--- a/maxious-canberra-transit-feed/04-generateymlinclude.rb
+++ b/maxious-canberra-transit-feed/04-generateymlinclude.rb
@@ -1,1 +1,38 @@
+#!/usr/bin/ruby
+require 'postgres'
 
+require 'highline.rb'
+include HighLine
+
+require 'rubygems'
+require 'json'
+require 'yaml'
+require 'pp'
+# make - { name: Civic Interchange Platform 1,stop_code: civic_platform_1, lat: -35.2794347, lng: 149.130588}
+connbus = PGconn.connect("localhost", 5432, '', '', "bus", "postgres", "snmc")
+
+f = File.open('cbrtable.yml.in.in')
+header = f.readlines
+f.close
+
+File.open('cbrtable.yml.in', 'w') do |f2|  
+	f2.puts header
+	f2.puts "stops:\n";
+	begin
+		time_points = connbus.exec("SELECT * from timing_point")
+	rescue PGError => e
+		puts "Error reading from DB #{e}"
+		#conn.close() if conn
+	end
+	time_points.each do |time_point|
+		#pp time_point
+		# 0 = name
+
+		# 1 = lat*100000
+		# 2 = lng*100000
+		f2.puts "  - { name: #{time_point[0]},stop_code: #{time_point[0]}, lat: #{Float(time_point[1])/10000000}, lng: #{Float(time_point[2])/10000000}}"
+	end
+	f2.puts "routes:\n";
+end
+
+