Saudi_GIS_Data icon indicating copy to clipboard operation
Saudi_GIS_Data copied to clipboard

Polygons overlap

Open kalthwaini opened this issue 6 years ago • 1 comments

Great share @usefksa !

I have noticed some overlap on polygons (attached ids of those 612 cases), you can try:

SELECT t1.id, t2.id FROM sa_regions t1 INNER JOIN sa_regions t2 on ST_Intersects(t1.borders, t2.borders) and t1.id != t2.id

Also, I have investigated some of those, where is is not small (you can try this latlon: 24.760873, 46.750853 that gives two suburbs)

what would you suggest..

sa_regions_overlaps.xlsx

kalthwaini avatar Dec 07 '18 10:12 kalthwaini

Hello, I do not have any new GIS data. I only have this. I do not know with overlapping, for us, it is not a problem.

usefksa avatar Dec 10 '18 00:12 usefksa