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/

搜集汇总

背景与挑战

背景概述

该数据集包含美国各级行政边界（如州、县、邮编区等）的多边形地理数据和相关属性（如面积和FIPS代码），基于美国人口普查局的TIGER/Line Shapefiles构建。数据集提供详细的文档和多个核心表格，用于支持地理信息分析。