What to do now… One option is to load the ‘mod_spatialite.dll’ from the QGIS bin directory again from menu Tools –> Load Extension… Although we don’t have a SpatiaLite database but a GeoPackage, what will happen? When using a spatial function we get the error again about missing function (no such function) This was expected as a GeoPackage is a regular SQLite database. In DB Browser for SQLite, counting the number of records works. We start again by downloading the GeoJSON file of Ukraine districts, Ĭonvert to GeoPackage using ogr2ogr: $ ogr2ogr -f gpkg ukraine.gpkg Ukraine.jsonįirst observation: The GeoPackage is much smaller:Īnother difference: The default geometry column name is ‘geometry’ in case of SpatiaLite, ‘geom’ in case of GeoPackage.įor visualizing in QGIS there is an option ‘GeoPackage’ in the browser: So let’s do the exercise again, we’ll download some spatial data, create a GeoPackage and see how we can use it in QGIS and DB Browser for SQLite. For more information about GeoPackage see ![]() This standard is developed by the Open Geospatial Consortium (OGC). More recently (2014) there was another initiative to store spatial data in a SQLite: GeoPackage (GPKG). The initial release of SpatiaLite was in 2008, nowadays it’s used in many software packages (see ). This book is licensed under the Creative Commons Attribution-ShareAlike 4.0 International license.In yesterday’s article ( ), we investigated SpatiaLite and how to use spatial functionality in DB Browser for SQLite.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |