Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
24 - Submissions - Professional Geographic Information Systems (GIS) Services (2)
This Response is for use in connection with the City of Bozeman Request for Proposals. This Response may be disclosed and distributed solely to those individuals who have a need to know and only for purposes of evaluating this Response to the City of Bozeman Request for Proposals. ©2024, The Sanborn Map Company, Inc., ALL RIGHTS RESERVED. “Sanborn” and “Sanborn Map” are Trademarks owned by The Sanborn Library, LLC, and used under license by The Sanborn Map Company, Inc. PREPARED EXCLUSIVELY FOR: City of Bozeman, MT Professional Geographic Information Systems (GIS) Services DIGITAL SUBMISSION Due: 5:00 p.m. Thursday, March 14, 2024 Professional Geographic Information Systems (GIS) Services © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Table of Contents Section 1 – Executive Summary ............................................................................. 1 Section 2 – Firm Profile ........................................................................................... 2 Background of Firm .............................................................................................. 2 Subcontractor Management ................................................................................. 5 Subcontractor Overview ....................................................................................... 5 Staff Roles and Responsibilities ........................................................................... 7 Section 3 – Scope of Project ................................................................................. 11 Section 4 – General and Technical Requirements .............................................. 13 Vendor Capability Overview ............................................................................... 14 Section 5 – Related Experience with Projects Similar to the Scope of Services 16 AppGeo Related Experience .............................................................................. 16 KCI Related Experience ..................................................................................... 20 DDS Related Experience .................................................................................... 21 Section 6 – Description of Proposed Approach to the Project .......................... 25 Phase 1 – Needs Assessment & Roadmap ........................................................ 25 Phase 2 – Roadmap Implementation ................................................................. 28 Project Management .......................................................................................... 28 Section 7 – Proposed Schedule ............................................................................ 33 Section 8 – Present and Projected Workloads .................................................... 36 Section 9 – Recent and Current Work for the City of Bozeman ......................... 37 Section 10 – References ........................................................................................ 38 AppGeo References ........................................................................................... 38 KCI References .................................................................................................. 38 DDS References ................................................................................................. 39 Section 11 – Price Proposal for both Phase 1 & Phase 2 ................................... 40 Phase 1 40 Phase 2 40 Appendix 42 Affirmation of Nondiscrimination ......................................................................... 42 Resumes ............................................................................................................ 44 Professional Geographic Information Systems (GIS) Services 1 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Section 1 – Executive Summary The AppGeo Division of the Sanborn Map Company, Inc. (AppGeo), is pleased to present this proposal to the City of Bozeman (City) in response to the Request for Proposals PROFESSIONAL GEOGRAPHIC INFORMATION SYSTEMS (GIS) SERVICES (RFP). This executive summary will provide you with a high-level overview of the project, and its objectives, and will show you the value AppGeo brings to this project. We are a successful, well-established, full Geospatial services company that began our journey in 1866. Today we continue to be an end-to-end full-service geospatial company specializing in providing a broad range of geographic information products, services, and solutions. These services include conducting needs assessment, strategic planning, and delivering implementation roadmaps to government agencies and commercial organizations throughout the United States and abroad. We are one of the largest dedicated Geospatial services companies in the nation, with the personnel, equipment, knowledge, experience, and financial strength to ensure timely and successful completion of both Phase 1 and the optional Phase 2 of your project. Additionally, you can feel confident to have AppGeo working for you on your project as we are an ISO 9001:2015 certified company. Our proposal includes our Firm profile containing the extensive background of the firm as well as key information about our highly qualified proposed project team. The scope of the project and general and technical requirements are discussed. We present multiple examples of related experience with projects similar in scope as well as relevant references. Our proposed approach, schedule, and pricing are also described in detail. Finally, our present and projected workloads as well as any recent work for the City are discussed as requested in the RFP. Our approach to Phase 1 begins with an assessment of the City’s current GIS environment, both operationally and technically, through information-gathering techniques such as a survey, workshop, and targeted interviews. AppGeo will then analyze our findings through the lens of a SWOT analysis. Using this information, and in collaboration with the City, we will develop a roadmap to fully optimize your GIS environment. Phase 2 will consist of AppGeo potentially performing some or all the work associated with the GIS roadmap. It is understood that this roadmap will include a strategy to upgrade and modernize the City’s GIS environment to include version upgrades and deployment of currently available technologies, training materials for staff, city officials, and citizens, as well as best practices for performance, security, stability, and accessibility. This roadmap will also include keeping FME workspaces and Python scripts updated and in sync with ESRI and Cityworks applications as well as a path for keeping these routines current. We have in-house expertise with all ESRI products, FME, and Python, and have diligently added partners to our team who have expertise in the VertiGIS and Cityworks products. AppGeo has recently completed a successful GIS Coordination Strategic Plan for the Montana State Library (MSL). The strategic plan identified several goals for MSL to improve its geospatial coordination across the State, for which the City of Bozeman provided valuable input as a GIS Stakeholder in the State. For each strategic goal, AppGeo has developed a business plan which is essentially the tactical roadmap describing the required actions, sequence of steps, timeline, and resources to achieve the goal. And now, we look forward to working with the City in generating a successful strategic roadmap to fulfill your goal of optimizing your Enterprise GIS! Thank you for this opportunity. Professional Geographic Information Systems (GIS) Services 2 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Section 2 – Firm Profile Sanborn, established in 1866 and continually operating for 158 years, is a geospatial solutions company that provides a broad range of geographic information products and services to government agencies and commercial organizations. Our offerings include strategic planning, implementation planning, Enterprise GIS support, GeoIT support, ortho and oblique aerial imagery acquisition and processing, UAV/UAS capability, digital orthophotography, satellite imagery, airborne and terrestrial lidar acquisition and processing, planimetric and topographic mapping, remote sensing analysis, 3D infrastructure modeling, GPS surveys and field data collection, parcel and facility mapping, utility mapping, corridor mapping, GIS consulting and training, data development, data analytics, data transformation, web application development, and onsite staff augmentation. We also have several geospatial products including MapGeo, Giza, Geodata Explorer, and Oblique Analyst. Sanborn also maintains partnerships with Esri, Google, HERE, and other top geospatial product companies, enabling us to bring even more solutions to our clients. Sanborn is an ISO 9001:2015-certified contractor, and the ISO process governs all our administrative, management, production, and quality control processes. Background of Firm Sanborn is the oldest and one of the largest dedicated geospatial companies in the nation, with the personnel, equipment, knowledge, experience, and financial strength to complete any project successfully. Our services cover the full spectrum from airborne and terrestrial data acquisition to strategic planning and consulting, including data management, analytics, system development and migration. The Sanborn Map Company, Inc. Address 1935 Jamboree Dr., Suite 100 Colorado Springs, CO 80920 Telephone/Fax (719) 593-0093 / (719) 528-5093 Internet Address www.sanborn.com Year Established 1866 Office to Provide Services Boston, MA Other Offices Colorado Springs, Colorado (Corporate Office) Pelham, NY Charlotte, NC Merritt Island, FL Type of Ownership The Sanborn Map Company, Inc. is a privately owned company incorporated in the State of Delaware, U.S.A. Registration Sanborn is licensed to do business in the State of Montana, under ID number F057504 ISO 9001:2015 Certification Sanborn is certified for the provision of geographic information products and services (GIS) Professional Geographic Information Systems (GIS) Services 3 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. In 2022, the Sanborn Map Company, Inc. (Sanborn) acquired Applied Geographics, Inc. (AppGeo). Since 1991, AppGeo, now operating as a Division of Sanborn, has advised clients on technical infrastructure, system architecture, data governance, budgeting, and every aspect of maintaining and growing an enterprise GIS. We have helped many clients create GIS strategies and then helped them build their systems successfully, supporting them as needed to continue their success with GIS. Long- term support includes strategic planning, specific business plans, data development, leading-edge application development, data analysis, Extract Transform and Load (ETLs), scripting, and on-call assistance. We have a successful record with large and complex GIS and mapping programs, including recent strategic plans and statewide services on contracts for the States of Arizona, Indiana, Kansas, Louisiana, Michigan, New York, North Carolina, North Dakota, Texas, Utah, Virginia, and Wyoming. We also have significant experience with municipal GIS projects and consulting. Over more than three decades of experience in strategic planning, we have provided: More than 35 enterprise GIS state strategic and business plans for 25 states More than 100 GIS strategic plans or needs assessments for local governments including DPWs More than 5 strategic plans and geospatial data program development projects for the US Department of Transportation (USDOT) The AppGeo team is the perfect strategic partner for this critical work. We summarize our competitive advantage for this project in these five ways, and back it up with documentation below: We have a senior and highly experienced team, that has performed exactly this type of strategic planning work, that collectively has more than 60 years of geospatial leadership and consulting experience We have an unmatched record of successful state geospatial strategic and business planning projects (more than 35), giving us exceptional skill in the planning process, in developing the vision, in making strategic, business and tactical recommendations, and in providing the ability for the City to leverage the lessons learned from decades of strategic and business planning projects, including the current plans for the State of Montana; Professional Geographic Information Systems (GIS) Services 4 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. We have worked extensively with public sector agencies of all types - transportation, environment, natural resources, public health, economic development, public safety, emergency management, agriculture, information technology, and more - from which we understand the use cases and value of geospatial data and the motivations and interests of key stakeholder communities that are key to the success of business planning. We have a deep understanding of the external environment and opportunities that can be leveraged to accelerate and guide the City’s Enterprise GIS program, such as new and emerging standards, federal funding, federal requirements and guidelines, emergent geospatial platforms and technologies, and new options for geospatial data acquisition and management. We start this project with an in-depth understanding of Montana’s geospatial landscape, leveraging the knowledge, relationships and insights gathered during our development of MSL’s GIS Coordination Strategic Plan and companion business plans. AppGeo has considerable experience providing GIS consulting support to meet our customers’ needs. Our staff brings formidable technical skills, and decades of hands-on experience with public sector clients at the local and state level. We have outstanding support success ratings, as well as a high percentage of repeat clients for whom we provide annual services year after year. In fact, our repeat business is a success factor across all aspects of our work, because so much of our work comes from existing customers who value what we do and the relationships we have built with them. Data Maintenance and Geospatial Analytics are fundamental to many of our long-term customer relationships. We are adept at: Performing analysis for utilities preventive maintenance, assessing, zoning and planning, public health, school redistricting, voter redistricting, broadband expansion, and digital equity Leveraging Python, FME, Alteryx, GeoDa, and Esri tooling to build our spatial processes that align with client’s needs and competencies. We pride ourselves on building high-quality geospatial solutions and data visualizations. We create easy-to-use data visualization applications that enable non-GIS users to see and understand data on a map or other visual representation. A fundamental aspect of ‘useful’ is that it is easy to use. We build systems that are readily accessible to untrained users - even though complex workflows are often involved. Our MapGeo web tool - which has been launched for over 100 sites - is deployed without training: the functionality of the site is quickly picked up by the public. Esri Expertise. We are a Silver Partner within the Esri Partner Network. Our employees regularly attend Esri’s webinars, trainings, and conferences and have early access to many upcoming features within the ArcGIS suite of products. We have also been certified by Esri to have the necessary competence to develop products using the ArcGIS SDK. We have extensive experience developing desktop and web applications on the Esri platform, advising clients on Esri technology choices, providing hands-on, technical support for software installation and configuration, troubleshooting for system administrators, advising clients on right-sizing their licenses and license agreements, building tools for streamlining work processes, implementing and configuring Esri COTS applications, and providing user training. We use Esri software products daily for data editing and production, map-making and geographic analysis, data processing, tiling, data publishing, and web map services. AppGeo also has integrated Esri data, applications, and web services with many business systems and applications, including asset management, mass appraisal, document management, and emergency management systems. Professional Geographic Information Systems (GIS) Services 5 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. We believe no other firm can match us on any one of these factors, and certainly not the combined advantage they offer to the City. Subcontractor Management Under Sanborn’s ISO 9001:2015-certified Quality Management System (QMS), subcontractors of goods and services are pre-qualified and certified by Sanborn prior to use based on their work being compatible and acceptable with Sanborn technology, procedures, quality, and requirements of Sanborn’s end customers. Methods of prequalification and certification may be site visits, knowledge and experience in industry, production piloting or prototyping, and/or history of use. For any project that utilizes subcontracted services and products, it is essential to have an experienced subcontract manager, subcontractor SOW, and a subcontract management plan. Sanborn’s ISO processes make certain these documents and personnel are in place to ensure purchase orders are properly executed, providing the appropriate controls to meet the program schedule, budgets, and technically compliant services and products, and to review the progress of the subcontractor and subcontract management activities. Sanborn will undertake full QC on the work of any subcontractor as well as our own work, and will ensure that the quality of the end product is not compromised in any way. Subcontractor Overview To increase Sanborn’s capacity and resource base, Sanborn has partnered with the following subcontractors: KCI Technologies, Inc. – will provide CityWorks expertise Digital Data Services, Inc. (DDS) – will provde VertiGIS expertise KCI Technologies, Inc. KCI is a 100% employee-owned sub-chapter S corporation incorporated in Delaware. The firm’s history can be traced to a small firm operating out of the basement of the co- founder’s home in 1955. By its second year, the company took up residence in a proper facility, only to change locations several times over the next decade in a succession of moves that paralleled its growth. Today, roughly 2,100 employee-owners operate out of 66 offices in 20 states, including the District of Columbia. With revenues of approximately $441 million in 2022, the Engineering News-Record consistently places KCI among the top consulting engineering firms in the country. KCI has a dedicated Asset Management practice of over 20 professionals and 30+ professionals in our Technology and Innovation market to provide additional resource support. Professional Geographic Information Systems (GIS) Services 6 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. At KCI, innovation is fostered by a curious workforce driven by the desire to learn more and facilitate change. Exploration is encouraged, and an entrepreneurial mindset is our culture's foundation. In January 2022, KCI established a new business vertical within the firm to better support technology and innovation development for internal and external clients. This market consolidated several teams within KCI and provided corporate support for enhanced growth in service offerings, a renewed focus on staff’s professional development, and a more mature organizational structure to support our clients' needs better. The Technology and Innovation market comprises three service lines: Advisory Services, Data Analytics, and Solution Engineering, and two national practices, Asset Management and Land Management. Each service line and national practice work together to establish and sustain innovation as a culture at KCI. Asset Management Our dedicated Asset Management Practice is founded on the core principles of enterprise asset management and backed up by a highly qualified ISO-certified team. Our Asset Management professionals have become certified by the Institute of Asset Management (IAM) in the “Principles of Asset Management.” The KCI team has leveraged this knowledge to promote good asset management concepts and principles and awareness to our clients regarding industry standards and practices. Our proposed team members have a strong history of delivering practical, boots-on-the-ground asset management programs for local municipalities and water utilities founded on the practical application of technology. The services offered by the Asset Management team touch on the core groups of the IAM framework for an Asset Management system. Tangible services offered include: Strategic Visioning & Planning Asset Registry Development Risk Quantification & Management Business Analytics Enterprise Technology Implementations CMMS/EAMS Implementations Smart Solutions Funding Scenarios Business Partnerships KCI is a Cityworks Platinum Level Implementation Partner; the firm has been a Cityworks partner since 2010. KCI has several dedicated employees trained and well-versed in installing, configuring, and administrating Cityworks for small and large municipalities involving water, sewer, stormwater, parks, transportation, parking, facilities, solid waste, forestry, and fiber/communications line assets. Because of KCI’s active involvement in the Cityworks community and the complexity of services provided to our clients, Cityworks promoted our membership status from “Member” to “Silver” in August 2017; from “Silver” to “Gold” in May 2020; and from “Gold” to “Platinum” in January 2023. As an Esri Silver Level Business Partner, KCI focuses on designing and implementing enterprise-wide GIS/IT solutions for clients. It has been working in a multidiscipline, multi- platform environment, employing the best GIS resources and practices to meet the needs of our clients. KCI offers our clients comprehensive GIS/IT solutions through innovative thinking and technology. Through this multitude of experiences, KCI has acquired the skills and knowledge to successfully provide IT and GIS solutions for various needs. Professional Geographic Information Systems (GIS) Services 7 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Digital Data Services, Inc. (DDS) Established in 1998, Digital Data Services, Inc. (DDS) is a GIS consulting firm that utilizes Esri’s ArcGIS Platform’s power to provide state-of-the-art desktop and web GIS solutions. Critical business decisions often require careful analysis of massive amounts of structured and unstructured data, and developing solutions allowing user access to said information. A company’s value depends on how well key personnel interpret and utilize their information assets. As Geographic Information Systems (GIS) specialists, DDS provides quality, custom-designed GIS solutions that ensure your business accurately captures, stores, analyzes, and presents your information assets to the layman and the expert. DDS is an Esri Bronze Business Partner and a VertiGIS Studio Implementation Consultant with a broad knowledge of Esri’s powerful desktop and web GIS solutions. Our staff provides a comprehensive knowledge base in data, cartography, CAD, GIS, graphic design, and application development. Every one of our team members has a passion for perfection, which is reflected not only in the work we perform but in how we support our clients, even after the project is complete. Our mission is to serve our clients by ensuring they have easy access to and effectively leverage their geospatial data. Staff Roles and Responsibilities For this project, AppGeo is dedicating the full attention of our top talent - a close-knit team of GIS professionals who have a strong history of collaboration on similar projects. Our team combines technical knowledge with the pragmatics of GIS program evaluation and planning. They have deep and complementary experience in the assessment of GIS organizations, staffing, operations, technologies, data, and workflows. Professional Geographic Information Systems (GIS) Services 8 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Michele Giorgianni, PMP, GISP - Principal in Charge/Strategic Planning expert – Ms. Giorgianni has 22 years of experience in the GIS field, including 16 at AppGeo, in which she has managed dozens of GIS consulting projects. Michele oversees AppGeo’s local government-managed services program, Spatial IQ for MapGeo, and leads the AppGeo Project Management Office (PMO). Her areas of expertise are GIS consulting, project management, local and state government GIS implementations, spatial data analysis, remote sensing applied to geosciences and geospatial projects, and field data collection. Her experience includes strategic planning, needs assessments, implementation planning, data development, quality control and integration, geographic analysis, imagery and LiDAR acquisition projects, CADD conversion, and managing the development of significant web applications. She has worked as a GIS professional in positions in state and municipal government. Michele is currently Chair of the RIGIS Executive Committee and a member of the RIGIS Outreach Working Group, Data Management Working Group, and Chair of the Technical Standards Working Group. She holds a B.S. in Geography and a Master of Environmental Science and Management with a Specialization in GIS/Remote Sensing. Michele is a certified Project Management Professional (PMP) and Geographic Information Systems Professional (GISP). Maggie Cloos, Project Manager/Strategist/Enterprise Expert - Ms. Cloos is the newest member of the AppGeo division. Joining us after 8 years as the GIS Manager at the Port of New Orleans, Ms. Cloos brings extensive experience managing GIS applications, projects, and technology. At the Port, she was tasked with implementing ArcGIS Enterprise for the entire organization. In that role, she managed the implementation, met with internal stakeholders, documented their needs and business requirements through needs assessments, facilitated discussions, and configured Esri applications and solutions to meet the needs of the Port’s departments and staff. Maggie supports a variety of state and local government clients at Sanborn, leveraging skill sets as a project manager, ArcGIS Enterprise technical specialist, and business analyst, depending on the needs of the client. She is currently the technical lead for Gloucester, MA’s efforts to scale its Enterprise deployment through data migration, publication of new web services, and support for enterprise integrations. Carson Vallino, Assistant PM/Enterprise support/Data&Business Analyst– Mr. Vallino (B.S.) is an experienced project manager with a strong background in GIS analyst training and SDE Enterprise support & management. Starting as a team lead at the University of Vermont’s Spatial Analysis Laboratory, Mr. Vallino joined the AppGeo team to work on many data improvement efforts for our clients, such as parcel data development, address data clean-up, GIS analyst training, and building quality control measures for data, including supervising a data production team on a large statewide project. With his history of experience with local GIS data development skills, Mr. Vallino now manages over a dozen local government clients under annual support contracts as well as several other initiatives. Mr. Vallino has also been a project manager for the build-out and support of Esri enterprise infrastructure for both MA’s Metropolitan Area Planning Commission (MAPC) and the City of Gloucester, MA. Eric Ingbar – Lead Strategist/Business Analyst - Mr. Ingbar has more than 30 years of experience in engagement and information gathering with stakeholders and agency business units, evaluation, design, and implementation of spatial and non-spatial information systems. He is experienced in both GIS and data management systems. Eric is currently providing geospatial governance expertise to Caltrans for its Enterprise Data Governance Technology Solutions and is working to deliver a business plan to Improve Geospatial Data Governance for the Montana State Library (Montana’s state geographic information office). He is the lead business analyst on work for the Arizona Department of Transportation to assess data quality, management, and data governance best practices for GIS data. Eric has been one of the key senior team members in our work on GIS strategic plans for the states of Utah, Georgia, Indiana, Michigan, Montana, and Massachusetts. Eric holds an M.A. from University of New Mexico and a B.A. from Swarthmore College. Professional Geographic Information Systems (GIS) Services 9 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Jake Gamble, GIS Analyst - Jake is a graduate of the University of Vermont, where he assisted in geospatial research funded by the Vermont NASA ESPCoR. He graduated with a B.S. in Forestry with a minor in Geospatial Technologies. He started working at AppGeo as a GIS Analyst immediately after graduating and brings experience with multiple ESRI software. Jake’s experience at AppGeo includes extensive data development work for the Arizona Department of Transportation, various geospatial tasks for numerous local government agencies including parcel updates, creating static maps, and working with utility networks for editing and tie card linking. Jake has also assisted with Beta and Production testing of the Rutgers Campus Map web application. Ashley Tardiff, Data Scientist - Ashley has 6 years of experience as a GIS Analyst and has a BS from the University of Massachusetts, Amherst. Her expertise is in complex spatial data processing, data analysis, and data visualization using tools such as Esri, QGIS, FME, Alteryx, and Python. In addition, she has worked on all of our recent redistricting projects (both school and local voting redistricting) including Shrewsbury, MA; Wellesley, MA; and Peabody, MA to name a few. Russell Cohen, Data Scientist, FME, Python - Since joining AppGeo in 2020, Mr. Cohen has been a key contributor to several AppGeo projects, including state, county, and town-level redistricting projects. He provides GIS Analyst skills in data development and improvement, building data ETL (Extract, Transform, Load) routines, data analysis, web cartography, and as-needed technical assistance for several projects using tools such as Esri, FME, Alteryx, and Python. KCI | Ms. Hammel, Principal In Charge – Ms. Hammel is KCI’s Asset Management Regional Practice Leader. She and her team provide asset management professional services such as strategic planning, data management, and technology implementation to predominantly municipal clients. Since 2005, Ms. Hammel has been a Certified Project Management Professional (PMP) managing complex projects for over 25+ years. Her strong project management acumen pervades through her staff and projects to ensure successful delivery and satisfied clients. Ms. Hammel maintains strong relationships and open communication with clients to ensure expectations are met at all project phases. She has worked primarily with local, state, and regional government organizations throughout her career, resulting in a strong understanding of municipal government. KCI | Mr. Murk, Task Manager – Mr. Murk is the Solutions Engineering Manager within KCI’s Asset Management Practice and has been leading Cityworks implementations for the past 13 years at KCI. He leads a team of solution analysts, business analysts, and solution engineers in implementing Cityworks AMS for transportation, water, utility, facility, and public works organizations. He is well versed in Cityworks AMS, Storeroom, and Mobile and integrating with other core enterprise systems through the Cityworks API and 3rd party integrations. Mr. Murk is also an expert in Esri’s ArcGIS platform and Microsoft SQL Server, both inherent in any Cityworks implementation. He has excellent communication skills and can easily converse with IT staff about architecture, GIS staff about geodatabases, and field staff about what would make their lives easier. He has developed targeted training programs and worked closely with many users to assist them in their day-to-day activities and understanding of the technology. KCI | Ms. Lowe, Solutions Engineer – Ms. Lowe is a Project Manager in KCI’s Asset Management practice with over 20 years of experience in providing GIS and IT management, asset management, analysis, and administrative and operations leadership. She has exceptional communication and interpersonal skills, with the ability to seamlessly work with clients, staff, and other professionals in various areas across different job levels. Ms. Lowe spent much of her adult career in the public sector, including supporting GIS and asset management initiatives nationwide at several water and wastewater utilities. Her experience in the public sector allows her to foster a relationship with the client based on understanding their needs and serving as a trusted advisor. KCI |Mr. Blinn, Solutions Architect - Mr. Blinn is a Solutions Architect, responsible for creating and configuring ArcGIS Online applications, managing ArcGIS Enterprise and Server instances, and serving Professional Geographic Information Systems (GIS) Services 10 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. as a primary technical lead. Mr. Blinn’s passion for problem-solving drives him to take on every task with excitement, insightfulness, and creativity. With a deep understanding of a solution's technical approach and business application, he can train a user or pitch to a CEO. Mr. Blinn has worked with numerous municipal and commercial agencies over the past 14 years to size infrastructure on-premises and in the cloud correctly. DDS | Tom Neer, Principal/Project Manager - Mr. Neer joined DDS in 2006 and has over 25 years of project experience integrating and developing Geographic Information System solutions for various industries. He leverages his cartography, GIS, and software development knowledge to analyze and present spatial concepts and relationships to executives, subject matter experts, non-specialists, and the public. Mr. Neer’s experience spans support and implementation for land planning, resource management, business, oil and gas, electric utilities (coal, wind, solar, transmission), NEPA, and various federal, state, and local government projects. DDS | Dave Carter, Principal / GIS Analyst 3 - Mr. Carter has over 25 years of information technology experience, emphasizing software development, databases, and Geographic Information Systems. Contributes technical expertise to optimize computer use, improve production techniques, create GIS systems, produce GIS projects, and implement other technology solutions. Other capacities include production management, GIS consulting, and Government procurement specialist. DDS | Pete Skull, Application Developer 3 - Mr. Skull is a senior application developer who joined DDS in 2015. He has a Bachelor of Science in computer science and mathematics. Mr. Skull is highly proficient in C#, C++, C, Java, Python, SQL, JavaScript, HTML, and XML languages; .NET, Win32 SDK, and WPF libraries. In addition to writing custom JavaScript and .NET modules for web GIS applications, Mr. Skull is experienced using the ArcGIS Pro SDK to develop Add-Ins and custom modules for ArcGIS Desktop to enhance functionality and end-user experience and with the ArcGIS Maps SDK for JavaScript (3.x & 4.x) in developing custom widgets for ArcGIS Web AppBuilder and ArcGIS Experience builder. DDS | Zack Robison, Application Developer 2 - Mr. Robison is a geospatial application developer who joined DDS in 2014. He has a bachelor’s degree in geography, emphasizing GIS, and brings experience in web design, software development, and GIS management. Mr. Robison has implemented web solutions for oil and gas, retail, and local government. Mr. Robison is proficient in Python, JavaScript (jQuery, Dojo, JSON), TypeScript, CSS3, SQL, and XML and is our lead front-end developer. Professional Geographic Information Systems (GIS) Services 11 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Section 3 – Scope of Project The project’s goals are to assess the City’s current GIS environment, develop a roadmap for further development of GIS resources, and potentially assist in the implementation of the roadmap recommendations. The project aims to provide recommendations for upgrading the City’s ESRI architecture, Cityworks implementation, and VertiGIS Geocortex technology while keeping FME applications and Python scripts updated and in sync. The project has two main phases. Phase 1 includes performing a full assessment of the City’s current GIS environment and developing a roadmap with recommendations for advancing the City’s geospatial maturity. The draft roadmap will be presented to the GIS & Asset Management Division staff. As evidenced in the above firm profile and below related experience sections, AppGeo has extensive experience in Geospatial Assessments, Strategic Planning, and Implementation Planning at both local and state government levels. Our teams’ strength in geospatial planning stems from our significant expertise in implementing and using geospatial technologies; building geospatial tools and processes; and developing, acquiring, analyzing, and visualizing geospatial data. Additionally, we have a lot of practice assessing and planning geospatial programs, technology, and data. As mentioned in the Firm Profile section we’ve successfully completed dozens of municipal and state-level plans. We’re currently working with the Montana State Library to develop a Data Quality Improvement Business Plan, the State of Massachusetts Geospatial Strategic Plan, the State of Indiana GIO Value and Benefits Study, and supporting the State of Michigan to plan for the implementation of a new GIO Advisory Council, helping them grow and maintain their Aerial Imagery Program, and supporting the development of their Broadband program and related mapping applications. The City’s assessment will consider both technical and organizational aspects of the City’s GIS program to provide a comprehensive picture of the current situation and future vision. The scope of the technical assessment includes the City’s on-premises Enterprise ArcGIS Portal deployment, data, and applications; ArcGIS Online (AGOL) environment and content; ArcGIS Pro and ArcMap deployments; CityWorks and VertiGIS deployments and integrations with the supporting Esri technology and data; and related FME and Python scripts. The information gathered for this assessment will come from the City’s GIS stakeholders’ input on gaps and priorities and a review of the existing technical components just described. Stakeholders may include GIS/IT managers, City staff power users, casual end-users, decision makers who may rely on GIS data to make informed decisions, and partners or collaborators such as representatives from the County or State who have a vested interest in Bozeman’s geospatial program. We will aim to explore data needs, geospatial analysis activities and requirements, integration of geospatial data and tools with business systems, and the current use of and need for geospatial tools. We will also aim to explore how existing systems and workflows could benefit from GIS or how stakeholders can more effectively engage with the geospatial resources offered by the City. Our focus will be on how stakeholders are using (not using) GIS and geospatial data: what needs are met (unmet) by the City’s GIS currently, what data is used (required), what are the critical applications/business processes that use (could use) GIS, what staff are using (not using) GIS, what opinions/concerns they have, what is their perception of the organizational effectiveness of the current GIS operation, and so on. Phase 2 includes assisting in implementing the roadmap recommendations. This also includes establishing standard operating procedures for developing and publishing map services, developing a Quality Assurance/Quality Control (QA/QC) plan for maintaining databases, and developing application training resources for City staff. We understand that the scope of Phase 2 will be determined by the outcomes of the Phase 1 assessment and recommendations. The AppGeo team is fully prepared to Professional Geographic Information Systems (GIS) Services 12 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. support the implementation of any of the Roadmap’s recommendations, including the specific tasks already identified. We have years of experience developing QA/QC plans both internally and for our clients and their projects. For instance, Sanborn is ISO 9001:2015 certified company and the AppGeo division is currently working to implement the ISO culture and develop additional ISO quality management plans. We also have our own internal best practices and procedures that ensure quality deliverables are provided to our clients. For example, we have extensive documentation on parcel data management and maintenance, and application development best practices. These are used for project execution and as resources for new employee or client training. We completed a large utility data conversion project for Rutgers University, and for that project we developed detailed Quality Assurance documentation and specifications that ensured AppGeo, our subconsultant, and Rutgers all followed the requirements necessary to ultimately deliver comprehensive, and accurate GIS Utility data for all nine of their utility network systems converted from AutoCAD. Similarly, AppGeo recently developed a Data Quality plan for the Arizona DOT that identified data owners and stakeholders, inventoried and assessed data based on a variety of metrics (Roads & Highways conformity, interoperability, sensitivity/ risk, etc.), and developed an actionable roadmap of process improvements to achieve the target state of data quality. Professional Geographic Information Systems (GIS) Services 13 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Section 4 – General and Technical Requirements Summary of Required Skills General/ Technical Requirement Team Capabilities Experience assessing geospatial technologies and programs and developing recommendations We have an unrivaled track record of delivering thorough, actionable needs assessments and strategic plans to local and state agencies (+100 local plans, +35 state plans). ArcGIS Enterprise and AGOL experience Our team possesses end-to-end expertise in designing and supporting Esri products, in addition to being an Esri Business Partner to ensure the City’s success in utilizing and troubleshooting Esri products. Experience with Open Data Hub, Hub Premium, ArcGIS Urban, Story Maps, Field Maps, Instant Apps, Survey 123 and other ArcGIS apps We have configured and deployed ArcGIS applications and solutions for a multitude of use cases for clients across the public sector. Experience with Cityworks version upgrades Our team has expertise in implementing, upgrading, and administering Cityworks as a Platinum Implementation Partner with numerous municipal deployments under our belt. Experience migrating Crystal Reports to Active Reports in Cityworks Our team of Cityworks specialists are experienced in supporting a variety of integrated applications and capabilities, including implementing Active Reports in Cityworks 23. Experience upgrading Geocortex to VertiGIS Studio Our team has supported numerous migrations from Geocortex to VertiGIS Studio as an Implementation Partner for more than a decade. Experience automating workflows with FME and Python Our team of data scientists are experienced in automating data processes through Python scripting and the use of FME workbenches. Experience developing Standard Operating Procedures and workflow documentation for integrated applications All members of our team are adept at developing documentation and providing knowledge transfer as a standard part of our project approaches. Experience developing QA/QC plans Quality control is an ingrained part of our work processes, and we frequently assist our clients in creating and improving their own data quality plans, such as the project referenced above for Arizona’s DOT. Professional Geographic Information Systems (GIS) Services 14 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Experience developing training resources for end users Our team excels at supporting our clients with tailored resources from user guides, to training seminars, to on-call support. Vendor Capability Overview Together, our team brings the following additional, relevant capabilities and benefits to this project and the City: Assessing functional specifications and technical requirements for specific departmental use cases. • Implementing, upgrading, and administering SQL databases. Managing data in a variety of formats and geodatabases and combining multiple data layers in data-driven systems. Transformation and migration of data to new databases, and data schemas through the use of ETL tools such as FME. • Proficiency in a variety of languages to support customization of ArcGIS web applications. Project Management activities are guided by PMP-certified project principals and project managers. City Staff Roles and Responsibilities AppGeo assumes that the City’s project team will include the following roles: Project Sponsor, Main POC: Provides high level project leadership and oversight of the project to ensure project success and act as a main point of contact. Contributes subject matter expertise to all project tasks and approves deliverables. We expect this role to be held by the GIS Program Manager or a similar role. Project Team Members: Contribute subject matter expertise to all project tasks. Collaboratively review and make recommendations on deliverables feedback. Project Support: Coordinates with AppGeo PM and facilitates administrative tasks such as deliverable acceptance forms, status meeting notes/reports, invoicing and payments. The City’s project team will have the following responsibilities: The Main POC or a designee will be involved with all facilitated meetings Provide existing documentation/materials for AppGeo’s review Help identify project stakeholders, roles and responsibilities Compile distribution list and distribute the Online Stakeholder Survey Help coordinate and schedule stakeholder meetings Review and provide timely feedback on draft deliverables Provide strategic input to formulate draft deliverables Professional Geographic Information Systems (GIS) Services 15 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Provide deliverable acceptance Participate in status meetings and draft deliverables review meetings Other Roles and Responsibilities A cross-section of the City’s GIS & Asset Management stakeholders will be expected to participate in the information gathering and visioning activities for the roadmap. Their involvement is essential to understanding the full picture of the City’s geospatial needs and will include the following activities: Participation in the online survey Participation in the facilitated workshop Timely review and feedback of roadmap deliverables Professional Geographic Information Systems (GIS) Services 16 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Section 5 – Related Experience with Projects Similar to the Scope of Services AppGeo Related Experience Montana State Library – GIS Coordination Strategic Plan and Companion Business Plans In 2005, Montana started creating a Spatial Data Infrastructure under the Montana Land Information Act. Today, the State boasts a very mature GIS program led by the Montana State Library (MSL). In this recent planning effort, a survey was conducted for technical and non-technical GIS data users. From there, a technical and non-technical workshop was held, followed by interviews with key stakeholders. AppGeo then performed a SWOT analysis, leading to the development of goals and recommendations and culminating in a GIS Coordination Strategic Plan. The GIS strategic plan empowers Montana to integrate geospatial policy, products, and information into business processes. Many state departments will directly and immediately benefit from the plan, including Public Health and Human Services (COVID-19 response and planning), Disaster and Emergency Services (Next Generation 9-1-1), Fish, Wildlife, and Parks (through high-resolution data like LiDAR), Bureau of Land Management, Labor and Industry (e.g., Building Standards Division), and Architecture & Engineering (through the Real-Time Network of high-resolution survey stations). A companion business plan was then developed to provide the MSL GIS office with an actionable implementation plan for achieving a strategic objective of enhanced communications. The activities described in the plan include creating the key elements of a formal communications plan, how to evaluate and then improve the Library GIS website, and building systematic mechanisms to make responding to support requests and public inquiries more efficient. Ultimately, all of these are components of a formal communications plan – essentially a handbook – that becomes the day-to-day guide for how GIS coordination and Library GIS services interact with the public and other professionals. Overall, the goal is to create appropriately tailored ways to convey the benefits, products, services, and coordination efforts of the Library’s work and to streamline inquiries and assistance requests from partners and the general public about geospatial information and services. AppGeo also worked with MSL to complete another business plan focused on improving partnerships for MSL GIS coordination by making it easier for MSL to manage new and existing partners, and thus make its assistance to other government and non-government entities easier to deliver. Most of the actions in the plan work toward defining ways to make partnering more efficient and effective. The business plan actions include promoting collaboration between others, such as regional partnerships, and creating ways to promote partnering opportunities with MSL at any level of government or local interested party. The most recently completed business plan to Improve Geospatial Data Governance describes what data governance should mean in the context of statewide geospatial coordination, the authority and responsibilities of MSL, other state data authorities, MSL’s partners, and the statewide geospatial community. That understanding then helps to establish the scope and boundaries of MSL geospatial data governance and develops a structure and process for data governance actions. The plan provides examples of data governance principles and policies from other states for background and ideas, offers a template work plan to implement statewide data governance, and describes the time and financial resources that might be required. We are currently working on a fourth business plan to Improve Geospatial Data Value. This plan seeks to describe the goals and actions required to achieve the strategic goal to Improve the collection, maintenance, and dissemination of authoritative geospatial information, aiding the creation of better policies, more informed Professional Geographic Information Systems (GIS) Services 17 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. decisions, and providing value to Montana. The plan defines the characteristics of data quality and the actions that MSL can take to reach its data quality goals. AppGeo facilitated MSL’s work to define the values and actions for structures and addresses, as well as elevation-related datasets. The work done during the development of this business plan will provide a template for planning data quality activities for all MSL statewide datasets in the future. These business plans provide objectives, resourcing and funding requirements, prioritization and implementation plans, and guidance on measuring progress. Indiana Geographic Information Office - GIO Strategic Plan and Business Plans Indiana had a mature GIS program before undertaking its GIO strategic plan with AppGeo in 2021. In the 2021 National States Geographic Information Council Maturity Assessment, the Indiana Geographic Information Office was given an “A” grade – the highest in the country. The process began with a survey, online workshop, and stakeholder interviews, where stakeholders voiced priorities and outlined the current state of GIS. The Indiana GIO Strategic Plan identifies several goals around the topics of leadership, data, communications, and organization, each involving several recommendations. The plan encourages Indiana to find ways to articulate the business value and problem-solving capabilities of geospatial data, especially to decision-makers and policy leaders. A recommendation was also made to find stable funding for staff, infrastructure, licensing, and data resources such as statewide imagery, LiDAR, and addresses. Three (3) Business Plans were then developed to provide tactical action plans for implementing selected objectives resulting from the strategic plan. These included business plans for implementing a GIO Advisory Workgroup, for aligning the office’s roles and responsibilities to the strategic plan, and a business plan to improve communications. These business plans provide objectives, resourcing and funding requirements, prioritization and implementation plan, and guidance on measuring progress. We are working on a GIO Value and Benefits Study to help the GIO support one of the strategic goals of articulating business value and problem-solving capabilities. The study will provide IGIO costs and savings information, discuss qualitative and quantitative benefits, and the value of open data. This study will be used by the GIO to convey the ROI provided by the office. State of Michigan Department of Technology, Management & Budget, Center for Shared Solutions (DTMB CSS) - GIS Strategic Plan In 2022, AppGeo worked with the State of Michigan to develop a 5-year strategic plan for Michigan’s primary GIS office. The project included designing survey strategies, conducting in-depth interviews with stakeholders, analysis of strengths, weaknesses, opportunities, and threats (SWOT), determining strategic goals, facilitating a consensus-building workshop, and writing a strategic plan. The strategic plan emphasizes the need to strengthen statewide geospatial coordination by expanding DTMB CSS leadership, increasing sharing of data across the state in an open data model, enhancing communications with stakeholders and partners, being a clearinghouse for authoritative geospatial data and services, and continuously reviewing and improving state business processes. These goals are backed up by evidence collected from the information gathering phases, and recommendations are provided to assist DTMB CSS with achieving these goals. We recently worked with CSS to help them achieve one of their strategic objectives of implementing an advisory group. To date, AppGeo has developed a charter for the advisory group and provided an implementation schedule that outlines all the steps required to ultimately host the inaugural meeting of the advisory group. Professional Geographic Information Systems (GIS) Services 18 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Town of Wakefield, MA – GIS Strategic Plan AppGeo began working with the Town of Wakefield in 2020 with the development of a GIS Strategic Plan for the DPW. The process of designing a strategic plan included requirements gathering of current state information through stakeholder interviews, assessment of risks and opportunities through a SWOT analysis, and finally, a GIS system design with an implementation plan. Following the strategic plan project, the Town continued to work with AppGeo to implement several of the recommendations from the plan. The parcel boundaries were not maintained for several years and needed to be updated. Also, a new workflow was needed to migrate from CAD data maintenance to GIS. Additionally, AppGeo has been working with the Town to update their GIS parcel data to comply with the MassGIS Standard. This work also involved minor dimension corrections to large lot subdivisions. AppGeo has also been working with the Assessor to resolve major mismatch resolutions. This includes parcels that do not have a CAMA record, CAMA records that do not have a parcel, and parcels greater than 20% different in GIS calculated area compared to the CAMA acreage. AppGeo also implemented a new MapGeo website for the Town to view parcel and CAMA data, with several themes such as zoning and zoning overlays, land use, school district boundaries, and statewide imagery. City of Stockton, CA - GIS Technology Assessment and Roadmap AppGeo performed a GIS technology assessment and roadmap development project for the City in 2014. The scope of work had eleven specific objectives covering all aspects of GIS from data and system evaluation to business process integration and governance. AppGeo conducted an online survey of stakeholders, numerous departmental interviews, and extensive review of documents, software and data holdings. A SWOT (Strengths, Weaknesses, Opportunities, and Threats) analysis was used to identify and organize an assessment of gaps to fill and of strengths to leverage going forward. AppGeo conducted a Joint Review Workshop with the City on vision development, goal setting and prioritizing recommendations. Two different visions were presented based on different assumptions about future budgets and staffing levels. The final report presented a strategic vision with specific programmatic recommendations for technology modernization, a sustainable GIS program design, business system integration with GIS, and targeted investments to address data deficiencies. The final report was delivered in July 2014. Since the completion of the final report, AppGeo has continued to support the city’s GIS program and has developed and implemented a modernized, public-facing geospatial web viewer. City of Tacoma, WA - GIS Strategic Plan The GIS Assessment Report for Tacoma, WA was prepared for the City of Tacoma Information Technology Department by AppGeo as a subcontractor to Plante Moran and within the context of a City-wide IT Assessment. The GIS assessment involved research on how staff in the City of Tacoma general government used geospatial information and GIS technologies. The research included an online survey, intensive interviews onsite with Tacoma city personnel, and a collection of information from business units and the Information Technology Department GIS (ITD GIS). The assessment goals were to characterize the use of GIS within the City relative to other U.S. cities, to identify opportunities for improvements, and to identify critical steps to protect the City’s investment in GIS to date. The report includes an executive summary, project overview, existing geospatial conditions, organization and governance findings, applications findings, systems integration findings, SWOT analysis, vision and goals, governance, and recommended priority projects and actions. The plan recommended new managerial configurations, determining how best to deploy Esri and non-Esri geospatial technologies, and a work plan by which to implement these changes. City of Gloucester, MA GIS Consulting Services AppGeo has been managing and developing the City of Gloucester, MA’s (population 29,952) GIS data for two decades. To better manage this data, AppGeo implemented and administered a versioned Enterprise Geodatabase. Professional Geographic Information Systems (GIS) Services 19 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. This implementation migrated the GIS data from a storage solution comprising a dozen disconnected file geodatabases, to a management solution comprising a single enterprise geodatabase. The environment is beneficial for database organization and allows multiple analysts to edit and maintain significant datasets such as the City’s stormwater, water, and sanitary sewer utility networks. To continue expanding the City’s geospatial abilities by directly enabling staff to contribute to the management of their utility data, AppGeo architected and implemented an Esri Enterprise System. Leveraging a combination of tools such as ArcGIS Online (AGOL), ArcGIS Server, and the Enterprise Geodatabase (SQL), the AppGeo project team is providing the City a platform where they can edit data through web-based and mobile applications, and integrate with existing third-party solutions such as Sedaru, GraniteNet, and Munis government services. Integration with the City’s third-party solutions is a key component and requirement. The City requires that field crews can update and capture GIS utility data in a mobile capacity, connecting to a database and feature services that provide a real-time data flow to managers and City officials monitoring and analyzing the data through dashboards, web maps, and applications. AppGeo is supporting Gloucester’s IT and DPW departments, providing technical and licensing recommendations, overseeing systems and server installation, facilitating licensing discussions with Esri based on the City’s needs, undertaking the installation, configuration, and security setup of the Esri Enterprise environment, migrating the AppGeo-managed Enterprise Geodatabases onto the City’s network, and supporting staff by answering questions and providing training opportunities, as well as managing access to the web-based content. AppGeo will continue to administer the City’s Enterprise Geodatabases and SQL environment, performing geodatabase maintenance tasks, performing database administration, and overseeing QA/QC and management of the data collected by the City’s staff. Most recently AppGeo has been developing a replacement solution to the Department of Public Works’ (DPW) asset management software, Sedaru, that is being discontinued. AppGeo is providing an Esri-based solution for the city’s DPW team to allow them to continue to carry out work orders, inspections and asset updates to their enterprise GIS database. The solution utilizes Esri’s ArcGIS Workforce, ArcGIS Field Maps, ArcGIS Survey123, and ArcGIS Experience builder together to assign work orders to DPW staff, allowing them to populate the orders during fieldwork, and have the work history and outstanding work orders visualized via a monitoring dashboard. Town of West Hartford, CT – GIS Consulting Services AppGeo identifies and defines a need for so many of our clients, then designs and implements the solution. And we do this successfully at the enterprise level, managing services that are important across the organization. By way of example, for West Hartford, CT (population 63,000), AppGeo provides ongoing technical expertise and services that supplement the Town’s in-house capabilities, effectively extending the Town’s work capacity, knowledge base, and flexibility to respond to short-notice needs. Our services range from field data collection to data development to training to application development. AppGeo has provided ongoing task-based support to the Town since 2002, beginning with a Needs Assessment and a GIS Strategic Plan and continuing with annual Managed Services contracts: Working with Emergency Operations Center to design and develop ArcGIS RunTime portable mapping application for emergency responders Performing ongoing property data and ancillary data maintenance and integration with assessing and permitting business systems Create and update data layers and maps, including address points, snow plow routes, trash pickup zones, flood zone and properties analysis, Assessment Neighborhood maps, assessment revaluation change maps, various school district maps, Voting District maps, Tax Assessor Maps, Zoning Maps, Wetland Maps, Floodplain Maps, Engineering Dept. Maps, Health Dept. case address, and census tract analysis Integration of the GIS with other business systems and databases such as the Town’s assessment database, Asset Essentials, document imaging, permitting system, web-based address point system Development of advanced GIS property viewer, including integration with Town Clerk’s data, Assessor’s database, AppGeo custom address maintenance application, and the Town’s CityView permitting application. Professional Geographic Information Systems (GIS) Services 20 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Coordination and management of town-wide GIS needs, database integrations and transfer of data between systems, migration of mapping website to new MapGeo platform, and development of upgraded address maintenance application Training Town staff, managing day-to-day GIS-related requests from town staff and installing and configuring ArcGIS desktops throughout various departments. Significant update of stormwater utility data to meet MS4 compliance. Thorough stormwater system inventory and extensive assessment of data integrity, followed by town-wide data development, updates, and revisions. KCI Related Experience Since becoming an Implementation Partner with Cityworks, KCI has performed many successful Cityworks implementations and system integrations. The following projects highlight our team’s recent successes, most relevant to the City’s project. City of Morgantown, WV KCI worked with the City of Morgantown to implement Cityworks AMS to support the management of work activities within their Streets and Right-of-Way (ROW), Facility Maintenance, and Fleet departments. When planning the project, the City decided to take a phased approach to provide more focused efforts for each department. Phase 1 of the implementation was for the Streets and ROW department, which provides many services and maintains various assets, including streets, sidewalks, retaining walls, traffic signals, signs, and more. After a thorough and interactive implementation process, Cityworks was deployed for use on March 1, 2023. Phase 2 of the implementation began following the completion of Phase 1 and focused on the Facility Maintenance and Fleet Maintenance departments. As a part of this phase, Cityworks Storeroom was implemented, including a migration of 10,000 material types from an existing Access database. Phase 2 was deployed on September 18, 2023. Also included in the project was an integration with their customer-facing 311 system, SeeClickFix. As a Development Partner with Cityworks, SeeClickFix offers an out-of-the-box integration they have established. KCI worked with the SeeClickFix team and Morgantown stakeholders to configure Cityworks to support the integration, including Service Request types and user security. City Of Lebanon, TN The City of Lebanon contracted with KCI to review the City’s current Cityworks configuration for AMS and PLL, migrate their on-premises deployment to AWS, and upgrade Cityworks to the latest version compatible with their Esri Enterprise environment. KCI worked with their IT and GIS departments to access and review the current on- premises architecture, provide server specification recommendations, install Cityworks in the cloud, and configure IIS. Once the existing Cityworks environment was configured for staging and production environments, KCI restored their current Cityworks instance, upgraded to 15.8.x, and performed testing. KCI also installed Respond, Admin, and Style plug-ins and granted plug-in permissions for multiple City departments. Issues encountered during testing were rectified, and users could access and use the upgraded Cityworks environment in AWS. KCI met with Public Works stakeholders to review their Cityworks configuration, including assets, groups, permissions, and work order templates. Multiple information-gathering sessions were held to meet with different departments within Public Works to understand their workflow processes better and better configure Cityworks to meet their daily operational needs and reporting requirements. Based on stakeholder feedback, KCI developed an Implementation Plan and configured the newly migrated Cityworks staging environment. KCI and the City walked through the Cityworks configuration with Public Works managers, supervisors, and field crews; and performed UAT and Cityworks Respond training. Once UAT was complete in staging, KCI replicated configurations in the Cityworks production database. KCI was available on-site for the go-live rollout, offered additional training, performed configuration changes on the fly, and provided additional post go-live support. Professional Geographic Information Systems (GIS) Services 21 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. KCI developed Crystal Reports for state reporting and reimbursement costs and implemented Power Automate to trigger Cityworks database updates. City of Chattanooga, TN The City of Chattanooga has implemented Cityworks as its CMMS. It is used throughout the City, specifically for tracking Department of Public Works (DPW) and wastewater plant maintenance activities. KCI has worked with Chattanooga over the past seven years to support new implementations, enhancements, user training, asset hierarchy redesign, mobile and inventory management (Storeroom) implementation. Cityworks Upgrade for the Waste Resources Division. KCI assisted Chattanooga’s Waste Resources Division in upgrading and enhancing Cityworks for managing the WTP facility. As a part of this task, KCI configured the test and production environments, provided onsite training and on-call support, and redesigned their asset geodatabase. GIS & Cityworks End User Support for Sewer Maintenance. KCI observed the workflows of the Sewer Maintenance Department, performed a gap analysis to determine where inefficiencies existed, and made recommendations to resolve them. KCI coordinated with the City’s Cityworks administrators to help resolve discovered issues. KCI also provided one-on-one and classroom training sessions using training guides written to meet their workflow. Cityworks Storeroom Implementation. Chattanooga tasked KCI with implementing the Storeroom module for the wastewater treatment plant (WWTP). This task involved migrating from their Oracle inventory management system and integrating it with the Oracle Financial Service general ledger. Throughout the process, KCI met and coordinated with stakeholders from waste resources, finance, IT, and GIS departments to ensure the implementation met the expectations of each group. Using the requirements gathered, KCI successfully implemented Storeroom and developed a custom interface that sends financial accounting data directly into the financial system daily. Through this effort, the City was able to eliminate a $300,000 discrepancy between the inventory management system and the general ledger and reliably maintain the balance moving forward. Implementation for Parks and Facility Maintenance. KCI worked with the City to expand the use of Cityworks into the Parks and Facility Maintenance departments. During this task, the KCI team worked with key stakeholders of each department to determine the requirements for Cityworks to fit their operations best. Once determined, KCI configured test and production sites and provided user training. DDS Related Experience DDS is one of only several companies that are both Esri and VertiGIS Business Partners. Esri recognized DDS as a Cornerstone Business Partner several years ago and has been a VertiGIS Studio Implementation Partner since 2011. DDS assisted many organizations with migrating from Microsoft Silverlight and Adobe Flex to Geocortex Essentials in the early 2010s. DDS has been using VertiGIS Studio since 2018. Many organizations we work with are in the early phases of migrating from Geocortex Essentials to VertiGIS Studio. Regional Municipality of York, Canada – On-Call Geocortex/VertiGIS Studio Support- Regional Municipality of York, Canada DDS has been providing on-call technical support services to York Region GIS in support of their ArcGIS Enterprise and Geocortex Essentials sites. Most of our technical support primarily focused on advanced Geocortex Workflow and Reporting support to internal York Region GIS developers. Professional Geographic Information Systems (GIS) Services 22 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. In the fall of 2023, York Region GIS approached DDS to start preparing for the migration from Geocortex Essentials to VertiGIS Studio. As part of this preparation, York Region requested DDS create a template application for VertiGIS Studio Web to incorporate branding standards and create a template to ensure applications provide a similar interface to end users. Additionally, York Region requested DDS prepare an online training course to introduce York Region GIS staff to VertiGIS Studio Web, Workflow, and Reporting. DDS created a customized agenda and presented four hours of training to 30 York Region staff. The training session was recorded and provided for future staff reference. Images Template app with Bike Path Details Open, custom CSS Pitkin County, Colorado Open Space and Trails | Pitkin Outside Web App- Pitkin County, Colorado DDS worked with OST staff to determine the requirements for a VertiGIS Studio replacement to an existing custom JavaScript web map application. The client wanted a powerful and attractive web GIS application that required minimal custom coding so that OST staff could modify it and make minor extensions of its capabilities when needed. The team decided a VertiGIS Studio Web application with some VertiGIS Studio Workflows would best fit these needs. Regular meetings were held with OST staff to discuss development as it unfolded, allowing the client to reassess their preferences for the new application as they developed a better of their data and application architectures. DDS consulted with OST and Pitkin County GIS staff to develop a new schema for OST data to enable the new capabilities requested by the web app, then DDS published these layers using custom symbology and popups Client: Regional Municipality of York, Ontario, Canada Project Dates: July 2016 to present Key Staff: Zack Robison and Tom Neer Deliverables: On-call technical support; VertiGIS Studio Web template; VertiGIS Studio Training Client: Pitkin County Business Information Technical Services Project Dates: January 2023 - Present Key Staff: Tom Neer, Zack Robison Deliverables: Pitkin Outside (currently in UAT due to internal priorities) Professional Geographic Information Systems (GIS) Services 23 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. carefully developed with OST staff in an ArcGIS Enterprise Web Map. DDS trained OST staff on the use of Portal for ArcGIS during this process so that they could update their data display and popups as needed. DDS then developed a VertiGIS Studio Web application with custom styling to bridge OST branding and the branding of the legacy viewer. Finally, DDS developed VertiGIS Studio Workflows to guide user interaction with the map and its features and presented overviews of the technology to OST staff and Pitkin County GIS staff supporting this app. OST staff is currently reviewing the application. DDS developed an ArcGIS Survey123 Form and integrated it directly into the application to receive user feedback and bug reports; the application and feedback form URLs were then sent to identified County staff and public superusers for beta testing before public release. Images App home page, summer theme with theme switcher button highlighted DDS provides on-going ArcGIS Enterprise and VertiGIS Studio design, implementation, development, and technical support services to Pitkin County in support of their enterprise GIS. In 2014, DDS assisted Pitkin County in deploying ArcGIS Enterprise and adding functionality to their web mapping capabilities utilizing Geocortex Essentials. DDS assisted with managing and hosting the County’s GIS data as part of the functionality. DDS also created workflows to guide users through complex tasks that allow users to zoom into features using multiple methods, create detailed parcel reports, data extraction workflow, and mailing lists that notify all property owners within a specified user distance minus the selected parcel. For the last year, DDS has been assisting Pitkin County in migrating their ArcGIS Enterprise from internally hosted servers to a Microsoft Azure tenant and upgrading to the latest version of ArcGIS Enterprise. Pitkin County has also started onboarding various departments into Portal for ArcGIS and expects to complete the deployment of their new production environment in the summer of 2023. Professional Geographic Information Systems (GIS) Services 24 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. VertiGIS Studio Implementation and Technical Support - SDI Presence for Chicago Department of Aviation (CDA) SDI Presence contracted DDS to provide support for a modern replacement of the ELS application utilized by Midway (MDW) and O’Hare (ORD) Airports. This solution utilizes both Esri ArcGIS Enterprise and VertiGIS Studio. In addition to providing technical and implementation support to SDI and CDA, DDS was contracted to develop and implement: NOTAMs Dashboard – In conjunction with ATC, duty supervisors frequently issue Notices to Airmen (NOTAMs). NOTAMs are entered into FAA’s Direct Digital NOTAM site. NOTAMs issued at ORD and MDW must be retrieved, parsed, and inserted into a SQL database for required local recordkeeping. Duty supervisors must acknowledge new and closed NOTAMs and add metadata to the NOTAM record through its lifecycle. DDS developed a custom Java application (only FAA supported option) to injest data from the FAA’s NOTAMs API. The imported NOTAM records are provided to CDA duty supervisors through a dashboard interface developed in VertiGIS Studio Web with a variety of complex VertiGIS Studio Workflows. Email Parser – Airfield operations receives email messages from several sources sent to unattended email accounts. DDS developed a Python script that collects all email text, metadata, and attachments and import them into a SQL database. AMOS Field Application – CDA Field Operations staff needed a field-capable replacement for their existing Microsoft Silverlight office application, which automates and validates inspection data collection. The field application was a VertiGIS Studio (VS) Web app with VS Workflows to process complicated business logic, such as process blocking and data validation. DDS developed the most complex tools for this app, automating inspection processes based on data schemas with multiple levels of nested hierarchies and relationships to outside data sources. DDS also consulted with CDA staff to train them in developing simpler VS workflows for managing data in more traditional schemas. NOTAMs Dashboard Client: SDI Presence / Chicago Department of Aviation Project Dates: July 2022 to Present Key Staff: Tom Neer, Zack Robison, Pete Skull Deliverables: NOTAM Dashboard and scraper, Email Parser, AMOS Field Application, VertiGIS Studio technical support. Professional Geographic Information Systems (GIS) Services 25 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Section 6 – Description of Proposed Approach to the Project When Phase 1 is completed, the City of Bozeman’s (City) GIS Roadmap will serve as a reference and guide for the GIS & Asset Management Division and their stakeholders throughout the City. This roadmap will outline the overall design and vision for an enhanced ecosystem of GIS and its integrated, essential technologies. The roadmap will also provide a framework to achieve the desired state of functionality in the form of recommended actions and the sequence of steps to achieve them. To develop this document, AppGeo will collaborate with the GIS & Asset Management staff and their stakeholders to identify priorities, evaluate gaps, and develop an actionable approach. Phase 2 will consist of AppGeo potentially performing some or all the work recommended by the GIS Roadmap. Phase 1 – Needs Assessment & Roadmap The work plan presented below describes how we will engage with the City’s project team and the broader stakeholder community to develop the highest quality plan. AppGeo will apply a collaborative “open door” approach to working with the GIS & Asset Management team and their departmental stakeholders to facilitate information gathering and requirements definition. We anticipate a close working relationship with the City’s core team throughout the project, which includes several planned interactions such as: The project initiation meeting to discuss approach, project management, stakeholders, etc. We anticipate the core team’s participation at all interviews and meetings. We employ a standard deliverable iteration of a draft delivery, draft review meeting, City project team review & provide feedback, AppGeo incorporates feedback, and City project team final review and acceptance A regular cadence of status meetings - AppGeo recommends bi-weekly status meetings to start. Live document collaboration - all draft documents may be shared with the entire project team in a live collaboration environment where suggested editing and comments can be used and progress is always visible. Phase 1 will include the following major tasks: Task 1: Information Gathering In Task 1, AppGeo will focus on convening the project team, conducting research, and commencing information gathering through a carefully crafted online survey and targeted interviews. Task 1.1: Project Kick-Off & Core Team Interview This task includes project management activities that will continue through the project lifecycle, ending with project closeout. AppGeo will launch the project with a kickoff meeting between AppGeo team members and the City’s core project team, consisting of the Strategic Services Director, GIS Program Manager, and GIS Asset Management Manager. This meeting will introduce key players and familiarize Professional Geographic Information Systems (GIS) Services 26 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. the AppGeo team with background information. The group will review the project schedule and cover all administrative details associated with project management and coordination. This meeting will also lay out key dates and plan for the information-gathering activities. AppGeo will also use this meeting to initiate a discussion with the core team about high-level objectives and challenges and to solicit background documentation -- existing assets, data, and other pertinent information – to begin our review. After reviewing the provided documentation, AppGeo will follow up with a second interview focused on clarification and further exploration of the kickoff discussion. Task 1.2: GIS & Asset Management Information Gathering AppGeo may request the following types of data and information during this discovery phase (this is a suggested, not exhaustive list): List of project stakeholders, roles, user types GIS Staff Job Descriptions Organizational charts List/description of current and planned GIS-related implementation projects Core GIS datasets and associated metadata if available GIS processes documentation Past GIS-related reports License deployment/ utilization summary Links to any existing online mapping Existing GIS, VertiGIS, and Cityworks system architecture diagrams/documentation After an initial assessment of existing conditions through conversations with the City’s project team and a review of pertinent background information, AppGeo will develop an online survey to distribute to GIS and Asset Management stakeholders. Most of our needs assessment projects include an Online Stakeholder Survey, and they have proved to be an efficient and candid way to collect baseline information and derive insights from stakeholders. We also typically achieve high response rates with these as they require a low level of effort to participate. The survey will cover both the technical and organizational topics that drive the assessment. We will use online survey tools to efficiently summarize the results for inclusion in our roadmap findings. AppGeo will prepare and review the draft survey with the core team, incorporate feedback, provide the final survey link for distribution by the City, and compile and analyze the survey results. In tandem with the survey, we will conduct technical assessments of the City’s GIS and Asset Management systems. Assessments will begin with brief orientations with the systems managers/ administrators to review the ArcGIS Enterprise, Cityworks, and Geocortex sites and obtain access for further independent review by the AppGeo team. Our technical team will review the architecture and configuration of each site. The team will also discuss current usage patterns, required functionality, and anticipated challenges and constraints for each system. Task 2: Roadmap Development Task 2.1: SWOT and Recommendations Development AppGeo will apply a SWOT Analysis (strengths and weaknesses, opportunities and threats) framework for determining where the greatest opportunities are for improvements that meets the City's objectives, and for formulating our recommendations for program growth. The SWOT helps to organize and present our assessment of the GIS assets, capabilities, and gaps. Strengths and weaknesses focus on Professional Geographic Information Systems (GIS) Services 27 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. characteristics of the current program and systems. Opportunities and threats refer to factors that may impact the program. AppGeo will develop recommendations to close gaps identified in the SWOT analysis and optimize the GIS and Asset Management program. The SWOT assessment findings and associated recommendations will be reviewed in a meeting with the City project team. We will facilitate discussion of the findings and recommendations and make revisions as needed. This is a key step that allows for the core team to provide feedback and guidance on priorities, constraints, resources, and goals. These cycles of review will ensure that the roadmap is of the greatest utility and best fit for the City going forward, and that it can be practically implemented. Task 2.2: Roadmap Development By this stage, we generally understand what will be included in the roadmap, and in this task, we will start compiling our findings for review and revision. We propose that the GIS Roadmap will include the following components as a technical memo: Executive summary Methodology Programmatic and technical recommendations Implementation plan The roadmap will present a brief overview of the information gathering activities and planning process. We will summarize the most important survey findings and highest priority items identified in our SWOT analysis. Based on our findings and technical assessments, we will present prioritized recommendations to achieve programmatic growth and systems optimizations. Recommendations will include implementation tasks, their sequences, and budget estimates. Technical recommendations will include additional details required for implementation. For Cityworks, the team will develop an implementation outline of the recommended upgrade path from 15.8.3 to 23.x. This document will detail critical decisions to be made, recommended actions, required actions, specific steps to performing the upgrade, and team responsibilities. For VertiGIS, the team will similarly outline the migration path from the City’s Geocortex applications to VertiGIS Studio. Every client’s approach to this differs, and our approach would reflect the City’s capabilities and expectations. Some clients prefer to have a consultant perform the migration, whereas others have the internal resources to perform the migration but only require support to learn the new software. Unless otherwise directed, with the limited Geocortex sites deployed, our approach would be to train City staff and be a resource for the City rather than performing the work ourselves. For any recommended optimizations related to ArcGIS Enterprise and ArcGIS Online, the team will also identify required actions, based on best practices, as well as the resources required to complete them. The cycle of roadmap development will begin with a draft version provided to the City for review and consolidated feedback. We would welcome feedback from all members of the City’s core team. In the next stage, we will incorporate the City’s feedback and finalize the document. The SWOT inventory and survey responses will be included as appendices in the roadmap. At the completion of this task, AppGeo will provide a final version of the roadmap for approval and then summarize the approved roadmap’s content in a presentation to the core team and key stakeholders. Professional Geographic Information Systems (GIS) Services 28 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Phase 2 – Roadmap Implementation In Phase 2 of this project, AppGeo can offer the following assistance to implement the roadmap recommendations developed in Phase 1: Cityworks Implementation Support: Up to 80 hours of as-needed support, plus project management, anticipated to include tasks such as report migration (Crystal reports to Active reports), user training (Respond, administrative, etc.), Respond-specific configurations (UI updates via Style, Dashboard and Query creation, Sidebar Menus, etc.), documentation updates. VertiGIS Implementation Support: on-call technical support (current pricing is based on this approach) or direct migration of the existing Geocortex Essentials sites and Workflows to VertiGIS Studio depending on the City’s preferences; in our review of the City’s public-facing Geocortex Essentials sites, we recommend providing on-call support to City GIS staff to assist in migrating these sites rather than performing the work ourselves to equip City staff to more fully leverage VertiGIS Studio both internally and externally; preparation of Standard Operating Procedures for workflows required to support and maintain the deployed VertiGIS applications ArcGIS Optimization Support: Up to 80 hours of as-needed support, plus project management, to include tasks such as assistance with an in-place upgrade of ArcGIS Enterprise, post-upgrade assistance with management of Portal services and content, preparation of testing plans and other go-live readiness support, review of existing backup/ disaster recovery protocols and preparation of best practices guidance, technical design assistance to extend the ArcGIS Enterprise architecture. Knowledge Transfer: guidance on best practices for developing and publishing map services to support enterprise applications, robust documentation of quality control measures and database maintenance best practices for knowledge transfer from our expert team to the City staff who own the system, user guidance for staff across the City’s 29 stakeholder departments Technical and Programmatic Assistance: access to a full range of technical and programmatic geospatial services on an as-needed basis including mapping and spatial analysis capabilities, configuration of ArcGIS applications and services as well as custom application development, data and program governance advising, process improvement guidance, and custom packages that bundle our services for tailored, on-going support. Project Management Project management will occur throughout all phases and tasks of the project. This section presents our commitment and approach to project management. AppGeo Approach to Project Management AppGeo follows the best practices of the Project Management Institute’s Body of Knowledge (PMBOK) and uses targeted business systems to support its Project Management best practices including: task management, video conferencing, web-based data and document libraries, time management and reporting systems, and online Gantt charting and budgeting tools. At the outset of this project, we will tailor the optimal combination of these systems for providing project transparency and streamlining communications. To provide ongoing communications throughout the project, AppGeo will use tools that make it easy to share and keep track of information. In addition to the use of these systems and tools, our project management best practices include: Professional Geographic Information Systems (GIS) Services 29 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. AppGeo is dedicated to meeting the City’s requirements through listening, collaboration, innovation, and service, and this includes the skillful management of the project and relationship, in addition to the use of appropriate tools. AppGeo’s experience with strategic planning projects is that high quality is achieved through full involvement on the part of our clients and open lines of communication. To this end, these are the key ways that we will collaborate with the City, and keep the project on target: We propose experienced project management staff who understand the overall objective. Our project manager and team are skilled at project management, but just as importantly they possess a combination of enterprise GIS planning expertise and practical experience in implementing and supporting enterprise systems. They know what a modern, comprehensive GIS program is made of and how to create a plan to achieve it. We will follow an agreed-upon plan for communication. At the outset of the project, our Project Manager will meet with the City team to establish a communication plan that addresses the frequency, scope and content of routine communications covering both relationship management and task-level reporting. We will follow the schedule of deliverables. Our project work plan presents the delivery schedule that we are committed to. For each project deliverable, we will work with the City’s project manager to usher along the progress on reviews and revisions. Our work plan gives careful consideration to the timing needed to move through these stages. We will use methods that make it easy to share information. We will use some or all of the following modern tools/methods for conducting meetings and sharing information: A shared online repository for document storage and sharing (notes, plans, deliverables, schedules, etc.) in MS Teams or SharePoint SmartSheets for task planning/scheduling/tracking Unanet accounting system for invoicing and staff time tracking Asana (http://asana.com/) for task management and tracking Teams video conferencing for meetings Assigning a PMP-certified Principal in Charge and/or Project Manager, where possible, to each project, who are responsible for the project plan, resource planning, and project completion schedule Working with our client to carefully define a plan for project administration, including the project schedule and the nature and content of deliverables, communications, and roles and responsibilities Maintaining regular communication on the progress of project activity, including milestones, issues, resolution, change management, and work completed Using our business systems for full accountability and transparency throughout the project life cycle Professional Geographic Information Systems (GIS) Services 30 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Risk/Issue Management and Escalation AppGeo deals with issue resolution across all types of services that we provide - professional consulting services, technical help desk support, hosting and website maintenance contracts, and on call support for mission critical web applications. These require different approaches to problem tracking, escalation, and resolution. Thus, we are adept at working with our clients at the outset of every project to establish mutually agreed-upon logistics and protocols for problem escalation and risk management. Examples of key risks and mitigation strategies in this type of project include: Risk Mitigation Plan (Plan to Reduce Probability) Key stakeholders introduced late in the process Identify all known stakeholders and ensure they are active participants as early as possible. New information introduced late in the process Use early project communications such as the KO and project status meetings to identify and collect all anticipated types of information as early as possible. Ask meeting attendees to come prepared with notes, ideas, documents, data, etc. Lack of stakeholder engagement Provide as much advance notice to stakeholders as possible about expectations placed upon them. Use technology to assist in communicating with stakeholders with demanding schedules. Educate stakeholders as to the benefits this project will provide to them to increase their enthusiasm for its success. Technology/systems are inaccessible Ensure the project team begins coordinating with the appropriate parties early on to provide the AppGeo team access. Provide AppGeo with all relevant project contacts information and allow direct communication with relevant parties. Inability to reach consensus Work with the project team to prioritize recommendations collaboratively. Establish priorities such as what has the largest impact on the most users, what provides the "biggest bang for the buck", or what helps achieve the vision most effectively. Delayed or incomplete feedback and/or acceptance of deliverables Maintain awareness of schedule and task dependencies, ensure those responsible for feedback or acceptance are aware of the due dates, adjust schedule as needed/approved by Project Sponsor in situations where deemed appropriate due to uncontrollable circumstances. Project team resources become unavailable or non-responsive Build teams that have the availability to fully support this project and make themselves available. Be prepared to work on aspects of the project that do not involve the client in the event they become unavailable due to a priority operational need. Make sure other staff outside of the team are aware of the project and have access to project resources in the event they are called on to step in. Roles and Responsibilities of project team members are not clear Tasks are identified by the responsibility owner in the project plan/schedule in the Assigned To column. In addition, using the Communications Plan discussed at the KO meeting. If necessary, develop a project RACI chart. Professional Geographic Information Systems (GIS) Services 31 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. A known event, outside the project, that could influence it Client will keep in close communication with the AppGeo Project Manager about the timing of the event and potential effects on the project (an example may be a planned roll-out of a new business system, or a move to a new facility) AppGeo’s best practices include documenting such a risk register at the outset of each project in order to forecast what problems the project may encounter and to proactively plan for them. For example, AppGeo developed a similar risk register at the outset of our Strategic Plan project for CAL FIRE and it was maintained by the AppGeo PM throughout the project lifecycle. The risk “CAL FIRE Staff becomes unavailable due to priority operational needs”, did in fact occur: the project was underway during the 2018 fire season which is notable for the large and devastating Camp Fire. AppGeo continued to perform any work on the project that did not require input or coordination from the CAL FIRE staff, but ultimately the project was delayed due to this unfortunate event. Later, a change order was processed which resulted in a revision to the contract end date. The existence of a problem may be reported by any one of the AppGeo team that is working on the project, or by a member of the client team. Regardless of who is reporting the problem, the report will be made directly to the AppGeo Project Manager who is responsible for maintaining the risk log, communicating with the client project manager about the issue, and acting as the gatekeeper to properly and thoroughly document the issue being reported. If there is the potential that the overall project budget or timeline will be significantly impacted, or if the overall progress of the project is held up by the need to resolve an issue, then escalation will occur immediately. The AppGeo Project Manager will bring the issue to the attention of the Principal in Charge so that a resolution plan can be implemented quickly, with immediate notification to the City’s project manager. AppGeo project managers work with our clients at the outset of a project to establish an appropriate cadence for reporting on project status, typically done during a status meeting. This mutually agreed upon reporting schedule will include the frequency of reporting on any project issues. Issue priority may be a factor in determining the frequency of feedback. For example, it may be established that an issue that has been escalated is reported on more frequently. Change Management In the event of a change of scope, the project team will meet to discuss impacts and mitigation strategies. Proposed scope changes should be provided to the AppGeo PM, who will then review the proposed change and determine any effect on budget and schedule. The AppGeo PM will then discuss the impacts with the City’s project manager. Any changes will be mutually agreed upon by both the City and AppGeo teams. Any changes to the AppGeo scope will be documented, shared with respective Principals and Project Sponsors, and communicated to stakeholders, as appropriate. AppGeo has a template form that may be used in the event of a Change Request. It provides a description of the requested change, and the impacts on scope, schedule, quality, and cost. Professional Geographic Information Systems (GIS) Services 32 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Status Updates Status Meetings Throughout the Project. The core AppGeo project team members will meet with the City via virtual web meetings. Meetings the City can expect throughout the project include: Administrative Kickoff meeting City Project Team Interview Technology Assessment Interviews Regular bi-weekly status meetings Draft deliverables review meetings where necessary Presentation of final draft Roadmap Project close-out meeting Reporting on Project Status. To keep the City continually aware of project status, AppGeo will use a secure, web-based collaboration tool that will provide a consistent, always-available sharing environment in which project meeting notes and other reporting information can be managed and archived. AppGeo also uses Smartsheet, a web-based project planning Gantt chart that exposes the project tasks, milestones, start date, end date, dependencies, and percent complete. The City’s team will have a full view of these aspects of the project and can confirm at any point that the team is on track. In addition to this ‘evergreen’ way of reporting on project status, AppGeo will provide notes on all status meetings recording all decisions reached and all action items. Professional Geographic Information Systems (GIS) Services 33 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Section 7 – Proposed Schedule AppGeo proposes to complete Phase 1 of the project within a 7 month period, assuming a start date of May 1, 2024. We remain flexible on schedule, however, and can adjust to meet key external milestones and/or accommodate the City project team. We have developed a detailed proposed project schedule, using the web-based SmartSheets tool, which can be viewed interactively at the following link: https://bit.ly/3PiBOsg. In addition to this interactive link, we present the following static views of our project schedule for Phase 1: High-level view of AppGeo’s project schedule and work plan (https://bit.ly/3PiBOsg) Professional Geographic Information Systems (GIS) Services 34 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. View of Phase 1 Task 1 of AppGeo’s project schedule and work plan (http://bit.ly/38mAhfm) View of Phase 1 Task 2 of AppGeo’s project schedule and work plan (http://bit.ly/38mAhfm) Professional Geographic Information Systems (GIS) Services 35 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. AppGeo’s approach to managing the schedule and communicating task performance involves: A baseline schedule is recorded The AppGeo PM manages and maintains the schedule, keeping the live SmartSheet schedule up-to-date, real-time, if there are changes. Changes to the schedule are made collaboratively with the City during status meetings or via other lines of communication. The AppGeo PM updates the % complete field on the SmartSheet schedule to track task progress and completion on an on-going basis. The AppGeo PM also communicates task progress and reviews the schedule at status meetings. Professional Geographic Information Systems (GIS) Services 36 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Section 8 – Present and Projected Workloads While it is not feasible to provide a list of all the ongoing projects at Sanborn, it is feasible to state that we can assume the City’s project with our available resources and key personnel. Our current and anticipated workloads do not directly conflict with the City’s project timeline. The AppGeo project manager is responsible for ensuring the staff resources meet their project commitments. We employ resource planning tools and have specific weekly resource planning meetings to ensure staff workloads are balanced and project deadlines are met. We use Resource Management systems to forecast workloads and secure staff commitments well in advance. Professional Geographic Information Systems (GIS) Services 37 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Section 9 – Recent and Current Work for the City of Bozeman The AppGeo division has not contracted directly with the City of Bozeman but we have worked with City staff as stakeholders during the development of the Montana State Library’s Strategic Plan. There were multiple MT GIS Stakeholders from Bozeman who participated in the survey, interviews, and workshop. These included: Jon Henderson, Strategic Services Director | Interview and workshop participant who was very articulate and challenged his colleagues to think about equity and diversity as issues on the horizon that GIS will support. Jon shared that Bozeman was moving towards a more mature governance model with a strategic plan that links all the other sub-units under one vision to assign goals and accountability. Jon emphasized that the City’s one goal is to stay relevant and educate decision makers with support for what they need to get their job done. He discussed how GIS has been successful in Bozeman and underlies the conversation for many things such as equity and inclusion and allocating ARPA funding. Jenny Connelley, Engineering Tech | Survey respondent who self-identified as a map user, was very supportive and aware of MSL’s efforts, and uses their geospatial products frequently. Jenny indicated that MLIA grants, training opportunities, data sharing with MSL and standards/best practices are important. Chris Saunders, Community Development Manager |Survey respondent who self-identified as a non-technical map user. They were very supportive of MSL, uses some of their geospatial products, especially Cadastral. Chris indicated that data sharing with MSL, and setting priorities for online mapping in Montana was important. Sanborn’s Mapping division worked with the City from 2012 - 2015 supporting the City’s impervious mapping efforts. Professional Geographic Information Systems (GIS) Services 38 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Section 10 – References AppGeo References Contact Name Erin Fashoway State GIS Coordinator Phone 406.444.9013 Email efashoway@mt.gov Customer Name Montana State Library Contact Name Megan Compton, Indiana Geographic Information Officer Phone (317) 234-5889 Email mcompton@iot.in.gov Customer Name Indiana Geographic Information Office Contact Name Mark Holmes Phone 517.285.6592 Email HolmesM3@michigan.gov Customer Name State of Michigan Department of Technology Contact Name William (Bill) Renault Phone 781 246-6308 Email wrenault@wakefield.ma.us Customer Name Town of Wakefield, MA Contact Name Robert Buck Phone 209-937-8065 Email robert.buck@stocktonca.gov Customer Name City of Stockton, CA Contact Name Ryan Marquez Phone 978-325-5335 Email RMarques@gloucester-ma.gov Customer Name City of Gloucester MA KCI References Contact Name Amy Famiglietta Asset Management System Coordinator Phone (423) 643-7432 Professional Geographic Information Systems (GIS) Services 39 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. DDS References Contact Name Mary Lackner, Geospatial Lead BITS Email Mary.lackner@pitkincounty.com Customer Name Pitkin County Business Information Technical Services (BITS) Contact Name Claudia Latea, Manager of Business Solutions Email Claudia.latea@york.ca Customer Name Regional Municipality of York, Canada Contact Name David Flack, Senior GIS Analyst Email dflack@sdipresence.com Customer Name SDI Presence, LLC Email afamiglietta@chattanooga.gov Customer Name City of Chattanooga Completion date Various, Support Continues Size 182,000 Assets Managed Parks, Facilities (Building Maintenance), Wastewater Collection, Wastewater Treatment, Stormwater, Water Quality, Trees, Streets, Traffic Signals Contact Name Mattie Neely, PE - Engineering Manager Phone (865) 925-3921 Email mattie.neely@lebanontn.org Customer Name City of Lebanon Completion date Public Works – April 2023 Other Departments – In Progress Size 41,000 Assets Managed Streets, Roads, Facilities, Stormwater, Signs, Gas, Wastewater Treatment Contact Name Marvin Davis GIS Manager Phone (302) 284-7410 Email mdavis@morgantownwv.gov Customer Name City of Morgantown Completion date September 2023 Size 29,000 Assets Managed Streets, Pavement, Signs, Sidewalks, Guardrails, Street Lights, Traffic Signals, Retaining Walls, Facilities (Building Maintenance), Fleet Professional Geographic Information Systems (GIS) Services 40 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Section 11 – Price Proposal for both Phase 1 & Phase 2 Phase 1 Sanborn will provide the scope of work for Phase 1: Roadmap for a total all-inclusive, fixed price of $112,044 based on the following table of fees by task. Monthly invoices for each task will be submitted on a percent complete basis. Task Number Task Description Billing Type Fee 1 Information Gathering and Needs Assessment FFP $46,237.00 2 Recommendations and Roadmap Development FFP $65,807.00 Total Total $112,044.00 Phase 2 Sanborn will provide the scope of work for Phase 2: Implementation using a combination of time and materials and fixed price fees based on the table of estimated fees below. Task Number Task Description Billing Type Estimated Fee 1 ArcGIS Optimization Support (Up to 80 of as-needed support plus project management) FFP $16,532.00 2 Cityworks Upgrade Implementation Support (Up to 80 hours of KCI as-needed support) and 4 hours of AppGeo Project Management FFP $17,413.00 3 VertiGIS Upgrade FFP $26,690.00 4 Technical and Programmatic Assistance (including documentation/ knowledge transfer) TBD T&M $50,000.00 Total Total $110,635.00 Professional Geographic Information Systems (GIS) Services 41 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. For Time and Materials tasks, invoices will be submitted monthly based on hours worked on each task. A table detailing the 2024 labor billing rates used for the time and materials billing is included below in the table of labor billing rates. The standard annual rate escalation is 5% per year. Labor Category 2024 Hourly Rate Principal in Charge $306.85 Consultant IV $262.32 Consultant III $230.77 Consultant II $192.34 Consultant I $143.78 Analyst III $133.35 Analyst II $130.80 Analyst I $110.74 Professional Geographic Information Systems (GIS) Services 42 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Appendix Affirmation of Nondiscrimination Attachment A NONDISCRIMINATION AND EQUAL PAY AFFIRMATION ____________________________________(name of entity submitting) hereby affirms it will not discriminate on the basis of race, color, religion, creed, sex, age, marital status, national origin, or because of actual or perceived sexual orientation, gender identity or disability and acknowledges and understands the eventual contract will contain a provision prohibiting discrimination as described above and this prohibition on discrimination shall apply to the hiring and treatments or proposer’s employees and to all subcontracts. In addition, ____________________________________(name of entity submitting) hereby affirms it will abide by the Equal Pay Act of 1963 and Section 39-3-104, MCA (the Montana Equal Pay Act), and has visited the State of Montana Equal Pay for Equal Work “best practices” website, https://equalpay.mt.gov/BestPractices/Employers, or equivalent “best practices publication and has read the material. ______________________________________ Name and title of person authorized to sign on behalf of submitter Professional Geographic Information Systems (GIS) Services 44 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Resumes Professional Geographic Information Systems (GIS) Services 45 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Michele Giorgianni, (GISP), (PMP) Principal, and Senior Project Manager Michele is a certified Project Management Professional (PMP), and a GIS Professional (GISP) with deep experience in all aspects of GIS implementation for local, state and regional governments. Ms. Giorgianni is a NSGIC Geospatial Excellence Award winner. Her clients and the NSGIC community recognize her as a Catalyst in the field, helping states like Indiana and Montana achieve success through her strategic planning leadership. She has 20 years of experience in the GIS field, with the past 16 years at AppGeo, where she has managed dozens of GIS consulting projects. She recently managed the development of GIS Strategic Plans for Georgia, Indiana, Montana, Michigan, and CAL FIRE, a strategic plan and implementation plan for Wakefield, MA, co-authored the Technology Roadmap for the City of Stockton, CA, and a GIS Strategic Plan for Tacoma, WA, and has been a team member on many other GIS strategic planning projects. Michele recently delivered a business plan to Improve Geospatial Data Governance for the Montana State Library and is working on a GIO Value and Benefits study for the State of Indiana. Michele is also the Chair of the State of Rhode Island’s GIS (RIGIS) Executive Committee and assisted in updating the RIGIS 5-Year Strategic Plan, in addition to continuously working on implementing many aspects of the plan in her role on the Committee. She is also a member of the State of Connecticut Strategic Plan subcommittee. She has worked as a GIS professional in positions in state and municipal government. She holds a Master’s in Environmental Science and Management from the University of Rhode Island and a BA in Geography from New Mexico State University. Work History 2022 to Present: Applied Geographics division of The Sanborn Map Company, Inc., Principal / Senior Project Manager 2020 to 2022: Applied Geographics, Inc., Principal / Senior Project Manager 2007 to 2019: Applied Geographics, Inc., Senior Project Manager 2006 to 2007: Rhode Island Department of Environmental Management (RIDEM), GIS Intern 2005 to 2006: Town of Cumberland, RI, GIS Consultant 2002 to 2005: Coast Realty LLC, GIS Specialist (East Providence, RI) 2001 to 2002: US Fish and Wildlife Service, GIS/GPS and Fisheries Intern (Panama City, FL) Selected & Relevant Project Experience Local Government Managed Services Program (Spatial IQ for MapGeo) (2017 - ongoing) - Manager of AppGeo’s Local Government Spatial IQ for MapGeo program which provides GIS Managed Services to dozens of local government clients throughout New England. Education MS in Environmental Science and Management (Concentration in GIS / RS), University of Rhode Island, 2007 BS in Geography, New Mexico State University, 2001 Professional Certifications Project Management Institute, certified Project Management Professional (PMP), 2018 GIS Certification Institute, Geographic Information Systems Professional (GISP), 2006 Professional Geographic Information Systems (GIS) Services 46 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. State of Georgia - Geographic Information Officer Strategic Plan (2021 - 2022) - Key performer and strategist working with the Georgia GIO to establish the Georgia Geospatial Advisory Committee and develop a five- year GIO strategic plan. Montana State Library - GIS Coordination Five-Year Strategic Plan and Companion Business Plan (2021) - Project Manager and key contributor to the development of a comprehensive geospatial strategic and business plan for the State of Montana. Indiana Geographic Information Office - Statewide GIS Strategic Plan (2021) - Project Manager and strategic planner in the development of a comprehensive geospatial Strategic Plan and Business Plan for the State of Indiana. State of Michigan Department of Technology, Management & Budget, Center for Shared Solutions (DTMB CSS) - GIS Strategic Plan - Project Manager and strategic planner in the development of a comprehensive geospatial Strategic Plan for the State of Michigan. City of Albany, NY - GIS Services (2021) - Principal in Charge, overseeing AppGeo’s delivery of as-needed GIS support services and enhancements to the City’s MapGeo platform. New York University Stern School of Business - PACE Finance Mapping Tool (2020 - 2021) - Project Manager for initial application development in support of NYU Stern’s objective help connect funding institutions and building owners to drive investment in concrete carbon emissions reduction projects under Local Law 97 (LL97) which is part of the Climate Mobilization Act. Stern’s goal is to ultimately launch a web application that will assist with identifying the patterns of ownership and lien holders for the worst offending buildings and guide the prioritization of outreach for property assessed clean energy (PACE) loans and energy efficiency retrofits. AppGeo will initially support Stern with basic website development and hosting of the application. Stern, with their other partners, plans to then utilize the initial website to craft a minimum viable product (MVP) in an effort to gain backing and funding for the concept before building the fully featured PACE Finance Mapping Tool. State of North Dakota Statewide Parcel Dataset and Program Support (2020 – present) – Project Manager for development of a statewide parcel dataset. Phase 1 included stakeholder engagement, data collection and inventorying, pilot, and full statewide tasks to create ETLs and launch mechanism for ongoing maintenance on State’s server. Phase 2 included development of parcel data for counties without data, and integration into the statewide dataset and maintenance tool. AppGeo continues to perform ongoing maintenance and support of the Parcel Program. Town of Wakefield, MA Department of Public Works (2020 - 2021) - Project Manager, and key investigator and contributor to the development of the DPW’s GIS Strategic Plan, and GIS implementation. Santa Barbara County Association of Governments (SBCAG) (2018 - 2019) - Project Manager, principal investigator for enterprise-wide GIS Needs Assessment and strategic plan, and co-author of final report. Subsequent implementation of region-wide mapping platform, MapGeo. California Department of Forestry and Fire Protection (CAL FIRE) (2018 - 2019) - Project Manager, principal investigator and co-author of CAL FIRE’s GIS Strategic Plan. Advise and plan for the incorporation of leading edge technology into the geospatial workflows of this major fire fighting organization (10,000 employees). The work includes assessment of current technologies, geospatial data, workflows, and program area activities, including guidance for the agency to take advantage of modern strategies for stewardship and governance, and a path by which its GIS model can continue to position itself at the forefront of industry trends. State of Vermont, Agency of Transportation (VTRANS) (2016 - 2017) - Provided overall project management to the State of Vermont in planning and developing a statewide parcel database. Develop specs for the State’s RFP and a plan for managing the vendors’ data submissions; develop a QA/QC process; review and revise the digital parcel data standard; risk assessment, documentation, and budgeting. City of Tacoma, WA (2016 - 2017) - GIS Strategic Plan - Online survey, interviews, and workshop for information gathering phase, needs assessment and implementation planning, co-authoring final report. The work included understanding the City’s needs with regard to GIS technology and coordination, recommending Professional Geographic Information Systems (GIS) Services 47 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. new managerial configurations, determining how best to deploy Esri and non-Esri geospatial technologies, and a work plan by which to implement these changes. State of Connecticut Department of Emergency Services and Public Protection (DESPP) (2016) - Project Manager assisting CT FirstNet to develop an implementation strategy, including GIS mapping and analysis support for public outreach, baseline data collection, information analysis, technical reporting, and developing data requirements. State of Connecticut General Assembly (CGA) – Managed support to CGA with 2011 redistricting project involving development, and alignment to 2010 census geography of many years’ of local voting district boundaries from all towns in the state, development of statewide address locator and geocoding of registered voters, analysis and improvements to geocoding results, provided various other as-needed analysis and mapping support requests throughout project timeframe. State of Connecticut, Department of Utility and Control (DPUC) – Data integration and collection support for municipal parcel data collection process, migrated existing Cadastral GIS data layers in various database schemas for several CT Towns into a standardized production model, developed address locator from standardized statewide address points, parcels, and TeleAtlas street data, and developed internal QA/QC guidelines and checks for processing of provider data, to support the Statewide Broadband Mapping project. Pitney Bowes Group 1 – Data integration and collection support for municipal parcel data collection process covering the states of Connecticut, Massachusetts, and Rhode Island. Connecticut Capitol Region Council of Governments (CRCOG) (2014-2016) - Project Manager for multiple projects to collect, standardize and serve through Web application COG geospatial data layers. Managed processes for source data collection from member towns, reviewing data models, alignment, mismatch assessment and processing, parcel data updates management, land use data conformance and integration, website data loading, testing and rollout. Southeastern Connecticut Council of Government (SCCOG) (2014-2017) - Project Manager for a series of projects including implementation of regional parcel mapping application; subsequent migration of the application to newer technology, MapGeo; Parcel data creation activities including conversion, ETL, data modeling and Geodatabase creation, spatial indexing, standards conformance to CT state standard, QC, clean up and topology error corrections Town of Easton, MA Department of Public Works - Needs Assessment, Analysis and Recommendations Stratford, CT – Live link, desktop and license manager installs & upgrades, abutter tool configurations, management of storm and sanitary sewer systems data development project including coordination of large scanning task and linking of documents, address points development, linking sewer billing. Town of East Hampton, CT – Managed Town-wide parcel automation project including QA/QC of data, map creation, linking to CAMA and training Town staff on CAMA mismatch resolution process, as well as incorporating parcel updates and subdivisions. Managed GIS website development project including organization and symbolization of data layers, loading data to SDE, testing, data layer creation and management including zoning, address points, sanitary sewer and storm drainage system networks, developed data dictionary, street conditions inventory, town-wide street map, PA-490 Farm and Forest map, Public Lands map, historic district data and map development, sewer permit inventorying and integration into GIS website and ArcReader, trained Town staff on web application, published and trained WPCA staff on use of ArcReader desktop application. Professional Geographic Information Systems (GIS) Services 48 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Maggie Cloos Project Manager Ms. Cloos is the newest member of the AppGeo division. Joining us after 8 years as the GIS Manager at the Port of New Orleans, Ms. Cloos brings extensive experience managing GIS applications, projects, and technology. At the Port, Maggie was tasked with implementing Esri Enterprise for the entire organization. In her role, she managed the implementation, met with internal stakeholders, documented their needs and business requirements through needs assessments, facilitated discussions, and configured Esri applications and solutions to meet the needs of the Port’s departments and staff. Her interdepartmental project supporting hurricane preparedness and response earned an Esri Special Achievement in GIS award in 2023. Work History Project Manager, Applied Geographics division of The Sanborn Map Company, Inc. (2023 – present) GIS Lead, Port of New Orleans (2017 - 2023) Professional Activities 2019-2021 – President (‘20), Vice President (‘19), Past President (‘21), URISA Louisiana Chapter Relevant Project Experience State of Indiana Geographic Information Office – Value and Benefits Study (2023 - ongoing): Primary performer in summarizing and analyzing IGIO cost data to determine potential savings created by the office for state agency and county stakeholders. Rhode Island Department of Transportation – HPMS Reporting and Support (2023 – ongoing): Business analyst developing programmatic documentation of HPMS reporting activities and identifying strategies for process improvement with data management and stakeholder coordination. City University of New York – Solar Roof Study (2023 – ongoing): Production team manager coordinating data development to analyze available area for rooftop solar equipment installation. City of Gloucester, MA Department of Public Works – GIS Support Services (2023 – ongoing): Enterprise system consultant supporting server administration, data migration, and content development for Public Works department’s ArcGIS Enterprise deployment. City of Columbus, OH – Land Cover and Urban Tree Canopy Assessment (2023-ongoing): Coordinating subcontractor activities and deliverable iterations for stakeholder group review in multi-jurisdiction tree canopy assessment project. Confidential Agricultural Investment Firm (2023-ongoing): Business analyst supporting governance development for user administration and management of ArcGIS Enterprise services and content. Port of New Orleans GIS Manager (06/2018-06/2023), GIS Analyst (03/2017-06/2018), GIS Committee Chair (04/2016-03/2017): Served as GIS lead for the organization from initial steering committee to mature Education Graduate Certificate in Geographic Information Science - Louisiana State University, Baton Rouge, LA, 2019 B.A. in History - Sewanee: The University of the South, Sewanee, TN, 2010 Skills & Qualifications ArcGIS Enterprise ▪ ArcGIS Online ▪ ArcGIS Pro ▪ ArcGIS Field Apps Professional Geographic Information Systems (GIS) Services 49 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. deployment of ArcGIS Enterprise with recent cloud migration and GeoEvent Server implementation. Developed web and mobile ArcGIS COTS applications for Real Estate, Facility Maintenance, Emergency Management, and other departmental stakeholders from needs assessment through configuration and final app delivery. Administered internal deployment of ArcGIS Enterprise with 100 named users and public-facing ArcGIS Online organization. Developed user guidance and engagement resources for all Portal users as well as departmental Standard Operating Procedures for non-technical end users. Conducted periodic stakeholder surveys for GIS and other technologies to ensure delivery of high-quality, relevant GIS services. Professional Geographic Information Systems (GIS) Services 50 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Carson Vallino, PMP Project Manager, GIS Analyst Mr. Vallino came to AppGeo from the University of Vermont’s Spatial Analysis Lab, an internationally recognized applied research facility. Since joining AppGeo, Mr. Vallino has been a key contributor to a number of AppGeo projects as both a project manager and GIS Analyst expert. Carson manages over 17 AppGeo clients each with a varying degree of scope. Carson manages 15 municipal clients in supporting their year-round & on-going GIS advancements and initiatives through AppGeo’s Spatial IQ for MapGeo Program. Carson also has experience working on enterprise systems for several clients as well as managing the roll out of these infrastructures for them. Work History Project Manager, Applied Geographics, August 2022 - present GIS Analyst, Applied Geographics, June 2020 - present Manual Corrections Project Team Lead (Burlington, VT), University of Vermont Spatial Analysis Laboratory (UVM SAL) - Created company-client SOPs and managed large-scale projects to meet company-client deadlines; conducted QA/QC of large datasets; trained new employees and assigned project positions. 2017 - 2020 Selected & Relevant Project Experience Metropolitan Area Planning Council (MAPC) - Enterprise System Upgrade (2023 – ongoing) - Project manager of this project to upgrade MAPC’s Enterprise. Includes new architecture design, data flow, infrastructure and software upgrades, ArcGIS Online clean-up support, ArcGIS Hub implementation, development of standard operating procedures, and training. City of Gloucester, MA Department of Public Works (2020 - ongoing) - Utility data development and clean up as part of AppGeo’s ongoing annual implementation support for the City. Additionally, assisted in support of the City’s Enterprise server and general maintenance/updates to existing enterprise infrastructure. State of Iowa - Broadband Mapping (2021) - Part of a large team of analysts and QA/QC experts processing hundreds of broadband provider coverage datasets into a single standardized statewide data product that identifies areas in need of improved broadband infrastructure. The data will be used at the state-level to determine broadband infrastructure buildout funding eligibility. Rutgers University, New Brunswick, NJ - Utility Data Conversion (2021) - Data analyst for the GIS conversion of comprehensive CADD utility data for all campuses. Project also includes delivery of true orthophotography, lidar, 3D buildings, contours, full planimetric mapping, CADD and GPS standards as well as data maintenance tools. State of North Dakota - Statewide Parcel Data Development (2020 - 2021) - Data assessment, QA/QC, database design, and documentation for the development of a statewide parcel database (800,000 parcels). Development of parcel data creation workflow and maintenance documentation; project kickoff activities. Arizona Department of Transportation - Roadway Characteristics Inventory (2020-2021) - GIS Analyst & team Production Manager performing data extraction and validation of roadway characteristics based on ortho imagery and Google Street View; workflow documentation; and QA/QC for statewide data improvement Education B.S. in Environmental Sciences, Concentration in GIS and Geology, University of Vermont, 2019 Project Management Professional (PMP) Certification Course, Burlington, VT, 2019 Professional Geographic Information Systems (GIS) Services 51 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. project focused on the expansion and creation of linear and point based roadway characteristics for a geospatial network of over 9,344 miles of public roadway. Town of East Windsor, CT - Stormwater Project (2021) - GIS Analyst developing a stormwater database. Conducted on-site field work to collect catch Basins and culverts to build out the town’s Stormwater network, Town of Wakefield, MA (2021) - GIS analyst for a large parcel data update project, including extensive clean- up and reconciliation Town of Johnston, RI (2020 - 2021) - GIS Analyst supporting the Town with annual ongoing parcel data maintenance, and other GIS projects Town of Rochester, MA (2020) - GIS Analyst providing parcel data maintenance under an annual GIS support services contract provided to the town through AppGeo’s Spatial IQ program. Now Project manager in charge of managing the GIS initiatives of the Town, including parcel data maintenance. Parcel Data Annual Maintenance (2020 - present) - GIS Analyst providing specialized editing and maintenance of parcel data and associated tax maps for a variety of towns such as Southbridge, MA; Old Saybrook, CT; Carver, MA. Towns of Shrewsbury, Northborough, Westborough, North Attleborough, and Amherst MA - Basemap Services Support (2021) - QA/QC for the acquisition of basemap imagery, lidar, and planimetric data, for a consortium of 3 Massachusetts towns and two individual projects for Amherst and North Attleborough MA. Town of North Attleborough, MA - Basemap Services Support (2020) - GIS Analyst performing data QA/QC of basemap imagery and planimetric data. AppGeo managed the procurement, vendor selection, and QA/QC of this basemap data acquisition. Now Project manager in charge of managing the GIS initiatives of the Town, including parcel data maintenance. Town of Westbrook, CT - Annual GIS Support Services (2020) - GIS Analyst providing technical support such as the development of new datasets under the Town’s Spatial IQ support contract. Town of West Hartford, CT (2020 - 2021) - Annual enterprise GIS support including parcel maintenance, data updates, general technical support. Town of Amherst, MA - Basemap Services Support (2020) - GIS Analyst performing data QA/QC of basemap imagery and planimetric data. AppGeo managed the procurement, vendor selection, and QA/QC of this basemap data acquisition. AppGeo’s Spatial IQ Program (2020 - present) - Project manager for a number of towns under AppGeo’s Spatial IQ Program which provides annual parcel maintenance and as-needed data improvement and other GIS technical projects, for the Towns of ; Northborough, MA; Manchester-By-The-Sea, MA; Milford, MA; Grafton, MA; ; Spencer, MA; Holyoke, MA; Norton, MA; Rehoboth, MA; Taunton, MA; Blackstone, MA; North Attleborough, MA; Watertown, MA, Middleborough, MA. San Mateo County Centerline Project (2019 - 2020) - Project Lead, worked with the County to improve the spatial accuracy and attribution of their trail/road/dozer network. Devised the SOP and methodology used to QA/QC centerline data; coordinated meetings with project stakeholders; trained and led manual corrections team; finalized, reviewed, prepared and packaged data for delivery to client. MEASURE Midwest Solar Panel Project (2018) - Worked with MEASURE, an aerial intelligence company, to identify defective and damaged solar panels. Using imagery taken from a drone, devised a rule set for automating the detection of these errors/defects. This project was documented in an article written by MEASURE and published in the UVM (University of Vermont) Magazine in 2019. Professional Geographic Information Systems (GIS) Services 52 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Jake Gamble GIS Analyst Mr. Gamble is a recent graduate from the University of Vermont, where he assisted in geospatial research funded by the Vermont NASA ESPCoR. He graduated with a B.S. in Forestry with a minor in Geospatial Technologies. He started working at AppGeo as a GIS Analyst immediately after graduating and brings experience with multiple ESRI software. Jake’s 1 year of experience at AppGeo includes extensive data development work for the Arizona Department of Transportation, various geospatial tasks for numerous local government agencies, and thorough Beta and Production testing of the Rutgers Campus Map web application. Jake has also played a key role in many QAQC initiatives including municipal parcel maintenance efforts and planimetric base map data updates for the island of Nantucket, Massachusetts. Work History June 2022-Present: Applied Geographics, Junior Analyst January 2022-May 2022: Vermont NASA EPSCoR Sept-Dec 2021: University of Vermont, Forest Hydrology Teaching Assistant May-Aug 2021: Vermont State Parks and Rec, May-Aug 2021 2018 to 2020: Town of Danvers Selected & Relevant Project Experience Arizona Department of Transportation - Roadway Characteristics Inventory (2021) - Data extraction and validation of roadway characteristics based on ortho imagery and Google Street View; workflow documentation; and QA/QC for statewide data improvement project focused on the expansion and creation of linear and point based roadway characteristics for a geospatial network of over 9,344 miles of public roadway. Rutgers University, New Brunswick, NJ - Utility Data Conversion (2022) - Beta and Production tester for Rutgers Campus Web Application. Project also includes delivery of true orthophotography, LiDAR, 3D buildings, contours, full planimetric mapping, CADD and GPS standards as well as data maintenance tools. New York University, Furman Center (2020, 2021) - Beta and Production tester for web application enhancements to the AppGeo-built system, CoreData, an interactive citywide web portal presenting maps, charts, tables and information on subsidized housing and neighborhood information at the city, borough, and neighborhood level. In addition, oversee ongoing application support services. Statewide Broadband Mapping Projects (2022) - Quality control, process management, data standardization and documentation for broadband availability data processing and mapping on a statewide basis for the States of Oklahoma, Michigan, and Massachusetts. Parcel Maintenance for New England Municipalities (2023 - ongoing) - Parcel updates, COGO, zoning updates, tax map updates, QA/QC for municipalities in RI, CT and MA, as part of AppGeo’s Spatial IQ Managed Services program. Recent parcel work includes the cities and towns of Northborough, MA, Watertown, MA, New Milford, CT, East Windsor, CT, and Smithfield, RI. Education Bachelors of Science in Forestry, with Geospatial Technologies minor, University of Vermont Rubenstein School of Environment and Natural Resources, 2022. Skills ArcPro, ArcMap, Google Products, Microsoft Office Suite, QGIS, Esri Software Professional Geographic Information Systems (GIS) Services 53 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Ashley Tardiff Senior Geospatial Analyst Ms. Tardif is a Geospatial Analyst with 7 years of experience lending technical expertise to both public and private sector projects. She performs complex spatial data processing, data analysis, and data visualization leveraging proprietary and open-source platforms. Work History Sept. 2017 to present: Applied Geographics, Inc., Geospatial Analyst & Assistant Product Manager (2017 - 2020), Senior Geospatial Analyst (2020 - present) Feb. 2017 - Sept. 2017: Open Source Geospatial Foundation, Operations Coordinator for FOSS4G Boston 2017 Jan. 2015- May 2016: University of Massachusetts, Amherst, Teaching Assistant for Introduction to Geographic Information Systems Selected & Relevant Project Experience Massachusetts Broadband Institute (2022 - ongoing) - BEAD Cost modeling analyst; Creation and management of a Broadband Serviceable Location address dataset for the state of Massachusetts. Aid in the identification and analysis of served, underserved, and unserved locations. Support with statistical analysis, data creation, and management for the Massachusetts Broadband Mapping Portal. Michigan High Speed Internet Office Broadband Program Support (2022-ongoing) - BEAD Cost modeling analyst; support with statistical analysis, data creation, and management for the Massachusetts Broadband Mapping Portal. Arizona Department of Transportation - Roadway Characteristics Inventory (2019 - 2022) - Data extraction and validation of roadway characteristics based on ortho imagery and Google Street View; workflow documentation; and QA/QC for statewide data improvement project focused on the expansion and creation of linear and point based roadway characteristics for a geospatial network of over 9,344 miles of public roadway. State of California Office of Statewide Health Planning and Development (2021) - Geospatial analytics in support of OSHPD’s Medical Service Study Areas (MSSA) Project. This project requires GIS analysis and technical support to ensure that the statewide MSSAs reflect geographically discrete communities, taking into consideration geographic and demographic factors for rural and urban areas. AppGeo performed as a subcontractor to Equanim Technologies. Rutgers University, New Brunswick, NJ - Utility Data Conversion (2020 - 2021) - QA/QC and data analyst for the GIS conversion of comprehensive CADD utility data for all campuses. Project also includes delivery of true orthophotography, LiDAR, 3D buildings, contours, full planimetric mapping, CADD and GPS standards as well as data maintenance tools. Education Trinity College Dublin; MS in Biodiversity and Conservation, 2021 University of Massachusetts, Amherst; BS in Natural Resources Conservation and Wildlife Ecology, 2016. Technical Skills Spatial Analysis ESRI ArcGIS QGIS CARTO - Editor / Builder Maptitude PostgreSQL, PGAdmin, & PostGIS Geoserver SQL Basic JavaScript Python R HTML, CSS Linux Command Line FME - Feature Manipulation Engine Alteryx Professional Geographic Information Systems (GIS) Services 54 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Town of Franklin MA Public Schools - School Redistricting (2022 - 2023) - Analyst assisting the Town with redistricting after school closure, performing a very detailed analysis with projections of the student population while also building multiple scenarios to balance enrollment across the schools due to decreasing population over the last decade. State General Assembly - Voter Redistricting (2021) - GIS analysis for a confidential state in its redistricting effort, including geocoding 5 years of voter rolls (using Maptitude) with a significant amount of parsing and cleaning of the data, establishing a repeatable process (using FME Workbench) to identify unique addresses, performing spatial analysis, and summarizing data by blocks using a variety of criteria. Town of South Kingstown, RI Public Schools - School Redistricting (2022) - Geospatial analyst, assisting the school district in planning for the proposed closing of a school. AppGeo worked with the district on a fast paced project to redistrict the elementary schools while taking into consideration the dual language programming that is very important to the district. City of Holyoke, MA Public Schools - School District Rezoning (2022) - Geospatial analysis for a major transition from nine different grade configurations to the typical three grade configurations (K-5; 6-8; 9-12). HPS has a large hispanic population and a mission to provide equitable education to all students. AppGeo is helping HPS evaluate how the changes to the grade configurations and assignment of special programs to particular schools will affect the equity goals. Albany County, NY - Redistricting Mapping Support (2022) - GIS Analyst assisting the Albany County Commission on Redistricting by providing mapping, demographic, and data analysis services related to the redistricting of the legislative districts of the County. AppGeo is employing Maptitude software, adjusting boundaries while balancing the population and demographics. AppGeo will also be providing an online platform for public engagement and to provide the Commission and the public with the opportunity to draw their own redistricting plans. City of Watertown Public Schools - School Redistricting (2022) - GIS analyst for the re-evaluation of the school assignment zones in the context of the rebuilding of some schools, building scenarios and helping the district visualize and evaluate the use of buffer zones for greater flexibility in assigning students to the appropriate school. Town of Shrewsbury, MA - School Redistricting and Demographics (2020 - 2021) - Geospatial analytics for redistricting and demographic analysis project. Working collaboratively with Bob Scarmadalia of RLS Demographics on demographic study and enrollment projections while managing the AppGeo tasks of GIS data management and scenario building. Town of North Haven, CT, Stormwater Data Development (2020 - 2021) - QA/QC and data production for the development and clean up of comprehensive stormwater system data, including conversion of CAD data and data development from hardcopy sources. Town of Wellesley, MA - School Redistricting and Demographics (2019) - Geospatial analysis for a redistricting project to adjust for decline in enrollment, and replacement and expansion of various schools, and demographic analysis to develop future enrollment projections. Town of Marlborough, MA - Public Schools Redistricting (2019 - 2020) - Spatial and demographic analysis, data processing, and scenario map development for a school redistricting project where the town needs to edit their school district boundaries because of the addition of a new school. Town of Chelmsford, MA - Update of the town’s zoning data and zoning map Rutgers University, New Brunswick, NJ - Campus Map (2018 - 2019) - Development of the comprehensive interactive campus map for the state university of New Jersey. Developed mockups for the design phase; beta and alpha testing. Created ArcGIS Online cartography for the spatial data in the application. Western Connecticut Council of Governments (WestCOG) (2019 - 2021) - Region-Wide Public-Facing GIS Platform (2019) - Development of a repeatable process to convert multi-town property and parcel data into a single schema format and dataset for the use in the MapGeo platform. This also includes generating a Professional Geographic Information Systems (GIS) Services 55 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. mismatch report between parcel and property data, resolution to those mismatches, as well as the conversion and creation of master land use and open space data layers. Implementation of regional parcel viewer (MapGeo). Responsibilities include governance support for regional agency for communication with towns and managing ETL processes for ingest of data from 18 towns. Town of North Andover, MA (2019) - Technical support to the town’s GIS program, under an annual managed services contract (Spatial IQ), which supports municipal operations. This includes master addressing and street centerline data maintenance, as well as school and bus route district data maintenance. Town of West Hartford, CT (2019 - 2023) - Technical support to the Town’s enterprise GIS program, under annual managed services support contract, including the generation of the Fire department run book, utility data maintenance, and fire station drive time analysis. MapGeo - Product Support and Maintenance (2017 - 2023) - support data management and data ETL workflows for MapGeo platform including property parcels, political districts, infrastructure and other thematic layers. Employ various data management platforms including WMS, Esri, Carto, Google, and Alteryx. Perform cartographic styling using Carto Editor. Troubleshoot errors and issues when they arise. Support installment of the Uploader tool and create python scripts to prepare and convert data for use in the MapGeo platform. Boston-based management consulting firm (2018) - Provided technical analytical support for a variety of business use cases including demographic analysis, customer profiling, supply chain logistics, opportunity assessment, and real estate analysis. Worked collaboratively with the firm using the full suite of ArcGIS tools, CARTO visualization and analysis, and Alteryx. Professional Geographic Information Systems (GIS) Services 56 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Russell Cohen Geospatial Analyst Since joining AppGeo, Mr. Cohen has been a key contributor to a number of AppGeo projects, providing GIS Analyst skills in data development and improvement, building data ETL (Extract, Transform, Load) routines, data analysis, web cartography, and as-needed technical assistance to a number of local government clients under annual support contracts. WORK HISTORY June 2020 - present: Applied Geographics, GIS Analyst 2019 - 2020 - University of Vermont Spatial Analysis Lab (UVM SAL). GIS Technician - Interpretation of satellite and aerial imagery, data creation and editing, and collaboration with a team of GIS and technology professionals. 2019 - University of Vermont. Teaching assistant for Introduction to Geographic Information Systems Selected & Relevant Project Experience Town of Plymouth, MA - School Redistricting and Demographics (2021 - 2022) - GIS Analyst performing boundary analysis for redistricting and demographic analysis project. State General Assembly - Redistricting Support (2021) - Provided GIS support to a confidential state in their redistricting effort, including geocoding 5 years of voter rolls (using Maptitude) with a significant amount of parsing and cleaning of the data, establishing a repeatable process (using FME Workbench) to identify unique addresses, perform spatial analysis, and summarize data by blocks using a variety of criteria. Town of Shrewsbury, MA - School Redistricting and Demographics (2020 - 2021) - GIS Analyst performing boundary analysis for redistricting and demographic analysis project. Town of West Hartford, CT (2020 - 2021) - Annual enterprise GIS support providing as-needed maintenance or improvements on data layers such as sidewalk centerlines. State of Iowa - Broadband Mapping (2021) - Developed an automated process to assess broadband coverage across the State of Iowa, as part of a large team of data analysts and QA/QC experts processing hundreds of broadband provider coverage datasets into a single standardized statewide data product that identifies areas in need of improved broadband infrastructure. The data will be used at the state-level to determine broadband infrastructure buildout funding eligibility. Rutgers University, Office of Planning, Development, and Design - Campus Map Reliability Enhancements (2021) - Ongoing improvements of an AppGeo-built campus map web application. GIS Analyst performing regression testing on the Rutgers campus map web application, and troubleshooting issues with back-end data. City of Cincinnati, Urban Tree Canopy Analysis (2020 - 2021) - Urban Tree Canopy Analysis Project including Lidar data acquisition and development, Urban Tree Canopy and PM 2.5 Analysis, Development of Priority Planting Plans, Landcover development, and the development of an impervious surface dataset for parking lots within Hamilton County, Ohio. Analyst performing QA/QC for Cincinnati tree canopy dataset using image interpretation of true color and color infrared imagery, as well as Lidar products. Education University of Vermont, B.A. in Geography, minors in Political Science and Geospatial Technologies, May 2020 Gamma Theta Upsilon, Eta Alpha Chapter – International Geographic Honor Society – Inducted in 2018 Skills ArcGIS FME Alteryx ENVI Python R Professional Geographic Information Systems (GIS) Services 57 Confidential and Proprietary, © 2024 The Sanborn Map Company, Inc., ALL RIGHTS RESERVED Any and all graphics included in this response are for illustrative and representative purposes only and shall not be relied upon as depictions of the final deliverables. Arizona Department of Transportation - Roadway Characteristics Inventory (2020 - 2021) - GIS Analyst performing data extraction and validation of roadway characteristics based on ortho imagery and Google Street View; workflow documentation; and QA/QC for statewide data improvement project focused on the expansion and creation of linear and point based roadway characteristics for a geospatial network of over 9,344 miles of public roadway. State of North Dakota - Statewide Parcel Data Development, Phase 1 and Phase 2 (2020 - 2021) - GIS Analyst building ETL routines for converting local county parcel data to a statewide standardized format for the development of a statewide parcel database. Rutgers University - Utility Data Conversion (2020 - ongoing) - Data Analyst for the GIS conversion of comprehensive CADD utility data for all campuses. Built models for creating tile layers from utility network and planimetric GIS data. Performed styling for GIS data based on cartographic best practices and client feedback. Project also includes quality control of orthophotography, LiDAR, 3D buildings, contours, and planimetric data. City of Bozeman KCI Technologies, Inc. 1 CITYWORKS UPGRADE HEIDI HAMMEL, PMP, GISP PRINCIPAL-IN-CHARGE EDUCATION: MS / Management Information System BS / Ocean Engineering REGISTRATIONS / CERTIFICATIONS: GISP / 9067 PMP / 525653 ITIL Foundation Certificate in IT Service Management IAM Certificate in Asset Management YEARS EXP.: 33 Ms. Hammel is KCI’s Asset Management Regional Practice Leader. She and her team provide asset management professional services such as strategic planning, data management, and technology implementation to predominantly municipal clients. Since 2005, Ms. Hammel has been a Certified Project Management Professional (PMP) managing complex projects for over 25+ years. Her strong project management acumen pervades through her staff and projects to ensure successful delivery and satisfied clients. Ms. Hammel maintains strong relationships and open communication with clients to ensure expectations are met at all project phases. She has worked primarily with local, state, and regional government organizations throughout her career, resulting in a strong understanding of municipal government. Ms. Hammel’s relevant experience is below: • City of Baltimore DOT, Cityworks Implementation & Snow Support, Baltimore, MD. • City of Baltimore DOT Conduits, Cityworks Implementation, Baltimore, MD. • Metro Nashville DOT, Cityworks Implementation, Nashville, TN. • Anne Arundel County, Asset and Work Order Management Planning, Annapolis, MD. JOE MURK, PMP, GISP CITYWORKS SUBJECT MATTER EXPERT EDUCATION: Post Graduate Studies / Database Management MA / Geography and Environmental Planning BS / Geography and Environmental Planning REGISTRATIONS / CERTIFICATIONS: GISP / 91350 PMP / 2995305 IAM Certificate in Asset Management YEARS EXP.: 14 Mr. Murk is the Solutions Engineering Manager within KCI’s Asset Management Practice and has been leading Cityworks implementations for the past 13 years at KCI. He leads a team of solution analysts, business analysts, and solution engineers in implementing Cityworks AMS for transportation, water, utility, facility, and public works organizations. He is well versed in Cityworks AMS, Storeroom, and Mobile and integrating with other core enterprise systems through the Cityworks API and 3rd party integrations. Mr. Murk is also an expert in Esri’s ArcGIS platform and Microsoft SQL Server, both inherent in any Cityworks implementation. He has excellent communication skills and can easily converse with IT staff about architecture, GIS staff about geodatabases, and field staff about what would make their lives easier. He has developed targeted training programs and worked closely with many users to assist them in their day-to-day activities and understanding of the technology. Mr. Murk’s relevant experience is below: • City of Baltimore DOT, Cityworks Implementation & Snow Support, Baltimore, MD. • Metro Nashville DOT, Cityworks Implementation, Nashville, TN. • City of Baltimore Parking Authority, Cityworks Implementation, Baltimore, MD. • City of Morgantown, Cityworks Implementation, Morgantown, WV. City of Bozeman KCI Technologies, Inc. 2 CITYWORKS UPGRADE SHANA LOWE, PMP, GISP LEAD CITYWORKS ENGINEER EDUCATION: MS / Environmental Studies BA / Psychology REGISTRATIONS / CERTIFICATIONS: GISP / 90050 PMP / 2870701 YEARS EXP.: 20 Ms. Lowe is a Project Manager in KCI’s Asset Management practice with over 20 years of experience in providing GIS and IT management, asset management, analysis, and administrative and operations leadership. She has exceptional communication and interpersonal skills, with the ability to seamlessly work with clients, staff, and other professionals in various areas across different job levels. Ms. Lowe spent much of her adult career in the public sector, including supporting GIS and asset management initiatives nationwide at several water and wastewater utilities. Her experience in the public sector allows her to foster a relationship with the client based on understanding their needs and serving as a trusted advisor. Ms. Lowe is a PMP (since 2013) and a Certified GIS Professional (since 2014). At KCI, Ms. Lowe acts as project manager and technical lead for various computerized maintenance management system (CMMS) implementation or implementation support projects. Ms. Lowe’s relevant experience is below: • City of Lebanon, Cityworks Implementation and Support, Lebanon, TN. • Groton Utilities, Cityworks AMS Implementation, Groton, CT. • City of Chattanooga, GIS and Cityworks Support Services, Chattanooga, TN. • City of Gastonia, Cityworks Implementation, Gastonia, NC. • Confidential Client, Cityworks Implementation, Various Locations, AZ & TX. CHRIS BLINN, GISP SENIOR SOLUTION ARCHITECT EDUCATION: MS / Geosciences BA / Geography REGISTRATIONS / CERTIFICATIONS: GISP / 65550 YEARS EXP.: 14 Before joining KCI, Mr. Blinn was a Senior Solutions Engineer and Architect, where he created and configured ArcGIS Online applications, managed ArcGIS Enterprise and Server instances, and served as the primary technical lead for over 50 projects. Mr. Blinn’s passion for problem-solving drives him to take on every task with excitement, insightfulness, and creativity. With a deep understanding of a solution's technical approach and business application, he can train a user or pitch to a CEO. Mr. Blinn has worked with numerous municipal and commercial agencies over the past 14 years to size infrastructure on-premises and in the cloud correctly. Mr. Blinn’s relevant experience is below: • Metro Nashville DOT, Cityworks Implementation-Stormwater Data Migration, Nashville, TN. • Groton Utilities, Cityworks AMS Implementation, Groton, CT. • City of Lancaster, Cityworks Improvement, Lancaster, SC. • Confidential Client, Cityworks Implementation, Various Locations, AZ & TX. City of Bozeman KCI Technologies, Inc. 3 CITYWORKS UPGRADE City of Bozeman, MT Professional Geographic Information Systems (GIS) Services 1935 Jamboree Drive, Suite 100 Colorado Springs, CO 80920 1.866.726.2676