Tesselation is a method of breaking up a geometry from a single polygon (or multipolygon) into a collection of polygons that are continuous with no gaps. This is useful for situations where the original geojson polygon comprises a large diverse area, and you want to calculate statistics for the smaller…

Set up a SQL Server database in less than 10 minutes using Docker. With a containerized version of SQL Server, you can run the database server anywhere you can install docker. For instance, this setup was a breeze on my old Macbook Air 8. …

These DMVs and catalog views can help you to monitor database performance and troubleshoot slow queries. This is a cheatsheet focused on DMVs that are tested on the DP-300 Administering Microsoft Azure SQL Solutions exam. …

In this article, I will demonstrate how to extract NDVI green-ness values from satellite data provided by MODIS/NASA and save to a local file. This is the basic prototype for a remote sensing data collection script. What is NDVI? NDVI stands for Normalized Difference Vegetation Index and is a metric for analyzing the…

Use SQL to Analyze Data and Draw Maps Analysis Plan Requirements: PostgreSQL with PostGIS enabled and pgAdmin4. Load Data into PostgreSQL — Colorado counties boundary shapefile and a shapefile of fracking well locations from FracTracker Data cleaning — specifying SRIDs, creating the geospatial index, and creating a geometry column from latitude and…

Before we begin, you must have an instance of PostgreSQL installed with the PostGIS extension. PGAdmin is a good database administration software that can be installed with PostgreSQL. Download PostgreSQL — https://www.postgresql.org/ Install PostGIS — https://postgis.net/install/ We also need a dataset. In this post, we will use the University of…

Some quirks of Cloud Functions. The python script was a relatively simple ETL job that tested my abilities to architect and debug, but it was a great experience in deploying production code under constraints. The script simply compared two Google Sheets, and updated the target page with new or updated…

Have you ever wanted to watch foreign malicious actors attack a virtual machine in real time? In this article, we will do just that with a python honeypot and Azure Monitor. First, I need to give a shout-out to the Microsoft docs for setting up Application Insights. …

Interactive charts are key to visual storytelling. — Building an infographic often starts while you are first exploring the data. Matplotlib, Seaborn, and ggplot2 are the classic programming charts, while Plotly has also exploded in popularity. But for me, nothing matches the clean professional aesthetic of Tableau. …