Results of 1 - 3 of about 3 for boxes (0.001 sec.)
- Geometry Functions 11831
- 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
...tors 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)'::GEOMETRY true Built-in...urns 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 the Coordinate Re...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 | | Alias | && | ST... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- R-Tree Indexes 8594
- 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
...box" in the context of 2D geometry), we mean the minimum bounding rectangle. Additionally, we tend to assume that bounding boxes/rectangles are axis-aligned, i.e., the rectangle is not rotated – the sides are always parallel to the coordinate axes. Th...tionally, using the bulk loading algorithm tends to create a R-tree with a better structure (less overlap between bounding boxes), which usually leads to better query performance. If you find that the performance of querying the R-tree starts to deter...dx ON t1 USING RTREE (geom) WITH (max_node_capacity = 4); -- Inspect the R-tree index. Notice how the area of the bounding boxes of the branch nodes -- decreases as we go deeper into the tree. SELECT level, bounds::GEOMETRY AS geom, CASE WHEN row_id I... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- GDAL Integration 7440
- The spatial extension integrates the GDAL translator library to read and write spatial data from a variety of geospatial vector file formats. See the documentation for the st_read table function for how to make use of this in practice. In o
...ctor formats through a GDAL based COPY function. For example, to export a table to a GeoJSON file, with generated bounding boxes, you can use the following query: COPY ⟨table⟩ TO 'some/file/path/filename.geojson' WITH (FORMAT gdal, DRIVER 'GeoJSON', L... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/gdal.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work