Ask NYC Browse All Data Public Safety Transportation Health Buildings

Tree Contract Work Details

Tree Contract Work Details contains information related to work performed on specific tree work contracts. This dataset can be joined to the Forestry Work Orders dataset (https://data.cityofnewyork.us/Environment/Forestry-Work-Orders/bdjm-n7q4) by joining work_order_id from Tree Contract Work Details to OBJECTID from Forestry Work Orders. There are many work_order_ids per single contract_number. Not all work orders in Forestry Work Orders are represented in this dataset because it is only used to track work on specific contracts.

Data Dictionary found here: https://docs.google.com/spreadsheets/d/1rAQL_d8yQ5axRIGl9vLxpr73rDmQUZ23VKQC8QQWIYI/edit?usp=sharing

Environment Department of Parks and Recreation (DPR) Dataset kcfe-uypz 11 fields
DOWNLOAD CSV
Dataset fields
Showing 50 real records
747921
Transaction Id: 747921 • Contract Number: BG-415M • Work Order Id: 649160
Transaction Id
747921
Contract Number
BG-415M
Work Order Id
649160
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
150.0
Units Used
1.0
Total Cost
150.0
Transaction Date
2015-10-21T00:00:00.000
747922
Transaction Id: 747922 • Contract Number: BG-415M • Work Order Id: 648435
Transaction Id
747922
Contract Number
BG-415M
Work Order Id
648435
Line Item Id
297.0
Item Number
03
Line Item Description
STUMP REMOVALS OF OVER 18 TO 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2015-11-16T00:00:00.000
747923
Transaction Id: 747923 • Contract Number: BG-415M • Work Order Id: 648435
Transaction Id
747923
Contract Number
BG-415M
Work Order Id
648435
Line Item Id
541.0
Item Number
31
Line Item Description
CONCRETE PAVEMENT W/O BASE – 7”
Unit Of Measure
SF
Unit Price
17.0
Units Used
3.0
Total Cost
51.0
Transaction Date
2016-05-14T00:00:00.000
747924
Transaction Id: 747924 • Contract Number: BG-415M • Work Order Id: 647955
Transaction Id
747924
Contract Number
BG-415M
Work Order Id
647955
Line Item Id
297.0
Item Number
03
Line Item Description
STUMP REMOVALS OF OVER 18 TO 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2015-10-21T00:00:00.000
747925
Transaction Id: 747925 • Contract Number: BG-415M • Work Order Id: 648334
Transaction Id
747925
Contract Number
BG-415M
Work Order Id
648334
Line Item Id
286.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 12 TO 18 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
200.0
Units Used
1.0
Total Cost
200.0
Transaction Date
2015-10-21T00:00:00.000
747926
Transaction Id: 747926 • Contract Number: BG-415M • Work Order Id: 681738
Transaction Id
747926
Contract Number
BG-415M
Work Order Id
681738
Line Item Id
297.0
Item Number
03
Line Item Description
STUMP REMOVALS OF OVER 18 TO 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2015-11-02T00:00:00.000
747927
Transaction Id: 747927 • Contract Number: BG-415M • Work Order Id: 647985
Transaction Id
747927
Contract Number
BG-415M
Work Order Id
647985
Line Item Id
335.0
Item Number
05
Line Item Description
STUMP REMOVALS OF OVER 30 TO 36 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
500.0
Units Used
1.0
Total Cost
500.0
Transaction Date
2015-10-21T00:00:00.000
747928
Transaction Id: 747928 • Contract Number: BG-415M • Work Order Id: 653131
Transaction Id
747928
Contract Number
BG-415M
Work Order Id
653131
Line Item Id
304.0
Item Number
04
Line Item Description
STUMP REMOVALS OF OVER 24 TO 30 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
400.0
Units Used
1.0
Total Cost
400.0
Transaction Date
2015-11-12T00:00:00.000
747929
Transaction Id: 747929 • Contract Number: BG-415M • Work Order Id: 670909
Transaction Id
747929
Contract Number
BG-415M
Work Order Id
670909
Line Item Id
304.0
Item Number
04
Line Item Description
STUMP REMOVALS OF OVER 24 TO 30 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
400.0
Units Used
1.0
Total Cost
400.0
Transaction Date
2015-10-26T00:00:00.000
747930
Transaction Id: 747930 • Contract Number: BG-415M • Work Order Id: 648371
Transaction Id
747930
Contract Number
BG-415M
Work Order Id
648371
Line Item Id
335.0
Item Number
05
Line Item Description
STUMP REMOVALS OF OVER 30 TO 36 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
500.0
Units Used
1.0
Total Cost
500.0
Transaction Date
2015-10-21T00:00:00.000
747931
Transaction Id: 747931 • Contract Number: BG-415M • Work Order Id: 649147
Transaction Id
747931
Contract Number
BG-415M
Work Order Id
649147
Line Item Id
286.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 12 TO 18 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
200.0
Units Used
1.0
Total Cost
200.0
Transaction Date
2015-10-21T00:00:00.000
747932
Transaction Id: 747932 • Contract Number: BG-415M • Work Order Id: 647952
Transaction Id
747932
Contract Number
BG-415M
Work Order Id
647952
Line Item Id
297.0
Item Number
03
Line Item Description
STUMP REMOVALS OF OVER 18 TO 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2015-10-30T00:00:00.000
747933
Transaction Id: 747933 • Contract Number: BG-415M • Work Order Id: 647540
Transaction Id
747933
Contract Number
BG-415M
Work Order Id
647540
Line Item Id
304.0
Item Number
04
Line Item Description
STUMP REMOVALS OF OVER 24 TO 30 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
400.0
Units Used
1.0
Total Cost
400.0
Transaction Date
2015-10-21T00:00:00.000
747935
Transaction Id: 747935 • Contract Number: BG-415M • Work Order Id: 651127
Transaction Id
747935
Contract Number
BG-415M
Work Order Id
651127
Line Item Id
297.0
Item Number
03
Line Item Description
STUMP REMOVALS OF OVER 18 TO 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2015-11-12T00:00:00.000
747937
Transaction Id: 747937 • Contract Number: BG-415M • Work Order Id: 669718
Transaction Id
747937
Contract Number
BG-415M
Work Order Id
669718
Line Item Id
286.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 12 TO 18 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
200.0
Units Used
1.0
Total Cost
200.0
Transaction Date
2015-10-26T00:00:00.000
747938
Transaction Id: 747938 • Contract Number: BG-415M • Work Order Id: 676118
Transaction Id
747938
Contract Number
BG-415M
Work Order Id
676118
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.0
Units Used
33.9
Total Cost
305.09999999999997
Transaction Date
2015-11-03T00:00:00.000
747939
Transaction Id: 747939 • Contract Number: BG-415M • Work Order Id: 676118
Transaction Id
747939
Contract Number
BG-415M
Work Order Id
676118
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-01-04T00:00:00.000
747940
Transaction Id: 747940 • Contract Number: BG-415M • Work Order Id: 676118
Transaction Id
747940
Contract Number
BG-415M
Work Order Id
676118
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
150.0
Units Used
1.0
Total Cost
150.0
Transaction Date
2015-11-03T00:00:00.000
747941
Transaction Id: 747941 • Contract Number: BG-415M • Work Order Id: 638736
Transaction Id
747941
Contract Number
BG-415M
Work Order Id
638736
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.0
Units Used
20.0
Total Cost
180.0
Transaction Date
2015-10-20T00:00:00.000
747942
Transaction Id: 747942 • Contract Number: BG-415M • Work Order Id: 638736
Transaction Id
747942
Contract Number
BG-415M
Work Order Id
638736
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-12-19T00:00:00.000
747943
Transaction Id: 747943 • Contract Number: BG-415M • Work Order Id: 638736
Transaction Id
747943
Contract Number
BG-415M
Work Order Id
638736
Line Item Id
297.0
Item Number
03
Line Item Description
STUMP REMOVALS OF OVER 18 TO 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2015-10-20T00:00:00.000
747944
Transaction Id: 747944 • Contract Number: BG-415M • Work Order Id: 649588
Transaction Id
747944
Contract Number
BG-415M
Work Order Id
649588
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.0
Units Used
40.0
Total Cost
360.0
Transaction Date
2015-11-16T00:00:00.000
747945
Transaction Id: 747945 • Contract Number: BG-415M • Work Order Id: 649588
Transaction Id
747945
Contract Number
BG-415M
Work Order Id
649588
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-01-08T00:00:00.000
747946
Transaction Id: 747946 • Contract Number: BG-415M • Work Order Id: 649588
Transaction Id
747946
Contract Number
BG-415M
Work Order Id
649588
Line Item Id
305.0
Item Number
06
Line Item Description
TREE REMOVAL OF OVER 8 TO 12 INCHES DBH
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2015-11-16T00:00:00.000
747947
Transaction Id: 747947 • Contract Number: BG-415M • Work Order Id: 649590
Transaction Id
747947
Contract Number
BG-415M
Work Order Id
649590
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.0
Units Used
40.0
Total Cost
360.0
Transaction Date
2015-11-16T00:00:00.000
747948
Transaction Id: 747948 • Contract Number: BG-415M • Work Order Id: 649590
Transaction Id
747948
Contract Number
BG-415M
Work Order Id
649590
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-16T00:00:00.000
747949
Transaction Id: 747949 • Contract Number: BG-415M • Work Order Id: 649590
Transaction Id
747949
Contract Number
BG-415M
Work Order Id
649590
Line Item Id
305.0
Item Number
06
Line Item Description
TREE REMOVAL OF OVER 8 TO 12 INCHES DBH
Unit Of Measure
EA
Unit Price
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2015-11-16T00:00:00.000
747950
Transaction Id: 747950 • Contract Number: BG-415M • Work Order Id: 641940
Transaction Id
747950
Contract Number
BG-415M
Work Order Id
641940
Line Item Id
541.0
Item Number
31
Line Item Description
CONCRETE PAVEMENT W/O BASE – 7”
Unit Of Measure
SF
Unit Price
17.0
Units Used
1.9
Total Cost
32.3
Transaction Date
2016-04-08T00:00:00.000
747953
Transaction Id: 747953 • Contract Number: BG-415M • Work Order Id: 664074
Transaction Id
747953
Contract Number
BG-415M
Work Order Id
664074
Line Item Id
541.0
Item Number
31
Line Item Description
CONCRETE PAVEMENT W/O BASE – 7”
Unit Of Measure
SF
Unit Price
17.0
Units Used
6.2
Total Cost
105.4
Transaction Date
2016-04-14T00:00:00.000
747954
Transaction Id: 747954 • Contract Number: BG-415M • Work Order Id: 1303864
Transaction Id
747954
Contract Number
BG-415M
Work Order Id
1303864
Line Item Id
342.0
Item Number
30
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
12.0
Units Used
19.2
Total Cost
230.39999999999998
Transaction Date
2016-05-14T00:00:00.000
747958
Transaction Id: 747958 • Contract Number: BG-415M • Work Order Id: 640447
Transaction Id
747958
Contract Number
BG-415M
Work Order Id
640447
Line Item Id
287.0
Item Number
20
Line Item Description
EXPANSION OF EXISTING SIDEWALK TREE PITS
Unit Of Measure
SF
Unit Price
14.0
Units Used
50.0
Total Cost
700.0
Transaction Date
2016-04-15T00:00:00.000
747967
Transaction Id: 747967 • Contract Number: BG-415M • Work Order Id: 1303069
Transaction Id
747967
Contract Number
BG-415M
Work Order Id
1303069
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
30.0
Total Cost
300.0
Transaction Date
2015-11-03T00:00:00.000
747968
Transaction Id: 747968 • Contract Number: BG-415M • Work Order Id: 1303069
Transaction Id
747968
Contract Number
BG-415M
Work Order Id
1303069
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-03T00:00:00.000
747969
Transaction Id: 747969 • Contract Number: BG-415M • Work Order Id: 665398
Transaction Id
747969
Contract Number
BG-415M
Work Order Id
665398
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
26.3
Total Cost
263.0
Transaction Date
2015-10-29T00:00:00.000
747970
Transaction Id: 747970 • Contract Number: BG-415M • Work Order Id: 665398
Transaction Id
747970
Contract Number
BG-415M
Work Order Id
665398
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-02-09T00:00:00.000
747971
Transaction Id: 747971 • Contract Number: BG-415M • Work Order Id: 673292
Transaction Id
747971
Contract Number
BG-415M
Work Order Id
673292
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
25.2
Total Cost
252.0
Transaction Date
2015-10-30T00:00:00.000
747972
Transaction Id: 747972 • Contract Number: BG-415M • Work Order Id: 673292
Transaction Id
747972
Contract Number
BG-415M
Work Order Id
673292
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-02T00:00:00.000
747973
Transaction Id: 747973 • Contract Number: BG-415M • Work Order Id: 647743
Transaction Id
747973
Contract Number
BG-415M
Work Order Id
647743
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.1
Total Cost
1197.0
Transaction Date
2016-04-07T00:00:00.000
747974
Transaction Id: 747974 • Contract Number: BG-415M • Work Order Id: 649686
Transaction Id
747974
Contract Number
BG-415M
Work Order Id
649686
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
70.0
Units Used
13.5
Total Cost
945.0
Transaction Date
2016-04-05T00:00:00.000
747975
Transaction Id: 747975 • Contract Number: BG-415M • Work Order Id: 642736
Transaction Id
747975
Contract Number
BG-415M
Work Order Id
642736
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.4
Total Cost
1008.0
Transaction Date
2016-04-07T00:00:00.000
747976
Transaction Id: 747976 • Contract Number: BG-415M • Work Order Id: 655202
Transaction Id
747976
Contract Number
BG-415M
Work Order Id
655202
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
70.0
Units Used
13.8
Total Cost
966.0
Transaction Date
2016-04-05T00:00:00.000
747977
Transaction Id: 747977 • Contract Number: BG-415M • Work Order Id: 650766
Transaction Id
747977
Contract Number
BG-415M
Work Order Id
650766
Line Item Id
342.0
Item Number
30
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
12.0
Units Used
17.4
Total Cost
208.79999999999998
Transaction Date
2016-04-20T00:00:00.000
747980
Transaction Id: 747980 • Contract Number: BG-415M • Work Order Id: 679305
Transaction Id
747980
Contract Number
BG-415M
Work Order Id
679305
Line Item Id
342.0
Item Number
30
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
12.0
Units Used
13.5
Total Cost
162.0
Transaction Date
2016-04-20T00:00:00.000
747982
Transaction Id: 747982 • Contract Number: BG-415M • Work Order Id: 653134
Transaction Id
747982
Contract Number
BG-415M
Work Order Id
653134
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
70.0
Units Used
12.2
Total Cost
854.0
Transaction Date
2016-04-05T00:00:00.000
747985
Transaction Id: 747985 • Contract Number: BG-415M • Work Order Id: 656376
Transaction Id
747985
Contract Number
BG-415M
Work Order Id
656376
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
70.0
Units Used
18.9
Total Cost
1323.0
Transaction Date
2016-04-07T00:00:00.000
747986
Transaction Id: 747986 • Contract Number: BG-415M • Work Order Id: 655587
Transaction Id
747986
Contract Number
BG-415M
Work Order Id
655587
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.9
Total Cost
1253.0
Transaction Date
2016-04-05T00:00:00.000
747987
Transaction Id: 747987 • Contract Number: BG-415M • Work Order Id: 668531
Transaction Id
747987
Contract Number
BG-415M
Work Order Id
668531
Line Item Id
353.0
Item Number
37
Line Item Description
STEEL TREE PIT GUARD - C
Unit Of Measure
LF
Unit Price
60.0
Units Used
15.8
Total Cost
948.0
Transaction Date
2016-05-14T00:00:00.000
747988
Transaction Id: 747988 • Contract Number: BG-415M • Work Order Id: 672086
Transaction Id
747988
Contract Number
BG-415M
Work Order Id
672086
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.0
Total Cost
1190.0
Transaction Date
2016-04-19T00:00:00.000
747989
Transaction Id: 747989 • Contract Number: BG-415M • Work Order Id: 673689
Transaction Id
747989
Contract Number
BG-415M
Work Order Id
673689
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
17.7
Total Cost
1239.0
Transaction Date
2016-04-19T00:00:00.000
747991
Transaction Id: 747991 • Contract Number: BG-415M • Work Order Id: 672089
Transaction Id
747991
Contract Number
BG-415M
Work Order Id
672089
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
13.8
Total Cost
966.0
Transaction Date
2016-04-18T00:00:00.000
NYC Data AI • Public-data exploration interface