Name: Tree Inventory

Display Field: UniqueID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -8638338.03895877
YMin: 4502301.68411758
XMax: -8614634.23810502
YMax: 4523584.59380656
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[58,150,77,255],"size":6,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":1}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

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)
• ID (type: esriFieldTypeDouble, alias: ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UniqueID (type: esriFieldTypeString, alias: UniqueID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Address (type: esriFieldTypeString, alias: Address, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• Suffix (type: esriFieldTypeString, alias: Suffix, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Street (type: esriFieldTypeString, alias: Street, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• OnStr (type: esriFieldTypeString, alias: OnStr, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• FromStr (type: esriFieldTypeString, alias: FromStr, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• toStr (type: esriFieldTypeString, alias: toStr, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• Side (type: esriFieldTypeString, alias: Side, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Front: Front], [Side Away: Side Away], [Side To: Side To], ... 4 more ...)
• Site (type: esriFieldTypeString, alias: Site, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• SPP (type: esriFieldTypeString, alias: Species, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true, Coded Values: [Vacant Site Small: Vacant Site Small], [Lagerstroemia indica: Lagerstroemia indica], [Vacant Site Large: Vacant Site Large], ... 296 more ...)
• DBH (type: esriFieldTypeDouble, alias: DBH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• COND (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• MT (type: esriFieldTypeString, alias: MT, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• MT2 (type: esriFieldTypeString, alias: MT2, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true)
• GROWSPACE (type: esriFieldTypeString, alias: Growspace, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Tree Lawn or Parkway: Tree Lawn or Parkway], [Open/Unrestricted: Open/Unrestricted], [Well/Pit: Well/Pit], ... 5 more ...)
• SPACESIZE (type: esriFieldTypeDouble, alias: SPACESIZE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• UTILITIES (type: esriFieldTypeString, alias: Overhead Utilities, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: N], [Y: Y])
• LOCVAL (type: esriFieldTypeString, alias: LOCVAL, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• INSPECT (type: esriFieldTypeString, alias: INSPECT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: N], [Y: Y])
• HDSCAPEDAM (type: esriFieldTypeString, alias: HDSCAPEDAM, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [N: N], [Y: Y])
• KLIR (type: esriFieldTypeString, alias: KLIR, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true)
• TRUNKS (type: esriFieldTypeDouble, alias: Trunks, SQL Type: sqlTypeOther, nullable: true, editable: true)
• OBSERVE (type: esriFieldTypeString, alias: OBSERVE, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Cavity or Decay: Cavity or Decay], [Grate or Guard: Grate or Guard], [Improperly Installed: Improperly Installed], ... 14 more ...)
• LOCTYPE (type: esriFieldTypeString, alias: Location Type, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true, Coded Values: [Street: Street], [Park/Public Space: Park/Public Space], [Borderline: Borderline], ... 3 more ...)
• AREA (type: esriFieldTypeString, alias: Neighborhood, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• P_DIST (type: esriFieldTypeString, alias: Planning District, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Broad Rock: Broad Rock], [Downtown: Downtown], [East: East], ... 6 more ...)
• C_DIST (type: esriFieldTypeString, alias: Council District, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [1: 1], [2: 2], [3: 3], ... 6 more ...)
• PROBFAIL (type: esriFieldTypeString, alias: PROBFAIL, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true, Coded Values: [N/A: N/A], [Low: Low], [Medium: Medium], ... 2 more ...)
• DEFECT (type: esriFieldTypeString, alias: DEFECT, SQL Type: sqlTypeOther, length: 23, nullable: true, editable: true)
• IMPACT (type: esriFieldTypeString, alias: IMPACT, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• RATING (type: esriFieldTypeDouble, alias: RATING, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STAFF (type: esriFieldTypeString, alias: STAFF, SQL Type: sqlTypeOther, length: 4, nullable: true, editable: true)
• CULTIVAR (type: esriFieldTypeString, alias: CULTIVAR, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Inv_Date (type: esriFieldTypeDate, alias: Inv_Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inv_Time (type: esriFieldTypeString, alias: Inv_Time, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• INSPECT_DT (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Inspect_TM (type: esriFieldTypeString, alias: Inspect_TM, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
• Active (type: esriFieldTypeDouble, alias: Active, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AddrLabl (type: esriFieldTypeString, alias: Full Address, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• TreeID (type: esriFieldTypeString, alias: Tree ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• TreeID_L (type: esriFieldTypeInteger, alias: TreeID_L, SQL Type: sqlTypeOther, nullable: true, editable: true)
• AssetID (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CarriagewayID (type: esriFieldTypeInteger, alias: Carriageway ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• IntersectionID (type: esriFieldTypeInteger, alias: Intersection ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LegacyAssetID (type: esriFieldTypeString, alias: Legacy Asset ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• Condition_Date (type: esriFieldTypeDate, alias: Condition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Install_Date (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Warranty_Date (type: esriFieldTypeDate, alias: Warranty 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: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [In Service: In Service], [Retired: Retired], [OOS: Out of Service], ... 1 more ...)
• LegacyCondition (type: esriFieldTypeString, alias: Legacy Condition, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true)
• Veriify (type: esriFieldTypeString, alias: Verify, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes], [Verified: Verified])
• PartofaGrant (type: esriFieldTypeString, alias: Part of a Grant, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Name: Tree Inventory
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• Veriify: No
• PartofaGrant: No

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 2/13/2025 1:42:42 PM

Schema Last Edit Date: 2/13/2025 1:42:42 PM

Data Last Edit Date: 2/13/2025 1:42:42 PM

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