Skip To Content

Add data

Your data is the basis of everything you do in Insights. You can add data to your workbook page from various data sources, making it easy for you to find the data you need for your analysis.

Add data from the home page

The Datasets tab Datasets on the home page gives you access to the feature layers that you created or that were shared with you by members of your organization. Clicking on the title of a dataset will open the dataset in a new workbook. You can use the search bar, filter, Favorites list Favorites, View items button View items, and Sort button Sort to help you find the items you want to add to a page.

The Add to page window

The Add to page window organizes your data to make it available in your workbook. Data types are organized into tabs, and the available tabs depend on the Insights deployment (Insights in ArcGIS Enterprise, Insights in ArcGIS Online, or Insights desktop) you are using.

Insights in ArcGIS Enterprise

The following data tabs and data sources are available in Insights in ArcGIS Enterprise:

  • Living Atlas—Feature layers curated by ArcGIS Online and configured for your ArcGIS Enterprise organization.
  • Upload fileExcel workbooks, CSV files, shapefiles, and GeoJSON files that are added directly to your workbook.
  • Connections—Data from your ArcGIS Enterprise organization. The following data sources are available from your ArcGIS connection:
    • My content (default)—Feature layers created by you.
    • My groups—Feature layers created by you or another member of your organization and shared to a group of which you are a member.
    • My organization—Feature layers created by you or another member of your organization and shared to your organization.
    • Boundaries—Standard boundary feature layers that have been configured for your organization.
  • Databases—Database connections and their associated spatial and nonspatial tables.

Insights in ArcGIS Online

The following data tabs and data sources are available in Insights in ArcGIS Online:

  • Living Atlas—Feature layers curated by ArcGIS Online.
  • Upload fileExcel workbooks, CSV files, shapefiles, and GeoJSON files that are added directly to your workbook.
  • Connections—Data from your ArcGIS Online organization. The following data sources are available from your ArcGIS connection:
    • My content (default)—Feature layers created by you.
    • My groups—Feature layers created by you or another member of your organization and shared to a group of which you are a member.
    • My organization—Feature layers created by you or another member of your organization and shared to your organization.
    • Boundaries—Standard boundary features that are part of the Living Atlas content.

Insights desktop

The following data tabs and data sources are available in Insights desktop:

  • Living Atlas—Feature layers curated by ArcGIS Online
  • Upload fileExcel workbooks, CSV files, shapefiles, and GeoJSON files that are added directly to your workbook.
  • Local content—Feature layers created by you.
  • Connections—Data from your ArcGIS connections. The following data sources are available for each connection:
    • My content (default)—Feature layers created by you.
    • My groups—Feature layers created by you or another member of your organization and shared to a group of which you are a member.
    • My organization—Feature layers created by you or another member of your organization and shared to your organization.
    • Boundaries—Standard boundary feature layers that have been configured for your organization.
  • Databases—Database connections and their associated spatial and nonspatial tables.

Add data to your workbook

Use the following steps to add data to your workbook:

  1. Open the Add to page window using one of the following options:
    • Create a workbook. The Add to page window appears when the workbook is created.
    • Click the Add button Add above the data pane in an existing workbook.
    • Create a page in an existing workbook. The Add to page window appears when the page is created.
  2. Choose one or more datasets from the available tabs:
    • To choose data from the Living Atlas tab, use the following steps:
      Note:

      Living Atlas is only available for an ArcGIS organization. You must be signed in to an organization to access these tabs from Insights desktop.

      1. Click the Living Atlas tab.
      2. Find the feature layer you want to add, using the search bar and sorting tools, if necessary.
      3. Select the dataset.
    • To choose data from the Upload file tab, use the following steps:
      1. Click the Upload file tab.
      2. Browse to add files using the Browse my computer button or drag files into the window.
    • To choose data from My content, My groups, My organization, or Boundaries, use the following steps:
      Note:

      My content, My groups, My organization, and Boundaries are only available for an ArcGIS organization. You must be signed in to an organization to access these tabs from Insights desktop.

      1. Click the tab for your ArcGIS connection, if necessary. Data from My content is displayed by default.
      2. Use the drop down menu to display My groups, My organization, or Boundaries, if necessary.
        Choose My groups, My organization, or Boundaries from the menu
      3. If My groups was selected, click the group with which the data is shared.
      4. Find the feature layer you want to add, using the search bar and sorting tools if necessary.
      5. Select the dataset.
    • To choose data from the Databases tab, use the following steps:
      Note:

      The Databases tab is available for Insights in ArcGIS Enterprise and Insights desktop.

      1. Click the Databases tab.
      2. Click the database connection from which you want to add data. You can also create a connection, if necessary.
      3. Find the feature layer you want to add, using the search bar and sorting tools, if necessary.
      4. Select the dataset.

    The dataset appears in the Selected Data pane. If there is more than one layer or table associated to the selected dataset, all of the layers or tables will be listed.

  3. Optional: Deselect any datasets, layers, or tables that you do not want to add to the workbook.
  4. Click Add.

