# SOME DESCRIPTIVE TITLE.
# FIRST AUTHOR <EMAIL@ADDRESS>, YEAR.
#
#, fuzzy
msgid ""
msgstr ""
"Project-Id-Version: PACKAGE VERSION\n"
"Report-Msgid-Bugs-To: https://bugs.kde.org\n"
"POT-Creation-Date: 2021-11-08 06:12+0000\n"
"PO-Revision-Date: YEAR-MO-DA HO:MI+ZONE\n"
"Last-Translator: FULL NAME <EMAIL@ADDRESS>\n"
"Language-Team: LANGUAGE <kde-i18n-doc@kde.org>\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
#. Tag: para
#: reference_output.xml:6
#, no-c-format
msgid ""
"These functions convert geometry objects into various textual or binary "
"formats."
msgstr ""
#. Tag: title
#: reference_output.xml:10
#, no-c-format
msgid "Geometry Output"
msgstr ""
#. Tag: title
#: reference_output.xml:13
#, no-c-format
msgid "Well-Known Text (WKT)"
msgstr ""
#. Tag: refname
#: reference_output.xml:17
#, no-c-format
msgid "ST_AsEWKT"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:18
#, no-c-format
msgid ""
"Return the Well-Known Text (WKT) representation of the geometry with SRID "
"meta data."
msgstr ""
#. Tag: funcsynopsis
#: reference_output.xml:22
#, no-c-format
msgid ""
"<funcprototype> <funcdef>text <function>ST_AsEWKT</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>text <function>ST_AsEWKT</function></"
"funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></"
"paramdef> <paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=15</parameter></paramdef> </funcprototype> "
"<funcprototype> <funcdef>text <function>ST_AsEWKT</function></funcdef> "
"<paramdef><type>geography </type> <parameter>g1</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>text <function>ST_AsEWKT</function></"
"funcdef> <paramdef><type>geography </type> <parameter>g1</parameter></"
"paramdef> <paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=15</parameter></paramdef> </funcprototype>"
msgstr ""
#. Tag: title
#: reference_output.xml:45 reference_output.xml:127 reference_output.xml:219
#: reference_output.xml:296 reference_output.xml:359 reference_output.xml:402
#: reference_output.xml:456 reference_output.xml:494 reference_output.xml:547
#: reference_output.xml:694 reference_output.xml:808 reference_output.xml:874
#: reference_output.xml:942 reference_output.xml:1018 reference_output.xml:1096
#: reference_output.xml:1149 reference_output.xml:1197
#: reference_output.xml:1319
#, no-c-format
msgid "Description"
msgstr ""
#. Tag: para
#: reference_output.xml:47
#, no-c-format
msgid ""
"Returns the Well-Known Text representation of the geometry prefixed with the "
"SRID. The optional <parameter>maxdecimaldigits</parameter> argument may be "
"used to reduce the maximum number of decimal digits after floating point "
"used in output (defaults to 15)."
msgstr ""
#. Tag: para
#: reference_output.xml:51
#, no-c-format
msgid ""
"To perform the inverse conversion of EWKT representation to PostGIS geometry "
"use <xref linkend=\"ST_GeomFromEWKT\"/>."
msgstr ""
#. Tag: para
#: reference_output.xml:55 reference_output.xml:149 reference_output.xml:557
#: reference_output.xml:703 reference_output.xml:815
#, no-c-format
msgid ""
"Using the <parameter>maxdecimaldigits</parameter> parameter can cause output "
"geometry to become invalid. To avoid this use <xref linkend="
"\"ST_ReducePrecision\"/> with a suitable gridsize first."
msgstr ""
#. Tag: para
#: reference_output.xml:63
#, no-c-format
msgid ""
"The WKT spec does not include the SRID. To get the OGC WKT format use <xref "
"linkend=\"ST_AsText\"/>."
msgstr ""
#. Tag: para
#: reference_output.xml:66
#, no-c-format
msgid ""
"WKT format does not maintain precision so to prevent floating truncation, "
"use <xref linkend=\"ST_AsBinary\"/> or <xref linkend=\"ST_AsEWKB\"/> format "
"for transport."
msgstr ""
#. Tag: para
#: reference_output.xml:70
#, no-c-format
msgid "Enhanced: 3.1.0 support for optional precision parameter."
msgstr ""
#. Tag: para
#: reference_output.xml:71
#, no-c-format
msgid ""
"Enhanced: 2.0.0 support for Geography, Polyhedral surfaces, Triangles and "
"TIN was introduced."
msgstr ""
#. Tag: para
#: reference_output.xml:73 reference_output.xml:252 reference_output.xml:314
#: reference_output.xml:367 reference_output.xml:612 reference_output.xml:753
#: reference_output.xml:843 reference_output.xml:1274
#, no-c-format
msgid "&Z_support;"
msgstr ""
#. Tag: para
#: reference_output.xml:74 reference_output.xml:160 reference_output.xml:249
#: reference_output.xml:315 reference_output.xml:368 reference_output.xml:1333
#, no-c-format
msgid "&curve_support;"
msgstr ""
#. Tag: para
#: reference_output.xml:75 reference_output.xml:250 reference_output.xml:316
#: reference_output.xml:754 reference_output.xml:1276
#, no-c-format
msgid "&P_support;"
msgstr ""
#. Tag: para
#: reference_output.xml:76 reference_output.xml:251 reference_output.xml:317
#: reference_output.xml:755 reference_output.xml:1279
#, no-c-format
msgid "&T_support;"
msgstr ""
#. Tag: title
#: reference_output.xml:81 reference_output.xml:164 reference_output.xml:257
#: reference_output.xml:322 reference_output.xml:372 reference_output.xml:411
#: reference_output.xml:509 reference_output.xml:616 reference_output.xml:847
#: reference_output.xml:903 reference_output.xml:962 reference_output.xml:1058
#: reference_output.xml:1115 reference_output.xml:1164
#: reference_output.xml:1337
#, no-c-format
msgid "Examples"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:83
#, no-c-format
msgid ""
"SELECT ST_AsEWKT('0103000020E61000000100000005000000000000\n"
" 000000000000000000000000000000000000000000000000000000\n"
" F03F000000000000F03F000000000000F03F000000000000F03\n"
" F000000000000000000000000000000000000000000000000'::"
"geometry);\n"
"\n"
" st_asewkt\n"
"--------------------------------\n"
"SRID=4326;POLYGON((0 0,0 1,1 1,1 0,0 0))\n"
"(1 row)\n"
"\n"
"SELECT "
"ST_AsEWKT('0108000080030000000000000060E30A4100000000785C0241000000000000F03F0000000018\n"
"E20A4100000000485F024100000000000000400000000018\n"
"E20A4100000000305C02410000000000000840')\n"
"\n"
"--st_asewkt---\n"
"CIRCULARSTRING(220268 150415 1,220227 150505 2,220227 150406 3)"
msgstr ""
#. Tag: title
#: reference_output.xml:88 reference_output.xml:177 reference_output.xml:265
#: reference_output.xml:330 reference_output.xml:424 reference_output.xml:639
#: reference_output.xml:773 reference_output.xml:851 reference_output.xml:967
#: reference_output.xml:1064 reference_output.xml:1173
#: reference_output.xml:1341
#, no-c-format
msgid "See Also"
msgstr ""
#. Tag: para
#: reference_output.xml:89
#, no-c-format
msgid ""
", <xref linkend=\"ST_AsEWKB\"/>, <xref linkend=\"ST_AsText\"/>, <xref "
"linkend=\"ST_GeomFromEWKT\"/>"
msgstr ""
#. Tag: refname
#: reference_output.xml:99
#, no-c-format
msgid "ST_AsText"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:100
#, no-c-format
msgid ""
"Return the Well-Known Text (WKT) representation of the geometry/geography "
"without SRID metadata."
msgstr ""
#. Tag: funcsynopsis
#: reference_output.xml:104
#, no-c-format
msgid ""
"<funcprototype> <funcdef>text <function>ST_AsText</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>text <function>ST_AsText</function></"
"funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></"
"paramdef> <paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits = 15</parameter></paramdef> </funcprototype> "
"<funcprototype> <funcdef>text <function>ST_AsText</function></funcdef> "
"<paramdef><type>geography </type> <parameter>g1</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>text <function>ST_AsText</function></"
"funcdef> <paramdef><type>geography </type> <parameter>g1</parameter></"
"paramdef> <paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits = 15</parameter></paramdef> </funcprototype>"
msgstr ""
#. Tag: para
#: reference_output.xml:129
#, no-c-format
msgid ""
"Returns the OGC <link linkend=\"OpenGISWKBWKT\">Well-Known Text</link> (WKT) "
"representation of the geometry/geography. The optional "
"<parameter>maxdecimaldigits</parameter> argument may be used to limit the "
"number of digits after the decimal point in output ordinates (defaults to "
"15)."
msgstr ""
#. Tag: para
#: reference_output.xml:133
#, no-c-format
msgid ""
"To perform the inverse conversion of WKT representation to PostGIS geometry "
"use <xref linkend=\"ST_GeomFromText\"/>."
msgstr ""
#. Tag: para
#: reference_output.xml:137
#, no-c-format
msgid ""
"The standard OGC WKT representation does not include the SRID. To include "
"the SRID as part of the output representation, use the non-standard PostGIS "
"function <xref linkend=\"ST_AsEWKT\"/>"
msgstr ""
#. Tag: para
#: reference_output.xml:142
#, no-c-format
msgid ""
"The textual representation of numbers in WKT may not maintain full floating-"
"point precision. To ensure full accuracy for data storage or transport it is "
"best to use <link linkend=\"OpenGISWKBWKT\">Well-Known Binary</link> (WKB) "
"format (see <xref linkend=\"ST_AsBinary\"/> and <parameter>maxdecimaldigits</"
"parameter>)."
msgstr ""
#. Tag: para
#: reference_output.xml:156
#, no-c-format
msgid "Availability: 1.5 - support for geography was introduced."
msgstr ""
#. Tag: para
#: reference_output.xml:157
#, no-c-format
msgid "Enhanced: 2.5 - optional parameter precision introduced."
msgstr ""
#. Tag: para
#: reference_output.xml:158 reference_output.xml:247
#, no-c-format
msgid "&sfs_compliant; s2.1.1.1"
msgstr ""
#. Tag: para
#: reference_output.xml:159
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 5.1.25"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:166
#, no-c-format
msgid ""
"SELECT ST_AsText('01030000000100000005000000000000000000\n"
"000000000000000000000000000000000000000000000000\n"
"F03F000000000000F03F000000000000F03F000000000000F03\n"
"F000000000000000000000000000000000000000000000000');\n"
"\n"
" st_astext\n"
"--------------------------------\n"
" POLYGON((0 0,0 1,1 1,1 0,0 0))"
msgstr ""
#. Tag: para
#: reference_output.xml:168
#, no-c-format
msgid "Full precision output is the default."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:169
#, no-c-format
msgid ""
"SELECT ST_AsText('POINT(111.1111111 1.1111111)'));\n"
" st_astext\n"
"------------------------------\n"
" POINT(111.1111111 1.1111111)"
msgstr ""
#. Tag: para
#: reference_output.xml:171
#, no-c-format
msgid ""
"The <parameter>maxdecimaldigits</parameter> argument can be used to limit "
"output precision."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:172
#, no-c-format
msgid ""
"SELECT ST_AsText('POINT(111.1111111 1.1111111)'), 2);\n"
" st_astext\n"
"--------------------\n"
" POINT(111.11 1.11)"
msgstr ""
#. Tag: para
#: reference_output.xml:179
#, no-c-format
msgid ""
", <xref linkend=\"ST_AsEWKB\"/>, <xref linkend=\"ST_AsEWKT\"/>, <xref "
"linkend=\"ST_GeomFromText\"/>"
msgstr ""
#. Tag: title
#: reference_output.xml:187
#, no-c-format
msgid "Well-Known Binary (WKB)"
msgstr ""
#. Tag: refname
#: reference_output.xml:191
#, no-c-format
msgid "ST_AsBinary"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:192
#, no-c-format
msgid ""
"Return the OGC/ISO Well-Known Binary (WKB) representation of the geometry/"
"geography without SRID meta data."
msgstr ""
#. Tag: funcsynopsis
#: reference_output.xml:196
#, no-c-format
msgid ""
"<funcprototype> <funcdef>bytea <function>ST_AsBinary</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>bytea <function>ST_AsBinary</"
"function></funcdef> <paramdef><type>geometry </type> <parameter>g1</"
"parameter></paramdef> <paramdef><type>text </type><parameter>NDR_or_XDR</"
"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>bytea "
"<function>ST_AsBinary</function></funcdef> <paramdef><type>geography </type> "
"<parameter>g1</parameter></paramdef> </funcprototype> <funcprototype> "
"<funcdef>bytea <function>ST_AsBinary</function></funcdef> "
"<paramdef><type>geography </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>text </type><parameter>NDR_or_XDR</parameter></paramdef> </"
"funcprototype>"
msgstr ""
#. Tag: para
#: reference_output.xml:221
#, no-c-format
msgid ""
"Returns the OGC/ISO <link linkend=\"OpenGISWKBWKT\">Well-Known Binary</link> "
"(WKB) representation of the geometry. The first function variant defaults to "
"encoding using server machine endian. The second function variant takes a "
"text argument specifying the endian encoding, either little-endian ('NDR') "
"or big-endian ('XDR')."
msgstr ""
#. Tag: para
#: reference_output.xml:226 reference_output.xml:302
#, no-c-format
msgid ""
"WKB format is useful to read geometry data from the database and maintaining "
"full numeric precision. This avoids the precision rounding that can happen "
"with text formats such as WKT."
msgstr ""
#. Tag: para
#: reference_output.xml:230
#, no-c-format
msgid ""
"To perform the inverse conversion of WKB to PostGIS geometry use <xref "
"linkend=\"ST_GeomFromWKB\"/>."
msgstr ""
#. Tag: para
#: reference_output.xml:233
#, no-c-format
msgid ""
"The OGC/ISO WKB format does not include the SRID. To get the EWKB format "
"which does include the SRID use <xref linkend=\"ST_AsEWKB\"/>"
msgstr ""
#. Tag: para
#: reference_output.xml:237
#, no-c-format
msgid ""
"The default behavior in PostgreSQL 9.0 has been changed to output bytea in "
"hex encoding. If your GUI tools require the old behavior, then SET "
"bytea_output='escape' in your database."
msgstr ""
#. Tag: para
#: reference_output.xml:241 reference_output.xml:313
#, no-c-format
msgid ""
"Enhanced: 2.0.0 support for Polyhedral surfaces, Triangles and TIN was "
"introduced."
msgstr ""
#. Tag: para
#: reference_output.xml:242
#, no-c-format
msgid ""
"Enhanced: 2.0.0 support for higher coordinate dimensions was introduced."
msgstr ""
#. Tag: para
#: reference_output.xml:243
#, no-c-format
msgid ""
"Enhanced: 2.0.0 support for specifying endian with geography was introduced."
msgstr ""
#. Tag: para
#: reference_output.xml:244 reference_output.xml:608 reference_output.xml:747
#, no-c-format
msgid "Availability: 1.5.0 geography support was introduced."
msgstr ""
#. Tag: para
#: reference_output.xml:245
#, no-c-format
msgid ""
"Changed: 2.0.0 Inputs to this function can not be unknown -- must be "
"geometry. Constructs such as <code>ST_AsBinary('POINT(1 2)')</code> are no "
"longer valid and you will get an <code>n st_asbinary(unknown) is not unique "
"error</code>. Code like that needs to be changed to "
"<code>ST_AsBinary('POINT(1 2)'::geometry);</code>. If that is not possible, "
"then install <filename>legacy.sql</filename>."
msgstr ""
#. Tag: para
#: reference_output.xml:248
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM 3: 5.1.37"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:259
#, no-c-format
msgid ""
"SELECT ST_AsBinary(ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))',4326));\n"
"\n"
" st_asbinary\n"
"--------------------------------\n"
"\\x01030000000100000005000000000000000000000000000000000000000000000000000000000000\n"
"000000f03f000000000000f03f000000000000f03f000000000000f03f0000000000000000000000\n"
"00000000000000000000000000"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:260
#, no-c-format
msgid ""
"SELECT ST_AsBinary(ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))',4326), "
"'XDR');\n"
" st_asbinary\n"
"--------------------------------\n"
"\\x000000000300000001000000050000000000000000000000000000000000000000000000003ff000\n"
"00000000003ff00000000000003ff00000000000003ff00000000000000000000000000000000000\n"
"00000000000000000000000000"
msgstr ""
#. Tag: para
#: reference_output.xml:266
#, no-c-format
msgid ""
", <xref linkend=\"ST_AsEWKB\"/>, <xref linkend=\"ST_AsTWKB\"/>, <xref "
"linkend=\"ST_AsText\"/>,"
msgstr ""
#. Tag: refname
#: reference_output.xml:277
#, no-c-format
msgid "ST_AsEWKB"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:278
#, no-c-format
msgid ""
"Return the Extended Well-Known Binary (EWKB) representation of the geometry "
"with SRID meta data."
msgstr ""
#. Tag: funcsynopsis
#: reference_output.xml:282
#, no-c-format
msgid ""
"<funcprototype> <funcdef>bytea <function>ST_AsEWKB</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>bytea <function>ST_AsEWKB</"
"function></funcdef> <paramdef><type>geometry </type> <parameter>g1</"
"parameter></paramdef> <paramdef><type>text </type><parameter>NDR_or_XDR</"
"parameter></paramdef> </funcprototype>"
msgstr ""
#. Tag: para
#: reference_output.xml:297
#, no-c-format
msgid ""
"Returns the <link linkend=\"EWKB_EWKT\">Extended Well-Known Binary</link> "
"(EWKB) representation of the geometry with SRID metadata. The first function "
"variant defaults to encoding using server machine endian. The second "
"function variant takes a text argument specifying the endian encoding, "
"either little-endian ('NDR') or big-endian ('XDR')."
msgstr ""
#. Tag: para
#: reference_output.xml:306
#, no-c-format
msgid ""
"To perform the inverse conversion of EWKB to PostGIS geometry use <xref "
"linkend=\"ST_GeomFromEWKB\"/>."
msgstr ""
#. Tag: para
#: reference_output.xml:309
#, no-c-format
msgid ""
"To get the OGC/ISO WKB format use <xref linkend=\"ST_AsBinary\"/>. Note that "
"OGC/ISO WKB format does not include the SRID."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:324
#, no-c-format
msgid ""
"SELECT ST_AsEWKB(ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))',4326));\n"
"\n"
" st_asewkb\n"
"--------------------------------\n"
"\\x0103000020e610000001000000050000000000000000000000000000000000000000000000000000\n"
"00000000000000f03f000000000000f03f000000000000f03f000000000000f03f00000000000000\n"
"0000000000000000000000000000000000"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:325
#, no-c-format
msgid ""
"SELECT ST_AsEWKB(ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))',4326), "
"'XDR');\n"
" st_asewkb\n"
"--------------------------------\n"
"\\x0020000003000010e600000001000000050000000000000000000000000000000000000000000000\n"
"003ff00000000000003ff00000000000003ff00000000000003ff000000000000000000000000000\n"
"0000000000000000000000000000000000"
msgstr ""
#. Tag: para
#: reference_output.xml:331
#, no-c-format
msgid ", <xref linkend=\"ST_GeomFromEWKB\"/>, <xref linkend=\"ST_SRID\"/>"
msgstr ""
#. Tag: refname
#: reference_output.xml:337
#, no-c-format
msgid "ST_AsHEXEWKB"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:339
#, no-c-format
msgid ""
"Returns a Geometry in HEXEWKB format (as text) using either little-endian "
"(NDR) or big-endian (XDR) encoding."
msgstr ""
#. Tag: funcsynopsis
#: reference_output.xml:344
#, no-c-format
msgid ""
"<funcprototype> <funcdef>text <function>ST_AsHEXEWKB</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>text </type> <parameter>NDRorXDR</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>text <function>ST_AsHEXEWKB</"
"function></funcdef> <paramdef><type>geometry </type> <parameter>g1</"
"parameter></paramdef> </funcprototype>"
msgstr ""
#. Tag: para
#: reference_output.xml:361
#, no-c-format
msgid ""
"Returns a Geometry in HEXEWKB format (as text) using either little-endian "
"(NDR) or big-endian (XDR) encoding. If no encoding is specified, then NDR is "
"used."
msgstr ""
#. Tag: para
#: reference_output.xml:365
#, no-c-format
msgid "Availability: 1.2.2"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:373
#, no-c-format
msgid ""
"SELECT ST_AsHEXEWKB(ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 "
"0))',4326));\n"
" which gives same answer as\n"
"\n"
" SELECT ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 "
"0))',4326)::text;\n"
"\n"
" st_ashexewkb\n"
" --------\n"
" 0103000020E6100000010000000500\n"
" 00000000000000000000000000000000\n"
" 00000000000000000000000000000000F03F\n"
" 000000000000F03F000000000000F03F000000000000F03\n"
" F000000000000000000000000000000000000000000000000"
msgstr ""
#. Tag: title
#: reference_output.xml:383
#, no-c-format
msgid "Other Formats"
msgstr ""
#. Tag: refname
#: reference_output.xml:387
#, no-c-format
msgid "ST_AsEncodedPolyline"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:388
#, no-c-format
msgid "Returns an Encoded Polyline from a LineString geometry."
msgstr ""
#. Tag: funcprototype
#: reference_output.xml:393
#, no-c-format
msgid ""
"<funcdef>text <function>ST_AsEncodedPolyline</function></funcdef> "
"<paramdef><type>geometry</type> <parameter>geom</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>integer </type> <parameter>precision=5</"
"parameter></paramdef>"
msgstr ""
#. Tag: para
#: reference_output.xml:404
#, no-c-format
msgid ""
"Returns the geometry as an Encoded Polyline. This format is used by Google "
"Maps with precision=5 and by Open Source Routing Machine with precision=5 "
"and 6."
msgstr ""
#. Tag: para
#: reference_output.xml:405
#, no-c-format
msgid ""
"Optional <varname>precision</varname> specifies how many decimal places will "
"be preserved in Encoded Polyline. Value should be the same on encoding and "
"decoding, or coordinates will be incorrect."
msgstr ""
#. Tag: para
#: reference_output.xml:407 reference_output.xml:1159
#, no-c-format
msgid "Availability: 2.2.0"
msgstr ""
#. Tag: para
#: reference_output.xml:412
#, no-c-format
msgid "Basic"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:413
#, no-c-format
msgid ""
"SELECT ST_AsEncodedPolyline(GeomFromEWKT('SRID=4326;LINESTRING(-120.2 "
"38.5,-120.95 40.7,-126.453 43.252)'));\n"
" --result--\n"
" |_p~iF~ps|U_ulLnnqC_mqNvxq`@"
msgstr ""
#. Tag: para
#: reference_output.xml:415
#, no-c-format
msgid ""
"Use in conjunction with geography linestring and geography segmentize, and "
"put on google maps"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:416
#, no-c-format
msgid ""
"-- the SQL for Boston to San Francisco, segments every 100 KM\n"
" SELECT ST_AsEncodedPolyline(\n"
" ST_Segmentize(\n"
" ST_GeogFromText('LINESTRING(-71.0519 "
"42.4935,-122.4483 37.64)'),\n"
" 100000)::geometry) As encodedFlightPath;"
msgstr ""
#. Tag: para
#: reference_output.xml:419
#, no-c-format
msgid ""
"javascript will look something like this where $ variable you replace with "
"query result"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:420
#, no-c-format
msgid ""
"<![CDATA[<script type=\"text/javascript\" src=\"http://maps.googleapis.com/"
"maps/api/js?libraries=geometry\"></script>\n"
"<script type=\"text/javascript\">\n"
" flightPath = new google.maps.Polyline({\n"
" path: google.maps.geometry.encoding."
"decodePath(\"$encodedFlightPath\"),\n"
" map: map,\n"
" strokeColor: '#0000CC',\n"
" strokeOpacity: 1.0,\n"
" strokeWeight: 4\n"
" });\n"
"</script>\n"
" ]]>"
msgstr ""
#. Tag: para
#: reference_output.xml:425
#, no-c-format
msgid ", <xref linkend=\"ST_Segmentize\"/>"
msgstr ""
#. Tag: refname
#: reference_output.xml:431
#, no-c-format
msgid "ST_AsFlatGeobuf"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:433
#, no-c-format
msgid "Return a FlatGeobuf representation of a set of rows."
msgstr ""
#. Tag: funcsynopsis
#: reference_output.xml:436
#, no-c-format
msgid ""
"<funcprototype> <funcdef>bytea <function>ST_AsFlatGeobuf</function></"
"funcdef> <paramdef><type>anyelement set </type> <parameter>row</parameter></"
"paramdef> </funcprototype> <funcprototype> <funcdef>bytea "
"<function>ST_AsFlatGeobuf</function></funcdef> <paramdef><type>anyelement </"
"type> <parameter>row</parameter></paramdef> <paramdef><type>bool </type> "
"<parameter>index</parameter></paramdef> </funcprototype> <funcprototype> "
"<funcdef>bytea <function>ST_AsFlatGeobuf</function></funcdef> "
"<paramdef><type>anyelement </type> <parameter>row</parameter></paramdef> "
"<paramdef><type>bool </type> <parameter>index</parameter></paramdef> "
"<paramdef><type>text </type> <parameter>geom_name</parameter></paramdef> </"
"funcprototype>"
msgstr ""
#. Tag: para
#: reference_output.xml:458
#, no-c-format
msgid ""
"Return a FlatGeobuf representation (<ulink url=\"http://flatgeobuf.org"
"\">http://flatgeobuf.org</ulink>) of a set of rows corresponding to a "
"FeatureCollection. NOTE: PostgreSQL bytea cannot exceed 1GB."
msgstr ""
#. Tag: para
#: reference_output.xml:465 reference_output.xml:502 reference_output.xml:1045
#, no-c-format
msgid "<varname>row</varname> row data with at least a geometry column."
msgstr ""
#. Tag: para
#: reference_output.xml:466
#, no-c-format
msgid ""
"<varname>index</varname> toggle spatial index creation. Default is false."
msgstr ""
#. Tag: para
#: reference_output.xml:467 reference_output.xml:503
#, no-c-format
msgid ""
"<varname>geom_name</varname> is the name of the geometry column in the row "
"data. If NULL it will default to the first found geometry column."
msgstr ""
#. Tag: para
#: reference_output.xml:469
#, no-c-format
msgid "Availability: 3.2.0"
msgstr ""
#. Tag: refname
#: reference_output.xml:475
#, no-c-format
msgid "ST_AsGeobuf"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:477
#, no-c-format
msgid "Return a Geobuf representation of a set of rows."
msgstr ""
#. Tag: funcsynopsis
#: reference_output.xml:480
#, no-c-format
msgid ""
"<funcprototype> <funcdef>bytea <function>ST_AsGeobuf</function></funcdef> "
"<paramdef><type>anyelement set </type> <parameter>row</parameter></paramdef> "
"</funcprototype> <funcprototype> <funcdef>bytea <function>ST_AsGeobuf</"
"function></funcdef> <paramdef><type>anyelement </type> <parameter>row</"
"parameter></paramdef> <paramdef><type>text </type> <parameter>geom_name</"
"parameter></paramdef> </funcprototype>"
msgstr ""
#. Tag: para
#: reference_output.xml:496
#, no-c-format
msgid ""
"Return a Geobuf representation (<ulink url=\"https://github.com/mapbox/geobuf"
"\">https://github.com/mapbox/geobuf</ulink>) of a set of rows corresponding "
"to a FeatureCollection. Every input geometry is analyzed to determine "
"maximum precision for optimal storage. Note that Geobuf in its current form "
"cannot be streamed so the full output will be assembled in memory."
msgstr ""
#. Tag: para
#: reference_output.xml:505 reference_output.xml:954 reference_output.xml:1054
#, no-c-format
msgid "Availability: 2.4.0"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:510
#, no-c-format
msgid ""
"<![CDATA[SELECT encode(ST_AsGeobuf(q, 'geom'), 'base64')\n"
" FROM (SELECT ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 0))') AS geom) "
"AS q;\n"
" st_asgeobuf\n"
"----------------------------------\n"
" GAAiEAoOCgwIBBoIAAAAAgIAAAE=\n"
"\n"
" ]]>"
msgstr ""
#. Tag: refname
#: reference_output.xml:517
#, no-c-format
msgid "ST_AsGeoJSON"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:519
#, no-c-format
msgid "Return a geometry as a GeoJSON element."
msgstr ""
#. Tag: funcsynopsis
#: reference_output.xml:523
#, no-c-format
msgid ""
"<funcprototype> <funcdef>text <function>ST_AsGeoJSON</function></funcdef> "
"<paramdef><type>record </type> <parameter>feature</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>text </type> <parameter>geomcolumnname</"
"parameter></paramdef> <paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=9</parameter></paramdef> <paramdef choice=\"opt"
"\"><type>boolean </type> <parameter>pretty_bool=false</parameter></paramdef> "
"</funcprototype> <funcprototype> <funcdef>text <function>ST_AsGeoJSON</"
"function></funcdef> <paramdef><type>geometry </type> <parameter>geom</"
"parameter></paramdef> <paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=9</parameter></paramdef> <paramdef choice=\"opt"
"\"><type>integer </type> <parameter>options=8</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>text <function>ST_AsGeoJSON</"
"function></funcdef> <paramdef><type>geography </type> <parameter>geog</"
"parameter></paramdef> <paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=9</parameter></paramdef> <paramdef choice=\"opt"
"\"><type>integer </type> <parameter>options=0</parameter></paramdef> </"
"funcprototype>"
msgstr ""
#. Tag: para
#: reference_output.xml:549
#, no-c-format
msgid ""
"Returns a geometry as a GeoJSON \"geometry\", or a row as a GeoJSON \"feature"
"\". (See the <ulink url=\"https://tools.ietf.org/html/rfc7946\">GeoJSON "
"specifications RFC 7946</ulink>). 2D and 3D Geometries are both supported. "
"GeoJSON only support SFS 1.1 geometry types (no curve support for example)."
msgstr ""
#. Tag: para
#: reference_output.xml:554
#, no-c-format
msgid ""
"The <varname>maxdecimaldigits</varname> argument may be used to reduce the "
"maximum number of decimal places used in output (defaults to 9). If you are "
"using EPSG:4326 and are outputting the geometry only for display, "
"<varname>maxdecimaldigits</varname>=6 can be a good choice for many maps."
msgstr ""
#. Tag: para
#: reference_output.xml:564
#, no-c-format
msgid ""
"The <varname>options</varname> argument can be used to add BBOX or CRS in "
"GeoJSON output:"
msgstr ""
#. Tag: para
#: reference_output.xml:567
#, no-c-format
msgid "0: means no option"
msgstr ""
#. Tag: para
#: reference_output.xml:571
#, no-c-format
msgid "1: GeoJSON BBOX"
msgstr ""
#. Tag: para
#: reference_output.xml:575
#, no-c-format
msgid "2: GeoJSON Short CRS (e.g EPSG:4326)"
msgstr ""
#. Tag: para
#: reference_output.xml:579
#, no-c-format
msgid "4: GeoJSON Long CRS (e.g urn:ogc:def:crs:EPSG::4326)"
msgstr ""
#. Tag: para
#: reference_output.xml:583
#, no-c-format
msgid "8: GeoJSON Short CRS if not EPSG:4326 (default)"
msgstr ""
#. Tag: para
#: reference_output.xml:588
#, no-c-format
msgid ""
"The GeoJSON specification states that polygons are oriented using the Right-"
"Hand Rule, and some clients require this orientation. This can be ensured by "
"using <xref linkend=\"ST_ForcePolygonCCW\"/>. The specification also "
"requires that geometry be in the WGS84 coordinate system (SRID = 4326). If "
"necessary geometry can be projected into WGS84 using <xref linkend="
"\"ST_Transform\"/>: <code>ST_Transform( geom, 4326 )</code>."
msgstr ""
#. Tag: para
#: reference_output.xml:597
#, no-c-format
msgid ""
"GeoJSON can be tested and viewed online at <ulink url=\"http://geojson.io/"
"\">geojson.io</ulink> and <ulink url=\"http://geojson.io/\">geojsonlint.com</"
"ulink>. It is widely supported by web mapping frameworks:"
msgstr ""
#. Tag: ulink
#: reference_output.xml:601
#, no-c-format
msgid "OpenLayers GeoJSON Example"
msgstr ""
#. Tag: ulink
#: reference_output.xml:602
#, no-c-format
msgid "Leaflet GeoJSON Example"
msgstr ""
#. Tag: ulink
#: reference_output.xml:603
#, no-c-format
msgid "Mapbox GL GeoJSON Example"
msgstr ""
#. Tag: para
#: reference_output.xml:607
#, no-c-format
msgid "Availability: 1.3.4"
msgstr ""
#. Tag: para
#: reference_output.xml:609
#, no-c-format
msgid "Changed: 2.0.0 support default args and named args."
msgstr ""
#. Tag: para
#: reference_output.xml:610
#, no-c-format
msgid "Changed: 3.0.0 support records as input"
msgstr ""
#. Tag: para
#: reference_output.xml:611
#, no-c-format
msgid "Changed: 3.0.0 output SRID if not EPSG:4326."
msgstr ""
#. Tag: para
#: reference_output.xml:618
#, no-c-format
msgid "Generate a FeatureCollection:"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:619
#, no-c-format
msgid ""
"SELECT json_build_object(\n"
" 'type', 'FeatureCollection',\n"
" 'features', json_agg(ST_AsGeoJSON(t.*)::json)\n"
" )\n"
"FROM ( VALUES (1, 'one', 'POINT(1 1)'::geometry),\n"
" (2, 'two', 'POINT(2 2)'),\n"
" (3, 'three', 'POINT(3 3)')\n"
" ) as t(id, name, geom);"
msgstr ""
#. Tag: screen
#: reference_output.xml:620
#, no-c-format
msgid ""
"{\"type\" : \"FeatureCollection\", \"features\" : [{\"type\": \"Feature\", "
"\"geometry\": {\"type\":\"Point\",\"coordinates\":[1,1]}, \"properties\": "
"{\"id\": 1, \"name\": \"one\"}}, {\"type\": \"Feature\", \"geometry\": "
"{\"type\":\"Point\",\"coordinates\":[2,2]}, \"properties\": {\"id\": 2, "
"\"name\": \"two\"}}, {\"type\": \"Feature\", \"geometry\": {\"type\":\"Point"
"\",\"coordinates\":[3,3]}, \"properties\": {\"id\": 3, \"name\": \"three"
"\"}}]}"
msgstr ""
#. Tag: para
#: reference_output.xml:622
#, no-c-format
msgid "Generate a Feature:"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:623
#, no-c-format
msgid ""
"SELECT ST_AsGeoJSON(t.*)\n"
"FROM (VALUES (1, 'one', 'POINT(1 1)'::geometry)) AS t(id, name, geom);"
msgstr ""
#. Tag: screen
#: reference_output.xml:624
#, no-c-format
msgid ""
"st_asgeojson\n"
"-----------------------------------------------------------------------------------------------------------------\n"
" {\"type\": \"Feature\", \"geometry\": {\"type\":\"Point\",\"coordinates\":"
"[1,1]}, \"properties\": {\"id\": 1, \"name\": \"one\"}}"
msgstr ""
#. Tag: para
#: reference_output.xml:626
#, no-c-format
msgid ""
"An alternate way to generate Features with an <varname>id</varname> property "
"is to use JSONB functions and operators:"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:628
#, no-c-format
msgid ""
"SELECT jsonb_build_object(\n"
" 'type', 'Feature',\n"
" 'id', id,\n"
" 'geometry', ST_AsGeoJSON(geom)::jsonb,\n"
" 'properties', to_jsonb( t.* ) - 'id' - 'geom'\n"
" ) AS json\n"
"FROM (VALUES (1, 'one', 'POINT(1 1)'::geometry)) AS t(id, name, geom);"
msgstr ""
#. Tag: screen
#: reference_output.xml:629
#, no-c-format
msgid ""
"json\n"
"-----------------------------------------------------------------------------------------------------------------\n"
" {\"id\": 1, \"type\": \"Feature\", \"geometry\": {\"type\": \"Point\", "
"\"coordinates\": [1, 1]}, \"properties\": {\"name\": \"one\"}}"
msgstr ""
#. Tag: para
#: reference_output.xml:631
#, no-c-format
msgid ""
"Don't forget to transform your data to WGS84 longitude, latitude to conform "
"with the GeoJSON specification:"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:632
#, no-c-format
msgid "SELECT ST_AsGeoJSON(ST_Transform(geom,4326)) from fe_edges limit 1;"
msgstr ""
#. Tag: screen
#: reference_output.xml:633
#, no-c-format
msgid ""
"st_asgeojson\n"
"-----------------------------------------------------------------------------------------------------------\n"
"\n"
"{\"type\":\"MultiLineString\",\"coordinates\":"
"[[[-89.734634999999997,31.492072000000000],\n"
"[-89.734955999999997,31.492237999999997]]]}"
msgstr ""
#. Tag: para
#: reference_output.xml:634
#, no-c-format
msgid "3D geometries are supported:"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:635
#, no-c-format
msgid "SELECT ST_AsGeoJSON('LINESTRING(1 2 3, 4 5 6)');"
msgstr ""
#. Tag: screen
#: reference_output.xml:636
#, no-c-format
msgid "{\"type\":\"LineString\",\"coordinates\":[[1,2,3],[4,5,6]]}"
msgstr ""
#. Tag: para
#: reference_output.xml:641
#, no-c-format
msgid ""
", <xref linkend=\"ST_ForcePolygonCCW\"/>, <xref linkend=\"ST_Transform\"/>"
msgstr ""
#. Tag: refname
#: reference_output.xml:649
#, no-c-format
msgid "ST_AsGML"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:650
#, no-c-format
msgid "Return the geometry as a GML version 2 or 3 element."
msgstr ""
#. Tag: funcsynopsis
#: reference_output.xml:654
#, no-c-format
msgid ""
"<funcprototype> <funcdef>text <function>ST_AsGML</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=15</parameter></paramdef> <paramdef choice=\"opt"
"\"><type>integer </type> <parameter>options=0</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>text <function>ST_AsGML</function></"
"funcdef> <paramdef><type>geography </type> <parameter>geog</parameter></"
"paramdef> <paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=15</parameter></paramdef> <paramdef choice=\"opt"
"\"><type>integer </type> <parameter>options=0</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>text </type> <parameter>nprefix=null</"
"parameter></paramdef> <paramdef choice=\"opt\"><type>text </type> "
"<parameter>id=null</parameter></paramdef> </funcprototype> <funcprototype> "
"<funcdef>text <function>ST_AsGML</function></funcdef> "
"<paramdef><type>integer </type> <parameter>version</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=15</parameter></paramdef> <paramdef choice=\"opt"
"\"><type>integer </type> <parameter>options=0</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>text </type> <parameter>nprefix=null</"
"parameter></paramdef> <paramdef choice=\"opt\"><type>text </type> "
"<parameter>id=null</parameter></paramdef> </funcprototype> <funcprototype> "
"<funcdef>text <function>ST_AsGML</function></funcdef> "
"<paramdef><type>integer </type> <parameter>version</parameter></paramdef> "
"<paramdef><type>geography </type> <parameter>geog</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=15</parameter></paramdef> <paramdef choice=\"opt"
"\"><type>integer </type> <parameter>options=0</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>text </type> <parameter>nprefix=null</"
"parameter></paramdef> <paramdef choice=\"opt\"><type>text </type> "
"<parameter>id=null</parameter></paramdef> </funcprototype>"
msgstr ""
#. Tag: para
#: reference_output.xml:696
#, no-c-format
msgid ""
"Return the geometry as a Geography Markup Language (GML) element. The "
"version parameter, if specified, may be either 2 or 3. If no version "
"parameter is specified then the default is assumed to be 2. The "
"<varname>maxdecimaldigits</varname> argument may be used to reduce the "
"maximum number of decimal places used in output (defaults to 15)."
msgstr ""
#. Tag: para
#: reference_output.xml:710
#, no-c-format
msgid "GML 2 refer to 2.1.2 version, GML 3 to 3.1.1 version"
msgstr ""
#. Tag: para
#: reference_output.xml:711
#, no-c-format
msgid ""
"The 'options' argument is a bitfield. It could be used to define CRS output "
"type in GML output, and to declare data as lat/lon:"
msgstr ""
#. Tag: para
#: reference_output.xml:715
#, no-c-format
msgid "0: GML Short CRS (e.g EPSG:4326), default value"
msgstr ""
#. Tag: para
#: reference_output.xml:719
#, no-c-format
msgid "1: GML Long CRS (e.g urn:ogc:def:crs:EPSG::4326)"
msgstr ""
#. Tag: para
#: reference_output.xml:723
#, no-c-format
msgid "2: For GML 3 only, remove srsDimension attribute from output."
msgstr ""
#. Tag: para
#: reference_output.xml:727
#, no-c-format
msgid ""
"4: For GML 3 only, use <LineString> rather than <Curve> tag for "
"lines."
msgstr ""
#. Tag: para
#: reference_output.xml:731
#, no-c-format
msgid ""
"16: Declare that datas are lat/lon (e.g srid=4326). Default is to assume "
"that data are planars. This option is useful for GML 3.1.1 output only, "
"related to axis order. So if you set it, it will swap the coordinates so "
"order is lat lon instead of database lon lat."
msgstr ""
#. Tag: para
#: reference_output.xml:737
#, no-c-format
msgid "32: Output the box of the geometry (envelope)."
msgstr ""
#. Tag: para
#: reference_output.xml:742
#, no-c-format
msgid ""
"The 'namespace prefix' argument may be used to specify a custom namespace "
"prefix or no prefix (if empty). If null or omitted 'gml' prefix is used"
msgstr ""
#. Tag: para
#: reference_output.xml:746
#, no-c-format
msgid "Availability: 1.3.2"
msgstr ""
#. Tag: para
#: reference_output.xml:748
#, no-c-format
msgid ""
"Enhanced: 2.0.0 prefix support was introduced. Option 4 for GML3 was "
"introduced to allow using LineString instead of Curve tag for lines. GML3 "
"Support for Polyhedral surfaces and TINS was introduced. Option 32 was "
"introduced to output the box."
msgstr ""
#. Tag: para
#: reference_output.xml:749
#, no-c-format
msgid "Changed: 2.0.0 use default named args"
msgstr ""
#. Tag: para
#: reference_output.xml:750
#, no-c-format
msgid "Enhanced: 2.1.0 id support was introduced, for GML 3."
msgstr ""
#. Tag: para
#: reference_output.xml:752
#, no-c-format
msgid "Only version 3+ of ST_AsGML supports Polyhedral Surfaces and TINS."
msgstr ""
#. Tag: title
#: reference_output.xml:759
#, no-c-format
msgid "Examples: Version 2"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:760
#, no-c-format
msgid ""
"<![CDATA[SELECT ST_AsGML(ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 "
"0))',4326));\n"
" st_asgml\n"
" --------\n"
" <gml:Polygon srsName=\"EPSG:4326\"><gml:outerBoundaryIs><gml:"
"LinearRing><gml:coordinates>0,0 0,1 1,1 1,0 0,0</gml:coordinates></gml:"
"LinearRing></gml:outerBoundaryIs></gml:Polygon>]]>"
msgstr ""
#. Tag: title
#: reference_output.xml:763
#, no-c-format
msgid "Examples: Version 3"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:764
#, no-c-format
msgid ""
"-- Flip coordinates and output extended EPSG (16 | 1)--\n"
"<![CDATA[SELECT ST_AsGML(3, ST_GeomFromText('POINT(5.234234233242 "
"6.34534534534)',4326), 5, 17);\n"
" st_asgml\n"
" --------\n"
" <gml:Point srsName=\"urn:ogc:def:crs:EPSG::4326\"><gml:"
"pos>6.34535 5.23423</gml:pos></gml:Point>]]>"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:765
#, no-c-format
msgid ""
"-- Output the envelope (32) --\n"
"<![CDATA[SELECT ST_AsGML(3, ST_GeomFromText('LINESTRING(1 2, 3 4, 10 "
"20)',4326), 5, 32);\n"
" st_asgml\n"
" --------\n"
" <gml:Envelope srsName=\"EPSG:4326\">\n"
" <gml:lowerCorner>1 2</gml:lowerCorner>\n"
" <gml:upperCorner>10 20</gml:upperCorner>\n"
" </gml:Envelope>]]>"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:767
#, no-c-format
msgid ""
"-- Output the envelope (32) , reverse (lat lon instead of lon lat) (16), "
"long srs (1)= 32 | 16 | 1 = 49 --\n"
"<![CDATA[SELECT ST_AsGML(3, ST_GeomFromText('LINESTRING(1 2, 3 4, 10 "
"20)',4326), 5, 49);\n"
" st_asgml\n"
" --------\n"
"<gml:Envelope srsName=\"urn:ogc:def:crs:EPSG::4326\">\n"
" <gml:lowerCorner>2 1</gml:lowerCorner>\n"
" <gml:upperCorner>20 10</gml:upperCorner>\n"
"</gml:Envelope>]]>"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:769
#, no-c-format
msgid ""
"-- Polyhedral Example --\n"
"SELECT ST_AsGML(3, ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 0, 0 0 1, 0 1 "
"1, 0 1 0, 0 0 0)),\n"
"((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0 "
"0)),\n"
"((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),\n"
"((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)), ((0 0 1, 1 0 1, 1 1 1, 0 1 1, 0 0 "
"1)) )'));\n"
" st_asgml\n"
" --------\n"
"<![CDATA[ <gml:PolyhedralSurface>\n"
"<gml:polygonPatches>\n"
" <gml:PolygonPatch>\n"
" <gml:exterior>\n"
" <gml:LinearRing>\n"
" <gml:posList srsDimension=\"3\">0 0 0 0 0 "
"1 0 1 1 0 1 0 0 0 0</gml:posList>\n"
" </gml:LinearRing>\n"
" </gml:exterior>\n"
" </gml:PolygonPatch>\n"
" <gml:PolygonPatch>\n"
" <gml:exterior>\n"
" <gml:LinearRing>\n"
" <gml:posList srsDimension=\"3\">0 0 0 0 1 "
"0 1 1 0 1 0 0 0 0 0</gml:posList>\n"
" </gml:LinearRing>\n"
" </gml:exterior>\n"
" </gml:PolygonPatch>\n"
" <gml:PolygonPatch>\n"
" <gml:exterior>\n"
" <gml:LinearRing>\n"
" <gml:posList srsDimension=\"3\">0 0 0 1 0 "
"0 1 0 1 0 0 1 0 0 0</gml:posList>\n"
" </gml:LinearRing>\n"
" </gml:exterior>\n"
" </gml:PolygonPatch>\n"
" <gml:PolygonPatch>\n"
" <gml:exterior>\n"
" <gml:LinearRing>\n"
" <gml:posList srsDimension=\"3\">1 1 0 1 1 "
"1 1 0 1 1 0 0 1 1 0</gml:posList>\n"
" </gml:LinearRing>\n"
" </gml:exterior>\n"
" </gml:PolygonPatch>\n"
" <gml:PolygonPatch>\n"
" <gml:exterior>\n"
" <gml:LinearRing>\n"
" <gml:posList srsDimension=\"3\">0 1 0 0 1 "
"1 1 1 1 1 1 0 0 1 0</gml:posList>\n"
" </gml:LinearRing>\n"
" </gml:exterior>\n"
" </gml:PolygonPatch>\n"
" <gml:PolygonPatch>\n"
" <gml:exterior>\n"
" <gml:LinearRing>\n"
" <gml:posList srsDimension=\"3\">0 0 1 1 0 "
"1 1 1 1 0 1 1 0 0 1</gml:posList>\n"
" </gml:LinearRing>\n"
" </gml:exterior>\n"
" </gml:PolygonPatch>\n"
"</gml:polygonPatches>\n"
"</gml:PolyhedralSurface>]]>"
msgstr ""
#. Tag: refname
#: reference_output.xml:782
#, no-c-format
msgid "ST_AsKML"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:784
#, no-c-format
msgid ""
"Return the geometry as a KML element. Several variants. Default version=2, "
"default maxdecimaldigits=15"
msgstr ""
#. Tag: funcsynopsis
#: reference_output.xml:788
#, no-c-format
msgid ""
"<funcprototype> <funcdef>text <function>ST_AsKML</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=15</parameter></paramdef> <paramdef choice=\"opt"
"\"><type>text </type> <parameter>nprefix=NULL</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>text <function>ST_AsKML</function></"
"funcdef> <paramdef><type>geography </type> <parameter>geog</parameter></"
"paramdef> <paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=15</parameter></paramdef> <paramdef choice=\"opt"
"\"><type>text </type> <parameter>nprefix=NULL</parameter></paramdef> </"
"funcprototype>"
msgstr ""
#. Tag: para
#: reference_output.xml:810
#, no-c-format
msgid ""
"Return the geometry as a Keyhole Markup Language (KML) element. There are "
"several variants of this function. maximum number of decimal places used in "
"output (defaults to 15), version default to 2 and default namespace is no "
"prefix."
msgstr ""
#. Tag: para
#: reference_output.xml:822
#, no-c-format
msgid ""
"Version 1: ST_AsKML(geom_or_geog, maxdecimaldigits) / version=2 / "
"maxdecimaldigits=15"
msgstr ""
#. Tag: para
#: reference_output.xml:823
#, no-c-format
msgid ""
"Version 2: ST_AsKML(version, geom_or_geog, maxdecimaldigits, nprefix) "
"maxdecimaldigits=15 / nprefix=NULL"
msgstr ""
#. Tag: para
#: reference_output.xml:826
#, no-c-format
msgid ""
"Requires PostGIS be compiled with Proj support. Use <xref linkend="
"\"PostGIS_Full_Version\"/> to confirm you have proj support compiled in."
msgstr ""
#. Tag: para
#: reference_output.xml:830
#, no-c-format
msgid ""
"Availability: 1.2.2 - later variants that include version param came in 1.3.2"
msgstr ""
#. Tag: para
#: reference_output.xml:833
#, no-c-format
msgid "Enhanced: 2.0.0 - Add prefix namespace. Default is no prefix"
msgstr ""
#. Tag: para
#: reference_output.xml:836
#, no-c-format
msgid "Changed: 2.0.0 - uses default args and supports named args"
msgstr ""
#. Tag: para
#: reference_output.xml:840
#, no-c-format
msgid "AsKML output will not work with geometries that do not have an SRID"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:848
#, no-c-format
msgid ""
"<![CDATA[SELECT ST_AsKML(ST_GeomFromText('POLYGON((0 0,0 1,1 1,1 0,0 "
"0))',4326));\n"
"\n"
" st_askml\n"
" --------\n"
" <Polygon><outerBoundaryIs><LinearRing><coordinates>0,0 0,1 "
"1,1 1,0 0,0</coordinates></LinearRing></outerBoundaryIs></Polygon>\n"
"\n"
" --3d linestring\n"
" SELECT ST_AsKML('SRID=4326;LINESTRING(1 2 3, 4 5 6)');\n"
" <LineString><coordinates>1,2,3 4,5,6</coordinates></"
"LineString>\n"
" ]]>"
msgstr ""
#. Tag: para
#: reference_output.xml:853
#, no-c-format
msgid ", <xref linkend=\"ST_AsGML\"/>"
msgstr ""
#. Tag: refname
#: reference_output.xml:859
#, no-c-format
msgid "ST_AsLatLonText"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:860
#, no-c-format
msgid "Return the Degrees, Minutes, Seconds representation of the given point."
msgstr ""
#. Tag: funcprototype
#: reference_output.xml:865
#, no-c-format
msgid ""
"<funcdef>text <function>ST_AsLatLonText</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>pt</parameter></paramdef> "
"<paramdef><type>text </type> <parameter>format=''</parameter></paramdef>"
msgstr ""
#. Tag: para
#: reference_output.xml:876
#, no-c-format
msgid "Returns the Degrees, Minutes, Seconds representation of the point."
msgstr ""
#. Tag: para
#: reference_output.xml:879
#, no-c-format
msgid ""
"It is assumed the point is in a lat/lon projection. The X (lon) and Y (lat) "
"coordinates are normalized in the output to the \"normal\" range (-180 to "
"+180 for lon, -90 to +90 for lat)."
msgstr ""
#. Tag: para
#: reference_output.xml:882
#, no-c-format
msgid ""
"The text parameter is a format string containing the format for the "
"resulting text, similar to a date format string. Valid tokens are \"D\" for "
"degrees, \"M\" for minutes, \"S\" for seconds, and \"C\" for cardinal "
"direction (NSEW). DMS tokens may be repeated to indicate desired width and "
"precision (\"SSS.SSSS\" means \" 1.0023\")."
msgstr ""
#. Tag: para
#: reference_output.xml:887
#, no-c-format
msgid ""
"\"M\", \"S\", and \"C\" are optional. If \"C\" is omitted, degrees are shown "
"with a \"-\" sign if south or west. If \"S\" is omitted, minutes will be "
"shown as decimal with as many digits of precision as you specify. If \"M\" "
"is also omitted, degrees are shown as decimal with as many digits precision "
"as you specify."
msgstr ""
#. Tag: para
#: reference_output.xml:892
#, no-c-format
msgid ""
"If the format string is omitted (or zero-length) a default format will be "
"used."
msgstr ""
#. Tag: para
#: reference_output.xml:898
#, no-c-format
msgid "Availability: 2.0"
msgstr ""
#. Tag: para
#: reference_output.xml:904
#, no-c-format
msgid "Default format."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:905
#, no-c-format
msgid ""
"SELECT (ST_AsLatLonText('POINT (-3.2342342 -2.32498)'));\n"
" st_aslatlontext\n"
"----------------------------\n"
" 2°19'29.928\"S 3°14'3.243\"W"
msgstr ""
#. Tag: para
#: reference_output.xml:906
#, no-c-format
msgid "Providing a format (same as the default)."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:907
#, no-c-format
msgid ""
"SELECT (ST_AsLatLonText('POINT (-3.2342342 -2.32498)', 'D°M''S.SSS\"C'));\n"
" st_aslatlontext\n"
"----------------------------\n"
" 2°19'29.928\"S 3°14'3.243\"W"
msgstr ""
#. Tag: para
#: reference_output.xml:908
#, no-c-format
msgid "Characters other than D, M, S, C and . are just passed through."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:909
#, no-c-format
msgid ""
"SELECT (ST_AsLatLonText('POINT (-3.2342342 -2.32498)', 'D degrees, M "
"minutes, S seconds to the C'));\n"
" st_aslatlontext\n"
"--------------------------------------------------------------------------------------\n"
" 2 degrees, 19 minutes, 30 seconds to the S 3 degrees, 14 minutes, 3 seconds "
"to the W"
msgstr ""
#. Tag: para
#: reference_output.xml:910
#, no-c-format
msgid "Signed degrees instead of cardinal directions."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:911
#, no-c-format
msgid ""
"SELECT (ST_AsLatLonText('POINT (-3.2342342 -2.32498)', 'D°M''S.SSS\"'));\n"
" st_aslatlontext\n"
"----------------------------\n"
" -2°19'29.928\" -3°14'3.243\""
msgstr ""
#. Tag: para
#: reference_output.xml:912
#, no-c-format
msgid "Decimal degrees."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:913
#, no-c-format
msgid ""
"SELECT (ST_AsLatLonText('POINT (-3.2342342 -2.32498)', 'D.DDDD degrees "
"C'));\n"
" st_aslatlontext\n"
"-----------------------------------\n"
" 2.3250 degrees S 3.2342 degrees W"
msgstr ""
#. Tag: para
#: reference_output.xml:914
#, no-c-format
msgid "Excessively large values are normalized."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:915
#, no-c-format
msgid ""
"SELECT (ST_AsLatLonText('POINT (-302.2342342 -792.32498)'));\n"
" st_aslatlontext\n"
"-------------------------------\n"
" 72°19'29.928\"S 57°45'56.757\"E"
msgstr ""
#. Tag: refname
#: reference_output.xml:924
#, no-c-format
msgid "ST_AsMVTGeom"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:926
#, no-c-format
msgid ""
"Transform a geometry into the coordinate space of a <ulink url=\"https://www."
"mapbox.com/vector-tiles/\">Mapbox Vector Tile</ulink>."
msgstr ""
#. Tag: funcprototype
#: reference_output.xml:930
#, no-c-format
msgid ""
"<funcdef>geometry <function>ST_AsMVTGeom</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> "
"<paramdef><type>box2d </type> <parameter>bounds</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>integer </type> <parameter>extent=4096</"
"parameter></paramdef> <paramdef choice=\"opt\"><type>integer </type> "
"<parameter>buffer=256</parameter></paramdef> <paramdef choice=\"opt"
"\"><type>boolean </type> <parameter>clip_geom=true</parameter></paramdef>"
msgstr ""
#. Tag: para
#: reference_output.xml:944
#, no-c-format
msgid ""
"Transform a geometry into the coordinate space of a <ulink url=\"https://www."
"mapbox.com/vector-tiles/\">Mapbox Vector Tile</ulink> of a set of rows "
"corresponding to a Layer. Makes best effort to keep and even correct "
"validity and might collapse geometry into a lower dimension in the process."
msgstr ""
#. Tag: para
#: reference_output.xml:948
#, no-c-format
msgid "<varname>geom</varname> is the geometry to transform."
msgstr ""
#. Tag: para
#: reference_output.xml:949
#, no-c-format
msgid ""
"<varname>bounds</varname> is the geometric bounds of the tile contents "
"without buffer."
msgstr ""
#. Tag: para
#: reference_output.xml:950
#, no-c-format
msgid ""
"<varname>extent</varname> is the tile extent in tile coordinate space as "
"defined by the <ulink url=\"https://www.mapbox.com/vector-tiles/"
"specification/\">specification</ulink>. If NULL it will default to 4096."
msgstr ""
#. Tag: para
#: reference_output.xml:951
#, no-c-format
msgid ""
"<varname>buffer</varname> is the buffer distance in tile coordinate space to "
"optionally clip geometries. If NULL it will default to 256."
msgstr ""
#. Tag: para
#: reference_output.xml:952
#, no-c-format
msgid ""
"<varname>clip_geom</varname> is a boolean to control if geometries should be "
"clipped or encoded as is. If NULL it will default to true."
msgstr ""
#. Tag: para
#: reference_output.xml:957
#, no-c-format
msgid ""
"From 3.0, Wagyu can be chosen at configure time to clip and validate MVT "
"polygons. This library is faster and produces more correct results than the "
"GEOS default, but it might drop small polygons."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:963
#, no-c-format
msgid ""
"<![CDATA[SELECT ST_AsText(ST_AsMVTGeom(\n"
" ST_GeomFromText('POLYGON ((0 0, 10 0, 10 5, 0 -5, 0 0))'),\n"
" ST_MakeBox2D(ST_Point(0, 0), ST_Point(4096, 4096)),\n"
" 4096, 0, false));\n"
" st_astext\n"
"--------------------------------------------------------------------\n"
" MULTIPOLYGON(((5 4096,10 4091,10 4096,5 4096)),((5 4096,0 4101,0 4096,5 "
"4096)))\n"
"\n"
" ]]>"
msgstr ""
#. Tag: para
#: reference_output.xml:968
#, no-c-format
msgid ""
", <xref linkend=\"ST_TileEnvelope\"/>, <xref linkend=\"PostGIS_Wagyu_Version"
"\"/>"
msgstr ""
#. Tag: refname
#: reference_output.xml:978
#, no-c-format
msgid "ST_AsMVT"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:980
#, no-c-format
msgid ""
"Aggregate function returning a Mapbox Vector Tile representation of a set of "
"rows."
msgstr ""
#. Tag: funcsynopsis
#: reference_output.xml:983
#, no-c-format
msgid ""
"<funcprototype> <funcdef>bytea <function>ST_AsMVT</function></funcdef> "
"<paramdef><type>anyelement set </type> <parameter>row</parameter></paramdef> "
"</funcprototype> <funcprototype> <funcdef>bytea <function>ST_AsMVT</"
"function></funcdef> <paramdef><type>anyelement </type> <parameter>row</"
"parameter></paramdef> <paramdef><type>text </type> <parameter>name</"
"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>bytea "
"<function>ST_AsMVT</function></funcdef> <paramdef><type>anyelement </type> "
"<parameter>row</parameter></paramdef> <paramdef><type>text </type> "
"<parameter>name</parameter></paramdef> <paramdef><type>integer </type> "
"<parameter>extent</parameter></paramdef> </funcprototype> <funcprototype> "
"<funcdef>bytea <function>ST_AsMVT</function></funcdef> "
"<paramdef><type>anyelement </type> <parameter>row</parameter></paramdef> "
"<paramdef><type>text </type> <parameter>name</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>extent</parameter></paramdef> "
"<paramdef><type>text </type> <parameter>geom_name</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>bytea <function>ST_AsMVT</function></"
"funcdef> <paramdef><type>anyelement </type> <parameter>row</parameter></"
"paramdef> <paramdef><type>text </type> <parameter>name</parameter></"
"paramdef> <paramdef><type>integer </type> <parameter>extent</parameter></"
"paramdef> <paramdef><type>text </type> <parameter>geom_name</parameter></"
"paramdef> <paramdef><type>text </type> <parameter>feature_id_name</"
"parameter></paramdef> </funcprototype>"
msgstr ""
#. Tag: para
#: reference_output.xml:1020
#, no-c-format
msgid ""
"An aggregate function which returns a binary <ulink url=\"https://www.mapbox."
"com/vector-tiles/\">Mapbox Vector Tile</ulink> representation of a set of "
"rows corresponding to a tile layer. The rows should contain a geometry "
"column which will be encoded as a feature geometry. The geometry should be "
"in tile coordinate space and valid as per the <ulink url=\"https://www."
"mapbox.com/vector-tiles/specification/\">MVT specification</ulink>. <xref "
"linkend=\"ST_AsMVTGeom\"/> can be used to transform geometry into tile "
"coordinate space. Other row columns are encoded as feature attributes."
msgstr ""
#. Tag: para
#: reference_output.xml:1029
#, no-c-format
msgid ""
"The <ulink url=\"https://www.mapbox.com/vector-tiles/\">Mapbox Vector Tile</"
"ulink> format can store features with varying sets of attributes. To use "
"this capability supply a JSONB column in the row data containing Json "
"objects one level deep. The keys and values in the JSONB values will be "
"encoded as feature attributes."
msgstr ""
#. Tag: para
#: reference_output.xml:1035
#, no-c-format
msgid ""
"Tiles with multiple layers can be created by concatenating multiple calls to "
"this function using <varname>||</varname>."
msgstr ""
#. Tag: para
#: reference_output.xml:1041
#, no-c-format
msgid ""
"Do not call with a <varname>GEOMETRYCOLLECTION</varname> as an element in "
"the row. However you can use <xref linkend=\"ST_AsMVTGeom\"/> to prepare a "
"geometry collection for inclusion."
msgstr ""
#. Tag: para
#: reference_output.xml:1046
#, no-c-format
msgid ""
"<varname>name</varname> is the name of the layer. Default is the string "
"\"default\"."
msgstr ""
#. Tag: para
#: reference_output.xml:1047
#, no-c-format
msgid ""
"<varname>extent</varname> is the tile extent in screen space as defined by "
"the specification. Default is 4096."
msgstr ""
#. Tag: para
#: reference_output.xml:1048
#, no-c-format
msgid ""
"<varname>geom_name</varname> is the name of the geometry column in the row "
"data. Default is the first geometry column."
msgstr ""
#. Tag: para
#: reference_output.xml:1049
#, no-c-format
msgid ""
"<varname>feature_id_name</varname> is the name of the Feature ID column in "
"the row data. If NULL or negative the Feature ID is not set. The first "
"column matching name and valid type (smallint, integer, bigint) will be used "
"as Feature ID, and any subsequent column will be added as a property. JSON "
"properties are not supported."
msgstr ""
#. Tag: para
#: reference_output.xml:1052
#, no-c-format
msgid "Enhanced: 3.0 - added support for Feature ID."
msgstr ""
#. Tag: para
#: reference_output.xml:1053
#, no-c-format
msgid "Enhanced: 2.5.0 - added support parallel query."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:1059
#, no-c-format
msgid ""
"<![CDATA[WITH mvtgeom AS\n"
"(\n"
" SELECT ST_AsMVTGeom(geom, ST_TileEnvelope(12, 513, 412), extent => 4096, "
"buffer => 64) AS geom, name, description\n"
" FROM points_of_interest\n"
" WHERE geom && ST_TileEnvelope(12, 513, 412, margin => (64.0 / 4096))\n"
")\n"
"SELECT ST_AsMVT(mvtgeom.*)\n"
"FROM mvtgeom;\n"
"]]>"
msgstr ""
#. Tag: para
#: reference_output.xml:1065
#, no-c-format
msgid ", <xref linkend=\"ST_TileEnvelope\"/>"
msgstr ""
#. Tag: refname
#: reference_output.xml:1073
#, no-c-format
msgid "ST_AsSVG"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:1075
#, no-c-format
msgid "Returns SVG path data for a geometry."
msgstr ""
#. Tag: funcsynopsis
#: reference_output.xml:1079
#, no-c-format
msgid ""
"<funcprototype> <funcdef>text <function>ST_AsSVG</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>integer </type> <parameter>rel=0</parameter></"
"paramdef> <paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=15</parameter></paramdef> </funcprototype> "
"<funcprototype> <funcdef>text <function>ST_AsSVG</function></funcdef> "
"<paramdef><type>geography </type> <parameter>geog</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>integer </type> <parameter>rel=0</parameter></"
"paramdef> <paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=15</parameter></paramdef> </funcprototype>"
msgstr ""
#. Tag: para
#: reference_output.xml:1098
#, no-c-format
msgid ""
"Return the geometry as Scalar Vector Graphics (SVG) path data. Use 1 as "
"second argument to have the path data implemented in terms of relative "
"moves, the default (or 0) uses absolute moves. Third argument may be used to "
"reduce the maximum number of decimal digits used in output (defaults to 15). "
"Point geometries will be rendered as cx/cy when 'rel' arg is 0, x/y when "
"'rel' is 1. Multipoint geometries are delimited by commas (\",\"), "
"GeometryCollection geometries are delimited by semicolons (\";\")."
msgstr ""
#. Tag: para
#: reference_output.xml:1108
#, no-c-format
msgid ""
"Availability: 1.2.2. Availability: 1.4.0 Changed in PostGIS 1.4.0 to include "
"L command in absolute path to conform to <ulink url=\"http://www.w3.org/TR/"
"SVG/paths.html#PathDataBNF\">http://www.w3.org/TR/SVG/paths."
"html#PathDataBNF</ulink>"
msgstr ""
#. Tag: para
#: reference_output.xml:1111
#, no-c-format
msgid "Changed: 2.0.0 to use default args and support named args"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:1116
#, no-c-format
msgid ""
"SELECT ST_AsSVG('POLYGON((0 0,0 1,1 1,1 0,0 0))');\n"
"\n"
" st_assvg\n"
" --------\n"
" M 0 0 L 0 -1 1 -1 1 0 Z"
msgstr ""
#. Tag: refname
#: reference_output.xml:1121
#, no-c-format
msgid "ST_AsTWKB"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:1122
#, no-c-format
msgid "Returns the geometry as TWKB, aka \"Tiny Well-Known Binary\""
msgstr ""
#. Tag: funcsynopsis
#: reference_output.xml:1126
#, no-c-format
msgid ""
"<funcprototype> <funcdef>bytea <function>ST_AsTWKB</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>decimaldigits_xy=0</parameter></"
"paramdef> <paramdef><type>integer </type> <parameter>decimaldigits_z=0</"
"parameter></paramdef> <paramdef><type>integer </type> "
"<parameter>decimaldigits_m=0</parameter></paramdef> <paramdef><type>boolean "
"</type> <parameter>include_sizes=false</parameter></paramdef> "
"<paramdef><type>boolean </type> <parameter>include_bounding boxes=false</"
"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>bytea "
"<function>ST_AsTWKB</function></funcdef> <paramdef><type>geometry[] </type> "
"<parameter>geometries</parameter></paramdef> <paramdef><type>bigint[] </"
"type> <parameter>unique_ids</parameter></paramdef> <paramdef><type>integer </"
"type> <parameter>decimaldigits_xy=0</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>decimaldigits_z=0</parameter></"
"paramdef> <paramdef><type>integer </type> <parameter>decimaldigits_m=0</"
"parameter></paramdef> <paramdef><type>boolean </type> "
"<parameter>include_sizes=false</parameter></paramdef> "
"<paramdef><type>boolean </type> <parameter>include_bounding_boxes=false</"
"parameter></paramdef> </funcprototype>"
msgstr ""
#. Tag: para
#: reference_output.xml:1150
#, no-c-format
msgid ""
"Returns the geometry in TWKB (Tiny Well-Known Binary) format. TWKB is a "
"<ulink url=\"https://github.com/TWKB/Specification/blob/master/twkb.md"
"\">compressed binary format</ulink> with a focus on minimizing the size of "
"the output."
msgstr ""
#. Tag: para
#: reference_output.xml:1151
#, no-c-format
msgid ""
"The decimal digits parameters control how much precision is stored in the "
"output. By default, values are rounded to the nearest unit before encoding. "
"If you want to transfer more precision, increase the number. For example, a "
"value of 1 implies that the first digit to the right of the decimal point "
"will be preserved."
msgstr ""
#. Tag: para
#: reference_output.xml:1152
#, no-c-format
msgid ""
"The sizes and bounding boxes parameters control whether optional information "
"about the encoded length of the object and the bounds of the object are "
"included in the output. By default they are not. Do not turn them on unless "
"your client software has a use for them, as they just use up space (and "
"saving space is the point of TWKB)."
msgstr ""
#. Tag: para
#: reference_output.xml:1153
#, no-c-format
msgid ""
"The array-input form of the function is used to convert a collection of "
"geometries and unique identifiers into a TWKB collection that preserves the "
"identifiers. This is useful for clients that expect to unpack a collection "
"and then access further information about the objects inside. You can create "
"the arrays using the <ulink url=\"http://www.postgresql.org/docs/9.4/static/"
"functions-aggregate.html\">array_agg</ulink> function. The other parameters "
"operate the same as for the simple form of the function."
msgstr ""
#. Tag: para
#: reference_output.xml:1155
#, no-c-format
msgid ""
"The format specification is available online at <ulink url=\"https://github."
"com/TWKB/Specification\">https://github.com/TWKB/Specification</ulink>, and "
"code for building a JavaScript client can be found at <ulink url=\"https://"
"github.com/TWKB/twkb.js\">https://github.com/TWKB/twkb.js</ulink>."
msgstr ""
#. Tag: para
#: reference_output.xml:1158
#, no-c-format
msgid "Enhanced: 2.4.0 memory and speed improvements."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:1165
#, no-c-format
msgid ""
"SELECT ST_AsTWKB('LINESTRING(1 1,5 5)'::geometry);\n"
" st_astwkb\n"
"--------------------------------------------\n"
"\\x02000202020808"
msgstr ""
#. Tag: para
#: reference_output.xml:1166
#, no-c-format
msgid ""
"To create an aggregate TWKB object including identifiers aggregate the "
"desired geometries and objects first, using \"array_agg()\", then call the "
"appropriate TWKB function."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:1168
#, no-c-format
msgid ""
"SELECT ST_AsTWKB(array_agg(geom), array_agg(gid)) FROM mytable;\n"
" st_astwkb\n"
"--------------------------------------------\n"
"\\x040402020400000202"
msgstr ""
#. Tag: para
#: reference_output.xml:1174
#, no-c-format
msgid ""
", <xref linkend=\"ST_AsBinary\"/>, <xref linkend=\"ST_AsEWKB\"/>, <xref "
"linkend=\"ST_AsEWKT\"/>, <xref linkend=\"ST_GeomFromText\"/>"
msgstr ""
#. Tag: refname
#: reference_output.xml:1180
#, no-c-format
msgid "ST_AsX3D"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:1182
#, no-c-format
msgid ""
"Returns a Geometry in X3D xml node element format: ISO-IEC-19776-1.2-"
"X3DEncodings-XML"
msgstr ""
#. Tag: funcprototype
#: reference_output.xml:1187
#, no-c-format
msgid ""
"<funcdef>text <function>ST_AsX3D</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxdecimaldigits=15</parameter></paramdef> <paramdef choice=\"opt"
"\"><type>integer </type> <parameter>options=0</parameter></paramdef>"
msgstr ""
#. Tag: para
#: reference_output.xml:1199
#, no-c-format
msgid ""
"Returns a geometry as an X3D xml formatted node element <ulink url=\"http://"
"www.web3d.org/standards/number/19776-1\">http://www.web3d.org/standards/"
"number/19776-1</ulink>. If <varname>maxdecimaldigits</varname> (precision) "
"is not specified then defaults to 15."
msgstr ""
#. Tag: para
#: reference_output.xml:1201
#, no-c-format
msgid ""
"There are various options for translating PostGIS geometries to X3D since "
"X3D geometry types don't map directly to PostGIS geometry types and some "
"newer X3D types that might be better mappings we have avoided since most "
"rendering tools don't currently support them. These are the mappings we have "
"settled on. Feel free to post a bug ticket if you have thoughts on the idea "
"or ways we can allow people to denote their preferred mappings."
msgstr ""
#. Tag: para
#: reference_output.xml:1203
#, no-c-format
msgid "Below is how we currently map PostGIS 2D/3D types to X3D types"
msgstr ""
#. Tag: para
#: reference_output.xml:1206
#, no-c-format
msgid ""
"The 'options' argument is a bitfield. For PostGIS 2.2+, this is used to "
"denote whether to represent coordinates with X3D GeoCoordinates Geospatial "
"node and also whether to flip the x/y axis. By default, <code>ST_AsX3D</"
"code> outputs in database form (long,lat or X,Y), but X3D default of lat/"
"lon, y/x may be preferred."
msgstr ""
#. Tag: para
#: reference_output.xml:1210
#, no-c-format
msgid ""
"0: X/Y in database order (e.g. long/lat = X,Y is standard database order), "
"default value, and non-spatial coordinates (just regular old Coordinate tag)."
msgstr ""
#. Tag: para
#: reference_output.xml:1214
#, no-c-format
msgid ""
"1: Flip X and Y. If used in conjunction with the GeoCoordinate option "
"switch, then output will be default \"latitude_first\" and coordinates will "
"be flipped as well."
msgstr ""
#. Tag: para
#: reference_output.xml:1218
#, no-c-format
msgid ""
"2: Output coordinates in GeoSpatial GeoCoordinates. This option will throw "
"an error if geometries are not in WGS 84 long lat (srid: 4326). This is "
"currently the only GeoCoordinate type supported. <ulink url=\"http://www."
"web3d.org/documents/specifications/19775-1/V3.2/Part01/components/geodata."
"html#Specifyingaspatialreference\">Refer to X3D specs specifying a spatial "
"reference system.</ulink>. Default output will be <code>GeoCoordinate "
"geoSystem='\"GD\" \"WE\" \"longitude_first\"'</code>. If you prefer the X3D "
"default of <code>GeoCoordinate geoSystem='\"GD\" \"WE\" \"latitude_first\"'</"
"code> use <code>(2 + 1)</code> = <code>3</code>"
msgstr ""
#. Tag: entry
#: reference_output.xml:1228
#, no-c-format
msgid "PostGIS Type"
msgstr ""
#. Tag: entry
#: reference_output.xml:1229
#, no-c-format
msgid "2D X3D Type"
msgstr ""
#. Tag: entry
#: reference_output.xml:1230
#, no-c-format
msgid "3D X3D Type"
msgstr ""
#. Tag: entry
#: reference_output.xml:1235
#, no-c-format
msgid "LINESTRING"
msgstr ""
#. Tag: entry
#: reference_output.xml:1236 reference_output.xml:1241
#, no-c-format
msgid "not yet implemented - will be PolyLine2D"
msgstr ""
#. Tag: entry
#: reference_output.xml:1237
#, no-c-format
msgid "LineSet"
msgstr ""
#. Tag: entry
#: reference_output.xml:1240
#, no-c-format
msgid "MULTILINESTRING"
msgstr ""
#. Tag: entry
#: reference_output.xml:1242
#, no-c-format
msgid "IndexedLineSet"
msgstr ""
#. Tag: entry
#: reference_output.xml:1245
#, no-c-format
msgid "MULTIPOINT"
msgstr ""
#. Tag: entry
#: reference_output.xml:1246
#, no-c-format
msgid "Polypoint2D"
msgstr ""
#. Tag: entry
#: reference_output.xml:1247
#, no-c-format
msgid "PointSet"
msgstr ""
#. Tag: entry
#: reference_output.xml:1250
#, no-c-format
msgid "POINT"
msgstr ""
#. Tag: entry
#: reference_output.xml:1251 reference_output.xml:1252
#, no-c-format
msgid "outputs the space delimited coordinates"
msgstr ""
#. Tag: entry
#: reference_output.xml:1255
#, no-c-format
msgid "(MULTI) POLYGON, POLYHEDRALSURFACE"
msgstr ""
#. Tag: entry
#: reference_output.xml:1256
#, no-c-format
msgid "Invalid X3D markup"
msgstr ""
#. Tag: entry
#: reference_output.xml:1257
#, no-c-format
msgid "IndexedFaceSet (inner rings currently output as another faceset)"
msgstr ""
#. Tag: entry
#: reference_output.xml:1260
#, no-c-format
msgid "<entry>TIN</entry>"
msgstr ""
#. Tag: entry
#: reference_output.xml:1261
#, no-c-format
msgid "TriangleSet2D (Not Yet Implemented)"
msgstr ""
#. Tag: entry
#: reference_output.xml:1262
#, no-c-format
msgid "IndexedTriangleSet"
msgstr ""
#. Tag: para
#: reference_output.xml:1267
#, no-c-format
msgid ""
"2D geometry support not yet complete. Inner rings currently just drawn as "
"separate polygons. We are working on these."
msgstr ""
#. Tag: para
#: reference_output.xml:1268
#, no-c-format
msgid ""
"Lots of advancements happening in 3D space particularly with <ulink url="
"\"https://www.web3d.org/wiki/index.php/X3D_and_HTML5\">X3D Integration with "
"HTML5</ulink>"
msgstr ""
#. Tag: para
#: reference_output.xml:1269
#, no-c-format
msgid ""
"There is also a nice open source X3D viewer you can use to view rendered "
"geometries. Free Wrl <ulink url=\"http://freewrl.sourceforge.net/\">http://"
"freewrl.sourceforge.net/</ulink> binaries available for Mac, Linux, and "
"Windows. Use the FreeWRL_Launcher packaged to view the geometries."
msgstr ""
#. Tag: para
#: reference_output.xml:1270
#, no-c-format
msgid ""
"Also check out <ulink url=\"https://github.com/robe2/postgis_x3d_viewer"
"\">PostGIS minimalist X3D viewer</ulink> that utilizes this function and "
"<ulink url=\"http://www.x3dom.org/\">x3dDom html/js open source toolkit</"
"ulink>."
msgstr ""
#. Tag: para
#: reference_output.xml:1271
#, no-c-format
msgid "Availability: 2.0.0: ISO-IEC-19776-1.2-X3DEncodings-XML"
msgstr ""
#. Tag: para
#: reference_output.xml:1272
#, no-c-format
msgid ""
"Enhanced: 2.2.0: Support for GeoCoordinates and axis (x/y, long/lat) "
"flipping. Look at options for details."
msgstr ""
#. Tag: title
#: reference_output.xml:1284
#, no-c-format
msgid ""
"Example: Create a fully functional X3D document - This will generate a cube "
"that is viewable in FreeWrl and other X3D viewers."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:1285
#, no-c-format
msgid ""
"<![CDATA[SELECT '<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n"
"<!DOCTYPE X3D PUBLIC \"ISO//Web3D//DTD X3D 3.0//EN\" \"http://www.web3d.org/"
"specifications/x3d-3.0.dtd\">\n"
"<X3D>\n"
" <Scene>\n"
" <Transform>\n"
" <Shape>\n"
" <Appearance>\n"
" <Material emissiveColor=''0 0 1''/>\n"
" </Appearance> ' ||\n"
" ST_AsX3D( ST_GeomFromEWKT('POLYHEDRALSURFACE( ((0 0 0, 0 0 1, 0 1 1, "
"0 1 0, 0 0 0)),\n"
"((0 0 0, 0 1 0, 1 1 0, 1 0 0, 0 0 0)), ((0 0 0, 1 0 0, 1 0 1, 0 0 1, 0 0 "
"0)),\n"
"((1 1 0, 1 1 1, 1 0 1, 1 0 0, 1 1 0)),\n"
"((0 1 0, 0 1 1, 1 1 1, 1 1 0, 0 1 0)), ((0 0 1, 1 0 1, 1 1 1, 0 1 1, 0 0 "
"1)) )')) ||\n"
" '</Shape>\n"
" </Transform>\n"
" </Scene>\n"
"</X3D>' As x3ddoc;]]>\n"
"\n"
" x3ddoc\n"
" --------\n"
"<![CDATA[<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n"
"<!DOCTYPE X3D PUBLIC \"ISO//Web3D//DTD X3D 3.0//EN\" \"http://www.web3d.org/"
"specifications/x3d-3.0.dtd\">\n"
"<X3D>\n"
" <Scene>\n"
" <Transform>\n"
" <Shape>\n"
" <Appearance>\n"
" <Material emissiveColor='0 0 1'/>\n"
" </Appearance>\n"
" <IndexedFaceSet coordIndex='0 1 2 3 -1 4 5 6 7 -1 8 9 10 11 -1 12 13 "
"14 15 -1 16 17 18 19 -1 20 21 22 23'>\n"
" <Coordinate point='0 0 0 0 0 1 0 1 1 0 1 0 0 0 0 0 1 0 1 1 0 1 0 "
"0 0 0 0 1 0 0 1 0 1 0 0 1 1 1 0 1 1 1 1 0 1 1 0 0 0 1 0 0 1 1 1 1 1 1 1 0 0 "
"0 1 1 0 1 1 1 1 0 1 1' />\n"
" </IndexedFaceSet>\n"
" </Shape>\n"
" </Transform>\n"
" </Scene>\n"
"</X3D>]]>"
msgstr ""
#. Tag: title
#: reference_output.xml:1288
#, no-c-format
msgid "Example: An Octagon elevated 3 Units and decimal precision of 6"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:1289
#, no-c-format
msgid ""
"SELECT ST_AsX3D(\n"
"ST_Translate(\n"
" ST_Force_3d(\n"
" ST_Buffer(ST_Point(10,10),5, 'quad_segs=2')), 0,0,\n"
" 3)\n"
" ,6) As x3dfrag;\n"
"\n"
"x3dfrag\n"
"--------\n"
"<![CDATA[<IndexedFaceSet coordIndex=\"0 1 2 3 4 5 6 7\">\n"
" <Coordinate point=\"15 10 3 13.535534 6.464466 3 10 5 3 6.464466 "
"6.464466 3 5 10 3 6.464466 13.535534 3 10 15 3 13.535534 13.535534 3 \" />\n"
"</IndexedFaceSet>]]>"
msgstr ""
#. Tag: title
#: reference_output.xml:1292
#, no-c-format
msgid "Example: TIN"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:1293
#, no-c-format
msgid ""
"<![CDATA[SELECT ST_AsX3D(ST_GeomFromEWKT('TIN (((\n"
" 0 0 0,\n"
" 0 0 1,\n"
" 0 1 0,\n"
" 0 0 0\n"
" )), ((\n"
" 0 0 0,\n"
" 0 1 0,\n"
" 1 1 0,\n"
" 0 0 0\n"
" ))\n"
" )')) As x3dfrag;]]>\n"
"\n"
" x3dfrag\n"
" --------\n"
"<![CDATA[<IndexedTriangleSet index='0 1 2 3 4 5'><Coordinate point='0 0 0 0 "
"0 1 0 1 0 0 0 0 0 1 0 1 1 0'/></IndexedTriangleSet>]]>"
msgstr ""
#. Tag: title
#: reference_output.xml:1296
#, no-c-format
msgid "Example: Closed multilinestring (the boundary of a polygon with holes)"
msgstr ""
#. Tag: programlisting
#: reference_output.xml:1297
#, no-c-format
msgid ""
"<![CDATA[SELECT ST_AsX3D(\n"
" ST_GeomFromEWKT('MULTILINESTRING((20 0 10,16 -12 10,0 "
"-16 10,-12 -12 10,-20 0 10,-12 16 10,0 24 10,16 16 10,20 0 10),\n"
" (12 0 10,8 8 10,0 12 10,-8 8 10,-8 0 10,-8 -4 10,0 -8 10,8 -4 10,12 0 "
"10))')\n"
") As x3dfrag;]]>\n"
"\n"
" x3dfrag\n"
" --------\n"
"<![CDATA[<IndexedLineSet coordIndex='0 1 2 3 4 5 6 7 0 -1 8 9 10 11 12 13 "
"14 15 8'>\n"
" <Coordinate point='20 0 10 16 -12 10 0 -16 10 -12 -12 10 -20 0 10 -12 16 "
"10 0 24 10 16 16 10 12 0 10 8 8 10 0 12 10 -8 8 10 -8 0 10 -8 -4 10 0 -8 10 "
"8 -4 10 ' />\n"
" </IndexedLineSet>]]>"
msgstr ""
#. Tag: refname
#: reference_output.xml:1303
#, no-c-format
msgid "ST_GeoHash"
msgstr ""
#. Tag: refpurpose
#: reference_output.xml:1305
#, no-c-format
msgid "Return a GeoHash representation of the geometry."
msgstr ""
#. Tag: funcprototype
#: reference_output.xml:1310
#, no-c-format
msgid ""
"<funcdef>text <function>ST_GeoHash</function></funcdef> "
"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>integer </type> "
"<parameter>maxchars=full_precision_of_point</parameter></paramdef>"
msgstr ""
#. Tag: para
#: reference_output.xml:1321
#, no-c-format
msgid ""
"Return a GeoHash representation (<ulink url=\"http://en.wikipedia.org/wiki/"
"Geohash\">http://en.wikipedia.org/wiki/Geohash</ulink>) of the geometry. A "
"GeoHash encodes a point into a text form that is sortable and searchable "
"based on prefixing. A shorter GeoHash is a less precise representation of a "
"point. It can also be thought of as a box, that contains the actual point."
msgstr ""
#. Tag: para
#: reference_output.xml:1323
#, no-c-format
msgid ""
"If no <varname>maxchars</varname> is specified ST_GeoHash returns a GeoHash "
"based on full precision of the input geometry type. Points return a GeoHash "
"with 20 characters of precision (about enough to hold the full double "
"precision of the input). Other types return a GeoHash with a variable amount "
"of precision, based on the size of the feature. Larger features are "
"represented with less precision, smaller features with more precision. The "
"idea is that the box implied by the GeoHash will always contain the input "
"feature."
msgstr ""
#. Tag: para
#: reference_output.xml:1325
#, no-c-format
msgid ""
"If <varname>maxchars</varname> is specified ST_GeoHash returns a GeoHash "
"with at most that many characters so a possibly lower precision "
"representation of the input geometry. For non-points, the starting point of "
"the calculation is the center of the bounding box of the geometry."
msgstr ""
#. Tag: para
#: reference_output.xml:1327
#, no-c-format
msgid "Availability: 1.4.0"
msgstr ""
#. Tag: para
#: reference_output.xml:1330
#, no-c-format
msgid ""
"ST_GeoHash will not work with geometries that are not in geographic (lon/"
"lat) coordinates."
msgstr ""
#. Tag: programlisting
#: reference_output.xml:1338
#, no-c-format
msgid ""
"<![CDATA[SELECT ST_GeoHash(ST_SetSRID(ST_Point(-126,48),4326));\n"
"\n"
" st_geohash\n"
"----------------------\n"
" c0w3hf1s70w3hf1s70w3\n"
"\n"
"SELECT ST_GeoHash(ST_SetSRID(ST_Point(-126,48),4326),5);\n"
"\n"
" st_geohash\n"
"------------\n"
" c0w3h\n"
" ]]>"
msgstr ""