[postgis-devel] [PostGIS] #318: 900913->4326 Transform

[PostGIS]

#318: 900913->4326 Transform
----------------------+-----------------------------------------------------
  Reporter:  pramsey  |       Owner:  mcayland     
      Type:  defect   |      Status:  new          
  Priority:  medium   |   Milestone:  PostGIS 1.4.2
 Component:  postgis  |     Version:  trunk        
Resolution:           |    Keywords:               
----------------------+-----------------------------------------------------
Comment (by mcayland):

 Unfortunately this still works for me:


 trunk=# select ST_AsGeoJSON(
 ST_TransForm(ST_setSRID(St_Box2D(ST_Transform(ST_SetSRID(ST_MakePoint(6.95,50.9333333),4326),900913))::box2d,900913),4326),6
 );
                                                        st_asgeojson
 ---------------------------------------------------------------------------------------------------------------------------
 {"type":"Polygon","coordinates":[[[6.95,50.933333],[6.95,50.933335],[6.95,50.933335],[6.95,50.933333],[6.95,50.933333]]]}
 (1 row)

 trunk=# select * from spatial_ref_sys where srid = 900913;
   srid  |       auth_name        | auth_srid |
 srtext
 |                                                    proj4text
 --------+------------------------+-----------+---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------------------------------------------------------
  900913 | spatialreferencing.org |    900913 | 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]]
 | +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
 (1 row)

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/318#comment:19>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.