[postgis-users] problems with transformation

[Stefan Zweig]

Hi regina,

well i can update. but i would like to avoid if i could, because our the company that maintains our postgis production servers wants to see some money for doing the update. but probably we are going to do that anyway, because it will be the easiest step to get my production doing the same like my testing.

thanks and best regards,
stefan

> -----Ursprüngliche Nachricht-----
> Von: "Obe, Regina" <robe.dnd at cityofboston.gov>
> Gesendet: 18.09.08 15:23:09
> An: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> Betreff: RE: [postgis-users] problems with transformation


> Not that I know of, but Frank would have a better idea.  I suppose you can't just upgrade your production to 4.6? 
> 
> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Stefan Zweig
> Sent: Thursday, September 18, 2008 8:41 AM
> To: PostGIS Users Discussion
> Subject: RE: [postgis-users] problems with transformation
> 
> Thank you regina!
> 
> the threads that you have attached show how i can get 4.6 working like 4.5 did. but actually i am quite happy with that what 4.6 does. so ist there a way to get 4.5 working like 4.6?
> 
> regards,
> stefan
> 
> > -----Ursprüngliche Nachricht-----
> > Von: "Obe, Regina" <robe.dnd at cityofboston.gov>
> > Gesendet: 18.09.08 14:38:10
> > An: "PostGIS Users Discussion" <postgis-users at postgis.refractions.net>
> > Betreff: RE: [postgis-users] problems with transformation
> 
> 
> > Check out these threads and Frank's responses.  I suspect its the same issue you are running into. 
> > 
> > http://postgis.refractions.net/pipermail/postgis-users/2008-January/018400.html
> > 
> > http://postgis.refractions.net/pipermail/postgis-users/2008-January/018412.html
> > 
> > Hope that helps,
> > Regina
> > 
> > -----Original Message-----
> > From: postgis-users-bounces at postgis.refractions.net [mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Stefan Zweig
> > Sent: Thursday, September 18, 2008 7:45 AM
> > To: postgis-users at postgis.refractions.net
> > Subject: [postgis-users] problems with transformation
> > 
> > hi list,
> > 
> > im a using two different installations of postgis. the first (1.) is for testing the second (2.) for working.
> > 
> > 
> > (1.)
> > select postgis_full_version()
> > "POSTGIS="1.3.3" GEOS="3.0.0-CAPI-1.4.1" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS"
> > 
> > (2.)
> > select postgis_full_version()
> > "POSTGIS="1.2.1" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.5.0, 22 Oct 2006" USE_STATS"
> > 
> > 
> > i am running the same query on both installations, getting different results:
> > 
> > (1.)
> > select st_y (transform(setsrid(makepoint(-626172.139189,7514065.62361),9805), 4326));
> > 55.7765729937296
> > 
> > (2.)
> > select st_y (transform(setsrid(makepoint(-626172.139189,7514065.62361),9805), 4326));
> > 55.9549116318344
> > 
> > the content for the srids 4326 and 9805 is equal on both installations:
> > 
> > (1.) + (2.)
> > select * from spatial_ref_sys where srid = 4326 or srid = 9805
> > 
> > srid;auth_name;auth_srid;srtext;proj4text
> > 4326;EPSG;4326;GEOGCS["WGS 84",DATUM["WGS_1984",SPHEROID["WGS84",6378137,298.257223563,AUTHORITY["EPSG","7030"]],TOWGS84[0,0,0,0,0,0,0],AUTHORITY["EPSG","6326"]],PRIMEM["Greenwich",0,AUTHORITY["EPSG","8901"]],UNIT["degree",0.01745329251994328,AUTHORITY["EPSG","9122"]],AUTHORITY["EPSG","4326"]];+proj=longlat +ellps=WGS84 +datum=WGS84 +no_defs
> > 9805;EPSG;9805; ;+proj=merc +lat_ts=0 +lon_0=0 +x_0=0 +y_0=0 +a=6378137 +b=6378137 +units=m +no_defs
> > 
> > 
> > actually i would suppose to get same results on both installations using transform() if the srid entries on both installations are equal. is there another point than the spatial_ref_sys table where the coordinate systems information can be set?
> > 
> > to me it seems like installation (1.) calculates the transformation using a spheroid and (2.) using the wgs84 ellipsoid.
> > 
> > 
> > any advices?
> > thanks in advance + regards. stefan
> > ________________________________________________________________________
> > Schon gehört? Bei WEB.DE gibt' s viele kostenlose Spiele:
> > http://games.entertainment.web.de/de/entertainment/games/free/index.html
> > 
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > -----------------------------------------
> > The substance of this message, including any attachments, may be
> > confidential, legally privileged and/or exempt from disclosure
> > pursuant to Massachusetts law. It is intended
> > solely for the addressee. If you received this in error, please
> > contact the sender and delete the material from any computer.
> > 
> > _______________________________________________
> > postgis-users mailing list
> > postgis-users at postgis.refractions.net
> > http://postgis.refractions.net/mailman/listinfo/postgis-users
> > 
> 
> 
> _____________________________________________________________________
> Der WEB.DE SmartSurfer hilft bis zu 70% Ihrer Onlinekosten zu sparen!
> http://smartsurfer.web.de/?mc=100071&distributionid=000000000066
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
> 


_________________________________________________________________________
In 5 Schritten zur eigenen Homepage. Jetzt Domain sichern und gestalten! 
Nur 3,99 EUR/Monat! http://www.maildomain.web.de/?mc=021114