Skip to contents

Toronto PS ArcGIS Hub dataset wrapper. Thin dispatch to morie_datasets_tps_arcgis_hub_by_id() with the canonical hub item_id 6ac1f56513ab481091ce16f435c390b7.

Usage

morie_datasets_tps_budget_2023(
  format = "json",
  where = "1=1",
  max_features = NULL,
  layer_idx = 0L,
  offline = TRUE,
  dest = NULL
)

Arguments

format

One of "json" (default), "geojson", "csv", "shapefile", "fgdb".

where

SoQL-style WHERE filter passed to FeatureServer ?where= (default "1=1").

max_features

Optional cap on returned rows. Passed as resultRecordCount to FeatureServer; ignored for binary formats.

layer_idx

Integer index of the FeatureServer layer to pull (default 0L, the first layer).

offline

Logical; if TRUE, the hub_id is resolved via the included catalog (no network needed for the resolution step). Default TRUE – you can run this against the 71 catalog entries without network. Live data fetches always hit the network regardless of this argument; "offline" here only affects the hub_id -> FeatureServer URL lookup.

dest

Optional path for binary downloads (format %in% c("shapefile", "fgdb")); defaults to tempfile().

Value

A data.frame / GeoJSON list / file path; see morie_datasets_tps_arcgis_hub_by_id() for per-format semantics.

Details

Toronto Police Service dataset.

Tags: Budget; Toronto Police Service; TPS

Examples

# \donttest{
df <- try(morie_datasets_tps_budget_2023(max_features = 5L))
if (!inherits(df, "try-error")) head(df)
#>   Fiscal_Year         Budget_Type        Organization_Entity
#> 1        2023 Actual Expenditures 1 - Toronto Police Service
#> 2        2023 Actual Expenditures 1 - Toronto Police Service
#> 3        2023 Actual Expenditures 1 - Toronto Police Service
#> 4        2023 Actual Expenditures 1 - Toronto Police Service
#> 5        2023 Actual Expenditures 1 - Toronto Police Service
#>                            Command_Name
#> 1 Centralized Service Charges (Command)
#> 2 Centralized Service Charges (Command)
#> 3 Centralized Service Charges (Command)
#> 4 Centralized Service Charges (Command)
#> 5 Centralized Service Charges (Command)
#>                                Pillar_Name               District_Name
#> 1 Centralized Service Chrgs & UNS (Pillar) Centralized Service Charges
#> 2 Centralized Service Chrgs & UNS (Pillar) Centralized Service Charges
#> 3 Centralized Service Chrgs & UNS (Pillar) Centralized Service Charges
#> 4 Centralized Service Chrgs & UNS (Pillar) Centralized Service Charges
#> 5 Centralized Service Chrgs & UNS (Pillar) Centralized Service Charges
#>                     Unit_Name Feature_Category Cost_Element
#> 1 Centralized Service Charges             1501   1-Salaries
#> 2 Centralized Service Charges             1502   1-Salaries
#> 3 Centralized Service Charges             1503   1-Salaries
#> 4 Centralized Service Charges             1504   1-Salaries
#> 5 Centralized Service Charges             1505   1-Salaries
#>                     Cost_Element_Long_Name    Amount ObjectId
#> 1         Regular salaries - Chief/Command         0        1
#> 2  Regular salaries - Civilian Sr. Officer   5249.52        2
#> 3   Regular salaries - Uniform Sr. Officer   3485.88        3
#> 4               Regular salaries - Uniform 218428.18        4
#> 5            Regular salaries - Civilian A  33866.96        5
# }