Winfried wrote: < Hello, < < I need to importe a GPX file that contains a few thousand waypoints, eg. < <wpt lat="41.37824" lon="9.21024"><name>Some name</name></wpt> < < I tried https://mygeodata.cloud and https://geoconverter.hsr.ch, but for < some reason, the "waypoints" table doesn't contain latitude + longitude < infos. < < Before I write a Python script, is there a simple way to import GPX data < into SQLite?
At this web page, https://www.gaia-gis.it/fossil/spatialite-tools/index , you can see a reference to an XML import facility, spatialite_xml_load , which is part of spatialite-tools. It is very generalized, and can be used to create a SQLite database from well-formed XML. Once you have a DB loaded with that tool, (which will be a several-years-old version of the SQLite3 file format, but readable by modern SQLite3), you can attach and query that DB to get the data into whatever DB schema you favor. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
