Neighbourhood Crime Rates Open Data
Source:R/datasets_tps_arcgis_hub_wrappers.R
morie_datasets_tps_neighbourhood_crime_rates.RdToronto PS ArcGIS Hub dataset wrapper. Thin dispatch to
morie_datasets_tps_arcgis_hub_by_id() with the canonical
hub item_id ea0cfecdb1de416884e6b0bf08a9e195.
Usage
morie_datasets_tps_neighbourhood_crime_rates(
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
WHEREfilter passed to FeatureServer?where=(default"1=1").- max_features
Optional cap on returned rows. Passed as
resultRecordCountto 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). DefaultTRUE– 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 totempfile().
Value
A data.frame / GeoJSON list / file path; see
morie_datasets_tps_arcgis_hub_by_id() for per-format semantics.
Details
Neighbourhood crime rates per 100,000.
Tags: Neighbourhood; Crime; Rate; Crime Rates; Community Safety Indicators; CSI; Toronto; TPS; Toronto Police
Examples
# \donttest{
df <- try(morie_datasets_tps_neighbourhood_crime_rates(max_features = 5L))
if (!inherits(df, "try-error")) head(df)
#> OBJECTID_1 AREA_NAME HOOD_ID ASSAULT_2014 ASSAULT_2015
#> 1 1 South Eglinton-Davisville 174 55 56
#> 2 2 North Toronto 173 53 57
#> 3 3 Dovercourt Village 172 62 65
#> 4 4 Junction-Wallace Emerson 171 164 159
#> 5 5 Yonge-Bay Corridor 170 387 521
#> ASSAULT_2016 ASSAULT_2017 ASSAULT_2018 ASSAULT_2019 ASSAULT_2020 ASSAULT_2021
#> 1 66 73 74 62 74 106
#> 2 47 61 66 84 80 118
#> 3 92 105 106 113 91 115
#> 4 171 161 163 186 171 182
#> 5 481 602 576 660 377 325
#> ASSAULT_2022 ASSAULT_2023 ASSAULT_2024 ASSAULT_2025 ASSAULT_RATE_2014
#> 1 122 100 123 126 301.1718
#> 2 136 105 128 129 455.7572
#> 3 103 104 118 128 456.1507
#> 4 138 230 195 200 698.2586
#> 5 441 543 554 560 3750.0000
#> ASSAULT_RATE_2015 ASSAULT_RATE_2016 ASSAULT_RATE_2017 ASSAULT_RATE_2018
#> 1 304.9113 342.8215 356.3409 340.3394
#> 2 492.3130 406.3986 482.2134 477.5342
#> 3 481.4102 680.1715 777.8930 785.9420
#> 4 667.0303 697.9022 652.8792 655.4081
#> 5 4761.9048 4119.5615 4949.8438 4541.1543
#> ASSAULT_RATE_2019 ASSAULT_RATE_2020 ASSAULT_RATE_2021 ASSAULT_RATE_2022
#> 1 270.6833 309.7012 427.8334 474.3944
#> 2 561.7602 501.2845 700.5046 766.3699
#> 3 841.1494 685.6024 878.8018 786.8001
#> 4 743.3458 685.3433 734.6708 541.3676
#> 5 5015.1978 2785.1655 2345.3850 3042.2185
#> ASSAULT_RATE_2023 ASSAULT_RATE_2024 ASSAULT_RATE_2025 AUTOTHEFT_2014
#> 1 368.7451 434.3680 435.9560 2
#> 2 554.1774 640.1600 626.7612 8
#> 3 783.8408 883.7628 974.9410 11
#> 4 864.6617 709.1941 720.0201 21
#> 5 3523.6860 3416.8003 3361.1428 13
#> AUTOTHEFT_2015 AUTOTHEFT_2016 AUTOTHEFT_2017 AUTOTHEFT_2018 AUTOTHEFT_2019
#> 1 4 8 7 14 8
#> 2 2 2 2 3 5
#> 3 15 18 15 12 13
#> 4 18 14 18 34 24
#> 5 20 20 14 32 37
#> AUTOTHEFT_2020 AUTOTHEFT_2021 AUTOTHEFT_2022 AUTOTHEFT_2023 AUTOTHEFT_2024
#> 1 15 16 10 20 19
#> 2 14 15 10 20 10
#> 3 24 11 25 29 36
#> 4 47 35 47 37 47
#> 5 16 18 30 48 38
#> AUTOTHEFT_2025 AUTOTHEFT_RATE_2014 AUTOTHEFT_RATE_2015 AUTOTHEFT_RATE_2016
#> 1 17 10.95170 21.77938 41.55412
#> 2 14 68.79353 17.27414 17.29356
#> 3 17 80.92996 111.09465 133.07704
#> 4 30 89.41116 75.51286 57.13819
#> 5 27 125.96899 182.79865 171.29153
#> AUTOTHEFT_RATE_2017 AUTOTHEFT_RATE_2018 AUTOTHEFT_RATE_2019
#> 1 34.16968 64.38854 34.92687
#> 2 15.81028 21.70610 33.43811
#> 3 111.12757 88.97457 96.76939
#> 4 72.99270 136.71089 95.91560
#> 5 115.11265 252.28635 281.15503
#> AUTOTHEFT_RATE_2020 AUTOTHEFT_RATE_2021 AUTOTHEFT_RATE_2022
#> 1 62.77727 64.57862 38.88478
#> 2 87.72479 89.04720 56.35073
#> 3 180.81821 84.05930 190.97090
#> 4 188.36920 141.28285 184.37880
#> 5 118.20331 129.89824 206.95364
#> AUTOTHEFT_RATE_2023 AUTOTHEFT_RATE_2024 AUTOTHEFT_RATE_2025 BIKETHEFT_2014
#> 1 73.74903 67.0975 58.81946 14
#> 2 105.55761 50.0125 68.02060 8
#> 3 218.57100 269.6225 129.48434 29
#> 4 139.09775 170.9340 108.00302 42
#> 5 311.48605 234.3654 162.05510 220
#> BIKETHEFT_2015 BIKETHEFT_2016 BIKETHEFT_2017 BIKETHEFT_2018 BIKETHEFT_2019
#> 1 19 27 33 29 42
#> 2 13 9 14 18 22
#> 3 35 55 47 30 27
#> 4 41 50 63 67 70
#> 5 154 202 214 263 220
#> BIKETHEFT_2020 BIKETHEFT_2021 BIKETHEFT_2022 BIKETHEFT_2023 BIKETHEFT_2024
#> 1 92 33 16 37 21
#> 2 52 23 12 22 14
#> 3 32 27 20 38 34
#> 4 54 36 34 55 41
#> 5 172 167 229 228 192
#> BIKETHEFT_2025 BIKETHEFT_RATE_2014 BIKETHEFT_RATE_2015 BIKETHEFT_RATE_2016
#> 1 6 76.66192 103.4520 140.24516
#> 2 15 68.79353 112.2819 77.82101
#> 3 23 213.36079 259.2209 406.62427
#> 4 43 178.82233 172.0015 204.06497
#> 5 137 2131.78296 1407.5496 1730.04456
#> BIKETHEFT_RATE_2017 BIKETHEFT_RATE_2018 BIKETHEFT_RATE_2019
#> 1 161.0856 133.3763 183.3661
#> 2 110.6719 130.2366 147.1277
#> 3 348.1997 222.4364 200.9826
#> 4 255.4745 269.4009 279.7538
#> 5 1759.5790 2073.4785 1671.7325
#> BIKETHEFT_RATE_2020 BIKETHEFT_RATE_2021 BIKETHEFT_RATE_2022
#> 1 385.0339 133.1934 62.21566
#> 2 325.8350 136.5390 67.62087
#> 3 241.0909 206.3274 152.77672
#> 4 216.4242 145.3195 133.38040
#> 5 1270.6855 1205.1671 1579.74609
#> BIKETHEFT_RATE_2023 BIKETHEFT_RATE_2024 BIKETHEFT_RATE_2025 BREAKENTER_2014
#> 1 136.4357 74.1604 20.75981 27
#> 2 116.1134 70.0175 72.87921 25
#> 3 286.4034 254.6435 175.18471 38
#> 4 206.7669 149.1126 154.80434 37
#> 5 1479.5587 1184.1619 822.27960 69
#> BREAKENTER_2015 BREAKENTER_2016 BREAKENTER_2017 BREAKENTER_2018
#> 1 32 25 37 48
#> 2 44 15 24 42
#> 3 22 38 39 50
#> 4 46 41 51 91
#> 5 115 60 125 99
#> BREAKENTER_2019 BREAKENTER_2020 BREAKENTER_2021 BREAKENTER_2022
#> 1 83 69 44 24
#> 2 36 89 49 48
#> 3 83 47 19 33
#> 4 103 110 76 56
#> 5 119 148 112 123
#> BREAKENTER_2023 BREAKENTER_2024 BREAKENTER_2025 BREAKENTER_RATE_2014
#> 1 43 52 37 147.8480
#> 2 31 31 36 214.9798
#> 3 46 45 31 279.5762
#> 4 82 77 64 157.5340
#> 5 108 95 92 668.6047
#> BREAKENTER_RATE_2015 BREAKENTER_RATE_2016 BREAKENTER_RATE_2017
#> 1 174.2350 129.8566 180.6111
#> 2 380.0311 129.7017 189.7233
#> 3 162.9388 280.9404 288.9317
#> 4 192.9773 167.3333 206.8127
#> 5 1051.0922 513.8746 1027.7915
#> BREAKENTER_RATE_2018 BREAKENTER_RATE_2019 BREAKENTER_RATE_2020
#> 1 220.7607 362.3663 288.7754
#> 2 303.8854 240.7544 557.6791
#> 3 370.7274 617.8353 354.1023
#> 4 365.9027 411.6378 440.8641
#> 5 780.5109 904.2553 1093.3806
#> BREAKENTER_RATE_2021 BREAKENTER_RATE_2022 BREAKENTER_RATE_2023
#> 1 177.5912 93.32349 158.5604
#> 2 290.8875 270.48349 163.6143
#> 3 145.1933 252.08159 346.6988
#> 4 306.7856 219.68538 308.2707
#> 5 808.2557 848.50995 700.8436
#> BREAKENTER_RATE_2024 BREAKENTER_RATE_2025 HOMICIDE_2014 HOMICIDE_2015
#> 1 183.6353 128.0188 0 0
#> 2 155.0388 174.9101 0 0
#> 3 337.0282 236.1185 1 0
#> 4 280.0407 230.4064 1 3
#> 5 585.9134 552.1877 1 2
#> HOMICIDE_2016 HOMICIDE_2017 HOMICIDE_2018 HOMICIDE_2019 HOMICIDE_2020
#> 1 1 0 0 1 1
#> 2 0 0 0 1 1
#> 3 0 1 0 2 1
#> 4 0 1 0 1 0
#> 5 0 0 1 2 0
#> HOMICIDE_2021 HOMICIDE_2022 HOMICIDE_2023 HOMICIDE_2024 HOMICIDE_2025
#> 1 1 0 0 0 0
#> 2 0 0 0 0 0
#> 3 0 0 0 0 0
#> 4 0 0 0 0 0
#> 5 1 1 1 1 2
#> HOMICIDE_RATE_2014 HOMICIDE_RATE_2015 HOMICIDE_RATE_2016 HOMICIDE_RATE_2017
#> 1 0.000000 0.00000 5.194265 0.000000
#> 2 0.000000 0.00000 0.000000 0.000000
#> 3 7.357269 0.00000 0.000000 7.408505
#> 4 4.257675 12.58548 0.000000 4.055150
#> 5 9.689922 18.27987 0.000000 0.000000
#> HOMICIDE_RATE_2018 HOMICIDE_RATE_2019 HOMICIDE_RATE_2020 HOMICIDE_RATE_2021
#> 1 0.000000 4.365859 4.185151 4.036164
#> 2 0.000000 6.687621 6.266057 0.000000
#> 3 0.000000 14.887599 7.534092 0.000000
#> 4 0.000000 3.996483 0.000000 0.000000
#> 5 7.883948 15.197568 0.000000 7.216569
#> HOMICIDE_RATE_2022 HOMICIDE_RATE_2023 HOMICIDE_RATE_2024 HOMICIDE_RATE_2025
#> 1 0.000000 0.000000 0.00000 0.00000
#> 2 0.000000 0.000000 0.00000 0.00000
#> 3 0.000000 0.000000 0.00000 0.00000
#> 4 0.000000 0.000000 0.00000 0.00000
#> 5 6.898455 6.489293 6.16751 12.00408
#> ROBBERY_2014 ROBBERY_2015 ROBBERY_2016 ROBBERY_2017 ROBBERY_2018 ROBBERY_2019
#> 1 10 8 8 7 12 5
#> 2 7 12 8 6 14 19
#> 3 29 27 16 42 35 17
#> 4 26 30 27 30 22 32
#> 5 72 52 73 86 90 63
#> ROBBERY_2020 ROBBERY_2021 ROBBERY_2022 ROBBERY_2023 ROBBERY_2024 ROBBERY_2025
#> 1 16 9 15 3 16 7
#> 2 3 12 12 14 18 11
#> 3 16 22 14 21 12 9
#> 4 23 11 20 18 12 10
#> 5 55 50 55 60 65 50
#> ROBBERY_RATE_2014 ROBBERY_RATE_2015 ROBBERY_RATE_2016 ROBBERY_RATE_2017
#> 1 54.75851 43.55875 41.55412 34.16968
#> 2 60.19434 103.64484 69.17423 47.43083
#> 3 213.36079 199.97037 118.29070 311.15720
#> 4 110.69954 125.85477 110.19508 121.65450
#> 5 697.67444 475.27649 625.21411 707.12054
#> ROBBERY_RATE_2018 ROBBERY_RATE_2019 ROBBERY_RATE_2020 ROBBERY_RATE_2021
#> 1 55.19018 21.82929 66.96242 36.32548
#> 2 101.29513 127.06480 18.79817 71.23775
#> 3 259.50916 126.54459 120.54547 168.11861
#> 4 88.45999 127.88746 92.18067 44.40318
#> 5 709.55536 478.72342 406.32388 360.82846
#> ROBBERY_RATE_2022 ROBBERY_RATE_2023 ROBBERY_RATE_2024 ROBBERY_RATE_2025
#> 1 58.32718 11.06236 56.50316 24.21978
#> 2 67.62087 73.89033 90.02251 53.44476
#> 3 106.94370 158.27554 89.87418 68.55054
#> 4 78.45906 67.66917 43.64271 36.00101
#> 5 379.41501 389.35757 400.88812 300.10202
#> SHOOTING_2014 SHOOTING_2015 SHOOTING_2016 SHOOTING_2017 SHOOTING_2018
#> 1 1 0 1 0 1
#> 2 0 0 0 0 0
#> 3 0 0 2 0 0
#> 4 0 2 1 5 3
#> 5 1 3 0 3 4
#> SHOOTING_2019 SHOOTING_2020 SHOOTING_2021 SHOOTING_2022 SHOOTING_2023
#> 1 0 1 0 1 0
#> 2 1 0 1 1 0
#> 3 0 0 2 0 1
#> 4 2 4 4 3 2
#> 5 4 2 0 1 2
#> SHOOTING_2024 SHOOTING_2025 SHOOTING_RATE_2014 SHOOTING_RATE_2015
#> 1 2 0 5.475852 0.000000
#> 2 1 0 0.000000 0.000000
#> 3 2 0 0.000000 0.000000
#> 4 0 1 0.000000 8.390318
#> 5 1 2 9.689922 27.419798
#> SHOOTING_RATE_2016 SHOOTING_RATE_2017 SHOOTING_RATE_2018 SHOOTING_RATE_2019
#> 1 5.194265 0.00000 4.599181 0.000000
#> 2 0.000000 0.00000 0.000000 6.687621
#> 3 14.786338 0.00000 0.000000 0.000000
#> 4 4.081299 20.27575 12.062726 7.992966
#> 5 0.000000 24.66700 31.535793 30.395136
#> SHOOTING_RATE_2020 SHOOTING_RATE_2021 SHOOTING_RATE_2022 SHOOTING_RATE_2023
#> 1 4.185151 0.00000 3.888479 0.000000
#> 2 0.000000 5.93648 5.635073 0.000000
#> 3 0.000000 15.28351 0.000000 7.536931
#> 4 16.031422 16.14661 11.768860 7.518797
#> 5 14.775414 0.00000 6.898455 12.978585
#> SHOOTING_RATE_2024 SHOOTING_RATE_2025 THEFTFROMMV_2014 THEFTFROMMV_2015
#> 1 7.062895 0.000000 13 18
#> 2 5.001250 0.000000 23 7
#> 3 14.979030 0.000000 45 38
#> 4 0.000000 3.600101 74 26
#> 5 6.167510 12.004082 120 102
#> THEFTFROMMV_2016 THEFTFROMMV_2017 THEFTFROMMV_2018 THEFTFROMMV_2019
#> 1 11 16 18 24
#> 2 15 14 8 18
#> 3 51 43 87 79
#> 4 48 72 153 124
#> 5 77 86 112 171
#> THEFTFROMMV_2020 THEFTFROMMV_2021 THEFTFROMMV_2022 THEFTFROMMV_2023
#> 1 41 22 42 40
#> 2 26 16 24 40
#> 3 68 18 29 25
#> 4 144 53 63 58
#> 5 135 63 107 76
#> THEFTFROMMV_2024 THEFTFROMMV_2025 THEFTFROMMV_RATE_2014 THEFTFROMMV_RATE_2015
#> 1 25 29 71.18607 98.00719
#> 2 11 13 197.78140 60.45949
#> 3 22 19 331.07712 281.43979
#> 4 71 56 315.06790 109.07413
#> 5 77 67 1162.79065 932.27307
#> THEFTFROMMV_RATE_2016 THEFTFROMMV_RATE_2017 THEFTFROMMV_RATE_2018
#> 1 57.13692 78.10212 82.78526
#> 2 129.70169 110.67194 57.88293
#> 3 377.05161 318.56570 645.06561
#> 4 195.90237 291.97079 615.19904
#> 5 659.47241 707.12054 883.00220
#> THEFTFROMMV_RATE_2019 THEFTFROMMV_RATE_2020 THEFTFROMMV_RATE_2021
#> 1 104.7806 171.5912 88.79561
#> 2 120.3772 162.9175 94.98367
#> 3 588.0601 512.3182 137.55157
#> 4 495.5639 577.1312 213.94260
#> 5 1299.3921 997.3405 454.64386
#> THEFTFROMMV_RATE_2022 THEFTFROMMV_RATE_2023 THEFTFROMMV_RATE_2024
#> 1 163.3161 147.4981 88.28619
#> 2 135.2417 211.1152 55.01375
#> 3 221.5262 188.4233 164.76932
#> 4 247.1461 218.0451 258.21939
#> 5 738.1346 493.1862 474.89822
#> THEFTFROMMV_RATE_2025 THEFTOVER_2014 THEFTOVER_2015 THEFTOVER_2016
#> 1 100.33907 4 3 4
#> 2 63.16199 2 3 2
#> 3 144.71780 5 3 5
#> 4 201.60565 5 5 6
#> 5 402.13672 37 30 27
#> THEFTOVER_2017 THEFTOVER_2018 THEFTOVER_2019 THEFTOVER_2020 THEFTOVER_2021
#> 1 1 3 3 4 6
#> 2 2 5 4 7 2
#> 3 3 4 4 3 2
#> 4 6 9 4 9 8
#> 5 35 44 63 35 26
#> THEFTOVER_2022 THEFTOVER_2023 THEFTOVER_2024 THEFTOVER_2025
#> 1 3 8 6 6
#> 2 4 7 6 5
#> 3 4 3 7 3
#> 4 8 9 13 9
#> 5 51 52 48 35
#> THEFTOVER_RATE_2014 THEFTOVER_RATE_2015 THEFTOVER_RATE_2016
#> 1 21.90341 16.33453 20.77706
#> 2 17.19838 25.91121 17.29356
#> 3 36.78635 22.21893 36.96584
#> 4 21.28837 20.97579 24.48780
#> 5 358.52713 274.19797 231.24358
#> THEFTOVER_RATE_2017 THEFTOVER_RATE_2018 THEFTOVER_RATE_2019
#> 1 4.881382 13.79754 13.09758
#> 2 15.810277 36.17683 26.75048
#> 3 22.225515 29.65819 29.77520
#> 4 24.330900 36.18818 15.98593
#> 5 287.781616 346.89374 478.72342
#> THEFTOVER_RATE_2020 THEFTOVER_RATE_2021 THEFTOVER_RATE_2022
#> 1 16.74060 24.21698 11.66544
#> 2 43.86240 11.87296 22.54029
#> 3 22.60228 15.28351 30.55534
#> 4 36.07070 32.29322 31.38363
#> 5 258.56973 187.63080 351.82120
#> THEFTOVER_RATE_2023 THEFTOVER_RATE_2024 THEFTOVER_RATE_2025 POPULATION_2025
#> 1 29.49961 21.18868 20.75981 28902
#> 2 36.94516 30.00750 24.29307 20582
#> 3 22.61079 52.42660 22.85018 13129
#> 4 33.83459 47.27961 32.40091 27777
#> 5 337.44321 296.04047 210.07143 16661
#> Shape__Area Shape__Length
#> 1 944309.0 4005.550
#> 2 402030.8 2543.946
#> 3 1503002.2 4965.496
#> 4 2222866.7 7435.192
#> 5 1118724.5 4811.108
# }