ST_read with file_search_path

[ericemc3]

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') ;

[zephyring]

👍 any update for this issue?

[ericemc3]

Hi, 👍 any update or explanation for this issue?

[yutannihilation]

(Sorry, I misunderstood the problem. Deleted my comment)

It seems this is difficult to fix. file_search_path is handled in LocalFileSystem::FetchFileWithoutGlob or LocalFileSystem::Glob. So, it might be possible to use this,

https://github.com/duckdb/duckdb/blob/4775cca62dc694519dd78d36f9881568dbe04430/src/common/local_file_system.cpp#L1353-L1371

however..., IIUC, ST_Read can take may other types of data source than a local filesystem, so these cannot be blindly applied to the input.

https://github.com/duckdb/duckdb-spatial/blob/f0bfd0d4a10cbd74250c91211fd04913d25064fc/src/spatial/modules/gdal/gdal_module.cpp#L572-L574

[zephyring]

FWIW I just migrated to use read_xlsx() as of duckdb1.2

[ericemc3]

FWIW I just migrated to use read_xlsx() as of duckdb1.2

This isn't about Excel, but rather GTFS or GIS formats in general, for which st_read is essential...