CSV data enrichment with Geolocation

Hello, I am just starting with Elk stack and need a nudge in the right direction.
Is there a way to convert string address into a longitude and latitude coordinates and add them back to CSV file using Logstash? Or does it require usage of some sort of external API to convert data prior to uploading the file?
Any help is greatly appreciated.

You are describing a Geocoding service: Address to Geolocation

There is no such service as part of the Elastic Stack you will need to use a 3rd party service.

Thank you for your reply.
Is it possible to connect 3rd party service with a logstash directly to enrich CSV file or should it be formatted prior uploading it.
Size of the file can very from 5k to 50k entries (address).

Once again, thank you for your help.

It depends on the 3rd party service, Logstash has some filters that could be used to enrich documents while ingesting, for example the http filter enables you to query external REST services.

But in your case, do you know which service are you going to use? Does this kind of service has a REST API that you can configure to use with the http filter? You will need to check that.

Nothing specific in mind yet. Just trying to add geolocation to the existing CSV files to utilize Maps in Kibana. If anything, lead developer can write something tailored to this task, but I am trying to find an existing solution before resorting to development from ground up.

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