get_cov_data: Get datasets from Vancouver Open Data Portal

Description Usage Arguments Value Examples

Description

Get datasets from Vancouver Open Data Portal

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
get_cov_data(
  dataset_id,
  format = c("csv", "geojson"),
  select = "*",
  where = NULL,
  apikey = getOption("VancouverOpenDataApiKey"),
  rows = NULL,
  cast_types = TRUE,
  refresh = FALSE
)

Arguments

dataset_id

Dataset id from the Vancouver Open Data catalogue

format

'csv' or 'geojson' are supported at this time (default 'csv')

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ā€œ

Value

tibble or sf object data table output, depending on the value of the 'format' parameter

Examples

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

VancouvR documentation built on July 10, 2021, 1:06 a.m.