1# SOME DESCRIPTIVE TITLE. 2# 3# Translators: 4# Jakub Bobrowski <jb@5dstudio.pl>, 2014 5# Milena Nowotarska <do.milenki@gmail.com>, 2016 6msgid "" 7msgstr "" 8"Project-Id-Version: PostGIS\n" 9"Report-Msgid-Bugs-To: https://bugs.kde.org\n" 10"POT-Creation-Date: 2020-12-15 04:51+0000\n" 11"PO-Revision-Date: 2018-07-23 18:01+0000\n" 12"Last-Translator: Jakub Bobrowski <jbobrowski@geoinfor.pl>\n" 13"Language-Team: Polish (http://www.transifex.com/postgis/postgis/language/" 14"pl/)\n" 15"Language: pl\n" 16"MIME-Version: 1.0\n" 17"Content-Type: text/plain; charset=UTF-8\n" 18"Content-Transfer-Encoding: 8bit\n" 19"Plural-Forms: nplurals=4; plural=(n==1 ? 0 : (n%10>=2 && n%10<=4) && (n" 20"%100<12 || n%100>14) ? 1 : n!=1 && (n%10>=0 && n%10<=1) || (n%10>=5 && n" 21"%10<=9) || (n%100>=12 && n%100<=14) ? 2 : 3);\n" 22 23#. Tag: para 24#: reference_editor.xml:5 25#, no-c-format 26msgid "" 27"These functions create modified geometries by changing type, structure or " 28"vertices." 29msgstr "" 30 31#. Tag: title 32#: reference_editor.xml:10 33#, no-c-format 34msgid "Geometry Editors" 35msgstr "" 36 37#. Tag: refname 38#: reference_editor.xml:14 39#, no-c-format 40msgid "ST_AddPoint" 41msgstr "ST_AddPoint" 42 43#. Tag: refpurpose 44#: reference_editor.xml:15 45#, no-c-format 46msgid "Add a point to a LineString." 47msgstr "Dodaj punkt do linii" 48 49#. Tag: funcprototype 50#: reference_editor.xml:19 51#, no-c-format 52msgid "" 53"<funcdef>geometry <function>ST_AddPoint</function></funcdef> " 54"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 55"<paramdef><type>geometry</type> <parameter>point</parameter></paramdef>" 56msgstr "" 57"<funcdef>geometry <function>ST_AddPoint</function></funcdef> " 58"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 59"<paramdef><type>geometry</type> <parameter>point</parameter></paramdef>" 60 61#. Tag: funcprototype 62#: reference_editor.xml:26 63#, no-c-format 64msgid "" 65"<funcdef>geometry <function>ST_AddPoint</function></funcdef> " 66"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 67"<paramdef><type>geometry</type> <parameter>point</parameter></paramdef> " 68"<paramdef><type>integer</type> <parameter>position</parameter></paramdef>" 69msgstr "" 70"<funcdef>geometry <function>ST_AddPoint</function></funcdef> " 71"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 72"<paramdef><type>geometry</type> <parameter>point</parameter></paramdef> " 73"<paramdef><type>integer</type> <parameter>position</parameter></paramdef>" 74 75#. Tag: title 76#: reference_editor.xml:36 reference_editor.xml:82 reference_editor.xml:136 77#: reference_editor.xml:181 reference_editor.xml:260 reference_editor.xml:301 78#: reference_editor.xml:348 reference_editor.xml:393 reference_editor.xml:438 79#: reference_editor.xml:482 reference_editor.xml:533 reference_editor.xml:573 80#: reference_editor.xml:630 reference_editor.xml:675 reference_editor.xml:704 81#: reference_editor.xml:761 reference_editor.xml:806 reference_editor.xml:845 82#: reference_editor.xml:888 reference_editor.xml:923 reference_editor.xml:995 83#: reference_editor.xml:1099 reference_editor.xml:1134 84#: reference_editor.xml:1171 reference_editor.xml:1210 85#: reference_editor.xml:1253 reference_editor.xml:1291 86#: reference_editor.xml:1345 reference_editor.xml:1427 87#: reference_editor.xml:1505 reference_editor.xml:1643 88#, no-c-format 89msgid "Description" 90msgstr "Opis" 91 92#. Tag: para 93#: reference_editor.xml:38 94#, no-c-format 95msgid "" 96"Adds a point to a LineString before point <position> (0-based index). " 97"Third parameter can be omitted or set to -1 for appending." 98msgstr "" 99 100#. Tag: para 101#: reference_editor.xml:41 reference_editor.xml:813 reference_editor.xml:1102 102#: reference_editor.xml:1258 103#, no-c-format 104msgid "Availability: 1.1.0" 105msgstr "Dostępność: 1.1.0" 106 107#. Tag: para 108#: reference_editor.xml:42 reference_editor.xml:225 reference_editor.xml:265 109#: reference_editor.xml:312 reference_editor.xml:357 reference_editor.xml:401 110#: reference_editor.xml:488 reference_editor.xml:542 reference_editor.xml:583 111#: reference_editor.xml:639 reference_editor.xml:680 reference_editor.xml:719 112#: reference_editor.xml:770 reference_editor.xml:850 reference_editor.xml:1103 113#: reference_editor.xml:1146 reference_editor.xml:1176 114#: reference_editor.xml:1261 reference_editor.xml:1303 115#: reference_editor.xml:1360 reference_editor.xml:1458 116#: reference_editor.xml:1653 117#, no-c-format 118msgid "&Z_support;" 119msgstr "&Z_support;" 120 121#. Tag: title 122#: reference_editor.xml:46 reference_editor.xml:107 reference_editor.xml:151 123#: reference_editor.xml:231 reference_editor.xml:317 reference_editor.xml:362 124#: reference_editor.xml:407 reference_editor.xml:450 reference_editor.xml:494 125#: reference_editor.xml:589 reference_editor.xml:724 reference_editor.xml:776 126#: reference_editor.xml:818 reference_editor.xml:856 reference_editor.xml:896 127#: reference_editor.xml:941 reference_editor.xml:1066 reference_editor.xml:1107 128#: reference_editor.xml:1181 reference_editor.xml:1226 129#: reference_editor.xml:1265 reference_editor.xml:1312 130#: reference_editor.xml:1369 reference_editor.xml:1463 131#: reference_editor.xml:1541 132#, no-c-format 133msgid "Examples" 134msgstr "Przykłady" 135 136#. Tag: programlisting 137#: reference_editor.xml:47 138#, no-c-format 139msgid "" 140"--guarantee all linestrings in a table are closed\n" 141" --by adding the start point of each linestring to the end of " 142"the line string\n" 143" --only for those that are not closed\n" 144" UPDATE sometable\n" 145" SET the_geom = ST_AddPoint(the_geom, " 146"ST_StartPoint(the_geom))\n" 147" FROM sometable\n" 148" WHERE ST_IsClosed(the_geom) = false;\n" 149"\n" 150" --Adding point to a 3-d line\n" 151" SELECT ST_AsEWKT(ST_AddPoint(ST_GeomFromEWKT('LINESTRING(0 0 " 152"1, 1 1 1)'), ST_MakePoint(1, 2, 3)));\n" 153"\n" 154" --result\n" 155" st_asewkt\n" 156" ----------\n" 157" LINESTRING(0 0 1,1 1 1,1 2 3)" 158msgstr "" 159 160#. Tag: title 161#: reference_editor.xml:50 reference_editor.xml:112 reference_editor.xml:156 162#: reference_editor.xml:238 reference_editor.xml:278 reference_editor.xml:324 163#: reference_editor.xml:369 reference_editor.xml:414 reference_editor.xml:457 164#: reference_editor.xml:501 reference_editor.xml:547 reference_editor.xml:598 165#: reference_editor.xml:644 reference_editor.xml:730 reference_editor.xml:782 166#: reference_editor.xml:823 reference_editor.xml:865 reference_editor.xml:901 167#: reference_editor.xml:946 reference_editor.xml:1075 reference_editor.xml:1111 168#: reference_editor.xml:1150 reference_editor.xml:1231 169#: reference_editor.xml:1269 reference_editor.xml:1319 170#: reference_editor.xml:1376 reference_editor.xml:1470 171#: reference_editor.xml:1616 reference_editor.xml:1666 172#, no-c-format 173msgid "See Also" 174msgstr "Zobacz także" 175 176#. Tag: para 177#: reference_editor.xml:51 178#, no-c-format 179msgid ", <xref linkend=\"ST_SetPoint\"/>" 180msgstr ", <xref linkend=\"ST_SetPoint\"/>" 181 182#. Tag: refname 183#: reference_editor.xml:58 184#, no-c-format 185msgid "ST_CollectionExtract" 186msgstr "ST_CollectionExtract" 187 188#. Tag: refpurpose 189#: reference_editor.xml:60 190#, no-c-format 191msgid "" 192"Given a (multi)geometry, return a (multi)geometry consisting only of " 193"elements of the specified type." 194msgstr "" 195 196#. Tag: funcprototype 197#: reference_editor.xml:67 198#, fuzzy, no-c-format 199msgid "" 200"<funcdef>geometry <function>ST_CollectionExtract</function></funcdef> " 201"<paramdef><type>geometry </type> <parameter>collection</parameter></paramdef>" 202msgstr "" 203"<funcdef>geometry <function>ST_Reverse</function></funcdef> " 204"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 205 206#. Tag: funcprototype 207#: reference_editor.xml:73 208#, no-c-format 209msgid "" 210"<funcdef>geometry <function>ST_CollectionExtract</function></funcdef> " 211"<paramdef><type>geometry </type> <parameter>collection</parameter></" 212"paramdef> <paramdef><type>integer </type> <parameter>type</parameter></" 213"paramdef>" 214msgstr "" 215"<funcdef>geometry <function>ST_CollectionExtract</function></funcdef> " 216"<paramdef><type>geometry </type> <parameter>collection</parameter></" 217"paramdef> <paramdef><type>integer </type> <parameter>type</parameter></" 218"paramdef>" 219 220#. Tag: para 221#: reference_editor.xml:84 222#, no-c-format 223msgid "" 224"Given a geometry collection, return a homogeneous multi-geometry. If the " 225"type is specified, return a multi-geometry containing only that type, and an " 226"EMPTY multigeometry otherwise. If the type is not specified, return a multi-" 227"geometry containing only geometries of the highest coordinate dimension. So " 228"polygons are preferred over lines, which are preferred over points. Sub-" 229"geometries that are not the desired type are ignored. If there are no sub-" 230"geometries of the right type, an EMPTY geometry will be returned." 231msgstr "" 232 233#. Tag: para 234#: reference_editor.xml:86 235#, no-c-format 236msgid "Only points, lines and polygons are supported. The type numbers are:" 237msgstr "" 238 239#. Tag: para 240#: reference_editor.xml:88 241#, no-c-format 242msgid "1 == POINT" 243msgstr "" 244 245#. Tag: para 246#: reference_editor.xml:89 247#, no-c-format 248msgid "2 == LINESTRING" 249msgstr "" 250 251#. Tag: para 252#: reference_editor.xml:90 253#, no-c-format 254msgid "3 == POLYGON" 255msgstr "" 256 257#. Tag: para 258#: reference_editor.xml:93 259#, no-c-format 260msgid "Availability: 1.5.0" 261msgstr "Dostępność: 1.5.0" 262 263#. Tag: para 264#: reference_editor.xml:95 265#, no-c-format 266msgid "" 267"Prior to 1.5.3 this function returned non-collection inputs untouched, no " 268"matter type. In 1.5.3 non-matching single geometries result in a NULL " 269"return. In 2.0.0 every case of missing match results in a typed EMPTY return." 270msgstr "" 271 272#. Tag: para 273#: reference_editor.xml:101 reference_editor.xml:142 274#, no-c-format 275msgid "" 276"When specifying 3 == POLYGON a multipolygon is returned even when the edges " 277"are shared. This results in an invalid multipolygon for many cases such as " 278"applying this function on an <xref linkend=\"ST_Split\"/> result." 279msgstr "" 280 281#. Tag: programlisting 282#: reference_editor.xml:109 283#, no-c-format 284msgid "" 285"-- Constants: 1 == POINT, 2 == LINESTRING, 3 == POLYGON\n" 286"SELECT " 287"ST_AsText(ST_CollectionExtract(ST_GeomFromText('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(0 " 288"0)))'),1));\n" 289"st_astext\n" 290"---------------\n" 291"MULTIPOINT(0 0)\n" 292"(1 row)\n" 293"\n" 294"SELECT " 295"ST_AsText(ST_CollectionExtract(ST_GeomFromText('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(0 " 296"0, 1 1)),LINESTRING(2 2, 3 3))'),2));\n" 297"st_astext\n" 298"---------------\n" 299"MULTILINESTRING((0 0, 1 1), (2 2, 3 3))\n" 300"(1 row)" 301msgstr "" 302 303#. Tag: para 304#: reference_editor.xml:113 305#, no-c-format 306msgid "" 307", <xref linkend=\"ST_Dump\"/>, <xref linkend=\"ST_CollectionHomogenize\"/>" 308msgstr "" 309", <xref linkend=\"ST_Dump\"/>, <xref linkend=\"ST_CollectionHomogenize\"/>" 310 311#. Tag: refname 312#: reference_editor.xml:119 313#, no-c-format 314msgid "ST_CollectionHomogenize" 315msgstr "ST_CollectionHomogenize" 316 317#. Tag: refpurpose 318#: reference_editor.xml:121 319#, no-c-format 320msgid "" 321"Given a geometry collection, return the \"simplest\" representation of the " 322"contents." 323msgstr "" 324 325#. Tag: funcprototype 326#: reference_editor.xml:128 327#, no-c-format 328msgid "" 329"<funcdef>geometry <function>ST_CollectionHomogenize</function></funcdef> " 330"<paramdef><type>geometry </type> <parameter>collection</parameter></paramdef>" 331msgstr "" 332 333#. Tag: para 334#: reference_editor.xml:138 335#, no-c-format 336msgid "" 337"Given a geometry collection, returns the \"simplest\" representation of the " 338"contents. Singletons will be returned as singletons. Collections that are " 339"homogeneous will be returned as the appropriate multi-type." 340msgstr "" 341 342#. Tag: para 343#: reference_editor.xml:146 reference_editor.xml:263 reference_editor.xml:1537 344#, no-c-format 345msgid "Availability: 2.0.0" 346msgstr "Dostępność: 2.0" 347 348#. Tag: programlisting 349#: reference_editor.xml:153 350#, no-c-format 351msgid "" 352"SELECT ST_AsText(ST_CollectionHomogenize('GEOMETRYCOLLECTION(POINT(0 " 353"0))'));\n" 354"\n" 355" st_astext\n" 356" ------------\n" 357" POINT(0 0)\n" 358" (1 row)\n" 359"\n" 360" SELECT ST_AsText(ST_CollectionHomogenize('GEOMETRYCOLLECTION(POINT(0 0)," 361"POINT(1 1))'));\n" 362"\n" 363" st_astext\n" 364" ---------------------\n" 365" MULTIPOINT(0 0,1 1)\n" 366" (1 row)" 367msgstr "" 368 369#. Tag: para 370#: reference_editor.xml:157 371#, no-c-format 372msgid ", <xref linkend=\"ST_CollectionExtract\"/>" 373msgstr ", <xref linkend=\"ST_CollectionExtract\"/>" 374 375#. Tag: refname 376#: reference_editor.xml:163 377#, no-c-format 378msgid "ST_CurveToLine" 379msgstr "" 380 381#. Tag: refpurpose 382#: reference_editor.xml:165 383#, no-c-format 384msgid "Converts a geometry containing curves to a linear geometry." 385msgstr "" 386 387#. Tag: funcprototype 388#: reference_editor.xml:170 389#, fuzzy, no-c-format 390msgid "" 391"<funcdef>geometry <function>ST_CurveToLine</function></funcdef> " 392"<paramdef><type>geometry</type> <parameter>curveGeom</parameter></paramdef> " 393"<paramdef><type>float</type> <parameter>tolerance</parameter></paramdef> " 394"<paramdef choice=\"opt\"><type>integer</type> <parameter>tolerance_type</" 395"parameter></paramdef> <paramdef choice=\"opt\"><type>integer</type> " 396"<parameter>flags</parameter></paramdef>" 397msgstr "" 398"<funcdef>geometry <function>ST_TransScale</function></funcdef> " 399"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 400"<paramdef><type>float</type> <parameter>deltaX</parameter></paramdef> " 401"<paramdef><type>float</type> <parameter>deltaY</parameter></paramdef> " 402"<paramdef><type>float</type> <parameter>XFactor</parameter></paramdef> " 403"<paramdef><type>float</type> <parameter>YFactor</parameter></paramdef>" 404 405#. Tag: para 406#: reference_editor.xml:183 407#, no-c-format 408msgid "" 409"Converts a CIRCULAR STRING to regular LINESTRING or CURVEPOLYGON to POLYGON " 410"or MULTISURFACE to MULTIPOLYGON. Useful for outputting to devices that can't " 411"support CIRCULARSTRING geometry types" 412msgstr "" 413 414#. Tag: para 415#: reference_editor.xml:185 416#, no-c-format 417msgid "" 418"Converts a given geometry to a linear geometry. Each curved geometry or " 419"segment is converted into a linear approximation using the given `tolerance` " 420"and options (32 segments per quadrant and no options by default)." 421msgstr "" 422 423#. Tag: para 424#: reference_editor.xml:190 425#, no-c-format 426msgid "" 427"The 'tolerance_type' argument determines interpretation of the `tolerance` " 428"argument. It can take the following values:" 429msgstr "" 430 431#. Tag: para 432#: reference_editor.xml:195 433#, no-c-format 434msgid "0 (default): Tolerance is max segments per quadrant." 435msgstr "" 436 437#. Tag: para 438#: reference_editor.xml:198 439#, no-c-format 440msgid "1: Tolerance is max-deviation of line from curve, in source units." 441msgstr "" 442 443#. Tag: para 444#: reference_editor.xml:201 445#, no-c-format 446msgid "2: Tolerance is max-angle, in radians, between generating radii." 447msgstr "" 448 449#. Tag: para 450#: reference_editor.xml:206 451#, no-c-format 452msgid "The 'flags' argument is a bitfield. 0 by default. Supported bits are:" 453msgstr "" 454 455#. Tag: para 456#: reference_editor.xml:211 457#, no-c-format 458msgid "1: Symmetric (orientation idependent) output." 459msgstr "" 460 461#. Tag: para 462#: reference_editor.xml:214 463#, no-c-format 464msgid "" 465"2: Retain angle, avoids reducing angles (segment lengths) when producing " 466"symmetric output. Has no effect when Symmetric flag is off." 467msgstr "" 468 469#. Tag: para 470#: reference_editor.xml:219 reference_editor.xml:849 471#, fuzzy, no-c-format 472msgid "Availability: 1.3.0" 473msgstr "Dostępność: 1.1.0" 474 475#. Tag: para 476#: reference_editor.xml:220 477#, no-c-format 478msgid "" 479"Enhanced: 2.4.0 added support for max-deviation and max-angle tolerance, and " 480"for symmetric output." 481msgstr "" 482 483#. Tag: para 484#: reference_editor.xml:221 485#, no-c-format 486msgid "" 487"Enhanced: 3.0.0 implemented a minimum number of segments per linearized arc " 488"to prevent topological collapse." 489msgstr "" 490 491#. Tag: para 492#: reference_editor.xml:223 493#, no-c-format 494msgid "&sfs_compliant;" 495msgstr "&sfs_compliant;" 496 497#. Tag: para 498#: reference_editor.xml:224 499#, fuzzy, no-c-format 500msgid "&sqlmm_compliant; SQL-MM 3: 7.1.7" 501msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.6" 502 503#. Tag: para 504#: reference_editor.xml:226 reference_editor.xml:264 reference_editor.xml:310 505#: reference_editor.xml:356 reference_editor.xml:402 reference_editor.xml:445 506#: reference_editor.xml:489 reference_editor.xml:584 reference_editor.xml:679 507#: reference_editor.xml:772 reference_editor.xml:851 reference_editor.xml:1652 508#, no-c-format 509msgid "&curve_support;" 510msgstr "&curve_support;" 511 512#. Tag: programlisting 513#: reference_editor.xml:233 514#, no-c-format 515msgid "" 516"SELECT ST_AsText(ST_CurveToLine(ST_GeomFromText('CIRCULARSTRING(220268 " 517"150415,220227 150505,220227 150406)')));\n" 518"\n" 519"--Result --\n" 520" LINESTRING(220268 150415,220269.95064912 150416.539364228,220271.823415575 " 521"150418.17258804,220273.613787707 150419.895736857,\n" 522" 220275.317452352 150421.704659462,220276.930305234 " 523"150423.594998003,220278.448460847 150425.562198489,\n" 524" 220279.868261823 150427.60152176,220281.186287736 " 525"150429.708054909,220282.399363347 150431.876723113,\n" 526" 220283.50456625 150434.10230186,220284.499233914 " 527"150436.379429536,220285.380970099 150438.702620341,220286.147650624 " 528"150441.066277505,\n" 529" 220286.797428488 150443.464706771,220287.328738321 " 530"150445.892130112,220287.740300149 150448.342699654,\n" 531" 220288.031122486 150450.810511759,220288.200504713 " 532"150453.289621251,220288.248038775 150455.77405574,\n" 533" 220288.173610157 150458.257830005,220287.977398166 " 534"150460.734960415,220287.659875492 150463.199479347,\n" 535" 220287.221807076 150465.64544956,220286.664248262 " 536"150468.066978495,220285.988542259 150470.458232479,220285.196316903 " 537"150472.81345077,\n" 538" 220284.289480732 150475.126959442,220283.270218395 " 539"150477.39318505,220282.140985384 150479.606668057,\n" 540" 220280.90450212 150481.762075989,220279.5637474 " 541"150483.85421628,220278.12195122 150485.87804878,\n" 542" 220276.582586992 150487.828697901,220274.949363179 " 543"150489.701464356,220273.226214362 150491.491836488,\n" 544" 220271.417291757 150493.195501133,220269.526953216 " 545"150494.808354014,220267.559752731 150496.326509628,\n" 546" 220265.520429459 150497.746310603,220263.41389631 " 547"150499.064336517,220261.245228106 150500.277412127,\n" 548" 220259.019649359 150501.38261503,220256.742521683 " 549"150502.377282695,220254.419330878 150503.259018879,\n" 550" 220252.055673714 150504.025699404,220249.657244448 " 551"150504.675477269,220247.229821107 150505.206787101,\n" 552" 220244.779251566 150505.61834893,220242.311439461 " 553"150505.909171266,220239.832329968 150506.078553494,\n" 554" 220237.347895479 150506.126087555,220234.864121215 " 555"150506.051658938,220232.386990804 150505.855446946,\n" 556" 220229.922471872 150505.537924272,220227.47650166 " 557"150505.099855856,220225.054972724 150504.542297043,\n" 558" 220222.663718741 150503.86659104,220220.308500449 150503.074365683,\n" 559" 220217.994991777 150502.167529512,220215.72876617 150501.148267175,\n" 560" 220213.515283163 150500.019034164,220211.35987523 150498.7825509,\n" 561" 220209.267734939 150497.441796181,220207.243902439 150496,\n" 562" 220205.293253319 150494.460635772,220203.420486864 " 563"150492.82741196,220201.630114732 150491.104263143,\n" 564" 220199.926450087 150489.295340538,220198.313597205 " 565"150487.405001997,220196.795441592 150485.437801511,\n" 566" 220195.375640616 150483.39847824,220194.057614703 " 567"150481.291945091,220192.844539092 150479.123276887,220191.739336189 " 568"150476.89769814,\n" 569" 220190.744668525 150474.620570464,220189.86293234 " 570"150472.297379659,220189.096251815 150469.933722495,\n" 571" 220188.446473951 150467.535293229,220187.915164118 " 572"150465.107869888,220187.50360229 150462.657300346,\n" 573" 220187.212779953 150460.189488241,220187.043397726 " 574"150457.710378749,220186.995863664 150455.22594426,\n" 575" 220187.070292282 150452.742169995,220187.266504273 " 576"150450.265039585,220187.584026947 150447.800520653,\n" 577" 220188.022095363 150445.35455044,220188.579654177 " 578"150442.933021505,220189.25536018 150440.541767521,\n" 579" 220190.047585536 150438.18654923,220190.954421707 " 580"150435.873040558,220191.973684044 150433.60681495,\n" 581" 220193.102917055 150431.393331943,220194.339400319 " 582"150429.237924011,220195.680155039 150427.14578372,220197.12195122 " 583"150425.12195122,\n" 584" 220198.661315447 150423.171302099,220200.29453926 " 585"150421.298535644,220202.017688077 150419.508163512,220203.826610682 " 586"150417.804498867,\n" 587" 220205.716949223 150416.191645986,220207.684149708 " 588"150414.673490372,220209.72347298 150413.253689397,220211.830006129 " 589"150411.935663483,\n" 590" 220213.998674333 150410.722587873,220216.22425308 " 591"150409.61738497,220218.501380756 150408.622717305,220220.824571561 " 592"150407.740981121,\n" 593" 220223.188228725 150406.974300596,220225.586657991 150406.324522731,220227 " 594"150406)\n" 595"\n" 596"--3d example\n" 597"SELECT ST_AsEWKT(ST_CurveToLine(ST_GeomFromEWKT('CIRCULARSTRING(220268 " 598"150415 1,220227 150505 2,220227 150406 3)')));\n" 599"Output\n" 600"------\n" 601" LINESTRING(220268 150415 1,220269.95064912 150416.539364228 " 602"1.0181172856673,\n" 603" 220271.823415575 150418.17258804 1.03623457133459,220273.613787707 " 604"150419.895736857 1.05435185700189,....AD INFINITUM ....\n" 605" 220225.586657991 150406.324522731 1.32611114201132,220227 150406 3)\n" 606"\n" 607"--use only 2 segments to approximate quarter circle\n" 608"SELECT ST_AsText(ST_CurveToLine(ST_GeomFromText('CIRCULARSTRING(220268 " 609"150415,220227 150505,220227 150406)'),2));\n" 610"st_astext\n" 611"------------------------------\n" 612" LINESTRING(220268 150415,220287.740300149 150448.342699654,220278.12195122 " 613"150485.87804878,\n" 614" 220244.779251566 150505.61834893,220207.243902439 150496,220187.50360229 " 615"150462.657300346,\n" 616" 220197.12195122 150425.12195122,220227 150406)\n" 617"\n" 618"-- Ensure approximated line is no further than 20 units away from\n" 619"-- original curve, and make the result direction-neutral\n" 620"SELECT ST_AsText(ST_CurveToLine(\n" 621" 'CIRCULARSTRING(0 0,100 -100,200 0)'::geometry,\n" 622" 20, -- Tolerance\n" 623" 1, -- Above is max distance between curve and line\n" 624" 1 -- Symmetric flag\n" 625"));\n" 626"st_astext\n" 627"-------------------------------------------------------------------------------------------\n" 628" LINESTRING(0 0,50 -86.6025403784438,150 -86.6025403784439,200 " 629"-1.1331077795296e-13,200 0)" 630msgstr "" 631 632#. Tag: refname 633#: reference_editor.xml:246 634#, no-c-format 635msgid "ST_FlipCoordinates" 636msgstr "" 637 638#. Tag: refpurpose 639#: reference_editor.xml:247 640#, no-c-format 641msgid "Returns a version of a geometry with X and Y axis flipped." 642msgstr "" 643 644#. Tag: funcprototype 645#: reference_editor.xml:252 646#, fuzzy, no-c-format 647msgid "" 648"<funcdef>geometry <function>ST_FlipCoordinates</function></funcdef> " 649"<paramdef><type>geometry</type> <parameter>geom</parameter></paramdef>" 650msgstr "" 651"<funcdef>geometry <function>ST_Reverse</function></funcdef> " 652"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 653 654#. Tag: para 655#: reference_editor.xml:261 656#, no-c-format 657msgid "" 658"Returns a version of the given geometry with X and Y axis flipped. Useful " 659"for fixing geometries which contain coordinates expressed as latitude/" 660"longitude (Y,X)." 661msgstr "" 662 663#. Tag: para 664#: reference_editor.xml:266 reference_editor.xml:543 reference_editor.xml:640 665#: reference_editor.xml:1654 666#, no-c-format 667msgid "&M_support;" 668msgstr "&M_support;" 669 670#. Tag: para 671#: reference_editor.xml:267 reference_editor.xml:311 reference_editor.xml:355 672#: reference_editor.xml:400 reference_editor.xml:582 reference_editor.xml:677 673#: reference_editor.xml:720 reference_editor.xml:1145 reference_editor.xml:1177 674#: reference_editor.xml:1306 reference_editor.xml:1655 675#, no-c-format 676msgid "&P_support;" 677msgstr "&P_support;" 678 679#. Tag: para 680#: reference_editor.xml:268 reference_editor.xml:678 reference_editor.xml:1307 681#: reference_editor.xml:1656 682#, no-c-format 683msgid "&T_support;" 684msgstr "&T_support;" 685 686#. Tag: title 687#: reference_editor.xml:272 reference_editor.xml:1660 688#, fuzzy, no-c-format 689msgid "Example" 690msgstr "Przykłady" 691 692#. Tag: programlisting 693#: reference_editor.xml:273 694#, no-c-format 695msgid "" 696"<![CDATA[\n" 697"SELECT ST_AsEWKT(ST_FlipCoordinates(GeomFromEWKT('POINT(1 2)')));\n" 698" st_asewkt\n" 699"------------\n" 700"POINT(2 1)\n" 701" ]]>" 702msgstr "" 703 704#. Tag: refname 705#: reference_editor.xml:286 706#, no-c-format 707msgid "ST_Force2D" 708msgstr "" 709 710#. Tag: refpurpose 711#: reference_editor.xml:288 712#, no-c-format 713msgid "Force the geometries into a \"2-dimensional mode\"." 714msgstr "" 715 716#. Tag: funcprototype 717#: reference_editor.xml:293 718#, no-c-format 719msgid "" 720"<funcdef>geometry <function>ST_Force2D</function></funcdef> " 721"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 722msgstr "" 723 724#. Tag: para 725#: reference_editor.xml:303 726#, no-c-format 727msgid "" 728"Forces the geometries into a \"2-dimensional mode\" so that all output " 729"representations will only have the X and Y coordinates. This is useful for " 730"force OGC-compliant output (since OGC only specifies 2-D geometries)." 731msgstr "" 732 733#. Tag: para 734#: reference_editor.xml:308 reference_editor.xml:352 reference_editor.xml:397 735#: reference_editor.xml:578 reference_editor.xml:718 736#, no-c-format 737msgid "Enhanced: 2.0.0 support for Polyhedral surfaces was introduced." 738msgstr "Ulepszenie: 2.0.0 wprowadzono wsparcie dla powierzchni wielościanowych" 739 740#. Tag: para 741#: reference_editor.xml:309 742#, no-c-format 743msgid "Changed: 2.1.0. Up to 2.0.x this was called ST_Force_2D." 744msgstr "" 745 746#. Tag: programlisting 747#: reference_editor.xml:319 748#, no-c-format 749msgid "" 750"SELECT ST_AsEWKT(ST_Force2D(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 " 751"5 2, 6 7 2, 5 6 2)')));\n" 752" st_asewkt\n" 753"-------------------------------------\n" 754"CIRCULARSTRING(1 1,2 3,4 5,6 7,5 6)\n" 755"\n" 756"SELECT ST_AsEWKT(ST_Force2D('POLYGON((0 0 2,0 5 2,5 0 2,0 0 2),(1 1 2,3 1 " 757"2,1 3 2,1 1 2))'));\n" 758"\n" 759" st_asewkt\n" 760"----------------------------------------------\n" 761" POLYGON((0 0,0 5,5 0,0 0),(1 1,3 1,1 3,1 1))" 762msgstr "" 763 764#. Tag: refname 765#: reference_editor.xml:332 766#, no-c-format 767msgid "ST_Force3D" 768msgstr "" 769 770#. Tag: refpurpose 771#: reference_editor.xml:334 772#, no-c-format 773msgid "Force the geometries into XYZ mode. This is an alias for ST_Force3DZ." 774msgstr "" 775 776#. Tag: funcprototype 777#: reference_editor.xml:339 778#, fuzzy, no-c-format 779msgid "" 780"<funcdef>geometry <function>ST_Force3D</function></funcdef> " 781"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 782"<paramdef><type>float </type> <parameter>Zvalue = 0.0</parameter></paramdef>" 783msgstr "" 784"<funcdef>geometry <function>ST_RotateY</function></funcdef> " 785"<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 786"<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef>" 787 788#. Tag: para 789#: reference_editor.xml:350 790#, no-c-format 791msgid "" 792"Forces the geometries into XYZ mode. This is an alias for ST_Force3DZ. If a " 793"geometry has no Z component, then a <parameter>Zvalue</parameter> Z " 794"coordinate is tacked on." 795msgstr "" 796 797#. Tag: para 798#: reference_editor.xml:353 799#, no-c-format 800msgid "Changed: 2.1.0. Up to 2.0.x this was called ST_Force_3D." 801msgstr "" 802 803#. Tag: para 804#: reference_editor.xml:354 reference_editor.xml:399 805#, no-c-format 806msgid "Changed: 3.1.0. Added support for supplying a non-zero Z value." 807msgstr "" 808 809#. Tag: programlisting 810#: reference_editor.xml:364 811#, no-c-format 812msgid "" 813"--Nothing happens to an already 3D geometry\n" 814" SELECT " 815"ST_AsEWKT(ST_Force3D(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 5 2, 6 " 816"7 2, 5 6 2)')));\n" 817" st_asewkt\n" 818"-----------------------------------------------\n" 819" CIRCULARSTRING(1 1 2,2 3 2,4 5 2,6 7 2,5 6 2)\n" 820"\n" 821"\n" 822"SELECT ST_AsEWKT(ST_Force3D('POLYGON((0 0,0 5,5 0,0 0),(1 1,3 1,1 3,1 " 823"1))'));\n" 824"\n" 825" st_asewkt\n" 826"--------------------------------------------------------------\n" 827" POLYGON((0 0 0,0 5 0,5 0 0,0 0 0),(1 1 0,3 1 0,1 3 0,1 1 0))" 828msgstr "" 829 830#. Tag: para 831#: reference_editor.xml:371 832#, no-c-format 833msgid "" 834", <xref linkend=\"ST_Force2D\"/>, <xref linkend=\"ST_Force_3DM\"/>, <xref " 835"linkend=\"ST_Force_3DZ\"/>" 836msgstr "" 837 838#. Tag: refname 839#: reference_editor.xml:377 840#, no-c-format 841msgid "ST_Force3DZ" 842msgstr "" 843 844#. Tag: refpurpose 845#: reference_editor.xml:379 846#, no-c-format 847msgid "Force the geometries into XYZ mode." 848msgstr "" 849 850#. Tag: funcprototype 851#: reference_editor.xml:384 852#, fuzzy, no-c-format 853msgid "" 854"<funcdef>geometry <function>ST_Force3DZ</function></funcdef> " 855"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 856"<paramdef><type>float </type> <parameter>Zvalue = 0.0</parameter></paramdef>" 857msgstr "" 858"<funcdef>geometry <function>ST_RotateZ</function></funcdef> " 859"<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 860"<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef>" 861 862#. Tag: para 863#: reference_editor.xml:395 864#, no-c-format 865msgid "" 866"Forces the geometries into XYZ mode. If a geometry has no Z component, then " 867"a <parameter>Zvalue</parameter> Z coordinate is tacked on." 868msgstr "" 869 870#. Tag: para 871#: reference_editor.xml:398 872#, no-c-format 873msgid "Changed: 2.1.0. Up to 2.0.x this was called ST_Force_3DZ." 874msgstr "" 875 876#. Tag: programlisting 877#: reference_editor.xml:409 878#, no-c-format 879msgid "" 880"--Nothing happens to an already 3D geometry\n" 881"SELECT ST_AsEWKT(ST_Force3DZ(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 " 882"5 2, 6 7 2, 5 6 2)')));\n" 883" st_asewkt\n" 884"-----------------------------------------------\n" 885" CIRCULARSTRING(1 1 2,2 3 2,4 5 2,6 7 2,5 6 2)\n" 886"\n" 887"\n" 888"SELECT ST_AsEWKT(ST_Force3DZ('POLYGON((0 0,0 5,5 0,0 0),(1 1,3 1,1 3,1 " 889"1))'));\n" 890"\n" 891" st_asewkt\n" 892"--------------------------------------------------------------\n" 893" POLYGON((0 0 0,0 5 0,5 0 0,0 0 0),(1 1 0,3 1 0,1 3 0,1 1 0))" 894msgstr "" 895 896#. Tag: para 897#: reference_editor.xml:416 reference_editor.xml:503 898#, no-c-format 899msgid "" 900", <xref linkend=\"ST_Force2D\"/>, <xref linkend=\"ST_Force_3DM\"/>, <xref " 901"linkend=\"ST_Force_3D\"/>" 902msgstr "" 903 904#. Tag: refname 905#: reference_editor.xml:422 906#, no-c-format 907msgid "ST_Force3DM" 908msgstr "" 909 910#. Tag: refpurpose 911#: reference_editor.xml:424 912#, no-c-format 913msgid "Force the geometries into XYM mode." 914msgstr "" 915 916#. Tag: funcprototype 917#: reference_editor.xml:429 918#, fuzzy, no-c-format 919msgid "" 920"<funcdef>geometry <function>ST_Force3DM</function></funcdef> " 921"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 922"<paramdef><type>float </type> <parameter>Mvalue = 0.0</parameter></paramdef>" 923msgstr "" 924"<funcdef>geometry <function>ST_RotateY</function></funcdef> " 925"<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 926"<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef>" 927 928#. Tag: para 929#: reference_editor.xml:440 930#, no-c-format 931msgid "" 932"Forces the geometries into XYM mode. If a geometry has no M component, then " 933"a <parameter>Mvalue</parameter> M coordinate is tacked on. If it has a Z " 934"component, then Z is removed" 935msgstr "" 936 937#. Tag: para 938#: reference_editor.xml:443 939#, no-c-format 940msgid "Changed: 2.1.0. Up to 2.0.x this was called ST_Force_3DM." 941msgstr "" 942 943#. Tag: para 944#: reference_editor.xml:444 945#, no-c-format 946msgid "Changed: 3.1.0. Added support for supplying a non-zero M value." 947msgstr "" 948 949#. Tag: programlisting 950#: reference_editor.xml:452 951#, no-c-format 952msgid "" 953"--Nothing happens to an already 3D geometry\n" 954"SELECT ST_AsEWKT(ST_Force3DM(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 " 955"5 2, 6 7 2, 5 6 2)')));\n" 956" st_asewkt\n" 957"------------------------------------------------\n" 958" CIRCULARSTRINGM(1 1 0,2 3 0,4 5 0,6 7 0,5 6 0)\n" 959"\n" 960"\n" 961"SELECT ST_AsEWKT(ST_Force3DM('POLYGON((0 0 1,0 5 1,5 0 1,0 0 1),(1 1 1,3 1 " 962"1,1 3 1,1 1 1))'));\n" 963"\n" 964" st_asewkt\n" 965"---------------------------------------------------------------\n" 966" POLYGONM((0 0 0,0 5 0,5 0 0,0 0 0),(1 1 0,3 1 0,1 3 0,1 1 0))" 967msgstr "" 968 969#. Tag: para 970#: reference_editor.xml:459 reference_editor.xml:600 971#, no-c-format 972msgid "" 973", <xref linkend=\"ST_Force2D\"/>, <xref linkend=\"ST_Force_3DM\"/>, <xref " 974"linkend=\"ST_Force_3D\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>" 975msgstr "" 976 977#. Tag: refname 978#: reference_editor.xml:465 979#, no-c-format 980msgid "ST_Force4D" 981msgstr "" 982 983#. Tag: refpurpose 984#: reference_editor.xml:467 985#, no-c-format 986msgid "Force the geometries into XYZM mode." 987msgstr "" 988 989#. Tag: funcprototype 990#: reference_editor.xml:472 991#, fuzzy, no-c-format 992msgid "" 993"<funcdef>geometry <function>ST_Force4D</function></funcdef> " 994"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 995"<paramdef><type>float </type> <parameter>Zvalue = 0.0</parameter></paramdef> " 996"<paramdef><type>float </type> <parameter>Mvalue = 0.0</parameter></paramdef>" 997msgstr "" 998"<funcdef>geometry <function>ST_Snap</function></funcdef> " 999"<paramdef><type>geometry </type> <parameter>input</parameter></paramdef> " 1000"<paramdef><type>geometry </type> <parameter>reference</parameter></paramdef> " 1001"<paramdef><type>float </type> <parameter>tolerance</parameter></paramdef>" 1002 1003#. Tag: para 1004#: reference_editor.xml:484 1005#, no-c-format 1006msgid "" 1007"Forces the geometries into XYZM mode. <parameter>Zvalue</parameter> and " 1008"<parameter>Mvalue</parameter> is tacked on for missing Z and M dimensions, " 1009"respectively." 1010msgstr "" 1011 1012#. Tag: para 1013#: reference_editor.xml:486 1014#, no-c-format 1015msgid "Changed: 2.1.0. Up to 2.0.x this was called ST_Force_4D." 1016msgstr "" 1017 1018#. Tag: para 1019#: reference_editor.xml:487 1020#, no-c-format 1021msgid "Changed: 3.1.0. Added support for supplying non-zero Z and M values." 1022msgstr "" 1023 1024#. Tag: programlisting 1025#: reference_editor.xml:496 1026#, no-c-format 1027msgid "" 1028"--Nothing happens to an already 3D geometry\n" 1029"SELECT ST_AsEWKT(ST_Force4D(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 " 1030"5 2, 6 7 2, 5 6 2)')));\n" 1031" st_asewkt\n" 1032"---------------------------------------------------------\n" 1033" CIRCULARSTRING(1 1 2 0,2 3 2 0,4 5 2 0,6 7 2 0,5 6 2 0)\n" 1034"\n" 1035"\n" 1036"\n" 1037"SELECT ST_AsEWKT(ST_Force4D('MULTILINESTRINGM((0 0 1,0 5 2,5 0 3,0 0 4),(1 " 1038"1 1,3 1 1,1 3 1,1 1 1))'));\n" 1039"\n" 1040" st_asewkt\n" 1041"--------------------------------------------------------------------------------------\n" 1042" MULTILINESTRING((0 0 0 1,0 5 0 2,5 0 0 3,0 0 0 4),(1 1 0 1,3 1 0 1,1 3 0 " 1043"1,1 1 0 1))" 1044msgstr "" 1045 1046#. Tag: refname 1047#: reference_editor.xml:509 1048#, no-c-format 1049msgid "ST_ForcePolygonCCW" 1050msgstr "" 1051 1052#. Tag: refpurpose 1053#: reference_editor.xml:512 1054#, no-c-format 1055msgid "" 1056"Orients all exterior rings counter-clockwise and all interior rings " 1057"clockwise." 1058msgstr "" 1059 1060#. Tag: funcprototype 1061#: reference_editor.xml:519 1062#, no-c-format 1063msgid "" 1064"<funcdef> geometry <function>ST_ForcePolygonCCW</function> </funcdef> " 1065"<paramdef> <type>geometry</type> <parameter>geom</parameter> </paramdef>" 1066msgstr "" 1067 1068#. Tag: para 1069#: reference_editor.xml:535 1070#, no-c-format 1071msgid "" 1072"Forces (Multi)Polygons to use a counter-clockwise orientation for their " 1073"exterior ring, and a clockwise orientation for their interior rings. Non-" 1074"polygonal geometries are returned unchanged." 1075msgstr "" 1076 1077#. Tag: para 1078#: reference_editor.xml:541 reference_editor.xml:638 1079#, fuzzy, no-c-format 1080msgid "Availability: 2.4.0" 1081msgstr "Dostępność: 2.0" 1082 1083#. Tag: para 1084#: reference_editor.xml:548 reference_editor.xml:645 1085#, no-c-format 1086msgid "" 1087", <xref linkend=\"ST_IsPolygonCCW\"/>, <xref linkend=\"ST_IsPolygonCW\"/>" 1088msgstr "" 1089 1090#. Tag: refname 1091#: reference_editor.xml:558 1092#, no-c-format 1093msgid "ST_ForceCollection" 1094msgstr "" 1095 1096#. Tag: refpurpose 1097#: reference_editor.xml:560 1098#, no-c-format 1099msgid "Convert the geometry into a GEOMETRYCOLLECTION." 1100msgstr "" 1101 1102#. Tag: funcprototype 1103#: reference_editor.xml:565 1104#, no-c-format 1105msgid "" 1106"<funcdef>geometry <function>ST_ForceCollection</function></funcdef> " 1107"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 1108msgstr "" 1109 1110#. Tag: para 1111#: reference_editor.xml:575 1112#, no-c-format 1113msgid "" 1114"Converts the geometry into a GEOMETRYCOLLECTION. This is useful for " 1115"simplifying the WKB representation." 1116msgstr "" 1117 1118#. Tag: para 1119#: reference_editor.xml:579 1120#, no-c-format 1121msgid "" 1122"Availability: 1.2.2, prior to 1.3.4 this function will crash with Curves. " 1123"This is fixed in 1.3.4+" 1124msgstr "" 1125 1126#. Tag: para 1127#: reference_editor.xml:580 1128#, no-c-format 1129msgid "Changed: 2.1.0. Up to 2.0.x this was called ST_Force_Collection." 1130msgstr "" 1131 1132#. Tag: programlisting 1133#: reference_editor.xml:591 1134#, no-c-format 1135msgid "" 1136"SELECT ST_AsEWKT(ST_ForceCollection('POLYGON((0 0 1,0 5 1,5 0 1,0 0 1),(1 1 " 1137"1,3 1 1,1 3 1,1 1 1))'));\n" 1138"\n" 1139" st_asewkt\n" 1140"----------------------------------------------------------------------------------\n" 1141" GEOMETRYCOLLECTION(POLYGON((0 0 1,0 5 1,5 0 1,0 0 1),(1 1 1,3 1 1,1 3 1,1 1 " 1142"1)))\n" 1143"\n" 1144"\n" 1145" SELECT ST_AsText(ST_ForceCollection('CIRCULARSTRING(220227 150406,2220227 " 1146"150407,220227 150406)'));\n" 1147" st_astext\n" 1148"--------------------------------------------------------------------------------\n" 1149" GEOMETRYCOLLECTION(CIRCULARSTRING(220227 150406,2220227 150407,220227 " 1150"150406))\n" 1151"(1 row)" 1152msgstr "" 1153 1154#. Tag: programlisting 1155#: reference_editor.xml:593 1156#, no-c-format 1157msgid "" 1158"-- POLYHEDRAL example --\n" 1159"SELECT ST_AsEWKT(ST_ForceCollection('POLYHEDRALSURFACE(((0 0 0,0 0 1,0 1 1,0 " 1160"1 0,0 0 0)),\n" 1161" ((0 0 0,0 1 0,1 1 0,1 0 0,0 0 0)),\n" 1162" ((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0)),\n" 1163" ((1 1 0,1 1 1,1 0 1,1 0 0,1 1 0)),\n" 1164" ((0 1 0,0 1 1,1 1 1,1 1 0,0 1 0)),\n" 1165" ((0 0 1,1 0 1,1 1 1,0 1 1,0 0 1)))'))\n" 1166"\n" 1167" st_asewkt\n" 1168"----------------------------------------------------------------------------------\n" 1169"GEOMETRYCOLLECTION(\n" 1170" POLYGON((0 0 0,0 0 1,0 1 1,0 1 0,0 0 0)),\n" 1171" POLYGON((0 0 0,0 1 0,1 1 0,1 0 0,0 0 0)),\n" 1172" POLYGON((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0)),\n" 1173" POLYGON((1 1 0,1 1 1,1 0 1,1 0 0,1 1 0)),\n" 1174" POLYGON((0 1 0,0 1 1,1 1 1,1 1 0,0 1 0)),\n" 1175" POLYGON((0 0 1,1 0 1,1 1 1,0 1 1,0 0 1))\n" 1176")" 1177msgstr "" 1178 1179#. Tag: refname 1180#: reference_editor.xml:606 1181#, no-c-format 1182msgid "ST_ForcePolygonCW" 1183msgstr "" 1184 1185#. Tag: refpurpose 1186#: reference_editor.xml:609 1187#, no-c-format 1188msgid "" 1189"Orients all exterior rings clockwise and all interior rings counter-" 1190"clockwise." 1191msgstr "" 1192 1193#. Tag: funcprototype 1194#: reference_editor.xml:616 1195#, no-c-format 1196msgid "" 1197"<funcdef> geometry <function>ST_ForcePolygonCW</function> </funcdef> " 1198"<paramdef> <type>geometry</type> <parameter>geom</parameter> </paramdef>" 1199msgstr "" 1200 1201#. Tag: para 1202#: reference_editor.xml:632 1203#, no-c-format 1204msgid "" 1205"Forces (Multi)Polygons to use a clockwise orientation for their exterior " 1206"ring, and a counter-clockwise orientation for their interior rings. Non-" 1207"polygonal geometries are returned unchanged." 1208msgstr "" 1209 1210#. Tag: refname 1211#: reference_editor.xml:655 1212#, no-c-format 1213msgid "ST_ForceSFS" 1214msgstr "" 1215 1216#. Tag: refpurpose 1217#: reference_editor.xml:657 1218#, no-c-format 1219msgid "Force the geometries to use SFS 1.1 geometry types only." 1220msgstr "" 1221 1222#. Tag: funcsynopsis 1223#: reference_editor.xml:661 1224#, no-c-format 1225msgid "" 1226"<funcprototype> <funcdef>geometry <function>ST_ForceSFS</function></funcdef> " 1227"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> </" 1228"funcprototype> <funcprototype> <funcdef>geometry <function>ST_ForceSFS</" 1229"function></funcdef> <paramdef><type>geometry </type> <parameter>geomA</" 1230"parameter></paramdef> <paramdef><type>text </type> <parameter>version</" 1231"parameter></paramdef> </funcprototype>" 1232msgstr "" 1233 1234#. Tag: refname 1235#: reference_editor.xml:687 1236#, no-c-format 1237msgid "ST_ForceRHR" 1238msgstr "ST_ForceRHR" 1239 1240#. Tag: refpurpose 1241#: reference_editor.xml:689 1242#, no-c-format 1243msgid "" 1244"Force the orientation of the vertices in a polygon to follow the Right-Hand-" 1245"Rule." 1246msgstr "" 1247 1248#. Tag: funcprototype 1249#: reference_editor.xml:695 1250#, no-c-format 1251msgid "" 1252"<funcdef>geometry <function>ST_ForceRHR</function></funcdef> " 1253"<paramdef><type>geometry</type> <parameter>g</parameter></paramdef>" 1254msgstr "" 1255 1256#. Tag: para 1257#: reference_editor.xml:706 1258#, no-c-format 1259msgid "" 1260"Forces the orientation of the vertices in a polygon to follow a Right-Hand-" 1261"Rule, in which the area that is bounded by the polygon is to the right of " 1262"the boundary. In particular, the exterior ring is orientated in a clockwise " 1263"direction and the interior rings in a counter-clockwise direction. This " 1264"function is a synonym for <xref linkend=\"ST_ForcePolygonCW\"/>" 1265msgstr "" 1266 1267#. Tag: para 1268#: reference_editor.xml:713 1269#, no-c-format 1270msgid "" 1271"The above definition of the Right-Hand-Rule conflicts with definitions used " 1272"in other contexts. To avoid confusion, it is recommended to use " 1273"ST_ForcePolygonCW." 1274msgstr "" 1275 1276#. Tag: programlisting 1277#: reference_editor.xml:726 1278#, no-c-format 1279msgid "" 1280"SELECT ST_AsEWKT(\n" 1281" ST_ForceRHR(\n" 1282" 'POLYGON((0 0 2, 5 0 2, 0 5 2, 0 0 2),(1 1 2, 1 3 2, 3 1 2, 1 1 " 1283"2))'\n" 1284" )\n" 1285");\n" 1286" st_asewkt\n" 1287"--------------------------------------------------------------\n" 1288" POLYGON((0 0 2,0 5 2,5 0 2,0 0 2),(1 1 2,3 1 2,1 3 2,1 1 2))\n" 1289"(1 row)" 1290msgstr "" 1291 1292#. Tag: para 1293#: reference_editor.xml:732 1294#, no-c-format 1295msgid "" 1296", <xref linkend=\"ST_ForcePolygonCW\"/>, <xref linkend=\"ST_IsPolygonCCW\"/" 1297">, <xref linkend=\"ST_IsPolygonCW\"/>, <xref linkend=\"ST_BuildArea\"/>, " 1298"<xref linkend=\"ST_Polygonize\"/>, <xref linkend=\"ST_Reverse\"/>" 1299msgstr "" 1300 1301#. Tag: refname 1302#: reference_editor.xml:745 1303#, no-c-format 1304msgid "ST_ForceCurve" 1305msgstr "" 1306 1307#. Tag: refpurpose 1308#: reference_editor.xml:747 1309#, no-c-format 1310msgid "Upcast a geometry into its curved type, if applicable." 1311msgstr "" 1312 1313#. Tag: funcprototype 1314#: reference_editor.xml:752 1315#, no-c-format 1316msgid "" 1317"<funcdef>geometry <function>ST_ForceCurve</function></funcdef> " 1318"<paramdef><type>geometry</type> <parameter>g</parameter></paramdef>" 1319msgstr "" 1320 1321#. Tag: para 1322#: reference_editor.xml:763 1323#, no-c-format 1324msgid "" 1325"Turns a geometry into its curved representation, if applicable: lines become " 1326"compoundcurves, multilines become multicurves polygons become curvepolygons " 1327"multipolygons become multisurfaces. If the geometry input is already a " 1328"curved representation returns back same as input." 1329msgstr "" 1330 1331#. Tag: para 1332#: reference_editor.xml:769 reference_editor.xml:1144 reference_editor.xml:1651 1333#, no-c-format 1334msgid "Availability: 2.2.0" 1335msgstr "" 1336 1337#. Tag: programlisting 1338#: reference_editor.xml:778 1339#, no-c-format 1340msgid "" 1341"SELECT ST_AsText(\n" 1342" ST_ForceCurve(\n" 1343" 'POLYGON((0 0 2, 5 0 2, 0 5 2, 0 0 2),(1 1 2, 1 3 2, 3 1 2, 1 1 " 1344"2))'::geometry\n" 1345" )\n" 1346");\n" 1347" st_astext\n" 1348"----------------------------------------------------------------------\n" 1349" CURVEPOLYGON Z ((0 0 2,5 0 2,0 5 2,0 0 2),(1 1 2,1 3 2,3 1 2,1 1 2))\n" 1350"(1 row)" 1351msgstr "" 1352 1353#. Tag: refname 1354#: reference_editor.xml:790 1355#, no-c-format 1356msgid "ST_LineMerge" 1357msgstr "ST_LineMerge" 1358 1359#. Tag: refpurpose 1360#: reference_editor.xml:792 1361#, no-c-format 1362msgid "" 1363"Return a (set of) LineString(s) formed by sewing together a MULTILINESTRING." 1364msgstr "" 1365 1366#. Tag: funcprototype 1367#: reference_editor.xml:798 1368#, no-c-format 1369msgid "" 1370"<funcdef>geometry <function>ST_LineMerge</function></funcdef> " 1371"<paramdef><type>geometry </type> <parameter>amultilinestring</parameter></" 1372"paramdef>" 1373msgstr "" 1374"<funcdef>geometry <function>ST_LineMerge</function></funcdef> " 1375"<paramdef><type>geometry </type> <parameter>amultilinestring</parameter></" 1376"paramdef>" 1377 1378#. Tag: para 1379#: reference_editor.xml:808 1380#, no-c-format 1381msgid "" 1382"Returns a (set of) LineString(s) formed by sewing together the constituent " 1383"line work of a MULTILINESTRING." 1384msgstr "" 1385 1386#. Tag: para 1387#: reference_editor.xml:810 1388#, no-c-format 1389msgid "" 1390"Only use with MULTILINESTRING/LINESTRINGs. If you feed a polygon or geometry " 1391"collection into this function, it will return an empty GEOMETRYCOLLECTION" 1392msgstr "" 1393 1394#. Tag: para 1395#: reference_editor.xml:812 reference_editor.xml:1536 1396#, no-c-format 1397msgid "Performed by the GEOS module." 1398msgstr "" 1399 1400#. Tag: para 1401#: reference_editor.xml:814 1402#, no-c-format 1403msgid "Will strip the M dimension." 1404msgstr "" 1405 1406#. Tag: programlisting 1407#: reference_editor.xml:820 1408#, no-c-format 1409msgid "" 1410"SELECT ST_AsText(ST_LineMerge(\n" 1411"ST_GeomFromText('MULTILINESTRING((-29 -27,-30 -29.7,-36 -31,-45 -33),(-45 " 1412"-33,-46 -32))')\n" 1413" )\n" 1414");\n" 1415"st_astext\n" 1416"--------------------------------------------------------------------------------------------------\n" 1417"LINESTRING(-29 -27,-30 -29.7,-36 -31,-45 -33,-46 -32)\n" 1418"(1 row)\n" 1419"\n" 1420"--If can't be merged - original MULTILINESTRING is returned\n" 1421"SELECT ST_AsText(ST_LineMerge(\n" 1422"ST_GeomFromText('MULTILINESTRING((-29 -27,-30 -29.7,-36 -31,-45 -33),(-45.2 " 1423"-33.2,-46 -32))')\n" 1424")\n" 1425");\n" 1426"st_astext\n" 1427"----------------\n" 1428"MULTILINESTRING((-45.2 -33.2,-46 -32),(-29 -27,-30 -29.7,-36 -31,-45 -33))\n" 1429"\n" 1430"-- example with Z dimension\n" 1431"SELECT ST_AsText(ST_LineMerge(\n" 1432"ST_GeomFromText('MULTILINESTRING((-29 -27 11,-30 -29.7 10,-36 -31 5,-45 -33 " 1433"6), (-29 -27 12,-30 -29.7 5), (-45 -33 1,-46 -32 11))')\n" 1434" )\n" 1435");\n" 1436"st_astext\n" 1437"--------------------------------------------------------------------------------------------------\n" 1438"LINESTRING Z (-30 -29.7 5,-29 -27 11,-30 -29.7 10,-36 -31 5,-45 -33 1,-46 " 1439"-32 11)\n" 1440"(1 row)" 1441msgstr "" 1442 1443#. Tag: para 1444#: reference_editor.xml:824 1445#, no-c-format 1446msgid ", <xref linkend=\"ST_LineSubstring\"/>" 1447msgstr "" 1448 1449#. Tag: refname 1450#: reference_editor.xml:830 1451#, fuzzy, no-c-format 1452msgid "ST_LineToCurve" 1453msgstr "ST_LineMerge" 1454 1455#. Tag: refpurpose 1456#: reference_editor.xml:832 1457#, no-c-format 1458msgid "Converts a linear geometry to a curved geometry." 1459msgstr "" 1460 1461#. Tag: funcprototype 1462#: reference_editor.xml:837 1463#, fuzzy, no-c-format 1464msgid "" 1465"<funcdef>geometry <function>ST_LineToCurve</function></funcdef> " 1466"<paramdef><type>geometry </type> <parameter>geomANoncircular</parameter></" 1467"paramdef>" 1468msgstr "" 1469"<funcdef>geometry <function>ST_Reverse</function></funcdef> " 1470"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 1471 1472#. Tag: para 1473#: reference_editor.xml:847 1474#, no-c-format 1475msgid "" 1476"Converts plain LINESTRING/POLYGON to CIRCULAR STRINGs and Curved Polygons. " 1477"Note much fewer points are needed to describe the curved equivalent." 1478msgstr "" 1479 1480#. Tag: para 1481#: reference_editor.xml:848 1482#, no-c-format 1483msgid "" 1484"If the input LINESTRING/POLYGON is not curved enough to clearly represent a " 1485"curve, the function will return the same input geometry." 1486msgstr "" 1487 1488#. Tag: programlisting 1489#: reference_editor.xml:858 1490#, no-c-format 1491msgid "" 1492"-- 2D Example\n" 1493"SELECT ST_AsText(ST_LineToCurve(foo.the_geom)) As curvedastext,ST_AsText(foo." 1494"the_geom) As non_curvedastext\n" 1495" FROM (SELECT ST_Buffer('POINT(1 3)'::geometry, 3) As the_geom) As foo;\n" 1496"\n" 1497"curvedatext " 1498"non_curvedastext\n" 1499"--------------------------------------------------------------------|-----------------------------------------------------------------\n" 1500"CURVEPOLYGON(CIRCULARSTRING(4 3,3.12132034355964 0.878679656440359, | " 1501"POLYGON((4 3,3.94235584120969 2.41472903395162,3.77163859753386 " 1502"1.85194970290473,\n" 1503"1 0,-1.12132034355965 5.12132034355963,4 3)) | " 1504"3.49440883690764 1.33328930094119,3.12132034355964 0.878679656440359,\n" 1505" | " 1506"2.66671069905881 0.505591163092366,2.14805029709527 0.228361402466141,\n" 1507" | " 1508"1.58527096604839 0.0576441587903094,1 0,\n" 1509" | " 1510"0.414729033951621 0.0576441587903077,-0.148050297095264 0.228361402466137,\n" 1511" | " 1512"-0.666710699058802 0.505591163092361,-1.12132034355964 0.878679656440353,\n" 1513" | " 1514"-1.49440883690763 1.33328930094119,-1.77163859753386 1.85194970290472\n" 1515" | --" 1516"ETC-- ,3.94235584120969 3.58527096604839,4 3))\n" 1517"\n" 1518"--3D example\n" 1519"SELECT ST_AsText(ST_LineToCurve(geom)) As curved, ST_AsText(geom) AS " 1520"not_curved\n" 1521"FROM (SELECT ST_Translate(ST_Force3D(ST_Boundary(ST_Buffer(ST_Point(1,3), " 1522"2,2))),0,0,3) AS geom) AS foo;\n" 1523"\n" 1524" curved | " 1525"not_curved\n" 1526"------------------------------------------------------" 1527"+---------------------------------------------------------------------\n" 1528" CIRCULARSTRING Z (3 3 3,-1 2.99999999999999 3,3 3 3) | LINESTRING Z (3 3 " 1529"3,2.4142135623731 1.58578643762691 3,1 1 3,\n" 1530" | -0.414213562373092 " 1531"1.5857864376269 3,-1 2.99999999999999 3,\n" 1532" | -0.414213562373101 " 1533"4.41421356237309 3,\n" 1534" | 0.999999999999991 5 " 1535"3,2.41421356237309 4.4142135623731 3,3 3 3)\n" 1536"(1 row)" 1537msgstr "" 1538 1539#. Tag: refname 1540#: reference_editor.xml:873 1541#, no-c-format 1542msgid "ST_Multi" 1543msgstr "ST_Multi" 1544 1545#. Tag: refpurpose 1546#: reference_editor.xml:875 1547#, no-c-format 1548msgid "Return the geometry as a MULTI* geometry." 1549msgstr "" 1550 1551#. Tag: funcprototype 1552#: reference_editor.xml:880 1553#, no-c-format 1554msgid "" 1555"<funcdef>geometry <function>ST_Multi</function></funcdef> " 1556"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 1557msgstr "" 1558 1559#. Tag: para 1560#: reference_editor.xml:890 1561#, no-c-format 1562msgid "" 1563"Returns the geometry as a MULTI* geometry. If the geometry is already a " 1564"MULTI*, it is returned unchanged." 1565msgstr "" 1566 1567#. Tag: programlisting 1568#: reference_editor.xml:898 1569#, no-c-format 1570msgid "" 1571"SELECT ST_AsText(ST_Multi(ST_GeomFromText('POLYGON((743238 2967416,743238 " 1572"2967450,\n" 1573" 743265 2967450,743265.625 2967416,743238 " 1574"2967416))')));\n" 1575" st_astext\n" 1576" --------------------------------------------------------------------------------------------------\n" 1577" MULTIPOLYGON(((743238 2967416,743238 2967450,743265 " 1578"2967450,743265.625 2967416,\n" 1579" 743238 2967416)))\n" 1580" (1 row)" 1581msgstr "" 1582 1583#. Tag: refname 1584#: reference_editor.xml:908 1585#, no-c-format 1586msgid "ST_Normalize" 1587msgstr "" 1588 1589#. Tag: refpurpose 1590#: reference_editor.xml:910 1591#, no-c-format 1592msgid "Return the geometry in its canonical form." 1593msgstr "" 1594 1595#. Tag: funcprototype 1596#: reference_editor.xml:915 1597#, no-c-format 1598msgid "" 1599"<funcdef>geometry <function>ST_Normalize</function></funcdef> " 1600"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 1601msgstr "" 1602 1603#. Tag: para 1604#: reference_editor.xml:925 1605#, no-c-format 1606msgid "" 1607"Returns the geometry in its normalized/canonical form. May reorder vertices " 1608"in polygon rings, rings in a polygon, elements in a multi-geometry complex." 1609msgstr "" 1610 1611#. Tag: para 1612#: reference_editor.xml:931 1613#, no-c-format 1614msgid "" 1615"Mostly only useful for testing purposes (comparing expected and obtained " 1616"results)." 1617msgstr "" 1618 1619#. Tag: para 1620#: reference_editor.xml:936 1621#, no-c-format 1622msgid "Availability: 2.3.0" 1623msgstr "" 1624 1625#. Tag: programlisting 1626#: reference_editor.xml:943 1627#, no-c-format 1628msgid "" 1629"SELECT ST_AsText(ST_Normalize(ST_GeomFromText(\n" 1630" 'GEOMETRYCOLLECTION(\n" 1631" POINT(2 3),\n" 1632" MULTILINESTRING((0 0, 1 1),(2 2, 3 3)),\n" 1633" POLYGON(\n" 1634" (0 10,0 0,10 0,10 10,0 10),\n" 1635" (4 2,2 2,2 4,4 4,4 2),\n" 1636" (6 8,8 8,8 6,6 6,6 8)\n" 1637" )\n" 1638" )'\n" 1639")));\n" 1640" st_astext\n" 1641"----------------------------------------------------------------------------------------------------------------------------------------------------\n" 1642" GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(6 6,8 6,8 8,6 8,6 6)," 1643"(2 2,4 2,4 4,2 4,2 2)),MULTILINESTRING((2 2,3 3),(0 0,1 1)),POINT(2 3))\n" 1644"(1 row)" 1645msgstr "" 1646 1647#. Tag: para 1648#: reference_editor.xml:947 1649#, no-c-format 1650msgid "<para>,</para>" 1651msgstr "" 1652 1653#. Tag: refname 1654#: reference_editor.xml:955 1655#, no-c-format 1656msgid "ST_QuantizeCoordinates" 1657msgstr "" 1658 1659#. Tag: refpurpose 1660#: reference_editor.xml:958 1661#, no-c-format 1662msgid "Sets least significant bits of coordinates to zero" 1663msgstr "" 1664 1665#. Tag: funcprototype 1666#: reference_editor.xml:965 1667#, fuzzy, no-c-format 1668msgid "" 1669"<funcdef> geometry <function>ST_QuantizeCoordinates</function> </funcdef> " 1670"<paramdef> <type>geometry</type> <parameter>g</parameter> </paramdef> " 1671"<paramdef> <type>int</type> <parameter>prec_x</parameter> </paramdef> " 1672"<paramdef> <type>int</type> <parameter>prec_y</parameter> </paramdef> " 1673"<paramdef> <type>int</type> <parameter>prec_z</parameter> </paramdef> " 1674"<paramdef> <type>int</type> <parameter>prec_m</parameter> </paramdef>" 1675msgstr "" 1676"<funcdef>geometry <function>ST_TransScale</function></funcdef> " 1677"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 1678"<paramdef><type>float</type> <parameter>deltaX</parameter></paramdef> " 1679"<paramdef><type>float</type> <parameter>deltaY</parameter></paramdef> " 1680"<paramdef><type>float</type> <parameter>XFactor</parameter></paramdef> " 1681"<paramdef><type>float</type> <parameter>YFactor</parameter></paramdef>" 1682 1683#. Tag: para 1684#: reference_editor.xml:996 1685#, no-c-format 1686msgid "" 1687"<code>ST_QuantizeCoordinates</code> determines the number of bits (<code>N</" 1688"code>) required to represent a coordinate value with a specified number of " 1689"digits after the decimal point, and then sets all but the <code>N</code> " 1690"most significant bits to zero. The resulting coordinate value will still " 1691"round to the original value, but will have improved compressiblity. This can " 1692"result in a significant disk usage reduction provided that the geometry " 1693"column is using a <ulink url=\"https://www.postgresql.org/docs/current/" 1694"static/storage-toast.html#STORAGE-TOAST-ONDISK\"> compressible storage type</" 1695"ulink>. The function allows specification of a different number of digits " 1696"after the decimal point in each dimension; unspecified dimensions are " 1697"assumed to have the precsion of the <code>x</code> dimension. Negative " 1698"digits are interpreted to refer digits to the left of the decimal point, (i." 1699"e., <code>prec_x=-2</code> will preserve coordinate values to the nearest " 1700"100." 1701msgstr "" 1702 1703#. Tag: para 1704#: reference_editor.xml:1014 1705#, no-c-format 1706msgid "" 1707"The coordinates produced by <code>ST_QuantizeCoordinates</code> are " 1708"independent of the geometry that contains those coordinates and the relative " 1709"position of those coordinates within the geometry. As a result, existing " 1710"topological relationships between geometries are unaffected by use of this " 1711"function. The function may produce invalid geometry when it is called with a " 1712"number of digits lower than the intrinsic precision of the geometry." 1713msgstr "" 1714 1715#. Tag: para 1716#: reference_editor.xml:1023 1717#, fuzzy, no-c-format 1718msgid "Availability: 2.5.0" 1719msgstr "Dostępność: 2.0" 1720 1721#. Tag: title 1722#: reference_editor.xml:1026 1723#, no-c-format 1724msgid "Technical Background" 1725msgstr "" 1726 1727#. Tag: para 1728#: reference_editor.xml:1027 1729#, no-c-format 1730msgid "" 1731"PostGIS stores all coordinate values as double-precision floating point " 1732"integers, which can reliably represent 15 significant digits. However, " 1733"PostGIS may be used to manage data that intrinsically has fewer than 15 " 1734"significant digits. An example is TIGER data, which is provided as " 1735"geographic coordinates with six digits of precision after the decimal point " 1736"(thus requiring only nine significant digits of longitude and eight " 1737"significant digits of latitude.)" 1738msgstr "" 1739 1740#. Tag: para 1741#: reference_editor.xml:1036 1742#, no-c-format 1743msgid "" 1744"When 15 significant digits are available, there are many possible " 1745"representations of a number with 9 significant digits. A double precision " 1746"floating point number uses 52 explicit bits to represent the significand " 1747"(mantissa) of the coordinate. Only 30 bits are needed to represent a " 1748"mantissa with 9 significant digits, leaving 22 insignificant bits; we can " 1749"set their value to anything we like and still end up with a number that " 1750"rounds to our input value. For example, the value 100.123456 can be " 1751"represented by the floating point numbers closest to 100.123456000000, " 1752"100.123456000001, and 100.123456432199. All are equally valid, in that " 1753"<code>ST_AsText(geom, 6)</code> will return the same result with any of " 1754"these inputs. As we can set these bits to any value, " 1755"<code>ST_QuantizeCoordinates</code> sets the 22 insignificant bits to zero. " 1756"For a long coordinate sequence this creates a pattern of blocks of " 1757"consecutive zeros that is compressed by PostgreSQL more effeciently." 1758msgstr "" 1759 1760#. Tag: para 1761#: reference_editor.xml:1056 1762#, no-c-format 1763msgid "" 1764"Only the on-disk size of the geometry is potentially affected by " 1765"<code>ST_QuantizeCoordinates</code>. <xref linkend=\"ST_MemSize\"/>, which " 1766"reports the in-memory usage of the geometry, will return the the same value " 1767"regardless of the disk space used by a geometry." 1768msgstr "" 1769 1770#. Tag: programlisting 1771#: reference_editor.xml:1068 1772#, no-c-format 1773msgid "" 1774"SELECT ST_AsText(ST_QuantizeCoordinates('POINT (100.123456 0)'::geometry, " 1775"4));\n" 1776"st_astext\n" 1777"-------------------------\n" 1778"POINT(100.123455047607 0)" 1779msgstr "" 1780 1781#. Tag: programlisting 1782#: reference_editor.xml:1070 1783#, no-c-format 1784msgid "" 1785"WITH test AS (SELECT 'POINT (123.456789123456 123.456789123456)'::geometry " 1786"AS geom)\n" 1787"SELECT\n" 1788" digits,\n" 1789" encode(ST_QuantizeCoordinates(geom, digits), 'hex'),\n" 1790" ST_AsText(ST_QuantizeCoordinates(geom, digits))\n" 1791"FROM test, generate_series(15, -15, -1) AS digits;\n" 1792"\n" 1793"digits | encode | " 1794"st_astext\n" 1795"--------+--------------------------------------------" 1796"+------------------------------------------\n" 1797"15 | 01010000005f9a72083cdd5e405f9a72083cdd5e40 | " 1798"POINT(123.456789123456 123.456789123456)\n" 1799"14 | 01010000005f9a72083cdd5e405f9a72083cdd5e40 | " 1800"POINT(123.456789123456 123.456789123456)\n" 1801"13 | 01010000005f9a72083cdd5e405f9a72083cdd5e40 | " 1802"POINT(123.456789123456 123.456789123456)\n" 1803"12 | 01010000005c9a72083cdd5e405c9a72083cdd5e40 | " 1804"POINT(123.456789123456 123.456789123456)\n" 1805"11 | 0101000000409a72083cdd5e40409a72083cdd5e40 | " 1806"POINT(123.456789123456 123.456789123456)\n" 1807"10 | 0101000000009a72083cdd5e40009a72083cdd5e40 | " 1808"POINT(123.456789123455 123.456789123455)\n" 1809"9 | 0101000000009072083cdd5e40009072083cdd5e40 | " 1810"POINT(123.456789123418 123.456789123418)\n" 1811"8 | 0101000000008072083cdd5e40008072083cdd5e40 | POINT(123.45678912336 " 1812"123.45678912336)\n" 1813"7 | 0101000000000070083cdd5e40000070083cdd5e40 | " 1814"POINT(123.456789121032 123.456789121032)\n" 1815"6 | 0101000000000040083cdd5e40000040083cdd5e40 | " 1816"POINT(123.456789076328 123.456789076328)\n" 1817"5 | 0101000000000000083cdd5e40000000083cdd5e40 | " 1818"POINT(123.456789016724 123.456789016724)\n" 1819"4 | 0101000000000000003cdd5e40000000003cdd5e40 | " 1820"POINT(123.456787109375 123.456787109375)\n" 1821"3 | 0101000000000000003cdd5e40000000003cdd5e40 | " 1822"POINT(123.456787109375 123.456787109375)\n" 1823"2 | 01010000000000000038dd5e400000000038dd5e40 | POINT(123.45654296875 " 1824"123.45654296875)\n" 1825"1 | 01010000000000000000dd5e400000000000dd5e40 | POINT(123.453125 " 1826"123.453125)\n" 1827"0 | 01010000000000000000dc5e400000000000dc5e40 | POINT(123.4375 " 1828"123.4375)\n" 1829"-1 | 01010000000000000000c05e400000000000c05e40 | POINT(123 123)\n" 1830"-2 | 01010000000000000000005e400000000000005e40 | POINT(120 120)\n" 1831"-3 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1832"-4 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1833"-5 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1834"-6 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1835"-7 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1836"-8 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1837"-9 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1838"-10 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1839"-11 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1840"-12 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1841"-13 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1842"-14 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1843"-15 | 010100000000000000000058400000000000005840 | POINT(96 96)" 1844msgstr "" 1845 1846#. Tag: refname 1847#: reference_editor.xml:1085 1848#, no-c-format 1849msgid "ST_RemovePoint" 1850msgstr "ST_RemovePoint" 1851 1852#. Tag: refpurpose 1853#: reference_editor.xml:1086 1854#, no-c-format 1855msgid "Remove point from a linestring." 1856msgstr "" 1857 1858#. Tag: funcprototype 1859#: reference_editor.xml:1090 1860#, no-c-format 1861msgid "" 1862"<funcdef>geometry <function>ST_RemovePoint</function></funcdef> " 1863"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 1864"<paramdef><type>integer</type> <parameter>offset</parameter></paramdef>" 1865msgstr "" 1866 1867#. Tag: para 1868#: reference_editor.xml:1101 1869#, no-c-format 1870msgid "" 1871"Remove a point from a linestring, given its 0-based index. Useful for " 1872"turning a closed ring into an open line string" 1873msgstr "" 1874 1875#. Tag: programlisting 1876#: reference_editor.xml:1108 1877#, no-c-format 1878msgid "" 1879"--guarantee no LINESTRINGS are closed\n" 1880"--by removing the end point. The below assumes the_geom is of type " 1881"LINESTRING\n" 1882"UPDATE sometable\n" 1883" SET the_geom = ST_RemovePoint(the_geom, ST_NPoints(the_geom) - 1)\n" 1884" FROM sometable\n" 1885" WHERE ST_IsClosed(the_geom) = true;" 1886msgstr "" 1887 1888#. Tag: para 1889#: reference_editor.xml:1112 1890#, no-c-format 1891msgid ", <xref linkend=\"ST_NPoints\"/>, <xref linkend=\"ST_NumPoints\"/>" 1892msgstr ", <xref linkend=\"ST_NPoints\"/>, <xref linkend=\"ST_NumPoints\"/>" 1893 1894#. Tag: refname 1895#: reference_editor.xml:1118 1896#, fuzzy, no-c-format 1897msgid "ST_RemoveRepeatedPoints" 1898msgstr "ST_RemovePoint" 1899 1900#. Tag: refpurpose 1901#: reference_editor.xml:1119 1902#, no-c-format 1903msgid "Returns a version of the given geometry with duplicated points removed." 1904msgstr "" 1905 1906#. Tag: funcprototype 1907#: reference_editor.xml:1125 1908#, fuzzy, no-c-format 1909msgid "" 1910"<funcdef>geometry <function>ST_RemoveRepeatedPoints</function></funcdef> " 1911"<paramdef><type>geometry</type> <parameter>geom</parameter></paramdef> " 1912"<paramdef choice=\"opt\"><type>float8</type> <parameter>tolerance</" 1913"parameter></paramdef>" 1914msgstr "" 1915"<funcdef>geometry <function>ST_SetSRID</function></funcdef> " 1916"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> " 1917"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef>" 1918 1919#. Tag: para 1920#: reference_editor.xml:1135 1921#, no-c-format 1922msgid "" 1923"Returns a version of the given geometry with duplicated points removed. Will " 1924"actually do something only with (multi)lines, (multi)polygons and " 1925"multipoints but you can safely call it with any kind of geometry. Since " 1926"simplification occurs on a object-by-object basis you can also feed a " 1927"GeometryCollection to this function." 1928msgstr "" 1929 1930#. Tag: para 1931#: reference_editor.xml:1141 1932#, no-c-format 1933msgid "" 1934"If the tolerance parameter is provided, vertices within the tolerance of one " 1935"another will be considered the \"same\" for the purposes of removal." 1936msgstr "" 1937 1938#. Tag: refname 1939#: reference_editor.xml:1157 1940#, no-c-format 1941msgid "ST_Reverse" 1942msgstr "ST_Reverse" 1943 1944#. Tag: refpurpose 1945#: reference_editor.xml:1158 1946#, no-c-format 1947msgid "Return the geometry with vertex order reversed." 1948msgstr "" 1949 1950#. Tag: funcprototype 1951#: reference_editor.xml:1163 1952#, no-c-format 1953msgid "" 1954"<funcdef>geometry <function>ST_Reverse</function></funcdef> " 1955"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 1956msgstr "" 1957"<funcdef>geometry <function>ST_Reverse</function></funcdef> " 1958"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 1959 1960#. Tag: para 1961#: reference_editor.xml:1173 1962#, no-c-format 1963msgid "Can be used on any geometry and reverses the order of the vertexes." 1964msgstr "" 1965 1966#. Tag: para 1967#: reference_editor.xml:1175 1968#, no-c-format 1969msgid "Enhanced: 2.4.0 support for curves was introduced." 1970msgstr "" 1971 1972#. Tag: programlisting 1973#: reference_editor.xml:1182 1974#, no-c-format 1975msgid "" 1976"SELECT ST_AsText(the_geom) as line, ST_AsText(ST_Reverse(the_geom)) As " 1977"reverseline\n" 1978"FROM\n" 1979"(SELECT ST_MakeLine(ST_MakePoint(1,2),\n" 1980" ST_MakePoint(1,10)) As the_geom) as foo;\n" 1981"--result\n" 1982" line | reverseline\n" 1983"---------------------+----------------------\n" 1984"LINESTRING(1 2,1 10) | LINESTRING(1 10,1 2)" 1985msgstr "" 1986 1987#. Tag: refname 1988#: reference_editor.xml:1188 1989#, no-c-format 1990msgid "ST_Segmentize" 1991msgstr "ST_Segmentize" 1992 1993#. Tag: refpurpose 1994#: reference_editor.xml:1190 1995#, no-c-format 1996msgid "" 1997"Return a modified geometry/geography having no segment longer than the given " 1998"distance." 1999msgstr "" 2000 2001#. Tag: funcsynopsis 2002#: reference_editor.xml:1195 2003#, no-c-format 2004msgid "" 2005"<funcprototype> <funcdef>geometry <function>ST_Segmentize</function></" 2006"funcdef> <paramdef><type>geometry </type> <parameter>geom</parameter></" 2007"paramdef> <paramdef><type>float </type> <parameter>max_segment_length</" 2008"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geography " 2009"<function>ST_Segmentize</function></funcdef> <paramdef><type>geography </" 2010"type> <parameter>geog</parameter></paramdef> <paramdef><type>float </type> " 2011"<parameter>max_segment_length</parameter></paramdef> </funcprototype>" 2012msgstr "" 2013 2014#. Tag: para 2015#: reference_editor.xml:1212 2016#, no-c-format 2017msgid "" 2018"Returns a modified geometry having no segment longer than the given " 2019"<varname>max_segment_length</varname>. Distance computation is performed in " 2020"2d only. For geometry, length units are in units of spatial reference. For " 2021"geography, units are in meters." 2022msgstr "" 2023 2024#. Tag: para 2025#: reference_editor.xml:1215 2026#, no-c-format 2027msgid "Availability: 1.2.2" 2028msgstr "Dostępność: 1.2.2" 2029 2030#. Tag: para 2031#: reference_editor.xml:1216 2032#, no-c-format 2033msgid "Enhanced: 3.0.0 Segmentize geometry now uses equal length segments" 2034msgstr "" 2035 2036#. Tag: para 2037#: reference_editor.xml:1217 2038#, no-c-format 2039msgid "Enhanced: 2.3.0 Segmentize geography now uses equal length segments" 2040msgstr "" 2041 2042#. Tag: para 2043#: reference_editor.xml:1218 2044#, no-c-format 2045msgid "Enhanced: 2.1.0 support for geography was introduced." 2046msgstr "" 2047 2048#. Tag: para 2049#: reference_editor.xml:1219 2050#, no-c-format 2051msgid "" 2052"Changed: 2.1.0 As a result of the introduction of geography support: The " 2053"construct <code>SELECT ST_Segmentize('LINESTRING(1 2, 3 4)',0.5);</code> " 2054"will result in ambiguous function error. You need to have properly typed " 2055"object e.g. a geometry/geography column, use ST_GeomFromText, " 2056"ST_GeogFromText or <code>SELECT ST_Segmentize('LINESTRING(1 2, 3 4)'::" 2057"geometry,0.5);</code>" 2058msgstr "" 2059 2060#. Tag: para 2061#: reference_editor.xml:1221 2062#, no-c-format 2063msgid "" 2064"This will only increase segments. It will not lengthen segments shorter than " 2065"max length" 2066msgstr "" 2067 2068#. Tag: programlisting 2069#: reference_editor.xml:1228 2070#, no-c-format 2071msgid "" 2072"SELECT ST_AsText(ST_Segmentize(\n" 2073"ST_GeomFromText('MULTILINESTRING((-29 -27,-30 -29.7,-36 -31,-45 -33),(-45 " 2074"-33,-46 -32))')\n" 2075" ,5)\n" 2076");\n" 2077"st_astext\n" 2078"--------------------------------------------------------------------------------------------------\n" 2079"MULTILINESTRING((-29 -27,-30 -29.7,-34.886615700134 -30.758766735029,-36 " 2080"-31,\n" 2081"-40.8809353009198 -32.0846522890933,-45 -33),\n" 2082"(-45 -33,-46 -32))\n" 2083"(1 row)\n" 2084"\n" 2085"SELECT ST_AsText(ST_Segmentize(ST_GeomFromText('POLYGON((-29 28, -30 40, -29 " 2086"28))'),10));\n" 2087"st_astext\n" 2088"-----------------------\n" 2089"POLYGON((-29 28,-29.8304547985374 37.9654575824488,-30 40,-29.1695452014626 " 2090"30.0345424175512,-29 28))\n" 2091"(1 row)" 2092msgstr "" 2093 2094#. Tag: refname 2095#: reference_editor.xml:1238 2096#, no-c-format 2097msgid "ST_SetPoint" 2098msgstr "ST_SetPoint" 2099 2100#. Tag: refpurpose 2101#: reference_editor.xml:1239 2102#, no-c-format 2103msgid "Replace point of a linestring with a given point." 2104msgstr "" 2105 2106#. Tag: funcprototype 2107#: reference_editor.xml:1243 2108#, no-c-format 2109msgid "" 2110"<funcdef>geometry <function>ST_SetPoint</function></funcdef> " 2111"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 2112"<paramdef><type>integer</type> <parameter>zerobasedposition</parameter></" 2113"paramdef> <paramdef><type>geometry</type> <parameter>point</parameter></" 2114"paramdef>" 2115msgstr "" 2116"<funcdef>geometry <function>ST_SetPoint</function></funcdef> " 2117"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 2118"<paramdef><type>integer</type> <parameter>zerobasedposition</parameter></" 2119"paramdef> <paramdef><type>geometry</type> <parameter>point</parameter></" 2120"paramdef>" 2121 2122#. Tag: para 2123#: reference_editor.xml:1255 2124#, no-c-format 2125msgid "" 2126"Replace point N of linestring with given point. Index is 0-based.Negative " 2127"index are counted backwards, so that -1 is last point. This is especially " 2128"useful in triggers when trying to maintain relationship of joints when one " 2129"vertex moves." 2130msgstr "" 2131 2132#. Tag: para 2133#: reference_editor.xml:1259 2134#, no-c-format 2135msgid "Updated 2.3.0 : negative indexing" 2136msgstr "" 2137 2138#. Tag: programlisting 2139#: reference_editor.xml:1266 2140#, no-c-format 2141msgid "" 2142"--Change first point in line string from -1 3 to -1 1\n" 2143"SELECT ST_AsText(ST_SetPoint('LINESTRING(-1 2,-1 3)', 0, 'POINT(-1 1)'));\n" 2144" st_astext\n" 2145"-----------------------\n" 2146" LINESTRING(-1 1,-1 3)\n" 2147"\n" 2148"---Change last point in a line string (lets play with 3d linestring this " 2149"time)\n" 2150"SELECT ST_AsEWKT(ST_SetPoint(foo.the_geom, ST_NumPoints(foo.the_geom) - 1, " 2151"ST_GeomFromEWKT('POINT(-1 1 3)')))\n" 2152"FROM (SELECT ST_GeomFromEWKT('LINESTRING(-1 2 3,-1 3 4, 5 6 7)') As " 2153"the_geom) As foo;\n" 2154" st_asewkt\n" 2155"-----------------------\n" 2156"LINESTRING(-1 2 3,-1 3 4,-1 1 3)\n" 2157"\n" 2158"SELECT ST_AsText(ST_SetPoint(g, -3, p))\n" 2159"FROM ST_GEomFromText('LINESTRING(0 0, 1 1, 2 2, 3 3, 4 4)') AS g\n" 2160" , ST_PointN(g,1) as p;\n" 2161" st_astext\n" 2162"-----------------------\n" 2163"LINESTRING(0 0,1 1,0 0,3 3,4 4)" 2164msgstr "" 2165 2166#. Tag: para 2167#: reference_editor.xml:1270 2168#, no-c-format 2169msgid "" 2170", <xref linkend=\"ST_NPoints\"/>, <xref linkend=\"ST_NumPoints\"/>, <xref " 2171"linkend=\"ST_PointN\"/>, <xref linkend=\"ST_RemovePoint\"/>" 2172msgstr "" 2173", <xref linkend=\"ST_NPoints\"/>, <xref linkend=\"ST_NumPoints\"/>, <xref " 2174"linkend=\"ST_PointN\"/>, <xref linkend=\"ST_RemovePoint\"/>" 2175 2176#. Tag: refname 2177#: reference_editor.xml:1276 2178#, no-c-format 2179msgid "ST_ShiftLongitude" 2180msgstr "" 2181 2182#. Tag: refpurpose 2183#: reference_editor.xml:1278 2184#, no-c-format 2185msgid "" 2186"Shifts a geometry with geographic coordinates between -180..180 and 0..360." 2187msgstr "" 2188 2189#. Tag: funcprototype 2190#: reference_editor.xml:1283 2191#, fuzzy, no-c-format 2192msgid "" 2193"<funcdef>geometry <function>ST_ShiftLongitude</function></funcdef> " 2194"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 2195msgstr "" 2196"<funcdef>geometry <function>ST_Reverse</function></funcdef> " 2197"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 2198 2199#. Tag: para 2200#: reference_editor.xml:1293 2201#, no-c-format 2202msgid "" 2203"Reads every point/vertex in a geometry, and if the longitude coordinate is " 2204"<0, adds 360 to it. The result is a 0-360 version of the data to be " 2205"plotted in a 180 centric map" 2206msgstr "" 2207 2208#. Tag: para 2209#: reference_editor.xml:1296 2210#, no-c-format 2211msgid "" 2212"This is only useful for data with coordinates in longitude/latitude; e.g. " 2213"SRID 4326 (WGS 84 geographic)" 2214msgstr "" 2215 2216#. Tag: para 2217#: reference_editor.xml:1300 2218#, no-c-format 2219msgid "" 2220"Pre-1.3.4 bug prevented this from working for MULTIPOINT. 1.3.4+ works with " 2221"MULTIPOINT as well." 2222msgstr "" 2223 2224#. Tag: para 2225#: reference_editor.xml:1304 2226#, fuzzy, no-c-format 2227msgid "Enhanced: 2.0.0 support for Polyhedral surfaces and TIN was introduced." 2228msgstr "Ulepszenie: 2.0.0 wprowadzono wsparcie dla powierzchni wielościanowych" 2229 2230#. Tag: para 2231#: reference_editor.xml:1305 2232#, no-c-format 2233msgid "NOTE: this function was renamed from \"ST_Shift_Longitude\" in 2.2.0" 2234msgstr "" 2235 2236#. Tag: programlisting 2237#: reference_editor.xml:1314 2238#, no-c-format 2239msgid "" 2240"--3d points\n" 2241"SELECT ST_AsEWKT(ST_ShiftLongitude(ST_GeomFromEWKT('SRID=4326;POINT(-118.58 " 2242"38.38 10)'))) As geomA,\n" 2243" ST_AsEWKT(ST_ShiftLongitude(ST_GeomFromEWKT('SRID=4326;POINT(241.42 " 2244"38.38 10)'))) As geomb\n" 2245"geomA geomB\n" 2246"---------- -----------\n" 2247"SRID=4326;POINT(241.42 38.38 10) SRID=4326;POINT(-118.58 38.38 10)\n" 2248"\n" 2249"--regular line string\n" 2250"SELECT ST_AsText(ST_ShiftLongitude(ST_GeomFromText('LINESTRING(-118.58 " 2251"38.38, -118.20 38.45)')))\n" 2252"\n" 2253"st_astext\n" 2254"----------\n" 2255"LINESTRING(241.42 38.38,241.8 38.45)" 2256msgstr "" 2257 2258#. Tag: refname 2259#: reference_editor.xml:1328 2260#, no-c-format 2261msgid "ST_WrapX" 2262msgstr "" 2263 2264#. Tag: refpurpose 2265#: reference_editor.xml:1330 2266#, no-c-format 2267msgid "Wrap a geometry around an X value." 2268msgstr "" 2269 2270#. Tag: funcprototype 2271#: reference_editor.xml:1335 2272#, fuzzy, no-c-format 2273msgid "" 2274"<funcdef>geometry <function>ST_WrapX</function></funcdef> " 2275"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> " 2276"<paramdef><type>float8 </type> <parameter>wrap</parameter></paramdef> " 2277"<paramdef><type>float8 </type> <parameter>move</parameter></paramdef>" 2278msgstr "" 2279"<funcdef>geometry <function>ST_Snap</function></funcdef> " 2280"<paramdef><type>geometry </type> <parameter>input</parameter></paramdef> " 2281"<paramdef><type>geometry </type> <parameter>reference</parameter></paramdef> " 2282"<paramdef><type>float </type> <parameter>tolerance</parameter></paramdef>" 2283 2284#. Tag: para 2285#: reference_editor.xml:1347 2286#, no-c-format 2287msgid "" 2288"This function splits the input geometries and then moves every resulting " 2289"component falling on the right (for negative 'move') or on the left (for " 2290"positive 'move') of given 'wrap' line in the direction specified by the " 2291"'move' parameter, finally re-unioning the pieces togheter." 2292msgstr "" 2293 2294#. Tag: para 2295#: reference_editor.xml:1354 2296#, no-c-format 2297msgid "" 2298"This is useful to \"recenter\" long-lat input to have features of interest " 2299"not spawned from one side to the other." 2300msgstr "" 2301 2302#. Tag: para 2303#: reference_editor.xml:1359 2304#, fuzzy, no-c-format 2305msgid "Availability: 2.3.0 requires GEOS" 2306msgstr "Dostępność: 2.0.0 wymaga GEOS >= 3.3.0." 2307 2308#. Tag: programlisting 2309#: reference_editor.xml:1371 2310#, no-c-format 2311msgid "" 2312"-- Move all components of the given geometries whose bounding box\n" 2313"-- falls completely on the left of x=0 to +360\n" 2314"select ST_WrapX(the_geom, 0, 360);\n" 2315"\n" 2316"-- Move all components of the given geometries whose bounding box\n" 2317"-- falls completely on the left of x=-30 to +360\n" 2318"select ST_WrapX(the_geom, -30, 360);" 2319msgstr "" 2320 2321#. Tag: refname 2322#: reference_editor.xml:1383 2323#, no-c-format 2324msgid "ST_SnapToGrid" 2325msgstr "ST_SnapToGrid" 2326 2327#. Tag: refpurpose 2328#: reference_editor.xml:1385 2329#, no-c-format 2330msgid "Snap all points of the input geometry to a regular grid." 2331msgstr "" 2332 2333#. Tag: funcsynopsis 2334#: reference_editor.xml:1391 2335#, no-c-format 2336msgid "" 2337"<funcprototype> <funcdef>geometry <function>ST_SnapToGrid</function></" 2338"funcdef> <paramdef><type>geometry </type> <parameter>geomA</parameter></" 2339"paramdef> <paramdef><type>float </type> <parameter>originX</parameter></" 2340"paramdef> <paramdef><type>float </type> <parameter>originY</parameter></" 2341"paramdef> <paramdef><type>float </type> <parameter>sizeX</parameter></" 2342"paramdef> <paramdef><type>float </type> <parameter>sizeY</parameter></" 2343"paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2344"<function>ST_SnapToGrid</function></funcdef> <paramdef><type>geometry </" 2345"type> <parameter>geomA</parameter></paramdef> <paramdef><type>float </type> " 2346"<parameter>sizeX</parameter></paramdef> <paramdef><type>float </type> " 2347"<parameter>sizeY</parameter></paramdef> </funcprototype> <funcprototype> " 2348"<funcdef>geometry <function>ST_SnapToGrid</function></funcdef> " 2349"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 2350"<paramdef><type>float </type> <parameter>size</parameter></paramdef> </" 2351"funcprototype> <funcprototype> <funcdef>geometry <function>ST_SnapToGrid</" 2352"function></funcdef> <paramdef><type>geometry </type> <parameter>geomA</" 2353"parameter></paramdef> <paramdef><type>geometry </type> " 2354"<parameter>pointOrigin</parameter></paramdef> <paramdef><type>float </type> " 2355"<parameter>sizeX</parameter></paramdef> <paramdef><type>float </type> " 2356"<parameter>sizeY</parameter></paramdef> <paramdef><type>float </type> " 2357"<parameter>sizeZ</parameter></paramdef> <paramdef><type>float </type> " 2358"<parameter>sizeM</parameter></paramdef> </funcprototype>" 2359msgstr "" 2360"<funcprototype> <funcdef>geometry <function>ST_SnapToGrid</function></" 2361"funcdef> <paramdef><type>geometry </type> <parameter>geomA</parameter></" 2362"paramdef> <paramdef><type>float </type> <parameter>originX</parameter></" 2363"paramdef> <paramdef><type>float </type> <parameter>originY</parameter></" 2364"paramdef> <paramdef><type>float </type> <parameter>sizeX</parameter></" 2365"paramdef> <paramdef><type>float </type> <parameter>sizeY</parameter></" 2366"paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2367"<function>ST_SnapToGrid</function></funcdef> <paramdef><type>geometry </" 2368"type> <parameter>geomA</parameter></paramdef> <paramdef><type>float </type> " 2369"<parameter>sizeX</parameter></paramdef> <paramdef><type>float </type> " 2370"<parameter>sizeY</parameter></paramdef> </funcprototype> <funcprototype> " 2371"<funcdef>geometry <function>ST_SnapToGrid</function></funcdef> " 2372"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 2373"<paramdef><type>float </type> <parameter>size</parameter></paramdef> </" 2374"funcprototype> <funcprototype> <funcdef>geometry <function>ST_SnapToGrid</" 2375"function></funcdef> <paramdef><type>geometry </type> <parameter>geomA</" 2376"parameter></paramdef> <paramdef><type>geometry </type> " 2377"<parameter>pointOrigin</parameter></paramdef> <paramdef><type>float </type> " 2378"<parameter>sizeX</parameter></paramdef> <paramdef><type>float </type> " 2379"<parameter>sizeY</parameter></paramdef> <paramdef><type>float </type> " 2380"<parameter>sizeZ</parameter></paramdef> <paramdef><type>float </type> " 2381"<parameter>sizeM</parameter></paramdef> </funcprototype>" 2382 2383#. Tag: para 2384#: reference_editor.xml:1429 2385#, no-c-format 2386msgid "" 2387"Variant 1,2,3: Snap all points of the input geometry to the grid defined by " 2388"its origin and cell size. Remove consecutive points falling on the same " 2389"cell, eventually returning NULL if output points are not enough to define a " 2390"geometry of the given type. Collapsed geometries in a collection are " 2391"stripped from it. Useful for reducing precision." 2392msgstr "" 2393 2394#. Tag: para 2395#: reference_editor.xml:1437 2396#, no-c-format 2397msgid "" 2398"Variant 4: Introduced 1.1.0 - Snap all points of the input geometry to the " 2399"grid defined by its origin (the second argument, must be a point) and cell " 2400"sizes. Specify 0 as size for any dimension you don't want to snap to a grid." 2401msgstr "" 2402 2403#. Tag: para 2404#: reference_editor.xml:1443 2405#, no-c-format 2406msgid "" 2407"The returned geometry might lose its simplicity (see <xref linkend=" 2408"\"ST_IsSimple\"/>)." 2409msgstr "" 2410 2411#. Tag: para 2412#: reference_editor.xml:1448 2413#, no-c-format 2414msgid "" 2415"Before release 1.1.0 this function always returned a 2d geometry. Starting " 2416"at 1.1.0 the returned geometry will have same dimensionality as the input " 2417"one with higher dimension values untouched. Use the version taking a second " 2418"geometry argument to define all grid dimensions." 2419msgstr "" 2420 2421#. Tag: para 2422#: reference_editor.xml:1455 2423#, no-c-format 2424msgid "Availability: 1.0.0RC1" 2425msgstr "Dostępność: 1.0.0RC1" 2426 2427#. Tag: para 2428#: reference_editor.xml:1456 2429#, no-c-format 2430msgid "Availability: 1.1.0 - Z and M support" 2431msgstr "Dostępność: 1.1.0 - wsparcie dla Z i M" 2432 2433#. Tag: programlisting 2434#: reference_editor.xml:1465 2435#, no-c-format 2436msgid "" 2437"--Snap your geometries to a precision grid of 10^-3\n" 2438"UPDATE mytable\n" 2439" SET the_geom = ST_SnapToGrid(the_geom, 0.001);\n" 2440"\n" 2441"SELECT ST_AsText(ST_SnapToGrid(\n" 2442" ST_GeomFromText('LINESTRING(1.1115678 2.123, " 2443"4.111111 3.2374897, 4.11112 3.23748667)'),\n" 2444" 0.001)\n" 2445" );\n" 2446" st_astext\n" 2447"-------------------------------------\n" 2448" LINESTRING(1.112 2.123,4.111 3.237)\n" 2449" --Snap a 4d geometry\n" 2450"SELECT ST_AsEWKT(ST_SnapToGrid(\n" 2451" ST_GeomFromEWKT('LINESTRING(-1.1115678 2.123 2.3456 1.11111,\n" 2452" 4.111111 3.2374897 3.1234 1.1111, -1.11111112 2.123 2.3456 " 2453"1.1111112)'),\n" 2454" ST_GeomFromEWKT('POINT(1.12 2.22 3.2 4.4444)'),\n" 2455" 0.1, 0.1, 0.1, 0.01) );\n" 2456" st_asewkt\n" 2457"------------------------------------------------------------------------------\n" 2458" LINESTRING(-1.08 2.12 2.3 1.1144,4.12 3.22 3.1 1.1144,-1.08 2.12 2.3 " 2459"1.1144)\n" 2460"\n" 2461"\n" 2462"--With a 4d geometry - the ST_SnapToGrid(geom,size) only touches x and y " 2463"coords but keeps m and z the same\n" 2464"SELECT ST_AsEWKT(ST_SnapToGrid(ST_GeomFromEWKT('LINESTRING(-1.1115678 2.123 " 2465"3 2.3456,\n" 2466" 4.111111 3.2374897 3.1234 1.1111)'),\n" 2467" 0.01) );\n" 2468" st_asewkt\n" 2469"---------------------------------------------------------\n" 2470" LINESTRING(-1.11 2.12 3 2.3456,4.11 3.24 3.1234 1.1111)" 2471msgstr "" 2472 2473#. Tag: para 2474#: reference_editor.xml:1472 2475#, no-c-format 2476msgid "" 2477", <xref linkend=\"ST_AsEWKT\"/>, <xref linkend=\"ST_AsText\"/>, <xref " 2478"linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>, <xref " 2479"linkend=\"ST_Simplify\"/>" 2480msgstr "" 2481", <xref linkend=\"ST_AsEWKT\"/>, <xref linkend=\"ST_AsText\"/>, <xref " 2482"linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>, <xref " 2483"linkend=\"ST_Simplify\"/>" 2484 2485#. Tag: refname 2486#: reference_editor.xml:1485 2487#, no-c-format 2488msgid "ST_Snap" 2489msgstr "ST_Snap" 2490 2491#. Tag: refpurpose 2492#: reference_editor.xml:1487 2493#, no-c-format 2494msgid "" 2495"Snap segments and vertices of input geometry to vertices of a reference " 2496"geometry." 2497msgstr "" 2498 2499#. Tag: funcprototype 2500#: reference_editor.xml:1495 2501#, no-c-format 2502msgid "" 2503"<funcdef>geometry <function>ST_Snap</function></funcdef> " 2504"<paramdef><type>geometry </type> <parameter>input</parameter></paramdef> " 2505"<paramdef><type>geometry </type> <parameter>reference</parameter></paramdef> " 2506"<paramdef><type>float </type> <parameter>tolerance</parameter></paramdef>" 2507msgstr "" 2508"<funcdef>geometry <function>ST_Snap</function></funcdef> " 2509"<paramdef><type>geometry </type> <parameter>input</parameter></paramdef> " 2510"<paramdef><type>geometry </type> <parameter>reference</parameter></paramdef> " 2511"<paramdef><type>float </type> <parameter>tolerance</parameter></paramdef>" 2512 2513#. Tag: para 2514#: reference_editor.xml:1507 2515#, no-c-format 2516msgid "" 2517"Snaps the vertices and segments of a geometry to another Geometry's " 2518"vertices. A snap distance tolerance is used to control where snapping is " 2519"performed. The result geometry is the input geometry with the vertices " 2520"snapped. If no snapping occurs then the input geometry is returned unchanged." 2521msgstr "" 2522 2523#. Tag: para 2524#: reference_editor.xml:1514 2525#, no-c-format 2526msgid "" 2527"Snapping one geometry to another can improve robustness for overlay " 2528"operations by eliminating nearly-coincident edges (which cause problems " 2529"during noding and intersection calculation)." 2530msgstr "" 2531 2532#. Tag: para 2533#: reference_editor.xml:1521 2534#, no-c-format 2535msgid "" 2536"Too much snapping can result in invalid topology being created, so the " 2537"number and location of snapped vertices is decided using heuristics to " 2538"determine when it is safe to snap. This can result in some potential snaps " 2539"being omitted, however." 2540msgstr "" 2541 2542#. Tag: para 2543#: reference_editor.xml:1530 2544#, no-c-format 2545msgid "" 2546"The returned geometry might lose its simplicity (see <xref linkend=" 2547"\"ST_IsSimple\"/>) and validity (see <xref linkend=\"ST_IsValid\"/>)." 2548msgstr "" 2549 2550#. Tag: para 2551#: reference_editor.xml:1554 2552#, no-c-format 2553msgid "A multipolygon shown with a linestring (before any snapping)" 2554msgstr "" 2555 2556#. Tag: para 2557#: reference_editor.xml:1565 2558#, no-c-format 2559msgid "" 2560"A multipolygon snapped to linestring to tolerance: 1.01 of distance. The new " 2561"multipolygon is shown with reference linestring" 2562msgstr "" 2563 2564#. Tag: programlisting 2565#: reference_editor.xml:1569 2566#, no-c-format 2567msgid "" 2568"SELECT ST_AsText(ST_Snap(poly,line, ST_Distance(poly,line)*1.01)) AS " 2569"polysnapped\n" 2570"FROM (SELECT\n" 2571" ST_GeomFromText('MULTIPOLYGON(\n" 2572" ((26 125, 26 200, 126 200, 126 125, 26 125 ),\n" 2573" ( 51 150, 101 150, 76 175, 51 150 )),\n" 2574" (( 151 100, 151 200, 176 175, 151 100 )))') As poly,\n" 2575" ST_GeomFromText('LINESTRING (5 107, 54 84, 101 100)') As line\n" 2576" ) As foo;\n" 2577"\n" 2578" polysnapped\n" 2579"---------------------------------------------------------------------\n" 2580" MULTIPOLYGON(((26 125,26 200,126 200,126 125,101 100,26 125),\n" 2581" (51 150,101 150,76 175,51 150)),((151 100,151 200,176 175,151 100)))" 2582msgstr "" 2583 2584#. Tag: para 2585#: reference_editor.xml:1576 2586#, no-c-format 2587msgid "" 2588"A multipolygon snapped to linestring to tolerance: 1.25 of distance. The new " 2589"multipolygon is shown with reference linestring" 2590msgstr "" 2591 2592#. Tag: programlisting 2593#: reference_editor.xml:1580 2594#, no-c-format 2595msgid "" 2596"SELECT ST_AsText(\n" 2597" ST_Snap(poly,line, ST_Distance(poly,line)*1.25)\n" 2598" ) AS polysnapped\n" 2599"FROM (SELECT\n" 2600" ST_GeomFromText('MULTIPOLYGON(\n" 2601" (( 26 125, 26 200, 126 200, 126 125, 26 125 ),\n" 2602" ( 51 150, 101 150, 76 175, 51 150 )),\n" 2603" (( 151 100, 151 200, 176 175, 151 100 )))') As poly,\n" 2604" ST_GeomFromText('LINESTRING (5 107, 54 84, 101 100)') As line\n" 2605" ) As foo;\n" 2606"\n" 2607" polysnapped\n" 2608"---------------------------------------------------------------------\n" 2609"MULTIPOLYGON(((5 107,26 200,126 200,126 125,101 100,54 84,5 107),\n" 2610"(51 150,101 150,76 175,51 150)),((151 100,151 200,176 175,151 100)))" 2611msgstr "" 2612 2613#. Tag: para 2614#: reference_editor.xml:1589 2615#, no-c-format 2616msgid "" 2617"The linestring snapped to the original multipolygon at tolerance 1.01 of " 2618"distance. The new linestring is shown with reference multipolygon" 2619msgstr "" 2620 2621#. Tag: programlisting 2622#: reference_editor.xml:1593 2623#, no-c-format 2624msgid "" 2625"SELECT ST_AsText(\n" 2626" ST_Snap(line, poly, ST_Distance(poly,line)*1.01)\n" 2627" ) AS linesnapped\n" 2628"FROM (SELECT\n" 2629" ST_GeomFromText('MULTIPOLYGON(\n" 2630" ((26 125, 26 200, 126 200, 126 125, 26 125),\n" 2631" (51 150, 101 150, 76 175, 51 150 )),\n" 2632" ((151 100, 151 200, 176 175, 151 100)))') As poly,\n" 2633" ST_GeomFromText('LINESTRING (5 107, 54 84, 101 100)') As line\n" 2634" ) As foo;\n" 2635"\n" 2636" linesnapped\n" 2637"----------------------------------------\n" 2638" LINESTRING(5 107,26 125,54 84,101 100)" 2639msgstr "" 2640 2641#. Tag: para 2642#: reference_editor.xml:1601 2643#, no-c-format 2644msgid "" 2645"The linestring snapped to the original multipolygon at tolerance 1.25 of " 2646"distance. The new linestring is shown with reference multipolygon" 2647msgstr "" 2648 2649#. Tag: programlisting 2650#: reference_editor.xml:1605 2651#, no-c-format 2652msgid "" 2653"SELECT ST_AsText(\n" 2654" ST_Snap(line, poly, ST_Distance(poly,line)*1.25)\n" 2655" ) AS linesnapped\n" 2656"FROM (SELECT\n" 2657" ST_GeomFromText('MULTIPOLYGON(\n" 2658" (( 26 125, 26 200, 126 200, 126 125, 26 125 ),\n" 2659" (51 150, 101 150, 76 175, 51 150 )),\n" 2660" ((151 100, 151 200, 176 175, 151 100 )))') As poly,\n" 2661" ST_GeomFromText('LINESTRING (5 107, 54 84, 101 100)') As line\n" 2662" ) As foo;\n" 2663" linesnapped\n" 2664"---------------------------------------\n" 2665"LINESTRING(26 125,54 84,101 100)" 2666msgstr "" 2667 2668#. Tag: refname 2669#: reference_editor.xml:1626 2670#, no-c-format 2671msgid "ST_SwapOrdinates" 2672msgstr "" 2673 2674#. Tag: refpurpose 2675#: reference_editor.xml:1627 2676#, no-c-format 2677msgid "" 2678"Returns a version of the given geometry with given ordinate values swapped." 2679msgstr "" 2680 2681#. Tag: funcprototype 2682#: reference_editor.xml:1634 2683#, fuzzy, no-c-format 2684msgid "" 2685"<funcdef>geometry <function>ST_SwapOrdinates</function></funcdef> " 2686"<paramdef><type>geometry</type> <parameter>geom</parameter></paramdef> " 2687"<paramdef><type>cstring</type> <parameter>ords</parameter></paramdef>" 2688msgstr "" 2689"<funcdef>geometry <function>ST_SetSRID</function></funcdef> " 2690"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> " 2691"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef>" 2692 2693#. Tag: para 2694#: reference_editor.xml:1644 2695#, no-c-format 2696msgid "Returns a version of the given geometry with given ordinates swapped." 2697msgstr "" 2698 2699#. Tag: para 2700#: reference_editor.xml:1647 2701#, no-c-format 2702msgid "" 2703"The <varname>ords</varname> parameter is a 2-characters string naming the " 2704"ordinates to swap. Valid names are: x,y,z and m." 2705msgstr "" 2706 2707#. Tag: programlisting 2708#: reference_editor.xml:1661 2709#, no-c-format 2710msgid "" 2711"<![CDATA[\n" 2712"-- Scale M value by 2\n" 2713"SELECT ST_AsText(\n" 2714" ST_SwapOrdinates(\n" 2715" ST_Scale(\n" 2716" ST_SwapOrdinates(g,'xm'),\n" 2717" 2, 1\n" 2718" ),\n" 2719" 'xm')\n" 2720") FROM ( SELECT 'POINT ZM (0 0 0 2)'::geometry g ) foo;\n" 2721" st_astext\n" 2722"--------------------\n" 2723" POINT ZM (0 0 0 4)\n" 2724" ]]>" 2725msgstr "" 2726 2727#~ msgid "ST_Affine" 2728#~ msgstr "ST_Affine" 2729 2730#~ msgid "" 2731#~ "<funcprototype> <funcdef>geometry <function>ST_Affine</function></" 2732#~ "funcdef> <paramdef><type>geometry </type> <parameter>geomA</parameter></" 2733#~ "paramdef> <paramdef><type>float </type> <parameter>a</parameter></" 2734#~ "paramdef> <paramdef><type>float </type> <parameter>b</parameter></" 2735#~ "paramdef> <paramdef><type>float </type> <parameter>c</parameter></" 2736#~ "paramdef> <paramdef><type>float </type> <parameter>d</parameter></" 2737#~ "paramdef> <paramdef><type>float </type> <parameter>e</parameter></" 2738#~ "paramdef> <paramdef><type>float </type> <parameter>f</parameter></" 2739#~ "paramdef> <paramdef><type>float </type> <parameter>g</parameter></" 2740#~ "paramdef> <paramdef><type>float </type> <parameter>h</parameter></" 2741#~ "paramdef> <paramdef><type>float </type> <parameter>i</parameter></" 2742#~ "paramdef> <paramdef><type>float </type> <parameter>xoff</parameter></" 2743#~ "paramdef> <paramdef><type>float </type> <parameter>yoff</parameter></" 2744#~ "paramdef> <paramdef><type>float </type> <parameter>zoff</parameter></" 2745#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2746#~ "<function>ST_Affine</function></funcdef> <paramdef><type>geometry </type> " 2747#~ "<parameter>geomA</parameter></paramdef> <paramdef><type>float </type> " 2748#~ "<parameter>a</parameter></paramdef> <paramdef><type>float </type> " 2749#~ "<parameter>b</parameter></paramdef> <paramdef><type>float </type> " 2750#~ "<parameter>d</parameter></paramdef> <paramdef><type>float </type> " 2751#~ "<parameter>e</parameter></paramdef> <paramdef><type>float </type> " 2752#~ "<parameter>xoff</parameter></paramdef> <paramdef><type>float </type> " 2753#~ "<parameter>yoff</parameter></paramdef> </funcprototype>" 2754#~ msgstr "" 2755#~ "<funcprototype> <funcdef>geometry <function>ST_Affine</function></" 2756#~ "funcdef> <paramdef><type>geometry </type> <parameter>geomA</parameter></" 2757#~ "paramdef> <paramdef><type>float </type> <parameter>a</parameter></" 2758#~ "paramdef> <paramdef><type>float </type> <parameter>b</parameter></" 2759#~ "paramdef> <paramdef><type>float </type> <parameter>c</parameter></" 2760#~ "paramdef> <paramdef><type>float </type> <parameter>d</parameter></" 2761#~ "paramdef> <paramdef><type>float </type> <parameter>e</parameter></" 2762#~ "paramdef> <paramdef><type>float </type> <parameter>f</parameter></" 2763#~ "paramdef> <paramdef><type>float </type> <parameter>g</parameter></" 2764#~ "paramdef> <paramdef><type>float </type> <parameter>h</parameter></" 2765#~ "paramdef> <paramdef><type>float </type> <parameter>i</parameter></" 2766#~ "paramdef> <paramdef><type>float </type> <parameter>xoff</parameter></" 2767#~ "paramdef> <paramdef><type>float </type> <parameter>yoff</parameter></" 2768#~ "paramdef> <paramdef><type>float </type> <parameter>zoff</parameter></" 2769#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2770#~ "<function>ST_Affine</function></funcdef> <paramdef><type>geometry </type> " 2771#~ "<parameter>geomA</parameter></paramdef> <paramdef><type>float </type> " 2772#~ "<parameter>a</parameter></paramdef> <paramdef><type>float </type> " 2773#~ "<parameter>b</parameter></paramdef> <paramdef><type>float </type> " 2774#~ "<parameter>d</parameter></paramdef> <paramdef><type>float </type> " 2775#~ "<parameter>e</parameter></paramdef> <paramdef><type>float </type> " 2776#~ "<parameter>xoff</parameter></paramdef> <paramdef><type>float </type> " 2777#~ "<parameter>yoff</parameter></paramdef> </funcprototype>" 2778 2779#~ msgid "Availability: 1.1.2. Name changed from Affine to ST_Affine in 1.2.2" 2780#~ msgstr "" 2781#~ "Dostępność: 1.1.2. Nazwa zmieniona z Affine na ST_Affine w wersji 1.2.2" 2782 2783#~ msgid "" 2784#~ ", <xref linkend=\"ST_Scale\"/>, <xref linkend=\"ST_Translate\"/>, <xref " 2785#~ "linkend=\"ST_TransScale\"/>" 2786#~ msgstr "" 2787#~ ", <xref linkend=\"ST_Scale\"/>, <xref linkend=\"ST_Translate\"/>, <xref " 2788#~ "linkend=\"ST_TransScale\"/>" 2789 2790#~ msgid "requires GEOS >= 2.1.0" 2791#~ msgstr "wymaga GEOS >= 2.1.0" 2792 2793#~ msgid "ST_Rotate" 2794#~ msgstr "ST_Rotate" 2795 2796#~ msgid "" 2797#~ "<funcprototype> <funcdef>geometry <function>ST_Rotate</function></" 2798#~ "funcdef> <paramdef><type>geometry</type> <parameter>geomA</parameter></" 2799#~ "paramdef> <paramdef><type>float</type> <parameter>rotRadians</parameter></" 2800#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2801#~ "<function>ST_Rotate</function></funcdef> <paramdef><type>geometry</type> " 2802#~ "<parameter>geomA</parameter></paramdef> <paramdef><type>float</type> " 2803#~ "<parameter>rotRadians</parameter></paramdef> <paramdef><type>float</type> " 2804#~ "<parameter>x0</parameter></paramdef> <paramdef><type>float</type> " 2805#~ "<parameter>y0</parameter></paramdef> </funcprototype> <funcprototype> " 2806#~ "<funcdef>geometry <function>ST_Rotate</function></funcdef> " 2807#~ "<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 2808#~ "<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef> " 2809#~ "<paramdef><type>geometry</type> <parameter>pointOrigin</parameter></" 2810#~ "paramdef> </funcprototype>" 2811#~ msgstr "" 2812#~ "<funcprototype> <funcdef>geometry <function>ST_Rotate</function></" 2813#~ "funcdef> <paramdef><type>geometry</type> <parameter>geomA</parameter></" 2814#~ "paramdef> <paramdef><type>float</type> <parameter>rotRadians</parameter></" 2815#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2816#~ "<function>ST_Rotate</function></funcdef> <paramdef><type>geometry</type> " 2817#~ "<parameter>geomA</parameter></paramdef> <paramdef><type>float</type> " 2818#~ "<parameter>rotRadians</parameter></paramdef> <paramdef><type>float</type> " 2819#~ "<parameter>x0</parameter></paramdef> <paramdef><type>float</type> " 2820#~ "<parameter>y0</parameter></paramdef> </funcprototype> <funcprototype> " 2821#~ "<funcdef>geometry <function>ST_Rotate</function></funcdef> " 2822#~ "<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 2823#~ "<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef> " 2824#~ "<paramdef><type>geometry</type> <parameter>pointOrigin</parameter></" 2825#~ "paramdef> </funcprototype>" 2826 2827#~ msgid "Availability: 1.1.2. Name changed from Rotate to ST_Rotate in 1.2.2" 2828#~ msgstr "" 2829#~ "Dostępność: 1.1.2. Nazwę zmieniono z Rotate na ST_Rotate w wersji 1.2.2" 2830 2831#~ msgid "" 2832#~ ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateY\"/>, <xref " 2833#~ "linkend=\"ST_RotateZ\"/>" 2834#~ msgstr "" 2835#~ ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateY\"/>, <xref " 2836#~ "linkend=\"ST_RotateZ\"/>" 2837 2838#~ msgid "ST_RotateX" 2839#~ msgstr "ST_RotateX" 2840 2841#~ msgid "" 2842#~ "Availability: 1.1.2. Name changed from RotateX to ST_RotateX in 1.2.2" 2843#~ msgstr "" 2844#~ "Dostępność: 1.1.2. Nazwa zmieniona z RotateX na ST_RotateX w wersji 1.2.2" 2845 2846#~ msgid ", <xref linkend=\"ST_RotateY\"/>, <xref linkend=\"ST_RotateZ\"/>" 2847#~ msgstr ", <xref linkend=\"ST_RotateY\"/>, <xref linkend=\"ST_RotateZ\"/>" 2848 2849#~ msgid "ST_RotateY" 2850#~ msgstr "ST_RotateY" 2851 2852#~ msgid "" 2853#~ "Availability: 1.1.2. Name changed from RotateY to ST_RotateY in 1.2.2" 2854#~ msgstr "" 2855#~ "Dostępność: 1.1.2. Nazwa zmieniona z RotateY na ST_RotateY w wersji 1.2.2" 2856 2857#~ msgid ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateZ\"/>" 2858#~ msgstr ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateZ\"/>" 2859 2860#~ msgid "ST_RotateZ" 2861#~ msgstr "ST_RotateZ" 2862 2863#~ msgid "" 2864#~ "<code>ST_RotateZ(geomA, rotRadians)</code> is short-hand for <code>SELECT " 2865#~ "ST_Affine(geomA, cos(rotRadians), -sin(rotRadians), 0, sin(rotRadians), " 2866#~ "cos(rotRadians), 0, 0, 0, 1, 0, 0, 0)</code>." 2867#~ msgstr "" 2868#~ "<code>ST_RotateZ(geomA, rotRadians)</code> is short-hand for <code>SELECT " 2869#~ "ST_Affine(geomA, cos(rotRadians), -sin(rotRadians), 0, sin(rotRadians), " 2870#~ "cos(rotRadians), 0, 0, 0, 1, 0, 0, 0)</code>." 2871 2872#~ msgid "" 2873#~ "Availability: 1.1.2. Name changed from RotateZ to ST_RotateZ in 1.2.2" 2874#~ msgstr "" 2875#~ "Dostępność: 1.1.2. Nazwa zmieniona z RotateZ na ST_RotateZ w wersji 1.2.2" 2876 2877#~ msgid ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateY\"/>" 2878#~ msgstr ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateY\"/>" 2879 2880#~ msgid "ST_Scale" 2881#~ msgstr "ST_Scale" 2882 2883#~ msgid "Availability: 1.1.0." 2884#~ msgstr "Dostępność: 1.1.0" 2885 2886#~ msgid ", <xref linkend=\"ST_TransScale\"/>" 2887#~ msgstr ", <xref linkend=\"ST_TransScale\"/>" 2888 2889#~ msgid "ST_SetSRID" 2890#~ msgstr "ST_SetSRID" 2891 2892#~ msgid "" 2893#~ "SELECT ST_SetSRID(ST_Point(-123.365556, 48.428611),4326) As " 2894#~ "wgs84long_lat;\n" 2895#~ "-- the ewkt representation (wrap with ST_AsEWKT) -\n" 2896#~ "SRID=4326;POINT(-123.365556 48.428611)" 2897#~ msgstr "" 2898#~ "SELECT ST_SetSRID(ST_Point(-123.365556, 48.428611),4326) As " 2899#~ "wgs84long_lat;\n" 2900#~ "-- the ewkt representation (wrap with ST_AsEWKT) -\n" 2901#~ "SRID=4326;POINT(-123.365556 48.428611)" 2902 2903#~ msgid "" 2904#~ ", <xref linkend=\"ST_AsEWKT\"/>, <xref linkend=\"ST_Point\"/>, <xref " 2905#~ "linkend=\"ST_SRID\"/>, <xref linkend=\"ST_Transform\"/>, <xref linkend=" 2906#~ "\"UpdateGeometrySRID\"/>" 2907#~ msgstr "" 2908#~ ", <xref linkend=\"ST_AsEWKT\"/>, <xref linkend=\"ST_Point\"/>, <xref " 2909#~ "linkend=\"ST_SRID\"/>, <xref linkend=\"ST_Transform\"/>, <xref linkend=" 2910#~ "\"UpdateGeometrySRID\"/>" 2911 2912#~ msgid "ST_Transform" 2913#~ msgstr "ST_Transform" 2914 2915#~ msgid "" 2916#~ "CREATE INDEX idx_the_geom_26986_parcels\n" 2917#~ " ON parcels\n" 2918#~ " USING gist\n" 2919#~ " (ST_Transform(the_geom, 26986))\n" 2920#~ " WHERE the_geom IS NOT NULL;" 2921#~ msgstr "" 2922#~ "CREATE INDEX idx_the_geom_26986_parcels\n" 2923#~ " ON parcels\n" 2924#~ " USING gist\n" 2925#~ " (ST_Transform(the_geom, 26986))\n" 2926#~ " WHERE the_geom IS NOT NULL;" 2927 2928#~ msgid "+nadgrids=@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat" 2929#~ msgstr "+nadgrids=@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat" 2930 2931#~ msgid "+nadgrids=@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat,null" 2932#~ msgstr "+nadgrids=@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat,null" 2933 2934#~ msgid "" 2935#~ "UPDATE spatial_ref_sys SET proj4text = '+proj=longlat +ellps=clrk66 " 2936#~ "+nadgrids=@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat,null +no_defs' WHERE " 2937#~ "srid = 4267;" 2938#~ msgstr "" 2939#~ "UPDATE spatial_ref_sys SET proj4text = '+proj=longlat +ellps=clrk66 " 2940#~ "+nadgrids=@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat,null +no_defs' WHERE " 2941#~ "srid = 4267;" 2942 2943#~ msgid "" 2944#~ ", <xref linkend=\"ST_AsText\"/>, <xref linkend=\"ST_SetSRID\"/>, <xref " 2945#~ "linkend=\"UpdateGeometrySRID\"/>" 2946#~ msgstr "" 2947#~ ", <xref linkend=\"ST_AsText\"/>, <xref linkend=\"ST_SetSRID\"/>, <xref " 2948#~ "linkend=\"UpdateGeometrySRID\"/>" 2949 2950#~ msgid "ST_Translate" 2951#~ msgstr "ST_Translate" 2952 2953#~ msgid "" 2954#~ "<funcprototype> <funcdef>geometry <function>ST_Translate</function></" 2955#~ "funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></" 2956#~ "paramdef> <paramdef><type>float </type> <parameter>deltax</parameter></" 2957#~ "paramdef> <paramdef><type>float </type> <parameter>deltay</parameter></" 2958#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2959#~ "<function>ST_Translate</function></funcdef> <paramdef><type>geometry </" 2960#~ "type> <parameter>g1</parameter></paramdef> <paramdef><type>float </type> " 2961#~ "<parameter>deltax</parameter></paramdef> <paramdef><type>float </type> " 2962#~ "<parameter>deltay</parameter></paramdef> <paramdef><type>float </type> " 2963#~ "<parameter>deltaz</parameter></paramdef> </funcprototype>" 2964#~ msgstr "" 2965#~ "<funcprototype> <funcdef>geometry <function>ST_Translate</function></" 2966#~ "funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></" 2967#~ "paramdef> <paramdef><type>float </type> <parameter>deltax</parameter></" 2968#~ "paramdef> <paramdef><type>float </type> <parameter>deltay</parameter></" 2969#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2970#~ "<function>ST_Translate</function></funcdef> <paramdef><type>geometry </" 2971#~ "type> <parameter>g1</parameter></paramdef> <paramdef><type>float </type> " 2972#~ "<parameter>deltax</parameter></paramdef> <paramdef><type>float </type> " 2973#~ "<parameter>deltay</parameter></paramdef> <paramdef><type>float </type> " 2974#~ "<parameter>deltaz</parameter></paramdef> </funcprototype>" 2975 2976#~ msgid "" 2977#~ "SELECT ST_AsText(ST_Translate(ST_GeomFromText('POINT(-71.01 " 2978#~ "42.37)',4326),1,0)) As wgs_transgeomtxt;\n" 2979#~ "\n" 2980#~ " wgs_transgeomtxt\n" 2981#~ " ---------------------\n" 2982#~ " POINT(-70.01 42.37)" 2983#~ msgstr "" 2984#~ "SELECT ST_AsText(ST_Translate(ST_GeomFromText('POINT(-71.01 " 2985#~ "42.37)',4326),1,0)) As wgs_transgeomtxt;\n" 2986#~ "\n" 2987#~ " wgs_transgeomtxt\n" 2988#~ " ---------------------\n" 2989#~ " POINT(-70.01 42.37)" 2990 2991#~ msgid "" 2992#~ "SELECT ST_AsText(ST_Translate(ST_GeomFromText('LINESTRING(-71.01 " 2993#~ "42.37,-71.11 42.38)',4326),1,0.5)) As wgs_transgeomtxt;\n" 2994#~ " wgs_transgeomtxt\n" 2995#~ " ---------------------------------------\n" 2996#~ " LINESTRING(-70.01 42.87,-70.11 42.88)" 2997#~ msgstr "" 2998#~ "SELECT ST_AsText(ST_Translate(ST_GeomFromText('LINESTRING(-71.01 " 2999#~ "42.37,-71.11 42.38)',4326),1,0.5)) As wgs_transgeomtxt;\n" 3000#~ " wgs_transgeomtxt\n" 3001#~ " ---------------------------------------\n" 3002#~ " LINESTRING(-70.01 42.87,-70.11 42.88)" 3003 3004#~ msgid "Move a 3d point" 3005#~ msgstr "Przesuń punkt 3d" 3006 3007#~ msgid "" 3008#~ "SELECT ST_AsEWKT(ST_Translate(CAST('POINT(0 0 0)' As geometry), 5, " 3009#~ "12,3));\n" 3010#~ " st_asewkt\n" 3011#~ " ---------\n" 3012#~ " POINT(5 12 3)" 3013#~ msgstr "" 3014#~ "SELECT ST_AsEWKT(ST_Translate(CAST('POINT(0 0 0)' As geometry), 5, " 3015#~ "12,3));\n" 3016#~ " st_asewkt\n" 3017#~ " ---------\n" 3018#~ " POINT(5 12 3)" 3019 3020#~ msgid "" 3021#~ "SELECT ST_AsText(ST_Translate(ST_Collect('CURVEPOLYGON(CIRCULARSTRING(4 " 3022#~ "3,3.12 0.878,1 0,-1.121 5.1213,6 7, 8 9,4 3))','POINT(1 3)'),1,2));\n" 3023#~ " st_astext\n" 3024#~ "------------------------------------------------------------------------------------------------------------\n" 3025#~ " GEOMETRYCOLLECTION(CURVEPOLYGON(CIRCULARSTRING(5 5,4.12 2.878,2 2,-0.121 " 3026#~ "7.1213,7 9,9 11,5 5)),POINT(2 5))" 3027#~ msgstr "" 3028#~ "SELECT ST_AsText(ST_Translate(ST_Collect('CURVEPOLYGON(CIRCULARSTRING(4 " 3029#~ "3,3.12 0.878,1 0,-1.121 5.1213,6 7, 8 9,4 3))','POINT(1 3)'),1,2));\n" 3030#~ " st_astext\n" 3031#~ "------------------------------------------------------------------------------------------------------------\n" 3032#~ " GEOMETRYCOLLECTION(CURVEPOLYGON(CIRCULARSTRING(5 5,4.12 2.878,2 2,-0.121 " 3033#~ "7.1213,7 9,9 11,5 5)),POINT(2 5))" 3034 3035#~ msgid ", <xref linkend=\"ST_AsText\"/>, <xref linkend=\"ST_GeomFromText\"/>" 3036#~ msgstr "" 3037#~ ", <xref linkend=\"ST_AsText\"/>, <xref linkend=\"ST_GeomFromText\"/>" 3038 3039#~ msgid "ST_TransScale" 3040#~ msgstr "ST_TransScale" 3041 3042#~ msgid ", <xref linkend=\"ST_Translate\"/>" 3043#~ msgstr ", <xref linkend=\"ST_Translate\"/>" 3044