PREP Database Files

DEQ has provided data from the agency’s Pollution Response Program (PREP) database. Three files are contained in the self-extracting zip file presented below. The first file, i_prep_data.txt, contains key information concerning the PREP database data. This file is best viewed in a spreadsheet program such as Excel. The second file, 'prepdata.txt, contains PREP database data in ASCII tab-delimited format for PREP incidents from October 1, 2009 to the present. . The third file, “prepdata_prior_to_10012009.txt” contains PREP database data in ASCII tab-delimited format for PREP incidents prior to October 1, 2009.

In order to perform search and queries on this data, you will need to import the prepdata.txt or prepdata_prior_to_10012009.txt files into a spreadsheet or database program such as Microsoft Excel or Access. All major programs include file import and export capabilities. Please refer to the documentation that accompanies your program for the procedure to import a tab delimited ASCII file. Please DO NOT call DEQ with data import or computer related questions.

If this data is distributed in any form, DEQ should be referenced as the data source. The following statement should also be included with any distribution of this data: "DEQ does not certify this data to be all inclusive or complete. This data is provided to the citizens of the Commonwealth of Virginia free of charge for informational purposes only."

*** PLEASE NOTE: DEQ does not maintain files (physical or electronic) for PREP incidents that have been closed for more than five years.***

If you have specific questions regarding the interpretation of field descriptions, you should contact the appropriate DEQ Pollution Response program staff. contains all the files needed to view the current PREP database Winzip Format

footer divider
footer divider
footer divider
Virginia Department of
Environmental Quality
P.O. Box 1105
Richmond, VA 23218
(804) 698-4000

Some resources on this website require Adobe Reader and Flash Player, Microsoft Word, PowerPoint or Excel. If you wish to receive this content in an accessible format pursuant to Section 508 of the federal Rehabilitation Act of 1973, as amended (29 U.S.C. ยง 794 (d)), please call 800-592-5482. In addition, this website includes hyperlinks to websites neither controlled nor sponsored by DEQ or the Commonwealth of Virginia. Links may open in a new window. If you wish to receive content from a website which is neither controlled nor sponsored by DEQ or the Commonwealth, please contact the host of that website directly.

Privacy Statement | Terms Of Use | WAI Compliance | Contact Us