Hi, 2016-03-21 17:33 GMT+01:00 Frederik Ramm <frede...@remote.org>: > I'm not sure if Geopackage has significant performance improvements over > simple Spatialite but if it hasn't then my recommendation for simple GIS > processing is certainly to stick with shape files for the time being - > despite all their shortcomings.
Shapefiles, Spatialite and GeoPackage all use R-tree indexes. I never heard about performance advantages of Shapefiles (except a bug in a former Spatialite driver). Can you tell me a use case? Which Spatialite SW are you using? What people need to realize is, that Shapefiles really have issues: 1. Attribute name length restricted to 10 chars => resulting in information loss. 2. Strings length restricted to 255 chars => resulting in information loss. 3. No Multi LineString/Multi Polygon => resulting in information loss. 4. Max. file size restricted to 2GB => resulting in splitting tables into several files. 5. Several cluttered files => makes users forget to include all. :Stefan 2016-03-21 17:33 GMT+01:00 Frederik Ramm <frede...@remote.org>: > Hi, > > On 03/20/2016 10:56 PM, Stefan Keller wrote: >> But Shapefile remains an oldtimer with more drawbacks than limited >> field names; see [1]. >> GeoJSON (ascii) and GeoPackages (binary) are formats which are more >> suited for the job. >> I still have hope that JOSM will be able to read those vector formats too. > > Frankly, whenever I venture into the brave new world of Spatialite, I > come back to good old shape files after a while for performance reasons. > I'm not sure if Geopackage has significant performance improvements over > simple Spatialite but if it hasn't then my recommendation for simple GIS > processing is certainly to stick with shape files for the time being - > despite all their shortcomings. > > Bye > Frederik > > -- > Frederik Ramm ## eMail frede...@remote.org ## N49°00'09" E008°23'33" > > _______________________________________________ > talk mailing list > talk@openstreetmap.org > https://lists.openstreetmap.org/listinfo/talk _______________________________________________ talk mailing list talk@openstreetmap.org https://lists.openstreetmap.org/listinfo/talk
