About this Dataset

Pothole Status

Pothole Status layer is a layer that provides work management data from INFOR/Hansen regarding Pot Hole status data. Maintained by Seattle Department of Transportation.

Feature Class: WM_POTHOLESTATUS

Refresh Cycle: Daily

Contact: Street Maintenance team
Organization: City of Seattle
Last updated: 2025-02-28T23:45:21.545394
Tags: gis, pothole, sdot, seattle-gis-open-data, street-maintenance, work-management

Tables

Table 1

@usgov.city_of_seattle_pothole_status.table_1

12.25 MB
98424 rows
58 columns


CREATE TABLE table_1 (
  "n__objectid" VARCHAR,
  "wokey" VARCHAR,
  "wo_status" VARCHAR,
  "resultcd" VARCHAR,
  "resultdesc" VARCHAR,
  "last90dayrprd" DOUBLE,
  "byduedt" DOUBLE,
  "notpothole" VARCHAR,
  "totalrprd" DOUBLE,
  "current_qtr" VARCHAR,
  "previous_1qtr" VARCHAR,
  "previous_2qtr" VARCHAR,
  "previous_3qtr" VARCHAR,
  "previous_4qtr" VARCHAR,
  "sourcecd" VARCHAR,
  "milestonecd" VARCHAR,
  "problemcd" VARCHAR,
  "prioritycd" VARCHAR,
  "assigned" VARCHAR,
  "assigneddiv" VARCHAR,
  "assignedlo" VARCHAR,
  "crewchief" VARCHAR,
  "crewchiefdiv" VARCHAR,
  "initdt" VARCHAR,
  "schedstartdt" VARCHAR,
  "duedt" VARCHAR,
  "fldstartdt" VARCHAR,
  "fldenddt" VARCHAR,
  "compdt" VARCHAR,
  "citysectorcd" VARCHAR,
  "neighcd" VARCHAR,
  "location" VARCHAR,
  "addrdesc" VARCHAR,
  "addrtype" VARCHAR,
  "addrkey" DOUBLE,
  "compkey" DOUBLE,
  "maplockey" DOUBLE,
  "segkey" DOUBLE,
  "distance" DOUBLE,
  "workorderdetkey" DOUBLE,
  "wo_addby" VARCHAR,
  "wo_modby" VARCHAR,
  "workactivitycd" VARCHAR,
  "workactivitydesc" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "pmsurface1" VARCHAR,
  "pmsurfdate1" VARCHAR,
  "pvmtcondindx1" DOUBLE,
  "pmsurface2" VARCHAR,
  "pmsurfdate2" VARCHAR,
  "pvmtcondindx2" DOUBLE,
  "artclass" DOUBLE,
  "speedlimit" DOUBLE,
  "sgndbkroute" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "x" DOUBLE,
  "y" DOUBLE
);