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
755146
Transaction Id: 755146 • Contract Number: MG-214M • Work Order Id: 1439500
Transaction Id
755146
Contract Number
MG-214M
Work Order Id
1439500
Line Item Id
558.0
Item Number
42R
Line Item Description
STEEL TREE PIT GUARD - D (R)
Unit Of Measure
LF
Unit Price
66.0
Units Used
16.0
Total Cost
1056.0
Transaction Date
2017-07-06T00:00:00.000
755522
Transaction Id: 755522 • Contract Number: QG-214M • Work Order Id: 666109
Transaction Id
755522
Contract Number
QG-214M
Work Order Id
666109
Line Item Id
329.0
Item Number
08
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
13.0
Units Used
10.0
Total Cost
130.0
Transaction Date
2015-10-07T00:00:00.000
755571
Transaction Id: 755571 • Contract Number: QG-214M • Work Order Id: 884637
Transaction Id
755571
Contract Number
QG-214M
Work Order Id
884637
Line Item Id
314.0
Item Number
10
Line Item Description
Preparing Lawn Tree Pits
Unit Of Measure
SF
Unit Price
8.0
Units Used
27.0
Total Cost
216.0
Transaction Date
2015-10-08T00:00:00.000
755772
Transaction Id: 755772 • Contract Number: MG-414M • Work Order Id: 909840
Transaction Id
755772
Contract Number
MG-414M
Work Order Id
909840
Line Item Id
314.0
Item Number
10
Line Item Description
Preparing Lawn Tree Pits
Unit Of Measure
SF
Unit Price
8.0
Units Used
25.0
Total Cost
200.0
Transaction Date
2015-10-13T00:00:00.000
756811
Transaction Id: 756811 • Contract Number: XG-115M • Work Order Id: 785411
Transaction Id
756811
Contract Number
XG-115M
Work Order Id
785411
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
28.8
Total Cost
230.4
Transaction Date
2015-10-26T00:00:00.000
758392
Transaction Id: 758392 • Contract Number: BG-415M • Work Order Id: 631429
Transaction Id
758392
Contract Number
BG-415M
Work Order Id
631429
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
36.0
Total Cost
360.0
Transaction Date
2015-11-05T00:00:00.000
760063
Transaction Id: 760063 • Contract Number: RG-115M • Work Order Id: 652335
Transaction Id
760063
Contract Number
RG-115M
Work Order Id
652335
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
15.0
Units Used
25.0
Total Cost
375.0
Transaction Date
2015-11-16T00:00:00.000
764467
Transaction Id: 764467 • Contract Number: XG-215M • Work Order Id: 688149
Transaction Id
764467
Contract Number
XG-215M
Work Order Id
688149
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
25.0
Total Cost
275.0
Transaction Date
2015-12-28T00:00:00.000
765152
Transaction Id: 765152 • Contract Number: XG-215M • Work Order Id: 1813939
Transaction Id
765152
Contract Number
XG-215M
Work Order Id
1813939
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
2.0
Units Used
10.5
Total Cost
21.0
Transaction Date
2015-11-25T00:00:00.000
765357
Transaction Id: 765357 • Contract Number: XG-115M • Work Order Id: 1443901
Transaction Id
765357
Contract Number
XG-115M
Work Order Id
1443901
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
36.0
Total Cost
612.0
Transaction Date
2015-11-24T00:00:00.000
772131
Transaction Id: 772131 • Contract Number: QG-315M • Work Order Id: 795832
Transaction Id
772131
Contract Number
QG-315M
Work Order Id
795832
Line Item Id
289.0
Item Number
22
Line Item Description
REMOVE DEBRIS (TREE PIT AND CANOPY)
Unit Of Measure
HR
Unit Price
80.0
Units Used
0.5
Total Cost
40.0
Transaction Date
2016-01-13T00:00:00.000
772492
Transaction Id: 772492 • Contract Number: QG-315M • Work Order Id: 909440
Transaction Id
772492
Contract Number
QG-315M
Work Order Id
909440
Line Item Id
636.0
Item Number
11R
Line Item Description
PREPARING LAWN TREE PITS (R)
Unit Of Measure
SF
Unit Price
12.0
Units Used
27.0
Total Cost
324.0
Transaction Date
2016-03-16T00:00:00.000
773279
Transaction Id: 773279 • Contract Number: QG-315M • Work Order Id: 1097059
Transaction Id
773279
Contract Number
QG-315M
Work Order Id
1097059
Line Item Id
636.0
Item Number
11R
Line Item Description
PREPARING LAWN TREE PITS (R)
Unit Of Measure
SF
Unit Price
12.0
Units Used
26.0
Total Cost
312.0
Transaction Date
2016-03-16T00:00:00.000
774028
Transaction Id: 774028 • Contract Number: QG-315M • Work Order Id: 1301868
Transaction Id
774028
Contract Number
QG-315M
Work Order Id
1301868
Line Item Id
636.0
Item Number
11R
Line Item Description
PREPARING LAWN TREE PITS (R)
Unit Of Measure
SF
Unit Price
12.0
Units Used
28.0
Total Cost
336.0
Transaction Date
2016-03-09T00:00:00.000
777000
Transaction Id: 777000 • Contract Number: MG-414M • Work Order Id: 680529
Transaction Id
777000
Contract Number
MG-414M
Work Order Id
680529
Line Item Id
330.0
Item Number
09
Line Item Description
Preparing Existing Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
9.0
Units Used
25.0
Total Cost
225.0
Transaction Date
2015-10-23T00:00:00.000
777164
Transaction Id: 777164 • Contract Number: BG-315M • Work Order Id: 2220409
Transaction Id
777164
Contract Number
BG-315M
Work Order Id
2220409
Line Item Id
294.0
Item Number
27
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
70.0
Units Used
1.81
Total Cost
126.7
Transaction Date
2015-12-31T00:00:00.000
777226
Transaction Id: 777226 • Contract Number: BG-315M • Work Order Id: 2111189
Transaction Id
777226
Contract Number
BG-315M
Work Order Id
2111189
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.2
Total Cost
1204.0
Transaction Date
2016-07-06T00:00:00.000
777622
Transaction Id: 777622 • Contract Number: CNYG-414M • Work Order Id: 1217850
Transaction Id
777622
Contract Number
CNYG-414M
Work Order Id
1217850
Line Item Id
352.0
Item Number
36K
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
75.0
Units Used
18.0
Total Cost
1350.0
Transaction Date
2016-07-13T00:00:00.000
778371
Transaction Id: 778371 • Contract Number: CNYG-414M • Work Order Id: 1072326
Transaction Id
778371
Contract Number
CNYG-414M
Work Order Id
1072326
Line Item Id
352.0
Item Number
36K
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
75.0
Units Used
18.3
Total Cost
1372.5
Transaction Date
2016-08-01T00:00:00.000
779005
Transaction Id: 779005 • Contract Number: QG-315M • Work Order Id: 1162658
Transaction Id
779005
Contract Number
QG-315M
Work Order Id
1162658
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
16.0
Units Used
24.0
Total Cost
384.0
Transaction Date
2016-01-18T00:00:00.000
779321
Transaction Id: 779321 • Contract Number: QG-214M • Work Order Id: 676105
Transaction Id
779321
Contract Number
QG-214M
Work Order Id
676105
Line Item Id
314.0
Item Number
10
Line Item Description
Preparing Lawn Tree Pits
Unit Of Measure
SF
Unit Price
8.0
Units Used
20.6
Total Cost
164.8
Transaction Date
2015-12-15T00:00:00.000
779635
Transaction Id: 779635 • Contract Number: QG-214M • Work Order Id: 787028
Transaction Id
779635
Contract Number
QG-214M
Work Order Id
787028
Line Item Id
314.0
Item Number
10
Line Item Description
Preparing Lawn Tree Pits
Unit Of Measure
SF
Unit Price
8.0
Units Used
25.0
Total Cost
200.0
Transaction Date
2015-12-22T00:00:00.000
781823
Transaction Id: 781823 • Contract Number: QG-315M • Work Order Id: 1307064
Transaction Id
781823
Contract Number
QG-315M
Work Order Id
1307064
Line Item Id
636.0
Item Number
11R
Line Item Description
PREPARING LAWN TREE PITS (R)
Unit Of Measure
SF
Unit Price
12.0
Units Used
27.0
Total Cost
324.0
Transaction Date
2016-03-09T00:00:00.000
783485
Transaction Id: 783485 • Contract Number: QG-1115M • Work Order Id: 2356078
Transaction Id
783485
Contract Number
QG-1115M
Work Order Id
2356078
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
13.2
Total Cost
264.0
Transaction Date
2016-04-25T00:00:00.000
784483
Transaction Id: 784483 • Contract Number: QG-1115M • Work Order Id: 2928551
Transaction Id
784483
Contract Number
QG-1115M
Work Order Id
2928551
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
13.0
Units Used
4.6
Total Cost
59.8
Transaction Date
2016-09-07T00:00:00.000
785191
Transaction Id: 785191 • Contract Number: XG-515M • Work Order Id: 794636
Transaction Id
785191
Contract Number
XG-515M
Work Order Id
794636
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
18.0
Units Used
41.7
Total Cost
750.6
Transaction Date
2016-05-09T00:00:00.000
785895
Transaction Id: 785895 • Contract Number: MG-715M • Work Order Id: 2826421
Transaction Id
785895
Contract Number
MG-715M
Work Order Id
2826421
Line Item Id
292.0
Item Number
25
Line Item Description
SHREDDED BARK MULCH
Unit Of Measure
SY
Unit Price
12.0
Units Used
1.7
Total Cost
20.4
Transaction Date
2016-04-14T00:00:00.000
786576
Transaction Id: 786576 • Contract Number: BG-115M • Work Order Id: 734133
Transaction Id
786576
Contract Number
BG-115M
Work Order Id
734133
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
75.0
Units Used
15.4
Total Cost
1155.0
Transaction Date
2016-04-15T00:00:00.000
787341
Transaction Id: 787341 • Contract Number: BG-1115M • Work Order Id: 2750215
Transaction Id
787341
Contract Number
BG-1115M
Work Order Id
2750215
Line Item Id
629.0
Item Number
36
Line Item Description
STEEL TREE BED GUARD - C
Unit Of Measure
LF
Unit Price
65.0
Units Used
15.5
Total Cost
1007.5
Transaction Date
2016-07-07T00:00:00.000
787491
Transaction Id: 787491 • Contract Number: BG-1115M • Work Order Id: 2781331
Transaction Id
787491
Contract Number
BG-1115M
Work Order Id
2781331
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
22.0
Units Used
28.0
Total Cost
616.0
Transaction Date
2016-04-01T00:00:00.000
788343
Transaction Id: 788343 • Contract Number: BG-1115M • Work Order Id: 1058641
Transaction Id
788343
Contract Number
BG-1115M
Work Order Id
1058641
Line Item Id
629.0
Item Number
36
Line Item Description
STEEL TREE BED GUARD - C
Unit Of Measure
LF
Unit Price
65.0
Units Used
17.75
Total Cost
1153.75
Transaction Date
2016-06-20T00:00:00.000
788494
Transaction Id: 788494 • Contract Number: BG-215M • Work Order Id: 659212
Transaction Id
788494
Contract Number
BG-215M
Work Order Id
659212
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
17.0
Units Used
37.0
Total Cost
629.0
Transaction Date
2016-06-03T00:00:00.000
788704
Transaction Id: 788704 • Contract Number: BG-215M • Work Order Id: 737336
Transaction Id
788704
Contract Number
BG-215M
Work Order Id
737336
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
74.0
Units Used
16.0
Total Cost
1184.0
Transaction Date
2017-01-18T00:00:00.000
789079
Transaction Id: 789079 • Contract Number: BG-215M • Work Order Id: 799824
Transaction Id
789079
Contract Number
BG-215M
Work Order Id
799824
Line Item Id
314.0
Item Number
11
Line Item Description
Preparing Lawn Tree Pits
Unit Of Measure
SF
Unit Price
13.0
Units Used
20.4
Total Cost
265.2
Transaction Date
2016-06-03T00:00:00.000
790810
Transaction Id: 790810 • Contract Number: BG-1015M • Work Order Id: 2626697
Transaction Id
790810
Contract Number
BG-1015M
Work Order Id
2626697
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
18.0
Total Cost
144.0
Transaction Date
2016-05-09T00:00:00.000
791336
Transaction Id: 791336 • Contract Number: BG-1015M • Work Order Id: 2813102
Transaction Id
791336
Contract Number
BG-1015M
Work Order Id
2813102
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
15.0
Total Cost
120.0
Transaction Date
2016-08-23T00:00:00.000
791947
Transaction Id: 791947 • Contract Number: BG-1115M • Work Order Id: 823453
Transaction Id
791947
Contract Number
BG-1115M
Work Order Id
823453
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
9.3
Total Cost
74.4
Transaction Date
2016-04-19T00:00:00.000
792522
Transaction Id: 792522 • Contract Number: XG-515M • Work Order Id: 2772545
Transaction Id
792522
Contract Number
XG-515M
Work Order Id
2772545
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
4.75
Units Used
2.0
Total Cost
9.5
Transaction Date
2016-08-09T00:00:00.000
795010
Transaction Id: 795010 • Contract Number: BG-1215M • Work Order Id: 652331
Transaction Id
795010
Contract Number
BG-1215M
Work Order Id
652331
Line Item Id
628.0
Item Number
35
Line Item Description
STEEL TREE BED GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.0
Total Cost
1120.0
Transaction Date
2016-08-12T00:00:00.000
795285
Transaction Id: 795285 • Contract Number: BG-1215M • Work Order Id: 691712
Transaction Id
795285
Contract Number
BG-1215M
Work Order Id
691712
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
7.0
Units Used
18.5
Total Cost
129.5
Transaction Date
2016-05-16T00:00:00.000
795365
Transaction Id: 795365 • Contract Number: BG-1215M • Work Order Id: 693725
Transaction Id
795365
Contract Number
BG-1215M
Work Order Id
693725
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
46.7
Total Cost
747.2
Transaction Date
2016-05-02T00:00:00.000
795731
Transaction Id: 795731 • Contract Number: BG-1215M • Work Order Id: 788638
Transaction Id
795731
Contract Number
BG-1215M
Work Order Id
788638
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
35.0
Total Cost
700.0
Transaction Date
2016-06-07T00:00:00.000
795930
Transaction Id: 795930 • Contract Number: BG-1215M • Work Order Id: 2763483
Transaction Id
795930
Contract Number
BG-1215M
Work Order Id
2763483
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
28.3
Total Cost
452.8
Transaction Date
2016-04-25T00:00:00.000
796150
Transaction Id: 796150 • Contract Number: BG-1215M • Work Order Id: 3132014
Transaction Id
796150
Contract Number
BG-1215M
Work Order Id
3132014
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
14.0
Total Cost
280.0
Transaction Date
2016-05-02T00:00:00.000
796356
Transaction Id: 796356 • Contract Number: QG-1315M • Work Order Id: 2973447
Transaction Id
796356
Contract Number
QG-1315M
Work Order Id
2973447
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
15.0
Units Used
22.5
Total Cost
337.5
Transaction Date
2016-06-10T00:00:00.000
798209
Transaction Id: 798209 • Contract Number: XG-615M • Work Order Id: 2527750
Transaction Id
798209
Contract Number
XG-615M
Work Order Id
2527750
Line Item Id
627.0
Item Number
34
Line Item Description
STEEL TREE BED GUARD - A
Unit Of Measure
LF
Unit Price
75.0
Units Used
14.8
Total Cost
1110.0
Transaction Date
2016-10-13T00:00:00.000
799216
Transaction Id: 799216 • Contract Number: XG-615M • Work Order Id: 2804520
Transaction Id
799216
Contract Number
XG-615M
Work Order Id
2804520
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
40.0
Total Cost
640.0
Transaction Date
2016-06-20T00:00:00.000
800444
Transaction Id: 800444 • Contract Number: QG-1315M • Work Order Id: 2990294
Transaction Id
800444
Contract Number
QG-1315M
Work Order Id
2990294
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
15.0
Units Used
14.5
Total Cost
217.5
Transaction Date
2016-09-23T00:00:00.000
800849
Transaction Id: 800849 • Contract Number: MG-715M • Work Order Id: 2828066
Transaction Id
800849
Contract Number
MG-715M
Work Order Id
2828066
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
5.5
Total Cost
110.0
Transaction Date
2016-05-17T00:00:00.000
801460
Transaction Id: 801460 • Contract Number: RG-615M • Work Order Id: 651156
Transaction Id
801460
Contract Number
RG-615M
Work Order Id
651156
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
15.0
Units Used
25.0
Total Cost
375.0
Transaction Date
2016-06-06T00:00:00.000
NYC Data AI • Public-data exploration interface