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_RESERVATIONSRefresh Cycle: NightlyContact: SDOT Parking team

[
  "geospatial"
]