Name: ICA Single Consolidated Table

Display Field: circuit_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: 751d51c15ed74068bdd5795cbbf13478

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

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

• circuit_name ( modelName: circuit_name, nullable: true, editable: true, defaultValue: null, length: 200, alias: circuit_name, type: esriFieldTypeString )
• circuit_id ( modelName: circuit_id, nullable: true, editable: true, defaultValue: null, alias: circuit_id, type: esriFieldTypeDouble )
• circuit_voltage ( modelName: circuit_voltage, nullable: true, editable: true, defaultValue: null, length: 20, alias: circuit_voltage, type: esriFieldTypeString )
• percent_15_cap ( modelName: percent_15_cap, nullable: true, editable: true, defaultValue: null, alias: percent_15_cap, type: esriFieldTypeDouble )
• res_pct ( modelName: res_pct, nullable: true, editable: true, defaultValue: null, alias: res_pct, type: esriFieldTypeDouble )
• com_pct ( modelName: com_pct, nullable: true, editable: true, defaultValue: null, alias: com_pct, type: esriFieldTypeDouble )
• agr_pct ( modelName: agr_pct, nullable: true, editable: true, defaultValue: null, alias: agr_pct, type: esriFieldTypeDouble )
• other_pct ( modelName: other_pct, nullable: true, editable: true, defaultValue: null, alias: other_pct, type: esriFieldTypeDouble )
• ind_pct ( modelName: ind_pct, nullable: true, editable: true, defaultValue: null, alias: ind_pct, type: esriFieldTypeDouble )
• sub_name ( modelName: sub_name, nullable: true, editable: true, defaultValue: null, length: 80, alias: sub_name, type: esriFieldTypeString )
• subst_id ( modelName: subst_id, nullable: true, editable: true, defaultValue: null, alias: subst_id, type: esriFieldTypeDouble )
• note_sub ( modelName: note_sub, nullable: true, editable: true, defaultValue: null, length: 512, alias: note_sub, type: esriFieldTypeString )
• layer_identifier ( modelName: layer_identifier, nullable: true, editable: true, defaultValue: null, length: 200, alias: layer_identifier, type: esriFieldTypeString )
• sys_name ( modelName: sys_name, nullable: true, editable: true, defaultValue: null, length: 200, alias: sys_name, type: esriFieldTypeString )
• existing_gen ( modelName: existing_gen, nullable: true, editable: true, defaultValue: null, alias: existing_gen, type: esriFieldTypeDouble )
• queued_gen ( modelName: queued_gen, nullable: true, editable: true, defaultValue: null, alias: queued_gen, type: esriFieldTypeDouble )
• total_gen ( modelName: total_gen, nullable: true, editable: true, defaultValue: null, alias: total_gen, type: esriFieldTypeDouble )
• projected_load ( modelName: projected_load, nullable: true, editable: true, defaultValue: null, alias: projected_load, type: esriFieldTypeDouble )
• penetration_level ( modelName: penetration_level, nullable: true, editable: true, defaultValue: null, alias: penetration_level, type: esriFieldTypeDouble )
• max_remain_cap ( modelName: max_remain_cap, nullable: true, editable: true, defaultValue: null, alias: max_remain_cap, type: esriFieldTypeDouble )
• agr_total ( modelName: agr_total, nullable: true, editable: true, defaultValue: null, alias: agr_total, type: esriFieldTypeDouble )
• com_total ( modelName: com_total, nullable: true, editable: true, defaultValue: null, alias: com_total, type: esriFieldTypeDouble )
• ind_total ( modelName: ind_total, nullable: true, editable: true, defaultValue: null, alias: ind_total, type: esriFieldTypeDouble )
• res_total ( modelName: res_total, nullable: true, editable: true, defaultValue: null, alias: res_total, type: esriFieldTypeDouble )
• other_total ( modelName: other_total, nullable: true, editable: true, defaultValue: null, alias: other_total, type: esriFieldTypeDouble )
• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: objectid, alias: OBJECTID )

Templates:

• Name: ICA Single Consolidated Table
  Description:
  Prototype:
  circuit_name: null
  total_gen: null
  max_remain_cap: null
  res_total: null
  queued_gen: null
  circuit_voltage: null
  ind_pct: null
  agr_total: null
  ind_total: null
  com_total: null
  sys_name: null
  circuit_id: null
  other_total: null
  agr_pct: null
  subst_id: null
  layer_identifier: null
  res_pct: null
  sub_name: null
  percent_15_cap: null
  note_sub: null
  existing_gen: null
  projected_load: null
  other_pct: null
  com_pct: null
  penetration_level: null
  
  Drawing Tool: esriFeatureEditToolNone

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

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Metadata