Visualizing the Data

Creating Thematic Maps with Takeout's Location Data

As mentioned in previous wikis, once the SQLite's tables created by the Excavator is added as a QGIS' map layer, the data can be viewed and styled just like any other regular QGIS layer.

It is interesting to note though that by using the different attribute data that Google provides with the Takeout, it is possible to create Thematic Maps from the location data to provide more insight on the information given.

As an example, a Categorized Thematic Map can be created using the google_location_activitysegment found in the Semantic data that Google provides. Here, the day_of_week() Date function is used on the start_timestamp attribute of the activity segment Linestring.

To do this, the following can be done:

• select and double click the activitysegment layer to display the Layer Properties dialog screen.
• select Categorized at the top most pull down menu.
• for the value, set to day_of_week( start_timestamp ). NOTE there are other Date/Time functions QGIS provides that can be used on the timestamp data.
• press the classify button to create the classification.
• the Legend of the created classifications can be edited to provide a more descriptive item.

Once done, the thematic map should display. The different categories can be turned on or off to show the paths taken for each day of the week.