Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION ST_CreateFishnet(
- nrow integer, ncol integer,
- xsize float8, ysize float8,
- x0 float8 DEFAULT 0, y0 float8 DEFAULT 0,
- OUT "row" integer, OUT col integer,
- OUT geom geometry)
- RETURNS SETOF record AS
- $$
- SELECT i + 1 AS row, j + 1 AS col, ST_Translate(cell, j * $3 + $5, i * $4 + $6) AS geom
- FROM generate_series(0, $1 - 1) AS i,
- generate_series(0, $2 - 1) AS j,
- (
- SELECT ('POLYGON((0 0, 0 '||$4||', '||$3||' '||$4||', '||$3||' 0,0 0))')::geometry AS cell
- ) AS foo;
- $$ LANGUAGE sql IMMUTABLE STRICT;
- SELECT ST_Collect(cells.geom)
- FROM ST_CreateFishnet(4, 6, 10, 10) AS cells;
Add Comment
Please, Sign In to add comment