Name: ProdGeoDB.TRANSPORTATION.StructuresInventory_lines

Display Field: PrimaryName

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Regular visual inspections of structures are carried out every other year to assess current conditions and to provide data which is used by city staff to prioritize maintenance and replacement needs, and provide cost estimates for capital budgeting purposes. The City’s total inventory presently consists of 293 structures which include: bridges, culverts (1.8m span or greater), footbridges/ boardwalks, pedestrian tunnels, major retaining walls, noise walls and an overhead sign.

Copyright Text: Corporation of the City of London | Produced For: Enironmental & Engineering Services - Roads and Transportation/ Transportation Planning and Design | Produced by: Environmental & Engineering Services - Roads & Transportation/ Geomatics. | Based on data collected by AECOM Canada Ltd. (AECOM), 2013

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.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: 471762.17349999957
YMin: 4742505.529999999
XMax: 491164.50600000005
YMax: 4767506.992699999
Spatial Reference: 26917  (26917)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Subtype
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [0, 72, 161, 255]
Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: 2
  Label: Culvert
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [166, 144, 0, 255]
  Width: 1
• Value: 6
  Label: Noise Wall
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 13, 153, 255]
  Width: 1
• Value: 5
  Label: Overhead Sign
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [138, 0, 145, 255]
  Width: 1
• Value: 4
  Label: Retaining Wall
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [138, 0, 143, 255]
  Width: 1
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: Subtype

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• GIS_ID ( type: esriFieldTypeInteger, alias: GIS_ID )
• GIS_FeatureKey ( type: esriFieldTypeString, alias: Structure Inventory Key, length: 50 )
• Subtype ( type: esriFieldTypeSmallInteger, alias: Subtype )
• StructureTypeCode ( type: esriFieldTypeString, alias: Structure Type (code), length: 2 , Coded Values: [BR: BR] , [CU: CU] , [FB: FB] , ...4 more... )
• StructureTypeDescription ( type: esriFieldTypeString, alias: Structure Type (description), length: 50 , Coded Values: [Bridge: Bridge] , [Culvert (1.8m to 3m span): Culvert (1.8m to 3m span)] , [Footbridge/ Boardwalk: Footbridge/ Boardwalk] , ...4 more... )
• PrimaryName ( type: esriFieldTypeString, alias: Primary Name, length: 50 )
• Location ( type: esriFieldTypeString, alias: Location, length: 100 )
• HistoricWard ( type: esriFieldTypeString, alias: Historic Ward, length: 50 )
• Report ( type: esriFieldTypeString, alias: Report, length: 50 )
• Comments ( type: esriFieldTypeString, alias: Comments, length: 50 )
• LastEditor ( type: esriFieldTypeString, alias: Last Editor, length: 50 )
• LastEditDate ( type: esriFieldTypeDate, alias: Last Edit Date, length: 8 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )
• SHAPE.STLength() ( type: esriFieldTypeDouble, alias: SHAPE.STLength() )

Types:

ID: 2
Name: Culvert
Domains:
• StructureTypeCode:
  Inherited
• StructureTypeDescription:
  Inherited

---

ID: 4
Name: Retaining Wall
Domains:
• StructureTypeCode:
  Inherited
• StructureTypeDescription:
  Inherited

---

ID: 5
Name: Overhead Sign
Domains:
• StructureTypeCode:
  Inherited
• StructureTypeDescription:
  Inherited

---

ID: 6
Name: Noise Wall
Domains:
• StructureTypeCode:
  Inherited
• StructureTypeDescription:
  Inherited

---

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

  Iteminfo   Thumbnail   Metadata