← All help

The attribute table

View, search, edit and structure your data — rows, columns, field types, pick lists and defaults.

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

  • 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). See Columns & fields.

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.

Columns & fields

Open Columns to manage fields: show/hide them, drag to reorder, and expand one (the tune icon) to rename it, change its type, set its format, restrict what can be entered, or add a default value. Add column creates a new field. You can also rename or delete a field by right-clicking its header.

Field types

A field can be Text, Number, Date, Time, Date & time, or Yes/No (boolean). The type drives how values are formatted and edited — for example numbers get decimals, thousands separators, prefixes and suffixes; dates and times get format options; booleans display as a checkbox or Yes/No.

Pick lists

Give a Text or Number field a pick list — one allowed value per line — and everywhere that field is edited (the table, the feature popup, the selection card, the Edit attributes form) offers a dropdown of those values instead of a free-text box. It’s the simplest way to keep categories clean and typo-free.

Existing values that aren’t on the list are preserved: open the dropdown on one and it appears as an extra choice, so adding a pick list to a populated field never rewrites your data.

Number limits & steppers

A Number field can set a Min, Max and Step. The step drives the up/down spinner on the input, and any value entered outside the range is clamped to the nearest limit when it’s saved.

Tick Show as hyperlink on a Text field to render its values as clickable links — in the table, the feature popup and the selection card. Values starting with http:// or https:// are linked as-is, and bare www. addresses get https:// added. Anything that isn’t a web address stays plain text.

Default values

Each field can carry a default value applied to new features. Dates and times can default to Now (stamped when the feature is created), booleans to Yes/No, and text/number fields to a fixed value (a field with a pick list picks its default from that list).

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.

Next steps