Results of 1 - 3 of about 3 for geomfromgeojson (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
...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
...a geometry 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...ut geometry has neither a Z or M component, the new Z and M values will be added to the vertices of the input geometry. ST_GeomFromGeoJSON Signatures GEOMETRY ST_GeomFromGeoJSON (geojson JSON) GEOMETRY ST_GeomFromGeoJSON (geojson VARCHAR) Description Deserializ...es a GEOMETRY from a GeoJSON fragment. Example SELECT ST_GeomFromGeoJSON('{"type":"Point","coordinates":[1.0,2.0]}'); ---- POINT (1 2) ST_GeomFromHEXEWKB Signature GEOMETRY ST_GeomFromHEXEWKB (he... - 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
...'features.geojson', geojson := 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