Treksoft Surveys

Context

Treksoft (now Polygon) is the company in charge of collecting data via three online questionnaires (eligibility, health & VERITAS). The data is stored on their server in JSON format wrapped into a session object.

Migration

At the end of each city/wave campaign, a SQL dump of the MySQL database managed by Treksoft is done. This dump, once cleaned up to remove any incompatible items, is restored into our pg database on Compute Canada.

Data transformation

All the transformations going on over the raw Treksoft data to extract the INTERACT variables is documented in the private Github repo treksoft_import. The variables themselves are documented in the online data dictionary published on the INTERACT team web site.

Essence table

In order to serve users a streamlined version of the Treksoft data, a subset of the INTERACT variables have been grouped into a data set called essence table, which also includes a series of derived variables. The repo documenting the production of this resource is available at essence_table.