Sqlite Data Starter Packs Link -

Here is some content on SQLite data starter packs and links:

Best for:

Maps, location services, or JSON testing. Did you know you can download the entire OpenStreetMap PBF data as a single SQLite file? There are tools to convert it, but pre-made SQLite databases of major cities (NYC, London, Tokyo) exist with millions of latitude/longitude points. sqlite data starter packs link

• File copy when DB is closed: copy notes.db
• Online backup while DB in use (sqlite3 CLI):

  .backup backup_notes.db
  

• Export schema and data SQL:

  .output dump.sql
  .dump
  .exit
  

• Import:

  sqlite3 new.db < dump.sql
  

3. Real-World Geographic Data (GeoNames)