Results of 1 - 4 of about 4 for coordinates (0.003 sec.)
- Spatial Functions 11983
- 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
...bounding box of a geometry, if available. ST_ExteriorRing Returns the exterior ring (shell) of a polygon geometry. ST_FlipCoordinates Returns a new geometry with the coordinates of the input geometry "flipped" so that x = y and y = x ST_Force2D Forces the...a geometry ST_MakeBox2D Create a BOX2D from two POINT geometries ST_MakeEnvelope Create a rectangular polygon from min/max coordinates ST_MakeLine Create a LINESTRING from a list of POINT geometries ST_MakePoint Creates a GEOMETRY point from an pair of floa...oom level and tile indices. ST_Touches Returns true if the geometries touch ST_Transform Transforms a geometry between two coordinate systems ST_Union Returns the union of two geometries ST_VoronoiDiagram Returns the Voronoi diagram of the supplied MultiPoi... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Geometry Data Type 9782
- 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
...alue can therefore represent 7 types of shapes: Geometry Type Description Point A single location in space, defined by its coordinates (e.g., longitude and latitude). LineString A sequence of points connected by straight lines, representing a path or route....vertex dimensions of a GEOMETRY value must be consistent across all vertices. For example, if one vertex has X , Y , and Z coordinates, then all other vertices in that geometry must also have X , Y , and Z coordinates. This means that you cannot have a mix...oordinate Reference Systems As far as the execution engine is concerned, geometries are considered to exist in a Cartesian coordinate system. In practice, however, most geospatial data is associated with a specific Coordinate Reference System (CRS) that def... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Unity Catalog Extension 8025
- The unity_catalog extension attaches a Unity Catalog catalog, on Databricks or Unity Catalog OSS, as a DuckDB database. You can list, read, insert into and create its Delta Lake tables. It uses the delta extension to access the tables. For
...abricks and in Unity Catalog OSS may use catalog-managed commits (Catalog-Coordinated Commits / CCv2), where Unity Catalog coordinates commits rather than writers committing directly to the Delta log. Since v1.5.2 (v1.5.5 for Unity Catalog OSS), DuckDB uses...t. INSERT statements are identical in syntax, but they commit through the catalog-managed write protocol, so Unity Catalog coordinates concurrent writers. For details, see the “Delta Grows Up: Writes, Unity Catalog and Time Travel” blog post . A managed tab... - https://man.mtool.work/duckdb/2.0/core_extensions/unity_catalog.html
- List Functions 7156
- Function Description list[index] Extracts a single list element using a (1-based) index . list[begin[:end][:step]] Extracts a sublist using slice conventions . Negative values are accepted. list1 && list2 Alias for list_has_any . list1 <->
...gregate function count to the list . list_distance(list1, list2) Calculates the Euclidean distance between two points with coordinates given in two inputs lists of equal length. list_distinct(list) Removes all duplicates and NULL values from a list. Does no...9]) | | Result | 3 | list_distance(list1, list2) | Description | Calculates the Euclidean distance between two points with coordinates given in two inputs lists of equal length. | | Example | list_distance([1, 2, 3], [1, 2, 5]) | | Result | 2.0 | | Alias |... - https://man.mtool.work/duckdb/2.0/sql/functions/list.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work