File: reference_measure.xml.po

package info (click to toggle)
postgis 2.3.1%2Bdfsg-2
links: PTS, VCS
area: main
in suites: stretch
size: 58,660 kB
ctags: 10,181
sloc: ansic: 132,858; sql: 131,148; xml: 46,460; sh: 4,832; perl: 4,476; makefile: 2,749; python: 1,198; yacc: 442; lex: 131
file content (5684 lines) | stat: -rw-r--r-- 171,977 bytes
parent folder | download | duplicates (2)
# SOME DESCRIPTIVE TITLE.
#
# Translators:
msgid ""
msgstr ""
"Project-Id-Version: PostGIS\n"
"Report-Msgid-Bugs-To: http://bugs.kde.org\n"
"POT-Creation-Date: 2016-07-04 13:02+0000\n"
"PO-Revision-Date: 2015-09-29 12:23+0000\n"
"Last-Translator: Sandro Santilli <strk@kbt.io>\n"
"Language-Team: Polish (http://www.transifex.com/postgis/postgis/language/"
"pl/)\n"
"Language: pl\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=3; plural=(n==1 ? 0 : n%10>=2 && n%10<=4 && (n%100<10 "
"|| n%100>=20) ? 1 : 2);\n"

#. Tag: title
#: reference_measure.xml:3
#, no-c-format
msgid "Spatial Relationships and Measurements"
msgstr ""

#. Tag: refname
#: reference_measure.xml:6
#, no-c-format
msgid "ST_3DClosestPoint"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:8
#, no-c-format
msgid ""
"Returns the 3-dimensional point on g1 that is closest to g2. This is the "
"first point of the 3D shortest line."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:14
#, no-c-format
msgid ""
"<funcdef>geometry <function>ST_3DClosestPoint</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>"
msgstr ""

#. Tag: title
#: reference_measure.xml:27 reference_measure.xml:93 reference_measure.xml:146
#: reference_measure.xml:198 reference_measure.xml:255
#: reference_measure.xml:313 reference_measure.xml:383
#: reference_measure.xml:430 reference_measure.xml:503
#: reference_measure.xml:563 reference_measure.xml:635
#: reference_measure.xml:755 reference_measure.xml:831
#: reference_measure.xml:913 reference_measure.xml:958
#: reference_measure.xml:1035 reference_measure.xml:1079
#: reference_measure.xml:1232 reference_measure.xml:1313
#: reference_measure.xml:1396 reference_measure.xml:1456
#: reference_measure.xml:1622 reference_measure.xml:1757
#: reference_measure.xml:1835 reference_measure.xml:1887
#: reference_measure.xml:1961 reference_measure.xml:2023
#: reference_measure.xml:2078 reference_measure.xml:2125
#: reference_measure.xml:2173 reference_measure.xml:2227
#: reference_measure.xml:2309 reference_measure.xml:2373
#: reference_measure.xml:2470 reference_measure.xml:2537
#: reference_measure.xml:2597 reference_measure.xml:2664
#: reference_measure.xml:2718 reference_measure.xml:2751
#: reference_measure.xml:2796 reference_measure.xml:2847
#: reference_measure.xml:2901 reference_measure.xml:2989
#: reference_measure.xml:3032 reference_measure.xml:3123
#: reference_measure.xml:3174 reference_measure.xml:3211
#: reference_measure.xml:3253 reference_measure.xml:3300
#: reference_measure.xml:3359 reference_measure.xml:3425
#: reference_measure.xml:3468 reference_measure.xml:3547
#: reference_measure.xml:3695
#, no-c-format
msgid "Description"
msgstr ""

#. Tag: para
#: reference_measure.xml:29
#, no-c-format
msgid ""
"Returns the 3-dimensional point on g1 that is closest to g2. This is the "
"first point of the 3D shortest line. The 3D length of the 3D shortest line "
"is the 3D distance."
msgstr ""

#. Tag: para
#: reference_measure.xml:32 reference_measure.xml:98 reference_measure.xml:151
#: reference_measure.xml:213 reference_measure.xml:270
#: reference_measure.xml:323 reference_measure.xml:388
#: reference_measure.xml:444 reference_measure.xml:2489
#: reference_measure.xml:2542 reference_measure.xml:2755
#: reference_measure.xml:2810 reference_measure.xml:3215
#: reference_measure.xml:3261
#, no-c-format
msgid "&Z_support;"
msgstr ""

#. Tag: para
#: reference_measure.xml:34 reference_measure.xml:100
#: reference_measure.xml:153 reference_measure.xml:215
#: reference_measure.xml:272 reference_measure.xml:325
#: reference_measure.xml:390 reference_measure.xml:446
#: reference_measure.xml:514
#, no-c-format
msgid "&P_support;"
msgstr ""

#. Tag: para
#: reference_measure.xml:35 reference_measure.xml:104
#: reference_measure.xml:156 reference_measure.xml:212
#: reference_measure.xml:262 reference_measure.xml:321
#: reference_measure.xml:392 reference_measure.xml:442
#: reference_measure.xml:3306
#, no-c-format
msgid "Availability: 2.0.0"
msgstr ""

#. Tag: para
#: reference_measure.xml:36 reference_measure.xml:322
#: reference_measure.xml:443
#, no-c-format
msgid ""
"Changed: 2.2.0 - if 2 2D geometries are input, a 2D point is returned "
"(instead of old behavior assuming 0 for missing Z). In case of 2D and 3D, Z "
"is no longer assumed to be 0 for missing Z."
msgstr ""

#. Tag: title
#: reference_measure.xml:40 reference_measure.xml:109
#: reference_measure.xml:160 reference_measure.xml:220
#: reference_measure.xml:329 reference_measure.xml:397
#: reference_measure.xml:450 reference_measure.xml:521
#: reference_measure.xml:579 reference_measure.xml:663
#: reference_measure.xml:765 reference_measure.xml:872
#: reference_measure.xml:921 reference_measure.xml:969
#: reference_measure.xml:1043 reference_measure.xml:1118
#: reference_measure.xml:1271 reference_measure.xml:1350
#: reference_measure.xml:1425 reference_measure.xml:1522
#: reference_measure.xml:1657 reference_measure.xml:1780
#: reference_measure.xml:1928 reference_measure.xml:1973
#: reference_measure.xml:2048 reference_measure.xml:2090
#: reference_measure.xml:2139 reference_measure.xml:2188
#: reference_measure.xml:2245 reference_measure.xml:2343
#: reference_measure.xml:2396 reference_measure.xml:2492
#: reference_measure.xml:2548 reference_measure.xml:2761
#: reference_measure.xml:2814 reference_measure.xml:2863
#: reference_measure.xml:2911 reference_measure.xml:3004
#: reference_measure.xml:3054 reference_measure.xml:3221
#: reference_measure.xml:3265 reference_measure.xml:3395
#: reference_measure.xml:3435 reference_measure.xml:3484
#: reference_measure.xml:3597 reference_measure.xml:3729
#, no-c-format
msgid "Examples"
msgstr ""

#. Tag: para
#: reference_measure.xml:45
#, no-c-format
msgid "linestring and point -- both 3d and 2d closest point"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:46
#, no-c-format
msgid ""
"SELECT ST_AsEWKT(ST_3DClosestPoint(line,pt)) AS cp3d_line_pt,\n"
"                ST_AsEWKT(ST_ClosestPoint(line,pt)) As cp2d_line_pt\n"
"        FROM (SELECT 'POINT(100 100 30)'::geometry As pt,\n"
"                        'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 "
"1000)'::geometry As line\n"
"                ) As foo;\n"
"\n"
"\n"
" cp3d_line_pt                                                |               "
"cp2d_line_pt\n"
"-----------------------------------------------------------"
"+------------------------------------------\n"
" POINT(54.6993798867619 128.935022917228 11.5475869506606) | "
"POINT(73.0769230769231 115.384615384615)"
msgstr ""

#. Tag: para
#: reference_measure.xml:50
#, no-c-format
msgid "linestring and multipoint -- both 3d and 2d closest point"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:51
#, no-c-format
msgid ""
"SELECT ST_AsEWKT(ST_3DClosestPoint(line,pt)) AS cp3d_line_pt,\n"
"                ST_AsEWKT(ST_ClosestPoint(line,pt)) As cp2d_line_pt\n"
"        FROM (SELECT 'MULTIPOINT(100 100 30, 50 74 1000)'::geometry As pt,\n"
"                        'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 "
"900)'::geometry As line\n"
"                ) As foo;\n"
"\n"
"\n"
"                       cp3d_line_pt                        | cp2d_line_pt\n"
"-----------------------------------------------------------+--------------\n"
" POINT(54.6993798867619 128.935022917228 11.5475869506606) | POINT(50 75)"
msgstr ""

#. Tag: para
#: reference_measure.xml:55
#, no-c-format
msgid "Multilinestring and polygon both 3d and 2d closest point"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:56
#, no-c-format
msgid ""
"SELECT ST_AsEWKT(ST_3DClosestPoint(poly, mline)) As cp3d,\n"
"    ST_AsEWKT(ST_ClosestPoint(poly, mline)) As cp2d\n"
"        FROM (SELECT  ST_GeomFromEWKT('POLYGON((175 150 5, 20 40 5, 35 45 5, "
"50 60 5, 100 100 5, 175 150 5))') As poly,\n"
"                ST_GeomFromEWKT('MULTILINESTRING((175 155 2, 20 40 20, 50 60 "
"-2, 125 100 1, 175 155 1),\n"
"                (1 10 2, 5 20 1))') As mline ) As foo;\n"
"                   cp3d                    |     cp2d\n"
"-------------------------------------------+--------------\n"
" POINT(39.993580415989 54.1889925532825 5) | POINT(20 40)"
msgstr ""

#. Tag: title
#: reference_measure.xml:66 reference_measure.xml:116
#: reference_measure.xml:166 reference_measure.xml:225
#: reference_measure.xml:286 reference_measure.xml:355
#: reference_measure.xml:403 reference_measure.xml:476
#: reference_measure.xml:537 reference_measure.xml:610
#: reference_measure.xml:726 reference_measure.xml:800
#: reference_measure.xml:886 reference_measure.xml:925
#: reference_measure.xml:1008 reference_measure.xml:1047
#: reference_measure.xml:1205 reference_measure.xml:1276
#: reference_measure.xml:1358 reference_measure.xml:1430
#: reference_measure.xml:1727 reference_measure.xml:1786
#: reference_measure.xml:1865 reference_measure.xml:1934
#: reference_measure.xml:1978 reference_measure.xml:2098
#: reference_measure.xml:2146 reference_measure.xml:2195
#: reference_measure.xml:2250 reference_measure.xml:2348
#: reference_measure.xml:2402 reference_measure.xml:2513
#: reference_measure.xml:2555 reference_measure.xml:2640
#: reference_measure.xml:2695 reference_measure.xml:2727
#: reference_measure.xml:2770 reference_measure.xml:2821
#: reference_measure.xml:2870 reference_measure.xml:2964
#: reference_measure.xml:3009 reference_measure.xml:3096
#: reference_measure.xml:3151 reference_measure.xml:3187
#: reference_measure.xml:3228 reference_measure.xml:3271
#: reference_measure.xml:3317 reference_measure.xml:3401
#: reference_measure.xml:3441 reference_measure.xml:3518
#: reference_measure.xml:3740
#, no-c-format
msgid "See Also"
msgstr ""

#. Tag: para
#: reference_measure.xml:68
#, no-c-format
msgid ""
", <xref linkend=\"ST_ClosestPoint\"/>, <xref linkend=\"ST_3DDistance\"/>, "
"<xref linkend=\"ST_3DShortestLine\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:73
#, no-c-format
msgid "ST_3DDistance"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:75
#, no-c-format
msgid ""
"For geometry type Returns the 3-dimensional cartesian minimum distance "
"(based on spatial ref) between two geometries in projected units."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:80
#, no-c-format
msgid ""
"<funcdef>float <function>ST_3DDistance</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:95
#, no-c-format
msgid ""
"For geometry type returns the 3-dimensional minimum cartesian distance "
"between two geometries in projected units (spatial ref units)."
msgstr ""

#. Tag: para
#: reference_measure.xml:101 reference_measure.xml:154
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM ?"
msgstr ""

#. Tag: para
#: reference_measure.xml:102 reference_measure.xml:274
#: reference_measure.xml:517 reference_measure.xml:1844
#: reference_measure.xml:2629 reference_measure.xml:2680
#, no-c-format
msgid "&sfcgal_enhanced;"
msgstr ""

#. Tag: para
#: reference_measure.xml:105 reference_measure.xml:393
#, no-c-format
msgid ""
"Changed: 2.2.0 - In case of 2D and 3D, Z is no longer assumed to be 0 for "
"missing Z."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:111
#, no-c-format
msgid ""
"-- Geometry example - units in meters (SRID: 2163 US National Atlas Equal "
"area) (3D point and line compared 2D point and line)\n"
"-- Note: currently no vertical datum support so Z is not transformed and "
"assumed to be same units as final.\n"
"SELECT ST_3DDistance(\n"
"                        ST_Transform(ST_GeomFromEWKT('SRID=4326;"
"POINT(-72.1235 42.3521 4)'),2163),\n"
"                        ST_Transform(ST_GeomFromEWKT('SRID=4326;"
"LINESTRING(-72.1260 42.45 15, -72.123 42.1546 20)'),2163)\n"
"                ) As dist_3d,\n"
"                ST_Distance(\n"
"                        ST_Transform(ST_GeomFromText('POINT(-72.1235 "
"42.3521)',4326),2163),\n"
"                        ST_Transform(ST_GeomFromText('LINESTRING(-72.1260 "
"42.45, -72.123 42.1546)', 4326),2163)\n"
"                ) As dist_2d;\n"
"\n"
"     dist_3d      |     dist_2d\n"
"------------------+-----------------\n"
" 127.295059324629 | 126.66425605671"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:112
#, no-c-format
msgid ""
"-- Multilinestring and polygon both 3d and 2d distance\n"
"-- Same example as 3D closest point example\n"
"SELECT ST_3DDistance(poly, mline) As dist3d,\n"
"    ST_Distance(poly, mline) As dist2d\n"
"        FROM (SELECT  ST_GeomFromEWKT('POLYGON((175 150 5, 20 40 5, 35 45 5, "
"50 60 5, 100 100 5, 175 150 5))') As poly,\n"
"                ST_GeomFromEWKT('MULTILINESTRING((175 155 2, 20 40 20, 50 60 "
"-2, 125 100 1, 175 155 1),\n"
"                (1 10 2, 5 20 1))') As mline ) As foo;\n"
"      dist3d       | dist2d\n"
"-------------------+--------\n"
" 0.716635696066337 |      0"
msgstr ""

#. Tag: para
#: reference_measure.xml:118
#, no-c-format
msgid ""
", <xref linkend=\"ST_3DClosestPoint\"/>, <xref linkend=\"ST_3DDWithin\"/>, "
"<xref linkend=\"ST_3DMaxDistance\"/>, <xref linkend=\"ST_3DShortestLine\"/>, "
"<xref linkend=\"ST_Transform\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:124
#, no-c-format
msgid "ST_3DDWithin"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:126
#, no-c-format
msgid ""
"For 3d (z) geometry type Returns true if two geometries 3d distance is "
"within number of units."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:130
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_3DDWithin</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> "
"<paramdef><type>double precision </type> <parameter>distance_of_srid</"
"parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:148
#, no-c-format
msgid ""
"For geometry type returns true if the 3d distance between two objects is "
"within distance_of_srid specified projected units (spatial ref units)."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:162
#, no-c-format
msgid ""
"-- Geometry example - units in meters (SRID: 2163 US National Atlas Equal "
"area) (3D point and line compared 2D point and line)\n"
"-- Note: currently no vertical datum support so Z is not transformed and "
"assumed to be same units as final.\n"
"SELECT ST_3DDWithin(\n"
"                        ST_Transform(ST_GeomFromEWKT('SRID=4326;"
"POINT(-72.1235 42.3521 4)'),2163),\n"
"                        ST_Transform(ST_GeomFromEWKT('SRID=4326;"
"LINESTRING(-72.1260 42.45 15, -72.123 42.1546 20)'),2163),\n"
"                        126.8\n"
"                ) As within_dist_3d,\n"
"ST_DWithin(\n"
"                        ST_Transform(ST_GeomFromEWKT('SRID=4326;"
"POINT(-72.1235 42.3521 4)'),2163),\n"
"                        ST_Transform(ST_GeomFromEWKT('SRID=4326;"
"LINESTRING(-72.1260 42.45 15, -72.123 42.1546 20)'),2163),\n"
"                        126.8\n"
"                ) As within_dist_2d;\n"
"\n"
" within_dist_3d | within_dist_2d\n"
"----------------+----------------\n"
" f              | t"
msgstr ""

#. Tag: para
#: reference_measure.xml:168
#, no-c-format
msgid ""
", <xref linkend=\"ST_Distance\"/>, <xref linkend=\"ST_DWithin\"/>, <xref "
"linkend=\"ST_3DMaxDistance\"/>, <xref linkend=\"ST_Transform\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:174
#, no-c-format
msgid "ST_3DDFullyWithin"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:176
#, no-c-format
msgid ""
"Returns true if all of the 3D geometries are within the specified distance "
"of one another."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:182
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_3DDFullyWithin</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> "
"<paramdef><type>double precision </type> <parameter>distance</parameter></"
"paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:200
#, no-c-format
msgid ""
"Returns true if the 3D geometries are fully within the specified distance of "
"one another. The distance is specified in units defined by the spatial "
"reference system of the geometries. For this function to make sense, the "
"source geometries must both be of the same coordinate projection, having the "
"same SRID."
msgstr ""

#. Tag: para
#: reference_measure.xml:207 reference_measure.xml:264
#: reference_measure.xml:1512 reference_measure.xml:2236
#: reference_measure.xml:2322 reference_measure.xml:2613
#, no-c-format
msgid ""
"This function call will automatically include a bounding box comparison that "
"will make use of any indexes that are available on the geometries."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:221
#, no-c-format
msgid ""
"-- This compares the difference between fully within and distance within as "
"well\n"
"                -- as the distance fully within for the 2D footprint of the "
"line/point vs. the 3d fully within\n"
"                SELECT ST_3DDFullyWithin(geom_a, geom_b, 10) as "
"D3DFullyWithin10, ST_3DDWithin(geom_a, geom_b, 10) as D3DWithin10,\n"
"        ST_DFullyWithin(geom_a, geom_b, 20) as D2DFullyWithin20,\n"
"        ST_3DDFullyWithin(geom_a, geom_b, 20) as D3DFullyWithin20 from\n"
"                (select ST_GeomFromEWKT('POINT(1 1 2)') as geom_a,\n"
"                ST_GeomFromEWKT('LINESTRING(1 5 2, 2 7 20, 1 9 100, 14 12 "
"3)') as geom_b) t1;\n"
" d3dfullywithin10 | d3dwithin10 | d2dfullywithin20 | d3dfullywithin20\n"
"------------------+-------------+------------------+------------------\n"
" f                | t           | t                | f"
msgstr ""

#. Tag: para
#: reference_measure.xml:227
#, no-c-format
msgid ""
", <xref linkend=\"ST_3DDWithin\"/>, <xref linkend=\"ST_DWithin\"/>, <xref "
"linkend=\"ST_DFullyWithin\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:233
#, no-c-format
msgid "ST_3DIntersects"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:235
#, no-c-format
msgid ""
"Returns TRUE if the Geometries \"spatially intersect\" in 3d - only for "
"points, linestrings, polygons, polyhedral surface (area). With SFCGAL "
"backend enabled also supports TINS"
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:241
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_3DIntersects</function></funcdef> <paramdef> "
"<type>geometry</type> <parameter>geomA</parameter> </paramdef> <paramdef> "
"<type>geometry</type> <parameter>geomB</parameter> </paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:256 reference_measure.xml:2600
#, no-c-format
msgid ""
"Overlaps, Touches, Within all imply spatial intersection. If any of the "
"aforementioned returns true, then the geometries also spatially intersect. "
"Disjoint implies false for spatial intersection."
msgstr ""

#. Tag: para
#: reference_measure.xml:269
#, no-c-format
msgid ""
"In order to take advantage of support for TINS, you need to enable the "
"SFCGAL backend. This can be done at session time with: <code>set postgis."
"backend = sfcgal;</code> or at the database or system level. Database level "
"can be done with <code>ALTER DATABASE gisdb SET postgis.backend = sfcgal;</"
"code>."
msgstr ""

#. Tag: para
#: reference_measure.xml:273
#, no-c-format
msgid "&T_support;"
msgstr ""

#. Tag: para
#: reference_measure.xml:275
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: ?"
msgstr ""

#. Tag: title
#: reference_measure.xml:278 reference_measure.xml:2632
#: reference_measure.xml:2684
#, no-c-format
msgid "Geometry Examples"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:279
#, no-c-format
msgid ""
"SELECT ST_3DIntersects(pt, line), ST_Intersects(pt,line)\n"
"        FROM (SELECT 'POINT(0 0 2)'::geometry As pt,\n"
"                'LINESTRING (0 0 1, 0 2 3 )'::geometry As line) As foo;\n"
" st_3dintersects | st_intersects\n"
"-----------------+---------------\n"
" f               | t\n"
"(1 row)"
msgstr ""

#. Tag: title
#: reference_measure.xml:282
#, no-c-format
msgid "TIN Examples"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:283
#, no-c-format
msgid ""
"set postgis.backend = sfcgal;\n"
"SELECT ST_3DIntersects('TIN(((0 0,1 0,0 1,0 0)))'::geometry, 'POINT(.1 .1)'::"
"geometry);\n"
" st_3dintersects\n"
"-----------------\n"
" t"
msgstr ""

