| CREATE OR REPLACE FUNCTION ST_LineChunk(geom geometry, max_length float8) RETURNS SETOF geometry AS $$ | |
| WITH | |
| points AS ( | |
| SELECT generate_series(0, CEIL(ST_Length(geom) / max_length)::int) | |
| / CEIL(ST_Length(geom) / max_length) "end" | |
| ), | |
| line_points AS (SELECT LAG("end", 1) OVER (ORDER BY "end") "start", "end" FROM points) | |
| SELECT ST_LineSubstring(geom, "start", "end") | |
| FROM line_points | |
| WHERE "start" IS NOT NULL AND "start" <> 1 |
I would like to be able to make myself one day a vector landcover tileset that looks as good as the ones of the large consumer maps. I tried doing this a bit but so far I have not found a good solution.
The landcover should give you an idea how the nature looks like in a place, whatever that means...
In this gist I would like to write down some notes around the challenges of making a vector landcover tileset.
Related to onthegomap/planetiler#550
| console.log(parse(`(define (square x) | |
| "Function calculate square of a number" | |
| (* x x))`)[0].toString()); | |
| // ==> (define (square x) "funkcja square wywołanie (square 10) zwraca 100" (* x x)) |