About this Dataset

Integrated Tax System Public Extract

The tax assessment roll public extract (ITSPE) is used for assessment and property analysis, to send property tax bills and notices, and stores comprehensive tax information such as ownership, mailing addresses, non-contiguous Air Rights lots (Multifamily or Development), Air Rights lots, possessory interest lots, record lots, tax lots, parcels, condominiums, and federally owned lands such as reservations and appropriations. The linkage from the Vector Property layers to this database is SSL (Square, Suffix, and Lot). It should be noted that not all record lots have a direct 1:1 relationship to information in this database. The most obvious examples would be when a tax lot was created from existing record lots. In this case, only the tax lot would have linkage to the ITSPE, not the underlying record lots (though they still exist). Reservations that have been converted into tax lots are an additional example where the reservation still exists, however for taxation purposes the tax lot (overlay) supersedes and has corresponding linkage to ITS. The same is true for most Condominiums and the ground surface lot (Record) which still exist (common space) or the previous overlay (Air Right or Tax lot), only the Condo lot would have linkage to (ITSPE).
Organization: District of Columbia
Last updated: 2025-07-09T03:44:10.357268
Tags: dc, district-of-columbia, its, itspe, land, ocfo, ownership, property, public-extract, tax-assessment, washington-dc

Tables

Table 1

@usgov.district_of_columbia_integrated_tax_system_public_extract_5b3c6.table_1

86.08 MB
220181 rows
219 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "ssl" VARCHAR,
  "square" VARCHAR,
  "suffix" VARCHAR,
  "lot" BIGINT,
  "arn" VARCHAR,
  "asrname" VARCHAR,
  "proptype" VARCHAR,
  "trigroup" VARCHAR,
  "usecode" DOUBLE,
  "landarea" BIGINT,
  "premiseadd" VARCHAR,
  "nbhd" BIGINT,
  "subnbhd" VARCHAR,
  "unitnumber" VARCHAR,
  "ownername" VARCHAR,
  "careofname" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "citystzip" VARCHAR,
  "oldland" BIGINT,
  "oldimpr" BIGINT,
  "oldtotal" BIGINT,
  "newland" BIGINT,
  "newimpr" BIGINT,
  "newtotal" BIGINT,
  "phaseland" BIGINT,
  "phasebuild" BIGINT,
  "partpart" VARCHAR,
  "vaclnduse" VARCHAR,
  "lownumber" VARCHAR,
  "streetname" VARCHAR,
  "qdrntname" VARCHAR,
  "delcode" VARCHAR,
  "hstdcode" DOUBLE,
  "classtype" VARCHAR,
  "taxrate" DOUBLE,
  "mixeduse" VARCHAR,
  "mix1txtype" VARCHAR,
  "mix1class" DOUBLE,
  "mix1rate" BIGINT,
  "mix1lndpct" DOUBLE,
  "mix1lndval" BIGINT,
  "mix1bldpct" DOUBLE,
  "mix1bldval" BIGINT,
  "mix2txtype" VARCHAR,
  "mix2class" DOUBLE,
  "mix2rate" DOUBLE,
  "mix2lndpct" DOUBLE,
  "mix2lndval" BIGINT,
  "mix2bldpct" DOUBLE,
  "mix2bldval" BIGINT,
  "ownocct" BIGINT,
  "coopunits" BIGINT,
  "pchildcode" VARCHAR,
  "abtlotcode" VARCHAR,
  "saleprice" BIGINT,
  "saledate" TIMESTAMP,
  "acceptcode" VARCHAR,
  "saletype" VARCHAR,
  "deeddate" TIMESTAMP,
  "assessment" BIGINT,
  "annualtax" DOUBLE,
  "duedate1" VARCHAR,
  "amtdue1" BIGINT,
  "duedate2" VARCHAR,
  "amtdue2" BIGINT,
  "duedate3" VARCHAR,
  "amtdue3" BIGINT,
  "totdueamt" DOUBLE,
  "totcolamt" DOUBLE,
  "totbalamt" DOUBLE,
  "extractdat" TIMESTAMP,
  "capcurr" BIGINT,
  "capprop" BIGINT,
  "reasoncd" VARCHAR,
  "cy1year" BIGINT,
  "cy1txsale" VARCHAR,
  "cy1tax" DOUBLE,
  "cy1pen" DOUBLE,
  "cy1int" DOUBLE,
  "cy1fee" DOUBLE,
  "cy1totdue" DOUBLE,
  "cy1coll" DOUBLE,
  "cy1bal" DOUBLE,
  "cy1cr" DOUBLE,
  "cy2year" BIGINT,
  "cy2txsale" VARCHAR,
  "cy2tax" DOUBLE,
  "cy2pen" BIGINT,
  "cy2int" BIGINT,
  "cy2fee" DOUBLE,
  "cy2totdue" DOUBLE,
  "cy2coll" DOUBLE,
  "cy2bal" DOUBLE,
  "cy2cr" DOUBLE,
  "py1year" BIGINT,
  "py1txsale" VARCHAR,
  "py1tax" DOUBLE,
  "py1pen" DOUBLE
);