othmanus/algeria-cities

The list of all Algerian provinces and cities according to the official division in different formats: csv, xlsx, php, json, etc.

algeria-cities's Issues

Grant me access to push there is an issue with your algeria_cities.sql

there is a problem with having a single quote it will not work with all SQL engines since you may have this case
'M'sila' which will cause the SQL engine to stop executing your script instead of it I did replace it with "" double quote

Code postaux incorrects

bonjour,
merci pour les effors frère, mais presque toutes les codes sont incorrects meme au niveau de wilaya d'alger :/ en effet je trouve que tu as pris les codes ONS et non pas postal.

Post Codes

hi
I can't find Post Codes ?
Thank's

Add Polygon points and shapes to draw wilayas on algeria map

it would be very helpful if you could add each wilaya polygon shape, so people can draw wilayas maps and have statistics on that, we might draw communes and other things later

Wilaya 32 - El Bayadh: Missing Cities

Background

I'm working on two major upgrades to the repository:

1. Add postal codes for all the cities and villages of Algeria
2. Update the list of Wilayas to 58

The expected result is to have:

1. 3961 Postal Codes as per the latest update (January 2021)
2. 1541 Cities (unchanged) as per the latest update (Mars 2021)

Issue

It got into my attention that I am missing 6 cities from the Wilaya 32 (El Bayadh). I got the list of the all the cities from the official website of the Interior Ministry of Algeria. When I double checked multiple sources, unfortunately, the official source is missing those 6 cities:

• Lbiodh Sidi Cheikh
• Ain El Orak
• Boussemghoun
• Sidi Ameur
• Sidi Slimane
• Tousmouline

In addition, the Dairas assigned to some cities from the Wilaya 32 - El Bayadh were wrong.

Resolution

Follow the same structure from the source ONIL: https://onil.dz/wp-content/uploads/2017/10/32EL-BAYADH.pdf

I need to use this in a blood donation app, am I permitted to

Hello, I could not find another way to contact you in order to ask for permission to use this in my Flutter Blood donation app,
can I ?
thanks in advance.

add gps coordinates for each commune

This allows users to show statistics on a map and it will help a lot.

Are commune_code right postal/zip codes?

Does municipality (commune) codes (commune_code) corresponding to real postal/zip codes?
If the "commune" codes which are in the repository are just identifiers for technical purposes, in this case it is better to rename the name of the column "commune_code" in "commune_id" to avoid confusion between technical identifier and commune code (zip code) .

Example 1 : for El Biar, the "commune" code (postal code / zip code) that can be found on the post office site is: 16003. And on the data of this repository we find 580.

Example 2 : For the "commune" Béjaia which is located in the Wilaya of Béjaia (the wilaya and the municipality have the same name. Ok.), The postal code is really 06000. But on this deposit, I find 187 as code_commune.

La liste des codes postaux

Bonjour,
La liste des codes postaux des localités sont incorrects.

I am making a Laravel package and I want to use this data set, I am allowed to ?

Single quotes in sql files are not escaped

Single quotes are not escaped in sql files, which results in errors when running the scripts.

For example: 'Hassi R'mel ' should be 'Hassi R''mel'

Tested on Postgres and oracle.

manque nom dairas -wilaya et daira- communes

Traduction en Arabe

Merci pour ces informations très utiles et pratiques. Mais en tant qu'arabe ne devrait-il pas avoir les noms en arabe? Je sais que c'est beaucoup de travail; mais comme c'est déjà fait en latin, l'arabe devrait être faisable aussi

Non Correspondance (nom commune <-> wilaya)

On sait bien que chaque nom de wilaya est un nom de comune (Sauf Alger et Alger Centre)
Alors la requetes

doit retourner Alger seulement
Mais quand on l'exécute comme ça, elle retoune aussi M'sila et Tamanrasset
car

• La wilaya est écrite "Tamanrasset" et la commune "Tamanghasset"
• La wilaya est écrite "M'sila" et la commune "Msila"

C'est deux (02) cas doit être unifiés (selon la nomonclature officielle)

Update wilayate

Time to update the provinces :-)

تقرر خلال إجتماع مجلس الوزراء اليوم الثلاثاء ترقية 10 ولايات منتدبة بالجنوب الكبير إلى ولايات جديدة و يتعلق الأمر بكل من ولايات: برج باجي مختار ، جانت ، عين صالح ، المنيعة ، عين قزام ،المغير ، تقرت ، بني عباس، تيميمون، اولاد جلال.

الصفحة 13 إلى 16 من الجريدة الرسمية
https://www.joradp.dz/FTP/jo-arabe/2019/A2019078.pdf

split cities and town

make special file for cities(wilaya) and anthor for town (Communes) for example : in sql add table for cites and oter for town

Count of dairas

there is 548 daira and not 546 as mentioned in the readme file

هل يمكن ايجاد الاحياء

هل يمكن ان اجد الاحياء اي التقسيمات في البلديات الكبيرة
+
zip
؟