On Jan 18, 2010, at 6:01 PM, Laurens Jansen wrote:
Laurens,
Do you have the ability to update on both plaforms PostGIS
version to 1.5.0 branch, and check again ?
Unix: <http://postgis.org/download/postgis-1.5.0b2.tar.gz>
Windows: <http://postgis.refractions.net/download/windows/experimental.php
>
As for upgrading our Unix platform it will take me some more time
cause i am working against one off the main test and developing
machines and i don't want to upgrade the PostGIS libraries on that
machine.
I've created a bug report #387 about this.
<http://trac.osgeo.org/postgis/ticket/387>
The Windows machine Ive updated the PostGIS to the 1.5 branch
SELECT postgis_full_version()
"POSTGIS="1.5.0SVN" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.6.1, 21
August 2008" LIBXML="2.7.6" USE_STATS"
Unfortunately i still get the same result set:
SELECT asKML(the_geom) FROM table WHERE gid = 1
"<MultiGeometry>
<Polygon>
<outerBoundaryIs>
<LinearRing>
<coordinates>
4.891594203993788,52.338389215425934,0
4.891546655317309,52.338416489781068,0
etc etc"
In the mean time the Windows 2008 PostgreSQL configuration with a
PostGIS 1.3 version does indeed give back a better result set and a
proper display of the KML-layers on the map; at least that gives us
some alternatives for our client who seems to insist on a Windows
hosting ....
As a workaround you could:
- Transform your data to EPSG:4326 with the ST_Transform function
on you Unix box
- Create a shapefile from there (pgsql2shp)
- Import the shapefile on the Win32 box (shp2pgsql with -s 4326 option)
- Use ST_AsKML as before (but in this case no need for the function to
reproject)
I will get back on the Unix PostGIS1.5 as soon as possible
Ok tks !
--
Olivier
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
