[postgis-users] Convert lines to polygon

[Vera Schulze]

Michael Fuhr schrieb:
> On Wed, Aug 16, 2006 at 04:56:15PM +0200, Vera Schulze wrote:
>> Sorry, I was wrong saying datasets. The geometry of the lines are stored 
>> in the same table but in different records and I'm looking for a way to 
>> join these lines into a polygon.
>>
>> I tried what you suggested but the resultset is empty if the linestring 
>> doesn't contain end- and startpoint in one record.
> 
> What do you mean by "doesn't contain end- and startpoint in one
> record"?  Could you post an example of what the data looks like and
> what query you ran?
> 
Hi Michael,

thanks for your help!

this is the query:
SELECT oid, ogc_fid, astext(polygonize(the_geom)) FROM 
countries_dcw_test WHERE cntry_code = 'QT' GROUP BY oid, ogc_fid

And I attached the data as csv-file.

There are 27 records and originally they are of type line. Some of the 
records contain start and endpoint, the others doesn't.

Thank you for any hint.

-- 

Mit freundlichen Grüßen

Vera Schulze

----------------------------------

  Vera Schulze
  CCGIS GbR
  Siemensstraße 8
  53121 Bonn
  Germany

----------------------------------
   v.schulze at ccgis.de
         www.ccgis.de
----------------------------------
  Tel.:      ++49 (0) 228 90826 28
  Fax.:      ++49 (0) 228 90826 11
  Zentrale:  ++49 (0) 228 90826 0
