So me being confused about something so simple is valid. :-) It all started with me using Osmconvert http://wiki.openstreetmap.org/wiki/Osmconvert in the search for a "macgyver solution" to make osm raw data become readable/distributable in spreadsheet form
which has this example that I initially adapted: (csv in @lon @lat order) osmconvert shops.osm --all-to-nodes --csv="@id @lon @lat amenity shop name" --csv-headline On Thu, Sep 19, 2013 at 1:21 PM, maning sambale <[email protected]>wrote: > The problem with lat,long is that it will be confusing when you plot > it in a cartesian plane. > Mathematics convention is x,y (hence long,lat) and this becomes more > confusing if you use a projected coordinate system like UTM (Easting, > Northing). > > For a bit of history, the lat, long order came from its roots in sea > navigation. During those days (where there are no GPS or even marine > chronometer) only latitude (north and south) could be measured with > great accuracy. > > My suggestion, stick to the one you prefer and use it consistently. > > > > > On Thu, Sep 19, 2013 at 12:34 PM, Ed Garcia <[email protected]> wrote: > > 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. > > > > > > On Thu, Sep 19, 2013 at 12:15 PM, Wayne Manuel <[email protected]> > wrote: > >> > >> 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. > >> > >> Also, when copying latitude longitude from Google Maps urls (the ll > >> parameter), it's lat long. > >> > >> 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 > >> > >> > >> > >> > >> Wayne Manuel > >> > >> > >> On Thu, Sep 19, 2013 at 11:22 AM, Rally de Leon <[email protected]> > wrote: > >>> > >>> Dear all, > >>> > >>> Which is the more common / preferred format for csv > >>> 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) > >>> > >>> If I am to recommend to ordinary people a free conversion utility, > which > >>> one? (my 2 preferred utility have different csv format) > >>> > >>> 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 > >>> csv will be in this order---> lat,long,name > >>> > >>> If i use another easy-to-use/free/multi-platform "KMLCSV" (from > >>> http://choonchernlim.com/kmlcsv/ ) > >>> kml to csv conversion will give you---> long,lat,name > >>> > >>> 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. > >>> > >>> GPSBabel is universal, has gui and command line, but has too many > >>> option-buttons that can be confusing for ordinary user. > >>> > >>> or is there a way gpsbabel can convert (kml to csv) or (osm to csv) in > >>> long,lat,name csv format? > >>> > >>> Thanks, > >>> Rally > >>> > >>> _______________________________________________ > >>> talk-ph mailing list > >>> [email protected] > >>> https://lists.openstreetmap.org/listinfo/talk-ph > >>> > >> > >> > >> _______________________________________________ > >> talk-ph mailing list > >> [email protected] > >> https://lists.openstreetmap.org/listinfo/talk-ph > >> > > > > > > > > -- > > website administrator: > > - www.waypoints.ph > > - reeflife.eppgarcia.com > > > > PADI Divemaster #491048 > > > > _______________________________________________ > > talk-ph mailing list > > [email protected] > > https://lists.openstreetmap.org/listinfo/talk-ph > > > > > > -- > cheers, > maning > ------------------------------------------------------ > "Freedom is still the most radical idea of all" -N.Branden > wiki: http://esambale.wikispaces.com/ > blog: http://epsg4253.wordpress.com/ > ------------------------------------------------------ > > _______________________________________________ > talk-ph mailing list > [email protected] > https://lists.openstreetmap.org/listinfo/talk-ph >
_______________________________________________ talk-ph mailing list [email protected] https://lists.openstreetmap.org/listinfo/talk-ph
