Import and tidy initial data - Githubissues

Metropolitan-Council / service.allocation.viz

Scrolly-telling viz for comparing scenarios in the service allocation study

https://metrotransitmn.shinyapps.io/bus-service-allocation-study/

Other

2 stars 0 forks source link

Import and tidy initial data #1

Open eroten opened 3 years ago

eroten commented 3 years ago

@dpena523 is working on cleaning up Excel workbooks

dpena523 commented 3 years ago

service_eval_base.xlsx service_eval_by_tma.xlsx this is the base data

dpena523 commented 3 years ago

service_eval_base.xlsx

This an updated service_eval_base file, this one includes a new entry, "Regional Total", which isn't included in the original file and is needed for one of the calculations

dpena523 commented 3 years ago

service_eval_clean.xlsx

Clean data for the slider tool; can be used for Expanded Access Metric, Improved Transit Service Metric, and Increased by Service Type Metric

dpena523 commented 3 years ago

service_eval_clean Metadata

Scenario "X" Expand: population that has new access to service per each scenario
Scenario "X" Improve: population that has improved service in each scenario
Scenario "X" High Freq/Local/Basic/CE: population that has access to each level of transit service
pop_total: overall population
X_pct: percent of improvement
emp_total: overall employment
poc_total: BIPOC affected
pov_total: Low Income population affected
aff_hu: affordable housing units affected
senior_total: senior population affected
lo_emp_total: low income jobs affected
hi_emp_total: high income jobs affected
pop_tma_X: population affected in transit market area X
emp_tma_X: jobs affected in transit market area X

dpena523 commented 3 years ago

scenario_def.xlsx

Scenario definitions

dpena523 commented 3 years ago

scenario_rdrshp.xlsx Ridership increases for each scenario

dpena523 commented 3 years ago

job_access.xlsx figures for job access measures

dpena523 commented 3 years ago

DRAFT Intermediate Scenario Evaluation Memo_20201230.docx

This is the Draft Scenario Evaluation Memo prepared by the consultant, provides some useful context for the analysis.

dpena523 commented 3 years ago

Service Allocation Slider Mock Up.pptx

Mock up of slider tool

dpena523 commented 3 years ago

Service Allocation Web Tool Text.docx Proposed text for the slider tool. Please disregard inserted chart, we are still coming up with a visualization idea, I will have something by end of day

dpena523 commented 3 years ago

Slider tool webtext: new text for slider tool; this is good for now, there is a main change in that we want to reconsider what the scenarios are called, so scenario names are still TBD in this version Service Allocation Web Tool Text 3-2-21.docx