Name: sde.DBO.SystemValveActivity_tbl

Display Field: computername

Type: Table

Geometry Type: N/A

Description:

Service Item Id: d67429b1456a4002b8433aed65c220c7

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

Drawing Info:

N/A

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: false
Supports Query With Distance: false
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: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• facilityid ( modelName: FACILITYID, nullable: true, editable: true, defaultValue: null, length: 20, alias: Facility Identifier, type: esriFieldTypeString )
• installdate ( modelName: INSTALLDATE, nullable: true, editable: true, defaultValue: null, length: 29, alias: Install Date, type: esriFieldTypeDate )
• locdesc ( modelName: LOCDESC, nullable: true, editable: true, defaultValue: null, length: 200, alias: Location Description, type: esriFieldTypeString )
• rotation ( modelName: ROTATION, nullable: true, editable: true, defaultValue: null, alias: Rotation, type: esriFieldTypeDouble )
• diameter ( modelName: DIAMETER, nullable: true, editable: true, defaultValue: null, alias: Diameter, type: esriFieldTypeDouble , Coded Values: [0.75: 3/4"] , [1: 1"] , [1.25: 1 1/4"] , ...21 more... )
• valvetype ( modelName: VALVETYPE, nullable: true, editable: true, defaultValue: null, length: 30, alias: Valve Type, type: esriFieldTypeString , Coded Values: [Ball: Ball] , [Butterfly: Butterfly] , [Cone: Cone] , ...2 more... )
• bypassvalve ( modelName: BYPASSVALVE, nullable: true, editable: true, defaultValue: 0, alias: Bypass Valve, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• clocktoclose ( modelName: CLOCKTOCLOSE, nullable: true, editable: true, defaultValue: 1, alias: Clockwise To Close, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• normallyopen ( modelName: NORMALLYOPEN, nullable: true, editable: true, defaultValue: 1, alias: Normally Open, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• turnstoclose ( modelName: TURNSTOCLOSE, nullable: true, editable: true, defaultValue: 1, alias: Turns To Close, type: esriFieldTypeInteger )
• operable ( modelName: OPERABLE, nullable: true, editable: true, defaultValue: 1, alias: Operable, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• hydrflag ( modelName: HYDRFLAG, nullable: true, editable: true, defaultValue: 0, alias: Hydrant Valve, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• curropen ( modelName: CURROPEN, nullable: true, editable: true, defaultValue: 1, alias: Currently Open, type: esriFieldTypeSmallInteger , Coded Values: [1: Open] , [2: Closed] , [3: Unkn] )
• enabled ( modelName: ENABLED, nullable: true, editable: true, defaultValue: 1, alias: Enabled, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• activeflag ( modelName: ACTIVEFLAG, nullable: true, editable: true, defaultValue: 1, alias: Active Flag, type: esriFieldTypeSmallInteger , Coded Values: [0: False] , [1: True] )
• ownedby ( modelName: OWNEDBY, nullable: true, editable: true, defaultValue: 1, alias: Owned By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Utility] , [-1: UTWD] , [-2: Copper Canyon] , ...1 more... )
• maintby ( modelName: MAINTBY, nullable: true, editable: true, defaultValue: 1, alias: Managed By, type: esriFieldTypeSmallInteger , Coded Values: [1: Our Utility] , [-1: UTWD] , [-2: Copper Canyon] , ...1 more... )
• lastupdate ( modelName: LASTUPDATE, nullable: true, editable: true, defaultValue: null, length: 29, alias: Last Update Date, type: esriFieldTypeDate )
• lasteditor ( modelName: LASTEDITOR, nullable: true, editable: true, defaultValue: null, length: 50, alias: Last Editor, type: esriFieldTypeString )
• legacyid ( modelName: LegacyID, nullable: true, editable: true, defaultValue: null, length: 30, alias: LegacyID, type: esriFieldTypeString )
• gps_verified ( modelName: GPS_Verified, nullable: true, editable: true, defaultValue: null, length: 5, alias: GPS_Verified, type: esriFieldTypeString )
• facility_id_label ( modelName: Facility_ID_Label, nullable: true, editable: true, defaultValue: null, length: 20, alias: Facility_ID_Label, type: esriFieldTypeString )
• comments ( modelName: Comments, nullable: true, editable: true, defaultValue: null, length: 50, alias: Comments, type: esriFieldTypeString )
• lastactivity ( modelName: LastActivity, nullable: true, editable: true, defaultValue: null, length: 4, alias: LastActivity, type: esriFieldTypeString , Coded Values: [INST: Installation] , [UPDT: Update Info] , [EXE: Exercise Valve] , ...4 more... )
• datestamp ( modelName: DateStamp, nullable: true, editable: true, defaultValue: null, length: 29, alias: DateStamp, type: esriFieldTypeDate )
• optime ( modelName: OpTime, nullable: true, editable: true, defaultValue: null, length: 5, alias: OpTime, type: esriFieldTypeString )
• computername ( modelName: ComputerName, nullable: true, editable: true, defaultValue: null, length: 30, alias: ComputerName, type: esriFieldTypeString )
• operatedby ( modelName: OperatedBy, nullable: true, editable: true, defaultValue: null, length: 30, alias: OperatedBy, type: esriFieldTypeString )
• operationalstatus ( modelName: OperationalStatus, nullable: true, editable: true, defaultValue: null, length: 10, alias: OperationalStatus, type: esriFieldTypeString , Coded Values: [OK: OK] , [NRPR: Needs Repair] , [INOP: Inoperable] , ...6 more... )
• depthtonut ( modelName: DepthtoNut, nullable: true, editable: true, defaultValue: null, alias: DepthtoNut, type: esriFieldTypeSmallInteger )
• valvepurpose ( modelName: ValvePurpose, nullable: true, editable: true, defaultValue: null, length: 10, alias: ValvePurpose, type: esriFieldTypeString , Coded Values: [ZONE: Zone Valve] , [RSRV: Resevoir Valve] , [HYD: Hydrant Valve] , ...6 more... )
• gpsx ( modelName: GPSX, nullable: true, editable: true, defaultValue: null, alias: GPSX, type: esriFieldTypeDouble )
• gpsy ( modelName: GPSY, nullable: true, editable: true, defaultValue: null, alias: GPSY, type: esriFieldTypeDouble )
• hightorque ( modelName: HighTorque, nullable: true, editable: true, defaultValue: null, alias: HighTorque, type: esriFieldTypeSmallInteger )
• closedirection ( modelName: CloseDirection, nullable: true, editable: true, defaultValue: null, length: 5, alias: CloseDirection, type: esriFieldTypeString , Coded Values: [R: Right] , [L: Left] )
• torquedata ( modelName: TorqueData, nullable: true, editable: true, defaultValue: null, length: 2147483647, alias: TorqueData, type: esriFieldTypeString )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )

Templates:

• Name: sde.DBO.SystemValveActivity_tbl
  Description:
  Prototype:
  lastactivity: null
  operable: 1
  facilityid: null
  installdate: null
  facility_id_label: null
  computername: null
  torquedata: null
  operatedby: null
  valvepurpose: null
  enabled: 1
  normallyopen: 1
  datestamp: null
  diameter: null
  valvetype: null
  depthtonut: null
  ownedby: 1
  hightorque: null
  comments: null
  optime: null
  rotation: null
  hydrflag: 0
  curropen: 1
  lasteditor: null
  turnstoclose: 1
  activeflag: 1
  closedirection: null
  clocktoclose: 1
  bypassvalve: 0
  gps_verified: null
  legacyid: null
  maintby: 1
  lastupdate: null
  operationalstatus: null
  locdesc: null
  gpsx: null
  gpsy: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

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