Layer: Trees (ID:0)

View In: Map Viewer

Name: Trees

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The Urban Forestry location points represent Urban Forestry assets such as a tree, grow space, or a location in need of maintenance.

Copyright Text: DPW Urban Forestry Division

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

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

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: 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)
Type (type: esriFieldTypeString, alias: Type, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
Status (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
COND (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 9, nullable: true, editable: true, Coded Values: [critical: Critical], [dead: Dead], [fair: Fair], ... 4 more ...)
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)
Location (type: esriFieldTypeString, alias: Location, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
Active (type: esriFieldTypeDouble, alias: Active, SQL Type: sqlTypeOther, nullable: true, editable: true)
LifeCycle (type: esriFieldTypeDouble, alias: Life Cycle, SQL Type: sqlTypeOther, nullable: true, editable: true)
ID (type: esriFieldTypeDouble, alias: Treekeeper 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: Building Number, 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 Name, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
OnStr (type: esriFieldTypeString, alias: On Street, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
FromStr (type: esriFieldTypeString, alias: From Street, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
toStr (type: esriFieldTypeString, alias: To Street, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
Side (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [front: Front], [median: Median], [park: Park], ... 3 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: [abies balsamea: Abies balsamea], [acer buergerianum: Acer buergerianum], [acer campestre: Acer campestre], ... 290 more ...)
DBH (type: esriFieldTypeDouble, alias: Diameter Breast Height, SQL Type: sqlTypeOther, nullable: true, editable: true)
MT (type: esriFieldTypeString, alias: Maintenance1, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [plant tree: Plant Tree], [removal: Removal], [stump removal: Stump Removal], ... 2 more ...)
MT2 (type: esriFieldTypeString, alias: Maintenance2, SQL Type: sqlTypeOther, length: 11, nullable: true, editable: true, Coded Values: [none: None], [raise: Raise], [reduce: Reduce], ... 3 more ...)
GROWSPACE (type: esriFieldTypeString, alias: Grow Space, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [island: Island], [median: Median], [natural area: Natural Area], ... 4 more ...)
SPACESIZE (type: esriFieldTypeDouble, alias: Space Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
UTILITIES (type: esriFieldTypeString, alias: Utilities, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
LOCVAL (type: esriFieldTypeString, alias: Location Value, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [fair: Fair], [good: Good], [n/a: N/A], ... 1 more ...)
INSPECT (type: esriFieldTypeString, alias: INSPECT, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
HDSCAPEDAM (type: esriFieldTypeString, alias: Hardscape Damage, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true, Coded Values: [Y: Yes], [N: No])
KLIR (type: esriFieldTypeString, alias: KLIR, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true, Coded Values: [building: Building], [light: Light], [none needed: None needed], ... 4 more ...)
TRUNKS (type: esriFieldTypeDouble, alias: Trunk Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
OBSERVE (type: esriFieldTypeString, alias: Observed Problems, 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], ... 13 more ...)
LOCTYPE (type: esriFieldTypeString, alias: Location Type, SQL Type: sqlTypeOther, length: 17, nullable: true, editable: true, Coded Values: [borderline: Borderline], [park/public space: Park/Public Space], [street: Street])
AREA (type: esriFieldTypeString, alias: PublicWorks.RIC.veg_Tree.AREA, 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)
C_DIST (type: esriFieldTypeString, alias: Council District, SQL Type: sqlTypeOther, length: 1, nullable: true, editable: true)
PROBFAIL (type: esriFieldTypeString, alias: Fail Probability, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true, Coded Values: [extremely high: Extremely High], [high: High], [low: Low], ... 2 more ...)
DEFECT (type: esriFieldTypeString, alias: Defect, SQL Type: sqlTypeOther, length: 23, nullable: true, editable: true, Coded Values: [18 to 30 (45 to 75 cm): 18 to 30 (45 to 75 cm)], [6 to 18 (15 to 45 cm): 6 to 18 (15 to 45 cm)], [greater than 30 (75 cm): Greater than 30 (75 cm)], ... 2 more ...)
IMPACT (type: esriFieldTypeString, alias: Impact, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true, Coded Values: [constant: Constant], [frequent use: Frequent Use], [intermittent use: Intermittent Use], ... 2 more ...)
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, Coded Values: [belle of georgia: Belle of Georgia], [black tartarian: Black Tartarian], [bracken's brown beauty: Bracken's Brown Beauty], ... 29 more ...)
Inv_Date (type: esriFieldTypeDate, alias: Inventory Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
Inv_Time (type: esriFieldTypeString, alias: Inventory 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: Inspection Time, SQL Type: sqlTypeOther, length: 24, nullable: true, editable: true)
Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 254, nullable: true, editable: true)
CreatedBy (type: esriFieldTypeString, alias: Created By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
CreatedDate (type: esriFieldTypeDate, alias: Created Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
EditBy (type: esriFieldTypeString, alias: Edit By, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
EditDate (type: esriFieldTypeDate, alias: Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 3/8/2022 4:56:59 PM

Schema Last Edit Date: 3/8/2022 4:56:59 PM

Data Last Edit Date: 3/8/2022 4:56:59 PM

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