Name: Status Active

Display Field: SpeciesCode

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: The City of London tree inventory was undertaken in the summer of 2002 and is regularly updated to reflect spring and fall tree planting programs as well as the removal of dead or hazardous trees. The data assists the City's Forestry Group in managing its year-round maintenance program as well as planning what tree species to plant and where. Trunks are measured at the standard diameter height of 1.4 meters (4.5 feet) above the ground. Leaning trees, multi-stemmed trees and other abnormal conditions are measured using professional appraisal techniques. For London residents a practical use of the trunk measurement is being able to assess tree root impacts for any planned construction. Every effort should be made to stay 30 cm away from the trunk for each 3 cm of trunk diameter.

Copyright Text: Corporation of the City of London | Produced For: EES Transportatoin & Roadside Operations c/o Information & Technology Services | Produced by: Environmental & Engineering Services - Roads & Transportation/ Geomatics

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 8000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: false

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 464169.5770679428
YMin: 4741672.9964000005
XMax: 490941.4708999996
YMax: 4768252.601
Spatial Reference: 26917  (26917)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Active Tree
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 0, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
• Value: 2
  Label: Commemorative Tree
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 0, 0, 255]
  Size: 10.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 0
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: true
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: Status

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GIS_ID ( type: esriFieldTypeInteger, alias: Unique Tree ID )
• Status ( type: esriFieldTypeSmallInteger, alias: Status (subtype) )
• SpeciesCode ( type: esriFieldTypeString, alias: Species Code, length: 6 , Coded Values: [ALGR: ALGR] , [ALUE: ALUE] , [AMMA: AMMA] , ...202 more... )
• Diameter ( type: esriFieldTypeSmallInteger, alias: Diameter (cm) )
• Condition ( type: esriFieldTypeString, alias: Condition, length: 50 , Coded Values: [Dead: Dead] , [Excellent: Excellent] , [Fair: Fair] , ...5 more... )
• PlantedBy ( type: esriFieldTypeString, alias: Planted By, length: 50 )
• DatePlanted ( type: esriFieldTypeDate, alias: Date Planted, length: 8 )
• Remarks ( type: esriFieldTypeString, alias: Remarks, length: 255 )
• LastEditor ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• LastEditDate ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• PlantedHeight ( type: esriFieldTypeSmallInteger, alias: Planted Height (cm) )
• UnderObservation ( type: esriFieldTypeString, alias: Under Observation, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• WarrantyStatus ( type: esriFieldTypeString, alias: Warranty Status, length: 20 , Coded Values: [Year 1: Year 1] , [Year 2: Year 2] , [None: None] )
• PlantingContract ( type: esriFieldTypeString, alias: Planting Contract, length: 20 , Coded Values: [No Contract: No Contract] , [2020s: 2020s] , [2020f: 2020f] , ...10 more... )
• WarrantyInspection ( type: esriFieldTypeString, alias: Warranty Inspection, length: 5 , Coded Values: [Y: To Be Inspected] , [YP: Inspected - Passed] , [YF: Inspected - Failed] )
• Flag1 ( type: esriFieldTypeString, alias: Flag1, length: 20 )
• Flag2 ( type: esriFieldTypeString, alias: Flag2, length: 20 )
• Street ( type: esriFieldTypeString, alias: Street, length: 50 )
• Postal ( type: esriFieldTypeString, alias: Postal Code, length: 7 )
• Mail ( type: esriFieldTypeString, alias: Mail, length: 5 )
• AddressExtra ( type: esriFieldTypeString, alias: AddressExtra, length: 50 )
• St_Num ( type: esriFieldTypeString, alias: St Num, length: 10 )
• On_Street ( type: esriFieldTypeString, alias: On Street, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 25 , Coded Values: [Boulevard: Boulevard] , [Park: Park] , [Island: Island] , ...4 more... )
• Botanical ( type: esriFieldTypeString, alias: Botanical Name, length: 50 , Coded Values: [---: ---] , [Abies balsamea: Abies balsamea] , [Abies concolor: Abies concolor] , ...202 more... )
• CommonName ( type: esriFieldTypeString, alias: Common Name, length: 50 , Coded Values: [---: ---] , [Alder, European: Alder, European] , [Alder, Grey: Alder, Grey] , ...216 more... )
• Insp_Date ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• Insp_Notes ( type: esriFieldTypeString, alias: Inspection Notes, length: 100 )
• Status_OLD ( type: esriFieldTypeSmallInteger, alias: Status_OLD )
• Migration_Notes ( type: esriFieldTypeString, alias: Migration Notes, length: 255 )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, length: 50 )
• CreatedOn ( type: esriFieldTypeDate, alias: CreatedOn, length: 8 )
• WarrantyState ( type: esriFieldTypeString, alias: WarrantyState, length: 50 , Coded Values: [None: None] , [Year 1: Year 1] , [Year 1 - To Be Inspected: Year 1 - To Be Inspected] , ...9 more... )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )

Types:

ID: 1
Name: Active
Domains:
• Condition:
  Inherited
• UnderObservation:
  Inherited
• WarrantyStatus:
  Inherited
• WarrantyInspection:
  Inherited
• Location:
  Inherited

---

ID: 2
Name: Commemorative
Domains:
• SpeciesCode:
  Inherited
• Condition:
  Inherited
• UnderObservation:
  Inherited
• WarrantyStatus:
  Inherited
• WarrantyInspection:
  Inherited

---

ID: 3
Name: Removed
Domains:
• SpeciesCode:
  Inherited
• Condition:
  Inherited
• UnderObservation:
  Inherited
• WarrantyStatus:
  Inherited
• WarrantyInspection:
  Inherited

---

ID: 4
Name: Future Columnar
Domains:
• SpeciesCode:
  Inherited
• Condition:
  Inherited
• UnderObservation:
  Inherited
• WarrantyStatus:
  Inherited
• WarrantyInspection:
  Inherited

---

ID: 6
Name: Future Large
Domains:
• SpeciesCode:
  Inherited
• Condition:
  Inherited
• UnderObservation:
  Inherited
• WarrantyStatus:
  Inherited
• WarrantyInspection:
  Inherited

---

ID: 7
Name: Future Medium
Domains:
• SpeciesCode:
  Inherited
• Condition:
  Inherited
• UnderObservation:
  Inherited
• WarrantyStatus:
  Inherited
• WarrantyInspection:
  Inherited

---

ID: 8
Name: Future On Hold
Domains:
• SpeciesCode:
  Inherited
• Condition:
  Inherited
• UnderObservation:
  Inherited
• WarrantyStatus:
  Inherited
• WarrantyInspection:
  Inherited

---

ID: 5
Name: Future Small
Domains:
• SpeciesCode:
  Inherited
• Condition:
  Inherited
• UnderObservation:
  Inherited
• WarrantyStatus:
  Inherited
• WarrantyInspection:
  Inherited
• Location:
  Inherited

---

Relationships:

• GeoDbRoadOps.FORESTRY.TreeInspections (1) -- Related To: ProdGeoDB.FORESTRY.TreeInspections (2)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata