Display Name: Select Layer By Attribute

Description: Adds, updates, or removes a selection based on an attribute query.

Category:

Help URL: https://collectordev.dot.state.oh.us/arcgis/rest/directories/arcgisoutput/POLLINATOR_SITES/Pollinator_Sites_GPServer/POLLINATOR_SITES_Pollinator_Sites/SelectLayerByAttribute.htm

Execution Type: esriExecutionTypeAsynchronous

Parameters:

Parameter: in_layer_or_view

Data Type: GPString
Display Name Input Rows
Description: The data to which the selection will be applied.
Direction: esriGPParameterDirectionInput
Filter:
Dependency:
Default Value: Active Pollinator Sites
Parameter Type: esriGPParameterTypeRequired
Category:
Choice List: [ Pollinator Sites Inspection Table, Rapid Assessment Inspection Table, Pollinator Sites Treatment Table, Active Pollinator Sites, Active Pollinator Rapid Assessment ]


Parameter: selection_type

Data Type: GPString
Display Name Selection Type
Description: Specifies how the selection will be applied and what to do if a selection already exists.New selection—The resulting selection will replace the current selection. This is the default.Add to the current selection—The 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—The resulting selection will be removed from the current selection. If no selection exists, this option has no effect.Select subset from the current selection—The resulting selection will be combined with the current selection. Only records that are common to both remain selected.Switch the current selection—The 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—The selection will be cleared or removed. The Expression parameter is ignored when this option is specified.
Direction: esriGPParameterDirectionInput
Filter:
Dependency:
Default Value: New selection
Parameter Type: esriGPParameterTypeOptional
Category:
Choice List: [ 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 ]


Parameter: where_clause

Data Type: GPString
Display Name Expression
Description: An SQL expression used to select a subset of records.
Direction: esriGPParameterDirectionInput
Filter:
Dependency: in_layer_or_view
Default Value: STATUS = 'A' And SITE_TYPE 'Perennial Sunflowers'
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: out_layer_or_view

Data Type: GPFeatureRecordSetLayer
Display Name Updated Layer Or Table View
Description:
Direction: esriGPParameterDirectionOutput
Filter:
Dependency:
Default Value:
Geometry Type: esriGeometryPoint
HasZ: false
HasM: false
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)
Fields:
• NLFID ( type: esriFieldTypeString, alias: NLFID, length: 14 )
• CRS ( type: esriFieldTypeString, alias: CRS, length: 17 )
• ODOT_DISTRICT ( type: esriFieldTypeString, alias: ODOT District, length: 2 )
• COUNTY ( type: esriFieldTypeString, alias: County, length: 10 )
• COUNTY_CD ( type: esriFieldTypeString, alias: County CD, length: 3 )
• ROUTE_TYPE ( type: esriFieldTypeString, alias: Route Type, length: 2 )
• ROUTE_NBR ( type: esriFieldTypeString, alias: Route Number, length: 5 )
• ROUTE_SUFFIX ( type: esriFieldTypeString, alias: Route Suffix, length: 1 )
• STREET_NAME ( type: esriFieldTypeString, alias: Street Name, length: 100 )
• CTL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: CTL Begin Number )
• STL_BEGIN_NBR ( type: esriFieldTypeDouble, alias: STL Begin Number )
• LATITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Latitude DD Begin )
• LONGITUDE_DD_BEGIN ( type: esriFieldTypeDouble, alias: Longitude DD Begin )
• PERP_DATE ( type: esriFieldTypeDate, alias: PERP Date, length: 8 )
• STATUS ( type: esriFieldTypeString, alias: Status, length: 1 )
• INSTALLATION_DATE ( type: esriFieldTypeDate, alias: Installation Date, length: 8 )
• MAINTAIN_RESPONSIBLE ( type: esriFieldTypeString, alias: Maintenance Responsibility, length: 70 )
• POLL_FILE_NUMBER ( type: esriFieldTypeString, alias: Pollinator Site File Number, length: 10 )
• PH_CODE ( type: esriFieldTypeString, alias: PH Site Code, length: 10 )
• SITE ( type: esriFieldTypeString, alias: Site, length: 255 )
• SITE_TYPE ( type: esriFieldTypeString, alias: Site Type, length: 255 )
• PERIMETER ( type: esriFieldTypeSingle, alias: Perimeter (ft) )
• ACRES1 ( type: esriFieldTypeSingle, alias: Acres )
• FIELD_NUMBER ( type: esriFieldTypeString, alias: Field Number, length: 5 )
• INVENTORY_COMMENTS ( type: esriFieldTypeString, alias: Inventory Comments, length: 2500 )
• INSPECTION_DUE ( type: esriFieldTypeString, alias: Inspection Due, length: 50 )
• EVAL_ASSIGNED_TO ( type: esriFieldTypeString, alias: Evaluation Assigned to, length: 30 )
• STAND_EVAL_COMP_DATE ( type: esriFieldTypeDate, alias: Standard Evaluation Complete Date, length: 8 )
• STAND_EVAL_NAME ( type: esriFieldTypeString, alias: Standard Evaluator Name, length: 30 )
• MAINTAIN_RECCOMEND ( type: esriFieldTypeString, alias: Maintenance Recommendations, length: 2500 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )
• sys_updated_date ( type: esriFieldTypeDate, alias: sys_updated_date, length: 8 )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
Features: None.



Parameter Type: esriGPParameterTypeDerived
Category:


Parameter: invert_where_clause

Data Type: GPBoolean
Display Name Invert Where Clause
Description: Specifies whether the expression will be used as is, or the opposite of the expression will be used.Unchecked—The query will be used as is. This is the default.Checked—The 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
Filter:
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeOptional
Category:


Parameter: count

Data Type: GPLong
Display Name Count
Description:
Direction: esriGPParameterDirectionOutput
Filter:
Dependency:
Default Value:
Parameter Type: esriGPParameterTypeDerived
Category:

Supported Operations:   Submit Job

Child Resources:   Metadata