About this Dataset

Historic Landmark Elements

This dataset contains Historic Landmark Elements (by structure) officially designated by the District of Columbia. This is a consolidated collection of structures with historical significance within the District of Columbia as listed in the District of Columbia Inventory of Historic Sights. It contains the locations and attributes of buildings, statues, bridges, forts, fountains, memorials of historical worth. Additional datasets are available of Historic Districts. Note: This dataset differs from Historic Landmarks by creating individual records for each element of a landmark (eg. landmarks that include more than one building).
Organization: District of Columbia
Last updated: 2024-04-30T19:20:42.761050
Tags: district-of-columbia, historic, historic-buildings, historic-preservation, historic-structures, historical-designation, landuse, national-register, planning, washington-dc, zoning

Tables

Table 1

@usgov.district_of_columbia_historic_landmark_elements.table_1

122.36 kB
965 rows
20 columns

CREATE TABLE table_1 (
  "name" VARCHAR,
  "label" VARCHAR,
  "shortlabel" VARCHAR,
  "address" VARCHAR,
  "ssl" VARCHAR,
  "type" VARCHAR,
  "edit_date" TIMESTAMP,
  "uniqueid" VARCHAR,
  "hitype" VARCHAR,
  "htype" VARCHAR,
  "gis_id" VARCHAR,
  "orig_fid" BIGINT,
  "shapearea" BIGINT,
  "shapelen" BIGINT,
  "globalid" VARCHAR,
  "creator" VARCHAR,
  "created" VARCHAR,
  "editor" VARCHAR,
  "edited" VARCHAR,
  "objectid" BIGINT
);