# Stream temperature at core phenology stream sites in the Andrews Experimental Forest, 2009 - 2014 ## Dataset - **Database Code:** HT006 - **Title:** Stream temperature at core phenology stream sites in the Andrews Experimental Forest, 2009 - 2014 - **Abstract:** The H.J Andrews phenology research included this study of stream temperatures at six headwater streams where springtime emergence of stream macroinvertebrates were collected. Streams were selected across an elevational gradient and with young riparian forests as well as old growth riparian forests. One site was a stream that originated in a cold water spring and the site was a stream that drys late in the summer. Stream temperature loggers were placed in protective housings and stream temperatures collected year-round starting May 2009-July 2014. Data were evaluated for quality control and missing periods were filled. These data document the thermal environment that stream macroinvertebrates experience and that influence their timing of emergence (database SA025). - **Keywords:** populations; phenology; water temperature; forests; streams; populations - **Temporal coverage:** 2009-01-01 to 2014-07-31 - **Principal Investigator:** Sherri L. Johnson ## Data Entities 1. HT00601 2. HT00602 ## Entity 1: HT00601 ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **HT006** — FSDB Database Code HT006 - **ENTITY** — numeric(1), range 1.0000 1.0000, number Entity Number - **SITECODE** — varchar, enum Site code - **PE001** — HJA Phenology Emergence Site 1 (WS01 stream) - **PE002** — HJA Phenology Emergence Site 2 (WS02 stream) - **PE003** — HJA Phenology Emergence Site 3 (WS08 stream) - **PE004** — HJA Phenology Emergence Site 4 (WS07 stream) - **PE005** — HJA Phenology Emergence Site 5 (Cold Creek) - **PE006** — HJA Phenology Emergence Site 6 (South Creek) - **SITETYPE** — varchar, enum Type of measurement site: core phenology emergence site - **PE** — Core phenology emergence stream site - **QC_LEVEL** — varchar, enum Quality control flag indicates level of quality checking performed - **1A** — Data is published and unlikely to change - automated range checking and manual review has been conducted - **1D** — Data is published and unlikely to change - data is derived or aggregated from published data of level 1A - **2A** — Data is published and unlikely to change - Level 1A data has been modified such that data gaps may be filled or problem data may be removed - **2D** — Data is published and unlikely to change - data is derived or aggregated from published data of level 2A - **DATE** — datetime, freetext Date - **WATERTEMP_MEAN_DAY** — numeric(0.100000), range 0.2000 15.8000, degrees Celsius Mean temperature for the day - **WATERTEMP_MEAN_FLAG** — varchar, enum Mean water temperature flag - **A** — Accepted value - **E** — Estimated value - **M** — Missing value - **Q** — Questionable value - **WATERTEMP_MAX_DAY** — numeric(0.100000), range 0.5000 16.5000, degrees Celsius Maximum water temperature for the day - **WATERTEMP_MAX_FLAG** — varchar, enum Maximum water temperature flag - **A** — Accepted value - **E** — Estimated value - **M** — Missing value - **Q** — Questionable value - **WATERTEMP_MIN_DAY** — numeric(0.100000), range 0.0000 15.4000, degrees Celsius Minimum water temperature for the day - **WATERTEMP_MIN_FLAG** — varchar, enum Minimum water temperature flag - **A** — Accepted value - **E** — Esimated value - **M** — Missing value - **Q** — Questionable value - **REGRESSION_SITE** — varchar, enum Reference site used to estimate values using linear regression - **GSWS01** — Andrews Watershed 1 Gaging Station - **GSWS02** — Andrews Watershed 2 Gaging Station - **GSWS07** — Andrews Watershed 7 Gaging Station - **GSWS08** — Andrews Watershed 8 Gaging Station - **PE003** — HJA Phenology Emergence Site 3 (WS08 stream) - **None** — No estimation (actual data is used) - **Manual** — Manual editing (no specific reference site) ## Entity 2: HT00602 ### Attribute list - **DBCODE** — varchar, enum FSDB Database Code - **HT006** — FSDB Database Code HT006 - **ENTITY** — numeric(1), range 2.0000 2.0000, number Entity Number - **SITECODE** — varchar, enum Site code - **PE001** — HJA Phenology Emergence Site 1 (WS01 stream) - **PE002** — HJA Phenology Emergence Site 2 (WS02 stream) - **PE003** — HJA Phenology Emergence Site 3 (WS08 stream) - **PE004** — HJA Phenology Emergence Site 4 (WS07 stream) - **PE005** — HJA Phenology Emergence Site 5 (Cold Creek) - **PE006** — HJA Phenology Emergence Site 6 (South Creek) - **SITETYPE** — varchar, enum Type of measurement site: core phenology emergence site - **PE** — Core phenology emergence stream site - **QC_LEVEL** — varchar, enum Quality control flag indicates level of quality checking performed - **1A** — Data is published and unlikely to change - automated range checking and manual review has been conducted - **1D** — Data is published and unlikely to change - data is derived or aggregated from published data of level 1A - **2A** — Data is published and unlikely to change - Level 1A data has been modified such that data gaps may be filled or problem data may be removed - **2D** — Data is published and unlikely to change - data is derived or aggregated from published data of level 2A - **DATE_TIME** — datetime, freetext Date and time of probe reading - **WATERTEMP_MEAN** — numeric(0.100000), range 0.0000 16.5000, degrees Celsius Mean water temperature over the last hour - **WATERTEMP_MEAN_FLAG** — varchar, enum Mean water temperature flag - **A** — Accepted value - **E** — Estimated value - **M** — Missing value - **Q** — Questionable value - **REGRESSION_SITE** — varchar, enum Reference site used to estimate values using linear regression - **GSWS01** — Andrews Watershed 1 Gaging Station - **GSWS02** — Andrews Watershed 2 Gaging Station - **GSWS07** — Andrews Watershed 7 Gaging Station - **GSWS08** — Andrews Watershed 8 Gaging Station - **PE003** — HJA Phenology Emergence Site 3 (WS08 stream) - **None** — No estimation (actual data is used) - **Manual** — Manual editing (no specific reference site) ## Attribute Definitions **DATE** Date **DATE_TIME** Date and time of probe reading **DBCODE** FSDB Database Code **ENTITY** Entity Number **QC_LEVEL** Quality control flag indicates level of quality checking performed **REGRESSION_SITE** Reference site used to estimate values using linear regression **SITECODE** Site code **SITETYPE** Type of measurement site: core phenology emergence site **WATERTEMP_MAX_DAY** Maximum water temperature for the day **WATERTEMP_MAX_FLAG** Maximum water temperature flag **WATERTEMP_MEAN** Mean water temperature over the last hour **WATERTEMP_MEAN_DAY** Mean temperature for the day **WATERTEMP_MEAN_FLAG** Mean water temperature flag **WATERTEMP_MIN_DAY** Minimum water temperature for the day **WATERTEMP_MIN_FLAG** Minimum water temperature flag ## Enumerated Domains ### DBCODE - **HT006** — FSDB Database Code HT006 ### SITECODE - **PE001** — HJA Phenology Emergence Site 1 (WS01 stream) - **PE002** — HJA Phenology Emergence Site 2 (WS02 stream) - **PE003** — HJA Phenology Emergence Site 3 (WS08 stream) - **PE004** — HJA Phenology Emergence Site 4 (WS07 stream) - **PE005** — HJA Phenology Emergence Site 5 (Cold Creek) - **PE006** — HJA Phenology Emergence Site 6 (South Creek) ### SITETYPE - **PE** — Core phenology emergence stream site ### QC_LEVEL - **1A** — Data is published and unlikely to change - automated range checking and manual review has been conducted - **1D** — Data is published and unlikely to change - data is derived or aggregated from published data of level 1A - **2A** — Data is published and unlikely to change - Level 1A data has been modified such that data gaps may be filled or problem data may be removed - **2D** — Data is published and unlikely to change - data is derived or aggregated from published data of level 2A ### WATERTEMP_MEAN_FLAG - **A** — Accepted value - **E** — Estimated value - **M** — Missing value - **Q** — Questionable value ### WATERTEMP_MAX_FLAG - **A** — Accepted value - **E** — Estimated value - **M** — Missing value - **Q** — Questionable value ### WATERTEMP_MIN_FLAG - **A** — Accepted value - **E** — Esimated value - **M** — Missing value - **Q** — Questionable value ### REGRESSION_SITE - **GSWS01** — Andrews Watershed 1 Gaging Station - **GSWS02** — Andrews Watershed 2 Gaging Station - **GSWS07** — Andrews Watershed 7 Gaging Station - **GSWS08** — Andrews Watershed 8 Gaging Station - **PE003** — HJA Phenology Emergence Site 3 (WS08 stream) - **None** — No estimation (actual data is used) - **Manual** — Manual editing (no specific reference site)