InThe Quantastic JournalbyRichard P·Jul 21, 2024Climate Change For Cities: Mitigation And AdaptationHow does climate policy get enacted on the local level? Problems, Policy, and Politics…
Richard P·Jun 12, 2024PowerShell: Create an HTML report from SQLHumans need easy-to-read reports. Create an HTML file with tables for fast consumption.
Richard P·Jun 9, 2024New Mexico Acequias: QGIS Cloud Web MapView a map of New Mexico acequias in your browser with data from New Mexico RGIS.
Richard P·May 26, 2024MS SQL Server Performance ChecklistGet the most out of your SQL Server on-prem instance with this checklist of configuration settings.
InPython in Plain EnglishbyRichard P·Dec 2, 2023Create an Extruded Polygon Map with Kepler.gl and Google Earth Engine Satellite dataimage created by author
InPython in Plain EnglishbyRichard P·Nov 21, 2023Tesselate 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…
Richard P·Sep 14, 2023Deploy 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…A response icon1A response icon1
Richard P·Aug 26, 2023SQL 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…
InPython in Plain EnglishbyRichard P·Aug 15, 2023Scrape satellite data for every US wildfire in 2022 using Python and Google Earth EngineWhat is NDVI?
Richard P·Apr 17, 2022Mapping Fracking Wells in Colorado with PostgreSQLUse SQL to Analyze Data and Draw MapsA response icon2A response icon2
