1# SOME DESCRIPTIVE TITLE. 2# 3# Translators: 4# Arnaud Vandecasteele <arnaud.sig@gmail.com>, 2014 5# Jacolin <yjacolin@free.fr>, 2013-2014 6# max g. <max@mapsnapps.com>, 2014 7# Nicolas Ribot <nicolas.ribot@gmail.com>, 2013 8# Vincent Picavet <vincent.ml@oslandia.com>, 2013 9# Vincent Picavet <vincent.ml@oslandia.com>, 2013,2016 10# Vincent Picavet <vincent.ml@oslandia.com>, 2013 11msgid "" 12msgstr "" 13"Project-Id-Version: PostGIS\n" 14"Report-Msgid-Bugs-To: https://bugs.kde.org\n" 15"POT-Creation-Date: 2020-12-15 04:51+0000\n" 16"PO-Revision-Date: 2018-07-23 18:00+0000\n" 17"Last-Translator: Vincent Picavet <vincent.ml@oslandia.com>\n" 18"Language-Team: French (http://www.transifex.com/postgis/postgis/language/" 19"fr/)\n" 20"Language: fr\n" 21"MIME-Version: 1.0\n" 22"Content-Type: text/plain; charset=UTF-8\n" 23"Content-Transfer-Encoding: 8bit\n" 24"Plural-Forms: nplurals=2; plural=(n > 1);\n" 25 26#. Tag: title 27#: reference_accessor.xml:4 28#, no-c-format 29msgid "Geometry Accessors" 30msgstr "Fonctions d'accès aux géométries" 31 32#. Tag: refname 33#: reference_accessor.xml:8 34#, no-c-format 35msgid "GeometryType" 36msgstr "GeometryType" 37 38#. Tag: refpurpose 39#: reference_accessor.xml:10 40#, fuzzy, no-c-format 41msgid "Returns the type of a geometry as text." 42msgstr "Renvoie le type de la géométrie passée en paramètre." 43 44#. Tag: funcprototype 45#: reference_accessor.xml:15 46#, no-c-format 47msgid "" 48"<funcdef>text <function>GeometryType</function></funcdef> " 49"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 50msgstr "" 51"<funcdef>text <function>GeometryType</function></funcdef> " 52"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 53 54#. Tag: title 55#: reference_accessor.xml:23 reference_accessor.xml:79 56#: reference_accessor.xml:160 reference_accessor.xml:207 57#: reference_accessor.xml:252 reference_accessor.xml:310 58#: reference_accessor.xml:379 reference_accessor.xml:425 59#: reference_accessor.xml:475 reference_accessor.xml:536 60#: reference_accessor.xml:606 reference_accessor.xml:653 61#: reference_accessor.xml:714 reference_accessor.xml:760 62#: reference_accessor.xml:802 reference_accessor.xml:866 63#: reference_accessor.xml:936 reference_accessor.xml:999 64#: reference_accessor.xml:1056 reference_accessor.xml:1111 65#: reference_accessor.xml:1154 reference_accessor.xml:1204 66#: reference_accessor.xml:1252 reference_accessor.xml:1298 67#: reference_accessor.xml:1341 reference_accessor.xml:1376 68#: reference_accessor.xml:1415 reference_accessor.xml:1454 69#: reference_accessor.xml:1497 reference_accessor.xml:1558 70#: reference_accessor.xml:1598 reference_accessor.xml:1640 71#: reference_accessor.xml:1697 reference_accessor.xml:1761 72#: reference_accessor.xml:1812 reference_accessor.xml:1864 73#: reference_accessor.xml:1937 reference_accessor.xml:1981 74#: reference_accessor.xml:2026 reference_accessor.xml:2070 75#, no-c-format 76msgid "Description" 77msgstr "Description" 78 79#. Tag: para 80#: reference_accessor.xml:25 81#, fuzzy, no-c-format 82msgid "" 83"Returns the type of the geometry as a string. Eg: 'LINESTRING', 'POLYGON', " 84"'MULTIPOINT', etc." 85msgstr "" 86"<para>Retourne le type de la géométrie, par exemple: 'LINESTRING', " 87"'POLYGON', 'MULTIPOINT', etc.</para>" 88 89#. Tag: para 90#: reference_accessor.xml:28 91#, no-c-format 92msgid "" 93"OGC SPEC s2.1.1.1 - Returns the name of the instantiable subtype of Geometry " 94"of which this Geometry instance is a member. The name of the instantiable " 95"subtype of Geometry is returned as a string." 96msgstr "" 97"OGC SPEC s2.1.1.1 - Retourne le nom du sous type instanciable de la " 98"géométrie. Le nom est retourné sous forme de texte." 99 100#. Tag: para 101#: reference_accessor.xml:34 102#, no-c-format 103msgid "" 104"This function also indicates if the geometry is measured, by returning a " 105"string of the form 'POINTM'." 106msgstr "" 107"Cette fonction indique si la géométrie comporte une dimension de type " 108"mesure, en retournant un texte de de la forme 'POINTM'." 109 110#. Tag: para 111#: reference_accessor.xml:37 reference_accessor.xml:266 112#: reference_accessor.xml:326 reference_accessor.xml:667 113#: reference_accessor.xml:1459 114#, no-c-format 115msgid "" 116"Enhanced: 2.0.0 support for Polyhedral surfaces, Triangles and TIN was " 117"introduced." 118msgstr "" 119"Amélioration: 2.0.0 introduction du support TIN, Triangles et surfaces " 120"polyhédriques. " 121 122#. Tag: para 123#: reference_accessor.xml:38 reference_accessor.xml:166 124#: reference_accessor.xml:669 reference_accessor.xml:813 125#: reference_accessor.xml:1005 reference_accessor.xml:1261 126#: reference_accessor.xml:1565 reference_accessor.xml:1606 127#: reference_accessor.xml:1714 reference_accessor.xml:1989 128#, no-c-format 129msgid "&sfs_compliant;" 130msgstr "&sfs_compliant;" 131 132#. Tag: para 133#: reference_accessor.xml:39 reference_accessor.xml:168 134#: reference_accessor.xml:273 reference_accessor.xml:328 135#: reference_accessor.xml:434 reference_accessor.xml:672 136#: reference_accessor.xml:766 reference_accessor.xml:1014 137#: reference_accessor.xml:1076 reference_accessor.xml:1122 138#: reference_accessor.xml:1310 reference_accessor.xml:1382 139#: reference_accessor.xml:1420 reference_accessor.xml:1717 140#: reference_accessor.xml:1775 reference_accessor.xml:1821 141#: reference_accessor.xml:1880 reference_accessor.xml:2077 142#, no-c-format 143msgid "&curve_support;" 144msgstr "&curve_support;" 145 146#. Tag: para 147#: reference_accessor.xml:40 reference_accessor.xml:94 148#: reference_accessor.xml:169 reference_accessor.xml:276 149#: reference_accessor.xml:331 reference_accessor.xml:389 150#: reference_accessor.xml:432 reference_accessor.xml:565 151#: reference_accessor.xml:615 reference_accessor.xml:671 152#: reference_accessor.xml:720 reference_accessor.xml:765 153#: reference_accessor.xml:815 reference_accessor.xml:896 154#: reference_accessor.xml:966 reference_accessor.xml:1013 155#: reference_accessor.xml:1075 reference_accessor.xml:1218 156#: reference_accessor.xml:1263 reference_accessor.xml:1309 157#: reference_accessor.xml:1346 reference_accessor.xml:1381 158#: reference_accessor.xml:1419 reference_accessor.xml:1463 159#: reference_accessor.xml:1564 reference_accessor.xml:1658 160#: reference_accessor.xml:1716 reference_accessor.xml:1776 161#: reference_accessor.xml:1819 reference_accessor.xml:1946 162#: reference_accessor.xml:1991 reference_accessor.xml:2036 163#: reference_accessor.xml:2076 164#, no-c-format 165msgid "&Z_support;" 166msgstr "&Z_support;" 167 168#. Tag: para 169#: reference_accessor.xml:41 reference_accessor.xml:170 170#: reference_accessor.xml:220 reference_accessor.xml:274 171#: reference_accessor.xml:329 reference_accessor.xml:673 172#: reference_accessor.xml:721 reference_accessor.xml:1017 173#: reference_accessor.xml:1311 reference_accessor.xml:1383 174#: reference_accessor.xml:1464 reference_accessor.xml:1567 175#: reference_accessor.xml:1659 reference_accessor.xml:1883 176#, no-c-format 177msgid "&P_support;" 178msgstr "&P_support;" 179 180#. Tag: para 181#: reference_accessor.xml:42 reference_accessor.xml:171 182#: reference_accessor.xml:221 reference_accessor.xml:275 183#: reference_accessor.xml:330 reference_accessor.xml:674 184#: reference_accessor.xml:1312 reference_accessor.xml:1465 185#: reference_accessor.xml:1886 186#, no-c-format 187msgid "&T_support;" 188msgstr "&T_support;" 189 190#. Tag: title 191#: reference_accessor.xml:48 reference_accessor.xml:99 192#: reference_accessor.xml:176 reference_accessor.xml:225 193#: reference_accessor.xml:394 reference_accessor.xml:444 194#: reference_accessor.xml:497 reference_accessor.xml:570 195#: reference_accessor.xml:620 reference_accessor.xml:726 196#: reference_accessor.xml:771 reference_accessor.xml:821 197#: reference_accessor.xml:1081 reference_accessor.xml:1129 198#: reference_accessor.xml:1173 reference_accessor.xml:1223 199#: reference_accessor.xml:1269 reference_accessor.xml:1318 200#: reference_accessor.xml:1350 reference_accessor.xml:1388 201#: reference_accessor.xml:1425 reference_accessor.xml:1470 202#: reference_accessor.xml:1509 reference_accessor.xml:1571 203#: reference_accessor.xml:1611 reference_accessor.xml:1665 204#: reference_accessor.xml:1729 reference_accessor.xml:1783 205#: reference_accessor.xml:1831 reference_accessor.xml:1894 206#: reference_accessor.xml:1952 reference_accessor.xml:1997 207#: reference_accessor.xml:2041 reference_accessor.xml:2082 208#, no-c-format 209msgid "Examples" 210msgstr "Exemples" 211 212#. Tag: programlisting 213#: reference_accessor.xml:50 214#, no-c-format 215msgid "" 216"SELECT GeometryType(ST_GeomFromText('LINESTRING(77.29 29.07,77.42 " 217"29.26,77.27 29.31,77.29 29.07)'));\n" 218" geometrytype\n" 219"--------------\n" 220" LINESTRING" 221msgstr "" 222"SELECT GeometryType(ST_GeomFromText('LINESTRING(77.29 29.07,77.42 " 223"29.26,77.27 29.31,77.29 29.07)'));\n" 224" geometrytype\n" 225"--------------\n" 226" LINESTRING" 227 228#. Tag: programlisting 229#: reference_accessor.xml:51 230#, no-c-format 231msgid "" 232"SELECT ST_GeometryType(ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 0, 0 0 1, 0 " 233"1 1, 0 1 0, 0 0 0)),\n" 234" ((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 " 235"1, 0 0 1, 0 0 0)),\n" 236" ((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),\n" 237" ((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)), ((0 0 1, 1 0 1, 1 1 " 238"1, 0 1 1, 0 0 1)) )'));\n" 239" --result\n" 240" POLYHEDRALSURFACE" 241msgstr "" 242 243#. Tag: programlisting 244#: reference_accessor.xml:52 245#, no-c-format 246msgid "" 247"SELECT GeometryType(geom) as result\n" 248" FROM\n" 249" (SELECT\n" 250" ST_GeomFromEWKT('TIN (((\n" 251" 0 0 0,\n" 252" 0 0 1,\n" 253" 0 1 0,\n" 254" 0 0 0\n" 255" )), ((\n" 256" 0 0 0,\n" 257" 0 1 0,\n" 258" 1 1 0,\n" 259" 0 0 0\n" 260" ))\n" 261" )') AS geom\n" 262" ) AS g;\n" 263" result\n" 264"--------\n" 265" TIN" 266msgstr "" 267 268#. Tag: title 269#: reference_accessor.xml:57 reference_accessor.xml:137 270#: reference_accessor.xml:183 reference_accessor.xml:230 271#: reference_accessor.xml:289 reference_accessor.xml:357 272#: reference_accessor.xml:401 reference_accessor.xml:450 273#: reference_accessor.xml:511 reference_accessor.xml:575 274#: reference_accessor.xml:625 reference_accessor.xml:693 275#: reference_accessor.xml:737 reference_accessor.xml:778 276#: reference_accessor.xml:828 reference_accessor.xml:902 277#: reference_accessor.xml:971 reference_accessor.xml:1034 278#: reference_accessor.xml:1087 reference_accessor.xml:1179 279#: reference_accessor.xml:1229 reference_accessor.xml:1275 280#: reference_accessor.xml:1355 reference_accessor.xml:1393 281#: reference_accessor.xml:1432 reference_accessor.xml:1475 282#: reference_accessor.xml:1514 reference_accessor.xml:1536 283#: reference_accessor.xml:1576 reference_accessor.xml:1616 284#: reference_accessor.xml:1672 reference_accessor.xml:1735 285#: reference_accessor.xml:1789 reference_accessor.xml:1837 286#: reference_accessor.xml:1900 reference_accessor.xml:1958 287#: reference_accessor.xml:2003 reference_accessor.xml:2047 288#: reference_accessor.xml:2089 289#, no-c-format 290msgid "See Also" 291msgstr "Voir aussi" 292 293#. Tag: refname 294#: reference_accessor.xml:63 295#, no-c-format 296msgid "ST_Boundary" 297msgstr "ST_Boundary" 298 299#. Tag: refpurpose 300#: reference_accessor.xml:65 301#, fuzzy, no-c-format 302msgid "Returns the boundary of a geometry." 303msgstr "Renvoie l'ensemble formant la frontière finie de cette géométrie." 304 305#. Tag: funcprototype 306#: reference_accessor.xml:70 307#, no-c-format 308msgid "" 309"<funcdef>geometry <function>ST_Boundary</function></funcdef> " 310"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 311msgstr "" 312"<funcdef>geometry <function>ST_Boundary</function></funcdef> " 313"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 314 315#. Tag: para 316#: reference_accessor.xml:81 317#, no-c-format 318msgid "" 319"Returns the closure of the combinatorial boundary of this Geometry. The " 320"combinatorial boundary is defined as described in section 3.12.3.2 of the " 321"OGC SPEC. Because the result of this function is a closure, and hence " 322"topologically closed, the resulting boundary can be represented using " 323"representational geometry primitives as discussed in the OGC SPEC, section " 324"3.12.2." 325msgstr "" 326"Renvoie l'ensemble formant la frontière finie de cette géométrie. La notion " 327"de frontière est définie dans la section 3.12.3.2 des spécifications OGC. Le " 328"résultat de cette fonction est un ensemble topologiquement fermé, " 329"représentable avec les types de base, comme décrit dans la section 3.12.2 " 330"des spécifications OGC." 331 332#. Tag: para 333#: reference_accessor.xml:88 334#, no-c-format 335msgid "Performed by the GEOS module" 336msgstr "Réalisé par le module GEOS" 337 338#. Tag: para 339#: reference_accessor.xml:90 340#, no-c-format 341msgid "" 342"Prior to 2.0.0, this function throws an exception if used with " 343"<varname>GEOMETRYCOLLECTION</varname>. From 2.0.0 up it will return NULL " 344"instead (unsupported input)." 345msgstr "" 346"Avant la version 2.0.0, cette fonction renvoie une exception si une " 347"<varname>GEOMETRYCOLLECTION</varname> est passée en paramètre. A partir de " 348"la 2.0.0, la fonction renvoie null (paramètre non supporté)." 349 350#. Tag: para 351#: reference_accessor.xml:92 352#, no-c-format 353msgid "&sfs_compliant; OGC SPEC s2.1.1.1" 354msgstr "&sfs_compliant; OGC SPEC s2.1.1.1" 355 356#. Tag: para 357#: reference_accessor.xml:93 358#, no-c-format 359msgid "&sqlmm_compliant; SQL-MM 3: 5.1.14" 360msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.14" 361 362#. Tag: para 363#: reference_accessor.xml:95 364#, no-c-format 365msgid "Enhanced: 2.1.0 support for Triangle was introduced" 366msgstr "Amélioration : 2.1.0 introduction du support pour Triangle" 367 368#. Tag: para 369#: reference_accessor.xml:110 370#, no-c-format 371msgid "Linestring with boundary points overlaid" 372msgstr "" 373 374#. Tag: programlisting 375#: reference_accessor.xml:113 376#, no-c-format 377msgid "" 378"SELECT ST_Boundary(geom)\n" 379"FROM (SELECT 'LINESTRING(100 150,50 60, 70 80, 160 170)'::geometry As geom) " 380"As f;" 381msgstr "" 382"SELECT ST_Boundary(geom)\n" 383"FROM (SELECT 'LINESTRING(100 150,50 60, 70 80, 160 170)'::geometry As geom) " 384"As f;" 385 386#. Tag: screen 387#: reference_accessor.xml:114 388#, no-c-format 389msgid "" 390"-- ST_AsText output\n" 391"MULTIPOINT(100 150,160 170)" 392msgstr "" 393"-- ST_AsText output\n" 394"MULTIPOINT(100 150,160 170)" 395 396#. Tag: para 397#: reference_accessor.xml:122 398#, no-c-format 399msgid "polygon holes with boundary multilinestring" 400msgstr "" 401 402#. Tag: programlisting 403#: reference_accessor.xml:125 404#, no-c-format 405msgid "" 406"SELECT ST_Boundary(geom)\n" 407"FROM (SELECT\n" 408"'POLYGON (( 10 130, 50 190, 110 190, 140 150, 150 80, 100 10, 20 40, 10 " 409"130 ),\n" 410" ( 70 40, 100 50, 120 80, 80 110, 50 90, 70 40 ))'::geometry As geom) " 411"As f;" 412msgstr "" 413 414#. Tag: screen 415#: reference_accessor.xml:126 416#, no-c-format 417msgid "" 418"-- ST_AsText output\n" 419"MULTILINESTRING((10 130,50 190,110 190,140 150,150 80,100 10,20 40,10 130),\n" 420" (70 40,100 50,120 80,80 110,50 90,70 40))" 421msgstr "" 422 423#. Tag: programlisting 424#: reference_accessor.xml:134 425#, no-c-format 426msgid "" 427"SELECT ST_AsText(ST_Boundary(ST_GeomFromText('LINESTRING(1 1,0 0, -1 " 428"1)')));\n" 429"st_astext\n" 430"-----------\n" 431"MULTIPOINT(1 1,-1 1)\n" 432"\n" 433"SELECT ST_AsText(ST_Boundary(ST_GeomFromText('POLYGON((1 1,0 0, -1 1, 1 " 434"1))')));\n" 435"st_astext\n" 436"----------\n" 437"LINESTRING(1 1,0 0,-1 1,1 1)\n" 438"\n" 439"--Using a 3d polygon\n" 440"SELECT ST_AsEWKT(ST_Boundary(ST_GeomFromEWKT('POLYGON((1 1 1,0 0 1, -1 1 1, " 441"1 1 1))')));\n" 442"\n" 443"st_asewkt\n" 444"-----------------------------------\n" 445"LINESTRING(1 1 1,0 0 1,-1 1 1,1 1 1)\n" 446"\n" 447"--Using a 3d multilinestring\n" 448"SELECT ST_AsEWKT(ST_Boundary(ST_GeomFromEWKT('MULTILINESTRING((1 1 1,0 0 " 449"0.5, -1 1 1),(1 1 0.5,0 0 0.5, -1 1 0.5, 1 1 0.5) )')));\n" 450"\n" 451"st_asewkt\n" 452"----------\n" 453"MULTIPOINT(-1 1 1,1 1 0.75)" 454msgstr "" 455"SELECT ST_AsText(ST_Boundary(ST_GeomFromText('LINESTRING(1 1,0 0, -1 " 456"1)')));\n" 457"st_astext\n" 458"-----------\n" 459"MULTIPOINT(1 1,-1 1)\n" 460"\n" 461"SELECT ST_AsText(ST_Boundary(ST_GeomFromText('POLYGON((1 1,0 0, -1 1, 1 " 462"1))')));\n" 463"st_astext\n" 464"----------\n" 465"LINESTRING(1 1,0 0,-1 1,1 1)\n" 466"\n" 467"--Using a 3d polygon\n" 468"SELECT ST_AsEWKT(ST_Boundary(ST_GeomFromEWKT('POLYGON((1 1 1,0 0 1, -1 1 1, " 469"1 1 1))')));\n" 470"\n" 471"st_asewkt\n" 472"-----------------------------------\n" 473"LINESTRING(1 1 1,0 0 1,-1 1 1,1 1 1)\n" 474"\n" 475"--Using a 3d multilinestring\n" 476"SELECT ST_AsEWKT(ST_Boundary(ST_GeomFromEWKT('MULTILINESTRING((1 1 1,0 0 " 477"0.5, -1 1 1),(1 1 0.5,0 0 0.5, -1 1 0.5, 1 1 0.5) )')));\n" 478"\n" 479"st_asewkt\n" 480"----------\n" 481"MULTIPOINT(-1 1 1,1 1 0.75)" 482 483#. Tag: para 484#: reference_accessor.xml:139 485#, no-c-format 486msgid "" 487", <xref linkend=\"ST_ExteriorRing\"/>, <xref linkend=\"ST_MakePolygon\"/>" 488msgstr "" 489", <xref linkend=\"ST_ExteriorRing\"/>, <xref linkend=\"ST_MakePolygon\"/>" 490 491#. Tag: refname 492#: reference_accessor.xml:145 493#, no-c-format 494msgid "ST_CoordDim" 495msgstr "ST_CoordDim" 496 497#. Tag: refpurpose 498#: reference_accessor.xml:147 499#, fuzzy, no-c-format 500msgid "Return the coordinate dimension of a geometry." 501msgstr "Retourne la dimension des coordonnées d'une valeur ST_Geometry." 502 503#. Tag: funcprototype 504#: reference_accessor.xml:152 505#, no-c-format 506msgid "" 507"<funcdef>integer <function>ST_CoordDim</function></funcdef> " 508"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 509msgstr "" 510"<funcdef>integer <function>ST_CoordDim</function></funcdef> " 511"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 512 513#. Tag: para 514#: reference_accessor.xml:162 515#, fuzzy, no-c-format 516msgid "Return the coordinate dimension of the ST_Geometry value." 517msgstr "Retourne la dimension des coordonnées d'une valeur ST_Geometry." 518 519#. Tag: para 520#: reference_accessor.xml:164 521#, no-c-format 522msgid "This is the MM compliant alias name for <xref linkend=\"ST_NDims\"/>" 523msgstr "Alias SQL/MM pour la fonction <xref linkend=\"ST_NDims\"/>" 524 525#. Tag: para 526#: reference_accessor.xml:167 527#, no-c-format 528msgid "&sqlmm_compliant; SQL-MM 3: 5.1.3" 529msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.3" 530 531#. Tag: programlisting 532#: reference_accessor.xml:178 533#, no-c-format 534msgid "" 535"SELECT ST_CoordDim('CIRCULARSTRING(1 2 3, 1 3 4, 5 6 7, 8 9 10, 11 12 " 536"13)');\n" 537" ---result--\n" 538" 3\n" 539"\n" 540" SELECT ST_CoordDim(ST_Point(1,2));\n" 541" --result--\n" 542" 2" 543msgstr "" 544"SELECT ST_CoordDim('CIRCULARSTRING(1 2 3, 1 3 4, 5 6 7, 8 9 10, 11 12 " 545"13)');\n" 546" ---result--\n" 547" 3\n" 548"\n" 549" SELECT ST_CoordDim(ST_Point(1,2));\n" 550" --result--\n" 551" 2" 552 553#. Tag: refname 554#: reference_accessor.xml:191 555#, no-c-format 556msgid "ST_Dimension" 557msgstr "ST_Dimension" 558 559#. Tag: refpurpose 560#: reference_accessor.xml:193 561#, fuzzy, no-c-format 562msgid "Returns the topological dimension of a geometry." 563msgstr "Retourne la dimension des coordonnées d'une valeur ST_Geometry." 564 565#. Tag: funcprototype 566#: reference_accessor.xml:198 567#, no-c-format 568msgid "" 569"<funcdef>integer <function>ST_Dimension</function></funcdef> " 570"<paramdef><type>geometry </type> <parameter>g</parameter></paramdef>" 571msgstr "" 572"<funcdef>integer <function>ST_Dimension</function></funcdef> " 573"<paramdef><type>geometry </type> <parameter>g</parameter></paramdef>" 574 575#. Tag: para 576#: reference_accessor.xml:209 577#, fuzzy, no-c-format 578msgid "" 579"Return the topological dimension of this Geometry object, which must be less " 580"than or equal to the coordinate dimension. OGC SPEC s2.1.1.1 - returns 0 for " 581"<varname>POINT</varname>, 1 for <varname>LINESTRING</varname>, 2 for " 582"<varname>POLYGON</varname>, and the largest dimension of the components of a " 583"<varname>GEOMETRYCOLLECTION</varname>. If the dimension is unknown (e.g. for " 584"an empty <varname>GEOMETRYCOLLECTION</varname>) 0 is returned." 585msgstr "" 586"La dimension intrinsèque de l'objet Geometry, inférieure ou égale à la " 587"dimension des coordonnées. Section 2.1.1.1 des spécifications OGC. Retourne " 588"0 pour un <varname>POINT</varname>, 1 pour une <varname>LINESTRING</" 589"varname>, 2 pour un <varname>POLYGON</varname>, et la dimesion maximale des " 590"éléments d'une <varname>GEOMETRYCOLLECTION</varname>. Renvoie NULL pour les " 591"géométries vides (GEOMETRY EMPTY)." 592 593#. Tag: para 594#: reference_accessor.xml:217 595#, no-c-format 596msgid "&sqlmm_compliant; SQL-MM 3: 5.1.2" 597msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.2" 598 599#. Tag: para 600#: reference_accessor.xml:218 601#, no-c-format 602msgid "" 603"Enhanced: 2.0.0 support for Polyhedral surfaces and TINs was introduced. No " 604"longer throws an exception if given empty geometry." 605msgstr "" 606"Amélioration: 2.0.0 introduction du support TIN et surfaces polyhédriques. " 607"Ne renvoie plus une exception si une GEOMETRY EMPTY est passée. " 608 609#. Tag: para 610#: reference_accessor.xml:219 611#, no-c-format 612msgid "" 613"Prior to 2.0.0, this function throws an exception if used with empty " 614"geometry." 615msgstr "" 616"Avant la version 2.0.0, cette fonction renvoie une exception si une " 617"<varname>GEOMETRY EMPT</varname> est passée en paramètre." 618 619#. Tag: programlisting 620#: reference_accessor.xml:227 621#, no-c-format 622msgid "" 623"SELECT ST_Dimension('GEOMETRYCOLLECTION(LINESTRING(1 1,0 0),POINT(0 0))');\n" 624"ST_Dimension\n" 625"-----------\n" 626"1" 627msgstr "" 628"SELECT ST_Dimension('GEOMETRYCOLLECTION(LINESTRING(1 1,0 0),POINT(0 0))');\n" 629"ST_Dimension\n" 630"-----------\n" 631"1" 632 633#. Tag: refname 634#: reference_accessor.xml:238 635#, no-c-format 636msgid "ST_Dump" 637msgstr "" 638 639#. Tag: refpurpose 640#: reference_accessor.xml:239 641#, no-c-format 642msgid "" 643"Returns a set of <varname>geometry_dump</varname> rows for the components of " 644"a geometry." 645msgstr "" 646 647#. Tag: funcprototype 648#: reference_accessor.xml:244 649#, fuzzy, no-c-format 650msgid "" 651"<funcdef>geometry_dump[] <function>ST_Dump</function></funcdef> " 652"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 653msgstr "" 654"<funcdef>geometry <function>ST_Envelope</function></funcdef> " 655"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 656 657#. Tag: para 658#: reference_accessor.xml:253 659#, no-c-format 660msgid "" 661"This is a set-returning function (SRF). It returns a set of geometry_dump " 662"rows, formed by a geometry (geom) and an array of integers (path). When the " 663"input geometry is a simple type (POINT,LINESTRING,POLYGON) a single record " 664"will be returned with an empty path array and the input geometry as geom. " 665"When the input geometry is a collection or multi it will return a record for " 666"each of the collection components, and the path will express the position of " 667"the component inside the collection." 668msgstr "" 669 670#. Tag: para 671#: reference_accessor.xml:262 672#, no-c-format 673msgid "" 674"ST_Dump is useful for expanding geometries. It is the reverse of a GROUP BY " 675"in that it creates new rows. For example it can be use to expand " 676"MULTIPOLYGONS into POLYGONS." 677msgstr "" 678 679#. Tag: para 680#: reference_accessor.xml:267 681#, no-c-format 682msgid "Availability: PostGIS 1.0.0RC1. Requires PostgreSQL 7.3 or higher." 683msgstr "" 684 685#. Tag: para 686#: reference_accessor.xml:269 reference_accessor.xml:1380 687#, no-c-format 688msgid "" 689"Prior to 1.3.4, this function crashes if used with geometries that contain " 690"CURVES. This is fixed in 1.3.4+" 691msgstr "" 692 693#. Tag: title 694#: reference_accessor.xml:280 reference_accessor.xml:680 695#, no-c-format 696msgid "Standard Examples" 697msgstr "Exemples" 698 699#. Tag: programlisting 700#: reference_accessor.xml:281 701#, no-c-format 702msgid "" 703"SELECT sometable.field1, sometable.field1,\n" 704" (ST_Dump(sometable.the_geom)).geom AS the_geom\n" 705"FROM sometable;\n" 706"\n" 707"-- Break a compound curve into its constituent linestrings and " 708"circularstrings\n" 709"SELECT ST_AsEWKT(a.geom), ST_HasArc(a.geom)\n" 710" FROM ( SELECT (ST_Dump(p_geom)).geom AS geom\n" 711" FROM (SELECT ST_GeomFromEWKT('COMPOUNDCURVE(CIRCULARSTRING(0 0, 1 " 712"1, 1 0),(1 0, 0 1))') AS p_geom) AS b\n" 713" ) AS a;\n" 714" st_asewkt | st_hasarc\n" 715"-----------------------------+----------\n" 716" CIRCULARSTRING(0 0,1 1,1 0) | t\n" 717" LINESTRING(1 0,0 1) | f\n" 718"(2 rows)" 719msgstr "" 720 721#. Tag: title 722#: reference_accessor.xml:283 reference_accessor.xml:351 723#: reference_accessor.xml:685 724#, no-c-format 725msgid "Polyhedral Surfaces, TIN and Triangle Examples" 726msgstr "Exemples TIN, Triangle et Surfaces Polyhédriques" 727 728#. Tag: programlisting 729#: reference_accessor.xml:284 730#, no-c-format 731msgid "" 732"-- Polyhedral surface example\n" 733"-- Break a Polyhedral surface into its faces\n" 734"SELECT (a.p_geom).path[1] As path, ST_AsEWKT((a.p_geom).geom) As geom_ewkt\n" 735" FROM (SELECT ST_Dump(ST_GeomFromEWKT('POLYHEDRALSURFACE(\n" 736"((0 0 0, 0 0 1, 0 1 1, 0 1 0, 0 0 0)),\n" 737"((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0 " 738"0)), ((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),\n" 739"((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)), ((0 0 1, 1 0 1, 1 1 1, 0 1 1, 0 0 " 740"1))\n" 741")') ) AS p_geom ) AS a;\n" 742"\n" 743" path | geom_ewkt\n" 744"------+------------------------------------------\n" 745" 1 | POLYGON((0 0 0,0 0 1,0 1 1,0 1 0,0 0 0))\n" 746" 2 | POLYGON((0 0 0,0 1 0,1 1 0,1 0 0,0 0 0))\n" 747" 3 | POLYGON((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0))\n" 748" 4 | POLYGON((1 1 0,1 1 1,1 0 1,1 0 0,1 1 0))\n" 749" 5 | POLYGON((0 1 0,0 1 1,1 1 1,1 1 0,0 1 0))\n" 750" 6 | POLYGON((0 0 1,1 0 1,1 1 1,0 1 1,0 0 1))" 751msgstr "" 752 753#. Tag: programlisting 754#: reference_accessor.xml:286 755#, no-c-format 756msgid "" 757"-- TIN --\n" 758"SELECT (g.gdump).path, ST_AsEWKT((g.gdump).geom) as wkt\n" 759" FROM\n" 760" (SELECT\n" 761" ST_Dump( ST_GeomFromEWKT('TIN (((\n" 762" 0 0 0,\n" 763" 0 0 1,\n" 764" 0 1 0,\n" 765" 0 0 0\n" 766" )), ((\n" 767" 0 0 0,\n" 768" 0 1 0,\n" 769" 1 1 0,\n" 770" 0 0 0\n" 771" ))\n" 772" )') ) AS gdump\n" 773" ) AS g;\n" 774"-- result --\n" 775" path | wkt\n" 776"------+-------------------------------------\n" 777" {1} | TRIANGLE((0 0 0,0 0 1,0 1 0,0 0 0))\n" 778" {2} | TRIANGLE((0 0 0,0 1 0,1 1 0,0 0 0))" 779msgstr "" 780 781#. Tag: para 782#: reference_accessor.xml:290 783#, fuzzy, no-c-format 784msgid "" 785", <xref linkend=\"PostGIS_Geometry_DumpFunctions\"/>, <xref linkend=" 786"\"ST_Collect\"/>, <xref linkend=\"ST_Collect\"/>, <xref linkend=" 787"\"ST_GeometryN\"/>" 788msgstr "" 789", <xref linkend=\"ST_GeomFromEWKT\"/>, <xref linkend=\"ST_Dump\"/>, <xref " 790"linkend=\"ST_GeometryN\"/>, <xref linkend=\"ST_NumGeometries\"/>" 791 792#. Tag: refname 793#: reference_accessor.xml:296 794#, fuzzy, no-c-format 795msgid "ST_DumpPoints" 796msgstr "ST_NumPoints" 797 798#. Tag: refpurpose 799#: reference_accessor.xml:297 800#, no-c-format 801msgid "" 802"Returns a set of <varname>geometry_dump</varname> rows for the points in a " 803"geometry." 804msgstr "" 805 806#. Tag: funcprototype 807#: reference_accessor.xml:302 808#, fuzzy, no-c-format 809msgid "" 810"<funcdef>geometry_dump[]<function>ST_DumpPoints</function></funcdef> " 811"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 812msgstr "" 813"<funcdef>geometry <function>ST_StartPoint</function></funcdef> " 814"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 815 816#. Tag: para 817#: reference_accessor.xml:311 818#, no-c-format 819msgid "" 820"This set-returning function (SRF) returns a set of <varname>geometry_dump</" 821"varname> rows formed by a geometry (<varname>geom</varname>) and an array of " 822"integers (<varname>path</varname>)." 823msgstr "" 824 825#. Tag: para 826#: reference_accessor.xml:314 827#, no-c-format 828msgid "" 829"The <parameter>geom</parameter> component of <varname>geometry_dump</" 830"varname> are all the <varname>POINT</varname>s that make up the supplied " 831"geometry" 832msgstr "" 833 834#. Tag: para 835#: reference_accessor.xml:317 836#, no-c-format 837msgid "" 838"The <parameter>path</parameter> component of <varname>geometry_dump</" 839"varname> (an <varname>integer[]</varname>) is an index reference enumerating " 840"the <varname>POINT</varname>s of the supplied geometry. For example, if a " 841"<varname>LINESTRING</varname> is supplied, a path of <varname>{i}</varname> " 842"is returned where <varname>i</varname> is the <varname>nth</varname> " 843"coordinate in the <varname>LINESTRING</varname>. If a <varname>POLYGON</" 844"varname> is supplied, a path of <varname>{i,j}</varname> is returned where " 845"<varname>i</varname> is the ring number (1 is outer; inner rings follow) and " 846"<varname>j</varname> enumerates the <varname>POINT</varname>s (again 1-based " 847"index)." 848msgstr "" 849 850#. Tag: para 851#: reference_accessor.xml:325 852#, no-c-format 853msgid "Enhanced: 2.1.0 Faster speed. Reimplemented as native-C." 854msgstr "" 855 856#. Tag: para 857#: reference_accessor.xml:327 858#, fuzzy, no-c-format 859msgid "Availability: 1.5.0" 860msgstr "Disponibilité : 2.2.0" 861 862#. Tag: title 863#: reference_accessor.xml:334 864#, no-c-format 865msgid "Classic Explode a Table of LineStrings into nodes" 866msgstr "" 867 868#. Tag: programlisting 869#: reference_accessor.xml:335 870#, no-c-format 871msgid "" 872"SELECT edge_id, (dp).path[1] As index, ST_AsText((dp).geom) As wktnode\n" 873"FROM (SELECT 1 As edge_id\n" 874" , ST_DumpPoints(ST_GeomFromText('LINESTRING(1 2, 3 4, 10 10)')) AS " 875"dp\n" 876" UNION ALL\n" 877" SELECT 2 As edge_id\n" 878" , ST_DumpPoints(ST_GeomFromText('LINESTRING(3 5, 5 6, 9 10)')) AS " 879"dp\n" 880" ) As foo;\n" 881" edge_id | index | wktnode\n" 882"---------+-------+--------------\n" 883" 1 | 1 | POINT(1 2)\n" 884" 1 | 2 | POINT(3 4)\n" 885" 1 | 3 | POINT(10 10)\n" 886" 2 | 1 | POINT(3 5)\n" 887" 2 | 2 | POINT(5 6)\n" 888" 2 | 3 | POINT(9 10)" 889msgstr "" 890 891#. Tag: title 892#: reference_accessor.xml:338 893#, fuzzy, no-c-format 894msgid "Standard Geometry Examples" 895msgstr "Exemples" 896 897#. Tag: programlisting 898#: reference_accessor.xml:348 899#, no-c-format 900msgid "" 901"SELECT path, ST_AsText(geom)\n" 902"FROM (\n" 903" SELECT (ST_DumpPoints(g.geom)).*\n" 904" FROM\n" 905" (SELECT\n" 906" 'GEOMETRYCOLLECTION(\n" 907" POINT ( 0 1 ),\n" 908" LINESTRING ( 0 3, 3 4 ),\n" 909" POLYGON (( 2 0, 2 3, 0 2, 2 0 )),\n" 910" POLYGON (( 3 0, 3 3, 6 3, 6 0, 3 0 ),\n" 911" ( 5 1, 4 2, 5 2, 5 1 )),\n" 912" MULTIPOLYGON (\n" 913" (( 0 5, 0 8, 4 8, 4 5, 0 5 ),\n" 914" ( 1 6, 3 6, 2 7, 1 6 )),\n" 915" (( 5 4, 5 8, 6 7, 5 4 ))\n" 916" )\n" 917" )'::geometry AS geom\n" 918" ) AS g\n" 919" ) j;\n" 920"\n" 921" path | st_astext\n" 922"-----------+------------\n" 923" {1,1} | POINT(0 1)\n" 924" {2,1} | POINT(0 3)\n" 925" {2,2} | POINT(3 4)\n" 926" {3,1,1} | POINT(2 0)\n" 927" {3,1,2} | POINT(2 3)\n" 928" {3,1,3} | POINT(0 2)\n" 929" {3,1,4} | POINT(2 0)\n" 930" {4,1,1} | POINT(3 0)\n" 931" {4,1,2} | POINT(3 3)\n" 932" {4,1,3} | POINT(6 3)\n" 933" {4,1,4} | POINT(6 0)\n" 934" {4,1,5} | POINT(3 0)\n" 935" {4,2,1} | POINT(5 1)\n" 936" {4,2,2} | POINT(4 2)\n" 937" {4,2,3} | POINT(5 2)\n" 938" {4,2,4} | POINT(5 1)\n" 939" {5,1,1,1} | POINT(0 5)\n" 940" {5,1,1,2} | POINT(0 8)\n" 941" {5,1,1,3} | POINT(4 8)\n" 942" {5,1,1,4} | POINT(4 5)\n" 943" {5,1,1,5} | POINT(0 5)\n" 944" {5,1,2,1} | POINT(1 6)\n" 945" {5,1,2,2} | POINT(3 6)\n" 946" {5,1,2,3} | POINT(2 7)\n" 947" {5,1,2,4} | POINT(1 6)\n" 948" {5,2,1,1} | POINT(5 4)\n" 949" {5,2,1,2} | POINT(5 8)\n" 950" {5,2,1,3} | POINT(6 7)\n" 951" {5,2,1,4} | POINT(5 4)\n" 952"(29 rows)" 953msgstr "" 954 955#. Tag: programlisting 956#: reference_accessor.xml:352 957#, no-c-format 958msgid "" 959"-- Polyhedral surface cube --\n" 960"SELECT (g.gdump).path, ST_AsEWKT((g.gdump).geom) as wkt\n" 961" FROM\n" 962" (SELECT\n" 963" ST_DumpPoints(ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 0, 0 0 1, 0 1 " 964"1, 0 1 0, 0 0 0)),\n" 965"((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0 " 966"0)),\n" 967"((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),\n" 968"((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)), ((0 0 1, 1 0 1, 1 1 1, 0 1 1, 0 0 " 969"1)) )') ) AS gdump\n" 970" ) AS g;\n" 971"-- result --\n" 972" path | wkt\n" 973"---------+--------------\n" 974" {1,1,1} | POINT(0 0 0)\n" 975" {1,1,2} | POINT(0 0 1)\n" 976" {1,1,3} | POINT(0 1 1)\n" 977" {1,1,4} | POINT(0 1 0)\n" 978" {1,1,5} | POINT(0 0 0)\n" 979" {2,1,1} | POINT(0 0 0)\n" 980" {2,1,2} | POINT(0 1 0)\n" 981" {2,1,3} | POINT(1 1 0)\n" 982" {2,1,4} | POINT(1 0 0)\n" 983" {2,1,5} | POINT(0 0 0)\n" 984" {3,1,1} | POINT(0 0 0)\n" 985" {3,1,2} | POINT(1 0 0)\n" 986" {3,1,3} | POINT(1 0 1)\n" 987" {3,1,4} | POINT(0 0 1)\n" 988" {3,1,5} | POINT(0 0 0)\n" 989" {4,1,1} | POINT(1 1 0)\n" 990" {4,1,2} | POINT(1 1 1)\n" 991" {4,1,3} | POINT(1 0 1)\n" 992" {4,1,4} | POINT(1 0 0)\n" 993" {4,1,5} | POINT(1 1 0)\n" 994" {5,1,1} | POINT(0 1 0)\n" 995" {5,1,2} | POINT(0 1 1)\n" 996" {5,1,3} | POINT(1 1 1)\n" 997" {5,1,4} | POINT(1 1 0)\n" 998" {5,1,5} | POINT(0 1 0)\n" 999" {6,1,1} | POINT(0 0 1)\n" 1000" {6,1,2} | POINT(1 0 1)\n" 1001" {6,1,3} | POINT(1 1 1)\n" 1002" {6,1,4} | POINT(0 1 1)\n" 1003" {6,1,5} | POINT(0 0 1)\n" 1004"(30 rows)" 1005msgstr "" 1006 1007#. Tag: programlisting 1008#: reference_accessor.xml:353 1009#, no-c-format 1010msgid "" 1011"-- Triangle --\n" 1012"SELECT (g.gdump).path, ST_AsText((g.gdump).geom) as wkt\n" 1013" FROM\n" 1014" (SELECT\n" 1015" ST_DumpPoints( ST_GeomFromEWKT('TRIANGLE ((\n" 1016" 0 0,\n" 1017" 0 9,\n" 1018" 9 0,\n" 1019" 0 0\n" 1020" ))') ) AS gdump\n" 1021" ) AS g;\n" 1022"-- result --\n" 1023" path | wkt\n" 1024"------+------------\n" 1025" {1} | POINT(0 0)\n" 1026" {2} | POINT(0 9)\n" 1027" {3} | POINT(9 0)\n" 1028" {4} | POINT(0 0)" 1029msgstr "" 1030 1031#. Tag: programlisting 1032#: reference_accessor.xml:354 1033#, no-c-format 1034msgid "" 1035"-- TIN --\n" 1036"SELECT (g.gdump).path, ST_AsEWKT((g.gdump).geom) as wkt\n" 1037" FROM\n" 1038" (SELECT\n" 1039" ST_DumpPoints( ST_GeomFromEWKT('TIN (((\n" 1040" 0 0 0,\n" 1041" 0 0 1,\n" 1042" 0 1 0,\n" 1043" 0 0 0\n" 1044" )), ((\n" 1045" 0 0 0,\n" 1046" 0 1 0,\n" 1047" 1 1 0,\n" 1048" 0 0 0\n" 1049" ))\n" 1050" )') ) AS gdump\n" 1051" ) AS g;\n" 1052"-- result --\n" 1053" path | wkt\n" 1054"---------+--------------\n" 1055" {1,1,1} | POINT(0 0 0)\n" 1056" {1,1,2} | POINT(0 0 1)\n" 1057" {1,1,3} | POINT(0 1 0)\n" 1058" {1,1,4} | POINT(0 0 0)\n" 1059" {2,1,1} | POINT(0 0 0)\n" 1060" {2,1,2} | POINT(0 1 0)\n" 1061" {2,1,3} | POINT(1 1 0)\n" 1062" {2,1,4} | POINT(0 0 0)\n" 1063"(8 rows)" 1064msgstr "" 1065 1066#. Tag: para 1067#: reference_accessor.xml:358 1068#, fuzzy, no-c-format 1069msgid "" 1070", <xref linkend=\"PostGIS_Geometry_DumpFunctions\"/>, <xref linkend=\"ST_Dump" 1071"\"/>, <xref linkend=\"ST_DumpRings\"/>" 1072msgstr "" 1073", <xref linkend=\"ST_Collect\"/>, <xref linkend=\"ST_Dump\"/>, <xref linkend=" 1074"\"ST_NumInteriorRing\"/>," 1075 1076#. Tag: refname 1077#: reference_accessor.xml:363 1078#, fuzzy, no-c-format 1079msgid "ST_DumpRings" 1080msgstr "ST_NRings" 1081 1082#. Tag: refpurpose 1083#: reference_accessor.xml:365 1084#, no-c-format 1085msgid "" 1086"Returns a set of <varname>geometry_dump</varname> rows for the exterior and " 1087"interior rings of a Polygon." 1088msgstr "" 1089 1090#. Tag: funcprototype 1091#: reference_accessor.xml:371 1092#, fuzzy, no-c-format 1093msgid "" 1094"<funcdef>geometry_dump[] <function>ST_DumpRings</function></funcdef> " 1095"<paramdef><type>geometry </type> <parameter>a_polygon</parameter></paramdef>" 1096msgstr "" 1097"<funcdef>geometry <function>ST_ExteriorRing</function></funcdef> " 1098"<paramdef><type>geometry </type> <parameter>a_polygon</parameter></paramdef>" 1099 1100#. Tag: para 1101#: reference_accessor.xml:381 1102#, no-c-format 1103msgid "" 1104"This is a set-returning function (SRF). It returns a set of " 1105"<varname>geometry_dump</varname> rows, defined as an <varname>integer[]</" 1106"varname> and a <varname>geometry</varname>, aliased \"path\" and \"geom\" " 1107"respectively. The \"path\" field holds the polygon ring index containing a " 1108"single integer: 0 for the shell, >0 for holes. The \"geom\" field contains " 1109"the corresponding ring as a polygon." 1110msgstr "" 1111 1112#. Tag: para 1113#: reference_accessor.xml:387 1114#, no-c-format 1115msgid "Availability: PostGIS 1.1.3. Requires PostgreSQL 7.3 or higher." 1116msgstr "" 1117 1118#. Tag: para 1119#: reference_accessor.xml:388 1120#, fuzzy, no-c-format 1121msgid "" 1122"This only works for POLYGON geometries. It will not work for MULTIPOLYGONS" 1123msgstr "" 1124"Ne support pas les MULTIPOLYGON. Utiliser en association avec ST_Dump pour " 1125"les MULTIPOLYGON" 1126 1127#. Tag: programlisting 1128#: reference_accessor.xml:396 1129#, no-c-format 1130msgid "" 1131"SELECT sometable.field1, sometable.field1,\n" 1132" (ST_DumpRings(sometable.the_geom)).geom As the_geom\n" 1133"FROM sometableOfpolys;\n" 1134"\n" 1135"SELECT ST_AsEWKT(geom) As the_geom, path\n" 1136" FROM ST_DumpRings(\n" 1137" ST_GeomFromEWKT('POLYGON((-8149064 5133092 1,-8149064 " 1138"5132986 1,-8148996 5132839 1,-8148972 5132767 1,-8148958 5132508 1,-8148941 " 1139"5132466 1,-8148924 5132394 1,\n" 1140" -8148903 5132210 1,-8148930 5131967 1,-8148992 5131978 " 1141"1,-8149237 5132093 1,-8149404 5132211 1,-8149647 5132310 1,-8149757 5132394 " 1142"1,\n" 1143" -8150305 5132788 1,-8149064 5133092 1),\n" 1144" (-8149362 5132394 1,-8149446 5132501 1,-8149548 5132597 " 1145"1,-8149695 5132675 1,-8149362 5132394 1))')\n" 1146" ) as foo;\n" 1147" path | the_geom\n" 1148"----------------------------------------------------------------------------------------------------------------\n" 1149" {0} | POLYGON((-8149064 5133092 1,-8149064 5132986 1,-8148996 5132839 " 1150"1,-8148972 5132767 1,-8148958 5132508 1,\n" 1151" | -8148941 5132466 1,-8148924 5132394 1,\n" 1152" | -8148903 5132210 1,-8148930 5131967 1,\n" 1153" | -8148992 5131978 1,-8149237 5132093 1,\n" 1154" | -8149404 5132211 1,-8149647 5132310 1,-8149757 5132394 " 1155"1,-8150305 5132788 1,-8149064 5133092 1))\n" 1156" {1} | POLYGON((-8149362 5132394 1,-8149446 5132501 1,\n" 1157" | -8149548 5132597 1,-8149695 5132675 1,-8149362 5132394 " 1158"1))" 1159msgstr "" 1160 1161#. Tag: para 1162#: reference_accessor.xml:403 1163#, fuzzy, no-c-format 1164msgid "" 1165", <xref linkend=\"PostGIS_Geometry_DumpFunctions\"/>, <xref linkend=\"ST_Dump" 1166"\"/>, <xref linkend=\"ST_ExteriorRing\"/>, <xref linkend=\"ST_InteriorRingN" 1167"\"/>" 1168msgstr "" 1169", <xref linkend=\"ST_GeomFromEWKT\"/>, <xref linkend=\"ST_Dump\"/>, <xref " 1170"linkend=\"ST_GeometryN\"/>, <xref linkend=\"ST_NumGeometries\"/>" 1171 1172#. Tag: refname 1173#: reference_accessor.xml:409 1174#, no-c-format 1175msgid "ST_EndPoint" 1176msgstr "ST_EndPoint" 1177 1178#. Tag: refpurpose 1179#: reference_accessor.xml:411 1180#, fuzzy, no-c-format 1181msgid "Returns the last point of a LineString or CircularLineString." 1182msgstr "" 1183"Retourne le nombre de points d'un objet géométrique dans une valeur " 1184"ST_LineString ou ST_CircularString." 1185 1186#. Tag: funcprototype 1187#: reference_accessor.xml:416 1188#, fuzzy, no-c-format 1189msgid "" 1190"<funcdef>geometry <function>ST_EndPoint</function></funcdef> " 1191"<paramdef><type>geometry </type> <parameter>g</parameter></paramdef>" 1192msgstr "" 1193"<funcdef>geometry <function>ST_Envelope</function></funcdef> " 1194"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 1195 1196#. Tag: para 1197#: reference_accessor.xml:427 1198#, fuzzy, no-c-format 1199msgid "" 1200"Returns the last point of a LINESTRING as a POINT. Returns <varname>NULL</" 1201"varname> if the input is not a LINESTRING." 1202msgstr "" 1203"Retourne le dernier point d'une <varname>LINESTRING</varname> sous la forme " 1204"d'un <varname>POINT</varname>, ou NULL si le paramètre n'est pas une " 1205"<varname>LINESTRING</varname>." 1206 1207#. Tag: para 1208#: reference_accessor.xml:431 1209#, no-c-format 1210msgid "&sqlmm_compliant; SQL-MM 3: 7.1.4" 1211msgstr "&sqlmm_compliant; SQL-MM 3: 7.1.4" 1212 1213#. Tag: para 1214#: reference_accessor.xml:435 reference_accessor.xml:1822 1215#, no-c-format 1216msgid "" 1217"Changed: 2.0.0 no longer works with single geometry multilinestrings. In " 1218"older versions of PostGIS -- a single line multilinestring would work " 1219"happily with this function and return the start point. In 2.0.0 it just " 1220"returns NULL like any other multilinestring. The older behavior was an " 1221"undocumented feature, but people who assumed they had their data stored as " 1222"LINESTRING may experience these returning NULL in 2.0 now." 1223msgstr "" 1224"Changement: 2.0.0: ne supporte plus les géométries multilinestring avec un " 1225"seul élément. Dans les anciennes version de PostGIS, une multilinestring ne " 1226"contenant qu'une ligne renvoyait le point d'origine de la ligne. A partir de " 1227"la version 2.0.0, la fonction renvoie NULL comme avec toute autre " 1228"multilinestring. L'ancien comportement n'était pas documenté. Le nouveau " 1229"comportement peut renvoyer null si l'on considère que la table contient des " 1230"LINESTRING (multilinestring avec un seul élément) " 1231 1232#. Tag: programlisting 1233#: reference_accessor.xml:446 1234#, no-c-format 1235msgid "" 1236"postgis=# SELECT ST_AsText(ST_EndPoint('LINESTRING(1 1, 2 2, 3 3)'::" 1237"geometry));\n" 1238" st_astext\n" 1239"------------\n" 1240" POINT(3 3)\n" 1241"(1 row)\n" 1242"\n" 1243"postgis=# SELECT ST_EndPoint('POINT(1 1)'::geometry) IS NULL AS is_null;\n" 1244" is_null\n" 1245"----------\n" 1246" t\n" 1247"(1 row)\n" 1248"\n" 1249"--3d endpoint\n" 1250"SELECT ST_AsEWKT(ST_EndPoint('LINESTRING(1 1 2, 1 2 3, 0 0 5)'));\n" 1251" st_asewkt\n" 1252"--------------\n" 1253" POINT(0 0 5)\n" 1254"(1 row)" 1255msgstr "" 1256"postgis=# SELECT ST_AsText(ST_EndPoint('LINESTRING(1 1, 2 2, 3 3)'::" 1257"geometry));\n" 1258" st_astext\n" 1259"------------\n" 1260" POINT(3 3)\n" 1261"(1 row)\n" 1262"\n" 1263"postgis=# SELECT ST_EndPoint('POINT(1 1)'::geometry) IS NULL AS is_null;\n" 1264" is_null\n" 1265"----------\n" 1266" t\n" 1267"(1 row)\n" 1268"\n" 1269"--3d endpoint\n" 1270"SELECT ST_AsEWKT(ST_EndPoint('LINESTRING(1 1 2, 1 2 3, 0 0 5)'));\n" 1271" st_asewkt\n" 1272"--------------\n" 1273" POINT(0 0 5)\n" 1274"(1 row)" 1275 1276#. Tag: para 1277#: reference_accessor.xml:452 1278#, no-c-format 1279msgid ", <xref linkend=\"ST_StartPoint\"/>" 1280msgstr ", <xref linkend=\"ST_StartPoint\"/>" 1281 1282#. Tag: refname 1283#: reference_accessor.xml:459 1284#, no-c-format 1285msgid "ST_Envelope" 1286msgstr "ST_Envelope" 1287 1288#. Tag: refpurpose 1289#: reference_accessor.xml:461 1290#, fuzzy, no-c-format 1291msgid "Returns a geometry representing the bounding box of a geometry." 1292msgstr "" 1293"Renvoie une géométrie représentant la boite englobante de la géométrie " 1294"donnée, sous forme de double precision (float8)." 1295 1296#. Tag: funcprototype 1297#: reference_accessor.xml:466 1298#, no-c-format 1299msgid "" 1300"<funcdef>geometry <function>ST_Envelope</function></funcdef> " 1301"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 1302msgstr "" 1303"<funcdef>geometry <function>ST_Envelope</function></funcdef> " 1304"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 1305 1306#. Tag: para 1307#: reference_accessor.xml:477 1308#, fuzzy, no-c-format 1309msgid "" 1310"Returns the double-precision (float8) minimum bounding box for the supplied " 1311"geometry, as a geometry. The polygon is defined by the corner points of the " 1312"bounding box ((<varname>MINX</varname>, <varname>MINY</varname>), " 1313"(<varname>MINX</varname>, <varname>MAXY</varname>), (<varname>MAXX</" 1314"varname>, <varname>MAXY</varname>), (<varname>MAXX</varname>, <varname>MINY</" 1315"varname>), (<varname>MINX</varname>, <varname>MINY</varname>)). (PostGIS " 1316"will add a <varname>ZMIN</varname>/<varname>ZMAX</varname> coordinate as " 1317"well)." 1318msgstr "" 1319"Renvoie une géométrie représentant la boite englobante de la géométrie " 1320"donnée, sous forme de float8. Le polygone est défini par les coins de la " 1321"boite englobante ((<varname>MINX</varname>, <varname>MINY</varname>), " 1322"(<varname>MINX</varname>, <varname>MAXY</varname>), (<varname>MAXX</" 1323"varname>, <varname>MAXY</varname>), (<varname>MAXX</varname>, <varname>MINY</" 1324"varname>), (<varname>MINX</varname>, <varname>MINY</varname>)). (PostGIS " 1325"ajoute également les coordonnées <varname>ZMIN</varname>/<varname>ZMAX</" 1326"varname>)." 1327 1328#. Tag: para 1329#: reference_accessor.xml:487 1330#, no-c-format 1331msgid "" 1332"Degenerate cases (vertical lines, points) will return a geometry of lower " 1333"dimension than <varname>POLYGON</varname>, ie. <varname>POINT</varname> or " 1334"<varname>LINESTRING</varname>." 1335msgstr "" 1336"Les cas dégénérés (lignes verticales, points) renvoient une géométrie de " 1337"dimension inférieure à celle d'un <varname>POLYGON</varname>, par exemple " 1338"<varname>POINT</varname> ou <varname>LINESTRING</varname>." 1339 1340#. Tag: para 1341#: reference_accessor.xml:491 1342#, no-c-format 1343msgid "" 1344"Availability: 1.5.0 behavior changed to output double precision instead of " 1345"float4" 1346msgstr "" 1347"Disponibilité: 1.5.0 changement pour renvoyer un type double précision à la " 1348"place de float4" 1349 1350#. Tag: para 1351#: reference_accessor.xml:492 reference_accessor.xml:1120 1352#: reference_accessor.xml:1216 1353#, no-c-format 1354msgid "&sfs_compliant; s2.1.1.1" 1355msgstr "&sfs_compliant; s2.1.1.1" 1356 1357#. Tag: para 1358#: reference_accessor.xml:493 1359#, no-c-format 1360msgid "&sqlmm_compliant; SQL-MM 3: 5.1.15" 1361msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.15" 1362 1363#. Tag: programlisting 1364#: reference_accessor.xml:499 1365#, no-c-format 1366msgid "" 1367"SELECT ST_AsText(ST_Envelope('POINT(1 3)'::geometry));\n" 1368" st_astext\n" 1369"------------\n" 1370" POINT(1 3)\n" 1371"(1 row)\n" 1372"\n" 1373"\n" 1374"SELECT ST_AsText(ST_Envelope('LINESTRING(0 0, 1 3)'::geometry));\n" 1375" st_astext\n" 1376"--------------------------------\n" 1377" POLYGON((0 0,0 3,1 3,1 0,0 0))\n" 1378"(1 row)\n" 1379"\n" 1380"\n" 1381"SELECT ST_AsText(ST_Envelope('POLYGON((0 0, 0 1, 1.0000001 1, 1.0000001 0, 0 " 1382"0))'::geometry));\n" 1383" st_astext\n" 1384"--------------------------------------------------------------\n" 1385" POLYGON((0 0,0 1,1.00000011920929 1,1.00000011920929 0,0 0))\n" 1386"(1 row)\n" 1387"SELECT ST_AsText(ST_Envelope('POLYGON((0 0, 0 1, 1.0000000001 1, " 1388"1.0000000001 0, 0 0))'::geometry));\n" 1389" st_astext\n" 1390"--------------------------------------------------------------\n" 1391" POLYGON((0 0,0 1,1.00000011920929 1,1.00000011920929 0,0 0))\n" 1392"(1 row)\n" 1393"\n" 1394"SELECT Box3D(geom), Box2D(geom), ST_AsText(ST_Envelope(geom)) As " 1395"envelopewkt\n" 1396" FROM (SELECT 'POLYGON((0 0, 0 1000012333334.34545678, 1.0000001 1, " 1397"1.0000001 0, 0 0))'::geometry As geom) As foo;\n" 1398"\n" 1399"<!-- TODO: Fix examples to reflect new behavior -->" 1400msgstr "" 1401 1402#. Tag: para 1403#: reference_accessor.xml:505 1404#, no-c-format 1405msgid "Envelope of a point and linestring." 1406msgstr "" 1407 1408#. Tag: programlisting 1409#: reference_accessor.xml:508 1410#, no-c-format 1411msgid "" 1412"SELECT ST_AsText(ST_Envelope(\n" 1413" ST_Collect(\n" 1414" ST_GeomFromText('LINESTRING(55 75,125 150)'),\n" 1415" ST_Point(20, 80))\n" 1416" )) As wktenv;\n" 1417"wktenv\n" 1418"-----------\n" 1419"POLYGON((20 75,20 150,125 150,125 75,20 75))" 1420msgstr "" 1421 1422#. Tag: para 1423#: reference_accessor.xml:513 1424#, no-c-format 1425msgid ", <xref linkend=\"Box3D\"/>, <xref linkend=\"ST_OrientedEnvelope\"/>" 1426msgstr "" 1427 1428#. Tag: refname 1429#: reference_accessor.xml:519 1430#, no-c-format 1431msgid "ST_BoundingDiagonal" 1432msgstr "ST_BoundingDiagonal" 1433 1434#. Tag: refpurpose 1435#: reference_accessor.xml:521 1436#, fuzzy, no-c-format 1437msgid "Returns the diagonal of a geometry's bounding box." 1438msgstr "" 1439"Retourne la diagonale de la boîte englobante pour la géométrie en argument" 1440 1441#. Tag: funcprototype 1442#: reference_accessor.xml:526 1443#, no-c-format 1444msgid "" 1445"<funcdef>geometry <function>ST_BoundingDiagonal</function></funcdef> " 1446"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> " 1447"<paramdef choice=\"opt\"><type>boolean </type> <parameter>fits=false</" 1448"parameter></paramdef>" 1449msgstr "" 1450"<funcdef>geometry <function>ST_BoundingDiagonal</function></funcdef> " 1451"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> " 1452"<paramdef choice=\"opt\"><type>boolean </type> <parameter>fits=false</" 1453"parameter></paramdef>" 1454 1455#. Tag: para 1456#: reference_accessor.xml:538 1457#, no-c-format 1458msgid "" 1459"Returns the diagonal of the supplied geometry's bounding box as a " 1460"LineString. If the input geometry is empty, the diagonal line is also empty, " 1461"otherwise it is a 2-point LineString with the minimum values of each " 1462"dimension in its start point and the maximum values in its end point." 1463msgstr "" 1464 1465#. Tag: para 1466#: reference_accessor.xml:545 1467#, no-c-format 1468msgid "" 1469"The returned linestring geometry always retains SRID and dimensionality (Z " 1470"and M presence) of the input geometry." 1471msgstr "" 1472 1473#. Tag: para 1474#: reference_accessor.xml:550 1475#, no-c-format 1476msgid "" 1477"The <varname>fits</varname> parameter specifies if the best fit is needed. " 1478"If false, the diagonal of a somewhat larger bounding box can be accepted (is " 1479"faster to obtain for geometries with a lot of vertices). In any case the " 1480"bounding box of the returned diagonal line always covers the input geometry." 1481msgstr "" 1482 1483#. Tag: para 1484#: reference_accessor.xml:558 1485#, no-c-format 1486msgid "" 1487"In degenerate cases (a single vertex in input) the returned linestring will " 1488"be topologically invalid (no interior). This does not make the return " 1489"semantically invalid." 1490msgstr "" 1491 1492#. Tag: para 1493#: reference_accessor.xml:564 1494#, no-c-format 1495msgid "Availability: 2.2.0" 1496msgstr "Disponibilité : 2.2.0" 1497 1498#. Tag: para 1499#: reference_accessor.xml:566 reference_accessor.xml:897 1500#: reference_accessor.xml:967 1501#, no-c-format 1502msgid "&M_support;" 1503msgstr "&M_support;" 1504 1505#. Tag: programlisting 1506#: reference_accessor.xml:572 1507#, no-c-format 1508msgid "" 1509"-- Get the minimum X in a buffer around a point\n" 1510"SELECT ST_X(ST_StartPoint(ST_BoundingDiagonal(\n" 1511" ST_Buffer(ST_MakePoint(0,0),10)\n" 1512")));\n" 1513" st_x\n" 1514"------\n" 1515" -10" 1516msgstr "" 1517"-- Obtenir le X minimum d'une zone tampon autour d'un point\n" 1518"SELECT ST_X(ST_StartPoint(ST_BoundingDiagonal(\n" 1519" ST_Buffer(ST_MakePoint(0,0),10)\n" 1520")));\n" 1521" st_x\n" 1522"------\n" 1523" -10" 1524 1525#. Tag: para 1526#: reference_accessor.xml:576 1527#, no-c-format 1528msgid "" 1529", <xref linkend=\"ST_EndPoint\"/>, <xref linkend=\"ST_X\"/>, <xref linkend=" 1530"\"ST_Y\"/>, <xref linkend=\"ST_Z\"/>, <xref linkend=\"ST_M\"/>, <xref " 1531"linkend=\"geometry_overlaps_nd\"/>" 1532msgstr "" 1533", <xref linkend=\"ST_EndPoint\"/>, <xref linkend=\"ST_X\"/>, <xref linkend=" 1534"\"ST_Y\"/>, <xref linkend=\"ST_Z\"/>, <xref linkend=\"ST_M\"/>, <xref " 1535"linkend=\"geometry_overlaps_nd\"/>" 1536 1537#. Tag: refname 1538#: reference_accessor.xml:590 1539#, no-c-format 1540msgid "ST_ExteriorRing" 1541msgstr "ST_ExteriorRing" 1542 1543#. Tag: refpurpose 1544#: reference_accessor.xml:592 1545#, no-c-format 1546msgid "Returns a LineString representing the exterior ring of a Polygon." 1547msgstr "" 1548 1549#. Tag: funcprototype 1550#: reference_accessor.xml:597 1551#, no-c-format 1552msgid "" 1553"<funcdef>geometry <function>ST_ExteriorRing</function></funcdef> " 1554"<paramdef><type>geometry </type> <parameter>a_polygon</parameter></paramdef>" 1555msgstr "" 1556"<funcdef>geometry <function>ST_ExteriorRing</function></funcdef> " 1557"<paramdef><type>geometry </type> <parameter>a_polygon</parameter></paramdef>" 1558 1559#. Tag: para 1560#: reference_accessor.xml:608 1561#, no-c-format 1562msgid "" 1563"Returns a line string representing the exterior ring of the " 1564"<varname>POLYGON</varname> geometry. Return NULL if the geometry is not a " 1565"polygon." 1566msgstr "" 1567"Retourne une ligne représentant l'envelope extérieure du <varname>POLYGON</" 1568"varname>. Renvoie NULL si la géométrie n'est pas un polygone." 1569 1570#. Tag: para 1571#: reference_accessor.xml:611 1572#, no-c-format 1573msgid "Only works with POLYGON geometry types" 1574msgstr "Ne fonctionne qu'avec des géométries POLYGON" 1575 1576#. Tag: para 1577#: reference_accessor.xml:613 reference_accessor.xml:1163 1578#, no-c-format 1579msgid "&sfs_compliant; 2.1.5.1" 1580msgstr "&sfs_compliant; 2.1.5.1" 1581 1582#. Tag: para 1583#: reference_accessor.xml:614 1584#, no-c-format 1585msgid "&sqlmm_compliant; SQL-MM 3: 8.2.3, 8.3.3" 1586msgstr "&sqlmm_compliant; SQL-MM 3: 8.2.3, 8.3.3" 1587 1588#. Tag: programlisting 1589#: reference_accessor.xml:621 1590#, no-c-format 1591msgid "" 1592"--If you have a table of polygons\n" 1593"SELECT gid, ST_ExteriorRing(the_geom) AS ering\n" 1594"FROM sometable;\n" 1595"\n" 1596"--If you have a table of MULTIPOLYGONs\n" 1597"--and want to return a MULTILINESTRING composed of the exterior rings of " 1598"each polygon\n" 1599"SELECT gid, ST_Collect(ST_ExteriorRing(the_geom)) AS erings\n" 1600" FROM (SELECT gid, (ST_Dump(the_geom)).geom As the_geom\n" 1601" FROM sometable) As foo\n" 1602"GROUP BY gid;\n" 1603"\n" 1604"--3d Example\n" 1605"SELECT ST_AsEWKT(\n" 1606" ST_ExteriorRing(\n" 1607" ST_GeomFromEWKT('POLYGON((0 0 1, 1 1 1, 1 2 1, 1 1 1, 0 0 1))')\n" 1608" )\n" 1609");\n" 1610"\n" 1611"st_asewkt\n" 1612"---------\n" 1613"LINESTRING(0 0 1,1 1 1,1 2 1,1 1 1,0 0 1)" 1614msgstr "" 1615"--If you have a table of polygons\n" 1616"SELECT gid, ST_ExteriorRing(the_geom) AS ering\n" 1617"FROM sometable;\n" 1618"\n" 1619"--If you have a table of MULTIPOLYGONs\n" 1620"--and want to return a MULTILINESTRING composed of the exterior rings of " 1621"each polygon\n" 1622"SELECT gid, ST_Collect(ST_ExteriorRing(the_geom)) AS erings\n" 1623" FROM (SELECT gid, (ST_Dump(the_geom)).geom As the_geom\n" 1624" FROM sometable) As foo\n" 1625"GROUP BY gid;\n" 1626"\n" 1627"--3d Example\n" 1628"SELECT ST_AsEWKT(\n" 1629" ST_ExteriorRing(\n" 1630" ST_GeomFromEWKT('POLYGON((0 0 1, 1 1 1, 1 2 1, 1 1 1, 0 0 1))')\n" 1631" )\n" 1632");\n" 1633"\n" 1634"st_asewkt\n" 1635"---------\n" 1636"LINESTRING(0 0 1,1 1 1,1 2 1,1 1 1,0 0 1)" 1637 1638#. Tag: para 1639#: reference_accessor.xml:627 1640#, no-c-format 1641msgid "" 1642", <xref linkend=\"ST_Boundary\"/>, <xref linkend=\"ST_NumInteriorRings\"/>" 1643msgstr "" 1644", <xref linkend=\"ST_Boundary\"/>, <xref linkend=\"ST_NumInteriorRings\"/>" 1645 1646#. Tag: refname 1647#: reference_accessor.xml:637 1648#, no-c-format 1649msgid "ST_GeometryN" 1650msgstr "ST_GeometryN" 1651 1652#. Tag: refpurpose 1653#: reference_accessor.xml:639 1654#, fuzzy, no-c-format 1655msgid "Return the Nth geometry element of a geometry collection." 1656msgstr "Renvoie le type de la géométrie passée en paramètre." 1657 1658#. Tag: funcprototype 1659#: reference_accessor.xml:644 1660#, no-c-format 1661msgid "" 1662"<funcdef>geometry <function>ST_GeometryN</function></funcdef> " 1663"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 1664"<paramdef><type>integer </type> <parameter>n</parameter></paramdef>" 1665msgstr "" 1666"<funcdef>geometry <function>ST_GeometryN</function></funcdef> " 1667"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 1668"<paramdef><type>integer </type> <parameter>n</parameter></paramdef>" 1669 1670#. Tag: para 1671#: reference_accessor.xml:655 1672#, no-c-format 1673msgid "" 1674"Return the 1-based Nth geometry if the geometry is a GEOMETRYCOLLECTION, " 1675"(MULTI)POINT, (MULTI)LINESTRING, MULTICURVE or (MULTI)POLYGON, " 1676"POLYHEDRALSURFACE Otherwise, return NULL" 1677msgstr "" 1678"Retourne la nième géométrie, n commençant à 1, si la géométrie passée en " 1679"paramètre est de type GEOMETRYCOLLECTION, (MULTI)POINT, (MULTI)LINESTRING, " 1680"MULTICURVE ou (MULTI)POLYGON, POLYHEDRALSURFACE. Renvoie NULL dans les " 1681"autres cas." 1682 1683#. Tag: para 1684#: reference_accessor.xml:660 1685#, no-c-format 1686msgid "" 1687"Index is 1-based as for OGC specs since version 0.8.0. Previous versions " 1688"implemented this as 0-based instead." 1689msgstr "" 1690"L'index commence à 1 pour respecter les spécificarions OGC depuis la version " 1691"0.8.0. Dans les versions antérieures, l'index commençait à 0." 1692 1693#. Tag: para 1694#: reference_accessor.xml:665 1695#, fuzzy, no-c-format 1696msgid "" 1697"If you want to extract all geometries, of a geometry, <xref linkend=\"ST_Dump" 1698"\"/> is more efficient, and also works for singular geoms." 1699msgstr "" 1700"Si toutes les géométries composant une géométrie doivent être extraites, il " 1701"faut mieux utiliser la fonction ST_Dump, qui est plus efficace et accepte " 1702"les types simples en paramètre." 1703 1704#. Tag: para 1705#: reference_accessor.xml:668 1706#, no-c-format 1707msgid "" 1708"Changed: 2.0.0 Prior versions would return NULL for singular geometries. " 1709"This was changed to return the geometry for ST_GeometryN(..,1) case." 1710msgstr "" 1711"Changement: 2.0.0. Les versions antérieures renvoient NULL pour les " 1712"géometries simples (un seul objet). Renvoie désormais la géométrie pour le " 1713"cas ST_GeometryN(..,1)." 1714 1715#. Tag: para 1716#: reference_accessor.xml:670 1717#, no-c-format 1718msgid "&sqlmm_compliant; SQL-MM 3: 9.1.5" 1719msgstr "&sqlmm_compliant; SQL-MM 3: 9.1.5" 1720 1721#. Tag: programlisting 1722#: reference_accessor.xml:682 1723#, no-c-format 1724msgid "" 1725"--Extracting a subset of points from a 3d multipoint\n" 1726"SELECT n, ST_AsEWKT(ST_GeometryN(the_geom, n)) As geomewkt\n" 1727"FROM (\n" 1728"VALUES (ST_GeomFromEWKT('MULTIPOINT(1 2 7, 3 4 7, 5 6 7, 8 9 10)') ),\n" 1729"( ST_GeomFromEWKT('MULTICURVE(CIRCULARSTRING(2.5 2.5,4.5 2.5, 3.5 3.5), (10 " 1730"11, 12 11))') )\n" 1731" )As foo(the_geom)\n" 1732" CROSS JOIN generate_series(1,100) n\n" 1733"WHERE n <= ST_NumGeometries(the_geom);\n" 1734"\n" 1735" n | geomewkt\n" 1736"---+-----------------------------------------\n" 1737" 1 | POINT(1 2 7)\n" 1738" 2 | POINT(3 4 7)\n" 1739" 3 | POINT(5 6 7)\n" 1740" 4 | POINT(8 9 10)\n" 1741" 1 | CIRCULARSTRING(2.5 2.5,4.5 2.5,3.5 3.5)\n" 1742" 2 | LINESTRING(10 11,12 11)\n" 1743"\n" 1744"\n" 1745"--Extracting all geometries (useful when you want to assign an id)\n" 1746"SELECT gid, n, ST_GeometryN(the_geom, n)\n" 1747"FROM sometable CROSS JOIN generate_series(1,100) n\n" 1748"WHERE n <= ST_NumGeometries(the_geom);" 1749msgstr "" 1750"--Extracting a subset of points from a 3d multipoint\n" 1751"SELECT n, ST_AsEWKT(ST_GeometryN(the_geom, n)) As geomewkt\n" 1752"FROM (\n" 1753"VALUES (ST_GeomFromEWKT('MULTIPOINT(1 2 7, 3 4 7, 5 6 7, 8 9 10)') ),\n" 1754"( ST_GeomFromEWKT('MULTICURVE(CIRCULARSTRING(2.5 2.5,4.5 2.5, 3.5 3.5), (10 " 1755"11, 12 11))') )\n" 1756" )As foo(the_geom)\n" 1757" CROSS JOIN generate_series(1,100) n\n" 1758"WHERE n <= ST_NumGeometries(the_geom);\n" 1759"\n" 1760" n | geomewkt\n" 1761"---+-----------------------------------------\n" 1762" 1 | POINT(1 2 7)\n" 1763" 2 | POINT(3 4 7)\n" 1764" 3 | POINT(5 6 7)\n" 1765" 4 | POINT(8 9 10)\n" 1766" 1 | CIRCULARSTRING(2.5 2.5,4.5 2.5,3.5 3.5)\n" 1767" 2 | LINESTRING(10 11,12 11)\n" 1768"\n" 1769"\n" 1770"--Extracting all geometries (useful when you want to assign an id)\n" 1771"SELECT gid, n, ST_GeometryN(the_geom, n)\n" 1772"FROM sometable CROSS JOIN generate_series(1,100) n\n" 1773"WHERE n <= ST_NumGeometries(the_geom);" 1774 1775#. Tag: programlisting 1776#: reference_accessor.xml:686 1777#, no-c-format 1778msgid "" 1779"-- Polyhedral surface example\n" 1780"-- Break a Polyhedral surface into its faces\n" 1781"SELECT ST_AsEWKT(ST_GeometryN(p_geom,3)) As geom_ewkt\n" 1782" FROM (SELECT ST_GeomFromEWKT('POLYHEDRALSURFACE(\n" 1783"((0 0 0, 0 0 1, 0 1 1, 0 1 0, 0 0 0)),\n" 1784"((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)),\n" 1785"((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0 0)),\n" 1786"((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),\n" 1787"((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)),\n" 1788"((0 0 1, 1 0 1, 1 1 1, 0 1 1, 0 0 1))\n" 1789")') AS p_geom ) AS a;\n" 1790"\n" 1791" geom_ewkt\n" 1792"------------------------------------------\n" 1793" POLYGON((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0))" 1794msgstr "" 1795 1796#. Tag: programlisting 1797#: reference_accessor.xml:688 1798#, no-c-format 1799msgid "" 1800"-- TIN --\n" 1801"SELECT ST_AsEWKT(ST_GeometryN(geom,2)) as wkt\n" 1802" FROM\n" 1803" (SELECT\n" 1804" ST_GeomFromEWKT('TIN (((\n" 1805" 0 0 0,\n" 1806" 0 0 1,\n" 1807" 0 1 0,\n" 1808" 0 0 0\n" 1809" )), ((\n" 1810" 0 0 0,\n" 1811" 0 1 0,\n" 1812" 1 1 0,\n" 1813" 0 0 0\n" 1814" ))\n" 1815" )') AS geom\n" 1816" ) AS g;\n" 1817"-- result --\n" 1818" wkt\n" 1819"-------------------------------------\n" 1820" TRIANGLE((0 0 0,0 1 0,1 1 0,0 0 0))" 1821msgstr "" 1822 1823#. Tag: para 1824#: reference_accessor.xml:695 reference_accessor.xml:1578 1825#, no-c-format 1826msgid ", <xref linkend=\"ST_NumGeometries\"/>" 1827msgstr ", <xref linkend=\"ST_NumGeometries\"/>" 1828 1829#. Tag: refname 1830#: reference_accessor.xml:701 1831#, no-c-format 1832msgid "ST_GeometryType" 1833msgstr "ST_GeometryType" 1834 1835#. Tag: refpurpose 1836#: reference_accessor.xml:702 1837#, fuzzy, no-c-format 1838msgid "Returns the SQL-MM type of a geometry as text." 1839msgstr "Renvoie le type de la géométrie passée en paramètre." 1840 1841#. Tag: funcprototype 1842#: reference_accessor.xml:707 1843#, no-c-format 1844msgid "" 1845"<funcdef>text <function>ST_GeometryType</function></funcdef> " 1846"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 1847msgstr "" 1848"<funcdef>text <function>ST_GeometryType</function></funcdef> " 1849"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 1850 1851#. Tag: para 1852#: reference_accessor.xml:716 1853#, no-c-format 1854msgid "" 1855"Returns the type of the geometry as a string. EG: 'ST_LineString', " 1856"'ST_Polygon','ST_MultiPolygon' etc. This function differs from " 1857"GeometryType(geometry) in the case of the string and ST in front that is " 1858"returned, as well as the fact that it will not indicate whether the geometry " 1859"is measured." 1860msgstr "" 1861"Renvoie le type de la géométrie sous forme de texte, par exemple: " 1862"'ST_LineString', 'ST_Polygon','ST_MultiPolygon' etc. Cette fonction diffère " 1863"de GeometryType(geometry) par la casse du texte renvoyé et par le préfixe " 1864"ST_ en début de texte. N'indique pas si la géométrie comporte une dimension " 1865"MESURE." 1866 1867#. Tag: para 1868#: reference_accessor.xml:718 reference_accessor.xml:1015 1869#: reference_accessor.xml:1379 1870#, no-c-format 1871msgid "Enhanced: 2.0.0 support for Polyhedral surfaces was introduced." 1872msgstr "" 1873"Amélioration: 2.0.0 introduction du support des surfaces polyhédriques." 1874 1875#. Tag: para 1876#: reference_accessor.xml:719 1877#, no-c-format 1878msgid "&sqlmm_compliant; SQL-MM 3: 5.1.4" 1879msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.4" 1880 1881#. Tag: programlisting 1882#: reference_accessor.xml:728 1883#, no-c-format 1884msgid "" 1885"SELECT ST_GeometryType(ST_GeomFromText('LINESTRING(77.29 29.07,77.42 " 1886"29.26,77.27 29.31,77.29 29.07)'));\n" 1887" --result\n" 1888" ST_LineString" 1889msgstr "" 1890"SELECT ST_GeometryType(ST_GeomFromText('LINESTRING(77.29 29.07,77.42 " 1891"29.26,77.27 29.31,77.29 29.07)'));\n" 1892" --result\n" 1893" ST_LineString" 1894 1895#. Tag: programlisting 1896#: reference_accessor.xml:730 reference_accessor.xml:732 1897#, no-c-format 1898msgid "" 1899"SELECT ST_GeometryType(ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 0, 0 0 1, 0 " 1900"1 1, 0 1 0, 0 0 0)),\n" 1901" ((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 " 1902"1, 0 0 1, 0 0 0)),\n" 1903" ((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),\n" 1904" ((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)), ((0 0 1, 1 0 1, 1 1 " 1905"1, 0 1 1, 0 0 1)) )'));\n" 1906" --result\n" 1907" ST_PolyhedralSurface" 1908msgstr "" 1909 1910#. Tag: programlisting 1911#: reference_accessor.xml:734 1912#, no-c-format 1913msgid "" 1914"SELECT ST_GeometryType(geom) as result\n" 1915" FROM\n" 1916" (SELECT\n" 1917" ST_GeomFromEWKT('TIN (((\n" 1918" 0 0 0,\n" 1919" 0 0 1,\n" 1920" 0 1 0,\n" 1921" 0 0 0\n" 1922" )), ((\n" 1923" 0 0 0,\n" 1924" 0 1 0,\n" 1925" 1 1 0,\n" 1926" 0 0 0\n" 1927" ))\n" 1928" )') AS geom\n" 1929" ) AS g;\n" 1930" result\n" 1931"--------\n" 1932" ST_Tin" 1933msgstr "" 1934 1935#. Tag: refname 1936#: reference_accessor.xml:745 1937#, no-c-format 1938msgid "ST_HasArc" 1939msgstr "" 1940 1941#. Tag: refpurpose 1942#: reference_accessor.xml:747 1943#, no-c-format 1944msgid "Tests if a geometry contains a circular arc" 1945msgstr "" 1946 1947#. Tag: funcprototype 1948#: reference_accessor.xml:752 1949#, fuzzy, no-c-format 1950msgid "" 1951"<funcdef>boolean <function>ST_HasArc</function></funcdef> " 1952"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 1953msgstr "" 1954"<funcdef>boolean <function>ST_IsEmpty</function></funcdef> " 1955"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 1956 1957#. Tag: para 1958#: reference_accessor.xml:762 1959#, fuzzy, no-c-format 1960msgid "" 1961"Returns true if a geometry or geometry collection contains a circular string" 1962msgstr "" 1963"Renvoie vrai si la géométrie est une geometrycollection vide, un polygon, " 1964"un point etc. " 1965 1966#. Tag: para 1967#: reference_accessor.xml:764 1968#, fuzzy, no-c-format 1969msgid "Availability: 1.2.3?" 1970msgstr "Disponibilité : 2.2.0" 1971 1972#. Tag: programlisting 1973#: reference_accessor.xml:773 1974#, no-c-format 1975msgid "" 1976"SELECT ST_HasArc(ST_Collect('LINESTRING(1 2, 3 4, 5 6)', 'CIRCULARSTRING(1 " 1977"1, 2 3, 4 5, 6 7, 5 6)'));\n" 1978" st_hasarc\n" 1979" --------\n" 1980" t" 1981msgstr "" 1982 1983#. Tag: para 1984#: reference_accessor.xml:780 1985#, fuzzy, no-c-format 1986msgid ", <xref linkend=\"ST_LineToCurve\"/>" 1987msgstr ", <xref linkend=\"ST_PointN\"/>" 1988 1989#. Tag: refname 1990#: reference_accessor.xml:786 1991#, no-c-format 1992msgid "ST_InteriorRingN" 1993msgstr "ST_InteriorRingN" 1994 1995#. Tag: refpurpose 1996#: reference_accessor.xml:788 1997#, no-c-format 1998msgid "Returns the Nth interior ring (hole) of a Polygon." 1999msgstr "" 2000 2001#. Tag: funcprototype 2002#: reference_accessor.xml:793 2003#, no-c-format 2004msgid "" 2005"<funcdef>geometry <function>ST_InteriorRingN</function></funcdef> " 2006"<paramdef><type>geometry </type> <parameter>a_polygon</parameter></paramdef> " 2007"<paramdef><type>integer </type> <parameter>n</parameter></paramdef>" 2008msgstr "" 2009"<funcdef>geometry <function>ST_InteriorRingN</function></funcdef> " 2010"<paramdef><type>geometry </type> <parameter>a_polygon</parameter></paramdef> " 2011"<paramdef><type>integer </type> <parameter>n</parameter></paramdef>" 2012 2013#. Tag: para 2014#: reference_accessor.xml:804 2015#, fuzzy, no-c-format 2016msgid "" 2017"Returns the Nth interior linestring ring of the polygon geometry. Returns " 2018"NULL if the geometry is not a polygon or the given N is out of range. The " 2019"index starts at 1." 2020msgstr "" 2021"Retourne la nième ligne intérieure du polygone passé en paramètre. Renvoie " 2022"NULL si la géométrie n'est pas un polygone ou si l'index ne correspond pas à " 2023"un intérieur. L'index démarre à 1." 2024 2025#. Tag: para 2026#: reference_accessor.xml:810 2027#, fuzzy, no-c-format 2028msgid "" 2029"This function does not support for MULTIPOLYGONs. Use in conjunction with " 2030"<xref linkend=\"ST_Dump\"/> for MULTIPOLYGONS" 2031msgstr "" 2032"Ne support pas les MULTIPOLYGON. Utiliser en association avec ST_Dump pour " 2033"les MULTIPOLYGON" 2034 2035#. Tag: para 2036#: reference_accessor.xml:814 2037#, no-c-format 2038msgid "&sqlmm_compliant; SQL-MM 3: 8.2.6, 8.3.5" 2039msgstr "&sqlmm_compliant; SQL-MM 3: 8.2.6, 8.3.5" 2040 2041#. Tag: programlisting 2042#: reference_accessor.xml:823 2043#, no-c-format 2044msgid "" 2045"SELECT ST_AsText(ST_InteriorRingN(the_geom, 1)) As the_geom\n" 2046"FROM (SELECT ST_BuildArea(\n" 2047" ST_Collect(ST_Buffer(ST_Point(1,2), 20,3),\n" 2048" ST_Buffer(ST_Point(1, 2), 10,3))) As the_geom\n" 2049" ) as foo" 2050msgstr "" 2051"SELECT ST_AsText(ST_InteriorRingN(the_geom, 1)) As the_geom\n" 2052"FROM (SELECT ST_BuildArea(\n" 2053" ST_Collect(ST_Buffer(ST_Point(1,2), 20,3),\n" 2054" ST_Buffer(ST_Point(1, 2), 10,3))) As the_geom\n" 2055" ) as foo" 2056 2057#. Tag: para 2058#: reference_accessor.xml:830 2059#, no-c-format 2060msgid "" 2061", <xref linkend=\"ST_Collect\"/>, <xref linkend=\"ST_Dump\"/>, <xref linkend=" 2062"\"ST_NumInteriorRing\"/>," 2063msgstr "" 2064", <xref linkend=\"ST_Collect\"/>, <xref linkend=\"ST_Dump\"/>, <xref linkend=" 2065"\"ST_NumInteriorRing\"/>," 2066 2067#. Tag: refname 2068#: reference_accessor.xml:843 2069#, no-c-format 2070msgid "ST_IsPolygonCCW" 2071msgstr "" 2072 2073#. Tag: refpurpose 2074#: reference_accessor.xml:846 2075#, no-c-format 2076msgid "" 2077"Tests if Polygons have exterior rings oriented counter-clockwise and " 2078"interior rings oriented clockwise." 2079msgstr "" 2080 2081#. Tag: funcprototype 2082#: reference_accessor.xml:852 2083#, no-c-format 2084msgid "" 2085"<funcdef> boolean <function>ST_IsPolygonCCW</function> </funcdef> <paramdef> " 2086"<type>geometry</type> <parameter>geom</parameter> </paramdef>" 2087msgstr "" 2088 2089#. Tag: para 2090#: reference_accessor.xml:868 2091#, no-c-format 2092msgid "" 2093"Returns true if all polygonal components of the input geometry use a counter-" 2094"clockwise orientation for their exterior ring, and a clockwise direction for " 2095"all interior rings." 2096msgstr "" 2097 2098#. Tag: para 2099#: reference_accessor.xml:874 reference_accessor.xml:944 2100#, no-c-format 2101msgid "Returns true if the geometry has no polygonal components." 2102msgstr "" 2103 2104#. Tag: para 2105#: reference_accessor.xml:879 reference_accessor.xml:949 2106#, no-c-format 2107msgid "" 2108"Closed linestrings are not considered polygonal components, so you would " 2109"still get a true return by passing a single closed linestring no matter its " 2110"orientation." 2111msgstr "" 2112 2113#. Tag: para 2114#: reference_accessor.xml:887 reference_accessor.xml:957 2115#, no-c-format 2116msgid "" 2117"If a polygonal geometry does not use reversed orientation for interior rings " 2118"(i.e., if one or more interior rings are oriented in the same direction as " 2119"an exterior ring) then both ST_IsPolygonCW and ST_IsPolygonCCW will return " 2120"false." 2121msgstr "" 2122 2123#. Tag: para 2124#: reference_accessor.xml:895 reference_accessor.xml:965 2125#, fuzzy, no-c-format 2126msgid "Availability: 2.4.0" 2127msgstr "Disponibilité : 2.2.0" 2128 2129#. Tag: para 2130#: reference_accessor.xml:903 reference_accessor.xml:972 2131#, no-c-format 2132msgid "" 2133", <xref linkend=\"ST_ForcePolygonCCW\"/>, <xref linkend=\"ST_IsPolygonCW\"/>" 2134msgstr "" 2135 2136#. Tag: refname 2137#: reference_accessor.xml:913 2138#, no-c-format 2139msgid "ST_IsPolygonCW" 2140msgstr "" 2141 2142#. Tag: refpurpose 2143#: reference_accessor.xml:916 2144#, no-c-format 2145msgid "" 2146"Tests if Polygons have exterior rings oriented clockwise and interior rings " 2147"oriented counter-clockwise." 2148msgstr "" 2149 2150#. Tag: funcprototype 2151#: reference_accessor.xml:922 2152#, no-c-format 2153msgid "" 2154"<funcdef> boolean <function>ST_IsPolygonCW</function> </funcdef> <paramdef> " 2155"<type>geometry</type> <parameter>geom</parameter> </paramdef>" 2156msgstr "" 2157 2158#. Tag: para 2159#: reference_accessor.xml:938 2160#, no-c-format 2161msgid "" 2162"Returns true if all polygonal components of the input geometry use a " 2163"clockwise orientation for their exterior ring, and a counter-clockwise " 2164"direction for all interior rings." 2165msgstr "" 2166 2167#. Tag: refname 2168#: reference_accessor.xml:982 2169#, no-c-format 2170msgid "ST_IsClosed" 2171msgstr "ST_IsClosed" 2172 2173#. Tag: refpurpose 2174#: reference_accessor.xml:984 2175#, fuzzy, no-c-format 2176msgid "" 2177"Tests if a LineStrings's start and end points are coincident. For a " 2178"PolyhedralSurface tests if it is closed (volumetric)." 2179msgstr "" 2180"Renvoie <varname>TRUE</varname> si les premier et dernier points de la " 2181"<varname>LINESTRING</varname> sont identiques. Pour les surface " 2182"polyhédriques, indique si la surface est surfacique (ouverte) ou " 2183"volumétrique (fermée)." 2184 2185#. Tag: funcprototype 2186#: reference_accessor.xml:990 2187#, no-c-format 2188msgid "" 2189"<funcdef>boolean <function>ST_IsClosed</function></funcdef> " 2190"<paramdef><type>geometry </type> <parameter>g</parameter></paramdef>" 2191msgstr "" 2192"<funcdef>boolean <function>ST_IsClosed</function></funcdef> " 2193"<paramdef><type>geometry </type> <parameter>g</parameter></paramdef>" 2194 2195#. Tag: para 2196#: reference_accessor.xml:1001 2197#, fuzzy, no-c-format 2198msgid "" 2199"Returns <varname>TRUE</varname> if the <varname>LINESTRING</varname>'s start " 2200"and end points are coincident. For Polyhedral Surfaces, reports if the " 2201"surface is areal (open) or volumetric (closed)." 2202msgstr "" 2203"Renvoie <varname>TRUE</varname> si les premier et dernier points de la " 2204"<varname>LINESTRING</varname> sont identiques. Pour les surface " 2205"polyhédriques, indique si la surface est surfacique (ouverte) ou " 2206"volumétrique (fermée)." 2207 2208#. Tag: para 2209#: reference_accessor.xml:1006 2210#, no-c-format 2211msgid "&sqlmm_compliant; SQL-MM 3: 7.1.5, 9.3.3" 2212msgstr "&sqlmm_compliant; SQL-MM 3: 7.1.5, 9.3.3" 2213 2214#. Tag: para 2215#: reference_accessor.xml:1008 2216#, no-c-format 2217msgid "" 2218"SQL-MM defines the result of <function>ST_IsClosed(<varname>NULL</varname>)</" 2219"function> to be 0, while PostGIS returns <varname>NULL</varname>." 2220msgstr "" 2221"La norme SQL-MM indique que le résultat de la fonction " 2222"<function>ST_IsClosed(<varname>NULL</varname>)</function> doit être 0 ; " 2223"PostGIS renvoie <varname>NULL</varname>." 2224 2225#. Tag: title 2226#: reference_accessor.xml:1022 2227#, no-c-format 2228msgid "Line String and Point Examples" 2229msgstr "Exemples: points et lignes" 2230 2231#. Tag: programlisting 2232#: reference_accessor.xml:1024 2233#, no-c-format 2234msgid "" 2235"postgis=# SELECT ST_IsClosed('LINESTRING(0 0, 1 1)'::geometry);\n" 2236" st_isclosed\n" 2237"-------------\n" 2238" f\n" 2239"(1 row)\n" 2240"\n" 2241"postgis=# SELECT ST_IsClosed('LINESTRING(0 0, 0 1, 1 1, 0 0)'::geometry);\n" 2242" st_isclosed\n" 2243"-------------\n" 2244" t\n" 2245"(1 row)\n" 2246"\n" 2247"postgis=# SELECT ST_IsClosed('MULTILINESTRING((0 0, 0 1, 1 1, 0 0),(0 0, 1 " 2248"1))'::geometry);\n" 2249" st_isclosed\n" 2250"-------------\n" 2251" f\n" 2252"(1 row)\n" 2253"\n" 2254"postgis=# SELECT ST_IsClosed('POINT(0 0)'::geometry);\n" 2255" st_isclosed\n" 2256"-------------\n" 2257" t\n" 2258"(1 row)\n" 2259"\n" 2260"postgis=# SELECT ST_IsClosed('MULTIPOINT((0 0), (1 1))'::geometry);\n" 2261" st_isclosed\n" 2262"-------------\n" 2263" t\n" 2264"(1 row)" 2265msgstr "" 2266"postgis=# SELECT ST_IsClosed('LINESTRING(0 0, 1 1)'::geometry);\n" 2267" st_isclosed\n" 2268"-------------\n" 2269" f\n" 2270"(1 row)\n" 2271"\n" 2272"postgis=# SELECT ST_IsClosed('LINESTRING(0 0, 0 1, 1 1, 0 0)'::geometry);\n" 2273" st_isclosed\n" 2274"-------------\n" 2275" t\n" 2276"(1 row)\n" 2277"\n" 2278"postgis=# SELECT ST_IsClosed('MULTILINESTRING((0 0, 0 1, 1 1, 0 0),(0 0, 1 " 2279"1))'::geometry);\n" 2280" st_isclosed\n" 2281"-------------\n" 2282" f\n" 2283"(1 row)\n" 2284"\n" 2285"postgis=# SELECT ST_IsClosed('POINT(0 0)'::geometry);\n" 2286" st_isclosed\n" 2287"-------------\n" 2288" t\n" 2289"(1 row)\n" 2290"\n" 2291"postgis=# SELECT ST_IsClosed('MULTIPOINT((0 0), (1 1))'::geometry);\n" 2292" st_isclosed\n" 2293"-------------\n" 2294" t\n" 2295"(1 row)" 2296 2297#. Tag: title 2298#: reference_accessor.xml:1028 2299#, no-c-format 2300msgid "Polyhedral Surface Examples" 2301msgstr "Exemples: surfaces polyhédriques" 2302 2303#. Tag: programlisting 2304#: reference_accessor.xml:1030 2305#, no-c-format 2306msgid "" 2307"-- A cube --\n" 2308" SELECT ST_IsClosed(ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 " 2309"0, 0 0 1, 0 1 1, 0 1 0, 0 0 0)),\n" 2310" ((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 " 2311"1, 0 0 1, 0 0 0)),\n" 2312" ((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),\n" 2313" ((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)), ((0 0 1, 1 0 1, 1 1 " 2314"1, 0 1 1, 0 0 1)) )'));\n" 2315"\n" 2316" st_isclosed\n" 2317"-------------\n" 2318" t\n" 2319"\n" 2320"\n" 2321" -- Same as cube but missing a side --\n" 2322" SELECT ST_IsClosed(ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 0, 0 0 1, 0 1 " 2323"1, 0 1 0, 0 0 0)),\n" 2324" ((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 " 2325"1, 0 0 1, 0 0 0)),\n" 2326" ((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),\n" 2327" ((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)) )'));\n" 2328"\n" 2329" st_isclosed\n" 2330"-------------\n" 2331" f" 2332msgstr "" 2333 2334#. Tag: refname 2335#: reference_accessor.xml:1042 2336#, no-c-format 2337msgid "ST_IsCollection" 2338msgstr "ST_IsCollection" 2339 2340#. Tag: refpurpose 2341#: reference_accessor.xml:1043 2342#, fuzzy, no-c-format 2343msgid "Tests if a geometry is a geometry collection type." 2344msgstr "" 2345"Renvoie vrai si la géométrie est une geometrycollection vide, un polygon, " 2346"un point etc. " 2347 2348#. Tag: funcprototype 2349#: reference_accessor.xml:1048 2350#, no-c-format 2351msgid "" 2352"<funcdef>boolean <function>ST_IsCollection</function></funcdef> " 2353"<paramdef><type>geometry </type> <parameter>g</parameter></paramdef>" 2354msgstr "" 2355"<funcdef>boolean <function>ST_IsCollection</function></funcdef> " 2356"<paramdef><type>geometry </type> <parameter>g</parameter></paramdef>" 2357 2358#. Tag: para 2359#: reference_accessor.xml:1058 2360#, fuzzy, no-c-format 2361msgid "" 2362"Returns <varname>TRUE</varname> if the geometry type of the argument a " 2363"geometry collection type. Collection types are the following:" 2364msgstr "Renvoie <varname>TRUE</varname> le type de la géométrie est soit:" 2365 2366#. Tag: para 2367#: reference_accessor.xml:1061 2368#, no-c-format 2369msgid "GEOMETRYCOLLECTION" 2370msgstr "GEOMETRYCOLLECTION" 2371 2372#. Tag: para 2373#: reference_accessor.xml:1062 2374#, no-c-format 2375msgid "MULTI{POINT,POLYGON,LINESTRING,CURVE,SURFACE}" 2376msgstr "MULTI{POINT,POLYGON,LINESTRING,CURVE,SURFACE}" 2377 2378#. Tag: para 2379#: reference_accessor.xml:1063 2380#, no-c-format 2381msgid "COMPOUNDCURVE" 2382msgstr "COMPOUNDCURVE" 2383 2384#. Tag: para 2385#: reference_accessor.xml:1068 2386#, no-c-format 2387msgid "" 2388"This function analyzes the type of the geometry. This means that it will " 2389"return <varname>TRUE</varname> on collections that are empty or that contain " 2390"a single element." 2391msgstr "" 2392"Cette fonction analyse le type de la géométrie. Renvoie <varname>TRUE</" 2393"varname> pour les collections vides ou ne contenant q'un seul élément." 2394 2395#. Tag: programlisting 2396#: reference_accessor.xml:1083 2397#, no-c-format 2398msgid "" 2399"postgis=# SELECT ST_IsCollection('LINESTRING(0 0, 1 1)'::geometry);\n" 2400" st_iscollection\n" 2401"-------------\n" 2402" f\n" 2403"(1 row)\n" 2404"\n" 2405"postgis=# SELECT ST_IsCollection('MULTIPOINT EMPTY'::geometry);\n" 2406" st_iscollection\n" 2407"-------------\n" 2408" t\n" 2409"(1 row)\n" 2410"\n" 2411"postgis=# SELECT ST_IsCollection('MULTIPOINT((0 0))'::geometry);\n" 2412" st_iscollection\n" 2413"-------------\n" 2414" t\n" 2415"(1 row)\n" 2416"\n" 2417"postgis=# SELECT ST_IsCollection('MULTIPOINT((0 0), (42 42))'::geometry);\n" 2418" st_iscollection\n" 2419"-------------\n" 2420" t\n" 2421"(1 row)\n" 2422"\n" 2423"postgis=# SELECT ST_IsCollection('GEOMETRYCOLLECTION(POINT(0 0))'::" 2424"geometry);\n" 2425" st_iscollection\n" 2426"-------------\n" 2427" t\n" 2428"(1 row)" 2429msgstr "" 2430"postgis=# SELECT ST_IsCollection('LINESTRING(0 0, 1 1)'::geometry);\n" 2431" st_iscollection\n" 2432"-------------\n" 2433" f\n" 2434"(1 row)\n" 2435"\n" 2436"postgis=# SELECT ST_IsCollection('MULTIPOINT EMPTY'::geometry);\n" 2437" st_iscollection\n" 2438"-------------\n" 2439" t\n" 2440"(1 row)\n" 2441"\n" 2442"postgis=# SELECT ST_IsCollection('MULTIPOINT((0 0))'::geometry);\n" 2443" st_iscollection\n" 2444"-------------\n" 2445" t\n" 2446"(1 row)\n" 2447"\n" 2448"postgis=# SELECT ST_IsCollection('MULTIPOINT((0 0), (42 42))'::geometry);\n" 2449" st_iscollection\n" 2450"-------------\n" 2451" t\n" 2452"(1 row)\n" 2453"\n" 2454"postgis=# SELECT ST_IsCollection('GEOMETRYCOLLECTION(POINT(0 0))'::" 2455"geometry);\n" 2456" st_iscollection\n" 2457"-------------\n" 2458" t\n" 2459"(1 row)" 2460 2461#. Tag: refname 2462#: reference_accessor.xml:1095 2463#, no-c-format 2464msgid "ST_IsEmpty" 2465msgstr "ST_IsEmpty" 2466 2467#. Tag: refpurpose 2468#: reference_accessor.xml:1097 2469#, no-c-format 2470msgid "Tests if a geometry is empty." 2471msgstr "" 2472 2473#. Tag: funcprototype 2474#: reference_accessor.xml:1103 2475#, no-c-format 2476msgid "" 2477"<funcdef>boolean <function>ST_IsEmpty</function></funcdef> " 2478"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 2479msgstr "" 2480"<funcdef>boolean <function>ST_IsEmpty</function></funcdef> " 2481"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 2482 2483#. Tag: para 2484#: reference_accessor.xml:1113 2485#, no-c-format 2486msgid "" 2487"Returns true if this Geometry is an empty geometry. If true, then this " 2488"Geometry represents an empty geometry collection, polygon, point etc." 2489msgstr "" 2490"Renvoie vrai si la géométrie est une géométrie vide. Si le résultat est " 2491"vrai alors cette géométrie représente une geometrycollection vide, un " 2492"polygon, un point etc. " 2493 2494#. Tag: para 2495#: reference_accessor.xml:1116 2496#, no-c-format 2497msgid "" 2498"SQL-MM defines the result of ST_IsEmpty(NULL) to be 0, while PostGIS returns " 2499"NULL." 2500msgstr "" 2501"La norme SQL-MM stipule que ST_IsEmpty(NULL) doit renvoyer 0. PostGIS " 2502"renvoie NULL." 2503 2504#. Tag: para 2505#: reference_accessor.xml:1121 2506#, no-c-format 2507msgid "&sqlmm_compliant; SQL-MM 3: 5.1.7" 2508msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.7" 2509 2510#. Tag: para 2511#: reference_accessor.xml:1123 2512#, no-c-format 2513msgid "" 2514"Changed: 2.0.0 In prior versions of PostGIS " 2515"ST_GeomFromText('GEOMETRYCOLLECTION(EMPTY)') was allowed. This is now " 2516"illegal in PostGIS 2.0.0 to better conform with SQL/MM standards" 2517msgstr "" 2518"Changement: 2.0.0 dans les version précédentes de PostGIS " 2519"ST_GeomFromText('GEOMETRYCOLLECTION(EMPTY)') etait autorisé. C'est désormais " 2520"interdit dans PostGIS 2.0.0 pour respecter la norme SQL/MM." 2521 2522#. Tag: programlisting 2523#: reference_accessor.xml:1131 2524#, no-c-format 2525msgid "" 2526"SELECT ST_IsEmpty(ST_GeomFromText('GEOMETRYCOLLECTION EMPTY'));\n" 2527" st_isempty\n" 2528"------------\n" 2529" t\n" 2530"(1 row)\n" 2531"\n" 2532" SELECT ST_IsEmpty(ST_GeomFromText('POLYGON EMPTY'));\n" 2533" st_isempty\n" 2534"------------\n" 2535" t\n" 2536"(1 row)\n" 2537"\n" 2538"SELECT ST_IsEmpty(ST_GeomFromText('POLYGON((1 2, 3 4, 5 6, 1 2))'));\n" 2539"\n" 2540" st_isempty\n" 2541"------------\n" 2542" f\n" 2543"(1 row)\n" 2544"\n" 2545" SELECT ST_IsEmpty(ST_GeomFromText('POLYGON((1 2, 3 4, 5 6, 1 2))')) = " 2546"false;\n" 2547" ?column?\n" 2548"----------\n" 2549" t\n" 2550"(1 row)\n" 2551"\n" 2552" SELECT ST_IsEmpty(ST_GeomFromText('CIRCULARSTRING EMPTY'));\n" 2553" st_isempty\n" 2554"------------\n" 2555" t\n" 2556"(1 row)" 2557msgstr "" 2558"SELECT ST_IsEmpty(ST_GeomFromText('GEOMETRYCOLLECTION EMPTY'));\n" 2559" st_isempty\n" 2560"------------\n" 2561" t\n" 2562"(1 row)\n" 2563"\n" 2564" SELECT ST_IsEmpty(ST_GeomFromText('POLYGON EMPTY'));\n" 2565" st_isempty\n" 2566"------------\n" 2567" t\n" 2568"(1 row)\n" 2569"\n" 2570"SELECT ST_IsEmpty(ST_GeomFromText('POLYGON((1 2, 3 4, 5 6, 1 2))'));\n" 2571"\n" 2572" st_isempty\n" 2573"------------\n" 2574" f\n" 2575"(1 row)\n" 2576"\n" 2577" SELECT ST_IsEmpty(ST_GeomFromText('POLYGON((1 2, 3 4, 5 6, 1 2))')) = " 2578"false;\n" 2579" ?column?\n" 2580"----------\n" 2581" t\n" 2582"(1 row)\n" 2583"\n" 2584" SELECT ST_IsEmpty(ST_GeomFromText('CIRCULARSTRING EMPTY'));\n" 2585" st_isempty\n" 2586"------------\n" 2587" t\n" 2588"(1 row)" 2589 2590#. Tag: refname 2591#: reference_accessor.xml:1138 2592#, no-c-format 2593msgid "ST_IsRing" 2594msgstr "ST_IsRing" 2595 2596#. Tag: refpurpose 2597#: reference_accessor.xml:1140 2598#, no-c-format 2599msgid "Tests if a LineString is closed and simple." 2600msgstr "" 2601 2602#. Tag: funcprototype 2603#: reference_accessor.xml:1145 2604#, no-c-format 2605msgid "" 2606"<funcdef>boolean <function>ST_IsRing</function></funcdef> " 2607"<paramdef><type>geometry </type> <parameter>g</parameter></paramdef>" 2608msgstr "" 2609"<funcdef>boolean <function>ST_IsRing</function></funcdef> " 2610"<paramdef><type>geometry </type> <parameter>g</parameter></paramdef>" 2611 2612#. Tag: para 2613#: reference_accessor.xml:1156 2614#, no-c-format 2615msgid "" 2616"Returns <varname>TRUE</varname> if this <varname>LINESTRING</varname> is " 2617"both <xref linkend=\"ST_IsClosed\"/> (<function>ST_StartPoint(<parameter>g</" 2618"parameter>)</function> <function>~=</function> " 2619"<function>ST_Endpoint(<parameter>g</parameter>)</function>) and <xref " 2620"linkend=\"ST_IsSimple\"/> (does not self intersect)." 2621msgstr "" 2622"Renvoie <varname>TRUE</varname> si cette <varname>LINESTRING</varname> est à " 2623"la fois <xref linkend=\"ST_IsClosed\"/> " 2624"(<function>ST_StartPoint(<parameter>g</parameter>)</function> <function>~=</" 2625"function> <function>ST_Endpoint(<parameter>g</parameter>)</function>) et " 2626"<xref linkend=\"ST_IsSimple\"/> (pas d'auto intersection)." 2627 2628#. Tag: para 2629#: reference_accessor.xml:1164 2630#, no-c-format 2631msgid "&sqlmm_compliant; SQL-MM 3: 7.1.6" 2632msgstr "&sqlmm_compliant; SQL-MM 3: 7.1.6" 2633 2634#. Tag: para 2635#: reference_accessor.xml:1166 2636#, no-c-format 2637msgid "" 2638"SQL-MM defines the result of <function>ST_IsRing(<varname>NULL</varname>)</" 2639"function> to be 0, while PostGIS returns <varname>NULL</varname>." 2640msgstr "" 2641"La norme SQL-MM stipule que <function>ST_IsRing(<varname>NULL</varname>)</" 2642"function> doit renvoyer 0. PostGIS renvoie <varname>NULL</varname>." 2643 2644#. Tag: programlisting 2645#: reference_accessor.xml:1175 2646#, no-c-format 2647msgid "" 2648"SELECT ST_IsRing(the_geom), ST_IsClosed(the_geom), ST_IsSimple(the_geom)\n" 2649"FROM (SELECT 'LINESTRING(0 0, 0 1, 1 1, 1 0, 0 0)'::geometry AS the_geom) AS " 2650"foo;\n" 2651" st_isring | st_isclosed | st_issimple\n" 2652"-----------+-------------+-------------\n" 2653" t | t | t\n" 2654"(1 row)\n" 2655"\n" 2656"SELECT ST_IsRing(the_geom), ST_IsClosed(the_geom), ST_IsSimple(the_geom)\n" 2657"FROM (SELECT 'LINESTRING(0 0, 0 1, 1 0, 1 1, 0 0)'::geometry AS the_geom) AS " 2658"foo;\n" 2659" st_isring | st_isclosed | st_issimple\n" 2660"-----------+-------------+-------------\n" 2661" f | t | f\n" 2662"(1 row)" 2663msgstr "" 2664"SELECT ST_IsRing(the_geom), ST_IsClosed(the_geom), ST_IsSimple(the_geom)\n" 2665"FROM (SELECT 'LINESTRING(0 0, 0 1, 1 1, 1 0, 0 0)'::geometry AS the_geom) AS " 2666"foo;\n" 2667" st_isring | st_isclosed | st_issimple\n" 2668"-----------+-------------+-------------\n" 2669" t | t | t\n" 2670"(1 row)\n" 2671"\n" 2672"SELECT ST_IsRing(the_geom), ST_IsClosed(the_geom), ST_IsSimple(the_geom)\n" 2673"FROM (SELECT 'LINESTRING(0 0, 0 1, 1 0, 1 1, 0 0)'::geometry AS the_geom) AS " 2674"foo;\n" 2675" st_isring | st_isclosed | st_issimple\n" 2676"-----------+-------------+-------------\n" 2677" f | t | f\n" 2678"(1 row)" 2679 2680#. Tag: para 2681#: reference_accessor.xml:1181 2682#, no-c-format 2683msgid "" 2684", <xref linkend=\"ST_IsSimple\"/>, <xref linkend=\"ST_StartPoint\"/>, <xref " 2685"linkend=\"ST_EndPoint\"/>" 2686msgstr "" 2687", <xref linkend=\"ST_IsSimple\"/>, <xref linkend=\"ST_StartPoint\"/>, <xref " 2688"linkend=\"ST_EndPoint\"/>" 2689 2690#. Tag: refname 2691#: reference_accessor.xml:1189 2692#, no-c-format 2693msgid "ST_IsSimple" 2694msgstr "ST_IsSimple" 2695 2696#. Tag: refpurpose 2697#: reference_accessor.xml:1191 2698#, fuzzy, no-c-format 2699msgid "" 2700"Tests if a geometry has no points of self-intersection or self-tangency." 2701msgstr "" 2702"Renvoie (TRUE) si cette géométrie ne présente pas d'anomalie comme une auto " 2703"intersection ou des segments tangentiels." 2704 2705#. Tag: funcprototype 2706#: reference_accessor.xml:1196 2707#, no-c-format 2708msgid "" 2709"<funcdef>boolean <function>ST_IsSimple</function></funcdef> " 2710"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 2711msgstr "" 2712"<funcdef>boolean <function>ST_IsSimple</function></funcdef> " 2713"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 2714 2715#. Tag: para 2716#: reference_accessor.xml:1206 2717#, no-c-format 2718msgid "" 2719"Returns true if this Geometry has no anomalous geometric points, such as " 2720"self intersection or self tangency. For more information on the OGC's " 2721"definition of geometry simplicity and validity, refer to <link linkend=" 2722"\"OGC_Validity\">\"Ensuring OpenGIS compliancy of geometries\"</link>" 2723msgstr "" 2724"Renvoie TRUE si cette géométrie ne présente pas d'anomalie comme une auto " 2725"intersection ou des segments tangentiels. Pour plus d'information sur les " 2726"notions OGC de simplicité et de validité, se référer à <link linkend=" 2727"\"OGC_Validity\">\"Ensuring OpenGIS compliancy of geometries\"</link>" 2728 2729#. Tag: para 2730#: reference_accessor.xml:1212 2731#, no-c-format 2732msgid "" 2733"SQL-MM defines the result of ST_IsSimple(NULL) to be 0, while PostGIS " 2734"returns NULL." 2735msgstr "" 2736"La norme SQL-MM indique que le résultat de la fonction <function> " 2737"ST_IsSimple(<varname>NULL</varname>)</function> doit être 0 ; PostGIS " 2738"renvoie <varname>NULL</varname>." 2739 2740#. Tag: para 2741#: reference_accessor.xml:1217 2742#, no-c-format 2743msgid "&sqlmm_compliant; SQL-MM 3: 5.1.8" 2744msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.8" 2745 2746#. Tag: programlisting 2747#: reference_accessor.xml:1225 2748#, no-c-format 2749msgid "" 2750"SELECT ST_IsSimple(ST_GeomFromText('POLYGON((1 2, 3 4, 5 6, 1 2))'));\n" 2751" st_issimple\n" 2752"-------------\n" 2753" t\n" 2754"(1 row)\n" 2755"\n" 2756" SELECT ST_IsSimple(ST_GeomFromText('LINESTRING(1 1,2 2,2 3.5,1 3,1 2,2 " 2757"1)'));\n" 2758" st_issimple\n" 2759"-------------\n" 2760" f\n" 2761"(1 row)" 2762msgstr "" 2763"SELECT ST_IsSimple(ST_GeomFromText('POLYGON((1 2, 3 4, 5 6, 1 2))'));\n" 2764" st_issimple\n" 2765"-------------\n" 2766" t\n" 2767"(1 row)\n" 2768"\n" 2769" SELECT ST_IsSimple(ST_GeomFromText('LINESTRING(1 1,2 2,2 3.5,1 3,1 2,2 " 2770"1)'));\n" 2771" st_issimple\n" 2772"-------------\n" 2773" f\n" 2774"(1 row)" 2775 2776#. Tag: refname 2777#: reference_accessor.xml:1237 2778#, no-c-format 2779msgid "ST_M" 2780msgstr "ST_M" 2781 2782#. Tag: refpurpose 2783#: reference_accessor.xml:1239 2784#, no-c-format 2785msgid "Returns the M coordinate of a Point." 2786msgstr "" 2787 2788#. Tag: funcprototype 2789#: reference_accessor.xml:1244 2790#, no-c-format 2791msgid "" 2792"<funcdef>float <function>ST_M</function></funcdef> <paramdef><type>geometry " 2793"</type> <parameter>a_point</parameter></paramdef>" 2794msgstr "" 2795"<funcdef>float <function>ST_M</function></funcdef> <paramdef><type>geometry " 2796"</type> <parameter>a_point</parameter></paramdef>" 2797 2798#. Tag: para 2799#: reference_accessor.xml:1254 2800#, fuzzy, no-c-format 2801msgid "" 2802"Return the M coordinate of a Point, or NULL if not available. Input must be " 2803"a Point." 2804msgstr "" 2805"Retourne les coordonnées M d'un point, ou NULL si non disponible. L'entrée " 2806"doit être un point." 2807 2808#. Tag: para 2809#: reference_accessor.xml:1258 2810#, no-c-format 2811msgid "" 2812"This is not (yet) part of the OGC spec, but is listed here to complete the " 2813"point coordinate extractor function list." 2814msgstr "" 2815 2816#. Tag: para 2817#: reference_accessor.xml:1262 reference_accessor.xml:2035 2818#, no-c-format 2819msgid "&sqlmm_compliant;" 2820msgstr "&sqlmm_compliant;" 2821 2822#. Tag: programlisting 2823#: reference_accessor.xml:1270 2824#, no-c-format 2825msgid "" 2826"SELECT ST_M(ST_GeomFromEWKT('POINT(1 2 3 4)'));\n" 2827" st_m\n" 2828"------\n" 2829" 4\n" 2830"(1 row)" 2831msgstr "" 2832"SELECT ST_M(ST_GeomFromEWKT('POINT(1 2 3 4)'));\n" 2833"st_m\n" 2834"------\n" 2835"4\n" 2836"(1 row)" 2837 2838#. Tag: para 2839#: reference_accessor.xml:1277 2840#, no-c-format 2841msgid "" 2842", <xref linkend=\"ST_X\"/>, <xref linkend=\"ST_Y\"/>, <xref linkend=\"ST_Z\"/" 2843">" 2844msgstr "" 2845", <xref linkend=\"ST_X\"/>, <xref linkend=\"ST_Y\"/>, <xref linkend=\"ST_Z\"/" 2846">" 2847 2848#. Tag: refname 2849#: reference_accessor.xml:1283 2850#, no-c-format 2851msgid "ST_MemSize" 2852msgstr "" 2853 2854#. Tag: refpurpose 2855#: reference_accessor.xml:1285 2856#, fuzzy, no-c-format 2857msgid "Returns the amount of memory space a geometry takes." 2858msgstr "Renvoie le type de la géométrie passée en paramètre." 2859 2860#. Tag: funcprototype 2861#: reference_accessor.xml:1290 2862#, fuzzy, no-c-format 2863msgid "" 2864"<funcdef>integer <function>ST_MemSize</function></funcdef> " 2865"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 2866msgstr "" 2867"<funcdef>integer <function>ST_NRings</function></funcdef> " 2868"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 2869 2870#. Tag: para 2871#: reference_accessor.xml:1300 2872#, fuzzy, no-c-format 2873msgid "Returns the amount of memory space (in bytes) the geometry takes." 2874msgstr "Renvoie le type de la géométrie passée en paramètre." 2875 2876#. Tag: para 2877#: reference_accessor.xml:1301 2878#, no-c-format 2879msgid "" 2880"This complements the PostgreSQL built-in <ulink url=\"https://www.postgresql." 2881"org/docs/current/functions-admin.html#FUNCTIONS-ADMIN-DBOBJECT\">database " 2882"object functions</ulink> pg_column_size, pg_size_pretty, pg_relation_size, " 2883"pg_total_relation_size." 2884msgstr "" 2885 2886#. Tag: para 2887#: reference_accessor.xml:1303 2888#, no-c-format 2889msgid "" 2890"pg_relation_size which gives the byte size of a table may return byte size " 2891"lower than ST_MemSize. This is because pg_relation_size does not add toasted " 2892"table contribution and large geometries are stored in TOAST tables." 2893msgstr "" 2894 2895#. Tag: para 2896#: reference_accessor.xml:1305 2897#, no-c-format 2898msgid "" 2899"pg_total_relation_size - includes, the table, the toasted tables, and the " 2900"indexes." 2901msgstr "" 2902 2903#. Tag: para 2904#: reference_accessor.xml:1306 2905#, no-c-format 2906msgid "" 2907"pg_column_size returns how much space a geometry would take in a column " 2908"considering compression, so may be lower than ST_MemSize" 2909msgstr "" 2910 2911#. Tag: para 2912#: reference_accessor.xml:1313 2913#, no-c-format 2914msgid "Changed: 2.2.0 name changed to ST_MemSize to follow naming convention." 2915msgstr "" 2916 2917#. Tag: programlisting 2918#: reference_accessor.xml:1320 2919#, no-c-format 2920msgid "" 2921"--Return how much byte space Boston takes up in our Mass data set\n" 2922"SELECT pg_size_pretty(SUM(ST_MemSize(the_geom))) as totgeomsum,\n" 2923"pg_size_pretty(SUM(CASE WHEN town = 'BOSTON' THEN ST_MemSize(the_geom) ELSE " 2924"0 END)) As bossum,\n" 2925"CAST(SUM(CASE WHEN town = 'BOSTON' THEN ST_MemSize(the_geom) ELSE 0 " 2926"END)*1.00 /\n" 2927" SUM(ST_MemSize(the_geom))*100 As numeric(10,2)) As perbos\n" 2928"FROM towns;\n" 2929"\n" 2930"totgeomsum bossum perbos\n" 2931"---------- ------ ------\n" 2932"1522 kB 30 kB 1.99\n" 2933"\n" 2934"\n" 2935"SELECT ST_MemSize(ST_GeomFromText('CIRCULARSTRING(220268 150415,220227 " 2936"150505,220227 150406)'));\n" 2937"\n" 2938"---\n" 2939"73\n" 2940"\n" 2941"--What percentage of our table is taken up by just the geometry\n" 2942"SELECT pg_total_relation_size('public.neighborhoods') As fulltable_size, " 2943"sum(ST_MemSize(the_geom)) As geomsize,\n" 2944"sum(ST_MemSize(the_geom))*1.00/pg_total_relation_size('public." 2945"neighborhoods')*100 As pergeom\n" 2946"FROM neighborhoods;\n" 2947"fulltable_size geomsize pergeom\n" 2948"------------------------------------------------\n" 2949"262144 96238 36.71188354492187500000" 2950msgstr "" 2951 2952#. Tag: refname 2953#: reference_accessor.xml:1327 2954#, no-c-format 2955msgid "ST_NDims" 2956msgstr "ST_NDims" 2957 2958#. Tag: refpurpose 2959#: reference_accessor.xml:1328 2960#, fuzzy, no-c-format 2961msgid "Returns the coordinate dimension of a geometry." 2962msgstr "Retourne la dimension des coordonnées d'une valeur ST_Geometry." 2963 2964#. Tag: funcprototype 2965#: reference_accessor.xml:1333 2966#, no-c-format 2967msgid "" 2968"<funcdef>integer <function>ST_NDims</function></funcdef> " 2969"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 2970msgstr "" 2971"<funcdef>integer <function>ST_NDims</function></funcdef> " 2972"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 2973 2974#. Tag: para 2975#: reference_accessor.xml:1343 2976#, no-c-format 2977msgid "" 2978"Returns the coordinate dimension of the geometry. PostGIS supports 2 - (x," 2979"y) , 3 - (x,y,z) or 2D with measure - x,y,m, and 4 - 3D with measure space x," 2980"y,z,m" 2981msgstr "" 2982 2983#. Tag: programlisting 2984#: reference_accessor.xml:1352 2985#, no-c-format 2986msgid "" 2987"SELECT ST_NDims(ST_GeomFromText('POINT(1 1)')) As d2point,\n" 2988" ST_NDims(ST_GeomFromEWKT('POINT(1 1 2)')) As d3point,\n" 2989" ST_NDims(ST_GeomFromEWKT('POINTM(1 1 0.5)')) As d2pointm;\n" 2990"\n" 2991" d2point | d3point | d2pointm\n" 2992"---------+---------+----------\n" 2993" 2 | 3 | 3" 2994msgstr "" 2995"SELECT ST_NDims(ST_GeomFromText('POINT(1 1)')) As d2point,\n" 2996"ST_NDims(ST_GeomFromEWKT('POINT(1 1 2)')) As d3point,\n" 2997"ST_NDims(ST_GeomFromEWKT('POINTM(1 1 0.5)')) As d2pointm;\n" 2998"\n" 2999"d2point | d3point | d2pointm\n" 3000"---------+---------+----------\n" 3001"2 | 3 | 3" 3002 3003#. Tag: para 3004#: reference_accessor.xml:1356 3005#, no-c-format 3006msgid ", <xref linkend=\"ST_Dimension\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>" 3007msgstr "" 3008", <xref linkend=\"ST_Dimension\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>" 3009 3010#. Tag: refname 3011#: reference_accessor.xml:1362 3012#, no-c-format 3013msgid "ST_NPoints" 3014msgstr "ST_NPoints" 3015 3016#. Tag: refpurpose 3017#: reference_accessor.xml:1363 3018#, fuzzy, no-c-format 3019msgid "Returns the number of points (vertices) in a geometry." 3020msgstr "Retourne le nombre de points (vertex) d'un objet géométrique." 3021 3022#. Tag: funcprototype 3023#: reference_accessor.xml:1368 3024#, no-c-format 3025msgid "" 3026"<funcdef>integer <function>ST_NPoints</function></funcdef> " 3027"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 3028msgstr "" 3029"<funcdef>integer <function>ST_NPoints</function></funcdef> " 3030"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 3031 3032#. Tag: para 3033#: reference_accessor.xml:1378 3034#, no-c-format 3035msgid "Return the number of points in a geometry. Works for all geometries." 3036msgstr "" 3037"Retourne le nombre de points d'un objet géométrique. Cela fonctionne pour " 3038"tous les types de géométrie. " 3039 3040#. Tag: programlisting 3041#: reference_accessor.xml:1390 3042#, no-c-format 3043msgid "" 3044"SELECT ST_NPoints(ST_GeomFromText('LINESTRING(77.29 29.07,77.42 29.26,77.27 " 3045"29.31,77.29 29.07)'));\n" 3046"--result\n" 3047"4\n" 3048"\n" 3049"--Polygon in 3D space\n" 3050"SELECT ST_NPoints(ST_GeomFromEWKT('LINESTRING(77.29 29.07 1,77.42 29.26 " 3051"0,77.27 29.31 -1,77.29 29.07 3)'))\n" 3052"--result\n" 3053"4" 3054msgstr "" 3055"SELECT ST_NPoints(ST_GeomFromText('LINESTRING(77.29 29.07,77.42 29.26,77.27 " 3056"29.31,77.29 29.07)'));\n" 3057"--result\n" 3058"4\n" 3059"\n" 3060"--Polygon dans un espace en 3 Dimension\n" 3061"SELECT ST_NPoints(ST_GeomFromEWKT('LINESTRING(77.29 29.07 1,77.42 29.26 " 3062"0,77.27 29.31 -1,77.29 29.07 3)'))\n" 3063"--result\n" 3064"4" 3065 3066#. Tag: refname 3067#: reference_accessor.xml:1401 3068#, no-c-format 3069msgid "ST_NRings" 3070msgstr "ST_NRings" 3071 3072#. Tag: refpurpose 3073#: reference_accessor.xml:1402 3074#, fuzzy, no-c-format 3075msgid "Returns the number of rings in a polygonal geometry." 3076msgstr "Retourne le nombre de points (vertex) d'un objet géométrique." 3077 3078#. Tag: funcprototype 3079#: reference_accessor.xml:1407 3080#, no-c-format 3081msgid "" 3082"<funcdef>integer <function>ST_NRings</function></funcdef> " 3083"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 3084msgstr "" 3085"<funcdef>integer <function>ST_NRings</function></funcdef> " 3086"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 3087 3088#. Tag: para 3089#: reference_accessor.xml:1417 3090#, no-c-format 3091msgid "" 3092"If the geometry is a polygon or multi-polygon returns the number of rings. " 3093"Unlike NumInteriorRings, it counts the outer rings as well." 3094msgstr "" 3095 3096#. Tag: programlisting 3097#: reference_accessor.xml:1427 3098#, no-c-format 3099msgid "" 3100"SELECT ST_NRings(the_geom) As Nrings, ST_NumInteriorRings(the_geom) As " 3101"ninterrings\n" 3102" FROM (SELECT " 3103"ST_GeomFromText('POLYGON((1 2, 3 4, 5 6, 1 2))') As the_geom) As foo;\n" 3104" nrings | ninterrings\n" 3105"--------+-------------\n" 3106" 1 | 0\n" 3107"(1 row)" 3108msgstr "" 3109"SELECT ST_NRings(the_geom) As Nrings, ST_NumInteriorRings(the_geom) As " 3110"ninterrings\n" 3111" FROM (SELECT " 3112"ST_GeomFromText('POLYGON((1 2, 3 4, 5 6, 1 2))') As the_geom) As foo;\n" 3113" nrings | ninterrings\n" 3114"--------+-------------\n" 3115" 1 | 0\n" 3116"(1 row)" 3117 3118#. Tag: refname 3119#: reference_accessor.xml:1440 3120#, no-c-format 3121msgid "ST_NumGeometries" 3122msgstr "ST_NumGeometries" 3123 3124#. Tag: refpurpose 3125#: reference_accessor.xml:1441 3126#, fuzzy, no-c-format 3127msgid "Returns the number of elements in a geometry collection." 3128msgstr "" 3129"Retourne le nombre de points d'un objet géométrique. Cela fonctionne pour " 3130"tous les types de géométrie. " 3131 3132#. Tag: funcprototype 3133#: reference_accessor.xml:1446 3134#, no-c-format 3135msgid "" 3136"<funcdef>integer <function>ST_NumGeometries</function></funcdef> " 3137"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 3138msgstr "" 3139"<funcdef>integer <function>ST_NumGeometries</function></funcdef> " 3140"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 3141 3142#. Tag: para 3143#: reference_accessor.xml:1456 3144#, no-c-format 3145msgid "" 3146"Returns the number of Geometries. If geometry is a GEOMETRYCOLLECTION (or " 3147"MULTI*) return the number of geometries, for single geometries will return " 3148"1, otherwise return NULL." 3149msgstr "" 3150 3151#. Tag: para 3152#: reference_accessor.xml:1460 3153#, no-c-format 3154msgid "" 3155"Changed: 2.0.0 In prior versions this would return NULL if the geometry was " 3156"not a collection/MULTI type. 2.0.0+ now returns 1 for single geometries e.g " 3157"POLYGON, LINESTRING, POINT." 3158msgstr "" 3159 3160#. Tag: para 3161#: reference_accessor.xml:1462 3162#, no-c-format 3163msgid "&sqlmm_compliant; SQL-MM 3: 9.1.4" 3164msgstr "&sqlmm_compliant; SQL-MM 3: 9.1.4" 3165 3166#. Tag: programlisting 3167#: reference_accessor.xml:1472 3168#, no-c-format 3169msgid "" 3170"--Prior versions would have returned NULL for this -- in 2.0.0 this returns " 3171"1\n" 3172"SELECT ST_NumGeometries(ST_GeomFromText('LINESTRING(77.29 29.07,77.42 " 3173"29.26,77.27 29.31,77.29 29.07)'));\n" 3174"--result\n" 3175"1\n" 3176"\n" 3177"--Geometry Collection Example - multis count as one geom in a collection\n" 3178"SELECT ST_NumGeometries(ST_GeomFromEWKT('GEOMETRYCOLLECTION(MULTIPOINT(-2 " 3179"3 , -2 2),\n" 3180"LINESTRING(5 5 ,10 10),\n" 3181"POLYGON((-7 4.2,-7.1 5,-7.1 4.3,-7 4.2)))'));\n" 3182"--result\n" 3183"3" 3184msgstr "" 3185 3186#. Tag: para 3187#: reference_accessor.xml:1477 3188#, no-c-format 3189msgid ", <xref linkend=\"ST_Multi\"/>" 3190msgstr ", <xref linkend=\"ST_Multi\"/>" 3191 3192#. Tag: refname 3193#: reference_accessor.xml:1483 3194#, no-c-format 3195msgid "ST_NumInteriorRings" 3196msgstr "ST_NumInteriorRings" 3197 3198#. Tag: refpurpose 3199#: reference_accessor.xml:1484 3200#, fuzzy, no-c-format 3201msgid "Returns the number of interior rings (holes) of a Polygon." 3202msgstr "Retourne le nombre de points (vertex) d'un objet géométrique." 3203 3204#. Tag: funcprototype 3205#: reference_accessor.xml:1489 3206#, no-c-format 3207msgid "" 3208"<funcdef>integer <function>ST_NumInteriorRings</function></funcdef> " 3209"<paramdef><type>geometry </type> <parameter>a_polygon</parameter></paramdef>" 3210msgstr "" 3211"<funcdef>integer <function>ST_NumInteriorRings</function></funcdef> " 3212"<paramdef><type>geometry </type> <parameter>a_polygon</parameter></paramdef>" 3213 3214#. Tag: para 3215#: reference_accessor.xml:1499 3216#, no-c-format 3217msgid "" 3218"Return the number of interior rings of a polygon geometry. Return NULL if " 3219"the geometry is not a polygon." 3220msgstr "" 3221 3222#. Tag: para 3223#: reference_accessor.xml:1504 3224#, no-c-format 3225msgid "&sqlmm_compliant; SQL-MM 3: 8.2.5" 3226msgstr "&sqlmm_compliant; SQL-MM 3: 8.2.5" 3227 3228#. Tag: para 3229#: reference_accessor.xml:1505 3230#, no-c-format 3231msgid "" 3232"Changed: 2.0.0 - in prior versions it would allow passing a MULTIPOLYGON, " 3233"returning the number of interior rings of first POLYGON." 3234msgstr "" 3235 3236#. Tag: programlisting 3237#: reference_accessor.xml:1511 3238#, no-c-format 3239msgid "" 3240"--If you have a regular polygon\n" 3241"SELECT gid, field1, field2, ST_NumInteriorRings(the_geom) AS numholes\n" 3242"FROM sometable;\n" 3243"\n" 3244"--If you have multipolygons\n" 3245"--And you want to know the total number of interior rings in the " 3246"MULTIPOLYGON\n" 3247"SELECT gid, field1, field2, SUM(ST_NumInteriorRings(the_geom)) AS numholes\n" 3248"FROM (SELECT gid, field1, field2, (ST_Dump(the_geom)).geom As the_geom\n" 3249" FROM sometable) As foo\n" 3250"GROUP BY gid, field1,field2;" 3251msgstr "" 3252 3253#. Tag: refname 3254#: reference_accessor.xml:1522 3255#, no-c-format 3256msgid "ST_NumInteriorRing" 3257msgstr "ST_NumInteriorRing" 3258 3259#. Tag: refpurpose 3260#: reference_accessor.xml:1523 3261#, no-c-format 3262msgid "" 3263"Returns the number of interior rings (holes) of a Polygon. Aias for " 3264"ST_NumInteriorRings" 3265msgstr "" 3266 3267#. Tag: funcprototype 3268#: reference_accessor.xml:1528 3269#, no-c-format 3270msgid "" 3271"<funcdef>integer <function>ST_NumInteriorRing</function></funcdef> " 3272"<paramdef><type>geometry </type> <parameter>a_polygon</parameter></paramdef>" 3273msgstr "" 3274"<funcdef>integer <function>ST_NumInteriorRing</function></funcdef> " 3275"<paramdef><type>geometry </type> <parameter>a_polygon</parameter></paramdef>" 3276 3277#. Tag: refname 3278#: reference_accessor.xml:1544 3279#, no-c-format 3280msgid "ST_NumPatches" 3281msgstr "ST_NumPatches" 3282 3283#. Tag: refpurpose 3284#: reference_accessor.xml:1545 3285#, no-c-format 3286msgid "" 3287"Return the number of faces on a Polyhedral Surface. Will return null for non-" 3288"polyhedral geometries." 3289msgstr "" 3290 3291#. Tag: funcprototype 3292#: reference_accessor.xml:1550 3293#, no-c-format 3294msgid "" 3295"<funcdef>integer <function>ST_NumPatches</function></funcdef> " 3296"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 3297msgstr "" 3298"<funcdef>integer <function>ST_NumPatches</function></funcdef> " 3299"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 3300 3301#. Tag: para 3302#: reference_accessor.xml:1560 3303#, no-c-format 3304msgid "" 3305"Return the number of faces on a Polyhedral Surface. Will return null for non-" 3306"polyhedral geometries. This is an alias for ST_NumGeometries to support MM " 3307"naming. Faster to use ST_NumGeometries if you don't care about MM convention." 3308msgstr "" 3309 3310#. Tag: para 3311#: reference_accessor.xml:1563 reference_accessor.xml:1656 3312#, no-c-format 3313msgid "Availability: 2.0.0" 3314msgstr "Disponibilité : 2.0.0" 3315 3316#. Tag: para 3317#: reference_accessor.xml:1566 reference_accessor.xml:1657 3318#, no-c-format 3319msgid "&sqlmm_compliant; SQL-MM 3: ?" 3320msgstr "&sqlmm_compliant; SQL-MM 3: ?" 3321 3322#. Tag: programlisting 3323#: reference_accessor.xml:1573 3324#, no-c-format 3325msgid "" 3326"SELECT ST_NumPatches(ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 0, 0 0 1, 0 1 " 3327"1, 0 1 0, 0 0 0)),\n" 3328" ((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 " 3329"1, 0 0 1, 0 0 0)),\n" 3330" ((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),\n" 3331" ((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)), ((0 0 1, 1 0 1, 1 1 " 3332"1, 0 1 1, 0 0 1)) )'));\n" 3333" --result\n" 3334" 6" 3335msgstr "" 3336 3337#. Tag: refname 3338#: reference_accessor.xml:1584 3339#, no-c-format 3340msgid "ST_NumPoints" 3341msgstr "ST_NumPoints" 3342 3343#. Tag: refpurpose 3344#: reference_accessor.xml:1585 3345#, fuzzy, no-c-format 3346msgid "Returns the number of points in a LineString or CircularString." 3347msgstr "" 3348"Retourne le nombre de points d'un objet géométrique dans une valeur " 3349"ST_LineString ou ST_CircularString." 3350 3351#. Tag: funcprototype 3352#: reference_accessor.xml:1590 3353#, no-c-format 3354msgid "" 3355"<funcdef>integer <function>ST_NumPoints</function></funcdef> " 3356"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 3357msgstr "" 3358"<funcdef>integer <function>ST_NumPoints</function></funcdef> " 3359"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 3360 3361#. Tag: para 3362#: reference_accessor.xml:1600 3363#, no-c-format 3364msgid "" 3365"Return the number of points in an ST_LineString or ST_CircularString value. " 3366"Prior to 1.4 only works with Linestrings as the specs state. From 1.4 " 3367"forward this is an alias for ST_NPoints which returns number of vertexes for " 3368"not just line strings. Consider using ST_NPoints instead which is multi-" 3369"purpose and works with many geometry types." 3370msgstr "" 3371 3372#. Tag: para 3373#: reference_accessor.xml:1607 3374#, no-c-format 3375msgid "&sqlmm_compliant; SQL-MM 3: 7.2.4" 3376msgstr "&sqlmm_compliant; SQL-MM 3: 7.2.4" 3377 3378#. Tag: programlisting 3379#: reference_accessor.xml:1613 3380#, no-c-format 3381msgid "" 3382"SELECT ST_NumPoints(ST_GeomFromText('LINESTRING(77.29 29.07,77.42 " 3383"29.26,77.27 29.31,77.29 29.07)'));\n" 3384" --result\n" 3385" 4" 3386msgstr "" 3387"SELECT ST_NumPoints(ST_GeomFromText('LINESTRING(77.29 29.07,77.42 " 3388"29.26,77.27 29.31,77.29 29.07)'));\n" 3389"--result\n" 3390"4" 3391 3392#. Tag: refname 3393#: reference_accessor.xml:1624 3394#, no-c-format 3395msgid "ST_PatchN" 3396msgstr "ST_PatchN" 3397 3398#. Tag: refpurpose 3399#: reference_accessor.xml:1626 3400#, fuzzy, no-c-format 3401msgid "Returns the Nth geometry (face) of a PolyhedralSurface." 3402msgstr "Renvoie le type de la géométrie passée en paramètre." 3403 3404#. Tag: funcprototype 3405#: reference_accessor.xml:1631 3406#, no-c-format 3407msgid "" 3408"<funcdef>geometry <function>ST_PatchN</function></funcdef> " 3409"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 3410"<paramdef><type>integer </type> <parameter>n</parameter></paramdef>" 3411msgstr "" 3412"<funcdef>geometry <function>ST_PatchN</function></funcdef> " 3413"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 3414"<paramdef><type>integer </type> <parameter>n</parameter></paramdef>" 3415 3416#. Tag: para 3417#: reference_accessor.xml:1642 3418#, no-c-format 3419msgid "" 3420">Returns the 1-based Nth geometry (face) if the geometry is a " 3421"POLYHEDRALSURFACE or POLYHEDRALSURFACEM. Otherwise, returns NULL. This " 3422"returns the same answer as ST_GeometryN for PolyhedralSurfaces. Using " 3423"ST_GeometryN is faster." 3424msgstr "" 3425 3426#. Tag: para 3427#: reference_accessor.xml:1649 3428#, no-c-format 3429msgid "Index is 1-based." 3430msgstr "" 3431 3432#. Tag: para 3433#: reference_accessor.xml:1653 3434#, fuzzy, no-c-format 3435msgid "" 3436"If you want to extract all elements of a geometry <xref linkend=\"ST_Dump\"/" 3437"> is more efficient." 3438msgstr "" 3439"Si toutes les géométries composant une géométrie doivent être extraites, " 3440"ST_Dump sera plus efficace." 3441 3442#. Tag: programlisting 3443#: reference_accessor.xml:1667 3444#, no-c-format 3445msgid "" 3446"--Extract the 2nd face of the polyhedral surface\n" 3447"SELECT ST_AsEWKT(ST_PatchN(geom, 2)) As geomewkt\n" 3448"FROM (\n" 3449"VALUES (ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 0, 0 0 1, 0 1 1, 0 1 0, 0 " 3450"0 0)),\n" 3451" ((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 1, 0 0 1, " 3452"0 0 0)),\n" 3453" ((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),\n" 3454" ((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)), ((0 0 1, 1 0 1, 1 1 1, 0 1 1, " 3455"0 0 1)) )')) ) As foo(geom);\n" 3456"\n" 3457" geomewkt\n" 3458"---+-----------------------------------------\n" 3459" POLYGON((0 0 0,0 1 0,1 1 0,1 0 0,0 0 0))" 3460msgstr "" 3461 3462#. Tag: para 3463#: reference_accessor.xml:1674 3464#, no-c-format 3465msgid "" 3466", <xref linkend=\"ST_GeomFromEWKT\"/>, <xref linkend=\"ST_Dump\"/>, <xref " 3467"linkend=\"ST_GeometryN\"/>, <xref linkend=\"ST_NumGeometries\"/>" 3468msgstr "" 3469", <xref linkend=\"ST_GeomFromEWKT\"/>, <xref linkend=\"ST_Dump\"/>, <xref " 3470"linkend=\"ST_GeometryN\"/>, <xref linkend=\"ST_NumGeometries\"/>" 3471 3472#. Tag: refname 3473#: reference_accessor.xml:1680 3474#, no-c-format 3475msgid "ST_PointN" 3476msgstr "ST_PointN" 3477 3478#. Tag: refpurpose 3479#: reference_accessor.xml:1682 3480#, fuzzy, no-c-format 3481msgid "" 3482"Returns the Nth point in the first LineString or circular LineString in a " 3483"geometry." 3484msgstr "" 3485"Retourne le nombre de points d'un objet géométrique dans une valeur " 3486"ST_LineString ou ST_CircularString." 3487 3488#. Tag: funcprototype 3489#: reference_accessor.xml:1688 3490#, no-c-format 3491msgid "" 3492"<funcdef>geometry <function>ST_PointN</function></funcdef> " 3493"<paramdef><type>geometry </type> <parameter>a_linestring</parameter></" 3494"paramdef> <paramdef><type>integer </type> <parameter>n</parameter></paramdef>" 3495msgstr "" 3496"<funcdef>geometry <function>ST_PointN</function></funcdef> " 3497"<paramdef><type>geometry </type> <parameter>a_linestring</parameter></" 3498"paramdef> <paramdef><type>integer </type> <parameter>n</parameter></paramdef>" 3499 3500#. Tag: para 3501#: reference_accessor.xml:1699 3502#, no-c-format 3503msgid "" 3504"Return the Nth point in a single linestring or circular linestring in the " 3505"geometry. Negative values are counted backwards from the end of the " 3506"LineString, so that -1 is the last point. Returns NULL if there is no " 3507"linestring in the geometry." 3508msgstr "" 3509 3510#. Tag: para 3511#: reference_accessor.xml:1704 3512#, no-c-format 3513msgid "" 3514"Index is 1-based as for OGC specs since version 0.8.0. Backward indexing " 3515"(negative index) is not in OGC Previous versions implemented this as 0-based " 3516"instead." 3517msgstr "" 3518 3519#. Tag: para 3520#: reference_accessor.xml:1710 3521#, no-c-format 3522msgid "" 3523"If you want to get the Nth point of each LineString in a MultiLineString, " 3524"use in conjunction with ST_Dump" 3525msgstr "" 3526 3527#. Tag: para 3528#: reference_accessor.xml:1715 3529#, no-c-format 3530msgid "&sqlmm_compliant; SQL-MM 3: 7.2.5, 7.3.5" 3531msgstr "&sqlmm_compliant; SQL-MM 3: 7.2.5, 7.3.5" 3532 3533#. Tag: para 3534#: reference_accessor.xml:1718 3535#, no-c-format 3536msgid "" 3537"Changed: 2.0.0 no longer works with single geometry multilinestrings. In " 3538"older versions of PostGIS -- a single line multilinestring would work " 3539"happily with this function and return the start point. In 2.0.0 it just " 3540"returns NULL like any other multilinestring." 3541msgstr "" 3542 3543#. Tag: para 3544#: reference_accessor.xml:1721 3545#, no-c-format 3546msgid "Changed: 2.3.0 : negative indexing available (-1 is last point)" 3547msgstr "" 3548 3549#. Tag: programlisting 3550#: reference_accessor.xml:1731 3551#, no-c-format 3552msgid "" 3553"-- Extract all POINTs from a LINESTRING\n" 3554"SELECT ST_AsText(\n" 3555" ST_PointN(\n" 3556" column1,\n" 3557" generate_series(1, ST_NPoints(column1))\n" 3558" ))\n" 3559"FROM ( VALUES ('LINESTRING(0 0, 1 1, 2 2)'::geometry) ) AS foo;\n" 3560"\n" 3561" st_astext\n" 3562"------------\n" 3563" POINT(0 0)\n" 3564" POINT(1 1)\n" 3565" POINT(2 2)\n" 3566"(3 rows)\n" 3567"\n" 3568"--Example circular string\n" 3569"SELECT ST_AsText(ST_PointN(ST_GeomFromText('CIRCULARSTRING(1 2, 3 2, 1 2)'), " 3570"2));\n" 3571"\n" 3572" st_astext\n" 3573"------------\n" 3574" POINT(3 2)\n" 3575"(1 row)\n" 3576"\n" 3577"SELECT ST_AsText(f)\n" 3578"FROM ST_GeomFromText('LINESTRING(0 0 0, 1 1 1, 2 2 2)') AS g\n" 3579" ,ST_PointN(g, -2) AS f; -- 1 based index\n" 3580"\n" 3581" st_astext\n" 3582"-----------------\n" 3583" POINT Z (1 1 1)\n" 3584"(1 row)" 3585msgstr "" 3586 3587#. Tag: refname 3588#: reference_accessor.xml:1743 3589#, no-c-format 3590msgid "ST_Points" 3591msgstr "" 3592 3593#. Tag: refpurpose 3594#: reference_accessor.xml:1744 3595#, no-c-format 3596msgid "Returns a MultiPoint containing all the coordinates of a geometry." 3597msgstr "" 3598 3599#. Tag: funcprototype 3600#: reference_accessor.xml:1750 3601#, no-c-format 3602msgid "" 3603"<funcdef>geometry <function>ST_Points</function></funcdef> <paramdef> " 3604"<type>geometry</type> <parameter>geom</parameter> </paramdef>" 3605msgstr "" 3606 3607#. Tag: para 3608#: reference_accessor.xml:1763 3609#, no-c-format 3610msgid "" 3611"Returns a MultiPoint containing all of the coordinates of a geometry. Does " 3612"not remove points that are duplicated in the input geometry, including start " 3613"and end points of ring geometries. (If this behavior is undesired, " 3614"duplicates may be removed using <xref linkend=\"ST_RemoveRepeatedPoints\"/>)." 3615msgstr "" 3616 3617#. Tag: para 3618#: reference_accessor.xml:1771 3619#, no-c-format 3620msgid "M and Z coordinates will be preserved if present." 3621msgstr "" 3622 3623#. Tag: para 3624#: reference_accessor.xml:1778 3625#, no-c-format 3626msgid "Availability: 2.3.0" 3627msgstr "" 3628 3629#. Tag: programlisting 3630#: reference_accessor.xml:1785 3631#, no-c-format 3632msgid "" 3633"SELECT ST_AsText(ST_Points('POLYGON Z ((30 10 4,10 30 5,40 40 6, 30 " 3634"10))'));\n" 3635"\n" 3636"--result\n" 3637"MULTIPOINT Z (30 10 4,10 30 5,40 40 6, 30 10 4)" 3638msgstr "" 3639"SELECT ST_AsText(ST_Points('POLYGON Z ((30 10 4,10 30 5,40 40 6, 30 " 3640"10))'));\n" 3641"\n" 3642"--result\n" 3643"MULTIPOINT Z (30 10 4,10 30 5,40 40 6, 30 10 4)" 3644 3645#. Tag: refname 3646#: reference_accessor.xml:1796 3647#, no-c-format 3648msgid "ST_StartPoint" 3649msgstr "ST_StartPoint" 3650 3651#. Tag: refpurpose 3652#: reference_accessor.xml:1798 3653#, no-c-format 3654msgid "Returns the first point of a LineString." 3655msgstr "" 3656 3657#. Tag: funcprototype 3658#: reference_accessor.xml:1803 3659#, no-c-format 3660msgid "" 3661"<funcdef>geometry <function>ST_StartPoint</function></funcdef> " 3662"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 3663msgstr "" 3664"<funcdef>geometry <function>ST_StartPoint</function></funcdef> " 3665"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 3666 3667#. Tag: para 3668#: reference_accessor.xml:1814 3669#, no-c-format 3670msgid "" 3671"Returns the first point of a <varname>LINESTRING</varname> or " 3672"<varname>CIRCULARLINESTRING</varname> geometry as a <varname>POINT</varname> " 3673"or <varname>NULL</varname> if the input parameter is not a " 3674"<varname>LINESTRING</varname> or <varname>CIRCULARLINESTRING</varname>." 3675msgstr "" 3676 3677#. Tag: para 3678#: reference_accessor.xml:1818 3679#, no-c-format 3680msgid "&sqlmm_compliant; SQL-MM 3: 7.1.3" 3681msgstr "&sqlmm_compliant; SQL-MM 3: 7.1.3" 3682 3683#. Tag: programlisting 3684#: reference_accessor.xml:1833 3685#, no-c-format 3686msgid "" 3687"SELECT ST_AsText(ST_StartPoint('LINESTRING(0 1, 0 2)'::geometry));\n" 3688" st_astext\n" 3689"------------\n" 3690" POINT(0 1)\n" 3691"(1 row)\n" 3692"\n" 3693"SELECT ST_StartPoint('POINT(0 1)'::geometry) IS NULL AS is_null;\n" 3694" is_null\n" 3695"----------\n" 3696" t\n" 3697"(1 row)\n" 3698"\n" 3699"--3d line\n" 3700"SELECT ST_AsEWKT(ST_StartPoint('LINESTRING(0 1 1, 0 2 2)'::geometry));\n" 3701" st_asewkt\n" 3702"------------\n" 3703" POINT(0 1 1)\n" 3704"(1 row)\n" 3705"\n" 3706"-- circular linestring --\n" 3707"SELECT ST_AsText(ST_StartPoint('CIRCULARSTRING(5 2,-3 1.999999, -2 1, -4 2, " 3708"5 2)'::geometry));\n" 3709" st_astext\n" 3710"------------\n" 3711" POINT(5 2)" 3712msgstr "" 3713 3714#. Tag: para 3715#: reference_accessor.xml:1839 3716#, no-c-format 3717msgid ", <xref linkend=\"ST_PointN\"/>" 3718msgstr ", <xref linkend=\"ST_PointN\"/>" 3719 3720#. Tag: refname 3721#: reference_accessor.xml:1844 3722#, no-c-format 3723msgid "ST_Summary" 3724msgstr "ST_Summary" 3725 3726#. Tag: refpurpose 3727#: reference_accessor.xml:1846 3728#, fuzzy, no-c-format 3729msgid "Returns a text summary of the contents of a geometry." 3730msgstr "Retourne le nombre de points (vertex) d'un objet géométrique." 3731 3732#. Tag: funcsynopsis 3733#: reference_accessor.xml:1851 3734#, no-c-format 3735msgid "" 3736"<funcprototype> <funcdef>text <function>ST_Summary</function></funcdef> " 3737"<paramdef><type>geometry </type> <parameter>g</parameter></paramdef> </" 3738"funcprototype> <funcprototype> <funcdef>text <function>ST_Summary</" 3739"function></funcdef> <paramdef><type>geography </type> <parameter>g</" 3740"parameter></paramdef> </funcprototype>" 3741msgstr "" 3742"<funcprototype> <funcdef>text <function>ST_Summary</function></funcdef> " 3743"<paramdef><type>geometry </type> <parameter>g</parameter></paramdef> </" 3744"funcprototype> <funcprototype> <funcdef>text <function>ST_Summary</" 3745"function></funcdef> <paramdef><type>geography </type> <parameter>g</" 3746"parameter></paramdef> </funcprototype>" 3747 3748#. Tag: para 3749#: reference_accessor.xml:1866 3750#, fuzzy, no-c-format 3751msgid "Returns a text summary of the contents of the geometry." 3752msgstr "Renvoie l'ensemble formant la frontière finie de cette géométrie." 3753 3754#. Tag: para 3755#: reference_accessor.xml:1868 3756#, no-c-format 3757msgid "" 3758"Flags shown square brackets after the geometry type have the following " 3759"meaning:" 3760msgstr "" 3761 3762#. Tag: para 3763#: reference_accessor.xml:1872 3764#, fuzzy, no-c-format 3765msgid "M: has M coordinate" 3766msgstr "M : possède une ordonnée M" 3767 3768#. Tag: para 3769#: reference_accessor.xml:1873 3770#, fuzzy, no-c-format 3771msgid "Z: has Z coordinate" 3772msgstr "Z : possède une coordonnée Z" 3773 3774#. Tag: para 3775#: reference_accessor.xml:1874 3776#, no-c-format 3777msgid "B: has a cached bounding box" 3778msgstr "B : possède une bounding box en cache" 3779 3780#. Tag: para 3781#: reference_accessor.xml:1875 3782#, no-c-format 3783msgid "G: is geodetic (geography)" 3784msgstr "" 3785 3786#. Tag: para 3787#: reference_accessor.xml:1876 3788#, no-c-format 3789msgid "S: has spatial reference system" 3790msgstr "" 3791 3792#. Tag: para 3793#: reference_accessor.xml:1887 3794#, no-c-format 3795msgid "Availability: 1.2.2" 3796msgstr "" 3797 3798#. Tag: para 3799#: reference_accessor.xml:1888 3800#, no-c-format 3801msgid "Enhanced: 2.0.0 added support for geography" 3802msgstr "" 3803 3804#. Tag: para 3805#: reference_accessor.xml:1889 3806#, no-c-format 3807msgid "" 3808"Enhanced: 2.1.0 S flag to denote if has a known spatial reference system" 3809msgstr "" 3810 3811#. Tag: para 3812#: reference_accessor.xml:1890 3813#, no-c-format 3814msgid "Enhanced: 2.2.0 Added support for TIN and Curves" 3815msgstr "" 3816 3817#. Tag: programlisting 3818#: reference_accessor.xml:1896 3819#, no-c-format 3820msgid "" 3821"=# SELECT ST_Summary(ST_GeomFromText('LINESTRING(0 0, 1 1)')) as geom,\n" 3822" ST_Summary(ST_GeogFromText('POLYGON((0 0, 1 1, 1 2, 1 1, 0 0))')) " 3823"geog;\n" 3824" geom | geog\n" 3825"-----------------------------+--------------------------\n" 3826" LineString[B] with 2 points | Polygon[BGS] with 1 rings\n" 3827" | ring 0 has 5 points\n" 3828" :\n" 3829"(1 row)\n" 3830"\n" 3831"\n" 3832"=# SELECT ST_Summary(ST_GeogFromText('LINESTRING(0 0 1, 1 1 1)')) As " 3833"geog_line,\n" 3834" ST_Summary(ST_GeomFromText('SRID=4326;POLYGON((0 0 1, 1 1 2, 1 2 3, " 3835"1 1 1, 0 0 1))')) As geom_poly;\n" 3836";\n" 3837" geog_line | geom_poly\n" 3838"-------------------------------- +--------------------------\n" 3839" LineString[ZBGS] with 2 points | Polygon[ZBS] with 1 rings\n" 3840" : ring 0 has 5 points\n" 3841" :\n" 3842"(1 row)" 3843msgstr "" 3844 3845#. Tag: para 3846#: reference_accessor.xml:1902 3847#, no-c-format 3848msgid "" 3849", <xref linkend=\"PostGIS_AddBBox\"/>, <xref linkend=\"ST_Force_3DM\"/>, " 3850"<xref linkend=\"ST_Force_3DZ\"/>, <xref linkend=\"ST_Force2D\"/>, <xref " 3851"linkend=\"geography\"/>" 3852msgstr "" 3853 3854#. Tag: para 3855#: reference_accessor.xml:1911 3856#, no-c-format 3857msgid "" 3858", <xref linkend=\"ST_IsValid\"/>, <xref linkend=\"ST_IsValidReason\"/>, " 3859"<xref linkend=\"ST_IsValidDetail\"/>" 3860msgstr "" 3861", <xref linkend=\"ST_IsValid\"/>, <xref linkend=\"ST_IsValidReason\"/>, " 3862"<xref linkend=\"ST_IsValidDetail\"/>" 3863 3864#. Tag: refname 3865#: reference_accessor.xml:1922 3866#, no-c-format 3867msgid "ST_X" 3868msgstr "ST_X" 3869 3870#. Tag: refpurpose 3871#: reference_accessor.xml:1924 3872#, no-c-format 3873msgid "Returns the X coordinate of a Point." 3874msgstr "" 3875 3876#. Tag: funcprototype 3877#: reference_accessor.xml:1929 3878#, no-c-format 3879msgid "" 3880"<funcdef>float <function>ST_X</function></funcdef> <paramdef><type>geometry " 3881"</type> <parameter>a_point</parameter></paramdef>" 3882msgstr "" 3883"<funcdef>float <function>ST_X</function></funcdef> <paramdef><type>geometry " 3884"</type> <parameter>a_point</parameter></paramdef>" 3885 3886#. Tag: para 3887#: reference_accessor.xml:1939 3888#, fuzzy, no-c-format 3889msgid "" 3890"Return the X coordinate of the point, or NULL if not available. Input must " 3891"be a point." 3892msgstr "" 3893"Retourne les coordonnées M d'un point, ou NULL si non disponible. L'entrée " 3894"doit être un point." 3895 3896#. Tag: para 3897#: reference_accessor.xml:1942 3898#, no-c-format 3899msgid "" 3900"To get the minimum and maximum X value of geometry coordinates use the " 3901"functions <xref linkend=\"ST_XMin\"/> and <xref linkend=\"ST_XMax\"/>." 3902msgstr "" 3903 3904#. Tag: para 3905#: reference_accessor.xml:1945 3906#, no-c-format 3907msgid "&sqlmm_compliant; SQL-MM 3: 6.1.3" 3908msgstr "&sqlmm_compliant; SQL-MM 3: 6.1.3" 3909 3910#. Tag: programlisting 3911#: reference_accessor.xml:1953 3912#, no-c-format 3913msgid "" 3914"SELECT ST_X(ST_GeomFromEWKT('POINT(1 2 3 4)'));\n" 3915" st_x\n" 3916"------\n" 3917" 1\n" 3918"(1 row)\n" 3919"\n" 3920"SELECT ST_Y(ST_Centroid(ST_GeomFromEWKT('LINESTRING(1 2 3 4, 1 1 1 1)')));\n" 3921" st_y\n" 3922"------\n" 3923" 1.5\n" 3924"(1 row)" 3925msgstr "" 3926"SELECT ST_X(ST_GeomFromEWKT('POINT(1 2 3 4)'));\n" 3927" st_x\n" 3928"------\n" 3929" 1\n" 3930"(1 row)\n" 3931"\n" 3932"SELECT ST_Y(ST_Centroid(ST_GeomFromEWKT('LINESTRING(1 2 3 4, 1 1 1 1)')));\n" 3933" st_y\n" 3934"------\n" 3935" 1.5\n" 3936"(1 row)" 3937 3938#. Tag: para 3939#: reference_accessor.xml:1960 3940#, no-c-format 3941msgid "" 3942", <xref linkend=\"ST_GeomFromEWKT\"/>, <xref linkend=\"ST_M\"/>, <xref " 3943"linkend=\"ST_XMax\"/>, <xref linkend=\"ST_XMin\"/>, <xref linkend=\"ST_Y\"/" 3944">, <xref linkend=\"ST_Z\"/>" 3945msgstr "" 3946", <xref linkend=\"ST_GeomFromEWKT\"/>, <xref linkend=\"ST_M\"/>, <xref " 3947"linkend=\"ST_XMax\"/>, <xref linkend=\"ST_XMin\"/>, <xref linkend=\"ST_Y\"/" 3948">, <xref linkend=\"ST_Z\"/>" 3949 3950#. Tag: refname 3951#: reference_accessor.xml:1966 3952#, no-c-format 3953msgid "ST_Y" 3954msgstr "ST_Y" 3955 3956#. Tag: refpurpose 3957#: reference_accessor.xml:1968 3958#, no-c-format 3959msgid "Returns the Y coordinate of a Point." 3960msgstr "" 3961 3962#. Tag: funcprototype 3963#: reference_accessor.xml:1973 3964#, no-c-format 3965msgid "" 3966"<funcdef>float <function>ST_Y</function></funcdef> <paramdef><type>geometry " 3967"</type> <parameter>a_point</parameter></paramdef>" 3968msgstr "" 3969"<funcdef>float <function>ST_Y</function></funcdef> <paramdef><type>geometry " 3970"</type> <parameter>a_point</parameter></paramdef>" 3971 3972#. Tag: para 3973#: reference_accessor.xml:1983 3974#, fuzzy, no-c-format 3975msgid "" 3976"Return the Y coordinate of the point, or NULL if not available. Input must " 3977"be a point." 3978msgstr "" 3979"Retourne les coordonnées M d'un point, ou NULL si non disponible. L'entrée " 3980"doit être un point." 3981 3982#. Tag: para 3983#: reference_accessor.xml:1986 3984#, no-c-format 3985msgid "" 3986"To get the minimum and maximum Y value of geometry coordinates use the " 3987"functions <xref linkend=\"ST_YMin\"/> and <xref linkend=\"ST_YMax\"/>." 3988msgstr "" 3989 3990#. Tag: para 3991#: reference_accessor.xml:1990 3992#, no-c-format 3993msgid "&sqlmm_compliant; SQL-MM 3: 6.1.4" 3994msgstr "&sqlmm_compliant; SQL-MM 3: 6.1.4" 3995 3996#. Tag: programlisting 3997#: reference_accessor.xml:1998 3998#, no-c-format 3999msgid "" 4000"SELECT ST_Y(ST_GeomFromEWKT('POINT(1 2 3 4)'));\n" 4001" st_y\n" 4002"------\n" 4003" 2\n" 4004"(1 row)\n" 4005"\n" 4006"SELECT ST_Y(ST_Centroid(ST_GeomFromEWKT('LINESTRING(1 2 3 4, 1 1 1 1)')));\n" 4007" st_y\n" 4008"------\n" 4009" 1.5\n" 4010"(1 row)" 4011msgstr "" 4012"SELECT ST_Y(ST_GeomFromEWKT('POINT(1 2 3 4)'));\n" 4013"st_y\n" 4014"------\n" 4015"2\n" 4016"(1 row)\n" 4017"\n" 4018"SELECT ST_Y(ST_Centroid(ST_GeomFromEWKT('LINESTRING(1 2 3 4, 1 1 1 1)')));\n" 4019"st_y\n" 4020"------\n" 4021"1.5\n" 4022"(1 row)" 4023 4024#. Tag: para 4025#: reference_accessor.xml:2005 4026#, no-c-format 4027msgid "" 4028", <xref linkend=\"ST_GeomFromEWKT\"/>, <xref linkend=\"ST_M\"/>, <xref " 4029"linkend=\"ST_X\"/>, <xref linkend=\"ST_YMax\"/>, <xref linkend=\"ST_YMin\"/" 4030">, <xref linkend=\"ST_Z\"/>" 4031msgstr "" 4032", <xref linkend=\"ST_GeomFromEWKT\"/>, <xref linkend=\"ST_M\"/>, <xref " 4033"linkend=\"ST_X\"/>, <xref linkend=\"ST_YMax\"/>, <xref linkend=\"ST_YMin\"/" 4034">, <xref linkend=\"ST_Z\"/>" 4035 4036#. Tag: refname 4037#: reference_accessor.xml:2011 4038#, no-c-format 4039msgid "ST_Z" 4040msgstr "ST_Z" 4041 4042#. Tag: refpurpose 4043#: reference_accessor.xml:2013 4044#, no-c-format 4045msgid "Returns the Z coordinate of a Point." 4046msgstr "" 4047 4048#. Tag: funcprototype 4049#: reference_accessor.xml:2018 4050#, no-c-format 4051msgid "" 4052"<funcdef>float <function>ST_Z</function></funcdef> <paramdef><type>geometry " 4053"</type> <parameter>a_point</parameter></paramdef>" 4054msgstr "" 4055"<funcdef>float <function>ST_Z</function></funcdef> <paramdef><type>geometry " 4056"</type> <parameter>a_point</parameter></paramdef>" 4057 4058#. Tag: para 4059#: reference_accessor.xml:2028 4060#, fuzzy, no-c-format 4061msgid "" 4062"Return the Z coordinate of the point, or NULL if not available. Input must " 4063"be a point." 4064msgstr "" 4065"Retourne les coordonnées M d'un point, ou NULL si non disponible. L'entrée " 4066"doit être un point." 4067 4068#. Tag: para 4069#: reference_accessor.xml:2031 4070#, no-c-format 4071msgid "" 4072"To get the minimum and maximum Z value of geometry coordinates use the " 4073"functions <xref linkend=\"ST_ZMin\"/> and <xref linkend=\"ST_ZMax\"/>." 4074msgstr "" 4075 4076#. Tag: programlisting 4077#: reference_accessor.xml:2042 4078#, no-c-format 4079msgid "" 4080"SELECT ST_Z(ST_GeomFromEWKT('POINT(1 2 3 4)'));\n" 4081" st_z\n" 4082"------\n" 4083" 3\n" 4084"(1 row)" 4085msgstr "" 4086 4087#. Tag: para 4088#: reference_accessor.xml:2049 4089#, no-c-format 4090msgid "" 4091", <xref linkend=\"ST_M\"/>, <xref linkend=\"ST_X\"/>, <xref linkend=\"ST_Y\"/" 4092">, <xref linkend=\"ST_ZMax\"/>, <xref linkend=\"ST_ZMin\"/>" 4093msgstr "" 4094", <xref linkend=\"ST_M\"/>, <xref linkend=\"ST_X\"/>, <xref linkend=\"ST_Y\"/" 4095">, <xref linkend=\"ST_ZMax\"/>, <xref linkend=\"ST_ZMin\"/>" 4096 4097#. Tag: refname 4098#: reference_accessor.xml:2055 4099#, no-c-format 4100msgid "ST_Zmflag" 4101msgstr "ST_Zmflag" 4102 4103#. Tag: refpurpose 4104#: reference_accessor.xml:2057 4105#, fuzzy, no-c-format 4106msgid "" 4107"<refpurpose>Returns a code indicating the ZM coordinate dimension of a " 4108"geometry.</refpurpose>" 4109msgstr "" 4110"<refpurpose>Retourne la dimension des coordonnées de la ST_Geometry.</" 4111"refpurpose>" 4112 4113#. Tag: funcprototype 4114#: reference_accessor.xml:2062 4115#, no-c-format 4116msgid "" 4117"<funcdef>smallint <function>ST_Zmflag</function></funcdef> " 4118"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 4119msgstr "" 4120"<funcdef>smallint <function>ST_Zmflag</function></funcdef> " 4121"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 4122 4123#. Tag: para 4124#: reference_accessor.xml:2072 4125#, fuzzy, no-c-format 4126msgid "" 4127"<para>Returns a code indicating the ZM coordinate dimension of a geometry.</" 4128"para>" 4129msgstr "" 4130"<para>Retourne la dimension des coordonnées d'une valeur ST_Geometry.</para>" 4131 4132#. Tag: para 4133#: reference_accessor.xml:2074 4134#, no-c-format 4135msgid "Values are: 0 = 2D, 1 = 3D-M, 2 = 3D-Z, 3 = 4D." 4136msgstr "" 4137 4138#. Tag: programlisting 4139#: reference_accessor.xml:2084 4140#, no-c-format 4141msgid "" 4142"SELECT ST_Zmflag(ST_GeomFromEWKT('LINESTRING(1 2, 3 4)'));\n" 4143" st_zmflag\n" 4144"-----------\n" 4145" 0\n" 4146"\n" 4147"SELECT ST_Zmflag(ST_GeomFromEWKT('LINESTRINGM(1 2 3, 3 4 3)'));\n" 4148" st_zmflag\n" 4149"-----------\n" 4150" 1\n" 4151"\n" 4152"SELECT ST_Zmflag(ST_GeomFromEWKT('CIRCULARSTRING(1 2 3, 3 4 3, 5 6 3)'));\n" 4153" st_zmflag\n" 4154"-----------\n" 4155" 2\n" 4156"SELECT ST_Zmflag(ST_GeomFromEWKT('POINT(1 2 3 4)'));\n" 4157" st_zmflag\n" 4158"-----------\n" 4159" 3" 4160msgstr "" 4161"SELECT ST_Zmflag(ST_GeomFromEWKT('LINESTRING(1 2, 3 4)'));\n" 4162" st_zmflag\n" 4163"-----------\n" 4164" 0\n" 4165"\n" 4166"SELECT ST_Zmflag(ST_GeomFromEWKT('LINESTRINGM(1 2 3, 3 4 3)'));\n" 4167" st_zmflag\n" 4168"-----------\n" 4169" 1\n" 4170"\n" 4171"SELECT ST_Zmflag(ST_GeomFromEWKT('CIRCULARSTRING(1 2 3, 3 4 3, 5 6 3)'));\n" 4172" st_zmflag\n" 4173"-----------\n" 4174" 2\n" 4175"SELECT ST_Zmflag(ST_GeomFromEWKT('POINT(1 2 3 4)'));\n" 4176" st_zmflag\n" 4177"-----------\n" 4178" 3" 4179 4180#. Tag: para 4181#: reference_accessor.xml:2091 4182#, no-c-format 4183msgid ", <xref linkend=\"ST_NDims\"/>, <xref linkend=\"ST_Dimension\"/>" 4184msgstr ", <xref linkend=\"ST_NDims\"/>, <xref linkend=\"ST_Dimension\"/>" 4185 4186#~ msgid "" 4187#~ "<refpurpose>Returns the type of the geometry as a string. Eg: " 4188#~ "'LINESTRING', 'POLYGON', 'MULTIPOINT', etc.</refpurpose>" 4189#~ msgstr "" 4190#~ "<refpurpose>Retourne le type de la géométrie, par exemple: 'LINESTRING', " 4191#~ "'POLYGON', 'MULTIPOINT', etc.</refpurpose>" 4192 4193#~ msgid "" 4194#~ "The inherent dimension of this Geometry object, which must be less than " 4195#~ "or equal to the coordinate dimension." 4196#~ msgstr "" 4197#~ "La dimension intrinsèque de l'objet Geometry, inférieure ou égale à la " 4198#~ "dimension des coordonnées" 4199 4200#~ msgid "" 4201#~ "Returns the last point of a <varname>LINESTRING</varname> or " 4202#~ "<varname>CIRCULARLINESTRING</varname> geometry as a <varname>POINT</" 4203#~ "varname>." 4204#~ msgstr "" 4205#~ "Retourne le dernier point d'une géométrie <varname>LINESTRING</varname> " 4206#~ "ou <varname>CIRCULARLINESTRING</varname> sous la forme d'un " 4207#~ "<varname>POINT</varname>." 4208 4209#~ msgid "" 4210#~ "<funcdef>boolean <function>ST_EndPoint</function></funcdef> " 4211#~ "<paramdef><type>geometry </type> <parameter>g</parameter></paramdef>" 4212#~ msgstr "" 4213#~ "<funcdef>boolean <function>ST_EndPoint</function></funcdef> " 4214#~ "<paramdef><type>geometry </type> <parameter>g</parameter></paramdef>" 4215 4216#~ msgid "" 4217#~ "Returns a line string representing the exterior ring of the " 4218#~ "<varname>POLYGON</varname> geometry. Return NULL if the geometry is not a " 4219#~ "polygon. Will not work with MULTIPOLYGON" 4220#~ msgstr "" 4221#~ "Retourne une ligne représentant l'envelope extérieure du " 4222#~ "<varname>POLYGON</varname>. Renvoie NULL si la géométrie n'est pas un " 4223#~ "polygone. Ne marche pas avec un objet MULTIPOLYGON" 4224 4225#~ msgid "" 4226#~ "Return the 1-based Nth geometry if the geometry is a GEOMETRYCOLLECTION, " 4227#~ "(MULTI)POINT, (MULTI)LINESTRING, MULTICURVE or (MULTI)POLYGON, " 4228#~ "POLYHEDRALSURFACE Otherwise, return NULL." 4229#~ msgstr "" 4230#~ "Retourne la nième géométrie, n commençant à 1, si la géométrie passée en " 4231#~ "paramètre est de type GEOMETRYCOLLECTION, (MULTI)POINT, " 4232#~ "(MULTI)LINESTRING, MULTICURVE ou (MULTI)POLYGON, POLYHEDRALSURFACE. " 4233#~ "Renvoie NULL dans les autres cas." 4234 4235#~ msgid "" 4236#~ "Return the Nth interior linestring ring of the polygon geometry. Return " 4237#~ "NULL if the geometry is not a polygon or the given N is out of range." 4238#~ msgstr "" 4239#~ "Retourne la nième ligne intérieure du polygone passé en paramètre. " 4240#~ "Renvoie NULL si la géométrie n'est pas un polygone ou si l'index ne " 4241#~ "correspond pas à un intérieur." 4242 4243#~ msgid "" 4244#~ "Returns <varname>TRUE</varname> if the argument is a collection " 4245#~ "(<varname>MULTI*</varname>, <varname>GEOMETRYCOLLECTION</varname>, ...)" 4246#~ msgstr "" 4247#~ "Renvoie <varname>TRUE</varname> si le paramètre est une collection " 4248#~ "(<varname>MULTI*</varname>, <varname>GEOMETRYCOLLECTION</varname>, ...)" 4249 4250#~ msgid "" 4251#~ "Returns <varname>TRUE</varname> if this <varname>LINESTRING</varname> is " 4252#~ "both closed and simple." 4253#~ msgstr "" 4254#~ "Renvoie <varname>TRUE</varname> si la <varname>LINESTRING</varname> est " 4255#~ "à la fois fermée et simple." 4256 4257#~ msgid "ST_IsValid" 4258#~ msgstr "ST_IsValid" 4259 4260#~ msgid "" 4261#~ "Returns <varname>true</varname> if the <varname>ST_Geometry</varname> is " 4262#~ "well formed." 4263#~ msgstr "" 4264#~ "Renvoie <varname>true</varname> si la <varname>ST_Geometry</varname> est " 4265#~ "correctement constituée." 4266 4267#~ msgid "" 4268#~ "<funcprototype> <funcdef>boolean <function>ST_IsValid</function></" 4269#~ "funcdef> <paramdef><type>geometry </type> <parameter>g</parameter></" 4270#~ "paramdef> </funcprototype> <funcprototype> <funcdef>boolean " 4271#~ "<function>ST_IsValid</function></funcdef> <paramdef><type>geometry </" 4272#~ "type> <parameter>g</parameter></paramdef> <paramdef><type>integer </type> " 4273#~ "<parameter>flags</parameter></paramdef> </funcprototype>" 4274#~ msgstr "" 4275#~ "<funcprototype> <funcdef>boolean <function>ST_IsValid</function></" 4276#~ "funcdef> <paramdef><type>geometry </type> <parameter>g</parameter></" 4277#~ "paramdef> </funcprototype> <funcprototype> <funcdef>boolean " 4278#~ "<function>ST_IsValid</function></funcdef> <paramdef><type>geometry </" 4279#~ "type> <parameter>g</parameter></paramdef> <paramdef><type>integer </type> " 4280#~ "<parameter>flags</parameter></paramdef> </funcprototype>" 4281 4282#~ msgid "" 4283#~ "SQL-MM defines the result of ST_IsValid(NULL) to be 0, while PostGIS " 4284#~ "returns NULL." 4285#~ msgstr "" 4286#~ "SQL-MM définit le résultat de ST_IsValid(NULL) comme 0, pendant que " 4287#~ "PostGIS retourne NULL." 4288 4289#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.9" 4290#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.9" 4291 4292#~ msgid "" 4293#~ "SELECT ST_IsValid(ST_GeomFromText('LINESTRING(0 0, 1 1)')) As good_line,\n" 4294#~ " ST_IsValid(ST_GeomFromText('POLYGON((0 0, 1 1, 1 2, 1 1, 0 0))')) " 4295#~ "As bad_poly\n" 4296#~ "--results\n" 4297#~ "NOTICE: Self-intersection at or near point 0 0\n" 4298#~ " good_line | bad_poly\n" 4299#~ "-----------+----------\n" 4300#~ " t | f" 4301#~ msgstr "" 4302#~ "SELECT ST_IsValid(ST_GeomFromText('LINESTRING(0 0, 1 1)')) As good_line,\n" 4303#~ " ST_IsValid(ST_GeomFromText('POLYGON((0 0, 1 1, 1 2, 1 1, 0 0))')) " 4304#~ "As bad_poly\n" 4305#~ "--results\n" 4306#~ "NOTICE: Self-intersection at or near point 0 0\n" 4307#~ " good_line | bad_poly\n" 4308#~ "-----------+----------\n" 4309#~ " t | f" 4310 4311#~ msgid "" 4312#~ ", <xref linkend=\"ST_IsValidReason\"/>, <xref linkend=\"ST_IsValidDetail" 4313#~ "\"/>, <xref linkend=\"ST_Summary\"/>" 4314#~ msgstr "" 4315#~ ", <xref linkend=\"ST_IsValidReason\"/>, <xref linkend=\"ST_IsValidDetail" 4316#~ "\"/>, <xref linkend=\"ST_Summary\"/>" 4317 4318#~ msgid "ST_IsValidReason" 4319#~ msgstr "ST_IsValidReason" 4320 4321#~ msgid "" 4322#~ "<funcprototype> <funcdef>text <function>ST_IsValidReason</function></" 4323#~ "funcdef> <paramdef><type>geometry </type> <parameter>geomA</parameter></" 4324#~ "paramdef> </funcprototype> <funcprototype> <funcdef>text " 4325#~ "<function>ST_IsValidReason</function></funcdef> <paramdef><type>geometry " 4326#~ "</type> <parameter>geomA</parameter></paramdef> <paramdef><type>integer </" 4327#~ "type> <parameter>flags</parameter></paramdef> </funcprototype>" 4328#~ msgstr "" 4329#~ "<funcprototype> <funcdef>text <function>ST_IsValidReason</function></" 4330#~ "funcdef> <paramdef><type>geometry </type> <parameter>geomA</parameter></" 4331#~ "paramdef> </funcprototype> <funcprototype> <funcdef>text " 4332#~ "<function>ST_IsValidReason</function></funcdef> <paramdef><type>geometry " 4333#~ "</type> <parameter>geomA</parameter></paramdef> <paramdef><type>integer </" 4334#~ "type> <parameter>flags</parameter></paramdef> </funcprototype>" 4335 4336#~ msgid "Availability: 1.4 - requires GEOS >= 3.1.0." 4337#~ msgstr "Disponibilité: 1.4 - nécessite GEOS >= 3.1.0." 4338 4339#~ msgid "" 4340#~ "Availability: 2.0 - requires GEOS >= 3.3.0 for the version taking " 4341#~ "flags." 4342#~ msgstr "Disponibilité: 2.0 - nécessite GEOS >= >= 3.3.0" 4343 4344#~ msgid ", <xref linkend=\"ST_Summary\"/>" 4345#~ msgstr ", <xref linkend=\"ST_Summary\"/>" 4346 4347#~ msgid "ST_IsValidDetail" 4348#~ msgstr "ST_IsValidDetail" 4349 4350#~ msgid "" 4351#~ "<funcprototype> <funcdef>valid_detail <function>ST_IsValidDetail</" 4352#~ "function></funcdef> <paramdef><type>geometry </type> <parameter>geom</" 4353#~ "parameter></paramdef> </funcprototype> <funcprototype> " 4354#~ "<funcdef>valid_detail <function>ST_IsValidDetail</function></funcdef> " 4355#~ "<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> " 4356#~ "<paramdef><type>integer </type> <parameter>flags</parameter></paramdef> </" 4357#~ "funcprototype>" 4358#~ msgstr "" 4359#~ "<funcprototype> <funcdef>valid_detail <function>ST_IsValidDetail</" 4360#~ "function></funcdef> <paramdef><type>geometry </type> <parameter>geom</" 4361#~ "parameter></paramdef> </funcprototype> <funcprototype> " 4362#~ "<funcdef>valid_detail <function>ST_IsValidDetail</function></funcdef> " 4363#~ "<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> " 4364#~ "<paramdef><type>integer </type> <parameter>flags</parameter></paramdef> </" 4365#~ "funcprototype>" 4366 4367#~ msgid "Availability: 2.0.0 - requires GEOS >= 3.3.0." 4368#~ msgstr "Disponibilité: 2.0.0 - nécessite GEOS >= 3.3.0." 4369 4370#~ msgid ", <xref linkend=\"ST_IsValidReason\"/>" 4371#~ msgstr ", <xref linkend=\"ST_IsValidReason\"/>" 4372 4373#~ msgid "" 4374#~ "If the geometry is a polygon or multi-polygon returns the number of rings." 4375#~ msgstr "" 4376#~ "Si la géométrie est un polygone ou un multi-polygone renvoi le nombre " 4377#~ "d'anneaux." 4378 4379#~ msgid "ST_SRID" 4380#~ msgstr "ST_SRID" 4381 4382#~ msgid "" 4383#~ "<funcdef>integer <function>ST_SRID</function></funcdef> " 4384#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 4385#~ msgstr "" 4386#~ "<funcdef>integer <function>ST_SRID</function></funcdef> " 4387#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 4388 4389#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.5" 4390#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.5" 4391 4392#~ msgid "" 4393#~ "SELECT ST_SRID(ST_GeomFromText('POINT(-71.1043 42.315)',4326));\n" 4394#~ " --result\n" 4395#~ " 4326" 4396#~ msgstr "" 4397#~ "SELECT ST_SRID(ST_GeomFromText('POINT(-71.1043 42.315)',4326));\n" 4398#~ " --result\n" 4399#~ " 4326" 4400 4401#~ msgid "" 4402#~ ", <xref linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_SetSRID\"/>, " 4403#~ "<xref linkend=\"ST_Transform\"/>" 4404#~ msgstr "" 4405#~ ", <xref linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_SetSRID\"/>, " 4406#~ "<xref linkend=\"ST_Transform\"/>" 4407 4408#~ msgid "ST_XMax" 4409#~ msgstr "ST_XMax" 4410 4411#~ msgid "" 4412#~ "<funcdef>float <function>ST_XMax</function></funcdef> " 4413#~ "<paramdef><type>box3d </type> <parameter>aGeomorBox2DorBox3D</parameter></" 4414#~ "paramdef>" 4415#~ msgstr "" 4416#~ "<funcdef>float <function>ST_XMax</function></funcdef> " 4417#~ "<paramdef><type>box3d </type> <parameter>aGeomorBox2DorBox3D</parameter></" 4418#~ "paramdef>" 4419 4420#~ msgid "" 4421#~ "SELECT ST_XMax('BOX3D(1 2 3, 4 5 6)');\n" 4422#~ "st_xmax\n" 4423#~ "-------\n" 4424#~ "4\n" 4425#~ "\n" 4426#~ "SELECT ST_XMax(ST_GeomFromText('LINESTRING(1 3 4, 5 6 7)'));\n" 4427#~ "st_xmax\n" 4428#~ "-------\n" 4429#~ "5\n" 4430#~ "\n" 4431#~ "SELECT ST_XMax(CAST('BOX(-3 2, 3 4)' As box2d));\n" 4432#~ "st_xmax\n" 4433#~ "-------\n" 4434#~ "3\n" 4435#~ "--Observe THIS DOES NOT WORK because it will try to autocast the string " 4436#~ "representation to a BOX3D\n" 4437#~ "SELECT ST_XMax('LINESTRING(1 3, 5 6)');\n" 4438#~ "\n" 4439#~ "--ERROR: BOX3D parser - doesn't start with BOX3D(\n" 4440#~ "\n" 4441#~ "SELECT ST_XMax(ST_GeomFromEWKT('CIRCULARSTRING(220268 150415 1,220227 " 4442#~ "150505 2,220227 150406 3)'));\n" 4443#~ "st_xmax\n" 4444#~ "--------\n" 4445#~ "220288.248780547" 4446#~ msgstr "" 4447#~ "SELECT ST_XMax('BOX3D(1 2 3, 4 5 6)');\n" 4448#~ "st_xmax\n" 4449#~ "-------\n" 4450#~ "4\n" 4451#~ "\n" 4452#~ "SELECT ST_XMax(ST_GeomFromText('LINESTRING(1 3 4, 5 6 7)'));\n" 4453#~ "st_xmax\n" 4454#~ "-------\n" 4455#~ "5\n" 4456#~ "\n" 4457#~ "SELECT ST_XMax(CAST('BOX(-3 2, 3 4)' As box2d));\n" 4458#~ "st_xmax\n" 4459#~ "-------\n" 4460#~ "3\n" 4461#~ "--Observe CELA NE FONCTIONNE PAS par ce qu'il tentera de caster la " 4462#~ "représentation de la chaîne vers BOX3D\n" 4463#~ "SELECT ST_XMax('LINESTRING(1 3, 5 6)');\n" 4464#~ "\n" 4465#~ "--ERREUR : BOX3D parser - ne démarre pas avec BOX3D(\n" 4466#~ "\n" 4467#~ "SELECT ST_XMax(ST_GeomFromEWKT('CIRCULARSTRING(220268 150415 1,220227 " 4468#~ "150505 2,220227 150406 3)'));\n" 4469#~ "st_xmax\n" 4470#~ "--------\n" 4471#~ "220288.248780547" 4472 4473#~ msgid "" 4474#~ ", <xref linkend=\"ST_YMax\"/>, <xref linkend=\"ST_YMin\"/>, <xref linkend=" 4475#~ "\"ST_ZMax\"/>, <xref linkend=\"ST_ZMin\"/>" 4476#~ msgstr "" 4477#~ ", <xref linkend=\"ST_YMax\"/>, <xref linkend=\"ST_YMin\"/>, <xref linkend=" 4478#~ "\"ST_ZMax\"/>, <xref linkend=\"ST_ZMin\"/>" 4479 4480#~ msgid "ST_XMin" 4481#~ msgstr "ST_XMin" 4482 4483#~ msgid "" 4484#~ "<funcdef>float <function>ST_XMin</function></funcdef> " 4485#~ "<paramdef><type>box3d </type> <parameter>aGeomorBox2DorBox3D</parameter></" 4486#~ "paramdef>" 4487#~ msgstr "" 4488#~ "<funcdef>float <function>ST_XMin</function></funcdef> " 4489#~ "<paramdef><type>box3d </type> <parameter>aGeomorBox2DorBox3D</parameter></" 4490#~ "paramdef>" 4491 4492#~ msgid "" 4493#~ "SELECT ST_XMin('BOX3D(1 2 3, 4 5 6)');\n" 4494#~ "st_xmin\n" 4495#~ "-------\n" 4496#~ "1\n" 4497#~ "\n" 4498#~ "SELECT ST_XMin(ST_GeomFromText('LINESTRING(1 3 4, 5 6 7)'));\n" 4499#~ "st_xmin\n" 4500#~ "-------\n" 4501#~ "1\n" 4502#~ "\n" 4503#~ "SELECT ST_XMin(CAST('BOX(-3 2, 3 4)' As box2d));\n" 4504#~ "st_xmin\n" 4505#~ "-------\n" 4506#~ "-3\n" 4507#~ "--Observe THIS DOES NOT WORK because it will try to autocast the string " 4508#~ "representation to a BOX3D\n" 4509#~ "SELECT ST_XMin('LINESTRING(1 3, 5 6)');\n" 4510#~ "\n" 4511#~ "--ERROR: BOX3D parser - doesn't start with BOX3D(\n" 4512#~ "\n" 4513#~ "SELECT ST_XMin(ST_GeomFromEWKT('CIRCULARSTRING(220268 150415 1,220227 " 4514#~ "150505 2,220227 150406 3)'));\n" 4515#~ "st_xmin\n" 4516#~ "--------\n" 4517#~ "220186.995121892" 4518#~ msgstr "" 4519#~ "SELECT ST_XMin('BOX3D(1 2 3, 4 5 6)');\n" 4520#~ "st_xmin\n" 4521#~ "-------\n" 4522#~ "1\n" 4523#~ "\n" 4524#~ "SELECT ST_XMin(ST_GeomFromText('LINESTRING(1 3 4, 5 6 7)'));\n" 4525#~ "st_xmin\n" 4526#~ "-------\n" 4527#~ "1\n" 4528#~ "\n" 4529#~ "SELECT ST_XMin(CAST('BOX(-3 2, 3 4)' As box2d));\n" 4530#~ "st_xmin\n" 4531#~ "-------\n" 4532#~ "-3\n" 4533#~ "--Observe THIS DOES NOT WORK because it will try to autocast the string " 4534#~ "representation to a BOX3D\n" 4535#~ "SELECT ST_XMin('LINESTRING(1 3, 5 6)');\n" 4536#~ "\n" 4537#~ "--ERROR: BOX3D parser - doesn't start with BOX3D(\n" 4538#~ "\n" 4539#~ "SELECT ST_XMin(ST_GeomFromEWKT('CIRCULARSTRING(220268 150415 1,220227 " 4540#~ "150505 2,220227 150406 3)'));\n" 4541#~ "st_xmin\n" 4542#~ "--------\n" 4543#~ "220186.995121892" 4544 4545#~ msgid "ST_YMax" 4546#~ msgstr "ST_YMax" 4547 4548#~ msgid "" 4549#~ "<funcdef>float <function>ST_YMax</function></funcdef> " 4550#~ "<paramdef><type>box3d </type> <parameter>aGeomorBox2DorBox3D</parameter></" 4551#~ "paramdef>" 4552#~ msgstr "" 4553#~ "<funcdef>float <function>ST_YMax</function></funcdef> " 4554#~ "<paramdef><type>box3d </type> <parameter>aGeomorBox2DorBox3D</parameter></" 4555#~ "paramdef>" 4556 4557#~ msgid "" 4558#~ ", <xref linkend=\"ST_XMax\"/>, <xref linkend=\"ST_YMin\"/>, <xref linkend=" 4559#~ "\"ST_ZMax\"/>, <xref linkend=\"ST_ZMin\"/>" 4560#~ msgstr "" 4561#~ ", <xref linkend=\"ST_XMax\"/>, <xref linkend=\"ST_YMin\"/>, <xref linkend=" 4562#~ "\"ST_ZMax\"/>, <xref linkend=\"ST_ZMin\"/>" 4563 4564#~ msgid "ST_YMin" 4565#~ msgstr "ST_YMin" 4566 4567#~ msgid "" 4568#~ "<funcdef>float <function>ST_YMin</function></funcdef> " 4569#~ "<paramdef><type>box3d </type> <parameter>aGeomorBox2DorBox3D</parameter></" 4570#~ "paramdef>" 4571#~ msgstr "" 4572#~ "<funcdef>float <function>ST_YMin</function></funcdef> " 4573#~ "<paramdef><type>box3d </type> <parameter>aGeomorBox2DorBox3D</parameter></" 4574#~ "paramdef>" 4575 4576#~ msgid "" 4577#~ ", <xref linkend=\"ST_XMin\"/>, <xref linkend=\"ST_XMax\"/>, <xref linkend=" 4578#~ "\"ST_YMax\"/>, <xref linkend=\"ST_ZMax\"/>, <xref linkend=\"ST_ZMin\"/>" 4579#~ msgstr "" 4580#~ ", <xref linkend=\"ST_XMin\"/>, <xref linkend=\"ST_XMax\"/>, <xref linkend=" 4581#~ "\"ST_YMax\"/>, <xref linkend=\"ST_ZMax\"/>, <xref linkend=\"ST_ZMin\"/>" 4582 4583#~ msgid "ST_ZMax" 4584#~ msgstr "ST_ZMax" 4585 4586#~ msgid "" 4587#~ "<funcdef>float <function>ST_ZMax</function></funcdef> " 4588#~ "<paramdef><type>box3d </type> <parameter>aGeomorBox2DorBox3D</parameter></" 4589#~ "paramdef>" 4590#~ msgstr "" 4591#~ "<funcdef>float <function>ST_ZMax</function></funcdef> " 4592#~ "<paramdef><type>box3d </type> <parameter>aGeomorBox2DorBox3D</parameter></" 4593#~ "paramdef>" 4594 4595#~ msgid "" 4596#~ ", <xref linkend=\"ST_XMin\"/>, <xref linkend=\"ST_XMax\"/>, <xref linkend=" 4597#~ "\"ST_YMax\"/>, <xref linkend=\"ST_YMin\"/>, <xref linkend=\"ST_ZMax\"/>" 4598#~ msgstr "" 4599#~ ", <xref linkend=\"ST_XMin\"/>, <xref linkend=\"ST_XMax\"/>, <xref linkend=" 4600#~ "\"ST_YMax\"/>, <xref linkend=\"ST_YMin\"/>, <xref linkend=\"ST_ZMax\"/>" 4601 4602#~ msgid "ST_ZMin" 4603#~ msgstr "ST_ZMin" 4604 4605#~ msgid "" 4606#~ "<funcdef>float <function>ST_ZMin</function></funcdef> " 4607#~ "<paramdef><type>box3d </type> <parameter>aGeomorBox2DorBox3D</parameter></" 4608#~ "paramdef>" 4609#~ msgstr "" 4610#~ "<funcdef>float <function>ST_ZMin</function></funcdef> " 4611#~ "<paramdef><type>box3d </type> <parameter>aGeomorBox2DorBox3D</parameter></" 4612#~ "paramdef>" 4613 4614#~ msgid "" 4615#~ "SELECT ST_ZMin('BOX3D(1 2 3, 4 5 6)');\n" 4616#~ "st_zmin\n" 4617#~ "-------\n" 4618#~ "3\n" 4619#~ "\n" 4620#~ "SELECT ST_ZMin(ST_GeomFromEWKT('LINESTRING(1 3 4, 5 6 7)'));\n" 4621#~ "st_zmin\n" 4622#~ "-------\n" 4623#~ "4\n" 4624#~ "\n" 4625#~ "SELECT ST_ZMin('BOX3D(-3 2 1, 3 4 1)' );\n" 4626#~ "st_zmin\n" 4627#~ "-------\n" 4628#~ "1\n" 4629#~ "--Observe THIS DOES NOT WORK because it will try to autocast the string " 4630#~ "representation to a BOX3D\n" 4631#~ "SELECT ST_ZMin('LINESTRING(1 3 4, 5 6 7)');\n" 4632#~ "\n" 4633#~ "--ERROR: BOX3D parser - doesn't start with BOX3D(\n" 4634#~ "\n" 4635#~ "SELECT ST_ZMin(ST_GeomFromEWKT('CIRCULARSTRING(220268 150415 1,220227 " 4636#~ "150505 2,220227 150406 3)'));\n" 4637#~ "st_zmin\n" 4638#~ "--------\n" 4639#~ "1" 4640#~ msgstr "" 4641#~ "SELECT ST_ZMin('BOX3D(1 2 3, 4 5 6)');\n" 4642#~ "st_zmin\n" 4643#~ "-------\n" 4644#~ "3\n" 4645#~ "\n" 4646#~ "SELECT ST_ZMin(ST_GeomFromEWKT('LINESTRING(1 3 4, 5 6 7)'));\n" 4647#~ "st_zmin\n" 4648#~ "-------\n" 4649#~ "4\n" 4650#~ "\n" 4651#~ "SELECT ST_ZMin('BOX3D(-3 2 1, 3 4 1)' );\n" 4652#~ "st_zmin\n" 4653#~ "-------\n" 4654#~ "1\n" 4655#~ "--Observe THIS DOES NOT WORK because it will try to autocast the string " 4656#~ "representation to a BOX3D\n" 4657#~ "SELECT ST_ZMin('LINESTRING(1 3 4, 5 6 7)');\n" 4658#~ "\n" 4659#~ "--ERROR: BOX3D parser - doesn't start with BOX3D(\n" 4660#~ "\n" 4661#~ "SELECT ST_ZMin(ST_GeomFromEWKT('CIRCULARSTRING(220268 150415 1,220227 " 4662#~ "150505 2,220227 150406 3)'));\n" 4663#~ "st_zmin\n" 4664#~ "--------\n" 4665#~ "1" 4666 4667#~ msgid "" 4668#~ ", <xref linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_XMin\"/>, <xref " 4669#~ "linkend=\"ST_XMax\"/>, <xref linkend=\"ST_YMax\"/>, <xref linkend=" 4670#~ "\"ST_YMin\"/>, <xref linkend=\"ST_ZMax\"/>" 4671#~ msgstr "" 4672#~ ", <xref linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_XMin\"/>, <xref " 4673#~ "linkend=\"ST_XMax\"/>, <xref linkend=\"ST_YMax\"/>, <xref linkend=" 4674#~ "\"ST_YMin\"/>, <xref linkend=\"ST_ZMax\"/>" 4675