--
-- PostgreSQL database dump
--

-- Started on 2010-04-27 19:03:21

SET statement_timeout = 0;
SET client_encoding = 'LATIN2';
SET standard_conforming_strings = off;
SET check_function_bodies = false;
SET client_min_messages = warning;
SET escape_string_warning = off;

SET search_path = xdohnal, pg_catalog;

SET default_tablespace = '';

SET default_with_oids = false;

--
-- TOC entry 3634 (class 1259 OID 1141651)
-- Dependencies: 14
-- Name: hotel; Type: TABLE; Schema: xdohnal; Owner: xdohnal; Tablespace: 
--

CREATE TABLE hotel (
    id integer NOT NULL,
    name character varying(50),
    street character varying(100),
    city character varying(30),
    zip_code integer,
    state character varying(30),
    distance_to_center integer
);


ALTER TABLE xdohnal.hotel OWNER TO xdohnal;

--
-- TOC entry 3633 (class 1259 OID 1141649)
-- Dependencies: 3634 14
-- Name: hotel_id_seq; Type: SEQUENCE; Schema: xdohnal; Owner: xdohnal
--

CREATE SEQUENCE hotel_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;


ALTER TABLE xdohnal.hotel_id_seq OWNER TO xdohnal;

--
-- TOC entry 3952 (class 0 OID 0)
-- Dependencies: 3633
-- Name: hotel_id_seq; Type: SEQUENCE OWNED BY; Schema: xdohnal; Owner: xdohnal
--

ALTER SEQUENCE hotel_id_seq OWNED BY hotel.id;


--
-- TOC entry 3953 (class 0 OID 0)
-- Dependencies: 3633
-- Name: hotel_id_seq; Type: SEQUENCE SET; Schema: xdohnal; Owner: xdohnal
--

SELECT pg_catalog.setval('hotel_id_seq', 500, true);


--
-- TOC entry 3946 (class 2604 OID 1141654)
-- Dependencies: 3633 3634 3634
-- Name: id; Type: DEFAULT; Schema: xdohnal; Owner: xdohnal
--

ALTER TABLE hotel ALTER COLUMN id SET DEFAULT nextval('hotel_id_seq'::regclass);


--
-- TOC entry 3949 (class 0 OID 1141651)
-- Dependencies: 3634
-- Data for Name: hotel; Type: TABLE DATA; Schema: xdohnal; Owner: xdohnal
--

