Skip to contents

Get data for deployments of acoustic receivers, with options to filter results.

Usage

get_acoustic_deployments(
  connection = con,
  deployment_id = NULL,
  receiver_id = NULL,
  acoustic_project_code = NULL,
  station_name = NULL,
  open_only = FALSE
)

Arguments

connection

A connection to the ETN database. Defaults to con.

deployment_id

Integer (vector). One or more deployment identifiers.

receiver_id

Character (vector). One or more receiver identifiers.

acoustic_project_code

Character (vector). One or more acoustic project codes. Case-insensitive.

station_name

Character (vector). One or more deployment station names.

open_only

Logical. Restrict deployments to those that are currently open (i.e. no end date defined). Defaults to FALSE.

Value

A tibble with acoustic deployment data, sorted by acoustic_project_code, station_name and deploy_date_time. See also field definitions.

Examples

# Set default connection variable
con <- connect_to_etn()

# Get all acoustic deployments
get_acoustic_deployments(con)
#> # A tibble: 11,528 × 38
#>    deploym…¹ recei…² acous…³ stati…⁴ stati…⁵ stati…⁶ deploy_date_time    deplo…⁷
#>        <int> <chr>   <chr>   <chr>   <chr>   <chr>   <dttm>                <dbl>
#>  1      6660 VR20-2… 2004_G… GUD1    GUD1    NA      2004-03-03 00:00:00    56.4
#>  2      6670 VR2-35… 2004_G… GUD1    GUD1    NA      2005-02-25 00:00:00    56.4
#>  3      6661 VR2-19… 2004_G… GUD2    GUD2    NA      2004-03-03 00:00:00    56.4
#>  4      6671 VR2-19… 2004_G… GUD2    GUD2    NA      2005-02-25 00:00:00    56.4
#>  5      6680 VR2-25… 2004_G… KATNORD KATNORD NA      2005-02-25 00:00:00    56.6
#>  6      6679 VR2-27… 2004_G… KATSYD  KATSYD  NA      2005-02-25 00:00:00    56.6
#>  7      6662 VR2-35… 2004_G… RAN1    RAN1    NA      2004-03-03 00:00:00    56.5
#>  8      6672 VR2-35… 2004_G… RAN1    RAN1    NA      2005-02-25 00:00:00    56.5
#>  9      6663 VR2-19… 2004_G… RAN2    RAN2    NA      2004-03-03 00:00:00    56.5
#> 10      6673 VR2-19… 2004_G… RAN2    RAN2    NA      2005-02-25 00:00:00    56.5
#> # … with 11,518 more rows, 30 more variables: deploy_longitude <dbl>,
#> #   intended_latitude <dbl>, intended_longitude <dbl>, mooring_type <chr>,
#> #   bottom_depth <chr>, riser_length <chr>, deploy_depth <chr>,
#> #   battery_installation_date <dttm>, battery_estimated_end_date <dttm>,
#> #   activation_date_time <dttm>, recover_date_time <dttm>,
#> #   recover_latitude <dbl>, recover_longitude <dbl>, download_date_time <dttm>,
#> #   download_file_name <chr>, valid_data_until_date_time <dttm>, …

# Get specific acoustic deployment
get_acoustic_deployments(con, deployment_id = 1437)
#> # A tibble: 1 × 38
#>   deployme…¹ recei…² acous…³ stati…⁴ stati…⁵ stati…⁶ deploy_date_time    deplo…⁷
#>        <int> <chr>   <chr>   <chr>   <chr>   <chr>   <dttm>                <dbl>
#> 1       1437 VR2W-1… demer   de-9    SA_GB_… 1       2014-04-10 00:00:00    51.0
#> # … with 30 more variables: deploy_longitude <dbl>, intended_latitude <dbl>,
#> #   intended_longitude <dbl>, mooring_type <chr>, bottom_depth <chr>,
#> #   riser_length <chr>, deploy_depth <chr>, battery_installation_date <dttm>,
#> #   battery_estimated_end_date <dttm>, activation_date_time <dttm>,
#> #   recover_date_time <dttm>, recover_latitude <dbl>, recover_longitude <dbl>,
#> #   download_date_time <dttm>, download_file_name <chr>,
#> #   valid_data_until_date_time <dttm>, sync_date_time <dttm>, …

# Get acoustic deployments for a specific receiver
get_acoustic_deployments(con, receiver_id = "VR2W-124070")
#> # A tibble: 8 × 38
#>   deployme…¹ recei…² acous…³ stati…⁴ stati…⁵ stati…⁶ deploy_date_time    deplo…⁷
#>        <int> <chr>   <chr>   <chr>   <chr>   <chr>   <dttm>                <dbl>
#> 1       1437 VR2W-1… demer   de-9    "SA_GB… "1"     2014-04-10 00:00:00    51.0
#> 2       1588 VR2W-1… demer   de-9    "de-9"   NA     2014-12-19 01:30:00    51.0
#> 3       1803 VR2W-1… dijle   M-2     "M-2"    NA     2015-04-16 00:00:00    51.0
#> 4       1804 VR2W-1… dijle   M-2     ""      ""      2015-05-15 00:00:00    51.0
#> 5       1805 VR2W-1… dijle   M-2     ""      ""      2015-05-28 00:00:00    51.0
#> 6       1806 VR2W-1… dijle   M-2     ""      ""      2015-09-24 00:00:00    51.0
#> 7       1807 VR2W-1… dijle   M-2     "m-2"    NA     2015-11-09 00:00:00    51.0
#> 8       2511 VR2W-1… dijle   M-2     "m-2"    NA     2017-01-26 00:00:00    51.0
#> # … with 30 more variables: deploy_longitude <dbl>, intended_latitude <dbl>,
#> #   intended_longitude <dbl>, mooring_type <chr>, bottom_depth <chr>,
#> #   riser_length <chr>, deploy_depth <chr>, battery_installation_date <dttm>,
#> #   battery_estimated_end_date <dttm>, activation_date_time <dttm>,
#> #   recover_date_time <dttm>, recover_latitude <dbl>, recover_longitude <dbl>,
#> #   download_date_time <dttm>, download_file_name <chr>,
#> #   valid_data_until_date_time <dttm>, sync_date_time <dttm>, …

