Marcus Blake <marcusthemapmaker@...> writes: ...
> Things that do not work... > > 1. QGIS is not displaying the Attribute Table of a GeoPackage view correctly. Attribute values are repeated for a single row. > 2. Any Select operation that is applied either to the attributes or the geometries results in the whole layer being selected. > > In summary it looks like whilst the geometries of a GeoPackage view are being interpreted correctly the link to the underlying attributes in a view is not. Incidentally, neither the latest version of ArcGIS or MapInfo Profession can interpret views in GeoPackage either and this has been identified as a bug by both organisations. > > Any help from some one who knows their way around how GeoPackage is interpreting views would be gratefully received. I made some quick tests by making queries directly with SQL from spatialite-gui SELECT * FROM "sa1_b01_map_v" order by SA1_MAINCODE_2011 limit 100; Looks good with no duplicates. select * from "sa1_b01_map_v" where SA1_7DIGITCODE_2011=1135752; One row returned. You should give more detailed examples about what you do, what you get, and what is the expected result. -Jukka Rahkonen- > Marcus. > > > _______________________________________________ > Qgis-user mailing list > Qgis-user <at> lists.osgeo.org > List info: http://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user _______________________________________________ Qgis-user mailing list [email protected] List info: http://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: http://lists.osgeo.org/mailman/listinfo/qgis-user
