160 likes | 179 Views
Learn about TMDL requirements, geodatabase development, innovative planning & modeling, and managing progress towards goals for Total Maximum Daily Load compliance. Discussion topics include data management challenges and applying geoprocessing tools.
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