add property data to tile

[pcace]

add property data to tile

[pcace]

Hi,

i have found a way by using the db-function functionality by converting it to a text:

CREATE OR REPLACE FUNCTION function_zxy_query(z integer, x integer, y integer, query_params json)
RETURNS bytea AS $$
DECLARE
  mvt bytea;
BEGIN
  SELECT INTO mvt ST_AsMVT(tile, 'function_zxy_query', 4096, 'geom', 'id') FROM (
    SELECT
      ST_AsMVTGeom(
          ST_Transform(ST_CurveToLine("ground_geometry"), 3857),
          ST_TileEnvelope(z, x, y),
          4096, 64, true) AS geom,
    "id",
    attributes::TEXT,
         "cj_metadata_id",
  geometry::TEXT,
    "object_id",
    "type"
    FROM 
      cjdb.city_object
    WHERE 
      "ground_geometry" && ST_Transform(ST_TileEnvelope(z, x, y, margin => 0.015625), 3857)
  ) as tile
  WHERE geom IS NOT NULL;

  RETURN mvt;
END
$$ LANGUAGE plpgsql IMMUTABLE STRICT PARALLEL SAFE;

[pcace]

Converting a tile to a json using ogre for example shows me, that martin does actually include property data in the file.
BUT only this data wich is of integer or varchar.
is it possible to add jsonb data to the file at all?

Thanks a lot!