Data types

Several data types can be added to a workbook, including feature layers, files, and database datasets.

Feature layers

Feature layers in your organization are categorized in the Add to page window to make them easier for you to find. Depending on who created the layers, how they are shared, and which deployment you are using, you can find feature layers in My content, My groups, My organization, Living Atlas, and Boundaries.

Feature layers can be either hosted or remote. Hosted feature layers are identified with the dataset icon Dataset in the data pane, whereas remote feature layers are identified with the remote dataset icon Remote dataset.

A map is created automatically when you add a feature layer to your workbook.

Files

Datasets can be added directly to your workbook using the Upload file tab. A file is saved only in the current workbook and will need to be re-added to use it in a separate workbook. If a file will be used frequently, you can import the file on the home page to create a feature layer so that the data will be available in My content or Local data for all workbooks you create.

The following file formats are supported:

  • Microsoft Excel workbook (.xlsx)
  • Comma-separated values (CSV) file (.csv)
  • Shapefile (in a .zip file)
  • GeoJSON (.json, .geojson, or GeoJSON files in a .zip file)
Note:

CSV files only support one table per sheet. If your CSV file contains multiple tables per sheet, you should convert it to an Excel workbook or move the extra tables to their own sheets.

Excel and CSV files are added as nonspatial tables. To use your Excel and CSV files as spatial data, you must enable location.

In Insights in ArcGIS Enterprise, GeoJSON files in .zip format are supported for deployments using ArcGIS Enterprise 10.7 or later.

Files are identified with the dataset icon Dataset in the data pane.

No cards are created when you add data from a file. You can create charts and tables with all file types. Maps can be created with shapefiles or with Excel and CSV files that have had location enabled.

Note:

If you use Insights in ArcGIS Enterprise with a PKI authentication and your files fail to upload, it may mean that the value of the uploadReadAheadSize property needs to be increased on your IIS web server. For more information, see Frequently asked questions about distributed collaboration.

Databases

Note:

Database connections are available in Insights in ArcGIS Enterprise and Insights desktop.

Connections can be made to PostgreSQL, SQL Server, Oracle, and SAP HANA databases so that you can access database tables from directly within Insights. Database tables can be spatial or nonspatial. Spatial tables load with the location field symbol Spatial dataset.

Database tables are identified with the database dataset icon Database dataset in the data pane.

No cards are created when you add datasets from a database connection. You can create charts and tables with any database tables, or create maps if the table has a location field. You can also enable location in a table without a location field.

Note:

To ensure the accurate and consistent analysis of spatial data from database connections, Insights requires that spatial tables have either a primary key or a unique index. An exclamation mark next to the location icon indicates that neither a primary key nor a unique index is detected. You can choose which fields will be used as the location or the ID fields by clicking the location field icon and choosing from the list of spatial and nonspatial fields.

If an ID field is not specified either automatically or manually, the table will be added to Insights as a nonspatial dataset. Only one spatial field is supported for each spatial table from a database connection, where features must meet the following requirements:

  • Features must have a valid geometry or geography (null or invalid features are not supported).
  • Features must have a spatial reference identifier (SRID).
  • All features in the field must have the same SRID.
  • All features in the field must have the same geometry type.

Remove a dataset

Use the following steps to remove a dataset from the data pane:

  1. Click the Dataset options button Dataset options next to the dataset you want to remove.
  2. Click Remove Dataset.

    If there are cards on your page that contain data from the dataset you are about to remove, the following message appears: Are you sure? You are about to remove <dataset-name> from the page. <#> card(s) will be affected. If you choose Yes, Remove, the dataset and all cards containing data from the dataset are removed.

Resources

The following resources may be helpful for adding data in Insights: