About this Dataset

Road Centerlines

The road centerlines have been developed and are maintained by the City's GIS staff. The address ranges match the values of the address points on the corresponding City properties and they have many attributes. They are routable and are used by many departments in the City.
Organization: City of Hartford
Last updated: 2025-06-09T20:50:40.762918
Tags: address-range, centerline, gis-data, hartford-ct, road, road-name, roads, street, transportation

Tables

Table 1

@usgov.city_of_hartford_road_centerlines_54eb0.table_1

340.85 kB
3,963 rows
44 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "streetname" VARCHAR,
  "streettype" VARCHAR,
  "leftfrom" BIGINT,
  "leftto" BIGINT,
  "rightfrom" BIGINT,
  "rightto" BIGINT,
  "speed" BIGINT,
  "routenumbe" VARCHAR,
  "hwyshield" VARCHAR,
  "lefttown" VARCHAR,
  "righttown" VARCHAR,
  "status" VARCHAR,
  "oneway" VARCHAR,
  "fullname" VARCHAR,
  "direction" VARCHAR,
  "cv_stprefix" VARCHAR,
  "cv_stname" VARCHAR,
  "cv_sttype" VARCHAR,
  "cv_stsuffix" VARCHAR,
  "symbology" VARCHAR,
  "globalid" VARCHAR,
  "ownership" VARCHAR,
  "externalstreetkey" BIGINT,
  "routingstreetexternalkey" DOUBLE,
  "leftcitycode" BIGINT,
  "rightcitycode" BIGINT,
  "leftcountycode" BIGINT,
  "rightcountycode" BIGINT,
  "leftstate" VARCHAR,
  "rightstate" VARCHAR,
  "featuretypecode" VARCHAR,
  "leftzipcode" BIGINT,
  "rightzipcode" BIGINT,
  "toelevation" BIGINT,
  "fromelevation" BIGINT,
  "locationname" VARCHAR,
  "leftcityname" VARCHAR,
  "rightcityname" VARCHAR,
  "leftcountyname" VARCHAR,
  "rightcountyname" VARCHAR,
  "speedcad" BIGINT,
  "onewaycad" VARCHAR,
  "shapestlength" DOUBLE
);