For those interested, I have started a repository today with.
- expanded explanation of specific Spatialite-Sql commands
- combination of Commands to perform certain Tasks
- What to do to resolve certain problems
https://github.com/mj10777/Spatialite-Tasks-with-Sql-Scripts/wiki/_pagesThis is an on going effort due to a project I am presently working on
- most of these commands tend to be complicated and I have been collecting them for future reference
In time a guide on how to create Spatial-Views and general designing tips for Database that are to be used with geopaparazzi will be added.
If there is a general interest and Andrea has no objection, I would like to move this to the main Geopaparazzi Repository as an extra Repository
- where Spatialite specific Information can be collected and referenced to
There also Sql-Scripts and how to use them could be stored
- importing a Shape-File into a Database etc.
Mark Johnson