View In:   ArcGIS Online Map Viewer

Name: Underground Structure

Display Field: OBJECTID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 2500.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: false

Supports Datum Transformation: true

Extent:

XMin: 14002.727
YMin: 5535963.8507
XMax: 31506.949400000303
YMax: 5550793.8169
Spatial Reference: 3779  (3779)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPECD
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
N/A
Default Label: null
UniqueValueInfos:
• Value: 1
  Label: Vault
  Description:
  Symbol:
  
• Value: 2
  Label: Enclosure
  Description:
  Symbol:
  
• Value: 7
  Label: Enclosure
  Description:
  Symbol:
  
• Value: 3
  Label: URD Handhole
  Description:
  Symbol:
  
• Value: 4
  Label: Switchgear - Padmount
  Description:
  Symbol:
  
• Value: 5
  Label: Switchgear - Submersible
  Description:
  Symbol:
  
• Value: 6
  Label: Pad
  Description:
  Symbol:
  
• Value: 8
  Label: Pedestal
  Description:
  Symbol:
  
• Value: 11
  Label: Padmount Fiber
  Description:
  Symbol:
  
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: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: SUBTYPECD

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: ObjectID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLATIONDATE )
• FIELDVERIFY ( type: esriFieldTypeString, alias: FieldVerify?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FieldVerify , Coded Values: [0: No] , [1: Yes] )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• CREATIONUSER ( type: esriFieldTypeString, alias: CreationUser, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CREATIONUSER )
• DATECREATED ( type: esriFieldTypeDate, alias: DateCreated, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• LASTUSER ( type: esriFieldTypeString, alias: LastEditUser, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LastUser )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: LastEditDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateModified )
• SYMBOLROTATION ( type: esriFieldTypeSingle, alias: SymbolRotation, editable: true, nullable: true, defaultValue: null, modelName: SYMBOLROTATION )
• GPSDATE ( type: esriFieldTypeDate, alias: GPSDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: GPSDATE )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: SubtypeCode, editable: true, nullable: true, defaultValue: 1, modelName: SubtypeCD )
• OWNERSHIP ( type: esriFieldTypeString, alias: FeatureOwnedBy, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Ownership )
• COMPATIBLEUNITID ( type: esriFieldTypeString, alias: CompatibleUnitID, editable: true, nullable: true, length: 5, defaultValue: null, modelName: COMPATIBLEUNITID , Coded Values: [1: Concrete] , [2: Steel] , [201: Switch PADMNT 14.4kV PMH3] , ...15 more... )
• STRUCTUREOBJECTID ( type: esriFieldTypeInteger, alias: STRUCTUREOBJECTID, editable: true, nullable: true, defaultValue: null, modelName: STRUCTUREOBJECTID )
• DEVICENUMBER ( type: esriFieldTypeString, alias: DeviceNumber, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LocationNumber )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MANUFACTURER )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MATERIAL )
• MODEL ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MODEL )
• STRUCTURESIZE ( type: esriFieldTypeString, alias: StructureSize, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STRUCTURESIZE )
• STRUCTURETYPE ( type: esriFieldTypeString, alias: StructureType, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STRUCTURETYPE )
• FAULTINDICATOR ( type: esriFieldTypeString, alias: FaultIndicator?, editable: true, nullable: true, length: 5, defaultValue: null, modelName: FaultIndicator )
• FEATURE_STATUS ( type: esriFieldTypeString, alias: FEATURE_STATUS, editable: true, nullable: false, length: 10, defaultValue: Existing, modelName: FEATURE_STATUS , Coded Values: [Existing: Existing Feature] , [New: New Feature] , [Proposed: Proposed Feature] , ...2 more... )
• STREETLIGHT_FACILITY ( type: esriFieldTypeString, alias: STREETLIGHT_FACILITY, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STREETLIGHT_FACILITY , Coded Values: [STLT-REN: Streetlights-rental lights] , [LT-OTHER: Lights - Other] , [STLT-MED: Streetlights-in Medicine Hat (529760)] , ...8 more... )
• HYPERLINK ( type: esriFieldTypeString, alias: HYPERLINK, editable: true, nullable: true, length: 100, defaultValue: null, modelName: HYPERLINK )
• HYPERLINK_PGDB ( type: esriFieldTypeString, alias: HYPERLINK_PGDB, editable: true, nullable: true, length: 50, defaultValue: null, modelName: HYPERLINK_PGDB )
• REPLACED_DATE_MM_DD_YYYY ( type: esriFieldTypeDate, alias: REPLACED_DATE_MM_DD_YYYY, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPLACED_DATE_MM_DD_YYYY )
• CADTYPE ( type: esriFieldTypeString, alias: CADType, editable: true, nullable: true, length: 50, defaultValue: INSERT, modelName: CADTYPE )
• REFNAME ( type: esriFieldTypeString, alias: RefName, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REFNAME , Coded Values: [swgr padmount: Switchgear Padmount] , [swgr sub: Switchgear Sumbersible] , [enclosure padmount: Enclosure Padmount] )
• CADANGLE ( type: esriFieldTypeDouble, alias: CADAngle, editable: true, nullable: true, defaultValue: null, modelName: CADANGLE )
• RULEID ( type: esriFieldTypeInteger, alias: RULEID, editable: true, nullable: true, defaultValue: null, modelName: RULEID , Coded Values: [1: Vault] , [2: Padmount Junction Box] , [3: Submersible Handhole] , ...9 more... )
• ASSETID ( type: esriFieldTypeString, alias: ASSETID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ASSETID )
• CITYWORKSPROJECT ( type: esriFieldTypeInteger, alias: Cityworks Project?, editable: true, nullable: true, defaultValue: 0, modelName: CITYWORKSPROJECT , Coded Values: [0: No] , [1: Yes] )
• SF6 ( type: esriFieldTypeSingle, alias: SF6 (LBS), editable: true, nullable: true, defaultValue: null, modelName: SF6 )
• LOCKCOMBINATION ( type: esriFieldTypeString, alias: Lock Combination, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LOCKCOMBINATION )

