Streamwatch historical survey data December1990-June2016

These partially quality coded data are from an extract from the decommissioned Oracle database that housed water quality data acquired through the citizen science program known as Streamwatch. The program supported volunteers to collect physical and chemical parameters of water quality across the Greater Sydney region, New South Wales, Australia. Data are from 30950 separate sampling events from December 1990 to June 2006. Date format is dd/mm/yyyy. The creation of these spreadsheets was to determine which data were good candidates for importing into the replacement database. There are two worksheets named; ‘Visits’ and ‘Results’. Each sampling event or survey on the ‘Visits’ sheet, has an associated unique identifier used to locate the associated water quality parameter data on the ‘Results’ sheet. Further information on site locations are available in the file, ‘Streamwatch Sites_coordinates_July2015.

本数据集为经部分质量编码的数据，取自已退役的甲骨文（Oracle）数据库，该数据库存储了通过Streamwatch公民科学项目采集的水质数据。该项目组织志愿者在澳大利亚新南威尔士州大悉尼地区采集水质的物理与化学参数。数据采集时段为1990年12月至2006年6月，共计30950次独立采样事件。日期格式为dd/mm/yyyy。编制此类电子表格的目的，是筛选适合导入替代数据库的合格数据。本数据集包含两个工作表，分别命名为"Visits"与"Results"。"Visits"工作表中的每一次采样事件或调查均关联唯一标识符，可用于在"Results"工作表中定位对应的水质参数数据。站点位置的更多详细信息可在文件"Streamwatch Sites_coordinates_July2015"中获取。