cbick/gtfs_SQL_importer — pull request #3 by atogle (2011-12-19 18:34:18+00:00)
Title: Add PostGIS support

Hello again,
First, I updated the scripts so that all of the prefixes are `gtfs_`. Some where `gtf_`. I'm not sure if you had a good reason for that but I couldn't figure it out. =) But more importantly...

I added gtfs_tables_makespatial.sql to add PostGIS support. This basically adds a `the_geom` column to `gtfs_stops` and makes a new `gtfs_shape_geoms` that has a `shape_id` and `the_geom` columns, and mirrors `gtfs_shapes` but much fewer rows (only 1 per trip).

Finally, I converted the README to markdown so I could read it better, rearranged a few things, and added PostGIS docs.

I hope this is useful for you. It certainly is for me!