Name: Trees

Display Field: commonname

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 18489298

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -11711796.3907
YMin: 4838451.8525
XMax: -9804798.11008962
YMax: 5137938.83238724
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[121,160,77,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

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)
• family (type: esriFieldTypeString, alias: Family, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Adoxaceae: Adoxaceae], [Altingiaceae: Altingiaceae], [Anacardiaceae: Anacardiaceae], ... 43 more ...)
• genus (type: esriFieldTypeString, alias: Genus, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Abies: Abies], [Acer: Acer], [Aesculus: Aesculus], ... 102 more ...)
• species (type: esriFieldTypeString, alias: Species, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Abies: Abies], [Acerifolia: Acerifolia], [Actinophyllum: Actinophyllum], ... 256 more ...)
• cultivar (type: esriFieldTypeString, alias: Cultivar, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Princeton: Princeton], [Valley Forge: Valley Forge])
• commonname (type: esriFieldTypeString, alias: Common name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Alaska Willow: Alaska Willow], [Alaska-Cedar: Alaska-Cedar], [Allegheny Chinkapin: Allegheny Chinkapin], ... 333 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)
• height_units (type: esriFieldTypeString, alias: Height Units, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Feet: Feet], [Meters: Meters])
• 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])
• designation (type: esriFieldTypeString, alias: Special designation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Memorial: Memorial], [Dedication: Dedication], [Heritage: Heritage])
• 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])
• 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)
• adoptionstatus (type: esriFieldTypeString, alias: Adoption Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Available: Available], [Adopted: Adopted])
• adoptedby (type: esriFieldTypeString, alias: Adopted By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• adoptedon (type: esriFieldTypeDate, alias: Adopted On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• nickname (type: esriFieldTypeString, alias: Nickname, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• globalid (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• created_user (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: Created On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: Last Edited By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: Last Edited On, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Name: Available
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

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

Attributes:

• spacestatus: Planted
• ownedby: 0
• maintby: 0
• collectedby: 0
• publicview: Yes
Name: Stump
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

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

Attributes:

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

Attributes:

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

Relationships:

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

Is Data Versioned: false

Has Contingent Values: true

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/15/2025 9:46:10 PM

Schema Last Edit Date: 6/27/2024 2:13:33 AM

Data Last Edit Date: 7/15/2025 9:46:10 PM

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat