--
-- PostgreSQL database dump
--

-- Dumped from database version 9.6.11
-- Dumped by pg_dump version 11.3 (Ubuntu 11.3-1.pgdg14.04+1)

-- Started on 2020-01-08 15:45:28 PST

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 3047 (class 0 OID 7330879)
-- Dependencies: 186
-- Data for Name: route; Type: TABLE DATA; Schema: public; Owner: dispatch_predetermined_route
--

COPY public.route (id, created_at, updated_at, name, start_location_latitude, start_location_longitude, start_location_altitude_meters, end_location_latitude, end_location_longitude, end_location_altitude_meters, start_location_name, end_location_name, intermediate_locations) FROM stdin;
7e1064d3-4e62-4878-a56d-3389cb62a7ad	2018-10-11 01:03:59.65344	2019-09-26 23:32:16.860955	Embarcadero Route	37.798893203	-122.3991159396	\N	37.798893203	-122.3991159397	\N	60 Broadway Pickup	Embarcadero Route	{"latitude": 37.79781038661232, "longitude": -122.40095079260122}|{"latitude": 37.799224287909624, "longitude": -122.40238125172634}|{"latitude": 37.800416616149136, "longitude": -122.40175367013732}|{"latitude": 37.7993998825726, "longitude": -122.39800900371499}
75fc0857-80d3-4c41-ae40-e156a4c37fd9	2018-10-16 01:17:59.045696	2019-09-26 23:32:16.396528	Mini Challenge Route	37.798893203	-122.3991159396	\N	37.79888515368238	-122.39908048101738	\N	60 Broadway Pickup	Mini Challenge Route	{"latitude": 37.79601044830069, "longitude": -122.42165827020062}|{"latitude": 37.80145436251634, "longitude": -122.42288529232334}|{"latitude": 37.80208717435577, "longitude": -122.41854726490067}|{"latitude": 37.80267295438865, "longitude": -122.41405082057223}|{"latitude": 37.799678370004294, "longitude": -122.40934281718499}|{"latitude": 37.799674910111214, "longitude": -122.40754628331597}|{"latitude": 37.80239327566265, "longitude": -122.40795708397172}|{"latitude": 37.802359958021796, "longitude": -122.40937095334856}|{"latitude": 37.8005937926631, "longitude": -122.40925643563816}|{"latitude": 37.80080838026109, "longitude": -122.40617016107593}|{"latitude": 37.800055740621644, "longitude": -122.40589625350626}|{"latitude": 37.800070624883496, "longitude": -122.40446888719815}|{"latitude": 37.799319571753045, "longitude": -122.40412096129259}|{"latitude": 37.79964815534752, "longitude": -122.40022285951318}|{"latitude": 37.800490824578645, "longitude": -122.40022109912748}|{"latitude": 37.7993998825726, "longitude": -122.39800900371499}
981f93b2-c0e4-4e71-a2cf-0ef6569878c4	2018-08-21 22:00:04.622272	2018-08-21 22:00:04.622302	Yerba Buena	37.782465	-122.40073956404424	\N	37.782465	-122.40073956404424	\N	Moscone	Yerba Buena	{"latitude": 37.7837026065193, "longitude": -122.39917135004801}|{"latitude": 37.786111494495586, "longitude": -122.4018977429361}|{"latitude": 37.78525896478578, "longitude": -122.40869985763578}|{"latitude": 37.78530502204642, "longitude": -122.40926591456243}|{"latitude": 37.78442050542617, "longitude": -122.40888191498279}|{"latitude": 37.78040112842607, "longitude": -122.40363988158677}
bf322440-79a8-4a63-9c86-18115601de65	2018-10-11 01:34:11.936361	2018-10-11 01:36:32.730667	Loop Road	37.4180047113	-122.2061840515	\N	37.4180047113	-122.2061840514	\N	Loop Road Pickup	Loop Road	{"latitude": 37.4180356553, "longitude": -122.203641841}|{"latitude": 37.4199624109, "longitude": -122.202908787}|{"latitude": 37.4199524342, "longitude": -122.207403812}|{"latitude": 37.4176801561, "longitude": -122.207665416}
48d55e27-926b-4237-8a40-37c43e7e4a4d	2018-08-09 22:40:03.420777	2018-08-09 22:40:03.420797	Fairmont -> Moscone	37.792084	-122.41092454718924	\N	37.782465	-122.40073956404424	\N	Fairmont	Moscone	{"latitude": 37.791992829200964, "longitude": -122.41090436213032}|{"latitude": 37.78449516326019, "longitude": -122.4093512493075}|{"latitude": 37.78441171355935, "longitude": -122.40888629489777}|{"latitude": 37.78039251472394, "longitude": -122.40364915086754}
dd8ce396-1f13-4bbb-8ea7-25a3a0cc1d1c	2018-08-09 18:42:05.959773	2018-08-09 18:42:05.959797	Moscone -> Fairmont	37.782465	-122.40073956404424	\N	37.792344	-122.41091237551969	\N	Moscone	Fairmont	{"latitude": 37.783695659875825, "longitude": -122.39918224370241}|{"latitude": 37.78445666482034, "longitude": -122.39994832847272}|{"latitude": 37.78735855966883, "longitude": -122.40343417620102}|{"latitude": 37.79251017396247, "longitude": -122.40444903033561}|{"latitude": 37.791910521751, "longitude": -122.41066650396364}
abbd72a8-ca2b-4e22-a428-683d0095465a	2018-10-09 16:34:13.611944	2018-10-09 16:34:13.611972	Chess-92-Long	37.567814	-122.2723833809	\N	37.567941	-122.2722618209	\N	Chess-92-Long Pickup	Chess-92-Long	{"latitude": 37.567993, "longitude": -122.27490102030004}|{"latitude": 37.547527, "longitude": -122.3224201865563}
eaf759a4-efa1-428d-b363-6ed226c5045a	2018-08-02 22:53:57.238366	2018-10-11 01:48:00.235326	Pep Ring	37.4180047113	-122.2061840511	\N	37.4180047113	-122.206184051	\N	Pep Ring Pickup	Pep Ring	{"latitude": 37.4200729901, "longitude": -122.206202809}|{"latitude": 37.4196913402, "longitude": -122.197874852}|{"latitude": 37.4154142692, "longitude": -122.204263184}
10dd7305-7d64-45fa-a676-138cec58444d	2019-08-13 19:29:16.107234	2019-09-26 23:32:16.492128	Mini Challenge Route V2	37.798893203	-122.3991159396	\N	37.79888515368238	-122.39908048101738	\N	60 Broadway Pickup	Mini Challenge Route V2	{"latitude": 37.79601044830069, "longitude": -122.42165827020062}|{"latitude": 37.80145436251634, "longitude": -122.42288529232334}|{"latitude": 37.80208717435577, "longitude": -122.41854726490067}|{"latitude": 37.80267295438865, "longitude": -122.41405082057223}|{"latitude": 37.799678370004294, "longitude": -122.40934281718499}|{"latitude": 37.799674910111214, "longitude": -122.40754628331597}|{"latitude": 37.80080838026109, "longitude": -122.40617016107593}|{"latitude": 37.800055740621644, "longitude": -122.40589625350626}|{"latitude": 37.800070624883496, "longitude": -122.40446888719815}|{"latitude": 37.799319571753045, "longitude": -122.40412096129259}|{"latitude": 37.79964815534752, "longitude": -122.40022285951318}|{"latitude": 37.800490824578645, "longitude": -122.40022109912748}|{"latitude": 37.7993998825726, "longitude": -122.39800900371499}
a23fedf0-a002-4fe0-ac70-9368ebd1dac4	2018-10-11 01:06:47.761814	2019-09-26 23:32:16.551617	Coit Tower	37.7988932033	-122.3991159398	\N	37.7988932034	-122.3991159398	\N	60 Broadway Pickup	Coit Tower	{"latitude": 37.79924462620796, "longitude": -122.40243549887705}|{"latitude": 37.79920840528004, "longitude": -122.40385213134788}|{"latitude": 37.79995319168782, "longitude": -122.40421185516921}|{"latitude": 37.79996499922311, "longitude": -122.40572695302384}|{"latitude": 37.80049876516784, "longitude": -122.4075777304935}|{"latitude": 37.80345176770251, "longitude": -122.40800465461086}|{"latitude": 37.80292340267815, "longitude": -122.4059741870994}|{"latitude": 37.802442907764856, "longitude": -122.4096303505972}|{"latitude": 37.800386224392284, "longitude": -122.40987389185169}|{"latitude": 37.79970858772054, "longitude": -122.40938892765794}|{"latitude": 37.799319571753045, "longitude": -122.40412096129259}|{"latitude": 37.800490824578645, "longitude": -122.40022109912748}|{"latitude": 37.7993998825726, "longitude": -122.39800900371499}
23c68dd6-b72e-440c-b186-b019015f9120	2019-06-13 01:02:42.677205	2019-09-26 23:32:16.603818	Coit Tower V2	37.7988932033	-122.3991159398	\N	37.7988932034	-122.3991159398	\N	60 Broadway Pickup	Coit Tower V2	{"latitude": 37.79924462620796, "longitude": -122.40243549887705}|{"latitude": 37.79920840528004, "longitude": -122.40385213134788}|{"latitude": 37.79995319168782, "longitude": -122.40421185516921}|{"latitude": 37.79996499922311, "longitude": -122.40572695302384}|{"latitude": 37.80049876516784, "longitude": -122.4075777304935}|{"latitude": 37.80176853355493, "longitude": -122.40945466751513}|{"latitude": 37.80345176770251, "longitude": -122.40800465461086}|{"latitude": 37.80292340267815, "longitude": -122.4059741870994}|{"latitude": 37.802442907764856, "longitude": -122.4096303505972}|{"latitude": 37.800386224392284, "longitude": -122.40987389185169}|{"latitude": 37.79970858772054, "longitude": -122.40938892765794}|{"latitude": 37.799319571753045, "longitude": -122.40412096129259}|{"latitude": 37.800490824578645, "longitude": -122.40022109912748}|{"latitude": 37.7993998825726, "longitude": -122.39800900371499}
36330281-0c28-4157-95d8-4cabb1f512dd	2019-11-22 21:44:55.472659	2019-12-02 23:53:23.086996	Chess Challenge Route V2	37.798893203	-122.3991159396	\N	37.567737490755015	-122.27281413431157	\N	60 Broadway Pickup	Chess Challenge Route V2	{"latitude": 37.79601044830069, "longitude": -122.42165827020062}|{"latitude": 37.80145436251634, "longitude": -122.42288529232334}|{"latitude": 37.80208717435577, "longitude": -122.41854726490067}|{"latitude": 37.80267295438865, "longitude": -122.41405082057223}|{"latitude": 37.799678370004294, "longitude": -122.40934281718499}|{"latitude": 37.799674910111214, "longitude": -122.40754628331597}|{"latitude": 37.80239327566265, "longitude": -122.40795708397172}|{"latitude": 37.802359958021796, "longitude": -122.40937095334856}|{"latitude": 37.8005937926631, "longitude": -122.40925643563816}|{"latitude": 37.80080838026109, "longitude": -122.40617016107593}|{"latitude": 37.800055740621644, "longitude": -122.40589625350626}|{"latitude": 37.800070624883496, "longitude": -122.40446888719815}|{"latitude": 37.799319571753045, "longitude": -122.40412096129259}|{"latitude": 37.79964815534752, "longitude": -122.40022285951318}|{"latitude": 37.800490824578645, "longitude": -122.40022109912748}|{"latitude": 37.7993998825726, "longitude": -122.39800900371499}|{"latitude": 37.79888515368238, "longitude": -122.39908048101738}
28292386-52d4-4b36-8a34-28eefa38f2d9	2019-12-03 00:03:34.473426	2019-12-03 00:03:34.473449	Chess Challenge Route	37.798893203	-122.3991159396	\N	37.567941169583776	-122.27226182093209	\N	60 Broadway Pickup	Chess Challenge Route	{"latitude": 37.79601044830069, "longitude": -122.42165827020062}|{"latitude": 37.80145436251634, "longitude": -122.42288529232334}|{"latitude": 37.80208717435577, "longitude": -122.41854726490067}|{"latitude": 37.80267295438865, "longitude": -122.41405082057223}|{"latitude": 37.799678370004294, "longitude": -122.40934281718499}|{"latitude": 37.799674910111214, "longitude": -122.40754628331597}|{"latitude": 37.80239327566265, "longitude": -122.40795708397172}|{"latitude": 37.802359958021796, "longitude": -122.40937095334856}|{"latitude": 37.8005937926631, "longitude": -122.40925643563816}|{"latitude": 37.80080838026109, "longitude": -122.40617016107593}|{"latitude": 37.800055740621644, "longitude": -122.40589625350626}|{"latitude": 37.800070624883496, "longitude": -122.40446888719815}|{"latitude": 37.799319571753045, "longitude": -122.40412096129259}|{"latitude": 37.79964815534752, "longitude": -122.40022285951318}|{"latitude": 37.800490824578645, "longitude": -122.40022109912748}|{"latitude": 37.7993998825726, "longitude": -122.39800900371499}|{"latitude": 37.79888515368238, "longitude": -122.39908048101738}
ff34b6d4-8de1-44a3-a2c5-ce64c2eb2ece	2019-12-20 21:12:51.697404	2019-12-20 21:12:51.697426	Chess Drive	37.5687646901353	-122.273402335118	\N	37.56810911884719	-122.27419427799164	\N	Chess Backlot	Chess Drive	{"latitude": 37.568723, "longitude": -122.274089}
\.
