Uploaded image for project: 'OpenNMS'
  1. OpenNMS
  2. NMS-9338

geo-coder creates invalid latitude/longitude in assets table

    Details

    • Sprint:
      Horizon - May 10th, Horizon - May 17th

      Description

      Samples:

      geocoder produced invalid latitude/longitude data in table assets.

        zip    |                     address1            | city   | latitude  | longitude
      ----------+----------------------------------------+--------+-----------+----------
       2415-026 | Regueira de Pontes, Fracção N, Nave 13 | Leiria | -Infinity | -Infinity
       2415-026 | Regueira de Pontes, Fracção N, Nave 13 | Leiria | -Infinity | -Infinity
       2415-026 | Regueira de Pontes, Fracção N, Nave 13 | Leiria | -Infinity | -Infinity
       2415-026 | Regueira de Pontes, Fracção N, Nave 13 | Leiria | -Infinity | -Infinity
       

      When using http://www.freegeocoding.com/batch.php the address results in
      39.7861962,-8.818807099999958

      This such entrys, the map-box.jsp freezes (see NMS-9339)

      Edit mvrueden:
      As mentioned in the comments below this is only affecting Horizon 19 and with backporting HZN-1016 to foundation-2017 this is solved at least for Meridian 2017 and possible next Horizon 19 releases. However a database update script should remove these entries from the database.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mvr Markus von Rüden
                Reporter:
                NoSt Norbert Steinhoff
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: