Agenda — Fairfield City Council, August 16, 2022 (part 2 of 7)

Stackhouse developed the majority of the scripts used by CAL FIRE and provided multiple knowledge transfer sessions with their staff.

Aquatic Invasive Plant Treatment (AIPT), California Department of Boating and Waterways (DBW) and Crowe LLP
Mr. Stackhouse serves as the Project Manager for the DBW AIPT project. In 2004, VESTRA worked with the DBW to assist in developing an Enterprise GIS for their Aquatic Weed Program. The system included a complete “field-to-back office” system that utilized ArcPAD and ArcSDE. In 2018, DBW contracted with VESTRA to upgrade this system to Esri’s latest technology (ArcGIS Portal, Survey123 and Collector).

In addition to acting as the Project Manager, Arthur designed and developed the surveys that will be used by DBW in the field and developed the scripts that are run nightly to QA/QC the data and prepare it to be uploaded into the historic record that is used for reporting and visualization. Once the DBS field data collection upgrade has been completed, DBW intends to begin investigation of the integration of image processing into their aquatic weed control program.

Regional GIS Platform-Feasibility Study, Shasta County Regional Transportation Agency, Redding, CA Mr. Stackhouse acted as the Senior Project Manager for the GIS Platform Feasibility Study. This study was an analysis related to the concept of a regional GIS data warehouse where spatial analysis, decision-making support, and a framework to develop custom tools and applications could be made available. Professionals from all eight region’s well-respected GIS community participated during each phase of the study, acting on behalf of their respective agency/organization and the greater region by way of the Far North Regional GIS Council.

The Feasibility Study was the region’s first step toward the compilation, standardization, and merging of many GIS data silos under one roof. The overarching goal of the effort is to minimize or eliminate the technological and informational barriers to coordinated regional planning. As the Senior Project Manager, Mr. Stackhouse was instrumental in developing the scope of the study, which included an exploration and evaluation of data needs, data standards, software and technology options, hosting and hardware options, and implementation strategies.

Business Process Re-Engineering, California Department of Transportation, Sacramento, CA Mr. Stackhouse provided high-level business intelligence support to Caltrans during their efforts to reevaluate their business processes. A Business Process Re-engineering was the first step towards envisioning a new system with more stream-lined processes, which will in turn facilitate major upgrades and/or replacements to one or more components of the existing system(s). Mr. Stackhouse used a structured approach for this re-engineering effort which helped ensure that core business functions were clearly addressed, and that future processes were supported. He worked with the stakeholder to identify gaps between the existing core processes as performed and these future processes. The methods used included project management, quality assurance, Michael Hammer’s BPR Method, and the Oracle CASE*Method.
eWRIMS—State Water Rights Information System, California State Water Resources Control Board The Web-based Enhanced Water Right Information Management System (eWRIMS) was developed to track information on water rights in California. eWRIMS contains information on water right permits and licenses issued by the State Water Board and other claimed water rights. eWRIMS is also a module of the State Water Board’s California Integrated Water Quality System (CIWQS) program. Arthur and his team developed a Web- based interactive mapping application which allows Water Board personnel to collect place-of-use data while in the office or field, supporting water right application and processing, and provides the following capabilities to the State Water Resource Control Board, Division of Water Rights: 1) Real-time access to water DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 238 of 1251Attachment 2 Page 24 of 42

Arthur Stackhouse

Page 6 of 6 ends

rights data to both Water Board users internally and the general public; 2) Web-based GIS editing, allowing internal users to add, delete, and modify water right points of diversions through a Web-based interface; 3) Login and password security control for State Water Resource Control Board employees; and 4) Upstream and downstream searching of water rights within eWRIMS based on the geolocation of 20,000 place-of-use points which were linked by Mr. Stackhouse’s programming staff to statewide copy of the National Hydrographic Dataset. Arthur also oversaw the development, testing and deployment of a set of custom applications that support field-based GPS data collection of place-of-use information, including both desktop and mobile GPS application components.

Environmental and Cultural Review Application, California Department of Parks and Recreation As the Senior Project Manager, Mr. Stackhouse successfully supervised the completion of two Web-based applications that helped facilitate the incorporation of GIS technology into the day-to-day workflow for development and review of capital outlay projects at the Department of Parks and Recreation (DPR). The first is the Environmental and Cultural Review Application (ECRA), a Web application was developed using JavaScript that supports DPR’s CEQA-related compliance work. The ECRA facilitates the internal Parks CEQA process, allowing users to track project status, review documents, create and edit project boundaries, and export CEQA-related documents. The second web application functions as a metadata catalog for digital and non-digital information housed at each individual park unit. There are two main tools: 1) Park units have the ability to upload metadata about files held at that specific unit, and can even upload the file if it exists in digital form, and 2) Allows users to access the metadata catalog for related documents from the CEQA/ECRA application. Arthur designed a geodatabase that housed the GIS information, as well as raster images, for various facilities through the park system. This design also provided a basic link to DPR’s existing facilities management application, MAXIMO by MRO Software.

Technical Capabilities
Visual Studio 2010
ArcGIS for Desktop 10.x
ArcGIS Pro
ArcGIS for Server 10.x
Portal for ArcGIS
ArcGIS Online
ArcGIS Python API
Windows Server 2008, 2010 and 2012R2
SQL Server 2008, 2010 and 2012R2
SQL Server Administration
Windows Server 2008 Administration
DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 239 of 1251Attachment 2 Page 25 of 42

Experience Highlights
Experienced with field data collection
solutions
Experienced in providing GIS
Mapping and emergency GIS Services
Long-term experience with legal
descriptions and CAD Map Drafting,
supplemented with Land Surveying
Techniques
Experiences with Revenue and
Taxation Code
IT-Backend support knowledge in
Microsoft SQL and Python.

Education
B.S.

Geography
Oregon State University
Corvallis, Oregon
Professional Certification in
Geographic Information Systems
Ryan Goodner-Belli
Project Manager and Senior GIS Analyst
Ryan Goodner-Belli is a Senior GIS Analyst / Project Manager for VESTRA. Ryan has over 21 years of technical Geographic Information Systems knowledge and experience; 11 years applying his GIS experience in a professional capacity. His work attributes incorporate Environmental Analysis, Municipal Planning, Public Safety, Local Government Infrastructure, Parcel Fabric Management, and ESRI System Administration.

Mr. Goodner-Belli has a Bachelor of Science Degree in Geography from Oregon State University and a Professional Certification in Geographic Information Systems. His professional work history includes experience in the utility and emergency response sectors, with a primary focus in local government. While working for two Counties in California, Ryan gained expertise in parcel fabric implementation and management, in addition to developing innovative solutions utilizing industry standard foundations. Over the course of his career, Mr.

Goodner-Belli has developed a strong working relationship with the California Assessor Community.

Representative Project Experience
Enterprise GIS Location Strategy, City of Mountain View, CA Mr. Goodner-Belli is the Senior GIS Analyst for the City of Mountain View’s Location Strategy project. This project involves creating a Survey 123 application for city-wide evaluation of GIS Services and needs. The resulting report and interpretations will be used to create a three-year plan for the strategic forward progress of GIS in the city.

Geographic Information Systems (GIS) System Management, County of Alpine, CA
Mr. Goodner-Belli is the Interim County GIS Coordinator, managing the Alpine County ArcGIS Online platform. Mr. Goodner-Belli is conducting the total data upgrade and functional implementation of GIS. Recent GIS work within this City includes parcel/condo updates, NextGen 911 address upgrades, recent wildfire mapping and applications, and the redistricting process.

Staff Training and Data Maintenance, City of Gonzales, CA Mr. Goodner-Belli has maintained responsive training for two intern staff members with the City of Gonzales Public Works Department. Mr.

Goodner-Belli has also consolidated data needs and simplified field collection solutions for the Department. Recommendations for geodetic control and appropriate hardware for GIS services have been provided.

DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 240 of 1251Attachment 2 Page 26 of 42

Ryan Goodner-Belli

Page 2 of 2 ends

Parcel Fabric Hyper Maintenance, City of Victorville, CA Mr. Goodner-Belli has worked on unpredictable updates from the County of San Bernardino ISD Parcel Base on short turnaround times to maintain a current Community Planning Parcel Fabric for the City of Victorville.

The recent update eclipsed 950 individual parcel additions to the database in less than two days.

Placer County Assessor’s Office, Auburn, CA, March 2018 – May 2021 Mr. Goodner-Belli was a GIS Analyst for the Placer County Assessor’s Office and performed analysis and interpretation of recorded documents to maintain R&T standards for the Placer County Assessor’s Office use.

Subdivisions, parcel maps, deeds, and records were continually reviewed to amend the accuracy of the Assessor’s Parcel Maps. Professional assistance to coworkers and service to constituents was provided daily.

Experience Highlights:
•Worked duty to coordinate an independent Geographic Information System, using an ESRI ArcGIS Online Portal, with an advanced data foundation and Megabyte Integration. •Spearheaded the Centralized County GIS Program within the Information Technology Department.

Mono County Department of Information Technology, Bridgeport, CA, November 2012 – February 2018 Mr. Goodner-Belli served as a Cadastral Analyst for the Mono County department of Information Technology.

In this position, analysis and conversion of recorded documents was performed to maintain a cadastral base map for the Mono County GIS and to develop and manage a Parcel Fabric.

Experience Highlights:
•Participated in ESRI beta testing of the Local Government Information Parcel Fabric Model. •Collaborated to design the Mono County Sheriff Department’s Active Shooter Scenario Maps Southern California Edison, Department of Real Property, Rosemead, CA, March 2010 – October 2012 Mr. Goodner-Belli served as a Technical Specialist II (GIS) for Southern California Edison’s Department of Real Property. In this position, Mr. Goodner-Belli compiled GIS analysis for transmission right-of-way and fee- owned parcels while supporting the Environmental, Security, Transmission, and Nuclear Divisions with various data and mapping requests.

Experience Highlights:
•Initiated and coordinated a project to demonstrate the need to collect Field GPS data for Solar Generation Interconnect Projects.

Orange County Fire Authority, Irvine, CA, October 2008 – February 2010 Mr. Gooder-Belli was GIS intern for the Orange County Fire Authority and contributed effort toward developing a First Due District Map set, Apparatus Fire Run Maps, and the Ready Set Go! Initiative.

Experience Highlights:
•Completed mass editing effort of address annotation for Fire Run Maps and contributed to After Action Reports.

Professional Memberships
California URISA - Member since 2019
California Cadastral Mapping Association – Member since 2013; Current Education Committee Chair International Association of Assessing Officers – Member since 2019 Technical Capabilities
ArcGIS for Desktop 10.x
ArcGIS Pro 2.x
ArcGIS Portal 10.x
ArcGIS for Server 10.x
ArcGIS Online
Parcel Fabric Management
ArcGIS Field Maps
Survey 123 for ArcGIS
3D Modeling
MS SQL Server 2008 R2 & forward
Database ETL with Python
Visual Studio 2010 (C#.NET
DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 241 of 1251Attachment 2 Page 27 of 42

1 Matthew Fremont
GIS Analyst/Systems Architect
phone: 916.817.0429 / email: [email protected]
Summary of Qualifications
Matthew Fremont is a Geographic Information Systems (GIS) Analyst, cartographer and systems administrator with over 18 years of experience providing geospatial solutions. His expertise includes cartography, spatial analysis, geodatabase design and management, spatial data integration, ArcGIS Online (AGOL), ArcGIS Server, ArcSDE, administration and maintenance of SQL Server databases, systems development and integration and Global Positioning Systems (GPS) implementation/operation.

Mr. Fremont utilizes the latest suite of ESRI products (ArcGIS 10.x, ArcGIS Pro) as well as AutoCAD, QGIS and other open source products. In addition, he utilizes the full suite of Adobe products (Adobe Illustrator, Photoshop, Acrobat Pro). He has managed numerous multi- disciplinary projects throughout Northern California ranging from land development and natural resources management to agency administration and asset management. His project background includes systems integration, spatial analysis, developing web applications, flood contingency mapping, habitat mapping and wetland delineations, public safety plans, modeling, GPS data collection and data post-processing, database management, impact analysis, as well as general cartography and map production.

Mr. Fremont’s technical expertise augments his project management skills that include budget administration and staff supervision. Mr. Fremont regularly coordinates with public and private stakeholders including planners, engineers, surveyors, archaeologists, biologists and field technicians to ensure that maps, exhibits and relevant supporting data accurately reflect the needs of the individual project with respect to content, standards, quality, geographic reference, integration, organization, and appropriate documentation (including metadata).

Mr. Fremont is also a professor of Geography and GIS at Sierra College in Rocklin, CA and teaches several GIS/GPS courses annually. He is a member of the Association of Environmental Professionals (AEP).

Selected Experience
City of Elk Grove On-call GIS Analyst/Systems Architect (2016-Present). Leads a team of GIS consultants to develop all GIS services and systems for the City of Elk Grove. Tasks include managing the City’s internal GIS platform (Portal) as well as the public online interface (ArcGIS Online). Ongoing responsibilities consist of systems design, map production and application building, data management, customer service and managing all City-wide GIS related functions.

City of Roseville GIS/Asset Management Effort, City of Roseville, CA (2011 - 2014). Led an effort to collect and digitize all City-wide park assets ranging from streetlights to playground equipment. The collected data was then integrated into the City’s GIS The collected data was then integrated into the City’s GIS and the asset management system. To date, the effort has covered more than 50 parks covering 800 acres with a combined total of 1,200 data points entered into the City’s asset management system. This task also included training City staff in the use of GPS and GIS software and hardware for collection, analysis, data organization, and storage.

Flood Contingency/Emergency Response Mapping, Northern CA (2013 - 2017). Developed Flood Contingency and Emergency Response maps and geodatabases, in conjunction with KSN Inc., for a variety of agencies throughout Northern California. Flood Contingency Maps are an integral part of flood safety plans and become a hazard-specific annex to written emergency operations plans. The maps display public safety agency evacuation/rescue elements of the flood safety plan covering remaining requirements of Water Code Section 9650 and maintained in the emergency operations plans of applicable jurisdictions.

DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 242 of 1251Attachment 2 Page 28 of 42

Matthew Fremont
2 Nevada Irrigation District GIS Initiative, Nevada County, CA (2014 –2017). Managed and implemented an on-going, intricate data collection effort for use in a Public Safety Plan for the Nevada Irrigation District.

Ongoing responsibilities include creating and managing an Enterprise geodatabase and developing all maps for the updated Plan. The database is currently in the process of being integrated into NID’s overall system.

Sacramento Municipal Utility District (SMUD) Habitat Conservation Plan (HCP) (2015 - 2017).

Managed all data required for the ongoing SMUD HCP. Task includes developing the geodatabase and all related database functions for analyzing critical habitat for the SMUD HCP, which is being prepared for SMUD jurisdiction throughout portions of Sacramento County. The project involves modeling of plant and wildlife covered species as well as existing land cover, data conversion, geodatabase creation and management, spatial analysis, map production as well as integration into the existing SMUD asset system.

Renewable Energy General Plan Amendment (REGPA), Program Environmental Impact Report (PEIR) and Public Outreach, Inyo County, CA (2014 – 2015). Developed a comprehensive geospatial collection and analysis effort aimed at mapping land cover and habitat types within a defined 140,000 acres in the Owens Valley. The landscape was analyzed based on unique aerial signatures in the landscape, specifically near aquatic resources. The REGPA and PEIR were met with intense interest and generated public comments from more than 500 individuals and organizations. The final REGPA and PEIR was adopted by the County in March 2015. Data management is ongoing.

Tahoe Inter/Intra Regional Transit Study, Placer County, CA (2009 - 2010). Conducted GIS analysis for the Tahoe Inter/Intra Regional Transit Study for the Tahoe Regional Planning Agency. The study defined feasible public transportation and transit projects for short range (five-year) implementation. The Agency intends to ultimately establish passenger rail service to the greater Tahoe/Truckee region from the Bay Area.

Placer County Conservation Plan, Placer County, CA (2011 - 2013). Managed the overall GIS effort in order to digitize habitat and land use coverage for use in the Placer County Conservation Plan (PCCP), which includes a Habitat Conservation Plan and Natural Community Conservation Plan (HCP/NCCP), and an Aquatic Resource Program (CARP). GIS services include database creation, heads-up digitizing, modeling, and quality control of data within the entire project area. The project area spans western Placer County in the Sacramento Valley and Sierra Nevada foothills and encompasses 212,090 acres.

Martis Valley Regional Trail (2010-2011). Conducted wetland delineation, digitized biological habitat, and conducted impact analyses for a proposed regional trail system. This task involved GPS data collection, GIS analysis, and cartography. The study corridor covered several miles between the eastern limits of the Town of Truckee and the Four Corners area near Brockway Summit in Placer County, California.

Education
Bachelor of Arts, Economics, Bucknell University, 1999
Master of Arts, Natural Resources Management, University of Colorado, Denver, 2005 Professional Affiliations
Association of Environmental Professionals (AEP)
Professor of Geography, Sierra College
Northern California GIS Advisory Board
DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 243 of 1251Attachment 2 Page 29 of 42

Experience Highlights
Exceptional knowledge of GIS
database design and maintenance
Experienced with ArcGIS Desktop and
ArcGIS Online including apps and
solutions
Excellent knowledge of leadership,
management, and supervision
procedures, practices, and skills
Over 35 years of experience in the
design and development of training
materials and presentations
Education
Coursework in support of
GIS Certificate, Shasta College
Redding, CA
Coursework in support of
Master in Public Administration
California State University
Chico, CA
M.A. Criminal Justice
California State University
Sacramento, CA
B.A. Police Science and
Administration
Sacramento State College
Sacramento, CA
Clarence Finmand
Sr. GIS Technician
Clarence (Clancy) Finmand is a Sr. GIS Technician at VESTRA, with 17 years of experience in GIS practices, procedures, operations and needs. Mr. Finmand has excellent knowledge of database design, creation and maintenance. Mr. Finmand is experienced in ESRI’s latest version of desktop software. Mr. Finmand has successfully developed, implemented and monitored projects and programs, including design, budget development, implementation, monitoring and training. Mr.

Finmand has an excellent knowledge of leadership, management, and supervision procedures, practices, and skills. In addition, Mr. Finmand has an established history of applying that knowledge in organizational settings to help achieve a team-oriented approach while allowing individual growth and development. Mr. Finmand has a relentless desire and ability to isolate challenges and identify solutions. Mr.

Finmand has the skill, ability and experience in the research, collection, analysis and presentation of information in various formats including written, oral, and visual. Mr. Finmand has sound knowledge of computer systems, programming concepts and systems analysis. Mr.

Finmand has 35 years’ experience in the design, development, and presentation of training and instructional material; Public Safety Policy and Procedures, Public Safety Training, GIS Introduction to ArcGIS, and Using ArcLogistics. Mr. Finmand is also familiar with ArcGIS Online and configuring apps such as Survey123 and ArcGIS Solutions that are provided out of the box in Esri’s platform.

Representative Project Experience
Yolo County Covid-19 Dashboards, Yolo, County, CA
Mr. Finmand serves as a GIS Analyst for the County of Yolo’s GIS Emergency Operations Support Services project. The County of Yolo contracted with VESTRA to take over GIS initiatives surrounding the Covid-19 Pandemic. The project has consisted of taking over daily data entry for new cases that serve the County’s GIS-based dashboards. As a part of the project, VESTRA analysts worked with County staff to optimize data input by creating a semi-automated workflow to pull data into GIS and process according to the metrics that needed to be visualized on the dashboards.

On a daily basis, Mr. Finmand receives an Excel file with data for each case Yolo has opened. The Excel sheet is processed using nine Python scripts in an ArcGIS Pro project. The project uses three map documents and several tables. After each script is ran Mr. Finmand QA/QCs the data for quality and accuracy.

The processing results in updated data for total COVID-19 cases and new COVID-19 cases for the current date; total deaths and new COVID- 19 deaths for the current date; current persons hospitalized and total DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 244 of 1251Attachment 2 Page 30 of 42

Clancy Finmand

Page 2 of 3 ends

persons hospitalized to date; testing positivity rate; updated information on cases by age, sex, race, and ethnicity. The updated data is published in an ArcGIS Online environment to a public facing dashboard and another internal dashboard for use within the County’s organization.

In addition, a separate dashboard is updated with case information for each of the County’s Long Term Care Facilities. The information only indicates data regarding total cases among staff and clients, total hospitalizations, and total deaths.

Thorough documentation of processes is maintained and updated for the project and knowledge transfer provided to County Staff as needed.

GIS Program Services, City of Elk Grove, CA
Mr. Finmand serves as a GIS Specialist for the City of Elk Grove’s GIS Program services project. In 2016, the City of Elk Grove contracted with VESTRA to provide GIS program services to the City including GIS Data, Mapping, Analysis Support and Services; GIS Coordination Services; GIS System and Application Maintenance and Support; and GIS Training Services. VESTRA supports the City's Public Works Department by performing CAD conversions of public infrastructure and engineering project drawings to GIS, assisting with GIS and asset management system integrations, setting up GIS viewers for managing assets in the field and tracking progress at the office. VESTRA also provides support with workflows related to asset data collection and maintenance. VESTRA has been very successful in providing prompt on-call support services such that the City is able to continue to meet or exceed its performance goals for overall IT/GIS support.

Mr. Finmand’s primary role on the project has been providing basemap re-alignment support.

GIS Database and System Support, Modoc County, CA
Mr. Finmand served as the GIS Data Analyst and Conversion Specialist for VESTRA’s GIS Database and System Support Project with Modoc County. Mr. Finmand performed advanced spatial analysis and 3D modeling for the County. Mr. Finmand processed and developed large datasets within a newly designed geodatabase structure. Mr. Finmand used Esri’s Model Builder to build geoprocessing models for processing vector and raster data.

CAD to GIS Conversion of Water Systems, City of Glendora, CA Mr. Finmand served as a GIS Technician for the City of Glendora CAD to GIS Conversion Project. The City contracted with VESTRA to convert their Master CAD drawing with the City’s water network into GIS.

VESTRA worked with the City to convert their CAD data to GIS and loaded the GIS data into the corresponding Local Government Information Model feature classes. Mr. Finmand’s primary responsibilities were working on the attribution of the city’s water lines.

CAL FIRE Statewide CAD/AVL Roads Database, Northrop Grumman and CAL FIRE Mr. Finmand serves as a GIS Analyst for the CAL FIRE Statewide CAD / AVL Roads Database project for Northrop Grumman. The project includes working with CAL FIRE and converting county roads feature classes to conform to the Altaris CAD’s requirements. For this project, an extensive library of over 100 Python scripts to programmatically address the common data errors in dispatch systems and the formatting needs necessary for incorporation into CAL FIRE’s CAD / AVL Roads Database, was developed. Mr. Finmand has used the highly advanced scripted workflow to convert CAL FIRE data from Napa, Sonoma, Lake, Siskiyou, Humboldt, Mendocino, Tuolumne, Calaveras, Solano, Colusa, Yolo, Contra Costa, Alameda, Stanislaus, San Joaquin, and Santa Clara Counties.

DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 245 of 1251Attachment 2 Page 31 of 42

Clancy Finmand

Page 3 of 3 ends

College GIS Data Inclusion - Project Assistant
Shasta Tehama Joint Community College, Redding, CA, 2011-2012 Mr. Finmand assessed, updated and modified existing college GIS data, and created data as required. Mr.

Finmand planned, designed and implemented a process to allow Shasta College to merge campus site GIS data for inclusion in county wide Esri Community Map Program. Mr. Finmand planned, designed and implemented a Facilities Management solution based on the needs of the Plant Facility Division. Mr.

Finmand also designed ‘Shasta College Maps and Apps’ web/mobile environment.

Computerized GIS Solution for School District, Washoe County School District, Reno, NV, 2005 - 2011 Mr. Finmand, as project lead, planned, developed and implemented a computerized GIS solution for the District's student transportation process. In addition to the work at WCSD, Mr. Finmand created maintained and edited data in a GIS and SQL database. Mr. Finmand worked with School District Emergency Manager with Facility Design (CAD Floor Plans to georeferenced GIS Feature Class). Mr. Finmand trained Mail Center Staff with Esri ArcLogistics solution for District-wide mail delivery. Mr. Finmand developed GIS solution for District Student Health Director for a visual representation of absentee rates. Mr. Finmand developed a similar solution for immunization compliance rate for each of the 100 district sites in the district. Mr.

Finmand planned the design phase of a Facilities Management Database for all of District structures. Mr.

Finmand implemented a test of ArcGIS Server with .Net Framework for Emergency Management Common Operational Picture using the Flex Sample Viewer with the goal to move to GIS solution for Emergency Management. Mr. Finmand was in the planning phase of a production version of COP viewer. Mr. Finmand installed GIS software – Client and Server with updates and patches and resolve user questions. Mr.

Finmand installed beta versions of ArcGIS family of software (desktop to Server) and tested new functionality and current workflows.

Public Safety Practitioner, Anderson Police Department, Anderson, CA 1970 – 2001 Mr. Finmand was agency lead for multi-agency Public Safety technology projects; Consolidate 911 Dispatch Center, Consolidated Records Management System, Consolidated mobile-data-computer in police vehicles.

Technical Capabilities
ArcGIS Online
ArcGIS Desktop 10.x
ArcGIS Pro 2.x
ArcGIS Server 10.x
Web AppBuilder for ArcGIS
Survey123
Certificates/Training
ESRI Using Network Analyst
ESRI ArcGIS Server Seminar
ESRI Developing Web Apps using Java Scrip Seminar
ESRI ArcGIS Server Setup using .Net Framework
ESRI Using CAD in GIS
ESRI Building Web Applications Using the ArcGIS API for Flex ESRI ArcGIS Server: Web Administration Using the Microsoft .NET Framework ESRI Building Web Applications Using the ArcGIS API for Silverlight/WPF ESRI ArcGIS Server Enterprise configuration and Tuning for SQL Server DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 246 of 1251Attachment 2 Page 32 of 42

EXHIBIT “B”

PAYMENT
1)The total contract price for services rendered by CONSULTANT under this Agreement shall be as specified below. CONSULTANT agrees to provide the listed Personnel at the Fully Loaded Hourly Rate as necessary to complete the Scope of Services and agrees to provide specific Personnel as requested in writing by the CITY to fulfill any portion of the Scope of Services.

Personnel Fully Loaded Hourly Rate
Arthur Stackhouse –Senior Project Manager $185.00
–Solution Architect $160.00
Ryan Goodner-Belli –Project Manager $161.00
–Senior GIS Specialist $147.00
–Senior GIS Analyst $114.00
–GIS Analyst $94.00
Clancy Finmand –Senior GIS Technician $79.00
Kaitlyn Taylor –Administrative Assistant $67.00
Connie Ebinger –Administrative Assistant $67.00
2)The project will be funded through the account codes: 011-65-005-8911, 255-99-304-8911, 461-99-8911, and 011-46-001-8911. The budget for the tasks of organizational data assessment, document import and centralization, and layer development is in the amount of ONE HUNDRED FIFTY THOUSAND ($150,000). The budget for the tasks of organizational skills assessment, and organizational skills training is in the amount of FIFTY THOUSAND ($50,000). CONSULTANT shall notify the CITY in writing once the total invoices under this agreement exceed ONE HUNDRED SIXTY THOUSAND DOLLARS ($160,000), or eighty (80%) percent of the existing not to exceed amount of TWO HUNDRED THOUSAND DOLLARS ($200,000).
3)Payment shall be made to CONSULTANT on a time and materials based on the CONSULTANT’S rates, attached with Exhibit “B” through the term of this agreement. CONSULTANT shall submit monthly invoices to the CITY OF FAIRFIELD for the same. The total authorized amount for this Agreement is TWO HUNDRED THOUSAND DOLLARS ($200,000) which will not be exceeded without Council authorization. 4)Any additional meetings or work required beyond that set forth in Exhibit “A” shall be mutually agreed to in writing by the CITY and CONSULTANT, and shall be billed on a time and materials basis to the CITY OF FAIRFIELD.

DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 247 of 1251Attachment 2 Page 33 of 42

5)CONSULTANT shall submit, and CITY shall pay, monthly invoices for work performed during the previous month. For the time and material services billing shall be based on the hourly and fee rate charges set forth in this Exhibit "B".

DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 248 of 1251Attachment 2 Page 34 of 42

EXHIBIT “C”

GENERAL PROVISIONS
1)INDEPENDENT CONSULTANT. At all times during the term of this Agreement, CONSULTANT shall be an independent contractor and shall not be an employee of CITY. CITY shall have the right to control CONSULTANT only insofar as the results of CONSULTANT's services rendered pursuant to this Agreement; however, CITY shall not have the right to control the means by which CONSULTANT accomplishes services rendered pursuant to this Agreement. 2)LICENSES; PERMITS; ETC. CONSULTANT represents and warrants to CITY that CONSULTANT has all licenses, permits, qualifications, and approvals of whatsoever nature which are legally required for CONSULTANT to practice CONSULTANT's profession. CONSULTANT represents and warrants to CITY that CONSULTANT shall, at its sole cost and expense, keep in effect at all times during the term of this Agreement, any licenses, permits, and approvals which are legally required for CONSULTANT to practice his profession.
3)TIME. CONSULTANT shall devote such services pursuant to this Agreement as may be reasonably necessary for satisfactory performance of CONSULTANT's obligations pursuant to this Agreement. CONSULTANT shall adhere to the Schedule of Activities as described in their Executive Summary.
4)CONSULTANT NOT AN AGENT. Except as CITY may specify in writing, CONSULTANT shall have no authority, express or implied, to act on behalf of CITY in any capacity whatsoever as an agent.

CONSULTANT shall have no authority, express or implied, pursuant to this Agreement, to bind CITY to any obligation whatsoever.
5)ASSIGNMENT PROHIBITED. No party to this Agreement may assign any right or obligation pursuant to this Agreement. Any attempted or purported assignment of any right or obligation pursuant to this Agreement shall be void and of no effect.
6)PERSONNEL. CONSULTANT shall assign only competent personnel to perform services pursuant to this Agreement. In the event that CITY, in its sole discretion, at any time during the term of this Agreement, desires the removal of any person or persons assigned by CONSULTANT to perform services pursuant to this Agreement, CONSULTANT shall remove any such person immediately upon receiving notice from CITY of the desire of CITY for the removal of such person or persons. 7)STANDARD OF PERFORMANCE. CONSULTANT shall perform all services required pursuant to this Agreement. Services shall be performed in the manner and according to the standards observed by a competent practitioner of the profession in which CONSULTANT is engaged in the geographical area in which CONSULTANT practices his profession. All products which CONSULTANT delivers to CITY pursuant to this Agreement shall be prepared in a workmanlike manner, and conform to the standards of quality normally observed by a person practicing in CONSULTANT's profession. CITY shall be the sole judge as to whether the product of the CONSULTANT is satisfactory.
8)CANCELLATION OF AGREEMENT. This Agreement may be canceled at any time by the CITY at its discretion upon written notification to CONSULTANT. CONSULTANT is entitled to receive full payment for all services performed and all costs incurred up to and including the date of receipt of written notice to cease work on the project. CONSULTANT shall be entitled to no further compensation for work DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 249 of 1251Attachment 2 Page 35 of 42

performed after the date of receipt of written notice to cease work. All completed and incomplete products up to the date of receipt of written notice to cease work shall become the property of CITY. 9)PRODUCTS OF CONSULTING. All products of the CONSULTANT provided under this Agreement shall be the property of the CITY.
10)INDEMNIFY AND HOLD HARMLESS.
a)If AGREEMENT is an agreement for design professional services subject to California Civil Code § 2782.8(a) and CONSULTANT is a design professional, as defined in California Civil Code §2782.8(c)(2), to the fullest extent permitted by law, CONSULTANT shall indemnify, defend and hold harmless CITY and its elected officials, officers, agents, employees and designated volunteers (collectively “CITY Indemnitees”) from and against any and all claims, losses, liabilities, damages, costs and expenses, including attorney’s fees and costs, to the extent they arise out of, pertain to, or relate to the negligence, recklessness, or willful misconduct of the CONSULTANT. CONSULTANT’s duty to defend shall consist of reimbursement of defense costs incurred by CITY in direct proportion to the CONSULTANT’s proportionate percentage of fault. CONSULTANT’s percentage of fault shall be determined, as applicable, by a court of law, jury or arbitrator. In the event any loss, liability or damage is incurred by way of settlement or resolution without a court, jury or arbitrator having made a determination of the CONSULTANT’s percentage of fault, the parties agree to mediation with a third party neutral to determine the CONSULTANT’s proportionate percentage of fault for purposes of determining the amount of indemnity and defense cost reimbursement owed to the CITY.
b)If AGREEMENT is not an agreement for design professional services subject to California Civil Code § 2782.8(a) or CONSULTANT is not a design professional as defined in California Civil Code §2782.8(c)(2), to the fullest extent allowed by law, CONSULTANT shall indemnify, defend, and hold harmless the CITY Indemnitees from all claims, suits, or actions of every name, kind and description, brought forth on account of injuries to or death of any person or damage to property arising from or connected with the willful misconduct, negligent acts, errors or omissions, ultra-hazardous activities, activities giving rise to strict liability, or defects in design by CONSULTANT or any person directly or indirectly employed by or acting as agent for CONSULTANT in the performance of this Agreement, including the concurrent or successive passive negligence of the CITY Indemnitees.

It is understood that the duty of CONSULTANT to indemnify and hold harmless includes the duty to defend as set forth in Section 2778 of the California Civil Code.

Acceptance of insurance certificates and endorsements required under this Agreement does not relieve CONSULTANT from liability under this indemnification and hold harmless clause. This indemnification and hold harmless clause shall apply whether or not such insurance policies are determined to be applicable to any such damages or claims for damages.

CONSULTANT’S responsibility for such defense and indemnity shall survive termination or completion of this agreement for the full period of time allowed by law. 11)PROHIBITED INTERESTS. No employee of the CITY shall have any direct financial interest in this agreement. This agreement shall be voidable at the option of the CITY if this provision is violated. 12)LOCAL EMPLOYMENT POLICY. The CITY desires wherever possible, to hire qualified local residents to work on city projects. Local resident is defined as a person who resides in Solano County.

DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 250 of 1251Attachment 2 Page 36 of 42

The CITY encourages an active affirmative action program on the part of its contractors, consultants, and developers. When local projects require, subcontractors, contractors, consultants and developers will solicit proposals from qualified local firms where possible.

As a way of responding to the provisions of the Davis-Bacon Act and this program, contractor, consultants, and developers will be asked, to provide no more frequently than monthly, a report which lists the employee's name, job class, hours worked, salary paid, city of residence, and ethnic origin. 13)CONSULTANT NOT A PUBLIC OFFICIAL. CONSULTANT is not a "public official" for purposes of Government Code §§ 87200 et seq. CONSULTANT conducts research and arrives at his or her conclusions, advice, recommendation, or counsel independent of the control and direction of the CITY or any CITY official, other than normal contract monitoring. In addition, CONSULTANT possesses no authority with respect to any CITY decision beyond these conclusions, advice, recommendation, or counsel. 14)EMPLOYMENT DEVELOPMENT DEPARTMENT REPORTING REQUIREMENTS. When the CITY executes an agreement for or makes payment to CONSULTANT in the amount of $600 (six hundred dollars) or more in any one calendar year, CONSULTANT shall provide the following information to CITY to comply with Employment Development Department (EDD) reporting requirements:
a)Whether CONSULTANT is doing business as a sole proprietorship, partnership, limited liability partnership, corporation, limited liability corporation, non-profit corporation or other form of organization.
b)If CONSULTANT is doing business as a sole proprietorship, CONSULTANT shall provide the full name, address and social security number of the sole proprietor. c)If CONSULTANT is doing business as other than a sole proprietorship, CONSULTANT shall provide CONSULTANT’S federal tax identification number.

DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 251 of 1251Attachment 2 Page 37 of 42

EXHIBIT “D”

INSURANCE REQUIREMENTS
CONSULTANT shall procure and maintain for the duration of the contract insurance against claims for injuries to persons or damages to property which may arise from or in connection with the performance of the work hereunder by the CONSULTANT, its agents, representatives, or employees. 1)MINIMUM SCOPE AND LIMITS OF INSURANCE
a)Commercial General Liability coverage (occurrence Form CG 00 01) with minimum limits of $1,000,000 per occurrence for bodily injury, personal injury, products and completed operations, and property damage. If Commercial General Liability or other form with a general aggregate limit is used, either the general aggregate limit shall apply separately to this project/location or the general aggregate limit shall be twice the required occurrence limit.
b)Automobile Liability coverage (Form CA 00 01 with Code 1 – any auto) with minimum limits of $1,000,000 per accident for bodily injury and property damage. c)Workers’ Compensation insurance as required by the State of California and Employers’ Liability insurance, each in the amount of $1,000,000 per accident for bodily injury or disease. 2)INDUSTRY SPECIFIC COVERAGES
If checked below, the following insurance is also required.

Professional Liability Insurance / Errors and Omissions Liability in the minimum amount of $1,000,000 per occurrence.

Cyber Liability Insurance in the minimum amount of $1,000,000 per occurrence Pollution Liability Insurance in the minimum amount of $1,000,000 per occurrence Garage Keepers Insurance in the minimum amount of $1,000,000 per occurrence Fidelity / Crime / Dishonesty Bond in the minimum amount of $____________ MCS-90 Endorsement to Business Automobile insurance for transportation of hazardous materials and pollutants
Builder’s Risk / Course of Construction Insurance in the minimum amount of $__________. 3)INSURANCE PROVISIONS
a)DEDUCTIBLES AND SELF-INSURED RETENTIONS. Any deductibles or self-insured retentions must be declared to and approved by the CITY. At the option of the CITY, either the insurer shall reduce or eliminate such deductibles or self-insured retentions as respects the CITY, its officers, officials, employees and volunteers; or the CONSULTANT shall procure a bond guaranteeing payment of losses and related investigations, claim administration and defense expenses.

DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 252 of 1251Attachment 2 Page 38 of 42

b)The general and automobile liability policies (and if applicable, pollution liability, garage keepers liability and builder’s risk policies) are to contain, or be endorsed to contain, the following provisions:
i)The CITY, its officers, officials, employees and volunteers are to be covered as insureds as respects: liability arising out of work or operations performed by or on behalf of the CONSULTANT; products and completed operations of the CONSULTANT; premises owned, occupied or used by the CONSULTANT; and automobiles owned, leased, hired or borrowed by the CONSULTANT. The coverage shall contain no special limitations on the scope of protection afforded to the CITY, its officers, officials, employees or volunteers. ii)For any claims related to this project, the CONSULTANT’S insurance coverage shall be primary insurance as respects the CITY, its officers, officials, employees and volunteers. Any insurance or self-insured maintained by the CITY, its officers, officials, employees or volunteers shall be excess of the CONSULTANT’S insurance and shall not contribute with it. iii)Any failure to comply with reporting or other provisions of the policies including breaches of warranties shall not affect coverage provided to the CITY, its officers, officials, employees or volunteers.
iv)The CONSULTANT’S insurance shall apply separately to each insured against whom claim is made or suit is brought, except with respect to the limits of the insurer’s liability. v)Each insurance policy required by this clause shall be endorsed to state that coverage shall not be suspended, voided, canceled by either party, reduced in coverage or in limits except after thirty (30) days’ prior written notice by certified mail, return receipt requested, has been given to the CITY.
vi)The policy limits of coverage shall be made available to the full limits of the policy. The minimum limits stated above shall not serve to reduce the CONSULTANT’S policy limits of coverage.

Therefore, the requirements for coverage and limits shall be (1) the minimum coverage and limits specified in this agreement, or (2) the broader coverage and maximum limits of coverage of any insurance policy or proceeds available to the named insured, whichever is greater. c)ACCEPTABILITY OF INSURER. Insurance is to be placed with insurers with a current A.M. Best’s rating of no less than A:VII, unless otherwise acceptable to the CITY.

VERIFICATION OF COVERAGE. CONSULTANT shall furnish the CITY with original endorsements effecting coverage required by this Exhibit D. The endorsements are to be signed by a person authorized by that insurer to bind coverage on its behalf; on forms equivalent to CG 20 10 11 85, subject to CITY approval; and submitted electronically through the Exigis insurance system to: [email protected].

All insurance certificates and endorsements are to be received and approved by the CITY before work commences. At the request of the CITY, CONSULTANT shall provide complete, certified copies of all required insurance policies, including endorsements effecting the coverage required by these specifications. d)SUB-CONTRACTORS. CONSULTANT shall require all subcontractors to procure and maintain insurance policies subject to the requirements of Exhibit D. Failure of CONSULTANT to verify existence of sub- contractor’s insurance shall not relieve CONSULTANT from any claim arising from sub-contractors work on behalf of CONSULTANT.

DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 253 of 1251Attachment 2 Page 39 of 42

EXHIBIT “E”

NON-DISCLOSURE AGREEMENT
Regarding the City of Fairfield’s Sensitive Proprietary Infrastructure Information This Non-Disclosure Agreement (“Agreement”), is entered into this 18th day of July 2022 (“Effective Date”), by and between the City of Fairfield, (“City”), a municipal corporation of the State of California, and the entity responding to City’s above-referenced Request for Proposals whose name, address, and state of incorporation, are as follows: VESTRA RESOURCES, INC., 5300 Aviation Dr., Redding, CA 96002, Incorporated in the State of California (hereinafter the “CONSULTANT”).

WHEREAS, the City, has asked for a datacenter move feasibility study from Communication Strategies. To enable the analysis, the City will disclose certain Confidential Information WHEREAS, in order to release this Confidential Information to those participating in the datacenter move feasibility study, the City requires each participant to enter into this Agreement through its authorized representative and return it to the City as a pre-condition of receiving supplemental documents or view on screen anything that may contain Confidential Information.

NOW THEREFORE, in consideration of the above recitals and the mutual promises of the parties herein contained, it is agreed by and between the parties as follows:

1. “Confidential Information” as used in this Agreement shall mean all technical and non- technical information, data, documents, records, and materials provided by or on behalf of the City to the CONSULTANT, including without limitation patent, trade secret, proprietary, and systems security-related information and information related to the current, future and proposed services of the City, in any form or medium, written or oral. Confidential Information also includes other information that is marked or otherwise identified as confidential or proprietary, or that would otherwise appear to a reasonable person to be confidential or proprietary in the context and circumstances in which the information is known or used. Confidential Information shall not include public records subject to disclosure under the California Public Records Act, Government code section 6250 et seq.

2. The CONSULTANT agrees that it will not make use of, disseminate, or in any way disclose the City’s Confidential Information to any person, firm or business, except as necessary for the CONSULTANT to create the datacenter move feasibility study, and any purpose the City has authorized or hereafter authorizes in writing. The CONSULTANT agrees that it shall disclose Confidential Information only to those directors, officers, employees, agents, affiliates, advisors, representatives, or consultants who need to know such information and who have previously agreed, either as a condition to employment or service or to obtain the Confidential Information, to be bound by terms and conditions substantially similar to those of this Agreement.

3. The CONSULTANT agrees to hold all Confidential Information of the City in the strictest confidence and treat it with the same degree of care as it accords to its own Confidential Information, and the CONSULTANT represents and warrants that it exercises reasonable care to protect its own Confidential Information.

DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 254 of 1251Attachment 2 Page 40 of 42

4.The CONSULTANT’s obligations under Sections 2 and 3 with respect to any portion of the City’s Confidential Information shall terminate if the CONSULTANT can document that: (a) such information was in the public domain at the time it was communicated to the CONSULTANT by the City; (b)such information entered the public domain subsequent to the time it was communicated to the CONSULTANT through no fault of the CONSULTANT; (c) it was in the CONSULTANT’s possession free of any obligation of confidence at the time it was communicated to the CONSULTANT by the City (as shown by the CONSULTANT’s files and records as of the time of disclosure); (d) it was rightfully communicated to the CONSULTANT by a third party free of any obligation of confidence subsequent to the time that it was communicated to the CONSULTANT by the City; (e) it was developed by employees or agents of the CONSULTANT independently of and without reference to any information communicated to the CONSULTANT by the City; or (f) the communication was in response to a valid order by a court or other governmental body, was otherwise required by law, or was necessary to establish the rights of either party under this Agreement (provided that the CONSULTANT has provided the City with a reasonable opportunity to seek protective legal treatment for such Confidential Information).

5.All materials (including, without limitation, documents, drawings, models, apparatus, sketches, designs and lists) furnished to the CONSULTANT by the City shall remain the property of the City and shall be returned promptly upon request, together with any copies thereof, or destroyed with the consent of the City.

6.The CONSULTANT shall not assign or transfer any rights or obligations under this Agreement without the prior written consent of the City.

7.CONSULTANT’s obligations under this Agreement shall survive the termination of any other contractual agreement between the parties.

8.This Agreement shall be governed in all respects by the laws of the United States of America and by the laws of the State of California. The sole jurisdiction and venue for any dispute arising under this Agreement shall be the state and federal courts located in Solano County, CA, and each party to this Agreement hereby submits to such jurisdiction and venue.

9.This Agreement may only be changed by mutual agreement of authorized representatives of the parties in writing.

10.The CONSULTANT acknowledges and agrees that irreparable injury may result to the City if the CONSULTANT breaches the provisions of this Agreement and that damages may be an inadequate remedy in respect of such breach. The CONSULTANT agrees in advance that, in the event of such breach, the City shall be entitled to the granting of injunctive relief in the City’s favor, in addition to such other remedies, damages and relief as may be available under applicable law.

11.This Agreement shall not be construed in any manner to be an obligation to enter into further contract or to reimburse the cost of any effort expended by CONSULTANT.

12.This agreement constitutes the entire agreement of the parties with respect to the subject matter hereof. In the event of a dispute or a claim by a party to enforce its rights under this Agreement, the non-prevailing party shall pay all of the prevailing party’s reasonable legal fees. This Agreement and all of the provisions hereof shall be binding upon and inure to the benefit of the parties hereto and their respective successors, transferees and assignees.

DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 Packet Page 255 of 1251Attachment 2 Page 41 of 42

IN WITNESS WHEREOF, the parties have executed this Agreement as of the date first written above.

CONSULTANT:

By: _________________________
Name: Kimberly Wilkes
Title: Operations Manager/CFO
Date: _________________________
CITY OF FAIRFIELD:

By: _________________________
Name: David Gassaway
Title: Interim City Manager
Date: _________________________
DocuSign Envelope ID: 7903B5FC-383E-4B44-BD8B-0ACBAB5A8437 7/19/2022
Packet Page 256 of 1251Attachment 2 Page 42 of 42

Packet Page 257 of 1251Attachment 3 Page 1 of 120

City of Fairfield| CA
Response to RFQ for GIS Services and Training

© GTG 2021
This document is and shall remain the property of GTG. The document may only be used for the purpose for which it was commissioned. Unauthorized use of this document in any form whatsoever is prohibited.

City of Fairfield| CA
Response to RFQ for GIS Services and Training

*Geographic Technologies Group agrees to the Non-Disclosure Agreement and does not have any exceptions to provisions of the Sample Consultant Services Agreement.

MAILING ADDRESS:

PO Box 10135
Goldsboro, NC 27532
PHONE: 919.222.1421
FAX: 919-429-4907

Packet Page 258 of 1251Attachment 3 Page 2 of 120

Cover Letter
Company Profile ............................................................................................... 1 Experience and References ............................................................................. 3 Project Team ..................................................................................................... 4 Methodology ..................................................................................................... 5 Appendix ........................................................................................................... 6

Additional Testimonials Upon Request
“ GTG offers the entire package of GIS and technical skills. - Asset/GIS Systems Administrator,
City of Bozeman, MT
“
“ “ GTG is the best company I have ever worked with. I am blown away by how good you guys are. So much better than other companies. – GIS Manager, Wake County, NC
“ You put our diverse set of users at ease with your calm demenor and depth of knowledge. Your approach was a perfect mix of education and fact- finding. Very engaging.
- City of Fremont, CA “
“ I’m relieved that we have a great group like GEOTG
to partner with moving forward.
- IT Manager, Central Lincoln PUD “
“ Your subject matter expertise, organization, clear
vision, sincerity, flexibility and most importantly,
clear and responsive communication at all times has
made this effort so successful.
- IT Project Manager, Wake County Government “
“ The very best GIS company period. I
have used them three times at three
different cities.
- Assistant City Manager, Granbury, TX

“
Packet Page 259 of 1251Attachment 3 Page 3 of 120

January 28, 2022

Attn: Jonathan Luong
Second Floor
1000 Webster St.

Fairfield, CA 94533
City of Fairfield - RFQ for GIS Services and Training
Dear Jonathan Luong:

My name is David Holdstock, CEO of Geographic Technologies Group (GTG). Our team would like to thank the City of Fairfield for allowing us to propose on this project. We understand that the City requires a qualified GIS design and consulting firm to support and provide GIS products and services that include assessing, evaluating, analyzing, training, and digitizing and integrating physical files and documents into a suite of GIS applications. This initiative would support and complement the City of Fairfield’s GIS Strategic Plan project. It would also include very specific technical training toward the operations and maintenance of the GIS platform. The following represent the proposed scope of services as specified by the Public Works (PA) department and the City:

Goal 1: Migrate electronic and physical files into the City’s ESRI platform and its suite of applications to update existing GIS layers.

Goal 2: Improve the precision and accuracy of assets and mapping of its utility infrastructure.

Goal 3: Technical training on the synchronization, operation, and maintenance of the City’s geodatabase, data sets, and shapefiles through the Esri suite of applications. (See the Methodology section for tasks and deliverables details).

We have assembled a highly qualified team with extensive experience in GIS strategic planning, Best Business Practices (BBP), procedures and protocols, GIS integration and interoperability, and expertise in strategically assessing, evaluating, analyzing, training, digitizing, and integrating data into an enterprise GIS database:
• David Holdstock GIS Strategic Planner and Advisor
• Jason Marshall: GIS Manager - Strategic Planner, Trainer, and Utility Data Conversion Specialist • Jessy Beasley: Project Manager (PM) - Strategic Planner, Trainer, and Utility Data Conversion Specialist
• Andrew Valenski: Esri IT, Databases Architect Expert and Trainer • Scott Mason: Software Solutions Expert, trainer, and Fiber Optics • Rives Deuterman: GIS Utilities Data Migration Manager and Trainer • Sam Stokes: Utilities GIS Utilities Data Migration Manager The entire GTG team would like to thank you for allowing us to propose on this project. We look forward to working closely with the City of Fairfield staff. Should you have any questions during the review of our proposal, please call me at 919-222-1421. I can be available for a TEAM’s meeting at short notice. As the proposed Project Advisor I look forward to the possibility of working with you to be “receptive to changes that can improve services”.

Respectfully Submitted,

Mr. David Holdstock, BA, MA, GISP
CEO, Geographic Technologies Group (GTG), Inc.
3717 National Drive, Ste 206, Raleigh, NC 27612 | P: 919.759.9214 | E: [email protected] Packet Page 260 of 1251Attachment 3 Page 4 of 120

Company Profile | 1
City of Fairfield| CA
Response to RFQ for GIS Services and Training

Company Profile

Packet Page 261 of 1251Attachment 3 Page 5 of 120

2 | Company Profile
City of Fairfield| CA
Response to RFQ for GIS Services and Training

Packet Page 262 of 1251Attachment 3 Page 6 of 120

Experience and References | 3
City of Fairfield| CA
Response to RFQ for GIS Services and Training

Experience and References
The following are 3 recent clients we have provided similar services for. More references are available upon request.

CITY OF TULARE, CA 2019-CURRENT
Contact Information
Jason Bowling | P: 559-684-4266 | E: [email protected] GTG performed a Needs Assessment for the City of Tulare, CA, in the process of creating a multi-year GIS Strategic Master Plan. The project involved three phases that included a GIS Technology Seminar, departmental interviews, the Needs Assessment, Conceptual Alternative Systems Design, a Value Proposition and ROI Analysis, and then the final delivery of the GIS Strategic Implementation Plan.

CITY OF HOBART, IN 2019-CURRENT
Contact Information
Tim Kingsland | HSD Coordinator
P: (219) 942-3619 | E: [email protected]
GTG performed a GIS Needs Assessment for the City of Hobart in addition to several GIS Consulting Services. The success of GIS for the City was dependent on the creation and adoption of effective metrics and clear, achievable goals. Additionally, GTG has planned, designed, and implemented a GIS hub for the City to internally use for housing all of their geospatial data such as documents, GIS applications, and GIS Maps.

CITY OF LAWRENCEVILLE, GA 2021-CURRENT
Contact Information
Kyle Parker | IT Director
P: (678) 407-6406 | E: [email protected]
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.

SERVICES PROVIDED
Data Conversion and Migration
Data layer Creation (Utilities)
Esri Platform and Ecosystem
Esri Training and Education in Local
Government
GIS and IT Architecture
Assessments
GIS GAP Analysis
GIS Strategic Planning in Local
Government

4 | Project Team
City of Fairfield| CA
Response to RFQ for GIS Services and Training

Project Team
The following team has been hand-selected for the services requested in this RFP. They are all permanent staff. Resumes, hourly rates, and a skillset matrix can be found in the Appendix.

Estimate of work to be performed locally: 80% off site | 20% on-site GTG does not plan to use subcontractors.

Packet Page 264 of 1251Attachment 3 Page 8 of 120

Methodology | 5
City of Fairfield| CA
Response to RFQ for GIS Services and Training

Methodology
Our methodology includes a team of experts that specialize in the work requested by the City of Fairfield, strategically thought out tasks and deliverables, and a thorough project management process (see additional details about Jason’s PMP certification in the Appendix.) Scope of Work
The following represents the proposed scope of services as specified by the Public Works (PA) department and the City. We understand the City of Fairfield is also working on a GIS Strategic Plan. We will ensure that this project will complement and support that plan.

Goal 1: Migrate electronic and physical files into the City’s ESRI platform and its suite of applications to update existing GIS layers.

Task 1: Assess the City’s current ability to file, locate and identify its map-related data, including as-built drawings, easements, and Right-of-Way).

Deliverable: Recommended Optimum Solution
Task 2: Work with staff to import and migrate physical and electronic files into a centralized folder for the purpose of collocating information sources for GIS.

Deliverable: Migration of Physical and Electronic Files Goal 2: Improve the precision and accuracy of assets and mapping of its utility infrastructure.

Task 3: Assist City staff in updating existing GIS layers to improve the precision and accuracy of assets, utility infrastructure, and mapping, and to build additional layers where requested for stormwater, sewer, fiber optics, easements, right of ways, and benchmarks.

Deliverable: Updated Existing Files
Deliverable: Additional Utility GIS Layers
Goal 3: Technical training on the synchronization, operation, and maintenance of the City’s geodatabase, data sets, and shapefiles through the Esri suite of applications.

Task 4: Assess the skill gap of staff and their competency with Esri and Its suite of applications.

Deliverable: Gap Analysis
Task 5: Train designated staff on a specific set of Esri solutions.

Deliverable: Training for specific staff on specific Esri Software Task 6: Identify and establish a designated staff member from the division or department with the necessary skills and competency to meet the GIS staff’s requests for the inflow and outflow of data.

Deliverable: GIS Governance Modifications Recommendations Task 7: Train identified specific staff to enable them to synchronize with the City’s GIS staff to fulfill requests for work orders.

Deliverable: Work Order Synchronization
Deliverable: Training for specific staff on work order synchronization Packet Page 265 of 1251Attachment 3 Page 9 of 120

6 | Appendix
City of Fairfield| CA
Response to RFQ for GIS Services and Training

Appendix
Geographic Technologies Group has provided the following items in this appendix:

GTG Hourly Rates Table
GTG Team Qualifications Matrix
Team Resumes
GTG Project Management Process
Recent Clients List (full list available upon request)
Example Work

Geographic Technologies
Group serves local
government nationwide,
with a large footprint of
clients in California.

Packet Page 266 of 1251Attachment 3 Page 10 of 120

Appendix | 7
City of Fairfield| CA
Response to RFQ for GIS Services and Training

We have hand-selected a team we believe fits this project, and will provide all of the necessary skillsets needed for the City of Fairfield. This team has experience with data conversion, migration, and creation. They are experts in the Esri platform and Esri ecosystem, and training for local government. (See qualifications matrix on the following page).

Hourly Rates Table
Team Member and Title Hourly
Rate
David Holdstock- GIS Strategic Planner and Advisor $ 210 Jason Marshall- GIS Manager, Strategic Planner, Trainer, and Utility Data Conversion Specialist $ 200
Jessy Beasley- Project Manager (PM), Strategic Planner, Trainer, and Utility Data Conversion Specialist $125
Andrew Valenski- Esri IT, Databases Architect Expert and Trainer $195 Scott Mason- Software Solutions Expert, Trainer, and Fiber Optics $193 Rives Deuterman-GIS Utilities Data Migration Manager and Trainer $115 Lance Kanzigg- GIS Utilities Technician $60
Dana Allcott GIS Technician $60
Grace Tueller GIS Technician $60
Jordan Rhoton GIS Technician $60

Estimate of work to be performed locally: 80% off site | 20% on-site

Packet Page 267 of 1251Attachment 3 Page 11 of 120

8 | Appendix
City of Fairfield| CA
Response to RFQ for GIS Services and Training

A matrix of our team qualifications can be found below. Full resumes can be found on the pages that follow.

Packet Page 268 of 1251Attachment 3 Page 12 of 120

DAVID H OLDSTOCK, GISP
GTG CEO- GIS Strategic Planner and Advisor
919.222.1421 [email protected]

EDUCATION
MASTER OF SCIENCE –Natural Resources GIS
Research Program, College of Natural Resources,
North Carolina State University (NCSU), Raleigh, NC.

August 1988 – May 1990. Thesis: “An Evaluation of
Computer Mapping Software for Natural Resource
Management”, Holdstock, 1990.

BACHELOR OF ARTS: HONORS – Geography, School
of Humanities Greenwich University/Thames
Polytechnic, London, United Kingdom. September
1982 - June 1984. Dissertation: “Tracking
Contaminated Water in the London Boroughs”,
Holdstock, 1984

CERTIFICATIONS
• Certified GIS Professional (GISP) Certificate # 23795 • Member of Urban and Regional Information System
Association (URISA)
• ESRI Business Partner
AWARDS
• ESRI’s 2017 Best GIS Citizen Engagement Award
• ESRI’s 2011 International Award for Mobile
Applications
• ESRI’s 2012 & 2016 Special Achievement in GIS Award
• ESRI’s 2018 Cornerstone Partner Recognition Award
• URISA’s Exemplary Systems in Government Award
• URISA’s Excellence in GIS Award
• URISA’s Best Web GIS Solution
• URISA’s 2019 Distinguished Exemplary Systems
Award in Local Government

PROFILE
One of North America’s leading authorities on GIS strategic implementation planning. Developed over 300 GIS strategic plans for towns, cities, counties, multi- regional agencies, and native indigenous people. Written two GIS strategic planning books. Developed innovative GIS management and analytics models. Secured many awards for exemplary use of GIS. A keynote speaker and presenter. Conducted many GIS workshops, webinars, and seminars. Currently collaborating with many organizations to build smarter communities with GIS technology and location intelligence. Research includes studying the maturation and evolution of GIS, promoting the democratization of GIS, encouraging the regionalization of GIS, and embracing the ubiquitous participation.

Projects and practice include building GIS working solutions to address community engagement, open and transparent government, community resilience and sustainability, social equity and social justice with an emphasis on affordable housing, available and accessible parks, open space, and recreational opportunities, climate change, economic development, and smart city 3D visualization. Worked in many parts of the world including USA, Canada, United Arab Emirates, Qatar, Africa, South Africa, St.

Vincent and the Grenadines, and the Bahamas. Committed to location intelligence to create connected, engaged, inclusive, and sustainable communities

