Hi everyone, I'm encured in a very strange issue.
This select give me an "geometry requires more points" error for a specific geometry: select st_linetocurve(the_geom) from covers where id_cover=2787; but not this: select st_linetocurve(geomfromtext(astext(the_geom))) from covers where id_cover=2787; Why? Here there is the geometry that encors into this error: LINESTRING(723433.642287571 120390.270478127,723433.648399855 120390.248369814,723433.660009611 120390.209061386,723433.672303626 120390.169961564,723433.685278155 120390.131082257,723433.698929245 120390.092435308,723433.713252738 120390.05403249,723433.728244271 120390.0158855,723433.743899278 120389.978005959,723433.760212989 120389.940405404,723433.777180436 120389.903095289,723433.79 120389.876,723433.79479645 120389.86608698,723433.813055665 120389.829391749,723433.831952519 120389.793020774,723433.851481256 120389.756985135,723433.871635928 120389.721295807,723433.892410394 120389.685963662,723433.913798327 120389.650999463,723433.935793213 120389.61641386,723433.95838835 120389.582217389,723433.981576857 120389.548420465,723434.005351669 120389.515033384,723434.029705546 120389.482066315,723434.054631068 120389.449529301,723434.080120643 120389.417432254,723434.106166506 120389.385784949,723434.132760724 120389.354597027,723434.159895196 120389.323877988,723434.187561657 120389.29363719,723434.215751678 120389.263883844,723434.244456674 120389.234627014,723434.273667899 120389.20587561,723434.303376457 120389.177638392,723434.333573297 120389.14992396,723434.364249222 120389.122740757,723434.395394887 120389.096097062,723434.427 120389.07,723434.45575343 120389.047106177,723434.488196686 120389.022141119,723434.521070701 120388.997746076,723434.554365462 120388.973928479,723434.588070826 120388.950695583,723434.622176526 120388.928054466,723434.656672174 120388.906012024,723434.691547262 120388.88457497,723434.726791166 120388.863749836,723434.762393151 120388.843542965,723434.798342373 120388.823960512,723434.834627879 120388.805008441,723434.871238619 120388.786692527,723434.90816344 120388.769018347,723434.945391093 120388.751991286,723434.98291024 120388.735616531,723435.020709452 120388.719899069,723435.058777214 120388.704843689,723435.097101931 120388.690454975,723435.135671928 120388.676737311,723435.174475457 120388.663694876,723435.213500698 120388.651331642,723435.252735764 120388.639651376,723435.255 120388.639,723435.292168702 120388.628657635,723435.331787502 120388.618353767,723435.371580095 120388.608742913,723435.411534361 120388.599827999,723435.451638127 120388.591611741,723435.491879179 120388.584096641,723435.532245259 120388.577284989,723435.572724071 120388.57117886,723435.613303283 120388.565780114,723435.653970537 120388.561090394,723435.694713444 120388.557111131,723435.735519593 120388.553843535,723435.776376555 120388.551288602,723435.817271883 120388.549447111,723435.858193122 120388.548319622,723435.899127805 120388.547906479,723435.940063465 120388.548207808,723435.98098763 120388.549223517,723436.021887836 120388.550953296,723436.062751624 120388.553396618,723436.103566547 120388.55655274,723436.144320171 120388.5604207,723436.185 120388.565,723440.739120394.008,723499.024 120400.047,723498.607 120403.984,723498.601671439 120404.044419126,723498.595265028 120404.131785807,723498.590384351 120404.219250989,723498.587030896 120404.306788029,723498.585205684 120404.394370262,723498.58490927 120404.481971011,723498.586141745 120404.569563591,723498.588902734 120404.65712132,723498.593191396 120404.744617528,723498.599006423 120404.832025562,723498.606346046 120404.919318798,723498.615208028 120405.006470644,723498.625589669 120405.093454554,723498.637487808 120405.180244031,723498.65089882 120405.266812638,723498.66581862 120405.353134006,723498.682242663 120405.439181841,723498.700165946 120405.524929931,723498.71958301 120405.610352157,723498.74048794 120405.695422498,723498.755 120405.751,723498.762874369 120405.780115041,723498.786735477 120405.864403988,723498.812063995 120405.948263663,723498.838852209 120406.031668523,723498.867091958 120406.114593161,723498.896774641 120406.197012318,723498.927891216 120406.278900887,723498.960432204 120406.360233926,723498.994387693 120406.440986658,723499.02974734 120406.521134486,723499.066500374 120406.600652997,723499.1046356 120406.679517967,723499.144141401 120406.757705375,723499.185005744 120406.835191403,723499.22721618 120406.911952448,723499.270759853 120406.987965129,723499.315623497 120407.063206291,723499.361793449 120407.137653014,723499.409255642 120407.211282622,723499.457995621 120407.284072687,723499.508 120407.356,723499.54118933 120407.402357935,723499.593275444 120407.472940908,723499.646585467 120407.542604103,723499.701103161 120407.6113263,723499.756811919 120407.679086565,723499.813694772 120407.745864258,723499.871734394 120407.811639038,723499.930913103 120407.876390869,723499.991212875 120407.940100027,723500.052615341 120408.002747106,723500.115101797 120408.064313023,723500.17865321 120408.124779023,723500.243250221 120408.18412669,723500.308873153 120408.242337944,723500.375502017 120408.299395054,723500.443116516 120408.35528064,723500.511696056 120408.409977679,723500.581219746 120408.463469509,723500.651666408 120408.515739836,723500.723014583 120408.566772739,723500.795242539 120408.616552671,723500.868328274 120408.665064471,723500.918 120408.697,723500.942249525 120408.712293359,723501.016983776 120408.758224951,723501.09250826 120408.802845255,723501.168799974 120408.846140679,723501.245835678 120408.888098035,723501.323591905 120408.928704542,723501.402044971 120408.967947831,723501.481170978 120409.005815948,723501.560945824 120409.042297359,723501.641345207 120409.07738095,723501.722344639 120409.111056035,723501.803919445 120409.143312357,723501.886044778 120409.174140089,723501.968695621 120409.203529841,723502.051846797 120409.23147266,723502.135472979 120409.257960036,723502.219548692 120409.2829839,723502.304048327 120409.306536628,723502.388946144 120409.328611048,723502.474216282 120409.349200434,723502.559832767 120409.368298515,723502.645769521 120409.385899474,723502.732 120409.402,723508.51 120409.991,723552.271 120414.462,723548.595 120417.382,723550.118 120419.25,723586.318 120422.946,723591.811 120418.531,723593.582 120418.712,723605.256 120419.866,723605.356 120418.871,723606.483 120407.617,723606.500230432 120407.432995197,723606.514248199 120407.248717815,723606.525047747 120407.064223855,723606.532625786 120406.879569517,723606.536980009 120406.694811048,723606.538109089 120406.510004726,723606.536012682 120406.325206846,723606.530691426 120406.140473699,723606.522146943 120405.955861557,723606.510381835 120405.771426654,723606.495399686 120405.58722517,723606.47720506 120405.403313216,723606.455803499 120405.219746813,723606.431201521 120405.036581876,723606.403406622 120404.8538742,723606.401 120404.839,723606.372427268 120404.671679439,723606.338272894 120404.490053092,723606.300953906 120404.309050483,723606.260481671 120404.128726748,723606.216868517 120403.949136814,723606.170127728 120403.770335388,723606.120273544 120403.592376934,723606.067321148 120403.415315658,723606.011286673 120403.239205497,723605.952187186 120403.064100095,723605.890040689 120402.89005279,723605.824866113 120402.7171166,723605.756683312 120402.545344202,723605.685513052 120402.374787919,723605.611377015 120402.205499705,723605.599 120402.178,723605.520578438 120402.011024868,723605.4392548 120401.845443765,723605.35505376 120401.681307174,723605.268000966 120401.518665093,723605.178122934 120401.357567063,723605.085447043 120401.198062158,723604.990001522 120401.040198963,723604.891815446 120400.884025566,723604.790918722 120400.729589537,723604.687342085 120400.576937921,723604.581117085 120400.426117216,723604.472276079 120400.277173364,723604.360852222 120400.130151733,723604.25 120399.989,723604.246879454 120399.98509711,723604.130392492 120399.842053678,723604.01142682 120399.70106501,723603.890018675 120399.562174052,723603.76620504 120399.425423113,723603.640023629 120399.290853847,723603.511512879 120399.158507246,723603.380711935 120399.028423624,723603.24766064 120398.900642606,723603.112399524 120398.775203115,723602.974969787 120398.65214336,723602.835413293 120398.531500828,723602.693772551 120398.413312267,723602.550090707 120398.297613678,723602.413 120398.191,723602.26538871 120398.080134964,723602.115865042 120397.971862983,723601.964474541 120397.86621704,723601.811263322 120397.763229316,723601.656278053 120397.662931182,723601.499565946 120397.56535319,723601.341174736 120397.470525063,723601.181152671 120397.378475687,723601.019548494 120397.2892331,723600.856411434 120397.202824487,723600.691791181 120397.119276169,723600.525737881 120397.038613595,723600.358302117 120396.960861336,723600.189534889 120396.886043076,723600.019487607 120396.814181605,723599.85 120396.746,723599.848212068 120396.745298814,723599.675760445 120396.679415684,723599.502185268 120396.616552285,723599.32753941 120396.556727764,723599.151876069 120396.499960345,723598.975248755 120396.446267321,723598.797711269 120396.395665045,723598.619317692 120396.348168933,723598.440122364 120396.303793452,723598.260179868 120396.26255212,723598.079545019 120396.224457498,723597.898272838 120396.189521191,723597.716418543 120396.157753841,723597.534037529 120396.129165124,723597.35118535 120396.103763749,723597.167917706 120396.081557453,723596.989 120396.063,723551.636 120391.423,723489.001 120384.993,723485.177 120384.6,723485.373 120382.977,723487.086 120368.814,723487.093 120368.732,723483.049 120368.393,723436.72 120364.507,723434.32 120383.669,723436.265 120373.572,723436.272506212 120373.5386552,723436.280599035 120373.505447842,723436.289270173 120373.472386781,723436.298516986 120373.439482087,723436.308336656 120373.406743784,723436.318726193 120373.374181844,723436.329682432 120373.341806186,723436.341202035 120373.309626671,723436.353281494 120373.277653103,723436.365917128 120373.24589522,723436.37910509 120373.214362695,723436.392841362 120373.183065136,723436.407121759 120373.152012073,723436.421941932 120373.121212968,723436.437297366 120373.090677201,723436.453183384 120373.060414074,723436.469595147 120373.030432806,723436.486527656 120373.000742529,723436.503975752 120372.971352287,723436.521934122 120372.942271032,723436.540397294 120372.913507623,723436.554 120372.893,723436.559359645 120372.885070822,723436.578815398 120372.856969291,723436.598758628 120372.829211589,723436.619183259 120372.801806172,723436.64008307 120372.774761389,723436.661451694 120372.748085476,723436.683282622 120372.72178656,723436.705569205 120372.695872652,723436.728304653 120372.670351645,723436.751482042 120372.645231313,723436.775094311 120372.620519308,723436.799134267 120372.596223158,723436.823594589 120372.572350264,723436.848467824 120372.548907897,723436.873746397 120372.525903199,723436.899422608 120372.503343175,723436.925488634 120372.4812347,723436.951936536 120372.459584507,723436.978758259 120372.43839919,723437.00594563 120372.417685204,723437.03349037 120372.397448858,723437.061384088 120372.377696316,723437.074 120372.369,723437.102299613 120372.349980734,723437.130928284 120372.331460439,723437.159875818 120372.313442603,723437.189133398 120372.295932716,723437.218692112 120372.278936111,723437.248542955 120372.262457966,723437.278676835 120372.246503299,723437.309084573 120372.231076971,723437.339756907 120372.21618368,723437.370684492 120372.201827964,723437.401857909 120372.188014195,723437.433267662 120372.174746581,723437.464904182 120372.162029164,723437.496757834 120372.149865817,723437.528818913 120372.138260245,723437.561077655 120372.127215984,723437.593524233 120372.116736398,723437.626148763 120372.106824679,723437.658941307 120372.097483845,723437.691891877 120372.088716744,723437.724990436 120372.080526044,723437.7582269 120372.072914241,723437.791591147 120372.065883654,723437.796 120372.065,723437.825073013 120372.059436424,723437.8586623 120372.053574515,723437.892348775 120372.048299713,723437.926122177 120372.043613624,723437.959972219 120372.039517677,723437.99388859 120372.036013117,723438.027860958 120372.033101014,723438.061878975 120372.030782254,723438.095932278 120372.029057543,723438.130010496 120372.027927407,723438.164103247 120372.02739219,723438.198200147 120372.027452055,723438.232290808 120372.028106984,723438.266364847 120372.029356777,723438.300411885 120372.031201054,723438.33442155 120372.033639253,723438.368383483 120372.036670631,723438.402287338 120372.040294264,723438.436122789 120372.04450905,723438.469879528 120372.049313704,723438.503547273 120372.054706762,723438.537115768 120372.060686582,723438.570574789 120372.067251342,723438.579 120372.069,723437.785 120376.965,723437.625 120377.952,723483.828 120382.811,723483.555 120385.469,723442.078 120381.195,723436.563 120385.557,723435.142 120385.411,723435.122204594 120385.408119484,723435.102464309 120385.4048821,723435.082783531 120385.401300694,723435.063168254 120385.397376357,723435.043624454 120385.393110283,723435.024158083 120385.388503773,723435.004775073 120385.383558229,723434.985481326 120385.378275159,723434.96628272 120385.372656171,723434.947185102 120385.366702976,723434.928194291120385.360417389,723434.909316071 120385.353801324,723434.890556193 120385.346856797,723434.87192037 120385.339585922,723434.85341428 120385.331990914,723434.83504356 120385.324074087,723434.816813805 120385.315837853,723434.798730569 120385.30728472,723434.78079936 120385.298417294,723434.76302564 120385.289238276,723434.745414823 120385.279750461,723434.727972273 120385.269956741,723434.716 120385.263,723434.710703304 120385.259860097,723434.693613175 120385.249463607,723434.676707094 120385.238770436,723434.659990208 120385.227783841,723434.643467612 120385.21650717,723434.627144337 120385.204943858,723434.611025355 120385.193097426,723434.595115578 120385.180971483,723434.57941985 120385.168569724,723434.563942953 120385.155895925,723434.548689602 120385.142953947,723434.533664443 120385.129747733,723434.518872053 120385.116281305,723434.504316936 120385.102558765,723434.490003529 120385.088584293,723434.475936189 120385.074362146,723434.462119202 120385.059896657,723434.448556778 120385.04519223,723434.435253046 120385.030253347,723434.422212061 120385.015084557,723434.409437793 120384.99969048,723434.396934135 120384.984075806,723434.384704895 120384.968245292,723434.38 120384.962,723433.642287571 120390.270478127) _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
