About this Dataset

Temporary No Parking Reservations (Past, Current, And Future)

Temporary No Parking Reservations layer is maintained by Seattle Department of Transportation. Due to the complex definition queries, source aprx required layers with definition queries to be exported as FGDB and then published.

Definition Queries applied to the following layers:

Temporary No Parking Reservations (Current)
((ACTUAL_START_TIME IS NULL AND ACTUAL_END_TIME IS NULL) AND (TRUNC (END_DATE_TIME ) >= TRUNC (SYSDATE) AND TRUNC (START_DATE_TIME) <= TRUNC (SYSDATE)))
OR
((ACTUAL_START_TIME IS NULL AND ACTUAL_END_TIME IS NOT NULL) AND (TRUNC (ACTUAL_END_TIME) >= TRUNC (SYSDATE) AND TRUNC (START_DATE_TIME) <= TRUNC (SYSDATE)))
OR
((ACTUAL_START_TIME IS NOT NULL AND ACTUAL_END_TIME IS NULL) AND (TRUNC (END_DATE_TIME) >= TRUNC (SYSDATE) AND TRUNC (ACTUAL_START_TIME) <= TRUNC (SYSDATE)))
OR
((ACTUAL_START_TIME IS NOT NULL AND ACTUAL_END_TIME IS NOT NULL) AND (TRUNC (ACTUAL_END_TIME) >= TRUNC (SYSDATE) AND TRUNC (ACTUAL_START_TIME) <= TRUNC (SYSDATE)))
Temporary No Parking Reservations (Past, Current, and Future)
((ACTUAL_START_TIME IS NULL AND ACTUAL_END_TIME IS NULL) AND (TRUNC (END_DATE_TIME ) >= TRUNC (SYSDATE) - 15 AND TRUNC (START_DATE_TIME) <= TRUNC (SYSDATE) + 30))
OR
((ACTUAL_START_TIME IS NULL AND ACTUAL_END_TIME IS NOT NULL) AND (TRUNC (ACTUAL_END_TIME) >= TRUNC (SYSDATE) - 15 AND TRUNC (START_DATE_TIME) <= TRUNC (SYSDATE) + 30))
OR
((ACTUAL_START_TIME IS NOT NULL AND ACTUAL_END_TIME IS NULL) AND (TRUNC (END_DATE_TIME) >= TRUNC (SYSDATE) - 15 AND TRUNC (ACTUAL_START_TIME) <= TRUNC (SYSDATE) + 30))
OR
((ACTUAL_START_TIME IS NOT NULL AND ACTUAL_END_TIME IS NOT NULL) AND (TRUNC (ACTUAL_END_TIME) >= TRUNC (SYSDATE) - 15 AND TRUNC (ACTUAL_START_TIME) <= TRUNC (SYSDATE) + 30))

Feature Class: V_TEMP_NOPARK_RESERVATIONS

Refresh Cycle: Nightly

Contact: SDOT Parking team
Organization: City of Seattle
Last updated: 2025-02-28T23:40:37.072369
Tags: gis, parking, restrictions, sdot, seattle-gis-open-data, temporary-no-parking

Tables

Table 1

@usgov.city_of_seattle_temporary_no_parking_reservations_past_99743e3f.table_1

92.52 kB
2,578 rows
17 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "date_time_of_record_creation" VARCHAR,
  "date_time_of_record_modification" VARCHAR,
  "temporary_no_park_record_id" VARCHAR,
  "full_name_of_contact" VARCHAR,
  "phone_number_of_contact" DOUBLE,
  "curbspace_number_also_known_as_meter_space_id" VARCHAR  -- Curbspace Number (also Known As Meter Space ID),
  "blockface_element_key" BIGINT,
  "no_parking_sign_type" VARCHAR,
  "start_date_time" VARCHAR,
  "date_time_of_temporary_no_park_end" VARCHAR,
  "actual_date_time_of_temporary_no_park_start" VARCHAR,
  "actual_date_time_of_temporary_no_park_end" VARCHAR,
  "se_anno_cad_data" VARCHAR,
  "record_status" VARCHAR,
  "publicnoticepostdatetime" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length
);