Kibana geopoints shown in wrong location

Elastic Stack Kibana
1

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.

2

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