Line point data processing

Green Book - Box I.C.1.a.ii
ICWD Annual Report
2024
vegetation condition
Line point data is transposed from paper data sheets to google sheets, one for each USGS quadrangle, and individual parcels within the quad are located in separate worksheets within the quad google sheet. This code extracts, transforms and loads these data at annual intervals into the database that is the backend for parameterized reports, dashboards and decision support tools downstream of this data.
Modified

August 12, 2024

# A tibble: 6 × 19
  Parcel Code   Transect Cover  Year Entity plotid      Species CommonName Order
  <chr>  <chr>     <dbl> <dbl> <dbl> <chr>  <chr>       <chr>   <chr>      <chr>
1 ABD012 ARTRT         1    13  2024 ICWD   ABD012_1_jm Artemi… sagebrush… Aste…
2 ABD012 PSPO          1     3  2024 ICWD   ABD012_1_jm Psorot… dalea, Do… Faba…
3 ABD012 ERNA10        1     2  2024 ICWD   ABD012_1_jm Ericam… rabbitbru… Aste…
4 ABD012 ATCA2         1     0  2024 ICWD   ABD012_1_jm Atripl… saltbush,… Cary…
5 ABD012 ATPO          1     0  2024 ICWD   ABD012_1_jm Atripl… saltbush,… Cary…
6 ABD012 ERBR7         1     0  2024 ICWD   ABD012_1_jm Eriogo… buckwheat… Poly…
# ℹ 9 more variables: Family <chr>, Genus <chr>, Lifecycle <chr>,
#   Lifeform <chr>, Veg_Type <chr>, source <chr>, source.abr <chr>,
#   Phreatophyte <chr>, plotid.full <chr>
[1] "A"      "copyA"  "Sheet1"

Citation

BibTeX citation:
@report{2024,
  author = {},
  publisher = {Inyo County Water Department},
  title = {Line Point Data Processing},
  date = {2024-08-12},
  url = {https://inyo-gov.github.io/vegetation-condition/},
  langid = {en}
}
For attribution, please cite this work as:
“Line Point Data Processing.” 2024. Annual Report. Inyo County Water Department. https://inyo-gov.github.io/vegetation-condition/.