Support MULTISURFACE in postgis geojson

[wongcht]

Problem

For the geometry types that are not natively supported by GeoJSON (Point, LineString, Polygon, MultiPoint, MultiLineString, and MultiPolygon), error message returned on query:

lwgeom_to_geojson: 'MultiSurface' geometry type not supported

Solution

• option to convert the "unsupported" type to geojson
• option to return these unsupported type as WKT / GML / other formats

[steve-chavez]

lwgeom_to_geojson: 'MultiSurface' geometry type not supported

Can you elaborate on what would be the query for MultiSurface? We currently we use this query:

postgrest/src/PostgREST/Query/SqlFragment.hs

Lines 223 to 224 in f01d5bf

	asGeoJsonF :: SQL.Snippet
	asGeoJsonF = "json_build_object('type', 'FeatureCollection', 'features', coalesce(json_agg(ST_AsGeoJSON(_postgrest_t)::json), '[]'))"

Also note that you're able to override the geojson handler https://docs.postgrest.org/en/v13/references/api/media_type_handlers.html#overriding-a-builtin-handler