Uploaded image for project: 'Help-Desk'
  1. Help-Desk
  2. HELP-3394

FIWARE.Request.Tech.WebUI.POIDataProvider.POI_GE_and_OCDB_SE_2

    Details

    • Type: extRequest
    • Status: Closed
    • Priority: Major
    • Resolution: Done
    • Fix Version/s: 2021
    • Component/s: FIWARE-TECH-HELP
    • Labels:
      None
    • HD-Chapter:
      WebUI
    • HD-Enabler:
      POI Provider

      Description

      from: krishna.chandramouli@instronix.com

      Dear Ari Okkkonen,

      Following the earlier conversation, I have followed the steps provided in the tutorial of POI GE and have imported the OpenStreetMap data into the PSQL using osm2pgsql tool.

      I would be much grateful if you could clarify the following couple of points:
      1. The database tables created by osm2pgsql should be again imported into fw_core and fw_core_intl tables using the comamnd
      psql -U gisuser -d poidatabase -f insert_fw_core_from_osm.sql

      I have downloaded the OSM data from: http://download.geofabrik.de/ and the files are available as different regions, namely africa, antartica, asia etc.. As instructed in the readme file, I suppose during the import process, the region name should be appropriately used..

      2. As you have mentioned below, the POI GE uses MongoDB.. However, after following the installation steps my mongodb database is pretty much empty.. Just as an example, please find below the list of count values from different mongodb collections from poi_database

      the total size of poi_db is 0.203125GB

      > show collections
      fw_contact
      fw_marker
      fw_media
      fw_relationships
      fw_time
      system.indexes
      > db.fw_contact.count()
      1
      > db.fw_marker.count()
      1
      > db.fw_media.count()
      1
      > db.fw_relationships.count()
      1
      > db.fw_time.count()
      2

      Can you please confirm if any additional steps is required to export the psql data into mongodb or mongodb needs additional import??

      Many thanks,
      Krishna

        Activity

        Transition Time In Source Status Execution Times Last Executer Last Execution Date
        Open Open In Progress In Progress
        1m 50s 1 Ari Okkonen 22/Jun/15 10:17 AM
        In Progress In Progress Done Done
        4m 22s 1 Ari Okkonen 22/Jun/15 10:22 AM
        Done Done Closed Closed
        203d 23h 46m 1 Manuel Escriche 12/Jan/16 9:08 AM
        fla Fernando Lopez made changes -
        Fix Version/s 2021 [ 12600 ]
        mev Manuel Escriche made changes -
        HD-Enabler POI Provider [ 10898 ]
        HD-Chapter WebUI [ 10842 ]
        mev Manuel Escriche made changes -
        Workflow FW eRequest Workflow [ 32120 ] FW extRequest Workflow-II [ 40695 ]
        Status Done [ 10000 ] Closed [ 6 ]
        Issue Type eRequest [ 10101 ] extRequest [ 10104 ]
        mev Manuel Escriche made changes -
        Summary FIWARE.Request.Lab.WebUI.POIDataProvider.POI_GE_and_OCDB_SE_2 FIWARE.Request.Tech.WebUI.POIDataProvider.POI_GE_and_OCDB_SE_2
        Hide
        ariokkon Ari Okkonen added a comment -

        Name changed according to email from Manuel "Request for urgent action on the help-desk - deadline TODAY- 13:00 "

        Show
        ariokkon Ari Okkonen added a comment - Name changed according to email from Manuel "Request for urgent action on the help-desk - deadline TODAY- 13:00 "
        ariokkon Ari Okkonen made changes -
        Summary POI GE and OCDB SE (2) FIWARE.Request.Lab.WebUI.POIDataProvider.POI_GE_and_OCDB_SE_2
        ariokkon Ari Okkonen made changes -
        Resolution Done [ 10000 ]
        Status In Progress [ 3 ] Done [ 10000 ]
        Hide
        ariokkon Ari Okkonen added a comment -

        Dear Krishna Chandramouli,

        If you think that an enhanced importer would be of general interest,
        you might create an issue to [Fiware-tech-help].

        BR
        Ari Okkonen

        Show
        ariokkon Ari Okkonen added a comment - Dear Krishna Chandramouli, If you think that an enhanced importer would be of general interest, you might create an issue to [Fiware-tech-help] . BR Ari Okkonen
        ariokkon Ari Okkonen made changes -
        Field Original Value New Value
        Status Open [ 1 ] In Progress [ 3 ]
        Hide
        ariokkon Ari Okkonen added a comment -

        Dear Krishna Chandramouli,

        The available experimental importer handles few essential fw_core fields only.
        If you need some other fields, regrettably, you have to enhance the importer by
        yourself.

        BR
        Ari Okkonen

        Show
        ariokkon Ari Okkonen added a comment - Dear Krishna Chandramouli, The available experimental importer handles few essential fw_core fields only. If you need some other fields, regrettably, you have to enhance the importer by yourself. BR Ari Okkonen
        ariokkon Ari Okkonen created issue -

          People

          • Assignee:
            ariokkon Ari Okkonen
            Reporter:
            ariokkon Ari Okkonen
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: