st_value
How PostGIS Raster runs Extract Values to Points: st_value.
| Engine | PostGIS Raster |
|---|---|
| Tool name | st_value |
| Interface | sql |
| Implements | Extract Values to Points |
| Preset | {"band":1} |
| Documentation | Not stated |
| Effects | modifies input: no, network: no |
| Notes | Not stated |
| Status | active |
Parameters
| Name | Type | Required | Default | Choices | Note |
|---|---|---|---|---|---|
rast | raster | no | Not stated | Not stated | Not stated |
band | integer | no | Not stated | Not stated | Not stated |
pt | geometry | no | Not stated | Not stated | Not stated |
exclude_nodata_value | boolean | no | true | Not stated | Not stated |
resample | text | no | 'nearest'::text | Not stated | Not stated |
x | integer | no | Not stated | Not stated | Not stated |
y | integer | no | Not stated | Not stated | Not stated |
SQL overloads
-
st_value(rast raster, band integer, pt geometry, exclude_nodata_value boolean DEFAULT true, resample text DEFAULT 'nearest'::text) → double precision -
st_value(rast raster, band integer, x integer, y integer, exclude_nodata_value boolean DEFAULT true) → double precision -
st_value(rast raster, pt geometry, exclude_nodata_value boolean DEFAULT true) → double precision -
st_value(rast raster, x integer, y integer, exclude_nodata_value boolean DEFAULT true) → double precision
How it maps to the operation
| Operation parameter | Parameter here | Note |
|---|---|---|
raster | rast | Not stated |
points | pt | Not stated |
resampling | resample | Not stated |
Differences from the operation
- Returns the value at one point; run it once per point row. resample also offers cubic and cubic spline interpolation.
Harvested by the postgis harvester from engine version
3.7.0. Names can change when an engine is harvested again.