Name: CAMAGIS Property Details
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-zero

About this Dataset

CAMAGIS Property Details

Contains property ownership information from the City Assessor CAMA system that can be joined to our GIS parcel polygons based on the parcel ID field. This information is update nightly from the City Assessor's database.
Organization: City of Hartford
Last updated: 2025-06-09T20:49:21.348650
Tags: assessor, cama, financial, hartford-ct, property-owner-information

Tables

Table 1

@usgov.city_of_hartford_camagis_property_details_b631c.table_1

2.58 MB
28,391 rows
53 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "accountnumber" BIGINT,
  "gisparcelnumber" DOUBLE,
  "parcelnumber" BIGINT,
  "cardnumber" BIGINT,
  "streetnumberfrom" DOUBLE,
  "streetnumberto" VARCHAR,
  "streetname" VARCHAR,
  "condonumber" VARCHAR,
  "ownerfullname" VARCHAR,
  "owner1fname" VARCHAR,
  "owner1last" VARCHAR,
  "owner2fname" VARCHAR,
  "owner2last" VARCHAR,
  "owner3fname" VARCHAR,
  "owner3last" VARCHAR,
  "mailingaddress1" VARCHAR,
  "mailingaddress2" VARCHAR,
  "mailingstreet" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip10" VARCHAR,
  "luc" VARCHAR,
  "lucdescription" VARCHAR,
  "zoning" VARCHAR,
  "nbhdcode" VARCHAR,
  "nbhddesc" VARCHAR,
  "lastgrantor" VARCHAR,
  "lastsaledate" TIMESTAMP,
  "lastsaleprice" DOUBLE,
  "lastsalecode" VARCHAR,
  "lastsaletype" VARCHAR,
  "legalref" VARCHAR,
  "livingunits" DOUBLE,
  "yearbuilt" DOUBLE,
  "totapprsdvalue" DOUBLE,
  "grossbuiltarea" DOUBLE,
  "totfinishdarea" DOUBLE,
  "totacreage" DOUBLE,
  "storyheight" VARCHAR,
  "bldgtype" VARCHAR,
  "bldgfoundation" VARCHAR,
  "bldgframetype" VARCHAR,
  "primextwall" VARCHAR,
  "bldgrooftype" VARCHAR,
  "bldgroofcover" VARCHAR,
  "primintwall" VARCHAR,
  "bedrooms" DOUBLE,
  "primheatfuel" VARCHAR,
  "primheatfueldesc" VARCHAR,
  "primheattype" VARCHAR,
  "primheattypedesc" VARCHAR,
  "taxmap" VARCHAR
);