NYCPlanning / db-equitable-development-tool

Data Repo for the equitable development tool (EDDT)
MIT License
0 stars 0 forks source link

Public Safety: Pedestrian injury #93

Open AmandaDoyle opened 2 years ago

AmandaDoyle commented 2 years ago

Description: Pedestrian injury hospitalization per 100,000 residents

Logic: See Public Safety: assault #94 for details

Source(s): https://a816-dohbesp.nyc.gov/IndicatorPublic/VisualizationData.aspx?id=2093,4466a0,101,Summarize for number of Pedestrian injury hospitalizations

Year(s):

Geographies:

Race and ethnicity breakdown: No Denominator: NA

SME: DOHMH

Questions: What does the note "Contains numerous measures" in the Notes columns on the data matrix mean?

refers to the fact that pedestrian injury is sort of an amalgam

Roadblocks:

SashaWeinstein commented 2 years ago

It doesn't seem like the there is an API so the .csvs will have to be downloaded one by one. I can approach the same way I did traffic injuries, where I write put the source data in the repo, write the logic, and then finally and then route them through data library once I have the logic working. Let me know if that's not a good approach @AmandaDoyle

SashaWeinstein commented 2 years ago

Also the portal only has 2016 data which is curious?

SashaWeinstein commented 2 years ago

Dealing with PUMA that combine multiple CD's by averaging, let me know if that's not correct