{ "name": "SelectLayerByAttribute", "displayName": "Select Layer By Attribute", "description": "Adds, updates, or removes a selection based on an attribute query.", "category": "", "helpUrl": "https://sig.taesa.com.br/arcgis/rest/directories/arcgisoutput/campanha_supressao_2025/Select_Layer_By_Attribute_GPServer/campanha_supressao_2025_Select_Layer_By_Attribute/SelectLayerByAttribute.htm", "executionType": "esriExecutionTypeAsynchronous", "parameters": [ { "name": "in_layer_or_view", "dataType": "GPFeatureRecordSetLayer", "displayName": "in_layer_or_view", "description": "The data to which the selection will be applied.", "direction": "esriGPParameterDirectionInput", "defaultValue": { "displayFieldName": "", "geometryType": "esriGeometryPolyline", "spatialReference": { "wkid": 102100, "latestWkid": 3857 }, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "id_responsavel", "type": "esriFieldTypeInteger", "alias": "ID do Responsável" }, { "name": "dt_levantamento", "type": "esriFieldTypeDate", "alias": "Data do Levantamento", "length": 8 }, { "name": "comp_acesso", "type": "esriFieldTypeDouble", "alias": "Comprimento do Acesso" }, { "name": "larg_acesso", "type": "esriFieldTypeSmallInteger", "alias": "Largura do Acesso" }, { "name": "ds_linha_transmissao", "type": "esriFieldTypeString", "alias": "Linha de Transmissão", "length": 100 }, { "name": "est_extrem", "type": "esriFieldTypeString", "alias": "Vão mais próximo", "length": 50 }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "length": 38 }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255 }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8 }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255 }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8 }, { "name": "shape_Length", "type": "esriFieldTypeDouble", "alias": "shape_Length" } ], "features": [], "exceededTransferLimit": false }, "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "selection_type", "dataType": "GPString", "displayName": "Selection Type", "description": "Specifies how the selection will be applied and what to do if a selection already exists.New selection\u2014The resulting selection replaces the current selection. This is the default.Add to the current selection\u2014The resulting selection is added to the current selection if one exists. If no selection exists, this is the same as the new selection option.Remove from the current selection\u2014The resulting selection is removed from the current selection. If no selection exists, this option has no effect.Select subset from the current selection\u2014The resulting selection is combined with the current selection. Only records that are common to both remain selected.Switch the current selection\u2014The selection is switched. All records that were selected are removed from the current selection, and all records that were not selected are added to the current selection. The Expression parameter (where_clause in Python) is ignored when this option is specified.Clear the current selection\u2014The selection is cleared or removed. The Expression parameter (where_clause in Python) is ignored when this option is specified.", "direction": "esriGPParameterDirectionInput", "defaultValue": "NEW_SELECTION", "parameterType": "esriGPParameterTypeOptional", "category": "", "choiceList": [ "NEW_SELECTION", "ADD_TO_SELECTION", "REMOVE_FROM_SELECTION", "SUBSET_SELECTION", "SWITCH_SELECTION", "CLEAR_SELECTION" ] }, { "name": "where_clause", "dataType": "GPString", "displayName": "Expression", "description": "An SQL expression used to select a subset of records.", "direction": "esriGPParameterDirectionInput", "dependency": "in_layer_or_view", "defaultValue": "ds_linha_transmissao = 'LT 230 kV LAGOA NOVA II - CURRAIS NOVOS II'", "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "out_layer_or_view", "dataType": "GPFeatureRecordSetLayer", "displayName": "Updated Layer Or Table View", "description": "", "direction": "esriGPParameterDirectionOutput", "defaultValue": { "displayFieldName": "", "geometryType": "esriGeometryPolyline", "spatialReference": { "wkid": 102100, "latestWkid": 3857 }, "fields": [ { "name": "objectid", "type": "esriFieldTypeOID", "alias": "OBJECTID" }, { "name": "id_responsavel", "type": "esriFieldTypeInteger", "alias": "ID do Responsável" }, { "name": "dt_levantamento", "type": "esriFieldTypeDate", "alias": "Data do Levantamento", "length": 8 }, { "name": "comp_acesso", "type": "esriFieldTypeDouble", "alias": "Comprimento do Acesso" }, { "name": "larg_acesso", "type": "esriFieldTypeSmallInteger", "alias": "Largura do Acesso" }, { "name": "ds_linha_transmissao", "type": "esriFieldTypeString", "alias": "Linha de Transmissão", "length": 100 }, { "name": "est_extrem", "type": "esriFieldTypeString", "alias": "Vão mais próximo", "length": 50 }, { "name": "globalid", "type": "esriFieldTypeGlobalID", "alias": "globalid", "length": 38 }, { "name": "created_user", "type": "esriFieldTypeString", "alias": "created_user", "length": 255 }, { "name": "created_date", "type": "esriFieldTypeDate", "alias": "created_date", "length": 8 }, { "name": "last_edited_user", "type": "esriFieldTypeString", "alias": "last_edited_user", "length": 255 }, { "name": "last_edited_date", "type": "esriFieldTypeDate", "alias": "last_edited_date", "length": 8 }, { "name": "shape_Length", "type": "esriFieldTypeDouble", "alias": "shape_Length" } ], "features": [], "exceededTransferLimit": false }, "parameterType": "esriGPParameterTypeDerived", "category": "" }, { "name": "invert_where_clause", "dataType": "GPBoolean", "displayName": "Invert Where Clause", "description": "Specifies whether the expression will be used as is, or the opposite of the expression will be used.Unchecked\u2014The query will be used as is. This is the default.Checked\u2014The opposite of the query will be used. If the Selection Type parameter is used, the reversal of the selection occurs before it is combined with existing selections.", "direction": "esriGPParameterDirectionInput", "defaultValue": null, "parameterType": "esriGPParameterTypeOptional", "category": "" }, { "name": "count", "dataType": "GPLong", "displayName": "Count", "description": "", "direction": "esriGPParameterDirectionOutput", "defaultValue": null, "parameterType": "esriGPParameterTypeDerived", "category": "" }, { "name": "esri_out_feature_service_name", "dataType": "GPString", "displayName": "Output Feature Service Name", "description": "The name of the optional feature service to create on the federated server containing the result of this tool. If no name is specified an output feature service will not be created.", "direction": "esriGPParameterDirectionInput", "defaultValue": "", "parameterType": "esriGPParameterTypeOptional", "category": "" } ] }