Reservations (Historical) by US Government | Finance and Economics

About this Dataset

Reservations (Historical)

U.S. Reservations are lands acquired for use by the Federal Government after the original founding of the city. These were all acquired by the Federal Government through purchase, condemnation, dedication or gift and almost all of the U.S. Reservations in Washington are under the Jurisdiction of the National Park Service. Unlike Appropriations, U.S. Reservations are found throughout the city. The National Park Service also has information for every U.S. Reservation and Appropriation in addition to DCRA Office of the Surveyor having some detailed information on transactional history. It should be noted that RPTA has converted some reservations to tax lots for land tracking purposes however the federal government still maintains ownership in many of these cases.
Organization: District of Columbia
Last updated: 2024-04-30T18:29:07.727104
Tags: acquisitions, cadastral, district-of-columbia, historic, national-park-service, nps, properties, recreation, reservations-history, vector-property, vpmdata, washington-dc

Tables

Table 1

@usgov.district_of_columbia_reservations_historical.table_1

29.84 KB
91 rows
36 columns


CREATE TABLE table_1 (
  "creation_dt" TIMESTAMP,
  "recordation_dt" TIMESTAMP,
  "narrative" VARCHAR,
  "expiration_dt" VARCHAR,
  "status" BIGINT,
  "square" BIGINT,
  "suffix" VARCHAR,
  "lot" BIGINT,
  "lot_type" BIGINT,
  "computed_area_sf" BIGINT,
  "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" DOUBLE,
  "conv_tolerance_type" DOUBLE,
  "conv_tolerance_value" VARCHAR,
  "conv_tolerance_resolution" VARCHAR,
  "reservationsplyid" VARCHAR,
  "parcelsplyid" VARCHAR,
  "squareplyid" VARCHAR,
  "kill_dt" VARCHAR,
  "ssl" VARCHAR,
  "col" VARCHAR,
  "res" VARCHAR,
  "shape_area" BIGINT,
  "shape_length" BIGINT,
  "mar_id" VARCHAR,
  "objectid" BIGINT
);