{
  "_id": "6a102f12acfb0bcc41c94a18",
  "Package": "watina",
  "Title": "Querying and Processing Data from the INBO Watina Data Warehouse",
  "Version": "0.5.0",
  "Description": "The R-package watina contains functions to query and\nprocess data from the Watina database at the Research Institute\nfor Nature and Forest (INBO). This database primarily provides\ngroundwater level and chemical data, mainly from natural areas\nin Flanders (Belgium).",
  "Authors@R": "c(\nperson(\"Floris\", \"Vanderhaeghe\", role = c(\"aut\", \"cre\"), email = \"floris.vanderhaeghe@inbo.be\", comment = c(ORCID = \"0000-0002-6378-6229\")),\nperson(\"Cécile\", \"Herr\", role = c(\"aut\"), email = \"cecile.herr@inbo.be\", comment = c(ORCID = \"0000-0002-2833-6046\")),\nperson(\"Peter\", \"Desmet\", role = c(\"ctb\"), email = \"peter.desmet@inbo.be\", comment = c(ORCID = \"0000-0002-8442-8025\")),\nperson(\"Jan\", \"Wouters\", email = \"jan.wouters@inbo.be\", role = c(\"ctb\"), comment = c(ORCID = \"0000-0001-8200-9102\")),\nperson(\"Frederic\", \"Piesschaert\", email = \"frederic.piesschaert@inbo.be\", role = c(\"ctb\"), comment = c(ORCID = \"0000-0002-5843-646X\")),\nperson(\"Mathias\", \"Wackenier\", email = \"mathias.wackenier@inbo.be\", role = c(\"ctb\"), comment = c(ORCID = \"0000-0001-6934-9241\")),\nperson(\"Research Institute for Nature and Forest (INBO)\", role = \"cph\", email = \"info@inbo.be\")\n)",
  "License": "GPL-3",
  "URL": "https://inbo.github.io/watina, https://github.com/inbo/watina",
  "BugReports": "https://github.com/inbo/watina/issues",
  "Remotes": [
    "inbo/inbodb"
  ],
  "Encoding": "UTF-8",
  "RoxygenNote": "7.3.3",
  "VignetteBuilder": "knitr",
  "Config/pak/sysreqs": "make libicu-dev unixodbc-dev",
  "Repository": "https://inbo.r-universe.dev",
  "Date/Publication": "2026-04-02 03:50:03 UTC",
  "RemoteUrl": "https://github.com/inbo/watina",
  "RemoteRef": "HEAD",
  "RemoteSha": "c34c7e31e33a3961d92c1671b5c715935b963984",
  "NeedsCompilation": "no",
  "Packaged": {
    "Date": "2026-05-12 17:24:29 UTC",
    "User": "root"
  },
  "Author": "Floris Vanderhaeghe [aut, cre] (ORCID:\n<https://orcid.org/0000-0002-6378-6229>),\nCécile Herr [aut] (ORCID: <https://orcid.org/0000-0002-2833-6046>),\nPeter Desmet [ctb] (ORCID: <https://orcid.org/0000-0002-8442-8025>),\nJan Wouters [ctb] (ORCID: <https://orcid.org/0000-0001-8200-9102>),\nFrederic Piesschaert [ctb] (ORCID:\n<https://orcid.org/0000-0002-5843-646X>),\nMathias Wackenier [ctb] (ORCID:\n<https://orcid.org/0000-0001-6934-9241>),\nResearch Institute for Nature and Forest (INBO) [cph]",
  "Maintainer": "Floris Vanderhaeghe <floris.vanderhaeghe@inbo.be>",
  "MD5sum": "f725d2f116522e24508fe0ccc63baac0",
  "_user": "inbo",
  "_type": "src",
  "_file": "watina_0.5.0.tar.gz",
  "_fileid": "5f766cc2f6fed8b8bc23a4b74e33b110bf82a674f082627deff63af066d8a95a",
  "_filesize": 490343,
  "_sha256": "5f766cc2f6fed8b8bc23a4b74e33b110bf82a674f082627deff63af066d8a95a",
  "_created": "2026-05-12T17:24:29.000Z",
  "_published": "2026-05-22T10:25:22.166Z",
  "_distro": "noble",
  "_jobs": [
    {
      "job": 77361262031,
      "time": 167,
      "config": "linux-devel-x86_64",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6951204742"
    },
    {
      "job": 77361262081,
      "time": 176,
      "config": "linux-release-x86_64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6951208325"
    },
    {
      "job": 77361262042,
      "time": 112,
      "config": "macos-oldrel-arm64",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6951182377"
    },
    {
      "job": 77361261939,
      "time": 113,
      "config": "macos-release-arm64",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6951183166"
    },
    {
      "job": 77361261336,
      "time": 182,
      "config": "source",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6951140369"
    },
    {
      "job": 77361261284,
      "time": 123,
      "config": "wasm-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "7158291716"
    },
    {
      "job": 77361261813,
      "time": 106,
      "config": "windows-devel",
      "r": "4.7.0",
      "check": "OK",
      "artifact": "6951180642"
    },
    {
      "job": 77361261998,
      "time": 125,
      "config": "windows-oldrel",
      "r": "4.5.3",
      "check": "OK",
      "artifact": "6951187100"
    },
    {
      "job": 77361261684,
      "time": 111,
      "config": "windows-release",
      "r": "4.6.0",
      "check": "OK",
      "artifact": "6951181947"
    }
  ],
  "_buildurl": "https://github.com/r-universe/inbo/actions/runs/25750644149",
  "_status": "success",
  "_host": "GitHub-Actions",
  "_upstream": "https://github.com/inbo/watina",
  "_commit": {
    "id": "c34c7e31e33a3961d92c1671b5c715935b963984",
    "author": "Floris Vanderhaeghe <floris.vanderhaeghe@inbo.be>",
    "committer": "GitHub <noreply@github.com>",
    "message": "Merge pull request #124 from inbo/dev_nextrelease\n\nVersion 0.5.0",
    "time": 1775101803
  },
  "_maintainer": {
    "name": "Floris Vanderhaeghe",
    "email": "floris.vanderhaeghe@inbo.be",
    "login": "florisvdh",
    "mastodon": "@florisvdh@fosstodon.org",
    "orcid": "0000-0002-6378-6229",
    "uuid": 19164640
  },
  "_registered": true,
  "_dependencies": [
    {
      "package": "R",
      "version": ">= 3.5.0",
      "role": "Depends"
    },
    {
      "package": "assertthat",
      "role": "Imports"
    },
    {
      "package": "dplyr",
      "role": "Imports"
    },
    {
      "package": "inbodb",
      "role": "Imports"
    },
    {
      "package": "lubridate",
      "role": "Imports"
    },
    {
      "package": "rlang",
      "role": "Imports"
    },
    {
      "package": "stringr",
      "role": "Imports"
    },
    {
      "package": "stats",
      "role": "Imports"
    },
    {
      "package": "tidyr",
      "role": "Imports"
    },
    {
      "package": "DBI",
      "role": "Suggests"
    },
    {
      "package": "ggplot2",
      "role": "Suggests"
    },
    {
      "package": "knitr",
      "role": "Suggests"
    },
    {
      "package": "KSgeneral",
      "role": "Suggests"
    },
    {
      "package": "purrr",
      "role": "Suggests"
    },
    {
      "package": "rmarkdown",
      "role": "Suggests"
    },
    {
      "package": "scales",
      "role": "Suggests"
    },
    {
      "package": "sf",
      "role": "Suggests"
    },
    {
      "package": "tibble",
      "role": "Suggests"
    },
    {
      "package": "tidyselect",
      "role": "Suggests"
    }
  ],
  "_owner": "inbo",
  "_selfowned": true,
  "_usedby": 0,
  "_updates": [
    {
      "week": "2026-14",
      "n": 1
    }
  ],
  "_tags": [
    {
      "name": "v0.5.0",
      "date": "2026-04-02"
    }
  ],
  "_topics": [
    "groundwater",
    "preprocessing-functions",
    "reproducibility"
  ],
  "_stars": 2,
  "_contributors": [
    {
      "user": "florisvdh",
      "count": 457,
      "uuid": 19164640
    },
    {
      "user": "cecileherr",
      "count": 19,
      "uuid": 31855012
    },
    {
      "user": "peterdesmet",
      "count": 13,
      "uuid": 600993
    },
    {
      "user": "w-jan",
      "count": 6,
      "uuid": 17884751
    },
    {
      "user": "falkmielke",
      "count": 2,
      "uuid": 67623545
    }
  ],
  "_userbio": {
    "uuid": 2735610,
    "type": "organization",
    "name": "Research Institute for Nature and Forest (INBO)",
    "description": "Open source, data and science initiatives of the Research Institute for Nature and Forest (INBO)"
  },
  "_downloads": {
    "count": 0,
    "source": "https://cranlogs.r-pkg.org/downloads/total/last-month/watina"
  },
  "_devurl": "https://github.com/inbo/watina",
  "_pkgdown": "https://inbo.github.io/watina",
  "_searchresults": 19,
  "_rbuild": "4.6.0",
  "_assets": [
    "extra/citation.cff",
    "extra/citation.html",
    "extra/citation.json",
    "extra/citation.txt",
    "extra/contents.json",
    "extra/NEWS.html",
    "extra/NEWS.txt",
    "extra/readme.html",
    "extra/readme.md",
    "extra/watina.html",
    "manual.pdf"
  ],
  "_cranurl": false,
  "_exports": [
    "as_points",
    "calculate_ir",
    "cluster_locs",
    "connect_watina",
    "dbDisconnect",
    "eval_chem",
    "eval_xg3_avail",
    "eval_xg3_series",
    "extract_xg3_series",
    "get_chem",
    "get_locs",
    "get_xg3",
    "ggplot_vanwirdum_background",
    "selectlocs_chem",
    "selectlocs_xg3"
  ],
  "_help": [
    {
      "page": "as_points",
      "title": "Convert a data frame with X and Y coordinates to a geospatial points object",
      "topics": [
        "as_points"
      ]
    },
    {
      "page": "calculate_ir",
      "title": "Compute the ionic ratio",
      "topics": [
        "calculate_ir"
      ]
    },
    {
      "page": "cluster_locs",
      "title": "Detect (spatial) groundwater well clusters",
      "topics": [
        "cluster_locs"
      ]
    },
    {
      "page": "connect_watina",
      "title": "Connect to the INBO Watina data warehouse",
      "topics": [
        "connect_watina"
      ]
    },
    {
      "page": "dbDisconnect",
      "title": "Disconnect a database connection",
      "topics": [
        "dbDisconnect"
      ]
    },
    {
      "page": "eval_chem",
      "title": "Evaluate hydrochemical data per location",
      "concept": [
        "functions to evaluate locations"
      ],
      "topics": [
        "eval_chem"
      ]
    },
    {
      "page": "eval_xg3_avail",
      "title": "Evaluate the availability of XG3 values per location",
      "concept": [
        "functions to evaluate locations"
      ],
      "topics": [
        "eval_xg3_avail"
      ]
    },
    {
      "page": "eval_xg3_series",
      "title": "Identify and evaluate XG3 series per location",
      "concept": [
        "functions to evaluate locations"
      ],
      "topics": [
        "eval_xg3_series"
      ]
    },
    {
      "page": "extract_xg3_series",
      "title": "Identify XG3 series per location",
      "topics": [
        "extract_xg3_series"
      ]
    },
    {
      "page": "get_chem",
      "title": "Get hydrochemical data from the data warehouse",
      "concept": [
        "functions to query the data warehouse"
      ],
      "topics": [
        "get_chem"
      ]
    },
    {
      "page": "get_locs",
      "title": "Get locations from the data warehouse",
      "concept": [
        "functions to query the data warehouse"
      ],
      "topics": [
        "get_locs"
      ]
    },
    {
      "page": "get_xg3",
      "title": "Get XG3 values from the data warehouse",
      "concept": [
        "functions to query the data warehouse"
      ],
      "topics": [
        "get_xg3"
      ]
    },
    {
      "page": "ggplot_vanwirdum_background",
      "title": "Plots hydrochemistry: Van Wirdum diagram",
      "topics": [
        "ggplot_vanwirdum_background"
      ]
    },
    {
      "page": "selectlocs_chem",
      "title": "Select locations based on hydrochemical data properties",
      "concept": [
        "functions to select locations"
      ],
      "topics": [
        "selectlocs_chem"
      ]
    },
    {
      "page": "selectlocs_xg3",
      "title": "Select locations based on XG3 availability and XG3 series' properties",
      "concept": [
        "functions to select locations"
      ],
      "topics": [
        "selectlocs_xg3"
      ]
    }
  ],
  "_readme": "https://github.com/inbo/watina/raw/HEAD/README.md",
  "_rundeps": [
    "assertthat",
    "bit",
    "bit64",
    "blob",
    "cli",
    "cpp11",
    "DBI",
    "dplyr",
    "generics",
    "glue",
    "hms",
    "inbodb",
    "lifecycle",
    "lubridate",
    "magrittr",
    "odbc",
    "pillar",
    "pkgconfig",
    "purrr",
    "R6",
    "Rcpp",
    "rlang",
    "stringi",
    "stringr",
    "tibble",
    "tidyr",
    "tidyselect",
    "timechange",
    "utf8",
    "vctrs",
    "withr"
  ],
  "_vignettes": [
    {
      "source": "v230_chem_plots.Rmd",
      "filename": "v230_chem_plots.html",
      "title": "Creating plots based on hydrochemical data",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Retrieve chemical data from Watina",
        "Plot the ionic ratio against the electrical conductivity (Van Wirdum)"
      ],
      "created": "2026-04-02 03:50:03",
      "modified": "2026-04-02 03:50:03",
      "commits": 1
    },
    {
      "source": "v010_getstarted.Rmd",
      "filename": "v010_getstarted.html",
      "title": "Getting started: connecting and selecting locations",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Connecting",
        "Selecting locations",
        "Disconnecting"
      ],
      "created": "2019-10-02 12:50:44",
      "modified": "2026-04-02 03:50:03",
      "commits": 3
    },
    {
      "source": "v210_chem.Rmd",
      "filename": "v210_chem.html",
      "title": "Using hydrochemical data to characterize and select locations",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Overview",
        "The basics: obtaining hydrochemical data",
        "Processing hydrochemical data and selecting locations"
      ],
      "created": "2019-10-02 12:50:44",
      "modified": "2026-04-02 03:50:03",
      "commits": 5
    },
    {
      "source": "v110_xg3.Rmd",
      "filename": "v110_xg3.html",
      "title": "Using XG3 values to characterize and select locations",
      "engine": "knitr::rmarkdown",
      "headings": [
        "Overview",
        "The basics: obtaining XG3 values",
        "Processing XG3 values and selecting locations"
      ],
      "created": "2019-10-02 12:50:44",
      "modified": "2026-04-02 03:50:03",
      "commits": 4
    }
  ],
  "_score": 4.482873583608754,
  "_indexed": true,
  "_nocasepkg": "watina",
  "_universes": [
    "inbo",
    "florisvdh"
  ],
  "_binaries": [
    {
      "r": "4.7.0",
      "os": "linux",
      "version": "0.5.0",
      "date": "2026-05-12T17:27:17.000Z",
      "distro": "noble",
      "commit": "c34c7e31e33a3961d92c1671b5c715935b963984",
      "fileid": "16ee90e47c4e848874dda6810172622e5da4c9cc22aed48f4367f7f8266cb6f0",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750644149"
    },
    {
      "r": "4.6.0",
      "os": "linux",
      "version": "0.5.0",
      "date": "2026-05-12T17:27:23.000Z",
      "distro": "noble",
      "commit": "c34c7e31e33a3961d92c1671b5c715935b963984",
      "fileid": "c3826d17ef6d3bf1b157c61d0bdb935b1f0c05e542b10206101091fa17273c8b",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750644149"
    },
    {
      "r": "4.5.3",
      "os": "mac",
      "version": "0.5.0",
      "date": "2026-05-12T17:26:19.000Z",
      "commit": "c34c7e31e33a3961d92c1671b5c715935b963984",
      "fileid": "3af773988a60a46061752a675ba07227d049771ef2b310c21fa0ccf280727499",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750644149"
    },
    {
      "r": "4.6.0",
      "os": "mac",
      "version": "0.5.0",
      "date": "2026-05-12T17:26:23.000Z",
      "commit": "c34c7e31e33a3961d92c1671b5c715935b963984",
      "fileid": "a3535182ad313dc1e6481842ff8cbdf24ece9d1da3f255e2e9536006eb49563c",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750644149"
    },
    {
      "r": "4.7.0",
      "os": "win",
      "version": "0.5.0",
      "date": "2026-05-12T17:26:04.000Z",
      "commit": "c34c7e31e33a3961d92c1671b5c715935b963984",
      "fileid": "b4370d4c2f0f4e8638ca57e4fb419d3a7ace803baaad7a08fe408709188a5050",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750644149"
    },
    {
      "r": "4.5.3",
      "os": "win",
      "version": "0.5.0",
      "date": "2026-05-12T17:26:20.000Z",
      "commit": "c34c7e31e33a3961d92c1671b5c715935b963984",
      "fileid": "09a95568be91e6d5e19ac2d544635c27f9e63b33d4f1ba13d0e08994e5c808de",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750644149"
    },
    {
      "r": "4.6.0",
      "os": "win",
      "version": "0.5.0",
      "date": "2026-05-12T17:26:07.000Z",
      "commit": "c34c7e31e33a3961d92c1671b5c715935b963984",
      "fileid": "466ee56245c75c8f7cf24c9750bc7388d5bf8529d90d792cf1bf799b257a4a67",
      "status": "success",
      "check": "OK",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750644149"
    },
    {
      "r": "4.6.0",
      "os": "wasm",
      "version": "0.5.0",
      "date": "2026-05-22T10:25:04.000Z",
      "commit": "c34c7e31e33a3961d92c1671b5c715935b963984",
      "fileid": "bd5dfc3061dc822d2654cedff5a5a9eddd0e5f6fb5de0ab3400c065098c1937a",
      "status": "success",
      "buildurl": "https://github.com/r-universe/inbo/actions/runs/25750644149"
    }
  ]
}