change float to double at GPS lat/lon column for better mapping

surfrock66 / torque

A set of tools used with the Torque app for Android to store OBD2 data in MySQL, view GPS data from Torque on a map in real time using the Google Maps JavaScript API, plot OBD2 data in time series charts, and export the data to CSV or JSON.

Other

43 stars 23 forks source link

change float to double at GPS lat/lon column for better mapping #21

Closed takashisite closed 5 years ago

takashisite commented 7 years ago

for smooth line draw 👍🏻

exists db:

ALTER TABLE torque.raw_logs MODIFY kff1006 DOUBLE NOT NULL DEFAULT '0'
ALTER TABLE torque.raw_logs MODIFY kff1005 DOUBLE NOT NULL DEFAULT '0'

surfrock66 commented 7 years ago

I want to look at a few things before I merge this; I think the install instructions would need to be modified to set this up at initial setup. I'll confirm tonight.

surfrock66 commented 5 years ago

This is gonna sound stupid, but all this time afterwards, I'll be implementing this. I've made some massive breaking restructuring to my local copy, and it's requiring an entire database rebuild. As such, there's no reason to NOT do this. The reason I was hesitant was just due to the implementation details, but at this point it requires so much manual DB work there's no reason to not implement it.