Name: Tree & Planting Sites
Display Field: commonname
Type:  Feature Layer
Geometry Type: esriGeometryPoint
Description:  
Service Item Id:  c4b99b2acf144a80b40fbf1bf6ccddc9
Copyright Text:  
Default Visibility: true 
MaxRecordCount:  2000
Supported Query Formats:  JSON, geoJSON, PBF
Min Scale:  10000.0
Max Scale:  0.0
Supports Advanced Queries:  true
Supports Statistics:  true
Has Labels:  false
Can Modify Layer:  true
Can Scale Symbols:  false
Use Standardized Queries:  true
Supports Datum Transformation:  true
Extent:
XMin: 1975240.2343187183
YMin: 776638.8317566514
XMax: 2061264.2007218897
YMax: 848629.0660567284
Spatial Reference: 102719
 (2264)
 LatestVCSWkid(0)
Drawing Info: 
Renderer: 
Simple Renderer:
Symbol:  Style:  esriSMSCircle
Color:  [38, 115, 0, 255] 
Size:  6.0
Angle:  0.0
XOffset:  0
YOffset:  0
Outline: 
Label:  N/A
Description:  N/A
Transparency:  0
Labeling Info: 
Advanced Query Capabilities: 
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
HasZ: true
HasM: false 
Has Attachments:  false
HTML Popup Type:  esriServerHTMLPopupTypeAsHTMLText
Type ID Field:  null
Fields: 
- 
contractplantingyr
(
type: esriFieldTypeSmallInteger, alias: Contract Planting Year
)
 
- 
pitcondition
(
type: esriFieldTypeString, alias: Tree: Pit Condition, length: 100
, Coded Values: 
[Damaged Hardscape: Damaged Hardscape]
, [Damaged Grate: Damaged Grate]
, [Girdling Grate: Girdling Grate]
, ...2 more...
)
 
- 
pittreatment
(
type: esriFieldTypeString, alias: Tree: Pit Treatment, length: 100
, Coded Values: 
[Tree pit (functional): Tree pit (functional)]
, [Tree pit (non-functional): Tree pit (non-functional)]
, [Tree pit (improved – flexi pave): Tree pit (improved – flexi pave)]
, ...3 more...
)
 
- 
pitinstalldate
(
type: esriFieldTypeDate, alias: Tree: Pit Treatment Installation Date, length: 8
)
 
- 
assetid
(
type: esriFieldTypeString, alias: Asset ID, length: 50
)
 
- 
OBJECTID
(
type: esriFieldTypeOID, alias: OBJECTID
)
 
- 
streetaddress
(
type: esriFieldTypeString, alias: Street Address, length: 100
)
 
- 
city
(
type: esriFieldTypeString, alias: City, length: 50
)
 
- 
zipcode
(
type: esriFieldTypeSmallInteger, alias: Zip Code
)
 
- 
facilityid
(
type: esriFieldTypeInteger, alias: Tree: Id
)
 
- 
present
(
type: esriFieldTypeString, alias: Tree: Present?, length: 20
, Coded Values: 
[Tree: Tree]
, [Planting Site: Planting Site]
, [Do Not Plant: Do Not Plant]
)
 
- 
genus
(
type: esriFieldTypeString, alias: Tree: Genus, length: 50
, Coded Values: 
[Abies: Abies]
, [Acacia: Acacia]
, [Acer: Acer]
, ...110 more...
)
 
- 
species
(
type: esriFieldTypeString, alias: Tree: Species, length: 50
, Coded Values: 
[abies: abies]
, [acerifolia: acerifolia]
, [acuminata: acuminata]
, ...199 more...
)
 
- 
commonname
(
type: esriFieldTypeString, alias: Tree: Common Name, length: 50
, Coded Values: 
[Acuba: Acuba]
, [Alternateleaf Dogwood: Alternateleaf Dogwood]
, [American Arborvitae: American Arborvitae]
, ...275 more...
)
 
- 
plantingdate
(
type: esriFieldTypeString, alias: Tree: Planting Date, length: 20
, Coded Values: 
[2016-2017: 2016-2017]
, [2017-2018: 2017-2018]
, [2018-2019: 2018-2019]
, ...11 more...
)
 
- 
diameterin
(
type: esriFieldTypeDouble, alias: Tree: Diameter
)
 