KEY EXPERIENCE
• Managed over 300 GIS Needs Assessments and Enterprise Implementations • Has managed the deployment of Esri Solutions for Hundreds of Clients • Former GIS Manager for World’s Leading Transportation Engineering Company – Parson Brinkerhoff, Quade and Douglas (PBQ&D), NY
• Extensive Publications and Presentations on GIS For Local Government • Conducts GIS Technology Workshops and Education Seminars • 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)
• Opening Keynote Speaker for Wyoming and Colorado Elevations Geospatial Summit GIS: Yesterday, Today, and Tomorrow 2020 to 2040: Smart, Resilient and Sustainable Local Government Organizations (May 2018)

SIMILAR PROJECTS
City of Tulare, CA - GIS Strategic Master Plan and Technical Support City of Fort Pierce, FL - GIS Needs Assessment and Technical Support City of Pico Rivera, CA – Geospatial Master Plan and Technical Support City of Lathrop, CA - GIS Needs Assessment and Technical Support City of Morgan Hill, CA – GIS Strategic Plan, Action Plan, and Technical Support City of Hobart, IN – GIS Strategic Plan and Implementation and Technical Support City of Irvine, CA – 5 Year GIS Strategic Plan and Technical Support

PUBLICATIONS
• 1990- 2021. Extensive publications in GIS and
GPS in strategic planning, transportation,
environment, telecommunications,
management, applications, value proposition,
best geospatial practices, challenges, barriers
and pitfalls, governance, the democratization of
GIS, and the future of geospatial technology.
• Holdstock, David A. 2017. GIS Strategic Planning
and Management in Local Government. Boca
Raton: Taylor & Francis Group.
• Holdstock, David A. 2020. Smart Geospatial
Practices and Application: An Altogether
Different Language. Boca Raton: Taylor &
Francis Group.
• Pending Book 2023: Building Smarter
Communities with Location Intelligence.:

MOdernization Boca Raton: Taylor & Francis
Group.

BA
MS
Packet Page 269 of 1251Attachment 3 Page 13 of 120

WEBINARS
2021 Webinar Series: 12 Part “Beyond Location
Intelligence” Series – including the following:
• Critical Steps to GIS Success in Local
Government
• The Value Proposition of Location
Intelligence and Geospatial Technology
• The Challenges, Barriers, and Pitfalls of GIS
in Local Government
• How to Apply for a GIS Grant?
• Why Should a Town, City, or County Invest
in a GIS Strategic Plan?
• A Formula for Success: The Six Pillars of GIS
Sustainability
• GIS Governance and Maturity Models in
Local Government
• The Future of Geospatial Practices and
Applications in Local Government
• How to Sell Location Intelligence?
• Characteristics of a Perfect GIS Manager
• How to Build an Enterprise, Sustainable,
Scalable, and Enduring GIS
• Building Smarter Communities with
Location Intelligence
Develops GIS strategic implementation plans for
government organizations. Over the course of 24
years has supported municipal government by
developing new and innovative GIS governance
and management models, GIS maturity models,
innovative strategies, methodologies, and
initiatives including but not limited to the following:
• A GIS Maturity Model – The Six Pillars of GIS
Sustainability
• A Regional GIS Framework Model – A Five
Tier Regional Framework Model
• GIS Governance and Management Models –
Centralized, Decentralized, and Hybrid
Governance Strategy
• High-Performance Organization (HPO) – A
GIS Centric HPO Model
• Award Winning “Green City” GIS Initiative -
GreenCityGIS.com
• A GIS Business Realization Planning
Strategy
• Best GIS Business Practices
• Strategies for 3-Dimensional (3D) Modelling
• Urban and Regional Information Systems
Association (URISA) – Lead Researcher in
the Development of a New 2022 GIS
Maturity Model Workshop

PRACTICE AND RESEARCH

DAVID HOLDSTOCK, GISP
continued

WORKING EXPERIENCE
Experience includes all areas of local government operations including Public Safety, Law Enforcement, Police and Emergency Management, Public Works and Public Utilities, Natural Resources, Parks and Recreation, Public Administration, Public Services, and Telecommunications. Presently combining real-world consulting and research to implement GIS technology and location intelligence for the following communities:
• Affordable Housing and Homelessness – City of Tulare, CA • Economic Development – City of Mississauga, Ontario
• Smart Green City Parks – Parks, Recreation, Open Space, Natural Resources - City of Berkeley, CA
• Telecommunications and Fiber Management – City of Wilson, NC • 3D Modeling – City of Roswell, GA and Green Cove Springs, FL • Geo HUB – City of Fort Pierce, FL
• Enterprise Integrated Utilities – City of Hobart, IN
• Public Works Geospatial Master Plan – Doha, Qatar
• Historic Story Maps – Town of Windsor, CA
• Climate Change Story Maps – City of Thousand Oaks, CA • COVID-19 Applications– City of Roswell, GA
• Rainbow Coalition - Geospatial Community Events – West Hollywood, CA • Next Generation E-911 Public Safety Suite – Westmoreland County, VA • Emergency Operations Center (EOC) – Simi Valley, CA
• GIS and Wine Country – Jackson Family Wines, CA
• Innovative Survey 123 Applications – City of Broken Arrow, OK • Emergency Management and Incident Collaboration – Morgan Hill, CA • Hurricane Damage Assessment – City of Fort Pierce, FL • Water Outage Planning, Assessment, Customer Notification – Howard County, MD
• Hydrant Maintenance Work Order Solutions – City of Broken Arrow, OK • Survey 123 – Sewer Inspections/Grease Interceptor Inspections/Water Quality Testing – Broken Arrow, OK
• Open Data ArcGIS Web Portal – City of Green Cove Springs, FL • GIS Regional GIS Framework Model – Wake County, NC
• 2021- 2026 - Five Year GIS Strategic Implementation Plan – City of Fremont, California
• 2021-2026 - Five Year GIS Strategic Implementation Plan – City of Englewood, Colorado
• 2021-2026 - Five Year GIS Strategic Implementation Plan – Town of Ajax, Ontario, Canada
• 2022-2026 - Five Year GIS Strategic Implementation Plan – City of Pickering, Ontario, Canada

Packet Page 270 of 1251Attachment 3 Page 14 of 120

KEYNOTE SPEAKER /WORKSHOP INSTRUCTOR
Presented and taught at many professional conferences throughout United States and beyond. The following represent a sample of presentations:
• Opening Keynote Speaker: Holdstock, David, A. 2019. GIS Smart, Resilient and Sustainable Local Government. Central Florida GIS Conference. September 2019. • Opening Keynote Speaker: Holdstock, David A. 2018. Yesterday, Today, and Tomorrow - 2020 to 2040. Wyoming and Colorado Elevations Geospatial Summit GIS. May 2018. • GIS Conference Speaker and Presenter. Multiple GIS technical papers, presentations and speaking engagements throughout North America since 1990. The following is a sample:
• Holdstock, David A. (September 1993) Utilizing A Geographical Information System (GIS) for A Roadway Improvement Planning Study on The Southern State Parkway Corridor, Long Island, New York. 4th National Conference on Transportation Planning Methods Applications, Volumes I and II. A Compendium of Papers. • URISA Workshop Instructor, (2000-2004).
• David A. Holdstock eta al (October 5-6, 2009) Project Management Basics for New Project Managers. 2009 Illinois GIS Association Conference.
• David A. Holdstock et al (July 19, 2010) 10 Ways to Improve Your Public Safety Using GIS.

Arizona APCO-NENA State Training Conference.
• DeGroot, Irene and David A. Holdstock. (September 28 - October 1, 2010) GIS Centric ERP Solutions: The Next Generation of Geospatial Integration. URISA GIS-Pro 2010. • Holdstock, David A. (September 30 - October 4, 2012) 311 GIS-Community Crowd Sourcing.

URISA GIS-Pro 2012 in Oregon.
• Holdstock, David A. (2013) Smarter Cities – Deploying ArcGIS for Local Government and ArcGIS Online. 2013 ESRI Southeast User Conference.
• Holdstock, David A. and Cathy Raney. (April 2013) 16th Annual American Association of Airport Executives GIS Conference.
• Holdstock, David A. (April 8-12, 2013) Crowdsourcing and Citizen Engagement. South Central Arc User Group (SCAUG). Texas.
• Holdstock, David A. (April 8-12, 2013) Smarter Cities – Deploying ArcGIS for Local Government and ArcGIS Online. South Central Arc User Group (SCAUG). Texas. • Holdstock, David A. (September 2013) Smarter Cities – Deploying ArcGIS GeCo. West Annual Conference.
• Holdstock, David A. (September 2013) Breaking Down Barriers for GIS Use GeCo. West Annual Conference.
• Holdstock, David A. (September 16-19, 2013) The Formula for GIS Success: Strategic GIS Planning and Management in Local Government. Geospatial Conference of the West. • Holdstock, David A. and Cathy Raney. (October 18-22, 2015) A World Class GIS Solution and a Forerunner of Things to Come. URISA GIS-Pro & NWGIS 2015. • Holdstock, David A. (2016) GIS and Telecommunications • Baber, Patrick and David A. Holdstock. (October 3, 2016) What’s the Return on Investment (ROI): The Business Case for GIS? Georgia Geospatial Conference. • Holdstock, David A. (October 3-5, 2016) Smarter Communities: Data Analytics and Geospatial Technology is Charting a New Course for the City of Roswell’s Parks and Recreation Departments. Georgia URISA and GITA Southeast. • Holdstock, David A. (October 3-5, 2016) Are You Really a Good GIS Manager? Do You Have the Right Management Characteristics? Georgia URISA and GITA Southeast. • Holdstock, David A. (Oct 6, 2016) WyGeo Annual Conference. • Holdstock, David A. (July 10-14, 2017) Booth Presentations. 2017 ESRI User Conference. • Holdstock, David A. (2017) Presentation at CalGIS.
• Holdstock, David A. (May 2018) Wyoming and Colorado Elevations Geospatial Summit GIS. • Holdstock, David A. (September 2019) Central Florida GIS Workshop. • Holdstock, David A. (2020) Geospatial Technology and Location Intelligence: Changing the Entire Parks and Recreation, Open Space, Conservation and Natural Resource Landscape.

National Recreation and Parks Association (NRPA).
• Holdstock, David A. (2021) How to Plan, Design, Build, Maintain and Modernize Your Enterprise GIS.
• Montana Rural Water Systems Conference.
• Holdstock, David A. (2021) The Value Proposition of Location Intelligence. GIS in the Rockies (GISITR).
• Holdstock, David. A. (2021) The Art of Strategically Planning GIS Solutions. North Carolina ArcGIS Users Conference (NCAUG).
• Holdstock, David A. (2021) Smart Parks and Recreation: Outstanding Benefits of Location Intelligence. National Recreation and Parks Association (NRPA). • Holdstock, David A. (September 2021) The Business Realization Planning of Location Intelligence. Urban and Regional Information Systems (URISA)

DAVID HOLDSTOCK, GISP
continued

EMPLOYMENT
1997 – 2021: Chief Executive Officer (CEO) and co-
owner of Geographic Technologies Group
(GTG).GTG is one of the world’s leading local
government GIS strategic planning and services
consulting companies and is headquartered in
Raleigh, North Carolina. Incorporated Geographic
Technologies Group in 1994 and is CEO and a
leading GIS Strategic Planner for local government.

Currently working on multiple GIS strategic projects
in USA and Canada.
1994 – 1997: Director for GIS/GPS at the Institute
for Transportation Research and Education (ITRE).

ITRE is a university-based entity committed to
leadership, analytical thinking, integrating
technology, problem solving, and professionalism.

As GIS/GPS Director for nearly four years
collaborated with NCSU Civil and Environmental
Engineering faculty and students, the Center for
Transportation and the Environment (CTE), and
North Carolina Department of Transportation
(NCDOT).
1990 -1994: GIS Specialist and GIS Cost Center
Manager for Parsons, Brinkerhoff, Quade, and
Douglas (PBQ&D), NY. In the 1990’s PBQD was the
largest transportation engineering company in the
world, headquartered in New York City. One of the
first GIS Managers that applied GIS technology to
Environmental Assessments (EA), Environmental
Impact Statements (EIS), Long Island Railroad (LIRR)
studies, pedestrian modeling, and large
transportation corridor projects.

Packet Page 271 of 1251Attachment 3 Page 15 of 120

JASON MARSHALL, GISP, PMP

GIS DIRECTOR AND UTILITY DATA CONVERSION SPECIALIST
919.920.3071 [email protected]

EDUCATION
MASTER OF ARTS – Applied Geography
Concentration in GIS
University of North Carolina, Greensboro
BACHELOR OF ARTS – Geography
University of North Carolina, Greensboro

CERTIFICATIONS
Geographic Information Systems
Professional (GISP)
Project Management Professional
(PMP)- Project Management Institute

PROFILE
Mr. Jason Marshall has 16 years of GIS experience and has served as Utility Specialist for many of GTG’s GIS technical projects. He previously served as the GIS Application and Administrator for the Information Technology Department of the City of Greensboro, North Carolina. While there he formed and coordinated an enterprise wide cross-departmental Data Leadership Team and partnered and collaborated with external stakeholders to leverage City GIS data for community benefit. He managed ArcGIS Geodatabases, ArcGIS Enterprise, ArcGIS Online, and web GIS solutions to support end-user requirements for data analytics and access. He also designed, implemented, and managed the City’s Open Data Program. 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 designed and executed ArcGIS and web GIS server architecture, system migration, and operating system upgrades, consistent data collection, data integration, and editing for the IT department.

KEY EXPERIENCE
• Conducts GIS Needs Assessments, System Designs, and Strategic Plans • Performs Comprehensive Assessments of GIS Applications, Data Infrastructure, Hardware and Software Systems for utilities
• Provides Migration Strategies to ArcGIS Systems and Software for utilities • Identifies Performance Issues with GIS Technology and Makes Recommendations for Data Management for utilities
• Designs, Implements, and Manages Departmental GIS Projects, Data, And Analysis • Manage, Administer, and Govern ArcGIS Enterprise and ArcGIS Online • 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 • Training for local government staff

SIMILAR PROJECTS
Contra Costa Water District, CA - GIS Needs Assessment and 5 Year Strategic Plan Santa Clara Valley Water District, CA - GIS Needs Assessment City of Tulare, CA - GIS Strategic Master Plan
City of Fort Pierce, FL - GIS Needs Assessment
City of Granbury, TX - GIS Strategic Implementation Plan City of Pico Rivera, CA – Geospatial Master Plan
City of Lathrop, CA - GIS Needs Assessment
City of Morgan Hill, CA – GIS Strategic Plan and Final Action Plan City of Hobart, IN – GIS Strategic Plan and Implementation City of Irvine, CA – 5 Year GIS Strategic Plan
Spotsylvania County, VA – GIS Assessment

TECHNICAL SKILLS
ESRI’s Suite of GIS Software, ArcGIS
Enterprise, ArcGIS Online, Open Data &
Open Performance, SQL Server,
Transact-SQL, Microsoft Excel, HTML5,
CSS, JavaScript, React, Node.js, Postgres,
C#, Powershell, Git.

BA
MA
Packet Page 272 of 1251Attachment 3 Page 16 of 120

JESSY BEASLEY

PROJECT MANAGER
386.478.3659 [email protected]

EDUCATION
BS
MS
MASTER OF SCIENCE – Geography
Certificate: GIS
East Carolina University
BACHELOR OF SCIENCE – Geography
University of Florida

CERTIFICATIONS
Graduate Certificate in Geographic
Information Systems

PROFILE
Mrs. Jessy Beasley has worked with GIS data and Esri products for over seven years. As a Project Manager, GIS Analyst, and Utility Data Conversion Specialist for GTG, she has completed GIS Data Assessments, performed QA/QC, deployed software, and migrated data to Esri’s ArcGIS Utility Network schemas. She has assisted in the planning, data gathering, design, and deployment of ArcGIS Hub solutions for several clients. Jessy has also 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 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.

KEY EXPERIENCE
• Project Management
• ArcGIS Desktop, Mobile, and Web applications
• Digital Data Layer Creation and Maintenance for Utilities • Deployment of Geospatial Websites
• Proficient in ArcGIS Online and the Esri Ecosystem, including GIS Licensing Management
• Dashboard Creation, ArcGIS Hub, and Web Solutions for Utilities • Workflow and Geoprocessing Automation
• Spatial Modeling and Print Maps (large format)
• Data Creation and Migration for Utlities
• Data Integrity and QA/QC Procedures
• Employs GIS web applications to ease information sharing and provides and maintains quality GIS data and databases.
• Understanding of file geodatabase structure and subsequent data configuration, GIS Database Maintenance
• Targeted Application Development
• LGIM Implementation and Migration
• Departmental Data Creation – Digitizing, Conversion, GPS Field Inventory, and Integration
• Staff Support, Training, and Education

SIMILAR PROJECTS
City of Hobart Sanitary District , IN – GIS Needs Assessment, Geospatial Data Hub, and GIS Implementation
City of Berkeley, CA - Software Consulting Services, ArcGIS Hub Solution Planning, and Implementation of GIS software
City of Roswell, GA – GIS Consulting, Public GIS Viewer, ArcGIS Data Hub Planning, and Implementation
City of Fort Pierce, FL - Software Consulting Services, ArcGIS Hub Solution Planning, and Implementation of GIS software
City of Broken Arrow, OK – GIS Consulting Services, Database Clean-up and Design, Maintenance, ArcGIS Data Hub Planning

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,

Packet Page 273 of 1251Attachment 3 Page 17 of 120

ANDREW VALENSKI

ESRI IT, DATABASE ARCHITECT, AND TRAINER
516.524.2016

[email protected]

EDUCATION
BACHELOR OF ARTS – Geography
University of Richmond
BACHELOR OF SCIENCE –
Environmental Studies
University of Richmond

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 IT/GIS Architect and Integration Expert for Geographic Technologies Group. He works with clients to design, implement, and maintain Enterprise systems and develop custom GIS applications and processes. He helps clients determine what geo-spatial solutions will work best for their organizational needs and develops custom applications/systems for them. He also provides training. These solutions include the following: GIS strategic plans, enterprise implementation, governance models, GIS and database development, GIS architecture, geodatabase implementations, data management strategies, ETL/script development, maintenance and 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 and developed an organizational data management system. He served as a Senior Enterprise GIS Analyst for Esri with the solutions and support teams to deliver server-side, geodatabase and web solutions for strategic customers.

KEY EXPERIENCE
• Builds and Deploys custom GIS architecture and spatial applications for local government
• Develops GIS and data applications and solutions
• Migrates desktop users to ArcGIS Pro and the Esri Ecosystem • GIS Integration Strategies with LGIM Standards
• Designs and Implements Enterprise GIS Solutions
• Recommends GIS Data Strategies for Clients
• Enterprise GIS design and administration and full-stack development • Database and Geodatabase management and GPS Field Inventory • IT management and education
• Quality assurance and quality control (QA/QC) Procedures • Enterprise migrations, application development and geoprocessing development
• Training for Local Government Staff

SIMILAR PROJECTS
City of Morgan Hill, CA- Capacity Planning, Database Development, GIS Infrastructure Development, Script Development, Security Implementation City of Irvine, CA- Infrastructure Development, Database Development, ArcGIS Portal Development, Integration Upgrades, Workflow Automation City of Mississauga, ON- Database QA/QC, Data Integrity, Integration Upgrades, Script Development, Database Development
Contra Costa Water District, CA- Infrastructure Development, Database Development, Integration Upgrades, Capacity Planning, Security Implementation

TECHNICAL SKILLS
LANGUAGES:

Bash, CSS, Git, Groovy, HTML,
JavaScript, JQuery, Powershell, Pug,
Python, R, Ruby, SQL, SASS, TypeScript
TECH/FRAMEWORKS:

ArcGIS JS API, ArcGIS Python API, AWS,
Azure, Bootstrap, Docker, GitHub,
Hyper-V, Leaflet, NodeJS, Rails, SSIS,
SSRS, TFS, Go, VMWare
SOFTWARE/STACKS:

Esri, GeoServer, Google, MapBox,
MariaDB, MongoDB, MySQL, Oracle,
PostGreSQL, QGIS, SQL Server

BA
BS
Packet Page 274 of 1251Attachment 3 Page 18 of 120

SCOTT MASON

SOFTWARE SOLUTIONS EXPERT
440.796.6794 [email protected]
BACHELOR OF SCIENCE – Computer
Science
Ohio University
BACHELOR OF SCIENCE – Mathematics
Ohio University

Xamarin Certified Professional
Mr. Scott Mason serves as the Software Solutions Expert and Senior Developer for Geographic Technologies Group. He is a strategic and forward-thinking IT Architect and Developer combining over 19 years of success in both software development and management with strategic vision to drive innovation and generate growth. He has extensive experience in developing comprehensive IT solutions and supporting back-end services. Mr. Mason is excited by new technologies with a record of translating market needs into dynamic and profitable new products. He is responsible for both technical architecture and simultaneous software development for projects ranging in scope from small projects to large multi-year enterprise ventures. He holds Bachelor of Science degrees in both Computer Science and Mathematics from the University of Ohio.

Mr. Mason proudly leads our new Center for Innovation and Excellence team.

KEY EXPERIENCE
• Manages day to day development and support needs for
Geographic Technologies Groups software products to include Vantage Points (version 1 and 2), Fiber Management System and GeoMax
• Manages the software product lifecycles providing both short and long term goals for GTG product line.
• Lead/Enterprise developer for the GTG product lines
• Provides assistance to the GIS consultancy when needed. • Increases customer satisfaction by developing and delivering features and enhancements that are both customer-oriented and customer-driven.

TECHNICAL SKILLS

EDUCATION

CERTIFICATIONS

PROFILE
PROGRAMMING:

C#, .NET, Xamarin, ASP.NET, VB.NET,
Objective-C, Swift, JavaScript, HTML,
Java, Java Beans / EJB / J2EE, XML,
PL/SQL, SQL, MS-Visual Basic 6,
VBScript, COM/COM+/DCOM,
ADO/ADO.NET, C++, FORTAN, COBOL
SOFTWARE:

Microsoft Visual Studio 2005, 2008,
2010, 2013, 2017, Mac; Xcode and Apple
iOS; Android Studio / Eclipse
METHODOLOGIES:

Object Oriented Programming; Agile
Development; MVC Design; MVVM
Design; Test Driven Development;
Integrated Software Development;
SDLC; Source Control (Git); Continuous
Integration (Jenkins)
DATABASES:

MS-SQL Server; Oracle; MySQL; MS-
Access; SQLite

BS
Packet Page 275 of 1251Attachment 3 Page 19 of 120

RIVES DEUTERMAN

GIS UTILITIES DATA MIGRATION MANAGER
336.965.4968 [email protected]

EDUCATION
BACHELOR OF SCIENCE –
Environmental Science (Energy and
Sustainability concentration)
Minor in Geography (GIS focus)
University of North Carolina, Chapel Hill

PROFILE
Mr. Rives Deuterman currently serves as GIS Utilities Data Migration Manager for Geographic Technologies Group. He has a Graduate Certificate in Geographic Information Systems. At GTG, Mr. Deuterman assists in all Needs Assessments, Analysis, and the creation of GIS Strategic Plans and Roadmaps. He also is project lead on all of our ArcGIS Hub and Geospatial Data Hub Solutions. He performs geodatabase management, data creation, migration and conversion, data capture, and data cleanup. He reviews data transfer and consolidations. He also provides QA/QC procedures and detailed technical documentation. He has experience with SQL. He creates and maintains data layers and develops maps and applications. He provides updates and maintenance for clients, as well as on-call technical support. He responds to client requests and provides as- needed GIS training.

KEY EXPERIENCE
• GIS Consulting and Implementation
• Data Migration and LGIM Data Standards
• GPS Field Inventory
• Geospatial Websites
• ArcGIS Hub Solutions
• Esri Software Updates and Maintenance
• GIS Data Management and Migration
• Data Transfer and Consolidation
• Data Layer Creation, Digitizing, Conversion, and Integration • ArcGIS Implementation
• GIS Technical Support Services
• Data Collection using Collector for ArcGIS, GPS Field Inventory • Quality Control/Quality Assurance Standards
• Esri Suite Set-Up for Community Services and Police/Public Safety • Ongoing Staff Training, Support, and Assistance

SIMILAR PROJECTS
City of Hobart Sanitary District, IN – GIS Needs Assessment, Geospatial Data Hub, GIS Implementation, and Technical Support Services City of Tulare, CA – GIS Consulting, Strategic Plan, Implementation, and Technical Support Services
City of Fort Pierce, FL- Strategic Planning, Software Consulting Services, ArcGIS Hub Solution Planning, Implementation, and Technical Support City of Roswell, GA – GIS Strategic Planning, Consulting, Public GIS Viewer, ArcGIS Data Hub Planning, Technical Support, and Implementation City of Broken Arrow, OK – GIS Consulting Services, Database Clean-up and Design, Maintenance, ArcGIS Data Hub Planning, and Implementation

TECHNICAL SKILLS
• ArcGIS applications ArcSDE
o Spatial Analysis, Network
Analysis, and Data
Reviewer extensions
• Esri Software Suite
• Python, SQL, Matlab
• Microsoft Visual Basic and VB.NET
• Remote Sensing, Envi Image
Processing Software
BS
Packet Page 276 of 1251Attachment 3 Page 20 of 120

LANCE KANZIGG

GIS TECHNICIAN AND UTILITY SPECIALIST
336.965.4968 [email protected]

EDUCATION
BACHELOR OF SCIENCE –
Geography, University of Southern
Mississippi, 2015

MASTER OF SCIENCE-
GIS Administration, University of West
Florida, 2020 - present

PROFILE
Mr. Lance Kanzigg currently serves as a GIS Technician and Utility Specialist for Geographic Technologies Group. He has a Bachelor of Science degree in Geography and pursuing a Masters in GIS Administration. Mr. Kanzigg has five years of GIS experience. At GTG, Mr. Kanzigg assists in field collection, database management, map creation, GIS implementation, and QA/QC procedures. He also is our utilities specialist, providing insight on GIS for water/sewer/stormwater on all utilities-based projects.

KEY EXPERIENCE
• Esri solutions for Utilities
• Geographic Mapping
• Data Collection
• Knowledge of Underground Infrastructure
• Database Management
• Digitizing and Georeferencing
• Digital Imagery
• Field data transfer
• Field inspections
• GIS Accuracy verification
• Map creation

TECHNICAL SKILLS
• Esri Suite of Software
• MS Office Suite

MA
BS

PROJECT EXPERIENCE
Constantine Engineering (GIS Technician)
• Lead field crews and was responsible for delivery and QA/QC of all data collected.
• Performed water/sewer GIS database management for local municipality.
• Digitized and georeferenced as-built drawings and digital imagery. • Created maps and wrote reports for final project deliverables. • Performed field data transfer, post processing and implementation. • Physically verified GIS accuracy using ground penetrating radar and vacuum excavation.
• Inspected underground pipelines using smoke testing and visual inspection.
• Inspected stormwater, sanitary sewer, and potable water structures.

Packet Page 277 of 1251Attachment 3 Page 21 of 120

DANA ALLCOTT

GIS TECHNICIAN
713.385.6768 [email protected]

EDUCATION

GIS AAS -
Lone Star Community College
Associate in Science – Geology
Houston Community College

PROFILE
Dana Allcott has experience working with GIS data entry, maintenance, and creation of core GIS information using ArcGIS Software including ArcMap, ArcGIS Pro, ArcScene, ArcCatalog, ArcGIS Online, and Arc Toolbox. As a GIS Data Specialist, she has maintained database standards and has executed quality control for database maintenance by reviewing input and output, while ensuring integrity of database changes. She has assisted in analyzing output and research, and correcting source problems using her critical thinking skills, accompanied by her data acquisition and analysis skills.

KEY EXPERIENCE
• ArcGIS Software: ArcMap, ArcGIS Pro, ArcScene, ArcCatalog, ArcGIS Online, and Arc Toolbox
• Perform data entry, maintenance, and creation of core GIS information for the Engineering Dept
• Maintain database standards and execute quality control for database maintenance
• Review input and output, ensuring integrity of database changes • Analyze output and research, and correct source problems • Fulfill requests from Engineers and Project Managers for GIS information and exhibits

TECHNICAL SKILLS
• Esri Software Suite
• Maintenance and creation of core
GIS information using ArcGIS
Software including ArcMap, ArcGIS
Pro, ArcScene, ArcCatalog, ArcGIS
Online, and Arc Toolbox
• GIS data entry

PROJECT EXPERIENCE
GIS Data Specialist, Harris County Engineering Department • Performed data entry, maintenance, and creation of core GIS information for the Engineering Dept
• Maintained database standards and execute quality control for database maintenance
• Reviewed input and output, ensuring integrity of database changes
• Analyzed output and research, and correct source problems • Fulfilled requests from Engineers and Project Managers for GIS information and exhibits
Packet Page 278 of 1251Attachment 3 Page 22 of 120

GRACE TUELLER

GIS TECHNICIAN
808.230. 60491 [email protected]

EDUCATION
BACHELOR OF SCIENCE – Geospatial
Science & Technology
Brigham Young University

TECHNICAL SKILLS
• Esri’s WAB
• Esri Mobile Apps
• SPSS
• GeoDa
• SpaceStat
• SQL
• ArcGIS Online
• ArcGIS Desktop
• ArcGIS Pro
• ArcMap ModelBuilder
• Programming Languages
o Python
o HTML/CSS
o JavaScript
• Microsoft Office Suite
• Microsoft Teams
• Skype for Business
• Monday.com (Project
Management Software)

PROFILE
Ms. Grace Tueller is a GIS Technician for Geographic Technologies Group.

