Results of 1 - 6 of about 6 for area (0.002 sec.)
- Spatial Functions 12027
- 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
...ibrary version that is being used by this instance of DuckDB. ST_Affine Applies an affine transformation to a geometry. ST_Area Compute the area of a geometry. ST_Area_Spheroid Returns the area of a geometry in meters, using an ellipsoidal model of t...y Returns the "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...ngle Returns the minimum rotated rectangle that bounds the input geometry, finding the surrounding box that has the lowest area by using a rotated rectangle, rather than taking the lowest and highest coordinate values as per ST_Envelope(). ST_Multi T... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- HTTP CSV Import 10711
- To load a CSV file directly over HTTP(S), the httpfs extension is required. This can be installed using the INSTALL SQL command. This only needs to be run once. INSTALL httpfs; To load the httpfs extension for usage, use the LOAD SQL comman
...ds an openly licensed (CC BY 4.0) real-world CSV directly over HTTP and aggregates it, with no local download step: SELECT area, round(avg(sunbed_price), 0) AS avg_sunbed_price_eur, count(*) AS clubs FROM 'http://blobs.duckdb.org/data/beach-clubs.csv...' WHERE sunbed_price IS NOT NULL GROUP BY area ORDER BY avg_sunbed_price_eur DESC; ┌────────────────────────────┬──────────────────────┬───────┐ │ area │ avg_sunbed_pric... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/http_csv_import.h...
- R-Tree Indexes 9742
- 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
...xt of 2D geometry), we mean the minimum bounding rectangle. Additionally, we tend to assume 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...es) CREATE INDEX my_idx ON t1 USING RTREE (geom) WITH (max_node_capacity = 4); -- Inspect the R-tree index. Notice how the area of the bounding boxes of the branch nodes -- decreases as we go deeper into the tree. SELECT level, bounds::GEOMETRY AS ge...om, CASE WHEN row_id IS NULL THEN st_area(geom) ELSE NULL END AS area, row_id, CASE WHEN row_id IS NULL THEN 'branch' ELSE 'leaf' END AS kind FROM rtree_index_dump(... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- Import Data 7585
- Overview The Rust client offers two ways to get data into DuckDB in bulk: the high-performance Appender for inserting rows from Rust, and reading directly from data files such as Parquet, CSV, and JSON. Both are described below. Appender Th
...n() -> Result<()> { let mut db = Connection::open_in_memory()?; db.execute_batch( "CREATE TABLE test (id INTEGER NOT NULL, area CHAR(6), age TINYINT NOT NULL, active TINYINT NOT NULL)", )?; let row_count = 10_000_000; { let mut tx = db.transaction()?... - https://man.mtool.work/duckdb/2.0/clients/rust/data_import.html
- What's New in the Docs for 2.0 7585
- This page tracks the documentation for the features introduced in DuckDB 2.0, organized around the themes of the DuckDB 2.0.0 release announcement . Each section links to the relevant documentation. DuckDB as a Server: Quack and CONNECT Sin
...extensions are no longer built Other Documentation Updates Additional 2.0 features documented across the site, grouped by area. Data Import and Export Writing GeoJSON and loading GeoJSON The Parquet schema parameter and new Parquet writing options T... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Geometry Data Type 7110
- 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
...v1.5 and above. However, almost all of the associated functions for working with geometries (e.g., calculating distances, areas, intersections) are still part of spatial . Types of Geometries Conceptually, the GEOMETRY type follows the core data mod...raight 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" rings represent holes in t...dentifier" as a parameter of the GEOMETRY type. For example, a column of type GEOMETRY('OGC:CRS84') stores geometries that are associated with the "OGC CRS84" coordinate reference system. CRS identifiers in DuckDB are always strings. OGC:CRS84 is the... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work