Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Export to GeoPackage does not create a spatial index #409

Open
MarkusHesse42 opened this issue Nov 23, 2017 · 0 comments
Open

Export to GeoPackage does not create a spatial index #409

MarkusHesse42 opened this issue Nov 23, 2017 · 0 comments

Comments

@MarkusHesse42
Copy link

When data are exported to Geopackage from geogig repository e.g. by

geogig geopkg export -i test_data test_data

the resulting database does not contain a spacial index, i.e. the tables "rtree..." are missing. When I do an export from e.g. postgres to GeoPackage with ogr2ogr the index tables do exist. Something like this:

set PG_TEXT="host=localhost user=postgres dbname=XXX password=XXX"
ogr2ogr -f GPKG test_data.gpkg PG:%PG_TEXT% "ga.test_data"

Eventually the problem is, that GeoPackages without spacial index seem to lead to problems in QGis. When I load three or four medium sized GeoPackages (about 100.000 to 200.000 features) in QGis, it is no more possible to edit any of them. If I use instead GeoPackages created via org2ogr (i.e with spatial index), this works.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant