Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table workorder
(
  wonum                  varchar2(10 char)      not null,
  parent                 varchar2(10 char),
  hierarchypath          varchar2(254 char),
  classstructureid       varchar2(20 char),
  division               varchar2(25 char),
  worktype               varchar2(16 char),
  status                 varchar2(16 char)      not null,
  actstart               date,
  actfinish              date,
  actlabcost             number(10,2)           not null,
  actmatcost             number(10,2)           not null,
  actservcost            number(10,2)           not null,
  acttoolcost            number(10,2)           not null,
  acttotalcost           number(10,2)           not null  
)
insert into workorder (wonum, parent, hierarchypath, classstructureid, worktype, status, actstart, actfinish, actlabcost, actmatcost, actservcost, acttoolcost, acttotalcost)

with cte as (

select 'WO37342' as wonum, 'WO43181' as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, null as division, 
       'EM' as worktype, 'CLOSE' as status, to_date('11/07/2020 4:13:00 PM', 'MM/DD/YYYY HH:MI:SS AM') as actstart, to_date('11/08/2020 4:13:00 PM', 'MM/DD/YYYY HH:MI:SS AM') as actfinish, 1090.32 as actlabcost, 
       1300.01 as actmatcost, 0 as actservcost, 0 as acttoolcost, 2390.33 as acttotalcost
from dual
union all
select 'WO43178' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, null as division, 
       'EM' as worktype, 'CLOSE' as status, to_date('11/08/2020 2:53:55 PM', 'MM/DD/YYYY HH:MI:SS AM') as actstart, to_date('11/08/2020 3:15:30 PM', 'MM/DD/YYYY HH:MI:SS AM') as actfinish, 198.24 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 198.24 as acttotalcost
from dual
union all
select 'WO43181' as wonum, null as parent, 'ROADS \ WINTER' as hierarchypath, '60720' as classstructureid, null as division, 
       'EM' as worktype, 'WAPPR' as status, to_date('10/26/2020 5:38:00 PM', 'MM/DD/YYYY HH:MI:SS AM') as actstart, to_date('11/08/2020 5:39:00 PM', 'MM/DD/YYYY HH:MI:SS AM') as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43182' as wonum, 'WO43181' as parent, 'ROADS \ WINTER \ SNOW FENCE' as hierarchypath, '60830' as classstructureid, null as division, 
       'EM' as worktype, 'WAPPR' as status, to_date('10/29/2020 5:38:00 PM', 'MM/DD/YYYY HH:MI:SS AM') as actstart, to_date('11/09/2020 5:38:00 PM', 'MM/DD/YYYY HH:MI:SS AM') as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43183' as wonum, 'WO43181' as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ ARTERIAL/COLLECTOR' as hierarchypath, '60760' as classstructureid, 'ROADS' as division, 
       'EM' as worktype, 'INPRG' as status, to_date('11/08/2020 7:29:29 PM', 'MM/DD/YYYY HH:MI:SS AM') as actstart, to_date('11/09/2020 5:40:00 PM', 'MM/DD/YYYY HH:MI:SS AM') as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43909' as wonum, null as parent, 'ROADS \ WINTER \ ANTI-ICING' as hierarchypath, '60740' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43910' as wonum, null as parent, 'ROADS \ WINTER \ ANTI-ICING' as hierarchypath, '60740' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43911' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING' as hierarchypath, '60750' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43912' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING' as hierarchypath, '60750' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43913' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ ARTERIAL/COLLECTOR' as hierarchypath, '60760' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43914' as wonum, 'WO43911' as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ ARTERIAL/COLLECTOR' as hierarchypath, '60760' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43915' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43916' as wonum, 'WO43911' as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43917' as wonum, 'WO43911' as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43918' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43919' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43920' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43921' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43922' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43923' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43924' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43925' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43926' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43927' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43928' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43929' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43930' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43931' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43932' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43933' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43934' as wonum, null as parent, 'ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL' as hierarchypath, '60770' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43935' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43936' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43937' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43938' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43939' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43940' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43941' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43942' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43943' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43944' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43945' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43946' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43947' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43948' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43949' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43950' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43951' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43952' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43953' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43954' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43955' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43956' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43957' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43958' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43959' as wonum, null as parent, 'ROADS \ WINTER \ MISCELLANEOUS' as hierarchypath, '60850' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43960' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43961' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43962' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43963' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43964' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43965' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43966' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43967' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43968' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43969' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43970' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43971' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43972' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43973' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43974' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43975' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43976' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43977' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43978' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43979' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43980' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43981' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43982' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43983' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43984' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43985' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43986' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43987' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43988' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43989' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43990' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43991' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43992' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43993' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43994' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43995' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43996' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43997' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43998' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO43999' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44000' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44001' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44002' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44003' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44004' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44005' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44006' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44007' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44008' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44009' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44010' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL' as hierarchypath, '60800' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44011' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL' as hierarchypath, '60800' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44012' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL' as hierarchypath, '60800' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44013' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL' as hierarchypath, '60800' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44014' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL' as hierarchypath, '60800' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44015' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL' as hierarchypath, '60800' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44016' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL' as hierarchypath, '60800' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44017' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL' as hierarchypath, '60800' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44018' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL' as hierarchypath, '60800' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44019' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL' as hierarchypath, '60800' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44020' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL' as hierarchypath, '60810' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44021' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL' as hierarchypath, '60810' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44022' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL' as hierarchypath, '60810' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44023' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL' as hierarchypath, '60810' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44024' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL' as hierarchypath, '60810' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44025' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44026' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44027' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44028' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44029' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44030' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44031' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44032' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44033' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44034' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44035' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44036' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44037' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44038' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44039' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44040' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44041' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44042' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44043' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44044' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44045' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44046' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44047' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44048' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44049' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44050' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44051' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44052' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44053' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44054' as wonum, null as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS' as hierarchypath, '60820' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44055' as wonum, null as parent, 'ROADS \ WINTER \ SNOW FENCE' as hierarchypath, '60830' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44056' as wonum, null as parent, 'ROADS \ WINTER \ SNOW FENCE' as hierarchypath, '60830' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44057' as wonum, null as parent, 'ROADS \ WINTER \ SNOW FENCE' as hierarchypath, '60830' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44058' as wonum, null as parent, 'ROADS \ WINTER \ SNOW FENCE' as hierarchypath, '60830' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44059' as wonum, null as parent, 'ROADS \ WINTER \ SNOW FENCE' as hierarchypath, '60830' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44060' as wonum, null as parent, 'ROADS \ WINTER \ SNOW FENCE' as hierarchypath, '60830' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44061' as wonum, null as parent, 'ROADS \ WINTER \ SNOW FENCE' as hierarchypath, '60830' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44062' as wonum, null as parent, 'ROADS \ WINTER \ SNOW FENCE' as hierarchypath, '60830' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44063' as wonum, null as parent, 'ROADS \ WINTER \ SNOW FENCE' as hierarchypath, '60830' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44064' as wonum, null as parent, 'ROADS \ WINTER \ SNOW FENCE' as hierarchypath, '60830' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44065' as wonum, null as parent, 'ROADS \ WINTER \ SNOW REMOVAL' as hierarchypath, '60840' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44066' as wonum, null as parent, 'ROADS \ WINTER \ SNOW REMOVAL' as hierarchypath, '60840' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44067' as wonum, null as parent, 'ROADS \ WINTER \ SNOW REMOVAL' as hierarchypath, '60840' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44068' as wonum, null as parent, 'ROADS \ WINTER \ SNOW REMOVAL' as hierarchypath, '60840' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44069' as wonum, null as parent, 'ROADS \ WINTER \ SNOW REMOVAL' as hierarchypath, '60840' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44070' as wonum, null as parent, 'ROADS \ WINTER \ SNOW REMOVAL' as hierarchypath, '60840' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44071' as wonum, null as parent, 'ROADS \ WINTER \ SNOW REMOVAL' as hierarchypath, '60840' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44072' as wonum, null as parent, 'ROADS \ WINTER \ SNOW REMOVAL' as hierarchypath, '60840' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44073' as wonum, null as parent, 'ROADS \ WINTER \ SNOW REMOVAL' as hierarchypath, '60840' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44074' as wonum, null as parent, 'ROADS \ WINTER \ SNOW REMOVAL' as hierarchypath, '60840' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44075' as wonum, null as parent, 'ROADS \ WINTER \ WINTER STORM EVENT' as hierarchypath, '60730' as classstructureid, 'ROADS' as division, 
       'CM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44512' as wonum, null as parent, 'ROADS \ WINTER' as hierarchypath, '60720' as classstructureid, 'ROADS' as division, 
       'EM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44513' as wonum, 'WO44512' as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING' as hierarchypath, '60790' as classstructureid, 'TRAFFICENG/OPS' as division, 
       'EM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44514' as wonum, 'WO44512' as parent, 'ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL' as hierarchypath, '60800' as classstructureid, 'TRAFFICENG/OPS' as division, 
       'EM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
union all
select 'WO44905' as wonum, null as parent, 'ROADS \ WINTER' as hierarchypath, '60720' as classstructureid, null as division, 
       'EM' as worktype, 'WAPPR' as status, cast(null as date) as actstart, cast(null as date) as actfinish, 0 as actlabcost, 
       0 as actmatcost, 0 as actservcost, 0 as acttoolcost, 0 as acttotalcost
from dual
)


