View In:   ArcGIS Online Map Viewer

Name: Water Main

Display Field: AssetID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: City of New Bern water main data showing location, pipe size, pipe material, status

Service Item Id: 28bdc03017304ba7ad7aa08757481dc6

Copyright Text:

Default Visibility: true

MaxRecordCount: 10000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 60000.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: true

Supports Datum Transformation: true

Extent:

XMin: 2500334.61588639
YMin: 460384.44655014575
XMax: 2601221.692983225
YMax: 527058.882098645
Spatial Reference: 102719  (2264)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: STATUS
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
Style: esriSLSSolid
Color: [205, 46, 49, 255]
Width: 1
Default Label: <all other values>
UniqueValueInfos:
• Value: ABANDONED
  Label: ABANDONED
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 0, 0, 255]
  Width: 1
• Value: IN SERVICE
  Label: IN SERVICE
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [0, 112, 255, 255]
  Width: 2
• Value: NOT ACCEPTED
  Label: NOT ACCEPTED
  Description: N/A
  Symbol:
  Style: esriSLSDash
  Color: [0, 112, 255, 255]
  Width: 2
• Value: PRIVATE
  Label: PRIVATE
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [115, 223, 255, 255]
  Width: 2
• Value: UNKNOWN
  Label: UNKNOWN
  Description: N/A
  Symbol:
  Style: esriSLSSolid
  Color: [230, 152, 0, 255]
  Width: 2
Transparency: 0
Labeling Info:
Label Placement: esriServerLinePlacementAboveAlong
Label Expression: [SIZE]
Use Coded Values: true
Symbol:
Color: [0, 92, 230, 255]
Background Color: N/A
Outline Color: N/A
Vertical Alignment: bottom
Horizontal Alignment: center
Right to Left: false
Angle: 0
XOffset: 0
YOffset: 0
Size: 10
Font Family: Arial
Font Style: normal
Font Weight: bold
Font Decoration: none

Min. Scale: 5001.0
Max. Scale: 0.0

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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: STATUS

Fields:

• AssetID ( type: esriFieldTypeString, alias: AssetID, editable: true, nullable: true, length: 50, defaultValue: null, modelName: AssetID )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• PURPOSE ( type: esriFieldTypeString, alias: PURPOSE, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PURPOSE )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 25, defaultValue: null, modelName: STATUS )
• SIZE ( type: esriFieldTypeDouble, alias: SIZE, editable: true, nullable: true, defaultValue: null, modelName: SIZE )
• YEAR_CON ( type: esriFieldTypeString, alias: YEAR_CON, editable: true, nullable: true, length: 8, defaultValue: null, modelName: YEAR_CON )
• MATERIAL ( type: esriFieldTypeString, alias: MATERIAL, editable: true, nullable: true, length: 25, defaultValue: null, modelName: MATERIAL )
• COMMMENT ( type: esriFieldTypeString, alias: COMMMENT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: COMMMENT )
• DBO.wat_main.ENTITY ( type: esriFieldTypeString, alias: DBO.wat_main.ENTITY, editable: true, nullable: true, length: 14, defaultValue: null, modelName: DBO.wat_main.ENTITY )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )

Types:

ID: ABANDONED
Name: ABANDONED
Domains:
Templates:
• Name: ABANDONED
  Description:
  Prototype:
  DBO.wat_main.ENTITY: null
  AssetID: null
  COMMMENT: null
  PURPOSE: null
  STATUS: ABANDONED
  SIZE: null
  YEAR_CON: null
  MATERIAL: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: IN SERVICE
Name: IN SERVICE
Domains:
Templates:
• Name: IN SERVICE
  Description:
  Prototype:
  MATERIAL:
  STATUS: IN SERVICE
  COMMMENT:
  SIZE: 0
  DBO.wat_main.ENTITY: null
  PURPOSE: DISTRIBUTION
  AssetID: null
  YEAR_CON:
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: NOT ACCEPTED
Name: NOT ACCEPTED
Domains:
Templates:
• Name: NOT ACCEPTED
  Description:
  Prototype:
  MATERIAL:
  STATUS: NOT ACCEPTED
  COMMMENT:
  SIZE: 0
  DBO.wat_main.ENTITY: null
  PURPOSE:
  AssetID: null
  YEAR_CON:
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: PRIVATE
Name: PRIVATE
Domains:
Templates:
• Name: PRIVATE
  Description:
  Prototype:
  DBO.wat_main.ENTITY: null
  AssetID: null
  COMMMENT: null
  PURPOSE: null
  STATUS: PRIVATE
  SIZE: null
  YEAR_CON: null
  MATERIAL: null
  
  Drawing Tool: esriFeatureEditToolLine

---

ID: UNKNOWN
Name: UNKNOWN
Domains:
Templates:
• Name: UNKNOWN
  Description:
  Prototype:
  MATERIAL:
  STATUS: UNKNOWN
  COMMMENT:
  SIZE: 0
  DBO.wat_main.ENTITY: null
  PURPOSE:
  AssetID: null
  YEAR_CON:
  
  Drawing Tool: esriFeatureEditToolLine

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

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