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