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
1033862
Transaction Id: 1033862 • Contract Number: BG-1119M • Work Order Id: 20441182
Transaction Id
1033862
Contract Number
BG-1119M
Work Order Id
20441182
Line Item Id
700.0
Item Number
18
Line Item Description
PLANTING PROCURED TREES, 2.5 – 3.0 INCH CALIPER
Unit Of Measure
EA
Unit Price
1550.0
Units Used
1.0
Total Cost
1550.0
Transaction Date
2023-06-08T00:00:00.000
1039322
Transaction Id: 1039322 • Contract Number: RG-519M • Work Order Id: 18259168
Transaction Id
1039322
Contract Number
RG-519M
Work Order Id
18259168
Line Item Id
283.0
Item Number
28
Line Item Description
RANGE FENCE 4’-0” HEIGHT
Unit Of Measure
LF
Unit Price
10.0
Units Used
20.0
Total Cost
200.0
Transaction Date
1900-07-18T00:00:00.000
1040084
Transaction Id: 1040084 • Contract Number: QG-1219M • Work Order Id: 21453543
Transaction Id
1040084
Contract Number
QG-1219M
Work Order Id
21453543
Line Item Id
634.0
Item Number
16
Line Item Description
PLANTING STREET TREES, 2.5 - 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1600.0
Units Used
1365.0
Total Cost
2184000.0
Transaction Date
1899-12-30T00:00:00.000
1040086
Transaction Id: 1040086 • Contract Number: QG-1219M • Work Order Id: 21456893
Transaction Id
1040086
Contract Number
QG-1219M
Work Order Id
21456893
Line Item Id
634.0
Item Number
16
Line Item Description
PLANTING STREET TREES, 2.5 - 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1600.0
Units Used
1365.0
Total Cost
2184000.0
Transaction Date
1899-12-30T00:00:00.000
1040088
Transaction Id: 1040088 • Contract Number: QG-1219M • Work Order Id: 21453541
Transaction Id
1040088
Contract Number
QG-1219M
Work Order Id
21453541
Line Item Id
634.0
Item Number
16
Line Item Description
PLANTING STREET TREES, 2.5 - 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1600.0
Units Used
1365.0
Total Cost
2184000.0
Transaction Date
1899-12-30T00:00:00.000
1041770
Transaction Id: 1041770 • Contract Number: MG-1219MA • Work Order Id: 19910696
Transaction Id
1041770
Contract Number
MG-1219MA
Work Order Id
19910696
Line Item Id
342.0
Item Number
32
Line Item Description
CONCRETE PAVEMENT W/O BASE - 4"
Unit Of Measure
SF
Unit Price
35.0
Units Used
24.6
Total Cost
861.0
Transaction Date
2023-10-03T00:00:00.000
1038075
Transaction Id: 1038075 • Contract Number: BG-222M • Work Order Id: 21282682
Transaction Id
1038075
Contract Number
BG-222M
Work Order Id
21282682
Line Item Id
625.0
Item Number
28
Line Item Description
REMOVE DEBRIS (TREE BED AND TREE CANOPY)
Unit Of Measure
HR
Unit Price
100.0
Units Used
0.25
Total Cost
25.0
Transaction Date
2023-12-05T00:00:00.000
1042619
Transaction Id: 1042619 • Contract Number: MG-1319MA • Work Order Id: 21631725
Transaction Id
1042619
Contract Number
MG-1319MA
Work Order Id
21631725
Line Item Id
647.0
Item Number
09
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
45.8
Units Used
40.8
Total Cost
1868.6399999999996
Transaction Date
2023-10-19T00:00:00.000
1047697
Transaction Id: 1047697 • Contract Number: BG-622M • Work Order Id: 21323826
Transaction Id
1047697
Contract Number
BG-622M
Work Order Id
21323826
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
50.8
Total Cost
1879.6
Transaction Date
2023-10-30T00:00:00.000
1047698
Transaction Id: 1047698 • Contract Number: BG-622M • Work Order Id: 21323817
Transaction Id
1047698
Contract Number
BG-622M
Work Order Id
21323817
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
44.6
Total Cost
1650.2
Transaction Date
2023-10-30T00:00:00.000
1048037
Transaction Id: 1048037 • Contract Number: BG-622M • Work Order Id: 21346486
Transaction Id
1048037
Contract Number
BG-622M
Work Order Id
21346486
Line Item Id
647.0
Item Number
11
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
49.6
Total Cost
1835.2
Transaction Date
2023-10-31T00:00:00.000
1048996
Transaction Id: 1048996 • Contract Number: BG-1119M • Work Order Id: 19674897
Transaction Id
1048996
Contract Number
BG-1119M
Work Order Id
19674897
Line Item Id
659.0
Item Number
13
Line Item Description
PREPARING LAWN TREE BEDS WITH AMENDED EXISTING SOIL
Unit Of Measure
SF
Unit Price
30.0
Units Used
36.0
Total Cost
1080.0
Transaction Date
2023-11-02T00:00:00.000
1048997
Transaction Id: 1048997 • Contract Number: BG-1119M • Work Order Id: 19674897
Transaction Id
1048997
Contract Number
BG-1119M
Work Order Id
19674897
Line Item Id
279.0
Item Number
26
Line Item Description
TRANSPLANTING TREES UP TO 4” CALIPER
Unit Of Measure
EA
Unit Price
500.0
Units Used
1.0
Total Cost
500.0
Transaction Date
2023-11-02T00:00:00.000
1038694
Transaction Id: 1038694 • Contract Number: QG-1119MR • Work Order Id: 20968437
Transaction Id
1038694
Contract Number
QG-1119MR
Work Order Id
20968437
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1039056
Transaction Id: 1039056 • Contract Number: QG-1119MR • Work Order Id: 21245045
Transaction Id
1039056
Contract Number
QG-1119MR
Work Order Id
21245045
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
43.68
Units Used
35.0
Total Cost
1528.8
Transaction Date
1905-03-21T00:00:00.000
1039989
Transaction Id: 1039989 • Contract Number: QG-1219M • Work Order Id: 21005152
Transaction Id
1039989
Contract Number
QG-1219M
Work Order Id
21005152
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
32.1
Total Cost
1187.7
Transaction Date
2023-05-05T00:00:00.000
1039990
Transaction Id: 1039990 • Contract Number: QG-1219M • Work Order Id: 21005152
Transaction Id
1039990
Contract Number
QG-1219M
Work Order Id
21005152
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1200.0
Units Used
1.0
Total Cost
1200.0
Transaction Date
2023-05-15T00:00:00.000
1039992
Transaction Id: 1039992 • Contract Number: QG-1219M • Work Order Id: 20945593
Transaction Id
1039992
Contract Number
QG-1219M
Work Order Id
20945593
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
32.1
Total Cost
1187.7
Transaction Date
2023-05-05T00:00:00.000
1039993
Transaction Id: 1039993 • Contract Number: QG-1219M • Work Order Id: 20945593
Transaction Id
1039993
Contract Number
QG-1219M
Work Order Id
20945593
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1200.0
Units Used
1.0
Total Cost
1200.0
Transaction Date
2023-05-15T00:00:00.000
1039995
Transaction Id: 1039995 • Contract Number: QG-1219M • Work Order Id: 21554133
Transaction Id
1039995
Contract Number
QG-1219M
Work Order Id
21554133
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
32.1
Total Cost
1187.7
Transaction Date
2023-05-05T00:00:00.000
1039996
Transaction Id: 1039996 • Contract Number: QG-1219M • Work Order Id: 21554133
Transaction Id
1039996
Contract Number
QG-1219M
Work Order Id
21554133
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1200.0
Units Used
1.0
Total Cost
1200.0
Transaction Date
2023-05-15T00:00:00.000
1039997
Transaction Id: 1039997 • Contract Number: QG-1219M • Work Order Id: 20976342
Transaction Id
1039997
Contract Number
QG-1219M
Work Order Id
20976342
Line Item Id
620.0
Item Number
11
Line Item Description
PREPARING LAWN TREE BEDS
Unit Of Measure
SF
Unit Price
37.0
Units Used
32.1
Total Cost
1187.7
Transaction Date
2023-05-05T00:00:00.000
1039998
Transaction Id: 1039998 • Contract Number: QG-1219M • Work Order Id: 20976342
Transaction Id
1039998
Contract Number
QG-1219M
Work Order Id
20976342
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1200.0
Units Used
1.0
Total Cost
1200.0
Transaction Date
2023-05-15T00:00:00.000
1038480
Transaction Id: 1038480 • Contract Number: QG-1119MR • Work Order Id: 21076137
Transaction Id
1038480
Contract Number
QG-1119MR
Work Order Id
21076137
Line Item Id
650.0
Item Number
14
Line Item Description
PLANTING PROCURED STREET TREES, 2.5 – 3 INCH CALIPER
Unit Of Measure
EA
Unit Price
1300.0
Units Used
1203.0
Total Cost
1563900.0
Transaction Date
1899-12-30T00:00:00.000
1038481
Transaction Id: 1038481 • Contract Number: QG-1119MR • Work Order Id: 21076137
Transaction Id
1038481
Contract Number
QG-1119MR
Work Order Id
21076137
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038482
Transaction Id: 1038482 • Contract Number: QG-1119MR • Work Order Id: 21076142
Transaction Id
1038482
Contract Number
QG-1119MR
Work Order Id
21076142
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038483
Transaction Id: 1038483 • Contract Number: QG-1119MR • Work Order Id: 21076149
Transaction Id
1038483
Contract Number
QG-1119MR
Work Order Id
21076149
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038484
Transaction Id: 1038484 • Contract Number: QG-1119MR • Work Order Id: 21136760
Transaction Id
1038484
Contract Number
QG-1119MR
Work Order Id
21136760
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038485
Transaction Id: 1038485 • Contract Number: QG-1119MR • Work Order Id: 21076117
Transaction Id
1038485
Contract Number
QG-1119MR
Work Order Id
21076117
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038486
Transaction Id: 1038486 • Contract Number: QG-1119MR • Work Order Id: 21076148
Transaction Id
1038486
Contract Number
QG-1119MR
Work Order Id
21076148
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038487
Transaction Id: 1038487 • Contract Number: QG-1119MR • Work Order Id: 21076113
Transaction Id
1038487
Contract Number
QG-1119MR
Work Order Id
21076113
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038488
Transaction Id: 1038488 • Contract Number: QG-1119MR • Work Order Id: 21076109
Transaction Id
1038488
Contract Number
QG-1119MR
Work Order Id
21076109
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038489
Transaction Id: 1038489 • Contract Number: QG-1119MR • Work Order Id: 21076141
Transaction Id
1038489
Contract Number
QG-1119MR
Work Order Id
21076141
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038490
Transaction Id: 1038490 • Contract Number: QG-1119MR • Work Order Id: 21076100
Transaction Id
1038490
Contract Number
QG-1119MR
Work Order Id
21076100
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038491
Transaction Id: 1038491 • Contract Number: QG-1119MR • Work Order Id: 21076147
Transaction Id
1038491
Contract Number
QG-1119MR
Work Order Id
21076147
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038492
Transaction Id: 1038492 • Contract Number: QG-1119MR • Work Order Id: 21136766
Transaction Id
1038492
Contract Number
QG-1119MR
Work Order Id
21136766
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038493
Transaction Id: 1038493 • Contract Number: QG-1119MR • Work Order Id: 21136775
Transaction Id
1038493
Contract Number
QG-1119MR
Work Order Id
21136775
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038494
Transaction Id: 1038494 • Contract Number: QG-1119MR • Work Order Id: 21136764
Transaction Id
1038494
Contract Number
QG-1119MR
Work Order Id
21136764
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038495
Transaction Id: 1038495 • Contract Number: QG-1119MR • Work Order Id: 21136773
Transaction Id
1038495
Contract Number
QG-1119MR
Work Order Id
21136773
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
0.0
Total Cost
0.0
Transaction Date
1899-12-30T00:00:00.000
1038500
Transaction Id: 1038500 • Contract Number: QG-1119MR • Work Order Id: 21016311
Transaction Id
1038500
Contract Number
QG-1119MR
Work Order Id
21016311
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038503
Transaction Id: 1038503 • Contract Number: QG-1119MR • Work Order Id: 21016333
Transaction Id
1038503
Contract Number
QG-1119MR
Work Order Id
21016333
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038504
Transaction Id: 1038504 • Contract Number: QG-1119MR • Work Order Id: 21016332
Transaction Id
1038504
Contract Number
QG-1119MR
Work Order Id
21016332
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038510
Transaction Id: 1038510 • Contract Number: QG-1119MR • Work Order Id: 21076123
Transaction Id
1038510
Contract Number
QG-1119MR
Work Order Id
21076123
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038512
Transaction Id: 1038512 • Contract Number: QG-1119MR • Work Order Id: 21016319
Transaction Id
1038512
Contract Number
QG-1119MR
Work Order Id
21016319
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038520
Transaction Id: 1038520 • Contract Number: QG-1119MR • Work Order Id: 21039040
Transaction Id
1038520
Contract Number
QG-1119MR
Work Order Id
21039040
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038526
Transaction Id: 1038526 • Contract Number: QG-1119MR • Work Order Id: 21016317
Transaction Id
1038526
Contract Number
QG-1119MR
Work Order Id
21016317
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038530
Transaction Id: 1038530 • Contract Number: QG-1119MR • Work Order Id: 21016310
Transaction Id
1038530
Contract Number
QG-1119MR
Work Order Id
21016310
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038531
Transaction Id: 1038531 • Contract Number: QG-1119MR • Work Order Id: 21016336
Transaction Id
1038531
Contract Number
QG-1119MR
Work Order Id
21016336
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038532
Transaction Id: 1038532 • Contract Number: QG-1119MR • Work Order Id: 21016340
Transaction Id
1038532
Contract Number
QG-1119MR
Work Order Id
21016340
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000
1038533
Transaction Id: 1038533 • Contract Number: QG-1119MR • Work Order Id: 21016326
Transaction Id
1038533
Contract Number
QG-1119MR
Work Order Id
21016326
Line Item Id
647.0
Item Number
9
Line Item Description
PREPARING NEW SIDEWALK TREE BEDS
Unit Of Measure
SF
Unit Price
47.84
Units Used
41.0
Total Cost
1961.44
Transaction Date
1899-12-30T00:00:00.000