Location History Activity Segments

Viewing Location Activity Segments in QGIS

Viewing the Location Activity Segments (Lines) created by Excavator in QGIS is quite straightforward, especially since a Well Known Text (WKT) LINESTRING has been created and saved into the Segments table. The following steps are done to accomplish this:

• Open the created SQLite database, in this case ichnion.db, into QGIS using the default file browser and choose the google_location_activitysegment table.

• Once the table has been loaded, open the Processing Toolbox and choose Vector Geometry then Geometry By Expression.

• In the dialog box, set the Output geometry type to Line, and set the Geometry expression to geom_from_wkt(wkt). Finally, press the Run button to create the temporary Line layer.

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