Baselight
Sign In

Snow Route Summary

Town of Cary, North Carolina

@usgov.town_of_cary_north_carolina_snow_route_summary

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
Loading...
 

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
);