select
    wonum, parent, hierarchypath, classstructureid, worktype, 
    status, actstart, actfinish, actlabcost, actmatcost, 
    actservcost, acttoolcost, acttotalcost
from
    cte;
176 rows affected

create table classancestor
(
  classancestorid   number(38,10)               not null,
  classstructureid  nvarchar2(20),
  classificationid  nvarchar2(192),
  ancestor          nvarchar2(20),
  ancestorclassid   nvarchar2(192),
  hierarchylevels   number(38,10)
)
insert into classancestor (classancestorid, classstructureid, classificationid, ancestor, ancestorclassid, hierarchylevels)

with cte as (

select 12214 as classancestorid, '60720' as classstructureid, 'WINTER' as classificationid, '60000' as ancestor, 'ROADS' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12213 as classancestorid, '60720' as classstructureid, 'WINTER' as classificationid, '60720' as ancestor, 'WINTER' as ancestorclassid, 
       0 as hierarchylevels
from dual
union all
select 12234 as classancestorid, '60780' as classstructureid, 'SIDEWALK CLEARING' as classificationid, '60000' as ancestor, 'ROADS' as ancestorclassid, 
       2 as hierarchylevels
from dual
union all
select 12233 as classancestorid, '60780' as classstructureid, 'SIDEWALK CLEARING' as classificationid, '60720' as ancestor, 'WINTER' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12232 as classancestorid, '60780' as classstructureid, 'SIDEWALK CLEARING' as classificationid, '60780' as ancestor, 'SIDEWALK CLEARING' as ancestorclassid, 
       0 as hierarchylevels
from dual
union all
select 12256 as classancestorid, '60840' as classstructureid, 'snow removal' as classificationid, '60000' as ancestor, 'roads' as ancestorclassid, 
       2 as hierarchylevels
from dual
union all
select 12255 as classancestorid, '60840' as classstructureid, 'snow removal' as classificationid, '60720' as ancestor, 'winter' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12254 as classancestorid, '60840' as classstructureid, 'snow removal' as classificationid, '60840' as ancestor, 'snow removal' as ancestorclassid, 
       0 as hierarchylevels
from dual
union all
select 12220 as classancestorid, '60740' as classstructureid, 'anti-icing' as classificationid, '60000' as ancestor, 'roads' as ancestorclassid, 
       2 as hierarchylevels
from dual
union all
select 12219 as classancestorid, '60740' as classstructureid, 'anti-icing' as classificationid, '60720' as ancestor, 'winter' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12218 as classancestorid, '60740' as classstructureid, 'anti-icing' as classificationid, '60740' as ancestor, 'anti-icing' as ancestorclassid, 
       0 as hierarchylevels
from dual
union all
select 12227 as classancestorid, '60760' as classstructureid, 'arterial/collector' as classificationid, '60000' as ancestor, 'roads' as ancestorclassid, 
       3 as hierarchylevels
from dual
union all
select 12226 as classancestorid, '60760' as classstructureid, 'arterial/collector' as classificationid, '60720' as ancestor, 'winter' as ancestorclassid, 
       2 as hierarchylevels
from dual
union all
select 12225 as classancestorid, '60760' as classstructureid, 'arterial/collector' as classificationid, '60750' as ancestor, 'city road clearing' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12224 as classancestorid, '60760' as classstructureid, 'arterial/collector' as classificationid, '60760' as ancestor, 'arterial/collector' as ancestorclassid, 
       0 as hierarchylevels
from dual
union all
select 12231 as classancestorid, '60770' as classstructureid, 'residential' as classificationid, '60000' as ancestor, 'roads' as ancestorclassid, 
       3 as hierarchylevels
from dual
union all
select 12230 as classancestorid, '60770' as classstructureid, 'residential' as classificationid, '60720' as ancestor, 'winter' as ancestorclassid, 
       2 as hierarchylevels
from dual
union all
select 12229 as classancestorid, '60770' as classstructureid, 'residential' as classificationid, '60750' as ancestor, 'city road clearing' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12228 as classancestorid, '60770' as classstructureid, 'residential' as classificationid, '60770' as ancestor, 'residential' as ancestorclassid, 
       0 as hierarchylevels
from dual
union all
select 12259 as classancestorid, '60850' as classstructureid, 'miscellaneous' as classificationid, '60000' as ancestor, 'roads' as ancestorclassid, 
       2 as hierarchylevels
from dual
union all
select 12258 as classancestorid, '60850' as classstructureid, 'miscellaneous' as classificationid, '60720' as ancestor, 'winter' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12257 as classancestorid, '60850' as classstructureid, 'miscellaneous' as classificationid, '60850' as ancestor, 'miscellaneous' as ancestorclassid, 
       0 as hierarchylevels
from dual
union all
select 12237 as classancestorid, '60790' as classstructureid, 'enforcement clearing' as classificationid, '60720' as ancestor, 'winter' as ancestorclassid, 
       2 as hierarchylevels
from dual
union all
select 12236 as classancestorid, '60790' as classstructureid, 'enforcement clearing' as classificationid, '60780' as ancestor, 'sidewalk clearing' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12235 as classancestorid, '60790' as classstructureid, 'enforcement clearing' as classificationid, '60790' as ancestor, 'enforcement clearing' as ancestorclassid, 
       0 as hierarchylevels
from dual
union all
select 12238 as classancestorid, '60790' as classstructureid, 'enforcement clearing' as classificationid, '60000' as ancestor, 'roads' as ancestorclassid, 
       3 as hierarchylevels
from dual
union all
select 12242 as classancestorid, '60800' as classstructureid, 'manual' as classificationid, '60000' as ancestor, 'roads' as ancestorclassid, 
       3 as hierarchylevels
from dual
union all
select 12241 as classancestorid, '60800' as classstructureid, 'manual' as classificationid, '60720' as ancestor, 'winter' as ancestorclassid, 
       2 as hierarchylevels
from dual
union all
select 12240 as classancestorid, '60800' as classstructureid, 'manual' as classificationid, '60780' as ancestor, 'sidewalk clearing' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12239 as classancestorid, '60800' as classstructureid, 'manual' as classificationid, '60800' as ancestor, 'manual' as ancestorclassid, 
       0 as hierarchylevels
from dual
union all
select 12217 as classancestorid, '60730' as classstructureid, 'winter storm event' as classificationid, '60000' as ancestor, 'roads' as ancestorclassid, 
       2 as hierarchylevels
from dual
union all
select 12216 as classancestorid, '60730' as classstructureid, 'winter storm event' as classificationid, '60720' as ancestor, 'winter' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12215 as classancestorid, '60730' as classstructureid, 'winter storm event' as classificationid, '60730' as ancestor, 'winter storm event' as ancestorclassid, 
       0 as hierarchylevels
from dual
union all
select 12246 as classancestorid, '60810' as classstructureid, 'mechanical' as classificationid, '60000' as ancestor, 'roads' as ancestorclassid, 
       3 as hierarchylevels
from dual
union all
select 12245 as classancestorid, '60810' as classstructureid, 'mechanical' as classificationid, '60720' as ancestor, 'winter' as ancestorclassid, 
       2 as hierarchylevels
from dual
union all
select 12244 as classancestorid, '60810' as classstructureid, 'mechanical' as classificationid, '60780' as ancestor, 'sidewalk clearing' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12243 as classancestorid, '60810' as classstructureid, 'mechanical' as classificationid, '60810' as ancestor, 'mechanical' as ancestorclassid, 
       0 as hierarchylevels
from dual
union all
select 12253 as classancestorid, '60830' as classstructureid, 'snow fence' as classificationid, '60000' as ancestor, 'roads' as ancestorclassid, 
       2 as hierarchylevels
from dual
union all
select 12252 as classancestorid, '60830' as classstructureid, 'snow fence' as classificationid, '60720' as ancestor, 'winter' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12251 as classancestorid, '60830' as classstructureid, 'snow fence' as classificationid, '60830' as ancestor, 'snow fence' as ancestorclassid, 
       0 as hierarchylevels
from dual
union all
select 12223 as classancestorid, '60750' as classstructureid, 'city road clearing' as classificationid, '60000' as ancestor, 'roads' as ancestorclassid, 
       2 as hierarchylevels
from dual
union all
select 12222 as classancestorid, '60750' as classstructureid, 'city road clearing' as classificationid, '60720' as ancestor, 'winter' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12221 as classancestorid, '60750' as classstructureid, 'city road clearing' as classificationid, '60750' as ancestor, 'city road clearing' as ancestorclassid, 
       0 as hierarchylevels
from dual
union all
select 12250 as classancestorid, '60820' as classstructureid, 'seniors' as classificationid, '60000' as ancestor, 'roads' as ancestorclassid, 
       3 as hierarchylevels
from dual
union all
select 12249 as classancestorid, '60820' as classstructureid, 'seniors' as classificationid, '60720' as ancestor, 'winter' as ancestorclassid, 
       2 as hierarchylevels
from dual
union all
select 12248 as classancestorid, '60820' as classstructureid, 'seniors' as classificationid, '60780' as ancestor, 'sidewalk clearing' as ancestorclassid, 
       1 as hierarchylevels
from dual
union all
select 12247 as classancestorid, '60820' as classstructureid, 'seniors' as classificationid, '60820' as ancestor, 'seniors' as ancestorclassid, 
       0 as hierarchylevels
from dual
)

