United States
Environmental Protection
Agency
Environmental Research
Laboratory
Corvallis, OR 97333
EPA/600/8-91/054
August 1991
Research and Development
wEPA ~^e Permit Tracking System (PTS):
A user's manual
-------
THE PERMIT TRACKING SYSTEM (PTS):
A USER'S MANUAL
by
Cindy C. Holland1
Mary E. Kentula2
Program by Robert G. Gibson1
1ManTech Environmental Technology, Inc.
USEPA Environmental Research Laboratory
200 SW 35th Street
Corvallis, OR 97333
2USEPA Environmental Research Laboratory
200 SW 35th Street
Corvallis, OR 97333
Contract Number 68-C8-0006
Project Officer
Eric M. Preston
Wetlands Research Program
USEPA Environmental Research Laboratory
200 SW 35th Street
Corvallis, OR 97333
ENVIRONMENTAL RESEARCH LABORATORY
OFFICE OF RESEARCH AND DEVELOPMENT
U.S. ENVIRONEMENTAL PROTECTION AGENCY
CORVALLIS, OREGON 97333
-------
NOTICE
The Permit Tracking System (PTS) was developed to track information on
the wetland resource affected by permitting, as opposed to information
on permit status and activity (e.g., acceptance or renewal). We designed
the PTS to complement existing systems that track permit activity to avoid
duplicating the efforts of other agencies.
-------
DISCLAIMER
The research described in this manual has been funded wholly or in part by the
U. S. Environmental Protection Agency (EPA) and conducted at EPA's Research
Laboratory in Corvallis, Oregon, through Contract #68-C8-0006 to ManTech
Environmental Technology, Inc.; Interagency Agreement #DW14932030 to U.S. Fish
and Wildlife Service, Laguna Niguel Field Office; Interagency Agreement
#DW12932026 to U.S. Department of Agriculture, Extension Service; Contract
#6Y0718NAEX to the University of Washington; and Interagency Agreement
#DW14932029 to U.S. Fish and Wildlife Service, National Wetlands Research Center,
Corpus Christi Field Station. It has been subjected to the Agency's peer and
administrative review, and it has been approved for publication as an EPA document.
Mention of trade names or commercial products does not constitute endorsement or
recommendation for use.
This document should be cited as:
Holland, C.C. and M.E. Kentula. 1991. The Permit Tracking System (PTS): A User's
Manual. EPA/600/8-91/054. U.S. Environmental Protection Agency,
Environmental Research Laboratory, Corvallis, Oregon.
-------
ACKNOWLEDGEMENTS
The authors want to take this opportunity to acknowledge people from the
Wetlands Research Program who assisted with the project. Eric Preston, the EPA
project officer, was supportive of the effort. Brenda Huntley and JoEllen Honea
entered data into the Permit Tracking System (PTS) and offered suggestions for
improving the software. Donna Frostholm, Stephanie Gwin, Jeannie Sifneos, and
Arthur Sherman assisted with the selection of fields used in the PTS. Rich Sumner
used his marketing skills to track down reviewers for the draft document. Jeannie
Sifneos assisted with the initial software development and computational strategies.
Tina Rohm, ManTech Environmental Technology, Inc., developed an early
version of a data management system that was used as a model for the PTS. Jim
Good, Oregon State University; Kathy Kunz and Michael Rylko, EPA-Region X; Jane
Griffith, formerly with U.S. Fish and Wildlife Service (FWS), Laguna Niguel Field Office;
Sharon Lockhart, formerly with FWS, Laguna Niguel Field Office; Paul Price, Paul
Price Associajes, Inc.; Edwin W. Cake, Gulf Environmental Associates; and Millicent
Quammen, FWS, National Wetlands Research Center, Corpus Christi Field Station,
tested the original data management system and offered suggestions for improving the
software.
We extend special thanks to those who improved this report through their
review of the draft document. Ann Hairston and Deborah Coffey of ManTech
Environmental Technology, Inc. provided editorial and Quality Assurance reviews,
respectively. Jane Epperson, Missouri Department of Natural Resources; Dick Gersib,
Nebraska Game and Parks; and Emily Roth, Oregon Division of State Lands reviewed
the draft and offered valuable comments which clarified and strengthened this manual
and the final version of the software. Ann Redmond, Florida Department of
Environmental Regulation, also provided technical guidance on the software and
manual.
-------
TABLE OF CONTENTS
About the documentation 1
Terms used 1
Overview 3
The Permit Tracking System (PTS) 5
Limitations 6
Getting started 6
Computer features needed to run the PTS 6
Installing the PTS 6
Accessing the PTS 7
The PTS form 9
Overview 11
Information to be recorded on the PTS form 12
Impacted wetland form 12
Compensatory wetland form 18
User defined field form 24
Data entry 27
Accessing the data entry component of the PTS 29
Creating new databases 32
How databases are named in the PTS 32
Steps to creating a database 33
Accessing an existing database 36
The help screen 37
Entering data 38
Highlighted boxes 38
Scroll boxes 41
User defined fields (UDFs) 42
Editing data 43
Changing data 43
Adding data 43
Deleting data 44
Exiting the data entry program 44
Query 45
Accessing the query component of the PTS 47
Look-up tables 49
The menu options 49
Clear. 49
Enter 50
Choosing fields to make up a query 51
Multiple queries 52
Exact queries 57
Moving around the query worksheet 61.
Yes/No and range fields 62
Run 68
Querying by permit versus querying by wetland 69
Generating a detail file 69
Processing the query 70
-------
Filter 70
View 72
Moving around the results worksheet 74
Save 75
Print 76
Quit 78
Supplemental programs 79
Checking for errors 81
Listing contents of fields 82
Generating tables 84
Printing files 88
Literature cited 91
APPENDIX A - The PTS form 93
APPRNDIX B - Definitions of mitigation types 101
APPENDIX C - Screens of the data entry program 105
APPENDIX D - List of codes 119
APPENDIX E - Field descriptions 127
APPENDIX F - Examples of selected queries 131
-------
IMPORTANT:
Several indices were used in the PTS programs. These indices can become
damaged due to power outages, computer failures, etc. You can tell that an index is
damaged if the PTS stops working, or you get an error message similar to the one
depicted below.
Proc TABLE line 47, open error \PTS\RESULTS\RESULTS.NTX (0) Retry? (Y/N)
If you suspect that an index has been damaged;
Type INDEX and press [Enter] from the directory containing the PTS (\PTS).
This process will restore any damaged indices in the PTS.
-------
About the documentation
This manual will guide you through use of the Permit Tracking System (PTS),
explain procedures, and provide examples of the procedures. A few preliminary notes
are made here to direct you to important points in the manual:
• Many examples and illustrations are included in the documentation. If you are
having trouble following the text, look in the figures. Procedures that may be
difficult to understand in verbiage, may be easily comprehended with the use
of a figure.
• A pointing finger (<®-) indicates that directions on what to do at the computer
will follow.
• Commands to type and keys to press will be in bold. For example:
Type cd\PTS and press [Enter]
i®* Press [F10] to exit the PTS
Terms used
Below is a list of terms and documentation conventions we use throughout this
guide.
Code the abbreviation for a value. For example, WILD is the code for
Habitat for wildlife.
Field each category of information. For example, permit number, state, and
wetland functions are field names.
Record all the information that has been entered for a wetland. For example,
if one permit impacted two wetlands and created three wetlands,
there would be a total of five records corresponding to that permit.
Screen the block of information displayed on the computer monitor.
Value the information entered into a field. For example, CA (for California) is
a potential value in the state field.
1
-------
2
-------
OVERVIEW
3
-------
4
-------
The Permit Tracking System (PTS)
A user-friendly data management system called the Permit Tracking System
(PTS), was developed by the Environmental Protection Agency's (EPA) Wetlands
Research Program to simplify the process of entering and analyzing information from
permit records. The PTS is designed to track information from three types of permit
systems, permits issued under Section 404 of the Clean Water Act, Section 401 of the
Clean Water Act, and state authority. There is also an option to track data from other
permit systems.
The PTS is divided into two main components: data entry and query. The PTS
simplifies the process of data entry. In most cases, the user is merely required to
check off items, as opposed to doing a lot of typing. Standardized categories, with
definitions, are given for items, such as Cowardin wetland types (Cowardin et al.
1979), project types, and wetland functions. Selecting items and entering minimal
verbiage eliminates most of the errors typically associated with data entry. The PTS
also contains a program that sorts and prints all the items listed in each category,
making it easy to recognize information that has been entered incorrectly. For
example, if a list of counties contained both CENTER and CENTRE, it would be easy to
recognize that there had been an error in data entry. After data have been entered,
corrections, additions, and deletions can easily be incorporated into the PTS.
The menu-driven query component of the PTS allows the user to generate
questions utilizing the contents of the database. The program identifies all possible
combinations and compiles the answers, which can be viewed on the screen, copied
to disk for conversion to tables and figures, or printed as hardcopy. The PTS not only
eliminates the potential errors inherent to querying in other software packages, but
also substantially reduces the time needed for analyses.
5
-------
Limitations
The PTS is not a statistical package. The query program generates frequency
and area totals, but does not calculate any statistics, such as means or standard
deviations. Since the PTS requires limited knowledge of the database structure,
statistical capabilities were not included, so users could not misinterpret the output. If
you want to perform statistical calculations on data, simply generate the frequencies
and area totals using the PTS, and compute the statistics by hand or use a statistical
software package.
Getting started
Computer features needed to run the PTS
The PTS can be run on any personal computer system that has the following
attributes:
• an IBM PC, XT, or AT, or an IBM compatible computer
• PC-DOS or MS-DOS Version 2.0 or greater
• 512 kilobytes, or more, of available random access memory (RAM)
• 3 megabytes, or more, of available hard disk space
• 20 files and 20 buffers, or more, in CONFIG.SYS file.
Features that are helpful, but not essential, are:
• a color monitor
• a fast hard disk (less than 28 milliseconds average access time)
• a fast processor (for example, a 386).
Installing the PTS
Follow the six steps listed on the following page to install the PTS on your
computer.
6
-------
1) Locate the three PTS diskettes found in the pocket at the back of this
document.
2) Insert PTS diskette # 1 into the A: or B: drive of your computer.
3) Access the hard drive to contain the PTS (e.g., C: or D:).
4) Initiate the installation.
If the PTS diskette is in the A: drive of your computer:
e? Type A:INSTALLA PTS and press [Enter]
If the PTS diskette is in the B: drive of your computer:
¦3s Type B:INSTALLB PTS and press [Enter]
5) Continue with the installation process inserting diskettes # 2-3 when
prompted by the directions on the computer monitor.
6) The PTS is now installed on your computer. Remove PTS diskette # 3 and
return all the diskettes to the pocket.
IMOTE: You may also want to make a back-up of the PTS diskettes to store at a
second location.
Accessing the PTS
¦s* Type PTS and press [Enter] from the directory containing the PTS.
ts* Type Y and press [Enter] to use color, otherwise type N and press [Enter].
The PTS main menu will appear. The various components (e.g., Data Entry, Query,
and Table) of the PTS are discussed in the following sections of this documentation.
Data Entry Summary Check Field Contents Query Table Print Exit
Do you want to use color? (Y)es/(N)o Y
1. Only appears on screens with color monitors.
Enter permit data
The PTS main menu.
7
-------
8
-------
THE PTS FORM
9
-------
10
-------
Overview
The amount of data in permit records can range from files with detailed
environmental impact reports and mitigation plans to those with only the U.S. Army
Corps of Engineers' public notice, environmental assessment, and permit issuance
letter, therefore it is essential that critical information be identified and organized
before it is entered into the PTS. The EPA's Wetlands Research Program created a
form to which key information can be transcribed for input into the data entry
component of the PTS.
The form is divided into two double-sided pages-one for information on
wetlands impacted by a project and a second for information on wetlands designated
as mitigation for the impacted wetlands (referred to as compensatory wetlands). An
optional third page is included so users can tailor the PTS to meet their individual
needs. Appendix A contains the blank PTS forms that can be used to make copies.
Copy the first two pages back to back on one sheet of paper and the second two
pages back to back on a second sheet. Copy the last page on a third sheet, if needed.
A separate form should be used for each wetland involved in a permit and for
each type of compensatory mitigation (i.e., wetland creation, enhancement,
preservation, or restoration) (See Appendix B for definitions of compensatory
mitigation types). For example, if a permit specifies that one wetland will be impacted
by a project, and one wetland will be created and one will be restored as mitigation,
three forms would be required-one impacted and two compensatory forms.
Furthermore, if one permit impacted a palustrine forested wetland on one site and a
palustrine emergent wetland on a different site, two impacted wetland forms should be
used. Information on a wetland that is a complex of patches of two or more wetland
types, however, should be recorded on only one form. Examples illustrating the
number of PTS forms that should be used in various situations are depicted in the
following table.
11
-------
SITUATION
# FORMS
Permit A
1 impacted wetland on site A
1 created wetland on site B
1 restored wetland on site C
1 impacted
2 compensatory
Permit B
1 impacted palustrine forested
wetland on site A
1 impacted palustrine emergent
wetland on site B
2 impacted
Permit C
1 impacted wetland on site A
1 created wetland composed of
patches of palustrine forested and
palustrine emergent wetland on site B
1 impacted
1 compensatory
After information is transcribed onto the PTS forms, it can be entered into the data
entry component of the PTS. The data entry program follows the arrangement of the
data on the forms.
INFORMATION TO BE RECORDED ON THE PTS FORM
The form is divided into several boxes (10 boxes on the impacted form, and 14
boxes on the compensatory form) that contain similar types of information to be
compiled from permit records. This section explains the specific information to be
recorded in each box on the PTS forms. The boxes are described in order starting
from the upper left corner and proceeding from left to right down the page. It might be
helpful to have a form in front of you as you follow the directions listed below.
Impacted wetland form:
Permit number 1
Date permit issued 2
Record the...
1. permit number
2. date the permit was issued - use the convention:
12
-------
Month/Day/Year - the two-digit month and day and the last two digits
of the year, for example, 12/23/87 (for December 23, 1987)
(Use 00 for the year 2000)
State 1 County,
2
Ages 3 .
Acres 5 .
State 4 County.
4
Township & Range
Z
TOTAL_fc
Section(s) Z
Latitude/Longitude
JBL
USGS/NWI map name
£
Scale 1: Q_
10 l >¦ Select[1] Water/river body name
Jfl.
O Water Body
O River Body Specific location
11
Record the ...
1. two-letter abbreviation of the state in which the wetland is located
2. county in which the wetland is located
3. area (in acres) of the wetland in that state and county
4. state abbreviation and/or county name if the wetland lies in more
than one state and/or county
5. area (in acres) of the wetland in the second state and/or county
6'. total area (in acres) of the wetland impacted by the permit - this area
should equal the area entered into 3 + the area entered into 5
7. township, range, and section of the location of the wetland - use the
convention:
Township and Range 2N4W Section(s) 4
8. latitude and longitude of the location of the wetland - use the
convention:
Latitude 33o07"45" Longitude 117°13,30"
9. U.S. Geological Survey topographic map name or the National
Wetlands Inventory map name and scale if one was cited in the
permit record
10. type of hydrologic connection (water body or river body) with which
the wetland is associated, and list its name
11. specific location of the wetland • be as detailed as possible
For example, INTERSECTION OF ZION AVE AND SAN
DIEGO RIVER
13
-------
Land use-S&lect[1]
O Agricultural
O Commercial
1 O Industrial
O Natural
O Residential
Documents available-
Sel&ct[0-4]
O Maps
2 O Blueprints
O Ground photos
O Aerial photos
Date construction began _3
Date construction completed _4
Record the...
1. primary land use in the vicinity of the wetland before the impact
occurred:
Agricultural - land used for producing crops and/or livestock (farming)
Commercial - land occupied by businesses
Industrial - land occupied by manufacturing facilities
Natural - undeveloped land
Residential - land occupied by housing and/or housing units
2. documents available in the permit record
3. date the construction to the impacted wetland began - refer to
comments on date entries at the top of page 13
4. date the construction to the impacted wetland was completed - refer
to comments on date entries at the top of page 13
14
-------
COWARDIN WETLAND TYPE-Se/ecf/J-5/
1
ACRES
ACRES
ACRES
ESTUARINE
RIVERINE
RIVERINE (eont)
0 subMal aquatic bed
2
0
Mai aquatic bed
0 unknown perennial aquatic bed
0 subndal open water
O
tidal beach/bar
0 unknown perennial beach/tar
0 subtldal reet
.
0
bdal emergent
.
0 unknown perennial flat
.
O subttda] rock bottom
0
tidal flat
0 unknown perennial open water
0 subtldal unconsolidated bottom
www
0
tidal open water
~
0 unknown perennial rock bottom
_____
O Intertldal aquatic bed
o
tidal rock bottom
O unknown perennial rocky 6hore
O Intertldal beach/bar
•
0
tfdal rocky shore
0 unknown perennial streambed
, ] »
0 Intertldal emergent
o
tidal stream bed
0 unknown perennial unconsolidated bottom
O Intertldal flat
.
0
tidal unconsolidated bottom
.
0 unknown perennial unconsoBdated shore
,
O Intertldal forested
o
tidal unconsolidated shore
0 Intertldal reef
•
0
lower perennial aquatic bed
'
PALUSTRINE
O Intertldal rocky shore
„
0
lower perennial beach/bar
0 Intertldal scruh/Shrub
0
lower perennial emergent
.
0 aquatic bed
0 Intertldal stream bed
0
lower perennial flat
0 emergent
0 Intertldal unconsoBdated shore
¦
0
lower perennial open water
«
0 flat
0
lower perennial rock bottom
.
O forested
LACUSTRINE
0
lower perennial rocky shore
>
0 moss/lichen
0
lower perennial stream bed
0 open water
0 limnetic aquatic bed
0
lower perennial unconsolidated bottom
0 rock bottom
0 limnelc open water
0
lower perennial unconsolidated shore
0 scrub/shrub
0 limnetic rock bottom
0
upper perennial aquatic bed
»
0 unconsolidated bottom
0 limnetic unconsolidated bottom
0
upper perennial beach/bar
0 unconsolidated shore
0 littoral aquatic bed
o
upper perennial flat
______
MARINE
O littoral beach/bar
0
upper perennial open water
O littoral emergent
.
0
upper perennial rock bottom
O subtldal aquatic bed
0 littoral flat
0
upper perennial rocky shore
0 subtidal open water
O littoral open water
o
upper perennial streambed
O subtldal reef
0 littoral rock bottom
0
upper perennial unconsolidated bottom
0 subtldal rock bottom
0 littoral rocky shore
0
upper perennial unconsolidated shore
_____
O subtidal unconsolidated bottom
.
0 littoral unconsolidated bottom
0
intermittent aquatic bed
0 intertldal aquatic bed
O littoral unconsolidated shore
o
Intermittent beechAnr
_____ __
O intertidaJ beach/bar
0
Intermittent flat
0 intertldal (tat
o
Intermittent open water
0 Intertldal reef
0
Intermittent rock bottom
____
0 intertldal rocky shore
0
Intermittent rocky shore
0 mtertldal unconsolidated shore
o
Intermittent streambed
Intermittent unconsolidated bottom
0
TOTAL AREA
2
1. Select up to five wetland types that may comprise the impacted
wetland (see Cowardin et al. 1979 for definitions of the wetland
types).
2. Specify the area (in acres) for each wetland type selected.
3. Record the total area (in acres) for all the wetland types - NOTE: this
area should equal the area recorded in the box depicted on page 13,
Number 6.
15
-------
Continuing on the back of the impacted wetland form:
T*PE OF
0 Airport
0 Hydroelectric project
0 Recrealional area
O Aquacullure
O Industrial park
0 Shipping wharf, dock, or pier
0 Boat ramp
O Jetty or groin
O Shore stabilization
0 Commercial project
0 Mama
0 Solid waste disposal
0 Dam or reservoir
0 Mming
0 Stream modification
0 Dike placement
0 Mosquito abatement
0 Tide gate
O Drainage ditch
0 Navigation channel, cannel, etc
0 Utility
0 Dredge disposal
0 09 & gas activities
0 Well drilling pad
O Dredging
0 Other
0 Wildlife habitat
O Farming activity
0 Ppebne
0 Highway, road, or bndge
0 Private dock or moorage
0 Housing development
0 Railroad
Select up to three types of projects that impacted the wetland as a result of
the permit.
FUNCTION-Sefecl [1-S]
0
Active recreation
0
Consumptive recreation
0
Flood storage
0
Food chain support
0
Ground water modification
0
Habitat for endangered species
o
Habitat for fisheries
0
Habitat for wildlife
0
Non-consumptive recreation
0
Nutrient retention and removal
0
Other
0
Passive recreation
0
Sediment trapping
0
Shoreline stabilization
o
Uniqueness or rareness
Select up to five functions the wetland performed before it was impacted.
16
-------
ENDANGERED SPECIES
1.
Scientific name
Common name
2.
Scientific name
Common name
3.
Scientific name
Common name
If Habitat for endangered species was selected in the previous box, record the
scientific and common names of up to three endangered species that were
affected by the impact to the wetland.
REPORT ireQRMATtON
Tale 1
Author's First Initial 2 Middle Initial 2 Last Name 2
Year 3 Source 4
Content 5
Record the...
1. title of the principal report listed in the permit record (e.g., mitigation
report or Environmental Impact Statement)
2. first initial, middle initial, and last name of the first author
3. year the report was published
4. source where the report can be located
5. content of the report
CONTACT INFORMATION
First Initial 1
Middle Initial 1
Last Name
1
Organization
2
Address
3
City 3
State
3 Zd 3 Phone (
)
3
Record the ...
1. first initial, middle initial, and last name of the principal contact for the
project
17
-------
2. organization with which the contact is affiliated
3. address and phone number of the contact's organization
COMMENTS
Record any additional comments pertinent to the permit.
Compensatory wetland form:
Permit number, 1
Date permit issued 2 / /
Record the ...
1. permit number
2. date the permit was issued - use the convention:
Month/Day/Year - the two-digit month and day and the last two digits
of the year, for example, 12/23/87 (for December 23, 1987)
(Use 00 for the year 2000)
Mitigation Bank?
X
Yes-
Name of bank 2
Money or land? 3
STOP HERE
COMPLETE REST OF FORM
1. Specify if the compensatory wetland was a mitigation bank by circling
Yes or No.
2. Record the name of the mitigation bank.
3. Specify if the mitigation bank was an in-lieu fee program (Money) or
a large wetland area created or restored prior to development (Land)
- circle the appropriate response.
Mitigation type~Select[1]
0 Created O Enhanced O Preserved O Restored
Select the type of compensatory mitigation specified in the permit.
18
-------
State 1 County
2
Acres
3 .
State 4 County
4
Acres
5 .
TOTAL
6 .
Township & Ranae
7
Section(s)
7
Latitude/Lonaitude
8
USGS/NWI mao name
9
Scale 1:
9
!~ Select [1]
Water/river body name
10
O Water Body
0 River Body
SDecific location
11
Record the...
1. two-letter abbreviation of the state in which the wetland is located
2. county in which the wetland is located
3. area (in acres) of the wetland in that state and county
4. state abbreviation and/or county name if the wetland lies in more
than one state and/or county
5. area (in acres) of the wetland in the second state and/or county
6. total area (in acres) of the compensatory wetland - this area
should equal the area entered into 3 + the area entered into 5.
7. township, range, and section of the location of the wetland - use the
convention:
Township and Range 2N4W Section(s) 4
8. latitude and longitude of the location of the wetland - use the
convention:
Latitude 33°07'45M Longitude 117°13'30M
9. U.S. Geological Survey topographic map name or the National
Wetlands Inventory map name and scale if one was cited in the
permit record
10. type of hydrologic connection (water body or river body) with which
the wetland is associated, and list its name
11. specific location of the wetland - be as detailed as possible
For example, INTERSECTION OF ZION AVE AND SAN
DIEGO RIVER
19
-------
O Agricultural
O Commercial
2 O Industrial
O Natural
O Residential
Land use-Select[1]
Documents available-
Select[0-4]
O Maps
3 O Blueprints
O Ground photos
O Aerial photos
Were mid-course corrections made? Yes / No 6
(Make notes in comments section)
Was the mitigation project Off-site or On-site? 1
Date construction began
Date construction completed 5 / /
Specify.
1.
2.
3.
4.
5.
6.
if the compensatory wetland occurred on the same site as the
impacted wetland (On-site) or a different site from the impacted
wetland (Off-site) by circling the appropriate response
the primary use of the land before the mitigation project was
constructed:
Agricultural - land used for producing crops and/or livestock (farming)
Commercial - land occupied by businesses
Industrial - land occupied by manufacturing facilities
Natural - undeveloped land
Residential - land occupied by housing and/or housing units
the documents available in the permit record
the date the construction to the compensatory wetland began - refer
to comments on date entries at the top of page 13
the date the construction to the compensatory wetland was
completed - refer to comments on date entries at the top of page 13
if adjustments were made to the project once construction was
underway
20
-------
COWARDIN WETLAND T¥PE-So#«*/J-5J
1
ACRES
ACRES
ACRES
ESTUAHINE
RIVERINE
RIVERINE (eont)
0 subada! aquatic ted
_2_-_
O
Ma! aquatic bed
.
O unknown perennial aquallc bed
0 subtidal open water
0
Ida! beach/bar
O unknown perennial beech/bar
0 subtidal reef
.
O
tidal emergen!
O unknown perennial flat
...
0 subtidal rock bottom
0
tidal flat
O unknown perennial open water
0 subtidal unconsolidated bottom
o
tidal open water
O tmknown perennial rock bottom
0 Interuda' aquatic bed
0
tidal nxk botiom
___
0 unknown perennial rocky shore
0 Intertidal beach/bar
-
0
tidal rocky shore
•
0 unknown perennial streambed
.
0 Imertdal emerge nl
0
tidal streambed
0 unknown perennial unconsolidated bottom
O Intertidal flat
.
0
(da) unconsolidated bottom
.
0 unknown perennial unconsolidated shore
..
0 Intertdal forestad
0
tidal unconsolidated shore
0 Intemdat reef
—<—
o
tower perennial aqua fee bed
¦
PM.UST8INE
0 Imertdal rocly shore
o
tower perennial beach/bar
0 imertdal tcrubtehrub
o
lower perennial emergent
O aquatic bed
0 Imertdal streambed
o
lower perennial flat
0 emergen!
0 Intertidal u neons ofida ted shore
.
o
lower perennial open water
.
0 Hat
0
lower perennial rock bottom
O forested
LACUSTRINE
o
lower perennial rocky shore
O moGS/lichen
o
lower perennial streambed
O open water
0 limnetic aquatic bed
o
lower perennial unconsolidated bottom
O rock bottom
0 limnetic open water
o
lower perennial unconsolidated shore
O scrubAhrub
0 limnetic rock bottom
o
upper perennial aquatic bed
O unconsolidated bottom
0 limnetic unconsolidated bottom
0
upper perennial beachybar
0 unconsolidated shore
O littoral aquatic bed
o
upper perennial flat
MARINE
O littoral beach/bar
0
upper perennial open water
0 littoral emergent
*
o
upper perennial rock bottom
.
O subtldal aquatic bed
0 littoral flal
0
upper perennial rocky shore
0 subudal open water
0 littoral open water
.
0
upper perennial streambed
0 subtidal reef
0 littoral rock bottom
0
upper perennial unconsolidated bottom
0 subtidal rock bottom
0 littoral rocky shore
¦
0
upper perennial unconsolidated shore
0 subtidal unconsolidated bottom
0 littoral unconsolidated bottom
o
Intermittent aquatic bed
0 IntertiCal equate bed
O Ihtoral unconsolidated shore
o
Internment beach/bar
¦
O tntertldaJ beach/bar
0
Intermittent flat
0 tntertldal flat
0
intermittent open water
.
0 miertkJal reef
0
Internment rock bottom
0 Inlertidal rocky shore
o
Intermittent rocky shore
.
0 Intertldal unconsolidated shore
Q
Intermittent streambed
Intermittent unconsolidated bottom
o
TOTAL AREA
a
1. Select up to five wetland types that may comprise the compensatory
wetland (see Cowardin et al. 1979 for definitions of wetland types).
2. Specify the area (in acres) for each wetland type selected.
3. Record the total area (in acres) for all the wetland types - NOTE: this
area should equal the area recorded in the box depicted on page 13,
Number 6.
21
-------
Continuing on the back of the compensatory wetland form:
OBJECnVE-Setecf/J-3/
O
1:1 Functional replacement
0
Active recreation
0
Consumptive recreation
0
Flood storage
0
Food chain support
0
Ground water modification
0
Habitat for endangered species
0
Habitat for fisheries
0
Habitat for wildlife
0
Mosquito abatement
0
Non-consumptive recreation
0
Nursery for mitigation plants
0
Nutrient retention and removal
0
Other
o
Passive recreation
0
Research
0
Sediment trapping
0
Shoreline stabilization
0
Unique systems replacement
0
Uniqueness or rareness
Select up to three objectives of the compensatory wetland.
ENDANGERED SPECIES
1
Scientific name
Common name
2.
Scientific name
Common name
3.
Scientific name
Common name
If Habitat for endangered species was selected in the previous box, record the
scientific and common names of up to three endangered species for which the
compensatory wetland was designed to create habitat.
22
-------
UEmOO~Sebcti1'3}
O Abalone planting
0 Other
0 Channels cut
0 Planting
0 Dike breaching
0 Preservations
0 Establish proper hydrology
0 Seeding
O Excavation
0 Soil enhancement
0 Fencing
0 Upstream flows
o nil
0 Wave protection
O Grading
0 Natural regrowth
Select up to three construction methods used for the compensatory wetland.
,NFORMATJON on MOhBTOfltNG "™""™
1 Do construction plans exist7 Yes / No
2 Were checks made regularly? Yes / No 2 irregularly? Yes / No
3 Were data collected? Yes / No
Specify whether or not...
1. construction plans, describing the wetland, as built, exist
2. post-construction assessments were made of the wetland on a
regular or irregular basis
3. data were collected during post-construction visits
ITEMS MONITOREDSetect [1-3]
0 Animal density
0 Plant diversity
O Animal diversity
0 Primary production
O Animal use
0 Secondary production
0 Endangered species
0 Vegetative cover
O Other
0 Water quality
0 Physical viability
0 Water table depth
Select up to three parameters monitored during post-construction visits to
the compensatory wetland.
REPORT IWORMATWW
Tate 1
Author's First Initial 2 Middle Initial 2
Last Name 2
Year 3 Source 4
Content 5
23
-------
Record the...
1. title of the principal report listed in the permit record (e.g., mitigation
report or Environmental Impact Statement)
2. first initial, middle initial, and last name of the first author
3. year the report was published
4. source where the report can be located
5. content of the report
CONTACT INFORMATION
First Initial 1
Middle Initial 1
Last Name
1
Organization
2
Address
3
City 3
State
3 Zc 3 Phone ( )
3
Record the...
1. first initial, middle initial, and last name of the principal contact for the
project
2. organization with which the contact is affiliated
3. address and phone number of the contact's organization
COMMENTS
Record any additional comments pertinent to the permit.
User defined field (udf) form (see pages 42-43 for information on udfs):
DATE FIELDS
FIELD NAME
DESCRIPTION
DATE
UDF DATE1
/ /
UDF DATE2 _
/ /
IJDF DATES
/ /
24
-------
Record up to three dates that you want to track. Remember to specify what
each date represents under the DESCRIPTION column.
NUMERIC FIELDS
FIELD NAME
DESCRIPTION NUMBER
HPF N"M1
IIPF N"M?
i inF Ml IMS
Record up to three numbers that you want to track. Remember to specify what
each number represents under the DESCRIPTION column.
YES OR NO FIELDS
FIELD NAME DESCRIPTION
YES OR NO
IJDF YN1
Yes/No
IJDF YN?
Yes/No
IJDF YN3
Yes/No
IJDF YN4
Yes/No
Record information for up to four "yes or no" questions. Remember to record
each question under the DESCRIPTION column.
25
-------
CHARACTER FIELDS
FIELD NAME
DESCRIPTION
CHARACTERS
UDF CHAR1
(«5 rharartor ma*imnm)
UDF CHAR2
UDF CHAR3
MO maximum)
UDF CHAR4
UDF CHAR5
(30 maximum)
UDF CHAR6
Record information (in letters or numbers) that you want to track in up to four of
the blanks. Remember to specify what the data represents under the
DESCRIPTION column.
26
-------
DATA ENTRY
27
-------
28
-------
ACCESSING THE DATA ENTRY COMPONENT OF THE PTS
After the PTS has been installed on your computer (see page 6), you can
access the data entry program two ways: by entering the PTS and accessing the data
entry program through the PTS main menu, or by directly accessing the data entry
program from the directory containing the PTS.
To access the data entry program from the PTS main menu:
1) Access the PTS
Type PTS and press [Enter] from the directory containing the PTS.
2) Access the data entry program
Data Entry Summary Check Field Contents Query Table Print Exit
Enter permit data
»• -v ' /m » % ¦¦ ,f ttft v
Position the highlighted box over DATA ENTRY and press [Enter], OR
press D.
To access the data entry program from the directory containing the PTS, follow the
directions outlined on the following page.
29
-------
SCREEN
DIRECTION
EXAMPLE
c
C:\>
2>
C
C:\PTS>
J
Do you want to use color?
D'
Access directory
containing the PTS
Access the data entry
component of the PTS
Answer question
P T
¦ ermrt S i
racking ystem
Wetlands Research Program,
U S Environmental Protection Agency,
Environmental Research Laboratory
Corvallis, Oregon 97333
Press any key to continue |~
+ Type cd\PTS and
press [Enter]
+ Type ENTER
and press [Enter]
+ Type Y and press
[Enter] to use color,
otherwise type N
and press [Enter]
+ Press [Enter]
NOTES: 1. Only appears on screens with color monitors.
Two options are available to you after you have entered the data entry program:
• create a new database and enter data into that database, or
• modify an existing database by adding data, making corrections, or deleting
data.
The following flowchart illustrates the options available for creating or selecting a
/ \
database in the PTS. Each v.
J represents a different data entry screen.
30
-------
Select a database type and press [Enter]
404 Permit
401 Permit
State Permit
Other
Exit
Select an existing database and press [Enter], or
press [Esc] to create a new database
CA404.DBF
OR404 DBF
9
No databases were found that matched
the permit type you requested. Do vou
want to create a new database' [Vj
YES
~7$
The selected database
(e g , CA404 DBF)
will appear.
The main menu
will appear.
[Exit
Select the type of database
to create and press [Enter]
404 Permit
401 Permit
State Permit
Other
Exit
i r [Enter]
NO
Enter the two letter state abbreviation ~
Enter a suffix (OPTIONAL) ~
The created database
(e g., GA404.DBF)
will appear. —
_YESU
Example: If state is Georgia,
enter GA as state abbreviation.
Is everything correct? [RJ
)no-
31
-------
Creating new databases
How databases are named in the PTS
A new database should be created for each unit of data you wish to track (for
example, the Section 404 permits issued in Oregon). All databases created in the
PTS will have a .dbf extension. DO NOT CHANGE THE .DBF EXTENSION. It is
necessary for both the data entry and the query programs to recognize databases
used with the PTS. Furthermore, a suffix will be automatically assigned to each
database depending upon which permit system was selected for that database. The
four possible suffixes are:
• 404.dbf corresponding to Section 404 permits
• 401 .dbf corresponding to Section 401 permits
• ST.dbf corresponding to state permits
• OTH.dbf corresponding to any other permit systems
This suffix is automatically assigned to the database in response to your choice in the
selection box illustrated below.
Select the type of database
to create and press [Enter]
404 Permit
401 Permit
State Permit
Other
Exit
You can further tailor the name for the database by using the options displayed in a
box that appears during the start-up to the data entry program.
I Enter the two letter state abbreviation
I Enter a three letter suffix (OPTIONAL) ~
32
-------
Using the first option, the second unit in the name of a database created in the PTS
becomes the two-letter state abbreviation. In addition, an optional, three-character
maximum code can be assigned to the database name. Both of these forms of
identification are assigned by you and are then combined with the initial database type
(e.g., 404, 401, state, other) to comprise the database name. An example database
name divided into its four components is:
OR401ONE.DBF
1 2 4
1. The two-letter abbreviation for Oregon
2. The permit type (Section 401 permits)
3. The optional suffix
4. The extension assigned by the PTS
Therefore, possible database names include:
CA404.DBF for Section 404 permits issued in California
CA404ONE.DBF for subset ONE of the Section 404 permits issued in California
CA401 .DBF for Section 401 permits issued in California
TXST.DBF for state permits issued in Texas
TXST1 .DBF for subset 1 of the state permits issued in Texas
Steps to creating a database
To create a database, follow the steps listed on the follow page in response to
the screens illustrated.
33
-------
Select a database type and press [Enter]
404 Permit
401 Permit
State Permit
Other
Exit
Position the highlighted box over the type of permit you want to create the
database to track and press [Enter].
If at least one database of the specified type exists the following screen
will appear that lists the names of all the existing databases of the
specified type.
CA404.DBF
OR404.DBF
Press [Esc].
Select the type of database
to create and press [Enter]
404 Permit
401 Permit
State Permit
Other
Exit
Position the highlighted box over the permit type for the database you want to
create and press [Enter].
34
-------
Enter the two letter state abbreviation ~
Enter a suffix (OPTIONAL) ~
y
ra* Enter the two-letter abbreviation for the state in which the permits were issued.
er OPTIONAL: Enter a suffix (3 character maximum) if you want to expand the
name further for purposes of identification. This is another way to name the
database you are creating.
ear Enter Y and press [Enter] if all the information is correct.
is* Enter N and press [Enter] if you need to correct the information entered above.
The program will now access the database you created.
If no databases of the specified type exist the following screens will
appear:
«sr Enter the two-letter abbreviation for the state in which the permits were issued.
OPTIONAL: Enter a suffix (3 character maximum) if you want to expand the
name further for purposes of identification. This is another way to name the
database you are creating.
Is everything correct? [N]
No databases were found that matched
the permit type you requested. Do vou
want to create a new database? fYf
Enter Y and press [Enter].
Enter the two letter state abbreviation ~
Enter a suffix (OPTIONAL) ~
35
-------
f | Is ev<
V
Is everything correct? [N]
B5>
Enter Y and press [Enter] if all the information is correct.
Enter N and press [Enter] if you need to correct the information entered above.
The program will now access the database you created.
Accessing an existing database
To access an existing database, follow the steps listed below in response to the
screens illustrated.
Select a database type and press [Enter]
404 Permit
401 Permit
State Permit
Other
Exit
«®" Position the highlighted box over the permit type for the database you want to
access and press [Enter],
A list of all the names of existing databases of the specified type will appear.
Select an existing database and press [Enter], or
press [Esc] to create a new database
CA404.DBF
OR404.DBF
B3-
The
Position the highlighted box over the database to access and press [Enter],
program will now access the database you specified.
36
-------
The help screen
The help screen appears at the top of every screen in the data entry program. It
lists the keys that perform certain functions within the data entry program.
¦[Record no. ==> 1
Status =
Y
[F2]
= Search for value
[Ctrl] + [Pg Up]
= Previous record
[F3]
= Find next value
[Ctrl] + [PgDn]
= Next record
[F7]
Delete/restore record
[Ctrl] + [End]
Go to last record
[Pg Up]
= Previous screen
[Ctrl] + [Home]
Go to first record
[Pg Dn]
= Next screen
[F10]
= Exit the program
.[Filename: CA404.DBF].
Explanations of the functions from the help screen menu of the data entry component
of the Permit Tracking System are listed below.
PRESS
IN ORDER TO
[F2]
[F3]
[FT]
[Pg Up]
[Pg Dn]
[Ctrl] & [Pg Up]
[Ctrl] & [Pg Dn]
[Ctrl] & [End]1
[Ctrl] & [Home]
[F10]
1
Search for a specified value in a field.
Advance to the next record with the value specified by the F2 function.
Delete the entire record from the database. Although the record will still
appear on the screen, the record will be deleted when the program is exited.
Press F7 again, before exiting the program, to restore the record
Shift to the previous screen.
Advance to the next screen
Shift to the first screen of the preceding record
Advance to the first screen of the next record.
Advance to the last record in the database
Shift to the first record in the database.
Exit the data entry program and return to the operating system.
1The two keys should be pressed simultaneously for the four functions listing the [Ctrl]
key.
37
-------
Entering data
After you have created a database, you are ready to start entering data. There
are two ways to enter information into the PTS-type data into highlighted boxes and
select items in scroll boxes. The screens, as they appear in the data entry program,
are illustrated in Appendix C.
Highlighted boxes
Highlighted boxes are the spaces in which you enter information into the
database. The table on the next page lists the maximum number of characters or
numbers each of the 54 highlighted boxes in the data entry program can contain.
Important points about the highlighted boxes are discussed below.
• A flashing cursor will appear at the beginning of the highlighted box to be
used.
t
Flashing cursor
• All information entered into highlighted boxes is automatically converted
to capital letters.
• Once you have entered the maximum number of characters for the
highlighted box, the flashing cursor will move to the next box.
• Press [Enter] or the down arrow to move the cursor to the next box, if
the maximum number of characters was not entered into the box.
• Press the up arrow to move the cursor to the previous box.
• For those questions that give you a choice of responses you must
enter one of the choices in parentheses into the highlighted box.
Examples include:
Impacted wetland? (Y)es/(N)o
Was the mitigation project (OFF)-site or (ON)-site?
(C)reated/(E)nhanced/(P)reserved/(R)estored
38
-------
HIGHLIGHTED BOX
MAXIMUM #
CHARACTERS
Permit number
15
Date permit issued
6
Impacted wetland?
1
Impacted
1
Created/enhanced/preserved/restored
1
Mitigation bank
1
Bank name
20
Money/land
1
State (2)
2
County (2)
15
Area (2)
6
Township/range
7
Sections
7
Latitude
7
Longitude
8
Map name
20
Map scale
5
Water body type
1
Water body name
20
Specific location
70
Off-site/on-site
3
Land use
1
Maps
1
Blueprints
1
Ground photos
1
Aerial photos
1
Date construction began
6
Date construction completed
6
Mid-course corrections
1
Endangered spedes-scientific(3)
40
Endangered spedes-common(3)
40
Report title
50
Author's intials
2
Author's last name
25
Year
4
Source
30
Content
50
Contact's initials
30
Contact's last name
50
Organization
30
Address
20
City
2
State
10
Phone number
13
As-built
1
Check-regular
1
Check-irregular
1
Data collected
1
User defined field-date
6
User defined field-numeric
5
User defined field-yes/no
1
User defined field-character
2@5,2@10, 2@3C
39
-------
• You can leave most of the highlighted boxes blank, if you do not know
the information. The exceptions to this are:
Permit number
Date permit issued
Impacted wetland? (Y)es/(N)o
Mitigation bank? (Y)es/(N)o
(l)mpacted (if you answered Yes to impacted wetland? (Y)es/(N)o,
then there will be an I in the (l)mpacted highlighted box)
(C)reated/(E)nhanced/(P)reserved/(R)estored
You must answer the questions listed above for the program to proceed.
• Do not enter commas into the area boxes.
WRONG: 1,345 acres
RIGHT: 1345 acres
• Do not enter symbols (°,H) into the Latitude and Longitude boxes.
WRONG: 117°20'4S"
RIGHT: 1172045
• The state and/or county entered for the first record can be transferred to
following records. A screen similar to the one illustrated below (with the
state and county entered for the previous record) will appear after each
record.
Press [Spacebar] to change values.
Press any other key to continue.
r-[Press [Enter] to continue.]—
STATE: OR
COUNTY: BENTON
¦sr To change the state and/or county defaults:
1) Press the spacebar,
2) Edit the data,
3) Press [Enter].
4) The next record will appear.
ra" To keep the state and/or county defaults:
1) Press any key.
2) The next record will appear.
40
-------
C AUTDODSd: If you change your response to Impacted wetland? (Y)es/(N)o or
Mitigation bank? (Y)es/(N)o, all the information previously entered for
that record will be deleted.
Scroll boxes
A scroll box contains a list of items that can be selected for a given category.
Six scroll boxes are found in the data entry program. A limited number of items can be
selected in each scroll box.
SCROLL BOX # ITEMS
Cowardin wetland types 5
Project types 3
Functions 5
Objectives 3
Methods 3
Items monitored 3
Selecting items in scroll boxes
ra* To select an item in a scroll box, press [Enter] over the CODE or the
FULLNAME of the item. A check will appear in the SELECTED column if an
item has been selected. Use the up and down arrows to position the cursor
over the desired CODE or FULLNAME.
<»" To deselect an item, press [Enter] again over the CODE or the FULLNAME.
The check will disappear to signify the item has been deselected.
41
-------
CODE FULLNAME SELECTED
FUNC
1:1 FUNCTIONAL REPLACEMENT
ACTV
ACTIVE RECREATION
CONS
CONSUMPTIVE RECREATION
FLOD
FLOOD STORAGE
FOOD
FOOD CHAIN SUPPORT
GRWT
GROUND WATER MODIFICATION
4
ENDS
HABITAT FOR ENDANGERED SPECIES
FISH
HABITAT FOR FISHERIES
4
WILD
HABITAT FOR WILDLIFE
NONC
NON-CONSUMPTIVE RECREATION
NURS
NURSERY FOR MITIGATION PLANTS
w
An example of the OBJECTIVE scroll box from the data entry program. Ground
water modification and Habitat for fisheries are selected in this example.
After you have selected the desired items in a scroll box, press [Pg Dn] (page
down) to move to the next screen.
User defined fields (UDFs)
The last screen in the data entry program for both impacted and compensatory
wetlands contains user defined fields (UDFs). These fields were included so users
can tailor the PTS to meet their individual needs. If information you wish to track is not
included in the PTS, simply assign the information to one of the appropriate UDFs. For
example, if you wanted to track the dates permits expired, you would set UDF_DATE1
= Date permit expires. Transcribe data for the dates permits expire onto the UDF form
(see Appendix A) then enter the data into the data entry component of the PTS. The
following table contains information on user defined fields.
42
-------
# OF FIELDS TYPE FIELD NAME FIELD LENGTH
3
Date
UDF_DATE
6
3
Numeric
UDF_NUM
5
4
Yes or no
UDF_YN
1
2
Character
UDF_CHAR
5
2
Character
UDF_CHAR
10
2
Character
UDF CHAR
30
EDITING DATA
Changing data
To change information previously entered into a database:
1) access the appropriate database
2) move to the screen with the information to change
3} position the cursor in the highlighted box and correct the data, OH
3) move the cursor to the appropriate scroll box, and select or
deselect the item to be corrected
4) When you exit the program, the corrections to the database will be
saved.
REMINDER: If you change your response to Impacted wetland? (Y)es/(N)o or
Mitigation bank? (Y)es/(N)o, all the information previously entered for
that record will be deleted.
Adding data
To add additional permits to an existing database:
1) access the appropriate database
2) press [Ctrl] and [End] simultaneously to advance to the last
record in the database
3) press [Ctrl] and [Pg Dn] simultaneously to bring up the first data
entry screen for the new permit
43
-------
4) enter the information for the new permits
To add information to records in an existing database:
1) access the appropriate database
2) move to the appropriate record
3) move to the screen with the information to add
4) add the desired information
Deleting data
To delete an entire record from a database:
1) access the appropriate database
2) move to the record to delete
3) press [F7] to delete the record
4) the word "DELETED" will appear after Status in the upper right
corner of the help screen
[ Record no. ==> 1 Status = DELETED ]
To delete information from a database:
1) access the appropriate database
2) move to the screen with the information to delete
3) delete the desired information
EXITING THE DATA ENTRY PROGRAM
«»¦ Press F10 then Y to exit the data entry program and return to the PTS main
menu.
44
-------
QUERY
45
-------
46
-------
ACCESSING THE QUERY COMPONENT OF THE PTS
You can access the query program two ways: enter the PTS and access the
query program through the PTS main menu, or directly access the query program from
the directory containing the PTS.
To access the query program from the PTS main menu:
«®* Type PTS and press [Enter] from the directory containing the PTS.
Data Entry Summary Check Field Contents Query Table Print Exit
Analyze a database
Position the highlighted box over QUERY and press [Enter], OR press
Q.
P T
B ermit I i
racking ^pPystem
Wetlands Research Program,
U S Environmental Protection Agency,
Environmental Research Laboratory
Corvallis, Oregon 97333
-| Press any key to continue ["
«®" Press any key.
Select a database type and press [Enter]
404 Permit
401 Permit
State Permit
Other
Exit
47
-------
Position the highlighted box over the permit type of the database to query and
press [Enter].
Select an existing database and press [Enter]
CA404,DBF
OR404.DBF
Position the highlighted box over the database to query and press [Enter],
The Creating Look-up Tables box will appear if look-up tables need to be updated.
The section immediately following discusses look-up tables.
I Creating Look-up Tables
The query menu will appear after the Creating Look-up Tables box.
Clear Enter Run Filter View Save Print Quit
Clear the query worksheet
To access the query program from the directory containing the PTS:
Type QUERY and press [Enter] from the directory containing the PTS and
follow the steps listed above.
The query program has eight features. Brief explanations of the features are listed in
the following table. The features are also discussed in more detail in the following
sections of this manual.
48
-------
SELECT
IN ORDER TO
Clear
Enter
Run
Filter
View
Save
Print
Quit
Clear the query worksheet
Select fields to be used in a query
Process the query
Remove all totals with counts equal to zero
View the results of a query
Save the results to a file
Print the query results
Exit the query program
LOOK-UP TABLES
Look-up tables are files used to store all the entries in a database. Every time
you change a database in the data entry program, the look-up table will change. The
query program automatically updates look-up tables the first time a database is used
with the query program and after changes are made to a database. After you have
specified the database to be used with the query program, the box shown below will
appear if the look-up table needs to be updated. If the database was not altered and
was the last database used with the query program, the box will not appear. The
process of creating look-up tables takes from 30 seconds to several minutes
depending on the size of the database and the speed of your computer.
Creating Look-up Tables
The menu options
Clear
Clear Enter Run Filter View Save Print Quit
Clear the query worksheet
49
-------
Position the'highlighted box over CLEAR and press [Enter], OR press C.
This option will clear the specifications for the query previously processed. Clear the
query worksheet before you begin the query process or before you enter a series of
similar queries.
Enter
Clear Enter Run Filter View Save Print Quit
Select fields to be used in a query
i®* Position the highlighted box over ENTER and press [Enter], OR press E.
A table containing all the field names followed by short descriptions will appear (see
the following figure). Use this table to complete the first step in the query process-
selecting the fields for a query (see Appendix E for descriptions of field names).
50
-------
Choosing fields to make up a query
I SELECTED
QRY_FIELD
F
PERMIT
Permit number
F
F
DATE ISS
I
Date permit was issued
Impacted wetland?
F
CASE
Type of compensatory mitigation
F
COMP MIT
Permits requiring compensatory mitigation
F
MIT BANK
Mitigation bank?
F
BANK NAME
Name of mitigation bank
F
MONEY LAND
Mitigation bank involved money or land?
F
STATE
State in which wetland is located
F
COUNTY
County in which wetland is located
F
AREA
Total area of the wetland
F
TOWN RANG
Township and range
F
SECTIONS
Sections
F
LAT LONG
Latitude and longitude
F
MAPNAME
USGS or NWI map name
F
SCALE
Scale of map
M [=>]
Press [Enter] to select/deselect the fields to be used THEN
Press [Esc] to continue.
QRY_FIELD stands for query field name.
Use the up and down arrow keys to position the highlighted box over the field
name (under the QRY_FIELD column) or the corresponding F (under the
SELECTED column and press [Enter] to select a field to be used for a query.
The F corresponding to that field will change to a T indicating the field has been
selected.
Press [Enter] again over the field name or the corresponding T to deselect a
field. The T will change to a F indicating the field has been deselected.
For example, if you wanted to answer the question, "What project types were listed as
impacting the most wetlands?", you would select the CASE and PROJECT fields for
that query.
51
-------
NOTE: We suggest that no more than five fields are used for each query, since it is
difficult to make sense of the results from overly complex queries.
bp After you have selected the fields to be used in a query, press [Esc] to continue.
The next table that appears allows you to refine the query specifications. This query
worksheet displays the fields selected for the query.
CASE_TF
CASE PROJECTJF
PROJECT
I F
F
F
CREATED F
AIRPORT
F
ENHANCED F
AQUACULTURE
F
IMPACTED F
BOAT RAMP
F
PRESERVED F
COMMERCIAL PROJECT
F
RESTORED F
DAM OR RESERVOIR
F
F
DIKE PLACEMENT
F
F
DRAINAGE DITCH
F
F
DREDGE DISPOSAL
F
F
DREDGING
Ill] M
Press [Enter] to select/deselect Items. Press [Enter] over the empty box
in the 1st row to select ALL the items in that column. Press [Esc] to continue.
The CASE and PROJECT fields are selected for the query illustrated in the query
worksheet above.
Multiple queries
The following sections on Multiple and Exact queries are probably the most
confusing sections in this manual. However, It is extremely important that you
understand these sections, so that you understand the results generated by the query.
52
-------
Several fields have the word MULTIPLE following the field description (for
example, the WET_TYPE, PROJECT, and FUNCTION fields shown below).
1 SELECTED QRY_FIELD
F
WETJYPE : Wetland type (MULTIPLE)
F
WA : Area of each wetland type
F
PROJECT : Project types (MULTIPLE)
F
FUNCTION : Functions of the impacted wetland (MULTIPLE)
These are the fields that also appeared in the scroll boxes in the data entry program.
Recall that you can select more than one item for the fields in the scroll boxes. For
example, since you select PROJECTS in a scroll box in the data entry program, the
PROJECT field name is followed by the word MULTIPLE in the query program. A list of
the fields that are followed by the word MULTIPLE in the query program (or those that
appeared in scroll boxes in the data entry program) and the number of items that can
be selected in each field appears below.
SCROLL BOXES # ITEMS
Cowardin wetland types 5
Project types 3
Functions 5
Objectives 3
Methods 3
Items monitored 3
If you select one of the fields listed above for use in a query the following box will
appear.
53
-------
MULTIPLE? N
This box is asking if you want to process a multiple query. Multiple queries
generate and query for all the different combinations of entries in that field. For
example, if three objectives, ENDS (Habitat for endangered species), FOOD (Food
chain support), and WILD (Habitat for wildlife), were entered in the Objective field in a
database, a multiple query would query for the seven possibilities listed in the first
column of the table illustrated below and provide a tally for each.
A regular query (not multiple) queries for the occurrence of only one objective.
Using the example listed above, a regular query would search for the occurrence of
the three objectives listed in the second column of the table illustrated below and
provide a tally of the number of times it was listed as an objective for a project, whether
by itself or in combination with other objectives.
MULTIPLE QUERY
ENDS
FOOD
WILD
ENDS, FOOD
ENDS, WILD
FOOD, WIL'D
ENDS, FOOD, WILD
REGULAR QUERY
ENDS
FOOD
WILD
MOTE: The order in which the codes are listed does not matter (e.g., ENDS, FOOD is
the same as FOOD, ENDS).
The search for ENDS in a multiple query will count all the records that have
ENDS listed as an objective. The record does not have to contain ENDS only. For
example, if Permit A had two objectives, ENDS and FOOD, the permit would be
54
-------
counted for three different cases in the multiple query: 1) ENDS 2) FOOD 3)
ENDS, FOOD.
The following figure illustrates how the three permits (with the objectives stated
below) would be counted under the various cases of a multiple query and a regular
query. YES indicates the permit would be counted for that query combination, and NO
indicates the permit would not be counted for that combination of objectives.
OBJECTIVES
Permit 1 ENDS
Permit 2 ENDS, FOOD
Permit 3 WILD, ENDS, FOOD
Objectives listed in permit
MULTIPLE QUERY
Permit 1
ENDS
Permit 2
ENDS, FOOD
Permit 3
WILD, ENDS, FOOD
ENDS
YES
YES
YES
FOOD
NO
YES
YES
WILD
NO
NO
YES
ENDS, FOOD
NO
YES
YES
ENDS, WILD
NO
NO
YES
FOOD, WILD
NO
NO
YES
ENDS, FOOD, WILD
NO
NO
YES
Objectives listed in permit
REGULAR QUERY
Permit 1
ENDS
Permit 2
ENDS, FOOD
Permit 3
WILD, ENDS, FOOD
ENDS
YES
YES
YES
FOOD
NO
YES
YES
WILD
NO
NO
YES
Note that for both multiple and regular queries, the record (permit or wetland) has to
contain the combination of codes requested in the search, but can contain additional
55
-------
codes. For example, Permit 2 (with ENDS, FOOD as objectives) was counted for the
search for ENDS for both multiple and regular queries, even though FOOD was also
listed as an objective for the permit. Recall that the order in which the codes occur
does not matter (e.g., Permit 3 listed WILD, ENDS, FOOD as objectives but was
counted for the search for ENDS, FOOD, WILD for the multiple query).
Use a multiple query to calculate the number of times various combinations of
objectives, functions, wetland types, etc. are listed in the database. For example, a
multiple query would be used if you wanted to determine how many palustrine
emergent-palustrine open water wetland complexes were impacted as a result of
permitting. Use a regular query to calculate the number of times one specific
objective, function, wetland type, etc. is listed in the database. For example, a regular
query would be used if you wanted to determine how many times palustrine emergent
marshes were impacted.
For both multiple and regular queries, the total for the query can be greater than
the number of records (permits or wetlands). In the example above, Permit 3 would be
counted seven times for the multiple query and three times for the regular query.
After you have selected a field that is followed by the word MULTIPLE, the following
box will appear.
MULTIPLE? N
«®* Press Y and [Enter] to perform a multiple query.
Press N and [Enter] to perform a regular query.
NOTE: Only one field can be designated as MULTIPLE for each query.
56
-------
If you answer Yes in the MULTIPLE query box, you will have the additional option to
perform an exact query.
NOTE: Both multiple and exact queries require additional processing time. It can
take up to several hours to generate totals for a multiple or an exact query.
Exact queries
Exact queries only count records that exactly match the combination requested
for that query. You will probably want to perform exact queries in most cases. Exact
queries produce totals that equal the number of records in a database, since each
permit or wetland will be counted only one time. Using the example above (see page
55), each of the three permits would be counted only one time in an exact query as
illustrated below.
Objectives listed in permit
EXACT QUERY
Permit 1
ENDS
Permit 2
ENDS, FOOD
Permit 3
WILD, ENDS, FOOD
ENDS
YES
NO
NO
ENDS, FOOD
NO
YES
NO
ENDS, FOOD, WILD
NO
NO
YES
NOTE: Again, the order in which the codes are listed does not matter (i.e., Permit 3
with WILD, ENDS, FOOD as objectives was counted for the exact query for ENDS,
FOOD, WILD).
After you have answered the question in the MULTIPLE box, the following box will
appear.
57
-------
I
EXACT? N
Em I
» Press Y and [Enter] to perform an exact query.
«¦ Press N and [Enter] to perform a multiple query.
REMEMBER: Although the preceding sections are rather complicated, it is very
important that you understand the difference between regular multiple, and exact
queries.
The following examples are presented to help clarify the differences between the three
types of queries.
EXAMPLE 1: Two permits are in a database, each permit lists the following
Project types:
PROJECT TYPES
Permit 1 DOCK, RAMP, ROAD
Permit 2 RECR, SMOD, STAB
DOCK = Private dock or moorage
RAMP = Boat ramp
ROAD = Highway, road, or bridge
RECR = Recreational area
SMOD = Stream modification
STAB = Shore stabilization
If a regular query was performed, the permits would be counted one time
for each of the following cases.
58
-------
REGULAR QUERY
PROJECT TYPES
DOCK
RAMP
RECR
ROAD
SMOD
STAB
FREQUENCY
Since DOCK was listed one time in Permit 1, the permit was counted one time for the
case when Project type = DOCK. Remember that regular queries count the number of
times one entry (e.g., DOCK) is listed in a database.
If a multiple query was performed, the permits would be counted one time
for each of the following cases.
MULTIPLE QUERY
PROJECT TYPES FREQUENCY
DOCK
RAMP
RECR
ROAD
SMOD
STAB
DOCK, RAMP
DOCK, ROAD
RAMP, ROAD
RECR, SMOD
RECR, STAB
SMOD, STAB
DOCK, RAMP, ROAD
RECR. SMOD, STAB
Each of the combinations listed above occurs in the database containing Permit 1 and
Permit 2. For example, the combination DOCK, ROAD can be found in Permit 1.
Notice, however, that the combination DOCK, RECR is not listed above, since that
59
-------
combination of project types does not occur in either Permit 1 or Permit 2. Remember
that multiple queries count the number of times specific combinations of entries (e.g.,
SMOD, STAB) occur in a database.
If an exact query was performed, the permits would be counted one time
for each of the following cases.
EXACT QUERY
PROJECT TYPES
FREQUENCY
DOCK, RAMP, ROAD
1
RECR, SMOD, STAB
1
Exact queries only count records that exactly match the combination of entries for the
exact query.
EXAMPLE 2: Four permits are in a database, each permit lists the following
Objectives:
OBJECTIVES
Permit 1 ENDS
Permit 2 WILD
Permit 3 ENDS, FOOD
Permit 4 ENDS, FOOD, WILD
The number of times the permits would be counted for the possible cases for each of
the three types of queries is listed on the next page.
60
-------
REGULAR
MULTIPLE
EXACT
ENDS 3
FOOD 2
WILD 2
ENDS 3
FOOD 2
WILD 2
ENDS, FOOD 2
ENDS, WILD 1
FOOD, WILD 1
ENDS, FOOD, WILD 1
ENDS 1
WILD 1
ENDS, FOOD 1
ENDS, FOOD, WILD 1
The Multiple query for ENDS is the same as the Regular query for ENDS, but is not
the same as the Exact query for ENDS.
Moving around the query worksheet
The following table contains a list of keys used for moving around the query
worksheet.
61
-------
PRESS IN ORDER TO
[ ft 1 Move the highlighted box up one row.
[ U] Move the highlighted box down one row.
[ =*] Move the highlighted box to the right one column.
[ *=] Move the highlighted box to the left one column.
[PgUp] Move the highlighted box up 14 lines.
[PgDn] Move the highlighted box down 14 lines.
[Home] Move the highlighted box to the first field on the screen.
[End] Move the highlighted box to the last field on the screen.
[Ctrl] & [PgUp]1 Move the highlighted box to the top of the query worksheet.
[Ctrl] & [PgDn]1 Move the highlighted box to the bottom of the query worksheet.
[Ctrl] & [Home]1 Move the highlighted box to the first field of the query worksheet.
[Ctrl] & [End]1 Move the highlighted box to the last field of the query worksheet.
^he two keys should be pressed simultaneously for the four functions listing the
[Ctrl] key.
Yes/No and range fields
There are two ways to enter specifications for queries in the query worksheet:
select items in True/False (T/F) fields and enter upper and lower limits in Range fields.
There are 46 T/F fields and 7 Range fields in the PTS. T/F fields are used for selecting
individual items or all the items in a field to the right of the T/F column. Range fields
are used to specify the lower and upper limits for fields. The range encompasses all
values greater than the lower limit and less than or equal to the upper limit. Both lower
and upper limits must be specified for all range fields. Tables listing the range and T/F
fields used in the PTS are illustrated on the next page.
62
-------
Range fields:
FIELD NAME RANGE FIELDS
LOW HIGH
DATE_ISS (date permit issued)
DATE_ISS_L
DATE_ISS_H
AREA (total project area)
AREA_L
AREA_H
SCALE (scale of NWI/USGS map)
SCALE_L
SCALE_H
DATE_BEGAN (date construction began)
DATE_BEG_L
DATE_BEG_H
DATE_COMP (date construction completed) DATE_COM_L
DATE_COM_H
WA (area of a specific wetland type)
WA_L
WA_H
YEAR (year permit was issued)
YEAR_L
YEAR_H
UDF_DATE (user defined field-date)
UDF_DAT_L
UDF_DAT_H
UDF_NUM (user defined field-numenc)
UDF NUM L
UDF NUM H
DATE_ISS_L stands for the low limit of the range for the DATEJSS field.
DATE_ISS_H stands for the high limit of the range for the DATEJSS field.
63
-------
T/F fields:
FIELD NAME
CORRESPONDING T/F FIELD
PERMIT
PERMIT TF
1
1 TF
CASE
CASE TF
COMP MIT
COMPMIT TF
MIT BANK
Ml BANK TF
BANK NAME
BANKNAM TF
MONEY LAND
ML TF
STATE
STATE TF
COUNTY
COUNTY TF
TOWN RANG
TOWN TF
SECTIONS
SECTION TF
LAT LONG
LATLONG TF
MAPNAME
MAPNAME TF
BODYTYPE
BODTYPE TF
BODYNAME
BODNAME TF
LOCATION
LOCAT TF
OFF ON
OFF ON TF
LAND USE
LANDUSE TF
MAPS
MAPS TF
BLUEPRINTS
BLUE TF
GRND PHOTO
GRND TF
AIR PHOTO
AIR TF
CORRECTION
CORRECT TF
WET TYPE
WET TYPE TF
PROJECT
PROJECT TF
FUNCTION
FUNC TF
OBJECTIVE
OBJECT TF
METHOD
METHOD TF
EN DSP SCI
END SCI TF
ENDSP COM
END COM TF
TITLE
TITLE TF
AUTHOR
AUTHOR TF
SOURCE
SOURCE TF
CONTENT
CONTENT TF
CONTACT
CONTACT TF
ORGAN IZA
ORGAN IZ TF
ADDRESS
ADDRESS TF
CITY
CITY TF
ST
ST TF
ZIP
ZIP TF
PHONE
PHONE TF
AS BUILT
AS BLT TF
CHECK REG
CHK REG TF
CHECK IREG
CHK IRG TF
DATA COLL
DAT COL TF
MONITOR
MONITOR TF
UDF YN
UDF YN TF
UDF CHAR
UDF CHAR TF
See Appendix E for descriptions of field names.
64
-------
An example of a T/F field using the PROJECT field is illustrated below.
PROJECTTF PROJECT
AIRPORT
AQUACULTURE
BOAT RAMP
COMMERCIAL PROJECT
DAM OR RESERVOIR
DIKE PLACEMENT
DRAINAGE DITCH
DREDGE DISPOSAL
AQUACULTURE and DRAINAGE DITCH are selected in this example.
<®" To select an item for a query, position the highlighted box over the item or the
corresponding F to the left of the item and press [Enter]. The F will change to
T to indicate the item has been selected.
PROJECTTF
PROJECT
T
F
AIRPORT
F
AQUACULTURE
F
BOAT RAMP
F
COMMERCIAL PROJECT
F
DAM OR RESERVOIR
F
DIKE PLACEMENT
F
DRAINAGE DITCH
F
DREDGE DISPOSAL
The entire Project field is selected in this example.
To select all the items in a field, position the highlighted box over the empty
space in the first row or the corresponding F and press [Enter]. The F will
change to T to indicate the entire field has been selected.
65
-------
To deselect an item or an entire field, position the highlighted box over the T or
the item and press [Enter]. The corresponding T will change to F to indicate
the item or field has been deselected.
An example of a Range field using the AREA field is illustrated below.
If you selected the AREA field from the list of field names, the following query
worksheet will appear.
AREA_L
AREA_H
1 0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
0.0
Note that the AREA range fields contain all 0.0's. You must enter the ranges for the
query you want to perform.
For example, if you wanted to determine wetland size in five acre increments, you
would enter the following area values in the query worksheet.
AREA_L
AREA_H
1 0.0
5.0
5.0
10.0
10.0
15.0
15.0
20.0
20.0
25.0
To enter data into range fields, position the highlighted box over the appropriate
0.0's and enter the value for the upper and lower limits and press [Enter].
Wetlands that are the following areas would be counted in the ranges listed above.
66
-------
AREA_L
AREA_H
ACCEPTABLE WETLAND AREA
0.0
5.0
0.1,0.2, 0.3, 0.4, 0.5, 0.6, ...5.0
5.0
10.0
5.1,5.2, 5.3, 5.4, 5.5, 5.6,.. . 10.0
10.0
15.0
10.1, 10.2, 10.3, 10.4, 10.5,10.6,..
. 15.0
15.0
20.0
15.1, 15.2, 15.3, 15.4, 15.5, 15.6,..
.20.0
20.0
25.0
20.1, 20.2, 20.3, 20.4, 20.5, 20.6, ..
.25.0
Therefore, if AREA_L < X <, AREA_H, X will be counted in that range.
To include areas equal to 0.0, enter -1.0 as the lower limit of the range.
Another example of a Range field using the DATEJSS field (the date the permit was
issued) is illustrated below.
DATE_ISS_L
DATE_ISS_H
12/31/80
12/31/81
12/31/81
12/31/82
12/31/82
12/31/83
12/31/83
12/31/84
12/31/84
12/31/85
The permits issued on the following dates would be counted in the ranges listed
above.
67
-------
DATEISS L DATEISS H
ACCEPTABLE DATES
12/31/80
12/31/81
12/31/82
12/31/83
12/31/84
12/31/81
12/31/82
12/31/83
12/31/84
12/31/85
1/1/81 through 12/31/81
1/1/82 through 12/31/82
1/1/83 through 12/31/83
1/1/84 through 12/31/84
1/1/85 through 12/31/85
After you have entered the specifications for the query, press [Esc] to return to
the PTS main menu.
The next step in the query program is to process the query. The query will
generate the frequency and area (in acres and hectares) totals for each question
entered into the PTS.
Clear Enter flun Filter View Save Print Quit
Process the query
Position the highlighted box over RUN and press [Enter], OR press R.
You will then be asked to answer three questions about the query.
Run
Query the database by permit? (Y)es/(N)o N
Generate a detail file? (Y)es/(N)o N
Process the query? (Y)es/(N)o N
68
-------
Querying by permit versus querying by wetland
There are two ways by which a query can be processed: by permit and by
wetland. A query processed by permit counts all the permits that meet the query
specifications. For example, you should query by permit to determine the number of
permits that were issued in 1987. A query processed by wetland counts all the
wetlands that meet the query specifications. For example, you should query the
database by wetland to determine the number of palustrine forested wetlands that
were impacted by permitting. Since more than one wetland can be affected by a
single permit, a query processed by wetland may have totals that exceed the number
of permits in a database.
Enter Y and press [Enter] to process the database by permit,
ra* Enter N and press [Enter] to process the database by wetland.
Generating a detail file
The detail file contains all the information in the database for the records that
meet the query specifications. For example, if the query was to calculate the number
of permits issued in each county, you will only see information pertaining to the query
(i.e., county, frequency, and area) when you view the results without having produced
a detail file. If a detail file was generated, all the information for each record that met
the query specifications would appear when you view the results. Most of the time you
will not want to generate detail files, as this greatly increases the amount of
information to view. Generating detail files also increases the time required to
Query the database by permit? (Y)es/(N)o N
69
-------
process the query. However, if information, other than the results of the query, is
desired, you should generate a detail file.
Generate a detail file? (Y)es/(N)o N
Enter Y and press [Enter] to generate a detail file,
a* Enter N and press [Enter] to not generate a detail file.
Processing the query
Process the query? (Y)es/(N)o N
Enter Y and press [Enter] to process the query as entered previously,
ra" Enter N and press [Enter] to change the query specifications.
Filter
After the query has been processed, the results can be filtered to remove all the
totals that equal zero. For example, the results of a query generated to calculate the
number and type of permits issued in each county might be similar to the one depicted
below.
70
-------
CASE
COUNTY
COUNT
ACRES
HECTARES
C
HUMBOLDT
0
0.0
0.0
C
MONTEREY
0
0.0
0.0
C
ORANGE
1
1.0
0.4
C
SAN DIEGO
2
5.7
2.3
C
SAN FRANCISCO
0
0.0
0.0
E
HUMBOLDT
0
0.0
0.0
E
MONTEREY
0
0.0
0.0
E
ORANGE
2
7.0
2.8
E
SAN DIEGO
4
34.9
14.1
E
SAN FRANCISCO
0
0.0
0.0
I
HUMBOLDT
0
0.0
0.0
I
MONTEREY
1
1.0
0.4
I
ORANGE
0
0.0
0.0
I
SAN DIEGO
0
0.0
0.0
I
SAN FRANCISCO
0
0.0
0.0
P
HUMBOLDT
0
0.0
0.0
P
MONTEREY
0
0.0
0.0
P
ORANGE
2
10.0
4.0
P
SAN DIEGO
1
2.4
1.0
P
SAN FRANCISCO
1
1.0
0.4
R
HUMBOLDT
1
1.0
0.4
R
MONTEREY
0
0.0
0.0
R
ORANGE
0
0.0
0.0
R
SAN DIEGO
0
0.0
0.0
R
SAN FRANCISCO
2
14.5
5.9
If the results were filtered, they would be shortened to the version illustrated on the
next page.
71
-------
1 CASE
COUNTY
COUNT
ACRES
HECTARES
C
ORANGE
1
1.0
0.4
C
SAN DIEGO
2
5.7
2.3
E
ORANGE
2
7.0
2.8
E
SAN DIEGO
4
34.9
14.1
1
MONTEREY
1
1.0
0.4
P
ORANGE
2
10.0
4.0
P
SAN DIEGO
1
2.4
1.0
P
SAN FRANCISCO
1
1.0
0.4
R
HUMBOLDT
1
1.0
0.4
R
SAN FRANCISCO
2
14.5
5.9
The primary advantage to filtering the results is that it simplifies the amount of
information you have to view.
Clear Enter Run Filter View Save Print Quit
Remove all totals with counts equal to zero
Position the highlighted box over FILTER and press [Enter], OR press F to
filter the results.
View
The results of the query will be displayed in a results worksheet. An example of
a results worksheet is illustrated on the next page.
72
-------
1 CASE
COUNTY
COUNT
ACRES
HECTARES
C
ORANGE
1
1.0
0.4
C
SAN DIEGO
2
5.7
2.3
E
ORANGE
2
7.0
2.8
E
SAN DIEGO
4
34.9
14.1
1
MONTEREY
1
1.0
0.4
P
ORANGE
2
10.0
4.0
P
SAN DIEGO
1
2.4
1.0
P
SAN FRANCISCO
1
1.0
0.4
R
HUMBOLDT
1
1.0
0.4
R
SAN FRANCISCO
2
14.5
5.9
M [=•]
Press [Esc] to return to the main menu.
Clear Enter
Run Filter View Save
View the results of a query
Totals
Details
Position the highlighted box over VIEW and press [Enter], OR press V.
THEN...
kf Position the highlighted box over TOTALS and press [Enter], OR press T and
press [Enter] to view the results worksheet for the query.
OR...
Position the highlighted box over DETAILS and press [Enter], OR press D
and press [Enter] to view the detail file (a detail file must have been requested
prior to processing the query).
OR...
73
-------
Position the highlighted box over EXIT and press [Enter], OR press E and
press [Enter] to return to the query main menu.
Moving around the results worksheet
It is unlikely that all of the query results will be displayed on the computer
monitor at one time. To view the entire results worksheet, use the keys listed in the
following table to move around.
PRESS IN ORDER TO
[ ft] Move the highlighted box up one row.
[ U] Move the highlighted box down one row.
[ =>] Move the highlighted box to the right one column.
[ <=] Move the highlighted box to the left one column.
[PgUp] Move the highlighted box up 14 lines.
[PgDn] Move the highlighted box down 14 lines.
[Home] Move the highlighted box to the first field on the screen.
[End] Move the highlighted box to the last field on the screen.
[Ctrl] & [PgUp]1 Move the highlighted box to the top of the results worksheet.
[Ctrl] & [PgDn]1 Move the highlighted box to the bottom of the results worksheet.
[Ctrl] & [Home]1 Move the highlighted box to the first field of the results worksheet.
[Ctrl] & [End]1 Move the highlighted box to the last field of the results worksheet.
1The two keys should be pressed simultaneously for the four functions listing the
[Ctrl] key.
74
-------
MOTE: If you query the database by permit, a field named LASTPERMIT will appear
when you view the results. The "last permit" is simply the permit number of the last
permit in the database that was counted for the query.
ra- After you have viewed the query results, press [Esc] to return to the query main
menu.
Save
You must save the query results if you want to generate tables (by using the
TABLE option from the PTS main menu).
ra- Position the highlighted box over SAVE and press [Enter], OR press S.
THEN...
Position the highlighted box over TOTALS and press [Enter], OR press T and
press [Enter] to save the results worksheet.
OR...
Position the highlighted box over EXIT and press [Enter], OR press E and
press [Enter] to return to the query main menu.
If you are saving query totals, the following box will appear.
ra* Enter a description (thirty character maximum) for the file to contain the results,
then press [Enter] to return to the query main menu.
NOTE: The file will be assigned a unique filename based on the date the query was
saved. For example, the first query saved on 6/11/91 would be assigned the filename
Clear Enter Run Filter View Save
Save the results to a file
Totals
Exit
75
-------
061191AA; the second query saved on 6/11/91 would be assigned the filename
061191AB. The file will be saved to a subdirectory of the directory containing the PTS
(i.e., \PTS\RESULTS). The saved file can be printed using the PRINT option from the
query program, and/or it can be used to generate a table at a later time using the
TABLE option from the PTS main menu.
Print
The results of a query can either be output to a printer or written to a floppy disk
or,a hard drive. If you write the file to either a floppy or a hard drive, it will be saved in
ASCII format with a .prn extension. The .prn file can later be incorporated into a word
processing program.
Clear Enter Run Filter View Save Print Quit
Print the query results
Query results
Detail results
Exit
Position the highlighted box over PRINT and press [Enter], OR press P.
THEN...
Position the highlighted box over QUERY RESULTS and press [Enter], OR
press Q and press [Enter] to print the query results.
OR...
** Position the highlighted box over DETAIL RESULTS and press [Enter], OR
press D and press [Enter] to print a detail file (a detail file must have been
requested prior to processing the query).
OR...
ra* Position the highlighted box over EXIT and press [Enter], OR press E and
press [Enter] to return to the query main menu.
76
-------
If you are printing either totals or details, the following box will appear.
TITLE:
NAME:
WRITE TO DISK ? N
ra* Enter the title for the file to be printed and press [Enter],
i®" Enter the file name to be printed and press [Enter].
If you are printing the file:
ear Enter N and press [Enter] to send the file to a printer.
Are you using a wide-carriage printer? (Y)es/(N)o N
Type Y and press [Enter] if you are printing to a wide-carriage printer (e.g., at
least 132 characters in width).
Type N and press [Enter] if you are nol printing to a wide-carriage printer.
The file will be printed.
If you are writing the file to a floppy or a hard drive:
ra- Enter Y and press [Enter] to write the file to a floppy or a hard drive. The
following box will appear.
I FILENAME: _
77
-------
«3" Enter a name (eight character maximum) for the file to contain the results, then
press [Enter] to save the file to the default subdirectory.
Enter a drive, and/or a directory, and a name (eight character maximum) for the
file to contain the results, then press [Enter] to save the file to a drive and/or
directory other than the defaults.
Do you want this file formatted for a wide-carriage
printer? (Y)es/(N)o N
oy Type Y and press [Enter] if you want the file formatted for a wide-carriage
printer (132 characters in width).
Type N and press [Enter] if you do not want the file formatted for a wide-
carriage printer.
NOTE: DO NOT ENTER AN EXTENSION-the file will be assigned a .pm extension.
For example, if you enter the name QUERY4, the file will be saved as QUERY4.prn.
The difference between a .prn file generated in this manner and a .dbf file generated
under SAVE from the query menu is the format. A .dbf is in dBase format and will be
recognized under the TABLE command from the PTS main menu. A .prn file is in
ASCII format and can be incorporated into other software programs as an ASCII file.
Quit
Clear Enter Run Filter View Save Print Quit
Exit the query program
Position the highlighted box over QUIT and press [Enter], OR press Q to exit
the query program.
78
-------
SUPPLEMENTAL PROGRAMS
79
-------
80
-------
Checking for errors
The Summary Check option searches for certain errors in a database. For
example, if endangered species was listed as a function of the impacted wetland, but
no endangered species names were listed, a warning would be issued. Summary
Check also calculates the percent of each field in a database that contains data. This
is especially useful for data quality assurance, in that you will be aware of how
complete the data is in each field. You can then either go back and concentrate on
obtaining better information for the incomplete fields or recognize the data quality
problems when drawing conclusions from the data. To perform a summary check on
your data, follow the steps listed below.
Data Entry Summary Check Field Contents Query Table Print Exit
Report errors and data quality
ra- From the PTS main menu, position the highlighted box over SUMMARY
CHECK and press [Enter], OR press S.
Select a database type and press [Enter]
404 Permit
401 Permit
State Permit
Other
Exit
Position the highlighted box over the permit type of the database to check and
press [Enter].
81
-------
CA404.DBF
OR404.DBF
•
T
Position the highlighted box over the database to check and press [Enter].
A report of any errors detected in the database and a listing of the percent of each field
that contains data will be generated and printed.
LISTING CONTENTS OF FIELDS
The Field Contents option generates and prints a sorted list of all the entries in
each field in a database. This option is also useful for quality assurance purposes, as
it easy to recognize information that has been entered incorrectly. For example, if a list
of counties contained both CENTER and CENTRE, it would be easy to recognize that
there had been an error in data entry. To produce a field contents list, follow the steps
listed below.
Data Entry Summary Check Field Contents Query Table Print Exit
Produce a listing of the contents of each field
From the PTS main menu, position the highlighted box over FIELD
CONTENTS and press [Enter], OR press F.
82
-------
Select a database type and press [Enter]
404 Permit
401 Permit
State Permit
Other
Exit
I II III I llll Illl I
««* Position the highlighted box over the permit type of the database from which to
produce a field contents list and press [Enterj.
CA404.DBF
OR404.DBF
f
*5- Position the highlighted box over the database from which to produce a field
contents list and press [Enter].
A box will appear as all the fields are processed.
Processing field 11 of 80
A file named CONTENTS.DBF, containing a sorted list of the contents of each field in
the database, will be created. To obtain a print-out of the file, use the PRINT option
from the PTS main menu (see directions on page 88 on printing files).
83
-------
The results are in the file CONTENTS.DBF.
Use the PRINT option to print the results.
Press [Enter] to continue.
Press [Enter] to return to the main menu.
Generating tables
To produce tables from query results saved in the query program, follow the
steps listed below. An ASCII file of the tables will be generated whether or not you
print the tables. This file will have the same filename as the file saved in the query
program, except with a .WID extension instead of a .DBF extension. The file saved by
the table program will be saved to the \PTS\TABLES subdirectory and can be imported
into other software packages as an ASCII file.
Data Entry Summary Check Field Contents Query Table Print Exit
¦sr From the PTS main menu, position the highlighted box over TABLE and press
[Enter], OR press T.
A list of all the files saved in the query program will be displayed.
Generate a table
84
-------
FILE_DESC
DATABASE
DATE
TIME
FILENAME
Wetland types & functions
CA404.DBF
6/10/91
10:25:42
061091AA
Case and area totals
MD401.DBF
6/11/91
09:41:37
061191AA
Objectives and methods
ORST1.DBF
7/21/91
02:13:01
072191 AA
Land use totals
MD401.DBF
7/21/91
04:11:43
072191AB
[=>] Press [Enter] to select a file / Press [Esc] to exit.
FILE_DESC is the file description (the description of the file saved in the query
program).
DATABASE is the database used for the query.
DATE is the date the query was processed.
TIME is the time the query was processed.
FILENAME is the name assigned to the file saved in the query program. The date
and time the query was saved are used in assigning this filename.
Use the up and down arrows to position the highlighted box over the description
of the file from which you want to generate a table and press [Enter].
OR...
is* Press [Esc] to return to the main menu if you do not want to generate a table.
Remove extraneous answers? N
Removing extraneous answers is similar to filtering the query results. It removes all
the results that equal zero.
Type N and press [Enter] to remove extraneous answers.
bp Type Y and press [Enter] to not remove extraneous answers.
An example of the table worksheet is illustrated on the next page. Only the field
names used in the file from which you are making a table will be displayed.
85
-------
FIELD NAME
CASE
STATE
COUNTY
AREA
Y AXES: X AXIS:
Press [Enter] to select the axis.
Press [Esc] to generate table.
A table is comprised of one X axis and one or more Y axis. The X axis runs across the
paper; the Y axes run down the paper. The TABLE option will calculate the total for
each row and each column displayed in the table. In the table illustrated on page 88,
COUNTY and CASE are the Y axes and OBJECTIVE is the X axis.
The next box that appears allows you to enter information about the table. The
information you enter will be printed at the top of the table.
•a* Specify the title for the table.
Specify the name of the file from which the table was generated, OR enter your
name.
Press [Enter],
TITLE:
NAME:
86
-------
The table will be generated.
processing
After the table has been generated, you will be asked if you want to print the table.
Type Y and press [Enter] to print the table.
Type N and press [Enter] to not print the table.
If you answered Yes to the previous question, the following box will appear.
Type Y and press [Enter] if you are printing to a wide-carriage printer (e.g., at
least 132 characters in width).
t®* Type N and press [Enter] if you are nsi printing to a wide-carriage printer.
A table, similar to the one illustrated on the next page, will be printed. Tables
calculating the total area in acres and hectares will also be printed.
Do you want to print the table? (Y)es/(N)o Y
Are you using a wide-carriage printer? (Y)es/(N)o N
87
-------
[COUNT]
Objective
County
Case
FISH
FOOD
WILD
TOTAL
Alameda
Created
2
2
1
5
Alameda
Restored
3
2
0
5
Marin
Created
1
1
4
6
Marin
Restored
1
1
2
4
San Francisco
Created
1
1
2
4
San Francisco
Restored
3
1
1
5
Solano
Created
2
1
0
3
Solano
Restored
2
0
1
3
Sonoma
Created
1
1
2
4
Sonoma
Restored
1
2
2
5
TOTAL
17
12
15
44
Printing files
Another program included with the PTS prints databases and the Field
Contents list. Database print-outs are useful for quality assurance purposes. For
example, you can scan an entire database searching for outliers and incomplete
information, as opposed to inspecting the database record-by record within the PTS.
Furthermore, we recommend you save hard-copies of all databases as archives. To
obtain a hard-copy of a database or the Field Contents list, follow the procedures
outlined below.
Data Entry Summary Check Field Contents Query
Send a file to the printer
Table Print Exit
From the PTS main menu, position the highlighted box over PRINT and press
[Enter], OR press P.
A list of all the databases created in the PTS will be displayed.
88
-------
CA404.DBF
OR404.DBF
GA401.DBF
TXSTONE.DBF
TXOTH2.DBF
Press [Enter] to select a
file. Press [Esc] to exit.
Use the up and down arrows to position the highlighted box over the database
to be printed and press [Enter].
Press [Esc] to return to the main menu.
A box that contains space for you to identify the database being printed will
appear. The information you enter will be displayed at the top of the print-out.
Specify the subject of the file you are printing, for example, Section 404 permits
issued in Texas, Field Contents list.
Specify the name of the file you are printing, OR enter your name.
Press [Enter].
A box asking if you have a wide-carriage printer will appear.
Type Y and press [Enter] if you are printing to a wide-carriage printer (e.g., at
least 132 characters in width)
Type N and press [Enter] if you are ncl printing to a wide-carriage printer.
A Printing box will appear while the file is being printed.
Subject:
Name:
89
-------
Printing
The PTS main menu will appear after the file has been printed.
Data Entry Summary Check Field Contents Query Table Print Exit
Enter permit data
90
-------
LITERATURE CITED
Cowardin, L.M., V. Carter, F.C. Golet, and E.T. LaRoe. 1979. Classification of
Wetlands and Deepwater Habitats of the United States. U.S. Fish and Wildlife
Service, Washington, DC. FWS/OBS/-79/31. 103 pp.
91
-------
92
-------
APPENDIX A
THE PERMIT TRACKING SYSTEM FORM
93
-------
94
-------
3ermit number
Dale permit issued
Form designed by C.C. Holland and R.G. Gibson
ManTech Environmental Technology, Inc.
U.S. Environmental Protection Agency,
Environmental Research Laboratory
200 SW 35th Street
Corvallis, OR 97333
State Countv
Acres
State Countv
Acres
TOTAL
TownshiD & Ranae
Section(s)
Latitude/Lonaitude
'JSGS/NWI maD name
Scale 1:
Select [1]
Water/river body name
lo Water Body
0 River Body
Specific location
Land use~ Select [1]
0
Agricultural
0
Commercial
0
Industrial
0
Natural
0
Residential
Documents available-
Select [0-4]
O Maps
O Blueprints
O Ground photos
O Aerial photos
Date construction began
Date construction completed / /
COWARDJN WETLAND VfPt-Sehct [1-5]
ACRES
ACRES
ACRES
ESTUARINE
RIVERINE
0
subbdal aquabc bed
o
tidal aquabc bed
0
subbdal open water
0
Mai beach/bar
0
subbdal reef
»
0
tidal emergent
o
subbdal rock bottom
o
bdal flat
o
subbdal unconsolidated bottom
o
bdal open water
o
interbdal aquatic bed
o
bdal rock bottom
0
interbdal beach/bar
0
tidal rocky shore
o
interbdal emergent
__
0
bdal streambed
o
interbdal flat
o
bdal unconsolidated bottom
0
interbdal forested
0
bdal unconsolidated shore
0
interbdal reef
o
lower perennial aquabc bed
0
interbdal rocky shore
0
lower perennial beach/bar
0
interbdal scrub/shrub
_____
o
lower perennial emergent
0
interbdal streambed
0
lower perennial flat
0
interbdal unconsolidated shore
0
lower perennial open water
o
lower perennial rock bottom
LACUSTRINE
0
lower perennial rocky shore
o
lower perennial streambed
0
limnetic aquatic bed
o
lower perennial unconsolidated bottom
O
limnetic open water
0
lower perennial unconsolidated shore
O
limnetic rock bottom
o
upper perennial aquatic bed
0
limnetic unconsolidated bottom
0
upper perennial beach/bar
0
littoral aquatic bed
___
o
upper perennial fiat
O
littoral beach/bar
o
upper perennial open water
o
littoral emergent
_____
o
upper perennial rock bottom
o
littoral flat
0
upper perennial rocky shore
0
littoral open water
___
o
upper perennial streambed
o
littoral rock bottom
0
upper perennial unconsolidated bottom
0
littoral rocky shore
o
upper perennial unconsolidated shore
o
littoral unconsolidated bottom
o
intermittent aquabc bed
0
littoral unconsolidated shore
o
intermittent beach/bar
0
intermittent flat
o
intermittent open water
0
intermittent rock bottom
o
intermittent rocky shore
0
intermittent streambed
o
intermittent unconsolidated bottom
RIVERINE (cont)
O unknown perennial aquatic bed
O unknown perennial beach/bar
O unknown perennial flat
O unknown perennial open water
O unknown perennial rock bottom
O unknown perennial rocky shore
O unknown perennial streambed
O unknown perennial unconsolidated bottom
O unknown perennial unconsolidated shore
PALUSTRINE
O aquatic bed
O emergent
O flat
O forested
O moss/lichen
O open water
O rock bottom
O scrub/shrub
O unconsolidated bottom
O unconsolidated shore
MARINE
O subddal aquatic bed
O subbdal open water
O subbdal reef
O subbdal rock bottom
O subtidal unconsolidated bottom
O interbdal aquatic bed
O Intertdal beach/bar
O interbdal flat
O interbdal reef
O interbdal rocky shore
O interbdal unconsolidated shore
TOTAL AREA
-------
TYPE OF PROJECT-Sdtecf
0
Airport
0
Hydroelectnc project
0
Recreational area
0
Aquaculture
0
Industrial park
0
Shipping wharf, dock, or pier
0
Boat ramp
0
Jetty or groin
0
Shore stabilization
0
Commercial project
0
Manna
0
Solid waste disposal
0
Dam or reservoir
0
Mining
0
Stream modification
0
Dike placement
0
Mosquito abatement
0
Tide gate
0
Drainage ditch
0
Navigation channel, cannel, etc
0
Utility
0
Dredge disposal
0
Oil & gas activities
O
Well drilling pad
0
Dredging
0
Other
O
Wildlife habitat
0
Farming activity
o
Pipeline
0
Highway, road, or bndge
0
Private dock or moorage
0
Housing development
0
Railroad
FUNCT10N--Se/ecf {1-5}
O Active recreation
O Consumptive recreation
O Flood storage
O Food chain support
0 Ground water modification
0 Habitat for endangered species-
CD Habitat for fisheries
O Habitat for wildlife
O Non-consumptive recreation
O Nutrient retention and removal
O Other
O Passive recreation
O Sediment trapping
O Shoreline stabilization
O Uniqueness or rareness
ENDANGERED SPECIES
1
Scientific name
Common name
2
Scientific name
Common name
3.
Scientific name
Common name
DEPORT INFORMATION
Title
Author's First Initial Middle Initial Last Name
Year Source
Content
CONTACT INFORMATION
First Initial Middle Initial Last Name
Organization
Add ress
City State Zip Phone ( )
COMMENTS
-------
I
Permit number
Date permit issued
Mitigation Bank'',
S
V
Yes-
. Name of bank
Money or land''
STOP HERE
COMPLETE REST OF FORM
Mitigation type-Setecff/y
O Created O Enhanced O Preserved O Restored
-------
0B4ECTWE~$etect [1-3}
0 1:1 Functional replacement
O Active recreation
O Consumptive recreation
O Flood storage
0 Food chain support
O Ground water modification
O Habitat for endangered species-
O Habitat for fisheries
0 Habitat for wildlife
O Mosquito abatement
O Non-consumptive recreation
O Nursery for mitigation plants
O Nutrient retention and removal
0 Other
0 Passive recreation
O Research
O Sediment trapping
O Shoreline stabilization
O Unique systems replacement
O Uniqueness or rareness
METHOD-Selact{1-3]
O Abalone planting O
O Channels cut O
O Dike breaching O
O Establish proper hydrology O
O Excavation O
0 Fencing O
O Fill O
O Grading
O Natural regrowth
Other
Planting
Preservations
Seeding
Soil enhancement
Upstream flows
Wave protection
ENDANGERED SPECIES
1. Scientific name
Common name_
2 Scientific name_
Common name
3. Scientific name
Common name
INFORMATION ON MONITORING
Do construction plans exist7 Yes / No
Were checks made regularly' Yes / No irregularly? Yes / No
Were data collected? Yes /No
ITEMS MONJTORED-Setoef [1-3J
0 Animal density
0 Plant diversity
0 Animal diversity
0 Primary production
0 Animal use
0 Secondary production
0 Endangered species
0 Vegetative cover
0 Other
0 Water quality
0 Physical viability
0 Water table depth
REPORT INFORMATION
Title
Author's First Initial
Middle Initial
Last Name
Year
Source
Content
CONTACT INFORMATION
First Initial Middle Initial Last Name
Organization
Address
City
State
ZiP_
Phone ( )
COMMENTS
-------
DATE FIELDS
CHARACTER FIELDS
FIELD NAME
DESCRIPTION
DATE
UDF DATE1
/ /
UDF DATE2
/ /
UDF DATE3
/ /
NUMERIC FIELDS
FIELD NAME
DESCRIPTION
NUMBER
(IDF NIIM1
IJDF NUM?
IIHF Nl IMS
YES OR NO FIELDS
FIELD NAME DESCRIPTION
YES OR NO
I IDF YN1
Yes/No
I IDF YN?
Yes/No
NDF YN3
Yes/No
I IDF YN4
Yes/No
FIELD NAME
DESCRIPTION
CHARACTERS
UDF_CHAR1
UDF_CHAR2
UDF_CHAR3
UDF_CHAR4
UDF_CHAR5
UDF CHAR6
(5 character maximum)
, (10 maximum)
(30 maximum)
-------
APPENDIX B
DEFINITIONS OF MITGATION TYPES
101
-------
102
-------
Type of
mitigation
Definition
Creation
Enhancement
Preservation
Restoration
the conversion of a persistent non-wetland area into a wetland
through human activity.1
the increase in one or more values of all or a portion of an existing
wetland by human activity, often with the accompanying decline in
other wetland values.1
the maintenance of an area in its natural and undeveloped
condition to meet the specific objective of securing the
perpetuation of the wetland site or complex for its inherent values.2
the return from a disturbed or totally altered condition to a
previously existing natural, or altered condition by human activity.1
1. Roy R. Lewis. 1990. Wetlands Restoration/Creation/Enhancement Terminology:
Suggestions for Standardization, p.1-8. In J.A. Kusler and M.E. Kentula (Eds.),
Wetland Creation and Restoration: The Status of the Science, Part 2:
Perspectives. Island Press, Washington, DC.
2. J. Epperson, Missouri Department of Natural Resources.
103
-------
104
-------
APPENDIX C
SCREENS OF THE DATA ENTRY PROGRAM
105
-------
106
-------
SCREEN 1
Permit number
Date issued I f
Impacted wetland? (Y)es/(N)o
If the answer to Impacted wetland? was YES, the following screens will appear.
Go to page 110 for screens that will appear if the answer was NO.
SCREEN 2
(l)mpacted I
State County
Area 0.0
State County
Area 0.0
Township & Range
Section(s)
Latitude
Longitude
USGS/NWI map name
Scale 1: 0
(W)ater body / (R)iver body
Water/riverbody name
Specific location
SCREEN 3
Land use
(A)gricultural / (C)ommercial / (l)ndustrial / (N)atural / (R)esidential
Documents available
(M)aps
(B)lue prints
(G)round photos
(A)erial photos
Date construction began / t
Date construction completed / /
107
-------
SCREEN 4
CODE COWARDIN WETLAND TYPE SELECTED AREA
E1AB
ESTUARINE SUBTIDAL AQUATIC BED
0.0
E1BB
ESTUARINE SUBTIDAL OPEN WATER
0.0
E1RF
ESTU
0.0
E1RB
ESTU
Enter the area in acres 0.0 |TOM
0.0
E1UB
ESTU
0.0
E2AB
ESTUARINE INTERTIDAL AQUATIC BED
0.0
E2BB
ESTUARINE INTERTIDAL BEACH/BAR
0.0
E2EM
ESTUARINE INTERTIDAL EMERGENT
0.0
E2FL
ESTUARINE INTERTIDAL FLAT
0.0
E2FO
ESTUARINE INTERTIDAL FORESTED
0.0
U]
SCREEN 5
CODE PROJECT TYPE SELECTED
AIRP
AIRPORT
AQUA
AQUACULTURE
RAMP
BOAT RAMP
COMM
COMMERCIAL PROJECT
DAMS
DAM OR RESERVOIR
DIKE
DIKE PLACEMENT
DRAI
DRAINAGE DITCH
DDIS
DREDGE DISPOSAL
DREG
DREDGING
FARM
FARMING ACTIVITY
ROAD
HIGHWAY, ROAD, OR BRIDGE
HOUS
HOUSING DEVELOPMENT
108
-------
SCREEN 6
CODE FUNCTION SELECTED
ACTV
ACTIVE RECREATION
CONS
CONSUMPTIVE RECREATION
FLOD
FLOOD STORAGE
FOOD
FOOD CHAIN SUPPORT
GRWT
GROUND WATER MODIFICATION
ENDS
HABITAT FOR ENDANGERED SPECIES
FISH
HABITAT FOR FISHERIES
WILD
HABITAT FOR WILDLIFE
NONC
NON-CONSUMPTIVE RECREATION
NUTR
NUTRIENT RETENTION AND REMOVAL
M
SCREEN 7
ENDANGERED SPECIES
Scientific name
Common name
Scientific name
Common name
Scientific name
Common name
SCREEN 8
REPORT" INFORMATION
Title
Author's initials , . Author's last name
Year 0 Source
Content
109
-------
SCREEN 9
CONTACT INFORMATION
Contact's initials *
* Contact's last name
Organization
Address
City
State Zip - Phone ( )
SCREEN 10
UDF_DATE1: / /
UDF_DATE2: / / UDF_DATE3: / /
UDF_NUM1: 0.0
UDF_NUM2: 0.0 UDF_NUM3: 0.0
UDF_YN1: (Y)es/(N)o
UDF_YN2: (Y)es/(N)o
UDF_YN3: (Y)es/(N)o
UDF_YN4: (Y)es/(N)o
UDF_CHAR1:
UDF_CHAR2:
UDF_CHAR3:
UDF_CHAR4:
UDF_CHAR5:
UDF_CHAR6:
If the answer to Impacted wetland? was NO, the following screens will appear.
SCREEN 2
Permit number
Date issued
/ /
Impacted wetland? (Y)es/(N)o
Mitigation bank? (Y)es/(N)o
110
-------
If the answer to Mitigation bank? was YES, the following screen will appear.
See below for the screens that will appear if the answer was NO.
SCREEN 3
Permit number
Date issued
/ 7
Impacted wetland? (Y)es/(N)o
Mitigation bank? (Y)es/(N)o
Name of the bank
(M)oney / (L)and
If the answer to Mitigation bank? was NO, the following screens will appear.
SCREEN 3
(C)reated/(E)nhanced/(P)reserved/(R)estored
State County
Area
0.0
State County
Area
0.0
Township & Range
Section(s)
Latitude
Longitude
USGS/NWI map name
Scale
1:
0
(W)ater body / (R)iver body
Water/riverbody name
Specific location
111
-------
SCREEN 4
Was the mitigation project (OFF)-site or (ON)-site?
Land use
(A)gricultural / (C)ommercial / (l)ndustrial / (N)atural / (R)esidential
Documents available
(M)aps (B)lue prints
(G)round photos (A)erial photos
Date construction began 1 I
Date construction completed / /
Were mid-course corrections made? (Y)es/(N)o
SCREEN 5
CODE COWARDIN WETLAND TYPE SELECTED AREA
E1AB
ESTUARINE SUBTIDAL AQUATIC BED
0.0
E1BB
ESTUARINE SUBTIDAL OPEN WATER
0.0
E1RF
ESTU
0.0
E1RB
ESTU
Enter the area in acres 0.0 IrOM
0.0
E1UB
ESTU
0.0
E2AB
ESTUARINE INTERTIDAL AQUATIC BED
0.0
E2BB
ESTUARINE INTERTIDAL BEACH/BAR
0.0
E2EM
ESTUARINE INTERTIDAL EMERGENT
0.0
E2FL
ESTUARINE INTERTIDAL FLAT
0.0
E2FO
ESTUARINE INTERTIDAL FORESTED
0.0
U]
112
-------
SCREEN 6
CODE OBJECTIVE SELECTED
FUNC
1:1 FUNCTIONAL REPLACEMENT
ACTV
ACTIVE RECREATION
CONS
CONSUMPTIVE RECREATION
FLOD
FLOOD STORAGE
FOOD
FOOD CHAIN SUPPORT
GRWT
GROUND WATER MODIFICATION
ENDS
HABITAT FOR ENDANGERED SPECIES
FISH
HABITAT FOR FISHERIES
WILD
HABITAT FOR WILDLIFE
MOSQ
MOSQUITO ABATEMENT
NONC
NON-CONSUMPTIVE RECREATION
NURS
NURSERY FOR MITIGATION PLANTS
SCREEN 7
ENDANGERED SPECIES
Scientific name
Common name
Scientific name
Common name
Scientific name
Common name
113
-------
SCREEN 8
CODE METHOD SELECTED
ABAL
ABALONE PLANTING
CHAN
CHANNELS CUT
DIKE
DIKE BREACHING
HYDR
ESTABLISH PROPER HYDROLOGY
EXCA
EXCAVATION
FENC
FENCING
FILL
FILL
GRAD
GRADING
REGR
NATURAL REGROWTH
OTHR
OTHER
U]
SCREEN 9
INFORMATION ON MONITORING
Do construction plans exist? (Y)es/(N)o
Were checks made regularly? (Y)es/(N)o
Were checks made irregularly? (Y)es/(N)o
Were data collected? (Y)es/(N)o
114
-------
If the answer to Were data collected? was YES, the following screens will appear.
Go to page 116 for the screens that will appear if the answer was NO.
SCREEN 10
CODE ITEMS MONITORED SELECTED
ANDE
ANIMAL DENSITY
ANDI
ANIMAL DIVERSITY
ANUS
ANIMAL USE
ENSP
ENDANGERED SPECIES
OTHR
OTHER
PHVI
PHYSICAL VIABILITY
PLDI
PLANT DIVERSITY
PRPR
PRIMARY PRODUCTION
SEPR
SECONDARY PRODUCTION
VECO
VEGETATIVE COVER
WAQU
WATER QUALITY
WATA
WATER TABLE DEPTH
U]
SCREEN 11
REPORT INFORMATION
Title
Author's initials . . Author's last name
Year 0 Source
Content
SCREEN 12
CONTACT INFORMATION
Contact's initials . . Contact's last name
Organization
Address
City State Zip
Phone ( )
115
-------
SCREEN 13
UDF_DATE1: f /
UDF_DATE2: j f
UDF_DATE3: / /
UDF_NUM1: 0.0
UDF_NUM2: 0-0
UDF_NUM3: 0.0
UDF_YN1: (Y)es/(N)o
UDF_YN2: (Y)es/(N)o
UDF_YN3: (Y)es/(N)o
UDF_YN4: (Y)es/(N)o
UDF_CHAR1:
UDF_CHAR2:
UDF_CHAR3:
UDF_CHAR4:
UDF_CHAR5:
UDF_CHAR6:
If the answer to Were data collected? was NO, the following screens will appear.
SCREEN 10
REPORT" INFORMATION
Title
Author's initials * , Author's last name
Year 0 Source
Content
116
-------
SCREEN 11
CONTACT INFORMATION
Contact's initials
* Contact's last name
Organization
Address
City
State Zip - Phone ( )
SCREEN 12
UDF_DATE1: / /
UDF_DATE2: / f UDF_DATE3: I /
UDF_NUM1: 0.0
UDF_NUM2: 0.0 UDF_NUM3: 0.0
UDF_YN1: (Y)es/(N)o
UDF_YN2: (Y)es/(N)o
UDF_YN3: (Y)es/(N)o
UDF_YN4: (Y)es/(N)o
UDF_CHAR1:
UDF_CHAR2:
UDF_CHAR3:
UDF_CHAR4:
UDF_CHAR5:
UDF_CHAR6:,
-------
118
-------
APPENDIX D
LIST OF CODES
119
-------
120
-------
COWARDIN WETLAND TYPES . . .
CODE FULLNAME
E1AB Estuarine subtidal aquatic bed
E10W Estuarine subtidal open water
E1RF Estuarine subtidal reef
E1RB Estuarine subtidal rock bottom
E1UB Estuarine subtidal unconsolidated bottom
E2AB Estuarine intertidal aquatic bed
E2BB Estuarine intertidal beach/bar
E2EM Estuarine intertidal emergent
E2FL Estuarine intertidal flat
E2FO Estuarine intertidal forested
E2RF Estuarine intertidal reef
E2RS Estuarine intertidal rocky shore
E2SS Estuanne intertidal scrub/shrub
E2SB Estuarine intertidal streambed
E2UB Estuarine intertidal unconsolidated shore
L1AB Lacustrine limnetic aquatic bed
L10W Lacustrine limnetic open water
L1RB Lacustrine limnetic rock bottom
L1UB Lacustrine limnetic unconsolidated bottom
L2AB Lacustrine littoral aquatic bed
L2BB Lacustrine littoral beach/bar
L2EM Lacustrine littoral emergent
L2FL Lacustrine littoral flat
L20W Lacustrine littoral open water
L2RB Lacustrine littoral rock bottom
L2RS Lacustrine littoral rocky shore
L2UB Lacustrine littoral unconsolidated bottom
L2US Lacustrine littoral unconsolidated shore
M1 AB Manne subtidal aquatic bed
M1OW Manne subtidal open water
M1RF Manne subtidal reef
M1 RB Marine subtidal rock bottom
M1 UB Marine subtidal unconsolidated bottom
M2AB Marine intertidal aquatic bed
M2BB Manne intertidal beach/bar
M2FL Marine intertidal flat
M2RF Marine intertidal reef
M2RS Manne intertidal rocky shore
M2US Marine intertidal unconsolidated shore
PAB Palustrine aquatic bed
PEM Palustrine emergent
PFL Palustrine flat
PFO Palustrine forested
PML Palustrine moss/lichen
POW Palustrine open water
PRB Palustrine rock bottom
PSS Palustrine scrub/shrub
PUB Palustrine unconsolidated bottom
PUS Palustrine unconsolidated shore
CODE FULLNAME
R1 AB Riverine tidal aquatic bed
R1BB Riverine tidal beach/bar
R1 EM Riverine tidal emergent
R1FL Riverine tidal flat
R1 OW Riverine tidal open water
R1 RB Rivenne tidal rock bottom
R1RS Riverine tidal rocky shore
R1 SB Riverine tidal streambed
R1 UB Riverine tidal unconsol. bottom
R1 US Riverine tidal unconsol. shore
R2AB Riverine lower perennial aquatic bed
R2BB Riverine lower perennial beach/bar
R2EM Riverine lower perennial emergent
R2FL Riverine lower perennial flat
R20W Riverine lower perennial open water
R2RB Riverine lower perennial rock bottom
R2RS Riverine lower perennial rocky shore
R2SB Rivenne lower perennial streambed
R2UB Riverine lower perennial unconsol. bottom
R2US Riverine lower perennial unconsol. shore
R3AB Riverine upper perennial aquatic bed
R3BB Riverine upper perennial beach/bar
R3FL Riverine upper perennial flat
R30W Riverine upper perennial open water
R3RB Riverine upper perennial rock bottom
R3RS Riverine upper perennial rocky shore
R3SB Riverine upper perennial streambed
R3UB Riverine upper perennial unconsol. bottom
R3US Riverine upper perennial unconsol shore
R4AB Riverine intermittent aquatic bed
R4BB Riverine intermittent beach/bar
R4FL Riverine intermittent flat
R40W Riverine intermittent open water
R4RB Riverine intermittent rock bottom
R4RS Riverine intermittent rocky shore
R4SB Riverine intermittent streambed
R4UB Rivenne intermittent unconsol. bottom
R5AB Rivenne unknown perennial aquatic bed
R5BB Riverine unknown perennial beach/bar
R5FL Riverine unknown perennial flat
R50W Riverine unknown perennial open water
R5RB Riverine unknown perennial rock bottom
R5RS Riverine unknown perennial rocky shore
R5SB Riverine unknown perennial streambed
R5UB Rivenne unknown perennial unconsol. bottom
R5US Riverine unknown perennial unconsol shore
121
-------
TYPES OF PROJECTS . . .
CQDE
FULLNAME
AIRP
Airport
AQUA
Aquaculture
RAMP
Boat ramp
COMM
Commercial project
DAMS
Dam or reservoir
DIKE
Dike placement
DRAI
Drainage ditch
DDIS
Dredge disposal
DREG
Dredging
FARM
Farming activity
ROAD
Highway, road, or bridge
HOUS
Housing development
HYDR
Hydroelectric project
INDS
Industrial park
JETT
Jetty or groin
MARN
Marina
MINE
Mining
MOSQ
Mosquito abatement
NAVI
Navigation channel, canal, or boat basin
OILG
Oil and gas activities
OTHR
Other
PIPL
Pipeline
DOCK
Private dock or moorage
RAIL
Railroad
RECR
Recreational area
SHIP
Shipping wharf, dock, or pier
STAB
Shore stabilization
WDIS
Solid waste disposal
SMOD
Stream modification
TIDE
Tide gate
UTIL
Utility
WELL
Well drilling pad
WILD
Wildlife habitat
122
-------
WETLAND FUNCTIONS .
COPE
FULLNAME
ACTV
Active recreation
CONS
Consumptive recreation
FLOD
Flood storage
FOOD
Food chain support
ENDS
Habitat for endangered species
FISH
Habitat for fisheries
WILD
Habitat for wildlife
GRWT
Ground water modification
NONC
Non-consumptive recreation
NUTR
Nutrient retention and removal
OTHR
Other
PASS
Passive recreation
SEDI
Sediment trapping
SHOR
Shoreline stabilization
RARE
Uniqueness or rareness
123
-------
OBJECTIVES
CODE
FULLNAME
FUNC
1:1 functional replacement
ACTV
Active recreation
CONS
Consumptive recreation
FLOD
Flood storage
FOOD
Food chain support
GRWT
Ground water modification
ENDS
Habitat for endangered species
FISH
Habitat for fisheries
WILD
Habitat for wildlife
MOSQ
Mosquito abatement
NONC
Non-consumptive recreation
NURS
Nursery for mitigation plants
NUTR
Nutrient retention and removal
OTHR
Other
PASS
Passive recreation
RESR
Research
SEDI
Sediment trapping
SHOR
Shoreline stabilization
UNIQ
Unique or rare systems replacement
RARE
Uniqueness or rareness
124
-------
METHODS .
CODE
FULLNAME
ABAL
Abalone planting
CHAN
Channels cut
DIKE
Dike breaching
HYDR
Establish proper hydrology
EXCA
Excavation
FENC
Fencing
FILL
Fill
GRAD
Grading
REGR
Natural regrowth
OTHR
Other
PLAN
Planting
PRES
Preservations
SEED
Seeding
SOIL
Soil enhancement
FLOW
Upstream flows
WAVE
Wave protection
125
-------
ITEMS MONITORED .
CODE
FULLNAME
ANDE
Animal density
ANDI
Animal diversity
ANUS
Animal use
ENSP
Endangered species
OTHR
Other
PHVI
Physical viability
PLDI
Plant diversity
PRPR
Primary production
SEPR
Secondary production
VECO
Vegetative cover
WAQU
Water quality
WATA
Water table depth
126
-------
APPENDIX E
FIELD DESCRIPTIONS
127
-------
128
-------
FIELD
FIELD DESCRIPTION
PERMIT
Permit number
DATE ISS
Date the permit was issued
I
Impacted wetland?
CASE
Type of compensatory mitigation
COMP MIT
Permits requiring compensatory mitigation
MIT BANK
Mitigation bank?
BANK NAME
Name of the mitigation bank
MONEY LAND
Mitigation bank involved money or land?
STATE
Stale in which the wetland is located
COUNTY
County in which the wetland is located
AREA
Total area of the wetland
TOWN RANG
Township and range
SECTIONS
Section(s)
LAT LONG
Latitude and longitude
MAPNAME
USGS or NW1 map name
SCALE
Scale of the map
BODYTYPE
Water body or river body?
BODYNAME
Name of the water body or river body
LOCATION
Specific location of the wetland
OFF ON
Off-site or on-site?
LAND USE
Primary land use
MAPS
Maps available
BLUEPRINTS
Blueprints available
GRND PHOTO
Ground photos available
AIR PHOTO
Aerial photos available
DATE BEGAN
Date construction began
DATE COMP
Date construction completed
CORRECTION
Were mid-course corrections made?
WET TYPE
Wetland type
WA
Area of each wetland type
PROJECT
Project types
FUNCTION
Functions of the impacted wetland
OBJECTIVE
Objectives of the compensatory wetland
METHOD
Construction methods
ENDSP SCI
Scientific name of endangered species
ENDSP COM
Common name of endangered species
TITLE
Report title
AUTHOR
Author of report
YEAR
Year report was published
SOURCE
Source from which report may be obtained
CONTENT
Content of the report
CONTACT
Primary contact
ORGANIZA
Contact's organization
ADDRESS
Contact's address
CITY
City in which contact is located
ST
State in which contact is located
ZIP
Contact's zip code
PHONE
Contact's phone number
AS BUILT
Do as-built construction plans exist?
CHECK REG
Were checks made regularly?
CHECK IREG
Were checks made irregularly?
DATA COLL
Were data collected?
MONITOR
Items monitored
UDF DATE
User defined field-date
UDF NUM
User defined field-numeric
UDF YN
User defined field-yes or no
UDF CHAR
User defined field-character
129
-------
130
-------
APPENDIX F
EXAMPLES OF SELECTED QUERIES
131
-------
132
-------
Examples of selected queries
A sample database (CA404.dbf) containing information from 20 permits is
included with the PTS and is loaded onto your computer when the PTS is installed.
Use this database to perform the following queries to make sure you understand the
query process. Refer to Accessing the Query Component of the PTS (Page 47), if you
have forgotten how to access the query program and select a database to be queried.
1. What is the frequency of occurrence of impacted and compensatory
(created, enhanced, preserved, or restored) wetlands in each county?
CLEAR
Clear Enter Run Filter View Save Print Quit ||
Clear the query worksheet H
Position the highlighted box over CLEAR and press [Enter], OR press C.
ENTER
Clear Enter Run Filter View Save Print Quit I
Select fields to be used in a query |j
«®- Position the highlighted box over ENTER and press [Enter], OR press E.
133
-------
I SELECTED
QRY_FIELD
F
PERMIT
Permit number
F
DATE ISS
Date permit was issued
F
I
Impacted wetland?
F
CASE
Type of compensatory mitigation
F
COMP MIT
Permits requiring compensatory mitigation
F
MIT BANK
Mitigation bank?
F
BANK NAME
Name of mitigation bank
F
MONEY LAND
Mitigation bank involved money or land?
F
STATE
State in which wetland is located
F
COUNTY
County in which wetland is located
F
AREA
Total area of the wetland
F
TOWN RANG
Township and range
F
SECTIONS
Sections
F
LAT LONG
Latitude and longitude
F
MAPNAME
USGS or NWI map name
F
SCALE
Scale of map
m m
Press [Enter] to select/deselect the fields to be used THEN
Press [Esc] to continue.
\ /
Position the highlighted box over CASE and press [Enter] to select all the
cases (i.e., Impacted, Created, Enhanced, Preserved, and Restored).
Position the highlighted box over COUNTY and press [Enter] to select all the
counties listed in the database.
134
-------
id SELECTED
QRY_FIELD
I p
PERMIT
Permit number
1 F
DATE ISS
Date permit was issued
1 F
1
Impacted wetland?
1 T
CASE
Type of compensatory mitigation
11 F
COMP MIT
Permits requiring compensatory mitigation
1 ^
MIT BANK
Mitigation bank?
1 F
BANK NAME
Name of mitigation bank
1 F
MONEY LAND
Mitigation bank involved money or land?
1 F
STATE
State in which wetland is located
III T
COUNTY
County in which wetland is located
B F
AREA
Total area of the wetland
1 ^
TOWN RANG
Township and range
[I F
SECTIONS
Sections
1 F
LAT LONG
Latitude and longitude
1 F
MAPNAME
USGS or NWI map name
1 F
SCALE
Scale of map
M [=>]
Press [Enter] to select/deselect the fields to be used THEN
Press [Esc] to continue.
Press [Esc].
135
-------
CASE TF CASE
COUNTY TF COUNTY
CREATED
ENHANCED
IMPACTED
PRESERVED
RESTORED
ALAMEDA
CONTRA COSTA
MARIN
MONTEREY
NAPA
SAN MATEO
SANTA CLARA
SANTA CRUZ
SOLANO
SONOMA
M M
Press [Enter] to select/deselect items. Press [Enter] over the empty box
In the 1st row to select ALL the items In that column. Press [Esc] to continue.
Position the highlighted box over the empty space in the first row under the
CASE field and press [Enter] to select all the cases. The first F under the
CASE_TF field will change to a T to indicate all cases have been selected.
Position the highlighted box over the empty space in the first row under the
COUNTY field and press [Enter] to select all the counties. The first F under the
COUNTY_TF field will change to a T to indicate all counties have been
selected.
136
-------
J CASE_TF CASE
COUNTY_TF COUNTY
1 F CREATED
T
F ALAMEDA
1 F ENHANCED
F CONTRA COSTA
1 F IMPACTED
F MARIN
1 F PRESERVED
F MONTEREY
I F RESTORED
F NAPA
I F
F SAN MATEO
1 F
F SANTA CLARA
I F
F SANTA CRUZ
1 F
F SOLANO
1
F SONOMA
Ul M
Press [Enter] to select/deselect items. Press [Enter] over the empty box
in the 1st row to select ALL the items in that column. Press [Esc] to continue.
Press [Esc].
Clear Enter Run Filter View Save Print Quit
Process the query
Position the highlighted box over RUN and press [Enter], OR press R.
Query the database by permit? (Y)es/(N)o N
Since we want to know how many wetlands are located in each county, we would
query the database by wetland.
ra- Press N and press [Enter].
Generate a detail file? (Y)es/(N)o N
137
-------
Since we are only interested in the results of the query, and not the supporting
information, we do not want to generate a detail file.
«¦ Press N and press [Enter].
Process the query? (Y)es/(N)o N
Press Y to process the query.
Process the query? (Y)es/(N)o Y
i®* Press [Enter].
FILTER
Clear Enter Run Filter View Save Print Quit
Remove all totals with counts equal to zero
Since we only want to view the results that met the query specifications, we would filter
the results.
Position the highlighted box over FILTER and press [Enter], OR press F.
Clear Enter
Run Filter View Save
View the results of a query
Totals
Details
i®" Position the highlighted box over VIEW and press [Enter], OR press V to view
the results worksheet.
138
-------
Position the highlighted box over TOTALS and press [Enter], OR press T and
press [Enter] to view the results worksheet.
The results worksheet will appear as illustrated below.
CASE
COUNTY
COUNT
ACRES
HECTARES
C
MARIN
2
53.4
21.6
c
SAN MATEO
1
1.5
0.6
c
SOLANO
1
0.2
0.1
E
SAN MATEO
1
5.2
2.1
E
SANTA CRUZ
1
7.5
3.0
E
SONOMA
1
1.0
0.4
I
ALAMEDA
2
75.5
30.6
I
CONTRA COSTA
1
1.0
0.4
I
MARIN
8
303.9
123.0
I
MONTEREY
1
114.0
46.1
I
NAPA
1
300.0
121.4
I
SAN MATEO
3
57.0
23.1
I
SANTA CLARA
1
8.0
3.2
I
SOLANO
2
5.2
2.1
I
SONOMA
2
5.5
2.2
P
MARIN
2
13.3
5.4
Wl [=>]
Press [Esc] to return to the main menu.
139
-------
2. What is the frequency of occurrence of project types listed as
impacting wetlands?
CLEAR
Clear Enter Run Filter View Save Print Quit m
Clear the query worksheet I
ra- Position the highlighted box over CLEAR and press [Enter], OR press C.
ENTER
Clear Enter Run Filter View Save Print Quit m
Select fields to be used in a query Si
ra- Position the highlighted box over ENTER and press [Enter], OR press E.
140
-------
SELECTED
QRY_FIELD
F
PERMIT
Permit number
F
DATE ISS
Date permit was issued
F
I
Impacted wetland?
F
CASE
Type of compensatory mitigation
F
COMP MIT
Permits requiring compensatory mitigation
F
MIT BANK
Mitigation bank?
F
BANK NAME
Name of mitigation bank
F
MONEY LAND
Mitigation bank involved money or land?
F
STATE
State in which wetland is located
COUNTY
County in which wetland is located
F
AREA
Total area of the wetland
F
TOWN RANG
Township and range
F
SECTIONS
Sections
F
LAT LONG
Latitude and longitude
F
MAPNAME
USGS or NWI map name
F
SCALE
Scale of map
I
U! M
I
PROJECT
I
Project types (MULTIPLE)
Press [Enter] to select/deselect the fields to be used THEN
Press [Esc] to continue.
ear Position the highlighted box over 1 (Impacted wetland?) and press [Enter] to
select all the impacted wetlands.
Position the highlighted box over PROJECT and press [Enter] to select alt the
project types.
MULTIPLE? N
Since we want to know the exact combination of projects listed in the permits, we
would perform a multiple query.
Press Y to perform a multiple query.
141
-------
I MULTIPLE? V
BbS5®S^S^SBBBBB8
Press [Enter].
EXACT? N
Since we want to know the exact combination of projects listed in the permits, we
would perform an exact query.
Press Y to perform an exact query.
I EXACT? Y
r iiiimiiiiiiiiiiiiiiiiiiiimiiiiiiiimm
Press [Enter].
142
-------
I SELECTED
QRY_FIELD
I F
PERMIT
Permit number
1 F
DATE ISS
Date permit was issued
1 T
1
Impacted wetland?
H F
CASE
Type of compensatory mitigation
1 f
COMP MIT
Permits requiring compensatory mitigation
1 f
MIT BANK
Mitigation bank?
1 F
BANK NAME
Name of mitigation bank
F
MONEY LAND
Mitigation bank involved money or land?
F
STATE
State in which wetland is located
F
COUNTY
County in which wetland is located
1 F
AREA
Total area of the wetland
I F
TOWN RANG
Township and range
1 F
SECTIONS
Sections
1 F
LAT LONG
Latitude and longitude
I F
MAPNAME
USGS or NWI map name
I
SCALE
1
Scale of map
I
I T
Y
PROJECT
T
Project types (MULTIPLE)
m [=>]
Press {Enter] to select/deselect the fields to be used THEN
Press [Esc] to continue.
Press [Esc].
143
-------
IJT
I
PROJECTJF PROJECT
F
F
N
F
F AQUACULTURE
F
Y
F COMMERCIAL PROJECT
F
F DREDGE DISPOSAL
F
F PRIVATE DOCK OR MOORAGE
F
F DRAINAGE DITCH
F
F DREDGING
F
F HOUSING DEVELOPMENT
F
F INDUSTRIAL PARK
F
F MARINA
F
F PIPELINE
F
F RAILROAD
F
F RECREATIONAL AREA
F
F HIGHWAY, ROAD, OR BRIDGE
F
F STREAM MODIFICATION
F
F TIDE GATE
M M
Press {Enter] to select/deselect items. Press [Enter] over the empty box
in the 1st row to select ALL the items in that column. Press [Esc] to continue.
You must scroll over to the right to see the last column.
Position the highlighted box over the Y in the I (Impacted) field and press
[Enter] to select all the impacted wetlands. The corresponding F under the
l_TF field will change to a T to indicate only impacted wetlands have been
selected.
Position the highlighted box over the empty space in the first row of the
PROJECT field and press [Enter] to select all the project types. The first F
under the PROJECT_TF field will change to a T to indicate all project types have
been selected.
144
-------
I TF
PROJECT TF PROJECT
M [=>]
AQUACULTURE
COMMERCIAL PROJECT
DREDGE DISPOSAL
PRIVATE DOCK OR MOORAGE
DRAINAGE DITCH
DREDGING
HOUSING DEVELOPMENT
INDUSTRIAL PARK
MARINA
PIPELINE
RAILROAD
RECREATIONAL AREA
HIGHWAY, ROAD, OR BRIDGE
STREAM MODIFICATION
TIDE GATE
Press [Enter] to select/deselect Hems. Press [Enter] over the empty box
in the 1st row to select ALL the Hems In that column. Press [Esc] to continue.
Press [Esc].
Clear Enter Run Filter View Save Print Quit
Process the query
Position the highlighted box over RUN and press [Enter], OR press R.
Query the database by permit? (Y)es/(N)o N
Since we want to know the project types that impacted wetlands, we would query the
database by wetland.
145
-------
ra* Press N and press [Enter].
Generate a detail file? (Y)es/(N)o N
Since we are only interested in the results of the query, and not the supporting
information, we do not want to generate a detail file.
"sp Press N and press [Enter].
Process the query? (Y)es/(N)o N
*3* Press Y to process the query.
Process the query? (Y)es/(N)o Y
*&¦ Press [Enter].
Since this is a multiple, exact query, allow up to 45 minutes for processing.
FILTER
Clear Enter Run Filter View Save Print Quit
Remove all totals with counts equal to zero
Since we only want to view the results that met the query specifications, we would filter
the results.
•s* Position the highlighted box over FILTER and press [Enter], OR press F.
146
-------
I®"
Clear Enter
Run Filter View Save
View the results of a query
Print Quit
Totals
Details
Position the highlighted box over VIEW and press [Enter], OR press V to view
the query results.
Position the highlighted box over TOTALS and press [Enter], OR press T and
press [Enter] to view the results worksheet.
The results worksheet will appear as illustrated below.
I
PROJECT1
PROJECT2 PROJECT3
COUNT
ACRES
HECTARES
Y
COMM
4
60.7
24.6
Y
DDIS
1
0.0
0.0
Y
HOUS
1
150.0
60.7
Y
INDS
14.0
5.7
Y
MARN
1
5.0
2.0
Y
RECR
1
1.0
0.4
Y
ROAD
3
76.2
30.8
Y
UTIL
1
0.2
0.1
Y
AQUA
PIPL
1
114.0
46.1
Y
DOCK
HOUS
1
99.0
40.1
Y
DREG
WDIS
1
300.0
121.4
Y
DRAI
PIPL SMOD
1
8.0
3.2
Y
INDS
RAIL TIDE
1
12.0
4.9
Y
MARN
RECR WILD
1
30.0
12.1
Hi] [=>]
Press [Esc] to return to the main menu.
147
-------
3. What were the sizes of the wetlands affected by permitting (in ten acre
increments)?
CLEAR
Clear Enter Run Filter View Save Print Quit m
Clear the query worksheet H
CT Position the highlighted box over CLEAR and press [Enter], OR press C.
E1N1TER
Clear Enter Run Filter View Save Print Quit m
Select fields to be used in a query 1
i®" Position the highlighted box over ENTER and press [Enter], OR press E.
148
-------
I SELECTED
QRY_FIELD
F
PERMIT
Permit number
F
DATE ISS
Date permit was issued
F
I
impacted wetland?
F
CASE
Type of compensatory mitigation
F
COMP MIT
Permits requiring compensatory mitigation
F
MIT BANK
Mitigation bank?
F
BANK NAME
Name of mitigation bank
F
MONEY LAND
Mitigation bank involved money or land?
F
STATE
State in which wetland is located
F
COUNTY
County in which wetland is located
F
AREA
Total area of the wetland
F
TOWN RANG
Township and range
F
SECTIONS
Sections
F
LAT LONG
Latitude and longitude
F
MAPNAME
USGS or NWI map name
F
SCALE
Scale of map
M M
Press [Enter] to select/deselect the fields to be used THEN
Press [Esc] to continue.
Position the highlighted box over CASE and press [Enter] to select all the
cases (i.e., Impacted, Created, Enhanced, Preserved, and Restored).
Position the highlighted box over AREA and press [Enter] to select all the
areas.
149
-------
I SELECTED
QRY_FIELD
F
PERMIT
Permit number
F
DATE ISS
Date permit was issued
F
I
Impacted wetland?
T
CASE
Type of compensatory mitigation
F
COMP MIT
Permits requiring compensatory mitigation
F
MIT BANK
Mitigation bank?
F
BANK NAME
Name of mitigation bank
F
MONEY LAND
Mitigation bank involved money or land?
F
STATE
State in which wetland is located
F
COUNTY
County in which wetland is located
T
AREA
Total area of the wetland
F
TOWN RANG
Township and range
F
SECTIONS
Sections
F
LAT LONG
Latitude and longitude
F
MAPNAME
USGS or NWI map name
F
SCALE
Scale of map
W M
Press [Enter] to select/deselect the fields to be used THEN
Press [Esc] to continue.
Press [Esc].
150
-------
CASE_TF CASE
AREA_L
AREA_H
J F
0.0
0.0
F CREATED
0.0
0.0
F ENHANCED
0.0
0.0
F IMPACTED
0.0
0.0
F PRESERVED
0.0
0.0
F RESTORED
0.0
0.0
F
0.0
0.0
F
0.0
0.0
F
0.0
0.0
F
0.0
0.0
F
0.0
0.0
F
0.0
0.0
F
0.0
0.0
F
0.0
0.0
Ill] [=•]
Press [Enter] to select/deselect items. Press {Enter] over the empty box
in the 1st row to select ALL the items in that column. Press [Esc] to continue.
Position the highlighted box over the empty space in the first row under the
CASE field and press [Enter] to select all the cases. The first F under the
CASE_TF field will change to a T to indicate all cases have been selected.
Enter the areas listed on the next page in the area range fields to obtain results
in ten acre increments. You could also enter other area increments depending
upon how you wanted to see the data arranged.
151
-------
CASE_TF CASE
AREA_L
AREA_H
I T
-1.0
10.0
F CREATED
10.0
20.0
F ENHANCED
20.0
30.0
F IMPACTED
30.0
40.0
F PRESERVED
40.0
50.0
F RESTORED
50.0
60.0
F
60.0
70.0
F
70.0
80.0
F
80.0
90.0
F
90.0
100.0
F
F
F
F
100.0
9999.0
W [=>]
Press [Enter] to select/deselect Items, Press [Enter] over the empty box
in the 1st row to select ALL the Items In that column. Press [Esc] to continue.
¦a* Press [Esc].
Clear Enter Run Filter View Save Print Quit
Process the query
ra* Position the highlighted box over RUN and press [Enter], OR press R.
Query the database by permit? (Y)es/(N)o N
Since we want to know the impacted and compensatory (created, enhanced,
preserved, or restored) wetland area, we would query the database by wetland.
152
-------
i®" Press N and press [Enter].
Generate a detail file? (Y)es/(N)o N
Since we are only interested in the results of the query, and not the supporting
information, we do not want to generate a detail file.
«* Press N and press [Enter].
Process the query? (Y)es/(N)o N
ra- Press Y to process the query.
Process the query? (Y)es/(N)o Y
«3P Press [Enter].
FILTER
Clear Enter Run Filter View Save Print Quit
Remove all totals with counts equal to zero
i
Since we only want to view the results that met the query specifications, we would filter
the results.
us* Position the highlighted box over FILTER and press [Enter], OR press F.
Clear Enter Run Filter View Save Print Quit
View the results of a query
Totas
Details
153
-------
«• Position the highlighted box over VIEW and press [Enter], OR press V to view
the results worksheet.
ks* Position the highlighted box over TOTALS and press [Enter], OR press T and
press [Enter] to view the results worksheet.
The results worksheet will appear as illustrated below.
I CASE
AREA_L
AREA_H
COUNT
ACRES
HECTARES
0
-1.0
10.0
5
12.3
5.0
C
40.0
50.0
1
43.8
17.7
E
-1.0
10.0
1
1.0
0.4
E
10.0
20.0
1
12.7
5.1
I
-1.0
10.0
11
35.6
14.4
I
10.0
20.0
2
27.0
10.9
1
20.0
30.0
1
30.0
12.1
1
30.0
40.0
1
39.0
15.8
1
70.0
80.0
1
75.5
30.6
1
90.0
100.0
1
99.0
40.1
1
100.0
9999.0
3
564.0
228.3
P
-1.0
10.0
3
8.8
3.6
P
10.0
20.0
1
13.0
5.3
R
40.0
50.0
1
50.0
20.2
R
90.0
100.0
1
100.0
40.5
R
100.0
9999.0
3
388.0
157.0
m [=>]
Press [Esc] to return to the main menu.
154
-------
4. In what years were the permits requiring compensatory mitigation
issued?
CLEAR
Clear Enter Run Filter View Save Print Quit m
Clear the query worksheet I
Position the highlighted box over CLEAR and press [Enter], OR press C.
ENTER
is* Position the highlighted box over ENTER and press [Enter], OR press E.
Clear
Select fields to be used in a query
155
-------
|SELECTED
QRY_FIELD
F
PERMIT
Permit number
I F
DATE ISS
Date permit was issued
I F
I
Impacted wetland?
I F
CASE
Type of compensatory mitigation
I F
COMP MIT
Permits requiring compensatory mitigation
I F
MIT BANK
Mitigation bank?
I F
BANK NAME
Name of mitigation bank
I F
MONEY LAND
Mitigation bank involved money or land?
I F
STATE
State in which wetland is located
I F
COUNTY
County in which wetland is located
I F
AREA
Total area of the wetland
F
TOWN RANG
Township and range
I F
SECTIONS
Sections
I F
LAT LONG
Latitude and longitude
I F
MAPNAME
USGS or NWI map name
I F
SCALE
Scale of map
M Is*]
Press [Enter] to select/deselect the fields to be used THEN
Press [Esc] to continue.
Position the highlighted box over DATEJSS and press [Enter] to select the
dates the permits were issued.
Position the highlighted box over COMP_MIT and press [Enter] to select the
permits requiring compensatory mitigation.
156
-------
I SELECTED
QRY_FIELD
F
PERMIT
Permit number
T
DATE ISS
Date permit was issued
F
1
Impacted wetland?
F
CASE
Type of compensatory mitigation
T
COMP MIT
Permits requiring compensatory mitigation
F
MIT BANK
Mitigation bank?
F
BANK NAME
Name of mitigation bank
F
MONEY LAND
Mitigation bank involved money or land?
F
STATE
State in which wetland is located
F
COUNTY
County in which wetland is located
F
AREA
Total area of the wetland
F
TOWN RANG
Township and range
F
SECTIONS
Sections
F
LAT LONG
Latitude and longitude
F
MAPNAME
USGS or NWI map name
F
SCALE
Scale of map
W [=>]
Press [Enter] to select/deselect the fields to be used THEN
Press [Esc] to continue.
Press [Esc].
157
-------
DATE ISS L DATE ISS H
COMPMIT TF COMP MIT
N
Y
Press [Enter] to select/deselect items. Press [Enter] over the empty box
in the 1st row to select ALL the Kerns in that column. Press [Esc] to continue.
Enter the dates listed on the next page in the date range fields to obtain results
in one year increments. You could also enter other date increments depending
upon how you wanted to see the data arranged.
Position the highlighted box over the Y in the COMP_MIT field and press
[Enter], The corresponding F will change to a T to indicate that only the
permits requiring compensatory mitigation have been selected.
158
-------
|| DATE_ISS_L
DATE_ISS_H
COMPMITJF COMP_MIT
II 12/31/75
12/31/76
F
¦ 12/31/76
12/31/77
F N
Ml 12/31/77
12/31/78
T Y
¦ 12/31/78
12/31/79
F
¦ 12/31/79
12/31/80
F
¦ 12/31/80
12/31/81
F
¦ 12/31/81
12/31/82
F
H 12/31/82
12/31/83
F
II 12/31/83
12/31/84
F
¦ 12/31/84
12/31/85
F
H 12/31/85
12/31/86
F
H 12/31/86
12/31/87
F
B 12/31/87
12/31/88
F
¦ 12/31/88
12/31/89
F
•V. V 'a/,? /a f W/ ' r
¦
m [=>]
Press [Enter] to select/deselect Items. Press [Enter] over the empty box
In the 1st row to select ALL the Items In that column. Press [Esc] to continue.
** Press [Esc].
Clear Enter Run Filter View Save Print Quit
Process the query
Position the highlighted box over RUN and press [Enter], OR press R.
Query the database by permit? (Y)es/(N)o N
Since we want to know how many permits requiring compensatory mitigation were
issued each year, we would query the database by permit.
Press Y to query the database by permit.
159
-------
Query the database by permit? (Y)es/(N)o Y
"«* Press [Enter].
Generate a detail file? (Y)es/(N)o N
Since we are only interested in the results of the query, and not the supporting
information, we do not want to generate a detail file.
^ Press N and press [Enter].
Process the query? (Y)es/(N)o N
Press Y to process the query.
Process the query? (Y)es/(N)o Y 1
m\
"3- Press [Enter].
FILTER
Clear Enter Run Filter View Save Print Quit
Remove all totals with counts equal to zero
Since we only want to view the results that met the query specifications, we would filter
the results.
w Position the highlighted box over FILTER and press [Enter], OR press F.
160
-------
Clear Enter
Run Filter View Save Print Quit
View the results of a query
Totals
Details
Position the highlighted box over VIEW and press [Enter], OR press V to view
the results worksheet.
ra* Position the highlighted box over TOTALS and press [Enter], OR press T and
press [Enter] to view the results worksheet.
The results worksheet will appear as illustrated below.
DATE_ISS_L
DATE_ISS_H
O
O
2
l~°
2
H
COUNT ACRES HECTARES
I 12/31/75
12/31/76
Y
1
0.4
0.2
12/31/76
12/31/77
Y
2
16.4
6.6
12/31/78
12/31/79
Y
1
123.0
49.8
12/31/79
12/31/80
Y
2
454.0
183.7
12/31/80
12/31/81
Y
1
82.8
33.5
12/31/81
12/31/82
Y
3
490.2
198.4
12/31/85
12/31/86
Y
1
12.7
5.1
12/31/86
12/31/87
Y
3
142.5
57.7
12/31/87
12/31/88
Y
1
13.5
5.5
U1 [=>]
Press [Esc] to return to the main menu.
161
-------
Pejlrift^aiekih^
; Version 4.0- .
y">
"> ." I t"M% $ j
^Hobert-G-Gibson.' Programmer I SSS3^
pManTechEnvr Tecfi]- Inc:—
&WH 00HWALU3 ENVIRONMENTAL RESEARCH UBORATORT"*"^
J.'B I. U.3. EtMROHUSNTH. PROTECTION AGE/JCV. .. -El
200 aw asm street, coawuis, or 97333 ¦ < " V ^SSI?
^ < ^DISK.#1
-------
;-r^
,. 1 J* ' J. —X
t; -4 0:
, ,v ,
v-:s
^iMtPJEracking System
-a""" - .v - .y,t0!r«V —
^VersionJ.O- ^ ^^
S^Robert^rTGibsornvgrogrammerl^^f^^-
j^L>a?-ManTech-Env Tech.V inc. '
Sffl-g
l-Vill T *
COflVAlllS ENVIRONMENTAL RESEARCH LABORATORY
S JNVIAONMENTAL'PROTECTON AGENCY , *
200 SW 35TH STREET CORVAUJS.-OR 97333- J ' ,
^S^£3^DISK3#2r
rt T"*&.
-------
t
A" . "> . •.
^r\
1 . • : 1. l.-=._t..'jh.—
»"""** "" '*" "^*'V 7*V"" 5"^*•"'j '"'«rf~* ''
-* . *, y^-i>agwTORY^._JJC_.^- J
B JStZS*mKS I US EWlf^MENTAi PfOTECTlON"AGENCY"*'1' ,'. ' ' ': 'I
• ' mow. '-' YllIX" 200 S.W-35TH STREETrCOfiVAU-tS. OR 97333 ' ., - '" I
mi* hfr .yltl. ..»,> 1-11. .jj», jwv • ^*V f V
in
------- |