ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Load Data

  • Summary
  • Usage
  • Syntax
  • Environments
  • Licensing information

Summary

Moves features from one schema to another by loading data from a source to a target workspace. Data mapping rules described in a cross-reference database are applied during the load.

Data that matches the schema defined in the cross-reference database for the source is appended to the target workspace. The cross-reference database contains a DatasetMapping table that lists pairs of source and target dataset names. Each source and target name pair can have a WHERE clause and a subtype. The WHERE clause defines a subset of features in the source to append to the target. Subtype identifies a subtype in the target feature class into which features are loaded.

Usage

  • The cross-reference database has other tables that affect load data functionality. These tables enable the following operations:

    • Map fields between data sources.
    • Override values from source to target.
    • Specify different source and target schema owners for enterprise geodatabases.
  • Use the Dataset Mapping Definitions parameter to specify which feature classes, shapefiles, or coverages to load from the input source to the target workspace. The list of sources and targets comes from the DatasetMapping table in the cross-reference database.

  • You can only set WHERE clauses and subtypes in the DatasetMapping table in the cross-reference database. You cannot set these in the Dataset Mapping Definitions parameter.

  • The ID value used in the Dataset Mapping Definitions parameter must refer to an existing row ID in the DatasetMapping table in the cross-reference database. The row in the DatasetMapping table contains the name of the source and target datasets.

  • This tool returns the warning Source dataset [dataset name] not found or is inaccessible for each source feature class listed in the cross-reference database that is not found in the input sources workspace.

  • This tool returns the warning Target dataset [dataset name] not found or is inaccessible for each target feature class listed in the cross-reference database that is not found in the target workspace.

Syntax

LoadData(in_cross_reference, in_sources, in_target, {in_dataset_map_defs}, {row_level_errors})
ParameterExplanationData Type
in_cross_reference

The path to a cross-reference database.

Workspace
in_sources
[in_sources,...]

A list of workspaces that contain the source features to load into the target workspace.

Workspace
in_target

The target workspace that contains the schema referenced in the cross-reference database. Source features are loaded into this workspace.

Workspace
in_dataset_map_defs
[in_dataset_map_defs,...]
(Optional)

The source to target feature class mapping list. The format of this string is id | SourceDataset | TargetDataset | WhereClause | Subtype.

String
row_level_errors
(Optional)

Indicates if the tool will log errors that occur while inserting new rows into feature classes and tables in the in_target parameter.

  • ROW_LEVEL_ERROR_LOGGING —Log errors that occur during individual row-level inserts. This is the default.
  • NO_ROW_LEVEL_ERROR_LOGGING —Do not log errors that occur during individual row-level inserts.
Boolean

Environments

  • Current Workspace

Licensing information

  • ArcGIS Desktop Basic: No
  • ArcGIS Desktop Standard: Requires Production Mapping
  • ArcGIS Desktop Advanced: Requires Production Mapping

Related topics

  • An overview of the Conversion toolset
  • Loading data into a geodatabase
  • Cross-reference mapping files
  • Creating a cross-reference database

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2019 Esri. | Privacy | Legal