View In:   ArcGIS Online Map Viewer

Name: WaterMain

Display Field: CREATIONUSER

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

Copyright Text: Durham Region

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: 653526.5046
YMin: 4852851.5909
XMax: 663137.6039
YMax: 4864797.2379
Spatial Reference: 26917  (26917)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [0, 0, 0, 255]
Width: 7
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: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• CREATIONUSER ( type: esriFieldTypeString, alias: CREATIONUSER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: CREATIONUSER )
• DATECREATED ( type: esriFieldTypeDate, alias: DATECREATED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATECREATED )
• LASTUSER ( type: esriFieldTypeString, alias: LASTUSER, editable: true, nullable: true, length: 50, defaultValue: null, modelName: LASTUSER )
• DATEMODIFIED ( type: esriFieldTypeDate, alias: DATEMODIFIED, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATEMODIFIED )
• DATACAPTUREMETHOD ( type: esriFieldTypeString, alias: DataCaptureMethod, editable: true, nullable: true, length: 20, defaultValue: DIGITIZED, modelName: DataCaptureMethod )
• DATACAPTUREACCURACY ( type: esriFieldTypeString, alias: DataCaptureAccuracy, editable: true, nullable: true, length: 15, defaultValue: +/-5M, modelName: DataCaptureAccuracy )
• DATASOURCE ( type: esriFieldTypeString, alias: DataSource, editable: true, nullable: true, length: 15, defaultValue: PLAN, modelName: DataSource )
• CONTRACTNO ( type: esriFieldTypeString, alias: CONTRACTNO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CONTRACTNO )
• OWNERSHIP ( type: esriFieldTypeString, alias: Ownership, editable: true, nullable: true, length: 25, defaultValue: REGION OF DURHAM, modelName: Ownership )
• SETTLEMENTAREA ( type: esriFieldTypeString, alias: SettlementArea, editable: true, nullable: true, length: 25, defaultValue: null, modelName: SettlementArea )
• ADMINISTRATIVEAREA ( type: esriFieldTypeString, alias: ADMINISTRATIVEAREA, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ADMINISTRATIVEAREA )
• LOCALMUNICIPALITY ( type: esriFieldTypeString, alias: LocalMunicipality, editable: true, nullable: true, length: 20, defaultValue: null, modelName: LocalMunicipality )
• STRUCTURETYPE ( type: esriFieldTypeString, alias: STRUCTURETYPE, editable: true, nullable: true, length: 20, defaultValue: null, modelName: STRUCTURETYPE )
• GRIDNO ( type: esriFieldTypeString, alias: GRIDNO, editable: true, nullable: true, length: 20, defaultValue: null, modelName: GRIDNO )
• SEQUENCENO ( type: esriFieldTypeInteger, alias: SEQUENCENO, editable: true, nullable: true, defaultValue: null, modelName: SEQUENCENO )
• FACILITYID ( type: esriFieldTypeString, alias: FACILITYID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: FACILITYID )
• INSTALLDATE ( type: esriFieldTypeDate, alias: INSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• ABANDONED_DATE ( type: esriFieldTypeDate, alias: ABANDONED_DATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ABANDONED_DATE )
• DEPOTAREA ( type: esriFieldTypeString, alias: DepotArea, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DepotArea )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 15, defaultValue: ISSUED FOR CON, modelName: LifecycleStatus )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: SubtypeCD, editable: true, nullable: true, defaultValue: 1, modelName: SubtypeCD )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• CONDITION ( type: esriFieldTypeString, alias: CONDITION, editable: true, nullable: true, length: 100, defaultValue: null, modelName: CONDITION )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 10, defaultValue: PVC, modelName: Material )
• DIAMETER ( type: esriFieldTypeInteger, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: Diameter )
• LENGTH ( type: esriFieldTypeDouble, alias: LENGTH, editable: true, nullable: true, defaultValue: null, modelName: LENGTH )
• WATERTYPE ( type: esriFieldTypeString, alias: WaterType, editable: true, nullable: true, length: 10, defaultValue: POT, modelName: WaterType )
• LININGTYPE ( type: esriFieldTypeString, alias: LiningType, editable: true, nullable: true, length: 10, defaultValue: NONE, modelName: LiningType )
• LININGINSTALLDATE ( type: esriFieldTypeDate, alias: LININGINSTALLDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LININGINSTALLDATE )
• PIPECLASS ( type: esriFieldTypeString, alias: PIPECLASS, editable: true, nullable: true, length: 20, defaultValue: null, modelName: PIPECLASS )
• GROUNDSURFACETYPE ( type: esriFieldTypeString, alias: GroundSurfaceType, editable: true, nullable: true, length: 15, defaultValue: GRASS, modelName: GroundSurfaceType )
• UPSTREAMID ( type: esriFieldTypeString, alias: UPSTREAMID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: UPSTREAMID )
• DOWNSTREAMID ( type: esriFieldTypeString, alias: DOWNSTREAMID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DOWNSTREAMID )
• PRESSUREZONE ( type: esriFieldTypeString, alias: PRESSUREZONE, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PRESSUREZONE )
• CATHODPROT ( type: esriFieldTypeString, alias: Cathodprot, editable: true, nullable: true, length: 5, defaultValue: null, modelName: CATHODPROT )
• CATHINSTALLDATE ( type: esriFieldTypeDate, alias: Install date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CATHINSTALLDATE )
• DATE_EST ( type: esriFieldTypeString, alias: DATE_EST, editable: true, nullable: true, length: 5, defaultValue: null, modelName: DATE_EST )
• DRAWING ( type: esriFieldTypeString, alias: DRAWING, editable: true, nullable: true, length: 255, defaultValue: null, modelName: DRAWING )
• SLRN ( type: esriFieldTypeDouble, alias: SLRN, editable: true, nullable: true, defaultValue: null, modelName: SLRN )
• CCT_RES ( type: esriFieldTypeString, alias: chlorine contact restrictions, editable: true, nullable: true, length: 10, defaultValue: NO, modelName: CCT_Res )
• MXCREATIONSTATE ( type: esriFieldTypeSmallInteger, alias: MXCREATIONSTATE, editable: true, nullable: true, defaultValue: null, modelName: MXCREATIONSTATE )
• MXSITEID ( type: esriFieldTypeString, alias: MXSITEID, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MXSITEID )
• MXASSETNUM ( type: esriFieldTypeString, alias: MXASSETNUM, editable: true, nullable: true, length: 12, defaultValue: null, modelName: MXASSETNUM )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• 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.LEN, editable: false, nullable: true, defaultValue: null, modelName: SHAPE.LEN )

