Question

Converting Survey (Northing Easting) csv file into shp

  • 24 January 2014
  • 2 replies
  • 2 views

Hello,

 

 

I am wondering what coordinate system I should be using to convert a csv file of survey data to an ESRI shp file?

 

 

The data looks like this:

 

 

135 5580767 458060.914 562.143 GF

 

Columns 2,3,4 are Northing, Easting, Elevation.

 

 

Any suggestions would be much appreciated.

 

 

Cheers!

2 replies

Userlevel 4
Hi,

 

 

you should probably ask your csv file provider which coordinate system their data is in. While it is possible to guess, there is always a risk that data will be off, as there can be minute differences between different projections, etc. This is an error that is not always easy to detect, unfortunately.

 

 

To convert your numeric values into geometries for the shape file, use the 3DPointReplacer. Remember to specify the coordinate system on the writer.

 

 

You might have to get rid of the "GF" suffix on the elevation first, though. You can use the StringReplacer for that (replace with empty string).

 

 

David

Looks like that was all I needed.

 

 

Data was in NAD83, was able to do a nice convert and bring in the data.

 

 

I was thinking that it wasn't a 'regular' coordinate system, that it was maybe a northing/easting based upon a reference point or something.

 

 

Thanks!

Reply