I implemented a SQL view in our Postgres database for the local 911 call data, all public information delivered in a cleaner form by the good people of Wayne County EMS.
The query to do it:
CREATE VIEW callinfo AS SELECT b.id, our_complaint, date, time, address, city, b.agency_abbrev FROM calls a JOIN call_details b ON a.id = b.id ORDER BY b.id ASC;
A selection of the output:
select agency_abbrev from callinfo where id='15-00000032'; agency_abbrev --------------- CAMB WCSD (2 rows)
Enjoying these databases – in no small part because it provides such a direct application of set theory.
Also, as promised in the testing post, the source code for some testing is now available. It is not the source code for those visualizations but, instead, the code for the Iceland test visualizations. It is now in our GitLab.