#. Tag: refname
#: reference_measure.xml:293
#, no-c-format
msgid "ST_3DLongestLine"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:295
#, no-c-format
msgid "Returns the 3-dimensional longest line between two geometries"
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:300
#, no-c-format
msgid ""
"<funcdef>geometry <function>ST_3DLongestLine</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:315
#, no-c-format
msgid ""
"Returns the 3-dimensional longest line between two geometries. The function "
"will only return the first longest line if more than one. The line returned "
"will always start in g1 and end in g2. The 3D length of the line this "
"function returns will always be the same as <xref linkend=\"ST_3DMaxDistance"
"\"/> returns for g1 and g2."
msgstr ""

#. Tag: para
#: reference_measure.xml:334
#, no-c-format
msgid "linestring and point -- both 3d and 2d longest line"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:335
#, no-c-format
msgid ""
"SELECT ST_AsEWKT(ST_3DLongestLine(line,pt)) AS lol3d_line_pt,\n"
"                ST_AsEWKT(ST_LongestLine(line,pt)) As lol2d_line_pt\n"
"        FROM (SELECT 'POINT(100 100 30)'::geometry As pt,\n"
"                        'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 "
"1000)'::geometry As line\n"
"                ) As foo;\n"
"\n"
"\n"
"           lol3d_line_pt           |       lol2d_line_pt\n"
"-----------------------------------+----------------------------\n"
" LINESTRING(50 75 1000,100 100 30) | LINESTRING(98 190,100 100)"
msgstr ""

#. Tag: para
#: reference_measure.xml:339
#, no-c-format
msgid "linestring and multipoint -- both 3d and 2d longest line"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:340
#, no-c-format
msgid ""
"SELECT ST_AsEWKT(ST_3DLongestLine(line,pt)) AS lol3d_line_pt,\n"
"                ST_AsEWKT(ST_LongestLine(line,pt)) As lol2d_line_pt\n"
"        FROM (SELECT 'MULTIPOINT(100 100 30, 50 74 1000)'::geometry As pt,\n"
"                        'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 "
"900)'::geometry As line\n"
"                ) As foo;\n"
"\n"
"\n"
"          lol3d_line_pt          |      lol2d_line_pt\n"
"---------------------------------+--------------------------\n"
" LINESTRING(98 190 1,50 74 1000) | LINESTRING(98 190,50 74)"
msgstr ""

#. Tag: para
#: reference_measure.xml:344
#, no-c-format
msgid "Multilinestring and polygon both 3d and 2d longest line"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:345
#, no-c-format
msgid ""
"SELECT ST_AsEWKT(ST_3DLongestLine(poly, mline)) As lol3d,\n"
"    ST_AsEWKT(ST_LongestLine(poly, mline)) As lol2d\n"
"        FROM (SELECT  ST_GeomFromEWKT('POLYGON((175 150 5, 20 40 5, 35 45 5, "
"50 60 5, 100 100 5, 175 150 5))') As poly,\n"
"                ST_GeomFromEWKT('MULTILINESTRING((175 155 2, 20 40 20, 50 60 "
"-2, 125 100 1, 175 155 1),\n"
"                (1 10 2, 5 20 1))') As mline ) As foo;\n"
"            lol3d             |          lol2d\n"
"------------------------------+--------------------------\n"
" LINESTRING(175 150 5,1 10 2) | LINESTRING(175 150,1 10)"
msgstr ""

#. Tag: para
#: reference_measure.xml:357
#, no-c-format
msgid ""
", <xref linkend=\"ST_3DDistance\"/>, <xref linkend=\"ST_LongestLine\"/>, "
"<xref linkend=\"ST_3DShortestLine\"/>, <xref linkend=\"ST_3DMaxDistance\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:363
#, no-c-format
msgid "ST_3DMaxDistance"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:365
#, no-c-format
msgid ""
"For geometry type Returns the 3-dimensional cartesian maximum distance "
"(based on spatial ref) between two geometries in projected units."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:370
#, no-c-format
msgid ""
"<funcdef>float <function>ST_3DMaxDistance</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:385
#, no-c-format
msgid ""
"For geometry type returns the 3-dimensional maximum cartesian distance "
"between two geometries in projected units (spatial ref units)."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:399
#, no-c-format
msgid ""
"-- Geometry example - units in meters (SRID: 2163 US National Atlas Equal "
"area) (3D point and line compared 2D point and line)\n"
"-- Note: currently no vertical datum support so Z is not transformed and "
"assumed to be same units as final.\n"
"SELECT ST_3DMaxDistance(\n"
"                        ST_Transform(ST_GeomFromEWKT('SRID=4326;"
"POINT(-72.1235 42.3521 10000)'),2163),\n"
"                        ST_Transform(ST_GeomFromEWKT('SRID=4326;"
"LINESTRING(-72.1260 42.45 15, -72.123 42.1546 20)'),2163)\n"
"                ) As dist_3d,\n"
"                ST_MaxDistance(\n"
"                        ST_Transform(ST_GeomFromEWKT('SRID=4326;"
"POINT(-72.1235 42.3521 10000)'),2163),\n"
"                        ST_Transform(ST_GeomFromEWKT('SRID=4326;"
"LINESTRING(-72.1260 42.45 15, -72.123 42.1546 20)'),2163)\n"
"                ) As dist_2d;\n"
"\n"
"     dist_3d      |     dist_2d\n"
"------------------+------------------\n"
" 24383.7467488441 | 22247.8472107251"
msgstr ""

#. Tag: para
#: reference_measure.xml:405
#, no-c-format
msgid ""
", <xref linkend=\"ST_3DDWithin\"/>, <xref linkend=\"ST_3DMaxDistance\"/>, "
"<xref linkend=\"ST_Transform\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:410
#, no-c-format
msgid "ST_3DShortestLine"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:412
#, no-c-format
msgid "Returns the 3-dimensional shortest line between two geometries"
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:417
#, no-c-format
msgid ""
"<funcdef>geometry <function>ST_3DShortestLine</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:432
#, no-c-format
msgid ""
"Returns the 3-dimensional shortest line between two geometries. The function "
"will only return the first shortest line if more than one, that the function "
"finds. If g1 and g2 intersects in just one point the function will return a "
"line with both start and end in that intersection-point. If g1 and g2 are "
"intersecting with more than one point the function will return a line with "
"start and end in the same point but it can be any of the intersecting "
"points. The line returned will always start in g1 and end in g2. The 3D "
"length of the line this function returns will always be the same as <xref "
"linkend=\"ST_3DDistance\"/> returns for g1 and g2."
msgstr ""

#. Tag: para
#: reference_measure.xml:455
#, no-c-format
msgid "linestring and point -- both 3d and 2d shortest line"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:456
#, no-c-format
msgid ""
"SELECT ST_AsEWKT(ST_3DShortestLine(line,pt)) AS shl3d_line_pt,\n"
"                ST_AsEWKT(ST_ShortestLine(line,pt)) As shl2d_line_pt\n"
"        FROM (SELECT 'POINT(100 100 30)'::geometry As pt,\n"
"                        'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 "
"1000)'::geometry As line\n"
"                ) As foo;\n"
"\n"
"\n"
" shl3d_line_pt                                                                 "
"|               shl2d_line_pt\n"
"----------------------------------------------------------------------------"
"+------------------------------------------------------\n"
" LINESTRING(54.6993798867619 128.935022917228 11.5475869506606,100 100 30)  "
"| LINESTRING(73.0769230769231 115.384615384615,100 100)"
msgstr ""

#. Tag: para
#: reference_measure.xml:460
#, no-c-format
msgid "linestring and multipoint -- both 3d and 2d shortest line"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:461
#, no-c-format
msgid ""
"SELECT ST_AsEWKT(ST_3DShortestLine(line,pt)) AS shl3d_line_pt,\n"
"                ST_AsEWKT(ST_ShortestLine(line,pt)) As shl2d_line_pt\n"
"        FROM (SELECT 'MULTIPOINT(100 100 30, 50 74 1000)'::geometry As pt,\n"
"                        'LINESTRING (20 80 20, 98 190 1, 110 180 3, 50 75 "
"900)'::geometry As line\n"
"                ) As foo;\n"
"\n"
"\n"
"                       shl3d_line_pt                                       | "
"shl2d_line_pt\n"
"---------------------------------------------------------------------------"
"+------------------------\n"
" LINESTRING(54.6993798867619 128.935022917228 11.5475869506606,100 100 30) | "
"LINESTRING(50 75,50 74)"
msgstr ""

#. Tag: para
#: reference_measure.xml:465
#, no-c-format
msgid "Multilinestring and polygon both 3d and 2d shortest line"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:466
#, no-c-format
msgid ""
"SELECT ST_AsEWKT(ST_3DShortestLine(poly, mline)) As shl3d,\n"
"    ST_AsEWKT(ST_ShortestLine(poly, mline)) As shl2d\n"
"        FROM (SELECT  ST_GeomFromEWKT('POLYGON((175 150 5, 20 40 5, 35 45 5, "
"50 60 5, 100 100 5, 175 150 5))') As poly,\n"
"                ST_GeomFromEWKT('MULTILINESTRING((175 155 2, 20 40 20, 50 60 "
"-2, 125 100 1, 175 155 1),\n"
"                (1 10 2, 5 20 1))') As mline ) As foo;\n"
"                   shl3d                                                                           "
"|     shl2d\n"
"---------------------------------------------------------------------------------------------------"
"+------------------------\n"
" LINESTRING(39.993580415989 54.1889925532825 5,40.4078575708294 "
"53.6052383805529 5.03423778139177) | LINESTRING(20 40,20 40)"
msgstr ""

#. Tag: para
#: reference_measure.xml:478
#, no-c-format
msgid ""
", <xref linkend=\"ST_3DDistance\"/>, <xref linkend=\"ST_LongestLine\"/>, "
"<xref linkend=\"ST_ShortestLine\"/>, <xref linkend=\"ST_3DMaxDistance\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:483
#, no-c-format
msgid "ST_Area"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:485
#, no-c-format
msgid ""
"Returns the area of the surface if it is a Polygon or MultiPolygon. For "
"geometry, a 2D Cartesian area is determined with units specified by the "
"SRID. For geography, area is determined on a curved surface with units in "
"square meters."
msgstr ""

#. Tag: funcsynopsis
#: reference_measure.xml:489
#, no-c-format
msgid ""
"<funcprototype> <funcdef>float <function>ST_Area</function></funcdef> "
"<paramdef><type>geometry </type><parameter>g1</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>float <function>ST_Area</function></"
"funcdef> <paramdef><type>geography </type><parameter>geog</parameter></"
"paramdef> <paramdef choice=\"opt\"><type>boolean </"
"type><parameter>use_spheroid=true</parameter></paramdef> </funcprototype>"
msgstr ""

#. Tag: para
#: reference_measure.xml:505
#, no-c-format
msgid ""
"Returns the area of the geometry if it is a Polygon or MultiPolygon. Return "
"the area measurement of an ST_Surface or ST_MultiSurface value. For "
"geometry, a 2D Cartesian area is determined with units specified by the "
"SRID. For geography, by default area is determined on a spheroid with units "
"in square meters. To measure around the faster but less accurate sphere, use "
"ST_Area(geog,false)."
msgstr ""

#. Tag: para
#: reference_measure.xml:510
#, no-c-format
msgid "Enhanced: 2.0.0 - support for 2D polyhedral surfaces was introduced."
msgstr ""

#. Tag: para
#: reference_measure.xml:511 reference_measure.xml:1849
#, no-c-format
msgid ""
"Enhanced: 2.2.0 - measurement on spheroid performed with GeographicLib for "
"improved accuracy and robustness. Requires Proj &gt;= 4.9.0 to take "
"advantage of the new feature."
msgstr ""

#. Tag: para
#: reference_measure.xml:512 reference_measure.xml:658
#: reference_measure.xml:1841 reference_measure.xml:2336
#, no-c-format
msgid "&sfs_compliant;"
msgstr ""

#. Tag: para
#: reference_measure.xml:513
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 8.1.2, 9.5.3"
msgstr ""

#. Tag: para
#: reference_measure.xml:515
#, no-c-format
msgid ""
"For polyhedral surfaces, only supports 2D polyhedral surfaces (not 2.5D). "
"For 2.5D, may give a non-zero answer, but only for the faces that sit "
"completely in XY plane."
msgstr ""

#. Tag: para
#: reference_measure.xml:522
#, no-c-format
msgid ""
"Return area in square feet for a plot of Massachusetts land and multiply by "
"conversion to get square meters. Note this is in square feet because "
"EPSG:2249 is Massachusetts State Plane Feet"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:525
#, no-c-format
msgid ""
"SELECT ST_Area(the_geom) As sqft, ST_Area(the_geom)*POWER(0.3048,2) As sqm\n"
"                FROM (SELECT\n"
"                ST_GeomFromText('POLYGON((743238 2967416,743238 2967450,\n"
"                        743265 2967450,743265.625 2967416,743238 "
"2967416))',2249) ) As foo(the_geom);\n"
"  sqft   |     sqm\n"
"---------+-------------\n"
" 928.625 | 86.27208552"
msgstr ""

#. Tag: para
#: reference_measure.xml:526
#, no-c-format
msgid ""
"Return area square feet and transform to Massachusetts state plane meters "
"(EPSG:26986) to get square meters. Note this is in square feet because 2249 "
"is Massachusetts State Plane Feet and transformed area is in square meters "
"since EPSG:26986 is state plane Massachusetts meters"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:529
#, no-c-format
msgid ""
"SELECT ST_Area(the_geom) As sqft, ST_Area(ST_Transform(the_geom,26986)) As "
"sqm\n"
"                FROM (SELECT\n"
"                ST_GeomFromText('POLYGON((743238 2967416,743238 2967450,\n"
"                        743265 2967450,743265.625 2967416,743238 "
"2967416))',2249) ) As foo(the_geom);\n"
"  sqft   |       sqm\n"
"---------+------------------\n"
" 928.625 | 86.2724304199219"
msgstr ""

#. Tag: para
#: reference_measure.xml:531
#, no-c-format
msgid ""
"Return area square feet and square meters using geography data type. Note "
"that we transform to our geometry to geography (before you can do that make "
"sure your geometry is in WGS 84 long lat 4326). Geography always measures in "
"meters. This is just for demonstration to compare. Normally your table will "
"be stored in geography data type already."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:534
#, no-c-format
msgid ""
"SELECT ST_Area(the_geog)/POWER(0.3048,2) As sqft_spheroid,  ST_Area(the_geog,"
"false)/POWER(0.3048,2) As sqft_sphere, ST_Area(the_geog) As sqm_spheroid\n"
"                FROM (SELECT\n"
"                geography(\n"
"                ST_Transform(\n"
"                        ST_GeomFromText('POLYGON((743238 2967416,743238 "
"2967450,743265 2967450,743265.625 2967416,743238 2967416))',\n"
"                                2249\n"
"                                ) ,4326\n"
"                        )\n"
"                )\n"
"        ) As foo(the_geog);\n"
"  sqft_spheroid   |   sqft_sphere    |   sqm_spheroid\n"
"------------------+------------------+------------------\n"
" 928.684403538925 | 927.049336105925 | 86.2776042893529\n"
"\n"
" --if your data is in geography already\n"
" SELECT ST_Area(the_geog)/POWER(0.3048,2) As  sqft, ST_Area(the_geog) As "
"sqm\n"
"        FROM somegeogtable;"
msgstr ""

#. Tag: para
#: reference_measure.xml:538
#, no-c-format
msgid ""
", <xref linkend=\"ST_GeographyFromText\"/>, <xref linkend=\"ST_SetSRID\"/>, "
"<xref linkend=\"ST_Transform\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:544
#, no-c-format
msgid "ST_Azimuth"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:546
#, no-c-format
msgid ""
"Returns the north-based azimuth as the angle in radians measured clockwise "
"from the vertical on pointA to pointB."
msgstr ""

#. Tag: funcsynopsis
#: reference_measure.xml:549
#, no-c-format
msgid ""
"<funcprototype> <funcdef>float <function>ST_Azimuth</function></funcdef> "
"<paramdef><type>geometry </type><parameter>pointA</parameter></paramdef> "
"<paramdef><type>geometry </type><parameter>pointB</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>float <function>ST_Azimuth</"
"function></funcdef> <paramdef><type>geography </type><parameter>pointA</"
"parameter></paramdef> <paramdef><type>geography </type><parameter>pointB</"
"parameter></paramdef> </funcprototype>"
msgstr ""

#. Tag: para
#: reference_measure.xml:565
#, no-c-format
msgid ""
"Returns the azimuth in radians of the segment defined by the given point "
"geometries, or NULL if the two points are coincident. The azimuth is angle "
"is referenced from north, and is positive clockwise: North = 0; East = "
"&#x03C0;/2; South = &#x03C0;; West = 3&#x03C0;/2."
msgstr ""

#. Tag: para
#: reference_measure.xml:567
#, no-c-format
msgid ""
"For the geography type, the forward azimuth is solved as part of the inverse "
"geodesic problem."
msgstr ""

#. Tag: para
#: reference_measure.xml:568
#, no-c-format
msgid ""
"The azimuth is mathematical concept defined as the angle between a reference "
"plane and a point, with angular units in radians. Units can be converted to "
"degrees using a built-in PostgreSQL function degrees(), as shown in the "
"example."
msgstr ""

#. Tag: para
#: reference_measure.xml:571
#, no-c-format
msgid "Availability: 1.1.0"
msgstr ""

#. Tag: para
#: reference_measure.xml:572
#, no-c-format
msgid "Enhanced: 2.0.0 support for geography was introduced."
msgstr ""

#. Tag: para
#: reference_measure.xml:573
#, no-c-format
msgid ""
"Enhanced: 2.2.0 measurement on spheroid performed with GeographicLib for "
"improved accuracy and robustness. Requires Proj &gt;= 4.9.0 to take "
"advantage of the new feature."
msgstr ""

#. Tag: para
#: reference_measure.xml:574
#, no-c-format
msgid ""
"Azimuth is especially useful in conjunction with ST_Translate for shifting "
"an object along its perpendicular axis. See upgis_lineshift <ulink url="
"\"http://trac.osgeo.org/postgis/wiki/UsersWikiplpgsqlfunctions"
"\">Plpgsqlfunctions PostGIS wiki section</ulink> for example of this."
msgstr ""

#. Tag: para
#: reference_measure.xml:580
#, no-c-format
msgid "Geometry Azimuth in degrees"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:581
#, no-c-format
msgid ""
"SELECT degrees(ST_Azimuth(ST_Point(25, 45), ST_Point(75, 100))) AS degA_B,\n"
"            degrees(ST_Azimuth(ST_Point(75, 100), ST_Point(25, 45))) AS "
"degB_A;\n"
"\n"
"      dega_b       |     degb_a\n"
"------------------+------------------\n"
" 42.2736890060937 | 222.273689006094"
msgstr ""

#. Tag: para
#: reference_measure.xml:591
#, no-c-format
msgid ""
"Green: the start Point(25,45) with its vertical. Yellow: degA_B as the path "
"to travel (azimuth)."
msgstr ""

#. Tag: para
#: reference_measure.xml:600
#, no-c-format
msgid ""
"Green: the start Point(75,100) with its vertical. Yellow: degB_A as the path "
"to travel (azimuth)."
msgstr ""

#. Tag: para
#: reference_measure.xml:611
#, no-c-format
msgid ""
", <xref linkend=\"ST_Translate\"/>, <xref linkend=\"ST_Project\"/>, <ulink "
"url=\"http://www.postgresql.org/docs/current/interactive/functions-math.html"
"\">PostgreSQL Math Functions</ulink>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:618
#, no-c-format
msgid "ST_Centroid"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:620
#, no-c-format
msgid "Returns the geometric center of a geometry."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:625
#, no-c-format
msgid ""
"<funcdef>geometry <function>ST_Centroid</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:637
#, no-c-format
msgid ""
"Computes the geometric center of a geometry, or equivalently, the center of "
"mass of the geometry as a <varname>POINT</varname>. For [<varname>MULTI</"
"varname>]<varname>POINT</varname>s, this is computed as the arithmetic mean "
"of the input coordinates. For [<varname>MULTI</varname>]<varname>LINESTRING</"
"varname>s, this is computed as the weighted length of each line segment. For "
"[<varname>MULTI</varname>]<varname>POLYGON</varname>s, \"weight\" is thought "
"in terms of area. If an empty geometry is supplied, an empty "
"<varname>GEOMETRYCOLLECTION</varname> is returned. If <varname>NULL</"
"varname> is supplied, <varname>NULL</varname> is returned. If "
"<varname>CIRCULARSTRING</varname> or <varname>COMPOUNDCURVE</varname> are "
"supplied, they are converted to linestring wtih CurveToLine first, then same "
"than for <varname>LINESTRING</varname>"
msgstr ""

#. Tag: para
#: reference_measure.xml:652
#, no-c-format
msgid ""
"New in 2.3.0 : support <varname>CIRCULARSTRING</varname> and "
"<varname>COMPOUNDCURVE</varname> (using CurveToLine)"
msgstr ""

#. Tag: para
#: reference_measure.xml:654
#, no-c-format
msgid ""
"The centroid is equal to the centroid of the set of component Geometries of "
"highest dimension (since the lower-dimension geometries contribute zero "
"\"weight\" to the centroid)."
msgstr ""

#. Tag: para
#: reference_measure.xml:659
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 8.1.4, 9.5.5"
msgstr ""

#. Tag: para
#: reference_measure.xml:665
#, no-c-format
msgid ""
"In each of the following illustrations, the blue dot represents the centroid "
"of the source geometry."
msgstr ""

#. Tag: para
#: reference_measure.xml:678
#, no-c-format
msgid "Centroid of a <varname>MULTIPOINT</varname>"
msgstr ""

#. Tag: para
#: reference_measure.xml:689
#, no-c-format
msgid "Centroid of a <varname>LINESTRING</varname>"
msgstr ""

#. Tag: para
#: reference_measure.xml:702
#, no-c-format
msgid "Centroid of a <varname>POLYGON</varname>"
msgstr ""

