3D Analyst Tools ArcToolbox

Make Query Layer, Table and Raster Catalog Layer Tools

Make Query Layer

How to Make Query Layer Tool in ArcToolbox ArcMap ArcGIS??

Make Query Layer

Path to access the tool

:

Make Query Layer Tool, Layers and Table Views Toolset, Data Management Tools Toolbox

 

Make Query Layer

Creates a query layer from a DBMS table based on an input SQL select statement.

1.    Input Database Connection

The database connection file that contains the data to be queried.

2.    Output Layer Name

The output name of the feature layer or table view to be created.

3.    Query

The SQL statement that defines the select query to be executed in the database.

This string must pass validation before remaining controls will be enabled. Validation will be triggered when you click outside this input box. The validation process executes 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 Model Builder, in which case validation will not be triggered if the input is derived data.

Rules for validation are as follows:

1. The result of the SQL query must have only one spatial field.
2. The result of the SQL query must have only one spatial reference.
3. The result of the SQL query must have only one entity type, such as point, multipoint, line, or polygon.
4. The result of the SQL query cannot have any field types not supported by ArcGIS; ArcGIS field data types describes the field types supported in ArcGIS.

Validation is especially important when working with data in spatial databases that do not enforce the same standards as ArcGIS.

4.    Unique Identifier Field(s) (optional)

One or more fields from the SELECT statement SELECT list that will generate a dynamic, unique row identifier.

5.    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 executing the tool if it is not the desired output shape type. This parameter is ignored if the result set of the query does not return a geometry field.

1. POINT—The output query layer will use point geometry.
2. MULTIPOINT—The output query layer will use multipoint geometry.
3. POLYGON—The output query layer will use polygon geometry.
4. POLYLINE—The output query layer will use polyline geometry.

6.    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 executing the tool if it is not the desired output SRID value. This parameter is ignored if the result set of the query does not return a geometry field.

7.    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 executing the tool if it is not the desired output coordinate system. This parameter is ignored if the result set of the query does not return a geometry field.

Make Query Table

How to Make Query Table Tool in ArcToolbox ArcMap ArcGIS??

Make Query Table

Path to access the tool

:

Make Query Table Tool, Layers and Table Views Toolset, Data Management Tools Toolbox

 

Make Query Table

This tool applies an SQL query to a database, and the results are represented in a layer or table view. The query can be used to join several tables or return a subset of fields or rows from the original data in the database.

This tool accepts data from a geodatabase or database connection.

1.    Input Tables

The name of the table or tables to be used in the query. If several tables are listed, the Expression parameter can be used to define how they are to be joined.

The input table can be from a geodatabase or a database connection.

2.    Fields (optional)

The fields to include in the layer or table view. If an alias is set for a field, this is the name that appears. If no fields are specified, all fields from all tables are included. If a Shape field is added to the field list, the result is a layer; otherwise it is a table view.

3.    Expression (optional)

An SQL expression used to select a subset of records.

4.    Table Name

The name of the layer or table view that will be created by the tool.

5.    Key Field Options

Layers and table views in ArcGIS require an ObjectID field. An ObjectID field is an integer field used to uniquely identify rows in the data being used. In this tool, this parameter is used to indicate how an ObjectID field will be generated (if at all) for the query. The default is Use key fields (USE_KEY_FIELDS in Python).

1. USE_KEY_FIELDS—This indicates that the fields chosen in the Key Fields parameter can be used to uniquely identify a row in the output table. This can be a single field or a combination of multiple fields, which, when combined, uniquely identify a row in the output table. If there are no fields chosen in the key fields list, the Generate a key field option (ADD VIRTUAL_KEY_FIELD in Python) is automatically applied.
2. ADD_VIRTUAL_KEY_FIELD—If no key fields have been specified, you can choose this option to have an ObjectID generated that uniquely identifies each row in the output table.
3. NO_KEY_FIELD—This option indicates that no ObjectID field is to be generated. Choosing this option means that selections will not be supported for the table view.

If there is already a field of type ObjectID in the fields list, it will be used as the ObjectID even if this option is chosen.

6.    Key Fields (optional)

Specifies a field or combination of fields that can be used to uniquely identify a row in the query. This parameter is used only when the Use Key Fields option is set.

The Add Field button, which is used only in ModelBuilder, allows you to add expected fields so you can complete the dialog box and continue to build your model.

Make Raster Catalog Layer

How to Make Raster Catalog Layer Tool in ArcToolbox ArcMap ArcGIS??

Make Raster Catalog Layer

Path to access the tool

:

Make Raster Catalog Layer Tool, Layers and Table Views Toolset, Data Management Tools Toolbox

 

Make Raster Catalog Layer

Creates a raster catalog layer from an input raster catalog. The layer that is created by the tool is temporary and will not persist after the session ends unless the layer is saved to disk or the map document is saved.

1.    Raster Catalog

The raster catalog containing one or more raster catalog items (raster datasets).

2.    Layer Name or Table View

Name of the temporary raster catalog layer.

3.    Expression (optional)

An SQL expression used to select a subset of raster catalog items.

The syntax for the expression differs slightly depending on the data source. For example, if you're querying file or ArcSDE geodatabases, enclose field names in double quotes:

"MY_FIELD"

If you're querying personal geodatabases, enclose fields in square brackets:

[MY_FIELD].

4.    Workspace (optional)

The input workspace used to validate the field names. If the input is from a file or personal geodatabase and the output workspace is an ArcSDE geodatabase, the field names may be truncated, since some database fields can only have names with ten characters or less. The new names may be reviewed and altered using the Field Info parameter.

5.    Field Info (optional)

Specifies which fields from the input table to rename and make visible in the output table view.