I have a spatial table with a geometry column geometry(MultiPolygonZ,4326).
We are trying to handle inserts and updates of geometries as GeoJSON from other systems of varying vintage. Everything is in reality 4326, but sometimes a geometry arrives that lacks the "crs" member, or the geometry might be XY instead of XYZ.
So those cases fail with either
- ERROR: Geometry SRID (0) does not match column SRID (4326)
- ERROR: Column has Z dimension but geometry does not.
I'd like to know if I can somehow set defaults on the geometry column for the SR (4326) and Z (0.0) to handle those cases.