[postgis-users] GML > PostGIS

Martin Davis mbdavis at refractions.net
Wed Jan 7 12:00:58 PST 2009

Glad you found a solution, Peter.  Just out of interest, do you have any 
sample *GML documents* you can post?

I have to say, that schema looks pretty complicated.  Are you hoping to 
load the attribute values as well?  No doubt ogr can handle this - but I 
wouldn't call it a "simple exercise" to code that up!


Peter Brewer wrote:
> Martin,
> Thanks for the prompt reply.
> The schema is being developed and is open to suggestions.  At the 
> moment we are keeping it ultra simple and just specifying the 
> following element in the relevant locations:
> ....snip....
> <xs:element name="locationGeometry">
> <xs:complexType>
> <xs:choice>
> <xs:element ref="gml:Point"/>
> <xs:element ref="gml:Polygon"/>
> </xs:choice>
> </xs:complexType>
> </xs:element>
> ....snip....
> The full schema is at: http://tridas.org/1.0/tridas.xsd
> I know it would be pretty simple to parse gml:Point and gml:Polygon 
> myself, but I'd rather not reinvent the wheel.  Besides, I imagine 
> that in the future we'll extend the schema to support full SF-GML so I 
> was hoping someone would have already written a SF-GML>PostGIS converter.
> Best wishes
> Peter
> Martin Davis wrote:
>> Do you have a fixed schema?  Can you post an example GML document?
>> Peter Brewer wrote:
>>> Hi All,
>>> I'm writing a webservice that reads and writes (amongst other things)
>>> location data to/from a Postgres/PostGIS database.
>>> Outputting the data as GML from the database is easy using the asGML()
>>> PostGIS function.  What I'm pondering over is how to write data to the
>>> database when sent by the user in GML format.
>>> GDAL/OGR doesn't seem to allow GML > PostGIS conversion.  Any ideas how
>>> I can do this?  I'm restricting users to the 'Simple Features' 
>>> subset of
>>> GML so I only need to be able to write points, lines and polygons to 
>>> the
>>> database.  Am I really stuck with parsing the GML myself and writing
>>> PostGIS SQL statements?  It doesn't seem enormously difficult so I'm
>>> wondering why there isn't a library to do this already.
>>> Any help or pointers much appreciated
>>> Cheers
>>> Peter
>>> _______________________________________________
>>> 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

Martin Davis
Senior Technical Architect
Refractions Research, Inc.
(250) 383-3022

More information about the postgis-users mailing list