Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
Bozeman GIS Langan Response 2021-01-15 3pm MST
Response to Request for Proposal: GIS DATA AND DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK Submitted to: City of Bozeman January 15, 2021 Technical Excellence Practical Experience Client Responsiveness SUSTAINABLE DESIGN HEALTH & SAFETY Langan is committed to providing a healthy and safe working environment. Langan’s goal is to be SAFE (Stay Accident Free Everyday). Langan professionals design solutions that maintain the inherent connections between structures and their natural surroundings. The result - sustainable communities for future generations to live, work and play. January 15, 2021 City of Bozeman Attn: Mike Maas City Clerk P.O. Box 1230 Bozeman, MT 59771-1230 Re: Request for Proposals for a GIS Data and Database Architecture and Data Maintenance Health Check Dear Mr. Maas, Langan Engineering and Environmental Services, Inc. (Langan) is pleased to provide our proposal for Geographic Information System (GIS) Services to support the upcoming GIS Data and Database Architecture and Data Maintenance Health Check in your request for proposal (RFP). As an Esri® Business Partner with Local Government and ArcGIS Online Specialties, Langan has extensive experience successfully completing similar projects and we are confident that we can exceed the City of Bozeman’s (City) expectations. Our approach will consist of the following key points: • Incorporating Langan’s technical experience in reviewing existing data and system architecture, designing and updating datasets, and implementing dynamic, future ready, web-based Enterprise GIS; and, • Leveraging our technical expertise in developing off-the-shelf and customized user-friendly Esri® industry standard data models, data maintenance, and web and mobile applications. Our technical approach and fee proposal for conducting the scope of work has been provided herein. Should you have any questions or need additional information, please do not hesitate to call us at 484.363.0720. Sincerely, Langan Engineering and Environmental Services, Inc. Brock Saylor Brett Milburn, GISP GIS Manager, Western Region Director of Applied Technologies/VP City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 1 of 23 Table of Contents EXECUTIVE SUMMARY ........................................................................................................................................... 2 INTRODUCTION ..................................................................................................................................................... 2 GIS SOLUTIONS FOR LOCAL GOVERNMENT ............................................................................................................ 2 LANGAN'S GEOSPATIAL SERVICES: ..................................................................................................................................... 3 OUR VALUE: ................................................................................................................................................................. 3 PROJECT UNDERSTANDING .................................................................................................................................... 3 FIRM PROFILE ........................................................................................................................................................ 4 PROJECT DIRECTOR:........................................................................................................................................................ 4 PROJECT MANAGER: ....................................................................................................................................................... 4 REGIONAL OFFICES: ........................................................................................................................................................ 4 DESCRIPTION OF PROPOSED SOLUTION ................................................................................................................. 4 TASK 1 – REVIEW EXISTING USE OF ENTERPRISE GEODATABASE .............................................................................................. 4 TASK 2 – REVIEW EXISTING USE OF FILE GEODATABASES ....................................................................................................... 5 TASK 3 – REVIEW EXISTING USE OF HOSTED DATA ............................................................................................................... 5 TASK 4 – RECOMMENDATIONS FOR IMPROVING DATABASE MAINTENANCE AND OVERALL PERFORMANCE ...................................... 6 TASK 5 – RECOMMENDATIONS TO IMPROVE DATA MANAGEMENT AND INTEGRATIONS ............................................................... 6 TASK 6 – RECOMMENDATIONS FOR NEW DATA MODELS ....................................................................................................... 7 TASK 7 – RECOMMENDATIONS AND BEST PRACTICES FOR DATABASE TYPE USE .......................................................................... 9 TASK 8 – REVIEW OF EXISTING GIS INTEGRATIONS AND GUIDANCE FOR EFFICIENT USE OF FME .................................................. 10 TASK 9 – TRANSITION PLAN FROM ARCGIS DESKTOP TO ARCGIS PRO ................................................................................... 11 SCOPE OF PROJECT .............................................................................................................................................. 12 DELIVERABLE ....................................................................................................................................................... 12 RELATED EXPERIENCE AND STATEMENT OF QUALIFICATIONS ............................................................................. 12 SOUTH WHITEHALL TOWNSHIP – ON-CALL GIS SUPPORT .................................................................................................... 13 GREATER NEW HAVEN WATER POLLUTION CONTROL AUTHORITY – DATABASE UPDATES, GIS MAPPING, WEBSITE DEVELOPMENT, AND ENTERPRISE INTEGRATIONS ...................................................................................................................................... 14 BROOKFIELD WATER POLLUTION CONTROL AUTHORITY – DATABASE UPDATES, GIS MAPPING, MOBILE APP DEVELOPMENT, AND ENTERPRISE INTEGRATIONS ............................................................................................................................................ 15 PORT AUTHORITY OF NEW YORK AND NEW JERSEY – LAW ENFORCEMENT/COMPUTER-AIDED DISPATCH MAPPING AND ARCGIS HUB DEPLOYMENT .............................................................................................................................................................. 16 METRO-NORTH RAILROAD – DEVELOPMENT SERVICES ........................................................................................................ 17 REFERENCES ......................................................................................................................................................... 17 PRESENT AND PROJECTED WORKLOAD................................................................................................................ 19 KEY PERSONNEL ................................................................................................................................................... 19 TEAM QUALIFICATIONS ....................................................................................................................................... 20 PRICE PROPOSAL ................................................................................................................................................. 22 CLOSING .............................................................................................................................................................. 23 City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 2 of 23 EXECUTIVE SUMMARY INTRODUCTION Langan Engineering & Environmental Services, Inc. (Langan), an Esri® Business Partner with an ArcGIS for Local Government and ArcGIS Online Specialty, is an international full-service engineering and environmental consulting firm. In addition to our core services of comprehensive geotechnical, site/civil and environmental engineering, our technical services extend to include Geographic Information Systems (GIS), traditional survey, mobile and stationary laser scanning, unmanned aerial survey (UAS), desktop/web/mobile application programing and Building Information Modeling (BIM). Langan was founded in 1970 and currently has over 1,200 employees spread over 33 offices, with regional offices in Seattle, Washington and Denver, Colorado. GIS SOLUTIONS FOR LOCAL GOVERNMENT Langan provides prompt on-call Geographic Information Systems (GIS) consulting services to local governments around the country to both implement and support their enterprise GIS efforts. These services include, but are not limited to, planning, design, implementation, maintenance and training of GIS to manage water, sewer and stormwater assets, track vehicle fleets and build multi-departmental datasets, as a means of providing accessibility of the information to both existing GIS and non-GIS users. Langan has extensive experience in the design and implementation of enterprise GIS at both small and large-scale for local government clients. This includes working with the staff to identify the end goal of the GIS and implement a strategy to reach these goals. The implementation of GIS can range from only a few employees to multiple departments with integrated data and applications. Our geospatial staff are trained in GIS architecture and design strategies to support development of GIS for desktop, web, and mobile use. This includes being trained by Esri® Authorized instructors on the most up-to-date software's. To complement our system architecture and design skill set, our GIS staff are also trained on database design and development. This includes adopting Esri® pre-defined database structures or developing customized schemas to meet the needs of the organization. We have extensive experience working with public works departments to create asset inventories, which includes, but is not limited to, street signs, trees/landscaping, park equipment, sidewalk assessments, and utility assets. For each of these, Langan can also offer laser scanning capabilities to precisely catalog the size, structure and location of the assets. In addition, we have developed a myriad of GIS-based mobile applications that provide custom reports to assist local government entities with regulatory reporting. Langan has also worked with several hardware vendors to provide Internet of Things (IoT) sensor data retrieval within an enterprise GIS to assist in collecting asset information. This includes vehicle tracking for government clients as a means of increasing operational and mechanical City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 3 of 23 efficiency as well as providing transparency to the public for applications such as snowplow and leaf collection activities. The tracking can include details, such as engine conditions, accessory positions (snowplow, salt spreader, etc.) and provide reports for each vehicle. Langan's Geospatial Services: • Enterprise GIS Design and Implementation • Asset and Facility Management • Mobile Data Collection Solutions • Data Interpretation, Management, Analysis, and Visualization • Process/Workflow Development and Automation • Training • Automated Figure and Report Generation • Map-Based Document Management • Spatial and Non-Spatial Data Integration • Custom GIS Development Solutions • Enterprise Systems Integration • AI / Machine Learning • Data Dashboards and Web Viewers Our Value: • Improved Data Access and Analysis • Increased Productivity • Better Insight • Reduced Risk • Enhanced Reporting • Improved Data Collection • Business Partners with Industry Leading Software Providers PROJECT UNDERSTANDING Langan is pleased to offer this proposal to provide technical support services to the City of Bozeman (City). We understand the City is looking to hire a consultant to provide a GIS data and database architecture and data maintenance health check. Langan understands the initial scope of services includes nine tasks, which consist of, but is not limited to the following: 1. Review Existing use of Enterprise Geodatabase; 2. Review Existing use of File Geodatabases; 3. Review Existing use of Hosted Data; 4. Recommendations for Improving Database Maintenance and Overall Performance; 5. Recommendations to Improve Data Management and Integrations; 6. Recommendations for New Data Models; 7. Recommendations and Best Practices for Database Type Use; 8. Review of Existing GIS Integrations and Guidance for Efficient use of FME; and, 9. Transition Plan from ArcGIS Desktop to ArcGIS Pro. Langan has completed and worked on numerous GIS projects for local municipalities and facilities that run like a municipality. Because of this, we have garnered extensive knowledge that makes Langan uniquely qualified to perform municipality related GIS services. Throughout the duration of this project, Langan will draw upon its experience with similar municipal projects to ensure all the City's requirements and expectations are exceeded. We have provided a detailed technical proposal for each of the requested tasks and select specialized project experience below. City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 4 of 23 FIRM PROFILE Throughout the project, Langan will be available to answer any questions that may arise. We've included contact information for Brett Milburn, GISP who will serve as the Project Director and Brock Saylor who will serve as the Project Manager for this project. Additional contacts for team members are available upon request. Project Director: Brett Milburn, GISP bmilburn@langan.com Phone: 610.984.8515 Project Manager: Brock Saylor bsaylor@langan.com Phone: 484.363.0720 Regional Offices: Seattle, Washington 1420 Fifth Avenue, 22nd Floor Seattle, WA 98101-4087 Phone: 206.504.3489 www.langan.com Denver, Colorado 300 Union Boulevard, Suite 405 Lakewood, CO 80228 Phone: 303.262.2000 DESCRIPTION OF PROPOSED SOLUTION Our approach to this project is provided in more detail in the sections below. Task 1 – Review Existing Use of Enterprise Geodatabase Based on our understanding, the City currently runs Microsoft SQL Server 2017, which is used both within the City's production ArcGIS Enterprise site and within the City's test ArcGIS Enterprise site. Many of our clients utilize Microsoft's SQL Server as their Relational Database Management System (RDBMS), and our team also uses Microsoft's SQL Server within our development, staging and production GIS environments. Our team has extensive experience working with Microsoft SQL Server as an Enterprise Database and have database administrators on staff, which will be essential to our team successfully completing this task. Typically, we recommend Enterprise Geodatabases for authoritative data when business requirements call for versioning, geodatabase replication, historical archiving, or multi-user editing. Versioning is a framework where multiple editors can work simultaneously on a single feature class without creating copies of the data, which provides a flexible data management framework that can meet a diverse set of demands. At present, there are two methods for versioning; Traditional and Branched Traditional versioning is intended for accessing the enterprise geodatabase directly via the database connection. However, datasets can be shared via feature services but will not have the same level of multi-user version management capabilities. Branched versioning facilitates the City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 5 of 23 web GIS model by allowing multi-user editing scenarios via a feature service. It is also required for the Utility Network (UN). Our team will review the City's current usage of Enterprise Geodatabases, architecture, and meet with IT as well as GIS stakeholders. Based on our review, we will make recommendations to migrate data to Hosted Data sources (ArcGIS Online & ArcGIS Data Store) and branched versioning based on the City’s business requirements. Task 2 – Review Existing Use of File Geodatabases Langan will evaluate the City's current File Geodatabases usage in conjunction with the City's ArcGIS Enterprise deployment. There are multiple methods that use File Geodatabases with ArcGIS Enterprise. File Geodatabases can be copied to each ArcGIS Server in an ArcGIS Enterprise site and shared as a map service or image services. This configuration minimizes network communication traffic among the different ArcGIS Server components and reduces Input/Output (I/O) contention when accessing the File Geodatabases. However, File Geodatabases are intended for read-only use with ArcGIS Server so they cannot be published as Feature Services. One of the most significant performance gains comes from using a File Geodatabase is for map caching. This method can eliminate multiple calls to the Enterprise Geodatabase that would usually occur across the network and can lighten the load on the database ultimately speeding up caching. Our team also uses File Geodatabases for working locally with data which operate an order of magnitude faster than referencing multiple shapefiles in most instances. Often this data is replicated from an Enterprise Geodatabase for performance purposes. In addition to this, we use File Geodatabases to archive data for long-term storage. Based on our experience, we recommend using File Geodatabases for caching Map Services and Image Services to display data. Map Image Services can also be published from Enterprise Geodatabases and hosted in Data Store. Data Store is the hosting server for ArcGIS Enterprise Portal. This method often aligns best with business needs for larger datasets that don't regularly update. To successfully complete this task, our team will review the City's current usage of File Geodatabases, architecture, and meet with IT and GIS stakeholders. Based on our review, we will make recommendations and outline the best practices surrounding the File Geodatabases' role in an ArcGIS Enterprise site and web GIS in the City. Task 3 – Review Existing Use of Hosted Data We understand the City is hosting data on ArcGIS Online and ArcGIS Portal in ArcGIS Data Store. There are different types of ArcGIS Data Stores; relational, tile, and spatiotemporal. Our team will evaluate the City's current usage of Hosted Data and provide recommendations to get the most out of the distributed web GIS model. However, we recommend that our clients not use ArcGIS Data Store or ArcGIS Online to host authoritative GIS data since an Enterprise Database provides the more features and flexibility. City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 6 of 23 Hosted data works well for simple data that requires editing but does not require all the Enterprise Geodatabase functionality. The hosted data is usually Feature Services or Map Image Services and have some distinct advantages over both Enterprise Geodatabases and File Geodatabases for ease of use within the web GIS model. However, we do typically host the following layers: • Feature Layers; o Feature Layer Views; • WFS Layers; • Tile Layers; • Vector Tile Layers; • WMTS Layers; • Scene Layers; and, • Elevation Layers. Our team will review the City's current usage of Enterprise Geodatabases, architecture, and meet with IT and GIS stakeholders. Based on our review, we will make recommendations on usage of Hosted Data and define its role within the Web GIS environment. Task 4 – Recommendations for Improving Database Maintenance and Overall Performance Based on our findings from Tasks 1, 2, and 3, we will provide recommendations to improve database maintenance and overall performance. For this task, we will focus on performance and reliability. During the health check, our team will review the City's data management practices to ensure that the systems fully align with business needs. This includes, but is not limited to, reviewing database backup and recovery, versioning, statistics, database version, and replication. As previously described, our team manages multiple ArcGIS Enterprise deployments that use Microsoft's SQL Server as their RDBMS. For this, we leverage scheduled tasks to perform both Esri's® recommended database maintenance and the recommended maintenance for SQL Server. We also profile databases to ensure query performance. While query performance starts at the database level, the way data is published as a web service also affects performance. Given this, our team often supplies our clients with flow charts and best practices to follow when publishing data. Task 5 – Recommendations to Improve Data Management and Integrations Data Management is imperative to a successful Enterprise GIS and is defined as how organizations collect, organize, and maintain accurate locations and details about assets and resources. It is vital to persist spatial data within storage models optimized for its unique characteristics. Storage models include the geodatabase (.gdb), spatiotemporal big data store (observation data), relational data store (hosted vector data), and tile cache (hosted raster data). Data Management represents server-side capabilities from an infrastructure perspective, exposed as web services that allow end-users to create, maintain, and transform geographic data. For example, you can use a mobile app to access a web service for data editing, allowing you to gather location data in the field. Key server-side data management capabilities include short and long transaction editing, data replication, and extract, transform, load (ETL) procedures. During this task, our team will leverage the insights gained during Tasks 1, 2, and 3 and our previous experience designing enterprise deployments as well as solutions to provide the City City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 7 of 23 with recommendations on how to improve their data management practices including, but not limited to, data stewardship, metadata standards, naming conventions, and quality control procedures. Our team will ensure the City is following the appropriate workflows when collecting new data or maintaining existing data during the health check and provide recommendations on how to improve as needed. Task 6 – Recommendations for New Data Models From our experience, the long-term success of all projects consist of setting up a standardized solution for the management of data with the GIS environment. As an Esri® Business Partner, Langan has used the industry standard Esri® Local Government Information Model (LGIM) as a base level for several of our clients. This would be an ideal starting point for the City. However, based on our experience, we anticipate that the City will benefit more from a simplified custom version of this data model. Starting with the LGIM and customizing the model will allow for the data model to be applicable to the day-to-day needs and scalable as the City expands its GIS in the future. We know that the City will most likely want to incorporate a number of custom attributes to help track the source (i.e., as-built, GPS, survey, etc.) and validation (i.e., high or low confidence) of their assets so that information can be updated over the long-term as budgets allow and projects occur. As such, we will work with the City to add these fields, along with pre-determined values in a drop-down menu so that users can only enter in approved values (i.e. surveyed, aerial photo, mapping grade GPS, unknown, etc.). To help with tracking the source and validity of the data, we recommend that the City enable editor tracking on all layers in the GIS so that certain fields will be updated automatically. By enabling editor tracking, the created date, created user, last edited date, and last edited user will all be automatically updated based on the computer clock and the current Windows account name or mobile device user if edited on a phone or tablet. Additionally, Langan will work with the City to determine opportunities to hyperlink or attach non-GIS data such as improvement drawings, CCTV inspections, photos, billing information, flow model results, and code violations, etc. to features within the GIS model so that the data can be recalled quickly via desktop GIS or a web/mobile GIS application. We understand the City is requesting recommendations for Esri’s new Utility Network (UN). From our experience, the UN is currently geared toward large utility companies with massive spatial and customer datasets. As such, we anticipate the City will benefit more from the creation of a geometric network for their GIS utility data such as sewer system, storm drain system, water system and other applicable utility networks in lieu of implementing the UN. A geometric network is a smart network in GIS that allows users to run modeling scenarios, identify upstream and downstream features, and ensure that all features are interconnected properly. Another Example Web Viewer with CCTV and photo records. City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 8 of 23 benefit to using a geometric network is the added functionality of the dynamic value table. The dynamic value table will allow the City to create custom rules that will auto-populate attributes based on other features, such as pipe slope, upstream/downstream ID, asset naming conventions, pipe length, etc. Following the review of the City’s existing data and after discussions with the City, we will be able to recommend data models that best suite the City’s current and future needs. If desired, Langan has the ability to provide utility modeling services on various GIS utility networks through programs such as InfoWater, XPSWMM, and SewerCAD. We have successfully integrated enterprise GIS databases in the past with these applications so that models can be run on the latest available information. The output from these models is then linked directly back into the GIS database and served up through interactive web viewers, map documents and static images. However, please note that a cost for the inclusion of utility modeling is not included under the proposed scope of services and that additional costs may be incurred. If not already in use by the City, we recommend utilizing the Esri Parcel Fabric for ArcGIS Pro toolset to create, maintain, and manage the City’s parcel dataset. This solution allows parcels to be interconnected to ensure that there are no gaps and that the topology of the dataset is always maintained. The Parcel Fabric toolset is also a solution for creating and managing subdivisions based on a parent parcel(s) that will be affected by the new subdivision. In addition, we recommend utilizing the Parcel Fabric Job Book and Editor Tracking throughout the parcel and subdivision development development. The Job Book and Editor Tracking keeps track of what parcel and/or subdivisions have been updated, which user made updates, when a parcel was created, and has been last updated. This data is stored in a feature table for all parcels and ensures that no parcels are updated multiple times. These tools ensure that all parcels are checked to conform to accuracy standards set forth by the City. In conjunction with the Esri Parcel Fabric toolset, we also understand the importance of an up to date and accurate address management system. If not already in use, we recommend utilizing the Address Data Management solution, which is an ArcGIS Solution provided for local government. The Address Data Management solution will assist with streamlining the City’s approach to collect, maintain, and use authoritative address information within the LGIM. It also included a series of preconfigured ArcGIS Data Reviewed checks that can be used to validate, maintain, and improve the integrity of the address data. If not already in place by Example of a Parcel Fabric. Example Data Reviewer Workflow. City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 9 of 23 the City, we recommend utilizing Esri’s® Data Reviewer, which allows for Quality Assurance and Control (QA/QC) of data directly in the enterprise database. Data Reviewer automatically detects irregularities with features, attributes, and relationships in the database and provides interactive analysis results. For example, Data Reviewer will help check and report back mismatched topology, empty geometry, and missing feature ID’s, null values, etc. The Data Reviewer table, stored in the City’s enterprise geodatabase, manages results and allows the feature(s) to be modified based on the information available in the record or further analyzed if necessary. Task 7 – Recommendations and Best Practices for Database Type Use Langan has provided both systems design and health checks to many of our local government clients. For a similar municipality, our team successfully migrated their stand-alone ArcGIS Server to a ArcGIS Enterprise Site based on the Web GIS model. After reviewing the City’s current architecture and meeting with IT and GIS stakeholders in the aforementioned tasks, our team will outline our recommended best practices for the City. In general, our recommendations around the different Geodatabases will most likely be as follows: • Enterprise Geodatabase o Versioning o Complex multiuser editing ▪ Connection File ▪ Feature Service o Some third-party integrations o Feature Datasets ▪ Geometric networks ▪ Network datasets (Requires ArcGIS Network Analyst extension) ▪ Parcel fabrics ▪ Terrains (Requires ArcGIS 3D Analyst extension) ▪ Topologies • Hosted Data o Editing ▪ Feature Service o Map Image Service • File Geodatabase o Static Data (Caching) ▪ Map Service ▪ Image Service o Feature Datasets ▪ Geometric networks ▪ Network datasets (Requires ArcGIS Network Analyst extension) Example of publishing flow chart. City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 10 of 23 ▪ Parcel fabrics ▪ Terrains (Requires ArcGIS 3D Analyst extension) ▪ Topologies Langan will provide recommendations and best practices for the best database type to use. For this task, we will also supply a functionality matrix and flow chart to help assist the City’s employees. Task 8 – Review of Existing GIS Integrations and Guidance for Efficient use of FME Langan works closely with our clients to connect many third-party systems and applications in either a one-way or two-way integration through software development kit (SDKs)/Application Programing Interface (APIs). These let our developers build custom capabilities for specific needs. At the infrastructure level, they reference objects and interfaces for your GIS servers, allowing you to extend, consume, and manage GIS services. For example, you can use ArcGIS Enterprise SDKs to add new operations to map services and extend the functionality of ArcGIS. In addition, with Esri's® other SDKs and APIs, many client and server technologies can be integrated with the ArcGIS platform. Langan understands that the City currently has several third-party integrations with their ArcGIS Enterprise Site. Our team will review the existing GIS integrations, which include, but not be limited to: • Cityworks; o GIS-centric enterprise asset management system o Has API & Developer tools o Closely integrated with ArcGIS • Navline (finance, utilities, billing, planning, etc.); • Innovyze; o InfoWater ▪ ArcGIS Pro Add-In ▪ Close integration with ArcGIS o Hydraulic modeling • Neptune; o IoT Smart Water Meter • Dropcountr o Water use tracking; • CUES GraniteNet o Wastewater/stormwater pipe inspections; o Integrates with SQL Server • Zuercher o 911; • Emergency Reporting o Fire; • Montana Department of Revenue Orion database; City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 11 of 23 • Laserfich; o Enterprise Content Management (ECM) o Has Esri® integration • LiGO Automatic Vehicle Location tracking; and, • Utility locates. During the health check, our team will meet with IT and GIS stakeholders and the departments utilizing the third-party systems to get a holistic view of how the integration is used. From this, we will provide recommendations to improve ETL and integration workflows through off-the- shelf integrations or optimization via FME, Python, or Esri® SDKs/APIs. Task 9 – Transition Plan from ArcGIS Desktop to ArcGIS Pro We understand the City is seeking a transition plan to move their data from ArcGIS Desktop (ArcMap) to ArcGIS Pro. Since the release of ArcGIS Pro, we've worked with several of our clients to convert their ArcMap projects to ArcGIS Pro. ArcGIS Pro provides several out of the box tools to consume ArcMap documents automatically, we will work with the City to evaluate existing workflows and assess the City’s current ArcMap file types, including but not limited to, style files, database connections, title blocks and layouts. Following our review of the City’s current ArcGIS Desktop assets, we will work with the City to provide a transition plan outlining the steps and processes needed to transition to ArcGIS Pro. Along with out of the box tools provided by ArcGIS Pro, we've also engaged with several of our clients to develop customized tools and Add-Ins that use the ArcGIS Pro SDK and incorporate modern .NET features. These integrations are maintainable and lead to user-friendly solutions. In addition to new tools for ArcGIS Pro, our team regularly migrates legacy ArcMap Add-Ins to ArcGIS Pro. Example customized tool ArcGIS Pro plug-in we created of our clients. City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 12 of 23 SCOPE OF PROJECT DELIVERABLE Following the full review of the City's existing database architecture, Langan will provide a detailed recommendations report in digital and/or hardcopy format as requested by the City. The report will encompass the recommendations for where transitioning from a traditional GIS to a web-based Enterprise GIS is the best practice. We will work with the City to review the City’s existing databases and provide recommendations for improved database maintenance and performance. The final deliverable will consist of the following items outlined in the tasks herein: 1. Review of existing use of Enterprise Geodatabase; 2. Review of existing use of File Geodatabases; 3. Review of existing use of Hosted Data; 4. Recommendations for improving database maintenance and overall performance; 5. Recommendations to improve data management and integrations; 6. Recommendations for migrating to new industry standard data models; 7. Recommendations and best practices for when to use a File Geodatabase, Enterprise Geodatabase, and Hosted Feature Services; 8. Review of existing GIS integrations and guidance for efficient use of FME and ETL tools; and, 9. Transition plan for ArcGIS Desktop to ArcGIS Pro. RELATED EXPERIENCE AND STATEMENT OF QUALIFICATIONS Langan has extensive experience providing GIS services for similar clients and projects. A brief description for the selected projects Langan has consulted on may be found below. Note that client letters of recommendation for projects where similar services have been performed are included in Appendix A. Additional references can be provided upon request. City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 13 of 23 South Whitehall Township – On-Call GIS Support Langan was retained by South Whitehall Township, PA (SWT) as their primary GIS consultant since 2011. Langan's activities consist of enterprise GIS architecture and design, GIS needs assessment, capacity planning, data management, enterprise system integration, training and on-call support. Initial activities included assisting the Township in specifying hardware and software to implement an enterprise-wide GIS and an extensive review of the information anticipated to populate the GIS. Langan worked with the existing IT consultant to configure ArcGIS for Server with an SQL database to allow for real-time connectivity to their data from the field. Langan developed database schemas for multiple utilities to support various activities such as geometric networks, manholesuch as geometric networks, manhole inspections, hydrant flushing, MS4 inspections, sewer camera truck integration as well as various web viewers for water, sewerLangan Management to develop an online viewer that tracks all vehicles owned by the township. The online application allows management to track vehicle location, engine diagnostics, idle time, and easily generate repots based on Management to develop an online viewer that tracks all vehicles owned by the township. The online application allows management to track vehicle location, engine diagnostics, idle time, and easily generate repots based on Management to develop an online viewer that tracks all vehicles owned by the township. The online application allows management to track vehicle location, engine diagnostics, idle time, and easily generate repots based on Management to develop an online viewer that tracks all vehicles owned by the township. The online application allows management to track vehicle location, engine diagnostics, idle time, and easily generate repots based on this information. Over the last year, we have worked with SWT to integrate Tyler Technologies, Munis with their enterprise GIS database. Munis is Tyler Technologies ERP solution for government agencies which includes financials, procurement, HR, payroll, and revenues. The integration allows multiple departments within SWT to manage work orders through Munis based on assets in GIS. We have also configured the Esri® Utility Network (UN), updated land cover analysis, and are working with SWT to establish a stormwater fee billing system that relies heavily on GIS. City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 14 of 23 Greater New Haven Water Pollution Control Authority – Database Updates, GIS Mapping, Website Development, and Enterprise Integrations In 2011, the Greater New Haven Water Pollution Control Authority (GNHWPCA), a multi-municipality water/sewer authority, retained Langan as their full-service GIS consultant for a wide array of projects. Initial activities consisted of enterprise database updates and management along with GIS data conversion and mapping to support utility upgrades and maintenance projects. Additional activities included field GPS surveying, GIS software training, creation of a geometric network consisting of over 35,000 sewer/water features, automation of attributes based on feature connectedness, creation of geometric network connectivity rules and QA/QC to verify network connectivity. Over the last year, we have successfully deployed and configured ArcGIS Portal, Portal acts as the central information source and allows for organization integration. We also migrated the geometric network to Esri's® new Utility Network, which allows for advanced modeling. Langan also implemented multiple enterprise integrations such as Granite XP for CCTV inspections and automated One Calls (Call Before You Dig) requests. One calls were automated through feature services provided to PelicanCorp. Along with enterprise integrations we have also developed advanced web viewer applications for emergency repairs that automatically notify affected customers and flow test and plan review applications for advanced modeling. City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 15 of 23 Brookfield Water Pollution Control Authority – Database Updates, GIS Mapping, Mobile App Development, and Enterprise Integrations Langan was retained by Brookfield Water Pollution Control Authority (WPCA) in 2014 to perform several GIS related tasks for them. Our initial task was to institute the use of customized Esri® data models and create a geometric network to identify flow directions and ensure that all features were topologically correct in the database. This served as the basis for performing sewer flow modeling on the network as well through SewerCAD®. This modeling aided the WPCA in determining capacity flow for their entire system. Additional activities included development of web and mobile applications to support manhole and grease trap inspections. Since the start of the project we have hosted and managed all ArcGIS solutions for the WPCA. We have digitized all paper records and hyperlinked/attached the records to an ArcGIS web viewer application for data access. Over the last year, we have integrated the GIS of pump house assets, laterals, and link connection cards with ArchiBus. ArchiBus is a data management tool for managing facility and infrastructure data and allows for both interior and exterior data to be queried simultaneously to visualize an organization's assets and streamline enterprise workflow processes. We are currently working with the WPCA to digitize their utility system laterals and link connection cards for more advanced system modeling and greater resilience. City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 16 of 23 Port Authority of New York and New jersey – Law Enforcement/Computer-Aided Dispatch Mapping and ArcGIS Hub Deployment Langan was retained by the Port Authority of New York & New Jersey Police Department since 2014 to develop mapping for their Computer- Aided Dispatch (CAD) system and customize, deploy, and manage a variety of GIS solutions including ArcGIS Hub. Langan was responsible for creating an address geodatabase covering the Port Authority's jurisdiction, which would become the backbone of a new CAD and Records Management System (RMS). The goal of the project was to enhance dispatching reliability, as well as create geo-verifiable addresses for all calls and arrests. This would enable spatial analysis of crimes to help identify crime hot spots and better deploy resources, as well as streamlining crime reporting to state and federal agencies. Once the mapping data was imported into the Superion® ONESolution CAD system, Langan fine-tuned the CAD map settings to match the needs of dispatchers and officers using the CAD software. An ArcGIS Server was also utilized to host base map layers for the CAD mapping portal to improve the performance of CAD and to improve the visual appearance of the map. Over the last year, Langan has been working with the Port Authority to successfully deploy ArcGIS Hub. City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 17 of 23 Metro-North Railroad – Development Services Langan provided development services consisting of scanning 200,000 drawings, data management, and GIS application development. The application leveraged React, Material-UI, and Esri's® ArcGIS API for JavaScript version 4.16. During development, our team used the widgets that are available off the shelf in the ArcGIS API for JavaScript. Where these didn't meet business requirements, we extended these or created custom components. For example, at this time the Feature Table widget was just released and had limited functionality so we integrated the React DevExtreme Grid. This custom web application (displayed below) enabled advanced, multi-tier filtering and querying of hundreds of thousands of features across many related datasets. The result is that Metro-North Railroad can quickly and easily find data that was previously inaccessible. REFERENCES Please see below for our list of references. Additional references are available upon request. South Whitehall Township Mr. Dave Manhardt, AICP Director GIS and Information Technology 4444 Walbert Avenue, Allentown, PA 18104 610-398-0401 manhardtd@southwhitehall.com Date of Services Provided: 2012 to Present City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 18 of 23 Services Provided: • Web and mobile application development • Needs Assessment • System architecture and design • Data and systems design, development, and management • On-Call GIS and data services • Real-time data consumption • Training and support • Third party software integrations Greater New Haven Water Pollution Control Authority Mr. Thomas Sgroi, P.E. Director of Engineering 260 East Street, New Haven, CT 065111 203.466.5185 tsgroi@gnhwpca.com Date of Services Provided: 2011 to Present Services Provided: • GIS planning (system architecture, design, and upgrades) • Needs Assessment • Web services o Custom website development o On-site training o Third-party software integrations • GIS mapping o Stormwater and sanitary utility asset mapping o Esri® Utility network creation o Database updates • Training and support Brookfield Water Pollution Control Authority Mr. Nelson Malwitz Chairman, City of Brookfield, Water Pollution Control Authority 100 Pocono Road, Brookfield, CT 068-4 203.775.7319 nelson@brookfieldwpca.com Date of Services Provided: 2014 to Present Services Provided: • Web and mobile application development • database development and mapping City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 19 of 23 • Linking of tax parcels to asset Information • Web and mobile application development • Data capture • On-call database updates and mapping • Third party software integrations • Enterprise Integrations • Training and support PRESENT AND PROJECTED WORKLOAD Langan considers this project of vital importance and will keep the staff identified in this proposal, as well as needed support staff, available to the City if needed. We manage workload scheduling and backlog through weekly staffing meetings where project needs are furcated over the next six months so that proper staff is assigned to each project. If additional staff is needed for short term periods, resources from other Langan offices can be utilized. Work for the City will have first-priority staffing throughout the duration of the project and will be impacted by staffing requirements of other projects. In the table below, we've projected the 6-month availability of the key personnel that will be dedicated to this project. KEY PERSONNEL The following section describes an overview of Langan's overall project organization and management approach to successfully provide GIS development and support services to the City. Resumes with qualifications for the individuals can be found in Appendix B. In addition, an organizational chart for the project team is provided in the section below. Langan has a wealth of technical professionals available to draw experience from that can aid in this project as needed, including our in-house IT/CADD/database/application development as referenced on the organizational chart below. Note that Langan will not be using any sub-contractors to complete this project. 10% 50% 25% 25% 30% 0%10%20%30%40%50%60%70%80%90%100% BRETT MILBURN, GISP -PROJECT DIRECTOR BROCK SAYLOR -PROJECT MANAGER TONY YATES, GISP -QA/QC AND DATA MODEL LEAD CHRIS DOUGHERTY -LEAD GIS SOLUTIONS ARCHITECT ANDREW BREEDING -GIS SOLUTIONS DEVELOPER Availability of Key Personnel City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 20 of 23 The project will be completed under the direct supervision of Brett Milburn, GISP. Mr. Milburn is a certified GIS professional with the GIS Certification Institute (GISCI) and has over nineteen years of operational enterprise GIS experience including over thirteen years of project management experience. Mr. Milburn will serve as the project director and will oversee all GIS aspects of the work to be conducted. TEAM QUALIFICATIONS Brett Milburn, GISP – Project Director Mr. Milburn has over nineteen years of experience in GIS mapping and analysis activities along with database design and management to support municipal, utility, transportation, sustainability, compliance, renewable energy, environmental, survey, litigation, natural resource, geotechnical and site/civil projects. In his current role as the leader of Langan's GIS and Data Solutions group, he serves as the director to various GIS and database related projects and is responsible for the development of this technology within the firm. Brock Saylor – Project Manager Mr. Saylor has over nine years of experience in GIS providing project management, GIS training solutions, and field mobility solutions. He will serve as the day-to-day contact for the Department and will manage the major tasks and meetings for this project. He also has a bachelor's degree in Environmental Planning with a focus in GIS and has extensive experience with data management of enterprise GIS, GPS data collection and processing, data management, local government GIS, ArcGIS online, and ArcGIS Server. In addition, he has conducted onsite trainings with various water departments and local government organizations in the past covering cartographic mapping, data management, field applications, and Quality Assurance/Quality Control (QA/QC) procedures. City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 21 of 23 Tony Yates, GISP – QA/QC and Data Model Lead Mr. Yates has over ten years of experience providing local government and utility GIS solutions. He will serve as the QA/QC lead for the project and will ensure data quality meets the required standards for this project. His area of expertise includes utility and asset management, geometric networks and utility networks, web and mobile solutions, and database design and maintenance. He currently manages several long-standing local government and utility clients. Chris Dougherty – Lead GIS Solutions Architect Mr. Dougherty has eleven years of experience in developing custom solutions in GIS. He will serve as the project's GIS solutions architect/lead GIS developer and will be responsible for designing the online cloud-based GIS and developing custom GIS applications. He has a range of expertise, from software development and application design to system architecture solutions. Software development programming languages include Python, JavaScript, HTML5, and C#/.NET. Specifically, he has applied these to Esri® development tasks such as custom ArcGIS Desktop Extensions, ArcGIS geoprocessing tools, and web mapping applications utilizing the ArcGIS API for JavaScript. Chris additionally has Systems Engineering experience, such as working with customers to determine project requirements and scope. He also has expertise in server maintenance and configuration (Windows Server, Linux), web servers (IIS, Apache, NGINX), and databases (MSSQL, PostgreSQL). System architecture design ties these skills together, delivering customers a comprehensive solution by integrating web technologies, server configuration, COTS software, and custom software development. Andrew Breeding – GIS Solutions Developer Mr. Breeding has experience in the full software development lifecycle – from design through delivery of state-of-the-art systems and applications. His technical toolset includes Python, JavaScript, React, C#, .Net, PostgreSQL, Microsoft SQL Server, and IIS. He is focused on developing and extending Esri® software (ArcGIS Enterprise, ArcGIS Pro, ArcGIS Online) through the ArcGIS for Developers platform. This includes creating add-ins, web applications, and mobile applications. Andrew has an in-depth knowledge of RESTful web services, database design, and enterprise server design, configuration, and maintenance following Esri® best practices. City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 22 of 23 PRICE PROPOSAL Our estimated fee proposal provided as a lump sum by task item is provided below. Note that we recommend reevaluating these costs after discussions with the City as a means of potentially reducing the overall project costs. These costs have been prepared based on our understanding of the project and past experiences on similar projects. Please note the estimated fee schedule is based on a blended rate and the estimated fee does not include costs associated with software or hardware purchases. Task Estimated Fee Task 1 – Review Existing use of Enterprise Geodatabase $4,000 Task 2 – Review Existing use of File Geodatabases $4,000 Task 3 – Review Existing use of Hosted Data $4,000 Task 4 – Recommendations for Improving Database Maintenance and Overall Performance $4,000 Task 5 – Recommendations to Improve Data Management and Integrations $4,000 Task 6 – Recommendations for New Data Models $4,000 Task 7 – Recommendations and Best Practices for Database Type Use $4,000 Task 8 – Review of Existing GIS Integrations and Guidance for Efficient use of FME $4,000 Task 9 – Transition Plan from ArcGIS Desktop to ArcGIS Pro $3,000 Total Project Costs $35,000 The table below is a summary of the proposed project billing rates by classification. For the purposes of this proposal, we assume that most of the work will be completed at a Langan Office and not in person at City's facilities. This will enhance client service and minimize potential impacts to the budget. Project Personnel Hourly Rate Project Director $205 Project Manager and QA/QC Lead $185 Lead Solutions Architect/Developer $180 Senior GIS Solutions Developer $160 GIS Analyst (Hourly Rate) $120 Administrative $60 City of Bozeman, MT GIS Data and Database Architecture and Data Maintenance Health Check January 15, 2021 Page 23 of 23 CLOSING Langan appreciates this opportunity to submit our proposal for GIS technical support services for the City of Bozeman. We are confident that if selected, we will exceed the City's expectations. We have a proven track record with projects of similar scope and have provided our clients with optimized enterprise GIS environments as well as up to 30% savings in operating costs through GIS implementations and solutions. If you have any questions or should you require additional information regarding the contents of this proposal, please do not hesitate to contact us. “Langan consultants have made significant contributions to our GIS program thanks to their experience and very strong technical and business backgrounds. - Tom Sgroi, Greater New Haven Water Pollution Control Authority TOCTOC Table of Contents: A. Project Experience B. Team Resumes C. Revisions to Proposed Contract D. Certificate of Liability Insurance E. Nondiscrimination and Equal Pay Affirmation A Project Experience Langan utilizes the latest software and data management applications to design, collect, manage, analyze, and present mass quantities of spatial and non-spatial data. Our team provides easy-to- use solutions to address our clients’ challenges through enriched workflows and data insight, while controlling costs, enhancing the quality of our deliverables, and increasing overall project efficiencies. GIS/Data Solutions Services: Technical Excellence • Practical Experience • Client Responsiveness www.langan.com • GIS Mapping and Analysis • Field Data Collection / Real-Time Mapping • Data Dashboards and Web Viewers • Map-Based Document Management • Data Interpretation, Management and Analysis • Process/Workflow Development • Spatial and Non-Spatial Data Integration • Data Visualization • Historical Data Acquisition • Enterprise Software Integration • Custom Solutions • Site Analysis • Litigation Support • Asset Management GEOGRAPHICINFORMATION SYSTEMS (GIS) New Jersey • New York • Connecticut • Pennsylvania • Virginia • Ohio Florida • Texas • Arizona • California • Colorado • Massachusetts • Washington Contact: Brett Milburn, GISP Director of Applied Technologies/VP 215.491.6555 | bmilburn@langan.com Our Value Development Services: • Improved Data Access and Analysis • Increased Productivity • Better Insight • Reduced Risk • Enhanced Reporting • Improved Data Collection • Business Partners with Industry Software Providers • Web & Mobile Application Development • Process Automation • Automated Figure & Report Generation • IoT / Real-Time Data Capture & Reporting • AI / Machine Learning • Enterprise Systems Integration • System Architecture Design & Implementation • Custom Tools • Data Extract, Transform & Load (ETL) Services • Interactive Data Exploration • Custom Viewers & Websites Langan takes a holistic approach to geospatial software development, maintenance, and support. From desktop, web, and mobile applications to enterprise and technical support, our team provides the expertise and tools necessary to answer all of today’s most challenging geographic questions. Our established development methodologies and project management practices significantly reduce risk, increase efficiencies, and ensure a collaborative environment throughout the complete development process, maintaining schedule and adhering to budget. Furthermore, we understand that software development is fluid, and requirements can, and often do change over time. To account for this, our solutions team employs agile development methods, focusing on testing, version control, continuous integration and automated deployment. When customization is required, we use a combination of commercial off-the-shelf (COTS) and custom DevOps tools and processes. These all come together to allow us to efficiently tackle any type of project – whether it is web, desktop, mobile or any other platform. For web development, our team leverages modern JavaScript frameworks and libraries. We develop new projects using ES2015/ES6, ReactJS, the ArcGIS JavaScript API 4.x and Babel/Webpack to support legacy browsers (IE11). Prior to the onset of any project, we will determine which languages/ frameworks are most appropriate for the project. GEOSPATIAL SOLUTIONS Technical Excellence • Practical Experience • Client Responsiveness www.langan.com New Jersey • New York • Connecticut • Pennsylvania • Virginia • Ohio Florida • Texas • Arizona • California • Colorado • Massachusetts • Washington Contact: Brett Milburn, GISP Director of Applied Technologies/VP 215.491.6555 | bmilburn@langan.com geospatial solutions When custom tools are required, we have the ability to use a wide range of languages and libraries for automation and backend server development, highly dependent on the requirements of the project. Our most common uses are: • Map/process automation using Python (ArcPy, ArcGIS for Python API, NumPy, Pandas) • Custom desktop Add-Ins for ArcGIS Desktop/ArcGIS Pro (ArcGIS Pro SDK, ArcObjects) • Web APIs (C# .NET) In addition to the latest languages and libraries, we also employ a variety of DevOps tooling for streamlined project management. All project code is checked-in to Git, an industry-standard Distributed Version Control System (DVCS). Specifically, the repositories are managed by Azure DevOps. DevOps provides us with centralized repository management, issue tracking, Continuous Integration (CI) pipelines, and automated deployments. Our CI scripts run a suite of tests before accepting new code, and allow fine-grained control over our development, staging and production environments. Additional utilities such as Docker enable us to do rapid prototyping via containerization. SOUTH WHITEHALL TOWNSHIP – ON-CALL GIS SUPPORT SERVICES: • Stormwater Billing • Data / Systems Integration • Data Conversion • Database Development and Management • System Architecture and Design • Web and Mobile App Development • BMP Management • On-Call GIS/Data Services • Real-Time Data Consumption LOCATION: South Whitehall Township, PA CLIENT: South Whitehall Township Authority, Department of Public Works PROJECT DATES: 5/2012-Ongoing REFERENCE: Mr. Dave Manhardt, AICP Director GIS and Information Technology 4444 Walbert Avenue, Allentown, PA 18104 610-398-0401 manhardtd@southwhitehall.com Langan was retained by the South Whitehall Township, PA as their primary Geographic Information Systems (GIS) consultant. Langan’s activities consisted of GIS system architecture and design, capacity planning, data management and training. Initial activities included assisting the Township in specifying hardware and software to implement an enterprise-wide GIS and an extensive review of the information anticipated to populate the GIS. Langan worked with the existing IT consultant and Langan IT personnel to configure a centralized enterprise database based on SQL Server to allow for real-time connectivity to their data from the field. Langan customized several Esri® data models for asset management at the Township to be populated from previous hard copy as-built drawings. These included the digitization of water, sewer, and stormwater networks and the creation of geometric networks from Aeach of these features. This allowed the township to perform regular analysis of the network and to identify potential problem areas in Township. In addition, to support their stormwater efforts, Langan developed procedures and workflows to calculate impervious coverages across the Township and tied these calculations to their tax parcel data. Upon completion of the build out of the Township’s utility assets within GIS, Langan integrated their enterprise GIS with third party software packages including customer billing software. To assist Township staff with access to data, Langan developed several custom web and mobile applications which provide the ability to interact with their enterprise databases in real-time. This includes a MS4 inspection application with reporting, hydrant flushing application as well as several other applications for performing calculations on the fly for regulatory reporting. In addition, Langan created a seasonal work tracking application to provide Township residents with the ability to view data within their GIS database from data collected using GPS and Internet of Things sensors. Throughout the contract, Langan has been providing on-call GIS/IT support for the Township and conducted numerous training courses to ensure office staff are able to properly manage their assets. GREATER NEW HAVEN WATER POLLUTION CONTROL AUTHORITY- DATABASE UPDATES, GIS MAPPING, WEB SITE DEVELOPMENT SERVICES: GIS Planning: • System Architecture & Design • System Upgrades Web Services: • Javascript Website Creation • Custom Web & Mobile Programming • On-Site Training • Third Party Software Integration GIS Mapping: • Stormwater and Sanitary Utility Asset Mapping • Geometric Network Creation • On-site Scanning • Data Capture • Feature Class Database Design • Database Updates LOCATION: New Haven, Connecticut CLIENT: Greater New Haven Water Pollution Control Authority (GNHWPCA) PROJECT DATES: 2011 – Present REFERENCE: Mr. Thomas Sgroi, P.E. Director of Engineering 260 East Street New Haven, CT 06511 203.466.5185 In 2011, the Greater New Haven Water Pollution Control Authority (GNHWPCA), a multi-municipality water/sewer authority, retained Langan as their Geographic Information Systems (GIS) consultant for a wide array of projects. Initial activities consisted of enterprise database updates and management along with GIS data conversion and mapping to support utility upgrades and maintenance projects. Additional activities included field GPS surveying, GIS software training, creation of a geometric network consisting of over 35,000 sewer/water features, automation of attributes based on feature connectedness, creation of geometric network connectivity rules and QA/QC to verify network connectivity. Langan has worked with GNHWPCA to help design their system architecture for both their on-premises Enterprise GIS and their cloud-based ArcGIS Online environments. We have developed their system so that data and applications can be accessed via the cloud interface while still taking advantage of the full enterprise solutions on their network. Langan has supported GNHWPCA with their stormwater management by maintaining the records of all stormwater assets across multiple municipalities that they are responsible for. This has included documenting all the locations of assets, and also developing mobile applications to perform routine inspections on these assets. Over the years, Langan has developed several real-time web/mobile-based field inspection forms tied directly to their GIS to enhance field-to-office operations. Langan has also been the lead consultant for GIS planning and administration as well as architect for relating the Authority’s GIS to other related enterprise systems to enhance overall business operation processes and analytics of data. This includes their 811 call before you dig system, capital planning program and their billings department. Langan continues to provide GIS and web services to the GNHWPCA. BROOKFIELD WATER POLLUTION CONTROL AUTHORITY- DATABASE UPDATES, GIS MAPPING, MOBILE APP DEVELOPMENT SERVICES: GIS Mapping: • Stormwater and Sanitary Sewer Database Development and Mapping • Linking of Tax Parcels to Related Utility Asset Information • Web and Mobile Application Development • Data Capture • On-call Database Updates and Mapping • Enterprise Integrations LOCATION: Brookfield, Connecticut CLIENT: Brookfield Water Pollution Control Authority PROJECT DATES: 2014 – Present REFERENCE: Mr. Nelson Malwitz Chairman 100 Pocono Road Brookfield, CT 06804 203.775.7319 Langan was retained by Brookfield Water Pollution Control Authority (WPCA) in 2014 to perform several GIS related tasks for them. Our initial task was to institute the use of customized Esri® data models and create a geometric network to identify flow directions and ensure that all features were topologically correct in the database. This served as the basis for performing sewer flow modeling on the network as well through SewerCAD®. This modeling aided the WPCA in determining capacity flow for their entire system. Additional activities included development of web and mobile applications to support manhole and grease trap inspections. Since the start of the project we have hosted and managed all ArcGIS solutions for the WPCA. We have digitized all paper records and hyperlinked/attached the records to an ArcGIS web viewer application for data access. Over the last year, we have integrated the GIS of pump house assets, laterals, and link connection cards with ArchiBus. ArchiBus is a data management tool for managing facility and infrastructure data and allows for both interior and exterior data to be queried simultaneously to visualize an organization’s assets and streamline enterprise workflow processes. We are currently working with the WPCA to digitize their utility system laterals and link connection cards for more advanced system modeling and greater resilience. MAPPING SERVICES FOR STORM & SANITARY SYSTEMS, TOWN OF STRATFORD SERVICES: • GIS Utility Mapping: − On-Site Scanning − Data Capture − Feature Class Database Design • Web Services: − Secured Website − Custom Web Programming LOCATION: Stratford, Connecticut CLIENT: Town of Stratford COMPLETION DATES: Month Year (Langan work) COST: $69,000 (Langan fee) REFERENCE: John Casey, PE Engineer Town of Stratford Phone: 203.385.4013 Langan is working with the Town of Stratford to design, implement, and manage Esri® GIS software solutions for mapping and maintaining sanitary and storm utility networks. Currently, Langan is creating, populating and managing the utility information from paper as-builts and field survey data within Esri’s database and mapping environments. As part of this project, Langan is georeferencing paper sanitary and stormwater network plans into a digital format, and then hyperlinking these documents to an existing GIS database of these utility networks for the Town. This work includes an estimated 2,485 record plans detailing the stormwater system in the existing GIS database. The hyperlink provides the ability for Town personnel to retrieve the paper copies on web, mobile and desktop devices when needed. As part of this project, outfall data will be converted from its current digital or handwritten format into GIS data with attributes in a designed database schema. Langan will work with the Town to identify additional information that can be populated from the associated plans to account for any future information the Town may be interested in documenting for their pump stations. In addition, the use of mobile apps to support inspection of stormwater assets as well as regulatory reporting is being evaluated and planned. Throughout the project, Langan will provide on-site training, technical support, and maintenance to the Town. BOARD OF COMMISSIONERS Christina Tori Morgan,President Glenn Block,Vice President Dale W.Daubert Thomas J.Johns David L.Bond January 14,2016 To Whom It May Concern, Langan Engineering &Environmental Services was selected to be our on-call GISconsultant in 2012.The staff at Langan has made significant contributions to the South Whitehall Township GIS program.They have provided short notice training as well as superior technical knowledge when it comes to troubleshooting and understanding the needs of the Township.Langan has the expertise to guide us through vendors when searching for certain ways to implement an idea or has developed programs to address our needs. Additionally,Langan has been instrumental in setting up our Lehigh intern program as well as the training and quality control of the interns involving all aspects of the GIStasks through the entire process. Our project manager is Brett Milburn who always has an answer for us or will get us an answer in a timely manner.Brett is always available and is always ready to go above and beyond whenever we need him.Brett is always looking out for us and our concerns and is a pleasure to deal with. We would highly recommend Langan to anyone starting up a GIS department or to anyone with an existing GIS department that needs fresh ideas to expand into the future. Sincerely, S0JJ:J7!l2 Gerald Charv~ Utilities Group Leader 4444 Walbert Avenue •Allentown,Pennsylvania 18104-1699 Administration (610)398-0401 •Administration FAX (610)398-1068 Police (610)398-0337 •Police FAX (610)391-9471 Public Works (610)398-0407 •Public Works FAX (610)398-6898 www.southwhitehall.com B Team Resumes Mr. Milburn has over 19 years of experience in successfully providing technology-based solutions to address the technical, regulatory and business challenges in the Architecture, Engineering and Construction (AEC) industry. As the leader of Langan’s Applied Technologies Group, he oversees various Geospatial/Geographic Information Systems (GIS), enterprise data management and web/mobile technology related projects across a wide array of business sectors, which includes utility asset management, municipal/public works, energy, environmental remediation/modeling and site/civil design. He leads a diverse team of analysts, solution architects, programmers and engineers whose work has resulted in achieving enhanced efficiencies (up to 80%) and quality of information through the various stages of field data collection, quality assurance/quality control review, management of big data, along with the analysis, visualization and reporting of client data. He is experienced in multiple aspects of: - Enterprise System Architecture Design and Implementation; - Needs Assessments / Gap Analyses; - Process Workflow Design & Development; - Application Development (desktop, web and mobile); - Database Design & Development; - Software Integration; - Cloud and SaaS Offerings; - Internet of Things (IoT) Business Application Relationships; - BIM; - 3D Modeling; - Data Acquisition (GPS, RTK, LiDAR, Photogrammetry); and, - Data Conversion and ETL Processes. Over his career he has amassed extensive experience in the use of Esri products including ArcGIS Desktop and associated extensions, ArcGIS Online, Business Analyst, CityEngine, ArcGIS Server and ArcSDE/Enterprise Geodatabases based on Microsoft’s SQL platform. He is also fluent in the use of Earthsoft’s EQuIS data management software in conjunction with other third-party packages to achieve business and project objectives. SELECTED PROJECTS • South Whitehall Township, Allentown, PA • Metro-North Railroad, New York, NY • San Francisco Public Utility (SFPUC), San Francisco, CA • Clean Power Alliance, Los Angeles, CA • Greater New Haven Water Pollution Control Authority, New Haven, CT • Brookfield Water Pollution Control Authority, Brookfield, CT • Town of Avon, Avon, CT BRETT MILBURN, GISP DIRECTOR OF APPLIED TECHNOLOGIES/VICE PRESIDENT PROJECT ROLE: PROJECT DIRECTOR EDUCATION B.S., Geo-Environmental Science Shippensburg University CERTIFICATION AND TRAINING Certified GIS Professional (GISP) Esri System Architecture Design Strategies Esri Working with Geometric Networks for Utilities ArcView GIS 10.x ArcGIS Server Administration EQuIS 7x and Enterprise Rockworks 16 40-Hour Health and Safety Training for Hazardous Waste Operations Transportation Worker Identification Credential (TWIC) BRETT MILBURN, VICE PRESIDENT • NBC/Universal – Burbank, CA • Penn State Hershey Medical Center, Hershey, PA • University of Miami, Miami, FL • Yale University, New Haven, CT • Lehigh University, Bethlehem, PA • Carnegie Mellon University, Pittsburgh, PA • NGL Energy Partners, LP • Hess Corporation, Schenectady, NY • Shell, Santa Barbara, CA • Valero Refining Company, Paulsboro, NJ • Sunoco, Philadelphia, PA • Philadelphia Energy Solutions, Philadelphia, PA • Markwest Energy Partners, Pittsburgh, PA • Williams Companies, Harrison County, OH • EQT Corporation, Pittsburgh, PA • Picatinny Arsenal, Wharton, NJ • Air Products and Chemicals, Edison, NJ • Mannington Mills, Mannington, NJ • Government of Bermuda, Sandys, Bermuda • U.S. Steel Corporation, Fairless Hills, PA • Latrobe Steel, Latrobe, PA • Heritage Conservancy, Doylestown, PA • Wildlands Conservancy, Allentown, PA • Rockefeller Development Group, Various Locations • Colliers International, Harrisburg, PA • Beazer East, Newport, DE • Texas Instrument, Santa Clara, CA • Hunters Point Naval Shipyard, San Francisco, CA • Fashion Outlets of Niagara Falls, Niagara, NY • Former Pennick Corporation, Montville, NJ • Triple Five – American Dream, East Rutherford, NJ SELECTED PUBLICATIONS, REPORTS, AND PRESENTATIONS “Integrating an Enterprise GIS With Third Party Applications to Enhance Municipal Operations”, Brett Milburn and Tony Yates; South Florida GIS Expo, West Palm Beach, FL; August 2019. Mobile Data Collection Applications – A Case Story”, Brett Milburn and Tony Yates; Esri Engineering Summit, San Diego, CA; July 2018. “Utilizing GIS and Data Management for Enhancing GNHWPCA Operations”; Brett Milburn and Ricardo Ceballos; Connecticut Association of Water Pollution Control Authorities; Plantsville, CT; May 2018. “Utilizing GIS and EQuIS to Ehance Operational Efficiency”; Brett Milburn and Raymond Lees; 2017 PA Water Environment Association (PWEA) Conference; Pocono Manor, PA; June 2017. 8-hour HAZWOPER Refresher National Safety Council Standard CPR and First Aid AFFILIATIONS Greater Philadelphia Energy Action Team (Infrastructure Co-Chair) Esri Mid-Atlantic Users Group (Former Vice President) AAG-Esri ConnectED Geomentor New Jersey Department of Environmental Protection (NJDEP) Remedial Priority System (RPS) HAZSITE Team member Urban and Regional Information Systems Association (URISA) since 2004 URISA (member) New Jersey Geographic Information Network (member) PA Magic (member) Mr. Saylor has over nine years of experince in GIS providing project management, GIS training solutions and field mobility solutions. He has a bachelor’s degree in Environmental Planning with a focus in GIS and has extensive experience with data management of enterprise GIS, GPS data collection and processing, data management, local government GIS, ArcGIS online and ArcGIS Server. In addition, he has conducted onsite trainings with various local government organizations covering cartographic mapping, data management, field applications, and Quality Assurance/Quality Control (QA/QC) procedures. Mr. Saylor has effectively managed enterprise GIS databases and applications to facilitate large-scale projects by analyzing all input data to create project-specific data models. In addition, Mr. Saylor has effecively prepared environmental impact studies, GIS based environmental risk assessments, network analysis of water/sanitary sewer networks, and view shed analysis. He has managed and performed spatial analysis using GIS for watershed, groundwater, and flood/tidal inundation modeling. SELECTED PROJECTS • San Francisco Public Utility (SFPUC), San Francisco, CA • Clean Power Alliance, Los Angeles, CA • Los Angeles River Storm Drain Inspections, Los Angeles, CA • Los Angeles Community College District, Los Angeles, CA • NBC/Universal, Burbank, CA • South Whitehall Township GIS, Allentown, PA • Utility Infrastructure Improvements, Los Angeles, CA • Chase Center, San Francisco, CA • Treasure Island Redevelopment, San Francisco, CA • Four Seasons, Calistoga, CA • UC Merced Expansion, Merced, CA • Alameda Point, Alameda, CA • Hunters Point Redevelopment San Francisco, CA • Treasure Island, San Francisco, CA • City of Lodi Public Works, Lodi, CA • City of Modesto, Water Resources, Modesto, CA • Sutter Hospital Neighborhood Redevelopment, Sacramento, CA • Golden State Warriors Arena, San Francisco, CA • City Place Redevelopment, Santa Clara, CA • Tesoro Amorco Terminal, Martinez, CA • Project Graphite, Dublin, CA • Century Center, Modesto, CA • Cherry Valley Sports Center, Cherry Valley, CA • Roseville Senior Housing Project, Roseville, CA • Agua Mansa Commerce Park, Riverside, CA • Fair Oaks Business Park, Sunnyvale, CA • Gateway of Pacific, San Francisco, CA • Oyster Points Redevelopment, South San Francisco, CA • California Resources Corporation, Bakersfield, CA BROCK J. SAYLOR GIS MANAGER PROJECT ROLE: PROJECT MANAGER EDUCATION B.A., Geography and Environmental Planning, with a focus in GIS Bloomsburg University of Pennsylvania SOFTWARE TRAINING Esri® ArcGIS 10.x Suite Esri® ArcGIS Pro Esri® ArcGIS Online Esri® Collector Esri® Survey123 Trimble Terrasync Suite AutoCAD Civil 3D Aquaveo’s ArcHydro AFFILIATIONS Urban Land Institute (ULI) California Water Environment Association (CWEA) Young Professionals in Energy Water Environment Federation (WEF) Mr. Yates has over 11 years of experience in Geographic Information Systems (GIS) and is proficient in Esri’s® ArcGIS 10.x suite of products. He also has extensive experience with AutoCAD®, Terramodel®, and Microstation® and the interoperability of these packages with GIS. His area of expertise includes utility networks, 3-D modeling, web-based mapping, mobile field collection, geodatabase design, along with georeferencing / digitizing raster and vector data within GIS and AutoCAD. SELECTED PROJECTS • San Francisco Public Utility (SFPUC), San Francisco, CA • Clean Power Alliance, Los Angeles, CA • Greater New Haven Water Pollution Control Authority, New Haven, CT • Brookfield Water Pollution Control Authority, Brookfield, CT • Penn State Hershey Medical Center, Hershey, PA • South Whitehall Township GIS, Allentown, PA • Utility Infrastructure Improvements, Los Angeles, CA • Yale University, New Haven, CT • Town of Avon, CT • Air Products and Chemicals, Various Locations • Brodson, Montville, NJ • NBC/Universal – Burbank, CA • Former APCI Facility, Wharton, NJ • General Remediation Support Services, Paulsboro, NJ • Heritage Conservancy GIS Services, Doylestown, PA • Hershey Downtown Act II, Hershey, PA • Highline 131410 Hotel/Office/Retail Site, New York, NY • HR+A/LGA Support Zone Study, Corona, NY • Jersey Central Power and Light, NJ • Mannington Mills, Mannington, NJ • Mobile LiDAR Data Collection and Mapping, Long Island City, NY • Morgans Point – Bermuda, Southhampton, Intl • Morris Canal Greenway, Belvidere, NJ • PCE Remediation, Vineland, NJ • Penny Plate Inc.- Remedial Investigation, Berlin Township, NJ • Prior Coated Metals Facility, Allentown, PA • Regional Groundwater Study, Haddon Township, NJ • Remediation Data Evaluation & Reporting, Paulsboro, NJ • RIR Support and Regulatory Support Svcs, Petrolia, PA • Roche Molecular Systems, Belleville, NJ • TFS Basement / Work Plan Implementation, Fairless Hills, PA • USS Phase 1 Confirmatory PCB Sampling, Fairless Hills, PA • Vapor Intrusion Investigation, Paulsboro, NJ • Verizon - Ewing, NJ • Wildwood Former MGP Site, Wildwood, NJ EDUCATION B.S., Geography - GIS Pennsylvania State University CERTIFICATION Certified GIS Professional (GISP) AFFILIATIONS American Water Works Association (AWWA) Campus Facilities Management Technology Association (CFTA) TONY YATES, GISP SENIOR GIS MANAGER PROJECT ROLE: QA/QC and DATA MODEL LEAD Mr. Dougherty has over 11 years of experience in developing custom solutions in Geographic Information Systems (GIS). He has a range of expertise, from software development and application design to system architecture solutions. Software development programming languages include Python, JavaScript, HTML5, and C#/.NET. Specifically, he has applied these to Esri development tasks such as custom ArcGIS Desktop Extensions, ArcGIS Geoprocessing tools, and web mapping applications utilizing the ArcGIS API for JavaScript. Mr. Dougherty additionally has Systems Engineering experience, such as working with customers to determine project requirements and scope. He also has expertise in server maintenance and configuration (Windows Server, Linux), web servers (IIS, Apache, NGINX), and databases (MSSQL, PostgreSQL). System architecture design ties these skills together, delivering customers a comprehensive solution by integrating web technologies, server configuration, COTS software, and custom software development. SELECTED PROJECTS • San Francisco Public Utility (SFPUC), San Francisco, CA • Clean Power Alliance, Los Angeles, CA • NBC Universal, Burbank, CA • Alan M. Voorhees Transportation Center, New Brunswick, NJ • BAE Systems, San Diego, CA • Brookfield Water Pollution Control Authority, Brookfield, CT • Center for Remote Sensing and Spatial Analysis, New Brunswick, NJ • Greater New Haven Water Pollution Control Authority, New Haven, CT • Metro-North Railroad, New York, NY • National Center for Neighborhood and Brownfields Redevelopment, New Brunswick, NJ • Philadelphia Energy Solutions, Philadelphia, PA • Picatinny Arsenal, Wharton, NJ • Seritage Properties, New Haven, CT • Signature Information Solutions, Trenton, NJ • South Whitehall Township, Allentown, PA • Confidential Client, Burbank, CA CHRIS DOUGHERTY SENIOR GIS SOLUTIONS ARCHITECT/LEAD GIS DEVELOPER PROJECT ROLE: LEAD GIS SOLUTIONS ARCHITECT EDUCATION B.S., Environmental Planning & Design, Environmental Geomatics Concentration Rutgers University M.B. & M.S.,Geospatial Information Systems Rutgers University AFFILIATIONS National Professional Science Master’s Association Mr. Breeding has experience in the full software development lifecycle – from design through delivery of state-of-the-art systems and applications. He is a practitioner of agile and is an expert in advanced development methodologies, tools, and processes. His technical toolset includes Python, JavaScript, React, C#, .Net, PostgreSQL, Microsoft SQL Server, and IIS. He is focused on developing and extending Esri software (ArcGIS Enterprise, ArcGIS Pro, ArcGIS Online) through the ArcGIS for Developers platform (ArcGIS API for JavaScript and ArcGIS Runtime SDK). This includes creating add-ins, web applications, and mobile applications. Andrew has an in-depth knowledge of RESTful web services, database design, and enterprise server design, configuration, and maintenance following Esri best practices. SELECTED PROJECTS • San Francisco Public Utility (SFPUC), San Francisco, CA • Clean Power Alliance, Los Angeles, CA • NBC Universal, Burbank, CA • Brookfield Water Pollution Control Authority, Brookfield, CT • Greater New Haven Water Pollution Control Authority, New Haven, CT • Norristown US EPA Brownfields, Norristown, PA • South Whitehall Township, Allentown, PA • BAE Systems, San Diego, CA • Yale University, CT ANDREW BREEDING SENIOR GIS SOLUITIONS DEVELOPER PROJECT ROLE: GIS SOLUTIONS DEVELOPER EDUCATION Graduate Certificate, GIS University of Denver B.A., Geography Emory & Henry College AFFILIATIONS Urban and Regional Information Systems Association C Revisions to Proposed Contract Professional Services Agreement for The City of Bozeman GIS Data & Database Architecture and Data Maintenance Health Check FY 2021 Page 1 of 12 Appendix C – Revisions to Proposed Contract The following contains a red lined version of Langan’s amendments to the proposed contract. Note that these changes are suggestions only and are open for discussion as well as negotiations should we be awarded the contract. PROFESSIONAL SERVICES AGREEMENT THIS AGREEMENT is made and entered into this day of , 202 (“Effective Date”), by and between the CITY OF BOZEMAN, MONTANA, a self-governing municipal corporation organized and existing under its Charter and the laws of the State of Montana, 121 North Rouse Street, Bozeman, Montana, with a mailing address of PO Box 1230, Bozeman, MT 59771, hereinafter referred to as “City,” and, , _ , hereinafter referred to as “Contractor.” The City and Contractor may be referred to individually as “Party” and collectively as “Parties.” In consideration of the mutual covenants and agreements herein contained, the receipt and sufficiency whereof being hereby acknowledged, the parties hereto agree as follows: 1. Purpose: City agrees to enter this Agreement with Contractor to perform for City services described in the Scope of Services attached hereto as Exhibit A and by this reference made a part hereof. 2. Effective Date: This Agreement is effective upon the date of its execution 3. Scope of Services: Contractor will perform the work and provide the services in accordance with the requirements of the Scope of Services (Exhibit A). For conflicts between this Agreement and the Scope of Services, unless specifically provided otherwise, the Agreement governs. 4. Payment: City agrees to pay Contractor the amount specified in the Scope of Services (Exhibit A). Any alteration or deviation from the described services that involves additional costs Professional Services Agreement for The City of Bozeman GIS Data & Database Architecture and Data Maintenance Health Check FY 2021 Page 2 of 12 above the Agreement amount will be performed by Contractor after written request by the City, and will become an additional charge over and above the amount listed in the Scope of Services. The City must agree in writing upon any additional charges. 5. Contractor’s Representations: To induce City to enter into this Agreement, Contractor makes the following representations: a. Contractor has familiarized itself with the nature and extent of this Agreement, theScope of Services, and with all local conditions without intrusive or subsurface investigation and federal, state and local laws, ordinances, rules, and regulations that in any manner may affect cost, progress or performance of the Scope of Services. b. Contractor represents to City that it has the experience and ability to perform the services required by this Agreement; that it will perform the services in a professional, competent and timely manner and with the diligence and skill ordinarily provided by firms practicing in the same or similar locality under the same or similar circumstances (the “Standard of Care”); that it has the power to enter into and perform this Agreement and grant the rights granted in it; and that its performance of this Agreement shall not infringe upon or violate the rights of any third party, whether rights of copyright, trademark, privacy, publicity, libel, slander or any other rights of any nature whatsoever, or violate any federal, state and municipal laws. The City will not determine or exercise control as to general procedures or formats necessary to have these services meet this representation. 6. Independent Contractor Status/Labor Relations: The parties agree that Contractor is an independent contractor for purposes of this Agreement and is not to be considered an employee of the City for any purpose. Contractor is not subject to the terms and provisions of the City’s personnel policies handbook and may not be considered a City employee for workers’ compensation or any other purpose. Contractor is not authorized to represent the City or otherwise bind the City in any dealings between Contractor and any third parties. Contractor shall comply with the applicable requirements of the Workers’ Compensation Act, Title 39, Chapter 71, Montana Code Annotated (MCA), and the Occupational Disease Act of Montana, Title 39, Chapter 71, MCA. Contractor shall maintain workers’ compensation coverage for all members and employees of Contractor’s business, except for those members who are exempted by law. Contractor shall furnish the City with copies showing one of the following: (1) a binder an accord for workers’ compensation coverage by an insurer licensed and authorized to provide workers’ compensation insurance in the State of Montana; or (2) proof of exemption from workers’ compensation granted by law for independent contractors. Professional Services Agreement for The City of Bozeman GIS Data & Database Architecture and Data Maintenance Health Check FY 2021 Page 3 of 12 In the event that, during the term of this Agreement, any labor problems or disputes of any type arise or materialize which in turn cause any services to cease for any period of time, Contractor specifically agrees to take immediate steps, at its own expense and without expectation of reimbursement from City, to alleviate or resolve all such labor problems or disputes. The specific steps Contractor shall take shall be left to the discretion of Contractor; provided, however, that Contractor shall bear all costs of any related legal action. Contractor shall provide immediate relief to the City so as to permit the services to continue at no additional cost to City. Contractor shall indemnify, defend, and hold the City harmless from any and all third party claims and demands and the costs, expenses, damages, and liabilities resulting from such claims and demands to the extent caused by any labor problems or disputes or any delays or stoppages of work associated with such problems or disputes. 7. Indemnity/Waiver of Claims/Insurance: For other than professional services rendered, to the fullest extent permitted by law, Contractor agrees to defend (to the extent such defense is covered by general liability insurance required by this Agreement), indemnify, and hold harmless the City, its employees and officers (collectively referred to for purposes of this Section as the City) from and against any and all third party claims, demands and actions (“Claims”) and the fees and costs (including reasonable attorney’s fees and the costs and fees of expert witness and consultants), losses, expenses, liabilities (including liability where activity is inherently or intrinsically dangerous) or damages of whatever kind or nature connected therewith resulting from such Claims and without limit and without regard to the cause or causes thereof or the negligence of any party or parties that may be asserted against, recovered from or suffered by the City to the extent caused by: (i) the negligent, reckless, or intentional misconduct of the Contractor; or (ii) any negligent, reckless, or intentional misconduct of any of the Contractor’s agents. For the professional services rendered, to the fullest extent permitted by law, Contractor agrees to indemnify and hold the City harmless against Claims and the damages, losses, and expenses, including reasonable defense attorney fees, resulting from such Claims to the extent caused by the negligence or intentional misconduct of the Contractor or Contractor’s agents or employees. Such obligations shall not be construed to negate, abridge, or reduce other rights or obligations of indemnity that would otherwise exist. The indemnification obligations of this Section must not be construed to negate, abridge, or reduce any common-law or statutory rights of the City as indemnitee(s) which would otherwise exist as to such indemnitee(s). Contractor’s indemnity under this Section shall be without regard to and without any right to contribution from any insurance maintained by City. Professional Services Agreement for The City of Bozeman GIS Data & Database Architecture and Data Maintenance Health Check FY 2021 Page 4 of 12 Should the City be required to bring an action against the Contractor to assert its right to defense or indemnification under this Agreement or under the Contractor’s applicable insurance policies required below, the City shall be entitled to recover reasonable costs and attorney fees incurred in asserting its right to indemnification or defense but only if a court of competent jurisdiction determines the Contractor was obligated to defend the claim(s) or was obligated to indemnify the City for a claim(s) or any portion(s) thereof. In the event of an action filed against the City resulting from the City’s performance under this Agreement, the City may elect to represent itself and incur all costs and expenses of suit. Contractor also waives any and all claims and recourse against the City, including the right of contribution for loss or damage to person or property arising from, growing out of, or in any way connected with or incident to the performance of this Agreement except “responsibility for [City’s] own fraud, for willful injury to the person or property of another, or for violation of law, whether willful or negligent” as per 28-2-702, MCA. These obligations shall survive termination of this Agreement and the services performed hereunder. In addition to and independent from the above, Contractor shall at Contractor’s expense secure insurance coverage through an insurance company or companies duly licensed and authorized to conduct insurance business in Montana which insures the liabilities and obligations specifically assumed by the Contractor in this Section pursuant to the standard ISO policy form CG 00 01. Such. The insurance coverage shall not contain any exclusion for liabilities specifically assumed by the Contractor in this Section. The insurance shall cover and apply to all as applicable to claims, demands, suits, damages, losses, and expenses that may be asserted or claimed against, recovered from, or suffered by the City without limit and without regard to the cause therefore to the extent caused by the negligent performance of the Services by the Contractor and which is rated an A-VII or better to be acceptable to the City. Contractor shall furnish to the City an accompanying certificate of insurance and accompanying endorsements in amounts not less than as follows: • Workers’ Compensation – statutory; • Employers’ Liability - $1,000,000 per occurrence; $2,000,000 annual aggregate; accident/employee/policy limit; • Commercial General Liability - $1,000,000 per occurrence; $2,000,000 general annual aggregate; • Automobile Liability - $1,000,000 property damage/bodily injury per accident; and Professional Services Agreement for The City of Bozeman GIS Data & Database Architecture and Data Maintenance Health Check FY 2021 Page 5 of 12 • Professional Liability - $1,000,000 per claim; $2,000,000 annual aggregate. With the exception of Professional Liability, the above amounts shall be exclusive of defense costs. The City shall be endorsed as an additional or named insured on a primary non- contributory basis on both the Commercial General and Automobile Liability policies. The insurance and required endorsements must be in a form suitable to City and shall include no less than a thirty (30) day notice of cancellation or non-renewal. Contractor shall notify City within two (2) business days of Contractor’s receipt of notice that any required insurance coverage will be terminated or Contractor’s decision to terminate any required insurance coverage for any reason. The City must approve all insurance coverage and endorsements prior to the Contractor commencing work. 8. Termination for Contractor’s Fault: a. If Contractor refuses or fails to timely do the work, or any part thereof, or fails to perform any of its obligations under this Agreement, or otherwise breaches any terms or conditions of this Agreement, the City may, by written notice, terminate this Agreement and the Contractor’s right to proceed with all or any part of the work (“Termination Notice Due to Contractor’s Fault”). The City may then take over the work and complete it, either with its own resources or by re-letting the contract to any other third party. b. In the event of a termination pursuant to this Section 8, Contractor shall be entitled to payment only for those services Contractor actually rendered. c. Any termination provided for by this Section 8 shall be in addition to any other remedies to which the City may be entitled under the law or at equity. d. In the event of termination under this Section 8, Contractor shall, under no circumstances, be entitled to claim or recover consequential, special, punitive, lost business opportunity, lost productivity, field office overhead, general conditions costs, or lost profits damages of any nature arising, or claimed to have arisen, as a result of the termination. 9. Termination for City’s Convenience: a. Should conditions arise which, in the sole opinion and discretion of the City, make it advisable to the City to cease performance under this Agreement, the City may Professional Services Agreement for The City of Bozeman GIS Data & Database Architecture and Data Maintenance Health Check FY 2021 Page 6 of 12 terminate this Agreement by written notice to Contractor (“Notice of Termination for City’s Convenience”). The termination shall be effective in the manner specified in the Notice of Termination for City’s Convenience and shall be without prejudice to any claims that the City may otherwise have against Contractor. b. Upon receipt of the Notice of Termination for City’s Convenience, unless otherwise directed in the Notice, the Contractor shall immediately cease performance under this Agreement and make every reasonable effort to refrain from continuing work, incurring additional expenses or costs under this Agreement and shall immediately cancel all existing orders or contracts upon terms satisfactory to the City. Contractor shall do only such work as may be necessary to preserve, protect, and maintain work already completed or immediately in progress. c. In the event of a termination pursuant to this Section 9, Contractor is entitled to payment only for those services Contractor actually rendered on or before the receipt of the Notice of Termination for City’s Convenience. d. The compensation described in Section 9(c) is the sole compensation due to Contractor for its performance of this Agreement. Contractor shall, under no circumstances, be entitled to claim or recover consequential, special, punitive, lost business opportunity, lost productivity, field office overhead, general conditions costs, or lost profits damages of any nature arising, or claimed to have arisen, as a result of the termination. 10. Limitation on Contractor’s Damages; Time for Asserting Claim: a. In the event of a claim for damages by Contractor under this Agreement, Contractor’s damages shall be limited to contract damages and Contractor hereby expressly waives any right to claim or recover consequential, special, punitive, lost business opportunity, lost productivity, field office overhead, general conditions costs, or lost profits damages of any nature or kind. b. In the event Contractor wants to assert a claim for damages of any kind or nature, Contractor shall provide City with written notice of its claim, the facts and circumstances surrounding and giving rise to the claim, and the total amount of damages sought by the claim, within thirty (30) days after Contractor’s management becomes aware of the facts and circumstances giving rise to the claim. In the event Contractor fails to provide such notice, Contractor shall waive all rights to assert such claim provided that such waiver shall apply only if and to the extent that the City is actually prejudiced by the failure to Professional Services Agreement for The City of Bozeman GIS Data & Database Architecture and Data Maintenance Health Check FY 2021 Page 7 of 12 provide notice as and when specified herein. 11. Representatives and Notices: a. City’s Representative: The City’s Representative for the purpose of this Agreement shall be Tara Preston, Asset/GIS Systems Administrator or such other individual as City shall designate in writing. Whenever approval or authorization from or communication or submission to City is required by this Agreement, such communication or submission shall be directed to the City’s Representative and approvals or authorizations shall be issued only by such Representative; provided, however, that in exigent circumstances when City’s Representative is not available, Contractor may direct its communication or submission to other designated City personnel or agents as designated by the City in writing and may receive approvals or authorization from such persons. b. Contractor’s Representative: The Contractor’s Representative for the purpose of this Agreement shall be or such other individual as Contractor shall designate in writing. Whenever direction to or communication with Contractor is required by this Agreement, such direction or communication shall be directed to Contractor’s Representative; provided, however, that in exigent circumstances when Contractor’s Representative is not available, City may direct its direction or communication to other designated Contractor personnel or agents. c. Notices: All notices required by this Agreement shall be in writing and shall be provided to the Representatives named in this Section. Notices shall be deemed given when delivered, if delivered by courier to Party’s address shown above during normal business hours of the recipient; or when sent, if sent by email or fax (with a successful transmission report) to the email address or fax number provided by the Party’s Representative; or on the fifth business day following mailing, if mailed by ordinary mail to the address shown above, postage prepaid. 12. Permits: Contractor shall provide all notices, comply with all applicable laws, ordinances, rules, and regulations, obtain all necessary professional and business permits, licenses, including a City of Bozeman business license, and inspections from applicable governmental authorities, and pay all fees and charges in connection therewith. Notwithstanding the foregoing and the provisions of Section 13 below, with respect to the performance of professional services, Contractor shall exercise the Standard of Care to comply with laws, ordinances, rules and regulations specifically applicable to the performance of such services. Professional Services Agreement for The City of Bozeman GIS Data & Database Architecture and Data Maintenance Health Check FY 2021 Page 8 of 12 13 Laws and Regulations: Contractor shall comply fully with all applicable state and federal laws, regulations, and municipal ordinances including, but not limited to, all workers’ compensation laws, all environmental laws including, but not limited to, the generation and disposal of hazardous waste, the Occupational Safety and Health Act (OSHA), the safety rules, codes, and provisions of the Montana Safety Act in Title 50, Chapter 71, MCA, all applicable City, County, and State building and electrical codes, the Americans with Disabilities Act, and all non-discrimination, affirmative action, and utilization of minority and small business statutes and regulations. 14. Nondiscrimination and Equal Pay: The Contractor agrees that all hiring by Contractor of persons performing this Agreement shall be on the basis of merit and qualifications. The Contractor will have a policy to provide equal employment opportunity in accordance with all applicable state and federal anti-discrimination laws, regulations, and contracts. The Contractor will not refuse employment to a person, bar a person from employment, or discriminate against a person in compensation or in a term, condition, or privilege of employment because of race, color, religion, creed, political ideas, sex, age, marital status, national origin, actual or perceived sexual orientation, gender identity, physical or mental disability, except when the reasonable demands of the position require an age, physical or mental disability, marital status or sex distinction. The Contractor shall be subject to and comply with Title VI of the Civil Rights Act of 1964; Section 140, Title 2, United States Code, and all regulations promulgated thereunder. Contractor represents it is, and for the term of this Agreement will be, in compliance with the requirements of the Equal Pay Act of 1963 and Section 39-3-104, MCA (the Montana Equal Pay Act). Contractor must report to the City any violations of the Montana Equal Pay Act that Contractor has been found guilty of within 60 days of such finding for violations occurring during the term of this Agreement. Contractor shall require these nondiscrimination terms of its subcontractors providing services under this Agreement. 15. Intoxicants; DOT Drug and Alcohol Regulations/Safety and Training: Contractor shall not permit or suffer the introduction or use of any intoxicants, including alcohol or illegal drugs, by any employee or agent engaged in services to the City under this Agreement while on City property or in the performance of any activities under this Agreement. Contractor acknowledges it is aware of and shall comply with its responsibilities and obligations under the U.S. Department of Transportation (DOT) regulations governing anti-drug and alcohol misuse prevention plans and related testing. City shall have the right to request proof of such compliance and Contractor shall be obligated to furnish such proof. Professional Services Agreement for The City of Bozeman GIS Data & Database Architecture and Data Maintenance Health Check FY 2021 Page 9 of 12 The Contractor shall be responsible for instructing and training the Contractor's employees and agents in proper and specified work methods and procedures. The Contractor shall provide continuous inspection and supervision of the work performed. The Contractor is responsible for instructing its employees and agents in safe work practices. 16. Modification and Assignability: This Agreement may not be enlarged, modified or altered except by written agreement signed by both parties hereto. The Contractor may not subcontract or assign Contractor’s rights, including the right to compensation or duties arising hereunder, without the prior written consent of the City. Any subcontractor or assignee will be bound by all of the terms and conditions of this Agreement. 17. Reports/Accountability/Public Information: Contractor agrees to develop and/or provide documentation as requested by the City demonstrating Contractor’s compliance with the requirements of this Agreement. Contractor shall allow the City, its auditors, and other persons authorized by the City to inspect and copy its books and records for the purpose of verifying that the reimbursement of monies distributed to Contractor pursuant to this Agreement was used in compliance with this Agreement and all applicable provisions of federal, state, and local law. The Contractor shall not issue any statements, releases or information for public dissemination without prior approval of the City. 18. Non-Waiver: A waiver by either party of any default or breach by the other party of any terms or conditions of this Agreement does not limit the other party’s right to enforce such term or conditions or to pursue any available legal or equitable rights in the event of any subsequent default or breach. 19. Attorney’s Fees and Costs: In the event it becomes necessary for either Party to retain an attorney to enforce any of the terms or conditions of this Agreement or to give any notice required herein, then the prevailing Party or the Party giving notice shall be entitled to reasonable attorney's fees and costs, including fees, salary, and costs of in-house counsel including the City Attorney’s Office staff. Prevailing party is the party who recovers at least 67% of its total claims in the action or who is required to pay no more than 32% of the other party’s total claims in the action when considered in the totality of claims and counterclaims, if any. In claims for monetary damages, the total amount of recoverable attorney’s fees and costs shall not exceed the net monetary award of the prevailing party. 20. Taxes: Contractor is obligated to pay all taxes of any kind or nature and make all appropriate employee withholdings. 21. Dispute Resolution: Professional Services Agreement for The City of Bozeman GIS Data & Database Architecture and Data Maintenance Health Check FY 2021 Page 10 of 12 a. Any claim, controversy, or dispute between the parties, their agents, employees, or representatives shall be resolved first by negotiation between senior-level personnel from each party duly authorized to execute settlement agreements. Upon mutual agreement of the parties, the parties may invite an independent, disinterested mediator to assist in the negotiated settlement discussions. b. If the parties are unable to resolve the dispute within thirty (30) days from the date the dispute was first raised, then such dispute may only be resolved in a court of competent jurisdiction in compliance with the Applicable Law provisions of this Agreement. 22. Survival: Contractor’s indemnification shall survive the termination or expiration of this Agreement for the maximum period allowed under applicable law. 23. Headings: The headings used in this Agreement are for convenience only and are not be construed as a part of the Agreement or as a limitation on the scope of the particular paragraphs to which they refer. 24. Severability: If any portion of this Agreement is held to be void or unenforceable, the balance thereof shall continue in effect. 25. Applicable Law: The parties agree that this Agreement is governed in all respects by the laws of the State of Montana. 26. Binding Effect: This Agreement is binding upon and inures to the benefit of the heirs, legal representatives, successors, and assigns of the parties. 27. No Third-Party Beneficiary: This Agreement is for the exclusive benefit of the parties, does not constitute a third-party beneficiary agreement, and may not be relied upon or enforced by a third party. 28. Counterparts: This Agreement may be executed in counterparts, which together constitute one instrument. 29. Integration: This Agreement and all Exhibits attached hereto constitute the entire agreement of the parties. Covenants or representations not contained herein or made a part thereof by reference, are not binding upon the parties. There are no understandings between the parties other than as set forth in this Agreement. All communications, either verbal or written, made prior to the date of Professional Services Agreement for The City of Bozeman GIS Data & Database Architecture and Data Maintenance Health Check FY 2021 Page 11 of 12 this Agreement are hereby abrogated and withdrawn unless specifically made a part of this Agreement by reference. 30. Consent to Electronic Signatures: The Parties have consented to execute this Agreement electronically in conformance with the Montana Uniform Electronic Transactions Act, Title 30, Chapter 18, Part 1, MCA. 31. Limitation of Liability: Notwithstanding any other provision of this Agreement, to the fullest extent permitted by law, the total liability, in the aggregate, of Contractor and its officers, directors, partners, employees, agents, and subconsultants, to City, and anyone claiming through or under City, for any claims, losses, costs, or damages whatsoever arising out of, resulting from or in any way relating to this project or Agreement, from any cause or causes, including but not limited to tort (including negligence and professional errors and omissions), strict liability, breach of contract, or breach of warranty, shall not exceed the total compensation received by Contractor or $100,000, whichever is greater. 32. Mutual Waiver of Consequential Damages: Notwithstanding any other provision of this Agreement, Contractor and City waive all consequential or special damages, including, but not limited to, loss of use, profits, revenue, business opportunity, or production, for claims, disputes, or other matters arising out of or relating to the Agreement or the services provided by Contractor, regardless of whether such claim or dispute is based upon breach of contract, willful misconduct or negligent act or omission of either of them or their employees, agents, subconsultants, or other legal theory, even if the affected party has knowledge of the possibility of such damages. This mutual waiver shall survive termination or completion of this Agreement. **** END OF AGREEMENT EXCEPT FOR SIGNATURES **** Professional Services Agreement for The City of Bozeman GIS Data & Database Architecture and Data Maintenance Health Check FY 2021 Page 12 of 12 IN WITNESS WHEREOF, the parties hereto have executed this Agreement the day and year first above written or as recorded in an electronic signature. CITY OF BOZEMAN, MONTANA CONTRACTOR (Type Name Above) By Jeff Mihelich, City Manager By Print Name: Print Title: APPROVED AS TO FORM: By Greg Sullivan, Bozeman City Attorney D Certificate of Liability Insurance INSR ADDLSUBRLTRINSRWVD DATE (MM/DD/YYYY) PRODUCER CONTACTNAME: FAXPHONE(A/C, No):(A/C, No, Ext): E-MAILADDRESS: INSURER A : INSURED INSURER B : INSURER C : INSURER D : INSURER E : INSURER F : POLICY NUMBER POLICY EFF POLICY EXPTYPE OF INSURANCE LIMITS(MM/DD/YYYY)(MM/DD/YYYY) COMMERCIAL GENERAL LIABILITY AUTOMOBILE LIABILITY UMBRELLA LIAB EXCESS LIAB WORKERS COMPENSATION AND EMPLOYERS' LIABILITY DESCRIPTION OF OPERATIONS / LOCATIONS / VEHICLES (ACORD 101, Additional Remarks Schedule, may be attached if more space is required) AUTHORIZED REPRESENTATIVE INSURER(S) AFFORDING COVERAGE NAIC # Y / N N / A (Mandatory in NH) ANY PROPRIETOR/PARTNER/EXECUTIVEOFFICER/MEMBER EXCLUDED? EACH OCCURRENCE $ DAMAGE TO RENTED $PREMISES (Ea occurrence)CLAIMS-MADE OCCUR MED EXP (Any one person)$ PERSONAL & ADV INJURY $ GENERAL AGGREGATE $GEN'L AGGREGATE LIMIT APPLIES PER: PRODUCTS - COMP/OP AGG $ $ PRO- OTHER: LOCJECT COMBINED SINGLE LIMIT $(Ea accident) BODILY INJURY (Per person)$ANY AUTO OWNED SCHEDULED BODILY INJURY (Per accident)$AUTOS ONLY AUTOS AUTOS ONLYHIRED PROPERTY DAMAGE $AUTOS ONLY (Per accident) $ OCCUR EACH OCCURRENCE $ CLAIMS-MADE AGGREGATE $ DED RETENTION $$ PER OTH- STATUTE ER E.L. EACH ACCIDENT $ E.L. DISEASE - EA EMPLOYEE $ If yes, describe under E.L. DISEASE - POLICY LIMIT $DESCRIPTION OF OPERATIONS below POLICY NON-OWNED SHOULD ANY OF THE ABOVE DESCRIBED POLICIES BE CANCELLED BEFORE THE EXPIRATION DATE THEREOF, NOTICE WILL BE DELIVERED IN ACCORDANCE WITH THE POLICY PROVISIONS. THIS IS TO CERTIFY THAT THE POLICIES OF INSURANCE LISTED BELOW HAVE BEEN ISSUED TO THE INSURED NAMED ABOVE FOR THE POLICY PERIOD INDICATED. NOTWITHSTANDING ANY REQUIREMENT, TERM OR CONDITION OF ANY CONTRACT OR OTHER DOCUMENT WITH RESPECT TO WHICH THIS CERTIFICATE MAY BE ISSUED OR MAY PERTAIN, THE INSURANCE AFFORDED BY THE POLICIES DESCRIBED HEREIN IS SUBJECT TO ALL THE TERMS, EXCLUSIONS AND CONDITIONS OF SUCH POLICIES. LIMITS SHOWN MAY HAVE BEEN REDUCED BY PAID CLAIMS. THIS CERTIFICATE IS ISSUED AS A MATTER OF INFORMATION ONLY AND CONFERS NO RIGHTS UPON THE CERTIFICATE HOLDER. THIS CERTIFICATE DOES NOT AFFIRMATIVELY OR NEGATIVELY AMEND, EXTEND OR ALTER THE COVERAGE AFFORDED BY THE POLICIES BELOW. THIS CERTIFICATE OF INSURANCE DOES NOT CONSTITUTE A CONTRACT BETWEEN THE ISSUING INSURER(S), AUTHORIZED REPRESENTATIVE OR PRODUCER, AND THE CERTIFICATE HOLDER. IMPORTANT: If the certificate holder is an ADDITIONAL INSURED, the policy(ies) must have ADDITIONAL INSURED provisions or be endorsed. If SUBROGATION IS WAIVED, subject to the terms and conditions of the policy, certain policies may require an endorsement. A statement on this certificate does not confer any rights to the certificate holder in lieu of such endorsement(s). COVERAGES CERTIFICATE NUMBER:REVISION NUMBER: CERTIFICATE HOLDER CANCELLATION © 1988-2015 ACORD CORPORATION. All rights reserved. The ACORD name and logo are registered marks of ACORDACORD 25 (2016/03) ACORDTM CERTIFICATE OF LIABILITY INSURANCE Valley Forge Insurance Co The Continental Insurance Company National Fire Insurance Co of Hartford American Casualty Company of Reading,PA Evanston Insurance Company 3/18/2020 Greyling Ins. Brokerage/EPIC 3780 Mansell Road, Suite 370 Alpharetta, GA 30022 Jerry Noyola 770-552-4225 866-550-4082 jerry.noyola@greyling.com Langan Engineering & Environmental Services, Inc. 300 Kimball Drive Parsippany, NJ 07054 20508 35289 20478 20427 35378 20-21 A X X X X 6016359887 04/01/2020 04/01/2021 1,000,000 500,000 15,000 1,000,000 2,000,000 2,000,000 B X X X 6016359856 04/01/2020 04/01/2021 1,000,000 B X X X X 10,000 6045964169 04/01/2020 04/01/2021 5,000,000 5,000,000 C D C N 6016359842 (AOS) 6016359873 (CA) 6057485432 (NY) 04/01/2020 04/01/2020 04/01/2020 04/01/2021 04/01/2021 04/01/2021 X 1,000,000 1,000,000 1,000,000 E Professional Liab incl. Poll. Liab. MKLV7PL0004062 04/01/2020 04/01/2021 Per Claim $2,000,000 Aggregate $2,000,000 Sample Certificate 1 of 1 #S2053319/M2048664 LANGENGIClient#: 25364 JNOY1 E Nondiscrimination and Equal Pay Affirmation Appendix B NONDISCRIMINATION AND EQUAL PAY AFFIRMATION ____________________________________(name of entity submitting) hereby affirms it will not discriminate on the basis of race, color, religion, creed, sex, age, marital status, national origin, or because of actual or perceived sexual orientation, gender identity or disability and acknowledges and understands the eventual contract will contain a provision prohibiting discrimination as described above and this prohibition on discrimination shall apply to the hiring and treatments or proposer’s employees and to all subcontracts. In addition, ____________________________________(name of entity submitting) hereby affirms it will abide by the Equal Pay Act of 1963 and Section 39-3-104, MCA (the Montana Equal Pay Act), and has visited the State of Montana Equal Pay for Equal Work “best practices” website, https://equalpay.mt.gov/BestPractices/Employers, or equivalent “best practices publication and has read the material. ______________________________________ Name and title of person authorized to sign on behalf of submitter Langan Engineering and Environmental Services, Inc. (Langan) Langan Brett Milburn, GISP Director of Applied Technologies/VP