# Need to create a map in kibana by taking latitude and longitude from mysql db by logstash

**URL:** <https://discuss.elastic.co/t/need-to-create-a-map-in-kibana-by-taking-latitude-and-longitude-from-mysql-db-by-logstash/164296>\
**Category:** Elasticsearch\
**Created:** [January 15, 2019, 10:49am UTC](https://discuss.elastic.co/t/need-to-create-a-map-in-kibana-by-taking-latitude-and-longitude-from-mysql-db-by-logstash/164296 "2019-01-15T10:49:19Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![saroj.moharana](https://avatars.discourse-cdn.com/v4/letter/s/7bcc69/32.png) [@saroj.moharana](https://discuss.elastic.co/u/saroj.moharana)\
**Post date:** [January 15, 2019, 10:49am UTC](https://discuss.elastic.co/t/need-to-create-a-map-in-kibana-by-taking-latitude-and-longitude-from-mysql-db-by-logstash/164296/1 "2019-01-15T10:49:19Z")

</div>

Hi Team,

I have latitude and longitude information in my mysql db and I want to push these information to elastic-search and want to create a map in kibana by taking these values.  
I have browsed different discussion but unable to wrap it up.  
can you please provide proper steps to achieve this.  
my logstash configuration is as below :

input {  
jdbc {  
jdbc\_connection\_string =\> "jdbc:mysql://10.0.30.14:3306/p\_gw"  
jdbc\_user =\> "db\_user"  
jdbc\_password =\> "db\_password"  
# The path to our downloaded jdbc driver  
jdbc\_driver\_library =\> "C:/Users/saroj/Downloads/mysql-connector-java-5.1.46/mysql-connector-java-5.1.46/mysql-connector-java-5.1.46-bin.jar"  
jdbc\_driver\_class =\> "com.mysql.jdbc.Driver"  
# our query  
schedule =\> "\* \* \* \* \*"  
statement =\> "select si.latitude, si.longitude from pg\_master tm left join p\_ledger pl on tm.tran\_id=pl.gRefNumber left join pg\_store\_info si on pl.storeID=si.store\_id where tm.id \> :sql\_last\_value order by tm.id ASC limit 10000"  
use\_column\_value =\> true  
tracking\_column =\> id  
last\_run\_metadata\_path =\> "C:/elk/logstash-5.2.2/config/.last\_txn\_with\_loc\_run\_metadata\_path"  
}  
}  
filter {  
if [latitude] and [longitude] {  
mutate {  
# Location and lat/lon should be used as is, this is as per logstash documentation  
# Here we are tying to create a two-dimensional array in order to save data as per Logstash documentation  
add\_field =\> { "[location][lat]" =\> ["%{latitude}"] }  
add\_field =\> { "[location][lon]" =\> ["%{longitude}"] }  
convert =\> ["[location]", "float" ]  
}  
}  
mutate {  
add\_field =\> {  
"[@metadata][document\_id]" =\> "%{id}"  
}  
}  
}  
output {  
elasticsearch {  
hosts =\> ["localhost:9200"]  
index =\> "pgw-txn-loc"  
sniffing =\> true  
manage\_template =\> false  
document\_type =\> "data"  
document\_id =\> "%{[@metadata][document\_id]}"  
}  
stdout { codec =\> rubydebug }  
}

---

<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:** [February 12, 2019, 10:49am UTC](https://discuss.elastic.co/t/need-to-create-a-map-in-kibana-by-taking-latitude-and-longitude-from-mysql-db-by-logstash/164296/2 "2019-02-12T10:49:31Z")

</div>

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