Data catalog / raw / cityworks_workorder
raw.cityworks_workorder
Work orders. 22,545 rows.
LayerRaw
Source systemCityworks
Data ownerPublic Works Director
Data stewardElena Ruiz
ClassificationInternal
RefreshNightly
RetentionAll versions, 7 years
AccessRoles R1 to R5, row policy P-01
Lineage
Columns
| Column | Type | Classification |
|---|---|---|
wo_id | text | |
category | text | |
dept_code | text | |
sr_id | text | |
asset_id | text | |
parcel_id | text | |
lat | double precision | |
lon | double precision | |
created_at | timestamp without time zone | |
completed_at | timestamp without time zone | |
status | text | |
modified_at | timestamp without time zone | |
_run_id | text | Load metadata |
_extracted_at | timestamp without time zone | Load metadata |
Quality rules
DQ-301 Block Work order completed on or after creation
Validity
DQ-302 Warn Service request link resolves to a 311 request
Referential
Sample rows
| wo_id | category | dept_code | sr_id | asset_id | parcel_id | lat | lon | created_at | completed_at | status | modified_at | _run_id | _extracted_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| WO-432168 | Mowing right of way | PW | AS-94067 | FBCAD-732798 | 29.591785 | -95.696942 | 2026-11-04 12:45:00 | 2026-11-10 08:37:11.144209 | Closed | 2026-11-10 08:37:11.144209 | R-20261111-0200 | 2026-11-11 02:04:25 | |
| WO-432188 | Sidewalk repair | PW | AS-71129 | FBCAD-576376 | 29.617142 | -95.673963 | 2026-11-04 18:58:00 | 2026-11-10 03:30:39.286945 | Closed | 2026-11-10 03:30:39.286945 | R-20261111-0200 | 2026-11-11 02:04:25 | |
| WO-431898 | Streetlight repair | PW | SR-26029540 | AS-10762 | FBCAD-806705 | 29.54951494106243 | -95.66315809814898 | 2026-10-30 19:14:00 | 2026-11-10 03:57:14.434823 | Closed | 2026-11-10 03:57:14.434823 | R-20261111-0200 | 2026-11-11 02:04:25 |
| WO-432154 | Sign replacement | PW | AS-64247 | FBCAD-672952 | 29.592062 | -95.69322 | 2026-11-04 09:41:00 | 2026-11-10 13:42:33.893641 | Closed | 2026-11-10 13:42:33.893641 | R-20261111-0200 | 2026-11-11 02:04:25 | |
| WO-432199 | Streetlight repair | PW | SR-26029943 | AS-77222 | FBCAD-130468 | 29.6023896360712 | -95.6585392454318 | 2026-11-05 07:08:00 | 2026-11-10 11:56:16.398120 | Closed | 2026-11-10 11:56:16.398120 | R-20261111-0200 | 2026-11-11 02:04:25 |
Data as of run R-20261111-0200, finished 11/11/2026 02:13 Central. Curated layer: curated schema.