08 Using the Water Quality Investigations Database

Using the Water Quality
Investigations Database
June 2015
Jon Baker
Sean Doig

To Get Started:
Find and double-click the shortcut on your desktop.
This downloads a copy of the Microsoft Access front-end
to your computer and opens it.
This front-end is connected to the data on the SQL
server. Any changes you make to the underlying data
are permanent.
However, any changes you make to the front-end (such
as queries you build or tweaks to the interface) will be
deleted the next time you open the database.
The WQDB Shortcut is located on the server here: F:\GIS\Files\PKG\WQlnvestigationsDB

MS Access Data Entry Basics
• Use the Tab key to move from one field to another on any form
• Tabbing to a new field in the Investigations Overview and Field Investigation
pages automatically saves the data in the prior field
• On the pop-up data entry forms data is not saved until you hit "Save"
• Any error messages you receive should be immediately reported to Sean Doig
([e-mail]) and Jon Baker ([e-mail])
• When you add data, the date, time, and username are recorded in the
database

Navigating the Database

The header explained
The switchboard
and data entry tabs
open automatically
with the
Investigation Datz
Entry shown first.
When the databas
opens the majority
of the form will be
hidden.
Select or type a CRFile
# from the combo box
Or select Add New
to add a new
to view an existing investigation to the
rin 1 ln k n co

