shapefile-to-sqlite

shapefile-to-sqlite copied to clipboard

Figure out primary keys and update/alter

6

`geojson-to-sqlite` supports both `--pk=` and `--alter` options. I'm not sure if `--pk` makes sense for Shapefiles - they appear to have a unijque ID property that I could use, but...

simonw

Hello! 👋 Unless I'm missing it (sorry if I am!) I don't think it's currently possible to exclude (or inclusively select) fields/properties on features during a load. My use case...

rdmurphy

Trying to load a shape to an sqlite database with options --spatialite and --spatial-index results in the error spatialite is installed

stuartong

Initialize SpatiaLite without KNN virtual table

4

Now that Homebrew has upgraded SpatiaLite on my laptop to 5.0 this tool seems to be creating databases that aren't compatible with SpatiaLite 4.3.x - which currently breaks `datasette publish`...

simonw