# Data Tracker | Annual Signal and PHB Request Ranking

![](/files/-MKq2gjXnTYSsqC9T-xA)

## 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)

![](/files/-MKq2lgeVGV8b7wWsZB4)

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*.

![](/files/-MKq2qUJKFGdxZ3OVMYS)

 Map `REQUEST_ID` to `SIGNAL_REQUEST>REQUEST_ID`.

![](/files/-MKq2veM8m8OjeJMbXC0)

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

![](/files/-MKq2zmTIcIylZPQTfdU)


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://atd-dts.gitbook.io/atd-knack-operations/data-tracker/builder-notes/data-tracker-or-annual-signal-and-phb-request-ranking.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.