Essential vocabulary

The following terms are used in ArcGIS for Microsoft 365. For more Esri and GIS terminology, see the Esri GIS dictionary.

Action (Power Automate)

The processes available in a Microsoft Power Automate flow. ArcGIS Connectors for Power Automate actions connect your flow to the services and privileges in your ArcGIS account. Depending on the action, either the standard ArcGIS connector or the ArcGIS PaaS connector is required to use the services accessed by the actions.

Aggregate (Excel)

A method of summarizing data used in analysis and exploration. Depending on the data and location type, you may be able to use the aggregate functionality when adding data. When you aggregate the data, ArcGIS for Excel creates a Microsoft Excel pivot table and adds it as a worksheet to an existing  Excel workbook. For example, you can aggregate office location data to show the total number of employees in each state, as opposed to the individual office locations that might span multiple cities in a single state.

ArcGIS

The brand name for  Esri GIS products. ArcGIS provides an online infrastructure for making maps and geographic information available throughout an organization, across a community, and on the web. By signing in to your ArcGIS organization, you can access ready-to-use maps and apps or create maps that tell a story. With ArcGIS for Microsoft 365, you can combine your business data with data from ArcGIS to create detailed maps that help you analyze the data visually and make better decisions. ArcGIS also allows you to share maps and map layers within your organization or with colleagues in the field.

Areas

Enclosed polygons that represent the shape and location of homogeneous features such as states, counties, parcels, and land-use zones.

Attributes

Fields and values for a single feature or nonspatial record. Attributes are typically stored in a database or service, such as a feature service. They are used to classify and filter data in data-driven visualizations.

Autoupdate (Excel)

An automatic function that updates the map when you make a change to the  Excel data. After you've added Excel data to a map, you can update the values in the spreadsheet and insert or delete rows and columns, and the map automatically refreshes to reflect the changes. Changes are also reflected automatically in pop-ups.

Basemap

A layer that provides a geographical context, or background, for the content you want to display in a map. With ArcGIS for Microsoft 365, you can choose from several basemaps hosted on ArcGIS. These include options that combine road, aerial, and topographic data with a variety of symbology. If your organization makes them available, you can also sign in to access basemaps from your ArcGIS organization.

Clustering

The function of organizing point features that are within a certain distance of each other into a single symbol to view and understand a map containing many data points. This is different from grouping in which features are grouped by a user-specified category and styled accordingly.

Contributor

A Microsoft 365 user role that has been assigned Create or Edit privileges by the Microsoft 365 account administrator. This role includes the following Microsoft 365 component designations: Microsoft Excel Users, Microsoft Power BI Contributors, and Microsoft SharePoint Contributors.

Coordinate system

A reference framework that consists of points, lines, or surfaces, and a set of rules used to define real-world locations.

In ArcGIS for Microsoft 365, you can choose between World Geodetic Survey 1984 (WGS84), Web Mercator, and several other supported coordinate systems. You can also import a custom coordinate system from a map or feature service hosted on ArcGIS.

A geographic coordinate system is used to find locations on a globe or sphere. WGS84 is a common geographic coordinate system in which every location on the earth is specified by a set of numbers (coordinates). Coordinates are often expressed as latitude and longitude values.

A projected coordinate system is used to translate locations on a globe to locations on a flat surface, such as a monitor or paper map. Web Mercator is a common projected coordinate system in which locations are identified by x,y coordinates on a grid, with the origin at the center of the grid. Coordinate values in the Web Mercator system generally have six, seven, or eight digits to the left of the decimal, and the units are meters. If you are unsure which coordinate system to use, contact the originator of the data or the person who collected it.

Coordinates

Coordinates are used to represent locations in space relative to other locations. Coordinates are often shown in latitude-longitude pairs in which x-coordinates range from -180 to 180 and y-coordinates range from -90 to 90, or as values with six, seven, or eight digits to the left of the decimal point. When using ArcGIS for Microsoft 365, these value pairs are often composed of the values from two columns in the data.

Feature

The term geographic feature is typically shortened to feature in ArcGIS for Microsoft 365. Geographic features are representations of things located on or near the surface of the earth. Geographic features can occur naturally (such as rivers and vegetation), can be construction items (such as roads, pipelines, wells, and buildings), and can be subdivisions of land (such as cities, boundaries, or land parcels). Geographic features are most commonly represented on a map as points, lines, or polygons. In ArcGIS for Microsoft 365, data you add to a map is represented as geographic features.

Feature service

A data hosting endpoint that provides access to a collection of geographic features. Each feature in a feature collection has a spatial location, a set of properties, map symbology, and pop-up information. You can search for feature services in ArcGIS and add them to a map. When you add a feature service to a map, it becomes one or more layers in the map.

Field well (Power BI)

