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
842162
Transaction Id: 842162 • Contract Number: QG-1016M • Work Order Id: 6386837
Transaction Id
842162
Contract Number
QG-1016M
Work Order Id
6386837
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
24.0
Total Cost
306.0
Transaction Date
2017-12-06T00:00:00.000
842487
Transaction Id: 842487 • Contract Number: RG-516M • Work Order Id: 5641053
Transaction Id
842487
Contract Number
RG-516M
Work Order Id
5641053
Line Item Id
293.0
Item Number
28
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
5.75
Units Used
6.0
Total Cost
34.5
Transaction Date
2017-06-01T00:00:00.000
843389
Transaction Id: 843389 • Contract Number: QG-916M • Work Order Id: 5256991
Transaction Id
843389
Contract Number
QG-916M
Work Order Id
5256991
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
10.0
Units Used
16.7
Total Cost
167.0
Transaction Date
2017-06-19T00:00:00.000
844432
Transaction Id: 844432 • Contract Number: QG-1016M • Work Order Id: 6415284
Transaction Id
844432
Contract Number
QG-1016M
Work Order Id
6415284
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-27T00:00:00.000
844519
Transaction Id: 844519 • Contract Number: QG-916M • Work Order Id: 686908
Transaction Id
844519
Contract Number
QG-916M
Work Order Id
686908
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
19.0
Units Used
25.0
Total Cost
475.0
Transaction Date
2017-06-29T00:00:00.000
845002
Transaction Id: 845002 • Contract Number: RG-516M • Work Order Id: 6312030
Transaction Id
845002
Contract Number
RG-516M
Work Order Id
6312030
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
30.0
Total Cost
510.0
Transaction Date
2017-06-27T00:00:00.000
845066
Transaction Id: 845066 • Contract Number: RG-516M • Work Order Id: 5641019
Transaction Id
845066
Contract Number
RG-516M
Work Order Id
5641019
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
23.0
Total Cost
391.0
Transaction Date
2017-06-28T00:00:00.000
846998
Transaction Id: 846998 • Contract Number: BG-316M • Work Order Id: 5610394
Transaction Id
846998
Contract Number
BG-316M
Work Order Id
5610394
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
2018-03-19T00:00:00.000
847781
Transaction Id: 847781 • Contract Number: BG-316M • Work Order Id: 6415742
Transaction Id
847781
Contract Number
BG-316M
Work Order Id
6415742
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.7
Total Cost
890.1
Transaction Date
2018-03-15T00:00:00.000
848473
Transaction Id: 848473 • Contract Number: BG-316M • Work Order Id: 6588550
Transaction Id
848473
Contract Number
BG-316M
Work Order Id
6588550
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
32.0
Total Cost
736.0
Transaction Date
2018-03-27T00:00:00.000
849674
Transaction Id: 849674 • Contract Number: MG-416M • Work Order Id: 5622050
Transaction Id
849674
Contract Number
MG-416M
Work Order Id
5622050
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
18.5
Total Cost
1387.5
Transaction Date
2017-12-15T00:00:00.000
849981
Transaction Id: 849981 • Contract Number: MG-416M • Work Order Id: 6685314
Transaction Id
849981
Contract Number
MG-416M
Work Order Id
6685314
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
18.8
Total Cost
1410.0
Transaction Date
2017-12-13T00:00:00.000
850551
Transaction Id: 850551 • Contract Number: XG-116M • Work Order Id: 6549167
Transaction Id
850551
Contract Number
XG-116M
Work Order Id
6549167
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
22.0
Units Used
50.0
Total Cost
1100.0
Transaction Date
2017-11-14T00:00:00.000
853476
Transaction Id: 853476 • Contract Number: BG-516M • Work Order Id: 6556582
Transaction Id
853476
Contract Number
BG-516M
Work Order Id
6556582
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
21.6
Total Cost
496.8
Transaction Date
2017-11-28T00:00:00.000
853609
Transaction Id: 853609 • Contract Number: BG-516M • Work Order Id: 6716119
Transaction Id
853609
Contract Number
BG-516M
Work Order Id
6716119
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
18.0
Total Cost
360.0
Transaction Date
2017-12-22T00:00:00.000
854484
Transaction Id: 854484 • Contract Number: QG-716M • Work Order Id: 6595598
Transaction Id
854484
Contract Number
QG-716M
Work Order Id
6595598
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
19.0
Units Used
29.8
Total Cost
566.2
Transaction Date
2017-11-01T00:00:00.000
855324
Transaction Id: 855324 • Contract Number: XG-216M • Work Order Id: 6601145
Transaction Id
855324
Contract Number
XG-216M
Work Order Id
6601145
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
24.8
Total Cost
496.0
Transaction Date
2017-10-20T00:00:00.000
855563
Transaction Id: 855563 • Contract Number: XG-216M • Work Order Id: 6644827
Transaction Id
855563
Contract Number
XG-216M
Work Order Id
6644827
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
26.0
Total Cost
520.0
Transaction Date
2017-10-30T00:00:00.000
856015
Transaction Id: 856015 • Contract Number: XG-216M • Work Order Id: 6663114
Transaction Id
856015
Contract Number
XG-216M
Work Order Id
6663114
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
17.1
Total Cost
1282.5
Transaction Date
2018-04-26T00:00:00.000
856120
Transaction Id: 856120 • Contract Number: RG-516M • Work Order Id: 6512346
Transaction Id
856120
Contract Number
RG-516M
Work Order Id
6512346
Line Item Id
652.0
Item Number
33
Line Item Description
CONCRETE PAVEMENT W/O BASE - 7"
Unit Of Measure
SF
Unit Price
50.0
Units Used
5.78
Total Cost
289.0
Transaction Date
2017-11-27T00:00:00.000
857435
Transaction Id: 857435 • Contract Number: QG-816M • Work Order Id: 5982617
Transaction Id
857435
Contract Number
QG-816M
Work Order Id
5982617
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.0
Total Cost
432.0
Transaction Date
2017-12-06T00:00:00.000
858392
Transaction Id: 858392 • Contract Number: MG-416M • Work Order Id: 6827991
Transaction Id
858392
Contract Number
MG-416M
Work Order Id
6827991
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
20.0
Total Cost
1500.0
Transaction Date
2018-02-01T00:00:00.000
859641
Transaction Id: 859641 • Contract Number: QG-916M • Work Order Id: 6306126
Transaction Id
859641
Contract Number
QG-916M
Work Order Id
6306126
Line Item Id
628.0
Item Number
35
Line Item Description
STEEL TREE BED GUARD - B
Unit Of Measure
LF
Unit Price
85.0
Units Used
17.3
Total Cost
1470.5
Transaction Date
2018-08-02T00:00:00.000
861163
Transaction Id: 861163 • Contract Number: BG-316M • Work Order Id: 6126810
Transaction Id
861163
Contract Number
BG-316M
Work Order Id
6126810
Line Item Id
628.0
Item Number
35
Line Item Description
STEEL TREE BED GUARD - B
Unit Of Measure
LF
Unit Price
85.0
Units Used
17.5
Total Cost
1487.5
Transaction Date
2018-05-01T00:00:00.000
862999
Transaction Id: 862999 • Contract Number: BG-116M • Work Order Id: 6926003
Transaction Id
862999
Contract Number
BG-116M
Work Order Id
6926003
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
49.6
Total Cost
1388.8
Transaction Date
2017-12-27T00:00:00.000
863183
Transaction Id: 863183 • Contract Number: XG-116M • Work Order Id: 6581638
Transaction Id
863183
Contract Number
XG-116M
Work Order Id
6581638
Line Item Id
294.0
Item Number
27
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
40.0
Units Used
0.4
Total Cost
16.0
Transaction Date
2017-12-18T00:00:00.000
864484
Transaction Id: 864484 • Contract Number: QG-816M • Work Order Id: 6458190
Transaction Id
864484
Contract Number
QG-816M
Work Order Id
6458190
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
20.4
Total Cost
1530.0
Transaction Date
2018-02-01T00:00:00.000
865047
Transaction Id: 865047 • Contract Number: QG-816M • Work Order Id: 7225473
Transaction Id
865047
Contract Number
QG-816M
Work Order Id
7225473
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
42.8
Total Cost
1112.8
Transaction Date
2018-06-07T00:00:00.000
865315
Transaction Id: 865315 • Contract Number: BG-516M • Work Order Id: 6714518
Transaction Id
865315
Contract Number
BG-516M
Work Order Id
6714518
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
26.0
Total Cost
208.0
Transaction Date
2018-01-11T00:00:00.000
868217
Transaction Id: 868217 • Contract Number: BG-116M • Work Order Id: 7358213
Transaction Id
868217
Contract Number
BG-116M
Work Order Id
7358213
Line Item Id
292.0
Item Number
25
Line Item Description
SHREDDED BARK MULCH
Unit Of Measure
SY
Unit Price
8.0
Units Used
5.5
Total Cost
44.0
Transaction Date
2018-02-14T00:00:00.000
869992
Transaction Id: 869992 • Contract Number: XG-216M • Work Order Id: 7178187
Transaction Id
869992
Contract Number
XG-216M
Work Order Id
7178187
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
26.2
Total Cost
524.0
Transaction Date
2018-05-23T00:00:00.000
871485
Transaction Id: 871485 • Contract Number: BG-116M • Work Order Id: 7492339
Transaction Id
871485
Contract Number
BG-116M
Work Order Id
7492339
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
60.0
Total Cost
1680.0
Transaction Date
2018-03-20T00:00:00.000
875336
Transaction Id: 875336 • Contract Number: MG-416M • Work Order Id: 8203400
Transaction Id
875336
Contract Number
MG-416M
Work Order Id
8203400
Line Item Id
626.0
Item Number
24
Line Item Description
TOPSOIL FOR TREE BED AREAS
Unit Of Measure
CF
Unit Price
15.0
Units Used
4.2
Total Cost
63.0
Transaction Date
2018-06-07T00:00:00.000
877405
Transaction Id: 877405 • Contract Number: XG-116MR • Work Order Id: 8389119
Transaction Id
877405
Contract Number
XG-116MR
Work Order Id
8389119
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
24.0
Units Used
20.0
Total Cost
480.0
Transaction Date
2018-12-10T00:00:00.000
880472
Transaction Id: 880472 • Contract Number: BG-418M • Work Order Id: 8471915
Transaction Id
880472
Contract Number
BG-418M
Work Order Id
8471915
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
30.0
Units Used
40.0
Total Cost
1200.0
Transaction Date
2018-10-03T00:00:00.000
882679
Transaction Id: 882679 • Contract Number: QG-716MR • Work Order Id: 8022507
Transaction Id
882679
Contract Number
QG-716MR
Work Order Id
8022507
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
41.3
Total Cost
1073.8
Transaction Date
2019-02-06T00:00:00.000
883092
Transaction Id: 883092 • Contract Number: QG-716MR • Work Order Id: 8069947
Transaction Id
883092
Contract Number
QG-716MR
Work Order Id
8069947
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
19.0
Units Used
32.0
Total Cost
608.0
Transaction Date
2018-11-26T00:00:00.000
883401
Transaction Id: 883401 • Contract Number: QG-716MR • Work Order Id: 8278641
Transaction Id
883401
Contract Number
QG-716MR
Work Order Id
8278641
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
15.0
Units Used
18.0
Total Cost
270.0
Transaction Date
2018-12-19T00:00:00.000
883580
Transaction Id: 883580 • Contract Number: QG-716MR • Work Order Id: 8542678
Transaction Id
883580
Contract Number
QG-716MR
Work Order Id
8542678
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
19.0
Units Used
30.0
Total Cost
570.0
Transaction Date
2019-01-09T00:00:00.000
883627
Transaction Id: 883627 • Contract Number: QG-716MR • Work Order Id: 8552958
Transaction Id
883627
Contract Number
QG-716MR
Work Order Id
8552958
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
26.0
Units Used
47.5
Total Cost
1235.0
Transaction Date
2019-03-25T00:00:00.000
884143
Transaction Id: 884143 • Contract Number: MG-416M • Work Order Id: 8651545
Transaction Id
884143
Contract Number
MG-416M
Work Order Id
8651545
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
18.8
Total Cost
1410.0
Transaction Date
2018-10-22T00:00:00.000
884478
Transaction Id: 884478 • Contract Number: BG-518M • Work Order Id: 6764882
Transaction Id
884478
Contract Number
BG-518M
Work Order Id
6764882
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
2018-11-28T00:00:00.000
884547
Transaction Id: 884547 • Contract Number: BG-518M • Work Order Id: 7319879
Transaction Id
884547
Contract Number
BG-518M
Work Order Id
7319879
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
8.0
Units Used
5.6
Total Cost
44.8
Transaction Date
2018-11-30T00:00:00.000
885899
Transaction Id: 885899 • Contract Number: XG-116MR • Work Order Id: 8985776
Transaction Id
885899
Contract Number
XG-116MR
Work Order Id
8985776
Line Item Id
618.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
24.0
Units Used
6.0
Total Cost
144.0
Transaction Date
2018-11-29T00:00:00.000
888471
Transaction Id: 888471 • Contract Number: BG-116M • Work Order Id: 6808509
Transaction Id
888471
Contract Number
BG-116M
Work Order Id
6808509
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
41.0
Total Cost
1148.0
Transaction Date
2018-12-10T00:00:00.000
888519
Transaction Id: 888519 • Contract Number: BG-116M • Work Order Id: 6959794
Transaction Id
888519
Contract Number
BG-116M
Work Order Id
6959794
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
6.7
Total Cost
187.6
Transaction Date
2018-12-11T00:00:00.000
888577
Transaction Id: 888577 • Contract Number: BG-116M • Work Order Id: 7040376
Transaction Id
888577
Contract Number
BG-116M
Work Order Id
7040376
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
24.0
Total Cost
672.0
Transaction Date
2018-12-17T00:00:00.000
888904
Transaction Id: 888904 • Contract Number: BG-116M • Work Order Id: 8348982
Transaction Id
888904
Contract Number
BG-116M
Work Order Id
8348982
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
28.0
Units Used
32.0
Total Cost
896.0
Transaction Date
2018-12-14T00:00:00.000
893506
Transaction Id: 893506 • Contract Number: RG-118M • Work Order Id: 1645918
Transaction Id
893506
Contract Number
RG-118M
Work Order Id
1645918
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
31.0
Units Used
24.0
Total Cost
744.0
Transaction Date
2019-06-21T00:00:00.000
896880
Transaction Id: 896880 • Contract Number: RG-118M • Work Order Id: 9551453
Transaction Id
896880
Contract Number
RG-118M
Work Order Id
9551453
Line Item Id
631.0
Item Number
40
Line Item Description
STEEL TREE BED GUARD - E
Unit Of Measure
LF
Unit Price
85.0
Units Used
13.3
Total Cost
1130.5
Transaction Date
2019-10-29T00:00:00.000
NYC Data AI • Public-data exploration interface