script that takes the latest csv export of costar data in the downloads directory, converts to kml, and opens. see costar_vrt.vrt for the file necessary here. Must be hard-coded to to work in a different path.

convert_costar_export_to_kml.rb

latest_download = Dir.glob("/Users/daviddouglas/Downloads/Export*.csv").max do |a,b| 
  File.ctime(a) <=> File.ctime(b)
end
puts "latest download is #{latest_download}"
`cp #{latest_download} /Users/daviddouglas/sikuli_scripts`
basename = File.basename(latest_download)
`mv #{basename} costar_data.csv`
`ogr2ogr -f KML costar_data.kml costar_vrt.vrt`
`open costar_data.kml`
`say "save the KML somewhere else to prevent from being overwritten"`