1# SOME DESCRIPTIVE TITLE. 2# 3# Translators: 4# pibinko <pibinko@gmail.com>, 2014 5msgid "" 6msgstr "" 7"Project-Id-Version: PostGIS\n" 8"Report-Msgid-Bugs-To: https://bugs.kde.org\n" 9"POT-Creation-Date: 2021-09-11 01:55+0000\n" 10"PO-Revision-Date: 2015-09-29 12:24+0000\n" 11"Last-Translator: Sandro Santilli <strk@kbt.io>\n" 12"Language-Team: Italian (Italy) (http://www.transifex.com/postgis/postgis/" 13"language/it_IT/)\n" 14"Language: it_IT\n" 15"MIME-Version: 1.0\n" 16"Content-Type: text/plain; charset=UTF-8\n" 17"Content-Transfer-Encoding: 8bit\n" 18"Plural-Forms: nplurals=2; plural=(n != 1);\n" 19 20#. Tag: para 21#: reference_measure.xml:5 22#, no-c-format 23msgid "" 24"These functions compute measurements of distance, area and angles. There are " 25"also functions to compute geometry values determined by measurements." 26msgstr "" 27 28#. Tag: title 29#: reference_measure.xml:10 30#, no-c-format 31msgid "Measurement Functions" 32msgstr "" 33 34#. Tag: refname 35#: reference_measure.xml:14 36#, no-c-format 37msgid "ST_Area" 38msgstr "ST_Area" 39 40#. Tag: refpurpose 41#: reference_measure.xml:16 42#, no-c-format 43msgid "Returns the area of a polygonal geometry." 44msgstr "" 45 46#. Tag: funcsynopsis 47#: reference_measure.xml:20 48#, no-c-format 49msgid "" 50"<funcprototype> <funcdef>float <function>ST_Area</function></funcdef> " 51"<paramdef><type>geometry </type><parameter>g1</parameter></paramdef> </" 52"funcprototype> <funcprototype> <funcdef>float <function>ST_Area</function></" 53"funcdef> <paramdef><type>geography </type><parameter>geog</parameter></" 54"paramdef> <paramdef choice=\"opt\"><type>boolean </" 55"type><parameter>use_spheroid=true</parameter></paramdef> </funcprototype>" 56msgstr "" 57 58#. Tag: title 59#: reference_measure.xml:34 reference_measure.xml:97 reference_measure.xml:176 60#: reference_measure.xml:237 reference_measure.xml:311 61#: reference_measure.xml:392 reference_measure.xml:468 62#: reference_measure.xml:517 reference_measure.xml:564 63#: reference_measure.xml:620 reference_measure.xml:692 64#: reference_measure.xml:757 reference_measure.xml:814 65#: reference_measure.xml:846 reference_measure.xml:889 66#: reference_measure.xml:943 reference_measure.xml:1038 67#: reference_measure.xml:1105 reference_measure.xml:1157 68#: reference_measure.xml:1199 reference_measure.xml:1283 69#: reference_measure.xml:1330 reference_measure.xml:1381 70#: reference_measure.xml:1416 reference_measure.xml:1462 71#: reference_measure.xml:1518 reference_measure.xml:1595 72#, no-c-format 73msgid "Description" 74msgstr "Descrizione" 75 76#. Tag: para 77#: reference_measure.xml:36 78#, no-c-format 79msgid "" 80"Returns the area of a polygonal geometry. For geometry types a 2D Cartesian " 81"(planar) area is computed, with units specified by the SRID. For geography " 82"types by default area is determined on a spheroid with units in square " 83"meters. To compute the area using the faster but less accurate spherical " 84"model use <varname>ST_Area(geog,false)</varname>." 85msgstr "" 86 87#. Tag: para 88#: reference_measure.xml:41 89#, no-c-format 90msgid "Enhanced: 2.0.0 - support for 2D polyhedral surfaces was introduced." 91msgstr "" 92 93#. Tag: para 94#: reference_measure.xml:42 reference_measure.xml:409 95#, no-c-format 96msgid "" 97"Enhanced: 2.2.0 - measurement on spheroid performed with GeographicLib for " 98"improved accuracy and robustness. Requires PROJ >= 4.9.0 to take " 99"advantage of the new feature." 100msgstr "" 101 102#. Tag: para 103#: reference_measure.xml:43 reference_measure.xml:410 104#, no-c-format 105msgid "Changed: 3.0.0 - does not depend on SFCGAL anymore." 106msgstr "" 107 108#. Tag: para 109#: reference_measure.xml:44 reference_measure.xml:402 110#, no-c-format 111msgid "&sfs_compliant;" 112msgstr "&sfs_compliant;" 113 114#. Tag: para 115#: reference_measure.xml:45 116#, no-c-format 117msgid "&sqlmm_compliant; SQL-MM 3: 8.1.2, 9.5.3" 118msgstr "&sqlmm_compliant; SQL-MM 3: 8.1.2, 9.5.3" 119 120#. Tag: para 121#: reference_measure.xml:46 reference_measure.xml:318 reference_measure.xml:475 122#: reference_measure.xml:1050 reference_measure.xml:1164 123#: reference_measure.xml:1611 124#, no-c-format 125msgid "&P_support;" 126msgstr "&P_support;" 127 128#. Tag: para 129#: reference_measure.xml:47 130#, no-c-format 131msgid "" 132"For polyhedral surfaces, only supports 2D polyhedral surfaces (not 2.5D). " 133"For 2.5D, may give a non-zero answer, but only for the faces that sit " 134"completely in XY plane." 135msgstr "" 136 137#. Tag: title 138#: reference_measure.xml:52 reference_measure.xml:116 reference_measure.xml:194 139#: reference_measure.xml:247 reference_measure.xml:324 140#: reference_measure.xml:484 reference_measure.xml:531 141#: reference_measure.xml:581 reference_measure.xml:646 142#: reference_measure.xml:721 reference_measure.xml:856 143#: reference_measure.xml:906 reference_measure.xml:956 144#: reference_measure.xml:1054 reference_measure.xml:1119 145#: reference_measure.xml:1171 reference_measure.xml:1247 146#: reference_measure.xml:1295 reference_measure.xml:1426 147#: reference_measure.xml:1534 reference_measure.xml:1615 148#, no-c-format 149msgid "Examples" 150msgstr "Esempi" 151 152#. Tag: para 153#: reference_measure.xml:53 154#, no-c-format 155msgid "" 156"Return area in square feet for a plot of Massachusetts land and multiply by " 157"conversion to get square meters. Note this is in square feet because " 158"EPSG:2249 is Massachusetts State Plane Feet" 159msgstr "" 160 161#. Tag: programlisting 162#: reference_measure.xml:56 163#, no-c-format 164msgid "" 165"select ST_Area(geom) sqft,\n" 166" ST_Area(geom) * 0.3048 ^ 2 sqm\n" 167"from (\n" 168" select 'SRID=2249;POLYGON((743238 2967416,743238 2967450,\n" 169" 743265 2967450,743265.625 2967416,743238 " 170"2967416))' :: geometry geom\n" 171" ) subquery;\n" 172"┌─────────┬─────────────┐\n" 173"│ sqft │ sqm │\n" 174"├─────────┼─────────────┤\n" 175"│ 928.625 │ 86.27208552 │\n" 176"└─────────┴─────────────┘" 177msgstr "" 178 179#. Tag: para 180#: reference_measure.xml:57 181#, no-c-format 182msgid "" 183"Return area square feet and transform to Massachusetts state plane meters " 184"(EPSG:26986) to get square meters. Note this is in square feet because 2249 " 185"is Massachusetts State Plane Feet and transformed area is in square meters " 186"since EPSG:26986 is state plane Massachusetts meters" 187msgstr "" 188 189#. Tag: programlisting 190#: reference_measure.xml:60 191#, no-c-format 192msgid "" 193"select ST_Area(geom) sqft,\n" 194" ST_Area(ST_Transform(geom, 26986)) As sqm\n" 195"from (\n" 196" select\n" 197" 'SRID=2249;POLYGON((743238 2967416,743238 2967450,\n" 198" 743265 2967450,743265.625 2967416,743238 2967416))' :: geometry " 199"geom\n" 200" ) subquery;\n" 201"┌─────────┬─────────────────┐\n" 202"│ sqft │ sqm │\n" 203"├─────────┼─────────────────┤\n" 204"│ 928.625 │ 86.272430607008 │\n" 205"└─────────┴─────────────────┘" 206msgstr "" 207 208#. Tag: para 209#: reference_measure.xml:62 210#, no-c-format 211msgid "" 212"Return area square feet and square meters using geography data type. Note " 213"that we transform to our geometry to geography (before you can do that make " 214"sure your geometry is in WGS 84 long lat 4326). Geography always measures in " 215"meters. This is just for demonstration to compare. Normally your table will " 216"be stored in geography data type already." 217msgstr "" 218 219#. Tag: programlisting 220#: reference_measure.xml:65 221#, no-c-format 222msgid "" 223"select ST_Area(geog) / 0.3048 ^ 2 sqft_spheroid,\n" 224" ST_Area(geog, false) / 0.3048 ^ 2 sqft_sphere,\n" 225" ST_Area(geog) sqm_spheroid\n" 226"from (\n" 227" select ST_Transform(\n" 228" 'SRID=2249;POLYGON((743238 2967416,743238 2967450,743265 " 229"2967450,743265.625 2967416,743238 2967416))'::geometry,\n" 230" 4326\n" 231" ) :: geography geog\n" 232" ) as subquery;\n" 233"┌──────────────────┬──────────────────┬──────────────────┐\n" 234"│ sqft_spheroid │ sqft_sphere │ sqm_spheroid │\n" 235"├──────────────────┼──────────────────┼──────────────────┤\n" 236"│ 928.684405784452 │ 927.049336105925 │ 86.2776044979692 │\n" 237"└──────────────────┴──────────────────┴──────────────────┘" 238msgstr "" 239 240#. Tag: para 241#: reference_measure.xml:67 242#, no-c-format 243msgid "If your data is in geography already:" 244msgstr "" 245 246#. Tag: programlisting 247#: reference_measure.xml:68 248#, no-c-format 249msgid "" 250"select ST_Area(geog) / 0.3048 ^ 2 sqft,\n" 251" ST_Area(the_geog) sqm\n" 252"from somegeogtable;" 253msgstr "" 254 255#. Tag: title 256#: reference_measure.xml:71 reference_measure.xml:147 reference_measure.xml:208 257#: reference_measure.xml:282 reference_measure.xml:350 258#: reference_measure.xml:439 reference_measure.xml:491 259#: reference_measure.xml:538 reference_measure.xml:588 260#: reference_measure.xml:652 reference_measure.xml:731 261#: reference_measure.xml:792 reference_measure.xml:823 262#: reference_measure.xml:865 reference_measure.xml:913 263#: reference_measure.xml:1010 reference_measure.xml:1080 264#: reference_measure.xml:1130 reference_measure.xml:1177 265#: reference_measure.xml:1253 reference_measure.xml:1300 266#: reference_measure.xml:1358 reference_measure.xml:1393 267#: reference_measure.xml:1433 reference_measure.xml:1489 268#: reference_measure.xml:1568 reference_measure.xml:1641 269#, no-c-format 270msgid "See Also" 271msgstr "Si veda anche" 272 273#. Tag: para 274#: reference_measure.xml:72 275#, fuzzy, no-c-format 276msgid "" 277", <xref linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_GeographyFromText" 278"\"/>, <xref linkend=\"ST_SetSRID\"/>, <xref linkend=\"ST_Transform\"/>" 279msgstr "" 280", <xref linkend=\"ST_GeomFromEWKT\"/>, <xref linkend=\"ST_Length_Spheroid\"/" 281">, <xref linkend=\"ST_Perimeter\"/>, <xref linkend=\"ST_Transform\"/>" 282 283#. Tag: refname 284#: reference_measure.xml:78 285#, no-c-format 286msgid "ST_Azimuth" 287msgstr "ST_Azimuth" 288 289#. Tag: refpurpose 290#: reference_measure.xml:80 291#, no-c-format 292msgid "Returns the north-based azimuth of a line between two points." 293msgstr "" 294 295#. Tag: funcsynopsis 296#: reference_measure.xml:83 297#, no-c-format 298msgid "" 299"<funcprototype> <funcdef>float <function>ST_Azimuth</function></funcdef> " 300"<paramdef><type>geometry </type><parameter>pointA</parameter></paramdef> " 301"<paramdef><type>geometry </type><parameter>pointB</parameter></paramdef> </" 302"funcprototype> <funcprototype> <funcdef>float <function>ST_Azimuth</" 303"function></funcdef> <paramdef><type>geography </type><parameter>pointA</" 304"parameter></paramdef> <paramdef><type>geography </type><parameter>pointB</" 305"parameter></paramdef> </funcprototype>" 306msgstr "" 307"<funcprototype> <funcdef>float <function>ST_Azimuth</function></funcdef> " 308"<paramdef><type>geometry </type><parameter>pointA</parameter></paramdef> " 309"<paramdef><type>geometry </type><parameter>pointB</parameter></paramdef> </" 310"funcprototype> <funcprototype> <funcdef>float <function>ST_Azimuth</" 311"function></funcdef> <paramdef><type>geography </type><parameter>pointA</" 312"parameter></paramdef> <paramdef><type>geography </type><parameter>pointB</" 313"parameter></paramdef> </funcprototype>" 314 315#. Tag: para 316#: reference_measure.xml:99 317#, no-c-format 318msgid "" 319"Returns the azimuth in radians of the line segment defined by the given " 320"point geometries, or NULL if the two points are coincident. The azimuth " 321"angle is referenced from north (the positive Y axis), and is positive " 322"clockwise: North = 0; Northeast = π/4; East = π/2; Southeast = " 323"3π/4; South = π; Southwest 5π/4; West = 3π/2; " 324"Northwest = 7π/4." 325msgstr "" 326 327#. Tag: para 328#: reference_measure.xml:102 329#, no-c-format 330msgid "" 331"For the geography type, the azimuth solution is known as the <ulink url=" 332"\"https://en.wikipedia.org/wiki/Geodesics_on_an_ellipsoid\">inverse geodesic " 333"problem</ulink>." 334msgstr "" 335 336#. Tag: para 337#: reference_measure.xml:104 338#, no-c-format 339msgid "" 340"The azimuth is a mathematical concept defined as the angle between a " 341"reference plane and a point, with angular units in radians. The result value " 342"in radians can be converted to degrees using the PostgreSQL function " 343"<varname>degrees()</varname>." 344msgstr "" 345 346#. Tag: para 347#: reference_measure.xml:107 348#, no-c-format 349msgid "" 350"Azimuth can be used in conjunction with <xref linkend=\"ST_Translate\"/> to " 351"shift an object along its perpendicular axis. See the " 352"<varname>upgis_lineshift()</varname> function in the <ulink url=\"http://" 353"trac.osgeo.org/postgis/wiki/UsersWikiplpgsqlfunctions\">PostGIS wiki</ulink> " 354"for an implementation of this." 355msgstr "" 356 357#. Tag: para 358#: reference_measure.xml:110 359#, no-c-format 360msgid "Availability: 1.1.0" 361msgstr "Disponibilità: 1.1.0" 362 363#. Tag: para 364#: reference_measure.xml:111 365#, no-c-format 366msgid "Enhanced: 2.0.0 support for geography was introduced." 367msgstr "" 368 369#. Tag: para 370#: reference_measure.xml:112 371#, no-c-format 372msgid "" 373"Enhanced: 2.2.0 measurement on spheroid performed with GeographicLib for " 374"improved accuracy and robustness. Requires PROJ >= 4.9.0 to take " 375"advantage of the new feature." 376msgstr "" 377 378#. Tag: para 379#: reference_measure.xml:117 380#, no-c-format 381msgid "Geometry Azimuth in degrees" 382msgstr "" 383 384#. Tag: programlisting 385#: reference_measure.xml:118 386#, no-c-format 387msgid "" 388"SELECT degrees(ST_Azimuth( ST_Point(25, 45), ST_Point(75, 100))) AS " 389"degA_B,\n" 390" degrees(ST_Azimuth( ST_Point(75, 100), ST_Point(25, 45) )) AS " 391"degB_A;\n" 392"\n" 393" dega_b | degb_a\n" 394"------------------+------------------\n" 395" 42.2736890060937 | 222.273689006094" 396msgstr "" 397 398#. Tag: para 399#: reference_measure.xml:128 400#, no-c-format 401msgid "" 402"Green: the start Point(25,45) with its vertical. Yellow: degA_B as the path " 403"to travel (azimuth)." 404msgstr "" 405 406#. Tag: para 407#: reference_measure.xml:137 408#, no-c-format 409msgid "" 410"Green: the start Point(75,100) with its vertical. Yellow: degB_A as the path " 411"to travel (azimuth)." 412msgstr "" 413 414#. Tag: para 415#: reference_measure.xml:148 416#, no-c-format 417msgid "" 418", <xref linkend=\"ST_Point\"/>, <xref linkend=\"ST_Translate\"/>, <xref " 419"linkend=\"ST_Project\"/>, <ulink url=\"http://www.postgresql.org/docs/" 420"current/interactive/functions-math.html\">PostgreSQL Math Functions</ulink>" 421msgstr "" 422 423#. Tag: refname 424#: reference_measure.xml:155 425#, fuzzy, no-c-format 426msgid "ST_Angle" 427msgstr "ST_Area" 428 429#. Tag: refpurpose 430#: reference_measure.xml:157 431#, no-c-format 432msgid "" 433"Returns the angle between two vectors defined by 3 or 4 points, or 2 lines." 434msgstr "" 435 436#. Tag: funcsynopsis 437#: reference_measure.xml:160 438#, fuzzy, no-c-format 439msgid "" 440"<funcprototype> <funcdef>float <function>ST_Angle</function></funcdef> " 441"<paramdef><type>geometry </type><parameter>point1</parameter></paramdef> " 442"<paramdef><type>geometry </type><parameter>point2</parameter></paramdef> " 443"<paramdef><type>geometry </type><parameter>point3</parameter></paramdef> " 444"<paramdef choice=\"opt\"><type>geometry </type><parameter>point4</" 445"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>float " 446"<function>ST_Angle</function></funcdef> <paramdef><type>geometry </" 447"type><parameter>line1</parameter></paramdef> <paramdef><type>geometry </" 448"type><parameter>line2</parameter></paramdef> </funcprototype>" 449msgstr "" 450"<funcprototype> <funcdef>float <function>ST_Azimuth</function></funcdef> " 451"<paramdef><type>geometry </type><parameter>pointA</parameter></paramdef> " 452"<paramdef><type>geometry </type><parameter>pointB</parameter></paramdef> </" 453"funcprototype> <funcprototype> <funcdef>float <function>ST_Azimuth</" 454"function></funcdef> <paramdef><type>geography </type><parameter>pointA</" 455"parameter></paramdef> <paramdef><type>geography </type><parameter>pointB</" 456"parameter></paramdef> </funcprototype>" 457 458#. Tag: para 459#: reference_measure.xml:178 460#, no-c-format 461msgid "Computes the clockwise angle between two vectors." 462msgstr "" 463 464#. Tag: para 465#: reference_measure.xml:181 466#, no-c-format 467msgid "" 468"<emphasis role=\"bold\">Variant 1:</emphasis> computes the angle enclosed by " 469"the points P1-P2-P3. If a 4th point provided computes the angle points P1-P2 " 470"and P3-P4" 471msgstr "" 472 473#. Tag: para 474#: reference_measure.xml:182 475#, no-c-format 476msgid "" 477"<emphasis role=\"bold\">Variant 2:</emphasis> computes the angle between two " 478"vectors S1-E1 and S2-E2, defined by the start and end points of the input " 479"lines" 480msgstr "" 481 482#. Tag: para 483#: reference_measure.xml:186 484#, no-c-format 485msgid "" 486"The result is a positive angle between 0 and 2π radians. The radian " 487"result can be converted to degrees using the PostgreSQL function " 488"<varname>degrees()</varname>." 489msgstr "" 490 491#. Tag: para 492#: reference_measure.xml:189 493#, no-c-format 494msgid "" 495"Note that <varname>ST_Angle(P1,P2,P3) = ST_Angle(P2,P1,P2,P3)</varname>." 496msgstr "" 497 498#. Tag: para 499#: reference_measure.xml:190 500#, fuzzy, no-c-format 501msgid "Availability: 2.5.0" 502msgstr "Disponibilità: 2.0" 503 504#. Tag: para 505#: reference_measure.xml:196 506#, no-c-format 507msgid "Angle between three points" 508msgstr "" 509 510#. Tag: programlisting 511#: reference_measure.xml:197 512#, no-c-format 513msgid "" 514"SELECT degrees( ST_Angle('POINT(0 0)', 'POINT(10 10)', 'POINT(20 0)') );\n" 515"\n" 516" degrees\n" 517"---------\n" 518" 270" 519msgstr "" 520 521#. Tag: para 522#: reference_measure.xml:199 523#, no-c-format 524msgid "Angle between vectors defined by four points" 525msgstr "" 526 527#. Tag: programlisting 528#: reference_measure.xml:200 529#, no-c-format 530msgid "" 531"SELECT degrees( ST_Angle('POINT (10 10)', 'POINT (0 0)', 'POINT(90 90)', " 532"'POINT (100 80)') );\n" 533"\n" 534" degrees\n" 535"-------------------\n" 536" 269.9999999999999" 537msgstr "" 538 539#. Tag: para 540#: reference_measure.xml:202 541#, no-c-format 542msgid "Angle between vectors defined by the start and end points of lines" 543msgstr "" 544 545#. Tag: programlisting 546#: reference_measure.xml:203 547#, fuzzy, no-c-format 548msgid "" 549"SELECT degrees( ST_Angle('LINESTRING(0 0, 0.3 0.7, 1 1)', 'LINESTRING(0 0, " 550"0.2 0.5, 1 0)') );\n" 551"\n" 552" degrees\n" 553"--------------\n" 554" 45" 555msgstr "" 556"postgis=# SELECT st_hausdorffdistance('LINESTRING (130 0, 0 0, 0 150)'::" 557"geometry, 'LINESTRING (10 10, 10 150, 130 10)'::geometry, 0.5);\n" 558" st_hausdorffdistance\n" 559" ----------------------\n" 560" 70\n" 561"(1 row)" 562 563#. Tag: refname 564#: reference_measure.xml:216 565#, no-c-format 566msgid "ST_ClosestPoint" 567msgstr "ST_ClosestPoint" 568 569#. Tag: refpurpose 570#: reference_measure.xml:218 571#, no-c-format 572msgid "" 573"Returns the 2D point on g1 that is closest to g2. This is the first point of " 574"the shortest line." 575msgstr "" 576 577#. Tag: funcprototype 578#: reference_measure.xml:224 579#, no-c-format 580msgid "" 581"<funcdef>geometry <function>ST_ClosestPoint</function></funcdef> " 582"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 583"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 584msgstr "" 585"<funcdef>geometry <function>ST_ClosestPoint</function></funcdef> " 586"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 587"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 588 589#. Tag: para 590#: reference_measure.xml:239 591#, no-c-format 592msgid "" 593"Returns the 2-dimensional point on g1 that is closest to g2. This is the " 594"first point of the shortest line." 595msgstr "" 596 597#. Tag: para 598#: reference_measure.xml:242 599#, no-c-format 600msgid "" 601"If you have a 3D Geometry, you may prefer to use <xref linkend=" 602"\"ST_3DClosestPoint\"/>." 603msgstr "" 604 605#. Tag: para 606#: reference_measure.xml:243 reference_measure.xml:716 607#: reference_measure.xml:951 reference_measure.xml:1116 608#: reference_measure.xml:1530 609#, no-c-format 610msgid "Availability: 1.5.0" 611msgstr "Disponibilità: 1.5.0" 612 613#. Tag: para 614#: reference_measure.xml:257 615#, no-c-format 616msgid "" 617"Closest between point and linestring is the point itself, but closest point " 618"between a linestring and point is the point on line string that is closest." 619msgstr "" 620 621#. Tag: programlisting 622#: reference_measure.xml:261 623#, fuzzy, no-c-format 624msgid "" 625"SELECT ST_AsText(ST_ClosestPoint(pt,line)) AS cp_pt_line,\n" 626" ST_AsText(ST_ClosestPoint(line,pt)) As cp_line_pt\n" 627"FROM (SELECT 'POINT(100 100)'::geometry As pt,\n" 628" 'LINESTRING (20 80, 98 190, 110 180, 50 75 )'::geometry As " 629"line\n" 630" ) As foo;\n" 631"\n" 632"\n" 633" cp_pt_line | cp_line_pt\n" 634"----------------+------------------------------------------\n" 635" POINT(100 100) | POINT(73.0769230769231 115.384615384615)" 636msgstr "" 637"SELECT ST_AsText(ST_ClosestPoint(pt,line)) AS cp_pt_line, \n" 638" ST_AsText(ST_ClosestPoint(line,pt)) As cp_line_pt\n" 639"FROM (SELECT 'POINT(100 100)'::geometry As pt, \n" 640" 'LINESTRING (20 80, 98 190, 110 180, 50 75 )'::geometry As " 641"line\n" 642" ) As foo;\n" 643"\n" 644" \n" 645" cp_pt_line | cp_line_pt\n" 646"----------------+------------------------------------------\n" 647" POINT(100 100) | POINT(73.0769230769231 115.384615384615)" 648 649#. Tag: para 650#: reference_measure.xml:269 651#, no-c-format 652msgid "closest point on polygon A to polygon B" 653msgstr "" 654 655#. Tag: programlisting 656#: reference_measure.xml:272 657#, fuzzy, no-c-format 658msgid "" 659"SELECT ST_AsText(\n" 660" ST_ClosestPoint(\n" 661" ST_GeomFromText('POLYGON((175 150, 20 40, 50 60, 125 " 662"100, 175 150))'),\n" 663" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 664" )\n" 665" ) As ptwkt;\n" 666"\n" 667" ptwkt\n" 668"------------------------------------------\n" 669" POINT(140.752120669087 125.695053378061)" 670msgstr "" 671"SELECT ST_AsText(\n" 672" ST_ClosestPoint(\n" 673" ST_GeomFromText('POLYGON((175 150, 20 40, 50 60, 125 " 674"100, 175 150))'),\n" 675" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 676" ) \n" 677" ) As ptwkt;\n" 678" \n" 679" ptwkt\n" 680"------------------------------------------\n" 681" POINT(140.752120669087 125.695053378061)" 682 683#. Tag: para 684#: reference_measure.xml:284 685#, no-c-format 686msgid "" 687",<xref linkend=\"ST_Distance\"/>, <xref linkend=\"ST_LongestLine\"/>, <xref " 688"linkend=\"ST_ShortestLine\"/>, <xref linkend=\"ST_MaxDistance\"/>" 689msgstr "" 690",<xref linkend=\"ST_Distance\"/>, <xref linkend=\"ST_LongestLine\"/>, <xref " 691"linkend=\"ST_ShortestLine\"/>, <xref linkend=\"ST_MaxDistance\"/>" 692 693#. Tag: refname 694#: reference_measure.xml:290 695#, no-c-format 696msgid "ST_3DClosestPoint" 697msgstr "ST_3DClosestPoint" 698 699#. Tag: refpurpose 700#: reference_measure.xml:292 701#, no-c-format 702msgid "" 703"Returns the 3D point on g1 that is closest to g2. This is the first point of " 704"the 3D shortest line." 705msgstr "" 706 707#. Tag: funcprototype 708#: reference_measure.xml:298 709#, no-c-format 710msgid "" 711"<funcdef>geometry <function>ST_3DClosestPoint</function></funcdef> " 712"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 713"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 714msgstr "" 715"<funcdef>geometry <function>ST_3DClosestPoint</function></funcdef> " 716"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 717"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 718 719#. Tag: para 720#: reference_measure.xml:313 721#, no-c-format 722msgid "" 723"Returns the 3-dimensional point on g1 that is closest to g2. This is the " 724"first point of the 3D shortest line. The 3D length of the 3D shortest line " 725"is the 3D distance." 726msgstr "" 727 728#. Tag: para 729#: reference_measure.xml:316 reference_measure.xml:473 730#: reference_measure.xml:850 reference_measure.xml:902 731#: reference_measure.xml:1048 reference_measure.xml:1162 732#: reference_measure.xml:1420 reference_measure.xml:1609 733#, no-c-format 734msgid "&Z_support;" 735msgstr "&Z_support;" 736 737#. Tag: para 738#: reference_measure.xml:319 reference_measure.xml:478 739#: reference_measure.xml:1046 reference_measure.xml:1166 740#: reference_measure.xml:1477 reference_measure.xml:1607 741#, no-c-format 742msgid "Availability: 2.0.0" 743msgstr "Disponibilità: 2.0" 744 745#. Tag: para 746#: reference_measure.xml:320 reference_measure.xml:1047 747#: reference_measure.xml:1608 748#, no-c-format 749msgid "" 750"Changed: 2.2.0 - if 2 2D geometries are input, a 2D point is returned " 751"(instead of old behavior assuming 0 for missing Z). In case of 2D and 3D, Z " 752"is no longer assumed to be 0 for missing Z." 753msgstr "" 754 755#. Tag: para 756#: reference_measure.xml:329 757#, no-c-format 758msgid "linestring and point -- both 3d and 2d closest point" 759msgstr "" 760 761#. Tag: programlisting 762#: reference_measure.xml:330 763#, fuzzy, no-c-format 764msgid "" 765"SELECT ST_AsEWKT(ST_3DClosestPoint(line,pt)) AS cp3d_line_pt,\n" 766" ST_AsEWKT(ST_ClosestPoint(line,pt)) As cp2d_line_pt\n" 767" FROM (SELECT 'POINT(100 100 30)'::geometry As pt,\n" 768" 'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 " 769"1000)'::geometry As line\n" 770" ) As foo;\n" 771"\n" 772"\n" 773" cp3d_line_pt | " 774"cp2d_line_pt\n" 775"-----------------------------------------------------------" 776"+------------------------------------------\n" 777" POINT(54.6993798867619 128.935022917228 11.5475869506606) | " 778"POINT(73.0769230769231 115.384615384615)" 779msgstr "" 780"SELECT ST_AsEWKT(ST_3DClosestPoint(line,pt)) AS cp3d_line_pt, \n" 781" ST_AsEWKT(ST_ClosestPoint(line,pt)) As cp2d_line_pt\n" 782" FROM (SELECT 'POINT(100 100 30)'::geometry As pt, \n" 783" 'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 " 784"1000)'::geometry As line\n" 785" ) As foo;\n" 786" \n" 787" \n" 788" cp3d_line_pt " 789"| cp2d_line_pt\n" 790"-----------------------------------------------------------" 791"+------------------------------------------\n" 792" POINT(54.6993798867619 128.935022917228 11.5475869506606) | " 793"POINT(73.0769230769231 115.384615384615)" 794 795#. Tag: para 796#: reference_measure.xml:334 797#, no-c-format 798msgid "linestring and multipoint -- both 3d and 2d closest point" 799msgstr "" 800 801#. Tag: programlisting 802#: reference_measure.xml:335 803#, fuzzy, no-c-format 804msgid "" 805"SELECT ST_AsEWKT(ST_3DClosestPoint(line,pt)) AS cp3d_line_pt,\n" 806" ST_AsEWKT(ST_ClosestPoint(line,pt)) As cp2d_line_pt\n" 807" FROM (SELECT 'MULTIPOINT(100 100 30, 50 74 1000)'::geometry As pt,\n" 808" 'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 " 809"900)'::geometry As line\n" 810" ) As foo;\n" 811"\n" 812"\n" 813" cp3d_line_pt | cp2d_line_pt\n" 814"-----------------------------------------------------------+--------------\n" 815" POINT(54.6993798867619 128.935022917228 11.5475869506606) | POINT(50 75)" 816msgstr "" 817"SELECT ST_AsEWKT(ST_3DClosestPoint(line,pt)) AS cp3d_line_pt, \n" 818" ST_AsEWKT(ST_ClosestPoint(line,pt)) As cp2d_line_pt\n" 819" FROM (SELECT 'MULTIPOINT(100 100 30, 50 74 1000)'::geometry As pt, \n" 820" 'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 " 821"900)'::geometry As line\n" 822" ) As foo;\n" 823" \n" 824" \n" 825" cp3d_line_pt | cp2d_line_pt\n" 826"-----------------------------------------------------------+--------------\n" 827" POINT(54.6993798867619 128.935022917228 11.5475869506606) | POINT(50 75)" 828 829#. Tag: para 830#: reference_measure.xml:339 831#, no-c-format 832msgid "Multilinestring and polygon both 3d and 2d closest point" 833msgstr "" 834 835#. Tag: programlisting 836#: reference_measure.xml:340 837#, fuzzy, no-c-format 838msgid "" 839"SELECT ST_AsEWKT(ST_3DClosestPoint(poly, mline)) As cp3d,\n" 840" ST_AsEWKT(ST_ClosestPoint(poly, mline)) As cp2d\n" 841" FROM (SELECT ST_GeomFromEWKT('POLYGON((175 150 5, 20 40 5, 35 45 5, " 842"50 60 5, 100 100 5, 175 150 5))') As poly,\n" 843" ST_GeomFromEWKT('MULTILINESTRING((175 155 2, 20 40 20, 50 60 " 844"-2, 125 100 1, 175 155 1),\n" 845" (1 10 2, 5 20 1))') As mline ) As foo;\n" 846" cp3d | cp2d\n" 847"-------------------------------------------+--------------\n" 848" POINT(39.993580415989 54.1889925532825 5) | POINT(20 40)" 849msgstr "" 850"SELECT ST_AsEWKT(ST_3DClosestPoint(poly, mline)) As cp3d,\n" 851" ST_AsEWKT(ST_ClosestPoint(poly, mline)) As cp2d \n" 852" FROM (SELECT ST_GeomFromEWKT('POLYGON((175 150 5, 20 40 5, 35 45 5, " 853"50 60 5, 100 100 5, 175 150 5))') As poly,\n" 854" ST_GeomFromEWKT('MULTILINESTRING((175 155 2, 20 40 20, 50 60 " 855"-2, 125 100 1, 175 155 1),\n" 856" (1 10 2, 5 20 1))') As mline ) As foo;\n" 857" cp3d | cp2d\n" 858"-------------------------------------------+--------------\n" 859" POINT(39.993580415989 54.1889925532825 5) | POINT(20 40)" 860 861#. Tag: para 862#: reference_measure.xml:352 863#, no-c-format 864msgid "" 865", <xref linkend=\"ST_ClosestPoint\"/>, <xref linkend=\"ST_3DDistance\"/>, " 866"<xref linkend=\"ST_3DShortestLine\"/>" 867msgstr "" 868", <xref linkend=\"ST_ClosestPoint\"/>, <xref linkend=\"ST_3DDistance\"/>, " 869"<xref linkend=\"ST_3DShortestLine\"/>" 870 871#. Tag: refname 872#: reference_measure.xml:358 873#, no-c-format 874msgid "ST_Distance" 875msgstr "ST_Distance" 876 877#. Tag: refpurpose 878#: reference_measure.xml:360 879#, no-c-format 880msgid "Returns the distance between two geometry or geography values." 881msgstr "" 882 883#. Tag: funcsynopsis 884#: reference_measure.xml:363 885#, fuzzy, no-c-format 886msgid "" 887"<funcprototype> <funcdef>float <function>ST_Distance</function></funcdef> " 888"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 889"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> </" 890"funcprototype> <funcprototype> <funcdef>float <function>ST_Distance</" 891"function></funcdef> <paramdef><type>geography </type> <parameter>geog1</" 892"parameter></paramdef> <paramdef><type>geography </type> <parameter>geog2</" 893"parameter></paramdef> <paramdef choice=\"opt\"><type>boolean </type> " 894"<parameter>use_spheroid=true</parameter></paramdef> </funcprototype>" 895msgstr "" 896"<funcprototype> <funcdef>float <function>ST_HausdorffDistance</function></" 897"funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></" 898"paramdef> <paramdef><type>geometry </type> <parameter>g2</parameter></" 899"paramdef> </funcprototype> <funcprototype> <funcdef>float " 900"<function>ST_HausdorffDistance</function></funcdef> <paramdef><type>geometry " 901"</type> <parameter>g1</parameter></paramdef> <paramdef><type>geometry </" 902"type> <parameter>g2</parameter></paramdef> <paramdef><type>float</type> " 903"<parameter>densifyFrac</parameter></paramdef> </funcprototype>" 904 905#. Tag: para 906#: reference_measure.xml:394 907#, no-c-format 908msgid "" 909"For <xref linkend=\"geometry\"/> types returns the minimum 2D Cartesian " 910"(planar) distance between two geometries, in projected units (spatial ref " 911"units)." 912msgstr "" 913 914#. Tag: para 915#: reference_measure.xml:397 916#, no-c-format 917msgid "" 918"For <xref linkend=\"geography\"/> types defaults to return the minimum " 919"geodesic distance between two geographies in meters, compute on the spheroid " 920"determined by the SRID. If <varname>use_spheroid</varname> is false, a " 921"faster spherical calculation is used." 922msgstr "" 923 924#. Tag: para 925#: reference_measure.xml:403 926#, no-c-format 927msgid "&sqlmm_compliant; SQL-MM 3: 5.1.23" 928msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.23" 929 930#. Tag: para 931#: reference_measure.xml:404 932#, no-c-format 933msgid "&curve_support;" 934msgstr "&curve_support;" 935 936#. Tag: para 937#: reference_measure.xml:406 938#, no-c-format 939msgid "" 940"Availability: 1.5.0 geography support was introduced in 1.5. Speed " 941"improvements for planar to better handle large or many vertex geometries" 942msgstr "" 943 944#. Tag: para 945#: reference_measure.xml:407 946#, no-c-format 947msgid "" 948"Enhanced: 2.1.0 improved speed for geography. See <ulink url=\"http://" 949"boundlessgeo.com/2012/07/making-geography-faster/\">Making Geography faster</" 950"ulink> for details." 951msgstr "" 952 953#. Tag: para 954#: reference_measure.xml:408 955#, no-c-format 956msgid "Enhanced: 2.1.0 - support for curved geometries was introduced." 957msgstr "" 958 959#. Tag: title 960#: reference_measure.xml:414 961#, no-c-format 962msgid "Basic Geometry Examples" 963msgstr "" 964 965#. Tag: para 966#: reference_measure.xml:416 967#, no-c-format 968msgid "" 969"Geometry example - units in planar degrees 4326 is WGS 84 long lat, units " 970"are degrees." 971msgstr "" 972 973#. Tag: programlisting 974#: reference_measure.xml:417 975#, fuzzy, no-c-format 976msgid "" 977"SELECT ST_Distance(\n" 978" 'SRID=4326;POINT(-72.1235 42.3521)'::geometry,\n" 979" 'SRID=4326;LINESTRING(-72.1260 42.45, -72.123 42.1546)'::" 980"geometry\n" 981" );\n" 982"st_distance\n" 983"-----------------\n" 984"0.00150567726382282" 985msgstr "" 986"SELECT ST_AsText(\n" 987" ST_LongestLine('POINT(100 100)'::geometry, \n" 988" 'LINESTRING (20 80, 98 190, 110 180, 50 75 )'::geometry)\n" 989" ) As lline;\n" 990"\n" 991" \n" 992" lline\n" 993"-----------------\n" 994"LINESTRING(100 100,98 190)" 995 996#. Tag: para 997#: reference_measure.xml:419 998#, no-c-format 999msgid "" 1000"Geometry example - units in meters (SRID: 3857, proportional to pixels on " 1001"popular web maps). Although the value is off, nearby ones can be compared " 1002"correctly, which makes it a good choice for algorithms like KNN or KMeans." 1003msgstr "" 1004 1005#. Tag: programlisting 1006#: reference_measure.xml:422 1007#, fuzzy, no-c-format 1008msgid "" 1009"SELECT ST_Distance(\n" 1010" ST_Transform('SRID=4326;POINT(-72.1235 42.3521)'::" 1011"geometry, 3857),\n" 1012" ST_Transform('SRID=4326;LINESTRING(-72.1260 42.45, " 1013"-72.123 42.1546)'::geometry, 3857)\n" 1014" );\n" 1015"st_distance\n" 1016"-----------------\n" 1017"167.441410065196" 1018msgstr "" 1019"SELECT ST_Intersects(\n" 1020" ST_GeographyFromText('SRID=4326;LINESTRING(-43.23456 " 1021"72.4567,-43.23456 72.4568)'),\n" 1022" ST_GeographyFromText('SRID=4326;POINT(-43.23456 " 1023"72.4567772)')\n" 1024" );\n" 1025"\n" 1026" st_intersects\n" 1027"---------------\n" 1028"t" 1029 1030#. Tag: para 1031#: reference_measure.xml:424 1032#, no-c-format 1033msgid "" 1034"Geometry example - units in meters (SRID: 3857 as above, but corrected by " 1035"cos(lat) to account for distortion)" 1036msgstr "" 1037 1038#. Tag: programlisting 1039#: reference_measure.xml:425 1040#, fuzzy, no-c-format 1041msgid "" 1042"SELECT ST_Distance(\n" 1043" ST_Transform('SRID=4326;POINT(-72.1235 42.3521)'::" 1044"geometry, 3857),\n" 1045" ST_Transform('SRID=4326;LINESTRING(-72.1260 42.45, " 1046"-72.123 42.1546)'::geometry, 3857)\n" 1047" ) * cosd(42.3521);\n" 1048"st_distance\n" 1049"-----------------\n" 1050"123.742351254151" 1051msgstr "" 1052"SELECT ST_Intersects(\n" 1053" ST_GeographyFromText('SRID=4326;LINESTRING(-43.23456 " 1054"72.4567,-43.23456 72.4568)'),\n" 1055" ST_GeographyFromText('SRID=4326;POINT(-43.23456 " 1056"72.4567772)')\n" 1057" );\n" 1058"\n" 1059" st_intersects\n" 1060"---------------\n" 1061"t" 1062 1063#. Tag: para 1064#: reference_measure.xml:427 1065#, no-c-format 1066msgid "" 1067"Geometry example - units in meters (SRID: 26986 Massachusetts state plane " 1068"meters) (most accurate for Massachusetts)" 1069msgstr "" 1070 1071#. Tag: programlisting 1072#: reference_measure.xml:428 1073#, fuzzy, no-c-format 1074msgid "" 1075"SELECT ST_Distance(\n" 1076" ST_Transform('SRID=4326;POINT(-72.1235 42.3521)'::" 1077"geometry, 26986),\n" 1078" ST_Transform('SRID=4326;LINESTRING(-72.1260 42.45, " 1079"-72.123 42.1546)'::geometry, 26986)\n" 1080" );\n" 1081"st_distance\n" 1082"-----------------\n" 1083"123.797937878454" 1084msgstr "" 1085"SELECT ST_Intersects(\n" 1086" ST_GeographyFromText('SRID=4326;LINESTRING(-43.23456 " 1087"72.4567,-43.23456 72.4568)'),\n" 1088" ST_GeographyFromText('SRID=4326;POINT(-43.23456 " 1089"72.4567772)')\n" 1090" );\n" 1091"\n" 1092" st_intersects\n" 1093"---------------\n" 1094"t" 1095 1096#. Tag: para 1097#: reference_measure.xml:430 1098#, no-c-format 1099msgid "" 1100"Geometry example - units in meters (SRID: 2163 US National Atlas Equal area) " 1101"(least accurate)" 1102msgstr "" 1103 1104#. Tag: programlisting 1105#: reference_measure.xml:431 1106#, fuzzy, no-c-format 1107msgid "" 1108"SELECT ST_Distance(\n" 1109" ST_Transform('SRID=4326;POINT(-72.1235 42.3521)'::" 1110"geometry, 2163),\n" 1111" ST_Transform('SRID=4326;LINESTRING(-72.1260 42.45, " 1112"-72.123 42.1546)'::geometry, 2163)\n" 1113" );\n" 1114"\n" 1115"st_distance\n" 1116"------------------\n" 1117"126.664256056812" 1118msgstr "" 1119"SELECT ST_Intersects(\n" 1120" ST_GeographyFromText('SRID=4326;LINESTRING(-43.23456 " 1121"72.4567,-43.23456 72.4568)'),\n" 1122" ST_GeographyFromText('SRID=4326;POINT(-43.23456 " 1123"72.4567772)')\n" 1124" );\n" 1125"\n" 1126" st_intersects\n" 1127"---------------\n" 1128"t" 1129 1130#. Tag: title 1131#: reference_measure.xml:434 reference_measure.xml:787 1132#, no-c-format 1133msgid "Geography Examples" 1134msgstr "" 1135 1136#. Tag: para 1137#: reference_measure.xml:435 1138#, no-c-format 1139msgid "" 1140"Same as geometry example but note units in meters - use sphere for slightly " 1141"faster and less accurate computation." 1142msgstr "" 1143 1144#. Tag: programlisting 1145#: reference_measure.xml:436 1146#, no-c-format 1147msgid "" 1148"SELECT ST_Distance(gg1, gg2) As spheroid_dist, ST_Distance(gg1, gg2, false) " 1149"As sphere_dist\n" 1150"FROM (SELECT\n" 1151" 'SRID=4326;POINT(-72.1235 42.3521)'::geography as gg1,\n" 1152" 'SRID=4326;LINESTRING(-72.1260 42.45, -72.123 42.1546)'::geography " 1153"as gg2\n" 1154" ) As foo ;\n" 1155"\n" 1156" spheroid_dist | sphere_dist\n" 1157"------------------+------------------\n" 1158" 123.802076746848 | 123.475736916397" 1159msgstr "" 1160 1161#. Tag: para 1162#: reference_measure.xml:441 1163#, fuzzy, no-c-format 1164msgid "" 1165", <xref linkend=\"ST_DWithin\"/>, <xref linkend=\"ST_DistanceSphere\"/>, " 1166"<xref linkend=\"ST_Distance_Spheroid\"/>, <xref linkend=\"ST_MaxDistance\"/" 1167">, <xref linkend=\"ST_HausdorffDistance\"/>, <xref linkend=" 1168"\"ST_FrechetDistance\"/>, <xref linkend=\"ST_Transform\"/>" 1169msgstr "" 1170", <xref linkend=\"ST_Boundary\"/>, <xref linkend=\"ST_Contains\"/>, <xref " 1171"linkend=\"ST_Covers\"/>, <xref linkend=\"ST_CoveredBy\"/>, <xref linkend=" 1172"\"ST_Equals\"/>, <xref linkend=\"ST_Relate\"/>, <xref linkend=\"ST_Within\"/>" 1173 1174#. Tag: refname 1175#: reference_measure.xml:448 1176#, no-c-format 1177msgid "ST_3DDistance" 1178msgstr "ST_3DDistance" 1179 1180#. Tag: refpurpose 1181#: reference_measure.xml:450 1182#, no-c-format 1183msgid "" 1184"Returns the 3D cartesian minimum distance (based on spatial ref) between two " 1185"geometries in projected units." 1186msgstr "" 1187 1188#. Tag: funcprototype 1189#: reference_measure.xml:455 1190#, no-c-format 1191msgid "" 1192"<funcdef>float <function>ST_3DDistance</function></funcdef> " 1193"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 1194"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 1195msgstr "" 1196"<funcdef>float <function>ST_3DDistance</function></funcdef> " 1197"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 1198"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 1199 1200#. Tag: para 1201#: reference_measure.xml:470 1202#, no-c-format 1203msgid "" 1204"Returns the 3-dimensional minimum cartesian distance between two geometries " 1205"in projected units (spatial ref units)." 1206msgstr "" 1207 1208#. Tag: para 1209#: reference_measure.xml:476 1210#, no-c-format 1211msgid "&sqlmm_compliant; SQL-MM ?" 1212msgstr "&sqlmm_compliant; SQL-MM ?" 1213 1214#. Tag: para 1215#: reference_measure.xml:479 reference_measure.xml:1167 1216#, no-c-format 1217msgid "" 1218"Changed: 2.2.0 - In case of 2D and 3D, Z is no longer assumed to be 0 for " 1219"missing Z." 1220msgstr "" 1221 1222#. Tag: para 1223#: reference_measure.xml:480 1224#, no-c-format 1225msgid "Changed: 3.0.0 - SFCGAL version removed" 1226msgstr "" 1227 1228#. Tag: programlisting 1229#: reference_measure.xml:486 1230#, no-c-format 1231msgid "" 1232"-- Geometry example - units in meters (SRID: 2163 US National Atlas Equal " 1233"area) (3D point and line compared 2D point and line)\n" 1234"-- Note: currently no vertical datum support so Z is not transformed and " 1235"assumed to be same units as final.\n" 1236"SELECT ST_3DDistance(\n" 1237" ST_Transform('SRID=4326;POINT(-72.1235 42.3521 4)'::" 1238"geometry,2163),\n" 1239" ST_Transform('SRID=4326;LINESTRING(-72.1260 42.45 " 1240"15, -72.123 42.1546 20)'::geometry,2163)\n" 1241" ) As dist_3d,\n" 1242" ST_Distance(\n" 1243" ST_Transform('SRID=4326;POINT(-72.1235 42.3521)'::" 1244"geometry,2163),\n" 1245" ST_Transform('SRID=4326;LINESTRING(-72.1260 42.45, " 1246"-72.123 42.1546)'::geometry,2163)\n" 1247" ) As dist_2d;\n" 1248"\n" 1249" dist_3d | dist_2d\n" 1250"------------------+-----------------\n" 1251" 127.295059324629 | 126.66425605671" 1252msgstr "" 1253 1254#. Tag: programlisting 1255#: reference_measure.xml:487 1256#, fuzzy, no-c-format 1257msgid "" 1258"-- Multilinestring and polygon both 3d and 2d distance\n" 1259"-- Same example as 3D closest point example\n" 1260"SELECT ST_3DDistance(poly, mline) As dist3d,\n" 1261" ST_Distance(poly, mline) As dist2d\n" 1262" FROM (SELECT 'POLYGON((175 150 5, 20 40 5, 35 45 5, 50 60 5, 100 " 1263"100 5, 175 150 5))'::geometry as poly,\n" 1264" 'MULTILINESTRING((175 155 2, 20 40 20, 50 60 -2, 125 100 1, " 1265"175 155 1), (1 10 2, 5 20 1))'::geometry as mline) as foo;\n" 1266" dist3d | dist2d\n" 1267"-------------------+--------\n" 1268" 0.716635696066337 | 0" 1269msgstr "" 1270"SELECT ST_AsEWKT(ST_3DLongestLine(poly, mline)) As lol3d,\n" 1271" ST_AsEWKT(ST_LongestLine(poly, mline)) As lol2d \n" 1272" FROM (SELECT ST_GeomFromEWKT('POLYGON((175 150 5, 20 40 5, 35 45 5, " 1273"50 60 5, 100 100 5, 175 150 5))') As poly,\n" 1274" ST_GeomFromEWKT('MULTILINESTRING((175 155 2, 20 40 20, 50 60 " 1275"-2, 125 100 1, 175 155 1),\n" 1276" (1 10 2, 5 20 1))') As mline ) As foo;\n" 1277" lol3d | lol2d\n" 1278"------------------------------+--------------------------\n" 1279" LINESTRING(175 150 5,1 10 2) | LINESTRING(175 150,1 10)" 1280 1281#. Tag: para 1282#: reference_measure.xml:493 1283#, no-c-format 1284msgid "" 1285", <xref linkend=\"ST_3DClosestPoint\"/>, <xref linkend=\"ST_3DDWithin\"/>, " 1286"<xref linkend=\"ST_3DMaxDistance\"/>, <xref linkend=\"ST_3DShortestLine\"/>, " 1287"<xref linkend=\"ST_Transform\"/>" 1288msgstr "" 1289", <xref linkend=\"ST_3DClosestPoint\"/>, <xref linkend=\"ST_3DDWithin\"/>, " 1290"<xref linkend=\"ST_3DMaxDistance\"/>, <xref linkend=\"ST_3DShortestLine\"/>, " 1291"<xref linkend=\"ST_Transform\"/>" 1292 1293#. Tag: refname 1294#: reference_measure.xml:499 1295#, no-c-format 1296msgid "ST_DistanceSphere" 1297msgstr "" 1298 1299#. Tag: refpurpose 1300#: reference_measure.xml:501 1301#, no-c-format 1302msgid "" 1303"Returns minimum distance in meters between two lon/lat geometries using a " 1304"spherical earth model." 1305msgstr "" 1306 1307#. Tag: funcprototype 1308#: reference_measure.xml:508 1309#, no-c-format 1310msgid "" 1311"<funcdef>float <function>ST_DistanceSphere</function></funcdef> " 1312"<paramdef><type>geometry </type> <parameter>geomlonlatA</parameter></" 1313"paramdef> <paramdef><type>geometry </type> <parameter>geomlonlatB</" 1314"parameter></paramdef>" 1315msgstr "" 1316 1317#. Tag: para 1318#: reference_measure.xml:519 1319#, no-c-format 1320msgid "" 1321"Returns minimum distance in meters between two lon/lat points. Uses a " 1322"spherical earth and radius derived from the spheroid defined by the SRID. " 1323"Faster than <xref linkend=\"ST_Distance_Spheroid\"/>, but less accurate. " 1324"PostGIS Versions prior to 1.5 only implemented for points." 1325msgstr "" 1326 1327#. Tag: para 1328#: reference_measure.xml:525 reference_measure.xml:575 1329#, no-c-format 1330msgid "" 1331"Availability: 1.5 - support for other geometry types besides points was " 1332"introduced. Prior versions only work with points." 1333msgstr "" 1334 1335#. Tag: para 1336#: reference_measure.xml:526 1337#, no-c-format 1338msgid "" 1339"Changed: 2.2.0 In prior versions this used to be called ST_Distance_Sphere" 1340msgstr "" 1341 1342#. Tag: programlisting 1343#: reference_measure.xml:533 1344#, no-c-format 1345msgid "" 1346"SELECT round(CAST(ST_DistanceSphere(ST_Centroid(geom), " 1347"ST_GeomFromText('POINT(-118 38)',4326)) As numeric),2) As dist_meters,\n" 1348"round(CAST(ST_Distance(ST_Transform(ST_Centroid(geom),32611),\n" 1349" ST_Transform(ST_GeomFromText('POINT(-118 38)', 4326),32611)) " 1350"As numeric),2) As dist_utm11_meters,\n" 1351"round(CAST(ST_Distance(ST_Centroid(geom), ST_GeomFromText('POINT(-118 38)', " 1352"4326)) As numeric),5) As dist_degrees,\n" 1353"round(CAST(ST_Distance(ST_Transform(geom,32611),\n" 1354" ST_Transform(ST_GeomFromText('POINT(-118 38)', 4326),32611)) " 1355"As numeric),2) As min_dist_line_point_meters\n" 1356"FROM\n" 1357" (SELECT ST_GeomFromText('LINESTRING(-118.584 38.374,-118.583 38.5)', " 1358"4326) As geom) as foo;\n" 1359" dist_meters | dist_utm11_meters | dist_degrees | " 1360"min_dist_line_point_meters\n" 1361" -------------+-------------------+--------------" 1362"+----------------------------\n" 1363" 70424.47 | 70438.00 | 0.72900 " 1364"| 65871.18" 1365msgstr "" 1366 1367#. Tag: para 1368#: reference_measure.xml:540 1369#, no-c-format 1370msgid ", <xref linkend=\"ST_Distance_Spheroid\"/>" 1371msgstr ", <xref linkend=\"ST_Distance_Spheroid\"/>" 1372 1373#. Tag: refname 1374#: reference_measure.xml:546 1375#, no-c-format 1376msgid "ST_DistanceSpheroid" 1377msgstr "" 1378 1379#. Tag: refpurpose 1380#: reference_measure.xml:548 1381#, no-c-format 1382msgid "" 1383"Returns the minimum distance between two lon/lat geometries using a " 1384"spheroidal earth model." 1385msgstr "" 1386 1387#. Tag: funcprototype 1388#: reference_measure.xml:554 1389#, no-c-format 1390msgid "" 1391"<funcdef>float <function>ST_DistanceSpheroid</function></funcdef> " 1392"<paramdef><type>geometry </type> <parameter>geomlonlatA</parameter></" 1393"paramdef> <paramdef><type>geometry </type> <parameter>geomlonlatB</" 1394"parameter></paramdef> <paramdef><type>spheroid </type> " 1395"<parameter>measurement_spheroid</parameter></paramdef>" 1396msgstr "" 1397 1398#. Tag: para 1399#: reference_measure.xml:566 1400#, no-c-format 1401msgid "" 1402"Returns minimum distance in meters between two lon/lat geometries given a " 1403"particular spheroid. See the explanation of spheroids given for <xref " 1404"linkend=\"ST_Length_Spheroid\"/>." 1405msgstr "" 1406 1407#. Tag: para 1408#: reference_measure.xml:570 1409#, no-c-format 1410msgid "" 1411"This function does not look at the SRID of the geometry. It assumes the " 1412"geometry coordinates are based on the provided spheroid." 1413msgstr "" 1414 1415#. Tag: para 1416#: reference_measure.xml:576 1417#, no-c-format 1418msgid "Changed: 2.2.0 In prior versions this was called ST_Distance_Spheroid" 1419msgstr "" 1420 1421#. Tag: programlisting 1422#: reference_measure.xml:583 1423#, no-c-format 1424msgid "" 1425"SELECT round(CAST(\n" 1426" ST_DistanceSpheroid(ST_Centroid(geom), " 1427"ST_GeomFromText('POINT(-118 38)',4326), 'SPHEROID[\"WGS " 1428"84\",6378137,298.257223563]')\n" 1429" As numeric),2) As dist_meters_spheroid,\n" 1430" round(CAST(ST_DistanceSphere(ST_Centroid(geom), " 1431"ST_GeomFromText('POINT(-118 38)',4326)) As numeric),2) As " 1432"dist_meters_sphere,\n" 1433"round(CAST(ST_Distance(ST_Transform(ST_Centroid(geom),32611),\n" 1434" ST_Transform(ST_GeomFromText('POINT(-118 38)', 4326),32611)) " 1435"As numeric),2) As dist_utm11_meters\n" 1436"FROM\n" 1437" (SELECT ST_GeomFromText('LINESTRING(-118.584 38.374,-118.583 38.5)', " 1438"4326) As geom) as foo;\n" 1439" dist_meters_spheroid | dist_meters_sphere | dist_utm11_meters\n" 1440"----------------------+--------------------+-------------------\n" 1441" 70454.92 | 70424.47 | 70438.00" 1442msgstr "" 1443 1444#. Tag: para 1445#: reference_measure.xml:590 1446#, no-c-format 1447msgid ", <xref linkend=\"ST_DistanceSphere\"/>" 1448msgstr "" 1449 1450#. Tag: refname 1451#: reference_measure.xml:597 1452#, fuzzy, no-c-format 1453msgid "ST_FrechetDistance" 1454msgstr "ST_Distance" 1455 1456#. Tag: refpurpose 1457#: reference_measure.xml:599 1458#, no-c-format 1459msgid "Returns the Fréchet distance between two geometries." 1460msgstr "" 1461 1462#. Tag: funcprototype 1463#: reference_measure.xml:604 1464#, fuzzy, no-c-format 1465msgid "" 1466"<funcdef>float <function>ST_FrechetDistance</function></funcdef> " 1467"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 1468"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> " 1469"<paramdef><type>float</type> <parameter>densifyFrac = -1</parameter></" 1470"paramdef>" 1471msgstr "" 1472"<funcdef>boolean <function>ST_DFullyWithin</function></funcdef> " 1473"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 1474"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> " 1475"<paramdef><type>double precision </type> <parameter>distance</parameter></" 1476"paramdef>" 1477 1478#. Tag: para 1479#: reference_measure.xml:622 1480#, no-c-format 1481msgid "" 1482"Implements algorithm for computing the Fréchet distance restricted to " 1483"discrete points for both geometries, based on <ulink url=\"http://www.kr." 1484"tuwien.ac.at/staff/eiter/et-archive/cdtr9464.pdf\">Computing Discrete " 1485"Fréchet Distance</ulink>. The Fréchet distance is a measure of similarity " 1486"between curves that takes into account the location and ordering of the " 1487"points along the curves. Therefore it is often better than the Hausdorff " 1488"distance." 1489msgstr "" 1490 1491#. Tag: para 1492#: reference_measure.xml:624 1493#, no-c-format 1494msgid "" 1495"When the optional densifyFrac is specified, this function performs a segment " 1496"densification before computing the discrete Fréchet distance. The " 1497"densifyFrac parameter sets the fraction by which to densify each segment. " 1498"Each segment will be split into a number of equal-length subsegments, whose " 1499"fraction of the total length is closest to the given fraction." 1500msgstr "" 1501 1502#. Tag: para 1503#: reference_measure.xml:627 reference_measure.xml:702 1504#, no-c-format 1505msgid "" 1506"Units are in the units of the spatial reference system of the geometries." 1507msgstr "" 1508 1509#. Tag: para 1510#: reference_measure.xml:631 reference_measure.xml:706 1511#, no-c-format 1512msgid "" 1513"The current implementation supports only vertices as the discrete locations. " 1514"This could be extended to allow an arbitrary density of points to be used." 1515msgstr "" 1516 1517#. Tag: para 1518#: reference_measure.xml:636 1519#, no-c-format 1520msgid "" 1521"The smaller densifyFrac we specify, the more acurate Fréchet distance we " 1522"get. But, the computation time and the memory usage increase with the square " 1523"of the number of subsegments." 1524msgstr "" 1525 1526#. Tag: para 1527#: reference_measure.xml:640 reference_measure.xml:1289 1528#, fuzzy, no-c-format 1529msgid "Performed by the GEOS module." 1530msgstr "Eseguito dal modulo GEOS" 1531 1532#. Tag: para 1533#: reference_measure.xml:641 1534#, fuzzy, no-c-format 1535msgid "Availability: 2.4.0 - requires GEOS >= 3.7.0" 1536msgstr "Disponibilità: 2.0" 1537 1538#. Tag: programlisting 1539#: reference_measure.xml:647 1540#, fuzzy, no-c-format 1541msgid "" 1542"postgres=# SELECT st_frechetdistance('LINESTRING (0 0, 100 0)'::geometry, " 1543"'LINESTRING (0 0, 50 50, 100 0)'::geometry);\n" 1544" st_frechetdistance\n" 1545"--------------------\n" 1546" 70.7106781186548\n" 1547"(1 row)" 1548msgstr "" 1549"postgis=# SELECT st_hausdorffdistance('LINESTRING (130 0, 0 0, 0 150)'::" 1550"geometry, 'LINESTRING (10 10, 10 150, 130 10)'::geometry, 0.5);\n" 1551" st_hausdorffdistance\n" 1552" ----------------------\n" 1553" 70\n" 1554"(1 row)" 1555 1556#. Tag: programlisting 1557#: reference_measure.xml:648 1558#, fuzzy, no-c-format 1559msgid "" 1560"SELECT st_frechetdistance('LINESTRING (0 0, 100 0)'::geometry, 'LINESTRING " 1561"(0 0, 50 50, 100 0)'::geometry, 0.5);\n" 1562" st_frechetdistance\n" 1563"--------------------\n" 1564" 50\n" 1565"(1 row)" 1566msgstr "" 1567"postgis=# SELECT st_hausdorffdistance('LINESTRING (130 0, 0 0, 0 150)'::" 1568"geometry, 'LINESTRING (10 10, 10 150, 130 10)'::geometry, 0.5);\n" 1569" st_hausdorffdistance\n" 1570" ----------------------\n" 1571" 70\n" 1572"(1 row)" 1573 1574#. Tag: refname 1575#: reference_measure.xml:660 1576#, no-c-format 1577msgid "ST_HausdorffDistance" 1578msgstr "ST_HausdorffDistance" 1579 1580#. Tag: refpurpose 1581#: reference_measure.xml:662 1582#, no-c-format 1583msgid "Returns the Hausdorff distance between two geometries." 1584msgstr "" 1585 1586#. Tag: funcsynopsis 1587#: reference_measure.xml:666 1588#, no-c-format 1589msgid "" 1590"<funcprototype> <funcdef>float <function>ST_HausdorffDistance</function></" 1591"funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></" 1592"paramdef> <paramdef><type>geometry </type> <parameter>g2</parameter></" 1593"paramdef> </funcprototype> <funcprototype> <funcdef>float " 1594"<function>ST_HausdorffDistance</function></funcdef> <paramdef><type>geometry " 1595"</type> <parameter>g1</parameter></paramdef> <paramdef><type>geometry </" 1596"type> <parameter>g2</parameter></paramdef> <paramdef><type>float</type> " 1597"<parameter>densifyFrac</parameter></paramdef> </funcprototype>" 1598msgstr "" 1599"<funcprototype> <funcdef>float <function>ST_HausdorffDistance</function></" 1600"funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></" 1601"paramdef> <paramdef><type>geometry </type> <parameter>g2</parameter></" 1602"paramdef> </funcprototype> <funcprototype> <funcdef>float " 1603"<function>ST_HausdorffDistance</function></funcdef> <paramdef><type>geometry " 1604"</type> <parameter>g1</parameter></paramdef> <paramdef><type>geometry </" 1605"type> <parameter>g2</parameter></paramdef> <paramdef><type>float</type> " 1606"<parameter>densifyFrac</parameter></paramdef> </funcprototype>" 1607 1608#. Tag: para 1609#: reference_measure.xml:694 1610#, no-c-format 1611msgid "" 1612"Returns the Hausdorff distance between two geometries, a measure of how " 1613"similar or dissimilar 2 geometries are." 1614msgstr "" 1615 1616#. Tag: para 1617#: reference_measure.xml:696 1618#, no-c-format 1619msgid "" 1620"Implements algorithm for computing a distance metric which can be thought of " 1621"as the \"Discrete Hausdorff Distance\". This is the Hausdorff distance " 1622"restricted to discrete points for one of the geometries. <ulink url=\"http://" 1623"en.wikipedia.org/wiki/Hausdorff_distance\">Wikipedia article on Hausdorff " 1624"distance</ulink> <ulink url=\"http://lin-ear-th-inking.blogspot.com/2009/01/" 1625"computing-geometric-similarity.html\">Martin Davis note on how Hausdorff " 1626"Distance calculation was used to prove correctness of the " 1627"CascadePolygonUnion approach.</ulink>" 1628msgstr "" 1629 1630#. Tag: para 1631#: reference_measure.xml:699 1632#, no-c-format 1633msgid "" 1634"When densifyFrac is specified, this function performs a segment " 1635"densification before computing the discrete hausdorff distance. The " 1636"densifyFrac parameter sets the fraction by which to densify each segment. " 1637"Each segment will be split into a number of equal-length subsegments, whose " 1638"fraction of the total length is closest to the given fraction." 1639msgstr "" 1640 1641#. Tag: para 1642#: reference_measure.xml:711 1643#, no-c-format 1644msgid "" 1645"This algorithm is NOT equivalent to the standard Hausdorff distance. " 1646"However, it computes an approximation that is correct for a large subset of " 1647"useful cases. One important part of this subset is Linestrings that are " 1648"roughly parallel to each other, and roughly equal in length. This is a " 1649"useful metric for line matching." 1650msgstr "" 1651 1652#. Tag: para 1653#: reference_measure.xml:722 1654#, no-c-format 1655msgid "" 1656"For each building, find the parcel that best represents it. First we require " 1657"the parcel intersect with the geometry. DISTINCT ON guarantees we get each " 1658"building listed only once, the ORDER BY .. ST_HausdorffDistance gives us a " 1659"preference of parcel that is most similar to the building." 1660msgstr "" 1661 1662#. Tag: programlisting 1663#: reference_measure.xml:724 1664#, no-c-format 1665msgid "" 1666"SELECT DISTINCT ON(buildings.gid) buildings.gid, parcels.parcel_id\n" 1667" FROM buildings INNER JOIN parcels ON ST_Intersects(buildings.geom,parcels." 1668"geom)\n" 1669" ORDER BY buildings.gid, ST_HausdorffDistance(buildings.geom, parcels." 1670"geom);" 1671msgstr "" 1672 1673#. Tag: programlisting 1674#: reference_measure.xml:726 1675#, no-c-format 1676msgid "" 1677"postgis=# SELECT ST_HausdorffDistance(\n" 1678" 'LINESTRING (0 0, 2 0)'::geometry,\n" 1679" 'MULTIPOINT (0 1, 1 0, 2 1)'::geometry);\n" 1680" st_hausdorffdistance\n" 1681" ----------------------\n" 1682" 1\n" 1683"(1 row)" 1684msgstr "" 1685 1686#. Tag: programlisting 1687#: reference_measure.xml:727 1688#, no-c-format 1689msgid "" 1690"postgis=# SELECT st_hausdorffdistance('LINESTRING (130 0, 0 0, 0 150)'::" 1691"geometry, 'LINESTRING (10 10, 10 150, 130 10)'::geometry, 0.5);\n" 1692" st_hausdorffdistance\n" 1693" ----------------------\n" 1694" 70\n" 1695"(1 row)" 1696msgstr "" 1697"postgis=# SELECT st_hausdorffdistance('LINESTRING (130 0, 0 0, 0 150)'::" 1698"geometry, 'LINESTRING (10 10, 10 150, 130 10)'::geometry, 0.5);\n" 1699" st_hausdorffdistance\n" 1700" ----------------------\n" 1701" 70\n" 1702"(1 row)" 1703 1704#. Tag: refname 1705#: reference_measure.xml:739 1706#, no-c-format 1707msgid "ST_Length" 1708msgstr "ST_Length" 1709 1710#. Tag: refpurpose 1711#: reference_measure.xml:741 1712#, no-c-format 1713msgid "Returns the 2D length of a linear geometry." 1714msgstr "" 1715 1716#. Tag: funcsynopsis 1717#: reference_measure.xml:744 1718#, no-c-format 1719msgid "" 1720"<funcprototype> <funcdef>float <function>ST_Length</function></funcdef> " 1721"<paramdef><type>geometry </type><parameter>a_2dlinestring</parameter></" 1722"paramdef> </funcprototype> <funcprototype> <funcdef>float " 1723"<function>ST_Length</function></funcdef> <paramdef><type>geography </" 1724"type><parameter>geog</parameter></paramdef> <paramdef choice=\"opt" 1725"\"><type>boolean </type><parameter>use_spheroid=true</parameter></paramdef> " 1726"</funcprototype>" 1727msgstr "" 1728"<funcprototype> <funcdef>float <function>ST_Length</function></funcdef> " 1729"<paramdef><type>geometry </type><parameter>a_2dlinestring</parameter></" 1730"paramdef> </funcprototype> <funcprototype> <funcdef>float " 1731"<function>ST_Length</function></funcdef> <paramdef><type>geography </" 1732"type><parameter>geog</parameter></paramdef> <paramdef choice=\"opt" 1733"\"><type>boolean </type><parameter>use_spheroid=true</parameter></paramdef> " 1734"</funcprototype>" 1735 1736#. Tag: para 1737#: reference_measure.xml:759 1738#, no-c-format 1739msgid "" 1740"For geometry types: returns the 2D Cartesian length of the geometry if it is " 1741"a LineString, MultiLineString, ST_Curve, ST_MultiCurve. For areal geometries " 1742"0 is returned; use <xref linkend=\"ST_Perimeter\"/> instead. The units of " 1743"length is determined by the spatial reference system of the geometry." 1744msgstr "" 1745 1746#. Tag: para 1747#: reference_measure.xml:763 1748#, no-c-format 1749msgid "" 1750"For geography types: computation is performed using the inverse geodesic " 1751"calculation. Units of length are in meters. If PostGIS is compiled with PROJ " 1752"version 4.8.0 or later, the spheroid is specified by the SRID, otherwise it " 1753"is exclusive to WGS84. If <varname>use_spheroid=false</varname>, then the " 1754"calculation is based on a sphere instead of a spheroid." 1755msgstr "" 1756 1757#. Tag: para 1758#: reference_measure.xml:768 1759#, no-c-format 1760msgid "" 1761"Currently for geometry this is an alias for ST_Length2D, but this may change " 1762"to support higher dimensions." 1763msgstr "" 1764 1765#. Tag: para 1766#: reference_measure.xml:770 1767#, no-c-format 1768msgid "" 1769"Changed: 2.0.0 Breaking change -- in prior versions applying this to a MULTI/" 1770"POLYGON of type geography would give you the perimeter of the POLYGON/" 1771"MULTIPOLYGON. In 2.0.0 this was changed to return 0 to be in line with " 1772"geometry behavior. Please use ST_Perimeter if you want the perimeter of a " 1773"polygon" 1774msgstr "" 1775 1776#. Tag: para 1777#: reference_measure.xml:773 1778#, no-c-format 1779msgid "" 1780"For geography the calculation defaults to using a spheroidal model. To use " 1781"the faster but less accurate spherical calculation use ST_Length(gg,false);" 1782msgstr "" 1783 1784#. Tag: para 1785#: reference_measure.xml:774 reference_measure.xml:1341 1786#, no-c-format 1787msgid "&sfs_compliant; s2.1.5.1" 1788msgstr "&sfs_compliant; s2.1.5.1" 1789 1790#. Tag: para 1791#: reference_measure.xml:775 1792#, no-c-format 1793msgid "&sqlmm_compliant; SQL-MM 3: 7.1.2, 9.3.4" 1794msgstr "&sqlmm_compliant; SQL-MM 3: 7.1.2, 9.3.4" 1795 1796#. Tag: para 1797#: reference_measure.xml:776 1798#, no-c-format 1799msgid "Availability: 1.5.0 geography support was introduced in 1.5." 1800msgstr "" 1801 1802#. Tag: para 1803#: reference_measure.xml:777 1804#, no-c-format 1805msgid "&sfcgal_enhanced;" 1806msgstr "" 1807 1808#. Tag: title 1809#: reference_measure.xml:781 1810#, no-c-format 1811msgid "Geometry Examples" 1812msgstr "" 1813 1814#. Tag: para 1815#: reference_measure.xml:782 1816#, no-c-format 1817msgid "" 1818"Return length in feet for line string. Note this is in feet because " 1819"EPSG:2249 is Massachusetts State Plane Feet" 1820msgstr "" 1821 1822#. Tag: programlisting 1823#: reference_measure.xml:784 1824#, no-c-format 1825msgid "" 1826"SELECT ST_Length(ST_GeomFromText('LINESTRING(743238 2967416,743238 " 1827"2967450,743265 2967450,\n" 1828"743265.625 2967416,743238 2967416)',2249));\n" 1829"\n" 1830"st_length\n" 1831"---------\n" 1832" 122.630744000095\n" 1833"\n" 1834"\n" 1835"--Transforming WGS 84 LineString to Massachusetts state plane meters\n" 1836"SELECT ST_Length(\n" 1837" ST_Transform(\n" 1838" ST_GeomFromEWKT('SRID=4326;LINESTRING(-72.1260 42.45, " 1839"-72.1240 42.45666, -72.123 42.1546)'),\n" 1840" 26986\n" 1841" )\n" 1842");\n" 1843"\n" 1844"st_length\n" 1845"---------\n" 1846"34309.4563576191" 1847msgstr "" 1848 1849#. Tag: para 1850#: reference_measure.xml:788 1851#, no-c-format 1852msgid "Return length of WGS 84 geography line" 1853msgstr "" 1854 1855#. Tag: programlisting 1856#: reference_measure.xml:789 1857#, no-c-format 1858msgid "" 1859"-- the default calculation uses a spheroid\n" 1860"SELECT ST_Length(the_geog) As length_spheroid, ST_Length(the_geog,false) As " 1861"length_sphere\n" 1862"FROM (SELECT ST_GeographyFromText(\n" 1863"'SRID=4326;LINESTRING(-72.1260 42.45, -72.1240 42.45666, -72.123 42.1546)') " 1864"As the_geog)\n" 1865" As foo;\n" 1866"\n" 1867" length_spheroid | length_sphere\n" 1868"------------------+------------------\n" 1869" 34310.5703627288 | 34346.2060960742" 1870msgstr "" 1871 1872#. Tag: para 1873#: reference_measure.xml:793 1874#, no-c-format 1875msgid "" 1876", <xref linkend=\"ST_GeomFromEWKT\"/>, <xref linkend=\"ST_Length_Spheroid\"/" 1877">, <xref linkend=\"ST_Perimeter\"/>, <xref linkend=\"ST_Transform\"/>" 1878msgstr "" 1879", <xref linkend=\"ST_GeomFromEWKT\"/>, <xref linkend=\"ST_Length_Spheroid\"/" 1880">, <xref linkend=\"ST_Perimeter\"/>, <xref linkend=\"ST_Transform\"/>" 1881 1882#. Tag: refname 1883#: reference_measure.xml:799 1884#, no-c-format 1885msgid "ST_Length2D" 1886msgstr "ST_Length2D" 1887 1888#. Tag: refpurpose 1889#: reference_measure.xml:801 1890#, no-c-format 1891msgid "" 1892"Returns the 2D length of a linear geometry. Alias for <varname>ST_Length</" 1893"varname>" 1894msgstr "" 1895 1896#. Tag: funcprototype 1897#: reference_measure.xml:806 1898#, no-c-format 1899msgid "" 1900"<funcdef>float <function>ST_Length2D</function></funcdef> " 1901"<paramdef><type>geometry </type> <parameter>a_2dlinestring</parameter></" 1902"paramdef>" 1903msgstr "" 1904"<funcdef>float <function>ST_Length2D</function></funcdef> " 1905"<paramdef><type>geometry </type> <parameter>a_2dlinestring</parameter></" 1906"paramdef>" 1907 1908#. Tag: para 1909#: reference_measure.xml:816 1910#, no-c-format 1911msgid "" 1912"Returns the 2D length of the geometry if it is a linestring or multi-" 1913"linestring. This is an alias for <varname>ST_Length</varname>" 1914msgstr "" 1915 1916#. Tag: para 1917#: reference_measure.xml:825 1918#, no-c-format 1919msgid ", <xref linkend=\"ST_3DLength\"/>" 1920msgstr ", <xref linkend=\"ST_3DLength\"/>" 1921 1922#. Tag: refname 1923#: reference_measure.xml:831 1924#, no-c-format 1925msgid "ST_3DLength" 1926msgstr "ST_3DLength" 1927 1928#. Tag: refpurpose 1929#: reference_measure.xml:833 1930#, no-c-format 1931msgid "Returns the 3D length of a linear geometry." 1932msgstr "" 1933 1934#. Tag: funcprototype 1935#: reference_measure.xml:838 1936#, no-c-format 1937msgid "" 1938"<funcdef>float <function>ST_3DLength</function></funcdef> " 1939"<paramdef><type>geometry </type> <parameter>a_3dlinestring</parameter></" 1940"paramdef>" 1941msgstr "" 1942"<funcdef>float <function>ST_3DLength</function></funcdef> " 1943"<paramdef><type>geometry </type> <parameter>a_3dlinestring</parameter></" 1944"paramdef>" 1945 1946#. Tag: para 1947#: reference_measure.xml:848 1948#, no-c-format 1949msgid "" 1950"Returns the 3-dimensional or 2-dimensional length of the geometry if it is a " 1951"LineString or MultiLineString. For 2-d lines it will just return the 2-d " 1952"length (same as ST_Length and ST_Length2D)" 1953msgstr "" 1954 1955#. Tag: para 1956#: reference_measure.xml:851 1957#, no-c-format 1958msgid "Changed: 2.0.0 In prior versions this used to be called ST_Length3D" 1959msgstr "" 1960 1961#. Tag: para 1962#: reference_measure.xml:858 1963#, no-c-format 1964msgid "" 1965"Return length in feet for a 3D cable. Note this is in feet because EPSG:2249 " 1966"is Massachusetts State Plane Feet" 1967msgstr "" 1968 1969#. Tag: programlisting 1970#: reference_measure.xml:860 1971#, no-c-format 1972msgid "" 1973"SELECT ST_3DLength(ST_GeomFromText('LINESTRING(743238 2967416 1,743238 " 1974"2967450 1,743265 2967450 3,\n" 1975"743265.625 2967416 3,743238 2967416 3)',2249));\n" 1976"ST_3DLength\n" 1977"-----------\n" 1978"122.704716741457" 1979msgstr "" 1980"SELECT ST_3DLength(ST_GeomFromText('LINESTRING(743238 2967416 1,743238 " 1981"2967450 1,743265 2967450 3,\n" 1982"743265.625 2967416 3,743238 2967416 3)',2249));\n" 1983"ST_3DLength\n" 1984"-----------\n" 1985"122.704716741457" 1986 1987#. Tag: para 1988#: reference_measure.xml:867 1989#, no-c-format 1990msgid ", <xref linkend=\"ST_Length2D\"/>" 1991msgstr ", <xref linkend=\"ST_Length2D\"/>" 1992 1993#. Tag: refname 1994#: reference_measure.xml:873 1995#, no-c-format 1996msgid "ST_LengthSpheroid" 1997msgstr "" 1998 1999#. Tag: refpurpose 2000#: reference_measure.xml:875 2001#, no-c-format 2002msgid "" 2003"Returns the 2D or 3D length/perimeter of a lon/lat geometry on a spheroid." 2004msgstr "" 2005 2006#. Tag: funcprototype 2007#: reference_measure.xml:880 2008#, fuzzy, no-c-format 2009msgid "" 2010"<funcdef>float <function>ST_LengthSpheroid</function></funcdef> " 2011"<paramdef><type>geometry </type> <parameter>a_geometry</parameter></" 2012"paramdef> <paramdef><type>spheroid </type> <parameter>a_spheroid</" 2013"parameter></paramdef>" 2014msgstr "" 2015"<funcdef>boolean <function>ST_Contains</function></funcdef> " 2016"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 2017"<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef>" 2018 2019#. Tag: para 2020#: reference_measure.xml:891 2021#, no-c-format 2022msgid "" 2023"Calculates the length or perimeter of a geometry on an ellipsoid. This is " 2024"useful if the coordinates of the geometry are in longitude/latitude and a " 2025"length is desired without reprojection. The spheroid is specified by a text " 2026"value as follows:" 2027msgstr "" 2028 2029#. Tag: literallayout 2030#: reference_measure.xml:896 2031#, fuzzy, no-c-format 2032msgid "" 2033"SPHEROID[<NAME>,<SEMI-MAJOR AXIS>,<INVERSE FLATTENING>]" 2034msgstr "" 2035"SPHEROID[<NAME>,<SEMI-MAJOR\n" 2036" AXIS>,<INVERSE FLATTENING>]" 2037 2038#. Tag: para 2039#: reference_measure.xml:897 2040#, fuzzy, no-c-format 2041msgid "For example:" 2042msgstr "Esempi" 2043 2044#. Tag: literallayout 2045#: reference_measure.xml:898 2046#, no-c-format 2047msgid "SPHEROID[\"GRS_1980\",6378137,298.257222101]" 2048msgstr "" 2049 2050#. Tag: para 2051#: reference_measure.xml:900 2052#, no-c-format 2053msgid "Availability: 1.2.2" 2054msgstr "" 2055 2056#. Tag: para 2057#: reference_measure.xml:901 2058#, no-c-format 2059msgid "" 2060"Changed: 2.2.0 In prior versions this was called ST_Length_Spheroid and had " 2061"the alias ST_3DLength_Spheroid" 2062msgstr "" 2063 2064#. Tag: programlisting 2065#: reference_measure.xml:908 2066#, fuzzy, no-c-format 2067msgid "" 2068"SELECT ST_LengthSpheroid( geometry_column,\n" 2069" 'SPHEROID[\"GRS_1980\",6378137,298.257222101]' )\n" 2070" FROM geometry_table;\n" 2071"\n" 2072"SELECT ST_LengthSpheroid( geom, sph_m ) As tot_len,\n" 2073"ST_LengthSpheroid(ST_GeometryN(geom,1), sph_m) As len_line1,\n" 2074"ST_LengthSpheroid(ST_GeometryN(geom,2), sph_m) As len_line2\n" 2075" FROM (SELECT " 2076"ST_GeomFromText('MULTILINESTRING((-118.584 38.374,-118.583 38.5),\n" 2077" (-71.05957 42.3589 , -71.061 43))') As geom,\n" 2078"CAST('SPHEROID[\"GRS_1980\",6378137,298.257222101]' As spheroid) As sph_m) " 2079"as foo;\n" 2080" tot_len | len_line1 | len_line2\n" 2081"------------------+------------------+------------------\n" 2082" 85204.5207562955 | 13986.8725229309 | 71217.6482333646\n" 2083"\n" 2084" --3D\n" 2085"SELECT ST_LengthSpheroid( geom, sph_m ) As tot_len,\n" 2086"ST_LengthSpheroid(ST_GeometryN(geom,1), sph_m) As len_line1,\n" 2087"ST_LengthSpheroid(ST_GeometryN(geom,2), sph_m) As len_line2\n" 2088" FROM (SELECT " 2089"ST_GeomFromEWKT('MULTILINESTRING((-118.584 38.374 20,-118.583 38.5 30),\n" 2090" (-71.05957 42.3589 75, -71.061 43 90))') As geom,\n" 2091"CAST('SPHEROID[\"GRS_1980\",6378137,298.257222101]' As spheroid) As sph_m) " 2092"as foo;\n" 2093"\n" 2094" tot_len | len_line1 | len_line2\n" 2095"------------------+-----------------+------------------\n" 2096" 85204.5259107402 | 13986.876097711 | 71217.6498130292" 2097msgstr "" 2098"SELECT ST_Length2D_Spheroid( geometry_column,\n" 2099" 'SPHEROID[\"GRS_1980\",6378137,298.257222101]' )\n" 2100" FROM geometry_table;\n" 2101"\n" 2102"SELECT ST_Length2D_Spheroid( the_geom, sph_m ) As tot_len,\n" 2103"ST_Length2D_Spheroid(ST_GeometryN(the_geom,1), sph_m) As len_line1,\n" 2104"ST_Length2D_Spheroid(ST_GeometryN(the_geom,2), sph_m) As len_line2\n" 2105" FROM (SELECT " 2106"ST_GeomFromText('MULTILINESTRING((-118.584 38.374,-118.583 38.5),\n" 2107" (-71.05957 42.3589 , -71.061 43))') As the_geom,\n" 2108"CAST('SPHEROID[\"GRS_1980\",6378137,298.257222101]' As spheroid) As sph_m) " 2109"as foo;\n" 2110" tot_len | len_line1 | len_line2\n" 2111"------------------+------------------+------------------\n" 2112" 85204.5207562955 | 13986.8725229309 | 71217.6482333646\n" 2113"\n" 2114" --3D Observe same answer\n" 2115"SELECT ST_Length2D_Spheroid( the_geom, sph_m ) As tot_len,\n" 2116"ST_Length2D_Spheroid(ST_GeometryN(the_geom,1), sph_m) As len_line1,\n" 2117"ST_Length2D_Spheroid(ST_GeometryN(the_geom,2), sph_m) As len_line2\n" 2118" FROM (SELECT " 2119"ST_GeomFromEWKT('MULTILINESTRING((-118.584 38.374 20,-118.583 38.5 30),\n" 2120" (-71.05957 42.3589 75, -71.061 43 90))') As the_geom,\n" 2121"CAST('SPHEROID[\"GRS_1980\",6378137,298.257222101]' As spheroid) As sph_m) " 2122"as foo;\n" 2123"\n" 2124" tot_len | len_line1 | len_line2\n" 2125"------------------+------------------+------------------\n" 2126" 85204.5207562955 | 13986.8725229309 | 71217.6482333646" 2127 2128#. Tag: para 2129#: reference_measure.xml:915 2130#, no-c-format 2131msgid ", <xref linkend=\"ST_Length\"/>" 2132msgstr "" 2133 2134#. Tag: refname 2135#: reference_measure.xml:922 2136#, no-c-format 2137msgid "ST_LongestLine" 2138msgstr "ST_LongestLine" 2139 2140#. Tag: refpurpose 2141#: reference_measure.xml:924 2142#, no-c-format 2143msgid "Returns the 2D longest line between two geometries." 2144msgstr "" 2145 2146#. Tag: funcprototype 2147#: reference_measure.xml:930 2148#, no-c-format 2149msgid "" 2150"<funcdef>geometry <function>ST_LongestLine</function></funcdef> " 2151"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 2152"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 2153msgstr "" 2154"<funcdef>geometry <function>ST_LongestLine</function></funcdef> " 2155"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 2156"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 2157 2158#. Tag: para 2159#: reference_measure.xml:945 2160#, no-c-format 2161msgid "" 2162"Returns the 2-dimensional longest line between the points of two geometries." 2163msgstr "" 2164 2165#. Tag: para 2166#: reference_measure.xml:947 2167#, no-c-format 2168msgid "" 2169"The function returns the first longest line if more than one is found. The " 2170"line returned starts on g1 and ends on g2. The length of the line is equal " 2171"to the distance returned by <xref linkend=\"ST_MaxDistance\"/>." 2172msgstr "" 2173 2174#. Tag: para 2175#: reference_measure.xml:966 2176#, no-c-format 2177msgid "Longest line between a point and a line" 2178msgstr "" 2179 2180#. Tag: programlisting 2181#: reference_measure.xml:969 2182#, fuzzy, no-c-format 2183msgid "" 2184"SELECT ST_AsText(\n" 2185" ST_LongestLine('POINT(100 100)'::geometry,\n" 2186" 'LINESTRING (20 80, 98 190, 110 180, 50 75 )'::geometry)\n" 2187" ) As lline;\n" 2188"\n" 2189"\n" 2190" lline\n" 2191"-----------------\n" 2192"LINESTRING(100 100,98 190)" 2193msgstr "" 2194"SELECT ST_AsText(\n" 2195" ST_LongestLine('POINT(100 100)'::geometry, \n" 2196" 'LINESTRING (20 80, 98 190, 110 180, 50 75 )'::geometry)\n" 2197" ) As lline;\n" 2198"\n" 2199" \n" 2200" lline\n" 2201"-----------------\n" 2202"LINESTRING(100 100,98 190)" 2203 2204#. Tag: para 2205#: reference_measure.xml:978 2206#, no-c-format 2207msgid "Longest line between two polygons" 2208msgstr "" 2209 2210#. Tag: programlisting 2211#: reference_measure.xml:981 2212#, fuzzy, no-c-format 2213msgid "" 2214"SELECT ST_AsText(\n" 2215" ST_LongestLine(\n" 2216" ST_GeomFromText('POLYGON((175 150, 20 40,\n" 2217" 50 60, 125 100, 175 150))'),\n" 2218" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 2219" )\n" 2220" ) As llinewkt;\n" 2221"\n" 2222" lline\n" 2223"-----------------\n" 2224"LINESTRING(20 40,121.111404660392 186.629392246051)" 2225msgstr "" 2226"SELECT ST_AsText(\n" 2227" ST_LongestLine(\n" 2228" ST_GeomFromText('POLYGON((175 150, 20 40, \n" 2229" 50 60, 125 100, 175 150))'),\n" 2230" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 2231" ) \n" 2232" ) As llinewkt;\n" 2233" \n" 2234" lline\n" 2235"-----------------\n" 2236"LINESTRING(20 40,121.111404660392 186.629392246051)" 2237 2238#. Tag: para 2239#: reference_measure.xml:997 2240#, no-c-format 2241msgid "" 2242"Longest straight distance to travel from one part of a city to another. Note " 2243"that the maximum distance is equal to the length of the line." 2244msgstr "" 2245 2246#. Tag: programlisting 2247#: reference_measure.xml:1001 2248#, fuzzy, no-c-format 2249msgid "" 2250"SELECT ST_AsText( ST_LongestLine(c.geom, c.geom)) AS llinewkt,\n" 2251" ST_MaxDistance( c.geom,c.geom) AS max_dist,\n" 2252" ST_Length( ST_LongestLine(c.geom, c.geom)) AS lenll\n" 2253"FROM (SELECT ST_MakeValid( ST_Collect(geom)) AS geom\n" 2254" FROM (SELECT ST_Translate( ST_SnapToGrid(\n" 2255" ST_Buffer(\n" 2256" ST_Point(50 ,generate_series(50,190, 50)),\n" 2257" 40, 'quad_segs=2'),1), x, 0) AS geom\n" 2258" FROM generate_series(1,100,50) As x) AS foo\n" 2259" ) AS c;\n" 2260"\n" 2261" llinewkt | max_dist | lenll\n" 2262"---------------------------+------------------+------------------\n" 2263" LINESTRING(23 22,129 178) | 188.605408193933 | 188.605408193933" 2264msgstr "" 2265"SELECT ST_AsText(ST_LongestLine(c.the_geom, c.the_geom)) As llinewkt, \n" 2266" ST_MaxDistance(c.the_geom,c.the_geom) As max_dist, \n" 2267" ST_Length(ST_LongestLine(c.the_geom, c.the_geom)) As lenll \n" 2268"FROM (SELECT ST_BuildArea(ST_Collect(the_geom)) As the_geom\n" 2269" FROM (SELECT ST_Translate(ST_SnapToGrid(ST_Buffer(ST_Point(50 ," 2270"generate_series(50,190, 50) \n" 2271" ),40, 'quad_segs=2'),1), x, 0) As the_geom \n" 2272" FROM generate_series(1,100,50) As x) AS foo\n" 2273") As c;\n" 2274" \n" 2275" llinewkt | max_dist | lenll\n" 2276"---------------------------+------------------+------------------\n" 2277" LINESTRING(23 22,129 178) | 188.605408193933 | 188.605408193933" 2278 2279#. Tag: para 2280#: reference_measure.xml:1012 2281#, fuzzy, no-c-format 2282msgid "" 2283", <xref linkend=\"ST_MakeValid\"/>, <xref linkend=\"ST_ShortestLine\"/>, " 2284"<xref linkend=\"ST_3DLongestLine\"/>" 2285msgstr "" 2286", <xref linkend=\"ST_Distance\"/>, <xref linkend=\"ST_LongestLine\"/>, <xref " 2287"linkend=\"ST_MaxDistance\"/>" 2288 2289#. Tag: refname 2290#: reference_measure.xml:1018 2291#, no-c-format 2292msgid "ST_3DLongestLine" 2293msgstr "ST_3DLongestLine" 2294 2295#. Tag: refpurpose 2296#: reference_measure.xml:1020 2297#, no-c-format 2298msgid "Returns the 3D longest line between two geometries" 2299msgstr "" 2300 2301#. Tag: funcprototype 2302#: reference_measure.xml:1025 2303#, no-c-format 2304msgid "" 2305"<funcdef>geometry <function>ST_3DLongestLine</function></funcdef> " 2306"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 2307"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 2308msgstr "" 2309"<funcdef>geometry <function>ST_3DLongestLine</function></funcdef> " 2310"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 2311"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 2312 2313#. Tag: para 2314#: reference_measure.xml:1040 2315#, no-c-format 2316msgid "" 2317"Returns the 3-dimensional longest line between two geometries. The function " 2318"returns the first longest line if more than one. The line returned starts in " 2319"g1 and ends in g2. The 3D length of the line is equal to the distance " 2320"returned by <xref linkend=\"ST_3DMaxDistance\"/>." 2321msgstr "" 2322 2323#. Tag: para 2324#: reference_measure.xml:1059 2325#, no-c-format 2326msgid "linestring and point -- both 3d and 2d longest line" 2327msgstr "" 2328 2329#. Tag: programlisting 2330#: reference_measure.xml:1060 2331#, fuzzy, no-c-format 2332msgid "" 2333"SELECT ST_AsEWKT(ST_3DLongestLine(line,pt)) AS lol3d_line_pt,\n" 2334" ST_AsEWKT(ST_LongestLine(line,pt)) As lol2d_line_pt\n" 2335" FROM (SELECT 'POINT(100 100 30)'::geometry As pt,\n" 2336" 'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 " 2337"1000)'::geometry As line\n" 2338" ) As foo;\n" 2339"\n" 2340"\n" 2341" lol3d_line_pt | lol2d_line_pt\n" 2342"-----------------------------------+----------------------------\n" 2343" LINESTRING(50 75 1000,100 100 30) | LINESTRING(98 190,100 100)" 2344msgstr "" 2345"SELECT ST_AsEWKT(ST_3DLongestLine(line,pt)) AS lol3d_line_pt, \n" 2346" ST_AsEWKT(ST_LongestLine(line,pt)) As lol2d_line_pt\n" 2347" FROM (SELECT 'POINT(100 100 30)'::geometry As pt, \n" 2348" 'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 " 2349"1000)'::geometry As line\n" 2350" ) As foo;\n" 2351" \n" 2352" \n" 2353" lol3d_line_pt | lol2d_line_pt\n" 2354"-----------------------------------+----------------------------\n" 2355" LINESTRING(50 75 1000,100 100 30) | LINESTRING(98 190,100 100)" 2356 2357#. Tag: para 2358#: reference_measure.xml:1064 2359#, no-c-format 2360msgid "linestring and multipoint -- both 3d and 2d longest line" 2361msgstr "" 2362 2363#. Tag: programlisting 2364#: reference_measure.xml:1065 2365#, fuzzy, no-c-format 2366msgid "" 2367"SELECT ST_AsEWKT(ST_3DLongestLine(line,pt)) AS lol3d_line_pt,\n" 2368" ST_AsEWKT(ST_LongestLine(line,pt)) As lol2d_line_pt\n" 2369" FROM (SELECT 'MULTIPOINT(100 100 30, 50 74 1000)'::geometry As pt,\n" 2370" 'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 " 2371"900)'::geometry As line\n" 2372" ) As foo;\n" 2373"\n" 2374"\n" 2375" lol3d_line_pt | lol2d_line_pt\n" 2376"---------------------------------+--------------------------\n" 2377" LINESTRING(98 190 1,50 74 1000) | LINESTRING(98 190,50 74)" 2378msgstr "" 2379"SELECT ST_AsEWKT(ST_3DLongestLine(line,pt)) AS lol3d_line_pt, \n" 2380" ST_AsEWKT(ST_LongestLine(line,pt)) As lol2d_line_pt\n" 2381" FROM (SELECT 'MULTIPOINT(100 100 30, 50 74 1000)'::geometry As pt, \n" 2382" 'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 " 2383"900)'::geometry As line\n" 2384" ) As foo;\n" 2385" \n" 2386" \n" 2387" lol3d_line_pt | lol2d_line_pt\n" 2388"---------------------------------+--------------------------\n" 2389" LINESTRING(98 190 1,50 74 1000) | LINESTRING(98 190,50 74)" 2390 2391#. Tag: para 2392#: reference_measure.xml:1069 2393#, no-c-format 2394msgid "MultiLineString and Polygon both 3d and 2d longest line" 2395msgstr "" 2396 2397#. Tag: programlisting 2398#: reference_measure.xml:1070 2399#, fuzzy, no-c-format 2400msgid "" 2401"SELECT ST_AsEWKT(ST_3DLongestLine(poly, mline)) As lol3d,\n" 2402" ST_AsEWKT(ST_LongestLine(poly, mline)) As lol2d\n" 2403" FROM (SELECT ST_GeomFromEWKT('POLYGON((175 150 5, 20 40 5, 35 45 5, " 2404"50 60 5, 100 100 5, 175 150 5))') As poly,\n" 2405" ST_GeomFromEWKT('MULTILINESTRING((175 155 2, 20 40 20, 50 60 " 2406"-2, 125 100 1, 175 155 1),\n" 2407" (1 10 2, 5 20 1))') As mline ) As foo;\n" 2408" lol3d | lol2d\n" 2409"------------------------------+--------------------------\n" 2410" LINESTRING(175 150 5,1 10 2) | LINESTRING(175 150,1 10)" 2411msgstr "" 2412"SELECT ST_AsEWKT(ST_3DLongestLine(poly, mline)) As lol3d,\n" 2413" ST_AsEWKT(ST_LongestLine(poly, mline)) As lol2d \n" 2414" FROM (SELECT ST_GeomFromEWKT('POLYGON((175 150 5, 20 40 5, 35 45 5, " 2415"50 60 5, 100 100 5, 175 150 5))') As poly,\n" 2416" ST_GeomFromEWKT('MULTILINESTRING((175 155 2, 20 40 20, 50 60 " 2417"-2, 125 100 1, 175 155 1),\n" 2418" (1 10 2, 5 20 1))') As mline ) As foo;\n" 2419" lol3d | lol2d\n" 2420"------------------------------+--------------------------\n" 2421" LINESTRING(175 150 5,1 10 2) | LINESTRING(175 150,1 10)" 2422 2423#. Tag: para 2424#: reference_measure.xml:1082 2425#, no-c-format 2426msgid "" 2427", <xref linkend=\"ST_3DDistance\"/>, <xref linkend=\"ST_LongestLine\"/>, " 2428"<xref linkend=\"ST_3DShortestLine\"/>, <xref linkend=\"ST_3DMaxDistance\"/>" 2429msgstr "" 2430", <xref linkend=\"ST_3DDistance\"/>, <xref linkend=\"ST_LongestLine\"/>, " 2431"<xref linkend=\"ST_3DShortestLine\"/>, <xref linkend=\"ST_3DMaxDistance\"/>" 2432 2433#. Tag: refname 2434#: reference_measure.xml:1088 2435#, no-c-format 2436msgid "ST_MaxDistance" 2437msgstr "ST_MaxDistance" 2438 2439#. Tag: refpurpose 2440#: reference_measure.xml:1090 2441#, no-c-format 2442msgid "" 2443"Returns the 2D largest distance between two geometries in projected units." 2444msgstr "" 2445 2446#. Tag: funcprototype 2447#: reference_measure.xml:1096 2448#, no-c-format 2449msgid "" 2450"<funcdef>float <function>ST_MaxDistance</function></funcdef> " 2451"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 2452"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 2453msgstr "" 2454"<funcdef>float <function>ST_MaxDistance</function></funcdef> " 2455"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 2456"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 2457 2458#. Tag: para 2459#: reference_measure.xml:1108 2460#, no-c-format 2461msgid "" 2462"Returns the 2-dimensional maximum distance between two geometries, in " 2463"projected units. The maximum distance always occurs between two vertices. " 2464"This is the length of the line returned by <xref linkend=\"ST_LongestLine\"/" 2465">." 2466msgstr "" 2467 2468#. Tag: para 2469#: reference_measure.xml:1112 2470#, no-c-format 2471msgid "" 2472"If g1 and g2 are the same geometry, returns the distance between the two " 2473"vertices farthest apart in that geometry." 2474msgstr "" 2475 2476#. Tag: para 2477#: reference_measure.xml:1121 2478#, no-c-format 2479msgid "Maximum distance between a point and lines." 2480msgstr "" 2481 2482#. Tag: programlisting 2483#: reference_measure.xml:1122 2484#, fuzzy, no-c-format 2485msgid "" 2486"postgis=# SELECT ST_MaxDistance('POINT(0 0)'::geometry, 'LINESTRING ( 2 0, 0 " 2487"2 )'::geometry);\n" 2488" st_maxdistance\n" 2489"-----------------\n" 2490" 2\n" 2491"\n" 2492"postgis=# SELECT ST_MaxDistance('POINT(0 0)'::geometry, 'LINESTRING ( 2 2, 2 " 2493"2 )'::geometry);\n" 2494" st_maxdistance\n" 2495"------------------\n" 2496" 2.82842712474619" 2497msgstr "" 2498"postgis=# SELECT ST_MaxDistance('POINT(0 0)'::geometry, 'LINESTRING ( 2 0, 0 " 2499"2 )'::geometry);\n" 2500" st_maxdistance\n" 2501"-----------------\n" 2502" 2\n" 2503"(1 row)\n" 2504"\n" 2505"postgis=# SELECT ST_MaxDistance('POINT(0 0)'::geometry, 'LINESTRING ( 2 2, 2 " 2506"2 )'::geometry);\n" 2507" st_maxdistance \n" 2508"------------------\n" 2509" 2.82842712474619\n" 2510"(1 row)" 2511 2512#. Tag: para 2513#: reference_measure.xml:1124 2514#, no-c-format 2515msgid "Maximum distance between vertices of a geometry." 2516msgstr "" 2517 2518#. Tag: programlisting 2519#: reference_measure.xml:1125 2520#, fuzzy, no-c-format 2521msgid "" 2522"SELECT ST_MaxDistance('POLYGON ((10 10, 10 0, 0 0, 10 10))'::geometry,\n" 2523" 'POLYGON ((10 10, 10 0, 0 0, 10 10))'::geometry);\n" 2524" st_maxdistance\n" 2525"------------------\n" 2526" 14.142135623730951" 2527msgstr "" 2528"postgis=# SELECT st_hausdorffdistance('LINESTRING (130 0, 0 0, 0 150)'::" 2529"geometry, 'LINESTRING (10 10, 10 150, 130 10)'::geometry, 0.5);\n" 2530" st_hausdorffdistance\n" 2531" ----------------------\n" 2532" 70\n" 2533"(1 row)" 2534 2535#. Tag: para 2536#: reference_measure.xml:1131 2537#, no-c-format 2538msgid "" 2539", <xref linkend=\"ST_LongestLine\"/>, <xref linkend=\"ST_DFullyWithin\"/>" 2540msgstr "" 2541 2542#. Tag: refname 2543#: reference_measure.xml:1137 2544#, no-c-format 2545msgid "ST_3DMaxDistance" 2546msgstr "ST_3DMaxDistance" 2547 2548#. Tag: refpurpose 2549#: reference_measure.xml:1139 2550#, no-c-format 2551msgid "" 2552"Returns the 3D cartesian maximum distance (based on spatial ref) between two " 2553"geometries in projected units." 2554msgstr "" 2555 2556#. Tag: funcprototype 2557#: reference_measure.xml:1144 2558#, no-c-format 2559msgid "" 2560"<funcdef>float <function>ST_3DMaxDistance</function></funcdef> " 2561"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 2562"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 2563msgstr "" 2564"<funcdef>float <function>ST_3DMaxDistance</function></funcdef> " 2565"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 2566"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 2567 2568#. Tag: para 2569#: reference_measure.xml:1159 2570#, no-c-format 2571msgid "" 2572"Returns the 3-dimensional maximum cartesian distance between two geometries " 2573"in projected units (spatial ref units)." 2574msgstr "" 2575 2576#. Tag: programlisting 2577#: reference_measure.xml:1173 2578#, no-c-format 2579msgid "" 2580"-- Geometry example - units in meters (SRID: 2163 US National Atlas Equal " 2581"area) (3D point and line compared 2D point and line)\n" 2582"-- Note: currently no vertical datum support so Z is not transformed and " 2583"assumed to be same units as final.\n" 2584"SELECT ST_3DMaxDistance(\n" 2585" ST_Transform(ST_GeomFromEWKT('SRID=4326;" 2586"POINT(-72.1235 42.3521 10000)'),2163),\n" 2587" ST_Transform(ST_GeomFromEWKT('SRID=4326;" 2588"LINESTRING(-72.1260 42.45 15, -72.123 42.1546 20)'),2163)\n" 2589" ) As dist_3d,\n" 2590" ST_MaxDistance(\n" 2591" ST_Transform(ST_GeomFromEWKT('SRID=4326;" 2592"POINT(-72.1235 42.3521 10000)'),2163),\n" 2593" ST_Transform(ST_GeomFromEWKT('SRID=4326;" 2594"LINESTRING(-72.1260 42.45 15, -72.123 42.1546 20)'),2163)\n" 2595" ) As dist_2d;\n" 2596"\n" 2597" dist_3d | dist_2d\n" 2598"------------------+------------------\n" 2599" 24383.7467488441 | 22247.8472107251" 2600msgstr "" 2601 2602#. Tag: para 2603#: reference_measure.xml:1179 2604#, no-c-format 2605msgid "" 2606", <xref linkend=\"ST_3DDWithin\"/>, <xref linkend=\"ST_3DMaxDistance\"/>, " 2607"<xref linkend=\"ST_Transform\"/>" 2608msgstr "" 2609", <xref linkend=\"ST_3DDWithin\"/>, <xref linkend=\"ST_3DMaxDistance\"/>, " 2610"<xref linkend=\"ST_Transform\"/>" 2611 2612#. Tag: refname 2613#: reference_measure.xml:1185 2614#, no-c-format 2615msgid "ST_MinimumClearance" 2616msgstr "" 2617 2618#. Tag: refpurpose 2619#: reference_measure.xml:1186 2620#, no-c-format 2621msgid "" 2622"Returns the minimum clearance of a geometry, a measure of a geometry's " 2623"robustness." 2624msgstr "" 2625 2626#. Tag: funcprototype 2627#: reference_measure.xml:1191 2628#, fuzzy, no-c-format 2629msgid "" 2630"<funcdef>float <function>ST_MinimumClearance</function></funcdef> " 2631"<paramdef><type>geometry </type><parameter>g</parameter></paramdef>" 2632msgstr "" 2633"<funcdef>float <function>ST_Perimeter2D</function></funcdef> " 2634"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 2635 2636#. Tag: para 2637#: reference_measure.xml:1201 2638#, no-c-format 2639msgid "" 2640"It is possible for a geometry to meet the criteria for validity according to " 2641"<xref linkend=\"ST_IsValid\"/> (polygons) or <xref linkend=\"ST_IsSimple\"/> " 2642"(lines), but to become invalid if one of its vertices is moved by a small " 2643"distance. This can happen due to loss of precision during conversion to text " 2644"formats (such as WKT, KML, GML, GeoJSON), or binary formats that do not use " 2645"double-precision floating point coordinates (e.g. MapInfo TAB)." 2646msgstr "" 2647 2648#. Tag: para 2649#: reference_measure.xml:1209 2650#, no-c-format 2651msgid "" 2652"The minimum clearance is a quantitative measure of a geometry's robustness " 2653"to change in coordinate precision. It is the largest distance by which " 2654"vertices of the geometry can be moved without creating an invalid geometry. " 2655"Larger values of minimum clearance indicate greater robustness." 2656msgstr "" 2657 2658#. Tag: para 2659#: reference_measure.xml:1215 2660#, no-c-format 2661msgid "If a geometry has a minimum clearance of <varname>e</varname>, then:" 2662msgstr "" 2663 2664#. Tag: para 2665#: reference_measure.xml:1219 2666#, no-c-format 2667msgid "" 2668"No two distinct vertices in the geometry are closer than the distance " 2669"<varname>e</varname>." 2670msgstr "" 2671 2672#. Tag: para 2673#: reference_measure.xml:1224 2674#, no-c-format 2675msgid "" 2676"No vertex is closer than <varname>e</varname> to a line segement of which it " 2677"is not an endpoint." 2678msgstr "" 2679 2680#. Tag: para 2681#: reference_measure.xml:1231 2682#, no-c-format 2683msgid "" 2684"If no minimum clearance exists for a geometry (e.g. a single point, or a " 2685"MultiPoint whose points are identical), the return value is " 2686"<varname>Infinity</varname>." 2687msgstr "" 2688 2689#. Tag: para 2690#: reference_measure.xml:1236 2691#, no-c-format 2692msgid "" 2693"To avoid validity issues caused by precision loss, <xref linkend=" 2694"\"ST_ReducePrecision\"/> can reduce coordinate precision while ensuring that " 2695"polygonal geometry remains valid." 2696msgstr "" 2697 2698#. Tag: para 2699#: reference_measure.xml:1242 2700#, fuzzy, no-c-format 2701msgid "Availability: 2.3.0" 2702msgstr "Disponibilità: 2.0" 2703 2704#. Tag: programlisting 2705#: reference_measure.xml:1248 2706#, no-c-format 2707msgid "" 2708"SELECT ST_MinimumClearance('POLYGON ((0 0, 1 0, 1 1, 0.5 3.2e-4, 0 0))');\n" 2709" st_minimumclearance\n" 2710"---------------------\n" 2711" 0.00032" 2712msgstr "" 2713 2714#. Tag: para 2715#: reference_measure.xml:1255 2716#, fuzzy, no-c-format 2717msgid "" 2718", <xref linkend=\"ST_IsSimple\"/>, <xref linkend=\"ST_IsValid\"/>, <xref " 2719"linkend=\"ST_ReducePrecision\"/>" 2720msgstr "" 2721", <xref linkend=\"ST_Crosses\"/>, <xref linkend=\"ST_Dimension\"/>, <xref " 2722"linkend=\"ST_Intersects\"/>" 2723 2724#. Tag: refname 2725#: reference_measure.xml:1266 2726#, no-c-format 2727msgid "ST_MinimumClearanceLine" 2728msgstr "" 2729 2730#. Tag: refpurpose 2731#: reference_measure.xml:1267 2732#, no-c-format 2733msgid "" 2734"Returns the two-point LineString spanning a geometry's minimum clearance." 2735msgstr "" 2736 2737#. Tag: funcprototype 2738#: reference_measure.xml:1272 2739#, fuzzy, no-c-format 2740msgid "" 2741"<funcdef>Geometry <function>ST_MinimumClearanceLine</function></funcdef> " 2742"<paramdef><type>geometry </type> <parameter>g</parameter></paramdef>" 2743msgstr "" 2744"<funcdef>geometry <function>ST_PointOnSurface</function></funcdef> " 2745"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 2746 2747#. Tag: para 2748#: reference_measure.xml:1285 2749#, no-c-format 2750msgid "" 2751"Returns the two-point LineString spanning a geometry's minimum clearance. If " 2752"the geometry does not have a minimum clearance, <varname>LINESTRING EMPTY</" 2753"varname> will be returned." 2754msgstr "" 2755 2756#. Tag: para 2757#: reference_measure.xml:1290 2758#, no-c-format 2759msgid "Availability: 2.3.0 - requires GEOS >= 3.6.0" 2760msgstr "" 2761 2762#. Tag: programlisting 2763#: reference_measure.xml:1296 2764#, no-c-format 2765msgid "" 2766"SELECT ST_AsText(ST_MinimumClearanceLine('POLYGON ((0 0, 1 0, 1 1, 0.5 " 2767"3.2e-4, 0 0))'));\n" 2768"st_astext\n" 2769"-------------------------------\n" 2770"LINESTRING(0.5 0.00032,0.5 0)" 2771msgstr "" 2772 2773#. Tag: refname 2774#: reference_measure.xml:1311 2775#, no-c-format 2776msgid "ST_Perimeter" 2777msgstr "ST_Perimeter" 2778 2779#. Tag: refpurpose 2780#: reference_measure.xml:1313 2781#, no-c-format 2782msgid "" 2783"Returns the length of the boundary of a polygonal geometry or geography." 2784msgstr "" 2785 2786#. Tag: funcsynopsis 2787#: reference_measure.xml:1316 2788#, no-c-format 2789msgid "" 2790"<funcprototype> <funcdef>float <function>ST_Perimeter</function></funcdef> " 2791"<paramdef><type>geometry </type><parameter>g1</parameter></paramdef> </" 2792"funcprototype> <funcprototype> <funcdef>float <function>ST_Perimeter</" 2793"function></funcdef> <paramdef><type>geography </type><parameter>geog</" 2794"parameter></paramdef> <paramdef choice=\"opt\"><type>boolean </" 2795"type><parameter>use_spheroid=true</parameter></paramdef> </funcprototype>" 2796msgstr "" 2797 2798#. Tag: para 2799#: reference_measure.xml:1332 2800#, no-c-format 2801msgid "" 2802"Returns the 2D perimeter of the geometry/geography if it is a ST_Surface, " 2803"ST_MultiSurface (Polygon, MultiPolygon). 0 is returned for non-areal " 2804"geometries. For linear geometries use <xref linkend=\"ST_Length\"/>. For " 2805"geometry types, units for perimeter measures are specified by the spatial " 2806"reference system of the geometry." 2807msgstr "" 2808 2809#. Tag: para 2810#: reference_measure.xml:1335 2811#, no-c-format 2812msgid "" 2813"For geography types, the calculations are performed using the inverse " 2814"geodesic problem, where perimeter units are in meters. If PostGIS is " 2815"compiled with PROJ version 4.8.0 or later, the spheroid is specified by the " 2816"SRID, otherwise it is exclusive to WGS84. If <varname>use_spheroid=false</" 2817"varname>, then calculations will approximate a sphere instead of a spheroid." 2818msgstr "" 2819 2820#. Tag: para 2821#: reference_measure.xml:1339 2822#, no-c-format 2823msgid "" 2824"Currently this is an alias for ST_Perimeter2D, but this may change to " 2825"support higher dimensions." 2826msgstr "" 2827 2828#. Tag: para 2829#: reference_measure.xml:1342 2830#, no-c-format 2831msgid "&sqlmm_compliant; SQL-MM 3: 8.1.3, 9.5.4" 2832msgstr "&sqlmm_compliant; SQL-MM 3: 8.1.3, 9.5.4" 2833 2834#. Tag: para 2835#: reference_measure.xml:1343 2836#, no-c-format 2837msgid "Availability 2.0.0: Support for geography was introduced" 2838msgstr "" 2839 2840#. Tag: title 2841#: reference_measure.xml:1347 2842#, no-c-format 2843msgid "Examples: Geometry" 2844msgstr "" 2845 2846#. Tag: para 2847#: reference_measure.xml:1348 2848#, no-c-format 2849msgid "" 2850"Return perimeter in feet for Polygon and MultiPolygon. Note this is in feet " 2851"because EPSG:2249 is Massachusetts State Plane Feet" 2852msgstr "" 2853 2854#. Tag: programlisting 2855#: reference_measure.xml:1350 2856#, no-c-format 2857msgid "" 2858"SELECT ST_Perimeter(ST_GeomFromText('POLYGON((743238 2967416,743238 " 2859"2967450,743265 2967450,\n" 2860"743265.625 2967416,743238 2967416))', 2249));\n" 2861"st_perimeter\n" 2862"---------\n" 2863" 122.630744000095\n" 2864"(1 row)\n" 2865"\n" 2866"SELECT ST_Perimeter(ST_GeomFromText('MULTIPOLYGON(((763104.471273676 " 2867"2949418.44119003,\n" 2868"763104.477769673 2949418.42538203,\n" 2869"763104.189609677 2949418.22343004,763104.471273676 2949418.44119003)),\n" 2870"((763104.471273676 2949418.44119003,763095.804579742 2949436.33850239,\n" 2871"763086.132105649 2949451.46730207,763078.452329651 2949462.11549407,\n" 2872"763075.354136904 2949466.17407812,763064.362142565 2949477.64291974,\n" 2873"763059.953961626 2949481.28983009,762994.637609571 2949532.04103014,\n" 2874"762990.568508415 2949535.06640477,762986.710889563 2949539.61421415,\n" 2875"763117.237897679 2949709.50493431,763235.236617789 2949617.95619822,\n" 2876"763287.718121842 2949562.20592617,763111.553321674 2949423.91664605,\n" 2877"763104.471273676 2949418.44119003)))', 2249));\n" 2878"st_perimeter\n" 2879"---------\n" 2880" 845.227713366825\n" 2881"(1 row)" 2882msgstr "" 2883"SELECT ST_Perimeter(ST_GeomFromText('POLYGON((743238 2967416,743238 " 2884"2967450,743265 2967450,\n" 2885"743265.625 2967416,743238 2967416))', 2249));\n" 2886"st_perimeter\n" 2887"---------\n" 2888" 122.630744000095\n" 2889"(1 row)\n" 2890"\n" 2891"SELECT ST_Perimeter(ST_GeomFromText('MULTIPOLYGON(((763104.471273676 " 2892"2949418.44119003,\n" 2893"763104.477769673 2949418.42538203,\n" 2894"763104.189609677 2949418.22343004,763104.471273676 2949418.44119003)),\n" 2895"((763104.471273676 2949418.44119003,763095.804579742 2949436.33850239,\n" 2896"763086.132105649 2949451.46730207,763078.452329651 2949462.11549407,\n" 2897"763075.354136904 2949466.17407812,763064.362142565 2949477.64291974,\n" 2898"763059.953961626 2949481.28983009,762994.637609571 2949532.04103014,\n" 2899"762990.568508415 2949535.06640477,762986.710889563 2949539.61421415,\n" 2900"763117.237897679 2949709.50493431,763235.236617789 2949617.95619822,\n" 2901"763287.718121842 2949562.20592617,763111.553321674 2949423.91664605,\n" 2902"763104.471273676 2949418.44119003)))', 2249));\n" 2903"st_perimeter\n" 2904"---------\n" 2905" 845.227713366825\n" 2906"(1 row)" 2907 2908#. Tag: title 2909#: reference_measure.xml:1353 2910#, no-c-format 2911msgid "Examples: Geography" 2912msgstr "" 2913 2914#. Tag: para 2915#: reference_measure.xml:1354 2916#, no-c-format 2917msgid "" 2918"Return perimeter in meters and feet for Polygon and MultiPolygon. Note this " 2919"is geography (WGS 84 long lat)" 2920msgstr "" 2921 2922#. Tag: programlisting 2923#: reference_measure.xml:1355 2924#, no-c-format 2925msgid "" 2926"SELECT ST_Perimeter(geog) As per_meters, ST_Perimeter(geog)/0.3048 As " 2927"per_ft\n" 2928"FROM ST_GeogFromText('POLYGON((-71.1776848522251 " 2929"42.3902896512902,-71.1776843766326 42.3903829478009,\n" 2930"-71.1775844305465 42.3903826677917,-71.1775825927231 " 2931"42.3902893647987,-71.1776848522251 42.3902896512902))') As geog;\n" 2932"\n" 2933" per_meters | per_ft\n" 2934"-----------------+------------------\n" 2935"37.3790462565251 | 122.634666195949\n" 2936"\n" 2937"\n" 2938"-- MultiPolygon example --\n" 2939"SELECT ST_Perimeter(geog) As per_meters, ST_Perimeter(geog,false) As " 2940"per_sphere_meters, ST_Perimeter(geog)/0.3048 As per_ft\n" 2941"FROM ST_GeogFromText('MULTIPOLYGON(((-71.1044543107478 " 2942"42.340674480411,-71.1044542869917 42.3406744369506,\n" 2943"-71.1044553562977 42.340673886454,-71.1044543107478 42.340674480411)),\n" 2944"((-71.1044543107478 42.340674480411,-71.1044860600303 " 2945"42.3407237015564,-71.1045215770124 42.3407653385914,\n" 2946"-71.1045498002983 42.3407946553165,-71.1045611902745 " 2947"42.3408058316308,-71.1046016507427 42.340837442371,\n" 2948"-71.104617893173 42.3408475056957,-71.1048586153981 " 2949"42.3409875993595,-71.1048736143677 42.3409959528211,\n" 2950"-71.1048878050242 42.3410084812078,-71.1044020965803 42.3414730072048,\n" 2951"-71.1039672113619 42.3412202916693,-71.1037740497748 42.3410666421308,\n" 2952"-71.1044280218456 42.3406894151355,-71.1044543107478 42.340674480411)))') As " 2953"geog;\n" 2954"\n" 2955" per_meters | per_sphere_meters | per_ft\n" 2956"------------------+-------------------+------------------\n" 2957" 257.634283683311 | 257.412311446337 | 845.256836231335" 2958msgstr "" 2959 2960#. Tag: para 2961#: reference_measure.xml:1359 2962#, no-c-format 2963msgid ", <xref linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_Length\"/>" 2964msgstr ", <xref linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_Length\"/>" 2965 2966#. Tag: refname 2967#: reference_measure.xml:1365 2968#, no-c-format 2969msgid "ST_Perimeter2D" 2970msgstr "ST_Perimeter2D" 2971 2972#. Tag: refpurpose 2973#: reference_measure.xml:1367 2974#, no-c-format 2975msgid "" 2976"Returns the 2D perimeter of a polygonal geometry. Alias for " 2977"<varname>ST_Perimeter</varname>." 2978msgstr "" 2979 2980#. Tag: funcprototype 2981#: reference_measure.xml:1373 2982#, no-c-format 2983msgid "" 2984"<funcdef>float <function>ST_Perimeter2D</function></funcdef> " 2985"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 2986msgstr "" 2987"<funcdef>float <function>ST_Perimeter2D</function></funcdef> " 2988"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 2989 2990#. Tag: para 2991#: reference_measure.xml:1383 2992#, no-c-format 2993msgid "Returns the 2-dimensional perimeter of a polygonal geometry." 2994msgstr "" 2995 2996#. Tag: para 2997#: reference_measure.xml:1387 2998#, no-c-format 2999msgid "" 3000"This is currently an alias for ST_Perimeter. In future versions ST_Perimeter " 3001"may return the highest dimension perimeter for a geometry. This is still " 3002"under consideration" 3003msgstr "" 3004 3005#. Tag: refname 3006#: reference_measure.xml:1401 3007#, no-c-format 3008msgid "ST_3DPerimeter" 3009msgstr "ST_3DPerimeter" 3010 3011#. Tag: refpurpose 3012#: reference_measure.xml:1403 3013#, no-c-format 3014msgid "Returns the 3D perimeter of a polygonal geometry." 3015msgstr "" 3016 3017#. Tag: funcprototype 3018#: reference_measure.xml:1408 3019#, no-c-format 3020msgid "" 3021"<funcdef>float <function>ST_3DPerimeter</function></funcdef> " 3022"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 3023msgstr "" 3024"<funcdef>float <function>ST_3DPerimeter</function></funcdef> " 3025"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 3026 3027#. Tag: para 3028#: reference_measure.xml:1418 3029#, no-c-format 3030msgid "" 3031"Returns the 3-dimensional perimeter of the geometry, if it is a polygon or " 3032"multi-polygon. If the geometry is 2-dimensional, then the 2-dimensional " 3033"perimeter is returned." 3034msgstr "" 3035 3036#. Tag: para 3037#: reference_measure.xml:1421 3038#, no-c-format 3039msgid "Changed: 2.0.0 In prior versions this used to be called ST_Perimeter3D" 3040msgstr "" 3041 3042#. Tag: para 3043#: reference_measure.xml:1427 3044#, no-c-format 3045msgid "" 3046"Perimeter of a slightly elevated polygon in the air in Massachusetts state " 3047"plane feet" 3048msgstr "" 3049 3050#. Tag: programlisting 3051#: reference_measure.xml:1428 3052#, fuzzy, no-c-format 3053msgid "" 3054"SELECT ST_3DPerimeter(geom), ST_Perimeter2d(geom), ST_Perimeter(geom) FROM\n" 3055" (SELECT ST_GeomFromEWKT('SRID=2249;POLYGON((743238 " 3056"2967416 2,743238 2967450 1,\n" 3057"743265.625 2967416 1,743238 2967416 2))') As geom) As foo;\n" 3058"\n" 3059" ST_3DPerimeter | st_perimeter2d | st_perimeter\n" 3060"------------------+------------------+------------------\n" 3061" 105.465793597674 | 105.432997272188 | 105.432997272188" 3062msgstr "" 3063"SELECT ST_3DPerimeter(the_geom), ST_Perimeter2d(the_geom), " 3064"ST_Perimeter(the_geom) FROM\n" 3065" (SELECT ST_GeomFromEWKT('SRID=2249;POLYGON((743238 " 3066"2967416 2,743238 2967450 1,\n" 3067"743265.625 2967416 1,743238 2967416 2))') As the_geom) As foo;\n" 3068"\n" 3069" ST_3DPerimeter | st_perimeter2d | st_perimeter\n" 3070"------------------+------------------+------------------\n" 3071" 105.465793597674 | 105.432997272188 | 105.432997272188" 3072 3073#. Tag: para 3074#: reference_measure.xml:1435 3075#, no-c-format 3076msgid ", <xref linkend=\"ST_Perimeter\"/>, <xref linkend=\"ST_Perimeter2D\"/>" 3077msgstr ", <xref linkend=\"ST_Perimeter\"/>, <xref linkend=\"ST_Perimeter2D\"/>" 3078 3079#. Tag: refname 3080#: reference_measure.xml:1441 3081#, no-c-format 3082msgid "ST_Project" 3083msgstr "ST_Project" 3084 3085#. Tag: refpurpose 3086#: reference_measure.xml:1443 3087#, no-c-format 3088msgid "" 3089"Returns a point projected from a start point by a distance and bearing " 3090"(azimuth)." 3091msgstr "" 3092 3093#. Tag: funcprototype 3094#: reference_measure.xml:1448 3095#, no-c-format 3096msgid "" 3097"<funcdef>geography <function>ST_Project</function></funcdef> " 3098"<paramdef><type>geography </type> <parameter>g1</parameter></paramdef> " 3099"<paramdef><type>float </type> <parameter>distance</parameter></paramdef> " 3100"<paramdef><type>float </type> <parameter>azimuth</parameter></paramdef>" 3101msgstr "" 3102"<funcdef>geography <function>ST_Project</function></funcdef> " 3103"<paramdef><type>geography </type> <parameter>g1</parameter></paramdef> " 3104"<paramdef><type>float </type> <parameter>distance</parameter></paramdef> " 3105"<paramdef><type>float </type> <parameter>azimuth</parameter></paramdef>" 3106 3107#. Tag: para 3108#: reference_measure.xml:1464 3109#, no-c-format 3110msgid "" 3111"Returns a point projected from a start point along a geodesic using a given " 3112"distance and azimuth (bearing). This is known as the direct geodesic problem." 3113msgstr "" 3114 3115#. Tag: para 3116#: reference_measure.xml:1467 3117#, no-c-format 3118msgid "The distance is given in meters. Negative values are supported." 3119msgstr "" 3120 3121#. Tag: para 3122#: reference_measure.xml:1468 3123#, no-c-format 3124msgid "" 3125"The azimuth (also known as heading or bearing) is given in radians. It is " 3126"measured clockwise from true north (azimuth zero). East is azimuth " 3127"π/2 (90 degrees); south is azimuth π (180 degrees); west is " 3128"azimuth 3π/2 (270 degrees). Negative azimuth values and values " 3129"greater than 2π (360 degrees) are supported." 3130msgstr "" 3131 3132#. Tag: para 3133#: reference_measure.xml:1478 3134#, no-c-format 3135msgid "Enhanced: 2.4.0 Allow negative distance and non-normalized azimuth." 3136msgstr "" 3137 3138#. Tag: title 3139#: reference_measure.xml:1483 3140#, no-c-format 3141msgid "Example: Projected point at 100,000 meters and bearing 45 degrees" 3142msgstr "" 3143 3144#. Tag: programlisting 3145#: reference_measure.xml:1485 3146#, no-c-format 3147msgid "" 3148"SELECT ST_AsText(ST_Project('POINT(0 0)'::geography, 100000, " 3149"radians(45.0)));\n" 3150"\n" 3151" st_astext\n" 3152"--------------------------------------------\n" 3153" POINT(0.635231029125537 0.639472334729198)\n" 3154"(1 row)" 3155msgstr "" 3156 3157#. Tag: para 3158#: reference_measure.xml:1491 3159#, no-c-format 3160msgid "" 3161", <xref linkend=\"ST_Distance\"/>, <ulink url=\"http://www.postgresql.org/" 3162"docs/current/interactive/functions-math.html\">PostgreSQL function " 3163"radians()</ulink>" 3164msgstr "" 3165 3166#. Tag: refname 3167#: reference_measure.xml:1498 3168#, no-c-format 3169msgid "ST_ShortestLine" 3170msgstr "ST_ShortestLine" 3171 3172#. Tag: refpurpose 3173#: reference_measure.xml:1500 3174#, no-c-format 3175msgid "Returns the 2D shortest line between two geometries" 3176msgstr "" 3177 3178#. Tag: funcprototype 3179#: reference_measure.xml:1505 3180#, no-c-format 3181msgid "" 3182"<funcdef>geometry <function>ST_ShortestLine</function></funcdef> " 3183"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 3184"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 3185msgstr "" 3186 3187#. Tag: para 3188#: reference_measure.xml:1520 3189#, no-c-format 3190msgid "" 3191"Returns the 2-dimensional shortest line between two geometries. The function " 3192"will only return the first shortest line if more than one, that the function " 3193"finds. If g1 and g2 intersects in just one point the function will return a " 3194"line with both start and end in that intersection-point. If g1 and g2 are " 3195"intersecting with more than one point the function will return a line with " 3196"start and end in the same point but it can be any of the intersecting " 3197"points. The line returned will always start in g1 and end in g2. The length " 3198"of the line this function returns will always be the same as ST_Distance " 3199"returns for g1 and g2." 3200msgstr "" 3201 3202#. Tag: para 3203#: reference_measure.xml:1544 3204#, no-c-format 3205msgid "Shortest line between point and linestring" 3206msgstr "" 3207 3208#. Tag: programlisting 3209#: reference_measure.xml:1547 3210#, fuzzy, no-c-format 3211msgid "" 3212"SELECT ST_AsText(\n" 3213" ST_ShortestLine('POINT(100 100)'::geometry,\n" 3214" 'LINESTRING (20 80, 98 190, 110 180, 50 75 )'::geometry)\n" 3215" ) As sline;\n" 3216"\n" 3217"\n" 3218" sline\n" 3219"-----------------\n" 3220"LINESTRING(100 100,73.0769230769231 115.384615384615)" 3221msgstr "" 3222"SELECT ST_AsText(\n" 3223" ST_ShortestLine('POINT(100 100)'::geometry, \n" 3224" 'LINESTRING (20 80, 98 190, 110 180, 50 75 )'::geometry)\n" 3225" ) As sline;\n" 3226"\n" 3227" \n" 3228" sline\n" 3229"-----------------\n" 3230"LINESTRING(100 100,73.0769230769231 115.384615384615)" 3231 3232#. Tag: para 3233#: reference_measure.xml:1555 3234#, no-c-format 3235msgid "shortest line between polygon and polygon" 3236msgstr "" 3237 3238#. Tag: programlisting 3239#: reference_measure.xml:1558 3240#, fuzzy, no-c-format 3241msgid "" 3242"SELECT ST_AsText(\n" 3243" ST_ShortestLine(\n" 3244" ST_GeomFromText('POLYGON((175 150, 20 40, 50 60, 125 " 3245"100, 175 150))'),\n" 3246" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 3247" )\n" 3248" ) As slinewkt;\n" 3249"\n" 3250" LINESTRING(140.752120669087 125.695053378061,121.111404660392 " 3251"153.370607753949)" 3252msgstr "" 3253"SELECT ST_AsText(\n" 3254" ST_ShortestLine(\n" 3255" ST_GeomFromText('POLYGON((175 150, 20 40, 50 60, 125 " 3256"100, 175 150))'),\n" 3257" ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n" 3258" ) \n" 3259" ) As slinewkt;\n" 3260" \n" 3261" LINESTRING(140.752120669087 125.695053378061,121.111404660392 " 3262"153.370607753949)" 3263 3264#. Tag: para 3265#: reference_measure.xml:1570 3266#, no-c-format 3267msgid "" 3268", <xref linkend=\"ST_Distance\"/>, <xref linkend=\"ST_LongestLine\"/>, <xref " 3269"linkend=\"ST_MaxDistance\"/>" 3270msgstr "" 3271", <xref linkend=\"ST_Distance\"/>, <xref linkend=\"ST_LongestLine\"/>, <xref " 3272"linkend=\"ST_MaxDistance\"/>" 3273 3274#. Tag: refname 3275#: reference_measure.xml:1575 3276#, no-c-format 3277msgid "ST_3DShortestLine" 3278msgstr "ST_3DShortestLine" 3279 3280#. Tag: refpurpose 3281#: reference_measure.xml:1577 3282#, no-c-format 3283msgid "Returns the 3D shortest line between two geometries" 3284msgstr "" 3285 3286#. Tag: funcprototype 3287#: reference_measure.xml:1582 3288#, no-c-format 3289msgid "" 3290"<funcdef>geometry <function>ST_3DShortestLine</function></funcdef> " 3291"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 3292"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 3293msgstr "" 3294"<funcdef>geometry <function>ST_3DShortestLine</function></funcdef> " 3295"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 3296"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 3297 3298#. Tag: para 3299#: reference_measure.xml:1597 3300#, no-c-format 3301msgid "" 3302"Returns the 3-dimensional shortest line between two geometries. The function " 3303"will only return the first shortest line if more than one, that the function " 3304"finds. If g1 and g2 intersects in just one point the function will return a " 3305"line with both start and end in that intersection-point. If g1 and g2 are " 3306"intersecting with more than one point the function will return a line with " 3307"start and end in the same point but it can be any of the intersecting " 3308"points. The line returned will always start in g1 and end in g2. The 3D " 3309"length of the line this function returns will always be the same as <xref " 3310"linkend=\"ST_3DDistance\"/> returns for g1 and g2." 3311msgstr "" 3312 3313#. Tag: para 3314#: reference_measure.xml:1620 3315#, no-c-format 3316msgid "linestring and point -- both 3d and 2d shortest line" 3317msgstr "" 3318 3319#. Tag: programlisting 3320#: reference_measure.xml:1621 3321#, fuzzy, no-c-format 3322msgid "" 3323"SELECT ST_AsEWKT(ST_3DShortestLine(line,pt)) AS shl3d_line_pt,\n" 3324" ST_AsEWKT(ST_ShortestLine(line,pt)) As shl2d_line_pt\n" 3325" FROM (SELECT 'POINT(100 100 30)'::geometry As pt,\n" 3326" 'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 " 3327"1000)'::geometry As line\n" 3328" ) As foo;\n" 3329"\n" 3330"\n" 3331" shl3d_line_pt " 3332"| shl2d_line_pt\n" 3333"----------------------------------------------------------------------------" 3334"+------------------------------------------------------\n" 3335" LINESTRING(54.6993798867619 128.935022917228 11.5475869506606,100 100 30) " 3336"| LINESTRING(73.0769230769231 115.384615384615,100 100)" 3337msgstr "" 3338"SELECT ST_AsEWKT(ST_3DShortestLine(line,pt)) AS shl3d_line_pt, \n" 3339" ST_AsEWKT(ST_ShortestLine(line,pt)) As shl2d_line_pt\n" 3340" FROM (SELECT 'POINT(100 100 30)'::geometry As pt, \n" 3341" 'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 " 3342"1000)'::geometry As line\n" 3343" ) As foo;\n" 3344" \n" 3345" \n" 3346" shl3d_line_pt " 3347"| shl2d_line_pt\n" 3348"----------------------------------------------------------------------------" 3349"+------------------------------------------------------\n" 3350" LINESTRING(54.6993798867619 128.935022917228 11.5475869506606,100 100 30) " 3351"| LINESTRING(73.0769230769231 115.384615384615,100 100)" 3352 3353#. Tag: para 3354#: reference_measure.xml:1625 3355#, no-c-format 3356msgid "linestring and multipoint -- both 3d and 2d shortest line" 3357msgstr "" 3358 3359#. Tag: programlisting 3360#: reference_measure.xml:1626 3361#, fuzzy, no-c-format 3362msgid "" 3363"SELECT ST_AsEWKT(ST_3DShortestLine(line,pt)) AS shl3d_line_pt,\n" 3364" ST_AsEWKT(ST_ShortestLine(line,pt)) As shl2d_line_pt\n" 3365" FROM (SELECT 'MULTIPOINT(100 100 30, 50 74 1000)'::geometry As pt,\n" 3366" 'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 " 3367"900)'::geometry As line\n" 3368" ) As foo;\n" 3369"\n" 3370"\n" 3371" shl3d_line_pt | " 3372"shl2d_line_pt\n" 3373"---------------------------------------------------------------------------" 3374"+------------------------\n" 3375" LINESTRING(54.6993798867619 128.935022917228 11.5475869506606,100 100 30) | " 3376"LINESTRING(50 75,50 74)" 3377msgstr "" 3378"SELECT ST_AsEWKT(ST_3DShortestLine(line,pt)) AS shl3d_line_pt, \n" 3379" ST_AsEWKT(ST_ShortestLine(line,pt)) As shl2d_line_pt\n" 3380" FROM (SELECT 'MULTIPOINT(100 100 30, 50 74 1000)'::geometry As pt, \n" 3381" 'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 " 3382"900)'::geometry As line\n" 3383" ) As foo;\n" 3384" \n" 3385" \n" 3386" shl3d_line_pt | " 3387"shl2d_line_pt\n" 3388"---------------------------------------------------------------------------" 3389"+------------------------\n" 3390" LINESTRING(54.6993798867619 128.935022917228 11.5475869506606,100 100 30) | " 3391"LINESTRING(50 75,50 74)" 3392 3393#. Tag: para 3394#: reference_measure.xml:1630 3395#, no-c-format 3396msgid "MultiLineString and polygon both 3d and 2d shortest line" 3397msgstr "" 3398 3399#. Tag: programlisting 3400#: reference_measure.xml:1631 3401#, fuzzy, no-c-format 3402msgid "" 3403"SELECT ST_AsEWKT(ST_3DShortestLine(poly, mline)) As shl3d,\n" 3404" ST_AsEWKT(ST_ShortestLine(poly, mline)) As shl2d\n" 3405" FROM (SELECT ST_GeomFromEWKT('POLYGON((175 150 5, 20 40 5, 35 45 5, " 3406"50 60 5, 100 100 5, 175 150 5))') As poly,\n" 3407" ST_GeomFromEWKT('MULTILINESTRING((175 155 2, 20 40 20, 50 60 " 3408"-2, 125 100 1, 175 155 1),\n" 3409" (1 10 2, 5 20 1))') As mline ) As foo;\n" 3410" shl3d " 3411"| shl2d\n" 3412"---------------------------------------------------------------------------------------------------" 3413"+------------------------\n" 3414" LINESTRING(39.993580415989 54.1889925532825 5,40.4078575708294 " 3415"53.6052383805529 5.03423778139177) | LINESTRING(20 40,20 40)" 3416msgstr "" 3417"SELECT ST_AsEWKT(ST_3DClosestPoint(poly, mline)) As cp3d,\n" 3418" ST_AsEWKT(ST_ClosestPoint(poly, mline)) As cp2d \n" 3419" FROM (SELECT ST_GeomFromEWKT('POLYGON((175 150 5, 20 40 5, 35 45 5, " 3420"50 60 5, 100 100 5, 175 150 5))') As poly,\n" 3421" ST_GeomFromEWKT('MULTILINESTRING((175 155 2, 20 40 20, 50 60 " 3422"-2, 125 100 1, 175 155 1),\n" 3423" (1 10 2, 5 20 1))') As mline ) As foo;\n" 3424" cp3d | cp2d\n" 3425"-------------------------------------------+--------------\n" 3426" POINT(39.993580415989 54.1889925532825 5) | POINT(20 40)" 3427 3428#. Tag: para 3429#: reference_measure.xml:1643 3430#, no-c-format 3431msgid "" 3432", <xref linkend=\"ST_3DDistance\"/>, <xref linkend=\"ST_LongestLine\"/>, " 3433"<xref linkend=\"ST_ShortestLine\"/>, <xref linkend=\"ST_3DMaxDistance\"/>" 3434msgstr "" 3435", <xref linkend=\"ST_3DDistance\"/>, <xref linkend=\"ST_LongestLine\"/>, " 3436"<xref linkend=\"ST_ShortestLine\"/>, <xref linkend=\"ST_3DMaxDistance\"/>" 3437 3438#, fuzzy 3439#~ msgid "" 3440#~ ", <xref linkend=\"ST_ShortestLine\"/>, <xref linkend=\"ST_3DLongestLine\"/" 3441#~ ">" 3442#~ msgstr "" 3443#~ ", <xref linkend=\"ST_ShortestLine\"/>, <xref linkend=\"ST_LongestLine\"/>" 3444 3445#~ msgid "Spatial Relationships and Measurements" 3446#~ msgstr "Relazioni e misure spaziali" 3447 3448#~ msgid "ST_3DDWithin" 3449#~ msgstr "ST_3DDWithin" 3450 3451#~ msgid "" 3452#~ "<funcdef>boolean <function>ST_3DDWithin</function></funcdef> " 3453#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 3454#~ "<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> " 3455#~ "<paramdef><type>double precision </type> <parameter>distance_of_srid</" 3456#~ "parameter></paramdef>" 3457#~ msgstr "" 3458#~ "<funcdef>boolean <function>ST_3DDWithin</function></funcdef> " 3459#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 3460#~ "<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> " 3461#~ "<paramdef><type>double precision </type> <parameter>distance_of_srid</" 3462#~ "parameter></paramdef>" 3463 3464#~ msgid "" 3465#~ ", <xref linkend=\"ST_Distance\"/>, <xref linkend=\"ST_DWithin\"/>, <xref " 3466#~ "linkend=\"ST_3DMaxDistance\"/>, <xref linkend=\"ST_Transform\"/>" 3467#~ msgstr "" 3468#~ ", <xref linkend=\"ST_Distance\"/>, <xref linkend=\"ST_DWithin\"/>, <xref " 3469#~ "linkend=\"ST_3DMaxDistance\"/>, <xref linkend=\"ST_Transform\"/>" 3470 3471#~ msgid "ST_3DDFullyWithin" 3472#~ msgstr "ST_3DDFullyWithin" 3473 3474#~ msgid "" 3475#~ "<funcdef>boolean <function>ST_3DDFullyWithin</function></funcdef> " 3476#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 3477#~ "<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> " 3478#~ "<paramdef><type>double precision </type> <parameter>distance</parameter></" 3479#~ "paramdef>" 3480#~ msgstr "" 3481#~ "<funcdef>boolean <function>ST_3DDFullyWithin</function></funcdef> " 3482#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 3483#~ "<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> " 3484#~ "<paramdef><type>double precision </type> <parameter>distance</parameter></" 3485#~ "paramdef>" 3486 3487#, fuzzy 3488#~ msgid "" 3489#~ "-- This compares the difference between fully within and distance within " 3490#~ "as well\n" 3491#~ " -- as the distance fully within for the 2D footprint of " 3492#~ "the line/point vs. the 3d fully within\n" 3493#~ " SELECT ST_3DDFullyWithin(geom_a, geom_b, 10) as " 3494#~ "D3DFullyWithin10, ST_3DDWithin(geom_a, geom_b, 10) as D3DWithin10,\n" 3495#~ " ST_DFullyWithin(geom_a, geom_b, 20) as D2DFullyWithin20,\n" 3496#~ " ST_3DDFullyWithin(geom_a, geom_b, 20) as D3DFullyWithin20 from\n" 3497#~ " (select ST_GeomFromEWKT('POINT(1 1 2)') as geom_a,\n" 3498#~ " ST_GeomFromEWKT('LINESTRING(1 5 2, 2 7 20, 1 9 100, 14 12 " 3499#~ "3)') as geom_b) t1;\n" 3500#~ " d3dfullywithin10 | d3dwithin10 | d2dfullywithin20 | d3dfullywithin20\n" 3501#~ "------------------+-------------+------------------+------------------\n" 3502#~ " f | t | t | f" 3503#~ msgstr "" 3504#~ "postgis=# SELECT ST_DFullyWithin(geom_a, geom_b, 10) as DFullyWithin10, " 3505#~ "ST_DWithin(geom_a, geom_b, 10) as DWithin10, ST_DFullyWithin(geom_a, " 3506#~ "geom_b, 20) as DFullyWithin20 from \n" 3507#~ " (select ST_GeomFromText('POINT(1 1)') as geom_a," 3508#~ "ST_GeomFromText('LINESTRING(1 5, 2 7, 1 9, 14 12)') as geom_b) t1;\n" 3509#~ " \n" 3510#~ "-----------------\n" 3511#~ " DFullyWithin10 | DWithin10 | DFullyWithin20 |\n" 3512#~ "---------------+----------+---------------+\n" 3513#~ " f | t | t |" 3514 3515#~ msgid "" 3516#~ ", <xref linkend=\"ST_3DDWithin\"/>, <xref linkend=\"ST_DWithin\"/>, <xref " 3517#~ "linkend=\"ST_DFullyWithin\"/>" 3518#~ msgstr "" 3519#~ ", <xref linkend=\"ST_3DDWithin\"/>, <xref linkend=\"ST_DWithin\"/>, <xref " 3520#~ "linkend=\"ST_DFullyWithin\"/>" 3521 3522#~ msgid "ST_3DIntersects" 3523#~ msgstr "ST_3DIntersects" 3524 3525#~ msgid "" 3526#~ "<funcdef>boolean <function>ST_3DIntersects</function></funcdef> " 3527#~ "<paramdef> <type>geometry</type> <parameter>geomA</parameter> </paramdef> " 3528#~ "<paramdef> <type>geometry</type> <parameter>geomB</parameter> </paramdef>" 3529#~ msgstr "" 3530#~ "<funcdef>boolean <function>ST_3DIntersects</function></funcdef> " 3531#~ "<paramdef> <type>geometry</type> <parameter>geomA</parameter> </paramdef> " 3532#~ "<paramdef> <type>geometry</type> <parameter>geomB</parameter> </paramdef>" 3533 3534#~ msgid "&sqlmm_compliant; SQL-MM 3: ?" 3535#~ msgstr "&sqlmm_compliant; SQL-MM 3: ?" 3536 3537#, fuzzy 3538#~ msgid "" 3539#~ "SELECT ST_3DIntersects(pt, line), ST_Intersects(pt,line)\n" 3540#~ " FROM (SELECT 'POINT(0 0 2)'::geometry As pt,\n" 3541#~ " 'LINESTRING (0 0 1, 0 2 3 )'::geometry As line) As foo;\n" 3542#~ " st_3dintersects | st_intersects\n" 3543#~ "-----------------+---------------\n" 3544#~ " f | t\n" 3545#~ "(1 row)" 3546#~ msgstr "" 3547#~ "SELECT ST_3DIntersects(pt, line), ST_Intersects(pt,line) \n" 3548#~ " FROM (SELECT 'POINT(0 0 2)'::geometry As pt, \n" 3549#~ " 'LINESTRING (0 0 1, 0 2 3 )'::geometry As line) As foo;\n" 3550#~ " st_3dintersects | st_intersects\n" 3551#~ "-----------------+---------------\n" 3552#~ " f | t\n" 3553#~ "(1 row)" 3554 3555#~ msgid "" 3556#~ "SELECT ST_Area(the_geom) As sqft, ST_Area(the_geom)*POWER(0.3048,2) As " 3557#~ "sqm\n" 3558#~ " FROM (SELECT\n" 3559#~ " ST_GeomFromText('POLYGON((743238 2967416,743238 2967450,\n" 3560#~ " 743265 2967450,743265.625 2967416,743238 " 3561#~ "2967416))',2249) ) As foo(the_geom);\n" 3562#~ " sqft | sqm\n" 3563#~ "---------+-------------\n" 3564#~ " 928.625 | 86.27208552" 3565#~ msgstr "" 3566#~ "SELECT ST_Area(the_geom) As sqft, ST_Area(the_geom)*POWER(0.3048,2) As " 3567#~ "sqm\n" 3568#~ " FROM (SELECT\n" 3569#~ " ST_GeomFromText('POLYGON((743238 2967416,743238 2967450,\n" 3570#~ " 743265 2967450,743265.625 2967416,743238 " 3571#~ "2967416))',2249) ) As foo(the_geom);\n" 3572#~ " sqft | sqm\n" 3573#~ "---------+-------------\n" 3574#~ " 928.625 | 86.27208552" 3575 3576#~ msgid "" 3577#~ "SELECT ST_Area(the_geom) As sqft, ST_Area(ST_Transform(the_geom,26986)) " 3578#~ "As sqm\n" 3579#~ " FROM (SELECT\n" 3580#~ " ST_GeomFromText('POLYGON((743238 2967416,743238 2967450,\n" 3581#~ " 743265 2967450,743265.625 2967416,743238 " 3582#~ "2967416))',2249) ) As foo(the_geom);\n" 3583#~ " sqft | sqm\n" 3584#~ "---------+------------------\n" 3585#~ " 928.625 | 86.2724304199219" 3586#~ msgstr "" 3587#~ "SELECT ST_Area(the_geom) As sqft, ST_Area(ST_Transform(the_geom,26986)) " 3588#~ "As sqm\n" 3589#~ " FROM (SELECT\n" 3590#~ " ST_GeomFromText('POLYGON((743238 2967416,743238 2967450,\n" 3591#~ " 743265 2967450,743265.625 2967416,743238 " 3592#~ "2967416))',2249) ) As foo(the_geom);\n" 3593#~ " sqft | sqm\n" 3594#~ "---------+------------------\n" 3595#~ " 928.625 | 86.2724304199219" 3596 3597#~ msgid "" 3598#~ ", <xref linkend=\"ST_GeographyFromText\"/>, <xref linkend=\"ST_SetSRID\"/" 3599#~ ">, <xref linkend=\"ST_Transform\"/>" 3600#~ msgstr "" 3601#~ ", <xref linkend=\"ST_GeographyFromText\"/>, <xref linkend=\"ST_SetSRID\"/" 3602#~ ">, <xref linkend=\"ST_Transform\"/>" 3603 3604#~ msgid "ST_Centroid" 3605#~ msgstr "ST_Centroid" 3606 3607#, fuzzy 3608#~ msgid "" 3609#~ "<funcprototype> <funcdef>geometry <function>ST_Centroid</function></" 3610#~ "funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></" 3611#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geography " 3612#~ "<function>ST_Centroid</function></funcdef> <paramdef><type>geography </" 3613#~ "type> <parameter>g1</parameter></paramdef> <paramdef choice=\"opt" 3614#~ "\"><type>boolean </type> <parameter>use_spheroid=true</parameter></" 3615#~ "paramdef> </funcprototype>" 3616#~ msgstr "" 3617#~ "<funcprototype> <funcdef>float <function>ST_Length</function></funcdef> " 3618#~ "<paramdef><type>geometry </type><parameter>a_2dlinestring</parameter></" 3619#~ "paramdef> </funcprototype> <funcprototype> <funcdef>float " 3620#~ "<function>ST_Length</function></funcdef> <paramdef><type>geography </" 3621#~ "type><parameter>geog</parameter></paramdef> <paramdef choice=\"opt" 3622#~ "\"><type>boolean </type><parameter>use_spheroid=true</parameter></" 3623#~ "paramdef> </funcprototype>" 3624 3625#~ msgid "&sqlmm_compliant; SQL-MM 3: 8.1.4, 9.5.5" 3626#~ msgstr "&sqlmm_compliant; SQL-MM 3: 8.1.4, 9.5.5" 3627 3628#~ msgid "Centroid of a <varname>MULTIPOINT</varname>" 3629#~ msgstr "Centroide di un <varname>MULTIPOINT</varname>" 3630 3631#~ msgid "Centroid of a <varname>LINESTRING</varname>" 3632#~ msgstr "Centroide di una <varname>LINESTRING</varname>" 3633 3634#~ msgid "Centroid of a <varname>POLYGON</varname>" 3635#~ msgstr "Centroide di un <varname>POLYGON</varname>" 3636 3637#~ msgid "Centroid of a <varname>GEOMETRYCOLLECTION</varname>" 3638#~ msgstr "Centroide di una <varname>GEOMETRYCOLLECTION</varname>" 3639 3640#, fuzzy 3641#~ msgid ", <xref linkend=\"ST_GeometricMedian\"/>" 3642#~ msgstr ", <xref linkend=\"ST_Reverse\"/>" 3643 3644#, fuzzy 3645#~ msgid "" 3646#~ "<funcdef>integer <function>ST_ClusterDBSCAN</function></funcdef> " 3647#~ "<paramdef><type>geometry winset </type> <parameter>geom</parameter></" 3648#~ "paramdef> <paramdef><type>float8 </type> <parameter>eps</parameter></" 3649#~ "paramdef> <paramdef><type>integer </type> <parameter>minpoints</" 3650#~ "parameter></paramdef>" 3651#~ msgstr "" 3652#~ "<funcdef>geography <function>ST_Project</function></funcdef> " 3653#~ "<paramdef><type>geography </type> <parameter>g1</parameter></paramdef> " 3654#~ "<paramdef><type>float </type> <parameter>distance</parameter></paramdef> " 3655#~ "<paramdef><type>float </type> <parameter>azimuth</parameter></paramdef>" 3656 3657#, fuzzy 3658#~ msgid "Availability: 2.3.0 - requires GEOS" 3659#~ msgstr "Disponibilità: 2.0" 3660 3661#, fuzzy 3662#~ msgid "" 3663#~ ", <xref linkend=\"ST_ClusterKMeans\"/>, <xref linkend=" 3664#~ "\"ST_ClusterIntersecting\"/>, <xref linkend=\"ST_ClusterWithin\"/>" 3665#~ msgstr "" 3666#~ ", <xref linkend=\"ST_Covers\"/>, <xref linkend=\"ST_ExteriorRing\"/>, " 3667#~ "<xref linkend=\"ST_Within\"/>" 3668 3669#, fuzzy 3670#~ msgid "ST_ClusterIntersecting" 3671#~ msgstr "ST_3DIntersects" 3672 3673#, fuzzy 3674#~ msgid "" 3675#~ "<funcdef>geometry[] <function>ST_ClusterIntersecting</function></funcdef> " 3676#~ "<paramdef><type>geometry set</type> <parameter>g</parameter></paramdef>" 3677#~ msgstr "" 3678#~ "<funcdef>geometry <function>ST_Centroid</function></funcdef> " 3679#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 3680 3681#, fuzzy 3682#~ msgid "Availability: 2.2.0 - requires GEOS" 3683#~ msgstr "Disponibilità: 2.0" 3684 3685#, fuzzy 3686#~ msgid "" 3687#~ ", <xref linkend=\"ST_ClusterKMeans\"/>, <xref linkend=\"ST_ClusterWithin" 3688#~ "\"/>" 3689#~ msgstr ", <xref linkend=\"ST_CoveredBy\"/>, <xref linkend=\"ST_Within\"/>" 3690 3691#, fuzzy 3692#~ msgid "" 3693#~ "<funcdef>integer <function>ST_ClusterKMeans</function></funcdef> " 3694#~ "<paramdef><type>geometry winset </type> <parameter>geom</parameter></" 3695#~ "paramdef> <paramdef><type>integer </type> <parameter>number_of_clusters</" 3696#~ "parameter></paramdef>" 3697#~ msgstr "" 3698#~ "<funcdef>boolean <function>ST_Contains</function></funcdef> " 3699#~ "<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 3700#~ "<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef>" 3701 3702#, fuzzy 3703#~ msgid "" 3704#~ ", <xref linkend=\"ST_ClusterIntersecting\"/>, <xref linkend=" 3705#~ "\"ST_ClusterWithin\"/>, <xref linkend=\"ST_Subdivide\"/>" 3706#~ msgstr "" 3707#~ ", <xref linkend=\"ST_Covers\"/>, <xref linkend=\"ST_ExteriorRing\"/>, " 3708#~ "<xref linkend=\"ST_Within\"/>" 3709 3710#, fuzzy 3711#~ msgid "ST_ClusterWithin" 3712#~ msgstr "ST_Within" 3713 3714#, fuzzy 3715#~ msgid "" 3716#~ "<funcdef>geometry[] <function>ST_ClusterWithin</function></funcdef> " 3717#~ "<paramdef><type>geometry set </type> <parameter>g</parameter></paramdef> " 3718#~ "<paramdef><type>float8 </type> <parameter>distance</parameter></paramdef>" 3719#~ msgstr "" 3720#~ "<funcdef>geometry <function>ST_ClosestPoint</function></funcdef> " 3721#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 3722#~ "<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 3723 3724#, fuzzy 3725#~ msgid "" 3726#~ ", <xref linkend=\"ST_ClusterKMeans\"/>, <xref linkend=" 3727#~ "\"ST_ClusterIntersecting\"/>" 3728#~ msgstr ", <xref linkend=\"ST_CoveredBy\"/>, <xref linkend=\"ST_Within\"/>" 3729 3730#~ msgid "ST_Contains" 3731#~ msgstr "ST_Contains" 3732 3733#~ msgid "" 3734#~ "<funcdef>boolean <function>ST_Contains</function></funcdef> " 3735#~ "<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 3736#~ "<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef>" 3737#~ msgstr "" 3738#~ "<funcdef>boolean <function>ST_Contains</function></funcdef> " 3739#~ "<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 3740#~ "<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef>" 3741 3742#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.31" 3743#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.31" 3744 3745#~ msgid "<varname>LINESTRING</varname> / <varname>MULTIPOINT</varname>" 3746#~ msgstr "<varname>LINESTRING</varname> / <varname>MULTIPOINT</varname>" 3747 3748#~ msgid "<varname>POLYGON</varname> / <varname>POINT</varname>" 3749#~ msgstr "<varname>POLYGON</varname> / <varname>POINT</varname>" 3750 3751#~ msgid "<varname>POLYGON</varname> / <varname>LINESTRING</varname>" 3752#~ msgstr "<varname>POLYGON</varname> / <varname>LINESTRING</varname>" 3753 3754#~ msgid "<varname>POLYGON</varname> / <varname>POLYGON</varname>" 3755#~ msgstr "<varname>POLYGON</varname> / <varname>POLYGON</varname>" 3756 3757#~ msgid "<varname>POLYGON</varname> / <varname>MULTIPOINT</varname>" 3758#~ msgstr "<varname>POLYGON</varname> / <varname>MULTIPOINT</varname>" 3759 3760#~ msgid "" 3761#~ ", <xref linkend=\"ST_ContainsProperly\"/>, <xref linkend=\"ST_Covers\"/>, " 3762#~ "<xref linkend=\"ST_CoveredBy\"/>, <xref linkend=\"ST_Equals\"/>, <xref " 3763#~ "linkend=\"ST_Within\"/>" 3764#~ msgstr "" 3765#~ ", <xref linkend=\"ST_ContainsProperly\"/>, <xref linkend=\"ST_Covers\"/>, " 3766#~ "<xref linkend=\"ST_CoveredBy\"/>, <xref linkend=\"ST_Equals\"/>, <xref " 3767#~ "linkend=\"ST_Within\"/>" 3768 3769#~ msgid "ST_ContainsProperly" 3770#~ msgstr "ST_ContainsProperly" 3771 3772#~ msgid "" 3773#~ "<funcdef>boolean <function>ST_ContainsProperly</function></funcdef> " 3774#~ "<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 3775#~ "<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef>" 3776#~ msgstr "" 3777#~ "<funcdef>boolean <function>ST_ContainsProperly</function></funcdef> " 3778#~ "<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 3779#~ "<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef>" 3780 3781#~ msgid "" 3782#~ ", <xref linkend=\"ST_Boundary\"/>, <xref linkend=\"ST_Contains\"/>, <xref " 3783#~ "linkend=\"ST_Covers\"/>, <xref linkend=\"ST_CoveredBy\"/>, <xref linkend=" 3784#~ "\"ST_Equals\"/>, <xref linkend=\"ST_Relate\"/>, <xref linkend=\"ST_Within" 3785#~ "\"/>" 3786#~ msgstr "" 3787#~ ", <xref linkend=\"ST_Boundary\"/>, <xref linkend=\"ST_Contains\"/>, <xref " 3788#~ "linkend=\"ST_Covers\"/>, <xref linkend=\"ST_CoveredBy\"/>, <xref linkend=" 3789#~ "\"ST_Equals\"/>, <xref linkend=\"ST_Relate\"/>, <xref linkend=\"ST_Within" 3790#~ "\"/>" 3791 3792#~ msgid "ST_Covers" 3793#~ msgstr "ST_Covers" 3794 3795#~ msgid "" 3796#~ "<funcprototype> <funcdef>boolean <function>ST_Covers</function></funcdef> " 3797#~ "<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 3798#~ "<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef> " 3799#~ "</funcprototype> <funcprototype> <funcdef>boolean <function>ST_Covers</" 3800#~ "function></funcdef> <paramdef><type>geography </type> " 3801#~ "<parameter>geogpolyA</parameter></paramdef> <paramdef><type>geography </" 3802#~ "type> <parameter>geogpointB</parameter></paramdef> </funcprototype>" 3803#~ msgstr "" 3804#~ "<funcprototype> <funcdef>boolean <function>ST_Covers</function></funcdef> " 3805#~ "<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 3806#~ "<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef> " 3807#~ "</funcprototype> <funcprototype> <funcdef>boolean <function>ST_Covers</" 3808#~ "function></funcdef> <paramdef><type>geography </type> " 3809#~ "<parameter>geogpolyA</parameter></paramdef> <paramdef><type>geography </" 3810#~ "type> <parameter>geogpointB</parameter></paramdef> </funcprototype>" 3811 3812#~ msgid "Not an OGC standard, but Oracle has it too." 3813#~ msgstr "Non è uno standard OGC, ma è presente anche in Oracle." 3814 3815#~ msgid ", <xref linkend=\"ST_CoveredBy\"/>, <xref linkend=\"ST_Within\"/>" 3816#~ msgstr ", <xref linkend=\"ST_CoveredBy\"/>, <xref linkend=\"ST_Within\"/>" 3817 3818#~ msgid "ST_CoveredBy" 3819#~ msgstr "ST_CoveredBy" 3820 3821#~ msgid "" 3822#~ "<funcprototype> <funcdef>boolean <function>ST_CoveredBy</function></" 3823#~ "funcdef> <paramdef><type>geometry </type> <parameter>geomA</parameter></" 3824#~ "paramdef> <paramdef><type>geometry </type> <parameter>geomB</parameter></" 3825#~ "paramdef> </funcprototype> <funcprototype> <funcdef>boolean " 3826#~ "<function>ST_CoveredBy</function></funcdef> <paramdef><type>geography </" 3827#~ "type> <parameter>geogA</parameter></paramdef> <paramdef><type>geography </" 3828#~ "type> <parameter>geogB</parameter></paramdef> </funcprototype>" 3829#~ msgstr "" 3830#~ "<funcprototype> <funcdef>boolean <function>ST_CoveredBy</function></" 3831#~ "funcdef> <paramdef><type>geometry </type> <parameter>geomA</parameter></" 3832#~ "paramdef> <paramdef><type>geometry </type> <parameter>geomB</parameter></" 3833#~ "paramdef> </funcprototype> <funcprototype> <funcdef>boolean " 3834#~ "<function>ST_CoveredBy</function></funcdef> <paramdef><type>geography </" 3835#~ "type> <parameter>geogA</parameter></paramdef> <paramdef><type>geography </" 3836#~ "type> <parameter>geogB</parameter></paramdef> </funcprototype>" 3837 3838#~ msgid "" 3839#~ ", <xref linkend=\"ST_Covers\"/>, <xref linkend=\"ST_ExteriorRing\"/>, " 3840#~ "<xref linkend=\"ST_Within\"/>" 3841#~ msgstr "" 3842#~ ", <xref linkend=\"ST_Covers\"/>, <xref linkend=\"ST_ExteriorRing\"/>, " 3843#~ "<xref linkend=\"ST_Within\"/>" 3844 3845#~ msgid "ST_Crosses" 3846#~ msgstr "ST_Crosses" 3847 3848#~ msgid "" 3849#~ "<funcdef>boolean <function>ST_Crosses</function></funcdef> " 3850#~ "<paramdef><type>geometry </type><parameter>g1</parameter></paramdef> " 3851#~ "<paramdef><type>geometry </type><parameter>g2</parameter></paramdef>" 3852#~ msgstr "" 3853#~ "<funcdef>boolean <function>ST_Crosses</function></funcdef> " 3854#~ "<paramdef><type>geometry </type><parameter>g1</parameter></paramdef> " 3855#~ "<paramdef><type>geometry </type><parameter>g2</parameter></paramdef>" 3856 3857#~ msgid "" 3858#~ "<markup>T*T******</markup> (for Point/Line, Point/Area, and Line/Area " 3859#~ "situations)" 3860#~ msgstr "" 3861#~ "<markup>T*T******</markup> (per casi Point/Line, Point/Area, e Line/Area)" 3862 3863#~ msgid "&sfs_compliant; s2.1.13.3" 3864#~ msgstr "&sfs_compliant; s2.1.13.3" 3865 3866#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.29" 3867#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.29" 3868 3869#~ msgid "<varname>MULTIPOINT</varname> / <varname>LINESTRING</varname>" 3870#~ msgstr "<varname>MULTIPOINT</varname> / <varname>LINESTRING</varname>" 3871 3872#~ msgid "<varname>MULTIPOINT</varname> / <varname>POLYGON</varname>" 3873#~ msgstr "<varname>MULTIPOINT</varname> / <varname>POLYGON</varname>" 3874 3875#~ msgid "<varname>LINESTRING</varname> / <varname>POLYGON</varname>" 3876#~ msgstr "<varname>LINESTRING</varname> / <varname>POLYGON</varname>" 3877 3878#~ msgid "<varname>LINESTRING</varname> / <varname>LINESTRING</varname>" 3879#~ msgstr "<varname>LINESTRING</varname> / <varname>LINESTRING</varname>" 3880 3881#~ msgid "" 3882#~ "CREATE TABLE roads (\n" 3883#~ " id serial NOT NULL,\n" 3884#~ " the_geom geometry,\n" 3885#~ " CONSTRAINT roads_pkey PRIMARY KEY (road_id)\n" 3886#~ ");" 3887#~ msgstr "" 3888#~ "CREATE TABLE roads (\n" 3889#~ " id serial NOT NULL,\n" 3890#~ " the_geom geometry,\n" 3891#~ " CONSTRAINT roads_pkey PRIMARY KEY (road_id)\n" 3892#~ ");" 3893 3894#~ msgid "" 3895#~ "CREATE TABLE highways (\n" 3896#~ " id serial NOT NULL,\n" 3897#~ " the_gem geometry,\n" 3898#~ " CONSTRAINT roads_pkey PRIMARY KEY (road_id)\n" 3899#~ ");" 3900#~ msgstr "" 3901#~ "CREATE TABLE highways (\n" 3902#~ " id serial NOT NULL,\n" 3903#~ " the_gem geometry,\n" 3904#~ " CONSTRAINT roads_pkey PRIMARY KEY (road_id)\n" 3905#~ ");" 3906 3907#~ msgid "" 3908#~ "SELECT roads.id\n" 3909#~ "FROM roads, highways\n" 3910#~ "WHERE ST_Crosses(roads.the_geom, highways.the_geom);" 3911#~ msgstr "" 3912#~ "SELECT roads.id\n" 3913#~ "FROM roads, highways\n" 3914#~ "WHERE ST_Crosses(roads.the_geom, highways.the_geom);" 3915 3916#~ msgid "ST_LineCrossingDirection" 3917#~ msgstr "ST_LineCrossingDirection" 3918 3919#~ msgid "" 3920#~ "<funcdef>integer <function>ST_LineCrossingDirection</function></funcdef> " 3921#~ "<paramdef><type>geometry </type> <parameter>linestringA</parameter></" 3922#~ "paramdef> <paramdef><type>geometry </type> <parameter>linestringB</" 3923#~ "parameter></paramdef>" 3924#~ msgstr "" 3925#~ "<funcdef>integer <function>ST_LineCrossingDirection</function></funcdef> " 3926#~ "<paramdef><type>geometry </type> <parameter>linestringA</parameter></" 3927#~ "paramdef> <paramdef><type>geometry </type> <parameter>linestringB</" 3928#~ "parameter></paramdef>" 3929 3930#~ msgid "Availability: 1.4" 3931#~ msgstr "Disponibilità: 1.4.0" 3932 3933#~ msgid "" 3934#~ "SELECT ST_LineCrossingDirection(foo.line1, foo.line2) As l1_cross_l2 ,\n" 3935#~ " ST_LineCrossingDirection(foo.line2, foo.line1) As l2_cross_l1\n" 3936#~ "FROM (\n" 3937#~ "SELECT\n" 3938#~ " ST_GeomFromText('LINESTRING(25 169,89 114,40 70,86 43)') As line1,\n" 3939#~ " ST_GeomFromText('LINESTRING(171 154,20 140,71 74,161 53)') As line2\n" 3940#~ " ) As foo;\n" 3941#~ "\n" 3942#~ " l1_cross_l2 | l2_cross_l1\n" 3943#~ "-------------+-------------\n" 3944#~ " 3 | -3" 3945#~ msgstr "" 3946#~ "SELECT ST_LineCrossingDirection(foo.line1, foo.line2) As l1_cross_l2 ,\n" 3947#~ " ST_LineCrossingDirection(foo.line2, foo.line1) As l2_cross_l1\n" 3948#~ "FROM (\n" 3949#~ "SELECT\n" 3950#~ " ST_GeomFromText('LINESTRING(25 169,89 114,40 70,86 43)') As line1,\n" 3951#~ " ST_GeomFromText('LINESTRING(171 154,20 140,71 74,161 53)') As line2\n" 3952#~ " ) As foo;\n" 3953#~ "\n" 3954#~ " l1_cross_l2 | l2_cross_l1\n" 3955#~ "-------------+-------------\n" 3956#~ " 3 | -3" 3957 3958#~ msgid "" 3959#~ "SELECT ST_LineCrossingDirection(foo.line1, foo.line2) As l1_cross_l2 ,\n" 3960#~ " ST_LineCrossingDirection(foo.line2, foo.line1) As l2_cross_l1\n" 3961#~ "FROM (\n" 3962#~ " SELECT\n" 3963#~ " ST_GeomFromText('LINESTRING(25 169,89 114,40 70,86 43)') As line1,\n" 3964#~ " ST_GeomFromText('LINESTRING (171 154, 20 140, 71 74, 2.99 90.16)') As " 3965#~ "line2\n" 3966#~ ") As foo;\n" 3967#~ "\n" 3968#~ " l1_cross_l2 | l2_cross_l1\n" 3969#~ "-------------+-------------\n" 3970#~ " 2 | -2" 3971#~ msgstr "" 3972#~ "SELECT ST_LineCrossingDirection(foo.line1, foo.line2) As l1_cross_l2 ,\n" 3973#~ " ST_LineCrossingDirection(foo.line2, foo.line1) As l2_cross_l1\n" 3974#~ "FROM (\n" 3975#~ " SELECT\n" 3976#~ " ST_GeomFromText('LINESTRING(25 169,89 114,40 70,86 43)') As line1,\n" 3977#~ " ST_GeomFromText('LINESTRING (171 154, 20 140, 71 74, 2.99 90.16)') As " 3978#~ "line2\n" 3979#~ ") As foo;\n" 3980#~ "\n" 3981#~ " l1_cross_l2 | l2_cross_l1\n" 3982#~ "-------------+-------------\n" 3983#~ " 2 | -2" 3984 3985#~ msgid "" 3986#~ "SELECT\n" 3987#~ " ST_LineCrossingDirection(foo.line1, foo.line2) As l1_cross_l2 ,\n" 3988#~ " ST_LineCrossingDirection(foo.line2, foo.line1) As l2_cross_l1\n" 3989#~ "FROM (\n" 3990#~ " SELECT\n" 3991#~ " ST_GeomFromText('LINESTRING(25 169,89 114,40 70,86 43)') As line1,\n" 3992#~ " ST_GeomFromText('LINESTRING (20 140, 71 74, 161 53)') As line2\n" 3993#~ " ) As foo;\n" 3994#~ "\n" 3995#~ " l1_cross_l2 | l2_cross_l1\n" 3996#~ "-------------+-------------\n" 3997#~ " -1 | 1" 3998#~ msgstr "" 3999#~ "SELECT\n" 4000#~ " ST_LineCrossingDirection(foo.line1, foo.line2) As l1_cross_l2 ,\n" 4001#~ " ST_LineCrossingDirection(foo.line2, foo.line1) As l2_cross_l1\n" 4002#~ "FROM (\n" 4003#~ " SELECT\n" 4004#~ " ST_GeomFromText('LINESTRING(25 169,89 114,40 70,86 43)') As line1,\n" 4005#~ " ST_GeomFromText('LINESTRING (20 140, 71 74, 161 53)') As line2\n" 4006#~ " ) As foo;\n" 4007#~ "\n" 4008#~ " l1_cross_l2 | l2_cross_l1\n" 4009#~ "-------------+-------------\n" 4010#~ " -1 | 1" 4011 4012#~ msgid "" 4013#~ "SELECT ST_LineCrossingDirection(foo.line1, foo.line2) As l1_cross_l2 ,\n" 4014#~ " ST_LineCrossingDirection(foo.line2, foo.line1) As l2_cross_l1\n" 4015#~ "FROM (SELECT\n" 4016#~ " ST_GeomFromText('LINESTRING(25 169,89 114,40 70,86 43)') As " 4017#~ "line1,\n" 4018#~ " ST_GeomFromText('LINESTRING(2.99 90.16,71 74,20 140,171 154)') As " 4019#~ "line2\n" 4020#~ " ) As foo;\n" 4021#~ "\n" 4022#~ " l1_cross_l2 | l2_cross_l1\n" 4023#~ "-------------+-------------\n" 4024#~ " -2 | 2" 4025#~ msgstr "" 4026#~ "SELECT ST_LineCrossingDirection(foo.line1, foo.line2) As l1_cross_l2 ,\n" 4027#~ " ST_LineCrossingDirection(foo.line2, foo.line1) As l2_cross_l1\n" 4028#~ "FROM (SELECT\n" 4029#~ " ST_GeomFromText('LINESTRING(25 169,89 114,40 70,86 43)') As " 4030#~ "line1,\n" 4031#~ " ST_GeomFromText('LINESTRING(2.99 90.16,71 74,20 140,171 154)') As " 4032#~ "line2\n" 4033#~ " ) As foo;\n" 4034#~ "\n" 4035#~ " l1_cross_l2 | l2_cross_l1\n" 4036#~ "-------------+-------------\n" 4037#~ " -2 | 2" 4038 4039#~ msgid "" 4040#~ "SELECT s1.gid, s2.gid, ST_LineCrossingDirection(s1.the_geom, s2." 4041#~ "the_geom)\n" 4042#~ " FROM streets s1 CROSS JOIN streets s2 ON (s1.gid != s2.gid AND s1." 4043#~ "the_geom && s2.the_geom )\n" 4044#~ "WHERE ST_CrossingDirection(s1.the_geom, s2.the_geom) > 0;" 4045#~ msgstr "" 4046#~ "SELECT s1.gid, s2.gid, ST_LineCrossingDirection(s1.the_geom, s2." 4047#~ "the_geom)\n" 4048#~ " FROM streets s1 CROSS JOIN streets s2 ON (s1.gid != s2.gid AND s1." 4049#~ "the_geom && s2.the_geom )\n" 4050#~ "WHERE ST_CrossingDirection(s1.the_geom, s2.the_geom) > 0;" 4051 4052#~ msgid "ST_Disjoint" 4053#~ msgstr "ST_Disjoint" 4054 4055#~ msgid "" 4056#~ "<funcdef>boolean <function>ST_Disjoint</function></funcdef> <paramdef> " 4057#~ "<type>geometry</type> <parameter>A</parameter> </paramdef> <paramdef> " 4058#~ "<type>geometry</type> <parameter>B</parameter> </paramdef>" 4059#~ msgstr "" 4060#~ "<funcdef>boolean <function>ST_Disjoint</function></funcdef> <paramdef> " 4061#~ "<type>geometry</type> <parameter>A</parameter> </paramdef> <paramdef> " 4062#~ "<type>geometry</type> <parameter>B</parameter> </paramdef>" 4063 4064#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.26" 4065#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.26" 4066 4067#~ msgid "" 4068#~ "SELECT ST_Disjoint('POINT(0 0)'::geometry, 'LINESTRING ( 2 0, 0 2 )'::" 4069#~ "geometry);\n" 4070#~ " st_disjoint\n" 4071#~ "---------------\n" 4072#~ " t\n" 4073#~ "(1 row)\n" 4074#~ "SELECT ST_Disjoint('POINT(0 0)'::geometry, 'LINESTRING ( 0 0, 0 2 )'::" 4075#~ "geometry);\n" 4076#~ " st_disjoint\n" 4077#~ "---------------\n" 4078#~ " f\n" 4079#~ "(1 row)" 4080#~ msgstr "" 4081#~ "SELECT ST_Disjoint('POINT(0 0)'::geometry, 'LINESTRING ( 2 0, 0 2 )'::" 4082#~ "geometry);\n" 4083#~ " st_disjoint\n" 4084#~ "---------------\n" 4085#~ " t\n" 4086#~ "(1 row)\n" 4087#~ "SELECT ST_Disjoint('POINT(0 0)'::geometry, 'LINESTRING ( 0 0, 0 2 )'::" 4088#~ "geometry);\n" 4089#~ " st_disjoint\n" 4090#~ "---------------\n" 4091#~ " f\n" 4092#~ "(1 row)" 4093 4094#~ msgid "" 4095#~ "<funcprototype> <funcdef>float <function>ST_Distance</function></funcdef> " 4096#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 4097#~ "<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> </" 4098#~ "funcprototype> <funcprototype> <funcdef>float <function>ST_Distance</" 4099#~ "function></funcdef> <paramdef><type>geography </type> <parameter>gg1</" 4100#~ "parameter></paramdef> <paramdef><type>geography </type> <parameter>gg2</" 4101#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>float " 4102#~ "<function>ST_Distance</function></funcdef> <paramdef><type>geography </" 4103#~ "type> <parameter>gg1</parameter></paramdef> <paramdef><type>geography </" 4104#~ "type> <parameter>gg2</parameter></paramdef> <paramdef><type>boolean </" 4105#~ "type> <parameter>use_spheroid</parameter></paramdef> </funcprototype>" 4106#~ msgstr "" 4107#~ "<funcprototype> <funcdef>float <function>ST_Distance</function></funcdef> " 4108#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 4109#~ "<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> </" 4110#~ "funcprototype> <funcprototype> <funcdef>float <function>ST_Distance</" 4111#~ "function></funcdef> <paramdef><type>geography </type> <parameter>gg1</" 4112#~ "parameter></paramdef> <paramdef><type>geography </type> <parameter>gg2</" 4113#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>float " 4114#~ "<function>ST_Distance</function></funcdef> <paramdef><type>geography </" 4115#~ "type> <parameter>gg1</parameter></paramdef> <paramdef><type>geography </" 4116#~ "type> <parameter>gg2</parameter></paramdef> <paramdef><type>boolean </" 4117#~ "type> <parameter>use_spheroid</parameter></paramdef> </funcprototype>" 4118 4119#~ msgid "ST_DFullyWithin" 4120#~ msgstr "ST_DFullyWithin" 4121 4122#~ msgid "" 4123#~ "<funcdef>boolean <function>ST_DFullyWithin</function></funcdef> " 4124#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 4125#~ "<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> " 4126#~ "<paramdef><type>double precision </type> <parameter>distance</parameter></" 4127#~ "paramdef>" 4128#~ msgstr "" 4129#~ "<funcdef>boolean <function>ST_DFullyWithin</function></funcdef> " 4130#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 4131#~ "<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> " 4132#~ "<paramdef><type>double precision </type> <parameter>distance</parameter></" 4133#~ "paramdef>" 4134 4135#, fuzzy 4136#~ msgid "" 4137#~ "postgis=# SELECT ST_DFullyWithin(geom_a, geom_b, 10) as DFullyWithin10, " 4138#~ "ST_DWithin(geom_a, geom_b, 10) as DWithin10, ST_DFullyWithin(geom_a, " 4139#~ "geom_b, 20) as DFullyWithin20 from\n" 4140#~ " (select ST_GeomFromText('POINT(1 1)') as geom_a," 4141#~ "ST_GeomFromText('LINESTRING(1 5, 2 7, 1 9, 14 12)') as geom_b) t1;\n" 4142#~ "\n" 4143#~ "-----------------\n" 4144#~ " DFullyWithin10 | DWithin10 | DFullyWithin20 |\n" 4145#~ "---------------+----------+---------------+\n" 4146#~ " f | t | t |" 4147#~ msgstr "" 4148#~ "postgis=# SELECT ST_DFullyWithin(geom_a, geom_b, 10) as DFullyWithin10, " 4149#~ "ST_DWithin(geom_a, geom_b, 10) as DWithin10, ST_DFullyWithin(geom_a, " 4150#~ "geom_b, 20) as DFullyWithin20 from \n" 4151#~ " (select ST_GeomFromText('POINT(1 1)') as geom_a," 4152#~ "ST_GeomFromText('LINESTRING(1 5, 2 7, 1 9, 14 12)') as geom_b) t1;\n" 4153#~ " \n" 4154#~ "-----------------\n" 4155#~ " DFullyWithin10 | DWithin10 | DFullyWithin20 |\n" 4156#~ "---------------+----------+---------------+\n" 4157#~ " f | t | t |" 4158 4159#~ msgid ", <xref linkend=\"ST_DWithin\"/>" 4160#~ msgstr ", <xref linkend=\"ST_DWithin\"/>" 4161 4162#~ msgid "ST_DWithin" 4163#~ msgstr "ST_DWithin" 4164 4165#~ msgid "" 4166#~ "<funcprototype> <funcdef>boolean <function>ST_DWithin</function></" 4167#~ "funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></" 4168#~ "paramdef> <paramdef><type>geometry </type> <parameter>g2</parameter></" 4169#~ "paramdef> <paramdef><type>double precision </type> " 4170#~ "<parameter>distance_of_srid</parameter></paramdef> </funcprototype> " 4171#~ "<funcprototype> <funcdef>boolean <function>ST_DWithin</function></" 4172#~ "funcdef> <paramdef><type>geography </type> <parameter>gg1</parameter></" 4173#~ "paramdef> <paramdef><type>geography </type> <parameter>gg2</parameter></" 4174#~ "paramdef> <paramdef><type>double precision </type> " 4175#~ "<parameter>distance_meters</parameter></paramdef> </funcprototype> " 4176#~ "<funcprototype> <funcdef>boolean <function>ST_DWithin</function></" 4177#~ "funcdef> <paramdef><type>geography </type> <parameter>gg1</parameter></" 4178#~ "paramdef> <paramdef><type>geography </type> <parameter>gg2</parameter></" 4179#~ "paramdef> <paramdef><type>double precision </type> " 4180#~ "<parameter>distance_meters</parameter></paramdef> <paramdef><type>boolean " 4181#~ "</type> <parameter>use_spheroid</parameter></paramdef> </funcprototype>" 4182#~ msgstr "" 4183#~ "<funcprototype> <funcdef>boolean <function>ST_DWithin</function></" 4184#~ "funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></" 4185#~ "paramdef> <paramdef><type>geometry </type> <parameter>g2</parameter></" 4186#~ "paramdef> <paramdef><type>double precision </type> " 4187#~ "<parameter>distance_of_srid</parameter></paramdef> </funcprototype> " 4188#~ "<funcprototype> <funcdef>boolean <function>ST_DWithin</function></" 4189#~ "funcdef> <paramdef><type>geography </type> <parameter>gg1</parameter></" 4190#~ "paramdef> <paramdef><type>geography </type> <parameter>gg2</parameter></" 4191#~ "paramdef> <paramdef><type>double precision </type> " 4192#~ "<parameter>distance_meters</parameter></paramdef> </funcprototype> " 4193#~ "<funcprototype> <funcdef>boolean <function>ST_DWithin</function></" 4194#~ "funcdef> <paramdef><type>geography </type> <parameter>gg1</parameter></" 4195#~ "paramdef> <paramdef><type>geography </type> <parameter>gg2</parameter></" 4196#~ "paramdef> <paramdef><type>double precision </type> " 4197#~ "<parameter>distance_meters</parameter></paramdef> <paramdef><type>boolean " 4198#~ "</type> <parameter>use_spheroid</parameter></paramdef> </funcprototype>" 4199 4200#, fuzzy 4201#~ msgid ", <xref linkend=\"ST_Expand\"/>, <xref linkend=\"ST_3DDWithin\"/>" 4202#~ msgstr ", <xref linkend=\"ST_CoveredBy\"/>, <xref linkend=\"ST_Within\"/>" 4203 4204#~ msgid "ST_Equals" 4205#~ msgstr "ST_Equals" 4206 4207#~ msgid "" 4208#~ "<funcdef>boolean <function>ST_Equals</function></funcdef> " 4209#~ "<paramdef><type>geometry </type> <parameter>A</parameter></paramdef> " 4210#~ "<paramdef><type>geometry </type> <parameter>B</parameter></paramdef>" 4211#~ msgstr "" 4212#~ "<funcdef>boolean <function>ST_Equals</function></funcdef> " 4213#~ "<paramdef><type>geometry </type> <parameter>A</parameter></paramdef> " 4214#~ "<paramdef><type>geometry </type> <parameter>B</parameter></paramdef>" 4215 4216#~ msgid "&sfs_compliant; s2.1.1.2" 4217#~ msgstr "&sfs_compliant; s2.1.1.2" 4218 4219#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.24" 4220#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.24" 4221 4222#~ msgid "" 4223#~ "SELECT ST_Equals(ST_GeomFromText('LINESTRING(0 0, 10 10)'),\n" 4224#~ " ST_GeomFromText('LINESTRING(0 0, 5 5, 10 10)'));\n" 4225#~ " st_equals\n" 4226#~ "-----------\n" 4227#~ " t\n" 4228#~ "(1 row)\n" 4229#~ "\n" 4230#~ "SELECT ST_Equals(ST_Reverse(ST_GeomFromText('LINESTRING(0 0, 10 10)')),\n" 4231#~ " ST_GeomFromText('LINESTRING(0 0, 5 5, 10 10)'));\n" 4232#~ " st_equals\n" 4233#~ "-----------\n" 4234#~ " t\n" 4235#~ "(1 row)" 4236#~ msgstr "" 4237#~ "SELECT ST_Equals(ST_GeomFromText('LINESTRING(0 0, 10 10)'),\n" 4238#~ " ST_GeomFromText('LINESTRING(0 0, 5 5, 10 10)'));\n" 4239#~ " st_equals\n" 4240#~ "-----------\n" 4241#~ " t\n" 4242#~ "(1 row)\n" 4243#~ "\n" 4244#~ "SELECT ST_Equals(ST_Reverse(ST_GeomFromText('LINESTRING(0 0, 10 10)')),\n" 4245#~ " ST_GeomFromText('LINESTRING(0 0, 5 5, 10 10)'));\n" 4246#~ " st_equals\n" 4247#~ "-----------\n" 4248#~ " t\n" 4249#~ "(1 row)" 4250 4251#~ msgid "" 4252#~ ", <xref linkend=\"ST_OrderingEquals\"/>, <xref linkend=\"ST_Reverse\"/>, " 4253#~ "<xref linkend=\"ST_Within\"/>" 4254#~ msgstr "" 4255#~ ", <xref linkend=\"ST_OrderingEquals\"/>, <xref linkend=\"ST_Reverse\"/>, " 4256#~ "<xref linkend=\"ST_Within\"/>" 4257 4258#, fuzzy 4259#~ msgid "" 4260#~ "<funcdef>geometry <function> ST_GeometricMedian </function> </funcdef> " 4261#~ "<paramdef> <type> geometry </type> <parameter> g </parameter> </paramdef> " 4262#~ "<paramdef> <type> float8 </type> <parameter> tolerance </parameter> </" 4263#~ "paramdef> <paramdef> <type> int </type> <parameter> max_iter </parameter> " 4264#~ "</paramdef> <paramdef> <type> boolean </type> <parameter> " 4265#~ "fail_if_not_converged </parameter> </paramdef>" 4266#~ msgstr "" 4267#~ "<funcdef>geography <function>ST_Project</function></funcdef> " 4268#~ "<paramdef><type>geography </type> <parameter>g1</parameter></paramdef> " 4269#~ "<paramdef><type>float </type> <parameter>distance</parameter></paramdef> " 4270#~ "<paramdef><type>float </type> <parameter>azimuth</parameter></paramdef>" 4271 4272#, fuzzy 4273#~ msgid "&M_support;" 4274#~ msgstr "&Z_support;" 4275 4276#~ msgid "" 4277#~ "<funcdef>boolean <function>ST_HasArc</function></funcdef> " 4278#~ "<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 4279#~ msgstr "" 4280#~ "<funcdef>boolean <function>ST_HasArc</function></funcdef> " 4281#~ "<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 4282 4283#~ msgid "" 4284#~ "SELECT ST_HasArc(ST_Collect('LINESTRING(1 2, 3 4, 5 6)', " 4285#~ "'CIRCULARSTRING(1 1, 2 3, 4 5, 6 7, 5 6)'));\n" 4286#~ " st_hasarc\n" 4287#~ " --------\n" 4288#~ " t" 4289#~ msgstr "" 4290#~ "SELECT ST_HasArc(ST_Collect('LINESTRING(1 2, 3 4, 5 6)', " 4291#~ "'CIRCULARSTRING(1 1, 2 3, 4 5, 6 7, 5 6)'));\n" 4292#~ " st_hasarc\n" 4293#~ " --------\n" 4294#~ " t" 4295 4296#~ msgid ", <xref linkend=\"ST_LineToCurve\"/>" 4297#~ msgstr ", <xref linkend=\"ST_LineToCurve\"/>" 4298 4299#, fuzzy 4300#~ msgid "ST_Intersects" 4301#~ msgstr "ST_3DIntersects" 4302 4303#~ msgid "" 4304#~ "<funcprototype> <funcdef>boolean <function>ST_Intersects</function></" 4305#~ "funcdef> <paramdef> <type>geometry</type> <parameter>geomA</parameter> </" 4306#~ "paramdef> <paramdef> <type>geometry</type> <parameter>geomB</parameter> </" 4307#~ "paramdef> </funcprototype> <funcprototype> <funcdef>boolean " 4308#~ "<function>ST_Intersects</function></funcdef> <paramdef> <type>geography</" 4309#~ "type> <parameter>geogA</parameter> </paramdef> <paramdef> " 4310#~ "<type>geography</type> <parameter>geogB</parameter> </paramdef> </" 4311#~ "funcprototype>" 4312#~ msgstr "" 4313#~ "<funcprototype> <funcdef>boolean <function>ST_Intersects</function></" 4314#~ "funcdef> <paramdef> <type>geometry</type> <parameter>geomA</parameter> </" 4315#~ "paramdef> <paramdef> <type>geometry</type> <parameter>geomB</parameter> </" 4316#~ "paramdef> </funcprototype> <funcprototype> <funcdef>boolean " 4317#~ "<function>ST_Intersects</function></funcdef> <paramdef> <type>geography</" 4318#~ "type> <parameter>geogA</parameter> </paramdef> <paramdef> " 4319#~ "<type>geography</type> <parameter>geogB</parameter> </paramdef> </" 4320#~ "funcprototype>" 4321 4322#~ msgid "" 4323#~ "&sfs_compliant; s2.1.1.2 //s2.1.13.3 - ST_Intersects(g1, g2 ) --> Not " 4324#~ "(ST_Disjoint(g1, g2 ))" 4325#~ msgstr "" 4326#~ "&sfs_compliant; s2.1.1.2 //s2.1.13.3 - ST_Intersects(g1, g2 ) --> Not " 4327#~ "(ST_Disjoint(g1, g2 ))" 4328 4329#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.27" 4330#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.27" 4331 4332#~ msgid "" 4333#~ "SELECT ST_Intersects('POINT(0 0)'::geometry, 'LINESTRING ( 2 0, 0 2 )'::" 4334#~ "geometry);\n" 4335#~ " st_intersects\n" 4336#~ "---------------\n" 4337#~ " f\n" 4338#~ "(1 row)\n" 4339#~ "SELECT ST_Intersects('POINT(0 0)'::geometry, 'LINESTRING ( 0 0, 0 2 )'::" 4340#~ "geometry);\n" 4341#~ " st_intersects\n" 4342#~ "---------------\n" 4343#~ " t\n" 4344#~ "(1 row)" 4345#~ msgstr "" 4346#~ "SELECT ST_Intersects('POINT(0 0)'::geometry, 'LINESTRING ( 2 0, 0 2 )'::" 4347#~ "geometry);\n" 4348#~ " st_intersects\n" 4349#~ "---------------\n" 4350#~ " f\n" 4351#~ "(1 row)\n" 4352#~ "SELECT ST_Intersects('POINT(0 0)'::geometry, 'LINESTRING ( 0 0, 0 2 )'::" 4353#~ "geometry);\n" 4354#~ " st_intersects\n" 4355#~ "---------------\n" 4356#~ " t\n" 4357#~ "(1 row)" 4358 4359#~ msgid ", <xref linkend=\"ST_Disjoint\"/>" 4360#~ msgstr ", <xref linkend=\"ST_Disjoint\"/>" 4361 4362#~ msgid "ST_Length2D_Spheroid" 4363#~ msgstr "ST_Length2D_Spheroid" 4364 4365#, fuzzy 4366#~ msgid "" 4367#~ "<funcdef>float <function>ST_Length2D_Spheroid</function></funcdef> " 4368#~ "<paramdef><type>geometry </type> <parameter>a_geometry</parameter></" 4369#~ "paramdef> <paramdef><type>spheroid </type> <parameter>a_spheroid</" 4370#~ "parameter></paramdef>" 4371#~ msgstr "" 4372#~ "<funcdef>boolean <function>ST_Contains</function></funcdef> " 4373#~ "<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 4374#~ "<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef>" 4375 4376#~ msgid "ST_OrderingEquals" 4377#~ msgstr "ST_OrderingEquals" 4378 4379#~ msgid "" 4380#~ "<funcdef>boolean <function>ST_OrderingEquals</function></funcdef> " 4381#~ "<paramdef><type>geometry </type> <parameter>A</parameter></paramdef> " 4382#~ "<paramdef><type>geometry </type> <parameter>B</parameter></paramdef>" 4383#~ msgstr "" 4384#~ "<funcdef>boolean <function>ST_OrderingEquals</function></funcdef> " 4385#~ "<paramdef><type>geometry </type> <parameter>A</parameter></paramdef> " 4386#~ "<paramdef><type>geometry </type> <parameter>B</parameter></paramdef>" 4387 4388#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.43" 4389#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.43" 4390 4391#~ msgid "" 4392#~ "SELECT ST_OrderingEquals(ST_GeomFromText('LINESTRING(0 0, 10 10)'),\n" 4393#~ " ST_GeomFromText('LINESTRING(0 0, 5 5, 10 10)'));\n" 4394#~ " st_orderingequals\n" 4395#~ "-----------\n" 4396#~ " f\n" 4397#~ "(1 row)\n" 4398#~ "\n" 4399#~ "SELECT ST_OrderingEquals(ST_GeomFromText('LINESTRING(0 0, 10 10)'),\n" 4400#~ " ST_GeomFromText('LINESTRING(0 0, 0 0, 10 10)'));\n" 4401#~ " st_orderingequals\n" 4402#~ "-----------\n" 4403#~ " t\n" 4404#~ "(1 row)\n" 4405#~ "\n" 4406#~ "SELECT ST_OrderingEquals(ST_Reverse(ST_GeomFromText('LINESTRING(0 0, 10 " 4407#~ "10)')),\n" 4408#~ " ST_GeomFromText('LINESTRING(0 0, 0 0, 10 10)'));\n" 4409#~ " st_orderingequals\n" 4410#~ "-----------\n" 4411#~ " f\n" 4412#~ "(1 row)" 4413#~ msgstr "" 4414#~ "SELECT ST_OrderingEquals(ST_GeomFromText('LINESTRING(0 0, 10 10)'),\n" 4415#~ " ST_GeomFromText('LINESTRING(0 0, 5 5, 10 10)'));\n" 4416#~ " st_orderingequals\n" 4417#~ "-----------\n" 4418#~ " f\n" 4419#~ "(1 row)\n" 4420#~ "\n" 4421#~ "SELECT ST_OrderingEquals(ST_GeomFromText('LINESTRING(0 0, 10 10)'),\n" 4422#~ " ST_GeomFromText('LINESTRING(0 0, 0 0, 10 10)'));\n" 4423#~ " st_orderingequals\n" 4424#~ "-----------\n" 4425#~ " t\n" 4426#~ "(1 row)\n" 4427#~ "\n" 4428#~ "SELECT ST_OrderingEquals(ST_Reverse(ST_GeomFromText('LINESTRING(0 0, 10 " 4429#~ "10)')),\n" 4430#~ " ST_GeomFromText('LINESTRING(0 0, 0 0, 10 10)'));\n" 4431#~ " st_orderingequals\n" 4432#~ "-----------\n" 4433#~ " f\n" 4434#~ "(1 row)" 4435 4436#~ msgid ", <xref linkend=\"ST_Reverse\"/>" 4437#~ msgstr ", <xref linkend=\"ST_Reverse\"/>" 4438 4439#~ msgid "ST_Overlaps" 4440#~ msgstr "ST_Overlaps" 4441 4442#~ msgid "" 4443#~ "<funcdef>boolean <function>ST_Overlaps</function></funcdef> " 4444#~ "<paramdef><type>geometry </type> <parameter>A</parameter></paramdef> " 4445#~ "<paramdef><type>geometry </type> <parameter>B</parameter></paramdef>" 4446#~ msgstr "" 4447#~ "<funcdef>boolean <function>ST_Overlaps</function></funcdef> " 4448#~ "<paramdef><type>geometry </type> <parameter>A</parameter></paramdef> " 4449#~ "<paramdef><type>geometry </type> <parameter>B</parameter></paramdef>" 4450 4451#~ msgid "&sfs_compliant; s2.1.1.2 // s2.1.13.3" 4452#~ msgstr "&sfs_compliant; s2.1.1.2 // s2.1.13.3" 4453 4454#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.32" 4455#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.32" 4456 4457#~ msgid "<varname>MULTIPOINT</varname> / <varname>MULTIPOINT</varname>" 4458#~ msgstr "<varname>MULTIPOINT</varname> / <varname>MULTIPOINT</varname>" 4459 4460#~ msgid "ST_PointOnSurface" 4461#~ msgstr "ST_PointOnSurface" 4462 4463#~ msgid "" 4464#~ "<funcdef>geometry <function>ST_PointOnSurface</function></funcdef> " 4465#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 4466#~ msgstr "" 4467#~ "<funcdef>geometry <function>ST_PointOnSurface</function></funcdef> " 4468#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 4469 4470#~ msgid "" 4471#~ "SELECT ST_AsText(ST_PointOnSurface('POINT(0 5)'::geometry));\n" 4472#~ " st_astext\n" 4473#~ "------------\n" 4474#~ " POINT(0 5)\n" 4475#~ "(1 row)\n" 4476#~ "\n" 4477#~ "SELECT ST_AsText(ST_PointOnSurface('LINESTRING(0 5, 0 10)'::geometry));\n" 4478#~ " st_astext\n" 4479#~ "------------\n" 4480#~ " POINT(0 5)\n" 4481#~ "(1 row)\n" 4482#~ "\n" 4483#~ "SELECT ST_AsText(ST_PointOnSurface('POLYGON((0 0, 0 5, 5 5, 5 0, 0 0))'::" 4484#~ "geometry));\n" 4485#~ " st_astext\n" 4486#~ "----------------\n" 4487#~ " POINT(2.5 2.5)\n" 4488#~ "(1 row)\n" 4489#~ "\n" 4490#~ "SELECT ST_AsEWKT(ST_PointOnSurface(ST_GeomFromEWKT('LINESTRING(0 5 1, 0 0 " 4491#~ "1, 0 10 2)')));\n" 4492#~ " st_asewkt\n" 4493#~ "----------------\n" 4494#~ " POINT(0 0 1)\n" 4495#~ "(1 row)" 4496#~ msgstr "" 4497#~ "SELECT ST_AsText(ST_PointOnSurface('POINT(0 5)'::geometry));\n" 4498#~ " st_astext\n" 4499#~ "------------\n" 4500#~ " POINT(0 5)\n" 4501#~ "(1 row)\n" 4502#~ "\n" 4503#~ "SELECT ST_AsText(ST_PointOnSurface('LINESTRING(0 5, 0 10)'::geometry));\n" 4504#~ " st_astext\n" 4505#~ "------------\n" 4506#~ " POINT(0 5)\n" 4507#~ "(1 row)\n" 4508#~ "\n" 4509#~ "SELECT ST_AsText(ST_PointOnSurface('POLYGON((0 0, 0 5, 5 5, 5 0, 0 0))'::" 4510#~ "geometry));\n" 4511#~ " st_astext\n" 4512#~ "----------------\n" 4513#~ " POINT(2.5 2.5)\n" 4514#~ "(1 row)\n" 4515#~ "\n" 4516#~ "SELECT ST_AsEWKT(ST_PointOnSurface(ST_GeomFromEWKT('LINESTRING(0 5 1, 0 0 " 4517#~ "1, 0 10 2)')));\n" 4518#~ " st_asewkt\n" 4519#~ "----------------\n" 4520#~ " POINT(0 0 1)\n" 4521#~ "(1 row)" 4522 4523#~ msgid ", <xref linkend=\"ST_Point_Inside_Circle\"/>" 4524#~ msgstr ", <xref linkend=\"ST_Point_Inside_Circle\"/>" 4525 4526#~ msgid "ST_Relate" 4527#~ msgstr "ST_Relate" 4528 4529#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.25" 4530#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.25" 4531 4532#~ msgid "" 4533#~ ", <xref linkend=\"DE-9IM\"/>, <xref linkend=\"ST_Disjoint\"/>, <xref " 4534#~ "linkend=\"ST_Intersects\"/>, <xref linkend=\"ST_Touches\"/>" 4535#~ msgstr "" 4536#~ ", <xref linkend=\"DE-9IM\"/>, <xref linkend=\"ST_Disjoint\"/>, <xref " 4537#~ "linkend=\"ST_Intersects\"/>, <xref linkend=\"ST_Touches\"/>" 4538 4539#~ msgid "ST_RelateMatch" 4540#~ msgstr "ST_RelateMatch" 4541 4542#~ msgid "" 4543#~ "<funcdef>boolean <function>ST_RelateMatch</function></funcdef> " 4544#~ "<paramdef><type>text </type> <parameter>intersectionMatrix</parameter></" 4545#~ "paramdef> <paramdef><type>text </type> " 4546#~ "<parameter>intersectionMatrixPattern</parameter></paramdef>" 4547#~ msgstr "" 4548#~ "<funcdef>boolean <function>ST_RelateMatch</function></funcdef> " 4549#~ "<paramdef><type>text </type> <parameter>intersectionMatrix</parameter></" 4550#~ "paramdef> <paramdef><type>text </type> " 4551#~ "<parameter>intersectionMatrixPattern</parameter></paramdef>" 4552 4553#~ msgid ", <xref linkend=\"ST_Relate\"/>" 4554#~ msgstr ", <xref linkend=\"ST_Relate\"/>" 4555 4556#~ msgid "ST_Touches" 4557#~ msgstr "ST_Touches" 4558 4559#~ msgid "" 4560#~ "<funcdef>boolean <function>ST_Touches</function></funcdef> " 4561#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 4562#~ "<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 4563#~ msgstr "" 4564#~ "<funcdef>boolean <function>ST_Touches</function></funcdef> " 4565#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> " 4566#~ "<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>" 4567 4568#~ msgid "FT*******" 4569#~ msgstr "FT*******" 4570 4571#~ msgid "F**T*****" 4572#~ msgstr "F**T*****" 4573 4574#~ msgid "F***T****" 4575#~ msgstr "F***T****" 4576 4577#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.28" 4578#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.28" 4579 4580#~ msgid "" 4581#~ "SELECT ST_Touches('LINESTRING(0 0, 1 1, 0 2)'::geometry, 'POINT(1 1)'::" 4582#~ "geometry);\n" 4583#~ " st_touches\n" 4584#~ "------------\n" 4585#~ " f\n" 4586#~ "(1 row)\n" 4587#~ "\n" 4588#~ "SELECT ST_Touches('LINESTRING(0 0, 1 1, 0 2)'::geometry, 'POINT(0 2)'::" 4589#~ "geometry);\n" 4590#~ " st_touches\n" 4591#~ "------------\n" 4592#~ " t\n" 4593#~ "(1 row)" 4594#~ msgstr "" 4595#~ "SELECT ST_Touches('LINESTRING(0 0, 1 1, 0 2)'::geometry, 'POINT(1 1)'::" 4596#~ "geometry);\n" 4597#~ " st_touches\n" 4598#~ "------------\n" 4599#~ " f\n" 4600#~ "(1 row)\n" 4601#~ "\n" 4602#~ "SELECT ST_Touches('LINESTRING(0 0, 1 1, 0 2)'::geometry, 'POINT(0 2)'::" 4603#~ "geometry);\n" 4604#~ " st_touches\n" 4605#~ "------------\n" 4606#~ " t\n" 4607#~ "(1 row)" 4608 4609#~ msgid "ST_Within" 4610#~ msgstr "ST_Within" 4611 4612#~ msgid "" 4613#~ "<funcdef>boolean <function>ST_Within</function></funcdef> " 4614#~ "<paramdef><type>geometry </type> <parameter>A</parameter></paramdef> " 4615#~ "<paramdef><type>geometry </type> <parameter>B</parameter></paramdef>" 4616#~ msgstr "" 4617#~ "<funcdef>boolean <function>ST_Within</function></funcdef> " 4618#~ "<paramdef><type>geometry </type> <parameter>A</parameter></paramdef> " 4619#~ "<paramdef><type>geometry </type> <parameter>B</parameter></paramdef>" 4620 4621#~ msgid "&sfs_compliant; s2.1.1.2 // s2.1.13.3 - a.Relate(b, 'T*F**F***')" 4622#~ msgstr "&sfs_compliant; s2.1.1.2 // s2.1.13.3 - a.Relate(b, 'T*F**F***')" 4623 4624#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.30" 4625#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.30" 4626 4627#~ msgid ", <xref linkend=\"ST_Equals\"/>, <xref linkend=\"ST_IsValid\"/>" 4628#~ msgstr ", <xref linkend=\"ST_Equals\"/>, <xref linkend=\"ST_IsValid\"/>" 4629 4630#~ msgid ", <xref linkend=\"ST_Expand\"/>" 4631#~ msgstr ", <xref linkend=\"ST_Expand\"/>" 4632 4633#~ msgid "<para>ST_Intersects</para>" 4634#~ msgstr "<para>ST_Intersects</para>" 4635 4636#~ msgid "<refname>ST_Intersects</refname>" 4637#~ msgstr "<refname>ST_Intersects</refname>" 4638 4639#~ msgid "" 4640#~ "<funcdef>geometry <function>ST_Centroid</function></funcdef> " 4641#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 4642#~ msgstr "" 4643#~ "<funcdef>geometry <function>ST_Centroid</function></funcdef> " 4644#~ "<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 4645 4646#, fuzzy 4647#~ msgid "" 4648#~ ", <xref linkend=\"ST_ClusterIntersecting\"/>, <xref linkend=" 4649#~ "\"ST_ClusterWithin\"/>" 4650#~ msgstr ", <xref linkend=\"ST_CoveredBy\"/>, <xref linkend=\"ST_Within\"/>" 4651 4652#~ msgid "" 4653#~ "SELECT ST_AsText(ST_Centroid('MULTIPOINT ( -1 0, -1 2, -1 3, -1 4, -1 7, " 4654#~ "0 1, 0 3, 1 1, 2 0, 6 0, 7 8, 9 8, 10 6 )'));\n" 4655#~ " st_astext\n" 4656#~ "------------------------------------------\n" 4657#~ " POINT(2.30769230769231 3.30769230769231)\n" 4658#~ "(1 row)" 4659#~ msgstr "" 4660#~ "SELECT ST_AsText(ST_Centroid('MULTIPOINT ( -1 0, -1 2, -1 3, -1 4, -1 7, " 4661#~ "0 1, 0 3, 1 1, 2 0, 6 0, 7 8, 9 8, 10 6 )'));\n" 4662#~ " st_astext\n" 4663#~ "------------------------------------------\n" 4664#~ " POINT(2.30769230769231 3.30769230769231)\n" 4665#~ "(1 row)" 4666