Administrative Boundaries USA

ABOUT
=====
The Administrative Boundaries USA data set contains border information as polygons about the following divisions of the fifty states, the District of Columbia, Puerto Rico, and the Island areas (American Samoa, the Commonwealth of the Northern Mariana Islands, Guam, and the United States Virgin Islands) of the United States.

> States
> Counties
> Zip Code Tabulation Areas
> County Subdivisions
> Census Tracts
> Block Groups

Apart from the geographic boundary information as polygons, the data set also includes attributes such as total land area, total water area, FIPS codes and much more. Please refer to the data dictionary in the documentation for full details https://sonra.io/snowflake/administrative-boundaries-usa/#data-dictionary

The data set is based on the TIGER/Line Shapefiles from the US Census Bureau. These are extracts of selected geographic and cartographic information from the Census Bureau's Master Address File (MAF)/Topologically Integrated Geographic Encoding and Referencing (TIGER) Database (MTDB).

TABLES
=======

CORE TABLES
--------------------
TL_2020_US_STATE
TL_2020_US_COUNTY
TL_2020_US_COUSUB
TL_2020_US_TRACT
TL_2020_US_BG
TL_2020_US_ZCTA520
CROSSWALK

DOCUMENTATION
===============

We have put together a comprehensive documentation which includes a description of all of the tables and columns in the data set and sample queries.

You can view the documentation here: https://sonra.io/snowflake/administrative-boundaries-usa/