cincinnati area geographic information system...
TRANSCRIPT
Cincinnati Area Geographic Information System
Detailed Report Activities & Tasks – Oct 6th 2016 For CAGIS Policy Board
CAGIS Administrator – Raj Chundur
Oct 6th, 2016 1
CAGIS Position Vacancy Report- Updates requested by CAGIS Policy Board.
This is a follow up to the previous report on the status of vacant CAGIS positions. Current disposition is
listed below. One position is vacant as of now.
Computer Systems Analyst (CSA) Pending
Candidate Selected – Starting Nov.
GIS Migration Phase 2 – Status
GIS Core layer maintenance by consortium partners:
GIS core consortium layers are critical for the day to day mission critical functions of all agencies. Some
of these critical GIS layers include Addressing, Streets, Property Parcels, Zoning, etc. Each agency in the
consortium relies on another agency within the CAGIS shared system and is the enduring strength of this
CAGIS model. Timeliness and accuracy in maintaining these layers as close to real-time as possible is key
to their use for daily decision making by agencies and providing effective service to citizens. With this in
mind I am requesting the CAGIS board to reinforce the importance of timely and accurate data
maintenance as well as ensure that the relevant agencies plan, train and maintain continuity with their
GIS editing staff.
End User GIS Applications Technology Portfolio:
GIS User Needs Assessment: – In Progress
End User applications with various technologies (ArcMap, Web, Server): In Progress
Gen 8 – Significant development done – Continuing Enhancements. Under Preview Release
Data Distribution Models: In Progress.
Oct 6th, 2016 2
Accela Automation Migration Phase 1- Status
Activities since last policy board report:
1. Enterprise Architecture – vendor working on functionality to be incorporated in their
upcoming software release. Expected timeline for incorporation into CAGIS projects - 1Q
2017.
2. Development of “Proof of Production” for “Building Combo Permit” (a complex work
process): – 95% Complete.
3. Development of a “Proof of Production” for “Code Enforcement Workflow”: Utilizing
Cincinnati Property Maintenance program as a model - 95% Complete.
4. Development of a “Proof of Production” for “Annual Licensing and Inspection Workflow” to
a production quality deliverable: – Utilizing Cincinnati Elevator program as a model – 95%
Complete.
5. Development of a “Proof of Production” for “Dance Hall Licensing” to a production quality
deliverable: – Utilizing Cincinnati Treasury as a model – 95% Complete.
6. Hamilton County “Building Combo Permit” process mapping – Under review by department.
7. Development of a “Proof of Production” for “Contractor Registration” to a production
quality deliverable: – Starting.
8. Development of a “Proof of Production” for “MSD Tap Permit” to a production quality
deliverable: – Starting.
9. Cincinnati Planning and Buildings Migration – RFP Development: Start mid Oct 2016
CAGIS is planning to release the RFP for this project in mid-2017
10. CAGIS Staff (Four) attended the Accela Conference in August. We met with the Chief
Operating Officer and other senior executives to stress the importance of our project and to
continue close collaboration with senior executives to ensure they meet our consortium
needs.
I am continuing weekly internal workshops and review of functionality to evaluate in-depth the new
system and identify commonalities, points of improvements and gaps with the current system. This
effort is important and represents the required preparatory work needed before engaging the
vendor in detailed migration efforts. I continue to have meetings with the vendors on key next
steps.
CAGIS Current Work – Update on recently completed, in progress and planned tasks.
Work Description Program Area Current
Status
Previous
Status
Estimated
Finish
ArcGIS Server map service re-configuration and
standardization
Includes renaming and re-organizing existing map services and
developing publishing guidelines for new map services
according to the ArcGIS Map Service Structure.
Cagis Consortium In Progress -
75%
In Progress -
75%
4Q - 2016
County Buildings & Planning - Functional requirements and
RFPs for Accela Migration
Creation of functional requirements and RFPs for migration to
new Accela Platform for remaining County Building & Planning
workflows.
County Buildings & Planning In Planning In Planning 2Q - 2017
City Buildings - Fee schedule changes
Fee schedule changes for the City Buildings department.
City Buildings Complete -
100%
In Progress -
99%
3Q - 2016
Law Department - GIS integration
Law department quality of life section - GIS tools to assist
enforcement activity.
Cincinnati Law In Progress -
25%
In Progress -
10%
4Q - 2016
MSD - Proof of Production for Sewer Tap Permit
As part of Accela Automation, implement MSD Sewer Tap
permit workflow.
MSD In Progress -
10%
In Progress -
10%
1Q - 2017
EzTrak Server Upgrade
The fire permits credit card vendor raised security
requrements. This resulted in the need to upgrade the ezTrak
server from 2003 to 2012.
CAGIS Consortium In Progress -
80%
4Q - 2016
Cincinnati Police Department CSR Requests
Add 5916000.com and Fix it Cincy to Police devices
City of Cincinnati In Planning In Planning 4Q - 2016
3
CAGIS Current Work – Update on recently completed, in progress and planned tasks.
Work Description Program Area Current
Status
Previous
Status
Estimated
Finish
Hamilton County Health Department (HCHD) Web
GIS/Document Management System
Design and implemented a web GIS and document
management solution for Hamilton County Health
Department’s sewage treatment information system. This
solution provides online interactive mapping for property
owners to check system inspection, approval status and system
maintenance information. It is maintained by HCCH staff on
daily basis.
Hamilton County Health Dept In Progress -
95%
In Progress -
85%
4Q - 2016
City Buildings & Inspections - Functional requirements and
RFPs for Accela Migration
Creation of functional requirements and RFPs for migration to
new Accela Platform for remaining City Building & Inspection
workflows.
City Buildings and Inspections In Planning In Planning 2Q - 2017
Street Centerline and Pavement Editing Tools - Phase II
Make data fixes as needed, add editing of the intersection cross
reference table, add integration with NESIS data
Cagis Consortium In Progress -
35%
In Progress -
25%
4Q - 2016
City Treasury - Proof of Production for Dance Hall Permits
As part of Accela Automation, implement Dance Hall licenses
workflow.
City Treasury - Workflow In Progress -
20%
In Progress -
15%
1Q - 2017
City/County Joint Computed Aided Dispatch (CAD) Phase II
Training of both Cincinnati Police and Emergency Operation
Center (EOC) editing staff, integration of additional GIS data
layers, including University of Cincinnati response areas, mile
markers, river mile markers, bike trails and park trails.
Continue enhancing and examining street centerline data
elements in response to CAD project requirements. Add
additional monitoring and QC python scripting on CAD data
extraction process.
Cagis Consortium In Progress -
90%
In Progress -
90%
4Q - 2016
4
CAGIS Current Work – Update on recently completed, in progress and planned tasks.
Work Description Program Area Current
Status
Previous
Status
Estimated
Finish
CAGIS Online II - New development
The next version of CAGIS Online will utilize JavaScript API and
HTML5 within the application framework of ESRI’s
webAppBuilder. This version of CAGIS Online will provide more
scalability, be highly integrated with other CAGIS enterprise
systems such as permitting and document management, and
more extensible functions beyond the current version.
Cagis Consortium In Progress -
40%
In Progress -
35%
4Q - 2016
County Buildings - Phased Approval Workflow Analysis
As part of the Accela Automation design, document the phased
appeals process.
County Buildings - Workflow In Progress -
90%
In Progress -
75%
4Q - 2016
City Buildings - Proof of Production for Code Enforcement
As part of Accela Automation, implement City Buildings Code
Enforcement workflow.
City buildings - workflow In Progress -
98%
In Progress -
98%
4Q - 2016
ArcGIS Training
Intern/user training for several departments and associate
members, including City Buildings, Performance Analytics, DCI,
Cincinnati Police. Will have more to train when GEN8 rolls out.
ArcGIS Training Ongoing Ongoing Ongoing
CAGIS Consortium - Property, District, Zone search
Creating a new arcgis server service and web methods for
returning property, district and zoning data. The process will
replace existing oracle spatial methods used by CSR, Cagis
online and permits plus and will be the basis for AA data.
Cagis Consortium In Progress -
92%
In Progress -
92%
4Q - 2016
Cincinnati DOTE - Migrate poles/traffic signs inventory from
CagisAim to ArcMap Desktop
DOTE has indicated that it would be much more productive in
the ArcMap environment than using the CagisAim application,
which was designed to be disconnected mobile application.
Cincinnati DOTE In Progress -
30%
In Progress -
30%
4Q - 2016
City Buildings - Proof of Production for Combo Permits
As part of Accela Automation, implement City Buildings Combo
Permits workflow
City Buildings - Workflow In Progress -
98%
In Progress -
98%
4Q - 2016
5
CAGIS Current Work – Update on recently completed, in progress and planned tasks.
Work Description Program Area Current
Status
Previous
Status
Estimated
Finish
GEN8 Migration Phase I
Develop a complete GIS solution for existing GEN7 users to
migrate to the current ArcGIS world. Phase 1 provides a
customized ArcMap desktop environment with point-and-click,
easy-to-use tools for GIS layer access, feature locating, feature
labeling, enhanced geocoding, cartographic mapping
production and metadata viewing functions. Beginning by
organizing GIS data into libraries of file geodatabases to easy
distribution and update, followed by enhancing the existing
CAGIS ArcMap desktop add-in tools, adding additional
functions/tools for accessing file geo-database layers,
eactivities (permitting) visualization, property report and owner
notification.
Cagis Consortium In Progress -
95%
In Progress -
95%
4Q - 2016
Cincinnati Economic Development Momentum Mapping
Create and support web map application that tracks City of
Cincinnati economic activities(phase 1 downtown)
Cincinnati Economic Development In Progress -
65%
In Progress -
60%
4Q - 2016
MSD - Sewer Availability
Update the MSD permits plus workflow. Remove the
dependency on GEN7. Create reports.
MSD In Planning 4Q - 2016
Momentum Map Phase I
Web map tracking economic development opportunities,
activities in downtown Cincinnati.
Cincinnati Economic Development In Progress -
50%
4Q - 2016
Woodlawn CSR
Create CSR website for the City of Woodlawn
City of Woodlawn Complete -
100%
In Progress -
90%
3Q - 2016
CSR - County Planning & Development - Fire Hydrant Repairs
Phase II
Implementing improved hydrant selection process with
inclusion of assetid so request can always be tied back to
correct hydrant
County Planning & Development - CSR In Progress -
80%
4Q - 2016
6
CAGIS Current Work – Update on recently completed, in progress and planned tasks.
Work Description Program Area Current
Status
Previous
Status
Estimated
Finish
DOTE/ Law Department Revocable Street Privilege
Create enterprise solution for a comprehensive list of locations,
agreements and administrative departments for the Revocable
Street Privilege database.
Cincinnati DOTE in Progress -
90%
in Progress -
75%
4Q - 2016
Norwood Code Enforcement
Add a workflow for Norwood to track Code Enforcment Cases
in Permits Plus
Norwood In Progress -
60%
In Progress -
30%
4Q 2016
DOTE CAP Web Mapping
Development of a web site that will allow the public to follow
the DOTE CAP program
Cincinnati DOTE In Progress -
75%
In Progress -
50%
4Q - 2016
GEN 8 Migration Phase II
Continued migration to GEN8 focusing on integration with
workflow/permitting applications.
CAGIS Consortium In Progress -
20%
In Progress -
10%
4Q - 2016
DPS Citations
Enhancing the DPS citations program to display citation data in
CDPSCODE (City DPS weed/litter records)
Cincinnati City Buildings In Progress -
90%
In Progress -
90%
4Q - 2016
Cagis Core Services Enhancements
Reviewing the Cagis Core services and moving applications off
older versions so all are pointing to the newest version of Core
services. Cataloging applications that point to the core web
services.
Cagis Consortium In Progress -
15%
In Progress -
10%
4Q - 2016
CAGIS Web Services QA/QC
Creating a program to review all CAGIS web services. Program
will test functions in each web services and email results to
managers on a daily basis.
Cagis Consortium In Progress -
20%
In Progress -
10%
4Q - 2016
CAGIS Project Inventory
Cataloging all the CAGIS applications, including SVN locations,
install locations, primary developer and user groups
CAGIS Consortium In Progress -
50%
In Progress -
25%
4Q - 2016
7
CAGIS Current Work – Update on recently completed, in progress and planned tasks.
Work Description Program Area Current
Status
Previous
Status
Estimated
Finish
Fix it Cincy! Enhancements
Upgrading Fix it Cincy! to work within the new Appcelerator
studio. On the UI, mapping end, making enhancements to the
submittal workflow and user CSR local storage and looking into
improvements to the GPS functionality.
Cincinnati City Managers Office In Progress -
25%
In Progress -
5%
4Q - 2016
County Wide Construction Coordination UI/Spatial
Enhancements
Moving CWCC off the TIBCO framework and oracle spatial
database functions to use dojo and esri js api's and Arcgis
server spatial functions.
Cagis Consortium In Progress -
10%
In Progress -
5%
1Q - 2017
County Wide Construction Coordination - CIP review, update
With the assistance of the City Manager, we are making a
renewed push to update utility CIP data in CWCC and retrain
the utilities project managers, particularly in the use of
Coordination Groups within CWCC
Cagis Consortium In Progress -
25%
In Progress -
10%
1Q - 2017
CSR Desktop enhancements
Enhancing the CSR desktop program to move off the remoting
services and use the RIP web services and also upgrade to use
visual studio 2013
Cagis Consortium In Progress -
40%
In Progress -
20%
4Q - 2016
County Planning & Development - CagisFIMUI
Testing and making enhancements to CagisFIMUI - Tablet
version so the County Building dept can start using it and move
off the older CagisFIM-NG platform.
County Planning & Development In Progress -
90%
In Progress -
60%
4Q - 2016
Sycamore Township Batch Document Import Process
Working with Sycamore Township to batch import several
thousand documents.
Sycamore Township Complete -
100%
In Progress -
95%
3Q - 2016
2017 Cyclical GIS Data Update
Update of orthophotography, contours and planimetric layers.
Develop RFP with TAC subcommittee.
CAGIS Consortium In Progress -
75%
4Q - 2016
8
CAGIS Current Work – Update on recently completed, in progress and planned tasks.
Work Description Program Area Current
Status
Previous
Status
Estimated
Finish
City DTE Document Archives into DocsOpen Imaging System
City DTE would like to scan and archive drawings into the CAGIS
DocsOpen Imaging System
City DOTE - Document Management Complete -
100%
In Progress -
85%
3Q - 2016
Port Authority - Land Bank
The Hamilton County Land Reutilization Corporation has
identified criteria used for determining property acquisition for
the land bank. The Corporation will use ArcGIS to analyze
various data sets for property, crime, water shut-offs,
complaints, etc. The Consortium will assist in integrating these
datasets with the Departmental owners.
Port Authority - GIS, Reporting In Progress -
95%
In Progress -
95%
4Q - 2016
County Buildings - Combo Permit Workflow Analysis
As part of the Accela Automation design, CAGIS and City
Building Staff documented the entire Building Permit Process
County Buildings - Workflow In Progress -
96% - Waiting
for signoff
In Progress -
96% - Waiting
for signoff
4Q -2016
Cincinnati Community Development - Vacant Foreclosed
Property Registration Phase II
Website where citizens on patrol or other citizen could log in
and access a list of foreclosed properties in their neighborhood
to monitor. If they find problems, create a way to enter a CSR
to notify code enforcement. Ideally, this would be an AP that
would work with the GPS system you were testing.
Community Development - Workflow On Hold On Hold TBD
Hamilton County Engineers - Parcel Migration Phase II:
The second phase of the parcel migration has a number of
parcel data and application integration tasks, including assist
HCE in tax map production, parcel data extraction, sharing and
publishing to be consumed by GEN7, Permit+, CAGIS Online and
other web applications
Hamilton County Engineers - GIS Maintenance
Ongoing
Maintenance
Ongoing
On going
9
CAGIS Current Work – Update on recently completed, in progress and planned tasks.
Work Description Program Area Current
Status
Previous
Status
Estimated
Finish
Cincinnati Health – Environmental Licensing:
Workflows for Food Service Operations, Retail Food
Establishments, Temporary Food Service, Vending (Food),
Marinas, Manufactured Home Parks, Household Sewage
Systems, Tattoo Parlors, Swimming Pools.
Cincinnati Health – Workflow, FIM Complete -
100%
In Progress -
90%
3Q - 2016
Cincinnati Planning and Buildings – Building Board of Appeals
Process:
Develop workflow to track in Permits Plus. Develop ez-Trak
online module to enable public to apply for these requests over
the internet.
Cincinnati Planning & Buildings -
Workflow, ez-Trak online, GIS
On Hold On Hold TBD
Consortium – Legacy Systems Support:
Nightly/weekly data extraction routines to create shape files
and attribute tables to support current applications across all
supported departments. This is an on-going activity that is likely
to continue into the coming years until the migration project is
completed and include both automated and manual methods.
Some examples of the routines are: • Nightly street centerline
geo-database to shape file extraction • Nightly addresses
extraction • Nightly permit activities (e-activity) extraction •
Weekly parcel boundary and Auditor data update • Weekly
planimetric data layers (pavement, buildings etc) extraction •
Weekly zoning data update for Cincinnati and Hamilton County
• Weekly boundary attribute updates for Permit Plus databases
Consortium Ongoing Ongoing Ongoing
10
CAGIS Current Work – Update on recently completed, in progress and planned tasks.
Work Description Program Area Current
Status
Previous
Status
Estimated
Finish
Consortium – CAGIS Online:
CAGIS Online is a web GIS application developed as a Rich
Internet Application (RIA) environment utilizing ArcGIS Server
and related spatial technologies. The phase I of CAGIS Online is
complete and is available for both public and internal use.
This task is also being utilized to evaluate various technologies
effective delivery of GIS services to users and applications with
varied needs.
Key GIS capabilities include expanded list of GIS layers,
integration to workflows and access of document images,
Parcel Notification Tool, Geocode Tool, DXF/Shape File,
Embeddable Maps, Property Report & Printing, Shape File
Overlay – enables users to load local shape files to overlay with
CAGIS Online base maps.
Consortium Ongoing Ongoing Ongoing
City Buildings – ProjectDox Plan Review Process
Redesign of plan review process for Building permit process to
utilize features of ProjectDox.
City Buildings - ProjectDox In Progress -
98%
In Progress -
98%
4Q - 2016
Cincinnati Planning and Buildings – Planning workflows:
CAGIS will be working with the planning division to identify
study and automate all their work process. The will also provide
the framework for developing performance indicators for
management dashboards and reports as requested by the
Department Director.
Cincinnati Planning & Buildings -
Workflow, ez-Trak online, GIS
In Progress -
95%
In Progress -
90%
4Q - 2016
County Planning and Development – Property Investigations:
Enhancement requests and retraining for Building Dept’s
Property Investigation workflow
County Planning & Development-
Workflow
TBD TBD TBD
11