help implementing OGR Postgres foreign data wrapper
Hi,
Apologies, this not strictly a Postgres question, but Postgres is so fundamental to what I'm trying to do and this list is generally so helpful, so here I go...
I'm using FDW's to create virtual tables providing access to data from external data sources. This is working well for data in other Postgres databases using the Postgres FDW.
I also want to be able to link to data from WFS services via the OGR FDW (https://www.pgxn.org/dist/ogr_fdw/)
The first service I'm trying to connect to is:
I can retrieve the capabilities doc in a browser (test 1 passed!) and plot the data as a layer in QGIS (test 2 passed). My next step is to test OGR access via ogrinfo. This I can't seem to get working. I'm assuming I need to sort this out before trying to get the OGR_FDW working.
I've tried:
ogrinfo https://dservices3.arcgis.com/fp1tibNcN9mbExhG/arcgis/services/BOMEC_15_Class_WFS/WFSServer?SERVICE=WFS&REQUEST=GetCapabilities
I can only get the following response
ogrinfo https://dservices3.arcgis.com/fp1tibNcN9mbExhG/arcgis/services/BOMEC_15_Class_WFS/WFSServer?SERVICE=WFS&REQUEST=GetCapabilities
[1] 3121502
ERROR 1: HTTP error code : 400
ERROR 1: HTTP error code : 400
FAILURE:
Unable to open datasource `https://dservices3.arcgis.com/fp1tibNcN9mbExhG/arcgis/services/BOMEC_15_Class_WFS/WFSServer?SERVICE=WFS' with the following drivers.
-> ESRIC...
-> OGR_PDS
-> WFS
-> OAPIF...
Can anyone suggest what might be the problem?
Thanks.
Brent Wood
Principal Technician, Fisheries
NIWA
DDI: +64 (4) 3860529
Principal Technician, Fisheries
NIWA
DDI: +64 (4) 3860529
 |
В списке pgsql-general по дате отправления: