Sonra: Administrative Boundaries USA

The polygon boundaries of geographic areas of the United States from the US Census

Description:

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.

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.

About the Provider:

Sonra offers products and services in data management and data analytics.

Flexter is our flagship product. It automates the conversion of industry data standards, XML, JSON to a relational model on Snowflake, relational databases, and big data formats

Sonra provides Snowflake various professional services, e.g. migration services, quickstarts.

Sonra provides data advisory services, e.g. data architecture and strategy.

Visit the provider’s website for more

Get access to the Sonra: Administrative Boundaries USA Listing in Snowflake

Sign up for a Snowflake free Trial

Already a Snowflake customer?
Access this listing directly from your Snowflake account.

Login