Water System Maintenance Pipe Repair Report from 1/1/24 to Present. Each line represents a pipe repair completed by Water System Maintenance crews. The data set reports by material and date of repair. This information is pulled from the Work Asset Management system daily.
This dataset has the following 13 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| WORK ORDER NO | work_order_no | number | 2147313 2253138 2346559 1823116 2250635 view top 100 |
| TASK NO | work_order_task_no | number | 1 2 3 4 5 view top 100 |
| TASK DESC | task_desc | text | 08-02-01790 1938 ALMERIA WAY S, CHECK SERVICE LEAKCHECK SERVICE LEAK, 1' E. OF DR 18' FROM CURB, CLASS: SNGL FMLY RSDNTIAL, CYCLE/ROUTE: 8/2, METER#: 19045493, MAKE: B BADGER, SIZE: 005 5/8 X 3/4 INCH 18-01-03210 6510 BAYOU GRANDE BLVD NE, CHECK SERVICE LEAKCHECK SERVICE LEAK, , CLASS: SNGL FMLY RSDNTIAL, CYCLE/ROUTE: 18/1, METER#: 15963521, MAKE: B BADGER, SIZE: 005 5/8 X 3/4 INCH 10-02-01810 619 52ND ST N, CHECK SERVICE LEAKCHECK SERVICE LEAK, , CLASS: SNGL FMLY RSDNTIAL, CYCLE/ROUTE: 10/2, METER#: 19123155, MAKE: B BADGER, SIZE: 005 5/8 X 3/4 INCH 08-03-00800 6230 3RD ST S, CHECK SERVICE LEAKCHECK SERVICE LEAK, , CLASS: SNGL FMLY RSDNTIAL, CYCLE/ROUTE: 8/3, METER#: 18808562, MAKE: B BADGER, SIZE: 005 5/8 X 3/4 INCH 08-02-04390 1817 LAKEWOOD DR S, CHECK SERVICE LEAKCHECK SERVICE LEAK, , CLASS: SNGL FMLY RSDNTIAL, CYCLE/ROUTE: 8/2, METER#: 76424908, MAKE: T TRIDENT, SIZE: 005 5/8 X 3/4 INCH view top 100 |
| CREATION DATE | creation_date | calendar_date | 2017-07-10T00:00:00.000 2018-10-17T00:00:00.000 2021-01-05T00:00:00.000 2021-08-27T00:00:00.000 2021-04-27T00:00:00.000 view top 100 |
| TASK STATUS | task_status | text | CLOSED FINISHED view top 100 |
| ASSET ID | asset_id | text | 0000059629 0000059181 0000055931 0000052212 0000118749 view top 100 |
| ASSET DESC | asset_desc | text | PIPE, POTABLE WATER, 2 IN, MAT: GP PIPE, POTABLE WATER, 2 INCH, MATERIAL: GP, TYPE: SUPPLY PIPE, POTABLE WATER, 6 IN, MAT: CAS PIPE, POTABLE WATER, 2 IN, MAT: PVC PIPE, POTABLE WATER, 8 IN, MAT: CAS view top 100 |
| ACTUAL FINISH DATE | actual_finish_date | calendar_date | 2018-01-08T00:00:00.000 2020-12-11T00:00:00.000 2022-12-27T00:00:00.000 2020-12-22T00:00:00.000 2023-01-20T00:00:00.000 view top 100 |
| CREW | crew | text | WSM9 WSM12 WSM1 WSM8 WSM2 view top 100 |
| ASSET TYPE | asset_type | text | METER PIPE RCWSERVICE BACKFLOW VALVE view top 100 |
| WORK CLASS | work_class | text | WTR SVC WTR MAIN RCW SVC FIRE SVC RCW MAIN view top 100 |
| WORK CATEGORY | work_category | text | LEAK REPR LEAK HS view top 100 |
| MATERIAL | material | text | OTHER GALVANIZED PIPE CAST IRON PLASTIC DUCTILE IRON PIPE view top 100 |