Loading...
HomeMy WebLinkAbout26 - Submissions - SS4A Demonstration Activity - Safety Data Platform (3)From:Ashley Wasvick To:Bozeman Procurement Cc:Erik Thorkelson Subject:[EXTERNAL]SRF Consulting Group Proposal for City of Bozeman SS4A Demonstration Activity - Safety DataPlatform Due 2/19/2026 at 3:00PM MST Date:Thursday, February 19, 2026 2:47:01 PM Attachments:image001.pngSRF_Proposal for City of Bozeman SS4A Demonstration Activity - Safety Data Platform.pdf Importance:High CAUTION: This email originated from outside of the organization. Do not click links or open attachments unless you recognize the sender and know the content is safe. Good afternoon, On behalf of SRF Consulting Group and our Project Manager, Erik Thorkelson, I have attached ourProposal for the City of Bozeman SS4A Demonstration Activity - Safety Data Platform. We kindly request confirmation of receipt. We thank you for the opportunity to present our qualifications and appreciate your consideration. Please reach out to Erik with any questions. Sincerely, Ashley Wasvick, CF APMP She/Her/Hers* Marketing Communications Lead | Marketing & Creative Services SRF Consulting Group Case Plaza | 1 2nd Street N, Suite 102 | Fargo, ND 58102 Direct: 701.237.0010 | awasvick@srfconsulting.com srfconsulting.com | Facebook | LinkedIn | Twitter | Vimeo | Instagram CONFIDENTIALITY NOTICE: The contents of this email message and any attachments are confidential and are intended solely for addressee. The information may also be legally privileged. This transmission is sent in trust, for the sole purpose of delivery to the intended recipient. *Why are pronouns important? February 19, 2026 CITY OF BOZEMAN SS4A COMPREHENSIVE DEMONSTRATION ACTIVITY - SAFETY DATA PLATFORM BOZEMAN, MT Marketing or promotional statements about SRF’s professional services are provided solely for general information and not as a contract commitment. Equal Employment Opportunity / Affirmative Action Employer 3701 Wayzata Boulevard, Suite 100 Minneapolis, MN 55416 763.475.0010 www.srfconsulting.com February 19, 2026 Taylor Lonsdale, PE City of Bozeman P.O. Box 1230 Bozeman, MT 59771-1230 tlonsdale@bozeman.net RE: PROPOSAL FOR CITY OF BOZEMAN SS4A COMPREHENSIVE DEMONSTRATION ACTIVITY - SAFETY DATA PLATFORM Dear Taylor Lonsdale and Members of the Selection Committee: SRF Consulting Group (SRF) brings decades of experience helping cities translate transportation safety policy into measurable, operational results. Across Vision Zero initiatives, SS4A programs, and comprehensive safety planning efforts nationwide, our team has supported public agencies in build- ing durable systems that move beyond one-time analysis toward continuous evaluation, prioritization, and accountability. The City of Bozeman’s Safety Data Platform demonstration represents a natural extension of this work—pairing strong local leadership with the technical infrastructure necessary to sustain implementation over time. SRF’s multidisciplinary structure is a defining strength. Our transportation planners, traffic safety specialists, and Spatial Data Sciences team work col- laboratively to integrate engineering insight, policy goals, and advanced analytics into practical tools for daily use. This integrated approach will extend directly to coordination between safety planning and platform implementation on the Bozeman SS4A effort. Should SRF be selected to support both the Comprehensive Safety Action Plan and the Safety Data Platform, our teams will coordinate from project initiation to ensure seamless alignment between plan development, prioritization logic, and long-term evaluation. We understand that a safety platform must be more than visually compelling—it must support defensible decision-making, align with federal evaluation requirements, and reduce staff burden rather than increase it. Our experience with federally funded transportation programs ensures that technical development remains grounded in documentation, reporting, and long-term program sustainability. This platform will be developed alongside Bozeman’s Comprehensive Safety Action Plan and will serve as the analytical foundation for plan development and demonstration activities. By integrating crash, network, and demographic data with structured countermeasure logic, our team will provide the City with a system that supports high injury network analysis, transparent prioritization, and ongoing SS4A evaluation requirements. We are enthusiastic about the opportunity to partner with the City of Bozeman in advancing its Safe Systems approach and look forward to delivering a platform that strengthens decision-making capacity both during the three-year demonstration and beyond. Sincerely, SRF CONSULTING GROUP, INC. Erik Thorkelson Jon Commers Project Manager Project Director SRF CONSULTING GROUP 2 Executive Summary This project is rooted in the need City of Bozeman leaders saw to implement critical safety changes within the City and to track their impact over time. The award of two recent SS4A grants gives the City of Bozeman the funding to make significant strides toward its goal of zero serious injuries and fatalities on Bozeman streets. This particular project will allow the City to move from static crash reporting toward an integrated, continuously updated safety management system. A dynamic Safety Data Platform that connects existing data, live updates, and countermeasure tracking in a single operational tool will support the implementation of the City’s Safe System approach. Inputs SRF understands that this platform builds upon the City’s Safety Action Plan foundation, incorporating crash data and the High Injury Network alongside enriched roadway and community context. Addi- tional data layers—including: • Speed limits • Functional classification • Traffic volumes • Roadway configuration • Land use • Relevant American Community Survey indicators Together, these layers will provide the physical and demographic context needed to understand not only where crashes occur, but why. SRF will draw upon its wealth of experience and deep knowledge of safety data concepts to create an easy-to-use dashboard that allows users to extract key information to understand what counter- measures are effective and what is not. We will create a solution based on the needs of city staff and other key stakeholders - our approach takes into account storyboarding and iterative design to ensure that the platform is responsive to key needs and has the ability to change over time as needs change. Platform SRF will develop an ArcGIS Online Experience tailored to daily City use. Through stakeholder storyboarding and iterative design, dash- boards will be structured to emphasize clarity and action rather than excessive metrics. Interactive filtering by crash severity, type, year, and roadway attributes will allow staff to evaluate corridors, intersections, and system-wide trends in real time. Automated data connec- tions will ensure that newly available crash records are consistently incorporated, enriched, and reflected in dashboard metrics without additional manual effort. Outcomes As new crashes enter the system, logic-based rules will assign context-sensitive countermeasures based on roadway setting, contributing factors, and user type. This creates a transparent, repeatable prioritization framework that strengthens both implementation and SS4A evaluation. Over the demonstration period, the platform will increase efficiency, support proactive safety management, and provide Boz- eman with a durable analytical foundation aligned with federal reporting expectations. INPUTS PLATFORM MONITORING & EVALUATION Live Data Refresh & Performance Feedback SRF CONSULTING GROUP 3 Firm/Individual Profile Established in 1961, SRF is a recognized transportation engineering firm and passionate leader in helping agencies develop strategic safety plans with easy-to-implement, effective countermeasures with one goal: sparing families from the devastation of a life-changing crash. Key areas we specialize in related to this project include big data management, interactive dashboard development, crash analysis, and systemic safety analysis. Recognized for our innovative and inspired approach to projects across the transportation spectrum and our focus on and commitment to public safety, SRF employs over 400 engineers, planners, landscape architects, real estate specialists, surveyors, and administrative personnel working with public sector clients across the country. SRF is a 100% employee-owned company (ESOP). SRF’s safety planning practice applies Safe System principles to proactively identify and mitigate conditions associated with severe crashes, recognizing that human error is inevitable and system design must be accommodating. The proposed platform operationalizes this philosophy by structuring crash, network, and demographic data into a repeatable framework for high injury network analysis, prioritization, and evaluation. OFFICE 3701 Wayzata Boulevard Suite 100 Minneapolis, MN 55416 763.475.0010 www.srfconsulting.com Erik Thorkelson PROJECT MANAGER P | 763.249.6763 E | ethorkelson@srfconsulting.com Staffing and Availability PROJECT STAFF ROLE COMMITMENTS PROJECTED AVAILABILITY* Erik Thorkelson Project Manager & GIS Dashboard Developer Goodhue County (MN) LRTP and Dashboard; MnDOT County Road Safety Plan Ph 4; Olmsted County (MN) CSAH Needs Study and dashboard 70% Jon Commers Project Director Metropolitan Council TOD Policy Update (MN); New Richmond Industrial Development (WI); City of Plymouth Comp Plan (MN)25% Carly Hanson GIS Support Metropolitan Council TOD Policy Update; Goodhue County (MN)LRTP and dashboard; New Richmond Industrial Development (WI); Minneapolis Public Schools Enrollment Dashboard (MN)35% Luke Champa, AICP Safety Advisor and Countermeasure Lead Otter Tail County (MN) Safety Action Plan; North Dakota Unpaved Roadways Safety Action Plan; State Highway 113 BUILD Application (MN); Forks MPO Socioeconomic Forecasts (ND)65% Peter Dirks Coding and Technical Support Minnesota County Road Safety Plan Updates; New Ulm Safety Action Plan (MN); Maryland Avenue Corridor Study (MN)80% Josie Myers GIS Support New Ulm Safety Action Plan (MN); WAMPO Safe Routes to School (NE); McKenzie County Safety Action Plan (ND)70% Erik Kappelman Data Support Wisconsin Travel Demand Model Input Data Update; Mountain Metro Transit Fare Study (CO); Danville Grade Crossing and Rail Study (IL)55% The following organizational chart and staff availability table provide an overview of the project team structure and resource commitment. Together, they illustrate reporting relationships, key roles, and the availability of staff assigned to support the work, demonstrating that the proposed team has the capacity and organizational clarity to deliver the project successfully. Project Manager & GIS Dashboard DeveloperErik Thorkelson Safety Advisor and Countermeasure Lead Luke Champa, AICP Project DirectorJon Commers GIS Support Josie Myers Carly Hanson Data Support Erik Kappelman Coding and Technical Support Peter Dirks City of Bozeman *Availability considers average consultant ‘win’ rates on active pursuits SRF CONSULTING GROUP 4 ERIK THORKELSON | PROJECT MANAGER & GIS DASHBOARD DEVELOPER Erik will serve as Project Manager and GIS Dashboard Developer, bringing strong expertise in geospatial analysis and data visualization. He has supported numerous safety projects using the full suite of ArcGIS Pro extensions to analyze road-way and crash data. Erik also leverages ArcPy (Python) scripting to streamline workflows, develop linear referencing systems, and apply current cartographic standards, enabling clear, reliable dashboards that support data-driven safety decisions. JON COMMERS | PROJECT DIRECTOR Jon has more than 25 years of experience working in market and policy analysis and engaging with project teams and clients to develop data-driven decisions and strategy. Jon founded and developed Visible City, a spatial analytics and consulting company serving clients nationally, which was acquired by SRF in 2024. He’s served for over a decade as an adjunct instructor of urban studies at the University of Minnesota and regularly addresses business, civic and conference audiences on urban economics, governance and history. Jon has also been invested in public decision making over many years, including service of eight years on the Metropolitan Council and six years on the Saint Paul Planning Commission, where he was elected chair. Currently, Jon is the Minnesota chapter president for Lambda Alpha International, a global land use economics society. CARLY HANSON | GIS SUPPORT Carly brings a diverse background in geospatial analysis, data visualization, and project management to the team. Prior to joining SRF, she served as the GIS and design lead for over 40 projects in her previous role as Lead Cartographer and Project Manager at Visible City, a spatial analytics and consulting company partnering with clients nationally. Carly is skilled in blending analytical findings with visualization techniques to deliver data-driven products that are multilayered, visually com-pelling, and intuitive. With extensive experience serving a diverse range of stakeholders, she ensures that each client’s voice is heard from project kickoff onward, working iteratively to provide custom insights tailored to their specific objectives. LUKE CHAMPA | SAFETY ADVISOR AND COUNTERMEASURE LEAD Luke will serve as Safety Advisor and Countermeasure Lead, bringing strong experience in safety action plan development and implementation. Since joining SRF in 2022, he has managed complex, data-driven planning efforts in coordination with federal, state, and local partners. Luke excels at aligning technical requirements with stakeholder priorities and identifying practical, implementable safety countermeasures. His experience supporting successful safety-focused grant applications further strengthens his ability to connect analysis, funding, and real-world implementation. JOSIE MYERS | GIS SUPPORT Josie is a GIS Analyst with SRF’s Spatial Data Sci-ences team. Joise utilizes her experience with the full suite of ArcGIS Pro tools for geospatial analysis and mapping. She is confident working within cartographic standards and using transportation and government data. In addition, Josie has experience creating ArcGIS Online applications for map review and distribution, model building for workflow improvement, and data discovery and research. Prior to joining SRF, Josie spent three years with the National Park Service and completed a Master’s thesis on perceptions of walkability in small-town Minnesota. She is passionate about connecting communities and active transportation. PETER DIRKS | CODING AND TECHNICAL SUPPORT Peter has seven years of experience in the trans-portation industry as an academic researcher, trans-portation department planner, and consultant. He is a go-to expert at identifying, procuring, and integrating disparate datasets and visualizing results using SQL, Python, and ArcGIS Pro. With experience working with national databases and unfiltered model outputs, he is adept at identifying and addressing inconsistencies, errors, and biases. Peter has led crash and safety analyses and high injury network (HIN) development for numerous agencies and has built Python scripts to preprocess data, generate HINs, and produce crash trend statistics, resulting in highly visual maps highlighting overrepresented crash corridors and contexts. ERIK KAPPELMAN | ANALYSIS SUPPORT Erik works at SRF in economic forecasting, socio-economic valuation, and project prioritization. His formal training in economics and career in transportation planning provide him with unique insights into travel demand modeling and data analysis, enabling him to analyze the complex effects of travel demand following changes to the transportation market, infrastructure, or policy. His contributions at SRF include regional transportation economic analysis, corridor-level economic analysis, benefit-cost analysis for grant applications, and the preparation of analysis mate-rials for the public. SRF CONSULTING GROUP 5 Scope of Services Task 1 | Data Collection Task Lead: Carly Hanson Project kickoff will include the critical step of coordinating with the City and Safety Action Plan team to identify and obtain necessary data. The safety data platform will integrate crash data, the high injury network, and other readily available datasets into a unified system that enriches crash analysis with roadway and community context. Through spatial proximity analysis, crash records will be linked to roadway characteristics including speed limit, functional classification, average annual daily traffic, jurisdiction, lane configuration, medians, adjacent land use, and streetscape features. This contextualized data-set will support both high injury network refinement and logic-based countermeasure identification as new crashes enter the system. Task 2 | Build the Safety Dashboard Task Lead: Erik Thorkelson Before building the platform, we will engage City stakeholders in an iterative “storyboarding” process, to ensure the platform meets the needs of those who will interact with it most. Upfront coordination with the team developing the Safety Action Plan will also confirm we are representing the plan’s vision. Upon reaching stakeholder consensus on the platform’s appearance and functionality, we will begin building it out. We will leverage the Esri ArcGIS Online environment to build a platform featuring multiple interactive dashboards, maps, and other visualizations. We will tailor the dashboards to derive clear results rather than endless metrics. Utilizing built-in functions to break down counts of crashes by severity or manner of collision paired with filtering for year, roadway characteristics, or even AADT will result in real time monitoring of SS4A progress. The dashboards will also be designed to update metrics based on zooming and panning to help keep track of problem intersections or areas of interest. Task 3 | Connect to Live Data Task Lead: Peter Dirks Once the safety data platform is fully established, we will lead the next phase by enhancing the existing crash dataset with live, regularly scheduled updates as new data becomes available. We will design and implement a structured update cadence aligned with the crash data release schedule to ensure the dashboard remains current, accurate, and dependable. Our team will configure and test the direct data connection between the crash data repository and the City’s GIS environment, enabling automated ingestion, validation, and spatial processing of records before they are published to the platform. Our team will replicate and formalize the enrichment and quality-con- trol workflows developed during earlier project phases so that all updates remain consistent with the established methodology. We will build, document, and deploy the automated data pipeline to ensure charts, filters, performance metrics, and summary counts refresh seamlessly without manual intervention. Looking ahead to the project’s three-year lifespan, this initial operational period will position the City for long-term sustainability, with the option to tran- sition maintenance responsibilities internally or continue with SRF for ongoing support and enhancements as the SS4A program evolves. Task 4 | Countermeasures and Tracking Task Lead: Luke Champa Once the safety data platform is complete, the final step is to assign real time countermeasures as crashes are pipelined into the exist-ing data set. A logic set will assign a countermeasure in real time based on the data we collected in Task 1. This logic will be tailored by real world attributes such as if the crash occurred in a rural or urban setting, whether the crash was caused by vehicle speeds or attentiveness, and even whether pedestrians or bicyclists were involved. The logic will digest all this information and produce a countermeasure fit for the individual crash occurrence. These will update in real time and be shown as a pop up once you click on the crash point in the dashboard. SRF CONSULTING GROUP 6 Description of Proposed Solution SRF proposes to implement a cloud-hosted Safety Data Platform built within ArcGIS Online that integrates crash data, roadway characteris-tics, demographic context, and automated countermeasure logic into a unified analytical environment. The platform is designed to support both development and long-term evaluation of the City’s Comprehensive Safety Action Plan and to demonstrate measurable improvements in staff efficiency and analytical clarity over the three-year demonstration period. System Architecture & Data Integration The platform will consist of hosted feature layers and structured geodatabases within ArcGIS Online, supported by automated data transformation workflows. Crash data from existing City and Mon-tana Department of Transportation systems (including formats such as Zeurcher Suite exports, PDF report data where applicable, and AASHTOWare outputs) will be standardized and integrated into a structured crash dataset. Automated enrichment processes will append roadway context—including speed limit, functional classifi-cation, AADT, jurisdiction, roadway configuration, and adjacent land use—as well as relevant American Community Survey indicators at the census tract level. This architecture ensures that crash records are not stored as static reports but as dynamic, queryable data objects that can be spatially analyzed, filtered, and continuously updated. Dashboard Environment & User Interface The user-facing component of the platform will be delivered through an ArcGIS Online Experience configured with multiple interactive dashboards and map views. The interface will be designed to pri- oritize clarity and operational usability, enabling City staff to: • Filter crashes by severity, manner of collision, year, roadway attributes, or geography • Visualize trends across the High Injury Network and other cor- ridors of interest • Monitor system-level metrics while simultaneously evaluating specific intersections • Update metrics dynamically based on zooming and panning The platform will generate crash diagrams, spatial overlays, and summary statistics that support both technical analysis and com-munication with stakeholders. Live Data Connectivity & Automation A key feature of the proposed solution is automated connectivity to newly available crash data. Scheduled workflows will ingest updated crash records as they are released by the source system, apply the established enrichment schema, and automatically refresh dashboard metrics and visualizations. This automation eliminates the need for manual data processing and ensures that evaluation metrics remain current throughout the demonstration period. Countermeasure Logic & Evaluation Support The platform will include a configurable logic framework that links crash characteristics to context-sensitive countermeasures. Based on variables such as roadway setting, contributing factors, and involved users (e.g., pedestrian, bicyclist), the system will assign recommended countermeasures in real time. These assignments will be transparent and editable, allowing the City to refine logic as policy priorities evolve. By structuring crash analysis, prioritization, and monitoring within a single environment, the platform directly supports SS4A evaluation requirements, including documentation of safety trends, identifi- cation of high-risk locations, and assessment of countermeasure performance over time. SRF CONSULTING GROUP 7 Maintenance & Support for City Staff Our team is well versed in transferring and ensuring the final product lives on client’s systems. We will work out a reasonable solution that could involve beginning a Partnered Collaboration inside ArcGIS Online. This Space will allow for both the City and our team to view and update data, maps, or applications as needed. This solution is ideal as it is the most secure solution to share data without sharing the information publicly or granting access to users outside of either organization. It is also ideal for the City to own the final products as they will be built on their ArcGIS Online account already. If a Partnered Collaboration is not feasible, there are multiple solutions that can take place. Our team has gone the route of gaining access to the cli-ent’s ArcGIS Online or Enterprise system via username and password. This solution is advantageous so that all products are created on the client side and eliminates the need to share and transfer data at the end of the project as well as eliminates duplication of efforts and budget on our side. If other options are not feasible, we are also equipped to host the dashboard and all maps/data on our ArcGIS Online. The final products would be available via a public link and easily accessible for City staff. Security and discretion over the data will be of paramount importance with this solution. Related Experience with Projects Similar to the Scope of Services Ramsey County All-Abilities PlanRamsey County, Minnesota SRF worked with Ramsey County to evaluate the County’s roadway system and identify changes to maximize their CSAH (County State Aid Highway) Needs funding. An interactive dashboard was developed that allowed the study team to evalu-ate different scenarios. The dashboard incorpo-rated the CSAH Needs formula and considered future traffic projects, planned jurisdictional changes, and planned construction projects. The dashboard provided instant calculation of potential CSAH Needs generated, which will allow the County to make an informed decision about adjustments to their current CSAH system. Our experience working with SRF to produce a long-range planning document and GIS based interactive dashboard for our entire, 293 mile transportation network has been beyond exceptional. SRF gathered and compiled data from inside and outside of Ramsey County to create an impressive, interactive view of our network that will help inform us of capital needs, project development, and programming. Their GIS expertise and ability to incorporate input from multiple sources including several public input events, elected officials, public works staff in both engineering and maintenance, and across other Ramsey County Departments has resulted in a powerful, user-friendly, GIS based tool that has significantly improved our asset tracking and decision-making capabilities for all of our residents. This is a tool we will be able to use for many years and even decades to come! – John Mazzitello, Deputy Director of Public Works, Ramsey County Sample image of the tool, built for client's internal use SRF CONSULTING GROUP 8 Minnesota County Road Safety PlansMnDOT, Statewide SRF has partnered with MnDOT and Minnesota counties to support the County Road Safety Plan (CRSP) program, a statewide initiative focused on reducing fatal and serious injury crashes on county roadways. Since its inception in 2009, the CRSP program has used a risk-based, systemic approach to identify low-cost safety improvements directly linked to the causation factors associated with the most severe crashes. Building on this foundation, SRF has led multiple phases of plan development and implementation support. A key evolution of the pro-gram has been the development of the County Road Safety Plan Map Application, an interactive GIS dashboard that translates plan findings into an operational, continuously usable tool. The CRSP GIS Dashboard Interface enables counties to filter and explore safety data related to roadway segments, curves, intersections, and crash patterns. Rather than relying solely on static reports, counties now have direct access to dynamic data visualization and prioritization tools that support ongoing safety analysis, funding decisions, and implementation tracking. This effort has helped transition Minnesota’s county safety program from individual plan documents to a scalable, data-driven safety management framework that continues to evolve with each update cycle. Saint Paul Public Schools: SPPS Builds Data and Mapping DashboardMinnesota Saint Paul Public Schools (SPPS), serving more than 35,700 students across 73 facilities and 500+ acres in Minnesota’s capital city, partnered with our team to assess its facilities portfolio and ensure it meets evolving community needs. Working closely with SPPS leadership, we established goals and evaluation criteria, then compiled a detailed inventory of land, facilities, programs, and usage data to inform capital improvement priorities. We translated this analysis into SPPS Builds, an interactive mapping dashboard that visualizes facility condition, priority status, and capital investment needs. Hosted on the District’s website, the tool enables users to identify service gaps, explore opportunities for growth, filter by school type or attendance area, compare schools through custom data visualizations, and align decisions with the District’s Five-Year Facilities Maintenance and Capital Implementation Plan. Pedestrian Crosswalk Policies, Guidance Documents, and Prioritization ToolsRosemount, Minnesota SRF is a leader developing crosswalk policies and guidance for imple-menting enhanced pedestrian/bicycle crossings in Minnesota. We have completed five crosswalk policies and associated crossing guidance for Dakota County, City of Eagan, City of Lakeville, City of Lake Elmo, and City of Rosemount. These customized policies and guidance have produced results and supported staff in each com munity. A transparent process and methodology create clear under standing for staff, elected officials, and other stakeholders or community members regarding when a location should receive pedestrian crossing enhancements. Many local agencies receive a deluge of crosswalk marking requests, and our approach seeks to produce the greatest benefits in the highest needs areas through a data cen tered approach. Additionally, we have produced a customized geospatial pedestrian crossing prioritization tool for the City of Lakeville and City of Rosemount which measures each city’s trans portation network and identifies the highest need locations for improvement based upon a variety of quantitative metrics. The tool assists city staff in proactively prioritizing locations and incorporating those improvements into existing capital planning processes, long term project planning, and grant funding acquisition. Sample image of the tool, built for client's internal use CLICK TO VIEW DASHBOARD CLICK TO VIEW DASHBOARD SRF CONSULTING GROUP 9 References JOHN MAZZITELLO DEPUTY DIRECTOR - PUBLIC WORKS RAMSEY COUNTY, MN John.Mazzitello@co.ramsey.mn.us 651.266.7105 TOM PARENT FORMER EXECUTIVE DIRECTOR OF OPERATIONS AND ADMINISTRATION SAINT PAUL PUBLIC SCHOOLS, MN tom.parent@mpls.k12.mn.us 612.668.0861 ROBBIE KREJCI HIGHWAY COMMISSIONER ST. CROIX COUNTY, WI 715.245.4201 Price Proposal Consultant Team Member Prof VIII Prof V Prof IV Prof III Prof II Budgeted Cost Phase Hourly Billing Rate $276.00 $198.00 $174.00 $145.00 $132.00 1 Project Management 20 20 40 5 5 $17,825.00 2 Data Collection 2 5 10 15 90 $17,337.00 3 Dashboard Development 5 80 160 30 20 $52,050.00 4 Live Data Manipulation 2 10 20 20 20 $11,552.00 5 Countermeasure Toolkit 2 10 100 60 20 $31,272.00 6 Ongoing Data Support 2 10 35 35 2 $13,961.00 TOTAL - HOURS 33 135 365 165 157 855 TOTAL - COST $9,108.00 $26,730.00 $63,510.00 $23,925.00 $20,724.00 $143,997.00 SRF Consulting Group 10 Proposed Schedule Deliverables 1a Data Inventory 1b Implementation of Data from SAP 1c Data Sign off before Safety Data Platform Creation 2a Storyboard of Platform Design(s) and Metric 2b Rough draft of Platform 2c Final Platform 3a Live Data Pipeline 3b Implementation of new crash data 4a Crash Tree Logic tailored to SAP goals 4b Crash Tree Logic in PDF format 4c Crash Tree Logic in GIS Meeting Task Duration SubTask Duration 2026 2027 2028 2029 A M J J A S O N D J F M A M J J A S O N D J F M A M J J A S O N D J F M A Project Management and Coordination Biweekly Check-ins Monthly Check-ins Task 1: Data Collection 1a. Collect Data 1b. Safety Action Plan Incorporation 1c. Data Confl ation and Schema Building Task 2: Build the Safety Data Platform 2a. Storyboard Design 2b. Creation 2c. Final Sign Off /Add Live Data/Cosmetic Changes Task 3: Connect to Live Data 3a. Process New Crash Data 3b. Implementation Task 4: Countermeasures and Tracking 4a. Safety Action Plan Incorporation 4b. Countermeasure Toolkit 4c. Implementation into GIS Ongoing Maintenance and Support for City Staff Quarterly Updates and Support Beyond CSAP Completion Finalize Draft Final Ongoing Support Quarterly Updates SRF CONSULTING GROUP 11 Attachment A NONDISCRIMINATION AND EQUAL PAY AFFIRMATION ____________________________________(name of entity submitting) hereby affirms it will not discriminate on the basis of race, color, religion, creed, sex, age, marital status, national origin, or because of actual or perceived sexual orientation, gender identity or disability and acknowledges and understands the eventual contract will contain a provision prohibiting discrimination as described above and this prohibition on discrimination shall apply to the hiring and treatments or proposer’s employees and to all subcontracts. In addition, ____________________________________(name of entity submitting) hereby affirms it will abide by the Equal Pay Act of 1963 and Section 39-3-104, MCA (the Montana Equal Pay Act), and has visited the State of Montana Equal Pay for Equal Work “best practices” website, https://equalpay.mt.gov/BestPractices/Employers, or equivalent “best practices publication and has read the material. ______________________________________ Name and title of person authorized to sign on behalf of submitter SRF Consulting Group, Inc. SRF Consulting Group, Inc. Todd Polum, PE - CEO SRF CONSULTING GROUP 12 Section 7c - Secure Services - SRF must provide a secure environment for all City's Confidential Information. • This will depend on what solutions the responding team plans to use, but all SRF corporate systems would comply with this requirement Section 8 - Security - States SRF and subcontractors must comply with industry best practices. • All SRF corporate systems comply with this requirement Section 19 - Data Location - City's Data must not be transferred outside the United States • All SRF corporate systems comply with this requirement - any cloud hosting platform used in a solution must also be evaluated to ensure compliance Section 20 - Access to Data - City may access and copy any of the City's Data in Provider's possession at any time • SRF can comply with this requirement on an as-needed / as-requested basis. SRF will not grant City open access to SRF systems at all times Section 21 - Deletion of Data - Provider must not erase the City's Data or any copy without City's prior written consent • SRF can comply with this, however it is a bit extreme - after the close of the project we're expected to maintain data indefinitely? Section 22 - Data Incidents - See Data Incident definition • SRF can comply with this requirement Section 24 - Virus Warranty - Provider warrants use of commercially reasonable efforts to ensure against introduction of virus to City's systems. • SRF can comply with this requirement Software as a Service Agreement Proposed Changes: SRF CONSULTING GROUP 13 Cloud Services Questions 1) Service Levels: What level of service should we expect? What is the City’s recourse for excessive downtime? Refund of percentage of monthly fee? The platform is hosted on ArcGIS Online under Esri's Service Level Agreement (G632), which commits to a 99.9% quarterly uptime for all covered services. Planned maintenance is excluded and requires a minimum of 8 hours advance notice. SRF will respond to reported platform issues within one (1) business day. If Esri's quarterly uptime falls below 99.9%, the City is eligible for a prorated SLA Credit applied at subscription renewal (minimum $100 threshold). SRF will initiate credit claims with Esri on the City's behalf. 2) Data Ownership: Who owns the data we provide and what can be done with the data? The City of Bozeman retains full ownership of all data it provides, including crash records, network data, demographic data, and all platform outputs (SaaS Agreement §18(b)). SRF will use City Data solely to deliver the agreed services and will not share, sell, or repurpose it without the City's prior written consent. SRF's preferred architecture builds the platform under a partnered collaboration arrangement, between SRF and the City of Bozeman's ArcGIS Online accounts. A second option involves building the platform within the City's own ArcGIS Online account. Both of these options ensure the City retains direct custody of all hosted assets throughout and after the project. Alternatively, the platform could be built within SRF's ArcGIS account. SRF may compile anonymized, non- identifiable aggregate usage statistics for service improvement purposes only (§5(f)). 3) ADA Compliance: If your proposed services include websites, they must be AA compliant as defined by WCAG (Web Content Accessibility Guidelines) standards. SRF commits to delivering a platform that meets WCAG 2.1 Level AA standards. An accessibility review of all dashboards and application components will be conducted prior to final acceptance, with any deviations documented and remediated. Esri's Voluntary Product Accessibility Template for ArcGIS Online will serve as a guide to ensure accessibility guidelines are adhered to. 4) Data Security: How secure is our data and how is it being kept secure? a. If this is a multi-tenant environment on the same hardware how is our data kept separate and from other customers, including any PII (Personally Identifiable Information) that may be gathered? SRF CONSULTING GROUP 14 The City's data is isolated within a dedicated ArcGIS Online organizational account with role- based access controls. No other Esri customer can access the City's data. All SRF staff will access City data through individually credentialed named accounts only. b. If PII is gathered, is it encrypted in transit and at rest? ArcGIS Online Hosted Feature Services are encrypted at rest (AES-256) and in transit (TLS 1.2+) by Esri's infrastructure. Project-specific ETL pipelines connecting to Zeurcher Suite, AASHTOWare, and PDF sources will be designed with TLS 1.2+ encryption in transit as a requirement. c. If credit card transactions are occurring is your system fully PCI compliant? Not applicable. No credit card transactions occur within this platform. 5) Data Integrity: What do you do as a vendor to ensure our data maintains its integrity? Automated ingestion workflows include schema validation and anomaly checks at point of entry; records that fail validation are flagged for review, not silently dropped. All enrichment logic (speed limits, AADT, demographics, countermeasures) is rule-based and version-controlled — changes require documented approval before deployment. Esri maintains geographically redundant storage with automated backups for all Hosted Feature Services. All platform schema and configuration changes are logged in a project change record shared with the City. SRF will not delete or alter City Data without prior written consent (SaaS Agreement §21). 6) We require data centers to be located in the United States: What country will our data be located in? All City Data will be stored and processed exclusively within the United States. SRF's corporate systems — including ETL processing and backup infrastructure — are US-based. City Data will not be transferred outside the US without prior written consent from the City (SaaS Agreement §19). 7) Responding to Legal Demands: What is your process when someone subpoenas or requests our data from you as a vendor? Upon receipt of any subpoena, court order, or legal demand for City Data, SRF will immediately notify the City's designated representative in writing — to the extent legally permissible — before making any disclosure. SRF will provide the City a reasonable opportunity to seek a protective order, disclose only the minimum data required, and cooperate with the City in contesting or limiting the request (SaaS Agreement §17(b)(i)). SRF CONSULTING GROUP 15 The City — not SRF — is the responsible party for determining responsiveness to Montana Open Records Law requests (MCA Title 2, Chapter 6). SRF will support the City's compliance obligations as needed. 8) Reporting: What is your protocol for data breaches? In the event of a confirmed or suspected Data Incident, SRF will notify the City's designated representative within 48 hours of discovery — by phone or in writing — as required by SaaS Agreement §22. SRF will contain the incident, preserve evidence, cooperate with the City and law enforcement, and assist with third-party notification as required by applicable law. 9) Disaster Recovery: What protections/protocols do you have in place to mitigate disasters? ArcGIS Online is operated across geographically redundant, multi-availability-zone Esri data centers with automated backup and failover — supporting the platform's 99.9% uptime commitment. Force majeure events are governed by SaaS Agreement §27(e); SRF will communicate restoration timelines promptly. 10) Business Continuity/Exit: If you decide to bring your business to an end or we end our relationship, what happens to our data? What format options will there be and what assistance will you provide getting our data to us? If the platform is built within the City's own ArcGIS Online account, the City retains uninterrupted access to all hosted data and application assets upon contract expiration or termination — no extraction is required. Any City Data on SRF-managed systems will be exported to the City promptly upon request; no data will be deleted without prior written consent (SaaS Agreement §21). City Data is available for export in the following formats: • Geospatial: Shapefile (.shp), File Geodatabase (.gdb), GeoJSON, KML/KMZ • Tabular: CSV, Excel (.xlsx) • Application: Full configuration documentation for platform recreation or handoff SRF will provide transition assistance upon written request for up to one year post-termination at then-current hourly rates, including handoff of all automation scripts, logic rules, and enrichment configurations (SaaS Agreement §14). 10) Termination Rights and Consequences: What is your termination policy both for you as a vendor and us as a customer? Either party may terminate for material breach uncured after 60 days written notice, or immediately upon the other party's insolvency or bankruptcy (SaaS Agreement §3(c)). SRF may also terminate if the City fails to pay within 60 days of written notice. SRF must provide 90 days notice before Agreement SRF CONSULTING GROUP 16 expiration; non-renewal notice requires 30 days prior to term end. Upon termination, all fees earned to date remain payable. The City retains all data, platform access on its own ArcGIS Online account continues uninterrupted, and SRF's indemnification obligations survive under Montana law. Transition assistance remains available for up to one year at then-current hourly rates. Questionnaire Completed by: Jon Commers Date: 2/19/26 20170.PP