I want to know if there's a way to check if a geometry of type Point is inside a geometry of type MultiPolygonZM, ignoring the Z coordinate, I just want to know if my Point(lat, lng) is inside a MultiPolygonZM.
This is an example of a MultiPolygonZM geometry in my database; I used ST_AsText to get a text representation of the geom :
"MULTIPOLYGON ZM ((( 570277.5312 3592073.8077 460.900200000004 -1.79769313486232e+308, 570262.0283 3592073.7806 460.712700000004 -1.79769313486232e+308, 570262.4922 3592086.4664 460.705199999997 -1.79769313486232e+308, 570278.0406 3592086.5792 460.697700000004 (...)"
ST_INTERSECTS like this :
SELECT * FROM CITIES WHERE ST_Intersects(ST_SetSRID(geom, 4326), ST_SetSRID(ST_MakePoint(3.67622580, 32.48549230), 4326)) SELECT * FROM CITIES WHERE ST_Contains(ST_SetSRID(geom, 4326), ST_SetSRID(ST_MakePoint(3.67622580, 32.48549230), 4326)).
My table uses 4326 as SRID, but i wanted to set it using ST_SetSRID to be sure that all the geoms have the same SRID
But it doesn't work! All the results are false!
Any solution ?