usefksa / saudi_gis_data Goto Github PK

looks good
but you didn't explain how to use the text location
I tried google maps but it didn't work as expected

Hi there!

I appreciate the work and effort a lot, But please upload sa_regions.sql again.
Every time I clone it, Seems its scrambled.

Thanks.

Hi @usefksa @daif

• I would like to convert the SQL Tables to one JSON file.
• Add English translation for each one.
• I think there is an issue with sa_regions.sql I can't preview it on github.

Let me know if you are interested.
Then I will start to build it, and PR it.

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