Logstash geo_point


#1

Hello,

I want to create a geographical coordinate map. Can you please help me guide through the process of creating the geo_point or any other way to create coordinate map. I have tried the option from some website. I request you to please help me with step by step process to create geo_point in elastic search using logstash.

Thank you.


(Christian Dahlqvist) #2

Have you gone through this blog post?


#3

Yes i did, but i am not able to understand how to do it ?

I have inserted the csv file before using logstash to elastic search but i am facing problem for geo_point.

Thank you for reply


(Christian Dahlqvist) #4

What does your data look like? What have you done so far?


#5

image
This is how my data is for 8087 records.

image
This is my config file saved at bin folder of logstash

And finally with command prompt added a command "logstash -f configfile.conf"


This is how my output is finally


(Christian Dahlqvist) #6

Please do not paste images of text when you instead can copy and paste them. They are often very hard to read.

Have you created an index template for your index where you map geoip.location as a geo_point type?


#7

Ok sorry for the images i didn't knew about it.

I dont know how to create index template ?
I tried doing this... I dont know whether it is correct or not ?
PUT earthquakes
{
"mappings": {
"_doc": {
"properties": {
"location": {
"type": "geo_point"
}
}
}
}
}


#8

When i check GET earthquakes i get
{
"earthquakes": {
"aliases": {},
"mappings": {
"_doc": {
"properties": {
"location": {
"type": "geo_point"
}
}
}
},
"settings": {
"index": {
"creation_date": "1537524951689",
"number_of_shards": "5",
"number_of_replicas": "1",
"uuid": "b08DMd7MSYeon8rE-jKM2w",
"version": {
"created": "6040099"
},
"provided_name": "earthquakes"
}
}
}
}

Please help. Thank you.


#9

Can any one guide me with step by step creating of geopoint and inserting the long lat csv file to the elastic search. Or how to create coordinate map in kibana step by step from start to end.


(Magnus Bäck) #10

Your mappings look fine. What does an example document stored in ES look like? Copy/paste from Kibana's JSON tab to get the raw JSON document.


#11

Can you please elaborate. Do you need the csv data ? I am new for creating the geo_point so i am finding difficult to understand the point. And i am using windows ELK.


(Magnus Bäck) #12

If I see what a document stored in ES looks like I can compare it your mappings to make sure everything is aligned.


#13
time latitude longitude depth_km magnitude
36:32.0 42.6983 13.2335 8.1 6
37:26.6 42.7123 13.2533 9 4.5
40:46.6 42.7647 13.1723 9.7 3.8
41:38.9 42.7803 13.1683 9.7 3.9
42:07.2 42.7798 13.1575 9.7 3.6
43:58.7 42.7298 13.2137 10.7 3.4
44:38.7 42.676 13.2858 10.8 2.7
44:56.4 42.6282 13.2648 10.6 3.2
46:12.2 42.7645 13.1777 6.6 3.7
46:46.0 42.7445 13.2097 12.4 2.8
47:51.5 42.6675 13.3238 6.5 3.3

This is how the data is in my csv file.


(Magnus Bäck) #14

That's not what I asked for. I don't care about the source document. I want to see what a single document stored in ES looks like.


#15

Sorry but how can i show you document ? i don't know how ?


(Magnus Bäck) #16

Locate the document in Kibana's Discover view. Expand the document so all fields can be seen. Switch to the JSON tab. Copy/paste the JSON text.


(system) #17

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