Grace has previous experience as a GIS consultant and an Esri Product Engineering Intern. She has a deep understanding of ArcGIS Pro, ArcGIS Online, and ArcGIS Desktop. Ms. Tueller creates, edits, and maintains GIS data. She also analyzes spatial data, performs data manipulation, and creates story maps and webmaps. Her experience includes hot spot analysis, network analysis, and geostatistical analysis, as well as georeferencing, SQL queries, data visualization, cartographic design, and remote sensing image processing. She also has experience troubleshooting GIS issues and providing GIS skills training. Grace has experience with several programming languages and Esri solutions, and excels at working with clients virtually and onsite.

KEY EXPERIENCE
• Web Map updates and maintenance
• Data correction and QA/QC
• Data acquisition
• Data cleanup
• Map creation
• Data analysis
• Publishing data to AGOL
• Georeferencing
• GIS training
• Address geocoding
• GIS technical support
• File and enterprise geodatabase design and managment

PROJECT EXPERIENCE
Provo City Cemetery / GIS Intern
Update and maintain cemetery web map. work independently to correct hundreds of data errors, ensuring data quality, Create GIS data and perform SQL queries in enterprise GIS environment
BYU Harold B. Lee Library / GIS Student Consultant
Assisted patrons with data acquisition, data clean-up, map creation, data analysis, and other GIS projects daily, using ArcGIS Desktop, ArcGIS Pro, QGIS, empowered patrons to complete tasks on their own by teaching GIS skills, provided friendly and supportive environment for patrons, collaborated with other consultants on projects, troubleshooted GIS issues regularly Esri / Product Engineering Intern
Worked as a virtual intern as a member of the ArcGIS Pro map authoring team, created over 100 new symbols for ArcGIS Pro, performed manual checklist and ad hoc software testing and provided, thorough documentation of results participate in daily scrum meetings, reporting on progress.

BS
Packet Page 279 of 1251Attachment 3 Page 23 of 120

JORDAN RHOTON

GIS TECHNICIAN I
919.429.6377 [email protected]

EDUCATION
BACHELOR OF ARTS – Geography
University of Tennessee

Mr. Jordan Rhoton currently serves as a GIS Technician for Geographic Technologies Group. While attending school, he spent time as a Transportation Planning Intern with the City of Kingsport, Tennessee where he contributed to a land use and transportation study of a development area, analyzing the area’s existing GIS layers in ArcMap and making recommendations for infrastructure improvements. While at GTG he has worked on numerous GIS technical projects for clients and has performed GIS data services including map creation, data creation, data verification, map adjustments, and maintenance.

KEY EXPERIENCE
• Data Assessment and Creation
• Internal ArcMap tools including the data reviewer and network analyst
• Road centerline accuracy adjustments
• Visual inspections
• Attribution management and QA/QC

PROFILE

SIMILAR PROJECTS
CALFIRE, CA- Data management and creation
Town of Windsor, CA- Data analysis and testing
City of Richmond, BC- Data assessment
City of Lawrenceville, GA- UtilityCityGIS, Electrical Systems Town of Adair, OK- SafeCityGIS, 911 Address Point Verification Soloano County , CA- SafeCityGIS, Parcel and Tax map adjustments Westmoreland County, VA- SafeCityGIS, 911 Address Point Verification

TECHNICAL SKILLS
• Esri Software Suite
• ArcGIS Online
• ArcGIS Pro
• Collector for iPad
Packet Page 280 of 1251Attachment 3 Page 24 of 120

Appendix | 21
City of Fairfield| CA
Response to RFQ for GIS Services and Training

GTG Project Management Process
Geographic Technologies Group (GTG) is a leading GIS firm with a heavy focus on supporting City GIS operations and infrastructure. Each of our proposed team members is highly qualified and has provided similar services for clients throughout California and the United States. As a GIS-only company, we have perfected our project management processes over the past 23 years in business. Our team collectively meets all of the qualifications identified in the RFP.

Managed by a Project Management Professional (PMP)
This project will be managed by Jessy Beasley, with direct oversight from Jason Marshall, GTG’s GIS Director, who is a certified Project Management Professional (PMP) and Geographic Information System Professional (GISP). Mr. Marshall and Ms. Beasley have hands-on experience in each of Fairfield's scope and qualification areas and manage our consulting team. Ms. Beasley will use project management best practices to ensure that the best staff person/s (inclusive of herself) is assigned to the various tasks and needs of the City of Fairfield.

Creation of an Internal Project Management Plan
GTG deploys a very tight feedback loop. As aforementioned, our team uses PMP Certification best practices such as Kanban Boards and various Information Radiators to prioritize work and inform stakeholders. GTG will manage each task/project within our project management software from Monday.com. This will give visibility to each of our team members as to the status of any task and the overall work plan for Fairfield. If a project would be best served by using
Agile project management
techniques, then an Agile
approach will be deployed. Our
team is adept with both waterfall,
Agile, and hybrid techniques. GTG
will grant the Fairfield Functional
Manager access to the task board.

Each City Task Will be Managed Within GTG’s Project
Management Software
Packet Page 281 of 1251Attachment 3 Page 25 of 120

22 | Appendix
City of Fairfield| CA
Response to RFQ for GIS Services and Training

City of Peterborough, Ontario
Wake County, North Carolina
City of Hobart, Indiana
Seminole Tribe of Florida
City of Fort Pierce, Florida
Ashghal Public Works Agency, Qatar
City of Morgan Hill, California
Bay County, Florida
City of Farmers Branch, Texas
City of Pico Rivera, California
City of San Marcos, Texas
City of Irvine, California
Santa Clara Valley Water District,
California
City of Lawrenceville, Georgia
City of Granbury, Texas
Contra Costa Water District,
California
City of Lloydminster, Alberta, Canada
City of Lauderhill, Florida
City of Tulare, California
City of Berkeley, California
Yukon Energy Corporation, Canada
Gwinnett County, Georgia
Columbus County, Georgia,
Louisville Jefferson County, Kentucky
City of West Hollywood, California
San Luis Obispo County, California
Rome Floyd County, Georgia
City of Boulder OSMP, Colorado
City of Vancouver, Washington
City of Concord, California
Wayne County, North Carolina
City of Roseville, California
City of Simi Valley, California
City of Sunnyvale, California
City of Pasadena, California
City of West Sacramento, California
City of Mississauga, ON, Canada
Lane Council of Governments, Oregon
City of Roswell, Georgia
City of Markham, ON, Canada
City of Nanaimo, BC, Canada
City of Guelph, ON, Canada
City of Edina, Minnesota
City of Woodland, California

Town of Truckee, California
City of Eagan, Minnesota
Athens-Clarke County, Georgia
Calvert County, Maryland
Carteret County, North Carolina
City of Alpharetta, Georgia
Lake County Forest Preserves, Illinois
City of Boynton Beach, Florida
City of Cocoa, Florida
City of Fulshear, Texas
Forsyth County, Georgia
City of Fort Pierce, Florida
City of Gillette, Wyoming
City of Goldsboro, North Carolina
City of Goose Creek, South Carolina
City of Greenville, North Carolina
City of Gulf Breeze, Florida
City of Hagerstown, Maryland
City of Johnson City, Tennessee
City of Kinston, North Carolina
City of Kissimmee, Florida
City of Lexington, North Carolina
City of Maryville, Tennessee
City of Medford, Oregon
City of Midland, Michigan
City of Miramar, Florida
City of Morehead City, North Carolina
City of North Myrtle Beach, South
Carolina
City of Olympia, Washington
City of Opelika, Alabama
City of St. Helens, Oregon
City of Stuart, Florida
City of Surf City, North Carolina
City of Tarboro, North Carolina
City of Titusville, Florida
City of Topsail Beach, North Carolina
City of Unalaska, Alaska
City of Valdez, Alaska
Town of Snowmass Village, Colorado
Yuma County, Arizona
City of Dayton, Ohio
Lenoir County, North Carolina
Moore County, North Carolina
Orange County, North Carolina

Pender County, North Carolina
Richland County, South Carolina
Rockingham County, North Carolina
City of Hoover, Alabama
Spotsylvania County, Virginia
Town of Boone, North Carolina
Town of Branford, Connecticut
City of Pembroke Pines, Florida
City of Parkland, Florida
City of Rio Rancho, New Mexico
City of New Bern, North Carolina
City of Shelby, North Carolina
City of South Bend, Indiana
Town of Clayton, North Carolina
Town of Davie, Florida
Town of Leesburg, Virginia
Town of Matthews, North Carolina
Town of Nags Head, North Carolina
Halifax County, North Carolina
Hendry County, Florida
Indian River County, Florida
Kitsap County, Washington
Town of Pine Knoll Shores, North
Carolina
Town of Southern Shores, North
Carolina
University of North Carolina, Chapel Hill
Wicomico County, MD
City of Salisbury, MD
Wilson County, North Carolina

Packet Page 282 of 1251Attachment 3 Page 26 of 120

Appendix | 23
City of Fairfield| CA
Response to RFQ for GIS Services and Training

Examples of Work
(more details and examples available upon request)

Packet Page 283 of 1251Attachment 3 Page 27 of 120

24 | Appendix
City of Fairfield| CA
Response to RFQ for GIS Services and Training

Packet Page 284 of 1251Attachment 3 Page 28 of 120

Appendix | 25
City of Fairfield| CA
Response to RFQ for GIS Services and Training

Packet Page 285 of 1251Attachment 3 Page 29 of 120

26 | Appendix
City of Fairfield| CA
Response to RFQ for GIS Services and Training

Packet Page 286 of 1251Attachment 3 Page 30 of 120

Appendix | 27
City of Fairfield| CA
Response to RFQ for GIS Services and Training

Packet Page 287 of 1251Attachment 3 Page 31 of 120

Appendix | 1
City of Fairfield| CA
Response to RFQ for GIS Services and Training

Packet Page 288 of 1251Attachment 3 Page 32 of 120

8239 State 371 NW | PO Box 812
Walker, MN 56484
320.207.6868 | www.prowestgis.com

City of Fairfield, CA
GIS Services & Training

Submitted by: Pro-West & Associates, Inc.
8239 State 371 NW
Walker, MN 56484

Due Date: January 28, 2022

Packet Page 289 of 1251Attachment 3 Page 33 of 120

2 \
2 GIS Services & Training
January 28, 2022

City of Fairfield, CA

To Whom it May Concern,

Pro-West & Associates, Inc. (Pro-West) is pleased to respond to the City’s RFP for GIS Services & Training. Pro-West has been in business for 35 years and has a proven track record of helping cities leverage GIS to generate value for the organization and citizens. Every day, Pro-West experts across the spectrum of GIS serve as partners to our city clients, providing guidance, support and expertise to ensure long-term GIS success.

Pro-West provides value to its clients that extends beyond successful projects:
• Esri recognition endorsing our expertise in using ArcGIS technology to provide value • Assurance that expertise in technology, procedures and best practices remains current • We stand behind our work. We ensure the services and solutions we deliver remain fit for purpose and deliver long-term value.
• Some of the industry’s most experienced trainers work at Pro-West. We train and support GIS users and administrators to enable them to become self-sufficient. • We build collaborative relationships. We have augmented many of our client teams for decades, enabling them to effectively serve users and keep moving forward. We work with organizations with an appetite for learning and collaborative work.

Contact information:
• Correspondence during selection: Jenny Miller, Vice President of Marketing, [email protected], 320-207-6858
• Person authorized to negotiate contract: Brandon Crissinger, Vice-President & Chief Operating Officer, [email protected], 320-207-6854 • Pro-West lead for completing work: Paul Rairamo, Project Manager, [email protected], 320-207-6855

Thank you for the opportunity to respond to the City of Fairfield’s RFP.

*Pro-West assumes the 5-page limit includes company/team qualifications and not the Project Work Plan. However, we recognize the City’s desire for efficiency and have endeavored to keep the entire proposal concise.*

Sincerely,

Brandon Crissinger, Vice President & COO, Pro-West & Associates, Inc. [email protected] | 320-207-6854
Packet Page 290 of 1251Attachment 3 Page 34 of 120

3 \
3 GIS Services & Training
Company History
Pro-West has exclusively provided GIS services for 34 years, with cities and counties comprising 70% of our business. Our mission is to make what you do better with location technology.

Pro-West provides the full spectrum of GIS services for local government, including:
• GIS evaluation, needs assessment, and planning
• Esri ArcGIS Enterprise GIS design, implementation, support and enhancement • System architecture design
• Map creation for internal and public uses
• Data development, conversion and management
• Asset management data management and application design/development • Web and mobile application development
• Integration with third party business systems
• GIS technical support
• Training (including custom manuals and videos)
o Spatial data editing using Esri tools
 Utilities/assets, land records, natural resources, facilities and more o GIS application administrator and user training
o System administrator training including ArcGIS Server and Portal

Esri Partnership
A 30-year Esri business partner, Pro-West has been recognized for delivering value using GIS:
• 12 clients have received Esri Special Achievement in GIS (SAG) Awards • Esri infrastructure Management & GIS Conference Award for Comprehensive GIS (2021) • Award for Web GIS Transformation (2020)
• Award for Leading Web GIS Transformations (2018)
• Twice been awarded Esri’s Foundation Partner of the Year Award (2000 and 2006) • Twice been awarded Esri’s Partner of the Year Award (1994 and 2010) • Award for Best Use of Story Maps for Partner’s Business (2016) • Member of Esri Partner Advisory Council (1 of 15 members) • Esri ArcGIS System Ready Specialty Partner
• Esri State & Local Government Specialty Partner
• Esri ArcGIS Online Specialty Partner
• Esri ArcGIS Hub Specialty Partner
• Esri Federal Small Business Specialty Partner

Work Location
All work will be performed via Pro-West’s main office in Walker, MN.

Staff
Pro-West’s team is comprised of 28 full-time staff including Certified GIS Professionals and Esri certified professionals. All individuals working on this contract are permanent, full-time staff.

Packet Page 291 of 1251Attachment 3 Page 35 of 120

4 \
4 GIS Services & Training
Working with Cities
Every day, Pro-West works with cities to evaluate, implement and enhance their enterprise- wide GIS deployments to ensure value now and in the future. We support cities with GIS system architecture, enterprise GIS, data management, application development, training, and technical support. These services form the foundation of our clients’ success with location technology and we deliver them in a way that ensures both immediate and long-term value.

From supporting clients with migrations to new servers to updating their data layers, Pro-West has collaborated with hundreds of cities, empowering them to be successful with GIS. We understand the challenges and details that need to be addressed, and provide knowledge transfer along the way to streamline maintenance and support.

Our city clients value our ability to deliver breadth and depth of knowledge with a team that provides ongoing, responsive support and “big picture” insight. Pro-West supports clients’ GIS deployments by working collaboratively with them to build accurate, easily accessible data, deploy web and mobile solutions to serve internal and public users, create efficiencies by integrating GIS with third party systems, and much more.

Team Overview
Name Experience with Similar Projects Educational Qualifications Experience Paul Rairamo
Project
Manager

• Daily GIS project management and
collaboration with cities on
equivalent projects to City of
Fairfield
• Daily experience with Esri products
• B.S. Geography,
University of Wyoming
• B.S. Political Science,
University of Wyoming
8 years (3
years at
Pro-West)
Cole Sutton
GIS Data
Technician

• Utility GIS data editing, migration
and management for local
governments
• Daily experience with Esri products
• Augmenting cities’ GIS teams
• M.S. GIS, Saint Mary’s
University of Minnesota
• B.F.A. Graphic Design,
Minneapolis College of
Art and Design
5 (4 at Pro-
West)
Shelby Murphy
GIS Data
Technician

• Utility GIS data editing, migration
and management for local
governments
• Daily experience with Esri products
• Augmenting cities’ GIS teams
• B.S. Environmental
Geography, University of
Wisconsin – Eau Claire
• Graduate Certificate in
GIS, University of Denver
4 (3 at Pro-
West)

Packet Page 292 of 1251Attachment 3 Page 36 of 120

5 \
5 GIS Services & Training
Brian Bjelland
Senior
Application
Developer &
Systems
Specialist

• System architecture design
• ArcGIS Enterprise implementation
• Process automation
• Application development
• System integration
• Daily experience with Esri products
• Augmenting GIS teams
• Training GIS teams
• B.S. Computer Science,
Bemidji State University
• Certified GIS Professional
• Esri Enterprise
Administration Certified
Professional
• Esri Enterprise Geodata
Certified Professional
15 (15 at
Pro-West)
Royal Paddock
Senior
Application
Developer

• Application development
• System administration and
upgrades
• Process automation
• Enterprise GIS implementation
• System integration
• Workflow automation
• Daily experience with Esri products
• Augmenting cities’ GIS teams
• Training GIS teams
• B.S. Computer Science,
Bemidji State University

14 (14 at
Pro-West)
Alex Lange
GIS Solutions
Engineer

• Configuration of Esri-based GIS
solutions
• Assessing cities’ GIS solution needs
• ArcGIS Online user/administrator
training
• Daily experience with Esri products
• Augmenting cities’ GIS teams
B.S. Computer Science
(Minor: GIS), St. Cloud
State University, St. Cloud,
MN
4 (1 at Pro-
West)
John Snyder
GIS Specialist

• GIS analysis
• System maintenance
• System integration support
• ArcGIS Online configuration
• Data management
• Training on Esri technology
• Daily experience with Esri products
• Augmenting cities’ GIS teams
B.S. Geography, emphasis
GIS, Minor: Geology,
Bemidji State University,
Bemidji, MN
13 (3 at
Pro-West)

Packet Page 293 of 1251Attachment 3 Page 37 of 120

6 \
6 GIS Services & Training
Client References
Reference 1: City of Novato, CA – GIS Services (2020-current) Organization City of Novato, CA
Contact Shamin Miller, Information Technology Manager, 415-899-7028, [email protected]
Services provided • Enterprise GIS implementation
• Enterprise geodatabase design and management
• GIS data migration to Enterprise
• Utility database design
• Training: Enterprise GIS, geodatabase administration, desktop editing and best practices, solution configuration, administration and best practices, python scripting
• Business system integration with asset management systems • Development of web GIS solutions
• Backend automation and scripting
• Implementation of parcel tax download routine to support internal City operations
• Technical support
Dates of service 2020-current

Reference 2: City of St. Cloud, MN – GIS Services
Organization City of St. Cloud, MN
Contact Tim Hewett, Infrastructure Services Manager, 320-650-2900, [email protected]
Services provided Pro-West has been providing secure, scalable, and efficient web-based, mobile and desktop solutions, as well as data conversion and development, to the City of St. Cloud since 2004, supporting the Public Works, Utilities, Engineering, Fire, IT, Assessor and Planning Depts. • CAD to GIS conversion and ongoing maintenance of water, sanitary and storm data
• System architecture design and best practices to support an enterprise GIS-based asset management system
• Training: Enterprise GIS, geodatabase administration, Field Maps, desktop editing and best practices, solution configuration, administration and best practices
• Mobile solutions and field-to-office workflows to streamline asset management across multiple departments and office locations • Development of a custom asset and maintenance management system in less than eight weeks
• Out-of-the-box solution configuration for utilities, engineering,

Packet Page 294 of 1251Attachment 3 Page 38 of 120

7 \
7 GIS Services & Training
economic development, planning and public works
• Business system integration with Tax, CAMA, and permitting systems
• Creation of Economic Development Activity Dashboard
• ArcGIS Online/Portal solution configurations
• ArcGIS Online map gallery development
• Enterprise Geodatabase design and management
ArcGIS StoryMap configurations
Dates of service 2004-current

Reference 3: City of Sioux Falls, SD – GIS Services
Organization City of Sioux Falls, SD
Contact Lauri Sohl, GIS Manager, 605-367-8625, [email protected] Services provided Pro-West has provided GIS systems, application and data services:
• Enterprise geodatabase design and management
• Mobile One Call system development
• Backend automations/scripting
• SQL database management
• Business system integrations
• Custom application development
• Technical support
• Training
Pro-West & Associates provided data conversion and alignment services to update the sanitary, traffic and water distribution networks for the City of Sioux Falls, South Dakota. A utility geometric network was developed to support editing procedures throughout the City. Pro- West collaborated with the City to identify and resolve spatial discrepancies. Pro-West provided data management training upon completion of the re-alignment and attribute updates.

Upon completion of the utility GIS updates, Pro-West worked with the City to develop a GIS-based one-call ticket management system to facilitate Call Before You Dig requests and standardize state-mandated Positive Response requirements. This system has scaled to include additional utilities, such as fiber locating and has been extended to hyperlink to record drawings and photos of infrastructure to support field locating.

Pro-West implemented a mobile-based One Call system to run on iPads. The system was scaled to work with a modernized Esri platform and includes several end user and administrator configurations.

Dates of services 2006-current

Packet Page 295 of 1251Attachment 3 Page 39 of 120

8 \
8 GIS Services & Training
Project Work Plan
Pro-West has worked with many local governments to establish standards for data storage, maintenance, and data usage throughout their organizations. After careful review of the City’s RFQ it is clear the City is looking for that experience.

Pro-West suggests the following services to meet the City’s goals:
• Analysis of GIS data by City division or department o Identify current GIS data usage and needs o Identify Esri Licensing needs • Development of GIS data standards (for data organization) o Feature datasets, feature classes, and overall schema development • Centralizing GIS data throughout the organization o Enterprise geodatabase configuration o Assuring data storage in the enterprise geodatabase that provides the access to the correct City users, whether no access, view access, or full access to the GIS data.
• Identifying maintenance automations o Attribute Rules o Scheduled routines required for City’s workflows and data consumption needs • Training o How to administer the enterprise geodatabase o How specific division/departments can access their and other City data o How to maintain specific GIS data for a particular division/department When reviewing a City’s current GIS landscape it is important to identify each department’s use of GIS, to create a truly enterprise GIS environment based on the City’s needs. If this has already been carried out, it can be shared with Pro-West, or Pro-West can lead the process via online departmental meetings. Often, departments are storing, consuming and maintaining the same GIS data, so the same data is represented differently on GIS products from one department to the next.

Pro-West can review the City’s current GIS data and suggest where features can be combined.

We will work with the City to determine the appropriate authoritative source of the data, and charge that department with maintenance. However, the data can be stored successfully in one place (enterprise geodatabase) to be consumed by users as necessary.

Pro-West will discuss with the City the building of a Data Matrix. This matrix catalogs all existing GIS data and illustrates how the data’s schema could be standardized and stored moving forward within the enterprise geodatabase. It provides a historical reference regarding the data sources and changes made for standardization purposes, and documents feature classes that were combined. All attribute fields would be listed with field names, alias names, field type, and other fields values, along with a link if a particular field required a domain for a value list. These Packet Page 296 of 1251Attachment 3 Page 40 of 120

9 \
9 GIS Services & Training
domains would also be
listed in the matrix
document, and the
feature classes to which
each domain has been
associated would be clear
to GIS administrators.

Once the matrix is built
and approved, the feature
classes and domains can
be built. Then, existing GIS
data can be migrated to the
new data model for City-wide storage.

Pro-West will provide support for enterprise implementation and setup to ensure department users have the appropriate permissions to access GIS data (full, access, or restricted access).

Once the City-wide GIS feature classes are standardized and migrated, Pro-West will work with the City to update its Public Works data and train staff on GIS workflows and data usage.

Utility Data Updates
Pro-West updates many organizations’ utility datasets from as-builts (record drawings), GPS captured features, CAD files, or all of the above. Pro-West will work with the City to understand its utility data usage and schema requirements, then establish an update plan including:

1. Update Notifications & Scheduling – review the process used to schedule updates.

Timeframe for completion will depend on the quantity of updates; Pro-West and the City will agree on estimated completion dates.

2. Data access – updates to be completed within a connected version through a VPN/remote desktop connection, whether data can be edited through web services in ArcGIS Pro (remotely), or if making disconnected checkouts works best for the City.

3. Attributes – discuss utility feature class attributes, understand the values that need to be populated and where values should be coming from.

4. Source data – type of source data available for the updates, as-builts, GPS’d point data, CAD data, and/or marked scans of paper maps? Discuss transfer and access to source data.

5. Data Update Process – how the source data will be consumed and what will be the most accurate source. This will include the process for handling utility features that are being replaced vs abandoned, if the City needs records of old placements. Abandoned features will be reviewed with the City during data schema and standardization conversations.

6. Quality control – discuss the types of quality control the City is using and describe Pro- West quality control processes, including attribute checks and topology review.

7. Data Completion – discuss how utility updates will be incorporated into the Enterprise system (options will hinge on decisions made during data access discussions).

Figure 1: Data Matrix
Packet Page 297 of 1251Attachment 3 Page 41 of 120

10 \
10 GIS Services & Training
Pro-West will work with the City to create data maintenance standards, producing a repeatable process that can be used by the City when assistance is needed with ongoing maintenance.

IT Assistance
Pro-West actively works with its clients to optimize GIS workflows. This includes enterprise installation, configuration, and upgrading, developing and automating scheduled tasks to allow integration of GIS data with other 3rd party systems, and configuring Esri solutions for GIS data consumption whether inside or outside of the City’s organization.

Pro-West also has a development team if customizations are required to meet the City’s needs.

Pro-West prioritizes helping clients to leverage their existing software licensing first, using custom development only if other options are unavailable to solve the workflow issue.

Training
Pro-West has many years’ experience of training local governments to administer and maintain their GIS enterprise systems. This encompasses software installation/configuration, data storage and maintenance, and configuring the solutions that display the GIS data. Pro-West has specialized staff ready to assist the City in all facets of Esri’s enterprise platform.

Pro-West tailors training to client-specific needs and the client’s unique systems and data. Pro- West will work with the City to identify its training needs and the best way to administer training to deliver greatest benefit to the City. This includes documentation and recordings of virtual training sessions to be rewatched for future reference or to train others.

Hourly Rates
The table below reflects the hourly rates that apply to each category of the scope of services.

Pro-West does not share information on individual employee wages in documents that become public record, such as RFP response. We would be happy to discuss this with the City.

Scope of Work Employee Name Title Hourly Rate
Project Management Paul Rairamo Project Manager $135.19 Data Assessment and
Standardization
John Snyder GIS Specialist $113.18
Data Migration and Update Cole Sutton
Shelby Murphy
GIS Technician
GIS Technician
$84.89
$84.89
GIS Workflow and Maintenance
Training
John Snyder GIS Specialist $113.18
IT Workflow and Automation Brian Bjelland Application Developer $152.10 IT Training Brian Bjelland Application Developer $152.10 GIS Solutions Support and Training Alex Lange Solutions Engineer $123.79

Packet Page 298 of 1251Attachment 3 Page 42 of 120

11 \
11 GIS Services & Training

Appendix: Staff
Résumés

Packet Page 299 of 1251Attachment 3 Page 43 of 120

12 \
12 GIS Services & Training
Pro-West Team Viewer
In addition to reviewing team résumés below, we
recommend viewing the Pro-West Team Viewer.

Résumés

PAUL RAIRAMO
GIS Project Manager

Relevant experience

Mr. Rairamo combines his technical skills with leadership and project management expertise to deliver successful projects for Pro-West’s city clients.

His technical expertise includes GIS data services including the development, analysis and management geospatial data for Pro-West’s government clients for a range of purposes. He is skilled in building and updating geodatabases, managing and editing data and performing quality control to ensure compliance with specified data standards. He is an experienced user of a variety of products within the Esri enterprise platform including ArcGIS Desktop and ArcGIS Online.

Paul is experienced in using geospatial technology in a military capacity as a member of a Multiple Rocket Launch System Crew with the Wyoming Army National Guard, during which he was deployed to Afghanistan. In this capacity Paul carried out GPS route planning and tracking and used imagery to understand artillery dynamics and target feasibility.

8 YEARS
Packet Page 300 of 1251Attachment 3 Page 44 of 120

13 \
13 GIS Services & Training

PROFESSIONAL STRENGTHS EDUCATION

PROJECT EXPERIENCE

GIS PROJECT MANAGEMENT
Placer County, CA
Disaster Response ArcGIS Hub Site Deployment
Mr. Rairamo leads the Pro-West team responsible for deploying ArcGIS Hub sites to support the “Ready Placer” initiative, focused on responding to disaster events in the county including earthquakes, air quality, power outages and wildfires. Pro-West and the County are leveraging ArcGIS Hub to deliver a critical component of the initiative: sharing vital information on emergency preparation and response with citizens, providing a single location for preparation, monitoring, damage assessment and recovery efforts.

City of Waterloo, IA
Sidewalk Inspection and Reporting Solutions
Paul led the team responsible for replacing the City’s paper-based processes for sidewalk inspections and maintenance with a fully digital workflow. A complex set of processes and calculations, the transformed workflow relied heavily on GIS tools such as Survey123 and ArcGIS Portal. Staff can document inspections in the field, leveraging integrated datasets such as tax parcels and mailing addresses and automation to increase efficiency. Detailed information about the inspection is recorded via Survey123 with the ability to update as maintenance is conducted. Cost estimates for repairs are autogenerated using the city’s formula, and letters to property owners are created via an automated process.

Stark County, ND
Highway and Assessors Offices GIS solutions
This was a unique project that resulted in the creation of a county-wide GIS workgroup. The Assessor was looking to create a tax parcel viewer and the highway department needed a road closure, and bridge viewer solution. Paul was able to get both departments together to work on • GIS project management
• GIS data development
• Data analysis, management and editing
• Quality control/quality assurance
• Geodatabase design and development
• Esri ArcGIS software including ArcGIS for Desktop,
ArcGIS Online
• AutoCAD
• Cartography
• GPS equipment and data collection
• Imagery analysis

B.S. Geography
University of Wyoming,
Laramie, WY

B.S. Political Science
University of Wyoming,
Laramie, WY

Packet Page 301 of 1251Attachment 3 Page 45 of 120

14 \
14 GIS Services & Training
these solutions in conjunction. This will create a lasting workgroup that can explore advancing GIS at their county level. Paul coordinated the Pro-West team to successfully build the solutions.

West Dakota Water
End-to-End GIS Support
Mr. Rairamo currently manages the End-to-End GIS program (Pro-West’s program for organizations requiring in-house team augmentation) for West Dakota Water. West Dakota Water works on the Bakken Formation delivering water to energy companies. Paul has helped develop a program utilizing a conjunction of ArcGIS online and field mapping solutions. Paul continues to manage the support for West Dakota Water and develop their program for a changing industry landscape.

