schema.backup

--
-- PostgreSQL database dump
--

-- Dumped from database version 9.1.3
-- Dumped by pg_dump version 9.1.3
-- Started on 2013-03-05 20:36:31

SET statement_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SET check_function_bodies = false;
SET client_min_messages = warning;

--
-- TOC entry 175 (class 3079 OID 11639)
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: 
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- TOC entry 1929 (class 0 OID 0)
-- Dependencies: 175
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner: 
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET search_path = public, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 170 (class 1259 OID 16717)
-- Dependencies: 5
-- Name: candidates; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE candidates (
    candidateid integer NOT NULL,
    image_name character varying(200) NOT NULL,
    telemetryid integer NOT NULL,
    processed boolean
);


ALTER TABLE public.candidates OWNER TO postgres;

--
-- TOC entry 169 (class 1259 OID 16715)
-- Dependencies: 170 5
-- Name: candidates_candidateid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE candidates_candidateid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.candidates_candidateid_seq OWNER TO postgres;

--
-- TOC entry 1930 (class 0 OID 0)
-- Dependencies: 169
-- Name: candidates_candidateid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE candidates_candidateid_seq OWNED BY candidates.candidateid;


--
-- TOC entry 1931 (class 0 OID 0)
-- Dependencies: 169
-- Name: candidates_candidateid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('candidates_candidateid_seq', 631, true);


--
-- TOC entry 162 (class 1259 OID 16660)
-- Dependencies: 5
-- Name: description; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE description (
    description_id integer NOT NULL,
    shape character varying(50),
    shapecolor character varying(50),
    letter character varying(50),
    lettercolor character varying(50),
    target_x integer,
    target_y integer,
    top_x integer,
    top_y integer,
    heading character varying(50),
    "timestamp" double precision
);


ALTER TABLE public.description OWNER TO postgres;

--
-- TOC entry 161 (class 1259 OID 16658)
-- Dependencies: 162 5
-- Name: description_description_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE description_description_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.description_description_id_seq OWNER TO postgres;

--
-- TOC entry 1932 (class 0 OID 0)
-- Dependencies: 161
-- Name: description_description_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE description_description_id_seq OWNED BY description.description_id;


--
-- TOC entry 1933 (class 0 OID 0)
-- Dependencies: 161
-- Name: description_description_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('description_description_id_seq', 550, true);


--
-- TOC entry 164 (class 1259 OID 16668)
-- Dependencies: 5
-- Name: gps_position; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE gps_position (
    gps_id integer NOT NULL,
    lat double precision,
    lon double precision,
    alt double precision
);


ALTER TABLE public.gps_position OWNER TO postgres;

--
-- TOC entry 163 (class 1259 OID 16666)
-- Dependencies: 164 5
-- Name: gps_position_gps_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE gps_position_gps_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.gps_position_gps_id_seq OWNER TO postgres;

--
-- TOC entry 1934 (class 0 OID 0)
-- Dependencies: 163
-- Name: gps_position_gps_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE gps_position_gps_id_seq OWNED BY gps_position.gps_id;


--
-- TOC entry 1935 (class 0 OID 0)
-- Dependencies: 163
-- Name: gps_position_gps_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('gps_position_gps_id_seq', 2873, true);


--
-- TOC entry 166 (class 1259 OID 16676)
-- Dependencies: 5
-- Name: location; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE location (
    loc_id integer NOT NULL,
    lower_left_gps integer,
    lower_right_gps integer,
    upper_left_gps integer,
    upper_right_gps integer
);


ALTER TABLE public.location OWNER TO postgres;

--
-- TOC entry 165 (class 1259 OID 16674)
-- Dependencies: 166 5
-- Name: location_loc_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE location_loc_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.location_loc_id_seq OWNER TO postgres;

--
-- TOC entry 1936 (class 0 OID 0)
-- Dependencies: 165
-- Name: location_loc_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE location_loc_id_seq OWNED BY location.loc_id;


--
-- TOC entry 1937 (class 0 OID 0)
-- Dependencies: 165
-- Name: location_loc_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('location_loc_id_seq', 550, true);


--
-- TOC entry 168 (class 1259 OID 16704)
-- Dependencies: 5
-- Name: telemetry; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE telemetry (
    telemetry_id integer NOT NULL,
    gimbal_roll double precision,
    gimbal_pitch double precision,
    gimbal_yaw double precision,
    origin_x integer,
    origin_y integer,
    gimbal_zoom integer,
    plane_roll double precision,
    plane_pitch double precision,
    plane_heading double precision,
    planelocation_id integer,
    blurfactor double precision,
    width_pixels integer,
    height_pixels integer
);


ALTER TABLE public.telemetry OWNER TO postgres;

--
-- TOC entry 167 (class 1259 OID 16702)
-- Dependencies: 5 168
-- Name: telemetry_telemetry_id_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE telemetry_telemetry_id_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.telemetry_telemetry_id_seq OWNER TO postgres;

--
-- TOC entry 1938 (class 0 OID 0)
-- Dependencies: 167
-- Name: telemetry_telemetry_id_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE telemetry_telemetry_id_seq OWNED BY telemetry.telemetry_id;


--
-- TOC entry 1939 (class 0 OID 0)
-- Dependencies: 167
-- Name: telemetry_telemetry_id_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('telemetry_telemetry_id_seq', 621, true);


--
-- TOC entry 172 (class 1259 OID 16731)
-- Dependencies: 5
-- Name: unverified_targets; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE unverified_targets (
    targetid integer NOT NULL,
    candidateid integer NOT NULL,
    revision integer NOT NULL,
    location integer,
    description_id integer,
    processed boolean
);


ALTER TABLE public.unverified_targets OWNER TO postgres;

--
-- TOC entry 171 (class 1259 OID 16729)
-- Dependencies: 172 5
-- Name: unverified_targets_targetid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE unverified_targets_targetid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.unverified_targets_targetid_seq OWNER TO postgres;

--
-- TOC entry 1940 (class 0 OID 0)
-- Dependencies: 171
-- Name: unverified_targets_targetid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE unverified_targets_targetid_seq OWNED BY unverified_targets.targetid;


--
-- TOC entry 1941 (class 0 OID 0)
-- Dependencies: 171
-- Name: unverified_targets_targetid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('unverified_targets_targetid_seq', 562, true);


--
-- TOC entry 174 (class 1259 OID 16754)
-- Dependencies: 5
-- Name: verified_targets; Type: TABLE; Schema: public; Owner: postgres; Tablespace: 
--

CREATE TABLE verified_targets (
    targetid integer NOT NULL,
    submitid integer NOT NULL,
    center_gps_id integer NOT NULL
);


ALTER TABLE public.verified_targets OWNER TO postgres;

--
-- TOC entry 173 (class 1259 OID 16752)
-- Dependencies: 5 174
-- Name: verified_targets_submitid_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

CREATE SEQUENCE verified_targets_submitid_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.verified_targets_submitid_seq OWNER TO postgres;

--
-- TOC entry 1942 (class 0 OID 0)
-- Dependencies: 173
-- Name: verified_targets_submitid_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: postgres
--

ALTER SEQUENCE verified_targets_submitid_seq OWNED BY verified_targets.submitid;


--
-- TOC entry 1943 (class 0 OID 0)
-- Dependencies: 173
-- Name: verified_targets_submitid_seq; Type: SEQUENCE SET; Schema: public; Owner: postgres
--

SELECT pg_catalog.setval('verified_targets_submitid_seq', 54, true);


--
-- TOC entry 1888 (class 2604 OID 16720)
-- Dependencies: 169 170 170
-- Name: candidateid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY candidates ALTER COLUMN candidateid SET DEFAULT nextval('candidates_candidateid_seq'::regclass);


--
-- TOC entry 1884 (class 2604 OID 16663)
-- Dependencies: 161 162 162
-- Name: description_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY description ALTER COLUMN description_id SET DEFAULT nextval('description_description_id_seq'::regclass);


--
-- TOC entry 1885 (class 2604 OID 16671)
-- Dependencies: 163 164 164
-- Name: gps_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY gps_position ALTER COLUMN gps_id SET DEFAULT nextval('gps_position_gps_id_seq'::regclass);


--
-- TOC entry 1886 (class 2604 OID 16679)
-- Dependencies: 165 166 166
-- Name: loc_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY location ALTER COLUMN loc_id SET DEFAULT nextval('location_loc_id_seq'::regclass);


--
-- TOC entry 1887 (class 2604 OID 16707)
-- Dependencies: 167 168 168
-- Name: telemetry_id; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY telemetry ALTER COLUMN telemetry_id SET DEFAULT nextval('telemetry_telemetry_id_seq'::regclass);


--
-- TOC entry 1889 (class 2604 OID 16734)
-- Dependencies: 172 171 172
-- Name: targetid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY unverified_targets ALTER COLUMN targetid SET DEFAULT nextval('unverified_targets_targetid_seq'::regclass);


--
-- TOC entry 1890 (class 2604 OID 16757)
-- Dependencies: 173 174 174
-- Name: submitid; Type: DEFAULT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY verified_targets ALTER COLUMN submitid SET DEFAULT nextval('verified_targets_submitid_seq'::regclass);


--
-- TOC entry 1921 (class 0 OID 16717)
-- Dependencies: 170
-- Data for Name: candidates; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY candidates (candidateid, image_name, telemetryid, processed) FROM stdin;
\.


