View In:   ArcGIS Online Map Viewer

Name: Controllable Fitting

Display Field: CREATIONUSER

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: COMMENTS: 255 characters to describe anything about the gas main that is not housed within a feature, but is important for field staff or office staff for design, finding more information etc.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.INSTALLATIONDATE: Date infrastructure/ material was installed.LOCATION: The address the pipeline supply gas to. (Only a few records/ not really used) 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 ie. 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 known.WORKORDERID: Account number the pipe was purchased and installed through, reference to find paper files of this project in Onbase.Field not used: INSERVICEDATE, HYPERLINK.

Copyright Text: City of Medicine Hat - UDS - Gas Distribution

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

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 14243.8274999997
YMin: 5539228.1593
XMax: 26945.2873
YMax: 5549333.1753
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: [138, 67, 0, 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: Stopper Fitting
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [146, 166, 0, 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: 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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: SUBTYPECD

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: System-maintained ObjectID )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: AncillaryRole, editable: true, nullable: true, defaultValue: null, modelName: AncillaryRole )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• CREATIONUSER ( type: esriFieldTypeString, alias: Creation User, editable: false, nullable: true, length: 20, defaultValue: null, modelName: CreationUser )
• DATECREATED ( type: esriFieldTypeDate, alias: Date Created, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DateCreated )
• LASTUSER ( type: esriFieldTypeString, alias: Last User, editable: false, nullable: true, length: 20, defaultValue: null, modelName: LastUser )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: Date Modified, editable: false, nullable: true, length: 8, defaultValue: null, modelName: DateModified )
• INSTALLATIONDATE ( type: esriFieldTypeDate, alias: InstallationDate, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InstallationDate )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: Subtype, editable: true, nullable: true, defaultValue: 1, modelName: SubtypeCD )
• FITTINGDIAMETER ( type: esriFieldTypeString, alias: Fitting Diameter, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FittingDiameter , Coded Values: [15: 15] , [20: 20] , [20x15: 20x15] , ...132 more... )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 5, defaultValue: MTL, modelName: Material , Coded Values: [MTL: Metal] )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Manufacturer , Coded Values: [MUL: Mueller] , [TDW: TD Williamson] , [UNK: Unknown] )
• WORKORDERID ( type: esriFieldTypeString, alias: Work Order ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WorkOrderID )
• INSERVICEDATE ( type: esriFieldTypeDate, alias: In Service Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: InServiceDate )
• GASTRACEWEIGHT ( type: esriFieldTypeInteger, alias: Gas Trace Weight, editable: true, nullable: true, defaultValue: null, modelName: GasTraceWeight )
• SYMBOLROTATION ( type: esriFieldTypeDouble, alias: Symbol Rotation, editable: true, nullable: true, defaultValue: 0, modelName: SymbolRotation )
• INSULATEDINDICATOR ( type: esriFieldTypeString, alias: Insulated Indicator, editable: true, nullable: true, length: 5, defaultValue: null, modelName: InsulatedIndicator , Coded Values: [N: No] , [Y: Yes] )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Comments )
• HYPERLINK ( type: esriFieldTypeString, alias: Hyperlink, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Hyperlink )
• NORMALPOSITION ( type: esriFieldTypeInteger, alias: Normal Position, editable: true, nullable: true, defaultValue: null, modelName: NormalPosition , Coded Values: [0: Closed] , [1: Open] )
• PRESENTPOSITION ( type: esriFieldTypeInteger, alias: Present Position, editable: true, nullable: true, defaultValue: null, modelName: PresentPosition , Coded Values: [0: Closed] , [1: Open] )
• EMERISOLATIONSYSSTATUS ( type: esriFieldTypeString, alias: Emergency Isolation System Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: EmerIsolationSysStatus )
• GASPRESSURESYSTEMSTATUS ( type: esriFieldTypeString, alias: Gas Pressure System Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GasPressureSystemStatus )
• GASSYSTEMSTATUS ( type: esriFieldTypeString, alias: Gas System Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GasSystemStatus )
• MODEL ( type: esriFieldTypeString, alias: Model, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Model )
• LOTNUMBER ( type: esriFieldTypeString, alias: Lot Number, editable: true, nullable: true, length: 30, defaultValue: null, modelName: LotNumber )
• LOCATIONQUALITY ( type: esriFieldTypeSmallInteger, alias: Location Quality, editable: true, nullable: true, defaultValue: null, modelName: LocationQuality , Coded Values: [1: Survey] , [2: Field Notes] , [3: Estimate] , ...1 more... )
• GBASEID ( type: esriFieldTypeInteger, alias: GBaseID, editable: true, nullable: true, defaultValue: null, modelName: GBaseID )
• HISTORICAL_OID ( type: esriFieldTypeInteger, alias: Historical_OID, editable: true, nullable: true, defaultValue: null, modelName: Historical_OID )
• BONDEDINDICATOR ( type: esriFieldTypeString, alias: BondedIndicator, editable: true, nullable: true, length: 5, defaultValue: null, modelName: BondedIndicator , Coded Values: [N: No] , [Y: Yes] )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GLOBALID )

Types:

ID: 1
Name: Stopper Fitting
Domains:
• ENABLED:
  Inherited
• FITTINGDIAMETER:
  Inherited
• MATERIAL:
  Inherited
• MANUFACTURER:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• NORMALPOSITION:
  Inherited
• PRESENTPOSITION:
  Inherited
• BONDEDINDICATOR:
  Inherited
Templates:
• Name: Stopper Fitting
  Description:
  Prototype:
  BONDEDINDICATOR: null
  HISTORICAL_OID: null
  ANCILLARYROLE: null
  ENABLED: 1
  GBASEID: null
  LOCATIONQUALITY: null
  LOTNUMBER: null
  MODEL: null
  INSTALLATIONDATE: null
  SUBTYPECD: 1
  FITTINGDIAMETER: null
  MATERIAL: MTL
  MANUFACTURER: null
  WORKORDERID: null
  INSERVICEDATE: null
  GASTRACEWEIGHT: null
  SYMBOLROTATION: 0
  INSULATEDINDICATOR: null
  COMMENTS: null
  HYPERLINK: null
  NORMALPOSITION: null
  PRESENTPOSITION: null
  EMERISOLATIONSYSSTATUS: null
  GASPRESSURESYSTEMSTATUS: null
  GASSYSTEMSTATUS: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Uploads,Editing,Extract

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Edit Fields Info:

• Creation Date Field: DATECREATED
• Creator Field: CREATIONUSER
• Edit Date Field: DATEMODIFIED
• Editor Field: LASTUSER

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Apply Edits   Add Features   Update Features   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata