Worldwide Address Data

Come join us for the LA Snowflake BUILD Event on Wednesday December 11th at Santa Monica Brew Works.

Login

Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

April 6, 2021

Snowflake Cost Saving

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

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!

Come join us for the LA Snowflake BUILD Event on Wednesday December 11th at Santa Monica Brew Works.

Login

Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free