-
-
Notifications
You must be signed in to change notification settings - Fork 0
/
poi-pt-ml.sql
4198 lines (4122 loc) · 371 KB
/
poi-pt-ml.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
INSERT INTO poi (id, type, world_coord, web_url) VALUES
('3b78b3fd-daa6-48eb-b579-8211bbfffe31', 'airport', '(38.769480, -9.128782)', 'https://www.aeroportolisboa.pt/'),
('097f332c-7022-49b4-a041-a80b4bf4767e', 'airport', '(38.763869, -9.136824)', 'https://www.aeroportolisboa.pt/');
INSERT INTO poi_name (id, main, lang, name) VALUES
('3b78b3fd-daa6-48eb-b579-8211bbfffe31', true, 'pt', 'Aeroporto Internacional de Lisboa (Terminal 1)'),
('3b78b3fd-daa6-48eb-b579-8211bbfffe31', false, 'en', 'Lisbon International Airport (Terminal 1)'),
('3b78b3fd-daa6-48eb-b579-8211bbfffe31', false, 'fr', 'Aéroport International de Lisbonne (Terminal 1)'),
('3b78b3fd-daa6-48eb-b579-8211bbfffe31', false, 'es', 'Aeropuerto internacional de Lisboa (Terminal 1)'),
('097f332c-7022-49b4-a041-a80b4bf4767e', true, 'pt', 'Aeroporto Internacional de Lisboa (Terminal 2)'),
('097f332c-7022-49b4-a041-a80b4bf4767e', false, 'en', 'Lisbon International Airport (Terminal 2)'),
('097f332c-7022-49b4-a041-a80b4bf4767e', false, 'fr', 'Aéroport International de Lisbonne (Terminal 2)'),
('097f332c-7022-49b4-a041-a80b4bf4767e', false, 'es', 'Aeropuerto internacional de Lisboa (Terminal 2)');
INSERT INTO poi (id, type, world_coord, web_url) VALUES
('833778c0-a2b6-4a1b-8262-90b7c72e73ab', 'bank', '(38.708696, -9.138308)', 'https://www.bportugal.pt/'),
('f971f658-6f56-47ff-858b-e9aa9694b6f0', 'bank', '(38.727291, -9.135581)', 'https://www.bportugal.pt/'),
('3f3e5648-26f0-42ac-87f9-00ca353307d4', 'bank', '(38.741425, -9.140983)', 'https://www.cga.pt/'),
('00f66dc2-8a13-43ec-bb01-7eae0c0f329c', 'bank', '(38.741252, -9.141519)', 'https://www.cgd.pt/');
INSERT INTO poi_name (id, main, lang, name) VALUES
('833778c0-a2b6-4a1b-8262-90b7c72e73ab', true, 'pt', 'Banco de Portugal'),
('833778c0-a2b6-4a1b-8262-90b7c72e73ab', false, 'en', 'Bank of Portugal'),
('833778c0-a2b6-4a1b-8262-90b7c72e73ab', false, 'fr', 'Banque du Portugal'),
('f971f658-6f56-47ff-858b-e9aa9694b6f0', true, 'pt', 'Banco de Portugal - Biblioteca e Arquivo'),
('f971f658-6f56-47ff-858b-e9aa9694b6f0', false, 'en', 'Bank of Portugal - Library and Archiving'),
('f971f658-6f56-47ff-858b-e9aa9694b6f0', false, 'fr', 'Banque du Portugal - Bibliothèque et Archive'),
('f971f658-6f56-47ff-858b-e9aa9694b6f0', false, 'es', 'Banco de Portugal - Biblioteca y Archivo'),
('3f3e5648-26f0-42ac-87f9-00ca353307d4', true, 'pt', 'CGA - Caixa Geral de Aposentações'),
('3f3e5648-26f0-42ac-87f9-00ca353307d4', false, 'en', 'Treasurer General of Retirements'),
('3f3e5648-26f0-42ac-87f9-00ca353307d4', false, 'fr', 'Caissier Général des Retraites'),
('3f3e5648-26f0-42ac-87f9-00ca353307d4', false, 'es', 'Cajera General de Jubilaciones'),
('00f66dc2-8a13-43ec-bb01-7eae0c0f329c', true, 'pt', 'CGD - Caixa Geral de Depósitos - Sede'),
('00f66dc2-8a13-43ec-bb01-7eae0c0f329c', false, 'en', 'Caixa Geral de Depósitos - Headquarters'),
('00f66dc2-8a13-43ec-bb01-7eae0c0f329c', false, 'fr', 'Caixa Geral de Depósitos - Siège');
INSERT INTO poi (id, type, world_coord, web_url) VALUES
('81185020-18b0-4f61-bc4e-b73d801f4546', 'bingo', '(38.751236, -9.227829)', 'http://www.bingos.pt/'),
('68858f2e-3530-4323-98a3-32c3f8a7224c', 'bingo', '(38.736154, -9.144541)', 'https://www.facebook.com/bingobelenenses/'),
('3f11e0ef-3f31-497a-abe8-5b248d717ee2', 'bingo', '(38.753346, -9.188704)', 'https://www.slbenfica.pt/pt-pt/servicos_atividades/bingo/'),
('f4682c9e-6257-4337-8a08-2f86a8318d6d', 'bingo', '(38.740971, -9.134518)', 'https://www.facebook.com/pandabingo/');
INSERT INTO poi_name (id, main, lang, name) VALUES
('81185020-18b0-4f61-bc4e-b73d801f4546', true, 'pt', 'Bingo da Amadora'),
('81185020-18b0-4f61-bc4e-b73d801f4546', false, 'en', 'Amadora Bingo'),
('81185020-18b0-4f61-bc4e-b73d801f4546', false, 'fr', 'Bingo d''Amadora'),
('81185020-18b0-4f61-bc4e-b73d801f4546', false, 'es', 'Bingo de la Amadora'),
('68858f2e-3530-4323-98a3-32c3f8a7224c', true, 'pt', 'Bingo Belenenses'),
('68858f2e-3530-4323-98a3-32c3f8a7224c', false, 'en', 'Belenenses Bingo'),
('3f11e0ef-3f31-497a-abe8-5b248d717ee2', true, 'pt', 'Bingo Benfica'),
('3f11e0ef-3f31-497a-abe8-5b248d717ee2', false, 'en', 'Benfica Bingo'),
('f4682c9e-6257-4337-8a08-2f86a8318d6d', true, 'pt', 'Panda Bingo');
INSERT INTO poi (id, type, world_coord, web_url) VALUES
('241938da-92b5-40ec-966d-9177cd102ff0', 'business', '(38.721763, -9.150981)', 'https://www.cimpor.com/'),
('dab5d053-2a79-4d26-8644-7d3097badf18', 'business', '(38.744862, -9.150797)', 'https://jobs.teleperformance.pt/pt-pt/'),
('ab02e391-475e-495e-8a51-ad0005e99d07', 'business', '(38.752132, -9.223693)', 'https://www.emef.pt/'),
('ef1f0ecc-c8ba-4c62-afa5-cce287b04ff9', 'business', '(38.716735, -9.143083)', 'http://www.epal.pt/epal'),
('c4d17f49-553b-4b7d-b24b-3d3f96e83dd9', 'business', '(38.766346, -9.105742)', 'http://www.epal.pt/epal'),
('30b49034-5a35-4ff1-97bc-8279c47f192d', 'business', '(38.766635, -9.103008)', 'http://www.epal.pt/epal'),
('dc7bc504-6ff4-4355-8aea-1bfbcc48e257', 'business', '(38.731099, -9.145881)', 'https://www.telecom.pt/pt-pt'),
('45a69d5d-89a1-405b-b292-c4ff9c58ee89', 'business', '(38.760037, -9.156646)', 'https://www.jeronimomartins.com/pt/'),
('d729ce6d-4e82-4910-a5a8-cb4bc458df26', 'business', '(38.7209599, -9.1347924)', 'http://www.cm-lisboa.pt/equipamentos/equipamento/info/fabrica-de-ceramica-da-viuva-lamego'),
('e0ed6165-0e08-4e85-bc1c-bdd948a8faff', 'business', '(38.723076, -9.149385)', 'http://www.leya.com/pt/gca/areas-de-actividade/livrarias/'),
('c4348edc-c3da-47a7-9336-9c0330e3db5e', 'business', '(38.725930, -9.148449)', 'http://www.edp.pt/'),
('1b755aa1-cb06-4b06-b778-efc6e79675be', 'business', '(38.730270, -9.147831)', 'https://pousadasjuventude.pt/pt/pousadas/lisboa/'),
('e2de78f2-71ba-46d7-a1f9-c7e734a285ec', 'business', '(38.759649, -9.117873)', 'http://www.rtp.pt/'),
('6e2d2392-38eb-44b4-b0b8-b347abd3a75f', 'business', '(38.748918, -9.137496)', 'https://www.ren.pt/'),
('9dd8b621-8873-4eb1-8d58-f39e24d98840', 'business', '(38.764037, -9.098458)', 'https://www.ctt.pt/'),
('fe03901f-c49d-4f89-ac65-fc151bf6cd92', 'business', '(38.730052, -9.146892)', 'http://www.metrolisboa.pt/metro/sede-social/'),
('a8b4c63a-7218-4bc0-ab2f-6cfcb050a513', 'business', '(38.727966, -9.148090)', 'http://www.semapa.pt/pt-pt/home'),
('a3c76f26-e2a1-48a0-aef3-e682d0d52189', 'business', '(38.773468, -9.091402)', 'https://www.telecabinelisboa.pt/'),
('af81c7ee-b857-4433-9052-e831f3515842', 'business', '(38.762424, -9.092292)', 'https://www.telecabinelisboa.pt/'),
('ea91385f-4ec3-4892-8aa8-ac3dcdc8a15b', 'business', '(38.756676, -9.175389)', 'http://www.torresdelisboa.com/');
INSERT INTO poi_name (id, main, lang, name) VALUES
('241938da-92b5-40ec-966d-9177cd102ff0', true, 'pt', 'CIMPOR - Cimentos de Portugal'),
('dab5d053-2a79-4d26-8644-7d3097badf18', true, 'pt', 'Edifício Marconi - Teleperformance Portugal'),
('dab5d053-2a79-4d26-8644-7d3097badf18', false, 'en', 'Marconi Building - Teleperformance Portugal'),
('dab5d053-2a79-4d26-8644-7d3097badf18', false, 'fr', 'Bâtiment Marconi - Teleperformance Portugal'),
('dab5d053-2a79-4d26-8644-7d3097badf18', false, 'es', 'Edificio Marconi - Teleperformance Portugal'),
('ab02e391-475e-495e-8a51-ad0005e99d07', true, 'pt', 'EMEF - Empresa de Manutenção de Equipamento Ferroviário'),
('ab02e391-475e-495e-8a51-ad0005e99d07', false, 'en', 'Railway Equipment Maintenance Company'),
('ab02e391-475e-495e-8a51-ad0005e99d07', false, 'fr', 'Entreprise de Maintenance de l''Équipement Ferroviaire'),
('ab02e391-475e-495e-8a51-ad0005e99d07', false, 'es', 'Empresa de Mantenimiento de Equipos Ferroviarios'),
('ef1f0ecc-c8ba-4c62-afa5-cce287b04ff9', true, 'pt', 'EPAL - Empresa Portuguesa das Águas Livres - Sede'),
('ef1f0ecc-c8ba-4c62-afa5-cce287b04ff9', false, 'en', 'Portuguese Water Company - Headquarters'),
('ef1f0ecc-c8ba-4c62-afa5-cce287b04ff9', false, 'fr', 'Compagnie Portugaise des Eaux Libres - Siège'),
('ef1f0ecc-c8ba-4c62-afa5-cce287b04ff9', false, 'es', 'Empresa Portuguesa de las Aguas Libres - Sede'),
('c4d17f49-553b-4b7d-b24b-3d3f96e83dd9', true, 'pt', 'EPAL - Estação Elevatória da Avenida de Berlim'),
('c4d17f49-553b-4b7d-b24b-3d3f96e83dd9', false, 'en', 'EPAL - Berlin Avenue Pumping Station'),
('c4d17f49-553b-4b7d-b24b-3d3f96e83dd9', false, 'fr', 'EPAL - Station de Pompage de l''Avenue de Berlin'),
('c4d17f49-553b-4b7d-b24b-3d3f96e83dd9', false, 'es', 'EPAL - Estación Elevadora de la Avenida de Berlín'),
('30b49034-5a35-4ff1-97bc-8279c47f192d', true, 'pt', 'EPAL - Laboratório Central'),
('30b49034-5a35-4ff1-97bc-8279c47f192d', false, 'en', 'EPAL - Central Laboratory'),
('30b49034-5a35-4ff1-97bc-8279c47f192d', false, 'fr', 'EPAL - Laboratoire Central'),
('30b49034-5a35-4ff1-97bc-8279c47f192d', false, 'es', 'EPAL - Laboratorio Central'),
('dc7bc504-6ff4-4355-8aea-1bfbcc48e257', true, 'pt', 'Fórum Picoas - PT Comunicações'),
('dc7bc504-6ff4-4355-8aea-1bfbcc48e257', false, 'en', 'Picoas Forum - PT Comunicações'),
('dc7bc504-6ff4-4355-8aea-1bfbcc48e257', false, 'fr', 'Forum Picoas - PT Comunicações'),
('dc7bc504-6ff4-4355-8aea-1bfbcc48e257', false, 'es', 'Foro Picoas - PT Comunicações'),
('45a69d5d-89a1-405b-b292-c4ff9c58ee89', true, 'pt', 'Jerónimo Martins - Provedoria do Cliente'),
('45a69d5d-89a1-405b-b292-c4ff9c58ee89', false, 'en', 'Jerónimo Martins - Customer Ombudsman'),
('45a69d5d-89a1-405b-b292-c4ff9c58ee89', false, 'fr', 'Jerónimo Martins - Ombudsman des Clients'),
('45a69d5d-89a1-405b-b292-c4ff9c58ee89', false, 'es', 'Jerónimo Martins - Proveeduría del Cliente'),
('d729ce6d-4e82-4910-a5a8-cb4bc458df26', true, 'pt', 'Loja da Fábrica de Cerâmica da Viúva Lamego'),
('d729ce6d-4e82-4910-a5a8-cb4bc458df26', false, 'en', 'Viúva Lamego Ceramics Factory Shop'),
('d729ce6d-4e82-4910-a5a8-cb4bc458df26', false, 'fr', 'Boutique de la Manufacture de Céramique Viúva Lamego'),
('d729ce6d-4e82-4910-a5a8-cb4bc458df26', false, 'es', 'Tienda de la Planta de Cerámica de la Viúva Lamego'),
('e0ed6165-0e08-4e85-bc1c-bdd948a8faff', true, 'pt', 'Livraria Buchholz'),
('e0ed6165-0e08-4e85-bc1c-bdd948a8faff', false, 'en', 'Buchholz Bookshop'),
('e0ed6165-0e08-4e85-bc1c-bdd948a8faff', false, 'fr', 'Librairie Buchholz'),
('e0ed6165-0e08-4e85-bc1c-bdd948a8faff', false, 'es', 'Librería Buchholz'),
('c4348edc-c3da-47a7-9336-9c0330e3db5e', true, 'pt', 'Loja EDP'),
('c4348edc-c3da-47a7-9336-9c0330e3db5e', false, 'en', 'EDP Store'),
('c4348edc-c3da-47a7-9336-9c0330e3db5e', false, 'fr', 'Boutique EDP'),
('c4348edc-c3da-47a7-9336-9c0330e3db5e', false, 'es', 'Tienda EDP'),
('1b755aa1-cb06-4b06-b778-efc6e79675be', true, 'pt', 'Pousada de Juventude de Lisboa'),
('1b755aa1-cb06-4b06-b778-efc6e79675be', false, 'en', 'Lisbon Youth Hostel'),
('1b755aa1-cb06-4b06-b778-efc6e79675be', false, 'fr', 'Auberge de jeunesse de Lisbonne'),
('1b755aa1-cb06-4b06-b778-efc6e79675be', false, 'es', 'Albergue Juvenil de Lisboa'),
('e2de78f2-71ba-46d7-a1f9-c7e734a285ec', true, 'pt', 'RTP - Rádio e Televisão de Portugal'),
('e2de78f2-71ba-46d7-a1f9-c7e734a285ec', false, 'en', 'Radio and Television of Portugal'),
('e2de78f2-71ba-46d7-a1f9-c7e734a285ec', false, 'fr', 'Radio et Télévision du Portugal'),
('e2de78f2-71ba-46d7-a1f9-c7e734a285ec', false, 'es', 'Radio y Televisión de Portugal'),
('6e2d2392-38eb-44b4-b0b8-b347abd3a75f', true, 'pt', 'REN - Redes Energéticas Nacionais'),
('6e2d2392-38eb-44b4-b0b8-b347abd3a75f', false, 'en', 'National Power Grids'),
('6e2d2392-38eb-44b4-b0b8-b347abd3a75f', false, 'fr', 'Réseaux Énergétiques Nationaux'),
('6e2d2392-38eb-44b4-b0b8-b347abd3a75f', false, 'es', 'Redes Energéticas Nacionales'),
('9dd8b621-8873-4eb1-8d58-f39e24d98840', true, 'pt', 'Sede CTT - Correios de Portugal'),
('9dd8b621-8873-4eb1-8d58-f39e24d98840', false, 'en', 'Mail of Portugal - Headquarters'),
('9dd8b621-8873-4eb1-8d58-f39e24d98840', false, 'fr', 'Courriers du Portugal - Siège'),
('9dd8b621-8873-4eb1-8d58-f39e24d98840', false, 'es', 'Correos de Portugal - Sede'),
('fe03901f-c49d-4f89-ac65-fc151bf6cd92', true, 'pt', 'Sede Social do Metropolitano de Lisboa'),
('fe03901f-c49d-4f89-ac65-fc151bf6cd92', false, 'en', 'Lisbon Metro''s Registered Office'),
('fe03901f-c49d-4f89-ac65-fc151bf6cd92', false, 'fr', 'Siège Social du Métro de Lisbonne'),
('fe03901f-c49d-4f89-ac65-fc151bf6cd92', false, 'es', 'Sede Social del Metro de Lisboa'),
('a8b4c63a-7218-4bc0-ab2f-6cfcb050a513', true, 'pt', 'Semapa - Sede'),
('a8b4c63a-7218-4bc0-ab2f-6cfcb050a513', false, 'en', 'Semapa - Headquarters'),
('a8b4c63a-7218-4bc0-ab2f-6cfcb050a513', false, 'fr', 'Semapa - Siège'),
('a3c76f26-e2a1-48a0-aef3-e682d0d52189', true, 'pt', 'Telecabine Lisboa - Teleférico da Expo (Estação Norte)'),
('a3c76f26-e2a1-48a0-aef3-e682d0d52189', false, 'en', 'Expo Cable Car (North Station)'),
('a3c76f26-e2a1-48a0-aef3-e682d0d52189', false, 'fr', 'Téléphérique d''Expo (Station Nord)'),
('a3c76f26-e2a1-48a0-aef3-e682d0d52189', false, 'es', 'Teleférico de la Expo (Estación Norte)'),
('af81c7ee-b857-4433-9052-e831f3515842', true, 'pt', 'Telecabine Lisboa - Teleférico da Expo (Estação Sul)'),
('af81c7ee-b857-4433-9052-e831f3515842', false, 'en', 'Expo Cable Car (South Station)'),
('af81c7ee-b857-4433-9052-e831f3515842', false, 'fr', 'Téléphérique d''Expo (Station Sud'),
('af81c7ee-b857-4433-9052-e831f3515842', false, 'es', 'Teleférico de la Expo (Estación Sur)'),
('ea91385f-4ec3-4892-8aa8-ac3dcdc8a15b', true, 'pt', 'Torres de Lisboa'),
('ea91385f-4ec3-4892-8aa8-ac3dcdc8a15b', false, 'en', 'Lisbon Towers'),
('ea91385f-4ec3-4892-8aa8-ac3dcdc8a15b', false, 'fr', 'Tours de Lisbonne');
INSERT INTO poi (id, type, world_coord, web_url) VALUES
('28eacd2e-ea8c-4e6d-a00d-d34bd6da2809', 'casino', '(38.764473, -9.096314)', 'http://www.casino-lisboa.pt/');
INSERT INTO poi_name (id, main, lang, name) VALUES
('28eacd2e-ea8c-4e6d-a00d-d34bd6da2809', true, 'pt', 'Casino Lisboa'),
('28eacd2e-ea8c-4e6d-a00d-d34bd6da2809', false, 'en', 'Lisbon Casino'),
('28eacd2e-ea8c-4e6d-a00d-d34bd6da2809', false, 'fr', 'Casino Lisbonne'),
('28eacd2e-ea8c-4e6d-a00d-d34bd6da2809', false, 'es', 'Cassino Lisboa');
INSERT INTO poi (id, type, world_coord, web_url) VALUES
('1bdcb32a-053d-4a67-b6f7-0028aeda4674', 'cemetery', '(38.764323, -9.108384)', 'http://www.cm-lisboa.pt/equipamentos/equipamento/info/cemiterio-dos-olivais'),
('f9304407-c736-4fce-8dd7-345651e82eae', 'cemetery', '(38.773206, -9.165051)', 'http://www.cm-lisboa.pt/equipamentos/equipamento/info/cemiterio-do-lumiar');
INSERT INTO poi_name (id, main, lang, name) VALUES
('1bdcb32a-053d-4a67-b6f7-0028aeda4674', true, 'pt', 'Cemitério dos Olivais'),
('1bdcb32a-053d-4a67-b6f7-0028aeda4674', false, 'en', 'Olivais Cemetery'),
('1bdcb32a-053d-4a67-b6f7-0028aeda4674', false, 'fr', 'Cimetière d''Olivais'),
('1bdcb32a-053d-4a67-b6f7-0028aeda4674', false, 'es', 'Cementerio de los Olivais'),
('f9304407-c736-4fce-8dd7-345651e82eae', true, 'pt', 'Cemitério do Lumiar'),
('f9304407-c736-4fce-8dd7-345651e82eae', false, 'en', 'Lumiar Cemetery'),
('f9304407-c736-4fce-8dd7-345651e82eae', false, 'fr', 'Cimetière du Lumiar'),
('f9304407-c736-4fce-8dd7-345651e82eae', false, 'es', 'Cementerio del Lumiar');
INSERT INTO poi (id, type, world_coord, web_url) VALUES
('291e24f0-f8f6-48bf-a30b-7c39d7e72d3e', 'church', '(38.710579, -9.141442)', 'http://paroquiadosmartires.pt/'),
('7d5c25f1-12d3-4bf3-9758-1ac11c19d5b4', 'church', '(38.741278, -9.180179)', 'http://www.paroquiasaodomingosdebenfica.pt/'),
('aebc903e-1f98-49ba-8431-fea14907ddb5', 'church', '(38.721874, -9.156578)', 'https://www.paroquiadesaomamede.pt/'),
('590c9be1-800c-486a-89c4-849028781c07', 'church', '(38.720856, -9.155054)', 'http://www.capeladorato.org/'),
('da8f9267-7525-42c5-b7c6-1ea82a4a9042', 'church', '(38.718581, -9.123154)', 'http://www.cm-lisboa.pt/en/equipments/equipment/info/capela-do-vale-de-santo-antonio'),
('d79798ed-bfd5-4198-8c39-32769fe881e6', 'church', '(38.716538, -9.139132)', 'http://www.patrimoniocultural.gov.pt/pt/patrimonio/patrimonio-imovel/pesquisa-do-patrimonio/classificado-ou-em-vias-de-classificacao/geral/view/70062'),
('94c5cece-5744-44eb-aaf8-323e626905f2', 'church', '(38.715955, -9.135632)', 'http://www.patrimoniocultural.gov.pt/pt/patrimonio/patrimonio-imovel/pesquisa-do-patrimonio/classificado-ou-em-vias-de-classificacao/geral/view/71835'),
('f4c4cb07-b81d-4ef7-93fb-32814a1eb100', 'church', '(38.750251, -9.169950)', 'https://the.ismaili/ismailicentres/lisbon'),
('0f795df5-f63a-40c8-87e1-e29ec620bcd1', 'church', '(38.761666, -9.189348)', 'http://www.cm-lisboa.pt/equipamentos/equipamento/info/convento-de-santa-teresa-de-jesus'),
('3d23a0b2-9be1-4c44-90c3-082fde0b49ff', 'church', '(38.7501963, -9.1792298)', 'http://www.isdomingos.com/'),
('d53b59e0-c82b-4b83-a8db-39ab80e8ecf9', 'church', '(38.732681, -9.136212)', 'https://www.facebook.com/paroquiadearroios/'),
('d9313d9b-465a-447f-9a94-2b458a6d5a96', 'church', '(38.716655, -9.131237)', 'https://www.lisbonlux.com/lisbon/igreja-da-graca.html'),
('5f5ec80e-b514-4cd8-a867-2eb176b8ad66', 'church', '(38.707287, -9.142237)', 'http://www.cm-lisboa.pt/en/equipments/equipment/info/igreja-do-corpo-santo'),
('e2f3d193-abcb-4073-86e5-a743be8a7d1e', 'church', '(38.710744, -9.142762)', 'http://www.cm-lisboa.pt/equipamentos/equipamento/info/igreja-de-nossa-senhora-do-loreto'),
('cdf64da1-9d6a-4a6a-8995-d2b94bd9689b', 'church', '(38.7916667, -9.1811256)', 'http://www.patrimoniocultural.gov.pt/pt/patrimonio/patrimonio-imovel/pesquisa-do-patrimonio/classificado-ou-em-vias-de-classificacao/geral/view/70888'),
('da772310-515c-4958-80f4-39c364c7669e', 'church', '(38.708926, -9.134270)', 'https://www.guiadacidade.pt/pt/poi-igreja-de-nossa-senhora-da-conceicao-velha-17838'),
('e6c35314-14c3-4e13-ab9b-261def3cadb0', 'church', '(38.710381, -9.142808)', 'https://www.patriarcado-lisboa.pt/site/index.php?cont_=90&tem=65&id=3660'),
('b6d636c9-b0ae-4ad7-9169-0b14001729af', 'church', '(38.759643, -9.165323)', 'http://portadoceu.org/'),
('2e78daef-2a10-4eb6-9c27-8f173bbb7958', 'church', '(38.741549, -9.180949)', 'http://www.paroquiasaodomingosdebenfica.pt/'),
('2edf3983-82ee-4520-b21c-578eb6b9053b', 'church', '(38.739675, -9.150864)', 'http://www.paroquiansrfatima.com/'),
('002c1bbc-18af-414a-8142-9cd3debb5f71', 'church', '(38.715770, -9.133483)', 'http://www.paixaoporlisboa.pt/igreja-do-socorro-54927'),
('dd88b3cd-8522-47e0-837f-975e20c18c93', 'church', '(38.712576, -9.125419)', 'http://www.orthodoxportugal.org/pt/'),
('90696519-fba3-4f6a-8574-5370ae3bc8f6', 'church', '(38.736799, -9.124197)', 'http://paroquiaespiritosanto.org/'),
('27f9cd67-6460-4c37-9a33-cc41deb8e857', 'church', '(38.7243407, -9.1348158)', 'https://www.guiadacidade.pt/pt/poi-igreja-paroquial-de-nossa-senhora-dos-anjos-279849'),
('052ff00b-539c-476c-94ec-2ef4e090a5e5', 'church', '(38.766223, -9.156121)', 'http://igrejaaltodolumiar.pt/'),
('a8ea5c39-24a6-4cf1-be2f-a53fc548143d', 'church', '(38.781827, -9.161077)', 'https://www.facebook.com/paroquia.ameixoeira/'),
('79de808e-f2a8-4a1e-9c25-e47079109c0a', 'church', '(38.717794, -9.139340)', 'https://www.facebook.com/paroquiadapena/'),
('8efa89b3-2973-4261-96b0-e5dbc52008e4', 'church', '(38.730408, -9.131479)', 'http://www.cm-lisboa.pt/equipamentos/equipamento/info/igreja-e-edificio-do-antigo-convento-de-nossa-senhora-da-penha-de-franca-incluindo-o-seu-patrimo'),
('6c5dcb8b-c3f4-4b35-a619-abafd6b668eb', 'church', '(38.718904, -9.119880)', 'http://www.cm-lisboa.pt/equipamentos/equipamento/info/igreja-paroquial-de-sta-engracia-ou-de-na-sra-da-porciuncula-convento-dos-barbadinhos'),
('47af7107-0227-4976-9cf6-60aaba5f0790', 'church', '(38.718531, -9.158397)', 'http://www.patriarcado-lisboa.pt/site/index.php?cont_=90&tem=65&id=1671'),
('217f75fa-8abc-43e8-95b2-77def9aab3f6', 'church', '(38.748148, -9.135550)', 'https://www.santajoanaprincesa.com/'),
('03b69979-30da-42d3-941c-0bd0adb4c99c', 'church', '(38.732357, -9.162128)', 'http://www.patriarcado-lisboa.pt/site/index.php?cont_=180&tem=84&id=38'),
('580b1e21-b937-4221-87f1-91be8fe48bbd', 'church', '(38.712187, -9.127844)', 'http://www.cm-lisboa.pt/equipamentos/equipamento/info/igreja-de-santo-estevao'),
('393b7a1c-bfc9-44b5-abd7-2447cf8b4717', 'church', '(38.773683, -9.117346)', 'https://www.facebook.com/paroquia.santo.eugenio/'),
('19b82bd2-732d-4261-88f9-b7f3a825c6a7', 'church', '(38.712828, -9.135565)', 'https://www.guiadacidade.pt/pt/poi-igreja-de-sao-cristovao-17801'),
('10202f9d-df1d-41ad-9f9a-caf0f39eb97d', 'church', '(38.741664, -9.173322)', 'http://www.paroquiasaodomingosdebenfica.pt/'),
('36c60585-6925-43be-a9ad-2e45ff224fd7', 'church', '(38.7632947, -9.2059698)', 'http://www.paroquiadealfornelos.com/'),
('9b07013b-9b7c-497a-b32f-dbdfec4d3e66', 'church', '(38.7548201, -9.1381926)', 'http://www.patriarcado-lisboa.pt/site/index.php?cont_=90&tem=65&id=1696'),
('d6f6eeb4-6dfc-4e58-a3e0-f4bac85efa9e', 'church', '(38.740390, -9.137937)', 'http://paroquiasaojoaodeus.pt/'),
('3349c439-9d36-49f6-939f-1b48ec0c2a1f', 'church', '(38.760301, -9.190800)', 'http://paroquiadecarnide.webnode.pt/'),
('53f3ed93-c229-4a59-b447-3cd2afee4a7a', 'church', '(38.718791, -9.152235)', 'https://www.paroquiadesaomamede.pt/'),
('1de61c17-eddb-4584-aa45-646f0b93f667', 'church', '(38.7078523, -9.1451506)', 'https://www.guiadacidade.pt/pt/poi-igreja-de-sao-paulo-17803'),
('0af7212c-5bb0-4bbd-a322-ce3b041bf65b', 'church', '(38.732454, -9.151391)', 'http://www.cm-lisboa.pt/equipamentos/equipamento/info/igreja-de-sao-sebastiao-da-pedreira'),
('48c861d1-b2bb-416e-a180-7cacde0ce1f0', 'church', '(38.724803, -9.147218)', 'http://www.cm-lisboa.pt/equipamentos/equipamento/info/igreja-do-sagrado-coracao-de-jesus'),
('cc672fcb-57f8-46e1-99ad-42bd69a538aa', 'church', '(38.752491, -9.115740)', 'http://www.patriarcado-lisboa.pt/site/index.php?cont_=90&tem=65&id=1663'),
('b2c2449d-d788-42bc-afaa-32b7da54464e', 'church', '(38.710113, -9.134768)', 'https://www.guiadacidade.pt/pt/poi-igreja-da-madalena-17837'),
('f5bc50d1-7399-44a3-a480-f010940abc3c', 'church', '(38.709983, -9.133909)', 'https://www.guiadacidade.pt/pt/poi-igreja-de-santo-antonio-17802'),
('d67bf5bb-9445-46ff-851b-de3d1e6a1894', 'church', '(38.714713, -9.138768)', 'https://www.guiadacidade.pt/pt/poi-igreja-de-sao-domingos-16603'),
('0e76d13f-ad31-4d5d-88fa-e5c5827f33ec', 'church', '(38.774121, -9.165951)', 'http://www.jesuitas.pt/Par%C3%B3quia-S.-Jo%C3%A3o-Baptista-do-Lumiar-267.aspx'),
('599a8652-b31f-405c-898f-b73f38cebdee', 'church', '(38.763157, -9.113652)', 'http://www.paroquiaolivaissul.pt/index.php'),
('05f7cc95-58cd-4d58-8dcb-840e700fec98', 'church', '(38.719503, -9.143210)', 'http://www.cm-lisboa.pt/equipamentos/equipamento/info/conjunto-formado-pela-igreja-de-sao-jose-dos-carpinteiros-e-predios-anexos-da-rua-de-s-jose-com'),
('efc0774c-5a99-4b44-be95-3350eda0f68d', 'church', '(38.714886, -9.127637)', 'http://www.patriarcado-lisboa.pt/site/'),
('5a1de34e-6b4f-41e8-a6b4-e2b7939819cc', 'church', '(38.736497, -9.134235)', 'https://igrejauniversal.pt/'),
('0004314a-9804-43e4-a82f-d5777929e547', 'church', '(38.735650, -9.158537)', 'http://www.comunidadeislamica.pt/pt/'),
('1670cef2-5033-48b3-8d4a-55a5e6a6cf6c', 'church', '(38.7912135, -9.1828103)', 'http://www.mosteirodeodivelas.org/'),
('384bf88d-9122-4061-83c9-7d98cec21fed', 'church', '(38.713597, -9.143461)', 'http://www.museu-saoroque.com/pt/Home.aspx'),
('2c8212fe-d742-4697-8dd0-ae2f6085b6a5', 'church', '(38.733243, -9.149978)', 'http://www.anuariocatolicoportugal.net/nunciatura.asp'),
('ec66e647-10cd-472a-a082-a5f188d8a4d9', 'church', '(38.752920, -9.172950)', 'http://www.paroquiatomasaquino.com/'),
('62c8bc79-b261-4e9b-8818-559ecc130e65', 'church', '(38.709891, -9.132607)', 'http://www.patriarcado-lisboa.pt/site/'),
('bb44d643-21b9-4580-8fb0-6fc4eb64643e', 'church', '(38.720353, -9.153337)', 'http://www.cilisboa.org/');
INSERT INTO poi_name (id, main, lang, name) VALUES
('291e24f0-f8f6-48bf-a30b-7c39d7e72d3e', true, 'pt', 'Basílica de Nossa Senhora dos Mártires'),
('291e24f0-f8f6-48bf-a30b-7c39d7e72d3e', false, 'en', 'Nossa Senhora dos Mártires Basilica'),
('291e24f0-f8f6-48bf-a30b-7c39d7e72d3e', false, 'fr', 'Basilique de Nossa Senhora dos Mártires'),
('7d5c25f1-12d3-4bf3-9758-1ac11c19d5b4', true, 'pt', 'Capela dos Castros - Antigo Convento de São Domingos de Benfica'),
('7d5c25f1-12d3-4bf3-9758-1ac11c19d5b4', false, 'en', 'Castros Chapel - São Domingos de Benfica Ancient Convent'),
('7d5c25f1-12d3-4bf3-9758-1ac11c19d5b4', false, 'fr', 'Chapelle des Castros - Ancien Couvent de São Domingos de Benfica'),
('7d5c25f1-12d3-4bf3-9758-1ac11c19d5b4', false, 'es', 'Capilla de los Castros - Antiguo Convento de São Domingos de Benfica'),
('aebc903e-1f98-49ba-8431-fea14907ddb5', true, 'pt', 'Capela de Nossa Senhora de Monserrate'),
('aebc903e-1f98-49ba-8431-fea14907ddb5', false, 'en', 'Nossa Senhora de Monserrate Chapel'),
('aebc903e-1f98-49ba-8431-fea14907ddb5', false, 'fr', 'Chapelle de Nossa Senhora de Monserrate'),
('aebc903e-1f98-49ba-8431-fea14907ddb5', false, 'es', 'Capilla de Nossa Senhora de Monserrate'),
('590c9be1-800c-486a-89c4-849028781c07', true, 'pt', 'Capela do Rato'),
('590c9be1-800c-486a-89c4-849028781c07', false, 'en', 'Rato Chapel'),
('590c9be1-800c-486a-89c4-849028781c07', false, 'fr', 'Chapelle du Rato'),
('590c9be1-800c-486a-89c4-849028781c07', false, 'es', 'Capilla del Rato'),
('da8f9267-7525-42c5-b7c6-1ea82a4a9042', true, 'pt', 'Capela do Vale de Santo António'),
('da8f9267-7525-42c5-b7c6-1ea82a4a9042', false, 'en', 'Santo António Valley Chapel'),
('da8f9267-7525-42c5-b7c6-1ea82a4a9042', false, 'fr', 'Chapelle du Vale de Santo António'),
('da8f9267-7525-42c5-b7c6-1ea82a4a9042', false, 'es', 'Capilla del Vale de Santo António'),
('d79798ed-bfd5-4198-8c39-32769fe881e6', true, 'pt', 'Convento da Encarnação'),
('d79798ed-bfd5-4198-8c39-32769fe881e6', false, 'en', 'Encarnação Convent'),
('d79798ed-bfd5-4198-8c39-32769fe881e6', false, 'fr', 'Couvent d''Encarnação'),
('d79798ed-bfd5-4198-8c39-32769fe881e6', false, 'es', 'Convento de la Encarnação'),
('94c5cece-5744-44eb-aaf8-323e626905f2', true, 'pt', 'Capela de Nossa Senhora da Saúde'),
('94c5cece-5744-44eb-aaf8-323e626905f2', false, 'en', 'Nossa Senhora da Saúde Chapel'),
('94c5cece-5744-44eb-aaf8-323e626905f2', false, 'fr', 'Chapelle de Nossa Senhora da Saúde'),
('94c5cece-5744-44eb-aaf8-323e626905f2', false, 'es', 'Capilla de Nossa Senhora da Saúde'),
('f4c4cb07-b81d-4ef7-93fb-32814a1eb100', true, 'pt', 'Centro Ismaili de Lisboa'),
('f4c4cb07-b81d-4ef7-93fb-32814a1eb100', false, 'en', 'Lisbon Ismaili Center'),
('f4c4cb07-b81d-4ef7-93fb-32814a1eb100', false, 'fr', 'Centre Ismaili de Lisbonne'),
('0f795df5-f63a-40c8-87e1-e29ec620bcd1', true, 'pt', 'Convento de Santa Teresa de Jesus'),
('0f795df5-f63a-40c8-87e1-e29ec620bcd1', false, 'en', 'Santa Teresa de Jesus Convent'),
('0f795df5-f63a-40c8-87e1-e29ec620bcd1', false, 'fr', 'Couvent de Santa Teresa de Jesus'),
('3d23a0b2-9be1-4c44-90c3-082fde0b49ff', true, 'pt', 'Convento de São Domingos'),
('3d23a0b2-9be1-4c44-90c3-082fde0b49ff', false, 'en', 'Sâo Domingos Convent'),
('3d23a0b2-9be1-4c44-90c3-082fde0b49ff', false, 'fr', 'Couvent de Sâo Domingos'),
('3d23a0b2-9be1-4c44-90c3-082fde0b49ff', false, 'es', 'Couvent de Sâo Domingos'),
('d53b59e0-c82b-4b83-a8db-39ab80e8ecf9', true, 'pt', 'Igreja e Centro Paroquial de São Jorge de Arroios'),
('d53b59e0-c82b-4b83-a8db-39ab80e8ecf9', false, 'en', 'São José de Arroios Church and Parish Center'),
('d53b59e0-c82b-4b83-a8db-39ab80e8ecf9', false, 'fr', 'Église et Centre Paroissial de São Jorge de Arroios'),
('d53b59e0-c82b-4b83-a8db-39ab80e8ecf9', false, 'es', 'Iglesia y Centro Parroquial de São José de Arroios'),
('d9313d9b-465a-447f-9a94-2b458a6d5a96', true, 'pt', 'Igreja e Convento da Graça'),
('d9313d9b-465a-447f-9a94-2b458a6d5a96', false, 'en', 'Graça Church and Convent'),
('d9313d9b-465a-447f-9a94-2b458a6d5a96', false, 'fr', 'Église et Couvent de Graça'),
('d9313d9b-465a-447f-9a94-2b458a6d5a96', false, 'es', 'Iglesia y Couvento de la Graça'),
('5f5ec80e-b514-4cd8-a867-2eb176b8ad66', true, 'pt', 'Igreja do Corpo Santo'),
('5f5ec80e-b514-4cd8-a867-2eb176b8ad66', false, 'en', 'Corpo Santo Church'),
('5f5ec80e-b514-4cd8-a867-2eb176b8ad66', false, 'fr', 'Église du Corpo Santo'),
('5f5ec80e-b514-4cd8-a867-2eb176b8ad66', false, 'es', 'Iglesia del Corpo Santo'),
('e2f3d193-abcb-4073-86e5-a743be8a7d1e', true, 'pt', 'Igreja Italiana de Nossa Senhora do Loreto'),
('e2f3d193-abcb-4073-86e5-a743be8a7d1e', false, 'en', 'Nossa Senhora do Loreto Italian Church'),
('e2f3d193-abcb-4073-86e5-a743be8a7d1e', false, 'fr', 'Église Italienne de Nossa Senhora do Loreto'),
('e2f3d193-abcb-4073-86e5-a743be8a7d1e', false, 'es', 'Iglesia Italiana de Nossa Senhora do Loret'),
('cdf64da1-9d6a-4a6a-8995-d2b94bd9689b', true, 'pt', 'Igreja Matriz de Odivelas'),
('cdf64da1-9d6a-4a6a-8995-d2b94bd9689b', false, 'en', 'Odivelas Main Church'),
('cdf64da1-9d6a-4a6a-8995-d2b94bd9689b', false, 'fr', 'Église Majeure d''Odivelas'),
('cdf64da1-9d6a-4a6a-8995-d2b94bd9689b', false, 'es', 'Iglesia Principal de Odivelas'),
('da772310-515c-4958-80f4-39c364c7669e', true, 'pt', 'Igreja de Nossa Senhora da Conceição Velha'),
('da772310-515c-4958-80f4-39c364c7669e', false, 'en', 'Nossa Senhora da Conceição Velha'),
('da772310-515c-4958-80f4-39c364c7669e', false, 'fr', 'Église de Nossa Senhora da Conceição Velha'),
('da772310-515c-4958-80f4-39c364c7669e', false, 'es', 'Iglesia de Nossa Senhora da Conceição Velha'),
('e6c35314-14c3-4e13-ab9b-261def3cadb0', true, 'pt', 'Igreja de Nossa Senhora da Encarnação'),
('e6c35314-14c3-4e13-ab9b-261def3cadb0', false, 'en', 'Nossa Senhora da Encarnação Church'),
('e6c35314-14c3-4e13-ab9b-261def3cadb0', false, 'fr', 'Église de Nossa Senhora da Encarnação'),
('e6c35314-14c3-4e13-ab9b-261def3cadb0', false, 'es', 'Iglesia de Nossa Senhora da Encarnação'),
('b6d636c9-b0ae-4ad7-9169-0b14001729af', true, 'pt', 'Igreja de Nossa Senhora da Porta do Céu'),
('b6d636c9-b0ae-4ad7-9169-0b14001729af', false, 'en', 'Nossa Senhora da Porta do Céu Church'),
('b6d636c9-b0ae-4ad7-9169-0b14001729af', false, 'fr', 'Église de Nossa Senhora da Porta do Céu'),
('b6d636c9-b0ae-4ad7-9169-0b14001729af', false, 'es', 'Iglesia Parroquial Senhora da Porta do Céu'),
('2e78daef-2a10-4eb6-9c27-8f173bbb7958', true, 'pt', 'Igreja de Nossa Senhora do Rosário - Antigo Convento de São Domingos de Benfica'),
('2e78daef-2a10-4eb6-9c27-8f173bbb7958', false, 'en', 'Nossa Senhora do Rosário Church - São Domingos de Benfica Ancient Convent'),
('2e78daef-2a10-4eb6-9c27-8f173bbb7958', false, 'fr', 'Église de Nossa Senhora do Rosário - Ancien Couvent de São Domingos de Benfica'),
('2e78daef-2a10-4eb6-9c27-8f173bbb7958', false, 'es', 'Iglesia de Nossa Senhora do Rosário - Antiguo Convento de São Domingos de Benfica'),
('2edf3983-82ee-4520-b21c-578eb6b9053b', true, 'pt', 'Igreja de Nossa Senhora do Rosário de Fátima'),
('2edf3983-82ee-4520-b21c-578eb6b9053b', false, 'en', 'Nossa Senhora do Rosário de Fátima Church'),
('2edf3983-82ee-4520-b21c-578eb6b9053b', false, 'fr', 'Église de Nossa Senhora do Rosário de Fátima'),
('2edf3983-82ee-4520-b21c-578eb6b9053b', false, 'es', 'Iglesia de Nossa Senhora do Rosário de Fátima'),
('002c1bbc-18af-414a-8142-9cd3debb5f71', true, 'pt', 'Igreja de Nossa Senhora do Socorro'),
('002c1bbc-18af-414a-8142-9cd3debb5f71', false, 'en', 'Nossa Senhora da Saúde Church'),
('002c1bbc-18af-414a-8142-9cd3debb5f71', false, 'fr', 'Église de Nossa Senhora da Saúde'),
('002c1bbc-18af-414a-8142-9cd3debb5f71', false, 'es', 'Iglesia de Nossa Senhora da Saúde'),
('dd88b3cd-8522-47e0-837f-975e20c18c93', true, 'pt', 'Igreja Ortodoxa Russa'),
('dd88b3cd-8522-47e0-837f-975e20c18c93', false, 'en', 'Russian Orthodox Church'),
('dd88b3cd-8522-47e0-837f-975e20c18c93', false, 'fr', 'Église Orthodoxe Russe'),
('dd88b3cd-8522-47e0-837f-975e20c18c93', false, 'es', 'Iglesia Ortodoxa Rusa'),
('90696519-fba3-4f6a-8574-5370ae3bc8f6', true, 'pt', 'Igreja Paroquial do Espírito Santo'),
('90696519-fba3-4f6a-8574-5370ae3bc8f6', false, 'en', 'Espírito Santo Parish Church'),
('90696519-fba3-4f6a-8574-5370ae3bc8f6', false, 'fr', 'Église Paroissiale du Espírito Santo'),
('90696519-fba3-4f6a-8574-5370ae3bc8f6', false, 'es', 'Iglesia Parroquial del Espírito Santo'),
('27f9cd67-6460-4c37-9a33-cc41deb8e857', true, 'pt', 'Igreja Paroquial de Nossa Senhora dos Anjos'),
('27f9cd67-6460-4c37-9a33-cc41deb8e857', false, 'en', 'Nossa Senhora dos Anjos Parish Church'),
('27f9cd67-6460-4c37-9a33-cc41deb8e857', false, 'fr', 'Église Paroissiale de Nossa Senhora dos Anjos'),
('27f9cd67-6460-4c37-9a33-cc41deb8e857', false, 'es', 'Iglesia Parroquial de Nossa Senhora dos Anjos'),
('052ff00b-539c-476c-94ec-2ef4e090a5e5', true, 'pt', 'Igreja Paroquial de Nossa Senhora do Carmo do Alto do Lumiar'),
('052ff00b-539c-476c-94ec-2ef4e090a5e5', false, 'en', 'Nossa Senhora do Carmo do Alto do Lumiar Parish Church'),
('052ff00b-539c-476c-94ec-2ef4e090a5e5', false, 'fr', 'Église Paroissiale de Nossa Senhora do Carmo do Alto do Lumiar'),
('052ff00b-539c-476c-94ec-2ef4e090a5e5', false, 'es', 'Iglesia Parroquial de Nossa Senhora do Carmo do Alto do Lumiar'),
('a8ea5c39-24a6-4cf1-be2f-a53fc548143d', true, 'pt', 'Igreja Paroquial de Nossa Senhora da Encarnação da Ameixoeira'),
('a8ea5c39-24a6-4cf1-be2f-a53fc548143d', false, 'en', 'Nossa Senhora da Encarnação Parish Church of Ameixoeira'),
('a8ea5c39-24a6-4cf1-be2f-a53fc548143d', false, 'fr', 'Église Paroissiale de Nossa Senhora da Encarnação d''Ameixoeira'),
('a8ea5c39-24a6-4cf1-be2f-a53fc548143d', false, 'es', 'Iglesia Parroquial de Nossa Senhora da Encarnação de Ameixoeira'),
('79de808e-f2a8-4a1e-9c25-e47079109c0a', true, 'pt', 'Igreja Paroquial de Nossa Senhora da Pena'),
('79de808e-f2a8-4a1e-9c25-e47079109c0a', false, 'en', 'Nossa Senhora da Pena Parish Church'),
('79de808e-f2a8-4a1e-9c25-e47079109c0a', false, 'fr', 'Église Paroissiale de Nossa Senhora da Pena'),
('79de808e-f2a8-4a1e-9c25-e47079109c0a', false, 'es', 'Iglesia Parroquial de Nossa Senhora da Pena'),
('8efa89b3-2973-4261-96b0-e5dbc52008e4', true, 'pt', 'Igreja Paroquial da Penha de França'),
('8efa89b3-2973-4261-96b0-e5dbc52008e4', false, 'en', 'Penha de França Parish Church'),
('8efa89b3-2973-4261-96b0-e5dbc52008e4', false, 'fr', 'Église Paroissiale de Penha de França'),
('8efa89b3-2973-4261-96b0-e5dbc52008e4', false, 'es', 'Iglesia Parroquial de la Penha de França'),
('6c5dcb8b-c3f4-4b35-a619-abafd6b668eb', true, 'pt', 'Igreja Paroquial de Santa Engrácia - Convento dos Barbadinhos'),
('6c5dcb8b-c3f4-4b35-a619-abafd6b668eb', false, 'en', 'Santa Engrácia Parish Council - Barbadinhos Convent'),
('6c5dcb8b-c3f4-4b35-a619-abafd6b668eb', false, 'fr', 'Église Paroissiale de Santa Engrácia - Couvent des Barbadinhos'),
('6c5dcb8b-c3f4-4b35-a619-abafd6b668eb', false, 'es', 'Iglesia Parroquial de Santa Engrácia - Convento de los Barbadinhos'),
('47af7107-0227-4976-9cf6-60aaba5f0790', true, 'pt', 'Igreja Paroquial de Santa Isabel'),
('47af7107-0227-4976-9cf6-60aaba5f0790', false, 'en', 'Santa Isabel Parish Church'),
('47af7107-0227-4976-9cf6-60aaba5f0790', false, 'fr', 'Église Paroissiale de Santa Isabel'),
('47af7107-0227-4976-9cf6-60aaba5f0790', false, 'es', 'Iglesia Parroquial de Santa Isabel'),
('217f75fa-8abc-43e8-95b2-77def9aab3f6', true, 'pt', 'Igreja Paroquial de Santa Joana Princesa'),
('217f75fa-8abc-43e8-95b2-77def9aab3f6', false, 'en', 'Santa Joana Princesa Parish Church'),
('217f75fa-8abc-43e8-95b2-77def9aab3f6', false, 'fr', 'Église Paroissiale de Santa Joana Princesa'),
('217f75fa-8abc-43e8-95b2-77def9aab3f6', false, 'es', 'Iglesia Parroquial de Santa Joana Princesa'),
('03b69979-30da-42d3-941c-0bd0adb4c99c', true, 'pt', 'Igreja Paroquial de Santo António de Campolide'),
('03b69979-30da-42d3-941c-0bd0adb4c99c', false, 'en', 'Santo António de Campolide Parish Church'),
('03b69979-30da-42d3-941c-0bd0adb4c99c', false, 'fr', 'Église Paroissiale de Santo António de Campolide'),
('03b69979-30da-42d3-941c-0bd0adb4c99c', false, 'es', 'Iglesia Parroquial de Santo António de Campolide'),
('580b1e21-b937-4221-87f1-91be8fe48bbd', true, 'pt', 'Igreja Paroquial de Santo Estêvão'),
('580b1e21-b937-4221-87f1-91be8fe48bbd', false, 'en', 'Santo Estêvão Parish Council'),
('580b1e21-b937-4221-87f1-91be8fe48bbd', false, 'fr', 'Église Paroissiale de Santo Estêvão'),
('580b1e21-b937-4221-87f1-91be8fe48bbd', false, 'es', 'Iglesia Parroquial de Santo Estêvão'),
('393b7a1c-bfc9-44b5-abd7-2447cf8b4717', true, 'pt', 'Igreja Paroquial de Santo Eugénio do Bairro da Encarnação'),
('393b7a1c-bfc9-44b5-abd7-2447cf8b4717', false, 'en', 'Encarnação Neighbourhood''s Santo Eugénio Parish Church'),
('393b7a1c-bfc9-44b5-abd7-2447cf8b4717', false, 'fr', 'Église Paroissiale de Santo Eugénio du Quartier d''Encarnação'),
('393b7a1c-bfc9-44b5-abd7-2447cf8b4717', false, 'es', 'Iglesia Parroquial de Santo Eugénio del Barrio de Encarnação'),
('19b82bd2-732d-4261-88f9-b7f3a825c6a7', true, 'pt', 'Igreja Paroquial de São Cristovão e São Lourenço'),
('19b82bd2-732d-4261-88f9-b7f3a825c6a7', false, 'en', 'São Cristóvão and São Lourenço Parish Church'),
('19b82bd2-732d-4261-88f9-b7f3a825c6a7', false, 'fr', 'Église Paroissiale de São Cristóvão et São Lourenço'),
('19b82bd2-732d-4261-88f9-b7f3a825c6a7', false, 'es', 'Iglesia Parroquial de São Cristóvão et São Lourenço'),
('10202f9d-df1d-41ad-9f9a-caf0f39eb97d', true, 'pt', 'Igreja Paroquial de São Domingos de Benfica'),
('10202f9d-df1d-41ad-9f9a-caf0f39eb97d', false, 'en', 'São Domingos de Benfica Parish Church'),
('10202f9d-df1d-41ad-9f9a-caf0f39eb97d', false, 'fr', 'Église Paroissiale de São Domingos de Benfica'),
('10202f9d-df1d-41ad-9f9a-caf0f39eb97d', false, 'es', 'Iglesia Parroquial de São Domingos de Benfica'),
('36c60585-6925-43be-a9ad-2e45ff224fd7', true, 'pt', 'Igreja Paroquial de São Francisco de Assis'),
('36c60585-6925-43be-a9ad-2e45ff224fd7', false, 'en', 'São Francisco de Assis Parish Church'),
('36c60585-6925-43be-a9ad-2e45ff224fd7', false, 'fr', 'Église Paroissiale de São Francisco de Assis'),
('36c60585-6925-43be-a9ad-2e45ff224fd7', false, 'es', 'Iglesia Parroquial de São Francisco de Assis'),
('9b07013b-9b7c-497a-b32f-dbdfec4d3e66', true, 'pt', 'Igreja Paroquial de São João de Brito'),
('9b07013b-9b7c-497a-b32f-dbdfec4d3e66', false, 'en', 'São João de Brito Parish Church'),
('9b07013b-9b7c-497a-b32f-dbdfec4d3e66', false, 'fr', 'Église Paroissiale de São João de Brito'),
('9b07013b-9b7c-497a-b32f-dbdfec4d3e66', false, 'es', 'Iglesia Parroquial de São João de Brito'),
('d6f6eeb4-6dfc-4e58-a3e0-f4bac85efa9e', true, 'pt', 'Igreja Paroquial de São João de Deus'),
('d6f6eeb4-6dfc-4e58-a3e0-f4bac85efa9e', false, 'en', 'São João de Deus Parish Church'),
('d6f6eeb4-6dfc-4e58-a3e0-f4bac85efa9e', false, 'fr', 'Église Paroissiale de São João de Deus'),
('d6f6eeb4-6dfc-4e58-a3e0-f4bac85efa9e', false, 'es', 'Iglesia Parroquial de São João de Deus'),
('3349c439-9d36-49f6-939f-1b48ec0c2a1f', true, 'pt', 'Igreja Paroquial de São Lourenço'),
('3349c439-9d36-49f6-939f-1b48ec0c2a1f', false, 'en', 'São Lourenço Parish Church'),
('3349c439-9d36-49f6-939f-1b48ec0c2a1f', false, 'fr', 'Église Paroissiale de São Lourenço'),
('3349c439-9d36-49f6-939f-1b48ec0c2a1f', false, 'es', 'Iglesia Parroquial de São Lourenço'),
('53f3ed93-c229-4a59-b447-3cd2afee4a7a', true, 'pt', 'Igreja Paroquial de São Mamede'),
('53f3ed93-c229-4a59-b447-3cd2afee4a7a', false, 'en', 'São Mamede Parish Church'),
('53f3ed93-c229-4a59-b447-3cd2afee4a7a', false, 'fr', 'Église Paroissiale de São Mamede'),
('53f3ed93-c229-4a59-b447-3cd2afee4a7a', false, 'es', 'Iglesia Parroquial de São Mamede'),
('1de61c17-eddb-4584-aa45-646f0b93f667', true, 'pt', 'Igreja Paroquial de São Paulo'),
('1de61c17-eddb-4584-aa45-646f0b93f667', false, 'en', 'São Paulo Parish Church'),
('1de61c17-eddb-4584-aa45-646f0b93f667', false, 'fr', 'Église Paroissiale de São Paulo'),
('1de61c17-eddb-4584-aa45-646f0b93f667', false, 'es', 'Iglesia Parroquial de São Paulo'),
('0af7212c-5bb0-4bbd-a322-ce3b041bf65b', true, 'pt', 'Igreja Paroquial de São Sebastião da Pedreira'),
('0af7212c-5bb0-4bbd-a322-ce3b041bf65b', false, 'en', 'São Sebastião da Pedreira Parish Churc'),
('0af7212c-5bb0-4bbd-a322-ce3b041bf65b', false, 'fr', 'Église Paroissiale de São Sebastião da Pedreira'),
('0af7212c-5bb0-4bbd-a322-ce3b041bf65b', false, 'es', 'Iglesia Parroquial de São Sebastião da Pedreira'),
('48c861d1-b2bb-416e-a180-7cacde0ce1f0', true, 'pt', 'Igreja do Sagrado Coração de Jesus'),
('48c861d1-b2bb-416e-a180-7cacde0ce1f0', false, 'en', 'Holly Heart of Jesus Church'),
('48c861d1-b2bb-416e-a180-7cacde0ce1f0', false, 'fr', 'Église du Sacré Coeur de Jésus'),
('48c861d1-b2bb-416e-a180-7cacde0ce1f0', false, 'es', 'Iglesia del Sagrado Corazón de Jesus'),
('cc672fcb-57f8-46e1-99ad-42bd69a538aa', true, 'pt', 'Igreja de Santa Beatriz da Silva'),
('cc672fcb-57f8-46e1-99ad-42bd69a538aa', false, 'en', 'Santa Beatriz da Silva Church'),
('cc672fcb-57f8-46e1-99ad-42bd69a538aa', false, 'fr', 'Église de Santa Beatriz da Silva'),
('cc672fcb-57f8-46e1-99ad-42bd69a538aa', false, 'es', 'Iglesia de Santa Beatriz da Silva'),
('b2c2449d-d788-42bc-afaa-32b7da54464e', true, 'pt', 'Igreja de Santa Maria Madalena'),
('b2c2449d-d788-42bc-afaa-32b7da54464e', false, 'en', 'Santa Maria Madalena Churc'),
('b2c2449d-d788-42bc-afaa-32b7da54464e', false, 'fr', 'Église de Santa Maria Madalena'),
('b2c2449d-d788-42bc-afaa-32b7da54464e', false, 'es', 'Iglesia de Santa Maria Madalena'),
('f5bc50d1-7399-44a3-a480-f010940abc3c', true, 'pt', 'Igreja de Santo António'),
('f5bc50d1-7399-44a3-a480-f010940abc3c', false, 'en', 'Santo António Church'),
('f5bc50d1-7399-44a3-a480-f010940abc3c', false, 'fr', 'Église de Santo António'),
('f5bc50d1-7399-44a3-a480-f010940abc3c', false, 'es', 'Iglesia de Santo António'),
('d67bf5bb-9445-46ff-851b-de3d1e6a1894', true, 'pt', 'Igreja de São Domingos'),
('d67bf5bb-9445-46ff-851b-de3d1e6a1894', false, 'en', 'São Domingos Church'),
('d67bf5bb-9445-46ff-851b-de3d1e6a1894', false, 'fr', 'Église de São Domingos'),
('d67bf5bb-9445-46ff-851b-de3d1e6a1894', false, 'es', 'Iglesia de São Domingos'),
('0e76d13f-ad31-4d5d-88fa-e5c5827f33ec', true, 'pt', 'Igreja de São João Baptista - Igreja Paroquial do Lumiar'),
('0e76d13f-ad31-4d5d-88fa-e5c5827f33ec', false, 'en', 'São João Baptista Church - Lumiar Parish Church'),
('0e76d13f-ad31-4d5d-88fa-e5c5827f33ec', false, 'fr', 'Église de São João Baptista - Église Paroissiale du Lumiar'),
('0e76d13f-ad31-4d5d-88fa-e5c5827f33ec', false, 'es', 'Iglesia de São João Baptista - Iglesia Parroquial del Lumiar'),
('599a8652-b31f-405c-898f-b73f38cebdee', true, 'pt', 'Igreja de São José - Olivais Sul'),
('599a8652-b31f-405c-898f-b73f38cebdee', false, 'en', 'São José Church - Olivais Sul'),
('599a8652-b31f-405c-898f-b73f38cebdee', false, 'fr', 'Église de São José - Olivais Sul'),
('599a8652-b31f-405c-898f-b73f38cebdee', false, 'es', 'Iglesia de São José - Olivais Sul'),
('05f7cc95-58cd-4d58-8dcb-840e700fec98', true, 'pt', 'Igreja de São José dos Carpinteiros'),
('05f7cc95-58cd-4d58-8dcb-840e700fec98', false, 'en', 'São José dos Carpinteiros Church'),
('05f7cc95-58cd-4d58-8dcb-840e700fec98', false, 'fr', 'Église de São José dos Carpinteiros'),
('05f7cc95-58cd-4d58-8dcb-840e700fec98', false, 'es', 'Iglesia de São José dos Carpinteiros'),
('efc0774c-5a99-4b44-be95-3350eda0f68d', true, 'pt', 'Igreja de São Vicente de Fora - Patriarcado de Lisboa'),
('efc0774c-5a99-4b44-be95-3350eda0f68d', false, 'en', 'São Vicente de Fora Church - Lisbon Patriarchy'),
('efc0774c-5a99-4b44-be95-3350eda0f68d', false, 'fr', 'Église de São Vicente de Fora - Patriarcat de Lisbonne'),
('efc0774c-5a99-4b44-be95-3350eda0f68d', false, 'es', 'Iglesia de São Vicente de Fora - Patriarcado de Lisboa'),
('5a1de34e-6b4f-41e8-a6b4-e2b7939819cc', true, 'pt', 'IURD - Igreja Universal do Reino de Deus - Sede Nacional'),
('5a1de34e-6b4f-41e8-a6b4-e2b7939819cc', false, 'en', 'Universal Church of the Kingdom of God - National Headquarters'),
('5a1de34e-6b4f-41e8-a6b4-e2b7939819cc', false, 'fr', 'Église Universelle du Royaume de Dieu - Siège National'),
('5a1de34e-6b4f-41e8-a6b4-e2b7939819cc', false, 'es', 'Iglesia Universal del Reino de Dios - Sede Nacional'),
('0004314a-9804-43e4-a82f-d5777929e547', true, 'pt', 'Mesquita Central de Lisboa'),
('0004314a-9804-43e4-a82f-d5777929e547', false, 'en', 'Lisbon Central Mosque'),
('0004314a-9804-43e4-a82f-d5777929e547', false, 'fr', 'Mosquée Centrale de Lisbonne'),
('0004314a-9804-43e4-a82f-d5777929e547', false, 'es', 'Mezquita Central de Lisboa'),
('1670cef2-5033-48b3-8d4a-55a5e6a6cf6c', true, 'pt', 'Mosteiro de São Dinis'),
('1670cef2-5033-48b3-8d4a-55a5e6a6cf6c', false, 'en', 'São Dinis Monastery'),
('1670cef2-5033-48b3-8d4a-55a5e6a6cf6c', false, 'fr', 'Monastère de São Dinis'),
('1670cef2-5033-48b3-8d4a-55a5e6a6cf6c', false, 'es', 'Monasterio de São Dinis'),
('384bf88d-9122-4061-83c9-7d98cec21fed', true, 'pt', 'Museu e Igreja de São Roque'),
('384bf88d-9122-4061-83c9-7d98cec21fed', false, 'en', 'São Roque Museum and Church'),
('384bf88d-9122-4061-83c9-7d98cec21fed', false, 'fr', 'Musée et Église de São Roque'),
('384bf88d-9122-4061-83c9-7d98cec21fed', false, 'es', 'Museo y Iglesia de São Roque'),
('2c8212fe-d742-4697-8dd0-ae2f6085b6a5', true, 'pt', 'Nunciatura Apostólica da Santa Sé'),
('2c8212fe-d742-4697-8dd0-ae2f6085b6a5', false, 'en', 'Portuguese Holy See Apostolic'),
('2c8212fe-d742-4697-8dd0-ae2f6085b6a5', false, 'fr', 'Nonciature Apostolique du Saint-Siège au Portugal'),
('2c8212fe-d742-4697-8dd0-ae2f6085b6a5', false, 'es', 'Nunciatura Apostólica de la Santa Sede de Portugal'),
('ec66e647-10cd-472a-a082-a5f188d8a4d9', true, 'pt', 'Paróquia de São Tomás de Aquino'),
('ec66e647-10cd-472a-a082-a5f188d8a4d9', false, 'en', 'São Tomás de Aquino Parish'),
('ec66e647-10cd-472a-a082-a5f188d8a4d9', false, 'fr', 'Paroisse de São Tomás de Aquino'),
('ec66e647-10cd-472a-a082-a5f188d8a4d9', false, 'es', 'Parroquia de São Tomás de Aquino'),
('62c8bc79-b261-4e9b-8818-559ecc130e65', true, 'pt', 'Sé Patriarcal de Lisboa'),
('62c8bc79-b261-4e9b-8818-559ecc130e65', false, 'en', 'Lisbon''s Cathedral'),
('62c8bc79-b261-4e9b-8818-559ecc130e65', false, 'fr', 'Cathédrale Patriarcale de Lisbonne'),
('62c8bc79-b261-4e9b-8818-559ecc130e65', false, 'es', 'Catedral de Lisboa'),
('bb44d643-21b9-4580-8fb0-6fc4eb64643e', true, 'pt', 'Sinagoga Portuguesa Shaaré Tikvah'),
('bb44d643-21b9-4580-8fb0-6fc4eb64643e', false, 'en', 'Shaaré Tikvah Portuguese Synagogue'),
('bb44d643-21b9-4580-8fb0-6fc4eb64643e', false, 'fr', 'Synagogue Portugaise Shaaré Tikvah');
INSERT INTO poi (id, type, world_coord, web_url) VALUES
('d03341d6-138d-4e50-865e-618b2d69c7e0', 'court', '(38.773832, -9.096356)', 'http://www.portaldasnacoes.pt/Campus-de-Justica-de-Lisboa-Contactos/'),
('0f06dd6e-86dd-461a-921f-c42f78ef1b79', 'court', '(38.732219, -9.157538)', 'http://www.cm-lisboa.pt/equipamentos/equipamento/info/palacio-da-justica-tribunal-civel-de-lisboa'),
('80396f99-71b3-4d2a-8cd8-6de37de1c5a4', 'court', '(38.714593, -9.144602)', 'http://www.stadministrativo.pt/'),
('24104d8f-2643-4b6b-9865-75711dc9a7e9', 'court', '(38.708593, -9.136480)', 'http://www.stj.pt/'),
('bb936604-a194-4876-8818-85fb9cdb7456', 'court', '(38.723819, -9.151131)', 'https://www.tribunalarbitraldesporto.pt/'),
('10065138-8983-409f-a48e-81cd62acbd86', 'court', '(38.707829, -9.138784)', 'http://www.trl.mj.pt/inicio/home.php');
INSERT INTO poi_name (id, main, lang, name) VALUES
('d03341d6-138d-4e50-865e-618b2d69c7e0', true, 'pt', 'Campus de Justiça de Lisboa'),
('d03341d6-138d-4e50-865e-618b2d69c7e0', false, 'en', 'Lisbon Justice Campus'),
('d03341d6-138d-4e50-865e-618b2d69c7e0', false, 'fr', 'Campus de la Justice à Lisbonne'),
('d03341d6-138d-4e50-865e-618b2d69c7e0', false, 'es', 'Campus de Justicia de Lisboa'),
('0f06dd6e-86dd-461a-921f-c42f78ef1b79', true, 'pt', 'Palácio da Justiça'),
('0f06dd6e-86dd-461a-921f-c42f78ef1b79', false, 'en', 'Justice Palace'),
('0f06dd6e-86dd-461a-921f-c42f78ef1b79', false, 'fr', 'Palais de Justice'),
('0f06dd6e-86dd-461a-921f-c42f78ef1b79', false, 'es', 'Palacio de la Justicia'),
('80396f99-71b3-4d2a-8cd8-6de37de1c5a4', true, 'pt', 'Supremo Tribunal Administrativo'),
('80396f99-71b3-4d2a-8cd8-6de37de1c5a4', false, 'en', 'Administrative Supreme Court'),
('80396f99-71b3-4d2a-8cd8-6de37de1c5a4', false, 'fr', 'Cour Administrative Suprême'),
('24104d8f-2643-4b6b-9865-75711dc9a7e9', true, 'pt', 'Supremo Tribunal de Justiça'),
('24104d8f-2643-4b6b-9865-75711dc9a7e9', false, 'en', 'Supreme Court of Justice'),
('24104d8f-2643-4b6b-9865-75711dc9a7e9', false, 'fr', 'Cour Suprême de Justice'),
('24104d8f-2643-4b6b-9865-75711dc9a7e9', false, 'es', 'Supremo Tribunal de Justicia'),
('bb936604-a194-4876-8818-85fb9cdb7456', true, 'pt', 'TAD - Tribunal Arbitral do Desporto'),
('bb936604-a194-4876-8818-85fb9cdb7456', false, 'en', 'Sports Arbitration Court'),
('bb936604-a194-4876-8818-85fb9cdb7456', false, 'fr', 'Cour d''Arbitrage pour le Sport'),
('bb936604-a194-4876-8818-85fb9cdb7456', false, 'es', 'Tribunal Arbitral del Deporte'),
('10065138-8983-409f-a48e-81cd62acbd86', true, 'pt', 'Tribunal da Relação de Lisboa'),
('10065138-8983-409f-a48e-81cd62acbd86', false, 'en', 'Lisbon Court of Appeal'),
('10065138-8983-409f-a48e-81cd62acbd86', false, 'fr', 'Cour d''Appel de Lisbonne'),
('10065138-8983-409f-a48e-81cd62acbd86', false, 'es', 'Tribunal de Apelación de Lisboa');
INSERT INTO poi (id, type, world_coord, web_url) VALUES
('e36bf67f-40ba-46e9-82b8-c08e06a455af', 'dinning', '(38.710663, -9.142010)', 'https://www.lisbonlux.com/lisbon-cafes/cafe-a-brasileira.html'),
('ef1ec800-be3c-45ef-8b65-047ab155fae9', 'dinning', '(38.736356, -9.134048)', 'http://www.cafeimperio.pt/'),
('5198ac3b-2f5c-42b0-8b3d-fb6159fa533c', 'dinning', '(38.715885, -9.140034)', 'http://www.casadoalentejo.com.pt/'),
('e7a7a0e0-7571-46af-8dde-3150957f807c', 'dinning', '(38.731091, -9.134680)', 'http://www.portugalia.pt/');
INSERT INTO poi_name (id, main, lang, name) VALUES
('e36bf67f-40ba-46e9-82b8-c08e06a455af', true, 'pt', 'A Brasileira'),
('e36bf67f-40ba-46e9-82b8-c08e06a455af', false, 'en', 'Café A Brasileira'),
('e36bf67f-40ba-46e9-82b8-c08e06a455af', false, 'fr', 'Café A Brasileira'),
('e36bf67f-40ba-46e9-82b8-c08e06a455af', false, 'es', 'Cafetería A Brasileira'),
('ef1ec800-be3c-45ef-8b65-047ab155fae9', true, 'pt', 'Café Império'),
('5198ac3b-2f5c-42b0-8b3d-fb6159fa533c', true, 'pt', 'Casa do Alentejo'),
('5198ac3b-2f5c-42b0-8b3d-fb6159fa533c', false, 'en', 'Casa do Alentejo Restaurant'),
('5198ac3b-2f5c-42b0-8b3d-fb6159fa533c', false, 'fr', 'Restaurant Casa do Alentejo'),
('5198ac3b-2f5c-42b0-8b3d-fb6159fa533c', false, 'es', 'Restaurante Casa do Alentejo'),
('e7a7a0e0-7571-46af-8dde-3150957f807c', true, 'pt', 'Portugália Cervejaria Almirante Reis'),
('e7a7a0e0-7571-46af-8dde-3150957f807c', false, 'en', 'Portugália Brewery'),
('e7a7a0e0-7571-46af-8dde-3150957f807c', false, 'fr', 'Brasserie Portugália'),
('e7a7a0e0-7571-46af-8dde-3150957f807c', false, 'es', 'Cervecería Portugália');
INSERT INTO poi (id, type, world_coord, web_url) VALUES
('7d5aaca3-990b-4022-a697-bf5f8415e82f', 'embassy', '(38.719447, -9.145712)', 'http://www.exteriores.gob.es/Portal/en/Paginas/inicio.aspx'),
('7070f2a1-1a1f-4612-ab95-26d813e52801', 'embassy', '(38.7103883, -9.1436105)', 'http://cglisboa.itamaraty.gov.br/pt-br/'),
('e0f525f7-62a7-48ef-ab51-d28ae33a225f', 'embassy', '(38.732742, -9.150303)', 'https://www.embaixada-africadosul.pt/index.php/en/'),
('0fe76a87-a9d9-432e-844a-97315062e913', 'embassy', '(38.7213117, -9.1408158)', 'http://www.lissabon.diplo.de/'),
('70bf0bf4-ab6a-430b-b1cd-5b8940077854', 'embassy', '(38.7444647, -9.146984)', 'http://www.embaixadadeangola.pt/'),
('fd598792-f25c-4a4e-969d-649b8de2125d', 'embassy', '(38.736856, -9.156640)', 'http://www.exteriores.gob.es/embajadas/lisboa/es/Paginas/inicio.aspx'),
('876a7879-60f5-4d7b-bcd5-3f1f413c7998', 'embassy', '(38.7367628, -9.1417021)', 'http://eport.cancilleria.gov.ar/'),
('0756332d-b4f4-4f22-95fc-63c9504e7640', 'embassy', '(38.721400, -9.146024)', 'http://portugal.embassy.gov.au/'),
('1230a84a-2767-4d47-9088-7c60e276e67e', 'embassy', '(38.731141, -9.150060)', 'http://www.embest.pt/por'),
('c5c2779f-4e61-4cc7-90d5-df5e40485e56', 'embassy', '(38.7248133, -9.1544465)', 'http://portugal.diplomatie.belgium.be/en'),
('ce5f3f97-91cc-445f-8cdd-2ac2c90392ba', 'embassy', '(38.742164, -9.164499)', 'http://lisboa.itamaraty.gov.br/pt-br/'),
('e0fb3193-9b7d-4125-b0c2-514392907adc', 'embassy', '(38.721311, -9.145855)', 'http://www.canadainternational.gc.ca/portugal/'),
('7dc944cc-4cbf-43a0-87b9-0d1613e17d04', 'embassy', '(38.7371844, -9.1445991)', 'http://www.emb-chile.pt/'),
('79452d46-dc95-431a-96ef-b416db233c3f', 'embassy', '(38.737192, -9.147396)', 'http://overseas.mofa.go.kr/pt-pt/index.do'),
('b730828b-354f-4cb2-8d58-80399340eace', 'embassy', '(38.722851, -9.148565)', 'http://www.mfa.gov.cy/mfa/embassies/embassy_lisbon.nsf/DMLindex_ol/DMLindex_ol?OpenDocument'),
('752b3e82-0039-4f34-9fff-c43a90ec03c9', 'embassy', '(38.720345, -9.149134)', 'http://portugal.um.dk/'),
('fcac7d46-1b44-4743-9634-1bf10d88e5b3', 'embassy', '(38.7441093, -9.163324)', 'https://pt.usembassy.gov/pt/'),
('d820a8d8-147d-489c-9c63-d2cc4c79dc99', 'embassy', '(38.723911, -9.136992)', 'http://www.amblisbona.esteri.it/Ambasciata_Lisbona/pt/'),
('01837454-c6eb-4aa6-8294-c61a10ef15f5', 'embassy', '(38.734572, -9.148443)', 'http://embassies.gov.il/lisboa/Pages/default.aspx'),
('a605d9f6-5a2f-4cc6-b206-7011abe86a06', 'embassy', '(38.722801, -9.148957)', 'http://www.embaixadas.net/1/12786/Paraguai-em-Lisboa'),
('f0254709-86ee-42ef-b9c4-64577298a81a', 'embassy', '(38.723747, -9.152152)', 'http://embaixadaperu.pt/'),
('75c393a8-cb7f-4ffa-bbb1-5fd600a1f4c1', 'embassy', '(38.716171, -9.157340)', 'https://www.gov.uk/world/organisations/british-embassy-lisbon.pt'),
('986bdfa2-71d5-47d3-9d0d-8aad97a3d670', 'embassy', '(38.734552, -9.138841)', 'http://www.embrussia.ru/'),
('8e592b8b-f8b3-4f8e-9a6e-80e172f16f93', 'embassy', '(38.727832, -9.145276)', 'http://portugal.embajada.gob.ve/');
INSERT INTO poi_name (id, main, lang, name) VALUES
('7d5aaca3-990b-4022-a697-bf5f8415e82f', true, 'pt', 'Consulado de Espanha'),
('7d5aaca3-990b-4022-a697-bf5f8415e82f', false, 'en', 'Consulate of Spain'),
('7d5aaca3-990b-4022-a697-bf5f8415e82f', false, 'fr', 'Consulat d''Espagne'),
('7d5aaca3-990b-4022-a697-bf5f8415e82f', false, 'es', 'Consulado de España'),
('7070f2a1-1a1f-4612-ab95-26d813e52801', true, 'pt', 'Consulado Geral do Brasil'),
('7070f2a1-1a1f-4612-ab95-26d813e52801', false, 'en', 'Consulate General of Brazil'),
('7070f2a1-1a1f-4612-ab95-26d813e52801', false, 'fr', 'Consulat Général du Brésil'),
('7070f2a1-1a1f-4612-ab95-26d813e52801', false, 'es', 'Consulado General de Brasil'),
('e0f525f7-62a7-48ef-ab51-d28ae33a225f', true, 'pt', 'Embaixada da África do Sul'),
('e0f525f7-62a7-48ef-ab51-d28ae33a225f', false, 'en', 'Embassy of South Africa'),
('e0f525f7-62a7-48ef-ab51-d28ae33a225f', false, 'fr', 'Ambassade d''Afrique du Sud'),
('e0f525f7-62a7-48ef-ab51-d28ae33a225f', false, 'es', 'Embajada de la Sudáfrica'),
('0fe76a87-a9d9-432e-844a-97315062e913', true, 'pt', 'Embaixada da Alemanha'),
('0fe76a87-a9d9-432e-844a-97315062e913', false, 'en', 'Embassy of Germany'),
('0fe76a87-a9d9-432e-844a-97315062e913', false, 'fr', 'Ambassade d''Allemagne'),
('0fe76a87-a9d9-432e-844a-97315062e913', false, 'es', 'Embajada de Alemania'),
('70bf0bf4-ab6a-430b-b1cd-5b8940077854', true, 'pt', 'Embaixada de Angola'),
('70bf0bf4-ab6a-430b-b1cd-5b8940077854', false, 'en', 'Embassy of Angola'),
('70bf0bf4-ab6a-430b-b1cd-5b8940077854', false, 'fr', 'Ambassade d''Angola'),
('70bf0bf4-ab6a-430b-b1cd-5b8940077854', false, 'es', 'Embajada de Angola'),
('876a7879-60f5-4d7b-bcd5-3f1f413c7998', true, 'pt', 'Embaixada da Argentina'),
('876a7879-60f5-4d7b-bcd5-3f1f413c7998', false, 'en', 'Embassy of Argentina'),
('876a7879-60f5-4d7b-bcd5-3f1f413c7998', false, 'fr', 'Ambassade d''Argentine'),
('876a7879-60f5-4d7b-bcd5-3f1f413c7998', false, 'es', 'Embajada de la Argentina'),
('0756332d-b4f4-4f22-95fc-63c9504e7640', true, 'pt', 'Embaixada da Austrália'),
('0756332d-b4f4-4f22-95fc-63c9504e7640', false, 'en', 'Embassy of Australia'),
('0756332d-b4f4-4f22-95fc-63c9504e7640', false, 'fr', 'Ambassade de l''Australie'),
('0756332d-b4f4-4f22-95fc-63c9504e7640', false, 'es', 'Embajada de Australia'),
('c5c2779f-4e61-4cc7-90d5-df5e40485e56', true, 'pt', 'Embaixada da Bélgica'),
('c5c2779f-4e61-4cc7-90d5-df5e40485e56', false, 'en', 'Embassy of Belgium'),
('c5c2779f-4e61-4cc7-90d5-df5e40485e56', false, 'fr', 'Ambassade de Belgique'),
('c5c2779f-4e61-4cc7-90d5-df5e40485e56', false, 'es', 'Embajada de la Bélgica'),
('ce5f3f97-91cc-445f-8cdd-2ac2c90392ba', true, 'pt', 'Embaixada do Brasil'),
('ce5f3f97-91cc-445f-8cdd-2ac2c90392ba', false, 'en', 'Embassy of Brazil'),
('ce5f3f97-91cc-445f-8cdd-2ac2c90392ba', false, 'fr', 'Ambassade du Brésil'),
('ce5f3f97-91cc-445f-8cdd-2ac2c90392ba', false, 'es', 'Embajada de Brasil'),
('e0fb3193-9b7d-4125-b0c2-514392907adc', true, 'pt', 'Embaixada do Canadá'),
('e0fb3193-9b7d-4125-b0c2-514392907adc', false, 'en', 'Embassy of Canada'),
('e0fb3193-9b7d-4125-b0c2-514392907adc', false, 'fr', 'Ambassade du Canada'),
('e0fb3193-9b7d-4125-b0c2-514392907adc', false, 'es', 'Embajada de Canadá'),
('7dc944cc-4cbf-43a0-87b9-0d1613e17d04', true, 'pt', 'Embaixada do Chile'),
('7dc944cc-4cbf-43a0-87b9-0d1613e17d04', false, 'en', 'Embassy of Chile'),
('7dc944cc-4cbf-43a0-87b9-0d1613e17d04', false, 'fr', 'Ambassade du Chili'),
('7dc944cc-4cbf-43a0-87b9-0d1613e17d04', false, 'es', 'Embajada del Chile'),
('b730828b-354f-4cb2-8d58-80399340eace', true, 'pt', 'Embaixada do Chipre'),
('b730828b-354f-4cb2-8d58-80399340eace', false, 'en', 'Embassy of Cyprus'),
('b730828b-354f-4cb2-8d58-80399340eace', false, 'fr', 'Ambassade de Chypre'),
('b730828b-354f-4cb2-8d58-80399340eace', false, 'es', 'Embajada del Chipre'),
('79452d46-dc95-431a-96ef-b416db233c3f', true, 'pt', 'Embaixada da Coreia do Sul'),
('79452d46-dc95-431a-96ef-b416db233c3f', false, 'en', 'Embassy of South Korea'),
('79452d46-dc95-431a-96ef-b416db233c3f', false, 'fr', 'Ambassade de Corée du Sud'),
('79452d46-dc95-431a-96ef-b416db233c3f', false, 'es', 'Embajada de la Corea del Sur'),
('752b3e82-0039-4f34-9fff-c43a90ec03c9', true, 'pt', 'Embaixada da Dinamarca'),
('752b3e82-0039-4f34-9fff-c43a90ec03c9', false, 'en', 'Embassy of Denmark'),
('752b3e82-0039-4f34-9fff-c43a90ec03c9', false, 'fr', 'Ambassade du Danemark'),
('752b3e82-0039-4f34-9fff-c43a90ec03c9', false, 'es', 'Embajada de Dinamarca'),
('fd598792-f25c-4a4e-969d-649b8de2125d', true, 'pt', 'Embaixada de Espanha'),
('fd598792-f25c-4a4e-969d-649b8de2125d', false, 'en', 'Embassy of Spain'),
('fd598792-f25c-4a4e-969d-649b8de2125d', false, 'fr', 'Ambassade d''Espagne'),
('fd598792-f25c-4a4e-969d-649b8de2125d', false, 'es', 'Embajada de España'),
('fcac7d46-1b44-4743-9634-1bf10d88e5b3', true, 'pt', 'Embaixada dos Estados Unidos da América'),
('fcac7d46-1b44-4743-9634-1bf10d88e5b3', false, 'en', 'Embassy of the United States of America'),
('fcac7d46-1b44-4743-9634-1bf10d88e5b3', false, 'fr', 'Ambassade des États-Unis d''Amérique'),
('fcac7d46-1b44-4743-9634-1bf10d88e5b3', false, 'es', 'Embajada de los Estados Unidos de América'),
('1230a84a-2767-4d47-9088-7c60e276e67e', true, 'pt', 'Embaixada da Estónia'),
('1230a84a-2767-4d47-9088-7c60e276e67e', false, 'en', 'Embassy of Estonia'),
('1230a84a-2767-4d47-9088-7c60e276e67e', false, 'fr', 'Ambassade d''Estonie'),
('1230a84a-2767-4d47-9088-7c60e276e67e', false, 'es', 'Embajada de la Estonia'),
('d820a8d8-147d-489c-9c63-d2cc4c79dc99', true, 'pt', 'Embaixada de Itália'),
('d820a8d8-147d-489c-9c63-d2cc4c79dc99', false, 'en', 'Embassy of Italy'),
('d820a8d8-147d-489c-9c63-d2cc4c79dc99', false, 'fr', 'Ambassade d''Italie'),
('d820a8d8-147d-489c-9c63-d2cc4c79dc99', false, 'es', 'Embajada de Italia'),
('01837454-c6eb-4aa6-8294-c61a10ef15f5', true, 'pt', 'Embaixada de Israel'),
('01837454-c6eb-4aa6-8294-c61a10ef15f5', false, 'en', 'Embassy of Israel'),
('01837454-c6eb-4aa6-8294-c61a10ef15f5', false, 'fr', 'Ambassade d''Israël'),
('01837454-c6eb-4aa6-8294-c61a10ef15f5', false, 'es', 'Embajada de Israel'),
('a605d9f6-5a2f-4cc6-b206-7011abe86a06', true, 'pt', 'Embaixada do Paraguai'),
('a605d9f6-5a2f-4cc6-b206-7011abe86a06', false, 'en', 'Embassy of Paraguay'),
('a605d9f6-5a2f-4cc6-b206-7011abe86a06', false, 'fr', 'Ambassade du Paraguay'),
('a605d9f6-5a2f-4cc6-b206-7011abe86a06', false, 'es', 'Embajada del Paraguay'),
('f0254709-86ee-42ef-b9c4-64577298a81a', true, 'pt', 'Embaixada do Peru'),
('f0254709-86ee-42ef-b9c4-64577298a81a', false, 'en', 'Embassy of Peru'),
('f0254709-86ee-42ef-b9c4-64577298a81a', false, 'fr', 'Ambassade du Pérou'),
('f0254709-86ee-42ef-b9c4-64577298a81a', false, 'es', 'Embajada del Perú'),
('75c393a8-cb7f-4ffa-bbb1-5fd600a1f4c1', true, 'pt', 'Embaixada do Reino Unido'),
('75c393a8-cb7f-4ffa-bbb1-5fd600a1f4c1', false, 'en', 'Embassy of the United Kingdom'),
('75c393a8-cb7f-4ffa-bbb1-5fd600a1f4c1', false, 'fr', 'Ambassade du Royaume-Uni'),
('75c393a8-cb7f-4ffa-bbb1-5fd600a1f4c1', false, 'es', 'Embajada del Reino Unido'),
('986bdfa2-71d5-47d3-9d0d-8aad97a3d670', true, 'pt', 'Embaixada da Rússia'),
('986bdfa2-71d5-47d3-9d0d-8aad97a3d670', false, 'en', 'Embassy of the Russian Federation'),
('986bdfa2-71d5-47d3-9d0d-8aad97a3d670', false, 'fr', 'Ambassade de la Russie'),
('986bdfa2-71d5-47d3-9d0d-8aad97a3d670', false, 'es', 'Embajada de Rusia'),
('8e592b8b-f8b3-4f8e-9a6e-80e172f16f93', true, 'pt', 'Embaixada da Venezuela'),
('8e592b8b-f8b3-4f8e-9a6e-80e172f16f93', false, 'en', 'Embassy of Venezuela'),
('8e592b8b-f8b3-4f8e-9a6e-80e172f16f93', false, 'fr', 'Ambassade du Venezuela'),
('8e592b8b-f8b3-4f8e-9a6e-80e172f16f93', false, 'es', 'Embajada de la Venezuela');
INSERT INTO poi (id, type, world_coord, web_url) VALUES
('0db3e48f-a532-47b8-a020-34bd3b632eb3', 'fire-station', '(38.758374, -9.109371)', 'http://www.bombeiroscaboruivo.com/'),
('98a8ee2c-6bad-4d96-ae9c-e0c1a20bc74f', 'fire-station', '(38.725119, -9.147859)', 'http://www.bvlisbonenses.pt/'),
('dc43ce78-282f-45aa-ab66-860e3b4a4383', 'fire-station', '(38.756608, -9.140320)', 'http://www.cm-lisboa.pt/viver/seguranca/regimento-de-sapadores-bombeiros'),
('f4adc09c-55c0-4225-804d-415ac6542460', 'fire-station', '(38.733281, -9.142751)', 'http://www.cm-lisboa.pt/viver/seguranca/regimento-de-sapadores-bombeiros'),
('f765b4e9-4456-475c-b12e-3b4c5e9a7745', 'fire-station', '(38.786843, -9.177378)', 'http://www.bvodivelas.com/sitemega/email.html');
INSERT INTO poi_name (id, main, lang, name) VALUES
('0db3e48f-a532-47b8-a020-34bd3b632eb3', true, 'pt', 'Bombeiros Voluntários de Cabo Ruivo'),
('0db3e48f-a532-47b8-a020-34bd3b632eb3', false, 'en', 'Cabo Ruivo Voluntary Firemen'),
('0db3e48f-a532-47b8-a020-34bd3b632eb3', false, 'fr', 'Pompiers Volontaires de Cabo Ruivo'),
('0db3e48f-a532-47b8-a020-34bd3b632eb3', false, 'es', 'Bomberos Voluntarios de Cabo Ruivo'),
('98a8ee2c-6bad-4d96-ae9c-e0c1a20bc74f', true, 'pt', 'Bombeiros Voluntários Lisbonenses'),
('98a8ee2c-6bad-4d96-ae9c-e0c1a20bc74f', false, 'en', 'Lisbon Voluntary Fire Department'),
('98a8ee2c-6bad-4d96-ae9c-e0c1a20bc74f', false, 'fr', 'Pompiers Volontaires Lisboètes'),
('98a8ee2c-6bad-4d96-ae9c-e0c1a20bc74f', false, 'es', 'Bomberos Voluntarios Lisboetas'),
('dc43ce78-282f-45aa-ab66-860e3b4a4383', true, 'pt', 'Regimento de Sapadores Bombeiros - Quartel de Alvalade'),
('dc43ce78-282f-45aa-ab66-860e3b4a4383', false, 'en', 'Fire Brigade Regiment - Alvalade Fire Station'),
('dc43ce78-282f-45aa-ab66-860e3b4a4383', false, 'fr', 'Régiment de Sapeurs-Pompiers - Brigade d''Alvalade'),
('dc43ce78-282f-45aa-ab66-860e3b4a4383', false, 'es', 'Cuerpo de Bomberos - Cuartel de Alvalade'),
('f4adc09c-55c0-4225-804d-415ac6542460', true, 'pt', 'Regimento de Sapadores Bombeiros - Quartel Defensores de Chaves'),
('f4adc09c-55c0-4225-804d-415ac6542460', false, 'en', 'Fire Brigade Regiment - Defensores de Chaves Fire Station'),
('f4adc09c-55c0-4225-804d-415ac6542460', false, 'fr', 'Régiment de Sapeurs-Pompiers - Brigade Defensores de Chaves'),
('f4adc09c-55c0-4225-804d-415ac6542460', false, 'es', 'Regimiento de Zapadores Bomberos - Cuartel Defensores de Chaves'),
('f765b4e9-4456-475c-b12e-3b4c5e9a7745', true, 'pt', 'Bombeiros Voluntários de Odivelas'),
('f765b4e9-4456-475c-b12e-3b4c5e9a7745', false, 'en', 'Odivelas Voluntary Firemen'),
('f765b4e9-4456-475c-b12e-3b4c5e9a7745', false, 'fr', 'Pompiers Volontaires d''Odivelas'),
('f765b4e9-4456-475c-b12e-3b4c5e9a7745', false, 'es', 'Bomberos Voluntarios de Odivelas');
INSERT INTO poi (id, type, world_coord, web_url) VALUES
('89dfb58d-ef07-4873-be00-a9480e0fc280', 'government', '(38.726050, -9.139059)', 'http://academiamilitar.pt/'),
('b65ab1a8-7a45-4f2f-8948-d30c0429f1a9', 'government', '(38.770244, -9.159556)', 'https://academiaportuguesadahistoria.gov.pt/'),
('ecdadb37-1744-43d4-81ee-66a89f724997', 'government', '(38.748914, -9.139577)', 'http://www.arslvt.min-saude.pt/'),
('17e5274f-997d-4997-8a90-52c986f854aa', 'government', '(38.750246, -9.171219)', 'https://www.ama.gov.pt/'),
('d4f5fc94-9251-4618-b6aa-1574d69b2a85', 'government', '(38.722319, -9.131119)', 'https://www.acm.gov.pt/'),
('d8a11814-4005-4fb2-8dc1-71d39fa2d148', 'government', '(38.732260, -9.142074)', 'http://www.act.gov.pt/(pt-PT)/Paginas/default.aspx'),
('1d25a73c-5984-4fa7-813f-52b78b1c68dd', 'government', '(38.772753, -9.126934)', 'https://www.anac.pt/'),
('fe47c911-d950-47e4-b62e-9440113d7614', 'government', '(38.737319, -9.163065)', 'https://www.anacom.pt/'),
('267e60b8-6a8e-4210-b369-0fff62e82031', 'government', '(38.758245, -9.148109)', 'http://www.infarmed.pt/'),
('5a245bd4-ecbb-49b8-8daf-73bd2b4de6d8', 'government', '(38.722972, -9.153444)', 'http://www.asae.gov.pt/'),
('e8f25775-15e2-407f-b7c4-19703bc100b7', 'government', '(38.777744, -9.113520)', 'https://www.igeoe.pt/index.php?id=1'),
('86f59edb-6eca-48c2-a294-eddc2d995add', 'government', '(38.742935, -9.176030)', 'http://www.cpj.pt/'),
('8c1e3495-2865-4ef8-8dfe-29ee9757a4d4', 'government', '(38.721574, -9.151114)', 'http://www.ccdr-lvt.pt/pt/'),
('5fb3615a-d514-4cc0-889d-b1a90691cbb4', 'government', '(38.739659, -9.125034)', 'http://cite.gov.pt/'),
('1d429964-86ba-41b2-8d8c-efef14a3c1b7', 'government', '(38.741852, -9.149793)', 'http://www.cmvm.pt/pt/Pages/home.aspx'),
('30a49870-747f-4c22-8ec6-a370ac9e6b68', 'government', '(38.7506592, -9.1454052)', 'http://www.cnedu.pt/pt/'),
('a44bc559-4cc3-49b0-8ed0-23ccdba20f41', 'government', '(38.723343, -9.149991)', 'https://www.csm.org.pt/'),
('4cb15f31-8310-4b89-97c0-f7bae91b7841', 'government', '(38.742297, -9.132243)', 'http://www.dgadr.gov.pt'),
('9c5bd274-0b15-4b8d-ae53-2ef8df9b6174', 'government', '(38.750595, -9.148629)', 'http://www.dgv.min-agricultura.pt/portal/page/portal/DGV'),
('0b521751-c713-4d28-9735-98be8ee27a96', 'government', '(38.737571, -9.150964)', 'http://www.dgae.gov.pt/'),
('2a39d0e9-1815-4df3-97fc-afedd2bc420f', 'government', '(38.743782, -9.149030)', 'http://www.dgeg.gov.pt/'),
('94dd6387-22d6-4f63-a7c3-968d135e1a9c', 'government', '(38.735034, -9.146304)', 'http://www.dges.gov.pt/pt'),
('7d096b9e-94be-453c-adb0-75edb17ad75a', 'government', '(38.753592, -9.143706)', 'https://www.dgeste.mec.pt/'),
('936cc66d-b22d-465c-b7a9-6ce465e5d387', 'government', '(38.7363676, -9.1356928)', 'https://www.dgs.pt/'),
('acd0f2da-9b83-467e-b199-1428f350bf05', 'government', '(38.720048, -9.156186)', 'http://www.seg-social.pt/dgss-direccao-geral-da-seguranca-social'),
('75e49789-1585-418a-a119-c31a45d17f3d', 'government', '(38.720882, -9.145539)', 'http://www.egeac.pt/'),
('40cce56e-80d1-4698-9894-9607d7f5cd1c', 'government', '(38.756937, -9.112006)', 'http://www.carris.pt/'),
('a14620a8-31f7-4cc4-b8ab-69e770cdcd4c', 'government', '(38.713228, -9.124838)', 'http://www.exercito.pt/pt/quem-somos/organizacao/ceme'),
('d1bc35f9-8cae-4c4d-a6fe-8da665e9a383', 'government', '(38.737447, -9.1430641)', 'https://www.incm.pt/'),
('4deafa7c-a807-4f5f-a261-f4362b0fc219', 'government', '(38.722227, -9.131115)', 'http://www.igf.gov.pt/'),
('cbe5b2ce-f30c-40ce-b8cc-72bb931f64f5', 'government', '(38.718149, -9.157686)', 'http://www.iave.pt/'),
('af46bf3a-d14c-4dd4-849d-8074552411c8', 'government', '(38.731108, -9.144331)', 'http://www.imt-ip.pt/'),
('cc043ea5-3c3b-401c-ad9b-b4e93de05241', 'government', '(38.778446, -9.114076)', 'https://www.exercito.pt/pt/quem-somos/organizacao/ceme/cmdlog/lmpqf'),
('40828a3e-8e5a-4072-b0e0-50ce5c867dda', 'government', '(38.708075, -9.135402)', 'https://www.portugal.gov.pt/pt/gc21/area-de-governo/administracao-interna'),
('349ac28d-91bd-4752-911c-4219c0eee77b', 'government', '(38.707674, -9.137701)', 'https://www.portugal.gov.pt/pt/gc21/area-de-governo/agricultura-florestas-e-desenvolvimento-rural'),
('90cd2cf2-0b72-4362-baca-3a283d45aa04', 'government', '(38.710034, -9.144711)', 'https://www.portugal.gov.pt/pt/gc21/area-de-governo/ministro-adjunto-e-da-economia'),
('5febe8fa-5f59-49d8-a4da-580738de1c00', 'government', '(38.707845, -9.133935)', 'https://www.portugal.gov.pt/pt/gc21/area-de-governo/financas'),
('f5c0a27d-8d3d-4913-9a86-9ec242de4c3d', 'government', '(38.740583, -9.143494)', 'https://www.portugal.gov.pt/pt/gc21/area-de-governo/infraestruturas-e-da-habitacao'),
('26ce37be-4d1a-438d-94ca-da5663d8b6c1', 'government', '(38.708359, -9.137159)', 'https://www.portugal.gov.pt/pt/gc21/area-de-governo/justica'),
('35c9a963-81b4-4a52-af50-fe822e6412cc', 'government', '(38.736166, -9.144126)', 'https://www.portugal.gov.pt/pt/gc21/area-de-governo/saude'),
('7970628e-8a70-41c8-aaba-317f3543024f', 'government', '(38.7415357, -9.1379847)', 'https://www.portugal.gov.pt/pt/gc21/area-de-governo/trabalho-solidariedade-e-seguranca-social'),
('526fd868-f86c-4bb0-a7b2-b349f2d8ea6e', 'government', '(38.782724, -9.120745)', 'https://www.exercito.pt/pt/quem-somos/organizacao/ceme/cmdlog/dmt/rtransp'),
('60e50948-9055-418f-8656-d4adfe31e773', 'government', '(38.719311, -9.153493)', 'http://www.ministeriopublico.pt/'),
('b4f150af-3131-4ad9-bd04-72bb2712bc9d', 'government', '(38.720075, -9.147169)', 'https://ec.europa.eu/portugal/about-us/contact_pt'),
('2fba3aee-fa6f-458a-8609-529338e02bed', 'government', '(38.739778, -9.146759)', 'http://spms.min-saude.pt/'),
('65715c8b-ab6f-41ca-81b5-fcf283498acc', 'government', '(38.740014, -9.146751)', 'https://www.tcontas.pt/pt-pt/Pages/homepage.aspx');
INSERT INTO poi_name (id, main, lang, name) VALUES
('89dfb58d-ef07-4873-be00-a9480e0fc280', true, 'pt', 'Academia Militar - Sede'),
('89dfb58d-ef07-4873-be00-a9480e0fc280', false, 'en', 'Military Academy - Headquarters'),
('89dfb58d-ef07-4873-be00-a9480e0fc280', false, 'fr', 'Académie Militaire - Siège'),
('b65ab1a8-7a45-4f2f-8948-d30c0429f1a9', true, 'pt', 'Academia Portuguesa da História'),
('b65ab1a8-7a45-4f2f-8948-d30c0429f1a9', false, 'en', 'Portuguese Academy of History'),
('b65ab1a8-7a45-4f2f-8948-d30c0429f1a9', false, 'fr', 'Académie Portugaise d''Histoire'),
('b65ab1a8-7a45-4f2f-8948-d30c0429f1a9', false, 'es', 'Academia Portuguesa de la Historia'),
('ecdadb37-1744-43d4-81ee-66a89f724997', true, 'pt', 'ARSLVT - Administração Regional de Saúde de Lisboa e Vale do Tejo'),
('ecdadb37-1744-43d4-81ee-66a89f724997', false, 'en', 'Regional Health Administration of Lisbon and the Tagus Valley'),
('ecdadb37-1744-43d4-81ee-66a89f724997', false, 'fr', 'Administration Régionale de Santé de Lisbonne et la Vallée du Tage'),
('ecdadb37-1744-43d4-81ee-66a89f724997', false, 'es', 'Administración Regional de Salud de Lisboa y Valle del Tajo'),
('17e5274f-997d-4997-8a90-52c986f854aa', true, 'pt', 'AMA - Agência para a Modernização Administrativa'),
('17e5274f-997d-4997-8a90-52c986f854aa', false, 'en', 'Agency for Administrative Modernisation'),
('17e5274f-997d-4997-8a90-52c986f854aa', false, 'fr', 'Agence pour la Modernisation Administrative'),
('17e5274f-997d-4997-8a90-52c986f854aa', false, 'es', 'Agencia para la Modernización Administrativa'),
('d4f5fc94-9251-4618-b6aa-1574d69b2a85', true, 'pt', 'Alto Comissariado para as Migrações - Centro Nacional de Apoio a Imigrantes'),
('d4f5fc94-9251-4618-b6aa-1574d69b2a85', false, 'en', 'High Commissariat for Migrations - National Centre for Immigrant Support'),
('d4f5fc94-9251-4618-b6aa-1574d69b2a85', false, 'fr', 'Haut Commissariat pour les Migrations - Centre National de Soutien à l''Intégration des Migrants'),
('d4f5fc94-9251-4618-b6aa-1574d69b2a85', false, 'es', 'Alto Comisionado para las Migraciones - Centro Nacional de Apoyo a los Inmigrantes'),
('d8a11814-4005-4fb2-8dc1-71d39fa2d148', true, 'pt', 'ACT - Autoridade para as Condições do Trabalho'),
('d8a11814-4005-4fb2-8dc1-71d39fa2d148', false, 'en', 'Authority for Work Conditions'),
('d8a11814-4005-4fb2-8dc1-71d39fa2d148', false, 'fr', 'Autorité pour les Conditions de Travail'),
('d8a11814-4005-4fb2-8dc1-71d39fa2d148', false, 'es', 'Autoridad para las Condiciones de Trabajo'),
('1d25a73c-5984-4fa7-813f-52b78b1c68dd', true, 'pt', 'ANAC - Autoridade Nacional de Aviação Civil'),
('1d25a73c-5984-4fa7-813f-52b78b1c68dd', false, 'en', 'Portuguese Civil Aviation Authority'),
('1d25a73c-5984-4fa7-813f-52b78b1c68dd', false, 'fr', 'Autorité Portugaise d''Aviation Civile'),
('1d25a73c-5984-4fa7-813f-52b78b1c68dd', false, 'es', 'Autoridad Portuguesa de Aviación Civil'),
('fe47c911-d950-47e4-b62e-9440113d7614', true, 'pt', 'ANACOM - Autoridade Nacional de Comunicações'),
('fe47c911-d950-47e4-b62e-9440113d7614', false, 'en', 'National Communications Authority'),
('fe47c911-d950-47e4-b62e-9440113d7614', false, 'fr', 'Autorité Nationale des Communications'),
('fe47c911-d950-47e4-b62e-9440113d7614', false, 'es', 'Autoridad Nacional de Comunicaciones'),
('267e60b8-6a8e-4210-b369-0fff62e82031', true, 'pt', 'INFARMED - Autoridade Nacional do Medicamento e Produtos de Saúde'),
('267e60b8-6a8e-4210-b369-0fff62e82031', false, 'en', 'INFARMED - National Authority for Medication and Health Products'),
('267e60b8-6a8e-4210-b369-0fff62e82031', false, 'fr', 'INFARMED - Autorité Nationale du Médicament e des Produits de Santé'),
('267e60b8-6a8e-4210-b369-0fff62e82031', false, 'es', 'INFARMED - Autoridad Nacional del Medicamentos y Productos de Salud'),
('5a245bd4-ecbb-49b8-8daf-73bd2b4de6d8', true, 'pt', 'ASAE - Autoridade de Segurança Alimentar e Económica'),
('5a245bd4-ecbb-49b8-8daf-73bd2b4de6d8', false, 'en', 'Authority for Economic and Food Safety'),
('5a245bd4-ecbb-49b8-8daf-73bd2b4de6d8', false, 'fr', 'Autorité pour la Sécurité Alimentaire et Économique'),
('5a245bd4-ecbb-49b8-8daf-73bd2b4de6d8', false, 'es', 'Autoridad de Seguridad Alimentaria y Económica'),
('e8f25775-15e2-407f-b7c4-19703bc100b7', true, 'pt', 'CIGeoE - Centro de Informação Geoespacial do Exército'),
('e8f25775-15e2-407f-b7c4-19703bc100b7', false, 'en', 'Geospatial Information Centre of the Army'),
('e8f25775-15e2-407f-b7c4-19703bc100b7', false, 'fr', 'Centre d''Information Géospatiale de l''Armée'),
('e8f25775-15e2-407f-b7c4-19703bc100b7', false, 'es', 'Centro de Información Geoespacial del Ejército'),
('86f59edb-6eca-48c2-a294-eddc2d995add', true, 'pt', 'Centro Protocolar de Formação Profissional para o Sector da Justiça'),
('86f59edb-6eca-48c2-a294-eddc2d995add', false, 'en', 'Vocational Training Protocol Center for the Justice Sector'),
('86f59edb-6eca-48c2-a294-eddc2d995add', false, 'fr', 'Centre de Protocole pour la Formation Professionnelle du Secteur de la Justice'),
('86f59edb-6eca-48c2-a294-eddc2d995add', false, 'es', 'Centro Protocolario de Formación Profesional para el Sector de la Justicia'),
('8c1e3495-2865-4ef8-8dfe-29ee9757a4d4', true, 'pt', 'CCDR-LVT - Comissão de Coordenação e Desenvolvimento Regional de Lisboa e Vale do Tejo'),
('8c1e3495-2865-4ef8-8dfe-29ee9757a4d4', false, 'en', 'Lisbon and Tagus Valley Coordinating Committee for Regional Development'),
('8c1e3495-2865-4ef8-8dfe-29ee9757a4d4', false, 'fr', 'Commission de Coordination et pour le Développement Régional de Lisbonne'),
('8c1e3495-2865-4ef8-8dfe-29ee9757a4d4', false, 'es', 'Comisión de Coordinación y Desarrollo Regional de Lisboa y Valle del Tajo'),
('5fb3615a-d514-4cc0-889d-b1a90691cbb4', true, 'pt', 'CITE - Comissão para a Igualdade no Trabalho e no Emprego'),
('5fb3615a-d514-4cc0-889d-b1a90691cbb4', false, 'en', 'Commission for Equality in Labour and Employment'),
('5fb3615a-d514-4cc0-889d-b1a90691cbb4', false, 'fr', 'Commission pour l''Égalité dans le Travail et l''Emploi'),
('5fb3615a-d514-4cc0-889d-b1a90691cbb4', false, 'es', 'Comisión para la Igualdad en el Trabajo y en el Empleo'),
('1d429964-86ba-41b2-8d8c-efef14a3c1b7', true, 'pt', 'CMVM - Comissão do Mercado de Valores Mobiliários'),
('1d429964-86ba-41b2-8d8c-efef14a3c1b7', false, 'en', 'Stock Market Regulator'),
('1d429964-86ba-41b2-8d8c-efef14a3c1b7', false, 'fr', 'Commission du Marché des Valeurs Mobilières'),
('1d429964-86ba-41b2-8d8c-efef14a3c1b7', false, 'es', 'Comisión del Mercado de Valores Mobiliarios'),
('30a49870-747f-4c22-8ec6-a370ac9e6b68', true, 'pt', 'Conselho Nacional de Educação'),
('30a49870-747f-4c22-8ec6-a370ac9e6b68', false, 'en', 'National Council of Education'),
('30a49870-747f-4c22-8ec6-a370ac9e6b68', false, 'fr', 'Conseil National de l''Éducation'),
('30a49870-747f-4c22-8ec6-a370ac9e6b68', false, 'es', 'Consejo Nacional de Educación'),
('a44bc559-4cc3-49b0-8ed0-23ccdba20f41', true, 'pt', 'Conselho Superior da Magistratura'),
('a44bc559-4cc3-49b0-8ed0-23ccdba20f41', false, 'en', 'Supreme Judicial Council'),
('a44bc559-4cc3-49b0-8ed0-23ccdba20f41', false, 'fr', 'Conseil Supérieur de la Magistrature'),
('a44bc559-4cc3-49b0-8ed0-23ccdba20f41', false, 'es', 'Consejo Superior de la Magistratura'),
('4cb15f31-8310-4b89-97c0-f7bae91b7841', true, 'pt', 'DGADR - Direção-Geral de Agricultura e Desenvolvimento Rural'),
('4cb15f31-8310-4b89-97c0-f7bae91b7841', false, 'en', 'Directorate-General of Agriculture and Rural Development'),
('4cb15f31-8310-4b89-97c0-f7bae91b7841', false, 'fr', 'Direction Générale de l''Agriculture et du Développement Rural'),
('4cb15f31-8310-4b89-97c0-f7bae91b7841', false, 'es', 'Dirección General de da Agricultura y Desarrollo Rural'),
('9c5bd274-0b15-4b8d-ae53-2ef8df9b6174', true, 'pt', 'DGAV - Direção-Geral de Alimentação e Veterinária'),
('9c5bd274-0b15-4b8d-ae53-2ef8df9b6174', false, 'en', 'Directorate-General for Feeding and Veterinary'),
('9c5bd274-0b15-4b8d-ae53-2ef8df9b6174', false, 'fr', 'Direction Générale d''Alimentation et Vétérinaire'),
('9c5bd274-0b15-4b8d-ae53-2ef8df9b6174', false, 'es', 'Dirección General de Alimentación y Veterinaria'),
('0b521751-c713-4d28-9735-98be8ee27a96', true, 'pt', 'DGAE - Direção-Geral das Atividades Económicas'),
('0b521751-c713-4d28-9735-98be8ee27a96', false, 'en', 'Directorate-General of Economic Activities'),
('0b521751-c713-4d28-9735-98be8ee27a96', false, 'fr', 'Direction Générale des Activités Économiques'),
('0b521751-c713-4d28-9735-98be8ee27a96', false, 'es', 'Dirección General de las Actividades Económicas'),
('2a39d0e9-1815-4df3-97fc-afedd2bc420f', true, 'pt', 'DGEG - Direção-Geral de Energia e Geologia'),
('2a39d0e9-1815-4df3-97fc-afedd2bc420f', false, 'en', 'Directorate-General for Energy and Geology'),
('2a39d0e9-1815-4df3-97fc-afedd2bc420f', false, 'fr', 'Direction Générale de l''Énergie et de la Géologie'),
('2a39d0e9-1815-4df3-97fc-afedd2bc420f', false, 'es', 'Dirección General de Energía y Geología'),
('94dd6387-22d6-4f63-a7c3-968d135e1a9c', true, 'pt', 'DGES - Direção-Geral do Ensino Superior'),
('94dd6387-22d6-4f63-a7c3-968d135e1a9c', false, 'en', 'General Directorate of Higher Education'),
('94dd6387-22d6-4f63-a7c3-968d135e1a9c', false, 'fr', 'Direction Générale de l''Enseignement Supérieur'),
('94dd6387-22d6-4f63-a7c3-968d135e1a9c', false, 'es', 'Dirección General de la Enseñanza Superior'),
('7d096b9e-94be-453c-adb0-75edb17ad75a', true, 'pt', 'DGEstE - Direção-Geral dos Estabelecimentos Escolares'),
('7d096b9e-94be-453c-adb0-75edb17ad75a', false, 'en', 'Directorate-General of Educational Establishments'),
('7d096b9e-94be-453c-adb0-75edb17ad75a', false, 'fr', 'Direction Générale d''Établissements Scolaires'),
('7d096b9e-94be-453c-adb0-75edb17ad75a', false, 'es', 'Dirección General de las Instalaciones Sscolares'),
('936cc66d-b22d-465c-b7a9-6ce465e5d387', true, 'pt', 'DGS - Direção-Geral da Saúde'),
('936cc66d-b22d-465c-b7a9-6ce465e5d387', false, 'en', 'Directorate General of Health'),
('936cc66d-b22d-465c-b7a9-6ce465e5d387', false, 'fr', 'Direction Générale de la Santé'),
('936cc66d-b22d-465c-b7a9-6ce465e5d387', false, 'es', 'Dirección General de Salud'),
('acd0f2da-9b83-467e-b199-1428f350bf05', true, 'pt', 'DGSS - Direção-Geral da Segurança Social'),
('acd0f2da-9b83-467e-b199-1428f350bf05', false, 'en', 'Directorate General for Social Security'),
('acd0f2da-9b83-467e-b199-1428f350bf05', false, 'fr', 'Direction Générale de la Sécurité Sociale'),
('acd0f2da-9b83-467e-b199-1428f350bf05', false, 'es', 'Dirección General de la Seguridad Social'),
('75e49789-1585-418a-a119-c31a45d17f3d', true, 'pt', 'EGEAC - Empresa de Gestão de Equipamentos e Animação Cultural'),
('75e49789-1585-418a-a119-c31a45d17f3d', false, 'en', 'Cultural Entertainment and Equipments Management Company'),
('75e49789-1585-418a-a119-c31a45d17f3d', false, 'fr', 'Société de Gestion des Équipements et de l''Animation Culturelle'),
('75e49789-1585-418a-a119-c31a45d17f3d', false, 'es', 'Compañía de Gestión de Equipamientos y Animación Cultural'),
('40cce56e-80d1-4698-9894-9607d7f5cd1c', true, 'pt', 'Estação Cabo Ruivo Carris'),
('40cce56e-80d1-4698-9894-9607d7f5cd1c', false, 'en', 'Cabo Ruivo Carris Bus Park'),
('40cce56e-80d1-4698-9894-9607d7f5cd1c', false, 'fr', 'Parc de Carris de Cabo Ruivo'),
('40cce56e-80d1-4698-9894-9607d7f5cd1c', false, 'es', 'Parque de Autobuses de la Carris de Cabo Ruivo'),
('a14620a8-31f7-4cc4-b8ab-69e770cdcd4c', true, 'pt', 'Estado-Maior do Exército'),
('a14620a8-31f7-4cc4-b8ab-69e770cdcd4c', false, 'en', 'Joint Chief of Staff of the Army'),
('a14620a8-31f7-4cc4-b8ab-69e770cdcd4c', false, 'fr', 'État-Major de l''Armée'),
('a14620a8-31f7-4cc4-b8ab-69e770cdcd4c', false, 'es', 'Estado Mayor del Ejército'),
('d1bc35f9-8cae-4c4d-a6fe-8da665e9a383', true, 'pt', 'INCM - Imprensa Nacional-Casa da Moeda'),
('d1bc35f9-8cae-4c4d-a6fe-8da665e9a383', false, 'en', 'National Mint'),
('d1bc35f9-8cae-4c4d-a6fe-8da665e9a383', false, 'fr', 'Presse Nationale-Maison de la Monnaie'),
('d1bc35f9-8cae-4c4d-a6fe-8da665e9a383', false, 'es', 'Prensa Nacional-Casa de la Moneda'),
('4deafa7c-a807-4f5f-a261-f4362b0fc219', true, 'pt', 'IGF - Inspecção-Geral de Finanças'),
('4deafa7c-a807-4f5f-a261-f4362b0fc219', false, 'en', 'Inspectorate-General of Finance'),
('4deafa7c-a807-4f5f-a261-f4362b0fc219', false, 'fr', 'Inspection Générale des Finances'),
('4deafa7c-a807-4f5f-a261-f4362b0fc219', false, 'es', 'Inspección General de Finanzas'),
('cbe5b2ce-f30c-40ce-b8cc-72bb931f64f5', true, 'pt', 'IAVE - Instituto de Avaliação Educativa'),
('cbe5b2ce-f30c-40ce-b8cc-72bb931f64f5', false, 'en', 'Institute of Educational Evaluation'),
('cbe5b2ce-f30c-40ce-b8cc-72bb931f64f5', false, 'fr', 'Institut d''Évaluation Éducative'),
('cbe5b2ce-f30c-40ce-b8cc-72bb931f64f5', false, 'es', 'Instituto de Evaluación Educativa'),
('af46bf3a-d14c-4dd4-849d-8074552411c8', true, 'pt', 'IMT - Instituto da Mobilidade e dos Transportes - Direção Regional de Lisboa e Vale do Tejo'),
('af46bf3a-d14c-4dd4-849d-8074552411c8', false, 'en', 'Mobility and Transport Institute - Lisbon Regional Directorate'),
('af46bf3a-d14c-4dd4-849d-8074552411c8', false, 'fr', 'Institut pour la Mobilité et les Transports - Direction Régionale de Lisbonne'),
('af46bf3a-d14c-4dd4-849d-8074552411c8', false, 'es', 'Instituto de Movilidad y Transporte - Dirección Regional de Lisboa'),
('cc043ea5-3c3b-401c-ad9b-b4e93de05241', true, 'pt', 'LMPQF - Laboratório Militar de Produtos Químicos e Farmacêuticos'),
('cc043ea5-3c3b-401c-ad9b-b4e93de05241', false, 'en', 'Military Laboratory of Chemical and Pharmaceutical Products'),
('cc043ea5-3c3b-401c-ad9b-b4e93de05241', false, 'fr', 'Laboratoire Militaire de Produits Chimiques et Pharmaceutiques'),
('cc043ea5-3c3b-401c-ad9b-b4e93de05241', false, 'es', 'Laboratorio Militar de Productos Químicos y Farmacéuticos'),
('40828a3e-8e5a-4072-b0e0-50ce5c867dda', true, 'pt', 'Ministério da Administração Interna'),
('40828a3e-8e5a-4072-b0e0-50ce5c867dda', false, 'en', 'Ministry of the Internal Administration'),
('40828a3e-8e5a-4072-b0e0-50ce5c867dda', false, 'fr', 'Ministère de l''Intérieur'),
('40828a3e-8e5a-4072-b0e0-50ce5c867dda', false, 'es', 'Ministerio del Interior'),
('349ac28d-91bd-4752-911c-4219c0eee77b', true, 'pt', 'Ministério da Agricultura, Florestas e Desenvolvimento Rural'),
('349ac28d-91bd-4752-911c-4219c0eee77b', false, 'en', 'Ministry of Agriculture, Forests and Rural Development'),
('349ac28d-91bd-4752-911c-4219c0eee77b', false, 'fr', 'Ministère de l''Agriculture, des Forêts et du Développement Rural'),
('349ac28d-91bd-4752-911c-4219c0eee77b', false, 'es', 'Ministerio de la Agricultura, Bosques y Desarrollo Rural'),
('90cd2cf2-0b72-4362-baca-3a283d45aa04', true, 'pt', 'Ministério da Economia'),
('90cd2cf2-0b72-4362-baca-3a283d45aa04', false, 'en', 'Ministry of Economy'),
('90cd2cf2-0b72-4362-baca-3a283d45aa04', false, 'fr', 'Ministère de l''Economie'),
('90cd2cf2-0b72-4362-baca-3a283d45aa04', false, 'es', 'Ministerio de Economía'),
('5febe8fa-5f59-49d8-a4da-580738de1c00', true, 'pt', 'Ministério das Finanças'),
('5febe8fa-5f59-49d8-a4da-580738de1c00', false, 'en', 'Ministry of Finance'),
('5febe8fa-5f59-49d8-a4da-580738de1c00', false, 'fr', 'Ministère des Finances'),
('5febe8fa-5f59-49d8-a4da-580738de1c00', false, 'es', 'Ministerio de Finanzas'),
('f5c0a27d-8d3d-4913-9a86-9ec242de4c3d', true, 'pt', 'Ministério das Infraestruturas e Habitação'),
('f5c0a27d-8d3d-4913-9a86-9ec242de4c3d', false, 'en', 'Ministry of Infrastructures and Housing'),
('f5c0a27d-8d3d-4913-9a86-9ec242de4c3d', false, 'fr', 'Ministère de l''Iinfrastructures et du Logement'),
('f5c0a27d-8d3d-4913-9a86-9ec242de4c3d', false, 'es', 'Ministério de la Infraestructuras y de la Vivienda'),
('26ce37be-4d1a-438d-94ca-da5663d8b6c1', true, 'pt', 'Ministério da Justiça'),
('26ce37be-4d1a-438d-94ca-da5663d8b6c1', false, 'en', 'Ministry of Justice'),
('26ce37be-4d1a-438d-94ca-da5663d8b6c1', false, 'fr', 'Ministère de la Justice'),
('26ce37be-4d1a-438d-94ca-da5663d8b6c1', false, 'es', 'Ministério de la Justicia'),
('35c9a963-81b4-4a52-af50-fe822e6412cc', true, 'pt', 'Ministério da Saúde'),
('35c9a963-81b4-4a52-af50-fe822e6412cc', false, 'en', 'Ministry of Health'),
('35c9a963-81b4-4a52-af50-fe822e6412cc', false, 'fr', 'Ministère de la Santé'),
('35c9a963-81b4-4a52-af50-fe822e6412cc', false, 'es', 'Ministerio de Salud'),
('7970628e-8a70-41c8-aaba-317f3543024f', true, 'pt', 'Ministério do Trabalho e da Segurança Social'),
('7970628e-8a70-41c8-aaba-317f3543024f', false, 'en', 'Ministry of Labour and Social Security'),
('7970628e-8a70-41c8-aaba-317f3543024f', false, 'fr', 'Ministère du Travail et de la Securité Socialé'),
('7970628e-8a70-41c8-aaba-317f3543024f', false, 'es', 'Ministerio del Trabajo y de la Seguridad Social'),
('526fd868-f86c-4bb0-a7b2-b349f2d8ea6e', true, 'pt', 'Quartel do RALIS - Regimento de Transportes'),
('526fd868-f86c-4bb0-a7b2-b349f2d8ea6e', false, 'en', 'RALIS Barracks - Transports Regiment'),
('526fd868-f86c-4bb0-a7b2-b349f2d8ea6e', false, 'fr', 'Caserne du RALIS - Régiment des Transports'),
('526fd868-f86c-4bb0-a7b2-b349f2d8ea6e', false, 'es', 'Cuartel del RALIS - Regimento de Transportes'),
('60e50948-9055-418f-8656-d4adfe31e773', true, 'pt', 'Procuradoria-Geral da República'),
('60e50948-9055-418f-8656-d4adfe31e773', false, 'en', 'General Attorney Office'),
('60e50948-9055-418f-8656-d4adfe31e773', false, 'fr', 'Procureur Général de la République - Siège'),
('60e50948-9055-418f-8656-d4adfe31e773', false, 'es', 'Procuraduría General de la República - Sede'),
('b4f150af-3131-4ad9-bd04-72bb2712bc9d', true, 'pt', 'Representação da Comissão Europeia em Portugal'),
('b4f150af-3131-4ad9-bd04-72bb2712bc9d', false, 'en', 'European Commission Representation in Portugal'),
('b4f150af-3131-4ad9-bd04-72bb2712bc9d', false, 'fr', 'Représentation de la Commission Européenne au Portugal'),
('b4f150af-3131-4ad9-bd04-72bb2712bc9d', false, 'es', 'Representación de la Comisión Europea en Portugal'),
('2fba3aee-fa6f-458a-8609-529338e02bed', true, 'pt', 'SPMS - Serviços Partilhados do Ministério da Saúde'),
('2fba3aee-fa6f-458a-8609-529338e02bed', false, 'en', 'Shared Services of the Ministry of Health'),
('2fba3aee-fa6f-458a-8609-529338e02bed', false, 'fr', 'Services Partagés du Ministère de la Santé'),
('2fba3aee-fa6f-458a-8609-529338e02bed', false, 'es', 'Servicios Compartidos del Ministerio de la Salud'),
('65715c8b-ab6f-41ca-81b5-fcf283498acc', true, 'pt', 'Tribunal de Contas - Sede'),
('65715c8b-ab6f-41ca-81b5-fcf283498acc', false, 'en', 'Court of Auditors - Headquarters'),
('65715c8b-ab6f-41ca-81b5-fcf283498acc', false, 'fr', 'Cour des Comptes - Siège'),
('65715c8b-ab6f-41ca-81b5-fcf283498acc', false, 'es', 'Tribunal de Cuentas - Sede');
INSERT INTO poi (id, type, world_coord, web_url) VALUES
('7902b21c-4624-4373-a0f1-214ce120b917', 'health-center', '(38.749354, -9.1470045)', 'http://www.saojoaodedeus.pt/'),
('f1638313-9b9e-4952-b52a-74e659b73f75', 'health-center', '(38.712728, -9.135696)', 'http://www.clinicasaocristovao.pt/'),
('d90f0b43-49da-4ca8-8db2-b4e04522f8ee', 'health-center', '(38.764626, -9.200260)', 'https://bicsp.min-saude.pt/pt/biufs/3/30029/3114551/Pages/default.aspx'),
('1b01a2e5-cc3d-423a-a326-a1fd7c655469', 'health-center', '(38.739578, -9.169008)', 'https://bicsp.min-saude.pt/pt/biufs/3/30028/3113851/Pages/default.aspx'),
('c9117ee8-f31c-4f80-9370-d0e1671be6ad', 'health-center', '(38.7365023, -9.1313583)', 'https://bicsp.min-saude.pt/pt/biufs/3/30027/3110200/Pages/default.aspx'),
('52ae96ff-0e2e-431c-95de-40bfb1231a61', 'health-center', '(38.772204, -9.161022)', 'https://bicsp.min-saude.pt/pt/biufs/3/30028/3112100/Pages/default.aspx'),
('7729fa91-f1ae-4b12-9919-c28df6d2ea57', 'health-center', '(38.786082, -9.178749)', 'https://bicsp.min-saude.pt/pt/biufs/3/30029/3112501/Pages/default.aspx'),
('0f4bf6b8-73ef-421a-bf1f-16ab85ac0c0a', 'health-center', '(38.772510, -9.118259)', 'https://bicsp.min-saude.pt/pt/biufs/3/30027/3112700/Pages/default.aspx'),
('fe26f82b-089e-470f-a6bf-19af7362f991', 'health-center', '(38.724132, -9.134607)', 'https://bicsp.min-saude.pt/pt/biufs/3/30027/3112900/Pages/default.aspx'),
('3a8cca9b-df56-40ce-aadc-6bd62d5beae7', 'health-center', '(38.739578, -9.169008)', 'https://bicsp.min-saude.pt/pt/biufs/3/30028/3113800/Pages/default.aspx'),
('58970596-5bd0-4196-b32c-1019cfbec995', 'health-center', '(38.754827, -9.218001)', 'https://bicsp.min-saude.pt/pt/biufs/3/30014/3114272/Pages/default.aspx'),
('d63958dd-9b2a-4ee0-8148-4968a1212d68', 'health-center', '(38.717634, -9.152878)', 'https://bicsp.min-saude.pt/pt/biufs/3/30027/3114471/Pages/default.aspx'),
('e9999f03-f085-4d4b-94c3-cde7234896b1', 'health-center', '(38.716141, -9.136847)', 'https://bicsp.min-saude.pt/pt/biufs/3/30027/3111772/Pages/default.aspx'),
('1b048159-0055-4f08-a05d-14e9050c1489', 'health-center', '(38.763860, -9.209281)', 'https://bicsp.min-saude.pt/pt/biufs/3/30014/3114201/Pages/default.aspx'),
('da1e6033-7b05-4afa-a58c-91fe3aafa41c', 'health-center', '(38.760584, -9.193474)', 'https://bicsp.min-saude.pt/pt/biufs/3/30028/3111172/Pages/default.aspx'),
('b34d8615-f80a-4e29-b469-f9a80c8c2e98', 'health-center', '(38.793676, -9.177632)', 'https://bicsp.min-saude.pt/pt/biufs/3/30029/3112572/Pages/default.aspx'),
('7c77cbfb-bc7d-4040-906a-95a450c4b146', 'health-center', '(38.7365023, -9.1313583)', 'https://bicsp.min-saude.pt/pt/biufs/3/30027/3110291/Pages/default.aspx'),
('872b89d3-9bc6-45d4-8ff8-fcd35e7c961b', 'health-center', '(38.760710, -9.193620)', 'https://bicsp.min-saude.pt/pt/biufs/3/30029/3114571/Pages/default.aspx'),
('40aa5cdd-69da-48bb-a706-9e09583d23cb', 'health-center', '(38.723570, -9.131911)', 'https://bicsp.min-saude.pt/pt/biufs/3/30027/3112971/Pages/default.aspx');
INSERT INTO poi_name (id, main, lang, name) VALUES
('7902b21c-4624-4373-a0f1-214ce120b917', true, 'pt', 'Clínica de São João de Deus'),
('7902b21c-4624-4373-a0f1-214ce120b917', false, 'en', 'São João de Deus Clinic'),
('7902b21c-4624-4373-a0f1-214ce120b917', false, 'fr', 'Clinique São João de Deus'),
('f1638313-9b9e-4952-b52a-74e659b73f75', true, 'pt', 'Clínica de São Cristóvão'),
('f1638313-9b9e-4952-b52a-74e659b73f75', false, 'en', 'São Cristóvão Clinic'),
('f1638313-9b9e-4952-b52a-74e659b73f75', false, 'fr', 'Clinique de São Cristóvão'),
('d90f0b43-49da-4ca8-8db2-b4e04522f8ee', true, 'pt', 'Unidade de Cuidados na Comunidade Nostra Pontinha'),
('d90f0b43-49da-4ca8-8db2-b4e04522f8ee', false, 'en', 'Nostra Pontinha Community Care Unit'),
('d90f0b43-49da-4ca8-8db2-b4e04522f8ee', false, 'fr', 'Unité de Soins Communautaires Nostra Pontinha'),
('d90f0b43-49da-4ca8-8db2-b4e04522f8ee', false, 'es', 'Unidad de Cuidados en la Comunidad Nostra Pontinha'),
('1b01a2e5-cc3d-423a-a326-a1fd7c655469', true, 'pt', 'Unidade de Cuidados na Comunidade de Sete Rios'),
('1b01a2e5-cc3d-423a-a326-a1fd7c655469', false, 'en', 'Sete Rios Community Care Unit'),
('1b01a2e5-cc3d-423a-a326-a1fd7c655469', false, 'fr', 'Unité de Soins Communautaires de Sete Rios'),
('1b01a2e5-cc3d-423a-a326-a1fd7c655469', false, 'es', 'Unidad de Cuidados en la Comunidad de Sete Rios'),
('c9117ee8-f31c-4f80-9370-d0e1671be6ad', true, 'pt', 'Unidade de Cuidados de Saúde Personalizados da Alameda'),
('c9117ee8-f31c-4f80-9370-d0e1671be6ad', false, 'en', 'Alameda Personalized Healthcare Unit'),
('c9117ee8-f31c-4f80-9370-d0e1671be6ad', false, 'fr', 'Unité de Soins de Santé Personnalisés d''Alameda'),
('c9117ee8-f31c-4f80-9370-d0e1671be6ad', false, 'es', 'Unidad de Cuidados de Salud Personalizada de la Alameda'),
('52ae96ff-0e2e-431c-95de-40bfb1231a61', true, 'pt', 'Unidade de Cuidados de Saúde Personalizados do Lumiar'),
('52ae96ff-0e2e-431c-95de-40bfb1231a61', false, 'en', 'Lumiar Personalized Healthcare Unit'),
('52ae96ff-0e2e-431c-95de-40bfb1231a61', false, 'fr', 'Unité de Soins de Santé Personnalisés du Lumiar'),
('52ae96ff-0e2e-431c-95de-40bfb1231a61', false, 'es', 'Unidad de Cuidados de Salud Personalizada del Lumiar'),
('7729fa91-f1ae-4b12-9919-c28df6d2ea57', true, 'pt', 'Unidade de Cuidados de Saúde Personalizados do Olaio'),
('7729fa91-f1ae-4b12-9919-c28df6d2ea57', false, 'en', 'Olaio Personalized Healthcare Unit'),
('7729fa91-f1ae-4b12-9919-c28df6d2ea57', false, 'fr', 'Unité de Soins de Santé Personnalisés de''Olaio'),
('7729fa91-f1ae-4b12-9919-c28df6d2ea57', false, 'es', 'Unidad de Cuidados de Salud Personalizada del Olaio'),
('0f4bf6b8-73ef-421a-bf1f-16ab85ac0c0a', true, 'pt', 'Unidade de Cuidados de Saúde Personalizados dos Olivais'),
('0f4bf6b8-73ef-421a-bf1f-16ab85ac0c0a', false, 'en', 'Olivais Personalized Healthcare Unit'),
('0f4bf6b8-73ef-421a-bf1f-16ab85ac0c0a', false, 'fr', 'Unité de Soins de Santé Personnalisés de''Olivais'),
('0f4bf6b8-73ef-421a-bf1f-16ab85ac0c0a', false, 'es', 'Unidad de Cuidados de Salud Personalizada de los Olivais'),
('fe26f82b-089e-470f-a6bf-19af7362f991', true, 'pt', 'Unidade de Cuidados de Saúde Personalizados da Penha de França'),
('fe26f82b-089e-470f-a6bf-19af7362f991', false, 'en', 'Penha de França Personalized Healthcare Unit'),
('fe26f82b-089e-470f-a6bf-19af7362f991', false, 'fr', 'Unité de Soins de Santé Personnalisés de Penha de França'),
('fe26f82b-089e-470f-a6bf-19af7362f991', false, 'es', 'Unidad de Cuidados de Salud Personalizada de la Penha de França'),
('3a8cca9b-df56-40ce-aadc-6bd62d5beae7', true, 'pt', 'Unidade de Cuidados de Saúde Personalizados de Sete Rios'),
('3a8cca9b-df56-40ce-aadc-6bd62d5beae7', false, 'en', 'Sete Rios Personalized Healthcare Unit'),
('3a8cca9b-df56-40ce-aadc-6bd62d5beae7', false, 'fr', 'Unité de Soins de Santé Personnalisés de Sete Rios'),
('3a8cca9b-df56-40ce-aadc-6bd62d5beae7', false, 'es', 'Unidad de Cuidados de Salud Personalizada de Sete Rios'),
('58970596-5bd0-4196-b32c-1019cfbec995', true, 'pt', 'Unidade de Saúde Familiar Amato Lusitano'),
('58970596-5bd0-4196-b32c-1019cfbec995', false, 'en', 'Amato Lusitano Family Health Unit'),
('58970596-5bd0-4196-b32c-1019cfbec995', false, 'fr', 'Unité de Santé Familiale Amato Lusitano'),
('58970596-5bd0-4196-b32c-1019cfbec995', false, 'es', 'Unidad de Salud Familiar Amato Lusitano'),
('d63958dd-9b2a-4ee0-8148-4968a1212d68', true, 'pt', 'Unidade de Saúde Familiar do Arco'),
('d63958dd-9b2a-4ee0-8148-4968a1212d68', false, 'en', 'Arco Family Health Unit'),
('d63958dd-9b2a-4ee0-8148-4968a1212d68', false, 'fr', 'Unité de Santé Familiale d''Arco'),
('d63958dd-9b2a-4ee0-8148-4968a1212d68', false, 'es', 'Unidad de Salud Familiar del Arco'),
('e9999f03-f085-4d4b-94c3-cde7234896b1', true, 'pt', 'Unidade de Saúde Familiar da Baixa'),
('e9999f03-f085-4d4b-94c3-cde7234896b1', false, 'en', 'Baixa Family Health Unit'),
('e9999f03-f085-4d4b-94c3-cde7234896b1', false, 'fr', 'Unité de Santé Familiale de la Baixa'),
('e9999f03-f085-4d4b-94c3-cde7234896b1', false, 'es', 'Unidad de Salud Familiar de la Baixa'),
('1b048159-0055-4f08-a05d-14e9050c1489', true, 'pt', 'Unidade de Saúde Familiar da Brandoa'),
('1b048159-0055-4f08-a05d-14e9050c1489', false, 'en', 'Brandoa Family Health Unit'),
('1b048159-0055-4f08-a05d-14e9050c1489', false, 'fr', 'Unité de Santé Familiale de la Brandoa'),
('1b048159-0055-4f08-a05d-14e9050c1489', false, 'es', 'Unidad de Salud Familiar de la Brandoa'),
('da1e6033-7b05-4afa-a58c-91fe3aafa41c', true, 'pt', 'Unidade de Saúde Familiar Carnide Quer'),
('da1e6033-7b05-4afa-a58c-91fe3aafa41c', false, 'en', 'Carnide Quer Family Health Unit'),
('da1e6033-7b05-4afa-a58c-91fe3aafa41c', false, 'fr', 'Unité de Santé Familiale Carnide Quer'),
('da1e6033-7b05-4afa-a58c-91fe3aafa41c', false, 'es', 'Unidad de Salud Familiar Carnide Quer'),
('b34d8615-f80a-4e29-b469-f9a80c8c2e98', true, 'pt', 'Unidade de Saúde Familiar do Cruzeiro'),
('b34d8615-f80a-4e29-b469-f9a80c8c2e98', false, 'en', 'Cruzeiro Family Health Unit'),
('b34d8615-f80a-4e29-b469-f9a80c8c2e98', false, 'fr', 'Unité de Santé Familiale du Cruzeiro'),
('b34d8615-f80a-4e29-b469-f9a80c8c2e98', false, 'es', 'Unidad de Salud Familiar del Cruzeiro'),