Name: Water Valve Info

Display Field: NAME_NUMBER

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

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 )
• FFID ( type: esriFieldTypeInteger, alias: FFID, editable: true, nullable: true, defaultValue: null, modelName: FFID )
• NAME_NUMBER ( type: esriFieldTypeString, alias: NAME_NUMBER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: NAME_NUMBER )
• Maintenance_Strategy ( type: esriFieldTypeString, alias: Maintenance Strategy, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Maintenance_Strategy , Coded Values: [Run To Failure: Run To Failure] , [Preventative Maintenance: Preventative Maintenance] , [Predictive Maintenance: Predictive Maintenance] , ...1 more... )
• Install_Year ( type: esriFieldTypeSmallInteger, alias: Install Year, editable: true, nullable: true, defaultValue: null, modelName: Install_Year )
• WarrantyStartDate ( type: esriFieldTypeDate, alias: Warranty Start Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyStartDate )
• WarrantyEndDate ( type: esriFieldTypeDate, alias: Warranty End Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: WarrantyEndDate )
• Bury_Condition ( type: esriFieldTypeString, alias: Bury Condition, editable: true, nullable: true, length: 15, defaultValue: null, modelName: Bury_Condition , Coded Values: [Vault: Vault] , [Direct Bury: Direct Bury] )
• Operator_Type ( type: esriFieldTypeString, alias: Operator Type, editable: true, nullable: true, length: 5, defaultValue: null, modelName: Operator_Type , Coded Values: [Wheel: Wheel] , [Key: Key] )
• Open_Direction ( type: esriFieldTypeString, alias: Open Direction, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Open_Direction , Coded Values: [CW: CW] , [CCW: CCW] )
• Turns_To_Close ( type: esriFieldTypeSmallInteger, alias: Turns To Close, editable: true, nullable: true, defaultValue: null, modelName: Turns_To_Close )
• Current_Position ( type: esriFieldTypeString, alias: Current Position, editable: true, nullable: true, length: 6, defaultValue: null, modelName: Current_Position , Coded Values: [Open: Open] , [Closed: Closed] )
• Cathodic_Protection ( type: esriFieldTypeString, alias: Cathodic Protection, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Cathodic_Protection , Coded Values: [Yes: Yes] , [No: No] )
• Manufacturer ( type: esriFieldTypeString, alias: Manufacturer, editable: true, nullable: true, length: 50, defaultValue: null, modelName: Manufacturer , Coded Values: [A.R.I USA Inc.: A.R.I. USA Inc.] , [ABZ Manufacturing: ABZ Manufacturing] , [Acrison, Inc.: Acrison, Inc.] , ...74 more... )
• Model_No ( type: esriFieldTypeString, alias: Model No, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Model )
• Serial_No ( type: esriFieldTypeString, alias: Serial No, editable: true, nullable: true, length: 30, defaultValue: null, modelName: Serial )
• Torque_ft_lb ( type: esriFieldTypeSmallInteger, alias: Torque (FT LB), editable: true, nullable: true, defaultValue: null, modelName: Torque )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• Invert_Elevation ( type: esriFieldTypeDouble, alias: Invert Elevation, editable: true, nullable: true, defaultValue: null, modelName: Invert_Elevation )
• Current_Position_Date ( type: esriFieldTypeDate, alias: Current Position Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Current_Position_Date )
• Division_valve ( type: esriFieldTypeString, alias: Division_valve, editable: true, nullable: true, length: 3, defaultValue: null, modelName: Division_valve , Coded Values: [Yes: Yes] , [No: No] )

Templates:

• Name: Water Valve Info
  Description:
  Prototype:
  Current_Position_Date: null
  Division_valve: null
  FFID: null
  NAME_NUMBER: null
  Maintenance_Strategy: null
  Install_Year: null
  WarrantyStartDate: null
  WarrantyEndDate: null
  Bury_Condition: null
  Operator_Type: null
  Open_Direction: null
  Turns_To_Close: null
  Current_Position: null
  Cathodic_Protection: null
  Manufacturer: null
  Model_No: null
  Serial_No: null
  Torque_ft_lb: null
  Notes: null
  Invert_Elevation: null
  
  Drawing Tool: esriFeatureEditToolNone

Capabilities: Query

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

Supported Operations:   Query   Query Analytic   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata