duckdb / duckdb/duckdb-spatial
wasm vsizip option
- Dominant language
- C
- Stars
- 708
- Forks
- 96
- Avg merge
- 1d 21h
- Merged PRs (30d)
- 5
Description
so I tried the following in shell and it seems `viszip` does not work well
```
.files add a.zip -- add your zip file containing shape file
INSTALL spatial;
LOAD spatial;
duckdb> .files
│ File Name ┆ File Size ┆ Protocol ┆ Statistics │
│ cb_2018_us_aiannh_500k.zip ┆ 1.46 MB ┆ Http ┆ false │
db> SELECT * FROM ST_Read('/vsizip/cb_2018_us_aiannh_500k.zip/cb_2018_us_aiannh_500k.shp') limit 10
...> ;
IO Error: GDAL Error (4): `/vsizip/cb_2018_us_aiannh_500k.zip/cb_2018_us_aiannh_500k.shp' does not exist in the file system, and is not recognized as a supported dataset name.
LINE 1: SELECT * FROM ST_Read('/vsizip/cb_2018_us_aiannh_500k.zip/cb_2018_us_aian...
^
-- Now install zip
INSTALL zipfs FROM community;
LOAD zipfs;
FROM st_read('zip://cb_2018_us_aiannh_500k.zip/cb_2018_us_aiannh_500k.shp') limit 1; --this works
```
is there any workarounds to make this work without need to unzip file?
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.