- 
heightft
(
type: esriFieldTypeString, alias: Tree: Height (feet), length: 20
, Coded Values: 
[0-20: 0-20]
, [20-40: 20-40]
, [40-60: 40-60]
, ...2 more...
)
 
- 
condition
(
type: esriFieldTypeString, alias: Tree: Condition, length: 50
, Coded Values: 
[Fair: Fair]
, [Good: Good]
, [Poor: Poor]
)
 
- 
contractwork
(
type: esriFieldTypeString, alias: Tree: Contract Work, length: 100
, Coded Values: 
[tree removal: tree removal]
, [tree pruning: tree pruning]
, [stump grinding: stump grinding]
)
 
- 
neighborhood
(
type: esriFieldTypeString, alias: Tree: Neighborhood, length: 50
, Coded Values: 
[Downtown: Downtown]
, [Lyon Park: Lyon Park]
, [Old East Durham: Old East Durham]
, ...6 more...
)
 
- 
program
(
type: esriFieldTypeString, alias: Tree: Program, length: 50
, Coded Values: 
[DCOI: DCOI]
, [PB: PB]
, [PWSW: PWSW]
, ...4 more...
)
 
- 
plantingw
(
type: esriFieldTypeString, alias: Planting Site: Width, length: 50
, Coded Values: 
[Less than 3 ft: Less than 3 ft]
, [3-5 ft: 3-5 ft]
, [Greater than 5 ft: Greater than 5 ft]
, ...2 more...
)
 
- 
plantingcond
(
type: esriFieldTypeString, alias: Planting Site: Planting Conditions, length: 50
, Coded Values: 
[Fair: Fair]
, [Good: Good]
, [Poor: Poor]
)
 
- 
underpwerlins
(
type: esriFieldTypeString, alias: Planting Site: Under Power Lines?, length: 5
, Coded Values: 
[Yes: Yes]
, [No: No]
)
 
- 
matureheight
(
type: esriFieldTypeString, alias: Planting Site: Mature Height of Tree, length: 50
, Coded Values: 
[Small (less than 35 feet tall): Small (less than 35 feet tall)]
, [Medium (35 to 60 feet tall): Medium (35 to 60 feet tall)]
, [Large (over 60 feet tall): Large (over 60 feet tall)]
)
 
- 
GlobalID
(
type: esriFieldTypeGlobalID, alias: GlobalID, length: 38
)
 
- 
created_user
(
type: esriFieldTypeString, alias: created_user, length: 255
)
 
- 
created_date
(
type: esriFieldTypeDate, alias: created_date, length: 8
)
 
- 
last_edited_user
(
type: esriFieldTypeString, alias: last_edited_user, length: 255
)
 
- 
last_edited_date
(
type: esriFieldTypeDate, alias: last_edited_date, length: 8
)
 
- 
isoprene
(
type: esriFieldTypeDouble, alias: Isoprene
)
 
- 
monoterpene
(
type: esriFieldTypeDouble, alias: Monoterpene
)
 
- 
vocs
(
type: esriFieldTypeDouble, alias: VOCs
)
 
- 
coremoved_ozperyr
(
type: esriFieldTypeDouble, alias: CO Removed (oz/yr)
)
 
- 
coremoved_dolperyr
(
type: esriFieldTypeDouble, alias: CO Removed ($/yr)
)
 
- 
o3removed_ozperyr
(
type: esriFieldTypeDouble, alias: O3 Removed (oz/yr)
)
 
- 
o3removed_dolperyr
(
type: esriFieldTypeDouble, alias: O3 Removed ($/yr)
)
 
- 
no2removed_ozperyr
(
type: esriFieldTypeDouble, alias: NO2 Removed (oz/yr)
)
 
- 
no2removed_dolperyr
(
type: esriFieldTypeDouble, alias: NO2 Removed ($/yr)
)
 
- 
so2removed_ozperyr
(
type: esriFieldTypeDouble, alias: SO2 Removed (oz/yr)
)
 
- 
so2removed_dolperyr
(
type: esriFieldTypeDouble, alias: SO2 Removed ($/yr)
)
 
- 
pm10removed_ozperyr
(
type: esriFieldTypeDouble, alias: PM10 Removed (oz/yr)
)
 
- 
pm10removed_dolperyr
(
type: esriFieldTypeDouble, alias: PM10 Removed ($/yr)
)
 
- 
pm25removed_ozperyr
(
type: esriFieldTypeDouble, alias: PM2.5 Removed (oz/yr)
)
 