#. Tag: para
#: reference_measure.xml:713
#, no-c-format
msgid "Centroid of a <varname>GEOMETRYCOLLECTION</varname>"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:722
#, no-c-format
msgid ""
"SELECT ST_AsText(ST_Centroid('MULTIPOINT ( -1 0, -1 2, -1 3, -1 4, -1 7, 0 "
"1, 0 3, 1 1, 2 0, 6 0, 7 8, 9 8, 10 6 )'));\n"
"                                st_astext\n"
"------------------------------------------\n"
" POINT(2.30769230769231 3.30769230769231)\n"
"(1 row)\n"
"\n"
"SELECT ST_AsText(ST_centroid(g))\n"
"FROM  ST_GeomFromText('CIRCULARSTRING(0 2, -1 1,0 0, 0.5 0, 1 0, 2 1, 1 2, "
"0.5 2, 0 2)')  AS g ;\n"
"------------------------------------------\n"
"POINT(0.5 1)\n"
"\n"
"\n"
"SELECT ST_AsText(ST_centroid(g))\n"
"FROM  ST_GeomFromText('COMPOUNDCURVE(CIRCULARSTRING(0 2, -1 1,0 0),(0 0, 0.5 "
"0, 1 0),CIRCULARSTRING( 1 0, 2 1, 1 2),(1 2, 0.5 2, 0 2))' ) AS g;\n"
"------------------------------------------\n"
"POINT(0.5 1)"
msgstr ""

#. Tag: refname
#: reference_measure.xml:734
#, no-c-format
msgid "ST_ClosestPoint"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:736
#, no-c-format
msgid ""
"<refpurpose>Returns the 2-dimensional point on g1 that is closest to g2. "
"This is the first point of the shortest line.</refpurpose>"
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:742
#, no-c-format
msgid ""
"<funcdef>geometry <function>ST_ClosestPoint</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:757
#, no-c-format
msgid ""
"<para>Returns the 2-dimensional point on g1 that is closest to g2. This is "
"the first point of the shortest line.</para>"
msgstr ""

#. Tag: para
#: reference_measure.xml:760
#, no-c-format
msgid ""
"If you have a 3D Geometry, you may prefer to use <xref linkend="
"\"ST_3DClosestPoint\"/>."
msgstr ""

#. Tag: para
#: reference_measure.xml:761 reference_measure.xml:2087
#: reference_measure.xml:2241 reference_measure.xml:2906
#: reference_measure.xml:3480
#, no-c-format
msgid "Availability: 1.5.0"
msgstr ""

#. Tag: para
#: reference_measure.xml:775
#, no-c-format
msgid ""
"Closest between point and linestring is the point itself, but closest point "
"between a linestring and point is the point on line string that is closest."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:779
#, no-c-format
msgid ""
"SELECT ST_AsText(ST_ClosestPoint(pt,line)) AS cp_pt_line,\n"
"        ST_AsText(ST_ClosestPoint(line,pt)) As cp_line_pt\n"
"FROM (SELECT 'POINT(100 100)'::geometry As pt,\n"
"                'LINESTRING (20 80, 98 190, 110 180, 50 75 )'::geometry As "
"line\n"
"        ) As foo;\n"
"\n"
"\n"
"   cp_pt_line   |                cp_line_pt\n"
"----------------+------------------------------------------\n"
" POINT(100 100) | POINT(73.0769230769231 115.384615384615)"
msgstr ""

#. Tag: para
#: reference_measure.xml:787
#, no-c-format
msgid "closest point on polygon A to polygon B"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:790
#, no-c-format
msgid ""
"SELECT ST_AsText(\n"
"                ST_ClosestPoint(\n"
"                        ST_GeomFromText('POLYGON((175 150, 20 40, 50 60, 125 "
"100, 175 150))'),\n"
"                        ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n"
"                        )\n"
"                ) As ptwkt;\n"
"\n"
"                  ptwkt\n"
"------------------------------------------\n"
" POINT(140.752120669087 125.695053378061)"
msgstr ""

#. Tag: para
#: reference_measure.xml:802
#, no-c-format
msgid ""
",<xref linkend=\"ST_Distance\"/>, <xref linkend=\"ST_LongestLine\"/>, <xref "
"linkend=\"ST_ShortestLine\"/>, <xref linkend=\"ST_MaxDistance\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:808
#, no-c-format
msgid "ST_ClusterDBSCAN"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:810
#, no-c-format
msgid ""
"Windowing function that returns integer id for the cluster each input "
"geometry is in based on 2D implementation of Density-based spatial "
"clustering of applications with noise (DBSCAN) algorithm."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:815
#, no-c-format
msgid ""
"<funcdef>integer <function>ST_ClusterDBSCAN</function></funcdef> "
"<paramdef><type>geometry winset </type> <parameter>geom</parameter></"
"paramdef> <paramdef><type>float8 </type> <parameter>eps</parameter></"
"paramdef> <paramdef><type>integer </type> <parameter>minpoints</parameter></"
"paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:833
#, no-c-format
msgid ""
"Returns cluster number for each input geometry, based on a 2D implementation "
"of the <ulink url=\"https://en.wikipedia.org/wiki/DBSCAN\">Density-based "
"spatial clustering of applications with noise (DBSCAN)</ulink> algorithm. "
"Unlike <xref linkend=\"ST_ClusterKMeans\"/>, it does not require the number "
"of clusters to be specified, but instead uses the desired distance "
"(<varname>eps</varname>) and density(<varname>minpoints</varname>) "
"parameters to construct each cluster."
msgstr ""

#. Tag: para
#: reference_measure.xml:840
#, no-c-format
msgid "An input geometry will be added to a cluster if it is either:"
msgstr ""

#. Tag: para
#: reference_measure.xml:844
#, no-c-format
msgid ""
"A \"core\" geometry, that is within <varname>eps</varname> distance of at "
"least <varname>minpoints</varname> other input geometries, or"
msgstr ""

#. Tag: para
#: reference_measure.xml:849
#, no-c-format
msgid ""
"A \"border\" geometry, that is within <varname>eps</varname> distance of a "
"core geometry."
msgstr ""

#. Tag: para
#: reference_measure.xml:856
#, no-c-format
msgid ""
"Note that border geometries may be within <varname>eps</varname> distance of "
"core geometries in more than one cluster; in this case, either assignment "
"would be correct, and the border geometry will be arbitrarily asssigned to "
"one of the available clusters. In these cases, it is possible for a correct "
"cluster to be generated with fewer than <varname>minpoints</varname> "
"geometries. When assignment of a border geometry is ambiguous, repeated "
"calls to ST_ClusterDBSCAN will produce identical results if an ORDER BY "
"clause is included in the window definition, but cluster assignments may "
"differ from other implementations of the same algorithm."
msgstr ""

#. Tag: para
#: reference_measure.xml:864
#, no-c-format
msgid ""
"Input geometries that do not meet the criteria to join any other cluster "
"will be assigned a cluster number of NULL."
msgstr ""

#. Tag: para
#: reference_measure.xml:868 reference_measure.xml:965
#, no-c-format
msgid "Availability: 2.3.0 - requires GEOS"
msgstr ""

#. Tag: para
#: reference_measure.xml:873
#, no-c-format
msgid "Assigning a cluster number to each parcel point:"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:876
#, no-c-format
msgid ""
"SELECT parcel_id, ST_ClusterDBSCAN(geom, eps := 0.5, minpoints := 5) over () "
"AS cid\n"
"FROM parcels;"
msgstr ""

#. Tag: para
#: reference_measure.xml:879
#, no-c-format
msgid ""
"Combining parcels with the same cluster number into a single geometry. This "
"uses named argument calling"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:882
#, no-c-format
msgid ""
"SELECT cid, ST_Collect(geom) AS cluster_geom, array_agg(parcel_id) AS "
"ids_in_cluster FROM (\n"
"    SELECT parcel_id, ST_ClusterDBSCAN(geom, eps := 0.5, minpoints := 5) "
"over () AS cid, geom\n"
"    FROM parcels) sq\n"
"GROUP BY cid;"
msgstr ""

#. Tag: para
#: reference_measure.xml:887
#, no-c-format
msgid ""
", <xref linkend=\"ST_ClusterIntersecting\"/>, <xref linkend="
"\"ST_ClusterWithin\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:898
#, no-c-format
msgid "ST_ClusterIntersecting"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:900
#, no-c-format
msgid ""
"Aggregate. Returns an array with the connected components of a set of "
"geometries"
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:905
#, no-c-format
msgid ""
"<funcdef>geometry[] <function>ST_ClusterIntersecting</function></funcdef> "
"<paramdef><type>geometry set</type> <parameter>g</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:915
#, no-c-format
msgid ""
"ST_ClusterIntersecting is an aggregate function that returns an array of "
"GeometryCollections, where each GeometryCollection represents an "
"interconnected set of geometries."
msgstr ""

#. Tag: para
#: reference_measure.xml:917 reference_measure.xml:1039
#, no-c-format
msgid "Availability: 2.2.0 - requires GEOS"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:922
#, no-c-format
msgid ""
"WITH testdata AS\n"
"  (SELECT unnest(ARRAY['LINESTRING (0 0, 1 1)'::geometry,\n"
"                       'LINESTRING (5 5, 4 4)'::geometry,\n"
"                       'LINESTRING (6 6, 7 7)'::geometry,\n"
"                       'LINESTRING (0 0, -1 -1)'::geometry,\n"
"                       'POLYGON ((0 0, 4 0, 4 4, 0 4, 0 0))'::geometry]) AS "
"geom)\n"
"\n"
"SELECT ST_AsText(unnest(ST_ClusterIntersecting(geom))) FROM testdata;\n"
"\n"
"--result\n"
"\n"
"st_astext\n"
"---------\n"
"GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(5 5,4 4),LINESTRING(0 0,-1 "
"-1),POLYGON((0 0,4 0,4 4,0 4,0 0)))\n"
"GEOMETRYCOLLECTION(LINESTRING(6 6,7 7))"
msgstr ""

#. Tag: para
#: reference_measure.xml:926
#, no-c-format
msgid ""
", <xref linkend=\"ST_ClusterKMeans\"/>, <xref linkend=\"ST_ClusterWithin\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:938
#, no-c-format
msgid "ST_ClusterKMeans"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:940
#, no-c-format
msgid ""
"Windowing function that returns integer id for the cluster each input "
"geometry is in."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:945
#, no-c-format
msgid ""
"<funcdef>integer <function>ST_ClusterKMeans</function></funcdef> "
"<paramdef><type>geometry winset </type> <parameter>geom</parameter></"
"paramdef> <paramdef><type>integer </type> <parameter>number_of_clusters</"
"parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:960
#, no-c-format
msgid ""
"Returns 2D distance based <ulink url=\"https://en.wikipedia.org/wiki/K-"
"means_clustering\">k-means</ulink> cluster number for each input geometry. "
"The distance used for clustering is the distance between the centroids of "
"the geometries."
msgstr ""

#. Tag: para
#: reference_measure.xml:970
#, no-c-format
msgid "Generate dummy set of parcels for examples"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:971
#, no-c-format
msgid ""
"CREATE TABLE parcels AS\n"
"SELECT lpad((row_number() over())::text,3,'0') As parcel_id, geom,\n"
"('{residential, commercial}'::text[])[1 + mod(row_number()OVER(),2)] As "
"type\n"
"FROM\n"
"    ST_Subdivide(ST_Buffer('LINESTRING(40 100, 98 100, 100 150, 60 90)'::"
"geometry,\n"
"    40, 'endcap=square'),12) As geom;"
msgstr ""

#. Tag: para
#: reference_measure.xml:983
#, no-c-format
msgid "Original Parcels"
msgstr ""

#. Tag: para
#: reference_measure.xml:993
#, no-c-format
msgid "Parcels color-coded by cluster number (cid)"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:996
#, no-c-format
msgid ""
"SELECT ST_ClusterKMeans(geom, 5) OVER() AS cid, parcel_id, geom\n"
"FROM parcels;\n"
"-- result\n"
" cid | parcel_id |   geom\n"
"-----+-----------+---------------\n"
"   0 | 001       | 0103000000...\n"
"   0 | 002       | 0103000000...\n"
"   1 | 003       | 0103000000...\n"
"   0 | 004       | 0103000000...\n"
"   1 | 005       | 0103000000...\n"
"   2 | 006       | 0103000000...\n"
"   2 | 007       | 0103000000...\n"
"(7 rows)"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1003
#, no-c-format
msgid ""
"-- Partitioning parcel clusters by type\n"
"SELECT ST_ClusterKMeans(geom,3) over (PARTITION BY type) AS cid, parcel_id, "
"type\n"
"FROM parcels;\n"
"-- result\n"
" cid | parcel_id |    type\n"
"-----+-----------+-------------\n"
"   1 | 005       | commercial\n"
"   1 | 003       | commercial\n"
"   2 | 007       | commercial\n"
"   0 | 001       | commercial\n"
"   1 | 004       | residential\n"
"   0 | 002       | residential\n"
"   2 | 006       | residential\n"
"(7 rows)"
msgstr ""

#. Tag: para
#: reference_measure.xml:1009
#, no-c-format
msgid ""
", <xref linkend=\"ST_ClusterIntersecting\"/>, <xref linkend="
"\"ST_ClusterWithin\"/>, <xref linkend=\"ST_Subdivide\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:1019
#, no-c-format
msgid "ST_ClusterWithin"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:1021
#, no-c-format
msgid ""
"Aggregate. Returns an array of GeometryCollections, where each "
"GeometryCollection represents a set of geometries separated by no more than "
"the specified distance."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:1026
#, no-c-format
msgid ""
"<funcdef>geometry[] <function>ST_ClusterWithin</function></funcdef> "
"<paramdef><type>geometry set </type> <parameter>g</parameter></paramdef> "
"<paramdef><type>float8 </type> <parameter>distance</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1037
#, no-c-format
msgid ""
"ST_ClusterWithin is an aggregate function that returns an array of "
"GeometryCollections, where each GeometryCollection represents a set of "
"geometries separated by no more than the specified distance."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1044
#, no-c-format
msgid ""
"WITH testdata AS\n"
"  (SELECT unnest(ARRAY['LINESTRING (0 0, 1 1)'::geometry,\n"
"                       'LINESTRING (5 5, 4 4)'::geometry,\n"
"                       'LINESTRING (6 6, 7 7)'::geometry,\n"
"                       'LINESTRING (0 0, -1 -1)'::geometry,\n"
"                       'POLYGON ((0 0, 4 0, 4 4, 0 4, 0 0))'::geometry]) AS "
"geom)\n"
"\n"
"SELECT ST_AsText(unnest(ST_ClusterWithin(geom, 1.4))) FROM testdata;\n"
"\n"
"--result\n"
"\n"
"st_astext\n"
"---------\n"
"GEOMETRYCOLLECTION(LINESTRING(0 0,1 1),LINESTRING(5 5,4 4),LINESTRING(0 0,-1 "
"-1),POLYGON((0 0,4 0,4 4,0 4,0 0)))\n"
"GEOMETRYCOLLECTION(LINESTRING(6 6,7 7))"
msgstr ""

#. Tag: para
#: reference_measure.xml:1048
#, no-c-format
msgid ""
", <xref linkend=\"ST_ClusterKMeans\"/>, <xref linkend="
"\"ST_ClusterIntersecting\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:1059
#, no-c-format
msgid "ST_Contains"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:1061
#, no-c-format
msgid ""
"Returns true if and only if no points of B lie in the exterior of A, and at "
"least one point of the interior of B lies in the interior of A."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:1066
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_Contains</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1081
#, no-c-format
msgid ""
"Geometry A contains Geometry B if and only if no points of B lie in the "
"exterior of A, and at least one point of the interior of B lies in the "
"interior of A. An important subtlety of this definition is that A does not "
"contain its boundary, but A does contain itself. Contrast that to <xref "
"linkend=\"ST_ContainsProperly\"/> where geometry A does not Contain Properly "
"itself."
msgstr ""

#. Tag: para
#: reference_measure.xml:1085
#, no-c-format
msgid ""
"Returns TRUE if geometry B is completely inside geometry A. For this "
"function to make sense, the source geometries must both be of the same "
"coordinate projection, having the same SRID. ST_Contains is the inverse of "
"ST_Within. So ST_Contains(A,B) implies ST_Within(B,A) except in the case of "
"invalid geometries where the result is always false regardless or not "
"defined."
msgstr ""

#. Tag: para
#: reference_measure.xml:1090 reference_measure.xml:1318
#: reference_measure.xml:1401 reference_measure.xml:1766
#: reference_measure.xml:3037 reference_measure.xml:3385
#: reference_measure.xml:3702
#, no-c-format
msgid "Performed by the GEOS module"
msgstr ""

#. Tag: para
#: reference_measure.xml:1091 reference_measure.xml:2608
#, no-c-format
msgid ""
"Enhanced: 2.3.0 Enhancement to PIP short-circuit extended to support "
"MultiPoints with few points. Prior versions only supported point in polygon."
msgstr ""

#. Tag: para
#: reference_measure.xml:1094 reference_measure.xml:1256
#: reference_measure.xml:1321 reference_measure.xml:1404
#: reference_measure.xml:1508 reference_measure.xml:1763
#: reference_measure.xml:3583 reference_measure.xml:3707
#, no-c-format
msgid "Do not call with a <varname>GEOMETRYCOLLECTION</varname> as an argument"
msgstr ""

#. Tag: para
#: reference_measure.xml:1098 reference_measure.xml:1260
#: reference_measure.xml:1329 reference_measure.xml:1408
#: reference_measure.xml:3711
#, no-c-format
msgid ""
"Do not use this function with invalid geometries. You will get unexpected "
"results."
msgstr ""

#. Tag: para
#: reference_measure.xml:1101
#, no-c-format
msgid ""
"This function call will automatically include a bounding box comparison that "
"will make use of any indexes that are available on the geometries. To avoid "
"index use, use the function _ST_Contains."
msgstr ""

#. Tag: para
#: reference_measure.xml:1106 reference_measure.xml:1341
#: reference_measure.xml:1416 reference_measure.xml:1772
#: reference_measure.xml:2622 reference_measure.xml:3046
#: reference_measure.xml:3719
#, no-c-format
msgid ""
"NOTE: this is the \"allowable\" version that returns a boolean, not an "
"integer."
msgstr ""

#. Tag: para
#: reference_measure.xml:1109
#, no-c-format
msgid ""
"&sfs_compliant; s2.1.1.2 // s2.1.13.3 - same as within(geometry B, geometry "
"A)"
msgstr ""

#. Tag: para
#: reference_measure.xml:1111
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 5.1.31"
msgstr ""

#. Tag: para
#: reference_measure.xml:1113 reference_measure.xml:1345
#: reference_measure.xml:1420
#, no-c-format
msgid ""
"There are certain subtleties to ST_Contains and ST_Within that are not "
"intuitively obvious. For details check out <ulink url=\"http://lin-ear-th-"
"inking.blogspot.com/2007/06/subtleties-of-ogc-covers-spatial.html"
"\">Subtleties of OGC Covers, Contains, Within</ulink>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1120
#, no-c-format
msgid ""
"The <function>ST_Contains</function> predicate returns <varname>TRUE</"
"varname> in all the following illustrations."
msgstr ""

#. Tag: para
#: reference_measure.xml:1132
#, no-c-format
msgid "<varname>LINESTRING</varname> / <varname>MULTIPOINT</varname>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1142 reference_measure.xml:3661
#, no-c-format
msgid "<varname>POLYGON</varname> / <varname>POINT</varname>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1153 reference_measure.xml:1193
#: reference_measure.xml:3630
#, no-c-format
msgid "<varname>POLYGON</varname> / <varname>LINESTRING</varname>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1163 reference_measure.xml:3083
#: reference_measure.xml:3610 reference_measure.xml:3620
#, no-c-format
msgid "<varname>POLYGON</varname> / <varname>POLYGON</varname>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1171
#, no-c-format
msgid ""
"The <function>ST_Contains</function> predicate returns <varname>FALSE</"
"varname> in all the following illustrations."
msgstr ""

#. Tag: para
#: reference_measure.xml:1183
#, no-c-format
msgid "<varname>POLYGON</varname> / <varname>MULTIPOINT</varname>"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1201
#, no-c-format
msgid ""
"-- A circle within a circle\n"
"SELECT ST_Contains(smallc, bigc) As smallcontainsbig,\n"
"           ST_Contains(bigc,smallc) As bigcontainssmall,\n"
"           ST_Contains(bigc, ST_Union(smallc, bigc)) as bigcontainsunion,\n"
"           ST_Equals(bigc, ST_Union(smallc, bigc)) as bigisunion,\n"
"           ST_Covers(bigc, ST_ExteriorRing(bigc)) As bigcoversexterior,\n"
"           ST_Contains(bigc, ST_ExteriorRing(bigc)) As bigcontainsexterior\n"
"FROM (SELECT ST_Buffer(ST_GeomFromText('POINT(1 2)'), 10) As smallc,\n"
"                         ST_Buffer(ST_GeomFromText('POINT(1 2)'), 20) As "
"bigc) As foo;\n"
"\n"
"-- Result\n"
"  smallcontainsbig | bigcontainssmall | bigcontainsunion | bigisunion | "
"bigcoversexterior | bigcontainsexterior\n"
"------------------+------------------+------------------+------------"
"+-------------------+---------------------\n"
" f                | t                | t                | t          | "
"t        | f\n"
"\n"
"-- Example demonstrating difference between contains and contains properly\n"
"SELECT ST_GeometryType(geomA) As geomtype, ST_Contains(geomA,geomA) AS "
"acontainsa, ST_ContainsProperly(geomA, geomA) AS acontainspropa,\n"
"   ST_Contains(geomA, ST_Boundary(geomA)) As acontainsba, "
"ST_ContainsProperly(geomA, ST_Boundary(geomA)) As acontainspropba\n"
"FROM (VALUES ( ST_Buffer(ST_Point(1,1), 5,1) ),\n"
"                         ( ST_MakeLine(ST_Point(1,1), ST_Point(-1,-1) ) ),\n"
"                         ( ST_Point(1,1) )\n"
"          ) As foo(geomA);\n"
"\n"
"  geomtype    | acontainsa | acontainspropa | acontainsba | acontainspropba\n"
"--------------+------------+----------------+-------------"
"+-----------------\n"
"ST_Polygon    | t          | f              | f           | f\n"
"ST_LineString | t          | f              | f           | f\n"
"ST_Point      | t          | t              | f           | f"
msgstr ""

