Postgis

SF Castro 311 Dashboard Summary — 2025-08-24 Raw Metrics Total cases: 70 Open: 41 Closed: 29 Request Type Breakdown request_type cnt Street and Sidewalk Cleaning 26 Graffiti Public 11 Parking Enforcement 8 General Request 6 Encampment 3 Tree Maintenance 3 Noise 2 Blocked Street and Sidewalk 2 RPD General 2 Sidewalk and Curb 2 Sewer 1 Graffiti Private 1 Muni Employee Feedback 1 Muni Service Feedback 1 Street Defect 1 Average resolution time: 1.5 hrs Open-case aging: 0–1 d=3, 1–3 d=38, 3+ d=0 AI Report SF_OpenCloseReport: {date} ...

Building a Personal GeoServer & PostGIS Stack I’ve worked with ArcGIS Online, ArcGIS Enterprise, and Microsoft SQL Server throughout my GIS career. I wanted a way to explore serving geospatial data using open-source tools and cloud infrastructure. That led me to build a personal GeoServer and PostGIS stack. I wanted a mini-server setup I could tinker with, break, rebuild, and use for hobby projects without relying on enterprise software. Here’s how I built it. ...