View In:   ArcGIS Online Map Viewer

Name: Water Lines

Display Field: MATL

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: This layer represents the current water main locations and design throughout the City of Chesapeake. Data is created from digitization of as-builts, approved plans, and field notes/drawings. Data is updated by Public Utilities GIS personnel as it becomes available.MAXIMO NUMBER - Unique asset number generated from Planimetric Page Number, Intersection Number, Asset Type and a non repeating number identifying a pipe per intersectionSTATUS - Active, Not-Active, OtherOWNER - 0-Chesapeake, 1-HRSD, 2-OtherDOWNSTRMPT - The Maximo asset number of the closest downstream assetUPSTRMPT - The Maximo asset numer of the closest upstream assetMASSETLOC - A Maximo realated number that helps identify all assets within a apecific planimetric sheet

Service Item Id: 17db632246424853a6c570f2839991e9

Copyright Text: City of Chesapeake Department of Public Utilities

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

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

Supports Datum Transformation: true

Extent:

XMin: 1.208073123141E7
YMin: 3374823.20601429
XMax: 1.2179722102243334E7
YMax: 3481350.0841392875
Spatial Reference: 102747  (2284)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 112, 255, 255]
Width: 2
Label: N/A
Description: N/A
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
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: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• MATL ( type: esriFieldTypeString, alias: MATL, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MATL , Coded Values: [ABS: ABS] , [AC: AC] , [CI: CI] , ...16 more... )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 50, defaultValue: null, modelName: NOTES )
• PROJECT ( type: esriFieldTypeString, alias: PROJECT, editable: true, nullable: true, length: 50, defaultValue: null, modelName: PROJECT )
• SOURCE ( type: esriFieldTypeString, alias: SOURCE, editable: true, nullable: true, length: 24, defaultValue: null, modelName: SOURCE , Coded Values: [Approved Plan: Approved Plan] , [Approved Plan Existing: Approved Plan Existing] , [City Survey: City Survey] , ...9 more... )
• STREET ( type: esriFieldTypeString, alias: STREET, editable: true, nullable: true, length: 36, defaultValue: null, modelName: STREET )
• IDENTIFIER ( type: esriFieldTypeString, alias: IDENTIFIER, editable: true, nullable: true, length: 25, defaultValue: null, modelName: IDENTIFIER , Coded Values: [Distribution: Distribution] , [Transmission: Transmission] )
• DIAMETER ( type: esriFieldTypeSmallInteger, alias: DIAMETER, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• INST_YEAR ( type: esriFieldTypeString, alias: INST_YEAR, editable: true, nullable: true, length: 18, defaultValue: null, modelName: INST_YEAR )
• PAGENUM ( type: esriFieldTypeString, alias: PAGENUM, editable: true, nullable: true, length: 6, defaultValue: null, modelName: PAGENUM )
• INTNUM ( type: esriFieldTypeString, alias: INTNUM, editable: true, nullable: true, length: 6, defaultValue: null, modelName: INTNUM )
• ASSETTYPE ( type: esriFieldTypeString, alias: ASSETTYPE, editable: true, nullable: true, length: 4, defaultValue: WDM, modelName: ASSETTYPE )
• ASSETNUM ( type: esriFieldTypeString, alias: ASSETNUM, editable: true, nullable: true, length: 6, defaultValue: null, modelName: ASSETNUM )
• MXASSETNUM ( type: esriFieldTypeString, alias: MXASSETNUM, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MXASSETNUM )
• MXSITEID ( type: esriFieldTypeString, alias: MXSITEID, editable: true, nullable: true, length: 8, defaultValue: COC, modelName: MXSITEID )
• MXCREATIONSTATE ( type: esriFieldTypeSmallInteger, alias: MXCREATIONSTATE, editable: true, nullable: true, defaultValue: 6, modelName: MXCREATIONSTATE )
• DOWNSTRMPT ( type: esriFieldTypeString, alias: DOWNSTRMPT, editable: true, nullable: true, length: 16, defaultValue: null, modelName: DOWNSTRMPT )
• UPSTRMPT ( type: esriFieldTypeString, alias: UPSTRMPT, editable: true, nullable: true, length: 16, defaultValue: null, modelName: UPSTRMPT )
• MXASSETLOC ( type: esriFieldTypeString, alias: MXASSETLOC, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MXASSETLOC )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 16, defaultValue: null, modelName: STATUS , Coded Values: [ACTIVE: ACTIVE] , [NOT ACTIVE: NOT ACTIVE] , [OTHER: OTHER] )
• ROWSTAMP ( type: esriFieldTypeString, alias: ROWSTAMP, editable: true, nullable: true, length: 50, defaultValue: 0, modelName: ROWSTAMP )
• 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 )
• Shape__Length ( type: esriFieldTypeDouble, alias: SHAPE.STLength(), editable: false, nullable: true, defaultValue: null, modelName: SHAPE.STLength(), required: true )

Templates:

• Name: Water Lines
  Description:
  Prototype:
  STATUS: null
  ROWSTAMP: 0
  MATL: null
  NOTES: null
  PROJECT: null
  SOURCE: null
  STREET: null
  IDENTIFIER: null
  DIAMETER: null
  INST_YEAR: null
  PAGENUM: null
  INTNUM: null
  ASSETTYPE: WDM
  ASSETNUM: null
  MXASSETNUM: null
  MXSITEID: COC
  MXCREATIONSTATE: 6
  DOWNSTRMPT: null
  UPSTRMPT: null
  MXASSETLOC: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

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

Child Resources:   Field Groups   Contingent Values

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