Results of 1 - 10 of about 67 for point (0.003 sec.)
- Spatial Functions 15022
- 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
...e geometry as a WKB (Well-Known-Binary) blob ST_Azimuth Returns the azimuth (a clockwise angle measured from north) of two points in radian. ST_Boundary Returns the "boundary" of a geometry ST_Buffer Returns a buffer around the input geometry at the t...yped multi geometry. ST_ConcaveHull Returns 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 t...er ST_DWithin_GEOS Returns if two geometries are within a target distance of each-other ST_DWithin_Spheroid Returns if two POINT_2D's are within a target distance in meters, using an ellipsoidal model of the earths surface ST_Difference Returns the "d... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Numeric Types 12106
- 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
...7e20201778 . Those are numbers with 20,201,779 decimal digits and storing a single such number requires 8 megabytes. Fixed-Point Decimals The data type DECIMAL(WIDTH, SCALE) (also available under the alias NUMERIC(WIDTH, SCALE) ) represents an exact f...ixed-point decimal value. When creating a value of type DECIMAL , the WIDTH and SCALE can be specified to define which size of decima...d. The WIDTH field determines how many digits can be held, and the scale determines the number of digits after the decimal point. For example, the type DECIMAL(3, 2) can fit the value 1.23 , but cannot fit the value 12.3 or the value 1.234 . The defau... - https://man.mtool.work/duckdb/2.0/sql/data_types/numeric.html
- Geometry Data Type 12021
- 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
...ospatial databases and GIS software. A GEOMETRY value 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 con...nected 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 footprint. The first ring is the "shell", and "interior" rin...gs represent holes in the polygon. MultiPoint A collection of points. MultiLineString A collection of LineStrings. MultiPolygon A collection of Polygons. GeometryCollec... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Geometry Functions 9730
- 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
...scription 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_GeomFromWKB Cre...| Example | ST_GeomFromWKB('\x01\x01\x00\x00\x00\x00\x00\x00\x00\x00\x00\xF0?\x00\x00\x00\x00\x00\x00\x00@') | | Result | POINT(1 2) | ST_AsWKB function | Description | Returns the Well-Known Binary (WKB) representation of the geometry | | Example |...ST_AsWKB('POINT(1 2)'::GEOMETRY) | | Result | \x01\x01\x00\x00\x00\x00\x00\x00\x00\x00\x00\xF0?\x00\x00\x00\x00\x00\x00\x00@ | | Alias | S... - https://man.mtool.work/duckdb/2.0/sql/functions/geometry.html
- Run Queries 8763
- Overview Java applications send queries and read result sets through the familiar Statement , PreparedStatement , and ResultSet interfaces. This page covers sending queries and reading DuckDB's nested and composite types. For opening the Co
...atement stmt = conn.prepareStatement("SELECT ?::INTEGER[]")) { stmt.setObject(1, list); stmt.execute(); } // STRUCT Struct point = conn.createStruct("STRUCT(x DOUBLE, y DOUBLE)", new Object[] {1.0, 2.0}); // MAP Map<String, Integer> counts = conn.crea...spatial extension builds its geometry types from STRUCT and LIST types, so they are bound with the same factory methods. A POINT_2D is a struct of two DOUBLE fields, and a LINESTRING is a list of such points. After loading the extension, build the val...ob() : try (Statement stmt = conn.createStatement()) { stmt.execute("INSTALL spatial"); stmt.execute("LOAD spatial"); } // POINT_2D is a STRUCT(x DOUBLE, y DOUBLE) Struct point = conn.createStruct("POINT_2D", new Object[] {41.1, 42.2}); try (PreparedS... - https://man.mtool.work/duckdb/2.0/clients/java/querying.html
- Types API 7881
- The DuckDBPyType class, duckdb.sqltypes.DuckDBPyType , represents one of the data types . Use DuckDBPyType to describe SQL types when declaring function parameters, return types or casts. Python types such as int are accepted too: int descr
...en , a list of pairs of a name and a type or a value. The field of a STRUCT type is also available by attribute or by key: point = duckdb.struct_type({"x": INTEGER, "y": VARCHAR}) print(point.id) print(point.children) print(point.x, point["y"]) struct... - https://man.mtool.work/duckdb/2.0/clients/python/types.html
- Numeric Functions 7739
- Numeric Operators The table below shows the available mathematical operators for numeric types . Operator Description Example Result + Addition 2 + 3 5 - Subtraction 2 - 3 -1 * Multiplication 2 * 3 6 / Float division 5 / 2 2.5 // Division 5
...equivalent when at least one of the operands is a FLOAT or a DOUBLE . When both operands are integers, / performs floating points division ( 5 / 2 = 2.5 ) while // performs integer division ( 5 // 2 = 2 ). Integer division ( // ), modulo ( % ), and IN...test common divisor of x and y . greatest(x1, x2, ...) Selects the largest value. isfinite(x) Returns true if the floating point value is finite, false otherwise. isinf(x) Returns true if the floating point value is infinite, false otherwise. isnan(x)...Returns true if the floating point value is not a number, false otherwise. lcm(x, y) Computes the least common multiple of x and y . least_common_multiple(x,... - https://man.mtool.work/duckdb/2.0/sql/functions/numeric.html
- Non-Deterministic Behavior 7568
- Several operators in DuckDB exhibit non-deterministic behavior. Most notably, SQL uses set semantics, which allows results to be returned in a different order. DuckDB exploits this to improve performance, particularly when performing multi-
...ECT array_distinct(['A', 'A', 'B', NULL, NULL]) AS arr; For this query, both [A, B] and [B, A] are valid results. Floating-Point Aggregate Operations with Multi-Threading Floating-point inaccuracies may produce different results when run in multi-thre...of s . However, when executed on multiple threads, the query may return small numbers ( 0 <= z < 10e-16 ) due to floating-point inaccuracies. Working Around Non-Determinism For the majority of use cases, non-determinism is not causing any issues. How... - https://man.mtool.work/duckdb/2.0/operations_manual/non-deterministic_behavior.h...
- Writing JSON 7426
- The contents of tables or the result of queries can be written directly to a JSON file using the COPY statement. For example: CREATE TABLE cities AS FROM (VALUES ('Amsterdam', 1), ('London', 2)) cities(name, id); COPY cities TO 'cities.json
...SON ) writes newline-delimited Feature objects. You do not need json_geometry_format for these copy formats. COPY (SELECT 'POINT(0 1)'::GEOMETRY AS geom, 10 AS my_field) TO 'test.json' (FORMAT GEOJSON); COPY (SELECT 'POINT(0 1)'::GEOMETRY AS geom, 10... - https://man.mtool.work/duckdb/2.0/data/json/writing_json.html
- Aggregate Functions 7426
- Examples Produce a single row containing the sum of the amount column: SELECT sum(amount) FROM sales; Produce one row per unique region, containing the sum of amount for each group: SELECT region, sum(amount) FROM sales GROUP BY region; Ret
...t sale using the first() aggregate function: SELECT first(amount ORDER BY date ASC) FROM sales; Downsample a series of 100 points to 5 points that preserve its visual shape using the lttb() aggregate function : SELECT unnest(lttb(x, sin(x), 5 ORDER BY...x)) AS point FROM range(0, 100) t(x); ┌───────────────────────────────────────┐ │ point │ │ struct(x double, y double) │ ├─────────────...ning a DECIMAL with the same width and scale as the input. favg(arg) Calculates the average using a more accurate floating point summation (Kahan Sum). This function is affected by ordering . first(arg) Returns the first value (null or non-null) from... - https://man.mtool.work/duckdb/2.0/sql/functions/aggregates.html
DuckDB 2.0 Documentation / man.mtool.work