[postgis-users] Can psql copy gml into postgis?

[Bo Victor Thomsen]

First -

Thanks to Simon for an interesting angle on how to load gml data into 
PostGIS. Using Postgres xml operators combined with the Postgis 
ST_GeomFromGML() function is a new one for me :-)

However, the "standard" open source procedure for loading gml files into 
PostGIS would be to use the OGR2OGR command-line tool (and not psql) for 
this operation.  More information on OGR2OGR : 
https://gdal.org/programs/ogr2ogr.html and https://www.gisinternals.com/

More specific information on GML -> PostGIS using OGR2OGR: 
https://gis.stackexchange.com/questions/302944/using-ogr2ogr-to-convert-multiple-gml-files-to-a-postgis-table.

And Shao, I would kindly like to second Barend Köbben's suggestion, that 
you do some self study on the subjects of database schemas and PostGIS 
technology. There is a ton of information waiting for you just by using 
google search with the relevant search words. If you prefer your 
information in a book form, i can recommend "PostGIS in Action, 2. 
edition" for a primer in PostGIS and spatial databases. Available from 
Amazon. This book include information about both OGR2OGR and general SQL

-- 
Med venlig hilsen / Kind regards

Bo Victor Thomsen
GIS- and Database specialist
AestasGIS Denmark


Den 01-09-2019 kl. 09:13 skrev Simon (SPDBA) Greener:
> Yes.
>
> One method is to copy the gml into a table (column declared as text or 
> xml). Then use XML XQUERY  processing to shred the GML document into 
> nodes that ST_GeomFromGML() can consume.
>
> Simon
>
> 39 Cliff View Drive, Allens Rivulet, Tas 7150
> (H) 0362396397
> (M) 0418396391
> <http://www.spatialdbadvisor.com>www.spatialdbadvisor.com 
> <http://www.spatialdbadvisor.com> / 
> <http://www.spdba.com.au>www.spdba.com.au <http://www.spdba.com.au>
>
> Sent from BlueMail <http://www.bluemail.me/r?b=15487>
> On 1 Sep. 2019, at 16:57, Shaozhong SHI <shishaozhong at gmail.com 
> <mailto:shishaozhong at gmail.com>> wrote:
>
>     Hi, all,
>     Can psql copy gml into postgis?
>     Regards,
>     Shao
>
>     ------------------------------------------------------------------------
>
>     postgis-users mailing list
>     postgis-users at lists.osgeo.org
>     https://lists.osgeo.org/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> https://lists.osgeo.org/mailman/listinfo/postgis-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20190901/f05490cb/attachment.html>