Name: Control_Panel

Display Field: asset_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: c5a93b92ae4a4922bed1e8f74d21d8bc

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: true
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
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: false
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 ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: System-maintained ObjectID, alias: OBJECTID )
• tier_1 ( modelName: Tier_1, nullable: true, editable: true, defaultValue: null, length: 50, alias: Tier 1, type: esriFieldTypeString , Coded Values: [001: BEACHAM] , [002: CEDAR CREEK] , [003: MIDDLE OCONEE] , ...1 more... )
• tier_2 ( modelName: Tier_2, nullable: true, editable: true, defaultValue: null, length: 50, alias: Tier 2, type: esriFieldTypeString , Coded Values: [001: ADMINISTRATION BUILDING] , [002: AEROBIC SLUDGE STORAGE AND THICKENING] , [003: BEAR CREEK PUMP STATION] , ...47 more... )
• tier_3 ( modelName: Tier_3, nullable: true, editable: true, defaultValue: null, length: 50, alias: Tier 3, type: esriFieldTypeString )
• tier_4 ( modelName: Tier_4, nullable: true, editable: true, defaultValue: null, length: 50, alias: Tier 4, type: esriFieldTypeString )
• tier_5 ( modelName: Tier_5, nullable: true, editable: true, defaultValue: null, length: 50, alias: Tier 5, type: esriFieldTypeString )
• tier_6 ( modelName: Tier_6, nullable: true, editable: true, defaultValue: null, length: 50, alias: Tier 6, type: esriFieldTypeString )
• tier_7 ( modelName: Tier_7, nullable: true, editable: true, defaultValue: null, length: 50, alias: Tier 7, type: esriFieldTypeString )
• tier_8 ( modelName: Tier_8, nullable: true, editable: true, defaultValue: null, length: 50, alias: Tier 8, type: esriFieldTypeString )
• asset_name ( modelName: Asset_Name, nullable: true, editable: true, defaultValue: null, length: 100, alias: Asset Name, type: esriFieldTypeString )
• asset_id ( modelName: Asset_ID, nullable: true, editable: true, defaultValue: null, length: 50, alias: Asset_ID, type: esriFieldTypeString )
• model ( modelName: Model, nullable: true, editable: true, defaultValue: null, length: 50, alias: Model, type: esriFieldTypeString )
• serial_no ( modelName: Serial_No, nullable: true, editable: true, defaultValue: null, length: 50, alias: Serial No, type: esriFieldTypeString )
• manufacturer ( modelName: Manufacturer, nullable: true, editable: true, defaultValue: null, length: 50, alias: Manufacturer, type: esriFieldTypeString )
• notes ( modelName: Notes, nullable: true, editable: true, defaultValue: null, length: 200, alias: Notes, type: esriFieldTypeString )
• asset_type ( modelName: Asset_Type, nullable: true, editable: true, defaultValue: null, length: 50, alias: Asset Type, type: esriFieldTypeString )
• status ( modelName: Status, nullable: true, editable: true, defaultValue: null, length: 50, alias: Status, type: esriFieldTypeString , Coded Values: [I: IN SERVICE] , [ABN: ABANDONERD] , [O: OUT OF SERVICE] , ...1 more... )
• condition ( modelName: Condition, nullable: true, editable: true, defaultValue: null, alias: Condition, type: esriFieldTypeSmallInteger )
• condition_date ( modelName: Condition_Date, nullable: true, editable: true, defaultValue: null, length: 50, alias: Condition Date, type: esriFieldTypeString )
• replacement_cost ( modelName: Replacement_Cost, nullable: true, editable: true, defaultValue: null, alias: Replacement Cost, type: esriFieldTypeDouble )
• purchase_date ( modelName: Purchase_Date, nullable: true, editable: true, defaultValue: null, length: 50, alias: Purchase Date, type: esriFieldTypeString )
• scadatag ( modelName: SCADATAG, nullable: true, editable: true, defaultValue: null, length: 30, alias: SCADA Tag, type: esriFieldTypeString )
• type ( modelName: Type, nullable: true, editable: true, defaultValue: null, length: 75, alias: Type, type: esriFieldTypeString )
• pid ( modelName: PID, nullable: true, editable: true, defaultValue: null, length: 10, alias: PID, type: esriFieldTypeString )
• location ( modelName: Location, nullable: true, editable: true, defaultValue: null, length: 150, alias: Location, type: esriFieldTypeString )
• tileno ( modelName: TileNo, nullable: true, editable: true, defaultValue: null, length: 100, alias: TileNo, type: esriFieldTypeString )

Templates:

• Name: Control_Panel
  Description:
  Prototype:
  tileno: null
  notes: null
  replacement_cost: null
  pid: null
  asset_id: null
  type: null
  manufacturer: null
  asset_name: null
  asset_type: null
  model: null
  scadatag: null
  tier_6: null
  tier_5: null
  tier_8: null
  condition: null
  tier_7: null
  location: null
  tier_2: null
  purchase_date: null
  tier_1: null
  serial_no: null
  condition_date: null
  tier_4: null
  tier_3: null
  status: null
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

• ACC_Plant (55) -- Related To: ACC Plants (3)

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:   Field Groups   Contingent Values

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Related Records   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata