Results of 1 - 4 of about 4 for Intersects (0.002 sec.)
- Geometry Functions 11835
- This section describes the functions for examining and manipulating GEOMETRY values. The spatial extension provides additional functions for working with GEOMETRY values, which are documented in the Spatial Functions section. Geometry Opera
...Y values. Operator Description Example Result && Returns true if the geometries bounding boxes intersect. Equivalent to ST_Intersects_Extent . 'POINT(5 5)'::GEOMETRY && 'LINESTRING(0 0, 10 20)'::GEOMETRY true Built-in Geometry Functions Name Description ST...n Binary (WKB) representation of the geometry ST_AsWKT Returns the Well-Known Text (WKT) representation of the geometry ST_Intersects_Extent Returns true if the geometries bounding boxes intersect ST_CRS Returns the Coordinate Reference System (CRS) identi...tation of the geometry | | Example | ST_AsText('POINT(1 2)'::GEOMETRY) | | Result | POINT (1 2) | | Alias | ST_AsText | ST_Intersects_Extent function | Description | Returns true if the geometries bounding boxes intersect | | Example | 'POINT(5 5)'::GEOMET... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- Spatial Functions 10133
- Function Index Scalar Functions Function Summary DuckDB_PROJ_Compiled_Version Returns a text description of the PROJ library version that this instance of DuckDB was compiled against. DuckDB_Proj_Version Returns a text description of the PR
...en POINT and returns the interpolated M value of that point. ST_Intersection Returns the intersection of two geometries ST_Intersects Returns true if the geometries intersect ST_Intersects_Extent Returns true if the extent of two geometries intersects ST_I...nature GEOMETRY ST_Intersection (geom1 GEOMETRY, geom2 GEOMETRY) Description Returns the intersection of two geometries ST_Intersects Signatures BOOLEAN ST_Intersects (box1 BOX_2D, box2 BOX_2D) BOOLEAN ST_Intersects (geom1 GEOMETRY, geom2 GEOMETRY) Descrip...tion Returns true if the geometries intersect ST_Intersects_Extent Signature BOOLEAN ST_Intersects_Extent (geom1 GEOMETRY, geom2 GEOMETRY) Description Returns true if th... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Geometry Data Type 7674
- Name Description GEOMETRY Geospatial entity The GEOMETRY data type is used to store and manipulate geometric objects, such as points, lines, and polygons. The GEOMETRY type was part of the spatial extension but became a built-in data type i
...nding box of the query geometry. Currently, only the && operator, which is used to check if the bounding box of a geometry intersects the bounding box of another geometry, can take advantage of geometry statistics when used in a WHERE clause. There is ongo...ing work to add support for more statistics-based optimizations to the functions in the spatial extension, such as ST_Intersects , ST_Distance , etc. Persisting geometry statistics is only possible in storage versions v1.5 and above, and so if you are... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- R-Tree Indexes 7304
- The spatial extension provides support for spatial indexing through the R-tree extension index type. Why Should I Use an R-Tree Index? When working with geospatial datasets, it is very common that you want to filter rows based on their spat
...ing a WHERE clause) with one of the following spatial predicate functions (as they all imply intersection): ST_Equals , ST_Intersects , ST_Touches , ST_Crosses , ST_Within , ST_Contains , ST_Overlaps , ST_Covers , ST_CoveredBy , ST_ContainsProperly . One o... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work