[talk-ph] recommended csv format

[Rally de Leon]

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
<emmanuel.sambale at gmail.com>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 <eppgarcia at gmail.com> 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 <wdmanuel at gmail.com>
> 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 <ralleon at gmail.com>
> 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
> >>> talk-ph at openstreetmap.org
> >>> https://lists.openstreetmap.org/listinfo/talk-ph
> >>>
> >>
> >>
> >> _______________________________________________
> >> talk-ph mailing list
> >> talk-ph at openstreetmap.org
> >> https://lists.openstreetmap.org/listinfo/talk-ph
> >>
> >
> >
> >
> > --
> > website administrator:
> > - www.waypoints.ph
> > - reeflife.eppgarcia.com
> >
> > PADI Divemaster #491048
> >
> > _______________________________________________
> > talk-ph mailing list
> > talk-ph at openstreetmap.org
> > 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
> talk-ph at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/talk-ph
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/talk-ph/attachments/20130919/312f3bc8/attachment.html>