Results of 1 - 4 of about 4 for geom (0.002 sec.)
- Spatial Functions 12223
- 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
...OJ library 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 ellipsoid...al model of the earth ST_AsGeoJSON Returns the geometry as a GeoJSON fragment ST_AsHEXWKB Returns the geometry as a HEXWKB string ST_AsMVTGeom Transform and clip geometry to...a tile boundary ST_AsSVG Convert the geometry into a SVG fragment or path ST_AsText Returns the geometry as a WKT string ST_AsWKB Returns the geometry as a WKB (Wel... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- R-Tree Indexes 9135
- 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
...e Indexes Work? An R-tree is a balanced tree data structure that stores the approximate minimum bounding rectangle of each geometry (and the internal ID of the corresponding row) in the leaf nodes, and the bounding rectangle enclosing all of the chil...d nodes in each internal node. The minimum bounding rectangle (MBR) of a geometry is the smallest rectangle that completely encloses the geometry. Usually when we talk about the bounding rectangle of...a geometry (or the bounding "box" in the context of 2D geometry), we mean the minimum bounding rectangle. Additionally, we tend t... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/r-tree_indexes.html
- Geometry Data Type 8358
- 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
...n DuckDB 1.5. Most of the benefits of having GEOMETRY as a built-in type (e.g., storage optimizations, statistics, etc.) are therefore only available in databases using sto...rage version 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, th...e GEOMETRY type follows the core data model defined in the Simple Features standard, which is widely used in geospatial databases... - https://man.mtool.work/duckdb/2.0/sql/data_types/geometry.html
- Writing JSON 7230
- 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
...tion . FORMAT GEOJSONL (or ARRAY true with FORMAT GEOJSON ) 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 GEO...JSON); COPY (SELECT 'POINT(0 1)'::GEOMETRY AS geom, 10 AS my_field) TO 'test.jsonl' (FORMAT GEOJSONL); Optional ID_COLUMN and GEOMETRY_COLUMN pick which columns...become the Feature id and geometry. st_asgeojson / st_geomfromgeojson convert a single value. Reading GeoJSON is documented on the Loading JSON page.... - https://man.mtool.work/duckdb/2.0/data/json/writing_json.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work