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:
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:
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