Apple devices collect a lot of information about you, I want to take a peek at at.

Some ideas:

• analysis of relationship between cycling speed and journey time (i.e. are you just getting to traffic lights sooner?)
• Which factors can be used to predict an increase VO2 max?
  • daily steps?
  • consistent running streaks?
• can I make a pretty plot of where I have walked (table contains millions of points)

• datasette & spatialite
• grafana
• bokeh
• R & ggplot2

• make a docker container that contains all the bits for a healthkit data exploring app.

• Apple Healthkit Docs
• Q: problem with import of XML Apple HealthKit Export Version: 12
• automated-exporting-of-health-kit-data

virtualenv ~/virtualenv/healthkit
source ~/virtualenvs/healthkit/bin/activate
pip install datasette healthkit_to_sqlite

healthkit-to-sqlite export.zip healthkit.db

This resulted in some errors about invalid syntax. Looks like the v12 of the healthkit data has some issues!

This thread here put me on the right track https://discussions.apple.com/thread/254202523.

Install xmllint

sudo apt-get install libxml2-utils

Use xmllint to point you at the errors

unzip export.zip
xmllint apple_health_export/export.xml 

Edit the xml in vi to remove the errors - a missing bracket, some invalid sections like in the link

• : set number
• esc + {line_no} + shift-G to jump