maya
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
st_fishnet(text, text, double precision)
Parameters
Name
Type
Mode
geom_table
text
IN
geom_col
text
IN
cellsize
double precision
IN
Definition
DECLARE sql TEXT; BEGIN sql := 'WITH extent as ( SELECT ST_Extent(' || geom_col ||') as bbox FROM ' || geom_table ||'), bnds as ( SELECT ST_XMin(bbox) as xmin, ST_YMin(bbox) as ymin, ST_XMax(bbox) as xmax, ST_YMax(bbox) as ymax FROM extent), raster as ( SELECT ST_MakeEmptyRaster( ceil((xmax-xmin)/' || cellsize ||')::integer, ceil((ymax-ymin)/' || cellsize ||')::integer, xmin, ymax, '|| cellsize ||') AS rast FROM bnds) SELECT (ST_PixelAsPolygons(rast)).geom FROM raster;'; RETURN QUERY EXECUTE sql; END