City of St. Cloud, Minnesota
Economic Development Activity Dashboard
Mr. Rairamo managed a project for the City of St. Cloud, MN that monitors ongoing permitted development projects within city limits. This project required numerous changes to the application. The client had various stakeholders that required different inputs. Paul worked closely with the city as well as Pro-West Solution Engineers to achieve the desired result. The final dashboard will help the City’s Planning & Zoning Department to monitor ongoing projects.

Crow Wing County, Minnesota
ArcGIS Hub Site with Open Data
Mr. Rairamo was project manager for the Crow Wing County Hub and Open Data Site project.

This project provides the county’s citizens with up-to-date GIS mapping applications, as well as downloadable datum. Paul kept the project on budget. He oversaw developing the project, managing tile layers for MrSID data, and ensured the timeline was met. All of this was done while keeping county employees working with Pro-West personnel to achieve the desired solution.

Crow Wing County, Minnesota
Snowplow Data Download Process Updates
Paul oversaw a project in which Pro-West updated the existing snowplow data download process at Crow Wing County, MN. This was due to the PreCise API change from using Soap based API to a Rest based API. During this project Paul coordinated with the county to get necessary information transferred. He helped lead the Pro-West team to successfully complete the updates swiftly. This was important so the script could be tested during spring snowfalls in preparation for implementation the following winter.

City of Fargo, ND
Lot Dimension Extractor
Mr. Rairamo led the Lot Dimension Extractor project for the City of Fargo, ND. This project involved writing a script that extracted the exterior lines of polygons in a parcel feature layer.

The script can be modified to order the measurements in different ways. Paul ensured the Packet Page 302 of 1251Attachment 3 Page 46 of 120

15 \
15 GIS Services & Training
project was delivered effectively and efficiently. In addition to serving as Project Manager, Paul also provided support with checking code.

City of New Ulm, MN
Database Migration
Paul was the project manager for a Database Migration that Pro-West performed for the City of New Ulm, MN. He ensured that details such as remote login information, server locations, and work groups were collected and passed to Pro-West staff. The client called for a high degree of coordination and communication. Paul ensured that the needs of the client were met and the client was kept up-to-date.

City of Rockford, IL
ArcGIS Server and Enterprise Geodatabase Installation
Mr. Rairamo worked with the City of Rockford to install ArcGIS Server and Enterprise Geodatabase. This project was implemented on a trial license from Esri. Paul had to coordinate with an Esri representative, so the trial license was active during the time of the installation.

The city was in process of switching to new Esri technology. Paul helped manage a team that worked closely with the Rockford staff while performing the installation. He ensured that effective knowledge transfer took place between the Pro-Wets team and the City during the installation so that City staff were confident in using their new system.

Todd County, MN
Trimin Landshark Integrated Viewer
Paul organized this project in coordination with Sibley County and TriMin. TriMin hosts the CAMA legal services for Sibley county via its Landshark application. Paul coordinated the database connection with TriMin, and assisted the county in setting up the viewer application on ArcGIS Online. This project was unique because the client wanted to build the viewer application with help from the Pro-West solutions team. Paul organized this accommodation, and the client was able to learn in the process.

Greylock Energy
News Feed and Dashboard
This client had a unique requirement, needing to create a newsfeed-style read-out for their project managers. These news articles related to their data needed to be spatial. Paul worked with Greylock and the Pro-West solutions team to create this solution. To accomplish this, Survey123 was used as the method of delivery paired with an internal Site (Portal) to display the information. This solution is updated daily by Greylock Energy’s GIS manager.

Polk County, MN
Hub Site and Open Data
Paul Rairamo was the project manager for the creation of a Hub Site to support Polk County GIS public outreach efforts. He managed the Pro-West solutions team to create the design and functionality of the site. The Polk County GIS director worked closely with the Pro-West team to set up applications and configure existing applications to work with the new Hub. The second Packet Page 303 of 1251Attachment 3 Page 47 of 120

16 \
16 GIS Services & Training
part of this project was creating an open data platform to provide the citizens of Polk County with the ability to download public data including imagery, contour lines, and parcel data.

PARCEL DATA DEVELOPMENT
Canadian County, OK
Parcel Fabric Implementation
Paul is responsible for data development in the Parcel Fabric environment for Canadian County, OK, whose goal is to modernize its GIS and make the most of the latest technology while developing its parcel data from the record documents. With the County opting to update its entire existing parcel data by also including a PLSS update, this is large scale data development project and the first implementation of the Parcel Fabric in the State of Oklahoma. Due to the scale of the project, Paul adheres to stringent goals for delivery, executing quality control procedures and communicating with the rest of the project team using tools such as ArcGIS Online applications such as Pre-Research Tracker, Discrepancy Tracker, and the overall Dashboard that tracks the project’s progress by section, township, and parcel counts.

Jackson County, WI
Parcel Fabric Implementation
Paul took over the development of the parcel data for Jackson County near the end of development. He ensured that the last fabric data for the project complete and quality checked. He managed calls with the county to ensure that the legal descriptions matched the 100-year-old plat books. When errors were found he corrected them to ensure the delivered product met the standard.

Packet Page 304 of 1251Attachment 3 Page 48 of 120

17 \
17 GIS Services & Training

COLE SUTTON

GIS TECHNICIAN

Relevant Experience

Mr. Sutton is a highly skilled GIS Technician, working with Cities’ and Counties’ geospatial data every day. He is experienced in GIS data collection, development and analysis, spatial modeling, and imagery analysis. He designs, develops and administers databases and is proficient in GIS customization/Python scripting. He is experienced in geospatial data development, analysis and quality control for utilities and natural resources and has special expertise in the area of NG9-1-1 addressing data development and improvement to ensure compliance with federal and state- mandated NG9-1-1 standards.

Cole is skilled in the Esri ArcGIS platform including ArcGIS for Desktop and ArcGIS Online. He is also experienced in working with AutoCAD.

PROFESSIONAL STRENGTHS EDUCATION

PROJECT EXPERIENCE

UTILITY DATA DEVELOPMENT
City of Lakeville, MN – City-Wide Utility GIS Data Development Mr. Sutton was responsible for developing water, sanitary and storm utility data in GIS format based on as-builts. The project involved creating standards for data development which were used throughout the development. Realignment was performed on almost all existing utility data. Discrepancies were flagged for review according to the standardized process developed for the project, and additional point features added with all necessary information.

NG9-1-1 DATA ANALYSIS & DEVELOPMENT
Crow Wing County, Yellow Medicine County, Fillmore County, Chippewa County, Big Stone County, Wilkin County, Becker County, Mille Lacs County, Grant County, and Clay County, MN – NG9-1-1 GIS Data Services
4 YEARS
• GIS data development
• GIS analysis
• Quality control
• Database design and development
• Georeferencing
• Esri ArcGIS software

M.S. GIS
Saint Mary’s University of
Minnesota, Winona, MN

B.F.A. Graphic Design
Minneapolis College of Art &
Design, Minneapolis, MN
Packet Page 305 of 1251Attachment 3 Page 49 of 120

18 \
18 GIS Services & Training
Mr Sutton is one of Pro-West’s most experienced team members in the area of addressing. His most recent projects have focused on ensuring Counties’ address data is compliant with federal and state-mandated standards in preparation for the introduction of an IP-enabled next generation 911 system. His responsibilities include reviewing discrepancies between the MSAG and GIS data and identifying problems that exist in the data; making corrections to GIS layers and their attributes (road centerlines, address points, ESN polygons, community polygons); and, identifying and flagging corrections to the MSAG that are needed.

NATURAL RESOURCES DATA DEVELOPMENT
State of Montana Department of Natural Resources and Conservation – Sage Grouse Habitat Disturbance Geographic Data Creation
Mr. Sutton plays a key role on the Pro-West team responsible for creating an accurate and current inventory of all sage grouse habitat disturbance areas. His individual responsibilities include identifying areas of land disturbance on aerial imagery, digitizing disturbances into polygons, assigning attributes to disturbance polygons according to the given schema, and using topology to ensure data integrity.

Packet Page 306 of 1251Attachment 3 Page 50 of 120

19 \
19 GIS Services & Training

Ms. Murphy is responsible for developing, managing and enhancing geospatial data for government agencies using the Esri ArcGIS platform. She is experienced in parcel development in the Parcel Fabric environment including ArcGIS Pro. She designs, builds and manages geodatabases, develops GIS data, performs data analysis and is responsible for quality control to ensure accurate and compliant data. She is proficient in aggregating data from multiple sources and formats to create authoritative and accurate information. Shelby is also experienced in GPS data collection and integration of GPS datasets into GIS.

PROFESSIONAL STRENGTHS EDUCATION

PUBLICATIONS
Co-Author, A Field Guide to the Whitsunday Islands. Global Treks and Adventures, LLC. Based on field work conducted on the physical geography of the islands including GPS point collection for hiking trails and research on the Whitsundays’ physical features and natural resources.

PROJECT EXPERIENCE

UTILITY DATA DEVELOPMENT & MANAGEMENT
City of Lakeville, MN – City-Wide Utility GIS Data Development Ms. Murphy is responsible for verifying water, storm and sewer utility attributes of GIS data with information on as-builts, and editing utility attributes where necessary, using data standards developed for the project.

SHELBY MURPHY

GIS TECHNICIAN
• GIS data development
• Data analysis, management and editing
• Quality control/quality assurance
• Geodatabase design and development
• Esri ArcGIS 10.x software
• GIS tools: Model Builder, Python, SQL,
geocoding, network analysis
• GPS data collection
• Map production

B.S. Environmental Geography
University of Wisconsin, Eau Claire
Graduate Certificate in GIS
University of Denver
Esri Training Certificates including:
• Geodatabase Management and
Design
• Geodatabase Topology
• Parcel Editing
• Geodatabase Domains & Subtypes
Relevant Experience
3 YEARS
Packet Page 307 of 1251Attachment 3 Page 51 of 120

20 \
20 GIS Services & Training

Madison Metropolitan Sewerage District (MMSD) – Esri GIS Implementation Services Shelby provides services for the data migration component of this project to implement an Esri-based enterprise GIS throughout MMSD. She is responsible for cleaning up and reorganizing sanitary utility data according to desired output, designing and building a geodatabase, and migrating data to the new geodatabase.

PARCEL DATA DEVELOPMENT
Canadian County, OK – Parcel Fabric Data Development
Shelby is responsible for data development in the Parcel Fabric environment for Canadian County, OK, whose goal is to modernize its GIS and make the most of the latest technology while developing its parcel data from the record documents. With the County opting to update its entire existing parcel data by also including a PLSS update, this is large scale data development project and the first implementation of the Parcel Fabric in the State of Oklahoma. Due to the scale of the project, Shelby adheres to stringent goals for delivery, executing quality control procedures and communicating with the rest of the project team using tools such as ArcGIS Online applications such as Pre-Research Tracker, Discrepancy Tracker, and the overall Dashboard that tracks the project’s progress by section, township, and parcel counts.

NATURAL RESOURCES DATA DEVELOPMENT
State of Montana Department of Natural Resources and Conservation – Sage Grouse Habitat Disturbance Geographic Data Creation
Ms. Murphy plays a key role on the Pro-West team responsible for creating an accurate and current inventory of all sage grouse habitat disturbance areas. Her individual responsibilities include identifying areas of land disturbance on aerial imagery, digitizing disturbances into polygons, assigning attributes to disturbance polygons according to the given schema, and using topology to ensure data integrity.

Packet Page 308 of 1251Attachment 3 Page 52 of 120

21 \
21 GIS Services & Training

BRIAN BJELLAND

SENIOR APPLICATION DEVELOPER

Mr. Bjelland primarily performs enterprise GIS implementations, integrates GIS with third- party business systems, designs and develops web applications, creates automated processes and provides on-demand technical support and issue resolution to many cities and counties.

He serves as a technical project lead and facilitates discussions on technical requirements to ensure clients receive the right system infrastructure for their needs.

Brian also delivers administrator and user training and documentation and excels at breaking down complex technical concepts into accessible terms. He has expert knowledge across the Esri enterprise platform and is a core member of many local government teams.

• Enterprise GIS deployment, configuration and support
• System integration and automation
• Application design and development
• Technical support
• GIS infrastructure evaluation and recommendations
• Client systems training

PROFESSIONAL STRENGTHS

APPLICATION DEVELOPMENT EXPERTISE

EDUCATION
B.S. Computer Science
Bemidji State University
Bemidji, MN
Certified GIS Professional
(GISP)
15 YEARS
Relevant experience:

WEB
ArcGIS Server APIs PHP
Esri JavaScript API 3.x, 4.x Flex
ASP.NET MVC Silverlight

WCF XML
HTML5/CSS3 Dojo/jQuery
ArcObjects JavaScript
Visual C++ AJAX
Visual Basic XSL

DESKTOP
ArcObjects Python
ArcGIS Desktop Add-Ins Visual Studio.NET

DATABASES
Microsoft SQL Server Microsoft Access
MySQL
MOBILE
ArcPad Application Builder Visual Studio.NET
ArcGIS Server Mobile

ESRI STACK
ArcGIS Enterprise Portal for ArcGIS ArcGIS Server Web Adaptors Enterprise GDB GeoEvent Role Security Configurations
Active Directory Integration ArcGIS Pro Add-Ins
ArcGIS Mobile SDK ArcGIS Data Store
ArcGIS Online Configuration/branding Feature Layers Web maps Operations Dashboard Survey123 Web AppBuilder

Packet Page 309 of 1251Attachment 3 Page 53 of 120

22 \
22 GIS Services & Training

PROJECT EXPERIENCE

SYSTEM INTEGRATION & AUTOMATION
Brian has created and deployed hundreds of Extract-Transform-Load (ETL) processes that extract, manipulate and load spatial and non-spatial data from one business system to another. Expertise includes:
• Working with SQL, text files, csv files and other data sources to generate and automate data transfer processes
• Creating/maintaining SQL views for data extraction or live integration into other business systems
• API development to support system integration
• Using existing third-party APIs to support integration • Integration best practice assessments, documentation and training • Collaboration with third party vendors and clients regarding best practices and protocol for system integrations, taking into account existing tasks, IT needs, GIS needs and end user needs
• Facilitating discussions on technical requirements with IT, GIS and non-technical stakeholders

ENTERPRISE GIS IMPLEMENTATION & SUPPORT
Mr. Bjelland has performed hundreds of enterprise GIS projects. He is well versed in all components of enterprise implementations and modifications from evaluating client needs and producing system architecture design documents to providing training to ensure clients can effectively administer their enterprise deployment. Mr. Bjelland provides:
• Deployment, configuration, maintenance and support for ArcGIS Server, Web Adaptor, Portal and Data Store
• New enterprise implementations and upgrades due to new Esri version releases or a change in licensing levels
• Scaling or modifying existing enterprise deployments
• Enterprise system architecture assessments and production of design documents • Implementing appropriate security protocols
• Training clients on their enterprise deployments and upgrades • Enterprise geodatabase implementation/maintenance including versioning & compress support
• Esri License Manager implementation, maintenance and support • Enterprise best practices, maintenance and support for clients with Esri Enterprise Agreements
Enterprise Implementation Project Examples
• Chisago County, MN
o Setup of a base ArcGIS Enterprise deployment (ArcGIS Server, Portal for ArcGIS, Data Store, Web Adaptor (IIS)) on on-premise infrastructure o Responsibilities:

Packet Page 310 of 1251Attachment 3 Page 54 of 120

23 \
23 GIS Services & Training
 Installation and configuration of a base ArcGIS Enterprise deployment (ArcGIS Server, Portal for ArcGIS, Data Store, Web Adaptor (IIS))  Develop documentation including:
• Software installed on each server
• Installation locations
• All relevant URLs and credential information
 Training with county staff on the administration of the base ArcGIS Enterprise deployment software
• Village of Webster Groves, MO
o Setup of the following software (ArcGIS Server, Portal for ArcGIS, Web Adaptor (IIS)) on on-premise infrastructure and migration of existing GIS content from their existing setup to the new setup
o Responsibilities:
 Installation and configuration of the following software (ArcGIS Server, Portal for ArcGIS, Web Adaptor (IIS))
 Develop documentation including:
• Software installed on each server
• Installation locations
• All relevant URLs and credential information
 Migrate existing ArcGIS Server services from their existing setup to their new setup
 Training with county staff on the administration of the base ArcGIS Enterprise deployment software
• Sherburne County, MN
o Description: Setup of a base ArcGIS Enterprise deployment (ArcGIS Server, Portal for ArcGIS, Data Store, Web Adaptor (IIS)) on on-premise infrastructure o Responsibilities:
 Installation and configuration of a base ArcGIS Enterprise deployment (ArcGIS Server, Portal for ArcGIS, Data Store, Web Adaptor (IIS))  Develop documentation including:
• Software installed on each server
• Installation locations
• All relevant URLs and credential information
 Training with county staff on administration of the base ArcGIS Enterprise deployment software
• Mille Lacs County, MN
o Description: Setup of a base ArcGIS Enterprise deployment (ArcGIS Server, Portal for ArcGIS, Data Store, Web Adaptor (IIS)) on on-premise infrastructure o Responsibilities:
 Installation and configuration of a base ArcGIS Enterprise deployment (ArcGIS Server, Portal for ArcGIS, Data Store, Web Adaptor (IIS))  Develop documentation including:

Packet Page 311 of 1251Attachment 3 Page 55 of 120

24 \
24 GIS Services & Training
• Software installed on each server
• Installation locations
• All relevant URLs and credential information
 Trained county staff on administration of the base ArcGIS Enterprise deployment software

APPLICATION DEVELOPMENT
Brian utilizes modern development technologies, such as MVC.NET, Dojo, jQuery, and Bootstrap to create intuitive web applications that streamline user workflows. He understands the separation of client and server-side application components, and relational databases, and performs full-stack development. He primarily works with Microsoft SQL Server, using technologies such as Entity Framework, but also interacts with other databases regularly to integrate with other third-party systems. He participates in all phases of software development, from design to delivery and training.

TECHNICAL SUPPORT
Brian provides technical support for Pro-West clients including on-demand support for Esri Enterprise, geodatabases, Esri licensing, security, SQL, Python, system integrations, desktop, Collector and Web AppBuilder applications (developer, Portal or ArcGIS Online). He also provides system integration training and documentation. He excels at breaking down technology concepts into accessible terms.

Packet Page 312 of 1251Attachment 3 Page 56 of 120

25 \
25 GIS Services & Training

ROYAL PADDOCK

SENIOR APPLICATION DEVELOPER
Relevant Experience:

Mr. Paddock’s primary focus is website and application design, development, testing and deployment, enterprise GIS installation and management and system integration. His experience includes developing several asset management systems. Mr. Paddock has performed dozens of enterprise GIS implementations for local government clients and is responsible for ongoing maintenance for many more. He is also experienced in creating reports for multiple web interfaces.

He has worked on Pro-West’s largest and most complex application development efforts and regularly proposes solutions to complex challenges.

PROFESSIONAL STRENGTHS EDUCATION

APPLICATION DEVELOPMENT EXPERTISE
• Web application development
• Enterprise GIS implementation and management
• Application support and maintenance
• Process automation
• Report design
• Esri software application design and development
• Data integration
• REST API development
• Technical support
• Team augmentation

WEB
ArcGIS Server APIs PHP HTML5/CSS3
jQuery SSRS XSL
ASP.NET MVC XML Visual C#
WCF Dojo JavaScript
AJAX
n his role as a Programmer at Pro West Mr

DESKTOP
ArcObjects Python
Visual Studio.NET

DATABASES
Microsoft SQL Server Microsoft Access
n his role as a Programmer at Pro-West,

B.S. Computer Science
Bemidji State University
Bemidji, MN

ESRI STACK
ArcGIS Enterprise Portal for ArcGIS ArcGIS Server Web Adaptors Security Configurations
Enterprise GDB
ArcGIS Online Configuration/branding Feature Layers Web maps Web AppBuilder

14 YEARS
Packet Page 313 of 1251Attachment 3 Page 57 of 120

26 \
26 GIS Services & Training

PROJECT EXPERIENCE

ENTERPRISE GIS IMPLEMENTATION
City of Rockford, IL
• 30 Day trial Enterprise deployment
• Installation of ArcGIS Server, Enterprise Database server and Portal • Knowledge transfer and training

Grant County, MN
• ArcGIS Portal installation and configuration

Big Stone County, MN
• Enterprise deployment and server migration
• Installation of Portal and ArcGIS server
• Migration of existing ArcGIS server services to new machines and migration of the County’s data from Workgroup to Enterprise geodatabases

White Earth Nation
• Enterprise upgrade and configuration

Sibley County MN
• ArcGIS Server and Workgroup installation

APPLICATION DEVELOPMENT
Land Management
• Developer for the custom Land Information Portal for St. Louis County, MN. The system accessed data from many different internal sources including ownership and tax information from multiple department systems and a SQL Server database for system and user configuration. It also provided a Flex-based mapping interface and had extensive administration tools that allowed county staff to configure the look and feel of data and queries available to users of the application.
• Serves as lead ongoing developer for Pro-West’s proprietary LINK product, continually adding functionality and deploying to multiple government agencies.

LINK is an enterprise system that allows internal, public, and subscription users to access many layers of information, including tax records, assessment data, forestry, scanned documents, and GIS data. The administration tools provide a high degree of configurability to many application features and interfaces. A built- in update and license manager component streamlines the update process and allows per-client configuration without maintaining parallel versions of the base application.
• Developed multiple Flex web-based applications. The application suite included a Daycare Locater, Floorplan Viewer, and a Tax Forfeited property viewer. Owner Packet Page 314 of 1251Attachment 3 Page 58 of 120

27 \
27 GIS Services & Training
information, E911 data, tax data, and other information retrieved from SQL Server databases were integrated into the system along with digital images of properties. The application also included several SSRS reports.

Data Management
• Developed a desktop data management application, ATS R5 File Checker. The application provides a means of verifying data formatting and consistency. The application processes chemistry data files to ensure they conform to a standard file format.
• Developed python scripts to standardize and merge utility data from multiple municipalities into a single data set.

Disaster Recovery
Developed a near-real-time mobile and web-based soil and sediment sample data acquisition and reporting system accessed 24/7 by multiple entities and hundreds of personnel across the nation. The system was deployed in response to three different incidents in support of the investigation of contaminated sediments in river systems.

Forestry
Royal developed a web-based map publisher solution comprised of an MVC.NET front end, backed by a SQL Server database and ArcGIS Server to provide high quality, semi- customized maps for staff with minimal GIS experience. He also contributed to developing a process for converting a print request to a map image and then sending the document to the selected printer.

Transportation/E911
Developed and tested the IROW web application for the Illinois Tollway. The IROW application provides internal and external stakeholders with a common interface and workflow that facilitates the process of land acquisition. The application utilizes several technologies including a SQL Server backbone, ArcGIS Server, and a JavaScript-based front end.

Permit Tracking
Mr. Paddock played a critical role in the development of a Permit Tracking Application for Cook County, IL, a solution that replaced the previous manual process for managing permit issuance. Royal created new Elevator, Rental Dwelling and Zoning Certificate modules for the application, developed a web page to allow the public to apply for zoning certificates, and a public page for managing rental dwellings. He also produced requested enhancements and delivered technical support.

ARCGIS WEB APPBUILDER WIDGET DEVELOPMENT
• Developed a Mailing Label widget for the ArcGIS Web AppBuilder platform. The Packet Page 315 of 1251Attachment 3 Page 59 of 120

28 \
28 GIS Services & Training
widget allows the user to generate pdf mailing labels in addition to csv formatted exports.
• Developed a Lot Batch Attribute Editor widget for the ArcGIS Web Appbuilder platform. This was a custom widget designed to allow the user select and edit the attributes of multiple lot features.
• Developed an Atlas widget for the ArcGIS Web AppBuilder platform. The widget allows the user to generate a pdf atlas document for a selected township • Developed a Road Certification widget for the ArcGIS Web AppBuilder platform.

The widget allows the user to generate pdf road certification document for a township.

REPORT DESIGN & DEVELOPMENT
• Designs reports for user interfaces for MVC web applications. The applications utilize cover pages, filtered lists of data, and embedded tables and lists. • Creates custom reports and multi-dataset reports. The reports utilize dynamic data sets to create xlsx (MS Excel), pdf (Adobe) and doc (MS Word). Custom reports include charts for land ownership, permitting, client specific information, and replicated specifications for templates.

Packet Page 316 of 1251Attachment 3 Page 60 of 120

29 \
29 GIS Services & Training

ALEX LANGE

GIS SOLUTIONS ENGINEER

Relevant Experience:

Mr. Lange serves as a GIS Solutions Architect at Pro-West, where he helps clients evaluate, configure, and deploy solutions through the ArcGIS platform. He has prior experience leading the GIS function at Renville County, MN.

Alex has extensive experience across the full breadth of GIS including data editing and administration for tax parcels and Next Generation 911, strategic planning and implementation, and solution configuration.

He is experienced in using numerous products within the ArcGIS platform including ArcGIS Online, Hub, Pro and Enterprise as well as specific solutions including Survey123, Collector and Explorer.

Alex has proven expertise in developing and implementing new programs and creative solutions based on location technology. He is a proficient collaborator, a skilled communicator, and cares about finding the right solutions to organizational challenges using GIS.

PROFESSIONAL STRENGTHS EDUCATION

PROJECT EXPERIENCE

GIS SOLUTION CONFIGURATION (ARCGIS ONLINE & ARCGIS ENTERPRISE) Renville County, MN – Draining Management Solution
Alex developed and implemented a program to integrate GIS into a local government Drainage Department to help streamline repair tracking, data collection and updates, perform • Web GIS solution deployment and configuration
• Esri ArcGIS platform – including ArcGIS Online, ArcGIS Hub, ArcGIS Pro, ArcGIS Enterprise
• ArcGIS Hub configuration and maintenance
• ArcGIS Online solution configuration
• Field and mobile solutions
• NG911 data administration
• Tax parcel data maintenance
• Geodatabase management
• GIS program planning and execution
• Team augmentation
• Client training

B.S. Computer Science
(Minor: GIS)
St. Cloud State University, St.

Cloud, MN

4 YEARS
Packet Page 317 of 1251Attachment 3 Page 61 of 120

30 \
30 GIS Services & Training
inspections and carry out benefit redetermination tasks. In collaboration with the Drainage Department, he identified, configured and deployed a set of ArcGIS-based solutions that together would accomplish the required tasks and meet departmental goals. The resulting Drainage Management System included:
• Implementation of ArcGIS Collector for improvement and construction lines • Implementation of Survey123 form for drainage system inspections • QuickCapture project implementation for private repair tracking • Deployment of Ditch Benefits Lookup web application to view benefit information from Drainage and Auditor/Treasurer Departments and tax system via integration and an automated publishing script
• Deployment of Ditch Benefits Processing web application to view acres and land class information
o Parcel data was incorporated and used to view benefit information for drainage • Deployment of Drainage System Editor web application to edit drainage system and related content
• Deployment of Repair Maintenance Tracker web application to provide repair status updates
o Integrated with AppXtender document management system to access and download reports

West Dakota Water – Asset Management & Maintenance Solutions Configured a set of three ArcGIS Online-based solutions to deliver better understanding of the locations, condition and status of West Dakota Water’s assets. Using Web AppBuilder, Survey123 and ArcGIS Online, Alex created solutions for asset management, valve inspection and location analysis, transforming critical workflows and optimizing organizational data, allowing information to be updated in the field, inspections and maintenance to be conducted more efficiently, reports to be generated and information to be more easily understood and shared.

Big Stone County, MN – Road Sign Management Center
Configured and deployed ArcGIS Online and Enterprise Sites to transform and modernize the County’s road sign management process. The resulting Road Sign Management Center brings together maps and apps to manage field inventory, perform inspections, manage and look up data, and monitor key performance indicators in a single location, bringing wide-ranging benefits for staff and the organization.

Packet Page 318 of 1251Attachment 3 Page 62 of 120

31 \
31 GIS Services & Training

JOHN SNYDER

GIS SPECIALIST

Relevant Experience:

Mr. Snyder has over ten years’ experience in the GIS industry, with a focus on government, natural resources, utilities and transportation.

John is highly experienced in working with geospatial data and producing maps and reports. He collects, analyzes and manages GIS data, works with field data, performs aerial imagery interpretation and collaborates with clients to define their mapping needs.

He is a proficient user of the Esri enterprise platform including ArcGIS Pro and is also experienced in GPS data collection and analysis. He regularly provides GIS and GPS training to client teams.

PROFESSIONAL STRENGTHS EDUCATION

PROJECT EXPERIENCE

ARCGIS ONLINE SOLUTION CONFIGURATION
City of St Cloud, MN
ArcGIS Online Solution Configuration & Maintenance
Mr. Snyder designed and configured utility collection solutions, mobile Pavement Condition Solution, and the City’s Economic Development Dashboard, and is responsible for maintaining

City of Breckenridge, MN
ArcGIS Online Solution Configuration
• ArcGIS Online solution configuration
• ArcGIS Hub configuration
• Integration of third-party systems with GIS
• Technical support
• Map production
• Esri ArcGIS 10.x platform
• Geospatial data development, analysis and maintenance • Geodatabase design
• Field data collection and management
• GPS technology and techniques
• Client training

B.S. Geography, emphasis GIS
Minor: Geology
Bemidji State University,
Bemidji, MN

13 YEARS
Packet Page 319 of 1251Attachment 3 Page 63 of 120

32 \
32 GIS Services & Training
Mr. Snyder designed and configured an Electrical Utility Field Inventory solution and a Corner Lookup solution.

Steele County, MN
ArcGIS Hub Site Development
Mr. Snyder designed and configured the County’s ArcGIS Hub site including a number of ArcGIS Online solutions: Tax Parcel Viewer, Recorded Documents Viewer, Property Sales Dashboard, Corner Viewer and Public Notification.

