OBF to SQL

[Razvan Calugarasu]

Can I convert OBF to SQL?

[Harry van der Wolf]

No, you can't.

You can convert the basic osm.pbf format to sql though via several tools.

Harry

2014-03-04 8:56 GMT+01:00 Razvan Calugarasu <raku...@gmail.com>:

Can I convert OBF to SQL?

--
You received this message because you are subscribed to the Google Groups "Osmand" group.
To unsubscribe from this group and stop receiving emails from it, send an email to osmand+un...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

[Razvan Calugarasu]

I don't want to extract hole obf just address and poi part. Also it can be csv not just sql.

[Harry van der Wolf]

You asked the exact same question here a week ago: https://groups.google.com/forum/#!topic/osmand/3uTebvbSo40

And I gave you an answer.

Are you trolling this list? Then please leave.

Harry

[Razvan Calugarasu]

I know, but I've told you what I've did and you haven't replied to me:

I've tried but I think that the result is not corect. I get something like this:

 

D:\OSM\OsmAndMapCreator-main>java.exe -Djava.util.logging.config.file=logging.properties -Xms64M -Xmx512M -cp "./OsmAndMapCreator.jar;./lib/OsmAnd-core.jar;./lib/*.jar" net.osmand.binary.BinaryInspector -vaddress -vstreetgroups -vstreets maps\romania.obf      

Binary index romania.obf version = 2

1 Address data Romania-latest - 10233413 bytes

1.1 Address part size=5630946 bytes

1.3 Address part size=2219736 bytes

1.2 Address part size=506573 bytes

Cities/Towns section, 364 group(s):

'Alba Iulia' [422868186], 465 street(s) size 79380 bytes:

'A 10 (Section I)' [42915], 0 building(s), 2 intersections(s)

'A 10 Sebes-Turda: Alba Iulia Interchange' [43001], 0 building(s), 2 intersections(s)

'A 10 Sebes-Turda: Alba Iulia Nord Interchange' [43754], 0 building(s), 1 intersections(s)

'Aleea Baisoara' [33049], 0 building(s), 6 intersections(s)

'Aleea Cetinei' [39266], 0 building(s), 1 intersections(s)

....

 

When I make map what I need to select? Is enought  just Build Address index?

[Harry van der Wolf]

Sorry.

If you open that csv file inside OpenCalc or Excel, you will get a csv structured file.

The data is maybe not what you want, but in that case it is much better to:
- use the osm.pbf from download.geofabrik.de

- use osmconvert to convert it to the intermeidate speed-optimised o5m format

- use osmfilter to retrieve the address data into another o5m

- use osmconvert to convert the address.o5m to csv

You should not create a map first. The obf is a navigation optimised version of the osm data specifically for Osmand.
You better use the osm data as there are so many tools to retrieve data from that official format. You can even create your own postgres/gis database which will give you all the options you want.

Harry

--

[Razvan Calugarasu]

Thanks, I will try this.