#. Tag: para
#: reference_measure.xml:1206
#, no-c-format
msgid ""
", <xref linkend=\"ST_ContainsProperly\"/>, <xref linkend=\"ST_Covers\"/>, "
"<xref linkend=\"ST_CoveredBy\"/>, <xref linkend=\"ST_Equals\"/>, <xref "
"linkend=\"ST_Within\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:1212
#, no-c-format
msgid "ST_ContainsProperly"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:1214
#, no-c-format
msgid ""
"Returns true if B intersects the interior of A but not the boundary (or "
"exterior). A does not contain properly itself, but does contain itself."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:1219
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_ContainsProperly</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1234
#, no-c-format
msgid ""
"Returns true if B intersects the interior of A but not the boundary (or "
"exterior)."
msgstr ""

#. Tag: para
#: reference_measure.xml:1236
#, no-c-format
msgid "A does not contain properly itself, but does contain itself."
msgstr ""

#. Tag: para
#: reference_measure.xml:1237
#, no-c-format
msgid ""
"Every point of the other geometry is a point of this geometry's interior. "
"The DE-9IM Intersection Matrix for the two geometries matches [T**FF*FF*] "
"used in <xref linkend=\"ST_Relate\"/>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1241
#, no-c-format
msgid ""
"From JTS docs slightly reworded: The advantage to using this predicate over "
"<xref linkend=\"ST_Contains\"/> and <xref linkend=\"ST_Intersects\"/> is "
"that it can be computed efficiently, with no need to compute topology at "
"individual points."
msgstr ""

#. Tag: para
#: reference_measure.xml:1243
#, no-c-format
msgid ""
"An example use case for this predicate is computing the intersections of a "
"set of geometries with a large polygonal geometry. Since intersection is a "
"fairly slow operation, it can be more efficient to use containsProperly to "
"filter out test geometries which lie wholly inside the area. In these cases "
"the intersection is known a priori to be exactly the original test geometry."
msgstr ""

#. Tag: para
#: reference_measure.xml:1253
#, no-c-format
msgid "Availability: 1.4.0 - requires GEOS &gt;= 3.1.0."
msgstr ""

#. Tag: para
#: reference_measure.xml:1263
#, no-c-format
msgid ""
"This function call will automatically include a bounding box comparison that "
"will make use of any indexes that are available on the geometries. To avoid "
"index use, use the function _ST_ContainsProperly."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1272
#, no-c-format
msgid ""
"--a circle within a circle\n"
"        SELECT ST_ContainsProperly(smallc, bigc) As smallcontainspropbig,\n"
"        ST_ContainsProperly(bigc,smallc) As bigcontainspropsmall,\n"
"        ST_ContainsProperly(bigc, ST_Union(smallc, bigc)) as "
"bigcontainspropunion,\n"
"        ST_Equals(bigc, ST_Union(smallc, bigc)) as bigisunion,\n"
"        ST_Covers(bigc, ST_ExteriorRing(bigc)) As bigcoversexterior,\n"
"        ST_ContainsProperly(bigc, ST_ExteriorRing(bigc)) As "
"bigcontainsexterior\n"
"        FROM (SELECT ST_Buffer(ST_GeomFromText('POINT(1 2)'), 10) As "
"smallc,\n"
"        ST_Buffer(ST_GeomFromText('POINT(1 2)'), 20) As bigc) As foo;\n"
"        --Result\n"
"  smallcontainspropbig | bigcontainspropsmall | bigcontainspropunion | "
"bigisunion | bigcoversexterior | bigcontainsexterior\n"
"------------------+------------------+------------------+------------"
"+-------------------+---------------------\n"
" f                     | t                    | f                    | "
"t          | t                 | f\n"
"\n"
" --example demonstrating difference between contains and contains properly\n"
" SELECT ST_GeometryType(geomA) As geomtype, ST_Contains(geomA,geomA) AS "
"acontainsa, ST_ContainsProperly(geomA, geomA) AS acontainspropa,\n"
" ST_Contains(geomA, ST_Boundary(geomA)) As acontainsba, "
"ST_ContainsProperly(geomA, ST_Boundary(geomA)) As acontainspropba\n"
" FROM (VALUES ( ST_Buffer(ST_Point(1,1), 5,1) ),\n"
"                  ( ST_MakeLine(ST_Point(1,1), ST_Point(-1,-1) ) ),\n"
"                  ( ST_Point(1,1) )\n"
"        ) As foo(geomA);\n"
"\n"
"  geomtype    | acontainsa | acontainspropa | acontainsba | acontainspropba\n"
"--------------+------------+----------------+-------------"
"+-----------------\n"
"ST_Polygon    | t          | f              | f           | f\n"
"ST_LineString | t          | f              | f           | f\n"
"ST_Point      | t          | t              | f           | f"
msgstr ""

#. Tag: para
#: reference_measure.xml:1277
#, no-c-format
msgid ""
", <xref linkend=\"ST_Boundary\"/>, <xref linkend=\"ST_Contains\"/>, <xref "
"linkend=\"ST_Covers\"/>, <xref linkend=\"ST_CoveredBy\"/>, <xref linkend="
"\"ST_Equals\"/>, <xref linkend=\"ST_Relate\"/>, <xref linkend=\"ST_Within\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:1283
#, no-c-format
msgid "ST_Covers"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:1285
#, no-c-format
msgid "Returns 1 (TRUE) if no point in Geometry B is outside Geometry A"
msgstr ""

#. Tag: funcsynopsis
#: reference_measure.xml:1290
#, no-c-format
msgid ""
"<funcprototype> <funcdef>boolean <function>ST_Covers</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>boolean <function>ST_Covers</"
"function></funcdef> <paramdef><type>geography </type> <parameter>geogpolyA</"
"parameter></paramdef> <paramdef><type>geography </type> "
"<parameter>geogpointB</parameter></paramdef> </funcprototype>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1315
#, no-c-format
msgid ""
"Returns 1 (TRUE) if no point in Geometry/Geography B is outside Geometry/"
"Geography A"
msgstr ""

#. Tag: para
#: reference_measure.xml:1325
#, no-c-format
msgid "For geography only Polygon covers point is supported."
msgstr ""

#. Tag: para
#: reference_measure.xml:1332
#, no-c-format
msgid ""
"This function call will automatically include a bounding box comparison that "
"will make use of any indexes that are available on the geometries. To avoid "
"index use, use the function _ST_Covers."
msgstr ""

#. Tag: para
#: reference_measure.xml:1337 reference_measure.xml:3704
#, no-c-format
msgid ""
"Enhanced: 2.3.0 Enhancement to PIP short-circuit for geometry extended to "
"support MultiPoints with few points. Prior versions only supported point in "
"polygon."
msgstr ""

#. Tag: para
#: reference_measure.xml:1338
#, no-c-format
msgid "Availability: 1.5 - support for geography was introduced."
msgstr ""

#. Tag: para
#: reference_measure.xml:1339 reference_measure.xml:1410
#, no-c-format
msgid "Availability: 1.2.2 - requires GEOS &gt;= 3.0"
msgstr ""

#. Tag: para
#: reference_measure.xml:1344 reference_measure.xml:1419
#, no-c-format
msgid "Not an OGC standard, but Oracle has it too."
msgstr ""

#. Tag: para
#: reference_measure.xml:1351
#, no-c-format
msgid "Geometry example"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1352
#, no-c-format
msgid ""
"--a circle covering a circle\n"
"SELECT ST_Covers(smallc,smallc) As smallinsmall,\n"
"        ST_Covers(smallc, bigc) As smallcoversbig,\n"
"        ST_Covers(bigc, ST_ExteriorRing(bigc)) As bigcoversexterior,\n"
"        ST_Contains(bigc, ST_ExteriorRing(bigc)) As bigcontainsexterior\n"
"FROM (SELECT ST_Buffer(ST_GeomFromText('POINT(1 2)'), 10) As smallc,\n"
"        ST_Buffer(ST_GeomFromText('POINT(1 2)'), 20) As bigc) As foo;\n"
"        --Result\n"
" smallinsmall | smallcoversbig | bigcoversexterior | bigcontainsexterior\n"
"--------------+----------------+-------------------+---------------------\n"
" t            | f              | t                 | f\n"
"(1 row)"
msgstr ""

#. Tag: para
#: reference_measure.xml:1353
#, no-c-format
msgid "Geeography Example"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1354
#, no-c-format
msgid ""
"-- a point with a 300 meter buffer compared to a point, a point and its 10 "
"meter buffer\n"
"SELECT ST_Covers(geog_poly, geog_pt) As poly_covers_pt,\n"
"        ST_Covers(ST_Buffer(geog_pt,10), geog_pt) As buff_10m_covers_cent\n"
"        FROM (SELECT ST_Buffer(ST_GeogFromText('SRID=4326;POINT(-99.327 "
"31.4821)'), 300) As geog_poly,\n"
"                                ST_GeogFromText('SRID=4326;POINT(-99.33 "
"31.483)') As geog_pt ) As foo;\n"
"\n"
" poly_covers_pt | buff_10m_covers_cent\n"
"----------------+------------------\n"
" f              | t"
msgstr ""

#. Tag: para
#: reference_measure.xml:1359
#, no-c-format
msgid ", <xref linkend=\"ST_CoveredBy\"/>, <xref linkend=\"ST_Within\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:1365
#, no-c-format
msgid "ST_CoveredBy"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:1367
#, no-c-format
msgid ""
"<refpurpose>Returns 1 (TRUE) if no point in Geometry/Geography A is outside "
"Geometry/Geography B</refpurpose>"
msgstr ""

#. Tag: funcsynopsis
#: reference_measure.xml:1372
#, no-c-format
msgid ""
"<funcprototype> <funcdef>boolean <function>ST_CoveredBy</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>boolean <function>ST_CoveredBy</"
"function></funcdef> <paramdef><type>geography </type> <parameter>geogA</"
"parameter></paramdef> <paramdef><type>geography </type> <parameter>geogB</"
"parameter></paramdef> </funcprototype>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1398
#, no-c-format
msgid ""
"<para>Returns 1 (TRUE) if no point in Geometry/Geography A is outside "
"Geometry/Geography B</para>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1411
#, no-c-format
msgid ""
"This function call will automatically include a bounding box comparison that "
"will make use of any indexes that are available on the geometries. To avoid "
"index use, use the function _ST_CoveredBy."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1426
#, no-c-format
msgid ""
"--a circle coveredby a circle\n"
"SELECT ST_CoveredBy(smallc,smallc) As smallinsmall,\n"
"        ST_CoveredBy(smallc, bigc) As smallcoveredbybig,\n"
"        ST_CoveredBy(ST_ExteriorRing(bigc), bigc) As exteriorcoveredbybig,\n"
"        ST_Within(ST_ExteriorRing(bigc),bigc) As exeriorwithinbig\n"
"FROM (SELECT ST_Buffer(ST_GeomFromText('POINT(1 2)'), 10) As smallc,\n"
"        ST_Buffer(ST_GeomFromText('POINT(1 2)'), 20) As bigc) As foo;\n"
"        --Result\n"
" smallinsmall | smallcoveredbybig | exteriorcoveredbybig | exeriorwithinbig\n"
"--------------+-------------------+----------------------"
"+------------------\n"
" t            | t                 | t                    | f\n"
"(1 row)"
msgstr ""

#. Tag: para
#: reference_measure.xml:1431
#, no-c-format
msgid ""
", <xref linkend=\"ST_Covers\"/>, <xref linkend=\"ST_ExteriorRing\"/>, <xref "
"linkend=\"ST_Within\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:1437
#, no-c-format
msgid "ST_Crosses"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:1439
#, no-c-format
msgid ""
"Returns <varname>TRUE</varname> if the supplied geometries have some, but "
"not all, interior points in common."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:1445
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_Crosses</function></funcdef> "
"<paramdef><type>geometry </type><parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type><parameter>g2</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1458
#, no-c-format
msgid ""
"<function>ST_Crosses</function> takes two geometry objects and returns "
"<varname>TRUE</varname> if their intersection \"spatially cross\", that is, "
"the geometries have some, but not all interior points in common. The "
"intersection of the interiors of the geometries must not be the empty set "
"and must have a dimensionality less than the maximum dimension of the two "
"input geometries. Additionally, the intersection of the two geometries must "
"not equal either of the source geometries. Otherwise, it returns "
"<varname>FALSE</varname>."
msgstr ""

#. Tag: para
#: reference_measure.xml:1467
#, no-c-format
msgid "In mathematical terms, this is expressed as:"
msgstr ""

#. Tag: remark
#: reference_measure.xml:1469
#, no-c-format
msgid ""
"TODO: Insert appropriate MathML markup here or use a gif. Simple HTML markup "
"does not work well in both IE and Firefox."
msgstr ""

#. Tag: para
#: reference_measure.xml:1480
#, no-c-format
msgid "The DE-9IM Intersection Matrix for the two geometries is:"
msgstr ""

#. Tag: para
#: reference_measure.xml:1484
#, no-c-format
msgid ""
"<markup>T*T******</markup> (for Point/Line, Point/Area, and Line/Area "
"situations)"
msgstr ""

#. Tag: para
#: reference_measure.xml:1489
#, no-c-format
msgid ""
"<markup>T*****T**</markup> (for Line/Point, Area/Point, and Area/Line "
"situations)"
msgstr ""

#. Tag: para
#: reference_measure.xml:1494
#, no-c-format
msgid "<markup>0********</markup> (for Line/Line situations)"
msgstr ""

#. Tag: para
#: reference_measure.xml:1498
#, no-c-format
msgid "For any other combination of dimensions this predicate returns false."
msgstr ""

#. Tag: para
#: reference_measure.xml:1501
#, no-c-format
msgid ""
"The OpenGIS Simple Features Specification defines this predicate only for "
"Point/Line, Point/Area, Line/Line, and Line/Area situations. JTS / GEOS "
"extends the definition to apply to Line/Point, Area/Point and Area/Line "
"situations as well. This makes the relation symmetric."
msgstr ""

#. Tag: para
#: reference_measure.xml:1517
#, no-c-format
msgid "&sfs_compliant; s2.1.13.3"
msgstr ""

#. Tag: para
#: reference_measure.xml:1518
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 5.1.29"
msgstr ""

#. Tag: para
#: reference_measure.xml:1524 reference_measure.xml:3055
#, no-c-format
msgid "The following illustrations all return <varname>TRUE</varname>."
msgstr ""

#. Tag: para
#: reference_measure.xml:1536
#, no-c-format
msgid "<varname>MULTIPOINT</varname> / <varname>LINESTRING</varname>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1546
#, no-c-format
msgid "<varname>MULTIPOINT</varname> / <varname>POLYGON</varname>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1558
#, no-c-format
msgid "<varname>LINESTRING</varname> / <varname>POLYGON</varname>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1568 reference_measure.xml:3075
#: reference_measure.xml:3641 reference_measure.xml:3651
#, no-c-format
msgid "<varname>LINESTRING</varname> / <varname>LINESTRING</varname>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1576
#, no-c-format
msgid ""
"Consider a situation where a user has two tables: a table of roads and a "
"table of highways."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1584
#, no-c-format
msgid ""
"CREATE TABLE roads (\n"
"  id serial NOT NULL,\n"
"  the_geom geometry,\n"
"  CONSTRAINT roads_pkey PRIMARY KEY (road_id)\n"
");"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1588
#, no-c-format
msgid ""
"CREATE TABLE highways (\n"
"  id serial NOT NULL,\n"
"  the_gem geometry,\n"
"  CONSTRAINT roads_pkey PRIMARY KEY (road_id)\n"
");"
msgstr ""

#. Tag: para
#: reference_measure.xml:1595
#, no-c-format
msgid ""
"To determine a list of roads that cross a highway, use a query similiar to:"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1599
#, no-c-format
msgid ""
"SELECT roads.id\n"
"FROM roads, highways\n"
"WHERE ST_Crosses(roads.the_geom, highways.the_geom);"
msgstr ""

#. Tag: refname
#: reference_measure.xml:1606
#, no-c-format
msgid "ST_LineCrossingDirection"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:1608
#, no-c-format
msgid ""
"Given 2 linestrings, returns a number between -3 and 3 denoting what kind of "
"crossing behavior. 0 is no crossing."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:1613
#, no-c-format
msgid ""
"<funcdef>integer <function>ST_LineCrossingDirection</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>linestringA</parameter></"
"paramdef> <paramdef><type>geometry </type> <parameter>linestringB</"
"parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1624
#, no-c-format
msgid ""
"Given 2 linestrings, returns a number between -3 and 3 denoting what kind of "
"crossing behavior. 0 is no crossing. This is only supported for "
"<varname>LINESTRING</varname>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1625
#, no-c-format
msgid "Definition of integer constants is as follows:"
msgstr ""

#. Tag: para
#: reference_measure.xml:1628
#, no-c-format
msgid "0: LINE NO CROSS"
msgstr ""

#. Tag: para
#: reference_measure.xml:1631
#, no-c-format
msgid "-1: LINE CROSS LEFT"
msgstr ""

#. Tag: para
#: reference_measure.xml:1634
#, no-c-format
msgid "1: LINE CROSS RIGHT"
msgstr ""

#. Tag: para
#: reference_measure.xml:1637
#, no-c-format
msgid "-2: LINE MULTICROSS END LEFT"
msgstr ""

#. Tag: para
#: reference_measure.xml:1640
#, no-c-format
msgid "2: LINE MULTICROSS END RIGHT"
msgstr ""

#. Tag: para
#: reference_measure.xml:1643
#, no-c-format
msgid "-3: LINE MULTICROSS END SAME FIRST LEFT"
msgstr ""

#. Tag: para
#: reference_measure.xml:1646
#, no-c-format
msgid "3: LINE MULTICROSS END SAME FIRST RIGHT"
msgstr ""

#. Tag: para
#: reference_measure.xml:1650
#, no-c-format
msgid "Availability: 1.4"
msgstr ""

#. Tag: para
#: reference_measure.xml:1668
#, no-c-format
msgid ""
"Line 1 (green), Line 2 ball is start point, triangle are end points. Query "
"below."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1672
#, no-c-format
msgid ""
"SELECT ST_LineCrossingDirection(foo.line1, foo.line2) As l1_cross_l2 ,\n"
"          ST_LineCrossingDirection(foo.line2, foo.line1) As l2_cross_l1\n"
"FROM (\n"
"SELECT\n"
" ST_GeomFromText('LINESTRING(25 169,89 114,40 70,86 43)') As line1,\n"
" ST_GeomFromText('LINESTRING(171 154,20 140,71 74,161 53)') As line2\n"
"        ) As foo;\n"
"\n"
" l1_cross_l2 | l2_cross_l1\n"
"-------------+-------------\n"
"           3 |          -3"
msgstr ""

#. Tag: para
#: reference_measure.xml:1682 reference_measure.xml:1696
#: reference_measure.xml:1710
#, no-c-format
msgid ""
"Line 1 (green), Line 2 (blue) ball is start point, triangle are end points. "
"Query below."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1686
#, no-c-format
msgid ""
"SELECT ST_LineCrossingDirection(foo.line1, foo.line2) As l1_cross_l2 ,\n"
"          ST_LineCrossingDirection(foo.line2, foo.line1) As l2_cross_l1\n"
"FROM (\n"
" SELECT\n"
"  ST_GeomFromText('LINESTRING(25 169,89 114,40 70,86 43)') As line1,\n"
"  ST_GeomFromText('LINESTRING (171 154, 20 140, 71 74, 2.99 90.16)') As "
"line2\n"
") As foo;\n"
"\n"
" l1_cross_l2 | l2_cross_l1\n"
"-------------+-------------\n"
"           2 |          -2"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1700
#, no-c-format
msgid ""
"SELECT\n"
"        ST_LineCrossingDirection(foo.line1, foo.line2) As l1_cross_l2 ,\n"
"        ST_LineCrossingDirection(foo.line2, foo.line1) As l2_cross_l1\n"
"FROM (\n"
" SELECT\n"
"  ST_GeomFromText('LINESTRING(25 169,89 114,40 70,86 43)') As line1,\n"
"  ST_GeomFromText('LINESTRING (20 140, 71 74, 161 53)') As line2\n"
"  ) As foo;\n"
"\n"
" l1_cross_l2 | l2_cross_l1\n"
"-------------+-------------\n"
"          -1 |          1"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1714
#, no-c-format
msgid ""
"SELECT ST_LineCrossingDirection(foo.line1, foo.line2) As l1_cross_l2 ,\n"
"          ST_LineCrossingDirection(foo.line2, foo.line1) As l2_cross_l1\n"
"FROM (SELECT\n"
"        ST_GeomFromText('LINESTRING(25 169,89 114,40 70,86 43)') As line1,\n"
"        ST_GeomFromText('LINESTRING(2.99 90.16,71 74,20 140,171 154)') As "
"line2\n"
"        ) As foo;\n"
"\n"
" l1_cross_l2 | l2_cross_l1\n"
"-------------+-------------\n"
"          -2 |          2"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1722
#, no-c-format
msgid ""
"SELECT s1.gid, s2.gid, ST_LineCrossingDirection(s1.the_geom, s2.the_geom)\n"
"        FROM streets s1 CROSS JOIN streets s2 ON (s1.gid != s2.gid AND s1."
"the_geom &amp;&amp; s2.the_geom )\n"
"WHERE ST_CrossingDirection(s1.the_geom, s2.the_geom) > 0;"
msgstr ""

