Re: help implementing OGR Postgres foreign data wrapper

Hi Brent,

not sure why, but it is working for me using ogrinfo:

~ $ ogrinfo
https://dservices3.arcgis.com/fp1tibNcN9mbExhG/arcgis/services/BOMEC_15_Class_WFS/WFSServer\?SERVICE\=WFS\&REQUEST\=GetCapabilities
INFO: Open of `
https://dservices3.arcgis.com/fp1tibNcN9mbExhG/arcgis/services/BOMEC_15_Class_WFS/WFSServer?SERVICE=WFS&REQUEST=GetCapabilities
'
using driver `WFS' successful.
Metadata:
ABSTRACT=To develop a marine environment classification for waters in
depths shallower than 3000 m within the outer boundary of the NZ 200 naut.
mile EEZ (an OGC WFS Layer).
TITLE=WFS
1: BOMEC_15_Class_WFS:BOMEC_15_Class (title: BOMEC_15_Class) (Multi Surface)

not very helpful, but a 400 error might be some kind of encoding problem
with request?

cheers

Ben

On Tue, 5 Oct 2021 at 14:18, Brent Wood <Brent(dot)Wood(at)niwa(dot)co(dot)nz> wrote:

> 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:
>
> https://dservices3.arcgis.com/fp1tibNcN9mbExhG/arcgis/services/BOMEC_15_Class_WFS/WFSServer
>
> 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
> 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
> <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
> <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
> <https://www.niwa.co.nz>
> 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 <https://www.niwa.co.nz> Facebook
> <https://www.facebook.com/nzniwa> LinkedIn
> <https://www.linkedin.com/company/niwa> Twitter
> <https://twitter.com/niwa_nz> Instagram
> <https://www.instagram.com/niwa_science> 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
>

--

[image: Ausvet Logo] <https://www.ausvet.com.au/>

Dr Ben Madin

BVMS MVPHMgmt PhD MANZCVS GAICD
Managing Director
Mobile:
+61 448 887 220 <+61448887220>
E-mail:
ben(at)ausvet(dot)com(dot)au
Website:
www.ausvet.com.au
Skype: benmadin
Address:
5 Shuffrey Street
Fremantle, WA 6160
Australia