| SurveyID | lat | long | accuracy_m | Date | StartTime | EndTime | SurveyLength | SurveyLengthCalc | latest_observation_time | Lake | Observer | Sky | Precip | Wind | AirThermometer | AirTemperature_F | WaterThermometer | WaterTemperature_F | WaterColor | SurveyType | Comments | species | NumberOfEggMasses | NumberOfAdults | Weather |
---|
Column Name: | SurveyID
| Latitude
| Longitude
| Accuracy_m
| Date
| StartTime
| EndTime
| SurveyLength
| SurveyLengthCalc
| latest_observation_time
| Lake
| Observer
| Sky
| Precip
| Wind
| AirThermometer
| AirTemperature_F
| WaterThermometer
| WaterTemperature_F
| WaterColor
| SurveyType
| Comments
| SpeciesCode
| NumberOfEggMasses
| NumberOfAdults
| Weather
|
Definition: | Unique ID based on date and lake surveyed | Latitude of collection | longitude of collection | GPS positional accuracy in meters, as reported by iphone data collection app | sampling date. If the sampling date is March 1st of any given year, this is a placeholder date for a survey year where no survey date was recorded. | Start time of survey in Pacific Time (America/LosAngeles), with appropriate daylight savings adjustment, if applicable | End time of survey in Pacific Time (America/LosAngeles), with appropriate daylight savings adjustment, if applicable | Total time spent on survey (HH:MM) | Total time spent on survey (HH:MM), estimated when end time was not recorded, based off of the last observation time during that survey. | The final egg mass detection time in a survey-used for SurveyLengthCalc. | Lake surveyed. Big Lake and Deep Lake form one continuous waterbody during high water years, and from 2021 to 2022 it was surveyed as one lake as opposed to breaking the lake up into two surveys. See map jpg for lake name labels. | Last name, or first and last name, of surveyor(s) | Cloud cover characteristics at the start of the survey. Egg masses are easier to see in clear and sunny conditions compared to overcast and cloudy conditions. | Precipitation at the survey start. Rain disturbs the water surface and makes egg masses difficult to see. | General description of wind at start of survey. Wind disturbs the water surface and makes egg masses harder to see. | Check if a thermometer was used to measure air temperature in the field. | Air temperature measured at the start of the survey (if airthermometer=Yes), or from cell phone weather app | Check if a thermometer was used to measure water temperature in the field. | Water temperature measured at the start of the survey at 6 inch depth, in the shade if possible. | Color of the lake water (clear, or stained from tannins). Egg masses slightly harder to discern in stained water. | Conveyance method for the survey. | Freeform comments about the survey | Species code identifier for the NumberOf... columns | Number of egg masses counted per species during a survey | Number of adults counted per species during a survey | longform description of weather conditions |
Storage Type: | string
| float
| float
| float
| dateTime
| dateTime
| dateTime
| string
| string
| string
| string
| string
| string
| string
| string
| string
| float
| string
| float
| string
| string
| string
| string
| float
| float
| string
|
Measurement Type: | nominal | ratio | ratio | ratio | dateTime | dateTime | dateTime | nominal | nominal | nominal | nominal | nominal | nominal | nominal | nominal | nominal | ratio | nominal | ratio | nominal | nominal | nominal | nominal | ratio | ratio | nominal |
Measurement Values Domain: | | | | | Format | YYYY-MM-DD | Precision | |
| | | | | | | | | | | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | No | Definition | Observer did not have an air thermometer with them, so temperature may be based on weather forecast | Source | |
| Code Definition | Code | Yes | Definition | Observer used a thermometer to measure local air temperature conditions | Source | |
|
|
| | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | No | Definition | Observer did not have a water thermometer with them | Source | |
| Code Definition | Code | Yes | Definition | Observer had a water thermometer with them | Source | |
|
|
| | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | nan | Definition | WaterColor data not recorded | Source | |
| Code Definition | Code | Clear | Definition | Color of water not discernable. Apparently clear or colorless. | Source | |
| Code Definition | Code | Stained | Definition | Water appears stained by tannins, with greenish or brownish hue. | Source | |
|
|
| Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | Canoe Survey | Definition | Focued on RAAU counts-any other detections are incidental. Counts conducted by canoe, allowing detection of egg masses not visible from shore. Individual egg mass detections not always recorded. | Source | |
| Code Definition | Code | wading | Definition | Surveys conducted in-and-out of the water, wearing chest or waist waders. Often within 5-6' of shoreline, depending on topography. | Source | |
| Code Definition | Code | walk | Definition | Surveys conducted by walking the perimeter of the lake outside the water. | Source | |
|
|
| | Allowed Values and DefinitionsEnumerated Domain | | Code Definition | Code | AMGR | Definition | Ambystoma gracile | Source | |
| Code Definition | Code | AMMA | Definition | Ambystoma macrodactylum | Source | |
| Code Definition | Code | PSRE | Definition | Pseudacris regilla | Source | |
| Code Definition | Code | RAAU | Definition | Rana aurora | Source | |
| Code Definition | Code | TAGR | Definition | Taricha granulosa | Source | |
|
|
| | | |
Missing Value Code: | | Code | NA | Expl | Latitude not collected |
| Code | NA | Expl | Longitude not collected |
| Code | NA | Expl | GPS positional accuracy information not available, or not applicable |
| Code | XXXX-03-01 | Expl | placeholder date for a survey year where no survey date was recorded |
| Code | NA | Expl | Start time data not collected |
| Code | NA | Expl | End time data not collected |
| | | | | | | Code | NULL | Expl | Historic data that predated this specific column, or observer did not note precipitation conditions |
| Code | NULL | Expl | Didn't measure wind speed |
| Code | NA | Expl | Historic data that predated this specific column, or observer did not note whether they had an air thermometer |
| Code | NA | Expl | Observer did not report air temperature |
| Code | NA | Expl | Historic data that predated this specific column, or observer did not note whether they had a water thermometer |
| Code | NA | Expl | Observer did not report water temperature |
| Code | NA | Expl | Water color data not collected |
| Code | NA | Expl | Typical of historic data, where all survey types presumed to be walk or wade, with the exception of the singular snorkel survey |
| | | Code | NA | Expl | Egg masses for that species were not specifically counted on that survey, or no survey was conducted |
| Code | NA | Expl | No adult data collected. An NA does not indicate there were no adults present. |
| |
Accuracy Report: | | | | | | | | | | | | | | | | | | | | | | | | | | |
Accuracy Assessment: | | | | | | | | | | | | | | | | | | | | | | | | | | |
Coverage: | | | | | | | | | | | | | | | | | | | | | | | | | | |
Methods: | | | | | | | | | | | | | | | | | | | | | | | | | | |