Comments (2)
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;
from martin.
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!
from martin.
Related Issues (20)
- Martin panics at start due to Postgres pool issue HOT 9
- RUSTSEC-2024-0320: yaml-rust is unmaintained. HOT 1
- automatic discovery of tables and functions have error HOT 3
- Issues starting the Docker version
- Font endpoint gives 404 but the font seems loaded HOT 2
- HowTo Provide Multiple PG Connections in Config HOT 5
- Tiles are not displayed HOT 1
- use function with query parameters. How?!
- if it is possible to load postgre function source automatically HOT 2
- uploading tiles slows down extremely HOT 1
- dynamic TileJSONs HOT 3
- very slow queries through martin HOT 11
- Impossible to run when I use PGPool
- Unable to get tile, connection closed HOT 2
- Error when deploy by AWS Lamda: Unable to load config file .yaml: No such file or directory (os error 2) HOT 2
- Unable to generate spritesheet
- [Feat]Can you support OGC's WFS, or do you have any recommended options for Martin's use?
- Loading sprites is very slow with big SVG HOT 3
- If sprites are in k8s configMap, image names get garbled
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from martin.