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.
Open Data Stack Exchange is a question and answer site for developers and researchers interested in open data. It only takes a minute to sign up.
Sign up to join this communityI 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.
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.
The Basic (free) database will meet many users' needs. You may want to purchase the Pro or Comprehensive versions if:
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.
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.