View In:   ArcGIS Online Map Viewer

Name: WAT ControlValve

Display Field: CREATIONUSER

Type: Feature Layer

Geometry Type: esriGeometryPoint

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: 653594.1268
YMin: 4853572.3986
XMax: 663131.8492
YMax: 4864764.7331
Spatial Reference: 26917  (26917)  LatestVCSWkid(0)

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 ( 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: 50, 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 )
• ABANDONEDDATE ( type: esriFieldTypeDate, alias: ABANDONEDDATE, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ABANDONEDDATE )
• LOCATIONDESCRIPTION ( type: esriFieldTypeString, alias: LOCATIONDESCRIPTION, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCATIONDESCRIPTION )
• DEPOTAREA ( type: esriFieldTypeString, alias: DepotArea, editable: true, nullable: true, length: 20, defaultValue: null, modelName: DepotArea )
• ROTATION ( type: esriFieldTypeDouble, alias: Rotation, editable: true, nullable: true, defaultValue: 0, modelName: Rotation )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: LifecycleStatus, editable: true, nullable: true, length: 15, defaultValue: null, modelName: LifecycleStatus )
• SUBTYPECD ( type: esriFieldTypeInteger, alias: SubtypeCD, editable: true, nullable: true, defaultValue: 6, modelName: SubtypeCD )
• COMMENTS ( type: esriFieldTypeString, alias: COMMENTS, editable: true, nullable: true, length: 100, defaultValue: null, modelName: COMMENTS )
• ELEVATION ( type: esriFieldTypeDouble, alias: ELEVATION, editable: true, nullable: true, defaultValue: null, modelName: ELEVATION )
• WATERTYPE ( type: esriFieldTypeString, alias: WaterType, editable: true, nullable: true, length: 10, defaultValue: POT, modelName: WaterType )
• CURRENTPOSITION ( type: esriFieldTypeString, alias: CurrentPosition, editable: true, nullable: true, length: 10, defaultValue: OPEN100, modelName: CurrentPosition )
• DIAMETER ( type: esriFieldTypeInteger, alias: Diameter, editable: true, nullable: true, defaultValue: 300, modelName: Diameter )
• PRESSUREZONE ( type: esriFieldTypeString, alias: PressureZone, editable: true, nullable: true, length: 10, defaultValue: null, modelName: PressureZone )
• VLS_NO ( type: esriFieldTypeString, alias: VLS_NO, editable: true, nullable: true, length: 50, defaultValue: null, modelName: VLS_NO )
• WATERMAINID ( type: esriFieldTypeString, alias: WATERMAINID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: WATERMAINID )
• BYPASSVALVE ( type: esriFieldTypeString, alias: BypassValve, editable: true, nullable: true, length: 5, defaultValue: NO, modelName: BypassValve )
• CURRENTLYOPEN ( type: esriFieldTypeString, alias: CurrentlyOpen, editable: true, nullable: true, length: 5, defaultValue: YES, modelName: CurrentlyOpen )
• MOTORIZED ( type: esriFieldTypeString, alias: Motorized, editable: true, nullable: true, length: 5, defaultValue: NO, modelName: Motorized )
• NORMALLYOPEN ( type: esriFieldTypeString, alias: NormallyOpen, editable: true, nullable: true, length: 5, defaultValue: YES, modelName: NormallyOpen )
• TURNSTOCLOSE ( type: esriFieldTypeDouble, alias: TURNSTOCLOSE, editable: true, nullable: true, defaultValue: null, modelName: TURNSTOCLOSE )
• OPERABLE ( type: esriFieldTypeString, alias: Operable, editable: true, nullable: true, length: 5, defaultValue: YES, modelName: Operable )
• VALVETYPE ( type: esriFieldTypeString, alias: ValveType, editable: true, nullable: true, length: 10, defaultValue: GATE, modelName: ValveType )
• 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 )
• INSPECTION_YEAR ( type: esriFieldTypeString, alias: INSPECTION_YEAR, editable: true, nullable: true, length: 20, defaultValue: null, modelName: INSPECTION_YEAR )
• CHAMBERID ( type: esriFieldTypeString, alias: CHAMBERID, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CHAMBERID )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• ASSESSMENT_YEAR ( type: esriFieldTypeString, alias: ASSESSMENT_YEAR, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ASSESSMENT_YEAR )
• LAST_EDITED_DATE ( type: esriFieldTypeDate, alias: LAST_EDITED_DATE, editable: false, nullable: true, length: 8, defaultValue: null, modelName: LAST_EDITED_DATE )

Templates:

• Name: WAT ControlValve
  Description:
  Prototype:
  ASSESSMENT_YEAR: null
  CHAMBERID: 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
  ABANDONEDDATE: null
  LOCATIONDESCRIPTION: null
  DEPOTAREA: null
  ROTATION: 0
  LIFECYCLESTATUS: null
  SUBTYPECD: 6
  COMMENTS: null
  ELEVATION: null
  WATERTYPE: POT
  CURRENTPOSITION: OPEN100
  DIAMETER: 300
  PRESSUREZONE: null
  VLS_NO: null
  WATERMAINID: null
  BYPASSVALVE: NO
  CURRENTLYOPEN: YES
  MOTORIZED: NO
  NORMALLYOPEN: YES
  TURNSTOCLOSE: null
  OPERABLE: YES
  VALVETYPE: GATE
  MXCREATIONSTATE: null
  MXSITEID: null
  MXASSETNUM: null
  INSPECTION_YEAR: null
  
  Drawing Tool: esriFeatureEditToolPoint

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