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

        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
        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
        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 "

          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: