search

buzacott / bomWater

An R package to download Australian water data
MIT License
15 stars 5 forks source link

Water temperature data not available on some sites on bomWater? #11

Open trishfishkoh opened 2 years ago

trishfishkoh commented 2 years ago

Hi Alex,

Thanks for developing this package. I've been using it recently to download water temperature data from multiple sites.

I was having a look at some of the sites where there is water temperature data and it seems like they don't agree with what is available on https://data.water.vic.gov.au/.

For example, when I try to download water temperature data with bomWater for Avon - Stratford (site_no 225201 and 225201a), there seems to be no data. However, when I go to the data.water.vic site there seems to be existing data.

Can I ask why this might be? Is it because there's duplicate codes for this water gauge?

Cheers,

Trish

buzacott commented 2 years ago

Unfortunately, not all data for each site is uploaded to the BoM by the different states (annoying I know). I also had a look to see if it was perhaps stored at a different site code/number, but it appears for e.g. Avon there is no water temperature data:

avon <- get_station_list(station_number = '225201')

# Get bbox around avon to search
bbox <- c(floor(avon$station_longitude)-1,
          floor(avon$station_latitude) -1,
          ceiling(avon$station_longitude)+1,
          ceiling(avon$station_latitude)+1)

station_list <- get_station_list(bbox=bbox)

avon_stations <- station_list %>% 
  filter(str_detect(station_name, 'AVON'))

get_parameter_list(station_number = avon_stations$station_no)

# A tibble: 19 × 7
   station_no station_id station_name        parametertype_id parametertype_na… parametertype_u…
   <chr>           <int> <chr>                          <int> <chr>             <chr>           
 1 225201        2827708 AVON @ STRATFORD               11731 Rainfall          millimeter      
 2 225201        2827708 AVON @ STRATFORD               11762 Water Course Dis… cubic meter per…
 3 225201        2827708 AVON @ STRATFORD               11763 Water Course Lev… meter           
 4 225201A       3545591 AVON @ STRATFORD               11763 Water Course Lev… meter           
 5 225201A       3545591 AVON @ STRATFORD               11762 Water Course Dis… cubic meter per…
 6 225224        2828744 AVON @ CHANNEL                 11731 Rainfall          millimeter      
 7 225224        2828744 AVON @ CHANNEL                 11763 Water Course Lev… meter           
 8 225224        2828744 AVON @ CHANNEL                 11762 Water Course Dis… cubic meter per…
 9 225224A       3545650 AVON @ CHANNEL                 11763 Water Course Lev… meter           
10 225224A       3545650 AVON @ CHANNEL                 11762 Water Course Dis… cubic meter per…
11 225234        2829527 AVON R @ CHINN'S BR            11762 Water Course Dis… cubic meter per…
12 225234        2829527 AVON R @ CHINN'S BR            11748 Turbidity         nephlometric tu…
13 225234        2829527 AVON R @ CHINN'S BR            11763 Water Course Lev… meter           
14 225234B       3545700 AVON R @ CHINN'S BR            11762 Water Course Dis… cubic meter per…
15 225234B       3545700 AVON R @ CHINN'S BR            11763 Water Course Lev… meter           
16 225255        2829889 AVON U/S VALENCIA C            11763 Water Course Lev… meter           
17 225255        2829889 AVON U/S VALENCIA C            11762 Water Course Dis… cubic meter per…
18 225255A       3545772 AVON U/S VALENCIA C            11762 Water Course Dis… cubic meter per…
19 225255A       3545772 AVON U/S VALENCIA C            11763 Water Course Lev… meter

Double checking on water data online http://www.bom.gov.au/waterdata/ still shows no water temperature data for that site. As for why this is the case, you would have to ask Vic Water/BoM.

I also encountered this a couple of times and noticed that the state systems (at least QLD, VIC, NSW) use a similar system (Hydstra/Kisters) that has a web service that can be queried if you are looking to bulk download a lot of data. You would have to construct the queries yourself, or there could be another package out there.

trishfishkoh commented 2 years ago

Thanks so much for the reply Alex! I've managed to download from the Victorian web service, but it is a bit of a semi-manual job which is a bit painful (definitely achievable though).