Load shapefiles into a SQLite (optionally SpatiaLite) database
Project description
shapefile-to-sqlite
Load shapefiles into a SQLite (optionally SpatiaLite) database.
How to install
$ pip install shapefile-to-sqlite
How to use
You can run this tool against a shapefile file like so:
$ shapefile-to-sqlite my.db features.shp
This will load the geometries as GeoJSON in a text column.
Using with SpatiaLite
If you have SpatiaLite available you can load them as SpatiaLite geometries like this:
$ shapefile-to-sqlite my.db features.shp --spatialite
The data will be loaded into a table called features
- based on the name of the shapefile. You can specify an alternative table name using --table
:
$ shapefile-to-sqlite my.db features.shp --table=places
The tool will search for the SpatiaLite module in the following locations:
/usr/lib/x86_64-linux-gnu/mod_spatialite.so
/usr/local/lib/mod_spatialite.dylib
If you have installed the module in another location, you can use the --spatialite_mod=xxx
option to specify where:
$ shapefile-to-sqlite my.db features.shp \
--spatialite_mod=/usr/lib/mod_spatialite.dylib
Projections
By default, this tool will attempt to convert geometries in the shapefile to the WGS 84 projection, for best conformance with the GeoJSON specification.
If you want it to leave the data in whatever projection was used by the shapefile, use the --crs=keep
option.
You can convert the data to another output projection by passing it to the --crs
option. For example, to convert to EPSG:2227 (California zone 3) use --crs=espg:2227
.
The full list of formats accepted by the --crs
option is documented here.
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distributions
Built Distribution
Hashes for shapefile_to_sqlite-0.2-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | cd24f7b62583774994093a31de1e6ec4f3933659840dfea140f02015009ecf71 |
|
MD5 | fccf046dfae1559fc75d942130bc887d |
|
BLAKE2b-256 | eee5ef945558afb91688452eba5635627c43e211165d7b245c56c445adc1c38d |