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 purpose
2

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?

Resource Compliance Division

Administrative Assistant Senior Resource Analyst

Clerk

Storm Water

Quality Specialist (6)

Supervisor

Construction Compliance

Industrial Compliance

Specialist (10)

Supervisor

Industry Compliance

Environmental Compliance

Specialist (17)

Senior

Environmental Compliance

Specialist (4)

Supervisor

Sampling and Monitoring

Manager
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.

Joe by type of Inspection 2006

2 2

1

2 2 2 2

0

3

1

7

4

0 0

0

0

1

0

0

20

19

19 4

11

6

16

7 3

12

2

4

1

0

0

0

0

0

0

0

5

10

15

20

25

30

35

Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Goals

SW TR

SW SV

SW Insp PT TR

PT SV

PT Insp

Industrial Compliance Jan to June 2006

55%

8%

2%

2%

1%

15%

14%

3%

COM

CAR

CAR2 ADV NOV

SVCLOSED

NPR

2006 Pretreatment SIU Inspections

7

18

16

11

22

20

18

23

12

10

27

12

5

1 1

0 0

0

5

10

15

20

25

30

Jan PT Feb PT March PT April PT May PT June PT Monthly PT Goal

Inspection Site Visit Training

Jeff inspections 2006

3

6

5

7

5

1

0 0 0 0 0 0

2

9

13

15

4

15

19

0 0 0 0 0 0

16

0

2

4

6

8

10

12

14

16

18

20

Jan-06 Feb-06 Mar-06 Apr-06 May-06 Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Goals

PTSW
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 collection
7

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 Requirements
8

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 facility
9

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 Calculations

• 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 Calendar
11

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