Skip to main content

Data Dictionary

Geographic Entity CharacteristicsView Source Documentation

PUBLIC_DATA.GEOGRAPHY_CHARACTERISTICS: Repository of geography characteristics, including GEOJSON coordinates, WKT coordinates, state abbreviations, and FIPS codes.

Geographic Entity HierarchiesView Source Documentation

PUBLIC_DATA.GEOGRAPHY_HIERARCHY: Hierarchical relationships between geographic entities, such as countries, states, and counties.

PUBLIC_DATA.GEOGRAPHY_INDEX: Snowflake Public Data unified geographic entity index, joinable to all tables, providing unique geographic identifiers with associated names, levels, and ISO codes for various US geographies.

Geographic Entity OverlapsView Source Documentation

PUBLIC_DATA.GEOGRAPHY_OVERLAPS: Geographic relationships between overlapping regions, such as counties and zip codes, identified by unique GEO_IDs.

Geographic Entity RelationshipsView Source Documentation

PUBLIC_DATA.GEOGRAPHY_RELATIONSHIPS: Relationships between geographic entities of differing levels, including overlaps and contains relationships, using Snowflake Public Data GEO_IDs.