Name: Miscellaneous Structures
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Miscellaneous Structures

SDOT Miscellaneous Structures layer maintained by Seattle Department of Transportation.

Feature Class: V_MiscStructures

Refresh Cycle: Nightly

Contact: Asset Management team
Organization: City of Seattle
Last updated: 2025-02-28T23:48:32.110102
Tags: asset-management, gis, miscellaneous-structures, sdot, seattle-gis-open-data

Tables

Table 1

@usgov.city_of_seattle_miscellaneous_structures_08a80.table_1

39.96 KB
47 rows
52 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "se_anno_cad_data" VARCHAR,
  "compkey" BIGINT,
  "comptype" BIGINT,
  "segkey" BIGINT,
  "unitid" VARCHAR,
  "unittype" VARCHAR,
  "unitdesc" VARCHAR,
  "material" VARCHAR,
  "model_type" VARCHAR,
  "milepost" VARCHAR,
  "asset_height" BIGINT,
  "asblt" VARCHAR,
  "install_date" VARCHAR,
  "comments" VARCHAR,
  "category" VARCHAR,
  "style" VARCHAR,
  "current_status" VARCHAR,
  "current_status_date" VARCHAR,
  "condition" VARCHAR,
  "condition_assessment_date" VARCHAR,
  "ownership" VARCHAR,
  "ownership_date" VARCHAR,
  "addby" VARCHAR,
  "adddttm" VARCHAR,
  "modby" VARCHAR,
  "moddttm" VARCHAR,
  "maintained_by" VARCHAR,
  "last_asset_verification_date" VARCHAR,
  "maintenance_financial_resp" VARCHAR,
  "maintenance_agreement" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "overridecomment" VARCHAR,
  "log_comment_1" VARCHAR,
  "log_comment_2" VARCHAR,
  "log_comment_3" VARCHAR,
  "attachment_1" VARCHAR,
  "attachment_2" VARCHAR,
  "attachment_3" VARCHAR,
  "attachment_4" VARCHAR,
  "attachment_5" VARCHAR,
  "attachment_6" VARCHAR,
  "attachment_7" VARCHAR,
  "attachment_8" VARCHAR,
  "attachment_9" VARCHAR,
  "attachment_10" VARCHAR,
  "num_attachments" BIGINT,
  "date_mvw_last_updated" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);