Skip to content
This repository


Subversion checkout URL

You can clone with HTTPS or Subversion.

Download ZIP

A dispatching and ride coordination tool created originally for RideConnection.

This branch is 0 commits ahead and 0 commits behind master

Fetching latest commit…


Cannot retrieve the latest commit at this time

Octocat-spinner-32 app
Octocat-spinner-32 config
Octocat-spinner-32 db
Octocat-spinner-32 doc
Octocat-spinner-32 lib
Octocat-spinner-32 public
Octocat-spinner-32 script
Octocat-spinner-32 spec
Octocat-spinner-32 test
Octocat-spinner-32 vendor
Octocat-spinner-32 .gitignore
Octocat-spinner-32 .rspec
Octocat-spinner-32 Capfile
Octocat-spinner-32 Gemfile
Octocat-spinner-32 Gemfile.lock
Octocat-spinner-32 LICENSE
Octocat-spinner-32 README
Octocat-spinner-32 Rakefile
RidePilot is a paratransit trip scheduling application. 

RidePilot is a project of Ride Connection, a Portland-area community
transpotation provider.  It is primarily written by hackers at


To set up postgres for use with RidePilot, you will need the
fuzzystrmatch library (included in postgresql-contrib-8.4 in Ubuntu),
and postgis.  This adds support for dmetaphone, which is how we
phonetically match names.  Run psql and then the following commands:

-- Create a new database
CREATE DATABASE template_postgis;

-- Make it a template database
UPDATE pg_database SET datistemplate = TRUE WHERE datname = 'template_postgis';

-- Connect to new database and install the pl/pgsql language
\c template_postgis


-- Install PostGIS (your file paths may vary)
\i /opt/local/share/postgresql84/contrib/postgis-1.5/postgis.sql 
\i /opt/local/share/postgresql84/contrib/postgis-1.5/spatial_ref_sys.sql
GRANT ALL ON geometry_columns TO PUBLIC;
GRANT ALL ON geography_columns TO PUBLIC;
GRANT ALL ON spatial_ref_sys TO PUBLIC;

-- vacuum freeze: it will guarantee that all rows in the database are
-- "frozen" and will not be subject to transaction ID wraparound
-- problems.

-- You'll also want to set up the fuzzy string matching functions

\i /opt/local/share/postgresql84/contrib/fuzzystrmatch.sql 


make sure your database.yml contains the line:

  template: template_postgis

in the section named common: &common

Then do rake db:create


You will also need ImageMagick (for no good reason, but Paperclip,
which we use for attachments, requires it)
Something went wrong with that request. Please try again.