The dataset table provides access to the spreadsheet portion of a dataset: the features (rows) and their attributes (columns). There are several functions you can use in the dataset table to explore and filter the data.
To get to the dataset table, follow these steps:
- Click a dataset from the search results.
- Click the Table tab.
Sort the dataset table
Each column or attribute can be sorted by clicking the column head. Text is sorted alphabetically, and numbers are sorted by value. Click once, and the column is sorted from A–Z or 1–10. Click again, and it's sorted from Z–A or 10–1.
Highlight a feature in the preview map
Each row in the dataset table represents a feature in the map. Hover over any row, and that feature is highlighted in the preview map at the top of the page.
Using the dataset table, you can filter data to show only the desired features. You can then download the filtered dataset. You can filter by location on the map or by attribute.
Filter by map extent
To filter by a location on the map, check the Filter by Map Extent check box. Zoom and pan to the desired location within the preview map. As you adjust the map, the dataset table changes to reflect the features that are within the desired area of the map.
Filter by attribute
- From the dataset profile, click the Table tab.
- Click the column head for the attribute you want to use to filter the dataset.
- Filter the data.
Depending on the column field type and size of the dataset, you have the option to filter using a sliding histogram, a slider, inputs for from and to, check boxes for unique values, or date pickers.
As you filter, the preview map reflects the changes.
- Multiple filters can be added by clicking another column header and typing your next query.
- To remove a filter, click the trash icon to the right of the text box. To clear all filters, click the Remove all filters button.
Download filtered datasets
Once the dataset is filtered, you can download a version of the data with only the attributes from the filter. You do this by clicking the Download Dataset tab in the blue bar above the table and choosing one of the options under Download filtered dataset.