Null X, Y, Lat and Long fields in FDO linked shapefile

Anonymous — Thu, 22 Jun 2017 15:33:07 GMT

I am adding via Create-->Feature-->New Feature-->Point a Manhole and have these 4 areas of the Feature Properties are <Null>. Is my only option to cut and paste the values? Any way to automate this?

Troy A. Wilcox

Civil Designer

Re: Null X, Y, Lat and Long fields in FDO linked shapefile

Pointdump — Wed, 27 Dec 2017 23:14:57 GMT

Troy,

You probably long ago already solved this, but you could use Data Extraction, then a Table Join.

Dave

Re: Null X, Y, Lat and Long fields in FDO linked shapefile

parkr4st — Thu, 28 Dec 2017 01:31:03 GMT

X is this equal to longitude?

Y is this equal to latitude?

If so, then calculations in fields

X X(Geometry)

Y Y(Geometry)

workflow

set your GCS i.e. LL

new SDF file

set up with schema geometry type point; with data fields such as description, color, date, etc and save into the map See Example1

and add the two calculations for X & Y (Rename the files by removing the .txt so they are .sdf files)

export to a new sdf file see Example2. This becomes the working file to store the data. as you add each point the X & Y are calculated and added to the fields in the data row. fill in any of the other data fields i.e. hydrant, green, 12/27/2017, 1000 GPM, 100 Main Street

and MAPCHECKINALL

if you need the data as a .shp file mapimport and mapexport to the .shp file format making sure to carry the data to OD and back to the shp file.

The calculated columns do not carry the calculation into the .shp, just the data.

work up new data in the sdf file and use it to store data, send the shp off to those who need to work with the data. (You drive, they ride:) ) This is a crude sort of data protection. without the sdf the lat & long are not calculated

dave p

topic Re: Null X, Y, Lat and Long fields in FDO linked shapefile in AutoCAD Map 3D Forum

Null X, Y, Lat and Long fields in FDO linked shapefile

Re: Null X, Y, Lat and Long fields in FDO linked shapefile

Re: Null X, Y, Lat and Long fields in FDO linked shapefile