The Extract Data tool packages feature layers and tables into datasets that can be used in ArcGIS Pro, Microsoft Excel, and other products. The Extract Data tool creates an item in your content containing the data from the layers. You can then download the data from the item.
Note:
The Extract Data tool provides options for exporting data, including the option to export features that are in a defined study area. For full datasets, you can also export the dataset directly from the item page. For more information, see Use layers.
The output is a hosted item containing a downloadable .csv file, file geodatabase, .kml file, or shapefile.
Learn more about how Extract Data works
Example
The manager of a small food delivery business has been tasked with increasing the efficiency of delivery routes during rush-hour traffic and exploring potential locations for a new restaurant. The manager creates a dataset consisting of delivery locations and demographic data and uses the Extract Data tool to create a comma-separated values file (.csv) that can be used for further analysis in spreadsheets or in GIS applications, such as ArcGIS Pro.
Usage notes
The Extract Data tool includes configurations for input layers, extent settings, and a result layer.
Input layers
The Input layers group includes the Input layers parameter, which specifies the feature layer or table to be extracted. Multiple layers and tables can be selected for export at the same time. Only layers that you own or with export enabled can be selected.
For feature inputs, a count of features is displayed below the layer name. The count includes all features in the layer, except features that have been removed using a filter. Environment settings, such as Processing extent, are not reflected in the feature count.
Extent settings
The Extent settings group includes the following parameters:
Extent layer specifies the point, line, or polygon features that define the extent of the features to be extracted. You can choose a layer using the Layer button, or you can create a sketch layer to use as the input using the Draw input features button.
When using a point layer or line layer as the extent layer, the extent of the extracted features will be defined by the full extent of the chosen layer, rather than by individual features. When using a polygon layer as the extent layer, the input features will be extracted if they intersect with the polygon features in the extent layer.
Note:
The extent can also be set in the Processing extent environment setting. The default processing extent is the full extent of the dataset.
If an extent layer is selected, the features that are extracted must be within the extent of both the extent layer and the processing extent. If no extent layer is selected, the extent will be based solely on the processing extent.
- Clip features that intersect the extent specifies whether features that intersect the extent will be clipped. This parameter is available when an input layer is selected for Extent layer. The parameter options are as follows:
- Unchecked—Features that intersect the extent will be extracted without clipping.
- Checked—Features that intersect the extent will be clipped, and only portions of those features within the extent will be extracted.
Result layer
The Result layer group includes the following parameters:
- Output data format specifies the file format of the item that is created. Supported formats include .csv file, file geodatabase, shapefile, and .kml file.
- Output name specifies the name of the item that is created in your content. The name must be unique. If an item with the same name already exists in your organization, the tool will fail and you will be prompted to use a different name.
- Save in folder specifies the name of a folder in My content where the result will be saved.
Limitations
The following limitations apply to the tool:
- Sketch layers are not supported as inputs.
- Extractable layers include layers that you own and layers with export enabled.
- Table layers cannot be extracted as a shapefile.
- When exporting lines or areas to a .csv file, only nonspatial attributes are extracted.
- Attachments are only extractable if the output data format is a file geodatabase and Clip features that intersect the extent is unchecked.
- The Draw input features button is not available in Scene Viewer.
Environments
Analysis environment settings are additional parameters that affect a tool's results. You can access the tool's analysis environment settings from the Environment settings parameter group.
This tool honors the following analysis environments:
- Output coordinate system
- Processing extent
Note:
The default processing extent is Full extent. This default is different from Map Viewer Classic in which Use current map extent is enabled by default.
Credits
This tool consumes credits.
Use Estimate credits to calculate the number of credits that will be required to run the tool. For more information, see Understand credits for spatial analysis.
Outputs
The output is a hosted item containing a downloadable .csv file, file geodatabase, .kml file, or shapefile. If multiple layers are extracted as .csv or .kml files, the files will be stored in a single compressed (.zip) folder.
Licensing requirements
This tool requires the following user type and configurations:
- Creator, Professional, or Professional Plus user type
- Publisher, Facilitator, or Administrator role, or an equivalent custom role
Resources
Use the following resources to learn more:
- How Extract Data works
- Extract Data in ArcGIS REST API
- extract_data in ArcGIS API for Python
- Export data in ArcGIS Pro
- Conversion toolbox in ArcGIS Pro