Name: Tree Inventory

Display Field: TRACT_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Trees listed as Public, Private or Unknown based on distance from the City Right of Way. If a tree is beyond 3 feet it is listed as Private unless otherwise amended by staff.

Copyright Text: Jake Ohana

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: 6129931.92341197
YMin: 2088917.69780432
XMax: 6158216.98396772
YMax: 2121551.98489781
Spatial Reference: 102646 (2230)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[173,121,76,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: 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:

Type ID Field:

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• TreeNumber (type: esriFieldTypeInteger, alias: TreeNumber, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LocationType (type: esriFieldTypeString, alias: LocationType, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Streetscape: Streetscape], [Park: Park], [ROW: ROW], ... 5 more ...)
• TreeSpecies (type: esriFieldTypeString, alias: TreeSpecies, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Acacia sp.: Acacia sp.], [Acacia baileyana: Acacia baileyana], [Acacia melanoxylon: Acacia melanoxylon], ... 184 more ...)
• Stems (type: esriFieldTypeString, alias: Stems, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Multi: Multi], [Single: Single])
• DCH1 (type: esriFieldTypeDouble, alias: DCH1, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1"], [2: 2"], [3: 3"], ... 47 more ...)
• DCH2 (type: esriFieldTypeDouble, alias: DCH2, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1"], [2: 2"], [3: 3"], ... 47 more ...)
• DCH3 (type: esriFieldTypeDouble, alias: DCH3, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1"], [2: 2"], [3: 3"], ... 47 more ...)
• DCH4 (type: esriFieldTypeDouble, alias: DCH4, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1"], [2: 2"], [3: 3"], ... 47 more ...)
• DCH5 (type: esriFieldTypeDouble, alias: DCH5, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1"], [2: 2"], [3: 3"], ... 47 more ...)
• DCH6 (type: esriFieldTypeDouble, alias: DCH6, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1"], [2: 2"], [3: 3"], ... 47 more ...)
• Health (type: esriFieldTypeString, alias: Health, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Good: Good], [Fair: Fair], [Poor: Poor], ... 2 more ...)
• GrowSpaceType (type: esriFieldTypeString, alias: Grow Space, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Street Scapes: Street Scapes], [Tree Well: Tree Well], [Turf: Turf], ... 3 more ...)
• GrowSpaceDimension (type: esriFieldTypeSmallInteger, alias: GrowSpaceDimension, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [12: 12"], [18: 18"], [24: 24"], ... 3 more ...)
• EstimatedAge (type: esriFieldTypeString, alias: EstimatedAge, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [0-5 Years: 0-5 Years], [5-10 Years: 5-10 Years], [10-15 Years: 10-15 Years], ... 8 more ...)
• EstimatedRemainingLifespan (type: esriFieldTypeString, alias: Estimated Remaining Lifespan, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [0-5 Years: 0-5 Years], [5-10 Years: 5-10 Years], [10-15 Years: 10-15 Years], ... 8 more ...)
• AjdAppurtenances (type: esriFieldTypeString, alias: AjdAppurtenances, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Building: Building], [Overhead Powerlines: Overhead Powerlines], [Underground Powerlines: Underground Powerlines], ... 7 more ...)
• Dist_to_Appurtenances (type: esriFieldTypeDouble, alias: Dist_to_Appurtenances, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1'], [2: 2'], [3: 3'], ... 17 more ...)
• CityROW (type: esriFieldTypeString, alias: CityROW, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [City Of San Clemente: City of San Clemente], [Unknown: Unknown], [Private: Private])
• OwnedBy (type: esriFieldTypeString, alias: OwnedBy, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [City Of San Clemente: City of San Clemente], [Unknown: Unknown], [Private: Private])
• PestPathogen (type: esriFieldTypeString, alias: PestPathogen, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• RootPrunning (type: esriFieldTypeString, alias: RootPrunning, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• HardscapeDamage (type: esriFieldTypeString, alias: HardscapeDamage, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• CanopySize (type: esriFieldTypeDouble, alias: CanopySize, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [5: 5'], [10: 10'], [15: 15'], ... 17 more ...)
• Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• AdjacentAppurtenancesYesNo (type: esriFieldTypeString, alias: AdjacentAppurtenancesYesNo, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• LASTEDITOR (type: esriFieldTypeString, alias: LAST EDITOR, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• LASTUPDATE (type: esriFieldTypeDate, alias: LAST UPDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ACTIVEFLAG (type: esriFieldTypeSmallInteger, alias: Active Flag, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• ROUTE_GRID (type: esriFieldTypeString, alias: ROUTE_GRID, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• INSTALL_DATE (type: esriFieldTypeDouble, alias: INSTALL_DATE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TRACT_NAME (type: esriFieldTypeString, alias: TRACT_NAME, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• INLUCITY (type: esriFieldTypeSmallInteger, alias: In Lucity?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LUCITYLINK (type: esriFieldTypeInteger, alias: Link to Lucity, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LUCITY_CATEGORY_CODE (type: esriFieldTypeString, alias: Lucity Category Code, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LUCITY_CATEGORY_TEXT (type: esriFieldTypeString, alias: Lucity Category Text, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• OPERATIONAL_STATUS (type: esriFieldTypeSmallInteger, alias: Operational Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Operational], [0: Abandoned], [951: Out of Service], ... 1 more ...)
• LASTSYNDATE (type: esriFieldTypeDate, alias: LASTSYNDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• WCA_INVENTORYID (type: esriFieldTypeInteger, alias: WCA_INVENTORYID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DISTRICT (type: esriFieldTypeString, alias: DISTRICT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ADDRESS (type: esriFieldTypeInteger, alias: ADDRESS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STREET (type: esriFieldTypeString, alias: STREET, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• FICTITIOUS (type: esriFieldTypeString, alias: FICTITIOUS, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
• SIDE (type: esriFieldTypeString, alias: SIDE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ONADDRESS (type: esriFieldTypeInteger, alias: ONADDRESS, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ONSTREET (type: esriFieldTypeString, alias: ONSTREET, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• SPECIESID (type: esriFieldTypeInteger, alias: SPECIESID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• TreeSpecies2 (type: esriFieldTypeString, alias: TreeSpecies2, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
• DBH (type: esriFieldTypeString, alias: DBH, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• RECOMMENDED (type: esriFieldTypeString, alias: RECOMMENDED, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
• UTILITY (type: esriFieldTypeString, alias: UTILITY, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• PRIORITY (type: esriFieldTypeString, alias: PRIORITY, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PARKWAYTYPE (type: esriFieldTypeString, alias: PARKWAYTYPE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ESTIMATED_ (type: esriFieldTypeInteger, alias: ESTIMATED_, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Tree_Height (type: esriFieldTypeString, alias: Tree_Height, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Grow_Space_Dimension (type: esriFieldTypeInteger, alias: Grow_Space_Dimension, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DIST_to_APP (type: esriFieldTypeString, alias: DIST_to_App, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• PestPathog (type: esriFieldTypeString, alias: PestPathog, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Canopy_Size (type: esriFieldTypeString, alias: Canopy_Size, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)

Templates:

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

Attributes:

• ACTIVEFLAG: 1
• INLUCITY: 0
• OPERATIONAL_STATUS: 1

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/11/2025 4:42:38 PM

Schema Last Edit Date: 7/11/2025 4:42:38 PM

Data Last Edit Date: 7/11/2025 4:42:38 PM

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