160 likes | 174 Views
Explore innovative data management and planning strategies for TMDL compliance, including geodatabase development, spatial modeling, site selection, and progress tracking towards goals. Learn about TMDL application portfolio and tools for effective implementation.
E N D
Innovative Data Management and Planning Strategies for TMDL Compliance Jeffrey Tirschman, KCI Technologies, Inc. Michele Aitkenhead, McCormick Taylor, Inc. March 18, 2014
Discussion Topics • TMDL In A Nutshell • Requirements and Milestones • Program Management Challenges • Managing TMDL Data • Do Your Homework • Geodatabase Development • Innovative Planning & Modeling • Spatial Data Models • Streamlining Site Selection • Managing Progress towards Goals • TMDL Application Portfolio
What is a TMDL? Total Maximum Daily Load …the maximum level of a pollutant that can be discharged to a waterbody without causing it to exceed water quality standards
TMDL In A Nutshell Baseline (Current Condition) Reduce Loads - Restoration Strategies TMDL
TMDL In A Nutshell • Clean Water Act, Section 303(d) • “Pollution Diet” • Bay TMDL - EPA’s Largest TMDL • 6 States and DC • Pollution Limits (Nitrogen, Phosphorus, Sediment) • Watershed Implementation Plans (WIP)
Requirements and Milestones • 60% Implementation by 2017 • Full Implementation by 2025 • 20% Restoration of Pre-2002 Impervious Surface • 2-Year Milestones • Local TMDLs
Program Management Challenges • Aggressive requirements • Technical requirements can be difficult to comprehend – multiple sources • Non-standard data – various data owners • Resource challenges • Financial challenges
Data Management • Data Inventory & Analysis • Consolidate Source Data (Multiple Formats) • MS Excel spreadsheets • MS Access databases • Shapefiles • Geodatabases • Work Order Management Systems • Lists • Analyze all Data Sources for Content, Currency, Completeness and Ownership
TMDL Database Modeling • Consider an Enterprise Spatial Database • Evaluate Program Needs & Permit Requirements • TMDL BMP Types • Load Reduction (Stream Restoration, Inlet Cleaning) • Efficiency (SWM Ponds & Facilities, Outfalls) • Landuse Change (Planting Trees, Remove Pavement) Change Land Use Reduce Loading Factor Removal Efficiency
Data Migration • Data Consolidation & Migration • Evaluate Key Data Sources • Develop Data Migration Plan • Prepare Source-to-Target Mappings • Data Processing • Quality Control Plans
TMDL Geoprocessing Tools • Streamline Selection of Sites • Develop Layers of Suitable Project Locations in Consideration of: • Restoration Opportunities • Local TMDLs • Efficiency • Land Ownership • Develop Scripts to Analyze and Geoprocess the Data to Support Prioritization of Sites & Projects • Track Sites to Assets & Project Development
Innovative Planning & Modeling Spatial Data Models: • Geographic Priorities • Site Programming Models • Strategy Specific • Watershed Based Managing Progress Toward Goals: • Develop standard reporting/tracking forms • Business Plan • MDE Reporting • Annual Reporting • Develop a modeling framework for tracking nutrient and sediment reductions • More control over which efficiencies are used • Account for specific design elements • Accurate tracking
Innovative Planning and Modeling Implementation Site Selection TMDL Geodatabase
Application Portfolio for TMDL • Innovative TMDL Applications • Data Management • GIS-Centric Data Maintenance Tools • Office Tools (Intranet, Internet) • Field Tools (mobile) • Planning & Selection Model Python Tools • Leveraging Database Framework • Reporting Tools • Public Transparency, Outreach • Data Sharing • Report Generation
Thank You! Jeff Tirschman KCI Technologies, Inc. 410.316.7944 jeff.tirschman@kci.com Michele Aitkenhead McCormick Taylor, Inc. 410.662.7400 mlaitkenhead@mccormicktaylor.com