View In:   ArcGIS Online Map Viewer

Name: Water2018.SDE.wMAIN

Display Field: OBJNAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

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: 3046480.2192562222
YMin: 667119.7032220662
XMax: 3167159.8456786424
YMax: 816741.4079150558
Spatial Reference: 103152  (6576)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: Diameter
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: 0.75
  Label: 3/4"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [205, 170, 102, 255]
  Width: 4
• Value: 1
  Label: 1"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [128, 94, 0, 255]
  Width: 4
• Value: 2
  Label: 2"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [20, 43, 255, 255]
  Width: 4
• Value: 3
  Label: 3"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 167, 127, 255]
  Width: 4
• Value: 4
  Label: 4"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 85, 0, 255]
  Width: 4
• Value: 6
  Label: 6"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 0, 255]
  Width: 4
• Value: 8
  Label: 8"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 255, 0, 255]
  Width: 4
• Value: 10
  Label: 10"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 0, 197, 255]
  Width: 4
• Value: 12
  Label: 12"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 0, 0, 255]
  Width: 4
• Value: 14
  Label: 14"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [33, 255, 255, 255]
  Width: 4
• Value: 16
  Label: 16"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [85, 255, 0, 255]
  Width: 4
• Value: 18
  Label: 18"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [137, 68, 101, 255]
  Width: 4
• Value: 20
  Label: 20"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [68, 101, 137, 255]
  Width: 4
• Value: 24
  Label: 24"
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [156, 156, 156, 255]
  Width: 4
• Value: -1
  Label: Other
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [163, 255, 115, 255]
  Width: 4
• Value: 0
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [255, 190, 232, 255]
  Width: 4
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: Diameter

Fields:

• 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... )
• Diameter ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: 2, modelName: Diameter , Coded Values: [-1: Other] , [0: Unknown] , [0.75: 3/4"] , ...13 more... )
• 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 Year, 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape.STLength(), editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )
• 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] )
• Material ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: PVC, modelName: Material , Coded Values: [ABS: ABS Plastic] , [AC: Asbestos Cement] , [ASP: Asphalt] , ...33 more... )
• LINK_1 ( type: esriFieldTypeString, alias: LINK_1, editable: true, nullable: true, length: 200, defaultValue: null, modelName: LINK_1 )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 150, defaultValue: null, modelName: NOTES )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH, editable: true, nullable: true, defaultValue: null, modelName: LENGTH )

Types:

ID: 0.75
Name: 3/4"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 0.75
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 0.75
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 1
Name: 1"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 1
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 1
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 2
Name: 2"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 2
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 2
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 3
Name: 3"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 3
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 3
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 4
Name: 4"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 4
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 4
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 6
Name: 6"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 6
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 6
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 8
Name: 8"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 8
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 8
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 10
Name: 10"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 10
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 10
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 12
Name: 12"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 12
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 12
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 14
Name: 14"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 14
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 14
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 16
Name: 16"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 16
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 16
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 18
Name: 18"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 18
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 18
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 20
Name: 20"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 20
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 20
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 24
Name: 24"
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 24
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 24
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: -1
Name: Other
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: -1
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: -1
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: 0
Name: Unknown
Domains:
• LIFECYCLES:
  Inherited
• Diameter:
  Inherited
• SURVEYED:
  Inherited
• INF_SOURCE:
  Inherited
• Enabled:
  Inherited
• Material:
  Inherited
Templates:
• Name: 0
  Description:
  Prototype:
  NOTES: null
  LIFECYCLES: Active
  Diameter: 0
  Material: PVC
  Enabled: 1
  LENGTH: null
  LINK_1: null
  OBJNAME: null
  CODEDESC: null
  INSTALL_YE: 9999
  SURVEYED: 0
  INF_SOURCE: 5
  DEPTH: null
  
  Drawing Tool: esriFeatureEditToolLine

---

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