Layer's don't match / Wrong Projection?

AnjaWietholter · ‎05-19-2010

I have a table with geocoded Lat/Long Values that I want to add as point features to my map. However when I add the table and add X/Y data (Tools-Add X/Y data) the data is added to the map but the projection doesn't match up. I did compare the coordinate systems and they appear to be the same whoever the extent doesn't match up.

My Shapefile with the Lat/Long Points has similar values in projected coordinates compared to the decimal degrees which leads me to believe it doesn't project?

Here is an example. My Zip Code layer in decimal degrees:
West: -117.597982
East: -116.080157
North: 33.511553
South: 32.530161

In projected or local coordinates:
Left: 6150765.000000
Right: 6613436.500000
Top: 2129760.000000
Bottom: 1775304.125000
NAD_1983_StatePlane_California_VI_FIPS_0406_Feet

And my XY layer that doesn't match:

Decimal:
West: -136.179977
East: -136.179964
North: 25.945595
South: 25.945576

In projected or local coordinates:
Left: -117.388904
Right: -116.371055
Top: 34.517990
Bottom: 32.543795

NAD_1983_StatePlane_California_VI_FIPS_0406 also

I tried about everything. If somebody could help me with this it would be GREATLY appreciated.

PearlDaniel · ‎09-27-2011

Hi,

The point shapefile has two problems with it that I can see. Given this extent:

Top: 35.984250 m
Bottom: 34.367333 m
Left: 90.817589 m
Right: 93.998444 m

The coordinate system should be NAD 1983 (geographic coordinate system), not a UTM zone. Once the data is defined correctly, you can use the Project Tool to convert to NAD 1983 UTM 15N. But before you can do any of this, the longitude values need to be made negative. ArcGIS expects that longitude values in the western hemisphere will be negative.

Melita

Doh. I changed the longitude to negative, then defined the coordinate system as NAD 1983 in ArcCatalog. Then the points displayed correctly! What a relief to have this issue resolved. I was overlooking the positive longitude and would probably have never spotted that. Thank you very much!!

HelenJenkins · ‎10-18-2011

Hi, I have a similar problem with layers not matching. I have a shapefile and a file which simply contains a list of latitudes and longitudes providing points and I want to plot the points over the shapefile map. The details of the projections are the same for each one:
Projected Coordinate System: MOLDREF 99 TMM 2824
Projection: Transverse_Mercator
False_Easting: 200000.00000000
False_Northing: -5000000.00000000
Central_Meridian: 28.40000000
Scale_Factor: 0.99994000
Latitude_Of_Origin: 0.00000000
Linear Unit: Meter

Geographic Coordinate System: MOLDREF 99
Datum: D_GRS_1980
Prime Meridian: Greenwich
Angular Unit: Degree

But the "extent" is different (and it may be wrong for at least one).
For the points, the extent is
Top: 48.467222m
Bottom: 45.544444m
Left: 26.803889m
Right: 30.042500m

(Although these look to me like the boundaries of the lat and long coordinates)

For the shapefile, the extent is:
Top: 372942.186016 m
Bottom: 36636.565397 m
Left: 67754.832657 m
Right: 335481.716789 m

Any thoughts on how I can fix this?

Thank you!
Helen

MelitaKennedy · ‎10-18-2011

Helen,

You're so close! The shapefile's extents exactly fit the projected coordinate system definition so as long as it's assigned the MOLDREF99 definition, it's fine. The file with lat/lon coordinates needs to be defined with a geographic coordinate system--to match the values. The coordinate system definition must always match what the coordinates currently are using. Once that's set, then ArcMap can project the values on-the-fly to a different coordinate system, or you can use the Project Tool to create a copy in a different coordinate system.

Melita

MikeZaske · ‎10-19-2011

Hi, I am also having similar issues with getting an imported excel spreadsheet to align with my existing data set. After creating the shapefile, in Catalog I have selected and set the Geographic coordinate to NAD 83 as data is supposedly set to. When I add the data to my existing data set nothing shows up, I can not even zoom to layer to find it. I have tried various Geographic Coordinates and various projections. Other coordinates have the same results, nothing shows in the map unless it is the first data added. With projections the data does appear in my map but in the wrong locations, depending upon which projection is used depends on where the data appears.

Here is the info for my map data
Top: 728023.312475 ft
Bottom: 590417.499994
Left: 831501.000015
Right: 958965.124998

Projected Coordinate System: NAD_1983_HARN_StatePlane_Florida_East_FIPS_0901_Feet
Projection: Transverse_Mercator
False Easting: 656166.66666667
False Northing: 0.00000000
Central_Meridian: -81.00000000
Scale_Factor: 0.99994118
Latitude_Of_Origin: 24.33333333
Linear Unit: Foot_US

Here is the info for the imported point feature
Top: -80.114722 dd
Bottom: -80.183333 dd
Left: 25.985000 dd
Right: 26.063333 dd

Geographic Coordinate System: GCS_North_American_1983
Datum: D_North_American_1983
Prime Meridian: Greenwich
Angular Unit: Degree

I know I am probably overlooking something just not sure what at this point. Any assistance you can give would be greatly appreciated.
Mike

DianeMcConnaughey · ‎10-21-2011

Check the Excel spreadsheet in Excel for bogus or out of range values. Put filters or sort the XY columns. If there are too many values, you might try searching for values < or > valid range. Null values might also cause problems. If you do find out of range or null values, filter them, and save filtered values to a new worksheet, save the out of range or suspicious values to a different worksheet. You reference StatePlane, but the coordinates seem to be in Antarica Top: -80.114722 dd Bottom: -80.183333 dd Left: 25.985000 dd Right: 26.063333 dd

MelitaKennedy · ‎10-21-2011