- 
o2production_lbperyr
(
type: esriFieldTypeDouble, alias: Oxygen Production (lb/yr)
)
 
- 
replacevalue_dol
(
type: esriFieldTypeDouble, alias: Replacement Value ($)
)
 
- 
carbonstorage_lb
(
type: esriFieldTypeDouble, alias: Carbon Storage (lb)
)
 
- 
carbonstorage_dol
(
type: esriFieldTypeDouble, alias: Carbon Storage ($)
)
 
- 
grosscarseq_lbperyr
(
type: esriFieldTypeDouble, alias: Gross Carbon Sequestration (lb/yr)
)
 
- 
grosscarseq_dolperyr
(
type: esriFieldTypeDouble, alias: Gross Carbon Sequestration ($/yr)
)
 
- 
avoidrunoff_ft2peryr
(
type: esriFieldTypeDouble, alias: Avoided Runoff (ft2/yr)
)
 
- 
avoidrunoff_dol2peryr
(
type: esriFieldTypeDouble, alias: Avoided Runoff ($/yr)
)
 
- 
polremoved_ozperyr
(
type: esriFieldTypeDouble, alias: Pollution Removal (oz/yr)
)
 
- 
polremoved_dolperyr
(
type: esriFieldTypeDouble, alias: Pollution Removal ($/yr)
)
 
- 
totannbenefits_dolperyr
(
type: esriFieldTypeDouble, alias: Total Annual Benefits ($/yr)
)
 
- 
leafarea_sqft
(
type: esriFieldTypeDouble, alias: Leaf Area (ft2)
)
 
- 
potevapotran_cuftperyr
(
type: esriFieldTypeDouble, alias: Potential Evapotranspiration (ft3/yr)
)
 
- 
evaporation_cuftperyr
(
type: esriFieldTypeDouble, alias: Evaporation (ft3/yr)
)
 
- 
transpiration_cuftperyr
(
type: esriFieldTypeDouble, alias: Transpiration (ft3/yr)
)
 
- 
h2ointercept_cuftperyr
(
type: esriFieldTypeDouble, alias: Water Intercepted (ft3/yr)
)
 
- 
avoidrunval_cuftperyr
(
type: esriFieldTypeDouble, alias: Avoided Runoff (ft3/yr)
)
 
- 
avoidrunval_dol2peryr
(
type: esriFieldTypeDouble, alias: Avoided Runoff Value ($/yr)
)
 
- 
carbonavoid_lbperyr
(
type: esriFieldTypeDouble, alias: Carbon Avoided (lb/yr)
)
 
- 
carbonavoid_dolperyr
(
type: esriFieldTypeDouble, alias: Carbon Avoided ($/yr)
)
 
- 
heating_mbtuperyr
(
type: esriFieldTypeDouble, alias: Heating (MBTU/yr)
)
 
- 
heating_dolperyrmbtu
(
type: esriFieldTypeDouble, alias: Heating ($/yr) - based on MBTU’s
)
 
- 
heating_kwhperyr
(
type: esriFieldTypeDouble, alias: Heating (Kwh/yr)
)
 
- 
heating_dolperyrmwh
(
type: esriFieldTypeDouble, alias: Heating ($/yr) - based on MWh's
)
 
- 
cooling_kwhperyr
(
type: esriFieldTypeDouble, alias: Cooling (Kwh/yr)
)
 
- 
cooling_dolperyr
(
type: esriFieldTypeDouble, alias: Cooling ($/yr)
)
 
- 
totalenerg_dolperyr
(
type: esriFieldTypeDouble, alias: Total Energy ($/yr)
)
 
- 
Shape
(
type: esriFieldTypeGeometry, alias: Shape
)
 
- 
ownertype
(
type: esriFieldTypeString, alias: Owner Type, length: 50
, Coded Values: 
[Municipal: Municipal]
, [County: County]
, [Regional: Regional]
, ...8 more...
)
 
- 
material
(
type: esriFieldTypeString, alias: Material, length: 20
, Coded Values: 
[ball and burlap: ball and burlap]
, [bare root: bare root]
, [container: container]
)
 
- 
notes
(
type: esriFieldTypeString, alias: Notes, length: 1000
)
 
Supported Operations:
  
Query
  Query Attachments
  Query Analytic
  Generate Renderer
  Return Updates
  Iteminfo
  Thumbnail
  Metadata