District 2 - Redding
Contents
District 2 - Redding¶
How does funding for local agencies differ district to district? Using E-76 obligation data, we can gain insight to how agencies in District 2 use federal program funds, and help identify DLA‘s core customers.
Quick Stats
Number of Unique Prefix Codes by Agency
| Agency | Number Of Unqiue Prefix Codes |
|---|---|
| Tehama County | 16 |
| Redding | 12 |
| Shasta County | 11 |
| Trinity County | 11 |
| Siskiyou County | 9 |
Number of Unique Agencies by Prefix Codes
| Prefix | Number Of Unqiue Agencies |
|---|---|
| RPSTPL | 12 |
| ER | 11 |
| ACSTP | 10 |
| BRLO | 9 |
| BRLS | 9 |
Top 5 Types of Work
| Type Of Work |
|---|
| Bridge Replacement (tc) |
| Bridge Replacement |
| Bridge Preventive Maintenance |
| Shoulder Widening |
| Roadway Rehabilitation (tc) |
Obligations¶
Obligations indicate a unique entry in the E-76 dataset. By counting the obligations for each year, district, and organization, we can see what the volume each as well which organizations are the most and last frequent customers.
Metrics:
Obligations by Year
Number of Unique Agencies by District
Agencies With The Most Obligations
Number of Obligations by Year¶
Number of Unique Agencies by District¶
Agencies With The Most Obligations¶
Prefix Codes¶
Prefix Codes refer to the program an obligation is in. Similar to the number of obligations, calcuating the unique prefix codes provides insight to how many progams DLA is involved in each year as well as workload at the district and organization level.
Metrics:
Number of Unique Prefix Codes by Districts
Most Used Prefix Codes
Agencies With The Most Unique Prefix Codes
Number of Unique Prefix Codes by District¶
Most Used Prefix Codes¶
Agencies With The Most Unique Prefix Codes¶
Funding Distributions¶
With each E-76, three types of funding amounts are included in the obligations:
Total Requested (
total_requested)Advance Construction Requested (
ac_requested)Federal Requested (
fed_requested)
Using this information, we can determine how much on average an organization recieves with these funds, and the distribution of the funds.
Metrics:
Average Total Requested Funds by Agency
Lowest Average Total Funds by Agency
Average Total Requested Funds by Prefix
Average Total Requested Funds by Agency ($2021)¶
Lowest Average Total Funds by Agency ($2021)¶
Average Total Requested Funds by Prefix ($2021)¶
Work Categories¶
While the data includes a description column, organizations have the option to manually input the descriptions. Using the organizations descriptions of the obligattion type, we can categorize the obligations in terms of types of work. We used the following type of work categories:
Active Transportation
Transit
Bridge
Street
Freeway
Infrastructure/Resiliency/Emergency Relief
Congestion Relief
With these categories, we can determine which organizations have the most obligations in that category and what percent of the category that organization accounts for.
/opt/conda/lib/python3.9/site-packages/altair/utils/core.py:228: UserWarning: I don't know how to infer vegalite type from 'empty'. Defaulting to nominal.
warnings.warn(