Sandgate - 2019
datastore ActiveURL: https://data.des.qld.gov.au/__data/assets/file/0025/255409/sandgate-2019.csv
This resource collects time series water physicochemical In-situ parameter readings, water (current) flow velocity and direction, Nitrogen and Carbon compounds and weather conditions every ten minutes.
Equipment is housed in a large yellow floating Buoy, anchored in position off Sandgate Beach, Bramble Bay, Brisbane, in approximately 4 meters of water, Lat: -27.302856 S Long: 153.105376 E Datum GDA 94 .
Water Quality is measured by a YSI EXO2 mulitparameter sonde at 0.4m below the surface, which collects : Timestamp, Record, EXO_TempC, EXO_SpCondmScm, EXO_Salpsu, EXO_pHmV, EXO_pH, EXO_Depthm, EXO_BatV, EXO_ChlugL, EXO_ChlRFU, EXO_DOPerSat, EXO_DOmgL, EXO_BGAPERFU, EXO_BGAPEugL, EXO_TurbFNU, EXO_fDOMRFU, EXO_fDOMQSU and EXO_TurbNTU data.
Water flow direction and velocity are also collected at a depth of 1.0 meter below the surface via an Aanderra Doppler Current Sensors (DCS) Model 420 which operates on the backscatter acoustic doppler principle.
The sensor has built-in compass and tilt sensor.
Doppler Parameters measured/collected are: Timestamp, Record, DCS_Model, DCS_ Serial, DCS_ABSSpeed_Avg (UNIT cm/S), DCS_Direction_Avg, DCS_NorthCur_Avg, DCS_Heading_AVG, DCS_TiltX_Avg, DCS_TiltY_Avg, DCS_SPstd_Avg, DCS_SigStrenght_Avg, DCS_PingCnt_Avg, DCS_AbsTilt_Avg, DCS_MaxTilt_Avg, DCS_StdTilt_Avg. A Trios ""Opus"" spectrophotometer with 10 mm optical path, submerged at 1 meter below the surface, measures Nitrogen and Carbon compounds, such as: Nitrate NO3-N, Nitrite NO2-N, CODeq, BODeq, DOCeq, TOCeq, TSSeq, KHP, SAC254, COD-SACeq, BOD-SACeq. Mounted on the vertical spar on the outside of the buoy, the Gill Maximet Compact Weather Station GMX100 measures Ambient Air conditions such as; Gill_Ws_Mean, Gill_Wd_MeanUnitVector, Gill_Wd_StdDev, Gill_WindSpd_Max, Gill_Temperature_Avg, Gill_RH, Gill_Pressure, Gill_Rain_mm_Tot, Gill_TotalRain_mm, Gill_DewPoint_Avg, Gill_SRad_Avg, Gill_SunHours_Avg, Gill_Latitude, Gill_Longitude, Gill_Time, Gill_Status, Gill_Status1, Gill_Status2, Gill_Status3, Gill_Status4, Gill_Status5, Gill_Status6.
See YSI website for instrument accuracy, method of operation etc. For more information visit:
There are no views created for this resource yet.
Data Dictionary
| Column | Type | Label | Description |
|---|---|---|---|
| TIMESTAMP | timestamp | ||
| RECORD | numeric | ||
| Station | text | ||
| LoggerBattV | numeric | ||
| LoggerPanelTemp | numeric | ||
| EXO_TempC | numeric | ||
| EXO_SpCondmScm | numeric | ||
| EXO_Salpsu | numeric | ||
| EXO_pHmV | numeric | ||
| EXO_pH | numeric | ||
| EXO_ORPmV | numeric | ||
| EXO_Depthm | numeric | ||
| EXO_BatV | numeric | ||
| EXO_TSSmgL | numeric | ||
| EXO_ChlugL | numeric | ||
| EXO_ChlRFU | numeric | ||
| EXO_DOPerSat | numeric | ||
| EXO_DOmgL | numeric | ||
| EXO_BGAPCRFU | numeric | ||
| EXO_BGAPERFU | numeric | ||
| EXO_BGAPCugL | numeric | ||
| EXO_BGAPEugL | numeric | ||
| EXO_TurbFNU | numeric | ||
| EXO_fDOMRFU | numeric | ||
| EXO_fDOMQSU | numeric | ||
| EXO_TurbNTU | numeric | ||
| ABSSpd_Avg | numeric | ||
| Direction_Avg | numeric | ||
| NorthCur_Avg | numeric | ||
| EastCur_Avg | numeric | ||
| Heading_Avg | numeric | ||
| TiltX_Avg | numeric | ||
| TiltY_Avg | numeric | ||
| SPstd_Avg | numeric | ||
| SigStrength_Avg | numeric | ||
| PingCnt_Avg | numeric | ||
| AbsTilt_Avg | numeric | ||
| MaxTilt_Avg | numeric | ||
| StdTilt_Avg | numeric | ||
| Gill_Ws_Mean | numeric | ||
| Gill_Wd_MeanUnitVector | numeric | ||
| Gill_Wd_StdDev | numeric | ||
| Gill_WindSpd_Max | numeric | ||
| Gill_Temperature_Avg | numeric | ||
| Gill_RH | numeric | ||
| Gill_Pressure | numeric | ||
| Gill_Rain_mm_Tot | numeric | ||
| Gill_TotalRain_mm | numeric | ||
| Gill_DewPoint_Avg | numeric | ||
| Gill_SRad_Avg | numeric | ||
| Gill_SunHours_Avg | numeric | ||
| Gill_Latitude | numeric | ||
| Gill_Longitude | numeric | ||
| Gill_Time | numeric | ||
| Gill_TotalDailyRain_mm | numeric | ||
| OPUS517_ActiveLSA | text | ||
| OPUS1000_N_NO3 | numeric | ||
| OPUS1004_CODeq | numeric | ||
| OPUS1014_TOCeq | numeric | ||
| OPUS1016_TSSeq | numeric | ||
| OPUS1032_SAC254 | numeric | ||
| OPUS1034_Abs360 | numeric | ||
| OPUS1036_Abs210 | numeric | ||
| OPUS1038_FitError | numeric | ||
| OPUS1042_Abs254 | numeric | ||
| OPUS1052_COD_SACeq | numeric | ||
| OPUS1060_SQI | numeric | ||
| OPUS1_MeasureTime | numeric | ||
| ModemTimeOn | numeric | ||
| ModemTimeOff | numeric |
Additional Information
| Field | Value |
|---|---|
| Data last updated | 6 December 2021 |
| Metadata last updated | 6 December 2021 |
| Created | 6 December 2021 |
| Format | CSV |
| License | Creative Commons Attribution 4.0 |
| Size | 3 MiB |
| Aligned with default data schema | |
| Archiver | {'resource_timestamp': '2021-12-06T03:25:59.943115', 'status_id': 0, 'is_broken': False, 'reason': '', 'url_redirected_to': None, 'cache_filepath': 'archive/33/335642ea-2b68-47a7-aca9-b95f00e29fbf/sandgate-2019.csv', 'cache_url': 'https://www.data.qld.gov.au/dataset/ad16501a-39ac-4bee-8301-83cca98a4089/resource/335642ea-2b68-47a7-aca9-b95f00e29fbf/archive/sandgate-2019.csv', 'size': 3263057, 'mimetype': 'application/octet-stream', 'hash': '7fa31ae8085ec9035f568217d3f16fd450cf51be', 'etag': None, 'last_modified': None, 'first_failure': None, 'last_success': '2022-03-08T09:48:06.006226', 'failure_count': 0, 'created': '2021-12-06T03:25:32.565438', 'updated': '2022-03-08T09:48:06.006226', 'status': 'Archived successfully', 'is_broken_printable': 'Downloaded OK'} |
| Ckan url | https://www.data.qld.gov.au |
| Datastore active | True |
| Datastore contains all records of source file | True |
| Has views | False |
| Hash | 448013063667c670745fc4afe54d61a4 |
| Id | 335642ea-2b68-47a7-aca9-b95f00e29fbf |
| Ignore hash | False |
| Original url | https://data.des.qld.gov.au/__data/assets/file/0025/255409/sandgate-2019.csv |
| Package id | ad16501a-39ac-4bee-8301-83cca98a4089 |
| Position | 0 |
| Qa | {'resource_timestamp': None, 'archival_timestamp': '2022-03-08T09:48:06.006226', 'openness_score': 3, 'openness_score_reason': 'Content of file appeared to be format "CSV" which receives openness score: 3.', 'format': 'CSV', 'created': '2021-12-06T03:25:36.992856', 'updated': '2022-03-08T17:39:39.199160'} |
| Resource id | 335642ea-2b68-47a7-aca9-b95f00e29fbf |
| Set url type | False |
| Size | 3 MiB |
| State | active |
| Task created | 2021-12-06 03:25:24.620765 |
| Validation status | success |
| Validation timestamp | 3 years ago |
Link checked: 8 March 2022