2

Ive updated my spatial_ref_sys table in postgres with spatial reference statement from http://spatialreference.org/ref/esri/102737/.

I can perform the tranformation from srid 4326 to srid 102737 and receive no errors...

INSERT into spatial_ref_sys (srid, auth_name, ...

SELECT id, name, ST_Transform(subs.geom, 102737) as geom
INTO subs4201

However the results when viewed on a map are displaced.

I can test this by using arcgis to reproject the data and the results overlay the wgs84 original locations....

enter image description here

How can I correct for this?

Edit: The displacement is approx. 1/2 mi.

Edit2: Adding ArcMap image as requested by @mkennedy

enter image description here

  • 1
    A half a mile is a lot. Maybe int'l feet versus US survey feet? Could the "102737" data have the wrong coordinate reference system attached? That is, 102737 use US survey feet, but maybe it's really using int'l feet? – mkennedy Feb 24 '17 at 19:38
  • 1
    Instead of "102737" can you try reprojecting to "2275?" – Mintx Feb 24 '17 at 19:50
  • @mkennedy I can confirm US Feet... +proj=lcc +lat_1=36.18333333333333 +lat_2=34.65 +lat_0=34 +lon_0=-101.5 +x_0=200000.0001016002 +y_0=999999.9998983998 +ellps=GRS80 +towgs84=0,0,0,0,0,0,0 +units=us-ft +no_defs – wtgeographer Feb 24 '17 at 20:44
  • I get the same shifted coordinates with 2275. I also tested with 3001 (NM East) and everytime same shifted coordinates? @Mintx – wtgeographer Feb 24 '17 at 20:47
  • 1
    Oops, I should have checked the code first. I mixed this Q up with the North Carolina one. I don't see anything obvious in the definition. Is there anyway you can post a test point results? The original coordinates in lat/lon, plus the results from ST_Transform and ArcGIS? – mkennedy Feb 24 '17 at 20:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.