NAS Database

Relational Structure:

SPECIMENS

specimen_ID	AutoNumber	unique number for this specimen
item_numb	Number	NAS item number from old system
species_ID	Number	unique species number
Site_ID	Number	unique site number
collection_ID	Number	unique collection number
Collection_ID_OLD	Text	old collection number
no_collected	Number	number of specimens collected
No_released	Number	number released
No_preserved	Number	number preserved
No_dead	Number	number dead
No_juveniles	Number	number of juveniles collected
No_females	Number	number of females collected
No_breedfemales	Number	number of breeding females collected
No_breedmales	Number	number of breeding males collected
Museum_Cat_No	Text	museum catalog number
Verifier	Text	person who verified the identification
YearVerified	Number	year the specimen was verified
Previously_determined	Text (120)	Previous taxonomic determination
Native_Introduced	Text	native or introduced to this location: Native, Introduced, Unknown
Status	Text	reproductive status of the population: established, persisting, collected, reported, extirpated, failed, eradicated
Comments	Memo	comments about this specimen
Container_Type	Text	container where specimen is stored: jar; vial; tub
date_entered	Date/Time	date current record is first entered
entered_by	Text	initials of person entering current record
date_last_change	Date/Time	timestamp of last change to curent record
year_class	Text	adult juvenile fry
size	Text	specimen size
disposal	Text	fate of specimen; deposited in museum, eaten, released, etc.; for Plants name of herberium
pathway	Text	Method of introduction; type_intro in tbl_NAS
no_stocked	Text	number of individuals stocked or released
agency	Text	agency responsible for introduction
stock_source	Text	place where species came from most recently
contact	Text	contact person for this record
ref_1	Number	published reference that is source for this record
ref_2	Number	additional supporting published references; or refs mentioned in ref_1
ref_3	Number	additional supporting published references; or refs mentioned in ref_1 or ref_2
fresh_marine_intro	Text	introduced into fresh or marine waters?
impact	Memo	known impacts of this introduced species at this site
Record_type	Text (25)	Type of record (based on source): specimen; literature; personal communication; database
Reproductive_status	Text (20)	Reproductive status of collected plant: flower; fruit; flower and fruit; spore bearing; vegetative
Plant_ID_notes	Text (250)	Characters used to identify plant

SITES

site_ID	AutoNumber	Unique number to identify site
GISLatDD	Number	Decimal Degree Latitude in GIS system
GISLongDD	Number	Decimal Degree Longitude in GIS system
latitude	Text	degrees minutes seconds (imported from NAS)
LatDegree	Number	record best position from actual collector GPS reading or map interpretation, can be different from Sites table GISLatitude
LatMinute	Number	record best position from actual collector GPS reading or map interpretation, can be different from Sites table GISLatitude
LatSecond	Number	record best position from actual collector GPS reading or map interpretation, can be different from Sites table GISLatitude
LatNS	Text	Degrees north or south latitude
longitude	Text	degrees minutes seconds (imported from NAS)
LongDegree	Number	record best position from actual collector GPS reading or map interpretation, can be different from Sites table GISLatitude
LongMinute	Number	record best position from actual collector GPS reading or map interpretation, can be different from Sites table GISLatitude
LongSecond	Number	record best position from actual collector GPS reading or map interpretation, can be different from Sites table GISLatitude
LongEW	Text	Degrees east or west longitude
Lat/Long Source	Text (20)	Source of coordinates (GPS reading; map derived; GNIS)
UTMeasting	Number	Universal Transverse Mercator easting
UTMnorthing	Number	Universal Transverse Mercator northing
UTMzone	Number	Universal Transverse Mercator zone
Country	Text	Country of occurrence; on borders, list each with a hyphen between names; query using *name* to include all borderline collections
State	Text	State of occurrence; on borders, list each with a hyphen between names; query using *name* to include all borderline collections
County	Text	County of occurrence; on borders, list each with a hyphen between names; query using *name* to include all borderline collections
fips	Number	Unique 5 digit number for state and county
Waterbody	Text	Name of waterbody where collection was made, use "unnamed tributary to next named waterbody" for unknown
waterbody_size	Text	waterbody size in acres
Locality	Text	verbal description of site, ca = about, SR = state route, mi = miles, jnct = junction,
Drainage	Text	name of basin-drainage-watershed or name of next largest waterbody for estuarine/marine collections
HUC8_name	Text	drainage as hydrologic unit code 8 digit name
HUC8_number	Number	hydrologic unit code (8 digits)
HUCext_name	Text	hydrologic unit code extension name to the smallest described area
HUC_extension	Number	hydrologic unit code extension (number of digits varies from state to state)
Collection_ID	Text	field number where site location information is described
Quadrangle	Text	US Geological Survey 7.5 minute quadrangle name
Township	Text	township number and bearing (i.e., 23 N)
Range	Text	range number and bearing (i.e., 12 W)
Section	Text	section number and quarter section (i.e., 36 NE)
Site_Access	Text	how sample site was accessed (i.e., foot, boat, at boat ramp)
Remarks	Memo	notes that pertain to location only
Site_equals	Number	if this site is the same as another what is the SiteID for that other site.
GISCODE	Number	the precision of the location information, state=1, county=2, drainage=3, point=4, state and drainage=6, county and drainage=7, state and lake=8, county and lake=9, state and linear=10, county and linear=11, bay=12, area of county=13, area of state=14
Protected_area	Text 20	Combo box (Yes-Federal; Yes-Other; No (default))