St Louis County, MN
ArcGIS Hub & GIS Solution Configuration
Mr. Snyder designed and configured an ArcGIS Hub site including a number of solutions: Value Analysis Dashboard, Residential Property Value, Residential Comp Finder and Tax Parcel Viewer.

Renville County, MN
ArcGIS Online Solution Configuration
Mr. Snyder designed and configured an Elections Hub based on ArcGIS Hub as well as an Elected Representative solution.

Pope County, MN
ArcGIS Online Solution Configuration
Mr. Snyder designed and configured a Ditch Benefits app and Elections app.

LOCAL GOVERNMENT DATA ANALYSIS & MAPPING
City of St Cloud
Pavement PCI Mapping
Mr. Snyder prepares data for City road surface data collection and reviews and analyzes roadway classification. He also works with the City to prepare maps and other visual products for City meetings.

Utility Data Edits
Mr. Snyder review as-builts for new data, compiles data and updates datasets for use in mapping applications.

Minnesota Department of Transportation (MnDOT)
GIS Bicycle Map Updates
Mr. Snyder supported MnDOT with GIS services that are critical to the collection of bicycle information in 22 Minnesota Counties. He maintained the calling log and survey data and received and analyzed data to be incorporated into the statewide database.

GIS DATA MIGRATION
Madison Metropolitan Sewerage District
CAD Data Conversion
Packet Page 320 of 1251Attachment 3 Page 64 of 120

33 \
33 GIS Services & Training
Converting data from facility CAD plans, adding what is missing and adjusting where needed.

Interpreted and transfer attributes.

Wilkin County, MN
Data Migration Survey
Mr. Snyder is responsible for taking an inventory of data and map services of the County’s server. He reviews what is current and what needs to be transferred, and performs necessary preparation for transferring existing data and services to an enterprise environment.

GIS APPLICATION & INFRASTRUCTURE SUPPORT
Illinois Tollway
Lane Closure Application Testing
This project involved testing an application used to track lane closures on the Illinois Tollway. It involved bug testing and working though standard processes to ensure that they work correctly.

Client Server Updates
John is responsible for routinely performing day-to-day updates on over 20 Pro-West local government client servers.

Packet Page 321 of 1251Attachment 3 Page 65 of 120

GIS SERVICES AND TRAINING
City of Fairfield, CA

Date Due: January 28, 2022
Contact: Mike Wiley | Director
1001 Boulders Parkway, Suite 300, Richmond, VA 23225
917.848.6504 phone | 804.560.1016 fax | [email protected] www.timmonsgis.com
Packet Page 322 of 1251Attachment 3 Page 66 of 120

GIS | STRATEGIC PLANNING | DATA MANAGEMENT | WEB AND MOBILE DEVELOPMENT | ASSET MANAGEMENT | STAFF AUGMENTATION 1001 Boulders Parkway
Suite 300
Richmond, VA 23225
P 804.200.6500
F 804.560.1016
www.timmonsgis.com
January 28, 2022
Mr. Jonathan Luong
City of Fairfield, Community Development
1000 Websters St.

Second Floor Fairfield, CA 94533
RE: GIS Services and Training
Dear Mr. Luong:

Timmons Group has more than 30 years of geospatial based technology solutions consulting experience for industry and government.

We Provide:
• A nationally recognized firm with more than 120 GIS/IT dedicated staff • Past, successful, project experience in Northern California and the Bay Area • National qualifications in GIS Strategic Planning and Implementation • Proven ability to develop and maintain long-term relationships with our clients • An award-winning Esri GIS Gold Business Partner for 30 years • State and Local and government GIS subject matter experts • Extensive experience with Esri ArcGIS Server / Portal / ArcGIS Online / Mobile • Extensive experience with Esri Production Mapping
• Expertise, including data collection, analysis, App Development, and Esri configurations. • Experts in Community Development
• Experts in Enterprise Asset Management
We successfully completed more than 1,500 GIS projects for clients throughout the US and Canada. We develop GIS data to support State and Local government business operations in E 9-1-1, government planning, parcel mapping and management, economic development, transportation system management, political redistricting, school redistricting, and utilities management.

Our corporate emphasis on client satisfaction is demonstrated through 60+ years of business. No two clients are exactly alike, and we work to create unique and engaging experiences for each one.

We appreciate your consideration and hope to work with you on this important project. If you have any questions, please contact me at 917.848.6504 or at [email protected].

Sincerely,

Mike Wiley | Director
Firm’s Lead in Completing Work
Packet Page 323 of 1251Attachment 3 Page 67 of 120

GIS Services and Training
City of Fairfield

TOC

TABLE OF CONTENTS
Company Profile .............................................................................................................................. 1 Services and Training ...................................................................................................................... 1 Locality ............................................................................................................................................ 4 References ...................................................................................................................................... 4 Resumes .......................................................................................................................................... 5 Brochures or Other Pertinent Information ..................................................................................... 5 Hourly Rates .................................................................................................................................... 5 Non-Disclosure Agreement, Exceptions, Subcontractors ............................................................... 5 Appendix A: Project Descriptions ................................................................................................... 6 Caltrans | Enterprise GIS Implementation and Data Management ........................................... 6 Forest Grove | Enterprise GIS Planning, Migration, Consulting, and ArcGIS Online Portal ....... 7 Lompoc | GIS Data Conversion ................................................................................................... 7 Albany .......................................................................................................................................... 9 St. Johns County Utility | GIS, Technology, and Graphic Design Services ................................ 10 Appendix B: Resumes.................................................................................................................... 13 Appendix C: Project Management Methodology ......................................................................... 21 Management Approach ............................................................................................................ 21 Project Communication Tools ................................................................................................... 22 Project Communications Processes .......................................................................................... 22

Packet Page 324 of 1251Attachment 3 Page 68 of 120

GIS Services and Training
City of Fairfield

Page | 1

COMPANY PROFILE
Timmons Group is a well-established professional consulting firm with more than 800 employees, providing information technology and geospatial consulting services to public and private clients throughout the US and Canada since 1989. Our team develops across multiple technologies and platforms, including open-source, proprietary, and hybrid solutions.

From our web developers to our database managers, systems engineers, consultants, and Project Managers, our award-winning team provides the unique ability to understand your vision and offer a solution tailored to your mission-critical business requirements.

We are technology experts who care deeply about the mission of local governments and providing solutions that enhance their ability to better serve their constituents. Our Technology group has the experience and capability to provide a wide range of services.

All staff performing work on this project are Permanent Staff.

SERVICES AND TRAINING
For almost 30 years, Timmons Group has developed geospatial-based technology solutions for government and industry. Our staff includes a broad range of subject-matter experts across all areas of GIS technologies. From our business systems subject matter experts (SMEs) to our GIS technicians, database managers, programmers, systems engineers, consultants, and project managers, our award-winning team can understand your vision and tailor a solution to your mission-critical business requirements.

We successfully completed thousands of GIS projects delivering integrated business solutions to our clients. One of the valuable assets we provide our clients is our understanding and insight into the future of GIS. Our depth of GIS staff (120+) and SMEs in many government services disciplines enable us to see emerging trends within the geospatial world that can be applied to these disciplines.

Timmons Group has built our highly successful GIS business by focusing on the most important aspect of our projects – your success. We ensure your success by developing trusted partner relationships with our clients. Our clients value our breadth of industry knowledge and the depth of GIS resources we can bring to bear on our projects. We offer significant experience integrating GIS with complex business processes and managing the impact of GIS implementation on client operational and management staff.

Timmons Group technical service offerings include:

Strategic Planning
Timmons Group is a leading provider of GIS strategic RoadMap planning for state, local, and federal government clients. From our technology consultants, web and mobile programmers, to our database managers, systems engineers, and project managers, our award-winning team understands your vision. Our geospatial technology experts care deeply about the mission of local governments and provide solutions that enhance our clients’ ability to better serve their constituents. Our team has the experience and capability to assist clients in all project phases– from planning to implementation to ongoing support and maintenance.

Packet Page 325 of 1251Attachment 3 Page 69 of 120

GIS Services and Training
City of Fairfield

Page | 2

Data Automation
Timmons Group has experience building data pipelines using FME, Python, R, Esri Data Interoperability, and other technologies.

Database Design
Our team has designed spatial databases and implemented them across many sectors, including property/land, transportation, utilities (e.g., sanitary, stormwater, water, gas, electric, telecommunications), retail, facilities, asset management, and more for many years. Most of these use geodatabases in personal, file, and especially enterprise formats. We are expert at creating and managing enterprise-level spatial databases and geodatabase with Oracle, Microsoft SQL Server, and PostgreSQL.

Our experience includes the endemic support and processes that go along with these relational database systems, such as:
• Designing, sizing, and creating database repository and tables, including related and ancillary tables
• Setting up user roles and permissions within the RDBMS software • Instituting multi-user access and versioning
• Designing and implementing associated environments such as development, testing, staging, and production
• Integrating other database and product systems with the primary GIS databases • Sizing and creating map, image, and feature caches, primarily to be used for web mapping applications
• Establishing and implementing back up plans, scripts, and procedures GIS-related Workflows and Best Practices
We help organizations with workflow process optimization, data capture automation, records digitization/indexing services, content management, retention and records management, reporting, dashboards, and e-forms process automation project implementations. In cases where these works are best suited for automation, we use a variety of technologies (FME, Python, etc.) to support our clients’ needs. The development of best practices and standard operating procedures (SOPs) are also a part of our RoadMap projects.

Data Insights and Visualizations
We capture, store, and manage data, and help our clients bring value from their data through our evolving data analytics practices. We use Esri, SQL, Excel Power Query, R, Python, and other methods of data analysis and we ensure we have the right tool for the job.

We have experience working with the complete Esri suite for proprietary data visualization.

Additionally, we work with Microsoft Power BI and Tableau.  We also have significant experience designing, developing solutions, and working with some of the widely used open- source map visualization products such as leaflet.js, OpenLayers.js, Polymap, D3.js, and Plotly.

Packet Page 326 of 1251Attachment 3 Page 70 of 120

GIS Services and Training
City of Fairfield

Page | 3

Systems Integration
Timmons Group has extensive experience with integrating GIS and non-GIS (legacy) systems.

System integration can be accomplished using several different methods, depending on the business need and legacy system capabilities. These methods range from a periodic data file download/upload exchange to fully automated transaction-level exchange where systems are updating each other’s data on a continuous basis.

Our proposed project team includes staff members with recent experience in integrating GIS and non-GIS systems on several high-profile projects. The resulting integrated business solutions provide access to spatial and business information on the desktop and mobile environments.

Application Development (including ArcGIS Online, Hub, and Portal) Timmons Group has more than 30 years of experience developing GIS applications for organizations in local, regional, state, and federal governments. Our GIS staff and government business subject matter experts team together to provide comprehensive GIS application development services from application design to maintenance and support. We proudly stand behind the solutions we have partnered with agencies to develop to help ensure the long-term return on investment is met.

Timmons Group uses a modified agile software development process that engages the project stakeholders and shows progress frequently while providing project oversight and risk management. We bring the lessons learned over many successful years of delivering GIS applications and solutions to government agencies around the country. If desired, Timmons Group will implement software development projects using a standard Waterfall method as well.

Timmons Group provides the following application development services:
• Esri configurable solutions
• Custom web-based applications including responsive Web Apps and Progressive Web Apps (PWAs)
• Web application and data services development in enterprise environments using SOA • GIS database design and modeling
• Design and implementation of solutions for supporting large raster and vector datasets • Design and implementation of ArcGIS solutions in multi-user, multi-agency, and enterprise environments
• ArcGIS Desktop plugin and tool development
• Custom ArcGIS applications that interface with GIS web services and enterprise GIS databases
Additional services include:
• ArcGIS Solution Design, Development, and Implementation ArcGIS Desktop ArcGIS Mobile ArcGIS Online
Packet Page 327 of 1251Attachment 3 Page 71 of 120

GIS Services and Training
City of Fairfield

Page | 4

ArcGIS Portal, including
ArcGIS Enterprise Sites
ArcGIS Hub ArcGIS Server
ArcGIS Web App Builder
• Custom Native Mobile Applications Design and Development Android iOS Windows
• Custom cloud-based solutions on AWS and Azure
• Enterprise data management design and implementation
• Open source and proprietary third-party (e.g., Esri, Google, and Mapbox) GIS solution design and implementation
• Automated deployment pipelines for DevOps environments • User Experience design
• Quality Assurance and Control
Test Strategy Design Test Plan Design Test Case Management Data QA/QC Software and Solution QA/QC
We have extensive experience using industry ETL tools in the market. This includes the Esri Data Interoperability Extension (FME Workbench) and FME from Safe Software. We have setup ETL processes for on-time, periodic, and continuous use applications. We also provide training on the set-up and use of ETL tools for our clients, should the need arise.

Training
We provide “over the shoulder” training focused on operating the data editing tools and query applications to ensure they are available for the end user. For the administrator, we provide example led training for systems maintenance using Esri Best Practices and training materials.

LOCALITY
Given the ongoing pandemic, we do not expect work on this contract to be performed locally.

REFERENCES
Project Descriptions for our references are in Appendix A: Project Descriptions.

Caltrans | Enterprise GIS
Implementation and Data
Management
Harold Feinberg, Chief
Phone: 916.654.6585
Email: [email protected]
Forest Grove | Enterprise GIS
Planning, Migration, Consulting, and
ArcGIS Online Portal
Gretchen Roberts, IT Manager
Phone: 604.501.9985 x 237
Email: [email protected]
Lompoc | GIS Data Conversion
Jeffrey Collins
1300 West Laurel Ave, Building 4A
Lompoc, CA 93436
Phone: 805.875.8290
Email: [email protected]
City of Albany | GIS Services
Bradley Glass, Director of Planning
City of Albany, NY
Phone: 800.258.3582
Email: [email protected]
St. Johns County Utility | GIS,
Technology, and Graphic
Design Services
Tom Tibbitts, GISP, Information
Systems Coordinator
St. Johns County Utility
Department
Phone: 904.209.2636
Email: [email protected]
Packet Page 328 of 1251Attachment 3 Page 72 of 120

GIS Services and Training
City of Fairfield

Page | 5

RESUMES
Resumes for our key personnel are in Appendix B: Resumes.

BROCHURES OR OTHER PERTINENT INFORMATION
https://www.timmons.com/technology/
https://www.timmons.com/service/technology/planning/roadmap-planning/ https://www.timmons.com/service/technology/implementation/enterprise-asset- management/
https://www.timmons.com/service/technology/data/data-insights-visualization/ https://www.timmons.com/service/technology/data/data-analysis-modeling/ https://www.timmons.com/service/technology/support/hosting-managed-services-migrations/

HOURLY RATES
Timmons Group does not disclose individual employee salaries.

Below is a table of our average salary by staff category, overhead rates, our proposed profit percentage, and fully loaded rate.

Title
Base
Hourly Rate Benefits Direct Costs
Indirect
Costs Profit
Fully
Loaded
Project Manager $60.63 $16.98 $0.00 $78.44 $6.06 $162.11 Esri Solution Lead $45.67 $12.79 $0.00 $59.09 $4.57 $122.11 Infrastructure
Lead $57.09 $15.99 $0.00 $73.86 $5.71 $152.65
Data Lead $26.37 $7.38 $0.00 $34.12 $2.64 $70.51

NON-DISCLOSURE AGREEMENT, EXCEPTIONS,

SUBCONTRACTORS

Ally Reynolds, FME Certified, Senior Data
Analyst: experienced in schema development,
scripting, QA/QC practices, data conversion,
including using ETL tools to populate
geodatabases, network modeling and routing,
GPS, integration, and geodetic adjustments for
coordinate system conversions.

Theo Snead, GIS Specialist: focuses on Utilities
and Enterprise data management. Theo has
managed, led, and participated in numerous data
creation and analysis projects using the Esri
Suite.

Brian Kingery, GISP, GIS Administrator: provides
expertise in application development and
implementing ArcGIS Online and ArcGIS
Enterprise systems for organizations. He has
worked on projects using both custom and COTS
applications.

Matt Moore, Systems Architect: performs
systems management/administration, web
administration, database administration and
development, and application development. He
is well versed in implementing enterprise
systems and uses both custom and COTS
applications.

Timmons Group agrees to the
Non-Disclosure Agreement.

Timmons Group takes no
exceptions to the sample
agreement.

Timmons Group will not use
subcontractors on this project.

Packet Page 329 of 1251Attachment 3 Page 73 of 120

GIS Services and Training
City of Fairfield

Page | 6

APPENDIX A : PROJECT DESCRIPTIONS
CALTRANS | ENTERPRISE GIS IMPLEMENTATION AND DATA

MANAGEMENT
Timmons Group was selected to help Caltrans establish new data management best practices within their geospatial Services Oriented Architectures (SOA). Caltrans is seeking to organize their Geographic Information System software, data, applications, workflows, stewardship/governance, and maintenance. The agency desires a solid plan that will carry them into the future and establish a GIS that serves all government departments equally and represents all current and future business needs. This plan will include all elements of a highly- functioning GIS – from people to process – accompanied with a reasonable plan of execution respectful of agency funding and capacity.

The overall project goal is to enable workflow automation and produce a GIS RoadMap Plan that defines the critical path and steps necessary for the continued development and implementation of a Geographic Information System that will improve the Agency productivity and service. Focused project goals include:
• Centralize GIS data and avoid duplicate, disparate datasets • Establish data workflows to ensure field data makes it to the central office easily and is of consistent and high-quality
• Improve internal data sharing
• Establish data stewards
• Establish GIS governance
• GIS training and education
The resulting GIS RoadMap plan will provide a detailed view of the existing GIS data and systems and establish a vision for the future with core recommendations. The plan will examine existing spatial data and workflows, identify needed data, and analyze existing integration opportunities. These recommendations will be driven by Agency priorities and presented in a manageable plan that includes staffing, training, overall governance requirements, and a plan for workflow automation. At a high-level, this RoadMap plan will:
• Review existing systems, data, workflows, governance, and solutions in place • Understand and document prioritized future requirements • Identify opportunities for workflow improvement
• Identify points of integration
• Lead discussions and education through examples and peer best practices • Identify IT infrastructure improvements
• Recommend changes required in the GIS (data, structure, applications, etc.) to achieve and enhance required services and commitments
• Recommend changes in governance and operations to support and expand the role and use of GIS within the Agency
• Recommend new data layers and improvements to existing layers • Create a schedule and budget for implementing the GIS that fits within Agency’s financial and calendar parameters
Packet Page 330 of 1251Attachment 3 Page 74 of 120

GIS Services and Training
City of Fairfield

Page | 7

FOREST GROVE | ENTERPRISE GIS PLANNING, MIGRATION,

CONSULTING, AND ARCGIS ONLINE PORTAL
The City of Forest Grove partnered with Timmons Group to employ our demonstrated expertise in designing and implementing Enterprise GIS Systems, converting existing geospatial data, and leveraging ArcGIS Online capabilities. The City initiated this effort with a GIS RoadMap project executed by our team. Based on the outcomes and recommendation of this planning effort, several high-priority projects and longer-term initiatives were identified. The RoadMap project was used to justify the need for a GIS manager position. The RoadMap plan was implemented parallel to hiring the GIS manager and focused on all aspects of the City’s GIS needs across Public Works, Utilities, Zoning, Planning, and other Departments.

Our team provides ongoing support for the City and its GIS environment. We work to ensure the GIS data and databases are tuned and performing as expected. This project also included a special focus on Data Quality Assurance / Control using automated tools and procedures.

Deliverables included in this project effort included:
• Business process and requirement analysis (GIS RoadMap) • Physical data model
• Data migration plan
• System design
• System workflows
• System implementation
• Data conversion
• Training
• ArcGIS Online Portal and administration training
• Collector for ArcGIS configuration and training
The City gained a fully functional enterprise GIS
system with all existing geospatial data available in the new system through this effort. The City’s project was
completed within a nine-month timeframe to encapsulate future additions and next steps in the following fiscal year’s budgeting process.

LOMPOC | GIS DATA CONVERSION
The City of Lompoc needed to convert its existing utility data from MicroStation to Esri’s Local Government Information Model (LGIM) in ArcGIS Pro.

LGIM Data Modeling
Timmons Group worked with the City to ensure the LGIM meets the data modeling needs.

Timmons Group held a Data Modeling workshop to address modifications to the LGIM with the City. This ensured that the features and attributes from both the existing GIS and the MicroStation files can be migrated to a feature class and field in the final database. This also involved the cleanup and creation of domains as well as contingent attribute fields to ensure high data quality when the City edits in the new database.

Packet Page 331 of 1251Attachment 3 Page 75 of 120

GIS Services and Training
City of Fairfield

Page | 8

During this data modeling period, Timmons Group started to discuss topology rules with the City’s editors. Topology rules help guide both the migration and the topology or network that will be created to help with quality assurance/quality control (QA/QC) workflow.

Migrate Existing GIS Data to the LGIM
Timmons Group takes a highly automated approach to data migration and quality control. This starts with the Extract, Transform, and Load (ETL) process used to migrate data from one format to another (in this case, both non-LGIM GIS data and MicroStation files to an Esri geodatabase). This enables our data conversion lead to perform continuous improvement to the process. Because the process is highly repeatable, this allows our team to run multiple migration iterations, constantly reviewing ETL results and refining them. The formalized ETL approach enables our staff to evaluate and remediate fallouts, or those items that do not convert as anticipated in the process. Once we are satisfied that we have the best possible ETL approach in place, our team will perform a final ETL migration into the modified LGIM geodatabase.

The ETL process is only the first step in the process for migrating geospatial data. Once data resides in “draft form” in the geodatabase, there are several levels of data integrity checks-and- balances that ensure data quality.

Timmons Group also leverages Esri’s Data Reviewer Extension, a set of tools that are used to validate user-defined conditions within the data. Data Reviewer is highly customizable and enables our team to further identify and remediate data integrity issues in the draft database.

Data Reviewer enables our team to review, flag, and track attribute-level deficiencies and spatial issues in the data. This enables our team to collaborate with the City in a systematic way should questions arise surrounding issues in the existing data. Many of the Data Reviewer components defined in this stage ultimately make their way into future data management workflows that are developed for our clients.

Migrate MicroStation Files to the LGIM
A similar process to the one used to migrate the existing GIS data into the LGIM was used to migrate the MicroStation files as well. We created an ETL process that migrates each feature from MicroStation, matches it to the MSSQL record to receive attributes, and then writes it into the LGIM database. Timmons Group worked with the City to ensure that each layer from each MicroStation file was migrated to the correct feature class within the LGIM.

The ETL process was also used to automate several functions that decreases the time needed for QA and manual corrections. This includes snapping features together, merging lines, and automating attribution. The ETL can also create logging in the form of counts for each feature going in and coming out.

Annotation (Linked and Non-Linked)
Annotations were requested but not recommended as, in most cases, they are simply not necessary and result in additional data maintenance. Dynamic labeling will better serve the City’s labelling needs and result in less work as well. Timmons Group will deliver a map file in ArcGIS Pro format with configured dynamic labels.

Packet Page 332 of 1251Attachment 3 Page 76 of 120

GIS Services and Training
City of Fairfield

Page | 9

Update GIS Data from As-builts
Timmons Group is under the impression that there is presently a single as-built which needs to be migrated to the new GIS system. As there is only one project, this will likely be a manual process undertaken by our staff following the migration effort. It is assumed this is a PDF or similar file.

QA/QC (Manual & Data Reviewer Checks) in ArcGIS Pro Format Timmons Group will configure Reviewer Rules and/or Validation Attribute Rules to ensure the data has correct connectivity. Depending on the data, a database topology will be created and configured with topology rules to support the validation of the migrated data.

Following the approval of the rules by the City, Timmons Group editors will use the configured checks to correct any data issues. It is expected during a migration from CAD-type software to GIS that there will be connectivity gaps. Timmons Group will work to correct these as much as possible, while making as few assumptions as possible about the data. The ease of this, and the extent to which the data can be corrected, will depend on the quality of the MicroStation files.

Grid-based Maps for City’s QA/QC
While Timmons Group recommends the use of Data Reviewer and Validation Attribute Rules rather than a grid-based map, we will configure and deliver a map file that references the migrated data as well as a grid feature to guide the City’s analysts through QA/QC processes.

ALBANY
Timmons Group was contracted to provide as-needed professional Geographic Information Services (GIS) to the City of Albany. The City required a team with advanced GIS skills for support with a wide spectrum of geospatial knowledge and decision making. Our GIS project team is providing GIS
technical support consulting
services to assist the City
with the management and
maintenance of the City’s
GIS datasets. Tasks
completed as part of this
work scope include, but are
not limited to, the following:

Dataset updates and
migration, quarterly updates
of the City’s parcel base and
the configuration/updates of
the miscellaneous datasets
used in the City basemap
applications, interfacing with
various software providers, including MapGeo and Energov, ArcGis Online administration, creation of miscellaneous maps and data analyses, and incidental system repairs and necessary software updates. Primary GIS support services to the City have included:

Packet Page 333 of 1251Attachment 3 Page 77 of 120

GIS Services and Training
City of Fairfield

Page | 10

• Administering, designing, building, and implementing enterprise GIS systems. • Esri administration, specifically: Enterprise SDE geodatabase, ArcGIS Server, Portal, ArcGIS Desktop, ArcGIS Online.
• Esri geodatabase administration in an MSSQL environment. • Configuration and operation of virtualized environments. • Management of Active Directory functionality, including authentication and group-based authorization.
• MSSQL Server database operation, permissions, and capabilities in an enterprise environment.
• Administering ArcGIS Online users, groups, data, and maps. • Using ArcToolbox and custom Python tools for data manipulation. • Clear, concise communication and documentation of system architecture and use cases.

ST. JOHNS COUNTY UTILITY | GIS, TECHNOLOGY, AND GRAPHIC DESIGN

SERVICES
Timmons Group is providing GIS, Technology, and Graphic Design services to St. Johns County Utility to expand the County's GIS by further developing applications targeted at increasing overall productivity, developing information, integrating systems, and limiting duplicate work processes.

Tasks under this on-call contract included:

Workflow/Data Quality Tools and Support
Timmons Group assisted the County with:
• Onsite Discovery – to understand the County's editing workflows and their data requirements. This discovery will focus on Utility data, specifically Operations, Capital Improvement and Development
• Workflow Tools – to develop workflow standardization tools for the County editors. This will aid in version and database management and maintaining standards when creating and modifying GIS data. This will use Esri's Workflow Manager (WMX) and Task Assistant Manager (TAM).
• Data Quality Tools – to develop quality checks for the County editors. These checks made certain data is clean and can be uses at maximum capacity by other applications such as water modeling. This used Esri's Data Reviewer extension (DR). • Onsite Training – to ensure that the tools developed can be used with proficiency by the editors. This included deployment and testing of the tools to desktop and server environments. An admin and end-user guide was provided to the Utility. • Troubleshooting and reconfiguration of deployed solutions • Support to GIS Staff during County maintenance of tools • Training and support of staff
• Additional GIS service requests
Cityworks PLL Integration for SJC Public Works Department (PWD) • Project Planning/Management
Packet Page 334 of 1251Attachment 3 Page 78 of 120

GIS Services and Training
City of Fairfield

Page | 11

• Three Days of Onsite Workshops to Identify Workflows
• Technical Memo to Document Workflows and Hardware/Software Specifications • PLL Configuration Support
• Training and Documentation
• Reports
• Online Access Portal
Public Conservation Awareness Program
Timmons Group assisted the County with its Water Usage Campaign by creating, developing, and publishing content that focused on decreasing landscaping water usage on new home construction. Content targeted the north east area of the County with the goal of encouraging action for changing aggressive irrigation schedules. We accomplished this by:
• Expanding the St. Johns County Utilities Department social media platforms (Facebook, Twitter, and Instagram) by posting industry-related news, St. Johns County Utility updates, and information to empower the public and St. Johns County residents to become conservation leaders.
• Creating a cohesive design appearance that falls within the St. Johns County brand and creates an overall consistent voice and tone for communications. • Expanding the social media engagement of customers and users in the region. • Establishing and maintaining a frequency of St. Johns County posts on social media platforms.
• Determining and engaging local social media powerhouses to create reciprocal relationships.

Capital Assets Data Migration
Timmons Group assisted the County with migrating its capital asset data from the existing Microsoft Access Database to a relational geodatabase. This involved converting the data into a file geodatabase schema containing non-spatial tables and a feature dataset to hold relational object features. Timmons Group then assessed the data to determine the scope of required clean up.

Water Conservation Awareness Applications and Data
Timmons Group developed data and applications to support the County’s Water Conservation Awareness Program using ArcGIS Online Web Application, building GeoForms, and creating StoryMaps. Timmons Group also supported the County on an as-needed basis designing, developing, editing, and maintaining GIS data.

GIS Data Quality and Standards
Timmons Group worked with the County on the following:
• GIS Needs Audit – determined the extent of attribution that is necessary for features in the water, wastewater, and reuse data model. This process will be led by Timmons Group personnel over the course of several remote workshops which will include all pertinent stakeholders from St. Johns County. These workshops will cover Water, Wastewater and Reuse systems.

Packet Page 335 of 1251Attachment 3 Page 79 of 120

GIS Services and Training
City of Fairfield

Page | 12

• As-Built Digitization – continued to support County efforts to digitize as-builts. This process relied heavily on feedback which is gathered in the Needs Audit and largely informed additional work planned for later phases.
• Evaluation of Data Integration – provided recommendations relating to a data submittal standard for County implementation. This standard placed strict requirements on data submitted to the County by vendors. This allowed the County to intake new data in a more efficient and accurate manner by standardizing attribution, workflows, tools, and quality assurance methodologies.
• Process Documentation – compiled documentation of data creation workflows, editing tools, and quality assurance methods.
• Update/Reconfigure Editing Tools – updated tools to make certain they function properly and are configured to maximize their effectiveness. • Remote Training Sessions – lead two half-day remote training sessions for County editors. These remote sessions covered data creation workflows, editing tools, and quality assurance methods.

