View In:   ArcGIS Online map viewer

Name: Water main breaks

Display Field: ID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Original: This point feature class is a collection of main breaks found within the City of Rockville's water distribution system for breaks that occurred between 12/19/79 and 6/13/2017.Supplemental: Locations are still being added until a suitable replacement can be created. Historical data about leaks on main and services are also being added. The break type column is being used to record this type and will correspond with the tab in the spreadsheets that O&M uses. Notes are being used to store the info for main_break bc it is currently a drop down menu.

Copyright Text: City of Rockville

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON, PBF

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: 1250860.860827282
YMin: 497488.8888043463
XMax: 1279702.385493189
YMax: 525158.5568901002
Spatial Reference: 102685  (2248)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID_1 ( type: esriFieldTypeOID, alias: OBJECTID_1, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID_1 )
• ID ( type: esriFieldTypeString, alias: ID, editable: true, nullable: true, length: 32, defaultValue: null, modelName: ID )
• DATE_OF_BREAK ( type: esriFieldTypeDate, alias: Date of Break, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_ )
• WORK_ORDER ( type: esriFieldTypeString, alias: WORK_ORDER, editable: true, nullable: true, length: 10, defaultValue: null, modelName: WORK_ORDER )
• ADDRESS ( type: esriFieldTypeString, alias: ADDRESS, editable: true, nullable: true, length: 60, defaultValue: null, modelName: ADDRESS )
• MAIN_BREAK ( type: esriFieldTypeString, alias: MAIN_BREAK, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MAIN_BREAK , Coded Values: [Circular: Circular] , [Longitudinal: Longitudinal] , [Split: Split] , ...2 more... )
• NOTES ( type: esriFieldTypeString, alias: NOTES, editable: true, nullable: true, length: 199, defaultValue: null, modelName: NOTES )
• BREAK_TYPE_NOTES ( type: esriFieldTypeString, alias: BREAK_TYPE, editable: true, nullable: true, length: 199, defaultValue: null, modelName: BREAK_TYPE )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: COMMENTS )
• REPAIR_TYPE ( type: esriFieldTypeString, alias: REPAIR_TYPE, editable: true, nullable: true, length: 50, defaultValue: null, modelName: REPAIR_TYPE )
• 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 )
• FiscalYear ( type: esriFieldTypeString, alias: Fiscal Year, editable: true, nullable: true, length: 4, defaultValue: null, modelName: FiscalYear )
• STATUS ( type: esriFieldTypeString, alias: STATUS, editable: true, nullable: true, length: 50, defaultValue: null, modelName: STATUS )

Templates:

• Name: Water main breaks
  Description:
  Prototype:
  FiscalYear: null
  STATUS: null
  ID: null
  DATE_OF_BREAK: null
  WORK_ORDER: null
  ADDRESS: null
  MAIN_BREAK: null
  NOTES: null
  BREAK_TYPE_NOTES: null
  COMMENTS: null
  REPAIR_TYPE: null
  
  Drawing Tool: esriFeatureEditToolPoint

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

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