vignettes/a01_Import_raw_data.Rmd
a01_Import_raw_data.RmdThis vignette documents the raw data import, calculation of mean lesion values and exports the new data to “data/lesion_counts.rda” for further use in visualisation and analysis.
In the first step, the data is imported, the “m” from the
distance column is dropped and the column is converted to
numeric. A new column, SpEv (Spread Event), is created for
each location and replicated event at that location. Another new column,
degrees, is added for each transect to indicate the
direction in degrees based on J. Fanning’s best information. Lastly the
mean lesions counted per plant within the pot, m_lesions is
calculated for each of the transects at each distance, 0, 10, 25, 50 and
75 metres from the plots.
After the data are updated, a column for precipitation type,
ptype, is added and the spread events, SpEv,
are renamed for clarity and ordered as factors for data
visualisation.
lesion_counts <-
read_csv(
system.file(
"extdata",
"lesion_counts.csv",
package = "ChickpeaAscoDispersal",
mustWork = TRUE
)
) %>%
mutate(site = str_remove(site, " SPA")) %>%
mutate(distance = as.numeric(str_replace(distance, " m", ""))) %>%
unite(SpEv, c(site, rep), remove = FALSE) %>%
mutate(
degrees = case_when(
site == "Curyo" & transect == 1 ~ 290,
site == "Curyo" & transect == 2 ~ 300,
site == "Curyo" & transect == 3 ~ 310,
site == "Curyo" & transect == 4 ~ 320,
site == "Curyo" & transect == 5 ~ 330,
site == "Curyo" & transect == 6 ~ 340,
site == "Curyo" & transect == 7 ~ 350,
site == "Curyo" & transect == 8 ~ 360,
site == "Curyo" & transect == 9 ~ 10,
site == "Curyo" & transect == 10 ~ 20,
site == "Horsham" & transect == 1 ~ 45,
site == "Horsham" & transect == 2 ~ 55,
site == "Horsham" & transect == 3 ~ 65,
site == "Horsham" & transect == 4 ~ 75,
site == "Horsham" & transect == 5 ~ 85,
site == "Horsham" & transect == 6 ~ 95,
site == "Horsham" & transect == 7 ~ 105,
site == "Horsham" & transect == 8 ~ 115,
site == "Horsham" & transect == 9 ~ 125,
site == "Horsham" & transect == 10 ~ 135,
site == "pbc" & transect == 1 ~ 45,
site == "pbc" & transect == 2 ~ 55,
site == "pbc" & transect == 3 ~ 65,
site == "pbc" & transect == 4 ~ 75,
site == "pbc" & transect == 5 ~ 85,
site == "pbc" & transect == 6 ~ 95,
site == "pbc" & transect == 7 ~ 105,
site == "pbc" & transect == 8 ~ 115,
site == "pbc" & transect == 9 ~ 125,
site == "pbc" & transect == 10 ~ 135
)
) %>%
mutate(
ptype = case_when(
SpEv == "pbc_1" ~ "irrigation",
SpEv == "pbc_2" ~ "irrigation",
SpEv == "pbc_3" ~ "mixed",
SpEv == "Horsham_1" ~ "rainfall",
SpEv == "Horsham_2" ~ "rainfall",
SpEv == "Curyo_1" ~ "rainfall"
)
) %>%
mutate(
site = case_when(
site == "pbc" ~ "Horsham irrigated",
site == "Horsham" ~ "Horsham dryland",
site == "Curyo" ~ "Curyo"
)
) %>%
mutate(
SpEv = case_when(
SpEv == "pbc_1" ~ "Horsham Irrg 1",
SpEv == "pbc_2" ~ "Horsham Irrg 2",
SpEv == "pbc_3" ~ "Horsham Mixd 1",
SpEv == "Horsham_1" ~ "Horsham Rain 1",
SpEv == "Horsham_2" ~ "Horsham Rain 2",
SpEv == "Curyo_1" ~ "Curyo Rain 1"
)
) %>%
mutate_at(vars(SpEv, site, rep), factor) %>%
mutate(m_lesions = rowMeans(select(., counts_p1:counts_p5),
na.rm = TRUE)) %>%
select(-dist_stat) %>%
arrange(SpEv, transect, distance)
kable(lesion_counts)| SpEv | site | rep | distance | station | transect | plant_no | pot_no | counts_p1 | counts_p2 | counts_p3 | counts_p4 | counts_p5 | degrees | ptype | m_lesions |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Curyo Rain 1 | Curyo | 1 | 0 | 1 | 1 | 5 | 1 | 2 | 0 | 4 | 2 | 2 | 290 | rainfall | 2.0000000 |
| Curyo Rain 1 | Curyo | 1 | 0 | 1 | 1 | 5 | 2 | 3 | 0 | 0 | 2 | 3 | 290 | rainfall | 1.6000000 |
| Curyo Rain 1 | Curyo | 1 | 10 | 1 | 1 | 5 | 9 | 0 | 3 | 0 | 1 | 1 | 290 | rainfall | 1.0000000 |
| Curyo Rain 1 | Curyo | 1 | 10 | 1 | 1 | 5 | 10 | 2 | 0 | 0 | 2 | 4 | 290 | rainfall | 1.6000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 1 | 1 | 5 | 17 | 2 | 0 | 1 | 0 | 0 | 290 | rainfall | 0.6000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 1 | 1 | 5 | 18 | 2 | 1 | 0 | 2 | 0 | 290 | rainfall | 1.0000000 |
| Curyo Rain 1 | Curyo | 1 | 50 | 1 | 1 | 3 | 37 | 0 | 4 | 1 | NA | NA | 290 | rainfall | 1.6666667 |
| Curyo Rain 1 | Curyo | 1 | 75 | 1 | 1 | 3 | 47 | 0 | 1 | 1 | NA | NA | 290 | rainfall | 0.6666667 |
| Curyo Rain 1 | Curyo | 1 | 25 | 2 | 2 | 5 | 19 | 1 | 2 | 1 | 2 | 2 | 300 | rainfall | 1.6000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 2 | 2 | 5 | 20 | 1 | 0 | 0 | 0 | 1 | 300 | rainfall | 0.4000000 |
| Curyo Rain 1 | Curyo | 1 | 50 | 2 | 2 | 3 | 38 | 0 | 0 | 0 | NA | NA | 300 | rainfall | 0.0000000 |
| Curyo Rain 1 | Curyo | 1 | 75 | 2 | 2 | 3 | 48 | 1 | 0 | 0 | NA | NA | 300 | rainfall | 0.3333333 |
| Curyo Rain 1 | Curyo | 1 | 25 | 3 | 3 | 5 | 21 | 2 | 2 | 1 | 3 | NA | 310 | rainfall | 2.0000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 3 | 3 | 5 | 22 | 0 | 1 | 1 | 0 | NA | 310 | rainfall | 0.5000000 |
| Curyo Rain 1 | Curyo | 1 | 50 | 3 | 3 | 3 | 39 | 1 | 0 | 0 | NA | NA | 310 | rainfall | 0.3333333 |
| Curyo Rain 1 | Curyo | 1 | 75 | 3 | 3 | 3 | 49 | 0 | 0 | 1 | NA | NA | 310 | rainfall | 0.3333333 |
| Curyo Rain 1 | Curyo | 1 | 0 | 2 | 4 | 5 | 3 | 0 | 2 | 3 | 1 | 2 | 320 | rainfall | 1.6000000 |
| Curyo Rain 1 | Curyo | 1 | 0 | 2 | 4 | 5 | 4 | 3 | 3 | 0 | 5 | 9 | 320 | rainfall | 4.0000000 |
| Curyo Rain 1 | Curyo | 1 | 10 | 2 | 4 | 5 | 11 | 0 | 0 | 0 | 0 | 0 | 320 | rainfall | 0.0000000 |
| Curyo Rain 1 | Curyo | 1 | 10 | 2 | 4 | 5 | 12 | 0 | 0 | 0 | 2 | NA | 320 | rainfall | 0.5000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 4 | 4 | 5 | 23 | NA | NA | NA | NA | NA | 320 | rainfall | NaN |
| Curyo Rain 1 | Curyo | 1 | 25 | 4 | 4 | 5 | 24 | NA | NA | NA | NA | NA | 320 | rainfall | NaN |
| Curyo Rain 1 | Curyo | 1 | 50 | 4 | 4 | 3 | 40 | 1 | 0 | 0 | NA | NA | 320 | rainfall | 0.3333333 |
| Curyo Rain 1 | Curyo | 1 | 75 | 4 | 4 | 3 | 50 | 0 | 0 | 0 | NA | NA | 320 | rainfall | 0.0000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 5 | 5 | 5 | 25 | 0 | 1 | 0 | 0 | 0 | 330 | rainfall | 0.2000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 5 | 5 | 5 | 26 | 0 | 0 | 0 | 1 | 2 | 330 | rainfall | 0.6000000 |
| Curyo Rain 1 | Curyo | 1 | 50 | 5 | 5 | 3 | 41 | 2 | 0 | 0 | NA | NA | 330 | rainfall | 0.6666667 |
| Curyo Rain 1 | Curyo | 1 | 75 | 5 | 5 | 3 | 51 | 0 | 0 | 0 | NA | NA | 330 | rainfall | 0.0000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 6 | 6 | 5 | 27 | 0 | 2 | 0 | 0 | 2 | 340 | rainfall | 0.8000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 6 | 6 | 5 | 28 | 0 | 0 | 0 | 1 | 0 | 340 | rainfall | 0.2000000 |
| Curyo Rain 1 | Curyo | 1 | 50 | 6 | 6 | 3 | 42 | 0 | 0 | 0 | NA | NA | 340 | rainfall | 0.0000000 |
| Curyo Rain 1 | Curyo | 1 | 75 | 6 | 6 | 3 | 52 | 0 | 1 | 1 | NA | NA | 340 | rainfall | 0.6666667 |
| Curyo Rain 1 | Curyo | 1 | 0 | 3 | 7 | 5 | 5 | 0 | 0 | 4 | 1 | 1 | 350 | rainfall | 1.2000000 |
| Curyo Rain 1 | Curyo | 1 | 0 | 3 | 7 | 5 | 6 | 3 | 2 | 0 | 1 | 2 | 350 | rainfall | 1.6000000 |
| Curyo Rain 1 | Curyo | 1 | 10 | 3 | 7 | 5 | 13 | 3 | 1 | 3 | 0 | 0 | 350 | rainfall | 1.4000000 |
| Curyo Rain 1 | Curyo | 1 | 10 | 3 | 7 | 5 | 14 | 2 | 2 | 1 | 0 | 0 | 350 | rainfall | 1.0000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 7 | 7 | 5 | 29 | 1 | 1 | 1 | 2 | 2 | 350 | rainfall | 1.4000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 7 | 7 | 5 | 30 | 0 | 0 | 0 | 0 | 0 | 350 | rainfall | 0.0000000 |
| Curyo Rain 1 | Curyo | 1 | 50 | 7 | 7 | 3 | 43 | 0 | 1 | 2 | NA | NA | 350 | rainfall | 1.0000000 |
| Curyo Rain 1 | Curyo | 1 | 75 | 7 | 7 | 3 | 53 | 0 | 0 | 1 | NA | NA | 350 | rainfall | 0.3333333 |
| Curyo Rain 1 | Curyo | 1 | 25 | 8 | 8 | 5 | 31 | 0 | 2 | 2 | 0 | 1 | 360 | rainfall | 1.0000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 8 | 8 | 5 | 32 | 1 | 2 | 0 | 0 | 0 | 360 | rainfall | 0.6000000 |
| Curyo Rain 1 | Curyo | 1 | 50 | 8 | 8 | 3 | 44 | 0 | 0 | 1 | NA | NA | 360 | rainfall | 0.3333333 |
| Curyo Rain 1 | Curyo | 1 | 75 | 8 | 8 | 3 | 54 | 0 | 0 | 1 | NA | NA | 360 | rainfall | 0.3333333 |
| Curyo Rain 1 | Curyo | 1 | 25 | 9 | 9 | 5 | 33 | 1 | 1 | 0 | 0 | 2 | 10 | rainfall | 0.8000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 9 | 9 | 5 | 34 | 1 | 0 | 0 | 0 | 0 | 10 | rainfall | 0.2000000 |
| Curyo Rain 1 | Curyo | 1 | 50 | 9 | 9 | 3 | 45 | 0 | 0 | 0 | NA | NA | 10 | rainfall | 0.0000000 |
| Curyo Rain 1 | Curyo | 1 | 75 | 9 | 9 | 3 | 55 | 0 | 1 | 0 | NA | NA | 10 | rainfall | 0.3333333 |
| Curyo Rain 1 | Curyo | 1 | 0 | 4 | 10 | 5 | 7 | 2 | 0 | 0 | 4 | 2 | 20 | rainfall | 1.6000000 |
| Curyo Rain 1 | Curyo | 1 | 0 | 4 | 10 | 5 | 8 | 3 | 2 | 0 | 3 | NA | 20 | rainfall | 2.0000000 |
| Curyo Rain 1 | Curyo | 1 | 10 | 4 | 10 | 5 | 15 | 2 | 0 | 0 | 0 | 0 | 20 | rainfall | 0.4000000 |
| Curyo Rain 1 | Curyo | 1 | 10 | 4 | 10 | 5 | 16 | 0 | 0 | 2 | 0 | 1 | 20 | rainfall | 0.6000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 10 | 10 | 5 | 35 | 0 | 0 | 2 | 0 | 1 | 20 | rainfall | 0.6000000 |
| Curyo Rain 1 | Curyo | 1 | 25 | 10 | 10 | 5 | 36 | 0 | 1 | 0 | NA | NA | 20 | rainfall | 0.3333333 |
| Curyo Rain 1 | Curyo | 1 | 50 | 10 | 10 | 3 | 46 | 0 | 0 | 1 | NA | NA | 20 | rainfall | 0.3333333 |
| Curyo Rain 1 | Curyo | 1 | 75 | 10 | 10 | 3 | 56 | 0 | 1 | 0 | NA | NA | 20 | rainfall | 0.3333333 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 0 | 1 | 1 | 5 | 1 | 1 | 2 | 2 | 0 | 3 | 45 | irrigation | 1.6000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 0 | 1 | 1 | 5 | 2 | 2 | 5 | 1 | 1 | 4 | 45 | irrigation | 2.6000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 10 | 1 | 1 | 5 | 9 | 0 | 2 | 0 | 0 | 0 | 45 | irrigation | 0.4000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 10 | 1 | 1 | 5 | 10 | 1 | 0 | 0 | 0 | 2 | 45 | irrigation | 0.6000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 1 | 1 | 5 | 17 | 3 | 0 | 1 | 0 | 0 | 45 | irrigation | 0.8000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 1 | 1 | 5 | 18 | 1 | 1 | 2 | 2 | 0 | 45 | irrigation | 1.2000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 50 | 1 | 1 | 3 | 37 | 0 | 0 | 0 | NA | NA | 45 | irrigation | 0.0000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 75 | 1 | 1 | 3 | 47 | 0 | 2 | 0 | NA | NA | 45 | irrigation | 0.6666667 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 2 | 2 | 5 | 19 | 0 | 3 | 6 | 0 | 0 | 55 | irrigation | 1.8000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 2 | 2 | 5 | 20 | 5 | 0 | 0 | 0 | 1 | 55 | irrigation | 1.2000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 50 | 2 | 2 | 3 | 38 | 3 | 0 | 0 | NA | NA | 55 | irrigation | 1.0000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 75 | 2 | 2 | 3 | 48 | 0 | 0 | 3 | NA | NA | 55 | irrigation | 1.0000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 3 | 3 | 5 | 21 | 0 | 0 | 0 | 0 | 0 | 65 | irrigation | 0.0000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 3 | 3 | 5 | 22 | 0 | 0 | 0 | 1 | 2 | 65 | irrigation | 0.6000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 50 | 3 | 3 | 3 | 39 | 2 | 0 | 0 | NA | NA | 65 | irrigation | 0.6666667 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 75 | 3 | 3 | 3 | 49 | 1 | 0 | 0 | NA | NA | 65 | irrigation | 0.3333333 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 0 | 2 | 4 | 5 | 3 | 3 | 3 | 4 | 3 | 2 | 75 | irrigation | 3.0000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 0 | 2 | 4 | 5 | 4 | 5 | 3 | 1 | 3 | 2 | 75 | irrigation | 2.8000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 10 | 2 | 4 | 5 | 11 | 3 | 0 | 0 | 1 | 1 | 75 | irrigation | 1.0000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 10 | 2 | 4 | 5 | 12 | 0 | 2 | 5 | 0 | 2 | 75 | irrigation | 1.8000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 4 | 4 | 5 | 23 | 2 | 2 | 0 | 0 | 0 | 75 | irrigation | 0.8000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 4 | 4 | 5 | 24 | 0 | 2 | 1 | 1 | 0 | 75 | irrigation | 0.8000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 50 | 4 | 4 | 3 | 40 | 1 | 0 | 0 | NA | NA | 75 | irrigation | 0.3333333 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 75 | 4 | 4 | 3 | 50 | 2 | 1 | 0 | NA | NA | 75 | irrigation | 1.0000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 5 | 5 | 5 | 25 | 2 | 1 | 0 | 0 | 0 | 85 | irrigation | 0.6000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 5 | 5 | 5 | 26 | 2 | 0 | 1 | 0 | 0 | 85 | irrigation | 0.6000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 50 | 5 | 5 | 3 | 41 | 1 | 0 | 0 | NA | NA | 85 | irrigation | 0.3333333 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 75 | 5 | 5 | 3 | 51 | 0 | 0 | 0 | NA | NA | 85 | irrigation | 0.0000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 6 | 6 | 5 | 27 | 1 | 0 | 0 | 3 | 0 | 95 | irrigation | 0.8000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 6 | 6 | 5 | 28 | 0 | 0 | 0 | 3 | 0 | 95 | irrigation | 0.6000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 50 | 6 | 6 | 3 | 42 | 0 | 1 | 1 | NA | NA | 95 | irrigation | 0.6666667 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 75 | 6 | 6 | 3 | 52 | 0 | 0 | 0 | NA | NA | 95 | irrigation | 0.0000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 0 | 3 | 7 | 5 | 5 | 3 | 1 | 4 | 5 | 3 | 105 | irrigation | 3.2000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 0 | 3 | 7 | 5 | 6 | 0 | 3 | 2 | 3 | 2 | 105 | irrigation | 2.0000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 10 | 3 | 7 | 5 | 13 | 0 | 1 | 1 | 0 | 0 | 105 | irrigation | 0.4000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 10 | 3 | 7 | 5 | 14 | 2 | 0 | 4 | 0 | 0 | 105 | irrigation | 1.2000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 7 | 7 | 5 | 29 | 2 | 1 | 0 | 0 | 0 | 105 | irrigation | 0.6000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 7 | 7 | 5 | 30 | 1 | 0 | 0 | 0 | 1 | 105 | irrigation | 0.4000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 50 | 7 | 7 | 3 | 43 | 1 | 0 | 0 | NA | NA | 105 | irrigation | 0.3333333 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 75 | 7 | 7 | 3 | 53 | 0 | 1 | 3 | NA | NA | 105 | irrigation | 1.3333333 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 8 | 8 | 5 | 31 | 1 | 0 | 0 | 0 | 1 | 115 | irrigation | 0.4000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 8 | 8 | 5 | 32 | 1 | 1 | 0 | 0 | 0 | 115 | irrigation | 0.4000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 50 | 8 | 8 | 3 | 44 | 1 | 2 | 2 | NA | NA | 115 | irrigation | 1.6666667 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 75 | 8 | 8 | 3 | 54 | 3 | 0 | 0 | NA | NA | 115 | irrigation | 1.0000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 9 | 9 | 5 | 33 | 3 | 1 | 2 | 0 | 1 | 125 | irrigation | 1.4000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 9 | 9 | 5 | 34 | 0 | 1 | 0 | 0 | 0 | 125 | irrigation | 0.2000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 50 | 9 | 9 | 3 | 45 | 1 | 0 | 1 | NA | NA | 125 | irrigation | 0.6666667 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 75 | 9 | 9 | 3 | 55 | 0 | 0 | 0 | NA | NA | 125 | irrigation | 0.0000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 0 | 4 | 10 | 5 | 7 | 2 | 2 | 1 | 1 | 1 | 135 | irrigation | 1.4000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 0 | 4 | 10 | 5 | 8 | 0 | 3 | 5 | 4 | 2 | 135 | irrigation | 2.8000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 10 | 4 | 10 | 5 | 15 | 1 | 0 | 1 | 0 | 0 | 135 | irrigation | 0.4000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 10 | 4 | 10 | 5 | 16 | 6 | 3 | 2 | 3 | 2 | 135 | irrigation | 3.2000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 10 | 10 | 5 | 35 | 1 | 0 | 0 | 0 | 1 | 135 | irrigation | 0.4000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 25 | 10 | 10 | 5 | 36 | 2 | 0 | 0 | 0 | 3 | 135 | irrigation | 1.0000000 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 50 | 10 | 10 | 3 | 46 | 0 | 2 | 0 | NA | NA | 135 | irrigation | 0.6666667 |
| Horsham Irrg 1 | Horsham irrigated | 1 | 75 | 10 | 10 | 3 | 56 | 0 | 0 | 0 | NA | NA | 135 | irrigation | 0.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 0 | 1 | 1 | 5 | 1 | 7 | 4 | 3 | 3 | 4 | 45 | irrigation | 4.2000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 0 | 1 | 1 | 5 | 2 | 3 | 3 | 4 | 9 | 8 | 45 | irrigation | 5.4000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 10 | 1 | 1 | 5 | 9 | 2 | 1 | 2 | 2 | 1 | 45 | irrigation | 1.6000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 10 | 1 | 1 | 5 | 10 | 0 | 2 | 2 | 1 | 1 | 45 | irrigation | 1.2000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 1 | 1 | 5 | 17 | 1 | 3 | 2 | 2 | NA | 45 | irrigation | 2.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 1 | 1 | 5 | 18 | 6 | 1 | 2 | 3 | 1 | 45 | irrigation | 2.6000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 50 | 1 | 1 | 3 | 37 | 0 | 0 | 0 | NA | NA | 45 | irrigation | 0.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 75 | 1 | 1 | 3 | 47 | 0 | 0 | 0 | NA | NA | 45 | irrigation | 0.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 2 | 2 | 5 | 19 | 3 | 2 | 2 | 1 | 0 | 55 | irrigation | 1.6000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 2 | 2 | 5 | 20 | 1 | 0 | 1 | 1 | NA | 55 | irrigation | 0.7500000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 50 | 2 | 2 | 3 | 38 | 0 | 0 | 3 | NA | NA | 55 | irrigation | 1.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 75 | 2 | 2 | 3 | 48 | 1 | 0 | 0 | NA | NA | 55 | irrigation | 0.3333333 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 3 | 3 | 5 | 21 | 1 | 0 | 0 | 2 | NA | 65 | irrigation | 0.7500000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 3 | 3 | 5 | 22 | 2 | 0 | 1 | 3 | 3 | 65 | irrigation | 1.8000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 50 | 3 | 3 | 3 | 39 | 4 | 0 | 1 | NA | NA | 65 | irrigation | 1.6666667 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 75 | 3 | 3 | 3 | 49 | 1 | 1 | 2 | NA | NA | 65 | irrigation | 1.3333333 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 0 | 2 | 4 | 5 | 3 | 5 | 2 | 4 | 2 | 2 | 75 | irrigation | 3.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 0 | 2 | 4 | 5 | 4 | 3 | 1 | 3 | 5 | 3 | 75 | irrigation | 3.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 10 | 2 | 4 | 5 | 11 | 2 | 0 | 4 | 2 | 2 | 75 | irrigation | 2.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 10 | 2 | 4 | 5 | 12 | 2 | 2 | 2 | 1 | 2 | 75 | irrigation | 1.8000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 4 | 4 | 5 | 23 | 2 | 2 | 1 | 2 | 1 | 75 | irrigation | 1.6000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 4 | 4 | 5 | 24 | 3 | 3 | 1 | 1 | 4 | 75 | irrigation | 2.4000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 50 | 4 | 4 | 3 | 40 | 0 | 0 | 0 | NA | NA | 75 | irrigation | 0.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 75 | 4 | 4 | 3 | 50 | 0 | 0 | 0 | NA | NA | 75 | irrigation | 0.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 5 | 5 | 5 | 25 | 2 | 0 | 2 | 1 | 5 | 85 | irrigation | 2.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 5 | 5 | 5 | 26 | 4 | 3 | 1 | NA | NA | 85 | irrigation | 2.6666667 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 50 | 5 | 5 | 3 | 41 | 0 | 0 | 0 | NA | NA | 85 | irrigation | 0.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 75 | 5 | 5 | 3 | 51 | 0 | 0 | 0 | NA | NA | 85 | irrigation | 0.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 6 | 6 | 5 | 27 | 2 | 2 | 0 | 2 | 1 | 95 | irrigation | 1.4000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 6 | 6 | 5 | 28 | 4 | 5 | 1 | 3 | 2 | 95 | irrigation | 3.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 50 | 6 | 6 | 3 | 42 | 0 | 0 | 0 | NA | NA | 95 | irrigation | 0.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 75 | 6 | 6 | 3 | 52 | 2 | 1 | 0 | NA | NA | 95 | irrigation | 1.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 0 | 3 | 7 | 5 | 5 | 7 | 2 | 0 | 4 | 6 | 105 | irrigation | 3.8000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 0 | 3 | 7 | 5 | 6 | 4 | 3 | 4 | 1 | 5 | 105 | irrigation | 3.4000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 10 | 3 | 7 | 5 | 13 | 2 | 1 | 0 | 0 | 5 | 105 | irrigation | 1.6000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 10 | 3 | 7 | 5 | 14 | 2 | 3 | 3 | 2 | 2 | 105 | irrigation | 2.4000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 7 | 7 | 5 | 29 | 4 | 0 | 0 | 2 | 0 | 105 | irrigation | 1.2000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 7 | 7 | 5 | 30 | 0 | 2 | 0 | 1 | 0 | 105 | irrigation | 0.6000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 50 | 7 | 7 | 3 | 43 | 0 | 0 | 0 | NA | NA | 105 | irrigation | 0.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 75 | 7 | 7 | 3 | 53 | 2 | 0 | 0 | NA | NA | 105 | irrigation | 0.6666667 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 8 | 8 | 5 | 31 | 1 | 1 | 0 | 0 | 1 | 115 | irrigation | 0.6000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 8 | 8 | 5 | 32 | 1 | 0 | 2 | 0 | 1 | 115 | irrigation | 0.8000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 50 | 8 | 8 | 3 | 44 | 0 | 0 | 0 | NA | NA | 115 | irrigation | 0.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 75 | 8 | 8 | 3 | 54 | 1 | 0 | 0 | NA | NA | 115 | irrigation | 0.3333333 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 9 | 9 | 5 | 33 | 4 | 3 | 0 | 1 | 2 | 125 | irrigation | 2.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 9 | 9 | 5 | 34 | 1 | 1 | 0 | 0 | 0 | 125 | irrigation | 0.4000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 50 | 9 | 9 | 3 | 45 | 1 | 0 | 2 | NA | NA | 125 | irrigation | 1.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 75 | 9 | 9 | 3 | 55 | 0 | 0 | 0 | NA | NA | 125 | irrigation | 0.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 0 | 4 | 10 | 5 | 7 | 3 | 2 | 3 | 2 | 3 | 135 | irrigation | 2.6000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 0 | 4 | 10 | 5 | 8 | 4 | 2 | 5 | 1 | 0 | 135 | irrigation | 2.4000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 10 | 4 | 10 | 5 | 15 | 2 | 0 | 1 | 0 | 0 | 135 | irrigation | 0.6000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 10 | 4 | 10 | 5 | 16 | 2 | 4 | 0 | 0 | 0 | 135 | irrigation | 1.2000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 10 | 10 | 5 | 35 | 3 | 0 | 3 | 0 | 0 | 135 | irrigation | 1.2000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 25 | 10 | 10 | 5 | 36 | 0 | 0 | 4 | 0 | 0 | 135 | irrigation | 0.8000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 50 | 10 | 10 | 3 | 46 | 1 | 1 | 1 | NA | NA | 135 | irrigation | 1.0000000 |
| Horsham Irrg 2 | Horsham irrigated | 2 | 75 | 10 | 10 | 3 | 56 | 0 | 0 | 0 | NA | NA | 135 | irrigation | 0.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 0 | 1 | 1 | 5 | 1 | 5 | 8 | 4 | 3 | 7 | 45 | mixed | 5.4000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 0 | 1 | 1 | 5 | 2 | 8 | 7 | 4 | 5 | 3 | 45 | mixed | 5.4000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 10 | 1 | 1 | 5 | 9 | 5 | 7 | 5 | 7 | 1 | 45 | mixed | 5.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 10 | 1 | 1 | 5 | 10 | 3 | 2 | 3 | 3 | 0 | 45 | mixed | 2.2000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 1 | 1 | 5 | 17 | 4 | 3 | 0 | 1 | 2 | 45 | mixed | 2.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 1 | 1 | 5 | 18 | 0 | 0 | 0 | 0 | 1 | 45 | mixed | 0.2000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 50 | 1 | 1 | 3 | 37 | 0 | 3 | 1 | NA | NA | 45 | mixed | 1.3333333 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 75 | 1 | 1 | 3 | 47 | 0 | 0 | 0 | NA | NA | 45 | mixed | 0.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 2 | 2 | 5 | 19 | 2 | 4 | 1 | 0 | 2 | 55 | mixed | 1.8000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 2 | 2 | 5 | 20 | 3 | 0 | 0 | 1 | 0 | 55 | mixed | 0.8000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 50 | 2 | 2 | 3 | 38 | 2 | 0 | 0 | NA | NA | 55 | mixed | 0.6666667 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 75 | 2 | 2 | 3 | 48 | 0 | 1 | 0 | NA | NA | 55 | mixed | 0.3333333 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 3 | 3 | 5 | 21 | 2 | 0 | 0 | 0 | 1 | 65 | mixed | 0.6000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 3 | 3 | 5 | 22 | 1 | 2 | 0 | 1 | 1 | 65 | mixed | 1.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 50 | 3 | 3 | 3 | 39 | 0 | 0 | 0 | NA | NA | 65 | mixed | 0.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 75 | 3 | 3 | 3 | 49 | 0 | 0 | 0 | NA | NA | 65 | mixed | 0.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 0 | 2 | 4 | 5 | 3 | 4 | 1 | 8 | 7 | 3 | 75 | mixed | 4.6000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 0 | 2 | 4 | 5 | 4 | 4 | 3 | 11 | 9 | 5 | 75 | mixed | 6.4000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 10 | 2 | 4 | 5 | 11 | 2 | 4 | 5 | 3 | 3 | 75 | mixed | 3.4000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 10 | 2 | 4 | 5 | 12 | 3 | 1 | 1 | 2 | 0 | 75 | mixed | 1.4000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 4 | 4 | 5 | 23 | 1 | 0 | 1 | 0 | 0 | 75 | mixed | 0.4000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 4 | 4 | 5 | 24 | 2 | 2 | 0 | 1 | 2 | 75 | mixed | 1.4000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 50 | 4 | 4 | 3 | 40 | 0 | 2 | 1 | NA | NA | 75 | mixed | 1.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 75 | 4 | 4 | 3 | 50 | 1 | 0 | 0 | NA | NA | 75 | mixed | 0.3333333 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 5 | 5 | 5 | 25 | 0 | 4 | 0 | 0 | 0 | 85 | mixed | 0.8000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 5 | 5 | 5 | 26 | 1 | 0 | 0 | 1 | 0 | 85 | mixed | 0.4000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 50 | 5 | 5 | 3 | 41 | 0 | 2 | 2 | NA | NA | 85 | mixed | 1.3333333 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 75 | 5 | 5 | 3 | 51 | 0 | 0 | 2 | NA | NA | 85 | mixed | 0.6666667 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 6 | 6 | 5 | 27 | 0 | 1 | 3 | 2 | 0 | 95 | mixed | 1.2000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 6 | 6 | 5 | 28 | 3 | 1 | 3 | 2 | 3 | 95 | mixed | 2.4000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 50 | 6 | 6 | 3 | 42 | 1 | 0 | 0 | NA | NA | 95 | mixed | 0.3333333 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 75 | 6 | 6 | 3 | 52 | 1 | 0 | 0 | NA | NA | 95 | mixed | 0.3333333 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 0 | 3 | 7 | 5 | 5 | 11 | 4 | 9 | 4 | 14 | 105 | mixed | 8.4000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 0 | 3 | 7 | 5 | 6 | 3 | 4 | 7 | 5 | 7 | 105 | mixed | 5.2000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 10 | 3 | 7 | 5 | 13 | 4 | 3 | 3 | 4 | 1 | 105 | mixed | 3.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 10 | 3 | 7 | 5 | 14 | 0 | 2 | 2 | 1 | 1 | 105 | mixed | 1.2000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 7 | 7 | 5 | 29 | 2 | 0 | 3 | 3 | 0 | 105 | mixed | 1.6000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 7 | 7 | 5 | 30 | 4 | 2 | 0 | 4 | 0 | 105 | mixed | 2.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 50 | 7 | 7 | 3 | 43 | 1 | 2 | 0 | NA | NA | 105 | mixed | 1.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 75 | 7 | 7 | 3 | 53 | 0 | 0 | 0 | NA | NA | 105 | mixed | 0.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 8 | 8 | 5 | 31 | 0 | 3 | 0 | 2 | 0 | 115 | mixed | 1.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 8 | 8 | 5 | 32 | 0 | 0 | 0 | 0 | 2 | 115 | mixed | 0.4000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 50 | 8 | 8 | 3 | 44 | 1 | 0 | 1 | NA | NA | 115 | mixed | 0.6666667 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 75 | 8 | 8 | 3 | 54 | 0 | 0 | 1 | NA | NA | 115 | mixed | 0.3333333 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 9 | 9 | 5 | 33 | 0 | 1 | 0 | 0 | 0 | 125 | mixed | 0.2000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 9 | 9 | 5 | 34 | 0 | 0 | 2 | 0 | 0 | 125 | mixed | 0.4000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 50 | 9 | 9 | 3 | 45 | 1 | 2 | 0 | NA | NA | 125 | mixed | 1.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 75 | 9 | 9 | 3 | 55 | 0 | 0 | 0 | NA | NA | 125 | mixed | 0.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 0 | 4 | 10 | 5 | 7 | 12 | 4 | 3 | 11 | 5 | 135 | mixed | 7.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 0 | 4 | 10 | 5 | 8 | 4 | 5 | 1 | 1 | 0 | 135 | mixed | 2.2000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 10 | 4 | 10 | 5 | 15 | 2 | 1 | 1 | 1 | 0 | 135 | mixed | 1.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 10 | 4 | 10 | 5 | 16 | 3 | 0 | 1 | 4 | 6 | 135 | mixed | 2.8000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 10 | 10 | 5 | 35 | 0 | 0 | 0 | 0 | 0 | 135 | mixed | 0.0000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 25 | 10 | 10 | 5 | 36 | 0 | 1 | 1 | 0 | 0 | 135 | mixed | 0.4000000 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 50 | 10 | 10 | 3 | 46 | 1 | 0 | 0 | NA | NA | 135 | mixed | 0.3333333 |
| Horsham Mixd 1 | Horsham irrigated | 3 | 75 | 10 | 10 | 3 | 56 | 0 | 0 | 0 | NA | NA | 135 | mixed | 0.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 0 | 1 | 1 | 5 | 1 | 1 | 2 | 2 | 0 | 1 | 45 | rainfall | 1.2000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 0 | 1 | 1 | 5 | 2 | 0 | 3 | 1 | 2 | 0 | 45 | rainfall | 1.2000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 10 | 1 | 1 | 5 | 9 | 0 | 1 | 4 | 1 | 1 | 45 | rainfall | 1.4000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 10 | 1 | 1 | 5 | 10 | 1 | 0 | 4 | 1 | 3 | 45 | rainfall | 1.8000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 1 | 1 | 5 | 17 | 0 | 0 | 2 | 0 | 0 | 45 | rainfall | 0.4000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 1 | 1 | 5 | 18 | 0 | 1 | 2 | 0 | 1 | 45 | rainfall | 0.8000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 50 | 1 | 1 | 3 | 37 | 0 | 0 | 0 | NA | NA | 45 | rainfall | 0.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 75 | 1 | 1 | 3 | 47 | 1 | 0 | 0 | NA | NA | 45 | rainfall | 0.3333333 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 2 | 2 | 5 | 19 | 1 | 2 | 1 | 1 | 1 | 55 | rainfall | 1.2000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 2 | 2 | 5 | 20 | 1 | 0 | 0 | 1 | 0 | 55 | rainfall | 0.4000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 50 | 2 | 2 | 3 | 38 | 1 | 0 | 0 | NA | NA | 55 | rainfall | 0.3333333 |
| Horsham Rain 1 | Horsham dryland | 1 | 75 | 2 | 2 | 3 | 48 | 0 | 1 | 0 | NA | NA | 55 | rainfall | 0.3333333 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 3 | 3 | 5 | 21 | 0 | 1 | 0 | 1 | 0 | 65 | rainfall | 0.4000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 3 | 3 | 5 | 22 | 1 | 0 | 0 | 0 | 2 | 65 | rainfall | 0.6000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 50 | 3 | 3 | 3 | 39 | 0 | 1 | 0 | NA | NA | 65 | rainfall | 0.3333333 |
| Horsham Rain 1 | Horsham dryland | 1 | 75 | 3 | 3 | 3 | 49 | 0 | 0 | 0 | NA | NA | 65 | rainfall | 0.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 0 | 2 | 4 | 5 | 3 | 1 | 2 | 0 | 0 | 0 | 75 | rainfall | 0.6000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 0 | 2 | 4 | 5 | 4 | 0 | 0 | 4 | 4 | 3 | 75 | rainfall | 2.2000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 10 | 2 | 4 | 5 | 11 | 1 | 0 | 2 | 0 | 1 | 75 | rainfall | 0.8000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 10 | 2 | 4 | 5 | 12 | 0 | 2 | 0 | 2 | 0 | 75 | rainfall | 0.8000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 4 | 4 | 5 | 23 | 1 | 0 | 0 | 2 | 0 | 75 | rainfall | 0.6000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 4 | 4 | 5 | 24 | 0 | 1 | 0 | 1 | 1 | 75 | rainfall | 0.6000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 50 | 4 | 4 | 3 | 40 | 0 | 0 | 0 | NA | NA | 75 | rainfall | 0.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 75 | 4 | 4 | 3 | 50 | 0 | 0 | 0 | NA | NA | 75 | rainfall | 0.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 5 | 5 | 5 | 25 | 1 | 0 | 0 | 0 | 0 | 85 | rainfall | 0.2000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 5 | 5 | 5 | 26 | 2 | 1 | 1 | 0 | 0 | 85 | rainfall | 0.8000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 50 | 5 | 5 | 3 | 41 | 0 | 0 | 0 | NA | NA | 85 | rainfall | 0.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 75 | 5 | 5 | 3 | 51 | 0 | 0 | 0 | NA | NA | 85 | rainfall | 0.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 6 | 6 | 5 | 27 | 1 | 0 | 0 | 1 | 0 | 95 | rainfall | 0.4000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 6 | 6 | 5 | 28 | 2 | 0 | 1 | 2 | 0 | 95 | rainfall | 1.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 50 | 6 | 6 | 3 | 42 | 0 | 1 | 0 | NA | NA | 95 | rainfall | 0.3333333 |
| Horsham Rain 1 | Horsham dryland | 1 | 75 | 6 | 6 | 3 | 52 | 0 | 1 | 0 | NA | NA | 95 | rainfall | 0.3333333 |
| Horsham Rain 1 | Horsham dryland | 1 | 0 | 3 | 7 | 5 | 5 | 0 | 1 | 1 | 1 | 1 | 105 | rainfall | 0.8000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 0 | 3 | 7 | 5 | 6 | 0 | 2 | 3 | 1 | NA | 105 | rainfall | 1.5000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 10 | 3 | 7 | 5 | 13 | 0 | 1 | 0 | 0 | 0 | 105 | rainfall | 0.2000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 10 | 3 | 7 | 5 | 14 | 1 | 0 | 2 | 1 | 1 | 105 | rainfall | 1.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 7 | 7 | 5 | 29 | 0 | 4 | 0 | 1 | 0 | 105 | rainfall | 1.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 7 | 7 | 5 | 30 | 0 | 0 | 2 | 1 | 0 | 105 | rainfall | 0.6000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 50 | 7 | 7 | 3 | 43 | 0 | 0 | 0 | NA | NA | 105 | rainfall | 0.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 75 | 7 | 7 | 3 | 53 | 0 | 0 | 0 | NA | NA | 105 | rainfall | 0.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 8 | 8 | 5 | 31 | 1 | 0 | 0 | 0 | 0 | 115 | rainfall | 0.2000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 8 | 8 | 5 | 32 | 0 | 1 | 0 | 0 | 0 | 115 | rainfall | 0.2000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 50 | 8 | 8 | 3 | 44 | 0 | 0 | 0 | NA | NA | 115 | rainfall | 0.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 75 | 8 | 8 | 3 | 54 | 0 | 0 | 0 | NA | NA | 115 | rainfall | 0.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 9 | 9 | 5 | 33 | 1 | 3 | 2 | 0 | 0 | 125 | rainfall | 1.2000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 9 | 9 | 5 | 34 | 0 | 2 | 1 | 1 | 2 | 125 | rainfall | 1.2000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 50 | 9 | 9 | 3 | 45 | 0 | 0 | 0 | NA | NA | 125 | rainfall | 0.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 75 | 9 | 9 | 3 | 55 | 0 | 0 | 0 | NA | NA | 125 | rainfall | 0.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 0 | 4 | 10 | 5 | 7 | 0 | 3 | 0 | 0 | 2 | 135 | rainfall | 1.0000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 0 | 4 | 10 | 5 | 8 | 1 | 0 | 3 | 2 | 2 | 135 | rainfall | 1.6000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 10 | 4 | 10 | 5 | 15 | 1 | 0 | 0 | 2 | 1 | 135 | rainfall | 0.8000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 10 | 4 | 10 | 5 | 16 | 1 | 0 | 2 | 0 | 0 | 135 | rainfall | 0.6000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 10 | 10 | 5 | 35 | 0 | 0 | 0 | 0 | 4 | 135 | rainfall | 0.8000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 25 | 10 | 10 | 5 | 36 | 0 | 0 | 0 | 2 | 0 | 135 | rainfall | 0.4000000 |
| Horsham Rain 1 | Horsham dryland | 1 | 50 | 10 | 10 | 3 | 46 | 1 | 0 | 0 | NA | NA | 135 | rainfall | 0.3333333 |
| Horsham Rain 1 | Horsham dryland | 1 | 75 | 10 | 10 | 3 | 56 | 1 | 0 | 0 | NA | NA | 135 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 0 | 1 | 1 | 5 | 1 | 7 | 5 | 2 | 3 | 4 | 45 | rainfall | 4.2000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 0 | 1 | 1 | 5 | 2 | 1 | 3 | 6 | 1 | 2 | 45 | rainfall | 2.6000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 10 | 1 | 1 | 5 | 9 | 1 | 2 | 4 | 1 | 0 | 45 | rainfall | 1.6000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 10 | 1 | 1 | 5 | 10 | 1 | 1 | 2 | 1 | 0 | 45 | rainfall | 1.0000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 1 | 1 | 5 | 17 | 0 | 1 | 2 | 2 | 1 | 45 | rainfall | 1.2000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 1 | 1 | 5 | 18 | 2 | 1 | 1 | 0 | 1 | 45 | rainfall | 1.0000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 50 | 1 | 1 | 3 | 37 | 2 | 0 | 0 | NA | NA | 45 | rainfall | 0.6666667 |
| Horsham Rain 2 | Horsham dryland | 2 | 75 | 1 | 1 | 3 | 47 | 1 | 0 | 1 | NA | NA | 45 | rainfall | 0.6666667 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 2 | 2 | 5 | 19 | 0 | 0 | 2 | 0 | 2 | 55 | rainfall | 0.8000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 2 | 2 | 5 | 20 | 3 | 2 | 2 | 3 | 1 | 55 | rainfall | 2.2000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 50 | 2 | 2 | 3 | 38 | 0 | 1 | 0 | NA | NA | 55 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 75 | 2 | 2 | 3 | 48 | 0 | 0 | 1 | NA | NA | 55 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 3 | 3 | 5 | 21 | 2 | 2 | 2 | 2 | 1 | 65 | rainfall | 1.8000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 3 | 3 | 5 | 22 | 0 | 0 | 2 | 1 | 0 | 65 | rainfall | 0.6000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 50 | 3 | 3 | 3 | 39 | 1 | 0 | 0 | NA | NA | 65 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 75 | 3 | 3 | 3 | 49 | 0 | 0 | 1 | NA | NA | 65 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 0 | 2 | 4 | 5 | 3 | 0 | 3 | 5 | 6 | 1 | 75 | rainfall | 3.0000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 0 | 2 | 4 | 5 | 4 | 3 | 2 | 3 | 5 | 2 | 75 | rainfall | 3.0000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 10 | 2 | 4 | 5 | 11 | 3 | 2 | 2 | 3 | 2 | 75 | rainfall | 2.4000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 10 | 2 | 4 | 5 | 12 | 3 | 2 | 2 | 1 | 0 | 75 | rainfall | 1.6000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 4 | 4 | 5 | 23 | 0 | 0 | 0 | 1 | 0 | 75 | rainfall | 0.2000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 4 | 4 | 5 | 24 | 2 | 1 | 1 | 0 | 0 | 75 | rainfall | 0.8000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 50 | 4 | 4 | 3 | 40 | 0 | 1 | 0 | NA | NA | 75 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 75 | 4 | 4 | 3 | 50 | 0 | 0 | 1 | NA | NA | 75 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 5 | 5 | 5 | 25 | 0 | 0 | 2 | 1 | 1 | 85 | rainfall | 0.8000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 5 | 5 | 5 | 26 | 0 | 2 | 0 | 0 | 0 | 85 | rainfall | 0.4000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 50 | 5 | 5 | 3 | 41 | 0 | 0 | 0 | NA | NA | 85 | rainfall | 0.0000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 75 | 5 | 5 | 3 | 51 | 0 | 1 | 1 | NA | NA | 85 | rainfall | 0.6666667 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 6 | 6 | 5 | 27 | 1 | 1 | 0 | 0 | 2 | 95 | rainfall | 0.8000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 6 | 6 | 5 | 28 | 0 | 0 | 0 | 0 | 1 | 95 | rainfall | 0.2000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 50 | 6 | 6 | 3 | 42 | 2 | 1 | 0 | NA | NA | 95 | rainfall | 1.0000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 75 | 6 | 6 | 3 | 52 | 1 | 0 | 0 | NA | NA | 95 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 0 | 3 | 7 | 5 | 5 | 5 | 1 | 4 | 1 | 4 | 105 | rainfall | 3.0000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 0 | 3 | 7 | 5 | 6 | 3 | 4 | 2 | 2 | 0 | 105 | rainfall | 2.2000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 10 | 3 | 7 | 5 | 13 | 2 | 2 | 4 | 2 | 0 | 105 | rainfall | 2.0000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 10 | 3 | 7 | 5 | 14 | 0 | 1 | 0 | 1 | 0 | 105 | rainfall | 0.4000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 7 | 7 | 5 | 29 | 2 | 2 | 1 | 1 | 0 | 105 | rainfall | 1.2000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 7 | 7 | 5 | 30 | 1 | 1 | 1 | 0 | 0 | 105 | rainfall | 0.6000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 50 | 7 | 7 | 3 | 43 | 0 | 0 | 0 | NA | NA | 105 | rainfall | 0.0000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 75 | 7 | 7 | 3 | 53 | 0 | 1 | 0 | NA | NA | 105 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 8 | 8 | 5 | 31 | 0 | 0 | 0 | 0 | 0 | 115 | rainfall | 0.0000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 8 | 8 | 5 | 32 | 1 | 0 | 0 | 2 | 1 | 115 | rainfall | 0.8000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 50 | 8 | 8 | 3 | 44 | 1 | 0 | 0 | NA | NA | 115 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 75 | 8 | 8 | 3 | 54 | 0 | 0 | 1 | NA | NA | 115 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 9 | 9 | 5 | 33 | 1 | 0 | 0 | 0 | 0 | 125 | rainfall | 0.2000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 9 | 9 | 5 | 34 | 0 | 1 | 1 | 0 | 0 | 125 | rainfall | 0.4000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 50 | 9 | 9 | 3 | 45 | 1 | 0 | 0 | NA | NA | 125 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 75 | 9 | 9 | 3 | 55 | 0 | 1 | 0 | NA | NA | 125 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 0 | 4 | 10 | 5 | 7 | 3 | 0 | 1 | 4 | 4 | 135 | rainfall | 2.4000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 0 | 4 | 10 | 5 | 8 | 5 | 7 | 5 | 4 | 3 | 135 | rainfall | 4.8000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 10 | 4 | 10 | 5 | 15 | 0 | 0 | 2 | 0 | 1 | 135 | rainfall | 0.6000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 10 | 4 | 10 | 5 | 16 | 0 | 0 | 1 | 1 | 0 | 135 | rainfall | 0.4000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 10 | 10 | 5 | 35 | 0 | 1 | 1 | 1 | 0 | 135 | rainfall | 0.6000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 25 | 10 | 10 | 5 | 36 | 1 | 0 | 2 | 0 | 0 | 135 | rainfall | 0.6000000 |
| Horsham Rain 2 | Horsham dryland | 2 | 50 | 10 | 10 | 3 | 46 | 0 | 0 | 1 | NA | NA | 135 | rainfall | 0.3333333 |
| Horsham Rain 2 | Horsham dryland | 2 | 75 | 10 | 10 | 3 | 56 | 0 | 1 | 0 | NA | NA | 135 | rainfall | 0.3333333 |
Save lesion count data for use in visualisation and modelling. This only needs to be done once.
save(lesion_counts, file = "../data/lesion_counts.rda")