Results of 1 - 10 of about 18 for Spatial (0.002 sec.)
- Spatial Extension 13280
- The spatial extension provides support for geospatial data processing in DuckDB. For an overview of the extension, see our blog post . Installing and Loading To install the spatial extension, run: INSTALL spatial; Note that the spatial exte
...nsion is not autoloadable. Therefore, you need to load it before using it: LOAD spatial;... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/overview.html
- GDAL Integration 10826
- The spatial extension integrates the GDAL translator library to read and write spatial data from a variety of geospatial vector file formats. See the documentation for the st_read table function for how to make use of this in practice. In o
...rder to spare users from having to setup and install additional dependencies on their system, the spatial extension bundles its own copy of the GDAL library. This also means that spatial's version of GDAL may not be the latest v...ction on the st_drivers table function to inspect which GDAL drivers are currently available. GDAL Based COPY Function The spatial extension does not only enable importing geospatial file formats (through the ST_Read function), it also enables exporting...DuckDB tables to different geospatial vector formats through a GDAL based COPY function. For example, to export a table to a GeoJSON file, with generated boundi... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/gdal.html
- R-Tree Indexes 10449
- 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 spatial
...fic rows whose geometries intersect the query region have to be fetched from disk, and the often much more expensive exact spatial predicate check (and any other filters) only have to be executed for these rows. What Are the Limitations of R-Tree Indexe...dex will only be used to perform "index scans" when the table is filtered (using a WHERE clause) with one of the following spatial predicate functions (as they all imply intersection): ST_Equals , ST_Intersects , ST_Touches , ST_Crosses , ST_Within , ST..._Contains , ST_Overlaps , ST_Covers , ST_CoveredBy , ST_ContainsProperly . One of the arguments to the spatial predicate function must be a "constant" (i.e., an expression whose result is known at query planning time). This is becaus... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- LOAD / INSTALL Statements 9934
- INSTALL The INSTALL statement downloads an extension so it can be loaded into a DuckDB session. Examples Install the httpfs extension: INSTALL httpfs; Install the h3 community extension : INSTALL h3 FROM community; Syntax LOAD The LOAD stat
...ing iceberg also installs the avro extension that it depends on. Examples Load the httpfs extension: LOAD httpfs; Load the spatial extension: LOAD spatial; Syntax INSTALL AND LOAD New The INSTALL AND LOAD statement was introduced in DuckDB 2.0. The INST...lowed by a FROM clause to select the repository and a VERSION clause to select the version . Examples Install and load the spatial extension: INSTALL AND LOAD spatial; Install and load the h3 community extension : INSTALL AND LOAD h3 FROM community; Rei... - https://man.mtool.work/duckdb/2.0/sql/statements/load_and_install.html
- Geometry Data Type 9848
- 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
...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 model defined in the Simple Features standard,...which is widely used in geospatial databases and GIS software. A GEOMETRY value can therefore represent 7 types of shapes: Geometry Type Description Point A...EMPTY , etc.) which means they don't contain any vertices. Empty geometries are still valid geometries and can be used in spatial operations, but they are mostly useful for representing the result of topological operations that don't have a valid geome... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Installing Extensions 9334
- To install core DuckDB extensions, use the INSTALL command. For example: INSTALL httpfs; This installs the extension from the default repository ( core ). Extension Repositories By default, DuckDB extensions are installed from a single repo
...- or INSTALL httpfs FROM 'http://extensions.duckdb.org'; To install an extension from the core nightly repository: INSTALL spatial FROM core_nightly; -- or INSTALL spatial FROM 'http://nightly-extensions.duckdb.org'; To install an extension from a custo...can also be used to overwrite an extension with an extension of the same name from another repository, For example, first, spatial is installed from the core repository: INSTALL spatial; Then, to overwrite this installation with the spatial extension fr...om the core_nightly repository: FORCE INSTALL spatial FROM core_nightly; Switching between Repositories To switch repositories for an extension, use the FORCE INSTALL command.... - https://man.mtool.work/duckdb/2.0/extensions/installing_extensions.html
- Load Extensions 8373
- Overview DuckDB-Wasm's (dynamic) extension loading is modeled after regular DuckDB's extension loading, with a few relevant differences due to the difference in platform. A growing subset of core, community, and external extensions is suppo
...rather than being bundled into the DuckDB-Wasm binary. For example: -- Explicitly load a core extension LOAD icu; -- Load spatial for geospatial support INSTALL spatial; LOAD spatial; -- Install a community extension, then load it INSTALL h3 FROM commu...data types and functions json Adds support for JSON operations parquet Adds support for reading and writing Parquet files spatial Adds support for geospatial data types and functions sqlite Adds support for reading SQLite database files sqlite, sqlite3... - https://man.mtool.work/duckdb/2.0/clients/wasm/extensions.html
- Extensions 8373
- DuckDB has a flexible extension mechanism that allows for dynamically loading extensions. Extensions can enhance DuckDB's functionality by providing support for additional file formats, introducing new types, and domain-specific functionali
...ts INSTALL and LOAD , which can be combined into a single INSTALL AND LOAD statement. For example, to install and load the spatial extension , run: INSTALL AND LOAD spatial; With this statement, DuckDB will ensure the spatial extension is installed (ski...pping the installation if it is already installed), then proceed to load the spatial extension (again skipping this step if it is already loaded). Extension Repository Optionally a repository can be provided... - https://man.mtool.work/duckdb/2.0/extensions/overview.html
- Troubleshooting of Extensions 8373
- You might be visiting this page directed via a DuckDB error message, similar to: INSTALL non_existing; HTTP Error: Failed to download extension "non_existing" at URL "http://extensions.duckdb.org/v2.0.0/osx_arm64/non_existing.duckdb_extensi
...load the relevant extension resource, for example via your browser visiting https://extensions.duckdb.org/v2.0.0/osx_arm64/spatial.duckdb_extension.gz or any other link that has been provided. The extension server can be reached over both http:// and ht...will download and unpack the extension to the default Downloads folder, so that from SQL you can run: INSTALL '~/Downloads/spatial.duckdb_extension'; -- or FORCE INSTALL '~/Downloads/spatial.duckdb_extension'; and after this command the extension will b... - https://man.mtool.work/duckdb/2.0/extensions/troubleshooting.html
- Spatial Functions 8287
- 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
...GeneratePoints Generates a set of random points within the specified bounding box. ST_Read Read and import a variety of geospatial file formats using the GDAL library. ST_ReadOSM The ST_ReadOsm() table function enables reading compressed OpenStreetMap d...file. ST_ReadSHP Read a Shapefile without relying on the GDAL library ST_Read_Meta Read the metadata from a variety of geospatial file formats using the GDAL library. Scalar Functions DuckDB_PROJ_Compiled_Version Signature VARCHAR DuckDB_PROJ_Compiled_...is not a POLYGON , MULTIPOLYGON or GEOMETRYCOLLECTION containing polygon geometries. The area is in the same units as the spatial reference system of the geometry. The POINT_2D and LINESTRING_2D overloads of this function always return 0.0 but are incl... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
DuckDB 2.0 Documentation / man.mtool.work