#. Tag: refname
#: reference_measure.xml:1735
#, no-c-format
msgid "ST_Disjoint"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:1737
#, no-c-format
msgid ""
"Returns TRUE if the Geometries do not \"spatially intersect\" - if they do "
"not share any space together."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:1743
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_Disjoint</function></funcdef> <paramdef> "
"<type>geometry</type> <parameter>A</parameter> </paramdef> <paramdef> "
"<type>geometry</type> <parameter>B</parameter> </paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1758
#, no-c-format
msgid ""
"Overlaps, Touches, Within all imply geometries are not spatially disjoint. "
"If any of the aforementioned returns true, then the geometries are not "
"spatially disjoint. Disjoint implies false for spatial intersection."
msgstr ""

#. Tag: para
#: reference_measure.xml:1768
#, no-c-format
msgid "This function call does not use indexes"
msgstr ""

#. Tag: para
#: reference_measure.xml:1775
#, no-c-format
msgid "&sfs_compliant; s2.1.1.2 //s2.1.13.3 - a.Relate(b, 'FF*FF****')"
msgstr ""

#. Tag: para
#: reference_measure.xml:1777
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 5.1.26"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1782
#, no-c-format
msgid ""
"SELECT ST_Disjoint('POINT(0 0)'::geometry, 'LINESTRING ( 2 0, 0 2 )'::"
"geometry);\n"
" st_disjoint\n"
"---------------\n"
" t\n"
"(1 row)\n"
"SELECT ST_Disjoint('POINT(0 0)'::geometry, 'LINESTRING ( 0 0, 0 2 )'::"
"geometry);\n"
" st_disjoint\n"
"---------------\n"
" f\n"
"(1 row)"
msgstr ""

#. Tag: para
#: reference_measure.xml:1787
#, no-c-format
msgid "<para>ST_Intersects</para>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:1793
#, no-c-format
msgid "ST_Distance"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:1795
#, no-c-format
msgid ""
"For geometry type Returns the 2D Cartesian distance between two geometries "
"in projected units (based on spatial ref). For geography type defaults to "
"return minimum geodesic distance between two geographies in meters."
msgstr ""

#. Tag: funcsynopsis
#: reference_measure.xml:1799
#, no-c-format
msgid ""
"<funcprototype> <funcdef>float <function>ST_Distance</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>float <function>ST_Distance</"
"function></funcdef> <paramdef><type>geography </type> <parameter>gg1</"
"parameter></paramdef> <paramdef><type>geography </type> <parameter>gg2</"
"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>float "
"<function>ST_Distance</function></funcdef> <paramdef><type>geography </type> "
"<parameter>gg1</parameter></paramdef> <paramdef><type>geography </type> "
"<parameter>gg2</parameter></paramdef> <paramdef><type>boolean </type> "
"<parameter>use_spheroid</parameter></paramdef> </funcprototype>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1837
#, no-c-format
msgid ""
"For geometry type returns the minimum 2D Cartesian distance between two "
"geometries in projected units (spatial ref units). For geography type "
"defaults to return the minimum geodesic distance between two geographies in "
"meters. If use_spheroid is false, a faster sphere calculation is used "
"instead of a spheroid."
msgstr ""

#. Tag: para
#: reference_measure.xml:1842
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 5.1.23"
msgstr ""

#. Tag: para
#: reference_measure.xml:1843 reference_measure.xml:2543
#, no-c-format
msgid "&curve_support;"
msgstr ""

#. Tag: para
#: reference_measure.xml:1846
#, no-c-format
msgid ""
"Availability: 1.5.0 geography support was introduced in 1.5. Speed "
"improvements for planar to better handle large or many vertex geometries"
msgstr ""

#. Tag: para
#: reference_measure.xml:1847
#, no-c-format
msgid ""
"Enhanced: 2.1.0 improved speed for geography. See <ulink url=\"http://"
"boundlessgeo.com/2012/07/making-geography-faster/\">Making Geography faster</"
"ulink> for details."
msgstr ""

#. Tag: para
#: reference_measure.xml:1848
#, no-c-format
msgid "Enhanced: 2.1.0 - support for curved geometries was introduced."
msgstr ""

#. Tag: title
#: reference_measure.xml:1853
#, no-c-format
msgid "Basic Geometry Examples"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1855
#, no-c-format
msgid ""
"--Geometry example - units in planar degrees 4326 is WGS 84 long lat "
"unit=degrees\n"
"SELECT ST_Distance(\n"
"                ST_GeomFromText('POINT(-72.1235 42.3521)',4326),\n"
"                ST_GeomFromText('LINESTRING(-72.1260 42.45, -72.123 "
"42.1546)', 4326)\n"
"        );\n"
"st_distance\n"
"-----------------\n"
"0.00150567726382282\n"
"\n"
"-- Geometry example - units in meters (SRID: 26986 Massachusetts state plane "
"meters) (most accurate for Massachusetts)\n"
"SELECT ST_Distance(\n"
"                        ST_Transform(ST_GeomFromText('POINT(-72.1235 "
"42.3521)',4326),26986),\n"
"                        ST_Transform(ST_GeomFromText('LINESTRING(-72.1260 "
"42.45, -72.123 42.1546)', 4326),26986)\n"
"                );\n"
"st_distance\n"
"-----------------\n"
"123.797937878454\n"
"\n"
"-- Geometry example - units in meters (SRID: 2163 US National Atlas Equal "
"area) (least accurate)\n"
"SELECT ST_Distance(\n"
"                        ST_Transform(ST_GeomFromText('POINT(-72.1235 "
"42.3521)',4326),2163),\n"
"                        ST_Transform(ST_GeomFromText('LINESTRING(-72.1260 "
"42.45, -72.123 42.1546)', 4326),2163)\n"
"                );\n"
"\n"
"st_distance\n"
"------------------\n"
"126.664256056812"
msgstr ""

#. Tag: title
#: reference_measure.xml:1858 reference_measure.xml:2636
#: reference_measure.xml:2690
#, no-c-format
msgid "Geography Examples"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1859
#, no-c-format
msgid ""
"-- same as geometry example but note units in meters - use sphere for "
"slightly faster less accurate\n"
"SELECT ST_Distance(gg1, gg2) As spheroid_dist, ST_Distance(gg1, gg2, false) "
"As sphere_dist\n"
"FROM (SELECT\n"
"        ST_GeogFromText('SRID=4326;POINT(-72.1235 42.3521)') As gg1,\n"
"        ST_GeogFromText('SRID=4326;LINESTRING(-72.1260 42.45, -72.123 "
"42.1546)') As gg2\n"
"        ) As foo  ;\n"
"\n"
"  spheroid_dist   |   sphere_dist\n"
"------------------+------------------\n"
" 123.802076746848 | 123.475736916397"
msgstr ""

#. Tag: para
#: reference_measure.xml:1867
#, no-c-format
msgid ""
", <xref linkend=\"ST_DWithin\"/>, <xref linkend=\"ST_DistanceSphere\"/>, "
"<xref linkend=\"ST_Distance_Spheroid\"/>, <xref linkend=\"ST_MaxDistance\"/"
">, <xref linkend=\"ST_Transform\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:1873
#, no-c-format
msgid "ST_MinimumClearance"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:1874
#, no-c-format
msgid ""
"Returns the minimum clearance of a geometry, a measure of a geometry's "
"robustness."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:1879
#, no-c-format
msgid ""
"<funcdef>float <function>ST_MinimumClearance</function></funcdef> "
"<paramdef><type>geometry </type><parameter>g</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1889
#, no-c-format
msgid ""
"It is not uncommon to have a geometry that, while meeting the criteria for "
"validity according to ST_IsValid (polygons) or ST_IsSimple (lines), would "
"become invalid if one of the vertices moved by a slight distance, as can "
"happen during conversion to text-based formats (such as WKT, KML, GML "
"GeoJSON), or binary formats that do not use double-precision floating point "
"coordinates (MapInfo TAB)."
msgstr ""

#. Tag: para
#: reference_measure.xml:1896
#, no-c-format
msgid ""
"A geometry's \"minimum clearance\" is the smallest distance by which a "
"vertex of the geometry could be moved to produce an invalid geometry. It can "
"be thought of as a quantitative measure of a geometry's robustness, where "
"increasing values of minimum clearance indicate increasing robustness."
msgstr ""

#. Tag: para
#: reference_measure.xml:1902
#, no-c-format
msgid ""
"If a geometry has a minimum clearance of <varname>e</varname>, it can be "
"said that:"
msgstr ""

#. Tag: para
#: reference_measure.xml:1906
#, no-c-format
msgid ""
"No two distinct vertices in the geometry are separated by less than "
"<varname>e</varname>."
msgstr ""

#. Tag: para
#: reference_measure.xml:1911
#, no-c-format
msgid ""
"No vertex is closer than <varname>e</varname> to a line segement of which it "
"is not an endpoint."
msgstr ""

#. Tag: para
#: reference_measure.xml:1918
#, no-c-format
msgid ""
"If no minimum clearance exists for a geometry (for example, a single point, "
"or a multipoint whose points are identical), then ST_MinimumClearance will "
"return Infinity."
msgstr ""

#. Tag: para
#: reference_measure.xml:1923 reference_measure.xml:1968
#, no-c-format
msgid "Availability: 2.3.0 - requires GEOS &gt;= 3.6.0"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1929
#, no-c-format
msgid ""
"SELECT ST_MinimumClearance('POLYGON ((0 0, 1 0, 1 1, 0.5 3.2e-4, 0 0))');\n"
" st_minimumclearance\n"
"---------------------\n"
"             0.00032"
msgstr ""

#. Tag: refname
#: reference_measure.xml:1944
#, no-c-format
msgid "ST_MinimumClearanceLine"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:1945
#, no-c-format
msgid ""
"Returns the two-point LineString spanning a geometry's minimum clearance."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:1950
#, no-c-format
msgid ""
"<funcdef>Geometry <function>ST_MinimumClearanceLine</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:1963
#, no-c-format
msgid ""
"Returns the two-point LineString spanning a geometry's minimum clearance. If "
"the geometry does not have a minimum clearance, <varname>LINESTRING EMPTY</"
"varname> will be returned."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:1974
#, no-c-format
msgid ""
"SELECT ST_AsText(ST_MinimumClearanceLine('POLYGON ((0 0, 1 0, 1 1, 0.5 "
"3.2e-4, 0 0))'));\n"
"st_astext\n"
"-------------------------------\n"
"LINESTRING(0.5 0.00032,0.5 0)"
msgstr ""

#. Tag: refname
#: reference_measure.xml:1990
#, no-c-format
msgid "ST_HausdorffDistance"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:1992
#, no-c-format
msgid ""
"Returns the Hausdorff distance between two geometries. Basically a measure "
"of how similar or dissimilar 2 geometries are. Units are in the units of the "
"spatial reference system of the geometries."
msgstr ""

#. Tag: funcsynopsis
#: reference_measure.xml:1997
#, no-c-format
msgid ""
"<funcprototype> <funcdef>float <function>ST_HausdorffDistance</function></"
"funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></"
"paramdef> <paramdef><type>geometry </type> <parameter>g2</parameter></"
"paramdef> </funcprototype> <funcprototype> <funcdef>float "
"<function>ST_HausdorffDistance</function></funcdef> <paramdef><type>geometry "
"</type> <parameter>g1</parameter></paramdef> <paramdef><type>geometry </"
"type> <parameter>g2</parameter></paramdef> <paramdef><type>float</type> "
"<parameter>densifyFrac</parameter></paramdef> </funcprototype>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2025
#, no-c-format
msgid ""
"Implements algorithm for computing a distance metric which can be thought of "
"as the \"Discrete Hausdorff Distance\". This is the Hausdorff distance "
"restricted to discrete points for one of the geometries. <ulink url=\"http://"
"en.wikipedia.org/wiki/Hausdorff_distance\">Wikipedia article on Hausdorff "
"distance</ulink> <ulink url=\"http://lin-ear-th-inking.blogspot.com/2009/01/"
"computing-geometric-similarity.html\">Martin Davis note on how Hausdorff "
"Distance calculation was used to prove correctness of the "
"CascadePolygonUnion approach.</ulink>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2028
#, no-c-format
msgid ""
"When densifyFrac is specified, this function performs a segment "
"densification before computing the discrete hausdorff distance. The "
"densifyFrac parameter sets the fraction by which to densify each segment. "
"Each segment will be split into a number of equal-length subsegments, whose "
"fraction of the total length is closest to the given fraction."
msgstr ""

#. Tag: para
#: reference_measure.xml:2033
#, no-c-format
msgid ""
"The current implementation supports only vertices as the discrete locations. "
"This could be extended to allow an arbitrary density of points to be used."
msgstr ""

#. Tag: para
#: reference_measure.xml:2038
#, no-c-format
msgid ""
"This algorithm is NOT equivalent to the standard Hausdorff distance. "
"However, it computes an approximation that is correct for a large subset of "
"useful cases. One important part of this subset is Linestrings that are "
"roughly parallel to each other, and roughly equal in length. This is a "
"useful metric for line matching."
msgstr ""

#. Tag: para
#: reference_measure.xml:2043
#, no-c-format
msgid "Availability: 1.5.0 - requires GEOS &gt;= 3.2.0"
msgstr ""

#. Tag: para
#: reference_measure.xml:2049
#, no-c-format
msgid ""
"For each building, find the parcel that best represents it. First we require "
"the parcel intersect with the geometry. DISTINCT ON guarantees we get each "
"building listed only once, the ORDER BY .. ST_HausdorffDistance gives us a "
"preference of parcel that is most similar to the building."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2051
#, no-c-format
msgid ""
"SELECT DISTINCT ON(buildings.gid) buildings.gid, parcels.parcel_id\n"
"   FROM buildings INNER JOIN parcels ON ST_Intersects(buildings.geom,parcels."
"geom)\n"
"     ORDER BY buildings.gid, ST_HausdorffDistance(buildings.geom, parcels."
"geom);"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2053
#, no-c-format
msgid ""
"postgis=# SELECT ST_HausdorffDistance(\n"
"                                'LINESTRING (0 0, 2 0)'::geometry,\n"
"                                'MULTIPOINT (0 1, 1 0, 2 1)'::geometry);\n"
" st_hausdorffdistance\n"
" ----------------------\n"
"                                         1\n"
"(1 row)"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2054
#, no-c-format
msgid ""
"postgis=# SELECT st_hausdorffdistance('LINESTRING (130 0, 0 0, 0 150)'::"
"geometry, 'LINESTRING (10 10, 10 150, 130 10)'::geometry, 0.5);\n"
" st_hausdorffdistance\n"
" ----------------------\n"
"                                        70\n"
"(1 row)"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2061
#, no-c-format
msgid "ST_MaxDistance"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2063
#, no-c-format
msgid ""
"Returns the 2-dimensional largest distance between two geometries in "
"projected units."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:2069
#, no-c-format
msgid ""
"<funcdef>float <function>ST_MaxDistance</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2082
#, no-c-format
msgid ""
"Returns the 2-dimensional maximum distance between two geometries in "
"projected units. If g1 and g2 is the same geometry the function will return "
"the distance between the two vertices most far from each other in that "
"geometry."
msgstr ""

#. Tag: para
#: reference_measure.xml:2092
#, no-c-format
msgid "Basic furthest distance the point is to any part of the line"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2093
#, no-c-format
msgid ""
"postgis=# SELECT ST_MaxDistance('POINT(0 0)'::geometry, 'LINESTRING ( 2 0, 0 "
"2 )'::geometry);\n"
"   st_maxdistance\n"
"-----------------\n"
" 2\n"
"(1 row)\n"
"\n"
"postgis=# SELECT ST_MaxDistance('POINT(0 0)'::geometry, 'LINESTRING ( 2 2, 2 "
"2 )'::geometry);\n"
"  st_maxdistance\n"
"------------------\n"
" 2.82842712474619\n"
"(1 row)"
msgstr ""

#. Tag: para
#: reference_measure.xml:2099
#, no-c-format
msgid ""
", <xref linkend=\"ST_LongestLine\"/>, <xref linkend=\"ST_DFullyWithin\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2105
#, no-c-format
msgid "ST_DistanceSphere"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2107
#, no-c-format
msgid ""
"Returns minimum distance in meters between two lon/lat geometries. Uses a "
"spherical earth and radius derived from the spheroid defined by the SRID. "
"Faster than ST_DistanceSpheroid <xref linkend=\"ST_Distance_Spheroid\"/>, "
"but less accurate. PostGIS versions prior to 1.5 only implemented for points."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:2116
#, no-c-format
msgid ""
"<funcdef>float <function>ST_DistanceSphere</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geomlonlatA</parameter></"
"paramdef> <paramdef><type>geometry </type> <parameter>geomlonlatB</"
"parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2127
#, no-c-format
msgid ""
"Returns minimum distance in meters between two lon/lat points. Uses a "
"spherical earth and radius derived from the spheroid defined by the SRID. "
"Faster than <xref linkend=\"ST_Distance_Spheroid\"/>, but less accurate. "
"PostGIS Versions prior to 1.5 only implemented for points."
msgstr ""

#. Tag: para
#: reference_measure.xml:2133 reference_measure.xml:2182
#, no-c-format
msgid ""
"Availability: 1.5 - support for other geometry types besides points was "
"introduced. Prior versions only work with points."
msgstr ""

#. Tag: para
#: reference_measure.xml:2134
#, no-c-format
msgid ""
"Changed: 2.2.0 In prior versions this used to be called ST_Distance_Sphere"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2141
#, no-c-format
msgid ""
"SELECT round(CAST(ST_DistanceSphere(ST_Centroid(the_geom), "
"ST_GeomFromText('POINT(-118 38)',4326)) As numeric),2) As dist_meters,\n"
"round(CAST(ST_Distance(ST_Transform(ST_Centroid(the_geom),32611),\n"
"                ST_Transform(ST_GeomFromText('POINT(-118 38)', 4326),32611)) "
"As numeric),2) As dist_utm11_meters,\n"
"round(CAST(ST_Distance(ST_Centroid(the_geom), ST_GeomFromText('POINT(-118 "
"38)', 4326)) As numeric),5) As dist_degrees,\n"
"round(CAST(ST_Distance(ST_Transform(the_geom,32611),\n"
"                ST_Transform(ST_GeomFromText('POINT(-118 38)', 4326),32611)) "
"As numeric),2) As min_dist_line_point_meters\n"
"FROM\n"
"        (SELECT ST_GeomFromText('LINESTRING(-118.584 38.374,-118.583 38.5)', "
"4326) As the_geom) as foo;\n"
"         dist_meters | dist_utm11_meters | dist_degrees | "
"min_dist_line_point_meters\n"
"        -------------+-------------------+--------------"
"+----------------------------\n"
"                70424.47 |          70438.00 |      0.72900 "
"|                   65871.18"
msgstr ""

#. Tag: para
#: reference_measure.xml:2148
#, no-c-format
msgid ", <xref linkend=\"ST_Distance_Spheroid\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2154
#, no-c-format
msgid "ST_DistanceSpheroid"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2156
#, no-c-format
msgid ""
"Returns the minimum distance between two lon/lat geometries given a "
"particular spheroid. PostGIS versions prior to 1.5 only support points."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:2163
#, no-c-format
msgid ""
"<funcdef>float <function>ST_DistanceSpheroid</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geomlonlatA</parameter></"
"paramdef> <paramdef><type>geometry </type> <parameter>geomlonlatB</"
"parameter></paramdef> <paramdef><type>spheroid </type> "
"<parameter>measurement_spheroid</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2175
#, no-c-format
msgid ""
"Returns minimum distance in meters between two lon/lat geometries given a "
"particular spheroid. See the explanation of spheroids given for <xref "
"linkend=\"ST_Length_Spheroid\"/>. PostGIS version prior to 1.5 only support "
"points."
msgstr ""

#. Tag: para
#: reference_measure.xml:2179
#, no-c-format
msgid ""
"This function currently does not look at the SRID of a geometry and will "
"always assume its represented in the coordinates of the passed in spheroid. "
"Prior versions of this function only support points."
msgstr ""

#. Tag: para
#: reference_measure.xml:2183
#, no-c-format
msgid ""
"Changed: 2.2.0 In prior versions this used to be called ST_Distance_Spheroid"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2190
#, no-c-format
msgid ""
"SELECT round(CAST(\n"
"                ST_DistanceSpheroid(ST_Centroid(the_geom), "
"ST_GeomFromText('POINT(-118 38)',4326), 'SPHEROID[\"WGS "
"84\",6378137,298.257223563]')\n"
"                        As numeric),2) As dist_meters_spheroid,\n"
"                round(CAST(ST_DistanceSphere(ST_Centroid(the_geom), "
"ST_GeomFromText('POINT(-118 38)',4326)) As numeric),2) As "
"dist_meters_sphere,\n"
"round(CAST(ST_Distance(ST_Transform(ST_Centroid(the_geom),32611),\n"
"                ST_Transform(ST_GeomFromText('POINT(-118 38)', 4326),32611)) "
"As numeric),2) As dist_utm11_meters\n"
"FROM\n"
"        (SELECT ST_GeomFromText('LINESTRING(-118.584 38.374,-118.583 38.5)', "
"4326) As the_geom) as foo;\n"
" dist_meters_spheroid | dist_meters_sphere | dist_utm11_meters\n"
"----------------------+--------------------+-------------------\n"
"                         70454.92 |           70424.47 |          70438.00"
msgstr ""

#. Tag: para
#: reference_measure.xml:2197
#, no-c-format
msgid ", <xref linkend=\"ST_DistanceSphere\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2203
#, no-c-format
msgid "ST_DFullyWithin"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2205
#, no-c-format
msgid ""
"Returns true if all of the geometries are within the specified distance of "
"one another"
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:2211
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_DFullyWithin</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> "
"<paramdef><type>double precision </type> <parameter>distance</parameter></"
"paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2229
#, no-c-format
msgid ""
"Returns true if the geometries is fully within the specified distance of one "
"another. The distance is specified in units defined by the spatial reference "
"system of the geometries. For this function to make sense, the source "
"geometries must both be of the same coordinate projection, having the same "
"SRID."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2246
#, no-c-format
msgid ""
"postgis=# SELECT ST_DFullyWithin(geom_a, geom_b, 10) as DFullyWithin10, "
"ST_DWithin(geom_a, geom_b, 10) as DWithin10, ST_DFullyWithin(geom_a, geom_b, "
"20) as DFullyWithin20 from\n"
"                (select ST_GeomFromText('POINT(1 1)') as geom_a,"
"ST_GeomFromText('LINESTRING(1 5, 2 7, 1 9, 14 12)') as geom_b) t1;\n"
"\n"
"-----------------\n"
" DFullyWithin10 | DWithin10 | DFullyWithin20 |\n"
"---------------+----------+---------------+\n"
" f             | t        | t             |"
msgstr ""

