Results of 1 - 8 of about 8 for layer (0.002 sec.)
- GDAL Integration 13465
- 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
...s, you can use the following query: COPY ⟨table⟩ TO 'some/file/path/filename.geojson' WITH (FORMAT gdal, DRIVER 'GeoJSON', LAYER_CREATION_OPTIONS ('WRITE_BBOX=YES', 'DESCRIPTION=a sample geojson'), SRS 'EPSG:4326'); Available options: FORMAT : is the...the export. Use ST_Drivers() to list the names of all available drivers. GEOMETRY_TYPE : the geometry type for the created layer to pass to the GDAL driver. One of POINT , LINESTRING , POLYGON , MULTIPOINT , MULTILINESTRING , MULTIPOLYGON and GEOMETRY...COLLECTION . LAYER_NAME : assign an alternate name to the new layer LAYER_CREATION_OPTIONS : list of layer creation options to pass to the GD... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/gdal.html
- Spatial Functions 10049
- 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
...rns a single binary BLOB containing the Mapbox Vector Tile. The function has the following signature: ST_AsMVT(row STRUCT, layer_name VARCHAR DEFAULT 'layer', extent INTEGER DEFAULT 4096, geom_column_name VARCHAR DEFAULT NULL, feature_id_column_name V...ULL) -> BLOB The first argument is a struct containing the geometry and properties. The second argument is the name of the layer in the vector tile. This argument is optional and defaults to 'layer' . The third argument is the extent of the tile. This..., max_y:10}::BOX_2D, 5, 42); ST_Read Signature ST_Read (col0 VARCHAR, keep_wkb BOOLEAN, max_batch_size INTEGER, sequential_layer_scan BOOLEAN, layer VARCHAR, sibling_files VARCHAR[], spatial_filter WKB_BLOB, spatial_filter_box BOX_2D, allowed_drivers... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Share a DuckDB Database That Only Stores Views 8458
- A DuckDB database file does not have to contain any data: it can store only view definitions that point at remote data such as Parquet files on object storage. The resulting file is only a few hundred kilobytes, yet it behaves like a shared
...ns, while the underlying data stays in its original location and format. This is useful for publishing a curated “semantic layer” over a data lake, where the view definitions encode the joins, filters, and column names that consumers should use, witho... - https://man.mtool.work/duckdb/2.0/guides/network_cloud_storage/duckdb_views_only...
- Iceberg Options 8350
- This page lists the options of the iceberg extension: the parameters accepted by the Iceberg functions , the options of the ATTACH and CREATE SECRET statements used to connect to a catalog , and the global settings. ATTACH Options To make a
...recated alias ENDPOINT ) or AUTHORIZATION_TYPE . AUTHORIZATION_TYPE VARCHAR OAUTH2 OAUTH2 , SIGV4 , NONE The Authorization layer of the Iceberg Catalog to attach to. Use NONE for catalogs that need no authentication. Endpoint Type For commonly used Ic...ESPACE to true to derive the location from the namespace's location property. Authorization To configure the Authorization layer for connecting to an Iceberg REST Catalog, you'll need to pass the AUTHORIZATION_TYPE parameter. These are the supported o... - https://man.mtool.work/duckdb/2.0/core_extensions/iceberg/iceberg_options.html
- Graph Queries 8241
- DuckDB supports graph queries via the DuckPGQ community extension , which implements the SQL/PGQ syntax from the SQL:2023 standard. Warning DuckPGQ is a community extension and is still under active development. It may not be available for
...']; Creating a Property Graph A property graph consists of vertices (nodes) and edges (relationships). You create one as a layer on top of existing tables: CREATE TABLE Person (id BIGINT, name VARCHAR); CREATE TABLE Knows (person1_id BIGINT, person2_i... - https://man.mtool.work/duckdb/2.0/guides/sql_features/graph_queries.html
- Load Extensions 8043
- 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
...The native HTTPFS extension is not compiled into DuckDB-Wasm, because HTTPS capabilities have to go through an additional layer, the browser, which adds both differences and some restrictions relative to native. Instead, DuckDB-Wasm ships a separate... - https://man.mtool.work/duckdb/2.0/clients/wasm/extensions.html
- ODBC 101: A Duck Themed Guide to ODBC 7844
- What is ODBC? ODBC which stands for Open Database Connectivity, is a standard that allows different programs to talk to different databases including, of course, DuckDB. This makes it easier to build programs that work with many different d
...ver, ODBC can be slower than other methods of connecting to a database, such as using a native driver, as it adds an extra layer of abstraction between the application and the database. Furthermore, because DuckDB is column-based and ODBC is row-based... - https://man.mtool.work/duckdb/2.0/guides/odbc/general.html
- Geometry Data Type 7753
- 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
...ifferent custom binary format used by the spatial extension, but this conversion is performed automatically at the storage layer and is not visible to the execution engine or the user. Shredding and Compression The GEOMETRY type supports a storage opt... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work