Webvar
USDOT - National Address Database (Sample Product) - logo

USDOT - National Address Database (Sample Product)

This listing contains sample datasets related to the National Address Database provided by the US Department of Transportation (USDOT). This listing is for sample data. For access to the full dataset, please contact us at data@rearc.io.
awsPurchase this listing from Webvar in AWS Marketplace using your AWS account. In AWS Marketplace, you can quickly launch pre-configured software with just a few clicks. AWS handles billing and payments, and charges on your AWS bill.

About

**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.

Related Products

How it works?

Search

Search 25000+ products and services vetted by AWS.

Request private offer

Our team will send you an offer link to view.

Purchase

Accept the offer in your AWS account, and start using the software.

Manage

All your transactions will be consolidated into one bill in AWS.

Create Your Marketplace with Webvar!

Launch your marketplace effortlessly with our solutions. Optimize sales processes and expand your reach with our platform.