Name: Sewer 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 )
• NAME_NUMBER ( type: esriFieldTypeString, alias: NAME NUMBER, editable: true, nullable: true, length: 30, defaultValue: null, modelName: NAME_NUMBER )
• FFID ( type: esriFieldTypeInteger, alias: FFID, editable: true, nullable: true, defaultValue: null, modelName: FFID )
• 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 )
• 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 )
• 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] )
• ARV_Odor_Control_System ( type: esriFieldTypeString, alias: ARV Odor Control System, editable: true, nullable: true, length: 3, defaultValue: null, modelName: ARV_Odor_Control_System , Coded Values: [Yes: Yes] , [No: No] )
• Open_Direction ( type: esriFieldTypeString, alias: Open Direction, editable: true, nullable: true, length: 30, 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] )
• Current_Position_Date ( type: esriFieldTypeDate, alias: Current Position Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: Current_Position_Date )
• ARV_Priority ( type: esriFieldTypeSmallInteger, alias: ARV Priority, editable: true, nullable: true, defaultValue: null, modelName: ARV_Priority )
• Notes ( type: esriFieldTypeString, alias: Notes, editable: true, nullable: true, length: 255, defaultValue: null, modelName: Notes )
• Status ( type: esriFieldTypeString, alias: Status, editable: true, nullable: true, length: 20, defaultValue: null, modelName: Status , Coded Values: [Proposed: Proposed] , [Active: Active] , [Inactive: Inactive] , ...2 more... )
• Valve_ID ( type: esriFieldTypeString, alias: Valve ID, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Valve_ID )
• Vault_Material ( type: esriFieldTypeString, alias: Vault Material, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Vault_Material , Coded Values: [Brick: Brick] , [Block: Block] , [Precast: Precast] , ...2 more... )
• Vault_Shape ( type: esriFieldTypeString, alias: Vault Shape, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Vault_Shape , Coded Values: [Circular: Circular] , [Rectangular: Rectangular] )
• Valve_Type ( type: esriFieldTypeString, alias: Valve Type, editable: true, nullable: true, length: 40, defaultValue: null, modelName: ARV_Type , Coded Values: [Air Release: Air Release] , [Combination: Combination] , [Vacuum: Vacuum] )
• Tap_Type ( type: esriFieldTypeString, alias: Tap Type, editable: true, nullable: true, length: 25, defaultValue: null, modelName: Tap_Type , Coded Values: [Flange: Flange] , [Saddle: Saddle] , [Tap: Tap] )
• Valve_Position ( type: esriFieldTypeString, alias: Valve Position, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ARV_Position , Coded Values: [Open: Open] , [Closed: Closed] )
• Valve_Location ( type: esriFieldTypeString, alias: Valve Location, editable: true, nullable: true, length: 20, defaultValue: null, modelName: ARV_Location , Coded Values: [Top: Top] , [Side: Side] )
• Nipple_Material ( type: esriFieldTypeString, alias: Nipple Material, editable: true, nullable: true, length: 25, defaultValue: null, modelName: ARV_Pipe_Material , Coded Values: [Cast Iron: Cast Iron] , [Galvanized: Galvanized] , [Stainless: Stainless] )
• Max_Pressure ( type: esriFieldTypeDouble, alias: Max Pressure, editable: true, nullable: true, defaultValue: null, modelName: Max_Pressure )
• Min_Pressure ( type: esriFieldTypeDouble, alias: Min Pressure, editable: true, nullable: true, defaultValue: null, modelName: Min_Pressure )
• Valve_Size ( type: esriFieldTypeDouble, alias: Valve Size, editable: true, nullable: true, defaultValue: null, modelName: ARV_Size )
• Tap_Size ( type: esriFieldTypeDouble, alias: Tap Size, editable: true, nullable: true, defaultValue: null, modelName: Tap_Size )
• Vault_Length ( type: esriFieldTypeDouble, alias: Vault Length, editable: true, nullable: true, defaultValue: null, modelName: Vault_Length )
• Vault_Width ( type: esriFieldTypeDouble, alias: Vault Width, editable: true, nullable: true, defaultValue: null, modelName: Vault_Width )
• Vault_Floor_to_Ceiling ( type: esriFieldTypeDouble, alias: Vault Floor to Ceiling, editable: true, nullable: true, defaultValue: null, modelName: Vault_Floor_to_Ceiling )
• Side_Wall_to_Valve ( type: esriFieldTypeDouble, alias: Side Wall to Valve, editable: true, nullable: true, defaultValue: null, modelName: Side_Wall_to_Valve )
• Front_Wall_to_Valve ( type: esriFieldTypeDouble, alias: Front Wall to Valve, editable: true, nullable: true, defaultValue: null, modelName: Front_Wall_to_Valve )
• Main_to_Ceiling ( type: esriFieldTypeDouble, alias: Main to Ceiling, editable: true, nullable: true, defaultValue: null, modelName: Main_to_Ceiling )
• PS_Area ( type: esriFieldTypeString, alias: PS Area, editable: true, nullable: true, length: 25, defaultValue: null, modelName: PS_Area )

Templates:

• Name: Sewer Valve Info
  Description:
  Prototype:
  Main_to_Ceiling: null
  PS_Area: null
  NAME_NUMBER: null
  FFID: null
  Maintenance_Strategy: null
  Install_Year: null
  WarrantyStartDate: null
  WarrantyEndDate: null
  Manufacturer: null
  Model_No: null
  Serial_No: null
  Bury_Condition: null
  Operator_Type: null
  ARV_Odor_Control_System: null
  Open_Direction: null
  Turns_To_Close: null
  Current_Position: null
  Current_Position_Date: null
  ARV_Priority: null
  Notes: null
  Status: null
  Valve_ID: null
  Vault_Material: null
  Vault_Shape: null
  Valve_Type: null
  Tap_Type: null
  Valve_Position: null
  Valve_Location: null
  Nipple_Material: null
  Max_Pressure: null
  Min_Pressure: null
  Valve_Size: null
  Tap_Size: null
  Vault_Length: null
  Vault_Width: null
  Vault_Floor_to_Ceiling: null
  Side_Wall_to_Valve: null
  Front_Wall_to_Valve: 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