#. Tag: para
#: reference_measure.xml:2252
#, no-c-format
msgid ", <xref linkend=\"ST_DWithin\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2258
#, no-c-format
msgid "ST_DWithin"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2260
#, no-c-format
msgid ""
"Returns true if the geometries are within the specified distance of one "
"another. For geometry units are in those of spatial reference and For "
"geography units are in meters and measurement is defaulted to "
"use_spheroid=true (measure around spheroid), for faster check, "
"use_spheroid=false to measure along sphere."
msgstr ""

#. Tag: funcsynopsis
#: reference_measure.xml:2266
#, no-c-format
msgid ""
"<funcprototype> <funcdef>boolean <function>ST_DWithin</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef> "
"<paramdef><type>double precision </type> <parameter>distance_of_srid</"
"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>boolean "
"<function>ST_DWithin</function></funcdef> <paramdef><type>geography </type> "
"<parameter>gg1</parameter></paramdef> <paramdef><type>geography </type> "
"<parameter>gg2</parameter></paramdef> <paramdef><type>double precision </"
"type> <parameter>distance_meters</parameter></paramdef> </funcprototype> "
"<funcprototype> <funcdef>boolean <function>ST_DWithin</function></funcdef> "
"<paramdef><type>geography </type> <parameter>gg1</parameter></paramdef> "
"<paramdef><type>geography </type> <parameter>gg2</parameter></paramdef> "
"<paramdef><type>double precision </type> <parameter>distance_meters</"
"parameter></paramdef> <paramdef><type>boolean </type> "
"<parameter>use_spheroid</parameter></paramdef> </funcprototype>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2311
#, no-c-format
msgid ""
"Returns true if the geometries are within the specified distance of one "
"another."
msgstr ""

#. Tag: para
#: reference_measure.xml:2313
#, no-c-format
msgid ""
"For Geometries: The distance is specified in units defined by the spatial "
"reference system of the geometries. For this function to make sense, the "
"source geometries must both be of the same coordinate projection, having the "
"same SRID."
msgstr ""

#. Tag: para
#: reference_measure.xml:2318
#, no-c-format
msgid ""
"For geography units are in meters and measurement is defaulted to "
"use_spheroid=true, for faster check, use_spheroid=false to measure along "
"sphere."
msgstr ""

#. Tag: para
#: reference_measure.xml:2328
#, no-c-format
msgid ""
"Prior to 1.3, ST_Expand was commonly used in conjunction with &amp;&amp; and "
"ST_Distance to achieve the same effect and in pre-1.3.4 this function was "
"basically short-hand for that construct. From 1.3.4, ST_DWithin uses a more "
"short-circuit distance function which should make it more efficient than "
"prior versions for larger buffer regions."
msgstr ""

#. Tag: para
#: reference_measure.xml:2334
#, no-c-format
msgid "Use ST_3DDWithin if you have 3D geometries."
msgstr ""

#. Tag: para
#: reference_measure.xml:2337
#, no-c-format
msgid "Availability: 1.5.0 support for geography was introduced"
msgstr ""

#. Tag: para
#: reference_measure.xml:2338
#, no-c-format
msgid ""
"Enhanced: 2.1.0 improved speed for geography. See <ulink url=\"http://blog."
"opengeo.org/2012/07/12/making-geography-faster/\">Making Geography faster</"
"ulink> for details."
msgstr ""

#. Tag: para
#: reference_measure.xml:2339
#, no-c-format
msgid "Enhanced: 2.1.0 support for curved geometries was introduced."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2344
#, no-c-format
msgid ""
"--Find the nearest hospital to each school\n"
"--that is within 3000 units of the school.\n"
"-- We do an ST_DWithin search to utilize indexes to limit our search list\n"
"-- that the non-indexable ST_Distance needs to process\n"
"--If the units of the spatial reference is meters then units would be "
"meters\n"
"SELECT DISTINCT ON (s.gid) s.gid, s.school_name, s.the_geom, h."
"hospital_name\n"
"        FROM schools s\n"
"                LEFT JOIN hospitals h ON ST_DWithin(s.the_geom, h.the_geom, "
"3000)\n"
"        ORDER BY s.gid, ST_Distance(s.the_geom, h.the_geom);\n"
"\n"
"--The schools with no close hospitals\n"
"--Find all schools with no hospital within 3000 units\n"
"--away from the school.  Units is in units of spatial ref (e.g. meters, "
"feet, degrees)\n"
"SELECT s.gid, s.school_name\n"
"        FROM schools s\n"
"                LEFT JOIN hospitals h ON ST_DWithin(s.the_geom, h.the_geom, "
"3000)\n"
"        WHERE h.gid IS NULL;"
msgstr ""

#. Tag: para
#: reference_measure.xml:2350
#, no-c-format
msgid ", <xref linkend=\"ST_Expand\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2356
#, no-c-format
msgid "ST_Equals"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2358
#, no-c-format
msgid ""
"Returns true if the given geometries represent the same geometry. "
"Directionality is ignored."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:2364
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_Equals</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>A</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>B</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2375
#, no-c-format
msgid ""
"Returns TRUE if the given Geometries are \"spatially equal\". Use this for a "
"'better' answer than '='. Note by spatially equal we mean ST_Within(A,B) = "
"true and ST_Within(B,A) = true and also mean ordering of points can be "
"different but represent the same geometry structure. To verify the order of "
"points is consistent, use ST_OrderingEquals (it must be noted "
"ST_OrderingEquals is a little more stringent than simply verifying order of "
"points are the same)."
msgstr ""

#. Tag: para
#: reference_measure.xml:2384
#, no-c-format
msgid ""
"This function will return false if either geometry is invalid even if they "
"are binary equal."
msgstr ""

#. Tag: para
#: reference_measure.xml:2388
#, no-c-format
msgid "Do not call with a GEOMETRYCOLLECTION as an argument."
msgstr ""

#. Tag: para
#: reference_measure.xml:2391
#, no-c-format
msgid "&sfs_compliant; s2.1.1.2"
msgstr ""

#. Tag: para
#: reference_measure.xml:2392
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 5.1.24"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2398
#, no-c-format
msgid ""
"SELECT ST_Equals(ST_GeomFromText('LINESTRING(0 0, 10 10)'),\n"
"                ST_GeomFromText('LINESTRING(0 0, 5 5, 10 10)'));\n"
" st_equals\n"
"-----------\n"
" t\n"
"(1 row)\n"
"\n"
"SELECT ST_Equals(ST_Reverse(ST_GeomFromText('LINESTRING(0 0, 10 10)')),\n"
"                ST_GeomFromText('LINESTRING(0 0, 5 5, 10 10)'));\n"
" st_equals\n"
"-----------\n"
" t\n"
"(1 row)"
msgstr ""

#. Tag: para
#: reference_measure.xml:2404
#, no-c-format
msgid ""
", <xref linkend=\"ST_OrderingEquals\"/>, <xref linkend=\"ST_Reverse\"/>, "
"<xref linkend=\"ST_Within\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2411
#, no-c-format
msgid "ST_GeometricMedian"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2415
#, no-c-format
msgid "Returns the geometric median of a MultiPoint."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:2422
#, no-c-format
msgid ""
"<funcdef>geometry <function> ST_GeometricMedian </function> </funcdef> "
"<paramdef> <type> geometry </type> <parameter> g </parameter> </paramdef> "
"<paramdef> <type> float8 </type> <parameter> tolerance </parameter> </"
"paramdef> <paramdef> <type> int </type> <parameter> max_iter </parameter> </"
"paramdef> <paramdef> <type> boolean </type> <parameter> "
"fail_if_not_converged </parameter> </paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2472
#, no-c-format
msgid ""
"Computes the approximate geometric median of a MultiPoint geometry using the "
"Weiszfeld algorithm. The geometric median provides a centrality measure that "
"is less sensitive to outlier points than the centroid. The algorithm will "
"iterate until the distance change between successive iterations is less than "
"the supplied <varname>tolerance</varname> parameter. If this condition has "
"not been met after <varname>max_iterations</varname> iterations, the "
"function will produce an error and exit, unless "
"<varname>fail_if_not_converged</varname> is set to false. If a tolerance "
"value is not provided, a default tolerance value will be calculated based on "
"the extent of the input geometry."
msgstr ""

#. Tag: para
#: reference_measure.xml:2488
#, no-c-format
msgid "Availability: 2.3.0"
msgstr ""

#. Tag: para
#: reference_measure.xml:2501
#, no-c-format
msgid ""
"Comparison of the centroid (turquoise point) and geometric median (red "
"point) of a four-point MultiPoint (yellow points)."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2509
#, no-c-format
msgid ""
"WITH test AS (\n"
"SELECT 'MULTIPOINT((0 0), (1 1), (2 2), (200 200))'::geometry geom)\n"
"SELECT\n"
"  ST_AsText(ST_Centroid(geom)) centroid,\n"
"  ST_AsText(ST_GeometricMedian(geom)) median\n"
"FROM test;\n"
"      centroid      |                 median\n"
"--------------------+----------------------------------------\n"
" POINT(50.75 50.75) | POINT(1.9761550281255 1.9761550281255)\n"
"(1 row)"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2522
#, no-c-format
msgid "ST_HasArc"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2524
#, no-c-format
msgid ""
"<refpurpose>Returns true if a geometry or geometry collection contains a "
"circular string</refpurpose>"
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:2529
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_HasArc</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2539
#, no-c-format
msgid ""
"<para>Returns true if a geometry or geometry collection contains a circular "
"string</para>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2541
#, no-c-format
msgid "Availability: 1.2.3?"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2550
#, no-c-format
msgid ""
"SELECT ST_HasArc(ST_Collect('LINESTRING(1 2, 3 4, 5 6)', 'CIRCULARSTRING(1 "
"1, 2 3, 4 5, 6 7, 5 6)'));\n"
"                st_hasarc\n"
"                --------\n"
"                t"
msgstr ""

#. Tag: para
#: reference_measure.xml:2557
#, no-c-format
msgid ", <xref linkend=\"ST_LineToCurve\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2563
#, no-c-format
msgid "<refname>ST_Intersects</refname>"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2565
#, no-c-format
msgid ""
"Returns TRUE if the Geometries/Geography \"spatially intersect in 2D\" - "
"(share any portion of space) and FALSE if they don't (they are Disjoint). "
"For geography -- tolerance is 0.00001 meters (so any points that close are "
"considered to intersect)"
msgstr ""

#. Tag: funcsynopsis
#: reference_measure.xml:2571
#, no-c-format
msgid ""
"<funcprototype> <funcdef>boolean <function>ST_Intersects</function></"
"funcdef> <paramdef> <type>geometry</type> <parameter>geomA</parameter> </"
"paramdef> <paramdef> <type>geometry</type> <parameter>geomB</parameter> </"
"paramdef> </funcprototype> <funcprototype> <funcdef>boolean "
"<function>ST_Intersects</function></funcdef> <paramdef> <type>geography</"
"type> <parameter>geogA</parameter> </paramdef> <paramdef> <type>geography</"
"type> <parameter>geogB</parameter> </paramdef> </funcprototype>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2598
#, no-c-format
msgid ""
"If a geometry or geography shares any portion of space then they intersect. "
"For geography -- tolerance is 0.00001 meters (so any points that are close "
"are considered to intersect)"
msgstr ""

#. Tag: para
#: reference_measure.xml:2605
#, no-c-format
msgid ""
"Do not call with a <varname>GEOMETRYCOLLECTION</varname> as an argument for "
"geometry version. The geography version supports GEOMETRYCOLLECTION since "
"its a thin wrapper around distance implementation."
msgstr ""

#. Tag: para
#: reference_measure.xml:2610
#, no-c-format
msgid "Performed by the GEOS module (for geometry), geography is native"
msgstr ""

#. Tag: para
#: reference_measure.xml:2611
#, no-c-format
msgid "Availability: 1.5 support for geography was introduced."
msgstr ""

#. Tag: para
#: reference_measure.xml:2618
#, no-c-format
msgid ""
"For geography, this function has a distance tolerance of about 0.00001 "
"meters and uses the sphere rather than spheroid calculation."
msgstr ""

#. Tag: para
#: reference_measure.xml:2625
#, no-c-format
msgid ""
"&sfs_compliant; s2.1.1.2 //s2.1.13.3 - ST_Intersects(g1, g2 ) --&gt; Not "
"(ST_Disjoint(g1, g2 ))"
msgstr ""

#. Tag: para
#: reference_measure.xml:2628
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 5.1.27"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2633
#, no-c-format
msgid ""
"SELECT ST_Intersects('POINT(0 0)'::geometry, 'LINESTRING ( 2 0, 0 2 )'::"
"geometry);\n"
" st_intersects\n"
"---------------\n"
" f\n"
"(1 row)\n"
"SELECT ST_Intersects('POINT(0 0)'::geometry, 'LINESTRING ( 0 0, 0 2 )'::"
"geometry);\n"
" st_intersects\n"
"---------------\n"
" t\n"
"(1 row)"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2637
#, no-c-format
msgid ""
"SELECT ST_Intersects(\n"
"                ST_GeographyFromText('SRID=4326;LINESTRING(-43.23456 "
"72.4567,-43.23456 72.4568)'),\n"
"                ST_GeographyFromText('SRID=4326;POINT(-43.23456 "
"72.4567772)')\n"
"                );\n"
"\n"
" st_intersects\n"
"---------------\n"
"t"
msgstr ""

#. Tag: para
#: reference_measure.xml:2641
#, no-c-format
msgid ", <xref linkend=\"ST_Disjoint\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2646
#, no-c-format
msgid "ST_Length"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2648
#, no-c-format
msgid ""
"Returns the 2D length of the geometry if it is a LineString or "
"MultiLineString. geometry are in units of spatial reference and geography "
"are in meters (default spheroid)"
msgstr ""

#. Tag: funcsynopsis
#: reference_measure.xml:2651
#, no-c-format
msgid ""
"<funcprototype> <funcdef>float <function>ST_Length</function></funcdef> "
"<paramdef><type>geometry </type><parameter>a_2dlinestring</parameter></"
"paramdef> </funcprototype> <funcprototype> <funcdef>float "
"<function>ST_Length</function></funcdef> <paramdef><type>geography </"
"type><parameter>geog</parameter></paramdef> <paramdef choice=\"opt"
"\"><type>boolean </type><parameter>use_spheroid=true</parameter></paramdef> "
"</funcprototype>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2666
#, no-c-format
msgid ""
"For geometry: Returns the 2D Cartesian length of the geometry if it is a "
"LineString, MultiLineString, ST_Curve, ST_MultiCurve. 0 is returned for "
"areal geometries. For areal geometries use <xref linkend=\"ST_Perimeter\"/>. "
"For geometry types, units for length measures are specified by the spatial "
"reference system of the geometry."
msgstr ""

#. Tag: para
#: reference_measure.xml:2669
#, no-c-format
msgid ""
"For geography types, the calculations are performed using the inverse "
"geodesic problem, where length units are in meters. If PostGIS is compiled "
"with PROJ version 4.8.0 or later, the spheroid is specified by the SRID, "
"otherwise it is exclusive to WGS84. If <varname>use_spheroid=false</"
"varname>, then calculations will approximate a sphere instead of a spheroid."
msgstr ""

#. Tag: para
#: reference_measure.xml:2673
#, no-c-format
msgid ""
"Currently for geometry this is an alias for ST_Length2D, but this may change "
"to support higher dimensions."
msgstr ""

#. Tag: para
#: reference_measure.xml:2674
#, no-c-format
msgid ""
"Changed: 2.0.0 Breaking change -- in prior versions applying this to a MULTI/"
"POLYGON of type geography would give you the perimeter of the POLYGON/"
"MULTIPOLYGON. In 2.0.0 this was changed to return 0 to be in line with "
"geometry behavior. Please use ST_Perimeter if you want the perimeter of a "
"polygon"
msgstr ""

#. Tag: para
#: reference_measure.xml:2676
#, no-c-format
msgid ""
"For geography measurement defaults spheroid measurement. To use the faster "
"less accurate sphere use ST_Length(gg,false);"
msgstr ""

#. Tag: para
#: reference_measure.xml:2677 reference_measure.xml:3134
#, no-c-format
msgid "&sfs_compliant; s2.1.5.1"
msgstr ""

#. Tag: para
#: reference_measure.xml:2678
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 7.1.2, 9.3.4"
msgstr ""

#. Tag: para
#: reference_measure.xml:2679
#, no-c-format
msgid "Availability: 1.5.0 geography support was introduced in 1.5."
msgstr ""

#. Tag: para
#: reference_measure.xml:2685
#, no-c-format
msgid ""
"Return length in feet for line string. Note this is in feet because "
"EPSG:2249 is Massachusetts State Plane Feet"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2687
#, no-c-format
msgid ""
"SELECT ST_Length(ST_GeomFromText('LINESTRING(743238 2967416,743238 "
"2967450,743265 2967450,\n"
"743265.625 2967416,743238 2967416)',2249));\n"
"st_length\n"
"---------\n"
" 122.630744000095\n"
"\n"
"\n"
"--Transforming WGS 84 LineString to Massachusetts state plane meters\n"
"SELECT ST_Length(\n"
"        ST_Transform(\n"
"                ST_GeomFromEWKT('SRID=4326;LINESTRING(-72.1260 42.45, "
"-72.1240 42.45666, -72.123 42.1546)'),\n"
"                26986\n"
"        )\n"
");\n"
"st_length\n"
"---------\n"
"34309.4563576191"
msgstr ""

#. Tag: para
#: reference_measure.xml:2691
#, no-c-format
msgid "Return length of WGS 84 geography line"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2692
#, no-c-format
msgid ""
"-- default calculation is using a sphere rather than spheroid\n"
"SELECT ST_Length(the_geog) As length_spheroid,  ST_Length(the_geog,false) As "
"length_sphere\n"
"FROM (SELECT ST_GeographyFromText(\n"
"'SRID=4326;LINESTRING(-72.1260 42.45, -72.1240 42.45666, -72.123 42.1546)') "
"As the_geog)\n"
" As foo;\n"
" length_spheroid  |  length_sphere\n"
"------------------+------------------\n"
" 34310.5703627288 | 34346.2060960742"
msgstr ""

#. Tag: para
#: reference_measure.xml:2696
#, no-c-format
msgid ""
", <xref linkend=\"ST_GeomFromEWKT\"/>, <xref linkend=\"ST_Length_Spheroid\"/"
">, <xref linkend=\"ST_Perimeter\"/>, <xref linkend=\"ST_Transform\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2702
#, no-c-format
msgid "ST_Length2D"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2704
#, no-c-format
msgid ""
"<refpurpose>Returns the 2-dimensional length of the geometry if it is a "
"linestring or multi-linestring. This is an alias for <varname>ST_Length</"
"varname></refpurpose>"
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:2710
#, no-c-format
msgid ""
"<funcdef>float <function>ST_Length2D</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>a_2dlinestring</parameter></"
"paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2720
#, no-c-format
msgid ""
"<para>Returns the 2-dimensional length of the geometry if it is a linestring "
"or multi-linestring. This is an alias for <varname>ST_Length</varname></para>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2729
#, no-c-format
msgid ", <xref linkend=\"ST_3DLength\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2735
#, no-c-format
msgid "ST_3DLength"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2737
#, no-c-format
msgid ""
"Returns the 3-dimensional or 2-dimensional length of the geometry if it is a "
"linestring or multi-linestring."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:2743
#, no-c-format
msgid ""
"<funcdef>float <function>ST_3DLength</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>a_3dlinestring</parameter></"
"paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2753
#, no-c-format
msgid ""
"Returns the 3-dimensional or 2-dimensional length of the geometry if it is a "
"linestring or multi-linestring. For 2-d lines it will just return the 2-d "
"length (same as ST_Length and ST_Length2D)"
msgstr ""

#. Tag: para
#: reference_measure.xml:2756
#, no-c-format
msgid "Changed: 2.0.0 In prior versions this used to be called ST_Length3D"
msgstr ""

#. Tag: para
#: reference_measure.xml:2763
#, no-c-format
msgid ""
"Return length in feet for a 3D cable. Note this is in feet because EPSG:2249 "
"is Massachusetts State Plane Feet"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2765
#, no-c-format
msgid ""
"SELECT ST_3DLength(ST_GeomFromText('LINESTRING(743238 2967416 1,743238 "
"2967450 1,743265 2967450 3,\n"
"743265.625 2967416 3,743238 2967416 3)',2249));\n"
"ST_3DLength\n"
"-----------\n"
"122.704716741457"
msgstr ""

#. Tag: para
#: reference_measure.xml:2772
#, no-c-format
msgid ", <xref linkend=\"ST_Length2D\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2778
#, no-c-format
msgid "ST_LengthSpheroid"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2780
#, no-c-format
msgid ""
"Calculates the 2D or 3D length/perimeter of a geometry on an ellipsoid. This "
"is useful if the coordinates of the geometry are in longitude/latitude and a "
"length is desired without reprojection."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:2787
#, no-c-format
msgid ""
"<funcdef>float <function>ST_LengthSpheroid</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>a_geometry</parameter></"
"paramdef> <paramdef><type>spheroid </type> <parameter>a_spheroid</"
"parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2798
#, no-c-format
msgid ""
"Calculates the length/perimeter of a geometry on an ellipsoid. This is "
"useful if the coordinates of the geometry are in longitude/latitude and a "
"length is desired without reprojection. The ellipsoid is a separate database "
"type and can be constructed as follows:"
msgstr ""

