[Geoserver-users] Help with reprojection

[alex_barros]

I would appreciate any help with the following…

I have a postgres/postgis database that has a table with points using srid = 
2163. If I do: 

SELECT ST_AsEWKT(ST_Transform((select spatial_location from vw_maps where 
id=1),900913)); 

I get  "SRID=900913;POINT(-13672282.345767 5705158.43996816)", which is the 
right reprojection for my point. 

If I define a layer in GeoServer pointing to that same table (which means it 
will be assume 2163) and use OpenLayers (or uDig) to request a 900913 layer, 
that same point now comes back as -13672358.78089 573596.56157 Notice the shift 
on the second value… All my values are shifted up  ! 

I tried everything, even comparing the definitions of 900913 in Postgis, 
Geoserver and uDig, and they are all the same… 

PROJCS["WGS84 / Google Mercator",                
   GEOGCS["WGS 
84",                                
     DATUM["World Geodetic System 
1984",                                               
 
     SPHEROID["WGS 84", 6378137.0, 298.257223563, AUTHORITY["EPSG","7030"]],   
     
AUTHORITY["EPSG","6326"]],                               
 
   PRIMEM["Greenwich", 0.0, 
AUTHORITY["EPSG","8901"]],                               
 
   UNIT["degree", 
0.017453292519943295],                               
 
   AXIS["Longitude", 
EAST],                                
   AXIS["Latitude", 
NORTH],                                
   AUTHORITY["EPSG","4326"]],                
   PROJECTION["Mercator_1SP"],                
   PARAMETER["semi_minor", 6378137.0],                
   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","900913"]] 

Can someone give me a hint here? Thanks,Alex



------------------------------------------------------------------------------
Free Software Download: Index, Search & Analyze Logs and other IT data in 
Real-Time with Splunk. Collect, index and harness all the fast moving IT data 
generated by your applications, servers and devices whether physical, virtual
or in the cloud. Deliver compliance at lower cost and gain new business 
insights. http://p.sf.net/sfu/splunk-dev2dev 
_______________________________________________
Geoserver-users mailing list
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users