Name: Tree Inventory

Display Field: GeoDbRoadOps.FORESTRY.Trees.CommonName

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: false

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:
Simple Renderer:
Symbol:
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: false
Supports OrderBy: false
Supports Distinct: false
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: false
Supports Having Clause: false
Supports Count Distinct: false
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: false
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: GeoDbRoadOps.FORESTRY.Trees.Status

Fields:

• GeoDbRoadOps.FORESTRY.Trees.OBJECTID ( type: esriFieldTypeOID, alias: GeoDbRoadOps.FORESTRY.Trees.OBJECTID )
• GeoDbRoadOps.FORESTRY.Trees.GIS_ID ( type: esriFieldTypeInteger, alias: Unique Tree ID )
• GeoDbRoadOps.FORESTRY.Trees.Status ( type: esriFieldTypeSmallInteger, alias: Status )
• GeoDbRoadOps.FORESTRY.Trees.SpeciesCode ( type: esriFieldTypeString, alias: Species Code, length: 6 , Coded Values: [ALGR: ALGR] , [ALUE: ALUE] , [AMMA: AMMA] , ...202 more... )
• GeoDbRoadOps.FORESTRY.Trees.Diameter ( type: esriFieldTypeSmallInteger, alias: Diameter (cm) )
• GeoDbRoadOps.FORESTRY.Trees.PlantedHeight ( type: esriFieldTypeSmallInteger, alias: Planted Height (cm) )
• GeoDbRoadOps.FORESTRY.Trees.Condition ( type: esriFieldTypeString, alias: Condition, length: 50 , Coded Values: [Dead: Dead] , [Excellent: Excellent] , [Fair: Fair] , ...5 more... )
• GeoDbRoadOps.FORESTRY.Trees.PlantedBy ( type: esriFieldTypeString, alias: Planted By, length: 50 )
• GeoDbRoadOps.FORESTRY.Trees.DatePlanted ( type: esriFieldTypeDate, alias: Date Planted, length: 8 )
• GeoDbRoadOps.FORESTRY.Trees.Remarks ( type: esriFieldTypeString, alias: Remarks, length: 255 )
• GeoDbRoadOps.FORESTRY.Trees.LastEditor ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• GeoDbRoadOps.FORESTRY.Trees.LastEditDate ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• GeoDbRoadOps.FORESTRY.Trees.UnderObservation ( type: esriFieldTypeString, alias: Under Observation, length: 1 , Coded Values: [Y: Yes] , [N: No] )
• GeoDbRoadOps.FORESTRY.Trees.WarrantyStatus ( type: esriFieldTypeString, alias: Warranty Status, length: 20 , Coded Values: [Year 1: Year 1] , [Year 2: Year 2] , [None: None] )
• GeoDbRoadOps.FORESTRY.Trees.PlantingContract ( type: esriFieldTypeString, alias: Planting Contract, length: 20 , Coded Values: [No Contract: No Contract] , [2020s: 2020s] , [2020f: 2020f] , ...10 more... )
• GeoDbRoadOps.FORESTRY.Trees.WarrantyInspection ( type: esriFieldTypeString, alias: Warranty Inspection, length: 5 , Coded Values: [Y: To Be Inspected] , [YP: Inspected - Passed] , [YF: Inspected - Failed] )
• GeoDbRoadOps.FORESTRY.Trees.Flag1 ( type: esriFieldTypeString, alias: Flag1, length: 20 )
• GeoDbRoadOps.FORESTRY.Trees.Flag2 ( type: esriFieldTypeString, alias: Flag2, length: 20 )
• GeoDbRoadOps.FORESTRY.Trees.St_Num ( type: esriFieldTypeString, alias: St Num, length: 10 )
• GeoDbRoadOps.FORESTRY.Trees.Street ( type: esriFieldTypeString, alias: GeoDbRoadOps.FORESTRY.Trees.Street, length: 50 )
• GeoDbRoadOps.FORESTRY.Trees.On_Street ( type: esriFieldTypeString, alias: On Street, length: 50 )
• GeoDbRoadOps.FORESTRY.Trees.Postal ( type: esriFieldTypeString, alias: Postal Code, length: 7 )
• GeoDbRoadOps.FORESTRY.Trees.Mail ( type: esriFieldTypeString, alias: GeoDbRoadOps.FORESTRY.Trees.Mail, length: 5 )
• GeoDbRoadOps.FORESTRY.Trees.Location ( type: esriFieldTypeString, alias: Location, length: 25 , Coded Values: [Boulevard: Boulevard] , [Park: Park] , [Island: Island] , ...4 more... )
• GeoDbRoadOps.FORESTRY.Trees.AddressExtra ( type: esriFieldTypeString, alias: Address Extra, length: 50 )
• GeoDbRoadOps.FORESTRY.Trees.Botanical ( type: esriFieldTypeString, alias: Botanical Name, length: 50 , Coded Values: [---: ---] , [Abies balsamea: Abies balsamea] , [Abies concolor: Abies concolor] , ...202 more... )
• GeoDbRoadOps.FORESTRY.Trees.CommonName ( type: esriFieldTypeString, alias: Common Name, length: 50 , Coded Values: [---: ---] , [Alder, European: Alder, European] , [Alder, Grey: Alder, Grey] , ...216 more... )
• GeoDbRoadOps.FORESTRY.Trees.Insp_Date ( type: esriFieldTypeDate, alias: Inspection Date, length: 8 )
• GeoDbRoadOps.FORESTRY.Trees.Insp_Notes ( type: esriFieldTypeString, alias: Inspection Notes, length: 100 )
• GeoDbRoadOps.FORESTRY.Trees.Status_OLD ( type: esriFieldTypeSmallInteger, alias: GeoDbRoadOps.FORESTRY.Trees.Status_OLD )
• GeoDbRoadOps.FORESTRY.Trees.Migration_Notes ( type: esriFieldTypeString, alias: Migration Notes, length: 255 )
• GeoDbRoadOps.FORESTRY.Trees.CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, length: 50 )
• GeoDbRoadOps.FORESTRY.Trees.CreatedOn ( type: esriFieldTypeDate, alias: CreatedOn, length: 8 )
• GeoDbRoadOps.FORESTRY.Trees.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... )
• GeoDbRoadOps.FORESTRY.Trees.GlobalID ( type: esriFieldTypeGlobalID, alias: GeoDbRoadOps.FORESTRY.Trees.GlobalID, length: 38 )
• GeoDbRoadOps.FORESTRY.Trees.Shape ( type: esriFieldTypeGeometry, alias: GeoDbRoadOps.FORESTRY.Trees.Shape )
• GeoDbRoadOps.FORESTRY.TreeSpecies.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• GeoDbRoadOps.FORESTRY.TreeSpecies.SpeciesCode ( type: esriFieldTypeString, alias: Species Code, length: 4 , Coded Values: [ALGR: ALGR] , [ALUE: ALUE] , [AMMA: AMMA] , ...202 more... )
• GeoDbRoadOps.FORESTRY.TreeSpecies.SpeciesType ( type: esriFieldTypeString, alias: Species Type, length: 255 , Coded Values: [---: ---] , [Alternate leaved: Alternate leaved] , [American: American] , ...89 more... )
• GeoDbRoadOps.FORESTRY.TreeSpecies.SpeciesGroup ( type: esriFieldTypeString, alias: Species Group, length: 100 , Coded Values: [---: ---] , [Alder: Alder] , [Amur: Amur] , ...86 more... )
• GeoDbRoadOps.FORESTRY.TreeSpecies.CommonName ( type: esriFieldTypeString, alias: Common Name, length: 100 )
• GeoDbRoadOps.FORESTRY.TreeSpecies.LatinName ( type: esriFieldTypeString, alias: Latin Name, length: 100 , Coded Values: [---: ---] , [Abies balsamea: Abies balsamea] , [Abies concolor: Abies concolor] , ...202 more... )
• GeoDbRoadOps.FORESTRY.TreeSpecies.CommonUse ( type: esriFieldTypeSmallInteger, alias: GeoDbRoadOps.FORESTRY.TreeSpecies.CommonUse )
• GeoDbRoadOps.FORESTRY.TreeSpecies.GlobalID ( type: esriFieldTypeGUID, alias: GeoDbRoadOps.FORESTRY.TreeSpecies.GlobalID, length: 38 )
• GeoDbRoadOps.FORESTRY.TreeSpecies.LastEditor ( type: esriFieldTypeString, alias: LastEditor, length: 50 )
• GeoDbRoadOps.FORESTRY.TreeSpecies.LastEditDate ( type: esriFieldTypeDate, alias: LastEditDate, length: 8 )
• GeoDbRoadOps.FORESTRY.TreeInspections.OBJECTID ( type: esriFieldTypeInteger, alias: OBJECTID )
• GeoDbRoadOps.FORESTRY.TreeInspections.DateObserved ( type: esriFieldTypeDate, alias: Date Observed, length: 8 )
• GeoDbRoadOps.FORESTRY.TreeInspections.Inspector ( type: esriFieldTypeString, alias: Inspector, length: 50 )
• GeoDbRoadOps.FORESTRY.TreeInspections.Remarks ( type: esriFieldTypeString, alias: Remarks, length: 1073741822 )
• GeoDbRoadOps.FORESTRY.TreeInspections.Type ( type: esriFieldTypeString, alias: Type, length: 40 , Coded Values: [Inspection: Inspection] , [Observation: Observation] )
• GeoDbRoadOps.FORESTRY.TreeInspections.TreeGIS_ID ( type: esriFieldTypeInteger, alias: TreeGIS_ID )
• GeoDbRoadOps.FORESTRY.TreeInspections.TreeObjectId ( type: esriFieldTypeInteger, alias: TreeObjectId )
• GeoDbRoadOps.FORESTRY.TreeInspections.GlobalID ( type: esriFieldTypeGUID, alias: GlobalID, length: 38 )
• GeoDbRoadOps.FORESTRY.TreeInspections.REL_GLOBALID ( type: esriFieldTypeGUID, alias: REL_GLOBALID, length: 38 )