#. Tag: literallayout
#: reference_measure.xml:2804 reference_measure.xml:2855
#, no-c-format
msgid ""
"SPHEROID[&lt;NAME&gt;,&lt;SEMI-MAJOR AXIS&gt;,&lt;INVERSE FLATTENING&gt;]"
msgstr ""

#. Tag: literallayout
#: reference_measure.xml:2806 reference_measure.xml:2857
#, no-c-format
msgid "SPHEROID[\"GRS_1980\",6378137,298.257222101]"
msgstr ""

#. Tag: para
#: reference_measure.xml:2808
#, no-c-format
msgid "Availability: 1.2.2"
msgstr ""

#. Tag: para
#: reference_measure.xml:2809
#, no-c-format
msgid ""
"Changed: 2.2.0 In prior versions this used to be called ST_Length_Spheroid "
"and used to have a ST_3DLength_Spheroid alias"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2816
#, no-c-format
msgid ""
"SELECT ST_LengthSpheroid( geometry_column,\n"
"                          'SPHEROID[\"GRS_1980\",6378137,298.257222101]' )\n"
"                          FROM geometry_table;\n"
"\n"
"SELECT ST_LengthSpheroid( the_geom, sph_m ) As tot_len,\n"
"ST_LengthSpheroid(ST_GeometryN(the_geom,1), sph_m) As len_line1,\n"
"ST_LengthSpheroid(ST_GeometryN(the_geom,2), sph_m) As len_line2\n"
"                          FROM (SELECT "
"ST_GeomFromText('MULTILINESTRING((-118.584 38.374,-118.583 38.5),\n"
"        (-71.05957 42.3589 , -71.061 43))') As the_geom,\n"
"CAST('SPHEROID[\"GRS_1980\",6378137,298.257222101]' As spheroid) As sph_m)  "
"as foo;\n"
"        tot_len      |    len_line1     |    len_line2\n"
"------------------+------------------+------------------\n"
" 85204.5207562955 | 13986.8725229309 | 71217.6482333646\n"
"\n"
" --3D\n"
"SELECT ST_LengthSpheroid( the_geom, sph_m ) As tot_len,\n"
"ST_LengthSpheroid(ST_GeometryN(the_geom,1), sph_m) As len_line1,\n"
"ST_LengthSpheroid(ST_GeometryN(the_geom,2), sph_m) As len_line2\n"
"                          FROM (SELECT "
"ST_GeomFromEWKT('MULTILINESTRING((-118.584 38.374 20,-118.583 38.5 30),\n"
"        (-71.05957 42.3589 75, -71.061 43 90))') As the_geom,\n"
"CAST('SPHEROID[\"GRS_1980\",6378137,298.257222101]' As spheroid) As sph_m)  "
"as foo;\n"
"\n"
"         tot_len      |    len_line1    |    len_line2\n"
"------------------+-----------------+------------------\n"
" 85204.5259107402 | 13986.876097711 | 71217.6498130292"
msgstr ""

#. Tag: para
#: reference_measure.xml:2823
#, no-c-format
msgid ", <xref linkend=\"ST_Length\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2829
#, no-c-format
msgid "ST_Length2D_Spheroid"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2831
#, no-c-format
msgid ""
"Calculates the 2D length/perimeter of a geometry on an ellipsoid. This is "
"useful if the coordinates of the geometry are in longitude/latitude and a "
"length is desired without reprojection."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:2838
#, no-c-format
msgid ""
"<funcdef>float <function>ST_Length2D_Spheroid</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>a_geometry</parameter></"
"paramdef> <paramdef><type>spheroid </type> <parameter>a_spheroid</"
"parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2849
#, no-c-format
msgid ""
"Calculates the 2D length/perimeter of a geometry on an ellipsoid. This is "
"useful if the coordinates of the geometry are in longitude/latitude and a "
"length is desired without reprojection. The ellipsoid is a separate database "
"type and can be constructed as follows:"
msgstr ""

#. Tag: para
#: reference_measure.xml:2858
#, no-c-format
msgid ""
"This is much like <xref linkend=\"ST_Length_Spheroid\"/> except it will "
"ignore the Z ordinate in calculations."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2865
#, no-c-format
msgid ""
"SELECT ST_Length2D_Spheroid( geometry_column,\n"
"                          'SPHEROID[\"GRS_1980\",6378137,298.257222101]' )\n"
"                          FROM geometry_table;\n"
"\n"
"SELECT ST_Length2D_Spheroid( the_geom, sph_m ) As tot_len,\n"
"ST_Length2D_Spheroid(ST_GeometryN(the_geom,1), sph_m) As len_line1,\n"
"ST_Length2D_Spheroid(ST_GeometryN(the_geom,2), sph_m) As len_line2\n"
"                          FROM (SELECT "
"ST_GeomFromText('MULTILINESTRING((-118.584 38.374,-118.583 38.5),\n"
"        (-71.05957 42.3589 , -71.061 43))') As the_geom,\n"
"CAST('SPHEROID[\"GRS_1980\",6378137,298.257222101]' As spheroid) As sph_m)  "
"as foo;\n"
"        tot_len      |    len_line1     |    len_line2\n"
"------------------+------------------+------------------\n"
" 85204.5207562955 | 13986.8725229309 | 71217.6482333646\n"
"\n"
" --3D Observe same answer\n"
"SELECT ST_Length2D_Spheroid( the_geom, sph_m ) As tot_len,\n"
"ST_Length2D_Spheroid(ST_GeometryN(the_geom,1), sph_m) As len_line1,\n"
"ST_Length2D_Spheroid(ST_GeometryN(the_geom,2), sph_m) As len_line2\n"
"                          FROM (SELECT "
"ST_GeomFromEWKT('MULTILINESTRING((-118.584 38.374 20,-118.583 38.5 30),\n"
"        (-71.05957 42.3589 75, -71.061 43 90))') As the_geom,\n"
"CAST('SPHEROID[\"GRS_1980\",6378137,298.257222101]' As spheroid) As sph_m)  "
"as foo;\n"
"\n"
"        tot_len      |    len_line1     |    len_line2\n"
"------------------+------------------+------------------\n"
" 85204.5207562955 | 13986.8725229309 | 71217.6482333646"
msgstr ""

#. Tag: para
#: reference_measure.xml:2872
#, no-c-format
msgid ", <xref linkend=\"ST_Length_Spheroid\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2878
#, no-c-format
msgid "ST_LongestLine"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2880
#, no-c-format
msgid ""
"Returns the 2-dimensional longest line points of two geometries. The "
"function will only return the first longest line if more than one, that the "
"function finds. The line returned will always start in g1 and end in g2. The "
"length of the line this function returns will always be the same as "
"st_maxdistance returns for g1 and g2."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:2888
#, no-c-format
msgid ""
"<funcdef>geometry <function>ST_LongestLine</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2903
#, no-c-format
msgid ""
"Returns the 2-dimensional longest line between the points of two geometries."
msgstr ""

#. Tag: para
#: reference_measure.xml:2921
#, no-c-format
msgid "Longest line between point and line"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2924
#, no-c-format
msgid ""
"SELECT ST_AsText(\n"
"        ST_LongestLine('POINT(100 100)'::geometry,\n"
"                'LINESTRING (20 80, 98 190, 110 180, 50 75 )'::geometry)\n"
"        ) As lline;\n"
"\n"
"\n"
"   lline\n"
"-----------------\n"
"LINESTRING(100 100,98 190)"
msgstr ""

#. Tag: para
#: reference_measure.xml:2932
#, no-c-format
msgid "longest line between polygon and polygon"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2935
#, no-c-format
msgid ""
"SELECT ST_AsText(\n"
"        ST_LongestLine(\n"
"                ST_GeomFromText('POLYGON((175 150, 20 40,\n"
"                        50 60, 125 100, 175 150))'),\n"
"                ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n"
"                )\n"
"        ) As llinewkt;\n"
"\n"
"   lline\n"
"-----------------\n"
"LINESTRING(20 40,121.111404660392 186.629392246051)"
msgstr ""

#. Tag: para
#: reference_measure.xml:2951
#, no-c-format
msgid ""
"longest straight distance to travel from one part of an elegant city to the "
"other Note the max distance = to the length of the line."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:2955
#, no-c-format
msgid ""
"SELECT ST_AsText(ST_LongestLine(c.the_geom, c.the_geom)) As llinewkt,\n"
"        ST_MaxDistance(c.the_geom,c.the_geom) As max_dist,\n"
"        ST_Length(ST_LongestLine(c.the_geom, c.the_geom)) As lenll\n"
"FROM (SELECT ST_BuildArea(ST_Collect(the_geom)) As the_geom\n"
"        FROM (SELECT ST_Translate(ST_SnapToGrid(ST_Buffer(ST_Point(50 ,"
"generate_series(50,190, 50)\n"
"                        ),40, 'quad_segs=2'),1), x, 0)  As the_geom\n"
"                        FROM generate_series(1,100,50) As x)  AS foo\n"
") As c;\n"
"\n"
"          llinewkt          |     max_dist     |      lenll\n"
"---------------------------+------------------+------------------\n"
" LINESTRING(23 22,129 178) | 188.605408193933 | 188.605408193933"
msgstr ""

#. Tag: para
#: reference_measure.xml:2966
#, no-c-format
msgid ""
", <xref linkend=\"ST_ShortestLine\"/>, <xref linkend=\"ST_LongestLine\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:2972
#, no-c-format
msgid "ST_OrderingEquals"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:2974
#, no-c-format
msgid ""
"Returns true if the given geometries represent the same geometry and points "
"are in the same directional order."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:2980
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_OrderingEquals</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>A</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>B</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:2991
#, no-c-format
msgid ""
"ST_OrderingEquals compares two geometries and returns t (TRUE) if the "
"geometries are equal and the coordinates are in the same order; otherwise it "
"returns f (FALSE)."
msgstr ""

#. Tag: para
#: reference_measure.xml:2996
#, no-c-format
msgid ""
"This function is implemented as per the ArcSDE SQL specification rather than "
"SQL-MM. http://edndoc.esri.com/arcsde/9.1/sql_api/sqlapi3."
"htm#ST_OrderingEquals"
msgstr ""

#. Tag: para
#: reference_measure.xml:3000
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 5.1.43"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:3006
#, no-c-format
msgid ""
"SELECT ST_OrderingEquals(ST_GeomFromText('LINESTRING(0 0, 10 10)'),\n"
"                ST_GeomFromText('LINESTRING(0 0, 5 5, 10 10)'));\n"
" st_orderingequals\n"
"-----------\n"
" f\n"
"(1 row)\n"
"\n"
"SELECT ST_OrderingEquals(ST_GeomFromText('LINESTRING(0 0, 10 10)'),\n"
"                ST_GeomFromText('LINESTRING(0 0, 0 0, 10 10)'));\n"
" st_orderingequals\n"
"-----------\n"
" t\n"
"(1 row)\n"
"\n"
"SELECT ST_OrderingEquals(ST_Reverse(ST_GeomFromText('LINESTRING(0 0, 10 "
"10)')),\n"
"                ST_GeomFromText('LINESTRING(0 0, 0 0, 10 10)'));\n"
" st_orderingequals\n"
"-----------\n"
" f\n"
"(1 row)"
msgstr ""

#. Tag: para
#: reference_measure.xml:3010
#, no-c-format
msgid ", <xref linkend=\"ST_Reverse\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:3016
#, no-c-format
msgid "ST_Overlaps"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:3018
#, no-c-format
msgid ""
"Returns TRUE if the Geometries share space, are of the same dimension, but "
"are not completely contained by each other."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:3023
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_Overlaps</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>A</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>B</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:3034
#, no-c-format
msgid ""
"Returns TRUE if the Geometries \"spatially overlap\". By that we mean they "
"intersect, but one does not completely contain another."
msgstr ""

#. Tag: para
#: reference_measure.xml:3039 reference_measure.xml:3367
#: reference_measure.xml:3381
#, no-c-format
msgid "Do not call with a GeometryCollection as an argument"
msgstr ""

#. Tag: para
#: reference_measure.xml:3041
#, no-c-format
msgid ""
"This function call will automatically include a bounding box comparison that "
"will make use of any indexes that are available on the geometries. To avoid "
"index use, use the function _ST_Overlaps."
msgstr ""

#. Tag: para
#: reference_measure.xml:3049 reference_measure.xml:3387
#: reference_measure.xml:3592
#, no-c-format
msgid "&sfs_compliant; s2.1.1.2 // s2.1.13.3"
msgstr ""

#. Tag: para
#: reference_measure.xml:3050
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 5.1.32"
msgstr ""

#. Tag: para
#: reference_measure.xml:3066
#, no-c-format
msgid "<varname>MULTIPOINT</varname> / <varname>MULTIPOINT</varname>"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:3090
#, no-c-format
msgid ""
"--a point on a line is contained by the line and is of a lower dimension, "
"and therefore does not overlap the line\n"
"                        nor crosses\n"
"\n"
"SELECT ST_Overlaps(a,b) As a_overlap_b,\n"
"        ST_Crosses(a,b) As a_crosses_b,\n"
"                ST_Intersects(a, b) As a_intersects_b, ST_Contains(b,a) As "
"b_contains_a\n"
"FROM (SELECT ST_GeomFromText('POINT(1 0.5)') As a, "
"ST_GeomFromText('LINESTRING(1 0, 1 1, 3 5)')  As b)\n"
"        As foo\n"
"\n"
"a_overlap_b | a_crosses_b | a_intersects_b | b_contains_a\n"
"------------+-------------+----------------+--------------\n"
"f           | f           | t              | t\n"
"\n"
"--a line that is partly contained by circle, but not fully is defined as "
"intersecting and crossing,\n"
"-- but since of different dimension it does not overlap\n"
"SELECT ST_Overlaps(a,b) As a_overlap_b, ST_Crosses(a,b) As a_crosses_b,\n"
"        ST_Intersects(a, b) As a_intersects_b,\n"
"        ST_Contains(a,b) As a_contains_b\n"
"FROM (SELECT ST_Buffer(ST_GeomFromText('POINT(1 0.5)'), 3)  As a, "
"ST_GeomFromText('LINESTRING(1 0, 1 1, 3 5)')  As b)\n"
"        As foo;\n"
"\n"
" a_overlap_b | a_crosses_b | a_intersects_b | a_contains_b\n"
"-------------+-------------+----------------+--------------\n"
" f           | t           | t              | f\n"
"\n"
" -- a 2-dimensional bent hot dog (aka buffered line string) that intersects "
"a circle,\n"
" --        but is not fully contained by the circle is defined as "
"overlapping since they are of the same dimension,\n"
"--        but it does not cross, because the intersection of the 2 is of the "
"same dimension\n"
"--        as the maximum dimension of the 2\n"
"\n"
"SELECT ST_Overlaps(a,b) As a_overlap_b, ST_Crosses(a,b) As a_crosses_b, "
"ST_Intersects(a, b) As a_intersects_b,\n"
"ST_Contains(b,a) As b_contains_a,\n"
"ST_Dimension(a) As dim_a, ST_Dimension(b) as dim_b, "
"ST_Dimension(ST_Intersection(a,b)) As dima_intersection_b\n"
"FROM (SELECT ST_Buffer(ST_GeomFromText('POINT(1 0.5)'), 3)  As a,\n"
"        ST_Buffer(ST_GeomFromText('LINESTRING(1 0, 1 1, 3 5)'),0.5)  As b)\n"
"        As foo;\n"
"\n"
" a_overlap_b | a_crosses_b | a_intersects_b | b_contains_a | dim_a | dim_b | "
"dima_intersection_b\n"
"-------------+-------------+----------------+--------------+-------+-------"
"+---------------------\n"
" t           | f           | t              | f            |     2 |     2 "
"|              2"
msgstr ""

#. Tag: para
#: reference_measure.xml:3098
#, no-c-format
msgid ""
", <xref linkend=\"ST_Crosses\"/>, <xref linkend=\"ST_Dimension\"/>, <xref "
"linkend=\"ST_Intersects\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:3103
#, no-c-format
msgid "ST_Perimeter"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:3105
#, no-c-format
msgid ""
"Return the length measurement of the boundary of an ST_Surface or "
"ST_MultiSurface geometry or geography. (Polygon, MultiPolygon). geometry "
"measurement is in units of spatial reference and geography is in meters."
msgstr ""

#. Tag: funcsynopsis
#: reference_measure.xml:3109
#, no-c-format
msgid ""
"<funcprototype> <funcdef>float <function>ST_Perimeter</function></funcdef> "
"<paramdef><type>geometry </type><parameter>g1</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>float <function>ST_Perimeter</"
"function></funcdef> <paramdef><type>geography </type><parameter>geog</"
"parameter></paramdef> <paramdef choice=\"opt\"><type>boolean </"
"type><parameter>use_spheroid=true</parameter></paramdef> </funcprototype>"
msgstr ""

#. Tag: para
#: reference_measure.xml:3125
#, no-c-format
msgid ""
"Returns the 2D perimeter of the geometry/geography if it is a ST_Surface, "
"ST_MultiSurface (Polygon, MultiPolygon). 0 is returned for non-areal "
"geometries. For linear geometries use <xref linkend=\"ST_Length\"/>. For "
"geometry types, units for perimeter measures are specified by the spatial "
"reference system of the geometry."
msgstr ""

#. Tag: para
#: reference_measure.xml:3128
#, no-c-format
msgid ""
"For geography types, the calculations are performed using the inverse "
"geodesic problem, where perimeter units are in meters. If PostGIS is "
"compiled with PROJ version 4.8.0 or later, the spheroid is specified by the "
"SRID, otherwise it is exclusive to WGS84. If <varname>use_spheroid=false</"
"varname>, then calculations will approximate a sphere instead of a spheroid."
msgstr ""

#. Tag: para
#: reference_measure.xml:3132
#, no-c-format
msgid ""
"Currently this is an alias for ST_Perimeter2D, but this may change to "
"support higher dimensions."
msgstr ""

#. Tag: para
#: reference_measure.xml:3135
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 8.1.3, 9.5.4"
msgstr ""

#. Tag: para
#: reference_measure.xml:3136
#, no-c-format
msgid "Availability 2.0.0: Support for geography was introduced"
msgstr ""

#. Tag: title
#: reference_measure.xml:3140
#, no-c-format
msgid "Examples: Geometry"
msgstr ""

#. Tag: para
#: reference_measure.xml:3141
#, no-c-format
msgid ""
"Return perimeter in feet for Polygon and MultiPolygon. Note this is in feet "
"because EPSG:2249 is Massachusetts State Plane Feet"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:3143
#, no-c-format
msgid ""
"SELECT ST_Perimeter(ST_GeomFromText('POLYGON((743238 2967416,743238 "
"2967450,743265 2967450,\n"
"743265.625 2967416,743238 2967416))', 2249));\n"
"st_perimeter\n"
"---------\n"
" 122.630744000095\n"
"(1 row)\n"
"\n"
"SELECT ST_Perimeter(ST_GeomFromText('MULTIPOLYGON(((763104.471273676 "
"2949418.44119003,\n"
"763104.477769673 2949418.42538203,\n"
"763104.189609677 2949418.22343004,763104.471273676 2949418.44119003)),\n"
"((763104.471273676 2949418.44119003,763095.804579742 2949436.33850239,\n"
"763086.132105649 2949451.46730207,763078.452329651 2949462.11549407,\n"
"763075.354136904 2949466.17407812,763064.362142565 2949477.64291974,\n"
"763059.953961626 2949481.28983009,762994.637609571 2949532.04103014,\n"
"762990.568508415 2949535.06640477,762986.710889563 2949539.61421415,\n"
"763117.237897679 2949709.50493431,763235.236617789 2949617.95619822,\n"
"763287.718121842 2949562.20592617,763111.553321674 2949423.91664605,\n"
"763104.471273676 2949418.44119003)))', 2249));\n"
"st_perimeter\n"
"---------\n"
" 845.227713366825\n"
"(1 row)"
msgstr ""

#. Tag: title
#: reference_measure.xml:3146
#, no-c-format
msgid "Examples: Geography"
msgstr ""

#. Tag: para
#: reference_measure.xml:3147
#, no-c-format
msgid ""
"Return perimeter in meters and feet for Polygon and MultiPolygon. Note this "
"is geography (WGS 84 long lat)"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:3148
#, no-c-format
msgid ""
"SELECT  ST_Perimeter(geog) As per_meters, ST_Perimeter(geog)/0.3048 As "
"per_ft\n"
"FROM ST_GeogFromText('POLYGON((-71.1776848522251 "
"42.3902896512902,-71.1776843766326 42.3903829478009,\n"
"-71.1775844305465 42.3903826677917,-71.1775825927231 "
"42.3902893647987,-71.1776848522251 42.3902896512902))') As geog;\n"
"\n"
"   per_meters    |      per_ft\n"
"-----------------+------------------\n"
"37.3790462565251 | 122.634666195949\n"
"\n"
"\n"
"-- MultiPolygon example --\n"
"SELECT  ST_Perimeter(geog) As per_meters, ST_Perimeter(geog,false) As "
"per_sphere_meters,  ST_Perimeter(geog)/0.3048 As per_ft\n"
"FROM ST_GeogFromText('MULTIPOLYGON(((-71.1044543107478 "
"42.340674480411,-71.1044542869917 42.3406744369506,\n"
"-71.1044553562977 42.340673886454,-71.1044543107478 42.340674480411)),\n"
"((-71.1044543107478 42.340674480411,-71.1044860600303 "
"42.3407237015564,-71.1045215770124 42.3407653385914,\n"
"-71.1045498002983 42.3407946553165,-71.1045611902745 "
"42.3408058316308,-71.1046016507427 42.340837442371,\n"
"-71.104617893173 42.3408475056957,-71.1048586153981 "
"42.3409875993595,-71.1048736143677 42.3409959528211,\n"
"-71.1048878050242 42.3410084812078,-71.1044020965803 42.3414730072048,\n"
"-71.1039672113619 42.3412202916693,-71.1037740497748 42.3410666421308,\n"
"-71.1044280218456 42.3406894151355,-71.1044543107478 42.340674480411)))') As "
"geog;\n"
"\n"
"    per_meters    | per_sphere_meters |      per_ft\n"
"------------------+-------------------+------------------\n"
" 257.634283683311 |  257.412311446337 | 845.256836231335"
msgstr ""

