Name: Stations

Display Field: NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Subtype (SUBtypeCD):Regulator StationReceipt StationCustomer StationOdorant StationValve HeaderRectifier/SCADAANCILLARYROLE: BYPASSINDICATOR: COMMENTS: 255 characters for additional information about the service pipeline, that is important for field staff or office staff for design, finding more information etc.CPSYSTEMSTATUS: If the value of the CPSystemStatus field is 1 it is automatically a CP Stop, and the trace will not continue. Usually the value in this field is a coded value of a domain. In our sample data this domain is called CP System Status (1 = Open and 0 = Closed). Since Cathodic Protection essentially looks for electricity, a value of Open indicates a stopping point for the trace (unlike an Open gas valve which allows the flow of gas). If the value of the CPSystemStatus field is set to 1 (Open), bit 19 for junctions or bit 23 for edges is set—meaning that the trace will stop at this feature. If the CPSystemStatus field is set to 0 (Closed) the trace will continue.DESIGNCAPACITYMCFHENABLED: FACILITYID: Unique ID to identify stations. GASTRACEWEIGHT: ArcFM calculates a value for this field to inform its tracing functions about one or multiple attributes on a given feature – using this to determine whether to go or stop.GBASEID: Object ID from old ArcGIS database, prior to converting to ArcFM.GLOBALID: Auto Calculated value used in relationships to create joins, unique identifier for each asset.HEATERS: Indicates station with/without heating provided. HISTORICAL_OID: Object ID from older ArcGIS database, prior to converting to ArcFM. INSTALLATIONDATE: Date station was installed.INSULATEDINDICATOR: Indicate if the station is insulated. LOCATION: Address of the station. LOCATIONQUALITY: Graphic = there is a pipeline is in this general area. Estimate = understand where the facility is roughly compared to an existing above grade location i.e., on the right side of the power-pole. Field Notes = Measurements were taken from property or existing above grade facility. Survey = GPS points were taken on the facility, exact location of pipeline is knownMOPIN: Indicates the operating pressure of gas been supplied to the station. MOPOUT: indicates the operating pressure of gas leaving the station after been reduced by regulators. NAME: identifies the name of the station. OPERATINGCLASSIFICATION: Identifies the level of inspections needed for the station, this informs the frequency of inspection performed on. OVERPRESSUREPROTECTIONTYPE: SUBTYPECD: The different types of stations. Subtypcd are defined by the subtypes. SUPPLIER: Only for Receipt stations, indicates the company providing gas to the station.SYMBOLROTATION: The angle of rotation of the station symbol in the map. SOPIN: Not used. SOPOUT: STATUS: Indicates if the station is Operational (Offline / Online) TAXROLL_BUIDLING: TAXROLL_ME: WORKORDERID: Account number the station was purchased and installed through, reference to find paper files of this project in OnBase.Fields Not used: PIPEDIAMETER, GASSYSTEMOBJECTSTATUS, GASSYSTEMOBJECTID, GASPRESSURESYSTEMSTATUS, GASPRESSURESYSTEMOBJECTID, EMERISOLATIONSYSTEMSTATUS, EMERISOLATIONOBJECTID, SOPIN, HYPERLINK, INSERVICEDATE, EQUIPMENTID.

