Label | Explanation | Data Type |
Input Database Connection
| The database connection file that contains the data to be queried. | Workspace |
Output Layer Name
| The output name of the feature layer or table view to be created. | String |
Query
| The SQL statement that defines the select query to be run in the database. Note:This string must pass validation before the remaining controls will be enabled. Validation will be triggered when you click outside this input box. The validation process runs the query in the database and verifies whether the result of the SQL query meets the data modeling standards enforced by ArcGIS. If the validation fails, the tool will return a warning. The only exception is for ModelBuilder, in which case validation will not be triggered if the input is derived data. Rules for validation are as follows:
Validation is especially important when working with data in spatial databases that do not enforce the same standards as ArcGIS. | String |
Unique Identifier Field(s)
(Optional) | One or more fields from the SELECT statement SELECT list that will generate a dynamic, unique row identifier. | String |
Shape Type
(Optional) | Specifies the shape type of the query layer. Only those records from the result set of the query that match the specified shape type will be used in the output query layer. Tool validation will attempt to set this property based on the first record in the result set. This can be changed before running the tool if it is not the correct output shape type. This parameter is ignored if the result set of the query does not return a geometry field.
| String |
SRID (Optional) | The spatial reference identifier (SRID) value for queries that return geometry. Only those records from the result set of the query that match the specified SRID value will be used in the output query layer. Tool validation will attempt to set this property based on the first record in the result set. This can be changed before running the tool if it is not the correct output SRID value. This parameter is ignored if the result set of the query does not return a geometry field. | String |
Coordinate System
(Optional) | The coordinate system that will be used by the output query layer. Tool validation will attempt to set this property based on the first record in the result set. This can be changed before running the tool if it is not the correct output coordinate system. This parameter is ignored if the result set of the query does not return a geometry field. | Spatial Reference |
Define the spatial properties of the layer
(Optional) | Specifies how the spatial properties for the layer will be defined. During the validation process, dimensionality, geometry type, spatial reference, SRID, and unique identifier properties will be set on the query layer. These values are based on the first row returned in the query. To manually define these properties instead of the tool querying the table to get them, this parameter is checked by default.
| Boolean |
Coordinates include M values
(Optional) | Specifies whether the layer will have m-values.
| Boolean |
Coordinates include Z values
(Optional) | Specifies whether the layer will have z-values.
| Boolean |
Extent
(Optional) | The extent of the layer. This parameter is only used if the Define the spatial properties of the layer parameter is checked (spatial_properties = DEFINE_SPATIAL_PROPERTIES in Python). The extent must include all features in the table.
| Extent |
Derived Output
Label | Explanation | Data Type |
Output Layer | The output query layer. | Table View |