Types:

ID: 1
Name: Vault
Domains:
• FIELDVERIFY:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [1382: Vault - 4 Foot Barrel] , [1383: Vault - 4 Foot Square] , [1384: Vault - 8 Sided] , ...11 more...
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• RULEID:
  Inherited
Templates:
• Name: Vault
  Description:
  Prototype:
  INSTALLATIONDATE: null
  CITYWORKSPROJECT: null
  ASSETID: null
  SF6: null
  GPSDATE: null
  STRUCTURETYPE: null
  FAULTINDICATOR: NA
  LOCKCOMBINATION: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  SYMBOLROTATION: null
  SUBTYPECD: 1
  OWNERSHIP: null
  COMPATIBLEUNITID: null
  STRUCTUREOBJECTID: null
  DEVICENUMBER: null
  MANUFACTURER: null
  MATERIAL: null
  MODEL: null
  STRUCTURESIZE: null
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  HYPERLINK: null
  HYPERLINK_PGDB: null
  REPLACED_DATE_MM_DD_YYYY: null
  CADTYPE: null
  REFNAME: null
  CADANGLE: null
  RULEID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Padmount Junction Box
Domains:
• FIELDVERIFY:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [255: ENCLOSURE 3PH 4 WAY] , [254: ENCLOSURE 1PH] , [1208: ENCLOSURE 3PH 6 WAY] , ...1 more...
• MATERIAL:
  Coded Values: [1292: Steel] , [1293: Aluminum] , [1294: Fiberglass]
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• RULEID:
  Inherited
Templates:
• Name: Enclosure - Padmount
  Description:
  Prototype:
  INSTALLATIONDATE: null
  CITYWORKSPROJECT: null
  ASSETID: null
  SF6: null
  GPSDATE: null
  OWNERSHIP: null
  STRUCTURETYPE: null
  FAULTINDICATOR: NA
  LOCKCOMBINATION: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  SYMBOLROTATION: null
  SUBTYPECD: 2
  COMPATIBLEUNITID: 255
  STRUCTUREOBJECTID: null
  DEVICENUMBER: null
  MANUFACTURER: null
  MATERIAL: null
  MODEL: null
  STRUCTURESIZE: null
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  HYPERLINK: null
  HYPERLINK_PGDB: null
  REPLACED_DATE_MM_DD_YYYY: null
  CADTYPE: null
  REFNAME: null
  CADANGLE: null
  RULEID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 7
