Top Modern GIS Skils for GIS Analysts in 2022

GIS Analysts serve the incredibly important purpose of providing detailed analysis and flexible results working with a wide range of data and tools. Not only do GIS Analysts work with many different stakeholder groups, but they also have to maintain a flexible workflow and use a wide range of data, delivering easy to use and […]

PostGIS and Geopandas

PostGIS and GeoPandas in Jupyter in 4 minutes

Take advantage of the speed of PostGIS along with the flexibility of Geopandas and Python in 4 minutes! Take a look at the video and follow along with these steps! The Spatial SQL Book – Available now! Check out my new book on Spatial SQL with 500+ pages to help you go from SQL novice […]

What is spatial SQL?

What is spatial SQL?

Spatial SQL is not just a query language. It is becoming far more than that and its uses are expanding beyond just a database for spatial data. It allows for faster spatial analysis, supports spatial applications, enables spatial data science and machine learning, and far more. Because of these reasons I wanted to share a […]

Uncategorized

PostGIS and QGIS in 4 minutes

QGIS provides an excellent interface to get started with PostGIS, and (if you are a Mac user) you can start with PostGIS using Postgres.app very fast! Check out the video and follow along using this guide. Download and install Postgres.app First, head over to this site to download and install Postgres.app. This is a complete […]

Learn Spatial SQL

40+ Spatial SQL Resources and Guides

One of the top questions I get asked is what my favorite resources are for learning any given topic, and spatial SQL is always near the top of that list It’s no secret that I am a big fan of spatial SQL (see my past posts on the topic). It’s speed, scale, and ability to […]