OSMM MapBox Studio SQL
(SELECT ST_Collect(geom) as geom, textstring, font, height, orientdeg, anchor, fcode
FROM osmm_mapbox.text
where geom && !bbox!
and z(!scale_denominator!) >= 16
GROUP BY textstring, font, height, orientdeg, anchor, fcode) as data
(SELECT ST_Collect(geom) as geom
FROM osmm_mapbox.edgelines
where geom && !bbox!
and z(!scale_denominator!) >= 16) as data
(SELECT ST_Collect(geom) as geom,fcode
FROM osmm_mapbox.otherlines
where geom && !bbox!
and z(!scale_denominator!) >= 16
GROUP BY fcode) as data
(SELECT ST_Collect(geom) as geom
FROM osmm_mapbox.buildinglines
where geom && !bbox!
and z(!scale_denominator!) >= 16) as data
(SELECT ST_Collect(geom) as geom
FROM osmm_mapbox.defaultlines
where geom && !bbox!
and z(!scale_denominator!) >= 16) as data
(SELECT ST_Collect(geom) as geom, fcode
FROM osmm_mapbox.landformpolygon
where geom && !bbox!
and z(!scale_denominator!) >= 16
GROUP BY fcode) as data
(SELECT ST_Collect(geom) as geom
FROM osmm_mapbox.buildingpolygon
where geom && !bbox!
and z(!scale_denominator!) >= 16) as data
(SELECT ST_Collect(geom) as geom
FROM osmm_mapbox.manmadepolygon
where geom && !bbox!
and z(!scale_denominator!) >= 16) as data
(SELECT ST_Collect(geom) as geom
FROM osmm_mapbox.manmadepolygon
where geom && !bbox!
and z(!scale_denominator!) >= 16) as data
(SELECT ST_Collect(geom) as geom
FROM osmm_mapbox.naturalpolygon
where geom && !bbox!
and z(!scale_denominator!) >= 16) as data
(SELECT ST_Collect(geom) as geom
FROM osmm_mapbox.railpolygon
where geom && !bbox!
and z(!scale_denominator!) >= 16) as data
Updated less than a minute ago