Name: Submersible Junction Box
Domains:
• FIELDVERIFY:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [255: ENCLOSURE 3PH 4 WAY] , [254: ENCLOSURE 1PH] , [1208: ENCLOSURE 3PH 6 WAY] , ...1 more...
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• RULEID:
  Inherited
Templates:
• Name: Enclosure - Submersible
  Description:
  Prototype:
  INSTALLATIONDATE: null
  CITYWORKSPROJECT: null
  ASSETID: null
  SF6: null
  GPSDATE: null
  STRUCTURETYPE: null
  FAULTINDICATOR: NA
  LOCKCOMBINATION: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  SYMBOLROTATION: null
  SUBTYPECD: 7
  OWNERSHIP: null
  COMPATIBLEUNITID: null
  STRUCTUREOBJECTID: null
  DEVICENUMBER: null
  MANUFACTURER: null
  MATERIAL: null
  MODEL: null
  STRUCTURESIZE: null
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  HYPERLINK: null
  HYPERLINK_PGDB: null
  REPLACED_DATE_MM_DD_YYYY: null
  CADTYPE: null
  REFNAME: null
  CADANGLE: null
  RULEID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Submersible Handhole
Domains:
• FIELDVERIFY:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [246: Handhole - Secondary SUBMERSIBLE] , [245: Handhole - Secondary 1 comp METAL] , [244: Handhole - Secondary 3 comp METAL] , ...1 more...
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• RULEID:
  Inherited
Templates:
• Name: Handhole - Submersible
  Description:
  Prototype:
  INSTALLATIONDATE: null
  CITYWORKSPROJECT: null
  ASSETID: null
  SF6: null
  GPSDATE: null
  OWNERSHIP: null
  STRUCTURETYPE: null
  FAULTINDICATOR: NA
  LOCKCOMBINATION: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  SYMBOLROTATION: null
  SUBTYPECD: 3
  COMPATIBLEUNITID: 246
  STRUCTUREOBJECTID: null
  DEVICENUMBER: null
  MANUFACTURER: null
  MATERIAL: null
  MODEL: null
  STRUCTURESIZE: null
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  HYPERLINK: null
  HYPERLINK_PGDB: null
  REPLACED_DATE_MM_DD_YYYY: null
  CADTYPE: null
  REFNAME: null
  CADANGLE: null
  RULEID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Padmount Switch Gear
Domains:
• FIELDVERIFY:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [872: Switch PADMNT Type 431 Gas Insulated] , [203: Switch PADMNT 14.4kV PMH11] , [201: Switch PADMNT 14.4kV PMH3] , ...13 more...
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• RULEID:
  Inherited
Templates:
• Name: Switchgear - Padmount
  Description:
  Prototype:
  INSTALLATIONDATE: null
  CITYWORKSPROJECT: null
  ASSETID: null
  SF6: null
  GPSDATE: null
  STRUCTURETYPE: null
  FAULTINDICATOR: NA
  LOCKCOMBINATION: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  SYMBOLROTATION: null
  SUBTYPECD: 4
  OWNERSHIP: null
  COMPATIBLEUNITID: null
  STRUCTUREOBJECTID: null
  DEVICENUMBER: null
  MANUFACTURER: null
  MATERIAL: null
  MODEL: null
  STRUCTURESIZE: null
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  HYPERLINK: null
  HYPERLINK_PGDB: null
  REPLACED_DATE_MM_DD_YYYY: null
  CADTYPE: null
  REFNAME: null
  CADANGLE: null
  RULEID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: Submersible Switch Gear
Domains:
• FIELDVERIFY:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [872: Switch PADMNT Type 431 Gas Insulated] , [203: Switch PADMNT 14.4kV PMH11] , [201: Switch PADMNT 14.4kV PMH3] , ...13 more...
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• RULEID:
  Inherited
