In most data acquisition settings it is useful to tag your data with time and location. If I write the data to csv file, what are the best formats that I can use for this two variables if I want to create a heatmap on Google Maps?

  • $\begingroup$ "Best" is massively dependent on your application and probably subjective too. $\endgroup$ – Spacedman Nov 3 '14 at 15:58
  • $\begingroup$ Question was edited to be more specific. $\endgroup$ – ontan Nov 3 '14 at 16:56

As Spacedman put it, "best" is pretty subjective. However, as we have found, a good format for time is Unix time (aka POSIX time, aka Epoch time). Most databases support it and it is still pretty human readable.

For location, we like decimal degrees as it is easy to read and stored and is compatible with Google Maps API. It's also easy to convert to other formats if needed.

| improve this answer | |
  • $\begingroup$ If using decimal degrees make sure your metadata includes the Coordinate Reference System (most likely WGS84 lat-long, aka EPSG code 4326). Time stamps need to consider time zones, DST and leap seconds when applicable. Caveat emptor. $\endgroup$ – Spacedman Nov 4 '14 at 17:46

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.