select
    classancestorid, classstructureid, classificationid, ancestor, ancestorclassid, hierarchylevels
from
    cte;
47 rows affected

commit;
--short form definitions:
--wo   = workorder
--act  = actual (actual cost, actual date, etc.)
--pmtr = parameters

with 
wo_pmtr as (  --WOs filtered by parameters
select
    wonum,
    parent,
    hierarchypath,
    classstructureid,
    division,
    worktype,
    status, 
    trunc(actstart)  as actstart,
    trunc(actfinish) as actfinish,
    actlabcost,
    actmatcost,
    actservcost,
    acttoolcost,
    acttotalcost   
from
    workorder wo
--where
    --**I commented-out the bind variables, since I assume I can't use them as parameters in dbfiddle
    
--        (:wonum            is null     or wonum             = :wonum)
--    and (:division         is null     or division          = :division)
--    and (:worktype         is null     or worktype          = :worktype)
--    and (:status           is null     or status            = :status)
--    and (:actstart         is null     or trunc(actstart)  >= :actstart)
--    and (:actfinish        is null     or trunc(actfinish) <= :actfinish)

    --**retrieve workorders where the classification matches the parameter 
    --**and retrieve any child classifications too
    --**the classification hierarchy is not to be confused with the workorder hierarchy

--    and (:classstructureid is null     or (exists (select 1 from classancestor where ((ancestor = :classstructureid)) and (classstructureid=wo.classstructureid))))  --60720

)