# Get open acoustic deployments for a specific receiver
get_acoustic_deployments(con, receiver_id = "VR2W-124070", open_only = TRUE)
#> # A tibble: 0 × 38
#> # … with 38 variables: deployment_id <int>, receiver_id <chr>,
#> #   acoustic_project_code <chr>, station_name <chr>, station_description <chr>,
#> #   station_manager <chr>, deploy_date_time <dttm>, deploy_latitude <dbl>,
#> #   deploy_longitude <dbl>, intended_latitude <dbl>, intended_longitude <dbl>,
#> #   mooring_type <chr>, bottom_depth <chr>, riser_length <chr>,
#> #   deploy_depth <chr>, battery_installation_date <dttm>,
#> #   battery_estimated_end_date <dttm>, activation_date_time <dttm>, …

# Get acoustic deployments for a specific acoustic project
get_acoustic_deployments(con, acoustic_project_code = "demer")
#> # A tibble: 46 × 38
#>    deploym…¹ recei…² acous…³ stati…⁴ stati…⁵ stati…⁶ deploy_date_time    deplo…⁷
#>        <int> <chr>   <chr>   <chr>   <chr>   <chr>   <dttm>                <dbl>
#>  1      1424 VR2W-1… demer   de-1    fietse… 1       2014-05-13 00:00:00    51.0
#>  2      1658 VR2W-1… demer   de-2    Rommel… 1       2014-05-14 00:00:00    51.0
#>  3      1478 VR2W-1… demer   de-2    rommel… 1       2014-08-07 00:00:00    51.0
#>  4      1661 VR2W-1… demer   de-3    Messel… 1       2014-05-13 00:00:00    51.0
#>  5      1381 VR2W-1… demer   de-3    Messel… NA      2014-08-07 00:00:00    51.0
#>  6      2869 VR2W-1… demer   de-3    Messel… NA      2014-09-21 00:00:00    51.0
#>  7      1662 VR2W-1… demer   de-4    Testelt 1       2014-05-13 00:00:00    51.0
#>  8      1425 VR2W-1… demer   de-5    SO_ZIC… 1       2014-05-05 00:00:00    51.0
#>  9      1663 VR2W-1… demer   de-6    SA_RIF… 1       2014-05-05 00:00:00    51.0
#> 10      1378 VR2W-1… demer   de-7    de-7    NA      2014-05-05 00:00:00    51.0
#> # … with 36 more rows, 30 more variables: deploy_longitude <dbl>,
#> #   intended_latitude <dbl>, intended_longitude <dbl>, mooring_type <chr>,
#> #   bottom_depth <chr>, riser_length <chr>, deploy_depth <chr>,
#> #   battery_installation_date <dttm>, battery_estimated_end_date <dttm>,
#> #   activation_date_time <dttm>, recover_date_time <dttm>,
#> #   recover_latitude <dbl>, recover_longitude <dbl>, download_date_time <dttm>,
#> #   download_file_name <chr>, valid_data_until_date_time <dttm>, …

# Get acoustic deployments for two specific stations
get_acoustic_deployments(con, station_name = c("de-9", "de-10"))
#> # A tibble: 3 × 38
#>   deployme…¹ recei…² acous…³ stati…⁴ stati…⁵ stati…⁶ deploy_date_time    deplo…⁷
#>        <int> <chr>   <chr>   <chr>   <chr>   <chr>   <dttm>                <dbl>
#> 1       1437 VR2W-1… demer   de-9    SA_GB_… 1       2014-04-10 00:00:00    51.0
#> 2       1588 VR2W-1… demer   de-9    de-9    NA      2014-12-19 01:30:00    51.0
#> 3       1428 VR2W-1… demer   de-10   IN_MZ_… 2       2014-04-10 00:00:00    51.0
#> # … with 30 more variables: deploy_longitude <dbl>, intended_latitude <dbl>,
#> #   intended_longitude <dbl>, mooring_type <chr>, bottom_depth <chr>,
#> #   riser_length <chr>, deploy_depth <chr>, battery_installation_date <dttm>,
#> #   battery_estimated_end_date <dttm>, activation_date_time <dttm>,
#> #   recover_date_time <dttm>, recover_latitude <dbl>, recover_longitude <dbl>,
#> #   download_date_time <dttm>, download_file_name <chr>,
#> #   valid_data_until_date_time <dttm>, sync_date_time <dttm>, …