End-to-End Guide: Ingesting Overture Maps Data into Snowflake and Serving It as a GeoService with Snowflake-Koop Provider

In this article, I will walk you through the process of ingesting geospatial data from the Overture Maps Foundation into Snowflake, using a step-by-step approach. Additionally, we will leverage the Snowflake-Koop provider to access and serve the ingested data as a GeoService. What is Koop.js ? Geospatial data server for the web; built using Node JS w/ javascript (a.k.a RESTful web server) Transform/serves data from from remote APIs with HTTP requests Support geospatial operations Built-in support for Geoservice Spec (for ArcGIS clients) “Plugins” allow quick and customuze deployments Underlying tech for custom data feeds in ArcGIS Enterprise. Common challenges with data feeds in any enterprise includes: ...

November 7, 2024 · 5 min

Access a Table from Azure Databricks using Javascript

This post shows how to connect to Azure Databricks using Databricks SQL driver for Node JS and fetch the data Pre-requiste Install Node.js version 14 or higher version Install @databricks/sql package from npm Create an workspace in Azure databricks and injest a data and save as table in Delta lake. Create personal access token as outlined here Understanding Databricks Authentcation types: using Personal Access Token (PAT) using User to Machine (OAuth User to machine) ...

November 6, 2024 · 2 min

Good Reads

I’ll share some of good technical articles and blogs which I came across. Awesome Vector-tiles . List of parsers and generators, clients and geospatial tools. What are Vector-tiles? . Good summary of vector-tiles and why should we care Awesome MapBox Resources - List of external resources if you are using Mapbox Tiling - Good reading on tiling. Must for any geospatial Engineer Src vs Flat Layout - Gives good undertsnading of python packaging and layout structure. ...

August 12, 2024 · 2 min