
DROP DATABASE IF EXISTS goteborg;
SHOW WARNINGS;
CREATE DATABASE IF NOT EXISTS goteborg;
SHOW WARNINGS;
USE goteborg;
SHOW WARNINGS;



DROP TABLE IF EXISTS stops;
SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS stops (
  stopID int NOT NULL,
  stopNAME text NOT NULL,
  stopNORTH double NOT NULL,
  stopEAST double NOT NULL
);
SHOW WARNINGS;


INSERT INTO stops (stopID, stopNAME, stopNORTH, stopEAST) VALUES
(1,  'Allhelgonakyrkan',  57.75731557531680, 12.036681175231900),
(2,  'Almedal',  57.68730175496990, 11.996941566467200),
(3,  'Angered Centrum',  57.79609137780020, 12.04927682876580),
(4,  'Aprilgatan',  57.76112177108570, 12.04128384590140),
(5,  'ƒttehˆgsgatan',  57.71999936725880, 12.028452157974200),
(6,  'Axel Dahlstrˆms Torg',  57.67224428302250, 11.927525997161800),
(7,  'B‰ckeliden',  57.699945198320900, 12.003357410430900),
(8,  'Bellevue',  57.732001334848900, 12.022658586502000),
(9,  'Berga',  57.67051155551880, 11.875340938568100),
(10, 'Berzeliigatan',  57.698534855956900, 11.98182463645930),
(11, 'Bev‰ringsgatan',  57.73987063091850, 12.02852725982660),
(12, 'Bˆgatan',  57.70090259456820, 12.01629638671870),
(13, 'Bokekullsgatan',  57.67697730533380, 11.932429075241000),
(14, 'Botaniska Tr‰dgÂrden',  57.68096977458320, 11.945486068725500),
(15, 'Briljantgatan',  57.648587125541500, 11.90320372581480),
(16, 'Brunnsgatan',  57.69367850102650, 11.958811283111500),
(17, 'Brunnsparken',  57.7068814488679, 11.967684030532800),
(18, 'Centralstationen',  57.70884743360550, 11.973509788513100),
(19, 'Chalmers',  57.69002577210640, 11.972662210464400),
(20, 'Chapmans Torg',  57.69431496713540, 11.919565200805600),
(21, 'Doktor Fries Torg',  57.684290760943000, 11.97311282157890),
(22, 'Doktor Sydows Gata',  57.68082063852320, 11.975430250167800),
(23, 'Domkyrkan',  57.70437079422240, 11.963510513305600),
(24, 'Ejdergatan',  57.72099061132330, 12.005717754364000),
(25, 'Ekedal',  57.68688883344760, 11.928030252456600),
(26, 'Eketr‰gatan',  57.71619457149260, 11.90994143486020),
(27, 'Ekmanska',  57.69956395265050, 12.009880542755100),
(28, 'Elisedal',  57.684075680368500, 12.000036835670400),
(29, 'Fj‰llgatan',  57.69444111224380, 11.93637728691100),
(30, 'Frihamnen',  57.72027439723500, 11.960291862487700),
(31, 'Friskv‰derstorget',  57.72363188635880, 11.893386840820300),
(32, 'Frˆlunda Torg',  57.65213209028380, 11.910070180892900),
(33, 'Galileis Gata',  57.76061239368450, 12.051637172698900),
(34, 'Gamlestadstorget',  57.72787700259210, 12.005417346954300),
(35, 'Getebergs‰ng',  57.691964000657, 11.991791725158600),
(36, 'Godhemsgatan',  57.68484709677510, 11.925981044769200),
(37, 'Grˆnsakstorget',  57.70246762495370, 11.963918209075900),
(38, 'GropegÂrdsgatan',  57.718314763050700, 11.919071674346900),
(39, 'Hagakyrkan',  57.699601217441800, 11.961139440536400),
(40, 'Hagen',  57.67483748207400, 11.88394546508780),
(41, 'Hammarkullen',  57.78015817796070, 12.034964561462400),
(42, 'Handelshˆgskolan',  57.69669444858560, 11.962416172027500),
(43, 'H‰rlanda',  57.71803971818330, 12.020244598388600),
(44, 'Hinsholmen',  57.66748769033630, 11.861586570739700),
(45, 'Hj. Brantingsplatsen',  57.720801532181, 11.953420042991600),
(46, 'Hj‰llbo',  57.768853123848400, 12.022658586502000),
(47, 'Hˆgsbogatan',  57.680212615928200, 11.930176019668500),
(48, 'Jaegerdorffsplatsen',  57.691642881199100, 11.915112733840900),
(49, 'Januarigatan',  57.760274712573200, 12.041176557540800),
(50, 'J‰rntorget',  57.700151585280300, 11.952234506607000),
(51, 'Kaggeledstorget',  57.72304177004840, 12.033709287643400),
(52, 'KÂlltorp',  57.7101255530144, 12.02330231666560),
(53, 'Kapellplatsen',  57.69386198789870, 11.973305940628000),
(54, 'Kaptensgatan',  57.697026990171900, 11.926946640014600),
(55, 'K‰ringberget',  57.66910867408880, 11.871060132980300),
(56, 'Klintens V‰g',  57.682535666167800, 11.92789077758780),
(57, 'Komettorget',  57.750921408899500, 12.071506977081200),
(58, 'Korsv‰gen',  57.696608445954400, 11.98708176612850),
(59, 'Kortedala Torg',  57.75290790042520, 12.03277587890620),
(60, 'Kroksl‰tts Fabriker',  57.671354979580000, 12.010202407836900),
(61, 'Kroksl‰tts Torg',  57.675382489261300, 12.007863521575900),
(62, 'Kungsportsplatsen',  57.704009658344800, 11.969679594039900),
(63, 'Kungssten',  57.68072312615220, 11.901519298553400),
(64, 'Kviberg',  57.7364802853199, 12.0250403881073),
(65, 'Lackareb‰ck',  57.66588098007620, 12.011404037475500),
(66, 'Lana',  57.67814182095370, 12.0040762424469),
(67, 'LÂngedrag',  57.66795247538760, 11.853534579277000),
(68, 'Lantmilsgatan',  57.667464737833800, 11.925047636032100),
(69, 'Lilla Bommen',  57.70923144731720, 11.966686248779200),
(70, 'LinnÈplatsen',  57.689601412376000, 11.95237398147580),
(71, 'Liseberg',  57.69720472666450, 11.991029977798400),
(72, 'Majvallen',  57.6910379073463, 11.935535073280300),
(73, 'Mariaplan',  57.68663649020110, 11.9209223985672),
(74, 'Marklandsgatan',  57.6744358925883, 11.93589448928830),
(75, 'Masthuggstorget',  57.69946935723870, 11.944295167922900),
(76, 'Medicinaregatan',  57.68539768877790, 11.96436882019040),
(77, 'Mildv‰dersgatan',  57.71562152542900, 11.89094066619870),
(78, 'Mˆlndal Centrum',  57.65578576844530, 12.017197608947700),
(79, 'Mˆlndals Sjukhus',  57.66170320026890, 12.013356685638400),
(80, 'Munkeb‰ckstorget',  57.718257462209000, 12.02678918838500),
(81, 'Musikv‰gen',  57.659298463213800, 11.92592740058890),
(82, 'Nordstan',  57.70915120598270, 11.970516443252500),
(83, 'Nya VarvsallÈn',  57.67745917840310, 11.893751621246300),
(84, 'NymÂnegatan',  57.74318621894920, 12.029932737350400),
(85, 'Nymilsgatan',  57.66273621258400, 11.924436092376700),
(86, 'Olivedalsgatan',  57.69200987463290, 11.953001618385300),
(87, 'Olskrokstorget',  57.71461294232380, 11.99880838394160),
(88, '÷nskev‰dersgatan',  57.71996498836490, 11.8937087059021),
(89, 'Opaltorget',  57.64184068965920, 11.900854110717700),
(90, 'Ostindiegatan',  57.68768026223220, 11.91540777683250),
(91, '÷stra Sjukhuset',  57.72225397842280, 12.048155665397600),
(92, 'Positivgatan',  57.65480421940990, 11.915380954742400),
(93, 'Prinsgatan',  57.696883653655600, 11.950775384902900),
(94, 'Rambergsvallen',  57.71947795052540, 11.927515268325800),
(95, 'Redbergsplatsen',  57.71639513547170, 12.00478971004480),
(96, 'Roddfˆreningen',  57.66403030594430, 11.851678490638700),
(97, 'Runstavsgatan',  57.74752923658740, 12.030179500579800),
(98, 'Rymdtorget',  57.75583305375430, 12.066839933395300),
(99, 'Sahlgrenska HuvudentrÈ',  57.68364838317360, 11.960924863815300),
(100, 'S‰lˆfjordsgatan',  57.71383929419330, 11.902130842208800),
(101, 'Saltholmen',  57.66057833117960, 11.84526801109310),
(102, 'Sanatoriegatan',  57.71340948253220, 12.024214267730700),
(103, 'Sandarna',  57.68277656656120, 11.909608840942300),
(104, 'Sankt Sigfrids Plan',  57.698626587211200, 11.999409198760900),
(105, 'Sannaplan',  57.68423914172150, 11.916604042053200),
(106, 'Scandinavium',  57.70047836222770, 11.985869407653800),
(107, 'Seminariegatan',  57.69219336995580, 11.957309246063200),
(108, 'SKF',  57.729188820368100, 12.01330304145810),
(109, 'Smaragdgatan',  57.64533176792470, 11.89921259880060),
(110, 'Solrosgatan',  57.71637794431700, 12.025201320648100),
(111, 'Stigbergstorget',  57.698815782189600, 11.935347318649200),
(112, 'Stockholmsgatan',  57.71711142632540, 12.013506889343200),
(113, 'StorÂs',  57.78498577647040, 12.046637535095200),
(114, 'Svingeln',  57.71170737823800, 11.990225315093900),
(115, 'Teleskopgatan',  57.759710949787900, 12.060402631759600),
(116, 'Temperaturgatan',  57.732660038817600, 11.895360946655200),
(117, 'Tingvallsv‰gen',  57.72464594725040, 12.041981220245300),
(118, 'Tˆpelsgatan',  57.702278449049800, 12.022368907928400),
(119, 'Torp',  57.7101255530144, 12.02330231666560),
(120, 'Ullevi Norra',  57.70783293002900, 11.986169815063400),
(121, 'Ullevi Sˆdra',  57.70437079422240, 11.984989643096900),
(122, 'V‰derilsgatan',  57.72720102551880, 11.893537044525100),
(123, 'VÂgm‰stareplatsen',  57.72096196303190, 11.94488525390620),
(124, 'Vagnhallen Majorna',  57.688941924553700, 11.912602186203000),
(125, 'Valand',  57.700472629324200, 11.974282264709400),
(126, 'Varbergsgatan',  57.6800175876525, 12.002788782119700),
(127, 'Varmfrontsgatan',  57.73689264162540, 11.896369457244800),
(128, 'VÂrv‰derstorget',  57.71304843679320, 11.8932044506073),
(129, 'Vasa Viktoriagatan',  57.69834565951130, 11.965903043746900),
(130, 'Vasaplatsen',  57.6991425711883, 11.969754695892300),
(131, 'Wavrinskys Plats',  57.68887884248090, 11.968542337417600),
(132, 'Welandergatan',  57.70609617148770, 12.023956775665200),
(133, 'Wieselgrensplatsen',  57.72101066511380, 11.934987902641200);



