Common Ownership Lots by US Government | Finance and Economics

About this Dataset

Common Ownership Lots

The common ownership lots is a single polygon layer that is built from various polygon feature classes of the District's Vector Property Mapping database including the below. It represents all lands that are outside right-of-way.

Record Lots
Tax Lots
Parcel Lots
Reservation Lots
Air Rights Lots

All of which are found separately on https://opendata.dc.gov. The Office of Tax and Revenue maintains a database known as Information Tax System (ITS) that contains the accounts for the real property taxes. ITS records reference record lots, tax lots, parcels, condominiums and federally owned lands such as reservations. Information from ITS is conflated to Common Ownership Lot features by SSL (Square, Suffix and Lot). This layer does not include condo records. This layer is regenerated WEEKLY with an automated algorithm using the latest Pubic Extract information for attribution.
Organization: District of Columbia
Last updated: 2024-04-30T18:24:52.256695
Tags: air-right, dc, district-of-columbia, dob, land, lot, parcel, planning-cadastre, property, record, reservations, square, tax, vpmdata, washington-dc

Tables

Table 1

@usgov.district_of_columbia_common_ownership_lots.table_1

27.25 MB
137361 rows
231 columns


CREATE TABLE table_1 (
  "squareplyid" VARCHAR,
  "reservationplyid" VARCHAR,
  "parcelplyid" VARCHAR,
  "taxlotsplyid" VARCHAR,
  "recordlotsplyid" VARCHAR,
  "account_id" VARCHAR,
  "recordation_dt" VARCHAR,
  "square" VARCHAR,
  "suffix" VARCHAR,
  "res" VARCHAR,
  "par" VARCHAR,
  "lot" VARCHAR,
  "lot_type" BIGINT,
  "of_lot_seq" DOUBLE,
  "is_theoretical_lot" DOUBLE,
  "is_rear_of" DOUBLE,
  "book_num" VARCHAR,
  "page_num" VARCHAR,
  "underlies_condo" DOUBLE,
  "condo_regime_num" VARCHAR,
  "condo_book_num" VARCHAR,
  "condo_page_num" VARCHAR,
  "record_area_sf" DOUBLE,
  "computed_area_sf" DOUBLE,
  "surveyed_area_sf" DOUBLE,
  "bldg_num" DOUBLE,
  "bldg_num_ext" VARCHAR,
  "bldg_num_end_range" VARCHAR,
  "bldg_ext_end_range" VARCHAR,
  "conv_tolerance_value" VARCHAR,
  "conv_tolerance_resolution" VARCHAR,
  "conv_tolerance_type" DOUBLE,
  "effectivetaxyear" VARCHAR,
  "quadrant" VARCHAR,
  "zip5" VARCHAR,
  "zip4" VARCHAR,
  "op_yn" VARCHAR,
  "col" VARCHAR,
  "ssl" VARCHAR,
  "arn" VARCHAR,
  "asrname" VARCHAR,
  "proptype" VARCHAR,
  "trigroup" VARCHAR,
  "usecode" DOUBLE,
  "landarea" DOUBLE,
  "prmsward" VARCHAR,
  "premiseadd" VARCHAR,
  "nbhd" DOUBLE,
  "nbhdname" VARCHAR,
  "subnbhd" VARCHAR,
  "unitnumber" VARCHAR,
  "ownername" VARCHAR,
  "careofname" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "citystzip" VARCHAR,
  "oldland" DOUBLE,
  "oldimpr" DOUBLE,
  "oldtotal" DOUBLE,
  "newland" DOUBLE,
  "newimpr" DOUBLE,
  "newtotal" DOUBLE,
  "phaseland" DOUBLE,
  "phasebuild" DOUBLE,
  "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" DOUBLE,
  "mix1lndpct" DOUBLE,
  "mix1lndval" DOUBLE,
  "mix1bldpct" DOUBLE,
  "mix1bldval" DOUBLE,
  "mix2txtype" VARCHAR,
  "mix2class" DOUBLE,
  "mix2rate" DOUBLE,
  "mix2lndpct" DOUBLE,
  "mix2lndval" DOUBLE,
  "mix2bldpct" DOUBLE,
  "mix2bldval" DOUBLE,
  "ownocct" DOUBLE,
  "coopunits" DOUBLE,
  "pchildcode" VARCHAR,
  "abtlotcode" VARCHAR,
  "saleprice" DOUBLE,
  "saledate" TIMESTAMP,
  "instno" VARCHAR,
  "acceptcode" VARCHAR,
  "saletype" VARCHAR,
  "mortgageco" VARCHAR,
  "assessment" DOUBLE,
  "annualtax" DOUBLE
);