O'Reilly logo

Mastering QGIS by GISP Dr. John Van Hoesen, GISP Dr. Richard Smith Jr., GISP Kurt Menke, Dr. Luigi Pirelli

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Importing data into a SpatiaLite database

Importing data into a SpatiaLite database is easy using the DB Manager. SpatiaLite supports the following formats for importing files:

  • Shapefile (.shp)
  • Dbase (.dbf)
  • Text (.txt), Commas Separate Values (.csv), and Excel spreadsheets (.xls)
  • Well-known Text (.wkt) and Well-known Binary (.wkb)
  • PostGIS (.ewkt / .ewkb)
  • Geography Markup Language (.gml)
  • Keyhole Markup Language (.kml)
  • Geometry JavaScript Object Notation (.geojson)
  • Scalable Vector Graphics (.svg)

Let's use DB Manager to import data in a few different formats into our GiffordPinochet.sqlite database.

Importing KML into SpatiaLite

To import a KML file into a SpatiaLite database, complete the following steps:

  1. Open DB Manager by clicking on DB Manager under Database ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required