simplemaps¶

Introduction¶

United States Cities Database¶

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

US Zip Codes Database¶

A simple, accurate and up-to-date database of US Zip Codes. It’s been built from the ground up using authoritative sources including the U.S. Postal Service™, U.S. Census Bureau, National Weather Service, American Community Survey, and the IRS.

Data Source Characteristics¶

Data files:
- uscities.xlsx
- uszips.xlsx
Format: xlsx
Size: about 7 MB
Update frequency: sporadic, but versioned
URLs:
- uscities.xlsx
- uszips.xlsx
Website hints: see
- United States Cities Database
- US Zip Codes Database

Data Target Characteristics¶

Database management system: PostgreSQL
Database name: io_avstats_db
Database table: io_lat_lng

Data Processing¶

Repository: io-avstats
Script: run_io_avstats_dev
Task: l_s_d (Load simplemaps data into PostgreSQL)

Processing Steps:¶

Download the uscities.xlsx file from here.
Download the uszips.xlsx file from here.
Load the csv files with the task l_s_d into the PostgreSQL database.

For detailed processing steps, refer to the external repository: io-avstats

Configuration Parameter:¶

download_file_simplemaps_us_cities = "data/simplemaps/uscities.xlsx"
download_file_simplemaps_us_cities_url = "https://simplemaps.com/data/us-cities"
download_file_simplemaps_us_zips = "data/simplemaps/uszips.xlsx"
download_file_simplemaps_us_zips_url = "https://simplemaps.com/data/us-zips"

Contact Information¶

Website: Contact Us