Schlagwörter: ,

Ansicht von 15 Beiträgen - 46 bis 60 (von insgesamt 61)
  • Autor
    Beiträge
  • #28650

    cebewee
    Teilnehmer

    The poi positions are stored in the poi_index table; the poi_index_node, poi_index_rowid, poi_index_parent tables are just an artifact of the poi_index table using an R*Tree index. See https://www.sqlite.org/draft/rtree.html.

    That means, all the information you need can be obtained by quering the poi_index table. The tables poi_index_node and so on can be safely ignored.

    #29188

    YPNA
    Teilnehmer

    I made some progress with my pet project – adding geocaches to a Locus POI database.
    The tools used were a Powershell script to generate points and the Spatialite GUI to load them into a Locus POI database.
    I was, at this stage, interested in finding out if I could make Locus show an icon of choice. While I failed with this one, I found that the icon is determined by the value selected from the FoldersSub table regardless of what value I select from the FoldersRoot table. Both of these values are associated with a point via an entry in the Points_Root_Sub table.
    I also found that there must be at least one entry in the Points_Key_Value table for the point to be usable in the Locus dialogs. It does not matter which combination is selected.
    The folowing Powershell script generates the 13 times 77 points representing all combinations of FoldersRoot and FolderSub values. The values I selected for the Points_Key_Value represent a URL. The location is calculated from the root and sub values. Please refer to the attached screenshot for the result.

    [/crayon]

    In my case, I needed to reformat the output file to remove the BOM. Otherwise, the Spacialite GUI program throws up when it tries to process the file.
    BTW… I could also create an empty DB using the Spacialite GUI program. After some fiddling around with the table contents I was able to display my points in Locus, too. The fiddling involved copying some of the metadata tables over from the Locus POI DB.
    Hope this helps to progress things… with the approaches shown above for extracting points from an OSM POI DB it is a piece of cake to add them to your homemade POI DB… if you find a suitable icon or if you are happy with the default icon (which ma be OK if you only have one category that does not fit into the Locus world).

    #31105

    mictie
    Teilnehmer

    @gaouargas:
    Thank you for providing the kml/kmz-extraction program!
    It’s working almost perfectly under W10 / 64 and I am able to extract the POIs of interest.
    The only thing which is not working is the ‚restriction to gepgraphical map‘. It seem that the web-map can not be accessed. Instead of a map, I just see the message the the remote server returned an error 403. (see attachment).
    It would be great if you could fix this (after a very loooong time) …
    Thank you!

    Anhänge:
    #31181

    Gaouargas
    Teilnehmer

    @mictie
    Thanks for your return.
    I think that there is a problem with the library which access to the map.
    I will have a look on it. Stay tuned ;-).

    #31196

    Gaouargas
    Teilnehmer

    @mictie
    Try this new version : https://drive.google.com/open?id=1se4dz1VTwB_MMmzF-3jWscGel6HiYhrI.
    Attention, all map providers do not work. But OpenStreetMap and GoogleMap are OK.
    Say me what.
    Thanks.

    #31205

    mictie
    Teilnehmer

    Thank you!
    I am currently travelling with no PC access, and will only be able to test it next weekend.

    #31306

    mictie
    Teilnehmer

    @gaouargas
    I was able to test the new program, and it’s working – Thank you!!!
    Google Maps, Bing Maps, OpenCycle Maps, WikiMapia Map, Yandex and possible others are working fine.
    OpenStreetMaps tells me that they don’t have imagery at this zoom level (I am looking at Singapore / Malaysia / Indonesia.)

    Thank you again for updating this very useful program!

    #31601

    juergenl
    Teilnehmer

    I made a python script that can convert the OpenAndroMaps POI fies into the format that is used by Locus.
    You can find it here: https://github.com/lieblerj/poi_converter

    #31606

    mictie
    Teilnehmer

    @juergenl: Thank you – looks very interesting!
    Question1: when trying I get this error message: „spatialite.connection.LoadExtensionError: Failed to load SpatiaLite extension. Verify that your python module sqlite3 has load_extension support and check that libspatialite is installed. Tried extension names: mod_spatialite, mod_spatialite.so, mod_spatialite.dylib“
    It seems I am missing something (running it on Win10/64)
    Question2: do you prefer questions here or via github?
    Thanks!

    #31609

    mictie
    Teilnehmer

    @juergenl: Problem solved! had to install libspatialite via System32…

    #31611

    juergenl
    Teilnehmer

    Thanks for pointing out, i think i need the installation section needs some additional details.
    Regarding Question 2: General topics can be discussed here for issues and observations with the code i would recommend github.

    #31621

    mictie
    Teilnehmer

    @juergenl: I have done some tests and it’s working – thank you!

    It seems that the information per POI is reduced quite a lot. Eg. I don’t see opening-hours, or bus-lines (for bus-stops) … here, although this information is included in the original OAM-poi-file.
    Is there a chance you can include the complete info into the database, or give me some hint how to do it?

    #31625

    juergenl
    Teilnehmer

    @mictie: Currently i include only those tags that are in the TagKeys table (see config/init.sql line 153++ for the values). Opening-hours should be included, bus-lines are not.
    Please submit an issue on github with a link to an OAM-poi-file and some POI so i can have a look.

    #31628

    mictie
    Teilnehmer

    Thanks for the quick reply!
    Sorry, I was wrong about ‚opening hours‘ and manged to include bus-lines (route_ref) – it’s working!

    There is one issue which seems to be related either to Locus or OAM: The POIs also include a link to ‚More on openstreetmap.org‘ which seems to wrong for POIs coming from OAM.poi-files. (I tried a couple of locations both in Austria as well as in Singapore).
    When using different map-sources (.osm converted to .pbf) these links look ok.
    No idea if these links are part of the db or generated by Locus…

    #31630

    juergenl
    Teilnehmer

    @mictie: I could not find any source for this special link in the database file. I think the link is automatically added by Locus itself.

Ansicht von 15 Beiträgen - 46 bis 60 (von insgesamt 61)

Du musst angemeldet sein, um auf dieses Thema antworten zu können.