Name: ProdGeoDB.TRANSPORTATION.StructuresInventory

Display Field: PrimaryName

Type: Feature Layer

Geometry Type: esriGeometryPoint

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 254 structures which include: bridges, culverts (1.8m span or greater), footbridges/ boardwalks, pedestrian tunnels, major retaining 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), 2011

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: 468168.32739999983
YMin: 4741824.8473000005
XMax: 491143.03390000015
YMax: 4767500.4339000005
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: esriSMSCircle
Color: [43, 0, 161, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: 1
  Label: Bridge
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 117, 133, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 2
  Label: Culvert
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [49, 0, 133, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 3
  Label: Footbridge/ Boardwalk
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 85, 145, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 6
  Label: Overhead Sign
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [0, 2, 145, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 4
  Label: Pedestrian Tunnel
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [140, 0, 21, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 5
  Label: Retaining Wall
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [143, 0, 5, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 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 )
• StructureTypeDescription ( type: esriFieldTypeString, alias: Structure Type (description), length: 50 )
• 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 )

Types:

ID: 1
Name: Bridge
Domains:
• StructureTypeCode:
  Coded Values: [BR: BR] , [CU: CU] , [FB: FB] , ...4 more...
• StructureTypeDescription:
  Coded Values: [Bridge: Bridge] , [Culvert (1.8m to 3m span): Culvert (1.8m to 3m span)] , [Footbridge/ Boardwalk: Footbridge/ Boardwalk] , ...4 more...

---

ID: 2
Name: Culvert
Domains:
• StructureTypeCode:
  Coded Values: [BR: BR] , [CU: CU] , [FB: FB] , ...4 more...
• StructureTypeDescription:
  Coded Values: [Bridge: Bridge] , [Culvert (1.8m to 3m span): Culvert (1.8m to 3m span)] , [Footbridge/ Boardwalk: Footbridge/ Boardwalk] , ...4 more...

---

ID: 3
Name: Footbridge/ Boardwalk
Domains:
• StructureTypeCode:
  Coded Values: [BR: BR] , [CU: CU] , [FB: FB] , ...4 more...
• StructureTypeDescription:
  Coded Values: [Bridge: Bridge] , [Culvert (1.8m to 3m span): Culvert (1.8m to 3m span)] , [Footbridge/ Boardwalk: Footbridge/ Boardwalk] , ...4 more...

---

ID: 4
Name: Pedestrian Tunnel
Domains:
• StructureTypeCode:
  Coded Values: [BR: BR] , [CU: CU] , [FB: FB] , ...4 more...
• StructureTypeDescription:
  Coded Values: [Bridge: Bridge] , [Culvert (1.8m to 3m span): Culvert (1.8m to 3m span)] , [Footbridge/ Boardwalk: Footbridge/ Boardwalk] , ...4 more...

---

ID: 5
Name: Retaining Wall
Domains:
• StructureTypeCode:
  Coded Values: [BR: BR] , [CU: CU] , [FB: FB] , ...4 more...
• StructureTypeDescription:
  Coded Values: [Bridge: Bridge] , [Culvert (1.8m to 3m span): Culvert (1.8m to 3m span)] , [Footbridge/ Boardwalk: Footbridge/ Boardwalk] , ...4 more...

---

ID: 6
Name: Overhead Sign
Domains:
• StructureTypeCode:
  Coded Values: [BR: BR] , [CU: CU] , [FB: FB] , ...4 more...
• StructureTypeDescription:
  Coded Values: [Bridge: Bridge] , [Culvert (1.8m to 3m span): Culvert (1.8m to 3m span)] , [Footbridge/ Boardwalk: Footbridge/ Boardwalk] , ...4 more...

---

ID: 7
Name: Noise Wall
Domains:
• StructureTypeCode:
  Coded Values: [BR: BR] , [CU: CU] , [FB: FB] , ...4 more...
• StructureTypeDescription:
  Coded Values: [Bridge: Bridge] , [Culvert (1.8m to 3m span): Culvert (1.8m to 3m span)] , [Footbridge/ Boardwalk: Footbridge/ Boardwalk] , ...4 more...

---

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

  Iteminfo   Thumbnail   Metadata