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
1020576
Transaction Id: 1020576 • Contract Number: QG-1019MR • Work Order Id: 19785318
Transaction Id
1020576
Contract Number
QG-1019MR
Work Order Id
19785318
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
30.16
Units Used
34.4
Total Cost
1037.504
Transaction Date
2023-04-05T00:00:00.000
1023102
Transaction Id: 1023102 • Contract Number: XG-519M • Work Order Id: 19635283
Transaction Id
1023102
Contract Number
XG-519M
Work Order Id
19635283
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
40.0
Units Used
24.0
Total Cost
960.0
Transaction Date
2023-05-09T00:00:00.000
1023151
Transaction Id: 1023151 • Contract Number: XG-519M • Work Order Id: 19650873
Transaction Id
1023151
Contract Number
XG-519M
Work Order Id
19650873
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
45.0
Units Used
15.3
Total Cost
688.5
Transaction Date
2023-05-05T00:00:00.000
1025030
Transaction Id: 1025030 • Contract Number: QG-222M • Work Order Id: 16007449
Transaction Id
1025030
Contract Number
QG-222M
Work Order Id
16007449
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
30.0
Total Cost
840.0
Transaction Date
2023-04-25T00:00:00.000
1025088
Transaction Id: 1025088 • Contract Number: QG-222M • Work Order Id: 16059127
Transaction Id
1025088
Contract Number
QG-222M
Work Order Id
16059127
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
36.0
Total Cost
1008.0
Transaction Date
2023-04-19T00:00:00.000
1026937
Transaction Id: 1026937 • Contract Number: BG-1619MR • Work Order Id: 19542945
Transaction Id
1026937
Contract Number
BG-1619MR
Work Order Id
19542945
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
48.88
Units Used
50.0
Total Cost
2444.0
Transaction Date
2023-05-08T00:00:00.000
1027829
Transaction Id: 1027829 • Contract Number: BG-1619MR • Work Order Id: 19867849
Transaction Id
1027829
Contract Number
BG-1619MR
Work Order Id
19867849
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
44.72
Units Used
19.3
Total Cost
863.096
Transaction Date
2023-04-28T00:00:00.000
1030463
Transaction Id: 1030463 • Contract Number: MG-1219MA • Work Order Id: 19938627
Transaction Id
1030463
Contract Number
MG-1219MA
Work Order Id
19938627
Line Item Id
342.0
Item Number
32
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
35.0
Units Used
42.4
Total Cost
1484.0
Transaction Date
2023-06-26T00:00:00.000
1030611
Transaction Id: 1030611 • Contract Number: RG-619MR • Work Order Id: 20037927
Transaction Id
1030611
Contract Number
RG-619MR
Work Order Id
20037927
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
44.2
Total Cost
1149.2
Transaction Date
2023-05-15T00:00:00.000
1032576
Transaction Id: 1032576 • Contract Number: QG-322M • Work Order Id: 20394065
Transaction Id
1032576
Contract Number
QG-322M
Work Order Id
20394065
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
24.6
Units Used
36.0
Total Cost
885.6
Transaction Date
2023-06-07T00:00:00.000
1032824
Transaction Id: 1032824 • Contract Number: BG-1119M • Work Order Id: 20177163
Transaction Id
1032824
Contract Number
BG-1119M
Work Order Id
20177163
Line Item Id
620.0
Item Number
12
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
40.0
Units Used
36.0
Total Cost
1440.0
Transaction Date
2023-06-09T00:00:00.000
1033017
Transaction Id: 1033017 • Contract Number: RG-519M • Work Order Id: 18273496
Transaction Id
1033017
Contract Number
RG-519M
Work Order Id
18273496
Line Item Id
620.0
Item Number
12
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
30.0
Units Used
36.0
Total Cost
1080.0
Transaction Date
2023-06-08T00:00:00.000
1033938
Transaction Id: 1033938 • Contract Number: CNYG-922M • Work Order Id: 20996489
Transaction Id
1033938
Contract Number
CNYG-922M
Work Order Id
20996489
Line Item Id
629.0
Item Number
25
Line Item Description
STEEL TREE BED GUARD - C
Unit Of Measure
LF
Unit Price
130.0
Units Used
16.0
Total Cost
2080.0
Transaction Date
2023-10-27T00:00:00.000
1034471
Transaction Id: 1034471 • Contract Number: MG-1319MA • Work Order Id: 19521860
Transaction Id
1034471
Contract Number
MG-1319MA
Work Order Id
19521860
Line Item Id
630.0
Item Number
40
Line Item Description
STEEL TREE BED GUARD - D
Unit Of Measure
LF
Unit Price
205.0
Units Used
15.9
Total Cost
3259.5
Transaction Date
2024-09-19T00:00:00.000
1035166
Transaction Id: 1035166 • Contract Number: RG-519M • Work Order Id: 21097753
Transaction Id
1035166
Contract Number
RG-519M
Work Order Id
21097753
Line Item Id
620.0
Item Number
12
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
30.0
Units Used
36.0
Total Cost
1080.0
Transaction Date
2023-10-26T00:00:00.000
1035446
Transaction Id: 1035446 • Contract Number: BG-1319M • Work Order Id: 20804695
Transaction Id
1035446
Contract Number
BG-1319M
Work Order Id
20804695
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
46.0
Units Used
27.2
Total Cost
1251.2
Transaction Date
2023-12-22T00:00:00.000
1038746
Transaction Id: 1038746 • Contract Number: QG-1119MR • Work Order Id: 20937282
Transaction Id
1038746
Contract Number
QG-1119MR
Work Order Id
20937282
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
45.0
Total Cost
2152.8
Transaction Date
2023-12-07T00:00:00.000
1040130
Transaction Id: 1040130 • Contract Number: BG-1619MR • Work Order Id: 19637825
Transaction Id
1040130
Contract Number
BG-1619MR
Work Order Id
19637825
Units Used
17.4
Transaction Date
2023-09-21T00:00:00.000
1040894
Transaction Id: 1040894 • Contract Number: QG-222M • Work Order Id: 19852740
Transaction Id
1040894
Contract Number
QG-222M
Work Order Id
19852740
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
29.0
Units Used
31.5
Total Cost
913.5
Transaction Date
2023-10-17T00:00:00.000
1041407
Transaction Id: 1041407 • Contract Number: QG-222M • Work Order Id: 21307241
Transaction Id
1041407
Contract Number
QG-222M
Work Order Id
21307241
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
30.0
Total Cost
840.0
Transaction Date
2023-10-09T00:00:00.000
1043357
Transaction Id: 1043357 • Contract Number: QG-322M • Work Order Id: 21216227
Transaction Id
1043357
Contract Number
QG-322M
Work Order Id
21216227
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
24.6
Units Used
36.0
Total Cost
885.6
Transaction Date
2023-10-13T00:00:00.000
1044019
Transaction Id: 1044019 • Contract Number: QG-1219M • Work Order Id: 20055379
Transaction Id
1044019
Contract Number
QG-1219M
Work Order Id
20055379
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
50.0
Total Cost
1850.0
Transaction Date
2023-10-25T00:00:00.000
1044971
Transaction Id: 1044971 • Contract Number: QG-1219M • Work Order Id: 21335869
Transaction Id
1044971
Contract Number
QG-1219M
Work Order Id
21335869
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
31.5
Total Cost
1165.5
Transaction Date
2023-10-18T00:00:00.000
1045218
Transaction Id: 1045218 • Contract Number: QG-1219M • Work Order Id: 21430141
Transaction Id
1045218
Contract Number
QG-1219M
Work Order Id
21430141
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
23.3
Total Cost
862.1
Transaction Date
2023-10-25T00:00:00.000
1045309
Transaction Id: 1045309 • Contract Number: QG-1219M • Work Order Id: 21466392
Transaction Id
1045309
Contract Number
QG-1219M
Work Order Id
21466392
Units Used
50.0
Transaction Date
2023-10-30T00:00:00.000
1045390
Transaction Id: 1045390 • Contract Number: QG-1219M • Work Order Id: 21466796
Transaction Id
1045390
Contract Number
QG-1219M
Work Order Id
21466796
Units Used
26.7
Transaction Date
2023-10-31T00:00:00.000
1045563
Transaction Id: 1045563 • Contract Number: QG-1219M • Work Order Id: 21514988
Transaction Id
1045563
Contract Number
QG-1219M
Work Order Id
21514988
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
33.3
Total Cost
1232.1
Transaction Date
2023-10-25T00:00:00.000
1045655
Transaction Id: 1045655 • Contract Number: QG-1219M • Work Order Id: 21526787
Transaction Id
1045655
Contract Number
QG-1219M
Work Order Id
21526787
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
31.5
Total Cost
1165.5
Transaction Date
2023-11-07T00:00:00.000
1045701
Transaction Id: 1045701 • Contract Number: QG-1219M • Work Order Id: 21527581
Transaction Id
1045701
Contract Number
QG-1219M
Work Order Id
21527581
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
32.1
Total Cost
1187.7
Transaction Date
2023-10-27T00:00:00.000
1048042
Transaction Id: 1048042 • Contract Number: BG-222M • Work Order Id: 20688889
Transaction Id
1048042
Contract Number
BG-222M
Work Order Id
20688889
Line Item Id
721.0
Item Number
38
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
600.0
Units Used
0.1
Total Cost
60.0
Transaction Date
2024-01-29T00:00:00.000
1047008
Transaction Id: 1047008 • Contract Number: MG-1219MA • Work Order Id: 19954548
Transaction Id
1047008
Contract Number
MG-1219MA
Work Order Id
19954548
Line Item Id
628.0
Item Number
41
Line Item Description
STEEL TREE BED GUARD - B
Unit Of Measure
LF
Unit Price
110.0
Units Used
17.2
Total Cost
1892.0
Transaction Date
2023-10-18T00:00:00.000
1047875
Transaction Id: 1047875 • Contract Number: QG-1219M • Work Order Id: 21527581
Transaction Id
1047875
Contract Number
QG-1219M
Work Order Id
21527581
Line Item Id
721.0
Item Number
34
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
500.0
Units Used
0.54
Total Cost
270.0
Transaction Date
2023-10-23T00:00:00.000
1048151
Transaction Id: 1048151 • Contract Number: BG-1119M • Work Order Id: 14022985
Transaction Id
1048151
Contract Number
BG-1119M
Work Order Id
14022985
Line Item Id
620.0
Item Number
12
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
40.0
Units Used
36.0
Total Cost
1440.0
Transaction Date
2023-10-31T00:00:00.000
1048203
Transaction Id: 1048203 • Contract Number: BG-622M • Work Order Id: 21334691
Transaction Id
1048203
Contract Number
BG-622M
Work Order Id
21334691
Units Used
43.0
Transaction Date
2023-11-01T00:00:00.000
1048812
Transaction Id: 1048812 • Contract Number: BG-622M • Work Order Id: 21217989
Transaction Id
1048812
Contract Number
BG-622M
Work Order Id
21217989
Line Item Id
292.0
Item Number
31
Line Item Description
SHREDDED BARK MULCH
Unit Of Measure
SY
Unit Price
15.0
Units Used
0.94
Total Cost
14.1
Transaction Date
2023-11-06T00:00:00.000
1051164
Transaction Id: 1051164 • Contract Number: RG-619MR • Work Order Id: 21621894
Transaction Id
1051164
Contract Number
RG-619MR
Work Order Id
21621894
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
31.2
Units Used
12.5
Total Cost
390.0
Transaction Date
2023-11-09T00:00:00.000
1052068
Transaction Id: 1052068 • Contract Number: BG-422M • Work Order Id: 20528273
Transaction Id
1052068
Contract Number
BG-422M
Work Order Id
20528273
Line Item Id
721.0
Item Number
38
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
2500.0
Units Used
0.11
Total Cost
275.0
Transaction Date
2024-06-04T00:00:00.000
1052218
Transaction Id: 1052218 • Contract Number: BG-422M • Work Order Id: 20582541
Transaction Id
1052218
Contract Number
BG-422M
Work Order Id
20582541
Line Item Id
620.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
35.0
Units Used
23.7
Total Cost
829.5
Transaction Date
2023-11-28T00:00:00.000
1052873
Transaction Id: 1052873 • Contract Number: BG-422M • Work Order Id: 20744884
Transaction Id
1052873
Contract Number
BG-422M
Work Order Id
20744884
Line Item Id
735.0
Item Number
38R
Line Item Description
CONCRETE CURB (R)
Unit Of Measure
CY
Unit Price
1850.0
Units Used
0.29
Total Cost
536.5
Transaction Date
2024-06-11T00:00:00.000
1053340
Transaction Id: 1053340 • Contract Number: QG-1219M • Work Order Id: 21019825
Transaction Id
1053340
Contract Number
QG-1219M
Work Order Id
21019825
Line Item Id
294.0
Item Number
29
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
350.0
Units Used
0.13
Total Cost
45.5
Transaction Date
2023-11-17T00:00:00.000
1054032
Transaction Id: 1054032 • Contract Number: QG-322M • Work Order Id: 20132097
Transaction Id
1054032
Contract Number
QG-322M
Work Order Id
20132097
Line Item Id
619.0
Item Number
12
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
50.0
Total Cost
1300.0
Transaction Date
2023-11-29T00:00:00.000
1054082
Transaction Id: 1054082 • Contract Number: BG-1319M • Work Order Id: 21386863
Transaction Id
1054082
Contract Number
BG-1319M
Work Order Id
21386863
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
43.0
Units Used
24.0
Total Cost
1032.0
Transaction Date
2023-11-30T00:00:00.000
1054244
Transaction Id: 1054244 • Contract Number: BG-622M • Work Order Id: 16890121
Transaction Id
1054244
Contract Number
BG-622M
Work Order Id
16890121
Line Item Id
292.0
Item Number
31
Line Item Description
SHREDDED BARK MULCH
Unit Of Measure
SY
Unit Price
15.0
Units Used
0.8
Total Cost
12.0
Transaction Date
2023-11-28T00:00:00.000
1054528
Transaction Id: 1054528 • Contract Number: QG-322M • Work Order Id: 19266887
Transaction Id
1054528
Contract Number
QG-322M
Work Order Id
19266887
Line Item Id
295.0
Item Number
42
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
210.0
Units Used
1.4
Total Cost
294.0
Transaction Date
2023-12-05T00:00:00.000
1054692
Transaction Id: 1054692 • Contract Number: RG-619MR • Work Order Id: 21654482
Transaction Id
1054692
Contract Number
RG-619MR
Work Order Id
21654482
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
37.5
Total Cost
975.0
Transaction Date
2023-12-04T00:00:00.000
1054760
Transaction Id: 1054760 • Contract Number: RG-619MR • Work Order Id: 21776521
Transaction Id
1054760
Contract Number
RG-619MR
Work Order Id
21776521
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
30.0
Total Cost
780.0
Transaction Date
2023-12-05T00:00:00.000
1054819
Transaction Id: 1054819 • Contract Number: RG-619MR • Work Order Id: 21776513
Transaction Id
1054819
Contract Number
RG-619MR
Work Order Id
21776513
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
30.0
Total Cost
780.0
Transaction Date
2023-12-06T00:00:00.000
1054862
Transaction Id: 1054862 • Contract Number: RG-619MR • Work Order Id: 21785041
Transaction Id
1054862
Contract Number
RG-619MR
Work Order Id
21785041
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
40.0
Total Cost
1040.0
Transaction Date
2023-11-20T00:00:00.000
1055513
Transaction Id: 1055513 • Contract Number: RG-619MR • Work Order Id: 21036842
Transaction Id
1055513
Contract Number
RG-619MR
Work Order Id
21036842
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
37.5
Total Cost
975.0
Transaction Date
2023-12-15T00:00:00.000
1056089
Transaction Id: 1056089 • Contract Number: QG-1219M • Work Order Id: 21004378
Transaction Id
1056089
Contract Number
QG-1219M
Work Order Id
21004378
Line Item Id
764.0
Item Number
29R
Line Item Description
UNCLASSIFIED EXCAVATION (R)
Unit Of Measure
CY
Unit Price
200.0
Units Used
0.36
Total Cost
72.0
Transaction Date
2023-12-16T00:00:00.000
NYC Data AI • Public-data exploration interface