Advertisement
Guest User

Untitled

a guest
Sep 20th, 2017
152
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.40 KB | None | 0 0
  1. postgis_test=# SELECT st_astext(ST_Transform('SRID=900914;POINT(111319.490793274 111325.142866385)'::geometry, 4326));
  2. st_astext
  3. ------------
  4. POINT(1 1)
  5. (1 row)
  6.  
  7. postgis_test=# SELECT st_astext(ST_Transform('SRID=900913;POINT(111319.490793274 111325.142866385)'::geometry, 4326));
  8. ERROR: transform: couldn't project point (111319 111325 0): failed to load NAD27-83 correction file (-38)
  9. HINT: PostGIS was unable to transform the point because either no grid shift files were found, or the point does not lie within the range for which the grid shift is defined. Refer to the ST_Transform() section of the PostGIS manual for details on how to configure PostGIS to alter this behaviour.
  10.  
  11.  
  12.  
  13. -[ RECORD 1 ]-
  14. srid | 900913
  15. auth_name | spatialreferencing.org
  16. auth_srid | 900913
  17. srtext | PROJCS["Popular Visualisation CRS / Mercator (deprecated)",GEOGCS["Popular Visualisation CRS",DATUM["Popular_Visualisation_Datum",SPHEROID["Popular Visualisation Sphere",6378137,0,AUTHORITY["EPSG","7059"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6055"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4055"]],UNIT["metre",1,AUTHORITY["EPSG","9001"]],PROJECTION["Mercator_1SP"],PARAMETER["central_meridian",0],PARAMETER["scale_factor",1],PARAMETER["false_easting",0],PARAMETER["false_northing",0],AUTHORITY["EPSG","3785"],AXIS["X",EAST],AXIS["Y",NORTH]]
  18. proj4text | +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +units=m +k=1.0 +nadgrids=@null +no_defs
  19.  
  20.  
  21. -[ RECORD 2 ]-
  22. srid | 900914
  23. auth_name | EPSG
  24. auth_srid | 900914
  25. srtext | GEOGCS["WGS 84", DATUM["World Geodetic System
  26. | 1984", SPHEROID["WGS 84", 6378137.0, 298.257223563,AUTHORITY["EPSG","7030"]], AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich", 0.0, AUTHORITY["EPSG","8901"]], NIT["degree",0.017453292519943295], AXIS["Longitude", EAST], AXIS["Latitude", NORTH],AUTHORITY["EPSG","4326"]], PROJECTION["Mercator_1SP"],PARAMETER["semi_minor", 6378137.0],
  27. | PARAMETER["latitude_of_origin",0.0], PARAMETER["central_meridian", 0.0], PARAMETER["scale_factor",1.0], PARAMETER["false_easting", 0.0], PARAMETER["false_northing", 0.0],UNIT["m", 1.0], AXIS["x", EAST], AXIS["y", NORTH],AUTHORITY["EPSG","900914"]] |
  28. proj4text | +proj=merc +a=6378137 +b=6378137 +lat_ts=0.0 +lon_0=0.0 +x_0=0.0 +y_0=0 +k=1.0 +units=m
  29. | +nadgrids=@null +no_defs
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement