About this Dataset

SDOT Pay Stations

Display the locations of Paid Parking Kiosks that distribute a receipt that is displayed in vehicle for mapping purposes.

Refresh Cycle: Daily Refresh

Feature Class: SDOT.V_PAYSTATIONS

Pay Station Definition Query:

To view the INSVC, or PLNRECON, or ' ' status, use

CURRENT_STATUS = 'INSVC' OR CURRENT_STATUS ='PLNRECON' OR CURRENT_STATUS = ' '
Organization: City of Seattle
Last updated: 2025-02-28T23:51:58.613260
Tags: parking, pay, sdot, seattle-gis-open-data, station, transportation

Tables

Table 1

@usgov.city_of_seattle_sdot_pay_stations.table_1

284.41 KB
1635 rows
70 columns


CREATE TABLE table_1 (
  "objectid" BIGINT,
  "compkey" BIGINT,
  "unitid" VARCHAR,
  "unitdesc" VARCHAR,
  "condition" VARCHAR,
  "ownership" VARCHAR,
  "current_status" VARCHAR,
  "primarydistrictcd" VARCHAR,
  "secondarydistrictcd" VARCHAR,
  "overrideyn" VARCHAR,
  "elmntkey" BIGINT,
  "comptype" BIGINT,
  "segkey" BIGINT,
  "distance" DOUBLE,
  "width" DOUBLE,
  "unittype" VARCHAR,
  "measdist" DOUBLE,
  "receipt_nbr" VARCHAR,
  "pandd_nbr" BIGINT,
  "pandd_nbr_start" BIGINT,
  "paidarea" VARCHAR,
  "subarea" VARCHAR,
  "side" VARCHAR,
  "perso_nbr" VARCHAR,
  "ps_configuration" VARCHAR,
  "pay_by_phone" DOUBLE,
  "wireless_carrier" VARCHAR,
  "modem" VARCHAR,
  "model" VARCHAR,
  "card_reader" VARCHAR,
  "category" VARCHAR,
  "overridecomment" VARCHAR,
  "wkd_rate1" DOUBLE,
  "wkd_start1" BIGINT,
  "wkd_end1" BIGINT,
  "wkd_rate2" DOUBLE,
  "wkd_start2" BIGINT,
  "wkd_end2" BIGINT,
  "wkd_rate3" DOUBLE,
  "wkd_start3" DOUBLE,
  "wkd_end3" DOUBLE,
  "sat_rate1" DOUBLE,
  "sat_start1" DOUBLE,
  "sat_end1" DOUBLE,
  "sat_rate2" DOUBLE,
  "sat_start2" DOUBLE,
  "sat_end2" DOUBLE,
  "sat_rate3" DOUBLE,
  "sat_start3" DOUBLE,
  "sat_end3" DOUBLE,
  "sun_rate1" DOUBLE,
  "sun_start1" DOUBLE,
  "sun_end1" DOUBLE,
  "sun_rate2" DOUBLE,
  "sun_start2" DOUBLE,
  "sun_end2" DOUBLE,
  "sun_rate3" DOUBLE,
  "sun_start3" DOUBLE,
  "sun_end3" DOUBLE,
  "start_time_wkd" VARCHAR,
  "end_time_wkd" VARCHAR,
  "start_time_sat" VARCHAR,
  "end_time_sat" VARCHAR,
  "start_time_sun" VARCHAR,
  "end_time_sun" VARCHAR,
  "peak_hour" VARCHAR,
  "shape_lng" DOUBLE,
  "shape_lat" DOUBLE,
  "x" DOUBLE,
  "y" DOUBLE
);