Results of 1 - 6 of about 6 for GeoJSON (0.002 sec.)
- Writing JSON 12448
- 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
...h the following content: {"name":"Amsterdam","id":1} {"name":"London","id":2} See the COPY statement for more information. GeoJSON New This feature was introduced in DuckDB 2.0. COPY ... (FORMAT GEOJSON) writes a GeoJSON FeatureCollection . FORMAT GEOJS...ONL (or ARRAY true with FORMAT GEOJSON ) writes newline-delimited Feature objects. You do not need json_geometry_format for these copy formats. COPY (SELECT 'POI...NT(0 1)'::GEOMETRY AS geom, 10 AS my_field) TO 'test.json' (FORMAT GEOJSON); COPY (SELECT 'POINT(0 1)'::GEOMETRY AS geom, 10 AS my_field) TO 'test.jsonl' (FORMAT GEOJSONL); Optional ID_COLUMN and G... - https://man.mtool.work/duckdb/2.0/data/json/writing_json.html
- Loading JSON 9889
- The DuckDB JSON reader can automatically infer which configuration flags to use by analyzing the JSON file. This will work correctly in most situations, and should be the first option attempted. In rare situations where the JSON reader cann
...object is less than this threshold, it will default to using a MAP type with value type of merged field types. DOUBLE 0.1 geojson When true , parse GeoJSON geometry objects as GEOMETRY instead of JSON / STRUCT . Stray GeoJSON fragments in ordinary JSON...(AUTO_DETECT true); We can also create a table from the auto-detected schema: CREATE TABLE numbers AS FROM 'numbers.json'; GeoJSON New This feature was introduced in DuckDB 2.0. The json extension can read GeoJSON when you opt in. Pass geojson := true t...ead_json so geometry objects become GEOMETRY (the spatial type) instead of generic JSON: SELECT * FROM read_json('features.geojson', geojson := true); .geojson / .geojsonl files are also recognized as JSON replacements. Convert with st_geomfromgeojson /... - https://man.mtool.work/duckdb/2.0/data/json/loading_json.html
- GDAL Integration 9505
- 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
...ckDB tables to different geospatial vector formats through a GDAL based COPY function. For example, to export a table to a GeoJSON file, with generated bounding boxes, you can use the following query: COPY ⟨table⟩ TO 'some/file/path/filename.geojson' WI...TH (FORMAT gdal, DRIVER 'GeoJSON', LAYER_CREATION_OPTIONS ('WRITE_BBOX=YES', 'DESCRIPTION=a sample geojson'), SRS 'EPSG:4326'); Available options: FORMAT :... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/gdal.html
- Spatial Functions 8609
- 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
...rea of a geometry. ST_Area_Spheroid Returns the area of a geometry in meters, using an ellipsoidal 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...try to have X, Y and Z components ST_Force4D Forces the vertices of a geometry to have X, Y, Z and M components ST_GeomFromGeoJSON Deserializes a GEOMETRY from a GeoJSON fragment. ST_GeomFromHEXEWKB Deserialize a GEOMETRY from a HEX(E)WKB encoded string...eturns 0.0 for any geometry that is not a POLYGON , MULTIPOLYGON or GEOMETRYCOLLECTION containing polygon geometries. ST_AsGeoJSON Signature JSON ST_AsGeoJSON (geom GEOMETRY) Description Returns the geometry as a GeoJSON fragment This does not return a... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- What's New in the Docs for 2.0 7622
- 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
...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 The PARTITION_PATH copy option for comput... - https://man.mtool.work/duckdb/2.0/whats_new_in_the_docs.html
- Configuration 6726
- 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
...oint division. BOOLEAN false json_geometry_format How GEOMETRY values are written to JSON : 'wkt' for Well-Known Text, or 'geojson' for Geo JSON geometry objects. COPY ... TO ... (FORMAT GEO JSON ) always writes Geo JSON regardless of this setting. VARC... - https://man.mtool.work/duckdb/2.0/configuration/overview.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work