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?
Update:
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)
ogrinfo RoFRS_v201701.gml -al -so
shows?