DROP TABLE IF EXISTS routes;
SHOW warnings;
CREATE TABLE routes (
  routeID int NOT NULL,
  routeNAME text NOT NULL,
  color text NOT NULL,
  colorhex varchar(7) NOT NULL
);
SHOW WARNINGS;


INSERT INTO routes (routeID, routeNAME, color, colorhex) VALUES
(1,  'Tynnered - ÷stra Sjukhuset',  'white',  '#FFFFFF'),
(2,  'Hˆgsbotorp - Annedal - City - Kroksl‰tt',  'yellow',  '#FFFF00'),
(3,  'Marklandsgatan - KÂlltorp',  'blue',  '#0000FF'),
(4,  'Mˆlndal - Korsv‰gen - City - Angered',  'dark green',  '#006400'),
(5,  'Torp - Liseberg - L‰nsmansgÂrden',  'red',  '#FF0000'),
(6,  'L‰nsmansgÂrden - Sahlgrenska - Kortedala',  'orange',  '#FFA500'),
(7,  'Tynnered - Bergsjˆn',  'brown',  '#8B4513'),
(8,  'Frˆlunda Torg - Korsv‰gen - Angered',  'purple',  '#A020F0'),
(9,  'Kungssten - Majorna - City - Angered',  'light blue',  '#ADD8E6'),
(10, 'Guldheden - BiskopsgÂrden',  'light green',  '#90EE90'),
(11, 'Saltholmen - Bergsjˆn',  'black',  '#000000'),
(13, 'LinnÈplatsen - City - Korsv‰gen - Marklandsgatan',  'light pink',  '#FFB6C1');