A text box in the Microsoft Power BI Visualizations > Build visual tab that is used to transfer report data into the active ArcGIS for Power BI map visualization. For example, coordinate (address) data placed in a Location field well transfers location data to the map visual. The functions or actions performed by the map depend on the field well and data type selected. Field wells also are used to apply Microsoft Power BI behaviors to all report visualizations, such as Drill through or filters. Available ArcGIS for Power BI field wells are described in the ArcGIS for Power BI user interface topic.

Grouping

The process of placing features in user-specified categories and styling them accordingly.

Heat map

A map that shows the relative geographic distribution of point density using a continuous color ramp that implies temperature ranging from cool (few points) to hot (many points).

Layer

A method of visually representing geographic data. A map can contain multiple layers, and each layer is rendered as one legend item on that map. On a road map, for example, roads, national parks, political boundaries, and rivers can each be considered unique, separate layers. When you add data to a map, ArcGIS for Microsoft 365 creates a layer for that data and includes it in the Layers list. Once the layer is created, editable functionality such as layer visibility, style configurations, and transparency is enabled.

Lines

A type of feature geometry containing ordered point coordinates and a spatial reference. Each point on a line can be expressed as an x,y coordinate, with an optional z-value for elevation and m-value for linear referencing.

Map

A collection of layers that displays geographic data and is used to explore and interact with that data. You can add  ArcGIS for Microsoft 365 data directly to a map and combine it with content from  ArcGIS.

Map service

A data hosting endpoint that provides prestyled collections of map cartography organized by location and scale. You can search for map services on ArcGIS and add their contents to a map. When you add map service content to a map, it becomes one or more layers in the map.

Normalization (Excel)

The process of standardizing data to reduce outliers. In ArcGIS for Excel. the values in a selected Divided By  attribute are used to divide the value of another attribute; this is used to style the map using ratios. Normalization ratios are useful when other factors influence numeric data. For example, population can be influenced by each county's size, so you can divide a population count by area to standardize the data. Data normalization is also useful for providing a meaningful comparison when field values do not use the same units of measurement.

Pan

The function of shifting a map extent relative to the display window without changing the viewing scale. Panning can also be thought of as moving the map image across the display window to view different parts of the map.

PivotTable (Excel)

An Excel tool used to aggregate data values so that table content can be sorted, filtered, and rearranged dynamically to emphasize different aspects of the data. In ArcGIS for Excel, a pivot table is used when adding data to a map. A pivot table is not added to the Add data wizard if it contains a nonnative data type, has a hierarchy, or has more than one row label. Nonnative data types that are generated by third-party Excel plug-ins and do not directly conform to typical data types are stored in a RDBMS.

For more information, see the Microsoft Overview of PivotTable and PivotChart reports article or the ArcGIS Visualize Aggregated Pivot Table Data in ArcGIS for Excel blog.

Points

A type of geometry that represents discrete locations of geographic features, such as well locations, telephone poles, and stream gauges. They contain a single set of x,y coordinates and a spatial reference and are often expressed in longitude (x) and latitude (y) values. They can also have an optional z-value for elevation and an m-value for linear referencing. Points can also represent address locations, GPS coordinates, or mountain peaks.

Polygons

Geometric enclosed areas (many-sided figures) that represent the shape and location of features such as states, counties, parcels, and land-use zones. Polygons are often called areas. Each polygon is composed of a series of x,y coordinates, or points, and a spatial reference, as well as an optional z-value that defines each x,y coordinate's elevation, and an optional m-value for linear referencing. These define the precise location (latitude and longitude) of the polygon's boundary.

Standard user

An ArcGIS for Microsoft 365 account type that is included with a Microsoft 365 license. A licensed Microsoft 365 user that is not signed in to an ArcGIS account can access ArcGIS for Microsoft 365 components (ArcGIS for Excel, ArcGIS for Power BI, ArcGIS for SharePoint, and ArcGIS for Teams, provided that these components have been properly installed and configured by the administrator or by an authorized user).

Note:

This account type has limited functionality. Functionality that is available to you as a Standard user or that requires an ArcGIS account are noted throughout this help documentation.

Table (Excel)

A specific set of rows and columns in an Excel worksheet. In Excel, a table is an item specifically created by the user of the workbook and is not equivalent to the spreadsheet. To see if there are tables in a worksheet, click the Name Manager  button on the Formulas tab on the ribbon.

For more information, see the Microsoft Overview of Excel tables article.

Trigger (Power Automate)

A user activity (typically manual, but may be automated) that begins a Microsoft Power Automate flow.

Viewer

A Microsoft 365 user role that has been assigned Read privileges by the Microsoft 365 account administrator. This role includes the following Microsoft 365 component designations: Microsoft Excel Unlicensed users, Microsoft Power BI Viewers, and Microsoft SharePoint Readers.

Web map

A digital map file that contains a map's layers, styles, and related data. You can search for a web map on ArcGIS and add it to a map. When a web map is added to a map, the individual layers in the web map become layers in the map.

Worksheet (Excel)

The primary document used in Excel to store and work with data. A worksheet is sometimes called a spreadsheet. It consists of cells organized into columns and rows. A worksheet is stored in a workbook.