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
747867
Transaction Id: 747867 • Contract Number: BG-415M • Work Order Id: 648338
Transaction Id
747867
Contract Number
BG-415M
Work Order Id
648338
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-07T00:00:00.000
747868
Transaction Id: 747868 • Contract Number: BG-415M • Work Order Id: 648339
Transaction Id
747868
Contract Number
BG-415M
Work Order Id
648339
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
12.0
Total Cost
168.0
Transaction Date
2015-10-30T00:00:00.000
747869
Transaction Id: 747869 • Contract Number: BG-415M • Work Order Id: 648339
Transaction Id
747869
Contract Number
BG-415M
Work Order Id
648339
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
18.0
Total Cost
180.0
Transaction Date
2015-10-30T00:00:00.000
747870
Transaction Id: 747870 • Contract Number: BG-415M • Work Order Id: 648339
Transaction Id
747870
Contract Number
BG-415M
Work Order Id
648339
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-07T00:00:00.000
747871
Transaction Id: 747871 • Contract Number: BG-415M • Work Order Id: 648754
Transaction Id
747871
Contract Number
BG-415M
Work Order Id
648754
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
12.6
Units Used
10.0
Total Cost
126.0
Transaction Date
2015-10-21T00:00:00.000
747872
Transaction Id: 747872 • Contract Number: BG-415M • Work Order Id: 648754
Transaction Id
747872
Contract Number
BG-415M
Work Order Id
648754
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.0
Units Used
23.3
Total Cost
209.70000000000002
Transaction Date
2015-10-21T00:00:00.000
747873
Transaction Id: 747873 • Contract Number: BG-415M • Work Order Id: 648754
Transaction Id
747873
Contract Number
BG-415M
Work Order Id
648754
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-09T00:00:00.000
747874
Transaction Id: 747874 • Contract Number: BG-415M • Work Order Id: 665728
Transaction Id
747874
Contract Number
BG-415M
Work Order Id
665728
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
16.5
Total Cost
231.0
Transaction Date
2015-11-02T00:00:00.000
747875
Transaction Id: 747875 • Contract Number: BG-415M • Work Order Id: 665728
Transaction Id
747875
Contract Number
BG-415M
Work Order Id
665728
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
24.2
Total Cost
242.0
Transaction Date
2015-11-02T00:00:00.000
747876
Transaction Id: 747876 • Contract Number: BG-415M • Work Order Id: 665728
Transaction Id
747876
Contract Number
BG-415M
Work Order Id
665728
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-02T00:00:00.000
747880
Transaction Id: 747880 • Contract Number: BG-415M • Work Order Id: 648369
Transaction Id
747880
Contract Number
BG-415M
Work Order Id
648369
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
12.6
Units Used
11.7
Total Cost
147.42
Transaction Date
2015-11-03T00:00:00.000
747881
Transaction Id: 747881 • Contract Number: BG-415M • Work Order Id: 648369
Transaction Id
747881
Contract Number
BG-415M
Work Order Id
648369
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.0
Units Used
25.8
Total Cost
232.20000000000002
Transaction Date
2015-11-03T00:00:00.000
747882
Transaction Id: 747882 • Contract Number: BG-415M • Work Order Id: 648369
Transaction Id
747882
Contract Number
BG-415M
Work Order Id
648369
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-04T00:00:00.000
747883
Transaction Id: 747883 • Contract Number: BG-415M • Work Order Id: 647555
Transaction Id
747883
Contract Number
BG-415M
Work Order Id
647555
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
12.6
Units Used
7.7
Total Cost
97.02
Transaction Date
2015-10-21T00:00:00.000
747884
Transaction Id: 747884 • Contract Number: BG-415M • Work Order Id: 647555
Transaction Id
747884
Contract Number
BG-415M
Work Order Id
647555
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
9.0
Units Used
31.3
Total Cost
281.7
Transaction Date
2015-10-21T00:00:00.000
747885
Transaction Id: 747885 • Contract Number: BG-415M • Work Order Id: 647555
Transaction Id
747885
Contract Number
BG-415M
Work Order Id
647555
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-09T00:00:00.000
747886
Transaction Id: 747886 • Contract Number: BG-415M • Work Order Id: 648361
Transaction Id
747886
Contract Number
BG-415M
Work Order Id
648361
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
12.6
Units Used
15.4
Total Cost
194.04
Transaction Date
2015-11-03T00:00:00.000
747887
Transaction Id: 747887 • Contract Number: BG-415M • Work Order Id: 648361
Transaction Id
747887
Contract Number
BG-415M
Work Order Id
648361
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.0
Units Used
23.7
Total Cost
213.29999999999998
Transaction Date
2015-11-03T00:00:00.000
747888
Transaction Id: 747888 • Contract Number: BG-415M • Work Order Id: 648361
Transaction Id
747888
Contract Number
BG-415M
Work Order Id
648361
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-03T00:00:00.000
747889
Transaction Id: 747889 • Contract Number: BG-415M • Work Order Id: 677720
Transaction Id
747889
Contract Number
BG-415M
Work Order Id
677720
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
25.0
Total Cost
250.0
Transaction Date
2015-11-02T00:00:00.000
747890
Transaction Id: 747890 • Contract Number: BG-415M • Work Order Id: 677720
Transaction Id
747890
Contract Number
BG-415M
Work Order Id
677720
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-02-09T00:00:00.000
747891
Transaction Id: 747891 • Contract Number: BG-415M • Work Order Id: 677721
Transaction Id
747891
Contract Number
BG-415M
Work Order Id
677721
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
25.0
Total Cost
250.0
Transaction Date
2015-11-02T00:00:00.000
747892
Transaction Id: 747892 • Contract Number: BG-415M • Work Order Id: 677721
Transaction Id
747892
Contract Number
BG-415M
Work Order Id
677721
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-02-09T00:00:00.000
747893
Transaction Id: 747893 • Contract Number: BG-415M • Work Order Id: 661013
Transaction Id
747893
Contract Number
BG-415M
Work Order Id
661013
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
31.9
Total Cost
319.0
Transaction Date
2015-11-03T00:00:00.000
747894
Transaction Id: 747894 • Contract Number: BG-415M • Work Order Id: 661013
Transaction Id
747894
Contract Number
BG-415M
Work Order Id
661013
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-04T00:00:00.000
747895
Transaction Id: 747895 • Contract Number: BG-415M • Work Order Id: 648539
Transaction Id
747895
Contract Number
BG-415M
Work Order Id
648539
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
49.0
Total Cost
490.0
Transaction Date
2015-11-04T00:00:00.000
747896
Transaction Id: 747896 • Contract Number: BG-415M • Work Order Id: 648539
Transaction Id
747896
Contract Number
BG-415M
Work Order Id
648539
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-04T00:00:00.000
747897
Transaction Id: 747897 • Contract Number: BG-415M • Work Order Id: 651542
Transaction Id
747897
Contract Number
BG-415M
Work Order Id
651542
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
49.0
Total Cost
490.0
Transaction Date
2015-11-04T00:00:00.000
747898
Transaction Id: 747898 • Contract Number: BG-415M • Work Order Id: 651542
Transaction Id
747898
Contract Number
BG-415M
Work Order Id
651542
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-04T00:00:00.000
747899
Transaction Id: 747899 • Contract Number: BG-415M • Work Order Id: 679305
Transaction Id
747899
Contract Number
BG-415M
Work Order Id
679305
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
26.6
Total Cost
266.0
Transaction Date
2015-10-22T00:00:00.000
747900
Transaction Id: 747900 • Contract Number: BG-415M • Work Order Id: 679305
Transaction Id
747900
Contract Number
BG-415M
Work Order Id
679305
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-12-19T00:00:00.000
747901
Transaction Id: 747901 • Contract Number: BG-415M • Work Order Id: 674501
Transaction Id
747901
Contract Number
BG-415M
Work Order Id
674501
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
33.3
Total Cost
333.0
Transaction Date
2015-10-23T00:00:00.000
747902
Transaction Id: 747902 • Contract Number: BG-415M • Work Order Id: 674501
Transaction Id
747902
Contract Number
BG-415M
Work Order Id
674501
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-12T00:00:00.000
747903
Transaction Id: 747903 • Contract Number: BG-415M • Work Order Id: 686137
Transaction Id
747903
Contract Number
BG-415M
Work Order Id
686137
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
40.0
Total Cost
400.0
Transaction Date
2015-10-20T00:00:00.000
747904
Transaction Id: 747904 • Contract Number: BG-415M • Work Order Id: 686137
Transaction Id
747904
Contract Number
BG-415M
Work Order Id
686137
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-09T00:00:00.000
747905
Transaction Id: 747905 • Contract Number: BG-415M • Work Order Id: 672095
Transaction Id
747905
Contract Number
BG-415M
Work Order Id
672095
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
34.0
Total Cost
340.0
Transaction Date
2015-10-30T00:00:00.000
747906
Transaction Id: 747906 • Contract Number: BG-415M • Work Order Id: 672095
Transaction Id
747906
Contract Number
BG-415M
Work Order Id
672095
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-06T00:00:00.000
747907
Transaction Id: 747907 • Contract Number: BG-415M • Work Order Id: 647560
Transaction Id
747907
Contract Number
BG-415M
Work Order Id
647560
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
28.5
Total Cost
285.0
Transaction Date
2015-10-30T00:00:00.000
747908
Transaction Id: 747908 • Contract Number: BG-415M • Work Order Id: 647560
Transaction Id
747908
Contract Number
BG-415M
Work Order Id
647560
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-21T00:00:00.000
747909
Transaction Id: 747909 • Contract Number: BG-415M • Work Order Id: 647958
Transaction Id
747909
Contract Number
BG-415M
Work Order Id
647958
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
29.3
Total Cost
293.0
Transaction Date
2015-10-30T00:00:00.000
747910
Transaction Id: 747910 • Contract Number: BG-415M • Work Order Id: 647958
Transaction Id
747910
Contract Number
BG-415M
Work Order Id
647958
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-21T00:00:00.000
747911
Transaction Id: 747911 • Contract Number: BG-415M • Work Order Id: 647579
Transaction Id
747911
Contract Number
BG-415M
Work Order Id
647579
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
47.5
Total Cost
475.0
Transaction Date
2015-11-03T00:00:00.000
747912
Transaction Id: 747912 • Contract Number: BG-415M • Work Order Id: 647579
Transaction Id
747912
Contract Number
BG-415M
Work Order Id
647579
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-04T00:00:00.000
747913
Transaction Id: 747913 • Contract Number: BG-415M • Work Order Id: 681360
Transaction Id
747913
Contract Number
BG-415M
Work Order Id
681360
Line Item Id
276.0
Item Number
11
Line Item Description
PREPARING LAWN TREE PITS FOR PLANTING
Unit Of Measure
SF
Unit Price
10.0
Units Used
36.0
Total Cost
360.0
Transaction Date
2015-10-29T00:00:00.000
747914
Transaction Id: 747914 • Contract Number: BG-415M • Work Order Id: 681360
Transaction Id
747914
Contract Number
BG-415M
Work Order Id
681360
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-05T00:00:00.000
747916
Transaction Id: 747916 • Contract Number: BG-415M • Work Order Id: 648361
Transaction Id
747916
Contract Number
BG-415M
Work Order Id
648361
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
150.0
Units Used
1.0
Total Cost
150.0
Transaction Date
2015-11-03T00:00:00.000
747917
Transaction Id: 747917 • Contract Number: BG-415M • Work Order Id: 647555
Transaction Id
747917
Contract Number
BG-415M
Work Order Id
647555
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
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2015-10-21T00:00:00.000
747918
Transaction Id: 747918 • Contract Number: BG-415M • Work Order Id: 648369
Transaction Id
747918
Contract Number
BG-415M
Work Order Id
648369
Line Item Id
304.0
Item Number
04
Line Item Description
STUMP REMOVALS OF OVER 24 TO 30 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
400.0
Units Used
1.0
Total Cost
400.0
Transaction Date
2015-11-03T00:00:00.000
747919
Transaction Id: 747919 • Contract Number: BG-415M • Work Order Id: 648754
Transaction Id
747919
Contract Number
BG-415M
Work Order Id
648754
Line Item Id
286.0
Item Number
02
Line Item Description
STUMP REMOVALS OF OVER 12 TO 18 INCHES IN DIAMETER
Unit Of Measure
EA
Unit Price
200.0
Units Used
1.0
Total Cost
200.0
Transaction Date
2015-10-21T00:00:00.000
747920
Transaction Id: 747920 • Contract Number: BG-415M • Work Order Id: 674090
Transaction Id
747920
Contract Number
BG-415M
Work Order Id
674090
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
300.0
Units Used
1.0
Total Cost
300.0
Transaction Date
2015-10-30T00:00:00.000
NYC Data AI • Public-data exploration interface