Name: Public Shade Trees

Display Field: RoadName

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 42726

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -7926142.42371092
YMin: 5220926.06348742
XMax: -7918478.99782368
YMax: 5226558.61531174
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"45feace4e7f7fa7e3854c1091995f1a3","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA4ElEQVQokZ2SQQ6CMBBFX8FL4Nqge64h19ADYNzq2sgB5BpeQ/Zq3AqnoDUdGkUUJP6Ekunklc/vjPhTo75mmLAAYuWzvOwoOsFZQqThAOTAGJjbfVNxcvV30EGRe5oKwoQjUFxTlk9wsiL2jNhqA03J18OE/JqSCeggaQxQZBcB7c+bivsAqPQge4EVgakD6bMqMj7lE9SKGPMbAgJTSYBxneowiKbqcGCrX+H0W1bSr8FzKoWyk+JBrmHbSNn2JBCtKG97uc/3AbD3Y9/TtaS8cW4yd/Cn1bbcXMqEdOkBTvBDJZJ4Ng4AAAAASUVORK5CYII=","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":-4.2202209243384921E-05,"yoffset":-4.2357326405806363E-05}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: GlobalID

Type ID Field:

Fields:

• AssetID (type: esriFieldTypeString, alias: Tree Asset ID, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• AddrNum (type: esriFieldTypeString, alias: Closest Address Number, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• RoadName (type: esriFieldTypeString, alias: Closest Road Name, SQL Type: sqlTypeOther, length: 75, nullable: true, editable: true, Coded Values: [ABERDEEN RD: ABERDEEN RD], [ACADEMY ST: ACADEMY ST], [ACORN PK: ACORN PK], ... 612 more ...)
• CommonName (type: esriFieldTypeString, alias: Common Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [American Beech: American Beech], [American Chestnut: American Chestnut], [American Elm: American Elm], ... 155 more ...)
• Genus (type: esriFieldTypeString, alias: Genus, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Abies: Abies], [Acer: Acer], [Aesculus: Aesculus], ... 63 more ...)
• Species (type: esriFieldTypeString, alias: Species, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Abies: Abies], [Acerifolia: Acerifolia], [Acuminata: Acuminata], ... 118 more ...)
• Cultivar (type: esriFieldTypeString, alias: Cultivated Variety, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• DBH (type: esriFieldTypeDouble, alias: Diameter at Breast Height (DBH) (Inches), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Height (type: esriFieldTypeDouble, alias: Height (ft), SQL Type: sqlTypeOther, nullable: true, editable: true)
• SpaceStatus (type: esriFieldTypeString, alias: Tree Space Status, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Available: Available], [Planted: Planted], [Stump: Stump], ... 3 more ...)
• SpaceMaterial (type: esriFieldTypeString, alias: Tree Space Material, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true, Coded Values: [Bark: Bark], [Brick: Brick], [Grass: Grass], ... 6 more ...)
• SpaceType (type: esriFieldTypeString, alias: Tree Location Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Bike Path: Bike Path], [Cemetery: Cemetery], [Park: Park], ... 3 more ...)
• PlantedDate (type: esriFieldTypeDate, alias: Planted Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• RemovedDate (type: esriFieldTypeDate, alias: Removed Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• HistoricDistrict (type: esriFieldTypeString, alias: Historic District, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• FloodZone (type: esriFieldTypeString, alias: Flood Zone (Y/N), SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Maintby (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Cemetery Staff: Cemetery Staff], [Conservation Staff: Conservation Staff], [Parks Staff: Parks Staff], ... 2 more ...)
• Stormwater (type: esriFieldTypeDouble, alias: Stormwater Intercepted (gal/yr), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Pollutants (type: esriFieldTypeDouble, alias: Air Pollutants Removed (oz/yr), SQL Type: sqlTypeOther, nullable: true, editable: true)
• CO2 (type: esriFieldTypeDouble, alias: Carbon Dioxide Reduced (lbs/yr), SQL Type: sqlTypeOther, nullable: true, editable: true)
• Benefits (type: esriFieldTypeDouble, alias: Total Value of Benefits ($/yr), SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: Edited Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: false)

Templates:

Name: Public Shade Trees
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Maintby: Tree Warden

Relationships:

• GIS.Tree_PestTreatment_tbl (0) -- Related To: Tree Pest Treatment (5)
• GIS.Tree_Inspection_tbl (2) -- Related To: Tree Inspections (3)
• GIS.Tree_Maintenance_tbl (1) -- Related To: Tree Work Orders (4)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/5/2026 7:36:21 PM

Schema Last Edit Date: 6/5/2026 7:36:16 PM

Data Last Edit Date: 6/5/2026 7:36:16 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat