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
747489
Transaction Id: 747489 • Contract Number: BG-415M • Work Order Id: 653309
Transaction Id
747489
Contract Number
BG-415M
Work Order Id
653309
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-11T00:00:00.000
747490
Transaction Id: 747490 • Contract Number: BG-415M • Work Order Id: 655599
Transaction Id
747490
Contract Number
BG-415M
Work Order Id
655599
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
45.0
Total Cost
630.0
Transaction Date
2015-11-11T00:00:00.000
747491
Transaction Id: 747491 • Contract Number: BG-415M • Work Order Id: 655599
Transaction Id
747491
Contract Number
BG-415M
Work Order Id
655599
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-12T00:00:00.000
747492
Transaction Id: 747492 • Contract Number: BG-415M • Work Order Id: 653311
Transaction Id
747492
Contract Number
BG-415M
Work Order Id
653311
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
45.8
Total Cost
641.1999999999999
Transaction Date
2015-11-11T00:00:00.000
747493
Transaction Id: 747493 • Contract Number: BG-415M • Work Order Id: 653311
Transaction Id
747493
Contract Number
BG-415M
Work Order Id
653311
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-12T00:00:00.000
747494
Transaction Id: 747494 • Contract Number: BG-415M • Work Order Id: 656389
Transaction Id
747494
Contract Number
BG-415M
Work Order Id
656389
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
34.6
Total Cost
484.40000000000003
Transaction Date
2015-11-11T00:00:00.000
747495
Transaction Id: 747495 • Contract Number: BG-415M • Work Order Id: 656389
Transaction Id
747495
Contract Number
BG-415M
Work Order Id
656389
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-27T00:00:00.000
747496
Transaction Id: 747496 • Contract Number: BG-415M • Work Order Id: 655212
Transaction Id
747496
Contract Number
BG-415M
Work Order Id
655212
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
45.0
Total Cost
630.0
Transaction Date
2015-11-12T00:00:00.000
747497
Transaction Id: 747497 • Contract Number: BG-415M • Work Order Id: 655212
Transaction Id
747497
Contract Number
BG-415M
Work Order Id
655212
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-12T00:00:00.000
747498
Transaction Id: 747498 • Contract Number: BG-415M • Work Order Id: 655213
Transaction Id
747498
Contract Number
BG-415M
Work Order Id
655213
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
41.7
Total Cost
583.8000000000001
Transaction Date
2015-11-12T00:00:00.000
747499
Transaction Id: 747499 • Contract Number: BG-415M • Work Order Id: 655213
Transaction Id
747499
Contract Number
BG-415M
Work Order Id
655213
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-12T00:00:00.000
747500
Transaction Id: 747500 • Contract Number: BG-415M • Work Order Id: 655230
Transaction Id
747500
Contract Number
BG-415M
Work Order Id
655230
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
39.0
Total Cost
546.0
Transaction Date
2015-11-12T00:00:00.000
747501
Transaction Id: 747501 • Contract Number: BG-415M • Work Order Id: 655230
Transaction Id
747501
Contract Number
BG-415M
Work Order Id
655230
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-12T00:00:00.000
747502
Transaction Id: 747502 • Contract Number: BG-415M • Work Order Id: 653325
Transaction Id
747502
Contract Number
BG-415M
Work Order Id
653325
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
45.0
Total Cost
630.0
Transaction Date
2015-11-12T00:00:00.000
747503
Transaction Id: 747503 • Contract Number: BG-415M • Work Order Id: 653325
Transaction Id
747503
Contract Number
BG-415M
Work Order Id
653325
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-12T00:00:00.000
747504
Transaction Id: 747504 • Contract Number: BG-415M • Work Order Id: 654014
Transaction Id
747504
Contract Number
BG-415M
Work Order Id
654014
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
48.8
Total Cost
683.1999999999999
Transaction Date
2015-11-11T00:00:00.000
747505
Transaction Id: 747505 • Contract Number: BG-415M • Work Order Id: 654014
Transaction Id
747505
Contract Number
BG-415M
Work Order Id
654014
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-17T00:00:00.000
747506
Transaction Id: 747506 • Contract Number: BG-415M • Work Order Id: 656413
Transaction Id
747506
Contract Number
BG-415M
Work Order Id
656413
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
32.3
Total Cost
452.19999999999993
Transaction Date
2015-11-11T00:00:00.000
747507
Transaction Id: 747507 • Contract Number: BG-415M • Work Order Id: 656413
Transaction Id
747507
Contract Number
BG-415M
Work Order Id
656413
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-17T00:00:00.000
747510
Transaction Id: 747510 • Contract Number: BG-415M • Work Order Id: 653335
Transaction Id
747510
Contract Number
BG-415M
Work Order Id
653335
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
39.1
Total Cost
547.4
Transaction Date
2015-11-12T00:00:00.000
747511
Transaction Id: 747511 • Contract Number: BG-415M • Work Order Id: 653335
Transaction Id
747511
Contract Number
BG-415M
Work Order Id
653335
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-12T00:00:00.000
747512
Transaction Id: 747512 • Contract Number: BG-415M • Work Order Id: 1327477
Transaction Id
747512
Contract Number
BG-415M
Work Order Id
1327477
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
38.7
Total Cost
541.8000000000001
Transaction Date
2015-11-12T00:00:00.000
747513
Transaction Id: 747513 • Contract Number: BG-415M • Work Order Id: 1327477
Transaction Id
747513
Contract Number
BG-415M
Work Order Id
1327477
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-12T00:00:00.000
747518
Transaction Id: 747518 • Contract Number: BG-415M • Work Order Id: 1320683
Transaction Id
747518
Contract Number
BG-415M
Work Order Id
1320683
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
52.9
Total Cost
740.6
Transaction Date
2015-11-11T00:00:00.000
747519
Transaction Id: 747519 • Contract Number: BG-415M • Work Order Id: 1320683
Transaction Id
747519
Contract Number
BG-415M
Work Order Id
1320683
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-01-08T00:00:00.000
747520
Transaction Id: 747520 • Contract Number: BG-415M • Work Order Id: 654026
Transaction Id
747520
Contract Number
BG-415M
Work Order Id
654026
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
40.4
Total Cost
565.6
Transaction Date
2015-11-11T00:00:00.000
747521
Transaction Id: 747521 • Contract Number: BG-415M • Work Order Id: 654026
Transaction Id
747521
Contract Number
BG-415M
Work Order Id
654026
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-01-08T00:00:00.000
747522
Transaction Id: 747522 • Contract Number: BG-415M • Work Order Id: 647612
Transaction Id
747522
Contract Number
BG-415M
Work Order Id
647612
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
45.0
Total Cost
630.0
Transaction Date
2015-11-11T00:00:00.000
747523
Transaction Id: 747523 • Contract Number: BG-415M • Work Order Id: 647612
Transaction Id
747523
Contract Number
BG-415M
Work Order Id
647612
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-01-08T00:00:00.000
747524
Transaction Id: 747524 • Contract Number: BG-415M • Work Order Id: 650748
Transaction Id
747524
Contract Number
BG-415M
Work Order Id
650748
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
44.2
Total Cost
618.8000000000001
Transaction Date
2015-11-11T00:00:00.000
747525
Transaction Id: 747525 • Contract Number: BG-415M • Work Order Id: 650748
Transaction Id
747525
Contract Number
BG-415M
Work Order Id
650748
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-12T00:00:00.000
747526
Transaction Id: 747526 • Contract Number: BG-415M • Work Order Id: 650752
Transaction Id
747526
Contract Number
BG-415M
Work Order Id
650752
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
45.0
Total Cost
630.0
Transaction Date
2015-11-11T00:00:00.000
747527
Transaction Id: 747527 • Contract Number: BG-415M • Work Order Id: 650752
Transaction Id
747527
Contract Number
BG-415M
Work Order Id
650752
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-11T00:00:00.000
747528
Transaction Id: 747528 • Contract Number: BG-415M • Work Order Id: 648399
Transaction Id
747528
Contract Number
BG-415M
Work Order Id
648399
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
47.5
Total Cost
665.0
Transaction Date
2015-11-11T00:00:00.000
747529
Transaction Id: 747529 • Contract Number: BG-415M • Work Order Id: 648399
Transaction Id
747529
Contract Number
BG-415M
Work Order Id
648399
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-11T00:00:00.000
747530
Transaction Id: 747530 • Contract Number: BG-415M • Work Order Id: 648400
Transaction Id
747530
Contract Number
BG-415M
Work Order Id
648400
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
47.1
Total Cost
659.4
Transaction Date
2015-11-11T00:00:00.000
747531
Transaction Id: 747531 • Contract Number: BG-415M • Work Order Id: 648400
Transaction Id
747531
Contract Number
BG-415M
Work Order Id
648400
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-11T00:00:00.000
747532
Transaction Id: 747532 • Contract Number: BG-415M • Work Order Id: 647619
Transaction Id
747532
Contract Number
BG-415M
Work Order Id
647619
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
47.5
Total Cost
665.0
Transaction Date
2015-11-11T00:00:00.000
747533
Transaction Id: 747533 • Contract Number: BG-415M • Work Order Id: 647619
Transaction Id
747533
Contract Number
BG-415M
Work Order Id
647619
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-11T00:00:00.000
747534
Transaction Id: 747534 • Contract Number: BG-415M • Work Order Id: 649553
Transaction Id
747534
Contract Number
BG-415M
Work Order Id
649553
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
36.3
Total Cost
508.19999999999993
Transaction Date
2015-11-11T00:00:00.000
747535
Transaction Id: 747535 • Contract Number: BG-415M • Work Order Id: 649553
Transaction Id
747535
Contract Number
BG-415M
Work Order Id
649553
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-11T00:00:00.000
747536
Transaction Id: 747536 • Contract Number: BG-415M • Work Order Id: 648403
Transaction Id
747536
Contract Number
BG-415M
Work Order Id
648403
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
32.8
Total Cost
459.19999999999993
Transaction Date
2015-11-11T00:00:00.000
747537
Transaction Id: 747537 • Contract Number: BG-415M • Work Order Id: 648403
Transaction Id
747537
Contract Number
BG-415M
Work Order Id
648403
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-11T00:00:00.000
747538
Transaction Id: 747538 • Contract Number: BG-415M • Work Order Id: 650759
Transaction Id
747538
Contract Number
BG-415M
Work Order Id
650759
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
50.8
Total Cost
711.1999999999999
Transaction Date
2015-11-11T00:00:00.000
747539
Transaction Id: 747539 • Contract Number: BG-415M • Work Order Id: 650759
Transaction Id
747539
Contract Number
BG-415M
Work Order Id
650759
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-01-08T00:00:00.000
747540
Transaction Id: 747540 • Contract Number: BG-415M • Work Order Id: 648407
Transaction Id
747540
Contract Number
BG-415M
Work Order Id
648407
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
48.7
Total Cost
681.8000000000001
Transaction Date
2015-11-11T00:00:00.000
747541
Transaction Id: 747541 • Contract Number: BG-415M • Work Order Id: 648407
Transaction Id
747541
Contract Number
BG-415M
Work Order Id
648407
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2016-01-08T00:00:00.000
747542
Transaction Id: 747542 • Contract Number: BG-415M • Work Order Id: 650766
Transaction Id
747542
Contract Number
BG-415M
Work Order Id
650766
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
24.8
Total Cost
347.2
Transaction Date
2015-11-11T00:00:00.000
747543
Transaction Id: 747543 • Contract Number: BG-415M • Work Order Id: 650766
Transaction Id
747543
Contract Number
BG-415M
Work Order Id
650766
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
305.0
Units Used
1.0
Total Cost
305.0
Transaction Date
2015-11-17T00:00:00.000
747544
Transaction Id: 747544 • Contract Number: BG-415M • Work Order Id: 649960
Transaction Id
747544
Contract Number
BG-415M
Work Order Id
649960
Line Item Id
308.0
Item Number
09
Line Item Description
PREPARING NEW TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
14.0
Units Used
45.4
Total Cost
635.6
Transaction Date
2015-11-16T00:00:00.000