--
-- TOC entry 1917 (class 0 OID 16660)
-- Dependencies: 162
-- Data for Name: description; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY description (description_id, shape, shapecolor, letter, lettercolor, target_x, target_y, top_x, top_y, heading, "timestamp") FROM stdin;
112	-	-	-	-	0	0	\N	\N	-	\N
113	-	-	-	-	0	0	\N	\N	-	\N
114	-	-	-	-	0	0	\N	\N	-	\N
115	-	-	-	-	0	0	\N	\N	-	\N
116	-	-	-	-	0	0	\N	\N	-	\N
117	-	-	-	-	0	0	\N	\N	-	\N
118	-	-	-	-	0	0	\N	\N	-	\N
119	-	-	-	-	0	0	\N	\N	-	\N
120	-	-	-	-	0	0	\N	\N	-	\N
121	-	-	-	-	0	0	\N	\N	-	\N
122	-	-	-	-	0	0	\N	\N	-	\N
123	-	-	-	-	0	0	\N	\N	-	\N
124	-	-	-	-	0	0	\N	\N	-	\N
125	-	-	-	-	0	0	\N	\N	-	\N
126	-	-	-	-	0	0	\N	\N	-	\N
127	-	-	-	-	0	0	\N	\N	-	\N
128	-	-	-	-	0	0	\N	\N	-	\N
129	-	-	-	-	0	0	\N	\N	-	\N
130	-	-	-	-	0	0	\N	\N	-	\N
131	-	-	-	-	0	0	\N	\N	-	\N
132	-	-	-	-	0	0	\N	\N	-	\N
133	-	-	-	-	0	0	\N	\N	-	\N
134	-	-	-	-	0	0	\N	\N	-	\N
135	-	-	-	-	0	0	\N	\N	-	\N
136	-	-	-	-	0	0	\N	\N	-	\N
137	-	-	-	-	0	0	\N	\N	-	\N
138	-	-	-	-	0	0	\N	\N	-	\N
139	-	-	-	-	0	0	\N	\N	-	\N
140	-	-	-	-	0	0	\N	\N	-	\N
141	-	-	-	-	0	0	\N	\N	-	\N
142	-	-	-	-	0	0	\N	\N	-	\N
143	-	-	-	-	0	0	\N	\N	-	\N
144	-	-	-	-	0	0	\N	\N	-	\N
145	-	-	-	-	0	0	\N	\N	-	\N
146	-	-	-	-	0	0	\N	\N	-	\N
147	-	-	-	-	0	0	\N	\N	-	\N
148	-	-	-	-	0	0	\N	\N	-	\N
149	-	-	-	-	0	0	\N	\N	-	\N
150	-	-	-	-	0	0	\N	\N	-	\N
151	-	-	-	-	0	0	\N	\N	-	\N
152	-	-	-	-	0	0	\N	\N	-	\N
153	-	-	-	-	0	0	\N	\N	-	\N
154	-	-	-	-	0	0	\N	\N	-	\N
155	-	-	-	-	0	0	\N	\N	-	\N
156	-	-	-	-	0	0	\N	\N	-	\N
157	-	-	-	-	0	0	\N	\N	-	\N
158	-	-	-	-	0	0	\N	\N	-	\N
159	-	-	-	-	0	0	\N	\N	-	\N
160	-	-	-	-	0	0	\N	\N	-	\N
161	-	-	-	-	0	0	\N	\N	-	\N
162	-	-	-	-	0	0	\N	\N	-	\N
163	-	-	-	-	0	0	\N	\N	-	\N
164	-	-	-	-	0	0	\N	\N	-	\N
165	-	-	-	-	0	0	\N	\N	-	\N
166	-	-	-	-	0	0	\N	\N	-	\N
167	-	-	-	-	0	0	\N	\N	-	\N
168	-	-	-	-	0	0	\N	\N	-	\N
169	-	-	-	-	0	0	\N	\N	-	\N
170	-	-	-	-	0	0	\N	\N	-	\N
171	-	-	-	-	0	0	\N	\N	-	\N
172	-	-	-	-	0	0	\N	\N	-	\N
173	-	-	-	-	0	0	\N	\N	-	\N
174	-	-	-	-	0	0	\N	\N	-	\N
175	-	-	-	-	0	0	\N	\N	-	\N
176	-	-	-	-	0	0	\N	\N	-	\N
177	-	-	-	-	0	0	\N	\N	-	\N
178	-	-	-	-	0	0	\N	\N	-	\N
179	-	-	-	-	0	0	\N	\N	-	\N
180	-	-	-	-	0	0	\N	\N	-	\N
181	-	-	-	-	0	0	\N	\N	-	\N
182	-	-	-	-	0	0	\N	\N	-	\N
183	-	-	-	-	0	0	\N	\N	-	\N
184	-	-	-	-	0	0	\N	\N	-	\N
185	-	-	-	-	0	0	\N	\N	-	\N
186	-	-	-	-	0	0	\N	\N	-	\N
187	-	-	-	-	0	0	\N	\N	-	\N
188	-	-	-	-	0	0	\N	\N	-	\N
189	-	-	-	-	0	0	\N	\N	-	\N
190	-	-	-	-	0	0	\N	\N	-	\N
191	-	-	-	-	0	0	\N	\N	-	\N
192	-	-	-	-	0	0	\N	\N	-	\N
193	-	-	-	-	0	0	\N	\N	-	\N
194	-	-	-	-	0	0	\N	\N	-	\N
195	-	-	-	-	0	0	\N	\N	-	\N
196	-	-	-	-	0	0	\N	\N	-	\N
197	-	-	-	-	0	0	\N	\N	-	\N
198	-	-	-	-	0	0	\N	\N	-	\N
199	-	-	-	-	0	0	\N	\N	-	\N
200	-	-	-	-	0	0	\N	\N	-	\N
201	-	-	-	-	0	0	\N	\N	-	\N
202	-	-	-	-	0	0	\N	\N	-	\N
203	-	-	-	-	0	0	\N	\N	-	\N
204	-	-	-	-	0	0	\N	\N	-	\N
205	-	-	-	-	0	0	\N	\N	-	\N
206	-	-	-	-	0	0	\N	\N	-	\N
207	-	-	-	-	0	0	\N	\N	-	\N
208	-	-	-	-	0	0	\N	\N	-	\N
209	-	-	-	-	0	0	\N	\N	-	\N
210	-	-	-	-	0	0	\N	\N	-	\N
211	-	-	-	-	0	0	\N	\N	-	\N
212	-	-	-	-	0	0	\N	\N	-	\N
213	-	-	-	-	0	0	\N	\N	-	\N
214	-	-	-	-	0	0	\N	\N	-	\N
215	-	-	-	-	0	0	\N	\N	-	\N
216	-	-	-	-	0	0	\N	\N	-	\N
217	-	-	-	-	0	0	\N	\N	-	\N
218	-	-	-	-	0	0	\N	\N	-	\N
219	-	-	-	-	0	0	\N	\N	-	\N
220	-	-	-	-	0	0	\N	\N	-	\N
221	-	-	-	-	0	0	\N	\N	-	\N
222	-	-	-	-	0	0	\N	\N	-	\N
223	-	-	-	-	0	0	\N	\N	-	\N
224	-	-	-	-	0	0	\N	\N	-	\N
225	-	-	-	-	0	0	\N	\N	-	\N
226	-	-	-	-	0	0	\N	\N	-	\N
227	-	-	-	-	0	0	\N	\N	-	\N
228	-	-	-	-	0	0	\N	\N	-	\N
229	-	-	-	-	0	0	\N	\N	-	\N
230	-	-	-	-	0	0	\N	\N	-	\N
231	-	-	-	-	0	0	\N	\N	-	\N
232	-	-	-	-	0	0	\N	\N	-	\N
233	-	-	-	-	0	0	\N	\N	-	\N
234	-	-	-	-	0	0	\N	\N	-	\N
235	-	-	-	-	0	0	\N	\N	-	\N
236	-	-	-	-	0	0	\N	\N	-	\N
237	-	-	-	-	0	0	\N	\N	-	\N
238	-	-	-	-	0	0	\N	\N	-	\N
239	-	-	-	-	0	0	\N	\N	-	\N
240	-	-	-	-	0	0	\N	\N	-	\N
241	-	-	-	-	0	0	\N	\N	-	\N
242	-	-	-	-	0	0	\N	\N	-	\N
243	-	-	-	-	0	0	\N	\N	-	\N
244	-	-	-	-	0	0	\N	\N	-	\N
245	-	-	-	-	0	0	\N	\N	-	\N
246	-	-	-	-	0	0	\N	\N	-	\N
247	-	-	-	-	0	0	\N	\N	-	\N
248	-	-	-	-	0	0	\N	\N	-	\N
249	-	-	-	-	0	0	\N	\N	-	\N
250	-	-	-	-	0	0	\N	\N	-	\N
251	-	-	-	-	0	0	\N	\N	-	\N
252	-	-	-	-	0	0	\N	\N	-	\N
253	-	-	-	-	0	0	\N	\N	-	\N
254	-	-	-	-	0	0	\N	\N	-	\N
255	-	-	-	-	0	0	\N	\N	-	\N
256	-	-	-	-	0	0	\N	\N	-	\N
257	-	-	-	-	0	0	\N	\N	-	\N
258	-	-	-	-	0	0	\N	\N	-	\N
259	-	-	-	-	0	0	\N	\N	-	\N
260	-	-	-	-	0	0	\N	\N	-	\N
261	-	-	-	-	0	0	\N	\N	-	\N
262	-	-	-	-	0	0	\N	\N	-	\N
263	-	-	-	-	0	0	\N	\N	-	\N
264	-	-	-	-	0	0	\N	\N	-	\N
265	-	-	-	-	0	0	\N	\N	-	\N
266	-	-	-	-	0	0	\N	\N	-	\N
267	-	-	-	-	0	0	\N	\N	-	\N
268	-	-	-	-	0	0	\N	\N	-	\N
269	-	-	-	-	0	0	\N	\N	-	\N
270	-	-	-	-	0	0	\N	\N	-	\N
271	-	-	-	-	0	0	\N	\N	-	\N
272	-	-	-	-	0	0	\N	\N	-	\N
273	-	-	-	-	0	0	\N	\N	-	\N
274	-	-	-	-	0	0	\N	\N	-	\N
275	-	-	-	-	0	0	\N	\N	-	\N
276	-	-	-	-	0	0	\N	\N	-	\N
277	-	-	-	-	0	0	\N	\N	-	\N
278	-	-	-	-	0	0	\N	\N	-	\N
279	-	-	-	-	0	0	\N	\N	-	\N
280	-	-	-	-	0	0	\N	\N	-	\N
281	-	-	-	-	0	0	\N	\N	-	\N
282	-	-	-	-	0	0	\N	\N	-	\N
283	-	-	-	-	0	0	\N	\N	-	\N
284	-	-	-	-	0	0	\N	\N	-	\N
285	-	-	-	-	0	0	\N	\N	-	\N
286	-	-	-	-	0	0	\N	\N	-	\N
287	-	-	-	-	0	0	\N	\N	-	\N
288	-	-	-	-	0	0	\N	\N	-	\N
289	-	-	-	-	0	0	\N	\N	-	\N
290	-	-	-	-	0	0	\N	\N	-	\N
291	-	-	-	-	0	0	\N	\N	-	\N
292	-	-	-	-	0	0	\N	\N	-	\N
293	-	-	-	-	0	0	\N	\N	-	\N
294	-	-	-	-	0	0	\N	\N	-	\N
295	-	-	-	-	0	0	\N	\N	-	\N
296	-	-	-	-	0	0	\N	\N	-	\N
297	-	-	-	-	0	0	\N	\N	-	\N
298	-	-	-	-	0	0	\N	\N	-	\N
299	-	-	-	-	0	0	\N	\N	-	\N
300	-	-	-	-	0	0	\N	\N	-	\N
301	-	-	-	-	0	0	\N	\N	-	\N
302	-	-	-	-	0	0	\N	\N	-	\N
303	-	-	-	-	0	0	\N	\N	-	\N
304	-	-	-	-	0	0	\N	\N	-	\N
305	-	-	-	-	0	0	\N	\N	-	\N
306	-	-	-	-	0	0	\N	\N	-	\N
307	-	-	-	-	0	0	\N	\N	-	\N
308	-	-	-	-	0	0	\N	\N	-	\N
309	-	-	-	-	0	0	\N	\N	-	\N
310	-	-	-	-	0	0	\N	\N	-	\N
311	-	-	-	-	0	0	\N	\N	-	\N
312	-	-	-	-	0	0	\N	\N	-	\N
313	-	-	-	-	0	0	\N	\N	-	\N
314	-	-	-	-	0	0	\N	\N	-	\N
315	-	-	-	-	0	0	\N	\N	-	\N
316	-	-	-	-	0	0	\N	\N	-	\N
317	-	-	-	-	0	0	\N	\N	-	\N
318	-	-	-	-	0	0	\N	\N	-	\N
319	-	-	-	-	0	0	\N	\N	-	\N
320	-	-	-	-	0	0	\N	\N	-	\N
321	-	-	-	-	0	0	\N	\N	-	\N
322	-	-	-	-	0	0	\N	\N	-	\N
323	-	-	-	-	0	0	\N	\N	-	\N
324	-	-	-	-	0	0	\N	\N	-	\N
325	-	-	-	-	0	0	\N	\N	-	\N
326	-	-	-	-	0	0	\N	\N	-	\N
327	-	-	-	-	0	0	\N	\N	-	\N
328	-	-	-	-	0	0	\N	\N	-	\N
329	-	-	-	-	0	0	\N	\N	-	\N
330	-	-	-	-	0	0	\N	\N	-	\N
331	-	-	-	-	0	0	\N	\N	-	\N
332	-	-	-	-	0	0	\N	\N	-	\N
333	-	-	-	-	0	0	\N	\N	-	\N
334	-	-	-	-	0	0	\N	\N	-	\N
335	-	-	-	-	0	0	\N	\N	-	\N
336	-	-	-	-	0	0	\N	\N	-	\N
337	-	-	-	-	0	0	\N	\N	-	\N
338	-	-	-	-	0	0	\N	\N	-	\N
339	-	-	-	-	0	0	\N	\N	-	\N
340	-	-	-	-	0	0	\N	\N	-	\N
341	-	-	-	-	0	0	\N	\N	-	\N
342	-	-	-	-	0	0	\N	\N	-	\N
343	-	-	-	-	0	0	\N	\N	-	\N
344	-	-	-	-	0	0	\N	\N	-	\N
345	-	-	-	-	0	0	\N	\N	-	\N
346	-	-	-	-	0	0	\N	\N	-	\N
347	-	-	-	-	0	0	\N	\N	-	\N
348	-	-	-	-	0	0	\N	\N	-	\N
349	-	-	-	-	0	0	\N	\N	-	\N
366	-	-	-	-	0	0	\N	\N	-	\N
367	-	-	-	-	0	0	\N	\N	-	\N
351	Diamond	White	K	Yellow	-1	-1	\N	\N	-	\N
352	-	-	-	-	0	0	\N	\N	-	\N
353	-	-	-	-	0	0	\N	\N	-	\N
354	-	-	-	-	0	0	\N	\N	-	\N
355	-	-	-	-	0	0	\N	\N	-	\N
356	-	-	-	-	0	0	\N	\N	-	\N
357	-	-	-	-	0	0	\N	\N	-	\N
358	-	-	-	-	0	0	\N	\N	-	\N
359	-	-	-	-	0	0	\N	\N	-	\N
360	-	-	-	-	0	0	\N	\N	-	\N
361	-	-	-	-	0	0	\N	\N	-	\N
362	-	-	-	-	0	0	\N	\N	-	\N
363	-	-	-	-	0	0	\N	\N	-	\N
364	-	-	-	-	0	0	\N	\N	-	\N
365	-	-	-	-	0	0	\N	\N	-	\N
368	-	-	-	-	0	0	\N	\N	-	\N
369	-	-	-	-	0	0	\N	\N	-	\N
370	-	-	-	-	0	0	\N	\N	-	\N
371	-	-	-	-	0	0	\N	\N	-	\N
372	-	-	-	-	0	0	\N	\N	-	\N
373	-	-	-	-	0	0	\N	\N	-	\N
374	-	-	-	-	0	0	\N	\N	-	\N
375	-	-	-	-	0	0	\N	\N	-	\N
376	-	-	-	-	0	0	\N	\N	-	\N
377	-	-	-	-	0	0	\N	\N	-	\N
378	-	-	-	-	0	0	\N	\N	-	\N
379	-	-	-	-	0	0	\N	\N	-	\N
380	-	-	-	-	0	0	\N	\N	-	\N
381	-	-	-	-	0	0	\N	\N	-	\N
382	-	-	-	-	0	0	\N	\N	-	\N
383	-	-	-	-	0	0	\N	\N	-	\N
384	-	-	-	-	0	0	\N	\N	-	\N
385	-	-	-	-	0	0	\N	\N	-	\N
386	-	-	-	-	0	0	\N	\N	-	\N
387	-	-	-	-	0	0	\N	\N	-	\N
388	-	-	-	-	0	0	\N	\N	-	\N
389	-	-	-	-	0	0	\N	\N	-	\N
390	-	-	-	-	0	0	\N	\N	-	\N
350	Square	Blue	J	Q	0	0	\N	\N	-	\N
391	-	-	-	-	0	0	\N	\N	-	\N
392	-	-	-	-	0	0	\N	\N	-	\N
393	-	-	-	-	0	0	\N	\N	-	\N
394	-	-	-	-	0	0	\N	\N	-	\N
395	-	-	-	-	0	0	\N	\N	-	\N
396	-	-	-	-	0	0	\N	\N	-	\N
397	-	-	-	-	0	0	\N	\N	-	\N
398	-	-	-	-	0	0	\N	\N	-	\N
399	-	-	-	-	0	0	\N	\N	-	\N
400	-	-	-	-	0	0	\N	\N	-	\N
401	-	-	-	-	0	0	\N	\N	-	\N
402	-	-	-	-	0	0	\N	\N	-	\N
403	-	-	-	-	0	0	\N	\N	-	\N
404	-	-	-	-	0	0	\N	\N	-	\N
405	-	-	-	-	0	0	\N	\N	-	\N
406	-	-	-	-	0	0	\N	\N	-	\N
407	-	-	-	-	0	0	\N	\N	-	\N
408	-	-	-	-	0	0	\N	\N	-	\N
409	-	-	-	-	0	0	\N	\N	-	\N
410	-	-	-	-	0	0	\N	\N	-	\N
411	-	-	-	-	0	0	\N	\N	-	\N
412	-	-	-	-	0	0	\N	\N	-	\N
413	-	-	-	-	0	0	\N	\N	-	\N
414	-	-	-	-	0	0	\N	\N	-	\N
415	-	-	-	-	0	0	\N	\N	-	\N
416	-	-	-	-	0	0	\N	\N	-	\N
417	-	-	-	-	0	0	\N	\N	-	\N
418	-	-	-	-	0	0	\N	\N	-	\N
419	-	-	-	-	0	0	\N	\N	-	\N
420	-	-	-	-	0	0	\N	\N	-	\N
421	-	-	-	-	0	0	\N	\N	-	\N
422	-	-	-	-	0	0	\N	\N	-	\N
423	-	-	-	-	0	0	\N	\N	-	\N
424	-	-	-	-	0	0	\N	\N	-	\N
425	-	-	-	-	0	0	\N	\N	-	\N
426	-	-	-	-	0	0	\N	\N	-	\N
427	-	-	-	-	0	0	\N	\N	-	\N
428	-	-	-	-	0	0	\N	\N	-	\N
429	-	-	-	-	0	0	\N	\N	-	\N
430	-	-	-	-	0	0	\N	\N	-	\N
431	-	-	-	-	0	0	\N	\N	-	\N
432	-	-	-	-	0	0	\N	\N	-	\N
433	-	-	-	-	0	0	\N	\N	-	\N
434	-	-	-	-	0	0	\N	\N	-	\N
435	-	-	-	-	0	0	\N	\N	-	\N
436	-	-	-	-	0	0	\N	\N	-	\N
437	-	-	-	-	0	0	\N	\N	-	\N
438	-	-	-	-	0	0	\N	\N	-	\N
439	-	-	-	-	0	0	\N	\N	-	\N
440	-	-	-	-	0	0	\N	\N	-	\N
441	-	-	-	-	0	0	\N	\N	-	\N
442	-	-	-	-	0	0	\N	\N	-	\N
443	-	-	-	-	0	0	\N	\N	-	\N
444	-	-	-	-	0	0	\N	\N	-	\N
445	-	-	-	-	0	0	\N	\N	-	\N
446	-	-	-	-	0	0	\N	\N	-	\N
447	-	-	-	-	0	0	\N	\N	-	\N
448	-	-	-	-	0	0	\N	\N	-	\N
449	-	-	-	-	0	0	\N	\N	-	\N
450	-	-	-	-	0	0	\N	\N	-	\N
451	-	-	-	-	0	0	\N	\N	-	\N
452	-	-	-	-	0	0	\N	\N	-	\N
453	-	-	-	-	0	0	\N	\N	-	\N
454	-	-	-	-	0	0	\N	\N	-	\N
455	-	-	-	-	0	0	\N	\N	-	\N
456	-	-	-	-	0	0	\N	\N	-	\N
457	-	-	-	-	0	0	\N	\N	-	\N
458	-	-	-	-	0	0	\N	\N	-	\N
459	-	-	-	-	0	0	\N	\N	-	\N
460	-	-	-	-	0	0	\N	\N	-	\N
461	-	-	-	-	0	0	\N	\N	-	\N
462	-	-	-	-	0	0	\N	\N	-	\N
463	-	-	-	-	0	0	\N	\N	-	\N
464	-	-	-	-	0	0	\N	\N	-	\N
465	-	-	-	-	0	0	\N	\N	-	\N
466	-	-	-	-	0	0	\N	\N	-	\N
467	-	-	-	-	0	0	\N	\N	-	\N
468	-	-	-	-	0	0	\N	\N	-	\N
469	-	-	-	-	0	0	\N	\N	-	\N
470	-	-	-	-	0	0	\N	\N	-	\N
471	-	-	-	-	0	0	\N	\N	-	\N
472	-	-	-	-	0	0	\N	\N	-	\N
473	-	-	-	-	0	0	\N	\N	-	\N
474	-	-	-	-	0	0	\N	\N	-	\N
475	-	-	-	-	0	0	\N	\N	-	\N
476	-	-	-	-	0	0	\N	\N	-	\N
477	-	-	-	-	0	0	\N	\N	-	\N
478	-	-	-	-	0	0	\N	\N	-	\N
479	-	-	-	-	0	0	\N	\N	-	\N
480	-	-	-	-	0	0	\N	\N	-	\N
481	-	-	-	-	0	0	\N	\N	-	\N
482	-	-	-	-	0	0	\N	\N	-	\N
483	-	-	-	-	0	0	\N	\N	-	\N
484	-	-	-	-	0	0	\N	\N	-	\N
485	-	-	-	-	0	0	\N	\N	-	\N
486	-	-	-	-	0	0	\N	\N	-	\N
487	-	-	-	-	0	0	\N	\N	-	\N
488	-	-	-	-	0	0	\N	\N	-	\N
489	-	-	-	-	0	0	\N	\N	-	\N
490	-	-	-	-	0	0	\N	\N	-	\N
491	-	-	-	-	0	0	\N	\N	-	\N
492	-	-	-	-	0	0	\N	\N	-	\N
493	-	-	-	-	0	0	\N	\N	-	\N
494	-	-	-	-	0	0	\N	\N	-	\N
495	-	-	-	-	0	0	\N	\N	-	\N
496	-	-	-	-	0	0	\N	\N	-	\N
497	-	-	-	-	0	0	\N	\N	-	\N
498	-	-	-	-	0	0	\N	\N	-	\N
499	-	-	-	-	0	0	\N	\N	-	\N
500	-	-	-	-	0	0	\N	\N	-	\N
501	-	-	-	-	0	0	\N	\N	-	\N
502	-	-	-	-	0	0	\N	\N	-	\N
503	-	-	-	-	0	0	\N	\N	-	\N
504	-	-	-	-	0	0	\N	\N	-	\N
505	-	-	-	-	0	0	\N	\N	-	\N
506	-	-	-	-	0	0	\N	\N	-	\N
507	-	-	-	-	0	0	\N	\N	-	\N
508	-	-	-	-	0	0	\N	\N	-	\N
509	-	-	-	-	0	0	\N	\N	-	\N
510	-	-	-	-	0	0	\N	\N	-	\N
511	-	-	-	-	0	0	\N	\N	-	\N
512	-	-	-	-	0	0	\N	\N	-	\N
513	-	-	-	-	0	0	\N	\N	-	\N
514	-	-	-	-	0	0	\N	\N	-	\N
515	-	-	-	-	0	0	\N	\N	-	\N
516	-	-	-	-	0	0	\N	\N	-	\N
517	-	-	-	-	0	0	\N	\N	-	\N
518	-	-	-	-	0	0	\N	\N	-	\N
519	-	-	-	-	0	0	\N	\N	-	\N
520	-	-	-	-	0	0	\N	\N	-	\N
521	-	-	-	-	0	0	\N	\N	-	\N
522	-	-	-	-	0	0	\N	\N	-	\N
523	-	-	-	-	0	0	\N	\N	-	\N
524	-	-	-	-	0	0	\N	\N	-	\N
525	-	-	-	-	0	0	\N	\N	-	\N
526	-	-	-	-	0	0	\N	\N	-	\N
527	-	-	-	-	0	0	\N	\N	-	\N
528	-	-	-	-	0	0	\N	\N	-	\N
529	-	-	-	-	0	0	\N	\N	-	\N
530	-	-	-	-	0	0	\N	\N	-	\N
531	-	-	-	-	0	0	\N	\N	-	\N
532	-	-	-	-	0	0	\N	\N	-	\N
533	-	-	-	-	0	0	\N	\N	-	\N
534	-	-	-	-	0	0	\N	\N	-	\N
535	-	-	-	-	0	0	\N	\N	-	\N
536	-	-	-	-	0	0	\N	\N	-	\N
537	-	-	-	-	0	0	\N	\N	-	\N
538	-	-	-	-	0	0	\N	\N	-	\N
539	-	-	-	-	0	0	\N	\N	-	\N
540	-	-	-	-	0	0	\N	\N	-	\N
541	-	-	-	-	0	0	\N	\N	-	\N
542	-	-	-	-	0	0	\N	\N	-	\N
543	-	-	-	-	0	0	\N	\N	-	\N
544	-	-	-	-	0	0	\N	\N	-	\N
545	-	-	-	-	0	0	\N	\N	-	\N
546	-	-	-	-	0	0	\N	\N	-	\N
547	-	-	-	-	0	0	\N	\N	-	\N
548	-	-	-	-	0	0	\N	\N	-	\N
549	-	-	-	-	0	0	\N	\N	-	\N
550	-	-	-	-	0	0	\N	\N	-	\N
\.


