HomeMy WebLinkAboutDEQ-CFW_00012295From: Moore, Tom [/O=EXCHANGELABS/OU=EXCHANGE ADMINISTRATIVE GROUP
(FYDIBOHF23SPDLT)/CN=RECIPIENTS/CN=9ECD84E0013D445189AFBCBBDCBF351E-TFMOORE]
Sent: 5/2/2016 1:22:38 PM
To: Belnick, Tom [/o=ExchangeLabs/ou=Exchange Administrative Group
(FYDIBOHF23SPDLT)/cn=Recipients/cn=9b26435493e14b3986935598ac339b1b-tbelnick]
Subject: RE: USGS request for wastewater data
Attachments: NPDES WW Permits - Montly Avg Flow (2010).xlsx; NPDES WW Permits - Montly Avg Flow (2010).xlsx
Mere is the flow data for 2010. 1 used same scripts that I used to pull for some of the other data requests for flow. It
includes both facility and outfall lat/longs.
I am going to see if I can set this up as a report that can be used to pull the data by users. My scripts are written so they
run more efficiently and should be able to be run for an entire year without any issue.
Thomas F, Moore
Enid. Si€`€ess & Technology Application Analyst
Division of Water Resod.drees
Department of EnvironMental Quality
(91€) 795-7301 office
tom.f.moore ncdenr. ov
Wilmington RegionalOffice
'127 Cardinal Drive Extension
Wilmington, NC 28405
Sent: Monday, May 02, 2016 9:15 AM
To: Moore, Tom etom.f.moore@ncdenr.gov>
Subject: RE: USGS request for wastewater data
Thanks Torn. I'm assuming they want Qutfall lat/long, as they are modeling a water budget.
Trim BeInick
Supervisor
NPDES Complex Permitting Knit, DW
North Carolina Depart€rent of Environmental Quality
919-807-6390 office
tom.belnick ncdenr. ov
512 North Salisbury Street
1617 Mail Service Center
Raleigh, NC 27669
DEQ-CFW 00012295
Sent: Monday, May 02, 2016 8:58 AM
To: Belnick, Tom <tom.belnick@ncdenr.gov>
Subject: RE: USGS request for wastewater data
.l.om,
Large data pulls via BIMS Reports will cause the error you mention as the network has limitations on how much info can
be sent at once.
I will just pull this info in one file for you. Do they only want the facility lat/long or the outfall lat/longs?
Thomas F. Moore
Business & Technology Application Analysl
Division of Water Resources
Department of Environmental Quality
(10) 790-7001 office
fonn.f.Moore 5ncdenr.1 ov
Wilmington Regional Office
127 Cardinal Drive Extension
Wilmington, NC 28405
`P_ ,. .,... �.,.., w� S �, .,...
From: Belnick, Tom
Sent: Friday, April 29, 2016 4:25 PM
To: Moore, Tom <tom.f.moore@ncdenr. ov>; Smith, Jennifer <'ennifer.h.smith@ncdenr. ov>
Subject: FW: USGS request for wastewater data
Torn- BIMS question. I was able to complete the first USGS data request for 2010 flow data from individual NPDES
WW.I_Ps, by sending spreadsheets for each month using O.AMONAVG for all individual NPDES permits.
Question i.- how would I download lat:tlong dat:a from BIMS for all NPDES individual WWTPs. What: Report:
Category/Report Dame?
DEQ-CFW 00012296
Question 2-- last time I broke flaw data into months, because the pull for the entire year did not work [502 Error]. Any
suggestions.
Thanks
Tom Belnick
Supervisor
NPDES Complex Fier€nittinq Unit, DWE
Forth Carolina Department of Environ€rental Quality
919-807-6890 office
tom.belnickncdenr.gov
512 North Salisbury Street
1617 Mail Service Center
Raleigh, NC 27669
From: Smith, Douglas [mailto.d smith@us s, ov]
Sent: Friday, April 29, 2016 10:58 AM
To: Belnick, Tom <tom.belnick@ncdenr.gov>
Subject: USGS request for wastewater data
I left you a voicemail yesterdaypertains to the requestrecently .!- for wastewaterdischarge
data in NC. We held a lengthy meeting yesterday with the modelers and they may need significantly
more discharge data than previously indicated. They are still in the process of developing the
framework of the model and some uncertainty exists regarding how far back in time the wastewater
discharge data will be needed. We will definitely need the 2010 data that you sent me along with
location data and I• • and/or streetaddress)added. I was mistaken- -i for
average daily flow value for the year for each facility. The monthly data you sent is exactly what they
need for the models.
possible or • to keep from significantly• •' on • would be willing to do the
retrievals from the database if that could be arranged. If someone could walk me through the process,
I might be able to pull the data as needed to limit the demands upon your time. The reason I suggest
this is because modelers • -• they may need wastewater discharge data back as
the fibavailable.- amount of • discharge data needed I be for the years
Iffiliffis M-MANOMOMMINSE
DEQ-CFW 00012297
please let me know if any clarification is needed or if you have any comments or questions about the
subject matter presented in this email. Thanks again for your help Tom.
OEQ-CFVV_00012298