Types:

ID: 1
Name: Active
Domains:
• GeoDbRoadOps.FORESTRY.Trees.Condition:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.UnderObservation:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyStatus:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyInspection:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.Location:
  Inherited

---

ID: 2
Name: Commemorative
Domains:
• GeoDbRoadOps.FORESTRY.Trees.SpeciesCode:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.Condition:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.UnderObservation:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyStatus:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyInspection:
  Inherited
• GeoDbRoadOps.FORESTRY.TreeSpecies.SpeciesCode:
  Inherited

---

ID: 3
Name: Removed
Domains:
• GeoDbRoadOps.FORESTRY.Trees.SpeciesCode:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.Condition:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.UnderObservation:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyStatus:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyInspection:
  Inherited
• GeoDbRoadOps.FORESTRY.TreeSpecies.SpeciesCode:
  Inherited

---

ID: 4
Name: Future Columnar
Domains:
• GeoDbRoadOps.FORESTRY.Trees.SpeciesCode:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.Condition:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.UnderObservation:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyStatus:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyInspection:
  Inherited
• GeoDbRoadOps.FORESTRY.TreeSpecies.SpeciesCode:
  Inherited

---

ID: 6
Name: Future Large
Domains:
• GeoDbRoadOps.FORESTRY.Trees.SpeciesCode:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.Condition:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.UnderObservation:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyStatus:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyInspection:
  Inherited
• GeoDbRoadOps.FORESTRY.TreeSpecies.SpeciesCode:
  Inherited

---

ID: 7
Name: Future Medium
Domains:
• GeoDbRoadOps.FORESTRY.Trees.SpeciesCode:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.Condition:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.UnderObservation:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyStatus:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyInspection:
  Inherited
• GeoDbRoadOps.FORESTRY.TreeSpecies.SpeciesCode:
  Inherited

---

ID: 8
Name: Future On Hold
Domains:
• GeoDbRoadOps.FORESTRY.Trees.SpeciesCode:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.Condition:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.UnderObservation:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyStatus:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyInspection:
  Inherited
• GeoDbRoadOps.FORESTRY.TreeSpecies.SpeciesCode:
  Inherited

---

ID: 5
Name: Future Small
Domains:
• GeoDbRoadOps.FORESTRY.Trees.SpeciesCode:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.Condition:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.UnderObservation:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyStatus:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.WarrantyInspection:
  Inherited
• GeoDbRoadOps.FORESTRY.Trees.Location:
  Inherited
• GeoDbRoadOps.FORESTRY.TreeSpecies.SpeciesCode:
  Inherited

---

Relationships:

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

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

  Iteminfo   Thumbnail   Metadata