Using the Data Table

Summarize data for a layer, or for a selection of features, using the Data Table.

The data table shows all attribute data for layer features, supporting data exploration and tabular data calculations. This article includes an overview of the data table features, along with steps on how to summarize and export table data.

Data Table Overview

The data table for the active layer appears in a pane below the map view. The table can be shown or hidden using the DATA TABLE tab. It can also be resized by clicking and dragging the upper border of the table.

A view of the Data Table pane

The data table shows data for the first 100 features in a layer, ordered according to the alphanumeric order of values in the first column. The data table will show only selected features if you apply filters to the layer, or make a manual selection of features on the map.

Column Summary Statistics. Summary statistics are displayed above the column names. You can select any of the options to change the statistic type, which will be applied to all numeric columns. Options include:

  • Sum. The sum of all values in the column.

  • Mean. The mean of all values in the column. Note that this is calculated as simple, rather than weighted, mean.

  • Min. The lowest value in the column.

  • Max. The highest value in the column.

You can bring up a display of the full set of summary statistics for a column by hovering over the statistics value or column name.

Hovering over column summary values displays a full set of column summary statistics

Export as CSV. Clicking Export as CSV exports the data table to a CSV file for use in Excel or other spreadsheet or database applications. If you have applied filters or made a manual selection on the map, the export will include the selected features only. Otherwise, the export will include all features in the dataset. While you can view a maximum of 100 rows within the data table, exporting the data allows you to view and work with all rows as selected for your layer.

Note that you can also copy and paste values from the data table directly into a spreadsheet. This can be useful for pulling together manual selections of data.

The Download Layer control also supports CSV exports. See Exporting Layer Data for details.

Filter Columns. You can apply a filter to narrow down the data table display to a specific column or columns. The data table will display only those columns containing the text entered in the search box. This function is particularly useful for viewing data and summary statistics for a selection of features.

Row Count. The row count includes two numbers. The first indicates the number of selected features selected; the second indicates the total number of features in the layer.

Column Count. The column count indicates the number of columns in the layer.

Column Controls. Hovering over a column name brings up a display of its full name and key name. Key names are used to identify columns in CSV exports. Summary statistics are also shown, if available for the column.

Columns can be resized by clicking and dragging the borders between column headers. Double-clicking on borders automatically resizes columns to accommodate full column names, or their longest (widest) values.

Data Table controls

How to Summarize Data

To summarize data:

1. Display the data table by activating a layer and clicking on the DATA TABLE tab.

2. Create a feature selection, if desired, using filters and/or manually selecting features on the map.

3. Select a summary statistics option using the Column Summary control.

4. See the summary values in the column headers, above the column names.

5. Hover over a summary value or column name to see the full set of summary statistics. These include the column sum, mean, and range from minimum to maximum values.

Note that summary statistics are not included in data table exports. However, they can be readily calculated using common spreadsheet applications.

To summarize data according to more complex criteria, you can export your layer data as a CSV for use in Excel or other spreadsheet applications. Pivot table functionality is particularly useful for stratifying and summarizing data according to multiple criteria.

How to Export Table Data

To export table data:

1. Display the data table by activating a layer and clicking on the DATA TABLE tab.

2. Create a feature selection, if desired, using filters and/or manually selecting features on the map.

3. Click Export as CSV. Your download will be prepared. UrbanFootprint will prepare the data download, and a pop-up window will appear at the bottom of your screen when it is ready.

3. Click DOWNLOAD in the pop-up notification to download your data. The CSV file will be downloaded to your computer.

4. Summarize the CSV data as needed. You can work with CSV data in Excel, Google Sheets, or other spreadsheet applications. Pivot tables are useful for summarizing data, as shown in the example below for a subarea selection of the Base Canvas.

View of a Google Sheets pivot table summarizing CSV data for the Base Canvas

Please refer to Excel help, Google help, or other resources for guidance on using pivot tables.

Learn More