too many projects, not enough money · 2019-10-24 · too many projects, not enough money practical...

June 21, 2018

2018 ASFPM

Too Many Projects, Not Enough MoneyPractical Solutions to Optimize Limited Funding

Near Southside Regional Drainage Study

Agenda

22

Background & Objectives

Prioritization System

Results

Conclusions

Database

Background & Objectives


Stormwater Mission

• To protect people and property

from the harmful effects of stormwater

44Lubbock at Devitt (2004)


Prior Planning Efforts

• 89 reports, 500 investigated alternatives

55


Allocating Limited Resources

• 200 potential projects, $450 M

66


Objectives

Objective and repeatable process as a

foundation for decision-making

Understandable system which can be

communicated internally and externally

Ability to reference and update

on a daily basis

77


Objectives

• Guide projects through the life cycle

88

STRATEGIC FEASIBILITYPROJECT

DEVELOPMENTCIP

What & Where?• Objectives• Constraints• Preferred strategy• Extents• Conceptual cost

Fatal Flaws?• External coordination• Land acquisition,

ROW• Community

opposition/support• Refined cost

Exactly How?• Utilities• Constructability• Scheduling• Implementation risks• Geotech• Cost

Prioritization System


Challenges

1010

Information

Complexity

Objectivity Objective

Complex

More

Subjective

Simple

Less


Prioritization Process

1111

Establish Criteria

Establish Scoring Process

Determine Weighting Factors

Project Priority Rankings


Criteria Selection

• Aligned with broader City objectives,

focused on the Stormwater mission

1212

5 criteria

18 criteria


Criteria Weights

1313

Road Hazard(30%)

Structure Flooding

(30%)

Rehab(15%)

Cost Efficiency

(15%)

CustomerSatisfaction

(10%)


Mapshed

1414

Criteria Metric

Road Hazard

Low water crossings

High water rescues

Fatalities

Structure FloodingAt-risk structures

Repetitive loss areas

Rehab Criticality

Capacity Pipe grades

Customer Satisfaction Reported flood incidents


Mapshed Prioritization

1515

• Identifying future

planning efforts using

available spatial datasets


Scoring Criteria & Metrics

1616

Criteria Metric

Road Hazard Risk-based hazard reduction

Structure Flooding Risk-based flood reduction

Infrastructure Rehab Criticality

Cost Efficiency Score-to-cost ratio

Customer SatisfactionSupport/opposition,

Reported flood incidents


Scoring System

1717

Criteria Score WeightWeighted

Score

Road Hazard 35 30% 10.5

Structure Flooding 50 30% 15

Rehab 20 15% 3

Cost Efficiency 50 15% 7.5

Customer Satisfaction 50 10% 5

TOTAL 41

Results


Ranking

1919


Ranking

2020

0

20

40

60

80

100

0 50 100 150 200

Sco

re

Rank


Data Entry

2121

• Varying levels of information


Data Class

2222

Data Class Description

0 Limited information, no model

1 Limited information, model available

2 Adequate information, no model

3 Adequate information, model available

4 Partial spreadsheet documentation

5 Complete spreadsheet documentation


0

1

2

3

4

5

0 20 40 60 80 100

Dat

a C

lass

Score

Data Class

2323

Database


Data Entry

2525


Photos

2626


Project Location

2727


Filters

2828


One Page Report

2929


Ranked List

3030


Project Assessment Form

3131

STRATEGIC FEASIBILITYPROJECT

DEVELOPMENTCIP


Spreadsheet Export

3232


Potential Extensions

3333

Conclusions


Conclusions

• Objective foundation for decision-making

in alignment with the Stormwater mission

• Facilitates transparent disclosure of

decision-making criteria

• Risk-based metrics focus on chronic issues

• Statistics-based rules enable flexibility and

an accurate picture of relative benefits

• Database improves access to information

3535

Chris Johnson, P.E., [email protected]

Scott Hubley, P.E., [email protected]

Mark Pauls, P.E., [email protected]

too many projects, not enough money · 2019-10-24 · too many projects, not enough money practical...

Documents