[mySQL] problème à l'insertion de polygone

problème à l'insertion de polygone [mySQL] - SQL/NoSQL - Programmation

Marsh Posté le 21-07-2009 à 13:02:34    

Bonjour.
Je suis en train de créer une table permettant de référencer les polygones représentant les régions françaises.
 
Voici ma table :  
 

Code :
  1. CREATE TABLE polygons_region(
  2. id_po_re INTEGER PRIMARY KEY AUTO_INCREMENT,
  3. polygon_po_re  POLYGON NOT NULL,
  4. id_re VARCHAR(20),
  5. SPATIAL INDEX(polygon_po_re ) ,
  6. FOREIGN KEY (id_re) REFERENCES region(id_re)
  7. )ENGINE=myisam;


 
Voici une insertion qui fonctionne :  
 

Code :
  1. INSERT INTO polygons_region VALUES (6, GeomFromText('POLYGON((4.97141067864157 44.4269927920504,4.9602656138422 44.4171284166614,4.9562222293031 44.4171081193899,4.9524924246148 44.4160004581088,4.94933809242948 44.4134933071606,4.91908089258044 44.4046456589072,4.91073446557233 44.3920114608202,4.90964279727531 44.3746989796261,4.90765233243756 44.3714886416847,4.90426842494054 44.3696245610037,4.89387380397729 44.3647301980783,4.89347210678984 44.3616804902131,4.89261732123629 44.3583174580903,4.87415163126085 44.3478781734273,4.87009806808919 44.3419349429994,4.87967690533074 44.342225759184,4.89198610432089 44.3369187952981,4.89589439281145 44.3349201175502,4.88267112221738 44.3221826008469,4.89123171134138 44.3105748940005,4.89177204291243 44.3039674663685,4.89002856072234 44.3008772071576,4.91766980192961 44.3053570966211,4.9224067005358 44.3056501489558,4.9841194235663 44.2918842660999,4.98758073513232 44.2895691264397,4.99276395716581 44.3094805395108,4.99787150989656 44.3152227994129,5.01389436081485 44.3225069550285,5.01034778812723 44.3243661539364,5.00956621976984 44.330620555813,5.0220286077966 44.3412027558583,5.02563077339911 44.3578501592207,5.05388339900096 44.3616878643363,5.06720476532401 44.3710384388866,5.07087731685924 44.3733043280958,5.07258321518982 44.3753672856352,5.0714446043665 44.3800837026328,5.04816754379919 44.3789705672606,5.0333315351885 44.3877497729636,5.01918289847205 44.3894467021489,5.01407175600559 44.4023037533495,5.01828142455181 44.4039914478937,5.01931772028652 44.4128381259935,5.01448054517033 44.4124884815679,5.00675038496798 44.4085739412257,4.98917796834054 44.4200589590167,4.98464443025451 44.4200335643823,4.97141067864157 44.4269927920504))'),'PA');


 
et voici une insertion qui ne fonctionne pas :  
 

