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!
_______________________________________________ Qgis-user mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/qgis-user
