About this Dataset

Temporary No Parking Reservations (All)

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:30:29.642850
Tags: gis, parking, restrictions, sdot, seattle-gis-open-data, temporary-no-parking

Tables

Table 1

@usgov.city_of_seattle_temporary_no_parking_reservations_all.table_1

1.11 MB
56189 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" VARCHAR,
  "curbspace_number_also_known_as_meter_space_id" VARCHAR,
  "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
);