Creating address map with external data

[Sander Deryckere]

Hi,

In Flanders (region of Belgium), we have governmental address data we can use for OSM. However, the quality isn't perfect, and doesn't allow a simple data dump. So it's a manual process which will take long (most likely over 3 years, as the areas will get harder and less interesting)

So I thought about creating an address index for OsmAnd based on the data available (it won't be perfect, but it should be good enough to find 99% of the available addresses).

I downloaded all boundaries and place nodes from OSM via Overpass API, and transformed the governmental data into an OSM file with standard OSM addr:* tags (these nodes were given negative ids, so they don't collide with any existing nodes). Then I merged the two files.

Now, I want to run the OsmAndMapCreator, the first test I do is via the gui, but when I start to convert the file, I immediately get the following error:

Nov 23, 2015 7:06:30 PM net.osmand.osm.MapPoiTypes init
INFO: Time to init poi types 40
Nov 23, 2015 7:06:30 PM net.osmand.osm.MapRenderingTypes init
INFO: Time to init 130
Nov 23, 2015 7:06:30 PM net.osmand.swing.ExceptionHandler handle
SEVERE: Error in thread Thread-3
java.lang.UnsatisfiedLinkError: org.sqlite.core.NativeDB._open(Ljava/lang/String;I)V
    at org.sqlite.core.NativeDB._open(Native Method)
    at org.sqlite.core.DB.open(DB.java:161)
    at org.sqlite.core.CoreConnection.open(CoreConnection.java:145)
    at org.sqlite.core.CoreConnection.<init>(CoreConnection.java:66)
    at org.sqlite.jdbc3.JDBC3Connection.<init>(JDBC3Connection.java:21)
    at org.sqlite.jdbc4.JDBC4Connection.<init>(JDBC4Connection.java:23)
    at org.sqlite.SQLiteConnection.<init>(SQLiteConnection.java:45)
    at org.sqlite.JDBC.createConnection(JDBC.java:114)
    at org.sqlite.JDBC.connect(JDBC.java:88)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:270)
    at net.osmand.data.preparation.DBDialect.getDatabaseConnection(DBDialect.java:76)
    at net.osmand.data.preparation.IndexCreator.getDatabaseConnection(IndexCreator.java:158)
    at net.osmand.data.preparation.IndexCreator.createDatabaseIndexesStructure(IndexCreator.java:385)
    at net.osmand.data.preparation.IndexCreator.generateIndexes(IndexCreator.java:589)
    at net.osmand.data.preparation.IndexCreator.generateIndexes(IndexCreator.java:519)
    at net.osmand.swing.OsmExtractionUI$13.run(OsmExtractionUI.java:543)
    at net.osmand.swing.ProgressDialog$WorkerThread.run(ProgressDialog.java:87)

java.lang.UnsatisfiedLinkError: org.sqlite.core.NativeDB._open(Ljava/lang/String;I)V
    at org.sqlite.core.NativeDB._open(Native Method)
    at org.sqlite.core.DB.open(DB.java:161)
    at org.sqlite.core.CoreConnection.open(CoreConnection.java:145)
    at org.sqlite.core.CoreConnection.<init>(CoreConnection.java:66)
    at org.sqlite.jdbc3.JDBC3Connection.<init>(JDBC3Connection.java:21)
    at org.sqlite.jdbc4.JDBC4Connection.<init>(JDBC4Connection.java:23)
    at org.sqlite.SQLiteConnection.<init>(SQLiteConnection.java:45)
    at org.sqlite.JDBC.createConnection(JDBC.java:114)
    at org.sqlite.JDBC.connect(JDBC.java:88)
    at java.sql.DriverManager.getConnection(DriverManager.java:664)
    at java.sql.DriverManager.getConnection(DriverManager.java:270)
    at net.osmand.data.preparation.DBDialect.getDatabaseConnection(DBDialect.java:76)
    at net.osmand.data.preparation.IndexCreator.getDatabaseConnection(IndexCreator.java:158)
    at net.osmand.data.preparation.IndexCreator.createDatabaseIndexesStructure(IndexCreator.java:385)
    at net.osmand.data.preparation.IndexCreator.generateIndexes(IndexCreator.java:589)
    at net.osmand.data.preparation.IndexCreator.generateIndexes(IndexCreator.java:519)
    at net.osmand.swing.OsmExtractionUI$13.run(OsmExtractionUI.java:543)
    at net.osmand.swing.ProgressDialog$WorkerThread.run(ProgressDialog.java:87)

Does anyone have an idea how to solve this? I use Arch Linux with the following java version:

$ java -version

openjdk version "1.8.0_65"
OpenJDK Runtime Environment (build 1.8.0_65-b17)
OpenJDK Server VM (build 25.65-b01, mixed mode)

Thanks,

Sander

 

[Nils Wauschkuhn]

Hi,

For Berlin I have the same problem:

Exception in thread "main" java.lang.UnsatisfiedLinkError: org.sqlite.core.NativeDB._open(Ljava/lang/String;I)V

        at org.sqlite.core.NativeDB._open(Native Method)

        at org.sqlite.core.DB.open(DB.java:161)

        at org.sqlite.core.CoreConnection.open(CoreConnection.java:145)

        at org.sqlite.core.CoreConnection.<init>(CoreConnection.java:66)

        at org.sqlite.jdbc3.JDBC3Connection.<init>(JDBC3Connection.java:21)

        at org.sqlite.jdbc4.JDBC4Connection.<init>(JDBC4Connection.java:23)

        at org.sqlite.SQLiteConnection.<init>(SQLiteConnection.java:45)

        at org.sqlite.JDBC.createConnection(JDBC.java:114)

        at org.sqlite.JDBC.connect(JDBC.java:88)

        at java.sql.DriverManager.getConnection(DriverManager.java:571)

        at java.sql.DriverManager.getConnection(DriverManager.java:233)

        at net.osmand.data.preparation.DBDialect.getDatabaseConnection(DBDialect.java:58)

        at net.osmand.data.preparation.IndexCreator.getDatabaseConnection(IndexCreator.java:167)

        at net.osmand.data.preparation.IndexCreator.createDatabaseIndexesStructure(IndexCreator.java:456)

        at net.osmand.data.preparation.IndexCreator.generateIndexes(IndexCreator.java:660)

        at net.osmand.data.preparation.IndexCreator.generateIndexes(IndexCreator.java:589)

        at net.osmand.data.index.IndexBatchCreator.generateIndex(IndexBatchCreator.java:552)

        at net.osmand.data.index.IndexBatchCreator.generatedIndexes(IndexBatchCreator.java:464)

        at net.osmand.data.index.IndexBatchCreator.runBatch(IndexBatchCreator.java:307)

        at net.osmand.data.index.IndexBatchCreator.main(IndexBatchCreator.java:165)

It seems that OsmAndMapCreator has a bug.