<div dir="ltr">Thank you for your answers. It looks like the Lat-Long wins :-) <br><div><br>Yes, its more natural to read in lat-long order. I checked with some paper records of the Bureau of Lands Location Monuments (BLLM), they too have Latitude/Northings Longitude/Eastings columns. Googe Earth uses it.<br>
<br>Maybe the only reason why some technical people and gis programs use long-lat format is don't want to reverse the order of x-y coordinate on their data list. I'm dropping KMLCSV Converter from my preferred utilities to recommend to lay people (too bad i love its simplicity, and can launch Garmin POI loader from within - no big deal)<br>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Sep 19, 2013 at 12:34 PM, Ed Garcia <span dir="ltr"><<a href="mailto:eppgarcia@gmail.com" target="_blank">eppgarcia@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">I also used lat-long ever since. My GPS devices displays them in that order, downloads them in that order too. my android GPS apps (GPS Essentials, One Touch Location, etc) displays them in that order too.<br>
</div><div class="gmail_extra"><div><div class="h5"><br><br><div class="gmail_quote">On Thu, Sep 19, 2013 at 12:15 PM, Wayne Manuel <span dir="ltr"><<a href="mailto:wdmanuel@gmail.com" target="_blank">wdmanuel@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Personally, I prefer lat-long. Easier to tell people that it should be alphabetical. And that at least in the PHL, the smaller number comes before the bigger number. <div>
<br></div><div>Also, when copying latitude longitude from Google Maps urls (the ll parameter), it's lat long. </div>
<div><br></div><div>When you want to quickly check where your lat longs are, you can just paste it into the Google Maps search box as lat,long</div><div><br><div><br></div><div><br></div></div></div><div class="gmail_extra">
<br clear="all"><div>Wayne Manuel</div>
<br><br><div class="gmail_quote">On Thu, Sep 19, 2013 at 11:22 AM, Rally de Leon <span dir="ltr"><<a href="mailto:ralleon@gmail.com" target="_blank">ralleon@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="ltr"><div><div><div>Dear all,<br></div><div><br></div><div>Which is the more common / preferred format for csv<br></div><div><div>lat,long,name or long,lat,name? and why do you prefer one over the other? (eg. less hassle, less clicks to import csv to common GIS softwares)<br>
<br></div></div><div>If I am to recommend to ordinary people a free conversion utility, which one? (my 2 preferred utility have different csv format) <br></div><div><br></div><div>If i use "gpsbabel's" generic (Comma separated values) option (eg. kml to csv conversion)---> gpsbabel -w -i kml -f filename.kml -o csv -F filename.csv</div>
<div>csv will be in this order---> lat,long,name<br><br></div><div>If i use another easy-to-use/free/multi-platform "KMLCSV" (from <a href="http://choonchernlim.com/kmlcsv/" target="_blank">http://choonchernlim.com/kmlcsv/</a> )<br>
</div><div>kml to csv conversion will give you---> long,lat,name<br></div><div><br>KMLCSV is very easy to use and allows ordinary people to view the POI's on built-in google maps for quick verification. easy to install, easy to distribute, virtually idiot-proof.<br>
<br></div>GPSBabel is universal, has gui and command line, but has too many option-buttons that can be confusing for ordinary user.<br></div><br>or is there a way gpsbabel can convert (kml to csv) or (osm to csv) in long,lat,name csv format?<br>
<br></div>Thanks,<br>Rally<br></div><div>
<br>_______________________________________________<br>
talk-ph mailing list<br>
<a href="mailto:talk-ph@openstreetmap.org" target="_blank">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></div></blockquote></div><br></div>
<br>_______________________________________________<br>
talk-ph mailing list<br>
<a href="mailto:talk-ph@openstreetmap.org" target="_blank">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></blockquote></div><br><br clear="all"><br></div></div><span class="HOEnZb"><font color="#888888">-- <br>website administrator: <br>- <a href="http://www.waypoints.ph" target="_blank">www.waypoints.ph</a><br>- <a href="http://reeflife.eppgarcia.com" target="_blank">reeflife.eppgarcia.com</a><br>
<br>PADI Divemaster #491048
</font></span></div>
</blockquote></div><br></div>