Page MenuHomePhabricator
Paste P17331

(An Untitled Masterwork)
ActivePublic

Authored by Jgiannelos on Sep 27 2021, 5:03 PM.
Tags
None
Referenced Files
F34659450: raw-paste-data.txt
Sep 27 2021, 5:03 PM
Subscribers
None
SELECT ((SELECT ST_AsMVT(q,'landuse',4096,'geom','osm_id') AS data FROM (SELECT class, osm_id, way_area, z_order, ST_AsMVTGeom(geometry, ST_MakeEnvelope(-9.0794959665625e+06,3.1308606781250015e+06,-8.76640989875e+06,3.4439467459375e+06,3857)) AS geom FROM layer_landuse(ST_MakeEnvelope(-9.0794959665625e+06,3.1308606781250015e+06,-8.76640989875e+06,3.4439467459375e+06,3857), 7)) AS q)||(SELECT ST_AsMVT(q,'water',4096,'geom','osm_id') AS data FROM (SELECT osm_id, ST_AsMVTGeom(geometry, ST_MakeEnvelope(-9.0794959665625e+06,3.1308606781250015e+06,-8.76640989875e+06,3.4439467459375e+06,3857)) AS geom FROM layer_water(ST_MakeEnvelope(-9.0794959665625e+06,3.1308606781250015e+06,-8.76640989875e+06,3.4439467459375e+06,3857), 7)) AS q)||(SELECT ST_AsMVT(q,'road',4096,'geom','osm_id') AS data FROM (SELECT osm_id, ST_AsMVTGeom(geometry, ST_MakeEnvelope(-9.0794959665625e+06,3.1308606781250015e+06,-8.76640989875e+06,3.4439467459375e+06,3857)) AS geom, class, z_order, 'is' FROM layer_transportation(ST_MakeEnvelope(-9.0794959665625e+06,3.1308606781250015e+06,-8.76640989875e+06,3.4439467459375e+06,3857), 7)) AS q)||(SELECT ST_AsMVT(q,'admin',4096,'geom',NULL) AS data FROM (SELECT osm_id, ST_AsMVTGeom(geometry, ST_MakeEnvelope(-9.0794959665625e+06,3.1308606781250015e+06,-8.76640989875e+06,3.4439467459375e+06,3857)) AS geom, admin_level, maritime, disputed FROM layer_admin(ST_MakeEnvelope(-9.0794959665625e+06,3.1308606781250015e+06,-8.76640989875e+06,3.4439467459375e+06,3857), 7)) AS q)||(SELECT ST_AsMVT(q,'country_label',4096,'geom','osm_id') AS data FROM (SELECT osm_id, ST_AsMVTGeom(geometry, ST_MakeEnvelope(-9.0794959665625e+06,3.1308606781250015e+06,-8.76640989875e+06,3.4439467459375e+06,3857)) AS geom, name, name_, scalerank, code FROM layer_country_label(ST_MakeEnvelope(-9.0794959665625e+06,3.1308606781250015e+06,-8.76640989875e+06,3.4439467459375e+06,3857), 7)) AS q)||(SELECT ST_AsMVT(q,'place_label',4096,'geom','osm_id') AS data FROM (SELECT osm_id, ST_AsMVTGeom(geometry, ST_MakeEnvelope(-9.0794959665625e+06,3.1308606781250015e+06,-8.76640989875e+06,3.4439467459375e+06,3857)) AS geom, ldir, localrank, name, osm_id, type FROM layer_place_label(ST_MakeEnvelope(-9.0794959665625e+06,3.1308606781250015e+06,-8.76640989875e+06,3.4439467459375e+06,3857), 7, 1222.9924523925802)) AS q)) AS data