View In:   ArcGIS Online Map Viewer

Name: Water Mains

Display Field: FACILITYID

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Service Item Id: 5a82be555a4f4e7298a64529a4e9d46d

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

Supported Query Formats: JSON, geoJSON

Min Scale: 6000

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: false

Supports Datum Transformation: true

Extent:

XMin: 970609.5549938828
YMin: 1990855.5626911297
XMax: 1004764.9735549241
YMax: 2007671.4256315455
Spatial Reference: 102671  (3435)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 112, 255, 255]
Width: 2
Label:
Description:
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 ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• FACILITYID ( type: esriFieldTypeString, alias: Facility Identifier, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• ADDRESS ( type: esriFieldTypeString, alias: Address, editable: true, nullable: true, length: 50, defaultValue: null, modelName: ADDRESS )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• MATERIAL ( type: esriFieldTypeString, alias: Water Main Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MATERIAL , Coded Values: [CAST IRON: Cast Iron] , [DUCTILE IRON: Ductile Iron] , [POLYVINYL CHLORIDE: Polyvinyl Chloride] , ...1 more... )
• DIAMETER ( type: esriFieldTypeDouble, alias: Water Main Diameter (Inch), editable: true, nullable: true, defaultValue: null, modelName: DIAMETER , Coded Values: [2: 2] , [4: 4] , [6: 6] , ...6 more... )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Main Type, editable: true, nullable: true, length: 30, defaultValue: Potable, modelName: WATERTYPE , Coded Values: [Potable Water: Potable Water] , [Raw Water: Raw Water] )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [1: Village of Algonquin] , [-1: Algonquin Township] , [-2: Commercial] , ...27 more... )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Maintained By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [0: Algonquin Public Works] , [1: Village of Algonquin] , [-1: Algonquin Township] , ...27 more... )
• LASTUPDATE ( type: esriFieldTypeDate, alias: Last Update Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LASTUPDATE )
• LASTEDITOR ( type: esriFieldTypeString, alias: Last Editor, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTEDITOR )
• GISID ( type: esriFieldTypeString, alias: GIS ID, editable: true, nullable: true, length: 15, defaultValue: null, modelName: GISID )
• WATERID ( type: esriFieldTypeDouble, alias: Water ID, editable: true, nullable: true, defaultValue: null, modelName: WATERID )
• STATUS ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 10, defaultValue: null, modelName: STATUS , Coded Values: [Active: Active] , [Removed: Permanently Removed] , [Abandon: Abandoned] , ...3 more... )
• LOCATION ( type: esriFieldTypeString, alias: Location, editable: true, nullable: true, length: 35, defaultValue: null, modelName: LOCATION )
• SERVICEAGREEMENT ( type: esriFieldTypeString, alias: Service Agreement, editable: true, nullable: true, length: 75, defaultValue: null, modelName: SERVICEAGREEMENT )
• USEFULLIFE ( type: esriFieldTypeSmallInteger, alias: Useful Life, editable: true, nullable: true, defaultValue: null, modelName: USEFULLIFE )
• 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 )
• CALCRC ( type: esriFieldTypeInteger, alias: Calculated Replacement Cost, editable: true, nullable: true, defaultValue: null, modelName: CALCRC )
• AGE ( type: esriFieldTypeSmallInteger, alias: Age (yrs), editable: true, nullable: true, defaultValue: null, modelName: AGE )
• AAAC ( type: esriFieldTypeDouble, alias: Annual Average Asset Consumption, editable: true, nullable: true, defaultValue: null, modelName: AAAC )
• HISTCOST ( type: esriFieldTypeDouble, alias: Historical Cost, editable: true, nullable: true, defaultValue: null, modelName: HISTCOST )
• LENGTH ( type: esriFieldTypeDouble, alias: Length In Feet, editable: true, nullable: true, defaultValue: null, modelName: LENGTH )
• SIZERATING ( type: esriFieldTypeSmallInteger, alias: Main Size Rating, editable: true, nullable: true, defaultValue: null, modelName: SIZERATING )
• MATERIALRATING ( type: esriFieldTypeSmallInteger, alias: Main Material Rating, editable: true, nullable: true, defaultValue: null, modelName: MATERIALRATING )
• NUMMAINBREAK ( type: esriFieldTypeSmallInteger, alias: Number Of Water Main Breaks, editable: true, nullable: true, defaultValue: null, modelName: NUMMAINBREAK )

Templates:

• Name: Water Mains
  Description:
  Prototype:
  DIAMETER: null
  WATERTYPE: Potable
  OWNEDBY: 1
  NUMMAINBREAK: null
  FACILITYID: null
  ADDRESS: null
  INSTALLDATE: null
  MATERIAL: null
  MAINTBY: 1
  LASTUPDATE: null
  LASTEDITOR: null
  GISID: null
  WATERID: null
  STATUS: null
  LOCATION: null
  SERVICEAGREEMENT: null
  USEFULLIFE: null
  MATERIALRATING: null
  SIZERATING: null
  LENGTH: null
  HISTCOST: null
  CALCRC: null
  AGE: null
  AAAC: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Create,Update,Uploads,Editing

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