DROP TABLE IF EXISTS stopsroutes;
SHOW warnings;
CREATE TABLE stopsroutes (
  routeID int NOT NULL,
  stopID int NOT NULL,
  seq int NOT NULL,
  distance float NOT NULL,
  minutes int NOT NULL
);
SHOW warnings;


INSERT INTO stopsroutes (routeID, stopID, seq, distance, minutes) VALUES
(1,  89,  0,  0.0,  0),
(1,  109, 1,  0.4,  1),
(1,  15,  2,  0.9,  2),
(1,  32,  3,  1.5,  4),
(1,  92,  4,  1.9,  5),
(1,  81,  5,  2.5,  5),
(1,  85,  6,  3.0,  6),
(1,  68,  7,  3.5,  7),
(1,  6,	  8,  4.1,  8),
(1,  74,  9,  4.7,  10),
(1,  14,  10, 5.7,  12),
(1,  70,  11, 6.7,  14),
(1,  86,  12, 7.0,  15),
(1,  93,  13, 7.5,  17),
(1,  50,  14, 7.9,  19),
(1,  39,  15, 8.5,  21),
(1,  37,  16, 9.0,  23),
(1,  23,  17, 9.2,  24),
(1,  17,  18, 9.7,  26),
(1,  18,  19, 10.0, 27),
(1,  120, 20, 10.7, 29),
(1,  114, 21, 11.2, 30),
(1,  87,  22, 11.9, 32),
(1,  95,  23, 12.4, 33),
(1,  112, 24, 12.9, 34),
(1,  43,  25, 13.3, 35),
(1,  80,  26, 13.7, 36),
(1,  5,   27, 13.9, 37),
(1,  51,  28, 14.3, 38),
(1,  117, 29, 15.0, 40),
(1,  91,  30, 15.5, 41),
(2,  6,   0,  0.0,  0),
(2,  74,  1,  0.6,  2),
(2,  14,  2,  1.6,  4),
(2,  70,  3,  2.6,  6),
(2,  86,  4,  2.9,  7),
(2,  107, 5,  3.2,  8),
(2,  16,  6,  3.4,  9),
(2,  42,  7,  3.8,  10),
(2,  129, 8,  4.1,  12),
(2,  130, 9,  4.4,  13),
(2,  37,  10, 4.8,  14),
(2,  23,  11, 5.0,  15),
(2,  17,  12, 5.5,  18),
(2,  18,  13, 5.8,  19),
(2,  121, 14, 6.8,  22),
(2,  106, 15, 7.3,  23),
(2,  58,  16, 7.7,  25),
(2,  35,  17, 8.3,  27),
(2,  2,	  18, 8.9,  28),
(2,  28,  19, 9.3,  29),
(2,  126, 20, 9.8,  31),
(2,  66,  21, 10.0, 31),
(3,  74,  0,  0.0,  0),
(3,  13,  1,  0.4,  1),
(3,  47,  2,  0.8,  2),
(3,  56,  3,  1.1,  2),
(3,  36,  4,  1.4,  3),
(3,  73,  5,  1.8,  4),
(3,  90,  6,  2.2,  6),
(3,  124, 7,  2.5,  7),
(3,  48,  8,  2.8,  8),
(3,  20,  9,  3.2,  9),
(3,  54,  10, 3.8,  10),
(3,  111, 11, 4.3,  12),
(3,  75,  12, 4.9,  14),
(3,  50,  13, 5.4,  16),
(3,  39,  14, 6.0,  18),
(3,  129, 15, 6.3,  19),
(3,  130, 16, 6.6,  20),
(3,  125, 17, 6.9,  21),
(3,  62,  18, 7.6,  23),
(3,  17,  19, 7.9,  23),
(3,  18,  20, 8.2,  25),
(3,  120, 21, 8.9,  27),
(3,  114, 22, 9.4,  28),
(3,  87,  23, 10.1, 30),
(3,  95,  24, 10.6, 31),
(3,  112, 25, 11.1, 32),
(3,  43,  26, 11.5, 33),
(3,  110, 27, 12.0, 34),
(3,  102, 28, 12.3, 36),
(3,  52,  29, 12.7, 37),
(4,  78,  0,  0.0,  0),
(4,  79,  1,  0.6,  1),
(4,  65,  2,  1.1,  2),
(4,  60,  3,  1.8,  3),
(4,  61,  4,  2.2,  4),
(4,  66,  5,  2.6,  5),
(4,  126, 6,  2.8,  6),
(4,  28,  7,  3.3,  7),
(4,  2,	  8,  3.7,  8),
(4,  35,  9,  4.3,  10),
(4,  58,  10, 4.9,  12),
(4,  10,  11, 5.3,  13),
(4,  125, 12, 5.8,  15),
(4,  62,  13, 6.5,  17),
(4,  17,  14, 6.8,  18),
(4,  18,  15, 7.1,  19),
(4,  34,  16, 10.3, 25),
(4,  46,  17, 15.3, 31),
(4,  41,  18, 16.7, 33),
(4,  113, 19, 17.7, 35),
(4,  3,	  20, 18.9, 37),
(5,  119, 0,  0.0,  0),
(5,  132, 1,  0.4,  1),
(5,  118, 2,  0.9,  2),
(5,  12,  3,  1.3,  3),
(5,  27,  4,  1.7,  4),
(5,  7,	  5,  2.0,  5),
(5,  104, 6,  2.3,  6),
(5,  71,  7,  2.9,  7),
(5,  58,  8,  3.1,  8),
(5,  10,  9,  3.5,  9),
(5,  125, 10, 4.0,  11),
(5,  62,  11, 4.7,  13),
(5,  17,  12, 5.0,  14),
(5,  69,  13, 5.2,  14),
(5,  30,  14, 6.6,  18),
(5,  45,  15, 7.1,  19),
(5,  123, 16, 7.5,  20),
(5,  133, 17, 8.1,  21),
(5,  94,  18, 8.6,  22),
(5,  38,  19, 9.1,  23),
(5,  26,  20, 9.7,  24),
(5,  100, 21, 10.3, 25),
(5,  128, 22, 10.9, 27),
(5,  77,  23, 11.2, 27),
(5,  88,  24, 11.7, 28),
(5,  31,  25, 12.1, 29),
(5,  122, 26, 12.5, 30),
(5,  116, 27, 13.1, 31),
(5,  127, 28, 13.6, 32),
(6,  127, 0,  0.0,  0),
(6,  116, 1,  0.5,  1),
(6,  122, 2,  1.1,  2),
(6,  31,  3,  1.5,  3),
(6,  88,  4,  1.9,  4),
(6,  77,  5,  2.4,  5),
(6,  128, 6,  2.7,  6),
(6,  100, 7,  3.3,  8),
(6,  26,  8,  3.9,  9),
(6,  38,  9,  4.5,  10),
(6,  94,  10, 5.0,  11),
(6,  133, 11, 5.5,  12),
(6,  123, 12, 6.1,  14),
(6,  45,  13, 6.5,  15),
(6,  30,  14, 7.0,  16),
(6,  82,  15, 8.4,  19),
(6,  17,  16, 8.8,  20),
(6,  23,  17, 9.3,  22),
(6,  37,  18, 9.5,  23),
(6,  39,  19, 10.0, 25),
(6,  50,  20, 10.6, 27),
(6,  93,  21, 11.0, 28),
(6,  86,  22, 11.5, 30),
(6,  70,  23, 11.8, 31),
(6,  99,  24, 12.8, 34),
(6,  76,  25, 13.1, 35),
(6,  131, 26, 13.6, 36),
(6,  19,  27, 13.9, 37),
(6,  58,  28, 15.5, 40),
(6,  106, 29, 15.9, 42),
(6,  121, 30, 16.4, 44),
(6,  120, 31, 16.8, 45),
(6,  114, 32, 17.3, 46),
(6,  87,  33, 18.0, 48),
(6,  95,  34, 18.5, 49),
(6,  24,  35, 19.0, 51),
(6,  34,  36, 19.8, 53),
(6,  108, 37, 20.3, 54),
(6,  8,	  38, 21.0, 56),
(6,  64,  39, 21.6, 57),
(6,  11,  40, 21.9, 58),
(6,  84,  41, 22.3, 59),
(6,  97,  42, 22.8, 60),
(6,  59,  43, 23.5, 61),
(6,  1,	  44, 24.0, 62),
(6,  4,	  45, 24.5, 63),
(7,  89,  0,  0.0,  0),
(7,  109, 1,  0.4,  1),
(7,  15,  2,  0.9,  2),
(7,  32,  3,  1.5,  4),
(7,  92,  4,  1.9,  5),
(7,  81,  5,  2.5,  5),
(7,  85,  6,  3.0,  6),
(7,  68,  7,  3.5,  7),
(7,  6,	  8,  4.1,  8),
(7,  74,  9,  4.7,  10),
(7,  14,  10, 5.7,  12),
(7,  99,  11, 7.0,  15),
(7,  76,  12, 7.3,  16),
(7,  131, 13, 7.8,  17),
(7,  19,  14, 8.1,  18),
(7,  53,  15, 8.5,  19),
(7,  130, 16, 9.2,  21),
(7,  125, 17, 9.5,  22),
(7,  62,  18, 10.0, 24),
(7,  17,  19, 10.3, 25),
(7,  18,  20, 10.6, 26),
(7,  34,  21, 13.8, 32),
(7,  108, 22, 14.3, 33),
(7,  8,	  23, 15.0, 35),
(7,  64,  24, 15.6, 36),
(7,  11,  25, 15.9, 37),
(7,  84,  26, 16.3, 38),
(7,  97,  27, 16.8, 39),
(7,  59,  28, 17.5, 40),
(7,  1,	  29, 18.0, 41),
(7,  49,  30, 18.4, 42),
(7,  33,  31, 19.1, 44),
(7,  115, 32, 19.6, 45),
(7,  98,  33, 20.3, 46),
(7,  57,  34, 20.8, 47),
(8,  32,  0,  0.0,  0),
(8,  92,  1,  0.4,  1),
(8,  81,  2,  1.0,  2),
(8,  85,  3,  1.5,  3),
(8,  68,  4,  2.0,  4),
(8,  6,	  5,  2.6,  5),
(8,  74,  6,  3.2,  7),
(8,  14,  7,  4.2,  9),
(8,  99,  8,  5.5,  12),
(8,  76,  9,  5.8,  13),
(8,  131, 10, 6.3,  14),
(8,  19,  11, 6.6,  15),
(8,  58,  12, 8.2,  19),
(8,  106, 13, 8.6,  21),
(8,  121, 14, 9.1,  23),
(8,  120, 15, 9.5,  24),
(8,  114, 16, 10.0, 25),
(8,  87,  17, 10.7, 28),
(8,  95,  18, 11.2, 29),
(8,  24,  19, 11.7, 30),
(8,  34,  20, 12.5, 32),
(8,  46,  21, 17.5, 38),
(8,  41,  22, 18.9, 40),
(8,  113, 23, 19.9, 42),
(8,  3,	  24, 21.1, 44),
(9,  63,  0,  0.0,  0),
(9,  103, 1,  0.6,  2),
(9,  105, 2,  1.0,  3),
(9,  90,  3,  1.5,  4),
(9,  124, 4,  1.8,  5),
(9,  48,  5,  2.1,  6),
(9,  20,  6,  2.5,  7),
(9,  54,  7,  3.1,  8),
(9,  111, 8,  3.6,  10),
(9,  75,  9,  4.2,  12),
(9,  50,  10, 4.7,  14),
(9,  39,  11, 5.3,  16),
(9,  37,  12, 5.8,  18),
(9,  23,  13, 6.0,  19),
(9,  17,  14, 6.5,  21),
(9,  18,  15, 6.8,  22),
(9,  34,  16, 10.0, 28),
(9,  46,  17, 15.0, 34),
(9,  41,  18, 16.4, 36),
(9,  113, 19, 17.4, 38),
(9,  3,	  20, 18.6, 40),
(10, 22,  0,  0.0,  0),
(10, 21,  1,  0.5,  1),
(10, 131, 2,  1.0,  2),
(10, 19,  3,  1.3,  3),
(10, 53,  4,  1.7,  4),
(10, 130, 5,  2.4,  6),
(10, 125, 6,  2.7,  7),
(10, 62,  7,  3.2,  9),
(10, 17,  8,  3.5,  10),
(10, 69,  9,  3.7,  10),
(10, 30,  10, 5.1,  14),
(10, 45,  11, 5.6,  15),
(10, 123, 12, 6.0,  16),
(10, 133, 13, 6.6,  18),
(10, 94,  14, 7.1,  19),
(10, 38,  15, 7.6,  20),
(10, 26,  16, 8.2,  21),
(10, 100, 17, 8.8,  22),
(10, 128, 18, 9.4,  24),
(10, 77,  19, 9.7,  24),
(10, 88,  20, 10.2, 25),
(10, 31,  21, 10.6, 26),
(10, 122, 22, 11.0, 27),
(11, 101, 0,  0.0,  0),
(11, 96,  1,  0.5,  1),
(11, 67,  2,  1.0,  2),
(11, 44,  3,  1.6,  3),
(11, 55,  4,  2.2,  4),
(11, 9,	  5,  2.6,  5),
(11,40,	  6,  3.2,  6),
(11, 83,  7,  4.0,  8),
(11, 63,  8,  4.5,  9),
(11, 103, 9,  5.1,  10),
(11, 105, 10, 5.5,  11),
(11, 73,  11, 5.9,  12),
(11, 36,  12, 6.3,  13),
(11, 25,  13, 6.6,  14),
(11, 72,  14, 7.2,  15),
(11, 29,  15, 7.6,  16),
(11, 111, 16, 8.2,  18),
(11, 75,  17, 8.8,  20),
(11, 50,  18, 9.4,  22),
(11, 39,  19, 10.0, 24),
(11, 37,  20, 10.5, 26),
(11, 23,  21, 10.7, 27),
(11, 17,  22, 11.2, 29),
(11, 18,  23, 11.5, 30),
(11, 34,  24, 14.7, 36),
(11, 108, 25, 15.2, 37),
(11, 8,	  26, 15.9, 39),
(11, 64,  27, 16.5, 40),
(11, 11,  28, 16.8, 41),
(11, 84,  29, 17.2, 42),
(11, 97,  30, 17.7, 43),
(11, 59,  31, 18.4, 44),
(11, 1,	  32, 18.9, 46),
(11, 49,  33, 19.3, 47),
(11, 33,  34, 20.0, 48),
(11, 115, 35, 20.5, 49),
(11, 98,  36, 21.2, 51),
(11, 57,  37, 21.7, 52),
(13, 74,  0,  0.0,  0),
(13, 14,  1,  1.0,  2),
(13, 99,  2,  2.3,  5),
(13, 76,  3,  2.6,  6),
(13, 131, 4,  3.1,  7),
(13, 19,  5,  3.4,  8),
(13, 58,  6,  5.0,  12),
(13, 106, 7,  5.4,  13),
(13, 121, 8,  5.9,  15),
(13, 18,  9,  6.9,  18),
(13, 17,  10, 7.2,  19),
(13, 23,  11, 7.7,  22),
(13, 37,  12, 7.9,  23),
(13, 130, 13, 8.3,  24),
(13, 129, 14, 8.6,  25),
(13, 42,  15, 8.9,  26),
(13, 16,  16, 9.3,  28),
(13, 107, 17, 9.5,  29),
(13, 86,  18, 9.8,  30),
(13, 70,  19, 10.1, 31);



