3

I am looking for a list of all US cities and their latitude and longitude.

Ideally something free will work but I'm willing to pay for it if its not too expensive and its complete.

3

United States Cities Database

A simple, accurate, and up-to-date database of United States cities and towns, built from the ground up using authoritative sources such as the U.S. Geological Survey and U.S. Census Bureau.

  • Up-to-date: Data updated as of November 18, 2020.
  • Comprehensive: Over 108,000 cities and towns from all 50 states, DC, Puerto Rico, and the US Virgin Islands.
  • Useful fields: From latitude and longitude to household income.
  • Accurate: Aggregated and cleaned from official sources.
  • Simple: A single CSV file, concise field names, only one entry per city/town.

The Basic (free) database will meet many users' needs. You may want to purchase the Pro or Comprehensive versions if:

  • You need data for rural towns/villages or places that aren't incorporated municipalities.
  • You need demographic data such as age, race, education, or income.
  • You don't want to (or can't) attribute your use of our data on a public-facing website.

Download Here


the US Cities Database The SQL file and a CSV have 29,880 registered cities. All cities are located in the United States.

The SQL file contains two tables:

  • US_STATES: ID, STATE_CODE, and STATE_NAME.

  • US_CITIES: ID, ID_STATE, CITY, COUNTY, LATITUDE, and LONGITUDE.

The US_CITIES table has all (or almost all) cities from the United States.


3

The U.S. Census Bureau is the authoritative government agency that has been tasked with managing national data about governments (state, local, and municipal) and the boundaries that they claim.

The latest data includes administrative boundaries for cities, towns, and CDP's (Census Designated Places). What is a CDP? Think of them as an area that is not a city/town nor is incorporated but is recognized as a distinct area for which to produce economic/social estimates.

If you're feeling adventurous and want to look through the boundaries shapefile joined with an abundance of demographic/social/economic estimates through their American Community Survey you might be able to delve into their Demographic Profile series in this directory.

2
  • It looks like your link is to Shape Files? Not sure how these can be used easily.
    – Kevin P.
    Aug 19 at 3:08
  • 1
    The shapefile contains metadata including two fields: INTPTLAT and INTPTLON. You can retrieve the list of Cities, Towns, and CDPs from this list.
    – Kotebiya
    Aug 19 at 16:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.