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