Get help from the marimo community

Updated 6 months ago

Can you load an ESRI shapefile in a marimo sql cell?

At a glance
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
You may need to install and load the spatial extension: https://duckdb.org/docs/extensions/spatial.html
I got that as I had a jpuyter notebook working with duckdb. I have to tweak my code to do it the marimo way.
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