Hi list,
I have a PostgreSql stored procedure which returns a geojson feature
collection created with json_build_object function. This web service
opens fine in OpenLayers, however, when I try to open it in QGIS, with
data source manager -> vector -> protocol -> geojson.
A similar REST service served with pg_featureserv, works well...
Here are tests realised with curl and ogrinfo for failing
postgrest service and working pg_featureserv services :
PostGrest
curl answer :
|StatusCode : 200 StatusDescription : OK Content : {123, 34, 116,
121...} RawContent : HTTP/1.1 200 OK Transfer-Encoding: chunked
Content-Range: 0-0/* Vary: Accept-Encoding Content-Type:
application/geo+json Date: Sun, 13 Feb 2022 07:35:55 GMT Server:
postgrest/9.0.0 {"type" : ... Headers : {[Transfer-Encoding, chunked],
[Content-Range, 0-0/*], [Vary, Accept-Encoding], [Content-Type,
application/geo+json]...} RawContentLength : 430979 |
ogrinfo answer :
|ERROR 1: HTTP error code : 404 ERROR 1: HTTP error code : 404 FAILURE:
Unable to open datasource `http://mydomain:3000/rpc/wod_geojson.json'
with the following drivers... |
pg_featureserv
curl answer :
|StatusCode : 200 StatusDescription : OK Content : {123, 34, 116,
121...} RawContent : HTTP/1.1 200 OK Transfer-Encoding: chunked
Content-Type: application/geo+json Date: Sun, 13 Feb 2022 07:33:51 GMT
{"type":"FeatureCollection","features":[{"type":"Feature","geometry":{"type":"Po...
Headers : {[Transfer-Encoding, chunked], [Content-Type,
application/geo+json], [Date, Sun, 13 Feb 2022 07:33:51 GMT]}
RawContentLength : 4474 |
ogrinfo answer :
|INFO: Open of
`http://mydomain:9000/functions/webmapod_mdarret/items.json' using
driver `GeoJSON' successful. 1: items (Point) |
What could explain that 404 error for posgrest geojson web service ?
Thanks for any hint,
--
Christophe Damour
_______________________________________________
gdal-dev mailing list
[email protected]
https://lists.osgeo.org/mailman/listinfo/gdal-dev
