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