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
745975
Transaction Id: 745975 • Contract Number: QG-215M • Work Order Id: 647587
Transaction Id
745975
Contract Number
QG-215M
Work Order Id
647587
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
25.0
Total Cost
425.0
Transaction Date
2015-09-09T00:00:00.000
745976
Transaction Id: 745976 • Contract Number: QG-215M • Work Order Id: 650723
Transaction Id
745976
Contract Number
QG-215M
Work Order Id
650723
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-17T00:00:00.000
745977
Transaction Id: 745977 • Contract Number: QG-215M • Work Order Id: 650723
Transaction Id
745977
Contract Number
QG-215M
Work Order Id
650723
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
25.0
Total Cost
300.0
Transaction Date
2015-09-09T00:00:00.000
745978
Transaction Id: 745978 • Contract Number: QG-215M • Work Order Id: 650723
Transaction Id
745978
Contract Number
QG-215M
Work Order Id
650723
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
25.0
Total Cost
425.0
Transaction Date
2015-09-09T00:00:00.000
745979
Transaction Id: 745979 • Contract Number: QG-215M • Work Order Id: 649924
Transaction Id
745979
Contract Number
QG-215M
Work Order Id
649924
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-17T00:00:00.000
745980
Transaction Id: 745980 • Contract Number: QG-215M • Work Order Id: 649924
Transaction Id
745980
Contract Number
QG-215M
Work Order Id
649924
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
25.0
Total Cost
300.0
Transaction Date
2015-09-09T00:00:00.000
745981
Transaction Id: 745981 • Contract Number: QG-215M • Work Order Id: 649924
Transaction Id
745981
Contract Number
QG-215M
Work Order Id
649924
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
26.3
Total Cost
447.1
Transaction Date
2015-09-09T00:00:00.000
745982
Transaction Id: 745982 • Contract Number: QG-215M • Work Order Id: 649527
Transaction Id
745982
Contract Number
QG-215M
Work Order Id
649527
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-17T00:00:00.000
745983
Transaction Id: 745983 • Contract Number: QG-215M • Work Order Id: 649527
Transaction Id
745983
Contract Number
QG-215M
Work Order Id
649527
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
25.0
Total Cost
300.0
Transaction Date
2015-09-09T00:00:00.000
745984
Transaction Id: 745984 • Contract Number: QG-215M • Work Order Id: 649527
Transaction Id
745984
Contract Number
QG-215M
Work Order Id
649527
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
25.0
Total Cost
425.0
Transaction Date
2015-09-09T00:00:00.000
745985
Transaction Id: 745985 • Contract Number: QG-215M • Work Order Id: 649526
Transaction Id
745985
Contract Number
QG-215M
Work Order Id
649526
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-17T00:00:00.000
745986
Transaction Id: 745986 • Contract Number: QG-215M • Work Order Id: 649526
Transaction Id
745986
Contract Number
QG-215M
Work Order Id
649526
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
25.0
Total Cost
300.0
Transaction Date
2015-09-09T00:00:00.000
745987
Transaction Id: 745987 • Contract Number: QG-215M • Work Order Id: 649526
Transaction Id
745987
Contract Number
QG-215M
Work Order Id
649526
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
25.0
Total Cost
425.0
Transaction Date
2015-09-09T00:00:00.000
745988
Transaction Id: 745988 • Contract Number: QG-215M • Work Order Id: 655622
Transaction Id
745988
Contract Number
QG-215M
Work Order Id
655622
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
745989
Transaction Id: 745989 • Contract Number: QG-215M • Work Order Id: 655622
Transaction Id
745989
Contract Number
QG-215M
Work Order Id
655622
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
19.8
Total Cost
237.60000000000002
Transaction Date
2015-09-25T00:00:00.000
745990
Transaction Id: 745990 • Contract Number: QG-215M • Work Order Id: 655622
Transaction Id
745990
Contract Number
QG-215M
Work Order Id
655622
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
10.0
Total Cost
170.0
Transaction Date
2015-09-25T00:00:00.000
745991
Transaction Id: 745991 • Contract Number: QG-215M • Work Order Id: 698913
Transaction Id
745991
Contract Number
QG-215M
Work Order Id
698913
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
745992
Transaction Id: 745992 • Contract Number: QG-215M • Work Order Id: 698913
Transaction Id
745992
Contract Number
QG-215M
Work Order Id
698913
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
14.2
Total Cost
153.36
Transaction Date
2015-09-08T00:00:00.000
745993
Transaction Id: 745993 • Contract Number: QG-215M • Work Order Id: 698913
Transaction Id
745993
Contract Number
QG-215M
Work Order Id
698913
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
5.6
Total Cost
85.67999999999999
Transaction Date
2015-09-08T00:00:00.000
745994
Transaction Id: 745994 • Contract Number: QG-215M • Work Order Id: 649636
Transaction Id
745994
Contract Number
QG-215M
Work Order Id
649636
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
745995
Transaction Id: 745995 • Contract Number: QG-215M • Work Order Id: 649636
Transaction Id
745995
Contract Number
QG-215M
Work Order Id
649636
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
25.0
Total Cost
300.0
Transaction Date
2015-12-31T00:00:00.000
745996
Transaction Id: 745996 • Contract Number: QG-215M • Work Order Id: 649636
Transaction Id
745996
Contract Number
QG-215M
Work Order Id
649636
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
25.0
Total Cost
425.0
Transaction Date
2015-12-31T00:00:00.000
745997
Transaction Id: 745997 • Contract Number: QG-215M • Work Order Id: 649636
Transaction Id
745997
Contract Number
QG-215M
Work Order Id
649636
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.0
Total Cost
1054.0
Transaction Date
2016-03-21T00:00:00.000
745998
Transaction Id: 745998 • Contract Number: QG-215M • Work Order Id: 650033
Transaction Id
745998
Contract Number
QG-215M
Work Order Id
650033
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
745999
Transaction Id: 745999 • Contract Number: QG-215M • Work Order Id: 650033
Transaction Id
745999
Contract Number
QG-215M
Work Order Id
650033
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
25.0
Total Cost
300.0
Transaction Date
2015-12-31T00:00:00.000
746000
Transaction Id: 746000 • Contract Number: QG-215M • Work Order Id: 650033
Transaction Id
746000
Contract Number
QG-215M
Work Order Id
650033
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
25.0
Total Cost
425.0
Transaction Date
2015-12-31T00:00:00.000
746001
Transaction Id: 746001 • Contract Number: QG-215M • Work Order Id: 650033
Transaction Id
746001
Contract Number
QG-215M
Work Order Id
650033
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.0
Total Cost
1054.0
Transaction Date
2016-03-21T00:00:00.000
746002
Transaction Id: 746002 • Contract Number: QG-215M • Work Order Id: 660412
Transaction Id
746002
Contract Number
QG-215M
Work Order Id
660412
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
746003
Transaction Id: 746003 • Contract Number: QG-215M • Work Order Id: 660412
Transaction Id
746003
Contract Number
QG-215M
Work Order Id
660412
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
25.0
Total Cost
300.0
Transaction Date
2015-12-31T00:00:00.000
746004
Transaction Id: 746004 • Contract Number: QG-215M • Work Order Id: 660412
Transaction Id
746004
Contract Number
QG-215M
Work Order Id
660412
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
20.0
Total Cost
340.0
Transaction Date
2015-12-31T00:00:00.000
746005
Transaction Id: 746005 • Contract Number: QG-215M • Work Order Id: 660412
Transaction Id
746005
Contract Number
QG-215M
Work Order Id
660412
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
16.8
Total Cost
1041.6000000000001
Transaction Date
2016-03-21T00:00:00.000
746006
Transaction Id: 746006 • Contract Number: QG-215M • Work Order Id: 665399
Transaction Id
746006
Contract Number
QG-215M
Work Order Id
665399
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
746007
Transaction Id: 746007 • Contract Number: QG-215M • Work Order Id: 665399
Transaction Id
746007
Contract Number
QG-215M
Work Order Id
665399
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
41.3
Total Cost
495.59999999999997
Transaction Date
2015-09-17T00:00:00.000
746008
Transaction Id: 746008 • Contract Number: QG-215M • Work Order Id: 665399
Transaction Id
746008
Contract Number
QG-215M
Work Order Id
665399
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
10.4
Total Cost
176.8
Transaction Date
2015-09-17T00:00:00.000
746009
Transaction Id: 746009 • Contract Number: QG-215M • Work Order Id: 669319
Transaction Id
746009
Contract Number
QG-215M
Work Order Id
669319
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
2016-01-14T00:00:00.000
746010
Transaction Id: 746010 • Contract Number: QG-215M • Work Order Id: 669319
Transaction Id
746010
Contract Number
QG-215M
Work Order Id
669319
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
41.3
Total Cost
495.59999999999997
Transaction Date
2016-01-14T00:00:00.000
746011
Transaction Id: 746011 • Contract Number: QG-215M • Work Order Id: 669319
Transaction Id
746011
Contract Number
QG-215M
Work Order Id
669319
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
10.4
Total Cost
176.8
Transaction Date
2016-01-14T00:00:00.000
746012
Transaction Id: 746012 • Contract Number: QG-215M • Work Order Id: 669319
Transaction Id
746012
Contract Number
QG-215M
Work Order Id
669319
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
18.0
Total Cost
1296.0
Transaction Date
2016-03-21T00:00:00.000
746017
Transaction Id: 746017 • Contract Number: QG-215M • Work Order Id: 668518
Transaction Id
746017
Contract Number
QG-215M
Work Order Id
668518
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
2016-01-14T00:00:00.000
746018
Transaction Id: 746018 • Contract Number: QG-215M • Work Order Id: 668518
Transaction Id
746018
Contract Number
QG-215M
Work Order Id
668518
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
52.1
Total Cost
885.7
Transaction Date
2016-01-14T00:00:00.000
746019
Transaction Id: 746019 • Contract Number: QG-215M • Work Order Id: 668518
Transaction Id
746019
Contract Number
QG-215M
Work Order Id
668518
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
18.0
Total Cost
1296.0
Transaction Date
2016-03-21T00:00:00.000
746020
Transaction Id: 746020 • Contract Number: QG-215M • Work Order Id: 666522
Transaction Id
746020
Contract Number
QG-215M
Work Order Id
666522
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
2016-01-14T00:00:00.000
746021
Transaction Id: 746021 • Contract Number: QG-215M • Work Order Id: 666522
Transaction Id
746021
Contract Number
QG-215M
Work Order Id
666522
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
15.4
Total Cost
184.8
Transaction Date
2016-01-14T00:00:00.000
746022
Transaction Id: 746022 • Contract Number: QG-215M • Work Order Id: 666522
Transaction Id
746022
Contract Number
QG-215M
Work Order Id
666522
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
35.4
Total Cost
601.8
Transaction Date
2016-01-14T00:00:00.000
746023
Transaction Id: 746023 • Contract Number: QG-215M • Work Order Id: 666522
Transaction Id
746023
Contract Number
QG-215M
Work Order Id
666522
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
18.0
Total Cost
1296.0
Transaction Date
2016-03-21T00:00:00.000
746025
Transaction Id: 746025 • Contract Number: QG-215M • Work Order Id: 668115
Transaction Id
746025
Contract Number
QG-215M
Work Order Id
668115
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
2016-01-14T00:00:00.000
746026
Transaction Id: 746026 • Contract Number: QG-215M • Work Order Id: 668115
Transaction Id
746026
Contract Number
QG-215M
Work Order Id
668115
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
21.9
Total Cost
262.79999999999995
Transaction Date
2016-01-14T00:00:00.000
746027
Transaction Id: 746027 • Contract Number: QG-215M • Work Order Id: 668115
Transaction Id
746027
Contract Number
QG-215M
Work Order Id
668115
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
28.0
Total Cost
476.0
Transaction Date
2016-01-14T00:00:00.000
746028
Transaction Id: 746028 • Contract Number: QG-215M • Work Order Id: 668115
Transaction Id
746028
Contract Number
QG-215M
Work Order Id
668115
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
18.0
Total Cost
1296.0
Transaction Date
2016-03-21T00:00:00.000
746029
Transaction Id: 746029 • Contract Number: QG-215M • Work Order Id: 649689
Transaction Id
746029
Contract Number
QG-215M
Work Order Id
649689
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
NYC Data AI • Public-data exploration interface