View In:   ArcGIS Online Map Viewer

Name: Water2018.SDE.wFITTING

Display Field: OBJNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Service Item Id: 5b93eb1cc18f498ca6c2ac7ea4c43a3e

Copyright Text:

Default Visibility: true

MaxRecordCount: 5000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 100000

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: 3051693.2413104773
YMin: 721701.4040978104
XMax: 1.0383919916066632E7
YMax: 2.6459700990659714E7
Spatial Reference: 103152  (6576)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: FITTINGTYP
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 1
  Label: Bend
  Description: N/A
  Symbol:
  
• Value: 2
  Label: Cap
  Description: N/A
  Symbol:
  
• Value: 3
  Label: Coupling
  Description: N/A
  Symbol:
  
• Value: 4
  Label: Cross
  Description: N/A
  Symbol:
  
• Value: 5
  Label: ExpansionJoint
  Description: N/A
  Symbol:
  
• Value: 6
  Label: Offset
  Description: N/A
  Symbol:
  
• Value: 7
  Label: Other
  Description: N/A
  Symbol:
  
• Value: 8
  Label: Reducer
  Description: N/A
  Symbol:
  
• Value: 9
  Label: Riser
  Description: N/A
  Symbol:
  
• Value: 10
  Label: Saddle
  Description: N/A
  Symbol:
  
• Value: 11
  Label: Sleeve
  Description: N/A
  Symbol:
  
• Value: 12
  Label: Tap
  Description: N/A
  Symbol:
  
• Value: 13
  Label: Tee
  Description: N/A
  Symbol:
  
• Value: 14
  Label: Unknown
  Description: N/A
  Symbol:
  
• Value: 15
  Label: Weld
  Description: N/A
  Symbol:
  
• Value: 16
  Label: Wye
  Description: N/A
  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: true

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: FITTINGTYP

Fields:

• AncillaryRole ( type: esriFieldTypeSmallInteger, alias: Ancillary Role, editable: true, nullable: true, defaultValue: null, modelName: AncillaryRole )
• FacilityID ( type: esriFieldTypeString, alias: Facility ID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FacilityID )
• LocationDescription ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LocationDescription )
• Rotation ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: null, modelName: Rotation )
• LIFECYCLES ( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 20, defaultValue: Active, modelName: LifecycleStatus , Coded Values: [Proposed: Proposed] , [Active: Active] , [Abandoned: Abandoned] , ...1 more... )
• POINT_X ( type: esriFieldTypeDouble, alias: POINT_X, editable: true, nullable: true, defaultValue: null, modelName: POINT_X )
• POINT_Y ( type: esriFieldTypeDouble, alias: POINT_Y, editable: true, nullable: true, defaultValue: null, modelName: POINT_Y )
• POINT_Z ( type: esriFieldTypeDouble, alias: POINT_Z, editable: true, nullable: true, defaultValue: null, modelName: POINT_Z )
• created_user ( type: esriFieldTypeString, alias: created_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: created_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• OBJNAME ( type: esriFieldTypeString, alias: Object Name, editable: true, nullable: true, length: 25, defaultValue: null, modelName: OBJNAME )
• CODEDESC ( type: esriFieldTypeString, alias: Code Description, editable: true, nullable: true, length: 25, defaultValue: null, modelName: CODEDESC )
• INSTALL_YE ( type: esriFieldTypeDouble, alias: INSTALL_YE, editable: true, nullable: true, defaultValue: 9999, modelName: INSTALL_YE )
• SURVEYED ( type: esriFieldTypeDouble, alias: SURVEYED, editable: true, nullable: true, defaultValue: 0, modelName: SURVEYED , Coded Values: [0: True] , [1: False] )
• INF_SOURCE ( type: esriFieldTypeString, alias: Information Source, editable: true, nullable: true, length: 3, defaultValue: 5, modelName: INF_SOURCE , Coded Values: [1: ASBUILT] , [2: COMPUTER] , [3: FILE CABINET] , ...12 more... )
• DEPTH ( type: esriFieldTypeDouble, alias: DEPTH, editable: true, nullable: true, defaultValue: null, modelName: DEPTH )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• Enabled ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: 1, modelName: Enabled , Coded Values: [0: False] , [1: True] )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 150, defaultValue: null, modelName: NOTES )
• FITTINGTYP ( type: esriFieldTypeString, alias: FITTINGTYP, editable: true, nullable: true, length: 15, defaultValue: 12, modelName: FITTINGTYPE , Coded Values: [1: Bend] , [2: Cap] , [3: Coupling] , ...13 more... )

Types:

ID: 1
Name: Bend
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 1
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 1
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 2
Name: Cap
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 2
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 2
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 3
Name: Coupling
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 3
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 3
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 4
Name: Cross
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 4
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 4
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 5
Name: ExpansionJoint
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 5
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 5
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 6
Name: Offset
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 6
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 6
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 7
Name: Other
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 7
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 7
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 8
Name: Reducer
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 8
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 8
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 9
Name: Riser
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 9
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 9
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 10
Name: Saddle
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 10
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 10
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 11
Name: Sleeve
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 11
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 11
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 12
Name: Tap
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 12
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 12
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 13
Name: Tee
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 13
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 13
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 14
Name: Unknown
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 14
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 14
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 15
Name: Weld
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 15
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 15
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: 16
Name: Wye
Domains:
• LIFECYCLES:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• FITTINGTYP:
  Inherited
Templates:
• Name: 16
  Description:
  Prototype:
  NOTES: null
  AncillaryRole: null
  FacilityID: null
  LocationDescription: null
  Rotation: null
  LIFECYCLES: Active
  POINT_X: null
  POINT_Y: null
  POINT_Z: null
  Enabled: 1
  FITTINGTYP: 16
  DEPTH: null
  INF_SOURCE: 5
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  
  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 ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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