DROP TABLE IF EXISTS poi;
SHOW WARNINGS;
CREATE TABLE poi (
  poiID int NOT NULL,
  poiNAME text NOT NULL,
  poiTYPE text NOT NULL,
  poiNORTH double NOT NULL,
  poiEAST double NOT NULL
);
SHOW WARNINGS;


INSERT INTO poi (poiID, poiNAME, poiTYPE, poiNORTH, poiEAST) VALUES
(1,  'Alvsborg Fortress', 'Bauwerk', 57.703493, 11.969323),
(2,  'Botanical Garden', 'Park', 57.682908, 11.950443),
(3,  'Bubbles',	'Bar', 57.701333, 11.973773),
(4,  'Childrens Zoo', 'Park', 57.687176, 11.940165),
(5,  'City Museum', 'Museum', 57.706324, 11.963436),
(6,  'Concert Hall', 'Kultur', 57.696981, 11.979110),
(7,  'Elfsborgs Fortress', 'Bauwerk', 57.685765, 11.838155),
(8,  'Engelska Park', 'Park', 57.689286, 11.927977),
(9,  'Gamla Ullevi', 'Freizeit/Sport', 57.705913, 11.987221),
(10, 'Goteborg Maritime Center', 'Museum', 57.716848, 11.951752),
(11, 'Gretas', 'Bar', 57.705661, 11.967386),
(12, 'Gustavi Cathedral', 'Bauwerk', 57.704511, 11.965232),
(13, 'Holticultural Gardens', 'Park', 57.706853, 11.975913),
(14, 'Kronhusbodarns', 'Bauwerk', 57.707735, 11.961579),
(15, 'Liseberg Park', 'Freizeit/Sport', 57.696878, 11.990418),
(16, 'Maritime Museum', 'Museum', 57.698837, 11.932836),
(17, 'Museum of Fine Art', 'Museum', 57.696568, 11.980634),
(18, 'Museum of World Culture', 'Museum', 57.694451, 11.989225),
(19, 'National Theater', 'Kultur', 57.699884, 11.952086),
(20, 'Natural History Museum', 'Museum', 57.689951, 11.949348),
(21, 'Opera House', 'Kultur', 57.710365, 11.963753),
(22, 'Public Library', 'Kultur', 57.697818, 11.979582),
(23, 'Queen Christinas Hunting Lodge', 'Bauwerk', 57.703514, 11.958557),
(24, 'Rohsska Museum of Design and Applied Art', 'Museum', 57.699962, 11.973424),
(25, 'The Seamans Tower', 'Bauwerk', 57.699492, 11.932547),
(26, 'Tradgoarn', 'Disco', 57.700181, 11.956786),
(27, 'Universeum', 'Museum', 57.695639, 11.988487),
(28, 'Valand', 'Disco', 57.700321, 11.974181),
(29, 'Volvo Museum', 'Museum', 57.694837, 11.819744);