select
    wo_pmtr.wonum,
    wo_pmtr.parent,
    wo_pmtr.hierarchypath,
    wo_pmtr.classstructureid,
    wo_pmtr.division,
    wo_pmtr.worktype,
    wo_pmtr.status, 
    wo_pmtr.actstart,
    wo_pmtr.actfinish,
    wo_pmtr.actlabcost,
    wo_pmtr.actmatcost,
    wo_pmtr.actservcost,
    wo_pmtr.acttoolcost,
    wo_pmtr.acttotalcost,
    coalesce(wo_pmtr.parent, wo_pmtr.wonum) parent_coalesced
from
    wo_pmtr      --WOs filtered by parameters
union            --union will remove duplicates (unlike union all)
select           --select children of the filtered WOs
    wo.wonum,
    wo.parent,
    wo.hierarchypath,
    wo.classstructureid,
    wo.division,
    wo.worktype,
    wo.status, 
    trunc(wo.actstart)  as actstart,
    trunc(wo.actfinish) as actfinish,
    wo.actlabcost,
    wo.actmatcost,
    wo.actservcost,
    wo.acttoolcost,
    wo.acttotalcost,
    coalesce(wo.parent, wo.wonum) parent_coalesced
from
    workorder wo  --select from the base workorder table *without* filtering by the parameters
left join
    wo_pmtr
    on wo.parent = wo_pmtr.wonum