--
-- TOC entry 1918 (class 0 OID 16668)
-- Dependencies: 164
-- Data for Name: gps_position; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY gps_position (gps_id, lat, lon, alt) FROM stdin;
1853	32.879995000000001	-117.230445	5.4545454545454604
1854	32.879979477587902	-117.23046339581001	0
1855	32.879979477345699	-117.230198178883	0
1856	32.8801978426647	-117.230463146327	0
1857	32.880197842429098	-117.230201526261	0
1858	32.879979477587902	-117.23046339581001	-0.010553444735705899
1859	32.879979413515997	-117.23046344705401	-0.010597004555165801
1860	32.879979413515997	-117.23046344705401	-0.010597004555165801
1861	32.880040000000001	-117.23018999999999	5.4545454545454604
1862	32.880024477588002	-117.23020839582	0
1863	32.880024477345899	-117.22994317875801	0
1864	32.880242842661403	-117.230208146336	0
1865	32.880242842425702	-117.22994652614101	0
1866	32.880024477588002	-117.23020839582	-0.010553452186286401
1867	32.879914999999997	-117.23028600000001	5.4545454545454604
1868	32.8800602140903	-117.230085007753	0
1869	32.880060214035403	-117.230053345459	0
1870	32.880098929379102	-117.23008549590899	0
1871	32.880098929324497	-117.230053910514	0
1872	32.880029999999998	-117.23030799999999	5.4545454545454604
1873	32.880050788240901	-117.23031022089999	0
1874	32.880050788236296	-117.230274227007	0
1875	32.880095185724898	-117.230310214762	0
1876	32.8800951857203	-117.230274320343	0
1877	32.879966000000003	-117.23036999999999	5.4545454545454604
1878	32.880025284274197	-117.230144087618	0
1879	32.880025284236901	-117.230124325696	0
1880	32.8800553162855	-117.23014451095401	0
1881	32.880055316248402	-117.230124786064	0
1882	32.879966000000003	-117.23036999999999	5.4545454545454604
1883	32.880083597841001	-117.23027827395499	0
1884	32.880083597807101	-117.230239959618	0
1885	32.880132850336402	-117.230278556877	0
1886	32.880132850302601	-117.230240360717	0
1887	32.879966000000003	-117.23036999999999	5.4545454545454604
1888	32.880148679556797	-117.23034162143399	0
1889	32.880148679549499	-117.230318726527	0
1890	32.880168842664901	-117.230341657415	0
1891	32.880168842657604	-117.230318791535	0
1892	32.879962999999996	-117.23039799999999	5.4545454545454604
1893	32.879947477581403	-117.230353763081	0
1894	32.879947477564102	-117.230318813612	0
1895	32.879962584318001	-117.23035380458499	0
1896	32.879962584300799	-117.230318887907	0
1897	32.879981000000001	-117.23044	5.4545454545454604
1898	32.879965477577699	-117.230386194182	0
1899	32.879965477556198	-117.230349044373	0
1900	32.879987040825597	-117.23038626624	0
1901	32.879987040804103	-117.230349166183	0
1902	32.879995000000001	-117.230445	5.4545454545454604
1903	32.880038717284002	-117.230319456141	0
1904	32.880038717234498	-117.230277293798	0
1905	32.880091648893	-117.23031987038	0
1906	32.880091648843901	-117.230277847153	0
1907	32.880011000000003	-117.230446	5.4545454545454604
1908	32.880028598380598	-117.230307740718	0
1909	32.880028598326199	-117.230265152263	0
1910	32.8800820825507	-117.230308200924	0
1911	32.880082082496699	-117.230265754228	0
1912	32.880025000000003	-117.230446	5.4545454545454604
1913	32.880103938305503	-117.23028374898399	0
1914	32.880103938241497	-117.23024020395501	0
1915	32.880157455812999	-117.230284291457	0
1916	32.880157455749298	-117.230240892018	0
1917	32.880032999999997	-117.230441	5.4545454545454604
1918	32.8800986929567	-117.230217774322	0
1919	32.8800986929148	-117.230195423753	0
1920	32.880150534657901	-117.23021849669099	0
1921	32.880150534616199	-117.230196218449	0
1922	32.880020000000002	-117.23042599999999	5.4545454545454604
1923	32.880107102608697	-117.230216597292	0
1924	32.880107102543597	-117.230180751982	0
1925	32.880156543145397	-117.230217244408	0
1926	32.880156543080702	-117.230181509871	0
1927	32.87997	-117.230378	5.4545454545454604
1928	32.880133279575297	-117.230164129424	0
1929	32.880133279523598	-117.230135741539	0
1930	32.880172842485898	-117.230164660833	0
1931	32.880172842434398	-117.230136343485	0
1932	32.880071000000001	-117.23028499999999	5.4545454545454604
1933	32.880222554381497	-117.230257629291	0
1934	32.8802225543688	-117.230222333483	0
1935	32.8802661704784	-117.23025770421199	0
1936	32.880266170465703	-117.23022250501801	0
1937	32.880076000000003	-117.230255	5.4545454545454604
1938	32.8802071977453	-117.230107881454	0
1939	32.880207197696599	-117.230071070127	0
1940	32.880252301528202	-117.230108297361	0
1941	32.8802523014798	-117.23007159010101	0
1942	32.880077999999997	-117.230228	5.4545454545454604
1943	32.880191059184	-117.22999771840099	0
1944	32.880191059156303	-117.22998314972099	0
1945	32.880229052167898	-117.22999826615499	0
1946	32.8802290521404	-117.22998373212801	0
1947	32.880080999999997	-117.230208	5.4545454545454604
1948	32.880265929363901	-117.230171590579	0
1949	32.880265929356298	-117.230151276092	0
1950	32.880283842654499	-117.23017163159599	0
1951	32.880283842646897	-117.230151339996	0
1952	32.88006	-117.23019499999999	5.4545454545454604
1953	32.880089521688703	-117.23005944563501	0
1954	32.880089521658199	-117.23003377883801	0
1955	32.880130638851	-117.230059792766	0
1956	32.880130638820702	-117.230034191697	0
1957	32.880040000000001	-117.23018999999999	5.4545454545454604
1958	32.880024925872398	-117.229962681077	0
1959	32.8800249258354	-117.229943185633	0
1960	32.880048340708797	-117.229963011658	0
1961	32.880048340671998	-117.229943544565	0
1962	32.879914999999997	-117.23028600000001	5.4545454545454604
1963	32.8800602140903	-117.230085007753	0
1964	32.880060214035403	-117.230053345459	0
1965	32.880098929379102	-117.23008549590899	0
1966	32.880098929324497	-117.230053910514	0
1967	32.880035999999997	-117.230318	5.4545454545454604
1968	32.880020477589099	-117.230309889465	0
1969	32.8800204775822	-117.230275656356	0
1970	32.880045235211497	-117.230309901936	0
1971	32.880045235204598	-117.230275721464	0
1972	32.880029999999998	-117.23030799999999	5.4545454545454604
1973	32.880050788240901	-117.23031022089999	0
1974	32.880050788236296	-117.230274227007	0
1975	32.880095185724898	-117.230310214762	0
1976	32.8800951857203	-117.230274320343	0
1977	32.879966000000003	-117.23036999999999	5.4545454545454604
1978	32.880025284274197	-117.230144087618	0
1979	32.880025284236901	-117.230124325696	0
1980	32.8800553162855	-117.23014451095401	0
1981	32.880055316248402	-117.230124786064	0
1982	32.879966000000003	-117.23036999999999	5.4545454545454604
1983	32.880083597841001	-117.23027827395499	0
1984	32.880083597807101	-117.230239959618	0
1985	32.880132850336402	-117.230278556877	0
1986	32.880132850302601	-117.230240360717	0
1987	32.879966000000003	-117.23036999999999	5.4545454545454604
1988	32.880148679556797	-117.23034162143399	0
1989	32.880148679549499	-117.230318726527	0
1990	32.880168842664901	-117.230341657415	0
1991	32.880168842657604	-117.230318791535	0
1992	32.879962999999996	-117.23039799999999	5.4545454545454604
1993	32.879947477581403	-117.230353763081	0
1994	32.879947477564102	-117.230318813612	0
1995	32.879962584318001	-117.23035380458499	0
1996	32.879962584300799	-117.230318887907	0
1997	32.879981000000001	-117.23044	5.4545454545454604
1998	32.879965477577699	-117.230386194182	0
1999	32.879965477556198	-117.230349044373	0
2000	32.879987040825597	-117.23038626624	0
2001	32.879987040804103	-117.230349166183	0
2002	32.879995000000001	-117.230445	5.4545454545454604
2003	32.880038717284002	-117.230319456141	0
2004	32.880038717234498	-117.230277293798	0
2005	32.880091648893	-117.23031987038	0
2006	32.880091648843901	-117.230277847153	0
2007	32.880011000000003	-117.230446	5.4545454545454604
2008	32.880028598380598	-117.230307740718	0
2009	32.880028598326199	-117.230265152263	0
2010	32.8800820825507	-117.230308200924	0
2011	32.880082082496699	-117.230265754228	0
2012	32.880025000000003	-117.230446	5.4545454545454604
2013	32.880103938305503	-117.23028374898399	0
2014	32.880103938241497	-117.23024020395501	0
2015	32.880157455812999	-117.230284291457	0
2016	32.880157455749298	-117.230240892018	0
2017	32.880032999999997	-117.230441	5.4545454545454604
2018	32.8800986929567	-117.230217774322	0
2019	32.8800986929148	-117.230195423753	0
2020	32.880150534657901	-117.23021849669099	0
2021	32.880150534616199	-117.230196218449	0
2022	32.880020000000002	-117.23042599999999	5.4545454545454604
2023	32.880107102608697	-117.230216597292	0
2024	32.880107102543597	-117.230180751982	0
2025	32.880156543145397	-117.230217244408	0
2026	32.880156543080702	-117.230181509871	0
2027	32.87997	-117.230378	5.4545454545454604
2028	32.880133279575297	-117.230164129424	0
2029	32.880133279523598	-117.230135741539	0
2030	32.880172842485898	-117.230164660833	0
2031	32.880172842434398	-117.230136343485	0
2032	32.880071000000001	-117.23028499999999	5.4545454545454604
2033	32.880222554381497	-117.230257629291	0
2034	32.8802225543688	-117.230222333483	0
2035	32.8802661704784	-117.23025770421199	0
2036	32.880266170465703	-117.23022250501801	0
2037	32.880076000000003	-117.230255	5.4545454545454604
2038	32.8802071977453	-117.230107881454	0
2039	32.880207197696599	-117.230071070127	0
2040	32.880252301528202	-117.230108297361	0
2041	32.8802523014798	-117.23007159010101	0
2042	32.880077999999997	-117.230228	5.4545454545454604
2043	32.880191059184	-117.22999771840099	0
2044	32.880191059156303	-117.22998314972099	0
2045	32.880229052167898	-117.22999826615499	0
2046	32.8802290521404	-117.22998373212801	0
2047	32.880080999999997	-117.230208	5.4545454545454604
2048	32.880265929363901	-117.230171590579	0
2049	32.880265929356298	-117.230151276092	0
2050	32.880283842654499	-117.23017163159599	0
2051	32.880283842646897	-117.230151339996	0
2052	32.88006	-117.23019499999999	5.4545454545454604
2053	32.880089521688703	-117.23005944563501	0
2054	32.880089521658199	-117.23003377883801	0
2055	32.880130638851	-117.230059792766	0
2056	32.880130638820702	-117.230034191697	0
2057	32.880040000000001	-117.23018999999999	5.4545454545454604
2058	32.880024925872398	-117.229962681077	0
2059	32.8800249258354	-117.229943185633	0
2060	32.880048340708797	-117.229963011658	0
2061	32.880048340671998	-117.229943544565	0
2062	32.879979413515997	-117.23046344705401	-0.010597004555165801
2063	32.879914999999997	-117.23028600000001	5.4545454545454604
2064	32.8800602140903	-117.230085007753	0
2065	32.880060214035403	-117.230053345459	0
2066	32.880098929379102	-117.23008549590899	0
2067	32.880098929324497	-117.230053910514	0
2068	32.880035999999997	-117.230318	5.4545454545454604
2069	32.880020477589099	-117.230309889465	0
2070	32.8800204775822	-117.230275656356	0
2071	32.880045235211497	-117.230309901936	0
2072	32.880045235204598	-117.230275721464	0
2073	32.880029999999998	-117.23030799999999	5.4545454545454604
2074	32.880050788240901	-117.23031022089999	0
2075	32.880050788236296	-117.230274227007	0
2076	32.880095185724898	-117.230310214762	0
2077	32.8800951857203	-117.230274320343	0
2078	32.879966000000003	-117.23036999999999	5.4545454545454604
2079	32.880025284274197	-117.230144087618	0
2080	32.880025284236901	-117.230124325696	0
2081	32.8800553162855	-117.23014451095401	0
2082	32.880055316248402	-117.230124786064	0
2083	32.879966000000003	-117.23036999999999	5.4545454545454604
2084	32.880083597841001	-117.23027827395499	0
2085	32.880083597807101	-117.230239959618	0
2086	32.880132850336402	-117.230278556877	0
2087	32.880132850302601	-117.230240360717	0
2088	32.879966000000003	-117.23036999999999	5.4545454545454604
2089	32.880148679556797	-117.23034162143399	0
2090	32.880148679549499	-117.230318726527	0
2091	32.880168842664901	-117.230341657415	0
2092	32.880168842657604	-117.230318791535	0
2093	32.879962999999996	-117.23039799999999	5.4545454545454604
2094	32.879947477581403	-117.230353763081	0
2095	32.879947477564102	-117.230318813612	0
2096	32.879962584318001	-117.23035380458499	0
2097	32.879962584300799	-117.230318887907	0
2098	32.879981000000001	-117.23044	5.4545454545454604
2099	32.879965477577699	-117.230386194182	0
2100	32.879965477556198	-117.230349044373	0
2101	32.879987040825597	-117.23038626624	0
2102	32.879987040804103	-117.230349166183	0
2103	32.879995000000001	-117.230445	5.4545454545454604
2104	32.880038717284002	-117.230319456141	0
2105	32.880038717234498	-117.230277293798	0
2106	32.880091648893	-117.23031987038	0
2107	32.880091648843901	-117.230277847153	0
2108	32.880011000000003	-117.230446	5.4545454545454604
2109	32.880028598380598	-117.230307740718	0
2110	32.880028598326199	-117.230265152263	0
2111	32.8800820825507	-117.230308200924	0
2112	32.880082082496699	-117.230265754228	0
2113	32.880025000000003	-117.230446	5.4545454545454604
2114	32.880103938305503	-117.23028374898399	0
2115	32.880103938241497	-117.23024020395501	0
2116	32.880157455812999	-117.230284291457	0
2117	32.880157455749298	-117.230240892018	0
2118	32.880032999999997	-117.230441	5.4545454545454604
2119	32.8800986929567	-117.230217774322	0
2120	32.8800986929148	-117.230195423753	0
2121	32.880150534657901	-117.23021849669099	0
2122	32.880150534616199	-117.230196218449	0
2123	32.880020000000002	-117.23042599999999	5.4545454545454604
2124	32.880107102608697	-117.230216597292	0
2125	32.880107102543597	-117.230180751982	0
2126	32.880156543145397	-117.230217244408	0
2127	32.880156543080702	-117.230181509871	0
2128	32.87997	-117.230378	5.4545454545454604
2129	32.880133279575297	-117.230164129424	0
2130	32.880133279523598	-117.230135741539	0
2131	32.880172842485898	-117.230164660833	0
2132	32.880172842434398	-117.230136343485	0
2133	32.880071000000001	-117.23028499999999	5.4545454545454604
2134	32.880222554381497	-117.230257629291	0
2135	32.8802225543688	-117.230222333483	0
2136	32.8802661704784	-117.23025770421199	0
2137	32.880266170465703	-117.23022250501801	0
2138	32.880076000000003	-117.230255	5.4545454545454604
2139	32.8802071977453	-117.230107881454	0
2140	32.880207197696599	-117.230071070127	0
2141	32.880252301528202	-117.230108297361	0
2142	32.8802523014798	-117.23007159010101	0
2143	32.880077999999997	-117.230228	5.4545454545454604
2144	32.880191059184	-117.22999771840099	0
2145	32.880191059156303	-117.22998314972099	0
2146	32.880229052167898	-117.22999826615499	0
2147	32.8802290521404	-117.22998373212801	0
2148	32.880080999999997	-117.230208	5.4545454545454604
2149	32.880265929363901	-117.230171590579	0
2150	32.880265929356298	-117.230151276092	0
2151	32.880283842654499	-117.23017163159599	0
2152	32.880283842646897	-117.230151339996	0
2153	32.88006	-117.23019499999999	5.4545454545454604
2154	32.880089521688703	-117.23005944563501	0
2155	32.880089521658199	-117.23003377883801	0
2156	32.880130638851	-117.230059792766	0
2157	32.880130638820702	-117.230034191697	0
2158	32.880040000000001	-117.23018999999999	5.4545454545454604
2159	32.880024925872398	-117.229962681077	0
2160	32.8800249258354	-117.229943185633	0
2161	32.880048340708797	-117.229963011658	0
2162	32.880048340671998	-117.229943544565	0
2163	32.879914999999997	-117.23028600000001	5.4545454545454604
2164	32.880029999999998	-117.23030799999999	5.4545454545454604
2165	32.879966000000003	-117.23036999999999	5.4545454545454604
2166	32.880025284274197	-117.230144087618	0
2167	32.880025284236901	-117.230124325696	0
2168	32.8800553162855	-117.23014451095401	0
2169	32.880055316248402	-117.230124786064	0
2170	32.879966000000003	-117.23036999999999	5.4545454545454604
2171	32.880083597841001	-117.23027827395499	0
2172	32.880083597807101	-117.230239959618	0
2173	32.880132850336402	-117.230278556877	0
2174	32.880132850302601	-117.230240360717	0
2175	32.879966000000003	-117.23036999999999	5.4545454545454604
2176	32.880148679556797	-117.23034162143399	0
2177	32.880148679549499	-117.230318726527	0
2178	32.880168842664901	-117.230341657415	0
2179	32.880168842657604	-117.230318791535	0
2180	32.879962999999996	-117.23039799999999	5.4545454545454604
2181	32.879947477581403	-117.230353763081	0
2182	32.879947477564102	-117.230318813612	0
2183	32.879962584318001	-117.23035380458499	0
2184	32.879962584300799	-117.230318887907	0
2185	32.879981000000001	-117.23044	5.4545454545454604
2186	32.879965477577699	-117.230386194182	0
2187	32.879965477556198	-117.230349044373	0
2188	32.879987040825597	-117.23038626624	0
2189	32.879987040804103	-117.230349166183	0
2190	32.879995000000001	-117.230445	5.4545454545454604
2191	32.880038717284002	-117.230319456141	0
2192	32.880038717234498	-117.230277293798	0
2193	32.880091648893	-117.23031987038	0
2194	32.880091648843901	-117.230277847153	0
2195	32.879914999999997	-117.23028600000001	5.4545454545454604
2196	32.880029999999998	-117.23030799999999	5.4545454545454604
2197	32.880050788240901	-117.23031022089999	0
2198	32.880050788236296	-117.230274227007	0
2199	32.880095185724898	-117.230310214762	0
2200	32.8800951857203	-117.230274320343	0
2201	32.879966000000003	-117.23036999999999	5.4545454545454604
2202	32.880025284274197	-117.230144087618	0
2203	32.880025284236901	-117.230124325696	0
2204	32.8800553162855	-117.23014451095401	0
2205	32.880055316248402	-117.230124786064	0
2206	32.879966000000003	-117.23036999999999	5.4545454545454604
2207	32.880083597841001	-117.23027827395499	0
2208	32.880083597807101	-117.230239959618	0
2209	32.880132850336402	-117.230278556877	0
2210	32.880132850302601	-117.230240360717	0
2211	32.879966000000003	-117.23036999999999	5.4545454545454604
2212	32.880148679556797	-117.23034162143399	0
2213	32.880148679549499	-117.230318726527	0
2214	32.880168842664901	-117.230341657415	0
2215	32.880168842657604	-117.230318791535	0
2216	32.879962999999996	-117.23039799999999	5.4545454545454604
2217	32.879947477581403	-117.230353763081	0
2218	32.879947477564102	-117.230318813612	0
2219	32.879962584318001	-117.23035380458499	0
2220	32.879962584300799	-117.230318887907	0
2221	32.879981000000001	-117.23044	5.4545454545454604
2222	32.879965477577699	-117.230386194182	0
2223	32.879965477556198	-117.230349044373	0
2224	32.879987040825597	-117.23038626624	0
2225	32.879987040804103	-117.230349166183	0
2226	32.879995000000001	-117.230445	5.4545454545454604
2227	32.880038717284002	-117.230319456141	0
2228	32.880038717234498	-117.230277293798	0
2229	32.880091648893	-117.23031987038	0
2230	32.880091648843901	-117.230277847153	0
2231	32.880011000000003	-117.230446	5.4545454545454604
2232	32.880028598380598	-117.230307740718	0
2233	32.880028598326199	-117.230265152263	0
2234	32.8800820825507	-117.230308200924	0
2235	32.880082082496699	-117.230265754228	0
2236	32.880025000000003	-117.230446	5.4545454545454604
2237	32.880103938305503	-117.23028374898399	0
2238	32.880103938241497	-117.23024020395501	0
2239	32.880157455812999	-117.230284291457	0
2240	32.880157455749298	-117.230240892018	0
2241	32.880032999999997	-117.230441	5.4545454545454604
2242	32.8800986929567	-117.230217774322	0
2243	32.8800986929148	-117.230195423753	0
2244	32.880150534657901	-117.23021849669099	0
2245	32.880150534616199	-117.230196218449	0
2246	32.880020000000002	-117.23042599999999	5.4545454545454604
2247	32.880107102608697	-117.230216597292	0
2248	32.880107102543597	-117.230180751982	0
2249	32.880156543145397	-117.230217244408	0
2250	32.880156543080702	-117.230181509871	0
2251	32.87997	-117.230378	5.4545454545454604
2252	32.880133279575297	-117.230164129424	0
2253	32.880133279523598	-117.230135741539	0
2254	32.880172842485898	-117.230164660833	0
2255	32.880172842434398	-117.230136343485	0
2256	32.880071000000001	-117.23028499999999	5.4545454545454604
2257	32.880222554381497	-117.230257629291	0
2258	32.8802225543688	-117.230222333483	0
2259	32.8802661704784	-117.23025770421199	0
2260	32.880266170465703	-117.23022250501801	0
2261	32.880076000000003	-117.230255	5.4545454545454604
2262	32.8802071977453	-117.230107881454	0
2263	32.880207197696599	-117.230071070127	0
2264	32.880252301528202	-117.230108297361	0
2265	32.8802523014798	-117.23007159010101	0
2266	32.880077999999997	-117.230228	5.4545454545454604
2267	32.880191059184	-117.22999771840099	0
2268	32.880191059156303	-117.22998314972099	0
2269	32.880229052167898	-117.22999826615499	0
2270	32.8802290521404	-117.22998373212801	0
2271	32.880080999999997	-117.230208	5.4545454545454604
2272	32.880265929363901	-117.230171590579	0
2273	32.880265929356298	-117.230151276092	0
2274	32.880283842654499	-117.23017163159599	0
2275	32.880283842646897	-117.230151339996	0
2276	32.88006	-117.23019499999999	5.4545454545454604
2277	32.880089521688703	-117.23005944563501	0
2278	32.880089521658199	-117.23003377883801	0
2279	32.880130638851	-117.230059792766	0
2280	32.880130638820702	-117.230034191697	0
2281	32.880040000000001	-117.23018999999999	5.4545454545454604
2282	32.880024925872398	-117.229962681077	0
2283	32.8800249258354	-117.229943185633	0
2284	32.880048340708797	-117.229963011658	0
2285	32.880048340671998	-117.229943544565	0
2286	32.879914999999997	-117.23028600000001	5.4545454545454604
2287	32.880029999999998	-117.23030799999999	5.4545454545454604
2288	32.880050788240901	-117.23031022089999	0
2289	32.880050788236296	-117.230274227007	0
2290	32.880095185724898	-117.230310214762	0
2291	32.8800951857203	-117.230274320343	0
2292	32.879966000000003	-117.23036999999999	5.4545454545454604
2293	32.880025284274197	-117.230144087618	0
2294	32.880025284236901	-117.230124325696	0
2295	32.8800553162855	-117.23014451095401	0
2296	32.880055316248402	-117.230124786064	0
2297	32.879966000000003	-117.23036999999999	5.4545454545454604
2298	32.880083597841001	-117.23027827395499	0
2299	32.880083597807101	-117.230239959618	0
2300	32.880132850336402	-117.230278556877	0
2301	32.880132850302601	-117.230240360717	0
2302	32.879966000000003	-117.23036999999999	5.4545454545454604
2303	32.880148679556797	-117.23034162143399	0
2304	32.880148679549499	-117.230318726527	0
2305	32.880168842664901	-117.230341657415	0
2306	32.880168842657604	-117.230318791535	0
2307	32.879962999999996	-117.23039799999999	5.4545454545454604
2308	32.879947477581403	-117.230353763081	0
2309	32.879947477564102	-117.230318813612	0
2310	32.879962584318001	-117.23035380458499	0
2311	32.879962584300799	-117.230318887907	0
2312	32.879981000000001	-117.23044	5.4545454545454604
2313	32.879965477577699	-117.230386194182	0
2314	32.879965477556198	-117.230349044373	0
2315	32.879987040825597	-117.23038626624	0
2316	32.879987040804103	-117.230349166183	0
2317	32.879995000000001	-117.230445	5.4545454545454604
2318	32.880038717284002	-117.230319456141	0
2319	32.880038717234498	-117.230277293798	0
2320	32.880091648893	-117.23031987038	0
2321	32.880091648843901	-117.230277847153	0
2322	32.880011000000003	-117.230446	5.4545454545454604
2323	32.880028598380598	-117.230307740718	0
2324	32.880028598326199	-117.230265152263	0
2325	32.8800820825507	-117.230308200924	0
2326	32.880082082496699	-117.230265754228	0
2327	32.880025000000003	-117.230446	5.4545454545454604
2328	32.880103938305503	-117.23028374898399	0
2329	32.880103938241497	-117.23024020395501	0
2330	32.880157455812999	-117.230284291457	0
2331	32.880157455749298	-117.230240892018	0
2332	32.880032999999997	-117.230441	5.4545454545454604
2333	32.8800986929567	-117.230217774322	0
2334	32.8800986929148	-117.230195423753	0
2335	32.880150534657901	-117.23021849669099	0
2336	32.880150534616199	-117.230196218449	0
2337	32.880020000000002	-117.23042599999999	5.4545454545454604
2338	32.880107102608697	-117.230216597292	0
2339	32.880107102543597	-117.230180751982	0
2340	32.880156543145397	-117.230217244408	0
2341	32.880156543080702	-117.230181509871	0
2342	32.87997	-117.230378	5.4545454545454604
2343	32.880133279575297	-117.230164129424	0
2344	32.880133279523598	-117.230135741539	0
2345	32.880172842485898	-117.230164660833	0
2346	32.880172842434398	-117.230136343485	0
2347	32.880071000000001	-117.23028499999999	5.4545454545454604
2348	32.880222554381497	-117.230257629291	0
2349	32.8802225543688	-117.230222333483	0
2350	32.8802661704784	-117.23025770421199	0
2351	32.880266170465703	-117.23022250501801	0
2352	32.880076000000003	-117.230255	5.4545454545454604
2353	32.8802071977453	-117.230107881454	0
2354	32.880207197696599	-117.230071070127	0
2355	32.880252301528202	-117.230108297361	0
2356	32.8802523014798	-117.23007159010101	0
2357	32.880077999999997	-117.230228	5.4545454545454604
2358	32.880191059184	-117.22999771840099	0
2359	32.880191059156303	-117.22998314972099	0
2360	32.880229052167898	-117.22999826615499	0
2361	32.8802290521404	-117.22998373212801	0
2362	32.880080999999997	-117.230208	5.4545454545454604
2363	32.880265929363901	-117.230171590579	0
2364	32.880265929356298	-117.230151276092	0
2365	32.880283842654499	-117.23017163159599	0
2366	32.880283842646897	-117.230151339996	0
2367	32.88006	-117.23019499999999	5.4545454545454604
2368	32.880089521688703	-117.23005944563501	0
2369	32.880089521658199	-117.23003377883801	0
2370	32.880130638851	-117.230059792766	0
2371	32.880130638820702	-117.230034191697	0
2372	32.880040000000001	-117.23018999999999	5.4545454545454604
2373	32.880024925872398	-117.229962681077	0
2374	32.8800249258354	-117.229943185633	0
2375	32.880048340708797	-117.229963011658	0
2376	32.880048340671998	-117.229943544565	0
2377	32.879914999999997	-117.23028600000001	5.4545454545454604
2378	32.879914999999997	-117.23028600000001	5.4545454545454604
2379	32.880029999999998	-117.23030799999999	5.4545454545454604
2380	32.880050788240901	-117.23031022089999	0
2381	32.880050788236296	-117.230274227007	0
2382	32.880095185724898	-117.230310214762	0
2383	32.8800951857203	-117.230274320343	0
2384	32.879966000000003	-117.23036999999999	5.4545454545454604
2385	32.880025284274197	-117.230144087618	0
2386	32.880025284236901	-117.230124325696	0
2387	32.8800553162855	-117.23014451095401	0
2388	32.880055316248402	-117.230124786064	0
2389	32.879966000000003	-117.23036999999999	5.4545454545454604
2390	32.880083597841001	-117.23027827395499	0
2391	32.880083597807101	-117.230239959618	0
2392	32.880132850336402	-117.230278556877	0
2393	32.880132850302601	-117.230240360717	0
2394	32.879966000000003	-117.23036999999999	5.4545454545454604
2395	32.880148679556797	-117.23034162143399	0
2396	32.880148679549499	-117.230318726527	0
2397	32.880168842664901	-117.230341657415	0
2398	32.880168842657604	-117.230318791535	0
2399	32.879914999999997	-117.23028600000001	5.4545454545454604
2400	32.880029999999998	-117.23030799999999	5.4545454545454604
2401	32.880050788240901	-117.23031022089999	0
2402	32.880050788236296	-117.230274227007	0
2403	32.880095185724898	-117.230310214762	0
2404	32.8800951857203	-117.230274320343	0
2405	32.879914999999997	-117.23028600000001	5.4545454545454604
2406	32.880029999999998	-117.23030799999999	5.4545454545454604
2407	32.880050788240901	-117.23031022089999	0
2408	32.880050788236296	-117.230274227007	0
2409	32.880095185724898	-117.230310214762	0
2410	32.8800951857203	-117.230274320343	0
2411	32.879966000000003	-117.23036999999999	5.4545454545454604
2412	32.880025284274197	-117.230144087618	0
2413	32.880025284236901	-117.230124325696	0
2414	32.8800553162855	-117.23014451095401	0
2415	32.880055316248402	-117.230124786064	0
2416	32.879966000000003	-117.23036999999999	5.4545454545454604
2417	32.880083597841001	-117.23027827395499	0
2418	32.880083597807101	-117.230239959618	0
2419	32.880132850336402	-117.230278556877	0
2420	32.880132850302601	-117.230240360717	0
2421	32.879966000000003	-117.23036999999999	5.4545454545454604
2422	32.880148679556797	-117.23034162143399	0
2423	32.880148679549499	-117.230318726527	0
2424	32.880168842664901	-117.230341657415	0
2425	32.880168842657604	-117.230318791535	0
2426	32.879962999999996	-117.23039799999999	5.4545454545454604
2427	32.879947477581403	-117.230353763081	0
2428	32.879947477564102	-117.230318813612	0
2429	32.879962584318001	-117.23035380458499	0
2430	32.879962584300799	-117.230318887907	0
2431	32.879981000000001	-117.23044	5.4545454545454604
2432	32.879965477577699	-117.230386194182	0
2433	32.879965477556198	-117.230349044373	0
2434	32.879987040825597	-117.23038626624	0
2435	32.879987040804103	-117.230349166183	0
2436	32.879995000000001	-117.230445	5.4545454545454604
2437	32.880038717284002	-117.230319456141	0
2438	32.880038717234498	-117.230277293798	0
2439	32.880091648893	-117.23031987038	0
2440	32.880091648843901	-117.230277847153	0
2441	32.880011000000003	-117.230446	5.4545454545454604
2442	32.880028598380598	-117.230307740718	0
2443	32.880028598326199	-117.230265152263	0
2444	32.8800820825507	-117.230308200924	0
2445	32.880082082496699	-117.230265754228	0
2446	32.880025000000003	-117.230446	5.4545454545454604
2447	32.880103938305503	-117.23028374898399	0
2448	32.880103938241497	-117.23024020395501	0
2449	32.880157455812999	-117.230284291457	0
2450	32.880157455749298	-117.230240892018	0
2451	32.880032999999997	-117.230441	5.4545454545454604
2452	32.8800986929567	-117.230217774322	0
2453	32.8800986929148	-117.230195423753	0
2454	32.880150534657901	-117.23021849669099	0
2455	32.880150534616199	-117.230196218449	0
2456	32.880020000000002	-117.23042599999999	5.4545454545454604
2457	32.880107102608697	-117.230216597292	0
2458	32.880107102543597	-117.230180751982	0
2459	32.880156543145397	-117.230217244408	0
2460	32.880156543080702	-117.230181509871	0
2461	32.87997	-117.230378	5.4545454545454604
2462	32.880133279575297	-117.230164129424	0
2463	32.880133279523598	-117.230135741539	0
2464	32.880172842485898	-117.230164660833	0
2465	32.880172842434398	-117.230136343485	0
2466	32.880071000000001	-117.23028499999999	5.4545454545454604
2467	32.880222554381497	-117.230257629291	0
2468	32.8802225543688	-117.230222333483	0
2469	32.8802661704784	-117.23025770421199	0
2470	32.880266170465703	-117.23022250501801	0
2471	32.880076000000003	-117.230255	5.4545454545454604
2472	32.8802071977453	-117.230107881454	0
2473	32.880207197696599	-117.230071070127	0
2474	32.880252301528202	-117.230108297361	0
2475	32.8802523014798	-117.23007159010101	0
2476	32.880077999999997	-117.230228	5.4545454545454604
2477	32.880191059184	-117.22999771840099	0
2478	32.880191059156303	-117.22998314972099	0
2479	32.880229052167898	-117.22999826615499	0
2480	32.8802290521404	-117.22998373212801	0
2481	32.880080999999997	-117.230208	5.4545454545454604
2482	32.879914999999997	-117.23028600000001	5.4545454545454604
2483	32.880029999999998	-117.23030799999999	5.4545454545454604
2484	32.880050788240901	-117.23031022089999	0
2485	32.880050788236296	-117.230274227007	0
2486	32.880095185724898	-117.230310214762	0
2487	32.8800951857203	-117.230274320343	0
2488	32.879966000000003	-117.23036999999999	5.4545454545454604
2489	32.880025284274197	-117.230144087618	0
2490	32.880025284236901	-117.230124325696	0
2491	32.8800553162855	-117.23014451095401	0
2492	32.880055316248402	-117.230124786064	0
2493	32.879966000000003	-117.23036999999999	5.4545454545454604
2494	32.880083597841001	-117.23027827395499	0
2495	32.880083597807101	-117.230239959618	0
2496	32.880132850336402	-117.230278556877	0
2497	32.880132850302601	-117.230240360717	0
2498	32.879966000000003	-117.23036999999999	5.4545454545454604
2499	32.880148679556797	-117.23034162143399	0
2500	32.880148679549499	-117.230318726527	0
2501	32.880168842664901	-117.230341657415	0
2502	32.880168842657604	-117.230318791535	0
2503	32.879962999999996	-117.23039799999999	5.4545454545454604
2504	32.879947477581403	-117.230353763081	0
2505	32.879947477564102	-117.230318813612	0
2506	32.879962584318001	-117.23035380458499	0
2507	32.879962584300799	-117.230318887907	0
2508	32.879981000000001	-117.23044	5.4545454545454604
2509	32.879965477577699	-117.230386194182	0
2510	32.879965477556198	-117.230349044373	0
2511	32.879987040825597	-117.23038626624	0
2512	32.879987040804103	-117.230349166183	0
2513	32.879995000000001	-117.230445	5.4545454545454604
2514	32.880038717284002	-117.230319456141	0
2515	32.880038717234498	-117.230277293798	0
2516	32.880091648893	-117.23031987038	0
2517	32.880091648843901	-117.230277847153	0
2518	32.880011000000003	-117.230446	5.4545454545454604
2519	32.880028598380598	-117.230307740718	0
2520	32.880028598326199	-117.230265152263	0
2521	32.8800820825507	-117.230308200924	0
2522	32.880082082496699	-117.230265754228	0
2523	32.880025000000003	-117.230446	5.4545454545454604
2524	32.880103938305503	-117.23028374898399	0
2525	32.880103938241497	-117.23024020395501	0
2526	32.880157455812999	-117.230284291457	0
2527	32.880157455749298	-117.230240892018	0
2528	32.880032999999997	-117.230441	5.4545454545454604
2529	32.8800986929567	-117.230217774322	0
2530	32.8800986929148	-117.230195423753	0
2531	32.880150534657901	-117.23021849669099	0
2532	32.880150534616199	-117.230196218449	0
2533	32.880020000000002	-117.23042599999999	5.4545454545454604
2534	32.880107102608697	-117.230216597292	0
2535	32.880107102543597	-117.230180751982	0
2536	32.880156543145397	-117.230217244408	0
2537	32.880156543080702	-117.230181509871	0
2538	32.87997	-117.230378	5.4545454545454604
2539	32.880133279575297	-117.230164129424	0
2540	32.880133279523598	-117.230135741539	0
2541	32.880172842485898	-117.230164660833	0
2542	32.880172842434398	-117.230136343485	0
2543	32.880071000000001	-117.23028499999999	5.4545454545454604
2544	32.880222554381497	-117.230257629291	0
2545	32.8802225543688	-117.230222333483	0
2546	32.8802661704784	-117.23025770421199	0
2547	32.880266170465703	-117.23022250501801	0
2548	32.880076000000003	-117.230255	5.4545454545454604
2549	32.8802071977453	-117.230107881454	0
2550	32.880207197696599	-117.230071070127	0
2551	32.880252301528202	-117.230108297361	0
2552	32.8802523014798	-117.23007159010101	0
2553	32.880077999999997	-117.230228	5.4545454545454604
2554	32.880191059184	-117.22999771840099	0
2555	32.880191059156303	-117.22998314972099	0
2556	32.880229052167898	-117.22999826615499	0
2557	32.8802290521404	-117.22998373212801	0
2558	32.880080999999997	-117.230208	5.4545454545454604
2559	32.880265929363901	-117.230171590579	0
2560	32.880265929356298	-117.230151276092	0
2561	32.880283842654499	-117.23017163159599	0
2562	32.880283842646897	-117.230151339996	0
2563	32.88006	-117.23019499999999	5.4545454545454604
2564	32.880089521688703	-117.23005944563501	0
2565	32.880089521658199	-117.23003377883801	0
2566	32.880130638851	-117.230059792766	0
2567	32.880130638820702	-117.230034191697	0
2568	32.880040000000001	-117.23018999999999	5.4545454545454604
2569	32.880024925872398	-117.229962681077	0
2570	32.8800249258354	-117.229943185633	0
2571	32.880048340708797	-117.229963011658	0
2572	32.880048340671998	-117.229943544565	0
2573	32.879914999999997	-117.23028600000001	5.4545454545454604
2574	32.879914999999997	-117.23028600000001	5.4545454545454604
2575	32.8800602140903	-117.230085007753	0
2576	32.880060214035403	-117.230053345459	0
2577	32.880098929379102	-117.23008549590899	0
2578	32.880098929324497	-117.230053910514	0
2579	32.880029999999998	-117.23030799999999	5.4545454545454604
2580	32.880050788240901	-117.23031022089999	0
2581	32.880050788236296	-117.230274227007	0
2582	32.880095185724898	-117.230310214762	0
2583	32.8800951857203	-117.230274320343	0
2584	32.879966000000003	-117.23036999999999	5.4545454545454604
2585	32.880025284274197	-117.230144087618	0
2586	32.880025284236901	-117.230124325696	0
2587	32.8800553162855	-117.23014451095401	0
2588	32.880055316248402	-117.230124786064	0
2589	32.879966000000003	-117.23036999999999	5.4545454545454604
2590	32.880083597841001	-117.23027827395499	0
2591	32.880083597807101	-117.230239959618	0
2592	32.880132850336402	-117.230278556877	0
2593	32.880132850302601	-117.230240360717	0
2594	32.879966000000003	-117.23036999999999	5.4545454545454604
2595	32.880148679556797	-117.23034162143399	0
2596	32.880148679549499	-117.230318726527	0
2597	32.880168842664901	-117.230341657415	0
2598	32.880168842657604	-117.230318791535	0
2599	32.879962999999996	-117.23039799999999	5.4545454545454604
2600	32.879947477581403	-117.230353763081	0
2601	32.879947477564102	-117.230318813612	0
2602	32.879962584318001	-117.23035380458499	0
2603	32.879962584300799	-117.230318887907	0
2604	32.879981000000001	-117.23044	5.4545454545454604
2605	32.879965477577699	-117.230386194182	0
2606	32.879965477556198	-117.230349044373	0
2607	32.879987040825597	-117.23038626624	0
2608	32.879987040804103	-117.230349166183	0
2609	32.879995000000001	-117.230445	5.4545454545454604
2610	32.880038717284002	-117.230319456141	0
2611	32.880038717234498	-117.230277293798	0
2612	32.880091648893	-117.23031987038	0
2613	32.880091648843901	-117.230277847153	0
2614	32.880011000000003	-117.230446	5.4545454545454604
2615	32.880028598380598	-117.230307740718	0
2616	32.880028598326199	-117.230265152263	0
2617	32.8800820825507	-117.230308200924	0
2618	32.880082082496699	-117.230265754228	0
2619	32.880025000000003	-117.230446	5.4545454545454604
2620	32.880103938305503	-117.23028374898399	0
2621	32.880103938241497	-117.23024020395501	0
2622	32.880157455812999	-117.230284291457	0
2623	32.880157455749298	-117.230240892018	0
2624	32.880032999999997	-117.230441	5.4545454545454604
2625	32.8800986929567	-117.230217774322	0
2626	32.8800986929148	-117.230195423753	0
2627	32.880150534657901	-117.23021849669099	0
2628	32.880150534616199	-117.230196218449	0
2629	32.880020000000002	-117.23042599999999	5.4545454545454604
2630	32.880107102608697	-117.230216597292	0
2631	32.880107102543597	-117.230180751982	0
2632	32.880156543145397	-117.230217244408	0
2633	32.880156543080702	-117.230181509871	0
2634	32.87997	-117.230378	5.4545454545454604
2635	32.880133279575297	-117.230164129424	0
2636	32.880133279523598	-117.230135741539	0
2637	32.880172842485898	-117.230164660833	0
2638	32.880172842434398	-117.230136343485	0
2639	32.880071000000001	-117.23028499999999	5.4545454545454604
2640	32.880222554381497	-117.230257629291	0
2641	32.8802225543688	-117.230222333483	0
2642	32.8802661704784	-117.23025770421199	0
2643	32.880266170465703	-117.23022250501801	0
2644	32.880076000000003	-117.230255	5.4545454545454604
2645	32.8802071977453	-117.230107881454	0
2646	32.880207197696599	-117.230071070127	0
2647	32.880252301528202	-117.230108297361	0
2648	32.8802523014798	-117.23007159010101	0
2649	32.880077999999997	-117.230228	5.4545454545454604
2650	32.880191059184	-117.22999771840099	0
2651	32.880191059156303	-117.22998314972099	0
2652	32.880229052167898	-117.22999826615499	0
2653	32.8802290521404	-117.22998373212801	0
2654	32.880080999999997	-117.230208	5.4545454545454604
2655	32.880265929363901	-117.230171590579	0
2656	32.880265929356298	-117.230151276092	0
2657	32.880283842654499	-117.23017163159599	0
2658	32.880283842646897	-117.230151339996	0
2659	32.88006	-117.23019499999999	5.4545454545454604
2660	32.880089521688703	-117.23005944563501	0
2661	32.880089521658199	-117.23003377883801	0
2662	32.880130638851	-117.230059792766	0
2663	32.880130638820702	-117.230034191697	0
2664	32.880040000000001	-117.23018999999999	5.4545454545454604
2665	32.880024925872398	-117.229962681077	0
2666	32.8800249258354	-117.229943185633	0
2667	32.880048340708797	-117.229963011658	0
2668	32.880048340671998	-117.229943544565	0
2669	32.879925	-117.23026299999999	35.151515151515198
2670	32.879912887640799	-117.22970295619101	0
2671	32.879914306030898	-117.22967661741301	0
2672	32.8799452263343	-117.229706238953	0
2673	32.8799466144037	-117.22967993935799	0
2674	32.879925	-117.23026299999999	35.151515151515198
2675	32.879912887640799	-117.22970295619101	0
2676	32.879914306030898	-117.22967661741301	0
2677	32.8799452263343	-117.229706238953	0
2678	32.8799466144037	-117.22967993935799	0
2679	32.879925	-117.23026299999999	35.151515151515198
2680	32.879813849688297	-117.230379055903	0
2681	32.879864022874102	-117.229481100744	0
2682	32.880566873448402	-117.230430102832	0
2683	32.880594204316502	-117.22956302632799	0
2684	32.879925	-117.23026299999999	35.151515151515198
2685	32.879813849688297	-117.230379055903	0
2686	32.879864022874102	-117.229481100744	0
2687	32.880566873448402	-117.230430102832	0
2688	32.880594204316502	-117.22956302632799	0
2689	32.879925	-117.23026299999999	35.151515151515198
2690	32.879813849688297	-117.230379055903	0
2691	32.879864022874102	-117.229481100744	0
2692	32.880566873448402	-117.230430102832	0
2693	32.880594204316502	-117.22956302632799	0
2694	32.879925	-117.23026299999999	35.151515151515198
2695	32.879813849688297	-117.230379055903	0
2696	32.879864022874102	-117.229481100744	0
2697	32.880566873448402	-117.230430102832	0
2698	32.880594204316502	-117.22956302632799	0
2699	32.879925	-117.23026299999999	35.151515151515198
2700	32.879912887640799	-117.22970295619101	0
2701	32.879914254806899	-117.22967756862	0
2702	32.8799452263343	-117.229706238953	0
2703	32.879946564274597	-117.229680889151	0
2704	32.879925	-117.23026299999999	35.151515151515198
2705	32.879814128760501	-117.230374061638	0
2706	32.879815615624302	-117.230347452724	0
2707	32.879832885478997	-117.230375337753	0
2708	32.879834354878	-117.23034875225299	0
2709	32.879925	-117.23026299999999	35.151515151515198
2710	32.879949309632103	-117.230119123186	0
2711	32.879950660591902	-117.230093113316	0
2712	32.879983561585398	-117.230121901158	0
2713	32.8799848813116	-117.230095932982	0
2714	32.879925	-117.23026299999999	35.151515151515198
2715	32.879870621595202	-117.229759258578	0
2716	32.879872029663197	-117.229733724344	0
2717	32.879903154503999	-117.229762463897	0
2718	32.879904533003398	-117.22973696788	0
2719	32.879925	-117.23026299999999	35.151515151515198
2720	32.880266131602099	-117.22962780413999	0
2721	32.8802671806069	-117.22960300571501	0
2722	32.880297246139101	-117.22963113628001	0
2723	32.880298268024298	-117.22960637388	0
2724	32.879925	-117.23026299999999	35.151515151515198
2725	32.880268135104203	-117.229617427459	0
2726	32.880269234317197	-117.229591410221	0
2727	32.880300397530803	-117.229620899708	0
2728	32.880301467235803	-117.229594921646	0
2729	32.879925	-117.23026299999999	35.151515151515198
2730	32.880213308401501	-117.2300771237	0
2731	32.8802144745029	-117.230050259311	0
2732	32.880246608060403	-117.23007993031101	0
2733	32.8802477431108	-117.230053108277	0
2734	32.879925	-117.23026299999999	35.151515151515198
2735	32.880228782737703	-117.229648176173	0
2736	32.880229865216101	-117.229623295873	0
2737	32.880260037515001	-117.229651485112	0
2738	32.880261092635102	-117.229626641077	0
2739	32.879925	-117.23026299999999	35.151515151515198
2740	32.880424237228503	-117.230214218729	0
2741	32.880425304592102	-117.230184872279	0
2742	32.880455400148698	-117.230216656862	0
2743	32.880456436203197	-117.230187354387	0
2744	32.879925	-117.23026299999999	35.151515151515198
2745	32.880543080002298	-117.22965746337999	0
2746	32.880543961272203	-117.22963084601299	0
2747	32.880574845030701	-117.22966086520501	0
2748	32.880575696983001	-117.229634287913	0
2749	32.879925	-117.23026299999999	35.151515151515198
2750	32.880212948924097	-117.22997556375	0
2751	32.880214111754	-117.229948870104	0
2752	32.880246147501097	-117.22997853081699	0
2753	32.8802472794683	-117.22995187897401	0
2754	32.879925	-117.23026299999999	35.151515151515198
2755	32.879912887640799	-117.22970295619101	0
2756	32.879914254806899	-117.22967756862	0
2757	32.8799452263343	-117.229706238953	0
2758	32.879946564274597	-117.229680889151	0
2759	32.879925	-117.23026299999999	35.151515151515198
2760	32.879814128760501	-117.230374061638	0
2761	32.879815615624302	-117.230347452724	0
2762	32.879832885478997	-117.230375337753	0
2763	32.879834354878	-117.23034875225299	0
2764	32.879925	-117.23026299999999	35.151515151515198
2765	32.879949309632103	-117.230119123186	0
2766	32.879950660591902	-117.230093113316	0
2767	32.879983561585398	-117.230121901158	0
2768	32.8799848813116	-117.230095932982	0
2769	32.879925	-117.23026299999999	35.151515151515198
2770	32.879870621595202	-117.229759258578	0
2771	32.879872029663197	-117.229733724344	0
2772	32.879903154503999	-117.229762463897	0
2773	32.879904533003398	-117.22973696788	0
2774	32.879925	-117.23026299999999	35.151515151515198
2775	32.880266131602099	-117.22962780413999	0
2776	32.8802671806069	-117.22960300571501	0
2777	32.880297246139101	-117.22963113628001	0
2778	32.880298268024298	-117.22960637388	0
2779	32.879925	-117.23026299999999	35.151515151515198
2780	32.880268135104203	-117.229617427459	0
2781	32.880269234317197	-117.229591410221	0
2782	32.880300397530803	-117.229620899708	0
2783	32.880301467235803	-117.229594921646	0
2784	32.879925	-117.23026299999999	35.151515151515198
2785	32.879912887640799	-117.22970295619101	0
2786	32.879914306030898	-117.22967661741301	0
2787	32.8799452263343	-117.229706238953	0
2788	32.8799466144037	-117.22967993935799	0
2789	32.879925	-117.23026299999999	35.151515151515198
2790	32.879888490931997	-117.229716793969	0
2791	32.879889880889301	-117.22969135174	0
2792	32.879922542370402	-117.22972022319	0
2793	32.879923901472502	-117.229694820788	0
2794	32.879925	-117.23026299999999	35.151515151515198
2795	32.879996456764701	-117.229685699204	0
2796	32.879997860414299	-117.229658243144	0
2797	32.880028504246297	-117.22968899332	0
2798	32.880029876666299	-117.229661577877	0
2799	32.879925	-117.23026299999999	35.151515151515198
2800	32.880349851021997	-117.229677785261	0
2801	32.880350877315003	-117.22965178167	0
2802	32.880382285563599	-117.22968119161899	0
2803	32.880383282373799	-117.229655227645	0
2804	32.879925	-117.23026299999999	35.151515151515198
2805	32.880540985662101	-117.229594665386	0
2806	32.880541877252703	-117.22956784782301	0
2807	32.880572318568703	-117.229598120866	0
2808	32.880573180958997	-117.22957134303	0
2809	32.879925	-117.23026299999999	35.151515151515198
2810	32.879899047076499	-117.229553299404	0
2811	32.879900489201198	-117.229526875595	0
2812	32.879932894699401	-117.22955698299801	0
2813	32.879934304811897	-117.229530600071	0
2814	32.879925	-117.23026299999999	35.151515151515198
2815	32.880173142182599	-117.22957094868001	0
2816	32.880174383866098	-117.229543636103	0
2817	32.880206068470102	-117.22957455209399	0
2818	32.880207278358803	-117.229547281214	0
2819	32.879925	-117.23026299999999	35.151515151515198
2820	32.879829413205101	-117.230100526336	0
2821	32.879831019813402	-117.23007177333299	0
2822	32.87984634056	-117.230101906597	0
2823	32.879847929994803	-117.23007317621899	0
2824	32.879925	-117.23026299999999	35.151515151515198
2825	32.880070565494798	-117.22966550009301	0
2826	32.8800718500977	-117.229639127246	0
2827	32.880103937730098	-117.229668976592	0
2828	32.880105191175602	-117.229642644493	0
2829	32.879925	-117.23026299999999	35.151515151515198
2830	32.8802585944321	-117.229593361951	0
2831	32.880259741104197	-117.22956644401	0
2832	32.880290864912602	-117.229596872423	0
2833	32.880291981010501	-117.229569994966	0
2834	32.879925	-117.23026299999999	35.151515151515198
2835	32.880378793983098	-117.22974182968299	0
2836	32.880379748192098	-117.22971700045601	0
2837	32.880409654336297	-117.229744975548	0
2838	32.880410581849503	-117.229720182454	0
2839	32.879925	-117.23026299999999	35.151515151515198
2840	32.880271234204798	-117.23030972582799	0
2841	32.880272354093897	-117.230282549704	0
2842	32.880304173400603	-117.230312124926	0
2843	32.8803052625303	-117.230284991666	0
2844	32.879925	-117.23026299999999	35.151515151515198
2845	32.8803082429258	-117.230299783238	0
2846	32.880309366556503	-117.230271709505	0
2847	32.880341441776999	-117.23030222238501	0
2848	32.880342533424702	-117.230274193345	0
2849	32.879925	-117.23026299999999	35.151515151515198
2850	32.880118666902703	-117.229652246847	0
2851	32.8801198469803	-117.22962721382299	0
2852	32.8801502829483	-117.22965556921299	0
2853	32.880151435051303	-117.229630572902	0
2854	32.879925	-117.23026299999999	35.151515151515198
2855	32.8803497226072	-117.22964172218801	0
2856	32.880350699085398	-117.229617012715	0
2857	32.880380581098798	-117.229645019179	0
2858	32.880381530888698	-117.229620345474	0
2859	32.879925	-117.23026299999999	35.151515151515198
2860	32.8805424170706	-117.22963159896101	0
2861	32.8805432678787	-117.229605940428	0
2862	32.8805726495115	-117.229634876405	0
2863	32.8805734733957	-117.22960925460301	0
2864	32.879925	-117.23026299999999	35.151515151515198
2865	32.880367378392897	-117.22960643347599	0
2866	32.880368338479002	-117.229581803166	0
2867	32.880398146536798	-117.22960977860301	0
2868	32.880399080087997	-117.229585183827	0
2869	32.879925	-117.23026299999999	35.151515151515198
2870	32.880481220384901	-117.229572728325	0
2871	32.880482006148398	-117.229550437724	0
2872	32.880511592176902	-117.22957610149101	0
2873	32.880512354330797	-117.229553842779	0
\.


