How to get started with spatial SQL

Mastering SQL fundamentals to get started with spatial SQL So you are interested in getting started with spatial SQL — that’s great! Getting started can seem overwhelming but in this post and others, I hope to take you through the different use cases for spatial SQL bit by bit.  One of the biggest challenges if you are working […]

The case for using spatial SQL

Why spatial SQL matters and how it can help you accelerate your GIS and geospatial workflows Originally published on Towards Data Science in June 2021 It was the spring of 2012 and I just had my first encounter with a SQL query. I had just moved to New York at the end of 2011 and […]

What do you get from sharing your location data?

You are sharing your location all the time. What do you get in return for the data you share? Knowingly or not, you are sharing your location. Your mobile device sends out your current location, multiple times a day, to companies that collect that information from apps on your phone. You may not have thought twice […]

A Brief History of Web Maps

Or how a Flemish cartographer and PNGs made web maps a part of our everyday lives Originally published on Towards Data Science in May 2020 When was the last time you were lost? Really think about it. Unless you didn’t have a phone or yours ran out of power, you likely had directions telling you where […]

zip codes map

Stop Using Zip Codes for Geospatial Analysis

Originally published on CARTO and Towards Data Science in August 2019 The last time you used your zip code, you were most likely entering your address into a website to make a purchase, finding a store near your home or office, or filling out some other online form. You likely found the answer you were […]