StreetStructures by US Government | Technology and IT

About this Dataset

StreetStructures

Structures in the right-of-way, maintained by Public Works. Includes Barriers; Retaining Walls; Stairs; Bridges; Tunnels, Overpasses; Pedestrian Overpasses; Ramps; Trestles; Viaducts; and other types of structures.
Organization: City of San Francisco
Last updated: 2024-01-12T15:05:50.426246

Tables

Table 1

@usgov.city_of_san_francisco_streetstructures_82a15.table_1

99.66 KB
417 rows
15 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "the_geom" VARCHAR,
  "struct_lin" BIGINT,
  "struct_id2" VARCHAR,
  "str_name" VARCHAR,
  "str_make" VARCHAR,
  "x_coord" DOUBLE,
  "y_coord" DOUBLE,
  "small_key" VARCHAR,
  "medium_key" VARCHAR,
  "large_key" VARCHAR,
  "streetname" VARCHAR,
  "crossst1" VARCHAR,
  "crossst2" VARCHAR,
  "shape_len" DOUBLE
);