--
-- TOC entry 1919 (class 0 OID 16676)
-- Dependencies: 166
-- Data for Name: location; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY location (loc_id, lower_left_gps, lower_right_gps, upper_left_gps, upper_right_gps) FROM stdin;
350	1854	1855	1856	1857
351	1862	1863	1864	1865
352	1868	1869	1870	1871
353	1873	1874	1875	1876
354	1878	1879	1880	1881
355	1883	1884	1885	1886
356	1888	1889	1890	1891
357	1893	1894	1895	1896
358	1898	1899	1900	1901
359	1903	1904	1905	1906
360	1908	1909	1910	1911
361	1913	1914	1915	1916
362	1918	1919	1920	1921
363	1923	1924	1925	1926
364	1928	1929	1930	1931
365	1933	1934	1935	1936
366	1938	1939	1940	1941
367	1943	1944	1945	1946
368	1948	1949	1950	1951
369	1953	1954	1955	1956
370	1958	1959	1960	1961
371	1963	1964	1965	1966
372	1968	1969	1970	1971
373	1973	1974	1975	1976
374	1978	1979	1980	1981
375	1983	1984	1985	1986
376	1988	1989	1990	1991
377	1993	1994	1995	1996
378	1998	1999	2000	2001
379	2003	2004	2005	2006
380	2008	2009	2010	2011
381	2013	2014	2015	2016
382	2018	2019	2020	2021
383	2023	2024	2025	2026
384	2028	2029	2030	2031
385	2033	2034	2035	2036
386	2038	2039	2040	2041
387	2043	2044	2045	2046
388	2048	2049	2050	2051
389	2053	2054	2055	2056
390	2058	2059	2060	2061
391	2064	2065	2066	2067
392	2069	2070	2071	2072
393	2074	2075	2076	2077
394	2079	2080	2081	2082
395	2084	2085	2086	2087
396	2089	2090	2091	2092
397	2094	2095	2096	2097
398	2099	2100	2101	2102
399	2104	2105	2106	2107
400	2109	2110	2111	2112
401	2114	2115	2116	2117
402	2119	2120	2121	2122
403	2124	2125	2126	2127
404	2129	2130	2131	2132
405	2134	2135	2136	2137
406	2139	2140	2141	2142
407	2144	2145	2146	2147
408	2149	2150	2151	2152
409	2154	2155	2156	2157
410	2159	2160	2161	2162
411	2166	2167	2168	2169
412	2171	2172	2173	2174
413	2176	2177	2178	2179
414	2181	2182	2183	2184
415	2186	2187	2188	2189
416	2191	2192	2193	2194
417	2197	2198	2199	2200
418	2202	2203	2204	2205
419	2207	2208	2209	2210
420	2212	2213	2214	2215
421	2217	2218	2219	2220
422	2222	2223	2224	2225
423	2227	2228	2229	2230
424	2232	2233	2234	2235
425	2237	2238	2239	2240
426	2242	2243	2244	2245
427	2247	2248	2249	2250
428	2252	2253	2254	2255
429	2257	2258	2259	2260
430	2262	2263	2264	2265
431	2267	2268	2269	2270
432	2272	2273	2274	2275
433	2277	2278	2279	2280
434	2282	2283	2284	2285
435	2288	2289	2290	2291
436	2293	2294	2295	2296
437	2298	2299	2300	2301
438	2303	2304	2305	2306
439	2308	2309	2310	2311
440	2313	2314	2315	2316
441	2318	2319	2320	2321
442	2323	2324	2325	2326
443	2328	2329	2330	2331
444	2333	2334	2335	2336
445	2338	2339	2340	2341
446	2343	2344	2345	2346
447	2348	2349	2350	2351
448	2353	2354	2355	2356
449	2358	2359	2360	2361
450	2363	2364	2365	2366
451	2368	2369	2370	2371
452	2373	2374	2375	2376
453	2380	2381	2382	2383
454	2385	2386	2387	2388
455	2390	2391	2392	2393
456	2395	2396	2397	2398
457	2401	2402	2403	2404
458	2407	2408	2409	2410
459	2412	2413	2414	2415
460	2417	2418	2419	2420
461	2422	2423	2424	2425
462	2427	2428	2429	2430
463	2432	2433	2434	2435
464	2437	2438	2439	2440
465	2442	2443	2444	2445
466	2447	2448	2449	2450
467	2452	2453	2454	2455
468	2457	2458	2459	2460
469	2462	2463	2464	2465
470	2467	2468	2469	2470
471	2472	2473	2474	2475
472	2477	2478	2479	2480
473	2484	2485	2486	2487
474	2489	2490	2491	2492
475	2494	2495	2496	2497
476	2499	2500	2501	2502
477	2504	2505	2506	2507
478	2509	2510	2511	2512
479	2514	2515	2516	2517
480	2519	2520	2521	2522
481	2524	2525	2526	2527
482	2529	2530	2531	2532
483	2534	2535	2536	2537
484	2539	2540	2541	2542
485	2544	2545	2546	2547
486	2549	2550	2551	2552
487	2554	2555	2556	2557
488	2559	2560	2561	2562
489	2564	2565	2566	2567
490	2569	2570	2571	2572
491	2575	2576	2577	2578
492	2580	2581	2582	2583
493	2585	2586	2587	2588
494	2590	2591	2592	2593
495	2595	2596	2597	2598
496	2600	2601	2602	2603
497	2605	2606	2607	2608
498	2610	2611	2612	2613
499	2615	2616	2617	2618
500	2620	2621	2622	2623
501	2625	2626	2627	2628
502	2630	2631	2632	2633
503	2635	2636	2637	2638
504	2640	2641	2642	2643
505	2645	2646	2647	2648
506	2650	2651	2652	2653
507	2655	2656	2657	2658
508	2660	2661	2662	2663
509	2665	2666	2667	2668
510	2670	2671	2672	2673
511	2675	2676	2677	2678
512	2680	2681	2682	2683
513	2685	2686	2687	2688
514	2690	2691	2692	2693
515	2695	2696	2697	2698
516	2700	2701	2702	2703
517	2705	2706	2707	2708
518	2710	2711	2712	2713
519	2715	2716	2717	2718
520	2720	2721	2722	2723
521	2725	2726	2727	2728
522	2730	2731	2732	2733
523	2735	2736	2737	2738
524	2740	2741	2742	2743
525	2745	2746	2747	2748
526	2750	2751	2752	2753
527	2755	2756	2757	2758
528	2760	2761	2762	2763
529	2765	2766	2767	2768
530	2770	2771	2772	2773
531	2775	2776	2777	2778
532	2780	2781	2782	2783
533	2785	2786	2787	2788
534	2790	2791	2792	2793
535	2795	2796	2797	2798
536	2800	2801	2802	2803
537	2805	2806	2807	2808
538	2810	2811	2812	2813
539	2815	2816	2817	2818
540	2820	2821	2822	2823
541	2825	2826	2827	2828
542	2830	2831	2832	2833
543	2835	2836	2837	2838
544	2840	2841	2842	2843
545	2845	2846	2847	2848
546	2850	2851	2852	2853
547	2855	2856	2857	2858
548	2860	2861	2862	2863
549	2865	2866	2867	2868
550	2870	2871	2872	2873
\.


