Skip to content

Tanzania locations database (Regions -> Districts -> Wards -> Places)

License

Notifications You must be signed in to change notification settings

HackEAC/tanzania-locations-db

Repository files navigation

Tanzania Locations Repo

Quick Introduction

Tanzania locations, All Regions from Tanzania, with their respective Districts wards & streets.

Very useful for easily implementing Tanzania locations in any application.

How to use

What you need before running the code.

  1. Install & Start Postgresql Db Service

  2. Copy files from location-files to a top level directory /posts/... this is necessary for postgresql Copy command to function as expected refer to this question.

  3. Give user postgres ownership to /posts directory with

sudo chown -R postgres:postgres /posts

  1. Create your locations database owned by postgres user

createdb --encoding utf8 --owner postgres DATABASE_NAME

  1. Use psql DATABASE_NAME to enter into the database.

  2. Extract everything

  • Create Tables \i tables_creation.sql

  • Extract countries \i countries.sql

  • Copy regions information to general table with \i general.sql (Don't judge the repetition)

  • Extract all Tanzania locations \i extract.sql

  1. Done!

Room for improvements

  • Create custom IDs to reference tables in (Regions, Districts & Wards) Status: 🗓 🔥

  • This whole process can easily be automated. Status: 🤔

Current Ideas

Credits

Process of data standardization was the most complicated and I was helped by a few friends whom I promised to credit.

  1. Natali Isuja

  2. Joe Master

  3. Robert Mnama

About

Tanzania locations database (Regions -> Districts -> Wards -> Places)

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published