Baselight

Integrated Tax System Public Extract Facts

District of Columbia

@usgov.district_of_columbia_integrated_tax_system_public_extr_77ec29cc

Loading...
Loading...

About this Dataset

Integrated Tax System Public Extract Facts

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). This table has fewer fields than the ITSPE and clarifies the abbreviated column names from the Data Dictionary.
Organization: District of Columbia
Last updated: 2025-05-07T01:16:36.296749
Tags: dc, district-of-columbia, its, itspe, land, ocfo, property, public-extract, tax-assessment, washington-dc

Tables

Table 1

@usgov.district_of_columbia_integrated_tax_system_public_extr_77ec29cc.table_1
  • 30.8 MB
  • 215,439 rows
  • 37 columns
Loading...
CREATE TABLE table_1 (
  "objectid" BIGINT,
  "ssl" VARCHAR,
  "assessor_name" VARCHAR,
  "land_use_code" DOUBLE,
  "land_use_description" VARCHAR,
  "landarea" BIGINT,
  "property_address" VARCHAR,
  "otr_neighborhood_code" BIGINT,
  "otr_neighborhood_name" VARCHAR,
  "owner_name_primary" VARCHAR,
  "careof_name" VARCHAR,
  "owner_address_line1" VARCHAR,
  "owner_address_line2" VARCHAR,
  "owner_address_citystzip" VARCHAR,
  "appraised_value_prior_land" BIGINT,
  "appraised_value_prior_impr" BIGINT,
  "appraised_value_prior_total" BIGINT,
  "appraised_value_proposed_land" BIGINT,
  "appraised_value_proposed_impr" BIGINT,
  "appraised_value_proposed_total" BIGINT,
  "appraised_value_current_land" BIGINT,
  "appraised_value_current_bldg" BIGINT,
  "vacant_use" VARCHAR,
  "homestead_description" VARCHAR,
  "tax_type_description" VARCHAR,
  "taxrate" DOUBLE,
  "mixed_use" VARCHAR,
  "owner_occupied_coop_units" BIGINT,
  "last_sale_price" BIGINT,
  "last_sale_date" TIMESTAMP,
  "deed_date" TIMESTAMP,
  "current_assessment_cap" BIGINT,
  "proposed_assessment_cap" BIGINT,
  "owner_name_secondary" VARCHAR,
  "address_id" VARCHAR,
  "lastmodifieddate" TIMESTAMP,
  "appraised_value_current_total" BIGINT
);

Share link

Anyone who has the link will be able to view this.