Extract Data

Note:

This functionality is currently only supported in Map Viewer Classic (formerly known as Map Viewer). It will be available in a future release of the new Map Viewer.

Extract Data The Extract Data tool is a convenient way to package the layers in your map into datasets that can be used in ArcGIS Pro, Microsoft Excel, and other products. Extract Data creates an item in Content containing the data in your layers. You can then download the data from the item.

Workflow diagram

Extract Data workflow diagram

Examples

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, then uses Extract Data to create a comma-separated values (CSV) file that can be used for further analysis in spreadsheets or in GIS applications, such as ArcGIS Pro.

Usage notes

The Extract Data tool requires at least one exportable layer. If you do not have any exportable layers in Map Viewer Classic, the tool will be disabled.

One or more layers can be selected for export. Only layers that you own or that the owner has enabled for export can be selected.

A boundary must be selected from which your data is extracted. The boundary can be the visible extent of your map (Same as Display), the extent of one of your layers, or a custom boundary created using the Draw tool. Features within the boundary can be extracted based on one of two methods: Select Features or Clip Features.

MethodDescription

Select Features

Entire features that cross the boundary of the study area will be extracted.

Clip Features

Only those portions of features that are within the study area will be extracted.

Data can be exported to the following formats:

  • CSV
  • File geodatabase
  • KML
  • Shapefile

Output data will use the Web Mercator 1984 projected coordinate system. For CSV outputs, latitude and longitude fields (Lat and Long) will be appended to the data table. If your dataset already includes latitude and longitude fields, such as SHAPE_X and SHAPE_Y, those will also be included in the output.

Limitations

  • Extractable layers include layers that you own and layers for which export has been enabled.
  • 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 the extract method is set to Select Features. In addition, the layer must be configured to allow others to export the data. For more information, see Export data from hosted feature layers.

How Extract Data works

The following sections provide additional details about how Extract Data works, including the settings to make layers extractable, exporting data as a CSV, and the option to export from the item page.

Layers must be extractable

For a layer to appear in the list of layers to extract, the layer must be a hosted feature layer, an ArcGIS Server feature layer, map notes, or a feature collection. The following requirements must be met to extract each data type:

  • Hosted feature layer—The owner or administrator must allow the data to be exported. For more information, see Export data from hosted feature layers.
  • ArcGIS Server feature layer—The Export Data and Enable Sync options must be enabled when published from ArcGIS Pro. For more information, see Configure a web feature layer.
  • Map notes—All map notes can be extracted.
  • Feature collection—All feature collections can be extracted.

Export to a CSV file

When you export point features to a CSV (comma-separated values) file, all attribute fields and the x- and y-coordinates of each point are exported. When exporting line and area features to a CSV file, all attribute fields are exported but not the x- and y-coordinates. This is because line and area features are made of multiple x- and y-coordinates and cannot be represented in a single column in a CSV file. If you need to export the spatial attribute of line or polygon features, export the features to a shapefile.

Export data from the item page

The Extract Data tool gives you many options when exporting data, including the option to export features that are in a study area you define. To extract the entire dataset to a shapefile or CSV file, you can use the Extract Data tool or export the data following the instructions in Use layers.

Similar tools

Use Extract Data to select and download data for a specified area of interest. Other tools may be useful in solving similar but slightly different problems.

ArcGIS Pro analysis tools

Extract Data performs a similar function to tools in the Conversion toolbox. For more on exporting data from ArcGIS Pro, see Export data.