⌘K ctrl+k
Search Shortcut cmd + k | ctrl + k
DuckDB 2.0 ドキュメント 全文検索
per page, with , order by , clip by
Results of 1 - 4 of about 4 for polygon (0.002 sec.)
Spatial Functions 11687
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 ... boundary" of a geometry ST_Buffer Returns a buffer around the input geometry at the target distance ST_BuildArea Creates a polygonal geometry by attempting to "fill in" the input geometry. ST_Centroid Returns the centroid of a geometry ST_Collect Collec ... rns the 'concave' hull of the input geometry, containing all of the source input's points, and which can be used to create polygons from points. The ratio parameter dictates the level of concavity; 1.0 returns the convex hull; and 0 indicates to return ... ometry ST_ConvexHull Returns the convex hull enclosing the geometry ST_CoverageInvalidEdges Returns the invalid edges in a polygonal coverage, which are edges that are not shared by two polygons. ST_CoverageSimplify Simplify the edges in a polygonal cov ...
https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
R-Tree Indexes 10318
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 ... ometry │ double │ int64 │ varchar │ ├───────┼──────────────────────────────┼────────────────────┼────────┼─────────┤ │ 0 │ POLYGON ((2.17285037040710… │ 3286.396482226409 │ │ branch │ │ 0 │ POLYGON ((6.00962591171264… │ 3193.725100864862 │ │ branch │ │ ... 0 │ POLYGON ((0.74995160102844… │ 3099.921458393704 │ │ branch │ │ 0 │ POLYGON ((14.6168870925903… │ 2322.2760491675654 │ │ branch │ │ ... 1 │ POLYGON ((2.17285037040710… │ 604.1520104388514 │ │ branch │ │ 1 │ POLYGON ((26.6022186279296… │ 569.1665467030252 │ │ branch │ │ ...
https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
Geometry Data Type 7766
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 ... (e.g., longitude and latitude). LineString A sequence of points connected by straight lines, representing a path or route. Polygon A set of closed rings defined by a sequence of points, representing an area such as a country border or a building footpri ... nt. The first ring is the "shell", and "interior" rings represent holes in the polygon. MultiPoint A collection of points. MultiLineString A collection of LineStrings. MultiPolygon A collection of Polygons. Ge ... ometryCollection 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 geometries uses "Well-Known Text" (WKT) format. ...
https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
GDAL Integration 7175
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 ... e drivers. GEOMETRY_TYPE : the geometry type for the created layer to pass to the GDAL driver. One of POINT , LINESTRING , POLYGON , MULTIPOINT , MULTILINESTRING , MULTIPOLYGON and GEOMETRYCOLLECTION . LAYER_NAME : assign an alternate name to the new la ...
https://man.mtool.work/duckdb/2.0/core_extensions/spatial/gdal.html
PREV 1 NEXT
DuckDB 2.0 Documentation / man.mtool.work