Other visualization

In order to view and use the extracted data placed into a SQLite database file when the extraction process was executed, the DB Browser for SQLite (available in the Mac App Store) desktop application can be used. With it all the past activities stored by Google, Twitter, and Facebook can be browsed and reviewed by moving into the Browse Data tab and choosing the desired table.

To view and analyze the extracted Location Information from the different services, the GIS desktop application QGIS (available in Homebrew for Macs) can also be used. The loaction table in SQLite has to be converted first into a CSV file using the DB Browser in order for QGIS to be able to create a Map Layer from the data.

Once the CSV file from the location table has been created, the data can be viewed in QGIS by doing Layer -> Add Layer -> Add Vector Layer .

Then choose the Delimited Text option and enter the CSV filename. Afterwards, chooce Point Coordinates and set the X field to lng and the Y field to lat column names of the CSV file.

Once the required information has been entered, QGIS should now be able to visualize the location information in a map.