I'm a bit unsure about using gpsbabel. Is there a single command that will
covert a file of points of interest in .csv format with <a unique ID,
descriptor, x coordinate in metres osgb, y coordinate in osgb> to google
earth kml?

AJH

On 07/03/2009 12:12, andrew wrote:
> I'm a bit unsure about using gpsbabel. Is there a single command that will
> covert a file of points of interest in .csv format with<a unique ID,
> descriptor, x coordinate in metres osgb, y coordinate in osgb> to google
> earth kml?
>
> AJH

You could do this using the Universal CSV format:
http://www.gpsbabel.org/htmldoc-deve...mt_unicsv.html
First make sure your csv file has the correct headers in the first line.
In your case, I think it will be:
Name, Desc, bng_e, bng_n

Then run GPSBabel with the command:
gpsbabel -w -i unicsv -f test.csv -o kml -F out.kml

(changing the input and output filenames as needed)

--
Craig Wallace
http://craig.neogeo.org.uk
http://www.neogeo.org.uk

Craig Wallace wrote:

> You could do this using the Universal CSV format:
> http://www.gpsbabel.org/htmldoc-deve...mt_unicsv.html
> First make sure your csv file has the correct headers in the first line.
> In your case, I think it will be:
> Name, Desc, bng_e, bng_n
>
> Then run GPSBabel with the command:
> gpsbabel -w -i unicsv -f test.csv -o kml -F out.kml

It fails on the first waypoint with the error:
Invalid latitude 10000000000000001000000000.000000 in waypoint 93m.

I'm guessing there's a step missing in changing datums?

AJH

On 7 Mar, 12:12, andrew <n...@sylva.icuklive.co.uk> wrote:
> I'm a bit unsure about using gpsbabel. Is there a single command that will
> covert a file of points of interest in .csv format with <a unique ID,
> descriptor, x coordinate in metres osgb, y coordinate in osgb> to google
> earth kml?

I seem to have problems with GPS Babel, but I'm sure this is me and
not the software. When I do what you want to do, I use DNR Garmin.
This will convert CSV point files as OS grid references to KML good to
a metre or so. The file format looks like this:

ident,x_proj,y_proj
1,452145,175693
2,462314,174031

and so on.

Unfortunately, as downloaded DNR Garmin doesn't convert between WGS84
and EPSG:27700 (OS) properly. This can be fixed by following the
instructions in this document:

http://confound.me.uk/maps/Beginning_MM_1.pdf

which also explains how to set up DNRG to use EPSG:27700. Ignore the
rest of the stuff in this document <g>. One of the nice things about
DNRG is that you can also convert your data to shape files, for use in
GIS software. (Oh, and you don't need ArcGIS, a Garmin GPS receiver or
any GPS receiver to do what you want to do with DNRG).

Regards, N.

Nick wrote:
> I use DNR Garmin.
> This will convert CSV point files as OS grid references to KML good to
> a metre or so. The file format looks like this:
>
> ident,x_proj,y_proj
> 1,452145,175693
> 2,462314,174031
>

Hi Nick, fancy finding you here!

I'll check out DNR Garmin.

I do have a solution but was looking for something simpler.

Currently I create the ,csv file from a list of OS references I've scraped
from a .pdf. This I then import into Mapmaker. Generally I find it gives me
a good line (+-10 metres because the grid references are tile plus 8
figures only). I use the utility in XY-LatLon conversion utility in MM and
then exit the project. The I open a new project with the LatLon file and
export this to GPStrackmaker and re export this as kml!

With each line having ~500 points it takes me about an hour to create each
kml and I think I have a couple of hundred to do to cover GB.

It would be very nice to get from .csv OSGB36 to KML in one step.

AJH

On 7 Mar, 18:51, andrew <n...@sylva.icuklive.co.uk> wrote:

> Hi Nick, fancy finding you here!
>
> I'll check out DNR Garmin.
>
> I do have a solution but was looking for something simpler.
>
> Currently I create the ,csv file from a list of OS references I've scraped
> from a .pdf. This I then import into Mapmaker. Generally I find it gives me
> a good line (+-10 metres because the grid references are tile plus 8
> figures only). I use the utility in XY-LatLon conversion utility in MM and
> then exit the project. The I open a new project with the LatLon file and
> export this to GPStrackmaker and re export this as kml!
>
> With each line having ~500 points it takes me about an hour to create each
> kml and I think I have a couple of hundred to do to cover GB.
>
> It would be very nice to get from .csv OSGB36 to KML in one step.

Hi Andrew, yes I do drop in here from time to time. You do the
conversions from OSGB to lat/lon in MM, which is good, Trackmaker
conversions are not very accurate.

DNRG will do what you want, in one step. Oh, and you can have a
comment field too, I forgot to mention this.

ident,x_proj,y_proj,comment
1,452145,175693,This is a point
2,462314,174031,This is another point

By the way, if you think about it OS grid references along the lines
of SU XXXX XXXX are actually good to about five metres, because if you
stray more than five metres away in any direction you'll have a
different grid reference <g>.

Regards, N.

Nick wrote:

> By the way, if you think about it OS grid references along the lines
> of SU XXXX XXXX are actually good to about five metres, because if you
> stray more than five metres away in any direction you'll have a
> different grid reference <g>.

Thanks for the further input Nick but I think you're wrong on this last bit,
although I'm no mathematician and will to be corrected, the OS ref gives
you the bottom left corner of the square and the point can lie anywhere in
that.

For all practical purposes when used in conjunction with Google earth it's a
very accurate way of seeing a feature on a line.

The OS website has a tool for this conversion which is an Excel spreadsheet
I think, trouble is I'm not clever enough to call it from a cell in my
spreadsheet.

AJH