Name: NBGIS.GISDATA.WaterValveMaintFieldHistory

Display Field: ACTION_DATE

Type: Table

Geometry Type: N/A

Description:

Copyright Text:

Default Visibility: false

MaxRecordCount: 1000

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: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• GIS_TAG ( type: esriFieldTypeString, alias: Valve ID, editable: true, nullable: true, length: 10, defaultValue: null, modelName: GIS_TAG )
• OWNER ( type: esriFieldTypeString, alias: Agency, editable: true, nullable: true, length: 20, defaultValue: null, modelName: OWNER , Coded Values: [IRWD: Irvine Ranch Water District] , [LBW: Laguna Beach Water] , [MCWD: Mesa Consolidated Water District] , ...7 more... )
• VALVE_FUNCTION ( type: esriFieldTypeString, alias: Valve Function, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_FUNCTION , Coded Values: [DV: Distribution Valve] , [HV: Hydrant Valve] , [DS: Domestic Service] , ...11 more... )
• VALVE_TYPE ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: VALVE_TYPE , Coded Values: [BFV: Butterfly Valve] , [GV: Gate Valve] , [SV: Surge Valve] , ...5 more... )
• HYDRANT_VALVE ( type: esriFieldTypeString, alias: Hydrant Valve, editable: true, nullable: true, length: 5, defaultValue: null, modelName: HYDRANT_VALVE , Coded Values: [Y: Yes] , [N: No] , [NA: Not Available] )
• VALVE_SIZE ( type: esriFieldTypeInteger, alias: Valve Size, editable: true, nullable: true, defaultValue: null, modelName: VALVE_SIZE , Coded Values: [0: 0 Inch] , [1: 1 Inch] , [2: 2 Inch] , ...19 more... )
• INSTALL_DATE ( type: esriFieldTypeDate, alias: Date Install/Replace, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALL_DATE )
• CURRENT_POSITION ( type: esriFieldTypeString, alias: Current Position, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CURRENT_POSITION , Coded Values: [OPN: Open] , [CLS: Closed] , [UNK: Unknown] )
• ABANDONED ( type: esriFieldTypeString, alias: Abandoned?, editable: true, nullable: true, length: 1, defaultValue: null, modelName: Abandoned , Coded Values: [Y: Yes] , [N: No] , [NA: Not Available] )
• NORMAL_CLOSED ( type: esriFieldTypeString, alias: Normally Closed, editable: true, nullable: true, length: 10, defaultValue: null, modelName: NORMAL_CLOSED , Coded Values: [Y: Yes] , [N: No] , [NA: Not Available] )
• TURNS_CLOSE ( type: esriFieldTypeString, alias: Turns to Close, editable: true, nullable: true, length: 10, defaultValue: null, modelName: TURNS_CLOSE )
• DEPTH_NUT ( type: esriFieldTypeSmallInteger, alias: Depth, editable: true, nullable: true, defaultValue: null, modelName: DEPTH_NUT )
• OPERATION_STATUS ( type: esriFieldTypeString, alias: Operational Status, editable: true, nullable: true, length: 30, defaultValue: null, modelName: OPERATION_STATUS , Coded Values: [OK: OK] , [BRK: Broken] , [PCLK: Packing Leak] , ...4 more... )
• VALVE_ACTIVITY ( type: esriFieldTypeString, alias: Activity, editable: true, nullable: true, length: 30, defaultValue: null, modelName: VALVE_ACTIVITY , Coded Values: [EXE: Exercise Valve] , [UPDT: Update Info] , [INST: Installation] , ...2 more... )
• CREW_UPDATE_BY ( type: esriFieldTypeString, alias: Crew Update, editable: true, nullable: true, length: 30, defaultValue: null, modelName: CREW_UPDATE_BY , Coded Values: [asanchez: asanchez] , [dhill: dhill] , [gpichardo: gpichardo] , ...8 more... )
• FIELD_COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 100, defaultValue: null, modelName: FIELD_COMMENTS )
• ACTION_DATE ( type: esriFieldTypeDate, alias: Updated Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: ACTION_DATE )
• MAINT_AREA ( type: esriFieldTypeString, alias: MAINT_AREA, editable: true, nullable: true, length: 10, defaultValue: null, modelName: MAINT_AREA )
• CHECK_VALVE ( type: esriFieldTypeString, alias: Check Valve, editable: true, nullable: true, length: 10, defaultValue: null, modelName: CHECK_VALVE , Coded Values: [YES: YES] , [NO: NO] )
• CHECK_VALVE_TYPE ( type: esriFieldTypeString, alias: Check Valve Type, editable: true, nullable: true, length: 20, defaultValue: null, modelName: CHECK_VALVE_TYPE , Coded Values: [AVK: AVK] , [Clow: Clow] )
• DATE_EXERCISED ( type: esriFieldTypeDate, alias: Date Exercised, editable: true, nullable: true, length: 8, defaultValue: null, modelName: DATE_EXERCISED )

Templates:

• Name: NBGIS.GISDATA.WaterValveMaintFieldHistory
  Description:
  Prototype:
  CHECK_VALVE_TYPE: null
  DATE_EXERCISED: null
  GIS_TAG: null
  OWNER: null
  VALVE_FUNCTION: null
  VALVE_TYPE: null
  HYDRANT_VALVE: null
  VALVE_SIZE: null
  INSTALL_DATE: null
  CURRENT_POSITION: null
  ABANDONED: null
  NORMAL_CLOSED: null
  TURNS_CLOSE: null
  DEPTH_NUT: null
  OPERATION_STATUS: null
  VALVE_ACTIVITY: null
  CREW_UPDATE_BY: null
  FIELD_COMMENTS: null
  ACTION_DATE: null
  MAINT_AREA: null
  CHECK_VALVE: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• WaterValveMaintField (0) -- Related To: Water Valve (0)

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

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:   Field Groups   Contingent Values

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