SERUG - Sarasota County Development of an Enterprise Stormwater ...
Sarasota County Development of an Enterprise Stormwater Infrastructure Geodatabase
Introduction
Project Team Introductions David Coley – Sarasota County Project Manager Matt Terella – Jones Edmunds Project Manager David Jenkins – Jones Edmunds Project Analyst/DBA
Water Core Service Stormwater Business Practices:
Flood Protection LOS –
NFIP/CRS
Asset Management SWRRP/CIP H & H Modeling Water Quality – –
TMDLS NPDES
Prior Data Status: 2001-2006
Existing SW Infrastructure – –
No Data Model = No Data Integrity! Low Confidence
No Workflow SOP Maintenance Is Reactive Assets Must Integrate with WMS Enterprise Solution Needed
Prior Data Status: 2001-2006 Prior Drainage GIS Data:
Prior Data Value: 2001-2006 Operations & Maintenance: •Location •Low confidence Planning: •Difficult to assess accurate dollars to develop CIP/SWRRP funding Engineering: •Rough estimates only
Future Data Value: 2007Operations & Maintenance:
Planning:
•Location
•Stormwater Master Planning
•Condition
•Capital Improvement Planning/SWRRP
•Preventative Maintenance •Enterprise Asset Management •Work Order Management
Engineering: • H & H Analysis Modeling
Project Goals Evaluate Existing Drainage Infrastructure Data – Spatial Quality – Attribute Quality Establish GIS Data Standards for Drainage Infrastructure Incorporate Standards in GIS Data Storage Model Develop an Enterprise Solution
Data Evaluation Existing Data Evaluation – Spatial Quality – Attribute Quality – Field Verification – Data Geographic Completeness
Pilot Project
Data Standard Development Workshop – Held at Phillippi Creek Estate Park – Operations, Engineering, and Environmental Groups Attended – Provided Input Regarding Nomenclature and Values for Domains
Data Standard Development and Refinement Goals – Develop for an Enterprise Solution – Work with all Business Practices H&H Modeling Asset Management Water Quality/ Environmental SWRRP/CIP Flood Protection
Developed Preliminary Data Model – Used W/WW Model and the County’s Hydraulic Model Database
Data Standard Development
Pilot Project Data Pilot GIS Data Collection: Phillippi Creek
Enterprise Solution Water Core Service Vision – SW Infrastructure Database Supports All Business Practices – Database Is the Most Up-toDate Database in the County – Future Integration with Other Schema CMMS Hydraulic Modeling Database Simple (Pollutant Load Model)
Enterprise Solution Requirements to Uphold Data Integrity – Standard Operating Procedures Field/Office
GPS Collection Location
– Data Management Application and Field Forms – Workflow Analysis – Training
Enterprise Potential Problems CCMS Integration – Difficulty working with subtypes – Required revision of the data model – Solution XML Reader to map databases
CMMS
Future Work Prioritized Field Collection H & H Model Integration Pollutant Load Model Integration
Questions?
Introduction
Project Team Introductions David Coley – Sarasota County Project Manager Matt Terella – Jones Edmunds Project Manager David Jenkins – Jones Edmunds Project Analyst/DBA
Water Core Service Stormwater Business Practices:
Flood Protection LOS –
NFIP/CRS
Asset Management SWRRP/CIP H & H Modeling Water Quality – –
TMDLS NPDES
Prior Data Status: 2001-2006
Existing SW Infrastructure – –
No Data Model = No Data Integrity! Low Confidence
No Workflow SOP Maintenance Is Reactive Assets Must Integrate with WMS Enterprise Solution Needed
Prior Data Status: 2001-2006 Prior Drainage GIS Data:
Prior Data Value: 2001-2006 Operations & Maintenance: •Location •Low confidence Planning: •Difficult to assess accurate dollars to develop CIP/SWRRP funding Engineering: •Rough estimates only
Future Data Value: 2007Operations & Maintenance:
Planning:
•Location
•Stormwater Master Planning
•Condition
•Capital Improvement Planning/SWRRP
•Preventative Maintenance •Enterprise Asset Management •Work Order Management
Engineering: • H & H Analysis Modeling
Project Goals Evaluate Existing Drainage Infrastructure Data – Spatial Quality – Attribute Quality Establish GIS Data Standards for Drainage Infrastructure Incorporate Standards in GIS Data Storage Model Develop an Enterprise Solution
Data Evaluation Existing Data Evaluation – Spatial Quality – Attribute Quality – Field Verification – Data Geographic Completeness
Pilot Project
Data Standard Development Workshop – Held at Phillippi Creek Estate Park – Operations, Engineering, and Environmental Groups Attended – Provided Input Regarding Nomenclature and Values for Domains
Data Standard Development and Refinement Goals – Develop for an Enterprise Solution – Work with all Business Practices H&H Modeling Asset Management Water Quality/ Environmental SWRRP/CIP Flood Protection
Developed Preliminary Data Model – Used W/WW Model and the County’s Hydraulic Model Database
Data Standard Development
Pilot Project Data Pilot GIS Data Collection: Phillippi Creek
Enterprise Solution Water Core Service Vision – SW Infrastructure Database Supports All Business Practices – Database Is the Most Up-toDate Database in the County – Future Integration with Other Schema CMMS Hydraulic Modeling Database Simple (Pollutant Load Model)
Enterprise Solution Requirements to Uphold Data Integrity – Standard Operating Procedures Field/Office
GPS Collection Location
– Data Management Application and Field Forms – Workflow Analysis – Training
Enterprise Potential Problems CCMS Integration – Difficulty working with subtypes – Required revision of the data model – Solution XML Reader to map databases
CMMS
Future Work Prioritized Field Collection H & H Model Integration Pollutant Load Model Integration
Questions?
