View In:   ArcGIS Online Map Viewer

Name: VNB Water Main Breaks

Display Field: STREETNAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 32000

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: -17463800
YMin: -46132600
XMax: 1134103.4389612451
YMax: 1998480.8908609077
Spatial Reference: 102671  (3435)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: MainBreakStatus
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Active
  Label: Active
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [85, 255, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Retired
  Label: Retired
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [115, 223, 255, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
• Value: Unknown
  Label: Unknown
  Description: N/A
  Symbol:
  Style: esriSMSCircle
  Color: [255, 255, 0, 255]
  Size: 6.0
  Angle: 0.0
  XOffset: 0
  YOffset: 0
  Outline:
  [0, 0, 0, 255] Width: 1
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: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: MainBreakStatus

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• REPAIR_DATE ( type: esriFieldTypeDate, alias: Repair Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REPAIR_DATE )
• ADDRESS ( type: esriFieldTypeSmallInteger, alias: Address Number, editable: true, nullable: true, defaultValue: null, modelName: ADDRESS )
• STREETNAME ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 100, defaultValue: null, modelName: STREETNAME , Coded Values: [ACADEMY DR: ACADEMY DR] , [ACORN LN: ACORN LN] , [ADAMS LN: ADAMS LN] , ...636 more... )
• MAIN_SIZE ( type: esriFieldTypeString, alias: Main Size, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAIN_SIZE , Coded Values: [1: 1] , [1-1/2: 1-1/2] , [2: 2] , ...15 more... )
• BREAK_TYPE ( type: esriFieldTypeString, alias: Break Type, editable: true, nullable: true, length: 50, defaultValue: null, modelName: BREAK_TYPE , Coded Values: [Accident: Accident] , [Bolt: Bolt] , [Corp: Corp] , ...5 more... )
• GENERAL_LOC ( type: esriFieldTypeString, alias: General Location of Repair, editable: true, nullable: true, length: 50, defaultValue: null, modelName: GENERAL_LOC , Coded Values: [Backyard: Backyard] , [Driveway: Driveway] , [Front yard: Front yard] , ...4 more... )
• REPAIR_MEASU ( type: esriFieldTypeString, alias: Repair/Sleeve Location Measurements, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REPAIR_MEASU )
• UTIL_MEASU ( type: esriFieldTypeString, alias: Other Utility Measurements, editable: true, nullable: true, length: 255, defaultValue: null, modelName: UTIL_MEASU )
• MAIN_MAT ( type: esriFieldTypeString, alias: Main Material, editable: true, nullable: true, length: 50, defaultValue: null, modelName: MAIN_MAT , Coded Values: [Asbestos Concrete: Asbestos Concrete] , [Cast Iron: Cast Iron] , [Concrete: Concrete] , ...6 more... )
• SAMPLE_LOC ( type: esriFieldTypeString, alias: Cl2 Sample Location, editable: true, nullable: true, length: 50, defaultValue: null, modelName: SAMPLE_LOC , Coded Values: [Hydrant: Hydrant] , [Other: Other] )
• JULIE_NUM ( type: esriFieldTypeString, alias: Julie Number, editable: true, nullable: true, length: 50, defaultValue: null, modelName: JULIE_NUM )
• DATE_OFF ( type: esriFieldTypeDate, alias: Date Off, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_OFF )
• TIME_OFF ( type: esriFieldTypeString, alias: Time Off, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TIME_OFF )
• DATE_ON ( type: esriFieldTypeDate, alias: Date On, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_ON )
• TIME_ON ( type: esriFieldTypeString, alias: Time On, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TIME_ON )
• REPAIR_MAT ( type: esriFieldTypeString, alias: Repair Materials, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SLEEVE_DIA )
• VALVES_CLOSE ( type: esriFieldTypeString, alias: Valves Closed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: VALVES_CLOSE )
• COMMENTS ( type: esriFieldTypeString, alias: Description of Events, editable: true, nullable: true, length: 400, defaultValue: null, modelName: COMMENTS )
• PERSONNEL ( type: esriFieldTypeString, alias: Personnel, editable: true, nullable: true, length: 150, defaultValue: null, modelName: PERSONNEL )
• ISSUE ( type: esriFieldTypeSmallInteger, alias: Follow Up Needed, editable: true, nullable: true, defaultValue: null, modelName: ISSUE , Coded Values: [0: No] , [1: Yes] )
• ISSUE_COMM ( type: esriFieldTypeString, alias: Issue(s) Description, editable: true, nullable: true, length: 400, defaultValue: null, modelName: ISSUE_COMM )
• ISSUE_RES_DATE ( type: esriFieldTypeDate, alias: Date Issue Resolved, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ISSUE_RES_DATE )
• HYPERLINK ( type: esriFieldTypeString, alias: Laserfiche Link, editable: true, nullable: true, length: 300, defaultValue: null, modelName: HYPERLINK )
• CL2_RES ( type: esriFieldTypeDouble, alias: CL2_RES, editable: true, nullable: true, defaultValue: null, modelName: CL2_RES )
• MainBreakStatus ( type: esriFieldTypeString, alias: MainBreakStatus, editable: true, nullable: true, length: 25, defaultValue: Active, modelName: MainBreakStatus , Coded Values: [Active: Active] , [Retired: Retired] )
• 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 )
• MAIN_DEPTH ( type: esriFieldTypeDouble, alias: Main Depth, editable: true, nullable: true, defaultValue: null, modelName: MAIN_DEPTH )
• SupervisorReview ( type: esriFieldTypeDate, alias: Supervisor Review Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: SupervisorReview )
• RestorationLoc1 ( type: esriFieldTypeString, alias: Restoration Location 1, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RestorationLoc1 , Coded Values: [Curb: Curb] , [Driveway: Driveway] , [Sidewalk: Sidewalk] , ...3 more... )
• RestorationType1 ( type: esriFieldTypeString, alias: Restoration Type 1, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RestorationType1 , Coded Values: [Asphalt: Asphalt] , [Brick Pavers: Brick Pavers] , [Concrete: Concrete] , ...3 more... )
• RestorationSize1 ( type: esriFieldTypeString, alias: Restoration Size 1, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RestorationSize1 )
• RestorationComplete ( type: esriFieldTypeDate, alias: Restoration Completed 1, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RestorationComplete )
• RestorationLoc2 ( type: esriFieldTypeString, alias: Restoration Location 2, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RestorationLoc2 , Coded Values: [Curb: Curb] , [Driveway: Driveway] , [Sidewalk: Sidewalk] , ...3 more... )
• RestorationType2 ( type: esriFieldTypeString, alias: Restoration Type 2, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RestorationType2 , Coded Values: [Asphalt: Asphalt] , [Brick Pavers: Brick Pavers] , [Concrete: Concrete] , ...3 more... )
• RestorationSize2 ( type: esriFieldTypeString, alias: Restoration Size 2, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RestorationSize2 )
• RestorationCompete2 ( type: esriFieldTypeDate, alias: Restoration Completed 2, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RestorationCompete2 )
• RestorationLoc3 ( type: esriFieldTypeString, alias: Restoration Location 3, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RestorationLoc3 , Coded Values: [Curb: Curb] , [Driveway: Driveway] , [Sidewalk: Sidewalk] , ...3 more... )
• RestorationType3 ( type: esriFieldTypeString, alias: Restoration Type 3, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RestorationType3 , Coded Values: [Asphalt: Asphalt] , [Brick Pavers: Brick Pavers] , [Concrete: Concrete] , ...3 more... )
• RestorationSize3 ( type: esriFieldTypeString, alias: Restoration Size 3, editable: true, nullable: true, length: 250, defaultValue: null, modelName: RestorationSize3 )
• RestorationCompleted3 ( type: esriFieldTypeDate, alias: Restoration Completed 3, editable: true, nullable: true, length: 8, defaultValue: null, modelName: RestorationCompleted3 )
• IrrigationDamaged ( type: esriFieldTypeString, alias: Irrigation Damaged, editable: true, nullable: true, length: 50, defaultValue: null, modelName: IrrigationDamaged , Coded Values: [Yes: Yes] , [No: No] , [Repaired: Repaired] )
• TreeRemoved ( type: esriFieldTypeString, alias: Tree Removed, editable: true, nullable: true, length: 50, defaultValue: null, modelName: TreeRemoved )
• AtlasSection ( type: esriFieldTypeString, alias: Atlas Section, editable: true, nullable: true, length: 10, defaultValue: null, modelName: AtlasSection , Coded Values: [1B: 1B] , [1C: 1C] , [1D: 1D] , ...128 more... )
• ApprovedBySupervisor ( type: esriFieldTypeString, alias: Approved by Supervisor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ApprovedBySupervisor , Coded Values: [YES: Yes] , [NO: No] )
• REPORTPREPAREDBY ( type: esriFieldTypeString, alias: REPORTPREPAREDBY, editable: true, nullable: true, length: 100, defaultValue: null, modelName: REPORTPREPAREDBY )
• OTHERCOMMENTS ( type: esriFieldTypeString, alias: OTHERCOMMENTS, editable: true, nullable: true, length: 255, defaultValue: null, modelName: OTHERCOMMENTS )
• HISTORICALCOMMENTS ( type: esriFieldTypeString, alias: Historical Comments, editable: true, nullable: true, length: 700, defaultValue: null, modelName: HISTORICALCOMMENTS )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• PressureZone ( type: esriFieldTypeString, alias: PressureZone, editable: true, nullable: true, length: 5, defaultValue: null, modelName: PressureZone , Coded Values: [1: 1] , [2: 2] )

Types:

ID: Active
Name: Active
Domains:
• STREETNAME:
  Inherited
• MAIN_SIZE:
  Inherited
• BREAK_TYPE:
  Inherited
• GENERAL_LOC:
  Inherited
• MAIN_MAT:
  Inherited
• SAMPLE_LOC:
  Inherited
• ISSUE:
  Inherited
• MainBreakStatus:
  Inherited
• RestorationLoc1:
  Inherited
• RestorationType1:
  Inherited
• RestorationLoc2:
  Inherited
• RestorationType2:
  Inherited
• RestorationLoc3:
  Inherited
• RestorationType3:
  Inherited
• IrrigationDamaged:
  Inherited
• AtlasSection:
  Inherited
• ApprovedBySupervisor:
  Inherited
• PressureZone:
  Inherited
Templates:
• Name: Active
  Description:
  Prototype:
  CL2_RES: null
  AtlasSection: null
  PERSONNEL: null
  PressureZone: null
  REPAIR_DATE: null
  ADDRESS: null
  STREETNAME: null
  MAIN_SIZE: null
  BREAK_TYPE: null
  GENERAL_LOC: null
  REPAIR_MEASU: null
  UTIL_MEASU: null
  MAIN_MAT: null
  SAMPLE_LOC: null
  JULIE_NUM: null
  DATE_OFF: null
  TIME_OFF: null
  DATE_ON: null
  TIME_ON: null
  REPAIR_MAT: null
  VALVES_CLOSE: null
  COMMENTS: null
  ISSUE: 0
  ISSUE_COMM: null
  ISSUE_RES_DATE: null
  HYPERLINK: null
  MainBreakStatus: Active
  HISTORICALCOMMENTS: null
  OTHERCOMMENTS: null
  REPORTPREPAREDBY: null
  ApprovedBySupervisor: No
  MAIN_DEPTH: null
  SupervisorReview: null
  RestorationLoc1: null
  RestorationType1: null
  RestorationSize1: null
  RestorationComplete: null
  RestorationLoc2: null
  RestorationType2: null
  RestorationSize2: null
  RestorationCompete2: null
  RestorationLoc3: null
  RestorationType3: null
  RestorationSize3: null
  RestorationCompleted3: null
  IrrigationDamaged: null
  TreeRemoved: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Retired
