[Question] Read WFS ?

[florentfougeres]

Hello everyone,

Is it possible to read a WFS stream directly with ST_READ?

I tried both of the above syntaxes without success.

SELECT * FROM ST_Read('WFS:https://url?service=WFS&version=1.1.0&request=GetFeature&typeName=my_layer');

SELECT * FROM ST_Read('WFS:https://url?', layer='my_layer');

Thank you in advance for your help.

[yharby]

@florentfougeres I think you can achive the same results using something like :

-- Enable Spatial and HTTPFS (install only once, load every session)
INSTALL spatial;
LOAD spatial;
INSTALL httpfs;
LOAD httpfs;

-- Query a WFS GeoJSON (Transport for Cairo)
SELECT 
    unnest(feature.properties) AS properties,
    ST_GeomFromGeoJSON(feature.geometry) AS geometry
FROM (
    SELECT unnest(features) AS feature
    FROM read_json_auto(
        'https://data.transportforcairo.com/geoserver/geonode/ows?'
        'service=WFS'
        '&version=1.1.0'
        '&request=GetFeature'
        '&typeName=geonode:cairo_od_stats'
        '&maxFeatures=26154'
        '&outputFormat=application/json'
    )
);

Ref: https://youssefharby.com/Snippets/DuckDB/3+-+Reading+WFS+GeoJSON+Service