Templates:
• Name: Switchgear - Submersible
  Description:
  Prototype:
  INSTALLATIONDATE: null
  CITYWORKSPROJECT: null
  ASSETID: null
  SF6: null
  GPSDATE: null
  STRUCTURETYPE: null
  FAULTINDICATOR: NA
  LOCKCOMBINATION: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  SYMBOLROTATION: null
  SUBTYPECD: 5
  OWNERSHIP: null
  COMPATIBLEUNITID: null
  STRUCTUREOBJECTID: null
  DEVICENUMBER: null
  MANUFACTURER: null
  MATERIAL: null
  MODEL: null
  STRUCTURESIZE: null
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  HYPERLINK: null
  HYPERLINK_PGDB: null
  REPLACED_DATE_MM_DD_YYYY: null
  CADTYPE: null
  REFNAME: null
  CADANGLE: null
  RULEID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: Pad
Domains:
• FIELDVERIFY:
  Inherited
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• RULEID:
  Inherited
Templates:
• Name: Pad
  Description:
  Prototype:
  INSTALLATIONDATE: null
  CITYWORKSPROJECT: null
  ASSETID: null
  SF6: null
  GPSDATE: null
  STRUCTURETYPE: null
  FAULTINDICATOR: NA
  LOCKCOMBINATION: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  SYMBOLROTATION: null
  SUBTYPECD: 6
  OWNERSHIP: null
  COMPATIBLEUNITID: null
  STRUCTUREOBJECTID: null
  DEVICENUMBER: null
  MANUFACTURER: null
  MATERIAL: null
  MODEL: null
  STRUCTURESIZE: null
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  HYPERLINK: null
  HYPERLINK_PGDB: null
  REPLACED_DATE_MM_DD_YYYY: null
  CADTYPE: null
  REFNAME: null
  CADANGLE: null
  RULEID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 8
Name: Padmount Handhole
Domains:
• FIELDVERIFY:
  Inherited
• COMPATIBLEUNITID:
  Coded Values: [246: Handhole - Secondary SUBMERSIBLE] , [245: Handhole - Secondary 1 comp METAL] , [244: Handhole - Secondary 3 comp METAL] , ...1 more...
• FAULTINDICATOR:
  Coded Values: [NA: Not Applicable]
• RULEID:
  Inherited
Templates:
• Name: Handhole - Padmount
  Description:
  Prototype:
  INSTALLATIONDATE: null
  CITYWORKSPROJECT: null
  ASSETID: null
  SF6: null
  GPSDATE: null
  OWNERSHIP: null
  STRUCTURETYPE: null
  FAULTINDICATOR: NA
  LOCKCOMBINATION: null
  FIELDVERIFY: N
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  SYMBOLROTATION: null
  SUBTYPECD: 8
  COMPATIBLEUNITID: 244
  STRUCTUREOBJECTID: null
  DEVICENUMBER: null
  MANUFACTURER: null
  MATERIAL: null
  MODEL: null
  STRUCTURESIZE: null
  FEATURE_STATUS:
  STREETLIGHT_FACILITY: null
  HYPERLINK: null
  HYPERLINK_PGDB: null
  REPLACED_DATE_MM_DD_YYYY: null
  CADTYPE: null
  REFNAME: null
  CADANGLE: null
  RULEID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 11
Name: Padmount Fibre
Domains:
• FIELDVERIFY:
  Inherited
• FEATURE_STATUS:
  Inherited
• STREETLIGHT_FACILITY:
  Inherited
• RULEID:
  Inherited
Templates:
• Name: Padmount Fibre
  Description:
  Prototype:
  SF6: null
  LOCKCOMBINATION: null
  INSTALLATIONDATE: null
  FIELDVERIFY: 0
  COMMENTS: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  SYMBOLROTATION: null
  GPSDATE: null
  SUBTYPECD: 11
  OWNERSHIP: null
  COMPATIBLEUNITID: null
  STRUCTUREOBJECTID: null
  DEVICENUMBER: null
  MANUFACTURER: null
  MATERIAL: null
  MODEL: null
  STRUCTURESIZE: null
  STRUCTURETYPE: null
  FAULTINDICATOR: null
  FEATURE_STATUS: Existing
  STREETLIGHT_FACILITY: null
  HYPERLINK: null
  HYPERLINK_PGDB: null
  REPLACED_DATE_MM_DD_YYYY: null
  CADTYPE: null
  REFNAME: null
  CADANGLE: null
  RULEID: 11
  ASSETID: null
  CITYWORKSPROJECT: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Extract

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata