[Enhancement] Refactored Signal and PHB Ranking Functionality

atdservicebot commented 4 years ago

In Project: Data-Informed Pedestrian Signal Prioritization, DTS worked with AMD to develop a data driven process to prioritize locations for pedestrian hybrid beacon installation. Using various sources for data, we developed criteria to map and identify the street segments where we should consider a PHB. This data is compiled and mapped in GIS.

We would like to have this GIS data interface with Data Tracker so we can track and communicate locations for study and push data to the public.

Describe the solution you have in mind. Work with DTS staff to identify modifications to existing data tracker pages and data and identify if other data is needed in data tracker.

How will we know that our solution is successful? If we are able to track identified locations for study and make this information publicly accessible

Users AMD, VZ, TED, ATSD, SRTS, ATD Development Review

Sponsorship

Jen D.

Level of Effort 20 hours each from Knack builders, Devs, and PM. 10 hours from GIS analyst.

Timeframe Not immediately blocking anyone’s work, but would have ideally by Dec 2020.

Requested by Renee O., AMD Request ID: DTS20-100735

dianamartin commented 4 years ago

@jaime-mckeown Is this something you were working with Renee on?

jaime-mckeown commented 4 years ago

@dianamartin Yes, it started with Renee asking for a map, then it turned into asking for lots of changes to Data Tracker to integrate the new PHB process. John told me to have Renee submit a new request for the Knack changes.

dianamartin commented 4 years ago

Diana's Notes

Traffic Signal Request page (keep page)

311 based signal and phb requests page
Lose/Remove PHB Evaluations and PHB Studies on this page
Keep PHB Evaluation records, don't need to edit or frequently access

FUTURE PROCESS

PHB Scoring isn't going to be part of Data Tracker
Will work with Signal Engineers, Council Districts to review
- Come up with highest ranking street segments based on GIS Data

Signal Studies (new tracking page)

PROPOSED IDEA

Create a location
On location details
- Add New Signal Study a this location
- Creates New Signal Study record
- Reference Renee's spreadsheet (which has many fields from the signal_request_signal_study
- Create new signal_studies object table

CURRENT TABLE ORGANIZATION

Locations>Signal Requests Signals>Signal Requests

Difference between Signal Studies and PHB Studies - they can exist on the same table? No, that's not how it is currently.

Would want to switch out Signal Requests to Studies or Locations.

FUTURE TABLE ORGANIZATION

Locations>Studies Studies>Traffic Studies Studies>PHB Studies

Migration Effort

We will probably have to export the signal_request_signal_studies and the signal_request_phb_studies` table, manipulate in excel.
Reimport to created Studies table
Export Studies table
Update signal_studies table with connected ID to Studies table
Update phb_studies table with connected ID to Studies table
Import signal_studies to create new studies_signal_studies table
Import signal_studies to create new studies_phb_studies table

amenity commented 4 years ago

@jaime-mckeown - don't expect you to do anything with this request, but wanted to make you aware that we'll be doing some Knack work to support Data-Driven PHB Ranking. ;)

amenity commented 4 years ago

@johnclary - can you provide a general level of effort assessment for this?🙏

(& while you're at it, maybe notes here.)

johnclary commented 4 years ago

I estimate 20 knack builder hours, 20 dev hours, 20 pm hours, 10 GIS hours.

johnclary commented 4 years ago

Updated the AMD doc accordingly. Thanks.

johnclary commented 4 years ago

added to doc:

Based on discussion with Renee, we estimate 20 hours each from knack builders, devs, and PM. 10 hours from GIS analyst. Our understanding is that this is not immediately blocking anyone’s work, but would have ideally by Dec 2020. (correct us, AMD, if we’re wrong).

johnclary commented 4 years ago

@amenity note that this could be a good one for JD

amenity commented 4 years ago

@johnclary - let's catch up on this one ... I should tell Renée if we know we won't be able to do it in time.

amenity commented 4 years ago

Spoke with @johnclary and this is too heavy a lift for us to tackle for the 2020 round of PHB ranking. He's going to email AMD to let them know where we're at.

johnclary commented 4 years ago

$status_update

We’ve collected requirements for refactoring both the PHB ranking process and the signal ranking process. Diana is meeting with Renee again this morning to get clarification on the PHB ranking process. We are focusing on Data Tracker improvements and may temporarily take the Signal Request Dashboard and public dataset offline while we update those assets to capture the program updates.

amenity commented 4 years ago

@johnclary is going to update this.

johnclary commented 3 years ago

Currently waiting for Renee to give us the go-ahead to proceed with the Data Tracker updates for signals scoring.

amenity commented 3 years ago

@johnclary - let us know if there's anything @dianamartin can help with here.

amenity commented 3 years ago

From 6/1/21 AMD P&P Meeting

We've begun work to migrate the data publication to our new automated process. Meeting with Renee again this week to review some proposed changes to the data structure.

amenity commented 2 years ago

@johnclary - would you mind converting this to a project index?

cityofaustin / atd-data-tech