The URL can be used to link to this page

Home My WebLink About2025-061-06/03/2025-ADOPTING THE TRANSPORTATION CAPITAL IMPROVEMENT DASHBOARD AS A METHODOLOGY AND FOUNDATION FOR THE TRRESOLUTION 2025-061 OF THE COUNCIL OF THE CITY OF FORT COLLINS ADOPTING THE TRANSPORTATION CAPITAL IMPROVEMENT DASHBOARD AS A METHODOLOGY AND FOUNDATION FOR THE TRANSPORTATION CAPITAL IMPROVEMENT PROGRAM PRIORITIZATION AND PLANNING A.The purpose of this item is to adopt the Transportation Capital Improvement (“TCI”)dashboard as a methodology and foundation for the transportation capital improvement program prioritization and planning. B.The TCI dashboard is a geographic information system (“GIS”)based project management tool that supports the TCI process.Exhibit A attached hereto and incorporated herein,is a technical memorandum that summarizes the methodology and standard operating procedures for the TCI dashboard.The TCI dashboard is a methodology for evaluating and prioritizing transportation capital projects identified in the City’s capital improvement type plans,including the Active Modes Plan (“AMP”adopted December 2022),Transportation Capital Projects Prioritization Study (“TCPPS”adopted September 2023),and Strategic Trails Plan (“STP”scheduled for City Council consideration in Summer 2025).The TCI dashboard uses criteria developed from the City’s various strategic plans and analyses that speak to the City’s strategic goals and inform the selection,implementation,and construction of transportation infrastructure improvements including City Plan,2024 Strategic Plan,Our Climate Future,Transit Master Plan,Vision Zero Action Plan,and the 15-Minute City Analysis. C.The TCI dashboard does not seek to prioritize maintenance work (street maintenance program),programmatic work (pedestrian sidewalk program and bridge program),primary transit infrastructure (bus rapid transit),or trails outside of arterial corridors.These efforts all have dedicated funding sources and are prioritized based on the specific evaluation criteria for those programs and projects.However,these efforts inform the scope of work of TCI projects (transit,trails,bridges),as well as the coordination/synergy of TCI projects (street maintenance program,pedestrian sidewalk program,transit). D.The TCI dashboard is a data driven approach to prioritize the various infrastructure projects recommended by the plans using criteria that aligns with the recommendations and goals of the City’s governing planning documents. E.The TCI dashboard was envisioned as a living tool that can be updated moving forward by including new projects and updating criteria to match future strategic planning efforts.Newly identified projects can be added as the various transportation infrastructure plans are updated.The criteria,weighting,and scoring can be updated to reflect updates in governing plans,and the prioritization list can be reordered to focus on funding opportunities and sources that emphasize specific criteria,such as air quality, safety,or active modes. F.The TCI dashboard includes consideration of environmental impacts and fiscal constraints,and the initial TCI dashboard criteria weighting and scoring was arrived at after careful consideration and robust discussion of the various groups that plan, deliver,and maintain transportation infrastructure for the City.The criteria includes: safety,greenhouse gas reduction health equity index,regional significance/alignment, synergy,coordination with Streets Department Maintenance Plan,coordination with Utilities Department Capital and Field Operations Projects,ability to further the goals of the Urban Forestry Master Plan,coordination with capital projects originating from other entities such as water and sewer providers like Fort Collins-Loveland Water District and private utilities such as Xcel,community benefits,bicycle access,and pedestrian access. G.Primary work on the TCI dashboard began in April 2024 and Olsson Associates was engaged to help develop and implement the tool.This work was first brought to the City Council’s attention in August 2023,as part of finalizing and adopting the TCPPS.Updates on progress on the TCI effort were provided to City Council in August 2024 as part of the update on the 15-Minute City efforts.In November 2024,City staff presented an update on the TCI dashboard to the Local Legislative Affairs Committee.City staff received feedback from Council at the January 14,2025,Work Session.City staff presented the TCI dashboard to the Transportation Board for additional discussion on April 16,2025,and the Board was receptive to the TCI dashboard and methodology. H.The City Council finds and determines that it is in the best interests of the City to adopt the TCI dashboard as a methodology and foundation for the transportation capital improvement program prioritization and planning,and that using the TCI dashboard advances the public’s health,safety,and welfare by facilitating improvement of the City’s multimodal transportation safety and infrastructure. In light of the foregoing recitals,which the Council hereby makes and adopts as determinations and findings,BE IT RESOLVED BY THE COUNCIL OF THE CITY OF FORT COLLINS that the City Council hereby adopts the Transportation Capital Improvement dashboard,as described in Exhibit A,as a methodology and foundation for the transportation capital improvement program prioritization and planning. Passed and adopted on June 3,2025. ATTEST: A./ ity Clef Effective Date:June 3,2025 Approving Attorney:Heather N.Jarvis Exhibits:Exhibit A -Transportation Capital Improvements Methodology Dashboard Standard Operating Procedure memorandum,dated May 20.2025 EXHIBIT A TO RESOLUTION 2025-061 •. M E IVI 0 ~OvernightElRegularMail El Hand Delivery El Other ____________ To:Dana Hornkohl,PE From:Chris Rolling,PE Jenna Friesen RE:Transportation Capital Improvements (TCI)Methodology Dashboard Standard Operating Procedure (SOP) Date:May 20,2025 Project #:City Proj No 9444-WO-Olsson-TCIP Olsson Proj.No.F21-06642 Introduction The Fort Collins Transportation Capital Improvements (TCI)consolidates multiple city transportation plans into a unified list This involves creating capital projects,developing performance-based scoring criteria, and integrating them into a fiscally constrained ten-year plan using a GIS-based dashboard.TCI is grounded in community objectives such as traffic safety,active transportation,emission reduction,support for community centers,and enhanced resiliency and sustainability,aligning projects with community goals and federa requ rements. This technical memorandum summarizes the methodology and Standard Operating Procedure (SOP) document for a Geographic Information System (GIS)based project management dashboard which supports the TCI process.This document provides a comprehensive guide to processes and tools,ensuring consistency in development and management of capital projects.It describes processes to develop the Project List,Scoring and Background GIS Layers,Scoring Rubric,and the interactive features of the GIS dashboard.The memo includes the following main topics. •Project List •Scoring and Background GIS Layers •Scoring Process •Dashboard &Functionality •Use Cases Project List The Project List was compiled using projects listed in the Active Modes Plan (AMP),Transportation Capital Project Prioritization Study (TCPPS),Highway Safety Improvement Program (HSIP)Funding Awards, proposed at-grade crossings from the Strategic Trails Master Plan,and the list of bridge improvements from the City Once al these projects were compiled,Olsson “grouped”projects by geographic location and by proposed project type Once projects were grouped,these became known as the 7Cr Project and were assigned an associated TCI number (e g.TCI-001,TCI-002,etc.).These projects were mapped in GlS and kept in an Excel spreadsheet with the TCI Project numbers and additional project details such as location, scope,project types,cost,and status 1880 Fali River Drive I Suite 200!Loveiand,CO 80538 Phone 970.461.7733/Fax 970.635.3709/oisson.com EXHIBIT A TO RESOLUTION 2025-061 Scoring and GIS Layers To establish a prioritization process,six scoring categories were developed which include&greenhouse gas reduction safety health equity index,community benefit,regional significance,and synergy.Each of these categories included one if,not multiple GIS layers to use in the scoring process.Those layers are listed in (he Table 1.These data layers were used in the scoring process which was completed in GIS using a combination of manual scoring and geospatially using intersect analysis. egory Dataset Format Sou ce Greenhouse Gas City Bus Routes and Spatial (~hapefilé)Fort Collins GIS Reduction Stops Greenhouse Gas 2045 Regional Silnificant Spatial (shapefile)Nirth Frint Range MP• Reduction Transit Corriftrs Safety LOSS lntersecti•ns Spatial (shapefile)F•rt C•llins 2122 Annual Ruiway Safety Rep.rt (PDF) Safety High Injury Network Spatial (shapefile)FortCollins GIS Equity Health Equity Index Spatial (shapefile)Fort Collins GIS Regional 2045 Regional Significant Spatial (shapefile)North Front Range MPO Significance Corridors Community Bike Scores Spatial (shapefile)F•rt C•llins 15-minute City Benefit Plan Community Pedestrian Scores Spatial (shapefile)Fort Collins 15-minute City Benefit Plan Synergy Street Maintenance Spatial (shapefile)F•rt C.llins Streets Efforts Maintenance Pr.gram Synergy Known Utility Projects Spatial (shapefile)Fort Collins GIS Synergy Forestry Land Cover Spatial (geodatabase)Fort Collins GIS Metrics Synergy Project Coordination Spatial (shapefile)Fort Collins GIS Projects TABLE 1 —SCORING CRITERIA DATA SUMMARY 1880 Fail River Dnve I Suite 200!Loveiand.CO 80538 Phone 970.461.7733?Fax 970.635.3709!oisson.com EXHIBIT A TO RESOLUTION 2025-061 Scoring Process The primary method when scoring the TCI projects was using the intersect analysis geospatial processing method,which is used to determine the common areas between different spatial datasets.Essentially,it overlays multiple layers of geographic information to identify where they overlap.In this process,the TCI Projects layer overlaid all the scoring layers listed in the table,and assigned a value based on the overlap. If a project overlapped a scoring layer,the scoring criteria was then applied to the TCI Project The scoring cr teria can be found in the tables below GHG Reduction Does the project support Does the project Does the project Score vehicle electrification?connect to transit?support active modes? iI~L.No 1 No ~r.2 ‘1*I No Yes ~r.3 No Yes Yes Yes 4 SYesYes TABLE 2—GHG REDUCTION SCORING RUBRIC The greenhouse gas reduction category was analyzed using spatial information such as transit routes and bus stops as well as active mode information to determine its score.If a project intersected a transit route or was within a short distance of a transit stop,then it would score higher Additionally,if the Project’s description had an indicator that it would support vehicle electrification,then it was scored accordingly. Safety Safety Elements Not HIN or Fl LOSS 3 or 4 Not on H1N,but Fl/LOSS 3 or 4 Scoren 2 OnHiN 3 On HIN andFl LOSS 3 On HIN and Fl LOSS 4 TABLE 3—SAFETY SCORING RUBRIC The safety score was determined using the city’s High Injury Network (HIN)as well as the Level of Safety Service (LOSS)at the top 50 intersections identified in the Fort Collins 2022 Safety Report.As indicated in the Safety Scoring table,if a project is along the HIN or near an intersection with LOSS 3 or 4,or a combination of these layers,the score reflects the Project’s relation to those safety concerns. 1880 FaIl River Drivel Suite 200/Loveland,CO 80538 Phono 970.461.7733/Fax 970.635.3709 /oIsson.com EXHIBIT A TO RESOLUTION 2025-061 Health Equity index Low Range High Range Score 60 1 61 75 2 90 3 91 95 4 96 100 5 TABLE 4—EQUITY SCORING RUBRIC Health Equity was scored using the City’s Health Equity Index.Each census tract IS given a HEI score (HElscore in attribute table).When a Project intersected the HEI layer,the TCI score wou d be determined based on the intersection of the HEI score (e g.TCI-057 intersects an HEI score of 54 therefore it gets a TCI score of 1).Note.if a Project intersected multiple HEI zones,the highest HEI score will determine the TCI Project score (e.g.TCI-001 intersects HEI scores of 15,54,92 and 100.Th s TCI project will get a score of 5). Alignment Score Not along a regiona significant route 1 Partially along a regional significant route 3 Along a regional significant route 5 TABLE 5—REGIoNAL SIGNIFIcANcE ScoRING RUBRIC The Regional Significance and Alignment layers were analyzed manually by reviewing each TCI Project and seeing if the project or a portion of the project was along a 2045 Regional Corridor identified by the North Front Range MPO. Community Benefit Walking &Biking Scores Rating Score .~I.Very Poor 1 36-60 Poor 2 61-80 Fair 81-90 Good 91-100 Very Good 3 4 5 TABLE 6—COMMUNITY BENEFIT SCORING RUBRIC The Community Benefit Scores were scoring using the geospatial intersect analysis method and determining the Project’s score based on the bike or pedestrian s layers score from the 15-minute City Plan.Like the HEI score,if the Project intersected multiple bike or pedestrian scores,the highest bike or pedestrian score was used for the TCI score (e.g.TCI-0O1 intersected 13 different bike scores,and the highest bike score in that intersect was 77.8,therefore the TCI-001 scored a 3 in the Bike Community Benefit category). Fali River Drivel Suite 2001 Loveland,CO 80538 Pho 0970.461.77331 Fax 970.635.37091 olsson.com EXHIBIT A TO RESOLUTION 2025-061 Synergy (Streets,Utilities,Other Projects) Value Not aligned with other projects. Partially aligned with other projects 3 Aligned with other projects S TABLE 7—SYNERGY (STREETS,UTILITIES,OTHER PROJECTS)SCORING RUBRIC Synergy (Forestry) Va ue 0-10 11-20 21 30 31-40 It TABLE 8—SYNERGY (FORESTRY)SCORING RUBRIC Synergy was scored using the Street Maintenance,Project Coordination,and Urban Forestry layers provided by the City.The Street maintenance and Project Coordination layers showed the locations of upcoming street maintenance as well as various projects listed by department and company throughout the city The Project Coordination layer was reduced to City projects that intersected the TCI Projects GIS layer and then those projects were categorized as street projects,utility,projects,or other projects.The Synergy Streets score was determined based on the TCI Projects’alignment with the Street Maintenance layer, while the Synergy Utilities and Synergy Other categories were scored based on the TCI Projects’alignment with the Project Coordination layer.The Synergy Forestry category was scored with the Urban Forestry layer’s canopy percent.The TCI Project layer was intersected with the Forestry layer and scored based on the percentage of canopy coverage.The higher score indicates the need for increased tree canopy for an area (e g TCI-OO1 intersecting canopy coverage percentages ranging from 20 to 37 percent.therefore receiving a score of 2). Once all the scoring analysis is completed,scores are recorded in the TCI Project spreadsheet under each category.A weighting was applied to the scores which is designed to create a project list that emphasize the criteria that directly reflect community’s needs and values The weighting scheme,designed to create a maximum score of 100,is shown in Table 9 below. Safety GHG HEi Regiona Synergy Synergy Synergy Synergy Community Community (Streets)(Utilities)(Forestry)(Other)(B’ke)(Pedestr an 3 TABLE 9—WEIGHTING SCHEME Costing and scheduling are also calculated in the Project spreadsheet.Once all the scoring,costing,and scheduling are calculated,the spreadsheet can be joined to the TCI Project GIS layer.An unformatted copy of the TCI Project Scores tab from the master TCI Project List spreadsheet is used to populate the TCI Projects GIS layer.Once the TCI Project Scores is exported to a separate spreadsheet,displaying the spreadsheet values only (no formulas),then it can be added into ArcGIS Pro and spatially joined to the TCI Project layer using the TCI Project Number to join.Values from the spreadsheet are copied into the appropriate attribute fields using the Field Calculator. 1660 Fail River Drive (Suite 2001 Loveland,Co 80538 Phone 970.461.7733!Fax 970.635.37091 olsson.com EXHIBIT A TO RESOLUTION 2025-061 Dashboard &Functionality In ArcGIS Online,an interactive dashboard was created to display the TCI Projects and associated project scoring.ArcGIS dashboards provide information on a single screen with location-based analytics and interactive data visual zations Dashboards ntegrate spatial data so users can visualize patterns,trends and relationships The TCI Project dashboard was set up so Fort Collins staff can view all the TCI Projects and sort and filter Projects based on pro ect information like location,status,cost,project type,and scoring The dashboard consists of the TCI Project overview map,which displays all the TCI Projects that are listed in the spreadsheet.The TCI Project dashboard can be used to sort/filter TCI Projects and their associated information. FIGURE 1 —DASHBOARD OVERVIEW ~~,_-,,n__.h—,,,—-—,c__—._~ Coin,TC1D.shbc,,d ~Op~~w •5i.!,4 88 —~ -K Proiec.l ‘“—c C,-7’~io S.. 382.3M 0 1.The left panel includes (he selector list a.The top left portion of the panel includes predefined selectors allow users to sort,and filter based on various Project attributes for the TCI Projects Map,TCI Projects List,and main panels b.The bottom left panel includes filters for Individual Projects Map and Individual Projects List.This map is located behind the TCI Projects Map and can be accessed by clicking on the “Individual Projects Map”tab. 2.The top panel includes scoring filters.Users can adjust the scores to see how projects were scored 3.Total TCI Projects Selected and Total Cost of TCI Projects Selected Indicators Indicators tell users the total number of projects and project costs that are selected.Note that there are indicators for Map #2:Individual Projects Maps under the displayed indicators.Use the arrows below the indictors to toggle between the two different indicators. 4.TCI Project List This list is dynamic and adjusts as project selections are made.This list is organized to display highest draft scores based on the current selection. 5.Plan Breakdown by Status (Map 2)graph.This graph shows the number of projects from each City Plan that are included within the TCI Project selection. 6.Total Cost of Projects by Year graph.This graph adjusts based on the projects selected. 7.Tables.The Tables tab includes the attribute table for the TCI Projects Map and Map #2:Individual Projects’tables and displays projects based on the current selection of projects. 1880 Fail River Drivel Suite 2001 Loveland.co 80538 •-S. ‘S -a. Phone 970.4517733 (Fax 970635.37091 oIsson.com EXHIBIT A TO RESOLUTION 2025-061 Dashboard Maps There are two different maps within the TCI Project dashboard.These maps can be toggled between the two by clicking on the map tabs shown directly below each map.The main map in the TCI Project dashboard is the TCI Projects map which is linked to most of the other dashboard elements such as the selectors, indicators,and project list.Map 2,which is referred to as the Individual Projects Map displays all the individual projects from the City’s different plans.There are selectors built into the left panel to sort on the individual projects layer Those selectors have “(Map 2)”associated with the selector name Background and Scoring Layers Each map in the dashboard has additional GIS layers that can be toggled on and off.Those can be found under the Layers button on the top right of the map screen.To turn on and off the background/scoring layers,click on the eyeball icon next to each layer FIGURE 2—ScoRING LAYERS 04db.9, L yers F Irrigati n s:ru Fort Col IP ~o cc:Lis~ Scor g Layers LOSS Hig In ury [,orv.o,L.0 Fu:c S’reet Projects (2025 -½2030) Project Editing The TCI Projects layer has been enabled for staff editing.The only field that is enabled for editing is the Project “Status”field.(Note:all the other fields are Read Only to prevent from accidental editing.)To edit this field,click on the TCI Projects Table,and click on the pencil button on the left side of each Project row. 1880 Fail River Drive/Suite 200/Loveland.co 80538 Phone 970.461.7733 /Fax 970.635.3709 /oisson.com EXHIBIT A TO RESOLUTION 2025-061 Use Cases Project Management -Editing Status The TCI Projects layer has been enabled for staff editing The only field that is enabled for editing is the Project Status”field (Note all the other fields are Read Only to prevent from accidental editing.)To edit this field,click on the TCI Projects Table,and click on the pencil button on the left side of each Project row FIGURE 3—PROJECT EDITING —PROJECT List VIEW TCPP.4.tt k’~t.’P,’,ta,~5,F?~Øc1Lk’•a0•,Ca,5~.,c,0~.,.0Seo,.Sa’oryScn,.(aIG ~ado~ 4 I .037 WC0w’RcadOa[dFo.Raaj 400000 4 I 4 1 i00s7 S7.,~I.,0aad £..,tc’,Road .500000 U-Iu,cie.J 40 I •0008’5.4.94 044 I ‘,r,a,Road Iiotb.’,J,e~oa,J 27.437000 U”fe’.to,l 49 .1 4 00014 ‘a,4~0o Gad [V oD’’.o Car,.Soa,I50 8.000.000 Urhwoo,4 4 0074 CR .,~[Ira,[“a,’.,Raa,j ~,[,a,,,.000000 U,’[ta,’.t,d t I 401095 ,,‘.Road CLa-4U r,o.’a,~r,or..000000 U’”cnoed •0 Ok .‘,mO..,.‘,.tdcad y •0~’a.1$,n.~a load ‘074 500 Ur’.,atd 2 1 .0*0 C4~oI.’oat~Road a,U900 flaht.ad .000,000 U’’card.d I 3 4 5 ‘J.,oa,0,500500 U’fc,r,d,d I I Ott,‘.000.500 u-arood I 4 .~•,,~.j,D’,,.Da.,oo,40o.d [00.000 UW04.d 4 4 02 Va oat ‘.000.500 IjrIa,,d,d 4? 4 002 .m’,~’,t’..,0.000500 U’da’,i.d 0?3 C,’‘o,rja.q,...‘a ‘.500.000 Uda,oi,d 40 4 0093 C4~S~,.,‘tthThtoJ 500.050 U 4a,oThd ‘0 4 000-It 7 1~jt~84 E..s,,S ,maj.’.2,000000 Udaa.dod 33 -0*00077 2’Ia,Oea,lt,~osd ~*0i4t ‘044 .000000 U’dod 22 4 0009’S .‘o.,,l..’a0 Ca,ca’e Road 000000 U,fa.oj.d 35 4 0073 :,~c9~0oad OIUS •ako.,?87 .000.000 [dHar.4a4 34 •0c4 G.ndr.~,Roao 0.~,be,V -“!H [ao_r0.(a 22’,.,4,I020 TCJ C—D cs ~.j In c I,,d’~cJuaI P’oj ecsrs’jI,’ Once you select a Project to edit,the Edit Attributes dialog box appears.Scroll down to the “Status field and click on the dropdown arrow to select the updated status of the Project.Select one of the predefined attributes,then click Save to save the changes.Note that only the project status can be modified currently If needed,additiona fields can be editable such that costs,timing,or scores could be changed. im oflant no -:urrentl the shann.•ermiss;ons -r -f.r internal Fort Coil s Staff on!.If this dashboard’s sso are shared to th-••c •Iease.;re to create a t-;.-oni “co f e TC!Proe t feature e and disable edith,.•e missions fr.e •ubhc. 0 Fali River Drivel Suite 200)Loveland,CO 80538 Phone 970.461.7733!Fa 970.635.37091 olsson.com EXHIBIT A TO RESOLUTION 2025-061 FIGURE 3—PROJECT EDITING —PROJECT DETAIL WINDOW U p<iv ,iiidb Ftc cc~Cc,i noo~rno Ci?P~o~vc: iI!u~a.)o rojo Pr’mo’y_o;ect_T S~d ‘pa.Fn S~,canddry 1~~~c>pe rn i-~ndod Urftinded Under ContnjcUon Compie~o Co~_?Q 0 On_PU 1880 FaIl River Drivel Suile 200/Loveland,CO 80538 Phone 970.461.7733/Fax 970.635.37091 olsson.com EXHIBIT A TO RESOLUTION 2025-061 Select Projects for Grants Another powerful use case for the dashboard is to filter and select projects to identify them as candidates for grant applications.This can be done using the scoring filters in the top ribbon as well as filters along the left side to further tailor the selection to meeting the grant.For example.Highway Safety Improvement Program (HSIP)applications focus on safety,bike and pedestrian improvements,and equity.Furthermore there are minimum and maximum grant amounts based on the available funding.To select candidate TCI projects,filter the Safety Community,and Equity criteria to higher values and filter by the allowable cost range to find candidate projects.Note that a user may need to increase or decrease criteria to create a useful list of candidate projects.Once selected the “TCI Projects Table”shows the list of candidate projects. F URE 4—GRANT IDENTIFICATION —~“½’~——.—%‘T~ CoIL,.,IC?Dathbo.’d 1C0”~ —, ——4 t \.z._... I -Id PmJC.- ‘06’~~~?~- ‘-‘p.0 o~,Io~.o? II 994 Io54~L.1•. 16 7M - t , -—--9-,I 1880 FaIl River Drive/Suite 200!Loveland,CO 80538 Phone 970.461.7733!Fax 970.635.3709!olsson.com