     ADD CONSTRAINT fk_vehicle_cluster_id FOREIGN KEY (cluster_id) REFERENCES cluster(id) ON UPDATE RESTRICT ON DELETE RESTRICT;
 
 
---
--- Name: public; Type: ACL; Schema: -; Owner: postgres
---
 
 REVOKE ALL ON SCHEMA public FROM PUBLIC;
-REVOKE ALL ON SCHEMA public FROM postgres;
-GRANT ALL ON SCHEMA public TO postgres;
 GRANT ALL ON SCHEMA public TO PUBLIC;
 
 
 --
--- Name: cluster; Type: ACL; Schema: public; Owner: pathfinderwebserver
---
-
-REVOKE ALL ON TABLE cluster FROM PUBLIC;
-REVOKE ALL ON TABLE cluster FROM pathfinderwebserver;
-GRANT ALL ON TABLE cluster TO pathfinderwebserver;
-GRANT ALL ON TABLE cluster TO PUBLIC;
-
-
---
--- Name: commodity; Type: ACL; Schema: public; Owner: pathfinderwebserver
---
-
-REVOKE ALL ON TABLE commodity FROM PUBLIC;
-REVOKE ALL ON TABLE commodity FROM pathfinderwebserver;
-GRANT ALL ON TABLE commodity TO pathfinderwebserver;
-GRANT ALL ON TABLE commodity TO PUBLIC;
-
-
---
--- Name: pathfinder_application; Type: ACL; Schema: public; Owner: pathfinderwebserver
---
-
-REVOKE ALL ON TABLE pathfinder_application FROM PUBLIC;
-REVOKE ALL ON TABLE pathfinder_application FROM pathfinderwebserver;
-GRANT ALL ON TABLE pathfinder_application TO pathfinderwebserver;
-GRANT ALL ON TABLE pathfinder_application TO PUBLIC;
-
-
---
--- Name: play_evolutions; Type: ACL; Schema: public; Owner: pathfinderwebserver
---
-
-REVOKE ALL ON TABLE play_evolutions FROM PUBLIC;
-REVOKE ALL ON TABLE play_evolutions FROM pathfinderwebserver;
-GRANT ALL ON TABLE play_evolutions TO pathfinderwebserver;
-GRANT ALL ON TABLE play_evolutions TO PUBLIC;
-
-
---
--- Name: vehicle; Type: ACL; Schema: public; Owner: pathfinderwebserver
---
-
-REVOKE ALL ON TABLE vehicle FROM PUBLIC;
-REVOKE ALL ON TABLE vehicle FROM pathfinderwebserver;
-GRANT ALL ON TABLE vehicle TO pathfinderwebserver;
-GRANT ALL ON TABLE vehicle TO PUBLIC;
-
-
---
--- Name: DEFAULT PRIVILEGES FOR TABLES; Type: DEFAULT ACL; Schema: -; Owner: pathfinderwebserver
---
-
-ALTER DEFAULT PRIVILEGES FOR ROLE pathfinderwebserver REVOKE ALL ON TABLES  FROM PUBLIC;
-ALTER DEFAULT PRIVILEGES FOR ROLE pathfinderwebserver REVOKE ALL ON TABLES  FROM pathfinderwebserver;
-ALTER DEFAULT PRIVILEGES FOR ROLE pathfinderwebserver GRANT ALL ON TABLES  TO pathfinderwebserver;
-ALTER DEFAULT PRIVILEGES FOR ROLE pathfinderwebserver GRANT ALL ON TABLES  TO PUBLIC;
-
-
---
 -- PostgreSQL database dump complete
 --
 

--

COPY commodity (id, startlatitude, startlongitude, endlatitude, endlongitude, status, metadata, cluster_id) FROM stdin;
1	39.4815139999999971	-87.3141770000000008	39.4754629999999977	-87.3487089999999995	2	{}	1
2	39.4423790000000025	-87.3390610000000009	39.4816379999999967	-87.3211009999999987	3	{}	1
3	39.4993100000000013	-87.3791140000000013	39.5159969999999987	-87.3586860000000058	3	{}	1
6	39.404952999999999	-87.3176050000000004	39.4704460000000026	-87.4144220000000018	3	{}	1
7	39.4587840000000014	-87.4068690000000004	39.4484449999999995	-87.3344280000000026	3	{}	1
9	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	3	{}	1
10	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	3	{}	1
11	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	3	{}	1
12	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	3	{}	1
13	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	3	{}	1
14	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	3	{}	1
15	39.4835410779709832	-87.3245842662521881	39.4399999999999977	-87.3400000000000034	3	{}	1
16	39.4399999999999977	-87.3400000000000034	39.4835410779709832	-87.3245842662521881	3	{}	1
17	39.4432649000000026	-87.3386129999999952	39.4399999999999977	-87.3400000000000034	2	{}	1
18	39.4399999999999977	-87.3400000000000034	39.4432649000000026	-87.3386129999999952	2	{}	1
19	39.4432649000000026	-87.3386129999999952	39.4399999999999977	-87.3400000000000034	2	{}	1
20	39.4399999999999977	-87.3400000000000034	39.4432649000000026	-87.3386129999999952	2	{}	1
21	39.4432649000000026	-87.3386129999999952	39.4399999999999977	-87.3400000000000034	2	{}	1
22	39.4399999999999977	-87.3400000000000034	39.4432649000000026	-87.3386129999999952	2	{}	1
23	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	2	{}	1
24	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	2	{}	1
25	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	2	{}	1
26	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	2	{}	1
27	39.4432649000000026	-87.3386129999999952	39.4399999999999977	-87.3400000000000034	2	{}	1
28	39.4399999999999977	-87.3400000000000034	39.4432649000000026	-87.3386129999999952	2	{}	1
29	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	2	{}	1
30	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	2	{}	1
31	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	2	{}	1
32	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	2	{}	1
33	43.1035260000000022	-86.2484919999999988	39.4399999999999977	-87.3400000000000034	2	{}	1
34	39.4399999999999977	-87.3400000000000034	43.1035260000000022	-86.2484919999999988	2	{}	1
35	42.1864145016690628	-88.1087807101086753	39.4399999999999977	-87.3400000000000034	2	{}	1
36	39.4399999999999977	-87.3400000000000034	42.1864145016690628	-88.1087807101086753	2	{}	1
4	39.4920240000000007	-87.4484649999999988	39.4334460000000036	-87.4134459999999933	4	{}	1
5	39.4914970000000025	-87.3145319999999998	39.4919610000000034	-87.3631129999999985	4	{}	1
\.



-- Name: commodity_id_seq; Type: SEQUENCE SET; Schema: public; Owner: pathfinderwebserver
--

SELECT pg_catalog.setval('commodity_id_seq', 2, true);


--
