Results of 1 - 4 of about 4 for geometries (0.002 sec.)
- Spatial Functions 11409
- 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
...y attempting to "fill in" the input geometry. ST_Centroid Returns the centroid of a geometry ST_Collect Collects a list of geometries into a collection geometry. ST_CollectionExtract Extracts geometries from a GeometryCollection into a typed multi geometry...ing the coverage by ensuring that there are no seams between the resulting simplified polygons. ST_CoverageUnion Union all geometries in a polygonal coverage into a single geometry. ST_CoveredBy Returns true if geom1 is "covered by" geom2 ST_Covers Returns...true if the geom1 "covers" geom2 ST_Crosses Returns true if geom1 "crosses" geom2 ST_DWithin Returns if two geometries are within a target distance of each-other ST_DWithin_GEOS Returns if two geometries are within a target distance of each-... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Geometry Data Type 10670
- 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
...ilable in databases using storage version v1.5 and above. However, almost all of the associated functions for working with geometries (e.g., calculating distances, areas, intersections) are still part of spatial . Types of Geometries Conceptually, the GEOM.... MultiPolygon A collection of Polygons. GeometryCollection A collection of different geometry types, allowing for complex geometries that combine points, lines, and polygons or even other nested geometry collections. The textual representation of geometri...es uses "Well-Known Text" (WKT) format. Geometries can be cast to and from WKT strings, so you can use string literals to create geometries directly in SQL statements. In th... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Geometry Functions 7803
- 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
...elow lists the operators that can be used with GEOMETRY 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)'::GEOMETR...eometry 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) identifier of the geometry ST_SetCRS Sets th...OMETRY) | | Result | POINT (1 2) | | Alias | ST_AsText | ST_Intersects_Extent function | Description | Returns true if the geometries bounding boxes intersect | | Example | 'POINT(5 5)'::GEOMETRY && 'LINESTRING(0 0, 10 20)'::GEOMETRY | | Result | true | |... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- R-Tree Indexes 7045
- 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
...their parent nodes don't intersect the query region at all. Once the leaf nodes are reached, only the specific rows whose geometries intersect the query region have to be fetched from disk, and the often much more expensive exact spatial predicate check (... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work