Diana has the answer. When you import the point data, switch the columns that you're using for 'x' and 'y'. The -80 values are longitude and correspond to 'x' (easting) while the +25 values are latitude and correspond to 'y' (northing).

Melita

AnneBarth · ‎12-06-2011

Hi, I think I have a similiar problem to these posted problems here.
The Data Frame of my ArcMap Document has the Coordinate System UTM Adindan 37N, due to the fact that the initial shapefiles of teh area were set to this Coordiante System. I wanted to add some GPS points. The GPS was set to WGS 1984. I add the GPS points as an excel file (and calculated them into Decimal Degrees) and used the button addxy data. I turned the Coordinate System of the Input Coordinates to WGS 1984. The points appear, and they are broadly in the right area, but there are not correct. They are also not shifted to one sight, but seem to be distributed totally wrong.

I made a screenshot, the green points are where the points should be located, and the brown points are the points which I got.

I hope, sombody can help me with this. Thanks in advance!

MelitaKennedy · ‎12-06-2011

Hi Anne,

First, try setting a transformation to convert between Adindan and WGS84. There are several possibilities. If the data's in Ethiopia, try Adindan_To_WGS_1984_4. You're correct that the transformation will likely move most of the points into the area of interest, but not all of them. Perhaps check the original values again to confirm that the conversion to decimal degrees worked correctly? Were the original values in degrees-minutes or degrees-minutes-seconds?

Melita

AnneBarth · ‎12-09-2011

Hi Melita,
thank you for your hint with the conversion to decimal degrees. In fact, the original data was in Degrees Decimal Minutes and not in Degrees, Minutes, Seconds. Now as I converted them again to Decimal Degrees, the points are very close to where they should be, but there are still about 150 m south-east of the real location. I tried the Conversion between Adindan and WGS 1984, but it seems to be no difference.
Thank you for your help
Anne

Pier_PaoloComida · ‎09-17-2012

Hello, I seems to have a similar problem as listed above.
When I try to open a shapefile made of a series of waypoints (called "map31") on arcmap this error window appears and waypoints don't match up with the map and others waypoints (called "waypoints") took in the same area but with a different tool.

So I opened arc catalog and then I checked the spatial attributes founding some strong differences between Map31 (wrong) and waypoints (correct) as listed below:

Map31 Shapefile metadata spatial data:

Horizontal coordinate system
Projected coordinate system name: PSAD_1956_UTM_Zone_17S
Geographic coordinate system name: GCS_Provisional_S_American_1956
Details
Grid Coordinate System Name: Universal Transverse Mercator
UTM Zone Number: -17
Transverse Mercator Projection
Scale Factor at Central Meridian: 0.999600
Longitude of Central Meridian: -81.000000
Latitude of Projection Origin: 0.000000
False Easting: 500000.000000
False Northing: 10000000.000000

Planar Coordinate Information
Planar Distance Units: meters
Coordinate Encoding Method: coordinate pair
Coordinate Representation
Abscissa Resolution: 0.000000
Ordinate Resolution: 0.000000

Geodetic Model
Horizontal Datum Name: D_Provisional_S_American_1956
Ellipsoid Name: International_1924
Semi-major Axis: 6378388.000000
Denominator of Flattening Ratio: 297.000000
_________________

Bounding coordinates
Horizontal
In decimal degrees
West: -78.274169
East: -78.185368
North: 0.466100
South: 0.411639
In projected or local coordinates
Left: -78.286671
Right: -78.191760
Top: 0.474426
Bottom: 0.413234
_________________

Lineage
ESRI geoprocessing history

1. Process
2. Process
3. Process

_________________

Spatial data description
Vector data information
ESRI description
Map31
ESRI feature type: Simple
Geometry type: Point
Topology: FALSE
Feature count: 80
Spatial Index: FALSE
Linear referencing: FALSE

-------------------------------------------------------------

Waypoints shapefile spatial metadata:

Horizontal coordinate system
Projected coordinate system name: PSAD_1956_UTM_Zone_17S
Geographic coordinate system name: GCS_Provisional_S_American_1956
Details
Grid Coordinate System Name: Universal Transverse Mercator
UTM Zone Number: -17
Transverse Mercator Projection
Scale Factor at Central Meridian: 0.999600
Longitude of Central Meridian: -81.000000
Latitude of Projection Origin: 0.000000
False Easting: 500000.000000
False Northing: 10000000.000000

Planar Coordinate Information
Planar Distance Units: meters
Coordinate Encoding Method: coordinate pair
Coordinate Representation
Abscissa Resolution: 0.000000
Ordinate Resolution: 0.000000

Geodetic Model
Horizontal Datum Name: D_Provisional_S_American_1956
Ellipsoid Name: International_1924
Semi-major Axis: 6378388.000000
Denominator of Flattening Ratio: 297.000000
_________________

Bounding coordinates
Horizontal
In decimal degrees
West: -78.274169
East: -78.185368
North: 0.466100
South: 0.411639
In projected or local coordinates
Left: 803436.152327
Right: 813326.941221
Top: 10051577.353089
Bottom: 10045554.316746
_________________

Spatial data description
Vector data information
ESRI description
waypoints
ESRI feature type: Simple
Geometry type: Point
Topology: FALSE
Feature count: 33
Spatial Index: FALSE
Linear referencing: FALSE

SDTS description
Feature class: SDTS feature type, feature count
waypoints: Entity point, 33

----------------------------------------------

Now, the first try I did was to apply the same sets of bounding coordinates from the correct file to the wrong one but I can find anywhere "In projected or local coordinates" tab to change the values. Now I don't know if what I do it's correct anyway an help should be very appreciated.

Please write the solution step by step because I'm not practical using arcgis.

Thank you very much in advance for all your help you will give to me

Pier Paolo