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
746441
Transaction Id: 746441 • Contract Number: QG-215M • Work Order Id: 665714
Transaction Id
746441
Contract Number
QG-215M
Work Order Id
665714
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-12-31T00:00:00.000
746442
Transaction Id: 746442 • Contract Number: QG-215M • Work Order Id: 665714
Transaction Id
746442
Contract Number
QG-215M
Work Order Id
665714
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
24.0
Total Cost
237.60000000000002
Transaction Date
2015-12-31T00:00:00.000
746443
Transaction Id: 746443 • Contract Number: QG-215M • Work Order Id: 665714
Transaction Id
746443
Contract Number
QG-215M
Work Order Id
665714
Line Item Id
335.0
Item Number
05
Line Item Description
STUMP REMOVALS OF OVER 30 TO 36 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
250.0
Units Used
1.0
Total Cost
250.0
Transaction Date
2015-09-30T00:00:00.000
746444
Transaction Id: 746444 • Contract Number: QG-215M • Work Order Id: 669305
Transaction Id
746444
Contract Number
QG-215M
Work Order Id
669305
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-29T00:00:00.000
746445
Transaction Id: 746445 • Contract Number: QG-215M • Work Order Id: 669305
Transaction Id
746445
Contract Number
QG-215M
Work Order Id
669305
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
24.0
Total Cost
237.60000000000002
Transaction Date
2015-09-11T00:00:00.000
746446
Transaction Id: 746446 • Contract Number: QG-215M • Work Order Id: 669305
Transaction Id
746446
Contract Number
QG-215M
Work Order Id
669305
Line Item Id
275.0
Item Number
01
Line Item Description
STUMP REMOVALS OF OVER 8 TO 12 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
75.0
Units Used
1.0
Total Cost
75.0
Transaction Date
2015-09-30T00:00:00.000
746447
Transaction Id: 746447 • Contract Number: QG-215M • Work Order Id: 648336
Transaction Id
746447
Contract Number
QG-215M
Work Order Id
648336
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-10-07T00:00:00.000
746448
Transaction Id: 746448 • Contract Number: QG-215M • Work Order Id: 648336
Transaction Id
746448
Contract Number
QG-215M
Work Order Id
648336
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
24.0
Total Cost
237.60000000000002
Transaction Date
2015-09-21T00:00:00.000
746449
Transaction Id: 746449 • Contract Number: QG-215M • Work Order Id: 668105
Transaction Id
746449
Contract Number
QG-215M
Work Order Id
668105
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-10-01T00:00:00.000
746450
Transaction Id: 746450 • Contract Number: QG-215M • Work Order Id: 668105
Transaction Id
746450
Contract Number
QG-215M
Work Order Id
668105
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
27.0
Total Cost
267.3
Transaction Date
2015-09-15T00:00:00.000
746451
Transaction Id: 746451 • Contract Number: QG-215M • Work Order Id: 668105
Transaction Id
746451
Contract Number
QG-215M
Work Order Id
668105
Line Item Id
297.0
Item Number
03
Line Item Description
STUMP REMOVALS OF OVER 18 TO 24 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
125.0
Units Used
1.0
Total Cost
125.0
Transaction Date
2015-09-30T00:00:00.000
746452
Transaction Id: 746452 • Contract Number: QG-215M • Work Order Id: 694135
Transaction Id
746452
Contract Number
QG-215M
Work Order Id
694135
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-10-06T00:00:00.000
746453
Transaction Id: 746453 • Contract Number: QG-215M • Work Order Id: 694135
Transaction Id
746453
Contract Number
QG-215M
Work Order Id
694135
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
28.0
Total Cost
277.2
Transaction Date
2015-09-22T00:00:00.000
746454
Transaction Id: 746454 • Contract Number: QG-215M • Work Order Id: 695740
Transaction Id
746454
Contract Number
QG-215M
Work Order Id
695740
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-10-06T00:00:00.000
746455
Transaction Id: 746455 • Contract Number: QG-215M • Work Order Id: 695740
Transaction Id
746455
Contract Number
QG-215M
Work Order Id
695740
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
51.7
Total Cost
511.83000000000004
Transaction Date
2015-09-22T00:00:00.000
746456
Transaction Id: 746456 • Contract Number: QG-215M • Work Order Id: 696145
Transaction Id
746456
Contract Number
QG-215M
Work Order Id
696145
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-10-06T00:00:00.000
746457
Transaction Id: 746457 • Contract Number: QG-215M • Work Order Id: 696145
Transaction Id
746457
Contract Number
QG-215M
Work Order Id
696145
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
24.0
Total Cost
237.60000000000002
Transaction Date
2015-09-23T00:00:00.000
746459
Transaction Id: 746459 • Contract Number: QG-215M • Work Order Id: 648375
Transaction Id
746459
Contract Number
QG-215M
Work Order Id
648375
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
44.2
Total Cost
751.4000000000001
Transaction Date
2015-11-04T00:00:00.000
746460
Transaction Id: 746460 • Contract Number: QG-215M • Work Order Id: 649938
Transaction Id
746460
Contract Number
QG-215M
Work Order Id
649938
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-25T00:00:00.000
746461
Transaction Id: 746461 • Contract Number: QG-215M • Work Order Id: 649938
Transaction Id
746461
Contract Number
QG-215M
Work Order Id
649938
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
40.0
Total Cost
480.0
Transaction Date
2015-09-25T00:00:00.000
746462
Transaction Id: 746462 • Contract Number: QG-215M • Work Order Id: 649938
Transaction Id
746462
Contract Number
QG-215M
Work Order Id
649938
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
72.0
Units Used
15.6
Total Cost
1123.2
Transaction Date
2016-03-14T00:00:00.000
746463
Transaction Id: 746463 • Contract Number: QG-215M • Work Order Id: 648393
Transaction Id
746463
Contract Number
QG-215M
Work Order Id
648393
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-25T00:00:00.000
746464
Transaction Id: 746464 • Contract Number: QG-215M • Work Order Id: 648393
Transaction Id
746464
Contract Number
QG-215M
Work Order Id
648393
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
50.0
Total Cost
600.0
Transaction Date
2015-09-25T00:00:00.000
746465
Transaction Id: 746465 • Contract Number: QG-215M • Work Order Id: 648393
Transaction Id
746465
Contract Number
QG-215M
Work Order Id
648393
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
72.0
Units Used
17.6
Total Cost
1267.2
Transaction Date
2016-02-23T00:00:00.000
746466
Transaction Id: 746466 • Contract Number: QG-215M • Work Order Id: 648410
Transaction Id
746466
Contract Number
QG-215M
Work Order Id
648410
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-25T00:00:00.000
746467
Transaction Id: 746467 • Contract Number: QG-215M • Work Order Id: 648410
Transaction Id
746467
Contract Number
QG-215M
Work Order Id
648410
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
49.2
Total Cost
590.4000000000001
Transaction Date
2015-09-25T00:00:00.000
746468
Transaction Id: 746468 • Contract Number: QG-215M • Work Order Id: 648410
Transaction Id
746468
Contract Number
QG-215M
Work Order Id
648410
Line Item Id
351.0
Item Number
35
Line Item Description
STEEL TREE PIT GUARD - A
Unit Of Measure
LF
Unit Price
62.0
Units Used
17.5
Total Cost
1085.0
Transaction Date
2016-03-14T00:00:00.000
746469
Transaction Id: 746469 • Contract Number: QG-215M • Work Order Id: 649957
Transaction Id
746469
Contract Number
QG-215M
Work Order Id
649957
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-25T00:00:00.000
746470
Transaction Id: 746470 • Contract Number: QG-215M • Work Order Id: 649957
Transaction Id
746470
Contract Number
QG-215M
Work Order Id
649957
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
50.0
Total Cost
850.0
Transaction Date
2015-09-25T00:00:00.000
746471
Transaction Id: 746471 • Contract Number: QG-215M • Work Order Id: 647614
Transaction Id
746471
Contract Number
QG-215M
Work Order Id
647614
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-25T00:00:00.000
746472
Transaction Id: 746472 • Contract Number: QG-215M • Work Order Id: 647614
Transaction Id
746472
Contract Number
QG-215M
Work Order Id
647614
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
50.0
Total Cost
850.0
Transaction Date
2015-09-25T00:00:00.000
746473
Transaction Id: 746473 • Contract Number: QG-215M • Work Order Id: 650754
Transaction Id
746473
Contract Number
QG-215M
Work Order Id
650754
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-25T00:00:00.000
746474
Transaction Id: 746474 • Contract Number: QG-215M • Work Order Id: 650754
Transaction Id
746474
Contract Number
QG-215M
Work Order Id
650754
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
50.0
Total Cost
850.0
Transaction Date
2015-09-25T00:00:00.000
746475
Transaction Id: 746475 • Contract Number: QG-215M • Work Order Id: 697719
Transaction Id
746475
Contract Number
QG-215M
Work Order Id
697719
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-25T00:00:00.000
746476
Transaction Id: 746476 • Contract Number: QG-215M • Work Order Id: 697719
Transaction Id
746476
Contract Number
QG-215M
Work Order Id
697719
Line Item Id
357.0
Item Number
10.5
Line Item Description
PREP EXISTING SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
10.8
Units Used
25.0
Total Cost
270.0
Transaction Date
2015-09-25T00:00:00.000
746477
Transaction Id: 746477 • Contract Number: QG-215M • Work Order Id: 697719
Transaction Id
746477
Contract Number
QG-215M
Work Order Id
697719
Line Item Id
356.0
Item Number
09.5
Line Item Description
PREP NEW SIDEWALK TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
15.3
Units Used
26.3
Total Cost
402.39000000000004
Transaction Date
2015-09-25T00:00:00.000
746478
Transaction Id: 746478 • Contract Number: QG-215M • Work Order Id: 697719
Transaction Id
746478
Contract Number
QG-215M
Work Order Id
697719
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
72.0
Units Used
17.8
Total Cost
1281.6000000000001
Transaction Date
2016-02-23T00:00:00.000
746479
Transaction Id: 746479 • Contract Number: QG-215M • Work Order Id: 651487
Transaction Id
746479
Contract Number
QG-215M
Work Order Id
651487
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-25T00:00:00.000
746480
Transaction Id: 746480 • Contract Number: QG-215M • Work Order Id: 651487
Transaction Id
746480
Contract Number
QG-215M
Work Order Id
651487
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
12.0
Units Used
50.0
Total Cost
600.0
Transaction Date
2015-09-25T00:00:00.000
746481
Transaction Id: 746481 • Contract Number: QG-215M • Work Order Id: 651487
Transaction Id
746481
Contract Number
QG-215M
Work Order Id
651487
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
72.0
Units Used
17.6
Total Cost
1267.2
Transaction Date
2016-02-23T00:00:00.000
746482
Transaction Id: 746482 • Contract Number: QG-215M • Work Order Id: 651877
Transaction Id
746482
Contract Number
QG-215M
Work Order Id
651877
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-25T00:00:00.000
746483
Transaction Id: 746483 • Contract Number: QG-215M • Work Order Id: 651877
Transaction Id
746483
Contract Number
QG-215M
Work Order Id
651877
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
50.0
Total Cost
850.0
Transaction Date
2015-09-25T00:00:00.000
746484
Transaction Id: 746484 • Contract Number: QG-215M • Work Order Id: 651877
Transaction Id
746484
Contract Number
QG-215M
Work Order Id
651877
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
72.0
Units Used
17.2
Total Cost
1238.3999999999999
Transaction Date
2016-02-23T00:00:00.000
746485
Transaction Id: 746485 • Contract Number: QG-215M • Work Order Id: 652151
Transaction Id
746485
Contract Number
QG-215M
Work Order Id
652151
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-25T00:00:00.000
746486
Transaction Id: 746486 • Contract Number: QG-215M • Work Order Id: 652151
Transaction Id
746486
Contract Number
QG-215M
Work Order Id
652151
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
17.0
Units Used
50.0
Total Cost
850.0
Transaction Date
2015-09-25T00:00:00.000
746487
Transaction Id: 746487 • Contract Number: QG-215M • Work Order Id: 652151
Transaction Id
746487
Contract Number
QG-215M
Work Order Id
652151
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
72.0
Units Used
16.8
Total Cost
1209.6000000000001
Transaction Date
2016-03-14T00:00:00.000
746488
Transaction Id: 746488 • Contract Number: QG-215M • Work Order Id: 704121
Transaction Id
746488
Contract Number
QG-215M
Work Order Id
704121
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-09-24T00:00:00.000
746489
Transaction Id: 746489 • Contract Number: QG-215M • Work Order Id: 704121
Transaction Id
746489
Contract Number
QG-215M
Work Order Id
704121
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
11.0
Units Used
24.0
Total Cost
264.0
Transaction Date
2015-09-24T00:00:00.000
746490
Transaction Id: 746490 • Contract Number: QG-215M • Work Order Id: 699318
Transaction Id
746490
Contract Number
QG-215M
Work Order Id
699318
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
375.0
Units Used
1.0
Total Cost
375.0
Transaction Date
2015-10-05T00:00:00.000
746491
Transaction Id: 746491 • Contract Number: QG-215M • Work Order Id: 699318
Transaction Id
746491
Contract Number
QG-215M
Work Order Id
699318
Line Item Id
355.0
Item Number
11.5
Line Item Description
PREP LAWN TREE PITS FOR PLANTING W/REM
Unit Of Measure
SF
Unit Price
9.9
Units Used
20.0
Total Cost
198.0
Transaction Date
2015-09-23T00:00:00.000
NYC Data AI • Public-data exploration interface