[postgis-users] st_linetocurve error

2010-12-17 Thread ma...@geosar.ch 

Hi,
why this gets error  on postgis 1.5.1: select 
ST_LineToCurve(geomfromtext('MULTILINESTRING((724117.946992354 
119346.456207008,724117.948 119346.478))'));


Thanks


___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

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

2009-11-19 Thread Mark Cave-Ayland 

Davide Ticozzi wrote:


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?


Hi Davide,

Possibly its due to a rounding error introduced from the conversion from 
binary to text and back to binary again? I haven't time to look at this 
at the moment, however you can get some good debug information out of 
PostGIS 1.4 if you wish to trace through it yourself.



HTH,

Mark.

--
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063

Sirius Labs: http://www.siriusit.co.uk/labs
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

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

2009-11-17 Thread Davide Ticozzi 

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.55731,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.00274710