--
-- TOC entry 1920 (class 0 OID 16704)
-- Dependencies: 168
-- Data for Name: telemetry; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY telemetry (telemetry_id, gimbal_roll, gimbal_pitch, gimbal_yaw, origin_x, origin_y, gimbal_zoom, plane_roll, plane_pitch, plane_heading, planelocation_id, blurfactor, width_pixels, height_pixels) FROM stdin;
410	0	0	0	0	0	1	0	0	0	1853	0	5184	3456
411	0	0	0	0	0	1	0	0	0	1861	0	5184	3456
412	0	0	0	4327	2534	1	0	0	0	1867	0	626	619
413	0	0	0	316	568	1	0	0	0	1872	0	706	699
414	0	0	0	4795	1173	1	0	0	0	1877	0	389	475
415	0	0	0	2167	2095	1	0	0	0	1882	0	756	785
416	0	0	0	921	3132	1	0	0	0	1887	0	454	324
417	0	0	0	1224	0	1	0	0	0	1892	0	684	237
418	0	0	0	1411	0	1	0	0	0	1897	0	727	338
419	0	0	0	2822	928	1	0	0	0	1902	0	828	836
420	0	0	0	3067	518	1	0	0	0	1907	0	835	842
421	0	0	0	3549	1483	1	0	0	0	1912	0	857	849
422	0	0	0	4744	1274	1	0	0	0	1917	0	440	821
423	0	0	0	4478	1612	1	0	0	0	1922	0	706	785
424	0	0	0	4586	2822	1	0	0	0	1927	0	562	634
425	0	0	0	900	2635	1	0	0	0	1932	0	698	698
426	0	0	0	3261	2311	1	0	0	0	1937	0	727	720
427	0	0	0	4896	2023	1	0	0	0	1942	0	288	605
428	0	0	0	1080	3168	1	0	0	0	1947	0	403	288
429	0	0	0	3016	705	1	0	0	0	1952	0	504	648
430	0	0	0	4802	7	1	0	0	0	1957	0	382	367
431	0	0	0	4327	2534	1	0	0	0	1962	0	626	619
432	0	0	0	518	0	1	0	0	0	1967	0	670	388
433	0	0	0	316	568	1	0	0	0	1972	0	706	699
434	0	0	0	4795	1173	1	0	0	0	1977	0	389	475
435	0	0	0	2167	2095	1	0	0	0	1982	0	756	785
436	0	0	0	921	3132	1	0	0	0	1987	0	454	324
437	0	0	0	1224	0	1	0	0	0	1992	0	684	237
438	0	0	0	1411	0	1	0	0	0	1997	0	727	338
439	0	0	0	2822	928	1	0	0	0	2002	0	828	836
440	0	0	0	3067	518	1	0	0	0	2007	0	835	842
441	0	0	0	3549	1483	1	0	0	0	2012	0	857	849
442	0	0	0	4744	1274	1	0	0	0	2017	0	440	821
443	0	0	0	4478	1612	1	0	0	0	2022	0	706	785
444	0	0	0	4586	2822	1	0	0	0	2027	0	562	634
445	0	0	0	900	2635	1	0	0	0	2032	0	698	698
446	0	0	0	3261	2311	1	0	0	0	2037	0	727	720
447	0	0	0	4896	2023	1	0	0	0	2042	0	288	605
448	0	0	0	1080	3168	1	0	0	0	2047	0	403	288
449	0	0	0	3016	705	1	0	0	0	2052	0	504	648
450	0	0	0	4802	7	1	0	0	0	2057	0	382	367
451	0	0	0	4327	2534	1	0	0	0	2063	0	626	619
452	0	0	0	518	0	1	0	0	0	2068	0	670	388
453	0	0	0	316	568	1	0	0	0	2073	0	706	699
454	0	0	0	4795	1173	1	0	0	0	2078	0	389	475
455	0	0	0	2167	2095	1	0	0	0	2083	0	756	785
456	0	0	0	921	3132	1	0	0	0	2088	0	454	324
457	0	0	0	1224	0	1	0	0	0	2093	0	684	237
458	0	0	0	1411	0	1	0	0	0	2098	0	727	338
459	0	0	0	2822	928	1	0	0	0	2103	0	828	836
460	0	0	0	3067	518	1	0	0	0	2108	0	835	842
461	0	0	0	3549	1483	1	0	0	0	2113	0	857	849
462	0	0	0	4744	1274	1	0	0	0	2118	0	440	821
463	0	0	0	4478	1612	1	0	0	0	2123	0	706	785
464	0	0	0	4586	2822	1	0	0	0	2128	0	562	634
465	0	0	0	900	2635	1	0	0	0	2133	0	698	698
466	0	0	0	3261	2311	1	0	0	0	2138	0	727	720
467	0	0	0	4896	2023	1	0	0	0	2143	0	288	605
468	0	0	0	1080	3168	1	0	0	0	2148	0	403	288
469	0	0	0	3016	705	1	0	0	0	2153	0	504	648
470	0	0	0	4802	7	1	0	0	0	2158	0	382	367
471	0	0	0	4327	2534	1	0	0	0	2163	0	626	619
472	0	0	0	316	568	1	0	0	0	2164	0	706	699
473	0	0	0	4795	1173	1	0	0	0	2165	0	389	475
474	0	0	0	2167	2095	1	0	0	0	2170	0	756	785
475	0	0	0	921	3132	1	0	0	0	2175	0	454	324
476	0	0	0	1224	0	1	0	0	0	2180	0	684	237
477	0	0	0	1411	0	1	0	0	0	2185	0	727	338
478	0	0	0	2822	928	1	0	0	0	2190	0	828	836
479	0	0	0	4327	2534	1	0	0	0	2195	0	626	619
480	0	0	0	316	568	1	0	0	0	2196	0	706	699
481	0	0	0	4795	1173	1	0	0	0	2201	0	389	475
482	0	0	0	2167	2095	1	0	0	0	2206	0	756	785
483	0	0	0	921	3132	1	0	0	0	2211	0	454	324
484	0	0	0	1224	0	1	0	0	0	2216	0	684	237
485	0	0	0	1411	0	1	0	0	0	2221	0	727	338
486	0	0	0	2822	928	1	0	0	0	2226	0	828	836
487	0	0	0	3067	518	1	0	0	0	2231	0	835	842
488	0	0	0	3549	1483	1	0	0	0	2236	0	857	849
489	0	0	0	4744	1274	1	0	0	0	2241	0	440	821
490	0	0	0	4478	1612	1	0	0	0	2246	0	706	785
491	0	0	0	4586	2822	1	0	0	0	2251	0	562	634
492	0	0	0	900	2635	1	0	0	0	2256	0	698	698
493	0	0	0	3261	2311	1	0	0	0	2261	0	727	720
494	0	0	0	4896	2023	1	0	0	0	2266	0	288	605
495	0	0	0	1080	3168	1	0	0	0	2271	0	403	288
496	0	0	0	3016	705	1	0	0	0	2276	0	504	648
497	0	0	0	4802	7	1	0	0	0	2281	0	382	367
498	0	0	0	4327	2534	1	0	0	0	2286	0	626	619
499	0	0	0	316	568	1	0	0	0	2287	0	706	699
500	0	0	0	4795	1173	1	0	0	0	2292	0	389	475
501	0	0	0	2167	2095	1	0	0	0	2297	0	756	785
502	0	0	0	921	3132	1	0	0	0	2302	0	454	324
503	0	0	0	1224	0	1	0	0	0	2307	0	684	237
504	0	0	0	1411	0	1	0	0	0	2312	0	727	338
505	0	0	0	2822	928	1	0	0	0	2317	0	828	836
506	0	0	0	3067	518	1	0	0	0	2322	0	835	842
507	0	0	0	3549	1483	1	0	0	0	2327	0	857	849
508	0	0	0	4744	1274	1	0	0	0	2332	0	440	821
509	0	0	0	4478	1612	1	0	0	0	2337	0	706	785
510	0	0	0	4586	2822	1	0	0	0	2342	0	562	634
511	0	0	0	900	2635	1	0	0	0	2347	0	698	698
512	0	0	0	3261	2311	1	0	0	0	2352	0	727	720
513	0	0	0	4896	2023	1	0	0	0	2357	0	288	605
514	0	0	0	1080	3168	1	0	0	0	2362	0	403	288
515	0	0	0	3016	705	1	0	0	0	2367	0	504	648
516	0	0	0	4802	7	1	0	0	0	2372	0	382	367
517	0	0	0	4327	2534	1	0	0	0	2377	0	626	619
518	0	0	0	4327	2534	1	0	0	0	2378	0	626	619
519	0	0	0	316	568	1	0	0	0	2379	0	706	699
520	0	0	0	4795	1173	1	0	0	0	2384	0	389	475
521	0	0	0	2167	2095	1	0	0	0	2389	0	756	785
522	0	0	0	921	3132	1	0	0	0	2394	0	454	324
523	0	0	0	4327	2534	1	0	0	0	2399	0	626	619
524	0	0	0	316	568	1	0	0	0	2400	0	706	699
525	0	0	0	4327	2534	1	0	0	0	2405	0	626	619
526	0	0	0	316	568	1	0	0	0	2406	0	706	699
527	0	0	0	4795	1173	1	0	0	0	2411	0	389	475
528	0	0	0	2167	2095	1	0	0	0	2416	0	756	785
529	0	0	0	921	3132	1	0	0	0	2421	0	454	324
530	0	0	0	1224	0	1	0	0	0	2426	0	684	237
531	0	0	0	1411	0	1	0	0	0	2431	0	727	338
532	0	0	0	2822	928	1	0	0	0	2436	0	828	836
533	0	0	0	3067	518	1	0	0	0	2441	0	835	842
534	0	0	0	3549	1483	1	0	0	0	2446	0	857	849
535	0	0	0	4744	1274	1	0	0	0	2451	0	440	821
536	0	0	0	4478	1612	1	0	0	0	2456	0	706	785
537	0	0	0	4586	2822	1	0	0	0	2461	0	562	634
538	0	0	0	900	2635	1	0	0	0	2466	0	698	698
539	0	0	0	3261	2311	1	0	0	0	2471	0	727	720
540	0	0	0	4896	2023	1	0	0	0	2476	0	288	605
541	0	0	0	1080	3168	1	0	0	0	2481	0	403	288
542	0	0	0	4327	2534	1	0	0	0	2482	0	626	619
543	0	0	0	316	568	1	0	0	0	2483	0	706	699
544	0	0	0	4795	1173	1	0	0	0	2488	0	389	475
545	0	0	0	2167	2095	1	0	0	0	2493	0	756	785
546	0	0	0	921	3132	1	0	0	0	2498	0	454	324
547	0	0	0	1224	0	1	0	0	0	2503	0	684	237
548	0	0	0	1411	0	1	0	0	0	2508	0	727	338
549	0	0	0	2822	928	1	0	0	0	2513	0	828	836
550	0	0	0	3067	518	1	0	0	0	2518	0	835	842
551	0	0	0	3549	1483	1	0	0	0	2523	0	857	849
552	0	0	0	4744	1274	1	0	0	0	2528	0	440	821
553	0	0	0	4478	1612	1	0	0	0	2533	0	706	785
554	0	0	0	4586	2822	1	0	0	0	2538	0	562	634
555	0	0	0	900	2635	1	0	0	0	2543	0	698	698
556	0	0	0	3261	2311	1	0	0	0	2548	0	727	720
557	0	0	0	4896	2023	1	0	0	0	2553	0	288	605
558	0	0	0	1080	3168	1	0	0	0	2558	0	403	288
559	0	0	0	3016	705	1	0	0	0	2563	0	504	648
560	0	0	0	4802	7	1	0	0	0	2568	0	382	367
561	0	0	0	4327	2534	1	0	0	0	2573	0	626	619
562	0	0	0	4327	2534	1	0	0	0	2574	0	626	619
563	0	0	0	316	568	1	0	0	0	2579	0	706	699
564	0	0	0	4795	1173	1	0	0	0	2584	0	389	475
565	0	0	0	2167	2095	1	0	0	0	2589	0	756	785
566	0	0	0	921	3132	1	0	0	0	2594	0	454	324
567	0	0	0	1224	0	1	0	0	0	2599	0	684	237
568	0	0	0	1411	0	1	0	0	0	2604	0	727	338
569	0	0	0	2822	928	1	0	0	0	2609	0	828	836
570	0	0	0	3067	518	1	0	0	0	2614	0	835	842
571	0	0	0	3549	1483	1	0	0	0	2619	0	857	849
572	0	0	0	4744	1274	1	0	0	0	2624	0	440	821
573	0	0	0	4478	1612	1	0	0	0	2629	0	706	785
574	0	0	0	4586	2822	1	0	0	0	2634	0	562	634
575	0	0	0	900	2635	1	0	0	0	2639	0	698	698
576	0	0	0	3261	2311	1	0	0	0	2644	0	727	720
577	0	0	0	4896	2023	1	0	0	0	2649	0	288	605
578	0	0	0	1080	3168	1	0	0	0	2654	0	403	288
579	0	0	0	3016	705	1	0	0	0	2659	0	504	648
580	0	0	0	4802	7	1	0	0	0	2664	0	382	367
581	0	0	0	2095	150	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2669	0	84	81
582	0	0	0	2095	150	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2674	0	84	81
583	0	0	0	0	0	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2679	0	2778	1875
584	0	0	0	0	0	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2684	0	2778	1875
585	0	0	0	0	0	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2689	0	2778	1875
586	0	0	0	0	0	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2694	0	2778	1875
587	0	0	0	2095	150	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2699	0	81	81
588	0	0	0	15	0	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2704	0	81	46
589	0	0	0	817	293	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2709	0	81	85
590	0	0	0	1906	54	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2714	0	81	81
591	0	0	0	2450	1026	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2719	0	81	81
592	0	0	0	2484	1030	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2724	0	85	84
593	0	0	0	1014	941	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2729	0	85	85
594	0	0	0	2372	933	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2734	0	81	81
595	0	0	0	640	1489	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2739	0	93	81
596	0	0	0	2450	1747	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2744	0	88	85
597	0	0	0	1331	929	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2749	0	85	85
598	0	0	0	2095	150	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2754	0	81	81
599	0	0	0	15	0	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2759	0	81	46
600	0	0	0	817	293	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2764	0	81	85
601	0	0	0	1906	54	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2769	0	81	81
602	0	0	0	2450	1026	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2774	0	81	81
603	0	0	0	2484	1030	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2779	0	85	84
604	0	0	0	2095	150	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2784	0	84	81
605	0	0	0	2044	92	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2789	0	81	85
606	0	0	0	2176	354	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2794	0	88	81
607	0	0	0	2318	1246	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2799	0	85	85
608	0	0	0	2654	1736	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2804	0	89	84
609	0	0	0	2561	96	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2809	0	85	85
610	0	0	0	2600	783	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2814	0	89	85
611	0	0	0	844	0	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2819	0	89	42
612	0	0	0	2264	536	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2824	0	85	85
613	0	0	0	2558	1003	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2829	0	88	84
614	0	0	0	2122	1327	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2834	0	81	81
615	0	0	0	308	1111	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2839	0	85	84
616	0	0	0	347	1203	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2844	0	88	85
617	0	0	0	2322	655	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2849	0	81	81
618	0	0	0	2434	1242	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2854	0	81	81
619	0	0	0	2534	1743	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2859	0	85	81
620	0	0	0	2554	1284	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2864	0	81	81
621	0	0	0	2704	1577	1	0.68500000000000005	-0.72099999999999997	-3.5680000000000001	2869	0	74	81
\.


