Sonra: Administrative Boundaries USA

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


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




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.