where
    wo.parent         is not null  --where WO is a child
    and wo_pmtr.wonum is not null  --where WO is a child of the filtered WOs 
                                   --caution: some of those workorders might have already been selected via the parameters in the first query
                                   --we need to eliminate duplicates if they exist (via the union)
order by
    parent_coalesced, 
    hierarchypath


WONUM
PARENT
HIERARCHYPATH
CLASSSTRUCTUREID
DIVISION
WORKTYPE
STATUS
ACTSTART
ACTFINISH
ACTLABCOST
ACTMATCOST
ACTSERVCOST
ACTTOOLCOST
ACTTOTALCOST
PARENT_COALESCED


WO43178
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
EM
CLOSE
08-NOV-20
08-NOV-20
198.24
0
0
0
198.24
WO43178

WO43181
null
ROADS \ WINTER
60720
null
EM
WAPPR
26-OCT-20
08-NOV-20
0
0
0
0
0
WO43181

WO43183
WO43181
ROADS \ WINTER \ CITY ROAD CLEARING \ ARTERIAL/COLLECTOR
60760
null
EM
INPRG
08-NOV-20
09-NOV-20
0
0
0
0
0
WO43181

WO37342
WO43181
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
EM
CLOSE
07-NOV-20
08-NOV-20
1090.32
1300.01
0
0
2390.33
WO43181

WO43182
WO43181
ROADS \ WINTER \ SNOW FENCE
60830
null
EM
WAPPR
29-OCT-20
09-NOV-20
0
0
0
0
0
WO43181

WO43909
null
ROADS \ WINTER \ ANTI-ICING
60740
null
CM
WAPPR
null
null
0
0
0
0
0
WO43909

WO43910
null
ROADS \ WINTER \ ANTI-ICING
60740
null
CM
WAPPR
null
null
0
0
0
0
0
WO43910

WO43911
null
ROADS \ WINTER \ CITY ROAD CLEARING
60750
null
CM
WAPPR
null
null
0
0
0
0
0
WO43911

WO43914
WO43911
ROADS \ WINTER \ CITY ROAD CLEARING \ ARTERIAL/COLLECTOR
60760
null
CM
WAPPR
null
null
0
0
0
0
0
WO43911

WO43916
WO43911
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43911

WO43917
WO43911
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43911

WO43912
null
ROADS \ WINTER \ CITY ROAD CLEARING
60750
null
CM
WAPPR
null
null
0
0
0
0
0
WO43912

WO43913
null
ROADS \ WINTER \ CITY ROAD CLEARING \ ARTERIAL/COLLECTOR
60760
null
CM
WAPPR
null
null
0
0
0
0
0
WO43913

WO43915
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43915

WO43918
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43918

WO43919
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43919

WO43920
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43920

WO43921
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43921

WO43922
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43922

WO43923
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43923

WO43924
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43924

WO43925
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43925

WO43926
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43926

WO43927
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43927

WO43928
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43928

WO43929
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43929

WO43930
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43930

WO43931
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43931

WO43932
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43932

WO43933
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43933

WO43934
null
ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL
60770
null
CM
WAPPR
null
null
0
0
0
0
0
WO43934

WO43935
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43935

WO43936
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43936

WO43937
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43937

WO43938
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43938

WO43939
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43939

WO43940
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43940

WO43941
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43941

WO43942
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43942

WO43943
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43943

WO43944
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43944

WO43945
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43945

WO43946
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43946

WO43947
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43947

WO43948
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43948

WO43949
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43949

WO43950
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43950

WO43951
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43951

WO43952
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43952

WO43953
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43953

WO43954
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43954

WO43955
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43955

WO43956
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43956

WO43957
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43957

WO43958
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43958

WO43959
null
ROADS \ WINTER \ MISCELLANEOUS
60850
null
CM
WAPPR
null
null
0
0
0
0
0
WO43959

WO43960
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43960

WO43961
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43961

WO43962
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43962

WO43963
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43963

WO43964
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43964

WO43965
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43965

WO43966
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43966

WO43967
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43967

WO43968
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43968

WO43969
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43969

WO43970
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43970

WO43971
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43971

WO43972
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43972

WO43973
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43973

WO43974
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43974

WO43975
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43975

WO43976
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43976

WO43977
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43977

WO43978
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43978

WO43979
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43979

WO43980
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43980

WO43981
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43981

WO43982
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43982

WO43983
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43983

WO43984
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43984

WO43985
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43985

WO43986
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43986

WO43987
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43987

WO43988
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43988

WO43989
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43989

WO43990
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43990

WO43991
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43991

WO43992
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43992

WO43993
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43993

WO43994
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43994

WO43995
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43995

WO43996
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43996

WO43997
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43997

WO43998
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43998

WO43999
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO43999

WO44000
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO44000

WO44001
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO44001

WO44002
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO44002

WO44003
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO44003

WO44004
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO44004

WO44005
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO44005

WO44006
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO44006

WO44007
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO44007

WO44008
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO44008

WO44009
null
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
CM
WAPPR
null
null
0
0
0
0
0
WO44009

WO44010
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL
60800
null
CM
WAPPR
null
null
0
0
0
0
0
WO44010

WO44011
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL
60800
null
CM
WAPPR
null
null
0
0
0
0
0
WO44011

WO44012
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL
60800
null
CM
WAPPR
null
null
0
0
0
0
0
WO44012

