Statistician, map-maker, dataviz consultant and trainer, Observable ambassador & R instructor. I enjoy explaining things i love in detail, the most clearly i can, and building live analytical opendataflows.
@ericmauviere
arrow_table = {
await db.registerFileHandle(geofile.name, geofile, duckdb.DuckDBDataProtocol.BROWSER_FILEREADER, true)
const parquet = /\.(geo|)parquet$/.test(geofile.name) //.parquet or .geoparquet
const connection = await db.connect()
await connection.query(`INSTALL spatial; LOAD spatial;`)
const q = (parquet ? `FROM read_parquet('${geofile.name}')` :
`FROM st_read('${geofile.name}')`)
+ ` SELECT * REPLACE(ST_AsGeoJSON(geometry) AS geometry)`
const arrowResult = await connection.query(q)
await connection.close()
return arrowResult // table au format arrow
}
geo = {
const arrow_ds = arrow_table.toArray()
return {
"type": "FeatureCollection",
"features": arrow_ds.map(
({geom, ...rest}) => Object.assign( {},
{type: "Feature", geometry: JSON.parse(geom), properties: {...rest}} )
)
}
}
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
