Re: [Geoserver-users] Transformation through PostGIS

2011-09-13 Thread Andrea Aime
On Tue, Sep 13, 2011 at 3:34 PM, Rahkonen Jukka wrote: > ** > Good suggestion, especially as EPSG:3857. > Oooops, typo! :) Thanks for fixing it Cheers Andrea -- --- Ing. Andrea Aime GeoSolutions S.A.S. Tech lead Via Poggio alle Viti 1187 55

Re: [Geoserver-users] Transformation through PostGIS

2011-09-13 Thread Rahkonen Jukka
Aihe: Re: [Geoserver-users] Transformation through PostGIS On Tue, Sep 13, 2011 at 3:09 PM, Rahkonen Jukka mailto:jukka.rahko...@mmmtike.fi>> wrote: Hi, I would try how a view containing SELECT Transform(geom,900913) as geom would behave. I'd also suggest to let go of 900913, not al

Re: [Geoserver-users] Transformation through PostGIS

2011-09-13 Thread Andrea Aime
On Tue, Sep 13, 2011 at 3:09 PM, Rahkonen Jukka wrote: > ** > Hi, > > I would try how a view containing SELECT Transform(geom,900913) as geom > would behave. > I'd also suggest to let go of 900913, not all GIS treat it the same way, and use EPSG:3957 instead, which is the official EPSG code for t

Re: [Geoserver-users] Transformation through PostGIS

2011-09-13 Thread Rahkonen Jukka
Hi, I would try how a view containing SELECT Transform(geom,900913) as geom would behave. -Jukka Rahkonen- Rengers Florian wrote: Hi, I have point geometries(WGS84) stored in PostGIS DB. I request this data transformed to Google Mercator (EPSG:900913). It seem

[Geoserver-users] Transformation through PostGIS

2011-09-13 Thread Rengers Florian
Hi, I have point geometries(WGS84) stored in PostGIS DB. I request this data transformed to Google Mercator (EPSG:900913). It seems that the transformation from 4236 to 900913 is done through Geoserver. Is it possible to configure Geoserver so that the transformation is done through PostGIS? Tan