Our Work

Built with Public Data.
Proven with Real Work.

Gridstone builds demonstration analytics products using open public datasets — showing exactly how we approach AI-assisted analysis, data quality, pipeline design, and government reporting.

Note: These are independent demonstration projects built from publicly available data. They are not official agency dashboards and do not represent agency endorsement or affiliation.
Seattle Open Data

Seattle 311 Operations Analytics

A full operations analytics suite built on Seattle's 311 customer service request data — covering backlog analysis, closure rate trends, category breakdowns, and geographic hotspot mapping.

AI Component Automated category classification and anomaly detection on request volume patterns using machine learning.

Dataset: City of Seattle Open Data — Customer Service Requests
Deliverables: Operations dashboard · Data quality scorecard · Modernization gap analysis
WSDOT Traffic Data

Washington Traffic Volume Analytics

A statewide traffic analytics dashboard with corridor analysis, county-level comparisons, planning priority scoring, and data coverage quality assessment — built directly for Washington State DOT use cases.

AI Component Predictive traffic volume modeling by corridor and season using historical AADT data.

Dataset: WSDOT Annual Average Daily Traffic (AADT) public data
Deliverables: Statewide dashboard · Corridor priority scoring · Predictive model
Seattle Open Data

Seattle Public Safety Calls for Service

A public safety analytics dashboard covering call demand by time and geography, category mix analysis, precinct-level views, and a public transparency report template.

AI Component Call demand forecasting and resource allocation modeling by precinct and shift.

Dataset: Seattle Police Department Call Data — Seattle Open Data Portal
Deliverables: Demand dashboard · Precinct views · Transparency report template
USAspending.gov

Federal Spending Intelligence Dashboard

A federal contracting intelligence tool covering agency spend, NAICS category analysis, vendor landscape mapping, small business award patterns, and under-$1M opportunity identification.

AI Component Spend pattern clustering and opportunity scoring for small business vendors entering federal markets.

Dataset: USAspending.gov — federal awards and contracts data
Deliverables: Spend dashboard · Opportunity score model · Vendor landscape map
Multi-Dataset

Public Data Quality Monitor

A cross-dataset data quality monitoring tool that scores completeness, duplicate rates, invalid records, missing locations, and data freshness — with automated remediation recommendations.

AI Component AI-assisted anomaly flagging and remediation prioritization across multiple agency data sources.

Datasets: Seattle 311 · WSDOT traffic · SPD call data · USAspending.gov
Deliverables: Quality monitor dashboard · Automated scoring engine · Remediation report
WA Dept of Commerce · Seattle HSD · King County

Washington Homelessness Response Dashboard

An independent data analysis of Washington State and Seattle/King County's homelessness response — tracking investment growth, shelter expansion, housing outcomes, and accountability measures using real public data.

AI Component AI-assisted trend analysis, growth rate modeling, and investment vs. outcome correlation across 7+ years of public data.

Datasets: WA 2025 Point In Time Count · Seattle 2026 Budget · King County Budget · OSPI
Deliverables: Investment tracker · Program dashboard · Accountability analysis · Growth trend model
View Dashboard →
Seattle City Council · King County · KCRHA · PIT Count

Seattle Homelessness Response — Tracking Progress Over Time

An independent data analysis tracking Seattle's homelessness response over time — investment levels, population trends, shelter capacity, and accountability outcomes using real public data.

AI Component AI-assisted trend analysis and performance scoring across 12 years of Seattle homelessness data.

Datasets: PIT Counts 2014–2025 · Seattle City Budgets · KCRHA Audit · King County Budgets
Deliverables: Mayoral comparison dashboard · Investment vs outcome analysis · Timeline · Verdict cards
View Dashboard →
Seattle Mayor's Office · City Council · King County

Mayor Katie B. Wilson — Seattle Progress Report 2026

An independent public data analysis of Mayor Wilson's first five months in office — tracking progress on housing, homelessness, public safety, transit, accountability, and community investment using publicly available data.

AI Component AI-assisted progress scoring, budget analysis, and priority tracking across all major policy areas.

Datasets: Seattle 2026 Budget · King County Budget · HSD · Mayor's Office · Sound Transit
Deliverables: Achievement dashboard · Priority tracker · Timeline · Budget analysis
View Dashboard →

See something relevant to your agency?

We can extend any of these projects for your specific data environment, or build a custom analytics product from scratch.

Start a Conversation View Our Services