duckdb / duckdb/duckdb-spatial

wasm vsizip option

Open
#754 0 comments 0 reactions 0 assignees View on GitHub
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.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.