USDOT - National Address Database (Sample Product)

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

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

---

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 

---

#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

---

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

---

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

---

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

---

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.