I want to annotate a line on a map and have it persisted:
At the current moment, I believe there are "start"/"end" and "point" columns? I additionally propose a "geometry" column (if there isn't one yet, this seems to suggest there is partial support for it)?
Since I don't think SQLite natively supports geometry, I imagine the we could utilize to_wkt (well-known-text) to store the data as string type, and from_wkt to serialize back the geometry, like I did here for MapnStreets since Parquet also doesn't natively support geometry.
I am happy to help implement this if the plan is agreed on.
I want to annotate a line on a map and have it persisted:
At the current moment, I believe there are "start"/"end" and "point" columns? I additionally propose a "geometry" column (if there isn't one yet, this seems to suggest there is partial support for it)?
Since I don't think SQLite natively supports geometry, I imagine the we could utilize
to_wkt(well-known-text) to store the data as string type, andfrom_wktto serialize back the geometry, like I did here for MapnStreets since Parquet also doesn't natively support geometry.I am happy to help implement this if the plan is agreed on.