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
918098
Transaction Id: 918098 • Contract Number: MG-219M • Work Order Id: 9627949
Transaction Id
918098
Contract Number
MG-219M
Work Order Id
9627949
Line Item Id
612.0
Item Number
03
Line Item Description
STUMP REMOVALS OF OVER 18 UP TO AND INCLUDING 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
650.0
Units Used
1.0
Total Cost
650.0
Transaction Date
2019-10-10T00:00:00.000
920533
Transaction Id: 920533 • Contract Number: MG-219M • Work Order Id: 9627945
Transaction Id
920533
Contract Number
MG-219M
Work Order Id
9627945
Line Item Id
612.0
Item Number
03
Line Item Description
STUMP REMOVALS OF OVER 18 UP TO AND INCLUDING 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
650.0
Units Used
1.0
Total Cost
650.0
Transaction Date
2019-10-10T00:00:00.000
920553
Transaction Id: 920553 • Contract Number: MG-219M • Work Order Id: 9260713
Transaction Id
920553
Contract Number
MG-219M
Work Order Id
9260713
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-09-30T00:00:00.000
936838
Transaction Id: 936838 • Contract Number: BG-819M • Work Order Id: 10654133
Transaction Id
936838
Contract Number
BG-819M
Work Order Id
10654133
Line Item Id
652.0
Item Number
31
Line Item Description
CONCRETE PAVEMENT W/O BASE - 7"
Unit Of Measure
SF
Unit Price
30.0
Units Used
4.7
Total Cost
141.0
Transaction Date
2020-02-27T00:00:00.000
931317
Transaction Id: 931317 • Contract Number: MG-219M • Work Order Id: 10046449
Transaction Id
931317
Contract Number
MG-219M
Work Order Id
10046449
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
2020-01-02T00:00:00.000
931368
Transaction Id: 931368 • Contract Number: MG-219M • Work Order Id: 7578198
Transaction Id
931368
Contract Number
MG-219M
Work Order Id
7578198
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
2020-01-07T00:00:00.000
928195
Transaction Id: 928195 • Contract Number: QG-816MR • Work Order Id: 8413466
Transaction Id
928195
Contract Number
QG-816MR
Work Order Id
8413466
Line Item Id
342.0
Item Number
30
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
26.0
Units Used
32.7
Total Cost
850.2
Transaction Date
2019-06-26T00:00:00.000
928986
Transaction Id: 928986 • Contract Number: MG-219M • Work Order Id: 9077981
Transaction Id
928986
Contract Number
MG-219M
Work Order Id
9077981
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-04T00:00:00.000
936270
Transaction Id: 936270 • Contract Number: BG-619M • Work Order Id: 10638929
Transaction Id
936270
Contract Number
BG-619M
Work Order Id
10638929
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
150.0
Units Used
1.0
Total Cost
150.0
Transaction Date
2020-02-13T00:00:00.000
936690
Transaction Id: 936690 • Contract Number: BG-619M • Work Order Id: 10905019
Transaction Id
936690
Contract Number
BG-619M
Work Order Id
10905019
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
46.7
Total Cost
2241.6000000000004
Transaction Date
2020-02-20T00:00:00.000
936949
Transaction Id: 936949 • Contract Number: MG-219M • Work Order Id: 9627946
Transaction Id
936949
Contract Number
MG-219M
Work Order Id
9627946
Line Item Id
612.0
Item Number
03
Line Item Description
STUMP REMOVALS OF OVER 18 UP TO AND INCLUDING 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
650.0
Units Used
1.0
Total Cost
650.0
Transaction Date
2019-10-10T00:00:00.000
923101
Transaction Id: 923101 • Contract Number: MG-219M • Work Order Id: 9860564
Transaction Id
923101
Contract Number
MG-219M
Work Order Id
9860564
Line Item Id
651.0
Item Number
13
Line Item Description
PLANTING PROCURED STREET TREES, 3.5 – 4 INCH CALIPER
Unit Of Measure
EA
Unit Price
2500.0
Units Used
1.0
Total Cost
2500.0
Transaction Date
2020-01-08T00:00:00.000
921746
Transaction Id: 921746 • Contract Number: MG-319M • Work Order Id: 8944155
Transaction Id
921746
Contract Number
MG-319M
Work Order Id
8944155
Line Item Id
612.0
Item Number
03
Line Item Description
STUMP REMOVALS OF OVER 18 UP TO AND INCLUDING 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
600.0
Units Used
1.0
Total Cost
600.0
Transaction Date
2019-10-31T00:00:00.000
934449
Transaction Id: 934449 • Contract Number: MG-319M • Work Order Id: 8969059
Transaction Id
934449
Contract Number
MG-319M
Work Order Id
8969059
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
24.0
Total Cost
1176.0
Transaction Date
2020-01-30T00:00:00.000
932558
Transaction Id: 932558 • Contract Number: BG-819M • Work Order Id: 647690
Transaction Id
932558
Contract Number
BG-819M
Work Order Id
647690
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
1565.0
Units Used
1.0
Total Cost
1565.0
Transaction Date
2020-04-10T00:00:00.000
936884
Transaction Id: 936884 • Contract Number: MG-219M • Work Order Id: 11069708
Transaction Id
936884
Contract Number
MG-219M
Work Order Id
11069708
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
14.8
Total Cost
725.2
Transaction Date
2020-02-12T00:00:00.000
937052
Transaction Id: 937052 • Contract Number: MG-219M • Work Order Id: 10082546
Transaction Id
937052
Contract Number
MG-219M
Work Order Id
10082546
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
1.0
Total Cost
54.0
Transaction Date
2020-03-03T00:00:00.000
937073
Transaction Id: 937073 • Contract Number: MG-219M • Work Order Id: 10481912
Transaction Id
937073
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
937260
Transaction Id: 937260 • Contract Number: MG-219M • Work Order Id: 8936937
Transaction Id
937260
Contract Number
MG-219M
Work Order Id
8936937
Line Item Id
617.0
Item Number
08
Line Item Description
TREE REMOVAL OF OVER 18 UP TO AND INCLUDING 24 INCHES DBH
Unit Of Measure
EA
Unit Price
2000.0
Units Used
1.0
Total Cost
2000.0
Transaction Date
2020-03-04T00:00:00.000
937267
Transaction Id: 937267 • Contract Number: MG-219M • Work Order Id: 10498902
Transaction Id
937267
Contract Number
MG-219M
Work Order Id
10498902
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
14.0
Total Cost
686.0
Transaction Date
2020-02-12T00:00:00.000
937290
Transaction Id: 937290 • Contract Number: MG-219M • Work Order Id: 9275798
Transaction Id
937290
Contract Number
MG-219M
Work Order Id
9275798
Line Item Id
614.0
Item Number
05
Line Item Description
STUMP REMOVALS OF OVER 30 UP TO AND INCLUDING 36 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
950.0
Units Used
1.0
Total Cost
950.0
Transaction Date
2020-02-21T00:00:00.000
937308
Transaction Id: 937308 • Contract Number: MG-219M • Work Order Id: 8707163
Transaction Id
937308
Contract Number
MG-219M
Work Order Id
8707163
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
2020-02-21T00:00:00.000
937309
Transaction Id: 937309 • Contract Number: MG-219M • Work Order Id: 9275805
Transaction Id
937309
Contract Number
MG-219M
Work Order Id
9275805
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
2020-02-21T00:00:00.000
937310
Transaction Id: 937310 • Contract Number: MG-219M • Work Order Id: 9275804
Transaction Id
937310
Contract Number
MG-219M
Work Order Id
9275804
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
2020-02-21T00:00:00.000
937311
Transaction Id: 937311 • Contract Number: MG-219M • Work Order Id: 9275804
Transaction Id
937311
Contract Number
MG-219M
Work Order Id
9275804
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-02-21T00:00:00.000
937337
Transaction Id: 937337 • Contract Number: MG-219M • Work Order Id: 11106384
Transaction Id
937337
Contract Number
MG-219M
Work Order Id
11106384
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
15.0
Units Used
340.0
Total Cost
5100.0
Transaction Date
2020-03-11T00:00:00.000
936986
Transaction Id: 936986 • Contract Number: MG-219M • Work Order Id: 6827990
Transaction Id
936986
Contract Number
MG-219M
Work Order Id
6827990
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
47.9
Total Cost
2586.6
Transaction Date
2020-02-13T00:00:00.000
937010
Transaction Id: 937010 • Contract Number: MG-219M • Work Order Id: 7635128
Transaction Id
937010
Contract Number
MG-219M
Work Order Id
7635128
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
2020-02-12T00:00:00.000
939035
Transaction Id: 939035 • Contract Number: MG-319M • Work Order Id: 9533764
Transaction Id
939035
Contract Number
MG-319M
Work Order Id
9533764
Line Item Id
295.0
Item Number
28
Line Item Description
HAND AND/OR PNEUMATIC EXCAVATION
Unit Of Measure
CY
Unit Price
225.0
Units Used
0.5
Total Cost
112.5
Transaction Date
2020-01-21T00:00:00.000
939107
Transaction Id: 939107 • Contract Number: MG-219M • Work Order Id: 9689251
Transaction Id
939107
Contract Number
MG-219M
Work Order Id
9689251
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
30.3
Total Cost
1636.2
Transaction Date
2020-02-12T00:00:00.000
934792
Transaction Id: 934792 • Contract Number: MG-319M • Work Order Id: 9533764
Transaction Id
934792
Contract Number
MG-319M
Work Order Id
9533764
Line Item Id
342.0
Item Number
30
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
30.0
Units Used
40.0
Total Cost
1200.0
Transaction Date
2020-01-21T00:00:00.000
936961
Transaction Id: 936961 • Contract Number: MG-219M • Work Order Id: 9161380
Transaction Id
936961
Contract Number
MG-219M
Work Order Id
9161380
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-03T00:00:00.000
937014
Transaction Id: 937014 • Contract Number: MG-219M • Work Order Id: 11070550
Transaction Id
937014
Contract Number
MG-219M
Work Order Id
11070550
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
41.2
Total Cost
2224.8
Transaction Date
2020-02-12T00:00:00.000
937015
Transaction Id: 937015 • Contract Number: MG-219M • Work Order Id: 11070550
Transaction Id
937015
Contract Number
MG-219M
Work Order Id
11070550
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.25
Total Cost
48.75
Transaction Date
2020-02-12T00:00:00.000
937245
Transaction Id: 937245 • Contract Number: MG-219M • Work Order Id: 11060288
Transaction Id
937245
Contract Number
MG-219M
Work Order Id
11060288
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
21.5
Total Cost
1053.5
Transaction Date
2020-03-04T00:00:00.000
937246
Transaction Id: 937246 • Contract Number: MG-219M • Work Order Id: 11060288
Transaction Id
937246
Contract Number
MG-219M
Work Order Id
11060288
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
31.5
Total Cost
1701.0
Transaction Date
2020-03-04T00:00:00.000
937247
Transaction Id: 937247 • Contract Number: MG-219M • Work Order Id: 11060288
Transaction Id
937247
Contract Number
MG-219M
Work Order Id
11060288
Line Item Id
625.0
Item Number
22
Line Item Description
REMOVE DEBRIS (TREE BED AND TREE CANOPY)
Unit Of Measure
HR
Unit Price
195.0
Units Used
0.25
Total Cost
48.75
Transaction Date
2020-03-04T00:00:00.000
937482
Transaction Id: 937482 • Contract Number: MG-219M • Work Order Id: 11100802
Transaction Id
937482
Contract Number
MG-219M
Work Order Id
11100802
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
41.8
Total Cost
2048.2
Transaction Date
2020-03-11T00:00:00.000
936909
Transaction Id: 936909 • Contract Number: MG-219M • Work Order Id: 8936949
Transaction Id
936909
Contract Number
MG-219M
Work Order Id
8936949
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
2020-02-06T00:00:00.000
937058
Transaction Id: 937058 • Contract Number: MG-219M • Work Order Id: 10088284
Transaction Id
937058
Contract Number
MG-219M
Work Order Id
10088284
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-03T00:00:00.000
937062
Transaction Id: 937062 • Contract Number: MG-219M • Work Order Id: 10983818
Transaction Id
937062
Contract Number
MG-219M
Work Order Id
10983818
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
2020-03-03T00:00:00.000
937066
Transaction Id: 937066 • Contract Number: MG-219M • Work Order Id: 10084944
Transaction Id
937066
Contract Number
MG-219M
Work Order Id
10084944
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
2020-03-03T00:00:00.000
937127
Transaction Id: 937127 • Contract Number: MG-219M • Work Order Id: 11120540
Transaction Id
937127
Contract Number
MG-219M
Work Order Id
11120540
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.25
Total Cost
48.75
Transaction Date
2020-02-21T00:00:00.000
937132
Transaction Id: 937132 • Contract Number: MG-219M • Work Order Id: 11119637
Transaction Id
937132
Contract Number
MG-219M
Work Order Id
11119637
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
2020-02-27T00:00:00.000
937133
Transaction Id: 937133 • Contract Number: MG-219M • Work Order Id: 11119637
Transaction Id
937133
Contract Number
MG-219M
Work Order Id
11119637
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-02-27T00:00:00.000
937141
Transaction Id: 937141 • Contract Number: MG-219M • Work Order Id: 7415032
Transaction Id
937141
Contract Number
MG-219M
Work Order Id
7415032
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
2020-02-27T00:00:00.000
937145
Transaction Id: 937145 • Contract Number: MG-219M • Work Order Id: 9161347
Transaction Id
937145
Contract Number
MG-219M
Work Order Id
9161347
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
2020-02-27T00:00:00.000
937148
Transaction Id: 937148 • Contract Number: MG-219M • Work Order Id: 7415047
Transaction Id
937148
Contract Number
MG-219M
Work Order Id
7415047
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
2020-02-27T00:00:00.000
937171
Transaction Id: 937171 • Contract Number: MG-219M • Work Order Id: 11119204
Transaction Id
937171
Contract Number
MG-219M
Work Order Id
11119204
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
2020-02-28T00:00:00.000
937185
Transaction Id: 937185 • Contract Number: MG-219M • Work Order Id: 9030629
Transaction Id
937185
Contract Number
MG-219M
Work Order Id
9030629
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
2020-03-02T00:00:00.000
NYC Data AI • Public-data exploration interface