topic Re: UTM coordinates - easting and northing do not fit when importing to ArcGIS in Coordinate Reference Systems Questions

UTM coordinates - easting and northing do not fit when importing to ArcGIS

LenaRiedel — Fri, 08 Jan 2016 09:07:42 GMT

Hi,

i have a simple question regarding the import of some coordinates via 'add XY data' to ArcGIS 10.3:

i have an excel file with UTM coordinates (easting and northing) of some points. I want to add it as a shapefile via the function add XY data, as i allways do.

But this time, i can't find any coordinate system, that covers the easting and northing values at the same time.

The points are in Lower Saxony, Germany. If i enter them in the internet (e.g. Online-Umrechner in nahezu alle Koordinatensysteme wie UTM, WGS, WGS84 und CH1903, Gauss-Krueger mit grosser Karte ) i find the place.

If i enter it to ArcGIS with the function add XY data, i allways get an error.

If i try e.g. the projected Coordinate System ETRS_1989_UTM_Zone_32N, the following error occurs:

One or more layers failed to draw:

sheet1$ Events: Syntaxfehler (fehlender Operator) in Abfrageausdruck

'Gewaesser Rechtswert ohne 32 >= 494225.671350 AND

Gewaesser Hochwert in UTM Koordinaten >= 6028859.486114 AND

Gewaesser Rechtswert ohne 32 <= 502301.705257 AND

Gewaesser Hochwert in UTM Koordinaten <= 6036832.306366'.

sheet1$ Events: An invalid SQL statement was used. [`sheet1$`]

Here are two examples of my coordinate pairs:

*Gewaesser Rechtswert*	*Gewaesser Rechtswert ohne 32 (easting)*	*Gewaesser Hochwert in UTM Koordinaten (northing)*
32 604678	604678	5781606
32 349458	349458	5939876

I understand that the coordinates are not in the interval of northing and easting within the error. But i don't have any idea anymore, which coordinate system would fit. I guess that it is simple and i am just doing a stupid mistake. I thought maybe one of you might have an idea?

I would be very happy about any kind of help or hints.

Thanks a lot in advance,

Lena

Re: UTM coordinates - easting and northing do not fit when importing to ArcGIS

XanderBakker — Fri, 08 Jan 2016 13:58:32 GMT

Strange, it does't throw an error in my case:

Did you try adding the Excel file and showing the XY events in a new session of ArcMap?

I attached the shapefile for you te revise.

Kind regards, Xander

Re: UTM coordinates - easting and northing do not fit when importing to ArcGIS

NeilAyres — Fri, 08 Jan 2016 16:43:45 GMT

What do you mean...

"If i try e.g. the projected Coordinate System ETRS_1989_UTM_Zone_32N"

The coordinates are either in this coordinate system or not. You need to know what the CRS of the input is...

I would recommend first importing the excel sheet into a gdb first. There maybe some fluff in the spreadsheet which is causing this error.

Re: UTM coordinates - easting and northing do not fit when importing to ArcGIS

DarrenWiens2 — Fri, 08 Jan 2016 17:45:39 GMT

'Gewaesser Rechtswert ohne 32 >= 494225.671350 AND
Gewaesser Hochwert in UTM Koordinaten >= 6028859.486114 AND
Gewaesser Rechtswert ohne 32 <= 502301.705257 AND
Gewaesser Hochwert in UTM Koordinaten <= 6036832.306366'.

Remove the spaces in your field names.

Re: UTM coordinates - easting and northing do not fit when importing to ArcGIS

LenaRiedel — Mon, 11 Jan 2016 14:51:15 GMT

Thank you very much for the answers and the solution guys, that was a big help!!

The error was really the space in the field name. i did not know that so far!

So it made also sence, that your table worked Xander, because you called the columns 'easting' and 'northing' and not as complicated as the original names. Top.

Thanks again and kind regards,

Lena