Main menu

Pages

Create Database View, Delete and Find Identical

Create Database View, Delete and Find Identical Tools

Create Database View

How to Create Database View Tool in ArcToolbox ArcMap ArcGIS??

Create Database View Tool
Create Database View

Path to access the tool

:

Create Database View Tool, General Toolset, Data Management Tools Toolbox

 

Create Database View

Creates a view in a database based on an SQL expression.

1.    Input Database Connection

The database that contains the tables or feature classes used to construct the view. This database is also where the view will be created.

2.    Output View Name

The name of the view that will be created in the database.

3.    View Definition

An SQL statement used to construct the view.

Delete

How to Delete Tool in ArcToolbox ArcMap ArcGIS??

Delete Tool
Delete Tool

Path to access the tool

:

Delete Tool, General Toolset, Data Management Tools Toolbox

 

Delete

Permanently deletes data from disk. All types of geographic data supported by ArcGIS, as well as toolboxes and workspaces (folders, geodatabases), can be deleted. If the specified item is a workspace, all contained items are also deleted.

1.    Input Data Element

The input data to be deleted.

2.    Data type (optional)

The type of the data on disk to be deleted. This is only necessary when the input data is in a geodatabase and naming conflicts exist, for example, if the geodatabase contains a feature dataset and a feature class with the same name. In this case, the data type is used to clarify which dataset you want to delete.

Delete Identical

How to Delete Identical Tool in ArcToolbox ArcMap ArcGIS??

Delete Identical Tool
Delete Identical

Path to access the tool

:

Delete Identical Tool, General Toolset, Data Management Tools Toolbox

 

Delete Identical

Deletes records in a feature class or table which have identical values in a list of fields. If the field Shape is selected, feature geometries are compared.

The Find Identical tool can be used to report which records are considered identical without deleting the identical records.

1.    Input Dataset

The table or feature class that will have its identical records deleted.

2.    Field(s)

The field or fields whose values will be compared to find identical records.

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

3.    XY Tolerance (optional)

The xy tolerance that will be applied to each vertex when evaluating if there is an identical vertex in another feature.

4.    Z Tolerance (optional)

The z tolerance that will be applied to each vertex when evaluating if there is an identical vertex in another feature.

Find Identical

How to Find Identical Tool in ArcToolbox ArcMap ArcGIS??

Find Identical Tool
Find Identical

Path to access the tool

:

Find Identical Tool, General Toolset, Data Management Tools Toolbox

 

Find Identical

Reports any records in a feature class or table that have identical values in a list of fields, and generates a table listing these identical records. If the field Shape is selected, feature geometries are compared.

The Delete Identical tool can be used to find and delete identical records.

1.    Input Dataset

The table or feature class for which identical records will be found.

2.    Output Dataset

The output table reporting identical records. The FEAT_SEQ field in the output table will have the same value for identical records.

3.    Field(s)

The field or fields whose values will be compared to find identical records.

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

4.    XY Tolerance (optional)

The xy tolerance that will be applied to each vertex when evaluating if there is an identical vertex in another feature. This parameter is enabled only when Shape is selected as one of the fields.

5.    Z Tolerance (optional)

The Z tolerance that will be applied to each vertex when evaluating if there is an identical vertex in another feature. This parameter is enabled only when Shape is selected as one of the fields.

6.    Output only duplicated records (optional)

Choose if you want only duplicated records in the output table.

Unchecked—All input records will have corresponding records in the output table. This is the default.

Checked—Only duplicate records will have corresponding records in the output table. The output will be empty if no duplicate is found.

Comments

table of contents title