Fetch a TPS open-data layer by short name — morie_ingest_tps

Convenience wrapper around morie_ingest_tps_feature_layer that takes a registry short-name (e.g. "major-crime", "shooting-firearms") instead of a raw FeatureServer URL.

Usage

morie_ingest_tps_fetch(
  layer,
  year = NULL,
  where = NULL,
  return_geometry = FALSE,
  max_features = NULL,
  ...
)

Arguments

layer: Short name from morie_ingest_tps_layers.
year: Optional shortcut for OCC_YEAR = <year> when where is NULL.
where: Raw ArcGIS WHERE clause (overrides year).
return_geometry: Include longitude/latitude columns.
max_features: Optional hard cap on rows.
...: Forwarded to morie_ingest_tps_feature_layer.

Value

A base R data.frame.

Examples

try(morie_ingest_tps_fetch("major-crime", max_features = 1L))
#>   OBJECTID EVENT_UNIQUE_ID  REPORT_DATE     OCC_DATE REPORT_YEAR REPORT_MONTH
#> 1        1  GO-20141259762 1.388552e+12 1.388466e+12        2014      January
#>   REPORT_DAY REPORT_DOY REPORT_DOW REPORT_HOUR OCC_YEAR OCC_MONTH OCC_DAY
#> 1          1          1 Wednesday            2     2013  December      31
#>   OCC_DOY    OCC_DOW OCC_HOUR DIVISION    LOCATION_TYPE PREMISES_TYPE UCR_CODE
#> 1     365 Tuesday          23      D52 Bar / Restaurant    Commercial     1430
#>   UCR_EXT OFFENCE CSI_CATEGORY HOOD_158      NEIGHBOURHOOD_158 HOOD_140
#> 1     100 Assault      Assault      164 Wellington Place (164)      077
#>                        NEIGHBOURHOOD_140 LONG_WGS84 LAT_WGS84
#> 1 Waterfront Communities-The Island (77)  -79.39079  43.64913