> For the complete documentation index, see [llms.txt](https://atd-dts.gitbook.io/atd-knack-operations/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://atd-dts.gitbook.io/atd-knack-operations/data-tracker/builder-notes/data-tracker-or-annual-signal-and-phb-request-ranking.md).

# Data Tracker | Annual Signal and PHB Request Ranking

Old guide - 12/10/2019, moved over 10/29/2020.

![](https://3087753818-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LzNSSXajDFpzOv2IhIv%2F-MKq1R-Tzsr1vRnx6wAM%2F-MKq2gjXnTYSsqC9T-xA%2Fimage.png?alt=media\&token=42e5af60-8503-4d9c-af9a-cbed8e59f2fc)

## Overview

Every year, AMD ranks [all active ("Under Evaluation") requests for Traffic Signals and Pedestrian Hybrid Beacons](https://data.mobility.austin.gov/data-tracker/#home/signal-requests/?view_39_filters=%7B%22match%22%3A%22and%22%2C%22rules%22%3A%5B%7B%22field%22%3A%22field_2022%22%2C%22operator%22%3A%22is%22%2C%22value%22%3A%22UNDER%20EVALUATION%22%2C%22field_name%22%3A%22REQUEST_STATUS%22%7D%5D%7D\&view_39_page=1).

In Data Tracker, requests are stored in the `signal_requests` object and evaluations are in a connected object. Since criteria are different for PHBs and signals, there are stored separately in `signal_requests_phb_evals` and `signal_requests_traffic_eval`.

### Bulk Create the evaluation records

To expedite the process for AMD, we bulk create evaluation records. This can be done using the following steps:

* Export two CSVs of all requests "Under evaluation", one for signals and one for PHBs
* In Excel, delete all columns besides `REQUEST_ID`
* Add two new columns, `RANK_ROUND_MO` and `RANK_ROUND_YEAR`
* Set `RANK_ROUND_MO` values to `DEC` and `RANK_ROUND_YEAR` values to `2019` (current year)

![](https://3087753818-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LzNSSXajDFpzOv2IhIv%2F-MKq1R-Tzsr1vRnx6wAM%2F-MKq2lgeVGV8b7wWsZB4%2Fimage.png?alt=media\&token=3eb744f7-08ec-4a0e-9f63-08862e6013e8)

Import the CSVs to the `signal_requests_phb_evals` and `signal_requests_traffic_eval` tables. Under *Select a field to match records* select *Don't match, add all imported records*.

![](https://3087753818-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LzNSSXajDFpzOv2IhIv%2F-MKq1R-Tzsr1vRnx6wAM%2F-MKq2qUJKFGdxZ3OVMYS%2Fimage.png?alt=media\&token=83de8f34-a6fd-45d0-a4c3-27f4c38610e7)

 Map `REQUEST_ID` to `SIGNAL_REQUEST>REQUEST_ID`.

![](https://3087753818-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LzNSSXajDFpzOv2IhIv%2F-MKq1R-Tzsr1vRnx6wAM%2F-MKq2veM8m8OjeJMbXC0%2Fimage.png?alt=media\&token=1ec6e122-1221-4570-831c-11a0e2ad942b)

Et voilà! Now you have nice evaluation records ready to go. These can be edited using the Edit link on the Details page. 

![](https://3087753818-files.gitbook.io/~/files/v0/b/gitbook-legacy-files/o/assets%2F-LzNSSXajDFpzOv2IhIv%2F-MKq1R-Tzsr1vRnx6wAM%2F-MKq2zmTIcIylZPQTfdU%2Fimage.png?alt=media\&token=fc3c567b-864e-4457-9a1c-c23ad5eadeb6)