View records

In this topic

Display the attribute table
Select features
Specify what records are shown
Change column display
Sort records
Statistics

You can get detailed information about features on a map by viewing a feature layer's interactive attribute table. Seeing tabular information in an attribute table can help you analyze your data and gain a better understanding of the features on the map.

By selecting records in the attribute table, you can select the corresponding features on the map and have a closer look by zooming to a feature. You can resize the table, sort records, and specify what records are shown.

Note:

Attribute information is only available for layers created from IBM Cognos data and for feature service layers.

By default, the attribute table for a layer created from IBM Cognos data includes the columns that were configured when the data was added to the map. A feature service layer's attribute table includes the columns that were configured when the layer item was created in ArcGIS.

When configuring a layer in Esri Maps Designer, the report author has the option of hiding any of these configured columns in the layer's attribute table. When report consumers view the attribute table, the columns that were displayed when the report author last saved the map are displayed. Report consumers can choose to view any of the hidden columns when using the attribute table.

Display the attribute table

Display the attribute table for any IBM Cognos layer or a feature service layer to see detailed attribute information about the features in the layer. You can also resize the table to make it easier to view and analyze your data, and hide it when you are finished with it.

In the Contents pane, select the Configure layer button beside the business layer or feature service layer for which you want to view the attribute table.
Select View records.

Attribute information for the features in the layer appears in an attribute table under the map.
To resize the table vertically, drag the splitter bar centered above the table up or down to the desired height.
To hide the attribute table, select the Close button.

Select features

You can select features on the map by selecting corresponding records in the attribute table.

Display the layer's attribute table.
Select the record for the feature you want to highlight on the map.
Continue to select records one at a time to select additional features on the map.
To select all records in the table and on the map, choose Select all records from the Options menu.
To clear your selection in the table and on the map, choose Clear selection from the Options menu.

Tip:

After selecting one or more records, you can use the attribute table to center the map on the selected features. From the Options menu, choose Center on selection.

Specify what records are shown

Specify what records are displayed in the attribute table. You can show records for all features, selected features, or unselected features.

Display the layer's attribute table.
Select records in the table as needed.
Choose any of the following from the Options menu to specify what records are shown in the table:
- Show selected records—Only the records you selected in the table are shown.
- Show unselected records—Only the records that you haven't selected in the table are shown.
- Show all records—All records in the layer are shown.

Change column display

You can specify what columns are displayed in the attribute table by showing or hiding columns or changing their width.

Display the layer's attribute table.
To change the columns displayed in the table, do the following:
1. Select the + button to view a list of columns.
2. Check the check boxes beside the columns you want to display.
3. Uncheck the check boxes beside the columns you want to hide.
4. When you're finished, click anywhere outside of the list.
  
  The table dynamically updates to show only the columns you chose to display.
To make a column wider or narrower, drag the edge of the column header to the desired width.

Sort records

You can sort records in ascending or descending alphabetical order according to a particular column in the attribute table. For example, you could sort store records by state alphabetically from top to bottom by choosing the Sort ascending option on the States column.

Display the layer's attribute table.
Select the header of the column on which you want to sort the table records.
Choose Sort ascending to sort records alphabetically from top to bottom. Choose Sort descending to sort records alphabetically from bottom to top.

Records are sorted according to the column and sorting option you chose.
To return the records to their original order, choose Default sort order from the Options menu in the table.

Statistics

You can calculate statistics for a numeric field in an ArcGIS hosted feature layer. For example, you could view the total population or average population by choosing the Statistics option on the Population column.

In the Contents pane, select the Configure layer button beside the hosted feature layer for which you want to calculate statistics.
Select View records to display the layer's attribute table.
Select the header of the column for which you want to calculate statistics.
The column must include numeric values.
Choose Statistics to calculate values.
A pop-up appears, displaying the Number of values, Sum of values, Minimum, Maximum, Average, and Standard deviation.
Close the pop-up to return to the attribute table.

Feedback on this topic?