Name: PCIScenarios_ExcelToTable

Display Field: area_name

Type: Table

Geometry Type: N/A

Description:

Service Item Id: ab3e8d0719b34508b2e9ff4b06c069c5

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: OBJECTID, alias: OBJECTID )
• laneid ( modelName: LANEID, nullable: true, editable: true, defaultValue: null, length: 255, alias: LANEID, type: esriFieldTypeString )
• pci_value_lanes__needs_based ( modelName: PCI_Value_Lanes__Needs_Based, nullable: true, editable: true, defaultValue: null, length: 255, alias: PCI_Value(Lanes)_Needs Based, type: esriFieldTypeString )
• pci_value_lanes__now ( modelName: PCI_Value_Lanes__Now, nullable: true, editable: true, defaultValue: null, length: 255, alias: PCI_Value(Lanes)_Now, type: esriFieldTypeString )
• pci_value_lanes__do_nothing ( modelName: PCI_Value_Lanes__Do_Nothing, nullable: true, editable: true, defaultValue: null, alias: PCI_Value(Lanes)_Do Nothing, type: esriFieldTypeDouble )
• critical_or_not ( modelName: Critical_Or_Not, nullable: true, editable: true, defaultValue: null, length: 255, alias: Critical Or Not, type: esriFieldTypeString )
• pci_value_lanes__critical ( modelName: PCI_Value_Lanes__Critical, nullable: true, editable: true, defaultValue: null, alias: PCI_Value(Lanes)_Critical, type: esriFieldTypeDouble )
• major_or_not ( modelName: Major_Or_Not, nullable: true, editable: true, defaultValue: null, length: 255, alias: Major Or Not, type: esriFieldTypeString )
• lane_id_en_md_category ( modelName: Lane_ID_EN_MD_CATEGORY, nullable: true, editable: true, defaultValue: null, length: 255, alias: Lane_ID+EN_MD_CATEGORY, type: esriFieldTypeString )
• pci_value_lanes__major ( modelName: PCI_Value_Lanes__Major, nullable: true, editable: true, defaultValue: null, alias: PCI_Value(Lanes)_Major, type: esriFieldTypeDouble )
• main_no ( modelName: Main_No, nullable: true, editable: true, defaultValue: null, length: 255, alias: Main_No, type: esriFieldTypeString )
• area_name ( modelName: Area_Name, nullable: true, editable: true, defaultValue: null, length: 255, alias: Area_Name, type: esriFieldTypeString )
• md_cost_needs_based_ ( modelName: MD_COST_Needs_Based_, nullable: true, editable: true, defaultValue: null, alias: MD_COST(Needs Based), type: esriFieldTypeDouble )
• maint_area_needs_based_ ( modelName: MAINT_AREA_Needs_Based_, nullable: true, editable: true, defaultValue: null, alias: MAINT_AREA(Needs Based), type: esriFieldTypeDouble )
• md_cost_critical_ ( modelName: MD_COST_Critical_, nullable: true, editable: true, defaultValue: null, alias: MD_COST(Critical), type: esriFieldTypeDouble )
• maint_area_critical_ ( modelName: MAINT_AREA_Critical_, nullable: true, editable: true, defaultValue: null, alias: MAINT_AREA(Critical), type: esriFieldTypeDouble )
• md_cost_major_ ( modelName: MD_COST_Major_, nullable: true, editable: true, defaultValue: null, alias: MD_COST(Major), type: esriFieldTypeDouble )
• maint_area_major_ ( modelName: MAINT_AREA_Major_, nullable: true, editable: true, defaultValue: null, alias: MAINT_AREA(Major), type: esriFieldTypeDouble )

Templates:

• Name: PCIScenarios_ExcelToTable
  Description:
  Prototype:
  area_name: null
  md_cost_major_: null
  maint_area_major_: null
  md_cost_needs_based_: null
  md_cost_critical_: null
  pci_value_lanes__needs_based: null
  maint_area_needs_based_: null
  lane_id_en_md_category: null
  major_or_not: null
  main_no: null
  pci_value_lanes__major: null
  laneid: null
  pci_value_lanes__do_nothing: null
  maint_area_critical_: null
  pci_value_lanes__critical: null
  pci_value_lanes__now: null
  critical_or_not: 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

Child Resources:   Field Groups   Contingent Values

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