Location History Points

Viewing Location Points in QGIS

Viewing the Location Points created by Excavator in QGIS is quite straightforward. The following steps are done to accomplish this:

• Open the created SQLite database, in this case ichnion.db, into QGIS using the default browser and choose the google_location_history table (this is applicable to the google_location_placevisit and google_location_activity tables as well).

• Once the table has been loaded, open the Processing Toolbox and choose Vector Creation then Create points layer from table.

• In dialog box to create a point layer, set the X to lng and Y to lat fields off the table. Then press Run to create the temporary point layer.

• By this time, the point layer is displayed in the map and can be styled and queried just like any QGIS map layer.