Name: System_Valve_Inspection

Display Field: notes

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 682cc88ce3e2449194fdbaf51210e982

Copyright Text:

Default Visibility: false

MaxRecordCount: 2000

MaxSelectionCount: 0

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: 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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• objectid ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: objectid )
• fintorque ( type: esriFieldTypeDouble, alias: Torque, editable: true, nullable: true, defaultValue: null, modelName: fintorque )
• depthtonut ( type: esriFieldTypeDouble, alias: Depth To Nut (Ft), editable: true, nullable: true, defaultValue: null, modelName: depthtonut )
• stem ( type: esriFieldTypeSmallInteger, alias: Stem OK?, editable: true, nullable: true, defaultValue: null, modelName: stem )
• package ( type: esriFieldTypeSmallInteger, alias: Packing OK?, editable: true, nullable: true, defaultValue: null, modelName: package )
• gears ( type: esriFieldTypeSmallInteger, alias: Gears OK?, editable: true, nullable: true, defaultValue: null, modelName: gears )
• lube ( type: esriFieldTypeSmallInteger, alias: Lube Req'd?, editable: true, nullable: true, defaultValue: null, modelName: lube )
• other ( type: esriFieldTypeSmallInteger, alias: Other Maint Req'd?, editable: true, nullable: true, defaultValue: null, modelName: other )
• notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 2000, defaultValue: null, modelName: notes )
• assetguid ( type: esriFieldTypeGUID, alias: Asset GlobalID, editable: true, nullable: true, length: 38, defaultValue: null, modelName: assetguid )
• created_user ( type: esriFieldTypeString, alias: Creator, editable: true, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Creation date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Updated by, editable: true, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Last update, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: last_edited_date )
• leaking ( type: esriFieldTypeSmallInteger, alias: Leaking?, editable: true, nullable: true, defaultValue: null, modelName: leaking )
• globalid ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: globalid )
• inspector ( type: esriFieldTypeString, alias: Inspector, editable: true, nullable: true, length: 255, defaultValue: null, modelName: inspector )
• insdate ( type: esriFieldTypeDate, alias: Inspection Date, editable: true, nullable: true, length: 8, defaultValue: null, precision: 1, modelName: insdate )
• paved ( type: esriFieldTypeSmallInteger, alias: Paved Over, editable: true, nullable: true, defaultValue: null, modelName: paved )
• gsurface ( type: esriFieldTypeSmallInteger, alias: Ground Surface, editable: true, nullable: true, defaultValue: null, modelName: gsurface )
• turns ( type: esriFieldTypeSmallInteger, alias: # of turns, editable: true, nullable: true, defaultValue: null, modelName: turns )
• op_status ( type: esriFieldTypeSmallInteger, alias: Open or Closed, editable: true, nullable: true, defaultValue: null, modelName: op_status )
• leak ( type: esriFieldTypeSmallInteger, alias: Leaking, editable: true, nullable: true, defaultValue: null, modelName: leak )
• repair ( type: esriFieldTypeSmallInteger, alias: Repair, editable: true, nullable: true, defaultValue: null, modelName: repair )
• valve_shape ( type: esriFieldTypeString, alias: Valve in Shape, editable: true, nullable: true, length: 20, defaultValue: null, modelName: valve_shape )

Templates:

• Name: System_Valve_Inspection
  Description:
  Prototype:
  repair: null
  fintorque: null
  depthtonut: null
  stem: null
  package: null
  gears: null
  lube: null
  other: null
  notes: null
  assetguid: null
  created_user: null
  created_date: null
  last_edited_user: null
  last_edited_date: null
  leaking: null
  valve_shape: null
  inspector: null
  insdate: null
  paved: null
  gsurface: null
  turns: null
  op_status: null
  leak: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• water.postgres.System_Valve (1) -- Related To: System Valve (0)

Capabilities: Query

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata   Update Metadata