Skip to content

A relational database and set of hierarchical json files for countries, cities and towns.

License

Notifications You must be signed in to change notification settings

CanburakTumer/Country-City-Town-DB

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Country-City-Town-DB

A relational database and set of hierarchical json files for countries, cities and towns.

This repository holds a collection of town list which is collected from internet, so there can be some missing towns in the list.

Let's have a look into the project structure

  • json_files
    • countries.json : list of countries
    • [COUNTRY_URL]
      • cities.json : list of cities in the [COUNTRY_NAME]
      • [CITY_NAME] : list of counties in the [CITY_NAME]
  • sqlite
    • locals.db : an SQLite database file which is modelled like in the ER diagram you can see below
  • images
    contains images used for this readme file.

ER Diagram

About

A relational database and set of hierarchical json files for countries, cities and towns.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published