Search code examples
mongodbelasticsearchkibana-4

Geo location from mongodb to elasticsearch


mongo-connector is used to push the data from server which have geo location as

 "location":{
    "coordinates" : {
        "lon":-77.03653,
        "lat": 38.897676
      }
  }

changed the properties of location as

"properties" :{
      "location" :{
          "type": "object",
          "properties" :{
              "coordinates": {
                  "type" : "geo_point",
                  "geohash": "true",
                  "geohash_prefix": "true"
              }
           }
      }
}

data is getting populated but kibana is not displaying any data on "tile map"

Is there anything i am missing


Solution

  • As it is mentioned Geo-points cannot be automatically detected with dynamic mapping. Mapping of the data need to be created before inserting data to the database.

    curl -XPOST :9200/databasename -d'{
        "mappings": {
          "tablename": {
            "properties": {
              "geojson_field": {"type": "geo_point"}
            }
          }
        } }'
    

    please check in the github for furthur reading.