SPECIES

species_ID	AutoNumber	arbitrary unique number (because not all have ITIS numbers yet)
ITIS Number	Number	Taxonomic serial number (TSN) from ITIS
Group	Text	Algae, Annelids, Bryozoans, Jellyfish, Fishes, Crabs, Bivalves, Snails, Tunicates, Plants, Sponges (see complete list)
Order	Text	Taxonomic order - according to ITIS
Family	Text	Taxonomic family - according to ITIS
Genus	Text	Taxonomic genus - according to ITIS
Species	Text	Taxonomic species - according to ITIS
Subspecies	Text	Taxonomic subspecies - according to ITIS
variety	Text	for plants only
common_name	Text	commonly accepted common/vernacular name
Synonyms	Text	other scientific names
fresh_marine_brackish	Text	does species occur in fresh, marine, or brackish water in its native range
continent_of_origin	Text	continent/region of origin (native range)
native_exotic	Text	Native, exotic/foreign or cryptogenic to the US

COLLECTION

collection_ID_num	Number	field collector's number (from field notes)
collection_ID	AutoNumber	arbitrary unique number
Collection_ID_ORIG	Text (100)	Original collector/herbarium number
SiteID	Number	unique number that corresponds to site record
Project	Text	code given to project: NAS Animals, NAS Plants, EPA, Eglin
Day	Number	day of collection
Month	Number	month of collection
Year	Number	year of collection
Begin_Time	Date/Time	start time of collection
End_Time	Date/Time	ending time of collection
LatDegree	Number	Degrees of Latitude; recorded at site at time of collection
LatMinute	Number	Minutes of Latitude; recorded at site at time of collection
LatSecond	Number	Seconds of Latitude; recorded at site at time of collection
LatNS	Text	North or South latitude
LongDegree	Number	Degrees of Longitude; recorded at site at time of collection
LongMinute	Number	Minutes of Longitude; recorded at site at time of collection
LongSecond	Number	Seconds of Longitude; recorded at site at time of collection
LongEW	Text	East or West Longitude
UTM	Text	UTM position
Position_method	Text	how were coordinates obtained: map, GPS
Position_precision	Text
Collectors	Text	Names of collectors making collection
Other_Coll_Field_Nos	Text	if collection recorded by more than one collector
Gear	Text	gear used for collection: seine, electroshock, blocknet, angling
Length_Upstream	Number	distance sampled upstream
Length_Downstream	Number	distance sampled downstream
Part_Sampled	Text
Area_Sampled	Number
Electroshock_Time	Number	length of time electroshocker was used in minutes
plant_infestation_size	Text	size of area covered by non-native plant; give units

Habitat

