Designing and building the database
Let's start our design of the DISTAL application by thinking about the various pieces of data it will require:
A list of all the countries. Each country needs to include a simple boundary map which can be displayed to the user.
Detailed shoreline and lake boundaries worldwide.
A list of all major cities and towns worldwide. For each city/town, we need to have the name of the city/town and a point representing the location of that town or city.
Fortunately, this data is readily available:
The list of countries and their outlines are included in the World Borders Dataset.
Shoreline and lake boundaries (as well as other land-water boundaries such as islands within lakes) are readily available using the GSHHS shoreline database.
City and town data can be found in two places: The GNIS Database (http://geonames.usgs.gov/domestic) provides official place-name data for the United States, while the GEOnet Names Server (http://earth-info.nga.mil/gns/html) provides similar...