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