Results of 1 - 10 of about 10 for geospatial (0.003 sec.)
- GDAL Integration 12710
- 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
...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 format... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/gdal.html
- Geometry Data Type 11173
- 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
...nceptually, 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...ution engine is concerned, geometries are considered to exist in a Cartesian coordinate system. In practice, however, most geospatial data is associated with a specific Coordinate Reference System (CRS) that defines how the coordinates relate to real-world...locations on the Earth's surface. A helpful analogy is to think of CRSs as the equivalent of "time zones", but for geospatial data. Just like how time zones define how local time relates to a standard reference time (e.g., UTC), CRSs define how the... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Spatial Extension 10082
- 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
... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/overview.html
- Load Extensions 8974
- 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
...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 community; LOAD h3;...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 tpcds Adds TPC-DS data gene... - https://man.mtool.work/duckdb/2.0/clients/wasm/extensions.html
- Spatial Functions 8759
- 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
...ST_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...pbf 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_...OB, spatial_filter_box BOX_2D, allowed_drivers VARCHAR[], open_options VARCHAR[]) Description Read and import a variety of geospatial file formats using the GDAL library. The ST_Read table function is based on the GDAL translator library and enables readin... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Core Extensions 8313
- List of Core Extensions Name Description Maintainer Support tier Aliases autocomplete Autocompletion for CLI client DuckDB team avro Avro files reading DuckDB team aws AWS S3 functionality DuckDB team azure Filesystem abstraction for Azure
...ckDB-Quack protocol for remote access DuckDB team sirius GPU-accelerated query execution (coming soon) Third party spatial Geospatial data and functions DuckDB team sqlite SQLite database read/write operations DuckDB team sqlite_scanner, sqlite3 tpcds TPC-... - https://man.mtool.work/duckdb/2.0/core_extensions/overview.html
- Querying Parquet Metadata 7651
- 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
...by parquet_kv_metadata . Field Type file_name VARCHAR key BLOB value 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 P... - https://man.mtool.work/duckdb/2.0/data/parquet/metadata.html
- Data Types 7651
- General-Purpose Data Types The table below shows all the built-in general-purpose data types. The alternatives listed in the aliases column can be used to refer to these types as well, however, note that the aliases are not part of the SQL
...le precision floating-point number (8 bytes) FLOAT FLOAT4 , REAL Single precision floating-point number (4 bytes) GEOMETRY Geospatial entity, see the GEOMETRY data type HUGEINT Signed sixteen-byte integer INTEGER INT4 , INT , SIGNED Signed four-byte intege... - https://man.mtool.work/duckdb/2.0/sql/data_types/overview.html
- R-Tree Indexes 7204
- 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
... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- Configuration 6775
- 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
...OOLEAN true ignore_unknown_crs Ignore unknown Coordinate Reference Systems (CRS) when creating geometry types or importing geospatial data. BOOLEAN false immediate_transaction_mode Whether transactions should be started lazily when needed, or immediately w... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work