--
-- TOC entry 1922 (class 0 OID 16731)
-- Dependencies: 172
-- Data for Name: unverified_targets; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY unverified_targets (targetid, candidateid, revision, location, description_id, processed) FROM stdin;
\.


--
-- TOC entry 1923 (class 0 OID 16754)
-- Dependencies: 174
-- Data for Name: verified_targets; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY verified_targets (targetid, submitid, center_gps_id) FROM stdin;
\.


--
-- TOC entry 1901 (class 2606 OID 16722)
-- Dependencies: 170 170
-- Name: candidateid; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY candidates
    ADD CONSTRAINT candidateid PRIMARY KEY (candidateid);


--
-- TOC entry 1892 (class 2606 OID 16665)
-- Dependencies: 162 162
-- Name: description_id; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY description
    ADD CONSTRAINT description_id PRIMARY KEY (description_id);


--
-- TOC entry 1894 (class 2606 OID 16673)
-- Dependencies: 164 164
-- Name: gps_id; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY gps_position
    ADD CONSTRAINT gps_id PRIMARY KEY (gps_id);


--
-- TOC entry 1903 (class 2606 OID 16736)
-- Dependencies: 172 172
-- Name: id; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY unverified_targets
    ADD CONSTRAINT id PRIMARY KEY (targetid);


