[postgis-users] St_LineToCurve error, geometry requires more points

Davide Ticozzi davide at geosar.ch
Tue Nov 17 08:37:36 PST 2009 

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)

More information about the postgis-users mailing list