[postgis-users] Error ST_LineToCurve(geom)

Davide Ticozzi davide at geosar.ch
Fri Feb 19 08:59:08 PST 2010


Hi,
I have a serius problem.
 I'm calling St_LineToCurve with the geometry attached, but returns me 
"geometry require more points"!
The geom is a linearized arc, and I think that the error occours when 
the function try to construct the circularstring.

Any idea?

Best regards
Dave

select astext(st_linetocurve(geomfromtext('LINESTRING(725515.460168627 
121202.269251756,725515.564326303 121202.218762205,725515.784240738 
121202.11686137,725516.005900093 121202.018814091,725516.22923685 
121201.924650233,725516.454182977 121201.834398482,725516.680669954 
121201.748086327,725516.908628791 121201.665740061,725517.137990049 
121201.587384767,725517.368683863 121201.513044313,725517.576 
121201.45,725517.60063996 121201.442741343,725517.833787686 
121201.376497273,725518.068056021 121201.314332281,725518.303373604 
121201.256265304,725518.539668755 121201.202314028,725518.776869498 
121201.152494888,725519.014903577 121201.10682306,725519.253698486 
121201.065312455,725519.493181485 121201.027975719,725519.733279626 
121200.994824223,725519.973919772 121200.965868067,725520.164 
121200.946,725520.405242162 121200.924460922,725520.64682341 
121200.907134371,725520.888670253 121200.894026633,725521.130709024 
121200.885141702,725521.372865994 121200.880482282,725521.615067401 
121200.880049794,725521.857239467 121200.883844369,725522.099308425 
121200.891864852,725522.341200538 121200.904108799,725522.582842123 
121200.92057248,725522.745 121200.934,725522.824159574 
121200.941250881,725523.065079383 121200.966137703,725523.305528165 
121200.995225365,725523.545432675 121201.028505007,725523.784719836 
121201.065966491,725524.02331676 121201.107598406,725524.261150768 
121201.153388072,725524.498149412 121201.203321538,725524.734240501 
121201.257383597,725524.969352119 121201.315557779,725525.203412649 
121201.377826364,725525.283 121201.4,725525.51438157 
121201.467624764,725525.746908077 121201.531201197,725525.98050873 
121201.5907098,725526.215112373 121201.646132445,725526.450647544 
121201.697452252,725526.687042495 121201.744653586,725526.92422522 
121201.787722071,725527.162123468 121201.826644587,725527.400664776 
121201.861409278,725527.457 121201.869,725527.63977648 
121201.892005554,725527.879385745 121201.918424096,725528.119419583 
121201.940656856,725528.359804878 121201.958697061,725528.600468406 
121201.972539217,725528.841336859 121201.982179107,725529.082336865 
121201.987613795,725529.323395015 121201.988841625,725529.564437879 
121201.985862223,725529.678 121201.983,725529.917654307 
121201.973884591,725530.157113011 121201.960587667,725530.396303181 
121201.943113638,725530.635151958 121201.921467827,725530.873586584 
121201.895656826,725531.111534433 121201.865688498,725531.348923021 
121201.831571972,725531.585680038 121201.79331764,725531.724 
121201.769,725531.821733366 121201.750937155,725532.0570111 
121201.704443426,725532.291441573 121201.653850615,725532.524953375 
121201.599174134,725532.757475375 121201.540430638,725532.988936746 
121201.47763802,725533.219266982 121201.410815408,725533.448395923 
121201.339983156,725533.676253772 121201.265162841,725533.715 
121201.252,725534.793 121200.966,725532.8 121201.089,725530.84 
121200.671,725529.077 121199.893,725527.432 121198.722,725526.424 
121197.535,725525.69 121196.272,725525.082 121194.859,725520.864 
121185.331,725519.887 121181.52,725519.514 121180.067,725518.935 
121178.511,725518.65 121177.746,725517.371 121174.172,725514.543 
121165.097,725514.683 121165.098,725513.533 121160.952,725513.335 
121161.02,725509.895 121150.775,725511.675 121146.158,725512.302 
121144.128,725514.291 121139.326,725493.657 121144.268,725494.586 
121144.25,725495.513 121144.348,725497.301 121145.122,725498.82 
121147.768,725499.468 121147.597,725500.152 121148.123,725506.509 
121157.869,725507.195 121159.3,725509.84 121166.82,725510.476 
121168.856,725510.741 121169.852,725512.893 121176.255,725515.696 
121182.806,725516.408 121184.248,725512.626 121189.046,725512.429 
121190.773,725515.139 121196.594,725516.235 121199.05,725516.238434492 
121199.05554188,725516.259461242 121199.090250067,725516.279879049 
121199.125319935,725516.299681691 121199.160740801,725516.318863139 
121199.196501877,725516.337417548 121199.232592268,725516.355339267 
121199.269000982,725516.372622837 121199.305716927,725516.389262993 
121199.342728921,725516.405254666 121199.380025688,725516.420592985 
121199.417595868,725516.435273278 121199.455428016,725516.449291073 
121199.493510609,725516.462642101 121199.531832046,725516.475322293 
121199.570380654,725516.487327789 121199.60914469,725516.49865493 
121199.648112348,725516.509300266 121199.687271756,725516.519260556 
121199.726610987,725516.528532764 121199.766118057,725516.537114066 
121199.805780933,725516.545001849 121199.845587532,725516.552193709 
121199.885525729,725516.558687457 121199.925583359,725516.564481113 
121199.965748219,725516.569572914 121200.006008075,725516.573961307 
121200.046350664,725516.577644958 121200.086763696,725516.579 
121200.104,725516.580622742 121200.127234862,725516.582893754 
121200.167751833,725516.584457301 121200.208302268,725516.585312907 
121200.248873814,725516.585460312 121200.289454114,725516.58489947 
121200.330030806,725516.583630553 121200.370591529,725516.581653947 
121200.41112393,725516.578970254 121200.45161566,725516.575580292 
121200.492054387,725516.571485093 121200.532427791,725516.566685905 
121200.572723576,725516.561184189 121200.612929465,725516.554981621 
121200.653033214,725516.548080092 121200.693022604,725516.540481702 
121200.732885455,725516.532188767 121200.772609625,725516.523203813 
121200.812183013,725516.513529576 121200.851593565,725516.503169004 
121200.890829276,725516.492125252 121200.929878194,725516.480401684 
121200.968728424,725516.468001872 121201.007368133,725516.454929593 
121201.045785551,725516.441188828 121201.083968974,725516.426783764 
121201.121906773,725516.411718787 121201.159587391,725516.396 
121201.197,725516.383831411 121201.22476867,725516.3669797 
121201.261682818,725516.349486316 121201.29829724,725516.331356586 
121201.334600785,725516.312596033 121201.370582392,725516.293210372 
121201.406231103,725516.273205508 121201.441536058,725516.252587534 
121201.476486503,725516.231362731 121201.511071791,725516.209537564 
121201.545281388,725516.187118681 121201.579104873,725516.164112912 
121201.612531943,725516.140527264 121201.645552416,725516.116368921 
121201.678156234,725516.091645242 121201.710333464,725516.066363759 
121201.742074306,725516.040532173 121201.773369091,725516.014158351 
121201.804208286,725515.987250328 121201.834582498,725515.9598163 
121201.864482474,725515.931864624 121201.893899106,725515.903403814 
121201.922823434,725515.885 121201.941,725515.87444254 
121201.951246647,725515.844989623 121201.979160087,725515.815054036 
121202.006555251,725515.784644896 121202.033423795,725515.753771467 
121202.059757534,725515.722443152 121202.085548447,725515.690669496 
121202.110788677,725515.658460177 121202.135470536,725515.625825005 
121202.159586506,725515.592773922 121202.18312924,725515.559316995 
121202.206091568,725515.525464417 121202.228466495,725515.491226497 
121202.250247205,725515.460168627 121202.269251756)')));




More information about the postgis-users mailing list