[Sqg-program] PUOCC Data Update

Griffith, John "Jack" John.Griffith at dep.state.fl.us
Tue Jul 19 16:10:36 EDT 2011


County SQG folks,

40 verifications (from early June to mid-July) may had certain data elements overwritten (including the verification date) during our addition of the PUOCC data to the SQG database. Unfortunately I had to pull the data in June and massage and match it before re-writing it in July.
We pulled the verification numbers for the year before we ran the scripts to be sure we didn't mess up the bean count. I have pulled a list of the ones that were overwritten (attached).

Please feel free to make corrections to the listed SQG IDs verification data in CHAZ SQG. No county has more than 6 that were overwritten. The ones I overwrote were the existing PUOCC matched facilities that were over 5 years old where I had newer data than what was in the SQG data.  The listed SQGs verified in June-July may have lost some of the recent data in the verification tab. No waste records were altered (except for the new UOEO records).

Please do not add "UOEO" wastes to the data, we intended to block County access to add these, but did not get it implemented. This should be fixed shortly. Any that are added will be deleted when this is corrected.

Thank you for your help and patience.

Jack Griffith
Florida Department of Environmental Protection
MS 4550
2600 Blair Stone Road
Tallahassee FL, 32399-2400
850-245-8748
Please note: Florida has a very broad public records law. Most written communications to or from state officials are public records and may be made available to the public or media upon request. This e-mail communication, your reply, and future e-mails to my attention may therefore be subject to public disclosure.



The Department of Environmental Protection values your feedback as a customer. DEP Secretary Herschel T. Vinyard Jr. is committed to continuously assessing and improving the level and quality of services provided to you. Please take a few minutes to comment on the quality of service you received. Simply click on this link to the DEP Customer Survey<http://survey.dep.state.fl.us/?refemail=John.Griffith@dep.state.fl.us>. Thank you in advance for completing the survey.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.dep.state.fl.us/pipermail/sqg-program/attachments/20110719/7c11f32c/attachment-0001.htm
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PUOCC_overwrite.xls
Type: application/vnd.ms-excel
Size: 37376 bytes
Desc: PUOCC_overwrite.xls
Url : http://lists.dep.state.fl.us/pipermail/sqg-program/attachments/20110719/7c11f32c/PUOCC_overwrite-0001.xls


More information about the Sqg-program mailing list