Geospatial Solutions
Washington, DC environmental equity demo

Environmental Equity Playground Mapper

Identify Washington, DC playgrounds and parks where low tree canopy, heat sensitivity, and income vulnerability overlap.

A Geospatial Solutions demo showing how public geospatial data can guide targeted cooling, tree planting, and community investment.

Who this helps

Cities, parks agencies, nonprofits, planners, public health teams

Decision supported

Where to prioritize shade, cooling, canopy, and grant investment

Sample output

Ranked candidate map, ward summary, evidence table, and GeoJSON

Current dataset

Loading

DPR park and recreation areas matching PLYGRD = 1 and PARK or REC CENTER GROUNDS.

Priority zones

0

Context geography

8 wards

Map layer

Priority Score

Decision question: which playgrounds and park grounds should be reviewed first for shade, cooling, tree canopy, and community investment?

Preparing DC parks, ward boundaries, and equity scores.
Screening-grade·Updated Data unavailable

Legend

Highest Priority
High Priority
Moderate Priority
Lower Priority

Equity relationship

Income vs. Tree Canopy

No chartable records

The current filters remove all records with both median household income and tree canopy values.

Ward grouping

High-Priority Playgrounds by Ward

No ward records

The current filters do not leave any playground areas to summarize by ward.

Ward canopy intelligence

Tree canopy coverage at playgrounds, aggregated by ward

This view aggregates only the filtered playground-relevant park areas, then compares each ward by average canopy, low-canopy concentration, heat overlap, and high-priority burden.

Filtered DC playground average

Data unavailable

Low-canopy threshold is set at 30% for screening and targeting.

No canopy inferences available

The current filters do not leave enough ward-level canopy records to summarize.

Average canopy plus priority burden

Ward canopy coverage vs. high-priority playground count

No ward canopy records

The current filters do not leave any playground areas with ward context.

Shade deficit concentration

Share of playground areas below canopy threshold

No deficit records

The current filters do not leave any canopy values to evaluate against the threshold.

Ward sample-size audit

Counts behind the ward-level chart

Ward 4 currently has n=9 analyzed records; Ward 6 is the small-sample ward at n=4.

Data scientist interpretation

The strongest candidates are not simply the lowest-canopy playgrounds. They are wards where low canopy repeats across multiple playground areas and overlaps with higher heat sensitivity or existing high-priority scores. That pattern helps separate one-off site conditions from ward-level investment opportunities.

Pilot-ready output

Turn this public demo into a city-specific investment review.

Geospatial Solutions can adapt this workflow to local park inventories, capital planning priorities, field inspection notes, grant geographies, and agency review requirements.

Scope a pilot map

Ranked investment list

A prioritized table of playground and park areas with score drivers, ward context, and review notes.

Decision map

A hosted Mapbox dashboard with filters, popups, ward summaries, and layer toggles for stakeholder review.

Evidence packet

Clean source notes, methodology, known limitations, and export-ready GeoJSON for agency or grant workflows.

Planning next steps

A shortlist for site inspection, community engagement, shade structure review, and tree-planting feasibility.

Methodology

Screening-grade environmental equity overlay

This demo combines public parks, Census ACS income data, tree canopy information, and DC heat sensitivity indicators to identify locations where environmental investment may have the greatest community benefit.

Data sources

DC Parks and Recreation Areas, DC Heat Sensitivity-Exposure Index, DC 2020 Urban Tree Canopy, US Census ACS 5-year median household income, and DC Ward boundaries.

Scoring method

Priority score weights income vulnerability at 35%, canopy deficit at 35%, and heat sensitivity at 30% after each indicator is normalized to a 0-100 scale.

Limitations

This analysis identifies spatial overlap between environmental exposure indicators and income vulnerability. It does not determine health outcomes or replace community engagement, site inspection, or agency planning review.

Potential uses

Parks capital planning, shade infrastructure targeting, tree-planting prioritization, public health grants, environmental justice review, and nonprofit investment planning.

Implementation stack

Technologies We Work With

We choose the stack around the job: browser maps for decision surfaces, spatial databases for reliable data, Python and GIS libraries for analysis, and annotation tools when imagery needs reviewer-ready labels.

QGIS

GIS Software

ESRI ArcGIS

GIS Platform

PostgreSQL

Database

PostGIS

Spatial Database

AWS

Cloud Platform

Google Cloud

Cloud Platform

DuckDB

Analytics Database

OpenAI

AI Platform

Claude AI

AI Assistant

CVAT

Annotation Tool

Python

Programming

React

Frontend

Node.js

Backend

Docker

Containerization

Kubernetes

Orchestration

Azure

Cloud Platform

TensorFlow

Machine Learning

Pandas

Data Analysis

NumPy

Scientific Computing

Jupyter

Data Science

Git

Version Control

Linux

Operating System

Ubuntu

Operating System

Mapbox

Mapping Platform

Leaflet

Web Mapping

Fastapi

API Framework

GeoPandas

Geospatial Analysis

GDAL

Geospatial Library