WorldCityLocations

KO | EN

gitlite — search

#hacktoberfest #typescript #llm #deep-learning #linux #docker #java #awesome #cli #kubernetes #awesome-list #vue #ios #open-source

WorldCityLocations

(★ 157)

Geographical location (latitude, longitude, altitude) of all main cities of the world

파일 탐색기

최종 버전 다운로드 (.zip)

README.md
World_Cities_Location_table.csv
World_Cities_Location_table.sql
World_Cities_Location_table_MS-EXCEL.csv
World_Cities_Location_table_MS-EXCEL.xls

// repository documentation

Was this content helpful?

★ 0 (0 ratings)

World City Locations Database
===============================

Geographical location (latitude, longitude, altitude) of all main cities of the world. The data has been scrapped from [Aneki World Cities site] (http://www.aneki.com/cities.html)

The repository contains the location database in below formats:

- SQL
- CSV
- CSV for MS EXCEL, MS EXCEL 2000

All of them are exported from MySQL using phpMyAdmin.

The table has in 10,567 rows (means 10,567 unique cities, their locations and 170 countries).

Structure
----------
The table has 5 fields, `id`, `country`, `city`, `latitude`, `longitude`, `altitude`. From their name, I hope you can understand their significance.

Usage
---------

The sql file contains the schema to reproduce the location table in your designated database (assuming you are using mysql database engine. If you aren’t, you can easily convert the sql schema

### Getting all countries of the world (170 countries)

SELECT DISTINCT(country) FROM location
    
### Getting all cities of a country

SELECT city FROM location WHERE country = 'YOUR_COUNTRY_NAME_HERE'
  
### Getting the location of a specific city of a specific country
      
    SELECT latitude,longitude,altitude FROM location WHERE country='COUNTRY_NAME' AND city = 'CITY_NAME'

WorldCityLocations

파일 탐색기

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

WorldCityLocations

파일 탐색기

오늘의 추천 프로젝트

Was this content helpful?

Recent Feedback

Download README