I was given a csv file and told to convert it to a feature layer. The data is supposedly in State Plane coordinates, NAD 83, Florida North. When I plot this out in ArcMap it ends up being about 182 miles northwest of where it should be. What am I doing wrong? Here's my workflow: * Open blank mxd, go to File -> Add Data -> bring in csv file. * Then go to File->Add Data -> Add XY Data. Choose csv file, x field is Field 2, y field is Field 3, z field is field 4 * That gives me the event layer, which is 182 miles northwest of where it should be. I'm fairlly confident of the State Plane designation. Can anyone tell me where I'm going wrong? Thanks in advance! holleyTopo.csv.zip

nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Convert Northing and Easting Data to layer

ElizabethBrumfield

I was given a csv file and told to convert it to a feature layer. The data is supposedly in State Plane coordinates, NAD 83, Florida North. When I plot this out in ArcMap it ends up being about 182 miles northwest of where it should be. What am I doing wrong? Here's my workflow:

Open blank mxd, go to File -> Add Data -> bring in csv file.
Then go to File->Add Data -> Add XY Data. Choose csv file, x field is Field 2, y field is Field 3, z field is field 4
That gives me the event layer, which is 182 miles northwest of where it should be.

I'm fairlly confident of the State Plane designation. Can anyone tell me where I'm going wrong? Thanks in advance!

holleyTopo.csv.zip

Najděte více příspěvků označených jako

Accepted answers

JayantaPoddar

Switching the Lat./Lon. Columns might work.

I added a Header to the CSV, as follows.

The Spatial Reference remains NAD_1983_StatePlane_Florida_North_FIPS_0903_Feet.

X= Lon

Y= Lat

All comments

ElizabethBrumfield

Thanks to all who helped me, I really appreciate it. The data looks fine to me but I'm waiting for other dept's approval.

Thanks again!

DanPatterson_Retired

I suggested you check that earlier, but your northing is too big for an easting

ElizabethBrumfield

Interesting idea! So I have them backwards? I'll try again! Thanks so much-

JayantaPoddar

Switching the Lat./Lon. Columns might work.

I added a Header to the CSV, as follows.

The Spatial Reference remains NAD_1983_StatePlane_Florida_North_FIPS_0903_Feet.

X= Lon

Y= Lat

ElizabethBrumfield

I set the X column to be field 2 and the Y column was field 3 (also I was told the elevation was in field 4 so for a couple of attempts I used that and then discarded it). According to google, I'm about 3386 km from the equator. Should I be confident in using State Plane (ft)?

DanPatterson_Retired

well going in the wrong direction might be progress..or not

here is your first row

40, 538974.187, 1222865.747, 96.86, scr

now the 2nd column looks like some easting (ie X )

the 3rd column looks like some type of northing, (ie Y)

so the question becomes, did you flip the X and Y values around?

or are these in feet or meters.

Are you about 1,222,900 meters from the equator (about 1,222 km-ish)

That will determine your confidence in the defined coordinate system

ElizabethBrumfield

Well that's a good point! So, I did the entire process again, then defined a projection using SP Fla North Meters - it was even further off....

DanPatterson_Retired

But are the units feet of meters? that you can't tell from a csv

Připojte se k diskusi

Přihlášení členové mohou přispívat, sledovat aktualizace a další. Jste tu noví? Zaregistrujte si bezplatný účet.

Rychlé odkazy

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.