Basically I have a polygon layer and I need to create a view which extracts about 100 different columns from about 10 tables with polygon, line and point geometry, that intersect with the said polygon.
The problem is that after creating the view, when I try to run it, I keep getting this unknown geometry type and it doesn't tell me where the error is located
ERROR: Unknown geometry type: 11 - MultiCurve
I've tried using
st_isvalid(r.geom) = true on every single table as a where condition because one of the layers definitely had some invalid geometries, but I keep running into this error.