View In:   ArcGIS Online Map Viewer

Name: Conduit

Display Field: route_name

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: The Conduit feature class is a linear feature class that can be used to track the placement of conduit which are used to house fiber cables. The Conduit feature class does not allow for the tracking of sub ducts or micro ducts or duct connectively typically seen in a blown fiber network. Sub duct tracking, duct connectivity and blown fiber infrastructure is supported using the Span feature class. The Conduit feature class can be used to track what fiber cables are in a given conduit.

Service Item Id: c52654c359a04654b2444d1e3c47c568

Copyright Text: 3-GIS

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 150000.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Supports Datum Transformation: true

Extent:

XMin: 555394.852899998
YMin: 4815800.326800004
XMax: 567013.252999999
YMax: 4825576.4106
Spatial Reference: 26917  (26917)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: inventory_status_code
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [225, 225, 225, 255]
Width: 2
Default Label: <all other values>
UniqueValueInfos:
• Value: Abandoned
  Label: Abandoned
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [225, 225, 225, 255]
  Width: 2
• Value: DesignComplete
  Label: Design Complete
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [225, 225, 225, 255]
  Width: 2
• Value: Installed
  Label: Installed
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [225, 225, 225, 255]
  Width: 2
• Value: InstalledAsBuilt
  Label: Installed, As-Built
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [225, 225, 225, 255]
  Width: 2