Packet Page 336 of 1251Attachment 3 Page 80 of 120

GIS Services and Training
City of Fairfield

Page | 13

APPENDIX B: RESUMES
Matt performs tasks related to systems
management/administration, web administration, database administration and development, and applications development.

Matt has worked on many systems architecture design,
development, and implementation projects for federal, state, and local governments throughout the US. He is well versed in implementing Enterprise systems and has worked on projects using both custom and COTS applications.

KEY EXPERTISE
• Consults clients on managed services and cloud service offerings
• Consults on numerous custom application development
projects
• Delivers consulting services via project discoveries and needs assessments
• Provides GIS industry best practices for local, state, and federal governments, and NGOs.
• Provides consulting and recommendations on using
technology to solve business process / workflow challenges • Plans and manages integration of GIS with other information technology systems
• Implements technical solutions and designs for enterprise GIS systems
• Deploys and manages server infrastructure in Cloud
environments
• Develops scripts as needed to automate GIS workflows
• Manages Relational Database Management Systems (SQL
Server/Postgres/PaaS offerings)
• Manages Active Directory as needed for Cloud environments • Builds and manages web servers in Apache and Microsoft IIS

RELEVANT PROJECT EXPERIENCE

MATT MOORE

INFRASTRUCTURE LEAD

EDUCATION
Bachelor of Science,
Geography, Information
Technology focus, Old
Dominion University, 2004

TECHNICAL SKILLS
Esri Enterprise System
Design, AWS Services,
ArcGIS Online, Python,
SQL Server / Oracle, IIS
10x, 8.x, 7.x, 6.x, Apache
Tomcat 2.2, 2.4, PHP,

HTML, JSON, SSL & PKI
Deployment, Adobe Flex
Builder, XML, Action
Script, Deployment of
.NET and JavaScript web
applications

CERTIFICATIONS
AWS Certified Cloud
Practitioner
Esri Certified Enterprise
System Design Associate
Esri Enterprise Geodata
Management Professional
Packet Page 337 of 1251Attachment 3 Page 81 of 120

GIS Services and Training
City of Fairfield

Page | 14

• ArcGIS Enterprise Cloud Design, Build and Managed Services, Philadelphia Gas Works (PGW)
• ArcGIS Jumpstart, City of New Smyrna
• Pennsylvania Game Commission (PGC)
• Minot ArcGIS Enterprise and Configuration
• GEOHub Conceptual System Design, Oregon Department of Transportation • GIS Services, Albany County, NY
• Anchorage GIS Downtown Step 2, Anchorage, AK
• Compatible Energy Siting Assessment, Thurston, WA
• City of Sandpoint GIS Support Services, Bonner County, ID • COF GIS Parcel Script Updates Cityworks, Fayetteville, NC • Cyber Secure GIS Support at Port of Anchorage, Anchorage, AK • Dinwiddie Co Site LoGIStics, Dinwiddie, VA
• Dominion Joint Use Pole Survey, 03Statewide, VA
• EPCOR Utility Network Migration, Maricopa, AZ
• Fairfax Co Water Authority Enterprise Geographic Information System, Fairfax County, VA • Fairfax County - Master Address Repository (MAR) Modernization Project, Fairfax, VA • Fairfax Water Phase 2 EGIS Implementation, Fairfax, VA • Fayetteville GIS Data & Systems Support, Fayetteville, NC • City of Forest Grove GIS Support Services, Forest Grove, OR • Forest Grove GraniteNet GIS Support, Forest Grove, OR • Forest Grove Internal ArcGIS Configure, Forest Grove, OR • City of Forest Grove Server Configuration, Forest Grove, OR • Fredericksburg GIS Support Services - IT, Fredericksburg, VA • Fredericksburg System Administration Services, Fredericksburg, VA • GIS Database and Support Services, Richmond, VA
• Grants Pass GIS RoadMap, Josephine County, OR
• Hanover Co Base Map Adj and Enhancements, Hanover, VA • Ichor Analytics, Kings County, NY
Packet Page 338 of 1251Attachment 3 Page 82 of 120

GIS Services and Training
City of Fairfield

Page | 15

• Lunenburg Co Onsite Parcel Training, Lunenburg County, VA • NC DMS GIS Support Services, Raleigh, NC
• NC DMS GIS Support Services FY2019, Raleigh, NC
• Nevada Department of Transportation - GIS Support Services, Carson City, NV • New Mexico State Land Office Right of Way, Santa Fe, NM • New Smyrna Beach, FL - ArcGIS Install, Volusia County, FL • OK Land Office Commercial Lease Workflow, Oklahoma City, OK • Oklahoma Commissioners of Land Office GIS Support, Oklahoma City, OK • Orange Co EGIS System Architecture and Tools, Orange County, VA • Oregon DLCD GIS Administration Assistance, Salem, OR
• PGC ArcGIS Enterprise Migration, 03Statewide, PA

Packet Page 339 of 1251Attachment 3 Page 83 of 120

GIS Services and Training
City of Fairfield

Page | 16

Ally is a GIS Analyst on the Timmons Group Geospatial Services Team. She has experience in Esri GIS schema development, scripting, QA/QC practices, and data conversion including using ETL tools to populate geodatabases.

KEY EXPERTISE
• Leads Timmons Group’s Utility Network projects
• Certified as a FME Professional
• ArcGIS Desktop certified
• Manages and consults on numerous utility mapping,
addressing, Next Generation 911, and tax parcel mapping projects
• Writes Arcade script to configure Attribute Rules and pop- ups
• Manages multiple GIS professionals
• Oversees the local government data maintenance projects • Presents at multiple GIS conferences

RELEVANT PROJECT EXPERIENCE
• City of Forest Grove Enterprise GIS System, Forest Grove, OR
• Eastern Virginia Regional Routable Centerline Development & On-going Support, King and Queen County, VA
• Town-wide GIS System, Town of Smithfield, Suffolk County, NY
• Land Information Management System, Albuquerque, NM
• Michigan Forest Road Inventory, Statewide, MI
• Parcel Data Maintenance and PSAP Boundary, Amelia
County, VA
• Parcel Data Maintenance, Gloucester County, VA

ALLY REYNOLDS, FME-CERT.

DATA AUTOMATION

EDUCATION
BA, Biology with Minor in
Spanish, University of
North Carolina, 2015

REGISTRATIONS
Certified ArcGIS
Desktop Associate
FME Certified
Professional

AWARDS
Esri Business Partner of
The Year
Esri Partner Award Winner:

Fostering Engagement
Award
Multiple Esri Local
Government Special
Achievement (SAG) Awards

Packet Page 340 of 1251Attachment 3 Page 84 of 120

GIS Services and Training
City of Fairfield

Page | 17

• Parcel Correction and Create Website, Mathews County, VA • Parcel Maintenance, Nelson County, VA
• Weekly Automation Addressing, Miami-Dade County, FL
• NG911 Address Verification/Data Readiness, Amelia County, VA • Address Maintenance 12/1/19-11/30/24, Bath County, VA • NG-911 Address Verification & Data Readiness, Essex County, VA • Enterprise Geographic Information System, Fairfax County Water Authority, VA • Master Address Repository (MAR) Modernization Project, Fairfax County, VA • NG911 Data Corrections, Lunenburg County, VA
• NG911 Data Correction/Maintenance, Nottoway County, VA • NG911 Data Correct/Maintenance, Orange County, VA
• ArcGIS Online, City of Forest Grove, OR
• ArcGIS Image Server Implementation, Spotsylvania County, VA • ArcGIS Enterprise and Configuration, City of Minot, ND

Packet Page 341 of 1251Attachment 3 Page 85 of 120

GIS Services and Training
City of Fairfield

Page | 18

Brian is a Project Manager and GIS Administrator on Timmons Group’s Geospatial Services team providing expertise in GIS. He has worked with numerous clients in both the public and private sector. His project experience ranges from performing mission- critical GIS tasks for the military, to assisting government department of transportation (DOTs) solve business problems, as well as helping local governments across the US improve workflows. He is well versed in implementing ArcGIS Online and ArcGIS Enterprise systems for organizations and has worked on projects using both custom and COTS applications.

Key Expertise
• Serves as a firm leader in terms of designing, configuring, and implementing Esri technology to support a variety of use cases from the office to the field.
• Helped establish and refines Timmons Group’s highly
successful community engagement GIS approach using
ArcGIS Hub. Learn more at arcgishub.timmons.com.
• Consults on numerous GIS RoadMap projects.
• Manages and consults the implementation of GIS solutions for city and county departments.
• Provides GIS industry best practices for local, state, and federal government.
• Specializes in helping organizations get the most return-on- investment related to GIS.
• Provides recommendations about GIS staffing, organization, and training.
• Manages and consults on integration of GIS with other information technology systems
• Manages and consults on numerous GIS data creation,
conversion, migration, and QA/QC projects

BRIAN KINGERY, GISP

ESRI LEAD

EDUCATION
Executive Certificate,
Leadership and
Management, University
of Notre Dame - Mendoza
College of Business, 2018
Master of Science,
Geographic Information
Systems, Elmhurst College,
2016
Bachelor of Science,
Geography, Old Dominion
University, 2014

REGISTRATIONS
Geographic Information
System Professional
Certified ArcGIS Desktop
Associate
Certified ArcGIS Online
Administration Specialty
Packet Page 342 of 1251Attachment 3 Page 86 of 120

GIS Services and Training
City of Fairfield

Page | 19

• Presents at numerous GIS conferences

RELEVANT PROJECT EXPERIENCE
• VDOT Guardrail Terminal and Curve Assessment Data Collection, Virginia Department of Transportation, Virginia
• VDOT Safety Rest Area ADA Compliance Assessment, Virginia Department of Transportation, Virginia
• Sidewalk Collection and Enrichment, Chesterfield County, VA • StoryMap Development, North Miami Community Redevelopment Agency, North Miami, FL • StoryMap Development, Pacific Islands Forestry Committee, US-Affiliated Pacific Islands • Strategic RoadMap, Pennsylvania Game Commission, Harrisburg, PA • Bailey Bridge Connector (Brad McNeer – Bailey Bridge), Chesterfield County, VA • Bon Air Pedestrian Improvement, Chesterfield County, VA • Buncombe County Site Identification, Asheville Economic Development Coalition, Buncombe County, NC
• Geographic Information System Enhancements, California Department of Transportation, California
• Compatible Energy Siting Assessment, State of Washington • Enterprise GIS Consulting, University of Richmond, Richmond VA • GIS Database and Support Services, Northern Virginia Community College, Richmond, VA • Mayo River State Park Master Plan, North Carolina Department of Natural and Cultural Resources, Rockingham County, NC

Packet Page 343 of 1251Attachment 3 Page 87 of 120

GIS Services and Training
City of Fairfield

Page | 20

Theo is a GIS Specialist at Timmons Group. His experience includes work with clients in both the public and private sectors. Theo’s work has focuses including Utilities and Enterprise data management. Theo has managed, led, and
participated in numerous data creation and analysis projects using the Esri Suite.

KEY SKILLS
• Generating and maintaining geodatabase layers and
associated attribute information
• Design and implementation of survey123 workflows
• FME data transformations
• Attribute automations within a utility network
• Management of enterprise geodatabases
• Map creations in both desktop and pro

RELEVANT EXPERIENCE
• Lompoc - GIS Data Conversion, Santa Barbara, California • SJC Update GIS Data Quality & Standards Program, St.

Johns County, Florida
• City of Sandpoint GIS Support Services, Bonner County, Idaho
• Albany - GIS Services, Albany County, New York
• MAG - Economic & Geospatial Data & Service Support On- Call, Phoenix, Arizona
• GIS Database and Support Services, Richmond, Virginia

THEO SNEAD

DATA ANALYST

EDUCATION
Bachelor of Science,
Environmental Studies,
Virginia Commonwealth
University, 2018

AWARDS
Esri Business Partner of The
Year
Esri Partner Award Winner:

Fostering Engagement
Award
Multiple Esri Local
Government Special
Achievement (SAG) Awards

TECHNICAL SKILLS
ArcGIS Desktop and
extensions
ArcGIS Server
ArcGIS Enterprise

Packet Page 344 of 1251Attachment 3 Page 88 of 120

GIS Services and Training
City of Fairfield

Page | 21

APPENDIX C: PROJECT MANAGEMENT METHODOLOGY

MANAGEMENT APPROACH
Timmons Group provides the following Project Management services throughout the duration of each project:
• Perform Business meeting(s) (in person or conference calls) • Develop, in cooperation with the client Project Manager, a detailed Project Plan and Schedule
• Proactively manage and update Project Plan and Schedule, as required, throughout the duration of the Project. Project Plan and Schedule modifications will be facilitated on common agreement between the client and the team Project Manager • Coordinate project events with the client Project Manager and team members • Author, edit, review, and distribute project documentation and technical reports, as required
• Facilitate in-process review meetings with the client Project Manager and end-users as scheduled, and appropriate, throughout the duration of the project • Perform miscellaneous project administration (e.g., internal project updates), and • Anticipate problem areas then propose and facilitate solutions Project Plan
Each project is defined and managed by a Project Plan. Our Project Plan is based on a proven template and includes the project scope, schedule, deliverables, and fee. The project plan is based on the requested scope of work and our team’s proposed response, refined through negotiations with the client. The Project Plan is a living document that can evolve, though mutual agreement of the client and Timmons Group, as the project progresses.

Issue/Action Item Management
During the project, the Project Manager will maintain a detailed issue/ action item tracking log.

This will include issue details, issue status, issue assignments, and issue resolution details.

Action items will be tracked in a similar fashion. The client Project Manager is encouraged to contribute issue/action items to the list. This list will be presented to the client Project Manager on a periodic basis, as agreed to by the client and team Project Manager, using the Project Progress Report (see below). This is normally done as part of a regularly scheduled project status report work process.

Risk Management
Risk Management is a
fundamental project management
element for Timmons Group
projects. It is critical to ensure a
level of contingency preparation
should a risk become a reality.

During the risk management
process, likely risks associated
Packet Page 345 of 1251Attachment 3 Page 89 of 120

GIS Services and Training
City of Fairfield

Page | 22

with the implementation of the project are identified, along with their project impact and mitigation strategies.

User Acceptance Testing
User Acceptance Testing (UAT) is the time when users get to "kick the tires" of the project deliverables to ensure they reflect the requirements and design specifications set out in the contract. The user acceptance timeline will be outlined as part of the overall project work plan.

This will include a detailed listing of UAT tasks, clearly delineating those that Timmons Group expects client personnel to perform.

Change Management
During the project, changes to the project plan may be required. Our change management process is designed to address these changes head-on, document them, and ensure they are reflected in an updated set of tasks. In some cases, the proposed change will affect schedule, costs, and scope. Should this occur, the Change Management Process will be used to manage expectations and clearly convey and document the impacts of such decisions on project scope, deliverable, schedule, and cost.

PROJECT COMMUNICATION TOOLS
We have a proven project communications process and plan that keeps your staff fully informed of the project progress. The project team uses a variety of project management tools throughout the project lifecycle, including:
• Microsoft Project – for schedule management
• Web-based Project Portal – for client communications and project document storage • Secure FTP project folder or Dropbox folder – for data and program transfers • Secure test environments – for software and data review and acceptance • Subversion or Team Foundation Server (TFS) – for application code management • TRAC or HP Quality Center – for application and data issue/bug tracking

PROJECT COMMUNICATIONS PROCESSES
Shown below is a summary table of our project communications/reporting methods followed by details of each method.

Reporting Method/
Responsibility Focus Participants
Project Kick-off Meeting
Responsibility: Project
Manager
Establish the necessary Project Management
protocols to be adhered to by team members. The
Meeting will focus on:

Team introductions
Deliverables Overview
Roles and Responsibilities
Project Schedule and Milestones
Project Manager and Key
Stakeholders
Project Website
Responsibility: Project
Manager
This website will provide a repository for project
documents, project status, and issue tracking.

Project Manager
Packet Page 346 of 1251Attachment 3 Page 90 of 120

GIS Services and Training
City of Fairfield

Page | 23

Reporting Method/
Responsibility Focus Participants
Project staff assigned to this project will have the
ability to access, post, and edit on the site.

Weekly Project Team
Coordination
Responsibility: Project
Manager
Weekly report of work in progress including
completed tasks; planned tasks; and anticipated
conflicts. Our Project Manager will review these
reports and meet with the project team members
to determine and schedule the required actions.

Project Manager
Weekly Status Reports
Responsibility: Project
Manager
Each report will detail significant progress made
during the previous time period; activities planned
for the current time period; and project issues that
require resolution
Project Manager and
occasional technical staff as
needed
Monthly Milestone Meetings
Responsibility: Project
Manager
Overall project direction, performance, and
progress.

Project Manager and Key
Stakeholders
Project Change Control
Process
Responsibility: Project
Manager
A change management process that provides a
structured, planned approach to identifying,
approving, and implementing changes affecting
schedule, costs, and scope
Project Manager
Project Kick-off Meeting
On notice to proceed, we convene a project kick-off meeting. This meeting is orchestrated by the Project Manager and includes participation from Key project stakeholders and client staff.

The meeting focuses on:

Packet Page 347 of 1251Attachment 3 Page 91 of 120

GIS Services and Training
City of Fairfield

Page | 24

• Team introductions
• Deliverables Overview
• Roles and Responsibilities
• Project Schedule and Milestones
Weekly Project Coordination Meetings
Project team members provide our Project Manager with
weekly status reports detailing the work in progress,
including completed tasks; planned tasks; and anticipated conflicts. Our Project Manager reviews these reports and meets with the project team members to determine and
schedule the required actions. Discussion topics are
logged and made available to all team members.

Project Schedule Coordination
Project scheduling and task management is proactively
monitored using Microsoft Project software. Project
schedules, tasks, deliverables, and milestones are
continuously monitored and adjusted as required. An
updated project schedule are made available to all
interested parties.

Project Progress Report
Our Project Manager provides the client’s Project Manager with a written weekly or bi-weekly status report, the frequency of which depends on the client’s needs. Each report details significant progress made during the previous month; activities planned for the current month; and project issues requiring resolution.

Packet Page 348 of 1251Attachment 3 Page 92 of 120

City of Fairfield, California
GIS Services and Training

Prepared For:

An Incorporated City in Solano County, California

Produced By:

VESTRA Resources, Inc.
5300 Aviation Drive
Redding, CA 96002
(530) 223-2585
www.vestra.com

January 28, 2022

Response to Request for Qualifications
GIS Services and Training

Packet Page 349 of 1251Attachment 3 Page 93 of 120

Packet Page 350 of 1251Attachment 3 Page 94 of 120

City of Fairfield, California
GIS Services and Training

Page | 1

GIS SERVICES AND TRAINING QUALIFICATIONS
VESTRA RESOURCES, INC. INTRODUCTION
For over 33 years, VESTRA Resources, Inc. (VESTRA) has been an industry leader in Enterprise GIS design, customization and implementation. VESTRA was one of the first Esri authorized business partners in California, and has been a business partner since 1989. As an Esri Certified Gold Partner (one of only 56 in the U.S.) we are proud to hold several specialty designations including ArcGIS Online Specialty (one of only 24 U.S. Gold partners), State and Local Government Specialty (one of only 10 U.S. Gold partners), Federal Small Business Specialty (only of only 8 U.S. Gold Partners), and ArcGIS System Ready Specialty (one of only 36 U.S. Gold partners). We offer products and services to clients of all sizes in federal, state, local government and private organizations, nationally.

VESTRA is an employee-owned, multi-disciplinary corporation doing business in the State of California having a principal office location at 5300 Aviation Drive, Redding, California. VESTRA was incorporated in the State of California in 1988 (Secretary of State Business Entity No.

C1429545), and is governed by a Board of Directors. VESTRA is a California-certified Small/Micro Business Enterprise (Certified Small/Micro Business No. 13183 ).

For this response VESTRA Resources, Inc. (VESTRA), located in Redding, California, has teamed with FEC, Inc. located in Folsom, California. We believe that our team will provide the City with the best resources available to provide GIS Services and Training to the City.

FEC, INC. INTRODUCTION -SUBCONSULTANT
FEC, Inc. (FEC) provides GIS services as well as environmental planning and regulatory permitting services. FEC’s principal office location is 629 Sutter Street, Folsom, California 95630. FEC staff specializes in supporting government organizations, public agencies, and local jurisdictions and municipalities. FEC has managed multi-disciplinary projects throughout Northern California ranging from land development and natural resource management to implementing GIS systems and leading data collection efforts used for asset management. Collectively, FEC’s skillset includes developing web applications and system integration, spatial analysis, GPS data collection and data post-processing, database management as well as general cartography and map production. FEC clients have included such public entities such as the City of Auburn, the City of Roseville, Placer County, El Dorado County and the Nevada Irrigation District.

CORE COMPETENCIES
GIS Training & Support Local Government Information Model (LGIM) Geodatabase Design & Development Mission Critical Enterprise GIS Monitoring GIS Mapping and Reporting Mobile Development & Field Data Collection GIS Data Management & Modeling GIS Solutions Architecture GIS System Architecture Design &
Implementation GIS Analytics
Packet Page 351 of 1251Attachment 3 Page 95 of 120

City of Fairfield, California
GIS Services and Training

Page | 2

GIS Strategic Planning & Needs Assessments Custom Web AppBuilder Widgets GIS Application Development Web Application Mashups
ArcGIS Online for Organizations CAD to GIS Data Migration & Conversion Portal for ArcGIS Implementations 3D Visualization & Modeling ArcGIS for Local Government GIS Data Task Automation

TYPES OF TRAINING SERVICES
VESTRA’s team provides training and technical support in several formats including on -site training in a classroom setting, and online knowledge transfer using screen sharing software.

Based on client’s requirements, our training content can be customized with da ta and tools that are specific to client workflows and needs. VESTRA also provides traditional GIS training.

VESTRA can provide GIS training to users of all experience levels (beginner to advanced) in various GIS topics. Training services VESTRA will be able to provide include, but are not limited to:

1. ArcGIS Desktop Training (e.g., ArcMap and ArcGIS Pro)

2. ArcGIS Online Training

3. ArcGIS Enterprise Design, Implementation, Administration and Management

4. Extensions (e.g., ArcGIS Desktop and Enterprise)
We produce detailed guided training materials that users can follow step by step in an interactive classroom setting where users can hear, see and do, to get maximum benefit in a short amount of time.

LOCATIONS AND PERCENTAGES OF WORK
VESTRA Location – 5300 Aviation Drive, Redding, CA 96002 • 45% of the work is estimated to be completed remotely FEC Location – 629 Sutter Street, Folsom, California 95630 • 55% of the project work is estimated to be completed locally Note: The above percentages are estimates and may change once requirements and details of project work to be completed are provided.

STAFFING
VESTRA has a GIS/IT Division and an Environmental/Engineering Division with 29 employees company-wide; 8 are dedicated GIS/IT professionals. Below is the proposed organizational chart for the GIS Services and Training project for the City of Fairfield. VESTRA’s GIS team members are all permanent staff. VESTRA will be teaming with Matt Fremont of FEC as a subconsultant on this project. Full staff resumes are included in Appendix A.

Packet Page 352 of 1251Attachment 3 Page 96 of 120

City of Fairfield, California
GIS Services and Training

Page | 3

Matt Fremont, Sr. GIS Specialist
18+ Years Experience, Subconsultant
Clancy Finmand, Sr. GIS Technician
17+ Years Experience, Permanent Staff
Arthur Stackhouse, President / CEO
Sr. Project Manager
44+ Years Experience, Permanent Staff
Ryan-Goodner-Belli, Sr. GIS Analyst
11+ Years Experience, Permanent Staff

WHAT SETS VESTRA APART FROM THE COMPETITION?
• Highly successful modernizations and migrations of Enterprise GIS systems to Esri's WebGIS Model
• GIS Staff with over 44+ years of experience, and 33+ years of GIS training experience • High client retention rate of 90 plus percent due to excellent client responsiveness • Flexible resources with competitive pricing
Our GIS teams’ unique skillsets position us ahead of most other GIS consulting firms in the country. Not only do we have exceptional project managers, GIS analysts and engineers, but we also have award winning software developers who have been working in the GIS industry for over 20 years as well as GIS system architects who have been building comprehensive and scalable GIS infrastructures for over 17 years.

There are many reasons why this is extremely important for your project. One is that we have the expertise readily available. We don't have to look into alternative methods or find resources to solve problems if we run into obstacles – saving you valuable time and money!

REFERENCES
Below are descriptions and references for GIS Services and training projects VESTRA worked on in the last year.

VESTRA AND FEC REFERENCE

1. City of Elk Grove, CA
Nicole Guttridge, IT Administrator
(916) 478-3658 |[email protected]
The City of Elk Grove contracted with VESTRA to provide on-call GIS program services to the City including GIS Data, Mapping, Analysis Support and Services; GIS Coordination Services; GIS System and Application Maintenance and Support; and GIS Training Services. The City maintains a highly active GIS support help desk. City staff use an internal help desk system to request GIS services on a daily basis. These requests range from ad -hoc map requests to Packet Page 353 of 1251Attachment 3 Page 97 of 120

City of Fairfield, California
GIS Services and Training

Page | 4

specific GIS projects that are executed over several months. GIS support services range in complexity from basic mapping to data management to custom software development and web application programming and Enterprise GIS System Administration and Maintenance.

VESTRA was very successful in providing prompt on-call support services such that the City was able to continue to meet or exceed its performance goals for overall IT/GIS support.

Project: GIS Program Services | Project Duration: 10/2016 – Present Responsible Personnel: Clancy Finmand, GIS Specialist
Matt Fremont, Subconsultant GIS Analyst/Systems Architect

VESTRA REFERENCES

1. Formation Environmental
Clint Kellar, Senior Spatial Solutions Consultant
(530) 515-6449 | [email protected]
VESTRA provided training services as a subconsultant to Formation Environmental for a confidential municipal utility client. The project involved developing curriculum and providing two training sessions for up to 20 attendees. The first training session, developed and conducted by Formation Environment, was for remote sensing technology, and focused training on shallow flooding wetness procedures and alternative remote sensing wetness procedures. The second training section, developed and conducted by Mr. Stackhouse of VESTRA, was for specialized training on the use of existing GIS technology tools and automation techniques for summarizing remote sensing data using ArcGIS and other toolsets. These training sessions were focused on empowering client staff to use remote sensing data in workflow and analysis tools.

VESTRA assisted Formation Environmental in the preparation of curricula, training materials, sample training data, and presentations materials for the Session Two Training on GIS Technology and Application, which included the following topics:
• GIS fundamentals using ESRI software (ArcGIS Pro) and data from client • Field data collection and field method workflows to publish and distribute data using ArcGIS Online/Collector/Survey123
• Geoprocessing models/scripts for repetitive tasks and analysis • WebGIS including workflows to publish and distribute GIS data for internal and/or external use (ArcGIS Pro/ArcGIS Online/Portal)
• 3D data and modeling using ArcGIS Pro/ArcGIS Online/Portal Project: Training and Knowledge Transfer Support | Contract Duration: 11/2019 - 7/2021 Responsible Personnel: Arthur Stackhouse, Solution Architect

2. Alpine County, CA
Candace Stowell, Deputy Director, Community Development Department (530) 694-1361 | [email protected]
Packet Page 354 of 1251Attachment 3 Page 98 of 120

City of Fairfield, California
GIS Services and Training

Page | 5

For the past 11 years, VESTRA has supported Alpine County, California with an Enterprise GIS implementation. VESTRA prepared the Alpine County GIS Master Plan 2011 and since then has been assisting the County with implementing the GIS within planned phases. The phased approach laid the foundation of GIS and data development. VESTRA helped implement a cloud based GIS infrastructure (using ArcGIS Online) and assisted in data maintenance workflows. Later phases helped implement web mapping viewers for the County. VESTRA assisted the County expand their online GIS presence in the County by understanding needs related to additional applications and GIS contribution to daily business processes. Currently, VESTRA is providing training to County staff covering the following topics: ArcGIS for Desktop (ArcMap and ArcCatolog); ArcGIS Online; a review of the Local Government Information Model (LGIM), application templates, loading data into LGIM; and a review of Collector for ArcGIS workflows. In addition, VESTRA is developing a multi-scale fire run book grid for the County. Most recently, VESTRA has been contracted to serve as the interim GIS Coordination. VESTRA is managing the County’s ArcGIS Online platform, and performing parcel/condo updates, NextGen 911 address upgrades, re cent wildfire mapping applications, and redistricting process.

Most recently, VESTRA has been contracted to serve as the interim GIS Coordinat or. VESTRA is managing the County’s ArcGIS Online platform, and performing parcel/condo updates, NextGen 911 address upgrades, recent wildfire mapping applications, and redistricting process.

Project: Various Contracts | Contract Duration: 2011-2019 Project: GIS On-Call Support | Contract Duration: 6/2021 - Present Responsible Personnel: Arthur Stackhouse, Project Manager / Sr. GIS Specialist Ryan Goodner-Belli, GIS Specialist

3. Yolo County, California
Mary Ellen Rosebrough-Gay, GIS Manager,
(530) 406-5004 | [email protected] The County of Yolo, California contracted with VESTRA to take over GIS initiatives surrounding the Covid-19 Pandemic. The project has consisted of taking over daily data entry for new cases that serve the County’s GIS-based dashboards. As a part of the project, VESTRA analysts worked with County staff to optimize data input by creating a semi - automated workflow to pull data into GIS and process according to the metrics that needed to be visualized on the dashboards. This has provided the benefit of reducing effort by County staff and data entry staff, and also provides more timely and accurate results to the public.

Project: GIS Emergency Operations Support Services | Contract Duration: 5/2020 - 6/2021 Project: GIS Emergency Operations Support Services | Contract Duration: 7/2021 – Present Responsible Personal: Clancy Finmand, GIS Analyst

Packet Page 355 of 1251Attachment 3 Page 99 of 120

City of Fairfield, California
GIS Services and Training

Page | 6

HOURLY RATES

