Welcome to the Location Analytics Hands on Lab. Today you will learn how to analyse and transform geospatial data in Snowflake. You will be covering:

alt text

Structure of the session

The Lab consists of three notebooks and two Streamlit applications.

What You Will Learn

What You'll Build

Prerequisites

Open up a new SQL worksheet and run the following commands. To open up a new SQL worksheet, select Projects » Worksheets, then click the blue plus button and select SQL worksheet.

CREATE DATABASE IF NOT EXISTS ANALYSE_LOCATION_DATA;

CREATE WAREHOUSE IF NOT EXISTS LOCATION_ANALYTICS;

CREATE SCHEMA IF NOT EXISTS NOTEBOOK;
CREATE SCHEMA IF NOT EXISTS STREAMLIT;
CREATE SCHEMA IF NOT EXISTS DEFAULT_SCHEMA;

Ordnance Survey Datasets

alt text

Carto Datasets - Obtain the following datasets from the marketplace

This dataset provides sample building polygons all over the world.

alt text

Are you ready to start learning about location data in Snowflake?

This tutorial will take you through how you can use location data to perform spatial calculations, joins, and visualise the data using the popular Pydeck python package. We will be using the freely available datasets which you have now installed to step through examples of how geospatial data can be handled.

import

This app gives you an example of how you can bring all these datasets together to form a multi layered mapping visual.

alt text

Conclusion

Congratulations on completing the Location Analytics Hands-on Lab! Throughout this session, you've explored how Snowflake can be used to analyze and transform geospatial data, combining multiple datasets to generate valuable insights.

What You Learned

Next Steps

With this foundational knowledge, you can extend your analyses by:

We hope this hands-on lab has provided you with the confidence and skills to apply geospatial analytics in your own projects. Happy analyzing! 🚀

Related Resources

Source code

Further Related Material