topic Re: How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile? in Coordinate Reference Systems Questions

How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile?

ShannonGrumbly — Mon, 05 Dec 2016 14:42:17 GMT

I have a table of almost 700,000 records that I would like to plot as points. There is an X field and Y field stored as lat/long (e.g. 40.04746, -75.233316). However, all of my other data is in NAD 1983 State Plane Pennsylvania South FIPS 3702 Feet. I cannot get the table to plot correctly over my existing data. In fact, it plots somewhere in Ohio.

So far I have tried:

The 'Add XY Data' tool, using the Data Frame's State Plane coordinate system and inputing the X field for X and Y field for Y.
Importing the table into Arc and right-clicking 'Display XY Data', exporting as a shapefile, and using 'Define Projection' as NAD 1983 State Plane Pennsylvania South FIPS 3702 Feet. The tool was successful but did not change the coordinates or add any new fields for re-mapping.
Importing the table into Arc and right-clicking 'Display XY Data', exporting as a shapefile, and using 'Project' to change the output coordinate system to NAD 1983 State Plane Pennsylvania South FIPS 3702 Feet. This tool runs unsuccessfully, giving the error 'ERROR 999999: Error executing function: invalid extent for output coordinate system. Failed to execute (Project)'.

I'm not sure what else to try at this point, so any help would be greatly appreciated!

Thanks in advance!

Re: How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile?

NeilAyres — Mon, 05 Dec 2016 15:21:03 GMT

When you use the Add XY table tool or add the XY event layer to ArcMap, are you putting in the XYs / Lat/Longs in the correct way round?

for you (e.g. 40.04746, -75.233316), in NAm that first one is the Y (Lat), 40 deg N of the equator, and the second the X (Long), 75 deg west.

Re: How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile?

TimWitt2 — Mon, 05 Dec 2016 15:23:15 GMT

When trying to bring in the new data, are you working in the same MXD?

Re: How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile?

ShannonGrumbly — Mon, 05 Dec 2016 15:26:47 GMT

I may have been putting them in the wrong way, but I just imported it again using what you suggested and the points are still plotting in Cincinnati.

Re: How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile?

ShannonGrumbly — Mon, 05 Dec 2016 15:27:35 GMT

Yes, I have been in the same MXD, but I was importing from my Oracle Database Connection and saving shapefiles in the Default Geodatabase. Would that cause problems?

Re: How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile?

TimWitt2 — Mon, 05 Dec 2016 15:32:01 GMT

I would open a new MXD, bring in the new data and add the ESRI basemap to see if the points plot in the right location.

Then use the Project tool, to get it into NAD.

Project—Help | ArcGIS for Desktop

Re: How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile?

NeilAyres — Mon, 05 Dec 2016 15:33:59 GMT

Well, that coordinate you gave above seems to be in the correct place.

But if you are saving the "shapefile", you cant put one of those in the default geodatabase.

Just loose the ".shp" from the name and save it as a normal feature class.

Re: How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile?

ShannonGrumbly — Mon, 05 Dec 2016 16:13:24 GMT

I brought it in as the normal table, added the base map, and tried to use 'Display XY Data'. If I put X as longitude and Y as latitude, it plots next to Africa. If I put X as latitude and Y as longitude, same thing!! I can't believe it.

Re: How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile?

ShannonGrumbly — Mon, 05 Dec 2016 16:39:51 GMT

I looked into it further and when I search for (-75, 40) with the 'Go To XY' tool, it only plots correctly when set as 'Decimal Degrees'. It looks like WGS_1984 uses Decimal Degrees, so I set the coordinate system of the Data Frame (in a new MXD) to WGS_1984. Now when I try to right-click 'Display XY Data', the fields to select my latitude and longitude are empty.

Re: How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile?

JayantaPoddar — Mon, 05 Dec 2016 17:26:53 GMT

Since your coordinates' units are in Degree Decimal, Do Not use NAD 1983 State Plane Pennsylvania South FIPS 3702 Feet as the (defined) coordinate system. Instead, try using GCS_NAD_1983.

Then you could use PROJECT tool to reproject the coordinate system from GCS_NAD_1983 to NAD 1983 State Plane Pennsylvania South FIPS 3702 Feet.

Re: How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile?

BillChappell — Mon, 05 Dec 2016 17:27:43 GMT

Open a new MXD, Under View, Data Frame Properties put in 3702, now add data, the X,Y's, in the X,Y event dialog, the example you showed is (40.04746, -75.233316) is really Y, X, Lat is Y, Longitude is X, where it says set coordinate system, tell it what it is, (4326 -- wgs 84) not state plane. Once the data comes in you can export it out as a shapefile, with the option of using the dataframe (Stateplane S) or the layers (WGS84). pick dataframe and your shapefile will be in the right projection.

The key is defining the data for what it is not what you want it to be. If it starts off in the wrong place it will end up in the wrong place.

Re: How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile?

ShannonGrumbly — Mon, 05 Dec 2016 17:42:34 GMT

For some reason, all of my values were of 'String' type. I had to use Field Calculator to convert them to Float. This populated the fields in 'Display XY Data' tool.

Re: How to convert latitude/longitude Oracle database table to a State Plane coordinate system shapefile?

ShannonGrumbly — Mon, 05 Dec 2016 17:58:55 GMT

Thank you all for your input!! You are life savers!

The final solution was: open new MXD, set the Data Frame to WGS 1984, add the table, [export as geodatabase table if there is no OID], use the Field Calculator to convert string fields to float, Display XY Data using new float fields, and Project as NAD 1983 State Plane Pennsylvania South FIPS 3702 Feet.