Results of 1 - 3 of about 3 for asgeojson (0.002 sec.)
- Writing JSON 11366
- 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
...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
- Spatial Functions 9673
- 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
...area 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...Returns 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...this function. This function supports geometries with Z values, but not M values. M values are ignored. Example select ST_AsGeoJSON('POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))'::geometry); ---- {"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,1.0],[1.0,1.0],[1.0... - https://man.mtool.work/duckdb/2.0/core_extensions/spatial/functions.html
- Loading JSON 6845
- 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
...eojson := true); .geojson / .geojsonl files are also recognized as JSON replacements. Convert with st_geomfromgeojson / st_asgeojson . Writing FeatureCollections is documented on the Writing JSON page.... - https://man.mtool.work/duckdb/2.0/data/json/loading_json.html
PREV
1
NEXT
DuckDB 2.0 Documentation / man.mtool.work