USDOT - National Address Database (Sample Product)
Available in
AWS Marketplace
Available in
AWS Marketplace
Available in
AWS Marketplace
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
show moreBuyer guide
Read insights from real user interviews on why they chose this product.
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.