Worldwide Address Data

Snowflake Cost Saving

We Automate SnowflakeDB Data Cloud Cost Saving. Sign Our Free 7 Days No Risk Trail Now

Join

Data Share Description:

Worldwide Address Data

Data Share Frequency: Never (Static Data)
Data Share Category: Local
Data Share Type: Personalized
Data Share Date Added: February 1, 2021
Data Share Status: ACTIVE
Data Share Usage Example Q1: Find the address closest to the lat/lon coordinates 38.8541 and -77.0513 Return with zip code and street address for a given coordinate select * from OPENADDRESS where postcode is not null order by pow(38.8541 – lat, 2) + pow(-77.0513 – lon, 2) limi
Data Share Usage Example SQL1 Last Tested: January 1, 1970
Related Company: Highland Math and Starschema

Data Share Overview:

This free dataset from the OpenAddresses project allows Snowflake customers to map lat/long information to address details. Use Cases: Append your datasets with a Postal Code in order to join multiple different location datasets together. Join your address data to Lat/Long for visualization tools that need address data geocoded. Fields: Longitude Latitude Street City District Region Postal Code Country See documentation for the full list of fields

Join The Club

Every week, we'll be sending you curated materials handpicked by professionals. Plus, you'll be the first to know about our latest data!

Copyright 2022 IT Strategists, Inc.  |  All Rights Reserved  |  Privacy  |  Terms of Service  |  Community site to educate and connect Snowflake users, not part of Snowflake Inc.