I have two shapefiles and i'm trying to do simple spatial analysis. When I want to know which polygon belongs to other polygon in other shapefile I always use select by location and in Spatial selection method i choose contain the source layer feature.
Now i have these two shapefiles in postgis and i'm trying to do the same using SQL Query but i got these results:
Select * from state where ST_Contains(geom, (select geom from region where REGION_N='CAPITAL_REGION')); =0 results, in ArcMap i got 1 result.
I also tried
When i tried
Where could be with SQL problem?
أكثر...
Now i have these two shapefiles in postgis and i'm trying to do the same using SQL Query but i got these results:
Select * from state where ST_Contains(geom, (select geom from region where REGION_N='CAPITAL_REGION')); =0 results, in ArcMap i got 1 result.
I also tried
ST_ContainsProperly
=0 results
When i tried
ST_Intersects
= 3 results, the same in ArcMap. So it looks like intersects works but "ST_Contains" doesn't work for some reason.
Where could be with SQL problem?
أكثر...