About this Dataset

Condo Approval Lots

Condo lots are individual lots for each condominium. The lot numbers normally range from 2000-6999. These condo lots are not geographically defined other than being within a air rights, record, tax or a combination of lots that has one or more condo buildings within it. A condo regime number is assigned to each residential Condo application or Article of Confederation regardless of how many buildings there are at any one site. The Regime number starts with a 1, 2, or 3 depending upon where the condo is located and where they fall in the tri-annual assessment process of RPTA. All numbers after the first are consecutive. RPTA maintains the master list of Regime numbers for residential properties. Commercial condos are not associated with a Regime number and in order to properly track all condos, a unique Regime number was created. RPTA then establishes individual accounts for each condominium unit and assigns a condo lot number to that account. RPTA maintains the master list of Regime numbers and their relationship to approved condos. There are roughly 66571 condo lots and there associations are as follows: 49486 condos were approved for record lots, 16867 were approved for tax lots, 2817 were approved for air rights lots, and 2600 were approved for both air rights and tax lots. The CondoPly layer was created to assist users in visualizing the relationship between ground surface lots (Record Lots), overlay lots (Air Rights & Tax Lots), and the associated Condos. When Condos are approved for ground lots, those lots remain in the production (active) layer and attributes updated to reflect the new condos. When Condos are approved for overlay lots, those lots are killed (dead lots) and archived to their respective history layer. Condo dwellings can also be queried city-wide via the individual VPM layers (active Record lots, dead Air Rights & Tax lots) where the value in the “UNDERLIES_CONDO” field is equal to 1.
Organization: District of Columbia
Last updated: 2024-04-30T19:16:51.959760
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_approval_lots.table_1

319.72 KB
4851 rows
43 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "creation_dt" TIMESTAMP,
  "recordation_dt" TIMESTAMP,
  "narrative" VARCHAR,
  "expiration_dt" VARCHAR,
  "status" BIGINT,
  "square" BIGINT,
  "suffix" VARCHAR,
  "lot" VARCHAR,
  "lot_type" BIGINT,
  "computed_area_sf" BIGINT,
  "surveyed_area_sf" VARCHAR,
  "mar_id" VARCHAR,
  "is_rear_of" VARCHAR,
  "bldg_num" VARCHAR,
  "bldg_num_ext" VARCHAR,
  "bldg_num_end_range" VARCHAR,
  "bldg_ext_end_range" VARCHAR,
  "quadrant" VARCHAR,
  "zip5" VARCHAR,
  "zip4" VARCHAR,
  "record_area_sf" DOUBLE,
  "conv_tolerance_type" DOUBLE,
  "conv_tolerance_value" VARCHAR,
  "conv_tolerance_resolution" VARCHAR,
  "recordlotsplyid" VARCHAR,
  "parcelsplyid" VARCHAR,
  "squareplyid" VARCHAR,
  "of_lot_seq" DOUBLE,
  "book_num" VARCHAR,
  "page_num" VARCHAR,
  "underlies_condo" BIGINT,
  "condo_book_num" VARCHAR,
  "condo_page_num" VARCHAR,
  "kill_dt" TIMESTAMP,
  "ssl" VARCHAR,
  "col" VARCHAR,
  "condolot" VARCHAR,
  "condo_regime_num" DOUBLE,
  "area" VARCHAR,
  "len" VARCHAR,
  "shape_length" DOUBLE,
  "shape_area" DOUBLE
);