Labs
Houston public-service activity
Houston Signal
A daily public-data view of Houston service requests and active emergency incidents.
- Data through
- 2026-05-28
- Refreshed
- Sep 19 · 10:30 UTC
- Pipeline
- Succeeded
Houston 311 geography
Request concentration
Filter the current feed, then select a 1 km cell to inspect request volume, open work, and recency.
Houston 311 · current published feed
What Houston is publishing now
All open cases plus cases closed in the last two weeks. This is a current source snapshot, not a complete historical count.
- Cases in the current feed
- 49,24840,343 are still open
- Created in the latest 30 days
- 16,476Through May 28, 2026
- Closed among those cases
- 35.8%Among cases from the same 30-day window that remain in the feed
- Median time to close
- 2.8 days Among closed cases still in the feed from the latest 90 days
Houston Emergency Center · active snapshot
43 active incidents
Houston publishes active Fire and Police calls. Houston Signal retains each incident it sees for 365 days.
- Retained by Houston Signal
- 1,444
- Active Fire calls
- 32
- Active Police calls
- 11
- Latest active call opened
- Sep 19 · 10:49
- Source refreshed
- Sep 19 · 11:00 UTC
Calls that open and close between source refreshes may not appear in the retained history.
Current call types
-
01EMS EVENT29
-
02CRASH/MAJOR/NON FATAL7
-
03TRAFFIC HAZARD/URGENT2
-
04CRASH/MAJOR/FSRA1
-
05CRASH/MINOR/FSGI1
-
06FIRE EVENT1
Current source snapshot · latest 365 days
Visible cases by creation date
Open and recently closed cases grouped by their original creation date.
Houston publishes all open 311 cases and only closed cases from the last two weeks. Older creation dates therefore show unresolved cases, not complete historical request volume.
Request types
Top request types
Created in the 30 days ending May 28, 2026.
-
01Weeds/Trash/Stagnant Water on Property2,465
-
02Traffic Signal Maintenance1,351
-
03Container Replacement926
-
04Water Leak826
-
05Parking Violation817
-
06Missed Garbage Pickup646
-
07Street Hazard536
-
08New Resident Container517
Geography
Council districts
Request volume in the same 30-day period.
-
01 District C 2,548
-
02 District D 2,218
-
03 District H 2,082
-
04 District B 2,049
-
05 District I 1,557
-
06 District K 1,423
-
07 District A 1,250
-
08 District E 934
-
09 District F 872
-
10 District G 870
-
11 District J 629
-
12 Unknown district 44
Pipeline status
Ingestion and dbt
Prefect runs each source ingest. PostgreSQL records the outcome, and dbt exposes one shared activity fact.
Source health
Latest committed loads
Each source owns its extraction cadence. Both publish through the same PostgreSQL and dbt foundation.
| Source | Status | Completed | Extracted | Changed | Watermark |
|---|---|---|---|---|---|
| Houston 311 | Succeeded | Sep 19 · 10:30 UTC | 2,000 | 0 | 2026-05-28 23:06:21+00:00 |
| Houston Emergency Center | Succeeded | Sep 19 · 11:00 UTC | 43 | 83 | 2026-09-19 10:49:00+00:00 |
Data path
Two sources, one reporting model.
Prefect schedules both ingests. PostgreSQL persists validated source rows, dbt transforms them, and Houston Signal queries the shared fact.
Latest row accounting
- Inserted
- 43
- Updated
- 0
- Unchanged
- 0
- Deactivated
- 40
- Deleted by retention
- 0
- Current watermark
- 2026-09-19 10:49:00+00:00
Database audit
Recent ingestion runs
Audit rows are committed with their source load.
| Completed | Source | Status | Extracted | Loaded | Changed |
|---|---|---|---|---|---|
| Sep 19 · 11:00 | Houston Emergency Center | Succeeded | 43 | 43 | 83 |
| Sep 19 · 10:30 | Houston 311 | Succeeded | 2,000 | 1,538 | 0 |
| Sep 18 · 11:01 | Houston Emergency Center | Succeeded | 40 | 40 | 81 |
| Sep 18 · 10:31 | Houston 311 | Succeeded | 2,000 | 1,538 | 0 |
| Sep 17 · 11:01 | Houston Emergency Center | Succeeded | 41 | 41 | 79 |
| Sep 17 · 10:30 | Houston 311 | Succeeded | 2,000 | 1,538 | 0 |
| Sep 16 · 11:01 | Houston Emergency Center | Succeeded | 38 | 38 | 70 |
| Sep 16 · 10:30 | Houston 311 | Succeeded | 2,000 | 1,538 | 0 |
Sources and methods
Public data, independently presented
Houston Signal is not affiliated with the City of Houston and is not an emergency service.
Derived from the City of Houston 311 Recent Service Requests feed and the public Houston Emergency Center active-incident layer, including Fire and Police records. Map data and tiles are © OpenStreetMap contributors.
Source feeds may be incomplete, delayed, corrected, or removed. Locations are intentionally reduced in precision and must not be used for emergency response, outreach, insurance, or safety decisions.