Landmarks by US Government | Demographics and Population Studies

About this Dataset

Landmarks

Historic Landmarks listed in Article 10 of the Planning Code
Organization: City of San Francisco
Last updated: 2022-05-19T03:00:18.048625

Tables

Table 1

@usgov.city_of_san_francisco_landmarks_7c36d.table_1

220.04 KB
362 rows
36 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "landmarkno" DOUBLE,
  "address" VARCHAR,
  "yearbuilt" DOUBLE,
  "name" VARCHAR,
  "proptype" VARCHAR,
  "yeardes" DOUBLE,
  "desage" DOUBLE,
  "crit1" VARCHAR,
  "crit2" VARCHAR,
  "crit3" VARCHAR,
  "crit1txt" VARCHAR,
  "crit2txt" VARCHAR,
  "crit3txt" VARCHAR,
  "sigsum" VARCHAR,
  "context" VARCHAR,
  "style" VARCHAR,
  "archbuild" VARCHAR,
  "sigperson" VARCHAR,
  "ntlreg" VARCHAR,
  "doccontext" VARCHAR,
  "potcontext" VARCHAR,
  "legbus" VARCHAR,
  "culturaldist" VARCHAR,
  "potcultural" VARCHAR,
  "idencultural" VARCHAR,
  "culturalsum" VARCHAR,
  "cultural_1" VARCHAR,
  "rbrp" VARCHAR,
  "desdoc" VARCHAR,
  "pimlink" VARCHAR,
  "largephoto" VARCHAR,
  "thumbail" VARCHAR,
  "status" VARCHAR,
  "description" VARCHAR
);