**Please note: this product contains a sample of the NAD data. For access to the full dataset, please contact us at data@rearc.io**

## USDOT - National Address Database

This listing contains datasets related to the National Address Database provided by the US Department of Transportation (USDOT).

---

## What is the National Address Database?

The U.S. Department of Transportation (USDOT) and its partners from all levels of government recognize the need for a National Address Database (NAD). Accurate and up-to-date addresses are critical to transportation safety and are a vital part of Next Generation 9-1-1. They are also essential for a broad range of government services, including mail delivery, permitting, and school siting.

To meet this need, USDOT partners with address programs from state, local, and tribal governments to compile their authoritative data into the NAD. To date, the NAD contains data from 24 state government partners (with an additional 11 states in the queue), 17 local government partners, and 1 tribal government partner.

**USDOT National Address Database (NAD) Partner Participation by State (as of May 2021)**

Twenty eight (28) states have provided address data including: Alaska, Arizona, Arkansas, Colorado, Connecticut, Delaware, District of Columbia, Indiana, Iowa, Kansas, Maine, Maryland, Massachusetts, Montana, New Jersey, New Mexico, New York, North Carolina, Ohio, Oregon, Rhode Island, Tennessee, Texas, Utah, Vermont, Virginia, West Virginia, and Wisconsin.

**Disclaimer**

The National Address Database (NAD) is, with few exceptions, aggregated from state data, which is in turn aggregated from local data. While it is considered to be authoritative and every reasonable effort is made to ensure the accuracy and completeness of the data, the United States Department of Transportation (USDOT) makes no warranties, expressed or implied, concerning the accuracy, completeness or suitability of the data, and it should not be construed or used as a legal description.

[Read More](https://www.transportation.gov/gis/national-address-database/national-address-database-nad-disclaimer)

---

## Use Cases

#1 Inspect Zip Codes at a State Level

```

SELECT State, count(distinct(Zip_Code)) as num_of_zipcode

FROM national_addresses

GROUP BY State

ORDER BY num_of_zipcode DESC

```

| State | num_of_zipcode |

|-------|-------------------|

| NY | 1715 |

| TX | 1305 |

| OH | 1156 |

| IA | 1083 |

| TN | 1078 |

#2 Get Residential Addresses in a particular street and zip code

```

SELECT

INT(Add_Number) as Add_Number, StreetName, StN_PosTyp,

County, State, Zip_Code, Latitude, Longitude

FROM

national_addresses

WHERE

State='NY' AND

County = 'New York' AND

StreetName like 'Wall'

ORDER BY

Add_Number DESC

```

| Add_Number | StreetName | StN_PosTyp | County | State | Zip_Code | Latitude | Longitude |

|---------------|---------------|---------------|-------------|----------|-------------|-----------------------|------------------------|

| 120 | Wall | Street | New York | NY | 10005 | 40.704567000000000 | -74.006190000000000 |

| 111 | Wall | Street | New York | NY | 10005 | 40.704445000000000 | -74.006710000000000 |

| 110 | Wall | Street | New York | NY | 10005 | 40.704780000000000 | -74.006520000000000 |

| 101 | Wall | Street | New York | NY | 10005 | 40.704815000000000 | -74.007150000000000 |

| 100 | Wall | Street | New York | NY | 10005 | 40.705208000000000 | -74.007090000000000 |

#3 Apply GeoLocation distances to get addresses under a certain distance of a target address:

For example, addresses < 1 km away from 3707 Newark St NW, Washington, DC 20016

| Add_Number | StreetName | StN_PosTyp | County | State | Zip_Code | Addr_Type | distance |

|---------------|---------------|---------------|---------------|----------|-------------|----------------|-------------|

| 3801 | MACOMB | Street | Washington | DC | 20016 | Residential | 0.07391 |

| 3030 | WISCONSIN | Avenue | Washington | DC | 20016 | Residential | 0.12098 |

| 2844 | WISCONSIN | Avenue | Washington | DC | 20007 | Residential | 0.19518 |

| 4000 | CATHEDRAL | Avenue | Washington | DC | 20016 | Multi | 0.71263 |

| 3930 | W | Street | Washington | DC | 20007 | Residential | 0.6701 |

| 3803 | PORTER | Street | Washington | DC | 20016 | Residential | 0.0984 |

| 2520 | 41ST | Street | Washington | DC | 20007 | Residential | 0.85543 |

---

## Source

https://www.transportation.gov/gis/national-address-database/national-address-database-0

---

## Cadence:

Revisions will be updated when a new update is published by USDOT.

---

## Need Help?

If you have questions about our products, contact us at data@rearc.io

---

# About Rearc

Rearc is a cloud, software and services company. We believe that empowering engineers drives innovation. Cloud-native architectures, modern software and data practices, and the ability to safely experiment can enable engineers to realize their full potential. We have partnered with several enterprises and startups to help them achieve agility. Our approach is simple — empower engineers with the best tools possible to make an impact within their industry.