About this Dataset

Condo Relate Table

The Condo Relate table contains attributes of air rights, record, and tax lots approved for active condos. Condominium documentation (Condo Book & Page) is approved and recorded by the DC's Surveyors Office (OS) for the DC's Department of Buildings (DOB) . Real Property Tax Administration's (RPTA) Maps & Title division receives copies of the approved Condominium documents from OS and reviews, records, and then ties the Condo book & page information to the Lot(s) of interest, i.e., (Air Rights, Record, Tax, or a combination) for the Office of Tax and Revenue (OTR).
Organization: District of Columbia
Last updated: 2024-07-03T03:09:01.761958
Tags: condo, condominium, dc, district-of-columbia, dob, land, lot, planning-cadastre, property, square, vpmdata, washington-dc

Tables

Table 1

@usgov.district_of_columbia_condo_relate_table_34fc9.table_1

8.53 MB
73450 rows
51 columns


CREATE TABLE table_1 (
  "ssl" VARCHAR,
  "regime" DOUBLE,
  "complex" VARCHAR,
  "name" VARCHAR,
  "rec_lot" VARCHAR,
  "under_rec" DOUBLE,
  "tax_lot" VARCHAR,
  "under_tax" DOUBLE,
  "condo_bk" VARCHAR,
  "condo_pg" VARCHAR,
  "rec_lot2" VARCHAR,
  "square" DOUBLE,
  "suffix" VARCHAR,
  "lot" BIGINT,
  "mat_ssl" VARCHAR,
  "act_lot" BIGINT,
  "regime_id" DOUBLE,
  "unitnum" VARCHAR,
  "doc_date" VARCHAR,
  "o_lots" VARCHAR,
  "bk_pg" VARCHAR,
  "unum_own" VARCHAR,
  "uid" DOUBLE,
  "marunitnum" VARCHAR,
  "air_lot" VARCHAR,
  "under_air" DOUBLE,
  "assessment" BIGINT,
  "oldtotal" BIGINT,
  "newtotal" BIGINT,
  "ownername" VARCHAR,
  "ownname2" VARCHAR,
  "careofname" VARCHAR,
  "address1" VARCHAR,
  "address2" VARCHAR,
  "citystzip" VARCHAR,
  "landarea" BIGINT,
  "hstdcode" DOUBLE,
  "cy1year" BIGINT,
  "capcurr" BIGINT,
  "phaseland" BIGINT,
  "phasebuild" BIGINT,
  "capprop" BIGINT,
  "newland" BIGINT,
  "newimpr" BIGINT,
  "saleprice" BIGINT,
  "saledate" TIMESTAMP,
  "acceptcode" VARCHAR,
  "vaclnduse" VARCHAR,
  "ward" VARCHAR,
  "mar_id" DOUBLE,
  "objectid" BIGINT
);