Skip to content

Fields and the data table ​

Fields ​

Open Properties → Manage fields, or the field button in the data table's heading. Add text, number, yes/no or date fields, with a default if you like. A new field fills existing records; a later change of default applies to newly drawn shapes only. Renaming a field updates the labels and styles that use it. Deleting a field asks first, and can be undone.

The data table ​

Open it with Data table in the Layers card (on a phone, its own tab). Drag its top edge to give it more or less of the map.

  • Find a shape: click a row to go to its shape on the map.
  • Sort a drawing layer by clicking a column heading: ascending, descending, then original order.
  • Search covers every record. The filter icon adds typed conditions; all of them must match, and the matching rows show on the map. While a search or filter is on, Zoom to results fits the map to them and Export these rows exports only them.
  • Edit a cell by double-clicking it, or focusing it and pressing Enter (on a touch screen, tap it and choose Edit). Enter saves, Esc cancels. Values are checked against their field type, and each edit is one Undo step.
  • Read a long value by pointing at it, or open the cell: the side panel shows it whole.

Columns are as wide as their values, numbers line up on the right, and the row numbers and first field stay in view as the table scrolls sideways.

Area and length ​

After its own fields, the table of a drawn or imported layer shows Area and Perimeter for its areas and Length for its lines. They are worked out from each shape and are always current: drag a corner, merge or split, and the row follows when the edit ends. They are not fields: you cannot type in them, and they add nothing to the map you save.

  • The unit is in the heading (Area (m²)) and follows Units. With the automatic feet-and-miles choice, areas are in acres.
  • Sort, filter and total them like any number field: click the heading to sort, add a condition with the filter icon, and open Σ for the sum. They cannot be used to colour the layer.
  • Hide them for a layer with the ruler button in the table's heading. The choice is kept on this browser.
  • Export them with Include area and length in the export dialog (see Import and export).

A linked Mapplex layer has no such columns.

Statistics ​

A number column's heading has Σ: how many records have a value and how many have none, min, max, mean, median and sum, for the selected rows, the filtered rows or the whole layer. The histogram spans the whole layer.

  • Point at a bar, Min, Max or Missing to light those records on the map. A bar narrows the table to its range; Min and Max go to their record.
  • Copy puts the figures on the clipboard, ready to paste into a spreadsheet.
  • Colour by this field opens the layer's styling on graduated colours with this field chosen; nothing changes until you apply it.

For a layer linked from Mapplex, Σ reads the whole layer you can see, including records outside the current view.

Photos and files ​

A photo or file kept in a field shows as its kind and size, such as Photo · JPEG · 132 KB. Open shows the photo, or the file with Download. Photos kept in the workspace's private storage are read with your own sign-in, only when you open or export them. A CSV export names each one ([photo], [3 photos]) instead of holding the file.

Linked Mapplex layers ​

Linked layers are read-only: their values cannot be edited here. Their tables search and page the whole source, and any field the table shows can be searched.

New linked layers start in Source style: the colours, categories and completion rules of the Mapplex project. Choose Web style to style them yourself; switching keeps both and can be undone. In Web style, Symbology → By data → Whole-layer statistics reads a field across every record you can access. It never changes the source project.

Spatial intelligence. Clear next steps.