Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Unable to add GeoParquet data from remote source to map #2962

Open
shish023 opened this issue Jan 29, 2025 · 1 comment
Open

Unable to add GeoParquet data from remote source to map #2962

shish023 opened this issue Jan 29, 2025 · 1 comment
Assignees
Labels
bug Something isn't working DuckDB

Comments

@shish023
Copy link

Describe the bug
GeoParquet data hosted at https://data.source.coop/fiboa/us-ca-scm/us_ca_scm.parquet can be loaded into DuckDB but not added to the map. When Add to Map is clicked, Loading... appears on screen but the data doesn't get added to the map.

To Reproduce
Steps to reproduce the behavior:

  1. Run this query in the SQL panel: select * from read_parquet("https://data.source.coop/fiboa/us-ca-scm/us_ca_scm.parquet") limit 100. Data can be seen in the form of a table
  2. Click on Add to Map
  3. Notice that Loading... appears but data is not added to the map

Expected behavior
The geometry in the loaded data should appear on the map.

Screenshots

Image

Additional context
LinkedIn Comment

@shish023 shish023 added the bug Something isn't working label Jan 29, 2025
@igorDykhta igorDykhta self-assigned this Jan 29, 2025
@igorDykhta
Copy link
Collaborator

The workaround for now is to use st_aswkb

SELECT st_aswkb(geometry) as geometry, id FROM read_parquet( ...

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug Something isn't working DuckDB
Projects
None yet
Development

No branches or pull requests

2 participants