search

bmwcarit / barefoot

Java map matching library for integrating the map into software and services with state-of-the-art online and offline map matching that can be used stand-alone and in the cloud.
Apache License 2.0
671 stars 183 forks source link

porting to c++ and using sqlite #28

Closed milad6506 closed 8 years ago

milad6506 commented 8 years ago

dear all i want to write a map matching software based on barefoot with c++ that works fine on embedded systems for an IVI module. i will publish it opensource along with its proper openembedded layer. the thing is that i am trying to choose a map database solution. does make sense to ddirectly use sqlite or should turn to something else? thank you all in advance

smattheis commented 8 years ago

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).

milad6506 commented 8 years ago

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 hasanvand.milad@airic-ir.com Mobile: +98 938 510 0152

On Mon, Sep 12, 2016 at 12:02 PM, Sebastian Mattheis < notifications@github.com> 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 https://github.com/bmwcarit/barefoot/issues/28#issuecomment-246269937, or mute the thread https://github.com/notifications/unsubscribe-auth/AHOiouGeaNYN4AEOw1pBLf2_QHoh0pHIks5qpQAggaJpZM4J6EaX .