About this Dataset

Appropriations

U.S Appropriations are lands set aside at the time of the original founding and platting of the city for use by the U.S. Federal Government. The White House, for instance, Treasury Building, Ellipse and LaFayette Park all sit on Appropriation No. 1. D.C General Hospital is on Appropriation No.13 (with the consent of the Federal Government). Appropriations are often confused with U.S Reservations but the two terms are not interchangeable. There are 17 U.S Appropriations in Washington, D.C., all of which are located within the limits of the Original City and, by definition; there can never be any more.
Organization: District of Columbia
Last updated: 2024-04-30T18:26:51.868436
Tags: appropriations, dc, district-of-columbia, dob, land, lot, planning-cadastre, property, square, vpmdata, washington-dc

Tables

Table 1

@usgov.district_of_columbia_appropriations.table_1

22.66 kB
17 rows
35 columns

CREATE TABLE table_1 (
  "creation_dt" TIMESTAMP,
  "recordation_dt" TIMESTAMP,
  "narrative" VARCHAR,
  "expiration_dt" VARCHAR,
  "status" BIGINT,
  "square" VARCHAR,
  "suffix" BIGINT,
  "lot" BIGINT,
  "lot_type" BIGINT,
  "computed_area_sf" DOUBLE,
  "surveyed_area_sf" VARCHAR,
  "is_rear_of" VARCHAR,
  "bldg_num" VARCHAR,
  "bldg_num_ext" VARCHAR,
  "bldg_num_end_range" VARCHAR,
  "bldg_ext_end_range" VARCHAR,
  "street_name" VARCHAR,
  "street_type" VARCHAR,
  "quadrant" VARCHAR,
  "zip5" VARCHAR,
  "zip4" VARCHAR,
  "record_area_sf" BIGINT,
  "conv_tolerance_type" VARCHAR,
  "conv_tolerance_value" VARCHAR,
  "conv_tolerance_resolution" VARCHAR,
  "appropriationsplyid" VARCHAR,
  "parcelsplyid" VARCHAR,
  "squareplyid" VARCHAR,
  "kill_dt" VARCHAR,
  "ssl" VARCHAR,
  "col" VARCHAR,
  "shape_area" BIGINT  -- Shape, Area,
  "shape_length" BIGINT  -- Shape, Length,
  "mar_id" VARCHAR,
  "objectid" BIGINT
);