SPU CIP Workorders by US Government | Finance and Economics

About this Dataset

SPU CIP Workorders

For use in SPU CIP App, as well as DotMaps.

Data refreshed daily.
Organization: City of Seattle
Last updated: 2025-02-28T23:20:44.325533
Tags: capital-improvement-projects, cdl, cip, projects, seattle-gis-open-data, spu, utility

Tables

Table 1

@usgov.city_of_seattle_spu_cip_workorders.table_1

473.54 KB
4834 rows
20 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "agency" VARCHAR,
  "project_status" VARCHAR,
  "project_type" VARCHAR,
  "project_id" VARCHAR,
  "project_name" VARCHAR,
  "project_description" VARCHAR,
  "project_manager" VARCHAR,
  "project_manager_phone_number" VARCHAR,
  "project_manager_email_address" VARCHAR,
  "agency_reference" VARCHAR,
  "budget_id" VARCHAR,
  "project_funded" VARCHAR,
  "construction_start" VARCHAR,
  "construction_end" VARCHAR,
  "sdot_street_compkey" BIGINT,
  "cip_purpose" VARCHAR,
  "globalid" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);