Can not upload csv with coordinates to kibana

Elastic Stack Kibana
1

Greetings!

Hope you are well, I am trying to add this csv data to Elastic but throws error on every single line I try to add. I am loading it from ML / DataVisualizer, I have read documentation but I can´t see where is the error.

Error on every line:
0: failed to parse field [latitude] of type [geo_point]

MOCK DATA CSV file:

5/10/2016,1,Kaiser,Davidovics,kdavidovics0@yahoo.com,Male,013XX S SAWYER AVE,BATTERY,DOMESTIC BATTERY SIMPLE,APARTMENT,TRUE,TRUE,A,5,59.6313435,39.72516
5/10/2016,2,Shauna,Coultas,scoultas1@seattletimes.com,Female,061XX S DREXEL AVE,BATTERY,DOMESTIC BATTERY SIMPLE,RESIDENCE,FALSE,TRUE,A,,-15.3612378,-70.3628516
5/10/2016,3,Rebeka,Bigg,rbigg2@issuu.com,Female,053XX W CHICAGO AVE,PUBLIC PEACE VIOLATION,RECKLESS CONDUCT,STREET,FALSE,FALSE,A,,37.9854094,23.7419512
5/10/2016,4,Kalila,Wolfendell,kwolfendell3@ucla.edu,Female,049XX W FULTON ST,BATTERY,SIMPLE,SIDEWALK,FALSE,FALSE,A,,47.1792078,9.5678116

Mapping:

{
  "Arrest": {
    "type": "keyword"
  },
  "Block": {
    "type": "text"
  },
  "Date": {
    "type": "keyword"
  },
  "Description": {
    "type": "text"
  },
  "Detention Time": {
    "type": "long"
  },
  "Domestic": {
    "type": "keyword"
  },
  "Group": {
    "type": "keyword"
  },
  "Location Description": {
    "type": "keyword"
  },
  "Primary Type": {
    "type": "keyword"
  },
  "email": {
    "type": "keyword"
  },
  "first_name": {
    "type": "keyword"
  },
  "gender": {
    "type": "keyword"
  },
  "id": {
    "type": "long"
  },
  "last_name": {
    "type": "keyword"
  },
  "latitude": {
    "type": "geo_point"
  },
  "longitude": {
    "type": "geo_point"
  }
}

I will appreciate any help you can give me!

Thanks in advance!

2

Check the geo_point type here
You should merge latitude & longitude
For example your CSV can be like this

5/10/2016|1|Kaiser|Davidovics|kdavidovics0@yahoo.com|Male|013XX S SAWYER AVE|BATTERY|DOMESTIC BATTERY SIMPLE|APARTMENT|TRUE|TRUE|A|5|59.6313435,39.72516
5/10/2016|2|Shauna|Coultas|scoultas1@seattletimes.com|Female|061XX S DREXEL AVE|BATTERY|DOMESTIC BATTERY SIMPLE|RESIDENCE|FALSE|TRUE|A||-15.3612378,-70.3628516
5/10/2016|3|Rebeka|Bigg|rbigg2@issuu.com|Female|053XX W CHICAGO AVE|PUBLIC PEACE VIOLATION|RECKLESS CONDUCT|STREET|FALSE|FALSE|A||37.9854094,23.7419512
5/10/2016|4|Kalila|Wolfendell|kwolfendell3@ucla.edu|Female|049XX W FULTON ST|BATTERY|SIMPLE|SIDEWALK|FALSE|FALSE|A||47.1792078,9.5678116

Or use an ingest processor to define your geo_point

{
   "set":{
      "field":"position",
      "value":"{{latitude}},{{longitude}}"
   }
}
1 Like
3

Thank you! :smiley:

4

thx @4T14S @ylasri

Short FYI related to this:

Uploading .csv with points will be supported automatically (without requiring manual config) when 7.10 version of the stack will be released. https://github.com/elastic/kibana/issues/76996

2 Likes
5

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