Support for over 100 cities

Geographical databases of cities

This Microsoft Access sample database provides tables containing information on the world's countries, cities and provinces. It is used to illustrate examples for a number of the articles on the About Databases site and also provides a good sample for students, professionals and others who are learning Microsoft Access.

Database Tables

The database contains three tables. The Country table contains the following fields:
  • Country Name: the name of the country
  • Capital: the name of the country's capital
  • Province: the province of the country's capital
  • Area: the total area of the country
  • Population: the total population of the country
The City table contains the following fields:
  • ID: a numeric identifier used as the table's primary key
  • City Name: the name of the city
  • Population: the population of the city
  • Longitude: the longitude of the city
  • Latitude: the latitude of the city
The Province table contains the following fields:
  • ProvinceName: the name of the province
  • Population: the population of the province
  • Area: the total area of the province
  • Capital: the capital of the province
  • CapProv: the name of the province where the capital exists. Due to unique circumstances in some areas, this field may differ from ProvinceName, although it is often the same.

Table Relationships

The table relationships described above are illustrated in the relational diagram shown on this page.

Downloading the Database

The database is available as a free download at this link: MONDIAL.accdb. The file is stored in Microsoft Access 2007 ACCDB format.

Acknowledgements

The data contained in this database is drawn from the MONDIAL project, with permission.
You might also like
Relational Database Management System Tutorial - 8
Relational Database Management System Tutorial - 8 ...
DiceTV: How to Become an Information Systems Auditor
DiceTV: How to Become an Information Systems Auditor
ArcGIS - Introduction to Geographic Information System
ArcGIS - Introduction to Geographic Information System ...

Datamining revealed? from craigslist bots

by XbLADErUnnerx

I work for a company who occasionally buys information from companies like info-usa. I write internal programs that basically organize this data and insert it into databases.
One thing I personally do is sell computer stuff over craigslist, and I use an exclusive inbox.com account for business that is used nowhere else. I've also never got spammer or spammer-like emails on this account that I responded to and completely block images and objects that can reveal anything via HTTP requests. Yet I've been seeing that email address pop up in acquisition data my company buys.

Springer GeoSpatial Semantics: Second International Conference, GeoS 2007, Mexico City, Mexico, November 29-30, 2007 (Lecture Notes in Computer Science / ... Applications, incl. Internet/Web, and HCI)
Book (Springer)
  • ISBN13: 9783540768753
  • Condition: New
  • Notes: 100% Satisfaction Guarantee. Tracking provided on most orders. Buy with Confidence! Millions of books sold!

Ligonier Borough complies with directional sign mandate  — Tribune-Review
Although Geographic Information Systems mapping of the borough pinpoints all directional signs, it does not include all data needed to comply with the program. “They want to see off-sets, heights, directions, locations, all kinds of stuff,” Faas said.

Springer Geographic Information Science: 5th International Conference, GIScience 2008, Park City, UT, USA, September 23-26, 2008, Proceedings (Lecture Notes in ... Applications, incl. Internet/Web, and HCI)
Book (Springer)
Springer Geographical Information and Planning: European Perspectives (Advances in Spatial Science)
Book (Springer)
  • Used Book in Good Condition
Springer Moving Objects Management: Models, Techniques and Applications
Book (Springer)
Springer Time-integrative Geographic Information Systems - Management and Analysis of Spatio-Temporal Data
Book (Springer)

Popular Q&A

avatar
What is the largest geographic city?

The New York Metro area is the largest geographic city in the world. Thank you and !

avatar
What are the geographic coordinates of Vatican City?

41 54n, 12 27e

avatar
What city is at the geographical center of america?

The Geographical Center of North America is located in Rugby, North Dakota. Do the anytime, anywhere!

Related Posts