COPY hotel (id, name, street, city, zip_code, state, distance_to_center) FROM stdin;
1	hotel18	street138	city206	267	state14	6
2	hotel392	street78	city99	258	state15	10
3	hotel401	street489	city243	214	state8	6
4	hotel453	street425	city43	157	state8	8
5	hotel115	street91	city121	213	state2	10
6	hotel476	street165	city180	124	state26	7
7	hotel248	street286	city30	134	state10	6
8	hotel117	street480	city13	31	state5	9
9	hotel273	street315	city248	183	state22	3
10	hotel178	street328	city30	381	state9	2
11	hotel311	street452	city4	196	state17	4
12	hotel215	street117	city145	382	state35	8
13	hotel251	street254	city174	195	state48	6
14	hotel345	street375	city175	100	state33	4
15	hotel87	street90	city195	127	state44	8
16	hotel352	street496	city171	317	state39	4
17	hotel241	street383	city137	235	state10	8
18	hotel104	street330	city197	179	state10	10
19	hotel344	street229	city137	172	state31	4
20	hotel385	street42	city144	157	state5	5
21	hotel437	street384	city103	311	state46	4
22	hotel266	street29	city101	350	state19	3
23	hotel485	street86	city89	28	state24	7
24	hotel492	street220	city139	375	state50	9
25	hotel233	street62	city28	9	state32	4
26	hotel188	street478	city13	117	state16	7
27	hotel1	street476	city237	252	state49	7
28	hotel326	street79	city184	273	state4	4
29	hotel428	street490	city58	322	state49	3
30	hotel186	street298	city155	103	state49	1
31	hotel165	street334	city130	324	state17	10
32	hotel108	street367	city61	221	state32	8
33	hotel281	street374	city119	109	state23	8
34	hotel30	street46	city75	115	state5	8
35	hotel236	street302	city185	225	state14	3
36	hotel73	street101	city125	99	state41	7
37	hotel462	street458	city154	116	state48	3
38	hotel498	street7	city130	254	state19	5
39	hotel420	street241	city111	296	state25	9
40	hotel415	street477	city241	315	state3	5
41	hotel170	street226	city119	219	state32	2
42	hotel175	street469	city122	36	state13	3
43	hotel11	street346	city86	281	state25	5
44	hotel445	street37	city43	154	state8	3
45	hotel219	street108	city66	26	state14	8
46	hotel468	street36	city3	143	state27	1
47	hotel197	street81	city81	51	state32	1
48	hotel129	street176	city26	185	state34	8
49	hotel336	street427	city165	74	state20	2
50	hotel29	street180	city222	130	state7	8
51	hotel201	street149	city141	347	state47	9
52	hotel329	street377	city77	265	state35	2
53	hotel191	street423	city238	303	state42	6
54	hotel458	street233	city235	65	state24	1
55	hotel407	street166	city45	82	state8	9
56	hotel80	street228	city210	329	state25	2
57	hotel28	street269	city129	309	state46	6
58	hotel151	street448	city225	219	state11	10
59	hotel69	street422	city225	110	state28	10
60	hotel136	street93	city226	212	state22	3
61	hotel305	street150	city140	340	state50	6
62	hotel42	street87	city235	235	state27	6
63	hotel27	street288	city53	394	state34	6
64	hotel409	street84	city141	302	state30	1
65	hotel421	street326	city60	281	state7	1
66	hotel103	street142	city193	348	state31	1
67	hotel310	street175	city76	359	state11	8
68	hotel294	street462	city60	273	state29	2
69	hotel143	street402	city98	247	state3	2
70	hotel304	street360	city37	324	state42	7
71	hotel250	street357	city235	291	state49	4
72	hotel296	street73	city209	299	state27	8
73	hotel286	street336	city91	153	state11	7
74	hotel289	street16	city101	94	state12	1
75	hotel232	street345	city31	249	state16	7
76	hotel146	street56	city134	308	state41	2
77	hotel386	street98	city14	339	state4	10
78	hotel217	street77	city53	88	state5	9
79	hotel53	street453	city250	86	state38	3
80	hotel24	street28	city163	253	state19	9
81	hotel155	street364	city83	112	state33	3
82	hotel52	street121	city41	281	state41	3
83	hotel451	street60	city104	117	state20	4
84	hotel63	street125	city45	387	state7	10
85	hotel249	street134	city248	338	state10	3
86	hotel181	street296	city30	66	state12	9
87	hotel139	street270	city185	320	state1	3
88	hotel396	street325	city146	217	state6	6
89	hotel61	street109	city120	149	state5	10
90	hotel306	street388	city202	261	state22	5
91	hotel442	street487	city119	181	state21	1
92	hotel487	street331	city202	117	state22	6
93	hotel299	street488	city174	155	state20	7
94	hotel340	street289	city63	22	state14	4
95	hotel207	street227	city17	109	state13	3
96	hotel6	street401	city236	140	state13	5
97	hotel371	street89	city243	324	state8	3
98	hotel166	street278	city34	225	state34	3
99	hotel255	street264	city28	146	state6	2
100	hotel381	street259	city69	130	state16	5
101	hotel413	street5	city126	52	state16	8
102	hotel356	street135	city80	396	state46	3
103	hotel387	street312	city22	117	state9	8
104	hotel36	street50	city160	209	state29	5
105	hotel169	street301	city225	99	state23	1
106	hotel333	street139	city82	358	state6	4
107	hotel402	street498	city90	261	state34	1
108	hotel65	street102	city139	357	state17	6
109	hotel96	street410	city171	354	state39	7
110	hotel389	street456	city242	40	state17	9
111	hotel124	street140	city74	144	state3	2
112	hotel145	street148	city8	237	state32	4
113	hotel433	street115	city85	266	state49	9
114	hotel395	street9	city63	282	state26	4
115	hotel189	street4	city224	85	state18	6
116	hotel412	street303	city247	318	state8	6
117	hotel432	street53	city147	38	state42	6
118	hotel126	street294	city161	320	state12	4
119	hotel367	street481	city18	329	state6	4
120	hotel67	street284	city228	343	state20	6
121	hotel342	street224	city188	229	state35	9
122	hotel454	street257	city39	355	state30	8
123	hotel31	street323	city18	313	state26	8
124	hotel473	street447	city89	55	state40	3
125	hotel137	street392	city184	398	state9	3
126	hotel474	street25	city10	269	state43	1
127	hotel277	street444	city135	112	state8	4
128	hotel466	street412	city89	162	state50	10
129	hotel461	street424	city171	275	state28	10
130	hotel316	street179	city204	387	state48	8
131	hotel366	street96	city138	60	state47	7
132	hotel313	street411	city131	7	state20	10
133	hotel172	street365	city37	221	state14	10
134	hotel161	street267	city77	204	state42	2
135	hotel142	street248	city77	77	state49	9
136	hotel325	street276	city80	215	state11	3
137	hotel127	street110	city186	93	state14	1
138	hotel245	street247	city48	97	state42	6
139	hotel493	street237	city238	228	state19	7
140	hotel424	street398	city202	118	state5	10
141	hotel298	street234	city235	155	state38	7
142	hotel167	street161	city48	352	state44	1
143	hotel193	street177	city196	198	state9	9
144	hotel256	street204	city214	98	state33	8
145	hotel324	street466	city119	214	state35	6
146	hotel388	street68	city131	384	state1	8
147	hotel292	street281	city189	296	state23	3
148	hotel235	street470	city18	143	state30	9
149	hotel328	street83	city23	159	state6	4
150	hotel320	street45	city175	320	state36	9
151	hotel59	street205	city75	29	state28	8
152	hotel358	street450	city234	214	state13	7
153	hotel365	street221	city101	233	state8	1
154	hotel122	street10	city195	92	state22	4
155	hotel338	street371	city71	323	state30	9
156	hotel237	street256	city209	274	state40	9
157	hotel25	street300	city113	96	state45	10
158	hotel223	street337	city26	281	state42	8
159	hotel486	street356	city16	9	state47	4
160	hotel384	street344	city194	51	state11	1
161	hotel230	street475	city61	36	state1	9
162	hotel360	street172	city183	242	state1	5
163	hotel34	street465	city111	191	state37	10
164	hotel368	street222	city3	379	state36	7
165	hotel309	street230	city8	332	state7	6
166	hotel26	street70	city80	48	state48	4
167	hotel125	street141	city230	187	state41	1
168	hotel214	street239	city129	341	state8	7
169	hotel68	street240	city119	17	state39	4
170	hotel431	street369	city2	7	state33	6
171	hotel82	street349	city47	297	state46	2
172	hotel204	street311	city101	247	state32	7
173	hotel495	street92	city69	63	state34	5
174	hotel164	street483	city83	47	state44	4
175	hotel177	street262	city48	16	state32	7
176	hotel21	street163	city28	83	state32	6
177	hotel303	street99	city32	259	state41	7
178	hotel330	street17	city74	239	state17	9
179	hotel94	street418	city178	269	state14	5
180	hotel355	street246	city249	125	state11	4
181	hotel210	street198	city135	32	state26	9
182	hotel430	street153	city103	360	state44	3
183	hotel46	street169	city155	329	state7	5
184	hotel148	street486	city69	367	state28	7
185	hotel422	street235	city197	214	state45	3
186	hotel196	street3	city68	257	state40	7
187	hotel135	street242	city188	231	state44	10
188	hotel443	street14	city143	334	state43	2
189	hotel278	street404	city94	165	state37	9
190	hotel491	street160	city167	51	state49	7
191	hotel425	street467	city153	290	state27	3
192	hotel403	street436	city161	386	state17	8
193	hotel300	street287	city70	110	state23	10
194	hotel318	street255	city245	263	state16	6
195	hotel283	street484	city4	275	state27	5
196	hotel416	street310	city137	248	state50	9
197	hotel208	street494	city82	52	state45	4
198	hotel168	street181	city182	46	state27	1
199	hotel347	street61	city87	91	state32	1
200	hotel113	street314	city85	218	state21	3
201	hotel199	street95	city208	45	state16	2
202	hotel393	street20	city20	251	state44	2
203	hotel171	street106	city116	47	state42	5
204	hotel349	street353	city76	146	state4	10
205	hotel452	street35	city32	261	state31	10
206	hotel110	street419	city98	12	state34	2
207	hotel86	street52	city137	261	state43	5
208	hotel185	street80	city193	229	state42	6
209	hotel50	street492	city192	20	state3	5
210	hotel20	street433	city60	390	state8	9
211	hotel269	street379	city86	197	state48	9
212	hotel72	street182	city101	334	state7	2
213	hotel440	street407	city250	169	state35	7
214	hotel228	street124	city141	131	state39	8
215	hotel200	street258	city50	141	state12	7
216	hotel40	street244	city30	369	state42	10
217	hotel159	street243	city213	295	state15	5
218	hotel380	street216	city197	341	state44	8
219	hotel359	street33	city195	253	state26	3
220	hotel263	street236	city246	137	state49	6
221	hotel291	street59	city99	104	state6	8
222	hotel271	street459	city38	74	state15	5
223	hotel49	street319	city109	65	state7	4
224	hotel23	street195	city152	8	state48	7
225	hotel410	street306	city119	348	state40	10
226	hotel128	street192	city153	88	state42	9
227	hotel447	street118	city49	164	state28	3
228	hotel231	street251	city244	270	state47	3
229	hotel226	street57	city115	234	state1	7
230	hotel408	street316	city136	241	state48	2
231	hotel341	street426	city158	387	state6	9
232	hotel417	street443	city240	223	state36	3
233	hotel130	street308	city225	319	state35	6
234	hotel280	street1	city10	353	state36	10
235	hotel246	street285	city183	346	state12	7
236	hotel48	street414	city133	83	state8	2
237	hotel234	street413	city233	266	state10	9
238	hotel419	street366	city91	2	state3	8
239	hotel4	street340	city138	115	state20	8
240	hotel362	street455	city238	29	state30	6
241	hotel483	street82	city48	27	state29	1
242	hotel405	street449	city126	278	state46	9
243	hotel3	street403	city163	375	state15	4
244	hotel314	street279	city100	209	state40	1
245	hotel239	street48	city244	55	state7	8
246	hotel285	street335	city110	140	state30	3
247	hotel12	street191	city35	290	state28	5
248	hotel152	street317	city44	280	state15	2
249	hotel5	street65	city147	58	state43	6
250	hotel243	street127	city42	393	state28	1
251	hotel112	street295	city59	248	state13	10
252	hotel15	street350	city195	8	state32	1
253	hotel41	street451	city208	36	state41	8
254	hotel179	street51	city173	121	state48	10
255	hotel16	street23	city195	383	state25	9
256	hotel427	street219	city227	298	state17	2
257	hotel212	street343	city47	139	state30	10
258	hotel337	street113	city218	229	state8	1
259	hotel218	street263	city150	308	state12	7
260	hotel194	street352	city219	341	state4	3
261	hotel134	street370	city57	55	state44	9
262	hotel43	street231	city204	71	state16	7
263	hotel19	street397	city159	78	state21	2
264	hotel10	street122	city234	283	state20	3
265	hotel74	street126	city85	301	state23	10
266	hotel39	street144	city114	94	state20	5
267	hotel132	street495	city224	241	state30	6
268	hotel270	street396	city59	256	state41	6
269	hotel70	street416	city142	32	state1	7
270	hotel261	street395	city9	172	state35	2
271	hotel489	street43	city137	347	state9	9
272	hotel481	street105	city70	308	state10	1
273	hotel81	street381	city143	273	state45	3
274	hotel429	street327	city63	327	state10	9
275	hotel438	street137	city119	217	state42	4
276	hotel478	street500	city192	43	state36	2
277	hotel457	street12	city236	249	state22	4
278	hotel312	street406	city185	55	state31	8
279	hotel66	street214	city113	26	state20	5
280	hotel60	street30	city129	385	state22	5
281	hotel180	street400	city163	85	state31	10
282	hotel144	street309	city98	162	state16	4
283	hotel346	street155	city97	279	state2	4
284	hotel33	street274	city4	187	state19	6
285	hotel439	street439	city158	355	state17	2
286	hotel190	street64	city166	245	state4	7
287	hotel209	street24	city165	293	state45	3
288	hotel105	street41	city244	159	state32	2
289	hotel426	street417	city180	375	state27	6
290	hotel406	street143	city43	45	state29	3
291	hotel2	street382	city43	208	state19	1
292	hotel335	street69	city173	142	state35	1
293	hotel479	street292	city107	378	state45	6
294	hotel149	street206	city100	74	state2	4
295	hotel398	street454	city177	340	state6	5
296	hotel257	street493	city55	95	state27	8
297	hotel58	street212	city129	41	state15	5
298	hotel351	street362	city220	266	state38	1
299	hotel95	street252	city245	120	state23	1
300	hotel370	street250	city240	37	state1	7
301	hotel375	street168	city58	126	state24	5
302	hotel99	street76	city6	255	state14	2
303	hotel221	street338	city76	25	state14	3
304	hotel114	street75	city85	69	state32	7
305	hotel225	street348	city175	108	state29	3
306	hotel106	street329	city166	171	state42	7
307	hotel446	street438	city209	188	state8	7
308	hotel116	street22	city231	5	state32	3
309	hotel490	street129	city219	72	state26	10
310	hotel88	street266	city151	278	state48	6
311	hotel157	street271	city36	5	state47	8
312	hotel153	street297	city227	333	state8	1
313	hotel411	street268	city69	62	state34	1
314	hotel242	street13	city140	400	state47	10
315	hotel383	street358	city183	100	state43	7
316	hotel56	street341	city235	229	state47	4
317	hotel463	street197	city174	110	state6	9
318	hotel176	street461	city104	282	state29	2
319	hotel173	street154	city55	166	state5	10
320	hotel488	street74	city200	187	state46	1
321	hotel253	street354	city83	209	state37	8
322	hotel160	street376	city181	303	state41	2
323	hotel111	street8	city128	105	state19	10
324	hotel290	street171	city229	371	state33	6
325	hotel37	street162	city204	101	state30	3
326	hotel89	street485	city181	257	state33	5
327	hotel497	street201	city142	262	state1	7
328	hotel441	street464	city247	375	state21	10
329	hotel254	street223	city108	361	state34	5
330	hotel222	street174	city105	197	state28	5
331	hotel141	street39	city35	147	state50	2
332	hotel203	street136	city74	231	state37	8
333	hotel272	street355	city169	390	state25	2
334	hotel158	street253	city194	204	state29	5
335	hotel295	street38	city162	277	state45	10
336	hotel435	street49	city69	119	state21	10
337	hotel378	street468	city187	278	state30	9
338	hotel216	street275	city156	147	state11	6
339	hotel334	street249	city12	87	state8	7
340	hotel264	street152	city131	257	state42	6
341	hotel499	street304	city50	72	state1	3
342	hotel475	street420	city88	375	state28	4
343	hotel102	street446	city228	273	state24	9
344	hotel183	street15	city77	285	state14	4
345	hotel400	street44	city25	356	state34	8
346	hotel9	street408	city130	28	state48	4
347	hotel319	street363	city156	384	state17	7
348	hotel343	street159	city133	248	state19	5
349	hotel301	street203	city240	225	state48	6
350	hotel434	street128	city71	204	state36	5
351	hotel459	street440	city171	373	state30	7
352	hotel252	street151	city132	115	state6	6
353	hotel308	street120	city185	8	state47	5
354	hotel470	street184	city109	188	state44	7
355	hotel469	street170	city6	342	state35	2
356	hotel465	street272	city93	16	state50	4
357	hotel120	street342	city64	158	state9	8
358	hotel265	street133	city91	92	state23	2
359	hotel109	street463	city60	90	state32	5
360	hotel317	street499	city175	71	state37	10
361	hotel418	street405	city155	305	state19	2
362	hotel121	street116	city157	377	state43	5
363	hotel464	street217	city246	82	state36	9
364	hotel471	street32	city112	150	state17	9
365	hotel51	street428	city108	210	state49	9
366	hotel45	street380	city174	285	state39	1
367	hotel302	street372	city217	165	state15	6
368	hotel482	street97	city122	324	state6	9
369	hotel211	street307	city239	154	state22	8
370	hotel374	street156	city19	172	state14	4
371	hotel107	street215	city75	239	state10	5
372	hotel480	street432	city144	255	state36	3
373	hotel198	street313	city88	293	state48	6
374	hotel119	street196	city242	136	state25	10
375	hotel57	street421	city91	311	state35	1
376	hotel322	street209	city216	292	state16	9
377	hotel484	street173	city23	21	state17	3
378	hotel456	street188	city40	120	state23	10
379	hotel448	street260	city71	216	state47	8
380	hotel154	street72	city73	51	state43	7
381	hotel38	street189	city194	9	state20	2
382	hotel100	street178	city13	23	state31	9
383	hotel54	street261	city93	93	state39	8
384	hotel477	street26	city65	240	state12	1
385	hotel293	street324	city207	105	state5	1
386	hotel377	street238	city105	259	state45	3
387	hotel354	street351	city88	345	state15	2
388	hotel391	street280	city237	295	state31	5
389	hotel376	street409	city211	249	state22	2
390	hotel75	street434	city137	209	state25	8
391	hotel22	street430	city180	31	state50	8
392	hotel131	street210	city117	41	state22	6
393	hotel62	street85	city12	156	state33	1
394	hotel84	street164	city178	182	state14	7
395	hotel397	street479	city101	283	state27	5
396	hotel14	street277	city103	172	state15	4
397	hotel184	street473	city80	255	state36	10
398	hotel118	street193	city231	230	state16	3
399	hotel361	street40	city207	207	state31	8
400	hotel162	street199	city143	274	state4	8
401	hotel71	street114	city30	46	state31	3
402	hotel229	street185	city101	387	state20	10
403	hotel423	street359	city73	38	state16	3
404	hotel13	street474	city15	316	state25	6
405	hotel472	street100	city233	51	state46	6
406	hotel287	street183	city36	389	state44	1
407	hotel274	street11	city189	294	state32	3
408	hotel373	street55	city101	390	state13	7
409	hotel76	street202	city187	68	state50	10
410	hotel350	street6	city62	48	state45	4
411	hotel369	street368	city69	286	state6	10
412	hotel92	street394	city58	141	state1	7
413	hotel8	street132	city182	246	state48	1
414	hotel7	street320	city206	310	state22	5
415	hotel98	street47	city134	303	state12	9
416	hotel258	street31	city187	199	state24	6
417	hotel240	street482	city155	211	state24	9
418	hotel147	street442	city46	358	state10	7
419	hotel297	street322	city140	252	state3	1
420	hotel496	street119	city74	382	state6	9
421	hotel455	street71	city34	210	state36	10
422	hotel379	street460	city217	357	state43	2
423	hotel279	street347	city30	72	state47	4
424	hotel93	street339	city22	18	state13	8
425	hotel315	street390	city89	178	state33	5
426	hotel449	street378	city247	256	state40	1
427	hotel332	street299	city116	172	state49	10
428	hotel275	street21	city196	373	state18	2
429	hotel123	street265	city136	202	state21	6
430	hotel363	street435	city124	320	state27	10
431	hotel372	street445	city226	159	state32	10
432	hotel460	street225	city177	196	state45	2
433	hotel276	street187	city141	391	state6	1
434	hotel220	street471	city150	7	state30	9
435	hotel182	street66	city151	102	state4	8
436	hotel357	street437	city151	176	state5	5
437	hotel138	street186	city99	1	state14	9
438	hotel90	street232	city25	127	state18	10
439	hotel436	street387	city109	167	state45	4
440	hotel17	street167	city224	14	state47	7
441	hotel494	street34	city94	172	state37	1
442	hotel394	street318	city222	182	state37	10
443	hotel288	street385	city184	195	state9	2
444	hotel206	street94	city97	393	state36	3
445	hotel390	street441	city90	304	state32	10
446	hotel348	street107	city144	269	state1	6
447	hotel205	street333	city207	259	state14	4
448	hotel327	street27	city196	363	state19	3
449	hotel382	street63	city122	161	state32	4
450	hotel187	street391	city184	322	state13	10
451	hotel85	street282	city119	143	state46	8
452	hotel156	street112	city32	124	state16	9
453	hotel224	street211	city141	348	state31	7
454	hotel192	street18	city210	389	state32	7
455	hotel78	street218	city215	268	state38	6
456	hotel444	street54	city39	400	state25	4
457	hotel244	street58	city207	2	state24	5
458	hotel44	street457	city177	311	state48	5
459	hotel259	street491	city208	247	state31	1
460	hotel77	street293	city104	27	state49	10
461	hotel414	street389	city119	222	state25	3
462	hotel133	street213	city215	86	state21	9
463	hotel101	street291	city246	163	state5	7
464	hotel467	street194	city44	263	state12	6
465	hotel268	street321	city95	91	state26	6
466	hotel47	street146	city102	225	state46	9
467	hotel364	street131	city42	294	state11	2
468	hotel399	street207	city186	91	state7	7
469	hotel91	street104	city66	335	state50	1
470	hotel35	street157	city100	14	state36	1
471	hotel55	street2	city132	202	state5	10
472	hotel64	street208	city84	6	state31	8
473	hotel307	street111	city96	341	state41	8
474	hotel97	street67	city231	233	state22	2
475	hotel140	street190	city240	141	state37	7
476	hotel321	street158	city170	127	state47	6
477	hotel247	street123	city88	89	state29	7
478	hotel227	street273	city209	320	state36	9
479	hotel323	street497	city40	31	state50	3
480	hotel284	street305	city250	110	state11	5
481	hotel32	street88	city97	269	state19	3
482	hotel163	street19	city2	3	state47	7
483	hotel450	street332	city22	31	state43	2
484	hotel260	street415	city133	385	state16	6
485	hotel282	street399	city44	262	state30	4
486	hotel353	street145	city168	169	state46	8
487	hotel262	street130	city174	110	state13	10
488	hotel150	street103	city227	198	state42	10
489	hotel404	street472	city104	357	state46	3
490	hotel195	street147	city141	51	state43	2
491	hotel331	street245	city70	126	state13	6
492	hotel267	street386	city161	196	state20	5
493	hotel213	street283	city238	305	state35	2
494	hotel238	street290	city232	343	state15	6
495	hotel339	street393	city166	336	state10	1
496	hotel500	street200	city171	174	state36	4
497	hotel174	street431	city246	278	state29	6
498	hotel83	street429	city183	392	state37	2
499	hotel79	street373	city155	335	state2	9
500	hotel202	street361	city58	158	state41	2
\.


--
-- TOC entry 3948 (class 2606 OID 1141656)
-- Dependencies: 3634 3634
-- Name: hotel_pkey; Type: CONSTRAINT; Schema: xdohnal; Owner: xdohnal; Tablespace: 
--

ALTER TABLE ONLY hotel
    ADD CONSTRAINT hotel_pkey PRIMARY KEY (id);


-- Completed on 2010-04-27 19:03:22

--
-- PostgreSQL database dump complete
--