Results of 1 - 5 of about 5 for Extent (0.002 sec.)
- Spatial Functions 12446
- 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
...the minimum bounding rectangle of a geometry as a polygon geometry ST_Equals Returns true if the geometries are "equal" ST_Extent Returns the minimal bounding box enclosing the input geometry ST_Extent_Approx Returns the approximate bounding box of a g...tersection Returns the intersection of two geometries ST_Intersects Returns true if the geometries intersect ST_Intersects_Extent Returns true if the extent of two geometries intersects ST_IsClosed Check if a geometry is 'closed' ST_IsEmpty Returns tru...intaining coverage ST_CoverageUnion_Agg Unions a set of geometries while maintaining coverage ST_Envelope_Agg Alias for ST_Extent_Agg . ST_Extent_Agg Computes the minimal-bounding-box polygon containing the set of input geometries ST_Intersection_Agg C... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Geometry Functions 9946
- 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
...perator 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 Geometry Functions Name Description ST_GeomFr...KB) representation of the geometry 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...he geometry | | Example | ST_AsText('POINT(1 2)'::GEOMETRY) | | 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 && '... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- UNPIVOT Statement 8273
- The UNPIVOT statement allows multiple columns to be stacked into fewer columns. In the basic case, multiple columns are stacked into two columns: a NAME column (which contains the name of the source column) and a VALUE column (which contain
...s additional flexibility: more than 2 destination columns are supported. This can be useful when the goal is to reduce the extent to which a dataset is pivoted, but not completely stack all pivoted columns. To demonstrate this, the query below will gen...s additional flexibility: more than 2 destination columns are supported. This can be useful when the goal is to reduce the extent to which a dataset is pivoted, but not completely stack all pivoted columns. To demonstrate this, the query below will gen... - https://man.mtool.work/duckdb/2.0/sql/statements/unpivot.html
- Numeric Types 7721
- Fixed-Width Integer Types The types TINYINT , SMALLINT , INTEGER , BIGINT and HUGEINT store whole numbers, that is, numbers without fractional components, of various ranges. Attempts to store values outside of the allowed range will result
...lementations of IEEE Standard 754 for Binary Floating-Point Arithmetic (single and double precision, respectively), to the extent that the underlying processor, operating system, and compiler support it. Name Aliases Description FLOAT FLOAT4 , REAL Sin... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Geometry Data Type 7537
- 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
...::GEOMETRY AS geom; SELECT stats(geom) AS geom_stats FROM geometries; The result is a VARIANT value: {'approx_unique': 1, 'extent': {'x_max': 30.0, 'x_min': 30.0, 'y_max': 10.0, 'y_min': 10.0, 'z_max': 5.0, 'z_min': 5.0}, 'has_empty_geom': false, 'has_... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work