SANITARY_DATA_SEQ is the primary key - this will get generated on the WI Beach Health side, but you probably want to have a field for an artificial primary key to identify the record with. Perhaps a sequence concatenated with the device name.
SAMPLER_SEQ must be in the list of users. This is not always the same person who is entering the data. We have a sequence number associated with the userid. You could send the userid here and our process will convert it into SAMPLER_SEQ.
ANALYZER_ZEQ must be in the list of users. This is not always the same person who is entering the data. We have a sequence number associated with the userid. You could send the userid here and our process will convert it into ANAYLYZER_SEQ.
DATA_ENTRY_SEQ must be in thelist of users. This is the person who is entering the data. We have a sequence number associated with the userid. You could send the userid here and our process will convert it into DATA_ENTRY_SEQ.
MONITOR_SITE_SEQ and SAMPLE_DATE_TIME make up a Unique Key
Cannot be null:
COLUMN NAME | DATA TYPE | Field in Monitoring Form |
Part 1 | ||
BEACH_SEQ | NUMBER (8) | *Beach (entered as beach name, saved as beach seq) |
MONITOR_SITE_SEQ | NUMBER (8) | *Monitoring Site (entered as name, saved as sequence number) |
SAMPLE_DATE_TIME | DATE | *Sample date time |
SAMPLER_SEQ | NUMBER (10) | *Sampler (entered as userid, saved as user seq) |
AIR_TEMP | NUMBER (8,4) | |
AIR_UNITS | VARCHAR2 (1) | |
WIND_SPEED | NUMBER (8,4) | |
WIND_SPEED_UNITS | VARCHAR2 (30) | |
WIND_DIR_DEGREES | NUMBER | |
WIND_DIR_DESC | VARCHAR2 (30) | |
WEATHER_DESC | VARCHAR2 (30) | *Weather Conditions |
RAINFALL_LAST_EVENT | VARCHAR2 (5) | |
RAINFALL | NUMBER (8,4) | |
RAINFALL_UNITS | VARCHAR2 (30) | |
RAINFALL_STN_DESC | VARCHAR2 (60) | |
WAVE_HEIGHT | NUMBER (8,4) | *Wave Height (ft) |
WAVE_HEIGHT_UNITS | VARCHAR2 (30) | * |
WAVE_DIRECTION | VARCHAR2 (10) | Wave Direction(E,N,NE,NW,S,SE,SW,W) |
WAVE_CONDITIONS | VARCHAR2 (30) | |
EST_ACT_FLAG | VARCHAR2 (1) | *Estimated/Actual (comes after Wave Height) |
CURRENT_SPEED | NUMBER (8) | Longshore Current Speed |
LONGSHORE_CURRENT_UNITS | VARCHAR2 (30) | Units(cm/sec;ft/sec) |
SHORELINE_CURRENT_DIR | VARCHAR2 (30) | Longshore Direction ((E,N,NE,NW,S,SE,SW,W)) |
PART_1_COMMENTS | VARCHAR2 (1000) | Field conditions comments |
Part 2 | ||
ECOLI_SAMPLE_TYPE | VARCHAR2 (30) | Composite Sample(Y/N) |
AVG_WATER_TEMP | NUMBER (7,2) | *Water Temperature |
AVG_WATER_TEMP_UNITS | VARCHAR2 (30) | *Water Temperature Units |
PH | NUMBER (5,2) | pH |
COLOR_CHANGE | VARCHAR2 (1) | |
COLOR_DESCRIPTION | VARCHAR2 (50) | |
ODOR_DESCRIPTION | VARCHAR2 (50) | Odor ( None;Septic;Algae;Sulfur;Other) |
ODOR_OTHER_DESCRIPTION | VARCHAR2 (50) | If Other, describe |
CLARITY_DESC | VARCHAR2 (30) | *Water Clarity |
NTU | NUMBER (10,2) | Turbidity Measurements |
SECCHI_TUBE_CM | NUMBER (8) | Secchi Tube (cm) |
PART_2_COMMENTS | VARCHAR2 (1000) | Comments/Observations (Part2) |
Part 3 | ||
NO_IN_WATER | NUMBER (8) | # In Water |
NUM_OUT_OF_WATER | NUMBER (8) | # Out of Water |
NO_BATHERS | NUMBER (8) | # at Beach |
NO_PEOPLE_BOATING | NUMBER (8) | # Boating |
NO_PEOPLE_FISHING | NUMBER (8) | # Fishing |
NO_PEOPLE_SURFING | NUMBER (8) | # Surfing |
NO_PEOPLE_WINDSURFING | NUMBER (8) | # Windsurfing |
NO_PEOPLE_DIVING | NUMBER (8) | # Diving |
NO_PEOPLE_CLAMMING | NUMBER (8) | # Clamming |
NO_PEOPLE_OTHER | NUMBER (8) | # Other Activity |
NO_PEOPLE_OTHER_DESC | VARCHAR2 (50) | Describe Other Activity |
PART_3_COMMENTS | VARCHAR2 (1000) | Comments/Observations (Part3) |
Part 4 | ||
FLOATABLES_FLAG | VARCHAR2 (1) | Floatables present |
Floatables Radio Boxes | ||
FLOAT_STREET_LITTER | VARCHAR2 (1) | Types of Floatables - Street Litter checkbox |
FLOAT_FOOD | VARCHAR2 (1) | Types of Floatables - Food checkbox |
FLOAT_MEDICAL | VARCHAR2 (1) | Types of Floatables - Medical checkbox |
FLOAT_SEWAGE | VARCHAR2 (1) | Types of Floatables - Sewage checkbox |
FLOAT_BLDG_MATERIALS | VARCHAR2 (1) | Types of Floatables - Bldg Materials checkbox |
FLOAT_FISHING | VARCHAR2 (1) | Types of Floatables - Fishing checkbox |
FLOAT_OTHER | VARCHAR2 (1) | Types of Floatables - Other checkbox |
FLOAT_OTHER_DESC | VARCHAR2 (50) | Describe Other Floatables |
DEBRIS_AMOUNT | VARCHAR2 (30) | Amount of Beach Debris/Litter on Beach (None, Low 1-20%, Moderate 21-50%, Hight >50%) |
Debris Radio Boxes | ||
DEBRIS_STREET_LITTER | VARCHAR2 (1) | Types of Debris/Litter - Street Litter checkbox |
DEBRIS_FOOD | VARCHAR2 (1) | Types of Debris/Litter - Food checkbox |
DEBRIS_MEDICAL | VARCHAR2 (1) | Types of Debris/Litter - Medical Waste checkbox |
DEBRIS_SEWAGE | VARCHAR2 (1) | Types of Debris/Litter - Sewage checkbox |
DEBRIS_BLDG_MATERIALS | VARCHAR2 (1) | Types of Debris/Litter - Bldg Materials checkbox |
DEBRIS_FISHING | VARCHAR2 (1) | Types of Debris/Litter - Fishing checkbox |
DEBRIS_HOUSEHOLD | VARCHAR2 (1) | Types of Debris/Litter - Household checkbox |
DEBRIS_TAR | VARCHAR2 (1) | Types of Debris/Litter - Tar checkbox |
DEBRIS_OIL | VARCHAR2 (1) | Types of Debris/Litter - Oil checkbox |
DEBRIS_OTHER | VARCHAR2 (1) | Types of Debris/Litter - Other checkbox |
DEBRIS_OTHER_DESC | VARCHAR2 (255) | Describe Other Debris |
ALGAE_NEARSHORE | VARCHAR2 (30) | *Amount of Algae in Nearshore Water (NONE, LOW, MODERATE, HIGH) |
ALGAE_ON_BEACH | VARCHAR2 (30) | *Amount of Algae On Beach (NONE, LOW, MODERATE, HIGH) |
Algae Type | ||
ALGAE_TYPE_PERIPHYTON | VARCHAR2 (1) | Algae Type - Periphyton |
ALGAE_TYPE_GLOBULAR | VARCHAR2 (1) | Algae Type - Globular |
ALGAE_TYPE_FREEFLOATING | VARCHAR2 (1) | Algae Type - Free Floating |
ALGAE_TYPE_OTHER | VARCHAR2 (1) | Algae Type - Other |
ALGAE_TYPE_OTHER_DESC | VARCHAR2 (50) | Describe Other Algae |
Algae Color | ||
ALGAE_COLOR_LT_GREEN | VARCHAR2 (1) | Algae Color - Light Green |
ALGAE_COLOR_BRIGHT_GREEN | VARCHAR2 (1) | Algae Color - Bright Green |
ALGAE_COLOR_DRK_GREEN | VARCHAR2 (1) | Algae Color - Dark Green |
ALGAE_COLOR_YELLOW | VARCHAR2 (1) | Algae Color - Yellow |
ALGAE_COLOR_BROWN | VARCHAR2 (1) | Algae Color - Brown |
ALGAE_COLOR_OTHER | VARCHAR2 (1) | Algae Color - Other |
ALGAE_COLOR_OTHER_DESC | VARCHAR2 (50) | Describe Other Algae Color |
Presence of Wildlife and Domestic Animals | ||
NO_GEESE | NUMBER (8) | (I think we want to add a field for Number of Geese?) |
NO_GULLS | NUMBER (8) | *Number of Gulls |
NO_DOGS | NUMBER (8) | Number of Dogs |
NO_ANIMALS_OTHER | NUMBER (8) | # Other Animals |
ANIMALS_OTHER_DESC | VARCHAR2 (50) | Other Animals Description |
Presence of Dead Birds and Fish | ||
NUM_LOONS | NUMBER (8) | Number of Dead Loons |
NUM_HERR_GULLS | NUMBER (8) | Number of Dead Herr Gulls |
NUM_RING_GULLS | NUMBER (8) | Number of Dead Ring Gulls |
NUM_CORMORANTS | NUMBER (8) | Number of Dead Cormorants |
NUM_LONGTAIL_DUCKS | NUMBER (8) | Number of Dead Loongtail Ducks |
NUM_SCOTER | NUMBER (8) | Number of Dead Scoter |
NUM_HORN_GREBE | NUMBER (8) | Number of Dead Horn Grebe |
NUM_REDNECKED_GREBE | NUMBER (8) | Number of Dead Rednecked Grebe |
NUM_OTHER | NUMBER (8) | Number of Dead Other Birds |
NUM_OTHER_DESC | VARCHAR2 (50) | Describe Other Dead Birds |
PART_4_COMMENTS | VARCHAR2 (1000) | Comments/Observations (Part 4) |
DATE_ENTERED | DATE | (Current date/time) |
DATA_ENTRY_SEQ | NUMBER (10) | Logged in by (default is the person who is logged on) |
DATE_UPDATED | DATE | (date/time when an update was made) |
UPDATE_ENTRY_SEQ | NUMBER (10) | (defaults to the person who was logged in when an update was made) |
MISSING_REQUIRED_FLAG | VARCHAR2 (1) | "Not all Required(*) data collected" -In the desktop version, this is a flag that is used to let users submit data even if not all of the required fields are filled in. We will need to discuss what the required fields are and if we want this option in the mobile version) |
COLUMN NAME | COLUMN ID | PRIMARY KEY | DATA TYPE | Field in Monitoring Data Form | ||||
SANITARY_DATA_SEQ | 1 | 1 | NUMBER (8) | |||||
BEACH_SEQ | 2 | NUMBER (8) | Beach | |||||
MONITOR_SITE_SEQ | 3 | NUMBER (8) | Monitoring Site | |||||
SAMPLE_DATE_TIME | 4 | DATE | Sample date time | |||||
SAMPLER_SEQ | 5 | NUMBER (10) | "Sampler (entered as userid | saved as user seq) | ||||
AIR_TEMP | 6 | "NUMBER (8 | 4)" | |||||
AIR_UNITS | 7 | VARCHAR2 (1 Byte) | ||||||
WIND_SPEED | 8 | "NUMBER (8 | 4)" | |||||
WIND_SPEED_UNITS | 9 | VARCHAR2 (30 Byte) | ||||||
WIND_SPEED_DESC | 10 | VARCHAR2 (30 Byte) | ||||||
WIND_DIR_DEGREES | 11 | NUMBER | ||||||
WIND_DIR_DESC | 12 | VARCHAR2 (30 Byte) | ||||||
WEATHER_DESC | 13 | VARCHAR2 (30 Byte) | Weather Conditions | |||||
SHORELINE_CURRENT_DIR | 14 | VARCHAR2 (30 Byte) | ||||||
WAVE_HEIGHT | 15 | "NUMBER (8 | 4)" | Wave Height (ft) | ||||
WAVE_HEIGHT_UNITS | 16 | VARCHAR2 (30 Byte) | ||||||
EST_ACT_FLAG | 17 | VARCHAR2 (1 Byte) | Estimated/Actual (comes after Wave Height) | |||||
RAINFALL_LAST_EVENT | 18 | VARCHAR2 (5 Byte) | ||||||
RAINFALL | 19 | "NUMBER (8 | 4)" | |||||
RAINFALL_UNITS | 20 | VARCHAR2 (30 Byte) | ||||||
RAINFALL_DURATION_HRS | 21 | "NUMBER (4 | 2)" | |||||
RAINFALL_STN_DESC | 22 | VARCHAR2 (60 Byte) | ||||||
RAINFALL_STN_DIST | 23 | "NUMBER (8 | 4)" | |||||
RAINFALL_STN_DIST_UNITS | 24 | VARCHAR2 (30 Byte) | ||||||
PART_1_COMMENTS | 25 | VARCHAR2 (1000 Byte) | Field conditions comments | |||||
ENTEROCICCUS_REMARK | 26 | VARCHAR2 (6 Byte) | ||||||
ENTEROCICCUS_VALUE | 27 | "NUMBER (10 | 2)" | |||||
OTHER_REMARK | 28 | VARCHAR2 (6 Byte) | ||||||
OTHER_MEAS_NAME | 29 | VARCHAR2 (50 Byte) | ||||||
OTHER_VALUE | 30 | "NUMBER (10 | 2)" | |||||
LAB_ANALYSIS_COMMENTS | 31 | VARCHAR2 (255 Byte) | Lab analysis comments | |||||
ANALYSIS_DATE | 32 | DATE | Analysis date | |||||
ANALYZER_SEQ | 33 | NUMBER (10) | "Analyzer (entered as userid | saved as user seq) | ||||
AVG_WATER_TEMP | 34 | "NUMBER (7 | 2)" | Water Temperature | ||||
AVG_WATER_TEMP_UNITS | 35 | VARCHAR2 (30 Byte) | Water Temperature Units | |||||
COLOR_CHANGE | 36 | VARCHAR2 (1 Byte) | ||||||
COLOR_DESCRIPTION | 37 | VARCHAR2 (50 Byte) | ||||||
ODOR_DESCRIPTION | 38 | VARCHAR2 (50 Byte) | ||||||
ODOR_OTHER_DESCRIPTION | 39 | VARCHAR2 (50 Byte) | ||||||
CLARITY_DESC | 40 | VARCHAR2 (30 Byte) | Water Clarity | |||||
NTU | 41 | "NUMBER (10 | 2)" | Turbidity Measurements | ||||
PART2_COMMENTS | 42 | VARCHAR2 (1000 Byte) | ||||||
NO_BATHERS | 43 | NUMBER (8) | ||||||
NO_IN_WATER | 44 | NUMBER (8) | ||||||
NO_PEOPLE_BOATING | 45 | NUMBER (8) | ||||||
NO_PEOPLE_FISHING | 46 | NUMBER (8) | ||||||
NO_PEOPLE_SURFING | 47 | NUMBER (8) | ||||||
NO_PEOPLE_WINDSURFING | 48 | NUMBER (8) | ||||||
NO_PEOPLE_DIVING | 49 | NUMBER (8) | ||||||
NO_PEOPLE_CLAMMING | 50 | NUMBER (8) | ||||||
NO_PEOPLE_OTHER | 51 | NUMBER (8) | ||||||
NO_PEOPLE_OTHER_DESC | 52 | VARCHAR2 (50 Byte) | ||||||
PART3_COMMENTS | 53 | VARCHAR2 (1000 Byte) | ||||||
FLOATABLES_FLAG | 54 | VARCHAR2 (1 Byte) | ||||||
FLOATABLE_DESC | 55 | VARCHAR2 (255 Byte) | ||||||
DEBRIS_AMOUNT | 56 | VARCHAR2 (30 Byte) | ||||||
DEBRIS_TAR | 57 | VARCHAR2 (1 Byte) | ||||||
DEBRIS_OIL | 58 | VARCHAR2 (1 Byte) | ||||||
DEBRIS_TRASH | 59 | VARCHAR2 (1 Byte) | ||||||
DEBRIS_PLASTIC | 60 | VARCHAR2 (1 Byte) | ||||||
DEBRIS_MEDICAL | 61 | VARCHAR2 (1 Byte) | ||||||
DEBRIS_OTHER | 62 | VARCHAR2 (1 Byte) | ||||||
DEBRIS_OTHER_DESC | 63 | VARCHAR2 (255 Byte) | ||||||
ALGAE_NEARSHORE | 64 | VARCHAR2 (30 Byte) | "Amount of Algae in Nearshore Water (NONE | LOW | MODERATE | HIGH) | ||
ALGAE_ON_BEACH | 65 | VARCHAR2 (30 Byte) | "Amount of Algae On Beach (NONE | LOW | MODERATE | HIGH) | ||
NO_GEESE | 66 | NUMBER (8) | (I think we want to add a field for Number of Geese?) | |||||
NO_GULLS | 67 | NUMBER (8) | Number of Gulls | |||||
NO_DOGS | 68 | NUMBER (8) | ||||||
NO_ANIMALS_OTHER | 69 | NUMBER (8) | ||||||
ANIMALS_OTHER_DESC | 70 | VARCHAR2 (50 Byte) | ||||||
PART4_COMMENTS | 71 | VARCHAR2 (1000 Byte) | ||||||
CURRENT_SPEED | 72 | NUMBER (8) | ||||||
OTHER_REMARK2 | 73 | VARCHAR2 (6 Byte) | ||||||
OTHER_MEAS_NAME2 | 74 | VARCHAR2 (50 Byte) | ||||||
OTHER_VALUE2 | 75 | "NUMBER (10 | 2)" | |||||
LONGSHORE_CURRENT_UNITS | 76 | VARCHAR2 (30 Byte) | ||||||
PH | 77 | "NUMBER (5 | 2)" | |||||
SWIM_AREAS_CHANNEL | 78 | VARCHAR2 (1 Byte) | ||||||
WATER_LEVEL_DESC | 79 | VARCHAR2 (30 Byte) | ||||||
DRIFT_DIRECTION | 80 | VARCHAR2 (10 Byte) | ||||||
WAVE_DIRECTION | 81 | VARCHAR2 (10 Byte) | ||||||
WAVE_CONDITIONS | 82 | VARCHAR2 (30 Byte) | ||||||
NATURAL_DEBRIS_AMT | 83 | VARCHAR2 (30 Byte) | ||||||
NATURAL_DEBRIS_TYPES | 84 | VARCHAR2 (255 Byte) | ||||||
ALGAE_BOYANCY | 85 | VARCHAR2 (30 Byte) | ||||||
ALGAE_COLOR | 86 | VARCHAR2 (30 Byte) | ||||||
ALGAE_IN_SAMPLE | 87 | VARCHAR2 (1 Byte) | ||||||
WIND_CONDITIONS | 88 | VARCHAR2 (30 Byte) | ||||||
WILDLIFE_ONSHORE | 89 | VARCHAR2 (255 Byte) | ||||||
WILDLIFE_IN_WATER | 90 | VARCHAR2 (255 Byte) | ||||||
SWIM_AREAS_EAST | 91 | VARCHAR2 (1 Byte) | ||||||
SWIM_AREAS_WEST | 92 | VARCHAR2 (1 Byte) | ||||||
RAIN_INTENSITY | 93 | VARCHAR2 (30 Byte) | ||||||
WAVE_INTENSITY | 94 | VARCHAR2 (15 Byte) | ||||||
NUM_OUT_OF_WATER | 95 | NUMBER (8) | ||||||
FLOAT_STREET_LITTER | 96 | VARCHAR2 (1 Byte) | ||||||
FLOAT_FOOD | 97 | VARCHAR2 (1 Byte) | ||||||
FLOAT_MEDICAL | 98 | VARCHAR2 (1 Byte) | ||||||
FLOAT_SEWAGE | 99 | VARCHAR2 (1 Byte) | ||||||
FLOAT_BLDG_MATERIALS | 100 | VARCHAR2 (1 Byte) | ||||||
FLOAT_FISHING | 101 | VARCHAR2 (1 Byte) | ||||||
FLOAT_HOUSEHOLD | 102 | VARCHAR2 (1 Byte) | ||||||
FLOAT_OTHER | 103 | VARCHAR2 (1 Byte) | ||||||
FLOAT_OTHER_DESC | 104 | VARCHAR2 (50 Byte) | ||||||
DEBRIS_STREET_LITTER | 105 | VARCHAR2 (1 Byte) | ||||||
DEBRIS_FOOD | 106 | VARCHAR2 (1 Byte) | ||||||
DEBRIS_SEWAGE | 107 | VARCHAR2 (1 Byte) | ||||||
DEBRIS_BLDG_MATERIALS | 108 | VARCHAR2 (1 Byte) | ||||||
DEBRIS_FISHING | 109 | VARCHAR2 (1 Byte) | ||||||
DEBRIS_HOUSEHOLD | 110 | VARCHAR2 (1 Byte) | ||||||
ALGAE_TYPE_PERIPHYTON | 111 | VARCHAR2 (1 Byte) | ||||||
ALGAE_TYPE_GLOBULAR | 112 | VARCHAR2 (1 Byte) | ||||||
ALGAE_TYPE_FREEFLOATING | 113 | VARCHAR2 (1 Byte) | ||||||
ALGAE_TYPE_OTHER | 114 | VARCHAR2 (1 Byte) | ||||||
ALGAE_TYPE_OTHER_DESC | 115 | VARCHAR2 (50 Byte) | ||||||
ALGAE_COLOR_LT_GREEN | 116 | VARCHAR2 (1 Byte) | ||||||
ALGAE_COLOR_BRGHT_GREEN | 117 | VARCHAR2 (1 Byte) | ||||||
ALGAE_COLOR_DRK_GREEN | 118 | VARCHAR2 (1 Byte) | ||||||
ALGAE_COLOR_YELLOW | 119 | VARCHAR2 (1 Byte) | ||||||
ALGAE_COLOR_BROWN | 120 | VARCHAR2 (1 Byte) | ||||||
ALGAE_COLOR_OTHER | 121 | VARCHAR2 (1 Byte) | ||||||
ALGAE_COLOR_OTHER_DESC | 122 | VARCHAR2 (50 Byte) | ||||||
NUM_LOONS | 123 | NUMBER (8) | ||||||
NUM_HERR_GULLS | 124 | NUMBER (8) | ||||||
NUM_RING_GULLS | 125 | NUMBER (8) | ||||||
NUM_CORMORANTS | 126 | NUMBER (8) | ||||||
NUM_LONGTAIL_DUCKS | 127 | NUMBER (8) | ||||||
NUM_SCOTER | 128 | NUMBER (8) | ||||||
NUM_HORN_GREBE | 129 | NUMBER (8) | ||||||
NUM_REDNECKED_GREBE | 130 | NUMBER (8) | ||||||
NUM_OTHER | 131 | NUMBER (8) | ||||||
NUM_OTHER_DESC | 132 | VARCHAR2 (50 Byte) | ||||||
NUM_DEAD_FISH | 133 | NUMBER (8) | ||||||
ECOLI_SAMPLE_TYPE | 134 | VARCHAR2 (30 Byte) | Composite Sample? (N/Y) | |||||
WATER_TEST1_SAMPLE_TYPE | 135 | VARCHAR2 (30 Byte) | ||||||
WATER_TEST2_SAMPLE_TYPE | 136 | VARCHAR2 (30 Byte) | ||||||
ENTEROCICCUS_SAMPLE_TYPE | 137 | VARCHAR2 (30 Byte) | ||||||
ENTEROCICCUS_UNITS | 138 | VARCHAR2 (30 Byte) | ||||||
OTHER_MEAS_UNITS | 139 | VARCHAR2 (30 Byte) | ||||||
OTHER_MEAS2_UNITS | 140 | VARCHAR2 (30 Byte) | ||||||
DATE_ENTERED | 141 | DATE | (Current date/time) | |||||
DATA_ENTRY_SEQ | 142 | NUMBER (10) | Logged in by (default is the person who is logged on) | |||||
DATE_UPDATED | 143 | DATE | (date/time when an update was made) | |||||
UPDATE_ENTRY_SEQ | 144 | NUMBER (10) | (defaults to the person who was logged in when an update was made) | |||||
E_COLI_REMARK | 145 | VARCHAR2 (6 Byte) | "E. coli remark (> | < | E | NONE) | ||
E_COLI_VALUE | 146 | "NUMBER (10 | 2)" | E Coli Value | ||||
GLRI_SURVEY_ID | 147 | INTEGER | ||||||
SURVEY_TIME | 148 | NUMBER | ||||||
ALGAE_CATEGORY | 149 | NUMBER (1) | ||||||
FECAL_MATTER_CATEGORY | 150 | NUMBER (1) | ||||||
DEBRIS_CATEGORY | 151 | NUMBER (1) | ||||||
WAVE_DIR_DEG | 152 | NUMBER | ||||||
SC | 153 | NUMBER | ||||||
TOTAL_NO_OF_BIRDS | 154 | NUMBER (8) | ||||||
NOWCAST_ID | 155 | VARCHAR2 (30 Byte) | ||||||
DAY_OF_SEASON | 156 | NUMBER (3) | ||||||
STAGE_OF_SEASON | 157 | NUMBER (1) | ||||||
DEW_POINT | 158 | "NUMBER (4 | 1)" | |||||
DEW_POINT_UNITS | 159 | VARCHAR2 (10 Byte) | ||||||
LAKE_LEVEL | 160 | "NUMBER (6 | 3)" | |||||
LAKE_LEVEL_UNITS | 161 | VARCHAR2 (10 Byte) | ||||||
NOAA_SURF_CURR_SPD | 162 | "NUMBER (6 | 4)" | |||||
NOAA_SURF_CURR_SPD_UNITS | 163 | VARCHAR2 (10 Byte) | ||||||
NOAA_SURF_CURR_DIR | 164 | "NUMBER (7 | 4)" | |||||
EST_WATERSHED_E_COLI_LOADING | 165 | "NUMBER (12 | 2)" | |||||
EST_WATERSHED_E_COLI_LD_UNITS | 166 | VARCHAR2 (10 Byte) | ||||||
NOWCAST_E_COLI_CONC | 167 | "NUMBER (10 | 2)" | |||||
NOWCAST_E_COLI_CONC_UNITS | 168 | VARCHAR2 (10 Byte) | ||||||
NOWCAST_PROB_EXCEEDING_235 | 169 | "NUMBER (5 | 2)" | |||||
NOWCAST_PROB_EXCEEDING_1000 | 170 | "NUMBER (5 | 2)" | |||||
EASTWARD_WATER_VELOCITY_UC | 171 | "NUMBER (6 | 4)" | |||||
UC_UNITS | 172 | VARCHAR2 (10 Byte) | ||||||
NORTH_WATER_VELOCITY_VC | 173 | "NUMBER (6 | 4)" | |||||
VC_UNITS | 174 | VARCHAR2 (10 Byte) | ||||||
RAINFALL_24HR | 175 | "NUMBER (3 | 2)" | |||||
RAINFALL_24HR_UNITS | 176 | VARCHAR2 (10 Byte) | ||||||
RAINFALL_48HR | 177 | "NUMBER (3 | 2)" | |||||
RAINFALL_48HR_UNITS | 178 | VARCHAR2 (10 Byte) | ||||||
NOAA_WAVE_HEIGHT | 179 | "NUMBER (6 | 4)" | |||||
NOAA_WAVE_HEIGHT_UNITS | 180 | VARCHAR2 (10 Byte) | ||||||
SC_UNITS | 181 | VARCHAR2 (10 Byte) | ||||||
E_COLI_UNITS | 182 | VARCHAR2 (10 Byte) | E Coli Units (the possible values are pulled from the beach information) | |||||
GLRI_E_COLI_BEACH_ACT | 183 | VARCHAR2 (1 Byte) | ||||||
E_COLI_PROC | 184 | VARCHAR2 (200 Byte) | ||||||
MONITOR_CATEGORY | 185 | VARCHAR2 (60 Byte) | ||||||
SECCHI_TUBE_CM | 186 | NUMBER (8) | Secchi Tube (cm) | |||||
MONITOR_FORM_FLAG | 187 | VARCHAR2 (1 Byte) | ||||||
MISSING_REQUIRED_FLAG | 188 | VARCHAR2 (1 Byte) | "In the desktop version | this is a flag that is used to let users submit data even if not all of the required fields are filled in. We will need to discuss what the required fields are and if we want this option in the mobile version) | ||||
MISSING_REQUIRED_FLAG2 | 189 | VARCHAR2 (1 Byte) | % |