WDBIS Data Dictionary - Draft
|
VWQMP Data Types
|
|
| Table Name |
Linked File(s) |
Primary Key |
Entity Name |
Entity Code |
Code Description |
| KBAC Site |
Many |
KBACId |
|
|
|
KBACId |
Unique Numeric |
Provides Identifier for Collection Sites |
|
|
|
XYZ |
Numeric Coordinate |
|
|
|
Site Description |
Character |
Additional info on site location |
| Sample Records |
KBAC Site |
KBACId |
|
|
|
CollectNum |
Unique Numeric |
Identifier for each sampling |
|
|
|
Date |
Date |
|
|
|
Time |
Time |
|
|
|
GroupName |
Character |
|
|
|
Name |
Character |
Name of Investigator |
| Weather Conditions |
KBAC Site |
KBACId |
|
|
CollectNum |
|
|
|
AirTemp |
Numeric |
Measured in Celsius |
|
|
|
WaterTemp |
Numeric |
Measured in Celsius |
|
|
|
Condition |
1 |
Clear |
|
|
|
|
2 |
partly Cloudy |
|
|
|
|
3 |
Overcast |
|
|
|
|
4 |
Rain |
None |
|
|
|
|
|
|
Trace |
|
|
|
|
|
|
Heavy |
| Streams |
KBAC Site |
KBACid |
|
Many Others |
StreamId |
StreamID |
Unique Numeric |
Provides Identifier for Stream Segments |
| Storm Drains |
KBAC Site |
KBACId |
|
|
SDrainId |
See HoLIS Data Dic. |
See HoLIS |
Storm Drainage Data Base |
| Storm Drain Pts |
KBAC SiteID |
KBACId |
|
|
SdrainPtId |
See HoLIS |
See HoLIS |
Inlet and other point type data |
| WaterFlow |
Streams |
StreamId |
|
StormDrains |
SDrainId |
|
|
|
WaterLevel |
|
|
|
|
1 |
No Flow |
|
|
|
|
2 |
Low Flow |
|
|
|
|
3 |
High Low |
|
|
|
WaterFlow |
|
|
|
|
Numeric Value |
cubic feet/second (cfs) |
| BottomTypes |
Streams |
StreamID |
|
StormDrains |
SDrainId |
|
|
|
Bottype |
1 |
Concrete |
|
|
|
|
2 |
Revetment |
|
|
|
|
3 |
Diversion |
|
|
|
|
4 |
Irrigation Flume |
|
|
|
|
5 |
Natural |
Rock |
|
|
|
|
|
|
Mud |
|
|
|
|
|
|
Sand |
|
|
|
|
|
|
Vegetate |
|
|
|
|
6 |
Other |
| Inlets |
Streams |
StreamId |
|
StormDrainPts |
SDrainPtId |
|
|
|
InletType |
See HoLIS |
See HoLIS |
|
|
|
LandUse |
1 |
Agriculture |
|
|
|
|
2 |
Industrial |
|
|
|
|
3 |
Feedlot |
|
|
|
|
4 |
Wetland |
|
|
|
|
5 |
Residential |
|
|
|
|
6 |
Open/Vacant |
|
|
|
|
7 |
Tributary |
|
|
|
|
8 |
Other |
| Debris |
Parcels |
TMK |
|
|
DebrisId |
DebrisType |
1 |
Household |
|
|
|
|
2 |
YardWaste |
|
|
|
|
3 |
Construction |
|
|
|
|
4 |
Commercial |
|
|
|
|
5 |
Plastic Food Containers/Shopping Bags |
|
|
|
|
6 |
Batteries |
|
|
|
|
7 |
Other |
| Stream Crossing |
Streets |
StreetName |
|
Streams |
StreamId |
|
|
CrossingId |
CrossType |
|
|
|
|
1 |
Auto Bridge |
|
|
|
|
2 |
Pedestrian/Biking |
|
|
|
|
3 |
Dam |
|
|
|
|
4 |
Weir |
|
|
|
|
5 |
Ditch |
|
|
|
|
6 |
Pipeline |
|
|
|
|
7 |
Other |
| Erosion |
Streams |
StreamID |
|
|
|
ECondition |
1 |
Bank Stability |
|
|
|
|
|
|
Stable |
|
|
|
|
|
|
Unstable |
|
|
|
|
|
|
Undetermined |
|
|
|
|
2 |
Vegetative Cover |
|
|
|
|
|
|
Heavy |
|
|
|
|
|
|
None |
|
|
|
|
|
|
Type |
|
|
|
|
3 |
Artificial Protection |
|
|
|
|
4 |
Bank Steepness |
|
|
|
|
|
|
Very |
|
|
|
|
|
|
Moderate |
|
|
|
|
|
|
Gradual |
| LandUse |
Parcels |
TMK |
|
|
|
See LUSE.DB in HoLIS |
| Human Use |
Streams |
StreamsID |
|
KBAC Sites |
KBACId |
|
|
|
HumanAct |
1 |
Lo'i |
|
|
|
|
2 |
Fishing |
|
|
|
|
3 |
Limu Gathering |
|
|
|
|
4 |
Water Sports |
|
|
|
|
5 |
Other |
| Vegetation |
KBAC Sites |
KBACId |
|
|
|
VegType |
|
|
|
|
1 |
Endemic |
|
|
|
|
2 |
Indigenous |
|
|
|
|
3 |
Introduced |
|
|
|
PercentShade |
Numeric Value |
|
|
|
Herbicide |
1 |
Yes |
|
|
|
|
2 |
No |
| StreamData |
|
Streams |
StreamId |
|
|
|
ChannelWidth |
Numeric Value |
Measured in Meters |
|
|
|
Gradient |
1 |
Low |
|
|
|
|
2 |
Moderate |
|
|
|
|
3 |
Steep |
|
|
|
DeepestDepth |
Numeric Value |
|
|
|
AvgDepth |
Numeric Value |
|
|
|
WaterColor |
Character |
Description |
|
|
|
Odor |
1 |
Present |
|
|
|
|
2 |
None |
|
|
|
SurfaceOil |
1 |
Present |
|
|
|
|
2 |
None |
|
|
|
See also Water Flow |
| Fish |
|
Streams |
StreamID |
|
|
|
Presence |
1 |
yes |
|
|
|
|
2 |
no |
|
|
|
Abundance |
1 |
Many |
|
|
|
|
2 |
Few |
|
|
|
Type |
|
|
|
|
1 |
Endemic |
|
|
|
|
2 |
Indigenous |
|
|
|
|
3 |
Introduced |
| Water Quality |
|
Streams |
StreamsID |
|
|
|
ph Level |
Numeric |
|
|
|
Nutrients |
Character |
|
|
|
Bacteria |
Character |
|
|
|
Dissolved Oxygen |
Numeric |
| STUDENT INTERN DATA TYPES |
| Table Name |
Linked File(s) |
Primary Key |
Entity Name |
Entity Code |
Code Description |
| Beach Survey |
Many |
SurveyId |
|
|
|
SurveyId |
Unique Numeric |
Identifier for each sample |
|
|
|
Date |
date |
|
|
|
Time |
numeric |
|
|
|
BeachID |
Numeric |
Define Beach numbering System for cross referencing with
other tables. |
|
|
|
Location |
Character |
| Trips |
Beach Survey |
SurveyId |
|
|
|
TripNum |
Character |
|
|
|
|
a |
5-7 times a week |
|
|
|
|
b |
1-4 times a week |
|
|
|
|
c |
1-3 times a month |
|
|
|
|
d |
less than once a month |
|
|
|
TripSiteNum |
Character |
|
|
|
|
a |
5-7 times a week |
|
|
|
|
b |
1-4 times a week |
|
|
|
|
c |
1-3 times a month |
|
|
|
|
d |
less than once a month |
|
|
|
WhatBeach |
Numeric |
Define Beach Numbering System for cross referencing with
other tables. |
| Activities |
Beach Survey |
SurveyID |
|
|
|
ActiveType |
Character |
|
|
|
|
a |
Walking |
|
|
|
|
b |
Sunbathing |
1 |
No Water Entry |
|
|
|
|
|
|
2 |
Enter Water |
|
|
|
|
|
|
3 |
Head Wet |
|
|
|
|
c |
Swimming |
Numeric |
Length of time |
|
|
|
|
d |
Fishing |
1 |
Consume Fish |
|
|
|
|
|
|
2 |
Have adverse effects |
| Symptons |
Beach Survey |
SurveyID |
|
|
|
SymptonType |
Character |
|
|
|
|
a |
Fever |
|
|
|
|
b |
Chills |
|
|
|
|
c |
Redness and Eye Discharge |
|
|
|
|
d |
Earache |
|
|
|
|
e |
Ear Discharge/Draining |
|
|
|
|
f |
Skin Rash |
|
|
|
|
g |
Infected Cuts/Scrapes |
|
|
|
|
h |
Nausea |
|
|
|
|
i |
Vomiting |
|
|
|
|
j |
Diarreaha |
|
|
|
|
k |
Diarreaha w/Blood |
|
|
|
|
l |
Stomach Pains/Cramps |
|
|
|
|
m |
Coughing |
|
|
|
|
n |
Coughing w/phlegm |
|
|
|
|
o |
Nasal Congestion/Runny Noes |
|
|
|
|
p |
Sore Throat |
| Beach Conditions |
Beach Survey |
SurveyID |
|
|
|
IllnessSuspect |
Character |
Y/N |
|
|
|
DebrisSeen |
Character |
Y/N |
|
|
|
UnSwimConditions |
Character |
|
|
|
|
a |
Litter |
|
|
|
|
b |
Water Clarity |
|
|
|
|
c |
Other |
|
|
|
Concern |
Character |
|
|
|
|
a |
Very Worried |
|
|
|
|
b |
Moderately Worried |
|
|
|
|
c |
Not at all |
| Demographics |
Beach Survey |
SurveyID |
|
|
|
Age |
Character |
|
|
|
|
a |
0-12 |
|
|
|
|
b |
13-18 |
|
|
|
|
c |
19-25 |
|
|
|
|
d |
26-35 |
|
|
|
|
e |
36-45 |
|
|
|
|
f |
46-55 |
|
|
|
|
g |
56-65 |
|
|
|
|
h |
66-75 |
|
|
|
|
i |
over 75 |
|
|
|
Ethnicity |
|
|
|
|
a |
white |
|
|
|
|
b |
black |
|
|
|
|
c |
Hawaiian |
|
|
|
|
d |
Asian |
|
|
|
|
e |
multi-ethnic |
|
|
|
|
f |
other |
| Student Site |
Many |
SSiteID |
|
|
|
SSiteID |
Unique Numeric |
Provides Identifier for Collection Sites |
|
|
|
XYZ |
Numeric Coordinate |
|
|
|
Site Description |
Character |
Additional info on site location |
|
|
|
Address |
Character |
Address or Street Name |
|
|
|
Area |
Numeric |
Parcel Size |
| BottomTypes |
Student Site |
SSiteID |
|
|
|
Bottype |
1 |
Concrete |
|
|
|
|
2 |
Revetment |
|
|
|
|
3 |
Diversion |
|
|
|
|
4 |
Irrigation Flume |
|
|
|
|
5 |
Natural |
Rock |
|
|
|
|
|
|
Mud |
|
|
|
|
|
|
Sand |
|
|
|
|
|
|
Vegetate |
|
|
|
|
6 |
Other |
| LandUse |
Student Site |
SSiteID |
|
|
|
LandUseObsverved |
Character |
Description of LandUse Observed |
|
|
|
See LUSE.DB in HoLIS |
|
Land Use or Zoning Classes |
| Erosion |
Student Site |
SSiteID |
|
|
|
ECondition |
1 |
Bank Stability |
|
|
|
|
|
|
Stable |
|
|
|
|
|
|
Unstable |
|
|
|
|
|
|
Undetermined |
|
|
|
|
2 |
Vegetative Cover |
|
|
|
|
|
|
Heavy |
|
|
|
|
|
|
None |
|
|
|
|
|
|
Type |
|
|
|
|
3 |
Artificial Protection |
|
|
|
|
4 |
Bank Steepness |
|
|
|
|
|
|
Very |
|
|
|
|
|
|
Moderate |
|
|
|
|
|
|
Gradual |
|
|
|
DrainPath |
1 |
Highway |
|
|
|
|
2 |
Pond |
|
|
|
|
3 |
Street |
|
|
|
|
4 |
Street Drain |
|
|
|
|
5 |
Stream |
Stream Name |
| Livestock |
|
|
|
LivestockType |
Numeric |
|
|
|
|
1 |
Horses |
|
|
|
|
2 |
Hogs |
|
|
|
|
3 |
Cattle |
|
|
|
|
4 |
Chickens |
| Production Tables |
|
|
|
See Intern report Reference |