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
802007
Transaction Id: 802007 • Contract Number: RG-615M • Work Order Id: 2611841
Transaction Id
802007
Contract Number
RG-615M
Work Order Id
2611841
Line Item Id
628.0
Item Number
37
Line Item Description
STEEL TREE BED GUARD - B
Unit Of Measure
LF
Unit Price
75.0
Units Used
15.3
Total Cost
1147.5
Transaction Date
2017-04-29T00:00:00.000
802276
Transaction Id: 802276 • Contract Number: RG-615M • Work Order Id: 3037513
Transaction Id
802276
Contract Number
RG-615M
Work Order Id
3037513
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
50.0
Total Cost
900.0
Transaction Date
2016-06-15T00:00:00.000
802828
Transaction Id: 802828 • Contract Number: QG-1315M • Work Order Id: 2902924
Transaction Id
802828
Contract Number
QG-1315M
Work Order Id
2902924
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.7
Total Cost
385.5
Transaction Date
2016-09-12T00:00:00.000
803401
Transaction Id: 803401 • Contract Number: MG-715M • Work Order Id: 3260489
Transaction Id
803401
Contract Number
MG-715M
Work Order Id
3260489
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
11.0
Total Cost
220.0
Transaction Date
2016-06-03T00:00:00.000
803723
Transaction Id: 803723 • Contract Number: MG-715M • Work Order Id: 1190649
Transaction Id
803723
Contract Number
MG-715M
Work Order Id
1190649
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
16.0
Units Used
44.0
Total Cost
704.0
Transaction Date
2016-06-01T00:00:00.000
804169
Transaction Id: 804169 • Contract Number: BG-1015M • Work Order Id: 2649066
Transaction Id
804169
Contract Number
BG-1015M
Work Order Id
2649066
Line Item Id
624.0
Item Number
21
Line Item Description
REMOVE BLOCK AND/OR STONE PAVEMENT
Unit Of Measure
SF
Unit Price
5.0
Units Used
15.0
Total Cost
75.0
Transaction Date
2016-06-13T00:00:00.000
805820
Transaction Id: 805820 • Contract Number: QG-1215M • Work Order Id: 2639446
Transaction Id
805820
Contract Number
QG-1215M
Work Order Id
2639446
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
25.0
Total Cost
300.0
Transaction Date
2017-03-28T00:00:00.000
807298
Transaction Id: 807298 • Contract Number: BG-1015M • Work Order Id: 3951580
Transaction Id
807298
Contract Number
BG-1015M
Work Order Id
3951580
Line Item Id
628.0
Item Number
35
Line Item Description
STEEL TREE BED GUARD - B
Unit Of Measure
LF
Unit Price
75.0
Units Used
14.0
Total Cost
1050.0
Transaction Date
2016-09-01T00:00:00.000
808034
Transaction Id: 808034 • Contract Number: MG-715M • Work Order Id: 4152580
Transaction Id
808034
Contract Number
MG-715M
Work Order Id
4152580
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
16.0
Units Used
40.0
Total Cost
640.0
Transaction Date
2016-11-14T00:00:00.000
808317
Transaction Id: 808317 • Contract Number: MG-715M • Work Order Id: 4288775
Transaction Id
808317
Contract Number
MG-715M
Work Order Id
4288775
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
12.0
Units Used
27.5
Total Cost
330.0
Transaction Date
2016-11-22T00:00:00.000
808865
Transaction Id: 808865 • Contract Number: QG-1315M • Work Order Id: 3887035
Transaction Id
808865
Contract Number
QG-1315M
Work Order Id
3887035
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
50.0
Total Cost
750.0
Transaction Date
2016-11-29T00:00:00.000
809111
Transaction Id: 809111 • Contract Number: QG-1315M • Work Order Id: 3975119
Transaction Id
809111
Contract Number
QG-1315M
Work Order Id
3975119
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
32.0
Total Cost
480.0
Transaction Date
2016-10-24T00:00:00.000
809177
Transaction Id: 809177 • Contract Number: QG-1315M • Work Order Id: 4099706
Transaction Id
809177
Contract Number
QG-1315M
Work Order Id
4099706
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
27.5
Total Cost
412.5
Transaction Date
2016-10-25T00:00:00.000
809451
Transaction Id: 809451 • Contract Number: QG-1315M • Work Order Id: 4169814
Transaction Id
809451
Contract Number
QG-1315M
Work Order Id
4169814
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
12.5
Total Cost
187.5
Transaction Date
2016-11-03T00:00:00.000
810147
Transaction Id: 810147 • Contract Number: BG-1115M • Work Order Id: 4263874
Transaction Id
810147
Contract Number
BG-1115M
Work Order Id
4263874
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
18.5
Total Cost
1202.5
Transaction Date
2017-01-17T00:00:00.000
812997
Transaction Id: 812997 • Contract Number: BG-1115M • Work Order Id: 2866953
Transaction Id
812997
Contract Number
BG-1115M
Work Order Id
2866953
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
18.1
Total Cost
271.5
Transaction Date
2016-11-08T00:00:00.000
813333
Transaction Id: 813333 • Contract Number: BG-1015M • Work Order Id: 3965737
Transaction Id
813333
Contract Number
BG-1015M
Work Order Id
3965737
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
19.0
Total Cost
152.0
Transaction Date
2016-09-15T00:00:00.000
813978
Transaction Id: 813978 • Contract Number: BG-1015M • Work Order Id: 4167439
Transaction Id
813978
Contract Number
BG-1015M
Work Order Id
4167439
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
19.8
Total Cost
158.4
Transaction Date
2016-09-23T00:00:00.000
814529
Transaction Id: 814529 • Contract Number: BG-1315M • Work Order Id: 3923374
Transaction Id
814529
Contract Number
BG-1315M
Work Order Id
3923374
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
7.0
Units Used
19.5
Total Cost
136.5
Transaction Date
2016-09-07T00:00:00.000
814643
Transaction Id: 814643 • Contract Number: BG-1115M • Work Order Id: 3008749
Transaction Id
814643
Contract Number
BG-1115M
Work Order Id
3008749
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
50.0
Total Cost
1100.0
Transaction Date
2016-11-03T00:00:00.000
814972
Transaction Id: 814972 • Contract Number: BG-1215M • Work Order Id: 2901772
Transaction Id
814972
Contract Number
BG-1215M
Work Order Id
2901772
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
25.5
Total Cost
408.0
Transaction Date
2016-10-13T00:00:00.000
814990
Transaction Id: 814990 • Contract Number: BG-1215M • Work Order Id: 2901784
Transaction Id
814990
Contract Number
BG-1215M
Work Order Id
2901784
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
37.5
Total Cost
750.0
Transaction Date
2016-12-28T00:00:00.000
815068
Transaction Id: 815068 • Contract Number: BG-1215M • Work Order Id: 4276754
Transaction Id
815068
Contract Number
BG-1215M
Work Order Id
4276754
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
50.0
Total Cost
1000.0
Transaction Date
2016-12-19T00:00:00.000
816952
Transaction Id: 816952 • Contract Number: QG-1115M • Work Order Id: 4100297
Transaction Id
816952
Contract Number
QG-1115M
Work Order Id
4100297
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
23.7
Total Cost
474.0
Transaction Date
2016-11-01T00:00:00.000
817920
Transaction Id: 817920 • Contract Number: XG-615M • Work Order Id: 3642367
Transaction Id
817920
Contract Number
XG-615M
Work Order Id
3642367
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
25.5
Total Cost
408.0
Transaction Date
2016-10-14T00:00:00.000
818234
Transaction Id: 818234 • Contract Number: XG-615M • Work Order Id: 4081142
Transaction Id
818234
Contract Number
XG-615M
Work Order Id
4081142
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
20.5
Total Cost
328.0
Transaction Date
2016-10-31T00:00:00.000
818476
Transaction Id: 818476 • Contract Number: XG-615M • Work Order Id: 4263616
Transaction Id
818476
Contract Number
XG-615M
Work Order Id
4263616
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
22.0
Total Cost
352.0
Transaction Date
2016-10-18T00:00:00.000
818568
Transaction Id: 818568 • Contract Number: XG-615M • Work Order Id: 4290774
Transaction Id
818568
Contract Number
XG-615M
Work Order Id
4290774
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
24.0
Total Cost
384.0
Transaction Date
2016-10-17T00:00:00.000
819187
Transaction Id: 819187 • Contract Number: QG-1215M • Work Order Id: 3962605
Transaction Id
819187
Contract Number
QG-1215M
Work Order Id
3962605
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-12-07T00:00:00.000
820190
Transaction Id: 820190 • Contract Number: MG-715M • Work Order Id: 4246869
Transaction Id
820190
Contract Number
MG-715M
Work Order Id
4246869
Line Item Id
631.0
Item Number
38
Line Item Description
STEEL TREE BED GUARD - E
Unit Of Measure
LF
Unit Price
80.0
Units Used
19.2
Total Cost
1536.0
Transaction Date
2017-03-29T00:00:00.000
822664
Transaction Id: 822664 • Contract Number: BG-1315M • Work Order Id: 4306435
Transaction Id
822664
Contract Number
BG-1315M
Work Order Id
4306435
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
35.9
Total Cost
574.4
Transaction Date
2016-10-19T00:00:00.000
823268
Transaction Id: 823268 • Contract Number: BG-1215M • Work Order Id: 4141445
Transaction Id
823268
Contract Number
BG-1215M
Work Order Id
4141445
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
7.0
Units Used
16.5
Total Cost
115.5
Transaction Date
2016-10-06T00:00:00.000
823391
Transaction Id: 823391 • Contract Number: BG-1315M • Work Order Id: 3994407
Transaction Id
823391
Contract Number
BG-1315M
Work Order Id
3994407
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
7.0
Units Used
1.8
Total Cost
12.6
Transaction Date
2017-04-24T00:00:00.000
823613
Transaction Id: 823613 • Contract Number: BG-1215M • Work Order Id: 3696016
Transaction Id
823613
Contract Number
BG-1215M
Work Order Id
3696016
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
18.0
Units Used
50.0
Total Cost
900.0
Transaction Date
2016-12-09T00:00:00.000
827258
Transaction Id: 827258 • Contract Number: BG-1215M • Work Order Id: 5631414
Transaction Id
827258
Contract Number
BG-1215M
Work Order Id
5631414
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
25.0
Total Cost
400.0
Transaction Date
2017-01-12T00:00:00.000
827319
Transaction Id: 827319 • Contract Number: RG-615M • Work Order Id: 5445337
Transaction Id
827319
Contract Number
RG-615M
Work Order Id
5445337
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
24.5
Total Cost
367.5
Transaction Date
2017-01-11T00:00:00.000
828800
Transaction Id: 828800 • Contract Number: QG-1016M • Work Order Id: 5667278
Transaction Id
828800
Contract Number
QG-1016M
Work Order Id
5667278
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
12.75
Units Used
26.0
Total Cost
331.5
Transaction Date
2017-09-05T00:00:00.000
829587
Transaction Id: 829587 • Contract Number: QG-816M • Work Order Id: 6132667
Transaction Id
829587
Contract Number
QG-816M
Work Order Id
6132667
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
36.0
Total Cost
576.0
Transaction Date
2017-06-05T00:00:00.000
830164
Transaction Id: 830164 • Contract Number: BG-516M • Work Order Id: 5610082
Transaction Id
830164
Contract Number
BG-516M
Work Order Id
5610082
Line Item Id
627.0
Item Number
34
Line Item Description
STEEL TREE BED GUARD - A
Unit Of Measure
LF
Unit Price
78.0
Units Used
16.3
Total Cost
1271.4
Transaction Date
2017-10-10T00:00:00.000
830457
Transaction Id: 830457 • Contract Number: BG-516M • Work Order Id: 5684845
Transaction Id
830457
Contract Number
BG-516M
Work Order Id
5684845
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
23.0
Units Used
38.0
Total Cost
874.0
Transaction Date
2017-05-23T00:00:00.000
831468
Transaction Id: 831468 • Contract Number: XG-116M • Work Order Id: 5640732
Transaction Id
831468
Contract Number
XG-116M
Work Order Id
5640732
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
17.8
Total Cost
142.4
Transaction Date
2017-05-15T00:00:00.000
832854
Transaction Id: 832854 • Contract Number: QG-716M • Work Order Id: 4117547
Transaction Id
832854
Contract Number
QG-716M
Work Order Id
4117547
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
11.2
Total Cost
291.2
Transaction Date
2017-05-19T00:00:00.000
836015
Transaction Id: 836015 • Contract Number: XG-216M • Work Order Id: 5754760
Transaction Id
836015
Contract Number
XG-216M
Work Order Id
5754760
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
36.2
Total Cost
724.0
Transaction Date
2017-06-08T00:00:00.000
836683
Transaction Id: 836683 • Contract Number: BG-416M • Work Order Id: 4486330
Transaction Id
836683
Contract Number
BG-416M
Work Order Id
4486330
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
20.0
Units Used
38.1
Total Cost
762.0
Transaction Date
2017-06-12T00:00:00.000
836822
Transaction Id: 836822 • Contract Number: BG-416M • Work Order Id: 4486397
Transaction Id
836822
Contract Number
BG-416M
Work Order Id
4486397
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
25.0
Units Used
28.0
Total Cost
700.0
Transaction Date
2017-06-14T00:00:00.000
837455
Transaction Id: 837455 • Contract Number: RG-516M • Work Order Id: 5542457
Transaction Id
837455
Contract Number
RG-516M
Work Order Id
5542457
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
17.0
Units Used
32.5
Total Cost
552.5
Transaction Date
2017-06-05T00:00:00.000
838487
Transaction Id: 838487 • Contract Number: MG-416M • Work Order Id: 5678191
Transaction Id
838487
Contract Number
MG-416M
Work Order Id
5678191
Line Item Id
630.0
Item Number
37
Line Item Description
STEEL TREE BED GUARD - D
Unit Of Measure
LF
Unit Price
75.0
Units Used
13.4
Total Cost
1005.0
Transaction Date
2017-07-28T00:00:00.000
840312
Transaction Id: 840312 • Contract Number: BG-216M • Work Order Id: 5684513
Transaction Id
840312
Contract Number
BG-216M
Work Order Id
5684513
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
18.0
Units Used
28.7
Total Cost
516.6
Transaction Date
2017-06-29T00:00:00.000
840851
Transaction Id: 840851 • Contract Number: BG-216M • Work Order Id: 5762686
Transaction Id
840851
Contract Number
BG-216M
Work Order Id
5762686
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
18.0
Units Used
30.0
Total Cost
540.0
Transaction Date
2017-06-12T00:00:00.000
841086
Transaction Id: 841086 • Contract Number: BG-216M • Work Order Id: 5779569
Transaction Id
841086
Contract Number
BG-216M
Work Order Id
5779569
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
18.0
Units Used
36.0
Total Cost
648.0
Transaction Date
2017-06-13T00:00:00.000
NYC Data AI • Public-data exploration interface