Loading...
HomeMy WebLinkAbout24 - Submissions - Professional Geographic Information Systems (GIS) Services (4)March 142024 Proposal Professional GIS Services City of Bozeman hdrinc.com Version # hdrinc.com 2150 Analysis Drive, Suite A, Bozeman, Montana 59718 T 406.577.5037 March 14, 2024 Gail Jorgenson City of Bozeman PO Box 1230 Bozeman, MT 59711-1230 RE: Proposal for Bozeman Professional GIS Services Dear Gail: The City of Bozeman has an important goal of optimizing their GIS starting with the development of a needs assessment and an implementation roadmap. Optimizing the existing system will result in real world benefits, including more efficient workflows, right-sized solutions, and better access to information for decision makers. HDR understands the importance of this goal and is uniquely qualified to assist the City of Bozeman. We are ideally suited to assist with this important project for the following reasons: • GIS Project Management Team with Extensive Municipal Experience Results in a Public Works- focused GIS System. Our proposed Project Manager Kyle Burke and Senior Technical Advisor Bridget Brown, combined, have over two dozen years of industry experience managing GIS-related projects and responsibly helping organizations move forward with GIS implementations. Our proposed team has the unique ability to speak to both infrastructure engineering and GIS to help clearly communicate technical concepts. This results in engaged stakeholders and solutions that match needs with appropriate GIS environments and approaches. HDR is focused on providing sustainable and scalable solutions that produce benefits in the short and long term. • HDR’s Knowledge of Bozeman’s Public Works Infrastructure and Operations Reduces Cost. Our team brings the perfect complement of geospatial expertise and knowledge of local Bozeman Public Works operations. For the past 20 years, HDR has worked in nearly every aspect of the City of Bozeman’s Public Works Department and have intimate knowledge of existing infrastructure as well as your goals and expectations. This unique knowledge, combined with our GIS capabilities, results in more quickly being able to complete the work, thus saving time and money compared to our competition. • A Full-Service Team with Applied Geospatial Expertise Results in Efficient Implementation. HDR has supported multiple local and national agencies on enterprise level geospatial efforts, ranging from ArcGIS Online configuration, to network infrastructure support and systems integration, to standards and best practices development. With HDR, there is no need to enlist multiple contractors; we have global geospatial experts that we can call upon at a moment’s notice, combined with local professionals who have established relationships within the City Public Works Department. This means your experience will be seamless and we will function as an extension of your staff. The City of Bozeman has turned to HDR time and time again to successfully deliver projects. HDR is fully committed and vested in the successful completion of this project! Thank you for the opportunity to offer our services for this project. Should you require further clarification of this proposal, please do not hesitate to contact me at 406.532.2257 or Kyle.Burke@hdrinc.com if you have any questions or need further information. Sincerely, Kyle Burke, GISP HDR Montana GIS Manager/Project Manager hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services1. Executive Summary GIS is a vital part of any city’s infrastructure. It allows city personal and decision makers the ability to gain insight into assets they maintain and employees they manage as they plan for the future. One of the challenges the City of Bozeman faces is operating a diverse GIS environment. Managing, integrating, and updating this environment and incorporating multiple Esri products, Cityworks, and VertiGIS applications can be extremely complex and difficult while continuing day to day operations. Without a clear roadmap for upgrading and modernizing the GIS environment, the City risks not staying at the forefront of technology advancements and facing challenges in meeting evolving user needs and industry standards. The City of Bozeman needs a comprehensive needs assessment and upgrade of its GIS environments to help them achieve this vision. HDR is uniquely positioned to help the City in this endeavor, having completed a very similar project with the City of Billings. This experience provides HDR industry-specific expertise on upgrading systems, architecture, and processes to set the City on a path of future success. From conducting in-person interviews to creating governance charters, HDR works alongside clients to create custom solutions to complex issues. Our approach outlines our plan to assist the City in their assessment and optimization of their GIS environment. In Phase 1, HDR will begin with a kick-off workshop to align all HDR and City personal on project expectations and goals. This will serve as the foundation for the Needs Assessment phase of the project. Following the kick-off, HDR will conduct interviews and job shadowing to better understand the needs of City staff and personal. This will allow for better prioritization of projects due to staff needs and use cases throughout the City. During the same time, a detailed system architecture review will be conducted to understand and recommend changes to the core systems. After the systems architecture review, a complete data review will be undertaken to establish where standardization can occur and alignment of all systems of record. Once these reviews are complete, HDR will begin to draft a roadmap based on findings from the interviews, job shadowing, architecture, and system reviews. After the draft roadmap is complete, HDR will facilitate a prioritization exercise with key City staff to assist in selecting and prioritizing key initiatives detailed in the roadmap. Phase 2 will be an implementation of the prioritized initiatives and final roadmap developed in Phase 1. Key initiatives noted by the City already, such as upgrading Esri ArcGIS Enterprise from version 10.9 to version 11, Cityworks from version 15.8.3 to 2023, and VertiGIS Studio from Geocortex version 4.14.5 will by prioritized. At the conclusion of implementing the roadmap initiatives that were identified and agreed upon at the end of Phase 1, HDR will help the City set up a GIS Technical Committee and Governance Charter. This will help the City to create a decision-making structure surrounding the GIS environment. This will be followed by Standard Operation Procedures (SOPs) and Quality Control/Quality Assurance (QA/QC) Plans. Finally, HDR will provide training documentation and workshops to help with user adoption of upgraded systems and procedures. 0101 The word cloud was derived from City of Billings GIS Needs Assessment from an end users perspective. This relays an overarching theme heard from many organizations - the need for access to information. Kyle Burke, GISP | Project Manager Kyle will lead HDR’s team of GIS and systems integration professionals to perform beneficial GIS services for the City of Bozeman. Kyle will manage the contract and work with the City to assign resources, develop and monitor schedules, establish protocols, and – most critically – strive to make sure that all work performed under this contract conforms to your criteria. Kyle is a GIS Manager experience managing projects and working with numerous city/local/state/federal government, utility, and university clients. His experience is focused on integrated cloud and web-based mapping solutions, as well as standardized database schemas, for project management, asset management, field work coordination, and enterprise systems. Kyle leverages geographic information to visualize problems, design solutions, enhance communication, and make better decisions. He also has experience in deploying Esri’s Utility Network for clients. His goal is to use GIS to provide innovative solutions for clients and their partners. Benefit to Bozeman • Experience with project management for GIS technology implementations. Kyle is well connected within HDR’s geospatial community and can help bring the right expertise to this project. He is a local Montanan and committed to supporting our local communities. Bridget Brown | Senior Technical Advisor With 22 years of experience, Bridget has grown HDR’s GIS program into one that is recognized in the industry by hiring the most technically proficient GIS people, matching them with clients in need, and utilizing the unique strengths of each individual team member to make great things happen. As a national leader of HDR’s GIS expertise, Bridget is connected to, and has direct access to, the diversity and magnitude of GIS and information management expertise of a nationwide infrastructure development company. Benefit to Bozeman• Bridget has a history of success with leading GIS services integral to project delivery. Over her career at HDR, Bridget has led dozens of projects and tasks related to GIS and information hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services We have identified a team that requires no time to be brought up to speed on the project challenges and critical success factors. PROJECT MANAGER Kyle Burke, GISP PRINCIPAL-IN-CHARGE Ben Fennelly, PE, CFM Senior Technical Advisor Bridget Brown GIS Analyst Rachael Ostrum Enterprise GIS Joel Griffin, GISP Terry MacNeill Cityworks Support Matt Wilson, GISP CORE DELIVERY TEAM 2. Firm Profile “HDR’s team collaboration, communication, and project management was exemplary. As a result of HDR’s quality work product, the District now has GIS capability it never had before. I found HDR easy to work with and very knowledgeable regarding GIS services. I would highly recommend them for future GIS work.” - James Sauceda, P.E., Chief, Geotechnical and Engineering Services Branch U.S. Army Corps of Engineers Alaska 02 management. As project manager for GIS services, Bridget helped the City of Billings move their GIS and asset management modernization initiative from concept to reality, bringing efficiencies that are translating into real-world cost savings. Joel Griffin, GISP | Enterprise GIS Joel has more than 13 years of experience in GIS data management, cartography and analysis. He has experience in water, local government, energy, and government industries. He has experience in the design and implementation of ArcGIS Enterprise and ArcGIS Online. He has been the team lead and subject matter expert for permitting, development and construction of major infrastructure projects. He is a proven communicator and instructor in GIS design and task management in desktop, web, and mobile applications. Benefit to Bozeman• Joel’s successful experience implementing ArcGIS Enterprise solutions for a variety of public clients highlights his ability to connect GIS technology solutions to the business needs of organizations. Rachael Ostrum,| GIS Analyst Rachael is a GIS Technician who has worked with and supported numerous clients with geospatial needs. She creates route maps and layouts used for deliverables, updates and adds data into GIS databases, performs analysis on data given in a variety of different formats, and reviews GIS data for completeness and accuracy. Rachael has also built several ArcGIS Online web applications to make the data viewing experience easier to understand and interpret for our clients. She works closely with clients and project managers to verify projects are completed to satisfaction and in a timely matter. By leveraging detailed initiatives that lay out projects and objectives meant to amplify how our client can leverage GIS, she helps streamline business across all client divisions and prepares them for any future changes. She is knowledgeable with geodatabase management/creation, cartographic design/map making, spatial analysis, utility network, arcade, and web application creation, and is proficient with ArcGIS Pro, ArcGIS Online, and various other Esri applications. Benefit to Bozeman• Rachael’s experience coordinating with city stakeholders to gain an understanding of future needs on the recent Billings GIS project will be invaluable to the City when designing and managing the upgraded Esri Enterprise geodatabase. Terry MacNeill | Enterprise GIS Terry has more than 25 years of experience in GIS data management, web applications, and Enterprise GIS. Terry has experience in transportation, water, local government, energy, and local, state and federal government industries. Terry has extensive experience in GIS, data integration, operating systems/virtualization, database and CAD. Benefit to Bozeman • Terry not only supports our clients, he helps manage HDR’s own Enterprise GIS ecosystem supporting more than 1,200 users. Matt Wilson, GISP | Cityworks Support As a GIS developer, Matt works with clients and coworkers to design and implement both desktop and web applications that assist with the creation, aggregation, and visualization of spatial data for a variety of projects. He has extensive experience working with multiple GIS platforms, synthesizing data from multiple data sources, communicating analytical results visually, in writing, and through oral presentations to a wide variety of audiences. Matt has been assisting clients with preparing computerized maintenance management system (CMMS) design guides to support the implementation of asset management, work orders, preventative maintenance, and replacement schedules for client utility assets, and has been assisting clients with implementing systems in existing GIS and Cityworks platforms. Benefit to Bozeman• Matt is HDR’s go to expert for implementation and optimization of Cityworks. He will help hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services 03 answer the tough technology questions and present reasonable and sustainable solutions. Ben Fennelly, PE, CFM | Principal-in-Charge Ben has 20 years of experience performing and managing a wide range of water infrastructure projects. As Principal-In-Charge, Ben is responsible for monitoring all phases of the project, quality assurance, assembling the appropriate technical expertise and resources for each phase, and certifying that the deliverables meet Bozeman’s requirements. One of his most effective tools is his ability to communicate and collaborate with the client team, the consultant team, the stakeholders, and the public to build consensus. He has a history of solving complex project problems with a communication style that make all comfortable with the technical, cost, and schedule implications of proposed solutions. Ben’s diverse experience provides efficiencies in design and provides the client opportunities to efficiently meet their goals. Benefit to Bozeman • In addition to his experience as a project manager for the City. Ben will help complete our complimentary services, bridging HDR’s civil design experience with our GIS and systems integrations team. 3. Scope of Project The City of Bozeman is looking to assess its GIS environment and create a roadmap to optimize GIS use and performance throughout the organization. The current GIS environment is robust and includes Esri, Cityworks, and VertiGIS and products with complex integrations. A needs assessment will inform a roadmap that will include strategies for upgrading and modernizing the City’s GIS environment, including version upgrades or deployments, providing training materials, and best practices for performance, security, stability, and accessibility. These services will be completed with a two phased approach: Phase 1 needs assessment and prioritized roadmap and Phase 2 implementation of the roadmap. • Overview of project scope, schedule, and roles • Presentation of current industry GIS trends and best practices. Benefits: • City staff will be primed and have clear expectations. • Outline optimization recommendations and associated investment, schedule, dependencies, benefits, etc. • Prioritization exercise. • Implementation Plan and Roadmap. Benefits: • Clear objectives and timeline for implementation • Prioritization identifies easy wins and required foundation changes. • Interviews and field visits. • Document: Workflows, data gaps, system architecture. Benefits: • Understanding of existing conditions and opportunities/needs Task 1 - Kick-off Presentation Task 2 - Needs Assessment Task 3 - Road Map hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services 04 hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services4. General and Technical Requirements HDR’s understanding of the technical requirements and goals of the GIS Environment optimization include the following. HDR will confirm and amend requirements during the needs assessment. Technical Requirements: Integration and coordination between Esri, Geocortex (VertiGIS), and Cityworks platforms •Esri ArcGIS Enterprise upgrade to version 11 from 10.9 °Considerations for infrastructure, licensing, data management, application deployment, systems integrations, and ongoing support and maintenance. °Sunset ArcMap »Compatibility review between ArcMap and ArcPro »Migrate services from ArcMap to ArcPro °Improve catalog system for GIS services and maps °Enhance directory search functionality in ArcPro for non-admin users •Upgrade Cityworks from 15.8.3 to 2023 °Transfer large library of Crystal Reports to Active Reports °Migrate from Cityworks AMS to Respond •Upgrade to VertiGIS Studio from Geocortex v4.14.5 °Provide uninterrupted access to critical maps during upgrade °Migrate supporting maps and services to ArcGIS Pro General Requirements: •Data schema changes required for systems integration •Development of standard operating procedures for publishing map services •Creation of quality control/quality assurance plan for maintaining database systems •Training resources •GIS Governance and GIS Technical Committee HDR developed this pilot Azure system mapping and helped the Municipality of Anchorage with server environment configuration and installation, developing workflows and process for updating standardized datasets, and incorporating business requirements to GIS enterprise design. 05 hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services The following project descriptions demonstrate HDR’s ability to work collaboratively to solve GIS and asset management challenges. In these projects, we worked with clients to develop cost-effective strategies, similar to those required in your scope of work. These projects represent successful partnerships with clients – reaching project goals and delivering within the required budget and schedule. 5. Related Experience with Projects Similar to the Scope of Services PROJECTS GIS NEEDS ASSESSMENTGIS ENVIRONMENT ROADMAPGIS SYSTEMS INTEGRATIONCITYWORKS SUPPORTGIS DATA MANAGEMENT SUPPORTGIS SYSTEM ARCHITECTURE SUPPORTPublic Works GIS Support | Billings, MT Geospatial Technology Services | Various Locations Central San Migration to Utility Network | Central Contra Costa County, CA San Juan Water District GIS Implementation | Granite Bay, CA GIS Environment Support | Anchorage, AK Geospatial Technology Program – MDT | Various Locations MS4 Sewer Inventory | Yellowstone County Big Horn Rural Electric Company Electric Utility Enterprise GIS Support | Basin, WY Goldenwest Electric Cooperative Electric Utility Enterprise GIS Support | Wibaux, MT  Upper Missouri Power Cooperative Electric Utility Enterprise GIS Support | Sidney, MT  Chelan PUD Electric Utility Enterprise GIS Support | Wenatchee, WA Campus Electrical Map GIS Conversion | Bozeman, MT Collection System Improvement Program Management | Winston Salem, NC CMMS Needs Assessment & Procurement Support | High Point, NC 06 hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services Billings GIS Support | Billings, MTThe Public Works Department has a goal to modernize their use of GIS to support asset management and other business processes. A two phased approach including a needs assessment and implementation plan followed by plan execution was developed by HDR. HDR conducted a systems and data review of the City of Billing Public Works production GIS Environment. The review included an evaluation of the City’s current GIS data and the IT infrastructure in relation to map performance, data access, workflows, and third party software integrations. The detailed data review included a data gap summary and assessment based on the completeness, accuracy, and consistency of current GIS data utilized by Public Works. Full assessment results were summarized in a report and ArcGIS Storymap with key takeaways and maps highlighting areas throughout the City with data gaps, potential issues, and recommendations. Recommendations were prioritized into a GIS Roadmap and are currently being implemented with the City. Roadmap projects include GIS Governance plan, data schema update, database improvement, Esri Utility Network pilot using FME workflows for data migration, CMMS (Cityworks) updates and integrations including mobile and reporting, ArcGIS Portal implementation, AVL tracking (LiG)O and OneCall integrations with GIS and Cityworks, subsurface utility engineering surveys and a suite of updated ArcGIS Online apps and dashboards. HDR is hosting and documenting trainings with GIS and Public Works. HDR is currently supporting the city with a Cityworks implementation at their Water Reclamation Facility. These initiatives are amplifying how City leverages GIS to streamline business operations across all Public Works divisions. Defense Logistics Agency (DLA) Geospatial Technology Services I Various LocationsHDR has been providing comprehensive geospatial services to DLA since 2011. These key services have included: Needs Assessment/Business Case Analysis. HDR conducted a User Needs Assessment analysis for 25 DLA Distribution sites worldwide. Results of the assessment were used to improve quality of the data and build consolidated databases. HDR also developed a Business Case Analysis document for justification of continued investment in geospatial infrastructure. HDR proposed solutions for an enterprise-wide GIS development program and provided expertise in system design and architecture. Web-based Decision Support Systems. HDR built a comprehensive online mapping application, which displays key infrastructure and facilities datasets, and provides staff with an easy-to-use and user-friendly interface to access and visualize facility-related spatial and/or non-spatial information online. The online portal also integrates GIS data with external asset management and SharePoint document management databases. The portal is currently being enhanced to 07 hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services include capabilities for additional requirements, such as strategic infrastructure planning, energy consumption tracking, environmental compliance, space management, MilCON, and emergency management. GIS Data Creation and Validation. Data was collected from all of the services where DLA Distribution is a tenant, as well as the host sites, and consolidated into a SDSFIE compliant GIS database. Subject matter experts on the installations were consulted to verify and improve data. Additional field data collection and RTK surveying methods were used to improve the quality of the datasets. Central San Migration to Utility Network | Central Contra Costa County, CACentral Contra Costa Sanitary District (Central San) is planning a conversion of their existing GIS geometric network into the Esri Utility Network (UN). This conversion will modernize their system to the industry standard, streamline data management, and improve use and adoption of their GIS tools supporting Central San’s business operations. Central San wanted to perform the migration themselves, but sought out guidance and assistance from HDR to help streamline the process and improve the overall results. HDR prepared and delivered a UN readiness and data assessment roadmap document to plan and identify current sanitary sewer and recycled water assets data and data model readiness for migration of to the EsriUN data model; provided gap analysis for existing data and recommendations for data cleanup and/or standardization in preparation for UN migration; developed a plan that included the methodology of incorporating operational data to geo-enrich the network features shared to the organization; advised and assessed the feasibility of potentially migrating the water treatment plant vertical asset database into a UN schema; and served as UN migration technical advisors and assisted Central San in the migration from the Geometric Network to the Utility Network. Trained Central San GIS staff on UN configuration, editing, creating new features, and general UN usage. GIS Implementation | Granite Bay, CASan Juan Water District underwent a modernization transformation in implementing an organization wide GIS program. The District went from standalone business processes into an integrated information system with GIS as its backbone. The project centered in engineering services and its migration from a two desktop CAD system into Enterprise GIS. The enterprise GIS migration included the implementation of the Esri Utility Network Management Extension enabling the engineering department to share system information to allow for data access and network tracing in the field. The Utility network enabled the GIS system to represent network connectivity reflecting attributes such as open, and closed valves, allowing the organization to quickly decipher who many assets are connected in a small neighborhood, pressure zone, or retail service area. The GIS implementation also included integration with the Customer Service CIS (Tyler Technologies), Document Management System, Operations CMMS (Cityworks) and Engineering Water Modeling program (Innovyze). This nexus of technologies used GIS as the centralized hub of system information integration and provided a common platform for all of the business groups to consolidate and share information with the entire organization. GIS Environment Support | Anchorage, AKWhen the Geographic Data and Informations Center (GDIC) approached HDR four years ago to help establish an enterprise geospatial environment to support multiple departments within the MOA, we understood that the system needed to be scalable, robust, dependable, and economically sustainable. Together, we planned, developed and implemented cloud-based infrastructure in Microsoft Azure. We migrated more than six terabytes of data from static storage to a cloud platform. Cloud-based environments are highly secure, they allow users to more easily access data and imagery, and they encourage collaboration because data is not split up into silos among multiple user groups. For the MOA, cloud-based enterprise GIS systems improve the way the municipality can address social, environmental, infrastructure, and disaster response challenges. Reliable access to critical infrastructure data results in more consistent response times from emergency services. A cloud-based system also offers resiliency in the face of natural disasters, as data is housed off site, and therefore less vulnerable to physical threats, such as the 7.1 magnitude earthquake that struck Anchorage in 2018. In establishing the cloud-based enterprise system, HDR deployed Esri software. We provisioned and secured virtual machines and network infrastructure, installed ArcGIS For Server, configured Portal for ArcGIS, 08 hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services published and optimized services, and documented workflows and procedures to make sure that multiple stakeholders could use the system now and into the future. We are also providing map production, user training, mobile app configuration, and assistance with data schema development to support the implementation of a Lucity-based asset management system and creation of operational dashboards. The GDIC has continued to build on this foundation to support other municipal departments and make sure that the Anchorage community across the board benefits from these services. For example, HDR aided in the initial implementation of a point-in-time homeless population count and survey, developed maps and a mobile field app which supported street maintenance efforts, and provided training to municipal employees and partners in the use of advanced high-precision global navigation satellite system devices. HDR has also provided on-site assistance to the MOA Long Range Planning Division in support of map production and data migration. The collaborative relationships that HDR has established among multiple MOA municipal departments has encouraged the adoption and use of their enterprise system. MDT Geospatial Technology Program | MontanaThrough the development of key relationships with the MDT GIS Management team HDR has enhanced data collaboration efforts with a variety of projects across the state. The services noted below were augmented using web based and mobile ArcGIS tools to increase project visibility to stakeholders through all project phases. Sign Inventory Management: HDR Geospatial Professional staff supported several roadway re-construction projects by designing and implementing web services used to collect sign asset data along project corridors throughout the state for MDT. Information gathered in the design phase is surfaced in ArcGIS Online Web Applications customized to fit project manager and stakeholder needs including data export and reporting tools, map creation ability, project status updates via interactive infographics, customized search and query tools to streamline user interface, and mobile access for field data collection and reference during construction phases of the project. Right-of-Way Services Support: HDR consolidates parcel data adjacent to various MDT projects throughout the state and deployed to ArcGIS Online web services. HDR and MDT ROW teams utilize services to update statuses the full duration of the project for acquisition and right-of-entry tracking. A dashboard web application conveys statuses to all team members in a web environment to streamline project communications. Previous workflow involved continuous submittals of project status spreadsheets. Web service eliminates any disconnects in reference to versioned copies as the Dashboard now serves as the repository for all ROW information in relation to the project. Smith, Robert 09 hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services MS4 Sewer Inventory | Yellowstone County, MT HDR conducted a storm sewer system field investigation and data analysis in 2019 to identify and map storm sewer features associated with Yellowstone County’s Municipal Separate Storm Sewer System (MS4). This was one part of a multi-year plan to update and improve the current stormwater asset inventory in compliance with MT DEQ regulations. The team utilized Apps and Software including ArcGIS Online, Collector for ArcGIS, and Survey 123 for ArcGIS to deliver a customized inventory system that can be utilized for future inventory, compliance, and maintenance of their stormwater assets moving forward. Field efforts and custom applications allowed for the existing system location and inventory to be validated. The status of features including condition, material, and location were documented using ArcGIS system. By mapping the features easily accessible, it allowed the County to identify any data gaps and plan efficiently for future inventories. All the information was easily downloaded and stored in databases. From here the data can be worked with in desktop applications and could be archived and stored for records. HDR also leveraged Survey 123 for ArcGIS to efficiently conduct dry weather outfall screenings and then created custom document templates to verify the required information was populated and compliance was met. Big Horn Rural Electric Company Electric Utility Enterprise GIS Support | Basin, WY With the onset of smart infrastructure implementations to help utilities monitor load growth, alert operations of outages, manage voltage levels to conserve energy, and streamline organizational workflows at multiple levels the distribution power industry has drastically changed. One key challenge that arises with all of this smart data is how to visualize and disseminate in a timely fashion. While very intuitive and useful in its native form, smart infrastructure platforms can sometimes be difficult to integrate in day-to-day business operations. Through the use of ArcGIS Online and the ArcGIS API for Python HDR partnered with Big Horn Rural Electric Company to design a process to effectively surface smart infrastructure data in one platform, in real time. Pulling data from various sources and analyzing in manners that best suit the utility’s needs. The specific workflow pushed meter reads directly to ArcGIS Online where the information could be embedded in a variety of different web applications. HDR configured a dashboard to quickly and succinctly quantify outages and provide locational reference for line crew and operations staff. Open source data can easily be consumed in ArcGIS Online web applications such as weather service radar, long term forecasts, wind speeds and so much more. Goldenwest Electric Cooperative Electric Utility Enterprise GIS Support | Wibaux, MTHDR worked with Goldenwest to migrate CAD data, GPS information collected by pole testers, and Synergi electric network model elements to GIS. After conversion was complete, HDR implemented an ArcGIS Online subscription to host and maintain Goldenwest system data. Line crews utilize Collector for ArcGIS to keep system data up-to-date, conduct line inspection, validate network model components, and navigate. HDR led a workshop on site training Goldenwest staff on how to utilize Collector and interact with the web based applications in ArcGIS Online at their desktops. 10 hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services Chelan PUD Electric Utility Enterprise GIS Support | Wenatchee, WA HDR designed a GIS-based web-enabled dashboard for the analysis of transmission line risk from wildfire in the Chelan PUD service area. Over 500 miles of lines were analyzed for risk from wildfires on a pole-by-pole basis that scored levels of risk through a risk matrix based potential flame lengths, foliage, slope aspect, accessibility, and criticality. The final report and GIS database provided a protocol for system risk reduction and infrastructure planning and rehabilitation. HDR also created a Story Map relaying key items from the report along with various web maps and infographics that Chelan staff could access via a web browser. The web interface enabled another level of data interaction that stakeholders could utilize during the risk assessment review. The Story Map still serves as a point of reference for Chelan as capital improvements recommended within the report are being implemented. MSU-Bozeman, Campus Electrical Map GIS Conversion | Bozeman, MTHDR provided GIS services to update the campus’s existing electrical GIS datasets to improve the scalability of the ArcGIS Enterprise platform used to host and visualize data. The existing electrical GIS was derived from CAD layers directly imported into GIS. HDR performed a data model review to determine if future organizational needs could be met or if additional changes were needed. HDR worked with MSU staff to analyze existing GIS/CAD data for attribute gaps. HDR configured a working Esri Utility Network Model of the campus’ electrical system. Following this, CAD/GIS data was migrated into the utility network model and updated based on physical infrastructure and engineering data. HDR provided a technical memorandum summarizing the changes and updates made to MSU’s Enterprise GIS system. Staff are currently supporting the Enterprise GIS upgrade and migration. Future work will include implementing the combined data model and migrating water, sewer, stormwater, heating/cooling, and natural gas. CMMS Needs Assessment & Procurement Support | High Point, NCDue to a lack of vendor support, evolving City needs, and a changing information system environment, the City of High Point was looking to consolidate and replace its existing Computerized Maintenance Management Systems (CMMSs). Through the CMMS Needs Assessment Procurement project, HDR led the evaluation of organizational needs around a CMMS solution through a series of staff interviews and data review. This assessment resulted in a software requirements document that outlined the relevant features and capabilities of a best-fit CMMS solution. Using this insight, HDR then led the development of procurement documentation and the facilitation of proposal evaluation, which included a review of formal submittals and in-person product demonstrations. Once a successful vendor was selected, HDR remained engaged by developing an implementation plan and troubleshooting integration challenges. The project resulted in selecting a consolidated CMMS solution and procuring other services required to integrate and implement this solution within the City. 11 hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services Collection System Improvement Program Management | Winston-Salem, NCThe Collection System Improvement Program is a 5-year program for the City/County Utility Commission, an agency of the City of Winston-Salem, to reduce sanitary sewer overflows (SSOs), increase operational efficiency, and help prioritize and schedule collection system preventative maintenance measures. The program management approach focuses first on optimizing the operation of the collection system, which involves a longer-term condition assessment program to identify and prioritize repairs, rehabilitation, and replacement of lines that would improve the performance of the collection system. Tools are being developed to help prioritize and schedule collection system preventative maintenance measures based on physical inspections from the field. Inspections ranging from routine cleaning to closed circuit television (CCTV) are tracked in the City of Winston-Salem’s Cityworks CMMS. The information collected from the field will be seamlessly entered into their preventative maintenance scheduler tool (COTools), thus streamlining a decision-making process for cleaning, rehabilitation, and/or replacement of collection system infrastructure. The goal of the capacity assessment approach is to ensure that potential projects identified in the master plan were necessary in the timeframe predicted. The goal of the operational optimization work is to enhance how the utility conducts its business to maximize efficiency and effectiveness. The goal of the capital program work is to “right-size” the programs, and execute the right projects, at the right time, for the right cost. 12 hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services6. Description of Proposal Approach to the Project 13 Phase 1 Needs Assessment and RoadmapPhase 1 involves a comprehensive assessment of the City’s current GIS environment. The goal is to develop a roadmap that includes recommendations and a detailed project scope to establish a solid foundation for further development of GIS resources across the organization, aligning with industry standards and best practices. Our approach is informed by our successful track record and lessons learned from similar projects with local governments and utilities. One example being, when developing the roadmap, we will organize the projects in a way that clearly describes the benefits and resources needed, as well as any precursors required and/or effects on other initiatives or projects if a project isn’t included in the roadmap. We also find more success when we highlight City IT involvement to secure collaboration and expedite access and infrastructure requests. Finally, we will employ a City-directed project prioritization process to secure full buy-in for executing the roadmap. Task 1. Project Management and Kick-Off Workshop TASK 1.1. PROJECT MANAGEMENTHDR’s Project Manager, Kyle Burke, will be responsible for the performance, quality, and budget management of the project. Kyle will coordinate with the City of Bozeman’s project team, as required, to finish the described work. He will also serve as the primary point of contact and liaison for work performed. Each month, Kyle will prepare and submit a monthly progress report and invoice that summarizes the activities performed during the previous month, problems encountered, proposed solutions and corrective actions, activities planned for the next month, and the project financial performance. Kyle and key staff will participate in bi-weekly (every other week) check-in calls. He will maintain meeting notes and a running action item list that will be shared with the City. Deliverables• Monthly Invoice and Progress Report TASK 1.2. KICK-OFF WORKSHOPThe project will start with a kick-off workshop, in which HDR will introduce our team, scope, project milestones, schedule, and technical approach. HDR will present on current industry best practices for enterprise GIS, Cityworks, and VertiGIS implementations, including our previous experience with implementing and upgrading enterprise and Cityworks systems. The goal of this presentation is to share knowledge, set expectations, and provide a foundation for City staff. HDR will provide a collaboration solution, such as SharePoint and Teams, or a City-recommended solution, to facilitate information sharing and project tasking. This will allow for the City to have visibility into all progress throughout the project. Deliverables• Presentation• Project kick-off summary• Collaboration site Task 2. Needs AssessmentHDR will gather comprehensive information on the current enterprise GIS, Cityworks, and VertiGIS systems. This information will identify desired condition, strengths, weaknesses, and opportunities for enhancing GIS use and performance across the organization. To gain a greater understanding of the status of these systems, HDR will need to gather specific operational needs based on current City systems and workflows. HDR will conduct interviews and job shadowing of key department staff to better understand those workflows and system architecture. HDR will conduct a review of the City’s Enterprise, Cityworks, and VertiGIS system architecture and key datasets. TASK 2.1. INTERVIEWS AND JOB SHADOWINGHDR will interview and shadow staff in the GIS and Asset Management Division, as well as other relevant departments, to document current workflows and find pain points. We have geospatial professionals who have previously worked closely with City staff doing needs assessments and can facilitate interviews and job shadowing in this initial stage. Kyle will lead department interviews with key staff, as identified by the City. We define these key staff as team members that are not GIS professionals, but users that rely on the tools built with the greater GIS environment. Hearing their stories and incorporating improvements (however small) to their workflows or system performance greatly helps with system adoption. These interviews may lead to field visits for a greater understanding of field crew workflows. HDR has found that office visits and field visits have led to a greater adoption of new technologies and workflows through all departments. hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services 14 For reporting and analyzing results, the interview will have a standard set of questions developed in conjunction with City staff to allow for targeted responses while focusing on workflows, data gaps, and efficiency gains. HDR will facilitate interviews and report findings to the City Project Manager and key stakeholders. Deliverables• Technical Memorandum summarizing interview and field visit findings TASK 2.2. ENTERPRISE, CITYWORKS, AND VERTIGIS SYSTEM ARCHITECTURE REVIEWHDR will review City system architecture from top to bottom. This review will help in understanding the technical specifications, configurations, and customizations implemented within the systems. Our enterprise GIS integration experts, Joel Griffin and Matt Wilson, will work with the City to review and document software, hardware, security, data storage, disaster and recovery plans, and system integrations. The team will evaluate current platforms being utilized, including but not limited to, ArcGIS Desktop and its extensions, ArcGIS Enterprise, ArcGIS Online, VertiGIS, Cityworks, and other systems noted within the City’s RFP. Joel and Matt have helped evaluate and design GIS environments for private and public entities throughout the United States. Their expertise helps us to create custom recommendations and solutions with a variety of factors, such as cost, speed, location, security, licensing, etc. for the long-term health and performance of the City’s infrastructure. Deliverable• Existing GIS Environment and Systems Integration Schematic and Summary Memorandum TASK 2.3. DATA REVIEWThis task involves reviewing and understanding the City’s current GIS data. The focus will be on key datasets relevant to systems integration, as identified by the City. HDR will develop a comprehensive data library, highlighting accuracy and data gaps. The review will assess the consistency and completeness of attributes, feature classes, and feature class domains. Any necessary schema changes to accommodate the required information for system integration will also be identified. HDR will summarize the findings, including data gaps. Deliverable• Data Review Technical Memorandum TASK 2.4. NEEDS ASSESSMENT REPORTThe conclusion of the Needs Assessment is the final report. The report will summarize the technical memoranda generated throughout the assessment. The report is expected to include the following: • City GIS Staff Roles and responsibilities • Staffing and skills requirements • Summary of GIS needs by functional group • GIS environment schematic – hardware/software/system integration • Summary of desired system updates and upgrades • GIS data overview including condition and gaps • Overview of existing GIS data workflows • Recommendations Deliverables• Needs Assessment Report Task 3. Roadmap Development TASK 3.1. PRELIMINARY ROADMAPAt the completion of the Needs Assessment, HDR will develop a roadmap outlining recommendations for optimizing the City’s GIS system. Each recommendation will have clear and defined goals, associated investment, schedule, dependencies, and benefits. The roadmap will be presented with enough detail to communicate goals, benefits, timeline, and technical needs to complete each project. HDR will finalize the roadmap in three steps. First, HDR will develop a preliminary draft roadmap which will include a comprehensive list of systems enhancements and updates. This will be the base for the prioritization and refinement of the roadmap in Task 3.2. HDR will do a preliminary prioritization highlighting foundational projects that are required to meet base technical requirements of this initiative. Deliverables• Preliminary Draft GIS Roadmap TASK 3.2. ROADMAP PRIORITIZATION AND REFINEMENTKyle and Bridget Brown will conduct a prioritization exercise with the City Project Manager and key stakeholders to determine the most critical projects within the roadmap. This exercise will support an objective assessment and prioritization based on potential impact and alignment with City goals. The prioritization process will help balance benefits verses ease of launch while allowing stakeholders to have a voice. This will verify that resources are allocated efficiently and the most beneficial projects are completed promptly all while accounting for seamless integration and compatibility between Esri, VertiGIS, Cityworks, and other systems. Following this exercise, we will present the prioritized draft roadmap to City Project Manager for their input. Their feedback hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services 15 will be used to refine the roadmap, assuring that it incorporates key concerns and is well-aligned with the needs of the organization. HDR is available to support the City’s GIS staff and communicate the GIS roadmap by attending council or other stakeholder meetings as needed. Deliverables• Prioritized Draft Roadmap• Final Roadmap Report Phase 2 Roadmap ImplementationHDR will provide hands-on support to the City throughout the implementation of the roadmap. Our goal is to provide seamless integration and compatibility between Esri, VertiGIS, Cityworks, and other systems. This includes assisting with version upgrades, deploying new technologies, and making necessary configuration changes identified in the roadmap. Additionally, we will develop detailed SOPs for the development and publication of map services, as well as workflows and protocols for managing schema changes and system integrations effectively. Our QA/QC Plan will be designed to maintain the accuracy, consistency, and integrity of the database systems, with monitoring and auditing processes in place to identify and address data quality issues proactively. Lastly, we will develop training resources for City staff on GIS and asset management applications, including training materials, documentation, and workshops, to set your staff up for success utilizing the optimized GIS environment. Task 4. Implement Roadmap RecommendationsKyle and the GIS assessment and integrations team will work alongside the City to execute and assist with selected roadmap initiatives. This includes assisting with version upgrades, deploying new technologies, and making configuration changes as necessary. HDR will develop detailed plans for upgrades and workflows and document processes and outcomes. Based on our assumptions of the General and Technical Requirements, HDR assumes the City will require assistance with the following: • Upgrade Esri ArcGIS Enterprise from version 10.9 to version 11 • Migrate services from ArcMap to ArcPro • Improve catalog system for GIS services and maps • Enhance directory search functionality in ArcPro for non-admin users • Change data schema as required for systems integration • Upgrade Cityworks from 15.8.3 to 2023 • Transfer large library of Crystal Reports to Active Reports • Migrate from Cityworks AMS to Respond • Upgrade to VertiGIS Studio from Geocortex v4.14.5 • Provide uninterrupted access to critical maps during upgrade • Migrate supporting maps and services to ArcGIS Pro • Other roadmap projects as determined by Phase 1 – To be determined Deliverables• Summary Technical Memorandum Task 5. GIS Governance, Standard Operating Procedures, and Quality Control/Quality Assurance Plan TASK 5.1. GOVERNANCEWe have found that the existence of formal GIS Governance and a GIS Technical Committee supports the long-term success of a GIS program. HDR will develop a GIS Governance plan, establishing a structure for guiding and strategizing future GIS activities. This will involve creating a charter document and establishing a technical committee. We suggest that the GIS Technical Committee consist of representatives from key City GIS end users, IT, and GIS and Asset Management staff. Most importantly GIS Governance will provide a structure for decision making effecting the City’s GIS environment. Deliverables• GIS Governance Charter Document TASK 5.2. STANDARD OPERATING PROCEDURES AND QUALITY CONTROL/QUALITY ASSURANCE PLANRelated to governance, we will support the City in development of SOPs and a QA/QC plan. The SOPs developed in Phase 2 are expected to be focused on creating and publishing map services. These SOPs will define workflows and protocols for effectively managing schema changes and system integrations. HDR will also support the City with creating a QA/QC plan for maintaining database systems. The plan will identify data integrity best practices and implement monitoring and auditing processes to identify and address data quality issues proactively. We will reference existing industry and local government standards in relation to geospatial data upkeep, while also leveraging the vast amount of insight gained during the Needs Assessment to construct thorough processes that work for the City. These standards and hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services 16 plans will be dynamic and updated throughout the implementation of the roadmap. This approach will build a reliable foundation to implement an optimized system of record that the City can rely on when they need it most. Deliverables• Map Service and GIS Data Schema SOPs• GIS Data QA/QC Plan Task 6. TrainingEnd user and administrative training is critical to this investment into the City’s GIS systems. HDR will develop comprehensive training resources for city staff on how to use the GIS and Asset Management applications that were upgraded and optimized. We understand that people learn in different ways so we will provide a variety of training materials including documentation and hands-on workshops. During the finalization of the roadmap, we will identify the key trainings to develop. Deliverables• Training documents and materials• In-person Training Workshops Meeting project goals and staying within the agreed upon project budget and schedule is a testament of the rigor taken during scoping and deliverables discussions. Working closely with the City to understand the desired scope of work and decision points embedded therein allows HDR to define the level of effort required to attain the City’s visions. Together, the team decides the execution timeline. This process manages expectations from the beginning and, through our diligent application of project controls, makes sure that the is project on time, on budget, and achieves Bozeman’s goals. The schedule shown below details the potential timeline for anticipated key tasks and project deliverables. It is important to note, however, that the schedule can be impacted significantly by decisions that Bozeman and HDR make related to Phase 2 and roadmap implementation. 2024 2025 Q2 Q3 Q4 Q1 Q2 Q3 Q4 Phase 1 Task 100. Project Management Task 200. Needs Assessment Task 300. Roadmap Development Phase 2 Task 400. Implement Roadmap Recommendations Task 500. GIS Governance, SOP, and QA/QC Plan Task 600. Training Kick-off Workshop 7. Proposed Schedule hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services We understand the importance of meeting project schedules.The capacity to accomplish work in a strict timeframe requires strong and experienced leaders backed by skilled team members. Our personnel are dedicated to providing sufficient time and effort to produce a quality product. With this in mind, our team members were carefully selected not only for their expertise, but also for their availability to work on the project for its duration. We follow well-established and time proven procedures to manage our project work and have assembled a strong team that is available to begin work upon notice to proceed. You can rely on us to successfully deliver this project. Project commitments for our key team members, as well as availability for this effort (with consideration of project role) are shown below. TEAM MEMBER NAME AND ROLE CURRENT PROJECT COMMITMENTS WITH COMMITMENT END DATE AVAILABILITY FOR THIS PROJECT Kyle Burke Project Manager • St Mary Watershed EIS (4/24) • MSU - Domestic Water Utility Network GIS Conversion (6/24)• Milk River Joint Board of Control GIS Services (8/24) 45% Bridget BrownSenior Technical Advisor • City of Billings GIS Services (12/24)• Ontario Line, Metro Linx (12/25) • Bonneville Power Authority SCM Program (10/24) 35% Rachael Ostrum GIS Analyst • St Mary Watershed EIS (4/24) • MSU - Domestic Water Utility Network GIS Conversion (6/24) • Milk River Joint Board of Control GIS Services (8/24) 55% Joel Griffin Enterprise GIS • Oak Ridge National Labs 3D Master Plan (3/24) • Delta Diablo Enterprise GIS and Utility Network Implementation (6/24)• Yuba Water GIS Program Roadmap (6/24 ) 30% Terry MacNeillEnterprise GIS • US Army Corps of Engineers Sacramento Weir ArcGIS Enterprise Implementation (12/24) • South Carolina Port Authority ArcGIS Enterprise (6/24)• Baton Rouge Water Company ArcGIS Enterprise High Availability (7/24) 25% Matt WilsonCityworks Support • City of Billings GIS Services - WRF Cityworks Implementation (12/24)• High Point Cityworks Implementation (10/24) • Great Lakes Water Authority LSIP Risk Model (6/24) 45% 17 8. Present and Projected Workloads hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services HDR has extensive experience working for the City of Bozeman, including: • Wastewater Facility Plan Update • Solids Handling Expansion • Davis Lane Lift Station • Bridger Creek Flood & Erosion Control • East Gallatin Avulsion • Norton Lift Station Evaluation • TMDL Water Modeling • Impact Fee Study • Manley Ditch Rehabilitation Study • WTP Membrane Feed Pump • On-Call Wastewater Assistance Contract • Emergency Response Plan • Phase II Stormwater Assistance 18 9. Recent and Current Work for the City of Bozeman 10. References We leverage Esri ArcGIS technology to create innovative solutions. Our long-standing relationship with Esri spans more than 20 years. And, as a Platinum Partner in the Esri Partner Network, we align our strategic plan with Esri’s technology roadmap. We continually invest in our GIS program, and we are proud to have demonstrated the credentials to earn ArcGIS System Ready and Utility Network Management specialties. With these specialties, customers can be confident that HDR has proven expertise in ArcGIS technology, supporting specific solutions and implementation for utilities for water organizations. We regularly engage Esri, leveraging our partner relationship, to give our approaches a critical eye, for technical support and troubleshooting, and for coordinating support with our clients, like the City of Bozeman. HDR has provided GIS and asset management services for a variety of municipalities. References for our proposed staff are below. CONTACT PHONE/EMAIL PROJECT Jennifer DurayCity of Billings 406.657.8239 Billings GIS Support Andrew PiersonSan Juan Water District 916.791.0115 San Juan Water District GIS Implementation Michael KnappMunicipality of Anchorage 907.310.0137 GIS Environmental Support John Bianco, PEDefense Logistics Agency 717.770.5270 Geospatial Technology Services Khae BohanCentral Contra Costa Sanitary District 925.229.7327 Migration to Utility Network hdrinc.com Version # City of Bozeman | Professional Geographic Information Systems (GIS) Services11. Price Proposal for Both Phase 1 & Phase 2 PHASE 1 TASKS COST Task 1. Project Management $23,839 Task 2. Needs Assessment $35,679 Task 3. Roadmap Development $19,882 PHASE 1 TOTAL $79,400 Assumptions: •Task 1. Project Management and Phase 1 Kick-Off °HDR assumes a nine-month project duration for project management costs. °One-hour monthly check in calls for one HDR staff for the duration of Phase 1. °One half-day (4 hour) in person Kick-Off workshop with up to three HDR staff. Cost includes travel for HDR staff. •Task 2. Needs Assessment °Key City staff will be made available for in office interviews with HDR staff. °HDR will conduct up to five, two-hour, interview sessions with City staff. Cost includes travel for HDR staff. °The City will provide HDR access for system architecture reviews. °Data set review will be limited to up to 20 city prioritized datasets. Data review technical memorandum will include data review methods the City can apply to additional datasets. °City will provide comments and review on technical memorandums within two weeks of draft submittal. •Task 3. Roadmap Development °City will provide comments and review on each of the preliminary and draft roadmap deliverables, within two of submittal. °One half-day (4 hour) in person prioritization workshop with up to three HDR staff. Cost includes travel for HDR staff. °Key City staff will be made available for roadmap reviews. PHASE 2 TASKS COST Phase 2 Project Management $39,339 Task 4. Implement Roadmap $95,611 Task 5. Governance, SOP, QA/QC $30,980 Task 6. Training $32,461 PHASE 2 TOTAL $198,390 Assumptions: Fees include an escalation of labor rates at 5% as work is expected to begin in 2025. •Phase 2 Project Management and Kick-Off °HDR assumes a 12 month project duration for project management costs. °One-hour monthly check in calls for one HDR staff for the duration of Phase 1. °One half-day (4 hour) in person Kick-Off workshop with up to three HDR staff. Cost includes travel for HDR staff. •Task 4. Implement Roadmap Recommendations °Fee assumes implementation of general technical requirements outlined in scope; other roadmap projects determined during Phase one are not included. °Cost includes travel for HDR staff to support City staff on-site with implementations for up three staff up to three days. °City will provide comments and review on technical memorandums within two weeks of draft submittal. •Task 5. GIS Governance, Standard Operating Procedures, and Quality Control/Quality Assurance Plan °City will provide comments and review of draft governance charter, SOP, and QA/QC plan within two weeks of draft submittal. •Task 6. Training °Cost includes travel for up to three HDR staff for two, four-hour training sessions. 19 Attachment A HDR Engineering, Inc. HDR Engineering, Inc. Resumes (Provided alphabetically) Bridget Brown Kyle Burke Ben Fennelly Joel Griffin Terry MacNeill Rachael Ostrum Matt Wilson Bridget is an experienced geospatial professional with more than 22 years of experience providing valuable spatial analysis and data management skills to a wide variety of projects. She has experience with a multitude of GIS applications including spatial analysis, suitability modeling, environmental modeling, database design, and mobile devices. As a skilled cartographer and GIS analyst, Bridget leverages geographic information to visualize problems, design solutions, enhance communication, and make better decisions. She supports environmental document production and provides project mapping to assist in decision-making processes. She is experienced in the full suite of Esri ArcGIS software and extensions, as well as mobile data collection systems. In her role as HDR’s Geospatial and Information Management Director, Bridget provides guidance and management to HDR’s national geospatial program. City of Billings, GIS ServicesAs the Project Manager, Bridget has been leading the City of Billings through their GIS modernization since 2019. The City aimed to optimize its GIS usage for asset management and other business processes. To adapt to evolving technology and maximize system investments, they prioritized enhancing the City’s GIS environment. The main goal was to create a user-friendly GIS system to boost Public Works staff’s productivity and efficiency. HDR devised a two-phase approach to assist the City: the first phase focused on a needs assessment and a GIS Roadmap, while the second phase involved implementing the GIS Roadmap with HDR’s support. To assess the enterprise GIS environment effectively, it was crucial to understand Public Works’ operational requirements and challenges. From June to August 2020, HDR’s team conducted a GIS Needs Assessment, meeting with Public Works leadership, Divisions, and City IT and GIS. They also conducted a thorough data review to identify gaps in data completeness, accuracy, and consistency. Based on the needs assessment, HDR created a GIS Roadmap that outlined opportunities for improvement. This roadmap was developed in collaboration with the City to prioritize projects. Phase two Roadmap projects included GIS Governance, data updates, ArcGIS Portal implementation, Esri Utility Network pilot, Cityworks updates and integrations, and a suite of updated ArcGIS Online apps and dashboards. HDR is currently supporting the city with a Cityworks implementation at their Water Reclamation Facility. These foundational improvements positioned the City for long-term success and facilitated future growth with new GIS and asset management technologies. Port Gamble S’Klallam TribeBridget was the project manager for this mobile application development effort. In the past PGST’s water quality program had been challenged by outdated methods; cumbersome paper forms and arduous manual transcription. Bridget’s team streamlined workflows by listening to PGST’s needs and developing a mobile application that follows required standards and has built in data integrity checks to further reduce time and errors during collection and transcription.US Army Corps of Engineers, Enterprise GIS Implementation PlanHDR’s work with the USACE - Alaska District moved eGIS from concept to reality, bringing efficiencies that will translate to real-world cost savings. HDR helped USACE implement enterprise GIS, which entailed a comprehensive review of geospatial activities and business processes within the agency. HDR authored an eGIS implementation plan addressing staffing, hardware, software, application development, data management, quality control, and oversight. HDR provided on-site technical support with hardware configuration and software installation. Defense Logistics Agency, Needs Assessment/Business Case AnalysisHDR conducted a User Needs Assessment analysis for 25 DLA Distribution sites worldwide. Results of the assessment were used to improve quality of the data and build consolidated databases. HDR also developed a Business Case Analysis document for justification of continued investment in geospatial infrastructure. HDR proposed solutions for an enterprise-wide GIS development program and provided expertise in system design and architecture. EDUCATIONBachelors, Wildlife Biology, University of Wisconsin, Madison, 2000 Masters, Geographic Information Systems, Penn State University Park, 2008 Bridget Brown Senior Technical Advisor Kyle is a GIS Manager with experience managing projects and working with numerous city/local/state/federal government, utility, and university clients. His experience is focused on integrated cloud and web-based mapping solutions, as well as standardized database schemas, for project management, asset management, field work coordination, and enterprise systems. Kyle leverages geographic information to visualize problems, design solutions, enhance communication, and make better decisions. He also has experience in deploying Esri’s Utility Network for clients. His goal is to use GIS to provide innovative solutions for clients and their partners. MSU-Bozeman, Campus Electrical Map GIS ConversionHDR provided GIS services to update the campus’s existing electrical GIS datasets to improve the scalability of the ArcGIS Enterprise platform used to host and visualize data. The existing electrical GIS was derived from CAD layers directly imported into GIS. HDR performed a data model review to determine if future organizational needs could be met or if additional changes were needed. HDR worked with MSU staff to analyze existing GIS/CAD data for attribute gaps. HDR configured a working Esri Utility Network Model of the campus’ electrical system. Following this, CAD/GIS data was migrated into the utility network model and updated based on physical infrastructure and engineering data. HDR provided a technical memorandum summarizing the changes and updates made to MSU’s Enterprise GIS system. Staff are currently supporting the Enterprise GIS upgrade and migration. Future work will include implementing the combined data model and migrating water, sewer, stormwater, heating/cooling, and natural gas. Sunflower Electric Power Corp., On-call GIS SupportHDR provided on-call GIS support for Sunflower’s internal staff in two phases of its GIS database. The goal of the first phase was to support Sunflower in configuring ArcGIS Enterprise, so they can effectively share GIS data across its organization. The goal of the second phase was to relate GIS to other databases, such as Cascade EAM. City-County of Butte-Silver Bow, Butte Water Lead Service Line InventoryHDR collaborated with BSB GIS staff to compete a lead service line (LSL) inventory and creating an online ArcGIS-based webpage accessible to the public. Data collection included ditch cards, customer records, property data, leak repair notes, meter installation records, building permits, water main replacement as-builts, GIS data, and paper maps. The Esri Lead Service Line Solution will allow BSB to set up internal dashboards to track inventory progress and other program efforts like replacement goals, sampling progress, and communication notification efforts. HDR also created an LSL Replacement Plan, providing strategies for determining “lead status unknown” service lines, replacement prioritization strategies, and replacement goal rates. Unknowns were categorized into three groups for verification (high-, medium-, and low-lead probability) to prioritize replacements in the areas with the greatest probability of lead, reduce uncertainty, and save program costs. Milk River Joint Board of Control, GIS ServicesHDR used ArcGIS Online to create a custom web map, which was then used to create a custom web application. This provides a tool to visualize and verify irrigated acres within each irrigation district during a given year. MRJBOC can view district boundaries and parcel information, digitize irrigated agricultural fields, measure distances and acreages, and update attribute information. This tool will be used as a tracking mechanism to provide program efficiencies. EDUCATIONBachelors, Anthropology, University of Montana, Missoula, 2015 Masters, Geographic Information Science and Technology, University of Southern California (USC), 2018 Bachelors, History, University of Montana, Missoula, 2012 REGISTRATIONSCertified GIS Professional, MT, No. 161587 Kyle Burke, GISP Project Manager Ben has 20 years of experience performing and managing a wide range of projects. He oversees resources, staffing, strategic direction, project quality, and performance. As Principal-In-Charge, Ben is responsible for monitoring all phases of the project, quality assurance, assembling the appropriate technical expertise and resources for each phase, and certifying that the deliverables meet clients’ requirements. One of his most effective tools is his ability to communicate and collaborate with the client team, the consultant team, the stakeholders, and the public to build consensus. He has a history of solving complex project problems with a communication style that make all comfortable with the technical, cost, and schedule implications of proposed solutions. Ben’s diverse experience provides efficiencies in design and provides the client opportunities to efficiently meet their goals. City of Bozeman, Downtown Bozeman Creek Culvert Condition AssessmentBozeman Creek flows under the City of Bozeman through five different culverts: Olive Street (approximately 220 FT long), Babcock Street (approximately 170 FT long), Main Street (approximately 330 FT long), Mendenhall Street (approximately 60 FT long), and Lamme Street (approximately 70 FT long). HDR assessed these culverts using multiple unmanned drones and provided a condition assessment in preparation for a future structural analysis of the culverts and buildings located on the culverts. Given the safety concerns of the confined spaces, the culverts were inspected using a robotic unmanned survey system to simultaneously collect digital video and photogrammetry data to capture more detailed, quantifiable information under adverse conditions and provide a profile of the culverts, as well as inform the preliminary structural assessment and future rehabilitation efforts. City of Bozeman, Sediment Management FacilityHDR designed a sediment treatment facility to handle the City of Bozeman’s Vactor© truck waste streams from stormwater and sewer operations. HDR used industry knowledge of existing sediment facilities in the USA to provide a phased facility approach to address a limited budget and a value-engineered design to meet the City’s current needs and anticipated future needs to decrease the upfront capital costs. HDR recommended using ecology blocks to form bays and drying beds, since the blocks are readily available in the City and can be moved to accommodate the City’s changing needs at the facility. In addition, HDR designed the discharge to utilize a nearby abandoned lined pond to avoid a discharge permit process, as well as utilize evaporation methods for the discharge of the facility. Ben provided construction oversight services to make sure the design’s intent and City’s needs were met. City of Bozeman, TMDL ModelingHDR provided preliminary water quality modeling to assist the City of Bozeman in understanding the potential implications of the TMDL on their National Pollutant Discharge Elimination System (NPDES) permit. City of Bozeman, Manley Ditch Rehabilitation StudyIn 2018, the City of Bozeman observed storm water drainage issues near the existing railroad tracks on the southwestern side of the East Gallatin Recreation Area. Heavy spring runoff had caused water to pond behind the railroad embankment and it was discovered that the outlet of the existing culvert passing beneath the embankment had been capped. Due to backwater pressure from the pond, water began seeping through the outer annular space of the culvert which resulted in minor flooding issues on the downstream side. HDR performed a feasibility analysis on three design alternatives that would improve conveyance, reduce the likelihood of future flooding issues, and be a cost effective solution for the City. Ben provided an initial alternative and feasibility overview and reviewed the hydrologic and hydraulic considerations. EDUCATIONMasters, Civil and Environmental Engineering, University of Iowa, 2006 Bachelors, Civil Engineering, Carroll College, 2004 REGISTRATIONSCertified Floodplain Manager, No. US-10-05173 Professional Engineer, MT, No. PEL-PE-LIC-16618 Ben Fennelly, PE, CFM Principal-in-Charge Joel has more than 20 years of experience in GIS data management, utility network, integrations, web applications, cartography, and analysis. He has experience in utilities, local government, energy, and federal government industries. He has experience in the design, implementation, and integration of ArcGIS Enterprise and ArcGIS Online. Has been the team lead and subject matter expert for permitting, utility management, and field data collection for major infrastructure projects. He is a proven communicator and instructor in GIS design and task management in desktop, web, and mobile applications. He has been published for his cartographic work and GIS implementations. City of Billings, GIS ServicesJoel has been integral during Phase 2 of the City of Billings GIS modernization efforts. Specifically, Joel has lead the technical aspects of the database improvement updates, ArcGIS Portal implementation, Esri Utility Network pilot, Cityworks updates and integrations, and a the suite of updated ArcGIS Online apps and dashboards. Joel has become a trusted advisor for the City. He has developed the critical documentation of system improvements and created and hosted the various GIS trainings with City staff. He is currently supporting the GIS aspects of the Cityworks implementation for their Water Reclamation Facility. These improvements and Joel’s support have positioned the City for long-term success and facilitated future growth with new GIS and asset management technologies. Defense Logistics Agency, Area Development Plan for NSA PhiladelphiaHDR provided 1 comprehensive review of physical planning and an analysis of infrastructure issues is needed for the Defense Logistics Agency (DLA) at Naval Support Activity Philadelphia (NSA-P). Changing conditions and new requirements necessitate an updated Area Development Plan (ADP), a planning action that will reexamine constraints, opportunities, and facility requirements and make recommendations to resolve facility deficiencies, maximize operational efficiencies and right size the footprint of DLA. The ADP will outline a program for improving the operational environment and mission accomplishment with short-, mid-, and long-term changes to the facilities infrastructure, with phased execution over the next 25-year time period. The ADP will act as a framework that sets a clear direction to effectively plan, develop, and execute projects to address current deficiencies and future mission growth for DLA, while considering impacts to other tenant organizations at NSA-P. To better support plan development and position DLA for project execution planning, the preparation of eight Basic Facility Requirements and the development of one DD1391 with a Project Readiness Index Level 1 (PRI#1) cost estimate is also required. Delta Diablo, GIS Consulting ServicesHDR migrated Geometric Network source data into a multi-domain Utility Network for sewer collection and recycled water. Work included linking together document records to utility features used in an ArcGIS Pro desktop environment for migration review and testing. HDR configured several trace configurations for both utility domains, published to ArcGIS online for field workers to access and test, and configured and managed portal web applications and dashboards. San Francisco Public Utilities Commission, San Joaquin Pipeline ArcGIS Online and Data ServicesHDR developed data, workflows, and solutions that will provide access to geospatial data and supporting documents via a web application, which will support future water transmission system condition assessments, alternatives analyses, and conceptual engineering reports. The project included creating and updates of data layers for right-of-way map extents along the San Joaquin Pipeline, review and updates to supporting data, and configuration of AGOL applications to provide a system of engagement for San Joaquin Pipeline GIS data and documents. The project was considered forward looking and will accommodate the transition of the solutions developed in AGOL into San Francisco Public Utility Commission’s enterprise GIS at a future date. The project provided policies and standards regarding data updates to Oracle Spatial Database Engine, AGOL, and Portal for ArcGIS. Work also included documentation and training for AGOL applications configured as part of this project. EDUCATIONBachelors, Geography, University of California, Santa Barbara (UCSB), 2003 CERTIFICATIONSGeographic Information Systems Professional (GISP) No. 90149 Esri ArcGIS Desktop Associate, EADA19-001 No. 412098078 Esri Enterprise Administration Professional, EAEP19-001 No. 412096431 Esri Utility Network Specialty, EUNS20-001 No. 412259207 Joel Griffin, GISP Enterprise GIS Terry has more than 45 years of experience in GIS data management, web applications, cartography and analysis. Terry has experience in transportation, water, local government, energy, and local, state and federal government industries. Terry has extensive experience in GIS, data integration, operating systems/virtualization, database and CAD. Yuba Water Agency, GIS Program DevelopmentHDR assisted YWA with collection and organization of their data, development of operations guides and SOPs, and implementation of their enterprise GIS. Baton Rouge Water Company, Enterprise GIS UpgradeHDR is working with BRWC GIS staff in determining the optimal “to be” technical architecture required to support the upgrade to ArcGIS Enterprise. Delta Diablo, Enterprise GIS ServicesHDR is supporting and implementing an Enterprise GIS system. HDR is providing regular monthly support in the administration of enterprise GIS software and support with GIS software and data needs. San Juan Water District, GIS and CMMS ServicesHDR provided CMMS and GIS services to support San Juan Water District’s CItyworks CMMS and Esri’s ArcGIS systems. Once the systems were fully implemented and operational, HDR’s technical resources provided as-needed basis to provide assistance for specialized tasks such as software upgrades, data modifications, troubleshooting, etc. South Carolina Ports Authority, Hugh Leatherman Terminal Construction GIS InspectionSCPA valued the new way to view their data in a GIS format and wanted to expand these capabilities throughout the port facilities. SCPA, working with HDR, began to outline the implementation of a GIS program. In February 2022, seeing the value in how GIS and supporting applications can improve access to information and improve workflows, SCPA brought HDR under contract to assist in developing their GIS program. As part of this program initiation, SCPA has improved data inventories and defined a plan to convert historical design hard copy documents to digital files integrated into GIS. Geo-Spatial Enabling ProjectSenior architect for a project to geo-spatially enable water allocation and water disturbance data that is sourced from Alberta Environment’s Enterprise Data Warehouse (EDW). The purpose of spatially enabling the data was to support water mastering initiatives within the department. The EDW is a SQL server database that is optimized for business query and intelligence using OLAP cubes. The project involved enabling the geo-spatial and related business data and accessing the data for the presentation tier via .NET web data services and ArcGIS Server map services. Integrated Cadastral Information Management SystemTerry led a team of consultants in the development of a strategic implementation plan for an integrated geographic information system that included components of the Canada Land Surveys System and the Indian Land Registry System. This was a follow-up for a project that was performed for this client in 2002. The project included documentation review, situational analysis, existing data and applications inventory assessment, business process development and improvement, development of conceptual data models and application and technology requirements. The key deliverable for this project was a detailed implementation plan that included data conversion costs, application development costs, technology acquisition and project governance structure. EDUCATIONBachelor of Science, University of Toronto TRAININGS & CERTIFICATIONS ArcGIS On-line, Operations Dashboards, Enterprise Sites, ArcGIS Insights, Experience Builder ArcGIS Desktop 10.8.1 ArcGIS Enterprise 10.9.1 ArcGIS Server, Portal for ArcGIS, ArcGIS Datastore, ArcSDE, Image Server ArcGIS Pro 2.9 ArcFM Designer, ArcFM Mobile, ArcFM Web Collector for ArcGIS, ArcGIS Explorer, ArcGIS Field Maps, Survey 123 Portal for ArcGIS, ArcGIS Server REST APIs Esri Web App Builder Developer Edition ArcGIS Maps for SharePoint ArcGIS for Power BI ArcGIS Web Services, OGC/ WMS Services Geocortex Essentials 4.x PetroWEB Navigator; FME Desktop 2021 – Esri Edition, FME Server 2021; FME Cloud Maximo Spatial Adapter 7.6.1 Amazon Web Services Microsoft Azure Terry MacNeill Enterprise GIS Rachael is a GIS Technician who has worked with and supported numerous clients with geospatial needs. She creates route maps and layouts used for deliverables, updates and adds data into GIS databases, performs analysis on data given in a variety of different formats, and reviews GIS data for completeness and accuracy. Rachael has also built several custom web applications to make the data viewing experience easier to understand and interpret for our clients. She works closely with clients and project managers to verify projects are completed to satisfaction and in a timely matter. By leveraging detailed initiatives that lay out projects and objectives meant to amplify how our client can leverage GIS, she helps streamline business across all client divisions and prepares them for any future changes. She is knowledgeable with geodatabase management/creation, cartographic design/map making, spatial analysis, utility network, arcade, and web application creation, and is proficient with ArcGIS Pro, ArcGIS Online, and various other Esri applications. City of Billings, GIS ServicesThe Public Works Department has a goal to modernize their use of GIS to support asset management and business processes. A two phased approach including a needs assessment and implementation plan followed by plan execution was developed by HDR. HDR is currently implementing the roadmap including GIS Governance, database improvements, Esri Utility Network pilot using FME workflows for data migration, CMMS (Cityworks) updates and integrations including mobile and reporting, ArcGIS Portal implementation, AVL tracking (LiGO) and OneCall integrations with GIS and Cityworks, and a suite of updated ArcGIS Online apps and dashboards. Rachael specifically supported the myriad of data improvement initiatives and ArcGIS Online tool configuration. These initiatives are amplifying how City leverages GIS to streamline business operations across all Public Works divisions. City-County of Butte-Silver Bow, Butte Water Lead Service Line InventoryHDR collaborated with BSB GIS staff to compete a lead service line (LSL) inventory and creating an online ArcGIS-based webpage accessible to the public. Data collection included ditch cards, customer records, property data, leak repair notes, meter installation records, building permits, water main replacement as-builts, GIS data, and paper maps. The Esri Lead Service Line Solution will allow BSB to set up internal dashboards to track inventory progress and other program efforts like replacement goals, sampling progress, and communication notification efforts. HDR also created an LSL Replacement Plan, providing strategies for determining “lead status unknown” service lines, replacement prioritization strategies, and replacement goal rates. Unknowns were categorized into three groups for verification (high-, medium-, and low-lead probability) to prioritize replacements in the areas with the greatest probability of lead, reduce uncertainty, and save program costs. Milk River Joint Board of Control, GIS ServicesHDR used ArcGIS Online to create a custom web map, which was then used to create a custom web application. This provides a tool to visualize and verify irrigated acres within each irrigation district during a given year. MRJBOC can view district boundaries and parcel information, digitize irrigated agricultural fields, measure distances and acreages, and update attribute information. This tool will be used as a tracking mechanism to ensure program efficiencies. EDUCATIONBachelors, Environmental Sciences, Montana State University, Billings, 2021 Rachael Ostrum GIS Analyst As a GIS developer, Matt works with clients and coworkers to design and implement both desktop and web applications that assist with the creation, aggregation, and visualization of spatial data for a variety of projects. He has extensive experience working with multiple GIS platforms, synthesizing data from multiple data sources, communicating analytical results visually, in writing, and through oral presentations to a wide variety of audiences. Matt has been assisting clients with preparing CMMS design guides to support the implementation of asset management, work orders, preventative maintenance, and replacement schedules for client utility assets, and has been assisting clients with implementing systems in existing GIS and Cityworks platforms. Johnston County, Central Johnston County Regional Wastewater Treatment Facility Cityworks Computerized Maintenance Management System (CMMS) ImplementationHDR provided CMMS implementation assistance that incorporate the Central Johnston County Regional Wastewater Treatment Facility into the Cityworks cloud-based system. Work included: integrating the county’s desired asset management practices with the functionality and workflows supported by Cityworks (thus forming the foundation for setting various configuration options and workflows in the software, for process-related training and documentation, and for implementing industry asset management principles); populating GIS with plant asset inventory data and creating the required linkages that enable Cityworks to access the county’s asset data from Johnston County’s GIS; developing a testing plan that confirms that the system’s configuration decisions, execution, and data work together with Cityworks to perform the specified functions; providing system configuration, data loading, and testing; and training users on the Cityworks software tools and processes. City of High Point, CMMS Needs Assessment & Procurement SupportThrough the CMMS Needs Assessment Procurement project, HDR led the evaluation of organizational needs around a CMMS solution through a series of staff interviews and data review. This assessment resulted in a software requirements document that outlined the relevant features and capabilities of a best-fit CMMS solution. Using this insight, HDR then led the development of procurement documentation and the facilitation of proposal evaluation, which included a review of formal submittals and in-person product demonstrations. Once a successful vendor was selected, HDR remained engaged by developing an implementation plan and troubleshooting integration challenges. The project resulted in selecting a consolidated CMMS solution and procuring other services required to integrate and implement this solution within the City. City of Winston-Salem, Collection System Improvement Program ManagementThe Collection System Improvement Program is a 5-year program for the City/County Utility Commission, to reduce SSOs, increase operational efficiency, and help prioritize and schedule collection system preventative maintenance measures. The program management approach focuses first on optimizing the operation of the collection system, which involves a longer-term condition assessment program to identify and prioritize repairs, rehabilitation, and replacement of lines that would improve the performance of the collection system. Tools are being developed to help prioritize and schedule collection system preventative maintenance measures based on physical inspections from the field. Inspections ranging from routine cleaning to CCTV are tracked in the City of Winston-Salem’s Cityworks CMMS. The information collected from the field will be seamlessly entered into their preventative maintenance scheduler tool (COTools), thus streamlining a decision-making process for cleaning, rehabilitation, and/or replacement of collection system infrastructure. The goal of the capacity assessment approach is to ensure that potential projects identified in the master plan were necessary in the timeframe predicted. The goal of the operational optimization work is to enhance how the utility conducts its business to maximize efficiency and effectiveness. The goal of the capital program work is to “right-size” the programs, and execute the right projects, at the right time, for the right cost. EDUCATIONBachelors, Geographic Information Science, Appalachian State University, 2018 Masters, Geography, Appalachian State University, 2019 REGISTRATIONSCertified GIS Professional, No. 161364 Matt Wilson, GISP Cityworks Support