Loading...
HomeMy WebLinkAboutDATA TRANSFER SOLUTIONS - CONTRACT - RFP - 7162 TIP DATABASE SYSTEM - SOFTWARE - NFRMPOAGREEMENT BETWEEN THE NORTH FRONT RANGE TRANSPORTATION AND AIR QUALITY PLANNING COUNCIL AND DATA TRANSFER SOLUTIONS, LLC. THIS AGREEMENT is made and entered into this [_clay of February, 2011, by and between THE NORTH FRONT RANGE TRANSPORTATION AND AIR QUALITY PLANNING COUNCIL (the "MPO") and DATA TRANSFER SOLUTIONS, LLC ("Contractor"). In consideration of the mutual covenants and obligations herein expressed, it is agreed by and between the parties hereto as follows: 1. Scope of Services. Contractor- shall perform tasks and related work as described in Attachment A, Scope of Services. The North Front Range Transportation -and Air Quality Planning Council shall compensate the Contractor in accordance with Attachment A. Maximum compensation under this Agreement shall not exceed $76,180 unless the Agreement is later supplemented. Payments shall be based on a monthly invoice billed on percent complete with respect to the $9,500 base implementation fee and the $57,080 custom TIP features fee. The annual maintenance and hosting shall be invoiced at 100% once the application is "live". 2. Time. Time is of the essence. Any extensions of any time limit must be agreed upon in writing by the parties hereto. 3. Term. This Agreement shall become effective upon execution by both parties and shall terminate no later than the thirtieth (30) day of September 2011, unless terminated sooner as herein provided. 4. Default. Each and every term and condition hereof shall. be deemed to be a material element of this Agreement. In the event either party should fail or refuse to perform according to the terms of this agreement, such party may be declared in default, and this Agreement may be terminated. 5. Early Termination by MPO. Notwithstanding the time periods contained herein, the MPO may terminate this Agreement at any time for the MPO's convenience or because of the failure of Contractor to fulfill the contract obligations. If the necessary funds are not available to fund this project, the Agreement may be terminated immediately and the Contractor paid for services rendered up to the time of termination. The MPO shall terminate by providing at least fifteen (15) days prior written notice of termination by 'delivering to Contractor a notice of termination specifying the nature, extent, and effective date of the termination. Upon receipt of the notice, Contractor shall immediately discontinue all services affected (unless the notice directs otherwise) and deliver to the MPO all data, drawings, specifications, reports, estimates, summaries, and other information and materials accumulated in performing this contract, c:ldatalproposalslfort collinsWrmpoVinal editable docsldts 2010 1 6 2011 verslon for edlting by dts.docx Agile Web Development Asset Management ographic Information Systems Transportation Planning Ft Engineering Multimedia NC - Portland, OR Attachment A SCOPE OF WORK North Front Range Metropolitan Planning Organization Interactive Transportation Improvement Program (TIP) Development & Annual Maintenance and Support I.PURPOSE This contract is to provide services for the development and support of an automated, web -based TIP for the North Front Range Metropolitan Planning Organization. The development will include integration of CDOT's Projects and Local project data, general design of the TIP, setup of web -mapping services (data layers, etc.); administrative tools, and setup of query templates with enhancements as required by the NFRMPO. 2. WORK ACTIVITIES TO BE PERFORMED AND SCHEDULE This contract shall be valid until September 30th, 2011. The Consultant will make available to the Project Manager, all personnel and equipment necessary to provide the professional services as requested by the Project Manager. Specific work to be performed by the Consultant when authorized by the Project Manager may include: Task I — Coordination Meetings Coordination meetings will be held throughout the period of the task order in order to review the progress of the automated web -based TIP program development. As many meetings as required will be held either in person or by teleconference. As a broad practice bi-weekly meetings for planning and review will be held to provide frequent updates to NFRMPO on the status of the project, Attachment H provides the detailed project schedule Task 2 — CDOT Projects Data Downloads and Mapping This task will include serni-automated downloads of the CDOT Projects on tentative and adopted priority lists as defined by the North Front Range Metropolitan Planning Organization into the TIP database. At a minimum, the following project tables in the current NFRMPO TIP will be downloaded: Highways: Bridge - On State System; Bridge - Off State System, Strategic; American Recovery and Reinvestment Act (ARRA) - FHWA; Faster Safety Pool; Faster Bridge Pool; Regional Priorities (North Front Range Listings); HB 1310; Congestion Relief; Surface Treatment; Safety; Railroad At -Grade; Grants - Safe Routes to Schools. (An example of these project tables are included in an Excel Workbook that currently is used by the NFR111PO to produce the TIP tables in the format provided in Attachment C.) The NFRIVIPO's complete Excel Workbook will be received in a pre -defined format from the NFRMPO using the most recent version available at the time Task 2 is to start. In addition, data downloads will be received in a pre -defined Excel or database format from CDOT and the TIP program will ingest this data into the application. Comparisons need to be made between the information received from the NFRMPO and the information received from CDOT, Information from CDOT that has not already been included in the NFRMPO's information will need to be addressed and decisions made about what data elements the TIP program's database will need to include on an ongoing basis. CDOT has C*dts provided the Excel format for STIP data elements for use in submitting TIP project data to CDOT for the Statewide Transportation Improvement Program. See Attachment B. A shapefile layer of project locations prepared by the NFRMPO will be received from the NFRMPO for ingestion into the application in this task. Deliverables • Downloads of STIP Project Tables on dates as defined by NFRMPO (or other day, as defined by the North Front Range Metropolitan Planning Organization) • Shapefiles created of CDOT's STIP Project Tables Data Task 3 — Integration of Local TIP Data and Mapping Similar to Task 2, Task 3 includes the integration of local government TIP project data into the North Front Range Metropolitan Planning Organization TIP database. At a minimum, the following HIGHWAYS -related project tables in the current NFRivIPO TIP will be downloaded: Highways: Transportation Enhancements; Congestion Mitigation & Air Quality; STP-Metro. Also, these TRANSIT -related and other project tables will be downloaded: 5307 - Large Urban Cities; 5309 - Capital Investment Program; 5310 - Transportation for Elderly Persons & Persons with Disabilities; 5311 - Rural & Small Urban Areas; 5316 - Job Access Reverse Commute; 5317 - New Freedom; Local; Illustrative and Unobligated. The TIP program will be designed to accommodate new, yet -to -be determined funding categories that might arise from new local, state, or federal legislation. In addition, the database system needs to be capable of accommodating in the future a breakdown of year -by -year funding for a project not only by funding sources but also by project phases (such as Environmental, Design, Right -of -Way, Utilities, and Construction or Implementation). Deliverables • Local TIP projects information saved in, and made suitable for subsequent reporting from, the TIP database • Local TIP projects mapped to the greatest extent possible, and saved for future retrieval from the TIP database. Task 4 — Development of Web -Mapping Service (Data Integration) This task will include the development of an interactive web -map customized with data provided by the North Front Range Metropolitan Planning Organization. For instance, the map interface will include many data layers defined by the NFRMPO. A sample of layers that may be included are: • . CDOT highway capacity projects • Locally funded highway capacity projects • Multi -use trails (existing and planned) • Sidewalks (existing and planned) • Truck routes fats • Transit bus routes and shelters • Parks and recreational data • Local roads and streets • _ Rivers and streams • Railroads • NFRMPO and DRCOG boundaries • County boundaries • Town and city limits • Highway symbols (Interstate, U.S. and Colorado) with Route Numbers shown on them, mimicking roadside signs • Various labels about features on the map • TIP projects (point and line projects) • Other major roads (collectors and higher classifications) • Additional data layers may include Planning Areas of local jurisdictions and various political boundaries such as County Commissioner Districts or municipal wards Deliverables • Customized Web -Mapping Interface Task•5 — Automated Report Download, Design, and Formatting In Task 5, DTS will modify the current automation routines to match requirements of the North Front Range Metropolitan Planning Organization for delivery of their TIP. The following project information items are generally addressed (and in several instances below, color -coded) in each entry of the TIP. Attachment C reflects the information that will be provided by NFRMPO regarding the projects, which will be incorporated into the TIP Tool: • The date of the most recent amendment or change to the project information • The TIP amendment number if applicable • CDOT's Statewide Transportation Improvement Program (STIP)/Work Breakdown Structure (WBS) Identification Number • NFRMPO's TIP Identification Number • The Project Description/Location (typically showing a route name or number, the name of a route or feature at the beginning terminus, the same for an ending terminus, or in some instances just the name of an intersecting route if the project is at a junction of two roads or transportation routes) • The name of the project's sponsor (typically either CDOT or a local municipality or county; in some instances this may be a different agency or subdivision of the Colorado State government) • The type of improvement that will be provided by the project (e.g. "Bridge Replacement" .or "Modify Intersection") • The source(s) of funds that will be used on the project (e.g. "Federal," "State," "Local," or "Local Overmatch") • The "highest" category of "Funding Type" or major "Program" category that can be associated with the project (e.g. "STU," "TE," or "AQC"), generally coinciding or �+ dts I i correlating with the major funding program heading from which project funds are assigned. (The "highest" category generally refers to one for which federal requirements might be the most challenging to achieve and/or might be the most logical source of funding given the type of project to be implemented.) The specific dollar amounts (stated in terms of 1,000s) for each funding type and each of six fiscal years as well as the dollar amounts required beyond six years to complete the project (shown in a "Future" column) Ability to attach one or more photos to the project, but only make one of the photos available on the project report, in addition to the GIS map. The multiple photos however will be available to view in the front-end of the application when the user searches for the TIP project and views its detail Attachment C provides an example of typical pages of the current TIP, showing these various items of project information These fields must be incorporated in the TIP Tool, and in any Excel - formatted output reports generated for CDOT to review Amendments to the STIP. Appendices (i.e. project prioritization process) and Executive Summary details will be provided to DTS by the NFRMPO for purposes of public downloading from the TIP web -site. Deliverables • Full TIP and specialized subsections (i.e. Executive Summary, Appendices, etc designed to North Front Range Metropolitan Planning Organization requirements) Task 6 — Develop Customized Search/Query Tool DTS will modify the current search and query tools in the Automated TIP to match requirements of the North Front Range Metropolitan Planning Organization. Deliverables • Modified search and query tool, per above. The automated TIP search and query tool should enable reader -defined reports to be generated. Typical examples would be: Full TIP with projects sorted by Funding Program (e.g. Bridge On State System,.Bridge Off State System, Regional Priorities Program, Surface Transportation Program - Metropolitan, Transportation Enhancements, Congestion Mitigation & Air Quality, etc.), Full TIP with projects first sorted by geographic location (e.g. ones in each municipality) and then by funding source; various types of reports showing subsets of the full TIP (such as ones specific to a finding program, a local jurisdiction, or a type of project like bike/pedestrian facilities linked from the project's "Improvement Type"). Task 7 — Automated Comparison Reports C16dts The TIPs automating reporting tool will allow the NFRMPO to print off updated CDOT's STIP Projects before they have been placed into the CDOT Adopted Program (during prioritization process — as when they are moving money around and the program is not "locked") using the Comparison Report developed inside the TIP Tool, Below is an example of a Comparison Report example that will be available from the administrative back -end of the TIP Tool. The administrator will be able to choose two different data sets of the TIP data and run the comparison report. For this feature to be functional, at least 2 UL Uald I1CeU5 Lo Or, 1UauCu III UIC Say TPO Tray sporrarion h7lpravenlentPrograln FY �01A I • Transportation Improvement Program [March FOOT 031$ versus FY 2010111- Transporrarlon Improvement Program F12D I&I I- TonsperUt-knpmva M P,ngam(Ntmh FOOT Oa1aj F-My Dem No. Phase Fund 2010011 20111t2 2012013 2013114 2014115 2015116 20M7 Berge 8RRP $2,27kN9 e 0 0 0 0 0 DIN 326"t 0 0 0 0 0 0 SRso(US M FPN.4Y%M1 .FROM ST ANDREW3 BAY 0 0 TO 9➢ OGS NOS. 112&119 DESCRIPT10m. FY 201(Y) i •7rensprnl. Bcn Improvemmf Program Fe-11q Dam No.. Phase fund 2010n1 201 U12 20:013 2013r14 2014JIS 2018116 2010r17 BrwQa DIN 547-AM 0 0 0 0 0 D BMW $2,2nen 0 0 0 0 0 D SR 90 ps so) FPN; 4254-1W DIN 32"1 0 0 0 0 -0 0 FROM ST ANDREWS BAY TO BRIDGE NOS, Ma M t,0 D DESCRIPTION: PD£•Prc* Develpr" En.Vz mera-PE-Prermilea wae& ROW-RicA1 or Way. CST•C *us0an; RRU•Rad Rp�y'�as• INClnoendve; ENV•EAvimnme tittgallon;CAP•CapRaE Grant; OP��-1 puaOora �r3M LA-LwSAdvance R+AmWrstmNt DSB•Desig-Design ADht•Ao.rinistraticn Pape fe In addition, DTS will expand the Comparison reporting feature to incorporate historical reporting for multiple years/data sets for a single project. (Also see Task .73 and 14) This will help NFRMPO understand the funding changes that occurred for a project over time. Deliverables • Automated comparison TIP report Task 8 — Quality Control and Technical Support DTS will quality control the TIP output resulting from the download and fonnatting tasks by comparing it to a gaming (garning — as when they are moving money around and the program is not "locked") report printed directly from the CDOT's STIP Project Tables data. The project, limits, phase, fund code, fiscal year, type of work, and funding amounts will be checked for each C*) d ts project. In addition, DTS will support technical questions commonly coordinated directly with the NFRMPOs and the CDOT. Task 9 — GIS Server based Map Viewer DTS will enhance the existing Interactive map to an ArcGIS Server back -end, from an ArchMS platform. The viewer will have a JQuery front-end with the ability to search and identify projects, view a project overview and generate an individual project report from the map. Individual project report information is expected to include all or most of that noted in Task 5 as well as options for a project specific map and graphic(s) (either a photo, diagram/chart, or drawing). Please find attached an example report for a project below that is currently offered as part of the TIP Tool. DTS will modify this project report to include one additional graphic as, specified in the administrative back -end for the project. An assortment of possible layouts and elements of contents for individual project reports is provided in Attachment D. The attachments can be used as a reference to understand the needs of NFRMPO and will be evaluated by DTS before enhancing the existing Project Report. The complete range of typical data elements combined from these examples will not be accommodated but DTS will investigate options and prepare a North Front Range -specific version in consideration of input from the NFRMPO. Polk TPO 7renePortaG'anlrnProvealenl Pravram•:FY2010l11.20r4/15 W3604 0 21 (SR 26) Prol tt Destrlp110n: RESURFACING BEGIN MILEPOST:0.970 MIN POOST: 10.255 200A.1 thfoYOh 20f 4lf57'IP. (DAcember 7, 20)0) Work Summnry: RESURFACING From: NORM OF US 98 LRTP Pave 0: 17 To: N OF CAMP INN RESORT Lenath: 3.279 LGAAUency: FOOT Fund $se .source 20101111 2011112 2012A3 20113114 2014115 Total f(5) SL 4,400.295 0 0 0 0 4,408,205 (52) DOR 50,000 0 0 0 0 50,000 (81) DIH 41.122 0 0 0 0 41,122 tal 4.497,417 6 0 0 0 4,497417 CID dts Deliverables • ArcGIS Server based Map Viewer with integrated reporting to generate an individual project report Task 10 — CDOT/SAP Data Updates Similarly, data exports to CDOT SAP will be exported out of the TIP program in a pre -defined format to hand over to CDOT's SAP data entry team on a periodic basis or whenever amendments to the NFRMPO TIP are being processed in cooperation with CDOT and will modify what is to be reported in an updated version of CDOT's Statewide Transportation Improvement Program (STEP). See Attachment B for information about the pre -defined format (Excel -based) for submitting TIP project -level information to CDOT and the associated menu options of data elements to be shown in its various cells. Deliverables • The latest version of Attachment B will be,provided to DTS before Task 10 is developed • Import Utility for ingesting CDOT's projects into the TIP program • Export Utility that exports TIP projects to hand over to CDOT SAP Team Task 11 — Analysis of Available Funds when managing project funding The TIP program's administrative back -end will allow the administrators to view "available funds remaining" at a program (category) level that will serve as a guideline when maintaining or adding new projects using the tool. Deliverables • Available Funds Remaining being tracked and displayed at a Program Level, including an option to export an Excel -formatted report file. Task 12 — Capturing and Reporting of Actuals The TIP program's administrative back -end will allow administrators to view reports comparing allocated funding to the sums of programmed projects against Acuals. Information about actuals will come from quarterly reconciliation reports prepared by CDOT and may be imported on a periodic basis through the TIP administrative back -end. These reports, however, will only be available to administrators of the tool, not to the general public through the TIP website's reports. See Attachment G for the format of the quarterly re -conciliation report that is currently received from CDOT (Excel -based). Comparisons will be made using the "'STIP WBS" number, which will be tied to all projects in the TIP. Deliverables • Actuals reports for TIP projects tracked in the Tool fiats Task 13 — Historical TIP Reporting and Amendment form generation As an addition to Task 10, DTS will work with NFRMPO to track amendments or changes to projects as we update the TIP with CDOT's SAP or whenever amendments to the NFRMPO TIP are being processed in cooperation with CDOT. Preliminary reviews for doing this require a reporting feature that will enable the NFRMPO administrator to exchange draft information about proposed TIP amendments (most Iikely in Excel spreadsheet format) to any interested parties. Interested parties need to be able to edit draft amendments and return them to the NFRMPO administrator who will review the amendments before entering them into the TIP database (via the administrative tools) as an approved amendment. See Attachment E for examples of currently -used TIP amendment output formats. Deliverables • Administrative back -end template (capable of generating an Excel -formatted report) meeting the current requirements as specified in this scope of work for each TIP amendment form. These formats will need to be provided by NFRMPO before Task 10 and 13 are started. Task 14 — Reporting on History of projects providing an ability to compare project funding over multiple years/data sets As an extension of Task 7, DTS will expand the comparison report sample shown in Task 7, to compare project funding information over multiple years. The administrator will need to be able to relate multiple STIP/WBS items to a single super 'project', and the tool will provide the capability to query a project based on this grouping for easy report generation and analysis. The pre -requisite for this feature to be functional, is that the TIP Tool must contain at least 2 years/sets of data. The administrator will be able to choose multiple different data sets of the TIP data and run the historical comparison report. This will help NFRMPO understand the funding changes that occurred for a project over time. Deliverables • Automated historical comparison TIP report Task 15 — Developing a custom report to handle an Investment Flier The TIP automated reporting tool will include a report customized to serve as an Investment Flier in a format specified and attached to this scope of work. DTS will work with NFRMPO to review the format of the Flier before development. The pre -requisite for generating this report will be that all data fields displayed in the report are fields already mentioned to be captured in Task 5 of this scope of work. This report, however, will only be available to administrators of the tool, not to the general public through the TIP website's reports. Attachment F provides an example of an Investment Flier report that can be generated from the administrative back -end of the TIP Tool. Deliverables • Investment Flier report Task 16 — Ability to Track new applications for funding in the TIP tool DTS will work with NFRMPO to built the capability for an administrator to create a project which is currently going through an application process from an agency and categorize it in a way that eliminates this project from displaying in any of the TIP reports. The application process itself will be manual, wherein the agency fills out a form and sends it to the NFRMPO TIP administrator (handled outside of the system) but this capability will allow the administrators to enter any un-approved project information and associate the amendment forms sent by the agency as "attachments" to the TIP project. These attachments will however be available only in the back -end and will not be included in the reporting of this application, until this project might be approved in an official TIP amendment or revision Deliverables • Administrative tool to add a new project (applying for funding) and categorize it under a non -reportable category, and also associate attachments with it Task 17 — Ability to manage multiple photos/graphics for an individual project The TIP administrative back -end will have the ability to associate multiple photos and graphics for a project, but only one of those graphics will be viewable in the standard project summary or project report, in addition to the GIS map for the project. The layout of the project report will be modified to accommodate this additional picture. A sample layout of the project report supported by the standard tool (showing one graphic note two) is displayed in Task 9 above. Deliverables • Administrative tool to manage multiple photos for a project Task 18 —RSS Feed Subscription Module DTS will provide a feed to which users may subscribe. This feed will publish information to be specified by the NFRN4P0 every time a new version of the TIP data has been published on the website. Deliverables • RSS Feed Module for notifying interested parties about each revision of the TIP Report 3. MEETINGS The Consultant shall participate in meetings as outlined in this scope of work or as requested by the NFRMPO and authorized by both the NFRMPO and DTS Project Managers. 4. PRODUCTS / DE.LIVERABLES �+dts whether completed or in process. If the termination is for convenience, the MPO shall make an equitable adjustment in the contract price but shall allow no anticipated profit on unperformed services. If the termination is for failure of Contractor to fulfill the contract obligations, the MPO may complete the work and Contractor shall be liable -for any additional cost incurred by the MPO. If, after termination for. failure to fulfill contract obligations, it is determined that Contractor was not in default, the rights and obligations of the parties shall be the same as if the termination had been issued for the convenience of the MPO. 6. Opportunity to Cure. In the case of a breach or default, the MPO may, in its sole discretion, allow Contractor a period of time in which to cure the defect. In such case, the notice of termination shall state the time period in which cure is permitted and other appropriate conditions. If Contractor fails to remedy to the MPO's satisfaction the breach or default or any of the terms, covenants, or conditions of this Agreement within ten (10) days after receipt by Contractor of written notice from the MPO setting forth the nature of said breach or default, the MPO may terminate the Agreement without any further obligation to Contractor and seek damages, may treat the Agreement as continuing and require specific performance, or may avail itself of any other remedy at law or equity. If the MPO commences legal or equitable actions against Contractor, Contractor shall be liable to the MPO for the MPO's reasonable attorney fees and costs incurred because of the default. Any such termination for default shall not in any way operate to preclude the MPO from also pursuing all available remedies against Contractor and its sureties for said breach or default. 7. Waiver of Remedies for any Breach. If the MPO elects to waive its remedies for any breach by Contractor of any covenant, term or condition of this Agreement, such waiver by the MPO shall not linut the MPO's remedies for any succeeding breach of that or of any other term, covenant, or condition of this Agreement. 8. Responsibility. Contractor shall be responsible for the Contractor quality, technical accuracy, timely completion and the coordination of all services rendered by the Contractor, including but not limited to designs, plans, reports, and specifications, and shall, without additional compensation, promptly remedy and correct any errors, omissions, or other deficiencies. The Contractor shall monitor its performance under this Agreement to ensure that time schedules are being met, the Budget and Scope of Services are being met within the specified time periods, and other performance goals are being achieved. 9. Indemnification. Contractor shall indemnify, hold harmless and defend the MPO and its representatives, officers, employees, agents, and contractors from and against all liabilities, penalties, costs, losses, damages, expenses, causes of action, claims, demands, or judgments, including, without limitation, reasonable attorney fees, arising from or in any way connected with injury to or the death of any person or physical damage to any property resulting from any act, omission, condition, or other matter related to this Agreement. 10. Insurance.. Contractor shall maintain commercial general liability insurance in the amount of $500,000 combined single limits, and errors and omissions insurance in the amount of $1,000,000. cAdata\proposalsVort collins\nfrmpo\final editable docs\dts 2010 1 6 2011 verslon for editing by dts.docx The Consultant shall provide Quality Assurance on all products and deliverables as defined in this task work order. Deliverables for activities to be performed under this task work order will generally be: • See each listing of "Deliverables" noted under task descriptions above. 5. COST AND REIMBURSEMENT METHOD The compensation method for this Task Work Order shall be a lump sum of $76,180. The Consultant shall invoice for services performed on this Task Work Order based on percentage of the work tasks or portions of work tasks completed. 6. ANNUAL MAINTENANCE AND WEB -HOSTING Annual maintenance and hosting of the North Front Range Metropolitan Planning Organization Interactive TIP developed according to scope herein to ensure the website is maintained and runs properly on a day-to-day basis for the first year (12 months) after the date of going "live" is to nclude: • Annual website hosting • Testing and troubleshooting of website • Minor updating of website for graphics, links, and test changes • Phone and email technical support on application • Minor programming changes to support needed updates Annual maintenance and hosting will be invoiced in full at $9,600 per year and. would remain at or below that rate until the subscriptions are terminated. The first year's subscription would start on the " Go Live" date and will automatically renew unless terminated in writing thirty (30) days prior to the expiration of the agreement. TOTAL COMBINED COST: $76,180 t+dts Attachment B CDOT STATEWIDE TRANSPORTATION IMPROVEMENT PROGRAM FILE STRUCTURE FOR TIP PROJECT DATA Rekion: JSTllvia�: ASTIP WBS.lD ITPR. FM AREA Funds Center ISTJP�Phasi'; lou . riding Prbgra.m..: i Fund,Source� j'Fu - nd,Type' :.; . �]acal ukr,.:� 11_U-YATH �eF Typ 1 4iSR28000 is MOM= jNF_ jCDFM ISFUWCDSRS17 C JBRS ::rF jSHF 960012012— 2017 Region 4 will provide - will !Region 4 will Ibe 7 provide -can be i characters lup to 11 i long !characters long May be NF, R4 or I J�R28 00.0018RS17 :see 96 i see 2nd Tab Isee3rd lau see #31 Note: L If TPR, Region fields are not available in the file it can be derived in SAP BW using STIP ID during data load 2- Funds Center is combination of STIP ID, Funding Program and Fiscal Year i. Key Figure Type will be 9600 or 9610 (or 9620) based on the project to be planned for current or rolled column. 9600 - Current, 963.0 - Rolled, 9620-Future 4. Fiscal Year needs to be selected - 2012, 2013, 2014, 2015, 2016, 2017 S. Dollar amounts in the STIP are always in thousands 6. C - Construction; D - Design; R - Right of Way; E - Environmental; M - Misc; U - Utilities; X - Unprogrammed "2nd Tab" Funding Program Key Prg. Code Program Description Constrained? Fund 7PE Strategic Earmarks Y 400 7PT Strategic Transit Y 400 TfH Strategic Projects . Y 400 AER Aeronautics Y 160 BRO Bridge Off Systems y 400 BRS Bridge On Systems Y 400 CDC CDC Funds Y 400 CMA Congestion Mitigation/Air Quality Y 400 CNF CMAQ- NFR MPO Y 400 COR Congestion Relief Y 400 CLIF CMAQ- UFR MPO Y 400 DIS Discretionary Y 400 EE9 Non TMA Enhancement Recovery FY09 Y 400 EMR Emergency Relief Y 400 EN9 North' Front Range Enhancement Recovery FY09 Y 400 ENA Enhancement Administration Y 400 ENF Enhancement - NFRMPO Y 400 ENH Enhancement Y 400 ES9 Economic Recovery 2009 Y 400 ET9 Transit Economic Recovery FY09 400 FBE Federal Bridge Enterprise Transfers Y 538 FED Federal Lands 400 FSA FASTER Safety Allocation Y 400 FTA Flexed to FTA 400 FTD First Time Drunk Driver Fund Y 400 FLIT Future 400 GAM Gaming Y 400 GCO Construction - Gaming Y 400 GMT Maintenance -Gaming Y 400 GRN Grants 400 HAZ Hazard Elimination Y 400 "2nd Tab" Funding Program Key Prg. Code Program Description Constrained? Fund HOT Hot Spots Y 400 IRR Indian Reservation Y 400 ITS Intelligent Transportation Systems Y 400 LOC Earmarks (Local Match) Y 400 LOM Locally Funded Project Y 400 MN9 North Front Range Metro Recovery FY09 Y 400 MNF STP Metro - NFR MPO Y 400 MOB Mobility Earmarks Y 400 MPH Metro Planning, FHWA Y 400 MPT Metro Planning, FTA (5303) Y 400 RAG Railroad Crossing - At Grade Y 400 RAR Rest Area Y 400 RFG Rockfall Mitigation -Gaming Y 400 RFM Rockfall Mitigation Y 400 RGS Railroad Crossing - Grade Separated Y 400 RPP Regional Priority Program Y 400 SAD Safety Education Y 400 SAE Safety Enhancement Y , 400 SAM Safety Earmarks Y 400 SAR Safe Routes to Schools Y 400 SBY Scenic Byways Y 400 SGN Traffic Signals Y 400 SIG Signing Y 400 SPR State Planning and Research Y 400 SQE System Quality Earmarks Y 400 SS9 ARRA Non -Participating Indirects Y 400 SSR Bridge Enterprise Y 538 STL State Transit and Rail Y 400 SUR Surface Treatment Pool Y 400 TCC TC Contingency Y 400 TOL Tolling Y 537 "2nd Tab" Funding Program Key Prg. Code Program Description TRG Transit and Rail Local Grant Program TRN Transit TUN Tunnels UNO Unobligated xxx Only For Conversion Purposes Constrained? Fund 400 400 Y 400 Y 400 Y 400 "3rd Tab" Fund Tvpe K 1310 1310 Funds 100.000 3037 USC3037 Job Access/Reverse Commute 50.000 5303 USC 5303 Planning Funds (part of CPG Grant) 75.000 5304 0.000 5307C USC5307 Urban Transit Capital 80.000 53070 USC5307 Urban Transit Operating 50.000 5308 0.000 5309 USC5309 Urban Transit Capital 80.000 5309B 0.000 5309G 0.000 5309N 0.000 5310 USC5310 Elderly & Disabled 80.000 5311 USC5311 Nonurbanized Areas 60.000 53110 0.000 5311R 0.000 5311T 0.000 5313 USC5313 Transit Planning 50.000 5316 0.000 53160 0.000 5317 0.000 7POT 7th Pot 100.000 AQC Congestion Mitigation/Air Quality 82.790 BR Bridge Replace (State Match) 80.000 BRO Bridge Replace (Local Match) 80.000 CDC CDC Funds 100.000 ES9 Economic Recovery 2009 100.000 FAS FASTER 0.000 FL Federal Lands 80.000 GAME Gaming 0.000 GRNT Grants 100.000 "3rd Tab" I Interstate 91.210 IM Interstate Maintenance 91.210 IRR Indian Reservation Roads 100.000 L Local 0.000 LO Local Overmatch 0.000 MISC Miscellaneous 0.000 NH National Highway System 82.790 NHD National Highway System Discretionary 91.210 PL Metropolitan Planning 82.790 PRIV Private 0.000 RAN Revenue Anticipation Notes 0.000 SB1 Senate Bill 97-001 0.000 SGR State of Good RepairTransit Funding 0.000 SHE STP-Safe: Elimination of Hazard -State Match 90.000 SHF State Highway Fund 0.000 SHO STP-Safety: Elimination of Hazard -Local Match 90.000 SIB State Infrastructure Bank 0.000 SPR Statewide Planning 82.790 SRH STP-Safety: Rail Crossing Elimination 90.000 SRP STP-Safety: Rail Crossing Protection 100.000 STA STP 82.790 STE STP-Enhancement Activities 80.000 STM STP-Small Urban 80.000 STR STP-Mandatory Non -Urban 82.790 STS STP-Safety: Optional 90.000 STU STP-Metro 82.790 >xxx 0.000 Attachment C EXAMPLE OF NFIUNIPO TIP PROJECT TABLES 1:D7 PM 12l9l2010 ADOPTED BY NFRTBAO PLANNNIG COUNCIL DECEMBER 2007 G Adwlhi hative Am ailment 4 73 Tmnsfort FTA5309 8, FTA531T 10-1S2010 FY 2008 - FY 2013 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) Notch Front Range Transportation S Air Quality Planning Council State of Colorado Fiscal Year K.F. srua rraliea "t"tea Ohang* or a carrectior; Item preview version Slid red box In 1-1 - ammdmeMan or •` • t .. ..'..� ..-... .... sinrx last version SJatawfde.ofRagJonFour Pool - Pro' v .._.:.. .....• .. i,....:. J,r',,,>.{` i la0tp> j;rvmmed/budyetedln a pool ProwhA wdqzm S71P nmrtber Dashed red snows 8(IIP11dnl6:ll last Prltjeat s funds have bedo rolled forward Dollars in Trnrgams HIGHWAYS BRIDGE - ON STATE SYSTEM SR16598 = f.; Regbn4BR-On POOI + � e:�' a Y -COOT :. BrdBa 'For the inostcunent lliatundin ;(ritormatlon(ease refertoCDOTsD STIP on fine et !/sm�y':dotsfa0e w.iisl8u etl ISea RE 1310 Section liorWIV laeafiry ur Ore COOT Siiyd: tlridge Desk Repar(eest alGrearey)I Region I ;SR46598.019 NFOSIS SM4- Cache La Poudra CDOT Bridge RaPlec - d i Str. B-16•D Region 4 I Ref Pt 135.91 t OBlD6l09 C 29 SR4859a.023 NFaB9 US 267- SH 1 Laporte BYPen Str. 848-AE COOT Bridge Reptxe[reat j ALYo See FA57ER Bridge 8 R.,x—1 Priaifies Proyrwm Region 4 f 121L219 SR46598.024 NF0943 (:3S Nxinfine lStr GA re amw= UH 402 COOT CalvertDranaga� #:19 MP2.AX7 Region4 -,-� BRIDGE - OFF STATE SYSTEM iSR46601 �' +-x �:2agbn6BR-0I[Pool .' � :V8dOLL1 [ BdCge FwG+ernos[rurrentpro}ddfgrdtngmlorutao IeaserefertoCDOTaDa STIPonOneath 1/ynw.rdtitsta>rw.us/Budgall, „�,� '' RO0 SR45601.001 Wek1 CR 25" t510 SH 392) at Greeley Watd Forward )SRa86'01 A06 NF0612 Fort Cdgtrn StruM" FCBRYN-02.61u@eny Font CDMr4 t 11rG1'2008 9946601.00T S37 NFBg3B Nrudcor 15e St of Graeky Flo.2 Coral Str. NO. WIN DI&O- 8.0A Windsw Bridge Reel mUrA t 5/4/2010 SR46861.006 S 57 NFM55 L.whlw CR 11C at Horseshoe Lake Splg ay Str. M. LR11C-0.7-24E Ladmw Co Bridge Reptaarrwnt 5 1O SR466p1.009 C 57 NF0956 Led—, CR 50 at Lak-r end WQdCarml Str. NO. LR5D-02-17 L drra Co Bridge Roplaceroent j r2,Q'Mt0 SR46B01.911 t 58 NF095-7 Lackner CR 17 at Poudre River Str. No. tR17-05.48 Ladroer Co Bridge ReI Pagel r1f 29 CADO=mlenls era Seth . rys\sclm4uisnLomi Satlings1i7omporffiy Irrmrnat Fr7esiCmtGnLOuBOaklo'06S6POD1FJ0-OEIT G-M-%1P0 TIP Pro}ed 7aLlec by Plogrdtn 1019 2010 Veaion 11. Compensation. In consideration of the services to be performed pursuant to this Agreement, the MPO agrees to pay Contractor as services are invoiced by the Contractor and accepted by the MPO. In accordance with Section (17) of this agreement each invoice must be accompanied by a written progress report.. Monthly invoices are required and shall include a description of services performed. As each invoice is accepted, the MPO shall make payment to the Contractor within 30 calendar days of receipt of the invoice. Supporting documentation shall also be- submitted for any reimbursable direct costs. The amounts of all such billings shall be based upon the Contractor's MPO-verified progress in completing the services to be performed pursuant to the Scope of Services and upon approval of the Contractor's direct reimbursable expenses. Final payment shall be made following acceptance of the work by the MPO. U. Records and Reports. The MPO and Contractor shall maintain all books, records, and other documentation pertaining to the Scope of Services and necessary to completely substantiate all costs incurred and billed to the MPO during the term of this Agreement for a period of three (3) years from the date of final payment under the terms of this Agreement. These records shall be made available for inspection and audit to the MPO and any state or federal authority authorized to inspect such records, and copies thereof shall be fiumished at the expense of Contractor, if so requested. 13. Ownership of Work Product. Upon final payment, all designs, plans, reports, specifications, drawings, and other services rendered by Contractor shall become the sole property of the MPO, which shall have the royalty -free, nonexclusive and irrevocable right to reproduce, publish, or otherwise use and' authorize others to use all such materials for authorized government purposes. Other entities that may reproduce, publish, or otherwise use the designs, plans, reports, specifications, drawings, and other services rendered by Contractor include but are not limited to the Colorado Department of Transportation ("CDOT"), the Federal Transportation Administration ("FTA"), and the Federal Highway Administration ("FHWA"). 15. MPO Representative. The MPO shall designate, prior to commencement of work, its project representative who shall make, within the scope of his or her authority, all necessary and proper decisions with reference to the project. All requests for contract interpretations, change orders, and other clarification or instruction shall be directed to the MPO Representative. 16. Project Documents. Upon conclusion of the project and before final payment, the Contractor shall provide the MPO with reproducible documents of the project containing accurate information on the project as designed. Documents shall be of archival quality, and also available in an' electronic format, in an agreed upon format. 17. Monthly Report. Commencing at the end of the calendar month following the date of execution of this Agreement and every calendar month end thereafter, Contractor shall provide the MPO with a written report of the status of the work. Failure to provide any required monthly report may, at the option of the MPO, suspend the processing of any partial payment request. 18. Independent Contractor. The services to be performed by Contractor are those of an independent contractor and not of an employee of the MPO. The MPO shall not be cAdatalproposalslfort collinslnfrmpoVInal editable docsldts 2010 1 6 2011 version for editing by dts.docx 1:OT PM 1219RR10 ADOPTED BY NFRTSAQ PLANNING COUNCIL DECDARER 200T O Adu&%6 W94e Amendment lr T3 Transtort FTA5309 & FTA531T 10-192010 FY 2008 - FY 2013 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) North Front Range Transportation & Air Qualify Planning Council State of Colorado Fiscal Year Key. Blue ltalia indicates change We correction Avm previous version Solid red box irwlicates wnenotnenl or cnange .. .. ... .... ... since last vM,= VStatoWoe nrReglon-Four Pouil 1 PmJe0programmed1hudtgetedinapawl Projects with antq" S77Pnmaber Dashed retl shows test Projeel's funds have been rolled forward amentlment Dollaes is Thousands BRIDGE - OFF STATE SYSTEM (cont'd) 5,W1,170 SR46611.012 D¢98`.,8 Laporl.iMubcamD Oddge at Arthur Dltr1, Fad Coffins Bridge Replaceaavd f R' 58 Str. Na. FCWIi11".0 -APT l 6T102111 SR41S601,013 NU961 Madison Ave at G—WIA—land Centel L—eland Bridge Ruplxxm¢nt Correcting i Amdnmt 53 Str, N.. LOV850MADISONAV I STRATEGIC SSP4028 K1,15CortM r(fM 1uFortC W');Co trued' 'CDOT - Recpnstr cllon-Hxy PdOeif:,` Sow Re9to'.:•Dod. S.c¢Ort-' 1 '... cepodly For the mosttvrrent Lvrrldorittnding",IMoma¢tl'gn please refer to;CDOTs,Delty ST)Pon,6m1@t litipJlwwwdotsble--. :us/Budgatl'.. 815=w NFD701 12S—At SH 392'lnterrJlan9. COOT iQ—1 1, 338 0 D 16,550 17,990 0 0'. a 61 SAFE -LU Eamxark included in SP4028 Windsor state SHF 0 0 0 3A42 3A42 0 0'. Fan Wine State S897-wl we 0 0 0 Soo 0 0, Local 0 0 0 B 000 5A00 0 0 Also sin FASTER Stymy & HS 1310 Prograrm Total 1 830 0 0 25=0 26,938 0 0I NFOT02 US 34• At 125 Interchange Loveland Fettered 0 1,437 0 0 1A37 0 Il SAFETEA4-U Eemsark included in SP4028 Local 0 139 0 0 139 0 0111 Total 0 1,576 0 0 1b70 0 0{ AMERICAN RECOVERY AND REINVESTMENT ACT (ARRA) - FHWA ISNF5788.013 ES401 NF0799 6,15 & Crossroads b wmhange AL -sea S7P-Meva Progrartl CDOT Raglan 4 Federal Total ES91 ES9 �— 0 0 1,000 1000 0 0 0 0 3AW 3pW 0 0 11 OI )rSR45218A73 I ES402 NF'080/ 1-25 North Rubblb lion Crossroads North (Lorimer County) CDOT Rcgion4 Fed.,.[ $tat Total E59I Eb'9 SHF 0 0 6,660 140 7,000 0 0 0 0 6,860 7.000 0 0 01 of ESR4666a.029 = ES403 Slynanmilon SHOO & t-2S tJohnstoven IntersMiun) CDOT - Raglan 4 Federal Stare Total ESOI ES9 SHF �� 0 0 490 10 51t0 0 0 0 0 490 490 0 0 0 0 iSR46666.030 1 1 ES404 SFgmtticatlon SWM & Garden Dove (10 indsor Intersection) CDOT Region 4 fadarw Stain Total ES91 EM &HF 0 0 490 10 500 0 0 0 0 490 600 0 0 0) 0 !SNF5094,011 ES405 SH 397 Undwpass (at Poudn FJ" Also see TrarsportaVaf Enhancement Program Lorimer County STE E,rtwcerrmnt BikdPed Federal Total ES9 i ENV 0 0 6w 600 0 0 D 0 80D 6D0 0 0 0 0. SWS?M.014 j ( ES406 US 05 S.rv)c. Rood BikdP.d Evans STE Enla�acrament 0&,JPed Federal Federal Total ES91 ENS ES91 MN9 0 0 0 18 142 160 0 0 0 0 0 0 18 142 100 D 0 0 0 01 0 =SNFW D4D24 ES407 Main Street Berthoud Berthoud STE d—t: Aesthetics FJaan Federal Total EBB / E119 0 0 134 134 0 0 0 0 134 134 0 0 0. Ill Page 2 of 29 C:1Doct is and Somngs%wi nquisrd.eral S0¢419SITempoiary Internet FdaslCdntenLUu¢ook%blU5SBPOUlEXHOtr G - NFRMPO TIP Project Tables by Progmn, 1010 2010 Version 1:07 PM 121912010 ADOPTED SY NFRT&AQ PLANNDJG COUNCIL DECENBER 2007 ❑ Adrl nistrattve Amendmerd R 73 Tran&rtFfA5309 & FrA531710-19.2010 FY 2008 - FY 2013 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) North Front Range Transportation 8: Air Quality Planning Council State of Colorado Fiscal Year Key. Blue Refits tirdicsles chacge-a corract= hom previous v6m1w S olid red Dome #tdicataa ame.amenl ry dwrge ince last version Sfatewlda tN Regton Four Poo! t Da. had asnetl red sows last Projects funds have been -fed forward rrendment STIP�'6'.LY 1�•Y' r i raiwi"S4ti,r�,L-cam' "„r"T"#"s';r .--n "�,�'. ;.'`13 IaS10Bl J , Nrlttn Pro l esaiptloNL`ocatlon �,x It' AMERICAN RECOVERY AND REINVESTMENT ACT (ARRA) - FHWA (conYd) Project progra amedl budgeted in a pool Prajecft wdth unique STIP ntunber ....... •w-�•� w,w nlAwr YrraraeGfNrr L.o-lam STP Federal ES9l MUB 0 250 0 0 250 0 0( kdersec6- knprovenaod Low[ Ovemmtoh 0 100 0 0 100 911r1010 SNF578S016 ES409 Larfmsr CR 17: LCR 45 to LCR 8 Larimnr Caruay STP Federal E59l b9i9 0 3,487 57 40 3,584 0 0 #88 Suttace Tmaftwd Total 0 3487 57 40 3 0 0 11V1010 SNF5765.017 ES410 37th Umet In Evans Evans STP Feda.1 ESS I MN9 0 356 0 �.9 125 O 0 #68 Sofa-Tm br—nt Local Overmatch 0 0 90 0 90 , �nrortte,tuu E5411 4th Ave (VCR 74): WCR 25 west (6svaranca) f Severetm STP Federal) Ess I mm LowtOvermatdr 0 0 m 0 0 147 0 0 098 0 147 I Surface Tteatmard Total 0 ma 147 0 ow 0 W210 SNFsm.519 ES412 Traft Opsratl— Cmdar 68 NF0743 Lovalend STP Fed tat EBB 7MM9 n5: Traffic Opetatans TnEaI _ _ 0 130 130 0 0 .2 .Z in 10 728 0 IRoil Forward Federal STA 0 0 1 0 iSNF5T88.02D ES473 W Id CR 74: WCR 13 to SH 257 Wald STP Fedwal EWIMN9 0 625 0 0 625 0 0 Srrd—Treaartent Total 0 625 0 0 625 0 0� RM12010 # 68 SNFSD84= ES414 C—by No.3 Ditch Trail NF0813 /Vas See TranspoNaOgs l=llhWr�e/lre(•t P/IXilem Greeley STP & STE Enhrmcry—t BD. Pad Federal ES9 / hue Federal ESS I EN9 TOW 0 0 D 0 0 0 108 104 212 -9 0 A 99 104 IMLI 0 0 0 O; n SUBTOTAL -ARRA RMtNG BY PROGRAM Toms (Fed) NTRSTE 1349 0 752 104 0 866 0 0 Total (Fed) NFRSTP M49 0 5.828 165 0 5w 0 0 Total (Fftd) CDOT FS9 0 10AQ 0 0 10.840 0 0 FASTER (North Front Range Listings of State Highway Locations) ;.;R4�'6DOB :` Regon 4FASiER§atstyPool GDOT FASTER Safeb For )�D rnDSt,currerrtyroJ9ct nfo[rr�alun, yleasa�referOD„CDQTe Datly571P on fills at httpJlwww dOt,sfa(e cous/BrtlgeV�s; _ _ _ • , 1222009 SR46606A02 NF0939 US 34 Spa- & US 55 (Csselsy A—) CDOT Bridge Rao ! # 30 Region 4 I i 1211 VZD09 SR48808A03 KFD940 4tur0S: 910 H-y Rd to WO SH 14 CDOT Ruhh57a and R*W Surface i 041 ���.�_�...� Re9iar4 Afae sae Sa,4a Treatc—tPoor 0611 Vt0 SR46606A06 —� NF0063 SH 592 CSC Repair @ Grwl4y 02 Dltrb CDOT 3,66R I DM5.9e # Region 4 fraimvemenro f Page 3 of 29 C:100cuments and SeWnPtTsmpormy tnl—t FOestronb n .Ou*=k%6O556PUDIE)GMfT G- NFRMF9 TIP "eC Tawas by ProWm 1019 2010 Vartiion I'CTFM 121S2010 ADOPTED BYNFRT&AQPLANNNIGCOUNCIL DECENIBERWW 0 AdminiStra Amendment #73TmnsfunFTAS$09&FTA531710-19-2010 FY 2008 - FY 2J13 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) North Front Range Transportation & Air Quality Planning Council Stata, Of Colorado Fiscal Year Key. S1.6 IWICSchange Staid red b- iMkmWs amendment01 Charge . ..... Since last version A14eaProgranmed1budoetedin a pool Pro' jem with unique STZP numbs .. .. .. .... =0e3nQ,U Md straws funds be� frorward roUed amonarnent D04.. in TI.,...b FASTER (North Front Range Listings of State Highway Locations) (coned) 35 I 2=20M ISR46606.M NF0941 SH 392 u W.1d CR 31 (WO G—{ay) CDOT Region 4 T--- —S- --1 F1-2 0-2-0 W7 11311 S R 4 6 W 6. 0 15 1 NF0942 SH 56 at 41h St (Bertttoud) CDCrr Region 4 05W612010 046 jSR46W6.0= NF0701 f,25 & SH 392 Interchange Abe v" StmW91c and HIJ 1310 ProgramsRegion CDOT 4 Intarchango ReconsUmbon ORM10 972 ISR48606.035 NFM74 SK4VZ (a Par-dluA.— COOT R.O.. 4 V,.Wfv lmwaacbon i aomuio t72 I SR4Z6W.038 MFO975 SH 3M 0 WCR 23 bf..--Lk. COOT P--9i- 4 M.,Bty Intersection 172 US 2B7: a SH = Ud—tion CDOT RuVion 4 M,.hfy uae—tion For tl,. 75t currentp oJect IMorrnabon _phase refer b CDOTs Daly STIP on lineal httpJ/www dDLstate.OD 1ulBudgeY/ „ . , _ 09r0V10 ISR4MaDIS NFWW SH I*- Cad* La Poudre StG B.4&D Re Pt 135.91 CDOT Region 4 Bridge Roplmunent NT"4M US 23T: SH I Laporte Byp— Str-S-16-AE Also soe, 8M On Sft.V System d Rer arml FlIbmrss_Progrmrrs CDOT R.0- 4 Bridge Raph—.-d 0=1110 ISR46598M NFC962 125 Series R-d 0.- Ual. 'n..9— $kr. C—,7-8N P.1 P124a's COOT Region 4 fridge Repair REGIONAL PRIORITIES (North Front Range Listings) .......... .. .. .. ....... .0 ----0 .. .. . ..... .... 0 a .0 .0.- R99W 4 2 to 4 Lerms State 1.415 0 0 0 1A15 a 0 ft" HU1310 11.240 0 0 D 11.m 0 0, Note: MM from STP Metro was In FYU7 and sec WQk in FY State CDC 1.170 0 0 0 1,770 0 0 row 800 0 0 Sm. HB1310 0 -800 0 0 Total 0 a 0 . I to Laporte Bypass CDOT MaJof Wderting Federal NH 640 0 3.2rA 145 4,039 0 2T". Region 4 2 to 4 Lanes Sb3b SFF 160 a us 30 B66 0 6=4 To" Page 4 of 29 C'IDcnuneRW and Setfir"brq7bMLpCa1 SaWnpATearizormy lnterrrot FJw1ConLenLDvWo=5S6P0D\EM8rr C - NFRMPO TIP Pn4,aTebi" by Program to io 2070 v=iw 1:07 PM Izamw ADOPTED BY NFRT8AQ PLANNING COUNCIL DECEMBER 2007 0 Pdndn-sLative Amendment V. 73 Transfnt FTA5309 & FTA531710-19.2010 FY 2008 - FY 2013 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) North Front Range Transportation & Air Quality Planning Council State of Colorado Fiscal Year Kay: Blua rtalics indicates change or a ctXiaeann (mm prayipa5 VBr51M Sued red box indicates amendment or change ..., .......... . . ... ..... . since last version Statew(de orReglon FotrrPoof`, ' ` t p Pr4ectprogrdmmed/budgeted to a pool I Projects with unique STlPnumber �am ndm Msnows last projecCs funds have been rolled forward ^^• Dollars in Th-Ms ,-, Ir�,"�''`t°'°�r' +»� f w i D NF Tl? a- 'a35,a��" n v rra'. =Probe DesaiptwLoealionr'iY1,b,�.3a.� h'PrD''J'ictr ponso! r''�t sovoii't�``;=z5unreeiPfo ,.. nding'x,�:tyy?fa'"F';.+ :O'i.::' Not , 7,x'.•. '-.:1�: 1'.vaw':i'``h .a•" So:;xs,.x r r+s7.t�•;.. r:..r ._..ia<t1a �"*✓ t .l:: a iy �aai;Ftm`di i�ri..w'P tT7:' „airy.�,FYt-06''Sri' ,„ F •09y p+ •„- .rr``is .,_ ,.,,.sue ...r- .+++...r.:sa.:,4.:m4.w.a:3a,a.�,..&«_-.... ., a...t.. ..r... :;.:J.a.:r i,:gay;, ,,..,,z r,:,•.rarer .--w.u::.:a:t..:. :a.4',�i R- +.. ,k. ��u. N. .:.`s "ter.` F,Y' , iia��.drS REGIONAL PRIORITIES (North Front Range Listings) (confd) 05018P010 SNF9392 NF3392 S114D2I1S 267 a F•2s g-weLvrc) cDor •..� • ....•• .. _._ .. • -. �45 tAa1M 4Yiderdng.. Federat STA 0 . .. _....292 2,070 0 2,382 128 27,Ap4. Region 4 210 4 tanea State SF¢ 0 76 430 0 SOS 32 4,533 _ ..: ....... ..., .._... .... .. ............... .-;........ _... .. ...... Ta .. ._... ....._........... ... .... ...... .. .. �_... .,.... 970..�...... 2•?OQ....,_.. .._.Q, ... �1.670 16D ?b.337 15R4S600.004 Traffic Safety Ma gwmerd • Region 4 COOT rYdarel STA state sw . Total ISR46600.008 NF5034 Rest Area A Prospect and 145 COOT Conch mtion Federal STA ISO D 0 0 180 i R.&.4 SM SHF 40 0 0 0 40 0 0 Or Ui Tobd 200 D 0 0 2D0 0 0 9l14f2070 SR45500.026 NFIM71 R4 NFR PraSAP Project Closraa Adjustm nts CDOT vadoos Sure SHF 0 0 Reaon4 TOW 0 0 0 9 16 111 1s 16 0 0 0 0 03111170 SR48600.024 NF0952 1.25 North ElS COOT Enr3rernaenmt Ynpxx Federal STA 0 0 m 0 730 0 1 049 statement study State SHF 0 0 7D 0 70 0 ,365,000 135,000 Also sea SSP4028 in the StratagicPOt rbtl Program Total D 0 800 0 Boo 0 1,SD0 000 HS 1310 1SIVYaSDM1J101 NF0745 NWSH3921nterchange ! Also sae Sbategre d FASMR Safe P COOT Ragbn4 Tlntard—ga Federal State Total HB1310 0 47 47 0 0 0 a 0 0 0 0 0 0 0 47 0 47 0 0/152/09 Correcting SI 114.002 NF0751 US "Wison interaectlon Loveland Intersection I mproearrent Faders! U O 0 0 0 0 inurdrnt 23 Also sae ARRA fFhWA Progmrn State Total HB1310 150 150 0 0 D 0 0 0 1. 0 150 0 Roll Forward Federal 0 0 0 0 (D7 funds moved to DS) State HS1310 0 150 0 0 08 tuns moved to 091 Total 0 150 0 g �SR45215ASD NFOW1 I-25 Rasurlacing/RubtHmrtion M r Seoud -N.M CDOT Region 4 CarsoWian Federal State SKr 9,088 1,889 0 0 0 D 0 0 D,OBB 0 1,689 0 i state Staff NE1310 CDC 17,800 3.060 0 0 D 0 0 0 17.600 0 3,060 0 Page 5 Of 29 - CA00cumente and SatarxdslcelmqugtLLocat Siuing.lTempowry Internet Fa-lContunLOutlookl8OSS5PODZQi1BU O . NFRMPO TIP Pnyact Tables by Prograrn 1019 2010 version 1:07 PM T21W410 ADOPTED BY NFRT&AQ PLANNING COUNCIL Or -CENSER 2007 0 Adminstrative Amendment # 73 Trandon FTAa''309 & FTA53171049.2010 FY 2008 - FY 2013 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) North Front Range Transportation & Air Quality Planning Council State of Colorado Fiscal Year Iffy. Blue inrlica indlcares change or a cane .n hom previous ✓arsion Solid red box 4101cmes amendment or mange ... .. _. .. ... . .. since last version State»ide wRaglorrFDur Poo! , Project progrannrred/budgeted in a pool [ Pro/eats wkb on(que STIP number =Dashod MO snows last ProjeCt> funds have been ro)led foraranf ..._. .. , amendment �� � � Dollars in Th usanes SURFACE TREATMENT (conCd) 7lL2o09 (SR45218.082 m27 l NF0913 SH 392. t.25- East Resurtactnp MP 10D COOT Region 4 Surface TareatmenE l 7?12009 jSR45218A67 #Z NF0914 SH 14: 1-25 to {YCW CR 23 MP 139.6-147-169 COOT Roe24 Sonata Treatment 71T(Y2(r09 SR45218A89 ti 26 I NF0016 OS 247 BeMpyd Parfcexy MP 327.75 to COOT Region 4 sedace Twabne"t 12111/2009 f SR45218.2 p 41 09 Nr-0940 1�3: SID Harmony Re to N10 SH 14 Also see Roa on 4 FASTER Saraly Poo! COOT Region 4 Surface Treatment t SR457.I U95 UF0964 N College AvWUS 237 lmpmv-menu Alm sea Transportation Enhancamants and Cmgestcn MIOaCon 6 Air Quef�ilt Proomms Fort Cu16ns Surface Tmam=t k E WI V2010 084 TRANSPORTATION ENHANCEMENTS grL2010 NF0736 NFR Not Assovd Enhancement Federal $TE -167 107 166 -134 31 1.: 0 Local 0 42 41 33 a 265 0 Total -209 209 206 -167 39 1.323 OI Roll SNF6094.002 TtoOay Track Fort COI[ms COsiorfc Provervabon Fodeml 57M 0 D 0 0 0 0 Forward Loral 19 0 0 0 0 0 hom 2005 Tool 19 0 0 0 0 0 SNF5094p08 NF5094 Mason Tr Crossing ofBNSF.r NRRC Fort CoWns Foal STE 200 0 0 0 We 0 0 from 06 and D7 Local 50 0 0 0 5o 0 0 1.1 Total 2`i0 0 0 0 250 0 01 Local Local Overmatch $14=10 SNFS094.007 NF0T35 W /US 341.1w hang. B—Alfica0oo Loveland Fadenl STE 0 0 0 163 16-3 0 0 # 56 movedfnm 07 to 10 tool 0 0 0 41 41 U 0 (mr.Wtcf-U1) TOW 0 0 0 204 2D4 0 0 SNF5094D12 NF07S5 10W Street UP Sidewalk G—ft Federal STE 45 4 0 0 49 0 0 r 1 (060 cnnuaa e/4 Prgecfs kPCM NFMT.. NF0736) Local 11 1 0 0 12 0 0 Total 56 5 0 0 61 0 0 SNF5094.D13 NFU786 Billy Mart—Sldeealk Croaky Fad.W STE 223 12 0 0 235 0 Ut lane caruact e/ 4 pr*ctr NF0785, NF0787, NF9736) Local 56 3 0 0 59 0 01 Told 279 15 0 0 294 0 00t3 SNF5044A09 i NF0787 22nd Street Me Pad Tr(Oroetey) (ors contract io/4Pro)eclt: NF0785, NF078R NF0739) Greeley Federal Local STE 140 36 50 12 0 0 0 0 IN 48 0 ui 0 0) Total 176 62 0 0 238 0 0 Page 7 of 29 C:10eaa x is wrd 3nWt Vsalxeld' Otoral saving MmParmy Internet FileslContenLOutl-kWO5S6P0DUD&11BIT G- NFRWO TIP Ro)actTables by Pmgw 10 T9 2010 Version 1:07PM rzsamo ADOPTED BY NFRTBAQ PLANNMG COUNM nEC.EA BER 2007 Cl Adrr.n.� Amendment # 73 Tra bd FTA5309 & FTA531710.19-MO FY 2008 - FY Z013 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) North Front Range Transportation S Air Quality Planning Council State of Colorado Fiscal Year Key; 6tue I18lics XldiCales crtangp or a con.cdon born previous version Solid red box indicates amendmanl or change '. . -.. � ... .. ... .. .... ..... ......... ... ...... ....... suxx lust venlor, SmtpwTdo ofRog7on FoufPoo! - Project Programneed1budgetedlnapoo! Projects rrdth ontgve S7lPnvmber Dashsd red shows last Project's funds have been fovea fanvartf ....._ . amandme:d Dollars In Tlausards TRANSPORTATION ENHANCEMENTS (confd) &61tt109 SN50W.029 NFWI9 Boydteke Ave at Greeley-L veland Canal Loveland SkeMad Paul Federal STE 0 0 0 179 179 0 0 a 30 Local 0 0 0 45 45 0 01 Local Overmatch 0 0 0 rr10 540 0 Ol Total 0 0 0 764 764 0 0 Roll SWUM SNF5633 College elk. La. Fort Cons Bk &Ped Path Federal STE 30 0 0 0 30 0 0 Forward Local 7 0 0 0 7 0 0 Total 37 0 0 0 37 0 0 _ Rog SNF5M SNFSS20 Sheep Draw Bike Pad Trait Greeley B&&?ed Path Federal STE a 0 0 0 0 0 Forwara Lo al 2 0 0 0 0 0 from 2005 Total 10 W12010 SNFS094.Inew1 NF0968 Ladner County BMOJPed Facility FoJeral STE 0 0 0 64 E4 0 0 s n LCR 546 Bildge at Terry Lake Inlet Carol 1. L.Porm Loral 0 0 0 21 21 0 0 tal To 0 0 0 t05 105 0 Oj Enhancement Programmed in NFRIAPO (excluding Roll Forwards and FY10 Payback to uFR) Federal 1,360 514 837 tra 3.= 0 0 ' Local - 375 316 210 1ST 1,056 0 0 Total (exdudng Ovemialdt) 1.735 WO 1,047 7M 4,391 0 0 CONGESTION MITIGATION Sa AIR QUALITY (CMAQ) 2,212010 131F5173 NF07114 NFR No *1-112ncd CMAQ Federal AQC 0 0 =8 •2,269 a 42.01 0 Local O 0 473 -472 2 673 D� Total 0 0 Z751 -2.741 10 5074 0 ;ShIM1� NFD767 Compr.h.rrsiv. Signal Tlmiog Foal C.F.. 01h-TDMSkae� Fed" AQC 300 0 0 O 300 0 0) { R4 Local 0 0 0 0 0 0 0( L Taal 300 0 t 0 300 0 0) fSNF5173,011 MF0768 Narnwny Rd Traffic Responsive Fort Cvir.- 00n:rTDM$mu4es Federal AQC 340 0 0 0 340 0 OE Signal TOnln9 Kcal 0 0 0 0 0 D 0 ( R4 Total 34D 0 0 0 340 0 0 ESNF5173412 NFD769 N C 11,ga AWLS 2871mpravam.rd Fort Coilirrs Other TDM Saalegirn Fodarte AQC 2511 U 0 0 250 0 D R4 Loral 52 0 0 0 52 0 0: ' Local Ovenaatch 196 0 0 0 1s6 Tow SDO 0 0 0 500 0 0 611820os SNF5173A13 NF0770 Mason Tag Exhrsion re, Spring Creek Fort Colons Other TDM StraleOas Federal AQC 545 0 0 0 545 0 0 Correc6rg R4 Local 140 0 0 0 140 0 0 AradrntZJ Total 895 0 0 0 6S5 0 01 ISW5173D14 NF0771 Urraon T-7 undarpasr at Tm bnan Fort Coirms Ofiwmm6Yalegies Federal AQC 600 600 0 0 1,200 0 Ol i R4 Inca 150 150 0 0 300 0 01 Page 9 of 29 e9Decrww" and Sate 1TerrWormy Internet FdrslCanRrt.Ongook1805S6POD1DO00R G-NFRMFID TIP ngs Project Tables 67 Program to 1B 2010 version 1:07 PM 12%W10 ADOPTED BY NFRT&AO PLANNNG COUNCL DECEM 13ER 2007 ❑ Adnninshat ve Amendn*M # 73 Tmm--fod FTAS309 & FTAS717 10-13201 D FY 2008 - FY 2013 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) North Front Range Transportation & Air Quality Planning Council State of Colorado Fiscal Year Key. Otue italics indicates charge or a -nvttfonn f . Previous -War, =S,141,od b01t indicates amenament or change ..... .... _ ..... ... ............... since Last varsron Smtrr»ide ruReglon:FourPoW - Project programmed/budgeted in a pod [ Projects with unique ST7Pnomb" =Dashed :ad snows last to -jets funds have been nollod fomard f ... .. . amendment Da ur Twsams CONGESTION MITIGATION & AIR QUALITY (CMAQ) (oonfd) 5262010 I SNF51T3.035 NF0950o NFR Signet Timing US 237 Federal AQC 0 0 0 120 12D 0 Local Ovemeteh 0 0 0 0 0 0 9122010 SNF$173 jnewj NFogw NFR signal Timing Pool various ITS and Trams Controls fwdeml ADC 0 0 0 250 260 0 0 #69 NoW: 100%Federal parOripabon LocalOvemiatch 0 0 D 0 0 0 01 Total 0 0 0 250 250 0 0t M2010 JUNF51734newf NF0969 Loveland p=!S 341Cre-reads VUS Loveland ITS and TraKc Controls Fodoml ACC 0 0 0 370 37D 0 969 Local 0 0 0 77 77 0 Local Overmatch 0 0 0 3 3 0 I Total 0 0 0 4W 460 0 I 9/1J2070 811175173.U..1 NF0970 Linden Stt, Strestscapirg Improvarrronu Fort Cogha', MuaifnodW Street Fedaml AOC 0 0 a 580 580 0 I # 69 Impunvemems Loral 0 0 0 120 120 0 I Local Overmach 0 0 0 1,600 1,mo 0 I Total 0 0 0 220D 2,2W 0 I Smmwy excludes Rog Forwards Region 4 Federal =9 1,595 1,495 3A55 8.815 0 0 Local 407 399 279 370 1A65 0 0 Total 2AN 1,994 1,774 3,826 10= 0 0 Transferred to OTO Federal 154 154 233 233 774 0 0 Local 36 36 50 49 171 0 0 Total 190 190 283 282 945 0 0 Tmnstened to FfA Federal 1.148 308 Z109 435 4AW 0 D Local 297 T7 433 90 892 0 0 Total tA35 385 2547 525 4,892 0 0 CMAO Progmmnro in NFRMPO Federal 3—%1 Z057 3=7 4,124 13,609 0 0 Local 730 512 787 509 2.518 0 0 T.W (-Cl Barg even al h) 4=1 z569 4,604 4,633 16.127 0 0 9122010 NF0737 NFR 1101 Assigned STP-Mseo FNeral S7U 0 164 1=4 .IAW 00 6,748 gt I91,1`5718 Local 0 34 277 291 21 1.t95 0' Total 0 199 IA12 -1691 119 6942 01 172/1 a SST7005,002 NF3087 T—P Pla-1.9 Studies NFRMPO Plerning Fednret SIU 917 672 448 512 Z449 0 0 43 Nod Front Range TPR Loral 191 119 93 IDS 609 0 al 2 DIO SST70U -- NP8051 Ra91.nal Rldoshare Program' NFRMPO RiJnstmirg I Federal STU 824 815 391 368 2,418 0 Ot 443 North Front Range TPR Loci 0 0 0 0 0 0 01 DTD _ Total 824 815 391 2W 2410 0 OI ISST7005.001 NF0800A Ra910m1 ln8latives EMraos Coca do Planning Federal STU 0 200 0 0 200 0 0 t 070 Local 0 41 D 0 41 0 0] 1 Total 0 241 0 0 241 0 0( Page 12 of 29 CADoaunents and SettirV Vr mpomry Internet Foestionter4.OuW k5605S6P001E011atT G- NFRMPO TIP PmjectTablas by Proms rn 1019 2ot0 version m Pb1 1219f207o ADOPTED BY NFRTBAQ PlANN1NG COUNCIL DECE WBER 2007 ❑ Administrative Ar ndmerti # 73 Transfort FTA5309 $ FTA531710.19-2010 FY 2008 - FY 2013 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) North Front Range Transportation & Air Quality Planning Council State of Colorado RLscal Year Koy: Stu. Itaiks indicates change or a cormc0on ftm previous version Solid rM ho: indicates amendment or change ..... .... .... ... . _ . .. since list ven;ion Statrwlde:orReO/ori Four AoOF j Projedprogrammed/bgdgetedin a pool ....Pmjeaswimunlque STiPmtmber I� Dwhwt ry shwa last ftlo l5 Ponds have been mAed forward amendment Dollaa in Tiwusands TRANSIT SENATE BILL 1 (SB1): STRATEGIC TRANSrr PROJECTS 1211irAG9 942 LEI 7,000 0 1p00 i NF0625 Clgr ofOreclay Evans Transit Greeley Tamil Stara t Tmw S8974101 0 0 467 58s 0 0 0 0 Q7 1564 O 0 0_ 01 NFD= North F—d Ranps MPO V.Nclas NFRMPO Tmnak State I Local 1 Tom S&97-001 0 0 U 36 13 51 a D 0 0 0 0 36 13 bi 0 0 D 0 0 o SB1 Pnlgrammed b NFRMPO State Local Total AMERICAN RECOVERY AND RELUVESTMENT ACT (ARRA) - FTA 300 505 4,000 0 4.60.5 100 130 1.D00 0 1,230 400 635 IX0 0 6.M &Zf[000 SST6741.M u za U401 Twasf n Bus Repta—.m Fart Colo. Vehide Federal Toud FTA5307 0 o 2,W2 2d02 0 0 0 0 Z,602 z ism 0 p 0 01 6l2r1D09 I SST6741A79 # 2° ET407 Trawton Prosaa0y Csrd Read— Fort C.Mm Pmrz' umly lard Reader Faded Total Si FTA07 � U 0 41 41 0 0 D 0 41 41 0 0 0 0 811=10 SST6741.030 665 ET402 Lowland Bus Rm eplaceent -- Loveland Vllide Federal Tel FTAM07 0 0 686 686 0 0 30 30 7S6 716 0 01 0 p1 SSTdT41.031 ET403 Loveland aectrome Faeb— Loveland Capital Federal Total FTA5307 0 0 145 145 0 0 0 0 145 745 0 0 0 p1 1$$T8741.M ET404 Berogad am Repiacemerd Berthoud VeJude Fed—1 Total FTA5307 0 0 54 54 0 0 D 0 54 54 0 01 0 0 1SST6741D33 ET405 VanGo Van Replacement NFRMPO Vetdde Federd Taal FTA5307 0 0 100 160 0 0 0 0 100 100 0 01• 0 - of 1SSTS741.034 ET406A GET Buawarh Greetey S Evans Gpital Federal FTA5307 0 360 0 0 350 0 Di Total D 350 0 0 350 Q. 0 Page 18 Of 29 C: Dacarnenta and Setdn9slsehnpa'm61awl Sldn9S1Temp0rary Intetrat FdasiCorlthnLOutloog6USS6POOVJO4tBIT G-NFRMPU TIP Prakct Tables by Program 10 is 2010 Version 1:01' PM 12/9f2010 ADOPTED BY NFRT&AO PLANNING COUNCIL DECEMBER 200T 0 Adminrstmlzye Anwndrnerd R 73 Tr4nsibft FTA5309 & FTh531710.19- IMO FY 2003 - FY 2013 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) North Front Range Transportation & Air Quality Planning Council State of Colorado Fiscal Year Kay: Blue lrallca titrllcares ahenga or a cane 6-fiwn previous vars/on Solid r box irxliwb:5 amendment or change " ' " ' " " •' ' since Out version Statea4de of Raglan Four Pouf _ _ Project programmod/bvdgated 1n a pool S Projects wdh OnIquo ST1P mrmber ,..,. ........ .. ... ..,.... r , , . =Da3nad roa atwas last Projects lands have been rolled forward ... . nmandmanl meta in Tt..arft TRANSIT S317 - New Freedom (cWd) 4f1/2070 r42 -018 NF0935 shutlM sarvica between 3 bRamcri canbers La•.•etmld Slnima Service Fedaol FTA5317 0 0 so 0 so 0 6 A Li Kee, Mad M of the Rocges. N Cob Rehab Ch COLT Local 0 0 00 0 50 0 Local O+er alch 0 0 10 0 10 0 Total 0 0 170 0 170 0 NFR Area Torso I= 5317 Pool Subtotal Federal � FTA5317 0 127 T38 0 265 0 0 [excludes Rol Forwardsl Local 0 30 102 0 132 0 0 Lord Overmatdl 0 0 1s 0 t8 0 0 Total 0 157 258 0 415 0 0 SUBTOTAL -TRANSIT Federal 10,159 27,433 18,455 15.947 71.894 221524 48.170 Local 13.476 8,120 1.832 1,784 26212 7,718 0 Lodi 0—:0, 0 0 461 0 461 0 0 Total 23,1135 36,553 20.748 17,631 98,567 30240 48.170 LOCAL NF&Z5 - NF8535 1-25 r US 341ntarim bmechunge imp —newts Loveland Safely Federal - - 0 - - - - 0 . ... ...p . _ _. _ ....O _. - " .....O ........._... D...............O. ' Loci 11b50 1,450 0 0 13,D00 0 0 rote) ....... ...... ................................................................................:....................... _.._...............:........_ .:_._........................ .,........_................... ...,..._....................... nsso .,......................:.......:...................._..._.......... 1,450 o D hobo _ ................_:................ D D: _........_....... ..._..._....-:.......... .... _...._........_................................................_..............................,..............._.............................:.......................... ' NFr103 NF5t03 31d 1as•25 Phases 1 & g COOT Satoly 8rymvameals Fedorel 0 0 0 0 0 0 0: Rejiba4 Local 0 0 0 0 0 0 2250 „�ota1 0 0 D 0 0 0 2250' MF0763 Ra9iornd Bus PJbtvarious PlaMin00peratiorc odoral 0 0 0 0 0 0 0 L • Local 250 250 0 0 SDo 0 0 --�.-�� Total 250 25D 0 0 5D0 0 D SUBTOTAL -LOCAL Federal 0 0 0 0 0 0 0 Local 11,800 1,700 0 0 13-%0 D 2250 ToWI 11,800 1.To0 0 0 13.600 0 2250 ILLUSTRATIVE PROJECTS Illustrative projects are defused as Vlose transportation projects that would be included in the RTP or TIP it addditional resources were to become available. Ilus"tive projects are outside of the fiscal constraint boundaries of lha plarls and programs and have no legal standing with respecd to trarsportationfair quality coisformity. Projects on the IDustrative fist cannot advance to implementation without an action by the FHW1A and the FTA on the TOST1P. NFDn2 Mason Corridor FM CDIVA3 Desi nIC—t ucrmn rsderal F IA5309 24,381 29,777 0 0 54.158 0 0 rim Stow. Sal 4.877 3.441 0 0 8,318 0 0 NF=0 South Transb Caner to Downtown Tconsit Cantor Local 1219 4.003 0 0 5,222 Toted 30,47-7 37221 0 0 87so0 0 0 SUBTOTAL-ILLUSTRATIVEPR0.¢Cj$ Federal 24,361 29,TT7 0 0 S4,158 0 0 Stole 40ff 3.441 0 0 a,am 0 0 Local 1219 4.003 0 0 5= Toot 30.47r 37221 0 0 67,693 0 0 Page 27 of 29 CADarsmmnls and Sdtugs1selmgrftALoca1 SellingslTemporaty Internet FR.—_lConknLO K%6O5S6P0D0(HIBITO- NFRMPO TIP Rejxt Tables by Pmgram 1019 LVIO Var-bn 1A7 PM T219R010 ADOPTED BY NFRT&AQ PLANNING COUNCIL DECEMBER 2007 ❑ RdawusUative Amendment g 73 Tiansfort FTA53M & FTA531T 10-1--2010 FY 2008 - FY 2M3 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) North Front Range Transportation & Air Quarity Planning Council State of Colorado Fiscal Year Kay: 81Gw 0alks indlrres change or a rorr-Um horn previous vers7m Solid red box indicates amend—,4 or ctanga since Last version .. . .. .. ... .. .. .. .. .... .. .. .. ... ... .. .. ... .. ... .. "Stetawfoa.wReglon Four Poo! _...-..... ...... ......._. Pmjctprogrammed/budgeted Ina pool Projects with unique ST)P number :..:. - ... rod snoa5 last =ametWment 3.6110 Pmjea 's funds have been rolled forlvardd .... ...... ......... .............. ............. ..... ............. ... ... Uolars in Thousands 'rr'y P 07RIE aY�' % a -y"�'�r-;IWIF71 t^s3 4 +rnm r 'r'?,.'.-u„v`Cr•pr'^'l�°,] .l ^"YN.'?.'ST^.^.i")�!N-'tr'!T" a 14 �ir.`.'.'F, �A ;.. !)W8„7D_ P o-wLKiD'e 7 ' .nr o p �d'�y`sG...; +x l ;rt l�eu.:�12 ny ra& ;- �� _..acs at c?! „f.SoW[CC}of M "KFtl9dlag.. _. t .� 7r }`e: .tea T. ,.'fig e'rs �.•Y,.a;. " •..yr a,4 y :•; „:�.� ,: • c �nryp je phon/Lnta$on IPro�ect Sponsort'7;11mprovemetlt7 �'Q �'+v.., 'fSy�,4w} jf..: �.,+I(rFUt,, '`'�k',.. -(-',t G': \Sea.aw}:f.NrrU[i1UB�y.16�MaQw.miW ROE*.4}.gc,2c4:6:+S.b3.tsl:b:'u'e%".1Lw�:. .µ:•.ii 1. f. ). ;.t�..'4 2 Yr .: i.h5 x, ..F'tr'�'" �m"N�; 1pj� �.-{..EL.l)Y.IsC�r7,�'1:�-R ��'/�•'-f�. "T 4M r.3 ,. ra�ii+i..r-.-•4n14e�..s_,wa J,r rf..��...�i .Lv.Lta•.w�nEE Ys......EfG.Gii REGION 4 - POOLS and REGION -WIDE PROJECTS Amounts shone Imrnedbtely bebw are the sums Of NFRMPO sPKft to ftt am part of puob covering 9 counties and part of a 101n w county in Region 4; Region 4ride entries ate not Inud d- ' = Fume ccA a d Includes fw roe pie Nodh FO EIS Corridor Oral eta Wetly addles; write !,rotors wasida Ole Nor'Jn Ford Range Rogan 1 U/112010 F246598, - ._..2CDb'i'fii4_ w .•.»•. , : - - ...., .... ... :Regbn•�BrfpO?�rr��j'olon!:Pool..�..._:. ..... ...::;: .,..::: Vaifous. .... �:,, ..-8iidge -:.::: Total iind'9.�).,.,. .;'BRa ....:: J... ,+.449-:.r 135::'.: ... i-1Zd�;::- ... ..0.. .,�� 1�07- •818�t:.;.� ,�::.-� YW0600.._e h:. �. ,._.:; L(iiR{Tp_Noi�ILglonadyS pni�carrt.PooG .. .:. ,.::CDOT R4 ...': ;'i :"yfat7ous , �..,:•...fi�.., .i .. :_.. , �. .. ... e. ..... �. _.-.._ ,.. � 6" '.' SI10 SR46658,-;. - :RapbRHeiard�QLntjmtjon Pool-'.: _._.: .:-):_.. _:.;, : CL10T R4_.::. • .. s`nfah!.. r:..::Tdefg'Ibc)...:-,.,>: ... 21G21._,i> .:-:1.320�'. 7:3?7:,,�.: ... �Ps.`-_-`a..._-., .w?"L'`.. Q 1 ' (JUtO Rd5606 :..�::..a._.,,, 77egloa4'F_'ASiFRSDfo '•Pool... ,,,•C ...� :: VadeLG .,-'� FhS".f.ER 3aiO.ty....-...;T4tol ,.-v .� _..._... _ :., .... .,0.,. t.: ,.. ::0:__�, 9460..._�,3gd0,::_:`'�?B0�',,.:.�__�7�.. :.0: ..?DO.,.;..5082:........_1<'49 9/t!lOrO SUBTOTAL. NFRMPO LOCATIONS IN REGION 4 POOLS and REGION WIDE PROJECTS 17.1w 25A02 30AS4 13,050 67,499 25A a 1,500,wo Amounts shown immedi4i4 babw are CDOT R&&n 4-wida Iolals which ara avagabla for bpl'aons ate 9 counties and Pad of a 10th wunty. `tFCaa887.... .n-- :��: .:.,: ., . .:: aYiagloa4Triitic BFgnale:?oW i., CDOi RA..a Total °..,,. ,. ,::;•.. _..:;�:_.....:: ..-:.._ ..;:>-�h. ..... ..: ; .., ,... ,.. ,..,,_ .._.. ... ,. ., . :iTagfon4Safaly Ert-harieemerR'Pwl_.?.6]6::. �.......-'.:Q-. SUBTOTAL -NFRMPO LOCATIONS IN REGION 4 POOLS and REGION WILE PROJECTS 2ATS 3.M3 X754 1,304 10,297 3xs 0 GRAND TOTAL OF REGION 4 POOLS AND REGION -WIDE PROJECTS 2o�c9 29,T15 33A4S 14-54 97,7m 29690 1 SW,000 Page �1 C;{Doctmtertd and SemngalmfmQaidaLocal Satangsl7empor,Oy Intemel by Program 7919 2010 Vooion responsible for withholding any portion of Contractor's compensation hereunder for the payment of FICA, Workers' Compensation, other taxes or benefits or for any other purpose. 19. Agreement format. All words used herein in the singular form shall extend to and include the plural. All words used in the plural form shall extend to and include the singular. All words in any gender shall extend to and include all genders. 20. Conflict of Interests and Prohibited Interests. The MPO and Contractor represent that neither has any interests and shall not acquire any interests, directly or indirectly, that would conflict in any manner or degree with the performance and services required to be performed under this Agreement. The MPO and Contractor further represent that no member or delegate to the Congress of the United'States shall be admitted to any share or part of this Agreement or to any benefit arising therefrom. In addition no employee, officer, or agent of the MPO shall participate in selection or in the award or administration of this Agreement if a conflict of interest, real or apparent, would be involved. Such conflict would arise when the employee, officer or agent; any member of his immediate family; his or her partner; or an organization which employs, or is about to employ any of the foregoing, has a financial or other interest in the firm selected for award. The MPO's officers, employees, or agents shall neither solicit nor accept gratuities, favors or anything of monetary.value from contractors, potential contractors, or parties of subagreements. 21. Debarment and Suspension. The Contractor agrees to comply with applicable provisions of Executive Orders Nos. 12549 and 12689, "Debarment and Suspension," 31 U.S.C.§6101 note, _ and U.S. DOT regulations, "Nonprocurement Suspension and Debarment," 2C.F.R.1200, which adopt and supplement the provisions of U.S. Office of Management .and Budget (U.S. OMB), "Guidelines to Agencies on Governmentwide Debarment and Suspension (Nonprocurement), 2 C.R.R. Part 180. To the extent required by these U.S. DOT regulations and U.S. OMB guidance, the Contractor agrees to review the "Excluded Parties Listing System" at http://et)ls.gov/ and to include a similar term or condition in each lower tier covered transaction, assuring that, to the extent required by the U.S. DOT regulations and U.S. OMB guidance, each third party contractor, and other participant at a lower tier of the Project, will review the" Excluded Parties Listing System" at http://el)ls.goy/, and will include a similar term or condition in each of its lower tier covered transactions. 22. No Waiver. The MPO's approval work or materials furnished hereunder shall not in any way relieve the Contractor of responsibility for the quality of the work. The MPO's approval or acceptance of, or payment for, any of the services shall not be construed to operate as a waiver of any rights or benefits provided to the MPO under this Agreement. 23. No Government Obligation to Third Parties. The MPO and Contractor acknowledge and agree that, notwithstanding any concurrence by the federal government in or approval of the solicitation or award of the underlying contract, absent the express written consent by the federal government, the federal government is not a party to this Agreement and shall not be subject to any obligations or liabilities to the MPO, Contractor, or any other party (whether or not a party to this Agreement) pertaining to any matter resulting from this Agreement. cAdatalpropcsalsVort collinsWrmpolflnal editable docsldts 2010 1 6 2011 version for editing by dts.docx IDIPM 1Lwalt0 ADOPTED BY NFr<r AQ PLA "Kr. COUNCR QECEM3ER 2007 ❑ Administrative Ameftdrllent # 73 Tn=fod FTA530B & FTA531710-19.2010 FY 2008 - FY 2013 TRANSPORTATION IMPROVEMENT PROGRAM MP) North Front Range Transportation & Air Quality Planning Council State of Colorado Fiscal Year KW. dies ttmics irdicn(as rtarga w a correcdon loom previous version Solid red box indlwles With U .. , :. 7p ... ...........Y 5tatewlde or Re lonFwrr Poo! i l ProJeet metl/bud eledlbe 1 aro' svlth tml ST7P namber amendment or change sinca last version j'"^.'`^^ J�� Qo°e 0nshed red shave last ( psefect's funds have been rolled farvrard ....., � , .. ... amendment l - Dollars in Tbousand5 UNOBUGATED Rerntm for Delay SNFy;TtY NF5327 SH 56 (%I*Un A Ave) & 1st St B.U—d Special Prognme; -SQ Federal S l u 0 OBLIGATED 6fnto 0 ROW Total 0 NF0533 NF0533 HarmongtShLeids Intersection Fart Colons CNV.Q Federal AQC 65r 40 ROW Impravaraan Lawl 161 OBLIGATED Total . 818 NF5448 NF9448 57tt1 Street In Lovel-ml BNSF Loveland Safely Federal SRH 197 Coordination Lynn 615E WILL RETURN TO POOL State 0 Total 197 NF.{C2i NF5592 SN 60 Nodh of CR 45 Fist of MOBaen CDOT Safety Federal SRP 0 ROW OBUGATED Re01on4 State 0 Tola1 0 NF6446 NF6446 U534 EfO MRI3 L.wdtud Safely Federal SRP 177 ROW , .'plate 0 Total 177 SNF5094.021 P75094 US 55 Service Road I— Ennharezment Federal Enh 367 Also one ARRA fFHWA) Progrwn Local 92 Tnfal 459 Roll Forward Federal 375 4130rLOtU 3,31=0 Qtdy RecomAlation Local 04 Total 0 0 459 0 SNF517:1= Mason Street Bike Pea Underpass Fod Collins CMAQ Federal CMAQ 1543 troll over from 2007) Local 134 Total 777 SU13TOTAL-UNDSUGATFD Federal R041 40 2,D41 Sgbr 0 0 laud 367 0 387 Total 2.428 40 2.428 ROLL FORWARDS (shown Program -by -Program above) Dollar fgu — 33%ea above as'Ro0 FromuaCC (see fyht Idue o oars) address the need for reowpUrg ,.&d by It,. ERP system at COOT vR1en dove phase baW4& imnsfers vAINn projects vddse federal funds rpd been programmed in pne s years. The NFRWO mderztwr aw the d ion st o as Rau F—fdv for completion of tbeso projects do rot deduo tram me elrnem TIP eomrol colors undo fie variwa Program. Page 29 Of 29 cmocwnenls and SaMn95Woi n;;W;M dqI solnp4Temporary, Internet Fria-IConteMUuuoan0O5S6WDZX60L31T G- NFRMPO TIP PmJea Tables by Program 1019 2010 Version Attachment D EXAMPLES OF PROJECT INFORMATION REPORTS Whatcom County Public Works 2010 Annual Constructlon Program Project Narrative Baker Lake Road / Sulphur Creek Bridge #422 - CRP #908013 2010 Annual Construction Program Construction Funding Year(s): 2010 Project Narrative: This project is located in the Mount Baker National Forest, 2.05 miles north of the Skagit County line & west of Baker Lake In Section 25, T37N, R8E. In November of 2006, scour caused by heavy rains and debris undermined the southern bridge approach. Further damage caused by a storm event on December 3rd, 2007 closed the bridge. A temporary one -lane bridge was placed over the creek in the winter of 2007-2008. The project scope includes installation of a permanent bridge and mitigation (bank protection) to safe guard county facilities (road) and allow the creek to migrate naturally. This project is listed #7 on the 2010-2015 Six Year Transportation Improvement Program. New Construction Features: Total Width 30' Lane Width 12' Shoulder 3' Curb / Gutter :N/A Bridge Leri th 112' Project Status: Design of the replacement structure is underway. Construction will be In 2010 during the fish window. Project Funding: 2010 Total Federal / State $1,225,000 (FED ER) $1,226,000 (FED ER) Local $ 190,000 $ 190,000 Total $1,415,000 $1,415,000 Environmental Permitting (Agencies/Permits): HPA, Sec. 404 Clean Water Act, Shorelines, SEPA, CLR/CAO, Sec 401 Water Quality Certification Right -of -Way Acquisition ($ Estimate): N/A County Forces ($ Estimate): To Be Determined MOUN BAKER ATIONAL FORES I o. I I I I -1 / r \ I _ r \ �J\ s Watson N1's 0 Mdersan Lakes 0 W;1DeptShara'EN`;rreh-copperlBaker Lake_SulpherWakemarrative.doc 'oject Name / Title Phone No. E-Mall Address anager. I Robin Kidder, Roadway Engineering Manager 1 385-5058 1 rkidder(5springsgov.com Colorado Springs / Roadway Engineedng o act esc[ pt on:.... ..::.: ,,... .. , ...... _ . e project will design and construct Improvements to widen Austin Bluffs Parkway to six through lanes and appropriate turn lanes at ersectlons from Nevada Avenue to Ruby/Old Farm Drive. Construction done under previous projects along the corridor will be utilized, much as possible, to end up with a consistent six lane arterial corridor within the project limits. Specifically, improvements at Austin tffs/Nevada, Austin Bluffs/Union, Austin Bluffs/Academy, and Austin Bluffs/Old Farm will be incorporated into the project provements. The objectives of this project Include: • Provide improved mobility per the East-West Mobility Study • Reduce accidents and congestion at signalized Intersectlons. • Enhance roadway capacity and safety, • Adhere to the City's "complete streets" concept along the corridor. • Identify Right of Way needs and acquire the ROW needed for the corridor. e.project scope Includes corridor development, preliminary design, permitting, public information and outreach, final design, ROW qulsltlon, construction, and construction management. The design of the project will combine two PPRTA "A" list projects into one )]act, namely the Nevada Avenue to Academy Boulevard and the Barnes Road to Old Farm Drive. y,ProJect Status: - -; LI The project team is currently evaluating alternative alignments and is In the process of selecting the prefered alternative. s A public meeting Is tenatively scheduled for mid October where the preferred alignment will be presented to the public. Project. Schedule ,.. < ConsultantlContractor Status :. Desl n 2009 2010 Matrix Design Group Notice to proceed May 14 2009. f) Right -of -Way, :2009.2010 N/A Constructlon 2012 2014 a JWA -S. plx �,ew 7$, Sf I' sx..%f�l`d , -.'�'� •s2+..����Af�����"Y.`�iw'rd��`�'��Yq:� �'}x'U�<.+l's";N c�•'C�i1' 3 .,fir' S'. •y yr� $ lS-�a+`E��b'T. '.-.o'k.k'�`i'��tAaB•"ls. �e ? wk�dz' , _ua *e efi+'`fii�e`•'.�' ��..b.3: tt .'A, �- 't.-�. q, t� R..� � ��.3 •.. ,.. Funding ;.. .. �: n � �� FUndlrr SOUIce3 .. fhruZ005.. ;.2000- 2007 2008. 2009 2010 2011 ,; 2014.2014 Project Total i PPRTA $ 1,700 000 $ 28,237 754 29,937 764 1 Other E lain $ 700 C00 $ 28 237 764 29 937 754 F ,�.,�.� Cc 'htIIMI+a$-h '6 iF"�1�':c;•�2' •J 7*_ •xtY•,F+�rcx. k5f 'ro[•c..5 q• rtF',w75z,u,`h ,t.- YF*$ty-a�" i°�h d� 'HFM eC :+,arb<?.F i °r<:'dy,�e(�. ,(c`� C77 t2tb s;[ S 6 ,,�y' r-y.,.9� 4 Fat enditu►es `es of, June 30, 2010 Design & Construction Management $6123673 Right -of -Way Acquisition $0 f Construction $0 TOTAL8 28 3 IM f'=ne�i,^e`t��"3�''.az'a�'lr m.t`�.n'�'i..,:.�a`" �e's`a es",. C1 r''��•. �' �t --v. ,x 1 r �. v i ,.+ ,cwc'zs +, .v'^-w �.�?�.. ^" -s f tr i - ..���N-,il�&_a•..:H �`5 �i.x`it�- "- i'��'s"�a '3t�'-.� rs Additional Comments,) pgpp PPRTA budgets based on most recent PPRTA Capital Project List s l� � s 1'-� �3N �) R�-#1.� zS:e3'N.L I.' ,k. .: E• C�L.Y.nzSr. .a.N dW.R .rk s.V-. F+- 3 Rt L .:S afJ...l ?' - i i._44V' ✓`x•!. 2.v4s n d - Fk. _-.,J"R.: t -SY v:.<:t.'� F"n.Y rf Gi I'S � S � tr�a C_ 1*:F�C'_^•3 .��..l�hNr..S,: 'R`iY`x..Y L"t:GS!F!FX. M.rt4h`Ye:.XL ._i.•.x's�.l: ":.Y 'z. o.(c•..� <.: _..xi _x�•-wi :s __+�.. _, e.._,vw�.,. .... Win._.... w...._ _-......... _.- �..... .... .. .... _... .• _, _X{J'.. _w.aa.�. City of Colorado Springs - ProJects and Programs Quarterly Update 1 2nd Quarter 2010 MiltonPPRTA E. • • South MetroAccessibility, Phase 1) :. Capital Prol .1 �yProject a ,. „. a . M e - rzTl.' .. �PSCt.3�a�u�R'Tea...K•�i�.(nYia+-Wr�Ef4�ii.Y. '=�riLt. {vsckaUM.3w1vV±H`lu -motet: t y� Tat�,ieA .... . ,s13".atnr3691'i,�Yi"va`N+R�i jK„...-kit ne o. h-Mall ACIC10553Lead en { Project Manager g Robin Kidder, Roadway Engineering Manager 385.5058 rkldder�y rJrsodr, *asnov.com Clty of Colorado Springs 1 Roadway Engineering Pro ect Description: 4 • This project will implement the. Phase I Improvements recommended by the South Metro Accessibility Study between Academy Boulevard.and Powers Boulevard. The total cost for improvements Is estimated at W,440,114 (in 2009 dollars). 0 The project scope Indudes co ridor development, preliminary design, permitting, public Information and outreach, final design, right-of-way (ROW)'r acquisition, construction, grid construction management, �t;,rc� °��- e5.�a3`��.,� :s �,x �• 4�:=.�f.s�s..i.n '!`+fi'�:'ipi . k;� ... t,€.'�'...r _;?�:tr .rF§s.. s:� �,r.> �.,.�k�15' `�;L;i' �x "5�:.. .. Pro ect Status:- - • Construction has started for Phase I Improvements between Academy Boulevard and Powers Boulevard. • Local access Improvements have been constructed as part of an Early Action project. , • Utility relocations are underway. • Construction becianInAvr112010andis 10% complete as of June 2010 �yy �",>'.:Fl<zrnxaMar.n . n.t,a�u.>T.aisf �s+•mrsrisr w:,-w yi. 2..-:.. r_-- .. ., r._. c.._... t:._.: s_.. t.. is- AP.Tw.x s]�`iy`+1HL"'S,.i:^ti.i4Ya k=rrtcesQ Aerial view of roadway grading 3u^aGS��F :.3'3sc9c.. _,mot 1 (left) F Sound wall construction (right) tj 1 Calsson ddlling (left) ?d l � Storm sewer construction y; i' (right) Project Schedule Consultaiwcontraotor .: Status as n 2006-2009 URS Com lele Right -of -Way; o late Construction of an early acton project Is complete. Early action utility duct bank complete. Nodce to 12007-2009 Construction: 2010-2012 Ames Construction, Ina Proceed Issued Aptii 19 2010 for main pro/ect. a�. L.f .�.-..%:,-',''K,.s;d�'r�','eR+'=t+i=`N9 y ... 123if, s°WE— Funding ttini i Fun din Sources: 2005 2001i 2007 2008 .. 2069 2010 3011_ 2042 .. ProjeclTotal d PPRTA 5 109111. $ 604,318 . $ 2,069J87 $ 6,661,483 S 7 806;456 d 18 455 384 8 19 322 083 1 S 2,412,094 S 55,44D,114 Other Ex lain-; $ - TOTAL109.1il Is 604.3161 0,061,483 OB B 8, S3 38< I 19,322,083 2,412.094 0 514 ('� Expenditures as of June.30, 2010: � �r '::�,+ Des) n 6 Construction Mana emant $308.377 RI ht-of-Wa Ae ulstflort 1. $6291827 Construction 1 $4 636 839 � TOTAL 521249043 Additional Comments. PPRTA budgets based on most racent PPRTA Capital Project List �.ir�A . a.l ci.3'.t: "'1'.•� .. ks�:...��:1.... _. L�... �"A i.. .,� .E... `4`C...,1.,�..J:.. }' �i City of Colorado Springs - Projects and Programs Quarterly Update 2 2nd Quarter 2010 PPRTA Capital Project • • Street Improvements � ;y #' •.: - Project KamI Phons No. E-Mall Addres Lead Agency Robin Kidder, Roadway En I eerIn Manager 385-5058 rkldder Manager: ay B 9 B a(Zsonnasaov eom City of Colorado springs 1 Roadway. Englneering �A sm , .p , : = ''1F . i, �3.'{T 'M'r':� ` R i}^ ✓' :X' 4 7 �Sts� 1•�l , lP,�rr.gLl Si:n�' F:��}2 i+' A .1t�'' ' .i[if'iC,r,.� i% ST+� i ;S t`% - 1. x ,aq.�,�. .R.n;...F✓r1t.����+ .a�`si-Y K lr. Project Description: 7e intent of this Intersection improvement project js to realign El Paso Street,. provide better turning radil, install new traffic signals, and Improve the safety of pedestrian crossings. N' L4.FR - f"J` :R'°-.,Y SJ. F•'Y s(i „�+de �"��.F,+i•�F4 11T TM ti V i Ei tS� : _'ii'^Y:fi�clgv. i 'l''.�'& WOW �iI T»�: a Project status, Blue Rldge Construction was selected as the construction contractor, Constructlon was completed In June 2010. �sJ R t� >;IU... � ..ram' - •-:i Intersection Improveinentswere completed to June 2010 ,� t. v, n,,....,. _x,:w�is�,_ M...�.,. ...,.. .,.> Yr, =�.°Ma i r a a �l'3 - ✓r - l k w Project Scitetlule :: ' - Co nsultan tlCoi*46tor: IStatus. =y Design: ISept. 2005 -Jan. 2007 lWilson & Co, lFinal design Is complete. 1 R ht•of a Feb 2007 -Set 2007 NA Com eted ons ruct on 20 0 ue ge onstrucl on JCorn feted WP`'xr Fundln a .' 9. - Prolact :� Funding .Sources. thru 2006'. .2008 ..:2007.. - - 2008 .. 2009 :. 2010 2011... 2012.2014 Total �= PPRTA S 98 303 $ 42,6 8 r> . 143,436 $ 3,135 $ 342107 $629 649 1 { ; HES FY 2007 $ 226 000 S 225 000 1, TOTAL 96, 0 267 668 43 436 $ 3,135 $ 342,107 $ $4 649 s•5 �n�'i�"�°Fxs�a tn3"�'�`�3£F.�.rst�urAau y' �^'v$ V:'�1iF�� t��"�c'f�a �s�f.�?�,�2't�'Y nit � r°Fc�r'�7sk u�,:�s?fl`d>� �s�kl��,-a'�a? '.. r a'�� �„ �'�+ #;�'�x���-�'� �;,� -s .... ... .. .... Expen as of June 30, 2010..:_'_ .lures a Oe3f n 4 Construction Management $115 985 Rl ht-of-Wa Ac ulsfflon $123 666IN `$ Construction $211 4f0 Construction HES Funding $248 822 si t TOTAL $697,683 .....,. ,.x.Fx..:, �a,.,.,i '�k. ,, .de ."� .�i�9 .1 Y .k:.J.lw. � t+n`kls .Sid `�1ht ft:,.t `�s.�+.�#i�a"�F.k.-.st_n��r: 3,�.rY`•�.�.{,Y"'E�"��.� a'`"',�[.. a�,.r��'��>�� ..c 1 Additional Comments:: t PPRTA budgets based on most recent PPRTA Capital Project List h -M. 3s Iurb a d �trsy3� I New andlor undatedinformationbolifalics t4s+,ANRI T.r3.�i „`t•#.�fipyiry l jn v1 .'xt4'� � �..�Yrt fiiFD d-k �h) 6 ti` Y �,r 5m' iy � y, �E � .Y...r.5-a .,.�,:v\.i_e.....__•8�-,cT.':Lt....�..h,.wb,.ce '.r.. �..-Lr<+,.:......e..�•{,a�..i:td-v .`�:�1�.i1...F:tii &44�'1`.''i�.ke., �ivl01 %1� City of Colorado Springs - Projects and Programs Quarterty Update 3 2nd Quarter 2010 Pro eat Status: t The pro fect team 17i currently evaluating alternative alignments and is in theprocess of selecting the prefered alternative. A public meeting is tenatJvely scheduled for la to September to present,the preferred alternative to the public. ��,.": F�t�3sv",�.''rirrt i-"£,i .',4'�n,,� t- -t' y a .�, ��3 > .�i,s: F' <,.u-,:rr- "c.:F..i� 'e �..... � r i -� u U✓:, as •�t F r„ � #�"�S�T"� y r �y ,£� � • 1,��-c;` ft'- ' wv. !f ;^'v � i�°� ��i�;�A�.'v''�t �� ,j�,'G,.��,F �"� �'�`'"'� t��,'�a�. `� p3: STUDIESCITY INPUT ALTERNATIVES ALTERATIVE ALTERNATIVE ` 4jt , {tint m'.SF ..-..,�.... -x F 32+rTY`�rK `'�"'"a �'' e*S.el' ,^ >�, `g.'.eq'•. .. 4t� (�'t' j'.16'�mw g� ........ ..... ..3�i '''e£ ? i -..- ._. Y PROJECT STATUS ?fir" m. `74`ti fi. ''�,' -vSu" i z ry,_S?P 'ri- �/' '` � t.� �. _ t 1 it F _ 'e' f � 1 Y � �t s4 i' G'> p>, i" 'ss;?cY"� i C.a�Y.?rt '✓y\.i �NF � �rC 1.'\SiL✓ i3 T' i' flyy1e�5 r! I+k w� d(^33. 2„s��3 �. yi ; ,tR ,'; f Y"'�� ,',+,�'J'ai�+ 1. "' Y'^L ,�{w�-ty''.'t wi 'f: S'�`�ixl'�'A�"�`�'fio.t���Y:F:�tYY��V`�t.` AE' c.�'q�Fx �k�r`�Qr�?�]'S�"�S`�'-iF` �s.�"�31'�F���"{�%•3K4'r� xC:_1�k�,•+3 3,E-'�-aea.��3a3} i.�Fi"�`�"M^"'Si6�.uet „ice t�4`ba��Flt�3�.``. Project Schedule. ConsultantiCtintractor' Status . 1 Design: 12 Months URS URS was selected as the design consultant. i Rig t of-Wa : Construction: ��r� sYry -'SF iF&��.r "5.a'�2Y ,,.-6s' :7.e�sr�-Z�S.:�n'i 'i�`f°'h�+i'�� v�`M" : £'s-�'iiW� :F•i�; •i..r�'3+i). xt`�5��...��"s,�F`�tit?� m � ''"'x'; ° a'@'n,`.,'.ithv:�aT(�.i�.+,s .�'.� ir�v. �+.4�` �f.:��`� Funding tl!ru ."�J.�J 2006. 2007 Funding Source: 2005 ::LEf 2008 2009 .. 2010' ., 2011 2012-2014 Project Total PPRTA $ $ $ $ 1000,000 S 200,000 $ 3,870,410 $ 5,070,418 ¢e CSU/TranslVPlannln $ $ $ $ $ 1,000,000 $ 200,000 $ $ 3 870 418 5,070.41 '":'-'�=s'�wrr �2',}?.fix 3r',A. ^31t C'4�i4iF3,�,sa. ti';lhrt'�'". Expegditures`as of June 30, 2010 x - Des 1 n 6 Construction Management $B2 365 t j Ri ht-o/-We Ae uisitlon Construction TOTAL 365 =Y 1 y � y$82 a I<: Atltlitional Comments... PPRTA budgsts based on most recent PPRTA Capital Project List City of Colorado Springs - Projects and Programs Quarterly Update 4 2nd Quarter 2010 1 Manager Dan Krueger, Sr Civil Engineer 385-5385 dkrueaerfdlsprinpsrzov com City of Colorado Springs ! City Englneer!ng: 'v M.. , .J iM :N_:'Wrn.. 4.: Y •.,. - .a+ w r. •.:�ntu... w+.v v.� - W. y!•.. .. .. ..: ,.. Project Description:. • The Nevada Avenue Bridge developed holes in the bridge deok on December 26, 2007 and December 22, 2009. a. z • The project will develop and Implement a bridge deck rehabilitation strategy to extend the life of the structure approximately 20 years t Project Status; • Union Pacific Railroad draft agreement and PUC application In process. • Construction is easement acquisition complete. • Plan to begin construction In late summer 2010. •, . US Roads has been selected as the construction contractor. vv eves . Htinat 9 \its � p-tri rrt jjjj ` The medlar ' a7 Zac .. _, Street will be closed to ��` �� '• ,'� enhancesafery. Hsu4vA'HreopB k `1 77� ikx'arr ycNt.. r Nil - /` i ';-�+.r-x_;rxr-:_.+�ai;.T 'ua .: .:�',",ia 3�.�riru'�;d•'s_?: 2i"T.S, .: :�-�: *CE f.:a..x .. �._. :: >•a .::a+r�rir.� _ M13n13........ ""-�• ,: ,°=_� ;''_'4sm 4 +?a' .-._.;rss i,u"Y; :;z.' Project Schedule Consultant/Contractor. Status r Design: N!A LONCO Completed i;RI ht-of-Wa : N/A CI (PPRTA Temporary ulstlons om lets. M= ,.a1 Construction; ITSO a r -A'ik• t,isri�' US Roads ,axe a.' <.-. .,5£x r-.:_sz:• > -zu j._ 4u v .- .:. nx. r .�.. +a :cxc.,._.. Summer 2010 start date tx. .us.,e,;F,.;-s... a c, ,.r+:'�; .ec... ' s r ,a-:rrs eAh k ,s. r rs' Eunding Funding Sourca.,. ' t .ru 2605 2006 :... 2007 2008, :. .:., 2066 2010. 2011 Project Total ' zk PPRTA $ 141,334 $ 90,735 $ 867,930 S 1 099 999 y COOT $ 250,000 250 C00 1 E TOTAL $ 391,334 $ 90,735 $ 867,930 $ $ S 1.349 999 )) -+,uii&+i'S99C', lmN` Y-.:•xN•?Y ..i.:fi+i ::: P '. f-5: Y i'+^ "+A-Ct' :'.l", ,+"life _...} !'4' ,1a I:.t K.1 tt 4,� 'i'✓ Y. M1v'r+:'� 3 �� ..s.. - „5 Expendltures'as of June 30,2010 ' ti A Design 1 $233,698151 Right -of -Way Ao uWtion I $2 529 Construction $0 TOTAL $236 227 1 t- 1.. '�. Y-^y1"� -e•' -^: /f `T Y:., yV+'M� !"V L S.P.•. - chti.. .M fi'. "±F+-!. ?L. �f•.'•:blti? w 13:i Y f }-w; 1[ . - i" C%W .t £ti •• ..Y'.• t 2.t1'. i A ono ornmen s:: - . PPRTA budgets based on most recent PPRTA Capital Project List New and/or updated information is formatted above in bold italics City of Colorado Springs - Projects and Programs Quarterly Update 12 2nd Quarter 2010 PROJECT NARRATIVE Construction of a muttimodal roundabout at the. intersection of Northwest/McLeod in conjunction with, but subsequent to, the 2009 construction of bicycle, pedestrian, and roundabout facilities on Northwest between West Baketview Road and Interstate 5. MULTIMODAL TRANSPORTATION BENEFITS Sidewalks, crosswalks with safety refuges, bicycle ramps, transit, auto, and freight safety, & efficiency. PROJECT STATUS: (ES-360) Construction scheduled for Spring 2011. 3 I Multim oda l Roundabout Southbound Interstate 5 JES-360 (Subtotal 1 2,6401 Boild I I 1 11 1 p 2,640 No Text 24. Notices. All notices provided under this Agreement shall be effective when mailed, postage prepaid and sent to the following addresses: Contractor: MPO: With Copy to: Data Transfer Solutions THE NFRT & AQPC City of Fort Collins Attn: Lakshmi Ramaseshan Attn: Stan Elmquist Purchasing 3680 Avalon Park Boulevard East 419 Canyon Avenue PO Box 580 Suite 200 Suite 300 Ft Collins, CO 80522 Orlando, FL 32828 Fort Collins, CO 80521 25. Incorporation of FTA Terms. This Agreement includes certain Standard Terms and Conditions required by the federal Department of Transportation ("DOT") and other federal and state authorities, whether or not expressly set forth in this Agreement. All contractual provisions required by DOT, as set forth in FTA Circular 4220.113, dated April 15, 1996, are hereby incorporated by reference. Anything to the contrary herein notwithstanding, all FTA mandated terms shall be deemed to control in the event of a conflict with other provisions contained in this Agreement. Contractor shall not perform any act, fail to perform any act, or refuse to comply with any the MPO requests which would cause the MPO to be in violation of the FTA terms and conditions. 26. Grant Assurances and Federal Requirements, This Agreement involves the expenditure of federal funds, which requires the MPO and Contractor at all times during the execution of this Agreement to adhere to and comply with all applicable federal laws and regulations, as they currently exist and may hereafter be amended, which are incorporated herein by this reference as terms and conditions of this Agreement. A non -exhaustive list of federal laws and regulations that may be applicable is included below. By signing this Agreement, Contractor avers that it is his or her responsibility to be aware of the requirements that may be imposed by the following federal laws and regulations, and others not listed, that he or she is aware of any such requirements, and that he or she will comply with all applicable laws and regulations. In all solicitations made by competitive bidding or negotiation by the Contractor of materials and leases of equipment, each potential subcontractor, supplier, or lessor shall be notified of obligations under this contract. a. Laws and regulations prohibiting false claims and statements from being made to the federal government, 31 U.S.C.A § 3801, et seq., 49 C.F.R. Part 31, and 18 U.S.C.A. § 1001; c.Watalproposafslfort colllns%nfrmpolfinal editable docsldts 2010 1 &2011 version for editing by dts.docx PROJECT NARRATIVE: The Lincoln Creek Transportation Center is located along the Interstate 5 corridor within a quarter mile from Exit 252. Approximately 7,8 acres are being redeveloped for public transpottation�related improvements to serve Whatcom County, including potential future capacity to serve 800 vehicles. WWU.and Whatcom Transportation.Ai thority (WTA) are working together.to improve and enhance this site. WWU provides on -going site maintenance and serves as the lead partner. NVTA provides 15 minute service _within Bellingham and 8 round. -trips daily from Bellingham to Mount Vernon. The City of Beffinghain is not a fundingpartner for. this project PROJECT STATUS Phase 1: Financed by WWU; transit pull-out, lighting, and new site entry (completed 2004). Phase 2: Financed by FTA & WWU; NEPA study (completed 2006), stream restoration (completed 2007), and storm water detention vaults. Phase 3: Re -grading, paving and safety improvements. Phase 4: Lincoln Street frontage improvements. Phase 5: Increase parking capacity from.530 to 800 vehicles, � Cost_Est�mates.I040 �? , f .DQIIats ,. �rypy■,`,.y<�_' 7 No: PROJT DESCRIPTION, .:, .; SOtRC_ 31--: OTALS WWU Uncoln ree Multimodei I$ Transportation Center Not a Cif Pro act, No City Funds F R i l . y i :R. _ Subtotal 3,748 6,2501 10,038 TRANSPORTATION IMPACT FEES COLLECTED Non -city; Not Eligible RIGHT-OF-WAY ACQUISITION NECESSARY No \ �W1 t ' - + `COISOiAATKNh1Ts bi vV ZL y c df fry 1 4` �l . ti Attachment E EXAMPLES OF NFRMWO TIP AMENDMENT FORMS: Form 55: Example of Entry Revision Form 57: Examples of New Entries Form 67: Examples of Rolls Forward State FY 2008 thru FY 2013 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) Request No. 201"11 North Front Range Transportation Ft Air Quality Planning Council March 30, 2010 Prepared by Kathy Seeihoff CDOT R4 DRAFT Amendment Form 55 Edaed by Stan Eftnquist NFRMPO Adrnmisb-ddve Amendment DOOM in Thousands STIP IDIVVBS to TIP Route Beginning Ending County Project trnprovement Type Fund, AL Number Number Number Ref Pt Ref Pt .� Sponsor Source Type qqTFY 08 FY 09 FY le FY11 FY 12-13 Future Entry: Project Description'Location: ES409 Larimer CR 17. LCR 48 to LCR 8 . Larlmer Larimer County Project Descriptlordl-ocation: E,S409 Larlmer CR 17: LCR 48 to LCR 8 Larimar LaLrimarCounty Page 1 of 1 Surface Treatment Fed ESgfMN9 3,487 Total 0 3,487 0 0 ?AZABZ 0 Stda(>-- Treatment Fed ES9tMN9 3,487 57 Total 0 3,467 57 0 c osure savings onWeld 7- State FY 2008 thru FY 2013 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) North Front Range Transportation & Air Quality Planning Council DRAFT Amendment Form 57 Administm&e Amendment Submitted to: CDOT Prepared by:. Stan Eirnqwst (from Larimer Co Request) DATE: 61412010 Dollars in Thousands STIP IDAVBS to TIP Route Beginning Ending County Project irrFunding ',, TOTAL Number Number Number Rat Pt Re-f-PIt Sponsor iprovernent Type Bounce Type FY 88 FY D9 FY 10 FY11 FY 12-13 Fuhnie Entry' Project DescrIptionlLceation i'mol lyF0955 Larimer CR 11C at Horseshoe Lake Spillway Sir. No. LR11C-0.7-24E Latimer Latimer County Entry: Project DescriptiordLocation Imol NF0966 Larimer CR 50 at Latimer and Weld Canal Str. No. LR50-0.2-17 Latimer Larifnar County 3ON: re66m�tn* a n iiid6vspac61h� Page 1 of 1 Bfid 0 pe Replacement Fed BRO 0 0 560 0 U Loc 140 0 0 U Total 0 0 700 0 0 0 Bridge Replacement Fed BRO 0 0 0 funding:. 880 State FY 2008 thru FY 2013 TRANSPORTATION IMPROVEMENT PROGRAM (TIP) Inlilaily Reed from, Greeley North Front Range Transportation 8; Air Quality Planning Council August 30, 2010 Amendment Form 67 Administrative Amendawnt Submitted to: GDOT Prepared by: Stan Elfficluist (from Greeley request) DAM 9/imio Collars in Thousands STIP DAVDS ID Project TIP Route Beginning Ending County improvement Type Funding T ype Number Number Number Ref Pt Ref Pt S=GT Source FY 08 FY 09 FY 10 FY-t1 0-Y. a 1S; FY 12-13 Future , Pray-w-us, ET&T. Project Description/locatilurr. t�- ST6741,009 NF-33 Greeley: The Bus Operating Assistance Operatrig F FrA53O7 752 790 0 0 0 L 1210 1,270 0 0 0 Federal Share: 38.339% 38-35% Weld Glee ley. 2,060 0 o7-144D22� 0 0 Revised Entry: AFT n . ...... . I N' E Project Description/Loa4w ST6741.009 NF33 Greeley., GET Operating Assistance Operating F rTAwoT 752 790 819 860 0 0 L 1,210 1,270 879 860;,�-� 0 0 Federal Share: 38.33% 3835% 50.00% 50-00%; Weld Greeley Total .1,062 zwo 1,638 1,720 0 D Project Description/Location: ST6741.009 NF33 Greeley., GET Operating Assistance Operating F FrA5307 819 0 0 L 819 0 0 Federal Sham' 50.00% 60 Weld Greeley Total 0 0. 0 1.638i 0 0 .REASON: availm 0 Project DescTiptionfl-ocation: NF3538 Greeley: The Bus F FTAW07 426 442 0 0 0 L 0 Federal Share: 79,33% 79-93% . 71h63%; ST6741.012 NF3538 Greeley., GET Preventive Maintenance F FTA5307 426 442 0 0 L ill ill 71 124 0 0 Federal al Share: 79.33% 7993% &,,4fJ:;`.,-; 80,ODY. Weld Greell. nfive Llibiter. tance Total S37 553 �ta ... 620 0 .................................. .......... Project Descriptlofulocation: Sr6741.012 NF3538 Greeley., GET Preventive Maintenance F FTA5307 480 8 0 0 L 120 0 0 0 Federal Share: 80.00% Wald. Greeley Preventive Maintenance Total 0 0 0 600 0 0 ,REASON: ..... .... Page 1 of 1 Attachment F Example of Investment Flier Report MPO Local Match — An Investment Julv 2010 1. Benefits of MPO Participation — MPO Products & Services ■ Regional forum of elected & appointed officials ■ Qualifies local governments for federal & state transportation funding a Long-range, regionally coordinated transportation planning a Development of cooperative relationships and financial partnerships a Providing federal & state funding participation in local transportation needs n Shared costs for products & services [regional intelligent transportation systems (ITS), transportation & land use modeling, regional air quality planning, transit assistance, socio- economic & transportation data, etc.] 2. Fort Collins Local Match History The following illustrates the local match contributed to the MPO from 2000 to 2009 for participation, services, and activities: FY03 + +r FY04 F�f05 FY07 FY08 s ` FY09 s TO�pL kF)�06 a $58,479 $63,952 $77,667 $78,777 $84,191 $77,378 $54,219 $494,664 3. Fort Collins Capital Return on Investment (FY2003 - 2009) The following illustrates the financial benefit for participation in the MPO: ► >$1,795,000 of federal and state funding (for Congestion Mitigation & Air Quality Improvements, CDOT Regional Priorities, Surface Transportation - Metro, and Transportation Enhancements Program Projects) (see reverse side for additional information) Fort Collins Summary of TIP Projects. Programmed (FY2003 - FY2009) . Program Fed/State $s Reference TIP Number 2007 ATMS Traveler information CMAQ 137,000 TIP 3 29 04 NF0703 2007 FC Bikes CMAQ 35,000 TIP 11 07 NF0759 2007 Fort Collins Test Ride CMAQ 70,000 TIP 3 29 04 NF0760 2007 Transfort Marketing CMAQ 145,000 TIP 11 07 NF0761 2008 Comprehensive Signal Timing CMAQ 300,000 TIP 11 07 NF0767 2008 Harmony Rd Traffic Responsive Signal Timing CMAQ 350,000 TIP 11 07 NF0768 2008 N. College Ave/US 287 Improvement CMAQ 250,000 TIP 11 07 NF0769 2008 Mason Trail Extension to Spring Creek CMAQ 545,000. TIP 5 28 10 NF0770 2008 Mason Trail Underpass at Troutman CMAQ 600,000 TIP 11 07 NF0771 2009 CMAQ 600,000 TIP 11 07 NF0771 2009 Jefferson Street/SH 14 Roundabout Study CMAQ 364,000 TIP 5 28 10 NF0772 2008 Test Ride Transfort CMAQ 68,000 TIP 5 28 10 NF0773 2009 CMAQ 68,000 TIP 5 28 10 NF0773 2008 FC Bikes CMAQ 88,000 TIP 5 28 10 NF0774 2009 CMAQ 88,000 TIP 5 28 10 NF0774 2008 Alternative Fueled Bus Replacement CMAQ 840,000 TIP 5 28 10 NF0775 2008 Fort Collins Bike Library CMAQ 66,000 TIP 5 28 10 NF0776 2009 CMAQ 66,000 TIP 5 2810 NF0776 2008 ITS Transit Information CMAQ 240,000 TIP 5 28 10 NF0778 2009 CMAQ 240,000 TIP 5 28 10 NF0778 (see next page for additional information) Fort Collins: Summary of TIP Projects Programmed (FY2003-FY2009) (c®nt'd) Program Fed/State $s Reference TIP Number 2008 Traveler Info Web Page CMAQ 73,000 TIP 5 28 10 NF0779 2008 CMAQ 88,000 TIP 5 28 10 NF0779 2008 Laurel St '/ Shields Intersection CMAQ 34,000 TIP 5 28 10 NF0780 2009 CMAQ 103,000 TIP 5 28 10 NF0780 2008 Drake Road / Lemay Intersection CMAQ 34,000 TIP 5 28 10 NF0781 2009 CMAQ 103,000 TIP 5 28 10 NF0781 2008 Mulberry / Shields Intersection CMAQ 60,000 TIP 5 28 10 NF0782 2009 CMAQ 179,000 TIP 5 28 10 NF0782 2008 Harmony Road / Lemay Intersection CMAQ 53,000 TIP 5 28 10 NF0783 2009 CMAQ 158,000 TIP 5 28 10• NF0783 2003 Fort Collins TDM General Marketing CMAQ 203,000 TIP 5 28 10 NF5398 2003 Fort Collins TDM Business Outreach CMAQ 220,000 TIP 5 28 10 NF5399 2004 CMAQ 577,000 TIP 5 28 10 NF5399 . 2005 CMAQ 226,000 TIP 3 29 04 NF5399 2003 Fort Collins Youth Education and Outreach CMAQ 119,000 TIP 3 29 04 NF5400 2003 Ft Collins Area Emission Repair CMAQ 11,000 TIP 3 29 04 NF5401 2003 Compressed Natural Gas Facilities (Ft Collins) CMAQ 251,000 TIP 10 12 04 NFS403 2003 N. College Ave Access Management Plan CMAQ 224,000 TIP 3 29 04 NF5408 2004 Mason St. -Harmony Rd -Fossil Cr Tr Bike/Pad CMAQ 440,000 TIP 3 29 04 NF5410 2003 Advanced Traffic Management System CMAQ 346,000 TIP 3 29 04 NF5789 2004 CMAQ 775,000 TIP 3 29 04 NF5789 2005 Fort Collins TDM Business Outreach (Not Matched) CMAQ 343,000 TIP 3 29 04 NF6324 2005 Transfort N. Gas Compressor CMAQ 58,000 TIP 3 29 04 NF6326 (see reverse side for additional information) Fort Collins: Summary of TIP Projects Programmed (FY2003-FY2009) Program (cont°d) Fed/State $s Reference TIP Number 2005 LeMay at Mulberry Turn Lane CMAQ 160,000 TIP 10 12 04 NF6327 2007 Mason Street Bike/Ped Underpass CMAQ 643,000 TIP 10 12 04 NF6534 2003 US 287: 29th St to Harmony Rd Regional Priorities 700,000 TIP 1107 NF5904 2007 Rest Area at Prospect and 1-25 Regional Priorities 300,000 TIP 10 12 04 NF5034 2008 Regional Priorities 200,000 TIP 10 12 04 NF5034 2007 Trolley Track Enhancements 108,000 TIP 11 07 NF0731 2008 North College Ave Enhancements 167,000 TIP 3 29 04 NF0788 2009 Enhancements 250,000 TIP 3 29 04 NF0788 2009 Linden Street Enhancements 250,000 TIP 3 29 04 NF0791 2003 Ft Collins Municipal Railway Car Barn Enhancements 90,000 TIP 3 29 04 NF5089 2008 Mason Street Bike/Ped Underpass Enhancements 200,000 TIP 3 29 04 NF5094 2004 S. College Bike Lane Enhancements 144,000 TIP 10 12 04 NF5633 2005 Enhancements 372,000 TIP 11 07 NF5633 2004 West Elizabeth Bike Lanes Enhancements 202,000 TIP 5 28 10 NF5556 2007 Harmony and College Intersection STP-Metro 1,200,000 TIP 11 07 NF0740 2003 N. College Ave Access Management Plan STP-Metro 200,000 TIP 5 28 10 NF5408 2004 West Elizabeth Bike Lanes STP-Metro 175,000 TIP 3 29 04 NF5556 2004 Advanced Traffic Management System STP-Metro 53,000 TIP 11 07 NF5789 2004 Telework Outreach STP-Metro 26,000 TIP 3 29 04 NF5968 2004 Shop by Bike STP-Metro, 7,000 TIP 3 29 04 NF5969 2005 Mason Corridor Bike/Ped Trail STP-Metro 250,000 TIP 10 12 04 NF6260 2005 Replacement Transit Vehicle STP-Metro 260,000 TIP 3 29 04 NF6263 Total Federal/State $s. $15,795,000 (see next page for additional information) b. Federal privacy law, 5 U.S.C.A. § 552; C. Nondiscrimination and equal employment opportunity laws in accordance with Title VI of the Civil Rights Act, 42 U.S.C.A. § 2000d; § 303 of the Age Discrimination Act of 1975, 42 U.S.C.A. § 6102; § 202 of the Americans with Disabilities Act of 1990, 42 U.S.C.A. § 12132 ("ADA"); and Federal transit law, 49 U.S.C.A. § 5332; d. Mandatory standards and policies relating to energy efficiency that are contained in the state energy conservation plan issued in compliance with the Energy Policy and Conservation Act, 42 U.S.C.A. § 6201. 27. Binding Effect. This Agreement, together with the Attachments hereto, constitutes the entire agreement between the parties and shall be binding upon said parties, their officers, employees, agents and assigns and shall inure to the benefit of the respective survivors, heirs, personal representatives, successors and assigns of said parties. 28. Governing Law. The laws of the State of Colorado shall govern the construction, interpretation, execution and enforcement of this Agreement. 29, Severability. In the event any provision of this Agreement shall be held invalid or unenforceable by any court of competent jurisdiction, such holding shall not invalidate or render unenforceable any other provision of this Agreement. 30. Prohibition Against Employing Illegal Aliens. This paragraph shall apply to all Contractors whose performance of work under this Agreement does not involve the delivery of a specific end product other than reports that are merely incidental to the performance of said work. Pursuant to Section 8-17.5-101, C.R.S., et. seq., Contractor represents and agrees that: a. As of the date of this Agreement: 1. Contractor does not knowingly employ or contract with an illegal alien; and 2. Contractor has participated or attempted to participate in the basic pilot employment verification program created in Public Law 208, 104th Congress, as amended, and expanded in Public Law 156, 108th Congress, as amended, administered by the United States Department of Homeland Security (the "Basic Pilot Program") in order to confirm the employment eligibility of all newly hired employees. b. Contractor shall not knowingly employ or contract with an illegal alien to perform work under this Agreement or knowingly enter into a contract with a subcontractor that knowingly employs or contracts with an illegal alien to perform work under this Agreement. C. Contractor shall continue to apply to participate in, the Basic Pilot Program and shall in writing verify same every three (3) calendar months thereafter, until Contractor is accepted or the public contract for services has been completed, whichever is earlier. The requirements of this section shall not be required or effective if the Basic Pilot Program is discontinued. c:\data\proposals\fert colllns\nfrmpo\final editable docs\dts 2010 1 6 2011 version for editing by dts.docx Fort Collins: Summary of TIP Projects Programmed (FY2003-FY2009) (cont'd) In addition, a portion of the following project was assigned for activities in Fort Collins: Program Fed/State $s Reference TIP Number 2003 US 287: 29th St to Harmony Rd - Environmental Overview Study Regional Priorities $700,000 TIP 3 29 04 NF5904 See Larimer County summary for information about the US 287 project from State Highway 1 to the Laporte Bypass. NFRMPO NORTH FRONT RANGE METROPOLITAN PLANNING ORGANIZATION The North Front Range Metropolitan Planning Organization (NFRN4P0) is a federally -designated transportation planning organization & state -designated air quality planning agency. Federal transportation funding to a region's governments requiresthe organization of an M'PO whenever an urbanizing area reaches a population of 50,000 or more residents. There are two urbanized areas in the North Front Range - Fort CollinslLoveland/Berthoud and Greeley/Evans/Garden City/LaSalle. The NFRMPO is comprised of 15 member governments (LarimerCounty, Weld County, Fort Collins, Greeley, Loveland, Windsor, Berthoud, Evans, Johnstown, Milliken, Eaton, Severance, La Salle, Garden City and Timnath) covering 675 square miles and working on behalf of approximately 400,000 northern Colorado residents. The MPO's objective is to provide the information, tools and public input needed for improving the regional transportation system's performance in the North Front Range. The MPO engages in cooperative decision -making through working relationships and financial partnerships among the member governments, the Colorado Transportation Commission, Department of Transportation, Federal Highway Administration, Federal Transit Administration and the Colorado Air Quality Control Commission. Attachment G Example of CDOT's NFR Quarterly Reconciliation Report Federal & Sute funds only CD12008 I NFR Quarterly Reconciliation Report September 30, 2010 Project awaiting TIP amendment Re6ion P iaffi I F:y Pro ffie .STIP" 1 7 1 ':FLi.dlhd A411able A� WeM a' FUm5roWarrhicdC--.,t Budiletec; 47IJnbuccje!� 1 1S Was !',.,7TH J, 2011:- r ' MaV20110TCResolunon .$20.000,000 SP4028 S 20.000,0001 I I 520 000000 1 120.000.0001 S*01 $01 320.0D0000 SR4659B� Regfon:4 Brid a On Systern Pool, RescuroAflocalioni: I : � ocatlomaclustmant;.- 0 roll -forward Transferimm,1310 tunds'from.SUR 9 6: 77777777= SH14 Cache La Poud(e trans to SRS Ent Trans to MWnvbridge Scour DO) UFP Proiect AdJustment q $1.11 U23 Result $10232.234 $4.825.000 S 5,4D7.234 100,000 $4.72, 2D12 I --SR46598 Region 4 Bridge On §ysta. Pool `: - - - ' - .. - :: � ::., - --> , ,Re..urce Allocation .$3.971,908 OFM SAllocallori adjustment ($116.456) --:-:'-UlJASSJG.WED--*:I:.F, 'z Result $3.855.452 $0 $ 3.855;452 0 $3.855.452 '2013*.: SR46598:0..Regiori48(iclqe2ori9sy Stem pool+ 7: % ResawcoAllocabon. $4,119.114 OFNIS Allocallon adjustment ;.:::UNASSIGNED'. % Result $3.953.505 so $ 3.953.505 0 S 3.953.50E 2011? .rSNF517Jc:.CIAAO Poolw'North%Fronl-Rianqe TPR Resouroe*Mdmtlon: 31:526308 7 Transfer to Statewide L '.:OFNS Allocationvadlustmant& $328523 4: -z+ FY1 0 RoVorvvard $3 .421:362 Z �:�SNW73� .027: i �US 34:(Esenho.e blvd) &,Garfield Ave,: - $130,000 130,000 $0 SNF5173:030 'Gremaleybar Optio'Cemmunicallons: -1 $1,174,000 0 $1.174,000 i -w- -!SNFsi 73.033f .-.WLqd County FuellnStalicn' $ 832,000 0 $832.006 =SNF5179.034-. NFRWPO,SiQna4 n,PoDl:�] $2.50.000 0 $250,000 .7 SNI`5173;035- .-.US'287:NIFRiSlgnaiMMino:iLovelandl-"- $120,000. 120,000 $0 W, .* R�Siqnal riming-US34 guv Rv Geeloy NF $130.000 0 $13D000 71 7 SNF5173:037.'.'Loveldnd-.VMSI-25F.US34/CrossmaWs $370.0 DO 0 $ 37D.000 W.: 'S NF5173:038: StStreelscaping lmprovements�'.'...:% 7 $580.000 0 $580,000 '.:UNASSIGNED� $349.000 0 $349.005 Result $4,608,193 3.835.000 $673,193 $ 250,00 S 3,685,000 "'2012 SNF5173 I 'CMAC:Po012 North Ffonf Ranclo.TP Resource Allomflon $1.612A94 OFMS Mocation adiostment $456A9I 77777-777777 77 Result 52,068,96E $ D $ 2A68,985 0 $ 2,000,985 2013. ,CMAQ:Pooi- North rcont Range TPR;�: Al$&Mtjo,' -11.696A28, OFMB Allocation adl,SIM,ntr Result $2,131.660 $0 $2,151,68 0 $2.131.680 COR !'201-1' :J` SR48603:.- RogionACo6gestio Relief Pool RqSaurcer AlloCali3n S6BC.484t -OFMB.Allocialon adlvptmenr%N d; :.$13.359 7 S702,Wr unasslqnadf;% $o 7. 7; Result 1 $694.000 $7,15,885 0 $684.000 — :.2012' .>SR46SL3 .,.,: pool 'F:Wsource AllocaSon $1:134 5 -Undssi�nccl� $0 Result 57.045,593 $1.045.000 $593 $1.045.000 '2013 8 R46603 -:;Reqion:4 CongesSon Re0of-Pool3 -1 Resource Allocacm Ras $1.065,485 Unassigned i $ $1.065.485 S 1,065,000 $ 485 $11065.000 ENS: 20.1.1� 4- -"SNF509 - Enhancem6mtLPool:w'Nonh. Front Range:':-. w-. .1. 'Savinqs on SH 392 Underpass: I .963, 7 SNF5D )94.023� Greeley:No I Ditch, L $8.000 "63 -$96 I:teWft $8,963 5 84D0 $963 0.963 $ TNF .201 19 1: 'SNF5094 Enhancem6ni-Pool North From RWQerTPR,:' 7. Resource-Allocallon: $539.047 6:5%lo EnhancDment Administration. (M,038) OFMBr Allocadon'ad'usirnont+ �1�10:Roll-forwarWr' NF5094 007 + 1-25/US 34 =.Ih $163,000 $153,000 .'S NF509NI 9�91 --North$171,000 CoReCer Ve (Ft CollinsCollins) � : $ 171,000 J�.:SNF5094.016 1� LcwTand: US 287-bike Pad Crossm 64th so $o J�`SNF5094=3j Poudra River Tr. nth No $ 26 000 26.0001 Sol Page 1 of 4 :: FY -STtPI��. -�.. : :- . � -'. .: •. � : • STIP MISS: "::.'�i ..''.: �: Fuhdl _. Available.-. .-Pro ""'.. ed�..'. Un rowaromed' �:8" etetl::' !Unbuifeted' - - - - - - : SNF5094:029: '.: g0 d Lake Ave Greele-Lcw]and Canal 17 000 179 000 SNF5094 030` . -LCR $4G 'T Lake inlet Canal $ 84,000 64A00 $ 0 ' Rmull 5739.749 $ 623.000 S 118.749 S 11 D.000 $ 513AOD • 2012 SNF5094 Enhamemenl Pool - North Front Ran 9TPR—+ .' :- Resource ADocaticn - $539;146' - 6:59Cm Fa+h'ancanient Adminisdation:: 535.04 :' OFMBAllocation.a 'ustment . 350�088 -` 2013 Result "'SNF5p94: P . -:_Enhandemen(P.00P-NonhFronvRan e.TPR .. B• "' .: UNASSIGNED'.. Resource Allocation tl' $554,189 539233 $504:OOD $ 504.000 $ 50,189 SSD4,000 504.000 . .'.� :.:. .. .... � .. �... ': .� ... ..-_-. .5%to:Enhancement Administration. q'' O fMH Atlocatlori- $66.799-: ".=• Result — : �'�"�UNASSIGNED-�:'— 5571982 5504.000 $ 5p4.000 $ 66.962 � � $50a,U00 504,000 d.... ... - ..- . ,. • � .,. � � Ennancemen2 Pools are reduced by 6.5% for Enhanceurent Administration Funds ' .' FSA 2011 ResultPREA :SR466Q6 Re ion:4'Faster Safe Pool' `'.'' ` :AI[ocaLan ." $15:819 945!''. $76.300,OQD . ,. #REFI 17.550,000 $ 750,000 OFMB Allocation ad ustmenY .. ... 5303061. �-$750.000' �, ... .. -.... .. .: .... '. JO'Roll-forwartl:. � '•..�:� ��'. �.. - `• - - ... , :..:5 R46606:006- 'SH392:CBC Re hIr(gTGreel 51,300;D00 IZ00000 SR46606 - Re ion'4Fastar.Sate Pool- .'. SR46508 022:' ' -F25 & SH392-Interchange ROW '.Allocation $16,600 253 250Q'000: 6 400 000 $ 200,263 2500,000 S 6300.D00 $0 $ 10.10D.000 SR46606 035 - :SH 402 Paridise Acres r;y .- '�•.:'.': Result Allocanon:': ' :_. $18.015i346. '. $14,648,000 2S02,fi8fi $ 0 $14 648 000 R46606.035�' -�SH402 Paddise Acres �' � - sw;Rx .... - 46606:038..:'SH392r - - -6. '." '6-' _US'287: :SH 392.Wersection-- " - :.HA2 201:h` Rew9 `SR46666. Re ion:4 Hazard EGminaton.ADul';: �' ROsoume AWCad0n ' � $18,015 346 52243,140- $14398.000 $ 3.617.346 - S 0 S 14.398.0D0 " :OFMB AIbralionad ustmenY• �' ". � •' '� -� � ; 69f029 .. .. - '. - :. ` - - ' -. •' .. , • C : FY70 RoB+fOrivard:: ° .. $691.741. -;:-SR46666:010:.SH:287.Ruers Mlersedtion $15.000 15336 - 336 - .... .:. ..:. :. :.�S - R 46666:03fi-'--SH-397@WCA35:Leh -Turmtanes" '•: ' .<.: :. •` .. ,, • `.SR46666:041:;: ':CER 98E81CRA9TaftH > - II Road . '# ; - $ 110.OW 110.000 5 0 - ., ,: - ...., ` - Result _ . - - - Elimination '>SR46666.045:� Ho Lake Ave 5dv St Guard Rail" ' 90Ao0 $2.794.000 $ 71 E52 WON 787.038 so 62 $ 2;006,9=SR66•-Rein4Hard .� ResorcMention .. 42364747 .., - fMB`A0oca0onad ustment :.. . .. 582:904- SR46666:042.-'BueharvartAve a['GaAleld:Ave��'� '"'" �' � _.$ 301 A00 .. - . .. -.. ..# UNASSIGNED.'.— # S 2[364A00 .. . ' 2013' Result 'SR46666: .... •`Re ien4 Hazard Elimination Pooh:' ,. ""' .. -' -...Resource ABDcation "' > '$2,483.177 $ 2.665.000 $ 282.651 0 $ 2,665.000 .:...' .;. .,. ... '. ''.' 7 ._ - .�, ,� :.:. :OFI✓iH'All ocatiunad stment'..; .': s553797'. �• � � .� � UNASSIGNED-. '�. # . !' ,HOT . 2 Resutl Relon 4 HotS'D6.PD01 ' . ReseumeAlloatlon 136-.974 _. 3241.000 S 2.483:000 $ 553,9%4 . 0 $ 2.4B3,D00 . -.. .. F. ".... - .... .- FMH-Asocatlon.atl'ustment .. '..'.: .:.$21.263' '... .:.. ..: . FYl0 Ro[Romard .. 5325.590 . 'Not assigned .. _; .. # _ ... `: '. :'. UNASSGNEp':' .-.. Result. .. 587853 $0 201V ;SR46667 ReioHotPool R,sourceAu 100. -�OFMB Allocalln-ad ustment �� :--NoFassl ned. [ :... .- .. :', .'. '..' # ., ..., . •UNASSIGNED-..7777 a Result . 0 5361,192 SO " $0 `?Re lon.4'Hat:S ots Pool :._ .., .: :.' - ; > ; # ::.�........ :. Resource Allocation ...-... ... +!. . a. "$361.000 -. ���- .. ' OFMH�Allocation' � usllaent� .::Notassined-.''.- .. .: . a .Result � Bl 771 $o $3s,.m $o $o :MN9. .. 2011. -_. :..;..::,NFR STP: Metro Pool ARRA.'-': .,. >".. .. '. ' '.• "- -$avin scn 37th Stin-Evans' .' .. :. ..: $29:371: "' - =."- ' • .' vins:ontoveland Traffic:o s: .. ,..-$1:717 - .. ... .-.. - - .. .. .. ... .. :: .:.. _ _ undswap Grvn4 t73 Ditch . _ ... - �-•-�. �• ' :• :SNF5788.016 '. <�tCR17::FmmLCR 48 toiCRrB ARRA ','- .. $40.000 --- 40.051 S51 Result $ 40,000 $ 51 $ 40.051 - 51 -201.1��aSNF5786� �NF.R37P Matro:Pool�::: � -.. ��: ,- .'� -' •`.' - ,'_'- .Resource Allocation •� �� 2039064 '" '� � : Tmrlsferto-DTDYornonconstrueticdprojects - "� � • .''" �' � S90p.0001:' : •.: _. - .. .: - - _ �• �• �: OFMB AIbcationad'ussnent 24 .. . ..'; :•'.c,,.� : ��;,� -�:� ._. .'��.-: ... '.. .:�.._.:•. ... .. .. ��.. FX10`Aoll4onNanl•�.'.. .. '_::'. S1'.402360�=. .m' M[Icsure"' G rabley �Trel0o-0 s.$322 - - - - - - - _SNF5.773.030'< �. Greeley Fiber.O "s Communications .'-' 222.000 .SNF5788.021 College Ave(Ft Collins ,Nro �.. 53Q.OD0 $ 530;000 SNFE788:024- . Harincny Rd dmnath Phase2A- 425,00D 425 000 Page 2 of 4 ion • : Pm r.,rii -... : .. - - U ram ".. .0 n -": SNF5788 025 ianmer Coun ��Rtl 19 Near FtCoDInsR RCwssln '. 289,0D0 289,000 $O F.5788 o2B - �SH 392 , ' 200.000 $ 200.000 . _ ... _. .."SN - '•SNF5788.028:.SH252:.SH6D+BThom F5788.027 �. ':. WCR23.(tst :SH 74 - WCR76 Sevemncc : t. � -- :: � "� - " '-� "'- -- - - -' - ^ Thompson Milliken.-. .. - 1 sD.DDD $160;000 ' Result NFR'STRMetro Pool.:_:- - ' - - .�. Resource: Atfocabon :: .:. :. .42i164222 $ 2.539.000 $ 2,900 289,000 2 50.DDD . -.:OFMB AIIocationad'ustment ' ' t '. _ .$666.732-.: :UNASSIGNED:.... .. # $2A 64.000 -- : 2013 Result '.SNF5786 STP - $2.830,954 $ 2,164:OD0 $ 066,954 4 2,1U4,000 .NFR Metro Pool •' .. Resource Allocation . $2286.109 : �• ''<>• :"-': OFMB:Allocadon'adustmt en- -'$830,631'' -: .:: .. UNASSIGNED - ` ` #: S 2286.000 Result Regional Pnont `Pro rant Non:Re ional S' nileant. :. ' .Resource Allocation $2,918.740 2.286,000 $ 630.740 $ 2.286.000 7777777777777 ...,... ..:.. ::.•: 0 treatment Sea•'.. ... :. ,.-�' ..: 13;779000..:.: . '. -BudgetAdustment ... :: • ..:, "...:. ::.. ::.: -.:.,. FY09:Ro8forirad: E9,465. f co" YB7: 3HQto:CaPone 544:12 : �� ... . SNF3389 Bel ass -,SUS # : .175,000 175,000 175.00D --' :'Re iorlal Pdod 'Pm ram -Non -Re bnaq'Sionific-1 'NFR.PreSARProjectClosure.. Remuice'Allocatlon $23.200.076 18,000 $ 50,057 $ 23,1513,019 22.8D0 25D.354 -....-6 4AOD $ 19,984.646 - 2012 .SSR46600 - " •% - ' " OFMBAfbcatlon ad'us[ment ` .# 'UNASSIGNED t " 2013- Re..h .SRa6600 - RegionalPdodN Program- Si nilroam � '-�' �' '. Reseuke Allocation � � $7. 05.910 6590951 _ $ 6:303,D00 - $-0 402.910 " 5 6.303.477 OFMB Allocation adjustment:- 57.347.849 '-SR4e600016 ;:NORA:FronfNot'.YeCDeterrnined� '.#-. $!4;680.000. rSAE _ .2011 Result .1SR46669 _.RB on'4 Safa `Enhancement Pool. " -� - + :- .- .••Resource Alocation ': 7:938.800 S6590;000' S1048,800' $6S90.000 OFMB•Atlocation adustmenf: $141.506 7777= ' FY40 Roo-forwiard.' .. .' • 51.323.893 ' - Result. .., . . # -UNASSIGNED, $ 960.000 •:..- •x.'.:: .: ;, -''20i'2 SR46669-- �Re-ionaSafe EnnancemenYPool'= :'-.''-:' "',- - _:.O ' - ' >Resoorce Allocation -• "$1;509A00�': S 960,000 . $ 1.485.800 $ 980.000 .,. r, ,. -..::._. , :-.:.: ,.: .... : ; .. ,- . ; FMB:AIIo ca0onad'ustmehr;:., $554i481 ., . _ - .,;: .: ,. ^ $954.002 2013 Result - Sfi46669. R4 e ion Safe! �Enhar mentP.00l � - ' ;. : • Resource.A0ora5on. 509 954 000 $ 509 S 954;000 .,. :`' :.: �-.� : - - ..:. .: '--: , • • -,..- ::" . -'." B AlloradonadustmenC �: ::.:. $159:•863 UNASSIGNED'. # . $ 947 DUU SGN Result ^ .SR46B68 ion:4 TmffidSi nalsPool. Resource Allocation . S947.584 5164.262" $947,000 4 $ 58Re 947,000 OFfv18 A8ocation'ad ustment"$13975 .' .. FY70 Roll -forward .; .: ._ UNASSIGNED . ,. SA 64.001) " 2012. 'SR46668 Re ionATraffldSl nals Pool 'Rosoume Allocation:$ ., $240.209 2a5470. $1 B4:DD0 $ 78209 0 S 164.000 UNASSIGNED. .,, 2013 Result SR46668 fie ion4 TralflcSignals Pool ":' "' "' Resource: Allocation "' ". 6245,470 ' , $245.456 -. $ 245.000 $ 470 $ 245:000 .•.. .. ..:.. .. . _.4 .: ..,... •SSR .2011 Result SR46598 R io&-4 Bred e.dn`S" stem'Pool-' - '" : ': Transfer from State.Bd a Ente nse SI..50D.000., 245.000 458' 245A00 >'SR46598.019. TSH14'Cache La'Poudre - '•- g 1,100,000 $ 1.10D,000 g0 - SR46598 028 =. "I-25 Service Road 'over L Thom son - g aoo,00D $ aoD.DoO -' :SUR .,.. .2011 Result. -SR45218. -.Re ion:45urface Treatment Pook' - ^ - ,. esource'Allocatbn :': : - - :.' 1 ,500,OD0 g29 '. E1.500.000 -$0 $1,500.000 0 . .. . ,..'.. -'. ... - .. ..... 07/08Sudace treatnientswa aback .:. .. ... .: 73;779.000 :OFMB Allocation: ' P.M19 � �� 56:413.679 ':. ... - :• .. �F1'1 D'RolFfd[vrard` ..: '. .'.. $2 3 9225 - - - . •- : .. - . ~SR45218 095 = N College AverUS2B71m rovomonts g 300.000 0 $ 300.000 - - '. 2012- ResuR S:SR45218:>-Rewn4 Surtace:7reatm8ntPooGr. r l' .•Resource Allocatoo-:$46.169.689"' $15 759.481 S 13.425.000 S 2.334.481 2.939211 S 10.485,789 - - - -• + :+ - '- 'OFMB Allocation. adjustment PMt9' . .' 11.113.394 zSR45218.075 *:-:US 85: Bus .SthSt m054:'• "-" .'. "'# $0 - - ..:SRa5218.082--:: �9SH 392:1-25East:MP>700moved trorn �FX40 -: $3.692.000 .. ._ - .._ SR45218:067--" � SH T4i1-25�t WCR 23 '10.600,000 ...: .. .. .. :r. Result $ 34.992.000 S 64.275 $ 34,99,000Reiun-4Sudace ::. Treatment Pool -; .. ResourceAllocation:. $: OFMAllocatlonadjustment PM19 : $62787B5 . Page 3 of 4 Ion .Proor3m. ..E`f: :STfP.?- .... .. _ - .STP WBS _. .. .. - FihB ''Avaliatile 'Pro rammed `i .::`Un ru r5rtinfed -Bu eted."r'rUnti' ". ' p,. -: r- - . . :UNASSIGNED $ 34512.000 Resuli 40.791.000 $ 34512.000 $ 5279.000 34 12215 Pape 4 of 4 Attachment H Project Sprint Schedule Attachment H - Project Sprint Schedule S nn4 Meetm s •;�. . ..-, ; <_ , DTS:Tasks', • " :: ' ' . - Sprint 1 Kickoff Project Provide TIP Tables Review TIP Project Tables Provide GIS Data, layers/Shape files available for projects, specific symbology Review GIS Data information Discuss custom reporting features (amendments, investment flier etc.) Review/provide specific feedback on custom fields to be incorporated into the Review custom fields to be added to the TIP database Database Provide NFRMPO Styles/Colors to be used for the website Sprint 2 Create TIP Shell (front-end) with NFRMPO sytles Provide requirements/clarifications on SAP data export fields/to finalize Data analysis / reviewing sectioning of projects into the TIP Tool reporting export feature Revlew/Finalize CDOTSAP data export fields/specs with NFRMPO Provide requirements/clarifications on sectioning of projects Provide clarifications for TIP data and GIS data (as needed) Sprint 3 Developing the basic search/query tool for TIP projects Provide requirements/clarificatioris on Project report format (with additional Start adding TIP projects into the database project pictures) Developing the basic project reporting tool Provide requirements/clarifications on basic website colors/styles of the TIP Start mapping projects for the Interactive Map tool Sprint 4 Develop an ArcGIS map viewer using the NFRMPO GIS data/sybmbDlogy Provide clarifications for TIP data and GIS data (as needed) Develop the basic select by point, search by project no. and project name capability Provide feedback on basic website functionality - search/view project detail, to the map tool basic project reporting Link the map tool to the reporting functionality, to show a project report Sprint 5 Setup the back -end of the TIP Tool (administrative back -end) with the basic Provide clarifications forTiP data and GIS data (as needed) functionality in core module Provide requirements/clarifications/feedback on questions about Analysis of Available Funds when managing projects feature, enhanced project report feature, ability to track new applications within the TIP tool, ability to manage multiple photos for a project Sprint 5 Develop the CDOT data export reporting feature Provide clarifications for TIP data and GIS data (as needed) Develop the Analysis of Available Funds feature when managing projects Provide feedback on the administrative capabilities of the TIP Tool & start Develop the feature to Track new applications in the TIP tool and categorize it to adding historical data using the administrative back -end not display in TIP reports Provide requirements/clarifications on the import of Actuals/Budgets from Enhance the TIP administrative form to handle multiple photos and enable one of CDOT via the reconciliation reports & answer any questions from DTS the photos for the web/project report Develop the RSS Feed Subscription module Sprint 7 Develop the enhanced project report (with an additional picture) Provide clarifications for TIP data and GIS data (as needed) Develop the import utility to read the data from the reconciliation reportfrom Provide feedback on all custom items developed in Sprint 6 CDOT Provide requirements/clarifications on the historical reporting feature to review a project over multiple years and also clarifying needs for the amendment forms generation Sprint B Develop Historical reporting feature to review project funding over multiple years Provide clarifications for TIP data and GIS data (as needed) Develop the export of TIP data into the Amendment form formats (3 formats) Provide feedback on all custom items developed in Sprint 7 Provide requirements/clarifications on the needs for the Investment Flier Sprint 9 DTS integrated Testing & Bug fodrig (Internal) Provide clarifications for TIP data and GIS data (as needed) Develop an administrative manual and integrate it with the administrative back -end Provide feedback on historical reporting feature, and Amendment form generation feature Sprint 20 NFRMPO Testing / Final sign off Provide results of testing Provide feedback on the adminstrative manual Sprint 11 Deployment to Production Deliver final documentation to NFRMPO Staff Attachment I FEDERAL PATENT AND RIGHTS IN DATA Attachment I FEDERAL PATENT AND RIGHTS IN DATA 37 C.F.R. Part 401,49 C.F.R. Parts 18 and 19 The F17A patent clause is substantially similar to the text of 49 C.F.R. Part 19, Appendix A, § 5, but the rights in data clause reflects FTA objectives. For patent rights, FTA is governed by Federal law and regulation. For data rights, the text on copyrights is insufficient to meet FTA's purposes for awarding research grants. This model clause, with larger rights ,as a standard, is proposed with the understanding that this standard could be modified to FTA's needs. CONTRACTS INVOLVING EXPERIMENTAL, DEVELOPMENTAL, OR RESEARCH WORK. A. Rights in Data. (1) The term "subject data" means recorded information, whether or not copyrighted, that is delivered or specified to be delivered under this Agreement. The term includes graphic or pictorial delineation in media such as drawings or photographs; text in specifications or related performance or design -type documents; machine forms such as punched cards, magnetic tape, or computer memory printouts; and information retained in computer memory. Examples include, • but are not limited to: computer software, engineering drawings and associated lists, specifications, standards, process sheets, manuals, technical reports, catalog item. identifications, and related information. The term "subject data" does not include financial reports, cost analyses, and similar information incidental to contract administration. (2) The following restrictions apply to all subject data first produced in the performance of the contract to which this Attachment has been added: (a) Except for its own internal use, Contractor may not publish or reproduce subject data in whole or in part, or in any manner or form, nor may Contractor authorize others to do so, without the written consent of the Federal Government, until such time as the Federal Government may have either released or approved the release of such data to the public; this restriction on publication, however, does not apply to any contract with an academic institution. (b) In accordance with 49 C.F.R. 18.34 and 49 C.F.R. 19.36, the Federal Government reserves a royalty -free, non-exclusive and irrevocable license to reproduce, publish, or otherwise use, and to authorize others to use, for "Federal Government purposes," any subject data or copyright described in subsections (2)(b)l and (2)(b)2 below. As used in the previous sentence, "for Federal Government purposes," means use only for the direct purposes of the Federal Government. Without the copyright owner's consent, the Federal Government may not extend its Federal license to any other party. 1. Any subject data developed under this Agreement, whether or not a copyright has been obtained; and d. Contractor is prohibited from using Basic Pilot Program procedures to undertake pre -employment screening of job applicants while this Agreement is being performed. e. If Contractor obtains actual knowledge that a subcontractor performing work under this Agreement knowingly employs or contracts with an illegal alien, Contractor shall: 1. Notify such subcontractor and the MPO within three days that Contractor has actual knowledge that the subcontractor is employing or contracting with an illegal alien; and 2. Terminate the subcontract with the subcontractor if within three days of receiving the notice required pursuant to this section the subcontractor does not cease employing or contracting with the illegal alien; except that Contractor shall not terminate the contract with the subcontractor if during such three days the subcontractor provides information to establish that the subcontractor has not knowingly employed or contracted with an illegal alien. f. Contractor shall comply with any reasonable request by the Colorado Department of Labor and Employment (the "Department") made in the course of an investigation that the Department undertakes or is undertaking pursuant to the authority established in Subsection 8-17.5-102 (5), C.R.S. g. If Contractor violates any provision of this Agreement pertaining to the duties imposed by Subsection 8-17.5-102, C.R.S. the MPO may terminate this Agreement. If this Agreement is so terminated, Contractor shall be liable for actual and consequential damages to the MPO arising out of Contractor's violation of Subsection 8- 17.5-10.2, C.R.S. h. The MPO will notify the Office of the Secretary of State if Contractor violates this provision of this Agreement and the MPO terminates the Agreement for such breach. 31. Disadvantaged Business Enterprise. To the extent authorized by Federal law, the Contract agrees to facilitate participation by Disadvantaged Business Enterprises (DBE's) in the Project and assures that each third party contractor, or other participant at any tier of the Project will facilitate participation by DBEs in the Project to the extent applicable as follows: (1) The Contractor agrees and assures that it shall comply with section 1101(b) of SAFETEA-LU, 23 U.S.C.§101 note, and U.S. DOT regulations, "Participation by Disadvantaged Business Enterprises in Department of Transportation Financial Assistance Programs,"49 C.F.R. Part 26. (2) The Contractor agrees and assures that it shall not discriminate on the basis of race, color, sex, or national origin in the award and performance of any third party contract or other arrangement supported with Federal assistance derived from U.S. DOT in the administration of its DBE program and shall comply with the requirements of 49 C.F.R. Part 26. The Contractor agrees to take all necessary and reasonable steps as set forth in 49 C.F.R. Part 26 to ensure nondiscrimination in the award and administration of all third party contracts and other arrangements supported with Federal assistance from U.S. DOT. cAdatMproposalslfort ccilinslnfrmpolfinal editable docsldts 2010 1 6 2011 version for editing by dts.docx 2. Any rights of copyright purchased by Contractor using Federal assistance in whole or in part provided by FTA. (c) When FTA awards Federal assistance for experimental, developmental, or research work, it is ETA's general intention to increase transportation knowledge available to the public, rather than to restrict the benefits resulting from the work to participants in that work. Therefore, unless FTA determines otherwise, Contractor performing experimental, developmental, or research work required by this Agreement agrees to permit FTA to make available to the public, either FTA's license in the copyright to any subject data developed in the course of that contract, or a copy of the subject data first produced under the contract for which a copyright has not been obtained. If the experimental, developmental, or research work, which is the subject of the underlying contract, is not completed for any reason whatsoever, all data developed under that contract shall become subject data as defined in subsection (a) of this clause and shall be delivered as the Federal Government may direct. . This subsection (c), however, does not apply to adaptations of automatic data processing equipment or programs for Contractor's use whose costs are financed in whole or in part with Federal assistance provided by FTA for transportation capital projects. (d) . Unless prohibited by state law, upon request by the Federal Government, the MPO and Contractor agree to indemnify, save, and hold harmless the Federal Government, its officers, agents, and employees acting within the scope of their official duties against any liability, including costs and expenses, resulting from any willful or intentional violation by the MPO or Contractor of proprietary rights, copyrights, or right of privacy, arising out of the publication, translation, reproduction, delivery,. use, or disposition of any data furnished under that contract. Neither the MPO nor Contractor shall be required to indemnify the Federal Government for any such liability arising out of the wrongful act of any employee, official, or agents of the Federal Government. (e) Nothing contained herein shall imply a license to the Federal Government under any patent or be construed as affecting the scope of any license or other right otherwise granted to the Federal Government under any patent. (f) Data developed by Contractor and financed entirely without using Federal assistance provided by the Federal Government that has been incorporated into work required by the underlying contract to which this Attachment has been added is exempt from the requirements of subsections (b), (c), and (d) of this clause, provided that Contractor identifies that data in writing at the time of delivery of the contract work. (g) Unless FTA determines otherwise, Contractor agrees to include these requirements in each subcontract for experimental, developmental, or research work financed in whole or in part with Federal assistance provided by FTA. (3) Unless the Federal Government later makes a contrary determination in writing, irrespective of Contractor's status (i.e., a large business, small business, state government or state instrumentality, local government, nonprofit organization, institution of higher education, individual, etc.), the MPO and Contractor agree to take the necessary actions to provide, through FTA, those rights in that invention due the Federal Government as described in U.S. Department of Commerce regulations, "Rights to Inventions Made by Nonprofit Organizations and Small Business Firms Under Government Grants, Contracts and Cooperative Agreements," 37 C.F.R. Part 401. (4) Contractor agrees to include these requirements in each subcontract for experimental, developmental, or research •work financed in whole or in part with Federal assistance provided by FTA. B. Patent Rights: (1) If any invention, improvement, or discovery is conceived or first actually reduced to practice in the course of or under this. Agreement, and that invention, improvement, or discovery is patentable under the laws of the United States of America or any foreign country, Contractor agrees to take actions necessary to provide immediate notice and a detailed report to the party at a higher tier until FTA is ultimately notified. (2) Unless the Federal Government later makes a contrary determination in writing, irrespective of Contractor's status (a large business, small business, state government or state instrumentality, local government, nonprofit organization, institution of higher education, individual), Contractor agrees to take the necessary actions to provide, through FTA, those rights in that invention due the Federal Government as described in U.S. Department of Commerce regulations, "Rights to Inventions Made by Nonprofit Organizations and Small Business Firms Under Government Grants, Contracts and Cooperative Agreements," 37 C.F.R. Part 401. (3) Contractor agrees to include the requirements of this clause in each subcontract for experimental, developmental, or research work financed in whole or in part with Federal assistance provided by FTA Attachment J AFFIDAVIT PURSUANT TO C.R.S. 24-76.5-103 ATTACHMENT J AFFIDAVIT PURSUANT TO C.R.S. 24-76.5-103 I, , swear or affirm under penalty of perjury under the laws of the State of Colorado that (check one): I am a United States citizen, or I am a Permanent Resident of the United States, or f am lawfully present in the United States pursuant to Federal law. I understand that this sworn statement is required by law because I have applied for a public benefit. I understand that state law requires me to provide proof that f am lawfully present in the United States prior to receipt of this public benefit. I further acknowledge that making a false, fictitious, or fraudulent statement or representation in this sworn affidavit is punishable under the criminal laws of Colorado as perjury in the second degree under Colorado Revised Statute 18-8-503 and it shall constitute a separate criminal offense each time a public benefit is fraudulently received. Signature Date INTERNAL USE ONLY Valid forms of identification ---current Colorado driver's license, minor driver's license, probationary driver's license, commercial driver's license, restricted driver's license, instruction permit ---current Colorado identification card ---U.S. military card or dependent identification card ---U.S. coast guard merchant mariner card ---Native American tribal document The following forms of identification may be accepted through February 28, 2007* ---original birth certificate from any state of the United States ---certificate verifying naturalized status by U.S, with photo and raised seal ---certificate verifying U.S. citizenship by U.S. government, e.g., U.S. passport ---order of adoption by a U.S. court with seal of certification ---valid driver's license from any state of the U.S. or the Dist. of Columbia excluding AK, HI, IL, MD, MI, NE, NM, NC, OR, TN, TX, UT, VT and WI ---valid immigration documents demonstrating lawful presence, e.g., current foreign passport with current 1-551 stamp or visa, current foreign passport with 1-94, 1-94 with asylum status, unexpired Resident Alien card, Permanent Resident card or Employment Authorization card *A waiver may be available where no identification exists or can be obtained due to a medical condition, homelessness, or insufficient documentation to receive a Colorado I.D. or driver's license. Contact your department director. Rev06/o7 32. Special Provisions. Special provisions or conditions relating to federal patent law and rights in data that are applicable to this Agreement are set forth in Attachment I, attached hereto and incorporated herein by this reference. THE NORTH FRONT RANGE TRANSPORTATION AND AIR QUALITY PLANNING COUNCIL (MPO) Cliff Davi xecutive Director CONTRACTOR: By: ,. Title: G I-Vt VV C. egyo= m of Ei e!)r tr STATE OF COLORADO } ss. COUNTY OF ) The foregoing instrument was subscribed, sworn to and acknowledged before me this day of , 200 , by [as of .] My commission expires: (SEAL) Notary Public cAdata\proposalsVort collfnslnfrmpoVinal editable docsldts 2010 1 6 2011 version for editing by dts.docx Attachment A SCOPE OF SERVICES