The avatar for @abenrob
Adam Roberts
Published
Spatialite
Edited
Jul 13, 2022
1 fork
9 stars
2
Insert cell
Insert cell
Insert cell
// data provided by city of Grenoble, 2022. CSV converted directly to spatailite DB without modifications
sql = FileAttachment("lights@1.sqlite").sqlite()
Insert cell
sql
select * from lights;
Insert cell
Insert cell
Insert cell
Insert cell
dbsrc = FileAttachment("lights@1.sqlite").arrayBuffer()
Insert cell
Insert cell
db = spl.db(dbsrc)
Insert cell
Insert cell
Insert cell
lights = (await db.exec(GeoJSONQuery).get.objs).reduce(
(obj, item) => {
obj.features.push(item);
return obj;
},
{ type: "FeatureCollection", features: [] }
)
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
spl = SPL.default()
Insert cell
Insert cell

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.
Learn more