Bug report #17867

Strange (Geopackage?) behaviour

Added by Richard Duivenvoorde almost 7 years ago. Updated over 5 years ago.

Status:Feedback
Priority:Normal
Assignee:-
Category:Map Canvas
Affected QGIS version:master Regression?:No
Operating System: Easy fix?:No
Pull Request or Patch supplied:No Resolution:
Crashes QGIS or corrupts data:No Copied to github as #:25762

Description

See https://gis.stackexchange.com/questions/267642/missing-a-feature-after-digitalization-of-a-geopackage-vector-in-qgis

Attached Geopackage has 3 features, epsg:3006

When you zoom out you see the third (newly digitized) one in the Mapcanvas
But zooming in it vanishes.

In attribute table you can always see it, can even copy paste it from there:

wkt_geom    fid    Id    river    reach
LineString (540748.95155992545187473 6445081.75009414739906788, 540770.64956660254392773 6445291.18302816152572632, 540754.61190949333831668 6445435.52194214425981045, 540731.02711962687317282 6445495.89900420233607292, 540680.0839735153131187 6445643.06809296924620867, 540654.65020835073664784 6445727.73851544689387083)    3    3    Stangan    upstream

If you instruct QGIS to copy/paste geojson:

{ "type": "FeatureCollection",
    "features":[
{
   "type":"Feature",
   "id":3,
   "bbox":[15.690706, 58.145171, 15.6926, 58.150981],
   "geometry":
   {"type": "LineString", "coordinates": [ [15.692195, 58.145171], [15.6926, 58.14705], [15.692353, 58.148348], [15.691963, 58.148892], [15.691123, 58.150219], [15.690706, 58.150981]]},
   "properties":{
      "fid":3,
      "Id":3,
      "river":"Stangan",
      "reach":"upstream" 
   }
}
]}

And then it is a valid geometry to, for example paste it to http://geojson.io to view it.

Coordinates seem fine.

But you cannot select it in QGIS either???

RverReaches.gpkg (116 KB) Richard Duivenvoorde, 2018-01-16 01:19 PM

History

#1 Updated by Richard Duivenvoorde almost 7 years ago

Other observation: if you save the gpkg as an Esri Shapefile, and load it in QGIS it behaves perfectly normal...

#2 Updated by Jérôme Guélat almost 7 years ago

Everything seems to be OK if you save the GeoPackage as a new GeoPackage... Maybe there's a problem with the spatial index (see #16154)

#3 Updated by Johannes Kroeger over 6 years ago

I dropped the index from the file via SQLite and afterwards it displayed fine in QGIS. So another vote that this is a bad spatial index in the file and not a QGIS bug.

#4 Updated by Giovanni Manghi over 5 years ago

  • Status changed from Open to Feedback

Please check if this issue is still valid on QGIS 3.4.5 or 3.6.

Also available in: Atom PDF