HomeMy WebLinkAboutTimmons Group - GIS Data and Database Architecture and Data Maintenance Health Check
Contact: Mike Wiley, Project Director
1001 Boulders Parkway, Suite 300, Richmond, VA 23225
917.848.6504 phone | mike.wiley@timmons.com www.timmonsgis.com
GIS Data and Database Architecture and Data Maintenance Health Check
City of Bozeman
Date Due: January 15, 2021
Strategic Planning | Solution Architecture | Application Development | Cloud Services | Managed Services | Data Management
1001 Boulders Parkway Suite 300 Richmond, VA 23225
P 804.200.6500 F 804.560.1016 www.timmonsgis.com
January 15, 2021
Mike Maas, City Clerk City of Bozeman PO Box 1230 Bozeman, MT 59771-1230
RE: GIS Data and Database Architecture and Data Maintenance Health Check
To continue advancing the value of its GIS Department, the City of Bozeman has recognized the need to implement best practices for data maintenance and performance. As a multi-disciplinary engineering firm that offers more than 28 years of geospatial based technology solutions consulting experience for industry and government, Timmons Group is ideally qualified to assist the City with this project. Ourstaff consists of more than 110 professionals with a broad range of subject-matter expertise across all areas of IT and GIS technologies. Many of these staff members currently support our clients in designing, implementing, and supporting Esri GIS architectures.
Timmons Group has earned Esri Gold Business Partner status. We are also an Esri Release Ready-certified firm, illustrating that we are experienced with Esri’s latest offerings and follow their best practices. We have evaluated, designed, implemented, and supported more than 2,500 Esri-based GIS solutions for satisfied clients in 48 states. We have a corporate emphasis on client satisfaction that is demonstrated through 65+ years of business. No two clients are exactly alike, and we work to create unique and engaging experiences for each one.
Timmons Group provides unmatched value to our clients. Consider the following as you make this important decision:
• We offer strategic planning that often includes support for architecting Esri software and complex environments
• We have deep experience in setting up complex Esri architectures, including Portal, Hub, and Enterprise sites
• We have FME, Esri and AWS Certified staff
• We have a pedigree of successfully supporting clients for multiple years in a managed-services model
• We are a leading and award-winning Esri GIS Business Partner
• We are a two-time Esri Foundation Partner of the Year
• We are an Esri Business Partner of the Year
• We have received the Esri Special Achievement in GIS award for projects executed with multiple clients, most recently in 2020
We appreciate your consideration and hope to work with you. If you have any questions about our proposal or would like additional detail, please contact me directly at 917.848.6504 or Mike.Wiley@timmons.com.
Sincerely,
Mike Wiley | Project Director
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
TOC
TABLE OF CONTENTS
A) Executive Summary ............................................................................................................................................................ 1
B) Firm Profile ......................................................................................................................................................................... 2
C) Description of Proposed Solution ....................................................................................................................................... 3
Phase 1: Project Initiation .................................................................................................................................................... 3
Kick-off Meeting ............................................................................................................................................................... 3
Phase 2: Technical Discovery ............................................................................................................................................. 3
Phase 3: Technical Recommendations ............................................................................................................................... 4
D) Scope of Project ................................................................................................................................................................. 6
E) Related Experience with Projects Similar to the Scope of Services .................................................................................. 7
F) Statement of Qualifications ............................................................................................................................................... 10
Support Gis Enterprise Foundation ................................................................................................................................... 10
Develop and Document GIS-Related Workflows and Best Practices ............................................................................... 10
Evaluate Existing City GIS Implementations For Obsolescence, Upgrades or Elimination .............................................. 10
Perform Data and Spatial Analyses .................................................................................................................................. 11
Systems Integration ........................................................................................................................................................... 11
Develop Applications (Including ArcGIS Online and Portal) ............................................................................................. 12
Develop Apps And Maps With ArcGIS Online and Arcgis Portal ...................................................................................... 14
Prepare Maps Using Arcgis Desktop or ArcGIS Pro ......................................................................................................... 15
G) References ....................................................................................................................................................................... 17
H) Present and Projected Workloads .................................................................................................................................... 18
I) Key Personnel .................................................................................................................................................................... 19
J) Price Proposal ................................................................................................................................................................... 25
K) Additional Information ....................................................................................................................................................... 26
L) Affirmation of Nondiscrimination and Equal Pay (Appendix B) ......................................................................................... 29
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
1 | Page
A) EXECUTIVE SUMMARY
We are proposing three phases to complete this project as detailed in Section C below: 1) Initiation; 2) Discovery; 3 Recommendations.
We can complete this project in as soon as five weeks, depending on the availability of City staff throughout the project. A schedule will be developed in coordination with City staff during contract discussions.
Our proposed project team includes three technical staff members, each of whom brings their own strengths that are necessary for a successful project. If, for some reason, additional staff or skillsets are required during the project, we have more than 100 technical GIS/IT staff available. Our proposed project manager, Andy Fox, is a PMP and we have also supplied a free resource, Mike Wiley, for this project.
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
2 | Page
B) FIRM PROFILE
WHO WE ARE
Timmons Group is a well-established professional consulting firm with more than 700 employees, providing information technology and geospatial consulting services to public and private clients throughout the U. S. and Canada since 1953. 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 conservation and providing solutions to further the sustainment of the environment and our shared natural resources. Our Technology group has the experience and capability to provide a wide range of services:
OUR MISSION
To achieve unparalleled understanding of our
clients, their businesses, and their visions,
resulting in unrivaled customer service and shared
success.
PLANNING
• Requirements Definition
• Strategic Planning
• Implementation Planning
DEVELOPMENT
• Application Development
• Data Conversion
• Field Data Collection
• Mobile and Web Development
• System Integration
DESIGN
• Infrastructure Design
• Database Design
• Data Model Design
• Application Design
• GIS Infrastructure Design
IMPLEMENTATION
• Installation
• User and Admin Training
• Support
16 OFFICES NATIONWIDE:
• Virginia (8)
• North Carolina (4)
• Washington, DC
• Maryland
• Texas
• Arizona 7 FIELD OFFICES
• Portland, OR
• Golden, CO
• Carson City, NV
• Cedar Rapids, IA
• Jefferson City, MO
• Atlanta, GA
• Jonesborough, TN 110+
DEDICATED
GEOSPATIAL
STAFF
PROPOSAL CONTACT Mike Wiley, Project Director _______________ 917.848.6504
mike.wiley@timmons.com
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
3 | Page
C) DESCRIPTION OF PROPOSED SOLUTION
PHASE 1: PROJECT INITIATION
Project Initiation sets the stage for all downstream activities and tasks. This is the time to better define the overall goal of the project and what stakeholders hope to ultimately gain from the effort. During this initiation task, it is also important to define who will be working on the project, their respective roles, and who will make business decisions and establish priorities for what ends up in the application. Having a “Product Owner” is extremely important in the process. This first step in the process is typically not time intensive – but very important throughout the project. By having clearly defined roles, the project team can minimize inefficiencies and streamline the requirements gathering and decision-making process.
On notice to proceed, we will convene an internal Timmons Group team meeting to ensure the entire project team understands the overall goals of City of Bozeman’s project and what the project schedule is. Our Project Manager will be in contact with the City’s Project Manager to discuss the kick-off meeting agenda and project schedule. Timmons Group will draft a kick-off meeting agenda for the City of Bozeman review and editing. Our Project Manager will also provide a detailed project plan to include phases, tasks, task dependencies, and task durations prior to the kick-off meeting.
Kick-off Meeting
The kick-off meeting will be organized by the Project Manager and will include participation from Key project stakeholders and client staff. We will:
• Introduce the Timmons Group and City teams
• Review Overall Project Goals/Objectives
• Review Project Roles and Responsibilities
• Determine the Communication Plan
• Determine the Status Meeting cadence
• Discuss content for Status Reports
• Determine the team collaboration site
• Review the Project Plan and milestones
• Discuss the Change Management process
• Discuss the invoicing process
• Review the list of project deliverables
• Gather existing technical documentation
• Determine action items and next steps
Our Project Manager will create the kick-off meeting summary notes for the City of Bozeman’s review and comment before
finalizing these notes. Additionally, the following will be created, modified, and then finalized:
Project Repository – If the City does not have a preferred project repository, Timmons Group will set-up a project repository
to store project deliverables, status reports, meeting minutes, work plans, change requests, decision requests, deliverable acceptance forms, and other project documentation as determined with the City.
Project Plan – After the kick-off meeting, our team will make any necessary adjustments to the project plan. This may include the identification of new tasks, changed dependencies or changed task durations.
Status Report Template – We will develop a status report template after the kick-off meeting to ensure that the City will receive comprehensive project updates.
PHASE 2: TECHNICAL DISCOVERY
Technical Discovery will involve accessing data sources by conducting a thorough review of GIS geodatabases (Enterprise and File), along with Web Hosted GIS Layers. This review will document key details and assist in
considerations for recommended improvements of the City’s GIS resources throughout the GIS Program. The goal of this phase is to acquire as much information as possible about the existing GIS data resources. By assuring each data source
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
4 | Page
is identified and documented, recommendations for improvements will be directly related to the detailed source information gathered during this phase.
Geodatabase review will focus on the following items of geodatabase components:
• Data domains
• Feature Classes and attributes
• Tables and attributes
• Existing Relationship Classes
• Geometric Network(s)
• User account level access to the geodatabase(s)
• Data Editing versioning controls
• Geodatabase data management automation and activities
• Current performance metrics
By documenting the details of each geodatabase’s existing usage and data management practices, a clearer picture will begin to develop, which will help determine recommended improvements for geodatabase design, function, and performance. If, during discovery, it is found that certain datasets require specific functionality geared towards field data collection, recommendations may center around migrating the data to a web hosted feature layer for ease of data management following field data collection best practices while use the WebGIS platforms (ArcGIS Enterprise / ArcGIS Online).
Web GIS Layer review will focus on both hosted and non-hosted GIS layers. With the web platforms, discovery will identify the different types of hosted and non-hosted layers and document them in detail. Timmons Group will also document detailed information of each data layer (hosted and non-hosted) to the effect of collecting the following information for each:
• Storage location within the web platform (Data Owner)
• Existing sharing configuration
• Current Metadata standard
• Data dependencies
• Web map and app inclusion of the data
Potential GIS data integrations review will focus on identifying any datasets participating in other software application integrations. This means determining which GIS datasets are being used in other applications and how they are being integrated currently. The following discovery items to be delivered from this review are:
• List of non-GIS applications integrating GIS data sources
• List of GIS data sources being used by other non-GIS applications
• Identification and documentation of workflow processes involved for integrating GIS data.
The final Technical Discovery deliverable will include all documentation from each of the tasks in this Phase.
PHASE 3: TECHNICAL RECOMMENDATIONS
Technical Recommendations will begin by referencing the items identified from the Phase 2 Technical Discovery. Each of the items discovered will then be compared to industry best practices and proven methods of improvement by the Timmons Group GIS team. The recommendations from information gathered during the discovery will focus on the following four areas:
• Geodatabase Design, Management and Performance Recommendations
• GIS Data Usage Best Practice Recommendations
• GIS Integration Recommendations
• GIS Client Software Migration Recommendations
Geodatabase Design, Management, and Performance Recommendations will center around geodatabase data model, data management, and performance improvement best practices. Data models come in a variety of flavors depending on the organization’s needs.
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
5 | Page
Based on the usage of the geodatabase GIS datasets, a database design consistent with industry best practices will be recommended. Documentation of the design will be drafted and reviewed for approval before any implementation of the design occurs.
Geodatabase Management recommendations will be determined based on various usage and database size metrics. Once determined, recommendations of industry best practices for automating data management tasks will be introduced and reviewed with the City staff. Upon approval, implementation of data management automation tasks will then proceed.
GIS Data Usage Best Practice Recommendations focus on guidelines of when to use various GIS format data types based on specific scenarios. For example, in use GIS data for WebGIS platforms, many organizations use their internal ArcGIS Enterprise platforms for using their data available to internal users only while sharing data from the internal platform to their ArcGIS Online platform for public access. This is called a Hybrid approach to data usage and sharing methods. The recommendation around data usage will be based on data workflows identified during the Technical Discovery phase. Use Enterprise data from a geodatabase is best suited for data not to be used for data collection in the field whenever possible as it requires much more data management. On the other hand, data used for field collection is managed very efficiently in a WebGIS hosted environment. Recommendations for data integrity and usage will determine the platform best suited for the stored GIS data format.
GIS Integration Recommendations
Integrations with non-GIS software vary to a wide degree dependent on the non-GIS software’s capabilities to accept GIS data. Since most geodatabase data is stored in a relational database management system (RDBMS), the geodatabase format is compatible with most non-GIS database system driven applications. Some of these applications will allow for a direct connection to the GIS geodatabase while others will require a data export-import process. For those applications requiring an export-import process, Timmons Group would recommend use a tool such as Feature Manipulation Engine (FME) software to perform regular conversions of identified processing of data discovered during the Technical Discovery Phase. Timmons Group’s recommendations will be dependent on the type of integrations with other non-GIS software applications required as the software is identified, and processes are documented.
GIS Client Software Migration Recommendations
It is understood that the City intends to migrate from ArcGIS Desktop to ArcGIS Pro in the very near future. Timmons Group highly recommends doing so as early as possible and has planned many migrations for a variety of other clients while use some best practices provided by Esri as well as lessons learned from the Timmons GIS team. Dependent on the tasks required and various functionality involved in performing GIS work, there are standard tools for migrating from ArcGIS Desktop to ArcGIS Pro.
In addition to providing services for migrating clients from one software to the other via COTS tools, Timmons Group also has experience in providing direction for ArcGIS Pro training to assist in becoming familiar with the differences in workflows between ArcGIS Desktop and ArcGIS Pro.
Migrations from ArcGIS Desktop to ArcGIS Pro can also be accomplished use automation processes through various GIS coding methods. This will be a recommended method whenever possible as it provides with the most efficient and timely results for beginning to use ArcGIS Pro exclusively throughout the organization and at the same time being able to retire legacy ArcGIS Desktop functionality as the software platform reaches maturity.
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
6 | Page
D) SCOPE OF PROJECT
The following summarizes the proposed deliverables by project phase:
Phase 1 (Initiation) – This phase will have the following five deliverables:
1) Kick-off Meeting Agenda
2) Kick-off Meeting
3) Kick-off Meeting Summary
4) Project Plan
5) Project Collaboration Site
Phase 2 (Discovery) – This phase will have four deliverables:
1) Multi-sheet spreadsheet detailing the information for each geodatabase and WebGIS layers as detailed in the section above (Draft/Final iterations)
2) Information about the integrations as detailed in the section above will be encapsulated in Lucidchart or Visio diagrams (Draft/Final iterations)
3) These spreadsheets and diagrams will be accompanied by a MS Word document providing a narrative summary of the data and integration (Draft/Final iterations)
4) PowerPoint summarizing the Discovery findings (Draft/Final iterations)
Phase 3 (Recommendations) – This phase will have three deliverables:
1) Lucidchart or Visio diagrams (Draft/Final iterations)
2) MS Word Narrative of our Recommendations (Draft/Final iterations)
3) PowerPoint summarizing the Recommendations (Draft/Final iterations)
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
7 | Page
E) RELATED EXPERIENCE WITH PROJECTS SIMILAR TO THE SCOPE OF SERVICES
Enterprise GIS Planning, Migration, Consulting, and ArcGIS Online Portal | City of Forest Grove, OR Contact: Gretchen Roberts, IT Manager | 604.501.9985 | groberts@forestgrove-or.gov
Project Dates: October 2015, support is ongoing Project Description: 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 ArcGIS Online capabilities. The City initiated this effort with a GIS RoadMap project executed by our team. Based on the outcomes and recommendations 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 current provides ongoing support for the City and their 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 use 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 9-month timeframe in order to encapsulate future additions and next steps in the Fiscal Year 2016-17 budgeting process.
Enterprise GIS System Consulting and Development | Fairfax Water Authority, VA Contact: Ian Stack | 703.289.6315 | istack@fairfaxwater.org
Project Dates: 2009-2013, support is ongoing Project Description: Fairfax Water (FW) contracted with Timmons Group to plan, develop, and implement an enterprise GIS to support utility operations that leveraged existing data and IT
infrastructure the extent possible. This included requirements gathering, GIS data modeling, migrating existing AutoCAD-based mapping system to an ESRI-based Enterprise GIS, and
providing technical support. The Enterprise GIS was designed taking into account the future needs of SAP, SCADA, and asset management enterprise systems integration. The project was organized into three phases. Phase 1 – Planning –Requirements Gathering, Solution Design, Solution Prototyping and
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
8 | Page
Testing.
• Discovery of existing mapping systems, infrastructure, and applications that require migration
• Situational Analysis Documentation
• Information Product Descriptions for Data Management Products, Systems Integration Solutions (Web Services, etc.), ArcGIS Server Web Applications, ArcGIS Server Mobile Applications, Data Interoperability Solutions
• IPD Priority and Cost/Benefit Documentation
• System Design/Functional Specification Documents
• WUDM Data Model Development and Geodatabase Prototype
• Pilot Conversion Prototype and Data Mapping Matrix (ETL)
Phase 2 – Development. Full CAD to Geodatabase Conversion;
• Water Service Address Conversion
• Enterprise System Implementation (hardware, software, networking)
• GPS inventory planning and oversight
• Data management tool implementation
• Mobile Maintenance and Inspection Applications
• Enterprise Intranet viewing and analysis applications
• Main Break Database application
Phase 3 – Data Conflation and Support. Ongoing improvement of spatial accuracy and system support.
• Data conflation (adjustment) of data location to newly collected GPS locations
• End user applications maintenance and upgrades
• Ongoing Enterprise GIS support, as needed
GIS Planning and Development | City of Fayetteville, NC Contact: Jessica VanHoozer, GIS Manager | 910.433.1721 | JVanHoozer@ci.fay.nc.us Project Dates: 2013–2015, support is ongoing Project Description: The City of Fayetteville (City) was looking to upgrade its existing GIS system to an Enterprise GIS to support future and current needs. The City contracted with
Timmons Group to:
• Perform a formal review and analysis of existing spatial datasets held by the GIS/IT supporting the City
• Perform a needs assessment for GIS in support of the pending Asset Management and permitting and Inspection projects
• Perform data conversion and cleanup for existing datasets into the new system
• Provide recommendations and procedures for collection of additional features identified in the needs assessment (data gaps), developed specific data models, tools
• Provide maintenance strategies to support the development of the EGIS use Esri’s Data Model templates and Local Government Data Model options for identified layers needed to support City-maintained GIS data related to General GIS, Asset
Management, Permitting, and Inspection tasks
• Provide recommendations for workflows to improve and maintain needed GIS feature
classes and infrastructure elements and provided quality assurance/quality control
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
9 | Page
(QA/QC) guidance and procedures for use during data conversion and ongoing
maintenance
California Department of Transportation (Caltrans), CA Contact: Harold Feinberg, Chief | 916.654.6585 | Harold.feinberg@dot.ca.gov Project Dates: June 2017, support is ongoing
Project Description: Timmons Group was selected to help Caltrans establish new data management best practices within its geospatial Services Oriented Architectures (SOA). Caltrans is seeking to organize its GIS 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 GIS that will improve 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
• Provide 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 the Agency’s financial and calendar parameters
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
10 | Page
F) STATEMENT OF QUALIFICATIONS
Timmons Group’s professional experience and qualification align well with the City’s needs for this project and more. The following is a summary of our relevant qualifications.
SUPPORT GIS ENTERPRISE FOUNDATION
Timmons Group can support the City’s enterprise foundation for FME, Esri Enterprise configurations, infrastructure (on-premise or AWS/Azure) support and migration (if needed), enterprise data management, FME and scripting (Python, R, etc.) as needed. The sections below provide more detail about these individual service offerings.
DEVELOP AND DOCUMENT GIS-RELATED WORKFLOWS AND BEST PRACTICES
Timmons Group helps organizations with workflow process optimization, data capture automation, records digitization/indexing, 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 (see below for details).
EVALUATE EXISTING CITY GIS IMPLEMENTATIONS FOR OBSOLESCENCE, UPGRADES OR ELIMINATION
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 provides the unique ability to understand your vision and offer a solution tailored to your mission-critical business requirements. We are geospatial technology experts that care deeply about the mission of local governments and providing solutions that enhance their 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.
These RoadMap exercises can be scaled up or down depending on the City’s budget or desire to even conduct this task. Should the City be interested in conducting a formal RoadMap project, our typical tasks and outcomes are:
• Collection and Review of Existing Documentation – In this task, we review the City’s existing GIS organizational, system architecture, and process management documents. Process management documents include standard
operating procedures (SOP’s) for GIS and asset management activities like system and data governance, data editing/updates, data quality review, data archiving, creating new GIS layers, creating and maintaining metadata, delivering data and metadata to staff and to the public via the internet. Tat the City may not have a lot of these processes formally documented – which is not uncommon. The purpose is to gather as much background
information as possible before engaging staff and to lay the foundation for topics to be addressed during the interviews. Our goal will be to maximize time spent with your staff, and the better prepared we are for the meetings,
the more productive they will be.
• Stakeholder Interviews – We conduct interviews with the key stakeholders are conducted to collect information and provide a knowledge transfer opportunity. The goal is to provide a forum for information exchange between the City and Timmons Group. City stakeholders will have an opportunity to learn more about how GIS is successfully implemented and used by their peers. Timmons Group will gain an understanding of the City’s relevant business requirements, data, existing systems, existing work processes, and future business requirements.
• Evaluation of Current System Architecture – Following completion of the information gathering and review steps, we evaluate the current system and document requirements and opportunities for enhancing system components related to:
o Non-functional requirements, constraints, standards, and policies
o Business Drivers and long-term vision
o Data architecture
o Application architecture
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
11 | Page
o Capacity planning
o Security model
o User workflows
o Technology architecture
o Web site
• Systems Architecture Report – The system architecture component requirements from the previous assessment task are compiled and organized into a comprehensive and detailed report that identifies City’s priority needs and opportunities related to:
o Business Architecture
o Data Architecture
o Application Architecture
o Technology Architecture
o Security Architecture
• Future System Definition – Recommendations formalized in this process will ultimately make up the GIS RoadMap Implementation Plan. Since the identified needs and recommendations may exceed available financial and staff
resources, it is critical that our team collaborates with the City to develop metrics to prioritize the recommendations. This prioritization process ensures that all users share a common expectation with respect to priority business
needs, delivery schedule, cost, and rationale for prioritization. This evaluation will be used at a high level to support the development of the Implementation plan and phasing of initiatives emerging from the plan.
• RoadMap Implementation Plan – The purpose of this final task is to develop RoadMap projects that, when implemented, will deliver the recommendations developed in previous Future System task. Project timelines and budgets are developed and presented for each RoadMap project so that our GIS RoadMap Implementation Plan will provide a comprehensive approach for more efficiently and effectively use GIS as a key business system within the City.
PERFORM DATA AND SPATIAL ANALYSES
We not only capture, store, and manage data, we also help our clients to bring value from their data through our evolving data analytics practices. We use SQL, Excel power query, R, Python and other methods of data analysis and we will consult with the City’s staff to ensure we have the “right tool for the job”.
On the proprietary data visualization front, we have experience working with the full range of Esri products. Additionally, we work with Microsoft Power BI and Tableau.
SYSTEMS INTEGRATION
Timmons Group has extensive experience with integrating GIS and non-GIS (legacy) systems. System integration can be done use several different methods, depending on the business need and legacy system capabilities. These methods range from a periodic data file download/upload exchange to a fully automated transaction-level exchange where systems are updating each other’s data on continuous basis.
Our proposed project team includes staff members with recent experience in integrating GIS and non-GIS (legacy) systems on several high-profile projects. The resulting integrated business solutions provide access to spatial and business information on the desktop and mobile environments. Examples include:
• Tyler Technologies – Timmons Group has integrated Cityworks and Tyler Technologies EDEN and Munis software for multiple clients. Our recent experience includes:
o Auburn, AL where we implemented four crucial interfaces between Tyler’s Munis (PayPros) for Point of Sale credit card processing and Laserfiche (or MS SharePoint) document management.
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
12 | Page
o Alpharetta, GA where we implemented a fully integrated system for its Work Management and Compliance needs. It includes GIS-based computerized maintenance management system (CMMS) implementation leveraging the newest release and technology from Azteca Cityworks and integrating with the City’s Tyler Technology Munis Financial and Utility Billing system, SeeClickFix for public reporting of needed repairs, ACS Firehouse for Fire Permit Management, and ePlan for online filing of designs for permit applications.
• Financial Systems – integration of GIS, Cityworks and financial systems information to support client billing and collections.
• Asset Management – Fairfax Water – integration of GIS and asset data to support asset management, maintenance, and modeling.
• CAMA integration of GIS and parcel data to support parcel management and local government operations.
• NVRRCL – NoVA PSAPS – integration of GIS and roadway data to support regional routing of emergency service vehicles. The resulting data was consumable by all the major PSAP software packages.
• SMART – US Forest Service, integration of GIS and land stewardship planning and management in a mobile environment, used throughout the USA.
• CG1V – US Coast Guard – Integration of Spatial and business data in a web-based environment to support all US Coast Guard mission areas worldwide.
DEVELOP APPLICATIONS (INCLUDING ARCGIS ONLINE AND PORTAL)
Timmons Group has more than 25 years of experience developing GIS applications for organizations in local, regional, state, and federal government. 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’ve 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 delivering GIS applications and solutions to government agencies around the country that no other firm
can bring to bear.
Figure 1: Integration Example: Tyler Technologies to Cityworks Integration
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
13 | Page
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 use 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
o ArcGIS Desktop
o ArcGIS Mobile
o ArcGIS Online
o ArcGIS Portal including ArcGIS Enterprise Sites
o ArcGIS Hub
o ArcGIS Server
o ArcGIS Web App Builder
• Custom Native Mobile Applications Design and Development
o Android
o iOS
o 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
o Test Strategy Design
o Test Plan Design
o Test Case Management
o Data QA/QC
o Software and Solution QA/QC
• Application Maintenance and Support
o Application Maintenance via Regular Maintenance Cadence
o Dedicated Staff for Tier 1 End-User Support
o Tier 2, 3, and 4 Technical Application and Solution Support
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
14 | Page
DEVELOP APPS AND MAPS WITH ARCGIS ONLINE AND ARCGIS PORTAL
The Timmons Group team typically uses a modified Agile approach for GIS application development and implementation. This enables the efficient and timely project delivery and provides flexibility when requirements and design are not known with certainty or completeness at the project start. Adopting the Agile techniques means that the application will be built in prioritized, successive iterations (called Sprints), each of which produces functional product slices for a client to review. The benefits of this approach include:
• Quicker delivery of functionally sound (usable) application components
• Highly visible product development progress via reviews (aka – Sprint Reviews)
• Frequent validation of the product, as being on the right track with stakeholder needs and expectations
• Higher quality product owing to continual feedback, review, and guidance
Process and Tools Our experience gained over many years has allowed Timmons Group to mature our process for application delivery and
support. A key area we have focused on is our testing and QA/QC process. Timmons Group has a dedicated testing and QA/QC team. This team is matrixed across projects and focuses on the:
• Developing and refining test cases
• Documenting, prioritizing, and validating bugs
• Creating regression tests for new and subsequent product releases
• Developing tools and procedures for testing
Our QA/QC staff work with the developers (web, mobile, and desktop) daily to test and approve all deliverables before the end of the Spring. They work closely with the clients, and their dedicated testers, to conduct user acceptance testing (UAT) at the end of each two-week Spring. Based on the results of the UAT, QA/QC staff members work with clients to report bugs, obtain general feedback, and add items to the backlog (enhancement requests, etc.).
The process flow across the two-week Spring iterations includes:
• Conducting a 15-day UAT (client)/regression (Timmons Group) testing period prior to go-live to fix any existing issues and accept all deliverables for production release (this can be negotiated to be longer or shorter depending on client needs)
• Prioritizing and incorporating fixes for any bugs found during UAT into the next Spring (keeps team focused on current Spring goals)
• Using Pivotal Tracker for bug tracking and providing Excel or Google Sheet exports for client review/tracking
• Providing release notes (list of functionalities tested, accepted, and ready for client testing), list of outstanding known issues, and test cases with each UAT release to the client to use during testing
Using two-week iterations for product delivery allows the client to sign-off on functionality which flows directly into milestone billing and progress reporting. Frequent delivery, coupled with internal Timmons Group and client testing, provides exceptional transparency into project progress, and minimizes surprises and missed expectations.
ArcGIS Online Specialty
Timmons Group has an Esri ArcGIS Online Specialty designation from Esri as a firm. Also, we have staff that are recognized for their expertise in administering both the ArcGIS Online and ArcGIS Enterprise platform. This specialty recognizes our proven ability to assist clients with the set-up and implementation of data, mapping services, web maps, and the resulting applications.
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
15 | Page
Our ArcGIS Online and Portal implementation strategy includes:
• Defining users (internal and external) and documenting their needs
• Performing ArcGIS architecture design for hosted and/or local implementations
• Specifying the system technology stack requirements for dev, test, and prod (as needed)
• Sizing and specifying ArcGIS server, including:
o Portal for ArcGIS server
o Web Server
o Portal Hosting Server
o ArcGIS Data Store (Relational and Tile Cache) server
Our ArcGIS Online and Portal implementation steps include:
• Installing Portal for ArcGIS sites
• Installing ArcGIS Server sites as Portal Hosting Servers
• Installing and configuring of ArcGIS Data Store as Data Store Servers
• Installing and configuring Web Adaptors for Portal sites and Portal Hosting Servers
• Federating the Portal Hosting Servers with the sites
• Configuring Enterprise Identity on Portal for ArcGIS sites
ArcGIS Hub Specialty
Timmons Group is one of only 10 firms that holds an Esri ArcGIS Hub Specialty designation from Esri. We have been formally recognized by Esri for the expertise and delivery of solutions and services that we provide to our clients as they look to build bridges between their government departments and their communities. We
have demonstrated expertise in implementing ArcGIS Hub sites while integrating source systems of record to deliver content to the appropriate audience. We have created a Hub or Hubs to showcase our training resources, a gallery showcasing samples of our work, and our key staff members who can assist in creating a targeted ArcGIS website to showcase the next project or highlight past successes.
https://arcgishub.timmons.com/
PREPARE MAPS USING ARCGIS DESKTOP OR ARCGIS PRO
We use the ArcGIS suite of GIS software tools, including ArcGIS Desktop and ArcGIS Pro, as our primary tools for data creation, maintenance, and quality control. We also use other software tools (e.g., Hexagon) should a client’s specific needs
require.
Timmons Group has developed a solid infrastructure for QA/QC in support of our GIS data services. Data quality control begins by establishing the data parameters and domains that define data type, content, and format. The parameters include geometric and attribute logic checks.
Where possible, we incorporate the latest data QA/QC tools offered by the Esri (specifically, Workflow Manager, Data Reviewer, and Task Assistant Manager) to automate, standardize, and manage the data processes. They provide tools and
a collaborative and shared environment to improve the quality and value of geospatial data, and cartographic products through standardization, repeatability, and configuration of your production processes.
Our GIS data services include the design, development, documentation, and population of databases to support a wide variety of business user’s needs. Our GIS Data development approach varies depending on the specific business data
requirements, available data resources, data formats, and intended use platforms. Our data conversion experience includes:
• Data Conversion and Migration
o Digitizing small to large scale (450,000 + features) projects use a heads-up approach
o Paper to digital use heads-up digitizing (e.g., Parcel maps, rights-of-way)
o Attribute coding and editing of points, lines, polygons
o Linking parcel data with tax records and computer aided mass appraisal (CAMA) systems
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
16 | Page
o Raster and vector data projection and transformation
o Non-GIS data location loading use geocoding tools and processes
o Digital to digital data conversion use Extract, Translate, and Load (ETL) tools
o Data QA/QC use automated processes and Esri Work Manager Extension Tools
• Field Data Inventory and Update
o Feature collection and validation
o Attribute collection and population
o Data QA/QC
• Image Processing
o Data acquisition
o Classification
o Loading
o Data QA/QC
Our data creation processing is typically managed use the Esri Production Mapping tools (specifically, Workflow Manager, Data Reviewer, and Task Assistant Manager) to automate, standardize, and manage the data creation and QA/QC
processes. We have extensive experience use industry ETL tools in the market today. This includes the Esri Data Interoperability Extension (FME Workbench) and FME from Safe Software. We have set-up 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.
An example is the parcel data creation work we have completed for many local government entities. We heads-up digitizing use scanned images of original plats and deeds, overlaid on local datums and imagery to georeferenced and vectorize the
parcels, rights-of-way, and other features shown on the source materials.
Field Data Collection and Validation
Timmons Group develops workflows and processes use a combination of Esri Production Mapping tools, Geoprocessing, and Decimeter/RTK based GPS to locate, validate, and collect field data.
An example is the field work we performed for the County of Virginia Beach Public Utilities. This two-phased project consists of the field inventory and location update of approximately 130,000 water meters and sanitary sewer cleanouts throughout
the County’s system and 10,000 key sewer manholes requiring Centimeter level locations and subsurface (invert) measurements. Timmons Group’s project team developed workflows and processes that provided:
• Highly accurate GPS Locations (sub-foot horizontal)
• GIS mapping in the field
• ArcGIS Mobile w/mobile caching
• Esri’s Data Reviewer to review/flag adjustment anomalies
• Geoprocessing scripting to update CVBPU data locations
• Batch submission of and acceptance of data
Emergency Response Systems Data Integration
Timmons Group provides GIS data validation, update, and maintenance services to support Emergency Operations including preparing data for Computer Aided Dispatch (CAD) systems, emergency map book (digital and paper) production, and GIS analysis services for Emergency Service Zone (ESZ) delineation and adjustment.
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
17 | Page
G) REFERENCES
City of New Smyrna Beach, FL | ArcGIS Jumpstart Package
Contact: Ken Klopp, GIS Manager
200 Canal Street, New Smyrna Beach, FL 32168
386.424.3064 KKlopp@ucnsb.org
City of Fayetteville, NC | GIS Planning and Development
Contact: Jessica VanHoozer, GIS Manager 433 Hay Street, Fayetteville, NC 28301 910.433.1721 JVanHoozer@ci.fay.nc.us
City of Forest Grove, OR | Enterprise GIS Planning, Migration, Consulting, and ArcGIS Online Portal
Contact: Gretchen Roberts, IT Manager 1924 Council Street, Forest Grove, OR 97116
604.501.9985 ext. 237 GRoberts@forestgrove-or.gov
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
18 | Page
H) PRESENT AND PROJECTED WORKLOADS
Timmons Group has the human resources available to successfully complete your project on accordance with the proposed schedule. Our staff includes more than 100 GIS professionals. The graph below shows our resources by category and their availability.
Staff Member % Used on Other Projects
Mike Wiley, Project Director 10%
Andy Fox, PMP, Project Manager 55%
Mike Sullivan, Esri Subject Matter Expert 55%
Matt Moore, Systems Architect 60%
Ally Reynolds, FME Subject Matter Expert 60%
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
19 | Page
Additional Staff Resources
System Designers Office Data Developers Client Support Technicians System Integrators
Programmers Field Data Collectors Trainers Engineering Services
I) KEY PERSONNEL
Project Manager Andy Fox, PMP Project Director Mike Wiley
Esri SME Mike Sullivan Systems Architect Matt Moore
FME SME
Ally Reynolds FME Certified
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
20 | Page
Mike Wiley
PROJECT DIRECTOR
Overview
Mike is an experienced IT executive with more than 20 years of experience in the ideation, conception, design, development, testing, delivery, training, and
maintenance of complex geospatial systems for state/local governments and commercial clients. His specialties include consistently developing strong
relationships with internal staff, technology partners and client teams. He is adept at identifying technology solutions to meet client's business and technology needs. Mike has a solid ability to develop value propositions that exceed clients' needs.
Select Project Experience
North Miami CRA Redevelopment Map, North Miami, FL
Timmons Group helped the City of North Miami CRA tell their story use story maps. Timmons Group staff was a key resource that helped frame the CRA’s authoritative data enriched with demographic data to provide greater context of demographic profiles and lifestyle habits associated with the areas of the various projects,
Opportunity Zones, and property-level and zoning data throughout the area.
Pelias Geocoder, AccuZIP*
Engagement Manager for the configuration, deployment and testing of the Pelias geocoder enabling this client to initially batch geocode 120M records followed by 1M geocodes monthly. ROI for customer was demonstrated to have a payback of 7 months after go-live.
Student Routing, WE Transport*
Engagement Manager for the design, build and deployment of a Student Information
System that helps WE Transport optimize their entire school bus network.
National Fire Data System (NFDS), National Fire Protection Association (NFPA)*
Engagement Manager for this nationwide NFDS project that collects and stores fire
incident data and supports data analysis to benefit firefighters, first responders community leaders, and stakeholders concerned with loss prevention, risk
prevention, and insurance.
Impervious Surface Map, NJ DEP*
Engagement Manager for the statewide impervious surface mapping project. This project used Object-Based Image Analysis (OBIA) to extract impervious surface
features.
NYC Planimetric Update and 3D Buildings, NYC DoITT*
Project Director responsible for overseeing all aspects of this data conversion project. Advised on technical deliverables and provided management support for
client and photogrammetry subconsultant. Created the first of kind, 3D massing model of 1M+ buildings in CityGML 1.5 LOD (level of detail).
*Projects before joining Timmons Group
Education
• Masters, Regional Planning,
Focus on GIS and Remote
Sensing Technology, University
of Massachusetts, Amherst, 1995
• Bachelor of Science,
Environmental Design,
University of Massachusetts,
Amherst, 1991
Experience
• 27 Years
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
21 | Page
Andy Fox, PhD, PMP
PROJECT MANAGER
Overview
Dr. Andrew Fox is a senior technical project consultant and project manager in Timmons Group’s Geospatial division. He is the lead consultant for many GIS
planning and integration projects. His responsibilities include designing and deploying integrated information management solutions that use a wide range of
technologies and information types. He has extensive experience in information systems specification and operations that manage critical information for state, federal and local governments.
Select Project Experience
City of Tigard Asset Management RoadMap, Washington County, OR
Timmons Group provided an Asset Management RoadMap for the City by reviewing the current framework of CMMS and AMS within the City’s three utility departments: water, sanitary, and storm water systems. The goal of the project was to produce an AMS RoadMap that would define the critical path and steps
necessary for the continued development and enhancement of the AMS program that will improve staff productivity and service.
Christiansburg VA, GIS RoadMap, Montgomery County, VA
The Town of Christiansburg IT Department desires a comprehensive needs assessment and analysis of the GIS Program. The goal is to identify existing assets, any unmet needs, identify inefficiencies and opportunities and prepare a GIS
strategic plan. This strategy is to ensure progress and success for the future. During all steps of the process, the awarded service provider is expected to keep in contact
with the Assistant to the Town Manager and/or designated GIS staff so to keep them informed of the project process. It is expected that the service provider will involve
stakeholders and staff, where possible and appropriate, during the process.
Town of Smithtown, Townwide GIS, Suffolk, NY
Timmons Group assisted in the planning, development, and implementation of an Esri-based Enterprise. The system provided for a multi-user environment managed
within the Town's Engineering Department offices, with the necessary elements in place to managed the data within a multi-user editing environment, and provide
integration between the GIS and existing Building Department to Town Assessor databases. The system has the capability to enable Town staff easy access to the
GIS at a multitude of user levels (Power user, maintainer, casual user, manager, etc.) within a browser based framework (Portal), in a GIS-based web mapping
application designed to provide access (at the staff level) assessment and planning level information reduce the overhead related to citizen requests, thereby further
improving staff efficiency and productivity.
Nevada Department of Wildlife CDMS RoadMap, Reno, NV
The Nevada Department of Wildlife (NDOW) sought to create a Comprehensive Data Management Strategy or “RoadMap”, to organize data, applications,
workflows, stewardship/governance, and maintenance. The agency desired a solid plan to establish improved data management system (to include GIS) that served
all divisions equally and represented all current and future business needs. This plan included all elements of a highly-functioning data management system and
GIS – from people to process – accompanied with a reasonable plan of execution respectful of agency funding and capacity.
Education
• Doctor of Philosophy, Geological
Sciences, Cornell University,
1993
• Masters, Geological Sciences,
University of Canterbury (New
Zealand), 1987
• Bachelor of Arts, Geological
Sciences, SUNY Geneseo, 1985
Registration
Project Management Professional
Certification, VA, 2013
Experience
• 29 Years
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
22 | Page
Matt Moore
SYSTEMS ARCHITECT
Overview
Matt is a Sr. Systems Architect in Timmons Group's Geospatial Division. He
performs tasks related to systems management/administration, web administration, database administration and development, and applications development. Matt has
worked on many system architecture design, development, and implementation projects for Federal, State, and Local governments throughout the USA. He is well
versed in implementing Enterprise systems and has worked on projects use both custom and COTS applications..
Select Project Experience
City of Danville Cityworks Roadmap, Danville, VA
Timmons Group is working with the City of Danville to provide a detailed Cityworks,
GIS, CMMS and Asset Management Roadmap, which will guide the organization, both short-term and long-term, to deliver an effective and efficient Asset Management Program concentrated on multiple departments, with high quality results, and align with the City’s current operational plans and initiatives. The
purpose of this project is to conduct a review of current Asset Management related tools, processes, requirements and goals; provide governance, and build
consensus for a unified view of the efforts needed to align the City’s existing GIS, Cityworks AMS and other systems throughout all identified user groups.
Napa Sanitation - Cityworks AMS Implementation, Napa County, CA
Timmons Group provided CMMS Implementation for the Napa Sanitation District
(NapaSan). Timmons Group conducted multiple reviews of NapaSan’s systems including their current GIS and IT systems. After working with NapaSan on the
configuration documentation, conducting multiple workshops and meetings, Timmons Group installed Cityworks Server and Cityworks AMS. SCADA and CCTV
integrations were performed and the migration/conversion of legacy data was necessary to ensure the success of the future CMMS.
New Smyrna Beach, FL - ArcGIS Install, Volusia County, FL
Timmons Group was contracted by the Utilities Commission (UCNSB) to provide
professional Geospatial Services to install, configure, and provide support for an ArcGIS Enterprise implementation. Working collaboratively with UCNSB, we
evaluated UCNSB’s current GIS footprint and workflows as well as their desired goal of this project.
University of Richmond ESRI ArcSDE Installation and Training, Richmond, VA
Timmons Group installed SQL Server 2008 and ArcSDE for the University’s GIS
server. Timmons Group also provided on-site training to University staff on its administration and maintenance as it pertained to ArcSDE. The training covered
administration, maintenance, and best practices to use in a multi-user, multi-editor, ArcSDE versioned environment. Documentation was provided to be used as a
technical reference and included information specific to the UR server and ArcSDE Configuration.
Education
• Bachelor of Science, Geography,
Focus in Information
Technology, Old Dominion
University, 2004
Experience
• 18 Years
Affiliation
Virginia Association for Mapping
and Land Information Systems
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
23 | Page
Mike Sullivan
ESRI SUBJECT MATTER EXPERT
Overview
Mike is a Senior GIS Analyst in Timmons Group’s Geospatial Services Team. He
has over two decades of experience at all levels of GIS. Mike has worked on many GIS systems architecture design, development, and implementation projects for
State and Local governments. He also has experience in database development use SQL Server for Enterprise-level GIS Solutions. His experience also includes
work in the private sector for multiple GIS clients in the Portland, OR region.
Select Project Experience
Tualatin Valley Soils and Water Conservation District Enterprise GIS System Support, Washington, OR
TVSWCD recently moved to a new office and established an ArcGIS Enterprise
infrastructure. The TVSWCD contracted with Timmons Group to evaluate the current system and configuration to ensure that the system is set up in a streamlined and efficient manner. The TVSWCD desired to ensure that newer technologies such as ArcGIS Online and Collector for ArcGIS are configured to
support existing and desire workflows.
Tualatin Soil and Water Conservation District GIS RoadMap, Washington, OR
Timmons Group provided IT strategic planning and assessment services for the Tualatin Soil and Water Conservation District (TSWCD). Phase 1 consisted of
defining and analyzing business processes; completing a needs assessment; making recommendations for IT strategies, tactics, and personnel; and regularly
communicating with TSWCD staff. Phase 2 consisted of documenting requirements for centralized database and management application(s), software, and hardware
and a completed IT assessment.
Nevada Department of Transportation GIS Support Services, Carson City, NV
The Nevada DOT on-site GIS infrastructure support project involves many of the following activities at the request of the client: the initial GIS System Architecture
design, assisting in configuration of servers, and installing and configuring GIS software for client and server-side hardware. Specific Timmons Group personnel
assisted with day to day activities such as development of professional documentation, resolving GIS issues, design and administration of NDOT ArcGIS
Online site, and participation in the DOT Agile processes. Multiple python automation scripts were created for assisting in nightly and weekly geodatabase
maintenance involving reconcile/post procedures, replica synchronization, and geodatabase compression routines.
Oregon GEOHub Conceptual System Design, Salem, OR
Timmons Group was selected by the Oregon Office of the State Chief Information
Officer (OSCIO) Geospatial Enterprise Office (GEO) to develop a GEOHub Conceptual System Design for the state. The purpose of the GEOHub project is to
provide improved, transparent, shared data services to the stakeholders and enhance state business processes and practices. Across the Oregon geospatial
enterprise, data and other information are managed in isolation, or silos, by unique organizations use varied data management tools for data quality, integration,
governance, and stewardship. GEOHub is the response to this situation.
Education
Bachelor of Science,
Cartography/Map Technology,
Missouri State University, 1996
Experience
22 Years
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
24 | Page
Ally Reynolds
FME-CERTIFIED SUBJECT MATTER EXPERT
Overview
Ally is a GIS Specialist on the Timmons Group Geospatial Services Team. She has experience in Esri GIS schema development, scripting, QA/QC practices, and data
conversion including use ETL tools to populate geodatabases.
Select Project Experience
City of Forest Grove Enterprise GIS System, Forest Grove, OR
The City of Forest Grove Oregon partnered with Timmons Group to employ our demonstrated expertise in designing, implementing Enterprise GIS Systems,
converting existing geospatial data, and ArcGIS Online capabilities.
Dominion GIS Survey - Fort Hood, Fort Hood, TX
Timmons Group provided GIS extract translate and load (ETL) data migration, data modeling, and GPS asset inventory services for Dominion Privatization Texas, LLC
Resources Services, Inc. to locate, verify, and convert government-owned electrical and natural gas facilities purchased at Fort Hood, TX as part of the
Department of Defense Privatization Program.
Eastern Virginia Regional Routable Centerline Development and On-going Support, King and Queen County, VA
Timmons Group developed a regional GIS dataset and promoted the transition to
NG-911 for a cooperative project with eight counties in the Middle Peninsula and Northern Neck regions of Virginia. This regional effort is led by King and Queen
County, located centrally in the Middle Peninsula region. The project began the Counties of King and Queen, Essex, Gloucester, Mathews, and Middlesex, but is
also reaching north to include the Counties of Richmond and Lancaster from the Northern Neck region of Virginia.
CRAC GIS Expansion Services, Richmond, VA
Timmons Group designed and implemented an Enterprise GIS (EGIS) for the
Richmond International Airport (RIC). The EGIS supports Federal Aviation Administration (FAA) Airports GIS (AGIS) Compliance and Reporting requirements
(FAR77 and eALPs) and airport operations including Operations and Planning, Real Estate, Engineering, Construction, Emergency Services, Asset Management
and Operations, and Executive Management.
Cumberland Co NG-911 Readiness, Cumberland County, VA
Cumberland County wanted to do an extensive evaluation and remediation of its existing address and road data based on the results of the VITA Readiness Report
that evaluated significant deficiencies in the County's data. The use of verification tools and creation of future maintenance planning to ensure that their data is
gaining accuracy needed for NG-911 deployment. Timmons Group ensured that all data complied with NENA schema standards and state regulations for NG-911
deployments.
Education
• Bachelor of Arts, Biology with
Minor in Spanish, University of
North Carolina, 2015
Registration
Certified ArcGIS Desktop
Associate 10.3, VA, 2018
Experience
• 6 Years
Affiliation
Virginia Association for Mapping
and Land Information Systems
(VAMLIS)
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
25 | Page
J) PRICE PROPOSAL
Timmons Group will complete this project with a fixed-fee budget of $35,000. Timmons Group will work with the City to determine the preferred invoicing options.
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
26 | Page
K) ADDITIONAL INFORMATION
Timmons Group has more than 100 geospatial personnel, many of whom have certifications equipped to benefit our Local Government clients. Our personnel certifications include GIS Professionals (GISP), Project Management Professionals (PMP), and various ArcGIS Desktop and Server certifications. As a firm, we are an Gold Esri Business Partner, we obtained an ArcGIS Online Specialty, Release Ready Specialty, and ArcGIS Hub Specialty.
License Employee
Certified ArcGIS Desktop Associate 10.1 William Dingus Stuart Frankfort Taylour H. Taylor
Certified ArcGIS Desktop Associate 10.3 Allyson T Reynolds
Certified ArcGIS Desktop Associate 10.5 Brian Kingery
Certified Business Analyst Foundation Level Zuzana Johansen
Certified Enterprise System Design Associate 10.5 Jarrett Green
Certified Mobile Tester Zuzana Johansen
Certified Scrum Master Stephanie M Giovannetti Matthew N McCracken Nathan R. Tate Taylour H Taylor
Certified Scrum Product Owner Christopher W. Gerecke
Stephanie M Giovannetti
Christopher Lutz
Matthew N McCracken
Certified Tester-Foundation Level Agile Tester Ex Zuzana Johansen
Certified Tester-Foundation Level Certification Zuzana Johansen
Certified Usability Tester Zuzana Johansen
Certified Web Application Developer Associate 10.2 Yogesh Dhanapal
Jitendrudu Lacaraju
Certified Web Application Developer Associate 10.4 Jarrett Green Rev. Max Mauren Charles Mateer Sreehari Kottoormadam
ArcGIS Online Administration Specialty Brian Kingery
Esri Enterprise Administration Professional Matthew Moore
Geographic Information System Professional Brian Kingery
Charles Mateer
Timothy Sheldon
ITIL Foundation Certificate in IT Service Management Stephanie M Giovannetti
Professional Land Surveyor Randall G. Trott
Project Management Professional Certification Michael Edwards Andrew N. Fox Dylan T. Sheets
Timmons Group has extensive on-call contract experience and has completed a wide range of projects for a significant number of clients. We are accustomed to working for these clients on an “as needed basis” providing quick response for
the establishment of scope, schedule, and fees for delivering the required services. We know that our staff must act as an extension of your staff to address project issues as they arise. We also understand that time is of the essence and that we must complete our work in accordance with the Purchase Order schedule.
We have successfully completed projects under master contracts or are currently under an on-call contract with many
clients. Due to our responsive service to our clients, many have renewed their contracts with Timmons Group over the years. Below is a representative list of our recent government client on-call GIS contracts.
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
27 | Page
Type Client Contract Name
Federal Department of Homeland Security
(DHS) - JPI IDIQ Contract for IT/GIS Support Services
Federal General Service Administration Master Contract GIS GSA Schedule 70
Federal General Service Administration Master Contract GSA Schedule 899
Local Anne Arundel County, MD Master Contract Information Technology Professional Services
Local Arlington County, VA IT Staff Augmentation
Local City of Charlottesville Master Contract for GIS Consulting Services
Local City of Fairfax, VA Master Contract IT Staff Augmentation
Local City of Forest Grove, OR Master GIS Services Contract
Local City of Greensboro, NC On-Call Services for GIS
Local City of Los Angeles, CA GIS Contract Program
Local City of North Miami, FL Geographic Information System Services
Local City of Palo Alto, CA On-Call GIS Implementation and Support Services
Local City of Phoenix, AZ IT Professional Services 2018-2020 Qualified Vendor List
Local City of Richmond GIS Contract for Staff Augmentation
Local City of San Jose, CA Master Contract to provide FME Licenses and Technical Services
Local Fairfax County, A Master Contract Fairfax Water IT Staff Aug
Local Fairfax County, VA Master Contract for GIS Services for Fairfax County
Local Hennepin County, MN Master IT Consulting Services Program 2020 - 2022
Local King County, WA Master Contract On Demand IT Consulting Services
Local Sacramento County, CA Master Contract for Information Technology Staffing
Local San Luis Obispo Council of Governments, CA Qualified Consultant List
Local Spotsylvania County, VA Master Services GIS Contract
Local St. Johns County, FL Master Contract for GIS and Technology Services
Local Town of Smithtown, NY Master Contract for Application for Professional Services
Local Washington County, OR Master Contract for ITS Staff Augmentation
State Arizona Master Contract GIS IT MSA
State Arizona Department of Transportation Master Contract - State Funded - Consulting Services, Transportation Planning On-Call
State Arizona Department of Transportation Master Contract - Federal Funded - Consulting Services, Transportation Planning On-Call
State Arkansas Master Contract GIS Arkansas Agreement IT Staff Augmentation
State California Master Contract GIS California CMAS Contract
State Georgia IT Staffing Services Contract
State Louisiana Division of Administration Louisiana Division of Administration - IT Staffing Support
State Maryland Master Contract for GIS/Geospatial Services
State Maryland Master Contract for GIS Services – MD CHART Client
State Massachusetts IT Project Services
State Michigan IT Temporary Staffing Services Contract
State Minnesota Master Contract GIS SITE Professional and Technical Services
State Missouri Master Contract for GIS Services
State Montana Master Contract for GIS/ IT Services
State Nevada Department of Transportation Master Contract GIS/Application Development
State New Jersey Master Contract for GIS Services
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
28 | Page
Type Client Contract Name
State New Mexico Master Contract for GIS/IT Professional Services
State New Mexico GIS - COTS Software
State North Carolina IT Staff Augmentation
State North Carolina - Dept. of Transportation Master Contract for GIS and IT Services
State North Carolina Dept. of Info. Technology Master Contract NC Office of Information Technology Services - Short Term IT Staffing/Open Enrollment
State North Carolina Dept. of Info. Technology NC Dept. of Info. Technology - IT Application Services On-Call Contract
State North Carolina Dept. of Info. Technology Digital Website Services
State North Carolina Dept. of Info. Technology GIS Services
State North Carolina Dept. of Info. Technology Agile Services
State North Dakota Master - North Dakota Staff Aug - Knowledge Service MSA
State North Dakota Master Contract - State of North Dakota - Information Tech
State North Dakota IT Dept - Data Architecture, Strategy and Technology Consulting Services Term Contract
State North Dakota Master Contract - Information Tech
State North Dakota IT Dept - Data Architecture, Strategy and Technology Consulting
Services Term Contract
State Ohio Master Contract for GIS Services
State Oregon Dept. of Forestry IT Products and Services
State Oregon for the Department of Transportation GIS Services for the State of Oregon for the Department of Transportation
State Pennsylvania Master Contract IT Services, Pennsylvania Sub to NIIT Technologies
State Pennsylvania Master Contract GIS IT Staff Augmentation
State Pennsylvania Department of General Services Master Service IT Services Contract
State State of Washington Master Contract - Information Technology Professional Service for
Washington State 2017 renewal
State Texas Master Contract Texas Multiple Award Schedule
State Texas Dept. of Information Resources Master Contract GIS as Sub to Data Transfer Solutions (DTS) for TXDIR
State Utah Staff Augmentation Managed Service Provider
State Utah IT Milestone/Deliverable-based Project Suppliers Managed Service Provider
State Vermont Department of Buildings and General Services Master Contract - Information Technology (IT) Services
State Virginia Master Contract GIS Agreement IT Staff Augmentation
State Virginia Information Technologies Agency Master VITA - Citizen-Facing Websites/Applications and Supporting Services
State Washington Master Contract for Information Technology Professional Service
State West Virginia Department of Transportation GIS Consulting Services
State Western Association of Fish and Wildlife Agencies Western Association Fish and Wildlife Agencies MSA
State Wisconsin - Dept. of Natural
Resources Master Contract Process Solutions for IT Services Supplier
State Wyoming Department of Transportation SOI for Consultant Work Renewal
GIS Data and Database Architecture and Data Maintenance Health Check City of Bozeman, MT
29 | Page
L) AFFIRMATION OF NONDISCRIMINATION AND EQUAL PAY (APPENDIX B)
Appendix B
NONDISCRIMINATION AND EQUAL PAY AFFIRMATION
Timmons Group, Inc. (name of entity submitting) hereby affirms it
will not discriminate on the basis of race, color, religion, creed, sex, age, marital
status, national origin, or because of actual or perceived sexual orientation, gender
identity or disability and acknowledges and understands the eventual contract will
contain a provision prohibiting discrimination as described above and this
prohibition on discrimination shall apply to the hiring and treatments or proposer’s
employees and to all subcontracts.
In addition, Timmons Group, Inc. (name of entity submitting) hereby affirms it
will abide by the Equal Pay Act of 1963 and Section 39-3-104, MCA (the Montana
Equal Pay Act), and has visited the State of Montana Equal Pay for Equal Work “best
practices” website, https://equalpay.mt.gov/BestPractices/Employers, or equivalent
“best practices” publication and has read the material.
Name and title of person authorized to sign on behalf of submitter
Mike Wiley, Project Director