[postgis-users] Create LINESTRING with a LOOP

[paallen at attglobal.net]

Mark

Version: PostgreSQL 8.2.1 on i686-pc-mingw32,
compiled by GCC gcc.exe (GCC) 3.4.2 (mingw-special)

PostGIS: POSTGIS="1.2.0" GEOS="2.2.3-CAPI-1.1.1"
PROJ="Rel. 4.5.0, 22 Oct 2006" USE_STATS

I am on Windows XP and my database is UTF-8.

If I run my linestring function for a short
interval  or few nodes, all works fine.  But if I
run it for longer interval with more nodes, it
returns and empty string.  And if I produce the
most nodes I can and get a character string, that
string will not produce a valid line from
GeomFromEWKT().  Below I included a sample of a
linestring that won't create a valid geometry
(5723 characters). Original string didn't have
line-feeds.  I added them with awk to help me read
it it better.

So what's up?  This is flustrating.

thanks,

Phil


SRID=32717;LINESTRING(796794.925994618
9228273.74400024 3771.434 0,
 796795.375531081 9228273.88150703 3770.9638271373
0.5,
 796795.824955924 9228274.01911906 3770.49357839301 1,
 796796.274269093 9228274.15683625
3770.02325378551 1.5,
 796796.723470536 9228274.2946585 3769.55285333321 2,
 796797.1725602 9228274.43258573 3769.08237705449 2.5,
 796797.621538032 9228274.57061788 3768.61182496775 3,
 796798.070403979 9228274.70875483
3768.14119709139 3.5,
 796798.51915799 9228274.84699652 3767.67049344382 4,
 796798.967800011 9228274.98534286
3767.19971404345 4.5,
 796799.41632999 9228275.12379377 3766.72885890869 5,
 796799.864747874 9228275.26234916
3766.25792805796 5.5,
 796800.313053611 9228275.40100895 3765.78692150969 6,
 796800.761247149 9228275.53977305
3765.31583928229 6.5,
 796801.209328436 9228275.67864138 3764.8446813942 7,
 796801.657297418 9228275.81761385
3764.37344786385 7.5,
 796802.105154045 9228275.95669039 3763.90213870968 8,
 796802.552898263 9228276.09587091
3763.43075395013 8.5,
 796803.000530021 9228276.23515531 3762.95929360364 9,
 796803.448049267 9228276.37454353
3762.48775768867 9.5,
 796803.895455948 9228276.51403547
3762.01614622367 10,
 796804.342750013 9228276.65363106 3761.5444592271
10.5,
 796804.78993141 9228276.7933302 3761.07269671741 11,
 796805.237000087 9228276.93313281
3760.60085871307 11.5,
 796805.683955992 9228277.07303881
3760.12894523255 12,
 796806.130799073 9228277.21304811
3759.65695629433 12.5,
 796806.577529279 9228277.35316063
3759.18489191688 13,
 796807.024146559 9228277.49337628
3758.71275211868 13.5,
 796807.47065086 9228277.63369499 3758.24053691822 14,
 796807.917042131 9228277.77411666
3757.76824633398 14.5,
 796808.36332032 9228277.91464121 3757.29588038446 15,
 796808.809485377 9228278.05526856
3756.82343908816 15.5,
 796809.255537249 9228278.19599862
3756.35092246357 16,
 796809.701475886 9228278.3368313 3755.8783305292
16.5,
 796810.147301236 9228278.47776653
3755.40566330356 17,
 796810.593013248 9228278.61880422
3754.93292080517 17.5,
 796811.038611871 9228278.75994428
3754.46010305252 18,
 796811.484097054 9228278.90118663
3753.98721006416 18.5,
 796811.929468745 9228279.04253118 3753.5142418586 19,
 796812.374726893 9228279.18397785
3753.04119845436 19.5,
 796812.819866064 9228279.3255268 3752.56807986999 20,
 796813.264288394 9228279.46682861
3752.09418624606 20.5,
 796813.707347366 9228279.60748952
3751.61883224006 21,
 796814.149035733 9228279.74750923
3751.14202490019 21.5,
 796814.589346271 9228279.88688746
3750.66377130333 22,
 796815.028271785 9228280.02562398
3750.18407855502 22.5,
 796815.465805104 9228280.16371854
3749.70295378927 23,
 796815.901939085 9228280.30117094
3749.22040416851 23.5,
 796816.336666611 9228280.437981 3748.73643688341 24,
 796816.769980593 9228280.57414854
3748.25105915278 24.5,
 796817.201873969 9228280.70967341
3747.76427822349 25,
 796817.632339703 9228280.8445555 3747.2761013703
25.5,
 796818.061370786 9228280.97879469
3746.78653589577 26,
 796818.488960239 9228281.1123909 3746.29558913012
26.5,
 796818.915101107 9228281.24534407
3745.80326843114 27,
 796819.339786465 9228281.37765414
3745.30958118404 27.5,
 796819.763009416 9228281.5093211 3744.81453480135 28,
 796820.18476309 9228281.64034493 3744.31813672278
28.5,
 796820.605040645 9228281.77072566 3743.8203944151 29,
 796821.025588434 9228281.90105229
3743.32219025918 29.5,
 796821.447392792 9228282.03189873
3742.82518940516 30,
 796821.870448626 9228282.1632646 3742.32939738076
30.5,
 796822.294750825 9228282.29514951
3741.83481969577 31,
 796822.720294261 9228282.42755304
3741.34146184201 31.5,
 796823.147073788 9228282.56047477
3740.84932929322 32,
 796823.575084242 9228282.69391428
3740.35842750505 32.5,
 796824.004320439 9228282.82787111
3739.86876191492 33,
 796824.43477718 9228282.96234482 3739.38033794201
33.5,
 796824.866449247 9228283.09733494
3738.89316098717 34,
 796825.299331406 9228283.23284099
3738.40723643286 34.5,
 796825.733418403 9228283.36886248
3737.92256964307 35,
 796826.168704967 9228283.50539891
3737.43916596326 35.5,
 796826.605185812 9228283.64244977
3736.95703072032 36,
 796827.042855632 9228283.78001454
3736.47616922246 36.5,
 796827.481709105 9228283.91809267
3735.99658675915 37,
 796827.921740891 9228284.05668363 3735.5182886011
37.5,
 796828.362945633 9228284.19578684
3735.04128000015 38,
 796828.804996858 9228284.33511322
3734.56459084991 38.5,
 796829.24700723 9228284.4743231 3734.08782980543 39,
 796829.688976689 9228284.6134165 3733.61099688394
39.5,
 796830.130905174 9228284.75239346
3733.13409210265 40,
 796830.572792626 9228284.89125399
3732.65711547878 40.5,
 796831.014638984 9228285.02999815
3732.18006702956 41,
 796831.456444188 9228285.16862595
3731.70294677221 41.5,
 796831.898208177 9228285.30713742
3731.22575472396 42,
 796832.339930891 9228285.4455326 3730.74849090205
42.5,
 796832.781612271 9228285.58381152
3730.27115532372 43,
 796833.223252255 9228285.72197421
3729.79374800621 43.5,
 796833.664850784 9228285.8600207 3729.31626896675 44,
 796834.106407797 9228285.99795102
3728.83871822261 44.5,
 796834.547923234 9228286.1357652 3728.36109579104 45,
 796834.989397035 9228286.27346327
3727.88340168928 45.5,
 796835.430829141 9228286.41104527
3727.40563593459 46,
 796835.87221949 9228286.54851122 3726.92779854425
46.5,
 796836.313568022 9228286.68586116
3726.44988953551 47,
 796836.754920372 9228286.82311353
3725.97195275565 47.5,
 796837.196315695 9228286.96029009
3725.49403390303 48,
 796837.63775397 9228287.09739081 3725.01613297873
48.5,
 796838.079235178 9228287.23441568
3724.53824998384 49,
 796838.520759297 9228287.37136468
3724.06038491942 49.5,
 796838.962326308 9228287.5082378 3723.58253778655 50,
 796839.403936189 9228287.64503501
3723.10470858632 50.5,
 796839.84558892 9228287.78175631 3722.62689731981 51)