Show tables

To see information about features in a layer, you can display an interactive table at the bottom of the map. Seeing a tabular view of the data can be a quick way to analyze information and start making decisions. You can sort, resize, reorder, and hide the data, as well as select specific attributes to see on the map. For example, you could show a table for a crimes layer and see the different types of crime that your district had responded to over the last two years. You might rearrange the columns so types and date are next to each other, hide some of the columns of data not relevant to your task, and zoom the map to a specific crime you want to investigate further.

You can view and sort attribute data in a feature layer's attribute table. You can also get more information about the layer by viewing any available related data tables, as well as any related photos or other file attachments.

Show a table

1. Open the map with the feature data you want to see in a table.
2. Click Details and click Contents.
3. Browse to the feature layer and click Show Table . The table appears at the bottom of your map.

   Tip:

   To resize the table vertically, drag the splitter bar centered above the table title up or down.

4. Click Hide Table to close the table view in the map.

View attributes and related records

Once the table is open in the map, you can view the layer's attributes. If the owner of the feature layer has created a relationship between the feature layer and another table, you will also see attributes from the related tables. Attributes from related tables are represented as columns with italicized headers on the right side of the table.

You can manipulate the table in the following ways to help you find the data you want:

• To make it easier to find specific attribute values, sort the attributes by clicking the column header and selecting Sort Ascending or Sort Descending.

  For example, if you want to find all records (rows) for motor vehicle theft in a table of crimes in your district, click the column header for crime_type and select Sort Descending. The records will be sorted in reverse alphabetical order based on crime_type values, and you can scroll to all motor vehicle theft records.

  Note:

  Web services from some older versions of ArcGIS Server do not support sorting.

• You can hide columns to make room in the display for the attributes you need. To hide or show attribute fields, click Options and click Show/Hide Columns. Check boxes to show attribute columns. Uncheck boxes to hide them.

  For example, you could hide the ID, latitude, and longitude columns in the crimes table so you only see the crime_type, date_time_reported, officers, arrest_made, and case_number data.

• To rearrange the columns, you need to edit the layer's pop-ups.
  1. Click the More Options button under the layer in the Contents pane.
  2. Click Configure Pop-up and click Configure Attributes.
  3. Select the field names of the columns you want to rearrange and use the Move up and Move down arrows to change the order of the columns. Columns listed from top to bottom correspond to their display from left to right in the table.
  4. Click OK on the Configure Attributes dialog box and the Configure Pop-up pane to apply your changes.
• To view related records, click Show in the cell of the column corresponding to the record for which you want to view related records.

  For example, the crime layer is related to the cases table. To see the details in the cases table that are related to a particular crime, click Show in the appropriate cell of the case_number column. From there, you can explore other records in the cases table. If the related table has related records of its own, you can examine those as well—for example, if the cases table has a related table of evidence_collected, click Show to see related evidence records.

• When viewing a related table, click the Close button (X) at any time to return to the previous table.
• You can hide or show columns in related tables too. Click Options on the related table and click Show/Hide Columns. Check boxes to show the columns. Uncheck boxes to hide them.

View related photos and files

Feature layers can include related photos or other files as attachments, which can be viewed from the attribute table. These attachments are stored in the Photos and Files column of the attribute table.

Do any of the following to view related photos and files:

• If the layer has related photos or files, view them by clicking Show in the appropriate cell of the Photos and Files column on the right of the table.
• To hide or show related photos and files columns, click Options and click Show/Hide Columns. Check boxes to show columns. Uncheck boxes to hide them.

Select and zoom to features

You can use a feature layer's attribute table to select and zoom to features on the map. To accomplish this, do any of the following:

• To zoom to a feature on the map, click a record (row) in the table, click Options, and click Center on Selection.
• To select multiple features on the map, hold down the Shift key and select multiple records or a range of records. Hold down the Ctrl key to select two or more nonadjacent records.
• To clear a selection, click Options and click Clear Selection. This option is useful to clear all selected records.
• To create a query expression that filters what feature data appears in the map and table, click Options and click Filter.

Considerations for showing a table

• You can see a table for these types of layers: feature and map services from an ArcGIS Server 10 SP1 or later site, hosted feature layers, hosted tile layers with associated attribute data, shapefiles, GPX files, and CSV (files and web).
• Tables display the same attribute fields and formatting configured in pop-ups. You can change a field name by editing the field alias in the Configure Attributes window of the Pop-up Properties. If you make updates to the pop-up configuration while the table is open, you'll need to hide and show the table to see the updates.
• If you select a single record to zoom to, the map zooms to the extent of the feature if the feature is a line or polygon. If the feature is a point, the map pans to the feature and, if necessary, zooms to a scale where the feature is visible.
• If you select multiple records to zoom to, the map zooms to the extent of all the features. You may not see all the features if the extent of all the selected features is outside the visible scale range of the layer.
• If you've selected a record in the table and open a pop-up in the map, you'll clear the selection in the table.
• If the layer is hidden in the map, you cannot zoom to a selection.