1. Home
  2. Organisations
  3. Environment and Science
  4. Ambient estuarine water quality monitoring data (includes near real-time sites) - 2012 to present day

Ambient estuarine water quality monitoring data (includes near real-time sites) - 2012 to present day

Half hourly in-situ estuarine water quality readings by station updated daily.

Data and Resources

Additional Info

Field Value
Source Not applicable
Version 1
Security Classification PUBLIC
Used in data driven application NO
Update Frequency Hourly

Comments

Gravatar Scott Lutwyche commented on 20 May 2020, 6:15PM

Timestamp data quality issues in dataset

Hello,
https://www.data.qld.gov.au/dataset/ambient-estuarine-water-quality-monitoring-data-near-real-time-sites-2012-to-present-day/resource/1bff3f93-49d3-46d7-9923-736dbdeeea43



^This dataset has a number of records that are future dated. Is this a model or a monitoring dataset?
I have screenshots
[7209,"2020-07-01T18:20:00",7209,420,753,18.245,330.306,15.856,-9.005,133.514,0.713,3.052,2.02,-11.823,36.077,50.377,1.172,0.626],
[7210,"2020-07-01T18:30:00",7210,420,753,20.407,329.057,17.407,-10.495,132.023,0.565,0.131,4.013,-27.572,100,0.681,0.96,0.203],
[7211,"2020-07-01T18:40:00",7211,420,753,24.912,330.11,21.52,-12.48,127.765,-0.486,-0.232,3.896,-27.415,100,0.997,1.639,0.32],
[7212,"2020-07-01T18:50:00",7212,420,753,26.53,328.942,22.725,-13.688,119.566,-1.066,-0.179,4.361,-26.094,100,1.631,2.227,0.375],
[7213,"2020-07-01T19:00:00",7213,420,753,23.363,329.737,20.168,-11.789,125.838,-0.566,0.203,4.431,-27.52,100,0.958,1.384,0.221],
[7214,"2020-07-01T19:10:00",7214,420,753,17.842,333.949,16.029,-7.836,130.001,0.119,0.035,4.336,-28.564,100,0.347,0.514,0.126],
[7215,"2020-07-01T19:20:00",7215,420,753,12.814,328.353,10.925,-6.624,126.042,0.431,0.095,4.42,-29.346,100,0.515,0.803,0.154],
[7216,"2020-07-01T19:30:00",7216,420,753,9.176,319.627,6.938,-5.991,121.894,0.806,-4.442,2.212,-13.248,35.204,50.443,0.936,0.564],
[7217,"2020-07-01T19:40:00",7217,420,753,4.58,176.042,4.544,-0.431,167.138,1.103,0.124,4.089,-30.212,100,1.113,1.208,0.075],
[7218,"2020-07-01T19:50:00",7218,420,753,2.631,85.406,0.011,0.719,279.003,1.092,6.5,4622.693,3.912,-29.918,100,1.096,1.182],
[7219,"2020-07-01T20:00:00",7219,420,753,3.674,165.682,-2.757,1.802,262.819,0.858,0.173,4.062,-30.408,100,0.884,1.019,0.095],
[7220,"2020-07-01T20:10:00",7220,420,753,9.748,151.988,-8.622,4.535,284.885,0.746,0.195,4.184,-30.314,100,0.867,0.969,0.074],
[7221,"2020-07-01T20:20:00",7221,420,753,11.795,155.152,-10.674,4.818,291.811,0.119,0.096,2.206,-13.502,34.489,50.606,1.478,0.


[8019,"2020-01-13T09:20:00",8019,420,753,48.996,322.796,38.558,-29.789,121.865,-7.75,0,-2.821,4.345,-9.009,100,8.264,8.876],
[8020,"2020-01-13T09:30:00",8020,420,753,52.34,315.342,37.172,-36.802,111.929,-8.529,-3.631,4.344,-8.483,100,9.305,10.037,0.434],
[8021,"2020-01-13T09:40:00",8021,420,753,50.393,318.432,37.705,-33.433,115.695,-8.229,0.447,4.547,-7.528,100,8.94,9.844,0.464],

Gravatar publisher-027 commented on 10 Jul 2020, 2:53AM

Hi Scott,
The dataset records monitoring data so all records should be in the past. If you downloaded the dataset, the data is correct and historic in the csv file. The portal on loading the csv flipped the day and month field in the timestamp making some dates appear in the future. The timestamp field has been converted to a text string in order to display the correct data.

Login to comment