WO44013
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL
60800
null
CM
WAPPR
null
null
0
0
0
0
0
WO44013

WO44014
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL
60800
null
CM
WAPPR
null
null
0
0
0
0
0
WO44014

WO44015
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL
60800
null
CM
WAPPR
null
null
0
0
0
0
0
WO44015

WO44016
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL
60800
null
CM
WAPPR
null
null
0
0
0
0
0
WO44016

WO44017
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL
60800
null
CM
WAPPR
null
null
0
0
0
0
0
WO44017

WO44018
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL
60800
null
CM
WAPPR
null
null
0
0
0
0
0
WO44018

WO44019
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL
60800
null
CM
WAPPR
null
null
0
0
0
0
0
WO44019

WO44020
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL
60810
null
CM
WAPPR
null
null
0
0
0
0
0
WO44020

WO44021
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL
60810
null
CM
WAPPR
null
null
0
0
0
0
0
WO44021

WO44022
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL
60810
null
CM
WAPPR
null
null
0
0
0
0
0
WO44022

WO44023
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL
60810
null
CM
WAPPR
null
null
0
0
0
0
0
WO44023

WO44024
null
ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL
60810
null
CM
WAPPR
null
null
0
0
0
0
0
WO44024

WO44025
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44025

WO44026
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44026

WO44027
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44027

WO44028
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44028

WO44029
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44029

WO44030
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44030

WO44031
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44031

WO44032
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44032

WO44033
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44033

WO44034
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44034

WO44035
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44035

WO44036
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44036

WO44037
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44037

WO44038
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44038

WO44039
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44039

WO44040
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44040

WO44041
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44041

WO44042
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44042

WO44043
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44043

WO44044
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44044

WO44045
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44045

WO44046
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44046

WO44047
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44047

WO44048
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44048

WO44049
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44049

WO44050
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44050

WO44051
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44051

WO44052
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44052

WO44053
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44053

WO44054
null
ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS
60820
null
CM
WAPPR
null
null
0
0
0
0
0
WO44054

WO44055
null
ROADS \ WINTER \ SNOW FENCE
60830
null
CM
WAPPR
null
null
0
0
0
0
0
WO44055

WO44056
null
ROADS \ WINTER \ SNOW FENCE
60830
null
CM
WAPPR
null
null
0
0
0
0
0
WO44056

WO44057
null
ROADS \ WINTER \ SNOW FENCE
60830
null
CM
WAPPR
null
null
0
0
0
0
0
WO44057

WO44058
null
ROADS \ WINTER \ SNOW FENCE
60830
null
CM
WAPPR
null
null
0
0
0
0
0
WO44058

WO44059
null
ROADS \ WINTER \ SNOW FENCE
60830
null
CM
WAPPR
null
null
0
0
0
0
0
WO44059

WO44060
null
ROADS \ WINTER \ SNOW FENCE
60830
null
CM
WAPPR
null
null
0
0
0
0
0
WO44060

WO44061
null
ROADS \ WINTER \ SNOW FENCE
60830
null
CM
WAPPR
null
null
0
0
0
0
0
WO44061

WO44062
null
ROADS \ WINTER \ SNOW FENCE
60830
null
CM
WAPPR
null
null
0
0
0
0
0
WO44062

WO44063
null
ROADS \ WINTER \ SNOW FENCE
60830
null
CM
WAPPR
null
null
0
0
0
0
0
WO44063

WO44064
null
ROADS \ WINTER \ SNOW FENCE
60830
null
CM
WAPPR
null
null
0
0
0
0
0
WO44064

WO44065
null
ROADS \ WINTER \ SNOW REMOVAL
60840
null
CM
WAPPR
null
null
0
0
0
0
0
WO44065

WO44066
null
ROADS \ WINTER \ SNOW REMOVAL
60840
null
CM
WAPPR
null
null
0
0
0
0
0
WO44066

WO44067
null
ROADS \ WINTER \ SNOW REMOVAL
60840
null
CM
WAPPR
null
null
0
0
0
0
0
WO44067

WO44068
null
ROADS \ WINTER \ SNOW REMOVAL
60840
null
CM
WAPPR
null
null
0
0
0
0
0
WO44068

WO44069
null
ROADS \ WINTER \ SNOW REMOVAL
60840
null
CM
WAPPR
null
null
0
0
0
0
0
WO44069

WO44070
null
ROADS \ WINTER \ SNOW REMOVAL
60840
null
CM
WAPPR
null
null
0
0
0
0
0
WO44070

WO44071
null
ROADS \ WINTER \ SNOW REMOVAL
60840
null
CM
WAPPR
null
null
0
0
0
0
0
WO44071

WO44072
null
ROADS \ WINTER \ SNOW REMOVAL
60840
null
CM
WAPPR
null
null
0
0
0
0
0
WO44072

WO44073
null
ROADS \ WINTER \ SNOW REMOVAL
60840
null
CM
WAPPR
null
null
0
0
0
0
0
WO44073

WO44074
null
ROADS \ WINTER \ SNOW REMOVAL
60840
null
CM
WAPPR
null
null
0
0
0
0
0
WO44074

WO44075
null
ROADS \ WINTER \ WINTER STORM EVENT
60730
null
CM
WAPPR
null
null
0
0
0
0
0
WO44075

WO44512
null
ROADS \ WINTER
60720
null
EM
WAPPR
null
null
0
0
0
0
0
WO44512

WO44513
WO44512
ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING
60790
null
EM
WAPPR
null
null
0
0
0
0
0
WO44512

