porting to c++ and using sqlite about barefoot HOT 2 CLOSED

I think every DBMS solution will do. It's a benefit to use a DBMS with spatial extensions (geometry data structures, spatial index, etc.), but it's not really necessary as you could just store geometries as text (WKT). SpatialLite could be an option for you (https://www.gaia-gis.it/fossil/libspatialite/index). For the import of OSM data into the database, I would refer to Osmosis which is used in Barefoot (http://wiki.openstreetmap.org/wiki/Osmosis).

from barefoot.

Dear Sebastian,

special thanks for your answer.

the issue is I tried using spatialite. the functions are not as mature as
those postgis and this led to the point where I decided to directly use
SQLite.
but for the very basic requirement of finding the set of ways in a
predefined vicinity of a point, one may needed four consecutive queries to
be executed in order to find the list ways and their corresponding nodes.
and if you want to check the ways tags another querry is needed.

I also tried multithreaded access to the database but because of the shared
database it was not of much help.

so I was thinking if it is possible to find a solution in between!

Regards;

Milad Hasanvand

Connected Car System Designer @ AIRIC-SAIPA

http://airic-ir.com/

Automotive Industries Research & Innovation Center (AIRIC)
SAIPA Group

15th Km Karadj Makhsoos Rd., Tehran, Iran.
P.O. Box 13445/967
[email protected]
Mobile: +98 938 510 0152

On Mon, Sep 12, 2016 at 12:02 PM, Sebastian Mattheis <
[email protected]> wrote:

I think every DBMS solution will do. It's a benefit to use a DBMS with
spatial extensions (geometry data structures, spatial index, etc.), but
it's not really necessary as you could just store geometries as text (WKT).
SpatialLite could be an option for you (https://www.gaia-gis.it/
fossil/libspatialite/index). For the import of OSM data into the
database, I would refer to Osmosis which is used in Barefoot (
http://wiki.openstreetmap.org/wiki/Osmosis).

—
You are receiving this because you authored the thread.
Reply to this email directly, view it on GitHub
#28 (comment),
or mute the thread
https://github.com/notifications/unsubscribe-auth/AHOiouGeaNYN4AEOw1pBLf2_QHoh0pHIks5qpQAggaJpZM4J6EaX
.

from barefoot.