Backend, database, and geospatial engineer focused on production-minded systems and environmental analytics.
This repository is the portfolio hub. Standalone project code is published in separate repositories under the matthew-lottly account, while local projects/ and standalone-checkouts/ folders serve as workspace checkouts.
- spatial-data-api for the flagship backend and GIS demo
- environmental-monitoring-analytics for the analytics and reporting lane
- monitoring-data-warehouse for the database-engineering lane
- qgis-operations-workbench for the desktop GIS and QGIS workflow lane
- postgis-service-blueprint for the open spatial services lane
- geoprompt for the custom spatial package lane
- open-web-map-operations-dashboard for the open web mapping lane
- raster-monitoring-pipeline for the raster analysis and monitoring lane
- gulf-coast-inundation-lab for the Google Earth Engine inundation mapping lane
- monitoring-anomaly-detection for the anomaly detection data science lane
- environmental-time-series-lab for the time-series analysis lane
- arroyo-flood-forecasting-lab for the flood forecasting data science lane
- station-forecasting-workbench for the forecasting data science lane
- station-risk-classification-lab for the classification data science lane
- experience-builder-station-brief-widget for the GIS frontend prototype lane
- causal-lens for the causal inference and observational study lane
- strata for conformal prediction and GNN uncertainty quantification
- Focus: backend engineering with strong GIS, database, and analytics depth
- Strengths: end-to-end systems, data workflows, geospatial problem solving, pragmatic architecture
- Typical work: spatial ETL, API design, enterprise GIS tooling, reporting pipelines, and applied data products
| Repository | Lane | What It Shows |
|---|---|---|
| spatial-data-api | Backend + GIS | FastAPI service with optional PostGIS, Docker support, health checks, and a browser dashboard for environmental monitoring. |
| environmental-monitoring-analytics | Analytics | DuckDB-based reporting pipeline for alert rates, regional monitoring pressure, and markdown operations briefs. |
| monitoring-anomaly-detection | Data Science | Python anomaly-detection pipeline for ranking suspicious telemetry behavior and packaging triage-ready station alerts. |
| environmental-time-series-lab | Data Science | Python time-series analysis lab for rolling summaries, seasonality fingerprints, change-point candidates, and temporal monitoring review. |
| arroyo-flood-forecasting-lab | Data Science | Python flood forecasting lab for wavelet denoising, autoregressive model comparison, holdout PMSE review, and Monte Carlo river-stage scenario bands. |
| station-forecasting-workbench | Data Science | Python forecasting workbench for trailing-baseline projections, holdout evaluation, and station-level review outputs. |
| station-risk-classification-lab | Data Science | Python classification lab for candidate risk-model comparison, explainable station triage, and holdout review output. |
| monitoring-data-warehouse | Database Engineering | Warehouse-style schema design, dimensional modeling, SQL transformations, and repeatable data quality checks for monitoring data. |
| qgis-operations-workbench | Desktop GIS | Python-driven desktop GIS review pack builder for QGIS-oriented bookmarks, route layouts, and analyst task preparation. |
| postgis-service-blueprint | Spatial Services | Open spatial service blueprint for PostGIS-backed collections, publication views, and delivery planning across FastAPI, PostgREST, or OGC API Features. |
| geoprompt | Package Design | Custom Python spatial package with a GeoPandas-style frame, mixed-geometry helpers, and reusable GeoPrompt equations for influence, corridor, and area scoring. |
| open-web-map-operations-dashboard | Web Mapping | React and TypeScript dashboard for open-stack layer review, map filtering, and a live MapLibre map surface. |
| raster-monitoring-pipeline | Raster Analysis | Python pipeline for raster snapshot comparison, hotspot ranking, and downstream monitoring summaries. |
| gulf-coast-inundation-lab | Remote Sensing | Google Earth Engine and Python workflow for Landsat-based inundation-frequency mapping, QA masking, and gauge-correlation validation summaries. |
| experience-builder-station-brief-widget | GIS Frontend | Public-safe React and TypeScript widget prototype inspired by ArcGIS Experience Builder patterns, with conceptual visuals and selection-driven station summaries. |
| causal-lens | Data Science | Causal inference toolkit for observational monitoring data with propensity scoring, matching, sensitivity analysis, and treatment-effect estimation. |
| strata | Data Science | Conformal prediction framework for heterogeneous infrastructure graphs with GNN-based uncertainty quantification, per-type coverage guarantees, and propagation-aware calibration. |
| 3d-vp-lcp | Remote Sensing / Ecology | LiDAR-driven 3-D landscape connectivity framework: voxelization, vertical gap fraction, species-specific morphology filtering, and 3-D least-cost-path routing. |
- spatial-data-api
- environmental-monitoring-api
- monitoring-data-warehouse
- qgis-operations-workbench
- open-web-map-operations-dashboard
- geoprompt
- environmental-monitoring-analytics
These repositories should receive priority refinement. They represent the strongest backend, GIS, data, and public-facing portfolio work in the set.
| Repository | Why It Is Prioritized | Next High-Value Upgrade |
|---|---|---|
| spatial-data-api | Strongest backend and GIS service story. | Add richer request and response examples plus rollback notes. |
| environmental-monitoring-api | Production-leaning API with dashboard context. | Add stronger operational examples and failure-path validation. |
| monitoring-data-warehouse | Best database-engineering evidence in the set. | Add a clearer schema-walkthrough artifact and warehouse narrative. |
| qgis-operations-workbench | Best desktop GIS representation. | Add fuller desktop capture assets after a QGIS review session. |
| open-web-map-operations-dashboard | Best open-stack frontend and mapping signal. | Extend browser interaction coverage into more multi-step review paths. |
| geoprompt | Best custom spatial package story. | Add CI alignment and cleaner public package framing. |
| environmental-monitoring-analytics | Strong analytics and reporting lane. | Add stronger packaging and report-evaluation framing. |
- This repository should not contain standalone project source trees.
- GitHub Actions for those projects belong in their own repositories, not here.
- Local checkout folders can still exist in your workspace, but they are intentionally ignored by this portfolio repository.
- things-to-do.md for the current portfolio-level execution list
- ROADMAP.md for the prioritized next 40 actions across repo, standalone repos, and GitHub settings
- docs/portfolio-matrix.md for the current project-by-project maturity and coverage snapshot
- docs/todo-hub.md for hub-only next actions
- docs/todo-showcase.md for showcase-specific polish priorities
- docs/todo-standalone-repos.md for source-repo follow-up work
- docs/todo-100.md for the expanded 100-item portfolio backlog
- docs/standalone-issue-checklists.md for repo-by-repo issue-ready checklists
- docs/issue-drafts-showcase.md for showcase repo issue drafts
- docs/issue-drafts-supporting.md for supporting repo issue drafts
- docs/issue-filing-queue.md for the recommended order to open issues
- docs/issue-filing-tracker.md for tracking what has been filed
- docs/issue-opening-batches.md for grouped issue-opening waves
- docs/issue-bodies-showcase.md for copy-paste showcase issue bodies
- docs/issue-bodies-supporting.md for copy-paste supporting issue bodies
- docs/issue-submissions/README.md for individual first-20 issue submission files
- docs/todo-github-ops.md for GitHub settings and automation follow-ups
- docs/pr2-split-review.md for the active backlog-branch split review
- docs/pr2-github-cleanup.md for exact stale-thread cleanup on the active PR
- docs/pr2-reviewer-closeout.md for the shorter reviewer-facing PR cleanup note
- docs/pr2-maintainer-comment.md for the exact PR #2 maintainer comment and UI checklist
- docs/merge-checklist.md for backlog-branch merge review
- docs/weekly-maintenance-checklist.md for recurring portfolio upkeep
- CONTRIBUTOR_ONBOARDING.md for repo workflow and contribution rules
- Workspace tasks in
.vscode/tasks.jsonfor one-click checks and filing helpers
- LinkedIn: https://www.linkedin.com/in/matthew-a-powell/
- Website: https://lottly-ai.com/