Sillson

-- Create the table
CREATE TABLE IF NOT EXISTS `StateBoundaries` (
  `State` varchar(10) DEFAULT NULL,
  `Name` varchar(255) DEFAULT NULL,
  `MinLat` varchar(50) DEFAULT NULL,
  `MaxLat` varchar(50) DEFAULT NULL,
  `MinLon` varchar(50) DEFAULT NULL,
  `MaxLon` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Sillson

Libraries for a modern geospatial workflow

Distribution

• Writing, Running, and Distributing
• Tox driven development
• Publishing python libraries

Numpy

Sillson

# lib/tasks/db.rake
namespace :db do

  desc "Dumps the database to db/APP_NAME.dump"
  task :dump => :environment do
    cmd = nil
    with_config do |app, host, db, user|
      cmd = "pg_dump --host #{host} --username #{user} --verbose --clean --no-owner --no-acl --format=c #{db} > #{Rails.root}/db/#{app}.dump"
    end
    puts cmd