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