Integrated Tax System Public Extract Vacant Property
District of Columbia
@usgov.district_of_columbia_integrated_tax_system_public_extr_46ebf287
District of Columbia
@usgov.district_of_columbia_integrated_tax_system_public_extr_46ebf287
This table is a subset of ITSPE and represents vacant property. 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: 2024-04-30T19:14:56.484024
Tags: district-of-columbia, its, itspe, land, ocfo, property, public-extract, tax-assessment, vacant, washington-dc
CREATE TABLE table_1 (
"objectid" BIGINT,
"ssl" VARCHAR,
"land_use_code" BIGINT,
"land_use_description" VARCHAR,
"landarea" BIGINT,
"property_address" VARCHAR,
"owner_name_primary" 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_code" DOUBLE,
"homestead_description" VARCHAR,
"tax_type_description" VARCHAR,
"taxrate" DOUBLE,
"mixed_use" VARCHAR,
"owner_occupied_coop_units" BIGINT,
"last_sale_price" BIGINT,
"last_sale_date" VARCHAR,
"deed_date" VARCHAR,
"current_assessment_cap" BIGINT,
"proposed_assessment_cap" BIGINT,
"owner_name_secondary" VARCHAR,
"address_id" VARCHAR,
"lastmodifieddate" VARCHAR,
"appraised_value_current_total" BIGINT
);Anyone who has the link will be able to view this.