--
-- TOC entry 1896 (class 2606 OID 16681)
-- Dependencies: 166 166
-- Name: loc_id; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY location
    ADD CONSTRAINT loc_id PRIMARY KEY (loc_id);


--
-- TOC entry 1899 (class 2606 OID 16709)
-- Dependencies: 168 168
-- Name: telemetry_id; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY telemetry
    ADD CONSTRAINT telemetry_id PRIMARY KEY (telemetry_id);


--
-- TOC entry 1905 (class 2606 OID 16759)
-- Dependencies: 174 174
-- Name: verified_id; Type: CONSTRAINT; Schema: public; Owner: postgres; Tablespace: 
--

ALTER TABLE ONLY verified_targets
    ADD CONSTRAINT verified_id PRIMARY KEY (submitid);


--
-- TOC entry 1897 (class 1259 OID 16728)
-- Dependencies: 168
-- Name: planelocation_id; Type: INDEX; Schema: public; Owner: postgres; Tablespace: 
--

CREATE INDEX planelocation_id ON telemetry USING btree (planelocation_id);


--
-- TOC entry 1911 (class 2606 OID 16723)
-- Dependencies: 1898 168 170
-- Name: cand_telem; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY candidates
    ADD CONSTRAINT cand_telem FOREIGN KEY (telemetryid) REFERENCES telemetry(telemetry_id);


