About this Dataset

District Government Owned Structures

A layer showing the District of Columbia government related structures. The dataset contains polygons representing District Government related structures on Government property created as part of the DC Geographic Information System (DC GIS) for the D.C. Office of the Chief Technology Officer (OCTO) using the Department of Energy and Environment’s Unique Building Identifier (UBID) data. 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). The UBID data was originally created by spatially joining the 2019 building footprints published in DC Open Data with the Common Ownership Lots. The UBIDs were coded using US DOE’s Implementation code. Search for UBID and ITSPE in Open Data DC for individual documentation.
Organization: District of Columbia
Last updated: 2024-04-30T19:02:54.614601
Tags: ddoe, district-of-columbia, itspe, ocfo, property, public-extract, structures, tax-assessment, ubid, washington-dc

Tables

Table 1

@usgov.district_of_columbia_district_government_owned_structures.table_1

495.54 KB
5310 rows
33 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "square" VARCHAR,
  "suffix" VARCHAR,
  "res" VARCHAR,
  "par" VARCHAR,
  "lot" VARCHAR,
  "condo_regime" VARCHAR,
  "ssl" VARCHAR,
  "description" VARCHAR,
  "captureyear" TIMESTAMP,
  "captureaction" VARCHAR,
  "area_new" DOUBLE,
  "centroidx" DOUBLE,
  "centroidy" DOUBLE,
  "minlat" DOUBLE,
  "maxlat" DOUBLE,
  "minlong" DOUBLE,
  "maxlong" DOUBLE,
  "nssl" BIGINT,
  "ubid" VARCHAR,
  "nubid" BIGINT,
  "link_type" BIGINT,
  "link_type_description" VARCHAR,
  "gis_id" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "ward" BIGINT,
  "globalid" VARCHAR,
  "shape_length" DOUBLE,
  "shape_area" DOUBLE
);