Templates:

• Name: WaterMain
  Description:
  Prototype:
  MXSITEID: null
  MXASSETNUM: null
  CREATIONUSER: null
  DATECREATED: null
  LASTUSER: null
  DATEMODIFIED: null
  DATACAPTUREMETHOD: DIGITIZED
  DATACAPTUREACCURACY: +/-5M
  DATASOURCE: PLAN
  CONTRACTNO: null
  OWNERSHIP: REGION OF DURHAM
  SETTLEMENTAREA: null
  ADMINISTRATIVEAREA: null
  LOCALMUNICIPALITY: null
  STRUCTURETYPE: null
  GRIDNO: null
  SEQUENCENO: null
  FACILITYID: null
  INSTALLDATE: null
  ABANDONED_DATE: null
  DEPOTAREA: null
  LIFECYCLESTATUS: ISSUED FOR CON
  SUBTYPECD: 1
  COMMENTS: null
  CONDITION: null
  MATERIAL: PVC
  DIAMETER: null
  LENGTH: null
  WATERTYPE: POT
  LININGTYPE: NONE
  LININGINSTALLDATE: null
  PIPECLASS: null
  GROUNDSURFACETYPE: GRASS
  UPSTREAMID: null
  DOWNSTREAMID: null
  PRESSUREZONE: null
  CATHODPROT: null
  CATHINSTALLDATE: null
  DATE_EST: null
  DRAWING: null
  SLRN: null
  CCT_RES: NO
  MXCREATIONSTATE: null
  
  Drawing Tool: esriFeatureEditToolLine

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Edit Fields Info:

• Creation Date Field:
• Creator Field:
• Edit Date Field: last_edited_date
• Editor Field:

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata