Cleanup: Make the SQL statements more readable
The series of SQL statements in the create_tables
function for SpatiaLite databases is rather difficult to read. It would be better to join all SQL statements for one table, its spatial field and indices into one long string and execute this using the executescript()
function. Not only would the code be more readable but also shorter.