----------------------------------
-------------- next part --------------
oid;ogc_fid;asewkt
"45013412";"1";"SRID=4326;LINESTRING(51.21949 26.177586,51.218208 26.174467,51.220387 26.170191,51.21904 26.165319,51.226372 26.163696,51.22879 26.16608,51.225399 26.168989,51.227833 26.171722,51.248165 26.174623,51.254318 26.172684,51.254757 26.174074,51.250599 26.177357,51.240082 26.17697,51.238476 26.175615,51.21949 26.177586)"
"45013409";"2";"SRID=4326;LINESTRING(50.829922 24.742144,50.858879 24.755859,50.87244 24.764015,50.870449 24.773252,50.87571 24.789656,50.877663 24.795767,50.878479 24.798315,50.877323 24.801788,50.866627 24.814232,50.862587 24.830872,50.866776 24.836508,50.866699 24.842482,50.870026 24.852964,50.866062 24.86363,50.872437 24.874954,50.866085 24.890045,50.86694 24.893469,50.85857 24.908381,50.859322 24.911116,50.859699 24.912487,50.857773 24.915522,50.833424 24.934967,50.830765 24.947439,50.828136 24.952328,50.816143 24.964111,50.805473 24.978388,50.803654 24.985096,50.805393 24.993092,50.803078 25,50.804115 25.009893,50.806496 25.013741,50.807091 25.017225,50.807709 25.02083,50.812901 25.026217,50.822144 25.032188,50.818386 25.050201,50.812687 25.062288,50.812157 25.070112,50.805767 25.075783,50.801029 25.086239,50.785732 25.097872,50.780754 25.100061,50.777 25.109802,50.779522 25.122286,50.781113 25.130148,50.78297 25.151009,50.780106 25.165323,50.775578 25.174625,50.771889 25.195621,50.77457 25.201071,50.770576 25.211506,50.77356 25.227516,50.770382 25.240002,50.770008 25.245117,50.768932 25.259796,50.77116 25.267094,50.769463 25.278393,50.77113 25.283638,50.775043 25.288137,50.776749 25.294758,50.773052 25.315527,50.77169 25.338537,50.77103 25.342001,50.767796 25.343689,50.767387 25.347145,50.769287 25.351694,50.770161 25.36454,50.769676 25.36673,50.767254 25.377708,50.769543 25.387074,50.761749 25.397373,50.765236 25.404411,50.765366 25.409004,50.761936 25.412764,50.758171 25.413774,50.757233 25.416325,50.763374 25.427666,50.761768 25.433449,50.767063 25.450554,50.77039 25.469545,50.775566 25.482517,50.770885 25.495729,50.768383 25.49671,50.764557 25.495653,50.763386 25.498899,50.779812 25.515734,50.791435 25.523952,50.798836 25.526068,50.805386 25.524988,50.815632 25.511868,50.819603 25.491776,50.825623 25.490019,50.829208 25.482805,50.828789 25.479156,50.828186 25.473869,50.831783 25.458384,50.840527 25.45472,50.849194 25.457031,50.854923 25.462633,50.854519 25.466091,50.851341 25.469847,50.845364 25.472982,50.840256 25.480003,50.841846 25.482492,50.847927 25.4828,50.850536 25.485493,50.839077 25.500256,50.842247 25.504772,50.840343 25.508957,50.835682 25.513899,50.832352 25.521105,50.828762 25.521444,50.82579 25.521727,50.823345 25.524775,50.827282 25.529503,50.831123 25.539749,50.83543 25.539871,50.841583 25.551208,50.838978 25.557249,50.842133 25.561308,50.841774 25.566372,50.832775 25.587509,50.834175 25.59207,50.83297 25.594168,50.823372 25.595095,50.812283 25.588245,50.807236 25.588829,50.800369 25.596581,50.803619 25.600136,50.806126 25.602875,50.809143 25.610844,50.813457 25.611197,50.819901 25.614944,50.822582 25.611431,50.825367 25.611362,50.830639 25.618357,50.839005 25.618608,50.86161 25.596962,50.863155 25.59831,50.858524 25.606197,50.85202 25.609529,50.844383 25.618847,50.844425 25.620682,50.852974 25.618231,50.860611 25.609161,50.86095 25.612806,50.864239 25.612747,50.868172 25.607626,50.869045 25.612658,50.859573 25.619257,50.849552 25.6238,50.844894 25.630541,50.844673 25.631922,50.848751 25.633224,50.850319 25.63549,50.848938 25.641712,50.850521 25.644667,50.856655 25.635834,50.859921 25.634855,50.863258 25.63686,50.869312 25.636061,50.872276 25.632793,50.873672 25.62726,50.877167 25.62513,50.879471 25.626234,50.879066 25.630831,50.880844 25.631027,50.88533 25.627962,50.879147 25.597151,50.874931 25.589043,50.874313 25.587851,50.868069 25.582262,50.865494 25.572214,50.868122 25.566862,50.875683 25.565754,50.87746 25.557436,50.87291 25.540545,50.879326 25.526365,50.879189 25.521772,50.883961 25.520569,50.885925 25.51457,50.892269 25.513506,50.894661 25.51166,50.897675 25.513802,50.898434 25.521791,50.895016 25.522329,50.895565 25.524096,50.897587 25.52582,50.901524 25.526155,50.903408 25.523878,50.902309 25.520952,50.901257 25.518152,50.907372 25.510418,50.904545 25.504728,50.899929 25.501831,50.894482 25.506981,50.89143 25.506121,50.880993 25.491629,50.882164 25.487476,50.88665 25.48464,50.882954 25.477596,50.887344 25.470631,50.890373 25.470345,50.893238 25.474192,50.893826 25.477852,50.896927 25.480778,50.90649 25.478992,50.911659 25.472931,50.915443 25.47263,50.916267 25.475597,50.909367 25.483299,50.909908 25.484894,50.918106 25.478546,50.92041 25.479879,50.91037 25.494064,50.920105 25.499847,50.92659 25.507069,50.921318 25.519789,50.918804 25.520294,50.917732 25.51779,50.920376 25.511774,50.917336 25.511374,50.912437 25.518349,50.914295 25.522215,50.919956 25.522579,50.924908 25.527279,50.92028 25.533371,50.91449 25.534437,50.91354 25.53653,50.917305 25.543789,50.916821 25.545944,50.916634 25.546793,50.919056 25.551558,50.917908 25.555492,50.9226 25.559971,50.924015 25.564989,50.920921 25.571503,50.927563 25.581905,50.931717 25.585247,50.929276 25.588297,50.927929 25.594076,50.933861 25.597603,50.936493 25.602619,50.937714 25.609705,50.940182 25.610083,50.94389 25.602631,50.950939 25.601301,50.954582 25.596151,50.955181 25.590851,50.964466 25.588083,50.972988 25.593142,50.977585 25.598352,50.979195 25.602314,50.97559 25.611761,50.983315 25.622223,50.982441 25.625364,50.979496 25.625446,50.974884 25.619791,50.972416 25.619415,50.956837 25.623413,50.955811 25.622107,50.962097 25.619261,50.961086 25.618399,50.957653 25.618494,50.950432 25.622702,50.943897 25.619638,50.940807 25.617878,50.934532 25.619877,50.930649 25.625492,50.922127 25.628468,50.920147 25.631069,50.909454 25.645107,50.905903 25.661974,50.901798 25.668743,50.905769 25.674389,50.902622 25.696301,50.898914 25.707888,50.907043 25.716875,50.910892 25.726889,50.914219 25.727955,50.922821 25.735779,50.923073 25.742546,50.919785 25.74436,50.912247 25.763628,50.913628 25.775776,50.916821 25.78075,50.923759 25.783792,50.928463 25.788269,50.936272 25.80324,50.938618 25.805248,50.945168 25.803701,50.951385 25.799635,50.95826 25.792103,50.959671 25.788389,50.963394 25.785765,50.966682 25.777176,50.960793 25.766985,50.960941 25.763535,50.957832 25.761316,50.957684 25.756493,50.964912 25.760674,50.974289 25.760431,50.976006 25.766823,50.98732 25.771816,50.989468 25.775669,50.986862 25.781712,50.987259 25.786299,50.995358 25.793903,50.996258 25.798477,50.992588 25.802938,50.994507 25.807486,50.992535 25.81765,50.989082 25.820957,50.985077 25.82267,50.970833 25.821659,50.967628 25.82473,50.964169 25.827806,50.964684 25.836298,50.967789 25.846561,50.965992 25.854193,50.969879 25.856852,50.974453 25.865238,50.972767 25.868269,50.96759 25.864956,50.962738 25.872435,50.964134 25.876537,50.969292 25.879162,50.974812 25.876951,50.980751 25.880245,50.985523 25.886787,50.985352 25.889551,50.991543 25.892609,50.99892 25.901381,51.001167 25.916494,50.998695 25.935177,50.999481 25.952396,50.99506 25.957338,50.993439 25.970713,50.995682 25.977551,51.000309 25.979269,51.00396 25.970791,51.004814 25.968807,51.003674 25.964701,51.006866 25.961168,51.010391 25.960157,51.011547 25.95645,51.013809 25.955702,51.016739 25.959991,51.024475 25.963697,51.030479 25.968828,51.031193 25.983521,51.040161 25.977768,51.041985 25.971054,51.036617 25.962,51.041588 25.958422,51.049683 25.965336,51.050343 25.970144,51.046043 25.978992,51.047474 25.984013,51.04171 25.986692,51.040504 25.988792,51.042892 26.00827,51.046616 26.013458,51.0471 26.020802,51.045929 26.024052,51.049187 26.030632,51.04882 26.037893,51.042065 26.039936,51.042114 26.041374,51.052441 26.045258,51.076637 26.054504,51.084404 26.058895,51.08688 26.064806,51.089481 26.066576,51.093185 26.071075,51.096218 26.070534,51.101158 26.065805,51.104752 26.066858,51.114677 26.075098,51.119125 26.078888,51.124058 26.074158,51.124451 26.070469,51.128448 26.068293,51.133068 26.069548,51.138725 26.071463,51.150616 26.077349,51.155861 26.082264,51.160347 26.0872,51.158916 26.090227,51.162148 26.095657,51.161606 26.102568,51.165703 26.111193,51.186989 26.124176,51.191502 26.129801,51.19035 26.133511,51.192352 26.140352,51.194942 26.141661,51.196064 26.137033,51.198574 26.136044,51.212845 26.136572,51.223907 26.140175,51.228901 26.13728,51.23555 26.138245,51.241898 26.145426,51.246193 26.152203,51.250324 26.153929,51.262825 26.15473,51.271133 26.144382,51.271935 26.14551,51.279495 26.143229,51.28545 26.138693,51.300262 26.13732,51.303211 26.137045,51.309158 26.132278,51.319466 26.12854,51.321655 26.125488,51.342426 26.115244,51.368561 26.098173,51.364799 26.092304,51.365959 26.089052,51.36454 26.077368,51.367744 26.074287,51.363739 26.061298,51.36591 26.05043,51.367016 26.049341,51.377964 26.038589,51.37759 26.035152,51.380459 26.029781,51.38974 26.018709,51.398026 26.015711,51.406471 26.009949,51.408211 25.994036,51.405369 25.985382,51.408478 25.979774,51.407326 25.968544,51.411953 25.962662,51.432457 25.9531,51.440136 25.947359,51.450493 25.945677,51.476177 25.946301,51.488537 25.950993,51.512905 25.95027,51.516979 25.951057,51.530796 25.945101,51.533588 25.941896,51.531139 25.940298,51.524899 25.943375,51.521416 25.942528,51.547855 25.923782,51.548805 25.924391,51.545761 25.927843,51.545639 25.931442,51.551594 25.927895,51.568859 25.922064,51.575111 25.919224,51.582634 25.908434,51.583271 25.891159,51.580894 25.876961,51.587162 25.870094,51.594772 25.85247,51.595245 25.842588,51.598488 25.831953,51.599949 25.812407,51.602375 25.807234,51.607349 25.796623,51.607182 25.782166,51.604824 25.779469,51.602051 25.779993,51.602921 25.801319,51.59729 25.808109,51.593834 25.820127,51.591824 25.847031,51.589294 25.847321,51.588345 25.840687,51.585396 25.835247,51.586479 25.825394)"
"45013413";"3";"SRID=4326;LINESTRING(51.276943 26.163931,51.271595 26.16655,51.268833 26.165581,51.265999 26.162508,51.265907 26.160055,51.268681 26.161375,51.272926 26.160543,51.29245 26.141708,51.297123 26.141916,51.297215 26.144369,51.288139 26.151312,51.284763 26.154572,51.282612 26.15955,51.276943 26.163931)"
"45013414";"4";"SRID=4326;LINESTRING(51.600739 25.769695,51.602722 25.776993,51.604961 25.775562,51.60479 25.760878,51.602642 25.756796,51.59185 25.751545,51.590603 25.752264,51.591175 25.754545,51.599983 25.761221,51.601639 25.765772,51.600739 25.769695)"
"45013415";"5";"SRID=4326;LINESTRING(51.589649 25.763073,51.582405 25.757967,51.579395 25.750235,51.580341 25.747915,51.58342 25.74922,51.59129 25.758444,51.593185 25.76276,51.591972 25.764626,51.589649 25.763073)"
"45013418";"6";"SRID=4326;LINESTRING(51.575668 25.718681,51.572948 25.71986,51.572021 25.722866,51.567589 25.727331,51.554661 25.735899,51.550591 25.735306,51.547142 25.738829,51.545498 25.743229,51.539402 25.746407,51.535484 25.747595,51.534058 25.750841,51.536964 25.765177,51.538971 25.754398,51.545765 25.752632,51.549393 25.755531,51.554054 25.750143,51.553997 25.748079,51.55706 25.748924,51.55743 25.744097,51.559895 25.741743,51.570217 25.739433,51.571278 25.749968,51.579884 25.767208,51.579006 25.767714,51.577393 25.768644,51.566139 25.756285,51.562572 25.75568,51.563705 25.759785,51.567375 25.764059,51.566662 25.765684,51.560333 25.765833,51.560444 25.769732,51.564983 25.768936,51.571411 25.772228,51.583336 25.772635,51.589241 25.775248,51.592651 25.779299,51.593876 25.786615,51.597729 25.788359,51.600464 25.795179,51.590508 25.819059,51.586479 25.825394)"
"45013419";"7";"SRID=4326;LINESTRING(50.772884 25.750376,50.767452 25.74963,50.768288 25.745157,50.77359 25.741901,50.77755 25.742687,50.779587 25.744858,50.778286 25.750233,50.772884 25.750376)"
"45013420";"8";"SRID=4326;LINESTRING(50.79068 25.753462,50.783123 25.747877,50.787834 25.741522,50.796299 25.744856,50.796848 25.746622,50.795982 25.750204,50.79068 25.753462)"
"45013421";"9";"SRID=4326;LINESTRING(51.575668 25.718681,51.578106 25.718191,51.583435 25.713535,51.58548 25.714174,51.585548 25.716469,51.588131 25.718243,51.58746 25.721243,51.581203 25.723917,51.58482 25.726355,51.584881 25.728367)"
"45013422";"10";"SRID=4326;LINESTRING(51.495403 25.541622,51.505913 25.559696,51.505806 25.563837,51.50246 25.562328,51.498718 25.563818,51.496887 25.576515,51.499146 25.583113,51.496498 25.587099,51.502468 25.602335,51.519917 25.608074,51.523991 25.608898,51.525658 25.614138,51.522121 25.614449,51.519806 25.613127,51.523861 25.622211,51.523697 25.625429,51.532269 25.626616,51.531216 25.624054,51.5341 25.623077,51.533752 25.619106,51.537312 25.612652,51.548393 25.614929,51.556339 25.62068,51.559311 25.633839,51.561935 25.638117,51.559937 25.644777,51.560108 25.65074,51.56353 25.655249,51.561623 25.659426,51.551754 25.659658,51.548279 25.662035,51.545177 25.659811,51.542789 25.655966,51.547554 25.645527,51.546524 25.644863,51.542793 25.647245,51.540348 25.650286,51.53933 25.659042,51.540611 25.668411,51.542698 25.673319,51.547855 25.677349,51.54874 25.681356,51.544044 25.682165,51.538666 25.680162,51.538483 25.674772,51.53664 25.671785,51.532818 25.670429,51.531464 25.676199,51.535675 25.681839,51.532677 25.683285,51.525826 25.682756,51.514832 25.688061,51.513618 25.689926,51.519577 25.694607,51.525677 25.695383,51.535191 25.700439,51.545914 25.703402,51.549904 25.701242,51.557274 25.702217,51.558418 25.700884,51.566162 25.70129,51.567745 25.700005,51.562443 25.696882,51.563805 25.694616,51.568409 25.693005,51.571068 25.68858,51.570557 25.683775,51.565025 25.684038,51.558395 25.681948,51.556133 25.67988,51.558308 25.677341,51.576126 25.67951,51.580101 25.676891,51.583099 25.675442,51.589638 25.682632,51.590019 25.695934,51.591873 25.698645,51.594666 25.698603,51.603252 25.716513,51.6026 25.719521,51.597931 25.723572,51.597046 25.734173,51.585148 25.738691,51.586109 25.736263,51.584389 25.732965,51.584881 25.728367)"
"45013424";"11";"SRID=4326;LINESTRING(52.41539 25.661459,52.421806 25.663294,52.427586 25.66791,52.42239 25.676607,52.417011 25.675425,52.413288 25.671423,52.413406 25.662451,52.41539 25.661459)"
"45013425";"12";"SRID=4326;LINESTRING(50.812584 25.659479,50.815708 25.66239,50.825718 25.66674,50.828693 25.673101,50.827011 25.676361,50.822521 25.67877,50.820095 25.682507,50.816357 25.675934,50.809757 25.675636,50.807728 25.666723,50.812584 25.659479)"
"45013426";"13";"SRID=4326;LINESTRING(50.796886 25.624933,50.801777 25.627571,50.804562 25.627502,50.80748 25.632027,50.813042 25.63166,50.81546 25.627695,50.820534 25.628029,50.820934 25.633074,50.825397 25.638479,50.822224 25.642466,50.816254 25.64629,50.811157 25.645266,50.807907 25.646725,50.801804 25.645956,50.797039 25.647682,50.801243 25.652864,50.793972 25.655571,50.788589 25.653404,50.788006 25.650661,50.790783 25.64163,50.795475 25.637379,50.79285 25.634226,50.796886 25.624933)"
"45013427";"14";"SRID=4326;LINESTRING(50.80484 25.724482,50.802921 25.719471,50.803154 25.710043,50.796288 25.70056,50.790405 25.698635,50.786903 25.691595,50.78936 25.688778,50.79269 25.690075,50.795578 25.684719,50.801624 25.683422,50.804062 25.680143,50.801441 25.676626,50.797905 25.673607,50.793964 25.673267,50.794399 25.679003,50.787792 25.678474,50.779472 25.671093,50.773472 25.673998,50.774811 25.676493,50.772606 25.679075,50.766079 25.681301,50.757938 25.68012,50.755508 25.67709,50.755047 25.676514,50.758461 25.671835,50.769314 25.670422,50.765163 25.667076,50.765255 25.661327,50.768688 25.657337,50.77224 25.648748,50.775265 25.648214,50.779163 25.642834,50.779305 25.638924,50.782497 25.635399,50.781384 25.631977,50.777901 25.63413,50.774315 25.632839,50.772934 25.628736,50.769341 25.627216,50.768509 25.624708,50.771896 25.61911,50.76458 25.611244,50.767574 25.609793,50.777081 25.614388,50.780724 25.609013,50.779613 25.605593,50.773174 25.60297,50.772694 25.602774,50.768745 25.597584,50.767807 25.591402,50.762043 25.584648,50.762699 25.580956,50.783783 25.571629,50.801117 25.561375,50.815403 25.548086,50.817753 25.544907,50.817665 25.54224,50.811367 25.544634,50.804779 25.553267,50.787418 25.563999,50.775433 25.571407,50.765545 25.574223,50.7491 25.583584,50.746262 25.590546,50.754322 25.606897,50.755558 25.614681,50.753822 25.624834,50.755676 25.636511,50.753807 25.642071,50.746418 25.649374,50.744263 25.653791,50.748398 25.663242,50.749142 25.664936,50.747818 25.671862,50.752476 25.68416,50.760937 25.696365,50.764793 25.698339,50.778496 25.716393,50.78252 25.715374,50.787109 25.716183,50.788322 25.714314,50.791103 25.714016,50.792561 25.720646,50.799175 25.721403,50.80484 25.724482)"
"45013408";"15";"SRID=4326;LINESTRING(51.497299 25.538914,51.495403 25.541622)"
"45013429";"16";"SRID=4326;LINESTRING(51.497299 25.538914,51.497726 25.536366,51.496487 25.535931,51.491238 25.526751,51.485779 25.521065,51.481949 25.504559,51.481892 25.502951,51.488255 25.496786,51.491528 25.496229,51.498837 25.488197,51.498543 25.472807,51.504536 25.47056,51.507618 25.471848,51.518738 25.46439,51.520981 25.45628,51.526066 25.449921,51.532166 25.436407,51.531082 25.427248,51.532719 25.423521,51.529083 25.413748,51.536301 25.38917,51.533237 25.381218,51.533821 25.369249,51.530361 25.364298,51.53046 25.342426,51.529716 25.331913,51.530849 25.328201,51.535244 25.323933,51.541565 25.323973,51.544525 25.322044,51.548359 25.316183,51.545494 25.313742,51.544319 25.309181,51.537483 25.308697,51.528145 25.301855,51.526714 25.297071,51.527016 25.296209)"
"45013416";"17";"SRID=4326;LINESTRING(50.882332 25.539145,50.879375 25.53878,50.883579 25.532434,50.89175 25.527315,50.894707 25.527679,50.894779 25.529902,50.887547 25.533661,50.882332 25.539145)"
"45013417";"18";"SRID=4326;LINESTRING(51.57201 25.408089,51.569221 25.406761,51.569145 25.404814,51.574806 25.394878,51.568718 25.389051,51.569164 25.38549,51.578148 25.395479,51.581337 25.397148,51.582264 25.400839,51.57201 25.408089)"
"45013430";"19";"SRID=4326;LINESTRING(51.577435 25.337824,51.592953 25.340797,51.589275 25.343899,51.580872 25.342085,51.57803 25.340334,51.577435 25.337824)"
"45013431";"20";"SRID=4326;LINESTRING(51.527016 25.296209,51.529007 25.290567,51.540222 25.286324,51.546768 25.285666,51.548386 25.288605,51.551693 25.289194,51.560009 25.28159,51.564735 25.279608,51.565697 25.279692)"
"45013432";"21";"SRID=4326;LINESTRING(51.565697 25.279692,51.570564 25.280119,51.573013 25.285101,51.575932 25.286957,51.579647 25.286968,51.586117 25.284243,51.592319 25.274172,51.594818 25.273405,51.599411 25.274645,51.602882 25.272928,51.605923 25.266171,51.612194 25.26506,51.61417 25.270744,51.616936 25.27043,51.617771 25.265577,51.615005 25.258999,51.612789 25.246656,51.606834 25.242474,51.610836 25.22052,51.625801 25.207022,51.627457 25.20553,51.626846 25.195667,51.631287 25.172127,51.629829 25.168854,51.624004 25.164217,51.622803 25.166391)"
"45013433";"22";"SRID=4326;LINESTRING(51.620579 25.167286,51.622803 25.166391)"
"45013434";"23";"SRID=4326;LINESTRING(51.620579 25.167286,51.61869 25.158693,51.619961 25.151989,51.628189 25.142315,51.628525 25.137709,51.625965 25.129745,51.628288 25.110371,51.632034 25.109337,51.629383 25.105742,51.627312 25.097303,51.626873 25.092262,51.629086 25.083693,51.625584 25.077595,51.623917 25.07328,51.61948 25.069052,51.618137 25.059902,51.618889 25.052755,51.621273 25.049007,51.624481 25.033283,51.630829 25.020679,51.635754 25.01754,51.636646 25.014296,51.632545 25,51.631161 24.995165,51.619106 24.975317,51.6017 24.974474,51.598328 24.971821,51.590805 24.958725,51.594994 24.949177,51.599823 24.950407,51.600487 24.947861,51.587254 24.929886,51.573215 24.903433,51.557541 24.887369,51.553295 24.881294,51.543213 24.866667,51.52729 24.8575,51.522846 24.85281,51.51564 24.83396,51.510075 24.825529,51.504482 24.817064,51.500862 24.807066,51.501465 24.795561,51.490673 24.774521,51.492207 24.760921,51.489861 24.751345,51.462078 24.711285,51.447006 24.660509,51.440071 24.648769,51.432709 24.646461,51.426872 24.637445,51.425842 24.633392,51.415733 24.634789,51.405811 24.630943,51.393055 24.632465,51.390854 24.619438,51.386093 24.612228,51.385303 24.603752,51.389687 24.598864,51.382992 24.587513,51.383846 24.583124,51.380924 24.578386,51.375519 24.574409,51.36356 24.569475,51.35117 24.556082,51.348457 24.553146,51.344719 24.553944,51.34412 24.558554,51.345947 24.568148,51.344856 24.573002,51.338329 24.580309,51.338383 24.589495,51.333721 24.592615,51.339413 24.597733,51.343197 24.598312,51.348866 24.595163,51.357338 24.606749,51.361938 24.613035,51.365475 24.635519,51.363758 24.637629,51.361031 24.63689,51.358356 24.625471,51.353668 24.620277,51.350681 24.612564,51.348034 24.613878,51.351196 24.619671,51.354321 24.649837,51.347973 24.648392,51.344704 24.645206,51.343472 24.636206,51.341194 24.635456,51.338497 24.636786,51.337219 24.637415)"
"45013436";"24";"SRID=4326;LINESTRING(51.26202 24.608698,51.256226 24.609751,51.250648 24.60807,51.244392 24.608706,51.239231 24.612066,51.237408 24.61005,51.225838 24.617035,51.228153 24.618807,51.227795 24.62318,51.2234 24.626978,51.228268 24.630056,51.22924 24.63669,51.237759 24.647261,51.238583 24.645182,51.235298 24.637669,51.238453 24.634365,51.240551 24.637062,51.246082 24.637367,51.24979 24.643234,51.256145 24.645582,51.266052 24.641397,51.268375 24.64534,51.268711 24.645916,51.278915 24.650681,51.282684 24.650803,51.285088 24.647518,51.285187 24.635344,51.290775 24.646053,51.292622 24.659554,51.294853 24.659075,51.296452 24.656475,51.298763 24.656927,51.296757 24.661892,51.296211 24.671127,51.29966 24.670877,51.302635 24.646561,51.298832 24.644983,51.296688 24.635601,51.292957 24.632017,51.292793 24.627504,51.294514 24.625397,51.301418 24.642029,51.305393 24.645285,51.31369 24.633432,51.315937 24.633364,51.316616 24.639505,51.319729 24.638586,51.325382 24.633482,51.332314 24.63335,51.331898 24.637558,51.333866 24.639069,51.337219 24.637415)"
"45013437";"25";"SRID=4326;LINESTRING(51.337219 24.637415,51.337158 24.635122,51.346588 24.626442,51.346893 24.624336,51.343151 24.626549,51.34177 24.62537,51.337322 24.629177,51.334805 24.633448,51.334747 24.637119,51.337219 24.637415)"
"45013438";"26";"SRID=4326;LINESTRING(51.113113 24.482944,51.190548 24.548397,51.26202 24.608698)"
"45013439";"27";"SRID=4326;LINESTRING(50.829922 24.742144,50.866539 24.693632,50.91021 24.646864,50.970577 24.582129,51.01461 24.574364,51.11198 24.557138,51.112522 24.52177,51.113113 24.482944)"