Log in
Log into community
Get help from the marimo community
New post
View all posts
Related posts
Was this helpful?
๐
๐
๐
Powered by
Hall
Inactive
Updated 6 months ago
0
Follow
Can you load an ESRI shapefile in a marimo sql cell?
Question
Can you load an ESRI shapefile in a marimo sql cell?
Inactive
0
Follow
At a glance
h
hubertrum
6 months ago
ยท
I'm getting a ComputerError when i Trey to create a table from an ESRI shaepfile.
CREATE OR REPLACE table piers AS
select *
from './data/in/gis/OneDrive_1_19-08-2024/OutlineGeofence.shp';
This cell raised an exception: ComputeError('datatype [binary data] cannot be written to csv')
A
h
3 comments
Share
Open in Discord
A
Akshay
6 months ago
You may need to install and load the spatial extension:
https://duckdb.org/docs/extensions/spatial.html
h
hubertrum
6 months ago
I got that as I had a jpuyter notebook working with duckdb. I have to tweak my code to do it the marimo way.
h
hubertrum
6 months ago
CREATE OR REPLACE table cells AS
from 's3://cl-ckdelta-production-3uk/processed/cells/active_cells/year=2024/month=7/*.parquet';
select cl_cell_id,ST_GeomFromText(geometry27700) as geometry from cells;
Add a reply
Sign up and join the conversation on Discord
Join on Discord