Name: Snow Plow Routes
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-zero

About this Dataset

Snow Plow Routes

This layer contains the snow plow routes for the Department of Public Works.
Organization: City of Hartford
Last updated: 2025-06-09T20:50:18.667764
Tags: ct, gis-data, hartford, public-works, snow-plow-route

Tables

Table 1

@usgov.city_of_hartford_snow_plow_routes.table_1

224.43 KB
2920 rows
28 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "code" VARCHAR,
  "speed" DOUBLE,
  "routenumbe" VARCHAR,
  "hwyshield" VARCHAR,
  "oneway" VARCHAR,
  "fullname" VARCHAR,
  "mtchmaster" VARCHAR,
  "direction" VARCHAR,
  "symbology" VARCHAR,
  "streetid" DOUBLE,
  "sectionid" VARCHAR,
  "txtaltsnowinfo" VARCHAR,
  "txtstreetstofrom" VARCHAR,
  "intcomments" DOUBLE,
  "intcomments2" DOUBLE,
  "intaltparking" DOUBLE,
  "txtowner" VARCHAR,
  "intconstruction2006" DOUBLE,
  "intconstruction2007" BIGINT,
  "txtmaporder" VARCHAR,
  "snowroute2008" VARCHAR,
  "txtmapord" DOUBLE,
  "intconstruction2008" DOUBLE,
  "intconstorder2008" DOUBLE,
  "label" VARCHAR,
  "globalid" VARCHAR,
  "shapestlength" DOUBLE
);