--- a/transitdata.sql
+++ b/transitdata.sql
@@ -1,1 +1,59 @@
+--
+-- PostgreSQL database dump
+--
 
+SET statement_timeout = 0;
+SET client_encoding = 'UTF8';
+SET standard_conforming_strings = off;
+SET check_function_bodies = false;
+SET client_min_messages = warning;
+SET escape_string_warning = off;
+
+SET search_path = public, pg_catalog;
+
+SET default_tablespace = '';
+
+SET default_with_oids = false;
+
+--
+-- Name: trips; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
+--
+
+CREATE TABLE trips (
+    route_id integer,
+    trip_id integer NOT NULL,
+    trip_headsign text,
+    service_id text
+);
+
+
+ALTER TABLE public.trips OWNER TO postgres;
+
+--
+-- Data for Name: trips; Type: TABLE DATA; Schema: public; Owner: postgres
+--
+
+COPY trips (route_id, trip_id, trip_headsign, service_id) FROM stdin;
+\.
+
+
+--
+-- Name: trips_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
+--
+
+ALTER TABLE ONLY trips
+    ADD CONSTRAINT trips_pkey PRIMARY KEY (trip_id);
+
+
+--
+-- Name: routetrips; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
+--
+
+CREATE INDEX routetrips ON trips USING btree (route_id);
+
+
+--
+-- PostgreSQL database dump complete
+--
+
+