Visitar URL original
Export to GeoPackage does not create a spatial index · Issue #409 · locationtech/geogig · GitHub
Skip to content

Export to GeoPackage does not create a spatial index #409

Open

Description

@MarkusHesse42

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.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

      Milestone

      No milestone

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions