<html><body><div style="color:#000; background-color:#fff; font-family:bookman old style, new york, times, serif;font-size:12pt"><div><span>try using time album. this comes when you buy columbus trackker</span></div><div><br></div> <div style="font-family: 'bookman old style', 'new york', times, serif; font-size: 12pt;"> <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> "talk-ph-request@openstreetmap.org" <talk-ph-request@openstreetmap.org><br> <b><span style="font-weight: bold;">To:</span></b> talk-ph@openstreetmap.org <br> <b><span style="font-weight: bold;">Sent:</span></b> Thursday, September 19, 2013 1:16 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> talk-ph Digest, Vol 62, Issue 14<br> </font> </div> <div class="y_msg_container"><br>Send talk-ph mailing list submissions
to<br> <a ymailto="mailto:talk-ph@openstreetmap.org" href="mailto:talk-ph@openstreetmap.org">talk-ph@openstreetmap.org</a><br><br>To subscribe or unsubscribe via the World Wide Web, visit<br> <a href="https://lists.openstreetmap.org/listinfo/talk-ph" target="_blank">https://lists.openstreetmap.org/listinfo/talk-ph</a><br>or, via email, send a message with subject or body 'help' to<br> <a ymailto="mailto:talk-ph-request@openstreetmap.org" href="mailto:talk-ph-request@openstreetmap.org">talk-ph-request@openstreetmap.org</a><br><br>You can reach the person managing the list at<br> <a ymailto="mailto:talk-ph-owner@openstreetmap.org" href="mailto:talk-ph-owner@openstreetmap.org">talk-ph-owner@openstreetmap.org</a><br><br>When replying, please edit your Subject line so it is more specific<br>than "Re: Contents of talk-ph digest..."<br><br><br>Today's Topics:<br><br> 1. Ervin's
Mapping Advocates blog post (Eugene Alvin Villar)<br> 2. recommended csv format (Rally de Leon)<br> 3. Re: recommended csv format (Jim Morgan)<br> 4. Re: recommended csv format (Wayne Manuel)<br> 5. Re: recommended csv format (Ed Garcia)<br> 6. Re: recommended csv format (Rally de Leon)<br><br><br>----------------------------------------------------------------------<br><br>Message: 1<br>Date: Thu, 19 Sep 2013 00:56:47 +0800<br>From: Eugene Alvin Villar <<a ymailto="mailto:seav80@gmail.com" href="mailto:seav80@gmail.com">seav80@gmail.com</a>><br>To: OpenStreetMap Philippines <<a ymailto="mailto:talk-ph@openstreetmap.org" href="mailto:talk-ph@openstreetmap.org">talk-ph@openstreetmap.org</a>><br>Subject: [talk-ph] Ervin's Mapping Advocates blog post<br>Message-ID:<br> <CAPhqi6Lh1=g9BZRtH12C3Z07suE7=CyNQ2wNK60V8JYx=<a ymailto="mailto:Rm4Cg@mail.gmail.com"
href="mailto:Rm4Cg@mail.gmail.com">Rm4Cg@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Hi guys,<br><br>Ervin has posted a nice article on his blog where he interviewed volunteer<br>mappers who contribute to OSM, RoadGuide.ph, WaypointsDotPH, and Google Map<br>Maker:<br><a href="http://www.s1expeditions.com/2013/09/100-philippinemappingadvocates.html" target="_blank">http://www.s1expeditions.com/2013/09/100-philippinemappingadvocates.html</a><br><br>The OSM interviewees include myself, Maning, Ian, Ed, Rem, and Tutubi.<br>There's also Rally. :)<br>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.openstreetmap.org/pipermail/talk-ph/attachments/20130919/8ef2c3ed/attachment-0001.html" target="_blank">http://lists.openstreetmap.org/pipermail/talk-ph/attachments/20130919/8ef2c3ed/attachment-0001.html</a>><br><br>------------------------------<br><br>Message:
2<br>Date: Thu, 19 Sep 2013 11:22:26 +0800<br>From: Rally de Leon <<a ymailto="mailto:ralleon@gmail.com" href="mailto:ralleon@gmail.com">ralleon@gmail.com</a>><br>To: OSM <<a ymailto="mailto:talk-ph@openstreetmap.org" href="mailto:talk-ph@openstreetmap.org">talk-ph@openstreetmap.org</a>><br>Subject: [talk-ph] recommended csv format<br>Message-ID:<br> <CA+<a ymailto="mailto:M6697R3JCyoKPUUr7gKBUuUpsBH1pHYHvMLkh-E4JwadBNPA@mail.gmail.com" href="mailto:M6697R3JCyoKPUUr7gKBUuUpsBH1pHYHvMLkh-E4JwadBNPA@mail.gmail.com">M6697R3JCyoKPUUr7gKBUuUpsBH1pHYHvMLkh-E4JwadBNPA@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<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 on<br>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>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.openstreetmap.org/pipermail/talk-ph/attachments/20130919/8d64a876/attachment-0001.html" target="_blank">http://lists.openstreetmap.org/pipermail/talk-ph/attachments/20130919/8d64a876/attachment-0001.html</a>><br><br>------------------------------<br><br>Message: 3<br>Date: Thu, 19 Sep 2013 12:06:05 +0800<br>From: Jim Morgan <<a ymailto="mailto:jim@datalude.com" href="mailto:jim@datalude.com">jim@datalude.com</a>><br>To: <a ymailto="mailto:talk-ph@openstreetmap.org" href="mailto:talk-ph@openstreetmap.org">talk-ph@openstreetmap.org</a><br>Subject: Re: [talk-ph] recommended csv format<br>Message-ID: <<a ymailto="mailto:523A782D.4010409@datalude.com" href="mailto:523A782D.4010409@datalude.com">523A782D.4010409@datalude.com</a>><br>Content-Type: text/plain; charset=ISO-8859-1;
format=flowed<br><br>On Thursday, 19 September, 2013 11:22 AM, Rally de Leon wrote:<br>> lat,long,name or long,lat,name? and why do you prefer one over the <br>> other? (eg. less hassle, less clicks to import csv to common GIS <br>> softwares)<br>Just my opinion: when people talk about co-ordinates, they normally talk <br>about Lat and Long (almost never Long and Lat), so they should probably <br>be in that order! I'd say gpsbabel has it right, and your other software <br>is swimming against the tide.<br><br>The advantage of XML formats as opposed to CSV, is that they specify <br>that each point is either <lat></lat> or <long></long> so there is no <br>ambiguity.<br><br>Jim<br><br><br><br>------------------------------<br><br>Message: 4<br>Date: Thu, 19 Sep 2013 12:15:52 +0800<br>From: Wayne Manuel <<a ymailto="mailto:wdmanuel@gmail.com" href="mailto:wdmanuel@gmail.com">wdmanuel@gmail.com</a>><br>To: Rally de Leon
<<a ymailto="mailto:ralleon@gmail.com" href="mailto:ralleon@gmail.com">ralleon@gmail.com</a>><br>Cc: OSM <<a ymailto="mailto:talk-ph@openstreetmap.org" href="mailto:talk-ph@openstreetmap.org">talk-ph@openstreetmap.org</a>><br>Subject: Re: [talk-ph] recommended csv format<br>Message-ID:<br> <CA+d-fotrU3QAF4hP3_7HbPfVm2CZ0vDcnRUiT3mAPUnU_H+<a ymailto="mailto:KRg@mail.gmail.com" href="mailto:KRg@mail.gmail.com">KRg@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<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 paste<br>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 on<br>> 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>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.openstreetmap.org/pipermail/talk-ph/attachments/20130919/1e4b4e9a/attachment-0001.html" target="_blank">http://lists.openstreetmap.org/pipermail/talk-ph/attachments/20130919/1e4b4e9a/attachment-0001.html</a>><br><br>------------------------------<br><br>Message: 5<br>Date: Thu, 19 Sep 2013 12:34:50 +0800<br>From: Ed Garcia <<a ymailto="mailto:eppgarcia@gmail.com" href="mailto:eppgarcia@gmail.com">eppgarcia@gmail.com</a>><br>To: Wayne Manuel <<a ymailto="mailto:wdmanuel@gmail.com" href="mailto:wdmanuel@gmail.com">wdmanuel@gmail.com</a>><br>Cc: OSM <<a ymailto="mailto:talk-ph@openstreetmap.org" href="mailto:talk-ph@openstreetmap.org">talk-ph@openstreetmap.org</a>><br>Subject: Re: [talk-ph] recommended csv
format<br>Message-ID:<br> <CAOEB1pW5H-b9VgiAZpaf7y2zjS=<a ymailto="mailto:3OiZOvMMu27G-TZ8YfhJmbA@mail.gmail.com" href="mailto:3OiZOvMMu27G-TZ8YfhJmbA@mail.gmail.com">3OiZOvMMu27G-TZ8YfhJmbA@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><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>-------------- next part --------------<br>An HTML
attachment was scrubbed...<br>URL: <<a href="http://lists.openstreetmap.org/pipermail/talk-ph/attachments/20130919/0dc3ef3e/attachment-0001.html" target="_blank">http://lists.openstreetmap.org/pipermail/talk-ph/attachments/20130919/0dc3ef3e/attachment-0001.html</a>><br><br>------------------------------<br><br>Message: 6<br>Date: Thu, 19 Sep 2013 13:16:03 +0800<br>From: Rally de Leon <<a ymailto="mailto:ralleon@gmail.com" href="mailto:ralleon@gmail.com">ralleon@gmail.com</a>><br>To: Ed Garcia <<a ymailto="mailto:eppgarcia@gmail.com" href="mailto:eppgarcia@gmail.com">eppgarcia@gmail.com</a>><br>Cc: OSM <<a ymailto="mailto:talk-ph@openstreetmap.org" href="mailto:talk-ph@openstreetmap.org">talk-ph@openstreetmap.org</a>><br>Subject: Re: [talk-ph] recommended csv format<br>Message-ID:<br> <CA+M6697Qmu-7u8xZdfMwPZTiZ4+<a ymailto="mailto:syUHet5T7uaMRMw4R7OwQLw@mail.gmail.com"
href="mailto:syUHet5T7uaMRMw4R7OwQLw@mail.gmail.com">syUHet5T7uaMRMw4R7OwQLw@mail.gmail.com</a>><br>Content-Type: text/plain; charset="iso-8859-1"<br><br>Thank you for your answers. It looks like the Lat-Long wins :-)<br><br>Yes, its more natural to read in lat-long order. I checked with some paper<br>records of the Bureau of Lands Location Monuments (BLLM), they too have<br>Latitude/Northings Longitude/Eastings columns. Googe Earth uses it.<br><br>Maybe the only reason why some technical people and gis programs use<br>long-lat format is don't want to reverse the order of x-y coordinate on<br>their data list. I'm dropping KMLCSV Converter from my preferred utilities<br>to recommend to lay people (too bad i love its simplicity, and can launch<br>Garmin POI loader from within - no big deal)<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><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<br>>>> other? (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<br>>>> to 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>-------------- next part --------------<br>An HTML attachment was scrubbed...<br>URL: <<a href="http://lists.openstreetmap.org/pipermail/talk-ph/attachments/20130919/9b873067/attachment.html" target="_blank">http://lists.openstreetmap.org/pipermail/talk-ph/attachments/20130919/9b873067/attachment.html</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>End of talk-ph Digest, Vol 62, Issue 14<br>***************************************<br><br><br></div> </div> </div> </div></body></html>