1# SOME DESCRIPTIVE TITLE. 2# FIRST AUTHOR <EMAIL@ADDRESS>, YEAR. 3# 4#, fuzzy 5msgid "" 6msgstr "" 7"Project-Id-Version: PACKAGE VERSION\n" 8"Report-Msgid-Bugs-To: http://bugs.kde.org\n" 9"POT-Creation-Date: 2019-10-06 23:49+0000\n" 10"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n" 11"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n" 12"Language-Team: LANGUAGE <kde-i18n-doc@kde.org>\n" 13"Language: \n" 14"MIME-Version: 1.0\n" 15"Content-Type: text/plain; charset=UTF-8\n" 16"Content-Transfer-Encoding: 8bit\n" 17 18#. Tag: para 19#: reference_transformation.xml:5 20#, no-c-format 21msgid "" 22"These functions change the position and shape of geometries using <ulink url=" 23"\"https://en.wikipedia.org/wiki/Affine_transformation\">affine " 24"transformations</ulink>." 25msgstr "" 26 27#. Tag: title 28#: reference_transformation.xml:10 29#, no-c-format 30msgid "Affine Transformations" 31msgstr "" 32 33#. Tag: refname 34#: reference_transformation.xml:14 35#, no-c-format 36msgid "ST_Affine" 37msgstr "" 38 39#. Tag: refpurpose 40#: reference_transformation.xml:16 41#, no-c-format 42msgid "Apply a 3D affine transformation to a geometry." 43msgstr "" 44 45#. Tag: funcsynopsis 46#: reference_transformation.xml:20 47#, no-c-format 48msgid "" 49"<funcprototype> <funcdef>geometry <function>ST_Affine</function></funcdef> " 50"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 51"<paramdef><type>float </type> <parameter>a</parameter></paramdef> " 52"<paramdef><type>float </type> <parameter>b</parameter></paramdef> " 53"<paramdef><type>float </type> <parameter>c</parameter></paramdef> " 54"<paramdef><type>float </type> <parameter>d</parameter></paramdef> " 55"<paramdef><type>float </type> <parameter>e</parameter></paramdef> " 56"<paramdef><type>float </type> <parameter>f</parameter></paramdef> " 57"<paramdef><type>float </type> <parameter>g</parameter></paramdef> " 58"<paramdef><type>float </type> <parameter>h</parameter></paramdef> " 59"<paramdef><type>float </type> <parameter>i</parameter></paramdef> " 60"<paramdef><type>float </type> <parameter>xoff</parameter></paramdef> " 61"<paramdef><type>float </type> <parameter>yoff</parameter></paramdef> " 62"<paramdef><type>float </type> <parameter>zoff</parameter></paramdef> </" 63"funcprototype> <funcprototype> <funcdef>geometry <function>ST_Affine</" 64"function></funcdef> <paramdef><type>geometry </type> <parameter>geomA</" 65"parameter></paramdef> <paramdef><type>float </type> <parameter>a</" 66"parameter></paramdef> <paramdef><type>float </type> <parameter>b</" 67"parameter></paramdef> <paramdef><type>float </type> <parameter>d</" 68"parameter></paramdef> <paramdef><type>float </type> <parameter>e</" 69"parameter></paramdef> <paramdef><type>float </type> <parameter>xoff</" 70"parameter></paramdef> <paramdef><type>float </type> <parameter>yoff</" 71"parameter></paramdef> </funcprototype>" 72msgstr "" 73 74#. Tag: title 75#: reference_transformation.xml:52 reference_transformation.xml:127 76#: reference_transformation.xml:176 reference_transformation.xml:223 77#: reference_transformation.xml:272 reference_transformation.xml:348 78#: reference_transformation.xml:419 reference_transformation.xml:471 79#, no-c-format 80msgid "Description" 81msgstr "" 82 83#. Tag: para 84#: reference_transformation.xml:54 85#, no-c-format 86msgid "" 87"Applies a 3D affine transformation to the geometry to do things like " 88"translate, rotate, scale in one step." 89msgstr "" 90 91#. Tag: para 92#: reference_transformation.xml:55 93#, no-c-format 94msgid "" 95"Version 1: The call <programlisting>ST_Affine(geom, a, b, c, d, e, f, g, h, " 96"i, xoff, yoff, zoff) </programlisting> represents the transformation matrix " 97"<programlisting>/ a b c xoff \\\n" 98"| d e f yoff |\n" 99"| g h i zoff |\n" 100"\\ 0 0 0 1 /</programlisting> and the vertices are transformed as " 101"follows: <programlisting>x' = a*x + b*y + c*z + xoff\n" 102"y' = d*x + e*y + f*z + yoff\n" 103"z' = g*x + h*y + i*z + zoff</programlisting> All of the translate / scale " 104"functions below are expressed via such an affine transformation." 105msgstr "" 106 107#. Tag: para 108#: reference_transformation.xml:62 109#, no-c-format 110msgid "" 111"Version 2: Applies a 2d affine transformation to the geometry. The call " 112"<programlisting>ST_Affine(geom, a, b, d, e, xoff, yoff)</programlisting> " 113"represents the transformation matrix <programlisting>/ a b 0 xoff " 114"\\ / a b xoff \\\n" 115"| d e 0 yoff | rsp. | d e yoff |\n" 116"| 0 0 1 0 | \\ 0 0 1 /\n" 117"\\ 0 0 0 1 /</programlisting> and the vertices are transformed as " 118"follows: <programlisting>x' = a*x + b*y + xoff\n" 119"y' = d*x + e*y + yoff\n" 120"z' = z </programlisting> This method is a subcase of the 3D method above." 121msgstr "" 122 123#. Tag: para 124#: reference_transformation.xml:68 reference_transformation.xml:133 125#: reference_transformation.xml:183 reference_transformation.xml:231 126#: reference_transformation.xml:280 reference_transformation.xml:368 127#, no-c-format 128msgid "" 129"Enhanced: 2.0.0 support for Polyhedral surfaces, Triangles and TIN was " 130"introduced." 131msgstr "" 132 133#. Tag: para 134#: reference_transformation.xml:69 135#, no-c-format 136msgid "Availability: 1.1.2. Name changed from Affine to ST_Affine in 1.2.2" 137msgstr "" 138 139#. Tag: para 140#: reference_transformation.xml:70 reference_transformation.xml:283 141#: reference_transformation.xml:364 reference_transformation.xml:424 142#: reference_transformation.xml:480 143#, no-c-format 144msgid "" 145"Prior to 1.3.4, this function crashes if used with geometries that contain " 146"CURVES. This is fixed in 1.3.4+" 147msgstr "" 148 149#. Tag: para 150#: reference_transformation.xml:72 reference_transformation.xml:138 151#: reference_transformation.xml:185 reference_transformation.xml:233 152#: reference_transformation.xml:287 reference_transformation.xml:371 153#, no-c-format 154msgid "&P_support;" 155msgstr "" 156 157#. Tag: para 158#: reference_transformation.xml:73 reference_transformation.xml:139 159#: reference_transformation.xml:187 reference_transformation.xml:235 160#: reference_transformation.xml:288 reference_transformation.xml:374 161#, no-c-format 162msgid "&T_support;" 163msgstr "" 164 165#. Tag: para 166#: reference_transformation.xml:74 reference_transformation.xml:136 167#: reference_transformation.xml:186 reference_transformation.xml:234 168#: reference_transformation.xml:285 reference_transformation.xml:372 169#: reference_transformation.xml:427 reference_transformation.xml:484 170#, no-c-format 171msgid "&Z_support;" 172msgstr "" 173 174#. Tag: para 175#: reference_transformation.xml:75 reference_transformation.xml:137 176#: reference_transformation.xml:286 reference_transformation.xml:373 177#: reference_transformation.xml:428 reference_transformation.xml:485 178#, no-c-format 179msgid "&curve_support;" 180msgstr "" 181 182#. Tag: title 183#: reference_transformation.xml:80 reference_transformation.xml:145 184#: reference_transformation.xml:192 reference_transformation.xml:241 185#: reference_transformation.xml:293 reference_transformation.xml:380 186#: reference_transformation.xml:432 reference_transformation.xml:490 187#, no-c-format 188msgid "Examples" 189msgstr "" 190 191#. Tag: programlisting 192#: reference_transformation.xml:82 193#, no-c-format 194msgid "" 195"--Rotate a 3d line 180 degrees about the z axis. Note this is long-hand for " 196"doing ST_Rotate();\n" 197" SELECT ST_AsEWKT(ST_Affine(the_geom, cos(pi()), -sin(pi()), 0, sin(pi()), " 198"cos(pi()), 0, 0, 0, 1, 0, 0, 0)) As using_affine,\n" 199" ST_AsEWKT(ST_Rotate(the_geom, pi())) As using_rotate\n" 200" FROM (SELECT ST_GeomFromEWKT('LINESTRING(1 2 3, 1 4 3)') As " 201"the_geom) As foo;\n" 202" using_affine | using_rotate\n" 203"-----------------------------+-----------------------------\n" 204" LINESTRING(-1 -2 3,-1 -4 3) | LINESTRING(-1 -2 3,-1 -4 3)\n" 205"(1 row)\n" 206"\n" 207"--Rotate a 3d line 180 degrees in both the x and z axis\n" 208"SELECT ST_AsEWKT(ST_Affine(the_geom, cos(pi()), -sin(pi()), 0, sin(pi()), " 209"cos(pi()), -sin(pi()), 0, sin(pi()), cos(pi()), 0, 0, 0))\n" 210" FROM (SELECT ST_GeomFromEWKT('LINESTRING(1 2 3, 1 4 3)') As " 211"the_geom) As foo;\n" 212" st_asewkt\n" 213"-------------------------------\n" 214" LINESTRING(-1 -2 -3,-1 -4 -3)\n" 215"(1 row)" 216msgstr "" 217 218#. Tag: title 219#: reference_transformation.xml:87 reference_transformation.xml:152 220#: reference_transformation.xml:199 reference_transformation.xml:248 221#: reference_transformation.xml:300 reference_transformation.xml:387 222#: reference_transformation.xml:445 reference_transformation.xml:497 223#, no-c-format 224msgid "See Also" 225msgstr "" 226 227#. Tag: para 228#: reference_transformation.xml:89 229#, no-c-format 230msgid "" 231", <xref linkend=\"ST_Scale\"/>, <xref linkend=\"ST_Translate\"/>, <xref " 232"linkend=\"ST_TransScale\"/>" 233msgstr "" 234 235#. Tag: refname 236#: reference_transformation.xml:96 237#, no-c-format 238msgid "ST_Rotate" 239msgstr "" 240 241#. Tag: refpurpose 242#: reference_transformation.xml:98 243#, no-c-format 244msgid "Rotates a geometry about an origin point." 245msgstr "" 246 247#. Tag: funcsynopsis 248#: reference_transformation.xml:102 249#, no-c-format 250msgid "" 251"<funcprototype> <funcdef>geometry <function>ST_Rotate</function></funcdef> " 252"<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 253"<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef> </" 254"funcprototype> <funcprototype> <funcdef>geometry <function>ST_Rotate</" 255"function></funcdef> <paramdef><type>geometry</type> <parameter>geomA</" 256"parameter></paramdef> <paramdef><type>float</type> <parameter>rotRadians</" 257"parameter></paramdef> <paramdef><type>float</type> <parameter>x0</" 258"parameter></paramdef> <paramdef><type>float</type> <parameter>y0</" 259"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 260"<function>ST_Rotate</function></funcdef> <paramdef><type>geometry</type> " 261"<parameter>geomA</parameter></paramdef> <paramdef><type>float</type> " 262"<parameter>rotRadians</parameter></paramdef> <paramdef><type>geometry</type> " 263"<parameter>pointOrigin</parameter></paramdef> </funcprototype>" 264msgstr "" 265 266#. Tag: para 267#: reference_transformation.xml:129 268#, no-c-format 269msgid "" 270"Rotates geometry rotRadians counter-clockwise about the origin point. The " 271"rotation origin can be specified either as a POINT geometry, or as x and y " 272"coordinates. If the origin is not specified, the geometry is rotated about " 273"POINT(0 0)." 274msgstr "" 275 276#. Tag: para 277#: reference_transformation.xml:134 278#, no-c-format 279msgid "" 280"Enhanced: 2.0.0 additional parameters for specifying the origin of rotation " 281"were added." 282msgstr "" 283 284#. Tag: para 285#: reference_transformation.xml:135 286#, no-c-format 287msgid "Availability: 1.1.2. Name changed from Rotate to ST_Rotate in 1.2.2" 288msgstr "" 289 290#. Tag: programlisting 291#: reference_transformation.xml:147 292#, no-c-format 293msgid "" 294"--Rotate 180 degrees\n" 295"SELECT ST_AsEWKT(ST_Rotate('LINESTRING (50 160, 50 50, 100 50)', pi()));\n" 296" st_asewkt\n" 297"---------------------------------------\n" 298" LINESTRING(-50 -160,-50 -50,-100 -50)\n" 299"(1 row)\n" 300"\n" 301"--Rotate 30 degrees counter-clockwise at x=50, y=160\n" 302"SELECT ST_AsEWKT(ST_Rotate('LINESTRING (50 160, 50 50, 100 50)', pi()/6, 50, " 303"160));\n" 304" st_asewkt\n" 305"---------------------------------------------------------------------------\n" 306" LINESTRING(50 160,105 64.7372055837117,148.301270189222 89.7372055837117)\n" 307"(1 row)\n" 308"\n" 309"--Rotate 60 degrees clockwise from centroid\n" 310"SELECT ST_AsEWKT(ST_Rotate(geom, -pi()/3, ST_Centroid(geom)))\n" 311"FROM (SELECT 'LINESTRING (50 160, 50 50, 100 50)'::geometry AS geom) AS " 312"foo;\n" 313" st_asewkt\n" 314"--------------------------------------------------------------\n" 315" LINESTRING(116.4225 130.6721,21.1597 75.6721,46.1597 32.3708)\n" 316"(1 row)" 317msgstr "" 318 319#. Tag: para 320#: reference_transformation.xml:154 321#, no-c-format 322msgid "" 323", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateY\"/>, <xref " 324"linkend=\"ST_RotateZ\"/>" 325msgstr "" 326 327#. Tag: refname 328#: reference_transformation.xml:160 329#, no-c-format 330msgid "ST_RotateX" 331msgstr "" 332 333#. Tag: refpurpose 334#: reference_transformation.xml:162 335#, no-c-format 336msgid "Rotates a geometry about the X axis." 337msgstr "" 338 339#. Tag: funcprototype 340#: reference_transformation.xml:167 341#, no-c-format 342msgid "" 343"<funcdef>geometry <function>ST_RotateX</function></funcdef> " 344"<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 345"<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef>" 346msgstr "" 347 348#. Tag: para 349#: reference_transformation.xml:178 350#, no-c-format 351msgid "Rotates a geometry geomA - rotRadians about the X axis." 352msgstr "" 353 354#. Tag: para 355#: reference_transformation.xml:180 356#, no-c-format 357msgid "" 358"<code>ST_RotateX(geomA, rotRadians)</code> is short-hand for " 359"<code>ST_Affine(geomA, 1, 0, 0, 0, cos(rotRadians), -sin(rotRadians), 0, " 360"sin(rotRadians), cos(rotRadians), 0, 0, 0)</code>." 361msgstr "" 362 363#. Tag: para 364#: reference_transformation.xml:184 365#, no-c-format 366msgid "Availability: 1.1.2. Name changed from RotateX to ST_RotateX in 1.2.2" 367msgstr "" 368 369#. Tag: programlisting 370#: reference_transformation.xml:194 371#, no-c-format 372msgid "" 373"--Rotate a line 90 degrees along x-axis\n" 374"SELECT ST_AsEWKT(ST_RotateX(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 1)'), " 375"pi()/2));\n" 376" st_asewkt\n" 377"---------------------------\n" 378" LINESTRING(1 -3 2,1 -1 1)" 379msgstr "" 380 381#. Tag: para 382#: reference_transformation.xml:201 383#, no-c-format 384msgid ", <xref linkend=\"ST_RotateY\"/>, <xref linkend=\"ST_RotateZ\"/>" 385msgstr "" 386 387#. Tag: refname 388#: reference_transformation.xml:207 389#, no-c-format 390msgid "ST_RotateY" 391msgstr "" 392 393#. Tag: refpurpose 394#: reference_transformation.xml:209 395#, no-c-format 396msgid "Rotates a geometry about the Y axis." 397msgstr "" 398 399#. Tag: funcprototype 400#: reference_transformation.xml:214 401#, no-c-format 402msgid "" 403"<funcdef>geometry <function>ST_RotateY</function></funcdef> " 404"<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 405"<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef>" 406msgstr "" 407 408#. Tag: para 409#: reference_transformation.xml:225 410#, no-c-format 411msgid "Rotates a geometry geomA - rotRadians about the y axis." 412msgstr "" 413 414#. Tag: para 415#: reference_transformation.xml:227 416#, no-c-format 417msgid "" 418"<code>ST_RotateY(geomA, rotRadians)</code> is short-hand for " 419"<code>ST_Affine(geomA, cos(rotRadians), 0, sin(rotRadians), 0, 1, 0, -" 420"sin(rotRadians), 0, cos(rotRadians), 0, 0, 0)</code>." 421msgstr "" 422 423#. Tag: para 424#: reference_transformation.xml:230 425#, no-c-format 426msgid "Availability: 1.1.2. Name changed from RotateY to ST_RotateY in 1.2.2" 427msgstr "" 428 429#. Tag: programlisting 430#: reference_transformation.xml:243 431#, no-c-format 432msgid "" 433"--Rotate a line 90 degrees along y-axis\n" 434" SELECT ST_AsEWKT(ST_RotateY(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 1)'), " 435"pi()/2));\n" 436" st_asewkt\n" 437"---------------------------\n" 438" LINESTRING(3 2 -1,1 1 -1)" 439msgstr "" 440 441#. Tag: para 442#: reference_transformation.xml:250 443#, no-c-format 444msgid ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateZ\"/>" 445msgstr "" 446 447#. Tag: refname 448#: reference_transformation.xml:256 449#, no-c-format 450msgid "ST_RotateZ" 451msgstr "" 452 453#. Tag: refpurpose 454#: reference_transformation.xml:258 455#, no-c-format 456msgid "Rotates a geometry about the Z axis." 457msgstr "" 458 459#. Tag: funcprototype 460#: reference_transformation.xml:263 461#, no-c-format 462msgid "" 463"<funcdef>geometry <function>ST_RotateZ</function></funcdef> " 464"<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 465"<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef>" 466msgstr "" 467 468#. Tag: para 469#: reference_transformation.xml:274 470#, no-c-format 471msgid "Rotates a geometry geomA - rotRadians about the Z axis." 472msgstr "" 473 474#. Tag: para 475#: reference_transformation.xml:276 476#, no-c-format 477msgid "This is a synonym for ST_Rotate" 478msgstr "" 479 480#. Tag: para 481#: reference_transformation.xml:277 482#, no-c-format 483msgid "" 484"<code>ST_RotateZ(geomA, rotRadians)</code> is short-hand for <code>SELECT " 485"ST_Affine(geomA, cos(rotRadians), -sin(rotRadians), 0, sin(rotRadians), " 486"cos(rotRadians), 0, 0, 0, 1, 0, 0, 0)</code>." 487msgstr "" 488 489#. Tag: para 490#: reference_transformation.xml:282 491#, no-c-format 492msgid "Availability: 1.1.2. Name changed from RotateZ to ST_RotateZ in 1.2.2" 493msgstr "" 494 495#. Tag: programlisting 496#: reference_transformation.xml:295 497#, no-c-format 498msgid "" 499"--Rotate a line 90 degrees along z-axis\n" 500"SELECT ST_AsEWKT(ST_RotateZ(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 1)'), " 501"pi()/2));\n" 502" st_asewkt\n" 503"---------------------------\n" 504" LINESTRING(-2 1 3,-1 1 1)\n" 505"\n" 506" --Rotate a curved circle around z-axis\n" 507"SELECT ST_AsEWKT(ST_RotateZ(the_geom, pi()/2))\n" 508"FROM (SELECT ST_LineToCurve(ST_Buffer(ST_GeomFromText('POINT(234 567)'), 3)) " 509"As the_geom) As foo;\n" 510"\n" 511" st_asewkt\n" 512"----------------------------------------------------------------------------------------------------------------------------\n" 513" CURVEPOLYGON(CIRCULARSTRING(-567 237,-564.87867965644 236.12132034356,-564 " 514"234,-569.12132034356 231.87867965644,-567 237))" 515msgstr "" 516 517#. Tag: para 518#: reference_transformation.xml:302 519#, no-c-format 520msgid ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateY\"/>" 521msgstr "" 522 523#. Tag: refname 524#: reference_transformation.xml:308 525#, no-c-format 526msgid "ST_Scale" 527msgstr "" 528 529#. Tag: refpurpose 530#: reference_transformation.xml:310 531#, no-c-format 532msgid "Scales a geometry by given factors." 533msgstr "" 534 535#. Tag: funcsynopsis 536#: reference_transformation.xml:314 537#, no-c-format 538msgid "" 539"<funcprototype> <funcdef>geometry <function>ST_Scale</function></funcdef> " 540"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 541"<paramdef><type>float</type> <parameter>XFactor</parameter></paramdef> " 542"<paramdef><type>float</type> <parameter>YFactor</parameter></paramdef> " 543"<paramdef><type>float</type> <parameter>ZFactor</parameter></paramdef> </" 544"funcprototype> <funcprototype> <funcdef>geometry <function>ST_Scale</" 545"function></funcdef> <paramdef><type>geometry </type> <parameter>geomA</" 546"parameter></paramdef> <paramdef><type>float</type> <parameter>XFactor</" 547"parameter></paramdef> <paramdef><type>float</type> <parameter>YFactor</" 548"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 549"<function>ST_Scale</function></funcdef> <paramdef><type>geometry </type> " 550"<parameter>geom</parameter></paramdef> <paramdef><type>geometry</type> " 551"<parameter>factor</parameter></paramdef> </funcprototype> <funcprototype> " 552"<funcdef>geometry <function>ST_Scale</function></funcdef> " 553"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> " 554"<paramdef><type>geometry</type> <parameter>factor</parameter></paramdef> " 555"<paramdef><type>geometry</type> <parameter>origin</parameter></paramdef> </" 556"funcprototype>" 557msgstr "" 558 559#. Tag: para 560#: reference_transformation.xml:350 561#, no-c-format 562msgid "" 563"Scales the geometry to a new size by multiplying the ordinates with the " 564"corresponding factor parameters." 565msgstr "" 566 567#. Tag: para 568#: reference_transformation.xml:354 569#, no-c-format 570msgid "" 571"The version taking a geometry as the <varname>factor</varname> parameter " 572"allows passing a 2d, 3dm, 3dz or 4d point to set scaling factor for all " 573"supported dimensions. Missing dimensions in the <varname>factor</varname> " 574"point are equivalent to no scaling the corresponding dimension." 575msgstr "" 576 577#. Tag: para 578#: reference_transformation.xml:360 579#, no-c-format 580msgid "" 581"The three-geometry variant allows a \"false origin\" for the scaling to be " 582"passed in. This allows \"scaling in place\", for example using the centroid " 583"of the geometry as the false origin. Without a false origin, scaling takes " 584"place relative to the actual origin, so all coordinates are just multipled " 585"by the scale factor." 586msgstr "" 587 588#. Tag: para 589#: reference_transformation.xml:367 reference_transformation.xml:483 590#, no-c-format 591msgid "Availability: 1.1.0." 592msgstr "" 593 594#. Tag: para 595#: reference_transformation.xml:369 596#, no-c-format 597msgid "" 598"Enhanced: 2.2.0 support for scaling all dimension (<varname>factor</varname> " 599"parameter) was introduced." 600msgstr "" 601 602#. Tag: para 603#: reference_transformation.xml:370 604#, no-c-format 605msgid "" 606"Enhanced: 2.5.0 support for scaling relative to a local origin " 607"(<varname>origin</varname> parameter) was introduced." 608msgstr "" 609 610#. Tag: para 611#: reference_transformation.xml:375 612#, no-c-format 613msgid "&M_support;" 614msgstr "" 615 616#. Tag: programlisting 617#: reference_transformation.xml:382 618#, no-c-format 619msgid "" 620"--Version 1: scale X, Y, Z\n" 621"SELECT ST_AsEWKT(ST_Scale(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 1)'), 0.5, " 622"0.75, 0.8));\n" 623" st_asewkt\n" 624"--------------------------------------\n" 625" LINESTRING(0.5 1.5 2.4,0.5 0.75 0.8)\n" 626"\n" 627"--Version 2: Scale X Y\n" 628" SELECT ST_AsEWKT(ST_Scale(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 1)'), 0.5, " 629"0.75));\n" 630" st_asewkt\n" 631"----------------------------------\n" 632" LINESTRING(0.5 1.5 3,0.5 0.75 1)\n" 633"\n" 634"--Version 3: Scale X Y Z M\n" 635" SELECT ST_AsEWKT(ST_Scale(ST_GeomFromEWKT('LINESTRING(1 2 3 4, 1 1 1 1)'),\n" 636" ST_MakePoint(0.5, 0.75, 2, -1)));\n" 637" st_asewkt\n" 638"----------------------------------------\n" 639" LINESTRING(0.5 1.5 6 -4,0.5 0.75 2 -1)\n" 640"\n" 641"--Version 4: Scale X Y using false origin\n" 642"SELECT ST_AsText(ST_Scale('LINESTRING(1 1, 2 2)', 'POINT(2 2)', 'POINT(1 " 643"1)'::geometry));\n" 644" st_astext\n" 645"---------------------\n" 646" LINESTRING(1 1,3 3)" 647msgstr "" 648 649#. Tag: para 650#: reference_transformation.xml:389 651#, no-c-format 652msgid ", <xref linkend=\"ST_TransScale\"/>" 653msgstr "" 654 655#. Tag: refname 656#: reference_transformation.xml:395 657#, no-c-format 658msgid "ST_Translate" 659msgstr "" 660 661#. Tag: refpurpose 662#: reference_transformation.xml:397 663#, no-c-format 664msgid "Translates a geometry by given offsets." 665msgstr "" 666 667#. Tag: funcsynopsis 668#: reference_transformation.xml:401 669#, no-c-format 670msgid "" 671"<funcprototype> <funcdef>geometry <function>ST_Translate</function></" 672"funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></" 673"paramdef> <paramdef><type>float </type> <parameter>deltax</parameter></" 674"paramdef> <paramdef><type>float </type> <parameter>deltay</parameter></" 675"paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 676"<function>ST_Translate</function></funcdef> <paramdef><type>geometry </type> " 677"<parameter>g1</parameter></paramdef> <paramdef><type>float </type> " 678"<parameter>deltax</parameter></paramdef> <paramdef><type>float </type> " 679"<parameter>deltay</parameter></paramdef> <paramdef><type>float </type> " 680"<parameter>deltaz</parameter></paramdef> </funcprototype>" 681msgstr "" 682 683#. Tag: para 684#: reference_transformation.xml:421 685#, no-c-format 686msgid "" 687"Returns a new geometry whose coordinates are translated delta x,delta y," 688"delta z units. Units are based on the units defined in spatial reference " 689"(SRID) for this geometry." 690msgstr "" 691 692#. Tag: para 693#: reference_transformation.xml:426 694#, no-c-format 695msgid "Availability: 1.2.2" 696msgstr "" 697 698#. Tag: para 699#: reference_transformation.xml:433 700#, no-c-format 701msgid "Move a point 1 degree longitude" 702msgstr "" 703 704#. Tag: programlisting 705#: reference_transformation.xml:434 706#, no-c-format 707msgid "" 708"SELECT ST_AsText(ST_Translate(ST_GeomFromText('POINT(-71.01 " 709"42.37)',4326),1,0)) As wgs_transgeomtxt;\n" 710"\n" 711" wgs_transgeomtxt\n" 712" ---------------------\n" 713" POINT(-70.01 42.37)" 714msgstr "" 715 716#. Tag: para 717#: reference_transformation.xml:435 718#, no-c-format 719msgid "Move a linestring 1 degree longitude and 1/2 degree latitude" 720msgstr "" 721 722#. Tag: programlisting 723#: reference_transformation.xml:436 724#, no-c-format 725msgid "" 726"SELECT ST_AsText(ST_Translate(ST_GeomFromText('LINESTRING(-71.01 " 727"42.37,-71.11 42.38)',4326),1,0.5)) As wgs_transgeomtxt;\n" 728" wgs_transgeomtxt\n" 729" ---------------------------------------\n" 730" LINESTRING(-70.01 42.87,-70.11 42.88)" 731msgstr "" 732 733#. Tag: para 734#: reference_transformation.xml:437 735#, no-c-format 736msgid "Move a 3d point" 737msgstr "" 738 739#. Tag: programlisting 740#: reference_transformation.xml:438 741#, no-c-format 742msgid "" 743"SELECT ST_AsEWKT(ST_Translate(CAST('POINT(0 0 0)' As geometry), 5, 12,3));\n" 744" st_asewkt\n" 745" ---------\n" 746" POINT(5 12 3)" 747msgstr "" 748 749#. Tag: para 750#: reference_transformation.xml:439 751#, no-c-format 752msgid "Move a curve and a point" 753msgstr "" 754 755#. Tag: programlisting 756#: reference_transformation.xml:440 757#, no-c-format 758msgid "" 759"SELECT ST_AsText(ST_Translate(ST_Collect('CURVEPOLYGON(CIRCULARSTRING(4 " 760"3,3.12 0.878,1 0,-1.121 5.1213,6 7, 8 9,4 3))','POINT(1 3)'),1,2));\n" 761" st_astext\n" 762"------------------------------------------------------------------------------------------------------------\n" 763" GEOMETRYCOLLECTION(CURVEPOLYGON(CIRCULARSTRING(5 5,4.12 2.878,2 2,-0.121 " 764"7.1213,7 9,9 11,5 5)),POINT(2 5))" 765msgstr "" 766 767#. Tag: para 768#: reference_transformation.xml:446 769#, no-c-format 770msgid ", <xref linkend=\"ST_AsText\"/>, <xref linkend=\"ST_GeomFromText\"/>" 771msgstr "" 772 773#. Tag: refname 774#: reference_transformation.xml:452 775#, no-c-format 776msgid "ST_TransScale" 777msgstr "" 778 779#. Tag: refpurpose 780#: reference_transformation.xml:454 781#, no-c-format 782msgid "Translates and scales a geometry by given offsets and factors." 783msgstr "" 784 785#. Tag: funcprototype 786#: reference_transformation.xml:459 787#, no-c-format 788msgid "" 789"<funcdef>geometry <function>ST_TransScale</function></funcdef> " 790"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 791"<paramdef><type>float</type> <parameter>deltaX</parameter></paramdef> " 792"<paramdef><type>float</type> <parameter>deltaY</parameter></paramdef> " 793"<paramdef><type>float</type> <parameter>XFactor</parameter></paramdef> " 794"<paramdef><type>float</type> <parameter>YFactor</parameter></paramdef>" 795msgstr "" 796 797#. Tag: para 798#: reference_transformation.xml:473 799#, no-c-format 800msgid "" 801"Translates the geometry using the deltaX and deltaY args, then scales it " 802"using the XFactor, YFactor args, working in 2D only." 803msgstr "" 804 805#. Tag: para 806#: reference_transformation.xml:476 807#, no-c-format 808msgid "" 809"<code>ST_TransScale(geomA, deltaX, deltaY, XFactor, YFactor)</code> is short-" 810"hand for <code>ST_Affine(geomA, XFactor, 0, 0, 0, YFactor, 0, 0, 0, 1, " 811"deltaX*XFactor, deltaY*YFactor, 0)</code>." 812msgstr "" 813 814#. Tag: programlisting 815#: reference_transformation.xml:492 816#, no-c-format 817msgid "" 818"SELECT ST_AsEWKT(ST_TransScale(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 1)'), " 819"0.5, 1, 1, 2));\n" 820" st_asewkt\n" 821"-----------------------------\n" 822" LINESTRING(1.5 6 3,1.5 4 1)\n" 823"\n" 824"\n" 825"--Buffer a point to get an approximation of a circle, convert to curve and " 826"then translate 1,2 and scale it 3,4\n" 827" SELECT ST_AsText(ST_Transscale(ST_LineToCurve(ST_Buffer('POINT(234 567)', " 828"3)),1,2,3,4));\n" 829" st_astext\n" 830"------------------------------------------------------------------------------------------------------------------------------\n" 831" CURVEPOLYGON(CIRCULARSTRING(714 2276,711.363961030679 2267.51471862576,705 " 832"2264,698.636038969321 2284.48528137424,714 2276))" 833msgstr "" 834 835#. Tag: para 836#: reference_transformation.xml:499 837#, no-c-format 838msgid ", <xref linkend=\"ST_Translate\"/>" 839msgstr "" 840