# Logtstash not recognizing the columns created in Geojson format

**URL:** https://discuss.elastic.co/t/logtstash-not-recognizing-the-columns-created-in-geojson-format/208832
**Category:** Logstash
**Created:** [November 21, 2019, 8:47am UTC](https://discuss.elastic.co/t/logtstash-not-recognizing-the-columns-created-in-geojson-format/208832 "2019-11-21T08:47:22Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Ramya\_Tanikanti](https://avatars.discourse-cdn.com/v4/letter/r/9de053/32.png) [@Ramya\_Tanikanti](https://discuss.elastic.co/u/Ramya_Tanikanti)
#### Post date: [November 21, 2019, 8:47am UTC](https://discuss.elastic.co/t/logtstash-not-recognizing-the-columns-created-in-geojson-format/208832/1 "2019-11-21T08:47:22Z")

</div>

Hi, I have fields like A\_Latitude, A\_Longitude, B\_Latitude and B\_Longitude. I would like to make use of this data and create Maps in Kibana. **The problem is data is getting into elasticsearch, but the gejson columns created in Logstash filter not gettin recognized and data is not being fed into geo\_point1 and geo\_point2.**

Hence, first created a geo\_point mapping in Kibana dev tools as follows,  
PUT cc-test  
{  
"mappings": {  
"properties": {  
"geo\_point1":{  
"type": "geo\_point"  
},  
"geo\_point2":{  
"type": "geo\_point"  
}  
}  
}  
}

I have configured my logstash config file the following way,

```
input {
        jdbc {
        # Postgres jdbc connection string to our database, mydb
        jdbc_connection_string => "some string"
        # The user we wish to execute our statement as
        jdbc_user => "User"
        jdbc_password => "Password"
        # The path to our downloaded jdbc driver
        jdbc_driver_library => "/apps/ELK/logstash/driver/ngdbc-2.4.56.jar"
        jdbc_driver_class => "com.sap.db.jdbc.Driver"
         # our query
        #jdbc_validate_connection => true
        #schedule => "* * * * *"
        #record_last_run => true
        # last_run_metadata_path => "login.txt"
        statement => "SELECT
       inputdata.A_LATITUDE, inpudata.A_LONGITUDE, inputdata.B_LATITUDE, 
      inputdata.B_LONGITUDE, outputdata.BANDWIDTH, inputdata.SEQUENCEID, 
      inputdata.REQUESTTIMESTAMP
FROM inputdata, outputdata
WHERE
       inputdata.SEQUENCEID = outputdata.SEQUENCEID
       AND inputdata.REQUEST_TIMESTAMP >= '2019-01-01 00:00:00'
                    AND inputdata.SEQUENCEID IS NOT NULL
       AND inputdata.SEQUENCEID NOT IN ('N/A')
ORDER BY inputdata.SEQUENCEID DESC "
      # jdbc_paging_enabled => "true"
      # jdbc_page_size => "10000"
    }
}

filter {
mutate {
          convert => { "A_LONGITUDE" => "float" }
          convert => { "A_LATITUDE" => "float" }
          convert => { "B_LONGITUDE" => "float" }
          convert => { "B_LATITUDE" => "float" }
      }
mutate {
        rename => {
        "A_LONGITUDE" => "[geo_point1][lon]"
        "A_LATITUDE" => "[geo_point1][lat]"
  }
  }
mutate {
        rename => {
        "B_LONGITUDE" => "[geo_point2][lon]"
        "B_LATITUDE" => "[geo_point2][lat]"
  }
  }
}

output {
  elasticsearch {
    hosts => ["http://some server"]
    index => "cc-test"
    #document_type => "system_logs"
user => "Username"
password => "Password"
  }
  stdout { codec => rubydebug }
}

```

**Don't understand what is wrong with the Filter part and why data is not getting into the columns geo\_point1 and geo\_point2!!**  
Somebody please help 🙏🙏🙏

---

<div class="post-metadata">

### Author: ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)
#### Post date: [December 19, 2019, 8:47am UTC](https://discuss.elastic.co/t/logtstash-not-recognizing-the-columns-created-in-geojson-format/208832/2 "2019-12-19T08:47:32Z")

</div>

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