Feature ID

[astridx]

I am using the following SQL:

SELECT
    ST_AsMVTGeom(geom, {{unbuffered_bbox}}, {{extent}}, {{buffer}}) AS way,
    area_id::integer AS id,
    kind
FROM sites
WHERE geom && {{bbox}}

Now I would like the variable $id to be populated. However, in my current setup, id is being generated without the $ prefix.

Do you have any suggestions on how I could ensure that $id is assigned or included correctly?

[pnorman]

The attributes shown in the viewer that begin with $ are not real tags encoded with Value messages. Instead, they're property of the Feature itself. feature_id_name needs to be set in the ST_AsMVT which will remove the named column and make it an id column if it is of a valid type (unsigned integer).

This currently can't be done. The right place to add it will be by expanding the YAML file to specify another property of the definition and adjust render_sql

[pnorman]

Note that MVT ids are a lot less useful than people think as I haven't seen anything you can't do with normal properties, and they won't work with area_id because those can be negative.