Name: Retired
Domains:
• STREETNAME:
  Inherited
• MAIN_SIZE:
  Inherited
• BREAK_TYPE:
  Inherited
• GENERAL_LOC:
  Inherited
• MAIN_MAT:
  Inherited
• SAMPLE_LOC:
  Inherited
• ISSUE:
  Inherited
• MainBreakStatus:
  Inherited
• RestorationLoc1:
  Inherited
• RestorationType1:
  Inherited
• RestorationLoc2:
  Inherited
• RestorationType2:
  Inherited
• RestorationLoc3:
  Inherited
• RestorationType3:
  Inherited
• IrrigationDamaged:
  Inherited
• AtlasSection:
  Inherited
• ApprovedBySupervisor:
  Inherited
• PressureZone:
  Inherited
Templates:
• Name: Retired
  Description:
  Prototype:
  CL2_RES: null
  AtlasSection: null
  PERSONNEL: null
  PressureZone: null
  REPAIR_DATE: null
  ADDRESS: null
  STREETNAME: null
  MAIN_SIZE: null
  BREAK_TYPE: null
  GENERAL_LOC: null
  REPAIR_MEASU: null
  UTIL_MEASU: null
  MAIN_MAT: null
  SAMPLE_LOC: null
  JULIE_NUM: null
  DATE_OFF: null
  TIME_OFF: null
  DATE_ON: null
  TIME_ON: null
  REPAIR_MAT: null
  VALVES_CLOSE: null
  COMMENTS: null
  ISSUE: 0
  ISSUE_COMM: null
  ISSUE_RES_DATE: null
  HYPERLINK: null
  MainBreakStatus: Retired
  HISTORICALCOMMENTS: null
  OTHERCOMMENTS: null
  REPORTPREPAREDBY: null
  ApprovedBySupervisor: No
  MAIN_DEPTH: null
  SupervisorReview: null
  RestorationLoc1: null
  RestorationType1: null
  RestorationSize1: null
  RestorationComplete: null
  RestorationLoc2: null
  RestorationType2: null
  RestorationSize2: null
  RestorationCompete2: null
  RestorationLoc3: null
  RestorationType3: null
  RestorationSize3: null
  RestorationCompleted3: null
  IrrigationDamaged: null
  TreeRemoved: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

