{
 "name": "SelectLayerByAttribute",
 "displayName": "Select Layer By Attribute",
 "description": "Adds, updates, or removes a selection based on an attribute query.",
 "category": "",
 "helpUrl": "https://collectordev.dot.state.oh.us/arcgis/rest/directories/arcgisoutput/POLLINATOR_SITES/Pollinator_Sites_GPServer/POLLINATOR_SITES_Pollinator_Sites/SelectLayerByAttribute.htm",
 "executionType": "esriExecutionTypeAsynchronous",
 "parameters": [
  {
   "name": "in_layer_or_view",
   "dataType": "GPString",
   "displayName": "Input Rows",
   "description": "The data to which the selection will be applied.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "Active Pollinator Sites",
   "parameterType": "esriGPParameterTypeRequired",
   "category": "",
   "choiceList": [
    "Pollinator Sites Inspection Table",
    "Rapid Assessment Inspection Table",
    "Pollinator Sites Treatment Table",
    "Active Pollinator Sites",
    "Active Pollinator Rapid Assessment"
   ]
  },
  {
   "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 will replace the current selection. This is the default.Add to the current selection\u2014The resulting selection will be 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 will be removed from the current selection. If no selection exists, this option has no effect.Select subset from the current selection\u2014The resulting selection will be combined with the current selection. Only records that are common to both remain selected.Switch the current selection\u2014The selection will be switched. All records that were selected will be removed from the current selection, and all records that were not selected will be added to the current selection. The Expression parameter is ignored when this option is specified.Clear the current selection\u2014The selection will be cleared or removed. The Expression parameter is ignored when this option is specified.",
   "direction": "esriGPParameterDirectionInput",
   "defaultValue": "New selection",
   "parameterType": "esriGPParameterTypeOptional",
   "category": "",
   "choiceList": [
    "New selection",
    "Add to the current selection",
    "Remove from the current selection",
    "Select subset from the current selection",
    "Switch the current selection",
    "Clear the current 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": "STATUS = 'A' And SITE_TYPE  'Perennial Sunflowers'",
   "parameterType": "esriGPParameterTypeOptional",
   "category": ""
  },
  {
   "name": "out_layer_or_view",
   "dataType": "GPFeatureRecordSetLayer",
   "displayName": "Updated Layer Or Table View",
   "description": "",
   "direction": "esriGPParameterDirectionOutput",
   "defaultValue": {
    "displayFieldName": "",
    "geometryType": "esriGeometryPoint",
    "spatialReference": {
     "wkid": 102100,
     "latestWkid": 3857
    },
    "fields": [
     {
      "name": "NLFID",
      "type": "esriFieldTypeString",
      "alias": "NLFID",
      "length": 14
     },
     {
      "name": "CRS",
      "type": "esriFieldTypeString",
      "alias": "CRS",
      "length": 17
     },
     {
      "name": "ODOT_DISTRICT",
      "type": "esriFieldTypeString",
      "alias": "ODOT District",
      "length": 2
     },
     {
      "name": "COUNTY",
      "type": "esriFieldTypeString",
      "alias": "County",
      "length": 10
     },
     {
      "name": "COUNTY_CD",
      "type": "esriFieldTypeString",
      "alias": "County CD",
      "length": 3
     },
     {
      "name": "ROUTE_TYPE",
      "type": "esriFieldTypeString",
      "alias": "Route Type",
      "length": 2
     },
     {
      "name": "ROUTE_NBR",
      "type": "esriFieldTypeString",
      "alias": "Route Number",
      "length": 5
     },
     {
      "name": "ROUTE_SUFFIX",
      "type": "esriFieldTypeString",
      "alias": "Route Suffix",
      "length": 1
     },
     {
      "name": "STREET_NAME",
      "type": "esriFieldTypeString",
      "alias": "Street Name",
      "length": 100
     },
     {
      "name": "CTL_BEGIN_NBR",
      "type": "esriFieldTypeDouble",
      "alias": "CTL Begin Number"
     },
     {
      "name": "STL_BEGIN_NBR",
      "type": "esriFieldTypeDouble",
      "alias": "STL Begin Number"
     },
     {
      "name": "LATITUDE_DD_BEGIN",
      "type": "esriFieldTypeDouble",
      "alias": "Latitude DD Begin"
     },
     {
      "name": "LONGITUDE_DD_BEGIN",
      "type": "esriFieldTypeDouble",
      "alias": "Longitude DD Begin"
     },
     {
      "name": "PERP_DATE",
      "type": "esriFieldTypeDate",
      "alias": "PERP Date",
      "length": 8
     },
     {
      "name": "STATUS",
      "type": "esriFieldTypeString",
      "alias": "Status",
      "length": 1
     },
     {
      "name": "INSTALLATION_DATE",
      "type": "esriFieldTypeDate",
      "alias": "Installation Date",
      "length": 8
     },
     {
      "name": "MAINTAIN_RESPONSIBLE",
      "type": "esriFieldTypeString",
      "alias": "Maintenance Responsibility",
      "length": 70
     },
     {
      "name": "POLL_FILE_NUMBER",
      "type": "esriFieldTypeString",
      "alias": "Pollinator Site File Number",
      "length": 10
     },
     {
      "name": "PH_CODE",
      "type": "esriFieldTypeString",
      "alias": "PH Site Code",
      "length": 10
     },
     {
      "name": "SITE",
      "type": "esriFieldTypeString",
      "alias": "Site",
      "length": 255
     },
     {
      "name": "SITE_TYPE",
      "type": "esriFieldTypeString",
      "alias": "Site Type",
      "length": 255
     },
     {
      "name": "PERIMETER",
      "type": "esriFieldTypeSingle",
      "alias": "Perimeter (ft)"
     },
     {
      "name": "ACRES1",
      "type": "esriFieldTypeSingle",
      "alias": "Acres"
     },
     {
      "name": "FIELD_NUMBER",
      "type": "esriFieldTypeString",
      "alias": "Field Number",
      "length": 5
     },
     {
      "name": "INVENTORY_COMMENTS",
      "type": "esriFieldTypeString",
      "alias": "Inventory Comments",
      "length": 2500
     },
     {
      "name": "INSPECTION_DUE",
      "type": "esriFieldTypeString",
      "alias": "Inspection Due",
      "length": 50
     },
     {
      "name": "EVAL_ASSIGNED_TO",
      "type": "esriFieldTypeString",
      "alias": "Evaluation Assigned to",
      "length": 30
     },
     {
      "name": "STAND_EVAL_COMP_DATE",
      "type": "esriFieldTypeDate",
      "alias": "Standard Evaluation Complete Date",
      "length": 8
     },
     {
      "name": "STAND_EVAL_NAME",
      "type": "esriFieldTypeString",
      "alias": "Standard Evaluator Name",
      "length": 30
     },
     {
      "name": "MAINTAIN_RECCOMEND",
      "type": "esriFieldTypeString",
      "alias": "Maintenance Recommendations",
      "length": 2500
     },
     {
      "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": "sys_updated_date",
      "type": "esriFieldTypeDate",
      "alias": "sys_updated_date",
      "length": 8
     },
     {
      "name": "GlobalID",
      "type": "esriFieldTypeGlobalID",
      "alias": "GlobalID",
      "length": 38
     },
     {
      "name": "OBJECTID",
      "type": "esriFieldTypeOID",
      "alias": "OBJECTID"
     }
    ],
    "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": ""
  }
 ]
}