← All help

The attribute table

View, search and edit your data as rows and columns — sort, select, add rows and fields, and browse tile layers.

The attribute table is the spreadsheet behind a layer. Open it from the bottom panel, or from a layer’s menu, to view and edit every feature’s properties. It’s backed by DuckDB, so it stays fast on large layers.

Browse & search

View, search and edit your data in the table.
  • Search features… does a full-text search across all visible columns. With a search active, Select picks every matching row.
  • The footer shows the feature count (and match count when filtered) and lets you set the page size (50 / 100 / 250 / 500) and move between pages.
  • Click a column header to sort ascending; click again for descending.

Edit values

Click a cell, type, and press Enter to save (Escape cancels). Boolean fields toggle on click. App-managed columns (like the internal id) are read-only.

A field with a pick list edits as a dropdown of its allowed values, and a Number field with a min/max only accepts values in that range (anything outside is pulled back to the nearest limit). Read-only and tracked fields can’t be typed into. See Fields & forms.

Rows

  • Add row — pick a geometry type (Point / Line / Polygon) and draw the new feature on the map; it’s added as a row you can then fill in.
  • Select rows with the checkboxes (or the header checkbox to select all matches). With a selection you can show Selected only, Zoom to / Pan to the features, Move / copy them to another layer, or Delete them.
  • A row’s ⋯ menu also offers Edit attributes (a form for every field on that record), Edit geometry (the map pans to the feature and its edit handles appear), Zoom/Pan to, and Delete record. See Editing features for what you can do once you’re editing.

Fields

  • Fields chooses which fields the table shows and in what order: tick them on or off and drag to reorder. This only affects the table; the form and popups choose their own.
  • Add field creates a new field with a name and type.
  • A column header’s menu has Field settings (label, type, format, pick list, limits, default), Rename and Delete field. Field settings… in the Fields window opens the same place.

Column headers show each field’s label when it has one. Records missing a required value are tinted so you can find and fill them.

Field types, pick lists, number limits, hyperlinks, defaults, edit tracking and form rules are all covered in Fields & forms.

Select by attributes

Select by attrs opens an expression builder to select features by a condition (e.g. status = 'open' AND value > 100) — the same builder used by the Filter tab.

Calculate & query

  • Field calc opens the field calculator to derive or update a column across all (or selected) features.
  • For anything more, the SQL console runs full SQL — including spatial functions — over your tables.

Tile layers

Live tile layers, such as PMTiles archives and Overture open data, don’t hold every feature on your device. Their table lists the features in view instead, a page at a time, and updates as you pan. Click a row to zoom to that feature. An Overture layer also has Save as layer…, which copies the data in view into an editable layer with every attribute.

Next steps