topic import csv geodata in Coordinate Reference Systems Questions

import csv geodata

PeterVersteeg — Thu, 08 Dec 2016 16:32:28 GMT

Hallo,

I have a file with locationas and i want to import that in arcgis for desktop 10.3.1.

the location are in this format:

-64.9734423 46.8886667 0, -64.975073 46.9527568 0,

What format is this? and what coordinate system do i need to use if i import this true create feature class true xy table.

Thank you

Re: import csv geodata

JayantaPoddar — Thu, 08 Dec 2016 16:48:54 GMT

Does the first row have any text (ColumnName) in it?

Looks like XYZ values in CSV file.

You could try Adding x,y coordinate data as a layer.

Spatial Reference preferably GCS_WGS1984.

Re: import csv geodata

AdamZiegler1 — Thu, 08 Dec 2016 17:00:11 GMT

Hi Peter - I would reformat your file first. Looks like the X Y Z coordinates are separated by a comma in a run on string. I would use Notepad ++ to replace the comma and space after it with a carriage return, then replace all the spaces with commas. Then you'd have rows of properly separated coordinates. The coordinates appear to be WGS 84.

In Notepad++

Open the CSV file
Hit Cntrl H to open replace
In the Search mode click on the Extended radial button
Find: , (comma and a space)
Replace with: \r
Then Find: <space>
Replace with: ,

This worked for me. I had to open the CSV in Excel and save it to a new file so that ArcMap would recognize the new format. In ArcMap, add data, add XY data. Field 1 is X, Field 2 is Y, Field 3 is Z. The points drew in Nova Scotia near a Canadian National Park.

-Adam Z

Re: import csv geodata

PeterVersteeg — Thu, 08 Dec 2016 17:04:04 GMT

I seems I did not set the Y field earlier. Thank you for the info