Widget: Total accidents involving pedestrians comparison - city vs specific street per accident severity

[DorAdam]

Name Percentage of severe and fatal accidents involving pedestrians on a certain road compared to the rest of the city.

Title Total accidents involving Pedestrians by accident severity - street ___ vs city

__ השוואת מספר התאונות עם הולך רגל לפי חומרה - רחוב ___ בהשוואה לעיר

Visualization

Visualization explanation Explain visualization content.

Use case When the percentage of severe and fatal accidents on road_x is greater than 1.5 times the percentage of severe and fatal accidents in the city.

SQL query query on redash modified parameters: street1,street2, accident_yishuv_symbol. Additional context

[atalyaalon]

Great! Thank you @DorAdam

[atalyaalon]

@MichalOren can you create a visualization of 2 pie chart using the existing 2 pie chart in our site (see image) Just like you created here? Ask @DorAdam for the title

[rsperer]

@atalyaalon we currently have 3 widgets related to pedestrian injuries and all currently return mock data. As far as I can tell all are different from the one described here. Do I add a new one or should it come instead of an existing pedestrian query?

[rsperer]

@atalyaalon @DorAdam In the news flash I have street1/2_hebrew and yishuv_name rather than symbols. Can I use them in the query?

[MichalOren]

Hi 2 display option: pie or donut? which one "is better" ? Note: The title is only temporary

[atalyaalon]

@MichalOren the pie - the front end will be similar to the one above of the frontal accidents. In addition - we'll sum the fatal and severe accidents together - so only 2 categories.

[MichalOren]

Hi, let me know what do U think עדיין חושבת על הכותתרת. לא סופי

[atalyaalon]

@MichalOren great! Thanks!

[atalyaalon]

@galraij any comments?

[atalyaalon]

@rsperer I suggest using exactly the same structure of API as in head_on_collisions_comparison widget