Code :
  1. INSERT INTO toupil.polygons_region VALUES (7, GeomFromText('POLYGON((6.59045364949887 45.1160584205105,6.57704805567793 45.1199589799239,6.57409640269892 45.1174592804099,6.56442034996845 45.1106847441555,6.5618904525505 45.1041779255973,6.54056793421989 45.0963943292894,6.53080371895234 45.0959353402639,6.5109452968396 45.1058640511188,6.50829076269523 45.1028651292224,6.48391469044595 45.0906818053774,6.48923347311856 45.0670439871118,6.48760862674127 45.0532687207414,6.48265280735336 45.0531029692974,6.45364703952623 45.0492393262602,6.43539404451726 45.0598604511301,6.42087606628078 45.0580725489798,6.40666102050185 45.0611086353231,6.39742209574239 45.058853447961,6.36540432756645 45.0670386912945,6.37511818174908 45.0791692362508,6.3632491827685 45.1019029496676,6.33476273099128 45.119803966082,6.33339253938058 45.1164936682371,6.31755046188176 45.1087948409846,6.29387421676373 45.1054989020604,6.27741814959542 45.1118041454492,6.26109956080936 45.1237131722126,6.25901729837036 45.1205263659718,6.231754452393 45.1068962569982,6.23063143256107 45.0966682559179,6.24380619232932 45.066807527038,6.22061078722912 45.0622369615125,6.21925771284526 45.0588709719151,6.21008417350687 45.0391620959443,6.20921529874356 45.0252058670578,6.20345520529233 45.0197963008097,6.20366667565259 45.0093058204583,6.21491438528284 45.0025450978176,6.25669879434414 44.993075848362,6.3138166934044 45.0007294593977,6.31872918135992 45.0007239917404,6.32319564110362 44.9944837007557,6.31673516454422 44.9850700471027,6.31651333769264 44.9780528490279,6.3287359236481 44.9632019197701,6.32377448441628 44.9534285474018,6.32440077740983 44.9499474432997,6.33060234858302 44.9446259417663,6.35394327201728 44.9394212961455,6.35869122525911 44.9384381030656,6.35880540674271 44.9349213250839,6.35469462018405 44.9211554624617,6.35846428552775 44.9041579435436,6.35518248813529 44.8939557851815,6.3590648068004 44.8841774979501,6.35252788536665 44.878894326225,6.35100597389753 44.8719966480771,6.35588950086231 44.8516806302296,6.35258199867141 44.8497024901811,6.33684105439514 44.8452303862684,6.31995479421015 44.8520011631059,6.30487606911807 44.8696557841668,6.29509436861787 44.8708443507783,6.26762173522155 44.8659535960323,6.24939275702632 44.8494177852844,6.22963023813024 44.8488645401778,6.1969063651157 44.8558400035698,6.19309307629152 44.8536047937207,6.17019572887892 44.8492510038854,6.16555584516991 44.850447606517,6.15843325994422 44.8551429674699,6.1309813298765 44.8593674756677,6.11367805011061 44.8423917750474,6.09785869865071 44.8350885434719,6.09382302648689 44.8332268876187,6.05703397628865 44.8126726610108,6.05279793692918 44.8140310061089,6.03075233974838 44.8349592153181,6.01673560953377 44.8321497294857,6.00396202421022 44.8172134051602,5.97972243730237 44.8154499986634,5.97615038010377 44.8134338698529,5.95006027941624 44.80138847493,5.95174610158936 44.7983169234588,5.9783166607995 44.7878447510928,5.98004076891345 44.7813138993946,5.98081349271558 44.7780379108528,5.97696525779347 44.7765982958637,5.95370417490634 44.7681706631605,5.95275815427023 44.7652664349946,5.95165968551927 44.7564787095455,5.94743418067503 44.758165829353,5.93823249405602 44.7602945562921,5.92011085512684 44.7496394668699,5.90274199036486 44.7548575170388,5.89367955420171 44.7524312194587,5.8859899142101 44.7441438041544,5.88112308564551 44.7436971785468,5.8680073917532 44.7478635198636,5.84853338103071 44.7483865877959,5.84157187543046 44.7532267844254,5.82764055236902 44.7565497988495,5.82706949386335 44.7530656529527,5.82989988011355 44.7393002530981,5.81940242054373 44.7275143665661,5.81186628405609 44.7108807807979,5.80201242746206 44.7036377921935,5.80951245354754 44.7026453557063,5.81321302925914 44.7018624115619,5.82600232761536 44.6978388421311,5.82916633386857 44.6848103858851,5.81772228605951 44.678744739825,5.81381383725896 44.6767615870748,5.80979198728488 44.674979943819,5.8015636901124 44.6716831330502,5.79116568442594 44.6501515960383,5.7862378966572 44.650000078786,5.77166539085339 44.6511310610788,5.75431493006408 44.6573877281088,5.74969083397848 44.6479347051053,5.72605011856896 44.6369444753056,5.6840508870365 44.6468360616814,5.65985315748486 44.6479114693739,5.65209163665332 44.6520703684986,5.64978572911041 44.649754313937,5.64226371567195 44.6479370808992,5.64084842442867 44.644675924241,5.64339337770188 44.6211139335525,5.65001217758359 44.616233882324,5.64664436812501 44.6067845063931,5.63758057937066 44.6060757479815,5.628025327028 44.5918246644398,5.62686855253939 44.5834789168082,5.62254155319133 44.5827171917776,5.61444228144205 44.5686828213581,5.60769176156941 44.5652024088121,5.60703930034309 44.5635115843275,5.60502803966542 44.5603219652564,5.59780001464322 44.5401310531612,5.61302165476885 44.5324591768447,5.6155369349297 44.5296297626808,5.62820036942816 44.5312132503487,5.64324422212777 44.5189157085947,5.64687666926299 44.5169340079421,5.6635939822157 44.5018016649919,5.66504845870596 44.4987511531532,5.66031182242128 44.4988316615166,5.65179215026446 44.4961819022376,5.63374495040868 44.4989577385058,5.62687633708661 44.4946272868903,5.6255118014457 44.4912927897446,5.61829528253452 44.4714906678056,5.6041887139183 44.4623527951149,5.5995202687823 44.4631217973749,5.56964785099823 44.4734388651033,5.56523433960812 44.4721017063002,5.56096918254714 44.4711560455817,5.55026522887198 44.4767534148195,5.54662071953069 44.4789752244815,5.51157380874909 44.4883651908174,5.50696307846054 44.4888764843413,5.48368245578378 44.4880703860362,5.4754660708177 44.4911137584981,5.47139786396301 44.4968552183325,5.4668895658351 44.4971908698768,5.45839366030821 44.4950117208593,5.45945568781308 44.4853782444746,5.46090752778358 44.4829968665019,5.46208089586737 44.4796783766722,5.46737092671044 44.4703743719024,5.4607622467438 44.4654416418153,5.46437998531732 44.4489043489176,5.46538487629501 44.4455096600369,5.49603974480101 44.4356577177023,5.49557397626807 44.4278050096299,5.4941648240866 44.4250735640094,5.48659592095303 44.425822282139,5.48204846775428 44.4197338054745,5.47327577544605 44.417798154145,5.43913668178686 44.4304064104316,5.43430503368122 44.4300210173347,5.41894951175554 44.4216249566984,5.42097247169518 44.418436152487,5.4333986812752 44.408519092646,5.44225274820425 44.3885321570172,5.44317220078001 44.3781204721827,5.43189155403441 44.3721850556684,5.43550222096173 44.365972267323,5.43984147230205 44.3648054654778,5.44447203473027 44.3646021768788,5.46333705578876 44.364092259869,5.46759836319435 44.35137100856,5.46940417873991 44.34820549036,5.48213382555763 44.3470755740327,5.49097743558753 44.3365705204587,5.49349116155291 44.3339871559067,5.50367937973423 44.3410276470787,5.5211120115314 44.346380863098,5.5275883305092 44.3413683847018,5.5367630642233 44.3397326088592,5.54160981094336 44.3279269835417,5.5508582467655 44.327628788386,5.55879944547068 44.3310042747636,5.56730167690655 44.3297096679016,5.57185062527796 44.3303223104035,5.58351912930843 44.3291488019854,5.5874661858508 44.3288876448196,5.588728232002 44.3290301562513,5.62090889220484 44.3297973197565,5.62433909001066 44.3320704086946,5.62880373335044 44.3307931830156,5.63075523662351 44.3247042880398,5.61376693553645 44.3126230795702,5.60885735271885 44.3029689341656,5.61660408285657 44.3062289952828,5.62987298363336 44.2980002911894,5.63434357662464 44.2977306150684,5.64031571626491 44.2933563498452,5.63628459149417 44.2884919613981,5.63314579770604 44.2862375855761,5.63340211797621 44.2796868188864,5.64691645455585 44.2672454868149,5.64732375990302 44.2639391422514,5.6722179541531 44.2710756118258,5.67614924057594 44.2727376553131,5.68503771863416 44.2656796551767,5.68719066687162 44.262913631969,5.68059932605187 44.2582013452473,5.67478944412482 44.2527088375538,5.67318540595717 44.2425157369288,5.67384939777694 44.2370144471476,5.68256562652543 44.2305198932555,5.68167576484409 44.2275411357404,5.67727500906597 44.2102699041084,5.68643623463826 44.1940505323338,5.67657577203955 44.1882777144086,5.65212710541778 44.1864219275183,5.65283156309932 44.1830796698026,5.64444605447122 44.1673688612914,5.64637916284111 44.1642954294719,5.68326423569074 44.1603357718136,5.68203242525493 44.1574756561241,5.67914824917931 44.1429397282391,5.6745965769332 44.1441680196704,5.64586471330257 44.1450342396086,5.64121432280546 44.1460841201112,5.63168139803077 44.1474253406388,5.63255244428597 44.1507917843349,5.63933500178431 44.1631318944514,5.63031314343557 44.17093704579,5.61749756206596 44.1754717057328,5.60986895329975 44.1875529269264,5.60259816898007 44.1883466058198,5.59960261645693 44.1858533378171,5.57745412435227 44.1849920960289,5.56491390597479 44.1677522136231,5.56864006433378 44.1655721476915,5.58173850806872 44.1519997538388,5.57096554084229 44.1454623088998,5.55187806458499 44.1464943699031,5.55185508867408 44.1460900945379,5.54268902289018 44.1301168661169,5.51163144782049 44.1208027628292,5.50816121843133 44.1146047186739,5.49932911973125 44.1125665839319,5.49438005766548 44.1122870694676,5.4552590748049 44.1160763060103,5.45170454128377 44.1179865500939,5.44811623312553 44.1336021327159,5.44358378851948 44.1347931140859,5.43723761049527 44.1389149400669,5.43629616785279 44.1491008807694,5.43160664306659 44.1483611380798,5.42346569953554 44.1468910352337,5.41638093861786 44.1515004020456,5.39749660498198 44.149188240596,5.38378349420196 44.1521364950153,5.3837476068449 44.1556468014551,5.38718892933609 44.1761207749829,5.38183122742474 44.1892369869281,5.38372937846918 44.1959148621444,5.38508204619788 44.1980367439584,5.38090984314328 44.1997638377017,5.37721409074006 44.2019814176639,5.37293177906716 44.2035312922176,5.3562546743235 44.2102744650063,5.33631152297879 44.2008177958442,5.3189006880932 44.2060456066231,5.30463095255434 44.2056334126911,5.30385259426707 44.2022442639768,5.29997998438829 44.2037710958054,5.29236605099834 44.2114998029056,5.28122496983423 44.2166506301744,5.27683322541863 44.217848673282,5.25705762142268 44.226909176982,5.25320885286004 44.2279837545718,5.24909098267956 44.2279676053554,5.24506523286674 44.2275529368495,5.24100477290435 44.2276789238752,5.24053631952104 44.2241641633898,5.23869964387668 44.2100862074057,5.20932488291376 44.2112764576361,5.17617214132426 44.2177126926255,5.16846296188027 44.2221596549538,5.16406120997607 44.2232093930618,5.1505526788439 44.2320968198614,5.15236987389872 44.2351632074513,5.15930579047618 44.2397260952162,5.16210755662534 44.2424430063151,5.16263819645268 44.2457944492807,5.16108129803678 44.2624716191068,5.14801090334744 44.2660206539208,5.15121148871381 44.2787332741884,5.16897779927633 44.2890992412604,5.17066902359744 44.295588017386,5.1703073005461 44.2988636825256,5.17338790967703 44.3050645299128,5.1693994978874 44.3109806306479,5.16699233961706 44.3117087723527,5.16253264543669 44.3102403518776,5.15382441264832 44.3070006163611,5.1500679334236 44.2975053848423,5.11020741261334 44.2772163407854,5.08703703173074 44.280788636465,5.07707484271097 44.2809396961928,5.07448291367637 44.2837938548636,5.06080123669646 44.3044700002923,5.05707316366513 44.3022503500272,5.03006579170622 44.2947486930293,5.02533991795353 44.2936322734395,5.01770842974217 44.2890958971445,5.01364466377779 44.2879267762712,5.00329204200012 44.282223373746,4.99016026275841 44.2826236716198,4.98602796236179 44.2823729361913,4.97225490159737 44.2762816482536,4.96811825280794 44.2745818150699,4.94208834014698 44.2662619062862,4.93259114072721 44.2593081873934,4.92779266290804 44.2589541553207,4.90405039027017 44.2563292875387,4.9018524758568 44.2611311849027,4.89753916481051 44.2612592683611,4.88082016376853 44.2586266049056,4.8765964130532 44.2571233775797,4.8576575204731 44.2428432049463,4.85374330459279 44.2412240533603,4.82591028116068 44.2252989873393,4.82146338485635 44.225742040505,4.81401165203476 44.2292758267304,4.81270732830786 44.2389134846187,4.81368361773723 44.2420580958079,4.81308190261691 44.2548826401747,4.80457028381377 44.2660597497048,4.80643176327512 44.2716945272062,4.8050505457604 44.2744696466563,4.80349882071554 44.2776444431504,4.80513533187847 44.3007558029559,4.80056019283575 44.3004090745156,4.78153022443223 44.3139799352615,4.7724763306067 44.3143977043251,4.76356649822583 44.3219548361612,4.75897703303417 44.3221824336314,4.7222367988602 44.3234480074988,4.71359010657826 44.3175094972274,4.68046063065133 44.3175490984709,4.65546358812114 44.3252064660222,4.65118726147954 44.3266643821632,4.65210957621034 44.3231813217691,4.65376037674433 44.2916687799936,4.65293895301307 44.2881327182125,4.6525198692587 44.2846331243329,4.64980275229703 44.2672203697879,4.64912099755104 44.2643290950798,4.65204727546369 44.2560089250274,4.6536543551182 44.252772345725,4.67793154958498 44.231834506027,4.67350085263863 44.2154579916213,4.67422793612608 44.2115652703784,4.68245964217521 44.2086001789772,4.70050129888365 44.2129611564529,4.70917214272754 44.2103533542954,4.71086824639921 44.2036865749795,4.70440650995614 44.194516165944,4.70889630703182 44.1885805115424,4.72167941688188 44.1848657504419,4.71792990197717 44.1661825280523,4.71787468549114 44.1627923752882,4.71769236320827 44.1593510281373,4.71776162490619 44.1559491791843,4.71929054889711 44.1492321031085,4.72030451704335 44.1463133955125,4.71869812992308 44.1375328540022,4.70630156244154 44.1084598185216,4.70564616786755 44.1050288619912,4.7201973048396 44.0856328903628,4.72029995734369 44.0824373492068,4.72838432449144 44.0752980210189,4.75350879750211 44.0848366342973,4.75828622449322 44.0847846043837,4.76069396741831 44.0786412625041,4.76059657437177 44.0751982265632,4.76345450024981 44.0717164317421,4.78468361100874 44.0640634712684,4.78737937666674 44.0612053466253,4.78798145772819 44.0517647484818,4.79297525696759 44.0466959087534,4.79643292328824 44.0447558901845,4.79958084914593 44.0428677373963,4.80832483603533 44.0366249113751,4.821132498458 44.014187338355,4.83982509424952 44.010709894872,4.84356206227685 44.0007921840107,4.84368026529817 43.9972633627686,4.84590942731295 43.9924445848269,4.84555729368377 43.9889895839177,4.84150761432825 43.9827683113503,4.8368590662317 43.9818767445988,4.81353181336191 43.9848477321545,4.81073768238877 43.9747650103308,4.81493016370902 43.9615281212756,4.79253895598896 43.9491194296586,4.79294005385793 43.9457283809509,4.77578474760903 43.9341246728813,4.74906166331356 43.9279569320842,4.74205374589339 43.923516058625,4.73935938045327 43.9207154351656,4.74012608017739 43.9179552273301,4.73607468714125 43.9133586974244,4.72396506877999 43.9029042209787,4.69908031151688 43.8934825126314,4.70377343531225 43.8938840619638,4.70846550041005 43.8942584511866,4.7060550941698 43.8913340051958,4.69328233629915 43.881430584077,4.66750423867955 43.8732086501899,4.66308234772859 43.8672326527978,4.66215670643727 43.87043625011,4.64229660387359 43.8641502803993,4.64753825624169 43.8548744058776,4.64424286449885 43.848702939759,4.66244367721656 43.8491870592861,4.66733181553695 43.8438300026326,4.6655631303764 43.8406932184441,4.65273476950435 43.8365967515049,4.6435415193374 43.8289591764813,4.65502293467831 43.8058534400295,4.65348615679811 43.7845723024274,4.65076497812782 43.7777866096709,4.63007114223317 43.7579739232868,4.62868060773423 43.7545590447927,4.62774778154171 43.7511075111027,4.61251222632169 43.7215725725323,4.61371594803871 43.7110439495297,4.62704516326504 43.6848735875364,4.59838292638369 43.6835965375771,4.57904987505582 43.6939170425256,4.55989589446049 43.6962901552001,4.53816639095565 43.7039007437705,4.5251505361627 43.6993536169618,4.49135941466359 43.697252415476,4.48698805039576 43.6957027212077,4.47711695814204 43.6836511521642,4.4779959119697 43.6697682944529,4.45218070890246 43.6610861763561,4.42781037994055 43.6226714090106,4.42927056884866 43.6159086623742,4.43937169122624 43.6082500086787,4.4488358291985 43.6071934658297,4.4670610065211 43.6117993010053,4.47434172529832 43.6072858446012,4.47414934141348 43.6004921670089,4.45338682925436 43.581416520881,4.44889538686703 43.5800298104668,4.4440730663744 43.5800609736675,4.42995137208806 43.5821514991812,4.40982984271167 43.5729907376933,4.41489014781404 43.5645589700903,4.40976268237174 43.558867300499,4.40543207498738 43.5574038515422,4.39115340459784 43.5577571312,4.37313731708796 43.5465540186658,4.35449090614997 43.544251576648,4.33339999611355 43.5327758995731,4.31668458248083 43.5435933620502,4.32288850323085 43.5485591485334,4.31897401292684 43.5540163587031,4.3149653444795 43.5521298704949,4.30983029726643 43.5433860914539,4.32106983148982 43.5246510038171,4.29404744945008 43.5108944940039,4.24526210100607 43.4981118156634,4.23832435247403 43.4937302697793,4.240355661332 43.4905749792649,4.23267230992951 43.4778097863666,4.23086131312463 43.4570304380247,4.23576697145548 43.4568543160649,4.37759436273943 43.449464227281,4.40087690143885 43.4442745337315,4.42524405658373 43.4455945450289,4.4576962678819 43.452621036373,4.52607876343158 43.4501311825923,4.55400779157471 43.4435191387022,4.5749322070861 43.4343032529552,4.58751983033811 43.4234145303524,4.5965483416557 43.4030782037365,4.59515503232373 43.3996371450514,4.55953895415667 43.3813004809555,4.55932957421283 43.3743105664081,4.56775798840647 43.3660453801893,4.57953553038905 43.3590493579468,4.60638269126685 43.3503330766942,4.66437340829941 43.3434585192661,4.72767563294765 43.3470072598537,4.77182189059855 43.3460180331957,4.81371615172067 43.3359729999631,4.83805454529726 43.3241091030066,4.84785098935492 43.3236922106797,4.85759163222084 43.3236892998297,4.86303837708214 43.3352405246105,4.91528532295228 43.3721779374789,4.91544460415265 43.3784590036055,4.90400773977386 43.3672234267277,4.8811467907087 43.3552863292071,4.86844271399159 43.3628054526107,4.84033393583992 43.3726781522169,4.86145434153876 43.3857257955588,4.8389544395784 43.3916182995032,4.83538043843386 43.39391303235,4.83925949355238 43.3994514657517,4.83702019544108 43.4023895951083,4.8535831911233 43.3951348324341,4.85726594955685 43.4000928211312,4.8319889112575 43.4168291578715,4.83250280412533 43.4221131176743,4.85922545946464 43.4067904103269,4.86342552542252 43.4049926868776,4.86823680333562 43.404753916627,4.87228029882698 43.4066729262665,4.87425992079726 43.4098812041851,4.87398503592848 43.4134212789872,4.85572661346326 43.4424961141555,4.85543256656134 43.4459107715969,4.85888524969582 43.4475294956983,4.86157369561297 43.444966942249,4.86432177902983 43.4345353426494,4.87962155682815 43.4209221835669,4.89681401906306 43.42443561551,4.8895465098211 43.4133326256659,4.89070046811761 43.4065707275277,4.91296107441517 43.4241319313455,4.92575337090357 43.4290316826319,4.9707327614925 43.4214412010373,4.97330722876003 43.4184109799381,4.97413912244649 43.4150456914172,4.9793571931279 43.3960712746277,4.98685875026412 43.4009673637017,4.99605282879623 43.4003182802258,4.99863835951437 43.3975749129899,4.99924969164672 43.3942778345208,4.99102832089068 43.3914144922822,4.992053550518 43.38506811677,4.99982105835238 43.3768558979171,5.00298860675514 43.3741969667565,5.0229409940803 43.3509706282962,5.02286504801135 43.3375123665108,5.03685868676775 43.3278292510744,5.05491576590726 43.3234365472043,5.0681495880215 43.3274623780887,5.08202449223197 43.3245108508135,5.08900661396332 43.3293678069568,5.09728988358591 43.3261704872928,5.13511907952407 43.3260298462406,5.14794117110573 43.3232769332213,5.16599591633442 43.3247640569813,5.17264313656302 43.329174981923,5.18104549262318 43.3284677150626,5.1855373042838 43.3291312251422,5.22477608844957 43.3251181471182,5.23781681562565 43.3284722003437,5.25859786826341 43.3352657672708,5.28002527982535 43.3480717812903,5.2831363824242 43.3505855287983,5.30465225496065 43.3572606645071,5.31837319635528 43.3547323564824,5.3190935732632 43.3512861845167,5.33582397136616 43.3446074895224,5.33783929732269 43.3383823348364,5.35783880865057 43.3190371768881,5.36607374723138 43.2925923795322,5.3554632749551 43.2879358679691,5.34992364174547 43.2785503594016,5.36665963875597 43.2659135517453,5.37348914735512 43.2566117327909,5.37134442531477 43.2432650076438,5.3630619305017 43.2399107168169,5.36010343459393 43.2334747906029,5.34963505268735 43.2266202475036,5.34248994763953 43.2101496167427,5.36491732944547 43.2046461766306,5.39249445863619 43.2089275844447,5.39722931206897 43.20919742002,5.41965346953819 43.2032688605952,5.42741826522451 43.2052577405442,5.44601285648779 43.2010972432329,5.45897500307904 43.2071056421339,5.50522712605704 43.1971724575681,5.51073476238781 43.1949685525957,5.51365543605316 43.2011139053916,5.53261637036369 43.2085277052177,5.54137856468899 43.2073673754914,5.54901356594951 43.203641179133,5.54868381859618 43.1935614036178,5.55606986984023 43.1852109949882,5.5589343981596 43.182382360056,5.5749031800534 43.1694023485191,5.60530838222111 43.1592094625271,5.61105440211534 43.1647715489061,5.61337633896567 43.1749073135225,5.62311801588734 43.1823972261928,5.64656089864254 43.1848875067711,5.67239977049064 43.1761020390266,5.67691640978966 43.1749543804226,5.68633781874716 43.1759557966424,5.69292013612631 43.1710468412151,5.69397215874785 43.1642332237605,5.68471632387303 43.1563388279745,5.68488089154216 43.1528354768822,5.69642823405901 43.1419259454073,5.71949227417938 43.1423612746411,5.72642841364931 43.133356271805,5.73078553103351 43.1322832359082,5.74884091774097 43.1309280228498,5.75128832376058 43.1280982925743,5.77085479973099 43.1358371684617,5.78028256848897 43.1290149111513,5.77160355718028 43.1136183951229,5.79429857229473 43.1107306793301,5.80777493880228 43.1125435478049,5.81076581472344 43.1098296917501,5.81322334314706 43.1031670962822,5.80839386518717 43.0971633754083,5.81052947180558 43.0904573784453,5.80538998447621 43.077044589985,5.79635002009114 43.0690994652634,5.79826953590348 43.0659349926808,5.81524929133981 43.0597196554847,5.8305011259856 43.0467054673291,5.84409835315989 43.0438780059117,5.84774120292414 43.0461147538875,5.85256629161528 43.0460194285942,5.86094843946114 43.0463464751165,5.87334479753693 43.0645263546977,5.88804122203119 43.0733211687904,5.89714688214056 43.0745658413371,5.90407741619319 43.0701984336546,5.90780880849739 43.068059645339,5.91445291174134 43.0638449792033,5.9325199353469 43.0679706336033,5.94633914190101 43.0659321052953,5.95055646657814 43.0717616139583,5.94894569020375 43.0750266151079,5.94181714869335 43.0795206142657,5.92855180260132 43.0775108370369,5.91591476705646 43.0808565137449,5.90439540214301 43.0757277086632,5.8964898829136 43.0794170578818,5.90692002997369 43.0903298133004,5.90763809730649 43.0969610609548,5.88535461473368 43.1009926311975,5.8861303448672 43.113971511693,5.88784857079955 43.112970300692,5.89244395782875 43.1138342811975,5.9057176533992 43.1115136232845,5.91195952662164 43.1165489763541,5.92097066151943 43.1179299776762,5.93208694340566 43.111927735683,5.92954056788919 43.1018142422704,5.97956836365086 43.1033637033326,5.99379431704485 43.1018180585263,5.99844036847111 43.1015335442686,6.02248903690129 43.0923898406053,6.01989714712089 43.0771981475365,6.03306666510777 43.0744062344888,6.03751815434443 43.0755207339521,6.05160944582614 43.0760044828518,6.08201665363034 43.084183086452,6.10929074478154 43.080743936811,6.11406741809424 43.0804227578024,6.12765415019185 43.0711553257843,6.13301457798624 43.0540200316048,6.13101785880021 43.0436304142519,6.12061630987894 43.0368660614015,6.10162920562702 43.0378860873048,6.093968841213 43.0339819317248,6.10049402665549 43.0253883764215,6.11722872695291 43.0315802607021,6.12095662837743 43.0293529467738,6.13435960629017 43.031261834121,6.15034831389127 43.0242446742826,6.16389145549035 43.027709864917,6.15331414072435 43.0358944855705,6.1500951067754 43.0496895861436,6.15408100769109 43.0706037617775,6.16250168830407 43.08710553566,6.18093438849079 43.1032754719223,6.20154660699889 43.1122490730904,6.23484076552791 43.1098382639956,6.23927477314347 43.1100457543256,6.25937378979731 43.1168954405611,6.27231773145455 43.1178154027813,6.27656605982186 43.1169127315234,6.28701441219169 43.1113467358671,6.28681716493047 43.1081155591616,6.29457171012939 43.1055446244163,6.31343177879502 43.1036231646132,6.32660558545209 43.0892890653038,6.35496593681721 43.0857015351667,6.3644890171472 43.0863875279999,6.36687559717226 43.0894463823629,6.36089124719553 43.1130519895861,6.36440647681613 43.1225728959306,6.36863786140599 43.1324807205465,6.40644715493317 43.1451591430108,6.42990117824046 43.1473885287799,6.44119990087984 43.141630610468,6.44873988378199 43.1494839990466,6.45268706644249 43.1512399675255,6.46595835541691 43.1536359563355,6.49065695248788 43.1496952684934,6.49449290228646 43.1476842177038,6.52238122584027 43.1609504040508,6.53625893532071 43.1628193934343,6.53776618336293 43.1757080046229,6.55277641153362 43.1842430866367,6.55743042924351 43.184995931518,6.59897246387968 43.179754820077,6.61683370238659 43.1593919414809,6.6344022167787 43.1683265924656,6.64553648851448 43.1643436633947,6.64708175304915 43.1646235221872,6.64742210646172 43.1662115444965,6.64456184468433 43.1675771980313,6.64132474651006 43.1772093569723,6.64489455893916 43.1836619198604,6.66000598781334 43.1919807586322,6.67834621036412 43.1947859065338,6.66574828585251 43.2082888973656,6.66295216897607 43.2219628007104,6.66580113115541 43.2391889322325,6.67826463107275 43.242699470593,6.6814736281704 43.2452514648076,6.68952784210271 43.2488670540013,6.69715246032084 43.2613998797725,6.67658755117027 43.2752274589559,6.66439438612753 43.2621662944491,6.64406163747242 43.2708214817236,6.62410494950864 43.2621705839171,6.62008419958374 43.2609271089447,6.59465149317879 43.2590133313672,6.59129925176066 43.260297953119,6.58540035160979 43.2636089084053,6.58719408217389 43.2660486137728,6.58587594258302 43.2693672809096,6.58585386454686 43.2760542379224,6.62122828507616 43.2927470222656,6.62659352347111 43.297770597931,6.63329562848294 43.3025335700291,6.66870515996149 43.3111202720466,6.66637023443819 43.3179010032742,6.66926347843618 43.3281341184061,6.6826699583834 43.3378081168108,6.68731426277879 43.3384033983853,6.71431358775871 43.3427082375757,6.71852138839404 43.3551642130916,6.71502242904075 43.3649008913233,6.73126440985699 43.3851020291975,6.72960773175359 43.39165903573,6.73582187594375 43.4045913169905,6.7472672563276 43.4155092612732,6.75959169048193 43.4204855231229,6.76416583936776 43.4213507495142,6.76654372693968 43.4184086732108,6.78824503880588 43.4057766357942,6.8279985428331 43.4144326938284,6.83722579947634 43.4132194207355,6.84197183370576 43.4131200277903,6.85466287694691 43.4087087830398,6.85805281003052 43.4111409699316,6.8589268549167 43.4247057153164,6.86456438831604 43.4296179037653,6.87531188686793 43.4230984878255,6.88927107906693 43.4248499526763,6.89057942859048 43.4248396642156,6.89430150863509 43.4270677675649,6.89535308923308 43.4337567330701,6.92180370389453 43.4481361395119,6.92506092751193 43.4688739639858,6.93420960572774 43.4768925471418,6.9342967720982 43.4802827955066,6.94731407526671 43.483643124508,6.95527796832869 43.4960592544758,6.95202626775313 43.5020412864932,6.93940542991662 43.5064247532568,6.93885169250596 43.513218496014,6.95205940960487 43.5309393447411,6.9553258025691 43.5335365367649,6.97098101428181 43.5416345538866,6.99444903431294 43.5454502051816,7.02325789355354 43.5456707976909,7.03147982936951 43.5422432419775,7.03609929186619 43.5361087805359,7.04007627285098 43.5361606226284,7.05828667953786 43.5471514804565,7.07488020016493 43.5624425730979,7.08698069338857 43.5666470688022,7.09187170623426 43.5670890889503,7.10163145956137 43.5674061853559,7.11454434507194 43.5624864294372,7.12124196269269 43.5530143370171,7.12112031197055 43.5428448305243,7.13033903189137 43.5419225243651,7.13894307556041 43.5448806653947,7.1410840638892 43.5479639593934,7.13855632846058 43.5616282230283,7.12986939636279 43.5696590840128,7.12657964206342 43.5834379946326,7.13057417525646 43.6146243333484,7.14291246299608 43.6361745788341,7.14597522782992 43.6386768601395,7.15696517731978 43.6495790093653,7.16505094417622 43.653090522929,7.17398970208889 43.6526099405101,7.17872524309421 43.6528752651839,7.19656971243413 43.6540018671311,7.19973137417239 43.6516623442491,7.20229097510165 43.6486653917771,7.20580996560139 43.6434007844547,7.21010401489417 43.6450354354799,7.22646999643771 43.6580032441436,7.23395301220678 43.678252221077,7.24826507102804 43.6875190737983,7.26210682847414 43.6907174370432,7.28623576908345 43.6912914300666,7.30067682949179 43.6826679808863,7.30824329384548 43.6857520044898,7.30922698965218 43.6892013655409,7.31304493425198 43.7006534729403,7.32001938288005 43.7014763492504,7.32111729248069 43.6984175068743,7.32440366211921 43.6959693254802,7.32268432726654 43.6832770054255,7.32803093559015 43.6740417294765,7.3418687515285 43.6814092665239,7.32987151326399 43.6983020849445,7.34319891746022 43.710386075979,7.34876991624436 43.7109028100422,7.35822334832203 43.7181296700362,7.37110465285738 43.7154956117751,7.38374581712463 43.7194105227172,7.39092890961587 43.7165262203556,7.40494347972588 43.7167355445474,7.41609398635624 43.7225631677825,7.4129292276945 43.7245401894499,7.41329916380364 43.7285492626504,7.41385286120508 43.7314147606018,7.42387491370117 43.7381955194806,7.43001487757452 43.7441943349789,7.43394804240851 43.7463513073002,7.43782798889147 43.7484656215227,7.43971867891429 43.7458542981727,7.45864276280849 43.7560678086682,7.48323025601826 43.7467765768579,7.48874586407585 43.7618555801278,7.50816455862429 43.7710557651731,7.51281822800217 43.7771125575115,7.53029195908424 43.7808437223207,7.53058176870916 43.7842892472372,7.51919514482709 43.7993388114429,7.51822614949151 43.8027634948769,7.50809225468439 43.8367158580355,7.49711660589934 43.8476982079469,7.49936982381366 43.8692039271161,7.50648491515777 43.8730814806802,7.5095152270022 43.8755857993041,7.51073764527752 43.879023146923,7.555202249656 43.8928231203326,7.5618790391639 43.897817708353,7.56030136560961 43.9118139361839,7.57077499055626 43.9274015090736,7.57213443942271 43.9440228305078,7.57695731027749 43.9441236673623,7.59222711575242 43.9523963947216,7.61564875140532 43.9543875598432,7.65492033560448 43.9738643658799,7.65679574147589 43.9806840766332,7.66970117013776 43.9948931534575,7.66331490752406 44.011408519955,7.66240745929447 44.0149043048651,7.66381966045035 44.0254054988638,7.70211139925301 44.0398977898463,7.71336233597606 44.0593128391897,7.71597449757773 44.080353142591,7.69921023602362 44.0930219658818,7.68987776785626 44.1055302279203,7.67498664284849 44.1147233109133,7.6727839358259 44.1177601273126,7.66867064722169 44.1307856179295,7.67711485654184 44.1389787073268,7.67848593441613 44.1423631816804,7.67194714613286 44.151713652225,7.68337998958599 44.1668439501022,7.68038785286569 44.1728036030657,7.64147129816235 44.1742800653812,7.633669201443 44.1703966252739,7.62829457227064 44.1610057831467,7.62791539309389 44.1574915220976,7.61685328715025 44.1465468353504,7.56853512249831 44.1502282979438,7.55667008274258 44.1441287309317,7.53256264187441 44.1429826861813,7.5227737702811 44.1354471018586,7.49995984888927 44.1388190071745,7.46173023590911 44.1238637262749,7.43265893594118 44.1262091906665,7.42684327137827 44.116632875822,7.42743345684176 44.109712560767,7.4227738700793 44.1094886941996,7.41197903008058 44.115866624894,7.38636767208216 44.1205073312912,7.38204573464037 44.1188875401485,7.36920882379645 44.1139131480261,7.35946530224959 44.1138942370949,7.34141424182015 44.1419517699756,7.29345533274077 44.1417734804898,7.28482420439708 44.1389312693851,7.26327387088465 44.1448713306422,7.25057347905127 44.1544985778553,7.24054338942283 44.169851048524,7.22035302481686 44.165928154862))'),'PA');


 
L'erreur est "Column 'polygon_po_re' cannot be null"
 
Je ne comprends pas du tout d'où vient le problème. Y-a-til une longueur max pour une requete INSERT ?
 
Merci d'avance

Reply

Marsh Posté le 21-07-2009 à 13:02:34   

Reply

Marsh Posté le 21-07-2009 à 15:32:01    

Je crois que le pb vient du fait que ton polygone n'est pas fermé. Sur l'ex, le premier point et le dernier sont identiques, ce qui n'est pas le cas dans le 2ième (long) exemple qui ne marche pas.


---------------
Astres, outil de help-desk GPL : http://sourceforge.net/projects/astres, ICARE, gestion de conf : http://sourceforge.net/projects/icare, Outil Planeta Calandreta : https://framalibre.org/content/planeta-calandreta
Reply

Marsh Posté le 21-07-2009 à 16:04:24    

merci rufo,
je teste çà ce soir et je te tiens au courant
encore merci pour ta réponse :)

Reply

Marsh Posté le 21-07-2009 à 19:59:47    

çà marche !! merci beaucoup :)

Reply

Sujets relatifs:

Leave a Replay

Make sure you enter the(*)required information where indicate.HTML code is not allowed