mwkeefer
1 MW
Hello All,
Currently I have a combination of sensors and logging equipment but most often I find myself using my EagleTree v3 eLogger with GPS + my iPhone 3GS with software which records GPSX trail logs.
The issue isn't logging but analysis... To date I have not been able to find a "bike" friendly GPS or navigation software package. Yep, I'm using either Google Earth or Google Maps to see my travels which works fine there but anyone who has ever tried to use EagleTree can tell you... there aren't many options for output.
What I am seeking is a SW package which can display the logged GPS trail but also show me largest climbs, averages durring climb/descent - speed / distance is enough but integrating the available logs from EagleTree would be nice to see the current and power a particular surge consumed... I have been searching for weeks to no avail for a package or packages which could do this, currently I use DTS (well it's not DTS anymore but it's still Data Transformation Services) to import the EagleTree logfiles into SQL Server 2008 in order to analyze and find "hot spots" or areas of increased current and then I have stored procs to generate new GPSX files and output the data with the hotspots documented for Google Maps... this is sufficient but time consuming and annoying. I also analyze the climb/descent rates and add them to the output tracks so I can identify a gradient percentage and climb durration / current / mah consumed.
I am posting this open request for info prior to actually cracking open Visual Studio and coding something on my own (why invent the wheel if I don't need too?) to fill this niche... any ideas are greatly appreciated!
If the turn-key sw doesn't exist to anyone's knowledge I will break out VS and code the whole package I have into SQL Server Express (or maybe do a platform independant package and use SQLite or MySQL) and release it here on ES so I am open to any suggestions or comments before making this a standalone (if the sw is not already out there).
Thanks in advance everyone!
-Mike
Currently I have a combination of sensors and logging equipment but most often I find myself using my EagleTree v3 eLogger with GPS + my iPhone 3GS with software which records GPSX trail logs.
The issue isn't logging but analysis... To date I have not been able to find a "bike" friendly GPS or navigation software package. Yep, I'm using either Google Earth or Google Maps to see my travels which works fine there but anyone who has ever tried to use EagleTree can tell you... there aren't many options for output.
What I am seeking is a SW package which can display the logged GPS trail but also show me largest climbs, averages durring climb/descent - speed / distance is enough but integrating the available logs from EagleTree would be nice to see the current and power a particular surge consumed... I have been searching for weeks to no avail for a package or packages which could do this, currently I use DTS (well it's not DTS anymore but it's still Data Transformation Services) to import the EagleTree logfiles into SQL Server 2008 in order to analyze and find "hot spots" or areas of increased current and then I have stored procs to generate new GPSX files and output the data with the hotspots documented for Google Maps... this is sufficient but time consuming and annoying. I also analyze the climb/descent rates and add them to the output tracks so I can identify a gradient percentage and climb durration / current / mah consumed.
I am posting this open request for info prior to actually cracking open Visual Studio and coding something on my own (why invent the wheel if I don't need too?) to fill this niche... any ideas are greatly appreciated!
If the turn-key sw doesn't exist to anyone's knowledge I will break out VS and code the whole package I have into SQL Server Express (or maybe do a platform independant package and use SQLite or MySQL) and release it here on ES so I am open to any suggestions or comments before making this a standalone (if the sw is not already out there).
Thanks in advance everyone!
-Mike