How To SpatiaLite

What is Spatialite:

Before you begin, you should create a folder and label it as SpatiaLite Tutorial. Then, you should download and save all the water files (that you can find on the bottom of the page) to the SpatiaLite Tutorial folder.

  1. Open QGIS and add a Vector Layer of your choice. If you don't have one, I have already attached a water.shp (shape file) on this page for you to use.
  2. Once you added a Vector Layer (water.shp) to QGIS, it should look like this.
    Screen%20Shot%202014-02-08%20at%204.34.07%20PM.png
  3. Now, you should left click on the water.shp file in the legend. Then, click on Save As and a window called Save vector layer as… should appear.
    Screen%20Shot%202014-02-08%20at%204.46.01%20PM.png
  4. You should change the Format from ESRI Shapefile to SpatiaLite and click the OK button.
  5. In changing the Format, your previous water.shp file combined with other existing files (.dbf, .prj, .qpj and .shx) into one file that is now called a SpatiaLite Layer consisting a file ending with .sqlite.
Screen%20Shot%202014-02-08%20at%205.03.59%20PM.jpeg —> MillsSQL.png

Notes/Delete stuff below

If you are having trouble finding it in the legend, you may go to the top of the page and click on Layers and find Add Spatialite Layer, image. Go ahead and click on the button.
A window called Add SpatiaLite Table(s) should appear. /Users/phuongtseng/Desktop/Screen Shot 2014-02-08 at 4.40.12 PM.png

Some Sample Data here: http://geocommons.com/overlays/16346

Created by Heather
Edited by Phuong T.