Comments

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],

data.qld 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.

Gerard Carroll commented on 01 Oct 2020, 7:00AM

Burnett river dissolved oxygen probe

Does the Burnett river sonde measure dissolved oxygen with the membrane probe or the optical probe?

Login to comment