1 Region VI Pretreatment Workshop 

### Martin Miller Industrial Compliance Supervisor 

# Management of your Data

August 11, 2014

August 11, 2014

Managing your Data Page 2 

# Data

• Compliance with a permit

– POTW (TPDES) / Recycle

– Pretreatment (local limits)

– Potable

– Storm Water (TMDL)


## • Enforcement

– Against others or in your own defense


## • Operational Controls

Collecting with purpose2 August 11, 2014

Managing your Data Page 3 

# Data Management

• 98 SIU’s (Categorical, High Volume, Misc .) and adding more everyday...
• 5000 + NSIU’s (Restaurants, Carwashes, Clinics, Laundries)
• 1200 Storm Water Industrial Permits
• Potable water samples (distribution, pump stations, storage tanks)
• Recycled water samples
• Monitoring Stations – Water Quality
• Complaints & Investigations
• SW Construction site inspections
• Water Pollution Abatement Plans
• Storm Water Quality Basins
• TMDL / Bacteria Diversity in data and who is using it

August 11, 2014

Managing your Data Page 4 

### Who is using the data and why ?3 August 11, 2014

Managing your Data Page 5 

# Changes since 1986 More stuff and less people...

• Increase in quantity and types of facilities
• Permit reporting requirements
– NPDES / TPDES Programs
• Provides valuable data for various studies, surcharge calculations, plant loadings

August 11, 2014

Managing your Data Page 6 

# Access Database Do I need a Data Coordinator?4 August 11, 2014

Managing your Data Page 7 

# Connecting data tables... Relationships between the data tables

August 11, 2014

Managing your Data Page 8 

# Report Generation How do I make it easy to report data to other agencies...5 August 11, 2014

Managing your Data Page 9 

# Data Entry – Daily activities... Get staff to enter consistent data for reporting. (Use drop down boxes)

August 11, 2014

Managing your Data Page 10 

# Benchmark goals & Industry tracking... Make the data auto update as many Reports & KPI’s as possible.6 August 11, 2014

Managing your Data Page 11 

# Pretreatment Performance Summary

• Reporting Period From: 01
- 01
- 06 To 12
- 31
- 06
• Total Number of Categorical IUs: 12
• Total Number of Significant Noncategorical IUs : 38
• *
• *Zero Discharge Categorical Industrial Users are considered Non - Categorical Significant Industrial Users rather than Categorical Industrial Users.
• II. Significant Industrial User Compliance
• SIGNIFICANT INDUSTRIAL USERS
• Categorical Noncategorical
• 1 ) No . of SIUs Submitting BMRs/Total
• No. Required ...................................................... 2 / 2 N/A
• 2 ) No . of SIUs Submitting 90
- Day Compliance
• Reports/No. Required .......................................... 1 / 1 N/A
• 3 ) No . of SIUs Submitting Semiannual Reports/
• Total No. Required ............................................. 11 / 13 3 / 3
• 4 ) No . of SIUs in SNC with Compliance Schedule/
• Total No. Required .............................................. 0 / 0 1 /1
• 5) No . of SIUs in Significant Noncompliance/
• Total No. of SIUs ................................................. 1 / 12 2 / 38
• 6 ) Rate of Significant Noncompliance for all
• SIUs (categorical and noncategorical ).................... 3 / 50 0 / 0
• XX Non - categorical Significant Industrial Users submitted Semi
- Annual Zero Discharge Certifications.
• XX Non - categorical Significant Industrial Users had their Semiannual conducted by the POTW. Annual Report

August 11, 2014

Managing your Data Page 12 

## Data collection...

• Currently using laptops with touch screen
• Speed of equipment
• Lack of wireless connection


## • Information Services concerns – Security, support, wireless access to database
• Busted and stolen equipment Field collection7 August 11, 2014

Managing your Data Page 13 

# Classifying Industrial Users Dischargers to the collection system



### – Processes or operations

• Understanding of manufacturing process and products



### – Wastewater discharged

• Volume, character and frequency of discharge



### – Facility supplied information

– Non process wastewater

August 11, 2014

Managing your Data Page 14 

# Classifying Industrial Users

• Identify and locate Industrial Users subject to TPDES pretreatment program requirements. 40 CFR § 403.8(f)(2)(i) & WRC/POTW Permits Federal and State Requirements8 August 11, 2014

Managing your Data Page 15 

# Tools

• We have added a large scanner to the office system and can now .pdf hard copies of information.
• Allows you to take the file information to the 

## field.
• Gives the ability to review and find answers to questions.
• Look at infrastructure maps, facility mapping, etc... Use technology

August 11, 2014

Managing your Data Page 16



# Permit Fact Sheet

• Documentation
• Pictures
• Processes
• Sample points
• Rational behind decisions
• Permit limits
• Dates Create a history of facility9 August 11, 2014

Managing your Data Page 17



# SIU Pretreatment Reports

• Pollution Prevention

– Product substitution

– Less toxic materials


## • Slug Discharge Control Plans

– Spill control

– Operational practices


## • Toxic Organic Management Plan

– Practices and controls

August 11, 2014

Managing your Data Page 18 

# Involvement

• Staff that use the products need to be involved.
• Complexity – keep it simple
• Consistency – drop down boxes
• Need to be able to generate and modify reports
• Think long term Beta test it !10 August 11, 2014

Managing your Data Page 19



# Production Based C alculations

• Coil Coating – millions of SF
• Battery Production – lbs. of lead / # batteries
• Use Excel to set up equations so that you can plug in flows, SF or lbs. and avoid repetitive calculations. Categorical

August 11, 2014

Managing your Data Page 20



# Scheduling

• Inspections
• Permits


# • Sampling Outlook Calendar11 August 11, 2014

Managing your Data Page 21 

# Data Collection
• There is no fast fix ... and it will change.
• There are commercial products available...
• Still have to maintain the paper copies for TCEQ (electronic signatures)
• Technology does allow you to track information easier, do complex calculations, reduces repetitive actions, allows for tracking 

## sites, staff, and reports ...

Region VI Pretreatment Workshop 

### Martin Miller Industrial Compliance Supervisor 

# Management of your Data

August 11, 2014 

## 210.233.3557 Martin.miller@saws.org