Free Snowflake Marketplace listing

U.S. ZIP Code Metadata with Geometry

A Snowflake-ready ZIP and ZCTA geography table for joining customer, store, property, and market data to county, CBSA, timezone, lat/lng, and geometry fields.

Get Free on Snowflake Request Enriched ZIP Data

Join-Ready Geography

Use ZIP or ZCTA keys to enrich internal records with location metadata.

Mapping Fields

Latitude, longitude, geometry, county, CBSA, and timezone fields for spatial workflows.

Native Snowflake Access

Install the share from Snowflake Marketplace and query it directly in your warehouse.

Free Geography Base Layer

Start with the free geography layer, then add paid demographics or real estate signals when needed.

Schema preview

What is included

Use these fields as a starting point for Snowflake joins, BI models, lead scoring, underwriting, site selection, or custom data products.

ZIP / ZCTA Identity

ZIP or ZCTA code
Preferred city
State code
Parent geography relationships

Geographic Crosswalks

County name and FIPS
CBSA mapping
State and regional attributes
Useful lookup keys

Spatial Fields

Latitude and longitude
Geometry fields
Centroid-style joins
Map-ready location attributes

Operational Metadata

Timezone
City and county labels
Join fields for warehouse models
Documentation-friendly schema

Where teams use this data

These datasets are built for warehouse-native workflows where geography, market context, and property signals need to join cleanly to your existing data.

Customer and Store Enrichment

Join customer, store, territory, or address-derived ZIP data to county, metro, timezone, and geometry fields.

Market Screening

Build market-level cuts by CBSA, county, state, or ZIP without maintaining your own crosswalk tables.

Map and BI Workflows

Power dashboards, maps, territory reports, and spatial joins from a Snowflake-native table.

Illustrative SQL

Snowflake

select
  z.zip_code,
  z.city,
  z.state,
  z.county_name,
  z.cbsa_name,
  z.timezone,
  z.latitude,
  z.longitude
from zip_code_meta_share.public.zip_code_metadata z
where z.state = 'TX'
limit 100;

Use this query as a join-pattern example. Replace database, schema, table, and column names with the exact objects from the Marketplace data dictionary after installation.

Snowflake + SFR Analytics

Need a custom data package?

Use Snowflake Marketplace for self-serve warehouse access. For custom geographies, enriched fields, API access, flat files, private listings, or other real estate datasets, start with the product catalog or request a scoped package.

Open Snowflake Listing Browse SFR Analytics Products Request Direct Data Delivery

Related Snowflake datasets

Use the free geography listings as a base layer, then add paid enrichment where the workflow needs more signal.

View all Snowflake pages

Paid Snowflake Marketplace listing