GPXRead
Signatures
GPXRead(VARCHAR path);
GPXRead(VARCHAR path, VARCHAR tableName);Description
Reads a GPX file from path and creates several tables
prefixed by tableName representing the file’s contents.
Which tables are produced depends on the content of the GPX file,
and may include:
TABLENAME_WAYPOINTTABLENAME_ROUTETABLENAME_ROUTEPOINTTABLENAME_TRACKTABLENAME_TRACKPOINTTABLENAME_TRACKSEGMENT
By default, the tableName is the filename given in path without
the extension.
Examples
-- Takes the table name from the filename, producing
-- * ROUTE_TRACK
-- * ROUTE_TRACKPOINT
-- * ROUTE_TRACKSEGMENT
CALL GPXRead('/home/user/route.gpx');
-- Uses the given table name, producing
-- * GPXDATA_TRACK
-- * GPXDATA_TRACKPOINT
-- * GPXDATA_TRACKSEGMENT
CALL GPXRead('/home/user/route.gpx', 'GPXDATA');
-- Produces STATION_WAYPOINT.
CALL GPXRead('/home/user/station.gpx');