The URL can be used to link to this page

Home My WebLink AboutCity of Bozeman, MT_GIS Data and Database Architecture and Data Maintenance Health Check_GTG Submission -1152021 Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 2 | Executive Summary GEOGRAPHIC TECHNOLOGIES GROUP City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 1202 Parkway Drive Goldsboro, NC 27534 888.757.4222 • Esri Silver Business Partner • FME Business Partner and User • Naviline Experts and Central Square Business Partner • Cityworks User and Experience • Laserfiche Specialists • GIS Integration Specialists Cover Letter A. Executive Summary .......................................................................................................... 1 B. Firm Profile ........................................................................................................................ 4 Esri Partner ............................................................................................................................ 5 Quality GIS Consulting Services .......................................................................................... 5 Award-Winning Company .................................................................................................... 6 C. Proposed Solution ............................................................................................................ 7 D. Scope of Project .............................................................................................................. 10 Project Understanding ....................................................................................................... 10 Scope of Services ................................................................................................................. 12 Project Timeline .................................................................................................................. 24 E. Related Experience and Projects ...................................................................................... 25 F. Statement of Qualifications ........................................................................................... 33 Professional Credentials, Experience, and Qualifications ............................................. 33 G. References....................................................................................................................... 35 H. Present and Projected Workloads ................................................................................. 36 Present Workload Activities and Coordination ............................................................... 36 Project Team Workloads .................................................................................................... 36 I. Key Personnel ................................................................................................................. 38 J. Price Proposal ................................................................................................................. 41 K. Additional Information................................................................................................... 42 L. Affirmation of Nondiscrimination & Equal Pay ............................................................ 45 COVID-19 Statement Our GIS Team will be able to conduct all required data, database architecture, and data maintenance reviews with no physical contact with the City of Bozeman staff. GTG utilizes Zoom and Microsoft Teams for remote collaboration. January 15, 2020 City of Bozeman PO Box 1230 Bozeman, MT 59771-1230 Re: RFP: GIS Data and Database Architecture and Data Maintenance Health Check Dear Mr. Maas: Geographic Technologies Group (GTG) understands that the City of Bozeman is looking for a qualified, experienced, and expert partner to analyze, document, and improve the organization’s geodata ecosystem. Our team has worked with the City of Bozeman and is excited about proposing on this project. GTG offers the City of Bozeman the following credentials: • The world’s leading GIS strategic planning company – GISPlan.com or GISRoadmap.com • Specific expert experience in data and database architecture and data maintenance procedures and Best Business Practices • A good working relationship with the City of Bozeman • A hand-picked small cadre of GIS Databases and Architecture specialists • A commitment to a $30,000 Budget • Key references from Local Government Organizations: • City of Morgan Hill, CA – GIS Data and Databases Architecture and Database Maintenance • City of Vancouver, WA – GIS Data and Databases Architecture and Database Maintenance • City of Lawrenceville, GA – GIS Data and Databases Architecture and Database Maintenance • Seminole Tribe of Florida, FL – GIS Data and Databases Architecture and Database Maintenance • Gwinnett County, GA – GIS Data and Databases Architecture and Database Maintenance • City of Lathrop, CA – GIS Data and Databases Architecture and Database Maintenance The City of Bozeman’s GIS data and database architecture is complex and mission-critical to the success of the GIS initiative. GTG has the experience, technical expertise, and knowledge of industry best practices to deliver a complete, robust, and tailored GIS data assessment. Our team understands that for the City of Bozeman to improve its geodata operations, the City must first develop a deep understanding of its geodata ecosystem. GTG’s holistic approach in evaluating the entire GIS, including user workflows, system architecture, integrations, data quality, and data management allows for this understanding to be cultivated and turned into tailored, actionable recommendations. GTG’s decades of experience conducting systemic GIS assessments, data reviews, strategic planning and integration services for local government positions us to be uniquely qualified to provide expert insights and services to the City. We are excited about proposing our solution to the City. Many Regards, Mr. David Holdstock, BA, MA, GISP CEO, Geographic Technologies Group (GTG), Inc. 1202 Parkway Drive Goldsboro, NC 27534 P: 919.759.9214 | E: dholdstock@geotg.com Supported By A Team of Experts: Jason Marshall Andrew Valenski Jessy Beasley City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Executive Summary | 1 GEOGRAPHIC TECHNOLOGIES GROUP A. Executive Summary The goal of this project is to provide the City of Bozeman a full review and assessment of all existing database architecture (both traditional geodatabase as well as hosted data) and provide Best Business Practices (BBP) and recommendations for transitioning from a traditional GIS to a web-based Enterprise GIS. The table below illustrates the recommended 9 tasks and outcomes of the project. GIS Data & Database Architecture and Data Maintenance Health Check Review and Analysis Outcomes 1. Enterprise Geodatabase Step-by-step strategy to improve the use of enterprise geodatabases 2. File Geodatabase Step-by-step strategy to improve the effective use of file geodatabases 3. Hosted Data Step-by-step strategy to improve the efficiency of ArcGIS Enterprise data store and ArcGIS Online 4. GIS Integrations and FME Optimization strategy to create a SMARTCITY SYSTEM OF SYSTEMS - INTEROPERABILITY Key Recommendations Outcomes 5. Improving Database Maintenance and Overall Performance Improved database maintenance and performance recommendations 6. Improve Data Management Improved data management tools and techniques 7. Migrating to New Data Models Detailed options and migration strategy to new data models 8. When to Use a File Geodatabase, and Hosted Feature Services Detailed recommendations on the optimum database architecture Transition Plan Outcomes 9. ArcGIS Desktop to ArcGIS Pro Step-by-step transition strategy City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 2 | Executive Summary GEOGRAPHIC TECHNOLOGIES GROUP Our team has read the City of Bozeman’s Request for Proposals (RFP) and understand the following: • The City of Bozeman’s GIS is a success! • The City is looking to take its enterprise GIS to the next level of database management. • The City of Bozeman’s suite of geospatial services and data are deeply connected to many of the City’s core operations. • In addition to exposing geospatial data, services, and applications to residents, partners, and employees, the GIS supports the continued operation and success of the City’s other departments. Among others, the GIS is integrated with the Finance Department (Navline, Orion), the Engineering Groups (Cityworks, Innovyze, Neptune, Dropcountr, GrainteNet), Emergency Services (Zuercher, LiGO), and Human Resources/Project Management (Laserfiche). • GIS integrations are achieved using FME, ETL (Extract-Transform-Load) processes, and automated scripts, which move and transform data throughout the organization. • The organization’s existing Geographic Information System (GIS) is centrally positioned in the organization’s technology landscape, serving as both a source of authoritative spatial data for other information systems/applications and as an integration destination for data flows. The movement of data within the organization is critical for operational success and developing an understanding of the City’s data ecosystem is paramount. • While hosted feature layers are appropriate in some situations, the Enterprise Geodatabase is not going away. Therefore, recommendations for improved database maintenance and performance are also very important. Additionally, the City is interested in learning about and exploring new data models and data maintenance processes. To meet these needs, GTG will address the nine (9) requirements of the City through a custom GIS-centric data assessment methodology. The nine (9) components of GTG’s holistic assessment are detailed below. GTG’s robust assessment methodology enables organizations to better understand their data and data ecosystem, and to use those insights to take actionable measures at improving operations. The City of Bozeman is unique, and the needs, workflows, and database operations need to be given appropriately tailored analysis to best serve the organization. Geographic Technologies Group (GTG) understands the complex and interwoven position of GIS within the City of Bozeman and recognizes the value of understanding and optimizing data processes for organizations. GTG is experienced in evaluating and analyzing data City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Executive Summary | 3 GEOGRAPHIC TECHNOLOGIES GROUP operations and generating achievable, effective, and efficient roadmaps for improving data operations. GTG’s holistic approach to data assessment considers the use and lineage of data, how and where data is stored, consumed, and maintained, and the underlying database design and system architecture. Geographic Technologies is a leading expert in GIS Technology and has written several publications on the matter. One of these includes a white paper for Local Government about GIS Database Architecture discussing File Geodatabases vs Personal Geodatabase vs ArcGIS Data Store vs Enterprise Geodatabase and RDBMS SDE. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 4 | Firm Profile GEOGRAPHIC TECHNOLOGIES GROUP B. Firm Profile Geographic Technologies Group, Inc. (GTG) is one of the country’s leading full-service local government GIS consulting companies, allowing us to have expertise in every area of GIS. Headquartered in North Carolina with regional offices throughout North America, GTG has secured state, national, and international awards for geospatial planning and enterprise planning solutions. Founded in 1997, our company celebrates more than twenty-three years of growth and success. Built on its tradition of deploying the very best GIS solutions for government, GTG now has over 700 clients nationwide. A corporate culture of quality, understanding government operations, and commitment to our clients allows GTG to continue to build an outstanding GIS portfolio. Our team takes pride in completing work within budget, and as scheduled. For over two decades GTG has gained exceptional experience in providing GIS data, database architecture, and data maintenance reviews. GTG is equipped and available to deliver incomparable services to the City of Bozeman. We are fully prepared to support the City of Bozeman with the following tasks as outlined in the RFP. We will conduct a full data, database architecture, and data maintenance review of the City’s GIS and other integrated asset management databases. Legal Name of Company: Geographic Technologies Group, Inc. Company Contact Email: dholdstock@geotg.com Telephone: 919.759.9214 Address: 1202 Parkway Drive Goldsboro, NC 27534 Website: www.geotg.com and www.GISPlan.com City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Firm Profile | 5 GEOGRAPHIC TECHNOLOGIES GROUP Esri Partner GTG has been an Esri Business Partner since 1998. Currently an Esri Silver Partner, GTG is the leading local government Esri expert. We were the first Esri Business Partner to achieve the following distinctions: Esri Gold Partner, Esri ArcGIS Online, and the ArcGIS for Local Government specialties. We are also recognized as an Esri Cornerstone Partner. As a group of Esri technologists, we are experts in the entire Esri suite of software. Most recently, we are working closely with Esri on new emerging technologies that will influence the City of Bozeman in the future, including but not limited to ArcGIS Pro, ArcGIS Urban, ArcGIS Hub, as well as Insights and Dashboards. Quality GIS Consulting Services GTG offers the very best cadre of experts in geospatial technologies. The success of GIS in local government is dependent on many factors, including the creation and maintenance of accurate and reliable GIS data and databases. GTG offers a complete range of geospatial services, including: • Data Migration • Geo-Database Design • GIS Data and Database Assessments • Database Management and Performance • System Architecture Design • Esri Software Deployment and Implementation • Software Migration and Integration • Data Layer Creation, Collection, and Conversion • GPS Inventory Services • Cartography, Map Creation, and Conversion • GIS and IT Integration • GIS Spatial Analysis • Application Development and Maintenance • GIS Configuration • Technical Support Services • Staff Training and Education City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 6 | Firm Profile GEOGRAPHIC TECHNOLOGIES GROUP Award-Winning Company Our unique insight and experience have allowed us to develop a successful approach to GIS implementation. GTG has received the following awards for our GIS products, services, and solutions. A list of GTG’s awards for GIS in Local Government 2000-2020 are as follows: • Esri Business Partner of the Year • Esri International Award for Mobile Applications • Esri Special Achievement in GIS Award, Campbell County/Gillette, Wyoming • URISA Gold Award • Esri Special Achievement in GIS Award, City of Unalaska, Alaska • Esri Best Citizen Engagement Award • Esri Cornerstone Partner Recognition • American City and County Excellence Award in GIS • URISA Exemplary Systems in Government • URISA Excellence Award In GIS • URISA City of Guelph Best Web GIS • URISA City of Guelph Best Public-Sector GIS • Herb Stout Exemplary Use of GIS Technology in Local Government • URISA Distinguished Exemplary Systems Award City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Proposed Solution | 7 GEOGRAPHIC TECHNOLOGIES GROUP C. Proposed Solution Geographic Technologies Group recommends additional project activities be included in the project scope to ensure a successful project. The following details all the tasks required to complete the scope of services outlined in the RFP and this proposal. GIS Data & Database Architecture and Data Maintenance Health Check A. Kick-Off Meeting - 1 Hour a. Teams or Zoom Meeting b. Introductions to GTG Team and City of Bozeman B. Project Scope of Services Presentation and Outline to all City of Bozeman Stakeholders – 1 Hour 30 Minutes a. Teams or Zoom Meeting b. Scope of Services • 9 Tasks and 9 Deliverables c. Timeline • 3 Month Project d. Budget • $30,000 Project e. City Requirements • Attend Teams Meetings • Support GTG with remote access to City systems • Data gathering of related documentation about IT infrastructure, integrated solutions, architecture, bandwidth, and any known challenges or barriers to success. C. Nine (9) Project Tasks a. Project Weekly Status Updates b. Project Presentations The following lists the recommended Teams meeting presentations for the scope of work. Our team wants to keep the City of Boseman in the loop and informed on everything we are doing. 9 Tasks for the City of Bozeman Project City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 8 | Proposed Solution GEOGRAPHIC TECHNOLOGIES GROUP Each presentation will be 60-90 minutes with time for Question and Answer. o Presentation #1: Task 1 and Task 2 o Presentation #2: Task 3 o Presentation #3: Task 4 and Task 5 o Presentation #4: Task 6 o Presentation #5: Task 7 o Presentation #6: Task 8 o Presentation #7: Task 9 D. Project Deliverables a. DRAFT Deliverables b. FINAL Deliverables As mentioned above, Geographic Technologies Group proposes a 9-step approach for this project. The following graphic illustrates the 9 Project Steps and the 9 Project deliverables that are critical to the success of this project. GTG has been wonderful to work with. They are professional, knowledgeable, and always there when we need them. I wish all my vendors were as responsive and thorough. I can always count on GTG! - City of Lauderhill, FL City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Proposed Solution | 9 GEOGRAPHIC TECHNOLOGIES GROUP Project Deliverable Documentation for each task: City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 10 | Scope of Project GEOGRAPHIC TECHNOLOGIES GROUP D. Scope of Project Project Understanding It is extremely important to understand the City of Bozeman’s existing GIS data and database architecture and data maintenance procedures, as well as the City’s GIS governance model, workflows, procedures, protocols, and integrations. Additionally, understanding the level of interoperability, the Esri GIS ecosystem, IT infrastructure, and all training, education, and knowledge transfer activities. The six pillars of GIS sustainability are extremely important and will guide our information gathering tasks. A successful GIS Data and Database Architecture and Data Maintenance health check must address all related components and dependencies. Six Pillars of GIS Sustainability - Smart City Initiative 1. GIS Governance 2. GIS Data and Database Architecture and Data Maintenance Procedures 3. GIS Workflow, Procedures, and Integration (Interoperability) 4. GIS Software 5. IT Infrastructure 6. Training, Education, and Knowledge Transfer The City of Bozeman’s scope of services includes 9 very specific tasks. We have developed a scope of services that enhances the City’s 9-step approach. The ultimate outcome is a comprehensive GIS Data and Databases Architecture and Data Maintenance Health Check that identifies clear and concise tasks and outcomes. Our team understands the following: • The City of Bozeman has had a GIS Division for over 20 years. • Since the year 2000, the use of GIS has expanded from a hand full of layers for 1-2 divisions to providing support across every department within the City. The City built a true enterprise GIS with users in every department. • The GIS Division has expanded its Esri production environment from Coverages and Shapefiles to supporting a robust and complex Enterprise Geodatabase, File City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Scope of Project | 11 GEOGRAPHIC TECHNOLOGIES GROUP Geodatabases, ArcGIS Enterprise (Portal), stand-alone ArcGIS Servers, and ArcGIS Online. • Today, most of the City’s production data is stored in an Enterprise Geodatabase, but with the industry-wide transition into Web GIS, the City is starting to migrate into hosted data in ArcGIS Enterprise and ArcGIS Online. • Using FME (Safe Software) the City’s GIS Department has created a highly integrated environment. GIS is integrated with many existing databases and systems across the organization. This includes, but is not limited to: • Cityworks • Navline (finance, utilities, billing, planning) • Innovyze hydraulic models • Neptune (water meters) • Dropcountr (water use tracking) • CUES GraniteNet (wastewater/stormwater pipe inspections) • Zuercher (911) • Emergency Reporting (fire) • Montana Department of Revenue Orion database • Laserfiche • LiGO (Automatic Vehicle Location (AVL)) • Utility Locates • In 2017, the City of Bozeman underwent a full System Architecture review with Esri. The resulting products from this review included a recommendation to expand the system architecture and transition into an Enterprise-wide Web GIS platform (ArcGIS Enterprise). • Over the last 3 years, the City’s GIS staff have added additional ArcGIS Servers and built out a full ArcGIS Enterprise implementation including Portal, Data Store, Host ArcGIS Server, additional federated ArcGIS Servers, and Image Server. • In 2021 Web GIS is fully developed within the City. The City of Bozeman is now requesting assistance in developing a plan of action to do the same with the City’s database architecture. To meet these needs, GTG will address the nine (9) requirements of the City through a custom GIS-centric data assessment methodology. The nine (9) components of GTG’s holistic assessment are detailed on the following pages. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 12 | Scope of Project GEOGRAPHIC TECHNOLOGIES GROUP Scope of Services CITY OF BOZEMAN GIS Data and Databases Architecture and Database Maintenance Health Check and Strategic Action Plan The goal of this project is to provide the City of Bozeman’s GIS department with a full review and assessment of their existing database architecture (both traditional geodatabase as well as hosted data) and provide best business practices and recommendations for transitioning from a traditional GIS to a web-based Enterprise GIS. While hosted feature layers are appropriate in some situations, the Enterprise Geodatabase is not going away. Therefore, recommendations for improved database maintenance and performance are also very important. Additionally, the City is interested in learning about and exploring new data models and data maintenance processes. To meet these needs, GTG will address the nine (9) requirements of the City through a custom GIS-centric data assessment methodology. Furthermore, GTG has included additional project steps. The scope of services GTG recommends to the City of Bozeman is as follows. A. Kick-Off Meeting GTG will employ its industry knowledge and experience to conduct a Kick- Off Meeting for all interested GIS users within the City. The initial presentation will last 60 minutes and will provide an opportunity for early interaction with the project team and introductions between the City of Bozeman and the Geographic Technologies Group Team. B. Project Scope of Services Presentation and Outline to all City of Bozeman Stakeholders This presentation can be expected to last a duration of one hour and thirty minutes with the goal of reviewing the project to all of the City of Bozeman GIS stakeholders. GTG will cover the 9 tasks and deliverables to be expected from those tasks, the 3-month project timeline associated with the tasks, and a breakdown and review of the budget for this project. Additionally, the team can discuss the required activities from the City, including (but not limited to); attending teams meetings, supporting GTG with remote access to City systems, and assistance with gathering data and related documentation about IT infrastructure, City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Scope of Project | 13 GEOGRAPHIC TECHNOLOGIES GROUP Integrated solutions, architecture, bandwidth and any known challenges or barriers to success. C. Nine (9) Project Tasks The nine (9) components of GTG’s holistic assessment are detailed below. To accompany these tasks, GTG will provide the City of Bozeman with weekly project status updates. The 9 tasks will include: 1. Review of the existing use of Enterprise Geodatabase GTG has decades of experience administering and maintaining Enterprise Geodatabases and Microsoft SQL Servers. At the core of the City’s GIS operations is its Enterprise Geodatabase, which supports the City’s GIS userbase, the ArcGIS Enterprise deployment, and Geocortex environment. GTG will conduct a detailed review of the Enterprise Geodatabase, documenting the geodatabase configuration specifications, analyzing the geodatabase system tables, usage statistics, and the underlying server’s performance metrics. Additionally, GTG will document the security model, and identify any potential vulnerabilities/improvements to be made which may improve sharing and/or access-control. GTG will also document Enterprise Geodatabase use patterns by reviewing database usage through ArcGIS Enterprise, scripted processes, and FME consumption. This core assessment will not only provide the City with a better understanding of its geodatabase but will also be used to inform other components of GTG’s work to provide a holistic and complete review of the City’s geodata systems. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 14 | Scope of Project GEOGRAPHIC TECHNOLOGIES GROUP Deliverable #1: Enterprise Geodatabase Assessment • Weekly Updates • City of Bozeman’s Enterprise Geodatabase Assessment • Overview • Executive Summary • Enterprise Geodatabase Use • Enterprise Geodatabase Configuration Specifications • Analysis of Enterprise Geodatabase • System Tables • Usage Statistics • Underlying Server’s Performance Metrics. • Security Model • Potential vulnerabilities • Improvements • Sharing and/or access-control. • Improvements • Enterprise Geodatabase Use Patterns • Conclusions and Recommendations 2. Review of the existing use of File Geodatabases File geodatabases offer specific benefits to GIS operations within an organization, but, when misused, can negatively impact the overall health of geodata activity. GTG will work with the City of Bozeman GIS staff and users to identify and document the use of file geodatabases across the organizations. Once the file geodatabase landscape has been plotted, GTG and the City will evaluate the content of these data sources, evaluate the use and use-patterns of these data sources, and develop a plan to use file geodatabases more effectively across the organization. This analysis will identify duplicated data, stagnant data, incomplete/unknown data, and ultimately yield a report recommending plans of action to best utilize these resources. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Scope of Project | 15 GEOGRAPHIC TECHNOLOGIES GROUP Deliverable #2: File Geodatabases Assessment • Weekly Updates • Presentation #1: Task 1 and Task 2 • City of Bozeman’s File Geodatabase Assessment • Overview • Executive Summary • File Geodatabase Use • File Geodatabase Configuration Specifications • Analysis of File Geodatabase • Usage Statistics • Underlying Server’s Performance Metrics. • Content Review • Security Model • Potential vulnerabilities • Improvements • Sharing and/or access-control. • Improvements • File Geodatabase Use Patterns • Conclusions and Recommendations 3. Review of the existing use of Hosted data (ArcGIS Enterprise Data Store and ArcGIS Online) Using the most up-to-date methods and practices, such as the ArcGIS API for Python, NodeJS, and ArcGIS Enterprise utility tooling, GTG will generate a complete report of the City’s hosted data. Hosting data offers considerable benefits to traditional on-premises data storage, but is often misused, overused or under-reported, resulting in an inefficient data storage solution. GTG’s technical team has worked with ArcGIS Enterprise and ArcGIS Online for decades and not only understands the underlying platforms that enable hosted storage, but also the industry best practices for leveraging hosted data storage. GTG will identify the extent of the City’s hosted data ecosystem and work in tandem with internal stakeholders to determine the value, authority, and accuracy of hosted datasets, and make determinations about their utility and appropriateness. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 16 | Scope of Project GEOGRAPHIC TECHNOLOGIES GROUP Deliverable #3: Hosted Data Assessment (ArcGIS Enterprise Data Store and ArcGIS Online) • Weekly Updates • Presentation #3: Task 3 • City of Bozeman’s Hosted Data Assessment • Overview • Executive Summary • Hosted Data Use and Hosted data Ecosystem • Hosted data Configuration Specifications • Analysis of Hosted Data • Usage Statistics • Underlying Server’s Performance Metrics. • Content Review • Security Model • Potential vulnerabilities • Improvements • Sharing and/or access-control. • Improvements • Hosted Data Use Patterns • Conclusions and Recommendations 4. Recommendations for improving database maintenance and overall performance. Effectively administering and maintaining an Enterprise Geodatabase is critical to the long-term success and health of a database and GTG has decades of experience maintaining Enterprise Geodatabases. GTG’s analysis of the existing Enterprise Geodatabase will inform this component of our holistic approach, resulting in instance-level recommendations for database tuning and potential configuration changes. GTG will analyze the City’s set of maintenance scripts and activities and work with the GIS Administrator(s) to cultivate an understanding of what maintenance activities are currently in place. Additionally, GTG will gather information about user and process workflows to evaluate whether database management/performance can be improved by addressing consumption patterns. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Scope of Project | 17 GEOGRAPHIC TECHNOLOGIES GROUP These efforts, in conjunction with the findings of our analysis of the Enterprise Geodatabase as a whole, will result in a set of recommendations for more effectively maintaining the City’s SQL Server instance. GTG will also review the City’s existing backup-and-recovery procedures and failover mechanisms to evaluate the stability and resilience of the organization’s Enterprise Geodatabase. Deliverable #4: Improving Database Maintenance and Overall Performance • Weekly Updates • City of Bozeman’s Database Maintenance and Performance • Overview Executive Summary • Analysis of Maintenance Scripts, Procedures, Protocols, and Activities • Analysis of User and Process Workflows • Consumption Patterns • Document Existing Maintenance and Performance Conditions • Review the City’s existing backup-and- recovery procedures and failover mechanisms. • Recommended Tuning and Configuration Changes • Recommendations for more effectively maintaining the City’s SQL Server instance • Recommendations for more effectively maintaining the City’s SQL Server instance • Recommendations for backup-and- recovery procedures and failover mechanisms 5. Recommendations to improve data management (including integrations) GTG will conduct a holistic data consumption analysis, documenting which datasets are being consumed through ArcGIS Enterprise, via scripted processes, and through FME integrations. This analysis will reveal how data is being consumed, which will provide the backdrop for City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 18 | Scope of Project GEOGRAPHIC TECHNOLOGIES GROUP understanding how the data can be better used and managed. GTG will examine the existing editing workflows, including the City’s use of versioning and replication, to document intra- system data flows. These analyses will provide insights into how the City may better leverage the tooling of multi-user; concurrent data management practices enabled by the geodatabase model. GTG will also review the City’s adherence to metadata management, a critical component of data quality and content discovery. GTG will review the geodatabase conventions, such as naming, ownership, access, and permissions, and make recommendations on improving the consistency and security of datasets within the Enterprise Geodatabase. GTG will work with the City of Bozeman stakeholders to cultivate an understanding of geodatabase integrations and identify process improvements to more effectively, efficiently, and/or safely leverage geodatabase resources. Deliverable #5: Improving Data Management • Weekly Updates • Presentation # 3: Task 4 and 5 • City of Bozeman’s Data Management • Overview • Define Data Management • Executive Summary • Holistic Data Consumption Analysis Report • Existing Editing Workflows • Versioning and Replication • Intra-system Data Flow • Database Conventions • Naming • Ownership • Access • Permissions • Security • Mata data Standards and Management • Recommendations about Improvements to data usage and management • Recommendations and Insights into improved leveraging and tooling of multi-user, concurrent data management practices City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Scope of Project | 19 GEOGRAPHIC TECHNOLOGIES GROUP 6. Recommendations for migrating to new data models (i.e., ArcGIS Solutions for Local Government, Utility Networks, etc.) As a part of GTG’s Enterprise Geodatabase analyses, our team will review the completeness, accuracy, and health of the City’s “core datasets.” Core datasets refer to the fundamental and critical datasets that underpin most GIS operations and integrations and often include parcels, centerlines, and utility data. GTG has worked with many organizations to improve the structure and accuracy of their core datasets by identifying current issues/limitations and developing a processional roadmap to improving the data while continuing to use the data across the system. GTG’s experience working with ArcGIS Data Models (ArcGIS Solutions/Utility Network) will inform our analyses and make determinations about the relative costs and benefits of modifying core dataset structures/schemas. GTG will make a set of recommendations on how to improve the quality and schematic interoperability of the City’s datasets with Esri’s data models. Deliverable #6: Migrating to New Data Models Report • Weekly Updates • Presentation #4: Task 6 • City of Bozeman’s Migrating to New Data Models Report • Overview • Executive Summary • Review Completeness, Accuracy, and Health of the City’s “core datasets.” • Identifying Current Issues and Limitations • Developing a processional roadmap to improving the data while continuing to use the data across the system. • Recommendations on how to improve the quality and schematic interoperability of the City’s datasets with Esri’s data models. • Recommendations for ArcGIS Data Models • Recommendations for Utility Network Models • Water • Sewer • Strom Water City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 20 | Scope of Project GEOGRAPHIC TECHNOLOGIES GROUP 7. Recommendations on when to use a File Geodatabase, Enterprise Geodatabase, and Hosted Feature Services (ArcGIS Enterprise or ArcGIS Online), including best practice. GTG has designed and implemented hundreds of GIS deployments, providing the organization with a rich and thorough understanding of architectures, strategies, and practices. This experience coupled with the continued efforts to stay up to date with Esri’s best practices enables GTG to provide the best consultative services to the City related to data architecture. GTG will use our professional experience and knowledge of industry best practices to tailor a custom set of recommendations for the management of data for the City. GTG’s analyses of the Bozeman GIS and geodata ecosystem will be front-and-center to GTG’s recommendations, ensuring that the City is not given a “one-size fits all” solution, but rather an achievable, realistic, effective, and efficient set of solutions that will meet the unique needs of the City now and into the future. Deliverable #7: When to use a File Geodatabase, Enterprise Geodatabase, and Hosted Feature Services (ArcGIS Enterprise or ArcGIS Online), including best practices. • Weekly Updates • Presentation #5: Task 7 • City of Bozeman’s Best Business Practices (BBP) - Use of File Geodatabase, Enterprise Geodatabase, and Hosted Feature Services (ArcGIS Enterprise or ArcGIS Online) • Overview • Executive Summary • Best Business Practices (BBP) • Use of File Geodatabase, • Use of Enterprise Geodatabase • Use of Hosted Feature Services (ArcGIS Enterprise or ArcGIS Online) City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Scope of Project | 21 GEOGRAPHIC TECHNOLOGIES GROUP 8. Review of the existing GIS integrations and how to use FME more efficiently to channel data to the appropriate repositories (File Geodatabase, Enterprise Geodatabase, Hosted Feature Service, etc.) GTG will review the current FME workflows to understand the sources, sinks, and transformations of data within the organization. GTG will also work with GIS stakeholders to develop an understanding of why these processes are in place and what purpose they are serving. With an informed perspective of “what” and “why,” GTG will evaluate the FME processes and identify areas of potential improvement, simplification, or consolidation. Additionally, GTG will examine the efficacy and efficiency of these FME processes and consider the relative efficacy and efficiency of other ETL processes and make recommendations on how the City can most effectively accomplish its goals. GTG will also provide a preliminary assessment of the potential utility of implementing a centralized Data Warehouse that could be leveraged as an interagency resource for consuming data. Deliverable #8: Review of the existing GIS integrations and how to use FME more efficiently to channel data to the appropriate repositories (File Geodatabase, Enterprise Geodatabase, Hosted Feature Service, etc.) • Weekly Updates • Presentation #6: Task 8 • City of Bozeman’s Review of the existing GIS integrations and how to use FME more efficiently to channel data to the appropriate repositories (File Geodatabase, Enterprise Geodatabase, Hosted Feature Service, etc.) • Overview • Executive Summary • Highly Integrated Environment • Existing Integrations Assessment • Cityworks • Navline (finance, utilities, billing, planning) • Innovyze hydraulic models • Neptune (water meters) City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 22 | Scope of Project GEOGRAPHIC TECHNOLOGIES GROUP • Dropcountr (water use tracking) • CUES GraniteNet (wastewater/stormwater pipe inspections) • Zuercher (911) • Emergency Reporting (fire) • Montana Department of Revenue Orion database • Laserfiche • LiGO (Automatic Vehicle Location (AVL)) • Utility Locates • Other Software and databases Solutions not listed in RFP • Evaluation of the current FME (Safe Software) use and workflows. • FME Recommendations • Citywide Integration Recommendations and Data warehousing Options 9. A plan for transitioning from ArcGIS Desktop to ArcGIS Pro. ArcGIS Pro is the latest and premier solution for Desktop GIS; however, many organizations are still working predominantly with the “legacy” tooling of ArcMap and ArcCatalog. GTG has worked with hundreds of governmental agencies and consulted on this matter successfully, developing roadmaps for staged adoption of the new technology. GTG’s process begins with developing an understanding of the current Desktop GIS userbase and their workflows. After GTG has developed an understanding of the Desktop GIS community, GTG will then evaluate the City’s licensing situation to understand the current and future potential of migrating from ArcMap to ArcGIS Pro. Once the City’s userbase has been adequately described and their licensing situation understood, GTG will work with City GIS staff to develop a training plan and staged roadmap for user migration. As the Web GIS environment of the City continues to grow, GTG has discovered that coupling the processes of Portal for ArcGIS adoption with ArcGIS Pro adoption for a more seamless GIS experience can serve as the catalyst for organic usage. GTG will develop a custom transition plan for the organization that will empower the users, identify critical workflows that need to be included in organizational training, and set realistic goals for a successful migration. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Scope of Project | 23 GEOGRAPHIC TECHNOLOGIES GROUP Deliverable #9: ArcGIS Transition Plan • Weekly Updates • Presentation # 7: Task 9 • City of Bozeman’s Plan to Transition from ArcGIS Desktop to ArcGIS Pro. • Overview • Executive Summary • Existing Desktop GIS Userbase and Workflows • Esri Licensing Evaluation • Recommended Approach • Development of a Custom Transition and Training Plan • Workflow Migration to ArcGIS Pro • Realistic Goals and Objectives D. Project Deliverables GTG will provide draft deliverables to the City of Bozeman to allow for comments and edits, and then GTG will finalize all documentation prior to delivery. Here is an example of how we can deliver the GIS Data and Database Architecture and Data Maintenance Health Check final documentation: https://online.fliphtml5.com/otxj/ivoz/ GTG’s decades of experience providing superior GIS consultative services to governments, in addition to our established technical staff of GIS analysts, database administrators, IT professionals, GIS developers, and Enterprise GIS consultants, position us well to deliver the City of Bozeman a robust assessment of the organization’s geodata ecosystem. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 24 | Scope of Project GEOGRAPHIC TECHNOLOGIES GROUP Project Timeline Geographic Technologies Group believes a three-month timeline is feasible for this project. We recommend starting in February 2021 with a completion at the end of April 2021. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check E. Related Experience and Projects | 25 GEOGRAPHIC TECHNOLOGIES GROUP E. Related Experience and Projects Geographic Technologies Group serves government agencies of various sizes and characteristics. Our team has extensive and successful experience working with small villages and towns like Dutch Harbor, Alaska; the Town of Windsor, California; and the Village of Snowmass, Colorado. We have also provided plans for small and medium- size cities to include the City of Roswell, Georgia; City of Hobart, Indiana; City of Rio Rancho, New Mexico; City of Guelph, Ontario, Canada; City of Pearland, Texas; City of Titusville, Florida; City of Edina, Minnesota; City of Berkeley, California; and the City of Vancouver, Washington. Our experience with large organizations includes the City of Mississauga, Ontario, Canada; City of Pasadena, California; The Public Works Agency of Ashghal, Qatar; and Orange County, California. Our strategic planning clients also include counties of all sizes including Campbell County, Wyoming; Macon-Bibb County, Georgia; Forsyth County and Rockingham County, North Carolina; and Yuma County, Arizona, as well as multi-agency initiatives like the Lane County, Oregon GIS Consortium. GTG has conducted several projects related to the tasks requested in this RFP. They are as follows: Developed and Implemented Integration Tools, ETL Strategies, and Automation Scripts GTG is trained in FME software and has successfully implemented hundreds of ETL processes for GIS integrations with a myriad of systems and data formats. Most recently, our team has developed and implemented integration tools, ETL strategies, and automation scripts for many organizations including: • City of Lawrenceville, Georgia • City of Lathrop, California • City of Mansfield, Texas • City of Morgan Hill, California • City of Lauderhill, Florida • City of Roswell, Georgia • City of Pico Rivera, California • City of LaGrange, Georgia • Missouri City, Texas • Troup County, Georgia • Town of Ocean City, Maryland • City of South Portland, Maine City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 26 | E. Related Experience and Projects GEOGRAPHIC TECHNOLOGIES GROUP • City of Hobart, Indiana • City of Fort Pierce, Florida • Town of Snowmass Village, CO Recommended, Designed, and Deployed File, Enterprise, and Hosted Solutions Recently, we have recommended, designed, and deployed File, Enterprise, and Hosted solutions for the following organizations. Each client has unique data management, administration, and workflow needs. GTG assesses specific requirements for each client to ensure recommendations are not only in line with industry best practices, but that are the best fit for the client. • City of Lawrenceville, Georgia • City of Berkeley, California • City of Lathrop, California • City of Morgan Hill, California • City of Roswell, Georgia • City of Pico Rivera, California • City of LaGrange, Georgia • City of South Portland, Maine • City of Hobart, Indiana • Town of Snowmass Village, CO • City of Fort Pierce, Florida • City of Fulshear, Texas Planned, Designed, and Deployed Esri Utility Models and the LGIM The following is a list of organizations we have recently planned, designed, and deployed Esri Utility models and the LGIM. These data model implementations include an assessment of client needs and inclusion of custom attribute fields that may be needed by staff or other systems for integration. • City of Hobart, Indiana • City of Lawrenceville, Georgia • City of Morgan Hill, California • City of Roswell, Georgia • City of Fulshear, Texas • Town of Snowmass Village, CO City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check E. Related Experience and Projects | 27 GEOGRAPHIC TECHNOLOGIES GROUP Developed Data Maintenance and Improved Performance Solutions Regular data maintenance and performance tuning is critical for ensuring GIS solutions are adopted and used by local government staff. Our team has recently developed data maintenance and improved performance solutions for the following local government organizations. • City of Hobart, Indiana • City of Lawrenceville, Georgia • City of Morgan Hill, California • City of Roswell, Georgia • City of Mississauga, Ontario • Gwinnett County, Georgia • City of Fulshear, Texas Data Architecture and Data Maintenance Best Business Practices (BBP) We have demonstrated our ability to use Data Architecture and Data Maintenance Best Business Practices (BBP) for many local governments recently including: • City of Lawrenceville, Georgia • City of Berkeley, California • City of Lathrop, California • City of Mansfield, Texas • City of Morgan Hill, California • City of Lauderhill, Florida • City of Roswell, Georgia • City of Pico Rivera, California • City of LaGrange, Georgia • Missouri City, Texas • Troup County, Georgia • Town of Ocean City, Maryland • City of South Portland, Maine • City of Hobart, Indiana • City of Fort Pierce, Florida • City of Mississauga, Ontario • City of Fulshear, Texas • Town of Snowmass Village, CO The following is additional information regarding recent GIS projects GTG has completed for local government that have similar scopes as this project for the City of Bozeman. These similar projects demonstrate our experience working with local government entities of comparable size, structure, and complexity, as well as our expertise in GIS data and database architecture, and database maintenance. These projects are a testament to our commitment to delivering high-quality GIS consulting services on time and within budget. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 28 | E. Related Experience and Projects GEOGRAPHIC TECHNOLOGIES GROUP The City of Morgan Hill, CA selected GTG to develop a comprehensive GIS system architecture (web, application, and database tiers) as part of a plan to implement enterprise-wide GIS. After initial meetings and interviews with staff to determine the City’s needs, GTG created an Enterprise GIS Strategic Plan to provide overall context and guidance for the City’s program and to assure the proposed system met stakeholder needs. The next step was to review and assess the performance of the existing Morgan Hill GIS infrastructure, and gather information on the IT systems, data and databases, current workflows, and integrations of the system. A system was then designed capable of supporting the City user base, with GIS tools and web applications to meet the city’s needs for data management, Web and mobile applications, and GIS analytics. This assessment produced a depiction of how the City’s GIS has been implemented, how it is currently being leveraged, and what opportunities exist for strengthening and extending the organization’s GIS performance. Subsequently, GTG implemented a Morgan Hill production web GIS and geodatabases that adheres to Esri, industry, and GTG best practices. The system follows the multi-tiered principle of system architecture (database, application, & web tiers) and isolates these components to achieve workload separation. The GIS leverages Esri’s ArcGIS Enterprise/ArcGIS Online platforms and is supported by an Enterprise Geodatabase configured on Microsoft’s SQL Server Relational Database Management System (RDMS). The project included the design, configuration, and deployment of ArcGIS Enterprise Geodatabases, a data migration strategy and implementation, as well as setup of GIS integrations and data management workflows. GTG has also recommended and advised on ArcGIS Pro migration strategies. Contact Information Pam van der Leeden| GIS Manager| 17575 Peak Ave Morgan Hill, CA 95037 P: 669-253-4330 | E: pam.vanderleeden@morganhill.ca.gov| https://www.morgan-hill.ca.gov City of Morgan Hill, CA – 2019 Population: 45,037 1 City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check E. Related Experience and Projects | 29 GEOGRAPHIC TECHNOLOGIES GROUP GTG developed a GIS Needs Assessment and Strategic Plan for the City of Vancouver in the fall of 2017. This plan defined a common and unified vision and established a framework for City departments to efficiently and effectively use and improve the City’s use of GIS technology. The plan included an Implementation plan with specific prioritized actions to improve data workflows and management, as well as recommendations for database design, administration, and migrating to ArcGIS Pro. In 2020, GTG implemented the recommended GIS for the City of Vancouver. The implementation included a full GIS deployment of ArcGIS Enterprise and Geodatabases (web, application and database tiers). The database implementation included a detailed data migration plan and configuration for new data maintenance and database management workflows. Recommendations were also made on how to best utilize the ArcGIS Data Store for hosting GIS data versus maintaining data within the enterprise geodatabase. GTG also trained Vancouver staff on these editing and database administration/performance workflows. With all of these project tasks taken together, the City of Vancouver has a performant, scalable and sustainable GIS to support their current and future GIS activities. Contact Information Eugene Durshpek | GIS Supervisor | 415 W. 6th St. Vancouver, WA 98660 P: (360) 487.7174 | E: eugene.durshpek@cityofvancouver.us | https://www.cityofvancouver.us/ In 2018, GTG performed a needs assessment for key departments and developed a multi-phase GIS strategic plan to meet the goals and needs of the City. Following the Strategic Plan’s creation, the City selected GTG to push forward with helping implement the proposed enterprise GIS. GTG began by conducting a database assessment and providing database recommendations. GTG also migrated a majority of the City's GIS data from file geodatabases into an Enterprise geodatabase under the Local Government Information Model (LGIM). Throughout the past few years, GTG has City of Vancouver, WA – 2017 - 2020 Population: 174,826 2 City of Lawrenceville, GA – 2018- Current Population: 29,873 3 City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 30 | E. Related Experience and Projects GEOGRAPHIC TECHNOLOGIES GROUP also aided in data creation, developed Database administration/maintenance Standard Operating Procedures (SOPs), developed dynamic Web GIS applications, deployed mobile GIS solutions, deployed Production and Development GIS environments, and aided with the implementation of enterprise system integrations. GTG and the City are in Year-3 of the 5- Year GIS implementation. Contact Information Kyle Parker | IT Director | 70 S Clayton St. Lawrenceville, GA 30046 P: (678) 407-6406 | E: kyle.parker@LawrencevilleGa.org | https://www.lawrencevillega.org/ With a large network of sites, and GIS data dispersed and in multiple formats, STOF needed to prioritize the performance, stability, and security of their GIS and data. STOF partnered with GTG to provide many GIS related services. An initial focus was reviewing the infrastructure and developing a plan with recommendations for data performance and maintenance improvements. After a weeklong onsite visit at the STOF headquarters in Hollywood, Florida, GTG was able to identify several systems and workflow-related challenges, develop resolution strategies, and implement solutions to address the organization’s performance issues. GTG worked with STOF to increase system capacity and improved security practices. Additionally, GTG worked with internal GIS stakeholders to organize the Tribe’s existing knowledge base of GIS to improve their administrative capacity. The next step was to focus on improving data management and safety practices, extending the tribe’s capacity to administer its GIS data, and identifying opportunities to deliver superior GIS services to the tribe, their community, and their partners. GTG worked alongside IT and GIS stakeholders to identify data management workflows and practices, evaluate risks, and generate a prioritized data maintenance and security plan. To streamline system administration, develop Key Performance Indicators (KPIs), and improve the administration of the tribe’s GIS, GTG deployed, configured, and implemented ArcGIS Monitor for the Tribe. Next, GTG met with representatives from the Seminole GIS community and leadership to better understand their GIS operations, workflows, pain-points, and goals. These insights were translated into an actionable plan for the Tribe and its business partners. Seminole Tribe of Florida (STOF) – 2020-Current Population: 4,000 4 City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check E. Related Experience and Projects | 31 GEOGRAPHIC TECHNOLOGIES GROUP The STOF and GTG continue to work together as partners in the ongoing effort to advance the Tribe’s GIS and improve the lives of the Seminole community through improved GIS services. Currently, GTG is assisting the Seminole Tribe of Florida (STOF) to develop a CARES grant application to secure funds for their GIS Strategic Plan. GTG will work closely with the Tribe to plan, design, modernize, and implement a true enterprise and sustainable GIS. Contact Information Albert Cruz | Applications Support Manager | 6300 Stirling Road Hollywood, FL 33024 P: 954-660-6300x11486 | E: albertcruz@semtribe.com | https://www.semtribe.com/stof/home/ GTG developed a strategic GIS master plan and roadmap for Gwinnett County including departmental needs assessment and analysis, along with a 3-year tactical plan of action. This plan of action covered all departments of the County and GTG worked closely with staff to ensure that all data was accessible across departments and along various platforms. GTG performed data QA/QC along with geodatabase design, implementation, database administration, and performance tuning, and provided training sessions for stakeholders and County staff on Best Business Practices, and worked with staff to develop SOPs to ensure data standards were met. GTG worked with all departments to improve and verify address and street centerlines while performing data accuracy checks of this data. GTG has also performed AVL services and implementation for the County and helped the County develop automated workflows, Enterprise implementation and interoperability, dashboard creation and implementation, open portal applications, front-facing applications, story map creation, and various software integrations. GTG provides on-going consulting and maintenance services for the County. Contact Information Dax Flinn | IT Manager | 75 Langley Dr., Gwinnett, GA 30046 P: (770) 822-8033 | E: dax.flinn@gwinnettcounty.com | GwinnettCounty.com Gwinnett County, GA -2002-Current Population: 920,260 5 City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 32 | E. Related Experience and Projects GEOGRAPHIC TECHNOLOGIES GROUP The City of Lathrop was interested in developing a practical understanding of its GIS to improve geospatial operations, to more completely leverage the capabilities of their GIS, and to realize the potential of their GIS. In the Fall of 2019, the City of Lathrop engaged Geographic Technologies Group (GTG) to assess the existing GIS and make recommendations on modernizing and upgrading the current system. This assessment, along with GTG’s expertise and knowledge of GIS and IT industry best practices, resulted in a set of recommendations for the City aimed at improving performance and modernizing their GIS. This assessment also included an implementation action plan to guide the implementation of a modern, performant, and sustainable enterprise GIS, designed to meet the current and future needs of the City. GTG made multiple recommendations designed to meet GIS and Information Technology (IT) best practices, modernize their GIS, and provide exceptional geospatial services to both the City’s staff and its residents. Those recommendations centered on five foundational activities aimed at reimagining and improving geospatial operations at the City: GIS layers • Implement a distributed Web GIS using Esri’s ArcGIS Enterprise platform; • Design a compact, multi-tiered, service-oriented architecture (SOA) GIS that employed workload separation and unified system administration; • Consolidate the City’s geodata footprint (Distributed File Geodatabases) into a central data repository (Enterprise Geodatabase); • Update the GIS’s web application suite; and • Refactor and improve the City’s existing automated parcel management scripts. GTG consultants reviewed the City’s existing GIS and, with their unique and deep knowledge of enterprise GIS, designed a GIS that is both highly functional and sustainable. GTG’s design balances the competing interests of industry best-practices with organizational constraints and capacities and increases the City’s ability to manage, analyze, and share geospatial insights. These insights lead to a more informed decision-making process for City stakeholders, a more informed community, a higher return on investment, and a secure and stable GIS. Contact Information Tony Fernandes | CIO | 390 Towne Centre Dr. Lathrop, CA 95330 P: (209) 941-7349 | E: tfernandes@ci.lathrop.ca.us| GwinnettCounty.com City of Lathrop, CA – 2019 Population: 22,341 6 City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Statement of Qualifications | 33 GEOGRAPHIC TECHNOLOGIES GROUP F. Statement of Qualifications The adoption of geospatial technology within government organizations has increased the demand for sophisticated planning tools and techniques to assist in the complex implementation process. Our team’s wealth of experience demonstrated in our advanced GIS strategic planning publications, key-note speeches, GIS strategic planning books, extensive presentations, and very happy clients throughout North America and the world allow our team to be pioneers in strategic GIS planning and implementation. Geographic Technologies Group (GTG) is one of the world’s leading GIS Strategic Planning companies with very successful clients throughout North America and the world. Our team is working with many organizations, including towns, cities, counties, and Native American and Alaskan tribes to design smart GIS strategic plans that focus on geo-smart government, geo-empowered citizens, and geospatial data infrastructure. Our future includes a very different relationship with geospatial technology and geospatial data. Our team understands that government organizations need a step-by-step roadmap that will systematically build an enterprise, sustainable, scalable, and enduring GIS solution. In today’s world mission- critical to the success of all local governments, organizations are optimum GIS data and databases architecture with data maintenance and procedures. Our qualifications illustrate that we are a company that plans, designs, implements, and maintains enterprise solutions for local government. Professional Credentials, Experience, and Qualifications GTG professional credentials are illustrated in the number and complexity of local government clients throughout the world, particularly in North America. We are a GIS company with over 25 GIS specialists. Our most recent GIS strategic planning work has focused on GIS architecture and digital data storage, maintenance, and management. We are specialists in Esri File, Personal, and Enterprise Geodatabases and are working extensively with hosted solutions and Arc GIS Data Store and AGOL. Our team uses FME extensively to integrate data. Our team is also working on the following key components: • Data Management and Performance • Esri Data Models – Utility Network (UtilityGIS.com) City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 34 | Statement of Qualifications GEOGRAPHIC TECHNOLOGIES GROUP • FME and Total Data Integration • Smart Cities and Integration (SmartCityGIS.com) The following table illustrates our experience with the key components of this project as defined by the RFP. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check References | 35 GEOGRAPHIC TECHNOLOGIES GROUP G. References Geographic Technologies Group has worked with the following organizations, and they may be contacted for recommendations. GTG References City of Morgan Hill, CA Pam van der Leeden | GIS Manager| P: 669-253-4330 E: pam.vanderleeden@morganhill.ca.gov City of Vancouver, WA Eugene Durshpek | GIS Supervisor P: (360) 487.7174 E: eugene.durshpek@cityofvancouver.us City of Lawrenceville, GA Kyle Parker | Director P: (678) 407-6406 E: kyle.parker@LawrencevilleGa.org City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 36 | Present and Projected Workloads GEOGRAPHIC TECHNOLOGIES GROUP H. Present and Projected Workloads Present Workload Activities and Coordination Geographic Technologies Group (GTG) prides itself on its project management and capacity planning, allowing for our staff to have a manageable workload, and giving each of our clients the time and attention their projects deserve. GTG carefully considers the projects it takes on as a company, and hand-selects the team for each one, to ensure the team has the necessary availability to provide quality products and services to our clients. To ensure we do not go over our workload capacity, GTG uses numerous processes to measure the time consumption of each project: • Determine the scope and timing of each task by creating a detailed project schedule. • Break down each scope into smaller tasks and assign workstreams for efficiency. • Prioritize tasks based on importance or urgency. • Conduct frequent follow-up calls and meetings to ensure tasks are on-track. Project Team Workloads The assigned staff for this project will be available to assist the City of Bozeman with all scope items outlined in this RFP. Jason Marshall, GIS Director, is assigned as the Project Manager (PM) for this project. He is the only PM on one other project, GIS Strategic Plan for Peterborough, Ontario. The Peterborough project will only require 10% of his time as a majority of the writing will be done by GTG’s strategic plan writers. Mr. Marshall specializes in SOPs, data review, and GIS implementation. He has hand-selected his team based on their experience in each of the project deliverables. Each of the task members will be allocated the necessary time to produce exceptional deliverables. Mr. Marshall uses a comprehensive time-management process to ensure that each of GTG’s staff has the requisite bandwidth to produce products that exceed client expectations. Our motto for projects at GTG is this, “Understand that each project is very important to the client and organization. Deliver the project as if it were to be showcased as the opening presentation at the annual Esri User’s City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Present and Projected Workloads | 37 GEOGRAPHIC TECHNOLOGIES GROUP conference in front of the 120,000 attendees.” Having worked in local government, our team understands the needs of local government. We intend to build a longstanding relationship with the City and ensure that the City builds a sustainable GIS platform that will enable all staff, and the public, with the information necessary to make informed and insightful decisions. GTG’s step-by-step GIS system design and phased implementation plan is practical, detailed and logically organized. It continues to serve as our roadmap for success. They are on time, within budget, and with outstanding professional expertise. I would definitely recommend GTG to plan your GIS projects. - Calvert County, MD City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 38 | Key Personnel GEOGRAPHIC TECHNOLOGIES GROUP I. Key Personnel GTG consists of staff that has the proper education and work experience for this project. This team understands local government, are experts in the entire Esri suite of products and has extensive experience with assisting clients with full data, database architecture, and data maintenance reviews of an organization's GIS and other integrated asset management databases. Our team is also very knowledgeable on SQL Server Enterprise Geodatabases, ArcGIS Enterprise (referenced as well as hosted data), ArcGIS Online, data integrations using FME, and the use of ArcGIS Desktop and Pro to update and publish data consumed by internal as well as external users. GTG has hand-selected a team that is ready to help the City of Bozeman achieve its vision. GTG understands the consistency of a project team is important, however, if the need arises, any proposed replacement of a key staff member will have equivalent or better qualifications than the original staff member. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Key Personnel | 39 GEOGRAPHIC TECHNOLOGIES GROUP Mr. David Holdstock will be the lead contact for the City. For the duration of this project, he will serve as the GIS Advisor and Manager. He is one of North America’s leading authorities on GIS Consulting and Implementation in local government and has managed over 300 GIS consulting projects for cities, towns, and counties. Mr. Holdstock’s 2016 book “Strategic GIS Planning and Management in Local Government” and his 2020 “Smart Geospatial Practices and Applications in Local Government: An Altogether Different Language” book establishes him as a leading authority on GIS in local government. For this project, David will be successfully managing and providing oversight for the tasks outlined in the Scope of Services. He will also be the main presenter of all deliverables. Mr. Jason Marshall has 15 years of GIS experience and has provided technical expertise for GIS Needs Assessments and Strategic Implementation Plans for clients during his time at GTG. He designs, implements, and manages departmental GIS projects, data, and analysis, and has provided QA/QC services for all GIS implementations. He will have heavy involvement in all portions of the development of the deliverables requested in this RFP, and the writing of the assessment documents. He will provide recommendations for GIS data and database architecture and the data maintenance health check, policies and procedures, staffing needs, GIS technology, revenue generation sources at the City of Bozeman, and opportunities to expand on the GIS usage. Jason will also be conducting weekly progress reports and any Project Status Meetings. Mr. Andrew Valenski currently serves as an Enterprise GIS Consultant for Geographic Technologies Group. He works with clients to design, implement, and maintain custom GIS applications and processes. He helps clients determine what geospatial solutions work best for their organizational needs and designs them customized specifically for the client. These solutions include the following: GIS strategic planning, enterprise implementation, governance models, customized GIS software and applications, GIS architecture, data management strategies, updates and maintenance, training plans, and on-call support. Mr. Valenski previously worked as a Spatial Intelligence Developer for the City of Charlotte, NC. He served as a Senior Geospatial Server Analyst for Esri where he worked with the solutions and support teams to deliver server-side and web solutions for strategic customers. During his time with Esri, he implemented organization-wide performance dashboards. For this project Andrew will have heavy involvement in all tasks, performing reviews, and assisting Jason in providing recommendations to the City of Bozeman. DAVID HOLDSTOCK, BA, MS, GISP, CEO GIS Advisor and Manager | 25 years of experience JASON MARSHALL, BA, MA, GISP GIS Director | 15 years of experience ANDREW VALENSKI, BS, BA Enterprise GIS Consultant | 8 years of experience City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 40 | Key Personnel GEOGRAPHIC TECHNOLOGIES GROUP Ms. Jessy Beasley has worked with GIS data and Esri products for over 7 years. As a GIS Specialist and Technical Support for GTG, she has completed GIS Data Assessments, performed data QA/QC, and has analyzed many different GIS software system architectures, integration, and GIS assets. She is proficient in ArcGIS Online and has an understanding of File and Enterprise Geodatabase structures and subsequent data configuration, Hosted Feature Services including publishing, maintenance, and consuming, and geoprocessing, and workflow automation with Python and FME. For this project, she will support the team in understanding the current use of GIS, data management, and data needs, identifying gaps in the current system, and will assist in providing recommendations for best practices on GIS usage for the City of Bozeman, as well as contribute in the development of the deliverables in the scope of services. Resumes for each team member can be found on the following pages. JESSY BEASLEY MS, BS GIS Specialist and Technical Support | 7 years of experience DAVID H OLDSTOCK, GISP GTG CEO BA 919.222.1421 dholdstock@geotg.com EDUCATION MASTER OF SCIENCE – Natural Resource Management GIS Research Program NC State University BACHELOR OF ARTS: HONORS – Geography School of Humanities- Geography Greenwich University CERTIFICATIONS Geographic Information Systems Professional (GISP) AWARDS • Esri Cornerstone Partner Award • Esri Business Partner of the Year • 2017 Esri Partner Award Winner: Best Citizen Engagement Award • Multiple Esri Local Government Special Achievement (SAG) Awards • 2017 URISA Best Web GIS • 2017 URISA Best Public-Sector GIS PROFILE Mr. David Holdstock is one of North America’s leading authorities on GIS Strategic Implementation Planning in local government. He has secured GIS implementation awards for multiple organizations including the City of Guelph, Ontario, Canada, and the City of Unalaska, Alaska. Mr. Holdstock’s recent 2016 book “Strategic GIS Planning and Management in Local Government” and his future 2020 “Smart Geospatial Practices and Applications in Local Government” book establish him as a leading authority. Mr. Holdstock incorporated Geographic Technologies Group, Inc. (GTG) in 1997 with offices throughout the United States. Mr. Holdstock has over 25 years of GIS experience. He has planned, designed, and coordinated the implementation of GIS technology for over 300 towns, cities, and counties across North America. As Principle, his duties include GIS management, GIS planning, data and database assessments, design, and implementation of enterprise GIS programs, client contact, and project technical supervisor. Mr. Holdstock has provided GIS data and consulting services for over 300 clients and has managed complete entire GIS enterprise implementations. KEY EXPERIENCE • Expert in GIS Data and Database Architecture • GIS Integration Expert • Expertise in Database Management Best Business Practices • Experience with Enterprise Geodatabases • Has managed the deployment of Esri Solutions for Hundreds of Clients • Managed over 300 GIS Needs Assessments and Enterprise Implementations • Former GIS Manager for World’s Leading Transportation Engineering Company – Parson Brinkerhoff, Quade and Douglas (PBQ&D), NY • Develops Project Management Plans and QA/QC Procedures • Provides Oversight for GIS Data Management Projects & Enterprise Implementation • GIS/GPS Program Director at North Carolina State University – Institute for Transportation Research and Education (ITRE) SIMILAR PROJECTS City of Morgan Hill, CA- GIS System Architecture Design, Strategic Plan, GIS Data Services, Geodatabase Implementation, leveraging Esri’s ArcGIS Enterprise/ArcGIS Online platforms Seminole Tribe of Florida, FL- GIS Data Assessment, data management workflows and practices, evaluate risks, and generated a prioritized data maintenance and security plan City of Lawrenceville, GA- Data Maintenance and Improved Performance Solutions, Data Architecture BBP, Integration Tool Development, File, Enterprise, and Hosted Solution Deployment City of Vancouver, WA- Full GIS deployment of ArcGIS Enterprise and Geodatabases, detailed data migration plan and configuration for new data maintenance and database management workflows PUBLICATIONS Author of : 2016 Strategic GIS Planning and Management in Local Government 2020 – Smart Geospatial Practices and Applications in Local Government MS JASON MARSHALL, GISP 919.920.3071 jmarshall@geotg.com MASTER OF ARTS – Applied Geography Concentration in GIS University of North Carolina, Greensboro BACHELOR OF ARTS – Geography University of North Carolina, Greensboro Geographic Information Systems Professional (GISP) AWARDS • Esri Cornerstone Partner Award • Esri Business Partner of the Year • 2017 Esri Partner Award Winner: Best Citizen Engagement Award • Multiple Esri Local Government Special Achievement (SAG) Awards • 2017 URISA Best Web GIS • 2017 URISA Best Public-Sector GIS Mr. Jason Marshall has 16 years of GIS experience and has served as Project Manager for many of GTG’s GIS technical projects. He served as the Open Data Program Manager for the Information Technology Department of Greensboro. While there he formed and coordinated an enterprise wide cross-departmental Data Leadership Team and partnered and collaborated with external stakeholders to leverage City data for community benefit. He managed technology equipment research and coordinated with end-users to implement hardware and software IT solutions. He also designed, implemented, and managed the City’s Open Data Program (Socrata and ArcGIS Open Data Portals). He wrote SQL queries to leverage spatial and non- spatial data for analysis, and to support decision-making. Mr. Marshall coordinated and implemented multi-department data management projects to break down data silos. He has served as the GIS Application Developer for the Information Technology Department of the City of Greensboro, NC. He designed and executed ArcGIS Server and web GIS server architecture, system migration, and operating system upgrades, consistent data collection, data integration, and editing for the IT department. GIS DIRECTOR EDUCATION KEY EXPERIENCE CERTIFICATIONS PROFILE • GIS Project and Team Management • Designs, Implements, and Manages Departmental GIS Projects, Data, And Analysis • Performs Comprehensive Assessments of GIS Data Infrastructures and Database Architecture • Provides recommendations for Data Management and Maintenance • Conducts GIS Needs Assessments, System Designs, and Strategic Plans • Expert in GIS Integration • Provides Migration Strategies to ArcGIS • Identifies Performance Issues with GIS Technology • Manages Technology Equipment Research, Coordinates with End- Users to Implement Hardware and Software IT Solutions. • Performs Quality Assurance and Quality Control Techniques for GIS Data Projects SIMILAR PROJECTS City of Morgan Hill, CA- GIS System Architecture Design, Strategic Plan, GIS Data Services, Geodatabase Implementation, leveraging Esri’s ArcGIS Enterprise/ArcGIS Online platforms City of Lawrenceville, GA- Data Maintenance and Improved Performance Solutions, Data Architecture BBP, Integration Tool Development, File, Enterprise, and Hosted Solution Deployment City of Roswell, GA- Integration Tool Development, File, Enterprise, and Hosted Solution Deployment, File, Enterprise, and Hosted Solution Deployment Seminole Tribe of Florida, FL- GIS Data Assessment, data management workflows and practices, evaluate risks, and generated a prioritized data maintenance and security plan TECHNICAL SKILLS ESRI’s Suite of GIS Software, ArcGIS Server, ArcGIS Online, Socrata Open Data & Open Performance, SQL Server, Management Studio, Transact-SQL, Microsoft Excel, Plotly, R/RStudio, HTML5, CSS, JavaScript, React, Node.js, Postgres, C#, Powershell, Git, ObjectiveC MA BA ANDREW VALENSKI ENTERPRISE GIS CONSULTANT BS BA 516.524.2016 avalenski@geotg.com EDUCATION BACHELOR OF ARTS – Geography University of Richmond BACHELOR OF SCIENCE – Environmental Studies University of Richmond TECHNICAL SKILLS LANGUAGES: Bash, CSS, Git, HTML, JavaScript, JQuery, Powershell, Pug, Python, R, Ruby, SQL, SASS, TypeScript TECH/FRAMEWORKS: AWS, Azure, Bootstrap, Docker, GitHub, Leaflet, NodeJS, Rails, SSIS, SSRS, TFS, Wo, VMWare SOFTWARE/STACKS: Esri, GeoServer, Google, MapBox, MariaDB, MongoDB, MySQL, Oracle, PostGreSQL, QGIS, SQL Server CERTIFICATIONS • Enterprise Administration Certificate [Esri] • Enterprise Architecture Certificate [Esri] • Advanced GIS Certificate [University of Richmond] • Complete Data Science Certificate [Cert-School] • Web Development Bootcamp Certificate [Udacity] PROFILE Mr. Andrew Valenski currently serves as an Enterprise GIS Consultant for Geographic Technologies Group. He works with clients to design, implement, and maintain custom GIS applications and processes. He helps clients determine what geo-spatial solutions works best for their organizational needs and designs them customized specifically for the client. These solutions include the following: GIS strategic planning, enterprise implementation, governance models, customized GIS software and applications, GIS architecture, data management strategies, updates and maintenance, training plans, and on-call support. Mr. Valenski previously worked as a Spatial Intelligence Developer for the City of Charlotte, NC. While there, he designed, rebuilt and deployed an enterprise GIS. He also built and released over two dozen spatial and non-spatial applications. He served as a Senior Geospatial Server Analyst for Esri where he worked with the solutions and support teams to deliver server-side and web solutions for strategic customers. During his time with Esri, he implemented organization- wide performance dashboards. KEY EXPERIENCE • GIS Integration Strategist • Database management and maintenance experience • Expert in Enterprise Geodatabase Management • Recommends GIS Data Strategies for Clients • Experience with database design and system architecture. • Experience migrating hosted data in ArcGIS Enterprise and ArcGIS Online. • Builds and Deploys custom GIS and spatial applications for local government • Develops solutions to address organization’s data and GIS needs • Implements Enterprise GIS Solutions • Quality assurance and quality control (QA/QC) Procedures • Enterprise migrations, application development and geoprocessing development • Enterprise GIS design and administration, full-stack development • IT management and education SIMILAR PROJECTS Seminole Tribe of Florida, FL- GIS Data Assessment, data management workflows and practices, evaluate risks, and generated a prioritized data maintenance and security plan City of Lathrop, CA- Implement Web GIS using Esri’s ArcGIS Enterprise platform, Consolidated geodata footprint, architecture design City of Lawrenceville, GA- Data Maintenance and Improved Performance Solutions, Data Architecture BBP, Integration Tool Development, File, Enterprise, and Hosted Solution Deployment City of Vancouver, WA- Full GIS deployment of ArcGIS Enterprise and Geodatabases, detailed data migration plan and configuration for new data maintenance and database management workflows J ESSY BEASLEY 919.759.9214 jvanhorn@geotg.com Mrs. Jessy Beasley has worked with GIS data and Esri products for over seven years. As a Senior GIS Analyst for GTG, she has completed GIS Data Assessments, performed QA/QC, deployed software, and migrated data to Esri’s ArcGIS Utility Network and other standard schemas. She has developed GIS Training Plans and Standard Operating Procedures (SOPs). She has collaborated with analysts at county and state levels to develop GIS solutions for stakeholders. She served as a Physical Science Technician with the USDA-Agricultural Research Service, creating quality geodatabases that were used to build agricultural conservation plans throughout the Midwest. While at the USDA, she built multiple web applications using Esri’s Story Maps and Web AppBuilder to ease information transfer among government officials and the public. She frequently found solutions employing Python to automate processes and extract and maintain organized datasets. She also uses Esri’s ArcGIS Data Reviewer to manage and control data quality for GIS projects. She provides spatial modeling and analysis to improve GIS decision making. She has experience deploying ArcGIS Solutions for utilities and other themes. KEY EXPERIENCE • Six years of experience working with ArcGIS Desktop applications • Proficient in ArcGIS Online • Understanding of File and Enterprise Geodatabase structures and subsequent data configuration • Understanding of Hosted Feature Services including publishing, maintenance, and consuming • Geoprocessing and workflow automation with Python and FME • Data Integrity and QA/QC Procedures, including ArcGIS Data Reviewer, topology and network error checks, custom data assessment scripts • Develops data migration plans including data schema updates and data housing recommendations • Utility Network and LGIM implementation and migration • ArcGIS Solutions deployment and configuration • SOP development for implementing ArcGIS Pro, ArcGIS Online, and ArcGIS Enterprise in clients’ organizations SIMILAR PROJECTS City of Lawrenceville, GA- Data Migration, Data Validation, Application Development, Geoprocessing Automation City of Hobart, IN- Utility Network Migration, Implementation of ArcGIS Pro, Data Maintenance in Desktop and ArcGIS Online, Custom Applications, Data Collection City of Berkeley, CA- LGIM Adaption, QC Process Automation, Data Migration, Workflow Automation, Schema Changes Contra Costa Water District, CA- Data Integrity/Corrections, QC Process Automation, Data Migration, Tool Incorporation City of Irvine, CA- LGIM Adaption, Data Migration, Data Collection, Data QC, Application Development, Spatial Modeling CAL FIRE, CA- Data Migration, Data QC, Data Integrity/Corrections, QC Process Automation, Workflow Automation, Data Collection DATA SCIENTIST/ETL and SENIOR GIS ANALYST MS BS EDUCATION MASTER OF SCIENCE – Geography Certificate: GIS East Carolina University BACHELOR OF SCIENCE – Geography University of Florida CERTIFICATIONS Graduate Certificate in Geographic Information Systems AWARDS • Esri Cornerstone Partner Award • Esri Business Partner of the Year • 2017 Esri Partner Award Winner: Best Citizen Engagement Award • Multiple Esri Local Government Special Achievement (SAG) Awards • 2017 URISA Best Web GIS • 2017 URISA Best Public-Sector GIS PROFILE TECHNICAL SKILLS ESRI’s Suite of GIS Software, ArcGIS Enterprise, ArcGIS Online, SQL Server, Python, FME, JavaScript, R/RStudio, HTML5, CSS, Microsoft Excel and other Office products, Transact-SQL, Plotly, React, Node.js, Postgres, C#, Powershell, Git, ObjectiveC City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Price Proposal | 41 GEOGRAPHIC TECHNOLOGIES GROUP J. Price Proposal Geographic Technologies Group proposes the following price proposal to accompany the project tasks detailed in the scope of services. Project Task Cost 1. Review of the existing use of Enterprise Geodatabase $3,000 2. Review of the existing use of File Geodatabases $3,000 3. Review of the existing use of Hosted data (ArcGIS Enterprise Data Store and ArcGIS Online) $3,250 4. Recommendations for improving database maintenance and overall performance $2,600 5. Recommendations to improve data management (including integrations) $3,500 6. Recommendations for migrating to new data models (i.e. ArcGIS Solutions for Local Government, Utility Networks, etc.) $3,500 7. Recommendations on when to use a File Geodatabase, Enterprise Geodatabase, and Hosted Feature Services (ArcGIS Enterprise or ArcGIS Online), including best practice $3,600 8. Review of the existing GIS integrations and how to more efficiently use FME to channel data to the appropriate repositories (File Geodatabase, Enterprise Geodatabase, Hosted Feature Service, etc.) $4,000 9. A plan for transitioning from ArcGIS Desktop to ArcGIS Pro $3,500 Total Sum: $29,950 City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 42 | Additional Information GEOGRAPHIC TECHNOLOGIES GROUP K. Additional Information Geographic Technologies Group is the number one strategic company in the world, with extensive experience in Planning, Designing, Implementation, and Maintaining and Support. The following information is a testament to our outstanding GIS services and expertise. The following are testimonials provided by a few of our clients: The City of Roswell, GA “We chose GTG twice, once for our GIS Strategic Planning project and again to assist with implementation. Both times they were up against the best firms in the country, and both times they won our business hands down. Their approach, their people, their tremendous experience with local governments, and their costs all put them over the top.” The City of Guelph, Ontario, Canada “…the most progressive GIS company in the world…in-depth knowledge that is unparalleled in the industry; understands the needs of local government; a clear return on investment.” The Town of Windsor, CA “Their approach, their people, and their experience with local government was a perfect find for our organization.” The City of Lauderhill, FL “GTG has been wonderful to work with. They are professional, knowledgeable, and always there when we need then. I wish all my vendors were as responsive and thorough. I can always count on GTG!” – Joan Fletcher The City of Berkeley, CA Cristi Delgado said she appreciated the work that Geographic Technologies Group (GTG) did to analyze and highlight how GIS has the potential for greater use and impact at the City of Berkeley. The professional analysis of the GIS provided an independent view that she could share with decision-makers that helped her make the case for applying the recommended changes to the enterprise GIS. She said, “It also made GIS stakeholders feel they were being heard.” City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Additional Information | 43 GEOGRAPHIC TECHNOLOGIES GROUP The City of Mississauga, Ontario, Canada “ The GTG team was very responsive to our unique and evolving needs. They used their subject expertise to help us develop our vision and make key decisions over the project period. As a result, the final products were much improved from our initial concepts. From the planning to implementation stages, our office received quality service from the GTG team that made the process simple, on-time and on-budget. Our story map continues to receive praise and has proven to be a great asset for our website.” Bay County, FL Ms. Morgan states, “We are beyond pleased with the final GIS Master Plan. It identifies a clear path forward and tangible goals, objectives, and activities that we need to pursue. We want to be second-to-none and provide meaningful services to staff and residents. The GIS Master Plan is informative, instructive, and inspirational. We have a renewed vigor for GIS and this document not only inspires us but allows the entire organization to understand how GIS will benefit them.” The City of Irvine, CA “Our GIS is a success and our team has been implementing various end-user tools. However, we were missing a systematic plan to promote, socialize, and advance the GIS for all the users internally and externally. We know what GIS can do but we needed a fresh perspective and plan to advance GIS to a primary decision-making platform for the City. GTG was the answer.” The City of Boulder, OSMP, CO “GTG has raised the bar for strategic operational planning at the City. The process GTG used to create our IT/GIS SOP has become the gold standard for all future city strategic operations plans.” – Mo Valenta, Resource Information Supervisor for Boulder, CO Calvert County, MD “GTG’s step-by-step GIS system design and phased implementation plan is practical, detailed, and logically organized. It continues to serve as our roadmap for success. [They are] on time, within budget, and with outstanding professional expertise. I would definitely recommend GTG to implement your GIS projects.” Additional testimonials are available upon request. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 44 | Additional Information GEOGRAPHIC TECHNOLOGIES GROUP Geographic Technologies Group has been working with towns, cities, and counties for over twenty years. Here is a list of the last fifty (50) Cities we have worked with. Geographic Technologies Group City Clients 1. 2020: City of Fort Pierce, Florida - GIS Assessment – Data and Databases Architecture 2. 2020: City of Granbury, Texas - GIS Strategic Plan– Data and Databases Architecture 3. 2020: City of Tulare, California – GIS Strategic Master Plan – Data and Databases Architecture 4. 2020: City of Roswell, Georgia – GIS Strategic Plan Update – Data and Databases Architecture 5. 2019: City of Pico Rivera, California - Geospatial Master Plan – Data and Databases Architecture 6. 2019: City of Mississauga, Ontario, Canada - GIS Strategic Plan – Data and Databases Architecture 7. 2019: City of Lawrenceville, Georgia - 5 Year GIS Strategic Plan– Data and Databases Architecture 8. 2019: City of Farmers Branch, Texas - GIS Strategic Governance Plan– Data and Databases Architecture 9. 2019: City of Lathrop, California – GIS Assessment– Data and Databases Architecture 10. 2019: City of San Marcos, Texas - 5 Year GIS Strategic Plan– Data and Databases Architecture 11. 2019: City of Napa, California – GIS Strategic Assessment – Data and Databases Architecture 12. 2019: City of Lloydminster, Alberta, Canada – GIS Strategic Plan– Data and Databases Architecture 13. 2019: City of Morgan Hill, California - GIS Strategic Plan and Final Action Plan– Data and Databases Architecture 14. 2019: City of Hobart, Indiana - GIS Strategic Plan– Data and Databases Architecture 15. 2019: City of Irvine, California - 5 Year GIS Strategic Plan– Data and Databases Architecture 16. 2019: City of Boulder OSMP, Colorado - GIS Strategic Plan– Data and Databases Architecture 17. 2018: City of Berkeley, California - GIS Strategic Plan– Data and Databases Architecture 18. 2018: City of Vancouver, WA - 5 Year GIS Strategic Plan– Data and Databases Architecture 19. 2018: City of Markham, Ontario, Canada - 5 Year GIS Strategic Plan– Data and Databases Architecture 20. 2018: City of Lauderhill, Florida – GIS Strategic Assessment– Data and Databases Architecture 21. 2017: City of Nanaimo, British Columbia, Canada – GIS Strategic Plan– Data and Databases Architecture 22. 2017: City of Rocky Mount, North Carolina – GIS Assessment– Data and Databases Architecture 23. 2017: City of Wilmington, North Carolina – GIS Strategic Plan– Data and Databases Architecture 24. 2017: City of Boulder OSMP, Colorado - GIS Strategic Operations Plan– Data and Databases Architecture 25. 2017: City of Simi Valley, California - 5 Year GIS Strategic Plan– Data and Databases Architecture 26. 2017: City of Roswell, Georgia – GIS Strategic Plan Update– Data and Databases Architecture 27. 2017: City of Providence, Rhode Island – GIS Strategic Plan for Public Works– Data and Databases Architecture 28. 2016: City of Missouri City, Texas – 5 Year GIS Strategic Plan– Data and Databases Architecture 29. 2016: City of Roseville, California – GIS Strategic Plan– Data and Databases Architecture 30. 2016: City of Louisville, Kentucky – GIS Assessment and Implementation– Data and Databases Architecture 31. 2016: City of Boynton Beach, Florida – GIS Strategic Plan Update– Data and Databases Architecture 32. 2016: City of Concord, California – GIS Strategic Plan– Data and Databases Architecture 33. 2016: City of Lake Worth, Florida – GIS Strategic Plan– Data and Databases Architecture 34. 2016: City of Rockwall, Texas – GIS Assessment– Data and Databases Architecture 35. 2016: City of Fulshear, Texas – GIS Strategic Plan– Data and Databases Architecture 36. 2015: City of Roswell, GA – GIS Strategic Plan– Data and Databases Architecture 37. 2015: City of Bossier City, Louisiana – GIS Plan– Data and Databases Architecture 38. 2015: City of Guelph, Ontario, Canada – GIS Strategic Plan– Data and Databases Architecture 39. 2015: City of Lauderdale Lakes, Florida – GIS Strategic Plan– Data and Databases Architecture 40. 2015: City of Truckee, California – GIS Assessment– Data and Databases Architecture 41. 2015: City of Greenville, North Carolina – GIS Strategic Plan – Data and Databases Architecture 42. 2015: City of Fresno, California – GIS Strategic Plan– Data and Databases Architecture 43. 2014: City of Sunnyvale, California – GIS Assessment– Data and Databases Architecture 44. 2014: City of Eagan, Minnesota – GIS Strategic Plan– Data and Databases Architecture 45. 2014: City of South Bend, Indiana – GIS Assessment – Data and Databases Architecture 46. 2014: City of Johnson City, Tennessee – GIS Strategic Plan– Data and Databases Architecture 47. 2014: City of Healdsburg, California – GIS Strategic Plan– Data and Databases Architecture 48. 2014: City of Charleston, West Virginia – GIS Strategic Plan – Data and Databases Architecture 49. 2013: City of West Hollywood, California – GIS Implementation Plan– Data and Databases Architecture 50. 2013: City of Pasadena, California – Enterprise GIS Strategic Plan– Data and Databases Architecture GTG produces newsletters to provide our clients and followers with the most up- to-date GIS News. The following pages are from our December 2020 edition. s we near the end of 2020, we still find ourselves in uncertain times. We are all asking similar questions – “Will budgets be cut?” “Is my job safe?” “Will our department get any funding this year?” The list of concerns and worries go on, and all are valid. These are good questions to consider, as they bring up important items to plan for. The sustainability of your GIS program relies on you and your team. Here are some questions you should be asking yourself: • Have I made my GIS recession-proof? • Have I educated my organization about the benefits of GIS? • Have I showcased impactful projects? • Have I quantified return on investment? • Is our GIS program seen as indispensable? As GIS professionals, we understand the importance of GIS as a decision-making platform. But do decision-makers in your organization have the same understanding? One of the “Keys to GIS Success” is to educate your organization. If you don’t, who will? Many organizations are ahead of the curve and have checked every box needed to ensure sustainability and prominence. One of the key tools being used nationwide is a GIS Executive Playbook. You must educate your organization about the power and indispensability of your GIS platform. An Executive Playbook (EP) has been used by numerous organizations as a way to tell the story of the GIS program to non-GIS people. A good EP highlights and explains graphically how GIS is and should be embedded in all facets of an organization. An EP should include: • An overview of how GIS aligns with, supports, and is essential to achieving organization-wide goals. • Key Performance Indicators (KPIs) for your GIS program. • Success stories featuring impactful GIS projects. • A game plan for the next few years. • Vision, goals, and objectives for GIS within your organization. The City of Lawrenceville, Georgia used its EP to highlight the progress of its first two years of GIS implementation. Gwinnett County, Georgia used their EP to show how ingrained their multi-decade GIS program is to the success of the County. Bay County, Florida’s GIS EP focused on its numerous success stories supporting emergency management and acting as the information hub for the county. Jennifer Morgan, GIS Manager at Bay County, explains, “The GIS EP was a perfect way for us to showcase our GIS program to executives and the public. Decision-makers went from knowing that a GIS existed to understanding that it was indispensable.” For more information and/or a remote presentation for your team, contact Curt Hinton at chinton@geotg.com. To view the Bay County EP follow this link - https://fliphtml5.com/otxj/ivoz/ HOW TO ENSURE GIS SUSTAINABILITY IN 888.757.4222 • www.geotg.com 1 A 888.757.4222 | DECEMBER 2020 Location Matters HOLIDAY EDITION Bay County’s Success Stories City of Lawrenceville’s KPIs 2 Throughout 2019 and 2020, the City of Irvine, CA worked with Geographic Technologies Group (GTG) to create an Enterprise GIS Master Plan and Enterprise Data Management Plan. The City has a very innovative GIS team with a strong desire to ensure that GIS aligns with City Council’s overall vision and goals. One of the showcases of the City of Irvine is the Orange County Great Park, a former Marine Corps Air Station (El Toro) that has been reimagined as a multi-purpose park. The park spans 1,300 acres and offers a diverse set of activities and recreation opportunities, which could not happen without significant planning. After the completion of the Master Plan, GTG was retained to assess the LiDAR data for usability. Jessy Beasly, GTG Senior GIS Analyst, points out, “We have extensive experience in the utilization of 3D data. The City needed to understand how this data could be used for park planning and visualization. Our team evaluated the data for quality and usability and to generate an estimate of time to process a terrain model.” Metadata, LAS dataset statistics, and coverage of datasets were analyzed to ensure completeness and quality. The eventual outcome of the project was a report that identified the necessary steps to generate a high-resolution elevation surface and a 3-D model for use in a variety of planning projects for the park. Jason Marshall, Director of GIS Consulting at GTG, explains, “Most of our clients have a vast wealth of data available to them but may not have the time or the internal technical skillsets to leverage the data for decision making. In this case, the City had invested in the acquisition of high-resolution geospatial data and was not using it to its fullest potential. Our team of data experts identified the steps necessary to integrate this data into the overall geospatial effort of the City and, specifically, Great Park.” For more information on data assessments or GIS strategic planning, contact Jason Marshall at jmarshall@ geotg.com or 919.920.3071. You can also learn more about GTG and our services for Parks and Recreation at GreenCityGIS.com. ak Ridge National Laboratory (ORNL) in East Tennessee is managed by UT-Battelle for the United States Department of Energy and delivers scientific discoveries and technical breakthroughs needed to realize solutions in energy and national security and provide economic benefit to the nation. The lab is located just 30 minutes west of Knoxville on a campus covering approximately 4,500 acres. ORNL has about 5,100 staff and hosts more than 3,200 guest researchers and visitors on site each year. To support the campus and its personnel, ORNL operates the Laboratory Emergency Response Center that answers 911 calls and an average of 2,100 non-emergency calls (such as power outages and water leaks) each month. While ORNL had an existing Esri Enterprise license and base GIS maps of the laboratory site, they were looking to improve their Computer-Aided Dispatch (CAD) and add mobile tools and Automatic Vehicle Location (AVL) technology. In October 2019, Geographic Technologies Group (GTG) partnered with Professional and Technical Software Solutions (dba PTS Solutions) to provide a new CAD system integrated with GIS for Dispatch and Mobile Mapping with AVL. To streamline ORNL operations, GTG installed Vantage Points Dispatch integrated with PTS Platinum CAD, Vantage Points Mobile integrated with PTS Platinum CAD, and Vantage Points AVL. With these Dispatch, Mapping, and CAD solutions in place, institutions can experience quicker emergency response, increased efficiencies, more accurate data, and a streamlined dispatch and incident response process. “Our dispatchers and responders need tools that improve their ability to mitigate emergency and non-emergency incidents,” said Keith Yahr, ORNL Laboratory Shift Superintendent. Historical data is at their fingertips for data-driven decision making, and the complex is now well-prepared for both emergency and non-emergency events. All Vantage Points products are part of the GTG SafeCityGIS suite and are now referenced by the SafeCity brand name only. For more information, please visit SafeCityGIS.com or reach out to our team at 888.757.4222 or moreinfo@geotg.com. 888.757.4222 • www.geotg.com Irvine Elevates Park Planning with LiDAR and 3D Imagery As a Geospatial Smart City, GIS Technology Simplifies E911 Dispatch and Emergency Response O Orange County Great Park Overview Map Analysis of spatial coverage and resolution of the LiDAR data. SafeCityGIS Vantage Points Viewer 3888.757.4222 • www.geotg.com BEYOND LOCATION INTELLIGENCE Critical Steps to GIS Success TIMELINE OF GIS AND GEOSPATIAL TECHNOLOGY From the first explorers to the Information Officers of today, the evolution of GIS has guided the actions and movement of governments and civilization. From 1960 to 1980, GIS pioneers proved the concept had value and began actively applying spatial data and reasoning to their work. GIS moved to desktop applications and provided further analysis to governments and independent agencies in the last two decades of the century. From 2000 to today, GIS has become an enterprise, strategic, and scalable resource for GIS Coordinators and the local governments they serve. What will the GIS landscape look like tomorrow? We are quickly moving toward smart, resilient, and sustainable Geographic Information Systems (GIS). GIS CHALLENGES, BARRIERS, AND PITFALLS Building an efficient GIS requires time, effort, and focus. Properly addressing challenges, breaking down barriers, and avoiding common pitfalls are all key to success. Here are a few potential challenges, barriers, and pitfalls to expect: Challenges (Senior Staff) • No GIS Strategic Plan • Lack of GIS Vision and defined goals • No quantifiable return on investment • Not selling or promoting GIS • No buy-in from elected officials and decision makers Barriers (Technical Staff) • Struggling to secure GIS Funding • No measurable results set • No governance model established • Lack of good management techniques • No enterprise database or architectural design Pitfalls (Departmental Staff) • Poor data accuracy • No strategy for training and education • Lack of succession planning • Poor IT infrastructure • GIS is too complicated • No GIS promotions or publications GIS STRATEGIC PLANNING AND MANAGEMENT GTG employs six pillars of GIS sustainability to build the foundation for GIS strategic planning and management. They are GIS governance; digital data and databases; procedures, workflow, and integration; GIS software; infrastructure; and GIS training, education, and knowledge transfer. These pillars provide guidance for the development of GIS key performance indicators (KPIs) and benchmarking analysis. A Smart City implements and maintains state-of-the-art GIS procedures, protocols, and standards across all departments. It is a complete GIS ecosystem with big data analytics, certified and trained users, and an enterprise-wide IT infrastructure. Smart Cities utilize geospatial technology for outreach, engagement, interaction, and feedback, both internally and with the public. It maintains a hybrid and regionalized governance model with a full suite of Smart City technology. Innovative GIS Strategic Planning in 2020 considers five key attributes. It is strategic, enterprise, sustainable, scalable, and enduring. Our strategic GIS planning philosophy includes a methodology that is deliberate, considered, intentional, and tactical, supported by well-calculated planning and decision-making. Within the GIS Strategic Planning process, there are three phases and seven steps. Phase One includes the first four steps: an online questionnaire for stakeholders; a kick-off meeting and technology seminar; departmental interviews, and a GIS Needs Assessment and findings presentation. Phase Two is the development of alternative system designs to help an organization decide on the best system for their GIS strategy. And the final phase is steps six and seven: a Business Plan and ROI Analysis along with the delivery of the GIS Strategic Plan. ESRI ECOSYSTEM AND INNOVATIVE SOLUTIONS GIS Strategic Planning leads directly to the design and implementation of custom software and data processing and storage solutions. Esri software and tools are leveraged for local governments around the world. The Esri ecosystem includes solutions for departmental use, mobile field tools, and community engagement across desktop, web, and mobile applications. There are a plethora of options for implementation including ArcGIS Hub, Operational Dashboards, ArcGIS Map Viewer, Open Data portals, Story Maps, Workforce, the Collector App, and ArcGIS Online, just to name a few. GTG has also developed tailored GIS software solutions for all sectors of local government. GISPlan focuses on Enterprise GIS Strategic Planning. SafeCityGIS provides geospatial solutions for Public Safety. GreenCityGIS is a suite of software and services specifically for Parks and Recreation Departments. UtilityCityGIS is GIS built for the needs of Public Works and Utilities. FiberCityGIS provides telecommunications planning, design, analysis, and software management solutions. And, finally, SmartCityGIS is a comprehensive business line to house geosmart solutions for all government organizations. THE FUTURE OF GEOSPATIAL MANAGEMENT With a projected 9.8 billion people living in the world by the year 2050, geo-smart government will play a significant role in the management of our future towns, cities, and counties. Allowing geospatial science to guide decisions will align growth with the needs of all citizens and public service delivery. CONCLUSION Smart City technologies create a system of systems, sustainable communities, regionalization of GIS, and (ultimately) a total GIS ecosystem. As you work to build a successful GIS program for your organization, keep in mind the history of GIS, potential challenges you will face, strategic planning considerations, the plethora of available tools, gaining decision-makers’ buy-in, and preparing for an innovative future. The future is the present; We react, we do not predict. This content is adapted from our exclusive webinar series with GISP and GTG CEO, David Holdstock Password: GTGbli10 In thirty years, the world’s population will be nearly 10 billion people, out of which 6.7 billion will live in cities. This rapid population growth will increase the demand for employment, housing, energy, clean water, food, transportation, health, education, social services, social equity, and safety. Our towns, cities, and counties will be asked to find new ways to protect the community, improve citizen access, comply with regulations, respond and interact quicker with citizens, process and interpret social media data, and openly, transparently and effectively manage our resources. Geospatial practices and applications are not only helping government meet these demands, they are redefining how we do it. This book: • Introduces the six pillars of GIS sustainability. • Describes the logical stages of GIS maturity and evolution. • Details the geosmart ‘connected city’ of the future that embeds information technology into the decision-support apparatus of local government. • Explains High-Performance Organizations (HPO), and the art of Business Realization Planning (BRP). • Discusses the tools for measuring resilience, the key to our sustainable future. • Gives the reader a practical and understandable way of thinking about a smart ‘application centric’ geospatial ecosystem. ne of the challenges for most local government agencies is geo-enabling data. Many analysts spend most of their day just massaging and normalizing data, not performing analysis. This shouldn’t be the case. All of this should be automated. Too many hours are wasted by downloading data and accessing data, writing scripts, etc. In the perfect world, this is done automatically. It is time to break down these barriers and get busy solving problems. Geographic Technologies Group (GTG) has worked with over 500 agencies nationwide and decided to do something about the time suck of manual geo-enablement, which led to the creation of GeoAdaptor. The City of Lacey, Washington, a long-time client of GTG, reengaged with our team in 2020 for assistance with a data migration. Their 2008 server was end-of-life and being upgraded to a new machine. When our GTG team got the call, we were able to inform them that we would not only be able to migrate data to their new server, but we would also upgrade their outdated GTG GeoMax platform to our new GeoAdaptor software. GeoAdaptor allows for data mashup, synchronization, spatial enabling, aggregation, automation, data fusion, extraction, and reporting. It has the ability to automatically geocode and output GIS data layers from any non-spatial database. The City of Lacey utilizes this adaptive software for pulling land management data from their Enterprise Resource Database into a GIS Viewer. GIS Viewers are only as useful as the data integrated with the interface. GeoAdaptor pulls data from any city resource and puts it on the map to spatially enable information. This innovative software can create new digital data layers with unique user-defined attributions. Users can combine and merge data attributes from multiple sources to create unique GIS layers for analysis. GeoAdaptor is used to schedule multiple database manipulation routines, including real-time geocoding, reporting, layer output, spatial overlay analysis, and database export to run every minute, every hour, or every day. GeoAdaptor is a must-have tool for all agencies and ensures the vital information you need is always at your fingertips. Call us at 888.757.4222 for a no obligation, no pressure demonstration. You can also learn more at GeoAdaptor.com. An Altogether Different Language SMART GEOSPATIAL PRACTICES AND APPLICATIONS IN LOCAL GOVERNMENT: Automate and Analyze O 888.757.4222 • www.geotg.com 4 UNDO THE TIMEWASTER: The Author, Mr. David Holdstock, BA, MS, is a GIS Professional and CEO who co-established and incorporated Geographic Technologies Group in 1997. Smart Geospatial Practices and Applications in Local Government is the guide that details our future GIS applications and practices in local government. It is available now on Amazon.com. 5888.757.4222 • www.geotg.com THE BENEFITS OF A GIS ROADMAP FOR A SMALL INNOVATIVE CITY Implementing State of the Art Technology on a Budget Case Study: City of Fort Pierce, Florida A gem on the Treasure Coast of Florida, the City of Fort Pierce is known as a quaint fishing village and has a mission “To provide community leadership, quality public service, and a safe environment for all citizens, by an empowered team of employees motivated by pride in themselves and their work.” To support its mission and provide excellent service to the community, city officials employed the guidance of Geographic Technologies Group (GTG) to fully utilize GIS technology, beginning with the development of a Strategic Implementation Plan in February of 2020. Their comprehensive and multi-year GIS Implementation Plan involved a GIS Needs Assessment, Alternative System Design, and a Phased GIS Implementation Plan to create a roadmap for success. Work on the City of Fort Pierce’s project began with telephone and onsite interviews with IT and GIS department staff as well as key staff members from other departments to assess their experience with and knowledge of GIS. This information collection phase led to the creation of a GIS Needs Assessment report that identified high-priority GIS application needs for internal and external use. The assessment process effectively provided a benchmark of existing GIS conditions, an analysis of existing gaps, and the introduction of Key Performance Indicators (KPIs) by which to monitor and measure future growth and success. The City of Fort Pierce’s identified needs included enterprise-wide initiatives and departmental solutions. Of highest priority was the creation of a City-wide Geospatial Hub solution to include Web Apps, Dashboards, and Story Maps for each department. ArcGIS Hub is the future of data sharing and data communication and includes the following applications from GTG and Esri. • Web Apps – Web AppBuilder for ArcGIS is an intuitive application that includes powerful tools to configure fully featured HTML apps, made to display and analyze data on any device. Developers can build custom widgets and themes to extend Web AppBuilder for ArcGIS. • Dashboards – Today’s statistical dashboards help monitor important real-time information about the day- to-day operations of government. Custom statistical real-time, data-driven dashboards provide a comprehensive view of the data most important to the viewer. • Story Maps – A Story Map is an extraordinary tool that allows creation of inspiring geospatial stories by combining text, interactive maps, and other multimedia content. This application harnesses the power of maps and geography to tell a story. Departmental needs were addressed at the City to provide integrated utilization of GIS at the Enterprise level. GTG recommended the Building Department implement a Building Permit App and Dashboard, a Hurricane Preparedness Dashboard, and a Damage Assessment App. The Police Department recommendations included a Command Center Dashboard integrated with their RMS, a Hazard Mitigation and Preparedness App, a Crime Mapping App and Dashboard, a public- facing Story Map, and ArcGIS Insights for crime analysis. The Public Works Department received recommendations for implementing a Parks Amenities App, Street and Drainage Asset Management App and Dashboard, Solid Waste Routing and Scheduling App, and a Park Asset Inventory with GTG’s GreenCityGIS suite of services. Detailed recommendations were also included for Code Enforcement, Animal Control, the City Marina, the Engineering Department, and Planning Department. Further enterprise recommendations included My Government Services App, crowdsourcing applications like Survey123, field data collection (Collector for ArcGIS and ArcGIS Quick Capture), and work order management with Workforce for ArcGIS. All recommendations were presented to the city in order of priority and efficiency for department teams. With needs prioritized, GTG’s team delivered the strategic plan for GIS implementation. Detailed steps were included for all ten high-priority GIS projects, and included the purpose, outcome, and best practices. The next step was to present the final findings to key Fort Pierce stakeholders. Discussions took place to determine the needed budget and to set a step-by-step schedule for full implementation. GTG also included a plan for maintaining GIS applications, which created a sustainable strategy for the City of Fort Pierce. The GIS strategic planning process helped the City of Fort Pierce understand their existing GIS conditions, identify needs, and build a long-term plan for healthy and sustainable growth. Benefits of GIS implementation include a more informed and engaged public, more efficient communication between departments, and streamlined data sharing. With staged implementation, GIS is truly scalable and sustainable. To learn more about GIS roadmaps and strategic planning, visit GISPlan.com. You can also reach a GIS expert at 888.755.0422 or via email to moreinfo@geotg.com. 1202 Parkway Drive Goldsboro, NC 27534 Phone: 888.757.4222 888.757.4222 • www.geotg.com 6 HOW “SMART” IS YOUR CITY? According to Esri, “Smart, in the context of government, is associated with the use of real-time data, 3D visualization, the application of artificial intelligence for automation and optimization, and other technologies being enlisted to improve the lives of citizens” (2019). New and advanced technologies aid government agencies in the search for innovative solutions to complex problems. Smart Cities, then, are ones that strive to keep pace with ever-changing technologies to improve operations and better serve their communities. The centric attribute of “smart” in local governments equates to “where.” Everything local government offers is dependent on where citizens are, the proximity of utilities, the location of amenities and facilities, distances and response times for emergency teams, and a myriad of other considerations vital to creating a safe and thriving community. The need for location technology is filled by the implementation of GIS applications, services, and strategic plans. GIS is empowering local government agencies to increase efficiencies, improve services, and save time, money, and lives. Chris Thomas, director of government marketing at Esri, explains, “We look at everything through the lens of geography. Everything we do requires a focal point, which is where people live, work, and play. This is why GIS is recognized as a foundational part of every smart strategy.” To support the creation of a Smart City and Smart Communities, you must build a foundation on geospatial data that all funnels into a well-constructed GIS. Remember that Smart is a process. There isn’t one project, one application, or one solution that will result in a Smart City. You must engage in strategic GIS planning, learn from failures, and build on your successes. We can help you build your Smart City and Smart Communities with innovative GIS solutions. Reach out to our team by calling 888.757.4222, emailing team@geotg.com, or visiting us online at geotg.com. p.1 How to Ensure GIS Sustainability in Uncertain Times p.2 SafeCityGIS: GIS Technology Simplifies E911 Dispatch and Emergency Response p.2 Irvine Elevates Park Planning with LiDAR and 3D Imagery p.3 Beyond Location Intelligence: Steps to GIS Success p.4 Undo the Timewaster with GeoAdaptor p.4 Smart Geospatial Practices and Applications p.5 Implementing State of the Art Technology on a Budget p.6 The Smart City Evolution INSIDE this issue THE SMART CITYTHE SMART CITYEvolution City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check Affirmation of Nondiscrimination & Equal Pay | 45 GEOGRAPHIC TECHNOLOGIES GROUP L. Affirmation of Nondiscrimination & Equal Pay Appendix B NONDISCRIMINATION AND EQUAL PAY AFFIRMATION ___Geographic Technologies Group________(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, ___ Geographic Technologies Group_________(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. __David Holdstock, CEO__________________ Name and title of person authorized to sign on behalf of the submitter. City of Bozeman | MT Proposal: GIS Data and Database Architecture and Data Maintenance Health Check 46 | Affirmation of Nondiscrimination & Equal Pay GEOGRAPHIC TECHNOLOGIES GROUP