SELECT AsGeoJson(
ST_Transform(
ST_HexagonalGrid(
ST_Transform(
geom, /* Boundary Polygon */
3857 /* Pseudo-Mercator projection */
),
200 /* Hexagon edge size */
),
4326 /* WGS 84 projection */
)
)
FROM spatial.geometry
WHERE source = 'osm'
AND id = 'relation:2567806'
SELECT AsGeoJson(
ST_Union(
ST_Buffer(
geom, /* Point | LineString | Polygon */
0.0001, /* Buffer Distance */
30 /* Quadrant Segments */
)
)
)
FROM spatial.geometry
SELECT AsGeoJson(
ST_SimplifyPreserveTopology(
geom, /* Boundary Polygon */
0.0045 /* Tolerance */
)
)
FROM spatial.geometry
WHERE source = 'wof'
AND id = '102079339'
That’s all for today folks, please 🌟 the repo on Github to show you’re interested in seeing more.
We’re able to help your organization import your own data into the Spatial service, send us an email!