I have a table that contains a column polygon shape. I need a query that I Want to pass a point(coordinates) if point contains in a polygon_shape of an instance the match will be returns .
select * from "DistrictAreas" where ST_Contains(polygon_shape, ST_GeomFromText('POINT(51.3525284 35.6960617)', 4326));
this is a error comes from postgresql
Reason: SQL Error [XX000]: ERROR: Operation on mixed SRID geometries
I find that this is the problem : org.jkiss.dbeaver.model.exec.DBCException: SQL Error: Error parsing SQL data:java.lang.IllegalArgumentException: Points of LinearRing do not form a closed linestring