--
-- TOC entry 1906 (class 2606 OID 16682)
-- Dependencies: 164 166 1893
-- Name: loc_gps_ll; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY location
    ADD CONSTRAINT loc_gps_ll FOREIGN KEY (lower_left_gps) REFERENCES gps_position(gps_id);


--
-- TOC entry 1907 (class 2606 OID 16687)
-- Dependencies: 1893 164 166
-- Name: loc_gps_lr; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY location
    ADD CONSTRAINT loc_gps_lr FOREIGN KEY (lower_right_gps) REFERENCES gps_position(gps_id);


--
-- TOC entry 1908 (class 2606 OID 16692)
-- Dependencies: 1893 166 164
-- Name: loc_gps_ul; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY location
    ADD CONSTRAINT loc_gps_ul FOREIGN KEY (upper_left_gps) REFERENCES gps_position(gps_id);


--
-- TOC entry 1909 (class 2606 OID 16697)
-- Dependencies: 166 1893 164
-- Name: loc_gps_ur; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY location
    ADD CONSTRAINT loc_gps_ur FOREIGN KEY (upper_right_gps) REFERENCES gps_position(gps_id);


--
-- TOC entry 1910 (class 2606 OID 16710)
-- Dependencies: 1893 164 168
-- Name: planelocation_id; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY telemetry
    ADD CONSTRAINT planelocation_id FOREIGN KEY (planelocation_id) REFERENCES gps_position(gps_id);


--
-- TOC entry 1912 (class 2606 OID 16737)
-- Dependencies: 172 170 1900
-- Name: unverif_cand; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY unverified_targets
    ADD CONSTRAINT unverif_cand FOREIGN KEY (candidateid) REFERENCES candidates(candidateid);


--
-- TOC entry 1913 (class 2606 OID 16742)
-- Dependencies: 1891 172 162
-- Name: unverif_desc; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY unverified_targets
    ADD CONSTRAINT unverif_desc FOREIGN KEY (description_id) REFERENCES description(description_id);


--
-- TOC entry 1914 (class 2606 OID 16747)
-- Dependencies: 172 1895 166
-- Name: unverif_loc; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY unverified_targets
    ADD CONSTRAINT unverif_loc FOREIGN KEY (location) REFERENCES location(loc_id);


--
-- TOC entry 1915 (class 2606 OID 16765)
-- Dependencies: 174 1893 164
-- Name: verif_gps; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY verified_targets
    ADD CONSTRAINT verif_gps FOREIGN KEY (center_gps_id) REFERENCES gps_position(gps_id);


--
-- TOC entry 1916 (class 2606 OID 16770)
-- Dependencies: 1902 172 174
-- Name: verif_unverif; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY verified_targets
    ADD CONSTRAINT verif_unverif FOREIGN KEY (targetid) REFERENCES unverified_targets(targetid);


--
-- TOC entry 1928 (class 0 OID 0)
-- Dependencies: 5
-- 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;


-- Completed on 2013-03-05 20:36:31

--
-- PostgreSQL database dump complete
--