View In:   ArcGIS Online Map Viewer

Name: Trees & Planting Sites

Display Field: commonname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 6df8ac036bff46deac0684b252d96145

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 5000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 2001988.0679621696
YMin: 776638.8317567259
XMax: 2061264.200721994
YMax: 848751.4066914022
Spatial Reference: 102719  (2264)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: present
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [130, 130, 130, 255]
Size: 6.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Default Label:
UniqueValueInfos:
• Value: Tree
  Label: Tree
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [152, 230, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [130, 130, 130, 255] Width: 0
• Value: Planting Site
  Label: Planting Site
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 115, 223, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [130, 130, 130, 255] Width: 0
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: present

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• streetaddress ( type: esriFieldTypeString, alias: Street Address, editable: true, nullable: true, length: 100, defaultValue: null, modelName: streetaddress )
• city ( type: esriFieldTypeString, alias: City, editable: true, nullable: true, length: 50, defaultValue: null, modelName: city )
• zipcode ( type: esriFieldTypeSmallInteger, alias: Zip Code, editable: true, nullable: true, defaultValue: null, modelName: zipcode )
• facilityid ( type: esriFieldTypeInteger, alias: Tree: Id, editable: true, nullable: true, defaultValue: null, modelName: treeid )
• present ( type: esriFieldTypeString, alias: Tree: Present?, editable: true, nullable: true, length: 20, defaultValue: null, modelName: present , Coded Values: [Tree: Tree] , [Planting Site: Planting Site] )
• genus ( type: esriFieldTypeString, alias: Tree: Genus, editable: true, nullable: true, length: 50, defaultValue: null, modelName: genus , Coded Values: [Abies: Abies] , [Acacia: Acacia] , [Acer: Acer] , ...110 more... )
• species ( type: esriFieldTypeString, alias: Tree: Species, editable: true, nullable: true, length: 50, defaultValue: null, modelName: species , Coded Values: [abies: abies] , [acerifolia: acerifolia] , [acuminata: acuminata] , ...199 more... )
• commonname ( type: esriFieldTypeString, alias: Tree: Common Name, editable: true, nullable: true, length: 50, defaultValue: null, modelName: commonname , Coded Values: [Acuba: Acuba] , [Alternateleaf Dogwood: Alternateleaf Dogwood] , [American Arborvitae: American Arborvitae] , ...275 more... )
• plantingdate ( type: esriFieldTypeString, alias: Tree: Planting Date, editable: true, nullable: true, length: 20, defaultValue: null, modelName: plantingdate , Coded Values: [2016-2017: 2016-2017] , [2017-2018: 2017-2018] , [2018-2019: 2018-2019] , ...11 more... )
• diameterin ( type: esriFieldTypeDouble, alias: Tree: Diameter, editable: true, nullable: true, defaultValue: null, modelName: diameterin )
• heightft ( type: esriFieldTypeString, alias: Tree: Height (feet), editable: true, nullable: true, length: 20, defaultValue: null, modelName: heightft , Coded Values: [0-20: 0-20] , [20-40: 20-40] , [40-60: 40-60] , ...2 more... )
• condition ( type: esriFieldTypeString, alias: Tree: Condition, editable: true, nullable: true, length: 50, defaultValue: null, modelName: condition , Coded Values: [Fair: Fair] , [Good: Good] , [Poor: Poor] )
• contractwork ( type: esriFieldTypeString, alias: Tree: Contract Work, editable: true, nullable: true, length: 100, defaultValue: null, modelName: contractwork , Coded Values: [tree removal: tree removal] , [tree pruning: tree pruning] , [stump grinding: stump grinding] )
• program ( type: esriFieldTypeString, alias: Tree: Program, editable: true, nullable: true, length: 50, defaultValue: null, modelName: program , Coded Values: [DCOI: DCOI] , [PB: PB] , [PWSW: PWSW] , ...4 more... )
• neighborhood ( type: esriFieldTypeString, alias: Neighborhood, editable: true, nullable: true, length: 50, defaultValue: null, modelName: neighborhood , Coded Values: [Downtown: Downtown] , [Lyon Park: Lyon Park] , [Old East Durham: Old East Durham] , ...6 more... )
• plantingw ( type: esriFieldTypeString, alias: Planting Site: Width, editable: true, nullable: true, length: 50, defaultValue: null, modelName: plantingw , 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, editable: true, nullable: true, length: 50, defaultValue: null, modelName: plantingcond , Coded Values: [Fair: Fair] , [Good: Good] , [Poor: Poor] )
• underpwerlins ( type: esriFieldTypeString, alias: Planting Site: Under Power Lines?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: underpwerlins , Coded Values: [Yes: Yes] , [No: No] )
• matureheight ( type: esriFieldTypeString, alias: Planting Site: Mature Height of Tree, editable: true, nullable: true, length: 50, defaultValue: null, modelName: matureheight , 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)] )
• contractplantingyr ( type: esriFieldTypeSmallInteger, alias: Contract Planting Year, editable: true, nullable: true, defaultValue: null, modelName: contractplantingyr )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• isoprene ( type: esriFieldTypeDouble, alias: Isoprene, editable: true, nullable: true, defaultValue: null, modelName: isoprene )
• monoterpene ( type: esriFieldTypeDouble, alias: Monoterpene, editable: true, nullable: true, defaultValue: null, modelName: monoterpene )
• vocs ( type: esriFieldTypeDouble, alias: VOCs, editable: true, nullable: true, defaultValue: null, modelName: vocs )
• coremoved_ozperyr ( type: esriFieldTypeDouble, alias: CO Removed (oz/yr), editable: true, nullable: true, defaultValue: null, modelName: coremoved_ozperyr )
• coremoved_dolperyr ( type: esriFieldTypeDouble, alias: CO Removed ($/yr), editable: true, nullable: true, defaultValue: null, modelName: coremoved_dolperyr )
• o3removed_ozperyr ( type: esriFieldTypeDouble, alias: O3 Removed (oz/yr), editable: true, nullable: true, defaultValue: null, modelName: o3removed_ozperyr )
• o3removed_dolperyr ( type: esriFieldTypeDouble, alias: O3 Removed ($/yr), editable: true, nullable: true, defaultValue: null, modelName: o3removed_dolperyr )
• no2removed_ozperyr ( type: esriFieldTypeDouble, alias: NO2 Removed (oz/yr), editable: true, nullable: true, defaultValue: null, modelName: no2removed_ozperyr )
• no2removed_dolperyr ( type: esriFieldTypeDouble, alias: NO2 Removed ($/yr), editable: true, nullable: true, defaultValue: null, modelName: no2removed_dolperyr )
• so2removed_ozperyr ( type: esriFieldTypeDouble, alias: SO2 Removed (oz/yr), editable: true, nullable: true, defaultValue: null, modelName: so2removed_ozperyr )
• so2removed_dolperyr ( type: esriFieldTypeDouble, alias: SO2 Removed ($/yr), editable: true, nullable: true, defaultValue: null, modelName: so2removed_dolperyr )
• pm10removed_ozperyr ( type: esriFieldTypeDouble, alias: PM10 Removed (oz/yr), editable: true, nullable: true, defaultValue: null, modelName: pm10removed_ozperyr )
• pm10removed_dolperyr ( type: esriFieldTypeDouble, alias: PM10 Removed ($/yr), editable: true, nullable: true, defaultValue: null, modelName: pm10removed_dolperyr )
• pm25removed_ozperyr ( type: esriFieldTypeDouble, alias: PM2.5 Removed (oz/yr), editable: true, nullable: true, defaultValue: null, modelName: pm25removed_ozperyr )
• o2production_lbperyr ( type: esriFieldTypeDouble, alias: Oxygen Production (lb/yr), editable: true, nullable: true, defaultValue: null, modelName: o2production_lbperyr )
• replacevalue_dol ( type: esriFieldTypeDouble, alias: Replacement Value ($), editable: true, nullable: true, defaultValue: null, modelName: replacevalue_dol )
• carbonstorage_lb ( type: esriFieldTypeDouble, alias: Carbon Storage (lb), editable: true, nullable: true, defaultValue: null, modelName: carbonstorage_lb )
• carbonstorage_dol ( type: esriFieldTypeDouble, alias: Carbon Storage ($), editable: true, nullable: true, defaultValue: null, modelName: carbonstorage_dol )
• grosscarseq_lbperyr ( type: esriFieldTypeDouble, alias: Gross Carbon Sequestration (lb/yr), editable: true, nullable: true, defaultValue: null, modelName: grosscarseq_lbperyr )
• grosscarseq_dolperyr ( type: esriFieldTypeDouble, alias: Gross Carbon Sequestration ($/yr), editable: true, nullable: true, defaultValue: null, modelName: grosscarseq_dolperyr )
• avoidrunoff_ft2peryr ( type: esriFieldTypeDouble, alias: Avoided Runoff (ft2/yr), editable: true, nullable: true, defaultValue: null, modelName: avoidrunoff_ft2peryr )
• avoidrunoff_dol2peryr ( type: esriFieldTypeDouble, alias: Avoided Runoff ($/yr), editable: true, nullable: true, defaultValue: null, modelName: avoidrunoff_dol2peryr )
• polremoved_ozperyr ( type: esriFieldTypeDouble, alias: Pollution Removal (oz/yr), editable: true, nullable: true, defaultValue: null, modelName: polremoved_ozperyr )
• polremoved_dolperyr ( type: esriFieldTypeDouble, alias: Pollution Removal ($/yr), editable: true, nullable: true, defaultValue: null, modelName: polremoved_dolperyr )
• totannbenefits_dolperyr ( type: esriFieldTypeDouble, alias: Total Annual Benefits ($/yr), editable: true, nullable: true, defaultValue: null, modelName: totannbenefits_dolperyr )
• leafarea_sqft ( type: esriFieldTypeDouble, alias: Leaf Area (ft2), editable: true, nullable: true, defaultValue: null, modelName: leafarea_sqft )
• potevapotran_cuftperyr ( type: esriFieldTypeDouble, alias: Potential Evapotranspiration (ft3/yr), editable: true, nullable: true, defaultValue: null, modelName: potevapotran_cuftperyr )
• evaporation_cuftperyr ( type: esriFieldTypeDouble, alias: Evaporation (ft3/yr), editable: true, nullable: true, defaultValue: null, modelName: evaporation_cuftperyr )
• transpiration_cuftperyr ( type: esriFieldTypeDouble, alias: Transpiration (ft3/yr), editable: true, nullable: true, defaultValue: null, modelName: transpiration_cuftperyr )
• h2ointercept_cuftperyr ( type: esriFieldTypeDouble, alias: Water Intercepted (ft3/yr), editable: true, nullable: true, defaultValue: null, modelName: h2ointercept_cuftperyr )
• avoidrunval_cuftperyr ( type: esriFieldTypeDouble, alias: Avoided Runoff (ft3/yr), editable: true, nullable: true, defaultValue: null, modelName: avoidrunval_cuftperyr )
• avoidrunval_dol2peryr ( type: esriFieldTypeDouble, alias: Avoided Runoff Value ($/yr), editable: true, nullable: true, defaultValue: null, modelName: avoidrunval_dol2peryr )
• carbonavoid_lbperyr ( type: esriFieldTypeDouble, alias: Carbon Avoided (lb/yr), editable: true, nullable: true, defaultValue: null, modelName: carbonavoid_lbperyr )
• carbonavoid_dolperyr ( type: esriFieldTypeDouble, alias: Carbon Avoided ($/yr), editable: true, nullable: true, defaultValue: null, modelName: carbonavoid_dolperyr )
• heating_mbtuperyr ( type: esriFieldTypeDouble, alias: Heating (MBTU/yr), editable: true, nullable: true, defaultValue: null, modelName: heating_mbtuperyr )
• heating_dolperyrmbtu ( type: esriFieldTypeDouble, alias: Heating ($/yr) - based on MBTU’s, editable: true, nullable: true, defaultValue: null, modelName: heating_dolperyrmbtu )
• heating_kwhperyr ( type: esriFieldTypeDouble, alias: Heating (Kwh/yr), editable: true, nullable: true, defaultValue: null, modelName: heating_kwhperyr )
• heating_dolperyrmwh ( type: esriFieldTypeDouble, alias: Heating ($/yr) - based on MWh's, editable: true, nullable: true, defaultValue: null, modelName: heating_dolperyrmwh )
• cooling_kwhperyr ( type: esriFieldTypeDouble, alias: Cooling (Kwh/yr), editable: true, nullable: true, defaultValue: null, modelName: cooling_kwhperyr )
• cooling_dolperyr ( type: esriFieldTypeDouble, alias: Cooling ($/yr), editable: true, nullable: true, defaultValue: null, modelName: cooling_dolperyr )
• totalenerg_dolperyr ( type: esriFieldTypeDouble, alias: Total Energy ($/yr), editable: true, nullable: true, defaultValue: null, modelName: totalenerg_dolperyr )
• pitcondition ( type: esriFieldTypeString, alias: Tree: Pit Condition, editable: true, nullable: true, length: 100, defaultValue: null, modelName: pitcondition , Coded Values: [Damaged Hardscape: Damaged Hardscape] , [Damaged Grate: Damaged Grate] , [Girdling Grate: Girdling Grate] , ...2 more... )
• pittreatment ( type: esriFieldTypeString, alias: Tree: Pit Treatment, editable: true, nullable: true, length: 100, defaultValue: null, modelName: pittreatment , 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, editable: true, nullable: true, length: 8, defaultValue: null, modelName: pitinstalldate )

Types:

ID: Tree
Name: Tree
Domains:
• present:
  Inherited
• genus:
  Inherited
• species:
  Inherited
• commonname:
  Inherited
• plantingdate:
  Inherited
• heightft:
  Inherited
• condition:
  Inherited
• contractwork:
  Inherited
• program:
  Inherited
• neighborhood:
  Inherited
• plantingw:
  Inherited
• plantingcond:
  Inherited
• underpwerlins:
  Inherited
• matureheight:
  Inherited
• pitcondition:
  Inherited
• pittreatment:
  Inherited
Templates:
• Name: Tree
  Description:
  Prototype:
  facilityid: null
  pittreatment: null
  streetaddress: null
  city: null
  zipcode: null
  present: Tree
  genus: null
  species: null
  commonname: null
  plantingdate: null
  diameterin: null
  heightft: null
  condition: null
  contractwork: null
  program: null
  neighborhood: null
  plantingw: null
  plantingcond: null
  underpwerlins: null
  matureheight: null
  contractplantingyr: null
  pitinstalldate: null
  pitcondition: null
  totalenerg_dolperyr: null
  cooling_dolperyr: null
  cooling_kwhperyr: null
  isoprene: null
  monoterpene: null
  vocs: null
  coremoved_ozperyr: null
  coremoved_dolperyr: null
  o3removed_ozperyr: null
  o3removed_dolperyr: null
  no2removed_ozperyr: null
  no2removed_dolperyr: null
  so2removed_ozperyr: null
  so2removed_dolperyr: null
  pm10removed_ozperyr: null
  pm10removed_dolperyr: null
  pm25removed_ozperyr: null
  o2production_lbperyr: null
  replacevalue_dol: null
  carbonstorage_lb: null
  carbonstorage_dol: null
  grosscarseq_lbperyr: null
  grosscarseq_dolperyr: null
  avoidrunoff_ft2peryr: null
  avoidrunoff_dol2peryr: null
  polremoved_ozperyr: null
  polremoved_dolperyr: null
  totannbenefits_dolperyr: null
  leafarea_sqft: null
  potevapotran_cuftperyr: null
  evaporation_cuftperyr: null
  transpiration_cuftperyr: null
  h2ointercept_cuftperyr: null
  avoidrunval_cuftperyr: null
  avoidrunval_dol2peryr: null
  carbonavoid_lbperyr: null
  carbonavoid_dolperyr: null
  heating_mbtuperyr: null
  heating_dolperyrmbtu: null
  heating_kwhperyr: null
  heating_dolperyrmwh: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Planting Site
Name: Planting Site
Domains:
• present:
  Inherited
• genus:
  Inherited
• species:
  Inherited
• commonname:
  Inherited
• plantingdate:
  Inherited
• heightft:
  Inherited
• condition:
  Inherited
• contractwork:
  Inherited
• program:
  Inherited
• neighborhood:
  Inherited
• plantingw:
  Inherited
• plantingcond:
  Inherited
• underpwerlins:
  Inherited
• matureheight:
  Inherited
• pitcondition:
  Inherited
• pittreatment:
  Inherited
Templates:
• Name: Planting Site
  Description:
  Prototype:
  facilityid: null
  pittreatment: null
  streetaddress: null
  city: null
  zipcode: null
  present: Planting Site
  genus: null
  species: null
  commonname: null
  plantingdate: null
  diameterin: null
  heightft: null
  condition: null
  contractwork: null
  program: null
  neighborhood: null
  plantingw: null
  plantingcond: null
  underpwerlins: null
  matureheight: null
  contractplantingyr: null
  pitinstalldate: null
  pitcondition: null
  totalenerg_dolperyr: null
  cooling_dolperyr: null
  cooling_kwhperyr: null
  isoprene: null
  monoterpene: null
  vocs: null
  coremoved_ozperyr: null
  coremoved_dolperyr: null
  o3removed_ozperyr: null
  o3removed_dolperyr: null
  no2removed_ozperyr: null
  no2removed_dolperyr: null
  so2removed_ozperyr: null
  so2removed_dolperyr: null
  pm10removed_ozperyr: null
  pm10removed_dolperyr: null
  pm25removed_ozperyr: null
  o2production_lbperyr: null
  replacevalue_dol: null
  carbonstorage_lb: null
  carbonstorage_dol: null
  grosscarseq_lbperyr: null
  grosscarseq_dolperyr: null
  avoidrunoff_ft2peryr: null
  avoidrunoff_dol2peryr: null
  polremoved_ozperyr: null
  polremoved_dolperyr: null
  totannbenefits_dolperyr: null
  leafarea_sqft: null
  potevapotran_cuftperyr: null
  evaporation_cuftperyr: null
  transpiration_cuftperyr: null
  h2ointercept_cuftperyr: null
  avoidrunval_cuftperyr: null
  avoidrunval_dol2peryr: null
  carbonavoid_lbperyr: null
  carbonavoid_dolperyr: null
  heating_mbtuperyr: null
  heating_dolperyrmbtu: null
  heating_kwhperyr: null
  heating_dolperyrmwh: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata