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
899504
Transaction Id: 899504 • Contract Number: BG-319MA • Work Order Id: 9577438
Transaction Id
899504
Contract Number
BG-319MA
Work Order Id
9577438
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
4.8
Total Cost
38.4
Transaction Date
2021-04-01T00:00:00.000
906558
Transaction Id: 906558 • Contract Number: QG-716MR • Work Order Id: 8552971
Transaction Id
906558
Contract Number
QG-716MR
Work Order Id
8552971
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
15.0
Units Used
5.6
Total Cost
84.0
Transaction Date
2019-06-27T00:00:00.000
908246
Transaction Id: 908246 • Contract Number: BG-518M • Work Order Id: 10218372
Transaction Id
908246
Contract Number
BG-518M
Work Order Id
10218372
Line Item Id
628.0
Item Number
35
Line Item Description
STEEL TREE BED GUARD - B
Unit Of Measure
LF
Unit Price
90.0
Units Used
18.0
Total Cost
1620.0
Transaction Date
2019-10-21T00:00:00.000
909186
Transaction Id: 909186 • Contract Number: BG-619M • Work Order Id: 7669970
Transaction Id
909186
Contract Number
BG-619M
Work Order Id
7669970
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
42.0
Units Used
50.0
Total Cost
2100.0
Transaction Date
2019-11-06T00:00:00.000
910352
Transaction Id: 910352 • Contract Number: BG-418M • Work Order Id: 10017067
Transaction Id
910352
Contract Number
BG-418M
Work Order Id
10017067
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
51.2
Total Cost
2048.0
Transaction Date
2019-09-18T00:00:00.000
911933
Transaction Id: 911933 • Contract Number: MG-219M • Work Order Id: 8069111
Transaction Id
911933
Contract Number
MG-219M
Work Order Id
8069111
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
15.0
Units Used
12.5
Total Cost
187.5
Transaction Date
2019-09-23T00:00:00.000
913233
Transaction Id: 913233 • Contract Number: MG-219M • Work Order Id: 8414795
Transaction Id
913233
Contract Number
MG-219M
Work Order Id
8414795
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
54.0
Units Used
24.6
Total Cost
1328.4
Transaction Date
2020-02-13T00:00:00.000
918913
Transaction Id: 918913 • Contract Number: MG-319M • Work Order Id: 10188950
Transaction Id
918913
Contract Number
MG-319M
Work Order Id
10188950
Line Item Id
294.0
Item Number
27
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
125.0
Units Used
1.08
Total Cost
135.0
Transaction Date
2019-10-18T00:00:00.000
920250
Transaction Id: 920250 • Contract Number: XG-118MA • Work Order Id: 10426856
Transaction Id
920250
Contract Number
XG-118MA
Work Order Id
10426856
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
28.3
Total Cost
1301.8
Transaction Date
2019-11-04T00:00:00.000
923268
Transaction Id: 923268 • Contract Number: BG-518M • Work Order Id: 10495331
Transaction Id
923268
Contract Number
BG-518M
Work Order Id
10495331
Line Item Id
630.0
Item Number
37
Line Item Description
STEEL TREE BED GUARD - D
Unit Of Measure
LF
Unit Price
90.0
Units Used
16.7
Total Cost
1503.0
Transaction Date
2019-11-21T00:00:00.000
923689
Transaction Id: 923689 • Contract Number: QG-816MR • Work Order Id: 8406781
Transaction Id
923689
Contract Number
QG-816MR
Work Order Id
8406781
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
16.0
Units Used
27.5
Total Cost
440.0
Transaction Date
2019-04-23T00:00:00.000
924388
Transaction Id: 924388 • Contract Number: QG-816MR • Work Order Id: 8615751
Transaction Id
924388
Contract Number
QG-816MR
Work Order Id
8615751
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
16.0
Units Used
26.3
Total Cost
420.8
Transaction Date
2019-05-06T00:00:00.000
925669
Transaction Id: 925669 • Contract Number: QG-118MA • Work Order Id: 5904302
Transaction Id
925669
Contract Number
QG-118MA
Work Order Id
5904302
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.0
Total Cost
1092.0
Transaction Date
2019-10-24T00:00:00.000
925875
Transaction Id: 925875 • Contract Number: QG-118MA • Work Order Id: 6917201
Transaction Id
925875
Contract Number
QG-118MA
Work Order Id
6917201
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
30.0
Total Cost
1260.0
Transaction Date
2020-02-24T00:00:00.000
927953
Transaction Id: 927953 • Contract Number: QG-118MA • Work Order Id: 8777255
Transaction Id
927953
Contract Number
QG-118MA
Work Order Id
8777255
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
27.0
Total Cost
1134.0
Transaction Date
2020-03-02T00:00:00.000
930426
Transaction Id: 930426 • Contract Number: CNYG-1417MA • Work Order Id: 10426807
Transaction Id
930426
Contract Number
CNYG-1417MA
Work Order Id
10426807
Line Item Id
706.0
Item Number
10
Line Item Description
PREPARING EXISTING TREE BEDS
Unit Of Measure
SF
Unit Price
44.0
Units Used
34.0
Total Cost
1496.0
Transaction Date
2019-12-16T00:00:00.000
930902
Transaction Id: 930902 • Contract Number: XG-118MA • Work Order Id: 8068917
Transaction Id
930902
Contract Number
XG-118MA
Work Order Id
8068917
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
23.7
Total Cost
1090.2
Transaction Date
2019-12-13T00:00:00.000
931740
Transaction Id: 931740 • Contract Number: BG-519M • Work Order Id: 8237083
Transaction Id
931740
Contract Number
BG-519M
Work Order Id
8237083
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
48.0
Units Used
50.0
Total Cost
2400.0
Transaction Date
2020-01-17T00:00:00.000
933783
Transaction Id: 933783 • Contract Number: MG-1319MA • Work Order Id: 10517196
Transaction Id
933783
Contract Number
MG-1319MA
Work Order Id
10517196
Line Item Id
293.0
Item Number
28
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
10.0
Units Used
30.8
Total Cost
308.0
Transaction Date
2024-10-18T00:00:00.000
934081
Transaction Id: 934081 • Contract Number: MG-319M • Work Order Id: 7435288
Transaction Id
934081
Contract Number
MG-319M
Work Order Id
7435288
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
54.0
Units Used
10.0
Total Cost
540.0
Transaction Date
2020-01-22T00:00:00.000
934917
Transaction Id: 934917 • Contract Number: MG-319M • Work Order Id: 9665520
Transaction Id
934917
Contract Number
MG-319M
Work Order Id
9665520
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
15.0
Units Used
25.6
Total Cost
384.0
Transaction Date
2020-01-15T00:00:00.000
936007
Transaction Id: 936007 • Contract Number: BG-619M • Work Order Id: 10329016
Transaction Id
936007
Contract Number
BG-619M
Work Order Id
10329016
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
35.0
Units Used
30.0
Total Cost
1050.0
Transaction Date
2020-02-12T00:00:00.000
938147
Transaction Id: 938147 • Contract Number: BG-519M • Work Order Id: 10634929
Transaction Id
938147
Contract Number
BG-519M
Work Order Id
10634929
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
48.0
Units Used
50.0
Total Cost
2400.0
Transaction Date
2020-03-19T00:00:00.000
938543
Transaction Id: 938543 • Contract Number: BG-519M • Work Order Id: 11115343
Transaction Id
938543
Contract Number
BG-519M
Work Order Id
11115343
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
35.0
Units Used
28.3
Total Cost
990.5
Transaction Date
2020-03-20T00:00:00.000
939231
Transaction Id: 939231 • Contract Number: QG-519M • Work Order Id: 7182690
Transaction Id
939231
Contract Number
QG-519M
Work Order Id
7182690
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
27.0
Total Cost
1134.0
Transaction Date
2020-06-24T00:00:00.000
939947
Transaction Id: 939947 • Contract Number: QG-519M • Work Order Id: 9356154
Transaction Id
939947
Contract Number
QG-519M
Work Order Id
9356154
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
30.0
Total Cost
1260.0
Transaction Date
2020-06-29T00:00:00.000
940682
Transaction Id: 940682 • Contract Number: BG-819M • Work Order Id: 11883973
Transaction Id
940682
Contract Number
BG-819M
Work Order Id
11883973
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
35.0
Units Used
20.0
Total Cost
700.0
Transaction Date
2020-06-19T00:00:00.000
942888
Transaction Id: 942888 • Contract Number: XG-118MA • Work Order Id: 11311740
Transaction Id
942888
Contract Number
XG-118MA
Work Order Id
11311740
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
45.0
Units Used
25.0
Total Cost
1125.0
Transaction Date
2020-08-25T00:00:00.000
942978
Transaction Id: 942978 • Contract Number: XG-118MA • Work Order Id: 9474881
Transaction Id
942978
Contract Number
XG-118MA
Work Order Id
9474881
Line Item Id
571.0
Item Number
26R
Line Item Description
SAW CUT PAVEMENT (R)
Unit Of Measure
LF
Unit Price
12.0
Units Used
20.0
Total Cost
240.0
Transaction Date
2020-09-02T00:00:00.000
943588
Transaction Id: 943588 • Contract Number: XG-319M • Work Order Id: 9450547
Transaction Id
943588
Contract Number
XG-319M
Work Order Id
9450547
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
45.0
Units Used
30.0
Total Cost
1350.0
Transaction Date
2020-09-28T00:00:00.000
945347
Transaction Id: 945347 • Contract Number: QG-319M • Work Order Id: 10233208
Transaction Id
945347
Contract Number
QG-319M
Work Order Id
10233208
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
20.0
Units Used
10.0
Total Cost
200.0
Transaction Date
2020-10-19T00:00:00.000
948180
Transaction Id: 948180 • Contract Number: QG-319M • Work Order Id: 10267443
Transaction Id
948180
Contract Number
QG-319M
Work Order Id
10267443
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
30.5
Units Used
29.2
Total Cost
890.6
Transaction Date
2020-11-04T00:00:00.000
949280
Transaction Id: 949280 • Contract Number: MG-319M • Work Order Id: 9946518
Transaction Id
949280
Contract Number
MG-319M
Work Order Id
9946518
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
15.0
Units Used
23.3
Total Cost
349.5
Transaction Date
2020-12-03T00:00:00.000
950468
Transaction Id: 950468 • Contract Number: QG-519M • Work Order Id: 12909051
Transaction Id
950468
Contract Number
QG-519M
Work Order Id
12909051
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
28.6
Total Cost
1201.2
Transaction Date
2020-12-21T00:00:00.000
952202
Transaction Id: 952202 • Contract Number: QG-321M • Work Order Id: 9406055
Transaction Id
952202
Contract Number
QG-321M
Work Order Id
9406055
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
35.5
Units Used
35.0
Total Cost
1242.5
Transaction Date
2021-12-27T00:00:00.000
954621
Transaction Id: 954621 • Contract Number: XG-319M • Work Order Id: 9033077
Transaction Id
954621
Contract Number
XG-319M
Work Order Id
9033077
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
20.0
Total Cost
920.0
Transaction Date
2021-04-29T00:00:00.000
955227
Transaction Id: 955227 • Contract Number: XG-319M • Work Order Id: 13722038
Transaction Id
955227
Contract Number
XG-319M
Work Order Id
13722038
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
49.6
Total Cost
2281.6
Transaction Date
2021-04-26T00:00:00.000
955453
Transaction Id: 955453 • Contract Number: BG-719M • Work Order Id: 8973772
Transaction Id
955453
Contract Number
BG-719M
Work Order Id
8973772
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
36.0
Total Cost
1332.0
Transaction Date
2021-05-03T00:00:00.000
956089
Transaction Id: 956089 • Contract Number: BG-719M • Work Order Id: 12814351
Transaction Id
956089
Contract Number
BG-719M
Work Order Id
12814351
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
50.0
Total Cost
2150.0
Transaction Date
2021-04-27T00:00:00.000
958038
Transaction Id: 958038 • Contract Number: BG-319MA • Work Order Id: 14247548
Transaction Id
958038
Contract Number
BG-319MA
Work Order Id
14247548
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
50.0
Units Used
51.7
Total Cost
2585.0
Transaction Date
2021-09-03T00:00:00.000
960183
Transaction Id: 960183 • Contract Number: QG-1119MR • Work Order Id: 9468137
Transaction Id
960183
Contract Number
QG-1119MR
Work Order Id
9468137
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
43.68
Units Used
28.0
Total Cost
1223.04
Transaction Date
2024-11-19T00:00:00.000
961659
Transaction Id: 961659 • Contract Number: BG-1219M • Work Order Id: 10536116
Transaction Id
961659
Contract Number
BG-1219M
Work Order Id
10536116
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
32.6
Total Cost
1532.2
Transaction Date
2021-11-04T00:00:00.000
966213
Transaction Id: 966213 • Contract Number: QG-319MR • Work Order Id: 8591371
Transaction Id
966213
Contract Number
QG-319MR
Work Order Id
8591371
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
31.5
Total Cost
999.18
Transaction Date
2021-11-08T00:00:00.000
967061
Transaction Id: 967061 • Contract Number: QG-1219M • Work Order Id: 14009260
Transaction Id
967061
Contract Number
QG-1219M
Work Order Id
14009260
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
26.3
Total Cost
973.1
Transaction Date
2021-11-23T00:00:00.000
968225
Transaction Id: 968225 • Contract Number: QG-1219M • Work Order Id: 14898668
Transaction Id
968225
Contract Number
QG-1219M
Work Order Id
14898668
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
35.0
Total Cost
1295.0
Transaction Date
2022-01-13T00:00:00.000
970403
Transaction Id: 970403 • Contract Number: MG-121M • Work Order Id: 13145311
Transaction Id
970403
Contract Number
MG-121M
Work Order Id
13145311
Line Item Id
294.0
Item Number
18
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
198.0
Units Used
2.1
Total Cost
415.8
Transaction Date
2022-01-06T00:00:00.000
970795
Transaction Id: 970795 • Contract Number: MG-221M • Work Order Id: 11288419
Transaction Id
970795
Contract Number
MG-221M
Work Order Id
11288419
Line Item Id
721.0
Item Number
22
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
3000.0
Units Used
0.13
Total Cost
390.0
Transaction Date
2022-03-30T00:00:00.000
970876
Transaction Id: 970876 • Contract Number: RG-221M • Work Order Id: 13139722
Transaction Id
970876
Contract Number
RG-221M
Work Order Id
13139722
Line Item Id
706.0
Item Number
09
Line Item Description
PREPARING EXISTING TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
33.1
Total Cost
827.5
Transaction Date
2021-12-16T00:00:00.000
971619
Transaction Id: 971619 • Contract Number: BG-1219M • Work Order Id: 14556919
Transaction Id
971619
Contract Number
BG-1219M
Work Order Id
14556919
Line Item Id
721.0
Item Number
34
Line Item Description
CONCRETE CURB
Unit Of Measure
CY
Unit Price
900.0
Units Used
0.06
Total Cost
54.0
Transaction Date
2021-12-23T00:00:00.000
973129
Transaction Id: 973129 • Contract Number: BG-1519M • Work Order Id: 12817557
Transaction Id
973129
Contract Number
BG-1519M
Work Order Id
12817557
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
39.9
Total Cost
1596.0
Transaction Date
2022-01-03T00:00:00.000
NYC Data AI • Public-data exploration interface