Kibana geopoints shown in wrong location

Hello,

I am trying to get Kibana to show me some points in a map. However, the points show up in the middle of the sea between Asia and North America when they should be in South America. The data comes in WKT from a PostGIS database. Here is the logstash conf file used.

 input {
jdbc {
    # Postgres jdbc connection string to our database, mydb
    jdbc_connection_string => "jdbc:postgresql://localhost:5432/gisdata"
    # The user we wish to execute our statement as
    jdbc_user => "user"
    jdbc_password => "pass"
    jdbc_validate_connection => true
    # The path to our downloaded jdbc driver
    jdbc_driver_library => "/home/mydir/postgresql-9.4.1202.jdbc42.jar"
    # The name of the driver class for Postgresql
    jdbc_driver_class => "org.postgresql.Driver"
    # our query
    statement => "select ST_AsText(geom) as geom, objectid"
}
}

output {
    elasticsearch {
            hosts => ["localhost:9200"]
            user => "elastic"
            password=>  "pass"
            index => "testings"
    }
stdout {
            codec => rubydebug {metadata =>true}
    }

After I create the mapping and set the attribute 'geom' to a geopoint, Kibana does show me the points and id's but in a different location. The points look like this

 POINT(-75.415861 -1.540444)

I've checked the coordinates in Wicket and they are fine.

Any help would be greatly appreciated.

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.