-
Notifications
You must be signed in to change notification settings - Fork 0
Location History Activity Segments
Mario Martin Basa edited this page Dec 28, 2023
·
2 revisions
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 thegoogle_location_activitysegment
table. -
Once the table has been loaded, open the Processing Toolbox and choose
Vector Geometry
thenGeometry By Expression
.

- In the dialog box, set the
Output geometry type
toLine
, and set theGeometry expression
togeom_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.
