Add data from SharePoint

Note:

To add SharePoint lists to a map, the lists must first be spatially enabled (geocoded). To spatially enable lists, see Geocode lists containing address or place name data and Geocode lists containing coordinate data.

ArcGIS for SharePoint works directly with your organization's SharePoint data, allowing you to use spatially enabled content in your SharePoint site and add it to the ArcGIS for SharePoint web part. Adding data from SharePoint is a quick way to add content to a map to complement existing information. For example, if you have a map of household income census data and a SharePoint list showing store locations and revenue, you can add the SharePoint data to the map to visualize and analyze spending trends.

With ArcGIS for SharePoint, you can add spatially enabled lists containing addresses or place-names, or lists containing coordinate data, to a map. Once added, they become layers in the map.

  1. Place the map in edit mode.

    Only layers that are added while the ArcGIS for SharePoint web part is in edit mode are saved with the map.

  2. From the map tools, select Layers Layers.

    The Layers pane appears.

  3. Click Add from SharePoint.

    The Add from SharePoint pane appears, displaying available lists in the current SharePoint site.

    Lists that are not spatially enabled appear inactive and cannot be added. However, you can click Configure data Configure data and add spatial information to these lists.

  4. Search for a list to add by typing one or more keywords in the Search text box.
  5. Click the Subsite picker button Subsite picker to change the subsite and browse its lists.
  6. Click the Filter button Filter and specify the filtering parameters for the results.
    • Turn on the Show geoenabled lists only toggle button to restrict the search results to lists that have been spatially enabled and can be added to the map.
    • Filter by list type or by date modified. Click to expand a section and choose an option. Click Clear filters to remove the filters.
  7. Click the Sort button Sort list to sort the results alphabetically.
  8. From the list of available data, click the button next to a list to expand its contents.

    Depending on how your list view is configured, the contents may list one or more subsets of the list, or only All items.

  9. Find the list you want to add and click its Add data button Add.

    A layer containing the data is added to the map and the map view zooms to display the full extent of the layer. The layer is listed in the layer list.

  10. Optionally, click Configure data Configure data to map the custom label fields and specify spatial reference.

    For Spatial Reference you can search for a Well-Known ID and press Enter, or you can choose from the drop-down menu, or select the default 4326 - GCS WGS 1984.

  11. Click Add to map.
  12. Click Back Back/ Return when you finish adding layers from SharePoint to return to the layer list.

Choose a location type

To add ArcGIS for SharePoint data to a map, the SharePoint data must contain at least one of these location types: latitude and longitude values (coordinates), or Esri JSON Geometry.

The location type selected determines how the data is mapped. If you choose Coordinates, the locations are mapped as points. If you choose ESRI JSON Geometry, the data is mapped as polygons, polylines or points.

To choose a location type, do the following:

  1. In the Add from SharePoint pane, click Configure data Configure data and choose a location type from the Location types drop-down menu.

    Depending on the location type you choose, different data options appear. Use the drop-down menus to choose the appropriate columns in the data to match the location fields.

  2. Use the following options to choose and format the location type:
    • Coordinates—Use the Longitude (X) and Latitude (Y) drop-down menus to match columns in the data that contain coordinates. If necessary, use the Spatial Reference drop-down menu to change the selected spatial reference system.

    • ESRI JSON Geometry—Use the Geometry column drop-down menu to identify which column contains the geometry. Esri JSON encodes both geometry and feature information into objects. An Esri feature set is a collection of features with the same geometry type and coordinate system. In a JSON document, a feature set is represented by a JSON object.
  3. Click Add to map.

Choose a coordinate system

To use a spatial reference other than the standard WGS, Web Mercator, or other well-known coordinate system, you can search for a Well-Known ID and press Enter, or you can choose from the drop-down menu, or select the default 4326 - GCS WGS 1984.

To add a custom coordinate system, do the following:

  1. In the Add from SharePoint pane, click Configure data Configure data.
  2. Choose Coordinates from the Location Types drop-down menu.
  3. Use the Longitude (X) and Latitude (Y) drop-down menus to choose the appropriate columns in the data to match the x- and y-fields.
  4. Choose an existing system from the Spatial Reference drop-down menu, or search for a spatial reference system in the text box.