usefksa / saudi_gis_data

Database for Saudi cities and districts with location information 'GIS Data'

Saudi_GIS_Data

قائمة باسماء المدن و الاحياء السعودية مع معلومات حدود الاحياء الجغرافية.

for more info @usef_ksa on Twitter

mysql -u root -p

CREATE DATABASE test;

use test;

source /path/sa_regions.sql

show tables;

select * from sa_regions limit 3;

Check this repo too: https://github.com/homaily/Saudi-Arabia-Regions-Cities-and-Districts

saudi_gis_data's Issues

Polygons overlap

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

location text in regions table

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

Convert the SQL Tables to JSON file

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.

sa_regions is scrambled!

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.