API tools faq
paste
Advertisement
Guest User

Extractor All in One

a guest
Aug 9th, 2016
188
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 31.42 KB | None | 0 0
raw download clone embed print report
  1. CREATE TABLE "pokemon_info" ("pokemon_id" INTEGER NOT NULL PRIMARY KEY, "pokemon_name_en" VARCHAR(255) NOT NULL, "pokemon_name_fr" VARCHAR(255) NOT NULL, "pokemon_rarity" VARCHAR(255) NOT NULL, "pokemon_spawn_rate" INTEGER NOT NULL);
  2.  
  3. INSERT INTO pokemon_info VALUES (1,"Bulbasaur","Bulbizarre","Uncommon",61);
  4. INSERT INTO pokemon_info VALUES (2,"Ivysaur","Herbizarre","Rare",421);
  5. INSERT INTO pokemon_info VALUES (3,"Venusaur","Florizarre","Very Rare",641);
  6. INSERT INTO pokemon_info VALUES (4,"Charmander","Salamèche","Rare",119);
  7. INSERT INTO pokemon_info VALUES (5,"Charmeleon","Reptincel","Very Rare",1025);
  8. INSERT INTO pokemon_info VALUES (6,"Charizard","Dracaufeu","Very Rare",879);
  9. INSERT INTO pokemon_info VALUES (7,"Squirtle","Carapuce","Uncommon",65);
  10. INSERT INTO pokemon_info VALUES (8,"Wartortle","Carabaffe","Rare",484);
  11. INSERT INTO pokemon_info VALUES (9,"Blastoise","Tortank","Very Rare",843);
  12. INSERT INTO pokemon_info VALUES (10,"Caterpie","Chenipan","Uncommon",51);
  13. INSERT INTO pokemon_info VALUES (11,"Metapod","Chrysacier","Rare",433);
  14. INSERT INTO pokemon_info VALUES (12,"Butterfree","Papilusion","Very Rare",843);
  15. INSERT INTO pokemon_info VALUES (13,"Weedle","Aspicot","Common",21);
  16. INSERT INTO pokemon_info VALUES (14,"Kakuna","Coconfort","Rare",204);
  17. INSERT INTO pokemon_info VALUES (15,"Beedrill","Dardargnan","Rare",377);
  18. INSERT INTO pokemon_info VALUES (16,"Pidgey","Roucool","Common",10);
  19. INSERT INTO pokemon_info VALUES (17,"Pidgeotto","Roucoups","Uncommon",75);
  20. INSERT INTO pokemon_info VALUES (18,"Pidgeot","Roucarnage","Rare",203);
  21. INSERT INTO pokemon_info VALUES (19,"Rattata","Rattata","Common",13);
  22. INSERT INTO pokemon_info VALUES (20,"Raticate","Rattatac","Rare",159);
  23. INSERT INTO pokemon_info VALUES (21,"Spearow","Piafabec","Uncommon",31);
  24. INSERT INTO pokemon_info VALUES (22,"Fearow","Rapasdepic","Rare",221);
  25. INSERT INTO pokemon_info VALUES (23,"Ekans","Abo","Uncommon",75);
  26. INSERT INTO pokemon_info VALUES (24,"Arbok","Arbok","Very Rare",544);
  27. INSERT INTO pokemon_info VALUES (25,"Pikachu","Pikachu","Uncommon",92);
  28. INSERT INTO pokemon_info VALUES (26,"Raichu","Raichu","Ultra Rare",2051);
  29. INSERT INTO pokemon_info VALUES (27,"Sandshrew","Sabelette","Rare",163);
  30. INSERT INTO pokemon_info VALUES (28,"Sandslash","Sablaireau","Ultra Rare",1619);
  31. INSERT INTO pokemon_info VALUES (29,"Nidoran Female","Nidoran Femelle","Uncommon",77);
  32. INSERT INTO pokemon_info VALUES (30,"Nidorina","Nidorina","Very Rare",504);
  33. INSERT INTO pokemon_info VALUES (31,"Nidoqueen","Nidoqueen","Very Rare",1398);
  34. INSERT INTO pokemon_info VALUES (32,"Nidoran Male","Nidoran Male","Uncommon",77);
  35. INSERT INTO pokemon_info VALUES (33,"Nidorino","Nidorino","Very Rare",586);
  36. INSERT INTO pokemon_info VALUES (34,"Nidoking","Nidoking","Very Rare",1025);
  37. INSERT INTO pokemon_info VALUES (35,"Clefairy","Mélofée","Uncommon",85);
  38. INSERT INTO pokemon_info VALUES (36,"Clefable","Mélodelfe","Very Rare",1309);
  39. INSERT INTO pokemon_info VALUES (37,"Vulpix","Goupix","Rare",188);
  40. INSERT INTO pokemon_info VALUES (38,"Ninetales","Feunard","Ultra Rare",1538);
  41. INSERT INTO pokemon_info VALUES (39,"Jigglypuff","Rondoudou","Rare",101);
  42. INSERT INTO pokemon_info VALUES (40,"Wigglytuff","Grodoudou","Ultra Rare",2051);
  43. INSERT INTO pokemon_info VALUES (41,"Zubat","Nosferapti","Common",24);
  44. INSERT INTO pokemon_info VALUES (42,"Golbat","Nosferalto","Rare",209);
  45. INSERT INTO pokemon_info VALUES (43,"Oddish","Mystherbe","Uncommon",91);
  46. INSERT INTO pokemon_info VALUES (44,"Gloom","Ortide","Very Rare",592);
  47. INSERT INTO pokemon_info VALUES (45,"Vileplume","Rafflesia","Ultra Rare",1864);
  48. INSERT INTO pokemon_info VALUES (46,"Paras","Paras","Uncommon",44);
  49. INSERT INTO pokemon_info VALUES (47,"Parasect","Parasect","Rare",397);
  50. INSERT INTO pokemon_info VALUES (48,"Venonat","Mimitoss","Uncommon",38);
  51. INSERT INTO pokemon_info VALUES (49,"Venomoth","Aéromite","Rare",300);
  52. INSERT INTO pokemon_info VALUES (50,"Diglett","Taupiqueur","Rare",211);
  53. INSERT INTO pokemon_info VALUES (51,"Dugtrio","Triopikeur","Ultra Rare",1663);
  54. INSERT INTO pokemon_info VALUES (52,"Meowth","Miaouss","Rare",106);
  55. INSERT INTO pokemon_info VALUES (53,"Persian","Persian","Very Rare",1282);
  56. INSERT INTO pokemon_info VALUES (54,"Psyduck","Psykokwak","Rare",108);
  57. INSERT INTO pokemon_info VALUES (55,"Golduck","Akwakwak","Very Rare",707);
  58. INSERT INTO pokemon_info VALUES (56,"Mankey","Férosinge","Rare",114);
  59. INSERT INTO pokemon_info VALUES (57,"Primeape","Colossinge","Very Rare",1061);
  60. INSERT INTO pokemon_info VALUES (58,"Growlithe","Caninos","Uncommon",77);
  61. INSERT INTO pokemon_info VALUES (59,"Arcanine","Arcanin","Very Rare",932);
  62. INSERT INTO pokemon_info VALUES (60,"Poliwag","Ptitard","Uncommon",95);
  63. INSERT INTO pokemon_info VALUES (61,"Poliwhirl","Têtarte","Rare",481);
  64. INSERT INTO pokemon_info VALUES (62,"Poliwrath","Tartard","Ultra Rare",1709);
  65. INSERT INTO pokemon_info VALUES (63,"Abra","Abra","Rare",104);
  66. INSERT INTO pokemon_info VALUES (64,"Kadabra","Kadabra","Very Rare",779);
  67. INSERT INTO pokemon_info VALUES (65,"Alakazam","Alakazam","Ultra Rare",2461);
  68. INSERT INTO pokemon_info VALUES (66,"Machop","Machoc","Rare",217);
  69. INSERT INTO pokemon_info VALUES (67,"Machoke","Machopeur","Very Rare",1465);
  70. INSERT INTO pokemon_info VALUES (68,"Machamp","Mackogneur","Ultra Rare",3418);
  71. INSERT INTO pokemon_info VALUES (69,"Bellsprout","Chétiflor","Uncommon",86);
  72. INSERT INTO pokemon_info VALUES (70,"Weepinbell","Boustiflor","Rare",496);
  73. INSERT INTO pokemon_info VALUES (71,"Victreebel","Empiflor","Ultra Rare",2051);
  74. INSERT INTO pokemon_info VALUES (72,"Tentacool","Tentacool","Rare",275);
  75. INSERT INTO pokemon_info VALUES (73,"Tentacruel","Tentacruel","Very Rare",615);
  76. INSERT INTO pokemon_info VALUES (74,"Geodude","Racaillou","Rare",121);
  77. INSERT INTO pokemon_info VALUES (75,"Graveler","Gravalanch","Very Rare",707);
  78. INSERT INTO pokemon_info VALUES (76,"Golem","Grolem","Ultra Rare",2797);
  79. INSERT INTO pokemon_info VALUES (77,"Ponyta","Ponyta","Rare",121);
  80. INSERT INTO pokemon_info VALUES (78,"Rapidash","Galopa","Very Rare",992);
  81. INSERT INTO pokemon_info VALUES (79,"Slowpoke","Ramoloss","Rare",175);
  82. INSERT INTO pokemon_info VALUES (80,"Slowbro","Flagadoss","Very Rare",947);
  83. INSERT INTO pokemon_info VALUES (81,"Magnemite","Magnéti","Rare",200);
  84. INSERT INTO pokemon_info VALUES (82,"Magneton","Magnéton","Ultra Rare",2051);
  85. INSERT INTO pokemon_info VALUES (83,"Farfetch'd","Canarticho","Ultra Rare",61527);
  86. INSERT INTO pokemon_info VALUES (84,"Doduo","Doduo","Uncommon",77);
  87. INSERT INTO pokemon_info VALUES (85,"Dodrio","Dodrio","Very Rare",634);
  88. INSERT INTO pokemon_info VALUES (86,"Seel","Otaria","Rare",196);
  89. INSERT INTO pokemon_info VALUES (87,"Dewgong","Lamantine","Ultra Rare",1578);
  90. INSERT INTO pokemon_info VALUES (88,"Grimer","Tadmorv","Very Rare",879);
  91. INSERT INTO pokemon_info VALUES (89,"Muk","Grotadmorv","Ultra Rare",7691);
  92. INSERT INTO pokemon_info VALUES (90,"Shellder","Kokiyas","Rare",177);
  93. INSERT INTO pokemon_info VALUES (91,"Cloyster","Crustabri","Ultra Rare",1578);
  94. INSERT INTO pokemon_info VALUES (92,"Gastly","Fantominus","Uncommon",77);
  95. INSERT INTO pokemon_info VALUES (93,"Haunter","Spectrum","Rare",419);
  96. INSERT INTO pokemon_info VALUES (94,"Gengar","Ectoplasma","Ultra Rare",1758);
  97. INSERT INTO pokemon_info VALUES (95,"Onix","Onix","Rare",269);
  98. INSERT INTO pokemon_info VALUES (96,"Drowzee","Soporifik","Uncommon",39);
  99. INSERT INTO pokemon_info VALUES (97,"Hypno","Hypnomade","Rare",322);
  100. INSERT INTO pokemon_info VALUES (98,"Krabby","Krabby","Uncommon",73);
  101. INSERT INTO pokemon_info VALUES (99,"Kingler","Krabboss","Very Rare",530);
  102. INSERT INTO pokemon_info VALUES (100,"Voltorb","Voltorbe","Rare",276);
  103. INSERT INTO pokemon_info VALUES (101,"Electrode","Electrode","Ultra Rare",1985);
  104. INSERT INTO pokemon_info VALUES (102,"Exeggcute","Noeunoeuf","Rare",123);
  105. INSERT INTO pokemon_info VALUES (103,"Exeggutor","Noadkoko","Very Rare",1231);
  106. INSERT INTO pokemon_info VALUES (104,"Cubone","Osselait","Rare",163);
  107. INSERT INTO pokemon_info VALUES (105,"Marowak","Ossatueur","Very Rare",1431);
  108. INSERT INTO pokemon_info VALUES (106,"Hitmonlee","Kicklee","Very Rare",504);
  109. INSERT INTO pokemon_info VALUES (107,"Hitmonchan","Tygnon","Rare",446);
  110. INSERT INTO pokemon_info VALUES (108,"Lickitung","Excelangue","Rare",443);
  111. INSERT INTO pokemon_info VALUES (109,"Koffing","Smogo","Rare",213);
  112. INSERT INTO pokemon_info VALUES (110,"Weezing","Smogogo","Very Rare",1398);
  113. INSERT INTO pokemon_info VALUES (111,"Rhyhorn","Rhinocorne","Rare",110);
  114. INSERT INTO pokemon_info VALUES (112,"Rhydon","Rhinoféros","Very Rare",867);
  115. INSERT INTO pokemon_info VALUES (113,"Chansey","Leveinard","Very Rare",1256);
  116. INSERT INTO pokemon_info VALUES (114,"Tangela","Saquedeneu","Rare",346);
  117. INSERT INTO pokemon_info VALUES (115,"Kangaskhan","Kanougrex","Ultra Rare",2461);
  118. INSERT INTO pokemon_info VALUES (116,"Horsea","Hypotrempe","Rare",104);
  119. INSERT INTO pokemon_info VALUES (117,"Seadra","Hypocéan","Very Rare",760);
  120. INSERT INTO pokemon_info VALUES (118,"Goldeen","Poissirène","Rare",103);
  121. INSERT INTO pokemon_info VALUES (119,"Seaking","Poissoroy","Very Rare",684);
  122. INSERT INTO pokemon_info VALUES (120,"Staryu","Stari","Uncommon",97);
  123. INSERT INTO pokemon_info VALUES (121,"Starmie","Staross","Very Rare",1206);
  124. INSERT INTO pokemon_info VALUES (122,"Mr. Mime","M.Mime","Very Rare",1431);
  125. INSERT INTO pokemon_info VALUES (123,"Scyther","Insécateur","Rare",155);
  126. INSERT INTO pokemon_info VALUES (124,"Jynx","Lippoutou","Rare",152);
  127. INSERT INTO pokemon_info VALUES (125,"Electabuzz","Elektek","Rare",261);
  128. INSERT INTO pokemon_info VALUES (126,"Magmar","Magmar","Rare",213);
  129. INSERT INTO pokemon_info VALUES (127,"Pinsir","Scarabrute","Uncommon",99);
  130. INSERT INTO pokemon_info VALUES (128,"Tauros","Tauros","Rare",153);
  131. INSERT INTO pokemon_info VALUES (129,"Magikarp","Magicarpe","Uncommon",79);
  132. INSERT INTO pokemon_info VALUES (130,"Gyarados","Leviator","Ultra Rare",2279);
  133. INSERT INTO pokemon_info VALUES (131,"Lapras","Lokhlass","Very Rare",1183);
  134. INSERT INTO pokemon_info VALUES (132,"Ditto","Métamorph","Ultra Rare",30764);
  135. INSERT INTO pokemon_info VALUES (133,"Eevee","Evoli","Common",24);
  136. INSERT INTO pokemon_info VALUES (134,"Vaporeon","Aquali","Very Rare",1465);
  137. INSERT INTO pokemon_info VALUES (135,"Jolteon","Voltali","Very Rare",1309);
  138. INSERT INTO pokemon_info VALUES (136,"Flareon","Pyroli","Ultra Rare",1568);
  139. INSERT INTO pokemon_info VALUES (137,"Porygon","Porygon","Very Rare",867);
  140. INSERT INTO pokemon_info VALUES (138,"Omanyte","Amonita","Rare",346);
  141. INSERT INTO pokemon_info VALUES (139,"Omastar","Amonistar","Ultra Rare",6153);
  142. INSERT INTO pokemon_info VALUES (140,"Kabuto","Kabuto","Rare",356);
  143. INSERT INTO pokemon_info VALUES (141,"Kabutops","Kabutops","Ultra Rare",2930);
  144. INSERT INTO pokemon_info VALUES (142,"Aerodactyl","Ptéra","Very Rare",879);
  145. INSERT INTO pokemon_info VALUES (143,"Snorlax","Ronflex","Rare",284);
  146. INSERT INTO pokemon_info VALUES (144,"Articuno","Artikodin","Ultra Rare",99999);
  147. INSERT INTO pokemon_info VALUES (145,"Zapdos","Electhor","Ultra Rare",99999);
  148. INSERT INTO pokemon_info VALUES (146,"Moltres","Sulfura","Ultra Rare",99999);
  149. INSERT INTO pokemon_info VALUES (147,"Dratini","Minidraco","Uncommon",91);
  150. INSERT INTO pokemon_info VALUES (148,"Dragonair","Draco","Very Rare",699);
  151. INSERT INTO pokemon_info VALUES (149,"Dragonite","Dracolosse","Very Rare",580);
  152. INSERT INTO pokemon_info VALUES (150,"Mewtwo","Mewtwo","Ultra Rare",99999);
  153. INSERT INTO pokemon_info VALUES (151,"Mew","Mew","Ultra Rare",99999);
  154.  
  155. SELECT KML FROM
  156. (SELECT '<?xml version="1.0" encoding="UTF-8"?>
  157. <kml xmlns="http://www.opengis.net/kml/2.2">
  158.  <Document>
  159.    <name>PokemonSpawnTimes</name>
  160.    <open>1</open>
  161.    <description>Pokemon Spawn Times</description>
  162.    <Folder>
  163.      <name>Pokemon Spawn (Expiration Minutes:Seconds)</name>
  164.      <description>Pokemon Spawn (Expiration Minutes:Seconds)</description>' AS KML, 1 AS Id
  165. UNION
  166. SELECT KML, 2 AS Id FROM (SELECT '      <Placemark>
  167.        <name>'||SUBSTR(disappear_time, 15, 5) || ' (' || COUNT(1) || ') ' || GROUP_CONCAT(DISTINCT(pi.pokemon_name_en))||'</name>
  168.        <description>'||SUBSTR(disappear_time, 15, 5) || ' (' || COUNT(1) || ') ' || GROUP_CONCAT(DISTINCT(pi.pokemon_name_en))||'</description>
  169.        <styleUrl>#Icon'||CASE(COUNT(1)) WHEN 1 THEN p.pokemon_id ELSE (SELECT pokemon_id FROM pokemon_info WHERE pokemon_id IN (SELECT pokemon_id FROM pokemon WHERE latitude = p.latitude AND longitude = p.longitude) ORDER BY pokemon_spawn_rate DESC LIMIT 1) END||'</styleUrl>
  170.        <Point>
  171.          <coordinates>'||longitude||','||latitude||',0</coordinates>
  172.        </Point>
  173.      </Placemark>' AS KML
  174. FROM pokemon p
  175. INNER JOIN pokemon_info pi
  176. ON pi.pokemon_id = p.pokemon_id
  177. WHERE p.pokemon_id IN (SELECT pokemon_id FROM pokemon_info WHERE pokemon_spawn_rate >= 24)
  178. GROUP BY p.latitude, p.longitude, SUBSTR(disappear_time, 15, 5)
  179. ORDER BY SUBSTR(disappear_time, 15, 5) || ' (' || COUNT(1) || ') ' || GROUP_CONCAT(DISTINCT(pi.pokemon_name_en)) ASC)
  180. UNION
  181. SELECT '</Folder>
  182.     <Style id="Icon1">
  183.      <IconStyle><Icon><href>https://pokemaps.eu/icons/1.png</href></Icon></IconStyle>
  184.    </Style>
  185.     <Style id="Icon2">
  186.      <IconStyle><Icon><href>https://pokemaps.eu/icons/2.png</href></Icon></IconStyle>
  187.    </Style>
  188.     <Style id="Icon3">
  189.      <IconStyle><Icon><href>https://pokemaps.eu/icons/3.png</href></Icon></IconStyle>
  190.    </Style>
  191.     <Style id="Icon4">
  192.      <IconStyle><Icon><href>https://pokemaps.eu/icons/4.png</href></Icon></IconStyle>
  193.    </Style>
  194.     <Style id="Icon5">
  195.      <IconStyle><Icon><href>https://pokemaps.eu/icons/5.png</href></Icon></IconStyle>
  196.    </Style>
  197.     <Style id="Icon6">
  198.      <IconStyle><Icon><href>https://pokemaps.eu/icons/6.png</href></Icon></IconStyle>
  199.    </Style>
  200.     <Style id="Icon7">
  201.      <IconStyle><Icon><href>https://pokemaps.eu/icons/7.png</href></Icon></IconStyle>
  202.    </Style>
  203.     <Style id="Icon8">
  204.      <IconStyle><Icon><href>https://pokemaps.eu/icons/8.png</href></Icon></IconStyle>
  205.    </Style>
  206.     <Style id="Icon9">
  207.      <IconStyle><Icon><href>https://pokemaps.eu/icons/9.png</href></Icon></IconStyle>
  208.    </Style>
  209.     <Style id="Icon10">
  210.      <IconStyle><Icon><href>https://pokemaps.eu/icons/10.png</href></Icon></IconStyle>
  211.    </Style>
  212.     <Style id="Icon11">
  213.      <IconStyle><Icon><href>https://pokemaps.eu/icons/11.png</href></Icon></IconStyle>
  214.    </Style>
  215.     <Style id="Icon12">
  216.      <IconStyle><Icon><href>https://pokemaps.eu/icons/12.png</href></Icon></IconStyle>
  217.    </Style>
  218.     <Style id="Icon13">
  219.      <IconStyle><Icon><href>https://pokemaps.eu/icons/13.png</href></Icon></IconStyle>
  220.    </Style>
  221.     <Style id="Icon14">
  222.      <IconStyle><Icon><href>https://pokemaps.eu/icons/14.png</href></Icon></IconStyle>
  223.    </Style>
  224.     <Style id="Icon15">
  225.      <IconStyle><Icon><href>https://pokemaps.eu/icons/15.png</href></Icon></IconStyle>
  226.    </Style>
  227.     <Style id="Icon16">
  228.      <IconStyle><Icon><href>https://pokemaps.eu/icons/16.png</href></Icon></IconStyle>
  229.    </Style>
  230.     <Style id="Icon17">
  231.      <IconStyle><Icon><href>https://pokemaps.eu/icons/17.png</href></Icon></IconStyle>
  232.    </Style>
  233.     <Style id="Icon18">
  234.      <IconStyle><Icon><href>https://pokemaps.eu/icons/18.png</href></Icon></IconStyle>
  235.    </Style>
  236.     <Style id="Icon19">
  237.      <IconStyle><Icon><href>https://pokemaps.eu/icons/19.png</href></Icon></IconStyle>
  238.    </Style>
  239.     <Style id="Icon20">
  240.      <IconStyle><Icon><href>https://pokemaps.eu/icons/20.png</href></Icon></IconStyle>
  241.    </Style>
  242.     <Style id="Icon21">
  243.      <IconStyle><Icon><href>https://pokemaps.eu/icons/21.png</href></Icon></IconStyle>
  244.    </Style>
  245.     <Style id="Icon22">
  246.      <IconStyle><Icon><href>https://pokemaps.eu/icons/22.png</href></Icon></IconStyle>
  247.    </Style>
  248.     <Style id="Icon23">
  249.      <IconStyle><Icon><href>https://pokemaps.eu/icons/23.png</href></Icon></IconStyle>
  250.    </Style>
  251.     <Style id="Icon24">
  252.      <IconStyle><Icon><href>https://pokemaps.eu/icons/24.png</href></Icon></IconStyle>
  253.    </Style>
  254.     <Style id="Icon25">
  255.      <IconStyle><Icon><href>https://pokemaps.eu/icons/25.png</href></Icon></IconStyle>
  256.    </Style>
  257.     <Style id="Icon26">
  258.      <IconStyle><Icon><href>https://pokemaps.eu/icons/26.png</href></Icon></IconStyle>
  259.    </Style>
  260.     <Style id="Icon27">
  261.      <IconStyle><Icon><href>https://pokemaps.eu/icons/27.png</href></Icon></IconStyle>
  262.    </Style>
  263.     <Style id="Icon28">
  264.      <IconStyle><Icon><href>https://pokemaps.eu/icons/28.png</href></Icon></IconStyle>
  265.    </Style>
  266.     <Style id="Icon29">
  267.      <IconStyle><Icon><href>https://pokemaps.eu/icons/29.png</href></Icon></IconStyle>
  268.    </Style>
  269.     <Style id="Icon30">
  270.      <IconStyle><Icon><href>https://pokemaps.eu/icons/30.png</href></Icon></IconStyle>
  271.    </Style>
  272.     <Style id="Icon31">
  273.      <IconStyle><Icon><href>https://pokemaps.eu/icons/31.png</href></Icon></IconStyle>
  274.    </Style>
  275.     <Style id="Icon32">
  276.      <IconStyle><Icon><href>https://pokemaps.eu/icons/32.png</href></Icon></IconStyle>
  277.    </Style>
  278.     <Style id="Icon33">
  279.      <IconStyle><Icon><href>https://pokemaps.eu/icons/33.png</href></Icon></IconStyle>
  280.    </Style>
  281.     <Style id="Icon34">
  282.      <IconStyle><Icon><href>https://pokemaps.eu/icons/34.png</href></Icon></IconStyle>
  283.    </Style>
  284.     <Style id="Icon35">
  285.      <IconStyle><Icon><href>https://pokemaps.eu/icons/35.png</href></Icon></IconStyle>
  286.    </Style>
  287.     <Style id="Icon36">
  288.      <IconStyle><Icon><href>https://pokemaps.eu/icons/36.png</href></Icon></IconStyle>
  289.    </Style>
  290.     <Style id="Icon37">
  291.      <IconStyle><Icon><href>https://pokemaps.eu/icons/37.png</href></Icon></IconStyle>
  292.    </Style>
  293.     <Style id="Icon38">
  294.      <IconStyle><Icon><href>https://pokemaps.eu/icons/38.png</href></Icon></IconStyle>
  295.    </Style>
  296.     <Style id="Icon39">
  297.      <IconStyle><Icon><href>https://pokemaps.eu/icons/39.png</href></Icon></IconStyle>
  298.    </Style>
  299.     <Style id="Icon40">
  300.      <IconStyle><Icon><href>https://pokemaps.eu/icons/40.png</href></Icon></IconStyle>
  301.    </Style>
  302.     <Style id="Icon41">
  303.      <IconStyle><Icon><href>https://pokemaps.eu/icons/41.png</href></Icon></IconStyle>
  304.    </Style>
  305.     <Style id="Icon42">
  306.      <IconStyle><Icon><href>https://pokemaps.eu/icons/42.png</href></Icon></IconStyle>
  307.    </Style>
  308.     <Style id="Icon43">
  309.      <IconStyle><Icon><href>https://pokemaps.eu/icons/43.png</href></Icon></IconStyle>
  310.    </Style>
  311.     <Style id="Icon44">
  312.      <IconStyle><Icon><href>https://pokemaps.eu/icons/44.png</href></Icon></IconStyle>
  313.    </Style>
  314.     <Style id="Icon45">
  315.      <IconStyle><Icon><href>https://pokemaps.eu/icons/45.png</href></Icon></IconStyle>
  316.    </Style>
  317.     <Style id="Icon46">
  318.      <IconStyle><Icon><href>https://pokemaps.eu/icons/46.png</href></Icon></IconStyle>
  319.    </Style>
  320.     <Style id="Icon47">
  321.      <IconStyle><Icon><href>https://pokemaps.eu/icons/47.png</href></Icon></IconStyle>
  322.    </Style>
  323.     <Style id="Icon48">
  324.      <IconStyle><Icon><href>https://pokemaps.eu/icons/48.png</href></Icon></IconStyle>
  325.    </Style>
  326.     <Style id="Icon49">
  327.      <IconStyle><Icon><href>https://pokemaps.eu/icons/49.png</href></Icon></IconStyle>
  328.    </Style>
  329.     <Style id="Icon50">
  330.      <IconStyle><Icon><href>https://pokemaps.eu/icons/50.png</href></Icon></IconStyle>
  331.    </Style>
  332.     <Style id="Icon51">
  333.      <IconStyle><Icon><href>https://pokemaps.eu/icons/51.png</href></Icon></IconStyle>
  334.    </Style>
  335.     <Style id="Icon52">
  336.      <IconStyle><Icon><href>https://pokemaps.eu/icons/52.png</href></Icon></IconStyle>
  337.    </Style>
  338.     <Style id="Icon53">
  339.      <IconStyle><Icon><href>https://pokemaps.eu/icons/53.png</href></Icon></IconStyle>
  340.    </Style>
  341.     <Style id="Icon54">
  342.      <IconStyle><Icon><href>https://pokemaps.eu/icons/54.png</href></Icon></IconStyle>
  343.    </Style>
  344.     <Style id="Icon55">
  345.      <IconStyle><Icon><href>https://pokemaps.eu/icons/55.png</href></Icon></IconStyle>
  346.    </Style>
  347.     <Style id="Icon56">
  348.      <IconStyle><Icon><href>https://pokemaps.eu/icons/56.png</href></Icon></IconStyle>
  349.    </Style>
  350.     <Style id="Icon57">
  351.      <IconStyle><Icon><href>https://pokemaps.eu/icons/57.png</href></Icon></IconStyle>
  352.    </Style>
  353.     <Style id="Icon58">
  354.      <IconStyle><Icon><href>https://pokemaps.eu/icons/58.png</href></Icon></IconStyle>
  355.    </Style>
  356.     <Style id="Icon59">
  357.      <IconStyle><Icon><href>https://pokemaps.eu/icons/59.png</href></Icon></IconStyle>
  358.    </Style>
  359.     <Style id="Icon60">
  360.      <IconStyle><Icon><href>https://pokemaps.eu/icons/60.png</href></Icon></IconStyle>
  361.    </Style>
  362.     <Style id="Icon61">
  363.      <IconStyle><Icon><href>https://pokemaps.eu/icons/61.png</href></Icon></IconStyle>
  364.    </Style>
  365.     <Style id="Icon62">
  366.      <IconStyle><Icon><href>https://pokemaps.eu/icons/62.png</href></Icon></IconStyle>
  367.    </Style>
  368.     <Style id="Icon63">
  369.      <IconStyle><Icon><href>https://pokemaps.eu/icons/63.png</href></Icon></IconStyle>
  370.    </Style>
  371.     <Style id="Icon64">
  372.      <IconStyle><Icon><href>https://pokemaps.eu/icons/64.png</href></Icon></IconStyle>
  373.    </Style>
  374.     <Style id="Icon65">
  375.      <IconStyle><Icon><href>https://pokemaps.eu/icons/65.png</href></Icon></IconStyle>
  376.    </Style>
  377.     <Style id="Icon66">
  378.      <IconStyle><Icon><href>https://pokemaps.eu/icons/66.png</href></Icon></IconStyle>
  379.    </Style>
  380.     <Style id="Icon67">
  381.      <IconStyle><Icon><href>https://pokemaps.eu/icons/67.png</href></Icon></IconStyle>
  382.    </Style>
  383.     <Style id="Icon68">
  384.      <IconStyle><Icon><href>https://pokemaps.eu/icons/68.png</href></Icon></IconStyle>
  385.    </Style>
  386.     <Style id="Icon69">
  387.      <IconStyle><Icon><href>https://pokemaps.eu/icons/69.png</href></Icon></IconStyle>
  388.    </Style>
  389.     <Style id="Icon70">
  390.      <IconStyle><Icon><href>https://pokemaps.eu/icons/70.png</href></Icon></IconStyle>
  391.    </Style>
  392.     <Style id="Icon71">
  393.      <IconStyle><Icon><href>https://pokemaps.eu/icons/71.png</href></Icon></IconStyle>
  394.    </Style>
  395.     <Style id="Icon72">
  396.      <IconStyle><Icon><href>https://pokemaps.eu/icons/72.png</href></Icon></IconStyle>
  397.    </Style>
  398.     <Style id="Icon73">
  399.      <IconStyle><Icon><href>https://pokemaps.eu/icons/73.png</href></Icon></IconStyle>
  400.    </Style>
  401.     <Style id="Icon74">
  402.      <IconStyle><Icon><href>https://pokemaps.eu/icons/74.png</href></Icon></IconStyle>
  403.    </Style>
  404.     <Style id="Icon75">
  405.      <IconStyle><Icon><href>https://pokemaps.eu/icons/75.png</href></Icon></IconStyle>
  406.    </Style>
  407.     <Style id="Icon76">
  408.      <IconStyle><Icon><href>https://pokemaps.eu/icons/76.png</href></Icon></IconStyle>
  409.    </Style>
  410.     <Style id="Icon77">
  411.      <IconStyle><Icon><href>https://pokemaps.eu/icons/77.png</href></Icon></IconStyle>
  412.    </Style>
  413.     <Style id="Icon78">
  414.      <IconStyle><Icon><href>https://pokemaps.eu/icons/78.png</href></Icon></IconStyle>
  415.    </Style>
  416.     <Style id="Icon79">
  417.      <IconStyle><Icon><href>https://pokemaps.eu/icons/79.png</href></Icon></IconStyle>
  418.    </Style>
  419.     <Style id="Icon80">
  420.      <IconStyle><Icon><href>https://pokemaps.eu/icons/80.png</href></Icon></IconStyle>
  421.    </Style>
  422.     <Style id="Icon81">
  423.      <IconStyle><Icon><href>https://pokemaps.eu/icons/81.png</href></Icon></IconStyle>
  424.    </Style>
  425.     <Style id="Icon82">
  426.      <IconStyle><Icon><href>https://pokemaps.eu/icons/82.png</href></Icon></IconStyle>
  427.    </Style>
  428.     <Style id="Icon83">
  429.      <IconStyle><Icon><href>https://pokemaps.eu/icons/83.png</href></Icon></IconStyle>
  430.    </Style>
  431.     <Style id="Icon84">
  432.      <IconStyle><Icon><href>https://pokemaps.eu/icons/84.png</href></Icon></IconStyle>
  433.    </Style>
  434.     <Style id="Icon85">
  435.      <IconStyle><Icon><href>https://pokemaps.eu/icons/85.png</href></Icon></IconStyle>
  436.    </Style>
  437.     <Style id="Icon86">
  438.      <IconStyle><Icon><href>https://pokemaps.eu/icons/86.png</href></Icon></IconStyle>
  439.    </Style>
  440.     <Style id="Icon87">
  441.      <IconStyle><Icon><href>https://pokemaps.eu/icons/87.png</href></Icon></IconStyle>
  442.    </Style>
  443.     <Style id="Icon88">
  444.      <IconStyle><Icon><href>https://pokemaps.eu/icons/88.png</href></Icon></IconStyle>
  445.    </Style>
  446.     <Style id="Icon89">
  447.      <IconStyle><Icon><href>https://pokemaps.eu/icons/89.png</href></Icon></IconStyle>
  448.    </Style>
  449.     <Style id="Icon90">
  450.      <IconStyle><Icon><href>https://pokemaps.eu/icons/90.png</href></Icon></IconStyle>
  451.    </Style>
  452.     <Style id="Icon91">
  453.      <IconStyle><Icon><href>https://pokemaps.eu/icons/91.png</href></Icon></IconStyle>
  454.    </Style>
  455.     <Style id="Icon92">
  456.      <IconStyle><Icon><href>https://pokemaps.eu/icons/92.png</href></Icon></IconStyle>
  457.    </Style>
  458.     <Style id="Icon93">
  459.      <IconStyle><Icon><href>https://pokemaps.eu/icons/93.png</href></Icon></IconStyle>
  460.    </Style>
  461.     <Style id="Icon94">
  462.      <IconStyle><Icon><href>https://pokemaps.eu/icons/94.png</href></Icon></IconStyle>
  463.    </Style>
  464.     <Style id="Icon95">
  465.      <IconStyle><Icon><href>https://pokemaps.eu/icons/95.png</href></Icon></IconStyle>
  466.    </Style>
  467.     <Style id="Icon96">
  468.      <IconStyle><Icon><href>https://pokemaps.eu/icons/96.png</href></Icon></IconStyle>
  469.    </Style>
  470.     <Style id="Icon97">
  471.      <IconStyle><Icon><href>https://pokemaps.eu/icons/97.png</href></Icon></IconStyle>
  472.    </Style>
  473.     <Style id="Icon98">
  474.      <IconStyle><Icon><href>https://pokemaps.eu/icons/98.png</href></Icon></IconStyle>
  475.    </Style>
  476.     <Style id="Icon99">
  477.      <IconStyle><Icon><href>https://pokemaps.eu/icons/99.png</href></Icon></IconStyle>
  478.    </Style>
  479.     <Style id="Icon100">
  480.      <IconStyle><Icon><href>https://pokemaps.eu/icons/100.png</href></Icon></IconStyle>
  481.    </Style>
  482.     <Style id="Icon101">
  483.      <IconStyle><Icon><href>https://pokemaps.eu/icons/101.png</href></Icon></IconStyle>
  484.    </Style>
  485.     <Style id="Icon102">
  486.      <IconStyle><Icon><href>https://pokemaps.eu/icons/102.png</href></Icon></IconStyle>
  487.    </Style>
  488.     <Style id="Icon103">
  489.      <IconStyle><Icon><href>https://pokemaps.eu/icons/103.png</href></Icon></IconStyle>
  490.    </Style>
  491.     <Style id="Icon104">
  492.      <IconStyle><Icon><href>https://pokemaps.eu/icons/104.png</href></Icon></IconStyle>
  493.    </Style>
  494.     <Style id="Icon105">
  495.      <IconStyle><Icon><href>https://pokemaps.eu/icons/105.png</href></Icon></IconStyle>
  496.    </Style>
  497.     <Style id="Icon106">
  498.      <IconStyle><Icon><href>https://pokemaps.eu/icons/106.png</href></Icon></IconStyle>
  499.    </Style>
  500.     <Style id="Icon107">
  501.      <IconStyle><Icon><href>https://pokemaps.eu/icons/107.png</href></Icon></IconStyle>
  502.    </Style>
  503.     <Style id="Icon108">
  504.      <IconStyle><Icon><href>https://pokemaps.eu/icons/108.png</href></Icon></IconStyle>
  505.    </Style>
  506.     <Style id="Icon109">
  507.      <IconStyle><Icon><href>https://pokemaps.eu/icons/109.png</href></Icon></IconStyle>
  508.    </Style>
  509.     <Style id="Icon110">
  510.      <IconStyle><Icon><href>https://pokemaps.eu/icons/110.png</href></Icon></IconStyle>
  511.    </Style>
  512.     <Style id="Icon111">
  513.      <IconStyle><Icon><href>https://pokemaps.eu/icons/111.png</href></Icon></IconStyle>
  514.    </Style>
  515.     <Style id="Icon112">
  516.      <IconStyle><Icon><href>https://pokemaps.eu/icons/112.png</href></Icon></IconStyle>
  517.    </Style>
  518.     <Style id="Icon113">
  519.      <IconStyle><Icon><href>https://pokemaps.eu/icons/113.png</href></Icon></IconStyle>
  520.    </Style>
  521.     <Style id="Icon114">
  522.      <IconStyle><Icon><href>https://pokemaps.eu/icons/114.png</href></Icon></IconStyle>
  523.    </Style>
  524.     <Style id="Icon115">
  525.      <IconStyle><Icon><href>https://pokemaps.eu/icons/115.png</href></Icon></IconStyle>
  526.    </Style>
  527.     <Style id="Icon116">
  528.      <IconStyle><Icon><href>https://pokemaps.eu/icons/116.png</href></Icon></IconStyle>
  529.    </Style>
  530.     <Style id="Icon117">
  531.      <IconStyle><Icon><href>https://pokemaps.eu/icons/117.png</href></Icon></IconStyle>
  532.    </Style>
  533.     <Style id="Icon118">
  534.      <IconStyle><Icon><href>https://pokemaps.eu/icons/118.png</href></Icon></IconStyle>
  535.    </Style>
  536.     <Style id="Icon119">
  537.      <IconStyle><Icon><href>https://pokemaps.eu/icons/119.png</href></Icon></IconStyle>
  538.    </Style>
  539.     <Style id="Icon120">
  540.      <IconStyle><Icon><href>https://pokemaps.eu/icons/120.png</href></Icon></IconStyle>
  541.    </Style>
  542.     <Style id="Icon121">
  543.      <IconStyle><Icon><href>https://pokemaps.eu/icons/121.png</href></Icon></IconStyle>
  544.    </Style>
  545.     <Style id="Icon122">
  546.      <IconStyle><Icon><href>https://pokemaps.eu/icons/122.png</href></Icon></IconStyle>
  547.    </Style>
  548.     <Style id="Icon123">
  549.      <IconStyle><Icon><href>https://pokemaps.eu/icons/123.png</href></Icon></IconStyle>
  550.    </Style>
  551.     <Style id="Icon124">
  552.      <IconStyle><Icon><href>https://pokemaps.eu/icons/124.png</href></Icon></IconStyle>
  553.    </Style>
  554.     <Style id="Icon125">
  555.      <IconStyle><Icon><href>https://pokemaps.eu/icons/125.png</href></Icon></IconStyle>
  556.    </Style>
  557.     <Style id="Icon126">
  558.      <IconStyle><Icon><href>https://pokemaps.eu/icons/126.png</href></Icon></IconStyle>
  559.    </Style>
  560.     <Style id="Icon127">
  561.      <IconStyle><Icon><href>https://pokemaps.eu/icons/127.png</href></Icon></IconStyle>
  562.    </Style>
  563.     <Style id="Icon128">
  564.      <IconStyle><Icon><href>https://pokemaps.eu/icons/128.png</href></Icon></IconStyle>
  565.    </Style>
  566.     <Style id="Icon129">
  567.      <IconStyle><Icon><href>https://pokemaps.eu/icons/129.png</href></Icon></IconStyle>
  568.    </Style>
  569.     <Style id="Icon130">
  570.      <IconStyle><Icon><href>https://pokemaps.eu/icons/130.png</href></Icon></IconStyle>
  571.    </Style>
  572.     <Style id="Icon131">
  573.      <IconStyle><Icon><href>https://pokemaps.eu/icons/131.png</href></Icon></IconStyle>
  574.    </Style>
  575.     <Style id="Icon132">
  576.      <IconStyle><Icon><href>https://pokemaps.eu/icons/132.png</href></Icon></IconStyle>
  577.    </Style>
  578.     <Style id="Icon133">
  579.      <IconStyle><Icon><href>https://pokemaps.eu/icons/133.png</href></Icon></IconStyle>
  580.    </Style>
  581.     <Style id="Icon134">
  582.      <IconStyle><Icon><href>https://pokemaps.eu/icons/134.png</href></Icon></IconStyle>
  583.    </Style>
  584.     <Style id="Icon135">
  585.      <IconStyle><Icon><href>https://pokemaps.eu/icons/135.png</href></Icon></IconStyle>
  586.    </Style>
  587.     <Style id="Icon136">
  588.      <IconStyle><Icon><href>https://pokemaps.eu/icons/136.png</href></Icon></IconStyle>
  589.    </Style>
  590.     <Style id="Icon137">
  591.      <IconStyle><Icon><href>https://pokemaps.eu/icons/137.png</href></Icon></IconStyle>
  592.    </Style>
  593.     <Style id="Icon138">
  594.      <IconStyle><Icon><href>https://pokemaps.eu/icons/138.png</href></Icon></IconStyle>
  595.    </Style>
  596.     <Style id="Icon139">
  597.      <IconStyle><Icon><href>https://pokemaps.eu/icons/139.png</href></Icon></IconStyle>
  598.    </Style>
  599.     <Style id="Icon140">
  600.      <IconStyle><Icon><href>https://pokemaps.eu/icons/140.png</href></Icon></IconStyle>
  601.    </Style>
  602.     <Style id="Icon141">
  603.      <IconStyle><Icon><href>https://pokemaps.eu/icons/141.png</href></Icon></IconStyle>
  604.    </Style>
  605.     <Style id="Icon142">
  606.      <IconStyle><Icon><href>https://pokemaps.eu/icons/142.png</href></Icon></IconStyle>
  607.    </Style>
  608.     <Style id="Icon143">
  609.      <IconStyle><Icon><href>https://pokemaps.eu/icons/143.png</href></Icon></IconStyle>
  610.    </Style>
  611.     <Style id="Icon144">
  612.      <IconStyle><Icon><href>https://pokemaps.eu/icons/144.png</href></Icon></IconStyle>
  613.    </Style>
  614.     <Style id="Icon145">
  615.      <IconStyle><Icon><href>https://pokemaps.eu/icons/145.png</href></Icon></IconStyle>
  616.    </Style>
  617.     <Style id="Icon146">
  618.      <IconStyle><Icon><href>https://pokemaps.eu/icons/146.png</href></Icon></IconStyle>
  619.    </Style>
  620.     <Style id="Icon147">
  621.      <IconStyle><Icon><href>https://pokemaps.eu/icons/147.png</href></Icon></IconStyle>
  622.    </Style>
  623.     <Style id="Icon148">
  624.      <IconStyle><Icon><href>https://pokemaps.eu/icons/148.png</href></Icon></IconStyle>
  625.    </Style>
  626.     <Style id="Icon149">
  627.      <IconStyle><Icon><href>https://pokemaps.eu/icons/149.png</href></Icon></IconStyle>
  628.    </Style>
  629.     <Style id="Icon150">
  630.      <IconStyle><Icon><href>https://pokemaps.eu/icons/150.png</href></Icon></IconStyle>
  631.    </Style>
  632.     <Style id="Icon151">
  633.      <IconStyle><Icon><href>https://pokemaps.eu/icons/151.png</href></Icon></IconStyle>
  634.    </Style>
  635.  </Document>
  636. </kml>
  637. ' AS KML,3 AS Id
  638. ORDER BY Id ASC);
  639.  
  640.  
  641. DROP TABLE "pokemon_info";
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!