[gdal-dev] ogr2ogr and GPX files

[Tamas Szekeres]

Dylan,

I couldn't reproduce the issue on Windows using the current version in
the trunk. The result have been attached to this ticket.

Are you sure you use the proper version?

Best regards,

Tamas



2008/3/4, Dylan Beaudette <dylan.beaudette at gmail.com>:
> On Tuesday 04 March 2008, Tamas Szekeres wrote:
>
> > Dylan,
>  >
>  > Would you attach this ogr2ogr commandline string and the corresponding
>  > test data to
>  > http://trac.osgeo.org/gdal/ticket/2171
>  > I'll look into the problem than.
>  >
>  > ( That's why I still haven't closed this ticket ;-)
>  >
>  >
>  > Best regards,
>  >
>  > Tamas
>
>
> Thanks Tamas:
>
>  http://trac.osgeo.org/gdal/ticket/2171#comment:5
>
>
>  Cheers,
>
>  Dylan
>
>  >
>  > 2008/3/4, Dylan Beaudette <dylan.beaudette at gmail.com>:
>  > > On Tuesday 04 March 2008, Tamas Szekeres wrote:
>  > >  > Hi,
>  > >  >
>  > >  > Yes, you should try with the recent SVN version. The changes related
>  > >  > to this issue are pretty new.
>  > >  >
>  > >  > Best regards,
>  > >  >
>  > >  > Tamas
>  > >
>  > > Hi Tamas,
>  > >
>  > >  Thanks for the tip. Unfortunately, even with today's SVN, I still get
>  > > the same error:
>  > >
>  > >
>  > >  ERROR 1: SQL: Missing comma after column cat in SELECT statement.
>  > >
>  > >
>  > > Cheers,
>  > >
>  > >
>  > >  Dylan
>  > >
>  > >  > 2008/3/4, Dylan Beaudette <dylan.beaudette at gmail.com>:
>  > >  > > On Monday 03 March 2008, Even Rouault wrote:
>  > >  > >  > In fact, using the same principle, you can use just one command
>  > >  > >  > line and no intermediary file :
>  > >  > >  >
>  > >  > >  > ogr2ogr -f GPX destination.gpx source.shp -sql "SELECT
>  > >  > >  > src_field_1 AS name, src_field_2 AS desc FROM
>  > >  > >  > your_source_layer_name"
>  > >  > >  >
>  > >  > >  > Thanks to FrankW for the tip ;-)
>  > >  > >
>  > >  > > Thanks Even / Frank.
>  > >  > >
>  > >  > >  One small problem:
>  > >  > >
>  > >  > >
>  > >  > >
>  > >  > >  ogr2ogr -t_srs '+proj=latlong +datum=WGS84' \
>  > >  > >  -f GPX -dsco GPX_USE_EXTENSIONS=YES \
>  > >  > >
>  > >  > > veg_points.gpx veg_points.shp \
>  > >  > >  -sql "SELECT cat AS foo FROM veg_points"
>  > >  > >
>  > >  > >  ERROR 1: SQL: Missing comma after column cat in SELECT statement.
>  > >  > >
>  > >  > >  Could this be a bug or my version of GDAL too old ? This is with
>  > >  > > GDAL SVN, checked out a couple of weeks ago.
>  > >  > >
>  > >  > >  I get a valid GPX file if I do not use the "AS foo" operator.
>  > >  > >
>  > >  > >  Ideas?
>  > >  > >
>  > >  > >
>  > >  > >  Dylan
>  > >  > >
>  > >  > >  > Le Monday 03 March 2008 19:43:12 Even Rouault, vous avez écrit :
>  > >  > >  > > Hi,
>  > >  > >  > >
>  > >  > >  > > I see your point...
>  > >  > >  > >
>  > >  > >  > > The solution is the powerful OGR Virtual Dataset format !
>  > >  > >  > > See http://www.gdal.org/ogr/drv_vrt.html
>  > >  > >  > >
>  > >  > >  > > In fact, the documentation should probably be extended to
>  > >  > >  > > demonstrate the power of the OGR SQL for that particular case
>  > >  > >  > >
>  > >  > >  > > Try to paste the following lines in a file (remapped_layer.vrt
>  > >  > >  > > would be fine)
>  > >  > >  > >
>  > >  > >  > > <OGRVRTDataSource>
>  > >  > >  > >     <OGRVRTLayer name="remapped_layer">
>  > >  > >  > >         <SrcDataSource>your_source.shp</SrcDataSource>
>  > >  > >  > >         <SrcSQL>SELECT src_field_1 AS name, src_field_2 AS desc
>  > >  > >  > > FROM your_source_layer_name</SrcSQL>
>  > >  > >  > >     </OGRVRTLayer>
>  > >  > >  > > </OGRVRTDataSource>
>  > >  > >  > >
>  > >  > >  > > Replace your_source.shp, src_field_1, src_field_2 and
>  > >  > >  > > your_source_layer_name by the appropriate values from your
>  > >  > >  > > source dataset and 'ogrinfo -ro -al remapped_layer.vrt' should
>  > >  > >  > > show a structure compatible of a GPX file.
>  > >  > >  > >
>  > >  > >  > > Best regards,
>  > >  > >  > > Even
>  > >  > >  > >
>  > >  > >  > > Le Monday 03 March 2008 07:04:41 Dylan Beaudette, vous avez
>  écrit :
>  > >  > >  > > > Hi,
>  > >  > >  > > >
>  > >  > >  > > > is there a simple approach (via ogr2ogr) to create GPS files
>  > >  > >  > > > which have standard waypoint tags such as <name>, <elev>,
>  > >  > >  > > > <cmt>, etc. by re-mapping columns in the attribute table of
>  > >  > >  > > > the source vector?
>  > >  > >  > > >
>  > >  > >  > > > for example:
>  > >  > >  > > >
>  > >  > >  > > > # export points vector from GRASS
>  > >  > >  > > > v.out.ogr in=wp type=point dsn=wp.shp
>  > >  > >  > > >
>  > >  > >  > > > # convert tp GPX:
>  > >  > >  > > > ogr2ogr -t_srs '+proj=latlong +datum=WGS84' \
>  > >  > >  > > > -f GPX -dsco GPX_USE_EXTENSIONS=YES \
>  > >  > >  > > > wp_gps.gpx wp.shp
>  > >  > >  > > >
>  > >  > >  > > > This results in a working GPX waypoints file, that when
>  > >  > >  > > > uploaded to a GPS is functional, but the waypoints are all
>  > >  > >  > > > re-named sequentially. Note that I am uploading the GPX file
>  > >  > >  > > > the GPS via gpsbabel.
>  > >  > >  > > >
>  > >  > >  > > > Does anyone know of the appropriate incantation that one
>  > >  > >  > > > could use to translate the column structure of the input
>  > >  > >  > > > wp.shp (i.e. the stuff in its .dbf) into standard waypoint
>  > >  > >  > > > tags?
>  > >  > >  > > >
>  > >  > >  > > > thanks in advance!
>  > >  > >  > > >
>  > >  > >  > > > PS: trying to write a simple tutorial for some colleagues [1]
>  > >  > >  > > >
>  > >  > >  > > > 1. http://casoilresource.lawr.ucdavis.edu/drupal/node/553
>  > >  > >  > >
>  > >  > >  > > _______________________________________________
>  > >  > >  > > gdal-dev mailing list
>  > >  > >  > > gdal-dev at lists.osgeo.org
>  > >  > >  > > http://lists.osgeo.org/mailman/listinfo/gdal-dev
>  > >  > >
>  > >  > > --
>  > >  > >  Dylan Beaudette
>  > >  > >  Soil Resource Laboratory
>  > >  > >
>  > >  > > http://casoilresource.lawr.ucdavis.edu/
>  > >  > >
>  > >  > > University of California at Davis
>  > >  > >  530.754.7341
>  > >  > >  _______________________________________________
>  > >  > >
>  > >  > > gdal-dev mailing list
>  > >  > >  gdal-dev at lists.osgeo.org
>  > >  > >  http://lists.osgeo.org/mailman/listinfo/gdal-dev
>  > >
>  > > --
>  > >
>  > > Dylan Beaudette
>  > >  Soil Resource Laboratory
>  > >  http://casoilresource.lawr.ucdavis.edu/
>  > >  University of California at Davis
>  > >  530.754.7341
>
>
>
>
> --
>
> Dylan Beaudette
>  Soil Resource Laboratory
>  http://casoilresource.lawr.ucdavis.edu/
>  University of California at Davis
>  530.754.7341
>