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: 2017-09-14 18:44+0000\n" 10"PO-Revision-Date: 2018-07-23 18:00+0000\n" 11"Last-Translator: nramire1 nramire1\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_operator.xml:3 22#, no-c-format 23msgid "Operators" 24msgstr "Operadores" 25 26#. Tag: refname 27#: reference_operator.xml:6 28#, no-c-format 29msgid "&&" 30msgstr "&&" 31 32#. Tag: refpurpose 33#: reference_operator.xml:8 34#, no-c-format 35msgid "" 36"Returns <varname>TRUE</varname> if A's 2D bounding box intersects B's 2D " 37"bounding box." 38msgstr "" 39 40#. Tag: funcsynopsis 41#: reference_operator.xml:12 42#, no-c-format 43msgid "" 44"<funcprototype> <funcdef>boolean <function>&&</function></funcdef> " 45"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 46"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef> </" 47"funcprototype> <funcprototype> <funcdef>boolean <function>&&</" 48"function></funcdef> <paramdef> <type>geography </type> <parameter>A</" 49"parameter> </paramdef> <paramdef> <type>geography </type> <parameter>B</" 50"parameter> </paramdef> </funcprototype>" 51msgstr "" 52 53#. Tag: title 54#: reference_operator.xml:50 reference_operator.xml:111 55#: reference_operator.xml:172 reference_operator.xml:233 56#: reference_operator.xml:294 reference_operator.xml:356 57#: reference_operator.xml:413 reference_operator.xml:470 58#: reference_operator.xml:530 reference_operator.xml:588 59#: reference_operator.xml:649 reference_operator.xml:707 60#: reference_operator.xml:760 reference_operator.xml:830 61#: reference_operator.xml:902 reference_operator.xml:955 62#: reference_operator.xml:1007 reference_operator.xml:1068 63#: reference_operator.xml:1129 reference_operator.xml:1193 64#: reference_operator.xml:1251 reference_operator.xml:1304 65#: reference_operator.xml:1354 reference_operator.xml:1415 66#: reference_operator.xml:1476 reference_operator.xml:1540 67#: reference_operator.xml:1619 reference_operator.xml:1694 68#: reference_operator.xml:1755 reference_operator.xml:1809 69#: reference_operator.xml:1874 70#, no-c-format 71msgid "Description" 72msgstr "Descripción" 73 74#. Tag: para 75#: reference_operator.xml:52 76#, no-c-format 77msgid "" 78"The <varname>&&</varname> operator returns <varname>TRUE</varname> " 79"if the 2D bounding box of geometry A intersects the 2D bounding box of " 80"geometry B." 81msgstr "" 82 83#. Tag: para 84#: reference_operator.xml:54 reference_operator.xml:298 85#: reference_operator.xml:536 reference_operator.xml:597 86#: reference_operator.xml:655 reference_operator.xml:712 87#: reference_operator.xml:765 reference_operator.xml:907 88#: reference_operator.xml:961 reference_operator.xml:1199 89#: reference_operator.xml:1256 reference_operator.xml:1309 90#: reference_operator.xml:1545 91#, no-c-format 92msgid "" 93"This operand will make use of any indexes that may be available on the " 94"geometries." 95msgstr "" 96 97#. Tag: para 98#: reference_operator.xml:57 99#, no-c-format 100msgid "Enhanced: 2.0.0 support for Polyhedral surfaces was introduced." 101msgstr "Mejorado: 2.0.0 soporte para superficies poliédricas fue introducida." 102 103#. Tag: para 104#: reference_operator.xml:58 105#, no-c-format 106msgid "Availability: 1.5.0 support for geography was introduced." 107msgstr "" 108 109#. Tag: para 110#: reference_operator.xml:59 reference_operator.xml:119 111#: reference_operator.xml:180 reference_operator.xml:241 112#: reference_operator.xml:302 reference_operator.xml:364 113#: reference_operator.xml:421 reference_operator.xml:478 114#: reference_operator.xml:594 reference_operator.xml:852 115#: reference_operator.xml:1015 reference_operator.xml:1076 116#: reference_operator.xml:1137 reference_operator.xml:1362 117#: reference_operator.xml:1423 reference_operator.xml:1484 118#, no-c-format 119msgid "&curve_support;" 120msgstr "&curve_support;" 121 122#. Tag: para 123#: reference_operator.xml:60 reference_operator.xml:120 124#: reference_operator.xml:181 reference_operator.xml:242 125#: reference_operator.xml:303 reference_operator.xml:365 126#: reference_operator.xml:422 reference_operator.xml:479 127#: reference_operator.xml:595 reference_operator.xml:853 128#: reference_operator.xml:1016 reference_operator.xml:1077 129#: reference_operator.xml:1138 reference_operator.xml:1363 130#: reference_operator.xml:1424 reference_operator.xml:1485 131#: reference_operator.xml:1549 132#, no-c-format 133msgid "&P_support;" 134msgstr "&P_support;" 135 136#. Tag: title 137#: reference_operator.xml:64 reference_operator.xml:124 138#: reference_operator.xml:185 reference_operator.xml:246 139#: reference_operator.xml:371 reference_operator.xml:428 140#: reference_operator.xml:485 reference_operator.xml:541 141#: reference_operator.xml:602 reference_operator.xml:660 142#: reference_operator.xml:717 reference_operator.xml:770 143#: reference_operator.xml:858 reference_operator.xml:912 144#: reference_operator.xml:967 reference_operator.xml:1020 145#: reference_operator.xml:1081 reference_operator.xml:1142 146#: reference_operator.xml:1204 reference_operator.xml:1261 147#: reference_operator.xml:1314 reference_operator.xml:1367 148#: reference_operator.xml:1428 reference_operator.xml:1489 149#: reference_operator.xml:1564 reference_operator.xml:1642 150#: reference_operator.xml:1712 reference_operator.xml:1769 151#, no-c-format 152msgid "Examples" 153msgstr "Ejemplos" 154 155#. Tag: programlisting 156#: reference_operator.xml:66 157#, no-c-format 158msgid "" 159"SELECT tbl1.column1, tbl2.column1, tbl1.column2 && tbl2.column2 AS " 160"overlaps\n" 161"FROM ( VALUES\n" 162" (1, 'LINESTRING(0 0, 3 3)'::geometry),\n" 163" (2, 'LINESTRING(0 1, 0 5)'::geometry)) AS tbl1,\n" 164"( VALUES\n" 165" (3, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl2;\n" 166"\n" 167" column1 | column1 | overlaps\n" 168"---------+---------+----------\n" 169" 1 | 3 | t\n" 170" 2 | 3 | f\n" 171"(2 rows)" 172msgstr "" 173 174#. Tag: title 175#: reference_operator.xml:71 reference_operator.xml:130 176#: reference_operator.xml:191 reference_operator.xml:252 177#: reference_operator.xml:322 reference_operator.xml:377 178#: reference_operator.xml:434 reference_operator.xml:491 179#: reference_operator.xml:547 reference_operator.xml:608 180#: reference_operator.xml:666 reference_operator.xml:723 181#: reference_operator.xml:776 reference_operator.xml:864 182#: reference_operator.xml:918 reference_operator.xml:973 183#: reference_operator.xml:1026 reference_operator.xml:1087 184#: reference_operator.xml:1148 reference_operator.xml:1210 185#: reference_operator.xml:1267 reference_operator.xml:1320 186#: reference_operator.xml:1373 reference_operator.xml:1434 187#: reference_operator.xml:1495 reference_operator.xml:1568 188#: reference_operator.xml:1658 reference_operator.xml:1716 189#: reference_operator.xml:1773 reference_operator.xml:1836 190#: reference_operator.xml:1892 191#, no-c-format 192msgid "See Also" 193msgstr "Ver también" 194 195#. Tag: para 196#: reference_operator.xml:73 197#, no-c-format 198msgid "" 199", <xref linkend=\"ST_Geometry_Overright\"/>, <xref linkend=" 200"\"ST_Geometry_Overbelow\"/>, <xref linkend=\"ST_Geometry_Overleft\"/>, <xref " 201"linkend=\"ST_Geometry_Contain\"/>, <xref linkend=\"ST_Geometry_Contained\"/>" 202msgstr "" 203 204#. Tag: refname 205#: reference_operator.xml:85 206#, no-c-format 207msgid "&&(geometry,box2df)" 208msgstr "" 209 210#. Tag: refpurpose 211#: reference_operator.xml:87 212#, no-c-format 213msgid "" 214"Returns <varname>TRUE</varname> if a geometry's (cached) 2D bounding box " 215"intersects a 2D float precision bounding box (BOX2DF)." 216msgstr "" 217 218#. Tag: funcprototype 219#: reference_operator.xml:92 220#, no-c-format 221msgid "" 222"<funcdef>boolean <function>&&</function></funcdef> <paramdef> " 223"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 224"<type>box2df</type> <parameter>B</parameter> </paramdef>" 225msgstr "" 226 227#. Tag: para 228#: reference_operator.xml:113 229#, no-c-format 230msgid "" 231"The <varname>&&</varname> operator returns <varname>TRUE</varname> " 232"if the cached 2D bounding box of geometry A intersects the 2D bounding box " 233"B, using float precision. This means that if B is a (double precision) " 234"box2d, it will be internally converted to a float precision 2D bounding box " 235"(BOX2DF)" 236msgstr "" 237 238#. Tag: para 239#: reference_operator.xml:115 reference_operator.xml:176 240#: reference_operator.xml:1011 reference_operator.xml:1072 241#: reference_operator.xml:1133 reference_operator.xml:1358 242#: reference_operator.xml:1419 reference_operator.xml:1480 243#, no-c-format 244msgid "" 245"This operand is intended to be used internally by BRIN indexes, more than by " 246"users." 247msgstr "" 248 249#. Tag: para 250#: reference_operator.xml:118 reference_operator.xml:179 251#: reference_operator.xml:240 reference_operator.xml:363 252#: reference_operator.xml:420 reference_operator.xml:477 253#: reference_operator.xml:1014 reference_operator.xml:1075 254#: reference_operator.xml:1136 reference_operator.xml:1361 255#: reference_operator.xml:1422 reference_operator.xml:1483 256#, no-c-format 257msgid "" 258"Availability: 2.3.0 support for Block Range INdexes (BRIN) was introduced. " 259"Requires PostgreSQL 9.5+." 260msgstr "" 261 262#. Tag: programlisting 263#: reference_operator.xml:126 264#, no-c-format 265msgid "" 266"SELECT ST_MakePoint(1,1) && ST_MakeBox2D(ST_MakePoint(0,0), " 267"ST_MakePoint(2,2)) AS overlaps;\n" 268"\n" 269" overlaps\n" 270"----------\n" 271" t\n" 272"(1 row)" 273msgstr "" 274 275#. Tag: para 276#: reference_operator.xml:132 reference_operator.xml:193 277#, no-c-format 278msgid "" 279", <xref linkend=\"overlaps_box2df_box2df\"/>, <xref linkend=" 280"\"contains_geometry_box2df\"/>, <xref linkend=\"contains_box2df_geometry\"/" 281">, <xref linkend=\"contains_box2df_box2df\"/>, <xref linkend=" 282"\"is_contained_geometry_box2df\"/>, <xref linkend=" 283"\"is_contained_box2df_geometry\"/>, <xref linkend=" 284"\"is_contained_box2df_box2df\"/>" 285msgstr "" 286 287#. Tag: refname 288#: reference_operator.xml:146 289#, no-c-format 290msgid "&&(box2df,geometry)" 291msgstr "" 292 293#. Tag: refpurpose 294#: reference_operator.xml:148 295#, no-c-format 296msgid "" 297"Returns <varname>TRUE</varname> if a 2D float precision bounding box " 298"(BOX2DF) intersects a geometry's (cached) 2D bounding box." 299msgstr "" 300 301#. Tag: funcprototype 302#: reference_operator.xml:153 303#, no-c-format 304msgid "" 305"<funcdef>boolean <function>&&</function></funcdef> <paramdef> " 306"<type>box2df </type> <parameter>A</parameter> </paramdef> <paramdef> " 307"<type>geometry </type> <parameter>B</parameter> </paramdef>" 308msgstr "" 309 310#. Tag: para 311#: reference_operator.xml:174 312#, no-c-format 313msgid "" 314"The <varname>&&</varname> operator returns <varname>TRUE</varname> " 315"if the 2D bounding box A intersects the cached 2D bounding box of geometry " 316"B, using float precision. This means that if A is a (double precision) " 317"box2d, it will be internally converted to a float precision 2D bounding box " 318"(BOX2DF)" 319msgstr "" 320 321#. Tag: programlisting 322#: reference_operator.xml:187 323#, no-c-format 324msgid "" 325"SELECT ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(2,2)) && " 326"ST_MakePoint(1,1) AS overlaps;\n" 327"\n" 328" overlaps\n" 329"----------\n" 330" t\n" 331"(1 row)" 332msgstr "" 333 334#. Tag: refname 335#: reference_operator.xml:207 336#, no-c-format 337msgid "&&(box2df,box2df)" 338msgstr "" 339 340#. Tag: refpurpose 341#: reference_operator.xml:209 342#, no-c-format 343msgid "" 344"Returns <varname>TRUE</varname> if two 2D float precision bounding boxes " 345"(BOX2DF) intersect each other." 346msgstr "" 347 348#. Tag: funcprototype 349#: reference_operator.xml:214 350#, no-c-format 351msgid "" 352"<funcdef>boolean <function>&&</function></funcdef> <paramdef> " 353"<type>box2df </type> <parameter>A</parameter> </paramdef> <paramdef> " 354"<type>box2df </type> <parameter>B</parameter> </paramdef>" 355msgstr "" 356 357#. Tag: para 358#: reference_operator.xml:235 359#, no-c-format 360msgid "" 361"The <varname>&&</varname> operator returns <varname>TRUE</varname> " 362"if two 2D bounding boxes A and B intersect each other, using float " 363"precision. This means that if A (or B) is a (double precision) box2d, it " 364"will be internally converted to a float precision 2D bounding box (BOX2DF)" 365msgstr "" 366 367#. Tag: para 368#: reference_operator.xml:237 reference_operator.xml:360 369#: reference_operator.xml:417 reference_operator.xml:474 370#, no-c-format 371msgid "" 372"This operator is intended to be used internally by BRIN indexes, more than " 373"by users." 374msgstr "" 375 376#. Tag: programlisting 377#: reference_operator.xml:248 378#, no-c-format 379msgid "" 380"SELECT ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(2,2)) && " 381"ST_MakeBox2D(ST_MakePoint(1,1), ST_MakePoint(3,3)) AS overlaps;\n" 382"\n" 383" overlaps\n" 384"----------\n" 385" t\n" 386"(1 row)" 387msgstr "" 388 389#. Tag: para 390#: reference_operator.xml:254 391#, no-c-format 392msgid "" 393", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 394"\"contains_geometry_box2df\"/>, <xref linkend=\"contains_box2df_geometry\"/" 395">, <xref linkend=\"contains_box2df_box2df\"/>, <xref linkend=" 396"\"is_contained_geometry_box2df\"/>, <xref linkend=" 397"\"is_contained_box2df_geometry\"/>, <xref linkend=" 398"\"is_contained_box2df_box2df\"/>" 399msgstr "" 400 401#. Tag: refname 402#: reference_operator.xml:268 403#, no-c-format 404msgid "&&&" 405msgstr "" 406 407#. Tag: refpurpose 408#: reference_operator.xml:270 409#, no-c-format 410msgid "" 411"Returns <varname>TRUE</varname> if A's n-D bounding box intersects B's n-D " 412"bounding box." 413msgstr "" 414 415#. Tag: funcprototype 416#: reference_operator.xml:275 417#, no-c-format 418msgid "" 419"<funcdef>boolean <function>&&&</function></funcdef> <paramdef> " 420"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 421"<type>geometry </type> <parameter>B</parameter> </paramdef>" 422msgstr "" 423 424#. Tag: para 425#: reference_operator.xml:296 426#, no-c-format 427msgid "" 428"The <varname>&&&</varname> operator returns <varname>TRUE</" 429"varname> if the n-D bounding box of geometry A intersects the n-D bounding " 430"box of geometry B." 431msgstr "" 432 433#. Tag: para 434#: reference_operator.xml:301 435#, no-c-format 436msgid "Availability: 2.0.0" 437msgstr "Disponibilidad: 2.0.0" 438 439#. Tag: para 440#: reference_operator.xml:304 reference_operator.xml:366 441#: reference_operator.xml:423 reference_operator.xml:480 442#, no-c-format 443msgid "&T_support;" 444msgstr "&T_support;" 445 446#. Tag: para 447#: reference_operator.xml:305 reference_operator.xml:367 448#: reference_operator.xml:424 reference_operator.xml:481 449#, no-c-format 450msgid "&Z_support;" 451msgstr "&Z_support;" 452 453#. Tag: title 454#: reference_operator.xml:309 455#, no-c-format 456msgid "Examples: 3D LineStrings" 457msgstr "" 458 459#. Tag: programlisting 460#: reference_operator.xml:311 461#, no-c-format 462msgid "" 463"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &&& tbl2.column2 " 464"AS overlaps_3d,\n" 465" tbl1.column2 && tbl2.column2 AS " 466"overlaps_2d\n" 467"FROM ( VALUES\n" 468" (1, 'LINESTRING Z(0 0 1, 3 3 2)'::geometry),\n" 469" (2, 'LINESTRING Z(1 2 0, 0 5 -1)'::geometry)) AS tbl1,\n" 470"( VALUES\n" 471" (3, 'LINESTRING Z(1 2 1, 4 6 1)'::geometry)) AS tbl2;\n" 472"\n" 473" column1 | column1 | overlaps_3d | overlaps_2d\n" 474"---------+---------+-------------+-------------\n" 475" 1 | 3 | t | t\n" 476" 2 | 3 | f | t" 477msgstr "" 478 479#. Tag: title 480#: reference_operator.xml:315 481#, no-c-format 482msgid "Examples: 3M LineStrings" 483msgstr "" 484 485#. Tag: programlisting 486#: reference_operator.xml:317 487#, no-c-format 488msgid "" 489"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &&& tbl2.column2 " 490"AS overlaps_3zm,\n" 491" tbl1.column2 && tbl2.column2 AS " 492"overlaps_2d\n" 493"FROM ( VALUES\n" 494" (1, 'LINESTRING M(0 0 1, 3 3 2)'::geometry),\n" 495" (2, 'LINESTRING M(1 2 0, 0 5 -1)'::geometry)) AS tbl1,\n" 496"( VALUES\n" 497" (3, 'LINESTRING M(1 2 1, 4 6 1)'::geometry)) AS tbl2;\n" 498"\n" 499" column1 | column1 | overlaps_3zm | overlaps_2d\n" 500"---------+---------+-------------+-------------\n" 501" 1 | 3 | t | t\n" 502" 2 | 3 | f | t" 503msgstr "" 504 505#. Tag: refname 506#: reference_operator.xml:330 507#, no-c-format 508msgid "&&&(geometry,gidx)" 509msgstr "" 510 511#. Tag: refpurpose 512#: reference_operator.xml:332 513#, no-c-format 514msgid "" 515"Returns <varname>TRUE</varname> if a geometry's (cached) n-D bounding box " 516"intersects a n-D float precision bounding box (GIDX)." 517msgstr "" 518 519#. Tag: funcprototype 520#: reference_operator.xml:337 521#, no-c-format 522msgid "" 523"<funcdef>boolean <function>&&&</function></funcdef> <paramdef> " 524"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 525"<type>gidx </type> <parameter>B</parameter> </paramdef>" 526msgstr "" 527 528#. Tag: para 529#: reference_operator.xml:358 530#, no-c-format 531msgid "" 532"The <varname>&&&</varname> operator returns <varname>TRUE</" 533"varname> if the cached n-D bounding box of geometry A intersects the n-D " 534"bounding box B, using float precision. This means that if B is a (double " 535"precision) box3d, it will be internally converted to a float precision 3D " 536"bounding box (GIDX)" 537msgstr "" 538 539#. Tag: programlisting 540#: reference_operator.xml:373 541#, no-c-format 542msgid "" 543"SELECT ST_MakePoint(1,1,1) &&& ST_3DMakeBox(ST_MakePoint(0,0,0), " 544"ST_MakePoint(2,2,2)) AS overlaps;\n" 545"\n" 546" overlaps\n" 547"----------\n" 548" t\n" 549"(1 row)" 550msgstr "" 551 552#. Tag: para 553#: reference_operator.xml:379 reference_operator.xml:436 554#, no-c-format 555msgid ", <xref linkend=\"overlaps_nd_gidx_gidx\"/>" 556msgstr "" 557 558#. Tag: refname 559#: reference_operator.xml:387 560#, no-c-format 561msgid "&&&(gidx,geometry)" 562msgstr "" 563 564#. Tag: refpurpose 565#: reference_operator.xml:389 566#, no-c-format 567msgid "" 568"Returns <varname>TRUE</varname> if a n-D float precision bounding box (GIDX) " 569"intersects a geometry's (cached) n-D bounding box." 570msgstr "" 571 572#. Tag: funcprototype 573#: reference_operator.xml:394 574#, no-c-format 575msgid "" 576"<funcdef>boolean <function>&&&</function></funcdef> <paramdef> " 577"<type>gidx </type> <parameter>A</parameter> </paramdef> <paramdef> " 578"<type>geometry </type> <parameter>B</parameter> </paramdef>" 579msgstr "" 580 581#. Tag: para 582#: reference_operator.xml:415 583#, no-c-format 584msgid "" 585"The <varname>&&&</varname> operator returns <varname>TRUE</" 586"varname> if the n-D bounding box A intersects the cached n-D bounding box of " 587"geometry B, using float precision. This means that if A is a (double " 588"precision) box3d, it will be internally converted to a float precision 3D " 589"bounding box (GIDX)" 590msgstr "" 591 592#. Tag: programlisting 593#: reference_operator.xml:430 594#, no-c-format 595msgid "" 596"SELECT ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) &&" 597"& ST_MakePoint(1,1,1) AS overlaps;\n" 598"\n" 599" overlaps\n" 600"----------\n" 601" t\n" 602"(1 row)" 603msgstr "" 604 605#. Tag: refname 606#: reference_operator.xml:444 607#, no-c-format 608msgid "&&&(gidx,gidx)" 609msgstr "" 610 611#. Tag: refpurpose 612#: reference_operator.xml:446 613#, no-c-format 614msgid "" 615"Returns <varname>TRUE</varname> if two n-D float precision bounding boxes " 616"(GIDX) intersect each other." 617msgstr "" 618 619#. Tag: funcprototype 620#: reference_operator.xml:451 621#, no-c-format 622msgid "" 623"<funcdef>boolean <function>&&&</function></funcdef> <paramdef> " 624"<type>gidx </type> <parameter>A</parameter> </paramdef> <paramdef> " 625"<type>gidx </type> <parameter>B</parameter> </paramdef>" 626msgstr "" 627 628#. Tag: para 629#: reference_operator.xml:472 630#, no-c-format 631msgid "" 632"The <varname>&&&</varname> operator returns <varname>TRUE</" 633"varname> if two n-D bounding boxes A and B intersect each other, using float " 634"precision. This means that if A (or B) is a (double precision) box3d, it " 635"will be internally converted to a float precision 3D bounding box (GIDX)" 636msgstr "" 637 638#. Tag: programlisting 639#: reference_operator.xml:487 640#, no-c-format 641msgid "" 642"SELECT ST_3DMakeBox(ST_MakePoint(0,0,0), ST_MakePoint(2,2,2)) &&" 643"& ST_3DMakeBox(ST_MakePoint(1,1,1), ST_MakePoint(3,3,3)) AS overlaps;\n" 644"\n" 645" overlaps\n" 646"----------\n" 647" t\n" 648"(1 row)" 649msgstr "" 650 651#. Tag: para 652#: reference_operator.xml:493 653#, no-c-format 654msgid ", <xref linkend=\"overlaps_nd_gidx_geometry\"/>" 655msgstr "" 656 657#. Tag: refname 658#: reference_operator.xml:501 659#, no-c-format 660msgid "&<" 661msgstr "" 662 663#. Tag: refpurpose 664#: reference_operator.xml:503 665#, no-c-format 666msgid "" 667"Returns <varname>TRUE</varname> if A's bounding box overlaps or is to the " 668"left of B's." 669msgstr "" 670 671#. Tag: funcprototype 672#: reference_operator.xml:508 673#, no-c-format 674msgid "" 675"<funcdef>boolean <function>&<</function></funcdef> <paramdef> " 676"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 677"<type>geometry </type> <parameter>B</parameter> </paramdef>" 678msgstr "" 679 680#. Tag: para 681#: reference_operator.xml:532 682#, no-c-format 683msgid "" 684"The <varname>&<</varname> operator returns <varname>TRUE</varname> if " 685"the bounding box of geometry A overlaps or is to the left of the bounding " 686"box of geometry B, or more accurately, overlaps or is NOT to the right of " 687"the bounding box of geometry B." 688msgstr "" 689 690#. Tag: programlisting 691#: reference_operator.xml:543 692#, no-c-format 693msgid "" 694"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &< tbl2.column2 AS " 695"overleft\n" 696"FROM\n" 697" ( VALUES\n" 698" (1, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl1,\n" 699" ( VALUES\n" 700" (2, 'LINESTRING(0 0, 3 3)'::geometry),\n" 701" (3, 'LINESTRING(0 1, 0 5)'::geometry),\n" 702" (4, 'LINESTRING(6 0, 6 1)'::geometry)) AS tbl2;\n" 703"\n" 704" column1 | column1 | overleft\n" 705"---------+---------+----------\n" 706" 1 | 2 | f\n" 707" 1 | 3 | f\n" 708" 1 | 4 | t\n" 709"(3 rows)" 710msgstr "" 711 712#. Tag: para 713#: reference_operator.xml:549 714#, no-c-format 715msgid "" 716", <xref linkend=\"ST_Geometry_Overabove\"/>, <xref linkend=" 717"\"ST_Geometry_Overright\"/>, <xref linkend=\"ST_Geometry_Overbelow\"/>" 718msgstr "" 719 720#. Tag: refname 721#: reference_operator.xml:559 722#, no-c-format 723msgid "&<|" 724msgstr "" 725 726#. Tag: refpurpose 727#: reference_operator.xml:561 728#, no-c-format 729msgid "" 730"Returns <varname>TRUE</varname> if A's bounding box overlaps or is below B's." 731msgstr "" 732 733#. Tag: funcprototype 734#: reference_operator.xml:566 735#, no-c-format 736msgid "" 737"<funcdef>boolean <function>&<|</function></funcdef> <paramdef> " 738"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 739"<type>geometry </type> <parameter>B</parameter> </paramdef>" 740msgstr "" 741 742#. Tag: para 743#: reference_operator.xml:590 744#, no-c-format 745msgid "" 746"The <varname>&<|</varname> operator returns <varname>TRUE</varname> " 747"if the bounding box of geometry A overlaps or is below of the bounding box " 748"of geometry B, or more accurately, overlaps or is NOT above the bounding box " 749"of geometry B." 750msgstr "" 751 752#. Tag: programlisting 753#: reference_operator.xml:604 754#, no-c-format 755msgid "" 756"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &<| tbl2.column2 AS " 757"overbelow\n" 758"FROM\n" 759" ( VALUES\n" 760" (1, 'LINESTRING(6 0, 6 4)'::geometry)) AS tbl1,\n" 761" ( VALUES\n" 762" (2, 'LINESTRING(0 0, 3 3)'::geometry),\n" 763" (3, 'LINESTRING(0 1, 0 5)'::geometry),\n" 764" (4, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl2;\n" 765"\n" 766" column1 | column1 | overbelow\n" 767"---------+---------+-----------\n" 768" 1 | 2 | f\n" 769" 1 | 3 | t\n" 770" 1 | 4 | t\n" 771"(3 rows)" 772msgstr "" 773 774#. Tag: para 775#: reference_operator.xml:610 776#, no-c-format 777msgid "" 778", <xref linkend=\"ST_Geometry_Overabove\"/>, <xref linkend=" 779"\"ST_Geometry_Overright\"/>, <xref linkend=\"ST_Geometry_Overleft\"/>" 780msgstr "" 781 782#. Tag: refname 783#: reference_operator.xml:620 784#, no-c-format 785msgid "&>" 786msgstr "" 787 788#. Tag: refpurpose 789#: reference_operator.xml:622 790#, no-c-format 791msgid "" 792"Returns <varname>TRUE</varname> if A' bounding box overlaps or is to the " 793"right of B's." 794msgstr "" 795 796#. Tag: funcprototype 797#: reference_operator.xml:627 798#, no-c-format 799msgid "" 800"<funcdef>boolean <function>&></function></funcdef> <paramdef> " 801"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 802"<type>geometry </type> <parameter>B</parameter> </paramdef>" 803msgstr "" 804 805#. Tag: para 806#: reference_operator.xml:651 807#, no-c-format 808msgid "" 809"The <varname>&></varname> operator returns <varname>TRUE</varname> if " 810"the bounding box of geometry A overlaps or is to the right of the bounding " 811"box of geometry B, or more accurately, overlaps or is NOT to the left of the " 812"bounding box of geometry B." 813msgstr "" 814 815#. Tag: programlisting 816#: reference_operator.xml:662 817#, no-c-format 818msgid "" 819"SELECT tbl1.column1, tbl2.column1, tbl1.column2 &> tbl2.column2 AS " 820"overright\n" 821"FROM\n" 822" ( VALUES\n" 823" (1, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl1,\n" 824" ( VALUES\n" 825" (2, 'LINESTRING(0 0, 3 3)'::geometry),\n" 826" (3, 'LINESTRING(0 1, 0 5)'::geometry),\n" 827" (4, 'LINESTRING(6 0, 6 1)'::geometry)) AS tbl2;\n" 828"\n" 829" column1 | column1 | overright\n" 830"---------+---------+-----------\n" 831" 1 | 2 | t\n" 832" 1 | 3 | t\n" 833" 1 | 4 | f\n" 834"(3 rows)" 835msgstr "" 836 837#. Tag: para 838#: reference_operator.xml:668 839#, no-c-format 840msgid "" 841", <xref linkend=\"ST_Geometry_Overabove\"/>, <xref linkend=" 842"\"ST_Geometry_Overbelow\"/>, <xref linkend=\"ST_Geometry_Overleft\"/>" 843msgstr "" 844 845#. Tag: refname 846#: reference_operator.xml:678 847#, no-c-format 848msgid "<<" 849msgstr "" 850 851#. Tag: refpurpose 852#: reference_operator.xml:680 853#, no-c-format 854msgid "" 855"Returns <varname>TRUE</varname> if A's bounding box is strictly to the left " 856"of B's." 857msgstr "" 858 859#. Tag: funcprototype 860#: reference_operator.xml:685 861#, no-c-format 862msgid "" 863"<funcdef>boolean <function><<</function></funcdef> <paramdef> " 864"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 865"<type>geometry </type> <parameter>B</parameter> </paramdef>" 866msgstr "" 867 868#. Tag: para 869#: reference_operator.xml:709 870#, no-c-format 871msgid "" 872"The <varname><<</varname> operator returns <varname>TRUE</varname> if " 873"the bounding box of geometry A is strictly to the left of the bounding box " 874"of geometry B." 875msgstr "" 876 877#. Tag: programlisting 878#: reference_operator.xml:719 879#, no-c-format 880msgid "" 881"SELECT tbl1.column1, tbl2.column1, tbl1.column2 << tbl2.column2 AS " 882"left\n" 883"FROM\n" 884" ( VALUES\n" 885" (1, 'LINESTRING (1 2, 1 5)'::geometry)) AS tbl1,\n" 886" ( VALUES\n" 887" (2, 'LINESTRING (0 0, 4 3)'::geometry),\n" 888" (3, 'LINESTRING (6 0, 6 5)'::geometry),\n" 889" (4, 'LINESTRING (2 2, 5 6)'::geometry)) AS tbl2;\n" 890"\n" 891" column1 | column1 | left\n" 892"---------+---------+------\n" 893" 1 | 2 | f\n" 894" 1 | 3 | t\n" 895" 1 | 4 | t\n" 896"(3 rows)" 897msgstr "" 898 899#. Tag: para 900#: reference_operator.xml:725 reference_operator.xml:920 901#, no-c-format 902msgid "" 903", <xref linkend=\"ST_Geometry_Above\"/>, <xref linkend=\"ST_Geometry_Below\"/" 904">" 905msgstr "" 906 907#. Tag: refname 908#: reference_operator.xml:731 909#, no-c-format 910msgid "<<|" 911msgstr "" 912 913#. Tag: refpurpose 914#: reference_operator.xml:733 915#, no-c-format 916msgid "" 917"Returns <varname>TRUE</varname> if A's bounding box is strictly below B's." 918msgstr "" 919 920#. Tag: funcprototype 921#: reference_operator.xml:738 922#, no-c-format 923msgid "" 924"<funcdef>boolean <function><<|</function></funcdef> <paramdef> " 925"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 926"<type>geometry </type> <parameter>B</parameter> </paramdef>" 927msgstr "" 928 929#. Tag: para 930#: reference_operator.xml:762 931#, no-c-format 932msgid "" 933"The <varname><<|</varname> operator returns <varname>TRUE</varname> if " 934"the bounding box of geometry A is strictly below the bounding box of " 935"geometry B." 936msgstr "" 937 938#. Tag: programlisting 939#: reference_operator.xml:772 940#, no-c-format 941msgid "" 942"SELECT tbl1.column1, tbl2.column1, tbl1.column2 <<| tbl2.column2 AS " 943"below\n" 944"FROM\n" 945" ( VALUES\n" 946" (1, 'LINESTRING (0 0, 4 3)'::geometry)) AS tbl1,\n" 947" ( VALUES\n" 948" (2, 'LINESTRING (1 4, 1 7)'::geometry),\n" 949" (3, 'LINESTRING (6 1, 6 5)'::geometry),\n" 950" (4, 'LINESTRING (2 3, 5 6)'::geometry)) AS tbl2;\n" 951"\n" 952" column1 | column1 | below\n" 953"---------+---------+-------\n" 954" 1 | 2 | t\n" 955" 1 | 3 | f\n" 956" 1 | 4 | f\n" 957"(3 rows)" 958msgstr "" 959 960#. Tag: para 961#: reference_operator.xml:778 962#, no-c-format 963msgid "" 964", <xref linkend=\"ST_Geometry_Right\"/>, <xref linkend=\"ST_Geometry_Above\"/" 965">" 966msgstr "" 967 968#. Tag: refname 969#: reference_operator.xml:784 970#, no-c-format 971msgid "=" 972msgstr "" 973 974#. Tag: refpurpose 975#: reference_operator.xml:786 976#, no-c-format 977msgid "" 978"Returns <varname>TRUE</varname> if the coordinates and coordinate order " 979"geometry/geography A are the same as the coordinates and coordinate order of " 980"geometry/geography B." 981msgstr "" 982 983#. Tag: funcsynopsis 984#: reference_operator.xml:791 985#, no-c-format 986msgid "" 987"<funcprototype> <funcdef>boolean <function>=</function></funcdef> " 988"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 989"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef> </" 990"funcprototype> <funcprototype> <funcdef>boolean <function>=</function></" 991"funcdef> <paramdef> <type>geography </type> <parameter>A</parameter> </" 992"paramdef> <paramdef> <type>geography </type> <parameter>B</parameter> </" 993"paramdef> </funcprototype>" 994msgstr "" 995 996#. Tag: para 997#: reference_operator.xml:832 998#, no-c-format 999msgid "" 1000"The <varname>=</varname> operator returns <varname>TRUE</varname> if the " 1001"coordinates and coordinate order geometry/geography A are the same as the " 1002"coordinates and coordinate order of geometry/geography B. PostgreSQL uses " 1003"the =, <, and > operators defined for geometries to perform internal " 1004"orderings and comparison of geometries (ie. in a GROUP BY or ORDER BY " 1005"clause)." 1006msgstr "" 1007 1008#. Tag: para 1009#: reference_operator.xml:837 1010#, no-c-format 1011msgid "" 1012"Only geometry/geography that are exactly equal in all respects, with the " 1013"same coordinates, in the same order, are considered equal by this operator. " 1014"For \"spatial equality\", that ignores things like coordinate order, and can " 1015"detect features that cover the same spatial area with different " 1016"representations, use <xref linkend=\"ST_OrderingEquals\"/> or <xref linkend=" 1017"\"ST_Equals\"/>" 1018msgstr "" 1019 1020#. Tag: para 1021#: reference_operator.xml:846 1022#, no-c-format 1023msgid "" 1024"This operand will NOT make use of any indexes that may be available on the " 1025"geometries. For an index assisted exact equality test, combine = with " 1026"&&." 1027msgstr "" 1028 1029#. Tag: para 1030#: reference_operator.xml:850 1031#, no-c-format 1032msgid "" 1033"Changed: 2.4.0, in prior versions this was bounding box equality not a " 1034"geometric equality. If you need bounding box equality, use <xref linkend=" 1035"\"ST_Geometry_Same\"/> instead." 1036msgstr "" 1037 1038#. Tag: programlisting 1039#: reference_operator.xml:860 1040#, no-c-format 1041msgid "" 1042"SELECT 'LINESTRING(0 0, 0 1, 1 0)'::geometry = 'LINESTRING(1 1, 0 0)'::" 1043"geometry;\n" 1044" ?column?\n" 1045"----------\n" 1046" f\n" 1047"(1 row)\n" 1048"\n" 1049"SELECT ST_AsText(column1)\n" 1050"FROM ( VALUES\n" 1051" ('LINESTRING(0 0, 1 1)'::geometry),\n" 1052" ('LINESTRING(1 1, 0 0)'::geometry)) AS foo;\n" 1053" st_astext\n" 1054"---------------------\n" 1055" LINESTRING(0 0,1 1)\n" 1056" LINESTRING(1 1,0 0)\n" 1057"(2 rows)\n" 1058"\n" 1059"-- Note: the GROUP BY uses the \"=\" to compare for geometry equivalency.\n" 1060"SELECT ST_AsText(column1)\n" 1061"FROM ( VALUES\n" 1062" ('LINESTRING(0 0, 1 1)'::geometry),\n" 1063" ('LINESTRING(1 1, 0 0)'::geometry)) AS foo\n" 1064"GROUP BY column1;\n" 1065" st_astext\n" 1066"---------------------\n" 1067" LINESTRING(0 0,1 1)\n" 1068" LINESTRING(1 1,0 0)\n" 1069"(2 rows)\n" 1070"\n" 1071"-- In versions prior to 2.0, this used to return true --\n" 1072" SELECT ST_GeomFromText('POINT(1707296.37 4820536.77)') =\n" 1073" ST_GeomFromText('POINT(1707296.27 4820536.87)') As pt_intersect;\n" 1074"\n" 1075"--pt_intersect --\n" 1076"f" 1077msgstr "" 1078 1079#. Tag: para 1080#: reference_operator.xml:866 1081#, no-c-format 1082msgid "" 1083", <xref linkend=\"ST_OrderingEquals\"/>, <xref linkend=\"ST_Geometry_Same\"/>" 1084msgstr "" 1085 1086#. Tag: refname 1087#: reference_operator.xml:873 1088#, no-c-format 1089msgid ">>" 1090msgstr "" 1091 1092#. Tag: refpurpose 1093#: reference_operator.xml:875 1094#, no-c-format 1095msgid "" 1096"Returns <varname>TRUE</varname> if A's bounding box is strictly to the right " 1097"of B's." 1098msgstr "" 1099 1100#. Tag: funcprototype 1101#: reference_operator.xml:880 1102#, no-c-format 1103msgid "" 1104"<funcdef>boolean <function>>></function></funcdef> <paramdef> " 1105"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1106"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1107msgstr "" 1108 1109#. Tag: para 1110#: reference_operator.xml:904 1111#, no-c-format 1112msgid "" 1113"The <varname>>></varname> operator returns <varname>TRUE</varname> if " 1114"the bounding box of geometry A is strictly to the right of the bounding box " 1115"of geometry B." 1116msgstr "" 1117 1118#. Tag: programlisting 1119#: reference_operator.xml:914 1120#, no-c-format 1121msgid "" 1122"SELECT tbl1.column1, tbl2.column1, tbl1.column2 >> tbl2.column2 AS " 1123"right\n" 1124"FROM\n" 1125" ( VALUES\n" 1126" (1, 'LINESTRING (2 3, 5 6)'::geometry)) AS tbl1,\n" 1127" ( VALUES\n" 1128" (2, 'LINESTRING (1 4, 1 7)'::geometry),\n" 1129" (3, 'LINESTRING (6 1, 6 5)'::geometry),\n" 1130" (4, 'LINESTRING (0 0, 4 3)'::geometry)) AS tbl2;\n" 1131"\n" 1132" column1 | column1 | right\n" 1133"---------+---------+-------\n" 1134" 1 | 2 | t\n" 1135" 1 | 3 | f\n" 1136" 1 | 4 | f\n" 1137"(3 rows)" 1138msgstr "" 1139 1140#. Tag: refname 1141#: reference_operator.xml:926 1142#, no-c-format 1143msgid "<refname>@</refname>" 1144msgstr "" 1145 1146#. Tag: refpurpose 1147#: reference_operator.xml:928 1148#, no-c-format 1149msgid "" 1150"Returns <varname>TRUE</varname> if A's bounding box is contained by B's." 1151msgstr "" 1152 1153#. Tag: funcprototype 1154#: reference_operator.xml:933 1155#, no-c-format 1156msgid "" 1157"<funcdef>boolean <function>@</function></funcdef> <paramdef> <type>geometry " 1158"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </" 1159"type> <parameter>B</parameter> </paramdef>" 1160msgstr "" 1161 1162#. Tag: para 1163#: reference_operator.xml:957 1164#, no-c-format 1165msgid "" 1166"The <varname>@</varname> operator returns <varname>TRUE</varname> if the " 1167"bounding box of geometry A is completely contained by the bounding box of " 1168"geometry B." 1169msgstr "" 1170 1171#. Tag: programlisting 1172#: reference_operator.xml:969 1173#, no-c-format 1174msgid "" 1175"SELECT tbl1.column1, tbl2.column1, tbl1.column2 @ tbl2.column2 AS contained\n" 1176"FROM\n" 1177" ( VALUES\n" 1178" (1, 'LINESTRING (1 1, 3 3)'::geometry)) AS tbl1,\n" 1179" ( VALUES\n" 1180" (2, 'LINESTRING (0 0, 4 4)'::geometry),\n" 1181" (3, 'LINESTRING (2 2, 4 4)'::geometry),\n" 1182" (4, 'LINESTRING (1 1, 3 3)'::geometry)) AS tbl2;\n" 1183"\n" 1184" column1 | column1 | contained\n" 1185"---------+---------+-----------\n" 1186" 1 | 2 | t\n" 1187" 1 | 3 | f\n" 1188" 1 | 4 | t\n" 1189"(3 rows)" 1190msgstr "" 1191 1192#. Tag: para 1193#: reference_operator.xml:975 reference_operator.xml:1322 1194#, no-c-format 1195msgid ", <xref linkend=\"geometry_overlaps\"/>" 1196msgstr "" 1197 1198#. Tag: refname 1199#: reference_operator.xml:981 1200#, no-c-format 1201msgid "@(geometry,box2df)" 1202msgstr "" 1203 1204#. Tag: refpurpose 1205#: reference_operator.xml:983 1206#, no-c-format 1207msgid "" 1208"Returns <varname>TRUE</varname> if a geometry's 2D bounding box is contained " 1209"into a 2D float precision bounding box (BOX2DF)." 1210msgstr "" 1211 1212#. Tag: funcprototype 1213#: reference_operator.xml:988 1214#, no-c-format 1215msgid "" 1216"<funcdef>boolean <function>@</function></funcdef> <paramdef> <type>geometry " 1217"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>box2df </type> " 1218"<parameter>B</parameter> </paramdef>" 1219msgstr "" 1220 1221#. Tag: para 1222#: reference_operator.xml:1009 1223#, no-c-format 1224msgid "" 1225"The <varname>@</varname> operator returns <varname>TRUE</varname> if the A " 1226"geometry's 2D bounding box is contained the 2D bounding box B, using float " 1227"precision. This means that if B is a (double precision) box2d, it will be " 1228"internally converted to a float precision 2D bounding box (BOX2DF)" 1229msgstr "" 1230 1231#. Tag: programlisting 1232#: reference_operator.xml:1022 1233#, no-c-format 1234msgid "" 1235"SELECT ST_Buffer(ST_GeomFromText('POINT(2 2)'), 1) @ " 1236"ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(5,5)) AS is_contained;\n" 1237"\n" 1238" is_contained\n" 1239"--------------\n" 1240" t\n" 1241"(1 row)" 1242msgstr "" 1243 1244#. Tag: para 1245#: reference_operator.xml:1028 1246#, no-c-format 1247msgid "" 1248", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 1249"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 1250"<xref linkend=\"contains_box2df_geometry\"/>, <xref linkend=" 1251"\"contains_box2df_box2df\"/>, <xref linkend=\"is_contained_box2df_geometry\"/" 1252">, <xref linkend=\"is_contained_box2df_box2df\"/>" 1253msgstr "" 1254 1255#. Tag: refname 1256#: reference_operator.xml:1042 1257#, no-c-format 1258msgid "@(box2df,geometry)" 1259msgstr "" 1260 1261#. Tag: refpurpose 1262#: reference_operator.xml:1044 1263#, no-c-format 1264msgid "" 1265"Returns <varname>TRUE</varname> if a 2D float precision bounding box " 1266"(BOX2DF) is contained into a geometry's 2D bounding box." 1267msgstr "" 1268 1269#. Tag: funcprototype 1270#: reference_operator.xml:1049 1271#, no-c-format 1272msgid "" 1273"<funcdef>boolean <function>@</function></funcdef> <paramdef> <type>box2df </" 1274"type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </type> " 1275"<parameter>B</parameter> </paramdef>" 1276msgstr "" 1277 1278#. Tag: para 1279#: reference_operator.xml:1070 1280#, no-c-format 1281msgid "" 1282"The <varname>@</varname> operator returns <varname>TRUE</varname> if the 2D " 1283"bounding box A is contained into the B geometry's 2D bounding box, using " 1284"float precision. This means that if B is a (double precision) box2d, it will " 1285"be internally converted to a float precision 2D bounding box (BOX2DF)" 1286msgstr "" 1287 1288#. Tag: programlisting 1289#: reference_operator.xml:1083 1290#, no-c-format 1291msgid "" 1292"SELECT ST_MakeBox2D(ST_MakePoint(2,2), ST_MakePoint(3,3)) @ " 1293"ST_Buffer(ST_GeomFromText('POINT(1 1)'), 10) AS is_contained;\n" 1294"\n" 1295" is_contained\n" 1296"--------------\n" 1297" t\n" 1298"(1 row)" 1299msgstr "" 1300 1301#. Tag: para 1302#: reference_operator.xml:1089 1303#, no-c-format 1304msgid "" 1305", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 1306"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 1307"<xref linkend=\"contains_box2df_geometry\"/>, <xref linkend=" 1308"\"contains_box2df_box2df\"/>, <xref linkend=\"is_contained_geometry_box2df\"/" 1309">, <xref linkend=\"is_contained_box2df_box2df\"/>" 1310msgstr "" 1311 1312#. Tag: refname 1313#: reference_operator.xml:1103 1314#, no-c-format 1315msgid "@(box2df,box2df)" 1316msgstr "" 1317 1318#. Tag: refpurpose 1319#: reference_operator.xml:1105 1320#, no-c-format 1321msgid "" 1322"Returns <varname>TRUE</varname> if a 2D float precision bounding box " 1323"(BOX2DF) is contained into another 2D float precision bounding box." 1324msgstr "" 1325 1326#. Tag: funcprototype 1327#: reference_operator.xml:1110 1328#, no-c-format 1329msgid "" 1330"<funcdef>boolean <function>@</function></funcdef> <paramdef> <type>box2df </" 1331"type> <parameter>A</parameter> </paramdef> <paramdef> <type>box2df </type> " 1332"<parameter>B</parameter> </paramdef>" 1333msgstr "" 1334 1335#. Tag: para 1336#: reference_operator.xml:1131 1337#, no-c-format 1338msgid "" 1339"The <varname>@</varname> operator returns <varname>TRUE</varname> if the 2D " 1340"bounding box A is contained into the 2D bounding box B, using float " 1341"precision. This means that if A (or B) is a (double precision) box2d, it " 1342"will be internally converted to a float precision 2D bounding box (BOX2DF)" 1343msgstr "" 1344 1345#. Tag: programlisting 1346#: reference_operator.xml:1144 1347#, no-c-format 1348msgid "" 1349"SELECT ST_MakeBox2D(ST_MakePoint(2,2), ST_MakePoint(3,3)) @ " 1350"ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(5,5)) AS is_contained;\n" 1351"\n" 1352" is_contained\n" 1353"--------------\n" 1354" t\n" 1355"(1 row)" 1356msgstr "" 1357 1358#. Tag: para 1359#: reference_operator.xml:1150 1360#, no-c-format 1361msgid "" 1362", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 1363"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 1364"<xref linkend=\"contains_box2df_geometry\"/>, <xref linkend=" 1365"\"contains_box2df_box2df\"/>, <xref linkend=\"is_contained_geometry_box2df\"/" 1366">, <xref linkend=\"is_contained_box2df_geometry\"/>" 1367msgstr "" 1368 1369#. Tag: refname 1370#: reference_operator.xml:1164 1371#, no-c-format 1372msgid "|&>" 1373msgstr "" 1374 1375#. Tag: refpurpose 1376#: reference_operator.xml:1166 1377#, no-c-format 1378msgid "" 1379"Returns <varname>TRUE</varname> if A's bounding box overlaps or is above B's." 1380msgstr "" 1381 1382#. Tag: funcprototype 1383#: reference_operator.xml:1171 1384#, no-c-format 1385msgid "" 1386"<funcdef>boolean <function>|&></function></funcdef> <paramdef> " 1387"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1388"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1389msgstr "" 1390 1391#. Tag: para 1392#: reference_operator.xml:1195 1393#, no-c-format 1394msgid "" 1395"The <varname>|&></varname> operator returns <varname>TRUE</varname> " 1396"if the bounding box of geometry A overlaps or is above the bounding box of " 1397"geometry B, or more accurately, overlaps or is NOT below the bounding box of " 1398"geometry B." 1399msgstr "" 1400 1401#. Tag: programlisting 1402#: reference_operator.xml:1206 1403#, no-c-format 1404msgid "" 1405"SELECT tbl1.column1, tbl2.column1, tbl1.column2 |&> tbl2.column2 AS " 1406"overabove\n" 1407"FROM\n" 1408" ( VALUES\n" 1409" (1, 'LINESTRING(6 0, 6 4)'::geometry)) AS tbl1,\n" 1410" ( VALUES\n" 1411" (2, 'LINESTRING(0 0, 3 3)'::geometry),\n" 1412" (3, 'LINESTRING(0 1, 0 5)'::geometry),\n" 1413" (4, 'LINESTRING(1 2, 4 6)'::geometry)) AS tbl2;\n" 1414"\n" 1415" column1 | column1 | overabove\n" 1416"---------+---------+-----------\n" 1417" 1 | 2 | t\n" 1418" 1 | 3 | f\n" 1419" 1 | 4 | f\n" 1420"(3 rows)" 1421msgstr "" 1422 1423#. Tag: para 1424#: reference_operator.xml:1212 1425#, no-c-format 1426msgid "" 1427", <xref linkend=\"ST_Geometry_Overright\"/>, <xref linkend=" 1428"\"ST_Geometry_Overbelow\"/>, <xref linkend=\"ST_Geometry_Overleft\"/>" 1429msgstr "" 1430 1431#. Tag: refname 1432#: reference_operator.xml:1222 1433#, no-c-format 1434msgid "|>>" 1435msgstr "" 1436 1437#. Tag: refpurpose 1438#: reference_operator.xml:1224 1439#, no-c-format 1440msgid "" 1441"Returns <varname>TRUE</varname> if A's bounding box is strictly above B's." 1442msgstr "" 1443 1444#. Tag: funcprototype 1445#: reference_operator.xml:1229 1446#, no-c-format 1447msgid "" 1448"<funcdef>boolean <function>|>></function></funcdef> <paramdef> " 1449"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 1450"<type>geometry </type> <parameter>B</parameter> </paramdef>" 1451msgstr "" 1452 1453#. Tag: para 1454#: reference_operator.xml:1253 1455#, no-c-format 1456msgid "" 1457"The <varname>|>></varname> operator returns <varname>TRUE</varname> if " 1458"the bounding box of geometry A is strictly above the bounding box of " 1459"geometry B." 1460msgstr "" 1461 1462#. Tag: programlisting 1463#: reference_operator.xml:1263 1464#, no-c-format 1465msgid "" 1466"SELECT tbl1.column1, tbl2.column1, tbl1.column2 |>> tbl2.column2 AS " 1467"above\n" 1468"FROM\n" 1469" ( VALUES\n" 1470" (1, 'LINESTRING (1 4, 1 7)'::geometry)) AS tbl1,\n" 1471" ( VALUES\n" 1472" (2, 'LINESTRING (0 0, 4 2)'::geometry),\n" 1473" (3, 'LINESTRING (6 1, 6 5)'::geometry),\n" 1474" (4, 'LINESTRING (2 3, 5 6)'::geometry)) AS tbl2;\n" 1475"\n" 1476" column1 | column1 | above\n" 1477"---------+---------+-------\n" 1478" 1 | 2 | t\n" 1479" 1 | 3 | f\n" 1480" 1 | 4 | f\n" 1481"(3 rows)" 1482msgstr "" 1483 1484#. Tag: para 1485#: reference_operator.xml:1269 1486#, no-c-format 1487msgid "" 1488", <xref linkend=\"ST_Geometry_Right\"/>, <xref linkend=\"ST_Geometry_Below\"/" 1489">" 1490msgstr "" 1491 1492#. Tag: refname 1493#: reference_operator.xml:1275 1494#, no-c-format 1495msgid "<refname>~</refname>" 1496msgstr "" 1497 1498#. Tag: refpurpose 1499#: reference_operator.xml:1277 1500#, no-c-format 1501msgid "Returns <varname>TRUE</varname> if A's bounding box contains B's." 1502msgstr "" 1503 1504#. Tag: funcprototype 1505#: reference_operator.xml:1282 1506#, no-c-format 1507msgid "" 1508"<funcdef>boolean <function>~</function></funcdef> <paramdef> <type>geometry " 1509"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </" 1510"type> <parameter>B</parameter> </paramdef>" 1511msgstr "" 1512 1513#. Tag: para 1514#: reference_operator.xml:1306 1515#, no-c-format 1516msgid "" 1517"The <varname>~</varname> operator returns <varname>TRUE</varname> if the " 1518"bounding box of geometry A completely contains the bounding box of geometry " 1519"B." 1520msgstr "" 1521 1522#. Tag: programlisting 1523#: reference_operator.xml:1316 1524#, no-c-format 1525msgid "" 1526"SELECT tbl1.column1, tbl2.column1, tbl1.column2 ~ tbl2.column2 AS contains\n" 1527"FROM\n" 1528" ( VALUES\n" 1529" (1, 'LINESTRING (0 0, 3 3)'::geometry)) AS tbl1,\n" 1530" ( VALUES\n" 1531" (2, 'LINESTRING (0 0, 4 4)'::geometry),\n" 1532" (3, 'LINESTRING (1 1, 2 2)'::geometry),\n" 1533" (4, 'LINESTRING (0 0, 3 3)'::geometry)) AS tbl2;\n" 1534"\n" 1535" column1 | column1 | contains\n" 1536"---------+---------+----------\n" 1537" 1 | 2 | f\n" 1538" 1 | 3 | t\n" 1539" 1 | 4 | t\n" 1540"(3 rows)" 1541msgstr "" 1542 1543#. Tag: refname 1544#: reference_operator.xml:1328 1545#, no-c-format 1546msgid "~(geometry,box2df)" 1547msgstr "" 1548 1549#. Tag: refpurpose 1550#: reference_operator.xml:1330 1551#, no-c-format 1552msgid "" 1553"Returns <varname>TRUE</varname> if a geometry's 2D bonding box contains a 2D " 1554"float precision bounding box (GIDX)." 1555msgstr "" 1556 1557#. Tag: funcprototype 1558#: reference_operator.xml:1335 1559#, no-c-format 1560msgid "" 1561"<funcdef>boolean <function>~</function></funcdef> <paramdef> <type>geometry " 1562"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>box2df </type> " 1563"<parameter>B</parameter> </paramdef>" 1564msgstr "" 1565 1566#. Tag: para 1567#: reference_operator.xml:1356 1568#, no-c-format 1569msgid "" 1570"The <varname>~</varname> operator returns <varname>TRUE</varname> if the 2D " 1571"bounding box of a geometry A contains the 2D bounding box B, using float " 1572"precision. This means that if B is a (double precision) box2d, it will be " 1573"internally converted to a float precision 2D bounding box (BOX2DF)" 1574msgstr "" 1575 1576#. Tag: programlisting 1577#: reference_operator.xml:1369 1578#, no-c-format 1579msgid "" 1580"SELECT ST_Buffer(ST_GeomFromText('POINT(1 1)'), 10) ~ " 1581"ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(2,2)) AS contains;\n" 1582"\n" 1583" contains\n" 1584"----------\n" 1585" t\n" 1586"(1 row)" 1587msgstr "" 1588 1589#. Tag: para 1590#: reference_operator.xml:1375 1591#, no-c-format 1592msgid "" 1593", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 1594"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_box2df_geometry\"/>, " 1595"<xref linkend=\"contains_box2df_box2df\"/>, <xref linkend=" 1596"\"is_contained_geometry_box2df\"/>, <xref linkend=" 1597"\"is_contained_box2df_geometry\"/>, <xref linkend=" 1598"\"is_contained_box2df_box2df\"/>" 1599msgstr "" 1600 1601#. Tag: refname 1602#: reference_operator.xml:1389 1603#, no-c-format 1604msgid "~(box2df,geometry)" 1605msgstr "" 1606 1607#. Tag: refpurpose 1608#: reference_operator.xml:1391 1609#, no-c-format 1610msgid "" 1611"Returns <varname>TRUE</varname> if a 2D float precision bounding box " 1612"(BOX2DF) contains a geometry's 2D bonding box." 1613msgstr "" 1614 1615#. Tag: funcprototype 1616#: reference_operator.xml:1396 1617#, no-c-format 1618msgid "" 1619"<funcdef>boolean <function>~</function></funcdef> <paramdef> <type>box2df </" 1620"type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </type> " 1621"<parameter>B</parameter> </paramdef>" 1622msgstr "" 1623 1624#. Tag: para 1625#: reference_operator.xml:1417 1626#, no-c-format 1627msgid "" 1628"The <varname>~</varname> operator returns <varname>TRUE</varname> if the 2D " 1629"bounding box A contains the B geometry's bounding box, using float " 1630"precision. This means that if A is a (double precision) box2d, it will be " 1631"internally converted to a float precision 2D bounding box (BOX2DF)" 1632msgstr "" 1633 1634#. Tag: programlisting 1635#: reference_operator.xml:1430 1636#, no-c-format 1637msgid "" 1638"SELECT ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(5,5)) ~ " 1639"ST_Buffer(ST_GeomFromText('POINT(2 2)'), 1) AS contains;\n" 1640"\n" 1641" contains\n" 1642"----------\n" 1643" t\n" 1644"(1 row)" 1645msgstr "" 1646 1647#. Tag: para 1648#: reference_operator.xml:1436 1649#, no-c-format 1650msgid "" 1651", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 1652"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 1653"<xref linkend=\"contains_box2df_box2df\"/>, <xref linkend=" 1654"\"is_contained_geometry_box2df\"/>, <xref linkend=" 1655"\"is_contained_box2df_geometry\"/>, <xref linkend=" 1656"\"is_contained_box2df_box2df\"/>" 1657msgstr "" 1658 1659#. Tag: refname 1660#: reference_operator.xml:1450 1661#, no-c-format 1662msgid "~(box2df,box2df)" 1663msgstr "" 1664 1665#. Tag: refpurpose 1666#: reference_operator.xml:1452 1667#, no-c-format 1668msgid "" 1669"Returns <varname>TRUE</varname> if a 2D float precision bounding box " 1670"(BOX2DF) contains another 2D float precision bounding box (BOX2DF)." 1671msgstr "" 1672 1673#. Tag: funcprototype 1674#: reference_operator.xml:1457 1675#, no-c-format 1676msgid "" 1677"<funcdef>boolean <function>~</function></funcdef> <paramdef> <type>box2df </" 1678"type> <parameter>A</parameter> </paramdef> <paramdef> <type>box2df </type> " 1679"<parameter>B</parameter> </paramdef>" 1680msgstr "" 1681 1682#. Tag: para 1683#: reference_operator.xml:1478 1684#, no-c-format 1685msgid "" 1686"The <varname>~</varname> operator returns <varname>TRUE</varname> if the 2D " 1687"bounding box A contains the 2D bounding box B, using float precision. This " 1688"means that if A is a (double precision) box2d, it will be internally " 1689"converted to a float precision 2D bounding box (BOX2DF)" 1690msgstr "" 1691 1692#. Tag: programlisting 1693#: reference_operator.xml:1491 1694#, no-c-format 1695msgid "" 1696"SELECT ST_MakeBox2D(ST_MakePoint(0,0), ST_MakePoint(5,5)) ~ " 1697"ST_MakeBox2D(ST_MakePoint(2,2), ST_MakePoint(3,3)) AS contains;\n" 1698"\n" 1699" contains\n" 1700"----------\n" 1701" t\n" 1702"(1 row)" 1703msgstr "" 1704 1705#. Tag: para 1706#: reference_operator.xml:1497 1707#, no-c-format 1708msgid "" 1709", <xref linkend=\"overlaps_box2df_geometry\"/>, <xref linkend=" 1710"\"overlaps_box2df_box2df\"/>, <xref linkend=\"contains_geometry_box2df\"/>, " 1711"<xref linkend=\"contains_box2df_geometry\"/>, <xref linkend=" 1712"\"is_contained_geometry_box2df\"/>, <xref linkend=" 1713"\"is_contained_box2df_geometry\"/>, <xref linkend=" 1714"\"is_contained_box2df_box2df\"/>" 1715msgstr "" 1716 1717#. Tag: refname 1718#: reference_operator.xml:1511 1719#, no-c-format 1720msgid "<refname>~=</refname>" 1721msgstr "" 1722 1723#. Tag: refpurpose 1724#: reference_operator.xml:1513 1725#, no-c-format 1726msgid "Returns <varname>TRUE</varname> if A's bounding box is the same as B's." 1727msgstr "" 1728 1729#. Tag: funcprototype 1730#: reference_operator.xml:1518 1731#, no-c-format 1732msgid "" 1733"<funcdef>boolean <function>~=</function></funcdef> <paramdef> <type>geometry " 1734"</type> <parameter>A</parameter> </paramdef> <paramdef> <type>geometry </" 1735"type> <parameter>B</parameter> </paramdef>" 1736msgstr "" 1737 1738#. Tag: para 1739#: reference_operator.xml:1542 1740#, no-c-format 1741msgid "" 1742"The <varname>~=</varname> operator returns <varname>TRUE</varname> if the " 1743"bounding box of geometry/geography A is the same as the bounding box of " 1744"geometry/geography B." 1745msgstr "" 1746 1747#. Tag: para 1748#: reference_operator.xml:1548 1749#, no-c-format 1750msgid "Availability: 1.5.0 changed behavior" 1751msgstr "" 1752 1753#. Tag: para 1754#: reference_operator.xml:1552 1755#, no-c-format 1756msgid "" 1757"This operator has changed behavior in PostGIS 1.5 from testing for actual " 1758"geometric equality to only checking for bounding box equality. To complicate " 1759"things it also depends on if you have done a hard or soft upgrade which " 1760"behavior your database has. To find out which behavior your database has you " 1761"can run the query below. To check for true equality use <xref linkend=" 1762"\"ST_OrderingEquals\"/> or <xref linkend=\"ST_Equals\"/>." 1763msgstr "" 1764 1765#. Tag: programlisting 1766#: reference_operator.xml:1565 1767#, no-c-format 1768msgid "" 1769"select 'LINESTRING(0 0, 1 1)'::geometry ~= 'LINESTRING(0 1, 1 0)'::geometry " 1770"as equality;\n" 1771" equality |\n" 1772"-----------------+\n" 1773" t |" 1774msgstr "" 1775 1776#. Tag: para 1777#: reference_operator.xml:1569 1778#, no-c-format 1779msgid "" 1780", <xref linkend=\"ST_OrderingEquals\"/>, <xref linkend=\"ST_Geometry_EQ\"/>" 1781msgstr "" 1782 1783#. Tag: refname 1784#: reference_operator.xml:1575 1785#, no-c-format 1786msgid "<->" 1787msgstr "" 1788 1789#. Tag: refpurpose 1790#: reference_operator.xml:1577 1791#, no-c-format 1792msgid "Returns the 2D distance between A and B." 1793msgstr "" 1794 1795#. Tag: funcsynopsis 1796#: reference_operator.xml:1583 1797#, no-c-format 1798msgid "" 1799"<funcprototype> <funcdef>double precision <function><-></function></" 1800"funcdef> <paramdef> <type>geometry </type> <parameter>A</parameter> </" 1801"paramdef> <paramdef> <type>geometry </type> <parameter>B</parameter> </" 1802"paramdef> </funcprototype> <funcprototype> <funcdef>double precision " 1803"<function><-></function></funcdef> <paramdef> <type>geography </type> " 1804"<parameter>A</parameter> </paramdef> <paramdef> <type>geography </type> " 1805"<parameter>B</parameter> </paramdef> </funcprototype>" 1806msgstr "" 1807 1808#. Tag: para 1809#: reference_operator.xml:1621 1810#, no-c-format 1811msgid "" 1812"The <varname><-></varname> operator returns the 2D distance between " 1813"two geometries. Used in the \"ORDER BY\" clause provides index-assisted " 1814"nearest-neighbor result sets. For PostgreSQL below 9.5 only gives centroid " 1815"distance of bounding boxes and for PostgreSQL 9.5+, does true KNN distance " 1816"search giving true distance between geometries, and distance sphere for " 1817"geographies." 1818msgstr "" 1819 1820#. Tag: para 1821#: reference_operator.xml:1630 1822#, no-c-format 1823msgid "" 1824"This operand will make use of 2D GiST indexes that may be available on the " 1825"geometries. It is different from other operators that use spatial indexes in " 1826"that the spatial index is only used when the operator is in the ORDER BY " 1827"clause." 1828msgstr "" 1829 1830#. Tag: para 1831#: reference_operator.xml:1631 reference_operator.xml:1824 1832#, no-c-format 1833msgid "" 1834"Index only kicks in if one of the geometries is a constant (not in a " 1835"subquery/cte). e.g. 'SRID=3005;POINT(1011102 450541)'::geometry instead of a." 1836"geom" 1837msgstr "" 1838 1839#. Tag: para 1840#: reference_operator.xml:1632 1841#, no-c-format 1842msgid "" 1843"Refer to <ulink url=\"http://workshops.opengeo.org/postgis-intro/knn.html" 1844"\">OpenGeo workshop: Nearest-Neighbour Searching</ulink> for real live " 1845"example." 1846msgstr "" 1847 1848#. Tag: para 1849#: reference_operator.xml:1634 1850#, no-c-format 1851msgid "" 1852"Enhanced: 2.2.0 -- True KNN (\"K nearest neighbor\") behavior for geometry " 1853"and geography for PostgreSQL 9.5+. Note for geography KNN is based on sphere " 1854"rather than spheroid. For PostgreSQL 9.4 and below, geography support is new " 1855"but only supports centroid box." 1856msgstr "" 1857 1858#. Tag: para 1859#: reference_operator.xml:1635 1860#, no-c-format 1861msgid "" 1862"Changed: 2.2.0 -- For PostgreSQL 9.5 users, old Hybrid syntax may be slower, " 1863"so you'll want to get rid of that hack if you are running your code only on " 1864"PostGIS 2.2+ 9.5+. See examples below." 1865msgstr "" 1866 1867#. Tag: para 1868#: reference_operator.xml:1636 1869#, no-c-format 1870msgid "" 1871"Availability: 2.0.0 -- Weak KNN provides nearest neighbors based on geometry " 1872"centroid distances instead of true distances. Exact results for points, " 1873"inexact for all other types. Available for PostgreSQL 9.1+" 1874msgstr "" 1875 1876#. Tag: programlisting 1877#: reference_operator.xml:1643 1878#, no-c-format 1879msgid "" 1880"<![CDATA[SELECT ST_Distance(geom, 'SRID=3005;POINT(1011102 450541)'::" 1881"geometry) as d,edabbr, vaabbr\n" 1882"FROM va2005\n" 1883"ORDER BY d limit 10;]]>\n" 1884"\n" 1885" d | edabbr | vaabbr\n" 1886"------------------+--------+--------\n" 1887" 0 | ALQ | 128\n" 1888" 5541.57712511724 | ALQ | 129A\n" 1889" 5579.67450712005 | ALQ | 001\n" 1890" 6083.4207708641 | ALQ | 131\n" 1891" 7691.2205404848 | ALQ | 003\n" 1892" 7900.75451037313 | ALQ | 122\n" 1893" 8694.20710669982 | ALQ | 129B\n" 1894" 9564.24289057111 | ALQ | 130\n" 1895" 12089.665931705 | ALQ | 127\n" 1896" 18472.5531479404 | ALQ | 002\n" 1897"(10 rows)" 1898msgstr "" 1899 1900#. Tag: para 1901#: reference_operator.xml:1644 1902#, no-c-format 1903msgid "Then the KNN raw answer:" 1904msgstr "" 1905 1906#. Tag: programlisting 1907#: reference_operator.xml:1647 1908#, no-c-format 1909msgid "" 1910"<![CDATA[SELECT st_distance(geom, 'SRID=3005;POINT(1011102 450541)'::" 1911"geometry) as d,edabbr, vaabbr\n" 1912"FROM va2005\n" 1913"ORDER BY geom <-> 'SRID=3005;POINT(1011102 450541)'::geometry limit 10;]]>\n" 1914"\n" 1915" d | edabbr | vaabbr\n" 1916"------------------+--------+--------\n" 1917" 0 | ALQ | 128\n" 1918" 5541.57712511724 | ALQ | 129A\n" 1919" 5579.67450712005 | ALQ | 001\n" 1920" 6083.4207708641 | ALQ | 131\n" 1921" 7691.2205404848 | ALQ | 003\n" 1922" 7900.75451037313 | ALQ | 122\n" 1923" 8694.20710669982 | ALQ | 129B\n" 1924" 9564.24289057111 | ALQ | 130\n" 1925" 12089.665931705 | ALQ | 127\n" 1926" 18472.5531479404 | ALQ | 002\n" 1927"(10 rows)" 1928msgstr "" 1929 1930#. Tag: para 1931#: reference_operator.xml:1648 1932#, no-c-format 1933msgid "" 1934"If you run \"EXPLAIN ANALYZE\" on the two queries you would see a " 1935"performance improvement for the second." 1936msgstr "" 1937 1938#. Tag: para 1939#: reference_operator.xml:1652 1940#, no-c-format 1941msgid "" 1942"For users running with PostgreSQL < 9.5, use a hybrid query to find the " 1943"true nearest neighbors. First a CTE query using the index-assisted KNN, then " 1944"an exact query to get correct ordering:" 1945msgstr "" 1946 1947#. Tag: programlisting 1948#: reference_operator.xml:1655 1949#, no-c-format 1950msgid "" 1951"<![CDATA[WITH index_query AS (\n" 1952" SELECT ST_Distance(geom, 'SRID=3005;POINT(1011102 450541)'::geometry) as d," 1953"edabbr, vaabbr\n" 1954" FROM va2005\n" 1955" ORDER BY geom <-> 'SRID=3005;POINT(1011102 450541)'::geometry LIMIT 100)\n" 1956" SELECT *\n" 1957" FROM index_query\n" 1958" ORDER BY d limit 10;]]>\n" 1959"\n" 1960" d | edabbr | vaabbr\n" 1961"------------------+--------+--------\n" 1962" 0 | ALQ | 128\n" 1963" 5541.57712511724 | ALQ | 129A\n" 1964" 5579.67450712005 | ALQ | 001\n" 1965" 6083.4207708641 | ALQ | 131\n" 1966" 7691.2205404848 | ALQ | 003\n" 1967" 7900.75451037313 | ALQ | 122\n" 1968" 8694.20710669982 | ALQ | 129B\n" 1969" 9564.24289057111 | ALQ | 130\n" 1970" 12089.665931705 | ALQ | 127\n" 1971" 18472.5531479404 | ALQ | 002\n" 1972"(10 rows)" 1973msgstr "" 1974 1975#. Tag: para 1976#: reference_operator.xml:1659 1977#, no-c-format 1978msgid "" 1979", <xref linkend=\"ST_Distance\"/>, <xref linkend=\"geometry_distance_box\"/>" 1980msgstr "" 1981 1982#. Tag: refname 1983#: reference_operator.xml:1665 1984#, no-c-format 1985msgid "<refname>|=|</refname>" 1986msgstr "" 1987 1988#. Tag: refpurpose 1989#: reference_operator.xml:1667 1990#, no-c-format 1991msgid "" 1992"Returns the distance between A and B trajectories at their closest point of " 1993"approach." 1994msgstr "" 1995 1996#. Tag: funcprototype 1997#: reference_operator.xml:1674 1998#, no-c-format 1999msgid "" 2000"<funcdef>double precision <function>|=|</function></funcdef> <paramdef> " 2001"<type>geometry </type> <parameter>A</parameter> </paramdef> <paramdef> " 2002"<type>geometry </type> <parameter>B</parameter> </paramdef>" 2003msgstr "" 2004 2005#. Tag: para 2006#: reference_operator.xml:1696 2007#, no-c-format 2008msgid "" 2009"The <varname>|=|</varname> operator returns the 3D distance between two " 2010"trajectories (See <xref linkend=\"ST_IsValidTrajectory\"/>). This is the " 2011"same as <xref linkend=\"ST_DistanceCPA\"/> but as an operator it can be used " 2012"for doing nearest neightbor searches using an N-dimensional index (requires " 2013"PostgreSQL 9.5.0 or higher)." 2014msgstr "" 2015 2016#. Tag: para 2017#: reference_operator.xml:1704 2018#, no-c-format 2019msgid "" 2020"This operand will make use of ND GiST indexes that may be available on the " 2021"geometries. It is different from other operators that use spatial indexes in " 2022"that the spatial index is only used when the operator is in the ORDER BY " 2023"clause." 2024msgstr "" 2025 2026#. Tag: para 2027#: reference_operator.xml:1705 2028#, no-c-format 2029msgid "" 2030"Index only kicks in if one of the geometries is a constant (not in a " 2031"subquery/cte). e.g. 'SRID=3005;LINESTRINGM(0 0 0,0 0 1)'::geometry instead " 2032"of a.geom" 2033msgstr "" 2034 2035#. Tag: para 2036#: reference_operator.xml:1707 2037#, no-c-format 2038msgid "Availability: 2.2.0. Index-supported only available for PostgreSQL 9.5+" 2039msgstr "" 2040 2041#. Tag: programlisting 2042#: reference_operator.xml:1713 2043#, no-c-format 2044msgid "" 2045"-- Save a literal query trajectory in a psql variable...\n" 2046"\\set qt 'ST_AddMeasure(ST_MakeLine(ST_MakePointM(-350,300,0)," 2047"ST_MakePointM(-410,490,0)),10,20)'\n" 2048"-- Run the query !\n" 2049"SELECT track_id, dist FROM (\n" 2050" SELECT track_id, ST_DistanceCPA(tr,:qt) dist\n" 2051" FROM trajectories\n" 2052" ORDER BY tr |=| :qt\n" 2053" LIMIT 5\n" 2054") foo;\n" 2055" track_id dist\n" 2056"----------+-------------------\n" 2057" 395 | 0.576496831518066\n" 2058" 380 | 5.06797130410151\n" 2059" 390 | 7.72262293958322\n" 2060" 385 | 9.8004461358071\n" 2061" 405 | 10.9534397988433\n" 2062"(5 rows)" 2063msgstr "" 2064 2065#. Tag: para 2066#: reference_operator.xml:1717 2067#, no-c-format 2068msgid "" 2069", <xref linkend=\"ST_ClosestPointOfApproach\"/>, <xref linkend=" 2070"\"ST_IsValidTrajectory\"/>" 2071msgstr "" 2072 2073#. Tag: refname 2074#: reference_operator.xml:1727 2075#, no-c-format 2076msgid "<#>" 2077msgstr "" 2078 2079#. Tag: refpurpose 2080#: reference_operator.xml:1729 2081#, no-c-format 2082msgid "Returns the 2D distance between A and B bounding boxes." 2083msgstr "" 2084 2085#. Tag: funcprototype 2086#: reference_operator.xml:1736 2087#, no-c-format 2088msgid "" 2089"<funcdef>double precision <function><#></function></funcdef> " 2090"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 2091"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef>" 2092msgstr "" 2093 2094#. Tag: para 2095#: reference_operator.xml:1757 2096#, no-c-format 2097msgid "" 2098"The <varname><#></varname> operator returns distance between two " 2099"floating point bounding boxes, possibly reading them from a spatial index " 2100"(PostgreSQL 9.1+ required). Useful for doing nearest neighbor <emphasis role=" 2101"\"strong\">approximate</emphasis> distance ordering." 2102msgstr "" 2103 2104#. Tag: para 2105#: reference_operator.xml:1759 reference_operator.xml:1878 2106#, no-c-format 2107msgid "" 2108"This operand will make use of any indexes that may be available on the " 2109"geometries. It is different from other operators that use spatial indexes in " 2110"that the spatial index is only used when the operator is in the ORDER BY " 2111"clause." 2112msgstr "" 2113 2114#. Tag: para 2115#: reference_operator.xml:1762 2116#, no-c-format 2117msgid "" 2118"Index only kicks in if one of the geometries is a constant e.g. ORDER BY " 2119"(ST_GeomFromText('POINT(1 2)') <#> geom) instead of g1.geom <#>." 2120msgstr "" 2121 2122#. Tag: para 2123#: reference_operator.xml:1764 2124#, no-c-format 2125msgid "Availability: 2.0.0 -- KNN only available for PostgreSQL 9.1+" 2126msgstr "" 2127 2128#. Tag: programlisting 2129#: reference_operator.xml:1770 2130#, no-c-format 2131msgid "" 2132"<![CDATA[SELECT *\n" 2133"FROM (\n" 2134"SELECT b.tlid, b.mtfcc,\n" 2135" b.geom <#> ST_GeomFromText('LINESTRING(746149 2948672,745954 " 2136"2948576,\n" 2137" 745787 2948499,745740 2948468,745712 2948438,\n" 2138" 745690 2948384,745677 2948319)',2249) As b_dist,\n" 2139" ST_Distance(b.geom, ST_GeomFromText('LINESTRING(746149 " 2140"2948672,745954 2948576,\n" 2141" 745787 2948499,745740 2948468,745712 2948438,\n" 2142" 745690 2948384,745677 2948319)',2249)) As act_dist\n" 2143" FROM bos_roads As b\n" 2144" ORDER BY b_dist, b.tlid\n" 2145" LIMIT 100) As foo\n" 2146" ORDER BY act_dist, tlid LIMIT 10;]]>\n" 2147"\n" 2148" tlid | mtfcc | b_dist | act_dist\n" 2149"-----------+-------+------------------+------------------\n" 2150" 85732027 | S1400 | 0 | 0\n" 2151" 85732029 | S1400 | 0 | 0\n" 2152" 85732031 | S1400 | 0 | 0\n" 2153" 85734335 | S1400 | 0 | 0\n" 2154" 85736037 | S1400 | 0 | 0\n" 2155" 624683742 | S1400 | 0 | 128.528874268666\n" 2156" 85719343 | S1400 | 260.839270432962 | 260.839270432962\n" 2157" 85741826 | S1400 | 164.759294123275 | 260.839270432962\n" 2158" 85732032 | S1400 | 277.75 | 311.830282365264\n" 2159" 85735592 | S1400 | 222.25 | 311.830282365264\n" 2160"(10 rows)" 2161msgstr "" 2162 2163#. Tag: para 2164#: reference_operator.xml:1774 2165#, no-c-format 2166msgid "" 2167", <xref linkend=\"ST_Distance\"/>, <xref linkend=\"geometry_distance_knn\"/>" 2168msgstr "" 2169 2170#. Tag: refname 2171#: reference_operator.xml:1780 2172#, no-c-format 2173msgid "<<->>" 2174msgstr "" 2175 2176#. Tag: refpurpose 2177#: reference_operator.xml:1782 2178#, no-c-format 2179msgid "" 2180"Returns the n-D distance between the centroids of A and B bounding boxes." 2181msgstr "" 2182 2183#. Tag: funcprototype 2184#: reference_operator.xml:1790 2185#, no-c-format 2186msgid "" 2187"<funcdef>double precision <function><<->></function></funcdef> " 2188"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 2189"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef>" 2190msgstr "" 2191 2192#. Tag: para 2193#: reference_operator.xml:1811 2194#, no-c-format 2195msgid "" 2196"The <varname><<->></varname> operator returns the n-D " 2197"(euclidean) distance between the centroids of the bounding boxes of two " 2198"geometries. Useful for doing nearest neighbor <emphasis role=\"strong" 2199"\">approximate</emphasis> distance ordering." 2200msgstr "" 2201 2202#. Tag: para 2203#: reference_operator.xml:1818 2204#, no-c-format 2205msgid "" 2206"This operand will make use of n-D GiST indexes that may be available on the " 2207"geometries. It is different from other operators that use spatial indexes in " 2208"that the spatial index is only used when the operator is in the ORDER BY " 2209"clause." 2210msgstr "" 2211 2212#. Tag: para 2213#: reference_operator.xml:1830 reference_operator.xml:1887 2214#, no-c-format 2215msgid "Availability: 2.2.0 -- KNN only available for PostgreSQL 9.1+" 2216msgstr "" 2217 2218#. Tag: para 2219#: reference_operator.xml:1837 2220#, no-c-format 2221msgid ", <xref linkend=\"geometry_distance_knn\"/>" 2222msgstr "" 2223 2224#. Tag: refname 2225#: reference_operator.xml:1846 2226#, no-c-format 2227msgid "<<#>>" 2228msgstr "" 2229 2230#. Tag: refpurpose 2231#: reference_operator.xml:1848 2232#, no-c-format 2233msgid "Returns the n-D distance between A and B bounding boxes." 2234msgstr "" 2235 2236#. Tag: funcprototype 2237#: reference_operator.xml:1855 2238#, no-c-format 2239msgid "" 2240"<funcdef>double precision <function><<#>></function></funcdef> " 2241"<paramdef> <type>geometry </type> <parameter>A</parameter> </paramdef> " 2242"<paramdef> <type>geometry </type> <parameter>B</parameter> </paramdef>" 2243msgstr "" 2244 2245#. Tag: para 2246#: reference_operator.xml:1876 2247#, no-c-format 2248msgid "" 2249"The <varname><<#>></varname> operator returns distance between " 2250"two floating point bounding boxes, possibly reading them from a spatial " 2251"index (PostgreSQL 9.1+ required). Useful for doing nearest neighbor " 2252"<emphasis role=\"strong\">approximate</emphasis> distance ordering." 2253msgstr "" 2254 2255#. Tag: para 2256#: reference_operator.xml:1881 2257#, no-c-format 2258msgid "" 2259"Index only kicks in if one of the geometries is a constant e.g. ORDER BY " 2260"(ST_GeomFromText('POINT(1 2)') <<#>> geom) instead of g1.geom " 2261"<<#>>." 2262msgstr "" 2263 2264#. Tag: para 2265#: reference_operator.xml:1893 2266#, no-c-format 2267msgid ", <xref linkend=\"geometry_distance_box\"/>" 2268msgstr "" 2269