system('sudo gem install GeoRuby')
system('git clone git://github.com/fragility/spatial_adapter.git')
 
$:.unshift(File.join(File.dirname(__FILE__), 'spatial_adapter', 'lib'))
 
require "rubygems"
require "active_record"
 
ActiveRecord::Base.establish_connection(
  :adapter => "postgresql",
  :host => "localhost",
  :database => "veitnam_development",
  :username => "sabman",
  :password => ""
)
 
# These should be added AFTER the AR connection is established otherwise you will get 
# "uninitialized constant ActiveRecord::..." error
require "post_gis_adapter"
require "geo_ruby"
 
class Poi < ActiveRecord::Base
end
 
# create a postgis database
system('createdb  -T template_postgis vietnam_development')
 
# convert shapefile to sql 
system('shp2pgsql -s 4326 -g geom pois.shp pois > pois.sql')
 
# change encoding to correct format - get script from https://gist.github.com/e658eb1df6f085d68352
system('convert_encoding.rb -f latin1 pois.sql')
 
# load the data in postgresql
system('psql -f pois.sql -d vietnam_development')