Guest User

Untitled

a guest
Feb 23rd, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.63 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION ST_CreateFishnet(
  2. nrow integer, ncol integer,
  3. xsize float8, ysize float8,
  4. x0 float8 DEFAULT 0, y0 float8 DEFAULT 0,
  5. OUT "row" integer, OUT col integer,
  6. OUT geom geometry)
  7. RETURNS SETOF record AS
  8. $$
  9. SELECT i + 1 AS row, j + 1 AS col, ST_Translate(cell, j * $3 + $5, i * $4 + $6) AS geom
  10. FROM generate_series(0, $1 - 1) AS i,
  11. generate_series(0, $2 - 1) AS j,
  12. (
  13. SELECT ('POLYGON((0 0, 0 '||$4||', '||$3||' '||$4||', '||$3||' 0,0 0))')::geometry AS cell
  14. ) AS foo;
  15. $$ LANGUAGE sql IMMUTABLE STRICT;
  16.  
  17.  
  18. SELECT ST_Collect(cells.geom)
  19. FROM ST_CreateFishnet(4, 6, 10, 10) AS cells;
Add Comment
Please, Sign In to add comment