search

data-for-change / anyway

ANYWAY - Car accidents map
http://www.anyway.co.il
MIT License
77 stars 242 forks source link

EURO DEMO motorcycle accidents on road 20 by sections #1503

Open ChayneAzriel opened 3 years ago

ChayneAzriel commented 3 years ago

Name motorcycle accidents on road 20 by section (excluding junctions)

Title motorcycle accidents on different parts of road X

Visualization motorcycle_road_20

Methodology top 5 accidents count of accidents which motorcycles were involved in

Use case motorcycle accident on road X when the percentage of motorcycle accidents on road X is greater than 1.1 times the percentage of the motorcycle accidents in all of the roads

SQL query query on redash

modified parameters: road1 language specific fields: road_segment_name

Additional context representing only top counts of each part of the road, other types are combined under 'other' name of the widget in the code (with the mock data) is top_road_segments_accidents

atalyaalon commented 3 years ago

mock data: https://github.com/hasadna/anyway/pull/1521/files

ziv17 commented 3 years ago

@atalyaalon What is the actual task?

atalyaalon commented 3 years ago

@ziv17 we need to improve this and other issue together with the data team - we'll discuss it in the coming meeting.

atalyaalon commented 3 years ago

@ChayneAzriel same here - can you create a new issue using the new template you created? Note that we need to send the top 5 segments, and not all segments. The name of the widget in the code (with the mock data) is top_road_segments_accidents This name is required so the BackEnd will be able to match the issue to the mock data that already exists.

Mock data was created in this PR