View In:   ArcGIS Online Map Viewer

Name: Structure

Display Field: structure_name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: A container (handhole, vault, manhole, etc.) used to house Fiber Equipment.

Service Item Id: c52654c359a04654b2444d1e3c47c568

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 24000.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.841792101
YMin: 4815071.43289857
XMax: 567013.264340264
YMax: 4825576.50711153
Spatial Reference: 26917  (26917)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: subtypecode
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Default Label: <all other values>
UniqueValueInfos:
• Value: 2
  Label: Handwell - Joint Use
  Description: N/A
  Symbol:
  
• Value: 6
  Label: Handwell - Fibre Only
  Description: N/A
  Symbol:
  
• Value: 1
  Label: Maintenance Hole
  Description: N/A
  Symbol:
  
• Value: 5
  Label: Traffic Controller Cabinet
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Vault or Chamber
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Other
  Description: N/A
  Symbol:
  
• Value: 0
  Label: Unknown
  Description: N/A
  Symbol:
  
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: false
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: subtypecode

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 )
• clli ( type: esriFieldTypeString, alias: Structure ID, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CLLI )
• structure_name ( type: esriFieldTypeString, alias: Structure Name, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STRUCTURE_NAME )
• inventory_status_code ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 150, defaultValue: null, modelName: INVENTORY_STATUS_CODE , Coded Values: [Planned: Planned] , [Installed: Installed] , [Abandoned: Abandoned] )
• subtypecode ( type: esriFieldTypeInteger, alias: Subtype Code, editable: true, nullable: true, defaultValue: 0, modelName: SUBTYPECODE )
• structure_size ( type: esriFieldTypeString, alias: Structure Size, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STRUCTURE_SIZE , Coded Values: [1: Small] , [2: Medium] , [3: Large] , ...1 more... )
• structure_use ( type: esriFieldTypeString, alias: Structure Use, editable: true, nullable: true, length: 255, defaultValue: null, modelName: STRUCTURE_USE , Coded Values: [Slack: Slack Loop] , [Ground: Ground Point] , [Splice: Splice] )
• material ( type: esriFieldTypeInteger, alias: Material, editable: true, nullable: true, defaultValue: null, modelName: MATERIAL , Coded Values: [1: Wood] , [3: Concrete] , [4: Metal] , ...2 more... )
• owner ( type: esriFieldTypeString, alias: Owner, editable: true, nullable: true, length: 255, defaultValue: City of Guelph, 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 )
• installationdate ( type: esriFieldTypeDate, alias: Installation Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATIONDATE )
• manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MANUFACTURER , Coded Values: [ACP: ACP] , [Acronym: Acronym] , [CCC: CCC] , ...4 more... )
• modelnumber ( type: esriFieldTypeString, alias: Model Number, editable: true, nullable: true, length: 100, defaultValue: null, modelName: MODELNUMBER )
• 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 )
• id ( type: esriFieldTypeGUID, alias: ID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: ID )
• rotation ( type: esriFieldTypeDouble, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: null, modelName: ROTATION )
• 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 )
• contract_id ( type: esriFieldTypeString, alias: Contract Number, editable: true, nullable: true, length: 20, defaultValue: null, modelName: contract_id )
• 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: 2
Name: Handwell - Joint Use
Domains:
• inventory_status_code:
  Inherited
• structure_size:
  Coded Values: [17x30x24in (432x762x610mm): 17x30x24in (432x762x610mm)] , [17x30x30in (432x762x762mm): 17x30x30in (432x762x762mm)] , [24x36x24in (610x914x610mm): 24x36x24in (610x914x610mm)] , ...6 more...
• structure_use:
  Inherited
• material:
  Inherited
• owner:
  Inherited
• manufacturer:
  Inherited
Templates:
• Name: Handhole
  Description:
  Prototype:
  inventory_status_code: Installed
  contract_id: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  subtypecode: 2
  structure_size: null
  structure_use: null
  material: null
  owner: City of Guelph
  owner_contact_number: null
  installationdate: null
  manufacturer: null
  modelnumber: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: Handwell - Fibre Only
Domains:
• inventory_status_code:
  Inherited