Copyright Text: City of Medicine Hat- Gas Distribution UDS. last updated Nov 2023.

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: 14277.4806000004
YMin: 5539236.3703
XMax: 28054.585799999502
YMax: 5555411.9767
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:
Style: esriSMSCircle
Color: [0, 166, 110, 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: 3
  Label: Customer Station
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [0, 7, 148, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 4
  Label: Odorant Station
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [130, 0, 17, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 2
  Label: Receipt Station
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [0, 161, 3, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 6
  Label: Rectifier/SCADA
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [114, 0, 176, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 1
  Label: Regulator Station
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [72, 0, 128, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 5
  Label: Valve Header
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [0, 79, 148, 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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SubtypeCD

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: AncillaryRole )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled , Coded Values: [0: False] , [1: True] )
• CREATIONUSER ( type: esriFieldTypeString, alias: Creation User, length: 20 )
• DATECREATED ( type: esriFieldTypeDate, alias: Date Created, length: 8 )
• LASTUSER ( type: esriFieldTypeString, alias: Last User, length: 20 )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: Date Modified, length: 8 )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: InstallationDate, length: 8 )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: Subtype )
• FACILITYID ( type: esriFieldTypeString, alias: Facility ID, length: 20 )
• EQUIPMENTID ( type: esriFieldTypeString, alias: Equipment ID, length: 20 )
• SUPPLIER ( type: esriFieldTypeString, alias: Supplier, length: 20 , Coded Values: [NGPR: NGPR] , [TCPL: TCPL] )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, length: 255 )
• WORKORDERID ( type: esriFieldTypeString, alias: Work Order ID, length: 20 )
• INSERVICEDATE ( type: esriFieldTypeDate, alias: In Service Date, length: 8 )
• GASTRACEWEIGHT ( type: esriFieldTypeInteger, alias: Gas Trace Weight )
• SYMBOLROTATION ( type: esriFieldTypeDouble, alias: Symbol Rotation )
• HYPERLINK ( type: esriFieldTypeString, alias: Hyperlink, length: 255 )
• NAME ( type: esriFieldTypeString, alias: Name, length: 50 )
• MOPIN ( type: esriFieldTypeDouble, alias: Maximum Operating Pressure - In )
• MOPOUT ( type: esriFieldTypeDouble, alias: Maximum Operating Pressure - Out )
• SOPIN ( type: esriFieldTypeDouble, alias: System Operating Pressure - In )
• SOPOUT ( type: esriFieldTypeDouble, alias: System Operating Pressure - Out )
• OVERPRESSUREPROTECTIONTYPE ( type: esriFieldTypeString, alias: Over Pressure Protection Type, length: 5 , Coded Values: [ESD: Emergency Shutdown] , [FCRV: Full Capacity Relief Valve] , [M: Monitor Only] , ...4 more... )
• BYPASSINDICATOR ( type: esriFieldTypeString, alias: Bypass Indicator, length: 5 , Coded Values: [N: No] , [Y: Yes] )
• DESIGNCAPACITYMCFH ( type: esriFieldTypeString, alias: Design Capacity - MCFH, length: 20 )
• EMERISOLATIONSYSSTATUS ( type: esriFieldTypeString, alias: Emergency Isolation System Status, length: 20 )
• GASPRESSURESYSTEMSTATUS ( type: esriFieldTypeString, alias: Gas Pressure System Status, length: 20 )
• GASSYSTEMSTATUS ( type: esriFieldTypeString, alias: Gas System Status, length: 20 )
• INSULATEDINDICATOR ( type: esriFieldTypeString, alias: Insulated Indicator, length: 5 , Coded Values: [N: No] , [Y: Yes] )
• LOCATION ( type: esriFieldTypeString, alias: Location Description, length: 50 )
• STATUS ( type: esriFieldTypeString, alias: Status, length: 5 , Coded Values: [OFF: Offline] , [ONL: Online] , [UNK: Unknown] )
• CPSYSTEMSTATUS ( type: esriFieldTypeInteger, alias: CP SystemStatus , Coded Values: [0: Closed] , [1: Open] )
• EMERISOLATIONSYSOBJECTID ( type: esriFieldTypeInteger, alias: Emergency Isolation Sys ObjectID )
• GASPRESSURESYSTEMOBJECTID ( type: esriFieldTypeInteger, alias: Gas Pressure System ObjectID )
• GASSYSTEMOBJECTID ( type: esriFieldTypeInteger, alias: Gas System ObjectID )
• GBASEID ( type: esriFieldTypeInteger, alias: GBaseID )
• LOCATIONQUALITY ( type: esriFieldTypeSmallInteger, alias: Location Quality , Coded Values: [1: Survey] , [2: Field Notes] , [3: Estimate] , ...1 more... )
• TAXROLL_BUIDLING ( type: esriFieldTypeString, alias: Tax Roll Building, length: 10 )
• TAXROLL_ME ( type: esriFieldTypeString, alias: Tax Roll M & E, length: 10 )
• HISTORICAL_OID ( type: esriFieldTypeInteger, alias: Historical_OID )
• PIPEDIAMETER ( type: esriFieldTypeString, alias: PipeDiameter, length: 10 , Coded Values: [15: 15mm] , [20: 20mm] , [25: 25mm] , ...15 more... )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• OPERATINGCLASSIFICATION ( type: esriFieldTypeString, alias: Operating Classification, length: 5 , Coded Values: [CIR: Critical/Inspection Required] , [NC: Non-Critical] )
• HEATERS ( type: esriFieldTypeString, alias: Heaters, length: 20 , Coded Values: [N: No] , [Y: Yes] )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

Types:

ID: 1
Name: Regulator Station
Domains:
• ENABLED:
  Inherited
• SUPPLIER:
  Inherited
• OVERPRESSUREPROTECTIONTYPE:
  Inherited
• BYPASSINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• STATUS:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• PIPEDIAMETER:
  Inherited
• OPERATINGCLASSIFICATION:
  Inherited

---

ID: 2
Name: Receipt Station
Domains:
• ENABLED:
  Inherited
• SUPPLIER:
  Inherited
• OVERPRESSUREPROTECTIONTYPE:
  Inherited
• BYPASSINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• STATUS:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• LOCATIONQUALITY:
  Inherited
• PIPEDIAMETER:
  Inherited
• OPERATINGCLASSIFICATION:
  Inherited

---

ID: 3
Name: Customer Station
Domains:
• ENABLED:
  Inherited
• SUPPLIER:
  Inherited
• OVERPRESSUREPROTECTIONTYPE:
  Inherited
• BYPASSINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• STATUS:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• LOCATIONQUALITY:
  Inherited
• PIPEDIAMETER:
  Inherited
• OPERATINGCLASSIFICATION:
  Inherited

---

ID: 5
Name: Valve Header
Domains:
• ENABLED:
  Inherited
• SUPPLIER:
  Inherited
• OVERPRESSUREPROTECTIONTYPE:
  Inherited
• BYPASSINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• STATUS:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• LOCATIONQUALITY:
  Inherited
• PIPEDIAMETER:
  Inherited
• OPERATINGCLASSIFICATION:
  Inherited

---

ID: 6
Name: Rectifier/SCADA
Domains:
• ENABLED:
  Inherited
• SUPPLIER:
  Inherited
• OVERPRESSUREPROTECTIONTYPE:
  Inherited
• BYPASSINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• STATUS:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• LOCATIONQUALITY:
  Inherited
• PIPEDIAMETER:
  Inherited
• OPERATINGCLASSIFICATION:
  Inherited

---

ID: 4
Name: Odorant Station
Domains:
• ENABLED:
  Inherited
• SUPPLIER:
  Inherited
• OVERPRESSUREPROTECTIONTYPE:
  Inherited
• BYPASSINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• STATUS:
  Inherited
• CPSYSTEMSTATUS:
  Inherited
• LOCATIONQUALITY:
  Inherited
• PIPEDIAMETER:
  Inherited
• OPERATINGCLASSIFICATION:
  Inherited

---

Relationships:

• Rectifier (1) -- Related To: Rectifier (18)
• Non-Controllable Fitting (0) -- Related To: Non-Controllable Fitting (5)
• GasValve (2) -- Related To: Gas Valve (8)

Supported Operations:   Query   Query Attachments   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata