needing a little help with a gdb and a standalone table

MikeHenson

I was given a gdb from a client containing a water system (lines, valves, meters, etc). Not a large one. I subsequently asked if there was any elevation data obtained when the data was field surveyed. He then sent me a standalone table titled "gpsPositions" Could have have someone look at these and tell me how to "join" them? Any help would be greatly appreciated.

MKH

XanderBakker

For the point featureclasses you can use the Spatial Join to join the elevation from the closest GPS point to the features. There are a lot of GPS points around the features, but the spatial join will only pass the data of the nearest feature. In this case I didn't much variation in the elevation, so that will probably not be an issue.

Add the table to the TOC, right click on the table and select Display XY data:

For the feature layer that is added enter the properties, activate the Fields tab and switch off all the fields that aren't relevant (this will avoid them to be joined to your features):

Just leave the one with the elevation switched on (I assume it is ProjectedZ). Next right click on the featureclasses you want to enrich with the elevation, and select Join and Relates..., and Join. Select Join data from another layer based on spatial location, select the XY events (GPS data), select each point will be given all the attributes..., specify the output and click OK.

A new featureclass will be created with the elevation added and a field with the distance between the features and the GPS point from which the elevation was joined.

For points this is easy, for lines you cannot do this. The GPS points are also to sparse to interpolate the elevation and create a surface (TIN). Although you could try and use that to convert the lines into 3D lines. Another possibility would be to interpolate the elevations between nodes with a GPS point close, but that would require some programming.