1# SOME DESCRIPTIVE TITLE. 2# 3# Translators: 4# pibinko <pibinko@gmail.com>, 2014 5msgid "" 6msgstr "" 7"Project-Id-Version: PostGIS\n" 8"Report-Msgid-Bugs-To: http://bugs.kde.org\n" 9"POT-Creation-Date: 2019-10-06 23:49+0000\n" 10"PO-Revision-Date: 2015-09-29 12:24+0000\n" 11"Last-Translator: Sandro Santilli <strk@kbt.io>\n" 12"Language-Team: Italian (Italy) (http://www.transifex.com/postgis/postgis/" 13"language/it_IT/)\n" 14"Language: it_IT\n" 15"MIME-Version: 1.0\n" 16"Content-Type: text/plain; charset=UTF-8\n" 17"Content-Transfer-Encoding: 8bit\n" 18"Plural-Forms: nplurals=2; plural=(n != 1);\n" 19 20#. Tag: title 21#: reference_processing.xml:3 22#, no-c-format 23msgid "Geometry Processing" 24msgstr "" 25 26#. Tag: refname 27#: reference_processing.xml:6 28#, no-c-format 29msgid "ST_Buffer" 30msgstr "ST_Buffer" 31 32#. Tag: refpurpose 33#: reference_processing.xml:8 34#, no-c-format 35msgid "" 36"(T) Returns a geometry covering all points within a given distance from the " 37"input geometry." 38msgstr "" 39 40#. Tag: funcsynopsis 41#: reference_processing.xml:16 42#, fuzzy, no-c-format 43msgid "" 44"<funcprototype> <funcdef>geometry <function>ST_Buffer</function></funcdef> " 45"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 46"<paramdef><type>float </type> <parameter>radius_of_buffer</parameter></" 47"paramdef> <paramdef choice=\"opt\"><type>text </type> " 48"<parameter>buffer_style_parameters=''</parameter></paramdef> </" 49"funcprototype> <funcprototype> <funcdef>geometry <function>ST_Buffer</" 50"function></funcdef> <paramdef><type>geometry </type> <parameter>g1</" 51"parameter></paramdef> <paramdef><type>float </type> " 52"<parameter>radius_of_buffer</parameter></paramdef> <paramdef><type>integer </" 53"type> <parameter>num_seg_quarter_circle</parameter></paramdef> </" 54"funcprototype> <funcprototype> <funcdef>geography <function>ST_Buffer</" 55"function></funcdef> <paramdef><type>geography </type> <parameter>g1</" 56"parameter></paramdef> <paramdef><type>float </type> " 57"<parameter>radius_of_buffer</parameter></paramdef> <paramdef choice=\"opt" 58"\"><type>text </type> <parameter>buffer_style_parameters</parameter></" 59"paramdef> </funcprototype> <funcprototype> <funcdef>geography " 60"<function>ST_Buffer</function></funcdef> <paramdef><type>geography </type> " 61"<parameter>g1</parameter></paramdef> <paramdef><type>float </type> " 62"<parameter>radius_of_buffer</parameter></paramdef> <paramdef><type>integer </" 63"type> <parameter>num_seg_quarter_circle</parameter></paramdef> </" 64"funcprototype>" 65msgstr "" 66"<funcprototype> <funcdef>geometry <function>ST_Buffer</function></funcdef> " 67"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 68"<paramdef><type>float </type> <parameter>radius_of_buffer</parameter></" 69"paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 70"<function>ST_Buffer</function></funcdef> <paramdef><type>geometry </type> " 71"<parameter>g1</parameter></paramdef> <paramdef><type>float </type> " 72"<parameter>radius_of_buffer</parameter></paramdef> <paramdef><type>integer </" 73"type> <parameter>num_seg_quarter_circle</parameter></paramdef> </" 74"funcprototype> <funcprototype> <funcdef>geometry <function>ST_Buffer</" 75"function></funcdef> <paramdef><type>geometry </type> <parameter>g1</" 76"parameter></paramdef> <paramdef><type>float </type> " 77"<parameter>radius_of_buffer</parameter></paramdef> <paramdef><type>text </" 78"type> <parameter>buffer_style_parameters</parameter></paramdef> </" 79"funcprototype> <funcprototype> <funcdef>geography <function>ST_Buffer</" 80"function></funcdef> <paramdef><type>geography </type> <parameter>g1</" 81"parameter></paramdef> <paramdef><type>float </type> " 82"<parameter>radius_of_buffer_in_meters</parameter></paramdef> </funcprototype>" 83 84#. Tag: title 85#: reference_processing.xml:50 reference_processing.xml:285 86#: reference_processing.xml:375 reference_processing.xml:491 87#: reference_processing.xml:539 reference_processing.xml:687 88#: reference_processing.xml:760 reference_processing.xml:844 89#: reference_processing.xml:943 reference_processing.xml:1025 90#: reference_processing.xml:1088 reference_processing.xml:1197 91#: reference_processing.xml:1289 reference_processing.xml:1358 92#: reference_processing.xml:1400 reference_processing.xml:1460 93#: reference_processing.xml:1507 reference_processing.xml:1561 94#: reference_processing.xml:1598 reference_processing.xml:1658 95#: reference_processing.xml:1711 reference_processing.xml:1765 96#: reference_processing.xml:1921 reference_processing.xml:1963 97#: reference_processing.xml:2001 reference_processing.xml:2075 98#: reference_processing.xml:2129 reference_processing.xml:2185 99#: reference_processing.xml:2236 reference_processing.xml:2277 100#: reference_processing.xml:2318 reference_processing.xml:2364 101#: reference_processing.xml:2412 reference_processing.xml:2468 102#: reference_processing.xml:2595 reference_processing.xml:2676 103#: reference_processing.xml:2766 reference_processing.xml:2843 104#: reference_processing.xml:2911 reference_processing.xml:2999 105#, no-c-format 106msgid "Description" 107msgstr "Descrizione" 108 109#. Tag: para 110#: reference_processing.xml:52 111#, no-c-format 112msgid "" 113"Returns a geometry/geography that represents all points whose distance from " 114"this Geometry/geography is less than or equal to distance." 115msgstr "" 116 117#. Tag: para 118#: reference_processing.xml:54 119#, no-c-format 120msgid "" 121"Geometry: Calculations are in the Spatial Reference System of the geometry. " 122"Introduced in 1.5 support for different end cap and mitre settings to " 123"control shape." 124msgstr "" 125 126#. Tag: para 127#: reference_processing.xml:57 128#, no-c-format 129msgid "" 130"Negative radii: For polygons, a negative radius can be used, which will " 131"shrink the polygon rather than expanding it." 132msgstr "" 133 134#. Tag: para 135#: reference_processing.xml:58 136#, no-c-format 137msgid "" 138"Geography: For geography this is really a thin wrapper around the geometry " 139"implementation. It first determines the best SRID that fits the bounding box " 140"of the geography object (favoring UTM, Lambert Azimuthal Equal Area (LAEA) " 141"north/south pole, and falling back on mercator in worst case scenario) and " 142"then buffers in that planar spatial ref and retransforms back to WGS84 " 143"geography." 144msgstr "" 145 146#. Tag: para 147#: reference_processing.xml:60 148#, no-c-format 149msgid "" 150"For geography this may not behave as expected if object is sufficiently " 151"large that it falls between two UTM zones or crosses the dateline" 152msgstr "" 153 154#. Tag: para 155#: reference_processing.xml:62 156#, no-c-format 157msgid "" 158"Enhanced: 2.5.0 - ST_Buffer geometry support was enhanced to allow for side " 159"buffering specification <code>side=both|left|right</code>." 160msgstr "" 161 162#. Tag: para 163#: reference_processing.xml:63 164#, no-c-format 165msgid "" 166"Availability: 1.5 - ST_Buffer was enhanced to support different endcaps and " 167"join types. These are useful for example to convert road linestrings into " 168"polygon roads with flat or square edges instead of rounded edges. Thin " 169"wrapper for geography was added." 170msgstr "" 171 172#. Tag: para 173#: reference_processing.xml:66 174#, no-c-format 175msgid "" 176"The optional third parameter (currently only applies to geometry) can either " 177"specify number of segments used to approximate a quarter circle (integer " 178"case, defaults to 8) or a list of blank-separated key=value pairs (string " 179"case) to tweak operations as follows:" 180msgstr "" 181 182#. Tag: para 183#: reference_processing.xml:70 reference_processing.xml:1791 184#, no-c-format 185msgid "" 186"'quad_segs=#' : number of segments used to approximate a quarter circle " 187"(defaults to 8)." 188msgstr "" 189 190#. Tag: para 191#: reference_processing.xml:73 192#, no-c-format 193msgid "" 194"'endcap=round|flat|square' : endcap style (defaults to \"round\"). 'butt' is " 195"also accepted as a synonym for 'flat'." 196msgstr "" 197 198#. Tag: para 199#: reference_processing.xml:76 reference_processing.xml:1794 200#, no-c-format 201msgid "" 202"'join=round|mitre|bevel' : join style (defaults to \"round\"). 'miter' is " 203"also accepted as a synonym for 'mitre'." 204msgstr "" 205 206#. Tag: para 207#: reference_processing.xml:79 208#, no-c-format 209msgid "" 210"'mitre_limit=#.#' : mitre ratio limit (only affects mitered join style). " 211"'miter_limit' is also accepted as a synonym for 'mitre_limit'." 212msgstr "" 213 214#. Tag: para 215#: reference_processing.xml:82 216#, no-c-format 217msgid "" 218"'side=both|left|right' : 'left' or 'right' performs a single-sided buffer on " 219"the geometry, with the buffered side relative to the direction of the line. " 220"This is only really relevant to LINESTRING geometry and does not affect " 221"POINT or POLYGON geometries. By default end caps are square." 222msgstr "" 223 224#. Tag: para 225#: reference_processing.xml:88 226#, no-c-format 227msgid "Units of radius are measured in units of the spatial reference system." 228msgstr "" 229 230#. Tag: para 231#: reference_processing.xml:89 232#, no-c-format 233msgid "" 234"The inputs can be POINTS, MULTIPOINTS, LINESTRINGS, MULTILINESTRINGS, " 235"POLYGONS, MULTIPOLYGONS, and GeometryCollections." 236msgstr "" 237 238#. Tag: para 239#: reference_processing.xml:90 240#, no-c-format 241msgid "" 242"This function ignores the third dimension (z) and will always give a 2-d " 243"buffer even when presented with a 3d-geometry." 244msgstr "" 245 246#. Tag: para 247#: reference_processing.xml:92 reference_processing.xml:499 248#: reference_processing.xml:854 reference_processing.xml:1422 249#: reference_processing.xml:1517 reference_processing.xml:1672 250#: reference_processing.xml:1719 reference_processing.xml:1782 251#: reference_processing.xml:1806 reference_processing.xml:2006 252#: reference_processing.xml:2245 reference_processing.xml:2686 253#: reference_processing.xml:2789 reference_processing.xml:2929 254#: reference_processing.xml:3020 255#, no-c-format 256msgid "Performed by the GEOS module." 257msgstr "Eseguito dal modulo GEOS" 258 259#. Tag: para 260#: reference_processing.xml:93 reference_processing.xml:709 261#: reference_processing.xml:952 reference_processing.xml:1313 262#: reference_processing.xml:2603 reference_processing.xml:2796 263#, no-c-format 264msgid "&sfs_compliant; s2.1.1.3" 265msgstr "&sfs_compliant; s2.1.1.3" 266 267#. Tag: para 268#: reference_processing.xml:94 269#, no-c-format 270msgid "&sqlmm_compliant; SQL-MM 3: 5.1.17" 271msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.17" 272 273#. Tag: para 274#: reference_processing.xml:96 275#, no-c-format 276msgid "" 277"People often make the mistake of using this function to try to do radius " 278"searches. Creating a buffer to a radius search is slow and pointless. Use " 279"<xref linkend=\"ST_DWithin\"/> instead." 280msgstr "" 281 282#. Tag: title 283#: reference_processing.xml:101 reference_processing.xml:302 284#: reference_processing.xml:405 reference_processing.xml:506 285#: reference_processing.xml:577 reference_processing.xml:715 286#: reference_processing.xml:810 reference_processing.xml:959 287#: reference_processing.xml:1101 reference_processing.xml:1225 288#: reference_processing.xml:1317 reference_processing.xml:1369 289#: reference_processing.xml:1476 reference_processing.xml:1527 290#: reference_processing.xml:1573 reference_processing.xml:1618 291#: reference_processing.xml:1728 reference_processing.xml:1815 292#: reference_processing.xml:1933 reference_processing.xml:2096 293#: reference_processing.xml:2154 reference_processing.xml:2207 294#: reference_processing.xml:2250 reference_processing.xml:2290 295#: reference_processing.xml:2335 reference_processing.xml:2382 296#: reference_processing.xml:2439 reference_processing.xml:2492 297#: reference_processing.xml:2611 reference_processing.xml:2692 298#: reference_processing.xml:2803 reference_processing.xml:2935 299#: reference_processing.xml:3026 300#, no-c-format 301msgid "Examples" 302msgstr "Esempi" 303 304#. Tag: para 305#: reference_processing.xml:112 306#, no-c-format 307msgid "quad_segs=8 (default)" 308msgstr "quad_segs=8 (default)" 309 310#. Tag: programlisting 311#: reference_processing.xml:115 312#, no-c-format 313msgid "" 314"SELECT ST_Buffer(\n" 315" ST_GeomFromText('POINT(100 90)'),\n" 316" 50, 'quad_segs=8');" 317msgstr "" 318"SELECT ST_Buffer(\n" 319" ST_GeomFromText('POINT(100 90)'),\n" 320" 50, 'quad_segs=8');" 321 322#. Tag: para 323#: reference_processing.xml:123 324#, no-c-format 325msgid "quad_segs=2 (lame)" 326msgstr "quad_segs=2 (lame)" 327 328#. Tag: programlisting 329#: reference_processing.xml:126 330#, no-c-format 331msgid "" 332"SELECT ST_Buffer(\n" 333" ST_GeomFromText('POINT(100 90)'),\n" 334" 50, 'quad_segs=2');" 335msgstr "" 336"SELECT ST_Buffer(\n" 337" ST_GeomFromText('POINT(100 90)'),\n" 338" 50, 'quad_segs=2');" 339 340#. Tag: para 341#: reference_processing.xml:135 342#, no-c-format 343msgid "endcap=round join=round (default)" 344msgstr "endcap=round join=round (default)" 345 346#. Tag: programlisting 347#: reference_processing.xml:138 348#, no-c-format 349msgid "" 350"SELECT ST_Buffer(\n" 351" ST_GeomFromText(\n" 352" 'LINESTRING(50 50,150 150,150 50)'\n" 353" ), 10, 'endcap=round join=round');" 354msgstr "" 355"SELECT ST_Buffer(\n" 356" ST_GeomFromText(\n" 357" 'LINESTRING(50 50,150 150,150 50)'\n" 358" ), 10, 'endcap=round join=round');" 359 360#. Tag: para 361#: reference_processing.xml:146 362#, no-c-format 363msgid "endcap=square" 364msgstr "endcap=square" 365 366#. Tag: programlisting 367#: reference_processing.xml:149 368#, no-c-format 369msgid "" 370"SELECT ST_Buffer(\n" 371" ST_GeomFromText(\n" 372" 'LINESTRING(50 50,150 150,150 50)'\n" 373" ), 10, 'endcap=square join=round');" 374msgstr "" 375"SELECT ST_Buffer(\n" 376" ST_GeomFromText(\n" 377" 'LINESTRING(50 50,150 150,150 50)'\n" 378" ), 10, 'endcap=square join=round');" 379 380#. Tag: para 381#: reference_processing.xml:157 382#, no-c-format 383msgid "endcap=flat" 384msgstr "endcap=flat" 385 386#. Tag: programlisting 387#: reference_processing.xml:160 388#, no-c-format 389msgid "" 390"SELECT ST_Buffer(\n" 391" ST_GeomFromText(\n" 392" 'LINESTRING(50 50,150 150,150 50)'\n" 393" ), 10, 'endcap=flat join=round');" 394msgstr "" 395"SELECT ST_Buffer(\n" 396" ST_GeomFromText(\n" 397" 'LINESTRING(50 50,150 150,150 50)'\n" 398" ), 10, 'endcap=flat join=round');" 399 400#. Tag: para 401#: reference_processing.xml:169 402#, no-c-format 403msgid "join=bevel" 404msgstr "join=bevel" 405 406#. Tag: programlisting 407#: reference_processing.xml:172 408#, no-c-format 409msgid "" 410"SELECT ST_Buffer(\n" 411" ST_GeomFromText(\n" 412" 'LINESTRING(50 50,150 150,150 50)'\n" 413" ), 10, 'join=bevel');" 414msgstr "" 415"SELECT ST_Buffer(\n" 416" ST_GeomFromText(\n" 417" 'LINESTRING(50 50,150 150,150 50)'\n" 418" ), 10, 'join=bevel');" 419 420#. Tag: para 421#: reference_processing.xml:180 422#, no-c-format 423msgid "join=mitre mitre_limit=5.0 (default mitre limit)" 424msgstr "join=mitre mitre_limit=5.0 (default mitre limit)" 425 426#. Tag: programlisting 427#: reference_processing.xml:183 428#, no-c-format 429msgid "" 430"SELECT ST_Buffer(\n" 431" ST_GeomFromText(\n" 432" 'LINESTRING(50 50,150 150,150 50)'\n" 433" ), 10, 'join=mitre mitre_limit=5.0');" 434msgstr "" 435"SELECT ST_Buffer(\n" 436" ST_GeomFromText(\n" 437" 'LINESTRING(50 50,150 150,150 50)'\n" 438" ), 10, 'join=mitre mitre_limit=5.0');" 439 440#. Tag: para 441#: reference_processing.xml:191 442#, no-c-format 443msgid "join=mitre mitre_limit=1" 444msgstr "join=mitre mitre_limit=1" 445 446#. Tag: programlisting 447#: reference_processing.xml:194 448#, no-c-format 449msgid "" 450"SELECT ST_Buffer(\n" 451" ST_GeomFromText(\n" 452" 'LINESTRING(50 50,150 150,150 50)'\n" 453" ), 10, 'join=mitre mitre_limit=1.0');" 454msgstr "" 455"SELECT ST_Buffer(\n" 456" ST_GeomFromText(\n" 457" 'LINESTRING(50 50,150 150,150 50)'\n" 458" ), 10, 'join=mitre mitre_limit=1.0');" 459 460#. Tag: para 461#: reference_processing.xml:203 462#, no-c-format 463msgid "side=left" 464msgstr "" 465 466#. Tag: programlisting 467#: reference_processing.xml:206 468#, fuzzy, no-c-format 469msgid "" 470"SELECT ST_Buffer(\n" 471" ST_GeomFromText(\n" 472" 'LINESTRING(50 50,150 150,150 50)'\n" 473" ), 10, 'side=left');" 474msgstr "" 475"SELECT ST_Buffer(\n" 476" ST_GeomFromText(\n" 477" 'LINESTRING(50 50,150 150,150 50)'\n" 478" ), 10, 'join=bevel');" 479 480#. Tag: para 481#: reference_processing.xml:214 482#, no-c-format 483msgid "side=right" 484msgstr "" 485 486#. Tag: programlisting 487#: reference_processing.xml:217 488#, fuzzy, no-c-format 489msgid "" 490"SELECT ST_Buffer(\n" 491" ST_GeomFromText(\n" 492" 'LINESTRING(50 50,150 150,150 50)'\n" 493" ), 10, 'side=right');" 494msgstr "" 495"SELECT ST_Buffer(\n" 496" ST_GeomFromText(\n" 497" 'LINESTRING(50 50,150 150,150 50)'\n" 498" ), 10, 'join=bevel');" 499 500#. Tag: para 501#: reference_processing.xml:225 502#, no-c-format 503msgid "side=left join=mitre" 504msgstr "" 505 506#. Tag: programlisting 507#: reference_processing.xml:228 508#, fuzzy, no-c-format 509msgid "" 510"SELECT ST_Buffer(\n" 511" ST_GeomFromText(\n" 512" 'LINESTRING(50 50,150 150,150 50)'\n" 513" ), 10, 'side=left join=mitre');" 514msgstr "" 515"SELECT ST_Buffer(\n" 516" ST_GeomFromText(\n" 517" 'LINESTRING(50 50,150 150,150 50)'\n" 518" ), 10, 'join=bevel');" 519 520#. Tag: para 521#: reference_processing.xml:237 522#, no-c-format 523msgid "right-hand-winding, polygon boundary side=left" 524msgstr "" 525 526#. Tag: programlisting 527#: reference_processing.xml:240 528#, fuzzy, no-c-format 529msgid "" 530"SELECT ST_Buffer(\n" 531"ST_ForceRHR(\n" 532"ST_Boundary(\n" 533" ST_GeomFromText(\n" 534"'POLYGON ((50 50, 50 150, 150 150, 150 50, 50 50))'))),\n" 535" ), 20, 'side=left');" 536msgstr "" 537"SELECT ST_Buffer(\n" 538" ST_GeomFromText(\n" 539" 'LINESTRING(50 50,150 150,150 50)'\n" 540" ), 10, 'join=bevel');" 541 542#. Tag: para 543#: reference_processing.xml:247 544#, no-c-format 545msgid "right-hand-winding, polygon boundary side=right" 546msgstr "" 547 548#. Tag: programlisting 549#: reference_processing.xml:250 550#, fuzzy, no-c-format 551msgid "" 552"SELECT ST_Buffer(\n" 553"ST_ForceRHR(\n" 554"ST_Boundary(\n" 555" ST_GeomFromText(\n" 556"'POLYGON ((50 50, 50 150, 150 150, 150 50, 50 50))'))\n" 557"), 20,'side=right')" 558msgstr "" 559"SELECT ST_Buffer(\n" 560" ST_GeomFromText(\n" 561" 'LINESTRING(50 50,150 150,150 50)'\n" 562" ), 10, 'join=bevel');" 563 564#. Tag: programlisting 565#: reference_processing.xml:257 566#, no-c-format 567msgid "" 568"--A buffered point approximates a circle\n" 569"-- A buffered point forcing approximation of (see diagram)\n" 570"-- 2 points per quarter circle is poly with 8 sides (see diagram)\n" 571"SELECT ST_NPoints(ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50)) As " 572"promisingcircle_pcount,\n" 573"ST_NPoints(ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50, 2)) As " 574"lamecircle_pcount;\n" 575"\n" 576"promisingcircle_pcount | lamecircle_pcount\n" 577"------------------------+-------------------\n" 578" 33 | 9\n" 579"\n" 580"--A lighter but lamer circle\n" 581"-- only 2 points per quarter circle is an octagon\n" 582"--Below is a 100 meter octagon\n" 583"-- Note coordinates are in NAD 83 long lat which we transform\n" 584"to Mass state plane meter and then buffer to get measurements in meters;\n" 585"SELECT ST_AsText(ST_Buffer(\n" 586"ST_Transform(\n" 587"ST_SetSRID(ST_MakePoint(-71.063526, 42.35785),4269), 26986)\n" 588",100,2)) As octagon;\n" 589"----------------------\n" 590"POLYGON((236057.59057465 900908.759918696,236028.301252769 " 591"900838.049240578,235\n" 592"957.59057465 900808.759918696,235886.879896532 " 593"900838.049240578,235857.59057465\n" 594"900908.759918696,235886.879896532 900979.470596815,235957.59057465 " 595"901008.759918\n" 596"696,236028.301252769 900979.470596815,236057.59057465 900908.759918696))" 597msgstr "" 598 599#. Tag: title 600#: reference_processing.xml:261 reference_processing.xml:336 601#: reference_processing.xml:468 reference_processing.xml:510 602#: reference_processing.xml:666 reference_processing.xml:735 603#: reference_processing.xml:817 reference_processing.xml:918 604#: reference_processing.xml:1000 reference_processing.xml:1042 605#: reference_processing.xml:1246 reference_processing.xml:1336 606#: reference_processing.xml:1378 reference_processing.xml:1433 607#: reference_processing.xml:1483 reference_processing.xml:1522 608#: reference_processing.xml:1540 reference_processing.xml:1568 609#: reference_processing.xml:1610 reference_processing.xml:1683 610#: reference_processing.xml:1734 reference_processing.xml:1897 611#: reference_processing.xml:1939 reference_processing.xml:1979 612#: reference_processing.xml:2049 reference_processing.xml:2103 613#: reference_processing.xml:2161 reference_processing.xml:2212 614#: reference_processing.xml:2255 reference_processing.xml:2295 615#: reference_processing.xml:2340 reference_processing.xml:2387 616#: reference_processing.xml:2446 reference_processing.xml:2563 617#: reference_processing.xml:2652 reference_processing.xml:2729 618#: reference_processing.xml:2814 reference_processing.xml:2871 619#: reference_processing.xml:2960 reference_processing.xml:3079 620#, no-c-format 621msgid "See Also" 622msgstr "Si veda anche" 623 624#. Tag: para 625#: reference_processing.xml:263 626#, no-c-format 627msgid "" 628", <xref linkend=\"ST_DWithin\"/>, <xref linkend=\"ST_SetSRID\"/>, <xref " 629"linkend=\"ST_Transform\"/>, <xref linkend=\"ST_Union\"/>" 630msgstr "" 631", <xref linkend=\"ST_DWithin\"/>, <xref linkend=\"ST_SetSRID\"/>, <xref " 632"linkend=\"ST_Transform\"/>, <xref linkend=\"ST_Union\"/>" 633 634#. Tag: refname 635#: reference_processing.xml:269 636#, no-c-format 637msgid "ST_BuildArea" 638msgstr "ST_BuildArea" 639 640#. Tag: refpurpose 641#: reference_processing.xml:271 642#, no-c-format 643msgid "" 644"Creates an areal geometry formed by the constituent linework of given " 645"geometry" 646msgstr "" 647 648#. Tag: funcprototype 649#: reference_processing.xml:277 650#, no-c-format 651msgid "" 652"<funcdef>geometry <function>ST_BuildArea</function></funcdef> " 653"<paramdef><type>geometry </type> <parameter>A</parameter></paramdef>" 654msgstr "" 655"<funcdef>geometry <function>ST_BuildArea</function></funcdef> " 656"<paramdef><type>geometry </type> <parameter>A</parameter></paramdef>" 657 658#. Tag: para 659#: reference_processing.xml:287 660#, no-c-format 661msgid "" 662"Creates an areal geometry formed by the constituent linework of given " 663"geometry. The return type can be a Polygon or MultiPolygon, depending on " 664"input. If the input lineworks do not form polygons NULL is returned. The " 665"inputs can be LINESTRINGS, MULTILINESTRINGS, POLYGONS, MULTIPOLYGONS, and " 666"GeometryCollections." 667msgstr "" 668 669#. Tag: para 670#: reference_processing.xml:292 671#, no-c-format 672msgid "This function will assume all inner geometries represent holes" 673msgstr "" 674 675#. Tag: para 676#: reference_processing.xml:295 reference_processing.xml:1670 677#, no-c-format 678msgid "" 679"Input linework must be correctly noded for this function to work properly" 680msgstr "" 681 682#. Tag: para 683#: reference_processing.xml:298 684#, fuzzy, no-c-format 685msgid "Availability: 1.1.0" 686msgstr "Disponibilità: 1.5.0" 687 688#. Tag: para 689#: reference_processing.xml:312 690#, no-c-format 691msgid "This will create a donut" 692msgstr "" 693 694#. Tag: programlisting 695#: reference_processing.xml:315 696#, no-c-format 697msgid "" 698"SELECT ST_BuildArea(ST_Collect(smallc,bigc))\n" 699"FROM (SELECT\n" 700" ST_Buffer(\n" 701" ST_GeomFromText('POINT(100 90)'), 25) As smallc,\n" 702" ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50) As bigc) As foo;" 703msgstr "" 704"SELECT ST_BuildArea(ST_Collect(smallc,bigc))\n" 705"FROM (SELECT\n" 706" ST_Buffer(\n" 707" ST_GeomFromText('POINT(100 90)'), 25) As smallc,\n" 708" ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50) As bigc) As foo;" 709 710#. Tag: para 711#: reference_processing.xml:324 712#, no-c-format 713msgid "" 714"This will create a gaping hole inside the circle with prongs sticking out" 715msgstr "" 716 717#. Tag: programlisting 718#: reference_processing.xml:327 719#, no-c-format 720msgid "" 721"SELECT ST_BuildArea(ST_Collect(line,circle))\n" 722"FROM (SELECT\n" 723" ST_Buffer(\n" 724" ST_MakeLine(ST_MakePoint(10, 10),ST_MakePoint(190, 190)),\n" 725" 5) As line,\n" 726" ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50) As circle) As foo;\n" 727"\n" 728"--this creates the same gaping hole\n" 729"--but using linestrings instead of polygons\n" 730"SELECT ST_BuildArea(\n" 731" ST_Collect(ST_ExteriorRing(line),ST_ExteriorRing(circle))\n" 732" )\n" 733"FROM (SELECT ST_Buffer(\n" 734" ST_MakeLine(ST_MakePoint(10, 10),ST_MakePoint(190, 190))\n" 735" ,5) As line,\n" 736" ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50) As circle) As foo;" 737msgstr "" 738 739#. Tag: para 740#: reference_processing.xml:338 741#, no-c-format 742msgid "" 743", <xref linkend=\"ST_MakePolygon\"/>, <xref linkend=\"ST_BdPolyFromText\"/>, " 744"<xref linkend=\"ST_BdMPolyFromText\"/>wrappers to this function with " 745"standard OGC interface" 746msgstr "" 747", <xref linkend=\"ST_MakePolygon\"/>, <xref linkend=\"ST_BdPolyFromText\"/>, " 748"<xref linkend=\"ST_BdMPolyFromText\"/>wrappers to this function with " 749"standard OGC interface" 750 751#. Tag: refname 752#: reference_processing.xml:349 753#, no-c-format 754msgid "ST_Centroid" 755msgstr "" 756 757#. Tag: refpurpose 758#: reference_processing.xml:351 759#, no-c-format 760msgid "Returns the geometric center of a geometry." 761msgstr "" 762 763#. Tag: funcsynopsis 764#: reference_processing.xml:355 765#, fuzzy, no-c-format 766msgid "" 767"<funcprototype> <funcdef>geometry <function>ST_Centroid</function></funcdef> " 768"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> </" 769"funcprototype> <funcprototype> <funcdef>geography <function>ST_Centroid</" 770"function></funcdef> <paramdef><type>geography </type> <parameter>g1</" 771"parameter></paramdef> <paramdef choice=\"opt\"><type>boolean </type> " 772"<parameter>use_spheroid=true</parameter></paramdef> </funcprototype>" 773msgstr "" 774"<funcprototype> <funcdef>geometry <function>ST_CurveToLine</function></" 775"funcdef> <paramdef><type>geometry</type> <parameter>curveGeom</parameter></" 776"paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 777"<function>ST_CurveToLine</function></funcdef> <paramdef><type>geometry</" 778"type> <parameter>curveGeom</parameter></paramdef> <paramdef><type>integer</" 779"type> <parameter>segments_per_qtr_circle</parameter></paramdef> </" 780"funcprototype>" 781 782#. Tag: para 783#: reference_processing.xml:377 784#, no-c-format 785msgid "" 786"Computes the geometric center of a geometry, or equivalently, the center of " 787"mass of the geometry as a <varname>POINT</varname>. For [<varname>MULTI</" 788"varname>]<varname>POINT</varname>s, this is computed as the arithmetic mean " 789"of the input coordinates. For [<varname>MULTI</varname>]<varname>LINESTRING</" 790"varname>s, this is computed as the weighted length of each line segment. For " 791"[<varname>MULTI</varname>]<varname>POLYGON</varname>s, \"weight\" is thought " 792"in terms of area. If an empty geometry is supplied, an empty " 793"<varname>GEOMETRYCOLLECTION</varname> is returned. If <varname>NULL</" 794"varname> is supplied, <varname>NULL</varname> is returned. If " 795"<varname>CIRCULARSTRING</varname> or <varname>COMPOUNDCURVE</varname> are " 796"supplied, they are converted to linestring wtih CurveToLine first, then same " 797"than for <varname>LINESTRING</varname>" 798msgstr "" 799 800#. Tag: para 801#: reference_processing.xml:392 802#, no-c-format 803msgid "" 804"New in 2.3.0 : support <varname>CIRCULARSTRING</varname> and " 805"<varname>COMPOUNDCURVE</varname> (using CurveToLine)" 806msgstr "" 807 808#. Tag: para 809#: reference_processing.xml:394 810#, no-c-format 811msgid "Availability: 2.4.0 support for geography was introduced." 812msgstr "" 813 814#. Tag: para 815#: reference_processing.xml:396 816#, no-c-format 817msgid "" 818"The centroid is equal to the centroid of the set of component Geometries of " 819"highest dimension (since the lower-dimension geometries contribute zero " 820"\"weight\" to the centroid)." 821msgstr "" 822 823#. Tag: para 824#: reference_processing.xml:400 reference_processing.xml:802 825#, no-c-format 826msgid "&sfs_compliant;" 827msgstr "&sfs_compliant;" 828 829#. Tag: para 830#: reference_processing.xml:401 831#, fuzzy, no-c-format 832msgid "&sqlmm_compliant; SQL-MM 3: 8.1.4, 9.5.5" 833msgstr "&sqlmm_compliant; SQL-MM 3: 7.1.7" 834 835#. Tag: para 836#: reference_processing.xml:407 837#, no-c-format 838msgid "" 839"In each of the following illustrations, the green dot represents the " 840"centroid of the source geometry." 841msgstr "" 842 843#. Tag: para 844#: reference_processing.xml:420 845#, no-c-format 846msgid "Centroid of a <varname>MULTIPOINT</varname>" 847msgstr "" 848 849#. Tag: para 850#: reference_processing.xml:431 851#, no-c-format 852msgid "Centroid of a <varname>LINESTRING</varname>" 853msgstr "" 854 855#. Tag: para 856#: reference_processing.xml:444 857#, no-c-format 858msgid "Centroid of a <varname>POLYGON</varname>" 859msgstr "" 860 861#. Tag: para 862#: reference_processing.xml:455 863#, no-c-format 864msgid "Centroid of a <varname>GEOMETRYCOLLECTION</varname>" 865msgstr "" 866 867#. Tag: programlisting 868#: reference_processing.xml:464 869#, no-c-format 870msgid "" 871"SELECT ST_AsText(ST_Centroid('MULTIPOINT ( -1 0, -1 2, -1 3, -1 4, -1 7, 0 " 872"1, 0 3, 1 1, 2 0, 6 0, 7 8, 9 8, 10 6 )'));\n" 873" st_astext\n" 874"------------------------------------------\n" 875" POINT(2.30769230769231 3.30769230769231)\n" 876"(1 row)\n" 877"\n" 878"SELECT ST_AsText(ST_centroid(g))\n" 879"FROM ST_GeomFromText('CIRCULARSTRING(0 2, -1 1,0 0, 0.5 0, 1 0, 2 1, 1 2, " 880"0.5 2, 0 2)') AS g ;\n" 881"------------------------------------------\n" 882"POINT(0.5 1)\n" 883"\n" 884"\n" 885"SELECT ST_AsText(ST_centroid(g))\n" 886"FROM ST_GeomFromText('COMPOUNDCURVE(CIRCULARSTRING(0 2, -1 1,0 0),(0 0, 0.5 " 887"0, 1 0),CIRCULARSTRING( 1 0, 2 1, 1 2),(1 2, 0.5 2, 0 2))' ) AS g;\n" 888"------------------------------------------\n" 889"POINT(0.5 1)" 890msgstr "" 891 892#. Tag: para 893#: reference_processing.xml:470 894#, fuzzy, no-c-format 895msgid ", <xref linkend=\"ST_GeometricMedian\"/>" 896msgstr ", <xref linkend=\"ST_ConvexHull\"/>" 897 898#. Tag: refname 899#: reference_processing.xml:476 900#, no-c-format 901msgid "ST_ClipByBox2D" 902msgstr "" 903 904#. Tag: refpurpose 905#: reference_processing.xml:477 906#, no-c-format 907msgid "Returns the portion of a geometry falling within a rectangle." 908msgstr "" 909 910#. Tag: funcprototype 911#: reference_processing.xml:482 912#, no-c-format 913msgid "" 914"<funcdef>geometry <function>ST_ClipByBox2D</function></funcdef> " 915"<paramdef><type>geometry</type> <parameter>geom</parameter></paramdef> " 916"<paramdef><type>box2d</type> <parameter>box</parameter></paramdef>" 917msgstr "" 918 919#. Tag: para 920#: reference_processing.xml:493 921#, no-c-format 922msgid "" 923"Clips a geometry by a 2D box in a fast but possibly dirty way. The output " 924"geometry is not guaranteed to be valid (self-intersections for a polygon may " 925"be introduced). Topologically invalid input geometries do not result in " 926"exceptions being thrown." 927msgstr "" 928 929#. Tag: para 930#: reference_processing.xml:501 reference_processing.xml:1973 931#: reference_processing.xml:2286 reference_processing.xml:2435 932#: reference_processing.xml:2687 933#, no-c-format 934msgid "Availability: 2.2.0" 935msgstr "" 936 937#. Tag: programlisting 938#: reference_processing.xml:507 939#, no-c-format 940msgid "" 941"-- Rely on implicit cast from geometry to box2d for the second parameter\n" 942"SELECT ST_ClipByBox2D(the_geom, ST_MakeEnvelope(0,0,10,10)) FROM mytab;" 943msgstr "" 944 945#. Tag: para 946#: reference_processing.xml:511 947#, no-c-format 948msgid ", <xref linkend=\"ST_MakeBox2D\"/>, <xref linkend=\"ST_MakeEnvelope\"/>" 949msgstr "" 950 951#. Tag: refname 952#: reference_processing.xml:522 953#, no-c-format 954msgid "ST_ConcaveHull" 955msgstr "ST_ConcaveHull" 956 957#. Tag: refpurpose 958#: reference_processing.xml:523 959#, no-c-format 960msgid "" 961"The concave hull of a geometry represents a possibly concave geometry that " 962"encloses all geometries within the set. You can think of it as shrink " 963"wrapping." 964msgstr "" 965 966#. Tag: funcprototype 967#: reference_processing.xml:529 968#, no-c-format 969msgid "" 970"<funcdef>geometry <function>ST_ConcaveHull</function></funcdef> " 971"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 972"<paramdef><type>float </type> <parameter>target_percent</parameter></" 973"paramdef> <paramdef choice=\"opt\"><type>boolean </type> " 974"<parameter>allow_holes=false</parameter></paramdef>" 975msgstr "" 976"<funcdef>geometry <function>ST_ConcaveHull</function></funcdef> " 977"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 978"<paramdef><type>float </type> <parameter>target_percent</parameter></" 979"paramdef> <paramdef choice=\"opt\"><type>boolean </type> " 980"<parameter>allow_holes=false</parameter></paramdef>" 981 982#. Tag: para 983#: reference_processing.xml:540 984#, no-c-format 985msgid "" 986"The concave hull of a geometry represents a possibly concave geometry that " 987"encloses all geometries within the set. Defaults to false for allowing " 988"polygons with holes. The result is never higher than a single polygon." 989msgstr "" 990 991#. Tag: para 992#: reference_processing.xml:544 993#, no-c-format 994msgid "" 995"The target_percent is the target percent of area of convex hull the PostGIS " 996"solution will try to approach before giving up or exiting. One can think of " 997"the concave hull as the geometry you get by vacuum sealing a set of " 998"geometries. The target_percent of 1 will give you the same answer as the " 999"convex hull. A target_percent between 0 and 0.99 will give you something " 1000"that should have a smaller area than the convex hull. This is different from " 1001"a convex hull which is more like wrapping a rubber band around the set of " 1002"geometries." 1003msgstr "" 1004 1005#. Tag: para 1006#: reference_processing.xml:549 1007#, no-c-format 1008msgid "" 1009"It is usually used with MULTI and Geometry Collections. Although it is not " 1010"an aggregate - you can use it in conjunction with ST_Collect or ST_Union to " 1011"get the concave hull of a set of points/linestring/polygons " 1012"ST_ConcaveHull(ST_Collect(somepointfield), 0.80)." 1013msgstr "" 1014 1015#. Tag: para 1016#: reference_processing.xml:554 1017#, no-c-format 1018msgid "" 1019"It is much slower to compute than convex hull but encloses the geometry " 1020"better and is also useful for image recognition." 1021msgstr "" 1022 1023#. Tag: para 1024#: reference_processing.xml:557 reference_processing.xml:707 1025#: reference_processing.xml:950 reference_processing.xml:1308 1026#: reference_processing.xml:2602 1027#, no-c-format 1028msgid "Performed by the GEOS module" 1029msgstr "Eseguito dal modulo GEOS" 1030 1031#. Tag: para 1032#: reference_processing.xml:558 1033#, no-c-format 1034msgid "" 1035"Note - If you are using with points, linestrings, or geometry collections " 1036"use ST_Collect. If you are using with polygons, use ST_Union since it may " 1037"fail with invalid geometries." 1038msgstr "" 1039 1040#. Tag: para 1041#: reference_processing.xml:561 1042#, no-c-format 1043msgid "" 1044"Note - The smaller you make the target percent, the longer it takes to " 1045"process the concave hull and more likely to run into topological exceptions. " 1046"Also the more floating points and number of points you accrue. First try a " 1047"0.99 which does a first hop, is usually very fast, sometimes as fast as " 1048"computing the convex hull, and usually gives much better than 99% of shrink " 1049"since it almost always overshoots. Second hope of 0.98 it slower, others get " 1050"slower usually quadratically. To reduce precision and float points, use " 1051"<xref linkend=\"ST_SimplifyPreserveTopology\"/> or <xref linkend=" 1052"\"ST_SnapToGrid\"/> after ST_ConcaveHull. ST_SnapToGrid is a bit faster, but " 1053"could result in invalid geometries where as ST_SimplifyPreserveTopology " 1054"almost always preserves the validity of the geometry." 1055msgstr "" 1056 1057#. Tag: para 1058#: reference_processing.xml:566 1059#, no-c-format 1060msgid "" 1061"More real world examples and brief explanation of the technique are shown " 1062"<ulink url=\"http://www.bostongis.com/postgis_concavehull.snippet\">http://" 1063"www.bostongis.com/postgis_concavehull.snippet</ulink>" 1064msgstr "" 1065 1066#. Tag: para 1067#: reference_processing.xml:569 1068#, no-c-format 1069msgid "" 1070"Also check out Simon Greener's article on demonstrating ConcaveHull " 1071"introduced in Oracle 11G R2. <ulink url=\"http://www.spatialdbadvisor.com/" 1072"oracle_spatial_tips_tricks/172/concave-hull-geometries-in-" 1073"oracle-11gr2\">http://www.spatialdbadvisor.com/" 1074"oracle_spatial_tips_tricks/172/concave-hull-geometries-in-oracle-11gr2</" 1075"ulink>. The solution we get at 0.75 target percent of convex hull is similar " 1076"to the shape Simon gets with Oracle SDO_CONCAVEHULL_BOUNDARY." 1077msgstr "" 1078 1079#. Tag: para 1080#: reference_processing.xml:573 reference_processing.xml:1027 1081#: reference_processing.xml:1424 reference_processing.xml:1720 1082#: reference_processing.xml:2007 reference_processing.xml:2479 1083#: reference_processing.xml:2865 1084#, no-c-format 1085msgid "Availability: 2.0.0" 1086msgstr "Disponibilità: 2.0" 1087 1088#. Tag: programlisting 1089#: reference_processing.xml:578 1090#, no-c-format 1091msgid "" 1092"--Get estimate of infected area based on point observations\n" 1093"SELECT d.disease_type,\n" 1094" ST_ConcaveHull(ST_Collect(d.pnt_geom), 0.99) As geom\n" 1095" FROM disease_obs As d\n" 1096" GROUP BY d.disease_type;" 1097msgstr "" 1098 1099#. Tag: para 1100#: reference_processing.xml:588 1101#, no-c-format 1102msgid "ST_ConcaveHull of 2 polygons encased in target 100% shrink concave hull" 1103msgstr "" 1104 1105#. Tag: programlisting 1106#: reference_processing.xml:591 1107#, fuzzy, no-c-format 1108msgid "" 1109"-- geometries overlaid with concavehull\n" 1110"-- at target 100% shrink (this is the same as convex hull - since no " 1111"shrink)\n" 1112"SELECT\n" 1113" ST_ConcaveHull(\n" 1114" ST_Union(ST_GeomFromText('POLYGON((175 150, 20 40,\n" 1115" 50 60, 125 100, 175 150))'),\n" 1116" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 1117" ), 1)\n" 1118" As convexhull;" 1119msgstr "" 1120"SELECT \n" 1121" ST_DelaunayTriangles(\n" 1122" ST_Union(ST_GeomFromText('POLYGON((175 150, 20 40, \n" 1123" 50 60, 125 100, 175 150))'),\n" 1124" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 1125" ),0.001,1) \n" 1126" As dtriag;" 1127 1128#. Tag: para 1129#: reference_processing.xml:598 1130#, no-c-format 1131msgid "" 1132"-- geometries overlaid with concavehull at target 90% of convex hull area" 1133msgstr "" 1134 1135#. Tag: programlisting 1136#: reference_processing.xml:602 1137#, fuzzy, no-c-format 1138msgid "" 1139"-- geometries overlaid with concavehull at target 90% shrink\n" 1140"SELECT\n" 1141" ST_ConcaveHull(\n" 1142" ST_Union(ST_GeomFromText('POLYGON((175 150, 20 40,\n" 1143" 50 60, 125 100, 175 150))'),\n" 1144" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 1145" ), 0.9)\n" 1146" As target_90;" 1147msgstr "" 1148"SELECT \n" 1149" ST_DelaunayTriangles(\n" 1150" ST_Union(ST_GeomFromText('POLYGON((175 150, 20 40, \n" 1151" 50 60, 125 100, 175 150))'),\n" 1152" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 1153" ),0.001,1) \n" 1154" As dtriag;" 1155 1156#. Tag: para 1157#: reference_processing.xml:611 1158#, no-c-format 1159msgid "L Shape points overlaid with convex hull" 1160msgstr "" 1161 1162#. Tag: programlisting 1163#: reference_processing.xml:614 1164#, no-c-format 1165msgid "" 1166"-- this produces a table of 42 points that form an L shape\n" 1167"SELECT (ST_DumpPoints(ST_GeomFromText(\n" 1168"'MULTIPOINT(14 14,34 14,54 14,74 14,94 14,114 14,134 14,\n" 1169"150 14,154 14,154 6,134 6,114 6,94 6,74 6,54 6,34 6,\n" 1170"14 6,10 6,8 6,7 7,6 8,6 10,6 30,6 50,6 70,6 90,6 110,6 130,\n" 1171"6 150,6 170,6 190,6 194,14 194,14 174,14 154,14 134,14 114,\n" 1172"14 94,14 74,14 54,14 34,14 14)'))).geom\n" 1173" INTO TABLE l_shape;\n" 1174"\n" 1175"SELECT ST_ConvexHull(ST_Collect(geom))\n" 1176"FROM l_shape;" 1177msgstr "" 1178 1179#. Tag: para 1180#: reference_processing.xml:621 1181#, no-c-format 1182msgid "ST_ConcaveHull of L points at target 99% of convex hull" 1183msgstr "" 1184 1185#. Tag: programlisting 1186#: reference_processing.xml:624 1187#, no-c-format 1188msgid "" 1189"SELECT ST_ConcaveHull(ST_Collect(geom), 0.99)\n" 1190" FROM l_shape;" 1191msgstr "" 1192 1193#. Tag: para 1194#: reference_processing.xml:633 1195#, no-c-format 1196msgid "Concave Hull of L points at target 80% convex hull area" 1197msgstr "" 1198 1199#. Tag: programlisting 1200#: reference_processing.xml:636 1201#, no-c-format 1202msgid "" 1203"-- Concave Hull L shape points\n" 1204" -- at target 80% of convexhull\n" 1205" SELECT ST_ConcaveHull(ST_Collect(geom), 0.80)\n" 1206" FROM l_shape;" 1207msgstr "" 1208 1209#. Tag: para 1210#: reference_processing.xml:645 1211#, no-c-format 1212msgid "multilinestring overlaid with Convex hull" 1213msgstr "" 1214 1215#. Tag: para 1216#: reference_processing.xml:653 1217#, no-c-format 1218msgid "" 1219"multilinestring with overlaid with Concave hull of linestrings at 99% target " 1220"-- first hop" 1221msgstr "" 1222 1223#. Tag: programlisting 1224#: reference_processing.xml:657 1225#, no-c-format 1226msgid "" 1227"SELECT ST_ConcaveHull(ST_GeomFromText('MULTILINESTRING((106 164,30 112,74 " 1228"70,82 112,130 94,\n" 1229" 130 62,122 40,156 32,162 76,172 88),\n" 1230"(132 178,134 148,128 136,96 128,132 108,150 130,\n" 1231"170 142,174 110,156 96,158 90,158 88),\n" 1232"(22 64,66 28,94 38,94 68,114 76,112 30,\n" 1233"132 10,168 18,178 34,186 52,184 74,190 100,\n" 1234"190 122,182 148,178 170,176 184,156 164,146 178,\n" 1235"132 186,92 182,56 158,36 150,62 150,76 128,88 118))'),0.99)" 1236msgstr "" 1237"SELECT ST_ConcaveHull(ST_GeomFromText('MULTILINESTRING((106 164,30 112,74 " 1238"70,82 112,130 94,\n" 1239" 130 62,122 40,156 32,162 76,172 88),\n" 1240"(132 178,134 148,128 136,96 128,132 108,150 130,\n" 1241"170 142,174 110,156 96,158 90,158 88),\n" 1242"(22 64,66 28,94 38,94 68,114 76,112 30,\n" 1243"132 10,168 18,178 34,186 52,184 74,190 100,\n" 1244"190 122,182 148,178 170,176 184,156 164,146 178,\n" 1245"132 186,92 182,56 158,36 150,62 150,76 128,88 118))'),0.99)" 1246 1247#. Tag: para 1248#: reference_processing.xml:667 1249#, no-c-format 1250msgid "" 1251", <xref linkend=\"ST_ConvexHull\"/>, <xref linkend=" 1252"\"ST_SimplifyPreserveTopology\"/>, <xref linkend=\"ST_SnapToGrid\"/>" 1253msgstr "" 1254", <xref linkend=\"ST_ConvexHull\"/>, <xref linkend=" 1255"\"ST_SimplifyPreserveTopology\"/>, <xref linkend=\"ST_SnapToGrid\"/>" 1256 1257#. Tag: refname 1258#: reference_processing.xml:673 1259#, no-c-format 1260msgid "ST_ConvexHull" 1261msgstr "ST_ConvexHull" 1262 1263#. Tag: refpurpose 1264#: reference_processing.xml:674 1265#, no-c-format 1266msgid "Computes the convex hull of a geometry." 1267msgstr "" 1268 1269#. Tag: funcprototype 1270#: reference_processing.xml:679 1271#, no-c-format 1272msgid "" 1273"<funcdef>geometry <function>ST_ConvexHull</function></funcdef> " 1274"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 1275msgstr "" 1276"<funcdef>geometry <function>ST_ConvexHull</function></funcdef> " 1277"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 1278 1279#. Tag: para 1280#: reference_processing.xml:688 1281#, no-c-format 1282msgid "" 1283"Computes the convex hull of a geometry. The convex hull is the smallest " 1284"convex geometry that encloses all geometries in the input." 1285msgstr "" 1286 1287#. Tag: para 1288#: reference_processing.xml:692 1289#, no-c-format 1290msgid "" 1291"In the general case the convex hull is a Polygon. The convext hull of two or " 1292"more collinear points is a two-point LineString. The convex hull of one or " 1293"more identical points is a Point." 1294msgstr "" 1295 1296#. Tag: para 1297#: reference_processing.xml:696 1298#, no-c-format 1299msgid "" 1300"It is usually used with Multi* and GeometryCollections. It is not an " 1301"aggregate function. To compute the convex hull of a set of geometries, use " 1302"<xref linkend=\"ST_Collect\"/> to aggregate them." 1303msgstr "" 1304 1305#. Tag: para 1306#: reference_processing.xml:701 1307#, no-c-format 1308msgid "" 1309"One can think of the convex hull as the geometry obtained by wrapping an " 1310"elastic band around a set of geometries. This is different from a concave " 1311"hull which is analogous to \"shrink-wrapping\" the geometries. A convex hull " 1312"is often used to determine an affected area based on a set of point " 1313"observations." 1314msgstr "" 1315 1316#. Tag: para 1317#: reference_processing.xml:710 1318#, no-c-format 1319msgid "&sqlmm_compliant; SQL-MM 3: 5.1.16" 1320msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.16" 1321 1322#. Tag: para 1323#: reference_processing.xml:711 reference_processing.xml:804 1324#: reference_processing.xml:856 reference_processing.xml:1029 1325#: reference_processing.xml:1221 reference_processing.xml:1363 1326#: reference_processing.xml:1428 reference_processing.xml:1471 1327#: reference_processing.xml:1718 reference_processing.xml:1929 1328#: reference_processing.xml:1975 reference_processing.xml:2087 1329#: reference_processing.xml:2145 reference_processing.xml:2863 1330#, no-c-format 1331msgid "&Z_support;" 1332msgstr "&Z_support;" 1333 1334#. Tag: para 1335#: reference_processing.xml:723 1336#, no-c-format 1337msgid "Convex Hull of a MultiLinestring and a MultiPoint" 1338msgstr "" 1339 1340#. Tag: programlisting 1341#: reference_processing.xml:726 1342#, no-c-format 1343msgid "" 1344"SELECT ST_AsText(ST_ConvexHull(\n" 1345" ST_Collect(\n" 1346" ST_GeomFromText('MULTILINESTRING((100 190,10 8),(150 10, 20 " 1347"30))'),\n" 1348" ST_GeomFromText('MULTIPOINT(50 5, 150 30, 50 10, 10 " 1349"10)')\n" 1350" )) );\n" 1351"---st_astext--\n" 1352"POLYGON((50 5,10 8,10 10,100 190,150 30,150 10,50 5))" 1353msgstr "" 1354"SELECT ST_AsText(ST_ConvexHull(\n" 1355" ST_Collect(\n" 1356" ST_GeomFromText('MULTILINESTRING((100 190,10 8),(150 10, 20 " 1357"30))'),\n" 1358" ST_GeomFromText('MULTIPOINT(50 5, 150 30, 50 10, 10 " 1359"10)')\n" 1360" )) );\n" 1361"---st_astext--\n" 1362"POLYGON((50 5,10 8,10 10,100 190,150 30,150 10,50 5))" 1363 1364#. Tag: para 1365#: reference_processing.xml:729 1366#, no-c-format 1367msgid "Using with ST_Collect to compute the convex hulls of geometry sets." 1368msgstr "" 1369 1370#. Tag: programlisting 1371#: reference_processing.xml:731 1372#, no-c-format 1373msgid "" 1374"--Get estimate of infected area based on point observations\n" 1375"SELECT d.disease_type,\n" 1376" ST_ConvexHull(ST_Collect(d.the_geom)) As the_geom\n" 1377" FROM disease_obs As d\n" 1378" GROUP BY d.disease_type;" 1379msgstr "" 1380 1381#. Tag: para 1382#: reference_processing.xml:736 1383#, no-c-format 1384msgid "" 1385", <xref linkend=\"ST_ConcaveHull\"/>, <xref linkend=" 1386"\"ST_MinimumBoundingCircle\"/>" 1387msgstr "" 1388", <xref linkend=\"ST_ConcaveHull\"/>, <xref linkend=" 1389"\"ST_MinimumBoundingCircle\"/>" 1390 1391#. Tag: refname 1392#: reference_processing.xml:742 1393#, no-c-format 1394msgid "ST_CurveToLine" 1395msgstr "ST_CurveToLine" 1396 1397#. Tag: refpurpose 1398#: reference_processing.xml:744 1399#, fuzzy, no-c-format 1400msgid "" 1401"Converts a CIRCULARSTRING/CURVEPOLYGON/MULTISURFACE to a LINESTRING/POLYGON/" 1402"MULTIPOLYGON" 1403msgstr "Converte un CIRCULARSTRING/CURVEDPOLYGON in LINESTRING/POLYGON" 1404 1405#. Tag: funcprototype 1406#: reference_processing.xml:749 1407#, fuzzy, no-c-format 1408msgid "" 1409"<funcdef>geometry <function>ST_CurveToLine</function></funcdef> " 1410"<paramdef><type>geometry</type> <parameter>curveGeom</parameter></paramdef> " 1411"<paramdef><type>float</type> <parameter>tolerance</parameter></paramdef> " 1412"<paramdef choice=\"opt\"><type>integer</type> <parameter>tolerance_type</" 1413"parameter></paramdef> <paramdef choice=\"opt\"><type>integer</type> " 1414"<parameter>flags</parameter></paramdef>" 1415msgstr "" 1416"<funcdef>geometry <function>ST_OffsetCurve</function></funcdef> " 1417"<paramdef><type>geometry </type> <parameter>line</parameter></paramdef> " 1418"<paramdef><type>float </type> <parameter>signed_distance</parameter></" 1419"paramdef> <paramdef choice=\"opt\"><type>text </type> " 1420"<parameter>style_parameters=''</parameter></paramdef>" 1421 1422#. Tag: para 1423#: reference_processing.xml:762 1424#, no-c-format 1425msgid "" 1426"Converts a CIRCULAR STRING to regular LINESTRING or CURVEPOLYGON to POLYGON " 1427"or MULTISURFACE to MULTIPOLYGON. Useful for outputting to devices that can't " 1428"support CIRCULARSTRING geometry types" 1429msgstr "" 1430 1431#. Tag: para 1432#: reference_processing.xml:764 1433#, no-c-format 1434msgid "" 1435"Converts a given geometry to a linear geometry. Each curved geometry or " 1436"segment is converted into a linear approximation using the given `tolerance` " 1437"and options (32 segments per quadrant and no options by default)." 1438msgstr "" 1439 1440#. Tag: para 1441#: reference_processing.xml:769 1442#, no-c-format 1443msgid "" 1444"The 'tolerance_type' argument determines interpretation of the `tolerance` " 1445"argument. It can take the following values:" 1446msgstr "" 1447 1448#. Tag: para 1449#: reference_processing.xml:774 1450#, no-c-format 1451msgid "0 (default): Tolerance is max segments per quadrant." 1452msgstr "" 1453 1454#. Tag: para 1455#: reference_processing.xml:777 1456#, no-c-format 1457msgid "1: Tolerance is max-deviation of line from curve, in source units." 1458msgstr "" 1459 1460#. Tag: para 1461#: reference_processing.xml:780 1462#, no-c-format 1463msgid "2: Tolerance is max-angle, in radians, between generating radii." 1464msgstr "" 1465 1466#. Tag: para 1467#: reference_processing.xml:785 1468#, no-c-format 1469msgid "The 'flags' argument is a bitfield. 0 by default. Supported bits are:" 1470msgstr "" 1471 1472#. Tag: para 1473#: reference_processing.xml:790 1474#, no-c-format 1475msgid "1: Symmetric (orientation idependent) output." 1476msgstr "" 1477 1478#. Tag: para 1479#: reference_processing.xml:793 1480#, no-c-format 1481msgid "" 1482"2: Retain angle, avoids reducing angles (segment lengths) when producing " 1483"symmetric output. Has no effect when Symmetric flag is off." 1484msgstr "" 1485 1486#. Tag: para 1487#: reference_processing.xml:798 reference_processing.xml:1362 1488#, fuzzy, no-c-format 1489msgid "Availability: 1.3.0" 1490msgstr "Disponibilità: 1.5.0" 1491 1492#. Tag: para 1493#: reference_processing.xml:799 1494#, no-c-format 1495msgid "" 1496"Enhanced: 2.4.0 added support for max-deviation and max-angle tolerance, and " 1497"for symmetric output." 1498msgstr "" 1499 1500#. Tag: para 1501#: reference_processing.xml:800 1502#, no-c-format 1503msgid "" 1504"Enhanced: 3.0.0 implemented a minimum number of segments per linearized arc " 1505"to prevent topological collapse." 1506msgstr "" 1507 1508#. Tag: para 1509#: reference_processing.xml:803 1510#, no-c-format 1511msgid "&sqlmm_compliant; SQL-MM 3: 7.1.7" 1512msgstr "&sqlmm_compliant; SQL-MM 3: 7.1.7" 1513 1514#. Tag: para 1515#: reference_processing.xml:805 reference_processing.xml:1028 1516#: reference_processing.xml:1364 1517#, no-c-format 1518msgid "&curve_support;" 1519msgstr "&curve_support;" 1520 1521#. Tag: programlisting 1522#: reference_processing.xml:812 1523#, fuzzy, no-c-format 1524msgid "" 1525"SELECT ST_AsText(ST_CurveToLine(ST_GeomFromText('CIRCULARSTRING(220268 " 1526"150415,220227 150505,220227 150406)')));\n" 1527"\n" 1528"--Result --\n" 1529" LINESTRING(220268 150415,220269.95064912 150416.539364228,220271.823415575 " 1530"150418.17258804,220273.613787707 150419.895736857,\n" 1531" 220275.317452352 150421.704659462,220276.930305234 " 1532"150423.594998003,220278.448460847 150425.562198489,\n" 1533" 220279.868261823 150427.60152176,220281.186287736 " 1534"150429.708054909,220282.399363347 150431.876723113,\n" 1535" 220283.50456625 150434.10230186,220284.499233914 " 1536"150436.379429536,220285.380970099 150438.702620341,220286.147650624 " 1537"150441.066277505,\n" 1538" 220286.797428488 150443.464706771,220287.328738321 " 1539"150445.892130112,220287.740300149 150448.342699654,\n" 1540" 220288.031122486 150450.810511759,220288.200504713 " 1541"150453.289621251,220288.248038775 150455.77405574,\n" 1542" 220288.173610157 150458.257830005,220287.977398166 " 1543"150460.734960415,220287.659875492 150463.199479347,\n" 1544" 220287.221807076 150465.64544956,220286.664248262 " 1545"150468.066978495,220285.988542259 150470.458232479,220285.196316903 " 1546"150472.81345077,\n" 1547" 220284.289480732 150475.126959442,220283.270218395 " 1548"150477.39318505,220282.140985384 150479.606668057,\n" 1549" 220280.90450212 150481.762075989,220279.5637474 " 1550"150483.85421628,220278.12195122 150485.87804878,\n" 1551" 220276.582586992 150487.828697901,220274.949363179 " 1552"150489.701464356,220273.226214362 150491.491836488,\n" 1553" 220271.417291757 150493.195501133,220269.526953216 " 1554"150494.808354014,220267.559752731 150496.326509628,\n" 1555" 220265.520429459 150497.746310603,220263.41389631 " 1556"150499.064336517,220261.245228106 150500.277412127,\n" 1557" 220259.019649359 150501.38261503,220256.742521683 " 1558"150502.377282695,220254.419330878 150503.259018879,\n" 1559" 220252.055673714 150504.025699404,220249.657244448 " 1560"150504.675477269,220247.229821107 150505.206787101,\n" 1561" 220244.779251566 150505.61834893,220242.311439461 " 1562"150505.909171266,220239.832329968 150506.078553494,\n" 1563" 220237.347895479 150506.126087555,220234.864121215 " 1564"150506.051658938,220232.386990804 150505.855446946,\n" 1565" 220229.922471872 150505.537924272,220227.47650166 " 1566"150505.099855856,220225.054972724 150504.542297043,\n" 1567" 220222.663718741 150503.86659104,220220.308500449 150503.074365683,\n" 1568" 220217.994991777 150502.167529512,220215.72876617 150501.148267175,\n" 1569" 220213.515283163 150500.019034164,220211.35987523 150498.7825509,\n" 1570" 220209.267734939 150497.441796181,220207.243902439 150496,\n" 1571" 220205.293253319 150494.460635772,220203.420486864 " 1572"150492.82741196,220201.630114732 150491.104263143,\n" 1573" 220199.926450087 150489.295340538,220198.313597205 " 1574"150487.405001997,220196.795441592 150485.437801511,\n" 1575" 220195.375640616 150483.39847824,220194.057614703 " 1576"150481.291945091,220192.844539092 150479.123276887,220191.739336189 " 1577"150476.89769814,\n" 1578" 220190.744668525 150474.620570464,220189.86293234 " 1579"150472.297379659,220189.096251815 150469.933722495,\n" 1580" 220188.446473951 150467.535293229,220187.915164118 " 1581"150465.107869888,220187.50360229 150462.657300346,\n" 1582" 220187.212779953 150460.189488241,220187.043397726 " 1583"150457.710378749,220186.995863664 150455.22594426,\n" 1584" 220187.070292282 150452.742169995,220187.266504273 " 1585"150450.265039585,220187.584026947 150447.800520653,\n" 1586" 220188.022095363 150445.35455044,220188.579654177 " 1587"150442.933021505,220189.25536018 150440.541767521,\n" 1588" 220190.047585536 150438.18654923,220190.954421707 " 1589"150435.873040558,220191.973684044 150433.60681495,\n" 1590" 220193.102917055 150431.393331943,220194.339400319 " 1591"150429.237924011,220195.680155039 150427.14578372,220197.12195122 " 1592"150425.12195122,\n" 1593" 220198.661315447 150423.171302099,220200.29453926 " 1594"150421.298535644,220202.017688077 150419.508163512,220203.826610682 " 1595"150417.804498867,\n" 1596" 220205.716949223 150416.191645986,220207.684149708 " 1597"150414.673490372,220209.72347298 150413.253689397,220211.830006129 " 1598"150411.935663483,\n" 1599" 220213.998674333 150410.722587873,220216.22425308 " 1600"150409.61738497,220218.501380756 150408.622717305,220220.824571561 " 1601"150407.740981121,\n" 1602" 220223.188228725 150406.974300596,220225.586657991 150406.324522731,220227 " 1603"150406)\n" 1604"\n" 1605"--3d example\n" 1606"SELECT ST_AsEWKT(ST_CurveToLine(ST_GeomFromEWKT('CIRCULARSTRING(220268 " 1607"150415 1,220227 150505 2,220227 150406 3)')));\n" 1608"Output\n" 1609"------\n" 1610" LINESTRING(220268 150415 1,220269.95064912 150416.539364228 " 1611"1.0181172856673,\n" 1612" 220271.823415575 150418.17258804 1.03623457133459,220273.613787707 " 1613"150419.895736857 1.05435185700189,....AD INFINITUM ....\n" 1614" 220225.586657991 150406.324522731 1.32611114201132,220227 150406 3)\n" 1615"\n" 1616"--use only 2 segments to approximate quarter circle\n" 1617"SELECT ST_AsText(ST_CurveToLine(ST_GeomFromText('CIRCULARSTRING(220268 " 1618"150415,220227 150505,220227 150406)'),2));\n" 1619"st_astext\n" 1620"------------------------------\n" 1621" LINESTRING(220268 150415,220287.740300149 150448.342699654,220278.12195122 " 1622"150485.87804878,\n" 1623" 220244.779251566 150505.61834893,220207.243902439 150496,220187.50360229 " 1624"150462.657300346,\n" 1625" 220197.12195122 150425.12195122,220227 150406)\n" 1626"\n" 1627"-- Ensure approximated line is no further than 20 units away from\n" 1628"-- original curve, and make the result direction-neutral\n" 1629"SELECT ST_AsText(ST_CurveToLine(\n" 1630" 'CIRCULARSTRING(0 0,100 -100,200 0)'::geometry,\n" 1631" 20, -- Tolerance\n" 1632" 1, -- Above is max distance between curve and line\n" 1633" 1 -- Symmetric flag\n" 1634"));\n" 1635"st_astext\n" 1636"-------------------------------------------------------------------------------------------\n" 1637" LINESTRING(0 0,50 -86.6025403784438,150 -86.6025403784439,200 " 1638"-1.1331077795296e-13,200 0)" 1639msgstr "" 1640"SELECT ST_AsText(ST_CurveToLine(ST_GeomFromText('CIRCULARSTRING(220268 " 1641"150415,220227 150505,220227 150406)')));\n" 1642"\n" 1643"--Result --\n" 1644" LINESTRING(220268 150415,220269.95064912 150416.539364228,220271.823415575 " 1645"150418.17258804,220273.613787707 150419.895736857,\n" 1646" 220275.317452352 150421.704659462,220276.930305234 " 1647"150423.594998003,220278.448460847 150425.562198489,\n" 1648" 220279.868261823 150427.60152176,220281.186287736 " 1649"150429.708054909,220282.399363347 150431.876723113,\n" 1650" 220283.50456625 150434.10230186,220284.499233914 " 1651"150436.379429536,220285.380970099 150438.702620341,220286.147650624 " 1652"150441.066277505,\n" 1653" 220286.797428488 150443.464706771,220287.328738321 " 1654"150445.892130112,220287.740300149 150448.342699654,\n" 1655" 220288.031122486 150450.810511759,220288.200504713 " 1656"150453.289621251,220288.248038775 150455.77405574,\n" 1657" 220288.173610157 150458.257830005,220287.977398166 " 1658"150460.734960415,220287.659875492 150463.199479347,\n" 1659" 220287.221807076 150465.64544956,220286.664248262 " 1660"150468.066978495,220285.988542259 150470.458232479,220285.196316903 " 1661"150472.81345077,\n" 1662" 220284.289480732 150475.126959442,220283.270218395 " 1663"150477.39318505,220282.140985384 150479.606668057,\n" 1664" 220280.90450212 150481.762075989,220279.5637474 " 1665"150483.85421628,220278.12195122 150485.87804878,\n" 1666" 220276.582586992 150487.828697901,220274.949363179 " 1667"150489.701464356,220273.226214362 150491.491836488,\n" 1668" 220271.417291757 150493.195501133,220269.526953216 " 1669"150494.808354014,220267.559752731 150496.326509628,\n" 1670" 220265.520429459 150497.746310603,220263.41389631 " 1671"150499.064336517,220261.245228106 150500.277412127,\n" 1672" 220259.019649359 150501.38261503,220256.742521683 " 1673"150502.377282695,220254.419330878 150503.259018879,\n" 1674" 220252.055673714 150504.025699404,220249.657244448 " 1675"150504.675477269,220247.229821107 150505.206787101,\n" 1676" 220244.779251566 150505.61834893,220242.311439461 " 1677"150505.909171266,220239.832329968 150506.078553494,\n" 1678" 220237.347895479 150506.126087555,220234.864121215 " 1679"150506.051658938,220232.386990804 150505.855446946,\n" 1680" 220229.922471872 150505.537924272,220227.47650166 " 1681"150505.099855856,220225.054972724 150504.542297043,\n" 1682" 220222.663718741 150503.86659104,220220.308500449 150503.074365683,\n" 1683" 220217.994991777 150502.167529512,220215.72876617 150501.148267175,\n" 1684" 220213.515283163 150500.019034164,220211.35987523 150498.7825509,\n" 1685" 220209.267734939 150497.441796181,220207.243902439 150496,\n" 1686" 220205.293253319 150494.460635772,220203.420486864 " 1687"150492.82741196,220201.630114732 150491.104263143,\n" 1688" 220199.926450087 150489.295340538,220198.313597205 " 1689"150487.405001997,220196.795441592 150485.437801511,\n" 1690" 220195.375640616 150483.39847824,220194.057614703 " 1691"150481.291945091,220192.844539092 150479.123276887,220191.739336189 " 1692"150476.89769814,\n" 1693" 220190.744668525 150474.620570464,220189.86293234 " 1694"150472.297379659,220189.096251815 150469.933722495,\n" 1695" 220188.446473951 150467.535293229,220187.915164118 " 1696"150465.107869888,220187.50360229 150462.657300346,\n" 1697" 220187.212779953 150460.189488241,220187.043397726 " 1698"150457.710378749,220186.995863664 150455.22594426,\n" 1699" 220187.070292282 150452.742169995,220187.266504273 " 1700"150450.265039585,220187.584026947 150447.800520653,\n" 1701" 220188.022095363 150445.35455044,220188.579654177 " 1702"150442.933021505,220189.25536018 150440.541767521,\n" 1703" 220190.047585536 150438.18654923,220190.954421707 " 1704"150435.873040558,220191.973684044 150433.60681495,\n" 1705" 220193.102917055 150431.393331943,220194.339400319 " 1706"150429.237924011,220195.680155039 150427.14578372,220197.12195122 " 1707"150425.12195122,\n" 1708" 220198.661315447 150423.171302099,220200.29453926 " 1709"150421.298535644,220202.017688077 150419.508163512,220203.826610682 " 1710"150417.804498867,\n" 1711" 220205.716949223 150416.191645986,220207.684149708 " 1712"150414.673490372,220209.72347298 150413.253689397,220211.830006129 " 1713"150411.935663483,\n" 1714" 220213.998674333 150410.722587873,220216.22425308 " 1715"150409.61738497,220218.501380756 150408.622717305,220220.824571561 " 1716"150407.740981121,\n" 1717" 220223.188228725 150406.974300596,220225.586657991 150406.324522731,220227 " 1718"150406)\n" 1719"\n" 1720"--3d example\n" 1721"SELECT ST_AsEWKT(ST_CurveToLine(ST_GeomFromEWKT('CIRCULARSTRING(220268 " 1722"150415 1,220227 150505 2,220227 150406 3)')));\n" 1723"Output\n" 1724"------\n" 1725" LINESTRING(220268 150415 1,220269.95064912 150416.539364228 " 1726"1.0181172856673,\n" 1727" 220271.823415575 150418.17258804 1.03623457133459,220273.613787707 " 1728"150419.895736857 1.05435185700189,....AD INFINITUM ....\n" 1729" 220225.586657991 150406.324522731 1.32611114201132,220227 150406 3)\n" 1730"\n" 1731"--use only 2 segments to approximate quarter circle\n" 1732"SELECT ST_AsText(ST_CurveToLine(ST_GeomFromText('CIRCULARSTRING(220268 " 1733"150415,220227 150505,220227 150406)'),2));\n" 1734"st_astext\n" 1735"------------------------------\n" 1736" LINESTRING(220268 150415,220287.740300149 150448.342699654,220278.12195122 " 1737"150485.87804878,\n" 1738" 220244.779251566 150505.61834893,220207.243902439 150496,220187.50360229 " 1739"150462.657300346,\n" 1740" 220197.12195122 150425.12195122,220227 150406)" 1741 1742#. Tag: refname 1743#: reference_processing.xml:825 1744#, no-c-format 1745msgid "ST_DelaunayTriangles" 1746msgstr "ST_DelaunayTriangles" 1747 1748#. Tag: refpurpose 1749#: reference_processing.xml:827 1750#, no-c-format 1751msgid "Return a Delaunay triangulation around the given input points." 1752msgstr "" 1753 1754#. Tag: funcprototype 1755#: reference_processing.xml:834 1756#, no-c-format 1757msgid "" 1758"<funcdef>geometry <function>ST_DelaunayTriangles</function></funcdef> " 1759"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 1760"<paramdef><type>float </type> <parameter>tolerance</parameter></paramdef> " 1761"<paramdef><type>int4 </type> <parameter>flags</parameter></paramdef>" 1762msgstr "" 1763 1764#. Tag: para 1765#: reference_processing.xml:846 1766#, no-c-format 1767msgid "" 1768"Return a <ulink url=\"http://en.wikipedia.org/wiki/Delaunay_triangulation" 1769"\">Delaunay triangulation</ulink> around the vertices of the input geometry. " 1770"Output is a COLLECTION of polygons (for flags=0) or a MULTILINESTRING (for " 1771"flags=1) or TIN (for flags=2). The tolerance, if any, is used to snap input " 1772"vertices togheter." 1773msgstr "" 1774 1775#. Tag: para 1776#: reference_processing.xml:855 1777#, fuzzy, no-c-format 1778msgid "Availability: 2.1.0" 1779msgstr "Disponibilità: 2.0" 1780 1781#. Tag: para 1782#: reference_processing.xml:857 reference_processing.xml:1032 1783#: reference_processing.xml:2091 1784#, no-c-format 1785msgid "&T_support;" 1786msgstr "&T_support;" 1787 1788#. Tag: title 1789#: reference_processing.xml:861 1790#, no-c-format 1791msgid "2D Examples" 1792msgstr "" 1793 1794#. Tag: para 1795#: reference_processing.xml:870 1796#, no-c-format 1797msgid "Original polygons" 1798msgstr "" 1799 1800#. Tag: programlisting 1801#: reference_processing.xml:873 1802#, fuzzy, no-c-format 1803msgid "" 1804"-- our original geometry --\n" 1805" ST_Union(ST_GeomFromText('POLYGON((175 150, 20 40,\n" 1806" 50 60, 125 100, 175 150))'),\n" 1807" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 1808" )" 1809msgstr "" 1810"--la geometria originale --\n" 1811" ST_Union(ST_GeomFromText('POLYGON((175 150, 20 40, \n" 1812" 50 60, 125 100, 175 150))'),\n" 1813" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 1814" )" 1815 1816#. Tag: para 1817#: reference_processing.xml:881 1818#, no-c-format 1819msgid "" 1820"ST_DelaunayTriangles of 2 polygons: delaunay triangle polygons each triangle " 1821"themed in different color" 1822msgstr "" 1823 1824#. Tag: programlisting 1825#: reference_processing.xml:884 1826#, fuzzy, no-c-format 1827msgid "" 1828"-- geometries overlaid multilinestring triangles\n" 1829"SELECT\n" 1830" ST_DelaunayTriangles(\n" 1831" ST_Union(ST_GeomFromText('POLYGON((175 150, 20 40,\n" 1832" 50 60, 125 100, 175 150))'),\n" 1833" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 1834" ))\n" 1835" As dtriag;" 1836msgstr "" 1837"SELECT \n" 1838" ST_DelaunayTriangles(\n" 1839" ST_Union(ST_GeomFromText('POLYGON((175 150, 20 40, \n" 1840" 50 60, 125 100, 175 150))'),\n" 1841" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 1842" ),0.001,1) \n" 1843" As dtriag;" 1844 1845#. Tag: para 1846#: reference_processing.xml:891 1847#, no-c-format 1848msgid "-- delaunay triangles as multilinestring" 1849msgstr "" 1850 1851#. Tag: programlisting 1852#: reference_processing.xml:894 1853#, fuzzy, no-c-format 1854msgid "" 1855"SELECT\n" 1856" ST_DelaunayTriangles(\n" 1857" ST_Union(ST_GeomFromText('POLYGON((175 150, 20 40,\n" 1858" 50 60, 125 100, 175 150))'),\n" 1859" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 1860" ),0.001,1)\n" 1861" As dtriag;" 1862msgstr "" 1863"SELECT \n" 1864" ST_DelaunayTriangles(\n" 1865" ST_Union(ST_GeomFromText('POLYGON((175 150, 20 40, \n" 1866" 50 60, 125 100, 175 150))'),\n" 1867" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 1868" ),0.001,1) \n" 1869" As dtriag;" 1870 1871#. Tag: para 1872#: reference_processing.xml:902 1873#, no-c-format 1874msgid "-- delaunay triangles of 45 points as 55 triangle polygons" 1875msgstr "" 1876 1877#. Tag: programlisting 1878#: reference_processing.xml:905 1879#, no-c-format 1880msgid "" 1881"-- this produces a table of 42 points that form an L shape\n" 1882"SELECT (ST_DumpPoints(ST_GeomFromText(\n" 1883"'MULTIPOINT(14 14,34 14,54 14,74 14,94 14,114 14,134 14,\n" 1884"150 14,154 14,154 6,134 6,114 6,94 6,74 6,54 6,34 6,\n" 1885"14 6,10 6,8 6,7 7,6 8,6 10,6 30,6 50,6 70,6 90,6 110,6 130,\n" 1886"6 150,6 170,6 190,6 194,14 194,14 174,14 154,14 134,14 114,\n" 1887"14 94,14 74,14 54,14 34,14 14)'))).geom\n" 1888" INTO TABLE l_shape;\n" 1889"-- output as individual polygon triangles\n" 1890"SELECT ST_AsText((ST_Dump(geom)).geom) As wkt\n" 1891"FROM ( SELECT ST_DelaunayTriangles(ST_Collect(geom)) As geom\n" 1892"FROM l_shape) As foo;\n" 1893"\n" 1894"---wkt ---\n" 1895"POLYGON((6 194,6 190,14 194,6 194))\n" 1896"POLYGON((14 194,6 190,14 174,14 194))\n" 1897"POLYGON((14 194,14 174,154 14,14 194))\n" 1898"POLYGON((154 14,14 174,14 154,154 14))\n" 1899"POLYGON((154 14,14 154,150 14,154 14))\n" 1900"POLYGON((154 14,150 14,154 6,154 14))\n" 1901":\n" 1902":" 1903msgstr "" 1904 1905#. Tag: title 1906#: reference_processing.xml:914 1907#, no-c-format 1908msgid "3D Examples" 1909msgstr "" 1910 1911#. Tag: programlisting 1912#: reference_processing.xml:915 1913#, no-c-format 1914msgid "" 1915"-- 3D multipoint --\n" 1916"SELECT ST_AsText(ST_DelaunayTriangles(ST_GeomFromText(\n" 1917"'MULTIPOINT Z(14 14 10,\n" 1918"150 14 100,34 6 25, 20 10 150)'))) As wkt;\n" 1919"\n" 1920"-----wkt----\n" 1921"GEOMETRYCOLLECTION Z (POLYGON Z ((14 14 10,20 10 150,34 6 25,14 14 10))\n" 1922" ,POLYGON Z ((14 14 10,34 6 25,150 14 100,14 14 10)))" 1923msgstr "" 1924 1925#. Tag: para 1926#: reference_processing.xml:919 1927#, fuzzy, no-c-format 1928msgid "" 1929", <xref linkend=\"ST_ConcaveHull\"/>, <xref linkend=\"ST_Dump\"/>, <xref " 1930"linkend=\"ST_Tesselate\"/>" 1931msgstr "" 1932", <xref linkend=\"ST_ConcaveHull\"/>, <xref linkend=" 1933"\"ST_MinimumBoundingCircle\"/>" 1934 1935#. Tag: refname 1936#: reference_processing.xml:926 1937#, no-c-format 1938msgid "ST_Difference" 1939msgstr "ST_Difference" 1940 1941#. Tag: refpurpose 1942#: reference_processing.xml:928 1943#, no-c-format 1944msgid "" 1945"Returns a geometry that represents that part of geometry A that does not " 1946"intersect with geometry B." 1947msgstr "" 1948 1949#. Tag: funcprototype 1950#: reference_processing.xml:934 1951#, no-c-format 1952msgid "" 1953"<funcdef>geometry <function>ST_Difference</function></funcdef> " 1954"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 1955"<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef>" 1956msgstr "" 1957"<funcdef>geometry <function>ST_Difference</function></funcdef> " 1958"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 1959"<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef>" 1960 1961#. Tag: para 1962#: reference_processing.xml:945 1963#, no-c-format 1964msgid "" 1965"Returns a geometry that represents that part of geometry A that does not " 1966"intersect with geometry B. One can think of this as GeometryA - " 1967"ST_Intersection(A,B). If A is completely contained in B then an empty " 1968"geometry collection is returned." 1969msgstr "" 1970 1971#. Tag: para 1972#: reference_processing.xml:948 1973#, no-c-format 1974msgid "Order matters. B - A will always return a portion of B" 1975msgstr "" 1976 1977#. Tag: para 1978#: reference_processing.xml:953 1979#, no-c-format 1980msgid "&sqlmm_compliant; SQL-MM 3: 5.1.20" 1981msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.20" 1982 1983#. Tag: para 1984#: reference_processing.xml:954 reference_processing.xml:2605 1985#, no-c-format 1986msgid "" 1987"&Z_support; However it seems to only consider x y when doing the difference " 1988"and tacks back on the Z-Index" 1989msgstr "" 1990 1991#. Tag: para 1992#: reference_processing.xml:971 1993#, no-c-format 1994msgid "The original linestrings shown together." 1995msgstr "" 1996 1997#. Tag: para 1998#: reference_processing.xml:983 1999#, no-c-format 2000msgid "The difference of the two linestrings" 2001msgstr "" 2002 2003#. Tag: para 2004#: reference_processing.xml:992 2005#, no-c-format 2006msgid "" 2007"Safe for 2D. This is same geometries as what is shown for st_symdifference" 2008msgstr "" 2009 2010#. Tag: programlisting 2011#: reference_processing.xml:993 2012#, fuzzy, no-c-format 2013msgid "" 2014"SELECT ST_AsText(\n" 2015" ST_Difference(\n" 2016" 'LINESTRING(50 100, 50 200)'::geometry,\n" 2017" 'LINESTRING(50 50, 50 150)'::geometry\n" 2018" )\n" 2019" );\n" 2020"\n" 2021"st_astext\n" 2022"---------\n" 2023"LINESTRING(50 150,50 200)" 2024msgstr "" 2025"SELECT ST_AsText(ST_ConvexHull(\n" 2026" ST_Collect(\n" 2027" ST_GeomFromText('MULTILINESTRING((100 190,10 8),(150 10, 20 " 2028"30))'),\n" 2029" ST_GeomFromText('MULTIPOINT(50 5, 150 30, 50 10, 10 " 2030"10)')\n" 2031" )) );\n" 2032"---st_astext--\n" 2033"POLYGON((50 5,10 8,10 10,100 190,150 30,150 10,50 5))" 2034 2035#. Tag: para 2036#: reference_processing.xml:995 2037#, no-c-format 2038msgid "When used in 3d doesn't quite do the right thing." 2039msgstr "" 2040 2041#. Tag: programlisting 2042#: reference_processing.xml:996 2043#, no-c-format 2044msgid "" 2045"select ST_AsEWKT(\n" 2046" ST_Difference(\n" 2047" 'MULTIPOINT(-118.58 38.38 5,-118.60 38.329 6,-118.614 38.281 " 2048"7)' :: geometry,\n" 2049" 'POINT(-118.614 38.281 5)' :: geometry\n" 2050" )\n" 2051" );\n" 2052"st_asewkt\n" 2053"---------\n" 2054"MULTIPOINT(-118.6 38.329 6,-118.58 38.38 5)" 2055msgstr "" 2056 2057#. Tag: para 2058#: reference_processing.xml:1002 reference_processing.xml:2654 2059#, no-c-format 2060msgid ", <xref linkend=\"ST_Intersection\"/>, <xref linkend=\"ST_Union\"/>" 2061msgstr ", <xref linkend=\"ST_Intersection\"/>, <xref linkend=\"ST_Union\"/>" 2062 2063#. Tag: refname 2064#: reference_processing.xml:1008 2065#, no-c-format 2066msgid "ST_FlipCoordinates" 2067msgstr "ST_FlipCoordinates" 2068 2069#. Tag: refpurpose 2070#: reference_processing.xml:1009 2071#, no-c-format 2072msgid "" 2073"Returns a version of the given geometry with X and Y axis flipped. Useful " 2074"for people who have built latitude/longitude features and need to fix them." 2075msgstr "" 2076 2077#. Tag: funcprototype 2078#: reference_processing.xml:1017 2079#, no-c-format 2080msgid "" 2081"<funcdef>geometry <function>ST_FlipCoordinates</function></funcdef> " 2082"<paramdef><type>geometry</type> <parameter>geom</parameter></paramdef>" 2083msgstr "" 2084"<funcdef>geometry <function>ST_FlipCoordinates</function></funcdef> " 2085"<paramdef><type>geometry</type> <parameter>geom</parameter></paramdef>" 2086 2087#. Tag: para 2088#: reference_processing.xml:1026 2089#, no-c-format 2090msgid "Returns a version of the given geometry with X and Y axis flipped." 2091msgstr "" 2092 2093#. Tag: para 2094#: reference_processing.xml:1030 reference_processing.xml:1222 2095#, no-c-format 2096msgid "&M_support;" 2097msgstr "" 2098 2099#. Tag: para 2100#: reference_processing.xml:1031 reference_processing.xml:1974 2101#: reference_processing.xml:2090 2102#, no-c-format 2103msgid "&P_support;" 2104msgstr "&P_support;" 2105 2106#. Tag: title 2107#: reference_processing.xml:1036 2108#, no-c-format 2109msgid "Example" 2110msgstr "Esempio" 2111 2112#. Tag: programlisting 2113#: reference_processing.xml:1037 2114#, fuzzy, no-c-format 2115msgid "" 2116"<![CDATA[\n" 2117"SELECT ST_AsEWKT(ST_FlipCoordinates(GeomFromEWKT('POINT(1 2)')));\n" 2118" st_asewkt\n" 2119"------------\n" 2120"POINT(2 1)\n" 2121" ]]>" 2122msgstr "" 2123"<![CDATA[\n" 2124"SELECT ST_AsEWKT(ST_FlipCoordinates(GeomFromEWKT('POINT(1 2)')));\n" 2125" st_asewkt \n" 2126"------------\n" 2127"POINT(2 1)\n" 2128" ]]>" 2129 2130#. Tag: refname 2131#: reference_processing.xml:1050 2132#, fuzzy, no-c-format 2133msgid "ST_GeneratePoints" 2134msgstr "ST_RemoveRepeatedPoints" 2135 2136#. Tag: refpurpose 2137#: reference_processing.xml:1052 2138#, no-c-format 2139msgid "" 2140"Converts a polygon or multi-polygon into a multi-point composed of randomly " 2141"location points within the original areas." 2142msgstr "" 2143 2144#. Tag: funcsynopsis 2145#: reference_processing.xml:1056 2146#, fuzzy, no-c-format 2147msgid "" 2148"<funcprototype> <funcdef>geometry <function>ST_GeneratePoints</function></" 2149"funcdef> <paramdef> <parameter>g</parameter> <type>geometry</type> </" 2150"paramdef> <paramdef> <parameter>npoints</parameter> <type>integer</type> </" 2151"paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2152"<function>ST_GeneratePoints</function></funcdef> <paramdef> <parameter>g</" 2153"parameter> <type>geometry</type> </paramdef> <paramdef> <parameter>npoints</" 2154"parameter> <type>integer</type> </paramdef> <paramdef> <parameter>seed</" 2155"parameter> <type>integer</type> </paramdef> </funcprototype>" 2156msgstr "" 2157"<funcprototype> <funcdef>geometry <function>ST_CurveToLine</function></" 2158"funcdef> <paramdef><type>geometry</type> <parameter>curveGeom</parameter></" 2159"paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2160"<function>ST_CurveToLine</function></funcdef> <paramdef><type>geometry</" 2161"type> <parameter>curveGeom</parameter></paramdef> <paramdef><type>integer</" 2162"type> <parameter>segments_per_qtr_circle</parameter></paramdef> </" 2163"funcprototype>" 2164 2165#. Tag: para 2166#: reference_processing.xml:1090 2167#, no-c-format 2168msgid "" 2169"ST_GeneratePoints generates pseudo-random points until the requested number " 2170"are found within the input area. The optional seed must be greater than " 2171"zero, and is used to regenerate a deterministic sequence of points." 2172msgstr "" 2173 2174#. Tag: para 2175#: reference_processing.xml:1096 reference_processing.xml:1219 2176#: reference_processing.xml:2143 reference_processing.xml:2930 2177#: reference_processing.xml:3021 2178#, fuzzy, no-c-format 2179msgid "Availability: 2.3.0" 2180msgstr "Disponibilità: 2.0" 2181 2182#. Tag: para 2183#: reference_processing.xml:1097 2184#, no-c-format 2185msgid "Enhanced: 3.0.0, added seed parameter" 2186msgstr "" 2187 2188#. Tag: para 2189#: reference_processing.xml:1113 2190#, no-c-format 2191msgid "Original Polygon" 2192msgstr "" 2193 2194#. Tag: para 2195#: reference_processing.xml:1124 2196#, no-c-format 2197msgid "" 2198"Generated 12 Points overlaid on top of original polygon using a random seed " 2199"value 1996" 2200msgstr "" 2201 2202#. Tag: programlisting 2203#: reference_processing.xml:1127 2204#, fuzzy, no-c-format 2205msgid "" 2206"SELECT ST_GeneratePoints(geom, 12, 1996)\n" 2207"FROM (\n" 2208" SELECT ST_Buffer(\n" 2209" ST_GeomFromText(\n" 2210" 'LINESTRING(50 50,150 150,150 50)'),\n" 2211" 10, 'endcap=round join=round') AS geom\n" 2212") AS s;" 2213msgstr "" 2214"SELECT ST_Buffer(\n" 2215" ST_GeomFromText(\n" 2216" 'LINESTRING(50 50,150 150,150 50)'\n" 2217" ), 10, 'endcap=round join=round');" 2218 2219#. Tag: refname 2220#: reference_processing.xml:1138 2221#, no-c-format 2222msgid "ST_GeometricMedian" 2223msgstr "" 2224 2225#. Tag: refpurpose 2226#: reference_processing.xml:1142 2227#, no-c-format 2228msgid "Returns the geometric median of a MultiPoint." 2229msgstr "" 2230 2231#. Tag: funcprototype 2232#: reference_processing.xml:1149 2233#, fuzzy, no-c-format 2234msgid "" 2235"<funcdef>geometry <function> ST_GeometricMedian </function> </funcdef> " 2236"<paramdef> <type> geometry </type> <parameter> g </parameter> </paramdef> " 2237"<paramdef> <type> float8 </type> <parameter> tolerance </parameter> </" 2238"paramdef> <paramdef> <type> int </type> <parameter> max_iter </parameter> </" 2239"paramdef> <paramdef> <type> boolean </type> <parameter> " 2240"fail_if_not_converged </parameter> </paramdef>" 2241msgstr "" 2242"<funcdef>geometry <function>ST_ConcaveHull</function></funcdef> " 2243"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 2244"<paramdef><type>float </type> <parameter>target_percent</parameter></" 2245"paramdef> <paramdef choice=\"opt\"><type>boolean </type> " 2246"<parameter>allow_holes=false</parameter></paramdef>" 2247 2248#. Tag: para 2249#: reference_processing.xml:1199 2250#, no-c-format 2251msgid "" 2252"Computes the approximate geometric median of a MultiPoint geometry using the " 2253"Weiszfeld algorithm. The geometric median provides a centrality measure that " 2254"is less sensitive to outlier points than the centroid." 2255msgstr "" 2256 2257#. Tag: para 2258#: reference_processing.xml:1205 2259#, no-c-format 2260msgid "" 2261"The algorithm will iterate until the distance change between successive " 2262"iterations is less than the supplied <varname>tolerance</varname> parameter. " 2263"If this condition has not been met after <varname>max_iterations</varname> " 2264"iterations, the function will produce an error and exit, unless " 2265"<varname>fail_if_not_converged</varname> is set to false." 2266msgstr "" 2267 2268#. Tag: para 2269#: reference_processing.xml:1212 2270#, no-c-format 2271msgid "" 2272"If a <varname>tolerance</varname> value is not provided, a default tolerance " 2273"value will be calculated based on the extent of the input geometry." 2274msgstr "" 2275 2276#. Tag: para 2277#: reference_processing.xml:1216 2278#, no-c-format 2279msgid "M value of points, if present, is interpreted as their relative weight." 2280msgstr "" 2281 2282#. Tag: para 2283#: reference_processing.xml:1220 2284#, no-c-format 2285msgid "Enhanced: 2.5.0 Added support for M as weight of points." 2286msgstr "" 2287 2288#. Tag: para 2289#: reference_processing.xml:1234 2290#, no-c-format 2291msgid "" 2292"Comparison of the centroid (turquoise point) and geometric median (red " 2293"point) of a four-point MultiPoint (yellow points)." 2294msgstr "" 2295 2296#. Tag: programlisting 2297#: reference_processing.xml:1242 2298#, no-c-format 2299msgid "" 2300"WITH test AS (\n" 2301"SELECT 'MULTIPOINT((0 0), (1 1), (2 2), (200 200))'::geometry geom)\n" 2302"SELECT\n" 2303" ST_AsText(ST_Centroid(geom)) centroid,\n" 2304" ST_AsText(ST_GeometricMedian(geom)) median\n" 2305"FROM test;\n" 2306" centroid | median\n" 2307"--------------------+----------------------------------------\n" 2308" POINT(50.75 50.75) | POINT(1.9761550281255 1.9761550281255)\n" 2309"(1 row)" 2310msgstr "" 2311 2312#. Tag: refname 2313#: reference_processing.xml:1255 2314#, no-c-format 2315msgid "ST_Intersection" 2316msgstr "ST_Intersection" 2317 2318#. Tag: refpurpose 2319#: reference_processing.xml:1257 2320#, no-c-format 2321msgid "" 2322"(T) Returns a geometry that represents the shared portion of geomA and geomB." 2323msgstr "" 2324 2325#. Tag: funcsynopsis 2326#: reference_processing.xml:1263 2327#, no-c-format 2328msgid "" 2329"<funcprototype> <funcdef>geometry <function>ST_Intersection</function></" 2330"funcdef> <paramdef> <type>geometry</type> <parameter>geomA</parameter> </" 2331"paramdef> <paramdef> <type>geometry</type> <parameter>geomB</parameter> </" 2332"paramdef> </funcprototype> <funcprototype> <funcdef>geography " 2333"<function>ST_Intersection</function></funcdef> <paramdef> <type>geography</" 2334"type> <parameter>geogA</parameter> </paramdef> <paramdef> <type>geography</" 2335"type> <parameter>geogB</parameter> </paramdef> </funcprototype>" 2336msgstr "" 2337 2338#. Tag: para 2339#: reference_processing.xml:1290 2340#, no-c-format 2341msgid "" 2342"Returns a geometry that represents the point set intersection of the " 2343"Geometries." 2344msgstr "" 2345 2346#. Tag: para 2347#: reference_processing.xml:1293 2348#, no-c-format 2349msgid "" 2350"In other words - that portion of geometry A and geometry B that is shared " 2351"between the two geometries." 2352msgstr "" 2353 2354#. Tag: para 2355#: reference_processing.xml:1296 2356#, no-c-format 2357msgid "" 2358"If the geometries do not share any space (are disjoint), then an empty " 2359"geometry collection is returned." 2360msgstr "" 2361 2362#. Tag: para 2363#: reference_processing.xml:1298 2364#, no-c-format 2365msgid "" 2366"ST_Intersection in conjunction with ST_Intersects is very useful for " 2367"clipping geometries such as in bounding box, buffer, region queries where " 2368"you only want to return that portion of a geometry that sits in a country or " 2369"region of interest." 2370msgstr "" 2371 2372#. Tag: para 2373#: reference_processing.xml:1301 2374#, no-c-format 2375msgid "" 2376"Geography: For geography this is really a thin wrapper around the geometry " 2377"implementation. It first determines the best SRID that fits the bounding box " 2378"of the 2 geography objects (if geography objects are within one half zone " 2379"UTM but not same UTM will pick one of those) (favoring UTM or Lambert " 2380"Azimuthal Equal Area (LAEA) north/south pole, and falling back on mercator " 2381"in worst case scenario) and then intersection in that best fit planar " 2382"spatial ref and retransforms back to WGS84 geography." 2383msgstr "" 2384 2385#. Tag: para 2386#: reference_processing.xml:1304 2387#, no-c-format 2388msgid "This function will drop the M coordinate values if present." 2389msgstr "" 2390 2391#. Tag: para 2392#: reference_processing.xml:1306 2393#, no-c-format 2394msgid "" 2395"If working with 3D geometries, you may want to use SFGCAL based <xref " 2396"linkend=\"ST_3DIntersection\"/> which does a proper 3D intersection for 3D " 2397"geometries. Although this function works with Z-coordinate, it does an " 2398"averaging of Z-Coordinate." 2399msgstr "" 2400 2401#. Tag: para 2402#: reference_processing.xml:1310 2403#, no-c-format 2404msgid "Availability: 1.5 support for geography data type was introduced." 2405msgstr "" 2406 2407#. Tag: para 2408#: reference_processing.xml:1311 reference_processing.xml:2794 2409#, no-c-format 2410msgid "Changed: 3.0.0 does not depend on SFCGAL." 2411msgstr "" 2412 2413#. Tag: para 2414#: reference_processing.xml:1314 2415#, no-c-format 2416msgid "&sqlmm_compliant; SQL-MM 3: 5.1.18" 2417msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.18" 2418 2419#. Tag: programlisting 2420#: reference_processing.xml:1318 2421#, no-c-format 2422msgid "" 2423"SELECT ST_AsText(ST_Intersection('POINT(0 0)'::geometry, 'LINESTRING ( 2 0, " 2424"0 2 )'::geometry));\n" 2425" st_astext\n" 2426"---------------\n" 2427"GEOMETRYCOLLECTION EMPTY\n" 2428"\n" 2429"SELECT ST_AsText(ST_Intersection('POINT(0 0)'::geometry, 'LINESTRING ( 0 0, " 2430"0 2 )'::geometry));\n" 2431" st_astext\n" 2432"---------------\n" 2433"POINT(0 0)" 2434msgstr "" 2435 2436#. Tag: para 2437#: reference_processing.xml:1319 2438#, no-c-format 2439msgid "" 2440"Clip all lines (trails) by country. Hhere we assume country geom are POLYGON " 2441"or MULTIPOLYGONS. NOTE: we are only keeping intersections that result in a " 2442"LINESTRING or MULTILINESTRING because we don't care about trails that just " 2443"share a point. The dump is needed to expand a geometry collection into " 2444"individual single MULT* parts. The below is fairly generic and will work for " 2445"polys, etc. by just changing the where clause." 2446msgstr "" 2447 2448#. Tag: programlisting 2449#: reference_processing.xml:1324 2450#, no-c-format 2451msgid "" 2452"select clipped.gid, clipped.f_name, clipped_geom\n" 2453"from (\n" 2454" select trails.gid, trails.f_name,\n" 2455" (ST_Dump(ST_Intersection(country.geom, trails.geom))).geom " 2456"clipped_geom\n" 2457" from country\n" 2458" inner join trails on ST_Intersects(country.geom, trails.geom)\n" 2459" ) as clipped\n" 2460"where ST_Dimension(clipped.clipped_geom) = 1;" 2461msgstr "" 2462 2463#. Tag: para 2464#: reference_processing.xml:1325 2465#, no-c-format 2466msgid "" 2467"For polys e.g. polygon landmarks, you can also use the sometimes faster hack " 2468"that buffering anything by 0.0 except a polygon results in an empty geometry " 2469"collection. (So a geometry collection containing polys, lines and points " 2470"buffered by 0.0 would only leave the polygons and dissolve the collection " 2471"shell.)" 2472msgstr "" 2473 2474#. Tag: programlisting 2475#: reference_processing.xml:1327 2476#, no-c-format 2477msgid "" 2478"select poly.gid,\n" 2479" ST_Multi(\n" 2480" ST_Buffer(\n" 2481" ST_Intersection(country.geom, poly.geom),\n" 2482" 0.0\n" 2483" )\n" 2484" ) clipped_geom\n" 2485"from country\n" 2486" inner join poly on ST_Intersects(country.geom, poly.geom)\n" 2487"where not ST_IsEmpty(ST_Buffer(ST_Intersection(country.geom, poly.geom), " 2488"0.0));" 2489msgstr "" 2490 2491#. Tag: title 2492#: reference_processing.xml:1331 2493#, no-c-format 2494msgid "Examples: 2.5Dish" 2495msgstr "" 2496 2497#. Tag: para 2498#: reference_processing.xml:1332 2499#, no-c-format 2500msgid "" 2501"Note this is not a true intersection, compare to the same example using " 2502"<xref linkend=\"ST_3DIntersection\"/>." 2503msgstr "" 2504 2505#. Tag: programlisting 2506#: reference_processing.xml:1333 2507#, no-c-format 2508msgid "" 2509"select ST_AsText(ST_Intersection(linestring, polygon)) As wkt\n" 2510"from ST_GeomFromText('LINESTRING Z (2 2 6,1.5 1.5 7,1 1 8,0.5 0.5 8,0 0 " 2511"10)') AS linestring\n" 2512" CROSS JOIN ST_GeomFromText('POLYGON((0 0 8, 0 1 8, 1 1 8, 1 0 8, 0 0 8))') " 2513"AS polygon;\n" 2514"\n" 2515" st_astext\n" 2516"---------------------------------------\n" 2517" LINESTRING Z (1 1 8,0.5 0.5 8,0 0 10)" 2518msgstr "" 2519 2520#. Tag: para 2521#: reference_processing.xml:1337 2522#, no-c-format 2523msgid "" 2524", <xref linkend=\"ST_Difference\"/>, <xref linkend=\"ST_Union\"/>, <xref " 2525"linkend=\"ST_Dimension\"/>, <xref linkend=\"ST_Dump\"/>, <xref linkend=" 2526"\"ST_Force2D\"/>, <xref linkend=\"ST_SymDifference\"/>, <xref linkend=" 2527"\"ST_Intersects\"/>, <xref linkend=\"ST_Multi\"/>" 2528msgstr "" 2529 2530#. Tag: refname 2531#: reference_processing.xml:1343 2532#, no-c-format 2533msgid "ST_LineToCurve" 2534msgstr "ST_LineToCurve" 2535 2536#. Tag: refpurpose 2537#: reference_processing.xml:1345 2538#, fuzzy, no-c-format 2539msgid "Converts a LINESTRING/POLYGON to a CIRCULARSTRING, CURVEPOLYGON" 2540msgstr "Converte un CIRCULARSTRING/CURVEDPOLYGON in LINESTRING/POLYGON" 2541 2542#. Tag: funcprototype 2543#: reference_processing.xml:1350 2544#, no-c-format 2545msgid "" 2546"<funcdef>geometry <function>ST_LineToCurve</function></funcdef> " 2547"<paramdef><type>geometry </type> <parameter>geomANoncircular</parameter></" 2548"paramdef>" 2549msgstr "" 2550"<funcdef>geometry <function>ST_LineToCurve</function></funcdef> " 2551"<paramdef><type>geometry </type> <parameter>geomANoncircular</parameter></" 2552"paramdef>" 2553 2554#. Tag: para 2555#: reference_processing.xml:1360 2556#, no-c-format 2557msgid "" 2558"Converts plain LINESTRING/POLYGON to CIRCULAR STRINGs and Curved Polygons. " 2559"Note much fewer points are needed to describe the curved equivalent." 2560msgstr "" 2561 2562#. Tag: para 2563#: reference_processing.xml:1361 2564#, no-c-format 2565msgid "" 2566"If the input LINESTRING/POLYGON is not curved enough to clearly represent a " 2567"curve, the function will return the same input geometry." 2568msgstr "" 2569 2570#. Tag: programlisting 2571#: reference_processing.xml:1371 2572#, no-c-format 2573msgid "" 2574"-- 2D Example\n" 2575"SELECT ST_AsText(ST_LineToCurve(foo.the_geom)) As curvedastext,ST_AsText(foo." 2576"the_geom) As non_curvedastext\n" 2577" FROM (SELECT ST_Buffer('POINT(1 3)'::geometry, 3) As the_geom) As " 2578"foo;\n" 2579"\n" 2580"curvedatext " 2581"non_curvedastext\n" 2582"--------------------------------------------------------------------|-----------------------------------------------------------------\n" 2583"CURVEPOLYGON(CIRCULARSTRING(4 3,3.12132034355964 0.878679656440359, | " 2584"POLYGON((4 3,3.94235584120969 2.41472903395162,3.77163859753386 " 2585"1.85194970290473,\n" 2586"1 0,-1.12132034355965 5.12132034355963,4 3)) | " 2587"3.49440883690764 1.33328930094119,3.12132034355964 0.878679656440359,\n" 2588" | " 2589"2.66671069905881 0.505591163092366,2.14805029709527 0.228361402466141,\n" 2590" | " 2591"1.58527096604839 0.0576441587903094,1 0,\n" 2592" | " 2593"0.414729033951621 0.0576441587903077,-0.148050297095264 0.228361402466137,\n" 2594" | " 2595"-0.666710699058802 0.505591163092361,-1.12132034355964 0.878679656440353,\n" 2596" | " 2597"-1.49440883690763 1.33328930094119,-1.77163859753386 1.85194970290472\n" 2598" | --" 2599"ETC-- ,3.94235584120969 3.58527096604839,4 3))\n" 2600"\n" 2601"--3D example\n" 2602"SELECT ST_AsText(ST_LineToCurve(geom)) As curved, ST_AsText(geom) AS " 2603"not_curved\n" 2604"FROM (SELECT ST_Translate(ST_Force3D(ST_Boundary(ST_Buffer(ST_Point(1,3), " 2605"2,2))),0,0,3) AS geom) AS foo;\n" 2606"\n" 2607" curved | " 2608"not_curved\n" 2609"------------------------------------------------------" 2610"+---------------------------------------------------------------------\n" 2611" CIRCULARSTRING Z (3 3 3,-1 2.99999999999999 3,3 3 3) | LINESTRING Z (3 3 " 2612"3,2.4142135623731 1.58578643762691 3,1 1 3,\n" 2613" | " 2614"-0.414213562373092 1.5857864376269 3,-1 2.99999999999999 3,\n" 2615" | -0.414213562373101 " 2616"4.41421356237309 3,\n" 2617" | " 2618"0.999999999999991 5 3,2.41421356237309 4.4142135623731 3,3 3 3)\n" 2619"(1 row)" 2620msgstr "" 2621 2622#. Tag: refname 2623#: reference_processing.xml:1386 2624#, no-c-format 2625msgid "ST_MakeValid" 2626msgstr "ST_MakeValid" 2627 2628#. Tag: refpurpose 2629#: reference_processing.xml:1387 2630#, no-c-format 2631msgid "Attempts to make an invalid geometry valid without losing vertices." 2632msgstr "" 2633 2634#. Tag: funcprototype 2635#: reference_processing.xml:1392 2636#, no-c-format 2637msgid "" 2638"<funcdef>geometry <function>ST_MakeValid</function></funcdef> " 2639"<paramdef><type>geometry</type> <parameter>input</parameter></paramdef>" 2640msgstr "" 2641"<funcdef>geometry <function>ST_MakeValid</function></funcdef> " 2642"<paramdef><type>geometry</type> <parameter>input</parameter></paramdef>" 2643 2644#. Tag: para 2645#: reference_processing.xml:1401 2646#, no-c-format 2647msgid "" 2648"The function attempts to create a valid representation of a given invalid " 2649"geometry without losing any of the input vertices. Already-valid geometries " 2650"are returned without further intervention." 2651msgstr "" 2652 2653#. Tag: para 2654#: reference_processing.xml:1407 2655#, no-c-format 2656msgid "" 2657"Supported inputs are: POINTS, MULTIPOINTS, LINESTRINGS, MULTILINESTRINGS, " 2658"POLYGONS, MULTIPOLYGONS and GEOMETRYCOLLECTIONS containing any mix of them." 2659msgstr "" 2660 2661#. Tag: para 2662#: reference_processing.xml:1413 2663#, no-c-format 2664msgid "" 2665"In case of full or partial dimensional collapses, the output geometry may be " 2666"a collection of lower-to-equal dimension geometries or a geometry of lower " 2667"dimension." 2668msgstr "" 2669 2670#. Tag: para 2671#: reference_processing.xml:1419 2672#, no-c-format 2673msgid "" 2674"Single polygons may become multi-geometries in case of self-intersections." 2675msgstr "" 2676 2677#. Tag: para 2678#: reference_processing.xml:1425 2679#, no-c-format 2680msgid "Enhanced: 2.0.1, speed improvements" 2681msgstr "" 2682 2683#. Tag: para 2684#: reference_processing.xml:1426 2685#, no-c-format 2686msgid "Enhanced: 2.1.0, added support for GEOMETRYCOLLECTION and MULTIPOINT." 2687msgstr "" 2688 2689#. Tag: refname 2690#: reference_processing.xml:1443 2691#, no-c-format 2692msgid "ST_MemUnion" 2693msgstr "ST_MemUnion" 2694 2695#. Tag: refpurpose 2696#: reference_processing.xml:1445 2697#, no-c-format 2698msgid "" 2699"Same as ST_Union, only memory-friendly (uses less memory and more processor " 2700"time)." 2701msgstr "" 2702 2703#. Tag: funcprototype 2704#: reference_processing.xml:1451 2705#, no-c-format 2706msgid "" 2707"<funcdef>geometry <function>ST_MemUnion</function></funcdef> " 2708"<paramdef><type>geometry set</type> <parameter>geomfield</parameter></" 2709"paramdef>" 2710msgstr "" 2711"<funcdef>geometry <function>ST_MemUnion</function></funcdef> " 2712"<paramdef><type>geometry set</type> <parameter>geomfield</parameter></" 2713"paramdef>" 2714 2715#. Tag: para 2716#: reference_processing.xml:1462 2717#, no-c-format 2718msgid "Some useful description here." 2719msgstr "" 2720 2721#. Tag: para 2722#: reference_processing.xml:1466 2723#, no-c-format 2724msgid "" 2725"Same as ST_Union, only memory-friendly (uses less memory and more processor " 2726"time). This aggregate function works by unioning the geometries one at a " 2727"time to previous result as opposed to ST_Union aggregate which first creates " 2728"an array and then unions" 2729msgstr "" 2730 2731#. Tag: programlisting 2732#: reference_processing.xml:1478 2733#, no-c-format 2734msgid "See ST_Union" 2735msgstr "Si veda ST_Union" 2736 2737#. Tag: refname 2738#: reference_processing.xml:1491 2739#, no-c-format 2740msgid "ST_MinimumBoundingCircle" 2741msgstr "ST_MinimumBoundingCircle" 2742 2743#. Tag: refpurpose 2744#: reference_processing.xml:1492 2745#, no-c-format 2746msgid "" 2747"Returns the smallest circle polygon that can fully contain a geometry. " 2748"Default uses 48 segments per quarter circle." 2749msgstr "" 2750 2751#. Tag: funcprototype 2752#: reference_processing.xml:1498 2753#, no-c-format 2754msgid "" 2755"<funcdef>geometry <function>ST_MinimumBoundingCircle</function></funcdef> " 2756"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 2757"<paramdef choice=\"opt\"><type>integer </type> " 2758"<parameter>num_segs_per_qt_circ=48</parameter></paramdef>" 2759msgstr "" 2760"<funcdef>geometry <function>ST_MinimumBoundingCircle</function></funcdef> " 2761"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 2762"<paramdef choice=\"opt\"><type>integer </type> " 2763"<parameter>num_segs_per_qt_circ=48</parameter></paramdef>" 2764 2765#. Tag: para 2766#: reference_processing.xml:1508 2767#, no-c-format 2768msgid "Returns the smallest circle polygon that can fully contain a geometry." 2769msgstr "" 2770 2771#. Tag: para 2772#: reference_processing.xml:1509 2773#, no-c-format 2774msgid "" 2775"The circle is approximated by a polygon with a default of 48 segments per " 2776"quarter circle. Because the polygon is an approximation of the minimum " 2777"bounding circle, some points in the input geometry may not be contained " 2778"within the polygon. The approximation can be improved by increasing the " 2779"number of segments, with little performance penalty. For applications where " 2780"a polygonal approximation is not suitable, ST_MinimumBoundingRadius may be " 2781"used." 2782msgstr "" 2783 2784#. Tag: para 2785#: reference_processing.xml:1511 2786#, no-c-format 2787msgid "" 2788"It is often used with MULTI and Geometry Collections. Although it is not an " 2789"aggregate - you can use it in conjunction with ST_Collect to get the minimum " 2790"bounding circle of a set of geometries. " 2791"ST_MinimumBoundingCircle(ST_Collect(somepointfield))." 2792msgstr "" 2793 2794#. Tag: para 2795#: reference_processing.xml:1516 2796#, no-c-format 2797msgid "" 2798"The ratio of the area of a polygon divided by the area of its Minimum " 2799"Bounding Circle is often referred to as the Roeck test." 2800msgstr "" 2801 2802#. Tag: para 2803#: reference_processing.xml:1518 2804#, fuzzy, no-c-format 2805msgid "Availability: 1.4.0" 2806msgstr "Disponibilità: 1.5.0" 2807 2808#. Tag: para 2809#: reference_processing.xml:1523 reference_processing.xml:1541 2810#, fuzzy, no-c-format 2811msgid ", <xref linkend=\"ST_MinimumBoundingRadius\"/>" 2812msgstr ", <xref linkend=\"ST_Union\"/>" 2813 2814#. Tag: programlisting 2815#: reference_processing.xml:1528 2816#, no-c-format 2817msgid "" 2818"SELECT d.disease_type,\n" 2819" ST_MinimumBoundingCircle(ST_Collect(d.the_geom)) As the_geom\n" 2820" FROM disease_obs As d\n" 2821" GROUP BY d.disease_type;" 2822msgstr "" 2823"SELECT d.disease_type,\n" 2824" ST_MinimumBoundingCircle(ST_Collect(d.the_geom)) As the_geom\n" 2825" FROM disease_obs As d\n" 2826" GROUP BY d.disease_type;" 2827 2828#. Tag: para 2829#: reference_processing.xml:1534 2830#, no-c-format 2831msgid "" 2832"Minimum bounding circle of a point and linestring. Using 8 segs to " 2833"approximate a quarter circle" 2834msgstr "" 2835 2836#. Tag: programlisting 2837#: reference_processing.xml:1537 2838#, fuzzy, no-c-format 2839msgid "" 2840"SELECT ST_AsText(ST_MinimumBoundingCircle(\n" 2841" ST_Collect(\n" 2842" ST_GeomFromText('LINESTRING(55 75,125 150)'),\n" 2843" ST_Point(20, 80)), 8\n" 2844" )) As wktmbc;\n" 2845"wktmbc\n" 2846"-----------\n" 2847"POLYGON((135.59714732062 115,134.384753327498 " 2848"102.690357210921,130.79416296937 90.8537670908995,124.963360620072 " 2849"79.9451031602111,117.116420743937 70.3835792560632,107.554896839789 " 2850"62.5366393799277,96.6462329091006 56.70583703063,84.8096427890789 " 2851"53.115246672502,72.5000000000001 51.9028526793802,60.1903572109213 " 2852"53.1152466725019,48.3537670908996 56.7058370306299,37.4451031602112 " 2853"62.5366393799276,27.8835792560632 70.383579256063,20.0366393799278 " 2854"79.9451031602109,14.20583703063 90.8537670908993,10.615246672502 " 2855"102.690357210921,9.40285267938019 115,10.6152466725019 " 2856"127.309642789079,14.2058370306299 139.1462329091,20.0366393799275 " 2857"150.054896839789,27.883579256063 159.616420743937,\n" 2858"37.4451031602108 167.463360620072,48.3537670908992 " 2859"173.29416296937,60.190357210921 176.884753327498,\n" 2860"72.4999999999998 178.09714732062,84.8096427890786 " 2861"176.884753327498,96.6462329091003 173.29416296937,107.554896839789 " 2862"167.463360620072,\n" 2863"117.116420743937 159.616420743937,124.963360620072 " 2864"150.054896839789,130.79416296937 139.146232909101,134.384753327498 " 2865"127.309642789079,135.59714732062 115))" 2866msgstr "" 2867"SELECT ST_AsText(ST_MinimumBoundingCircle(\n" 2868" ST_Collect(\n" 2869" ST_GeomFromEWKT('LINESTRING(55 75,125 150)'),\n" 2870" ST_Point(20, 80)), 8\n" 2871" )) As wktmbc;\n" 2872"wktmbc\n" 2873"-----------\n" 2874"POLYGON((135.59714732062 115,134.384753327498 " 2875"102.690357210921,130.79416296937 90.8537670908995,124.963360620072 " 2876"79.9451031602111,117.116420743937 70.3835792560632,107.554896839789 " 2877"62.5366393799277,96.6462329091006 56.70583703063,84.8096427890789 " 2878"53.115246672502,72.5000000000001 51.9028526793802,60.1903572109213 " 2879"53.1152466725019,48.3537670908996 56.7058370306299,37.4451031602112 " 2880"62.5366393799276,27.8835792560632 70.383579256063,20.0366393799278 " 2881"79.9451031602109,14.20583703063 90.8537670908993,10.615246672502 " 2882"102.690357210921,9.40285267938019 115,10.6152466725019 " 2883"127.309642789079,14.2058370306299 139.1462329091,20.0366393799275 " 2884"150.054896839789,27.883579256063 159.616420743937,\n" 2885"37.4451031602108 167.463360620072,48.3537670908992 " 2886"173.29416296937,60.190357210921 176.884753327498,\n" 2887"72.4999999999998 178.09714732062,84.8096427890786 " 2888"176.884753327498,96.6462329091003 173.29416296937,107.554896839789 " 2889"167.463360620072,\n" 2890"117.116420743937 159.616420743937,124.963360620072 " 2891"150.054896839789,130.79416296937 139.146232909101,134.384753327498 " 2892"127.309642789079,135.59714732062 115))" 2893 2894#. Tag: refname 2895#: reference_processing.xml:1547 2896#, fuzzy, no-c-format 2897msgid "ST_MinimumBoundingRadius" 2898msgstr "ST_MinimumBoundingCircle" 2899 2900#. Tag: refpurpose 2901#: reference_processing.xml:1548 2902#, no-c-format 2903msgid "" 2904"Returns the center point and radius of the smallest circle that can fully " 2905"contain a geometry." 2906msgstr "" 2907 2908#. Tag: funcprototype 2909#: reference_processing.xml:1553 2910#, fuzzy, no-c-format 2911msgid "" 2912"<funcdef>(geometry, double precision) <function>ST_MinimumBoundingRadius</" 2913"function></funcdef> <paramdef><type>geometry</type> <parameter>geom</" 2914"parameter></paramdef>" 2915msgstr "" 2916"<funcdef>geometry_dump[]<function>ST_DumpPoints</function></funcdef> " 2917"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 2918 2919#. Tag: para 2920#: reference_processing.xml:1562 2921#, no-c-format 2922msgid "" 2923"Returns a record containing the center point and radius of the smallest " 2924"circle that can fully contain a geometry." 2925msgstr "" 2926 2927#. Tag: para 2928#: reference_processing.xml:1563 2929#, no-c-format 2930msgid "" 2931"Can be used in conjunction with <xref linkend=\"ST_Collect\"/> to get the " 2932"minimum bounding circle of a set of geometries." 2933msgstr "" 2934 2935#. Tag: para 2936#: reference_processing.xml:1564 2937#, fuzzy, no-c-format 2938msgid "Availability - 2.3.0" 2939msgstr "Disponibilità: 2.0" 2940 2941#. Tag: para 2942#: reference_processing.xml:1569 2943#, fuzzy, no-c-format 2944msgid ", <xref linkend=\"ST_MinimumBoundingCircle\"/>" 2945msgstr ", <xref linkend=\"ST_Union\"/>" 2946 2947#. Tag: programlisting 2948#: reference_processing.xml:1574 2949#, no-c-format 2950msgid "" 2951"SELECT ST_AsText(center), radius FROM " 2952"ST_MinimumBoundingRadius('POLYGON((26426 65078,26531 65242,26075 65136,26096 " 2953"65427,26426 65078))');\n" 2954"\n" 2955" st_astext | radius\n" 2956"------------------------------------------+------------------\n" 2957" POINT(26284.8418027133 65267.1145090825) | 247.436045591407" 2958msgstr "" 2959 2960#. Tag: refname 2961#: reference_processing.xml:1581 2962#, no-c-format 2963msgid "ST_OrientedEnvelope" 2964msgstr "" 2965 2966#. Tag: refpurpose 2967#: reference_processing.xml:1582 2968#, no-c-format 2969msgid "Returns a minimum rotated rectangle enclosing a geometry." 2970msgstr "" 2971 2972#. Tag: funcprototype 2973#: reference_processing.xml:1587 2974#, fuzzy, no-c-format 2975msgid "" 2976"<funcdef>geometry <function>ST_OrientedEnvelope</function></funcdef> " 2977"<paramdef> <type>geometry</type> <parameter>geom</parameter> </paramdef>" 2978msgstr "" 2979"<funcdef>geometry <function>ST_Node</function></funcdef> " 2980"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 2981 2982#. Tag: para 2983#: reference_processing.xml:1599 2984#, no-c-format 2985msgid "" 2986"Returns a mimimum rotated rectangle enclosing a geometry. Note that more " 2987"than one minimum rotated rectangle may exist. May return a Point or " 2988"LineString in the case of degenerate inputs." 2989msgstr "" 2990 2991#. Tag: para 2992#: reference_processing.xml:1604 reference_processing.xml:2331 2993#: reference_processing.xml:2378 2994#, fuzzy, no-c-format 2995msgid "Availability: 2.5.0" 2996msgstr "Disponibilità: 2.0" 2997 2998#. Tag: programlisting 2999#: reference_processing.xml:1619 3000#, no-c-format 3001msgid "" 3002"SELECT ST_AsText(ST_OrientedEnvelope('MULTIPOINT ((0 0), (-1 -1), (3 " 3003"2))'));\n" 3004"\n" 3005" st_astext\n" 3006" ------------------------------------------------\n" 3007" POLYGON((3 2,2.88 2.16,-1.12 -0.84,-1 -1,3 " 3008"2))" 3009msgstr "" 3010 3011#. Tag: para 3012#: reference_processing.xml:1626 3013#, no-c-format 3014msgid "Oriented envelope of a point and linestring." 3015msgstr "" 3016 3017#. Tag: programlisting 3018#: reference_processing.xml:1629 3019#, no-c-format 3020msgid "" 3021"SELECT ST_AsText(ST_OrientedEnvelope(\n" 3022" ST_Collect(\n" 3023" ST_GeomFromText('LINESTRING(55 75,125 150)'),\n" 3024" ST_Point(20, 80))\n" 3025" )) As wktenv;\n" 3026"wktenv\n" 3027"-----------\n" 3028"POLYGON((19.9999999999997 79.9999999999999,33.0769230769229 " 3029"60.3846153846152,138.076923076924 130.384615384616,125.000000000001 " 3030"150.000000000001,19.9999999999997 79.9999999999999))" 3031msgstr "" 3032 3033#. Tag: refname 3034#: reference_processing.xml:1636 3035#, no-c-format 3036msgid "ST_Polygonize" 3037msgstr "ST_Polygonize" 3038 3039#. Tag: refpurpose 3040#: reference_processing.xml:1638 3041#, no-c-format 3042msgid "" 3043"Aggregate. Creates a GeometryCollection containing possible polygons formed " 3044"from the constituent linework of a set of geometries." 3045msgstr "" 3046 3047#. Tag: funcsynopsis 3048#: reference_processing.xml:1644 3049#, no-c-format 3050msgid "" 3051"<funcprototype> <funcdef>geometry <function>ST_Polygonize</function></" 3052"funcdef> <paramdef><type>geometry set</type> <parameter>geomfield</" 3053"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 3054"<function>ST_Polygonize</function></funcdef> <paramdef><type>geometry[]</" 3055"type> <parameter>geom_array</parameter></paramdef> </funcprototype>" 3056msgstr "" 3057"<funcprototype> <funcdef>geometry <function>ST_Polygonize</function></" 3058"funcdef> <paramdef><type>geometry set</type> <parameter>geomfield</" 3059"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 3060"<function>ST_Polygonize</function></funcdef> <paramdef><type>geometry[]</" 3061"type> <parameter>geom_array</parameter></paramdef> </funcprototype>" 3062 3063#. Tag: para 3064#: reference_processing.xml:1660 3065#, no-c-format 3066msgid "" 3067"Creates a GeometryCollection containing possible polygons formed from the " 3068"constituent linework of a set of geometries." 3069msgstr "" 3070 3071#. Tag: para 3072#: reference_processing.xml:1665 3073#, no-c-format 3074msgid "" 3075"Geometry Collections are often difficult to deal with with third party " 3076"tools, so use ST_Polygonize in conjunction with <xref linkend=\"ST_Dump\"/> " 3077"to dump the polygons out into individual polygons." 3078msgstr "" 3079 3080#. Tag: para 3081#: reference_processing.xml:1674 3082#, fuzzy, no-c-format 3083msgid "Availability: 1.0.0RC1" 3084msgstr "Disponibilità: 1.5.0" 3085 3086#. Tag: title 3087#: reference_processing.xml:1678 3088#, no-c-format 3089msgid "Examples: Polygonizing single linestrings" 3090msgstr "" 3091 3092#. Tag: programlisting 3093#: reference_processing.xml:1679 3094#, no-c-format 3095msgid "" 3096"SELECT ST_AsEWKT(ST_Polygonize(the_geom_4269)) As geomtextrep\n" 3097"FROM (SELECT the_geom_4269 FROM ma.suffolk_edges ORDER BY tlid LIMIT 45) As " 3098"foo;\n" 3099"\n" 3100"geomtextrep\n" 3101"-------------------------------------\n" 3102" SRID=4269;GEOMETRYCOLLECTION(POLYGON((-71.040878 42.285678,-71.040943 " 3103"42.2856,-71.04096 42.285752,-71.040878 42.285678)),\n" 3104" POLYGON((-71.17166 42.353675,-71.172026 42.354044,-71.17239 " 3105"42.354358,-71.171794 42.354971,-71.170511 42.354855,\n" 3106" -71.17112 42.354238,-71.17166 42.353675)))\n" 3107"(1 row)\n" 3108"\n" 3109"--Use ST_Dump to dump out the polygonize geoms into individual polygons\n" 3110"SELECT ST_AsEWKT((ST_Dump(foofoo.polycoll)).geom) As geomtextrep\n" 3111"FROM (SELECT ST_Polygonize(the_geom_4269) As polycoll\n" 3112" FROM (SELECT the_geom_4269 FROM ma.suffolk_edges\n" 3113" ORDER BY tlid LIMIT 45) As foo) As foofoo;\n" 3114"\n" 3115"geomtextrep\n" 3116"------------------------\n" 3117" SRID=4269;POLYGON((-71.040878 42.285678,-71.040943 42.2856,-71.04096 " 3118"42.285752,\n" 3119"-71.040878 42.285678))\n" 3120" SRID=4269;POLYGON((-71.17166 42.353675,-71.172026 42.354044,-71.17239 " 3121"42.354358\n" 3122",-71.171794 42.354971,-71.170511 42.354855,-71.17112 42.354238,-71.17166 " 3123"42.353675))\n" 3124"(2 rows)" 3125msgstr "" 3126 3127#. Tag: para 3128#: reference_processing.xml:1684 3129#, no-c-format 3130msgid ", <xref linkend=\"ST_Dump\"/>" 3131msgstr ", <xref linkend=\"ST_Dump\"/>" 3132 3133#. Tag: refname 3134#: reference_processing.xml:1693 3135#, no-c-format 3136msgid "ST_Node" 3137msgstr "ST_Node" 3138 3139#. Tag: refpurpose 3140#: reference_processing.xml:1695 3141#, no-c-format 3142msgid "Node a set of linestrings." 3143msgstr "" 3144 3145#. Tag: funcprototype 3146#: reference_processing.xml:1702 3147#, no-c-format 3148msgid "" 3149"<funcdef>geometry <function>ST_Node</function></funcdef> " 3150"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 3151msgstr "" 3152"<funcdef>geometry <function>ST_Node</function></funcdef> " 3153"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 3154 3155#. Tag: para 3156#: reference_processing.xml:1713 3157#, no-c-format 3158msgid "" 3159"Fully node a set of linestrings using the least possible number of nodes " 3160"while preserving all of the input ones." 3161msgstr "" 3162 3163#. Tag: para 3164#: reference_processing.xml:1722 3165#, no-c-format 3166msgid "" 3167"Changed: 2.4.0 this function uses GEOSNode internally instead of " 3168"GEOSUnaryUnion. This may cause the resulting linestrings to have a different " 3169"order and direction compared to Postgis < 2.4." 3170msgstr "" 3171 3172#. Tag: programlisting 3173#: reference_processing.xml:1729 3174#, fuzzy, no-c-format 3175msgid "" 3176"SELECT ST_AsText(\n" 3177" ST_Node('LINESTRINGZ(0 0 0, 10 10 10, 0 10 5, 10 0 3)'::" 3178"geometry)\n" 3179" ) As output;\n" 3180"output\n" 3181"-----------\n" 3182"MULTILINESTRING Z ((0 0 0,5 5 4.5),(5 5 4.5,10 10 10,0 10 5,5 5 4.5),(5 5 " 3183"4.5,10 0 3))" 3184msgstr "" 3185"SELECT ST_AsEWKT(\n" 3186" ST_Node('LINESTRINGZ(0 0 0, 10 10 10, 0 10 5, 10 0 3)'::" 3187"geometry)\n" 3188" ) As output;\n" 3189"output\n" 3190"-----------\n" 3191"MULTILINESTRING((0 0 0,5 5 4.5),(5 5 4.5,10 10 10,0 10 5,5 5 4.5),(5 5 " 3192"4.5,10 0 3))" 3193 3194#. Tag: refname 3195#: reference_processing.xml:1744 3196#, no-c-format 3197msgid "ST_OffsetCurve" 3198msgstr "ST_OffsetCurve" 3199 3200#. Tag: refpurpose 3201#: reference_processing.xml:1746 3202#, no-c-format 3203msgid "" 3204"Return an offset line at a given distance and side from an input line. " 3205"Useful for computing parallel lines about a center line" 3206msgstr "" 3207 3208#. Tag: funcprototype 3209#: reference_processing.xml:1754 3210#, no-c-format 3211msgid "" 3212"<funcdef>geometry <function>ST_OffsetCurve</function></funcdef> " 3213"<paramdef><type>geometry </type> <parameter>line</parameter></paramdef> " 3214"<paramdef><type>float </type> <parameter>signed_distance</parameter></" 3215"paramdef> <paramdef choice=\"opt\"><type>text </type> " 3216"<parameter>style_parameters=''</parameter></paramdef>" 3217msgstr "" 3218"<funcdef>geometry <function>ST_OffsetCurve</function></funcdef> " 3219"<paramdef><type>geometry </type> <parameter>line</parameter></paramdef> " 3220"<paramdef><type>float </type> <parameter>signed_distance</parameter></" 3221"paramdef> <paramdef choice=\"opt\"><type>text </type> " 3222"<parameter>style_parameters=''</parameter></paramdef>" 3223 3224#. Tag: para 3225#: reference_processing.xml:1767 3226#, no-c-format 3227msgid "" 3228"Return an offset line at a given distance and side from an input line. All " 3229"points of the returned geometries are not further than the given distance " 3230"from the input geometry." 3231msgstr "" 3232 3233#. Tag: para 3234#: reference_processing.xml:1773 3235#, no-c-format 3236msgid "" 3237"For positive distance the offset will be at the left side of the input line " 3238"and retain the same direction. For a negative distance it'll be at the right " 3239"side and in the opposite direction." 3240msgstr "" 3241 3242#. Tag: para 3243#: reference_processing.xml:1778 3244#, no-c-format 3245msgid "" 3246"Note that output may be a MULTILINESTRING or EMPTY for some jigsaw-shaped " 3247"input geometries." 3248msgstr "" 3249 3250#. Tag: para 3251#: reference_processing.xml:1783 3252#, fuzzy, no-c-format 3253msgid "Availability: 2.0" 3254msgstr "Disponibilità: 2.0" 3255 3256#. Tag: para 3257#: reference_processing.xml:1784 3258#, no-c-format 3259msgid "" 3260"Enhanced: 2.5 - added support for GEOMETRYCOLLECTION and MULTILINESTRING" 3261msgstr "" 3262 3263#. Tag: para 3264#: reference_processing.xml:1786 3265#, no-c-format 3266msgid "" 3267"The optional third parameter allows specifying a list of blank-separated " 3268"key=value pairs to tweak operations as follows:" 3269msgstr "" 3270 3271#. Tag: para 3272#: reference_processing.xml:1797 3273#, no-c-format 3274msgid "" 3275"'mitre_limit=#.#' : mitre ratio limit (only affects mitred join style). " 3276"'miter_limit' is also accepted as a synonym for 'mitre_limit'." 3277msgstr "" 3278 3279#. Tag: para 3280#: reference_processing.xml:1802 3281#, no-c-format 3282msgid "" 3283"Units of distance are measured in units of the spatial reference system." 3284msgstr "" 3285 3286#. Tag: para 3287#: reference_processing.xml:1808 3288#, no-c-format 3289msgid "" 3290"This function ignores the third dimension (z) and will always give a 2-d " 3291"result even when presented with a 3d-geometry." 3292msgstr "" 3293 3294#. Tag: para 3295#: reference_processing.xml:1816 3296#, no-c-format 3297msgid "Compute an open buffer around roads" 3298msgstr "" 3299 3300#. Tag: programlisting 3301#: reference_processing.xml:1817 3302#, no-c-format 3303msgid "" 3304"SELECT ST_Union(\n" 3305" ST_OffsetCurve(f.the_geom, f.width/2, 'quad_segs=4 join=round'),\n" 3306" ST_OffsetCurve(f.the_geom, -f.width/2, 'quad_segs=4 join=round')\n" 3307") as track\n" 3308"FROM someroadstable;" 3309msgstr "" 3310"SELECT ST_Union(\n" 3311" ST_OffsetCurve(f.the_geom, f.width/2, 'quad_segs=4 join=round'),\n" 3312" ST_OffsetCurve(f.the_geom, -f.width/2, 'quad_segs=4 join=round')\n" 3313") as track\n" 3314"FROM someroadstable;" 3315 3316#. Tag: para 3317#: reference_processing.xml:1827 3318#, no-c-format 3319msgid "15, 'quad_segs=4 join=round' original line and its offset 15 units." 3320msgstr "" 3321 3322#. Tag: programlisting 3323#: reference_processing.xml:1831 3324#, no-c-format 3325msgid "" 3326"SELECT ST_AsText(ST_OffsetCurve(ST_GeomFromText(\n" 3327"'LINESTRING(164 16,144 16,124 16,104 16,84 16,64 16,\n" 3328" 44 16,24 16,20 16,18 16,17 17,\n" 3329" 16 18,16 20,16 40,16 60,16 80,16 100,\n" 3330" 16 120,16 140,16 160,16 180,16 195)'),\n" 3331" 15, 'quad_segs=4 join=round'));\n" 3332"--output --\n" 3333"LINESTRING(164 1,18 1,12.2597485145237 2.1418070123307,\n" 3334" 7.39339828220179 5.39339828220179,\n" 3335" 5.39339828220179 7.39339828220179,\n" 3336" 2.14180701233067 12.2597485145237,1 18,1 195)" 3337msgstr "" 3338"SELECT ST_AsText(ST_OffsetCurve(ST_GeomFromText(\n" 3339"'LINESTRING(164 16,144 16,124 16,104 16,84 16,64 16,\n" 3340" 44 16,24 16,20 16,18 16,17 17,\n" 3341" 16 18,16 20,16 40,16 60,16 80,16 100,\n" 3342" 16 120,16 140,16 160,16 180,16 195)'),\n" 3343" 15, 'quad_segs=4 join=round'));\n" 3344"--output --\n" 3345"LINESTRING(164 1,18 1,12.2597485145237 2.1418070123307,\n" 3346" 7.39339828220179 5.39339828220179,\n" 3347" 5.39339828220179 7.39339828220179,\n" 3348" 2.14180701233067 12.2597485145237,1 18,1 195)" 3349 3350#. Tag: para 3351#: reference_processing.xml:1838 3352#, no-c-format 3353msgid "-15, 'quad_segs=4 join=round' original line and its offset -15 units" 3354msgstr "" 3355 3356#. Tag: programlisting 3357#: reference_processing.xml:1842 3358#, no-c-format 3359msgid "" 3360"SELECT ST_AsText(ST_OffsetCurve(geom,\n" 3361" -15, 'quad_segs=4 join=round')) As notsocurvy\n" 3362" FROM ST_GeomFromText(\n" 3363"'LINESTRING(164 16,144 16,124 16,104 16,84 16,64 16,\n" 3364" 44 16,24 16,20 16,18 16,17 17,\n" 3365" 16 18,16 20,16 40,16 60,16 80,16 100,\n" 3366" 16 120,16 140,16 160,16 180,16 195)') As geom;\n" 3367"-- notsocurvy --\n" 3368"LINESTRING(31 195,31 31,164 31)" 3369msgstr "" 3370"SELECT ST_AsText(ST_OffsetCurve(geom,\n" 3371" -15, 'quad_segs=4 join=round')) As notsocurvy\n" 3372" FROM ST_GeomFromText(\n" 3373"'LINESTRING(164 16,144 16,124 16,104 16,84 16,64 16,\n" 3374" 44 16,24 16,20 16,18 16,17 17,\n" 3375" 16 18,16 20,16 40,16 60,16 80,16 100,\n" 3376" 16 120,16 140,16 160,16 180,16 195)') As geom;\n" 3377"-- notsocurvy --\n" 3378"LINESTRING(31 195,31 31,164 31)" 3379 3380#. Tag: para 3381#: reference_processing.xml:1851 3382#, no-c-format 3383msgid "" 3384"double-offset to get more curvy, note the first reverses direction, so -30 + " 3385"15 = -15" 3386msgstr "" 3387 3388#. Tag: programlisting 3389#: reference_processing.xml:1854 3390#, no-c-format 3391msgid "" 3392"SELECT ST_AsText(ST_OffsetCurve(ST_OffsetCurve(geom,\n" 3393" -30, 'quad_segs=4 join=round'), -15, 'quad_segs=4 join=round')) As " 3394"morecurvy\n" 3395" FROM ST_GeomFromText(\n" 3396"'LINESTRING(164 16,144 16,124 16,104 16,84 16,64 16,\n" 3397" 44 16,24 16,20 16,18 16,17 17,\n" 3398" 16 18,16 20,16 40,16 60,16 80,16 100,\n" 3399" 16 120,16 140,16 160,16 180,16 195)') As geom;\n" 3400"-- morecurvy --\n" 3401"LINESTRING(164 31,46 31,40.2597485145236 32.1418070123307,\n" 3402"35.3933982822018 35.3933982822018,\n" 3403"32.1418070123307 40.2597485145237,31 46,31 195)" 3404msgstr "" 3405"SELECT ST_AsText(ST_OffsetCurve(ST_OffsetCurve(geom,\n" 3406" -30, 'quad_segs=4 join=round'), -15, 'quad_segs=4 join=round')) As " 3407"morecurvy\n" 3408" FROM ST_GeomFromText(\n" 3409"'LINESTRING(164 16,144 16,124 16,104 16,84 16,64 16,\n" 3410" 44 16,24 16,20 16,18 16,17 17,\n" 3411" 16 18,16 20,16 40,16 60,16 80,16 100,\n" 3412" 16 120,16 140,16 160,16 180,16 195)') As geom;\n" 3413"-- morecurvy --\n" 3414"LINESTRING(164 31,46 31,40.2597485145236 32.1418070123307,\n" 3415"35.3933982822018 35.3933982822018,\n" 3416"32.1418070123307 40.2597485145237,31 46,31 195)" 3417 3418#. Tag: para 3419#: reference_processing.xml:1861 3420#, no-c-format 3421msgid "" 3422"double-offset to get more curvy,combined with regular offset 15 to get " 3423"parallel lines. Overlaid with original." 3424msgstr "" 3425 3426#. Tag: programlisting 3427#: reference_processing.xml:1864 3428#, fuzzy, no-c-format 3429msgid "" 3430"SELECT ST_AsText(ST_Collect(\n" 3431" ST_OffsetCurve(geom, 15, 'quad_segs=4 join=round'),\n" 3432" ST_OffsetCurve(ST_OffsetCurve(geom,\n" 3433" -30, 'quad_segs=4 join=round'), -15, 'quad_segs=4 join=round')\n" 3434" )\n" 3435") As parallel_curves\n" 3436" FROM ST_GeomFromText(\n" 3437"'LINESTRING(164 16,144 16,124 16,104 16,84 16,64 16,\n" 3438" 44 16,24 16,20 16,18 16,17 17,\n" 3439" 16 18,16 20,16 40,16 60,16 80,16 100,\n" 3440" 16 120,16 140,16 160,16 180,16 195)') As geom;\n" 3441"-- parallel curves --\n" 3442"MULTILINESTRING((164 1,18 1,12.2597485145237 2.1418070123307,\n" 3443"7.39339828220179 5.39339828220179,5.39339828220179 7.39339828220179,\n" 3444"2.14180701233067 12.2597485145237,1 18,1 195),\n" 3445"(164 31,46 31,40.2597485145236 32.1418070123307,35.3933982822018 " 3446"35.3933982822018,\n" 3447"32.1418070123307 40.2597485145237,31 46,31 195))" 3448msgstr "" 3449"SELECT ST_AsText(ST_Collect(\n" 3450" ST_OffsetCurve(geom, 15, 'quad_segs=4 join=round'), \n" 3451" ST_OffsetCurve(ST_OffsetCurve(geom,\n" 3452" -30, 'quad_segs=4 join=round'), -15, 'quad_segs=4 join=round')\n" 3453" )\n" 3454") As parallel_curves\n" 3455" FROM ST_GeomFromText(\n" 3456"'LINESTRING(164 16,144 16,124 16,104 16,84 16,64 16,\n" 3457" 44 16,24 16,20 16,18 16,17 17,\n" 3458" 16 18,16 20,16 40,16 60,16 80,16 100,\n" 3459" 16 120,16 140,16 160,16 180,16 195)') As geom;\n" 3460"-- parallel curves --\n" 3461"MULTILINESTRING((164 1,18 1,12.2597485145237 2.1418070123307,\n" 3462"7.39339828220179 5.39339828220179,5.39339828220179 7.39339828220179,\n" 3463"2.14180701233067 12.2597485145237,1 18,1 195),\n" 3464"(164 31,46 31,40.2597485145236 32.1418070123307,35.3933982822018 " 3465"35.3933982822018,\n" 3466"32.1418070123307 40.2597485145237,31 46,31 195))" 3467 3468#. Tag: para 3469#: reference_processing.xml:1873 3470#, no-c-format 3471msgid "15, 'quad_segs=4 join=bevel' shown with original line" 3472msgstr "" 3473 3474#. Tag: programlisting 3475#: reference_processing.xml:1876 3476#, fuzzy, no-c-format 3477msgid "" 3478"SELECT ST_AsText(ST_OffsetCurve(ST_GeomFromText(\n" 3479"'LINESTRING(164 16,144 16,124 16,104 16,84 16,64 16,\n" 3480" 44 16,24 16,20 16,18 16,17 17,\n" 3481" 16 18,16 20,16 40,16 60,16 80,16 100,\n" 3482" 16 120,16 140,16 160,16 180,16 195)'),\n" 3483" 15, 'quad_segs=4 join=bevel'));\n" 3484"-- output --\n" 3485"LINESTRING(164 1,18 1,7.39339828220179 5.39339828220179,\n" 3486" 5.39339828220179 7.39339828220179,1 18,1 195)" 3487msgstr "" 3488"SELECT ST_AsText(ST_OffsetCurve(ST_GeomFromText(\n" 3489"'LINESTRING(164 16,144 16,124 16,104 16,84 16,64 16,\n" 3490" 44 16,24 16,20 16,18 16,17 17,\n" 3491" 16 18,16 20,16 40,16 60,16 80,16 100,\n" 3492" 16 120,16 140,16 160,16 180,16 195)'), \n" 3493" 15, 'quad_segs=4 join=bevel'));\n" 3494"-- output --\n" 3495"LINESTRING(164 1,18 1,7.39339828220179 5.39339828220179,\n" 3496" 5.39339828220179 7.39339828220179,1 18,1 195)" 3497 3498#. Tag: para 3499#: reference_processing.xml:1884 3500#, no-c-format 3501msgid "15,-15 collected, join=mitre mitre_limit=2.1" 3502msgstr "" 3503 3504#. Tag: programlisting 3505#: reference_processing.xml:1887 3506#, no-c-format 3507msgid "" 3508"SELECT ST_AsText(ST_Collect(\n" 3509" ST_OffsetCurve(geom, 15, 'quad_segs=4 join=mitre mitre_limit=2.2'),\n" 3510" ST_OffsetCurve(geom, -15, 'quad_segs=4 join=mitre mitre_limit=2.2')\n" 3511" ) )\n" 3512" FROM ST_GeomFromText(\n" 3513"'LINESTRING(164 16,144 16,124 16,104 16,84 16,64 16,\n" 3514" 44 16,24 16,20 16,18 16,17 17,\n" 3515" 16 18,16 20,16 40,16 60,16 80,16 100,\n" 3516" 16 120,16 140,16 160,16 180,16 195)') As geom;\n" 3517"-- output --\n" 3518"MULTILINESTRING((164 1,11.7867965644036 1,1 11.7867965644036,1 195),\n" 3519" (31 195,31 31,164 31))" 3520msgstr "" 3521"SELECT ST_AsText(ST_Collect(\n" 3522" ST_OffsetCurve(geom, 15, 'quad_segs=4 join=mitre mitre_limit=2.2'),\n" 3523" ST_OffsetCurve(geom, -15, 'quad_segs=4 join=mitre mitre_limit=2.2')\n" 3524" ) )\n" 3525" FROM ST_GeomFromText(\n" 3526"'LINESTRING(164 16,144 16,124 16,104 16,84 16,64 16,\n" 3527" 44 16,24 16,20 16,18 16,17 17,\n" 3528" 16 18,16 20,16 40,16 60,16 80,16 100,\n" 3529" 16 120,16 140,16 160,16 180,16 195)') As geom;\n" 3530"-- output --\n" 3531"MULTILINESTRING((164 1,11.7867965644036 1,1 11.7867965644036,1 195),\n" 3532" (31 195,31 31,164 31))" 3533 3534#. Tag: refname 3535#: reference_processing.xml:1904 3536#, no-c-format 3537msgid "ST_PointOnSurface" 3538msgstr "" 3539 3540#. Tag: refpurpose 3541#: reference_processing.xml:1906 3542#, no-c-format 3543msgid "Returns a <varname>POINT</varname> guaranteed to lie on the surface." 3544msgstr "" 3545 3546#. Tag: funcprototype 3547#: reference_processing.xml:1911 3548#, fuzzy, no-c-format 3549msgid "" 3550"<funcdef>geometry <function>ST_PointOnSurface</function></funcdef> " 3551"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 3552msgstr "" 3553"<funcdef>geometry <function>ST_Node</function></funcdef> " 3554"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 3555 3556#. Tag: para 3557#: reference_processing.xml:1923 3558#, no-c-format 3559msgid "Returns a <varname>POINT</varname> guaranteed to intersect a surface." 3560msgstr "" 3561 3562#. Tag: para 3563#: reference_processing.xml:1925 3564#, fuzzy, no-c-format 3565msgid "&sfs_compliant; s3.2.14.2 // s3.2.18.2" 3566msgstr "&sfs_compliant; s2.1.1.3" 3567 3568#. Tag: para 3569#: reference_processing.xml:1926 3570#, no-c-format 3571msgid "" 3572"&sqlmm_compliant; SQL-MM 3: 8.1.5, 9.5.6. According to the specs, " 3573"ST_PointOnSurface works for surface geometries (POLYGONs, MULTIPOLYGONS, " 3574"CURVED POLYGONS). So PostGIS seems to be extending what the spec allows " 3575"here. Most databases Oracle,DB II, ESRI SDE seem to only support this " 3576"function for surfaces. SQL Server 2008 like PostGIS supports for all common " 3577"geometries." 3578msgstr "" 3579 3580#. Tag: programlisting 3581#: reference_processing.xml:1935 3582#, no-c-format 3583msgid "" 3584"SELECT ST_AsText(ST_PointOnSurface('POINT(0 5)'::geometry));\n" 3585" st_astext\n" 3586"------------\n" 3587" POINT(0 5)\n" 3588"(1 row)\n" 3589"\n" 3590"SELECT ST_AsText(ST_PointOnSurface('LINESTRING(0 5, 0 10)'::geometry));\n" 3591" st_astext\n" 3592"------------\n" 3593" POINT(0 5)\n" 3594"(1 row)\n" 3595"\n" 3596"SELECT ST_AsText(ST_PointOnSurface('POLYGON((0 0, 0 5, 5 5, 5 0, 0 0))'::" 3597"geometry));\n" 3598" st_astext\n" 3599"----------------\n" 3600" POINT(2.5 2.5)\n" 3601"(1 row)\n" 3602"\n" 3603"SELECT ST_AsEWKT(ST_PointOnSurface(ST_GeomFromEWKT('LINESTRING(0 5 1, 0 0 1, " 3604"0 10 2)')));\n" 3605" st_asewkt\n" 3606"----------------\n" 3607" POINT(0 0 1)\n" 3608"(1 row)" 3609msgstr "" 3610 3611#. Tag: para 3612#: reference_processing.xml:1941 3613#, fuzzy, no-c-format 3614msgid ", <xref linkend=\"ST_PointInsideCircle\"/>" 3615msgstr ", <xref linkend=\"ST_Union\"/>" 3616 3617#. Tag: refname 3618#: reference_processing.xml:1947 3619#, no-c-format 3620msgid "ST_RemoveRepeatedPoints" 3621msgstr "ST_RemoveRepeatedPoints" 3622 3623#. Tag: refpurpose 3624#: reference_processing.xml:1948 3625#, no-c-format 3626msgid "Returns a version of the given geometry with duplicated points removed." 3627msgstr "" 3628 3629#. Tag: funcprototype 3630#: reference_processing.xml:1954 3631#, no-c-format 3632msgid "" 3633"<funcdef>geometry <function>ST_RemoveRepeatedPoints</function></funcdef> " 3634"<paramdef><type>geometry</type> <parameter>geom</parameter></paramdef> " 3635"<paramdef choice=\"opt\"><type>float8</type> <parameter>tolerance</" 3636"parameter></paramdef>" 3637msgstr "" 3638 3639#. Tag: para 3640#: reference_processing.xml:1964 3641#, no-c-format 3642msgid "" 3643"Returns a version of the given geometry with duplicated points removed. Will " 3644"actually do something only with (multi)lines, (multi)polygons and " 3645"multipoints but you can safely call it with any kind of geometry. Since " 3646"simplification occurs on a object-by-object basis you can also feed a " 3647"GeometryCollection to this function." 3648msgstr "" 3649 3650#. Tag: para 3651#: reference_processing.xml:1970 3652#, no-c-format 3653msgid "" 3654"If the tolerance parameter is provided, vertices within the tolerance of one " 3655"another will be considered the \"same\" for the purposes of removal." 3656msgstr "" 3657 3658#. Tag: refname 3659#: reference_processing.xml:1986 3660#, no-c-format 3661msgid "ST_SharedPaths" 3662msgstr "ST_SharedPaths" 3663 3664#. Tag: refpurpose 3665#: reference_processing.xml:1987 3666#, no-c-format 3667msgid "" 3668"Returns a collection containing paths shared by the two input linestrings/" 3669"multilinestrings." 3670msgstr "" 3671 3672#. Tag: funcprototype 3673#: reference_processing.xml:1992 3674#, no-c-format 3675msgid "" 3676"<funcdef>geometry <function>ST_SharedPaths</function></funcdef> " 3677"<paramdef><type>geometry</type> <parameter>lineal1</parameter></paramdef> " 3678"<paramdef><type>geometry</type> <parameter>lineal2</parameter></paramdef>" 3679msgstr "" 3680"<funcdef>geometry <function>ST_SharedPaths</function></funcdef> " 3681"<paramdef><type>geometry</type> <parameter>lineal1</parameter></paramdef> " 3682"<paramdef><type>geometry</type> <parameter>lineal2</parameter></paramdef>" 3683 3684#. Tag: para 3685#: reference_processing.xml:2002 3686#, no-c-format 3687msgid "" 3688"Returns a collection containing paths shared by the two input geometries. " 3689"Those going in the same direction are in the first element of the " 3690"collection, those going in the opposite direction are in the second element. " 3691"The paths themselves are given in the direction of the first geometry." 3692msgstr "" 3693 3694#. Tag: title 3695#: reference_processing.xml:2010 3696#, no-c-format 3697msgid "Examples: Finding shared paths" 3698msgstr "" 3699 3700#. Tag: para 3701#: reference_processing.xml:2020 3702#, no-c-format 3703msgid "A multilinestring and a linestring" 3704msgstr "" 3705 3706#. Tag: para 3707#: reference_processing.xml:2031 3708#, no-c-format 3709msgid "" 3710"The shared path of multilinestring and linestring overlaid with original " 3711"geometries." 3712msgstr "" 3713 3714#. Tag: programlisting 3715#: reference_processing.xml:2034 3716#, fuzzy, no-c-format 3717msgid "" 3718"SELECT ST_AsText(\n" 3719" ST_SharedPaths(\n" 3720" ST_GeomFromText('MULTILINESTRING((26 125,26 200,126 200,126 125,26 " 3721"125),\n" 3722" (51 150,101 150,76 175,51 150))'),\n" 3723" ST_GeomFromText('LINESTRING(151 100,126 156.25,126 125,90 161, 76 " 3724"175)')\n" 3725" )\n" 3726" ) As wkt\n" 3727"\n" 3728" wkt\n" 3729"-------------------------------------------------------------\n" 3730"GEOMETRYCOLLECTION(MULTILINESTRING((126 156.25,126 125),\n" 3731" (101 150,90 161),(90 161,76 175)),MULTILINESTRING EMPTY)" 3732msgstr "" 3733"SELECT ST_AsText(\n" 3734" ST_SharedPaths(\n" 3735" ST_GeomFromText('MULTILINESTRING((26 125,26 200,126 200,126 125,26 " 3736"125),\n" 3737" (51 150,101 150,76 175,51 150))'),\n" 3738" ST_GeomFromText('LINESTRING(151 100,126 156.25,126 125,90 161, 76 " 3739"175)')\n" 3740" )\n" 3741" ) As wkt\n" 3742"\n" 3743" wkt\n" 3744"-------------------------------------------------------------\n" 3745"GEOMETRYCOLLECTION(MULTILINESTRING((126 156.25,126 125),\n" 3746" (101 150,90 161),(90 161,76 175)),MULTILINESTRING EMPTY)" 3747 3748#. Tag: programlisting 3749#: reference_processing.xml:2040 3750#, fuzzy, no-c-format 3751msgid "" 3752"-- same example but linestring orientation flipped\n" 3753"SELECT ST_AsText(\n" 3754" ST_SharedPaths(\n" 3755" ST_GeomFromText('LINESTRING(76 175,90 161,126 125,126 156.25,151 100)'),\n" 3756" ST_GeomFromText('MULTILINESTRING((26 125,26 200,126 200,126 125,26 125),\n" 3757" (51 150,101 150,76 175,51 150))')\n" 3758" )\n" 3759" ) As wkt\n" 3760"\n" 3761" wkt\n" 3762"-------------------------------------------------------------\n" 3763"GEOMETRYCOLLECTION(MULTILINESTRING EMPTY,\n" 3764"MULTILINESTRING((76 175,90 161),(90 161,101 150),(126 125,126 156.25)))" 3765msgstr "" 3766"SELECT ST_AsText(\n" 3767" ST_SharedPaths(\n" 3768" ST_GeomFromText('MULTILINESTRING((26 125,26 200,126 200,126 125,26 " 3769"125),\n" 3770" (51 150,101 150,76 175,51 150))'),\n" 3771" ST_GeomFromText('LINESTRING(151 100,126 156.25,126 125,90 161, 76 " 3772"175)')\n" 3773" )\n" 3774" ) As wkt\n" 3775"\n" 3776" wkt\n" 3777"-------------------------------------------------------------\n" 3778"GEOMETRYCOLLECTION(MULTILINESTRING((126 156.25,126 125),\n" 3779" (101 150,90 161),(90 161,76 175)),MULTILINESTRING EMPTY)" 3780 3781#. Tag: para 3782#: reference_processing.xml:2050 3783#, no-c-format 3784msgid "" 3785", <xref linkend=\"ST_GeometryN\"/>, <xref linkend=\"ST_NumGeometries\"/>" 3786msgstr "" 3787", <xref linkend=\"ST_GeometryN\"/>, <xref linkend=\"ST_NumGeometries\"/>" 3788 3789#. Tag: refname 3790#: reference_processing.xml:2060 3791#, no-c-format 3792msgid "ST_ShiftLongitude" 3793msgstr "" 3794 3795#. Tag: refpurpose 3796#: reference_processing.xml:2062 3797#, no-c-format 3798msgid "Toggle geometry coordinates between -180..180 and 0..360 ranges." 3799msgstr "" 3800 3801#. Tag: funcprototype 3802#: reference_processing.xml:2067 3803#, no-c-format 3804msgid "" 3805"<funcdef>geometry <function>ST_ShiftLongitude</function></funcdef> " 3806"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 3807msgstr "" 3808 3809#. Tag: para 3810#: reference_processing.xml:2077 3811#, no-c-format 3812msgid "" 3813"Reads every point/vertex in every component of every feature in a geometry, " 3814"and if the longitude coordinate is <0, adds 360 to it. The result would " 3815"be a 0-360 version of the data to be plotted in a 180 centric map" 3816msgstr "" 3817 3818#. Tag: para 3819#: reference_processing.xml:2081 3820#, no-c-format 3821msgid "This is only useful for data in long lat e.g. 4326 (WGS 84 long lat)" 3822msgstr "" 3823 3824#. Tag: para 3825#: reference_processing.xml:2084 3826#, no-c-format 3827msgid "" 3828"Pre-1.3.4 bug prevented this from working for MULTIPOINT. 1.3.4+ works with " 3829"MULTIPOINT as well." 3830msgstr "" 3831 3832#. Tag: para 3833#: reference_processing.xml:2088 3834#, no-c-format 3835msgid "Enhanced: 2.0.0 support for Polyhedral surfaces and TIN was introduced." 3836msgstr "" 3837 3838#. Tag: para 3839#: reference_processing.xml:2089 3840#, no-c-format 3841msgid "NOTE: this function was renamed from \"ST_Shift_Longitude\" in 2.2.0" 3842msgstr "" 3843 3844#. Tag: programlisting 3845#: reference_processing.xml:2098 3846#, no-c-format 3847msgid "" 3848"--3d points\n" 3849"SELECT ST_AsEWKT(ST_ShiftLongitude(ST_GeomFromEWKT('SRID=4326;POINT(-118.58 " 3850"38.38 10)'))) As geomA,\n" 3851" ST_AsEWKT(ST_ShiftLongitude(ST_GeomFromEWKT('SRID=4326;POINT(241.42 " 3852"38.38 10)'))) As geomb\n" 3853"geomA geomB\n" 3854"---------- -----------\n" 3855"SRID=4326;POINT(241.42 38.38 10) SRID=4326;POINT(-118.58 38.38 10)\n" 3856"\n" 3857"--regular line string\n" 3858"SELECT ST_AsText(ST_ShiftLongitude(ST_GeomFromText('LINESTRING(-118.58 " 3859"38.38, -118.20 38.45)')))\n" 3860"\n" 3861"st_astext\n" 3862"----------\n" 3863"LINESTRING(241.42 38.38,241.8 38.45)" 3864msgstr "" 3865 3866#. Tag: refname 3867#: reference_processing.xml:2112 3868#, no-c-format 3869msgid "ST_WrapX" 3870msgstr "" 3871 3872#. Tag: refpurpose 3873#: reference_processing.xml:2114 3874#, no-c-format 3875msgid "Wrap a geometry around an X value." 3876msgstr "" 3877 3878#. Tag: funcprototype 3879#: reference_processing.xml:2119 3880#, fuzzy, no-c-format 3881msgid "" 3882"<funcdef>geometry <function>ST_WrapX</function></funcdef> " 3883"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> " 3884"<paramdef><type>float8 </type> <parameter>wrap</parameter></paramdef> " 3885"<paramdef><type>float8 </type> <parameter>move</parameter></paramdef>" 3886msgstr "" 3887"<funcdef>geometry <function>ST_ConcaveHull</function></funcdef> " 3888"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 3889"<paramdef><type>float </type> <parameter>target_percent</parameter></" 3890"paramdef> <paramdef choice=\"opt\"><type>boolean </type> " 3891"<parameter>allow_holes=false</parameter></paramdef>" 3892 3893#. Tag: para 3894#: reference_processing.xml:2131 3895#, no-c-format 3896msgid "" 3897"This function splits the input geometries and then moves every resulting " 3898"component falling on the right (for negative 'move') or on the left (for " 3899"positive 'move') of given 'wrap' line in the direction specified by the " 3900"'move' parameter, finally re-unioning the pieces togheter." 3901msgstr "" 3902 3903#. Tag: para 3904#: reference_processing.xml:2138 3905#, no-c-format 3906msgid "" 3907"This is useful to \"recenter\" long-lat input to have features of interest " 3908"not spawned from one side to the other." 3909msgstr "" 3910 3911#. Tag: programlisting 3912#: reference_processing.xml:2156 3913#, no-c-format 3914msgid "" 3915"-- Move all components of the given geometries whose bounding box\n" 3916"-- falls completely on the left of x=0 to +360\n" 3917"select ST_WrapX(the_geom, 0, 360);\n" 3918"\n" 3919"-- Move all components of the given geometries whose bounding box\n" 3920"-- falls completely on the left of x=-30 to +360\n" 3921"select ST_WrapX(the_geom, -30, 360);" 3922msgstr "" 3923 3924#. Tag: refname 3925#: reference_processing.xml:2168 3926#, no-c-format 3927msgid "ST_Simplify" 3928msgstr "ST_Simplify" 3929 3930#. Tag: refpurpose 3931#: reference_processing.xml:2169 3932#, no-c-format 3933msgid "" 3934"Returns a \"simplified\" version of the given geometry using the Douglas-" 3935"Peucker algorithm." 3936msgstr "" 3937 3938#. Tag: funcprototype 3939#: reference_processing.xml:2175 3940#, fuzzy, no-c-format 3941msgid "" 3942"<funcdef>geometry <function>ST_Simplify</function></funcdef> " 3943"<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 3944"<paramdef><type>float</type> <parameter>tolerance</parameter></paramdef> " 3945"<paramdef><type>boolean</type> <parameter>preserveCollapsed</parameter></" 3946"paramdef>" 3947msgstr "" 3948"<funcdef>geometry <function>ST_ConcaveHull</function></funcdef> " 3949"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 3950"<paramdef><type>float </type> <parameter>target_percent</parameter></" 3951"paramdef> <paramdef choice=\"opt\"><type>boolean </type> " 3952"<parameter>allow_holes=false</parameter></paramdef>" 3953 3954#. Tag: para 3955#: reference_processing.xml:2186 3956#, no-c-format 3957msgid "" 3958"Returns a \"simplified\" version of the given geometry using the Douglas-" 3959"Peucker algorithm. Will actually do something only with (multi)lines and " 3960"(multi)polygons but you can safely call it with any kind of geometry. Since " 3961"simplification occurs on a object-by-object basis you can also feed a " 3962"GeometryCollection to this function." 3963msgstr "" 3964 3965#. Tag: para 3966#: reference_processing.xml:2193 3967#, no-c-format 3968msgid "" 3969"The \"preserve collapsed\" flag will retain objects that would otherwise be " 3970"too small given the tolerance. For example, a 1m long line simplified with a " 3971"10m tolerance. If the preserve flag is given, the line will not disappear. " 3972"This flag is useful for rendering engines, to avoid having large numbers of " 3973"very small objects disappear from a map leaving surprising gaps." 3974msgstr "" 3975 3976#. Tag: para 3977#: reference_processing.xml:2199 reference_processing.xml:2282 3978#: reference_processing.xml:2430 3979#, no-c-format 3980msgid "" 3981"Note that returned geometry might lose its simplicity (see <xref linkend=" 3982"\"ST_IsSimple\"/>)" 3983msgstr "" 3984 3985#. Tag: para 3986#: reference_processing.xml:2201 reference_processing.xml:2284 3987#: reference_processing.xml:2432 3988#, no-c-format 3989msgid "" 3990"Note topology may not be preserved and may result in invalid geometries. Use " 3991"(see <xref linkend=\"ST_SimplifyPreserveTopology\"/>) to preserve topology." 3992msgstr "" 3993 3994#. Tag: para 3995#: reference_processing.xml:2203 3996#, no-c-format 3997msgid "Availability: 1.2.2" 3998msgstr "" 3999 4000#. Tag: para 4001#: reference_processing.xml:2208 4002#, no-c-format 4003msgid "A circle simplified too much becomes a triangle, medium an octagon," 4004msgstr "" 4005 4006#. Tag: programlisting 4007#: reference_processing.xml:2209 4008#, fuzzy, no-c-format 4009msgid "" 4010"SELECT ST_Npoints(the_geom) AS np_before,\n" 4011" ST_NPoints(ST_Simplify(the_geom,0.1)) AS np01_notbadcircle,\n" 4012" ST_NPoints(ST_Simplify(the_geom,0.5)) AS np05_notquitecircle,\n" 4013" ST_NPoints(ST_Simplify(the_geom,1)) AS np1_octagon,\n" 4014" ST_NPoints(ST_Simplify(the_geom,10)) AS np10_triangle,\n" 4015" (ST_Simplify(the_geom,100) is null) AS np100_geometrygoesaway\n" 4016" FROM\n" 4017" (SELECT ST_Buffer('POINT(1 3)', 10,12) As the_geom) AS foo;\n" 4018"\n" 4019" np_before | np01_notbadcircle | np05_notquitecircle | np1_octagon | " 4020"np10_triangle | np100_geometrygoesaway\n" 4021"-----------+-------------------+---------------------+-------------" 4022"+---------------+------------------------\n" 4023" 49 | 33 | 17 | 9 " 4024"| 4 | t" 4025msgstr "" 4026"SELECT ST_Npoints(the_geom) As np_before, " 4027"ST_NPoints(ST_Simplify(the_geom,0.1)) As np01_notbadcircle, " 4028"ST_NPoints(ST_Simplify(the_geom,0.5)) As np05_notquitecircle,\n" 4029"ST_NPoints(ST_Simplify(the_geom,1)) As np1_octagon, " 4030"ST_NPoints(ST_Simplify(the_geom,10)) As np10_triangle,\n" 4031"(ST_Simplify(the_geom,100) is null) As np100_geometrygoesaway\n" 4032"FROM (SELECT ST_Buffer('POINT(1 3)', 10,12) As the_geom) As foo;\n" 4033"-result\n" 4034" np_before | np01_notbadcircle | np05_notquitecircle | np1_octagon | " 4035"np10_triangle | np100_geometrygoesaway\n" 4036"-----------+-------------------+---------------------+-------------" 4037"+---------------+------------------------\n" 4038" 49 | 33 | 17 | 9 " 4039"| 4 | t" 4040 4041#. Tag: para 4042#: reference_processing.xml:2213 4043#, no-c-format 4044msgid "" 4045", <xref linkend=\"ST_SimplifyPreserveTopology\"/>, Topology <xref linkend=" 4046"\"TP_ST_Simplify\"/>" 4047msgstr "" 4048 4049#. Tag: refname 4050#: reference_processing.xml:2219 4051#, no-c-format 4052msgid "ST_SimplifyPreserveTopology" 4053msgstr "ST_SimplifyPreserveTopology" 4054 4055#. Tag: refpurpose 4056#: reference_processing.xml:2220 4057#, no-c-format 4058msgid "" 4059"Returns a \"simplified\" version of the given geometry using the Douglas-" 4060"Peucker algorithm. Will avoid creating derived geometries (polygons in " 4061"particular) that are invalid." 4062msgstr "" 4063 4064#. Tag: funcprototype 4065#: reference_processing.xml:2227 4066#, no-c-format 4067msgid "" 4068"<funcdef>geometry <function>ST_SimplifyPreserveTopology</function></funcdef> " 4069"<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 4070"<paramdef><type>float</type> <parameter>tolerance</parameter></paramdef>" 4071msgstr "" 4072"<funcdef>geometry <function>ST_SimplifyPreserveTopology</function></funcdef> " 4073"<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 4074"<paramdef><type>float</type> <parameter>tolerance</parameter></paramdef>" 4075 4076#. Tag: para 4077#: reference_processing.xml:2237 4078#, no-c-format 4079msgid "" 4080"Returns a \"simplified\" version of the given geometry using the Douglas-" 4081"Peucker algorithm. Will avoid creating derived geometries (polygons in " 4082"particular) that are invalid. Will actually do something only with " 4083"(multi)lines and (multi)polygons but you can safely call it with any kind of " 4084"geometry. Since simplification occurs on a object-by-object basis you can " 4085"also feed a GeometryCollection to this function." 4086msgstr "" 4087 4088#. Tag: para 4089#: reference_processing.xml:2246 4090#, no-c-format 4091msgid "Availability: 1.3.3" 4092msgstr "" 4093 4094#. Tag: para 4095#: reference_processing.xml:2251 4096#, no-c-format 4097msgid "" 4098"Same example as Simplify, but we see Preserve Topology prevents " 4099"oversimplification. The circle can at most become a square." 4100msgstr "" 4101 4102#. Tag: programlisting 4103#: reference_processing.xml:2252 4104#, no-c-format 4105msgid "" 4106"SELECT ST_Npoints(the_geom) As np_before, " 4107"ST_NPoints(ST_SimplifyPreserveTopology(the_geom,0.1)) As np01_notbadcircle, " 4108"ST_NPoints(ST_SimplifyPreserveTopology(the_geom,0.5)) As " 4109"np05_notquitecircle,\n" 4110"ST_NPoints(ST_SimplifyPreserveTopology(the_geom,1)) As np1_octagon, " 4111"ST_NPoints(ST_SimplifyPreserveTopology(the_geom,10)) As np10_square,\n" 4112"ST_NPoints(ST_SimplifyPreserveTopology(the_geom,100)) As np100_stillsquare\n" 4113"FROM (SELECT ST_Buffer('POINT(1 3)', 10,12) As the_geom) As foo;\n" 4114"\n" 4115"--result--\n" 4116" np_before | np01_notbadcircle | np05_notquitecircle | np1_octagon | " 4117"np10_square | np100_stillsquare\n" 4118"-----------+-------------------+---------------------+-------------" 4119"+---------------+-------------------\n" 4120" 49 | 33 | 17 | 9 " 4121"| 5 | 5" 4122msgstr "" 4123"SELECT ST_Npoints(the_geom) As np_before, " 4124"ST_NPoints(ST_SimplifyPreserveTopology(the_geom,0.1)) As np01_notbadcircle, " 4125"ST_NPoints(ST_SimplifyPreserveTopology(the_geom,0.5)) As " 4126"np05_notquitecircle,\n" 4127"ST_NPoints(ST_SimplifyPreserveTopology(the_geom,1)) As np1_octagon, " 4128"ST_NPoints(ST_SimplifyPreserveTopology(the_geom,10)) As np10_square,\n" 4129"ST_NPoints(ST_SimplifyPreserveTopology(the_geom,100)) As np100_stillsquare\n" 4130"FROM (SELECT ST_Buffer('POINT(1 3)', 10,12) As the_geom) As foo;\n" 4131"\n" 4132"--result--\n" 4133" np_before | np01_notbadcircle | np05_notquitecircle | np1_octagon | " 4134"np10_square | np100_stillsquare\n" 4135"-----------+-------------------+---------------------+-------------" 4136"+---------------+-------------------\n" 4137" 49 | 33 | 17 | 9 " 4138"| 5 | 5" 4139 4140#. Tag: refname 4141#: reference_processing.xml:2262 4142#, no-c-format 4143msgid "ST_SimplifyVW" 4144msgstr "" 4145 4146#. Tag: refpurpose 4147#: reference_processing.xml:2263 4148#, no-c-format 4149msgid "" 4150"Returns a \"simplified\" version of the given geometry using the Visvalingam-" 4151"Whyatt algorithm" 4152msgstr "" 4153 4154#. Tag: funcprototype 4155#: reference_processing.xml:2268 4156#, no-c-format 4157msgid "" 4158"<funcdef>geometry <function>ST_SimplifyVW</function></funcdef> " 4159"<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 4160"<paramdef><type>float</type> <parameter>tolerance</parameter></paramdef>" 4161msgstr "" 4162 4163#. Tag: para 4164#: reference_processing.xml:2278 4165#, no-c-format 4166msgid "" 4167"Returns a \"simplified\" version of the given geometry using the Visvalingam-" 4168"Whyatt algorithm. Will actually do something only with (multi)lines and " 4169"(multi)polygons but you can safely call it with any kind of geometry. Since " 4170"simplification occurs on a object-by-object basis you can also feed a " 4171"GeometryCollection to this function." 4172msgstr "" 4173 4174#. Tag: para 4175#: reference_processing.xml:2285 reference_processing.xml:2327 4176#, no-c-format 4177msgid "" 4178"This function handles 3D and the third dimension will affect the result." 4179msgstr "" 4180 4181#. Tag: para 4182#: reference_processing.xml:2291 4183#, no-c-format 4184msgid "A LineString is simplified with a minimum area threshold of 30." 4185msgstr "" 4186 4187#. Tag: programlisting 4188#: reference_processing.xml:2292 4189#, no-c-format 4190msgid "" 4191"select ST_AsText(ST_SimplifyVW(geom,30)) simplified\n" 4192"FROM (SELECT 'LINESTRING(5 2, 3 8, 6 20, 7 25, 10 10)'::geometry geom) As " 4193"foo;\n" 4194"-result\n" 4195" simplified\n" 4196"------------------------------\n" 4197"LINESTRING(5 2,7 25,10 10)" 4198msgstr "" 4199 4200#. Tag: para 4201#: reference_processing.xml:2296 4202#, no-c-format 4203msgid "" 4204", <xref linkend=\"ST_Simplify\"/>, <xref linkend=" 4205"\"ST_SimplifyPreserveTopology\"/>, Topology <xref linkend=\"TP_ST_Simplify\"/" 4206">" 4207msgstr "" 4208 4209#. Tag: refname 4210#: reference_processing.xml:2302 4211#, no-c-format 4212msgid "ST_ChaikinSmoothing" 4213msgstr "" 4214 4215#. Tag: refpurpose 4216#: reference_processing.xml:2303 4217#, no-c-format 4218msgid "" 4219"Returns a \"smoothed\" version of the given geometry using the Chaikin " 4220"algorithm" 4221msgstr "" 4222 4223#. Tag: funcprototype 4224#: reference_processing.xml:2308 4225#, fuzzy, no-c-format 4226msgid "" 4227"<funcdef>geometry <function>ST_ChaikinSmoothing</function></funcdef> " 4228"<paramdef><type>geometry</type> <parameter>geom</parameter></paramdef> " 4229"<paramdef><type>integer</type> <parameter>nIterations = 1</parameter></" 4230"paramdef> <paramdef><type>boolean</type> <parameter>preserveEndPoints = " 4231"false</parameter></paramdef>" 4232msgstr "" 4233"<funcdef>geometry <function>ST_ConcaveHull</function></funcdef> " 4234"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 4235"<paramdef><type>float </type> <parameter>target_percent</parameter></" 4236"paramdef> <paramdef choice=\"opt\"><type>boolean </type> " 4237"<parameter>allow_holes=false</parameter></paramdef>" 4238 4239#. Tag: para 4240#: reference_processing.xml:2319 4241#, no-c-format 4242msgid "" 4243"Returns a \"smoothed\" version of the given geometry using the Chaikin " 4244"algorithm. See <ulink url=\"http://www.idav.ucdavis.edu/education/CAGDNotes/" 4245"Chaikins-Algorithm/Chaikins-Algorithm.html\">Chaikins-Algorithm</ulink> for " 4246"an explanation of the process. For each iteration the number of vertex " 4247"points will double. The function puts new vertex points at 1/4 of the line " 4248"before and after each point and removes the original point. To reduce the " 4249"number of points use one of the simplification functions on the result. The " 4250"new points gets interpolated values for all included dimensions, also z and " 4251"m." 4252msgstr "" 4253 4254#. Tag: para 4255#: reference_processing.xml:2325 4256#, no-c-format 4257msgid "Second argument, number of iterations is limited to max 5 iterations" 4258msgstr "" 4259 4260#. Tag: para 4261#: reference_processing.xml:2326 4262#, no-c-format 4263msgid "" 4264"Note third argument is only valid for polygons, and will be ignored for " 4265"linestrings" 4266msgstr "" 4267 4268#. Tag: para 4269#: reference_processing.xml:2328 4270#, no-c-format 4271msgid "" 4272"Note that returned geometry will get more points than the original. To " 4273"reduce the number of points again use one of the simplification functions on " 4274"the result. (see <xref linkend=\"ST_Simplify\"/> and <xref linkend=" 4275"\"ST_SimplifyVW\"/>)" 4276msgstr "" 4277 4278#. Tag: para 4279#: reference_processing.xml:2336 4280#, no-c-format 4281msgid "A triangle is smoothed" 4282msgstr "" 4283 4284#. Tag: programlisting 4285#: reference_processing.xml:2337 4286#, no-c-format 4287msgid "" 4288"select ST_AsText(ST_ChaikinSmoothing(geom)) smoothed\n" 4289"FROM (SELECT 'POLYGON((0 0, 8 8, 0 16, 0 0))'::geometry geom) As foo;\n" 4290"┌───────────────────────────────────────────┐\n" 4291"│ smoothed │\n" 4292"├───────────────────────────────────────────┤\n" 4293"│ POLYGON((2 2,6 6,6 10,2 14,0 12,0 4,2 2)) │\n" 4294"└───────────────────────────────────────────┘" 4295msgstr "" 4296 4297#. Tag: para 4298#: reference_processing.xml:2341 reference_processing.xml:2388 4299#, fuzzy, no-c-format 4300msgid ", <xref linkend=\"ST_SimplifyVW\"/>" 4301msgstr ", <xref linkend=\"ST_Dump\"/>" 4302 4303#. Tag: refname 4304#: reference_processing.xml:2347 4305#, no-c-format 4306msgid "ST_FilterByM" 4307msgstr "" 4308 4309#. Tag: refpurpose 4310#: reference_processing.xml:2348 4311#, no-c-format 4312msgid "Filters vertex points based on their m-value" 4313msgstr "" 4314 4315#. Tag: funcprototype 4316#: reference_processing.xml:2353 4317#, fuzzy, no-c-format 4318msgid "" 4319"<funcdef>geometry <function>ST_FilterByM</function></funcdef> " 4320"<paramdef><type>geometry</type> <parameter>geom</parameter></paramdef> " 4321"<paramdef><type>double precision</type> <parameter>min</parameter></" 4322"paramdef> <paramdef><type>double precision</type> <parameter>max = null</" 4323"parameter></paramdef> <paramdef><type>boolean</type> <parameter>returnM = " 4324"false</parameter></paramdef>" 4325msgstr "" 4326"<funcdef>geometry <function>ST_ConcaveHull</function></funcdef> " 4327"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 4328"<paramdef><type>float </type> <parameter>target_percent</parameter></" 4329"paramdef> <paramdef choice=\"opt\"><type>boolean </type> " 4330"<parameter>allow_holes=false</parameter></paramdef>" 4331 4332#. Tag: para 4333#: reference_processing.xml:2365 4334#, no-c-format 4335msgid "" 4336"Filters away vertex points based on their m-value. Returns a geometry with " 4337"only vertex points that have a m-value larger or equal to the min value and " 4338"smaller or equal to the max value. If max-value argument is left out only " 4339"min value is considered. If fourth argument is left out the m-value will not " 4340"be in the resulting geometry. If resulting geometry have too few vertex " 4341"points left for its geometry type an empty geometry will be returned. In a " 4342"geometry collection geometries without enough points will just be left out " 4343"silently. If" 4344msgstr "" 4345 4346#. Tag: para 4347#: reference_processing.xml:2371 4348#, no-c-format 4349msgid "" 4350"This function is mainly intended to be used in conjunction with " 4351"ST_SetEffectiveArea. ST_EffectiveArea sets the effective area of a vertex in " 4352"it's m-value. With ST_FilterByM it then is possible to get a simplified " 4353"version of the geometry without any calculations, just by filtering" 4354msgstr "" 4355 4356#. Tag: para 4357#: reference_processing.xml:2374 4358#, no-c-format 4359msgid "" 4360"There is a difference in what ST_SimplifyVW returns when not enough points " 4361"meets the creterias compared to ST_FilterByM. ST_SimplifyVW returns the " 4362"geometry with enough points while ST_FilterByM returns an empty geometry" 4363msgstr "" 4364 4365#. Tag: para 4366#: reference_processing.xml:2376 4367#, no-c-format 4368msgid "Note that the retuned geometry might be invalid" 4369msgstr "" 4370 4371#. Tag: para 4372#: reference_processing.xml:2377 4373#, no-c-format 4374msgid "This function returns all dimensions, also the z and m-value" 4375msgstr "" 4376 4377#. Tag: para 4378#: reference_processing.xml:2383 4379#, no-c-format 4380msgid "A linestring is filtered" 4381msgstr "" 4382 4383#. Tag: programlisting 4384#: reference_processing.xml:2384 4385#, no-c-format 4386msgid "" 4387"SELECT ST_AsText(ST_FilterByM(geom,30)) simplified\n" 4388"FROM (SELECT ST_SetEffectiveArea('LINESTRING(5 2, 3 8, 6 20, 7 25, 10 10)'::" 4389"geometry) geom) As foo;\n" 4390"-result\n" 4391" simplified\n" 4392"----------------------------\n" 4393" LINESTRING(5 2,7 25,10 10)" 4394msgstr "" 4395 4396#. Tag: refname 4397#: reference_processing.xml:2394 4398#, no-c-format 4399msgid "ST_SetEffectiveArea" 4400msgstr "" 4401 4402#. Tag: refpurpose 4403#: reference_processing.xml:2395 4404#, no-c-format 4405msgid "" 4406"Sets the effective area for each vertex, storing the value in the M " 4407"ordinate. A simplified geometry can then be generated by filtering on the M " 4408"ordinate." 4409msgstr "" 4410 4411#. Tag: funcprototype 4412#: reference_processing.xml:2402 4413#, fuzzy, no-c-format 4414msgid "" 4415"<funcdef>geometry <function>ST_SetEffectiveArea</function></funcdef> " 4416"<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 4417"<paramdef><type>float</type> <parameter>threshold = 0</parameter></paramdef> " 4418"<paramdef><type>integer</type> <parameter>set_area = 1</parameter></paramdef>" 4419msgstr "" 4420"<funcdef>geometry <function>ST_OffsetCurve</function></funcdef> " 4421"<paramdef><type>geometry </type> <parameter>line</parameter></paramdef> " 4422"<paramdef><type>float </type> <parameter>signed_distance</parameter></" 4423"paramdef> <paramdef choice=\"opt\"><type>text </type> " 4424"<parameter>style_parameters=''</parameter></paramdef>" 4425 4426#. Tag: para 4427#: reference_processing.xml:2413 4428#, no-c-format 4429msgid "" 4430"Sets the effective area for each vertex, using the Visvalingam-Whyatt " 4431"algorithm. The effective area is stored as the M-value of the vertex. If the " 4432"optional \"theshold\" parameter is used, a simplified geometry will be " 4433"returned, containing only vertices with an effective area greater than or " 4434"equal to the threshold value." 4435msgstr "" 4436 4437#. Tag: para 4438#: reference_processing.xml:2418 4439#, no-c-format 4440msgid "" 4441"This function can be used for server-side simplification when a threshold is " 4442"specified. Another option is to use a threshold value of zero. In this case, " 4443"the full geometry will be returned with effective areas as M-values, which " 4444"can be used by the client to simplify very quickly." 4445msgstr "" 4446 4447#. Tag: para 4448#: reference_processing.xml:2421 4449#, no-c-format 4450msgid "" 4451"Will actually do something only with (multi)lines and (multi)polygons but " 4452"you can safely call it with any kind of geometry. Since simplification " 4453"occurs on a object-by-object basis you can also feed a GeometryCollection to " 4454"this function." 4455msgstr "" 4456 4457#. Tag: para 4458#: reference_processing.xml:2433 4459#, no-c-format 4460msgid "The output geometry will lose all previous information in the M-values" 4461msgstr "" 4462 4463#. Tag: para 4464#: reference_processing.xml:2434 4465#, no-c-format 4466msgid "" 4467"This function handles 3D and the third dimension will affect the effective " 4468"area" 4469msgstr "" 4470 4471#. Tag: para 4472#: reference_processing.xml:2440 4473#, no-c-format 4474msgid "" 4475"Calculating the effective area of a LineString. Because we use a threshold " 4476"value of zero, all vertices in the input geometry are returned." 4477msgstr "" 4478 4479#. Tag: programlisting 4480#: reference_processing.xml:2443 4481#, no-c-format 4482msgid "" 4483"select ST_AsText(ST_SetEffectiveArea(geom)) all_pts, " 4484"ST_AsText(ST_SetEffectiveArea(geom,30) ) thrshld_30\n" 4485"FROM (SELECT 'LINESTRING(5 2, 3 8, 6 20, 7 25, 10 10)'::geometry geom) As " 4486"foo;\n" 4487"-result\n" 4488" all_pts | thrshld_30\n" 4489"-----------+-------------------+\n" 4490"LINESTRING M (5 2 3.40282346638529e+38,3 8 29,6 20 1.5,7 25 49.5,10 10 " 4491"3.40282346638529e+38) | LINESTRING M (5 2 3.40282346638529e+38,7 25 49.5,10 " 4492"10 3.40282346638529e+38)" 4493msgstr "" 4494 4495#. Tag: refname 4496#: reference_processing.xml:2453 4497#, no-c-format 4498msgid "ST_Split" 4499msgstr "ST_Split" 4500 4501#. Tag: refpurpose 4502#: reference_processing.xml:2454 4503#, no-c-format 4504msgid "Returns a collection of geometries resulting by splitting a geometry." 4505msgstr "" 4506 4507#. Tag: funcprototype 4508#: reference_processing.xml:2459 4509#, no-c-format 4510msgid "" 4511"<funcdef>geometry <function>ST_Split</function></funcdef> " 4512"<paramdef><type>geometry</type> <parameter>input</parameter></paramdef> " 4513"<paramdef><type>geometry</type> <parameter>blade</parameter></paramdef>" 4514msgstr "" 4515"<funcdef>geometry <function>ST_Split</function></funcdef> " 4516"<paramdef><type>geometry</type> <parameter>input</parameter></paramdef> " 4517"<paramdef><type>geometry</type> <parameter>blade</parameter></paramdef>" 4518 4519#. Tag: para 4520#: reference_processing.xml:2469 4521#, no-c-format 4522msgid "" 4523"The function supports splitting a line by (multi)point, (multi)line or " 4524"(multi)polygon boundary, a (multi)polygon by line. The returned geometry is " 4525"always a collection." 4526msgstr "" 4527 4528#. Tag: para 4529#: reference_processing.xml:2473 4530#, no-c-format 4531msgid "" 4532"Think of this function as the opposite of ST_Union. Theoretically applying " 4533"ST_Union to the elements of the returned collection should always yield the " 4534"original geometry." 4535msgstr "" 4536 4537#. Tag: para 4538#: reference_processing.xml:2480 4539#, no-c-format 4540msgid "" 4541"Enhanced: 2.2.0 support for splitting a line by a multiline, a multipoint or " 4542"(multi)polygon boundary was introduced." 4543msgstr "" 4544 4545#. Tag: para 4546#: reference_processing.xml:2481 4547#, no-c-format 4548msgid "" 4549"Enhanced: 2.5.0 support for splitting a polygon by a multiline was " 4550"introduced." 4551msgstr "" 4552 4553#. Tag: para 4554#: reference_processing.xml:2483 4555#, no-c-format 4556msgid "" 4557"To improve the robustness of ST_Split it may be convenient to <xref linkend=" 4558"\"ST_Snap\"/> the input to the blade in advance using a very low tolerance. " 4559"Otherwise the internally used coordinate grid may cause tolerance problems, " 4560"where coordinates of input and blade do not fall onto each other and the " 4561"input is not being split correctly (see <ulink url=\"http://trac.osgeo.org/" 4562"postgis/ticket/2192\">#2192</ulink>)." 4563msgstr "" 4564 4565#. Tag: para 4566#: reference_processing.xml:2485 4567#, no-c-format 4568msgid "" 4569"When a (multi)polygon is passed as as the blade, its linear component (the " 4570"boundary) is used for cutting the input." 4571msgstr "" 4572 4573#. Tag: para 4574#: reference_processing.xml:2493 4575#, no-c-format 4576msgid "Polygon Cut by Line" 4577msgstr "" 4578 4579#. Tag: para 4580#: reference_processing.xml:2505 reference_processing.xml:2539 4581#, no-c-format 4582msgid "Before Split" 4583msgstr "" 4584 4585#. Tag: para 4586#: reference_processing.xml:2517 reference_processing.xml:2551 4587#, no-c-format 4588msgid "After split" 4589msgstr "" 4590 4591#. Tag: programlisting 4592#: reference_processing.xml:2526 4593#, no-c-format 4594msgid "" 4595"-- this creates a geometry collection consisting of the 2 halves of the " 4596"polygon\n" 4597"-- this is similar to the example we demonstrated in ST_BuildArea\n" 4598"SELECT ST_Split(circle, line)\n" 4599"FROM (SELECT\n" 4600" ST_MakeLine(ST_MakePoint(10, 10),ST_MakePoint(190, 190)) As line,\n" 4601" ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50) As circle) As foo;\n" 4602"\n" 4603"-- result --\n" 4604" GEOMETRYCOLLECTION(POLYGON((150 90,149.039264020162 " 4605"80.2454838991936,146.193976625564 70.8658283817455,..), POLYGON(..)))\n" 4606"\n" 4607"-- To convert to individual polygons, you can use ST_Dump or ST_GeometryN\n" 4608"SELECT ST_AsText((ST_Dump(ST_Split(circle, line))).geom) As wkt\n" 4609"FROM (SELECT\n" 4610" ST_MakeLine(ST_MakePoint(10, 10),ST_MakePoint(190, 190)) As line,\n" 4611" ST_Buffer(ST_GeomFromText('POINT(100 90)'), 50) As circle) As foo;\n" 4612"\n" 4613"-- result --\n" 4614"wkt\n" 4615"---------------\n" 4616"POLYGON((150 90,149.039264020162 80.2454838991936,..))\n" 4617"POLYGON((60.1371179574584 60.1371179574584,58.4265193848728 " 4618"62.2214883490198,53.8060233744357 ..))" 4619msgstr "" 4620 4621#. Tag: para 4622#: reference_processing.xml:2527 4623#, no-c-format 4624msgid "Multilinestring Cut by point" 4625msgstr "" 4626 4627#. Tag: programlisting 4628#: reference_processing.xml:2560 4629#, fuzzy, no-c-format 4630msgid "" 4631"SELECT ST_AsText(ST_Split(mline, pt)) As wktcut\n" 4632" FROM (SELECT\n" 4633" ST_GeomFromText('MULTILINESTRING((10 10, 190 190), (15 15, 30 30, 100 " 4634"90))') As mline,\n" 4635" ST_Point(30,30) As pt) As foo;\n" 4636"\n" 4637"wktcut\n" 4638"------\n" 4639"GEOMETRYCOLLECTION(\n" 4640" LINESTRING(10 10,30 30),\n" 4641" LINESTRING(30 30,190 190),\n" 4642" LINESTRING(15 15,30 30),\n" 4643" LINESTRING(30 30,100 90)\n" 4644")" 4645msgstr "" 4646"SELECT ST_AsText(ST_Split(mline, pt)) As wktcut\n" 4647" FROM (SELECT \n" 4648" ST_GeomFromText('MULTILINESTRING((10 10, 190 190), (15 15, 30 30, 100 " 4649"90))') As mline,\n" 4650" ST_Point(30,30) As pt) As foo;\n" 4651" \n" 4652"wktcut\n" 4653"------\n" 4654"GEOMETRYCOLLECTION(\n" 4655" LINESTRING(10 10,30 30),\n" 4656" LINESTRING(30 30,190 190),\n" 4657" LINESTRING(15 15,30 30),\n" 4658" LINESTRING(30 30,100 90)\n" 4659")" 4660 4661#. Tag: para 4662#: reference_processing.xml:2564 4663#, no-c-format 4664msgid "" 4665", <xref linkend=\"ST_BuildArea\"/>, <xref linkend=\"ST_Dump\"/>, <xref " 4666"linkend=\"ST_GeometryN\"/>, <xref linkend=\"ST_Union\"/>, <xref linkend=" 4667"\"ST_Subdivide\"/>" 4668msgstr "" 4669 4670#. Tag: refname 4671#: reference_processing.xml:2577 4672#, no-c-format 4673msgid "ST_SymDifference" 4674msgstr "ST_SymDifference" 4675 4676#. Tag: refpurpose 4677#: reference_processing.xml:2579 4678#, no-c-format 4679msgid "" 4680"Returns a geometry that represents the portions of A and B that do not " 4681"intersect. It is called a symmetric difference because ST_SymDifference(A,B) " 4682"= ST_SymDifference(B,A)." 4683msgstr "" 4684 4685#. Tag: funcprototype 4686#: reference_processing.xml:2586 4687#, no-c-format 4688msgid "" 4689"<funcdef>geometry <function>ST_SymDifference</function></funcdef> " 4690"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 4691"<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef>" 4692msgstr "" 4693"<funcdef>geometry <function>ST_SymDifference</function></funcdef> " 4694"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 4695"<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef>" 4696 4697#. Tag: para 4698#: reference_processing.xml:2597 4699#, no-c-format 4700msgid "" 4701"Returns a geometry that represents the portions of A and B that do not " 4702"intersect. It is called a symmetric difference because ST_SymDifference(A,B) " 4703"= ST_SymDifference(B,A). One can think of this as ST_Union(geomA,geomB) - " 4704"ST_Intersection(A,B)." 4705msgstr "" 4706 4707#. Tag: para 4708#: reference_processing.xml:2604 4709#, no-c-format 4710msgid "&sqlmm_compliant; SQL-MM 3: 5.1.21" 4711msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.21" 4712 4713#. Tag: para 4714#: reference_processing.xml:2624 4715#, no-c-format 4716msgid "The original linestrings shown together" 4717msgstr "" 4718 4719#. Tag: para 4720#: reference_processing.xml:2636 4721#, no-c-format 4722msgid "The symmetric difference of the two linestrings" 4723msgstr "" 4724 4725#. Tag: programlisting 4726#: reference_processing.xml:2645 4727#, no-c-format 4728msgid "" 4729"--Safe for 2d - symmetric difference of 2 linestrings\n" 4730"SELECT ST_AsText(\n" 4731" ST_SymDifference(\n" 4732" ST_GeomFromText('LINESTRING(50 100, 50 200)'),\n" 4733" ST_GeomFromText('LINESTRING(50 50, 50 150)')\n" 4734" )\n" 4735");\n" 4736"\n" 4737"st_astext\n" 4738"---------\n" 4739"MULTILINESTRING((50 150,50 200),(50 50,50 100))" 4740msgstr "" 4741 4742#. Tag: programlisting 4743#: reference_processing.xml:2647 4744#, no-c-format 4745msgid "" 4746"--When used in 3d doesn't quite do the right thing\n" 4747"SELECT ST_AsEWKT(ST_SymDifference(ST_GeomFromEWKT('LINESTRING(1 2 1, 1 4 " 4748"2)'),\n" 4749" ST_GeomFromEWKT('LINESTRING(1 1 3, 1 3 4)')))\n" 4750"\n" 4751"st_astext\n" 4752"------------\n" 4753"MULTILINESTRING((1 3 2.75,1 4 2),(1 1 3,1 2 2.25))" 4754msgstr "" 4755 4756#. Tag: refname 4757#: reference_processing.xml:2661 4758#, no-c-format 4759msgid "ST_Subdivide" 4760msgstr "" 4761 4762#. Tag: refpurpose 4763#: reference_processing.xml:2662 4764#, no-c-format 4765msgid "" 4766"Returns a set of geometry where no geometry in the set has more than the " 4767"specified number of vertices." 4768msgstr "" 4769 4770#. Tag: funcprototype 4771#: reference_processing.xml:2667 4772#, no-c-format 4773msgid "" 4774"<funcdef>setof geometry <function>ST_Subdivide</function></funcdef> " 4775"<paramdef><type>geometry</type> <parameter>geom</parameter></paramdef> " 4776"<paramdef><type>integer</type> <parameter>max_vertices=256</parameter></" 4777"paramdef>" 4778msgstr "" 4779 4780#. Tag: para 4781#: reference_processing.xml:2678 4782#, no-c-format 4783msgid "" 4784"Divides geometry into parts until a part can be represented using no more " 4785"than <code>max_vertices</code>. Point-in-polygon and other overlay " 4786"operations are normally faster for indexed subdivided dataset: \"miss\" " 4787"cases are faster to check as boxes for all parts typically cover smaller " 4788"area than original geometry box, \"hit\" cases are faster because recheck " 4789"operates on less points. Uses the same envelope clipping as " 4790"<code>ST_ClipByBox2D</code>. <code>max_vertices</code> must be 5 or more, as " 4791"5 points are needed to represent a closed box." 4792msgstr "" 4793 4794#. Tag: para 4795#: reference_processing.xml:2688 4796#, no-c-format 4797msgid "" 4798"Enhanced: 2.5.0 reuses existing points on polygon split, vertex count is " 4799"lowered from 8 to 5." 4800msgstr "" 4801 4802#. Tag: programlisting 4803#: reference_processing.xml:2693 4804#, no-c-format 4805msgid "" 4806"-- Subdivide complex geometries in table, in place\n" 4807"with complex_areas_to_subdivide as (\n" 4808" delete from polygons_table\n" 4809" where ST_NPoints(geom) > 255\n" 4810" returning id, column1, column2, column3, geom\n" 4811")\n" 4812"insert into polygons_table (fid, column1, column2, column3, geom)\n" 4813" select\n" 4814" fid, column1, column2, column3,\n" 4815" ST_Subdivide(geom, 255) as geom\n" 4816" from complex_areas_to_subdivide;" 4817msgstr "" 4818 4819#. Tag: programlisting 4820#: reference_processing.xml:2695 4821#, no-c-format 4822msgid "" 4823"-- Create a new subdivided table suitable for joining to the original\n" 4824"CREATE TABLE subdivided_geoms AS\n" 4825"SELECT pkey, ST_Subdivide(geom) AS geom\n" 4826"FROM original_geoms;" 4827msgstr "" 4828 4829#. Tag: para 4830#: reference_processing.xml:2706 4831#, no-c-format 4832msgid "Subdivide max 10 vertices" 4833msgstr "" 4834 4835#. Tag: programlisting 4836#: reference_processing.xml:2709 4837#, no-c-format 4838msgid "" 4839"SELECT row_number() OVER() As rn, ST_AsText(geom) As wkt\n" 4840"FROM ( SELECT ST_SubDivide('POLYGON((132 10,119 23,85 35,68 29,66 28,49 " 4841"42,32 56,22 64,32 110,40 119,36 150,\n" 4842"57 158,75 171,92 182,114 184,132 186,146 178,176 184,179 162,184 141,190 " 4843"122,\n" 4844"190 100,185 79,186 56,186 52,178 34,168 18,147 13,132 10))'::geometry,10)) " 4845"As f(geom);" 4846msgstr "" 4847 4848#. Tag: screen 4849#: reference_processing.xml:2710 4850#, no-c-format 4851msgid "" 4852"rn │ wkt\n" 4853"────┼────────────────────────────────────────────────────────────────────────────────────────────────────────────────\n" 4854" 1 │ POLYGON((119 23,85 35,68 29,66 28,32 56,22 64,29.8260869565217 100,119 " 4855"100,119 23))\n" 4856" 2 │ POLYGON((132 10,119 23,119 56,186 56,186 52,178 34,168 18,147 13,132 " 4857"10))\n" 4858" 3 │ POLYGON((119 56,119 100,190 100,185 79,186 56,119 56))\n" 4859" 4 │ POLYGON((29.8260869565217 100,32 110,40 119,36 150,57 158,75 171,92 " 4860"182,114 184,114 100,29.8260869565217 100))\n" 4861" 5 │ POLYGON((114 184,132 186,146 178,176 184,179 162,184 141,190 122,190 " 4862"100,114 100,114 184))" 4863msgstr "" 4864 4865#. Tag: para 4866#: reference_processing.xml:2719 4867#, no-c-format 4868msgid "" 4869"Useful in conjunction with ST_Segmentize(geography) to create additional " 4870"vertices that can then be used for splitting." 4871msgstr "" 4872 4873#. Tag: programlisting 4874#: reference_processing.xml:2722 4875#, no-c-format 4876msgid "" 4877"SELECT ST_AsText(ST_Subdivide(ST_Segmentize('LINESTRING(0 0, 85 85)'::" 4878"geography,1200000)::geometry,8));" 4879msgstr "" 4880 4881#. Tag: screen 4882#: reference_processing.xml:2723 4883#, no-c-format 4884msgid "" 4885"LINESTRING(0 0,0.487578359029357 5.57659056746196,0.984542144675897 " 4886"11.1527721155093,1.50101059639722 16.7281035483571,1.94532113630331 21.25)\n" 4887"LINESTRING(1.94532113630331 21.25,2.04869538062779 " 4888"22.3020741387339,2.64204641967673 27.8740533545155,3.29994062412787 " 4889"33.443216802941,4.04836719489742 39.0084282520239,4.59890468420694 42.5)\n" 4890"LINESTRING(4.59890468420694 42.5,4.92498503922732 " 4891"44.5680389206321,5.98737409390639 50.1195229244701,7.3290919767674 " 4892"55.6587646879025,8.79638749938413 60.1969505994924)\n" 4893"LINESTRING(8.79638749938413 60.1969505994924,9.11375579533779 " 4894"61.1785363177625,11.6558166691368 66.6648504160202,15.642041247655 " 4895"72.0867690601745,22.8716627200212 77.3609628116894,24.6991785131552 " 4896"77.8939011989848)\n" 4897"LINESTRING(24.6991785131552 77.8939011989848,39.4046096622744 " 4898"82.1822848017636,44.7994523421035 82.5156766227011)\n" 4899"LINESTRING(44.7994523421035 82.5156766227011,85 85)" 4900msgstr "" 4901 4902#. Tag: para 4903#: reference_processing.xml:2730 4904#, fuzzy, no-c-format 4905msgid "" 4906", <xref linkend=\"ST_ClipByBox2D\"/>, <xref linkend=\"ST_Segmentize\"/>, " 4907"<xref linkend=\"ST_Split\"/>, <xref linkend=\"ST_NPoints\"/>" 4908msgstr "" 4909", <xref linkend=\"ST_DWithin\"/>, <xref linkend=\"ST_SetSRID\"/>, <xref " 4910"linkend=\"ST_Transform\"/>, <xref linkend=\"ST_Union\"/>" 4911 4912#. Tag: refname 4913#: reference_processing.xml:2742 4914#, no-c-format 4915msgid "ST_Union" 4916msgstr "ST_Union" 4917 4918#. Tag: refpurpose 4919#: reference_processing.xml:2743 4920#, no-c-format 4921msgid "" 4922"Returns a geometry that represents the point set union of the Geometries." 4923msgstr "" 4924 4925#. Tag: funcsynopsis 4926#: reference_processing.xml:2748 4927#, no-c-format 4928msgid "" 4929"<funcprototype> <funcdef>geometry <function>ST_Union</function></funcdef> " 4930"<paramdef><type>geometry set</type> <parameter>g1field</parameter></" 4931"paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 4932"<function>ST_Union</function></funcdef> <paramdef><type>geometry</type> " 4933"<parameter>g1</parameter></paramdef> <paramdef><type>geometry</type> " 4934"<parameter>g2</parameter></paramdef> </funcprototype> <funcprototype> " 4935"<funcdef>geometry <function>ST_Union</function></funcdef> " 4936"<paramdef><type>geometry[]</type> <parameter>g1_array</parameter></paramdef> " 4937"</funcprototype>" 4938msgstr "" 4939"<funcprototype> <funcdef>geometry <function>ST_Union</function></funcdef> " 4940"<paramdef><type>geometry set</type> <parameter>g1field</parameter></" 4941"paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 4942"<function>ST_Union</function></funcdef> <paramdef><type>geometry</type> " 4943"<parameter>g1</parameter></paramdef> <paramdef><type>geometry</type> " 4944"<parameter>g2</parameter></paramdef> </funcprototype> <funcprototype> " 4945"<funcdef>geometry <function>ST_Union</function></funcdef> " 4946"<paramdef><type>geometry[]</type> <parameter>g1_array</parameter></paramdef> " 4947"</funcprototype>" 4948 4949#. Tag: para 4950#: reference_processing.xml:2767 4951#, no-c-format 4952msgid "" 4953"Output type can be a MULTI*, single geometry, or Geometry Collection. Comes " 4954"in 2 variants. Variant 1 unions 2 geometries resulting in a new geometry " 4955"with no intersecting regions. Variant 2 is an aggregate function that takes " 4956"a set of geometries and unions them into a single ST_Geometry resulting in " 4957"no intersecting regions." 4958msgstr "" 4959 4960#. Tag: para 4961#: reference_processing.xml:2771 4962#, no-c-format 4963msgid "" 4964"Aggregate version: This function returns a MULTI geometry or NON-MULTI " 4965"geometry from a set of geometries. The ST_Union() function is an \"aggregate" 4966"\" function in the terminology of PostgreSQL. That means that it operates on " 4967"rows of data, in the same way the SUM() and AVG() functions do and like most " 4968"aggregates, it also ignores NULL geometries." 4969msgstr "" 4970 4971#. Tag: para 4972#: reference_processing.xml:2777 4973#, no-c-format 4974msgid "" 4975"Non-Aggregate version: This function returns a geometry being a union of two " 4976"input geometries. Output type can be a MULTI*, NON-MULTI or " 4977"GEOMETRYCOLLECTION. If any are NULL, then NULL is returned." 4978msgstr "" 4979 4980#. Tag: para 4981#: reference_processing.xml:2781 4982#, no-c-format 4983msgid "" 4984"ST_Collect and ST_Union are often interchangeable. ST_Union is in general " 4985"orders of magnitude slower than ST_Collect because it tries to dissolve " 4986"boundaries and reorder geometries to ensure that a constructed Multi* " 4987"doesn't have intersecting regions." 4988msgstr "" 4989 4990#. Tag: para 4991#: reference_processing.xml:2786 4992#, no-c-format 4993msgid "" 4994"ST_Union will use the faster Cascaded Union algorithm described in <ulink " 4995"url=\"http://blog.cleverelephant.ca/2009/01/must-faster-unions-in-postgis-14." 4996"html\">http://blog.cleverelephant.ca/2009/01/must-faster-unions-in-" 4997"postgis-14.html</ulink>" 4998msgstr "" 4999 5000#. Tag: para 5001#: reference_processing.xml:2790 5002#, no-c-format 5003msgid "" 5004"NOTE: this function was formerly called GeomUnion(), which was renamed from " 5005"\"Union\" because UNION is an SQL reserved word." 5006msgstr "" 5007 5008#. Tag: para 5009#: reference_processing.xml:2793 5010#, no-c-format 5011msgid "" 5012"Availability: 1.4.0 - ST_Union was enhanced. ST_Union(geomarray) was " 5013"introduced and also faster aggregate collection in PostgreSQL." 5014msgstr "" 5015 5016#. Tag: para 5017#: reference_processing.xml:2797 5018#, no-c-format 5019msgid "Aggregate version is not explicitly defined in OGC SPEC." 5020msgstr "" 5021 5022#. Tag: para 5023#: reference_processing.xml:2798 5024#, no-c-format 5025msgid "" 5026"&sqlmm_compliant; SQL-MM 3: 5.1.19 the z-index (elevation) when polygons are " 5027"involved." 5028msgstr "" 5029 5030#. Tag: para 5031#: reference_processing.xml:2804 5032#, no-c-format 5033msgid "Aggregate example" 5034msgstr "" 5035 5036#. Tag: programlisting 5037#: reference_processing.xml:2805 5038#, fuzzy, no-c-format 5039msgid "" 5040"SELECT stusps,\n" 5041" ST_Union(f.geom) as singlegeom\n" 5042"FROM sometable f\n" 5043"GROUP BY stusps" 5044msgstr "" 5045"SELECT stusps,\n" 5046" ST_Multi(ST_Union(f.the_geom)) as singlegeom\n" 5047" FROM sometable As f\n" 5048"GROUP BY stusps" 5049 5050#. Tag: para 5051#: reference_processing.xml:2806 5052#, no-c-format 5053msgid "Non-Aggregate example" 5054msgstr "" 5055 5056#. Tag: programlisting 5057#: reference_processing.xml:2807 5058#, no-c-format 5059msgid "" 5060"select ST_AsText(ST_Union('POINT(1 2)' :: geometry, 'POINT(-2 3)' :: " 5061"geometry))\n" 5062"\n" 5063"st_astext\n" 5064"----------\n" 5065"MULTIPOINT(-2 3,1 2)\n" 5066"\n" 5067"select ST_AsText(ST_Union('POINT(1 2)' :: geometry, 'POINT(1 2)' :: " 5068"geometry))\n" 5069"\n" 5070"st_astext\n" 5071"----------\n" 5072"POINT(1 2)" 5073msgstr "" 5074 5075#. Tag: para 5076#: reference_processing.xml:2808 5077#, no-c-format 5078msgid "3D example - sort of supports 3D (and with mixed dimensions!)" 5079msgstr "" 5080 5081#. Tag: programlisting 5082#: reference_processing.xml:2809 5083#, no-c-format 5084msgid "" 5085"select ST_AsEWKT(ST_Union(geom))\n" 5086"from (\n" 5087" select 'POLYGON((-7 4.2,-7.1 4.2,-7.1 4.3, -7 4.2))'::geometry " 5088"geom\n" 5089" union all\n" 5090" select 'POINT(5 5 5)'::geometry geom\n" 5091" union all\n" 5092" select 'POINT(-2 3 1)'::geometry geom\n" 5093" union all\n" 5094" select 'LINESTRING(5 5 5, 10 10 10)'::geometry geom\n" 5095" ) as foo;\n" 5096"\n" 5097"st_asewkt\n" 5098"---------\n" 5099"GEOMETRYCOLLECTION(POINT(-2 3 1),LINESTRING(5 5 5,10 10 10),POLYGON((-7 4.2 " 5100"5,-7.1 4.2 5,-7.1 4.3 5,-7 4.2 5)));" 5101msgstr "" 5102 5103#. Tag: para 5104#: reference_processing.xml:2810 5105#, no-c-format 5106msgid "3d example not mixing dimensions" 5107msgstr "" 5108 5109#. Tag: programlisting 5110#: reference_processing.xml:2811 5111#, no-c-format 5112msgid "" 5113"select ST_AsEWKT(ST_Union(geom))\n" 5114"from (\n" 5115" select 'POLYGON((-7 4.2 2,-7.1 4.2 3,-7.1 4.3 2, -7 4.2 2))'::" 5116"geometry geom\n" 5117" union all\n" 5118" select 'POINT(5 5 5)'::geometry geom\n" 5119" union all\n" 5120" select 'POINT(-2 3 1)'::geometry geom\n" 5121" union all\n" 5122" select 'LINESTRING(5 5 5, 10 10 10)'::geometry geom\n" 5123" ) as foo;\n" 5124"\n" 5125"st_asewkt\n" 5126"---------\n" 5127"GEOMETRYCOLLECTION(POINT(-2 3 1),LINESTRING(5 5 5,10 10 10),POLYGON((-7 4.2 " 5128"2,-7.1 4.2 3,-7.1 4.3 2,-7 4.2 2)))\n" 5129"\n" 5130"--Examples using new Array construct\n" 5131"SELECT ST_Union(ARRAY(SELECT the_geom FROM sometable));\n" 5132"\n" 5133"SELECT ST_AsText(ST_Union(ARRAY[ST_GeomFromText('LINESTRING(1 2, 3 4)'),\n" 5134" ST_GeomFromText('LINESTRING(3 4, 4 5)')])) As " 5135"wktunion;\n" 5136"\n" 5137"--wktunion---\n" 5138"MULTILINESTRING((3 4,4 5),(1 2,3 4))" 5139msgstr "" 5140 5141#. Tag: para 5142#: reference_processing.xml:2815 5143#, fuzzy, no-c-format 5144msgid "" 5145", <xref linkend=\"ST_UnaryUnion\"/>, <xref linkend=\"ST_Intersection\"/>, " 5146"<xref linkend=\"ST_Difference\"/> <xref linkend=\"ST_SymDifference\"/>" 5147msgstr "" 5148", <xref linkend=\"ST_DWithin\"/>, <xref linkend=\"ST_SetSRID\"/>, <xref " 5149"linkend=\"ST_Transform\"/>, <xref linkend=\"ST_Union\"/>" 5150 5151#. Tag: refname 5152#: reference_processing.xml:2827 5153#, no-c-format 5154msgid "ST_UnaryUnion" 5155msgstr "ST_UnaryUnion" 5156 5157#. Tag: refpurpose 5158#: reference_processing.xml:2829 5159#, no-c-format 5160msgid "Like ST_Union, but working at the geometry component level." 5161msgstr "" 5162 5163#. Tag: funcprototype 5164#: reference_processing.xml:2834 5165#, no-c-format 5166msgid "" 5167"<funcdef>geometry <function>ST_UnaryUnion</function></funcdef> " 5168"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 5169msgstr "" 5170"<funcdef>geometry <function>ST_UnaryUnion</function></funcdef> " 5171"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 5172 5173#. Tag: para 5174#: reference_processing.xml:2845 5175#, no-c-format 5176msgid "" 5177"Unlike ST_Union, ST_UnaryUnion does dissolve boundaries between components " 5178"of a multipolygon (invalid) and does perform union between the components of " 5179"a geometrycollection. Each components of the input geometry is assumed to be " 5180"valid, so you won't get a valid multipolygon out of a bow-tie polygon " 5181"(invalid)." 5182msgstr "" 5183 5184#. Tag: para 5185#: reference_processing.xml:2855 5186#, no-c-format 5187msgid "" 5188"You may use this function to node a set of linestrings. You may mix " 5189"ST_UnaryUnion with ST_Collect to fine-tune how many geometries at once you " 5190"want to dissolve to be nice on both memory size and CPU time, finding the " 5191"balance between ST_Union and ST_MemUnion." 5192msgstr "" 5193 5194#. Tag: para 5195#: reference_processing.xml:2873 5196#, no-c-format 5197msgid "" 5198", <xref linkend=\"ST_MemUnion\"/>, <xref linkend=\"ST_Collect\"/>, <xref " 5199"linkend=\"ST_Node\"/>" 5200msgstr "" 5201 5202#. Tag: refname 5203#: reference_processing.xml:2884 5204#, fuzzy, no-c-format 5205msgid "ST_VoronoiLines" 5206msgstr "ST_CurveToLine" 5207 5208#. Tag: refpurpose 5209#: reference_processing.xml:2886 5210#, no-c-format 5211msgid "" 5212"Returns the boundaries between the cells of the Voronoi diagram constructed " 5213"from the vertices of a geometry." 5214msgstr "" 5215 5216#. Tag: funcprototype 5217#: reference_processing.xml:2891 5218#, fuzzy, no-c-format 5219msgid "" 5220"<funcdef>geometry <function>ST_VoronoiLines</function></funcdef> <paramdef> " 5221"<parameter>g1</parameter> <type>geometry</type> </paramdef> <paramdef choice=" 5222"\"opt\"> <parameter>tolerance</parameter> <type>float8</type> </paramdef> " 5223"<paramdef choice=\"opt\"> <parameter>extend_to</parameter> <type>geometry</" 5224"type> </paramdef>" 5225msgstr "" 5226"<funcdef>geometry <function>ST_OffsetCurve</function></funcdef> " 5227"<paramdef><type>geometry </type> <parameter>line</parameter></paramdef> " 5228"<paramdef><type>float </type> <parameter>signed_distance</parameter></" 5229"paramdef> <paramdef choice=\"opt\"><type>text </type> " 5230"<parameter>style_parameters=''</parameter></paramdef>" 5231 5232#. Tag: para 5233#: reference_processing.xml:2912 5234#, no-c-format 5235msgid "" 5236"ST_VoronoiLines computes a two-dimensional <ulink url=\"https://en.wikipedia." 5237"org/wiki/Voronoi_diagram\">Voronoi diagram</ulink> from the vertices of the " 5238"supplied geometry and returns the boundaries between cells in that diagram " 5239"as a MultiLineString. Returns null if input geometry is null. Returns an " 5240"empty geometry collection if the input geometry contains only one vertex. " 5241"Returns an empty geometry collection if the extend_to envelope has zero area." 5242msgstr "" 5243 5244#. Tag: para 5245#: reference_processing.xml:2917 reference_processing.xml:3007 5246#, no-c-format 5247msgid "Optional parameters:" 5248msgstr "" 5249 5250#. Tag: para 5251#: reference_processing.xml:2921 reference_processing.xml:3011 5252#, no-c-format 5253msgid "" 5254"'tolerance' : The distance within which vertices will be considered " 5255"equivalent. Robustness of the algorithm can be improved by supplying a " 5256"nonzero tolerance distance. (default = 0.0)" 5257msgstr "" 5258 5259#. Tag: para 5260#: reference_processing.xml:2924 reference_processing.xml:3014 5261#, no-c-format 5262msgid "" 5263"'extend_to' : If a geometry is supplied as the \"extend_to\" parameter, the " 5264"diagram will be extended to cover the envelope of the \"extend_to\" " 5265"geometry, unless that envelope is smaller than the default envelope (default " 5266"= NULL, default envelope is boundingbox of input geometry extended by about " 5267"50% in each direction)." 5268msgstr "" 5269 5270#. Tag: para 5271#: reference_processing.xml:2945 5272#, no-c-format 5273msgid "Voronoi lines with tolerance of 30 units" 5274msgstr "" 5275 5276#. Tag: programlisting 5277#: reference_processing.xml:2948 reference_processing.xml:3067 5278#, no-c-format 5279msgid "" 5280"SELECT ST_VoronoiLines(geom, 30) As geom\n" 5281"FROM (SELECT 'MULTIPOINT (50 30, 60 30, 100 100,10 150, 110 120)'::geometry " 5282"As geom ) As g" 5283msgstr "" 5284 5285#. Tag: screen 5286#: reference_processing.xml:2949 reference_processing.xml:3068 5287#, no-c-format 5288msgid "" 5289"-- ST_AsText output\n" 5290"MULTILINESTRING((135.555555555556 270,36.8181818181818 92.2727272727273)," 5291"(36.8181818181818 92.2727272727273,-110 43.3333333333333),(230 " 5292"-45.7142857142858,36.8181818181818 92.2727272727273))" 5293msgstr "" 5294 5295#. Tag: para 5296#: reference_processing.xml:2962 5297#, fuzzy, no-c-format 5298msgid "" 5299", <xref linkend=\"ST_VoronoiPolygons\"/>, <xref linkend=\"ST_Collect\"/>" 5300msgstr ", <xref linkend=\"ST_Intersection\"/>, <xref linkend=\"ST_Union\"/>" 5301 5302#. Tag: refname 5303#: reference_processing.xml:2972 5304#, fuzzy, no-c-format 5305msgid "ST_VoronoiPolygons" 5306msgstr "ST_Polygonize" 5307 5308#. Tag: refpurpose 5309#: reference_processing.xml:2974 5310#, no-c-format 5311msgid "" 5312"Returns the cells of the Voronoi diagram constructed from the vertices of a " 5313"geometry." 5314msgstr "" 5315 5316#. Tag: funcprototype 5317#: reference_processing.xml:2979 5318#, fuzzy, no-c-format 5319msgid "" 5320"<funcdef>geometry <function>ST_VoronoiPolygons</function></funcdef> " 5321"<paramdef> <parameter>g1</parameter> <type>geometry</type> </paramdef> " 5322"<paramdef choice=\"opt\"> <parameter>tolerance</parameter> <type>float8</" 5323"type> </paramdef> <paramdef choice=\"opt\"> <parameter>extend_to</parameter> " 5324"<type>geometry</type> </paramdef>" 5325msgstr "" 5326"<funcdef>geometry <function>ST_OffsetCurve</function></funcdef> " 5327"<paramdef><type>geometry </type> <parameter>line</parameter></paramdef> " 5328"<paramdef><type>float </type> <parameter>signed_distance</parameter></" 5329"paramdef> <paramdef choice=\"opt\"><type>text </type> " 5330"<parameter>style_parameters=''</parameter></paramdef>" 5331 5332#. Tag: para 5333#: reference_processing.xml:3001 5334#, no-c-format 5335msgid "" 5336"ST_VoronoiPolygons computes a two-dimensional <ulink url=\"https://en." 5337"wikipedia.org/wiki/Voronoi_diagram\">Voronoi diagram</ulink> from the " 5338"vertices of the supplied geometry. The result is a GeometryCollection of " 5339"Polygons that covers an envelope larger than the extent of the input " 5340"vertices. Returns null if input geometry is null. Returns an empty geometry " 5341"collection if the input geometry contains only one vertex. Returns an empty " 5342"geometry collection if the extend_to envelope has zero area." 5343msgstr "" 5344 5345#. Tag: para 5346#: reference_processing.xml:3037 5347#, no-c-format 5348msgid "Points overlaid on top of Voronoi diagram" 5349msgstr "" 5350 5351#. Tag: programlisting 5352#: reference_processing.xml:3040 5353#, no-c-format 5354msgid "" 5355"SELECT\n" 5356" ST_VoronoiPolygons(geom) As geom\n" 5357"FROM (SELECT 'MULTIPOINT (50 30, 60 30, 100 100,10 150, 110 120)'::geometry " 5358"As geom ) As g;" 5359msgstr "" 5360 5361#. Tag: screen 5362#: reference_processing.xml:3041 5363#, no-c-format 5364msgid "" 5365"-- ST_AsText output\n" 5366"GEOMETRYCOLLECTION(POLYGON((-110 43.3333333333333,-110 270,100.5 " 5367"270,59.3478260869565 132.826086956522,36.8181818181818 92.2727272727273,-110 " 5368"43.3333333333333)),\n" 5369"POLYGON((55 -90,-110 -90,-110 43.3333333333333,36.8181818181818 " 5370"92.2727272727273,55 79.2857142857143,55 -90)),\n" 5371"POLYGON((230 47.5,230 -20.7142857142857,55 79.2857142857143,36.8181818181818 " 5372"92.2727272727273,59.3478260869565 132.826086956522,230 47.5)),POLYGON((230 " 5373"-20.7142857142857,230 -90,55 -90,55 79.2857142857143,230 " 5374"-20.7142857142857)),\n" 5375"POLYGON((100.5 270,230 270,230 47.5,59.3478260869565 132.826086956522,100.5 " 5376"270)))" 5377msgstr "" 5378 5379#. Tag: para 5380#: reference_processing.xml:3051 5381#, no-c-format 5382msgid "Voronoi with tolerance of 30 units" 5383msgstr "" 5384 5385#. Tag: programlisting 5386#: reference_processing.xml:3054 5387#, no-c-format 5388msgid "" 5389"SELECT ST_VoronoiPolygons(geom, 30) As geom\n" 5390"FROM (SELECT 'MULTIPOINT (50 30, 60 30, 100 100,10 150, 110 120)'::geometry " 5391"As geom ) As g;" 5392msgstr "" 5393 5394#. Tag: screen 5395#: reference_processing.xml:3055 5396#, no-c-format 5397msgid "" 5398"-- ST_AsText output\n" 5399"GEOMETRYCOLLECTION(POLYGON((-110 43.3333333333333,-110 270,100.5 " 5400"270,59.3478260869565 132.826086956522,36.8181818181818 92.2727272727273,-110 " 5401"43.3333333333333)),\n" 5402"POLYGON((230 47.5,230 -45.7142857142858,36.8181818181818 " 5403"92.2727272727273,59.3478260869565 132.826086956522,230 47.5)),POLYGON((230 " 5404"-45.7142857142858,230 -90,-110 -90,-110 43.3333333333333,36.8181818181818 " 5405"92.2727272727273,230 -45.7142857142858)),\n" 5406"POLYGON((100.5 270,230 270,230 47.5,59.3478260869565 132.826086956522,100.5 " 5407"270)))" 5408msgstr "" 5409 5410#. Tag: para 5411#: reference_processing.xml:3064 5412#, no-c-format 5413msgid "Voronoi with tolerance of 30 units as MultiLineString" 5414msgstr "" 5415 5416#. Tag: para 5417#: reference_processing.xml:3081 5418#, fuzzy, no-c-format 5419msgid ", <xref linkend=\"ST_VoronoiLines\"/>, <xref linkend=\"ST_Collect\"/>" 5420msgstr ", <xref linkend=\"ST_Intersection\"/>, <xref linkend=\"ST_Union\"/>" 5421 5422#~ msgid "ST_Collect" 5423#~ msgstr "ST_Collect" 5424 5425#~ msgid "" 5426#~ "<funcprototype> <funcdef>geometry <function>ST_Collect</function></" 5427#~ "funcdef> <paramdef><type>geometry set</type> <parameter>g1field</" 5428#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 5429#~ "<function>ST_Collect</function></funcdef> <paramdef><type>geometry</type> " 5430#~ "<parameter>g1</parameter></paramdef> <paramdef><type>geometry</type> " 5431#~ "<parameter>g2</parameter></paramdef> </funcprototype> <funcprototype> " 5432#~ "<funcdef>geometry <function>ST_Collect</function></funcdef> " 5433#~ "<paramdef><type>geometry[]</type> <parameter>g1_array</parameter></" 5434#~ "paramdef> </funcprototype>" 5435#~ msgstr "" 5436#~ "<funcprototype> <funcdef>geometry <function>ST_Collect</function></" 5437#~ "funcdef> <paramdef><type>geometry set</type> <parameter>g1field</" 5438#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 5439#~ "<function>ST_Collect</function></funcdef> <paramdef><type>geometry</type> " 5440#~ "<parameter>g1</parameter></paramdef> <paramdef><type>geometry</type> " 5441#~ "<parameter>g2</parameter></paramdef> </funcprototype> <funcprototype> " 5442#~ "<funcdef>geometry <function>ST_Collect</function></funcdef> " 5443#~ "<paramdef><type>geometry[]</type> <parameter>g1_array</parameter></" 5444#~ "paramdef> </funcprototype>" 5445 5446#, fuzzy 5447#~ msgid "" 5448#~ "SELECT stusps, ST_Collect(f.the_geom) as singlegeom\n" 5449#~ " FROM (SELECT stusps, (ST_Dump(the_geom)).geom As the_geom\n" 5450#~ " FROM\n" 5451#~ " somestatetable ) As f\n" 5452#~ "GROUP BY stusps" 5453#~ msgstr "" 5454#~ "SELECT stusps,\n" 5455#~ " ST_Multi(ST_Collect(f.the_geom)) as singlegeom\n" 5456#~ " FROM (SELECT stusps, (ST_Dump(the_geom)).geom As the_geom\n" 5457#~ " FROM\n" 5458#~ " somestatetable ) As f\n" 5459#~ "GROUP BY stusps" 5460 5461#~ msgid "" 5462#~ "SELECT ST_AsText(ST_Collect(ST_GeomFromText('POINT(1 2)'),\n" 5463#~ " ST_GeomFromText('POINT(-2 3)') ));\n" 5464#~ "\n" 5465#~ "st_astext\n" 5466#~ "----------\n" 5467#~ "MULTIPOINT(1 2,-2 3)\n" 5468#~ "\n" 5469#~ "--Collect 2 d points\n" 5470#~ "SELECT ST_AsText(ST_Collect(ST_GeomFromText('POINT(1 2)'),\n" 5471#~ " ST_GeomFromText('POINT(1 2)') ) );\n" 5472#~ "\n" 5473#~ "st_astext\n" 5474#~ "----------\n" 5475#~ "MULTIPOINT(1 2,1 2)\n" 5476#~ "\n" 5477#~ "--Collect 3d points\n" 5478#~ "SELECT ST_AsEWKT(ST_Collect(ST_GeomFromEWKT('POINT(1 2 3)'),\n" 5479#~ " ST_GeomFromEWKT('POINT(1 2 4)') ) );\n" 5480#~ "\n" 5481#~ " st_asewkt\n" 5482#~ "-------------------------\n" 5483#~ " MULTIPOINT(1 2 3,1 2 4)\n" 5484#~ "\n" 5485#~ " --Example with curves\n" 5486#~ "SELECT ST_AsText(ST_Collect(ST_GeomFromText('CIRCULARSTRING(220268 " 5487#~ "150415,220227 150505,220227 150406)'),\n" 5488#~ "ST_GeomFromText('CIRCULARSTRING(220227 150406,2220227 150407,220227 " 5489#~ "150406)')));\n" 5490#~ " st_astext\n" 5491#~ "------------------------------------------------------------------------------------\n" 5492#~ " GEOMETRYCOLLECTION(CIRCULARSTRING(220268 150415,220227 150505,220227 " 5493#~ "150406),\n" 5494#~ " CIRCULARSTRING(220227 150406,2220227 150407,220227 150406))\n" 5495#~ "\n" 5496#~ "--New ST_Collect array construct\n" 5497#~ "SELECT ST_Collect(ARRAY(SELECT the_geom FROM sometable));\n" 5498#~ "\n" 5499#~ "SELECT ST_AsText(ST_Collect(ARRAY[ST_GeomFromText('LINESTRING(1 2, 3 " 5500#~ "4)'),\n" 5501#~ " ST_GeomFromText('LINESTRING(3 4, 4 5)')])) As " 5502#~ "wktcollect;\n" 5503#~ "\n" 5504#~ "--wkt collect --\n" 5505#~ "MULTILINESTRING((1 2,3 4),(3 4,4 5))" 5506#~ msgstr "" 5507#~ "SELECT ST_AsText(ST_Collect(ST_GeomFromText('POINT(1 2)'),\n" 5508#~ " ST_GeomFromText('POINT(-2 3)') ));\n" 5509#~ "\n" 5510#~ "st_astext\n" 5511#~ "----------\n" 5512#~ "MULTIPOINT(1 2,-2 3)\n" 5513#~ "\n" 5514#~ "--Recupera punti 2D\n" 5515#~ "SELECT ST_AsText(ST_Collect(ST_GeomFromText('POINT(1 2)'),\n" 5516#~ " ST_GeomFromText('POINT(1 2)') ) );\n" 5517#~ "\n" 5518#~ "st_astext\n" 5519#~ "----------\n" 5520#~ "MULTIPOINT(1 2,1 2)\n" 5521#~ "\n" 5522#~ "--recupera punti 3D\n" 5523#~ "SELECT ST_AsEWKT(ST_Collect(ST_GeomFromEWKT('POINT(1 2 3)'),\n" 5524#~ " ST_GeomFromEWKT('POINT(1 2 4)') ) );\n" 5525#~ "\n" 5526#~ " st_asewkt\n" 5527#~ "-------------------------\n" 5528#~ " MULTIPOINT(1 2 3,1 2 4)\n" 5529#~ "\n" 5530#~ " --esempio con curve\n" 5531#~ "SELECT ST_AsText(ST_Collect(ST_GeomFromText('CIRCULARSTRING(220268 " 5532#~ "150415,220227 150505,220227 150406)'),\n" 5533#~ "ST_GeomFromText('CIRCULARSTRING(220227 150406,2220227 150407,220227 " 5534#~ "150406)')));\n" 5535#~ " st_astext\n" 5536#~ "------------------------------------------------------------------------------------\n" 5537#~ " GEOMETRYCOLLECTION(CIRCULARSTRING(220268 150415,220227 150505,220227 " 5538#~ "150406),\n" 5539#~ " CIRCULARSTRING(220227 150406,2220227 150407,220227 150406))\n" 5540#~ "\n" 5541#~ "--nuova costruzione di ST_Collect array\n" 5542#~ "SELECT ST_Collect(ARRAY(SELECT the_geom FROM sometable));\n" 5543#~ "\n" 5544#~ "SELECT ST_AsText(ST_Collect(ARRAY[ST_GeomFromText('LINESTRING(1 2, 3 " 5545#~ "4)'),\n" 5546#~ " ST_GeomFromText('LINESTRING(3 4, 4 5)')])) As " 5547#~ "wktcollect;\n" 5548#~ "\n" 5549#~ "--wkt collect --\n" 5550#~ "MULTILINESTRING((1 2,3 4),(3 4,4 5))" 5551 5552#~ msgid ", <xref linkend=\"ST_Union\"/>" 5553#~ msgstr ", <xref linkend=\"ST_Union\"/>" 5554 5555#~ msgid "ST_Dump" 5556#~ msgstr "ST_Dump" 5557 5558#~ msgid "" 5559#~ "<funcdef>geometry_dump[] <function>ST_Dump</function></funcdef> " 5560#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 5561#~ msgstr "" 5562#~ "<funcdef>geometry_dump[] <function>ST_Dump</function></funcdef> " 5563#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 5564 5565#~ msgid "Standard Examples" 5566#~ msgstr "Esempi standard" 5567 5568#, fuzzy 5569#~ msgid "" 5570#~ "-- TIN --\n" 5571#~ "SELECT (g.gdump).path, ST_AsEWKT((g.gdump).geom) as wkt\n" 5572#~ " FROM\n" 5573#~ " (SELECT\n" 5574#~ " ST_Dump( ST_GeomFromEWKT('TIN (((\n" 5575#~ " 0 0 0,\n" 5576#~ " 0 0 1,\n" 5577#~ " 0 1 0,\n" 5578#~ " 0 0 0\n" 5579#~ " )), ((\n" 5580#~ " 0 0 0,\n" 5581#~ " 0 1 0,\n" 5582#~ " 1 1 0,\n" 5583#~ " 0 0 0\n" 5584#~ " ))\n" 5585#~ " )') ) AS gdump\n" 5586#~ " ) AS g;\n" 5587#~ "-- result --\n" 5588#~ " path | wkt\n" 5589#~ "------+-------------------------------------\n" 5590#~ " {1} | TRIANGLE((0 0 0,0 0 1,0 1 0,0 0 0))\n" 5591#~ " {2} | TRIANGLE((0 0 0,0 1 0,1 1 0,0 0 0))" 5592#~ msgstr "" 5593#~ "-- TIN -- \n" 5594#~ "SELECT (g.gdump).path, ST_AsEWKT((g.gdump).geom) as wkt\n" 5595#~ " FROM\n" 5596#~ " (SELECT \n" 5597#~ " ST_Dump( ST_GeomFromEWKT('TIN (((\n" 5598#~ " 0 0 0, \n" 5599#~ " 0 0 1, \n" 5600#~ " 0 1 0, \n" 5601#~ " 0 0 0\n" 5602#~ " )), ((\n" 5603#~ " 0 0 0, \n" 5604#~ " 0 1 0, \n" 5605#~ " 1 1 0, \n" 5606#~ " 0 0 0\n" 5607#~ " ))\n" 5608#~ " )') ) AS gdump\n" 5609#~ " ) AS g;\n" 5610#~ "-- result --\n" 5611#~ " path | wkt\n" 5612#~ "------+-------------------------------------\n" 5613#~ " {1} | TRIANGLE((0 0 0,0 0 1,0 1 0,0 0 0))\n" 5614#~ " {2} | TRIANGLE((0 0 0,0 1 0,1 1 0,0 0 0))" 5615 5616#~ msgid "" 5617#~ ", <xref linkend=\"PostGIS_Geometry_DumpFunctions\"/>, <xref linkend=" 5618#~ "\"ST_Collect\"/>, <xref linkend=\"ST_Collect\"/>, <xref linkend=" 5619#~ "\"ST_GeometryN\"/>" 5620#~ msgstr "" 5621#~ ", <xref linkend=\"PostGIS_Geometry_DumpFunctions\"/>, <xref linkend=" 5622#~ "\"ST_Collect\"/>, <xref linkend=\"ST_Collect\"/>, <xref linkend=" 5623#~ "\"ST_GeometryN\"/>" 5624 5625#~ msgid "" 5626#~ "<funcdef>geometry_dump[]<function>ST_DumpPoints</function></funcdef> " 5627#~ "<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 5628#~ msgstr "" 5629#~ "<funcdef>geometry_dump[]<function>ST_DumpPoints</function></funcdef> " 5630#~ "<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 5631 5632#~ msgid "Availability: 1.5.0" 5633#~ msgstr "Disponibilità: 1.5.0" 5634 5635#, fuzzy 5636#~ msgid "" 5637#~ "SELECT path, ST_AsText(geom)\n" 5638#~ "FROM (\n" 5639#~ " SELECT (ST_DumpPoints(g.geom)).*\n" 5640#~ " FROM\n" 5641#~ " (SELECT\n" 5642#~ " 'GEOMETRYCOLLECTION(\n" 5643#~ " POINT ( 0 1 ),\n" 5644#~ " LINESTRING ( 0 3, 3 4 ),\n" 5645#~ " POLYGON (( 2 0, 2 3, 0 2, 2 0 )),\n" 5646#~ " POLYGON (( 3 0, 3 3, 6 3, 6 0, 3 0 ),\n" 5647#~ " ( 5 1, 4 2, 5 2, 5 1 )),\n" 5648#~ " MULTIPOLYGON (\n" 5649#~ " (( 0 5, 0 8, 4 8, 4 5, 0 5 ),\n" 5650#~ " ( 1 6, 3 6, 2 7, 1 6 )),\n" 5651#~ " (( 5 4, 5 8, 6 7, 5 4 ))\n" 5652#~ " )\n" 5653#~ " )'::geometry AS geom\n" 5654#~ " ) AS g\n" 5655#~ " ) j;\n" 5656#~ "\n" 5657#~ " path | st_astext\n" 5658#~ "-----------+------------\n" 5659#~ " {1,1} | POINT(0 1)\n" 5660#~ " {2,1} | POINT(0 3)\n" 5661#~ " {2,2} | POINT(3 4)\n" 5662#~ " {3,1,1} | POINT(2 0)\n" 5663#~ " {3,1,2} | POINT(2 3)\n" 5664#~ " {3,1,3} | POINT(0 2)\n" 5665#~ " {3,1,4} | POINT(2 0)\n" 5666#~ " {4,1,1} | POINT(3 0)\n" 5667#~ " {4,1,2} | POINT(3 3)\n" 5668#~ " {4,1,3} | POINT(6 3)\n" 5669#~ " {4,1,4} | POINT(6 0)\n" 5670#~ " {4,1,5} | POINT(3 0)\n" 5671#~ " {4,2,1} | POINT(5 1)\n" 5672#~ " {4,2,2} | POINT(4 2)\n" 5673#~ " {4,2,3} | POINT(5 2)\n" 5674#~ " {4,2,4} | POINT(5 1)\n" 5675#~ " {5,1,1,1} | POINT(0 5)\n" 5676#~ " {5,1,1,2} | POINT(0 8)\n" 5677#~ " {5,1,1,3} | POINT(4 8)\n" 5678#~ " {5,1,1,4} | POINT(4 5)\n" 5679#~ " {5,1,1,5} | POINT(0 5)\n" 5680#~ " {5,1,2,1} | POINT(1 6)\n" 5681#~ " {5,1,2,2} | POINT(3 6)\n" 5682#~ " {5,1,2,3} | POINT(2 7)\n" 5683#~ " {5,1,2,4} | POINT(1 6)\n" 5684#~ " {5,2,1,1} | POINT(5 4)\n" 5685#~ " {5,2,1,2} | POINT(5 8)\n" 5686#~ " {5,2,1,3} | POINT(6 7)\n" 5687#~ " {5,2,1,4} | POINT(5 4)\n" 5688#~ "(29 rows)" 5689#~ msgstr "" 5690#~ "SELECT path, ST_AsText(geom) \n" 5691#~ "FROM (\n" 5692#~ " SELECT (ST_DumpPoints(g.geom)).* \n" 5693#~ " FROM\n" 5694#~ " (SELECT \n" 5695#~ " 'GEOMETRYCOLLECTION(\n" 5696#~ " POINT ( 0 1 ), \n" 5697#~ " LINESTRING ( 0 3, 3 4 ),\n" 5698#~ " POLYGON (( 2 0, 2 3, 0 2, 2 0 )),\n" 5699#~ " POLYGON (( 3 0, 3 3, 6 3, 6 0, 3 0 ), \n" 5700#~ " ( 5 1, 4 2, 5 2, 5 1 )),\n" 5701#~ " MULTIPOLYGON (\n" 5702#~ " (( 0 5, 0 8, 4 8, 4 5, 0 5 ), \n" 5703#~ " ( 1 6, 3 6, 2 7, 1 6 )), \n" 5704#~ " (( 5 4, 5 8, 6 7, 5 4 ))\n" 5705#~ " )\n" 5706#~ " )'::geometry AS geom\n" 5707#~ " ) AS g\n" 5708#~ " ) j;\n" 5709#~ " \n" 5710#~ " path | st_astext \n" 5711#~ "-----------+------------\n" 5712#~ " {1,1} | POINT(0 1)\n" 5713#~ " {2,1} | POINT(0 3)\n" 5714#~ " {2,2} | POINT(3 4)\n" 5715#~ " {3,1,1} | POINT(2 0)\n" 5716#~ " {3,1,2} | POINT(2 3)\n" 5717#~ " {3,1,3} | POINT(0 2)\n" 5718#~ " {3,1,4} | POINT(2 0)\n" 5719#~ " {4,1,1} | POINT(3 0)\n" 5720#~ " {4,1,2} | POINT(3 3)\n" 5721#~ " {4,1,3} | POINT(6 3)\n" 5722#~ " {4,1,4} | POINT(6 0)\n" 5723#~ " {4,1,5} | POINT(3 0)\n" 5724#~ " {4,2,1} | POINT(5 1)\n" 5725#~ " {4,2,2} | POINT(4 2)\n" 5726#~ " {4,2,3} | POINT(5 2)\n" 5727#~ " {4,2,4} | POINT(5 1)\n" 5728#~ " {5,1,1,1} | POINT(0 5)\n" 5729#~ " {5,1,1,2} | POINT(0 8)\n" 5730#~ " {5,1,1,3} | POINT(4 8)\n" 5731#~ " {5,1,1,4} | POINT(4 5)\n" 5732#~ " {5,1,1,5} | POINT(0 5)\n" 5733#~ " {5,1,2,1} | POINT(1 6)\n" 5734#~ " {5,1,2,2} | POINT(3 6)\n" 5735#~ " {5,1,2,3} | POINT(2 7)\n" 5736#~ " {5,1,2,4} | POINT(1 6)\n" 5737#~ " {5,2,1,1} | POINT(5 4)\n" 5738#~ " {5,2,1,2} | POINT(5 8)\n" 5739#~ " {5,2,1,3} | POINT(6 7)\n" 5740#~ " {5,2,1,4} | POINT(5 4)\n" 5741#~ "(29 rows)" 5742 5743#, fuzzy 5744#~ msgid "" 5745#~ "-- Polyhedral surface cube --\n" 5746#~ "SELECT (g.gdump).path, ST_AsEWKT((g.gdump).geom) as wkt\n" 5747#~ " FROM\n" 5748#~ " (SELECT\n" 5749#~ " ST_DumpPoints(ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 0, 0 0 1, " 5750#~ "0 1 1, 0 1 0, 0 0 0)),\n" 5751#~ "((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0 " 5752#~ "0)),\n" 5753#~ "((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),\n" 5754#~ "((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)), ((0 0 1, 1 0 1, 1 1 1, 0 1 1, 0 0 " 5755#~ "1)) )') ) AS gdump\n" 5756#~ " ) AS g;\n" 5757#~ "-- result --\n" 5758#~ " path | wkt\n" 5759#~ "---------+--------------\n" 5760#~ " {1,1,1} | POINT(0 0 0)\n" 5761#~ " {1,1,2} | POINT(0 0 1)\n" 5762#~ " {1,1,3} | POINT(0 1 1)\n" 5763#~ " {1,1,4} | POINT(0 1 0)\n" 5764#~ " {1,1,5} | POINT(0 0 0)\n" 5765#~ " {2,1,1} | POINT(0 0 0)\n" 5766#~ " {2,1,2} | POINT(0 1 0)\n" 5767#~ " {2,1,3} | POINT(1 1 0)\n" 5768#~ " {2,1,4} | POINT(1 0 0)\n" 5769#~ " {2,1,5} | POINT(0 0 0)\n" 5770#~ " {3,1,1} | POINT(0 0 0)\n" 5771#~ " {3,1,2} | POINT(1 0 0)\n" 5772#~ " {3,1,3} | POINT(1 0 1)\n" 5773#~ " {3,1,4} | POINT(0 0 1)\n" 5774#~ " {3,1,5} | POINT(0 0 0)\n" 5775#~ " {4,1,1} | POINT(1 1 0)\n" 5776#~ " {4,1,2} | POINT(1 1 1)\n" 5777#~ " {4,1,3} | POINT(1 0 1)\n" 5778#~ " {4,1,4} | POINT(1 0 0)\n" 5779#~ " {4,1,5} | POINT(1 1 0)\n" 5780#~ " {5,1,1} | POINT(0 1 0)\n" 5781#~ " {5,1,2} | POINT(0 1 1)\n" 5782#~ " {5,1,3} | POINT(1 1 1)\n" 5783#~ " {5,1,4} | POINT(1 1 0)\n" 5784#~ " {5,1,5} | POINT(0 1 0)\n" 5785#~ " {6,1,1} | POINT(0 0 1)\n" 5786#~ " {6,1,2} | POINT(1 0 1)\n" 5787#~ " {6,1,3} | POINT(1 1 1)\n" 5788#~ " {6,1,4} | POINT(0 1 1)\n" 5789#~ " {6,1,5} | POINT(0 0 1)\n" 5790#~ "(30 rows)" 5791#~ msgstr "" 5792#~ "SELECT path, ST_AsText(geom) \n" 5793#~ "FROM (\n" 5794#~ " SELECT (ST_DumpPoints(g.geom)).* \n" 5795#~ " FROM\n" 5796#~ " (SELECT \n" 5797#~ " 'GEOMETRYCOLLECTION(\n" 5798#~ " POINT ( 0 1 ), \n" 5799#~ " LINESTRING ( 0 3, 3 4 ),\n" 5800#~ " POLYGON (( 2 0, 2 3, 0 2, 2 0 )),\n" 5801#~ " POLYGON (( 3 0, 3 3, 6 3, 6 0, 3 0 ), \n" 5802#~ " ( 5 1, 4 2, 5 2, 5 1 )),\n" 5803#~ " MULTIPOLYGON (\n" 5804#~ " (( 0 5, 0 8, 4 8, 4 5, 0 5 ), \n" 5805#~ " ( 1 6, 3 6, 2 7, 1 6 )), \n" 5806#~ " (( 5 4, 5 8, 6 7, 5 4 ))\n" 5807#~ " )\n" 5808#~ " )'::geometry AS geom\n" 5809#~ " ) AS g\n" 5810#~ " ) j;\n" 5811#~ " \n" 5812#~ " path | st_astext \n" 5813#~ "-----------+------------\n" 5814#~ " {1,1} | POINT(0 1)\n" 5815#~ " {2,1} | POINT(0 3)\n" 5816#~ " {2,2} | POINT(3 4)\n" 5817#~ " {3,1,1} | POINT(2 0)\n" 5818#~ " {3,1,2} | POINT(2 3)\n" 5819#~ " {3,1,3} | POINT(0 2)\n" 5820#~ " {3,1,4} | POINT(2 0)\n" 5821#~ " {4,1,1} | POINT(3 0)\n" 5822#~ " {4,1,2} | POINT(3 3)\n" 5823#~ " {4,1,3} | POINT(6 3)\n" 5824#~ " {4,1,4} | POINT(6 0)\n" 5825#~ " {4,1,5} | POINT(3 0)\n" 5826#~ " {4,2,1} | POINT(5 1)\n" 5827#~ " {4,2,2} | POINT(4 2)\n" 5828#~ " {4,2,3} | POINT(5 2)\n" 5829#~ " {4,2,4} | POINT(5 1)\n" 5830#~ " {5,1,1,1} | POINT(0 5)\n" 5831#~ " {5,1,1,2} | POINT(0 8)\n" 5832#~ " {5,1,1,3} | POINT(4 8)\n" 5833#~ " {5,1,1,4} | POINT(4 5)\n" 5834#~ " {5,1,1,5} | POINT(0 5)\n" 5835#~ " {5,1,2,1} | POINT(1 6)\n" 5836#~ " {5,1,2,2} | POINT(3 6)\n" 5837#~ " {5,1,2,3} | POINT(2 7)\n" 5838#~ " {5,1,2,4} | POINT(1 6)\n" 5839#~ " {5,2,1,1} | POINT(5 4)\n" 5840#~ " {5,2,1,2} | POINT(5 8)\n" 5841#~ " {5,2,1,3} | POINT(6 7)\n" 5842#~ " {5,2,1,4} | POINT(5 4)\n" 5843#~ "(29 rows)" 5844 5845#, fuzzy 5846#~ msgid "" 5847#~ "-- Triangle --\n" 5848#~ "SELECT (g.gdump).path, ST_AsText((g.gdump).geom) as wkt\n" 5849#~ " FROM\n" 5850#~ " (SELECT\n" 5851#~ " ST_DumpPoints( ST_GeomFromEWKT('TRIANGLE ((\n" 5852#~ " 0 0,\n" 5853#~ " 0 9,\n" 5854#~ " 9 0,\n" 5855#~ " 0 0\n" 5856#~ " ))') ) AS gdump\n" 5857#~ " ) AS g;\n" 5858#~ "-- result --\n" 5859#~ " path | wkt\n" 5860#~ "------+------------\n" 5861#~ " {1} | POINT(0 0)\n" 5862#~ " {2} | POINT(0 9)\n" 5863#~ " {3} | POINT(9 0)\n" 5864#~ " {4} | POINT(0 0)" 5865#~ msgstr "" 5866#~ "-- TIN -- \n" 5867#~ "SELECT (g.gdump).path, ST_AsEWKT((g.gdump).geom) as wkt\n" 5868#~ " FROM\n" 5869#~ " (SELECT \n" 5870#~ " ST_Dump( ST_GeomFromEWKT('TIN (((\n" 5871#~ " 0 0 0, \n" 5872#~ " 0 0 1, \n" 5873#~ " 0 1 0, \n" 5874#~ " 0 0 0\n" 5875#~ " )), ((\n" 5876#~ " 0 0 0, \n" 5877#~ " 0 1 0, \n" 5878#~ " 1 1 0, \n" 5879#~ " 0 0 0\n" 5880#~ " ))\n" 5881#~ " )') ) AS gdump\n" 5882#~ " ) AS g;\n" 5883#~ "-- result --\n" 5884#~ " path | wkt\n" 5885#~ "------+-------------------------------------\n" 5886#~ " {1} | TRIANGLE((0 0 0,0 0 1,0 1 0,0 0 0))\n" 5887#~ " {2} | TRIANGLE((0 0 0,0 1 0,1 1 0,0 0 0))" 5888 5889#, fuzzy 5890#~ msgid "" 5891#~ "-- TIN --\n" 5892#~ "SELECT (g.gdump).path, ST_AsEWKT((g.gdump).geom) as wkt\n" 5893#~ " FROM\n" 5894#~ " (SELECT\n" 5895#~ " ST_DumpPoints( ST_GeomFromEWKT('TIN (((\n" 5896#~ " 0 0 0,\n" 5897#~ " 0 0 1,\n" 5898#~ " 0 1 0,\n" 5899#~ " 0 0 0\n" 5900#~ " )), ((\n" 5901#~ " 0 0 0,\n" 5902#~ " 0 1 0,\n" 5903#~ " 1 1 0,\n" 5904#~ " 0 0 0\n" 5905#~ " ))\n" 5906#~ " )') ) AS gdump\n" 5907#~ " ) AS g;\n" 5908#~ "-- result --\n" 5909#~ " path | wkt\n" 5910#~ "---------+--------------\n" 5911#~ " {1,1,1} | POINT(0 0 0)\n" 5912#~ " {1,1,2} | POINT(0 0 1)\n" 5913#~ " {1,1,3} | POINT(0 1 0)\n" 5914#~ " {1,1,4} | POINT(0 0 0)\n" 5915#~ " {2,1,1} | POINT(0 0 0)\n" 5916#~ " {2,1,2} | POINT(0 1 0)\n" 5917#~ " {2,1,3} | POINT(1 1 0)\n" 5918#~ " {2,1,4} | POINT(0 0 0)\n" 5919#~ "(8 rows)" 5920#~ msgstr "" 5921#~ "-- TIN -- \n" 5922#~ "SELECT (g.gdump).path, ST_AsEWKT((g.gdump).geom) as wkt\n" 5923#~ " FROM\n" 5924#~ " (SELECT \n" 5925#~ " ST_Dump( ST_GeomFromEWKT('TIN (((\n" 5926#~ " 0 0 0, \n" 5927#~ " 0 0 1, \n" 5928#~ " 0 1 0, \n" 5929#~ " 0 0 0\n" 5930#~ " )), ((\n" 5931#~ " 0 0 0, \n" 5932#~ " 0 1 0, \n" 5933#~ " 1 1 0, \n" 5934#~ " 0 0 0\n" 5935#~ " ))\n" 5936#~ " )') ) AS gdump\n" 5937#~ " ) AS g;\n" 5938#~ "-- result --\n" 5939#~ " path | wkt\n" 5940#~ "------+-------------------------------------\n" 5941#~ " {1} | TRIANGLE((0 0 0,0 0 1,0 1 0,0 0 0))\n" 5942#~ " {2} | TRIANGLE((0 0 0,0 1 0,1 1 0,0 0 0))" 5943 5944#~ msgid "" 5945#~ ", <xref linkend=\"PostGIS_Geometry_DumpFunctions\"/>, <xref linkend=" 5946#~ "\"ST_Dump\"/>, <xref linkend=\"ST_DumpRings\"/>" 5947#~ msgstr "" 5948#~ ", <xref linkend=\"PostGIS_Geometry_DumpFunctions\"/>, <xref linkend=" 5949#~ "\"ST_Dump\"/>, <xref linkend=\"ST_DumpRings\"/>" 5950 5951#~ msgid "ST_DumpRings" 5952#~ msgstr "ST_DumpRings" 5953 5954#~ msgid "" 5955#~ "<funcdef>geometry_dump[] <function>ST_DumpRings</function></funcdef> " 5956#~ "<paramdef><type>geometry </type> <parameter>a_polygon</parameter></" 5957#~ "paramdef>" 5958#~ msgstr "" 5959#~ "<funcdef>geometry_dump[] <function>ST_DumpRings</function></funcdef> " 5960#~ "<paramdef><type>geometry </type> <parameter>a_polygon</parameter></" 5961#~ "paramdef>" 5962 5963#~ msgid "" 5964#~ "SELECT sometable.field1, sometable.field1,\n" 5965#~ " (ST_DumpRings(sometable.the_geom)).geom As the_geom\n" 5966#~ "FROM sometableOfpolys;\n" 5967#~ "\n" 5968#~ "SELECT ST_AsEWKT(geom) As the_geom, path\n" 5969#~ " FROM ST_DumpRings(\n" 5970#~ " ST_GeomFromEWKT('POLYGON((-8149064 5133092 1,-8149064 " 5971#~ "5132986 1,-8148996 5132839 1,-8148972 5132767 1,-8148958 5132508 " 5972#~ "1,-8148941 5132466 1,-8148924 5132394 1,\n" 5973#~ " -8148903 5132210 1,-8148930 5131967 1,-8148992 5131978 " 5974#~ "1,-8149237 5132093 1,-8149404 5132211 1,-8149647 5132310 1,-8149757 " 5975#~ "5132394 1,\n" 5976#~ " -8150305 5132788 1,-8149064 5133092 1),\n" 5977#~ " (-8149362 5132394 1,-8149446 5132501 1,-8149548 5132597 " 5978#~ "1,-8149695 5132675 1,-8149362 5132394 1))')\n" 5979#~ " ) as foo;\n" 5980#~ " path | the_geom\n" 5981#~ "----------------------------------------------------------------------------------------------------------------\n" 5982#~ " {0} | POLYGON((-8149064 5133092 1,-8149064 5132986 1,-8148996 5132839 " 5983#~ "1,-8148972 5132767 1,-8148958 5132508 1,\n" 5984#~ " | -8148941 5132466 1,-8148924 5132394 1,\n" 5985#~ " | -8148903 5132210 1,-8148930 5131967 1,\n" 5986#~ " | -8148992 5131978 1,-8149237 5132093 1,\n" 5987#~ " | -8149404 5132211 1,-8149647 5132310 1,-8149757 " 5988#~ "5132394 1,-8150305 5132788 1,-8149064 5133092 1))\n" 5989#~ " {1} | POLYGON((-8149362 5132394 1,-8149446 5132501 1,\n" 5990#~ " | -8149548 5132597 1,-8149695 5132675 1,-8149362 " 5991#~ "5132394 1))" 5992#~ msgstr "" 5993#~ "SELECT sometable.field1, sometable.field1,\n" 5994#~ " (ST_DumpRings(sometable.the_geom)).geom As the_geom\n" 5995#~ "FROM sometableOfpolys;\n" 5996#~ "\n" 5997#~ "SELECT ST_AsEWKT(geom) As the_geom, path\n" 5998#~ " FROM ST_DumpRings(\n" 5999#~ " ST_GeomFromEWKT('POLYGON((-8149064 5133092 1,-8149064 " 6000#~ "5132986 1,-8148996 5132839 1,-8148972 5132767 1,-8148958 5132508 " 6001#~ "1,-8148941 5132466 1,-8148924 5132394 1,\n" 6002#~ " -8148903 5132210 1,-8148930 5131967 1,-8148992 5131978 " 6003#~ "1,-8149237 5132093 1,-8149404 5132211 1,-8149647 5132310 1,-8149757 " 6004#~ "5132394 1,\n" 6005#~ " -8150305 5132788 1,-8149064 5133092 1),\n" 6006#~ " (-8149362 5132394 1,-8149446 5132501 1,-8149548 5132597 " 6007#~ "1,-8149695 5132675 1,-8149362 5132394 1))')\n" 6008#~ " ) as foo;\n" 6009#~ " path | the_geom\n" 6010#~ "----------------------------------------------------------------------------------------------------------------\n" 6011#~ " {0} | POLYGON((-8149064 5133092 1,-8149064 5132986 1,-8148996 5132839 " 6012#~ "1,-8148972 5132767 1,-8148958 5132508 1,\n" 6013#~ " | -8148941 5132466 1,-8148924 5132394 1,\n" 6014#~ " | -8148903 5132210 1,-8148930 5131967 1,\n" 6015#~ " | -8148992 5131978 1,-8149237 5132093 1,\n" 6016#~ " | -8149404 5132211 1,-8149647 5132310 1,-8149757 " 6017#~ "5132394 1,-8150305 5132788 1,-8149064 5133092 1))\n" 6018#~ " {1} | POLYGON((-8149362 5132394 1,-8149446 5132501 1,\n" 6019#~ " | -8149548 5132597 1,-8149695 5132675 1,-8149362 " 6020#~ "5132394 1))" 6021 6022#~ msgid "" 6023#~ ", <xref linkend=\"PostGIS_Geometry_DumpFunctions\"/>, <xref linkend=" 6024#~ "\"ST_Dump\"/>, <xref linkend=\"ST_ExteriorRing\"/>, <xref linkend=" 6025#~ "\"ST_InteriorRingN\"/>" 6026#~ msgstr "" 6027#~ ", <xref linkend=\"PostGIS_Geometry_DumpFunctions\"/>, <xref linkend=" 6028#~ "\"ST_Dump\"/>, <xref linkend=\"ST_ExteriorRing\"/>, <xref linkend=" 6029#~ "\"ST_InteriorRingN\"/>" 6030 6031#, fuzzy 6032#~ msgid "" 6033#~ "<funcdef>geometry <function>ST_GeneratePoints</function></funcdef> " 6034#~ "<paramdef> <parameter>g</parameter> <type>geometry</type> </paramdef> " 6035#~ "<paramdef> <parameter>npoints</parameter> <type>numeric</type> </paramdef>" 6036#~ msgstr "" 6037#~ "<funcdef>geometry <function>ST_MakeValid</function></funcdef> " 6038#~ "<paramdef><type>geometry</type> <parameter>input</parameter></paramdef>" 6039 6040#, fuzzy 6041#~ msgid "" 6042#~ "<funcprototype> <funcdef>geometry <function>ST_CurveToLine</function></" 6043#~ "funcdef> <paramdef><type>geometry</type> <parameter>curveGeom</" 6044#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 6045#~ "<function>ST_CurveToLine</function></funcdef> <paramdef><type>geometry</" 6046#~ "type> <parameter>curveGeom</parameter></paramdef> " 6047#~ "<paramdef><type>integer</type> <parameter>segments_per_qtr_circle</" 6048#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 6049#~ "<function>ST_CurveToLine</function></funcdef> <paramdef><type>geometry</" 6050#~ "type> <parameter>curveGeom</parameter></paramdef> <paramdef><type>float</" 6051#~ "type> <parameter>tolerance</parameter></paramdef> " 6052#~ "<paramdef><type>integer</type> <parameter>tolerance_type</parameter></" 6053#~ "paramdef> <paramdef><type>integer</type> <parameter>flags</parameter></" 6054#~ "paramdef> </funcprototype>" 6055#~ msgstr "" 6056#~ "<funcprototype> <funcdef>geometry <function>ST_Collect</function></" 6057#~ "funcdef> <paramdef><type>geometry set</type> <parameter>g1field</" 6058#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 6059#~ "<function>ST_Collect</function></funcdef> <paramdef><type>geometry</type> " 6060#~ "<parameter>g1</parameter></paramdef> <paramdef><type>geometry</type> " 6061#~ "<parameter>g2</parameter></paramdef> </funcprototype> <funcprototype> " 6062#~ "<funcdef>geometry <function>ST_Collect</function></funcdef> " 6063#~ "<paramdef><type>geometry[]</type> <parameter>g1_array</parameter></" 6064#~ "paramdef> </funcprototype>" 6065 6066#~ msgid ", <xref linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_AsEWKT\"/>" 6067#~ msgstr "" 6068#~ ", <xref linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_AsEWKT\"/>" 6069 6070#~ msgid "" 6071#~ "<funcdef>geometry <function>ST_Simplify</function></funcdef> " 6072#~ "<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 6073#~ "<paramdef><type>float</type> <parameter>tolerance</parameter></paramdef>" 6074#~ msgstr "" 6075#~ "<funcdef>geometry <function>ST_Simplify</function></funcdef> " 6076#~ "<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 6077#~ "<paramdef><type>float</type> <parameter>tolerance</parameter></paramdef>" 6078