EMPLOYEE NAME TITLE BASE
HOURLY
RATE

BENEFITS
(%)
DIRECT
COSTS
(%)
Includes
Benefits

INDIRECT
COSTS
(%)
Includes
Benefits

PROFIT &
FULLY
LOADED
TOTAL
Arthur Stackhouse Sr. Project
Manager
$50.14 23% 65% 31% $185.00
Arthur Stackhouse Solution
Architect
$50.14 23% 65% 31% $160.00
Ryan Goodner-Belli Project
Manager

37.00 23% 65% 31% $161.00
Ryan Goodner-Belli Sr. GIS Analyst $37.00 23% 65% 31% $114.00 Clancy Finmand Sr. GIS
Technician $21.00 23% 65% 31% $79.00
Kaitlyn Taylor Administrative
Assistant
$24.50 23% 65% 31% $67.00
Connie Ebinger Administrative
Assistant
$21.00 23% 65% 31% $67.00

COST OF DIRECT EXPENSES BY TYPE

DIRECT EXPENSE TYPE COST
Travel – Mileage $0.585 /mile or current IRS Rate
Travel – Lodging $96.00/night + taxes or Current GSA Per Diem Rate Travel – Meals and Incidentals $44.25 - $59.00 or Current GSA Per Diem Rate Subconsultant $94 - $147.00 / hour

NON -DISCLOSURE AGREEMENT
VESTRA has reviewed the Non-Disclosure Agreement provided as Appendix A to the RFP.

VESTRA has no proposed changes to the Non-Disclosure Agreement and is ready to sign the agreement as written upon award of the contract.

SERVICES AGREEMENT
VESTRA has reviewed the Consultant Services Agreement provided as Appendix B to the RFP.

VESTRA has no exceptions to propose and is ready to sign the agreement as written upon award of the contract.

VESTRA has reviewed the insurance requirements and will provide a Certificate of Insurance to the City upon aware of the contract.

Packet Page 356 of 1251Attachment 3 Page 100 of 120

City of Fairfield, California
GIS Services and Training

Page | 7

METHODOLOG Y FOR SERVICES

PROJECT UNDERSTANDING AND OBJECTIVES
The City of Fairfield, California (City) has a GIS that is well maintained and actively used. The City Community Development Department recognizes that it is now time to update its GIS Database to reflect the latest needs and goals of Development and Gener al Planning for the City using the latest data trends and advancements. The outcome of this department recognition should be a full GIS Database with Governance Documentation and Training for the appropriation of the City’s Community Development.

This GIS Data Service project is scheduled to work in conjunction with the City Master Plan (Location Strategy) effort. The VESTRA Team (VESTRA and FEC) all take pride in performing meticulous and high-quality work. Our solutions and planning processes are carefully tailored for the client’s specific needs, including all system integrations to keep the City GIS fluid between departments, in accordance with the collaborative City GIS Vision and Mission. We have found success and built a solid reputation based on thi s approach. It is hoped that the following knowledge, skills, and abilities will reflect the wants and needs of the City’s Community Development Department (CDD or Department).

SCOPE BASED KNOWLEDGE, SKILLS, AND ABILITIES
The following is the technical work experience and methodical approach that will be used toward meeting the City CDD goals and objectives. The manufacture of an advanced GIS Database for CDD purposes will be phased by process and technical milestones will each be presented as a reference appendix by letter following the core of the Location Strategy TASK 1: KICKOFF MEETING
A core effort in this process is to get to know the constituents. VESTRA’s team will begin the project with an up to two (2) hour kickoff meeting, with the City’s CDD project team. This meeting will be conducted as a conference call using GoToMeeting, Skype, or similar screen sharing software and is designed to review and confirm the project scope of work, schedule, and budget; and establish guidelines and reach an agreement on protocols for change control, communications, and project closing processes, as needed.

VESTRA will submit summarized meeting notes including any minor changes to scope, schedule or budget (if applicable), agreed upon protocols for change control, communications, and project closing processes (as needed) for review and formal acceptance by the City.

TASK 2 : DATA MIGRATION AND UPDATE

ORGANIZATIONAL DATA ASSESSM ENT
In this task, VESTRA’s team will gather information about the City CDD by evaluating day to day work flows and analyzing what the Department finds useful and how some contributions may improve the GIS data. This process will help gather preliminary inf ormation about the Department’s primary business objectives, business processes, workflows, existing data, and Packet Page 357 of 1251Attachment 3 Page 101 of 120

City of Fairfield, California
GIS Services and Training

Page | 8

applications used, along with needs and gaps in these areas. VESTRA’s team, will analyze information gathered during the research phase and prepare itself for the interview phase of the needs assessment.

The interview phase of this task may be conducted over two (2) days consecutive days on-site or in a virtual environment, if necessary. There may be another vendor selected for the GIS Master Plan, in that case it is assumed that follow up materials will be available, including verified reports of the specific department analysis. During this time VESTRA will have more specific and in-depth discussions with the primary individuals involved in the City CDD workflows. VESTRA will seek to build on the information already gathered and discover more about the existing situation, gaps, and future needs related to GIS. The discussions will be interactive where VESTRA will not only ask questions but seek to (as t ime allows) elicit feedback and ideas and contribute by relating examples from experience, industry trends and practices.

During the evaluation of the Department, VESTRA’s team will identify core datasets, nature of the data, how data is used, and applications, workflows, business processes and business objectives supported by the data. In addition, VESTRA ’s team will review the current enterprise geodatabase and layers within the City, and data maintenance to make a comparison to identify the gaps is usage or delivery so appropriate governance procedures may be developed and followed. Key business objectives and associated business processes being performed will be identified along with data workflows or applications that should be integrated or converted to a GIS base so that business processes are more efficient and effective, and business objectives are met.

During the Department evaluation, VESTRA’s team will identify opportunities where existing GIS staff can enhance support for data maintenance for business processes. In addition, VESTRA’s team will identify opportunities for training departmental staff with using GIS software and applications, as applicable, and allocate resources to promote efficient maintenance, accessibility, usage, and sponsorship of the GIS. The most important piece of this review is where each staff is getting data. Questions regarding communication with other departments and external sources will be evaluated to ensure a centralized data governance within the organization. Such an effort has been successfully conducted with the City of Elk Grove combining the services of VESTRA and FEC to accomplish the goals of the City.

COLLOCAT ION AND CENTRALIZATION OF USER DATA AND DOCUMENTATION With a direct point of contact, VESTRA’s team will setup a standard folder structure within the City’s environment (e.g. File Server) that will store all scanned CDD documents in an organized pattern. Documents will be stored in folders named after the plan types (e.g. building, grading, special use, etc.). Within each plan type folder, documents will be arranged by Drawing Number. User datasets will also be consolidated and collocated into a staging fil e geodatabase for import into the City IT GIS Enterprise. The City CDD has multiple core datasets related to the base for the City IT GIS Enterprise – Parcels. These features are always maintained by a City for interdepartmental visualization and county assessment purposes.

It is strongly recommended, that the Parcel Base is maintained in a Parcel Fabric Editing Environment so the associated CDD layers may be aligned on the specific ground object Packet Page 358 of 1251Attachment 3 Page 102 of 120

City of Fairfield, California
GIS Services and Training

Page | 9

assigned to that parcel. VESTRA’s team will conduct a full quality assurance of the current resources to maintain the associations between the Parcels and CDD asset and planning layers along with a gap analysis of the data transfer between the City and the County. This portion of the project is expected to be a large undertaking and will benefit from the VESTRA and FEC’s alliance experience from the City of Elk Grove but will also feature the explicit environmental planning and land development knowledge of Mr. Matt Fremont and Mr. Ryan Goodner -Belli and their associated abilities to provide priorities to this type of work.

LAYER DEVELOPMENT
During a combined meeting with the City IT and CDD, VESTRA’s team will also discuss the best path forward to house, develop, edit, and publish CDD GIS data. The VESTRA Team excels at data assessments. We provide a fully loaded data report that includes a data dictionary, verified metadata, ownership, currency, and limitations. The City has requested additional data governance within this report including update and maintenance r esponsibilities, and the levels of projected cost and effort to upgrade each layer to modern ArcGIS Pro or ArcGIS Online. The same product for the City IT GIS Enterprise will be delivered to the CDD as a data governance, with structure, schema, metadata, and associated best practices.

This portion of the project is expected to be an extreme undertaking and will benefit from the VESTRA and FEC alliance experience from the City of Elk Grove but will also feature the knowledge of Mr. Matt Fremont and Mr. Ryan Goodner-Belli and their associated abilities to provide priorities to this type of work. The example layers may include but are not limited to:

Character and Historic Preservation, Affordable Housing, Parcels, Land Use Designations, Zoning Districts, Special Districts, Residential Associations, Planned Use Developments, Subdivisions, Capital Improvements, Mass Transit, Interface Broadband Status, and American Disability Act Compliance. The nature of this data, how data is used, and applications, workflows, business processes and business objectives this data should support will be documented. In addition, VESTRA’s team will concurrently review the enterprise geodatabase and layers within the City, and data maintenance to make a comparison to identify the ga ps between IT and CDD to formulate the appropriate governance procedures to be developed and followed. It is assumed that if another vendor is selected that a report will have been furnished to the Department for review on this task.

The collocated file geodatabase will be transferred into the City GIS Enterprise with the appropriate user group and editing permissions for General Plan Update purposes. Each Layer will have an associated proposal layer to further institute a fluid General Plan process. To assist in this process VESTRA will provide capable GIS Technician level staff for on call editing and map production to make sure each layer is adequately represented in the GIS Enterprise.

TASK 3 : TEAM TECHNICAL ANALYSIS AND TRAINING

ORGAN IZATIONAL SKILLS ASSESSMENT
During a specified on-site or virtual day with the City CDD Staff, VESTRA’s team will conduct the evaluation of the CDD Staff and utilize the resulting information to develop a department data curriculum that easily transfers knowledge, skills, and abilities to sustain the City CDD GIS Data Packet Page 359 of 1251Attachment 3 Page 103 of 120

City of Fairfield, California
GIS Services and Training

Page | 10

for years to come. A gap analysis between ESRI standard training materials and the City staff training should be flexible as CDD documentation may incorporate tactical approaches and integrations above and beyond the commercial-off-the-shelf ESRI Suite. The knowledge basics for interview processes should be incorporated into the curriculum to allow the staff to find people with the appropriate knowledge and innovative thinking that contributes to a productive GIS institution. The base of the Curriculum will incorporate performance improvements, education about specific department integrations, and key communication points for emergency situations and disaster recovery planning. The resulting curriculum will be instituted into a GIS training directly available to CDD then available on the City IT Internal Portal. This training portal will also link to available training materials and courses available with an existing Enterprise Agreement. The goal of this portal and the current training to be provided by VESTRA is to provide key technical knowledge to maintain a GIS institution in the City for the overall support of a sustainable GIS Enterprise.

ORGANIZATIONAL SKILLS TRAINING
The City CDD will have up to four (4) days of hands on and conceptual training from VESTRA’s team, and we will also discuss the current governance structure for GIS. This may include, but is not limited to, the administration, maintenance and support of the Enterprise GIS data and CDD sublayers. This includes guidelines for data stewardship, data maintenance and data release procedures, quality assurance protocols, data publishing strategies, internal support procedures, security, and communications. A key part of this training is to facilitate background knowledge from ESRI Free Structured Online Courses because the knowledge, skills, and abilities of Mr. Fremont and Mr. Goodner-Belli are advanced in concept and will require such material to bring CDD Staff up to ideal GIS maintenance abilities, while developing a training process that is not overwhelming to users.

Separate evaluations will be performed for IT and CDD. The training sessions are anticipated to include (but not limited to): primary business objectives, current use of GIS, and how GIS can enhance and add value to their business processes. In addition, VESTRA’s team will use identified opportunities for training to shape the departmental staff training using GIS software and applications, as applicable, and allocate resources to promote efficient maintenance, accessibility, usage, and sponsorship of the CDD GIS priorities. The result of this study will be an integral training, support, and staffing structure that will encompass a data workflow that benefits the entire organization.

PROJECTED DELIVERABLES AND PROJECT ESTIMATES
The anticipated project deliverables are listed below.

Task 1 Kick Off Meeting Deliverables

1. Project kickoff meeting with formal introductions

2. Finalization of In-person/virtual Interview Strategy

3. High level summary of meeting notes, updated scope of work, schedule and budget (if applicable), agreed upon protocols for change control, communications, and project closing processes, as needed for proactive project flow and prevention of delays.

Packet Page 360 of 1251Attachment 3 Page 104 of 120

City of Fairfield, California
GIS Services and Training

Page | 11

Task 2 Data Migration and Update Deliverables

1. Organizational Data Assessment
a. Department Survey and Evaluation
b. Department Data Use Matrix
c. Gap Analysis

2. Document Import and Centralization
a. Core GIS Layer Collection (File geodatabase)
b. Collocation and Document Scanning (File Server)

3. Layer Development
a. Layer Structure and Editing Governance
b. Metadata, Schema, and Limitation Curriculum
c. Data Use Matrix
d. On-Call Editing and Mapping Services
Task 3: Team Technical Analysis and Training Deliverables

1. Organizational Skills Assessment

2. Organizational Skills Training
a. Provide Training for Current Staff using ArcGIS Pro and Data Management Best Practices
Task 4: Final Presentation Deliverable (OPTIONAL)

1. Final Presentation
a. Strategic Implementation Recommendations
b. Planning Reflections & Actions to Move Forward

2. Executive Summary

WORK BREAKDOWN STRUCTURE
The following is a work breakdown structure for the tasks and resources anticipated for this project. Work to be contracted out to subcontractors is detailed in the table below as well.

Packet Page 361 of 1251Attachment 3 Page 105 of 120

City of Fairfield, California
GIS Services and Training

Page | 12

SOFTWARE FORMAT FOR ELECTRONIC DATA DELIVERY
All Documentation will be delivered in PDF Format. A copy of the Location Strategy Final Draft will be submitted in MS Office Word for Project Roadmap Maintenance and Republishing for Transparency to the City Constituents. Technological deliveries include installed executables and associated ArcGIS products and licenses. Any applicable data shall be transcribed to the Enterprise Database or delivered by projected File Geodatabase for department utilization.

Description Staff Classification
1 Kickoff Meeting
Project Manager
Sr. GIS Specialist (Subconsultant)
Sr. GIS Analyst
Sr. GIS Technician
Admin
2 Data Migration and Update

2.1 Organizational Data Assessment
Assessment of Data / Documentation Filing Project Manager On Call Work Rate Sr. GIS Specialist (Subconsultant)
Sr. GIS Analyst

2.2 Document Import and Centralization
Collocation of User Documentation Project Manager
Document Scanning and Filing GIS Analyst (Subconsultant) Sr. GIS Technician

2.3 Layer Development
Layer Structure and Editing Development Project Manager Metadata/Field Editing Sr. GIS Specialist (Subconsultant) On-Call Editing and Mapping Sr. GIS Technician
Admin
Direct Costs (Travel)
3 Team Technical Analysis and Training

3.1 Organizational Skills Assessment Project Manager
Skill Assessment Interviews Sr. GIS Specialist (Subconsultant)

3.1 Organizational Skills Training Project Manager
ESRI Skills Training Sr. GIS Specialist (Subconsultant) Admin
Direct Costs (Travel)
4 Final Presentation (OPTIONAL)
Project Manager
Presentation and Materials Sr. GIS Specialist (Subconsultant) Admin
Direct Costs (Travel)
Packet Page 362 of 1251Attachment 3 Page 106 of 120

City of Fairfield, California
GIS Services and Training

APPENDIX A

APPENDIX A – FULL STAFF RESUMES

Packet Page 363 of 1251Attachment 3 Page 107 of 120

Experience Highlights
Over 30 years of experience
providing GIS training to clients

Advanced understanding of Esri
products, tools, applications, and
services.

Long-term experience with
management of complex project and
client relationships.

Track record of practical, innovative
solutions to environmental and GIS
problems

Education
Post Graduate Study
Economics and Management
University of Southern California

M.S.

Wildland Resource Sciences
University of California, Berkeley

B.S.

School of Forestry and Conservation
University of California, Berkeley

Arthur Stackhouse
President / CEO
Sr. Project Manager and Solution Architect

Arthur Stackhouse is the President of VESTRA Resources, Inc., and has over 44 years of experience in GIS database development, implementation of GIS concepts and best practices, computer- hardware configuration, and the design, development, and implementation of enterprise geographic information systems.

Early in Mr. Stackhouse’s career he worked as a forester for a major timber company in California, developing silvicultural prescriptions and supervising road construction, logging, and reforestation efforts. His interest in forest planning and mapping led to an opportunity to develop a GIS for the timber company’s holdings during the mid- 1980’s, and later led to his becoming responsible for Information Technology throughout the company. In 1988, Mr. Stackhouse and a small group of fellow employees started VESTRA Resources; one of the first GIS services firms in the United States.

At VESTRA, Mr. Stackhouse has acted in a variety of project roles, from Project Manager to Lead Analyst, and even Python Programmer. Mr.

Stackhouse has participated as a senior member of VESTRA’s enterprise GIS team on a wide array of projects including GIS implementations in Calaveras, Napa, Mendocino, Lake, Lassen, and Contra Costa Counties. He has also been actively involved with GIS implementations at the San Francisco Public Utility Commission, Sonoma County Water Agency, and the California Office of Statewide Health Planning and Development. Because of his experience, Mr.

Stackhouse provides senior level oversight and quality
assurance/quality control on many of VESTRA’s more complex projects. As the President of VESTRA, Mr. Stackhouse has overall responsibility for all projects undertaken by VESTRA, and coordinates the personnel, hardware, and software needed to complete each project.

In addition to his duties as President, Arthur has done an extensive amount of certified and custom training. For 20 years, Arthur was a successful certified Esri trainer before the partner training program was phased out by Esri in 2008. Arthur continues to provide custom GIS training to private clients and clients of all levels of government.

Representative Project Experience
Confidential Client, Formation Environmental
Arthur Stackhouse served as a Solution Architect providing subconsultant services to Formation Environmental to provide GIS training services to their confidential municipal utility client. The project involved developing curriculum and providing two training sessions for up to 20 attendees. The first training session, developed

Packet Page 364 of 1251Attachment 3 Page 108 of 120

Arthur Stackhouse

Page 2 of 6 ends

and conducted by Formation Environment, was for remote sensing technology, and focused training on shallow flooding wetness procedures and alternative remote sensing wetness procedures. The second training section, developed and conducted by Mr. Stackhouse of VESTRA, was for specialized training on the use of existing GIS technology tools and automation techniques for summarizing remote sensing data using ArcGIS and other toolsets. These training sessions were focused on empowering client staff to use remote sensing data in workflow and analysis tools.

VESTRA assisted Formation Environmental in the preparation of curricula, training materials, sample training data, and presentations materials for the Session Two Training on GIS Technology and Application, which included the following topics:
• GIS fundamentals using ESRI software (ArcGIS Pro) and data from client • Field data collection and field method workflows to publish and distribute data using ArcGIS Online/Collector/Survey123
• Geoprocessing models/scripts for repetitive tasks and analysis • WebGIS including workflows to publish and distribute GIS data for internal and/or external use (ArcGIS Pro/ArcGIS Online/Portal)
• ArcGIS JavaScript API used in LADWP's Web application development • 3D data and modeling using ArcGIS Pro/ArcGIS Online/Portal

GIS Strategic Plan, City of Sunnyvale, CA
Mr. Stackhouse was the Enterprise Architect for the City of Sunnyvale's GIS Strategic Plan project. The City has many departments that use and depend upon GIS for operations. The City also has a healthy GIS portal, but the City wanted to provide more end-user functionality and additional information to the public. The City contracted with VESTRA to complete a needs assessment and develop a GIS Strategic Plan.

VESTRA reviewed the current state, provided guidance on best practices, discussed future state options, and developed a strategic report covering all aspects of the City's current and future growth with regards to GIS.

Mr. Stackhouse assisted with the needs assessment and provided system integration oversight and design, participated in systems requirements gathering and enterprise architecture design, and translated business needs into solution architecture requirements. In addition, Arthur provided QA/QC for the needs assessment report and GIS Strategic Plan.

Enterprise GIS Strategic Plan, City of Cupertino, CA
Mr. Stackhouse was the Enterprise Architect for the development of an Enterprise GIS Strategic Plan for the City of Cupertino. With a good foundation in place, the City was looking to cast a vision and develop a strategy for how GIS could better serve the City by improving how it is used, implemented, leveraged and integrated as a technology and be highly visible within the organization over the next five years. VESTRA helped the City with a detailed roadmap and a phased implementation plan to meet City goals such as enhancing GIS service delivery with improved efficiency and effectiveness, expanding GIS accessibility and use, achieving a greater level of integration of the GIS with the City’s business systems, provide better support to City business processes, increase organizational awareness, visibility and department sponsorship for GIS, and implementing best in class GIS technology.

Mr. Stackhouse participated in the system requirements gathering and translated business needs into solution requirements. He provided expert guidance for the roadmap creation and helped align strategies to goals and visions. He also conducted QA/QC of the needs assessment report and GIS Strategic Plan for accuracy and completeness.

Packet Page 365 of 1251Attachment 3 Page 109 of 120

Arthur Stackhouse

Page 3 of 6 ends

GIS Strategic Plan and Implementation Services, City of Belmont, CA Mr. Stackhouse was the Enterprise Architect for the development of a three year Enterprise Geographic Information Systems (GIS) Strategic Plan for the City of Belmont. The City of Belmont had never developed a strategic plan for GIS; therefore, with GIS integrations and needs increasing, and with a focus on being progressive and providing better service to the employees and public, there was a desire to expand the use and availability of GIS throughout the organization. Mr. Stackhouse participated in the department interviews for the Enterprise GIS Assessment and provided guidance for system and architecture design for the GIS Strategic Plan.

Water Turn Off/On Field Application, City of Santa Maria, CA Mr. Stackhouse served as the Project Manager for the City of San Maria’s Water Turn Off/On Field Application. The City’s Department of Utilities Water Resources Operation and Maintenance Section was interested in improving their field crew’s efficiency by making information on disabling/enabling customer’s water service connections available online. Information on the status of the City’s water service connections were being maintained in a legacy system by the City’s Department of Administrative Services. The City had the capability of querying this system every thirty minutes, extracting address information for needed turn offs/ons, and sending this information to a Microsoft SQL table. Per the City's requirements, VESTRA developed an application that geocodes the addresses within this Microsoft SQL table and presents the results in an ArcGIS Online feature service making it available online and via mobile devices. This has enabled field crews the ability to access and edit the information from their smart phones utilizing Esri’s Collector for ArcGIS application. Mr. Stackhouse oversaw the entire project and provided guidance and QA/QC for the application development process to ensure that the application aligned with the City’s goals and visions.

Enterprise GIS Master Plan, City of Mountain View, CA
Mr. Stackhouse worked with the City of Mountain View to provide a needs assessment to determine the C ity of Mountain View’s current use of geospatial information and GIS technology, and to develop an effective guide for the City’s ongoing implementation of their GIS. This assessment included detailed recommendations with regard to development of a City-wide GIS management structure, transition to an Enterprise GIS architecture, development of a GIS Strategic (or Master) Plan, development and implementation of GIS Database Enhancement/Maintenance Plans, and overall recognition of City-wide staffing needs.

Cannabis Identification and Prioritization System, State Water Resources Control Board Mr. Stackhouse serves as the Project Manager on the Cannabis Identification and Prioritization System project for the State Water Resources Control Board (SWRCB). The Cannabis Identification and Prioritization System (CIPS), acts as both a repository of geospatial information on grow locations and a tool for helping the agencies prioritize their regulatory efforts based on the potential impact individual grows are having on water resources, fish, and wildlife. VESTRA, working with Formation Environmental, was engaged in the development of CIPS.

Formation Environmental captured grow locations and developed raster datasets of percent slope, length of slope, evapotranspiration and proximity to surface water. These raster datasets were used along with information on the proximity of threatened fish and wildlife to model the level of threat associated with each grow, allowing the agencies to establish priorities for action.

VESTRA was responsible for the design and development of the system. This project required the system to leverage the SWRCB’s existing Esri Enterprise system. The development effort included a JavaScript web interface to be used by agency staff tasked with regulating Cannabis cultivation. The web interface and geoprocessing services are used to model the environmental threat based on the factors a user chooses to consider in their analysis, and the weight they associate with each factor.

Packet Page 366 of 1251Attachment 3 Page 110 of 120

Arthur Stackhouse

Page 4 of 6 ends

The web interface includes a quick at-a-glance dashboard, map viewer, editor, and modeler. The Python geoprocessing scripts are used in CIPS to provide the analytical modeling framework for the application.

Some of the python geoprocessing scripts run nightly as a scheduled task and some are run directly by the web application. There are numerous scripts that make up the modeling framework; however, at the core the scripts in CIPS are used to estimate the environmental threat of individual grows, develop weighted averages of an environmental threat, generate heat maps, and generate summary statistics.

In addition to managing the project, Arthur developed the geodatabase design underlying the CIPS application and wrote the geoprocessing scripts that establish the potential threat of the grows to the environment.

Imperial Irrigation District – Salton Sea Air Quality Mitigation Program Support, Formation Environmental Mr. Stackhouse serves as the Solution Architect for the Salton Sea Air Quality Mitigation (SS AQM) Program Support project. The SS AQM Program was developed by the Imperial Irrigation District to provide a comprehensive, science-based, and adaptive approach to address air quality mitigation requirements associated with the transfer of conserved water under the Quantification Settlement Agreement. The transfer reduces the volume of agricultural return flow to the Salton Sea, thereby exposing the playa and increasing the potential for dust emissions that could affect nearby communities.

VESTRA worked with Formation Environmental to develop a Data Portal in the Amazon Cloud (AWS) that provides a centralized repository where the authoritative data developed in the project is stored. Mr.

Stackhouse developed the geodatabase design for the repository and worked with the developers to establish a map service framework that makes it possible to have data that is added to the repository be immediately available in Data Portal web application without requiring additional code. Mr. Stackhouse also developed the 3D cache database design used in the 3D viewer and participated in database design for the PI-SWERL applications.

By having all of the data available within a set of interactive web applications, the Imperial Irrigation District is able to visualize the effects of the playa over time and how this is affecting the air quality surrounding the Salton Sea. The web applications provide the ability for users to see the affects over time utilizing a time slider and create scientific predictions for what could happen in the future.

CAL FIRE Management Activity Project Planning Event Reporter (CalMAPPER) Web Map Application California Department of Forestry and Fire Protection (CAL FIRE) Mr. Stackhouse is the Project Manager for the CalMAPPER Application projects. The CalMAPPER and Re- Architecture projects involved adding functionality to CalMAPPER, an existing Web Map Application hosted by CAL FIRE. An ongoing effort has been underway within CAL FIRE to bring the department’s records from multiple resource management and fire prevention programs into a common database framework. The database framework has a spatial (GIS) component that facilitates mapping and monitoring of past project, assists in planning future program activities, and is readily available to emergency responders and resource management staff.

CAL FIRE Statewide CAD/AVL Roads Database, Northrop Grumman Mr. Stackhouse serves as the Project Manager for the CAL FIRE Statewide CAD / AVL Roads Database project for Northrop Grumman. VESTRA has extensive experience working with CAL FIRE data converting county roads feature classes to roads feature classes, the new roads features classes conform to the Altaris CAD’s requirements. For this project, VESTRA has developed an extensive library of over 100 Python scripts to programmatically address the common data errors in dispatch systems and the formatting needs necessary for incorporation into CAL FIRE’s CAD / AVL Roads Database. In addition to managing the project, Mr.

Packet Page 367 of 1251Attachment 3 Page 111 of 120

Arthur Stackhouse

Page 5 of 6 ends

Stackhouse developed the majority of the scripts used by CAL FIRE and provided multiple knowledge transfer sessions with their staff.

eWRIMS—State Water Rights Information System, California State Water Resources Control Board The Web-based Enhanced Water Right Information Management System (eWRIMS) was developed to track information on water rights in California. eWRIMS contains information on water right permits and licenses issued by the State Water Board and other claimed water rights. eWRIMS is also a module of the State Water Board’s California Integrated Water Quality System (CIWQS) program. Arthur and his team developed a Web- based interactive mapping application which allows Water Board personnel to collect place-of-use data while in the office or field, supporting water right application and processing, and provides the following capabilities to the State Water Resource Control Board, Division of Water Rights: 1) Real-time access to water Packet Page 368 of 1251Attachment 3 Page 112 of 120

Arthur Stackhouse

Page 6 of 6 ends

Packet Page 369 of 1251Attachment 3 Page 113 of 120

Experience Highlights
Experienced with field data collection
solutions

Experienced in providing GIS
Mapping and emergency GIS Services

Long-term experience with legal
descriptions and CAD Map Drafting,
supplemented with Land Surveying
Techniques

Experiences with Revenue and
Taxation Code

IT-Backend support knowledge in
Microsoft SQL and Python.

Education

B.S.

Geography
Oregon State University
Corvallis, Oregon

Professional Certification in
Geographic Information Systems
Ryan Goodner-Belli
Project Manager and Senior GIS Analyst

Ryan Goodner-Belli is a Senior GIS Analyst / Project Manager for VESTRA. Ryan has over 21 years of technical Geographic Information Systems knowledge and experience; 11 years applying his GIS experience in a professional capacity. His work attributes incorporate Environmental Analysis, Municipal Planning, Public Safety, Local Government Infrastructure, Parcel Fabric Management, and ESRI System Administration.

Goodner-Belli has developed a strong working relationship with the California Assessor Community.

Staff Training and Data Maintenance, City of Gonzales, CA Mr. Goodner-Belli has maintained responsive training for two intern staff members with the City of Gonzales Public Works Department. Mr.

Packet Page 370 of 1251Attachment 3 Page 114 of 120

Ryan Goodner-Belli

Page 2 of 2 ends

Fairfield City CouncilAugust 16, 2022

Fairfield City Council
August 16, 2022