The Form
The form for requesting information from the LUST Cleanup Site Database
contains nine fields [1-LUST Number, 2-County, 3-Year, 4-Region, 5-Site Name,
6-Address, 7-City, 8-Zip Code, and 9-Underground Storage Tank (UST) Facility
Number], four checkboxes (10-DEQ Cleanup File Open, 11-Unregulated Heating Oil
Tank, 12-Unregulated Tank, and 13-Regulated Tank), and two buttons (14-Lookup,
and 15-Clear). Two of the fields (County and Region) have drop-down lists that
provide you with the allowable choices.
Leaking Underground Storage Tank Cleanup Site Database
Performing a Search
When you want to search for data, you only need to enter information into as
many fields and check as many boxes as are necessary to produce the dataset that
you want. Also, in most of the fields you can provide partial information and
the search will produce all entries that include that part within the overall
field.
After entering information into the fields, click on the "Lookup" button to
perform the search. Depending on how many entries are found, this may take a
while. You will then see a form which lists all of the sites that meet your
search requirements. The results are listed in a table which includes the Log
Number, Site Name, Address, City, Zip, and County.
You can sort this table by clicking on any of the six heading names. If you
want them sorted by zip code, for example, simply click on the word "Zip" at the
top of that column. To view the information for a particular site, click on the
specific log number for that site in the first column of data. This will
generate a site-specific form listing information that is contained in the LUST
database.
NOTE: Depending on the priority of the site, when the latest report
was submitted, if a project manager is assigned to that site, and other factors,
that form may not be completely up-to-date. If you need to know all of the
latest information about a project, you should contact the appropriate Regional
Office and make an appointment to view the project file.
To begin a new search, you can click on the "Clear" button to delete all of
the entries from the form, or you can change one or more entries by deleting and
typing them individually.
Several examples of Leaking UST database searches are listed below:
- You're working on a specific project and want to check the status in the
Leaking UST database. Even though you have all of the information -- Leaking UST number, site
name, address, etc. -- you only need to enter the Leaking UST Number, then click on the
"Lookup" button to produce a list that should only contain one entry. Clicking
on the log number will produce the report for that site.
- You want a list of all reported releases for Marion County in 1999, sorted
by city. Select "Marion" from the County drop-down list, type 1999 into the
field marked "Year," and then click on the "Lookup" button. When the list of
sites appears, click on "City" to sort the list by city name.
- You want a list of all reported releases for unregulated heating oil tanks
in Lane County in 1999, sorted by zip code. Select "Lane" from the County
drop-down list, type 1999 into the field marked "Year," click on the box by
"Unregulated Heating Oil Tank" (a check mark should appear in that box), and
then click on the "Lookup" button. When the list of sites appears, click on
"Zip" to sort the list by zip code.
- You know there was a release from a site on Cornell Road in Washington
County, but you don't know the address and are not sure what year the release
may have occurred. Select "Washington" from the County drop-down list, type
Cornell Road in the field marked "Address" and click on the "Lookup" button.
Because many fields are available for your use, there may be several ways to
perform a given search. For example, the initial search described under the
second bullet above could have been accomplished by typing 24 (the number for
Marion County) into the first part of the Leaking UST number field and 99 (the year)
into the second part. By leaving the third part empty, all releases in Marion
County in 1999 will be listed.
Fields, Checkboxes and Buttons
- Leaking UST Number: This is an eight-digit site identification number that
looks something like this: 15-99-0067. If your facility has had a release,
letters from the Department would contain this Leaking UST log number.
The first two digits are a code for the county in which the release occurred.
The numbers of each of Oregon's 36 counties can be found on the County List on
the UST Program Regional Office page. The second two digits are for the year in
which the release was reported; 99 represents 1999, 01 represents 2001, etc. The
final four digits are the number of the release in the listed county for that
given year. So, 15-99-0067 stands for the 67th reported release in 1999 for
county 15 (Jackson County).
When you use the LUST number field you may enter all 8 digits if you know
them, or you may enter only one or two parts of the number, such as just the
county number, or just the county and year. You do not need to enter any
hyphens, just put the digits in the appropriate boxes. If you only enter part of
the 4-digit release number, the search will lookup all release numbers that
start with the digits you entered.
For example, if you entered "15" and "99" and "00" into the form, you would
get a list of all reported releases in 1999 for county 15 that were assigned
release numbers beginning with "00". So, 15-99-0067 would be one of the sites
contained on this list.
- County: To enter a county name, click on the arrow to reveal the list
of names. Then scroll down and click on the county of interest.
- Year: Type a 4-digit year in the box, such as 1999, or 2001.
- Region: To select a region, click on the arrow to reveal the list of
names. Then scroll down and click on the region of interest.
- Site Name: This is the name assigned to the project by the DEQ, such
as John Smith Texaco, or River City Auto, etc. If you don't know the complete
name you can enter a partial name to get a list of sites containing that word or
name. For example, you could search for all site names that include the name
"Chevron" by typing that in the "Site Name" field and clicking on search.
NOTE: In the site printout all heating oil tank sites will simply
be listed as "Heating Oil Tank" in the "Site Name" column. This is done in order
to maintain privacy and prevent the release of the homeowner's
name.
- Address: This is the mailing address of the site. If you only know
the street name you can enter that in the "Address" field and get a list of all
reported releases on that street. Or, you can enter just an address number
without the street name (such as 5600) to narrow your search to one or only a
few sites.
- City: This is the city name contained in the mailing address. Note
that there are cases where this may not be within the city limits. For example,
many businesses in unincorporated Washington County have Portland mailing
addresses, even though they are NOT within the Portland city limits. The same is
true for some locations in Clackamas County.
- Zip Code: This is the zip code associated with the mailing address
for the site.
- UST Facility Number: This is the UST Facility Identification Number
that the Department assigns to each facility with regulated underground storage
tanks. Releases at unregulated facilities, such as residential heating oil
tanks, will not have a facility number.
NOTE: If you entered the facility ID for a site and the search did
not return any results, you may want to search by address since facility IDs
have not always been entered into the database.
- DEQ Cleanup File Open: Check this box if you only want to see the
facilities that have not yet been "closed." An open site is one that has not yet
met the requirements of the UST Cleanup Rules to receive a "No Further Action"
letter from the Department, or has not yet been reviewed by the DEQ for closure.
- Unregulated Heating Oil Tank (HOT): Check this box if you only want
to see releases reported from unregulated heating oil tanks (HOTs), such as
residential HOTs.
- Unregulated Tank (Non HOT): Check this box if you only want to see
releases reported from unregulated tanks OTHER than HOTs, for example, farm fuel
tanks containing less than 1100 gallons.
- Regulated Tank (UST Facility): Check this box if you only want to see
releases reported from regulated UST facilities.
- Lookup Button: Click on this button to perform a data search after
you have entered data into appropriate fields and checked any necessary
checkboxes.
- Clear Button: Click on this button to delete all of your entries from
the form.