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
975752
Transaction Id: 975752 • Contract Number: MG-321M • Work Order Id: 14053145
Transaction Id
975752
Contract Number
MG-321M
Work Order Id
14053145
Line Item Id
294.0
Item Number
17
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
300.0
Units Used
0.5
Total Cost
150.0
Transaction Date
2021-12-17T00:00:00.000
976131
Transaction Id: 976131 • Contract Number: QG-321M • Work Order Id: 8870064
Transaction Id
976131
Contract Number
QG-321M
Work Order Id
8870064
Units Used
1.0
Transaction Date
2021-12-30T00:00:00.000
976159
Transaction Id: 976159 • Contract Number: BG-321M • Work Order Id: 12861918
Transaction Id
976159
Contract Number
BG-321M
Work Order Id
12861918
Line Item Id
620.0
Item Number
10
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
5.0
Units Used
36.0
Total Cost
180.0
Transaction Date
2021-12-23T00:00:00.000
976903
Transaction Id: 976903 • Contract Number: BG-321M • Work Order Id: 14245620
Transaction Id
976903
Contract Number
BG-321M
Work Order Id
14245620
Line Item Id
706.0
Item Number
09
Line Item Description
PREPARING EXISTING TREE BEDS
Unit Of Measure
SF
Unit Price
5.0
Units Used
42.2
Total Cost
211.0
Transaction Date
2022-04-27T00:00:00.000
977568
Transaction Id: 977568 • Contract Number: BG-819M • Work Order Id: 6465659
Transaction Id
977568
Contract Number
BG-819M
Work Order Id
6465659
Line Item Id
627.0
Item Number
34
Line Item Description
STEEL TREE BED GUARD - A
Unit Of Measure
LF
Unit Price
100.0
Units Used
17.5
Total Cost
1750.0
Transaction Date
2020-08-10T00:00:00.000
977696
Transaction Id: 977696 • Contract Number: QG-319MR • Work Order Id: 6549049
Transaction Id
977696
Contract Number
QG-319MR
Work Order Id
6549049
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
31.72
Units Used
36.0
Total Cost
1141.92
Transaction Date
2022-03-25T00:00:00.000
978880
Transaction Id: 978880 • Contract Number: QG-1219M • Work Order Id: 16884077
Transaction Id
978880
Contract Number
QG-1219M
Work Order Id
16884077
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
30.9
Total Cost
1143.3
Transaction Date
2022-05-24T00:00:00.000
978985
Transaction Id: 978985 • Contract Number: XG-221M • Work Order Id: 13987871
Transaction Id
978985
Contract Number
XG-221M
Work Order Id
13987871
Line Item Id
294.0
Item Number
20
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
198.0
Units Used
0.16
Total Cost
31.68
Transaction Date
2022-03-03T00:00:00.000
981689
Transaction Id: 981689 • Contract Number: QG-1019M • Work Order Id: 15873602
Transaction Id
981689
Contract Number
QG-1019M
Work Order Id
15873602
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
29.0
Units Used
36.0
Total Cost
1044.0
Transaction Date
2022-04-08T00:00:00.000
982575
Transaction Id: 982575 • Contract Number: BG-1419M • Work Order Id: 16708487
Transaction Id
982575
Contract Number
BG-1419M
Work Order Id
16708487
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
43.0
Units Used
42.5
Total Cost
1827.5
Transaction Date
2022-04-11T00:00:00.000
982680
Transaction Id: 982680 • Contract Number: BG-1419M • Work Order Id: 16803906
Transaction Id
982680
Contract Number
BG-1419M
Work Order Id
16803906
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
25.0
Total Cost
1000.0
Transaction Date
2022-04-19T00:00:00.000
982979
Transaction Id: 982979 • Contract Number: BG-1419M • Work Order Id: 16585275
Transaction Id
982979
Contract Number
BG-1419M
Work Order Id
16585275
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
43.0
Units Used
30.0
Total Cost
1290.0
Transaction Date
2022-04-15T00:00:00.000
983284
Transaction Id: 983284 • Contract Number: QG-1019M • Work Order Id: 15875572
Transaction Id
983284
Contract Number
QG-1019M
Work Order Id
15875572
Line Item Id
294.0
Item Number
29
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
300.0
Units Used
0.15
Total Cost
45.0
Transaction Date
2022-04-05T00:00:00.000
983769
Transaction Id: 983769 • Contract Number: QG-1119M • Work Order Id: 16630606
Transaction Id
983769
Contract Number
QG-1119M
Work Order Id
16630606
Line Item Id
630.0
Item Number
40
Line Item Description
STEEL TREE BED GUARD - D
Unit Of Measure
LF
Unit Price
135.0
Units Used
17.7
Total Cost
2389.5
Transaction Date
2022-07-19T00:00:00.000
983955
Transaction Id: 983955 • Contract Number: QG-1019M • Work Order Id: 15865496
Transaction Id
983955
Contract Number
QG-1019M
Work Order Id
15865496
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
29.0
Units Used
50.0
Total Cost
1450.0
Transaction Date
2022-04-11T00:00:00.000
985417
Transaction Id: 985417 • Contract Number: BG-1519M • Work Order Id: 17484794
Transaction Id
985417
Contract Number
BG-1519M
Work Order Id
17484794
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
40.0
Units Used
26.2
Total Cost
1048.0
Transaction Date
2022-06-06T00:00:00.000
985732
Transaction Id: 985732 • Contract Number: XG-319MR • Work Order Id: 15311143
Transaction Id
985732
Contract Number
XG-319MR
Work Order Id
15311143
Line Item Id
654.0
Item Number
11R
Line Item Description
PREPARING LAWN TREE BEDS (R)
Unit Of Measure
SF
Unit Price
41.0
Units Used
33.5
Total Cost
1373.5
Transaction Date
2022-06-21T00:00:00.000
986421
Transaction Id: 986421 • Contract Number: QG-1319M • Work Order Id: 668487
Transaction Id
986421
Contract Number
QG-1319M
Work Order Id
668487
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
40.0
Units Used
22.5
Total Cost
900.0
Transaction Date
2022-04-22T00:00:00.000
986922
Transaction Id: 986922 • Contract Number: QG-1319M • Work Order Id: 17036171
Transaction Id
986922
Contract Number
QG-1319M
Work Order Id
17036171
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
40.0
Units Used
30.0
Total Cost
1200.0
Transaction Date
2022-04-26T00:00:00.000
987827
Transaction Id: 987827 • Contract Number: BG-1319M • Work Order Id: 17074327
Transaction Id
987827
Contract Number
BG-1319M
Work Order Id
17074327
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
42.0
Units Used
29.9
Total Cost
1255.8
Transaction Date
2022-05-24T00:00:00.000
988334
Transaction Id: 988334 • Contract Number: BG-1219M • Work Order Id: 16862970
Transaction Id
988334
Contract Number
BG-1219M
Work Order Id
16862970
Line Item Id
721.0
Item Number
34
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
900.0
Units Used
0.32
Total Cost
288.0
Transaction Date
2022-05-27T00:00:00.000
988622
Transaction Id: 988622 • Contract Number: BG-1219M • Work Order Id: 17440150
Transaction Id
988622
Contract Number
BG-1219M
Work Order Id
17440150
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.0
Units Used
40.3
Total Cost
1894.1
Transaction Date
2022-05-11T00:00:00.000
990183
Transaction Id: 990183 • Contract Number: QG-1119M • Work Order Id: 10079821
Transaction Id
990183
Contract Number
QG-1119M
Work Order Id
10079821
Line Item Id
294.0
Item Number
29
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
250.0
Units Used
0.59
Total Cost
147.5
Transaction Date
2022-04-25T00:00:00.000
991818
Transaction Id: 991818 • Contract Number: XG-619M • Work Order Id: 14380618
Transaction Id
991818
Contract Number
XG-619M
Work Order Id
14380618
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
42.0
Units Used
11.3
Total Cost
474.6
Transaction Date
2022-06-03T00:00:00.000
991879
Transaction Id: 991879 • Contract Number: XG-619M • Work Order Id: 14383998
Transaction Id
991879
Contract Number
XG-619M
Work Order Id
14383998
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
43.3
Total Cost
1602.1
Transaction Date
2022-05-24T00:00:00.000
993283
Transaction Id: 993283 • Contract Number: BG-1619M • Work Order Id: 11667682
Transaction Id
993283
Contract Number
BG-1619M
Work Order Id
11667682
Line Item Id
721.0
Item Number
34
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
2500.0
Units Used
0.25
Total Cost
625.0
Transaction Date
2022-07-12T00:00:00.000
995963
Transaction Id: 995963 • Contract Number: BG-421M • Work Order Id: 15917555
Transaction Id
995963
Contract Number
BG-421M
Work Order Id
15917555
Line Item Id
293.0
Item Number
19
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
10.0
Units Used
28.0
Total Cost
280.0
Transaction Date
2022-06-24T00:00:00.000
996915
Transaction Id: 996915 • Contract Number: MG-1319MA • Work Order Id: 16202485
Transaction Id
996915
Contract Number
MG-1319MA
Work Order Id
16202485
Line Item Id
294.0
Item Number
29
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
255.0
Units Used
2.3
Total Cost
586.5
Transaction Date
2022-11-01T00:00:00.000
997811
Transaction Id: 997811 • Contract Number: QG-219MA • Work Order Id: 18344591
Transaction Id
997811
Contract Number
QG-219MA
Work Order Id
18344591
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
27.5
Units Used
33.3
Total Cost
915.7499999999999
Transaction Date
2022-10-11T00:00:00.000
998026
Transaction Id: 998026 • Contract Number: QG-219MA • Work Order Id: 10521649
Transaction Id
998026
Contract Number
QG-219MA
Work Order Id
10521649
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
27.5
Units Used
18.0
Total Cost
495.0
Transaction Date
2022-10-20T00:00:00.000
998269
Transaction Id: 998269 • Contract Number: QG-219MA • Work Order Id: 10834829
Transaction Id
998269
Contract Number
QG-219MA
Work Order Id
10834829
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
27.5
Units Used
36.0
Total Cost
990.0
Transaction Date
2022-10-21T00:00:00.000
1000188
Transaction Id: 1000188 • Contract Number: BG-1319M • Work Order Id: 17952777
Transaction Id
1000188
Contract Number
BG-1319M
Work Order Id
17952777
Line Item Id
293.0
Item Number
28
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
22.1
Total Cost
176.8
Transaction Date
2023-02-22T00:00:00.000
1000651
Transaction Id: 1000651 • Contract Number: BG-1319M • Work Order Id: 18344203
Transaction Id
1000651
Contract Number
BG-1319M
Work Order Id
18344203
Line Item Id
293.0
Item Number
28
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
31.2
Total Cost
249.6
Transaction Date
2023-02-21T00:00:00.000
1003132
Transaction Id: 1003132 • Contract Number: QG-1119M • Work Order Id: 19015807
Transaction Id
1003132
Contract Number
QG-1119M
Work Order Id
19015807
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
42.0
Units Used
26.5
Total Cost
1113.0
Transaction Date
2022-11-04T00:00:00.000
1003185
Transaction Id: 1003185 • Contract Number: BG-1319M • Work Order Id: 18057741
Transaction Id
1003185
Contract Number
BG-1319M
Work Order Id
18057741
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
42.0
Units Used
43.8
Total Cost
1839.6
Transaction Date
2022-11-07T00:00:00.000
1005035
Transaction Id: 1005035 • Contract Number: XG-619M • Work Order Id: 13248100
Transaction Id
1005035
Contract Number
XG-619M
Work Order Id
13248100
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
29.2
Total Cost
1080.3999999999999
Transaction Date
2022-11-14T00:00:00.000
1008110
Transaction Id: 1008110 • Contract Number: BG-122M • Work Order Id: 18444503
Transaction Id
1008110
Contract Number
BG-122M
Work Order Id
18444503
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
35.0
Units Used
44.1
Total Cost
1543.5
Transaction Date
2022-12-01T00:00:00.000
1008916
Transaction Id: 1008916 • Contract Number: BG-122M • Work Order Id: 18537794
Transaction Id
1008916
Contract Number
BG-122M
Work Order Id
18537794
Line Item Id
618.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
35.0
Units Used
8.9
Total Cost
311.5
Transaction Date
2022-12-19T00:00:00.000
1010803
Transaction Id: 1010803 • Contract Number: RG-519M • Work Order Id: 18969513
Transaction Id
1010803
Contract Number
RG-519M
Work Order Id
18969513
Line Item Id
706.0
Item Number
10
Line Item Description
PREPARING EXISTING TREE BEDS
Unit Of Measure
SF
Unit Price
30.0
Units Used
50.0
Total Cost
1500.0
Transaction Date
2022-12-30T00:00:00.000
1011949
Transaction Id: 1011949 • Contract Number: XG-619M • Work Order Id: 13953333
Transaction Id
1011949
Contract Number
XG-619M
Work Order Id
13953333
Line Item Id
294.0
Item Number
29
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
350.0
Units Used
0.36
Total Cost
126.0
Transaction Date
2022-12-29T00:00:00.000
1012129
Transaction Id: 1012129 • Contract Number: CNYG-1420MR • Work Order Id: 19498825
Transaction Id
1012129
Contract Number
CNYG-1420MR
Work Order Id
19498825
Line Item Id
627.0
Item Number
01
Line Item Description
STEEL TREE BED GUARD - A
Unit Of Measure
LF
Unit Price
102.13
Units Used
18.0
Total Cost
1838.34
Transaction Date
2024-10-28T00:00:00.000
1012582
Transaction Id: 1012582 • Contract Number: MG-1319MA • Work Order Id: 8717680
Transaction Id
1012582
Contract Number
MG-1319MA
Work Order Id
8717680
Line Item Id
294.0
Item Number
29
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
255.0
Units Used
0.85
Total Cost
216.75
Transaction Date
2023-01-18T00:00:00.000
1012912
Transaction Id: 1012912 • Contract Number: MG-1319MA • Work Order Id: 14883632
Transaction Id
1012912
Contract Number
MG-1319MA
Work Order Id
14883632
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
51.0
Units Used
33.3
Total Cost
1698.3
Transaction Date
2023-01-27T00:00:00.000
1013201
Transaction Id: 1013201 • Contract Number: MG-1319MA • Work Order Id: 18195684
Transaction Id
1013201
Contract Number
MG-1319MA
Work Order Id
18195684
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
45.8
Units Used
30.0
Total Cost
1374.0
Transaction Date
2023-01-10T00:00:00.000
1016597
Transaction Id: 1016597 • Contract Number: XG-619M • Work Order Id: 19859220
Transaction Id
1016597
Contract Number
XG-619M
Work Order Id
19859220
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
42.0
Units Used
50.0
Total Cost
2100.0
Transaction Date
2023-03-23T00:00:00.000
1016647
Transaction Id: 1016647 • Contract Number: XG-619M • Work Order Id: 19870661
Transaction Id
1016647
Contract Number
XG-619M
Work Order Id
19870661
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
28.0
Total Cost
1036.0
Transaction Date
2023-03-27T00:00:00.000
1017455
Transaction Id: 1017455 • Contract Number: RG-619M • Work Order Id: 19545879
Transaction Id
1017455
Contract Number
RG-619M
Work Order Id
19545879
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
50.0
Total Cost
1250.0
Transaction Date
2023-03-24T00:00:00.000
1017723
Transaction Id: 1017723 • Contract Number: XG-619M • Work Order Id: 19917659
Transaction Id
1017723
Contract Number
XG-619M
Work Order Id
19917659
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
42.0
Units Used
21.0
Total Cost
882.0
Transaction Date
2024-05-22T00:00:00.000
1017926
Transaction Id: 1017926 • Contract Number: XG-619M • Work Order Id: 19941311
Transaction Id
1017926
Contract Number
XG-619M
Work Order Id
19941311
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
38.0
Units Used
50.0
Total Cost
1900.0
Transaction Date
2023-04-17T00:00:00.000
1020389
Transaction Id: 1020389 • Contract Number: XG-519M • Work Order Id: 20072632
Transaction Id
1020389
Contract Number
XG-519M
Work Order Id
20072632
Line Item Id
294.0
Item Number
29
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
90.0
Units Used
1.57
Total Cost
141.3
Transaction Date
2023-04-03T00:00:00.000
NYC Data AI • Public-data exploration interface