Volunteer Needed

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:

• Sample Dataset (.csv file 785KBytes)

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(?):

• Sample Crash Map

IIRC I created it in the windows application; and at some point it all gets saved to the cloud.

QGIS

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

• Sample QGIS map

ArcGIS Pro

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)

GIS Cloud

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:

Google My Maps example Tempe Bike crashes

BatchGEO

Has many very cool features, see this example for 10 years of bike-MV crash data, but limited to Cochise County:

• • Cochise County (mostly Sierra Vista) Bike-MV 2013-2022 complete

Here’s the major rub: the free version only supports 250 rows, which just out of coincidence is just enough to cover 10 years(!)

Paid versions are quite expensive and recurring (monthly). There is a rumor non-profits can get the license for $15.

It seems to have many of the features fusion tables had, with even better filtering.