Where are the Cities, States, Counties, etc Found?
Our databases are delivered in text files that represent fully normalized relational database tables. Therefore the details of the Features (i.e. cities), States/Provinces, Counties/Districts, Countries, and Timezones are found in separate tables. * Feature.txt = List of cities, with the feature_int_id the main key. * Country.txt = List of countries where country_str_code is the foreign key back to Feature to get the country name from this table. * Admin1.txt = List of States/Provinces where admin1_str_code is the foreign key back to Feature to get the State name from this table. * Admin2.txt = List of Counties/Districts where admin2_str_code is the foreign key back to Feature to get the County name from this table. * Timezone.txt = List of Timezones where timezone_int_id is the foreign key back to Feature to get the Timezeone information from this table. You can view the Entity Relationship of our tables for more information.
