[postgis-tickets] [PostGIS] #5225: ST_SIMPLIFYPRESERVETOPOLOGY instability on some MULTILINESTRING
PostGIS
trac at osgeo.org
Wed Aug 24 09:09:15 PDT 2022
#5225: ST_SIMPLIFYPRESERVETOPOLOGY instability on some MULTILINESTRING
------------------------+--------------------------
Reporter: cactusbone | Owner: pramsey
Type: defect | Status: new
Priority: low | Milestone: PostGIS GEOS
Component: postgis | Version: 3.2.x
Keywords: |
------------------------+--------------------------
I have a question.
It seems ST_SIMPLIFYPRESERVETOPOLOGY (from postgis, which documentation
says it is performed by the geos module) sends varying data with some
MULTILINESTRING inputs
It also seems that the longer the MULTILINESTRING, the greater the chance
of variation.
My question: is this a bug or something to be expected ?
example SQL : (run a few times, check that diff is sometimes not empty)
{{{
SELECT ST_ASTEXT(A), a,
ST_ASTEXT(ST_DIFFERENCE(A,A)) AS DIFF
FROM (
SELECT ST_SIMPLIFYPRESERVETOPOLOGY(WAY,1222) AS A
FROM (SELECT ST_GEOMFROMTEXT(
'MULTILINESTRING((194310.3864375258
6269374.922168917,194229.76886229333 6269419.62067134,194119.46237886624
6269472.9675241215,194042.57400657536 6269505.525209331,193958.79495780432
6269533.572399087,193858.273457618 6269561.687510971,193767.74844770491
6269582.053220367,193573.44027652525 6269621.462109578,193479.14153587425
6269645.72817361,193389.2065192624 6269674.369340893,193292.52554150842
6269711.7098361235,193217.87469098245 6269746.35423054,193155.7695470689
6269778.590772032,193093.35270858108 6269814.473358343,193040.4759504543
6269849.186005235,192970.65636582876 6269900.4158241125,192894.84779259854
6269962.719570645,192836.52751137194 6270015.289773788,192778.54118861773
6270073.778748463,192625.0316108138 6270239.666467283,192568.5592331344
6270298.716632978,192512.55439731627 6270357.292362772,192453.93355346454
6270412.985471226,192393.4425421675 6270465.931574068,192347.57891196062
6270503.173810453,192301.4481149759 6270537.770570481,192237.51733141334
6270581.932522803,192171.7275123545 6270622.940256508,192058.01465250918
6270680.941609077,191985.70151128987 6270713.673542163,191909.31407670752
6270741.572103306,191822.22883905994 6270769.640353469,191449.74269091658
6270869.872750556,191380.12348137447 6270888.596497581,191124.12204839717
6270957.488032467,190824.78393765405 6271035.233363513,190464.67651688692
6271132.212507669,189704.9321241719 6271338.029749751,189668.1076366175
6271348.087531609,189348.69862168434 6271433.655485189,189138.50515916848
6271492.849680412,188856.3881736511 6271578.910977546,188790.843257472
6271599.11193322,188320.0842628563 6271744.641655042,187820.53804792152
6271896.195374541,187692.69874469453 6271935.632014541,187619.1610890765
6271957.055092225,187607.1385840708 6271960.379660216,187539.91274358073
6271978.970125731,187150.99583859628 6272106.017375912,187088.7459793447
6272125.86338048,186794.37271789095 6272204.755950004,186715.3581433259
6272226.9430276,186386.019429814 6272324.902724626,186341.98143925617
6272338.33728588,186228.48008644333 6272372.704076362,186148.8198588317
6272397.130705383,185908.72598108876 6272470.3262004275,184829.45012200074
6272795.583095043,184445.90994842158 6272911.174952552,184084.39990207044
6273020.101453073,183928.0962050476 6273064.4969112985,182967.9099372102
6273321.187642189,182437.8733137471 6273462.573600028,182195.7756851699
6273527.329633407,181451.6494170132 6273725.926944476,181349.51378421034
6273753.394341246,180894.95177550512 6273876.39644083,180646.27516502203
6273951.606744456,180527.5417961419 6273987.405251751,180453.04679290304
6274011.0052037,180394.06972668075 6274031.602196206,180335.10379240758
6274053.403845108,180288.73922449216 6274073.542850133,180239.85883608487
6274096.091127523,180172.97808601626 6274130.278434857,180095.22142169712
6274176.291545229,180053.242841719 6274204.93110029,180002.03587595408
6274241.205747136,179936.64680706212 6274291.97015417,179876.75692101536
6274344.431552935,179788.01302295495 6274433.304484509,179730.2493391823
6274498.560004091,179617.97250076823 6274621.352372588,179525.2990246828
6274717.490354004,179439.85018354992 6274796.916150924,179358.47563578002
6274869.0125483805,179299.48743760868 6274917.065843037,178963.19125592217
6275182.958891726,178872.84435719438 6275259.249852135,178787.77400233014
6275335.965722783,178712.68900579007 6275410.527225275,178494.07978977027
6275641.953757119,177877.44773441908 6276298.935552551,177659.651150682
6276529.351169971,177237.7168847283 6276979.118426997,176836.78860668722
6277406.437319403,176724.22233759708 6277523.229470048,176645.04078379582
6277599.507615941,176614.50584747124 6277629.007448478,176501.08241830196
6277727.538993572,176424.34989329817 6277788.915985597,176350.85676547643
6277843.928209411,176274.5249906395 6277897.243390758,176156.33708726428
6277973.049636971,176064.33152812364 6278026.925783878,175960.02516525035
6278082.7034044145,175832.28604956504 6278145.356064293,175696.1868401212
6278204.512415867,175593.32763062822 6278243.808757859,175473.42540709476
6278283.529652145,175334.88830080253 6278323.9127527755,175224.9714355933
6278350.359629461,175125.2736996388 6278371.238801115,175012.75195834498
6278390.997674488,174923.1286363073 6278402.914130773,174785.29284280707
6278416.494158423,174676.0216306444 6278421.977100771,174100.86721756277
6278440.191358953,173698.97045995184 6278452.939665534,173540.2399980297
6278455.129456483,173327.2190204477 6278456.521416915,173064.77218895347
6278454.569277345,172730.62447343933 6278444.333283348,172564.44673758312
6278438.375023896,172464.9493767121 6278432.926021066,172257.23833884092
6278419.142266356,172119.8255594057 6278408.668664824,171877.5052918469
6278387.432925874,171702.3329411346 6278369.490380695,171082.127530129
6278305.138576055,170505.1140815511 6278245.047911142,170402.29939985444
6278235.083765929,170292.12649981634 6278227.3433137005,170194.47704249248
6278221.521004526,170041.15670782293 6278214.340727894,169855.24202624903
6278210.2498401515,169705.57297087752 6278210.131017717,169622.81806142177
6278211.387140695,169526.35972264942 6278213.848463291,169378.70555006122
6278219.6028685635,169239.1331725046 6278228.310869838,169075.88313925627
6278241.890616841,168886.91830363468 6278260.9871729845,168734.08777472458
6278281.526628219,168578.49652244285 6278304.18798594,168370.69642897905
6278340.038887247,168134.54326121017 6278389.571774863,168031.3500932448
6278412.437122872,167946.24634253338 6278433.265522698,167775.02583374424
6278477.027397188,167221.3672143348 6278632.35162899,166564.38184357106
6278819.168873168,166459.41869570207 6278848.757844283,166041.4919314169
6278967.029884336,165837.27632555665 6279028.602620861,165678.90208600505
6279078.563955241,165512.601898709 6279134.518284295,165331.74112201715
6279198.536874455,165093.95155773364 6279292.927407073,164927.9074052664
6279363.551229157,164822.33200019805 6279410.390767568,164716.75659512973
6279459.743182722,164550.01112987046 6279542.473213391,164382.6311435137
6279628.973055033,164171.31335414085 6279747.323929873,163970.61544418964
6279867.83266412,163782.9196507631 6279988.529877836,163630.74590684866
6280090.722325979,163479.24007987903 6280199.5886100065,163379.94309409146
6280273.819513355,163247.127809626 6280378.001954607,163115.57043540652
6280484.698602745,163059.6880510283 6280531.968840754,162875.54334935802
6280694.275525646,162783.88288063885 6280779.377839527,162689.60640388602
6280869.388223054,162596.5767054301 6280961.284363624,162447.34179607264
6281113.020460335,162357.3288558172 6281210.998327417,162269.20834690524
6281309.588642108,162101.57232571964 6281505.567054671,162010.35713496362
6281621.668706291,161854.3873964132 6281821.407357725,161723.431147444
6281998.836028648,161601.6030967198 6282162.155893708,161215.4580470561
6282692.4535129145,161104.21647990638 6282844.135795295,160829.9141226427
6283218.198562569,160702.65368076783 6283385.584448484,160574.558342712
6283548.625397618,160460.78982312127 6283687.600801415,160371.35574421793
6283794.543099508,160231.61638742514 6283954.27963882,160087.1570842227
6284113.3397397725,159955.12103619284 6284254.006129454,159817.01807591468
6284395.35434521,159744.50455961193 6284466.955143437,159590.92819011354
6284616.189126318,159504.75577229046 6284696.999112322,159389.42877982865
6284802.459260868,159281.02585969414 6284898.169562886,159107.41198185296
6285047.326225455,158927.04101092063 6285194.650745688,158757.7018015259
6285325.923272096),(159612.02323361888 6284563.8677484,159743.35796885678
6284436.870843225,159804.50576514952 6284376.057057197,159943.10966313622
6284232.942543113,160062.97849082242 6284104.710601479,160212.85905322648
6283940.435912305,160278.87151126692 6283866.104831385,160358.70985006384
6283774.160091971,160552.72859056742 6283538.077492254,160684.97614562983
6283370.620643681,160811.55753861085 6283201.910250149,161138.15779264923
6282756.753832039,161584.226124207 6282147.686750394,161704.9855078195
6281984.995507281,161836.4315625482 6281805.648176685,161986.86872240627
6281612.872298865,162079.47540679717 6281496.176424808,162250.50667245197
6281295.324729303,162338.95000788724 6281195.4440528685,162430.53255296283
6281096.515461827,162580.01236520006 6280943.94763531,162596.9329278006
6280927.239206045,162672.95300806337 6280852.187522901,162769.03286056704
6280761.03967867,162860.51521810095 6280675.92056996,163020.51472221813
6280534.855322192,163099.85212330648 6280467.05722754,163230.44101795607
6280360.683402378,163363.5346011485 6280256.823770906,163467.76304037822
6280179.112405164,163648.79079630628 6280051.332500253,163770.30715245623
6279968.682376769,163963.03458686662 6279844.963376556,164159.33537693147
6279726.662066799,164358.04066799747 6279615.085483966,164543.98874541855
6279518.976647851,164709.18686975574 6279437.961534301,164812.15739873954
6279390.289969728,164916.3747060202 6279343.246819833,165085.1461860119
6279271.332933188,165186.24654755034 6279231.420650729,165324.78365384255
6279176.721946358,165504.15274935775 6279112.499804153,165669.88520725077
6279057.46234304,166039.34346524457 6278943.365158198,166557.42437539648
6278795.793149981,166583.84049056174 6278788.238917756,167189.73021505136
6278618.109211654,167769.8717413205 6278455.129456483,167928.78031442792
6278413.489575424,168027.06429284927 6278389.860349767,168103.07324116293
6278372.376123329,168372.9228187949 6278316.477766411,168581.99195445376
6278280.134696615,168742.52579212672 6278256.30214721,168872.51356152602
6278239.7348305425,169075.40446544587 6278218.839009227,169235.6711363409
6278205.5648425175,169378.816869552 6278196.09300741,169525.63614595926
6278190.508364088,169700.730573028 6278186.570259162,169851.34584407127
6278186.315640371,170044.14007017616 6278190.372567335,170194.27666740905
6278198.07903647,170293.64044489112 6278203.986202594,170401.4199758772
6278212.354695007,170499.50357921512 6278220.723195708,171085.58956629265
6278281.98494721,171705.6279980621 6278347.032546713,171877.6166113377
6278364.924119366,172140.3417415589 6278387.178301031,172250.04709973568
6278395.292349814,172467.320481866 6278410.0096924985,172565.3706893567
6278415.8321315665,172732.4612450374 6278421.960125714,172873.4807759743
6278427.290295983,173072.53115746178 6278431.551039599,173317.93497491552
6278433.367373186,173696.47690335807 6278430.8211112525,174099.07497376102
6278417.376860977,174673.76184498132 6278398.178101262,174785.28171085802
6278392.304749357,174919.56641260194 6278379.845108834,174999.9724808019
6278368.6416330505,175050.34455038584 6278360.748284028,175121.71147593344
6278348.424489337,175222.12165662897 6278327.290751028,175329.82326397148
6278301.030669535,175465.9781331607 6278262.582798295,175584.2884879758
6278220.960840882,175688.11617703867 6278181.596706854,175823.68105292672
6278123.068570675,175954.45919071068 6278060.959254745,176051.79695346032
6278008.423854744,176149.13471620996 6277951.679200016,176247.7081253074
6277886.770436193,176332.1439590741 6277828.889349307,176413.15115252437
6277768.157069202,176490.89668489437 6277706.525623646,176554.3265307484
6277652.481784668,176627.05155408365 6277584.842605183,176657.0632888015
6277557.413671906,176711.01984598898 6277504.507992098,176760.8241861699
6277453.130223573,176820.9701070455 6277390.431777683,177286.2855785614
6276892.20443966,177861.65149867552 6276284.154003537,178398.8570973457
6275710.3070790805,178695.34542912449 6275395.866013061,178775.66244173184
6275316.536399705,178858.2392400023 6275241.313948316,178944.2780744364
6275168.569570697,179282.555743059 6274899.63970496,179341.2990383506
6274851.1623121975,179428.87408175768 6274776.724518886,179508.23374674423
6274703.390274527,179556.8135725264 6274653.3699657265,179603.24493213627
6274605.046692117,179711.58106057628 6274482.339396265,179772.46169009112
6274415.709673763,179860.53767120678 6274326.463656855,179922.175273259
6274271.881528828,179987.39736291478 6274218.419549947,180033.8621183719
6274184.910548036,180080.6942281486 6274154.099350101,180113.37763064553
6274134.21464984,180161.62349795533 6274106.525452321,180227.2797336252
6274070.115652964,180274.1897670455 6274047.771040161,180324.66202417118
6274025.0023307055,180385.19756326458 6274002.216716409,180442.14861475438
6273980.992048297,180512.50253293573 6273958.885196452,180622.23015501068
6273925.954068508,180758.819170214 6273887.695757958,181342.9348023045
6273730.813046822,181445.46005332508 6273703.7698630225,182199.37130472253
6273502.49257374,182963.31244224045 6273298.794114928,183938.78287616375
6273037.642466021,184079.81353904973 6272997.267655166,184238.04306326332
6272948.394035007,184438.81889685805 6272888.1548454845,185007.9731893859
6272716.159139401,185901.1673876639 6272446.119879661,185976.12993276407
6272423.898300745,186121.39073630024 6272380.829315267,186199.8821092586
6272357.556209243,186287.8356389343 6272331.484299947,186334.95717938713
6272317.506939917,186380.0304412093 6272304.157225641,186534.40831104142
6272258.391783233,187140.94368857768 6272080.624735446,187160.71403014255
6272073.754996126,187539.9238755298 6271955.324960422,187600.55960216493
6271936.378344127,187674.38668845902 6271913.293043615,188332.00658032027
6271715.4507022835,188782.3273164263 6271579.470701108,188845.1115092337
6271560.0669725705,189141.16569499843 6271470.308346317,189362.03469668137
6271405.008357309,189660.70489047974 6271327.564920277,189695.74826618144
6271318.185594663,190457.64112506877 6271112.86068684,190816.96930940036
6271015.305118234,190957.20960390175 6270978.976471972,191363.30310631558
6270868.855156802,191382.17176000506 6270863.7502299575,191434.1802261037
6270849.63961765,191820.4365952582 6270744.9131529685,191901.21001777778
6270719.338045002,191985.0892540905 6270686.9791996395,192040.4595688111
6270663.354607214,192160.21707700647 6270601.4866406545,192224.78238166656
6270561.2591377525,192288.2122275206 6270517.639987497,192333.53039222254
6270484.077816298,192375.79840287674 6270448.616364298,192436.43412951185
6270396.28089196,192495.3110081924 6270340.316552183,192562.12496656654
6270270.209020157,192607.55445075926 6270222.555224079,192756.95633935288
6270062.772818872,192822.64597087 6269995.906593106,192877.8047785581
6269946.151545336,192950.19584342095 6269885.764165967,193028.06382723083
6269828.853568001,193081.4526550153 6269795.378919636,193143.23497240557
6269758.885938274,193203.2473098922 6269726.344235049,193277.89816041818
6269691.106408963,193383.50696133377 6269650.425386225,193473.76480446896
6269622.140405321,193562.74247346004 6269598.857935085,193760.70192393768
6269560.042655652,193859.23080523883 6269538.235634942,193947.90791160477
6269513.155934936,194042.86343725142 6269480.309949474,194138.18631721768
6269439.375585526,194224.10270021195 6269397.305304478,194320.43858754443
6269340.66930346,194475.90738838635 6269233.418035558,194494.54227114512
6269220.615801189,194664.23770291038 6269112.128240871,194828.89036174273
6269037.198367567,195010.69735410626 6268978.30961655,195148.03220989797
6268949.297773971,195257.4258735005 6268935.122532327,195372.96437299484
6268930.30702502,195454.81759457514 6268931.917845822,195574.4415193816
6268933.816919159,195727.56147896775 6268938.327220044,195820.25721895127
6268939.463273653,195941.77357510122 6268941.85407354,195965.09500842242
6268942.464490643,196037.35248989632 6268942.277974303,196407.6901718674
6268913.825802466,196571.5524623151 6268895.682930008,196777.5714439262
6268865.060562559,197081.7074247225 6268811.0732258195,197359.3048389137
6268768.921292356,197475.16616493132 6268757.28970169,197670.76564220418
6268743.233471346,198172.98352491803 6268730.66935761,198995.62342993126
6268720.665555703,199347.37075693987 6268728.414262247,199766.67788291088
6268759.137868818,200210.07454668958 6268814.12526456,200531.89919457294
6268876.590566079,200935.03159853164 6268964.35475524,201114.24484675977
6268993.722728287,201231.23049963443 6269013.934464141,201370.8140091401
6269028.9067794895,201490.69396877536 6269036.316644114,201616.45159752454
6269038.826164957,201729.85276279564 6269034.231029387,201869.69230713014
6269026.32943679,202013.5616170314 6269008.321972242,202197.13858929859
6268977.800933472,202565.27214535192 6268895.954225012,202962.90536646548
6268805.5965146255,203348.71645765682 6268718.393507428,203397.96420038375
6268706.863719617,203489.92523172806 6268685.499742586,203619.6903621458
6268658.896579973,203844.1883792286 6268616.202833018,204131.44832522067
6268588.548658428,204371.29730008382 6268588.718211642,204675.25516969484
6268610.488872914,204941.39780828342 6268652.775660202,205011.76285841386
6268673.444379371,205136.97502165815 6268706.69416403,205236.40559083468
6268736.841200623,205346.28906019675 6268772.973701606,205514.38149129457
6268842.237984302,205880.70053964798 6269000.77648296,206415.36805392808
6269237.284144589,206920.04609738846 6269441.325643939,207099.98292230672
6269503.846450623,207507.6237656426 6269626.668030797,207670.59550016397
6269669.010772909,207843.78636394013 6269708.640515808,208195.21086442543
6269775.453596626,208326.70144695044 6269795.412835121,208401.7530476433
6269804.53610511,208587.40056243923 6269826.15727683,208844.6265098152
6269851.678809498,209191.79860575218 6269865.550345944,209374.51841794027
6269862.04006501,210445.4453152188 6269847.066274299,210891.858737198
6269838.536482385,211903.04046376777 6269819.865934097,211997.6842948402
6269818.136239613,212192.64925101554 6269814.931218413,212407.40681265394
6269808.080277704,212479.0297730303 6269801.093680517,212650.52858054647
6269780.625697236,212924.0071735783 6269723.664934162,213171.13644313932
6269647.220428596,213310.74221654324 6269590.3114362415,213451.52797654943
6269524.686822251,213657.66940960046 6269410.09084941,213828.21086949573
6269294.6825062595,213881.0430998262 6269257.089502756,214002.68190741603
6269159.029694296,214111.9642515278 6269056.952388293,214243.57728549268
6268925.338916485,214374.81183318887 6268788.657730618,214873.33390880836
6268207.147302767,215218.01244815157 6267810.013090632,215882.93489860886
6267037.414654649,216116.60564173307 6266750.062595269,216274.74611035397
6266549.306755744,216459.60325676532 6266299.9747393485,216683.26637766714
6265986.527581096,216817.5844752583 6265785.0440774225,217058.769284011
6265410.989382424,217213.72601519522 6265167.233065622,217368.43784349976
6264940.143649308,217465.0075017629 6264806.035119937,217572.3306228367
6264677.623069013,217658.02436684936 6264585.649580556,217711.70262530987
6264529.503367279,217716.7120023956 6264524.385318675,217819.73819112475
6264423.8213760685,218037.39005952372 6264242.168710179,218235.13800296892
6264110.545412234,218316.47915489157 6264061.960376094,218399.21180044912
6264015.256642067,218491.45113052044 6263968.7056804495,218519.58156584387
6263954.80992066,218626.33695751466 6263902.701024731,218868.96891964765
6263798.060552794,219003.18682969714 6263742.902412033,219524.27336610042
6263522.578458384,219917.03079351725 6263360.025015918,220398.06457713316
6263157.553507509,220812.79647203258 6262984.230630194,221226.7046027001
6262802.134449159,221473.62236522866 6262688.324208363,221777.62476263603
6262540.71374249,221856.95103177536 6262498.677762082,221929.31983274
6262464.012213491,222114.2103749986 6262367.962615812,222255.61952415327
6262288.670419796,222381.59979188404 6262211.056278395,222434.3429666219
6262170.733124265,222484.49239722424 6262128.885348189,222542.9351298907
6262075.178181773,222597.90469444444 6262018.862263656,222674.04722614703
6261927.527586906),(212490.06153456794
6198000.715026029,212379.49901631207 6197893.050431567,212340.8711530068
6197854.040638241,212310.31395278405 6197824.245347578,212241.1066253579
6197762.149741283,212189.75494425494 6197720.618408016,212145.14922429406
6197687.427115726,212111.6309256162 6197664.038597945,212062.349787042
6197631.318320755,212029.2545024292 6197610.889228954,211996.00337052924
6197590.880536372,211946.154502552 6197563.8268411225,211885.16255354637
6197533.5785913365,211819.5842415201 6197503.4481459,211775.4015356242
6197485.4573616,211727.4896267868 6197467.0294574825,211667.66653243446
6197446.92022078,211615.80278167388 6197431.636560121,211558.41758416998
6197414.469796878,211474.1153337922 6197390.611248074,211228.5556690513
6197324.248180438,210481.3347190506 6197120.454419101,209765.6617127406
6196925.240006449,209577.96591931404 6196872.246564336,209373.60559811577
6196811.015339376,209173.5422092621 6196747.19545404,208980.7702470554
6196679.374741058,208855.96996592707 6196631.56095884,208734.5204014716
6196583.814693298,208336.28605510772 6196426.169858823,208073.10451497426
6196315.784907852,207715.27914376836 6196180.6720451135,207378.07014225743
6196062.170566912,206998.59313009222 6195938.5266493885,206917.69725613273
6195916.252443212,206501.23990912602 6195782.726103228,206074.01796735957
6195639.6536853695,205728.7828305624 6195515.713326804,205494.16587176654
6195425.326928047,205105.83896008326 6195256.49167308,205032.43488785418
6195226.503762168,204922.08387663082 6195178.126626321,204769.09750043362
6195112.066561723,204479.92285919993 6194989.764344907,204439.89237031064
6194973.157197529,204396.65588008653 6194955.844112794,204320.33523719865
6194926.243862112,204097.5515402741 6194843.007365857,204040.51143319166
6194821.66049573,203908.72028804146 6194776.042245602,203860.04027471755
6194759.502748834,203805.86107854848 6194742.34137406,203665.11984633855
6194695.412502371,203435.89075089706 6194625.322226611,203163.3138457406
6194546.509174163,202803.61830708943 6194456.637300373,202659.47069846117
6194421.677112061,202233.5177988898 6194319.839574057,201938.05360642634
6194250.307034981,201636.93438383052 6194178.287587824,201488.12248853804
6194143.177277796,201408.89640694048 6194124.672572378,201340.34586451
6194105.764536182,201184.33159816323 6194069.242732725,201132.23407647194
6194055.343311639,201081.4835206193 6194042.704438166,201023.70870489758
6194027.695800286,200964.11938147596 6194012.888872159,200889.20136417207
6193991.880221502,200718.41500139705 6193941.896648272,200622.92514219458
6193909.728491724,200503.95800238382 6193874.636095934,200456.98117726902
6193859.07313529,200414.7242985639 6193844.804311923,200306.24345478584
6193806.552554789,200149.65032708697 6193748.923145034,200057.88967082606
6193713.881831132,199998.3226113026 6193691.478994754,199907.66401800056
6193654.858131102,199882.28317409966 6193643.648380099,199852.04880040025
6193630.758025001,199781.7839378115 6193599.565799282,199765.854118679
6193592.776127363,199526.86230389492 6193485.284914192,199499.21054238186
6193472.7309163585,199394.03588748036 6193424.985559544,199020.4142805309
6193258.156209193,198857.6985808384 6193193.65713112,198534.29319618578
6193069.365861583,198394.4425199022 6193021.286667081,198375.74084544892
6193015.421729742,198159.32462339773 6192945.244454814,197966.2409666168
6192883.638157201,197677.7453742769 6192795.531507291,197673.94937964086
6192794.6240622755,197522.10959419888 6192747.537881321,197285.61133600856
6192673.195347736,197012.8340557687 6192588.2500511715,196679.29859745392
6192495.844646442,196342.17865153556 6192413.388078894,196240.06528263088
6192391.391954001,196167.58516217538 6192376.537460241,195831.57841116496
6192314.817652284,194658.80531175964 6192153.185458943,194042.79664555693
6192070.866634535,193426.9549585904 6191979.256582095,192988.79031087898
6191898.6701241145,192768.21073987213 6191854.075693898,192551.63867053378
6191805.583296708,192222.4001445636 6191732.811613842,191578.17198744477
6191587.639761255,190985.30664337796 6191453.643633212,190757.43564572415
6191397.979153161,190516.66271908736 6191332.637280303,190274.14207644516
6191260.004051219,190008.6339589541 6191166.638582807,189832.66010790807
6191103.045809532,189506.87248615248 6190971.846262171,189370.4170543381
6190911.027078318,189254.22176984805 6190857.684643403,189119.83688056245
6190793.237347289,188957.42174349504 6190710.242851276,188742.1298483009
6190594.320718837,188531.26846884025 6190474.384973415,188113.51981574032
6190218.475056823),(188204.74613844542
6190253.283595123,188541.92174410916 6190454.426646578,188750.4565462122
6190576.176527881,188965.8041011518 6190693.42564406,189127.42886983452
6190774.471112138,189260.91207124476 6190839.825502848,189377.39678641086
6190893.184626676,189514.19730864666 6190953.8356740605,189839.0164508324
6191085.774195124,190014.7342670496 6191150.744545293,190279.73031488297
6191241.219985933,190538.85982555154 6191318.658317842,190810.07863292028
6191390.653580105,190989.77055495876 6191437.026580091,191582.42439199306
6191569.291828281,192261.58460532286 6191718.22710756,192557.19351312437
6191786.176333629,192775.04575660682 6191835.189502212,192992.80894449662
6191879.380567987,193430.10530017983 6191959.126698984,194044.73360469672
6192050.988580879,194660.00756226023 6192134.298603812,195836.8326911304
6192296.182491913,196171.15851782984 6192357.71732437,196246.9002993656
6192373.159914935,196347.23255641756 6192394.651880307,196685.8107876653
6192475.612718563,197017.70984946546 6192570.168827414,197292.43522079417
6192654.576207245,197526.96312399744 6192729.002600291,197682.89946670068
6192776.592813748,197961.43196461452 6192863.690987247,198096.13968042345
6192903.030817104,198165.8479455582 6192924.893825473,198382.62038997991
6192996.7514260365,198540.39350428124 6193050.493779081,198873.33896929485
6193177.994583501,199030.2215276698 6193242.980900124,199395.08229069386
6193404.650589195,199538.8402811043 6193469.82350049,199773.4795037983
6193575.297788921,199789.36479513452 6193581.331172849,199820.723495691
6193595.36426899,199891.18873336315 6193625.817007487,199915.07789608737
6193635.967944528,200004.9461210048 6193670.303074583,200064.95845849146
6193695.092351473,200159.0122962627 6193730.92348808,200310.99679704275
6193786.149447056,200422.96194088264 6193826.165802465,200463.87185374915
6193839.611071189,200510.74849132219 6193855.42609571,200628.39092919254
6193892.753703668,200721.8436417135 6193922.316747496,200893.4649006695
6193972.56911555,200968.67234864942 6193992.670145828,201027.8497899551
6194008.014860586,201083.55406314804 6194022.8553941585,201138.41230821097
6194037.258971866,201189.69719761945 6194049.763381143,201411.9465609882
6194103.663645866,201493.031678082 6194122.97504919,201642.9790321806
6194159.31220363,201941.86073301145 6194230.306240591,202255.09151620558
6194300.326034044,202664.54686724136 6194400.39852927,202837.5930156795
6194439.106764922,203168.4679381644 6194523.263749096,203445.46422710526
6194602.026162016,203544.5163100131 6194632.66739151,203672.2442937493
6194674.956839473,203865.63964510447 6194740.862236623,204047.00135950488
6194802.280273382,204104.97655030998 6194824.333053703,204333.71583999204
6194906.039775093,204468.23431266664 6194958.197345543,204544.04288589687
6194988.957519183,204614.67510280517 6195017.784777341,204737.99483470593
6195070.144740824,204851.76335429668 6195121.025822879,204968.28146531
6195172.478722892,205110.74814962727 6195237.900500616,205503.0602990809
6195403.625594119,205734.4378606947 6195496.432383454,206084.40407585062
6195621.465118841,206507.6630437448 6195761.897998581,206924.91075913614
6195893.927863353,207384.72704780684 6196043.443147057,207720.80059051173
6196161.860308602,208083.39043592356 6196298.485903498,208236.52152745883
6196359.646195032,208345.10255877854 6196404.499596358,208731.15855284967
6196561.471550474,208811.66480859133 6196592.422450956,208985.97999922454
6196659.855791187,209181.13419853422 6196729.021332928,209374.61860548198
6196791.294338468,209579.6579755741 6196852.542234097,209771.3835345674
6196905.720492717,210481.1343439671 6197100.177870892,211234.67824104498
6197305.4843564965,211596.0992318035 6197403.002889102,211707.1070280225
6197433.032096752,211758.9262509868 6197446.735269826,211853.89290858255
6197472.6452561505,211909.9088763497 6197488.736053101,211991.0162573417
6197515.049699872,212032.62748300022 6197529.0388410585,212078.90299532298
6197546.979275725,212142.61113990398 6197573.663009996,212210.04848742654
6197605.760946121,212285.33385905004 6197644.584646139,212343.40923739687
6197677.574001187,212396.99844026475 6197709.974985597,212446.14599544997
6197742.981408434,212509.27527867886 6197788.497862243,212569.9666650594
6197837.024353374,212630.29069712025 6197885.43341908),(196631.9766819177
6268913.673198705,196283.42422429487 6268957.199294584,196174.40904696102
6268969.509403638,195991.07697757357 6268986.5333305355,195876.45129790375
6268988.245898784,195746.86427867127 6268985.566831778,195721.3387194324
6268983.786439614,195652.521010224 6268976.308796625,195572.19286566757
6268967.050771607,195481.43408482382 6268961.370486556,195393.74772192593
6268960.709199883,195302.0204615123 6268964.507359918,195173.55776913685
6268976.902260108,195047.6220292024 6268998.402622558,194880.38675818368
6269047.372106385,194732.28730763233 6269108.8726181835,194617.03823881404
6269169.780100242,194446.2407440899 6269280.862776473,194310.3864375258
6269374.922168917),(196631.9766819177 6268913.673198705,196220.71795513103
6268983.0573267415,196106.35944223907 6268998.402622558,195991.5445194349
6269007.931980497,195870.78513582237 6269011.831898765,195757.01661623162
6269010.05150107,195649.23708524558 6269002.845133285,195504.9224973812
6268987.109838621,195374.35586662975 6268981.870398944,195278.09790294082
6268987.957644698,195175.8398186981 6268996.622227694,195123.84248454857
6269004.845959488,195079.53732721283 6269013.103611632,194983.84709292694
6269036.164038138,194885.75235763993 6269066.3292057,194730.49506383055
6269133.069385506,194622.70440089543 6269189.195300187,194523.87495696914
6269247.1189913,194310.3864375258 6269374.922168917),(222375.4104281959
6262244.687291328,222306.75969822367 6262289.144815342,222214.37565281437
6262342.988882456,222115.24564626295 6262398.307325896,221924.88931700645
6262495.356911591,221788.23351010866 6262561.994431308,221749.14923689113
6262582.597442175,221482.4833966958 6262710.0796876205,221236.01091213044
6262824.262984011,220819.9988430869 6263007.342401228,220407.61578944323
6263180.818252401,219927.29445056838 6263381.409435056,219530.9191397008
6263545.623919324,219012.6601183636 6263766.219603694,218879.58879906934
6263822.32685951,218705.75228224657 6263893.838307869,218520.03797575616
6263979.347814357,218490.1486924782 6263994.362057897,218408.25094310154
6264037.557812361,218325.8745199145 6264082.9229123965,218244.90072231152
6264132.050353388,218053.4089342489 6264260.657482187,217837.0038441468
6264442.852849489,217784.0825582237 6264493.355096953,217728.20017384543
6264546.501411833,217658.1579502383 6264620.205192584,217541.57304753052
6264753.565079774,217384.59030161385 6264956.820506265,217233.96389862147
6265182.18162379,217114.51808500028 6265370.05776213,217054.32763632835
6265464.734680305,216838.23424080043 6265799.298788547,216701.3669268701
6265999.426621184,216479.58510536267 6266315.416871801,216294.72795895135
6266564.749343449,216136.38711524702 6266765.352984541,215902.29335805785
6267053.485366645,215235.44508040982 6267830.493258173,214892.12463885426
6268223.8306030845,214377.20520224093 6268825.044789955,214251.2694623065
6268952.722895732,214128.18350133637 6269077.791658462,214009.2608893219
6269184.023561346,213892.23070865095 6269278.014049706,213843.42824388717
6269314.742350535,213670.8273734122 6269430.0661824485,213462.23691156376
6269544.865912889,213305.5324643741 6269618.477608959,213177.59297360538
6269668.671623153,212927.60279313088 6269747.659969178,212654.14646399723
6269802.8233715175,212483.09293444428 6269824.614116857,212408.41982002018
6269831.159830317,212191.34681297326 6269838.383861936,211998.31881593776
6269841.673681193,211873.9415488744 6269845.557026199,210892.30401516115
6269862.04006501,210446.35813504332 6269870.315512252,209374.51841794027
6269887.171673696,209190.60748720073 6269888.273938942,208845.5170657416
6269873.89362822,208584.40606813686 6269851.678809498,208322.51583409662
6269819.798102936,208119.68058992218 6269787.374869348,207838.4764242293
6269733.17815191,207666.2651719721 6269693.32784602,207500.0763041668
6269651.188471549,207094.13864904008 6269527.942605048,207010.21488493102
6269499.573248141,206915.03672030274 6269469.050436069,206405.47175119657
6269260.463879191,205872.1289388569 6269025.413802074,205509.60588513955
6268865.823577013,205338.81952236447 6268798.356409601,205229.83774087788
6268760.79952401,205129.21605314984 6268728.482084657,205004.1708691418
6268697.33470097,204937.22332737868 6268683.159881713,204672.08256420726
6268635.854137745,204370.6739109354 6268613.6256161155,204261.52515021258
6268613.47301777,204135.43356299106 6268617.254066456,203986.54374405506
6268624.867035082,203844.71158083534 6268640.4999231035,203624.3657807591
6268684.635011318,203495.53573406406 6268709.915720742,203397.38533903164
6268732.63620819,203350.37511806964 6268743.369116401,202970.9426337008
6268826.943839294,202600.93891020207 6268911.401098567,202196.83802667345
6268999.894763305,202016.15536116686 6269030.53457528,201871.68492601535
6269047.066894041,201731.35557592136 6269057.528901179,201616.9970630294
6269060.801460366,201488.60116234847 6269057.8171576345,201368.87705000027
6269051.84855534,201231.82049293566 6269038.114003561,201055.81324604238
6269011.509731532,200931.7922013496 6268991.348869861,200526.58925486208
6268901.057963869,200204.19687757565 6268843.136643355,199764.70752792383
6268786.250018328,199346.39114542087 6268756.679297957,198995.5343743386
6268745.810727753,198173.98540033516 6268752.711674767,197670.8101700005
6268765.411466662,197477.55953398338 6268779.162531202,197360.328978229
6268791.52324825,197084.12305767272 6268832.776636343,196819.97303796935
6268881.422998699,196631.9766819177 6268913.673198705))'
) as way ) as t ) as t
}}}
result (screen from pgAdmin)
Version: `POSTGIS="3.2.2 628da50" [EXTENSION] PGSQL="140"
GEOS="3.9.0-CAPI-1.16.2" PROJ="7.2.1" GDAL="GDAL 3.2.2, released
2021/03/05" LIBXML="2.9.10" LIBJSON="0.15" LIBPROTOBUF="1.3.3"
WAGYU="0.5.0 (Internal)" TOPOLOGY RASTER`
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5225>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list