Name: Address Points
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-zero

About this Dataset

Address Points

The data was compiled by MobileVideo in 2002 in a windshield survey of building entrances. This data is updated daily by the City's GIS Staff with field verification done by DPW, License and Inspection or Fire Marshall's Office.
Organization: City of Hartford
Last updated: 2025-06-09T20:52:37.208861
Tags: address, development, hartford-ct, housing

Tables

Table 1

@usgov.city_of_hartford_address_points_51a02.table_1

2.3 MB
42,654 rows
40 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "streetnum" VARCHAR,
  "stnumsuffx" VARCHAR,
  "streetname" VARCHAR,
  "streettype" VARCHAR,
  "camapin" DOUBLE,
  "addressptloc" VARCHAR,
  "datecreate" TIMESTAMP,
  "unitnum" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE,
  "status" VARCHAR,
  "taxmaplbl" VARCHAR,
  "full_address" VARCHAR,
  "placename" VARCHAR,
  "placestnum" VARCHAR,
  "placestnam" VARCHAR,
  "addrplusunit" VARCHAR,
  "stname_mat" DOUBLE,
  "flid_gis" BIGINT,
  "junk1" VARCHAR,
  "field1" VARCHAR,
  "field2" VARCHAR,
  "field3" BIGINT,
  "externalkey" BIGINT,
  "locationname" VARCHAR,
  "streetname1" VARCHAR,
  "address" BIGINT,
  "citycode" VARCHAR,
  "zipcode" BIGINT,
  "countycode" VARCHAR,
  "state" VARCHAR,
  "routingstreetextkey" DOUBLE,
  "countycode1" VARCHAR,
  "leftcityname" VARCHAR,
  "rightcityname" VARCHAR,
  "leftcountyname" VARCHAR,
  "rightcountyname" VARCHAR,
  "fireraleft" VARCHAR,
  "fireraright" VARCHAR
);