More of the header explained
The Main Switchboard includes
the Search function, Complaint
Log and Reports. These functions
will be covered later in this
presentation.
Main Switchboard Overview Map WQInvestigations V6_a
I gp53 Select an Investigation Add New
[R = le I
1.5WQ241 JFP15WQ2Q1� I Print
Investigation averviewl Field Investigation I Task Details
The Previous, Next, First, and Last
buttons are another method to
navigate through the
Previous First
Spell Check Next Last
Water ChAnistry
Use spell check to
check the spelling
on the Overview
WITS FM-1I
Investigations tabs.
The Complaint Log can
be viewed by clicking the
View Complaint Log
button on the Main
investigations. Switchboard
the header.
Set Investigation Folder
Investigation Folder
z —
Contacts VioIa�ons E oreement I map
If the Investigation
Folder text is blue,
the path to the
folder is set. If you
click on it Windows
Explorer will open
and attempt to
navigate to the
correct folder.
Use the Set
or here on
View Camplaint Log
Investigation Folder
to update or set the
path.

Reviewing an existing investigation
Select a CR File #
Select an Investigation
20WQ400
15WQ098
15WQ097
15WQ096
15WQ095
15WQ094
15WQ093
15WQ092
5 ■
15WQ090
15WQ089
15WQ088
15WQ087
15WQ086
15WQ085
15WQ084
And the related data will appear in the form
Min Switchboard wQ Investigations V6_1
3936 Select an InvestigationVdd New Previous First Set Investigation Folder
15WQ091 15WQ091 Print Spell Check Next Last Investigation Folder
nvestigation Overview �L Field Investigation I Task Details I Water Chemistry I Contacts
Investigation Type Standard
Complainant's Description of Problem and Location
Private sewage leak from residence
Complaint From
First Name
Clarence Harris
Last Name
Company
Street Address
City NIS
Address Line 2
City
Durham
State
NC
Zip
Primary Phone
[phone].34269
Secondary Phone
Email
Clarence-HarristDclurhamne-gov
Role
(Complainant
Investigation Closed
Violations I Enforcement I Map
Initial Investigation
Date I5/20/2015
Field StartTime 13:45
Field Start Time: enter the time you arrive at the
complaint focation to start the field investigation.
Duration 20 minutes
Duration: enter the totaf time spent an the initial
investigation (includes office work, prep work, travel
time, and field investigation).
Lead Investigator Jim Azarelo
t Add Staff
Delete Staff
Investigation Progress
Date Results Communicated to Complainant:
Source Identified Date: 5f20f2015
Responsible Party Determined Date: 5/20f2075
Source Controlled Date:
5- Controlled Oate: enter the date when you observe that the
responsibl e party has controlled or eliminated the pollutant ar
problem.
Investigation Forwarded To
Name Agency
Add Contact
Complaint Date and Source Data Entry Tracking
Date 5/20/2015 Time 9:00 Created by lamesN Created on 6/1/2015 2:41:41 PM
Source Other city employee Edited by lamesAz Edited on 6/1/2015 2:48:55 PM
If Dther,Please NIS Supervisor emailing Water Quality
describe:
G

The data entry tabs explained
The Field Investigation tab
includes the investigator's
general findings, more
specifics about the
Main Switch[ location, and any
I❑ probable pollution
CRFile 1 sources. 1-
nvestigatiun Overview Field Investigation
T
The Investigation Overview
tab includes information
about the complaint, when
the investigation was started,
and the status of the
investigation.
The Contacts tab lists
anyone associated with
the investigation and their
role. If a person is listed
as a Responsible Party
their name can be
accessed on the
Je1N Enforcement tab
Task Details Water Chemistry Contacts Violations
T
The Water Chemistry tab
includes sample site
location and results from
any assessed parameters.
The Task Details tab
lists, times, dates,
findings and actions on
every task from the
Initial Investigation
through any follow-ups.
The Map tab displays all
the investigations that
have a valid latitude and
longitude, allows you to
determine the lat/long,
watershed, and nearest
stream for the current
investigation
Enforcement Map
The Violations tab lists
any violations that
stem from the
investigation and
required corrective
actions. Penalty
amounts are calculated
on the violations tab.
The Enforcement tab lists
enforcement actions,
including NORs, NOVs, and
NOPs. Violations are
associated with specific
actions and letters can be
printed from this page.

Tab design for Task Details, Water Chemistry, Violations, and Enforcement
All of these tabs have the same basic design
3930 Select an Investigation
15WQ079 ISWQ079 J
i
Add New Previous First set investigation Folder
Print Spell Check Next Last Aestigation Folder
I nvestigaticn� Field I nvestigation Task Details ` Water Chemistry I Contacts
Violations Enforcement Map
There is a
TasklD 7403 Investigationl❑ 3930
selectable
Task 4 Description Fallow -up Investigation Date 5/11/2015 Time 14:38 Duration (in minutes) 60
Task
Task Investigator Claire Tipton Always enter the total amount of time spent
liSt b oX
1
Initial investigation
on each task (office work, prep work, travel
Details and Findings Edit or Delete Task time, field investigation, meeting, etc.)
2
Follow-up Investigation
3
Follow-up Investigation
CT conducted a follow up onsite and noted the SSO had been stopped. Area still had some mud -mixed solids, but in general most solids had been scooped up and
lime powder applied. CT called and spoke to Mr. Jones, who informed CT that he had been in touch with Junior Mobley with Water & Sewer Mgmt. on Friday
15/8/15) and that they had actually determined that the SSO was caused from the City side (the City would reimburse him for his expenses). CT called Mr. Mobley
and was able to speak with him on 5/13/15 about the situation. Mr. Mobley stated that on Friday they had discovered that the line was actually city maintained
and that the City was responsible for the 550. However more recently Water & Sewer Mgmt. Had discovered some contradicting building plans for the property
and ultimately it was still up in the air as to who was responsible. Regardless, on Friday (5/8/15) the City had jetted the lines and Mr. Mobley said they would send
out a crew to finish cleaning up the solids/mud along the path of the SSO, no problem. At this time, CT will not issue a notice due to ambiguous nature of who is
Add New Task
And a subform.
When you select an item
from the listbox, the details
are displayed in the subform.
Actions
Mobley stated he would keep CT in the loop at to who was the ultimate responsible party. No further action necessary. Investigation resolved.
Date Created 5/29/2015 1:52:48 PM Date Revised 5/29/2015 2:D0:13 PM
Created By Irlaireti Edited By claireti
Jill
KI— 1 —6 F�

Editing and Adding Data

Adding a new investigation Click the Add New button on the header. Add New
Click the Add New Investigation button
at the bottom of the the Complaint Log
window.
A new CR File # will appear. Fill in ALL
blank fields with appropriate information
pertaining to the investigation and click
the Save button.
Add CR #:
Request Date:
Investigation Date:
Lead Investigator:
Add Investigation
Click on an investigation to view the full record.
CRFile
Date
Caller Description
15WQ209
12/14/2O15
City SSO near 1606 University Drive
15WQ208
12/912O15
High turbidity in stream
15WQ207
12f 3f 2015
Leaves blown into drainage ditch
15WQ206
12111/2O15
Passible SSO across from 538 Green St.
15WQ205
12f 10f 2015
Leaves in the street at 207 Edward Street
15WQ2O4
121101201.5
Leaves in street and car leaking oil in street at 1109
Stonehedge Ave.
15WQ203
12f 9f 2015
Sewage leak from broken sewer pump at8O9 Lee St.
Add New
Investigation
Complainant's
Description of Problem
and Location
Save
Cancel

Viewing the new investigation
This creates a new investigation. The
Select an Investigation box should
now display the CR File #you just
added. Confirm that it does and then
begin data entry.
3945 Select an Investigation Add New
2 WWQ99 221WQ999 - Print
nvestigation Overview Field Investigation task Details Wate
Investigation Type
Complainant's Description of Problem and Location

Investigation Overview Tab
Be sure to complete those
fields bound by
47 Main Switchboard 1711 WQ Investigrtions V61
Select an Investigation Add New Previous First Set Investigation Folder
15WQ291 EPrint Spell Check Next Last Investigation Folder
Investigation Type Standard
Complainant's Description of Problem and Location
Private sewage leak from residence
Complaint From
First Name
Clarence Harris
Last Name
Company
Street Address
City NIS
Address Line 2
City
Durham
State
NC
Zip
Primary Phone
[phone].34269
Secondary Phone
Email
Clarence-HarristDclurhamne-gov
Role
Complainant
Complaint Date and Source
Date 5/20/2015 Time 9:00
Source Other city employee
If Other,please NIS Supervisor emailing Water Quality
describe:
Chemistry I Contacts I Violations I Enforcement
nvestigation Closed
Initial Investigation
Date 5/20/2015
Field StartTime F 13:45
Field Start Time: enter the time you arrive at the
mm plaint focation to start the field investigation.
Duration 20 minutes
Duration: enter the total time spent an the initial
investigation (includes office work, prep work, trove
time, and field investigation).
Map
Investigation Progress
Date Results Communicated to Complainant:
Source Identified Date: 5f20f2015
Responsible Party Determined Date: 5/20f2075
Source Controlled Date:
5- Controlled Date: enter the date when you observe that the
responsibl e party has controlled or eliminated the pollutant ar
problem.
Lead Investigator Jim Azarelo Investigation Forwarded To
Add
Name Agency Staff f
Delete S
Add Contact
T
The Add Staff and Add
Contact buttons open
Data Entry Track0 data entr forms and are
Created by lamesAz Creab Y
Edited by lamesAz Editec discussed on the next
slide.
G

Forwarding investigation/Add contact button
The Add Staff button allows you to add additional
investigators to an investigation. This window only displays
Jim
Azarelo
current staff. You may select more than one staff member to
Jonathan
Baker
be added. Simply click on any staff member you want to add
John
Cox
Travis
Marion
and then hit the Add Contact(s) button. Selected staff will
James
Pflaum
appear in the listbox on the Investigation Overview tab.
Maverick
Raber
Derek
Routhier
Claire
Tipton
Paul
Wiebke
—
Michelle
Woolfolk
J o u
Add Contact(s) Cancel
The Add Contact button opens the Add Contacts data
entry form. If you indicate in that form that the person's
relationship to the investigation is "Agency Referral" their
name will appear in the list box on the Investigation
Overview tab once you have saved that contact. It will
also appear on the Contacts tab.
I nvestigation I D
Title
First Name
Last Name
Full Name
Company
Job Title
Street Address
Address Line 2
City
State
Zip
Primary Phone Number
Secondary Phone Number
Email
Website
Relationship to investigation
Responsible Party?
Notes
2
Durham
NC
Spell Check Save Contact j Delete Contact Cancel

Field Investigation Tab
All data on the Field Investigation tab is editable from this form except you must use
the Add Probable Source button to add new sources. Be sure to complete those fields
bound by green.
3929 Select an Investigation Add New Previous First Set Investigation Folder
15WQ685 ssril/Qa�$ Print Spell Check Next Last Investigation Folder
nvestigation Overview Field Investigation Task Details Water ChemistryContacts Violations Enforcement Map
71 Field Investigations Probable Source(s) of Water Quality Problem Add Probable Sources
Investigator's No grass clippings in street during investigation, no WO, problem
Description found
Street Address 2103 Great Bend Or
example. 112 W Main St (NO periods. Prefix and su& are both abbreviated.)
Property Use Residential
Latitude N 36.0192g Between 35.5 and 36.5 Decimal Degrees
Longitude W-78.g4779Between -78.6and -79.1Decimal Degrees
Surface Water and Storm Drainage System Observations
Parameter
© Sheen
© Odor
© Floatables
Description
© Other
© Illicit discharge to storm drain, drain channel, or ditch?
❑r Illicit discharge to stream e c or river?
Drainage Basin
Creek
ff a spill or discharge reaches o stream, enter the stream name or tributary name.
Sub Basin Ellerbe Creek
Always enter the sub -basin where investigation occurred
Downstream Ambient Site ID
l f a spill or discharge reaches a stream, select the closest downstream monitoring site.
es on er urces
No Problem Found
Surface and drainage system
observations, drainage basin, and
spill volume and flow only need to be
completed if the situation warrants.
Spill Volume and Flow Rate
Total Volume Units F
Flow Rate Units
Method used to calculate flow rate and total volume:
If no source is
found, open
the Probable
Delete Source form
and select "No
problem
found."
Latitude, longitude, creek, and sub basin can also be entered on the Map tab.

Adding a Probable Source
❑ No water quality problem found
This form appears when
you click the Add Probable Construction Erosion and Sediment Controis
.No controls controls not maintained
Source button on the Field
Investigation tab. Check On -site Sewage Disposal
the relevant boxes and hit ❑L Discharging sand ❑I� Failing septic
filter system system
Save. You can select more
Private Connection to City Sewer System
than o n e probable source
House/Duplex Apartment/
ifnecessary. sewer lateral Commercial lateral
If you hit Cancel on this
form, or any others, your
changes are not saved and
no new records are
created.
City Sanitary Sewer System
❑r' Overflow Break
Other
© Illicit connection
© Petroleum spill/release
© Grease/cooking oil/food wastes
© Trash/garbage dumped in channel
© Water line break/leak
❑� Surface washing discharge
© Source unknown
❑ Leak
Investigationll) 3929
Sediment/Dehris in drainage system
❑l—' Pipe failure,
leak, etc.
❑ Other
© Other
❑ Laundry discharge
❑r' Commercial vehicle washing discharge
© Paint spill/release/dumping
© Improper management practice
© Leaf and yard waste
© Water quantity problem
❑� Other source
Save Cancel

Adding new data to Task Details
To add a new record, hit the
Add New button that is
below the listbox
Data entry form will
appear.
Task # is generated
automatically.
Spell check button
only checks this
record.
Data is not saved until
you hit Save.
Add Ne,%.-Task
If this is the first task associated with an
investigation the date, time, duration, and
task investigator are pulled from the
Investigation Overview tab.

Editing data on Task Details tab
Task
Select a record 1 Initial investigation
in the l i st b ox Follow-up Investigation
3 Follow-up Investigation
Follow-up Investigation
TaskID Investigation ID
Task 4 Description Fallow -up Investigation
Task Investigator Claire Tipton
Date 5f11f2015 Time 14:38
Details and Findings Edit or Delete Task
CT conducted a follow up onsite and noted the 55a had been stopped. Area still had some mud -mixed sc
An editable version of the form appears.
Make changes.
Data is not saved until you hit Save.
This is the same method you will use to
edit water samples, violations, and
enforcements.
Click Edit or
Delete button
z I& 4=1 L
Investigations[) 3930
Taska Description Follow-up Investigation F,] Date 5/11/2015 Time 14:38 = Duration (in minutes)
Task Investigator Claire Tipton on Always each eYnatkr (off—
offctwalakm, oprusp owf rk, t-veel
Details and Findings Yime, field investigation, meeting, eta)
CF conducted a follow up onsite and noted the SSO had been stopped. Area still had some mud -mixed solids, but in general most solids had
been scooped up and lime powder applied. CF called and spoke to Mr. Jones, who informed CF that he had been in touch with Junior Mobley
with Water & Sewer Mgmt. on Friday (518115) and that they had actually determined that the 550 was caused from the City side (the City
would reimburse him for his expenses). CF called Mr. Mobley and was able to speak with him on 5/13/15 about the situation. Mr. Mobley
stated that on Friday they had discovered that the line was actually city maintained and that the City was responsible for the SSO. However
moreently Water & Sewer Mgmt. Had discovered some contradicting building plans for the property and ultimately it was still up in the air
as to who was responsible. Regardless, on Friday (5/8/15) the City had jetted the lines and Mr. Mobley said they would send out a crew to
finish cleaning up the solids/mud along the path of the SSO, no problem. At this time, CT will not issue a notice due to ambiguous nature of
who is responsible.
Actions
Mr. Mobley stated he would keep CF in the loop at to who was the ultimate responsible party. No further action necessary. Investigation
resolved.
Spell Check � Cancel Delete

Water Chemistry Tab
Both the Chemistry and Violations tables have related tables.
When you select a record from the listbox, the data from the
related table displays in another subform on the tab.
nvestigation Overview ` Field Investigation I Task Details IWater Chemist y Contacts i Violations Enforcement Map
Sample Site
Sample I D Collection Date Location Sample ID ' 4u2 Task Number
Sample Location Cleanout at The Laundry Roam,
1483 5/5/2015 Outfall to UN Trib Sandy C k T i') D
Date 5/5/2015 Time
Meters Calibrated ❑ Chain of Custody in file?
Lab Sample Taken © Lab Sample Name
Add New Sample
Site
Edit or Delete
1 Data Entry Tracking
Created When I5/29/2D15 2:01:49 PM
Created By claireti
Edited When 5/29/2D15 2:01:49 PM
Edited By claireti
Parameter
Result - Analysis Type
Collection Method Instrument
Filtered Notes
Detergents or MBAS (mg/L)
1 Field
Grab Test Kit
No MBAS result was greater than the darkest
Delete
comparator of the chemets kit, 1 mg/L
No
Delete
Both the Chemistry and Violations tables have related tables.
You can directly edit the Parameters table on the Chemistry tab and the Corrective
Actions table on the Violations tab.

Editing an existing record on the Water Chemistry tab
Begin by clicking on the Edit or
Delete button in the selected
record.
A pop-up form will appear. You
may edit data from the Samples
table and the Parameters table.
If you chose to delete a sample
site, all the related parameter
data is also deleted.
Eait o- Deiete
Sample ID InvestigationslD 2
Task Number
' Sample Location Downstream of club Blvd bridge
Date 4/6/2015 Time 13:50
Meters Calibrated ® Chain of Custody in file? '`
Lab Sample Taken ® Lab Sample Name 20WQ400-1
Parameter Result Analysis Type
PH (S.I.) n Field
Spell Check Save Cancel Delete

Contacts Tab
The contacts tab only displays a portion of the data for each contact. Click on the View
Details button to see all the fields or to edit the data.
MaM Switchho and J WQ muesli g A—s V6_2
ID Z2DVVa4OO
Select an Investigation Add New
CR Flle H jfl) Q400 El IPrint Spell Check
Investigation Overview Field Investigation Task Details Water Chemistry
Name Company Phone
Sean's Doig [phone]
Previous First Set Investigation Folder
Next last Investigation Folder
Contacts Violations Fnforcement Map
Role Responsible Notes
Pa rty
Complainani No
Owner EYesl
ontact
View Details
View Details
View Details
f a notice needs to be sent to a
responsible party, then select Yes. If you
select no or leave this field blank, then
the responsible party's name will not
appear on the letter.
For an image of the Add Contact pop-up form, please see the Forwarding
Investigation/Add Contact slide earlier in this slideset.

The Violation
Violations Tab
type is listed in
the listbox.
Violations Add Violation I Click here to add a violation for NORs and NOVs
Select one a n d
1 Permits & Plans::ailure to conduct analytical and/orvisual stormwater runoff monitoring, as directed byyour facility's NPDES permit or bythe City of Durham. { Durham City Code rticle 5, C ,
it will display in
I Illicit Discharge: Failure to contain the discharge of a solid, liquid, or gas, otherthan storn-water either directly or indirectlyto the drainage system. (Durham City Code Article 5, Division 2,
A displayed
3 Automotive: Failure to contain and capture vehicle wash water. (Durham City Code Article 5, Division 2, § 70-511(a) & [b}}
-
4 Illicit rlischarnp, Faihirptncnntain the dischAmp of a solid. linnid. nrnas. nthprthan stnrmwater Pithprdirpctivor indirpctivtnthp rlrainavP wtpm. (Durham C:i1v C:ndp Artirla.S- Divisinn 7. § `
the s u bf o rm .
Violation # [:::-2 Violation Type Illicit Discharge: Failure to contain the discharge of a solid, liquid, or gas, other than stormwater either directly or indirectly to the drainage
system. (Durham City Code Article 5, Division 2, § 70-511(a) & [b}}
Violatio-ND [- J
Base Penalty (Base): $0.00 Violation of State WQ Stand ard(C)7 Knowledge of Code (G): Corrected (J)7
Degree/Extent of Harm (A): Violators Cost to Correct (D): Amt. Saved by Violation (F): Repeat Violation (K)7
If an NOV is required, ill in the fields in this box to
calculate the proposec penalty. Adjust the values
Duration (# days) (B): Cost to City (E): $0.00 Willful/Knowing (H)7
based on various factors (receipts, enforcement
Edit or Delete Violation
mee Ing, pro em corrected, etc.} once you are ready
Total Penalty(BasexAxBxCxGxHxKxJ+F-(0.75xD)+E): $0
to send an NOP. If necessary, ry.You can edit the
violation field using the Edit or Delete Violation
button. The violation text will appear in the notice
template.
Created By jonathanb Created When 4/5/2015 3:33:20 PMI Edited By Iseando Edited Wher 1 4/15/2015 10:03:31 AM
# Violationl❑ 84 CorrectiveActionf Best Management Practice NOR Deadline NOV Dead me
1 Immediately and completely cleanup spilled materials using dry methods. Contact City of Durham StormwaterServices 4/9/2015 Delete
upon completion. Provide a report of cleanup costs to Stormwater Services.
2 Please refer to enclosed guidance documents. Delete
3 Train employees not to wash stuff outside. 4/16/2015 pelete
Delete
Click on the appropriate violation in the top box
(Violations) and enter the corrective actions or best
management practices in this box. Corrective
actions/best management practices will be shown
for each corresponding violation. Enter the deadline
for each corrective action. Text entered in these
boxes will appear in the notice template.

Adding a new violation
To add a new record, hit the
Add New button that is Add Violation € Click here to add a violation for NORs and NOVs
above the listbox
Select a Violation Type from the dropdown list.
J dlgViolaticnsNew
InvestigationlD Violation # 5
Violation Type I \ , n-
Base Penalty (Base): Violation of State WO Standard (C)? Knowledge of Code (G): Q Corrected U)?
Degree/Extent of Harm (A): 0 Violators Cost to Correct (D): Amt_ Saved by Violation fl: Repeat Violation (K)? 0
Duration (# days) (B): Cast to City (E): $0.00 Willful!Kna ing (H)? 0
Total Penalty(BasexAxBxCxGxHxKxJ+F-(0_TSxD)+E):
Spell Check Save Cancel
t
The Base Penalty is generated from the Violation Type. If you do not fill in the remaining
boxes in the penalty calculator the Total Penalty will be equal to the Base Penalty.
Remember: The penalty amount is not included in the NOR, so you do not need to reset
the value to $0.00 if you are issuing an NOR.

Violations Tab — Corrective Actions or Best Management Practices
The corrective actions/best management practices displayed in the subform are
associated with the selected violations.
You may edit and delete these corrective actions directly on the Violations tab.
Violations
Add ViolatiDn Click here to add a violation for NORs and NOVs
2 Illicit Discharge: Failure to contain the discharge of a solid, liquid, organ, other than stormwater either directly or indirectlyto the drainage system. (Durham City Code Article 5, Division 2, §J
3 1 Automotive: Failure to contain and capture vehicle wash water. (Durham City Cade Article 5, Division 2, § 70-511(a) & (b}}
a•11___an.__L____.r__1..__a____a_._aL_J.__L _____2___I.J 1._....J ______aL__aL___a__.__..._a___.aL__J___sl_.____J.__sl._a_aL_J__._____.._a_.__ fr..._I__.__r.i. r_J_ ns__I_r r.. ___.__n {r
# Violationl❑
Corrective Action/ Best Management Practice
Provide a complete copy of your facility's Stormwater Pollution Prevention Plan for review by Stormwater Services
2 More stuff
r 3 Even more stuff
4 Yes this is what we are requiring
NOR ❑e�
3/24/2015 Delete

Violations Tab — Edit or Delete Violations
To edit an existing violation, first select
JE or Delete Violation
one from the listbox and then click the ............................................
Edit or Delete Violation button.
You may edit data associated with the violation, the penalty amount or the associated
corrective actions.
If you hit the Delete button, the violation and related corrective actions are deleted.
o is
InvestigationlD 2 Violation# 1
t
Violation Type Permits & Plans: Failure to conduct analytical and/or visual stormwater runoff monitoring, as directed by your facility`s NPDES permit or by the City of Durham.
(Durham City Code Article 5, Division 2, 4 70-514(a)j
Base Penalty (Base): $200.00 WQ Violation found (C)? Yes 0 Knowledge of Code (G): Yes 0 Corrected (J)? Yes
Degree/Extent of Harm (A): Medium 0 Violators Cost to Correct (D): $35.00 Amt. Saved by Violation fl: $52.00 Repeat Violation (K)? No
Duration (# days) (B): 2 Cost to City (E): $0.00 Willful/Knowing (H)? Yes 0 r
r
Total Penalty (Base x A x B x C x G x H x K x J+ F- (0.75 x D) + E): $3,625.75
r
IE
# Corrective Action/ Best Management Practice NOR Deadline NOV Deadline e
1 Provide a complete copy of your facility's5tormwater Pollution Prevention Plan for review by5tormwaterServices. 3/24/2015
2 More stuff
3 Even more stuff
Save Cancel Delete

Enforcement Tab — Add notification/enforcement
To view an existing
notification select one
=_stigation 0verviewl Field Investigation I Task Details l
from the listbox.
Enforcementl❑
Enforcernent/Notification:
NOV Jim Sapienzar Notification Type
NOR Jim Sapienzar Date Notified
NOR Jim Sapienzar
NOP Jim Sapienzar Recipient
NOR JimSapienzar
NOP DummvTest
Add Notification/
Enforcement
To add a new
notification click
this button.
Water Chemistry
1774
Enforcement and
notification
information will be
displayed to the right
of the listbox.
NOV
4/W2015
JimSapienzar
Violations
InvestigationslD 2
Edit or Delete
_ Enforcement
J Print Letter
Click this button to
open a new window
for editing or deleting
an enforcement
action.
ent Map
ViolationType Penalty
Illicit Discharge: Failure to contain the discharge of a solid, liquid, orgas, other than stormwater $0.00
either directly or indirectly to the drainage system. (Durham City Code Article 5, Division 2, § 70-
511(a) & (b))
Automotive: Failure to contain and capture vehicle wash water. (Durham City Code Articles, $175.00
Division 2, §70-511(a) & (b))
Enforcement Meeting Date
Certified Mail Number 111111112222 3333
Payment Status Valid for V0P Only
Total Penalty 175 Amount Received
Payment Due Date Payment Received Date
No Payment (Penalty Forwarded to City Finance Department)
Created By
Created When
Updated By Jonathanb
Updated When 51112015 3:48:12 PM

Enforcement Tab — Add notification type and associated violation
jj dlgEnforcementNew
k InvestigationslD 2
Notification Type
ci
NOR
Select Violations NOV
N OP
In Person
Phone
Email
Lette r
cl
date Notified
:h
1(
Recipient
itc
Enforcement Meeting date
JI
Certified Mail Number
IY
i
Click the Select Violations
button, which opens a new
I
window with the list of
violations selected on the
Violations tab.
Select the violation associated
with the NOR or NOV.
Select a notification type from
the drop -down box
dlgEnforcementNew
InvestigationsID 2
Notification Type
Select Violations
dlgAddViolations New
Illicit Discharge: Failure to contain the discharge of a solid, liquid, orgas, otherthan stormwater either directly or indirectly to the drainage system. [Durham City Cod(
Illicit Discharge: Failure to contain the discharge of a solid, liquid, orgas, otherthan stormwater either directly or indirectly to the drainage system. [Durham City Cod(
Automotive: Failure to contain and capture vehicle wash water. (Durham City Code Article 5, Division 2, § 74511(a) & (h)j
Illicit Discharge: Failure to contain the discharge of a solid, liquid, orgas, other than stormwater either directly or indirectly to the drainage system. (Durham City Cod(
Add Violations I Cancel

Enforcement Tab — Edit or Delete NOR or NOV
You can do the following in
the Edit or Delete
Enforcement window:
• Add a violation to the
notice
• Delete a violation from
the notice
• Change the recipient
(responsible party)
• Enter the notification
date
• Enter the Enforcement
Meeting Date
• Enter the certified
mail number
• Delete the entire
notification
EnfarcementlD 1775 InvestigationslD 2
Edit or Delete
Notification Type NOR Enforcement
dlgEnforcementRevised T 1 29 1
EnforcementlD 1775 InvestigatianslD 2
Notification Type NOR
Add Violations
ViolationType
ermits & Plans: Failure to conduct analytical andjorvisual starmwater runoff monitoring, as directed by
aurfacility's NPDES permit or bythe City of Durham. (Durham City Code Article 5, Division 2, § 70-514(a))
,utamotive: Failure to contain and capture vehicle wash water. (Durham City Cade Article 5, Division 2,
D 511(a) & (b))
Date Notified
Recipient
Enforcement Meeting Date
Certified Mail Number
L4f6f2615
Jim 5apienaar
5555 4444 3333 222211111
Change Recipient
Save Cancel Delete
Proposed Penalty
$3,525.75
� Delete
$175.00
� Delete

Enforcement Tab — Edit or Delete NOP
You can do the following in
the NOP window:
• Add a violation and
the associated penalty
to the NOP
• Delete a violation and
penalty from the NOP
• Add the enforcement
meeting date
• Add the certified mail
number
• Calculate the final
penalty
• Enter the penalty
amount received
• Enter the penalty due
date
• Enter the penalty
received date
• Check no payment if
the penalty is sent to
the Finance
Department and a
private collections
agency
tnrorcemenuu _yFF invesngacnonsw 2
Edit ar Delete
Notification Type NOP Enforcement
dlgEnforcementRevised I. zz
Enfcrcementl❑ 1966 InvestigaticnslD 2
Notification Type NOP
Add Violations
ViolationType Proposed Penalty
Automotive: Failure to contain and capture vehicle wash water. (Durham City Cade Article 5, Division 2, § $175.00
70-511(a) & (b)) 6ele#e
Illicit Discharge: Failure to contain the discharge of a solid, liquid, or gas, other than starmwater either
directly or indirectly to the drainage system. (Durham City Code Article 5, Division 7, § 70-511(a) & (b)) Delete
Date Notified 5/9/2015
Recipient Dummy Test Change Recipient
Enforcement Meeting Date
Certified Mail Number
Payment Calculate Final Penalty
Total Penalty 175 Amount Received
Payment Due Date
Date Received
No Payment (Charge Forwarded to City Finance Department r'❑
Save Cancel Delete

Enforcement Tab — Print a Notice
EnforcementlC 1a qnuestigatinslD nClick the Print Letter button to
Edit or Delete gQenerate a letter in the database.
Notification Type NQV Enforcement b
Date Notified A "1A.72015
Recipient _'-i Sac'erizar Print Letter
Make sure that all information is
entered into the Contacts tab for the
responsible party, including:
• Title
• First and Last Names
• Company name (if applicable)
• Full mailing address
• Yes is selected from
"Responsible Party?" drop -
down box
Right click on the Notice to
export and save. Notices
should be exported as PDF
and saved in the electronic
investigation folder.
DUMAM
1869
NOTICE OF VIOLATION
1—., —
Cerff.dmalllFi7M31R)0 787345111
Mr. Mike Kidd
4943 oedield St.
Durham, NC27704
L.catim d imes[iga[ion. 1@ @y Hall Plz, Durham, NC
Dear Mr_ Gd d,
You are required to mrreR aviolation of the Crt�s Stonnwater Managemern and Pollutim mntml
Ordinance (the "0kinan ce"j t.urid during a Stmmwater Investigation (Reference N1SNCp42( of
your husness. the investigation was conducted by Sormwater Investigatorlon baker m
3/1J/2015, as alloxed by t]rdinanre § ]O-E25.
You have been nidentified as a party resp.n9hk fo,the husiness. A[rordingtothe 0rdinan..
responsibility dudesthe ability to con[ml what cams m property thmugh .uvnershlp d the
praperty.,through ownership,—tral,.,management of a business, organization, o, Mherent'ty
whom artrvities oaur on property, and also as pmvned in]o-S IrI-Violatnns fthe ordnance
m ay he committed through deliberate action, n l� nce, om ivon,miriattentim.
Yrola tion and Caret —Asti ons
9elow,ad—ption dthe violatim(s(-Al»li-d are the proposed mil pen allies. A p m d
civil penny ¢the amount that you will he penalized N you take no afi.n-The prop—d amount
will he decreaxd or suspended tithe corrective icton—complted as required.
Eadi vie - na -rate offer. Each day avid—, cornnues may he -rate off—
Dufh-- Where G—t 7h,i p Happen

Map Tab Overview
Investfgation Overviewl Field Investfgation Task Details Water Chemistry Contacts Violations Enforcement Map
la 0
Field Address 5702 Newhall Rd
Latitude N 35.88319
Between 35.5 and 36.5 Decimal degrees
Longitude W-78.90911
Between-78.6and -79.1 Decimal Degrees
Add Lat/Long Open in
from Map I Streetview
Creek Northeast Creek Tributary
If a spill or discharge reaches a stream, enter
the stream name or tributary name.
Sub Basin I Northeast Creek
Always enter the sub -basin where
investiLyation occurred.

Enter address and press
Map Tab Features View layer list tool magnifying glass icon to
Identify tool zoom to location
Zoom in and out buttons 4WMain St
122�•�4
Quality Zoom out to full extent
Water
:3 212
B13
Zoom in and out
to specific areas
Pan map tool city Hall Piz
Quickly turn on and off Water, Sanitary Sewer,
and Stormwater layers with these buttons Set lat/long
coordinates for 10.E
investigation
jW-�j
S D 1
Turn on and off
0 50 100ft aerial photo layers 1 r

Map Tab- Identify tool
Use the identify tool to
display a pop-up window
with summary information
for an investigation or a _
parcel.
Map
' 116 L #25 Al o
106.
1, �r. 104
1 City Hall Piz
CRFile: IIWQ162
InVE5tigation Date: 7/29/2011
Lead Investigator; Bill Hailey ,
111 Field Address: 300 North Mangum Street
Description; Illicit discharge (sediment) 1
109 into the storm drainage system.
06
107
105 Zoom to
'14 -i UY
11 1�1
'11
2 1 r-,(3 A=
108 2 05

Map Tab — Setting Lat/Long Coordinates
Latitude N 1 35.99-C=
Between 35.5 and 36.5 Decimal Degrees
Longitude w1 -79.94153M
Between -78.6 and -79.1 Decimal Degrees
Add Lat/Long Open ire
from MaV Streetview
3. Click on the Add Lat/Long
from Map and like magic the
coordinates will be added to
the fields above.
2. Click on the location of
the source of the water
quality problem for your
investigation (a window will
appear with lat/long
coordinates
A F'
1. Click the bullseye icon
�lz

r
Printing a Single Investigation Report
E. Main Switchboard { n wQInvestigat(onsV6_2
ID 2 Select an Investigation Add New
20WQ40U �p}jljq¢�p Print Spell Check
Investigation Overview Field Investigation Task Details Water Chemistry
rptPrintInvestigation
DURHAM
11F UUNHAM
Report gen erased on: 6115/2015 9:58:38 AM
Works
srov. k?, & GIublic
G!S Serviws
Report generated 6y: lonathanb
®CITY
1G1 Citaier&
101 City Hall Plate Durham, NC 27TD1
919.560.43261 F 919560.4316
1 8 6 9 """"'d,rhamnc go
Stormwater Investigation Report
Investigation Summary
Is the investigation —1—d? NN.
City Investigation Number: 20WQ400
Investigation Type: Weekend Enforcement
Complainant Name: Sean's Doig
Com plaint Date: Lf1f2020 Co. plaint Time:
Complainant's DescriptionofPmblem:
Leaves in street
Lead Investigato, John Cox
Additi a1Staff: Probable Sourceof Water Quality ProblemF7]
Failing septic system
Investigation Date: 6f1f2015
City -maintained sanitary sewer break
Investigation Time: 12:05:00 PM
Initai Investigation Duration: 75 mutes
Investigator's Description of Problem:
athlakiwel
Location of Water Quality Problem: 114 W Main St
Latitude: IN 35.99547 Longitude: W-78.90111
Property Type Where ProblemOriginated: I Residential(housefduplex)
Drainage Basin: hird Fork
Wreek Name) Third Fork Geek (Sub -basin Name(
Page 1 of 2
Click the Print button to
generate an investigation
report.
rptPrintinvestigationDetails
Microsoft Access
Right -click on report to print.
aic
Investigation Tasks (Details & Findings}
TasklD: [1 Task Description: Initial investigation Date: lfl/2020 Time: 12:05 T sk Duration: 75 (min)
Task Investigator: Ion Baker
Details and Findings:
Jon ny B went out and looked at the problems.
Act
a
He ad a em the dot aM.
TasklD: �2 Task Description: Follow-up Investigation Date: 4/15f2015 Time: L0:00 Task Duration: 20 (min)
Task Investigator: Ion Baker
Details and Findings
so many fndingsitwould blow your mind. And detailsto spare.
Act'
btsand bts of actions
T.:klD: [3 Task Description: Follow-up Investigation Dater Tim e:� Task Duration: (mini
Task Investigator: Ion Baker
Details and Findings
Act'
Water Chemistry Results
Taskl D: F Location: Downstream of dub bFvd bridge Date: 4/6/2015 Time: 1:50:00 PM
WerefiAd meterscalibrated? 0
Werelabsamplescollected? Yes Lab Sample Name: I 20WGL400-1
Parameter Result Analysis Type Collection Method Instrument Filtered Notes
pH (5.1.) 9 Field Grab Pen No
Page 1 of 5
The Investigation Report separates into two tabs: a summary report and a details report

The Switchboard
Main Snit€hbaard'i !.q Overview Map J �J. WQInvestigations V6_8
❑ Investigations Data Entry
❑ View Complaint Log
❑ Search Investigations
❑ Reports
❑ Weekend Enforcement
❑ Seger Spill Reports
❑ Assign Spill IDs

Search
Main Switchboard -5� Overview Map i WQ Investi g ati o n s V6_8 'EM- Search
Enter Search Criteria
CR =ile ft
Date of Initial Investigation
Investigator
Location
CB File# Investigation Date Investigator
21WCL999 1011012021 James Pflaum
211 05%
21WC 9%
10/1012021 Jaynes Pflaurn
10}10{2021 Jaynes Pflaum
Contacts
Business Name
Investigator's Description
search blear Search close Search
Contacts Field Address Company Investigator's Field Description
Bob 13254 diman7
Bob Newhart 13254
Sean Doig 13254
Sornevvhere in durham
-Somewhere in durham
21►NQ999 10/1012021 Jaynes Pflaurn Jeff Lecky 13Z54 COD
Somewhere in durham

Reports
Lead Inrrestigator Summary Sheet Investigator - Report
Lists in vestigations by prinapal in Vestigatar f ar selected fiscal year Fiscal Year - F Datasheet
Monthly Summary Report
u m m ary n u m hers by selected dates
Missing Data
Lists investrgations with missing data far a given month in the current year
Enforcement Actions Summary
.Summ adzes ernf arcemen is f ar selected m an th are d year
Month Report
Year Datasheet
Exportto Eccel
Month Report...
Year
Month Report
Year Datasheet
Complaint Log with Notice Count Start Date Datasheet
Lists investrgationsforselected dates End Date
Task Details Review Month =orm...
Farm th at displays all tasks (sorted by CR File an d Task #) far a given m an th Year - Ah
Annual Report Numbers Start Date Report...
Displays summary data Based an selected dates End Date Datasheet...

Lead Investigator Summary
Lead Investigator Summary Sheet
Lists investigations byprincipalinvestfgatorforsefected fiscal year
Inamoftations by Load In Bator: Jan Balder
Investigations for the Fiscal Year: 9
Percent of Investigations for the Fiscal Year: 9.18%
July, 2015: 4
August, 2015: 2
September, 2015: 1
October, 2015: 1
November, 2015: 1
Investigator Jan Baker Report
Fiscal Year E::: Datasheet
Total #of Investigations FY 2016 : 98
Lead Investigator for
Outfall Screening
1211612015 9:11:50 PM Page 1 of 1

Investigations Summary Report
Monthly Report Calculations
Novefnbef
New i nvestigations
Staff- initiated investigations
FolloYuup investigations
Total n umberof i rive A iig ations
Total staff time for all investigations
Total response time (business days);
Average response time (business days);
Unresolved Investigations
November 201S
Ccunt TctalSta- Haurs Aver ageSte IfHrs/Investigation
21 =Y.-' Hours v.Y' Hours
Unresolved for morethan 4 months ; 17
Unresolved for less tharr4months ; 15
Pollution Sou fc es Controlled
November
City-mairtained sankary sewer overfbw 0
Ctt mairtained sankary sewer break 0
Cit�-mairtained sanitary sewer leak 0
Other cit-maintained s;--wEr issue 0
Private -sanitary sewer 2
On--4tesewrage treatment 0
Ilick Conn ect ion 0
Eresion sed rn ent co ntro 1 2
FoodvrasteJgrease 0
Water line break/leak D
33 17.17, Hours v.52 Hours
5
3F.55 Hours -.uF Days i= Haurs
15.1v Business Days
v.71 Business Days
Art o bile vehicle vrash ng*
1
Surface washing discharge
2
Faint
0
Petra leum
0
Improper Management Practices
0
Yard vrale
1
-Other
1
No problem identfied
1
Infrastructur e�dran age
1
Source rernans unknovm
0
Total Pollution Sou riesControlled: 10

Missing Data Report
Missing Data Report
November 2015
15WCII74 Lead Investigator; Fatrck Hogan
Main Investigation Tabs ProbableSou rce Data
At east cne prcLaL e scurze s sted
Contacts
M a i n I nve stigati on Ta bs
15wC1.1
rive stigato rrs description is missing
Blain In
Street address is missing
Property type is missing
Latitude is missing
Longitude is missing
15wm Sub Basin is missing
Main Investigation Tabs ProbableSou rce Data
At east one prabab a sourze 's 'sted
Contacts
At east one zonta`t 'sted
151h QA T7 Lead Investigator; Jam esFflaurn
Main Investigation Tabs ProbableSou rce Data
At east one prabab a sourze 's 'sted
Contacts
At east one f:orta:t 'steel
Probable source Data
Drobable source is missing
Conta ets
Al least one conlad listed

Enforcement Actions Report
Monthly
Enforcement Actions
November 2015
NOR
1
CR File #
ResponsihleParty
Notification Date
Working
Recipient Total Penalty
Determined Date
pays
15-WQ176
11/18/2015
11/25/2015
5
David Knott
NOV
2
CRFile 4
ResponsihleParty
Notification Date
1Norking
Recipient TotaIPenaity
Determined Date
Days
15VVQ175
11f3f2015
11/10/2015
5
5arnuell Bailey
153NQ186
11/19/2015
11/25/2015
5
Ilene Britt
NOR
NOV
Sum
NOP
Pena Wes
Enforcement M eetirigs
Cou nt
1
2
3
Cou nt
B
D
Avg Days
between
Determination
Percent Issued
cumulative
and
with 5 Bus! ness
Days
Notification
Days
5
5. CC
100_00%
10
5. CO
100_00%
Tota I Amount Total Amount
Assessed Col Iected

Annual Report Numbers
Annual Report 7 1 015 - 1 15 015
New invest igat ions
Staff -initiated investigations
Fol low-u P i nvesti ga #ions
Total number of investigations
Total staff tirne for all investigations
Total response time (business days):
Average response time (business days):
Count Total Staff Hours Average Staff Hrs/Investigation
.90 104.20 Hours 1.16 Hours
6
231 102.12 Hours 0.44 Hours
321
206.32 Hours 22_92 Days 0.64 Hours
62.80 Business Days
0.70 Business Days
Avg Days
between
Determination
Percent Issued
Cumulative
and
with 5 Business
Count
Days
Notification
Days
NOR
9
29
3.22
88.89%
NOV
8
23
3.29
104_00'
Sum
17
Cou Dt
Total Amou nt
Tota I Amount
NOP
5
Assessed
Col Iected
Penalties
$27,462.50
$175.00
Enforcement M eeti ngs
1