HomeMy WebLinkAbout05.b. Optimization of Data Transfer Between Environmental Compliance and Permit CounterMENTORSHIP PROJECT PRESENTATION:
OPTIMIZATION OF DATA TRANSFER
BETWEEN ENVIRONMENTAL
COMPLIANCE AND PERMIT COUNTER
Ian Morales, GIS Analyst
Rita Cheng. Associate Engineer
November 7, 2016
PRESENTATION OUTLINE
• Introduction
• Purpose
• Current Challenges
• Approach
11111 • Preliminary Technology Evaluation
• Recommendations
• Acknowledgements
Questions
5.b.
1
INTRODUCTION
• Mentee/Mentor Teams:
lan Morales, GIS Analyst
John Huie, Information Technology Manager
Rita Cheng, Associate Engineer
Jean -Marc Petit, Director of Engineering and
Technical Services
PURPOSE
• Understand and improve the data transfer
between Environmental Compliance and
Permit Counter
• Preliminary technology evaluation
• FY2016-18 Strategic Plan
Goal Six, Strategy 2 — Evaluate Business
Processes and Optimize Business Operations
11/1/2016
CURRENT CHALLENGES
• Access to mobile technology in the field
• Security, multi-user access, and
robustness
• Lack of efficient data transfer between
Environmental Compliance (EC) and
Permit Counter (PC)
Limited enterprise software options that
can accommodate both EC's pretreatment
sand stormwater programs
APPROACH
• Meetings with EC and PC
Engaged stakeholders
Helped initiate the coordination meetings between the
divisions
• Meeting with EC
Obtained an understanding of the current EC
Inspection Program workflow
Identified business optimization opportunities
• Meetings with Mentors
• Ensure proper development of the project
Technology Evaluation
• Evaluated enterprise software options
11/1/2016
3
CURRENT EC ACCESS DATABASE
• Highly -customized Access database that
fulfills their current business needs
� Microsoft
■
• Limitations include:
• Lack of multi-user access
A
• Limited compatibility with mobile devices
• No security and permissions
Unreliable back-up capability
Access
Z71)
CURRENT IMPROVEMENTS FOR
MANAGING EC DATA
• Implemented a form field in the current
Access database to categorize businesses
that need PC's follow-up
• SQL Conversion
• Completed by EC and GIS Group
• Optimized security, reliability, multi-user
access, and integration with enterprise
systems (ex: GeoPortal and Cityworks)
r ^r
II
11/1/2016
FUTURE CONSIDERATIONS FOR
MANAGING EC DATA
• Benefits of an enterprise software:
, Enhance approach to reliably manage and
integrate EC data
11111Improve data transfer with other groups
1140411/4
• Preliminary evaluation of enterprise
software
Software
Description
Pros
Cons
Future
Consideration
Miesr-7111T=Tlitywor— ! g F
GIS -centric mobile Comprehensive Comprehensive Environmental Common
apps asset management environmental compliance environmental
system used by CSO compliance software used by compliance
and POD management City of San Jose software used for
Maintenance software and Union San other pretreatment
programs
- Integrate to
District's GIS
- User friendly
- in-house support
- No additional cost
- Customizable with
in-house support
- GS compatible
- Mobile ready
- Workload
management
- Supports
stormwater and
pretreatment
- Storrnwater and - Highly - Well-established
pretreatment customizable pretreatment
modules - Pretreatment management
- Management of and stormwater option
inspections, features
permits, and
workflow
- GIS compatible
- Lack of permit - Different permits - Perpetual - Expensive to - Not appropriate
management management agreement implement and for stormwater
- Does not support structure - Back -end maintain inspections
inspection format maintenance only - Data entry is not - Back -end
provided by as user friendly maintenance
NJBSoft - Back -end only performed
maintenance by Linko
only provided by - Expensive to
enfoTech implement and
maintain
X
x❑
11/1/2016
5
11/1/2016
RECOMMENDATIONS
• Current Solutions
Ensure compatibility of EC database
with mobile devices
Completed Access to SQL conversion
• Future Consideration
Further evaluate the application of
Cityworks to address EC's
pretreatment and stormwater
inspection programs, workflow
management, and permits
-,7
Microsoft.
SQL Server
Cityworks
PROJECT ACCOMPLISHMENTS
• Optimized communications and data
transfer between EC and PC
Implemented a form field to categorize
businesses that need PC's attention
• Identified solution to address current
11410104cs4
business needs
, SQL conversion completed
• Identified an enterprise software for future
onsideration
ACKNOWLEDGEMENTS
• Permit Counter
• Environmental Compliance
• Division Managers
• Executive Team, Teji O'Malley, and Larry
Bienati
Mentors — John Huie and Jean -Marc Petit
QUESTIONS?
11/1/2016