habitat_ID	AutoNumber	unique number
collection_ID	Number	collection ID - FOREIGN KEY
Collection_ID_ORIG	Text	original collection number listed on herbarium sheet; also contains database numbers originally assigned then changed (animals)
Min_Width	Number	narrowest point sampled in meters
Max_Width	Number	widest point sampled in meters
Average_Width	Number	mean width of sampled area in meters
Max_Depth	Number	maximum depth in sampled area in meters
Capture_Depth	Number	maximum capture depth in meters
Average_Depth	Number	mean depth of sampled area in meters
Habitat_TypeI	Text	broad aquatic habitat from National Wetlands Inventory
Habitat_TypeII	Text	specific aquatic habitat
Stream_Gradient	Text	amount of drop per linear section
Sinuosity	Text	amount of curvature of stream
General_Landuse	Text	overall landuse that affects area sampled
Landuse_Description	Text	specific landuse that affects area sampled (i.e., sewage outfall, mill effluent)
Site_Condition	Text	condition of overall watershed that affects area sampled
Sediment_Smothering	Text	slightly=light dusting, moderately=up to 1 cm thick, severe=bottom homogenous silt
Tide	Text	phase of tide during sample
Moon	Text	phase of moon
Level	Text	amount of flow or water level
Appearance	Text	general color of water
Visibility	Text	water clarity; if shallow, estimate horizontal visibility
Conductivity	Number	microsiemens/cm or micromhos/cm
pH	Number	negative log10 of hydrogen-ion concentration
Salinity	Number	in parts per thousand
DO	Number	in milligrams per liter of parts per million
Turbidity	Number	in nephelometric turbidity units (NTU)
PO4	Number	in parts per million
NO4	Number	in parts per million
Air_Temp	Number	in centigrade(celsius) degrees
Water_Temp	Number	in centigrade(celsius) degrees
Temp_Time	Date/Time	time that temperatures taken in 24-hour time at local time zone and daylight savings (i.e., 15:32)
Secchi	Number	in meters
Discharge	Number	calculated discharge in cubic meters per second
substrate_description	Text	general substrate description
Minimum_Riparian_Buffer	Number	minimum width of riparian cover to shrubs/trees stature in sampled area
Run	Number	percent of sampled area minimum 5% increments
Riffle	Number	percent of sampled area minimum 5% increments
Pool	Number	percent of sampled area minimum 5% increments
Backwater	Number	percent of sampled area minimum 5% increments
Canopy_Cover	Number	percent of sampled area covered by shrubs and trees
soft_silt-mud	Number	percent of sampled area minimum 5% increments
silt-sand_mix	Number	percent of sampled area minimum 5% increments
sand	Number	percent of sampled area (0.125 - 1.9 mm)
gravel	Number	percent of sampled area (2 - 63 mm)
rubble	Number	percent of sampled area (64 - 256 mm)
boulder	Number	percent of sampled area (>256 mm)
bedrock/claypan	Number	percent of sampled area in flat bedrock or claypan
bedrock_ledges/fissures	Number	percent of sampled area in bedrock with many crevices/ledges/fissures
vegetation	Number	percent of sampled area with submergent or emergent plants
shred_detritus/organics	Number	percent of sampled area
leaves/sm_branches	Number	percent of sampled area
logs	Number	percent of sampled area (total of above should equal 100)
algae	Number	percent of sampled area by 5% minimum increments
submergent	Number	percent of sampled area by 5% minimum increments
emergent	Number	percent of sampled area by 5% minimum increments
overhanging	Number	percent of sampled area by 5% minimum increments
floating	Number	percent of sampled area by 5% minimum increments
standing_trees	Number	percent of sampled area by 5% minimum increments (total of above should equal 100)
Veg_Species	Text (256)	Plant associates; vegetation species in and around sampling area
Notes	Memo	all notes pertaining to habitat and collection
habitat_description	Text (256)	category of habitat; i.e., lake, stream, canal, pond, impoundment, ruderal, etc.
control_notes	Text (256)	PLANT control notes
plant_frequency	Number	PLANT frequency percentage
plant_frequency_notes	Text	PLANT frequency notes
plant_elevation	Number	PLANT elevation
waterveloc	Number	measure of current in meters/second