using timestamps from a csv file
Pete
Global Mapper UserTrusted User
I import csv files in many formats, often including a "time" column of data. How can I get GM to recognise the "time" data as a time stamp that can be used for exporting time stamped kml files? The times are not always regular so creating them as a series within GM is not practical.
Comments
-
Are you looking to create time-stamped waypoints or tracks? If you just want your points time-stamped on export to GPX just make the column named TIMESTAMP.
Let me know if I can be of further assistance.
Thanks,
Mike
Global Mapper Guru
gmsupport@bluemarblegeo.com
http://www.globalmapper.com -
Thanks, I am trying to import a track from a csv file that includes position, time stamps and other attributes. I would like to export this to a Google Earth (GE) so that the track can be replayed in GE using its play functions associated with timestamped data, without losing the attribute data loaded into GM with the csv. I have managed to get the timestamping side working by exporting a gpx file and then getting GE to convert that to a KML but that loses other attributes and is a messy approach to what should be a simple export. Hopefully I am just not clicking the right options. Any help would be appreciated.
-
What type of attribute data do you have? The GPX format doesn't support a completely generic set of attributes, you can only get out things like the display label, description, and a comment field, so you would need to have your attributes mapped to an appropriate name, like "COMMENT", for them to be exported to a GPX file.
Let me know if I can be of further assistance.
Thanks,
Mike
Global Mapper Guru
gmsupport@bluemarblegeo.com
http://www.globalmapper.com -
I was only using the gpx file as a means of preservicing the timestamp between GM and Google Earth, I do not need a GPX file. KMZ files support attributes and timestamping, I am just unable to get the timestamping function into the KMZ file using GM even though GM does manage it for other formats (eg GPX) with the same loaded csv data. How do I get GM to export a KMZ file with timestamps, when ticking the timestamping box does not appear to work for me?
-
Can you perhaps provide me with some sample data so I can take a look and come up with some ideas on how to get it directly to KML with the timestamps intact?
Thanks,
Mike
Global Mapper Guru
gmsupport@bluemarblegeo.com
http://www.globalmapper.com -
I have packaged a workspace with some dummy data as requested.
-
Aha, it looks like your line just has a bunch of duplicate TIMESTAMP attributes rather than actual per-vertex time-stamps.
How did you create your line? I can think of a couple of ways to go from either the source CSV or from a collection of points after loading and getting the times assigned, but I figure I'll change it where you actually need it to make it work.
Thanks,
Mike -
I went ahead and made connecting points with a TIMESTAMP attribute into a line using the Digitizer Tool add the per-vertex times to the new line, so you could load your points and then connect them into a line, then export that to a KML with replay tracks enabled to get the timed line. I have placed a new build at http://www.globalmapper.com/global_mapper13.zip with the change for you to try. Simply download that file and extract the contents into your existing v13.xx installation folder to give it a try. If you are using the 64-bit v13 version there is a new build at http://www.globalmapper.com/global_mapper13_64bit.zip .
Let me know if I can be of further assistance.
Thanks,
Mike -
Thanks, that does the trick. Before you roll it into a release, you may want to make the line attributes and KML altitude options work as per non-timestamped exports but that is a minor niggle. I also think that a simple export of the imported csv points to a timestamped KML/KMZ is the way ahead given that is how the KML/KMZ options appear to be offering. Looking forward to GM13.x. Thanks again.
Categories
- 12.7K All Categories
- 5.6K Features Discussion
- 342 Downloading Imagery
- 1.3K Elevation Data
- 380 Georeferencing Imagery Discussion
- 628 GM Script Language
- 53 User Scripts
- 113 GPS Features
- 414 Projection Questions
- 819 Raster Data
- 1.3K Vector Data
- 6.6K Support
- 177 Announcement and News
- 908 Bug Report
- 558 SDK
- 1.2K Suggestion Box
- 3.7K Technical Support
- 562 Other Discussion
- 129 GIS Data Sources
- 27 Global Mapper Showcase
- 233 How I use Global Mapper
- 107 Global Mapper Forum Website