#. Tag: para
#: reference_measure.xml:3152
#, no-c-format
msgid ", <xref linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_Length\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:3158
#, no-c-format
msgid "ST_Perimeter2D"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:3160
#, no-c-format
msgid ""
"Returns the 2-dimensional perimeter of the geometry, if it is a polygon or "
"multi-polygon. This is currently an alias for ST_Perimeter."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:3166
#, no-c-format
msgid ""
"<funcdef>float <function>ST_Perimeter2D</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:3176
#, no-c-format
msgid ""
"Returns the 2-dimensional perimeter of the geometry, if it is a polygon or "
"multi-polygon."
msgstr ""

#. Tag: para
#: reference_measure.xml:3181
#, no-c-format
msgid ""
"This is currently an alias for ST_Perimeter. In future versions ST_Perimeter "
"may return the highest dimension perimeter for a geometry. This is still "
"under consideration"
msgstr ""

#. Tag: refname
#: reference_measure.xml:3195
#, no-c-format
msgid "ST_3DPerimeter"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:3197
#, no-c-format
msgid ""
"Returns the 3-dimensional perimeter of the geometry, if it is a polygon or "
"multi-polygon."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:3203
#, no-c-format
msgid ""
"<funcdef>float <function>ST_3DPerimeter</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:3213
#, no-c-format
msgid ""
"Returns the 3-dimensional perimeter of the geometry, if it is a polygon or "
"multi-polygon. If the geometry is 2-dimensional, then the 2-dimensional "
"perimeter is returned."
msgstr ""

#. Tag: para
#: reference_measure.xml:3216
#, no-c-format
msgid "Changed: 2.0.0 In prior versions this used to be called ST_Perimeter3D"
msgstr ""

#. Tag: para
#: reference_measure.xml:3222
#, no-c-format
msgid ""
"Perimeter of a slightly elevated polygon in the air in Massachusetts state "
"plane feet"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:3223
#, no-c-format
msgid ""
"SELECT ST_3DPerimeter(the_geom), ST_Perimeter2d(the_geom), "
"ST_Perimeter(the_geom) FROM\n"
"                        (SELECT ST_GeomFromEWKT('SRID=2249;POLYGON((743238 "
"2967416 2,743238 2967450 1,\n"
"743265.625 2967416 1,743238 2967416 2))') As the_geom) As foo;\n"
"\n"
"  ST_3DPerimeter  |  st_perimeter2d  |   st_perimeter\n"
"------------------+------------------+------------------\n"
" 105.465793597674 | 105.432997272188 | 105.432997272188"
msgstr ""

#. Tag: para
#: reference_measure.xml:3230
#, no-c-format
msgid ", <xref linkend=\"ST_Perimeter\"/>, <xref linkend=\"ST_Perimeter2D\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:3236
#, no-c-format
msgid "ST_PointOnSurface"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:3238
#, no-c-format
msgid "Returns a <varname>POINT</varname> guaranteed to lie on the surface."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:3243
#, no-c-format
msgid ""
"<funcdef>geometry <function>ST_PointOnSurface</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:3255
#, no-c-format
msgid "Returns a <varname>POINT</varname> guaranteed to intersect a surface."
msgstr ""

#. Tag: para
#: reference_measure.xml:3257
#, no-c-format
msgid "&sfs_compliant; s3.2.14.2 // s3.2.18.2"
msgstr ""

#. Tag: para
#: reference_measure.xml:3258
#, no-c-format
msgid ""
"&sqlmm_compliant; SQL-MM 3: 8.1.5, 9.5.6. According to the specs, "
"ST_PointOnSurface works for surface geometries (POLYGONs, MULTIPOLYGONS, "
"CURVED POLYGONS). So PostGIS seems to be extending what the spec allows "
"here. Most databases Oracle,DB II, ESRI SDE seem to only support this "
"function for surfaces. SQL Server 2008 like PostGIS supports for all common "
"geometries."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:3267
#, no-c-format
msgid ""
"SELECT ST_AsText(ST_PointOnSurface('POINT(0 5)'::geometry));\n"
" st_astext\n"
"------------\n"
" POINT(0 5)\n"
"(1 row)\n"
"\n"
"SELECT ST_AsText(ST_PointOnSurface('LINESTRING(0 5, 0 10)'::geometry));\n"
" st_astext\n"
"------------\n"
" POINT(0 5)\n"
"(1 row)\n"
"\n"
"SELECT ST_AsText(ST_PointOnSurface('POLYGON((0 0, 0 5, 5 5, 5 0, 0 0))'::"
"geometry));\n"
"   st_astext\n"
"----------------\n"
" POINT(2.5 2.5)\n"
"(1 row)\n"
"\n"
"SELECT ST_AsEWKT(ST_PointOnSurface(ST_GeomFromEWKT('LINESTRING(0 5 1, 0 0 1, "
"0 10 2)')));\n"
"   st_asewkt\n"
"----------------\n"
" POINT(0 0 1)\n"
"(1 row)"
msgstr ""

#. Tag: para
#: reference_measure.xml:3273
#, no-c-format
msgid ", <xref linkend=\"ST_Point_Inside_Circle\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:3279
#, no-c-format
msgid "ST_Project"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:3281
#, no-c-format
msgid ""
"Returns a <varname>POINT</varname> projected from a start point using a "
"distance in meters and bearing (azimuth) in radians."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:3286
#, no-c-format
msgid ""
"<funcdef>geography <function>ST_Project</function></funcdef> "
"<paramdef><type>geography </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>float </type> <parameter>distance</parameter></paramdef> "
"<paramdef><type>float </type> <parameter>azimuth</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:3302
#, no-c-format
msgid ""
"Returns a <varname>POINT</varname> projected along a geodesic from a start "
"point using an azimuth (bearing) measured in radians and distance measured "
"in meters. This is also called a direct geodesic problem."
msgstr ""

#. Tag: para
#: reference_measure.xml:3303
#, no-c-format
msgid ""
"The azimuth is sometimes called the heading or the bearing in navigation. It "
"is measured relative to true north (azimuth zero). East is azimuth 90 "
"(&#x03C0;/2), south is azimuth 180 (&#x03C0;), west is azimuth 270 "
"(3&#x03C0;/2)."
msgstr ""

#. Tag: para
#: reference_measure.xml:3304
#, no-c-format
msgid "The distance is given in meters."
msgstr ""

#. Tag: title
#: reference_measure.xml:3311
#, no-c-format
msgid ""
"Example: Using degrees - projected point 100,000 meters and bearing 45 "
"degrees"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:3313
#, no-c-format
msgid ""
"SELECT ST_AsText(ST_Project('POINT(0 0)'::geography, 100000, "
"radians(45.0)));\n"
"\n"
"                 st_astext\n"
"--------------------------------------------\n"
" POINT(0.635231029125537 0.639472334729198)\n"
"(1 row)"
msgstr ""

#. Tag: para
#: reference_measure.xml:3319
#, no-c-format
msgid ""
", <xref linkend=\"ST_Distance\"/>, <ulink url=\"http://www.postgresql.org/"
"docs/current/interactive/functions-math.html\">PostgreSQL Math Functions</"
"ulink>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:3325
#, no-c-format
msgid "ST_Relate"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:3327
#, no-c-format
msgid ""
"Returns true if this Geometry is spatially related to anotherGeometry, by "
"testing for intersections between the Interior, Boundary and Exterior of the "
"two geometries as specified by the values in the intersectionMatrixPattern. "
"If no intersectionMatrixPattern is passed in, then returns the maximum "
"intersectionMatrixPattern that relates the 2 geometries."
msgstr ""

#. Tag: funcsynopsis
#: reference_measure.xml:3335
#, no-c-format
msgid ""
"<funcprototype> <funcdef>boolean <function>ST_Relate</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef> "
"<paramdef><type>text </type> <parameter>intersectionMatrixPattern</"
"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>text "
"<function>ST_Relate</function></funcdef> <paramdef><type>geometry </type> "
"<parameter>geomA</parameter></paramdef> <paramdef><type>geometry </type> "
"<parameter>geomB</parameter></paramdef> </funcprototype> <funcprototype> "
"<funcdef>text <function>ST_Relate</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>geomB</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>BoundaryNodeRule</parameter></"
"paramdef> </funcprototype>"
msgstr ""

#. Tag: para
#: reference_measure.xml:3361
#, no-c-format
msgid ""
"Version 1: Takes geomA, geomB, intersectionMatrix and Returns 1 (TRUE) if "
"this Geometry is spatially related to anotherGeometry, by testing for "
"intersections between the Interior, Boundary and Exterior of the two "
"geometries as specified by the values in the <ulink url=\"http://en."
"wikipedia.org/wiki/DE-9IM\">DE-9IM matrix pattern</ulink>."
msgstr ""

#. Tag: para
#: reference_measure.xml:3366
#, no-c-format
msgid ""
"This is especially useful for testing compound checks of intersection, "
"crosses, etc in one step."
msgstr ""

#. Tag: para
#: reference_measure.xml:3369
#, no-c-format
msgid ""
"This is the \"allowable\" version that returns a boolean, not an integer. "
"This is defined in OGC spec"
msgstr ""

#. Tag: para
#: reference_measure.xml:3372
#, no-c-format
msgid ""
"This DOES NOT automagically include an index call. The reason for that is "
"some relationships are anti e.g. Disjoint. If you are using a relationship "
"pattern that requires intersection, then include the &amp;&amp; index call."
msgstr ""

#. Tag: para
#: reference_measure.xml:3377
#, no-c-format
msgid ""
"Version 2: Takes geomA and geomB and returns the <xref linkend=\"DE-9IM\"/>"
msgstr ""

#. Tag: para
#: reference_measure.xml:3379
#, no-c-format
msgid ""
"Version 3: same as version 2, but allows to specify a boundary node rule (1:"
"OGC/MOD2, 2:Endpoint, 3:MultivalentEndpoint, 4:MonovalentEndpoint)"
msgstr ""

#. Tag: para
#: reference_measure.xml:3383
#, no-c-format
msgid "not in OGC spec, but implied. see s2.1.13.2"
msgstr ""

#. Tag: para
#: reference_measure.xml:3388
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 5.1.25"
msgstr ""

#. Tag: para
#: reference_measure.xml:3389
#, no-c-format
msgid ""
"Enhanced: 2.0.0 - added support for specifying boundary node rule (requires "
"GEOS &gt;= 3.0)."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:3396
#, no-c-format
msgid ""
"--Find all compounds that intersect and not touch a poly (interior "
"intersects)\n"
"SELECT l.* , b.name As poly_name\n"
"        FROM polys As b\n"
"INNER JOIN compounds As l\n"
"ON (p.the_geom &amp;&amp; b.the_geom\n"
"AND ST_Relate(l.the_geom, b.the_geom,'T********'));\n"
"\n"
"SELECT ST_Relate(ST_GeometryFromText('POINT(1 2)'), "
"ST_Buffer(ST_GeometryFromText('POINT(1 2)'),2));\n"
"st_relate\n"
"-----------\n"
"0FFFFF212\n"
"\n"
"SELECT ST_Relate(ST_GeometryFromText('LINESTRING(1 2, 3 4)'), "
"ST_GeometryFromText('LINESTRING(5 6, 7 8)'));\n"
"st_relate\n"
"-----------\n"
"FF1FF0102\n"
"\n"
"\n"
"SELECT ST_Relate(ST_GeometryFromText('POINT(1 2)'), "
"ST_Buffer(ST_GeometryFromText('POINT(1 2)'),2), '0FFFFF212');\n"
"st_relate\n"
"-----------\n"
"t\n"
"\n"
"SELECT ST_Relate(ST_GeometryFromText('POINT(1 2)'), "
"ST_Buffer(ST_GeometryFromText('POINT(1 2)'),2), '*FF*FF212');\n"
"st_relate\n"
"-----------\n"
"t"
msgstr ""

#. Tag: para
#: reference_measure.xml:3403
#, no-c-format
msgid ""
", <xref linkend=\"DE-9IM\"/>, <xref linkend=\"ST_Disjoint\"/>, <xref linkend="
"\"ST_Intersects\"/>, <xref linkend=\"ST_Touches\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:3409
#, no-c-format
msgid "ST_RelateMatch"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:3411
#, no-c-format
msgid ""
"Returns true if intersectionMattrixPattern1 implies "
"intersectionMatrixPattern2"
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:3416
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_RelateMatch</function></funcdef> "
"<paramdef><type>text </type> <parameter>intersectionMatrix</parameter></"
"paramdef> <paramdef><type>text </type> <parameter>intersectionMatrixPattern</"
"parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:3427
#, no-c-format
msgid ""
"Takes intersectionMatrix and intersectionMatrixPattern and Returns true if "
"the intersectionMatrix satisfies the intersectionMatrixPattern. For more "
"information refer to <xref linkend=\"DE-9IM\"/>."
msgstr ""

#. Tag: para
#: reference_measure.xml:3430
#, no-c-format
msgid "Availability: 2.0.0 - requires GEOS &gt;= 3.3.0."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:3436
#, no-c-format
msgid ""
"SELECT ST_RelateMatch('101202FFF', 'TTTTTTFFF') ;\n"
"-- result --\n"
"t\n"
"--example of common intersection matrix patterns and example matrices\n"
"-- comparing relationships of involving one invalid geometry and ( a line "
"and polygon that intersect at interior and boundary)\n"
"SELECT mat.name, pat.name, ST_RelateMatch(mat.val, pat.val) As satisfied\n"
"    FROM\n"
"        ( VALUES ('Equality', 'T1FF1FFF1'),\n"
"                ('Overlaps', 'T*T***T**'),\n"
"                ('Within', 'T*F**F***'),\n"
"                ('Disjoint', 'FF*FF****') As pat(name,val)\n"
"        CROSS JOIN\n"
"            (        VALUES ('Self intersections (invalid)', '111111111'),\n"
"                    ('IE2_BI1_BB0_BE1_EI1_EE2', 'FF2101102'),\n"
"                    ('IB1_IE1_BB0_BE0_EI2_EI1_EE2', 'F11F00212')\n"
"            ) As mat(name,val);"
msgstr ""

#. Tag: para
#: reference_measure.xml:3442
#, no-c-format
msgid ", <xref linkend=\"ST_Relate\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:3448
#, no-c-format
msgid "ST_ShortestLine"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:3450
#, no-c-format
msgid "Returns the 2-dimensional shortest line between two geometries"
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:3455
#, no-c-format
msgid ""
"<funcdef>geometry <function>ST_ShortestLine</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:3470
#, no-c-format
msgid ""
"Returns the 2-dimensional shortest line between two geometries. The function "
"will only return the first shortest line if more than one, that the function "
"finds. If g1 and g2 intersects in just one point the function will return a "
"line with both start and end in that intersection-point. If g1 and g2 are "
"intersecting with more than one point the function will return a line with "
"start and end in the same point but it can be any of the intersecting "
"points. The line returned will always start in g1 and end in g2. The length "
"of the line this function returns will always be the same as ST_Distance "
"returns for g1 and g2."
msgstr ""

#. Tag: para
#: reference_measure.xml:3494
#, no-c-format
msgid "Shortest line between point and linestring"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:3497
#, no-c-format
msgid ""
"SELECT ST_AsText(\n"
"        ST_ShortestLine('POINT(100 100)'::geometry,\n"
"                'LINESTRING (20 80, 98 190, 110 180, 50 75 )'::geometry)\n"
"        ) As sline;\n"
"\n"
"\n"
"   sline\n"
"-----------------\n"
"LINESTRING(100 100,73.0769230769231 115.384615384615)"
msgstr ""

#. Tag: para
#: reference_measure.xml:3505
#, no-c-format
msgid "shortest line between polygon and polygon"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:3508
#, no-c-format
msgid ""
"SELECT ST_AsText(\n"
"                ST_ShortestLine(\n"
"                        ST_GeomFromText('POLYGON((175 150, 20 40, 50 60, 125 "
"100, 175 150))'),\n"
"                        ST_Buffer(ST_GeomFromText('POINT(110 170)'), 20)\n"
"                        )\n"
"                ) As slinewkt;\n"
"\n"
" LINESTRING(140.752120669087 125.695053378061,121.111404660392 "
"153.370607753949)"
msgstr ""

#. Tag: para
#: reference_measure.xml:3520
#, no-c-format
msgid ""
", <xref linkend=\"ST_Distance\"/>, <xref linkend=\"ST_LongestLine\"/>, <xref "
"linkend=\"ST_MaxDistance\"/>"
msgstr ""

#. Tag: refname
#: reference_measure.xml:3526
#, no-c-format
msgid "ST_Touches"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:3528
#, no-c-format
msgid ""
"Returns <varname>TRUE</varname> if the geometries have at least one point in "
"common, but their interiors do not intersect."
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:3534
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_Touches</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>g2</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:3549
#, no-c-format
msgid ""
"Returns <varname>TRUE</varname> if the only points in common between "
"<parameter>g1</parameter> and <parameter>g2</parameter> lie in the union of "
"the boundaries of <parameter>g1</parameter> and <parameter>g2</parameter>. "
"The <function>ST_Touches</function> relation applies to all Area/Area, Line/"
"Line, Line/Area, Point/Area and Point/Line pairs of relationships, but "
"<emphasis>not</emphasis> to the Point/Point pair."
msgstr ""

#. Tag: para
#: reference_measure.xml:3556
#, no-c-format
msgid "In mathematical terms, this predicate is expressed as:"
msgstr ""

#. Tag: para
#: reference_measure.xml:3566
#, no-c-format
msgid "The allowable DE-9IM Intersection Matrices for the two geometries are:"
msgstr ""

#. Tag: markup
#: reference_measure.xml:3570
#, no-c-format
msgid "FT*******"
msgstr ""

#. Tag: markup
#: reference_measure.xml:3574
#, no-c-format
msgid "F**T*****"
msgstr ""

#. Tag: markup
#: reference_measure.xml:3578
#, no-c-format
msgid "F***T****"
msgstr ""

#. Tag: para
#: reference_measure.xml:3587
#, no-c-format
msgid ""
"This function call will automatically include a bounding box comparison that "
"will make use of any indexes that are available on the geometries. To avoid "
"using an index, use <function>_ST_Touches</function> instead."
msgstr ""

#. Tag: para
#: reference_measure.xml:3593
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 5.1.28"
msgstr ""

#. Tag: para
#: reference_measure.xml:3599
#, no-c-format
msgid ""
"The <function>ST_Touches</function> predicate returns <varname>TRUE</"
"varname> in all the following illustrations."
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:3669
#, no-c-format
msgid ""
"SELECT ST_Touches('LINESTRING(0 0, 1 1, 0 2)'::geometry, 'POINT(1 1)'::"
"geometry);\n"
" st_touches\n"
"------------\n"
" f\n"
"(1 row)\n"
"\n"
"SELECT ST_Touches('LINESTRING(0 0, 1 1, 0 2)'::geometry, 'POINT(0 2)'::"
"geometry);\n"
" st_touches\n"
"------------\n"
" t\n"
"(1 row)"
msgstr ""

#. Tag: refname
#: reference_measure.xml:3675
#, no-c-format
msgid "ST_Within"
msgstr ""

#. Tag: refpurpose
#: reference_measure.xml:3677
#, no-c-format
msgid "Returns true if the geometry A is completely inside geometry B"
msgstr ""

#. Tag: funcprototype
#: reference_measure.xml:3682
#, no-c-format
msgid ""
"<funcdef>boolean <function>ST_Within</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>A</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>B</parameter></paramdef>"
msgstr ""

#. Tag: para
#: reference_measure.xml:3697
#, no-c-format
msgid ""
"Returns TRUE if geometry A is completely inside geometry B. For this "
"function to make sense, the source geometries must both be of the same "
"coordinate projection, having the same SRID. It is a given that if "
"ST_Within(A,B) is true and ST_Within(B,A) is true, then the two geometries "
"are considered spatially equal."
msgstr ""

#. Tag: para
#: reference_measure.xml:3714
#, no-c-format
msgid ""
"This function call will automatically include a bounding box comparison that "
"will make use of any indexes that are available on the geometries. To avoid "
"index use, use the function _ST_Within."
msgstr ""

#. Tag: para
#: reference_measure.xml:3722
#, no-c-format
msgid "&sfs_compliant; s2.1.1.2 // s2.1.13.3 - a.Relate(b, 'T*F**F***')"
msgstr ""

#. Tag: para
#: reference_measure.xml:3725
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 5.1.30"
msgstr ""

#. Tag: programlisting
#: reference_measure.xml:3730
#, no-c-format
msgid ""
"--a circle within a circle\n"
"SELECT ST_Within(smallc,smallc) As smallinsmall,\n"
"        ST_Within(smallc, bigc) As smallinbig,\n"
"        ST_Within(bigc,smallc) As biginsmall,\n"
"        ST_Within(ST_Union(smallc, bigc), bigc) as unioninbig,\n"
"        ST_Within(bigc, ST_Union(smallc, bigc)) as biginunion,\n"
"        ST_Equals(bigc, ST_Union(smallc, bigc)) as bigisunion\n"
"FROM\n"
"(\n"
"SELECT ST_Buffer(ST_GeomFromText('POINT(50 50)'), 20) As smallc,\n"
"        ST_Buffer(ST_GeomFromText('POINT(50 50)'), 40) As bigc) As foo;\n"
"--Result\n"
" smallinsmall | smallinbig | biginsmall | unioninbig | biginunion | "
"bigisunion\n"
"--------------+------------+------------+------------+------------"
"+------------\n"
" t            | t          | f          | t          | t          | t\n"
"(1 row)"
msgstr ""

#. Tag: para
#: reference_measure.xml:3741
#, no-c-format
msgid ", <xref linkend=\"ST_Equals\"/>, <xref linkend=\"ST_IsValid\"/>"
msgstr ""