11.06.2009, 15:13
(11.06.2009, 09:19)routeconverter Wrote: Of course I could try to define a generic .csv format, but how would that look like? Something like this:
INDEX,DATE,TIME,LATITUDE,LONGITUDE,HEIGHT,SPEED,COMMENT,
1,210409,061051,47.797120,13.049595,524.33,33.44,Somewhere above the sea,
2,210409,061051,47.897120,13.059595,525.33,34.34,For GER/FRA/DK/NW/SW umlauts like äöüß,
Date + Time in GMT
Date in ddmmyy, Time in hhmmss
Latitude, Longitude in WGS84
Height in Meter above sealevel
Speed in Km/h
Whole file is UTF-8 encoded
Spaces ignored
Something like that?
Alternatively: How about splitting the NSWE into separate columns in Excel, doing the subtraction and then joining them again?
1. I would not split the NSEW into separate columns, since the use of '-' for west and south is a well known standard, and therefore the latitude has to be north if positive and south if negative, and longitude has to be west if negative and east if positive.
2. The math used to adjust a track if it is off, as mine is via the Panama Canal, by about .0006° longitude is, in this instance to use -.0006 on the longitude column. Even if it crossed the 0° longitude marker, that same adjustment would be continued, correctly, on all of the longitude cells in the CVS file. It you split the columns based on West or East, I would simply need to do that same math on the two columns instead of on the one column should it cross the 0° point.
3. As long as you cover all of the columns available in RouteConverter, including the Description column, which I suspect you are calling the Comment column, and Elevation is the same what you are calling Height above, I am quite happy as even if I had added a postal address before I started working on the file in QuatroPro or Excel, I would be fine as I wouldn't lose anything from the before file I had converted.
4. Index is fine, but when I re-order lines that index value will suddenly be out of order as well. I would expect all of my 'files' would be in date and time sequence [and I would check via a sort] anyway, so I am uncertain what, if anything, the index column adds. It cannot hurt if when, after adjusting the file, it is not used to order the positions when I convert back from CVS to GPX, which is what I would be doing... In fact I would expect that the index column would simply be dropped if I were converting back to GPX, since it is not in the GPX file at the start, nor in the RouteConverter's screen display of a GPX file as imported, where the Description column starts off as with position values.
5. If you do have an index column, and if I am bringing two GPX files, individually saved as CVS files via RouteConverter, into the same 'spreadsheet' so as to merge them, both would have the same INDEX values in them for the first x positions, and I would likely be injecting Y blank lines so as to fill in the gap between file one and file two.
6. In the case of my Panama Canal files [five in total] there are gaps of several seconds between the various files, and I would import each into the one CVS file, insert the missing seconds at the gap I would deliberately leave, using a simple equation to move the ship from the last position in file one to the first position in file two, for example, and then re-index the file so as to get rid of the duplicate index numbers, yet sorting simply on the time column [or date and time if midnight gets in the way] puts them in absolutely the correct order in any event [except where two entries have the same precise time in seconds, which does indeed happen on occasion]. So I am uncertain what the index column adds, if anything... but as long as it is ignored when the file is loaded into RouteConverter AFTER the corrections and adjustments are made, I really do not care if it is there or not <grin>...
Hope that helps you decide which way to go with it... and it is fairly simple to add that index column down the road, or remove it down the road, so go either way, as long as saving as a pure CVS file, and loading a pure CVS file both follow the same rules.
Incidentally, one other use I have for this sort of file is to create from scratch a CVS file for old slides I am now scanning using my Nikon Coolscan III and Vuescan, which injects a basic EXIF file. I can easily create a record that uses the date in the scanned result and the latitude and longitude where the image was taken [for example Monte Alban, in Mexico, during our Honeymoon] and then use GPicSync to inject that geo-position information into those scanned slides so that the digitized images have better data in them. The other way I can do this is to use Wordpad, and that is a bit more cumbersome so I prefer using a delimited file and QuatroPro. In those instances speed and altitude/elevation would be blank, and I would let RouteConverter fill in those fields after importing the CVS file into RouteConverter, and before injecting into the scanned images.