Need to populate geo location based on US State name column using logstash,es and kibi

Construct a text file (e.g. a CSV) that maps state names to lat/lon values, then use the translate filter to look up the state name field.