ericemc3

[buffer1_g.json](https://github.com/user-attachments/files/16118821/buffer1_g.json) [buffer2_g.json](https://github.com/user-attachments/files/16118823/buffer2_g.json) [buffer3_g.json](https://github.com/user-attachments/files/16118822/buffer3_g.json) These are 3 buffers around river Garonne (1000, 2000 and 3000 meters). I want to get H3 cells for these buffers. ``` FROM st_read('buffer2_g.json') SELECT geom.h3_polygon_wkt_to_cells(8); ```...

J'ai lu avec beaucoup d'intérêt la fiche détaillée sur l'utilisation de DuckDB dans R (https://book.utilitr.org/03_Fiches_thematiques/Fiche_duckdb.html). Je pense qu'elle donne beaucoup de clés pratiques. Voici quelques remarques et suggestions. "Il est...

ST_read with file_search_path

5

Starting from: `FROM st_read('c:/apps/datasets/IDFM-gtfs.zip', layer = 'routes')` It would be great and consistent that this could work: ``` SET file_search_path = 'c:/apps/datasets' ; FROM st_read('IDFM-gtfs.zip', layer = 'routes') ; ```

DBeaver cannot display geometries anymore with 1.2.2 release

1

`SELECT 'POLYGON((0 0, 0 1, 1 1, 1 0, 0 0))'::GEOMETRY;` ->  works fine with 1.2.1:  I am using current DBeaver version (25.0.2).

st_read() error on a geojson API

3

``` load spatial ; load httpfs; FROM st_read('https://geo.api.gouv.fr/communes?codePostal=31140&geometry=contour&format=geojson'); ``` GDAL Error (4): `https://geo.api.gouv.fr/communes?codePostal=31140&geometry=contour&format=geojson' not recognized as a supported file format. But it works well on the duckdb wasm shell: https://tinyurl.com/2p4wuvad...

La doc de présentation stipule 'nested'

SVG export with attributes described as SVG, not as inline styles

4

Many softwares cannot properly import SVG files with SVG inline styles (such as transform for instance). Would it be possible to avoid inline styles with the SVG export?

Error reading JSON API

6

### What happens? I have trouble reading a JSON stream via https. If i save that stream in a local file, it works fine. ### To Reproduce `FROM read_json('https://geomsa.msa.fr/GC_indic.php?indic=diag_emploi_sa&dataset=emploi_etp_diag&view=map7&filters=annee=2022');` `SQL...

SET force_download = true in error

6

### What happens? with shell.duckdb.org ``` INTERNAL Error: Invalid PhysicalType for GetTypeIdSize This error signals an assertion failure within DuckDB. This usually occurs due to unexpected conditions or errors in...

### What happens? I get an error message ### To Reproduce ``` FORCE INSTALL postgres FROM core_nightly; LOAD postgres; CREATE OR REPLACE SECRET ( TYPE postgres, PASSFILE 'C:\...\.pgpass' ) ;...