WO44514
WO44512
ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL
60800
null
EM
WAPPR
null
null
0
0
0
0
0
WO44512

WO44905
null
ROADS \ WINTER
60720
null
EM
WAPPR
null
null
0
0
0
0
0
WO44905

WONUM	PARENT	HIERARCHYPATH	CLASSSTRUCTUREID	DIVISION	WORKTYPE	STATUS	ACTSTART	ACTFINISH	ACTLABCOST	ACTMATCOST	ACTTOTALCOST	PARENT_COALESCED
WO43178	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	EM	CLOSE	08-NOV-20	08-NOV-20	198.24	0	198.24	WO43178
WO43181	null	ROADS \ WINTER	60720	null	EM	WAPPR	26-OCT-20	08-NOV-20	0	0	0	WO43181
WO43183	WO43181	ROADS \ WINTER \ CITY ROAD CLEARING \ ARTERIAL/COLLECTOR	60760	null	EM	INPRG	08-NOV-20	09-NOV-20	0	0	0	WO43181
WO37342	WO43181	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	EM	CLOSE	07-NOV-20	08-NOV-20	1090.32	1300.01	2390.33	WO43181
WO43182	WO43181	ROADS \ WINTER \ SNOW FENCE	60830	null	EM	WAPPR	29-OCT-20	09-NOV-20	0	0	0	WO43181
WO43909	null	ROADS \ WINTER \ ANTI-ICING	60740	null	CM	WAPPR	null	null	0	0	0	WO43909
WO43910	null	ROADS \ WINTER \ ANTI-ICING	60740	null	CM	WAPPR	null	null	0	0	0	WO43910
WO43911	null	ROADS \ WINTER \ CITY ROAD CLEARING	60750	null	CM	WAPPR	null	null	0	0	0	WO43911
WO43914	WO43911	ROADS \ WINTER \ CITY ROAD CLEARING \ ARTERIAL/COLLECTOR	60760	null	CM	WAPPR	null	null	0	0	0	WO43911
WO43916	WO43911	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43911
WO43917	WO43911	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43911
WO43912	null	ROADS \ WINTER \ CITY ROAD CLEARING	60750	null	CM	WAPPR	null	null	0	0	0	WO43912
WO43913	null	ROADS \ WINTER \ CITY ROAD CLEARING \ ARTERIAL/COLLECTOR	60760	null	CM	WAPPR	null	null	0	0	0	WO43913
WO43915	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43915
WO43918	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43918
WO43919	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43919
WO43920	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43920
WO43921	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43921
WO43922	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43922
WO43923	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43923
WO43924	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43924
WO43925	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43925
WO43926	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43926
WO43927	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43927
WO43928	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43928
WO43929	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43929
WO43930	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43930
WO43931	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43931
WO43932	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43932
WO43933	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43933
WO43934	null	ROADS \ WINTER \ CITY ROAD CLEARING \ RESIDENTIAL	60770	null	CM	WAPPR	null	null	0	0	0	WO43934
WO43935	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43935
WO43936	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43936
WO43937	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43937
WO43938	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43938
WO43939	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43939
WO43940	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43940
WO43941	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43941
WO43942	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43942
WO43943	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43943
WO43944	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43944
WO43945	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43945
WO43946	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43946
WO43947	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43947
WO43948	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43948
WO43949	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43949
WO43950	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43950
WO43951	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43951
WO43952	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43952
WO43953	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43953
WO43954	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43954
WO43955	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43955
WO43956	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43956
WO43957	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43957
WO43958	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43958
WO43959	null	ROADS \ WINTER \ MISCELLANEOUS	60850	null	CM	WAPPR	null	null	0	0	0	WO43959
WO43960	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43960
WO43961	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43961
WO43962	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43962
WO43963	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43963
WO43964	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43964
WO43965	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43965
WO43966	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43966
WO43967	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43967
WO43968	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43968
WO43969	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43969
WO43970	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43970
WO43971	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43971
WO43972	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43972
WO43973	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43973
WO43974	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43974
WO43975	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43975
WO43976	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43976
WO43977	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43977
WO43978	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43978
WO43979	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43979
WO43980	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43980
WO43981	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43981
WO43982	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43982
WO43983	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43983
WO43984	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43984
WO43985	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43985
WO43986	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43986
WO43987	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43987
WO43988	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43988
WO43989	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43989
WO43990	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43990
WO43991	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43991
WO43992	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43992
WO43993	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43993
WO43994	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43994
WO43995	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43995
WO43996	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43996
WO43997	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43997
WO43998	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43998
WO43999	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO43999
WO44000	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO44000
WO44001	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO44001
WO44002	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO44002
WO44003	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO44003
WO44004	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO44004
WO44005	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO44005
WO44006	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO44006
WO44007	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO44007
WO44008	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO44008
WO44009	null	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	CM	WAPPR	null	null	0	0	0	WO44009
WO44010	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL	60800	null	CM	WAPPR	null	null	0	0	0	WO44010
WO44011	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL	60800	null	CM	WAPPR	null	null	0	0	0	WO44011
WO44012	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL	60800	null	CM	WAPPR	null	null	0	0	0	WO44012
WO44013	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL	60800	null	CM	WAPPR	null	null	0	0	0	WO44013
WO44014	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL	60800	null	CM	WAPPR	null	null	0	0	0	WO44014
WO44015	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL	60800	null	CM	WAPPR	null	null	0	0	0	WO44015
WO44016	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL	60800	null	CM	WAPPR	null	null	0	0	0	WO44016
WO44017	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL	60800	null	CM	WAPPR	null	null	0	0	0	WO44017
WO44018	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL	60800	null	CM	WAPPR	null	null	0	0	0	WO44018
WO44019	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL	60800	null	CM	WAPPR	null	null	0	0	0	WO44019
WO44020	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL	60810	null	CM	WAPPR	null	null	0	0	0	WO44020
WO44021	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL	60810	null	CM	WAPPR	null	null	0	0	0	WO44021
WO44022	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL	60810	null	CM	WAPPR	null	null	0	0	0	WO44022
WO44023	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL	60810	null	CM	WAPPR	null	null	0	0	0	WO44023
WO44024	null	ROADS \ WINTER \ SIDEWALK CLEARING \ MECHANICAL	60810	null	CM	WAPPR	null	null	0	0	0	WO44024
WO44025	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44025
WO44026	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44026
WO44027	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44027
WO44028	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44028
WO44029	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44029
WO44030	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44030
WO44031	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44031
WO44032	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44032
WO44033	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44033
WO44034	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44034
WO44035	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44035
WO44036	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44036
WO44037	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44037
WO44038	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44038
WO44039	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44039
WO44040	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44040
WO44041	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44041
WO44042	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44042
WO44043	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44043
WO44044	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44044
WO44045	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44045
WO44046	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44046
WO44047	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44047
WO44048	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44048
WO44049	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44049
WO44050	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44050
WO44051	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44051
WO44052	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44052
WO44053	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44053
WO44054	null	ROADS \ WINTER \ SIDEWALK CLEARING \ SENIORS	60820	null	CM	WAPPR	null	null	0	0	0	WO44054
WO44055	null	ROADS \ WINTER \ SNOW FENCE	60830	null	CM	WAPPR	null	null	0	0	0	WO44055
WO44056	null	ROADS \ WINTER \ SNOW FENCE	60830	null	CM	WAPPR	null	null	0	0	0	WO44056
WO44057	null	ROADS \ WINTER \ SNOW FENCE	60830	null	CM	WAPPR	null	null	0	0	0	WO44057
WO44058	null	ROADS \ WINTER \ SNOW FENCE	60830	null	CM	WAPPR	null	null	0	0	0	WO44058
WO44059	null	ROADS \ WINTER \ SNOW FENCE	60830	null	CM	WAPPR	null	null	0	0	0	WO44059
WO44060	null	ROADS \ WINTER \ SNOW FENCE	60830	null	CM	WAPPR	null	null	0	0	0	WO44060
WO44061	null	ROADS \ WINTER \ SNOW FENCE	60830	null	CM	WAPPR	null	null	0	0	0	WO44061
WO44062	null	ROADS \ WINTER \ SNOW FENCE	60830	null	CM	WAPPR	null	null	0	0	0	WO44062
WO44063	null	ROADS \ WINTER \ SNOW FENCE	60830	null	CM	WAPPR	null	null	0	0	0	WO44063
WO44064	null	ROADS \ WINTER \ SNOW FENCE	60830	null	CM	WAPPR	null	null	0	0	0	WO44064
WO44065	null	ROADS \ WINTER \ SNOW REMOVAL	60840	null	CM	WAPPR	null	null	0	0	0	WO44065
WO44066	null	ROADS \ WINTER \ SNOW REMOVAL	60840	null	CM	WAPPR	null	null	0	0	0	WO44066
WO44067	null	ROADS \ WINTER \ SNOW REMOVAL	60840	null	CM	WAPPR	null	null	0	0	0	WO44067
WO44068	null	ROADS \ WINTER \ SNOW REMOVAL	60840	null	CM	WAPPR	null	null	0	0	0	WO44068
WO44069	null	ROADS \ WINTER \ SNOW REMOVAL	60840	null	CM	WAPPR	null	null	0	0	0	WO44069
WO44070	null	ROADS \ WINTER \ SNOW REMOVAL	60840	null	CM	WAPPR	null	null	0	0	0	WO44070
WO44071	null	ROADS \ WINTER \ SNOW REMOVAL	60840	null	CM	WAPPR	null	null	0	0	0	WO44071
WO44072	null	ROADS \ WINTER \ SNOW REMOVAL	60840	null	CM	WAPPR	null	null	0	0	0	WO44072
WO44073	null	ROADS \ WINTER \ SNOW REMOVAL	60840	null	CM	WAPPR	null	null	0	0	0	WO44073
WO44074	null	ROADS \ WINTER \ SNOW REMOVAL	60840	null	CM	WAPPR	null	null	0	0	0	WO44074
WO44075	null	ROADS \ WINTER \ WINTER STORM EVENT	60730	null	CM	WAPPR	null	null	0	0	0	WO44075
WO44512	null	ROADS \ WINTER	60720	null	EM	WAPPR	null	null	0	0	0	WO44512
WO44513	WO44512	ROADS \ WINTER \ SIDEWALK CLEARING \ ENFORCEMENT CLEARING	60790	null	EM	WAPPR	null	null	0	0	0	WO44512
WO44514	WO44512	ROADS \ WINTER \ SIDEWALK CLEARING \ MANUAL	60800	null	EM	WAPPR	null	null	0	0	0	WO44512
WO44905	null	ROADS \ WINTER	60720	null	EM	WAPPR	null	null	0	0	0	WO44905