[postgis-devel] [PostGIS] #387: ST_Transform decimal issue on Win32

PostGIS trac at osgeo.org
Mon Jan 18 11:10:29 PST 2010


#387: ST_Transform decimal issue on Win32
-----------------------+----------------------------------------------------
  Reporter:  colivier  |       Owner:  pramsey                   
      Type:  defect    |      Status:  new                       
  Priority:  medium    |   Milestone:                            
 Component:  postgis   |     Version:  trunk                     
Resolution:            |    Keywords:  ST_Transform Win32 decimal
-----------------------+----------------------------------------------------
Comment (by robe):

 Actually this may be more than a windows issue or I'm just being stupid.
 I get the same answers on my CentOS dev box when comparing my 1.3.6
 database with 1.4 install. Both in theory are sharing the same proj and
 same datum shift since I didn't recompile proj when compiling PostGIS 1.4
 for this particular install



 {{{
 SELECT
 ST_AsEWKT(ST_Transform(ST_GeomFromEWKT('SRID=28992;LINESTRING(121197.452
 483388.474 0 ,121194.232643364 483391.530431554 0)'),4326));

 -- PostgreSQL 8.4.1 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC)
 4.1.2 20071124 (Red Hat 4.1.2-42), 64-bit POSTGIS="1.4.1rc1" GEOS="3.2.
 0rc2-CAPI-1.6.0" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS"
 SRID=4326;LINESTRING(4.89159420399379 52.3383892154259 0,4.89154665531731
 52.3384164897811 0)

 -- PostgreSQL 8.4.1 on x86_64-redhat-linux-gnu, compiled by GCC gcc (GCC)
 4.1.2 20071124 (Red Hat 4.1.2-42), 64-bit POSTGIS="1.3.6" GEOS="3.2.0rc2-
 CAPI-1.6.0" PROJ="Rel. 4.6.0, 21 Dec 2007" USE_STATS
 SRID=4326;LINESTRING(4.8912328883848 52.3373804295345
 43.0455399099737,4.89118534688269 52.3374077007853 43.0454913368449)
 }}}


 So i really don't know which one is right at this point.  If its a mistake
 in teh dataum shift, then I must be doing the same thing wrong on my linux
 installs

-- 
Ticket URL: <http://trac.osgeo.org/postgis/ticket/387#comment:7>
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.


More information about the postgis-devel mailing list