Search Postgresql Archives

help implementing OGR Postgres foreign data wrapper

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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:

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
Brent Wood
Principal Technician - GIS and Spatial Data Management
Programme Leader - Environmental Information Delivery
+64-4-386-0529

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz Facebook LinkedIn Twitter Instagram
To ensure compliance with legal requirements and to maintain cyber security standards, NIWA's IT systems are subject to ongoing monitoring, activity logging and auditing. This monitoring and auditing service may be provided by third parties. Such third parties can access information transmitted to, processed by and stored on NIWA's IT systems

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux