Temporary No Parking

Description

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

Resources

Name Format Description Link
21 https://data-seattlecitygis.opendata.arcgis.com/maps/SeattleCityGIS::temporary-no-parking-1
23 https://services.arcgis.com/ZOyb2t4B0UYuYNYH/arcgis/rest/services/Temporary_No_Parking/FeatureServer

Tags

  • temporary-no-parking
  • sdot
  • parking
  • restrictions
  • gis
  • seattle-gis-open-data

Topics

  • Local Government

Categories