HomeMy WebLinkAboutBozeman MT Database Proposal final_complete
GIS DATA & DATABASE
ARCHITECTURE AND
DATA MAINTENANCE
HEALTH CHECK
CITY OF BOZEMAN, MT
January 15, 2021
January 15, 2021
Mike Maas
City Clerk
Bozeman, MT
agenda@bozeman.net
RE: PROPOSAL FOR GIS DATA & DATABASE ARCHITECTURE AND DATA MAINTENANCE HEALTH CHECK
Dear Mr. Maas:
James W. Sewall Company (Sewall) is pleased to provide the City of Bozeman, MT (City), this proposal to conduct a
data and database architecture and data maintenance review of the City’s GIS systems in response to the City’s
request for Proposals issued on December 20, 2020.
As you read our proposal, we ask you to be aware of the specific benefits that the Sewall team will bring to your
project:
• Experience. Sewall has been providing precisely the services requested for more than two decades.
• Esri Business Partner. Sewall has been an Esri business partner since 1998 and was the foundation partner
of the year for the Northeast in 2004. Our staff is well versed in its applications and has experience teaching
clients their use.
• Educated, Experienced Staff: Sewall’s highly trained, experienced staff can assist the City with all of its
project needs. The City will benefit greatly from our consultative project approach, whereby it can leverage
our experience and expertise in GIS, imaging, survey, engineering and forestry. Sewall will remain available
and responsive well after this project has been successfully completed.
• Client-Based Commitment. Sewall’s success is founded upon consistently meeting customer expectations,
timelines, budgets and deliverables. The majority of our business comes from repeat customers, a strong
testimony to our commitment to delivering solutions that make a difference to our clients, reflected in the
projects referenced in our documentation. We encourage the City to contact our clients and learn more
about Sewall’s reputation.
If you have any questions or require any further information regarding this proposal, please feel free to call Nasir
Shir at (207) 817-5540; Email: nasir.shir@sewall.com. We look forward to working with you on this important
project.
Sincerely,
JAMES W. SEWALL COMPANY
M. Nasir Shir – Director of Geospatial Services Matthew Dieterich - Executive Vice President
(541-21-01)
1. Executive Summary .................................................................................................................1
2. Firm/Individual Profile........................................................................................................... 2
3. Description of Proposed Solution .................................................................................... 4
3.1. Task 1 – Establish Communication Protocols ...................................................................................................... 4
3.2. Task 2 – Gather Materials ................................................................................................................................... 5
3.3. Task 3 – Review Materials .................................................................................................................................. 6
3.4. Task 4 – Establish Remote Connection ................................................................................................................ 6
3.5. Task 5 – Review Policies...................................................................................................................................... 6
3.6. Task 6 – Review Other Related Materials ........................................................................................................... 6
3.7. Task 7 – Compile the Report ............................................................................................................................... 7
4. Scope of Project ......................................................................................................................8
5. Related Experience with Projects Similar to the Scope of Services .................... 9
6. Statement of Qualifications .............................................................................................. 13
7. References ............................................................................................................................... 14
8. Present and Projected Workloads ................................................................................. 15
9. Key Personnel......................................................................................................................... 16
9.1. Key Personnel and Contract Roles .....................................................................................................................16
9.2. Resumes ............................................................................................................................................................17
10. Price proposal ...................................................................................................................... 29
11. Additional Information: QC/QA Procedures .............................................................. 30
12. Affirmation of Nondiscrimination & Equal Pay (Appendix B) ............................. 31
City of Bozeman | January 15, 2021 | Page 1
1. EXECUTIVE SUMMARY
James W. Sewall Company (Sewall) is pleased to present this proposal to the City of Bozeman, MT (City of Bozeman),
for a GIS data and database architecture and data maintenance health check.
Sewall has been an Esri business partner since 1998 and was their foundation partner of the year for the Northeast
in 2004. Our integrated solutions and Esri platform services assist in the management and analysis of spatially
related information that enable the efficient and safe delivery of electricity, natural gas, water, and
telecommunication products and services, among others.
Sewall follows a client-focused approach in executing our work by establishing long-term relationships and
partnering in our client’s success. For the City of Bozeman’s project, we have developed a detailed atechnical
approach to meet the needs as outlined in the RFP, including reviewing the City of Bozeman’s published material,
enterprise geodatabase, and file geodatabase, setting up ArcGIS Enterprise Data Store/ArcGIS Online, managing
data, integrating databases, identifying geographic layers for the Local Government Information Models (LGIM), and
integrating FME.
Throughout the entire process, Sewall will be working with the City of Bozeman to ensure all phases of the project
are well understood by both parties, and that the identification of best practices is understood by the City of
Bozeman personnel. Communication will be frequent and the process iterative.
As a company that has been in business for over 140 years, Sewall has a long history of GIS capability and
innovation. Its in-house geospatial solutions staff is very experienced in setting up Esri enterprise geodatabases for
both internal and external purposes. Four (4) of our dedicated senior staff have close to 20 years’ experience in GIS
and with Esri products. Sewall’s chosen project manager for the City’s endeavor, M. Nasir Shir, GISP, Director of
Geospatial Services, recently joined Sewall with 25 years of GIS experience, including three (3) years as an Esri
distributor. For the past nine (9) years, he worked as the GIS manager for the City of Portland, Maine, which has a
population similar in size to the City of Bozeman. Mr. Shir faced many of the same challenges with Portland’s GIS
setup as does the City of Bozeman and worked to find the best solutions to these challenges. Sewall’s resume of
successful similar projects and satisfied clients illustrate its qualifications.
Sewall has provided consultation services for many clients regarding the design, setup and execution of Esri
enterprise geodatabases. Our long history of Esri partnership allows us to keep staff informed about using Esri’s
latest technology to provide our clients valuable guidance. In addition, Sewall’s in-depth QC/QA process ensures the
quality of its work products.
City of Bozeman | January 15, 2021 | Page 2
2. FIRM/INDIVIDUAL PROFILE
Company responding:
James W. Sewall Company
136 Center St; PO Box 433
Old Town, ME 04468
(207) 827-4456
www.sewall.com
info@sewall.com
Principal:
Andrew Nelson
Chief Executive Officer
(207) 650-0773 (mobile)
nelan@sewall.com
Project Officer:
Matthew Dieterich
Executive Vice President
(207) 318-2166 (mobile)
Matthew.dieterich@sewall.com
Project Manager:
M. Nasir Shir
Director of Geospatial Services
(207) 817-5540
Nasir.shir@sewall.com
COMPANY OVERVIEW
James W. Sewall Company (Sewall) is a full-service consulting firm based in Old Town, Maine. The 140-year-old
company offers a wide range of professional services, including geospatial solutions, civil and transportation
engineering, surveying, construction management/administration and inspection, alternative site evaluation and
permitting, land use planning, and natural resources consulting. The Geospatial Division includes certified geographic
systems professionals (GISPs), an ASPRS Certified Photogrammetrist, GIS application specialists, database engineers,
analysts and technicians. The Engineering Division includes professional engineers, professional land surveyors,
City of Bozeman | January 15, 2021 | Page 3
analysts, and technicians with expertise in virtually every discipline of civil engineering, including highway and
intersection design, traffic and transportation engineering, site design, structural design, and environmental
permitting.
Sewall was established in 1880 by a civil engineering alumnus of Bowdoin College and a citizen of Old Town. In its
early days, the small firm established a market niche in surveying and forestry appraisals for private and public
sector clients, while also performing large civil engineering design projects throughout the eastern US.
Funded by NASA, in the 1990s Sewall adapted its digital camera system for mapping pipeline ROWs and developed
software applications for pipeline integrity management. In 1997, Sewall incorporated photogrammetric-quality
scanning and digital imaging processing into its services. By the first decade of the 21st century, Sewall passed
benchmarks of capturing over 1 million aerial images and mapping 2000 towns nationwide and entered renewable
energy markets.
During the past decade, Sewall has used aerial and satellite imagery for change detection, as well as performing
wood resource studies for confidential clients. Our software programmers have developed digital platforms such as
WoodPro for clients to manage their wood procurement, and Mobile Verify to capture asset information in the field
and post that information to database records in a single step, improving the accuracy and currency of spatial data
without the need for additional processing.
Since its founding, Sewall has expanded to include over 50 employees and seven offices in four states. Sewall is
owned by Treadwell Franklin Infrastructure Capital (TFIC), a company that undertakes project origination and
development, financial structuring and project finance for the commercial infrastructure of the United States.
Sewall’s corporate headquarters is located at 136 Center Street, Old Town, ME 04468; telephone: 207 827 4456.
Sewall/TFIC offices are located at 40 Forest Falls Drive, Suite 2, Yarmouth, Maine 04096; telephone 207 817 5410.
Regional Sewall offices are located in Caribou, Maine; Augusta, Maine; International Falls, Minnesota; Peachtree
City, Georgia; and Summerville, South Carolina.
Sewall’s professionals assist public and private sector clients throughout the United States, Canada, and overseas
with projects that range in size and scope from local municipal peer review services to large, multi-year asset
management, highway design and site development projects.
City of Bozeman | January 15, 2021 | Page 4
3. DESCRIPTION OF PROPOSED SOLUTION
In the sub sections below, Sewall presents its proposed approach to conducting a database and data architecture
review, and its recommended plan.
3.1. TASK 1 – ESTABLISH COMMUNICATION PROTOCOLS
Over its 140 years of service, Sewall has established long-term relationships with clients based upon high standards,
effective communication, and shared objectives. During every stage of a project, Sewall works closely with clients to
understand their expectations and to meet their unique, specific needs.
Our client-centric approach to project management has earned Sewall the confidence of clients throughout all levels
of government and within the private sector. In fact, 80% of Sewall's business is with repeat customers.
Sewall assigns a single point of contact with respect to a proposed project. It is anticipated that the contact person
will not change during the period the project is in force.
For the City’s project, we have assigned our Director of Geospatial Services, M. Nasir Shir, GISP, as the project
manager. He can be reached by phone at (207) 817-5540 (direct line) or by email at Nasir.shir@sewall.com. Mr.
Shir’s preferred method of contact is via telephone.
The Sewall Project Manager will:
• Serve as the primary point of contact for the client and will coordinate and communicate all activities;
• Develop and maintain the Project Management Plan, in consultation with the client and the project
team;
• Facilitate regular communication with the client, including frequent calls and monthly status
reports/updates, and review the project performance against the project plan;
• Facilitate project status meetings as needed;
City of Bozeman | January 15, 2021 | Page 5
• Update the project plan on a monthly basis with changes and updates included in monthly progress
correspondence; and
• Be responsible for the management and deployment of Sewall personnel.
The Sewall project manager and other key technical staff will hold a kickoff meeting with the City of Bozeman team
to make sure the project scope is clearly understood by the two parties and establish a project schedule and
milestones.
Effective communications will be crucial to successfully completing this project on time and within budget. We
anticipate multiple video meetings with the City to understand and address any current needs. We anticipate
frequent phone conversations and emails during the course of the project, and Sewall will initiate these
communications to make sure the City is kept abreast of the most recent project information.
Before creating a project plan, Sewall’s first step will be to conduct in-depth interviews with leaders in the client
organization. Interviews will focus on clearly understanding the reasons that the project is being undertaken, the
key outcomes expected, the key pain points that prompted the project, and the long-term vision that the project is
intended to move toward.
3.2. TASK 2 – GATHER MATERIALS
Gathering materials, both verbal and written, is vital to gaining the best understanding of the project. To answer
questions or understand how databases integrate with other systems and thus platforms, documents like studies,
recommendations, and flow charts will be important sources. The following is a draft outline of the type of
documents that will be requested, and the reasons for each are briefly described.
1. Gather materials and documents
a. Minutes of committees or steering groups to help discern:
i. How information is shared and/or coordinated
ii. How projects are discussed and how decisions are made, or how data are prioritized for
editing purposes
b. System designs provided by Esri
c. Data flow chart between servers
d. FME scripts and information about how often they are run, which database they interact with,
where the data ends up, and how the data is deployed
e. Obtain 500+ layer names in Excel sheet; attempt to identify the layers based on the following:
i. Age of the layer
ii. Static layer, containing items such as City boundary, water bodies, wetlands
iii. Dynamic
1. Hourly, daily, weekly, monthly, etc.
2. Monthly, such as zones
3. Seasonally, such as winter vs. summer data for plowing and sweeping
4. Periodically, such as during elections, voter registration
5. Occasionally, such as census data
iv. Holder of the data
City of Bozeman | January 15, 2021 | Page 6
1. Is there an editor in the specific department to edit the layer?
v. How many layers can be put in an archive feature dataset?
vi. Do metadata exist for all layers? Is it important? (Yes, if the layers are used daily and/or are
part of the base map)
f. Any feedback from surveys from all the GIS users within the City.
g. Any feedback from Esri or others in reference to recommendations about database design
3.3. TASK 3 – REVIEW MATERIALS
Materials will be reviewed for the purpose of gaining a better understanding of the City’s needs and will be
compared to the practices of other municipalities and private sector clients of Sewall. These materials may include,
but will not be limited to, documents, emails, graphs, flow charts, reports, studies, or other documents that will
support the project. These documents will be reviewed and discussed with the City of Bozeman to clarify questions
and concerns and will help Sewall understand how the technology is used by the City of Bozeman.
While reviewing the materials, the findings will be compared to industry standard practices and assessed. This
information and analysis will be shared with the City of Bozeman and will be documented in the final report.
3.4. TASK 4 – ESTABLISH REMOTE CONNECTION
Based on a discussion with City staff on January 8, 2021, Sewall understands that VPN connection is limited.
However, there are other solutions such as screen share or scheduling a demo that will allow us to view and
understand how the software is used, how the servers are laid out, and what information is shared between the
servers.
The purpose of these viewings is to observe the system operating and to review how each department utilizes and
accesses the data. The overarching goal is to look at the existing process and workflow in action. Observations will
be made and recorded.
3.5. TASK 5 – REVIEW POLICIES
Sewall will gather any policies that are available in refence to editors and their permissions to specific feature class
via a group and/or by a role. Questions will be asked such as: are there versions, how are decisions made, who
qualifies to be a version editor as opposed to requesting the data to be edited and/or editing the data in a browser
base? Are the editors geometry editors or do they populate attributes only?
This information is important in allowing us to identify best practices for maintaining datasets in the future.
3.6. TASK 6 – REVIEW OTHER RELATED MATERIALS
Sewall will review Esri’s documentation, industry standard practices and procedures and other client best practices
known to us to assist in creating recommendations for the City’s best practices. As part of this task, a thorough
review will be given to using a Local Government Information Model (LGIM) based on our past experience. The City
of Portland, where Sewall’s Director of Geospatial Services M. Nasir Shir worked for nine years, has migrated two of
City of Bozeman | January 15, 2021 | Page 7
their datasets to LGIM. One dataset was Parcels which moved to the Parcel Fabric LGIM whereas the second dataset
was water/sewer data. Sewall will bring this experience and expertise to this project and hence look to Esri to
identify number of LGIM configurations for the City of Bozeman.
3.7. TASK 7 – COMPILE THE REPORT
Sewall’s method for compiling the report is presented in Section 4 on the following page.
City of Bozeman | January 15, 2021 | Page 8
4. SCOPE OF PROJECT
Sewall will identify best practices when hosting data on Portal vs a traditional geodatabase, recommend best
maintenance practices, identify server performances, and recommend data models that fall under Esri standards of
Local Government Information Model (LGIM). Action items will be identified, and a recommendation will be made in
a report based on the tasks identified in section 3 of this proposal.
Choices for storing data are the following:
ArcGIS Enterprise Default Data Store – a built in, ESRI-managed enterprise geodatabase that uses embedded
PostgreSQL. Convenient for publishers and not needing any special privileges or administration or secure database
connections. Supports multi-user editing. It is not transparent or manageable. Admins cannot see the content or
structure.
(Registered) Enterprise Geodatabase – Enterprise Geodatabases have existed for many years. This is a multi-user,
versionable geodatabase that is implemented in SQLServer, Oracle, or PostgreSQL. They can be “made known” to
Enterprise by means of registration. When services are published using registered data sources, the data is not
copied to the Default Data Store.
File Geodatabase – This is spatial data stored in a proprietary file format that does not require a relational
database. It cannot support multi-user editing or versions. It cannot serve as a registered database.
Sewall will assist the City in determining where the report will be easily accessible, easily searched, and easily
interpreted, and the report will contain visuals such as diagrams, flow charts, and tables or references to tables.
Sewall will suggest a template for the report that can be improved based on City staff recommendations. The table
of contents for final report will follow the nine items listed on page 3 of the RFP and shown below, with hyperlinks,
figures, tables, and possibly launching of tables or refences to tables. The tables will include the 500+ layers
presented in a meaningful manner where one can prioritize layers based on user needs and editing status, meaning
editing periodically, daily or annually.
1. Existing use of Enterprise Geodatabase
2. Existing use of File Geodatabases
3. Existing use of Hosted data (ArcGIS Enterprise Data Store and ArcGIS Online)
4. Recommendations for improving database maintenance and overall performance
5. Recommendations to improve data management
6. Recommendations for migrating to new data models
7. Recommendations on when to use a File Geodatabase, Enterprise Geodatabase, and Hosted Feature
Services (as the source of data for a user in a particular use case)
8. Review of existing GIS integrations and efficient use of FME
9. Transition Plan from ArcGIS Desktop to ArcGIS Pro
City of Bozeman | January 15, 2021 | Page 9
5. RELATED EXPERIENCE WITH PROJECTS SIMILAR TO
THE SCOPE OF SERVICES
M. Nasir Shir, GISP, joined Sewall in October 2020 with nine (9) years of experience as a GIS manager at the City of
Portland, Maine, which is similar in size to Bozeman, MT. He faced similar challenges as the City is currently
addressing in his previous workplace and is confident that he can assist in providing the best solution based on his
experience. Aside from these nine (9) years, Mr. Shir has over 25 years of experience working with Esri products. In
fact, he worked as an Esri distributor for three (3) years.
The City of Portland framework is very similar to Bozeman based on the correspondence between Mr. Shir and the
City of Bozeman staff. Like the city of Bozeman, Mr. Shir also worked with Esri in reference to system designs and
the architecture structure of data flow between Esri products. Bozeman staff may well be familiar with the Esri
document titled “Architecting the ArcGIS Platform: Best Practices.” This document is kept up to date with the latest
version of Esri software, and the most recent update was in September 2020.
In addition to the City of Portland, Mr. Shir has worked closely with other cities in the state of Maine by sharing
information and ideas for best practices for specific types of data and groups.
Sewall has delivered web-based GIS applications to clients for 20 years, beginning with ESRI’s ArcIMS product in
2000. When ArcGIS for Server replaced IMS, we were early adopters and have continuously upgraded our platform
as the capabilities of Server were improved. We deployed ArcGIS Enterprise (Portal and Server) in 2019, and now
run version 10.8.1, which is the most current release.
Sewall’s GIS server software was deployed on our own hardware in commercial data center space from 2007 to
2019, serving numerous clients, each having secure apps and data. In 2019, we transitioned the system to
infrastructure provided by Amazon Web Services (AWS), the leading commercial cloud provider. We have found
that AWS provides increased reliability, scalability, performance, and security; it is now the most common method
of deployment for ArcGIS servers.
The Sewall organization spans several
disciplines and is growing. We have identified
ArcGIS Enterprise Portal as a strategic platform
to enhance collaboration and improve
client service by the engineers, surveyors, and
GIS professionals that make up our staff. Two
on-going internal initiatives are actively
promoting the effective use of Portal and the
building of valuable shared content.
City of Bozeman | January 15, 2021 | Page 10
Old Town Water District Asset Mapping and Inspection Support
Sewall assists the Old Town Water District with asset management and providing the information in online web
maps.
Under pressure from the Public Utilities Commission to comply with digital infrastructure mapping requirements,
Old Town Water District recognized the need to convert its paper and Mylar drawings to digital format.
Simultaneously, the City of Old Town’s Public Works Department was in the midst of a drainage infrastructure
inventory project to identify and locate these assets. What the City needed was a user-friendly yet comprehensive
digital mapping and record-keeping system enabling the City’s utility departments - Public Works and Water
Pollution Control - and the Water District to track the history, condition and maintenance of their assets.
Working with Sewall, the City’s solution was to develop a common utility GIS, integrating water, sanitary sewer, and
stormwater asset information. As a cooperative effort between the City and Water District, both entities shared in
the development costs and efficiency benefits of a standard, centralized system.
In summer 2007, Sewall staff collected field data, including GPS locations and descriptive information on various
water, sewer and stormwater infrastructure features. Following completion of the data collection, Sewall GIS
professionals post-processed the GPS data to sub-meter accuracy and developed digital spatial data layers for each
of the collected features, including manholes, catch basins, hydrants and water valve locations. Sewall then worked
with each utility to gather attribute data on underground features (water lines, storm drainage pipes, and sanitary
sewer lines) from card files, databases, as-built plans and construction drawings. Using these legacy data sources,
Sewall was able add breadth and functionality to the spatial data layers with such utility information as pipe size,
diameter, material of construction, installation date and maintenance history.
Since then, Sewall has worked regularly with each utility to
learn about its specific work processes and data needs.
Such information as maintenance schedules, repair history,
and reporting requirements, combined with spatial location
and feature attribute information, will be vital to the
ultimate use of the GIS as an asset maintenance
management system.
Ultimately, the system will allow the City and Water District
to plan more effectively and manage their assets more
economically and efficiently than ever before.
City of Bozeman | January 15, 2021 | Page 11
Utility Asset Conversion, Migration, & Application Development for Norwich Public Utilities
Beginning in 2013 and continuing through 2018, Sewall has provided an extensive set of GIS services for Norwich
Public Utilities (NPU). During this time, Sewall has completed multiple projects for data conversion and migration
services, geodatabase development, utilities management, server configuration, and application and script
development for systems mapping and deployment in an ArcGIS environment. Utility assets belonging to NPU’s gas,
water, and wastewater systems were converted and migrated from Trimble’s Utilities Center to ArcFM and later to
ArcGIS using FME and other software tools. Sewall’s most recent efforts included the development and deployment
of a web application for the maintenance of gas leak inspections and repairs.
City of Bozeman | January 15, 2021 | Page 12
GIS Geodatabase Development and Maintenance for City of Atlanta, Georgia
Sewall also has worked for many years with the City of Atlanta to maintain their data for public safety and deploying
the data in a platform the City uses.
Sewall assisted the City of Atlanta, Georgia, with developing and integrating a street centerline file with address
ranges and point addresses for the 400,000+ addressable locations within the City limits. This data is now installed
on the City’s PSSI GeoServer Computer Aided Dispatch (CAD) system to provide accurate X, Y coordinate and
nearest address information for distress calls made from GPS-equipped cellular, traditional cellular and landline
telephones. Sewall’s initial responsibility included the validation of newly captured centerlines, address ranges, and
street names from a geospatially-oriented data set (GeoBase) against an existing tabular-based MSAG file that
contained street names and ranges. Sewall identified and corrected address parity issues, missing or duplicated
street segments, and street naming and alias problems.
Sewall acts as the GIS services component for the City, supporting updates to all GIS related features deployed in
the City of Atlanta CAD and emergency services system. Sewall is presently working as the resource to incorporate
updates and additions to the addressing and street data. In addition, Sewall is working with City officials to develop
a plan that leverages this data and additional GIS data in resource planning, response and reporting assignments,
and other emergency planning activities.
City of Bozeman | January 15, 2021 | Page 13
6. STATEMENT OF QUALIFICATIONS
Sewall utilizes the latest versions of Esri server products on a daily basis. We operate ArcGIS Enterprise (Portal and
Server 10.8) on Amazon Web Services (AWS) in addition to our own ArcGIS Online (AGOL) Organization hosted by
Esri. These platforms are used for internal and external (client-facing and, in one case, public-facing) applications
and services. Enterprise is increasingly becoming the authoritative, shared library of geospatial content for our
entire company, including our engineers.
We also use a local install of ArcGIS Enterprise Database Server (Workgroup) for multi-user production editing with
ArcMAP and ArcGIS Pro. Many of our projects include the design of database schemas; formal design of editing
workflows including versioning, replication, and reconciliation; and distribution and publishing of periodic updates to
user groups.
Given the range of infrastructure we have in place, for each new project we can identify the technology plan and the
roles of each project stakeholder by answering the following questions:
1. How do they use the data?
2. How do they use the software--to which capacity or level?
3. How often do they access the data and software?
4. For what purpose(s) do they use the data and software?
5. Is the data shared with others? If so, how is it used? Which platform is used to share the data?
Over its 140 years in business, Sewall has been at the forefront of developing many types of GIS projects including
creation of topographic maps, engineering, surveying, flying its own aircraft for aerial imagery, and more. To be
successful at this or any production work, one needs to have a rigorous QC/QA process in place.
City of Bozeman | January 15, 2021 | Page 14
7. REFERENCES
Below, Sewall presents its references for GIS projects similar to the City of Bozeman’s, presented in Section 5.
Old Town Joint Project:
Mr. Bill Mayo
City Manager
City of Old Town
265 Main Street
Old Town, ME 04468
207-827-3965
bmayo@old-town.com
Old Town Joint Project:
Mr. Steve Lane
Superintendent
Old Town Water District
109 Center Street
Old Town, ME 04468
207-827-2145
info@oldtownwater.org
Mr. David Poore
GIS Manager
Norwich Public Utilities
16 South Golden Street
Norwich, CT 06360
860-823-4195
davidpoore@npumail.com
Mr. Mark Tursich
IT Senior Project Manager
City of Atlanta
Atlanta Information Management
Atlanta Police 911 Communications
180 Peachtree St NW, 5th Floor
Atlanta, GA 30303
404-546-3043
mtursich@atlantaga.gov
City of Bozeman | January 15, 2021 | Page 15
8. PRESENT AND PROJECTED WORKLOADS
As an active engineering, forestry, and geospatial services company, Sewall’s current work activities are near
capacity for the engineering division over the next several months. Forestry, which includes several GIS
professionals, is at 50% capacity due to COVID restrictions on travel. Although the geospatial division has several
large contracts to fulfill over the next several months as well, there is still 25% of its capacity available. Specifically,
since Mr. Shir is new to the company, his is currently utilized at just 30% which will allow him ample time to give the
City of Bozeman and this project his full attention.
There are 12 dedicated GIS professionals on the Geospatial Services team that can be brought into the project as
needed, and additional employees in other divisions that have a background in GIS and system and database
designs. To successfully complete this project Sewall will involve our database administrator, a GIS Analyst, a
software developer, or a project manager who may have the relevant experience and can contribute to the project.
City of Bozeman | January 15, 2021 | Page 16
9. KEY PERSONNEL
In this section, Sewall presents its key personnel, their contract roles, and full resumes.
9.1. KEY PERSONNEL AND CONTRACT ROLES
Key personnel and contract roles for the City of Bozeman’s project will be:
• Matthew Dieterich—Project Officer
• M. Nasir Shir, GISP—Project Manager
• Justin Mugnai—Technical Lead, Database Review
• Gary Mullaney—Esri Support, QC/QA Lead
• Morgan Cameron—Technical Lead, Data Management/FME Usage
Matthew Dieterich, Executive Vice President, will be the project officer for this project. His role will be to sign all
contracts and work orders and ensure that the City of Bozeman receives the best possible final product. Mr.
Dieterich has over 27 years’ experience in program, asset, and development management. He oversees the
geospatial operations division of Sewall, and in the engineering division, specializes in construction management.
His previous experience included providing capital program support for the Trust for the National Mall in
Washington, DC, and overseeing master scheduling, contractor selection, contract document development, design
reviews, and on-site construction management for the $120 million rehabilitation of Constitution Gardens.
M. Nasi Shir, GISP, Director of Geospatial Services, will be the project manager and the primary point of contact for
the City of Bozeman. He recently joined Sewall with nearly 25 years of experience in leadership and management
positions in Information Management Technology. Skills include producing complex GIS projects, facilitating groups
to achieve consensus toward common goals, and creating a bridge between GIS technical teams and policy makers.
Mr. Shir is skilled in GIS business development as well as providing training and technical support. While working
with the Esri distributor in Afghanistan, he was an Esri Authorized Instructor for multiple Esri courses. Mr. Shir is
also skilled in ArcGIS Online, ArcGIS Desktop, Geodatabases admin, Collector, & Survey 123, Python, Model Builder,
SQL, and Postgres. He has experience overseeing geodata and quality assurance of GIS systems and international
land development work (cadastral mapping) with the United Nations Development Program (UNDP).
Justin Mugnai, Senior GIS Analyst, will review the City of Bozeman existing enterprise geodatabases, file
geodatabases, and identify database maintenance and over performance. He has more than 17 years of experience
with town and countywide address sources, GIS data analysis and geocoding processes, as well as importing and
exporting SDE data. He is responsible for data conversion processes and geodatabase schema design for Sewall’s GIS
conversion services. On large-scale utilities and government projects, he institutes optimized QA/QC procedures as
well as regulating production workflow and answering technical and project specific questions. He is proficient with
a range of GIS and CADD software, including ArcView, ArcGIS, AutoCAD, MapInfo, FME, MicroStation and X-Map.
Gary Mullaney, Senior GIS Consultant, will support the team in reviewing existing material from the City of
Bozeman and Esri’s recommendations, and comparing them to similar projects for present and past Sewall clients.
He will also provide QC/QA oversight. Mr. Mullaney came to Sewall after 26 years in the forest industry (MWV),
City of Bozeman | January 15, 2021 | Page 17
where he provided strategic planning and financial analysis for an operating unit and for the forestry division. In
addition, he was responsible for the development of GIS and forest inventory systems. As Director of Systems at
Sewall, Mr. Mullaney supervised a consulting team which delivered software engineering, web services, database
administration and systems integration to Sewall clients in a number of different industry and government sectors.
In 2012, his role was expanded to include forest economics, wood resource studies, and a variety of other forestry
consulting activities.
Morgan Cameron, Database Administrator, will primarily be involved in data management integration and FME
usage in reference to channeling data to the appropriate repository, such as enterprise geodatabase. He is currently
responsible for client database and application update deployment, backup and security. Mr. Cameron provides
systems and application technical support, including resolution of data issues and assistance with ArcGIS editing
issues. Mr. Cameron was one of the founding team members of the Forest Technology Group, a former subsidiary
of MeadWestvaco, with responsibilities that have included designing, developing and maintaining webFRISTM, GIS
application development, data translation and migration, forest inventory software and data processing, and
network and system administration.
9.2. RESUMES
On the following pages, Sewall presents full resumes for the outstanding team of professionals that will work on the
City’s project.
Matthew Dieterich
Executive Vice President
Matthew Dieterich joined Sewall in 2018 with over 27 years’ experience in program, asset,
and development management. He oversees the geospatial operations division of Sewall,
and in the engineering division, specializes in construction management. His previous
experience included providing capital program support for the Trust for the National Mall in
Washington, DC, and overseeing master scheduling, contractor selection, contract document
development, design reviews, and on-site construction management for the $120 million
rehabilitation of Constitution Gardens. He also served as the program manager for the National Park Service
Construction Management Services nationwide, and has overseen contracted construction support services for the
Department of State at overseas embassies (Moscow, Russia; Freetown, Sierra Leone; Wellington, New Zealand;
Shenyang, China; and Nuevo Laredo, Mexico).
Previously, Matt worked as development manager for Celebration Associates/Mount Washington Resort on a 980
unit resort real estate development program and resort capital projects, and as the director of asset management
for American Skiing Company.
EDUCATION
▪ MS, Civil Engineering, Construction Management Program, Massachusetts Institute of Technology
▪ BS, Civil Engineering, Massachusetts Institute of Technology
HONORS/ORGANIZATIONS
▪ EIT—Commonwealth of Massachusetts
▪ Board Member, Paris Utility District, 2014-Present
▪ Member, Construction Management Association of America (CMMA)
RELEVANT EXPERIENCE
2018 – Present, James W. Sewall Company
Executive Vice President
Oversees geospatial services at Sewall, including budgeting, sales, and production. Responsible for researching and
contracting for a new enterprise resource planning (ERP) system that will be implemented in 2019. Provides
construction management services for engineering at Sewall.
2009 – 2018, The Louis Berger Group, Inc., Washington, DC, and Portland, ME
Senior Program Manager
Trust for the National Mall, Washington, DC. Provided support for capital programs, including the $120 million
rehabilitation of Constitution Gardens. Phase I services include master scheduling, contractor selection, contract
document development, design reviews and on-site construction management.
M. Dieterich | Page 2
Overseas Building Operations (OBO). Deputy Program Manager for overseeing contracted construction support
services for the Department of State at overseas embassies and other real property. Responsible for proposal
preparation, personnel mobilization and task order management. Locations include Moscow, Russia, Freetown,
Sierra Leone, Wellington, New Zealand, Shenyang China, and Nuevo Laredo, Mexico.
American Transmission Company. Project Manager for review of ATC Construction Oversight Program. Identified
areas for improvement including application of defined Construction Management process, improved
documentation and application of technology driven project controls to improve operational efficiency and quality
and reduce potential risks associated with compliance, liability and safety.
National Park Service Construction Management Services. Program Manager responsible for administration and
oversight of Nationwide Program in excess of $165 million in construction value, including solicitation response,
project management, and client interaction. Projects included:
• National Mall and Parks (Washington, DC)
o Potomac Park Levee- Design management for new structure across 17th Street ($5 million)
o Lincoln Memorial Reflecting Pool Rehabilitation ($34.9 million)
2015 ACEC Metro Washington Engineering Excellence Award, Grand Award Winner, Design
o Washington Monument Earthquake Damage Repair ($11.3 million)
2014 ENR MidAtlantic—Best Cultural/Worship Project
2014 ENR MidAtlantic—Safety Award of Merit
2015 ACEC Metro Washington Engineering Excellence Award, Grand Award Winner, Non-Design
2015 ACEC Engineering Excellence Award, National Recognition Award
• Hawaii Volcanoes National Park (Volcano, HI). Visitor Emergency Operations Center ($4.4 million) and
Volcano House Life Safety Upgrades ($2.7 million)
• Jefferson Expansion National Monument (St. Louis, MO. Old Courthouse Roof Replacement ($4 million)
and St. Louis Arch Trams PLC Upgrade ($2.7 million)
• Statue of Liberty National Monument (New York, NY). Statue of Liberty- Life Safety Upgrades in
preparation for crown re-opening ($1.2 million) and Ellis Island- Seawall Repair ($19.9 million)
• Perry's Victory National Monument (Put-in-Bay, OH). Restoration ($4.25 million)
• Acadia National Park (Bar Harbor, ME). Roadway & Culvert Improvements ($3.7 million)
• Shenandoah National Park (Luray, VA). Roadway Improvements ($21.9 million)
2006 – 2009, Celebration Associates/Mount Washington Resort, Bretton Woods, NH
Development Manager
Responsible for planning, permitting, and financial model development for a 980 unit resort real estate development
program and resort capital projects. Scope included four major resi-dential areas and mixed use
residential/commercial village at base of Bretton Woods Ski Area.
2002 – 2006, American Skiing Company, Bethel, ME
Director of Asset Management
Responsible for real estate development at Sunday River, Sugarloaf, Killington, Mount Snow, and Attitash ski resorts.
Duties included negotiation of sales and/or development of joint venture projects to support corporate disposition
strategy. Responsibilities included site planning, design, permitting, plan review, and marketing and sales support.
M. Nasir Shir, GISP
Director of Geospatial Services
Mr. Shir recently joined Sewall with nearly 25 years of experience in leadership and
management positions in Information Management Technology. He has extensive
experience coordinating multi-divisional operations in posts with the State of Maine, the
United Nations, and in higher education. Skills include producing complex GIS projects,
facilitating groups to achieve consensus toward common goals, and creating a bridge
between GIS technical teams and policy makers. Mr. Shir is skilled in GIS business
development as well as providing training and technical support. While working with the Esri distributor in
Afghanistan, he was an Esri Authorized Instructor for multiple Esri courses. Mr. Shir is also skilled in ArcGIS Online,
ArcGIS Desktop, Geodatabases admin, Collector, & Survey 123, Python, Model Builder, SQL, and Postgres. He has
experience overseeing geodata and quality assurance of GIS systems and international land development work
(cadastral mapping) with the United Nations Development Program (UNDP). He is fluent in English, Pashto, and Dari,
and understands Urdu and Hindi.
EDUCATION
▪ MA, Community Planning & Development, University of Southern Maine
▪ BA, Geography & International Development, Clark University
LICENSES & CERTIFICATIONS
Certified GIS Professional (GISP), (GISCI Certification No. 59861)
NON-PROFIT ORGANIZATION LEADERSHIP & BOARD MEMBERSHIP
▪ Member, Board of Visitors, University of Southern Maine
▪ Member, Cumberland County Committee, Maine Community Foundation
▪ Member of GISCI Outreach Committee
▪ Past Member, Maine GIS User Group (MEGUG)
▪ Past Member, Maine Civil Liberties Union (MCLU)
▪ Past Member, Waynflete Board of Trustees
RELEVANT EXPERIENCE
2020 – Present, James W. Sewall Company
Director of Geospatial Services
Duties include leading and working with Sewall’s geospatial team to diversify its clientele and acquire new projects
involving geospatial technology. He is responsible for all Esri products, making decisions about how and when to
deploy these product both internally and externally for clients, especially when setting up Esri enterprise systems. He
also participates in the QA/QC of geospatial data along with other members of the team.
2012 – 2020, City of Portland, ME
GIS Manager (2014-2020)
Set up, maintain, and upgrade GIS Enterprise, hardware, software, servers, and build GIS applications for the field
staff and for internal departmental use.
GIS Technician (2012-2014)
Create customized maps. Produce data analyses and GIS schema based on custom requirements.
2009 – 2011, Geographic Information System Working, Afghanistan
Executive Director
Led the Kabul branch office of GISWorking, headquartered in Mendoza, Argentina.
2006 – 2009, GeoVision Afghanistan (GVA), Liwal Ltd., ESRI for Afghanistan
Co-founder
Co-founded GVA, the GIS Division of Liwal Ltd, which is the official ESRI distributor for Afghanistan.
2006 – 2006, U.S. Agency for International Development (USAID)
Project Consultant
Short term consultant studying how current tracking and reporting systems can be used to track USAID
Performance Monitoring Plan. Met head of agencies and directors within USAID, Government of Afghanistan,
and United Nations Agencies such as United Nation Development Program (UNDP).
2003 – 2006, AIMS United Nation Development Program (UNDP), Kabul, Afghanistan
Provided information management services to the Afghani government and to the broader humanitarian aid
community. Built information management capacity within the national government of Afghanistan.
Typical tasks at Afghanistan Information Management Systems (AIMS) include GIS services, digital mapping,
standardization, project support, systems set up, and distribution of technical files.
Human Capacity Developer (2005 – 2006)
Developed the capacity of all AIMS staff by creating individual development plans, mentoring, coaching, identifying
training, and creating AIMS internal policies and schemes for staff development.
Technical Manager (2004 – 2005)
Led the GIS, Database, and ICT teams to create new applications and standardization for AIMS products.
Documented the process of creating new standardization and created guidelines.
Government Project Coordinator (2003 – 2004)
Developed programs and gave technical policy advice to the government ministries and departments of
Afghanistan. Initiated, coordinated, and managed many types of programs, including GIS and ICT.
Justin Mugnai
Senior GIS Analyst
Justin Mugnai has more than 17 years of experience with town and countywide address
sources, GIS data analysis and geocoding processes, as well as importing and exporting SDE
data. He is responsible for data conversion processes and geodatabase schema design for
Sewall’s GIS conversion services. On large-scale utilities and government projects, he
institutes optimized QA/QC procedures as well as regulating production workflow and
answering technical and project specific questions. He is proficient with a range of GIS and CADD software, including
ArcView, ArcGIS, AutoCAD, MapInfo, FME, MicroStation and X-Map.
EDUCATION
▪ BS, Chemical Engineering, University of Maine
RELEVANT EXPERIENCE
2001 - Present, James W. Sewall Company
GIS Analyst
Rockland County, New York. Lead coordinator of schema translation of five towns, editing tool modifications and
combining /creation of county-wide geodatabase.
Stoughton, Massachusetts. Lead developer of process to import/export town e911 data with MassGIS schema.
Tools and documentation created for the process were delivered to Stoughton officials.
City of Atlanta, Georgia. Responsibilities include QA/QC of address and street data within the city’s e911 GIS system;
maintaining and regulating quarterly editing workflow; exporting data for delivery in multiple formats on a quarterly
basis; as well as being the technical point of contact for the client.
ConnectME Authority, Maine. Responsibilities include development of geodatabase schema and workflow for
capture and storage of the state of Maine’s 600,000+ broadband service records and related 141,000+ associated
street centerline segments ; development of QC and delivery mechanisms for datasets bi-annually having to
conform to both state and federal requirements.
Enfield, Maine. Coordinated a Pavement Assessment Study to evaluate and document the current conditions of the
roadways in Enfield, Maine. Mr. Mugnai developed the field data application and translated data post field work.
Mr. Mugnai worked directly with Sewall engineers to produce a prototype web enabled dashboard to assist Enfield
with budgetary and road repair planning.
South Central Connecticut Regional Water Authority (RWA). (2014) Responsible for all aspects of photogrammetry
DTM and plan updates for a large 668 square mile area, comprised of the Towns of Ansonia, Derby , Seymour,
Cheshire, Orange, West Haven, New Haven, East Haven, Bethany, Meriden, Southington, Durham, Haddam,
Killingworth, Madison, Guilford, Wallingford, North Branford, Prospect, Beacon Falls, and Hamden CT.
J. Mugnai | Page 2
AGL Services Company/Southern Company, Atlanta, GA. Responsibilities include development and maintenance of
workflow for mobile field data collection application designed by Sewall; assist with Class Locations and High
Consequence Areas (HCAs) analyses for the site surveys completed in 2015 throughout the company’s service
territories in support of its Transmission Integrity Management Program (“TIMP”).
Connect Maine Authority. Analyst for state-wide broadband mapping project. Leading data processing tasks and
provides QA/QC oversight; leading geocoding processing of wired Service Provider data; leading validation efforts
for wired service data. Instrumental in developing custom tools integrate into an ESRI platform for extracting
different feature sets for both State and NTIA. Sewall is developing mapping and address data representing the
availability of broadband service in the State. This project is being executed to support the Agency in meeting its
requirements to deliver data that is being used to create a nationwide broadband map.
Penobscot Nation, Indian Island, Maine. Analyst. Performed data model and workflow analysis for implementation
of Cartegraph asset management software across sewer, water and transportation utilities. Developed additional
workflows and data models along with custom forms and reports for historic preservation and land
assets. Performed a needs assessment for the various assets as well as a conversion data source matrix to facilitate
transfer of data to the asset management system.
Old Town, Maine. To comply with Public Utilities Commission’s digital infrastructure mapping requirements, Water
District and Public Work’s Department hired Sewall to develop a common utility GIS, integrating water, sanitary
sewer, and stormwater asset information. Responsibilities included database schema creation for storm, sewer and
water systems and oversight and QC of data creation and population of attributes.
City of Atlanta, Georgia Maintain on a quarterly basis the street centerline and addressing services for the City of
Atlanta Public Safety’s wireless implementation project. Responsibilities include collecting and organizing quarterly
updates from Northrop Grumman, QA/QC of address and street centerline edits, point of contact to client for
source discrepancies, maintaining and regulating workflow, exporting data into MapInfo and .SHP file formats for
delivery.
City of Atlanta, Georgia. Assisted in geocoding production work and QA/QC tasks for street centerline and
addressing services for the City of Atlanta Public Safety’s wireless implementation project. Created street centerline
and address point layers to represent more than 400,000 physical addresses, providing geocoding capability for the
E-911 mapping system. Responsibilities included training technicians, creating and documenting the street
centerline process, maintaining and regulating workflow, exporting data into MapInfo and .SHP file formats as well
as fielding questions for all phases of the project.
Westchester County, White Plains, New York. Project goal was to develop an address record data set that will
support both GIS functionality and Computer Aided Dispatch functionality in the County’s Intergraph ISP system.
Responsibilities included construction of address data database schema and creation and oversight of automated
and manual processes for scrubbing collected address data sources for the towns of Eastchester and New Rochelle.
Gary E. Mullaney
Forest Economist and Senior GIS Consultant
Gary Mullaney came to Sewall after 26 years in the forest industry (MWV), where he
provided strategic planning and financial analysis for an operating unit and for the forestry
division as a whole. This work included two resource studies which were presented at the
Southern Forest Economics Workers (SOFEW) and published in their Proceedings. In
addition, he was responsible for environmental compliance for company lands in Kentucky
and Tennessee and for the development of GIS and forest inventory systems. As Director of Systems at Sewall, Mr.
Mullaney supervised a consulting team which delivered software engineering, web services, database
administration and systems integration to Sewall clients in a number of different industry and government sectors.
In 2012, his role was expanded to include forest economics, wood resource studies, and a variety of other forestry
consulting activities.
EDUCATION
▪ MS, Forestry – Duke University - Emphasis Forest Economics
▪ BS, Forestry – North Carolina State - With High Honors
RELEVANT EXPERIENCE
2012 – Present, James W. Sewall Company
Forest Economist and Senior GIS Consultant
Mr. Mullaney has the following responsibilities:
Wood fiber resource studies, fiber supply and price modeling, market studies and benchmark studies, price indexing
mechanisms, forest land ownership trends; needs assessment and design of spatial information systems for a variety of
natural resources, municipal and engineering clients.
Examples of recent projects (confidential clients) include:
Maine Forest Economic Growth Initiative. State-wide study assessing inventory, growth/drain and prices by four
regions.
Comprehensive Wood Supply Study. Geospatial analysis and projection of wood resource dynamics for a wood-
based liquid biofuel producer (U.S. South).
Comprehensive Wood Supply Study. Geospatial analysis and projection of wood resource dynamics for an oriented
strand board producer (U.S. South).
G. Mullaney| Page 2
Comprehensive Wood Supply Study. Geospatial analysis and projection of wood resource dynamics for a pulp and
paper mill and sawmill (U. S. South).
Wood Procurement Spatial Information System. Design and development of a web-based GIS system for tracking direct
purchases of stumpage by a southern pulp and paper mill.
2006 – 2012, James W. Sewall Company
Director, Systems
As the Director, Systems, Mr. Mullaney had the following responsibilities:
Supervised a consulting team made up of software engineering, web services, database administration and systems
integration. Developed information systems for a variety of natural resources, municipal and engineering clients.
Examples of projects include:
American Forest Foundation. As Consultant and Project Administrator, conducted business process analysis, needs
assessment, evaluation of commercial software offerings, and was responsible for contracts and billing, planning and
budgeting. Scope of services included implementation of new version of American Tree Farm System, a web-based
application for maintaining the Tree Farm database.
Rigesa, Santa Catarina, Brazil. Project Manager and Report Developer for implementation of webFRISTM, a real-time,
web-based enterprise geospatial solution for the management of forestry data through a centralized database.
Responsible for scope and objectives, tasks and schedules, acceptance criteria and testing, day to day project
oversight and hands-on development of custom reports.
MWV. Project manager for a division-wide GIS needs assessment and design of an enterprise GIS system based on
ESRI’s ArcGIS 10 software platform. Significant changes in the business model for MeadWestvaco’ lands division led
them to consider new approaches to GIS that would be more flexible and better support their real estate
development activities. The project included the creation of a pilot database, workflows for distributed editing,
customized training, and the design and development of custom tools and extensions.
First Wind: Project Manager for new enterprise web-GIS viewer/publishing system using the Google Maps Enterprise
API, extended by unique Sewall technology. The Google Maps API was selected for performance, familiarity, and
richness of background data. Because newly acquired spatial data is now quickly made available company-wide, the
wind project development teams are able to collaborate more effectively, and maintain the required fast pace of data-
driven decision making.
Rockland County, New York. Project Manager for Rockland County GIS Portal on the Sewall GeoPower™ platform, an
innovative on-line solution that provides comprehensive shared spatial data, maps, and applications across
government departments, to the public and into the private sector. Based on ESRI server technology, GeoPower
allows a wide range of users to search through, access, and interact with a centralized, authoritative repository of
spatial data with only a standard browser and Internet connection. Rockland County’s GIS professionals are able to
post custom web applications, a library of ready-to-print maps, and GIS data files for download.
Morgan L. Cameron
GIS/Database Engineer
Morgan Cameron is currently responsible for client database and application update
deployment, backup and security. Mr. Cameron provides systems and application technical
support, including resolution of data issues and assistance with ArcGIS editing issues. Mr.
Cameron was one of the founding team members of the Forest Technology Group, a former
subsidiary of MeadWestvaco, with responsibilities that have included designing, developing
and maintaining webFRISTM, GIS application development, data translation and migration, forest inventory software
and data processing, and network and system administration.
EDUCATION
▪ B.S., Forestry, Mississippi State University
▪ M.S., Forestry, University of Maine
HARDWARE/SOFTWARE EXPERTISE
▪ Databases: Oracle, SQL Server, PostgreSQL, Ingres, Access
▪ Programming languages: C#, Visual Basic, FORTRAN, ArcGIS AML, Unix shell scripts (Bourne, C, Bash), SQL,
Oracle PL/SQL, PostgreSQL pgplsql, C, Java, python
▪ GIS: ArcGIS, Oracle Spatial, PostGIS, GDAL
▪ Platforms: Windows desktop and server, Solaris, Linux (Red Hat)
RELEVANT EXPERIENCE
2007 – Present, James W. Sewall Company
Database Administrator
American Forest Foundation. Project manager for implementation of new version of American Tree Farm System, a
web-based application for maintaining the Tree Farm database. Responsible for database design, data migration,
software updates and enhancements, report development (JasperReports), QA testing and client technical support.
MeadWestvaco, South Carolina; Rigesa, Santa Catarina, Brazil. Technical project leader for implementation and
migration of client data into an ArcGIS SDE Oracle geodatabase and implementation and administration of ArcGIS
Server services. Responsible for database and application update deployment, backup and security, and provide
systems and client technical support. Designed, programmed and deployed application for processing of timber
inventory data and integration and synchronization of the inventory data with the GIS database.
M. Cameron | Page 2
Timberland Investment Resources, LLC. Responsible for the update and maintenance of forest inventory cruise data
in a SQL Server database. Developed SQL scripts for identifying stands needing inventory updates and tracking data
collection and processing progress. Activities include creating, reviewing and editing GIS spatial data for stands and
roads.
WestRock, South Carolina, North Carolina; Pixelle Specialty Solutions, Ohio. Responsible for database and ArcGIS
Server service administration and deployment of a web-based application used to manage spatial and tabular
inventory of stumpage purchasing activities. Responsible for custom report development and deployment
(JasperServer). Provide systems and client technical support.
Rockland County, New York. Database administrator for implementation and migration of client data into an ArcGIS
SDE Oracle geodatabase and administration and deployment of ArcGIS Server services. Responsible for data and
web application deployment, database backup and security, and provide systems and client technical support.
Database developer for the Rockland County Emergency Application, which enabled real-time data entry and
sharing of road obstructions during storm events.
Norwich Public Utilities, Connecticut. Responsible for data translation and migration of various data layers (gas,
water, sewer, valve inspections) into standard ESRI data models implemented in a SQL Server ArcGIS SDE
geodatabase. Assisted in the design, development and deployment of a web-based gas leak maintenance
application which utilized ArcGIS Server map services.
Chenango County, New York. Database administrator for development of a web based mapping solution to
streamline the process of matching county services (employers, day care providers, training partners and
community resources such as food pantries) with clients. Provided database design and technical support.
Danbury, Connecticut. Database administrator for creation of two web based GIS viewer applications. Responsible
for database deployment, backup and security, and provided systems and client technical support.
Various Municipal Clients, Eastern US. Database administrator for more than 30 projects involving the development
and implementation of web-based viewers for government entities throughout the Eastern US. Responsible for
database deployment, backup and security, provide systems and client technical support.
1985 – 2007, Westvaco/MeadWestvaco/Forest Technology Group
Database Administrator
Served as DBA for the webFRIS 3 application, which was based on X-Hive (a native XML database) and
PostgreSQL (an open-source relational database). Duties included all aspects of configuration, performance
tuning, deployment, security, backups, replication, fail-over, and disaster recovery.
Served as DBA for the webFRIS 2 application which was based on Oracle 9, using Oracle Spatial. Duties included
data migration (tabular and spatial), database code development and deployment, backups and disaster
recovery.
M. Cameron | Page 3
Served as DBA for the webFRIS 1 application which was based on SQL Server and ArcIMS. Duties included
database deployment, backups and disaster recovery.
Served as DBA for FRIS, a distributed Arc/Info and INGRES application running on Unix (Solaris) workstations at
more than a dozen locations (including Brazil).
GIS
Member of a team that designed, developed, and maintained the Arc/Info application components of the
MeadWestvaco Corp. FRIS application.
Extensive Arc/Info training and experience (since 1986), including AML, ArcIMS and ArcSDE.
Data Migration and Database Programming
Technical leader in the client data migration process. Developed extensive SQL programming to transform data
and assure quality.
Developed database functions using Oracle PL/SQL and PostgreSQL pgplsql.
Performed GIS data transformation using Arc/Info, ArcSDE, Oracle Spatial, FME, and PostGIS.
Windows/UNIX/Linux System Administration
Performed setup, configuration and administration of distributed Sun (Solaris) workstations.
System/Network Administrator for MeadWestvaco Division FRIS group and Forest Technology Group subsidiary
(1995-2001).
Handled Windows and Linux setup and administration tasks in cooperation with and as a backup for the Forest
Technology Group Network and Systems lead.
Compiled and prepared distribution for PostgreSQL database server software.
Software Development
Extensive FORTRAN large systems experience, primarily FRIS.
Extensive SQL, including procedural SQL code generation and relational database design (Oracle, SQL Server,
PostgreSQL)
Other experience includes Arc/Info AML, VisualBasic, C, Java, UNIX shell languages.
Forest Inventory
Designed, coded, and maintained cruise compilation system for MeadWestvaco (FRIS) covering several regions,
many forest types and equation systems.
Member of a team that designed and created field data collection software and data transfer software with
early and more recent handheld computers.
Developed detailed technical specifications for the cruise compilation software that is a part of the webFRIS 2.x
application. Supervised contract programmers.
Forest Growth and Yield
Designed, coded, and maintained forest growth and yield projection system (FRIS) that covers several regions,
many forest types and model/equation systems, including Brazil.
City of Bozeman | January 15, 2021 | Page 29
10. PRICE PROPOSAL
Sewall will provide the services as outlined in the above proposal for a lump sum fee of $35,000.
Once the project begins, the Client will be billed monthly for the percentage of work complete to date.
Payment is due within 30 days after the date of invoice and balances outstanding beyond these terms will accrue
interest at the rate of 1.5% per month (18% per annum), or the legally permitted maximum if that rate is lower.
The prices and schedule listed above are valid for 60 days. If the Client decides to proceed with the project after 60
days from the date of this proposal, Sewall reserves the right to review the cost estimate and schedule, and to make
changes as needed.
City of Bozeman | January 15, 2021 | Page 30
11. ADDITIONAL INFORMATION: QC/QA PROCEDURES
Sewall has its own rigorous internal quality control/quality assurance (QC/QA) procedures that provides clients
confidence in the quality of its work products. The standard procedure for geospatial QC/QA is as follows:
SEWALL QC/QA PROCEDURE
Quality Control Review Assignment - At the onset of a project or task order, assign a Quality Control Reviewer. This
cannot be the same person who is completing the majority of the work. Questions or concerns about the role of the
QC Reviewer should be referred to Sewall’s Quality Assurance Auditor.
Client Deliverables Identification - Identify deliverables requiring review during the project kick-off call and inform
the reviewer and the Quality Assurance Auditor of anticipated schedule for planning and coordination purposes.
Examples of deliverables requiring this level of review are design plans (50%, Final, rtc.), backup calculations,
analysis, reports/memorandums/letters with results and findings, construction cost estimates, aerial imaging
products, data sets, metadata, dashboards and base plans.
Quality Control Review - When the deliverable is ready for review, it should be forwarded to the Quality Control
Reviewer for comment. The QC Reviewer should use the attached QC/QA Checklist and any project specific/topic
specific checklists as a guide. The method of comment will depend on the work product.
• Geospatial - email or memo briefly summarizing comments and concerns.
QC Review Response – Provide a response to the review comments. Provide a clean work product for the QC
Reviewer.
• Geospatial – Provide an email response to the QC Reviewer. If a comment is incorporated, just type
“DONE” – if not, provide an explanation.
QC Process Documentation – Prior to submission of a deliverable to the client, the following shall be saved in a QC
folder within the project directory.
• Geospatial
a. Email review chain culminating in the QC Reviewer clearly stating that the deliverable meets
contractual and Sewall standards.
b. Completed QC/QA Checklist
City of Bozeman | January 15, 2021 | Page 31
12. AFFIRMATION OF NONDISCRIMINATION & EQUAL PAY
(APPENDIX B)
Below, Sewall presents its affirmation of nondiscrimination and equal pay.
Appendix B
NONDISCRIMINATION AND EQUAL PAY AFFIRMATION
James W. Sewall Company (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, James W. Sewall Company (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
Matthew Dieterich, Executive Vice President