Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

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

Open
DorAdam opened this issue Dec 19, 2020 · 10 comments · May be fixed by #1726
Open

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

DorAdam opened this issue Dec 19, 2020 · 10 comments · May be fixed by #1726
Assignees
@rsperer
Labels
backend infographics-API road-map

Comments

@DorAdam
Copy link

DorAdam commented Dec 19, 2020 •
edited by atalyaalon
Loading

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
WhatsApp Image 2020-11-21 at 20 03 29 (1)

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
Copy link
Collaborator

Great! Thank you @DorAdam

@atalyaalon
Copy link
Collaborator

@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

Screen Shot 2020-12-26 at 17 09 53

@atalyaalon atalyaalon changed the title Widget: Total accidents involving pedestrians comparison - city vs specific road per accident severity Widget: Total accidents involving pedestrians comparison - city vs specific street per accident severity Dec 26, 2020
@rsperer
Copy link

rsperer commented Dec 27, 2020

@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
Copy link

rsperer commented Dec 29, 2020

@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
Copy link
Collaborator

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

@atalyaalon
Copy link
Collaborator

@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
Copy link
Collaborator

MichalOren commented Dec 30, 2020 •
edited
Loading

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

@atalyaalon
Copy link
Collaborator

@MichalOren great! Thanks!

@atalyaalon
Copy link
Collaborator

@galraij any comments?

@atalyaalon
Copy link
Collaborator

atalyaalon commented Jan 6, 2021 •
edited
Loading

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

@rsperer rsperer linked a pull request Mar 6, 2021 that will close this issue
Open
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@rsperer rsperer

Labels
backend infographics-API road-map
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

1647 pedestrian city vs street accident widget rsperer/anyway
4 participants
@rsperer @atalyaalon @MichalOren @DorAdam