Please contact us to receive the data in one of these formats. The database has too many rows to fit in a single Excel worksheet, but we can provide the data in Excel format, broken out by country, upon request. The Comprehensive Database can be downloaded in CSV or SQL (MySQL) format upon purchase. Check them out.Ĭan I get the Pro or Comprehensive Database in Excel or SQL server? We've published free formulas in popular programming languages. How do I calculate the distance between two cities? To get a sense of the expertise, check out some of the testimonials from our happy customers. Our data products have been used in production by well-regarded organizations such as The Guardian. Over this time, we've learned a lot about geographic data. We've been developing and selling interactive maps to Fortune 500 companies and prominent international organizations for over 11 years. This database was aggregated from authoritative sources and carefully processed by SimpleMaps. To learn more, read the full license terms. You can make copies of the database for internal and backup purposes. You are not allowed to publicly redistribute the database without prior permission. What am I allowed to do if I purchase the Comprehensive Database license?Ī license allows you to use the database internally or to query the database for public-facing applications that you or your organization owns or develops. We've spent countless hours: downloading, merging, cleaning, formatting, and aggregating this data into an accurate and concise product. Since most of this data is in the public-domain, what value are you adding? We simply use the determination of our primary source which is a U.S. How do you address border conflicts and territorial disputes? We've made a concerted effort to source our data from public domain and permissively-licensed sources that will not restrict the rights of our customers. Population density data comes from the Center for International Earth Science Information Network at Columbia University in partnership with NASA's Socioeconomic Data and Applications Center. Population data comes from various sources. countries comes from the National Geospatial-Intelligence Agency. Neighborhoods within listed cities are not included.Ĭities for all non-U.S. U.S Cities Database).Īny populated place in the world as determined by U.S. We make every effort to keep it consistent across releases and databases (e.g. Many users choose to drop these relatively unimportant places with conflicting names.Ī 10-digit unique id generated by SimpleMaps. TRUE if the place has the same exact name as a more important place in the same country, and admin_name. America/Los_Angeles)Īn integer from 1-5 that captures the importance of a city (1 is most important, 5 least important). The city's timezone in the tz database format. We only count the municipal population that lies within the urban area so population_proper will always be smaller than or equal to population. Only available for some (prominent) cities. If the urban population is not available, the municipal population is used.Īn estimate of the city's municipal population. Derived from 2020 data.Īn estimate of the city's urban population. Fayetteville, AR)Īn estimate of the population per square kilometer at the lat/ lng. Washington D.C.)Īdmin - first-level admin capital (e.g. province, state, municipal district etc.)īlank string if not a capital, otherwise: Length varies by country.Ī description of the admin. The name of the highest level administration region of the city town (e.g. Left blank if ASCII representation is not possible.Īlternative city names, separated by a vertical bar (e.g. The name of the city/town as a Unicode string (e.g. For an exact representation, download this sample ( Excel, CSV) of France. Simple: A single CSV file, concise field names, only one entry per city.ĭue to space constraints, not all fields are shown.Includes latitude and longitude coordinates. Accurate: Cleaned and aggregated from official sources.Comprehensive: Over 4 million unique cities and towns from every country in the world.Up-to-date: It was last refreshed on March 31, 2023.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |