Stories in this track keep running into the same missing fields and feeds. If you know where
to find any of these, get in touch — each is a story waiting for the right column.
PFD apparatus dispatched
PFD · Open The fire-incident layer publishes which incident type and where, but not which engine, ladder, medic, or specialty rig responded.
Would unlock "busiest engine," "busiest ladder," and per-rig run-volume comparisons across stations.
Where to look
- › OpenDataPhilly — Search for an "incident apparatus" or "unit dispatch" feed alongside the existing stat360_fire_incidents layer.
- › PFD FOIL request — Right-to-Know Act request for unit-level dispatch logs.
- › NFIRS extracts — The federal NFIRS database carries per-unit fields; PFD submits to it.
PFD first-due station per incident
PFD · Open Incidents lack a column naming the station that responded; we approximate via a centroid-to-nearest-station spatial join.
Replacing the proxy with the published assignment would give exact per-station run counts and let us show overrun patterns when first-due is unavailable.
Where to look
- › PFD response-zone shapefile — A station response-area polygon set, if published, would let us assign by geometry rather than nearest-point.
- › PFD FOIL request — Same vehicle as above; ask for response-zone or unit-assignment data.
EMS-only dispatch feed
EMS · Investigating PFD’s `stat360_fire_incidents` mixes fire and EMS via an `incident_type_category` field; an EMS-only layer with finer call-type detail (e.g. "Medical Emergency", "MVA", "Cardiac") doesn’t appear in the published catalog.
Would let the medic-unit-load story drill into call-type mix per zip and per medic unit instead of treating "Rescue & EMS" as a single category.
Where to look
- › PFD EMS division — The bureau publishes annual reports with breakdowns; ask whether the underlying feed is on ArcGIS.
- › OpenDataPhilly — Periodically check for new EMS-tagged feeds.
Per-incident PPD demographics + outcome
PPD · Open The Carto `shootings` table publishes victim race/sex/age and a fatal flag, but not arrest status, charged offense, or case clearance. `incidents_part1_part2` carries category and district but no demographic or outcome detail.
Would let the police stories follow incidents downstream of the dispatch — clearance rates by district, charging patterns by offense type, the gap between "called in" and "resolved."
Where to look
- › PPD Annual Crime Report
- › PPD FOIL request — Per-incident clearance / charging data is held by the PPD Records Bureau.
Narcan administrations (per-incident or aggregated)
OPIOID · Open Overdose deaths are published; the volume of Narcan administrations (not kits distributed) per incident or per zip is not in the current pipeline.
Would let the Narcan story show "saves" alongside losses — the response side of the same crisis.
Response time distributions by incident type
PFD · Open Neither the fire nor the (not yet wired) EMS feed publishes per-incident response time — only annual averages in PFD’s public reports.
Would unlock "where does PFD arrive fast vs. slow" and let us compare against published NFPA targets per call type.
Where to look
- › PFD annual report PDFs — Aggregate only; would need extraction.
- › PFD FOIL request — Per-incident dispatch / on-scene timestamps.