I'm trying to load an Environment Agency GML file into Postgres/PostGIS using ogr2ogr. The file loads fine, all the other data is there, but when I check the table in the database there is no geometry column. As it is a polygon dataset this is a problem!
ogr2ogr command is:
ogr2ogr -f "PostgreSQL" PG:"host=* port=* dbname=* user=* password=*" RoFRS_v201701.gml -overwrite -progress --config PG_USE_COPY YES
The GML file has a XSD file with it.
Also the GML opens perfectly in QGIS, with polygons displayed as they should be.
Any suggestions for getting the geom into Postgres?
Results from ogrinfo:
Geometry: Polygon Feature Count: 2130752 Extent: (134111.801000, 11510.471300) - (655988.124900, 657600.687500) Layer SRS WKT: (unknown) OBJECTID: Integer (0.0) PROB_4BAND: String (8.0) SUITABILITY: String (25.0) PUB_DATE: Integer (0.0) RISK_FOR_INSURANCE_SOP: String (3.0) SHAPE_Length: Real (0.0) SHAPE_Area: Real (0.0)