Results of 1 - 7 of about 7 for Coordinate (0.003 sec.)
- Spatial Functions 11996
- 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...try or geometry collection created by filtering and interpolating vertices within a range of "M" values ST_M Returns the M coordinate of a point geometry ST_MMax Returns the maximum M coordinate of a geometry ST_MMin Returns the minimum M coordinate of a g...eometry 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 flo... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Geometry Data Type 11559
- 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...present, which means that the execution engine will not be able to do any optimizations based on the geometry statistics. Coordinate Reference Systems As far as the execution engine is concerned, geometries are considered to exist in a Cartesian coordinat... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Geometry Functions 9396
- 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
...esentation 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 Reference System (CRS) identifier of the g...METRY && 'LINESTRING(0 0, 10 20)'::GEOMETRY | | Result | true | | Alias | && | ST_CRS function | Description | Returns the Coordinate Reference System (CRS) identifier of the geometry | | Example | ST_CRS('POINT(1 2)'::GEOMETRY('OGC:CRS84')) | | Result | O...GC:CRS84 | ST_SetCRS function | Description | Sets the Coordinate Reference System (CRS) identifier of the geometry | | Example | typeof(ST_SetCRS('POINT(1 2)'::GEOMETRY, 'OGC:CRS84')) | |... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- Querying Parquet Metadata 7997
- Parquet Metadata The parquet_metadata function can be used to query the metadata contained within a Parquet file, which reveals various internal details of the Parquet file such as the statistics of the different columns. This can be useful
...BLOB GeoParquet Metadata GeoParquet files store their geospatial metadata (the primary geometry column, its encoding, the coordinate reference system, and more) under the geo key of the Parquet key-value metadata. Because parquet_kv_metadata returns the k...adata('file.parquet') WHERE decode(key) = 'geo'; version primary_column encoding 1.0.0 geometry WKB When the file embeds a coordinate reference system, it is stored as PROJJSON under the geometry column's crs key, for example decode(value)->>'$.columns.geo... - https://man.mtool.work/duckdb/2.0/data/parquet/metadata.html
- DuckDB_% Metadata Functions 7724
- DuckDB offers a collection of table functions that provide metadata about the current database. These functions reside in the main schema and their names are prefixed with duckdb_ . The resultset returned by a duckdb_ table function may be
...al_constraints and information_schema.table_constraints are implemented as a query on top of duckdb_constraints() ) duckdb_coordinate_systems The duckdb_coordinate_systems() function lists the available coordinate reference systems (CRS) for use with the G... - https://man.mtool.work/duckdb/2.0/sql/meta/duckdb_table_functions.html
- R-Tree Indexes 7506
- 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
...that bounding boxes/rectangles are axis-aligned, i.e., the rectangle is not rotated – the sides are always parallel to the coordinate axes. The MBR of a point is the point itself. By traversing the R-tree from top to bottom, it is possible to very quickly... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- Configuration 7379
- DuckDB has a number of configuration options that can be used to change the behavior of the system. The configuration options can be set using either the SET statement or the PRAGMA statement . They can be reset to their original values usi
...ported floating point operations, returning NAN/INF instead of errors/NULL. BOOLEAN true ignore_unknown_crs Ignore unknown Coordinate Reference Systems (CRS) when creating geometry types or importing geospatial data. BOOLEAN false immediate_transaction_mod... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work