• Value: Planned
  Label: Planned
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [225, 225, 225, 255]
  Width: 2
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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: true
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: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: inventory_status_code

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• creationuser ( type: esriFieldTypeString, alias: Creation User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATIONUSER )
• datecreated ( type: esriFieldTypeDate, alias: Date Created, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• lastuser ( type: esriFieldTypeString, alias: Last User, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTUSER )
• datemodified ( type: esriFieldTypeDate, alias: Date Modified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEMODIFIED )
• route_name ( type: esriFieldTypeString, alias: Route Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: ROUTE_NAME )
• inventory_status_code ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 150, defaultValue: Planned, modelName: INVENTORY_STATUS_CODE , Coded Values: [Planned: Planned] , [Installed: Installed] , [Abandoned: Abandoned] )
• calculatedlength ( type: esriFieldTypeDouble, alias: Calculated Length (m), editable: true, nullable: true, defaultValue: null, modelName: CALCULATEDLENGTH )
• install_method ( type: esriFieldTypeString, alias: Installation Method, editable: true, nullable: true, length: 50, defaultValue: Underground, modelName: INSTALL_METHOD , Coded Values: [Aerial: Aerial] , [Underground: Underground] , [Bridge Span: Bridge Span] )
• from_structure ( type: esriFieldTypeString, alias: From Structure, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FROM_STRUCTURE )
• to_structure ( type: esriFieldTypeString, alias: To Structure, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TO_STRUCTURE )
• installationdate ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATIONDATE )
• manufacturer ( type: esriFieldTypeString, alias: Installation Contractor, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MANUFACTURER , Coded Values: [ACP: ACP] , [Acronym: Acronym] , [CCC: CCC] , ...4 more... )
• owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OWNER , Coded Values: [City of Guelph: City of Guelph] , [Leased - Bell: Leased - Bell] , [Leased - Rogers: Leased - Rogers] , ...2 more... )
• owner_contact_number ( type: esriFieldTypeString, alias: Cable Owner Contact Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: OWNER_CONTACT_NUMBER )
• comments ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• ipid ( type: esriFieldTypeString, alias: IPID, editable: true, nullable: true, length: 90, defaultValue: null, modelName: IPID )
• workorderid ( type: esriFieldTypeString, alias: Work Order ID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: WORKORDERID )
• id ( type: esriFieldTypeGUID, alias: ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ID )
• threegisid ( type: esriFieldTypeGUID, alias: 3-GIS ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: THREEGISID )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• edittrackinguser ( type: esriFieldTypeString, alias: EDITTRACKINGUSER, editable: false, nullable: true, length: 255, defaultValue: null, modelName: EDITTRACKINGUSER )
• edittrackingdate ( type: esriFieldTypeDate, alias: EDITTRACKINGDATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: EDITTRACKINGDATE )
• diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: 50, modelName: diameter , Coded Values: [25: 25mm (1")] , [50: 50mm (2")] , [100: 100mm (4")] , ...1 more... )
• Shape__Length ( type: esriFieldTypeDouble, alias: shape.STLength(), editable: false, nullable: true, defaultValue: null, modelName: shape.STLength(), required: true )
• level_begin ( type: esriFieldTypeInteger, alias: level_begin, editable: true, nullable: true, defaultValue: null, modelName: level_begin )
• level_end ( type: esriFieldTypeInteger, alias: level_end, editable: true, nullable: true, defaultValue: null, modelName: level_end )
• CreatedBy ( type: esriFieldTypeString, alias: CreatedBy, editable: false, nullable: true, length: 50, defaultValue: null, modelName: CreatedBy )
• CreatedDate ( type: esriFieldTypeDate, alias: CreatedDate, editable: false, nullable: true, length: 8, defaultValue: null, modelName: CreatedDate )

Types:

ID: Abandoned
Name: Abandoned
Domains:
• inventory_status_code:
  Inherited
• install_method:
  Inherited
• manufacturer:
  Inherited
• owner:
  Inherited
• diameter:
  Inherited
Templates:
• Name: Abandoned
  Description:
  Prototype:
  diameter: 50
  level_end: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  route_name: null
  inventory_status_code: Abandoned
  calculatedlength: null
  install_method: Underground
  from_structure: null
  to_structure: null
  installationdate: null
  manufacturer: null
  owner: null
  owner_contact_number: null
  comments: null
  ipid: null
  workorderid: null
  id: null
  threegisid: null
  level_begin: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: DesignComplete
Name: Design Complete
Domains:
• inventory_status_code:
  Inherited
• install_method:
  Inherited
• manufacturer:
  Inherited
• owner:
  Inherited
• diameter:
  Inherited
Templates:
• Name: DesignComplete
  Description:
  Prototype:
  diameter: 50
  level_end: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  route_name: null
  inventory_status_code: DesignComplete
  calculatedlength: null
  install_method: Underground
  from_structure: null
  to_structure: null
  installationdate: null
  manufacturer: null
  owner: null
  owner_contact_number: null
  comments: null
  ipid: null
  workorderid: null
  id: null
  threegisid: null
  level_begin: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Installed
Name: Installed
Domains:
• inventory_status_code:
  Inherited
• install_method:
  Inherited
• manufacturer:
  Inherited
• owner:
  Inherited
• diameter:
  Inherited
Templates:
• Name: Installed
  Description:
  Prototype:
  diameter: 50
  level_end: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  route_name: null
  inventory_status_code: Installed
  calculatedlength: null
  install_method: Underground
  from_structure: null
  to_structure: null
  installationdate: null
  manufacturer: null
  owner: null
  owner_contact_number: null
  comments: null
  ipid: null
  workorderid: null
  id: null
  threegisid: null
  level_begin: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: InstalledAsBuilt
Name: Installed, As-Built
Domains:
• inventory_status_code:
  Inherited
• install_method:
  Inherited
• manufacturer:
  Inherited
• owner:
  Inherited
• diameter:
  Inherited
Templates:
• Name: InstalledAsBuilt
  Description:
  Prototype:
  diameter: 50
  level_end: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  route_name: null
  inventory_status_code: InstalledAsBuilt
  calculatedlength: null
  install_method: Underground
  from_structure: null
  to_structure: null
  installationdate: null
  manufacturer: null
  owner: null
  owner_contact_number: null
  comments: null
  ipid: null
  workorderid: null
  id: null
  threegisid: null
  level_begin: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: Planned
Name: Planned
Domains:
• inventory_status_code:
  Inherited
• install_method:
  Inherited
• manufacturer:
  Inherited
• owner:
  Inherited
• diameter:
  Inherited
Templates:
• Name: Planned
  Description:
  Prototype:
  diameter: 50
  level_end: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  route_name: null
  inventory_status_code: Planned
  calculatedlength: null
  install_method: Underground
  from_structure: null
  to_structure: null
  installationdate: null
  manufacturer: null
  owner: null
  owner_contact_number: null
  comments: null
  ipid: null
  workorderid: null
  id: null
  threegisid: null
  level_begin: null
  
  Drawing Tool: esriFeatureEditToolLine

---

Relationships:

• fibercable (2) -- Related To: Fiber Cable (9)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: CreatedDate
• Creator Field: CreatedBy
• Edit Date Field: edittrackingdate
• Editor Field: edittrackinguser

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Analytic   Query Related Records   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata