Home
Flowchart
Justifications
Benefits
Definitions
Codes / Forms
Queries
Scanning
Offices
FAQ
GIS
Support

SAMPLE QUERIES for OALS


How many projects have been received from the Louisville District Corps of Engineers?*
FILENAME ..COE-ORL..

How many Environmental Reviews received from Washington Office?*
FILENAME ..ER #0.. or FILENAME ..FWS-WO..

How many projects completed with Indiana bat given as species located near project impact area? SPECIES ..M003..

How many PDCs (Pre-Development Consultation) were reviewed for Knox County, TN?
ACTIVITY ..3.. COUNTY 47093

How many “Species in Project Area” projects were reviewed this fiscal year?
SERVPOS1 ..E..

How many projects occurred in the French Broad watershed?
ECOSY ..4.. or 4 RIVER ..C.. or C

Calculate number of coal mining projects completed so far this fiscal year.
WORK ..O..

How many Section 10(a) permits for fish were completed?
ACTIVITY 2L

How many Section 7 projects were located in the Duck River Watershed?
ACTIVITY ..2.. ECOSYSTEM ..1.. RIVER ..A2..

How many transportation projects located in Davidson County, TN, were completed?
AGENCY ..11.. COUNTY 47037

How many projects had stream relocations?
WORK ..L5..

How many contaminant projects were completed for KY and TN?
ACTIVITY ..4..

Have we received KSMRE coal project # 867-9014? If so, what is the log number?
LOG: Check Box FILENAME ..867-9014..

Have we received anything on the Sneedville cellular tower site? If so, what is the log number?
LOG: Check Box and FILENAME ..SNEEDVILLE.. and
ACTION AGENCY ..25.. and TYPE OF WORK ..D3..


How many cell tower projects have been completed this fiscal year?
AGENCY ..25..

How many projects involved migratory birds?
PRIORITY SPECIES ..A..

How many partners projects were received this fiscal year?
ACTIVITY 5C or ..5C..

How many projects had upland development habitat?
LOG: Check Box HABITAT ..C3..

Calculate number of hours worked by Wally Brines (Hint: WFB) for first three months of FY03?
(no checks; date out >9/30/01, <1/01/02; type CALC SUM in Hrs ES and Hrs Other)

Calculate number of acres by Corps of Engineers projects in Kentucky?
RES_UNITS A and ACTION AGENCY 2 and STATE KY


Hints for Operating Queries
*The Cookeville Field Office logs all projects from the Louisville District Corps of Engineers as “COE-ORL”.

*The Cookeville Field Office logs all Environmental Reviews received from the Washington Office as “FWS-WO” and/or “ER #03/0111".


REMEMBER:
If you have problems operating queries, please call Sandra Silvey at 931/528-6481, ext. 200.