topic Re: Joining one attribute from one shp to another in ArcGIS Spatial Analyst Questions

Joining one attribute from one shp to another

mileslayne — Wed, 22 May 2013 15:12:57 GMT

I have two separate files, one is Manholes, and the other is Sewer Lines. I have a Field in the Manholes attribute table that i created called Seg_ID. Now All of my points (manholes) are snapped onto the sewer lines. Each sewer line is label SL_1, SL_2, SL_3 etc etc... How can i get the field in the manholes file to automatically say which sewer line each point is on in the Seg_ID field?

Thanks

Re: Joining one attribute from one shp to another

JeffreySwain — Thu, 23 May 2013 10:31:22 GMT

Have you tried a spatial join?

Re: Joining one attribute from one shp to another

mileslayne — Thu, 23 May 2013 12:58:04 GMT

I have tried a spatial join, i thought it worked, but what happens is that since my manholes are snapped to the sewer lines it messes things up. I found that if my manholes is snapped at an "T" intersection it makes three copies of the manhole, It says manhole 3 is on SL_54, SL_57,and SL_63 those are just examples. So it takes my 1375 manholes and Turns them into 1800+ manholes.

Re: Joining one attribute from one shp to another

NobbirAhmed — Thu, 23 May 2013 17:15:58 GMT

Could you please let us know what parameter values you are using? Especially, these ones:

Join Operation
Keep All Target Features (checked? unchecked?)
Match Option

When a manhole is snapped to a T-section then the manhole actually belongs to all of the three, no? In that case, how do you want to determine the sewer line it should belong to?

Re: Joining one attribute from one shp to another

mileslayne — Thu, 23 May 2013 18:33:09 GMT

Target features are manholes, join features are sewer line.
1 to many join operation. Check keep all target features. I don't care what line the manhole is on, the software can choose any one
it wants for all i care. I just don't need it to make triples every time a manhole is at an intersection

Re: Joining one attribute from one shp to another

NobbirAhmed — Thu, 23 May 2013 18:40:17 GMT

Most probably you are using INTERSECT option. Use CLOSEST match option instead - only 1 will be chosen as join feature.

Re: Joining one attribute from one shp to another

mileslayne — Thu, 23 May 2013 18:51:27 GMT

I am fairly sure that worked, thanks alot for the help!

Miles,