Sign In Start Free Trial
Account

Add to playlist

Create a Playlist

Modal Close icon
You need to login to use this feature.
  • Book Overview & Buying Mastering QGIS
  • Table Of Contents Toc
Mastering QGIS

Mastering QGIS

By : Kurt Menke, GISP
4.6 (12)
close
close
Mastering QGIS

Mastering QGIS

4.6 (12)
By: Kurt Menke, GISP

Overview of this book

If you are a GIS professional, a consultant, a student, or perhaps a fast learner who wants to go beyond the basics of QGIS, then this book is for you. It will prepare you to realize the full potential of QGIS.
Table of Contents (12 chapters)
close
close
11
Index

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. Expand SpatiaLite and select GiffordPinochet.sqlite on the Tree panel.
  2. Navigate to Table | Import layer/file to open the Import vector layer dialog.
  3. Click on the ellipsis button at the right-hand side of the Input drop-down box and select...
CONTINUE READING
83
Tech Concepts
36
Programming languages
73
Tech Tools
Icon Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.
Icon Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.
Icon 50+ new titles added per month and exclusive early access to books as they are being written.
Mastering QGIS
notes
bookmark Notes and Bookmarks search Search in title playlist Add to playlist font-size Font size

Change the font size

margin-width Margin width

Change margin width

day-mode Day/Sepia/Night Modes

Change background colour

Close icon Search
Country selected

Close icon Your notes and bookmarks

Confirmation

Modal Close icon
claim successful

Buy this book with your credits?

Modal Close icon
Are you sure you want to buy this book with one of your credits?
Close
YES, BUY

Submit Your Feedback

Modal Close icon
Modal Close icon
Modal Close icon