st_intersection
How PostGIS runs Clip: st_intersection.
| Engine | PostGIS |
|---|---|
| Tool name | st_intersection |
| Interface | sql |
| Implements | Clip |
| Variant of | postgis-st-intersection |
| Documentation | Not stated |
| Effects | modifies input: no, network: no |
| Notes | Not stated |
| Status | active |
Parameters
| Name | Type | Required | Default | Choices | Note |
|---|---|---|---|---|---|
geom1 | geometry | no | Not stated | Not stated | Not stated |
geom2 | geometry | no | Not stated | Not stated | Not stated |
gridsize | double precision | no | '-1'::integer | Not stated | Not stated |
SQL overloads
-
st_intersection(geography, geography) → geography -
st_intersection(geom1 geometry, geom2 geometry, gridsize double precision DEFAULT '-1'::integer) → geometry -
st_intersection(text, text) → geometry
How it maps to the operation
| Operation parameter | Parameter here | Note |
|---|---|---|
layer | geom1 | Not stated |
mask | geom2 | Not stated |
Differences from the operation
- Per pair of geometries: union the mask first, or join on ST_Intersects and intersect each pair.
Harvested by the postgis harvester from engine version
3.7.0. Names can change when an engine is harvested again.