The “raw” position data used to draw SomnoPose charts can be exported in CSV (comma-separated value) format, which can then be directly loaded into many spreadsheet, data analysis, and database applications.
To export data, go to the Charts view and tap the chart to show the toolbar at the bottom:
The action button will bring up a menu that includes several data-export items:
The "Use data" items will present options for exporting data in various ways, including options to use AirDrop, or pass the data to selected apps (such as Mail or Notes).
The "Email data" items may be omitted if email is not fully set up on your device. These items will create and show an email message with the data as an attachment. You will need to fill in recipient addresses, and you can edit the email subject and body (for example, to add notes) before sending the message.
Data for one eight-hour chart will involve over 14,000 samples (about one every two seconds), so it may take a noticeable time for SomnoPose to prepare the data, depending on the speed of your device (and especially if you are using all your data, collected over many sessions). Lengthy preparation will be indicated by a progress bar overlaid on the chart. You can cancel the email by swiping right over the progress-bar view and tapping the resulting Cancel email button. (The button can instead be dismissed by double-tapping the progress-bar view.)
The exported CSV data files contain five columns, but all the essential data is in the first three columns, with the last two columns providing optional time and date information in a more human-readable form.
Here is a very short example of the beginning of a SomnoPose CSV file:
Timestamp,Orientation,Inclination,Time_of_day,Date 329027337.43,121.85,78.30,23:28:57, 329027339.44,114.51,84.75,23:28:59, 329027341.44,131.99,93.92,23:29:01,2011-06-05 329027343.45,118.25,80.36,23:29:03, 329027345.46,114.47,80.18,23:29:05,
The data rows are ordered chronologically, with the earliest samples first. Since samples are saved about every two seconds, a file for an eight-hour session will contain about 14,400 rows, with a file size of about 500 kilobytes. (Although most spreadsheet and database software should be able to load such files, some may have difficulty creating charts that use thousands of data values.)
The data columns are as follows:
Copyright © 2010-2018 Proximal Box Software. All rights reserved.