See data.cdrc.ac.uk/dataset/southwark-traffic-counts
This dataset represents travel levels at the point locations stored in
traffic
traffic_volumes
Format
An object of class tbl_df (inherits from tbl, data.frame) with 1522 rows and 20 columns.
Examples
if (FALSE) { f = "/tmp/2010-2016-allaveragedailytrafficflowcdrcmapreducedfile.xlsx" traffic_volumes = readxl::read_excel(f) summary(traffic_volumes$ID %in% traffic$cp) pryr::object_size(traffic_volumes) usethis::use_data(traffic_volumes) library(dplyr) traffic_agg = traffic_volumes %>% group_by(cp = ID) %>% summarise( total = sum(`TOTAL FLOW`), cycle_or_motorcycle = sum(`ARX PEDAL-MOTORCYCLE`), av_speed = mean(AVERAGE_SPEED), year = mean(YEAR) ) if(ncol(traffic) < 8) { traffic = left_join(traffic, traffic_agg) usethis::use_data(traffic, overwrite = TRUE) } mapview::mapview(traffic, zcol = "total") sf:::plot.sf(traffic) } summary(traffic_volumes)#> ID ROAD EASTING NORTHING #> Length:1522 Length:1522 Min. :531210 Min. :170864 #> Class :character Class :character 1st Qu.:532908 1st Qu.:175243 #> Mode :character Mode :character Median :533826 Median :176829 #> Mean :533768 Mean :176794 #> 3rd Qu.:534654 3rd Qu.:178637 #> Max. :536583 Max. :180497 #> #> ORIGINAL_REF DIRECTION MONTH YEAR #> Length:1522 Length:1522 Length:1522 Min. :2010 #> Class :character Class :character Class :character 1st Qu.:2011 #> Mode :character Mode :character Mode :character Median :2013 #> Mean :2013 #> 3rd Qu.:2015 #> Max. :2016 #> #> MONITORING TYPE TOTAL FLOW ARX PEDAL-MOTORCYCLE ARX CAR #> Length:1522 Min. : 4.143 Min. : 0.0 Min. : 1.0 #> Class :character 1st Qu.: 701.500 1st Qu.: 55.0 1st Qu.: 536.2 #> Mode :character Median : 2356.000 Median : 162.0 Median : 1934.5 #> Mean : 3861.157 Mean : 219.3 Mean : 3220.4 #> 3rd Qu.: 6294.179 3rd Qu.: 294.0 3rd Qu.: 5329.8 #> Max. :20036.000 Max. :1635.0 Max. :17806.0 #> #> ARX TRAILER_CARAVAN_VAN ARX 2AXLE_TRUCKorBUS ARX 3AXLE_TRUCKorBUS #> Min. : 0.00 Min. : 0.0 Min. : 0.00 #> 1st Qu.: 1.00 1st Qu.: 41.0 1st Qu.: 2.00 #> Median : 7.00 Median : 183.0 Median : 9.00 #> Mean : 21.15 Mean : 330.5 Mean : 28.73 #> 3rd Qu.: 32.00 3rd Qu.: 521.0 3rd Qu.: 33.18 #> Max. :289.00 Max. :2874.0 Max. :1026.00 #> NA's :6 NA's :6 NA's :6 #> ARX 4AXLE_TRUCK ARX LGV TOTAL LARGER THAN CAR AVERAGE_SPEED #> Min. : 0.000 Min. : 0.00 Min. : 0.0 Min. : 6.00 #> 1st Qu.: 1.286 1st Qu.: 0.00 1st Qu.: 49.0 1st Qu.:16.90 #> Median : 9.000 Median : 4.00 Median : 230.5 Median :19.50 #> Mean : 23.591 Mean : 23.84 Mean : 427.4 Mean :19.68 #> 3rd Qu.: 27.893 3rd Qu.: 24.68 3rd Qu.: 668.8 3rd Qu.:22.60 #> Max. :473.000 Max. :675.00 Max. :3465.0 Max. :31.80 #> NA's :6 NA's :6 #> _85TH_SPEED #> Min. : 0.00 #> 1st Qu.:21.00 #> Median :24.40 #> Mean :24.32 #> 3rd Qu.:27.70 #> Max. :71.80 #> NA's :3
