URGENT: Google has announced the tool used to present the crash maps on Azbikelaw, called “Fusion Tables” is being discontinued Dec 3, 2019.
Azbikelaw is looking for a volunteer familiar with GIS and web-presentation to help effect transition to something else.
That something else would likely need to be free-to-use, either open source or free-commercial. Commercial tools run the cost gamut from prohibitively expensive to free for non-commercial use, which this application would be.
Ideally the replacement would offer all the features of fusion tables; which includes in addition to mapping, rudimentary filtering; for example find all crashes occurring at night in some particular city where a motorist was turning left in years 2010-2015.
Contact azbikelaw by leaving a comment or email
Here are some things I quickly tried
Created a sample dataset that included all bike-MV crashes in city of Tempe 2009-2017 simply by filtering the crashmap, there are 1769 incidents:
Tableau – Public
Is a free version of Tableau’s commercial product. I didn’t get very far but each crash has a style-able tool tip. For some reason the streets don’t show up(?):
IIRC I created it in the windows application; and at some point it all gets saved to the cloud.
QGIS is a free open-source cross-platform application; I used the linux application to create a sample map and then used a plugin (called what?) that exports the map to a web-based map using either leaflet or OpenLayers, in this example I chose leaflet
I tried a 30 day trial of ArcGIS pro, installed the application and messed around a little bit, then my 30 days ran out. As far as I understand, it (“pro”) would be prohibitively expensive anyway.
ArcGIS Public / Online
I’m not sure if these are two different things or not but in any event this seems to be free:
- Sample ArcGIS “online” map (updated to include whole state)
as its name implies, it’s an online deal (no application, as far I can tell). Login at giscloud.com with user cazbikeweb
Google’s “fusion table archive tool”
So I did the “fusion table archive tool” exported 11/25/2019… it leaves an index spreadsheet file in ft-archive folder on google drive… The only trouble compared with full fusion tables, is it can’t be updated, and it doesn’t have any filtering capability:
- exported FT archive tool : AZ cyclists 2009-2018
- exported FT archive tool: AZ pedestrians 2009-2018
- exported FT archive tool: Tempe all MV 2010-2017
- (master Index of all former fusion tables)
Google My Maps
Seems to be very limited, something about 2,000 points; but maybe each layer up to 10 layers(?). In the example, it’s been “styled by” InjurySeverity with custom color code using same scheme as fusion table (blue – green – yellow – red – black), with a “point” icon: