Richard PPowerShell: Create an HTML report from SQLHumans need easy-to-read reports. Create an HTML file with tables for fast consumption.·7 min read·4 days ago----
Richard PNew Mexico Acequias: QGIS Cloud Web MapView a map of New Mexico acequias in your browser with data from New Mexico RGIS.·3 min read·Jun 9, 2024----
Richard PMS SQL Server Performance ChecklistGet the most out of your SQL Server on-prem instance with this checklist of configuration settings.·10 min read·May 26, 2024----
Richard PinPython in Plain EnglishCreate an Extruded Polygon Map with Kepler.gl and Google Earth Engine Satellite dataIn my previous article, I demonstrated how to segment/tesselate a single polygon into a set of evenly sized hexagons. Now, we are going to…6 min read·Dec 2, 2023----
Richard PinPython in Plain EnglishTesselate a GeoDataFrame into Hexagons Using PythonTesselation is a method of breaking up a geometry from a single polygon (or multipolygon) into a collection of polygons that are continuous…·7 min read·Nov 21, 2023----
Richard PDeploy a SQL Server 2022 container in less than 10 minutesSet up a Linux SQL Server database in less than 10 minutes using Docker. With a containerized version of SQL Server, you can run the…·2 min read·Sep 14, 2023--1--1
Richard PSQL Server Dynamic Management Views (DMVs) cheatsheetThese DMVs and catalog views can help you to monitor database performance and troubleshoot slow queries. This is a cheatsheet focused on…·4 min read·Aug 26, 2023----
Richard PinPython in Plain EnglishScrape satellite data for every US wildfire in 2022 using Python and Google Earth EngineWhat is NDVI?5 min read·Aug 15, 2023----
Richard PinSelectFromMapping Fracking Wells in Colorado with PostgreSQLUse SQL to Analyze Data and Draw Maps·6 min read·Apr 17, 2022--2--2
Richard PinDev Genius3 Easy Ways to import a shapefile into a PostgreSQL databaseBefore we begin, you must have an instance of PostgreSQL installed with the PostGIS extension. PGAdmin is a good database administration…·3 min read·Mar 31, 2022--1--1