jacobian / jacobian/coros-to-sqlite
store track details
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 1
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
`detail["frequencyList"]` is a list of
```
{'altitude': 77,
'cadence': 164,
'cadenceLength': 101,
'distance': 2800,
'gpsLat': 447678130,
'gpsLon': -1230242061,
'heart': 102,
'heartLevel': 1,
'power': 135,
'slope': 0,
'speed': 360,
'timestamp': 164497134500}
```
I think it's approximately one per second (?).
I'd like to store this in a way that makes sense. A polyline via Spatialite makes a lot of sense -- that would let me draw maps etc -- but the last time I did this I recall that storing the extra info (HR, power, etc) alongside that spatial data is weird. A separate table with one row per point would work too, I guess, but be pretty unweildly.
There's also #4 for the raw file, which is a different way of getting this same data. Some redundancy here is OK too I think.
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
No file or test is named. Start by tracing how detail["frequencyList"] is currently read and compare the raw-file path in issue #4. Done means choosing and implementing a storage model that preserves the track points and fields such as cadence, heart rate, power, GPS coordinates, and timestamps.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python, sqlite
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 30/100