text: -- phpMyAdmin SQL Dump
  -- version 2.8.2.4
  -- http://www.phpmyadmin.net
  -- 
  -- Host: localhost:3306
  -- Generation Time: Mar 27, 2010 at 09:20 AM
  -- Server version: 5.0.77
  -- PHP Version: 5.2.6
  -- 
  -- Database: `joksnet`
  -- 
  
  -- --------------------------------------------------------
  
  -- 
  -- Table structure for table `twcensus_areas`
  -- 
  
  CREATE TABLE `twcensus_areas` (
    `id_area` tinyint(3) unsigned NOT NULL auto_increment,
    `id_country` tinyint(3) unsigned NOT NULL default '0',
    `code` varchar(140) NOT NULL,
    `name` varchar(140) NOT NULL,
    `coordinates` text NOT NULL,
    PRIMARY KEY  (`id_area`)
  ) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 AUTO_INCREMENT=23 ;
  
  -- 
  -- Dumping data for table `twcensus_areas`
  -- 
  
  INSERT INTO `twcensus_areas` (`id_area`, `id_country`, `code`, `name`, `coordinates`) VALUES (1, 1, 'alsace', 'Alsace', '6.823664,47.813267,0 6.904269,47.893268,0 6.942787,47.99453,0 7.033917,48.075736,0 7.082801,48.172488,0 7.151134,48.26526,0 7.089015,48.363959,0 7.118167,48.473838,0 7.202095,48.552634,0 7.278151,48.635541,0 7.293534,48.753231,0 7.203643,48.826831,0 7.091265,48.793173,0 7.019834,48.881795,0 7.039,48.99715,0 7.161604,49.005957,0 7.275194,48.976063,0 7.382051,48.951057,0 7.499834,48.944682,0 7.636219,49.05407,0 7.748308,49.046873,0 7.867957,49.033361,0 7.98351,49.025967,0 8.097209,48.98988,0 8.212894,48.97409,0 8.135143,48.887579,0 8.076678,48.794907,0 7.968969,48.75399,0 7.899999,48.670279,0 7.806616,48.594665,0 7.769336,48.49061,0 7.731865,48.377808,0 7.683941,48.265935,0 7.613543,48.169376,0 7.57381,48.057207,0 7.611062,47.955822,0 7.563465,47.849359,0 7.548134,47.732021,0 7.570351,47.625867,0 7.500413,47.54029,0 7.420858,47.445801,0 7.301976,47.438624,0 7.130059,47.503145,0 7.063287,47.600991,0 7.027764,47.705428,0 6.934167,47.771465,0 6.823664,47.813267,0'),
  (2, 1, 'aquitaine', 'Aquitaine', '-1.791909,43.375614,0 -1.685304,43.396766,0 -1.589962,43.448122,0 -1.522265,43.532249,0 -1.45492,43.633101,0 -1.429468,43.741147,0 -1.397947,43.848021,0 -1.365833,43.953663,0 -1.33578,44.061151,0 -1.308531,44.16901,0 -1.289519,44.277635,0 -1.267399,44.387922,0 -1.252654,44.498842,0 -1.208383,44.611312,0 -1.101277,44.648946,0 -1.137624,44.753952,0 -1.23649,44.683571,0 -1.235319,44.795949,0 -1.217227,44.920879,0 -1.200261,45.041576,0 -1.185271,45.155958,0 -1.166868,45.284873,0 -1.163519,45.395116,0 -1.13492,45.511999,0 -1.051587,45.585785,0 -0.959009,45.520004,0 -0.846543,45.428634,0 -0.758543,45.353188,0 -0.636412,45.317792,0 -0.526823,45.289963,0 -0.421159,45.259221,0 -0.342042,45.167726,0 -0.245305,45.108475,0 -0.130594,45.09695,0 -0.022567,45.144927,0 0.063869,45.222085,0 0.171198,45.247412,0 0.269804,45.304914,0 0.271088,45.420905,0 0.373274,45.476215,0 0.473716,45.538434,0 0.538388,45.63065,0 0.629762,45.714572,0 0.760626,45.670564,0 0.835036,45.581229,0 0.948583,45.614274,0 1.054388,45.555014,0 1.127876,45.475838,0 1.233749,45.440444,0 1.309839,45.35842,0 1.236766,45.268856,0 1.271346,45.154104,0 1.38219,45.105936,0 1.448288,45.019319,0 1.405119,44.863899,0 1.307419,44.800006,0 1.249095,44.708138,0 1.149529,44.656822,0 1.078407,44.574827,0 1.018117,44.476803,0 1.006467,44.365391,0 0.893521,44.358192,0 0.923023,44.243688,0 0.879886,44.1381,0 0.766186,44.111882,0 0.678996,44.033217,0 0.564676,44.05935,0 0.455273,44.050803,0 0.344488,44.012876,0 0.233503,44.022121,0 0.120035,43.995494,0 0.041568,43.903829,0 -0.052924,43.961515,0 -0.17232,43.933185,0 -0.196883,43.821935,0 -0.239741,43.711752,0 -0.252668,43.601369,0 -0.139169,43.582795,0 -0.044583,43.525513,0 -0.042703,43.410454,0 -0.04453,43.290714,0 -0.069008,43.184136,0 -0.164617,43.12227,0 -0.235963,43.039525,0 -0.311877,42.847412,0 -0.425007,42.802769,0 -0.542365,42.794107,0 -0.643867,42.854255,0 -0.730063,42.945592,0 -0.83768,42.953759,0 -0.946835,42.954677,0 -1.051983,42.996635,0 -1.166626,43.035304,0 -1.281969,43.060613,0 -1.393515,43.036315,0 -1.410219,43.15171,0 -1.391312,43.261213,0 -1.506139,43.293507,0 -1.608545,43.252504,0 -1.705244,43.310823,0 -1.791909,43.375614,0'),
  (3, 1, 'auvergne', 'Auvergne', '2.062843,44.976449,0 2.193327,45.135305,0 2.224871,45.242951,0 2.316273,45.32228,0 2.390429,45.409274,0 2.505776,45.409122,0 2.516818,45.517009,0 2.482928,45.630231,0 2.493982,45.737956,0 2.426131,45.834915,0 2.526179,45.895863,0 2.603719,45.981267,0 2.554556,46.084543,0 2.525008,46.20162,0 2.458749,46.289642,0 2.346695,46.325743,0 2.282068,46.420945,0 2.376177,46.518451,0 2.483437,46.532853,0 2.598914,46.548347,0 2.59937,46.666182,0 2.691265,46.724137,0 2.807742,46.733512,0 2.913409,46.791124,0 3.032218,46.794675,0 3.125368,46.728834,0 3.228646,46.696417,0 3.336821,46.684965,0 3.452605,46.687316,0 3.55966,46.716438,0 3.670982,46.671375,0 3.739983,46.581012,0 3.843695,46.528406,0 3.957375,46.490657,0 3.982512,46.383554,0 3.899377,46.276107,0 3.78949,46.212631,0 3.808141,46.101969,0 3.823215,45.987056,0 3.708321,45.972921,0 3.727461,45.859247,0 3.738139,45.747669,0 3.812278,45.65126,0 3.909228,45.59467,0 3.973761,45.499818,0 3.905428,45.412485,0 4.005151,45.351855,0 4.114984,45.367972,0 4.227268,45.389287,0 4.338652,45.365214,0 4.3711,45.25974,0 4.482167,45.235791,0 4.453811,45.127689,0 4.346495,45.074953,0 4.300693,44.970428,0 4.190072,44.914164,0 4.09118,44.870603,0 3.980521,44.8255,0 3.862522,44.744016,0 3.769469,44.804052,0 3.658194,44.834523,0 3.550151,44.826072,0 3.444835,44.852518,0 3.396856,44.958593,0 3.289138,44.929677,0 3.19421,44.871413,0 3.091362,44.833012,0 3.031425,44.742526,0 2.981779,44.645275,0 2.900083,44.784259,0 2.829333,44.872196,0 2.742193,44.938509,0 2.645851,44.871041,0 2.573292,44.785108,0 2.509734,44.694685,0 2.400711,44.645301,0 2.28857,44.666157,0 2.174903,44.669754,0 2.171084,44.785924,0 2.099964,44.86797,0 2.062843,44.976449,0'),
  (4, 1, 'basse-normandie', 'Basse-Normandie', '-1.951647,49.708761,0 -1.840399,49.711981,0 -1.737627,49.678314,0 -1.630101,49.660036,0 -1.520627,49.657327,0 -1.410317,49.702257,0 -1.298276,49.693896,0 -1.266518,49.582871,0 -1.241094,49.472631,0 -1.162663,49.395088,0 -1.05207,49.389633,0 -0.941059,49.395136,0 -0.827682,49.358118,0 -0.714758,49.347323,0 -0.599064,49.339959,0 -0.479219,49.339635,0 -0.359178,49.32235,0 -0.249103,49.291017,0 -0.139938,49.289947,0 -0.034048,49.316486,0 0.069959,49.36766,0 0.272494,49.433157,0 0.314738,49.326938,0 0.356564,49.224135,0 0.426251,49.13233,0 0.438052,49.024487,0 0.387429,48.913348,0 0.501632,48.878155,0 0.615719,48.877421,0 0.697442,48.793243,0 0.814899,48.670273,0 0.926992,48.541833,0 0.963391,48.430271,0 0.878583,48.356681,0 0.771684,48.301929,0 0.797865,48.194888,0 0.597211,48.244909,0 0.495603,48.304877,0 0.386608,48.330607,0 0.363919,48.446065,0 0.261052,48.482136,0 0.158229,48.442718,0 0.062282,48.381238,0 -0.057981,48.388065,0 -0.146588,48.456497,0 -0.206487,48.561474,0 -0.316983,48.521617,0 -0.425729,48.507791,0 -0.539829,48.485876,0 -0.644734,48.44747,0 -0.754198,48.437799,0 -0.845306,48.497137,0 -0.955311,48.517307,0 -1.069999,48.508899,0 -1.181288,48.52997,0 -1.298006,48.501863,0 -1.404223,48.461857,0 -1.507616,48.520711,0 -1.570531,48.626276,0 -1.450704,48.622992,0 -1.517023,48.711568,0 -1.573412,48.818584,0 -1.555416,48.93255,0 -1.598046,49.033689,0 -1.597166,49.160605,0 -1.665406,49.265922,0 -1.752764,49.352879,0 -1.824379,49.438253,0 -1.886763,49.526925,0 -1.850661,49.631389,0 -1.951647,49.708761,0'),
  (5, 1, 'bourgogne', 'Bourgogne', '2.936621,48.163106,0 3.034972,48.250351,0 3.065177,48.357595,0 3.184402,48.368145,0 3.294809,48.37674,0 3.414681,48.390354,0 3.587457,48.293053,0 3.589353,48.180644,0 3.693514,48.147349,0 3.799272,48.107918,0 3.846207,48.003352,0 3.940199,47.933162,0 4.056014,47.942034,0 4.17251,47.959191,0 4.287367,47.927371,0 4.398252,47.965533,0 4.509561,47.966482,0 4.601242,48.030406,0 4.719989,48.008897,0 4.830542,47.961092,0 4.917993,47.896215,0 4.986738,47.802954,0 4.960825,47.696662,0 5.066194,47.667192,0 5.174238,47.655356,0 5.260122,47.578558,0 5.377974,47.602678,0 5.486567,47.527146,0 5.431607,47.433428,0 5.479418,47.331876,0 5.479972,47.219974,0 5.414006,47.129069,0 5.317469,47.068293,0 5.254959,46.970422,0 5.343392,46.89074,0 5.445919,46.828151,0 5.328921,46.816921,0 5.395097,46.719915,0 5.414267,46.600449,0 5.420751,46.488591,0 5.31075,46.44689,0 5.206856,46.486222,0 5.092233,46.49577,0 4.974723,46.514965,0 4.893024,46.442695,0 4.85387,46.333815,0 4.799404,46.227369,0 4.68865,46.250983,0 4.572662,46.280681,0 4.462408,46.2942,0 4.385269,46.212642,0 4.277192,46.15708,0 4.164636,46.172964,0 4.054239,46.183567,0 3.899377,46.276107,0 3.982512,46.383554,0 3.957375,46.490657,0 3.843695,46.528406,0 3.739983,46.581012,0 3.670982,46.671375,0 3.55966,46.716438,0 3.452605,46.687316,0 3.336821,46.684965,0 3.228646,46.696417,0 3.125368,46.728834,0 3.032218,46.794675,0 3.074121,46.947253,0 3.032047,47.0573,0 3.014012,47.168465,0 2.959476,47.276353,0 2.876905,47.35139,0 2.926636,47.447812,0 2.894381,47.554001,0 2.941788,47.656966,0 2.926082,47.764739,0 3.012445,47.834318,0 3.067021,47.930689,0 3.120933,48.032059,0 3.038164,48.10218,0 2.936621,48.163106,0'),
  (6, 1, 'bretagne', 'Bretagne', '-3.20468,48.835096,0 -3.098222,48.86629,0 -3.024274,48.782488,0 -2.92962,48.72072,0 -2.834069,48.654965,0 -2.762314,48.565861,0 -2.651949,48.525307,0 -2.560549,48.585677,0 -2.458728,48.648441,0 -2.341046,48.668986,0 -2.242344,48.62347,0 -2.120964,48.637675,0 -2.008275,48.654646,0 -1.906324,48.690747,0 -1.832314,48.612178,0 -1.715201,48.607422,0 -1.570531,48.626276,0 -1.507616,48.520711,0 -1.404223,48.461857,0 -1.298006,48.501863,0 -1.181288,48.52997,0 -1.069999,48.508899,0 -1.062509,48.393184,0 -1.092768,48.275192,0 -1.072267,48.159126,0 -1.0269,48.045628,0 -1.126849,47.985362,0 -1.192277,47.891246,0 -1.241111,47.790276,0 -1.353866,47.797639,0 -1.469603,47.833996,0 -1.574605,47.778519,0 -1.668184,47.712687,0 -1.776768,47.699102,0 -1.88842,47.695366,0 -2.005044,47.673265,0 -2.091492,47.600861,0 -2.152378,47.510259,0 -2.261296,47.513666,0 -2.459609,47.447904,0 -2.542184,47.523127,0 -2.664679,47.507089,0 -2.778302,47.496011,0 -2.895474,47.537832,0 -2.779683,47.546266,0 -2.684649,47.616954,0 -2.794068,47.619967,0 -2.902234,47.582355,0 -3.013348,47.582034,0 -3.128484,47.561128,0 -3.20899,47.641201,0 -3.322324,47.694255,0 -3.438198,47.698564,0 -3.535048,47.765988,0 -3.645327,47.773796,0 -3.763631,47.790454,0 -3.878122,47.819685,0 -3.957185,47.896097,0 -4.063505,47.857646,0 -4.165521,47.819502,0 -4.277411,47.791071,0 -4.387193,47.809887,0 -4.387117,47.919275,0 -4.473712,47.985125,0 -4.589969,48.006471,0 -4.697579,48.025754,0 -4.598748,48.076257,0 -4.482739,48.091801,0 -4.375813,48.110408,0 -4.308951,48.196461,0 -4.414247,48.222755,0 -4.519743,48.191215,0 -4.60784,48.260691,0 -4.531758,48.3418,0 -4.427057,48.291053,0 -4.317076,48.314094,0 -4.430304,48.330914,0 -4.537053,48.357262,0 -4.652245,48.345705,0 -4.760424,48.328121,0 -4.782643,48.438561,0 -4.750468,48.54372,0 -4.637417,48.575722,0 -4.538873,48.63712,0 -4.42916,48.640919,0 -4.312236,48.673133,0 -4.201783,48.676307,0 -4.08362,48.694119,0 -3.977796,48.726068,0 -3.868551,48.64442,0 -3.76738,48.707707,0 -3.647095,48.695519,0 -3.541372,48.728907,0 -3.493473,48.827258,0 -3.386725,48.811277,0 -3.20468,48.835096,0'),
  (7, 1, 'centre', 'Centre', '0.053536,47.164394,0 0.098652,47.307489,0 0.157336,47.398821,0 0.214051,47.498191,0 0.270461,47.601828,0 0.376366,47.570327,0 0.462603,47.642751,0 0.56947,47.668649,0 0.648002,47.753947,0 0.739953,47.81157,0 0.812684,47.90574,0 0.838656,48.023341,0 0.797865,48.194888,0 0.771684,48.301929,0 0.878583,48.356681,0 0.963391,48.430271,0 0.926992,48.541833,0 0.814899,48.670273,0 0.928298,48.711029,0 1.036337,48.7301,0 1.134733,48.787303,0 1.247741,48.768896,0 1.365778,48.783819,0 1.501407,48.941078,0 1.583157,48.857809,0 1.624682,48.748868,0 1.648876,48.635033,0 1.753466,48.578673,0 1.794038,48.478665,0 1.901518,48.438834,0 1.98493,48.361401,0 2.070754,48.294148,0 2.180948,48.312647,0 2.291541,48.309218,0 2.402434,48.319544,0 2.48857,48.239588,0 2.454785,48.135825,0 2.579435,48.131978,0 2.692148,48.124138,0 2.795553,48.16919,0 2.936621,48.163106,0 3.038164,48.10218,0 3.120933,48.032059,0 3.067021,47.930689,0 3.012445,47.834318,0 2.926082,47.764739,0 2.941788,47.656966,0 2.894381,47.554001,0 2.926636,47.447812,0 2.876905,47.35139,0 2.959476,47.276353,0 3.014012,47.168465,0 3.032047,47.0573,0 3.074121,46.947253,0 3.032218,46.794675,0 2.913409,46.791124,0 2.807742,46.733512,0 2.691265,46.724137,0 2.59937,46.666182,0 2.598914,46.548347,0 2.483437,46.532853,0 2.376177,46.518451,0 2.282068,46.420945,0 2.063993,46.421347,0 1.945408,46.434522,0 1.837651,46.428197,0 1.728828,46.393494,0 1.617605,46.41108,0 1.508875,46.412073,0 1.40946,46.361361,0 1.292477,46.374936,0 1.17732,46.38392,0 1.105929,46.532644,0 0.996392,46.565723,0 0.897043,46.634349,0 0.876565,46.743236,0 0.799509,46.832182,0 0.711146,46.898958,0 0.647303,46.988523,0 0.531107,46.957083,0 0.414195,46.936802,0 0.307938,46.962864,0 0.267814,47.067853,0 0.149722,47.104636,0 0.053536,47.164394,0'),
  (8, 1, 'champagne-ardenne', 'Champagne-Ardenne', '3.485325,48.852066,0 3.584006,48.945956,0 3.667464,49.031688,0 3.6105,49.127261,0 3.668176,49.225875,0 3.702048,49.332699,0 3.819885,49.357323,0 3.920986,49.404795,0 4.038887,49.38789,0 4.050142,49.508319,0 4.035099,49.622767,0 4.131976,49.677403,0 4.226239,49.73485,0 4.242605,49.850278,0 4.232908,49.957866,0 4.352228,49.952506,0 4.460191,49.941664,0 4.567857,49.972449,0 4.674773,49.996614,0 4.716147,50.100924,0 4.819661,50.165062,0 4.827586,50.053382,0 4.850084,49.94615,0 4.868107,49.831295,0 4.97613,49.80108,0 5.090048,49.765329,0 5.176456,49.694189,0 5.290067,49.68107,0 5.393708,49.617231,0 5.29124,49.554517,0 5.175889,49.566107,0 5.074769,49.507951,0 5.094194,49.395919,0 5.040772,49.300966,0 4.981323,49.203645,0 4.997476,49.090112,0 5.007391,48.978917,0 4.914615,48.899985,0 4.930419,48.791221,0 5.012586,48.715496,0 5.065123,48.607574,0 5.170493,48.561182,0 5.269953,48.515508,0 5.371234,48.474927,0 5.441025,48.380529,0 5.544415,48.315382,0 5.649702,48.270251,0 5.730637,48.19587,0 5.656189,48.105839,0 5.749999,48.042551,0 5.884711,47.92583,0 5.790599,47.855554,0 5.681923,47.806246,0 5.694117,47.690425,0 5.584772,47.698844,0 5.46906,47.674912,0 5.377974,47.602678,0 5.260122,47.578558,0 5.174238,47.655356,0 5.066194,47.667192,0 4.960825,47.696662,0 4.986738,47.802954,0 4.917993,47.896215,0 4.830542,47.961092,0 4.719989,48.008897,0 4.601242,48.030406,0 4.509561,47.966482,0 4.398252,47.965533,0 4.287367,47.927371,0 4.17251,47.959191,0 4.056014,47.942034,0 3.940199,47.933162,0 3.846207,48.003352,0 3.799272,48.107918,0 3.693514,48.147349,0 3.589353,48.180644,0 3.587457,48.293053,0 3.414681,48.390354,0 3.478131,48.53995,0 3.550137,48.623988,0 3.44507,48.668846,0 3.401433,48.76793,0 3.485325,48.852066,0'),
  (9, 1, 'corse', 'Corse', '9.381494,41.688176,0 9.292731,41.609173,0 9.285821,41.495759,0 9.212884,41.414248,0 9.094201,41.393675,0 9.014992,41.470876,0 8.905758,41.507593,0 8.801496,41.556801,0 8.865703,41.64816,0 8.773799,41.721339,0 8.784414,41.831826,0 8.74205,41.931239,0 8.629907,41.906472,0 8.658463,42.010562,0 8.696142,42.114288,0 8.582807,42.151635,0 8.626371,42.251401,0 8.555485,42.333669,0 8.628777,42.420683,0 8.677279,42.517677,0 8.780887,42.556686,0 8.880398,42.620337,0 8.988702,42.640343,0 9.081591,42.701949,0 9.191193,42.726248,0 9.28955,42.67477,0 9.341354,42.777933,0 9.327278,42.890215,0 9.351618,43.001976,0 9.459966,42.987671,0 9.480472,42.868752,0 9.466215,42.750598,0 9.469275,42.631584,0 9.53298,42.534609,0 9.539215,42.414997,0 9.5534,42.299205,0 9.556229,42.183073,0 9.512288,42.0655,0 9.430332,41.978133,0 9.397396,41.872529,0 9.381494,41.688176,0'),
  (10, 1, 'franche-comte', 'Franche-Comté', '5.377974,47.602678,0 5.46906,47.674912,0 5.584772,47.698844,0 5.694117,47.690425,0 5.681923,47.806246,0 5.790599,47.855554,0 5.884711,47.92583,0 5.993452,47.957483,0 6.087966,48.013954,0 6.18249,47.956123,0 6.300981,47.953964,0 6.424371,47.943579,0 6.535322,47.901701,0 6.645623,47.903788,0 6.823664,47.813267,0 6.934167,47.771465,0 7.027764,47.705428,0 7.063287,47.600991,0 7.130059,47.503145,0 7.021574,47.504399,0 6.941346,47.41914,0 7.048276,47.362371,0 6.962493,47.291311,0 6.885222,47.202985,0 6.797879,47.129181,0 6.700311,47.069835,0 6.618096,46.991553,0 6.499999,46.970369,0 6.461755,46.865723,0 6.430244,46.756717,0 6.332454,46.707752,0 6.230903,46.651466,0 6.129896,46.591457,0 6.063855,46.416302,0 5.974455,46.349491,0 5.8841,46.275268,0 5.774472,46.266508,0 5.675036,46.319078,0 5.564824,46.293574,0 5.456673,46.274805,0 5.375105,46.350607,0 5.31075,46.44689,0 5.420751,46.488591,0 5.414267,46.600449,0 5.395097,46.719915,0 5.328921,46.816921,0 5.445919,46.828151,0 5.343392,46.89074,0 5.254959,46.970422,0 5.317469,47.068293,0 5.414006,47.129069,0 5.479972,47.219974,0 5.479418,47.331876,0 5.431607,47.433428,0 5.486567,47.527146,0 5.377974,47.602678,0'),
  (11, 1, 'haute-normandie', 'Haute-Normandie', '0.15509,49.659102,0 0.252542,49.727078,0 0.364906,49.764538,0 0.470716,49.80404,0 0.582422,49.852497,0 0.695945,49.871514,0 0.813597,49.882765,0 0.92895,49.906859,0 1.048259,49.922284,0 1.161119,49.956748,0 1.263305,50.007611,0 1.381457,50.067325,0 1.490989,50.018747,0 1.583007,49.961522,0 1.679777,49.912796,0 1.737477,49.808186,0 1.694496,49.696522,0 1.718904,49.589584,0 1.790743,49.497862,0 1.716791,49.417213,0 1.708885,49.233916,0 1.658238,49.134528,0 1.568172,49.074969,0 1.457276,49.057853,0 1.501407,48.941078,0 1.365778,48.783819,0 1.247741,48.768896,0 1.134733,48.787303,0 1.036337,48.7301,0 0.928298,48.711029,0 0.814899,48.670273,0 0.697442,48.793243,0 0.615719,48.877421,0 0.501632,48.878155,0 0.387429,48.913348,0 0.438052,49.024487,0 0.426251,49.13233,0 0.356564,49.224135,0 0.314738,49.326938,0 0.272494,49.433157,0 0.163784,49.454023,0 0.066583,49.512216,0 0.15509,49.659102,0'),
  (12, 1, 'ile-de-france', 'Île-de-France', '1.708885,49.233916,0 1.844093,49.169947,0 1.963077,49.175114,0 2.077146,49.208545,0 2.192579,49.173492,0 2.313681,49.187408,0 2.42442,49.152522,0 2.541191,49.116377,0 2.658487,49.096046,0 2.772182,49.083714,0 2.887454,49.079342,0 3.010692,49.093721,0 3.119531,49.109112,0 3.167572,49.01245,0 3.260493,48.944398,0 3.370197,48.895503,0 3.485325,48.852066,0 3.401433,48.76793,0 3.44507,48.668846,0 3.550137,48.623988,0 3.478131,48.53995,0 3.414681,48.390354,0 3.294809,48.37674,0 3.184402,48.368145,0 3.065177,48.357595,0 3.034972,48.250351,0 2.936621,48.163106,0 2.795553,48.16919,0 2.692148,48.124138,0 2.579435,48.131978,0 2.454785,48.135825,0 2.48857,48.239588,0 2.402434,48.319544,0 2.291541,48.309218,0 2.180948,48.312647,0 2.070754,48.294148,0 1.98493,48.361401,0 1.901518,48.438834,0 1.794038,48.478665,0 1.753466,48.578673,0 1.648876,48.635033,0 1.624682,48.748868,0 1.583157,48.857809,0 1.501407,48.941078,0 1.457276,49.057853,0 1.568172,49.074969,0 1.658238,49.134528,0 1.708885,49.233916,0'),
  (13, 1, 'languedoc-roussillon', 'Languedoc-Roussillon', '1.68881,43.273538,0 1.819168,43.411719,0 1.934492,43.42536,0 2.045822,43.433738,0 2.153086,43.416908,0 2.25885,43.460895,0 2.371593,43.423342,0 2.479096,43.436543,0 2.596329,43.429554,0 2.672131,43.517312,0 2.634233,43.629309,0 2.744103,43.619698,0 2.85732,43.643253,0 2.952782,43.695071,0 3.06126,43.697472,0 3.053466,43.807123,0 3.165033,43.815194,0 3.254438,43.87698,0 3.354378,43.943837,0 3.385781,44.057361,0 3.275489,44.083874,0 3.282048,44.200629,0 3.177671,44.246623,0 3.127389,44.346985,0 3.121451,44.465732,0 3.071947,44.574928,0 2.981779,44.645275,0 3.031425,44.742526,0 3.091362,44.833012,0 3.19421,44.871413,0 3.289138,44.929677,0 3.396856,44.958593,0 3.444835,44.852518,0 3.550151,44.826072,0 3.658194,44.834523,0 3.769469,44.804052,0 3.862522,44.744016,0 3.892471,44.626446,0 3.965863,44.539822,0 4.022714,44.445767,0 4.050173,44.335055,0 4.164108,44.312107,0 4.274224,44.272652,0 4.362253,44.339983,0 4.47573,44.340598,0 4.649319,44.270198,0 4.719783,44.177587,0 4.772688,44.070456,0 4.842301,43.986967,0 4.745283,43.929544,0 4.652274,43.871071,0 4.62454,43.753751,0 4.507398,43.702411,0 4.426542,43.625936,0 4.350079,43.546424,0 4.230171,43.46058,0 4.11788,43.498843,0 4.018773,43.553839,0 3.90787,43.517001,0 3.814,43.454371,0 3.708585,43.395801,0 3.586816,43.342883,0 3.498126,43.274794,0 3.376226,43.280489,0 3.27185,43.233742,0 3.177051,43.164633,0 3.097546,43.074346,0 3.048551,42.977208,0 3.048917,42.860224,0 3.039484,42.746812,0 3.036514,42.632623,0 3.084348,42.529609,0 3.167386,42.456903,0 3.058209,42.445674,0 2.948448,42.479974,0 2.835009,42.454071,0 2.719162,42.421817,0 2.63796,42.343366,0 2.525976,42.333446,0 2.424813,42.392737,0 2.319505,42.421514,0 2.203002,42.417117,0 2.099552,42.37685,0 1.992169,42.359458,0 1.923656,42.449001,0 1.786285,42.574684,0 1.915658,42.610895,0 2.0201,42.654641,0 2.146961,42.701105,0 2.0471,42.748804,0 1.936496,42.750213,0 1.860417,42.827945,0 1.978007,42.868047,0 1.984345,42.976772,0 1.955048,43.092337,0 1.854875,43.151314,0 1.747986,43.175343,0 1.68881,43.273538,0'),
  (14, 1, 'limousin', 'Limousin', '0.629762,45.714572,0 0.78166,45.82076,0 0.84107,45.923718,0 0.923875,45.995111,0 0.824336,46.045748,0 0.830991,46.153686,0 0.869316,46.263906,0 0.976786,46.285188,0 1.059559,46.361581,0 1.17732,46.38392,0 1.292477,46.374936,0 1.40946,46.361361,0 1.508875,46.412073,0 1.617605,46.41108,0 1.728828,46.393494,0 1.837651,46.428197,0 1.945408,46.434522,0 2.063993,46.421347,0 2.282068,46.420945,0 2.346695,46.325743,0 2.458749,46.289642,0 2.525008,46.20162,0 2.554556,46.084543,0 2.603719,45.981267,0 2.526179,45.895863,0 2.426131,45.834915,0 2.493982,45.737956,0 2.482928,45.630231,0 2.516818,45.517009,0 2.505776,45.409122,0 2.390429,45.409274,0 2.316273,45.32228,0 2.224871,45.242951,0 2.193327,45.135305,0 2.062843,44.976449,0 1.94507,44.953193,0 1.832546,44.946151,0 1.725989,44.96775,0 1.625706,45.033715,0 1.448288,45.019319,0 1.38219,45.105936,0 1.271346,45.154104,0 1.236766,45.268856,0 1.309839,45.35842,0 1.233749,45.440444,0 1.127876,45.475838,0 1.054388,45.555014,0 0.948583,45.614274,0 0.835036,45.581229,0 0.760626,45.670564,0 0.629762,45.714572,0'),
  (15, 1, 'lorraine', 'Lorraine', '5.393708,49.617231,0 5.460635,49.524978,0 5.571124,49.527897,0 5.679087,49.548959,0 5.791377,49.552906,0 5.886828,49.498383,0 5.998119,49.45643,0 6.116903,49.471176,0 6.228044,49.509936,0 6.340352,49.468376,0 6.462687,49.464945,0 6.552435,49.394143,0 6.616873,49.301623,0 6.701833,49.216661,0 6.800774,49.162392,0 6.905235,49.214377,0 7.010357,49.189791,0 7.117248,49.140308,0 7.227022,49.125824,0 7.341466,49.145168,0 7.445258,49.184142,0 7.529059,49.102468,0 7.636219,49.05407,0 7.499834,48.944682,0 7.382051,48.951057,0 7.275194,48.976063,0 7.161604,49.005957,0 7.039,48.99715,0 7.019834,48.881795,0 7.091265,48.793173,0 7.203643,48.826831,0 7.293534,48.753231,0 7.278151,48.635541,0 7.202095,48.552634,0 7.118167,48.473838,0 7.089015,48.363959,0 7.151134,48.26526,0 7.082801,48.172488,0 7.033917,48.075736,0 6.942787,47.99453,0 6.904269,47.893268,0 6.823664,47.813267,0 6.645623,47.903788,0 6.535322,47.901701,0 6.424371,47.943579,0 6.300981,47.953964,0 6.18249,47.956123,0 6.087966,48.013954,0 5.993452,47.957483,0 5.884711,47.92583,0 5.749999,48.042551,0 5.656189,48.105839,0 5.730637,48.19587,0 5.649702,48.270251,0 5.544415,48.315382,0 5.441025,48.380529,0 5.371234,48.474927,0 5.269953,48.515508,0 5.170493,48.561182,0 5.065123,48.607574,0 5.012586,48.715496,0 4.930419,48.791221,0 4.914615,48.899985,0 5.007391,48.978917,0 4.997476,49.090112,0 4.981323,49.203645,0 5.040772,49.300966,0 5.094194,49.395919,0 5.074769,49.507951,0 5.175889,49.566107,0 5.29124,49.554517,0 5.393708,49.617231,0'),
  (16, 1, 'midi-pyrenees', 'Midi-Pyrénées', '-0.311877,42.847412,0 -0.235963,43.039525,0 -0.164617,43.12227,0 -0.069008,43.184136,0 -0.04453,43.290714,0 -0.042703,43.410454,0 -0.044583,43.525513,0 -0.139169,43.582795,0 -0.252668,43.601369,0 -0.239741,43.711752,0 -0.196883,43.821935,0 -0.17232,43.933185,0 -0.052924,43.961515,0 0.041568,43.903829,0 0.120035,43.995494,0 0.233503,44.022121,0 0.344488,44.012876,0 0.455273,44.050803,0 0.564676,44.05935,0 0.678996,44.033217,0 0.766186,44.111882,0 0.879886,44.1381,0 0.923023,44.243688,0 0.893521,44.358192,0 1.006467,44.365391,0 1.018117,44.476803,0 1.078407,44.574827,0 1.149529,44.656822,0 1.249095,44.708138,0 1.307419,44.800006,0 1.405119,44.863899,0 1.448288,45.019319,0 1.625706,45.033715,0 1.725989,44.96775,0 1.832546,44.946151,0 1.94507,44.953193,0 2.062843,44.976449,0 2.099964,44.86797,0 2.171084,44.785924,0 2.174903,44.669754,0 2.28857,44.666157,0 2.400711,44.645301,0 2.509734,44.694685,0 2.573292,44.785108,0 2.645851,44.871041,0 2.742193,44.938509,0 2.829333,44.872196,0 2.900083,44.784259,0 2.981779,44.645275,0 3.071947,44.574928,0 3.121451,44.465732,0 3.127389,44.346985,0 3.177671,44.246623,0 3.282048,44.200629,0 3.275489,44.083874,0 3.385781,44.057361,0 3.354378,43.943837,0 3.254438,43.87698,0 3.165033,43.815194,0 3.053466,43.807123,0 3.06126,43.697472,0 2.952782,43.695071,0 2.85732,43.643253,0 2.744103,43.619698,0 2.634233,43.629309,0 2.672131,43.517312,0 2.596329,43.429554,0 2.479096,43.436543,0 2.371593,43.423342,0 2.25885,43.460895,0 2.153086,43.416908,0 2.045822,43.433738,0 1.934492,43.42536,0 1.819168,43.411719,0 1.68881,43.273538,0 1.747986,43.175343,0 1.854875,43.151314,0 1.955048,43.092337,0 1.984345,42.976772,0 1.978007,42.868047,0 1.860417,42.827945,0 1.936496,42.750213,0 2.0471,42.748804,0 2.146961,42.701105,0 2.0201,42.654641,0 1.915658,42.610895,0 1.786285,42.574684,0 1.676788,42.623681,0 1.566425,42.650236,0 1.442608,42.60351,0 1.376573,42.694396,0 1.265482,42.715515,0 1.156894,42.714305,0 1.072837,42.782632,0 0.953843,42.802594,0 0.843844,42.828966,0 0.73574,42.84879,0 0.651556,42.778388,0 0.573821,42.695143,0 0.462243,42.693953,0 0.347792,42.713976,0 0.238493,42.717879,0 0.124055,42.713542,0 0.011427,42.69176,0 -0.106339,42.72074,0 -0.19994,42.796171,0 -0.311877,42.847412,0'),
  (17, 1, 'nord-pas-de-calais', 'Nord-Pas-de-Calais', '4.146411,49.975647,0 3.943658,50.029831,0 3.825095,50.043148,0 3.713297,50.06797,0 3.608892,50.030121,0 3.494962,50.021921,0 3.385675,50.032049,0 3.268481,50.030208,0 3.15443,50.019253,0 3.042552,50.054885,0 2.933103,50.043342,0 2.81612,50.061252,0 2.706959,50.084065,0 2.595288,50.107621,0 2.491148,50.137767,0 2.381549,50.12747,0 2.431504,50.227482,0 2.319603,50.220035,0 2.200616,50.213092,0 2.085768,50.202735,0 1.998767,50.273934,0 1.891176,50.318255,0 1.77893,50.360726,0 1.665137,50.334062,0 1.560383,50.393708,0 1.559445,50.436145,0 1.563235,50.554779,0 1.569384,50.669897,0 1.601456,50.776173,0 1.643086,50.884654,0 1.744582,50.943869,0 1.870446,50.974937,0 1.983444,51.002648,0 2.106447,51.004212,0 2.224436,51.03581,0 2.335386,51.056879,0 2.45522,51.063698,0 2.564191,51.051061,0 2.626806,50.955681,0 2.602738,50.848616,0 2.71886,50.813086,0 2.799628,50.723719,0 2.910793,50.694526,0 3.007066,50.766785,0 3.120926,50.79074,0 3.208212,50.711215,0 3.268316,50.612948,0 3.320714,50.516501,0 3.435923,50.509162,0 3.544491,50.497258,0 3.651014,50.463151,0 3.667398,50.355166,0 3.783562,50.353404,0 3.888394,50.327383,0 4.003196,50.349861,0 4.106006,50.306793,0 4.212948,50.267071,0 4.149822,50.176145,0 4.217433,50.087784,0 4.146411,49.975647,0'),
  (18, 1, 'pays-de-la-loire', 'Pays-de-la-Loire', '-2.459609,47.447904,0 -2.261296,47.513666,0 -2.152378,47.510259,0 -2.091492,47.600861,0 -2.005044,47.673265,0 -1.88842,47.695366,0 -1.776768,47.699102,0 -1.668184,47.712687,0 -1.574605,47.778519,0 -1.469603,47.833996,0 -1.353866,47.797639,0 -1.241111,47.790276,0 -1.192277,47.891246,0 -1.126849,47.985362,0 -1.0269,48.045628,0 -1.072267,48.159126,0 -1.092768,48.275192,0 -1.062509,48.393184,0 -1.069999,48.508899,0 -0.955311,48.517307,0 -0.845306,48.497137,0 -0.754198,48.437799,0 -0.644734,48.44747,0 -0.539829,48.485876,0 -0.425729,48.507791,0 -0.316983,48.521617,0 -0.206487,48.561474,0 -0.146588,48.456497,0 -0.057981,48.388065,0 0.062282,48.381238,0 0.158229,48.442718,0 0.261052,48.482136,0 0.363919,48.446065,0 0.386608,48.330607,0 0.495603,48.304877,0 0.597211,48.244909,0 0.797865,48.194888,0 0.838656,48.023341,0 0.812684,47.90574,0 0.739953,47.81157,0 0.648002,47.753947,0 0.56947,47.668649,0 0.462603,47.642751,0 0.376366,47.570327,0 0.270461,47.601828,0 0.214051,47.498191,0 0.157336,47.398821,0 0.098652,47.307489,0 0.053536,47.164394,0 -0.121073,47.057465,0 -0.222303,47.100278,0 -0.341005,47.090487,0 -0.459388,47.081873,0 -0.554458,47.02942,0 -0.662869,46.997552,0 -0.773474,47.004086,0 -0.866668,46.945991,0 -0.797793,46.8624,0 -0.727146,46.767614,0 -0.663243,46.67892,0 -0.624339,46.575325,0 -0.616821,46.466336,0 -0.585993,46.357001,0 -0.688747,46.322023,0 -0.80865,46.338756,0 -0.920915,46.31246,0 -1.029983,46.351599,0 -1.132688,46.304474,0 -1.243301,46.287081,0 -1.35465,46.340729,0 -1.472128,46.343802,0 -1.568418,46.405414,0 -1.673932,46.436283,0 -1.775306,46.487568,0 -1.847801,46.584291,0 -1.928276,46.674116,0 -2.023287,46.750491,0 -2.119698,46.804351,0 -2.166933,46.905991,0 -2.265363,46.961192,0 -2.157596,46.950788,0 -2.046056,46.977875,0 -2.053365,47.094446,0 -2.16276,47.114964,0 -2.182441,47.232319,0 -2.292516,47.234999,0 -2.396941,47.280124,0 -2.511196,47.281039,0 -2.556875,47.380482,0 -2.459609,47.447904,0'),
  (19, 1, 'picardie', 'Picardie', '1.381457,50.067325,0 1.471391,50.14909,0 1.567049,50.217708,0 1.673478,50.174303,0 1.578534,50.258042,0 1.560383,50.393708,0 1.665137,50.334062,0 1.77893,50.360726,0 1.891176,50.318255,0 1.998767,50.273934,0 2.085768,50.202735,0 2.200616,50.213092,0 2.319603,50.220035,0 2.431504,50.227482,0 2.381549,50.12747,0 2.491148,50.137767,0 2.595288,50.107621,0 2.706959,50.084065,0 2.81612,50.061252,0 2.933103,50.043342,0 3.042552,50.054885,0 3.15443,50.019253,0 3.268481,50.030208,0 3.385675,50.032049,0 3.494962,50.021921,0 3.608892,50.030121,0 3.713297,50.06797,0 3.825095,50.043148,0 3.943658,50.029831,0 4.146411,49.975647,0 4.232908,49.957866,0 4.242605,49.850278,0 4.226239,49.73485,0 4.131976,49.677403,0 4.035099,49.622767,0 4.050142,49.508319,0 4.038887,49.38789,0 3.920986,49.404795,0 3.819885,49.357323,0 3.702048,49.332699,0 3.668176,49.225875,0 3.6105,49.127261,0 3.667464,49.031688,0 3.584006,48.945956,0 3.485325,48.852066,0 3.370197,48.895503,0 3.260493,48.944398,0 3.167572,49.01245,0 3.119531,49.109112,0 3.010692,49.093721,0 2.887454,49.079342,0 2.772182,49.083714,0 2.658487,49.096046,0 2.541191,49.116377,0 2.42442,49.152522,0 2.313681,49.187408,0 2.192579,49.173492,0 2.077146,49.208545,0 1.963077,49.175114,0 1.844093,49.169947,0 1.708885,49.233916,0 1.716791,49.417213,0 1.790743,49.497862,0 1.718904,49.589584,0 1.694496,49.696522,0 1.737477,49.808186,0 1.679777,49.912796,0 1.583007,49.961522,0 1.490989,50.018747,0 1.381457,50.067325,0'),
  (20, 1, 'poitou-charentes', 'Poitou-Charentes', '-1.132688,46.304474,0 -1.029983,46.351599,0 -0.920915,46.31246,0 -0.80865,46.338756,0 -0.688747,46.322023,0 -0.585993,46.357001,0 -0.616821,46.466336,0 -0.624339,46.575325,0 -0.663243,46.67892,0 -0.727146,46.767614,0 -0.797793,46.8624,0 -0.866668,46.945991,0 -0.773474,47.004086,0 -0.662869,46.997552,0 -0.554458,47.02942,0 -0.459388,47.081873,0 -0.341005,47.090487,0 -0.222303,47.100278,0 -0.121073,47.057465,0 0.053536,47.164394,0 0.149722,47.104636,0 0.267814,47.067853,0 0.307938,46.962864,0 0.414195,46.936802,0 0.531107,46.957083,0 0.647303,46.988523,0 0.711146,46.898958,0 0.799509,46.832182,0 0.876565,46.743236,0 0.897043,46.634349,0 0.996392,46.565723,0 1.105929,46.532644,0 1.17732,46.38392,0 1.059559,46.361581,0 0.976786,46.285188,0 0.869316,46.263906,0 0.830991,46.153686,0 0.824336,46.045748,0 0.923875,45.995111,0 0.84107,45.923718,0 0.78166,45.82076,0 0.629762,45.714572,0 0.538388,45.63065,0 0.473716,45.538434,0 0.373274,45.476215,0 0.271088,45.420905,0 0.269804,45.304914,0 0.171198,45.247412,0 0.063869,45.222085,0 -0.022567,45.144927,0 -0.130594,45.09695,0 -0.245305,45.108475,0 -0.342042,45.167726,0 -0.421159,45.259221,0 -0.526823,45.289963,0 -0.636412,45.317792,0 -0.758543,45.353188,0 -0.846543,45.428634,0 -0.959009,45.520004,0 -1.051587,45.585785,0 -1.133029,45.657191,0 -1.238616,45.701091,0 -1.176341,45.793957,0 -1.259995,45.866437,0 -1.350854,45.92546,0 -1.404799,46.027958,0 -1.302622,45.990631,0 -1.220853,45.911407,0 -1.118703,45.86022,0 -1.082693,45.966458,0 -1.094634,46.076142,0 -1.173646,46.152897,0 -1.28848,46.144858,0 -1.392917,46.177036,0 -1.503127,46.193368,0 -1.383962,46.204857,0 -1.278394,46.16293,0 -1.132688,46.304474,0'),
  (21, 1, 'provence-alpes-cote-d-azur', 'Provence-Alpes-Côte d''Azur', '4.230171,43.46058,0 4.350079,43.546424,0 4.426542,43.625936,0 4.507398,43.702411,0 4.62454,43.753751,0 4.652274,43.871071,0 4.745283,43.929544,0 4.842301,43.986967,0 4.772688,44.070456,0 4.719783,44.177587,0 4.649319,44.270198,0 4.765324,44.322852,0 4.851761,44.243445,0 4.961503,44.275241,0 5.076275,44.284976,0 5.168155,44.225423,0 5.280423,44.219794,0 5.383087,44.162138,0 5.493624,44.115529,0 5.576884,44.188179,0 5.681727,44.235281,0 5.623584,44.333724,0 5.50211,44.343765,0 5.419908,44.422646,0 5.503314,44.492045,0 5.612672,44.470837,0 5.625724,44.589606,0 5.730178,44.639746,0 5.813708,44.719449,0 5.92494,44.757018,0 6.016933,44.834235,0 6.12294,44.855317,0 6.243686,44.85318,0 6.354282,44.89539,0 6.317797,45.003853,0 6.214297,45.037428,0 6.297466,45.108951,0 6.403375,45.064547,0 6.512025,45.108411,0 6.631388,45.110116,0 6.706766,45.021734,0 6.751429,44.918479,0 6.85173,44.857572,0 6.966195,44.849123,0 7.021504,44.752045,0 6.954093,44.66041,0 6.904832,44.55632,0 6.926239,44.444088,0 6.927771,44.33232,0 7.002206,44.243108,0 7.115965,44.216743,0 7.224557,44.169158,0 7.333841,44.144646,0 7.451398,44.128029,0 7.567685,44.154829,0 7.677033,44.17665,0 7.713072,44.074897,0 7.65583,43.982772,0 7.564176,43.921242,0 7.514394,43.815988,0 7.426773,43.742799,0 7.334801,43.682807,0 7.221138,43.657402,0 7.125825,43.596505,0 7.029844,43.540144,0 6.928656,43.474919,0 6.83686,43.416506,0 6.730218,43.398659,0 6.660242,43.313761,0 6.676101,43.204391,0 6.56081,43.188879,0 6.447412,43.151397,0 6.355184,43.08945,0 6.237687,43.113225,0 6.152026,43.037498,0 6.044852,43.079208,0 5.940378,43.107809,0 5.838264,43.049507,0 5.770603,43.138965,0 5.662278,43.181893,0 5.548679,43.195037,0 5.440254,43.206041,0 5.357582,43.276543,0 5.280341,43.352322,0 5.17148,43.331295,0 5.062864,43.331453,0 4.975674,43.401026,0 4.863753,43.444845,0 4.832709,43.333531,0 4.716948,43.34945,0 4.600749,43.354603,0 4.532998,43.450577,0 4.409915,43.443935,0 4.230171,43.46058,0'),
  (22, 1, 'rhone-alpes', 'Rhône-Alpes', '3.708321,45.972921,0 3.823215,45.987056,0 3.808141,46.101969,0 3.78949,46.212631,0 3.899377,46.276107,0 4.054239,46.183567,0 4.164636,46.172964,0 4.277192,46.15708,0 4.385269,46.212642,0 4.462408,46.2942,0 4.572662,46.280681,0 4.68865,46.250983,0 4.799404,46.227369,0 4.85387,46.333815,0 4.893024,46.442695,0 4.974723,46.514965,0 5.092233,46.49577,0 5.206856,46.486222,0 5.31075,46.44689,0 5.375105,46.350607,0 5.456673,46.274805,0 5.564824,46.293574,0 5.675036,46.319078,0 5.774472,46.266508,0 5.8841,46.275268,0 5.974455,46.349491,0 6.063855,46.416302,0 6.163389,46.373318,0 6.104519,46.280519,0 6.009403,46.226972,0 5.955894,46.132324,0 6.075116,46.148843,0 6.185905,46.164366,0 6.289228,46.223047,0 6.219509,46.311819,0 6.317301,46.393735,0 6.425438,46.415644,0 6.534731,46.45615,0 6.669009,46.454886,0 6.777615,46.435564,0 6.799808,46.32035,0 6.807478,46.208365,0 6.87999,46.123791,0 6.953856,46.043682,0 7.044647,45.922588,0 6.949608,45.857353,0 6.833495,45.837566,0 6.818529,45.719394,0 6.916759,45.659656,0 6.990292,45.579155,0 7.047823,45.481283,0 7.147717,45.42445,0 7.110482,45.321122,0 7.071782,45.212316,0 6.964229,45.194295,0 6.86858,45.132618,0 6.752967,45.146813,0 6.631388,45.110116,0 6.512025,45.108411,0 6.403375,45.064547,0 6.297466,45.108951,0 6.214297,45.037428,0 6.317797,45.003853,0 6.354282,44.89539,0 6.243686,44.85318,0 6.12294,44.855317,0 6.016933,44.834235,0 5.92494,44.757018,0 5.813708,44.719449,0 5.730178,44.639746,0 5.625724,44.589606,0 5.612672,44.470837,0 5.503314,44.492045,0 5.419908,44.422646,0 5.50211,44.343765,0 5.623584,44.333724,0 5.681727,44.235281,0 5.576884,44.188179,0 5.493624,44.115529,0 5.383087,44.162138,0 5.280423,44.219794,0 5.168155,44.225423,0 5.076275,44.284976,0 4.961503,44.275241,0 4.851761,44.243445,0 4.765324,44.322852,0 4.649319,44.270198,0 4.47573,44.340598,0 4.362253,44.339983,0 4.274224,44.272652,0 4.164108,44.312107,0 4.050173,44.335055,0 4.022714,44.445767,0 3.965863,44.539822,0 3.892471,44.626446,0 3.862522,44.744016,0 3.980521,44.8255,0 4.09118,44.870603,0 4.190072,44.914164,0 4.300693,44.970428,0 4.346495,45.074953,0 4.453811,45.127689,0 4.482167,45.235791,0 4.3711,45.25974,0 4.338652,45.365214,0 4.227268,45.389287,0 4.114984,45.367972,0 4.005151,45.351855,0 3.905428,45.412485,0 3.973761,45.499818,0 3.909228,45.59467,0 3.812278,45.65126,0 3.738139,45.747669,0 3.727461,45.859247,0 3.708321,45.972921,0');
  
  -- --------------------------------------------------------
  
  -- 
  -- Table structure for table `twcensus_countries`
  -- 
  
  CREATE TABLE `twcensus_countries` (
    `id_country` tinyint(3) unsigned NOT NULL auto_increment,
    `iso` tinyint(3) unsigned NOT NULL default '0',
    `code` varchar(140) NOT NULL,
    `name` varchar(140) NOT NULL,
    `coordinates` text NOT NULL,
    PRIMARY KEY  (`id_country`)
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
  
  -- 
  -- Dumping data for table `twcensus_countries`
  -- 
  
  INSERT INTO `twcensus_countries` (`id_country`, `iso`, `code`, `name`, `coordinates`) VALUES (1, 250, 'france', 'France', '2.065972,50.94412 8.142361,49.006371 8.4,42.214144 3.038194,42.763881 -1.614583,43.435745 -4.704861,48.385608');
  
  -- --------------------------------------------------------
  
  -- 
  -- Table structure for table `twcensus_localities`
  -- 
  
  CREATE TABLE `twcensus_localities` (
    `id_locality` mediumint(6) unsigned NOT NULL auto_increment,
    `id_area` tinyint(3) unsigned NOT NULL default '0',
    `code` varchar(140) NOT NULL,
    `name` varchar(140) NOT NULL,
    PRIMARY KEY  (`id_locality`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
  
  -- 
  -- Dumping data for table `twcensus_localities`
  -- 
  
  
  -- --------------------------------------------------------
  
  -- 
  -- Table structure for table `twcensus_users`
  -- 
  
  CREATE TABLE `twcensus_users` (
    `id_user` int(12) unsigned NOT NULL default '0',
    `id_country` tinyint(3) NOT NULL default '0',
    `id_area` tinyint(3) unsigned NOT NULL default '0',
    `id_locality` mediumint(6) unsigned NOT NULL default '0',
    `name` varchar(140) NOT NULL,
    `username` varchar(140) NOT NULL,
    `location` varchar(140) NOT NULL,
    `description` varchar(160) NOT NULL,
    `image` varchar(255) NOT NULL,
    `url` varchar(255) NOT NULL,
    `token` varchar(255) NOT NULL,
    `secret` varchar(255) NOT NULL,
    `address` varchar(255) NOT NULL,
    `x` float(20,17) NOT NULL default '0.00000000000000000',
    `y` float(20,17) NOT NULL default '0.00000000000000000',
    `sex` enum('0','m','f') NOT NULL default '0',
    `age` tinyint(3) unsigned NOT NULL default '0',
    `saved` int(11) unsigned NOT NULL default '0',
    `modified` int(11) unsigned NOT NULL default '0',
    `created` int(11) unsigned NOT NULL default '0',
    PRIMARY KEY  (`id_user`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
  
  -- 
  -- Dumping data for table `twcensus_users`
  -- 
  
  