<html><body><div style="color:#000; background-color:#fff; font-family:verdana, helvetica, sans-serif;font-size:10pt"><div><span>Also to add a bit even it may sound obvious. For easier plotting of the coordinates , </span><span style="background-color: transparent;">the lat/long field should be in Decimal Degrees format.</span></div><div style="color: rgb(0, 0, 0); font-size: 13.333333015441895px; font-family: verdana, helvetica, sans-serif; background-color: transparent; font-style: normal;"><span style="background-color: transparent;"><br></span></div><div style="color: rgb(0, 0, 0); font-size: 13.333333015441895px; font-family: verdana, helvetica, sans-serif; background-color: transparent; font-style: normal;"><span style="background-color: transparent;">--bunny</span></div><div><br></div> <div style="font-family: verdana, helvetica, sans-serif; font-size: 10pt;"> <div style="font-family: 'times new roman', 'new york', times, serif; font-size:
12pt;"> <div dir="ltr"> <hr size="1"> <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> maning sambale <emmanuel.sambale@gmail.com><br> <b><span style="font-weight: bold;">To:</span></b> osm-ph <talk-ph@openstreetmap.org> <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, 19 September 2013 1:21 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [talk-ph] recommended csv format<br> </font> </div> <div class="y_msg_container"><br>The problem with lat,long is that it will be confusing when you plot<br>it in a cartesian plane.<br>Mathematics convention is x,y (hence long,lat) and this becomes more<br>confusing if you use a projected coordinate system like UTM (Easting,<br>Northing).<br><br>For a bit of history, the lat, long order came from its roots in sea<br>navigation. During those days (where there are no GPS or even marine<br>chronometer) only latitude (north and south)
could be measured with<br>great accuracy.<br><br>My suggestion, stick to the one you prefer and use it consistently.<br><br><br><br><br>On Thu, Sep 19, 2013 at 12:34 PM, Ed Garcia <<a ymailto="mailto:eppgarcia@gmail.com" href="mailto:eppgarcia@gmail.com">eppgarcia@gmail.com</a>> wrote:<br>> I also used lat-long ever since. My GPS devices displays them in that<br>> order, downloads them in that order too. my android GPS apps (GPS<br>> Essentials, One Touch Location, etc) displays them in that order too.<br>><br>><br>> On Thu, Sep 19, 2013 at 12:15 PM, Wayne Manuel <<a ymailto="mailto:wdmanuel@gmail.com" href="mailto:wdmanuel@gmail.com">wdmanuel@gmail.com</a>> wrote:<br>>><br>>> Personally, I prefer lat-long. Easier to tell people that it should be<br>>> alphabetical. And that at least in the PHL, the smaller number comes before<br>>> the bigger number.<br>>><br>>> Also, when
copying latitude longitude from Google Maps urls (the ll<br>>> parameter), it's lat long.<br>>><br>>> When you want to quickly check where your lat longs are, you can just<br>>> paste it into the Google Maps search box as lat,long<br>>><br>>><br>>><br>>><br>>> Wayne Manuel<br>>><br>>><br>>> On Thu, Sep 19, 2013 at 11:22 AM, Rally de Leon <<a ymailto="mailto:ralleon@gmail.com" href="mailto:ralleon@gmail.com">ralleon@gmail.com</a>> wrote:<br>>>><br>>>> Dear all,<br>>>><br>>>> Which is the more common / preferred format for csv<br>>>> lat,long,name or long,lat,name? and why do you prefer one over the other?<br>>>> (eg. less hassle, less clicks to import csv to common GIS softwares)<br>>>><br>>>> If I am to recommend to ordinary people a free conversion utility, which<br>>>> one? (my 2 preferred
utility have different csv format)<br>>>><br>>>> If i use "gpsbabel's" generic (Comma separated values) option (eg. kml to<br>>>> csv conversion)---> gpsbabel -w -i kml -f filename.kml -o csv -F<br>>>> filename.csv<br>>>> csv will be in this order---> lat,long,name<br>>>><br>>>> If i use another easy-to-use/free/multi-platform "KMLCSV" (from<br>>>> <a href="http://choonchernlim.com/kmlcsv/" target="_blank">http://choonchernlim.com/kmlcsv/ </a>)<br>>>> kml to csv conversion will give you---> long,lat,name<br>>>><br>>>> KMLCSV is very easy to use and allows ordinary people to view the POI's<br>>>> on built-in google maps for quick verification. easy to install, easy to<br>>>> distribute, virtually idiot-proof.<br>>>><br>>>> GPSBabel is universal, has gui and command line, but has too many<br>>>>
option-buttons that can be confusing for ordinary user.<br>>>><br>>>> or is there a way gpsbabel can convert (kml to csv) or (osm to csv) in<br>>>> long,lat,name csv format?<br>>>><br>>>> Thanks,<br>>>> Rally<br>>>><br>>>> _______________________________________________<br>>>> talk-ph mailing list<br>>>> <a ymailto="mailto:talk-ph@openstreetmap.org" href="mailto:talk-ph@openstreetmap.org">talk-ph@openstreetmap.org</a><br>>>> <a href="https://lists.openstreetmap.org/listinfo/talk-ph" target="_blank">https://lists.openstreetmap.org/listinfo/talk-ph</a><br>>>><br>>><br>>><br>>> _______________________________________________<br>>> talk-ph mailing list<br>>> <a ymailto="mailto:talk-ph@openstreetmap.org" href="mailto:talk-ph@openstreetmap.org">talk-ph@openstreetmap.org</a><br>>> <a
href="https://lists.openstreetmap.org/listinfo/talk-ph" target="_blank">https://lists.openstreetmap.org/listinfo/talk-ph</a><br>>><br>><br>><br>><br>> --<br>> website administrator:<br>> - www.waypoints.ph<br>> - reeflife.eppgarcia.com<br>><br>> PADI Divemaster #491048<br>><br>> _______________________________________________<br>> talk-ph mailing list<br>> <a ymailto="mailto:talk-ph@openstreetmap.org" href="mailto:talk-ph@openstreetmap.org">talk-ph@openstreetmap.org</a><br>> <a href="https://lists.openstreetmap.org/listinfo/talk-ph" target="_blank">https://lists.openstreetmap.org/listinfo/talk-ph</a><br>><br><br><br><br>-- <br>cheers,<br>maning<br>------------------------------------------------------<br>"Freedom is still the most radical idea of all" -N.Branden<br>wiki: <a href="http://esambale.wikispaces.com/" target="_blank">http://esambale.wikispaces.com/</a><br>blog: <a
href="http://epsg4253.wordpress.com/" target="_blank">http://epsg4253.wordpress.com/</a><br>------------------------------------------------------<br><br>_______________________________________________<br>talk-ph mailing list<br><a ymailto="mailto:talk-ph@openstreetmap.org" href="mailto:talk-ph@openstreetmap.org">talk-ph@openstreetmap.org</a><br><a href="https://lists.openstreetmap.org/listinfo/talk-ph" target="_blank">https://lists.openstreetmap.org/listinfo/talk-ph</a><br><br><br></div> </div> </div> </div></body></html>