Sent:
To: Mac Corthell
Cc: Adam Shultz
Subject: RE: ACFR - Measurable Goals
Importance: Normal
For Cindy!
System
| Measure
| 2018
| 2019
| 2020
| 2021
| Units
| Source
| Can be reported Monthly?
|
Sewer
| Sewer TV inspected:
| No Data
| No Data
| 1500
| 5,280
| FT
| 2021 Annual I/I Report*
| Yes, but may be unflattering without process changes
|
Sewer
| Sewer Cleaned
| 9733
| 9727
| 9727
| 11,616
| FT
| “”
| “”
|
Sewer
| Mainline Replaced
| No Data
| 200
| 2900
| 0
| Ft
| “”
| “”
|
Sewer
| Manholes Repaired
| 101
| 0
| 105
| 20
| Ea
| “”
| “”
|
Sewer
| Laterals Repaired
| No Data
| 4
| 9
| 10
| Ea
| “”
| “”
|
Sewer (Plant)
| Biosolids Removed
| 866.34
| 280.00
| 411.46
| 27.84
| Dry Tons
| 2021 Annual Biosolids Report*
| Yes, from Accounting Records
|
Sewer (Plant)
| Wastewater Recycled
| 110,279,000
| 112,303,000
| 114,091,000
| 125,891,000
| Million gallons
| 2021 Annual RWUP Report*
| Yes, from DMRs
|
Streets
| Asphalt Maintenance Overlay
| 5760
| 2420
| 1,758
| 2154
| Ft (22’ wide)
| Accounting records, query t
| Yes, but may be unflattering without process changes
|
Streets
| Cold Mix Potholes Filled
| 254
| 385
| 360
| 279
| Ea
| Accounting records, query t
| Yes
|
Street
| Roads Swept
| Coming soon
| Curb line miles
| Work Order Records
| Yes
| |||
Water
| Total Drinking Water Produced
| 382,572,480
| 379,959,591
| 349,201,849
| 325,626,159
| Gallons
| State Report q
| Yes
|
Water
| Service Orders Processed (meters on/off, installs, etc)
| 689
| 820
| 625
| 807
| Ea
| Accounting records, query w
|
|
Water
| Water Meters Read
| No Data
| 26622
| 35453
| 35853
| Ea
| Accounting records, query x
|
|
Storm
| Catch Basins Cleaned
| No Data
| No Data
| No Data
| Coming soon
| Ea
| Accounting records, query f
| Yes, but may be unflattering without process changes
|
Storm
| Sweeping Debris Removed
| No Data
| No Data
| 340,000
| 110,000
| Lbs
| 2021 TMDL Report*
| Yes
|
Parks
| Dog Poo removed from Park
| No Data
| No Data
| No Data
| 22,745
| Bags
| Accounting records, query r
| Yes, but will come in jumps as bags are purchased
|
Parks
| Acres Mowed
| No Data
| No Data
| No Data
| Coming Soon
| Acres
| Machine hours per acre
| Yes
|
Administrative
| Total number of work orders completed
| 3773
| 3984
| 4105
| 3906
| Ea
| z Administrative Report
| Yes
|
Administrative
| After Hours Callouts Processed
| Coming soon
| Ea
| Accounting records, query c
| Yes
| |||
Administrative
| Underground Locate Tickets Processed
| Coming soon
| Ea
| Managetickets.com reports u
|
| |||
Capital Projects
| Road Installed
| Coming soon
| Miles or feet
| From Project “Tracked Items” b
| Yes, but may be unflattering without process changes
| |||
Capital Projects
| Sewer installed
| Coming soon
| “”
| “”
| “”
| |||
Capital Projects
| Water Mains installed
| Coming soon
| “”
| “”
| “” | |||
t select Description, sum(Amount),
'asphalt=$190 per ton (a ton will pave 422 sf 2" thick. Which is 19ft of a 2ft wide roadway),
coldmix=$240 per ton (which will fill 30 pot holes), rock=$16/ton, sidewalk=$12 psf, '
from GL0_MolallaOR.dbo.tblTransaction where GLAccount='1044015203300' and Date>='2021-01-01 00:00:00.000' and Date<='2021-12-31 00:00:00.000'
group by Description
q https://apps.wrd.state.or.us/apps/wr/wateruse_query/. Note, convert Acre Feet to Gallons by multiplying by 271328
w Under development. Number is estimate.
z http://clarity/prd/CouncilReport
b Entered by Project Managers in the “Closeout” tab on the Projects Module, therefore an easy query for management. Development in progress.
c Query coming soon.
r Query coming soon. 1 mutt mitt is $.16 Mutt Mit is the name of the vendor, use either GL or PO system.
u Locate tickets: ashultz@cityofmolalla.com, pw: Molalla. Coming soon.
n select count(*) from tblServiceOrder where DueDate>='2021-01-01' and DueDate<='2021-12-31'
x select count(*) from UM0_MolallaOR.dbo.tblMeterActivity where Date>='2021-01-01' and Date<='2021-12-31'
f this will likely be based on the debris disposal accounting