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 |
|---|---|---|---|
| CSV | CSV | Open resource | |
| Excel | XLS | Open resource | |
| Feature Collection | Text | Open resource | |
| File Geodatabase | ZIP | Open resource | |
| GeoJSON | GeoJSON | Open resource | |
| GeoPackage | Unknown | Open resource | |
| KML | KML | Open resource | |
| Shapefile | ZIP | Open resource | |
| SQLite Geodatabase | Unknown | Open resource | |
| ArcGIS Hub Dataset | HTML | Open resource | |
| ArcGIS GeoService | JSON | Open resource |