Get datasets from Vancouver Open Data Portal

get_cov_data(
  dataset_id,
  select = "*",
  where = NULL,
  apikey = getOption("VancouverOpenDataApiKey"),
  rows = NULL,
  cast_types = TRUE,
  refresh = FALSE,
  ...
)

Arguments

dataset_id: Dataset id from the Vancouver Open Data catalogue
select: select string for fields to return, returns all fields by default. It accepts ODSQL syntax.
where: Query parameter to filter data (default `NULL` no filter) It accepts ODSQL syntax.
apikey: Vancouver Open Data API key, default `getOption("VancouverOpenDataApiKey")`
rows: Maximum number of rows to return (default `NULL` returns all rows)
cast_types: Logical, use metadata to look up types and type-cast automatically, default `TRUE`
refresh: refresh cached data, default `FALSE``
...: optional ignored parameters, for compatibility with previous versions that relied on the `format` parameter

Value

tibble or sf object data table output, depending on whether the dataset is spatial and `cast_types` is `TRUE`

Examples

# Get all parking tickets issued at the 1100 block of Alberni Street between 2017 and 2019
if (FALSE) {
get_cov_data("parking-tickets-2017-2019",where = "block = 1100 AND street = 'ALBERNI ST'")
}