How to provide a geojson from postgrest?

[npltr62]

Environment

• PostgreSQL version: kartoza/postgis:13
• PostgREST version: postgrest:v7.0.1
• Operating system:
  NAs synology

Description of issue

I would like to get a geojson with featurecollection
I try to set accept parameter like that 'Accept: "application/geo+json" but nothing works.

[steve-chavez]

Hey @npltr62,

I try to set accept parameter like that 'Accept: "application/geo+json" but nothing works.

Yeah, this feature is not yet merged: #1564

For now you can create a view for getting geojson, like:

create view shops_geojson as
select st_asgeojson(x) from shops x;

Then call it through PostgREST:

GET /shops_geojson


{"type": "Feature", 
 "geometry": {"type":"Point","coordinates":[-71.10044,42.373695]}, 
 "properties": {"id": 1, "address": "1369 Cambridge St"}
} 

Edit: For a feature collection

create view shops_geojson as
select json_build_object('type', 'FeatureCollection', 'features', json_agg(ST_AsGeoJSON(x)))  from shops x;

[npltr62]

ok thanks. and for getting feature collection?

[wolfgangwalther]

@steve-chavez ping. Any idea? I have no clue about postgis.

[steve-chavez]

Sorry, missed this one. I've edited my answer above, took the function from https://github.com/PostgREST/postgrest/pull/1564/files#diff-6600cf9df2241e8fc293e9d89997c585750e0405f235e3dfb282d0c2e8a44a02R88