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
873024
Transaction Id: 873024 • Contract Number: XG-116M • Work Order Id: 8002280
Transaction Id
873024
Contract Number
XG-116M
Work Order Id
8002280
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
24.0
Units Used
21.0
Total Cost
504.0
Transaction Date
1903-06-03T00:00:00.000
873025
Transaction Id: 873025 • Contract Number: XG-116M • Work Order Id: 8002280
Transaction Id
873025
Contract Number
XG-116M
Work Order Id
8002280
Line Item Id
310.0
Item Number
12
Line Item Description
PLANT PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
775.0
Units Used
560.0
Total Cost
434000.0
Transaction Date
1902-02-13T00:00:00.000
878221
Transaction Id: 878221 • Contract Number: XG-116MR • Work Order Id: 8236161
Transaction Id
878221
Contract Number
XG-116MR
Work Order Id
8236161
Line Item Id
646.0
Line Item Description
PREAPRING EXISTING SIDEWALK TREE BEDS (R)
Unit Of Measure
SF
Transaction Date
1903-06-03T00:00:00.000
878223
Transaction Id: 878223 • Contract Number: XG-116MR • Work Order Id: 8236241
Transaction Id
878223
Contract Number
XG-116MR
Work Order Id
8236241
Line Item Id
646.0
Line Item Description
PREAPRING EXISTING SIDEWALK TREE BEDS (R)
Unit Of Measure
SF
Transaction Date
1903-06-03T00:00:00.000
878226
Transaction Id: 878226 • Contract Number: XG-116MR • Work Order Id: 8240003
Transaction Id
878226
Contract Number
XG-116MR
Work Order Id
8240003
Line Item Id
646.0
Line Item Description
PREAPRING EXISTING SIDEWALK TREE BEDS (R)
Unit Of Measure
SF
Transaction Date
1903-06-03T00:00:00.000
878228
Transaction Id: 878228 • Contract Number: XG-116MR • Work Order Id: 8239997
Transaction Id
878228
Contract Number
XG-116MR
Work Order Id
8239997
Line Item Id
646.0
Line Item Description
PREAPRING EXISTING SIDEWALK TREE BEDS (R)
Unit Of Measure
SF
Transaction Date
1903-06-03T00:00:00.000
878230
Transaction Id: 878230 • Contract Number: XG-116MR • Work Order Id: 8243911
Transaction Id
878230
Contract Number
XG-116MR
Work Order Id
8243911
Line Item Id
646.0
Line Item Description
PREAPRING EXISTING SIDEWALK TREE BEDS (R)
Unit Of Measure
SF
Transaction Date
1903-06-03T00:00:00.000
878232
Transaction Id: 878232 • Contract Number: XG-116MR • Work Order Id: 8243910
Transaction Id
878232
Contract Number
XG-116MR
Work Order Id
8243910
Line Item Id
646.0
Line Item Description
PREAPRING EXISTING SIDEWALK TREE BEDS (R)
Unit Of Measure
SF
Transaction Date
1903-06-03T00:00:00.000
880604
Transaction Id: 880604 • Contract Number: BG-418M • Work Order Id: 8564755
Transaction Id
880604
Contract Number
BG-418M
Work Order Id
8564755
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
46.7
Total Cost
1868.0
Transaction Date
2018-10-01T00:00:00.000
880608
Transaction Id: 880608 • Contract Number: BG-418M • Work Order Id: 8564757
Transaction Id
880608
Contract Number
BG-418M
Work Order Id
8564757
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.2
Total Cost
1568.0
Transaction Date
2018-10-01T00:00:00.000
906804
Transaction Id: 906804 • Contract Number: BG-419M • Work Order Id: 7700941
Transaction Id
906804
Contract Number
BG-419M
Work Order Id
7700941
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
33.3
Total Cost
1565.1
Transaction Date
2020-04-02T00:00:00.000
907065
Transaction Id: 907065 • Contract Number: BG-419M • Work Order Id: 9916121
Transaction Id
907065
Contract Number
BG-419M
Work Order Id
9916121
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
49.2
Total Cost
2312.4
Transaction Date
2020-04-07T00:00:00.000
916152
Transaction Id: 916152 • Contract Number: MG-219M • Work Order Id: 10481912
Transaction Id
916152
Contract Number
MG-219M
Work Order Id
10481912
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
49.0
Units Used
50.0
Total Cost
2450.0
Transaction Date
2019-10-11T00:00:00.000
911903
Transaction Id: 911903 • Contract Number: MG-219M • Work Order Id: 9122030
Transaction Id
911903
Contract Number
MG-219M
Work Order Id
9122030
Line Item Id
615.0
Item Number
06
Line Item Description
TREE REMOVAL OF OVER 8 UP TO AND INCLUDING 12 INCHES DBH
Unit Of Measure
EA
Unit Price
1000.0
Units Used
1.0
Total Cost
1000.0
Transaction Date
2019-09-30T00:00:00.000
915961
Transaction Id: 915961 • Contract Number: MG-219M • Work Order Id: 10372686
Transaction Id
915961
Contract Number
MG-219M
Work Order Id
10372686
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
49.0
Units Used
50.0
Total Cost
2450.0
Transaction Date
2019-10-08T00:00:00.000
912566
Transaction Id: 912566 • Contract Number: MG-219M • Work Order Id: 7353016
Transaction Id
912566
Contract Number
MG-219M
Work Order Id
7353016
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
49.0
Units Used
29.2
Total Cost
1430.8
Transaction Date
2020-02-17T00:00:00.000
912567
Transaction Id: 912567 • Contract Number: MG-219M • Work Order Id: 7353016
Transaction Id
912567
Contract Number
MG-219M
Work Order Id
7353016
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.8
Total Cost
583.2
Transaction Date
2020-02-17T00:00:00.000
914823
Transaction Id: 914823 • Contract Number: MG-219M • Work Order Id: 9368733
Transaction Id
914823
Contract Number
MG-219M
Work Order Id
9368733
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
50.0
Total Cost
2700.0
Transaction Date
2020-02-17T00:00:00.000
914926
Transaction Id: 914926 • Contract Number: MG-219M • Work Order Id: 9374691
Transaction Id
914926
Contract Number
MG-219M
Work Order Id
9374691
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
49.0
Units Used
48.9
Total Cost
2396.1
Transaction Date
2020-02-21T00:00:00.000
915142
Transaction Id: 915142 • Contract Number: MG-219M • Work Order Id: 9860564
Transaction Id
915142
Contract Number
MG-219M
Work Order Id
9860564
Line Item Id
312.0
Item Number
23
Line Item Description
REMOVE AND RESET METAL TREE GUARDS AND GRATES
Unit Of Measure
HR
Unit Price
195.0
Units Used
0.3
Total Cost
58.5
Transaction Date
2019-10-16T00:00:00.000
915143
Transaction Id: 915143 • Contract Number: MG-219M • Work Order Id: 9860564
Transaction Id
915143
Contract Number
MG-219M
Work Order Id
9860564
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
49.0
Units Used
50.0
Total Cost
2450.0
Transaction Date
2019-10-16T00:00:00.000
915627
Transaction Id: 915627 • Contract Number: MG-219M • Work Order Id: 10265263
Transaction Id
915627
Contract Number
MG-219M
Work Order Id
10265263
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
49.0
Units Used
22.1
Total Cost
1082.9
Transaction Date
2020-03-16T00:00:00.000
921576
Transaction Id: 921576 • Contract Number: RG-118M • Work Order Id: 10551003
Transaction Id
921576
Contract Number
RG-118M
Work Order Id
10551003
Line Item Id
640.0
Item Number
12
Line Item Description
PLANTING PROCURED STREE TREES, 2.0 - 2.5 INCH CALIPER
Unit Of Measure
EA
Unit Price
1000.0
Units Used
1.0
Total Cost
1000.0
Transaction Date
2019-12-18T00:00:00.000
913051
Transaction Id: 913051 • Contract Number: MG-219M • Work Order Id: 7635129
Transaction Id
913051
Contract Number
MG-219M
Work Order Id
7635129
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
50.8
Total Cost
2743.2
Transaction Date
2020-02-12T00:00:00.000
914620
Transaction Id: 914620 • Contract Number: MG-219M • Work Order Id: 9287708
Transaction Id
914620
Contract Number
MG-219M
Work Order Id
9287708
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
49.0
Units Used
15.0
Total Cost
735.0
Transaction Date
2020-02-14T00:00:00.000
914621
Transaction Id: 914621 • Contract Number: MG-219M • Work Order Id: 9287708
Transaction Id
914621
Contract Number
MG-219M
Work Order Id
9287708
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
35.0
Total Cost
1890.0
Transaction Date
2020-02-14T00:00:00.000
915953
Transaction Id: 915953 • Contract Number: MG-219M • Work Order Id: 10367160
Transaction Id
915953
Contract Number
MG-219M
Work Order Id
10367160
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
49.0
Units Used
40.6
Total Cost
1989.4
Transaction Date
2020-03-11T00:00:00.000
922399
Transaction Id: 922399 • Contract Number: BG-819M • Work Order Id: 1821549
Transaction Id
922399
Contract Number
BG-819M
Work Order Id
1821549
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
27.5
Total Cost
1237.5
Transaction Date
2019-12-03T00:00:00.000
922480
Transaction Id: 922480 • Contract Number: BG-819M • Work Order Id: 648761
Transaction Id
922480
Contract Number
BG-819M
Work Order Id
648761
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
12.0
Total Cost
504.0
Transaction Date
2019-11-22T00:00:00.000
927586
Transaction Id: 927586 • Contract Number: QG-118MA • Work Order Id: 6922799
Transaction Id
927586
Contract Number
QG-118MA
Work Order Id
6922799
Line Item Id
650.0
Item Number
12
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1250.0
Units Used
1.0
Total Cost
1250.0
Transaction Date
2020-09-16T00:00:00.000
927915
Transaction Id: 927915 • Contract Number: QG-118MA • Work Order Id: 8740683
Transaction Id
927915
Contract Number
QG-118MA
Work Order Id
8740683
Line Item Id
650.0
Item Number
12
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1250.0
Units Used
1.0
Total Cost
1250.0
Transaction Date
2020-09-16T00:00:00.000
927989
Transaction Id: 927989 • Contract Number: QG-118MA • Work Order Id: 8804444
Transaction Id
927989
Contract Number
QG-118MA
Work Order Id
8804444
Line Item Id
650.0
Item Number
12
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1250.0
Units Used
1.0
Total Cost
1250.0
Transaction Date
2020-09-16T00:00:00.000
932723
Transaction Id: 932723 • Contract Number: BG-819M • Work Order Id: 1491911
Transaction Id
932723
Contract Number
BG-819M
Work Order Id
1491911
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
41.2
Total Cost
1854.0000000000002
Transaction Date
2020-01-10T00:00:00.000
992121
Transaction Id: 992121 • Contract Number: XG-619M • Work Order Id: 14839317
Transaction Id
992121
Contract Number
XG-619M
Work Order Id
14839317
Line Item Id
293.0
Item Number
28
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
25.0
Units Used
11.7
Total Cost
292.5
Transaction Date
2022-05-20T00:00:00.000
992122
Transaction Id: 992122 • Contract Number: XG-619M • Work Order Id: 14839317
Transaction Id
992122
Contract Number
XG-619M
Work Order Id
14839317
Line Item Id
294.0
Item Number
29
Line Item Description
UNCLASSIFIED EXCAVATION
Unit Of Measure
CY
Unit Price
350.0
Units Used
2.55
Total Cost
892.4999999999999
Transaction Date
2022-05-20T00:00:00.000
858107
Transaction Id: 858107 • Contract Number: QG-816M • Work Order Id: 6588648
Transaction Id
858107
Contract Number
QG-816M
Work Order Id
6588648
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
15.0
Units Used
54.2
Total Cost
813.0
Transaction Date
2017-11-28T00:00:00.000
858109
Transaction Id: 858109 • Contract Number: QG-816M • Work Order Id: 6588649
Transaction Id
858109
Contract Number
QG-816M
Work Order Id
6588649
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
15.0
Units Used
55.1
Total Cost
826.5
Transaction Date
2017-11-28T00:00:00.000
858767
Transaction Id: 858767 • Contract Number: MG-416M • Work Order Id: 5177733
Transaction Id
858767
Contract Number
MG-416M
Work Order Id
5177733
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.3
Total Cost
138.4
Transaction Date
2017-10-25T00:00:00.000
880610
Transaction Id: 880610 • Contract Number: BG-418M • Work Order Id: 8564758
Transaction Id
880610
Contract Number
BG-418M
Work Order Id
8564758
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
37.5
Total Cost
1500.0
Transaction Date
2018-10-01T00:00:00.000
880612
Transaction Id: 880612 • Contract Number: BG-418M • Work Order Id: 8564759
Transaction Id
880612
Contract Number
BG-418M
Work Order Id
8564759
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
37.5
Total Cost
1500.0
Transaction Date
2018-10-01T00:00:00.000
883806
Transaction Id: 883806 • Contract Number: MG-416MR • Work Order Id: 7428786
Transaction Id
883806
Contract Number
MG-416MR
Work Order Id
7428786
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
35.79
Units Used
44.1
Total Cost
1578.339
Transaction Date
2020-03-04T00:00:00.000
914999
Transaction Id: 914999 • Contract Number: MG-219M • Work Order Id: 9627946
Transaction Id
914999
Contract Number
MG-219M
Work Order Id
9627946
Line Item Id
650.0
Item Number
12
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
2000.0
Units Used
1.0
Total Cost
2000.0
Transaction Date
2019-12-23T00:00:00.000
913041
Transaction Id: 913041 • Contract Number: MG-219M • Work Order Id: 7635123
Transaction Id
913041
Contract Number
MG-219M
Work Order Id
7635123
Line Item Id
652.0
Item Number
31
Line Item Description
CONCRETE PAVEMENT W/O BASE - 7"
Unit Of Measure
SF
Unit Price
35.0
Units Used
5.8
Total Cost
203.0
Transaction Date
2020-02-13T00:00:00.000
913571
Transaction Id: 913571 • Contract Number: MG-219M • Work Order Id: 8935730
Transaction Id
913571
Contract Number
MG-219M
Work Order Id
8935730
Line Item Id
615.0
Item Number
06
Line Item Description
TREE REMOVAL OF OVER 8 UP TO AND INCLUDING 12 INCHES DBH
Unit Of Measure
EA
Unit Price
1000.0
Units Used
1.0
Total Cost
1000.0
Transaction Date
2020-03-04T00:00:00.000
911909
Transaction Id: 911909 • Contract Number: MG-219M • Work Order Id: 9260713
Transaction Id
911909
Contract Number
MG-219M
Work Order Id
9260713
Line Item Id
615.0
Item Number
06
Line Item Description
TREE REMOVAL OF OVER 8 UP TO AND INCLUDING 12 INCHES DBH
Unit Of Measure
EA
Unit Price
1000.0
Units Used
1.0
Total Cost
1000.0
Transaction Date
2019-09-30T00:00:00.000
911915
Transaction Id: 911915 • Contract Number: MG-219M • Work Order Id: 9012326
Transaction Id
911915
Contract Number
MG-219M
Work Order Id
9012326
Line Item Id
615.0
Item Number
06
Line Item Description
TREE REMOVAL OF OVER 8 UP TO AND INCLUDING 12 INCHES DBH
Unit Of Measure
EA
Unit Price
1000.0
Units Used
1.0
Total Cost
1000.0
Transaction Date
2019-09-30T00:00:00.000
914980
Transaction Id: 914980 • Contract Number: MG-219M • Work Order Id: 9612332
Transaction Id
914980
Contract Number
MG-219M
Work Order Id
9612332
Line Item Id
619.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
49.0
Units Used
35.6
Total Cost
1744.4
Transaction Date
2019-10-03T00:00:00.000
915359
Transaction Id: 915359 • Contract Number: MG-219M • Work Order Id: 10055781
Transaction Id
915359
Contract Number
MG-219M
Work Order Id
10055781
Line Item Id
610.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 12 UP TO AND INCLUDING 18 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
550.0
Units Used
1.0
Total Cost
550.0
Transaction Date
2019-10-02T00:00:00.000
916276
Transaction Id: 916276 • Contract Number: MG-219M • Work Order Id: 7253646
Transaction Id
916276
Contract Number
MG-219M
Work Order Id
7253646
Line Item Id
611.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 UP TO AND INCLUDING 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
400.0
Units Used
1.0
Total Cost
400.0
Transaction Date
2019-10-02T00:00:00.000
996995
Transaction Id: 996995 • Contract Number: MG-1319MA • Work Order Id: 16220866
Transaction Id
996995
Contract Number
MG-1319MA
Work Order Id
16220866
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-04T00:00:00.000
NYC Data AI • Public-data exploration interface