The vendor is required to provide geographic information system (GIS) project support services.
- GIS is currently operating as a hybrid governance model with technology, data, and software being managed centrally and users being enabled in a distributed fashion; the GIS architecture has a significant impact on this recommendation and interrelates with the software deployment suggestions.
- IT department provides services related to geospatial web application development, configuration, data integration, data migration database management, networking, hardware, and training for the enterprise-wide GIS.
- Current system architecture:
• The city’s current GIS primarily consists of ArcGIS enterprise, encompass, and AutoCAD.
• ArcGIS portal is used to visualize via the web platform all utility and non-utility GIS data.
• Many GIS datasets have been made available to view and edit via ArcGIS mobile apps like field maps, survey123, and workforce.
• Department-specific custom editing workflows have been enabled using ArcGIS pro.
• Many configurable GIS web application solutions have been configured for targeted editing use cases.
• Many custom advanced GIS web applications have been built using ArcGIS JavaScript API and python; custom geoprocessing services have been built leveraging ArcPy libraries.
• FME server is leveraged for many internal and external geospatial extract, transformation, and load tasks.
- Desired system architecture
• Prevent duplicate and redundant GIS subsystems; prevents the existence of disparate copies of data that inculcate a lack of confidence in data accuracy and completeness.
• To improve efficiency and increase ROI
• Technology simplification
• Enables departments to manage and maintain their business data with ease; facilitates data/information sharing,
• Prevents the existence of disparate copies of data that inculcate a lack of confidence in data accuracy and completeness.
- GIS infrastructure setup and ArcGIS platform configuration:
- The GIS infrastructure will be hosted in the city’s it data center based in city hall and managed by the department; GIS will have different environments like production, staging, and development servers to support software development life cycle processes.
• Deploy, and configure a high available ArcGIS enterprise system that enables GIS content sharing across the enterprise and meets the city’s business requirements.
• Assist with server capacity planning.
• Configure ArcGIS server sites, services, applications, and users
• Configure the web adaptor component to integrate our ArcGIS server with a web server.
• Upgrade ArcGIS enterprise as requested by the city.
• Publish services that have the capabilities required for our applications.
• Plan and create a cache for high-performing map and image services.
• Implement security for our site and services that meet the needs of the city.
- Spatial database management:
- The new enterprise GIS will be maintained in arc SDE (spatial database engine) technology which is a core component of ArcGIS for server.
- Provides the framework to support long transactions, which will facilitate the versioned editing environment in the departments’ multiuser geo-databases.
• Demonstrates and maintains expert knowledge/leadership in configuring and supporting Autodesk topo base on oracle db.
• Demonstrates and maintains expert knowledge/leadership in configuring and supporting program enterprise geodatabase running on oracle and SQL server.
• Configure a multiuser geodatabase for our relational database management system.
• Create a multiuser geodatabase and configure connections to it.
• Configure storage settings to support our organization's data management workflows
• Perform database restores or re-organization as required
• Create/refresh development/QA databases from production data as required
• New database and tool implementation and configuration as required
• Develop database backup scripts and processes as required
• Perform database initiation parameter modifications as required
• Perform database upgrades and patches as required
• Data integrity and corrections as required
• Problem identification of data integrity, errors, and omissions.
• Database performance monitoring, analysis, and tuning as required
• New database/object creation as required
• Application of schema changes, e.g. creation, alteration, and deletion of tables and indices, compilation and dropping of stored procedures and triggers, etc. as required
• Establishing and maintaining database configuration and system parameters consistently across database environments
• Execution of processes for the proper maintenance and functioning of databases, e.g. updating table/index statistics, dropping and rebuilding tables/indices, etc. - Software, application, database development, and integration services:
• Building out the ArcGIS portal for citywide use; configure ArcGIS server sites, services, applications, and users.
• Set up user roles and privileges to provide secure data access.
• Establishing new printing services
• Publish services that have the capabilities required for our applications.
• Develop department-specific targeted custom web map and web map app GIS solutions to meet business requirements, using tools such as ArcGIS JavaScript API and experience builder.
- Spatial modeling and analysis services:
• Using spatial analysis methods, the tool must be able to show polygons of canopy cover for a specified geographic area (citywide, per neighborhood, per parcel, and per selection).
• Some examples include calculations on monetary tree benefits, water savings, energy savings, tree appraisal value, and carbon sequestration.
• Modeling of predicted plant growth and future vegetation management needs.
- System maintenance and support:
• Provide support/change control application where all the work orders from the city will be recorded, approved, tracked, and managed throughout the life cycle.
• Provide written support request troubleshooting procedures for the system and application environment.
• Provide monthly status reports including, but not limited to, work order analysis, actual hour’s usage, average cycle time, quality issues, and improvement recommendations.
• Staffed between 6:00 a.m. PST to 6:00 p.m. PST on weekdays, Monday through Friday, except for city holidays.
• Provide a problem escalation process to ensure urgent problems are resolved according to the service level agreement.
• Provide a process to record after-hours problems for next-day resolution.
• All software modifications and upgrades are deployed using the configuration management, documentation, integration, and acceptance testing requirements as per each negotiated contract during the warranty period and licensing period.
• Provide the appropriate technical resources (at agreed-upon rates) to modify or enhance applications to ensure that the software continues to support city business requirements as per each negotiated contract during the warranty period and licensing period.
• Provide and maintain coding standards and quality control to ensure coding readability, performance, and sustainability.
- Contract Period/Term: 1 year