[Qgis-user] Using -> OGR Layer Converter <- For GML to PostGIS

[Mars Sjoden]

Hello,

I have been receiving public .gml files from the BC Ministry of Forests and
I quickly review them in QGIS.

I also wish to quickly add these .gml files to our PostGIS databases, and
noticed there is a GUI front end plugin "OGR Layer Converter".

I have tried the plugin a couple times using the following parameters:


I am able to import the GML file into PostGIS however the Column Table are
not exported over.

The newly created PostGIS layer "RESULTS_FORESTCOVER_RESERVES" will load the
spatial into QGIS correctly, lacking the Columns.


Any pointers would be greatly appreciated.

Also, here is an example excerpt of the GML that the BC MOF exports to me
incase this is a syntax issue parsing the GML

<?xml version="1.0" encoding="UTF-8"?>
>
> <FeatureCollection xmlns:gml="http://www.opengis.net/gml">
>
> <gml:featureMember>
>
> <FOREST_COVER_RESERVE fid="5">
>
> <OPENING_ID>1234567</OPENING_ID>
>
> <FOREST_FILE_ID>A9595959</FOREST_FILE_ID>
>
> <CUTTING_PERMIT_ID>886</CUTTING_PERMIT_ID>
>
> <CUT_BLOCK_ID>003</CUT_BLOCK_ID>
>
> <SILV_POLYGON_NO>A</SILV_POLYGON_NO>
>
> <SILV_POLYGON_AREA>7.7</SILV_POLYGON_AREA>
>
> <SILV_RESERVE_CODE>W</SILV_RESERVE_CODE>
>
> <SILV_RESERVE_OBJECTIVE_CODE>WTR</SILV_RESERVE_OBJECTIVE_CODE>
>
> <ENTRY_USERID>BCEID\USERID</ENTRY_USERID>
>
> <GEOMETRY.AREA>0</GEOMETRY.AREA>
>
> <GEOMETRY.LEN>0</GEOMETRY.LEN>
>
> <GEOMETRY>
>
> <gml:MultiPolygon>
>
> <gml:polygonMember>
>
> <gml:Polygon>
>
> <gml:outerBoundaryIs>
>
> <gml:LinearRing>
>
> <gml:coordinates>941509.249,1060062.342 941510.887,1060056.694
>> 941510.01</gml:coordinates>
>
> </gml:LinearRing>
>
> </gml:outerBoundaryIs>
>
> </gml:Polygon>
>
> </gml:polygonMember>
>
> </gml:MultiPolygon>
>
> </GEOMETRY>
>
> </FOREST_COVER_RESERVE>
>
> </gml:featureMember>
>
> </FeatureCollection>
>
>

Thank you!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20100629/4d193134/attachment.html>