AS011

Attributes in entity 1: Raw data on vertebrate length, weight, and abundance		Details
1. DBCODE Definition: FSDB Database Code Domain: enum
2. ENTITY Definition: Entity number Units: number Domain: range (minimum = 1.  maximum = 1.)
3. YEAR Definition: Year of collection Units: year (yyyy) Domain: range (minimum = 2013.  maximum = 2019.)
4. DATE Definition: Date of collection Units: date as date type Domain: range (minimum = Aug 6 2013  maximum = Aug 15 2019)
5. STREAM Definition: Stream name Domain: place
6. SITE Definition: Colloquial name used by researchers for sampling reach Domain: enum
7. SITE_CODE Definition: code assigned to site represents stream and median elevation of sample reach Domain: place
8. VISIT_NO Definition: site visit number during current year Domain: enum
9. SAMPLING_TEAM Definition: project principal and/or sampling team Domain: enum
10. SAMPLING_METHOD Definition: Sampling method Domain: enum
11. MARK_RECAP Definition: mark or recapture day Domain: enum
12. PASS_NUMBER Definition: number of pass Units: number Domain: range (minimum = 1.  maximum = 4.)
13. PASS_DIRECTION Definition: direction upstream or downstream Domain: enum
14. SPECIES Definition: Vertebrate species collected Domain: taxa
15. VENT_FORK_LENGTH Definition: Vent/Fork Length of vertebrate Units: millimeters Domain: range (minimum = 1.  maximum = 250.)
16. TOTAL_LENGTH Definition: Total Length of vertebrate Units: millimeters Domain: range (minimum = 1.  maximum = 350.)
17. TF_LENGTH_LEGS_EXTENDED Definition: Length of TF adult extended legs in 2018 only Units: millimeters Domain: range (minimum = 1.  maximum = 150.)
18. WEIGHT Definition: Weight of vertebrate collected in grams Units: grams Domain: range (minimum = 0.1  maximum = 300.0)
19. LIFESTAGE_DEVELOPMENT Definition: Development stage of species Domain: enum
20. MARKED Definition: if vertebrate was marked or not at time of sampling on mark day Domain: enum
21. RECAPTURED Definition: if mark on vertebrate was noted or not at time of sampling on recap day Domain: enum
22. COMMENTS Definition: notes taken in field/during data entry Domain: freetext
23. QA_NOTES Definition: notes added during QA Domain: freetext
24. VERT_INDEX Definition: unique number for each vertibrate captured by year, site_code, visit (for primary key) Units: number Domain: range (minimum = 1.  maximum = 1000.)