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 317e768682d14fad94de83eaefbf5954.

Usage

morie_datasets_tps_fatals_ksi(
  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

Fatal-related KSI collisions (2006 - 2023).

Tags: Killed or Seriously Injured; KSI; Fatal; Traffic; Collision; Traffic Collision

Examples

# \donttest{
df <- try(morie_datasets_tps_fatals_ksi(max_features = 5L))
if (!inherits(df, "try-error")) head(df)
#>   OBJECTID  INDEX_ ACCNUM         DATE TIME       STREET1       STREET2 OFFSET
#> 1        1 3363207 882024 1.136610e+12 2325 STEELES AVE E NINTH LINE ST     NA
#> 2        2 3363869 882497 1.136696e+12 1828 ISLINGTON AVE   GOLFDOWN DR     NA
#> 3        3 3363416 882174 1.136783e+12 1435    KENNEDY RD GLAMORGAN AVE     NA
#> 4        4 3363879 882501 1.136956e+12 1120    BARTLEY DR    JINNAH CRT     NA
#> 5        5 3371161 886230 1.137820e+12 1829   MIDLAND AVE   GOODLAND GT     NA
#>       ROAD_CLASS       DISTRICT LATITUDE LONGITUDE          ACCLOC
#> 1 Minor Arterial    Scarborough 43.84275 -79.22479            <NA>
#> 2 Major Arterial Etobicoke York 43.72145 -79.55809 At Intersection
#> 3 Major Arterial    Scarborough 43.76944 -79.28229 At Intersection
#> 4      Collector     North York 43.72205 -79.30799            <NA>
#> 5 Major Arterial    Scarborough 43.77934 -79.27559 At Intersection
#>               TRAFFCTL VISIBILITY    LIGHT RDSFCOND ACCLASS
#> 1           No Control      Clear     Dark      Wet   Fatal
#> 2 Pedestrian Crossover      Clear     Dark      Dry   Fatal
#> 3       Traffic Signal      Clear Daylight      Dry   Fatal
#> 4           No Control      Clear Daylight      Wet   Fatal
#> 5           No Control      Clear     Dusk      Dry   Fatal
#>               IMPACTYPE    INVTYPE   INVAGE INJURY FATAL_NO INITDIR
#> 1           Approaching     Driver 50 to 54  Fatal       NA    West
#> 2 Pedestrian Collisions Pedestrian 10 to 14  Fatal       NA    East
#> 3 Pedestrian Collisions Pedestrian 75 to 79  Fatal       NA    East
#> 4             SMV Other  Passenger 15 to 19  Fatal       NA    <NA>
#> 5 Pedestrian Collisions Pedestrian 50 to 54  Fatal       NA    West
#>                     VEHTYPE   MANOEUVER      DRIVACT DRIVCOND
#> 1 Automobile, Station Wagon Going Ahead Lost control  Unknown
#> 2                     Other        <NA>         <NA>     <NA>
#> 3                     Other        <NA>         <NA>     <NA>
#> 4                     Other        <NA>         <NA>     <NA>
#> 5                     Other        <NA>         <NA>     <NA>
#>                                                            PEDTYPE
#> 1                                                             <NA>
#> 2                       Pedestrian hit a PXO/ped. Mid-block signal
#> 3 Vehicle is going straight thru inter.while ped cross without ROW
#> 4                                                             <NA>
#> 5                                      Pedestrian hit at mid-block
#>                           PEDACT PEDCOND CYCLISTYPE CYCACT CYCCOND PEDESTRIAN
#> 1                           <NA>    <NA>         NA     NA      NA       <NA>
#> 2 Crossing, Pedestrian Crossover  Normal         NA     NA      NA        Yes
#> 3  Crossing without right of way Unknown         NA     NA      NA        Yes
#> 4                           <NA>    <NA>         NA     NA      NA       <NA>
#> 5   Crossing, no Traffic Control  Normal         NA     NA      NA        Yes
#>   CYCLIST AUTOMOBILE MOTORCYCLE TRUCK TRSN_CITY_VEH EMERG_VEH PASSENGER
#> 1      NA        Yes         NA    NA            NA        NA      <NA>
#> 2      NA        Yes         NA    NA            NA        NA       Yes
#> 3      NA        Yes         NA    NA            NA        NA      <NA>
#> 4      NA        Yes         NA    NA            NA        NA       Yes
#> 5      NA        Yes         NA    NA            NA        NA      <NA>
#>   SPEEDING AG_DRIV REDLIGHT ALCOHOL DISABILITY HOOD_158
#> 1     <NA>    <NA>       NA      NA         NA      144
#> 2     <NA>     Yes       NA      NA         NA        5
#> 3     <NA>    <NA>       NA      NA         NA      126
#> 4      Yes     Yes       NA      NA         NA       43
#> 5      Yes     Yes       NA      NA         NA      128
#>              NEIGHBOURHOOD_158 HOOD_140                  NEIGHBOURHOOD_140
#> 1          Morningside Heights      131                        Rouge (131)
#> 2             Elms-Old Rexdale        5               Elms-Old Rexdale (5)
#> 3                  Dorset Park      126                  Dorset Park (126)
#> 4             Victoria Village       43              Victoria Village (43)
#> 5 Agincourt South-Malvern West      128 Agincourt South-Malvern West (128)
#>   DIVISION
#> 1      D42
#> 2      D23
#> 3      D41
#> 4      D55
#> 5      D42
# }