loader.rb

require 'nokogiri'
require 'yaml'

kml_path = File.join(File.dirname(__FILE__), 'FloodLine_x5.kml')

File.open(kml_path) do |f|
  kml = Nokogiri::XML(f)
  kml.xpath('//ns:MultiGeometry', {'ns' => "http://www.opengis.net/kml/2.2"}).each do |polygon|
    escaped_geometry = con.escape_string(polygon.to_s)
    con.exec "INSERT INTO flood_zones VALUES( ST_GEOMFROMKML('#{escaped_geometry}') )"
  end
end