View In:   ArcGIS Online Map Viewer

Name: MNGL_Enterprise_ArcFm.SDE.NonControllableFitting

Display Field: MATERIAL

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 059e80d07c4845369e38b8c6a7e0492f

Copyright Text:

Default Visibility: true

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 0

Max Scale: 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: 360866.6202999996
YMin: 2038808.7789999992
XMax: 390486.7511999998
YMax: 2079266.7087999992
Spatial Reference: 32643  (32643)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SUBTYPECD
Field 2: null
Field 3: null
Field Delimiter: ,
Default Symbol:
Style: esriSMSCircle
Color: [176, 138, 0, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 1
Default Label:
UniqueValueInfos:
• Value: 1
  Label: Coupler
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [135, 110, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 9
  Label: Drs TF
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [11, 0, 161, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 2
  Label: Elbow
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [135, 9, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 3
  Label: End Cap
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [26, 128, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 6
  Label: Flange
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [153, 0, 153, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 7
  Label: Insulating Joint
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [67, 0, 138, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 4
  Label: Reducer
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [0, 52, 156, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 8
  Label: Saddle
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [38, 173, 0, 255]
  Size: 4.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: 5
  Label: Tee
  Description:
  Symbol:
  Style: esriSMSCircle
  Color: [0, 145, 27, 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: OBJECTID )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: SUBTYPECD, editable: true, nullable: true, defaultValue: 3, modelName: SubtypeCD )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Material , Coded Values: [SS: Stainless Steel] , [CS: Carbon Steel] , [SSMDPE: SSMDPE] , ...2 more... )
• FITTINGDIAMETER ( type: esriFieldTypeString, alias: Fitting Diameter, editable: true, nullable: true, length: 15, defaultValue: null, modelName: FittingDiameter , Coded Values: [1.5 X 45 DEG: 1.5" X 45 DEG] , [12: 12"] , [12 X 12: 12" X 12"] , ...108 more... )
• MANUFACTURER ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Manufacturer , Coded Values: [AMP: Amp Fitting] , [CNP: Central Plastic] , [CHI: Chicago] , ...19 more... )
• STYLE ( type: esriFieldTypeString, alias: Style, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Style , Coded Values: [AA: duPont Aladyl-A] , [AMP: Amp Fit] , [BRS: Branch Saddle] , ...43 more... )
• OWNER ( type: esriFieldTypeString, alias: OWNER, editable: true, nullable: true, length: 20, defaultValue: MGNL, modelName: OWNER )
• BONDEDINDICATOR ( type: esriFieldTypeString, alias: Bonded Indicator, editable: true, nullable: true, length: 5, defaultValue: null, modelName: BondedIndicator , Coded Values: [N: No] , [Y: Yes] )
• INSULATEDINDICATOR ( type: esriFieldTypeString, alias: Insulated Indicator, editable: true, nullable: true, length: 5, defaultValue: null, modelName: InsulatedIndicator , Coded Values: [N: No] , [Y: Yes] )
• SYMBOLROTATION ( type: esriFieldTypeDouble, alias: SYMBOLROTATION, editable: true, nullable: true, defaultValue: 0, modelName: SymbolRotation )
• GASTRACEWEIGHT ( type: esriFieldTypeInteger, alias: Gas Trace Weight, editable: true, nullable: true, defaultValue: null, modelName: GasTraceWeight )
• CREATIONUSER ( type: esriFieldTypeString, alias: Creation User, editable: true, nullable: true, length: 20, 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: 20, defaultValue: null, modelName: LastUser )
• SUBAREACODE ( type: esriFieldTypeString, alias: SUBAREACODE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SUBAREACODE )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: Date Modified, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DateModified )
• ANCILLARYROLE ( type: esriFieldTypeSmallInteger, alias: Ancilary Role, editable: true, nullable: true, defaultValue: null, modelName: ANCILLARYROLE , Coded Values: [0: None] , [1: Source] , [2: Sink] )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• DIAMETERUNIT ( type: esriFieldTypeString, alias: DIAMETERUNIT, editable: true, nullable: true, length: 10, defaultValue: null, modelName: DIAMETERUNIT )
• INSERVICEDATE ( type: esriFieldTypeDate, alias: INSERVICEDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSERVICEDATE )
• TF_NUMBER ( type: esriFieldTypeString, alias: TF_NUMBER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TF_NUMBER )
• UINCID ( type: esriFieldTypeInteger, alias: UINCID, editable: true, nullable: true, defaultValue: null, modelName: UNICID )
• DBID ( type: esriFieldTypeString, alias: DBID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: DBID )
• Asset_Id ( type: esriFieldTypeString, alias: Asset_Id, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Asset_Id )
• Location ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Location )

Types:

ID: 1
Name: Coupler
Domains:
• MATERIAL:
  Inherited
• FITTINGDIAMETER:
  Inherited
• MANUFACTURER:
  Inherited
• STYLE:
  Inherited
• BONDEDINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
Templates:
• Name: Coupler
  Description:
  Prototype:
  Asset_Id: null
  Location: null
  SUBTYPECD: 1
  MATERIAL: null
  FITTINGDIAMETER: null
  MANUFACTURER: null
  STYLE: null
  OWNER: null
  BONDEDINDICATOR: null
  INSULATEDINDICATOR: null
  SYMBOLROTATION: 0
  GASTRACEWEIGHT: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SUBAREACODE: null
  DATEMODIFIED: null
  ANCILLARYROLE: null
  ENABLED: 1
  DIAMETERUNIT: null
  INSERVICEDATE: null
  TF_NUMBER: null
  UINCID: null
  DBID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 9
Name: Drs TF
Domains:
• MATERIAL:
  Inherited
• FITTINGDIAMETER:
  Inherited
• MANUFACTURER:
  Inherited
• STYLE:
  Inherited
• BONDEDINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
Templates:
• Name: Drs TF
  Description:
  Prototype:
  Asset_Id: null
  Location: null
  SUBTYPECD: 9
  MATERIAL: null
  FITTINGDIAMETER: null
  MANUFACTURER: null
  STYLE: null
  OWNER: null
  BONDEDINDICATOR: null
  INSULATEDINDICATOR: null
  SYMBOLROTATION: 0
  GASTRACEWEIGHT: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SUBAREACODE: null
  DATEMODIFIED: null
  ANCILLARYROLE: null
  ENABLED: 1
  DIAMETERUNIT: null
  INSERVICEDATE: null
  TF_NUMBER: null
  UINCID: null
  DBID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Elbow
Domains:
• MATERIAL:
  Inherited
• FITTINGDIAMETER:
  Inherited
• MANUFACTURER:
  Inherited
• STYLE:
  Inherited
• BONDEDINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
Templates:
• Name: Elbow
  Description:
  Prototype:
  Asset_Id: null
  Location: null
  SUBTYPECD: 2
  MATERIAL: null
  FITTINGDIAMETER: null
  MANUFACTURER: null
  STYLE: null
  OWNER: null
  BONDEDINDICATOR: null
  INSULATEDINDICATOR: null
  SYMBOLROTATION: 0
  GASTRACEWEIGHT: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SUBAREACODE: null
  DATEMODIFIED: null
  ANCILLARYROLE: null
  ENABLED: 1
  DIAMETERUNIT: null
  INSERVICEDATE: null
  TF_NUMBER: null
  UINCID: null
  DBID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: End Cap
Domains:
• MATERIAL:
  Inherited
• FITTINGDIAMETER:
  Inherited
• MANUFACTURER:
  Inherited
• STYLE:
  Inherited
• BONDEDINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
Templates:
• Name: End Cap
  Description:
  Prototype:
  Asset_Id: null
  Location: null
  SUBTYPECD: 3
  MATERIAL: null
  FITTINGDIAMETER: null
  MANUFACTURER: null
  STYLE: null
  OWNER: null
  BONDEDINDICATOR: null
  INSULATEDINDICATOR: null
  SYMBOLROTATION: 0
  GASTRACEWEIGHT: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SUBAREACODE: null
  DATEMODIFIED: null
  ANCILLARYROLE: null
  ENABLED: 1
  DIAMETERUNIT: null
  INSERVICEDATE: null
  TF_NUMBER: null
  UINCID: null
  DBID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: Flange
Domains:
• MATERIAL:
  Inherited
• FITTINGDIAMETER:
  Inherited
• MANUFACTURER:
  Inherited
• STYLE:
  Inherited
• BONDEDINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
Templates:
• Name: Flange
  Description:
  Prototype:
  Asset_Id: null
  Location: null
  SUBTYPECD: 6
  MATERIAL: null
  FITTINGDIAMETER: null
  MANUFACTURER: null
  STYLE: null
  OWNER: null
  BONDEDINDICATOR: null
  INSULATEDINDICATOR: null
  SYMBOLROTATION: 0
  GASTRACEWEIGHT: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SUBAREACODE: null
  DATEMODIFIED: null
  ANCILLARYROLE: null
  ENABLED: 1
  DIAMETERUNIT: null
  INSERVICEDATE: null
  TF_NUMBER: null
  UINCID: null
  DBID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 7
Name: Insulating Joint
Domains:
• MATERIAL:
  Inherited
• FITTINGDIAMETER:
  Inherited
• MANUFACTURER:
  Inherited
• STYLE:
  Inherited
• BONDEDINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
Templates:
• Name: Insulating Joint
  Description:
  Prototype:
  Asset_Id: null
  Location: null
  SUBTYPECD: 7
  MATERIAL: null
  FITTINGDIAMETER: null
  MANUFACTURER: null
  STYLE: null
  OWNER: null
  BONDEDINDICATOR: null
  INSULATEDINDICATOR: null
  SYMBOLROTATION: 0
  GASTRACEWEIGHT: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SUBAREACODE: null
  DATEMODIFIED: null
  ANCILLARYROLE: null
  ENABLED: 1
  DIAMETERUNIT: null
  INSERVICEDATE: null
  TF_NUMBER: null
  UINCID: null
  DBID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Reducer
Domains:
• MATERIAL:
  Inherited
• FITTINGDIAMETER:
  Inherited
• MANUFACTURER:
  Inherited
• STYLE:
  Inherited
• BONDEDINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
Templates:
• Name: Reducer
  Description:
  Prototype:
  Asset_Id: null
  Location: null
  SUBTYPECD: 4
  MATERIAL: null
  FITTINGDIAMETER: null
  MANUFACTURER: null
  STYLE: null
  OWNER: null
  BONDEDINDICATOR: null
  INSULATEDINDICATOR: null
  SYMBOLROTATION: 0
  GASTRACEWEIGHT: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SUBAREACODE: null
  DATEMODIFIED: null
  ANCILLARYROLE: null
  ENABLED: 1
  DIAMETERUNIT: null
  INSERVICEDATE: null
  TF_NUMBER: null
  UINCID: null
  DBID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 8
Name: Saddle
Domains:
• MATERIAL:
  Inherited
• FITTINGDIAMETER:
  Inherited
• MANUFACTURER:
  Inherited
• STYLE:
  Inherited
• BONDEDINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
Templates:
• Name: Saddle
  Description:
  Prototype:
  Asset_Id: null
  Location: null
  SUBTYPECD: 8
  MATERIAL: null
  FITTINGDIAMETER: null
  MANUFACTURER: null
  STYLE: null
  OWNER: null
  BONDEDINDICATOR: null
  INSULATEDINDICATOR: null
  SYMBOLROTATION: 0
  GASTRACEWEIGHT: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SUBAREACODE: null
  DATEMODIFIED: null
  ANCILLARYROLE: null
  ENABLED: 1
  DIAMETERUNIT: null
  INSERVICEDATE: null
  TF_NUMBER: null
  UINCID: null
  DBID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: Tee
Domains:
• MATERIAL:
  Inherited
• FITTINGDIAMETER:
  Inherited
• MANUFACTURER:
  Inherited
• STYLE:
  Inherited
• BONDEDINDICATOR:
  Inherited
• INSULATEDINDICATOR:
  Inherited
• ANCILLARYROLE:
  Inherited
• ENABLED:
  Inherited
Templates:
• Name: Tee
  Description:
  Prototype:
  Asset_Id: null
  Location: null
  SUBTYPECD: 5
  MATERIAL: null
  FITTINGDIAMETER: null
  MANUFACTURER: null
  STYLE: null
  OWNER: null
  BONDEDINDICATOR: null
  INSULATEDINDICATOR: null
  SYMBOLROTATION: 0
  GASTRACEWEIGHT: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  SUBAREACODE: null
  DATEMODIFIED: null
  ANCILLARYROLE: null
  ENABLED: 1
  DIAMETERUNIT: null
  INSERVICEDATE: null
  TF_NUMBER: null
  UINCID: null
  DBID: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

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

Sync Can Return Changes: false

Is Data Versioned: false

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   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata