topic Re: Convert Northing and Easting Data to layer in Mapping Questions

Convert Northing and Easting Data to layer

ElizabethBrumfield — Wed, 20 Sep 2017 21:19:18 GMT

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!

Re: Convert Northing and Easting Data to layer

DanPatterson_Retired — Wed, 20 Sep 2017 21:22:18 GMT

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

Re: Convert Northing and Easting Data to layer

ElizabethBrumfield — Wed, 20 Sep 2017 21:33:01 GMT

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....

Re: Convert Northing and Easting Data to layer

DanPatterson_Retired — Wed, 20 Sep 2017 21:42:55 GMT

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

Re: Convert Northing and Easting Data to layer

ElizabethBrumfield — Wed, 20 Sep 2017 21:53:09 GMT

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)?

Re: Convert Northing and Easting Data to layer

DanPatterson_Retired — Wed, 20 Sep 2017 22:22:23 GMT

sounds about right (don't do feet often)... could be an issue with the zone then if it is that shifted

Hopefully someone in your area will chime in with the correct 'State Plane Whatever' designation. It is like UTM data, there are 120 positions on earth with the same easting and northing, making the numbers useless unless you know the utm zone and whether it is north or south of the equator.

Re: Convert Northing and Easting Data to layer

ElizabethBrumfield — Thu, 21 Sep 2017 00:11:27 GMT

Do you think the error is arising when I project it? Am I doing the actual add data and xy conversion correctly? No, I must not be because the event layer is off . Can I use calculate geometry to fix it?

Re: Convert Northing and Easting Data to layer

DanPatterson_Retired — Thu, 21 Sep 2017 00:17:59 GMT

The numbers are right for somewhere.. I don't understand how you got pairs of coordinates without a spatial reference for them. Did they come from a gps or something? is the csv the result of projecting some data and exporting it?.

Once you create the event layer, (in an empty dataframe... no basemap, nothing), then save it as featureclass/shapefile and immediately use the Define Projection tool in Arctoolbox, to 'tell it what it is' in terms of coordinates. Define the coordinate system of the dataframe using the same projection/coordinate system. If you then add a featureclass that you are absolutely sure about, regardless of its coordinate system, it will project to what you defined previously. If it was the correct definition, then stuff will line up. If not, then the coordinate system/projection was wrong.

I would find out what those numbers actually are. You could end up circling the barn for days to try to get everything lined up.

Re: Convert Northing and Easting Data to layer

JayantaPoddar — Thu, 21 Sep 2017 05:17:18 GMT

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

Re: Convert Northing and Easting Data to layer

ElizabethBrumfield — Thu, 21 Sep 2017 14:51:06 GMT

This data was given to me by our Engineering Dept - they have a worker who does survey GPS - I've never seen his unit or gotten data from him before. When I asked, all he could tell me was 'state plane'. I sort of took a guess that the rest of his settings would be similar to what other depts here use...hopefully!

Re: Convert Northing and Easting Data to layer

ElizabethBrumfield — Thu, 21 Sep 2017 14:51:37 GMT

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

Re: Convert Northing and Easting Data to layer

DanPatterson_Retired — Thu, 21 Sep 2017 14:58:43 GMT

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

Re: Convert Northing and Easting Data to layer

DanPatterson_Retired — Thu, 21 Sep 2017 15:31:25 GMT

you missed this from earlier

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

Re: Convert Northing and Easting Data to layer

ElizabethBrumfield — Fri, 22 Sep 2017 21:23:35 GMT

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!