search

hackoregon / emergency-response

Simulations, Models, and Visualizations of Portland Fire and Rescue data
11 stars 10 forks source link

Figure out how to know what vehicle types showed up at an incident #78

Open hannahkane opened 7 years ago

hannahkane commented 7 years ago

@futurechris - can you please add detail to this ticket by describing the work to be done? thanks!

futurechris commented 7 years ago

Proposed solution: create a new table that maps from responderunit.responderunit_id to a long description, based on the sheet Mark provided for us (here: https://drive.google.com/drive/u/0/folders/0Byy4RAOeNM0yTTdTc1ZGelFKUWc )

To translate these, responderunit.description (e.g., "M300") becomes a long-form nice description like "AMR Ambulance 300" (example - not sure this is a correct mapping).

We should also include a nice name of the responderunit.agency_id, e.g. "Sandy FD", etc., where available.

Some of these may be tricky - if so, we can record them here and discuss/get Mark to help us.