Saturday, May 24, 2014

What Hits Bikes (in Queensland)

To answer that question, you go here: http://www.unorthodox.com.au/map/what_hits_bikes/

I warn you, it's layer intense - and probably needs a legend (although you can figure it out by clicking and thinking) and it should even come up area-appropriate for you.

Big kudos to Google for making the tech so public and useful.

If you want to delve into the source data for this map, check out here:
https://www.google.com/fusiontables/DataSource?docid=1GRnw_Z6ykR-eBiGMKcIMEmAGoHXNC6vspM3UrTkF#map:id=13

This is a filtered extract from the full TRM dataset which can be viewed here:
https://www.google.com/fusiontables/DataSource?docid=1QizaOJA0-1IStwn0PukyjpkBiNPU3fBSMLJSmGqI#map:id=13

... but you will quickly see why I made the extract, because it's slooowww.

TMR Crash Data Analysis Results (or: Bicycles! Bicycles! Bicycles! )

These maps are generated from the Queensland TMR Road Crash Location data, obtained from:
https://data.qld.gov.au/dataset/crash-data-from-queensland-roads/resource/e88943c0-5968-4972-a15f-38e120d72ec0?inner_span=True



If you are all googlified, you can access the Fusion Tables here:
https://www.google.com/fusiontables/data?docid=1QizaOJA0-1IStwn0PukyjpkBiNPU3fBSMLJSmGqI#map:id=10
(and potentially build your own views by example)

All incidents recorded a "casualty", but the few "fatalities" are marked with a big flag. In most cases, I would assume the fatality (or casualty) was the person on the bicycle, except perhaps in motorcycle vs bike where it could be the faster-moving vehicle. Unfortunately the data does not assign casualties to vehicles (well, not obviously) but again, it's very probable that if there were casualties, one of them was the person on the bike.

Sometimes it is hard to concentrate on the data analysis, and try not to imagine what each of those little flags actually mean...

[Update: the maps that used to be here were just not working well enough... go to http://www.unorthodox.com.au/map/what_hits_bikes/ to see all in one map]

Sunday, May 18, 2014

Astromech in Two Minutes

I finally announce my latest project. Ready for users.


Contact me if interested. Hoping to write a manual shortly.