• structure_size:
  Coded Values: [17x30x24in (432x762x610mm): 17x30x24in (432x762x610mm)] , [17x30x30in (432x762x762mm): 17x30x30in (432x762x762mm)] , [24x36x24in (610x914x610mm): 24x36x24in (610x914x610mm)] , ...6 more...
• structure_use:
  Inherited
• material:
  Inherited
• owner:
  Inherited
• manufacturer:
  Inherited
Templates:
• Name: Handwell - Fibre Only
  Description:
  Prototype:
  threegisid: null
  contract_id: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  inventory_status_code: Planned
  subtypecode: 6
  structure_size: null
  structure_use: null
  material: null
  owner: City of Guelph
  owner_contact_number: null
  installationdate: null
  manufacturer: null
  modelnumber: null
  comments: null
  ipid: null
  id: null
  rotation: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 1
Name: Maintenance Hole
Domains:
• inventory_status_code:
  Inherited
• structure_size:
  Coded Values: [600mm: 600mm] , [900mm: 900mm] , [1000mm: 1000mm] , ...20 more...
• structure_use:
  Inherited
• material:
  Inherited
• owner:
  Inherited
• manufacturer:
  Inherited
Templates:
• Name: Manhole
  Description:
  Prototype:
  inventory_status_code: Installed
  contract_id: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  subtypecode: 1
  structure_size: null
  structure_use: null
  material: null
  owner: City of Guelph
  owner_contact_number: null
  installationdate: null
  manufacturer: null
  modelnumber: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: Traffic Cabinet
Domains:
• inventory_status_code:
  Inherited
• structure_size:
  Coded Values: [On-Ground Standard: On-Ground Standard] , [Pole Mounted: Pole Mounted] , [Unknown: Unknown]
• structure_use:
  Inherited
• material:
  Inherited
• owner:
  Inherited
• manufacturer:
  Inherited
Templates:
• Name: Cabinet
  Description:
  Prototype:
  inventory_status_code: Installed
  contract_id: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  subtypecode: 5
  structure_size: null
  structure_use: null
  material: null
  owner: City of Guelph
  owner_contact_number: null
  installationdate: null
  manufacturer: null
  modelnumber: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Vault or Chamber
Domains:
• inventory_status_code:
  Inherited
• structure_size:
  Coded Values: [N/A: N/A] , [Unknown: Unknown]
• structure_use:
  Inherited
• material:
  Inherited
• owner:
  Inherited
• manufacturer:
  Inherited
Templates:
• Name: Vault
  Description:
  Prototype:
  inventory_status_code: Installed
  contract_id: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  subtypecode: 3
  structure_size: Unknown
  structure_use: null
  material: null
  owner: City of Guelph
  owner_contact_number: null
  installationdate: null
  manufacturer: null
  modelnumber: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Other
Domains:
• inventory_status_code:
  Inherited
• structure_size:
  Coded Values: [N/A: N/A] , [Unknown: Unknown]
• structure_use:
  Inherited
• material:
  Inherited
• owner:
  Inherited
• manufacturer:
  Inherited
Templates:
• Name: Pedestal
  Description:
  Prototype:
  inventory_status_code: Installed
  contract_id: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  subtypecode: 4
  structure_size: null
  structure_use: null
  material: null
  owner: City of Guelph
  owner_contact_number: null
  installationdate: null
  manufacturer: null
  modelnumber: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 0
Name: Unknown
Domains:
• inventory_status_code:
  Inherited
• structure_size:
  Coded Values: [N/A: N/A] , [Unknown: Unknown]
• structure_use:
  Inherited
• material:
  Inherited
• owner:
  Inherited
• manufacturer:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  inventory_status_code: Installed
  contract_id: null
  creationuser: null
  datecreated: null
  lastuser: null
  datemodified: null
  clli: null
  structure_name: null
  subtypecode: 0
  structure_size: null
  structure_use: null
  material: null
  owner: City of Guelph
  owner_contact_number: null
  installationdate: null
  manufacturer: null
  modelnumber: null
  comments: null
  ipid: null
  id: null
  rotation: null
  threegisid: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Relationships:

• spliceclosure (0) -- Related To: Splice Closure (1)

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