ID: Unknown
Name: Unknown
Domains:
• STREETNAME:
  Inherited
• MAIN_SIZE:
  Inherited
• BREAK_TYPE:
  Inherited
• GENERAL_LOC:
  Inherited
• MAIN_MAT:
  Inherited
• SAMPLE_LOC:
  Inherited
• ISSUE:
  Inherited
• MainBreakStatus:
  Inherited
• RestorationLoc1:
  Inherited
• RestorationType1:
  Inherited
• RestorationLoc2:
  Inherited
• RestorationType2:
  Inherited
• RestorationLoc3:
  Inherited
• RestorationType3:
  Inherited
• IrrigationDamaged:
  Inherited
• AtlasSection:
  Inherited
• ApprovedBySupervisor:
  Inherited
• PressureZone:
  Inherited
Templates:
• Name: Unknown
  Description:
  Prototype:
  CL2_RES: null
  AtlasSection: null
  PERSONNEL: null
  PressureZone: null
  REPAIR_DATE: null
  ADDRESS: null
  STREETNAME: null
  MAIN_SIZE: null
  BREAK_TYPE: null
  GENERAL_LOC: null
  REPAIR_MEASU: null
  UTIL_MEASU: null
  MAIN_MAT: null
  SAMPLE_LOC: null
  JULIE_NUM: null
  DATE_OFF: null
  TIME_OFF: null
  DATE_ON: null
  TIME_ON: null
  REPAIR_MAT: null
  VALVES_CLOSE: null
  COMMENTS: null
  ISSUE: 0
  ISSUE_COMM: null
  ISSUE_RES_DATE: null
  HYPERLINK: null
  MainBreakStatus: Unknown
  HISTORICALCOMMENTS: null
  OTHERCOMMENTS: null
  REPORTPREPAREDBY: null
  ApprovedBySupervisor: No
  MAIN_DEPTH: null
  SupervisorReview: null
  RestorationLoc1: null
  RestorationType1: null
  RestorationSize1: null
  RestorationComplete: null
  RestorationLoc2: null
  RestorationType2: null
  RestorationSize2: null
  RestorationCompete2: null
  RestorationLoc3: null
  RestorationType3: null
  RestorationSize3: null
  RestorationCompleted3: null
  IrrigationDamaged: null
  TreeRemoved: null
  
  Drawing Tool: esriFeatureEditToolPoint

---

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

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   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata