- Products
- Solutions
- Developers
- Support
- About
- Login
- Blog
Native App · Address Geocode US
Geocode your address table where it already sits.
Convert US addresses into validated coordinates, Census geography, and jurisdiction data inside your Snowflake account. Get a usable location back even when the address is incomplete.
Coordinates + Census geography
Native app in your Snowflake account
Free 20-day trial, no sales call
Address in → geography out
In your warehouse
27 E Cota St, Santa Barbara CA 93101
34.4197, −119.6987Tract 0020.02FIPS 06083
100 State St (no unit), SB CA
Street-level matchCounty + district
Lompoc, CA 93436
City-level matchBest available
Even an imperfect address returns a location — not an empty row.
Trusted by data teams at brands that plan by geography
The problem
Most geocoders quit on the addresses you actually have.
Address data collected over years is never uniform — missing units, street types abbreviated three ways, records typed by a human in a hurry. Most geocoding tools are built for the clean version: they match exactly or return nothing, and every imperfect record drops out.
The export loop
Pull a CSV, send it to a geocoding service, wait, load the results back, reconcile the rows that didn't return. Repeat next month.
All-or-nothing matching
An exact-match geocoder returns no result for a record missing a unit number, even when the street and city are unambiguous.
Coordinates without context
Latitude and longitude answer where, but territory rules, tax jurisdiction, and reporting need FIPS codes, Census tracts, and districts.
Consumer geocoding APIs
Rate limits, bulk restrictions, and terms that constrain what you can store or display.
The result is a geographic layer that is always slightly stale, never complete, and lives one system away from the data it describes.
What you get back
More than a coordinate pair.
Every input row returns a full geographic record, not just a point on a map — and every field lands in a Snowflake table, ready to use in SQL like any other column.
Latitude & longitude
Coordinates at the most granular geographic level available for that address.
Census geography
Census Tract, Census Block, Census GeoID, and ClassFP.
Jurisdiction data
County and state FIPS codes, congressional district, and state legislative district.
Location context
Alternate place name, incorporation status, time zone, and UTC offset.
Mapping links
Ready-to-use Google Maps, Bing Maps, and MapQuest links for the returned coordinates.
Cascading match, built in
When an exact property-level match isn't available, it falls back to a broader match rather than returning nothing — down to city and state.
Honest about precision. Precision varies by record, so treat each result as the best available match rather than a rooftop coordinate on every row.
The shift
From all-or-nothing to a location on every row.
An exact-match geocoder returns a coordinate or nothing. Cascading match returns the most precise location it can find — so the messy records stay in your dataset.
Exact-match geocoder
Match perfectly, or drop the row
NO MATCH
- Returns nothing when a unit or detail is missing
- Imperfect records silently fall out of the dataset
- A coordinate, with no geography or jurisdiction
- Lives one export away from your table
Cascading match
Return the best location available
34.42, −119.70 · Tract
- Falls back progressively — rooftop to street to city
- A usable location on records others would drop
- Full Census geography and jurisdiction, every row
- Lands right back in your Snowflake table
How it works
One SQL call. Coordinates and geography back in your table.
1
Install the native app
Get it from the Snowflake Marketplace and grant the external access integration. It runs inside your account — nothing to stand up, no API client to build.
2
Point it at your table
Pass a SELECT query and an output table path. It runs right in your warehouse, where your data already lives.
3
Read the results
A table lands in your schema with coordinates, Census geography, jurisdiction codes, context, and mapping links for every row. Join it back on the row ID.
worksheet.sqlSQL
-- Point it at a query and an output table CALL APP_CODE.AGUS_GET_BEST_MATCHES_V4( 'SELECT CONSUMER_ROW_ID, ADDRESS, CITY, STATE, POSTALCODE FROM MY_SCHEMA.MY_TABLE', 'MY_SCHEMA.AGUS_RESULTS' );
Install, call, use — results land back in your own table.
No batch files. No CSV export. No third-party bucket. No API integration to maintain.
Who it's for
Built for the teams that plan by geography.
Sales & revenue operations
Write territory logic in SQL with FIPS codes, districts, and coordinates — not ZIP boundaries that break.
Logistics & delivery
Get the most precise location available for every stop with cascading match, including the messy ones.
Risk, tax & compliance
Assign jurisdiction with Census Tract, Block, GeoID, and incorporation status — based on where a record sits.
Analytics & data science
Add coordinates, Census geography, time zone, and UTC offset as model and segmentation inputs.
Real estate & site selection
Analyze markets with structured geography: coordinates, Census, ClassFP, place name, jurisdiction.
Marketing operations
Use place name, time zone, and UTC offset for regional targeting and communication timing.
Security & architecture
You control the connection. We retain nothing.
The app runs inside your Snowflake account. When you call it, the app sends address data to the Service Objects API through a single external access integration you grant and revoke and retains nothing.
You can review exactly what the app requests before you install it. There are no batch files moving between systems, no third-party storage bucket holding your customer data, and no standing credential in an external tool.
SOC 2 Type II
PCI-DSS
Your Snowflake accountThe app runs on your data in your warehouse
Single external access integrationYou grant it, you can revoke it — the only connection
Service Objects validation APIValidates & returns the result — stores nothing
Why Service Objects
Enterprise reliability, proven since 2001.
The validation and location infrastructure behind AGUS has run in production for over two decades — trusted by Fortune 500 data teams and backed by billions of validated transactions.
25 Years
In production, since 2001
8 Billion+
Validations delivered
99.999%
Uptime SLA, financially backed
SOC 2 Type II
Independently audited security
Fortune 500
Clients rely on our data
Pricing
Transparent pricing. Pay through the Snowflake Marketplace.
Both tiers return the complete output, same latency, same uptime SLA. The only difference is volume.
Standard
$2,500 / year
100,000 transactions
- Full output — coordinates, Census geography, jurisdiction & mapping links
- Sub-500ms latency, 99.999% uptime
- 20-day trial — 1,000 records, full output
Higher volume
Enterprise
$7,500 / year
500,000 transactions
- Full output — coordinates, Census geography, jurisdiction & mapping links
- Sub-500ms latency, 99.999% uptime
- 20-day trial — 1,000 records, full output
Marketplace Capacity Drawdown (MCD) supported.
Apply a percentage of your committed Snowflake capacity toward this purchase. No separate procurement process and no additional contract — if your team already has committed Snowflake spend, this draws against it.
No "request a quote." No sales call required to learn what it costs.
Snowflake Marketplace
Geocode your own address table.
Geocode your own address table.
Free for 20 days.
1,000 records with the complete output — coordinates, Census geography, jurisdiction data, and mapping links. Install, grant the connection, and geocode your first batch in minutes.
Stops at 20 days or 1,000 records, whichever comes first. No auto-charge, no surprise conversion.
Questions, answered
Frequently asked questions
Is every result a rooftop coordinate?
No, and that is deliberate. The app returns the most precise match it can find for each address. When an exact property-level match is not available, it falls back progressively to a broader geographic match rather than returning nothing — down to ZIP, city, and state level. You get a usable location on records an exact-match geocoder would drop, with precision that varies by record.
Does it validate the address as well as geocode it?
It validates the address internally as part of finding the coordinates, but the corrected address is not part of what comes back. You get the location, not a cleaned-up address to write to your table. If you need CASS-certified correction and delivery point validation as an output, that is the address validation app.
Is it US only?
Yes. This app covers US addresses.
Can we store and display the coordinates we get back?
Yes. The results are yours to store, display, and use in your own systems. There is no separate mapping licence to buy and no requirement to display the results on a particular provider's map.
Does my data leave Snowflake?
The app runs inside your Snowflake account and sends address data to the Service Objects API through a single external access integration you grant and revoke. Nothing is retained. There is no batch file, no third-party bucket, and no standing credential outside your control.
Is this real-time?
It runs in your warehouse against tables, on demand or on a schedule. It is not a point-of-entry lookup embedded in your application.
Where does the geographic data come from?
Proprietary geographic data sources updated continuously, combined with Census geography and jurisdiction reference data.
What is the difference between Standard and Enterprise?
Volume only. Both tiers return the complete output with the same latency and the same uptime SLA.
Can we pay with our Snowflake commitment?
Yes. Marketplace Capacity Drawdown lets you apply a percentage of your committed Snowflake capacity to this purchase, so it does not require a separate contract or vendor onboarding cycle.
The rest of the portfolio
Also in your Snowflake account.
Geocoding accuracy depends on address quality — so these two run in the same direction, on the same contact record.