[postgis-users] PostGIS and GML

[Silke Reimer]

On Wed, Feb 23, 2005 at 02:08:02PM +0100, TECHER Jean David wrote:
> Hi 
> 
> I tried to export PostGIS data to GML using (ogr2ogr with support for GML (only version 2.0 is supported from this tool))
> ad AsGML function from postgis...
> 
> example:
> 
> ogr2ogr -f GML building.gml PG:dbname=madatabase -sql "SELECT id,data,asgml(the_geom) FROM  buildings"
> 
> then do few replacements in buildings.gml using cat/sed (cut
> '<asgml' , '</asgml>' and son on..;)
> 
> This method is no very nice ...Did someone have a better idea to
> export from PostGIS => GML
> 
> or does exist tools for that???

I would still try to use ogr2ogr for your needs. With your ogr2ogr
command you are converting the data to gml twice: once by postgis
and again by ogr2ogr. Hence ogr does not recognize the geometry as
geometry data any more but only as a text field. If you don't use
the asgml-function any more it should work:

ogr2ogr -f GML building.gml PG:dbname=madatabase -sql "SELECT id,data,the_geom from buildings"

or even
ogr2ogr -f GML building.gml PG:dbname=madatabase -sql "SELECT * from buildings"

Many greetings,
	Silke


-- 
Intevation GmbH

Georgstrasse 4                    49074 Osnabrück, Germany
http://intevation.de              http://intevation.de/~silke
FreeGIS.org                       http://freegis.org/

-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20050223/afc63669/attachment.pgp>