What's new in the Data Management toolbox

New and improved tools for the Data Management toolbox at 10.1.

Toolset changes

New tools




Attachments toolset

Add Attachments

Adds file attachments to the records of a geodatabase feature class or table. The attachments are stored internally in the geodatabase in a separate attachment table that maintains linkage to the target dataset. Attachments are added to the target dataset using a match table that dictates for each input record (or an attribute group of records) the path to a file to add as an attachment to that record.

Disable Attachments

Disables attachments on a geodatabase feature class or table. Deletes the attachment relationship class and attachment table.

Enable Attachments

Enables attachments on a geodatabase feature class or table. Creates the necessary attachment relationship class and attachment table that will internally store attachment files.

Generate Attachment Match Table

ArcGIS geoprocessing tool that creates a match table to be used with the Add Attachments and Remove Attachment tools.

Remove Attachments

Removes attachments from geodatabase feature class or table records. Since attachments are not actually stored in the input dataset, no changes will be made to that feature class or table, but rather to the related geodatabase table that stores the attachments and maintains linkage with the input dataset. A match table is used to identify which input records (or attribute groups of records) will have attachments removed.

Fields Toolset

Add Incrementing ID Field

The Add Incrementing ID Field tool adds a database-maintained ID field to an existing table or feature class in an IBM DB2, Microsoft SQL Server, Oracle, or PostgreSQL database. This type of field is required on all feature classes or tables you plan to edit through a feature service.

Disable Editor Tracking

Disables editor tracking on a feature class, table, mosaic dataset, or raster catalog.

Enable Editor Tracking

Enables editor tracking for a feature class, table, mosaic dataset, or raster catalog.

Distributed Geodatabase toolset

Export XML Workspace Document

Creates a readable XML document of the geodatabase contents.

Import XML Workspace Document

Imports the contents of an XML workspace document into an existing geodatabase.

Geodatabase Administration toolsetAnalyze Datasets

Updates database statistics of base tables, delta tables, and archive tables, along with the statistics on those tables' indexes. This tool is used in enterprise geodatabases to help get optimal performance from the RDBMS's query optimizer. Stale statistics can lead to poor geodatabase performance.

Create Database User

The Create Database User tool creates a database user with privileges sufficient to create data in the database.

Create Enterprise Geodatabase

The Create Enterprise Geodatabase tool creates a database, storage locations, and a database user to be used as the geodatabase administrator and owner of the geodatabase depending on the database management system (DBMS) used. It grants the geodatabase administrator privileges required to create a geodatabase, then creates a geodatabase in the database.

Create Role

The Create Role tool creates a database role and lets you add users to or remove users from the role.

Enable Enterprise Geodatabase

The Enable Enterprise Geodatabase tool creates geodatabase system tables, stored procedures, functions, and types in an existing enterprise database, thereby enabling geodatabase functionality in the database.

Rebuild Indexes

Updates indexes of datasets and system tables stored in an enterprise geodatabase. This tool is used in enterprise geodatabases to rebuild existing attribute or spatial indexes. Out-of-date indexes can lead to poor geodatabase performance.

Upgrade Dataset

Upgrades the schema of a mosaic dataset, network dataset, or parcel fabric to the current ArcGIS release. Upgrading the dataset allows the dataset to make use of new functionality available in the current software release.

Geometric Network toolsetAdd Edge-Edge Connectivity Rule to Geometric Network

Adds an edge-edge connectivity rule to a geometric network.

Add Edge-Junction Connectivity Rule to Geometric Network

Adds an edge-junction connectivity rule to a geometric network.

Create Geometric Network

Creates a geometric network in a geodatabase using the specified feature classes, role for each feature class, and the specified weights with weight associations.

Remove Connectivity Rule From Geometric Network

Removes a connectivity rule from the geometric network.

Remove Empty Feature Class from Geometric Network

Removes an empty feature class from a geometric network.

Trace Geometric Network

Solves the specified network analysis problem based on the flags, barriers, and specified weight properties.

Set Flow Direction

Sets the flow direction for a geometric network based on either the digitized direction or the source/sink settings in the geometric network.

LAS Dataset toolsetCreate LAS Dataset

Creates a LAS dataset referencing one or more LAS files and optional surface constraint features.

Add Files To LAS Dataset

Adds references for one or more LAS files and surface constraint features to a LAS dataset.

Remove Files From LAS Dataset

Removes one or more LAS files and surface constraint features from a LAS dataset.

LAS Dataset Statistics

Calculates or updates statistics for a LAS dataset and generates an optional statistics report.

LAS Point Statistics As Raster

Creates a raster whose cell values reflect statistical information about measurements from LAS files referenced by a LAS dataset.

Layers and Table Views toolsetMake Query Layer

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

Package toolsetConsolidate Result

Consolidates one or more geoprocessing results into a specified output folder.

Package Result

Packages one or more geoprocessing results, including all tools and input and output datasets, into a single compressed file (.gpk).

Consolidate Locator

Consolidate a locator or composite locator by copying all locators into a single folder.

Package Locator

Package a locator or composite locator to create a single compressed .gcpk file.

Create Map Tile Package

Generates tiles from a map document and packages the tiles to create a single compressed .tpk file.

Photos toolsetGeoTagged Photos To Points

Creates points from the x-, y-, and z-coordinate information stored in geotagged photos. Optionally adds photo files to features in the output feature class as geodatabase attachments.

Match Photos To Rows By Time

Matches photo files to table or feature class rows according to the photo and row time stamps. The row with the time stamp closest to the capture time of a photo will be matched to that photo. Creates a new table containing the ObjectIDs from the input rows and their matching photo paths. Optionally adds matching photo files to the rows of the input table as geodatabase attachments.

Topology toolsetExport Topology Errors

Exports the errors from a geodatabase topology to the target geodatabase. All information associated with the errors and exceptions, such as the features referenced by the error or exception, are exported. Once they are exported, the feature classes can be accessed using any license level of ArcGIS. The feature classes can be used with the Select by Location dialog box or the Select Layer By Location tool and can be shared with other users who do not have access to the topology itself.

Versions toolsetReconcile Versions

Reconciles a version or multiple versions against a target version.

Create Versioned View

Creates a versioned view on a table or feature class.

Workspace_toolsetCreate Database Connection

Creates a connection file that can be used to connect to an enterprise database or ArcSDE geodatabase.

Create Spatial Type

The Create Spatial Type tool adds the ST_Geometry SQL type, subtypes, and functions to an Oracle or PostgreSQL database. This allows you to use the ST_Geometry SQL type to store geometries in a database that does not contain a geodatabase. This tool also can be used to upgrade an existing ST_Geometry installation in an Oracle or PostgreSQL database.

Improved tools

Geodatabase Administration



Register With Geodatabase

Prior to ArcGIS 10.1, database tables and feature classes had to be registered with ArcSDE using an ArcSDE command line utility before they could be registered with the geodatabase. Database tables and feature classes can now be registered with the geodatabase in one step.

Related Topics