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
747279
Transaction Id: 747279 • Contract Number: MG-115M • Work Order Id: 687320
Transaction Id
747279
Contract Number
MG-115M
Work Order Id
687320
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
15.0
Total Cost
330.0
Transaction Date
2015-09-09T00:00:00.000
747280
Transaction Id: 747280 • Contract Number: MG-115M • Work Order Id: 685347
Transaction Id
747280
Contract Number
MG-115M
Work Order Id
685347
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
32.0
Total Cost
576.0
Transaction Date
2015-09-09T00:00:00.000
747281
Transaction Id: 747281 • Contract Number: MG-115M • Work Order Id: 684528
Transaction Id
747281
Contract Number
MG-115M
Work Order Id
684528
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
28.0
Total Cost
504.0
Transaction Date
2015-09-09T00:00:00.000
747282
Transaction Id: 747282 • Contract Number: MG-115M • Work Order Id: 684528
Transaction Id
747282
Contract Number
MG-115M
Work Order Id
684528
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
10.0
Total Cost
220.0
Transaction Date
2015-09-09T00:00:00.000
747283
Transaction Id: 747283 • Contract Number: MG-115M • Work Order Id: 684128
Transaction Id
747283
Contract Number
MG-115M
Work Order Id
684128
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
32.3
Total Cost
581.4
Transaction Date
2015-09-09T00:00:00.000
747284
Transaction Id: 747284 • Contract Number: MG-115M • Work Order Id: 686928
Transaction Id
747284
Contract Number
MG-115M
Work Order Id
686928
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
32.0
Total Cost
576.0
Transaction Date
2015-09-09T00:00:00.000
747285
Transaction Id: 747285 • Contract Number: MG-115M • Work Order Id: 688532
Transaction Id
747285
Contract Number
MG-115M
Work Order Id
688532
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
34.0
Total Cost
612.0
Transaction Date
2015-09-09T00:00:00.000
747286
Transaction Id: 747286 • Contract Number: MG-115M • Work Order Id: 688532
Transaction Id
747286
Contract Number
MG-115M
Work Order Id
688532
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
18.5
Total Cost
407.0
Transaction Date
2015-09-09T00:00:00.000
747287
Transaction Id: 747287 • Contract Number: MG-115M • Work Order Id: 732136
Transaction Id
747287
Contract Number
MG-115M
Work Order Id
732136
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
48.3
Total Cost
869.4
Transaction Date
2015-09-09T00:00:00.000
747288
Transaction Id: 747288 • Contract Number: MG-115M • Work Order Id: 658899
Transaction Id
747288
Contract Number
MG-115M
Work Order Id
658899
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
37.5
Total Cost
825.0
Transaction Date
2015-09-11T00:00:00.000
747289
Transaction Id: 747289 • Contract Number: MG-115M • Work Order Id: 730939
Transaction Id
747289
Contract Number
MG-115M
Work Order Id
730939
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
20.8
Total Cost
374.40000000000003
Transaction Date
2015-09-11T00:00:00.000
747290
Transaction Id: 747290 • Contract Number: MG-115M • Work Order Id: 730939
Transaction Id
747290
Contract Number
MG-115M
Work Order Id
730939
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
7.1
Total Cost
156.2
Transaction Date
2015-09-11T00:00:00.000
747291
Transaction Id: 747291 • Contract Number: MG-115M • Work Order Id: 660087
Transaction Id
747291
Contract Number
MG-115M
Work Order Id
660087
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
38.3
Total Cost
689.4
Transaction Date
2015-09-11T00:00:00.000
747292
Transaction Id: 747292 • Contract Number: MG-115M • Work Order Id: 660084
Transaction Id
747292
Contract Number
MG-115M
Work Order Id
660084
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
36.4
Total Cost
655.1999999999999
Transaction Date
2015-09-11T00:00:00.000
747293
Transaction Id: 747293 • Contract Number: MG-115M • Work Order Id: 661266
Transaction Id
747293
Contract Number
MG-115M
Work Order Id
661266
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
30.9
Total Cost
556.1999999999999
Transaction Date
2015-09-11T00:00:00.000
747294
Transaction Id: 747294 • Contract Number: MG-115M • Work Order Id: 661266
Transaction Id
747294
Contract Number
MG-115M
Work Order Id
661266
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
12.5
Total Cost
275.0
Transaction Date
2015-09-11T00:00:00.000
747295
Transaction Id: 747295 • Contract Number: MG-115M • Work Order Id: 658896
Transaction Id
747295
Contract Number
MG-115M
Work Order Id
658896
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
37.5
Total Cost
825.0
Transaction Date
2015-09-11T00:00:00.000
747296
Transaction Id: 747296 • Contract Number: MG-115M • Work Order Id: 658859
Transaction Id
747296
Contract Number
MG-115M
Work Order Id
658859
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
48.3
Total Cost
1062.6
Transaction Date
2015-09-11T00:00:00.000
747297
Transaction Id: 747297 • Contract Number: MG-115M • Work Order Id: 658860
Transaction Id
747297
Contract Number
MG-115M
Work Order Id
658860
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
48.7
Total Cost
1071.4
Transaction Date
2015-09-11T00:00:00.000
747298
Transaction Id: 747298 • Contract Number: MG-115M • Work Order Id: 660449
Transaction Id
747298
Contract Number
MG-115M
Work Order Id
660449
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
40.0
Total Cost
880.0
Transaction Date
2015-09-11T00:00:00.000
747299
Transaction Id: 747299 • Contract Number: MG-115M • Work Order Id: 661235
Transaction Id
747299
Contract Number
MG-115M
Work Order Id
661235
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
41.3
Total Cost
908.5999999999999
Transaction Date
2015-09-11T00:00:00.000
747300
Transaction Id: 747300 • Contract Number: MG-115M • Work Order Id: 662435
Transaction Id
747300
Contract Number
MG-115M
Work Order Id
662435
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
50.4
Total Cost
1108.8
Transaction Date
2015-09-11T00:00:00.000
747301
Transaction Id: 747301 • Contract Number: MG-115M • Work Order Id: 660071
Transaction Id
747301
Contract Number
MG-115M
Work Order Id
660071
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
44.6
Total Cost
981.2
Transaction Date
2015-09-11T00:00:00.000
747302
Transaction Id: 747302 • Contract Number: MG-115M • Work Order Id: 732540
Transaction Id
747302
Contract Number
MG-115M
Work Order Id
732540
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
28.0
Total Cost
504.0
Transaction Date
2015-09-11T00:00:00.000
747303
Transaction Id: 747303 • Contract Number: MG-115M • Work Order Id: 732540
Transaction Id
747303
Contract Number
MG-115M
Work Order Id
732540
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
4.7
Total Cost
103.4
Transaction Date
2015-09-11T00:00:00.000
747304
Transaction Id: 747304 • Contract Number: MG-115M • Work Order Id: 662050
Transaction Id
747304
Contract Number
MG-115M
Work Order Id
662050
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
32.7
Total Cost
588.6
Transaction Date
2015-09-11T00:00:00.000
747305
Transaction Id: 747305 • Contract Number: MG-115M • Work Order Id: 734127
Transaction Id
747305
Contract Number
MG-115M
Work Order Id
734127
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
16.2
Units Used
31.5
Total Cost
510.29999999999995
Transaction Date
2015-09-11T00:00:00.000
747306
Transaction Id: 747306 • Contract Number: MG-115M • Work Order Id: 728133
Transaction Id
747306
Contract Number
MG-115M
Work Order Id
728133
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
36.0
Total Cost
648.0
Transaction Date
2015-09-11T00:00:00.000
747307
Transaction Id: 747307 • Contract Number: MG-115M • Work Order Id: 728936
Transaction Id
747307
Contract Number
MG-115M
Work Order Id
728936
Line Item Id
309.0
Item Number
10
Line Item Description
PREPARING EXISTING SIDEWALK TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
18.0
Units Used
32.0
Total Cost
576.0
Transaction Date
2015-09-11T00:00:00.000
747308
Transaction Id: 747308 • Contract Number: MG-115M • Work Order Id: 728936
Transaction Id
747308
Contract Number
MG-115M
Work Order Id
728936
Line Item Id
329.0
Item Number
09
Line Item Description
Preparing New Sidewalk Tree Pits
Unit Of Measure
SF
Unit Price
22.0
Units Used
8.0
Total Cost
176.0
Transaction Date
2015-09-11T00:00:00.000
747309
Transaction Id: 747309 • Contract Number: QG-215M • Work Order Id: 655601
Transaction Id
747309
Contract Number
QG-215M
Work Order Id
655601
Line Item Id
293.0
Item Number
26
Line Item Description
SAW CUT PAVEMENT
Unit Of Measure
LF
Unit Price
5.0
Units Used
19.0
Total Cost
95.0
Transaction Date
2015-09-09T00:00:00.000
747310
Transaction Id: 747310 • Contract Number: QG-215M • Work Order Id: 698953
Transaction Id
747310
Contract Number
QG-215M
Work Order Id
698953
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
747311
Transaction Id: 747311 • Contract Number: BG-1215M • Work Order Id: 816650
Transaction Id
747311
Contract Number
BG-1215M
Work Order Id
816650
Line Item Id
627.0
Item Number
34
Line Item Description
STEEL TREE BED GUARD - A
Unit Of Measure
LF
Unit Price
70.0
Units Used
18.1
Total Cost
1267.0
Transaction Date
2016-08-08T00:00:00.000
747312
Transaction Id: 747312 • Contract Number: BG-315M • Work Order Id: 817841
Transaction Id
747312
Contract Number
BG-315M
Work Order Id
817841
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.1
Total Cost
1127.0
Transaction Date
2015-09-09T00:00:00.000
747313
Transaction Id: 747313 • Contract Number: BG-315M • Work Order Id: 819835
Transaction Id
747313
Contract Number
BG-315M
Work Order Id
819835
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.3
Total Cost
1001.0
Transaction Date
2015-09-09T00:00:00.000
747314
Transaction Id: 747314 • Contract Number: BG-315M • Work Order Id: 820239
Transaction Id
747314
Contract Number
BG-315M
Work Order Id
820239
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.8
Total Cost
1176.0
Transaction Date
2015-09-09T00:00:00.000
747315
Transaction Id: 747315 • Contract Number: BG-315M • Work Order Id: 818637
Transaction Id
747315
Contract Number
BG-315M
Work Order Id
818637
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.3
Total Cost
1071.0
Transaction Date
2015-09-09T00:00:00.000
747316
Transaction Id: 747316 • Contract Number: BG-315M • Work Order Id: 819435
Transaction Id
747316
Contract Number
BG-315M
Work Order Id
819435
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.3
Total Cost
1141.0
Transaction Date
2015-09-09T00:00:00.000
747317
Transaction Id: 747317 • Contract Number: BG-315M • Work Order Id: 817838
Transaction Id
747317
Contract Number
BG-315M
Work Order Id
817838
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.8
Total Cost
1036.0
Transaction Date
2015-09-09T00:00:00.000
747318
Transaction Id: 747318 • Contract Number: BG-315M • Work Order Id: 817436
Transaction Id
747318
Contract Number
BG-315M
Work Order Id
817436
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.7
Total Cost
1029.0
Transaction Date
2015-09-09T00:00:00.000
747319
Transaction Id: 747319 • Contract Number: BG-315M • Work Order Id: 808652
Transaction Id
747319
Contract Number
BG-315M
Work Order Id
808652
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.0
Total Cost
1120.0
Transaction Date
2015-09-09T00:00:00.000
747320
Transaction Id: 747320 • Contract Number: BG-315M • Work Order Id: 805852
Transaction Id
747320
Contract Number
BG-315M
Work Order Id
805852
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
16.8
Total Cost
1176.0
Transaction Date
2015-09-09T00:00:00.000
747321
Transaction Id: 747321 • Contract Number: BG-315M • Work Order Id: 809049
Transaction Id
747321
Contract Number
BG-315M
Work Order Id
809049
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.2
Total Cost
994.0
Transaction Date
2015-09-09T00:00:00.000
747322
Transaction Id: 747322 • Contract Number: BG-315M • Work Order Id: 809851
Transaction Id
747322
Contract Number
BG-315M
Work Order Id
809851
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.8
Total Cost
1036.0
Transaction Date
2015-09-09T00:00:00.000
747323
Transaction Id: 747323 • Contract Number: BG-315M • Work Order Id: 812647
Transaction Id
747323
Contract Number
BG-315M
Work Order Id
812647
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
13.3
Total Cost
931.0
Transaction Date
2015-09-09T00:00:00.000
747324
Transaction Id: 747324 • Contract Number: BG-315M • Work Order Id: 794662
Transaction Id
747324
Contract Number
BG-315M
Work Order Id
794662
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.8
Total Cost
1106.0
Transaction Date
2015-09-09T00:00:00.000
747325
Transaction Id: 747325 • Contract Number: BG-315M • Work Order Id: 813843
Transaction Id
747325
Contract Number
BG-315M
Work Order Id
813843
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
13.7
Total Cost
959.0
Transaction Date
2015-09-09T00:00:00.000
747326
Transaction Id: 747326 • Contract Number: BG-315M • Work Order Id: 808651
Transaction Id
747326
Contract Number
BG-315M
Work Order Id
808651
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.5
Total Cost
1015.0
Transaction Date
2015-09-09T00:00:00.000
747327
Transaction Id: 747327 • Contract Number: BG-315M • Work Order Id: 815041
Transaction Id
747327
Contract Number
BG-315M
Work Order Id
815041
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
15.7
Total Cost
1099.0
Transaction Date
2015-09-09T00:00:00.000
747328
Transaction Id: 747328 • Contract Number: BG-315M • Work Order Id: 804649
Transaction Id
747328
Contract Number
BG-315M
Work Order Id
804649
Line Item Id
352.0
Item Number
36
Line Item Description
STEEL TREE PIT GUARD - B
Unit Of Measure
LF
Unit Price
70.0
Units Used
14.5
Total Cost
1015.0
Transaction Date
2015-09-09T00:00:00.000