[postgis-users] Import gpx files into Postgis db (windows)?

[James David Smith]

Thank you very much Nicholas. I will try this later. :-)

On Tue Nov 04 2014 at 10:21:14 Nicolas Ribot <nicolas.ribot at gmail.com>
wrote:

> Hi James,
>
> I don't know well the GPX format, but it seems several types of geo
> objects can be stored (waypoints, routes, tracks, route_points,
>  track_points).
> OGR will read each of these layers and create a postgis table for them:
>
> ogrinfo command lists the layers:
>
> $ ogrinfo sample.gpx
> Had to open data source read-only.
> INFO: Open of `sample.gpx'
>       using driver `GPX' successful.
> 1: waypoints (Point)
> 2: routes (Line String)
> 3: tracks (Multi Line String)
> 4: route_points (Point)
> 5: track_points (Point)
>
> (with -al -so switches, you get details of each layer)
>
> To load the file in a PG database:
>
> ogr2ogr -f PostgreSQL PG:"dbname=test" sample.gpx
>
> 5 tables corresponding to the layers will be created.
> The PG:"..." part is used to configure the database connection (port,
> username, password, ...)
>
> test=# \dt
>                Liste des relations
>  Schéma |       Nom       | Type  | Propriétaire
> --------+-----------------+-------+--------------
>  public | route_points    | table | nicolas
>  public | routes          | table | nicolas
>  public | spatial_ref_sys | table | nicolas
>  public | track_points    | table | nicolas
>  public | tracks          | table | nicolas
>  public | waypoints       | table | nicolas
> (6 lignes)
>
> Nicolas
>
> On 4 November 2014 10:52, James David Smith <james.david.smith at gmail.com>
> wrote:
>
>> Hi Nicolas,
>>
>> Thanks for pointing Dandrigo towards the GPX driver for GDAL - I
>> didn't know it existed to be honest so saw your reply with interest.
>> Would you mind, if possible, giving a sample line or two about how
>> someone could create a new table in PostGIS from the GPX please? The
>> examples in the documentation aren't that clear (or perhaps I just
>> don't understand them!).
>>
>> Regards
>>
>> James
>>
>> On 3 November 2014 08:06, Nicolas Ribot <nicolas.ribot at gmail.com> wrote:
>> > Hello,
>> >
>> > You can use GDAL/OGR, (ogr2ogr): http://www.gdal.org/drv_gpx.html
>> >
>> > Nicolas
>> >
>> > On 31 October 2014 18:32, dandrigo <lcelati at latitude-geosystems.com>
>> wrote:
>> >>
>> >> Dear all,
>> >>
>> >> I'm working with windows 8 & postgis 2.1.
>> >>
>> >> I have several gps (gpx) files. I would like to import directly those
>> gpx
>> >> files into my postgis database.
>> >>
>> >> What would be the easiest way?
>> >>
>> >> In advance, thank you to throw light for me.
>> >>
>> >> Regards.
>> >>
>> >>
>> >>
>> >>
>> >> --
>> >> View this message in context:
>> >>
>> http://postgis.17.x6.nabble.com/Import-gpx-files-into-Postgis-db-windows-tp5007255.html
>> >> Sent from the PostGIS - User mailing list archive at Nabble.com.
>> >> _______________________________________________
>> >> postgis-users mailing list
>> >> postgis-users at lists.osgeo.org
>> >> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>> >
>> >
>> >
>> > _______________________________________________
>> > postgis-users mailing list
>> > postgis-users at lists.osgeo.org
>> > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20141104/6863aed4/attachment.html>