st_asraster
How PostGIS Raster runs Rasterize: st_asraster.
| Engine | PostGIS Raster |
|---|---|
| Tool name | st_asraster |
| Interface | sql |
| Implements | Rasterize |
| Documentation | Not stated |
| Effects | modifies input: no, network: no |
| Notes | Not stated |
| Status | active |
Parameters
| Name | Type | Required | Default | Choices | Note |
|---|---|---|---|---|---|
geom | geometry | no | Not stated | Not stated | Not stated |
ref | raster | no | Not stated | Not stated | Not stated |
pixeltype | text | text[] | no | ARRAY['8BUI'::text] | Not stated | Not stated |
value | double precision | double precision[] | no | Not stated | Not stated | Not stated |
nodataval | double precision | double precision[] | no | Not stated | Not stated | Not stated |
touched | boolean | no | false | Not stated | Not stated |
scalex | double precision | no | Not stated | Not stated | Not stated |
scaley | double precision | no | Not stated | Not stated | Not stated |
gridx | double precision | no | NULL::double precision | Not stated | Not stated |
gridy | double precision | no | NULL::double precision | Not stated | Not stated |
skewx | double precision | no | 0 | Not stated | Not stated |
skewy | double precision | no | 0 | Not stated | Not stated |
upperleftx | double precision | no | NULL::double precision | Not stated | Not stated |
upperlefty | double precision | no | NULL::double precision | Not stated | Not stated |
width | integer | no | Not stated | Not stated | Not stated |
height | integer | no | Not stated | Not stated | Not stated |
SQL overloads
-
st_asraster(geom geometry, ref raster, pixeltype text, value double precision DEFAULT 1, nodataval double precision DEFAULT 0, touched boolean DEFAULT false) → raster -
st_asraster(geom geometry, ref raster, pixeltype text[] DEFAULT ARRAY['8BUI'::text], value double precision[] DEFAULT ARRAY[(1)::double precision], nodataval double precision[] DEFAULT ARRAY[(0)::double precision], touched boolean DEFAULT false) → raster -
st_asraster(geom geometry, scalex double precision, scaley double precision, gridx double precision, gridy double precision, pixeltype text, value double precision DEFAULT 1, nodataval double precision DEFAULT 0, skewx double precision DEFAULT 0, skewy double precision DEFAULT 0, touched boolean DEFAULT false) → raster -
st_asraster(geom geometry, scalex double precision, scaley double precision, gridx double precision DEFAULT NULL::double precision, gridy double precision DEFAULT NULL::double precision, pixeltype text[] DEFAULT ARRAY['8BUI'::text], value double precision[] DEFAULT ARRAY[(1)::double precision], nodataval double precision[] DEFAULT ARRAY[(0)::double precision], skewx double precision DEFAULT 0, skewy double precision DEFAULT 0, touched boolean DEFAULT false) → raster -
st_asraster(geom geometry, scalex double precision, scaley double precision, pixeltype text, value double precision DEFAULT 1, nodataval double precision DEFAULT 0, upperleftx double precision DEFAULT NULL::double precision, upperlefty double precision DEFAULT NULL::double precision, skewx double precision DEFAULT 0, skewy double precision DEFAULT 0, touched boolean DEFAULT false) → raster -
st_asraster(geom geometry, scalex double precision, scaley double precision, pixeltype text[], value double precision[] DEFAULT ARRAY[(1)::double precision], nodataval double precision[] DEFAULT ARRAY[(0)::double precision], upperleftx double precision DEFAULT NULL::double precision, upperlefty double precision DEFAULT NULL::double precision, skewx double precision DEFAULT 0, skewy double precision DEFAULT 0, touched boolean DEFAULT false) → raster -
st_asraster(geom geometry, width integer, height integer, gridx double precision, gridy double precision, pixeltype text, value double precision DEFAULT 1, nodataval double precision DEFAULT 0, skewx double precision DEFAULT 0, skewy double precision DEFAULT 0, touched boolean DEFAULT false) → raster -
st_asraster(geom geometry, width integer, height integer, gridx double precision DEFAULT NULL::double precision, gridy double precision DEFAULT NULL::double precision, pixeltype text[] DEFAULT ARRAY['8BUI'::text], value double precision[] DEFAULT ARRAY[(1)::double precision], nodataval double precision[] DEFAULT ARRAY[(0)::double precision], skewx double precision DEFAULT 0, skewy double precision DEFAULT 0, touched boolean DEFAULT false) → raster -
st_asraster(geom geometry, width integer, height integer, pixeltype text, value double precision DEFAULT 1, nodataval double precision DEFAULT 0, upperleftx double precision DEFAULT NULL::double precision, upperlefty double precision DEFAULT NULL::double precision, skewx double precision DEFAULT 0, skewy double precision DEFAULT 0, touched boolean DEFAULT false) → raster -
st_asraster(geom geometry, width integer, height integer, pixeltype text[], value double precision[] DEFAULT ARRAY[(1)::double precision], nodataval double precision[] DEFAULT ARRAY[(0)::double precision], upperleftx double precision DEFAULT NULL::double precision, upperlefty double precision DEFAULT NULL::double precision, skewx double precision DEFAULT 0, skewy double precision DEFAULT 0, touched boolean DEFAULT false) → raster
How it maps to the operation
| Operation parameter | Parameter here | Note |
|---|---|---|
layer | geom | Not stated |
resolution | Not stated | scalex and scaley: the cell size, with scaley negative. |
value | value | Not stated |
field | Not stated | Pass the column as value. |
all_touched | touched | Not stated |
Differences from the operation
- Per geometry; union the features first (ST_Union) or use ST_AsRaster with a reference raster for a common grid.
Harvested by the postgis harvester from engine version
3.7.0. Names can change when an engine is harvested again.