About this Dataset

Snow Route Summary

This dataset contains information on the Town’s street mileage and corresponding equipment for major spreader and plow routes from 2009 to 2015. It does not include mileage for most through-streets in subdivisions and culs-de-sac. It does not measure the actual effort and material expended on individual events.

This dataset is an archive - it is not being updated.
Organization: Town of Cary, North Carolina
Last updated: 2020-11-12T13:15:08.054131
Tags: plow, snow, spreader, weather

Tables

Table 1

@usgov.town_of_cary_north_carolina_snow_route_summary.table_1

13.7 KB
98 rows
16 columns


CREATE TABLE table_1 (
  "year" BIGINT,
  "route" BIGINT,
  "routetype" VARCHAR,
  "streetmileage" DOUBLE,
  "tocsingleaxleltplow" BIGINT,
  "tocsingleaxleplowspdr" BIGINT,
  "tocyardwasteplow" BIGINT,
  "toctandemplowspdr" BIGINT,
  "tocpickupplow" BIGINT,
  "conttandemplow" BIGINT,
  "conttandemplowspdr" BIGINT,
  "contpickup" BIGINT,
  "plowequivalents" DOUBLE,
  "spreaderequivalents" BIGINT,
  "plowstreetmileratio" DOUBLE,
  "spreaderstreetmileratio" DOUBLE
);