United States Zip Codes.org

Introduction

US ZIP codes are a type of postal code used within the United States to help the United States Postal Service (USPS) route mail more efficiently. ZIP codes near me are shown on the map above. Some still refer to ZIP codes as US postal codes. The term ZIP stands for Zone Improvement Plan. The basic 5-digit format was first introduced in 1963 and later extended to add an additional 4 digits after a dash to form a ZIP+4 code. The additional 4 digits help USPS more precisely group mail for delivery. Though ZIP codes were originally developed for USPS, many other shipping companies such as United Parcel Service (UPS), Federal Express (FedEx), DHL, and others make use of ZIP codes for sorting packages and calculating the time and cost of shipping a package (the shipping rate).

Data Source Characteristics

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_z_d (Load ZIP Code Database data into PostgreSQL)

Processing Steps:

  1. Download the zip_code_database.xls file from here.

  2. Load the csv files with the task l_z_d into the PostgreSQL database.

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

Configuration Parameter:

download_file_zip_codes_org = "data/United States Zip Codes.org/zip_code_database.xls"
download_file_zip_codes_org_url = "https://www.unitedstateszipcodes.org/zip-code-database/"

Contact Information