Name: Trees

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -15000000
YMin: 2700000
XMax: -6200000
YMax: 6500000
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"visualVariables":[{"type":"sizeInfo","field":"diameter","valueExpression":null,"valueUnit":"unknown","minSize":6,"maxSize":52.5,"minDataValue":0.5,"maxDataValue":90}],"authoringInfo":{"visualVariables":[{"type":"sizeInfo","minSliderValue":0.5,"maxSliderValue":90}]},"type":"uniqueValue","field1":"spacestatus","uniqueValueInfos":[{"label":"Planted","symbol":{"color":[26,99,36,255],"size":18.75,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[26,40,22,201],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"value":"Planted"},{"label":"Available","symbol":{"color":[0,122,194,255],"size":18.75,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[0,25,39,196],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"value":"Available"},{"label":"Retired","symbol":{"color":[201,49,0,255],"size":18.75,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[40,10,0,193],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"value":"Retired"},{"label":"Stump","symbol":{"color":[108,64,0,255],"size":18.75,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[22,13,0,193],"width":0.75,"type":"esriSLS","style":"esriSLSSolid"}},"value":"Stump"},{"label":"Other","symbol":{"color":[88,89,91,255],"size":18.75,"angle":0,"xoffset":0,"yoffset":0,"type":"esriSMS","style":"esriSMSCircle","outline":{"color":[18,18,18,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"}},"value":"Other"}]},"labelingInfo":[{"labelExpression":null,"labelExpressionInfo":{"expression":"$feature[\"commonname\"]\nDomainName($feature,\"commonname\")"},"useCodedValues":true,"maxScale":0,"minScale":1415,"where":null,"labelPlacement":"esriServerPointLabelPlacementAboveCenter","symbol":{"color":[105,105,105,255],"type":"esriTS","backgroundColor":null,"borderLineColor":null,"haloSize":0,"haloColor":null,"horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"text":"","rotated":false,"kerning":true,"font":{"size":10.5,"style":"normal","decoration":"none","weight":"normal","family":"Arial"}}}],"transparency":0}

HasZ: true

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:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• assetid (type: esriFieldTypeString, alias: Tree identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• fulladdr (type: esriFieldTypeString, alias: Nearest address, SQL Type: sqlTypeOther, length: 250, nullable: true, editable: true)
• district (type: esriFieldTypeString, alias: District or neighborhood, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• municipality (type: esriFieldTypeString, alias: Municipality, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• commonname (type: esriFieldTypeString, alias: Common name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Adirondack Crabapple (A): Adirondack Crabapple (A)], [Alder: Alder], [Allegheny Serviceberry (A): Allegheny Serviceberry (A)], ... 135 more ...)
• genus (type: esriFieldTypeString, alias: Genus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Abies: Abies], [Acacia: Acacia], [Acer: Acer], ... 120 more ...)
• species (type: esriFieldTypeString, alias: Species, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Abies: Abies], [Actinophylla: Actinophylla], [Acuminata: Acuminata], ... 297 more ...)
• diameter (type: esriFieldTypeDouble, alias: Diameter at breast height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• height (type: esriFieldTypeDouble, alias: Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
• installdate (type: esriFieldTypeDate, alias: Date planted, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• treewires (type: esriFieldTypeString, alias: Tree wires present, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• treeguard (type: esriFieldTypeString, alias: Tree guard present, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• heritage (type: esriFieldTypeString, alias: Heritage tree, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• overheadutilities (type: esriFieldTypeString, alias: Overhead utilities, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• warranty (type: esriFieldTypeString, alias: Warranty, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• warrantydate (type: esriFieldTypeDate, alias: Warranty date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• waterthroughdate (type: esriFieldTypeDate, alias: Water through date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• treenotes (type: esriFieldTypeString, alias: Tree notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• retiredate (type: esriFieldTypeDate, alias: Date retired, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• spaceid (type: esriFieldTypeString, alias: Planting space identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• spacestatus (type: esriFieldTypeString, alias: Planting space status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Available: Available], [Planted: Planted], [Stump: Stump], ... 2 more ...)
• spacetype (type: esriFieldTypeString, alias: Planting space type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Bark: Bark], [Brick: Brick], [Grass: Grass], ... 6 more ...)
• sitetype (type: esriFieldTypeString, alias: Site type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Circle: Traffic circle], [Curb: Curb], [Island: Traffic island], ... 4 more ...)
• spacewidth (type: esriFieldTypeDouble, alias: Planting space width, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spacelength (type: esriFieldTypeDouble, alias: Planting space length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• spacenotes (type: esriFieldTypeString, alias: Planting space notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• collectedby (type: esriFieldTypeSmallInteger, alias: Collected by, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Our Agency], [1: Private], [2: Other])
• publicview (type: esriFieldTypeString, alias: Publicly Visibile, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• globalid (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• stormwater (type: esriFieldTypeDouble, alias: Stormwater intercepted, SQL Type: sqlTypeOther, nullable: true, editable: true)
• energy (type: esriFieldTypeDouble, alias: Energy conserved, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pollutants (type: esriFieldTypeDouble, alias: Air pollutants removed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• co2 (type: esriFieldTypeDouble, alias: Carbon dioxide reduced, SQL Type: sqlTypeOther, nullable: true, editable: true)
• propvalue (type: esriFieldTypeDouble, alias: Increased property value, SQL Type: sqlTypeOther, nullable: true, editable: true)
• benefits (type: esriFieldTypeDouble, alias: Total value of benefits, SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: Planted
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• collectedby: 0
• spacestatus: Planted
• ownedby: 0
• maintby: 0
Name: Available
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• collectedby: 0
• spacestatus: Available
• ownedby: 0
• maintby: 0
Name: Retired
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• collectedby: 0
• spacestatus: Retired
• ownedby: 0
• maintby: 0
Name: Stump
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• collectedby: 0
• spacestatus: Stump
• ownedby: 0
• maintby: 0
Name: Other
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• collectedby: 0
• spacestatus: Other
• ownedby: 0
• maintby: 0

Relationships:

• Maintenance (0) -- Related To: Maintenance (1)
• Inspections (1) -- Related To: Inspections (2)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/7/2025 3:06:46 PM

Schema Last Edit Date: 4/25/2025 8:21:57 PM

Data Last Edit Date: 7/7/2025 3:06:46 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