Sorry, the parameters did not get pasted SOURCE
> *FORMAT: * GML *DATASET:* /GISWorkspace/GML/2010-JUNE/RESULTS_OPENINGS_FCRESERVES.GML TARGET > *FORMAT: *PostgreSQL *DATASET:* PG:dbname='MyDatabase' user='MyUserName' password='MyPassword' *LAYER:* RESULTS_FORESTCOVER_RESERVES thank you. mars On Tue, Jun 29, 2010 at 9:47 PM, Mars Sjoden <aurorageomat...@gmail.com>wrote: > 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 Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user