1# SOME DESCRIPTIVE TITLE. 2# 3# Translators: 4# nramire1 nramire1, 2017 5msgid "" 6msgstr "" 7"Project-Id-Version: PostGIS\n" 8"Report-Msgid-Bugs-To: http://bugs.kde.org\n" 9"POT-Creation-Date: 2019-10-06 23:48+0000\n" 10"PO-Revision-Date: 2018-07-23 18:01+0000\n" 11"Last-Translator: nramire1 nramire1\n" 12"Language-Team: Spanish (http://www.transifex.com/postgis/postgis/language/" 13"es/)\n" 14"Language: es\n" 15"MIME-Version: 1.0\n" 16"Content-Type: text/plain; charset=UTF-8\n" 17"Content-Transfer-Encoding: 8bit\n" 18"Plural-Forms: nplurals=2; plural=(n != 1);\n" 19 20#. Tag: title 21#: reference_editor.xml:3 22#, no-c-format 23msgid "Geometry Editors" 24msgstr "Editores de Geometría" 25 26#. Tag: refname 27#: reference_editor.xml:7 28#, no-c-format 29msgid "ST_AddPoint" 30msgstr "ST_AddPoint" 31 32#. Tag: refpurpose 33#: reference_editor.xml:8 34#, no-c-format 35msgid "Add a point to a LineString." 36msgstr "Añade un punto a una cadena de línea." 37 38#. Tag: funcprototype 39#: reference_editor.xml:12 40#, no-c-format 41msgid "" 42"<funcdef>geometry <function>ST_AddPoint</function></funcdef> " 43"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 44"<paramdef><type>geometry</type> <parameter>point</parameter></paramdef>" 45msgstr "" 46"<funcdef>geometry <function>ST_AddPoint</function></funcdef> " 47"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 48"<paramdef><type>geometry</type> <parameter>point</parameter></paramdef>" 49 50#. Tag: funcprototype 51#: reference_editor.xml:19 52#, no-c-format 53msgid "" 54"<funcdef>geometry <function>ST_AddPoint</function></funcdef> " 55"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 56"<paramdef><type>geometry</type> <parameter>point</parameter></paramdef> " 57"<paramdef><type>integer</type> <parameter>position</parameter></paramdef>" 58msgstr "" 59"<funcdef>geometry <function>ST_AddPoint</function></funcdef> " 60"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 61"<paramdef><type>geometry</type> <parameter>point</parameter></paramdef> " 62"<paramdef><type>integer</type> <parameter>position</parameter></paramdef>" 63 64#. Tag: title 65#: reference_editor.xml:29 reference_editor.xml:69 reference_editor.xml:120 66#: reference_editor.xml:162 reference_editor.xml:208 reference_editor.xml:251 67#: reference_editor.xml:294 reference_editor.xml:335 reference_editor.xml:385 68#: reference_editor.xml:425 reference_editor.xml:482 reference_editor.xml:527 69#: reference_editor.xml:556 reference_editor.xml:613 reference_editor.xml:658 70#: reference_editor.xml:697 reference_editor.xml:732 reference_editor.xml:804 71#: reference_editor.xml:908 reference_editor.xml:941 reference_editor.xml:980 72#: reference_editor.xml:1023 reference_editor.xml:1090 73#: reference_editor.xml:1168 reference_editor.xml:1306 74#, no-c-format 75msgid "Description" 76msgstr "Descripción" 77 78#. Tag: para 79#: reference_editor.xml:31 80#, no-c-format 81msgid "" 82"Adds a point to a LineString before point <position> (0-based index). " 83"Third parameter can be omitted or set to -1 for appending." 84msgstr "" 85"Agrega un punto a un LineString antes del punto <position> (índice " 86"basado en 0). El tercer parámetro puede omitirse o establecerse en -1 para " 87"anexar." 88 89#. Tag: para 90#: reference_editor.xml:34 reference_editor.xml:665 reference_editor.xml:911 91#: reference_editor.xml:1028 92#, no-c-format 93msgid "Availability: 1.1.0" 94msgstr "Disponibilidad: 1.1.0" 95 96#. Tag: para 97#: reference_editor.xml:35 reference_editor.xml:173 reference_editor.xml:216 98#: reference_editor.xml:258 reference_editor.xml:340 reference_editor.xml:394 99#: reference_editor.xml:435 reference_editor.xml:491 reference_editor.xml:532 100#: reference_editor.xml:571 reference_editor.xml:622 reference_editor.xml:912 101#: reference_editor.xml:946 reference_editor.xml:1031 reference_editor.xml:1121 102#: reference_editor.xml:1316 103#, no-c-format 104msgid "&Z_support;" 105msgstr "&Z_support;" 106 107#. Tag: title 108#: reference_editor.xml:39 reference_editor.xml:91 reference_editor.xml:135 109#: reference_editor.xml:178 reference_editor.xml:221 reference_editor.xml:264 110#: reference_editor.xml:305 reference_editor.xml:346 reference_editor.xml:441 111#: reference_editor.xml:576 reference_editor.xml:628 reference_editor.xml:670 112#: reference_editor.xml:705 reference_editor.xml:750 reference_editor.xml:875 113#: reference_editor.xml:916 reference_editor.xml:951 reference_editor.xml:996 114#: reference_editor.xml:1035 reference_editor.xml:1126 115#: reference_editor.xml:1204 116#, no-c-format 117msgid "Examples" 118msgstr "Ejemplos" 119 120#. Tag: programlisting 121#: reference_editor.xml:40 122#, no-c-format 123msgid "" 124"--guarantee all linestrings in a table are closed\n" 125" --by adding the start point of each linestring to the end of " 126"the line string\n" 127" --only for those that are not closed\n" 128" UPDATE sometable\n" 129" SET the_geom = ST_AddPoint(the_geom, " 130"ST_StartPoint(the_geom))\n" 131" FROM sometable\n" 132" WHERE ST_IsClosed(the_geom) = false;\n" 133"\n" 134" --Adding point to a 3-d line\n" 135" SELECT ST_AsEWKT(ST_AddPoint(ST_GeomFromEWKT('LINESTRING(0 0 " 136"1, 1 1 1)'), ST_MakePoint(1, 2, 3)));\n" 137"\n" 138" --result\n" 139" st_asewkt\n" 140" ----------\n" 141" LINESTRING(0 0 1,1 1 1,1 2 3)" 142msgstr "" 143"--Garantizar que todos los LineStrings en una tabla estén cerrados\n" 144" --añadiendo el punto de inicio de cada LineString al final " 145"de la cadena de línea\n" 146" --sólo para aquellos que no están cerrados\n" 147" UPDATE sometable\n" 148" SET the_geom = ST_AddPoint(the_geom, " 149"ST_StartPoint(the_geom))\n" 150" FROM sometable\n" 151" WHERE ST_IsClosed(the_geom) = false;\n" 152"\n" 153" --Agregar punto a una línea tridimensional\n" 154" SELECT ST_AsEWKT(ST_AddPoint(ST_GeomFromEWKT('LINESTRING(0 0 " 155"1, 1 1 1)'), ST_MakePoint(1, 2, 3)));\n" 156"\n" 157" --result\n" 158" st_asewkt\n" 159" ----------\n" 160" LINESTRING(0 0 1,1 1 1,1 2 3)" 161 162#. Tag: title 163#: reference_editor.xml:43 reference_editor.xml:96 reference_editor.xml:140 164#: reference_editor.xml:185 reference_editor.xml:228 reference_editor.xml:271 165#: reference_editor.xml:312 reference_editor.xml:353 reference_editor.xml:399 166#: reference_editor.xml:450 reference_editor.xml:496 reference_editor.xml:582 167#: reference_editor.xml:634 reference_editor.xml:675 reference_editor.xml:710 168#: reference_editor.xml:755 reference_editor.xml:884 reference_editor.xml:920 169#: reference_editor.xml:1001 reference_editor.xml:1039 170#: reference_editor.xml:1133 reference_editor.xml:1279 171#: reference_editor.xml:1329 172#, no-c-format 173msgid "See Also" 174msgstr "Ver también" 175 176#. Tag: para 177#: reference_editor.xml:44 178#, no-c-format 179msgid ", <xref linkend=\"ST_SetPoint\"/>" 180msgstr ", <xref linkend=\"ST_SetPoint\"/>" 181 182#. Tag: refname 183#: reference_editor.xml:51 184#, no-c-format 185msgid "ST_CollectionExtract" 186msgstr "ST_CollectionExtract" 187 188#. Tag: refpurpose 189#: reference_editor.xml:53 190#, no-c-format 191msgid "" 192"Given a (multi)geometry, return a (multi)geometry consisting only of " 193"elements of the specified type." 194msgstr "" 195"Dada una (multi)geometría, devuelve una (multi)geometría que consiste sólo " 196"en elementos del tipo especificado." 197 198#. Tag: funcprototype 199#: reference_editor.xml:60 200#, no-c-format 201msgid "" 202"<funcdef>geometry <function>ST_CollectionExtract</function></funcdef> " 203"<paramdef><type>geometry </type> <parameter>collection</parameter></" 204"paramdef> <paramdef><type>integer </type> <parameter>type</parameter></" 205"paramdef>" 206msgstr "" 207"<funcdef>geometry <function>ST_CollectionExtract</function></funcdef> " 208"<paramdef><type>geometry </type> <parameter>collection</parameter></" 209"paramdef> <paramdef><type>integer </type> <parameter>type</parameter></" 210"paramdef>" 211 212#. Tag: para 213#: reference_editor.xml:71 214#, no-c-format 215msgid "" 216"Given a (multi)geometry, returns a (multi)geometry consisting only of " 217"elements of the specified type. Sub-geometries that are not the specified " 218"type are ignored. If there are no sub-geometries of the right type, an EMPTY " 219"geometry will be returned. Only points, lines and polygons are supported. " 220"Type numbers are 1 == POINT, 2 == LINESTRING, 3 == POLYGON." 221msgstr "" 222"Dada una (multi)geometría, devuelve una (multi)geometría que consiste sólo " 223"en elementos del tipo especificado. Las subgeometrías que no son el tipo " 224"especificado se omiten. Si no hay subgeometrías del tipo correcto, se " 225"devolverá una geometría EMPTY. Sólo se admiten puntos, líneas y polígonos. " 226"Los números de tipo son 1 == POINT, 2 == LINESTRING, 3 == POLYGON." 227 228#. Tag: para 229#: reference_editor.xml:77 230#, no-c-format 231msgid "Availability: 1.5.0" 232msgstr "Disponibilidad: 1.5.0" 233 234#. Tag: para 235#: reference_editor.xml:79 236#, no-c-format 237msgid "" 238"Prior to 1.5.3 this function returned non-collection inputs untouched, no " 239"matter type. In 1.5.3 non-matching single geometries result in a NULL " 240"return. In of 2.0.0 every case of missing match results in a typed EMPTY " 241"return." 242msgstr "" 243"Antes de 1.5.3 esta función devolvió intactos las entradas sin colección, " 244"sin importar el tipo. En 1.5.3 las geometrías individuales que no coinciden " 245"resultan en un retorno NULL. En de 2.0.0 cada caso de falta de coincidencia " 246"resulta en retorno de tipo EMPTY." 247 248#. Tag: para 249#: reference_editor.xml:85 reference_editor.xml:126 250#, no-c-format 251msgid "" 252"When specifying 3 == POLYGON a multipolygon is returned even when the edges " 253"are shared. This results in an invalid multipolygon for many cases such as " 254"applying this function on an <xref linkend=\"ST_Split\"/> result." 255msgstr "" 256"Al especificar 3 == POLYGON se devuelve un multipolígono incluso cuando se " 257"comparten los bordes. Esto da lugar a un multipolígono no válido para muchos " 258"casos, como la aplicación de esta función en un resultado <xref linkend=" 259"\"ST_Split\"/>." 260 261#. Tag: programlisting 262#: reference_editor.xml:93 263#, no-c-format 264msgid "" 265"-- Constants: 1 == POINT, 2 == LINESTRING, 3 == POLYGON\n" 266"SELECT " 267"ST_AsText(ST_CollectionExtract(ST_GeomFromText('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(0 " 268"0)))'),1));\n" 269"st_astext\n" 270"---------------\n" 271"MULTIPOINT(0 0)\n" 272"(1 row)\n" 273"\n" 274"SELECT " 275"ST_AsText(ST_CollectionExtract(ST_GeomFromText('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(0 " 276"0, 1 1)),LINESTRING(2 2, 3 3))'),2));\n" 277"st_astext\n" 278"---------------\n" 279"MULTILINESTRING((0 0, 1 1), (2 2, 3 3))\n" 280"(1 row)" 281msgstr "" 282"-- Constantes: 1 == POINT, 2 == LINESTRING, 3 == POLYGON\n" 283"SELECT " 284"ST_AsText(ST_CollectionExtract(ST_GeomFromText('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(POINT(0 " 285"0)))'),1));\n" 286"st_astext\n" 287"---------------\n" 288"MULTIPOINT(0 0)\n" 289"(1 row)\n" 290"\n" 291"SELECT " 292"ST_AsText(ST_CollectionExtract(ST_GeomFromText('GEOMETRYCOLLECTION(GEOMETRYCOLLECTION(LINESTRING(0 " 293"0, 1 1)),LINESTRING(2 2, 3 3))'),2));\n" 294"st_astext\n" 295"---------------\n" 296"MULTILINESTRING((0 0, 1 1), (2 2, 3 3))\n" 297"(1 row)" 298 299#. Tag: para 300#: reference_editor.xml:97 301#, no-c-format 302msgid "" 303", <xref linkend=\"ST_Dump\"/>, <xref linkend=\"ST_CollectionHomogenize\"/>" 304msgstr "" 305", <xref linkend=\"ST_Dump\"/>, <xref linkend=\"ST_CollectionHomogenize\"/>" 306 307#. Tag: refname 308#: reference_editor.xml:103 309#, no-c-format 310msgid "ST_CollectionHomogenize" 311msgstr "ST_CollectionHomogenize" 312 313#. Tag: refpurpose 314#: reference_editor.xml:105 315#, no-c-format 316msgid "" 317"Given a geometry collection, return the \"simplest\" representation of the " 318"contents." 319msgstr "" 320"Dada una colección geométrica, devuelva la representación \"más simple\" del " 321"contenido." 322 323#. Tag: funcprototype 324#: reference_editor.xml:112 325#, no-c-format 326msgid "" 327"<funcdef>geometry <function>ST_CollectionHomogenize</function></funcdef> " 328"<paramdef><type>geometry </type> <parameter>collection</parameter></paramdef>" 329msgstr "" 330"<funcdef>geometry <function>ST_CollectionHomogenize</function></funcdef> " 331"<paramdef><type>geometry </type> <parameter>collection</parameter></paramdef>" 332 333#. Tag: para 334#: reference_editor.xml:122 335#, no-c-format 336msgid "" 337"Given a geometry collection, returns the \"simplest\" representation of the " 338"contents. Singletons will be returned as singletons. Collections that are " 339"homogeneous will be returned as the appropriate multi-type." 340msgstr "" 341"Dada una colección geométrica, devuelve la representación \"más simple\" del " 342"contenido. Los singletons se devolverán como singletons. Las colecciones que " 343"sean homogéneas se devolverán como el multitipo apropiado." 344 345#. Tag: para 346#: reference_editor.xml:130 reference_editor.xml:1200 347#, no-c-format 348msgid "Availability: 2.0.0" 349msgstr "Disponibilidad: 2.0.0" 350 351#. Tag: programlisting 352#: reference_editor.xml:137 353#, no-c-format 354msgid "" 355"SELECT ST_AsText(ST_CollectionHomogenize('GEOMETRYCOLLECTION(POINT(0 " 356"0))'));\n" 357"\n" 358" st_astext\n" 359" ------------\n" 360" POINT(0 0)\n" 361" (1 row)\n" 362"\n" 363" SELECT ST_AsText(ST_CollectionHomogenize('GEOMETRYCOLLECTION(POINT(0 0)," 364"POINT(1 1))'));\n" 365"\n" 366" st_astext\n" 367" ---------------------\n" 368" MULTIPOINT(0 0,1 1)\n" 369" (1 row)" 370msgstr "" 371"SELECT ST_AsText(ST_CollectionHomogenize('GEOMETRYCOLLECTION(POINT(0 " 372"0))'));\n" 373"\n" 374" st_astext\n" 375" ------------\n" 376" POINT(0 0)\n" 377" (1 row)\n" 378"\n" 379" SELECT ST_AsText(ST_CollectionHomogenize('GEOMETRYCOLLECTION(POINT(0 0)," 380"POINT(1 1))'));\n" 381"\n" 382" st_astext\n" 383" ---------------------\n" 384" MULTIPOINT(0 0,1 1)\n" 385" (1 row)" 386 387#. Tag: para 388#: reference_editor.xml:141 389#, no-c-format 390msgid ", <xref linkend=\"ST_CollectionExtract\"/>" 391msgstr ", <xref linkend=\"ST_CollectionExtract\"/>" 392 393#. Tag: refname 394#: reference_editor.xml:147 395#, no-c-format 396msgid "ST_Force2D" 397msgstr "ST_Force2D" 398 399#. Tag: refpurpose 400#: reference_editor.xml:149 401#, no-c-format 402msgid "Force the geometries into a \"2-dimensional mode\"." 403msgstr "Forzar las geometrías en un \"modo de 2 dimensiones\"." 404 405#. Tag: funcprototype 406#: reference_editor.xml:154 407#, no-c-format 408msgid "" 409"<funcdef>geometry <function>ST_Force2D</function></funcdef> " 410"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 411msgstr "" 412"<funcdef>geometry <function>ST_Force2D</function></funcdef> " 413"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 414 415#. Tag: para 416#: reference_editor.xml:164 417#, no-c-format 418msgid "" 419"Forces the geometries into a \"2-dimensional mode\" so that all output " 420"representations will only have the X and Y coordinates. This is useful for " 421"force OGC-compliant output (since OGC only specifies 2-D geometries)." 422msgstr "" 423"Forzar las geometrías en un \"modo de 2 dimensiones\" para que todas las " 424"representaciones de salida sólo tengan las coordenadas X e Y. Esto es útil " 425"para forzar la salida compatible con OGC (ya que OGC sólo especifica " 426"geometría 2D)." 427 428#. Tag: para 429#: reference_editor.xml:169 reference_editor.xml:212 reference_editor.xml:255 430#: reference_editor.xml:430 reference_editor.xml:570 431#, no-c-format 432msgid "Enhanced: 2.0.0 support for Polyhedral surfaces was introduced." 433msgstr "Mejorado: 2.0.0 soporte para superficies poliédricas fue introducida." 434 435#. Tag: para 436#: reference_editor.xml:170 437#, no-c-format 438msgid "Changed: 2.1.0. Up to 2.0.x this was called ST_Force_2D." 439msgstr "Cambiado: 2.1.0. Hasta la 2.0.x esto se llamaba ST_Force_2D." 440 441#. Tag: para 442#: reference_editor.xml:171 reference_editor.xml:215 reference_editor.xml:259 443#: reference_editor.xml:300 reference_editor.xml:341 reference_editor.xml:436 444#: reference_editor.xml:531 reference_editor.xml:624 reference_editor.xml:1315 445#, no-c-format 446msgid "&curve_support;" 447msgstr "&curve_support;" 448 449#. Tag: para 450#: reference_editor.xml:172 reference_editor.xml:214 reference_editor.xml:257 451#: reference_editor.xml:434 reference_editor.xml:529 reference_editor.xml:572 452#: reference_editor.xml:947 reference_editor.xml:1318 453#, no-c-format 454msgid "&P_support;" 455msgstr "&P_support;" 456 457#. Tag: programlisting 458#: reference_editor.xml:180 459#, no-c-format 460msgid "" 461"SELECT ST_AsEWKT(ST_Force2D(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 " 462"5 2, 6 7 2, 5 6 2)')));\n" 463" st_asewkt\n" 464"-------------------------------------\n" 465"CIRCULARSTRING(1 1,2 3,4 5,6 7,5 6)\n" 466"\n" 467"SELECT ST_AsEWKT(ST_Force2D('POLYGON((0 0 2,0 5 2,5 0 2,0 0 2),(1 1 2,3 1 " 468"2,1 3 2,1 1 2))'));\n" 469"\n" 470" st_asewkt\n" 471"----------------------------------------------\n" 472" POLYGON((0 0,0 5,5 0,0 0),(1 1,3 1,1 3,1 1))" 473msgstr "" 474"SELECT ST_AsEWKT(ST_Force2D(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 " 475"5 2, 6 7 2, 5 6 2)')));\n" 476" st_asewkt\n" 477"-------------------------------------\n" 478"CIRCULARSTRING(1 1,2 3,4 5,6 7,5 6)\n" 479"\n" 480"SELECT ST_AsEWKT(ST_Force2D('POLYGON((0 0 2,0 5 2,5 0 2,0 0 2),(1 1 2,3 1 " 481"2,1 3 2,1 1 2))'));\n" 482"\n" 483" st_asewkt\n" 484"----------------------------------------------\n" 485" POLYGON((0 0,0 5,5 0,0 0),(1 1,3 1,1 3,1 1))" 486 487#. Tag: refname 488#: reference_editor.xml:193 489#, no-c-format 490msgid "ST_Force3D" 491msgstr "ST_Force3D" 492 493#. Tag: refpurpose 494#: reference_editor.xml:195 495#, no-c-format 496msgid "Force the geometries into XYZ mode. This is an alias for ST_Force3DZ." 497msgstr "Forzar las geometrías en modo XYZ. Este es un alias para ST_Force3DZ." 498 499#. Tag: funcprototype 500#: reference_editor.xml:200 501#, no-c-format 502msgid "" 503"<funcdef>geometry <function>ST_Force3D</function></funcdef> " 504"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 505msgstr "" 506"<funcdef>geometry <function>ST_Force3D</function></funcdef> " 507"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 508 509#. Tag: para 510#: reference_editor.xml:210 511#, no-c-format 512msgid "" 513"Forces the geometries into XYZ mode. This is an alias for ST_Force_3DZ. If a " 514"geometry has no Z component, then a 0 Z coordinate is tacked on." 515msgstr "" 516"Fuerza las geometrías en modo XYZ. Este es un alias para ST_Force_3DZ. Si " 517"una geometría no tiene componente z, entonces un 0 se agrega a la coordenada " 518"Z." 519 520#. Tag: para 521#: reference_editor.xml:213 522#, no-c-format 523msgid "Changed: 2.1.0. Up to 2.0.x this was called ST_Force_3D." 524msgstr "Cambiado: 2.1.0. Hasta la 2.0.x esto se llamaba ST_Force_3D." 525 526#. Tag: programlisting 527#: reference_editor.xml:223 528#, no-c-format 529msgid "" 530"--Nothing happens to an already 3D geometry\n" 531" SELECT " 532"ST_AsEWKT(ST_Force3D(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 5 2, 6 " 533"7 2, 5 6 2)')));\n" 534" st_asewkt\n" 535"-----------------------------------------------\n" 536" CIRCULARSTRING(1 1 2,2 3 2,4 5 2,6 7 2,5 6 2)\n" 537"\n" 538"\n" 539"SELECT ST_AsEWKT(ST_Force3D('POLYGON((0 0,0 5,5 0,0 0),(1 1,3 1,1 3,1 " 540"1))'));\n" 541"\n" 542" st_asewkt\n" 543"--------------------------------------------------------------\n" 544" POLYGON((0 0 0,0 5 0,5 0 0,0 0 0),(1 1 0,3 1 0,1 3 0,1 1 0))" 545msgstr "" 546"--Nada le pasa a una geometría que ya es 3D\n" 547" SELECT " 548"ST_AsEWKT(ST_Force3D(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 5 2, 6 " 549"7 2, 5 6 2)')));\n" 550" st_asewkt\n" 551"-----------------------------------------------\n" 552" CIRCULARSTRING(1 1 2,2 3 2,4 5 2,6 7 2,5 6 2)\n" 553"\n" 554"\n" 555"SELECT ST_AsEWKT(ST_Force3D('POLYGON((0 0,0 5,5 0,0 0),(1 1,3 1,1 3,1 " 556"1))'));\n" 557"\n" 558" st_asewkt\n" 559"--------------------------------------------------------------\n" 560" POLYGON((0 0 0,0 5 0,5 0 0,0 0 0),(1 1 0,3 1 0,1 3 0,1 1 0))" 561 562#. Tag: para 563#: reference_editor.xml:230 564#, no-c-format 565msgid "" 566", <xref linkend=\"ST_Force2D\"/>, <xref linkend=\"ST_Force_3DM\"/>, <xref " 567"linkend=\"ST_Force_3DZ\"/>" 568msgstr "" 569", <xref linkend=\"ST_Force2D\"/>, <xref linkend=\"ST_Force_3DM\"/>, <xref " 570"linkend=\"ST_Force_3DZ\"/>" 571 572#. Tag: refname 573#: reference_editor.xml:236 574#, no-c-format 575msgid "ST_Force3DZ" 576msgstr "ST_Force3DZ" 577 578#. Tag: refpurpose 579#: reference_editor.xml:238 580#, no-c-format 581msgid "Force the geometries into XYZ mode." 582msgstr "Fuerza las geometrías en modo XYZ." 583 584#. Tag: funcprototype 585#: reference_editor.xml:243 586#, no-c-format 587msgid "" 588"<funcdef>geometry <function>ST_Force3DZ</function></funcdef> " 589"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 590msgstr "" 591"<funcdef>geometry <function>ST_Force3DZ</function></funcdef> " 592"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 593 594#. Tag: para 595#: reference_editor.xml:253 596#, no-c-format 597msgid "" 598"Forces the geometries into XYZ mode. This is a synonym for ST_Force3DZ. If a " 599"geometry has no Z component, then a 0 Z coordinate is tacked on." 600msgstr "" 601"Fuerza las geometrías en modo XYZ. Este es un sinónimo de ST_Force3DZ. Si " 602"una geometría no tiene componente z, entonces un 0 se agrega a la coordenada " 603"Z." 604 605#. Tag: para 606#: reference_editor.xml:256 607#, no-c-format 608msgid "Changed: 2.1.0. Up to 2.0.x this was called ST_Force_3DZ." 609msgstr "Cambiado: 2.1.0. Hasta la 2.0.x esto se llamaba ST_Force_3DZ." 610 611#. Tag: programlisting 612#: reference_editor.xml:266 613#, no-c-format 614msgid "" 615"--Nothing happens to an already 3D geometry\n" 616"SELECT ST_AsEWKT(ST_Force3DZ(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 " 617"5 2, 6 7 2, 5 6 2)')));\n" 618" st_asewkt\n" 619"-----------------------------------------------\n" 620" CIRCULARSTRING(1 1 2,2 3 2,4 5 2,6 7 2,5 6 2)\n" 621"\n" 622"\n" 623"SELECT ST_AsEWKT(ST_Force3DZ('POLYGON((0 0,0 5,5 0,0 0),(1 1,3 1,1 3,1 " 624"1))'));\n" 625"\n" 626" st_asewkt\n" 627"--------------------------------------------------------------\n" 628" POLYGON((0 0 0,0 5 0,5 0 0,0 0 0),(1 1 0,3 1 0,1 3 0,1 1 0))" 629msgstr "" 630"--Nada le pasa a una geometría que ya es 3D\n" 631"SELECT ST_AsEWKT(ST_Force3DZ(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 " 632"5 2, 6 7 2, 5 6 2)')));\n" 633" st_asewkt\n" 634"-----------------------------------------------\n" 635" CIRCULARSTRING(1 1 2,2 3 2,4 5 2,6 7 2,5 6 2)\n" 636"\n" 637"\n" 638"SELECT ST_AsEWKT(ST_Force3DZ('POLYGON((0 0,0 5,5 0,0 0),(1 1,3 1,1 3,1 " 639"1))'));\n" 640"\n" 641" st_asewkt\n" 642"--------------------------------------------------------------\n" 643" POLYGON((0 0 0,0 5 0,5 0 0,0 0 0),(1 1 0,3 1 0,1 3 0,1 1 0))" 644 645#. Tag: para 646#: reference_editor.xml:273 reference_editor.xml:355 647#, no-c-format 648msgid "" 649", <xref linkend=\"ST_Force2D\"/>, <xref linkend=\"ST_Force_3DM\"/>, <xref " 650"linkend=\"ST_Force_3D\"/>" 651msgstr "" 652", <xref linkend=\"ST_Force2D\"/>, <xref linkend=\"ST_Force_3DM\"/>, <xref " 653"linkend=\"ST_Force_3D\"/>" 654 655#. Tag: refname 656#: reference_editor.xml:279 657#, no-c-format 658msgid "ST_Force3DM" 659msgstr "ST_Force3DM" 660 661#. Tag: refpurpose 662#: reference_editor.xml:281 663#, no-c-format 664msgid "Force the geometries into XYM mode." 665msgstr "Fuerza las geometrías en modo XYM." 666 667#. Tag: funcprototype 668#: reference_editor.xml:286 669#, no-c-format 670msgid "" 671"<funcdef>geometry <function>ST_Force3DM</function></funcdef> " 672"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 673msgstr "" 674"<funcdef>geometry <function>ST_Force3DM</function></funcdef> " 675"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 676 677#. Tag: para 678#: reference_editor.xml:296 679#, no-c-format 680msgid "" 681"Forces the geometries into XYM mode. If a geometry has no M component, then " 682"a 0 M coordinate is tacked on. If it has a Z component, then Z is removed" 683msgstr "" 684"Fuerza las geometrías en modo XYM. Si una geometría no tiene componente M, " 685"entonces un 0 se agrega a la coordenada M. Si tiene un componente Z, " 686"entonces Z se quita" 687 688#. Tag: para 689#: reference_editor.xml:299 690#, no-c-format 691msgid "Changed: 2.1.0. Up to 2.0.x this was called ST_Force_3DM." 692msgstr "Cambiado: 2.1.0. Hasta la 2.0.x esto se llamaba ST_Force_3DM." 693 694#. Tag: programlisting 695#: reference_editor.xml:307 696#, no-c-format 697msgid "" 698"--Nothing happens to an already 3D geometry\n" 699"SELECT ST_AsEWKT(ST_Force3DM(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 " 700"5 2, 6 7 2, 5 6 2)')));\n" 701" st_asewkt\n" 702"------------------------------------------------\n" 703" CIRCULARSTRINGM(1 1 0,2 3 0,4 5 0,6 7 0,5 6 0)\n" 704"\n" 705"\n" 706"SELECT ST_AsEWKT(ST_Force3DM('POLYGON((0 0 1,0 5 1,5 0 1,0 0 1),(1 1 1,3 1 " 707"1,1 3 1,1 1 1))'));\n" 708"\n" 709" st_asewkt\n" 710"---------------------------------------------------------------\n" 711" POLYGONM((0 0 0,0 5 0,5 0 0,0 0 0),(1 1 0,3 1 0,1 3 0,1 1 0))" 712msgstr "" 713"--Nada le pasa a una geometría que ya es 3D\n" 714"SELECT ST_AsEWKT(ST_Force3DM(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 " 715"5 2, 6 7 2, 5 6 2)')));\n" 716" st_asewkt\n" 717"------------------------------------------------\n" 718" CIRCULARSTRINGM(1 1 0,2 3 0,4 5 0,6 7 0,5 6 0)\n" 719"\n" 720"\n" 721"SELECT ST_AsEWKT(ST_Force3DM('POLYGON((0 0 1,0 5 1,5 0 1,0 0 1),(1 1 1,3 1 " 722"1,1 3 1,1 1 1))'));\n" 723"\n" 724" st_asewkt\n" 725"---------------------------------------------------------------\n" 726" POLYGONM((0 0 0,0 5 0,5 0 0,0 0 0),(1 1 0,3 1 0,1 3 0,1 1 0))" 727 728#. Tag: para 729#: reference_editor.xml:314 reference_editor.xml:452 730#, no-c-format 731msgid "" 732", <xref linkend=\"ST_Force2D\"/>, <xref linkend=\"ST_Force_3DM\"/>, <xref " 733"linkend=\"ST_Force_3D\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>" 734msgstr "" 735", <xref linkend=\"ST_Force2D\"/>, <xref linkend=\"ST_Force_3DM\"/>, <xref " 736"linkend=\"ST_Force_3D\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>" 737 738#. Tag: refname 739#: reference_editor.xml:320 740#, no-c-format 741msgid "ST_Force4D" 742msgstr "ST_Force4D" 743 744#. Tag: refpurpose 745#: reference_editor.xml:322 746#, no-c-format 747msgid "Force the geometries into XYZM mode." 748msgstr "Fuerza las geometrías en modo XYZM." 749 750#. Tag: funcprototype 751#: reference_editor.xml:327 752#, no-c-format 753msgid "" 754"<funcdef>geometry <function>ST_Force4D</function></funcdef> " 755"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 756msgstr "" 757"<funcdef>geometry <function>ST_Force4D</function></funcdef> " 758"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 759 760#. Tag: para 761#: reference_editor.xml:337 762#, no-c-format 763msgid "" 764"Forces the geometries into XYZM mode. 0 is tacked on for missing Z and M " 765"dimensions." 766msgstr "" 767"Fuerza las geometrías en modo XYZM. Un 0 es agregado para las coordenadas Z " 768"y M faltantes." 769 770#. Tag: para 771#: reference_editor.xml:339 772#, no-c-format 773msgid "Changed: 2.1.0. Up to 2.0.x this was called ST_Force_4D." 774msgstr "Cambiado: 2.1.0. Hasta la 2.0.x esto se llamaba ST_Force_4D." 775 776#. Tag: programlisting 777#: reference_editor.xml:348 778#, no-c-format 779msgid "" 780"--Nothing happens to an already 3D geometry\n" 781"SELECT ST_AsEWKT(ST_Force4D(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 " 782"5 2, 6 7 2, 5 6 2)')));\n" 783" st_asewkt\n" 784"---------------------------------------------------------\n" 785" CIRCULARSTRING(1 1 2 0,2 3 2 0,4 5 2 0,6 7 2 0,5 6 2 0)\n" 786"\n" 787"\n" 788"\n" 789"SELECT ST_AsEWKT(ST_Force4D('MULTILINESTRINGM((0 0 1,0 5 2,5 0 3,0 0 4),(1 " 790"1 1,3 1 1,1 3 1,1 1 1))'));\n" 791"\n" 792" st_asewkt\n" 793"--------------------------------------------------------------------------------------\n" 794" MULTILINESTRING((0 0 0 1,0 5 0 2,5 0 0 3,0 0 0 4),(1 1 0 1,3 1 0 1,1 3 0 " 795"1,1 1 0 1))" 796msgstr "" 797"--Nada le pasa a una geometría que ya es 3D\n" 798"SELECT ST_AsEWKT(ST_Force4D(ST_GeomFromEWKT('CIRCULARSTRING(1 1 2, 2 3 2, 4 " 799"5 2, 6 7 2, 5 6 2)')));\n" 800" st_asewkt\n" 801"---------------------------------------------------------\n" 802" CIRCULARSTRING(1 1 2 0,2 3 2 0,4 5 2 0,6 7 2 0,5 6 2 0)\n" 803"\n" 804"\n" 805"\n" 806"SELECT ST_AsEWKT(ST_Force4D('MULTILINESTRINGM((0 0 1,0 5 2,5 0 3,0 0 4),(1 " 807"1 1,3 1 1,1 3 1,1 1 1))'));\n" 808"\n" 809" st_asewkt\n" 810"--------------------------------------------------------------------------------------\n" 811" MULTILINESTRING((0 0 0 1,0 5 0 2,5 0 0 3,0 0 0 4),(1 1 0 1,3 1 0 1,1 3 0 " 812"1,1 1 0 1))" 813 814#. Tag: refname 815#: reference_editor.xml:361 816#, no-c-format 817msgid "ST_ForcePolygonCCW" 818msgstr "ST_ForcePolygonCCW" 819 820#. Tag: refpurpose 821#: reference_editor.xml:364 822#, no-c-format 823msgid "" 824"Orients all exterior rings counter-clockwise and all interior rings " 825"clockwise." 826msgstr "" 827"Orienta todos los aros exteriores en sentido contrario a las agujas del " 828"reloj y todos los aros interiores en sentido horario." 829 830#. Tag: funcprototype 831#: reference_editor.xml:371 832#, no-c-format 833msgid "" 834"<funcdef> geometry <function>ST_ForcePolygonCCW</function> </funcdef> " 835"<paramdef> <type>geometry</type> <parameter>geom</parameter> </paramdef>" 836msgstr "" 837"<funcdef> geometry <function>ST_ForcePolygonCCW</function> </funcdef> " 838"<paramdef> <type>geometry</type> <parameter>geom</parameter> </paramdef>" 839 840#. Tag: para 841#: reference_editor.xml:387 842#, no-c-format 843msgid "" 844"Forces (Multi)Polygons to use a counter-clockwise orientation for their " 845"exterior ring, and a clockwise orientation for their interior rings. Non-" 846"polygonal geometries are returned unchanged." 847msgstr "" 848"Fuerza (Multi)polígonos a utilizar una orientación en sentido contrario a " 849"las manecillas del reloj para su anillo exterior, y una orientación en el " 850"sentido de las agujas del reloj para sus anillos interiores. Las geometrías " 851"no poligonales se devuelven sin cambios." 852 853#. Tag: para 854#: reference_editor.xml:393 reference_editor.xml:490 855#, fuzzy, no-c-format 856msgid "Availability: 2.4.0" 857msgstr "Disponibilidad: 2.0.0" 858 859#. Tag: para 860#: reference_editor.xml:395 reference_editor.xml:492 reference_editor.xml:1317 861#, no-c-format 862msgid "&M_support;" 863msgstr "&M_support;" 864 865#. Tag: para 866#: reference_editor.xml:400 reference_editor.xml:497 867#, no-c-format 868msgid "" 869", <xref linkend=\"ST_IsPolygonCCW\"/>, <xref linkend=\"ST_IsPolygonCW\"/>" 870msgstr "" 871", <xref linkend=\"ST_IsPolygonCCW\"/>, <xref linkend=\"ST_IsPolygonCW\"/>" 872 873#. Tag: refname 874#: reference_editor.xml:410 875#, no-c-format 876msgid "ST_ForceCollection" 877msgstr "ST_ForceCollection" 878 879#. Tag: refpurpose 880#: reference_editor.xml:412 881#, no-c-format 882msgid "Convert the geometry into a GEOMETRYCOLLECTION." 883msgstr "Convertir la geometría en una GEOMETRYCOLLECTION." 884 885#. Tag: funcprototype 886#: reference_editor.xml:417 887#, no-c-format 888msgid "" 889"<funcdef>geometry <function>ST_ForceCollection</function></funcdef> " 890"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 891msgstr "" 892"<funcdef>geometry <function>ST_ForceCollection</function></funcdef> " 893"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef>" 894 895#. Tag: para 896#: reference_editor.xml:427 897#, no-c-format 898msgid "" 899"Converts the geometry into a GEOMETRYCOLLECTION. This is useful for " 900"simplifying the WKB representation." 901msgstr "" 902"Convierte la geometría en una GEOMETRYCOLLECTION. Esto es útil para " 903"simplificar la representación WKB." 904 905#. Tag: para 906#: reference_editor.xml:431 907#, no-c-format 908msgid "" 909"Availability: 1.2.2, prior to 1.3.4 this function will crash with Curves. " 910"This is fixed in 1.3.4+" 911msgstr "" 912"Disponibilidad: 1.2.2, antes de 1.3.4 esta función se bloqueará con curvas. " 913"Esto se fija en 1.3.4 +" 914 915#. Tag: para 916#: reference_editor.xml:432 917#, no-c-format 918msgid "Changed: 2.1.0. Up to 2.0.x this was called ST_Force_Collection." 919msgstr "Cambiado: 2.1.0. Hasta la 2.0.x esto se llamaba ST_Force_Collection." 920 921#. Tag: programlisting 922#: reference_editor.xml:443 923#, no-c-format 924msgid "" 925"SELECT ST_AsEWKT(ST_ForceCollection('POLYGON((0 0 1,0 5 1,5 0 1,0 0 1),(1 1 " 926"1,3 1 1,1 3 1,1 1 1))'));\n" 927"\n" 928" st_asewkt\n" 929"----------------------------------------------------------------------------------\n" 930" GEOMETRYCOLLECTION(POLYGON((0 0 1,0 5 1,5 0 1,0 0 1),(1 1 1,3 1 1,1 3 1,1 1 " 931"1)))\n" 932"\n" 933"\n" 934" SELECT ST_AsText(ST_ForceCollection('CIRCULARSTRING(220227 150406,2220227 " 935"150407,220227 150406)'));\n" 936" st_astext\n" 937"--------------------------------------------------------------------------------\n" 938" GEOMETRYCOLLECTION(CIRCULARSTRING(220227 150406,2220227 150407,220227 " 939"150406))\n" 940"(1 row)" 941msgstr "" 942"SELECT ST_AsEWKT(ST_ForceCollection('POLYGON((0 0 1,0 5 1,5 0 1,0 0 1),(1 1 " 943"1,3 1 1,1 3 1,1 1 1))'));\n" 944"\n" 945" st_asewkt\n" 946"----------------------------------------------------------------------------------\n" 947" GEOMETRYCOLLECTION(POLYGON((0 0 1,0 5 1,5 0 1,0 0 1),(1 1 1,3 1 1,1 3 1,1 1 " 948"1)))\n" 949"\n" 950"\n" 951" SELECT ST_AsText(ST_ForceCollection('CIRCULARSTRING(220227 150406,2220227 " 952"150407,220227 150406)'));\n" 953" st_astext\n" 954"--------------------------------------------------------------------------------\n" 955" GEOMETRYCOLLECTION(CIRCULARSTRING(220227 150406,2220227 150407,220227 " 956"150406))\n" 957"(1 row)" 958 959#. Tag: programlisting 960#: reference_editor.xml:445 961#, no-c-format 962msgid "" 963"-- POLYHEDRAL example --\n" 964"SELECT ST_AsEWKT(ST_ForceCollection('POLYHEDRALSURFACE(((0 0 0,0 0 1,0 1 1,0 " 965"1 0,0 0 0)),\n" 966" ((0 0 0,0 1 0,1 1 0,1 0 0,0 0 0)),\n" 967" ((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0)),\n" 968" ((1 1 0,1 1 1,1 0 1,1 0 0,1 1 0)),\n" 969" ((0 1 0,0 1 1,1 1 1,1 1 0,0 1 0)),\n" 970" ((0 0 1,1 0 1,1 1 1,0 1 1,0 0 1)))'))\n" 971"\n" 972" st_asewkt\n" 973"----------------------------------------------------------------------------------\n" 974"GEOMETRYCOLLECTION(\n" 975" POLYGON((0 0 0,0 0 1,0 1 1,0 1 0,0 0 0)),\n" 976" POLYGON((0 0 0,0 1 0,1 1 0,1 0 0,0 0 0)),\n" 977" POLYGON((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0)),\n" 978" POLYGON((1 1 0,1 1 1,1 0 1,1 0 0,1 1 0)),\n" 979" POLYGON((0 1 0,0 1 1,1 1 1,1 1 0,0 1 0)),\n" 980" POLYGON((0 0 1,1 0 1,1 1 1,0 1 1,0 0 1))\n" 981")" 982msgstr "" 983"-- Ejemplo POLYHEDRAL --\n" 984"SELECT ST_AsEWKT(ST_ForceCollection('POLYHEDRALSURFACE(((0 0 0,0 0 1,0 1 1,0 " 985"1 0,0 0 0)),\n" 986" ((0 0 0,0 1 0,1 1 0,1 0 0,0 0 0)),\n" 987" ((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0)),\n" 988" ((1 1 0,1 1 1,1 0 1,1 0 0,1 1 0)),\n" 989" ((0 1 0,0 1 1,1 1 1,1 1 0,0 1 0)),\n" 990" ((0 0 1,1 0 1,1 1 1,0 1 1,0 0 1)))'))\n" 991"\n" 992" st_asewkt\n" 993"----------------------------------------------------------------------------------\n" 994"GEOMETRYCOLLECTION(\n" 995" POLYGON((0 0 0,0 0 1,0 1 1,0 1 0,0 0 0)),\n" 996" POLYGON((0 0 0,0 1 0,1 1 0,1 0 0,0 0 0)),\n" 997" POLYGON((0 0 0,1 0 0,1 0 1,0 0 1,0 0 0)),\n" 998" POLYGON((1 1 0,1 1 1,1 0 1,1 0 0,1 1 0)),\n" 999" POLYGON((0 1 0,0 1 1,1 1 1,1 1 0,0 1 0)),\n" 1000" POLYGON((0 0 1,1 0 1,1 1 1,0 1 1,0 0 1))\n" 1001")" 1002 1003#. Tag: refname 1004#: reference_editor.xml:458 1005#, no-c-format 1006msgid "ST_ForcePolygonCW" 1007msgstr "ST_ForcePolygonCW" 1008 1009#. Tag: refpurpose 1010#: reference_editor.xml:461 1011#, no-c-format 1012msgid "" 1013"Orients all exterior rings clockwise and all interior rings counter-" 1014"clockwise." 1015msgstr "" 1016"Orienta todos los anillos exteriores en el sentido de las agujas del reloj y " 1017"todos los anillos interiores en sentido contrario a las agujas del reloj." 1018 1019#. Tag: funcprototype 1020#: reference_editor.xml:468 1021#, no-c-format 1022msgid "" 1023"<funcdef> geometry <function>ST_ForcePolygonCW</function> </funcdef> " 1024"<paramdef> <type>geometry</type> <parameter>geom</parameter> </paramdef>" 1025msgstr "" 1026"<funcdef> geometry <function>ST_ForcePolygonCW</function> </funcdef> " 1027"<paramdef> <type>geometry</type> <parameter>geom</parameter> </paramdef>" 1028 1029#. Tag: para 1030#: reference_editor.xml:484 1031#, no-c-format 1032msgid "" 1033"Forces (Multi)Polygons to use a clockwise orientation for their exterior " 1034"ring, and a counter-clockwise orientation for their interior rings. Non-" 1035"polygonal geometries are returned unchanged." 1036msgstr "" 1037"Fuerza (Multi)Polígonos a utilizar una orientación en el sentido de las " 1038"agujas del reloj para su anillo exterior, y una orientación en sentido " 1039"contrario a las agujas del reloj para sus anillos interiores. Las geometrías " 1040"no poligonales se devuelven sin cambios." 1041 1042#. Tag: refname 1043#: reference_editor.xml:507 1044#, no-c-format 1045msgid "ST_ForceSFS" 1046msgstr "ST_ForceSFS" 1047 1048#. Tag: refpurpose 1049#: reference_editor.xml:509 1050#, no-c-format 1051msgid "Force the geometries to use SFS 1.1 geometry types only." 1052msgstr "Fuerza las geometrías para usar sólo los tipos de geometría SFS 1.1." 1053 1054#. Tag: funcsynopsis 1055#: reference_editor.xml:513 1056#, no-c-format 1057msgid "" 1058"<funcprototype> <funcdef>geometry <function>ST_ForceSFS</function></funcdef> " 1059"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> </" 1060"funcprototype> <funcprototype> <funcdef>geometry <function>ST_ForceSFS</" 1061"function></funcdef> <paramdef><type>geometry </type> <parameter>geomA</" 1062"parameter></paramdef> <paramdef><type>text </type> <parameter>version</" 1063"parameter></paramdef> </funcprototype>" 1064msgstr "" 1065"<funcprototype> <funcdef>geometry <function>ST_ForceSFS</function></funcdef> " 1066"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> </" 1067"funcprototype> <funcprototype> <funcdef>geometry <function>ST_ForceSFS</" 1068"function></funcdef> <paramdef><type>geometry </type> <parameter>geomA</" 1069"parameter></paramdef> <paramdef><type>text </type> <parameter>version</" 1070"parameter></paramdef> </funcprototype>" 1071 1072#. Tag: para 1073#: reference_editor.xml:530 reference_editor.xml:1319 1074#, no-c-format 1075msgid "&T_support;" 1076msgstr "&T_support;" 1077 1078#. Tag: refname 1079#: reference_editor.xml:539 1080#, no-c-format 1081msgid "ST_ForceRHR" 1082msgstr "ST_ForceRHR" 1083 1084#. Tag: refpurpose 1085#: reference_editor.xml:541 1086#, no-c-format 1087msgid "" 1088"Force the orientation of the vertices in a polygon to follow the Right-Hand-" 1089"Rule." 1090msgstr "" 1091"Fuerza la orientación de los vértices en un polígono para seguir la regla de " 1092"la mano derecha." 1093 1094#. Tag: funcprototype 1095#: reference_editor.xml:547 1096#, no-c-format 1097msgid "" 1098"<funcdef>geometry <function>ST_ForceRHR</function></funcdef> " 1099"<paramdef><type>geometry</type> <parameter>g</parameter></paramdef>" 1100msgstr "" 1101"<funcdef>geometry <function>ST_ForceRHR</function></funcdef> " 1102"<paramdef><type>geometry</type> <parameter>g</parameter></paramdef>" 1103 1104#. Tag: para 1105#: reference_editor.xml:558 1106#, no-c-format 1107msgid "" 1108"Forces the orientation of the vertices in a polygon to follow a Right-Hand-" 1109"Rule, in which the area that is bounded by the polygon is to the right of " 1110"the boundary. In particular, the exterior ring is orientated in a clockwise " 1111"direction and the interior rings in a counter-clockwise direction. This " 1112"function is a synonym for <xref linkend=\"ST_ForcePolygonCW\"/>" 1113msgstr "" 1114"Fuerce la orientación de los vértices en un polígono para seguir la regla de " 1115"la mano derecha, en el cual, el área que está delimitada por el polígono " 1116"está a la derecha del límite. En particular, el anillo exterior está " 1117"orientado en el sentido de las agujas del reloj y el interior está orientado " 1118"en sentido contrario a las agujas del reloj. Esta función es sinónimo de " 1119"<xref linkend=\"ST_ForcePolygonCW\"/>" 1120 1121#. Tag: para 1122#: reference_editor.xml:565 1123#, no-c-format 1124msgid "" 1125"The above definition of the Right-Hand-Rule conflicts with definitions used " 1126"in other contexts. To avoid confusion, it is recommended to use " 1127"ST_ForcePolygonCW." 1128msgstr "" 1129"La definición anterior de la regla de la derecha entra en conflicto con " 1130"definiciones utilizadas en otros contextos. Para evitar la confusión, se " 1131"recomienda utilizar ST_ForcePolygonCW." 1132 1133#. Tag: programlisting 1134#: reference_editor.xml:578 1135#, no-c-format 1136msgid "" 1137"SELECT ST_AsEWKT(\n" 1138" ST_ForceRHR(\n" 1139" 'POLYGON((0 0 2, 5 0 2, 0 5 2, 0 0 2),(1 1 2, 1 3 2, 3 1 2, 1 1 " 1140"2))'\n" 1141" )\n" 1142");\n" 1143" st_asewkt\n" 1144"--------------------------------------------------------------\n" 1145" POLYGON((0 0 2,0 5 2,5 0 2,0 0 2),(1 1 2,3 1 2,1 3 2,1 1 2))\n" 1146"(1 row)" 1147msgstr "" 1148"SELECT ST_AsEWKT(\n" 1149" ST_ForceRHR(\n" 1150" 'POLYGON((0 0 2, 5 0 2, 0 5 2, 0 0 2),(1 1 2, 1 3 2, 3 1 2, 1 1 " 1151"2))'\n" 1152" )\n" 1153");\n" 1154" st_asewkt\n" 1155"--------------------------------------------------------------\n" 1156" POLYGON((0 0 2,0 5 2,5 0 2,0 0 2),(1 1 2,3 1 2,1 3 2,1 1 2))\n" 1157"(1 row)" 1158 1159#. Tag: para 1160#: reference_editor.xml:584 1161#, no-c-format 1162msgid "" 1163", <xref linkend=\"ST_ForcePolygonCW\"/>, <xref linkend=\"ST_IsPolygonCCW\"/" 1164">, <xref linkend=\"ST_IsPolygonCW\"/>, <xref linkend=\"ST_BuildArea\"/>, " 1165"<xref linkend=\"ST_Polygonize\"/>, <xref linkend=\"ST_Reverse\"/>" 1166msgstr "" 1167", <xref linkend=\"ST_ForcePolygonCW\"/>, <xref linkend=\"ST_IsPolygonCCW\"/" 1168">, <xref linkend=\"ST_IsPolygonCW\"/>, <xref linkend=\"ST_BuildArea\"/>, " 1169"<xref linkend=\"ST_Polygonize\"/>, <xref linkend=\"ST_Reverse\"/>" 1170 1171#. Tag: refname 1172#: reference_editor.xml:597 1173#, no-c-format 1174msgid "ST_ForceCurve" 1175msgstr "ST_ForceCurve" 1176 1177#. Tag: refpurpose 1178#: reference_editor.xml:599 1179#, no-c-format 1180msgid "Upcast a geometry into its curved type, if applicable." 1181msgstr "Relanzar una geometría en su tipo curvo, si corresponde." 1182 1183#. Tag: funcprototype 1184#: reference_editor.xml:604 1185#, no-c-format 1186msgid "" 1187"<funcdef>geometry <function>ST_ForceCurve</function></funcdef> " 1188"<paramdef><type>geometry</type> <parameter>g</parameter></paramdef>" 1189msgstr "" 1190"<funcdef>geometry <function>ST_ForceCurve</function></funcdef> " 1191"<paramdef><type>geometry</type> <parameter>g</parameter></paramdef>" 1192 1193#. Tag: para 1194#: reference_editor.xml:615 1195#, no-c-format 1196msgid "" 1197"Turns a geometry into its curved representation, if applicable: lines become " 1198"compoundcurves, multilines become multicurves polygons become curvepolygons " 1199"multipolygons become multisurfaces. If the geometry input is already a " 1200"curved representation returns back same as input." 1201msgstr "" 1202"Convierte una geometría en su representación curvada, si corresponde: las " 1203"líneas se convierten en curvas compuestas, las multilíneas se convierten en " 1204"polígonos multicurvos se convierten en polígonos de curvas los " 1205"multipolígonos se convierten en multisuperficies. Si la entrada de geometría " 1206"es ya una representación curvada regresa igual que la entrada." 1207 1208#. Tag: para 1209#: reference_editor.xml:621 reference_editor.xml:1314 1210#, no-c-format 1211msgid "Availability: 2.2.0" 1212msgstr "Disponibilidad: 2.2.0" 1213 1214#. Tag: programlisting 1215#: reference_editor.xml:630 1216#, no-c-format 1217msgid "" 1218"SELECT ST_AsText(\n" 1219" ST_ForceCurve(\n" 1220" 'POLYGON((0 0 2, 5 0 2, 0 5 2, 0 0 2),(1 1 2, 1 3 2, 3 1 2, 1 1 " 1221"2))'::geometry\n" 1222" )\n" 1223");\n" 1224" st_astext\n" 1225"----------------------------------------------------------------------\n" 1226" CURVEPOLYGON Z ((0 0 2,5 0 2,0 5 2,0 0 2),(1 1 2,1 3 2,3 1 2,1 1 2))\n" 1227"(1 row)" 1228msgstr "" 1229"SELECT ST_AsText(\n" 1230" ST_ForceCurve(\n" 1231" 'POLYGON((0 0 2, 5 0 2, 0 5 2, 0 0 2),(1 1 2, 1 3 2, 3 1 2, 1 1 " 1232"2))'::geometry\n" 1233" )\n" 1234");\n" 1235" st_astext\n" 1236"----------------------------------------------------------------------\n" 1237" CURVEPOLYGON Z ((0 0 2,5 0 2,0 5 2,0 0 2),(1 1 2,1 3 2,3 1 2,1 1 2))\n" 1238"(1 row)" 1239 1240#. Tag: refname 1241#: reference_editor.xml:642 1242#, no-c-format 1243msgid "ST_LineMerge" 1244msgstr "ST_LineMerge" 1245 1246#. Tag: refpurpose 1247#: reference_editor.xml:644 1248#, no-c-format 1249msgid "" 1250"Return a (set of) LineString(s) formed by sewing together a MULTILINESTRING." 1251msgstr "" 1252"Devuelve un (conjunto de) LineString (s) formado por un agrupamiento " 1253"formando un MULTILINESTRING." 1254 1255#. Tag: funcprototype 1256#: reference_editor.xml:650 1257#, no-c-format 1258msgid "" 1259"<funcdef>geometry <function>ST_LineMerge</function></funcdef> " 1260"<paramdef><type>geometry </type> <parameter>amultilinestring</parameter></" 1261"paramdef>" 1262msgstr "" 1263"<funcdef>geometry <function>ST_LineMerge</function></funcdef> " 1264"<paramdef><type>geometry </type> <parameter>amultilinestring</parameter></" 1265"paramdef>" 1266 1267#. Tag: para 1268#: reference_editor.xml:660 1269#, no-c-format 1270msgid "" 1271"Returns a (set of) LineString(s) formed by sewing together the constituent " 1272"line work of a MULTILINESTRING." 1273msgstr "" 1274"Devuelve un (conjunto de) LineString (s) formado por un agrupamiento la " 1275"linea de trabajo constituyente de un MULTILINESTRING." 1276 1277#. Tag: para 1278#: reference_editor.xml:662 1279#, no-c-format 1280msgid "" 1281"Only use with MULTILINESTRING/LINESTRINGs. If you feed a polygon or geometry " 1282"collection into this function, it will return an empty GEOMETRYCOLLECTION" 1283msgstr "" 1284"Utilice solamente con MULTILINESTRING/LINESTRINGs. Si se alimenta un " 1285"polígono o una colección geométrica en esta función, se devolverá un " 1286"GEOMETRYCOLLECTION vacío" 1287 1288#. Tag: para 1289#: reference_editor.xml:664 reference_editor.xml:1199 1290#, no-c-format 1291msgid "Performed by the GEOS module." 1292msgstr "" 1293 1294#. Tag: para 1295#: reference_editor.xml:666 1296#, no-c-format 1297msgid "Will strip the M dimension." 1298msgstr "" 1299 1300#. Tag: programlisting 1301#: reference_editor.xml:672 1302#, fuzzy, no-c-format 1303msgid "" 1304"SELECT ST_AsText(ST_LineMerge(\n" 1305"ST_GeomFromText('MULTILINESTRING((-29 -27,-30 -29.7,-36 -31,-45 -33),(-45 " 1306"-33,-46 -32))')\n" 1307" )\n" 1308");\n" 1309"st_astext\n" 1310"--------------------------------------------------------------------------------------------------\n" 1311"LINESTRING(-29 -27,-30 -29.7,-36 -31,-45 -33,-46 -32)\n" 1312"(1 row)\n" 1313"\n" 1314"--If can't be merged - original MULTILINESTRING is returned\n" 1315"SELECT ST_AsText(ST_LineMerge(\n" 1316"ST_GeomFromText('MULTILINESTRING((-29 -27,-30 -29.7,-36 -31,-45 -33),(-45.2 " 1317"-33.2,-46 -32))')\n" 1318")\n" 1319");\n" 1320"st_astext\n" 1321"----------------\n" 1322"MULTILINESTRING((-45.2 -33.2,-46 -32),(-29 -27,-30 -29.7,-36 -31,-45 -33))\n" 1323"\n" 1324"-- example with Z dimension\n" 1325"SELECT ST_AsText(ST_LineMerge(\n" 1326"ST_GeomFromText('MULTILINESTRING((-29 -27 11,-30 -29.7 10,-36 -31 5,-45 -33 " 1327"6), (-29 -27 12,-30 -29.7 5), (-45 -33 1,-46 -32 11))')\n" 1328" )\n" 1329");\n" 1330"st_astext\n" 1331"--------------------------------------------------------------------------------------------------\n" 1332"LINESTRING Z (-30 -29.7 5,-29 -27 11,-30 -29.7 10,-36 -31 5,-45 -33 1,-46 " 1333"-32 11)\n" 1334"(1 row)" 1335msgstr "" 1336"SELECT ST_AsText(ST_LineMerge(\n" 1337"ST_GeomFromText('MULTILINESTRING((-29 -27,-30 -29.7,-36 -31,-45 -33),(-45 " 1338"-33,-46 -32))')\n" 1339" )\n" 1340");\n" 1341"st_astext\n" 1342"--------------------------------------------------------------------------------------------------\n" 1343"LINESTRING(-29 -27,-30 -29.7,-36 -31,-45 -33,-46 -32)\n" 1344"(1 row)\n" 1345"\n" 1346"--Si no se puede fusionar, se devuelve el MULTILINESTRING original\n" 1347"SELECT ST_AsText(ST_LineMerge(\n" 1348"ST_GeomFromText('MULTILINESTRING((-29 -27,-30 -29.7,-36 -31,-45 -33),(-45.2 " 1349"-33.2,-46 -32))')\n" 1350")\n" 1351");\n" 1352"st_astext\n" 1353"----------------\n" 1354"MULTILINESTRING((-45.2 -33.2,-46 -32),(-29 -27,-30 -29.7,-36 -31,-45 -33))" 1355 1356#. Tag: para 1357#: reference_editor.xml:676 1358#, no-c-format 1359msgid ", <xref linkend=\"ST_LineSubstring\"/>" 1360msgstr ", <xref linkend=\"ST_LineSubstring\"/>" 1361 1362#. Tag: refname 1363#: reference_editor.xml:682 1364#, no-c-format 1365msgid "ST_Multi" 1366msgstr "ST_Multi" 1367 1368#. Tag: refpurpose 1369#: reference_editor.xml:684 1370#, no-c-format 1371msgid "Return the geometry as a MULTI* geometry." 1372msgstr "Devuelve la geometría como una geometría MULTI*." 1373 1374#. Tag: funcprototype 1375#: reference_editor.xml:689 1376#, no-c-format 1377msgid "" 1378"<funcdef>geometry <function>ST_Multi</function></funcdef> " 1379"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 1380msgstr "" 1381"<funcdef>geometry <function>ST_Multi</function></funcdef> " 1382"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 1383 1384#. Tag: para 1385#: reference_editor.xml:699 1386#, no-c-format 1387msgid "" 1388"Returns the geometry as a MULTI* geometry. If the geometry is already a " 1389"MULTI*, it is returned unchanged." 1390msgstr "" 1391"Devuelve la geometría como una geometría MULTI*. Si la geometría ya es " 1392"MULTI*, esta se devuelve sin cambios." 1393 1394#. Tag: programlisting 1395#: reference_editor.xml:707 1396#, no-c-format 1397msgid "" 1398"SELECT ST_AsText(ST_Multi(ST_GeomFromText('POLYGON((743238 2967416,743238 " 1399"2967450,\n" 1400" 743265 2967450,743265.625 2967416,743238 " 1401"2967416))')));\n" 1402" st_astext\n" 1403" --------------------------------------------------------------------------------------------------\n" 1404" MULTIPOLYGON(((743238 2967416,743238 2967450,743265 " 1405"2967450,743265.625 2967416,\n" 1406" 743238 2967416)))\n" 1407" (1 row)" 1408msgstr "" 1409"SELECT ST_AsText(ST_Multi(ST_GeomFromText('POLYGON((743238 2967416,743238 " 1410"2967450,\n" 1411" 743265 2967450,743265.625 2967416,743238 " 1412"2967416))')));\n" 1413" st_astext\n" 1414" --------------------------------------------------------------------------------------------------\n" 1415" MULTIPOLYGON(((743238 2967416,743238 2967450,743265 " 1416"2967450,743265.625 2967416,\n" 1417" 743238 2967416)))\n" 1418" (1 row)" 1419 1420#. Tag: refname 1421#: reference_editor.xml:717 1422#, no-c-format 1423msgid "ST_Normalize" 1424msgstr "ST_Normalize" 1425 1426#. Tag: refpurpose 1427#: reference_editor.xml:719 1428#, no-c-format 1429msgid "Return the geometry in its canonical form." 1430msgstr "Devuelve la geometría en su forma canónica." 1431 1432#. Tag: funcprototype 1433#: reference_editor.xml:724 1434#, no-c-format 1435msgid "" 1436"<funcdef>geometry <function>ST_Normalize</function></funcdef> " 1437"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 1438msgstr "" 1439"<funcdef>geometry <function>ST_Normalize</function></funcdef> " 1440"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef>" 1441 1442#. Tag: para 1443#: reference_editor.xml:734 1444#, no-c-format 1445msgid "" 1446"Returns the geometry in its normalized/canonical form. May reorder vertices " 1447"in polygon rings, rings in a polygon, elements in a multi-geometry complex." 1448msgstr "" 1449"Devuelve la geometría en su forma normalizada/canónica. Puede reordenar " 1450"vértices en anillos poligonales, anillos en un polígono, elementos en un " 1451"complejo de geometría múltiple." 1452 1453#. Tag: para 1454#: reference_editor.xml:740 1455#, no-c-format 1456msgid "" 1457"Mostly only useful for testing purposes (comparing expected and obtained " 1458"results)." 1459msgstr "" 1460"Principalmente útil sólo para propósitos de prueba (comparando los " 1461"resultados esperados y los obtenidos)." 1462 1463#. Tag: para 1464#: reference_editor.xml:745 1465#, no-c-format 1466msgid "Availability: 2.3.0" 1467msgstr "Disponibilidad: 2.3.0" 1468 1469#. Tag: programlisting 1470#: reference_editor.xml:752 1471#, no-c-format 1472msgid "" 1473"SELECT ST_AsText(ST_Normalize(ST_GeomFromText(\n" 1474" 'GEOMETRYCOLLECTION(\n" 1475" POINT(2 3),\n" 1476" MULTILINESTRING((0 0, 1 1),(2 2, 3 3)),\n" 1477" POLYGON(\n" 1478" (0 10,0 0,10 0,10 10,0 10),\n" 1479" (4 2,2 2,2 4,4 4,4 2),\n" 1480" (6 8,8 8,8 6,6 6,6 8)\n" 1481" )\n" 1482" )'\n" 1483")));\n" 1484" st_astext\n" 1485"----------------------------------------------------------------------------------------------------------------------------------------------------\n" 1486" GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(6 6,8 6,8 8,6 8,6 6)," 1487"(2 2,4 2,4 4,2 4,2 2)),MULTILINESTRING((2 2,3 3),(0 0,1 1)),POINT(2 3))\n" 1488"(1 row)" 1489msgstr "" 1490"SELECT ST_AsText(ST_Normalize(ST_GeomFromText(\n" 1491" 'GEOMETRYCOLLECTION(\n" 1492" POINT(2 3),\n" 1493" MULTILINESTRING((0 0, 1 1),(2 2, 3 3)),\n" 1494" POLYGON(\n" 1495" (0 10,0 0,10 0,10 10,0 10),\n" 1496" (4 2,2 2,2 4,4 4,4 2),\n" 1497" (6 8,8 8,8 6,6 6,6 8)\n" 1498" )\n" 1499" )'\n" 1500")));\n" 1501" st_astext\n" 1502"----------------------------------------------------------------------------------------------------------------------------------------------------\n" 1503" GEOMETRYCOLLECTION(POLYGON((0 0,0 10,10 10,10 0,0 0),(6 6,8 6,8 8,6 8,6 6)," 1504"(2 2,4 2,4 4,2 4,2 2)),MULTILINESTRING((2 2,3 3),(0 0,1 1)),POINT(2 3))\n" 1505"(1 row)" 1506 1507#. Tag: para 1508#: reference_editor.xml:756 1509#, no-c-format 1510msgid "<para>,</para>" 1511msgstr "<para>,</para>" 1512 1513#. Tag: refname 1514#: reference_editor.xml:764 1515#, no-c-format 1516msgid "ST_QuantizeCoordinates" 1517msgstr "" 1518 1519#. Tag: refpurpose 1520#: reference_editor.xml:767 1521#, no-c-format 1522msgid "Sets least significant bits of coordinates to zero" 1523msgstr "" 1524 1525#. Tag: funcprototype 1526#: reference_editor.xml:774 1527#, fuzzy, no-c-format 1528msgid "" 1529"<funcdef> geometry <function>ST_QuantizeCoordinates</function> </funcdef> " 1530"<paramdef> <type>geometry</type> <parameter>g</parameter> </paramdef> " 1531"<paramdef> <type>int</type> <parameter>prec_x</parameter> </paramdef> " 1532"<paramdef> <type>int</type> <parameter>prec_y</parameter> </paramdef> " 1533"<paramdef> <type>int</type> <parameter>prec_z</parameter> </paramdef> " 1534"<paramdef> <type>int</type> <parameter>prec_m</parameter> </paramdef>" 1535msgstr "" 1536"<funcdef>geometry <function>ST_TransScale</function></funcdef> " 1537"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 1538"<paramdef><type>float</type> <parameter>deltaX</parameter></paramdef> " 1539"<paramdef><type>float</type> <parameter>deltaY</parameter></paramdef> " 1540"<paramdef><type>float</type> <parameter>XFactor</parameter></paramdef> " 1541"<paramdef><type>float</type> <parameter>YFactor</parameter></paramdef>" 1542 1543#. Tag: para 1544#: reference_editor.xml:805 1545#, no-c-format 1546msgid "" 1547"<code>ST_QuantizeCoordinates</code> determines the number of bits (<code>N</" 1548"code>) required to represent a coordinate value with a specified number of " 1549"digits after the decimal point, and then sets all but the <code>N</code> " 1550"most significant bits to zero. The resulting coordinate value will still " 1551"round to the original value, but will have improved compressiblity. This can " 1552"result in a significant disk usage reduction provided that the geometry " 1553"column is using a <ulink url=\"https://www.postgresql.org/docs/current/" 1554"static/storage-toast.html#STORAGE-TOAST-ONDISK\"> compressible storage type</" 1555"ulink>. The function allows specification of a different number of digits " 1556"after the decimal point in each dimension; unspecified dimensions are " 1557"assumed to have the precsion of the <code>x</code> dimension. Negative " 1558"digits are interpreted to refer digits to the left of the decimal point, (i." 1559"e., <code>prec_x=-2</code> will preserve coordinate values to the nearest " 1560"100." 1561msgstr "" 1562 1563#. Tag: para 1564#: reference_editor.xml:823 1565#, no-c-format 1566msgid "" 1567"The coordinates produced by <code>ST_QuantizeCoordinates</code> are " 1568"independent of the geometry that contains those coordinates and the relative " 1569"position of those coordinates within the geometry. As a result, existing " 1570"topological relationships between geometries are unaffected by use of this " 1571"function. The function may produce invalid geometry when it is called with a " 1572"number of digits lower than the intrinsic precision of the geometry." 1573msgstr "" 1574 1575#. Tag: para 1576#: reference_editor.xml:832 1577#, fuzzy, no-c-format 1578msgid "Availability: 2.5.0" 1579msgstr "Disponibilidad: 2.2.0" 1580 1581#. Tag: title 1582#: reference_editor.xml:835 1583#, no-c-format 1584msgid "Technical Background" 1585msgstr "" 1586 1587#. Tag: para 1588#: reference_editor.xml:836 1589#, no-c-format 1590msgid "" 1591"PostGIS stores all coordinate values as double-precision floating point " 1592"integers, which can reliably represent 15 significant digits. However, " 1593"PostGIS may be used to manage data that intrinsically has fewer than 15 " 1594"significant digits. An example is TIGER data, which is provided as " 1595"geographic coordinates with six digits of precision after the decimal point " 1596"(thus requiring only nine significant digits of longitude and eight " 1597"significant digits of latitude.)" 1598msgstr "" 1599 1600#. Tag: para 1601#: reference_editor.xml:845 1602#, no-c-format 1603msgid "" 1604"When 15 significant digits are available, there are many possible " 1605"representations of a number with 9 significant digits. A double precision " 1606"floating point number uses 52 explicit bits to represent the significand " 1607"(mantissa) of the coordinate. Only 30 bits are needed to represent a " 1608"mantissa with 9 significant digits, leaving 22 insignificant bits; we can " 1609"set their value to anything we like and still end up with a number that " 1610"rounds to our input value. For example, the value 100.123456 can be " 1611"represented by the floating point numbers closest to 100.123456000000, " 1612"100.123456000001, and 100.123456432199. All are equally valid, in that " 1613"<code>ST_AsText(geom, 6)</code> will return the same result with any of " 1614"these inputs. As we can set these bits to any value, " 1615"<code>ST_QuantizeCoordinates</code> sets the 22 insignificant bits to zero. " 1616"For a long coordinate sequence this creates a pattern of blocks of " 1617"consecutive zeros that is compressed by PostgreSQL more effeciently." 1618msgstr "" 1619 1620#. Tag: para 1621#: reference_editor.xml:865 1622#, no-c-format 1623msgid "" 1624"Only the on-disk size of the geometry is potentially affected by " 1625"<code>ST_QuantizeCoordinates</code>. <xref linkend=\"ST_MemSize\"/>, which " 1626"reports the in-memory usage of the geometry, will return the the same value " 1627"regardless of the disk space used by a geometry." 1628msgstr "" 1629 1630#. Tag: programlisting 1631#: reference_editor.xml:877 1632#, no-c-format 1633msgid "" 1634"SELECT ST_AsText(ST_QuantizeCoordinates('POINT (100.123456 0)'::geometry, " 1635"4));\n" 1636"st_astext\n" 1637"-------------------------\n" 1638"POINT(100.123455047607 0)" 1639msgstr "" 1640 1641#. Tag: programlisting 1642#: reference_editor.xml:879 1643#, no-c-format 1644msgid "" 1645"WITH test AS (SELECT 'POINT (123.456789123456 123.456789123456)'::geometry " 1646"AS geom)\n" 1647"SELECT\n" 1648" digits,\n" 1649" encode(ST_QuantizeCoordinates(geom, digits), 'hex'),\n" 1650" ST_AsText(ST_QuantizeCoordinates(geom, digits))\n" 1651"FROM test, generate_series(15, -15, -1) AS digits;\n" 1652"\n" 1653"digits | encode | " 1654"st_astext\n" 1655"--------+--------------------------------------------" 1656"+------------------------------------------\n" 1657"15 | 01010000005f9a72083cdd5e405f9a72083cdd5e40 | " 1658"POINT(123.456789123456 123.456789123456)\n" 1659"14 | 01010000005f9a72083cdd5e405f9a72083cdd5e40 | " 1660"POINT(123.456789123456 123.456789123456)\n" 1661"13 | 01010000005f9a72083cdd5e405f9a72083cdd5e40 | " 1662"POINT(123.456789123456 123.456789123456)\n" 1663"12 | 01010000005c9a72083cdd5e405c9a72083cdd5e40 | " 1664"POINT(123.456789123456 123.456789123456)\n" 1665"11 | 0101000000409a72083cdd5e40409a72083cdd5e40 | " 1666"POINT(123.456789123456 123.456789123456)\n" 1667"10 | 0101000000009a72083cdd5e40009a72083cdd5e40 | " 1668"POINT(123.456789123455 123.456789123455)\n" 1669"9 | 0101000000009072083cdd5e40009072083cdd5e40 | " 1670"POINT(123.456789123418 123.456789123418)\n" 1671"8 | 0101000000008072083cdd5e40008072083cdd5e40 | POINT(123.45678912336 " 1672"123.45678912336)\n" 1673"7 | 0101000000000070083cdd5e40000070083cdd5e40 | " 1674"POINT(123.456789121032 123.456789121032)\n" 1675"6 | 0101000000000040083cdd5e40000040083cdd5e40 | " 1676"POINT(123.456789076328 123.456789076328)\n" 1677"5 | 0101000000000000083cdd5e40000000083cdd5e40 | " 1678"POINT(123.456789016724 123.456789016724)\n" 1679"4 | 0101000000000000003cdd5e40000000003cdd5e40 | " 1680"POINT(123.456787109375 123.456787109375)\n" 1681"3 | 0101000000000000003cdd5e40000000003cdd5e40 | " 1682"POINT(123.456787109375 123.456787109375)\n" 1683"2 | 01010000000000000038dd5e400000000038dd5e40 | POINT(123.45654296875 " 1684"123.45654296875)\n" 1685"1 | 01010000000000000000dd5e400000000000dd5e40 | POINT(123.453125 " 1686"123.453125)\n" 1687"0 | 01010000000000000000dc5e400000000000dc5e40 | POINT(123.4375 " 1688"123.4375)\n" 1689"-1 | 01010000000000000000c05e400000000000c05e40 | POINT(123 123)\n" 1690"-2 | 01010000000000000000005e400000000000005e40 | POINT(120 120)\n" 1691"-3 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1692"-4 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1693"-5 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1694"-6 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1695"-7 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1696"-8 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1697"-9 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1698"-10 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1699"-11 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1700"-12 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1701"-13 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1702"-14 | 010100000000000000000058400000000000005840 | POINT(96 96)\n" 1703"-15 | 010100000000000000000058400000000000005840 | POINT(96 96)" 1704msgstr "" 1705 1706#. Tag: refname 1707#: reference_editor.xml:894 1708#, no-c-format 1709msgid "ST_RemovePoint" 1710msgstr "ST_RemovePoint" 1711 1712#. Tag: refpurpose 1713#: reference_editor.xml:895 1714#, no-c-format 1715msgid "Remove point from a linestring." 1716msgstr "Eliminar el punto de una cadena de líneas." 1717 1718#. Tag: funcprototype 1719#: reference_editor.xml:899 1720#, no-c-format 1721msgid "" 1722"<funcdef>geometry <function>ST_RemovePoint</function></funcdef> " 1723"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 1724"<paramdef><type>integer</type> <parameter>offset</parameter></paramdef>" 1725msgstr "" 1726"<funcdef>geometry <function>ST_RemovePoint</function></funcdef> " 1727"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 1728"<paramdef><type>integer</type> <parameter>offset</parameter></paramdef>" 1729 1730#. Tag: para 1731#: reference_editor.xml:910 1732#, no-c-format 1733msgid "" 1734"Remove a point from a linestring, given its 0-based index. Useful for " 1735"turning a closed ring into an open line string" 1736msgstr "" 1737"Elimine un punto de una cadena de línea, dado su índice basado en 0. Útil " 1738"para convertir un anillo cerrado en una cadena de línea abierta" 1739 1740#. Tag: programlisting 1741#: reference_editor.xml:917 1742#, no-c-format 1743msgid "" 1744"--guarantee no LINESTRINGS are closed\n" 1745"--by removing the end point. The below assumes the_geom is of type " 1746"LINESTRING\n" 1747"UPDATE sometable\n" 1748" SET the_geom = ST_RemovePoint(the_geom, ST_NPoints(the_geom) - 1)\n" 1749" FROM sometable\n" 1750" WHERE ST_IsClosed(the_geom) = true;" 1751msgstr "" 1752"--garantiza que ningún LINESTRINGs está cerrado\n" 1753"--quitando el punto final. La siguiente asume que the_geom es de tipo " 1754"LINESTRING\n" 1755"UPDATE sometable\n" 1756" SET the_geom = ST_RemovePoint(the_geom, ST_NPoints(the_geom) - 1)\n" 1757" FROM sometable\n" 1758" WHERE ST_IsClosed(the_geom) = true;" 1759 1760#. Tag: para 1761#: reference_editor.xml:921 1762#, no-c-format 1763msgid ", <xref linkend=\"ST_NPoints\"/>, <xref linkend=\"ST_NumPoints\"/>" 1764msgstr ", <xref linkend=\"ST_NPoints\"/>, <xref linkend=\"ST_NumPoints\"/>" 1765 1766#. Tag: refname 1767#: reference_editor.xml:927 1768#, no-c-format 1769msgid "ST_Reverse" 1770msgstr "ST_Reverse" 1771 1772#. Tag: refpurpose 1773#: reference_editor.xml:928 1774#, no-c-format 1775msgid "Return the geometry with vertex order reversed." 1776msgstr "Devuelve la geometría con el orden de vértice invertido." 1777 1778#. Tag: funcprototype 1779#: reference_editor.xml:933 1780#, no-c-format 1781msgid "" 1782"<funcdef>geometry <function>ST_Reverse</function></funcdef> " 1783"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 1784msgstr "" 1785"<funcdef>geometry <function>ST_Reverse</function></funcdef> " 1786"<paramdef><type>geometry </type> <parameter>g1</parameter></paramdef>" 1787 1788#. Tag: para 1789#: reference_editor.xml:943 1790#, no-c-format 1791msgid "Can be used on any geometry and reverses the order of the vertexes." 1792msgstr "" 1793"Se puede utilizar en cualquier geometría e invierte el orden de los vértices." 1794 1795#. Tag: para 1796#: reference_editor.xml:945 1797#, no-c-format 1798msgid "Enhanced: 2.4.0 support for curves was introduced." 1799msgstr "Mejorada: 2.4.0 se introdujo el soporte para curvas." 1800 1801#. Tag: programlisting 1802#: reference_editor.xml:952 1803#, no-c-format 1804msgid "" 1805"SELECT ST_AsText(the_geom) as line, ST_AsText(ST_Reverse(the_geom)) As " 1806"reverseline\n" 1807"FROM\n" 1808"(SELECT ST_MakeLine(ST_MakePoint(1,2),\n" 1809" ST_MakePoint(1,10)) As the_geom) as foo;\n" 1810"--result\n" 1811" line | reverseline\n" 1812"---------------------+----------------------\n" 1813"LINESTRING(1 2,1 10) | LINESTRING(1 10,1 2)" 1814msgstr "" 1815"SELECT ST_AsText(the_geom) as line, ST_AsText(ST_Reverse(the_geom)) As " 1816"reverseline\n" 1817"FROM\n" 1818"(SELECT ST_MakeLine(ST_MakePoint(1,2),\n" 1819" ST_MakePoint(1,10)) As the_geom) as foo;\n" 1820"--result\n" 1821" line | reverseline\n" 1822"---------------------+----------------------\n" 1823"LINESTRING(1 2,1 10) | LINESTRING(1 10,1 2)" 1824 1825#. Tag: refname 1826#: reference_editor.xml:958 1827#, no-c-format 1828msgid "ST_Segmentize" 1829msgstr "ST_Segmentize" 1830 1831#. Tag: refpurpose 1832#: reference_editor.xml:960 1833#, no-c-format 1834msgid "" 1835"Return a modified geometry/geography having no segment longer than the given " 1836"distance." 1837msgstr "" 1838"Devuelve una geometry/geography modificada que no tenga un segmento mayor " 1839"que la distancia dada." 1840 1841#. Tag: funcsynopsis 1842#: reference_editor.xml:965 1843#, no-c-format 1844msgid "" 1845"<funcprototype> <funcdef>geometry <function>ST_Segmentize</function></" 1846"funcdef> <paramdef><type>geometry </type> <parameter>geom</parameter></" 1847"paramdef> <paramdef><type>float </type> <parameter>max_segment_length</" 1848"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geography " 1849"<function>ST_Segmentize</function></funcdef> <paramdef><type>geography </" 1850"type> <parameter>geog</parameter></paramdef> <paramdef><type>float </type> " 1851"<parameter>max_segment_length</parameter></paramdef> </funcprototype>" 1852msgstr "" 1853"<funcprototype> <funcdef>geometry <function>ST_Segmentize</function></" 1854"funcdef> <paramdef><type>geometry </type> <parameter>geom</parameter></" 1855"paramdef> <paramdef><type>float </type> <parameter>max_segment_length</" 1856"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geography " 1857"<function>ST_Segmentize</function></funcdef> <paramdef><type>geography </" 1858"type> <parameter>geog</parameter></paramdef> <paramdef><type>float </type> " 1859"<parameter>max_segment_length</parameter></paramdef> </funcprototype>" 1860 1861#. Tag: para 1862#: reference_editor.xml:982 1863#, no-c-format 1864msgid "" 1865"Returns a modified geometry having no segment longer than the given " 1866"<varname>max_segment_length</varname>. Distance computation is performed in " 1867"2d only. For geometry, length units are in units of spatial reference. For " 1868"geography, units are in meters." 1869msgstr "" 1870"Devuelve una geometría modificada que no tiene ningún segmento más largo que " 1871"el <varname>max_segment_length</varname>dado . El cálculo de distancia se " 1872"realiza en 2d solamente. Para geometry, las unidades de longitud están en " 1873"unidades de referencia espacial. Para geography, las unidades están en " 1874"metros." 1875 1876#. Tag: para 1877#: reference_editor.xml:985 1878#, no-c-format 1879msgid "Availability: 1.2.2" 1880msgstr "Disponibilidad: 1.2.2" 1881 1882#. Tag: para 1883#: reference_editor.xml:986 1884#, fuzzy, no-c-format 1885msgid "Enhanced: 3.0.0 Segmentize geometry now uses equal length segments" 1886msgstr "" 1887"Mejorada: 2.3.0 Segmentize geography ahora utiliza segmentos de igual " 1888"longitud" 1889 1890#. Tag: para 1891#: reference_editor.xml:987 1892#, no-c-format 1893msgid "Enhanced: 2.3.0 Segmentize geography now uses equal length segments" 1894msgstr "" 1895"Mejorada: 2.3.0 Segmentize geography ahora utiliza segmentos de igual " 1896"longitud" 1897 1898#. Tag: para 1899#: reference_editor.xml:988 1900#, no-c-format 1901msgid "Enhanced: 2.1.0 support for geography was introduced." 1902msgstr "Mejorada: 2.1.0 se introdujo el soporte para geography." 1903 1904#. Tag: para 1905#: reference_editor.xml:989 1906#, no-c-format 1907msgid "" 1908"Changed: 2.1.0 As a result of the introduction of geography support: The " 1909"construct <code>SELECT ST_Segmentize('LINESTRING(1 2, 3 4)',0.5);</code> " 1910"will result in ambiguous function error. You need to have properly typed " 1911"object e.g. a geometry/geography column, use ST_GeomFromText, " 1912"ST_GeogFromText or <code>SELECT ST_Segmentize('LINESTRING(1 2, 3 4)'::" 1913"geometry,0.5);</code>" 1914msgstr "" 1915"Cambiado: 2.1.0 como resultado de la introducción del soporte a geography: " 1916"la construcción <code>SELECT ST_Segmentize('LINESTRING(1 2, 3 4)',0.5);</" 1917"code> producirá un error de función ambigua. Debe tener un objeto " 1918"correctamente tecleado, por ejemplo, una columna geometry/geography, utilice " 1919"ST_GeomFromText, ST_GeogFromText o <code>SELECT ST_Segmentize('LINESTRING(1 " 1920"2, 3 4)'::geometry,0.5);</code>" 1921 1922#. Tag: para 1923#: reference_editor.xml:991 1924#, no-c-format 1925msgid "" 1926"This will only increase segments. It will not lengthen segments shorter than " 1927"max length" 1928msgstr "" 1929"Esto sólo aumentará los segmentos. No alargará segmentos más cortos que la " 1930"longitud máxima" 1931 1932#. Tag: programlisting 1933#: reference_editor.xml:998 1934#, no-c-format 1935msgid "" 1936"SELECT ST_AsText(ST_Segmentize(\n" 1937"ST_GeomFromText('MULTILINESTRING((-29 -27,-30 -29.7,-36 -31,-45 -33),(-45 " 1938"-33,-46 -32))')\n" 1939" ,5)\n" 1940");\n" 1941"st_astext\n" 1942"--------------------------------------------------------------------------------------------------\n" 1943"MULTILINESTRING((-29 -27,-30 -29.7,-34.886615700134 -30.758766735029,-36 " 1944"-31,\n" 1945"-40.8809353009198 -32.0846522890933,-45 -33),\n" 1946"(-45 -33,-46 -32))\n" 1947"(1 row)\n" 1948"\n" 1949"SELECT ST_AsText(ST_Segmentize(ST_GeomFromText('POLYGON((-29 28, -30 40, -29 " 1950"28))'),10));\n" 1951"st_astext\n" 1952"-----------------------\n" 1953"POLYGON((-29 28,-29.8304547985374 37.9654575824488,-30 40,-29.1695452014626 " 1954"30.0345424175512,-29 28))\n" 1955"(1 row)" 1956msgstr "" 1957"SELECT ST_AsText(ST_Segmentize(\n" 1958"ST_GeomFromText('MULTILINESTRING((-29 -27,-30 -29.7,-36 -31,-45 -33),(-45 " 1959"-33,-46 -32))')\n" 1960" ,5)\n" 1961");\n" 1962"st_astext\n" 1963"--------------------------------------------------------------------------------------------------\n" 1964"MULTILINESTRING((-29 -27,-30 -29.7,-34.886615700134 -30.758766735029,-36 " 1965"-31,\n" 1966"-40.8809353009198 -32.0846522890933,-45 -33),\n" 1967"(-45 -33,-46 -32))\n" 1968"(1 row)\n" 1969"\n" 1970"SELECT ST_AsText(ST_Segmentize(ST_GeomFromText('POLYGON((-29 28, -30 40, -29 " 1971"28))'),10));\n" 1972"st_astext\n" 1973"-----------------------\n" 1974"POLYGON((-29 28,-29.8304547985374 37.9654575824488,-30 40,-29.1695452014626 " 1975"30.0345424175512,-29 28))\n" 1976"(1 row)" 1977 1978#. Tag: refname 1979#: reference_editor.xml:1008 1980#, no-c-format 1981msgid "ST_SetPoint" 1982msgstr "ST_SetPoint" 1983 1984#. Tag: refpurpose 1985#: reference_editor.xml:1009 1986#, no-c-format 1987msgid "Replace point of a linestring with a given point." 1988msgstr "Reemplace el punto de una cadena de línea con un punto dado." 1989 1990#. Tag: funcprototype 1991#: reference_editor.xml:1013 1992#, no-c-format 1993msgid "" 1994"<funcdef>geometry <function>ST_SetPoint</function></funcdef> " 1995"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 1996"<paramdef><type>integer</type> <parameter>zerobasedposition</parameter></" 1997"paramdef> <paramdef><type>geometry</type> <parameter>point</parameter></" 1998"paramdef>" 1999msgstr "" 2000"<funcdef>geometry <function>ST_SetPoint</function></funcdef> " 2001"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef> " 2002"<paramdef><type>integer</type> <parameter>zerobasedposition</parameter></" 2003"paramdef> <paramdef><type>geometry</type> <parameter>point</parameter></" 2004"paramdef>" 2005 2006#. Tag: para 2007#: reference_editor.xml:1025 2008#, no-c-format 2009msgid "" 2010"Replace point N of linestring with given point. Index is 0-based.Negative " 2011"index are counted backwards, so that -1 is last point. This is especially " 2012"useful in triggers when trying to maintain relationship of joints when one " 2013"vertex moves." 2014msgstr "" 2015"Reemplace el punto N de una cadena de línea con el punto dado. El índice " 2016"comineza en 0. El índice negativo se cuenta hacia atrás, por lo que -1 es el " 2017"último punto. Esto es especialmente útil en los disparadores cuando se trata " 2018"de mantener la relación de las articulaciones cuando un vértice se mueve." 2019 2020#. Tag: para 2021#: reference_editor.xml:1029 2022#, no-c-format 2023msgid "Updated 2.3.0 : negative indexing" 2024msgstr "Actualizado 2.3.0: indexación negativa" 2025 2026#. Tag: programlisting 2027#: reference_editor.xml:1036 2028#, no-c-format 2029msgid "" 2030"--Change first point in line string from -1 3 to -1 1\n" 2031"SELECT ST_AsText(ST_SetPoint('LINESTRING(-1 2,-1 3)', 0, 'POINT(-1 1)'));\n" 2032" st_astext\n" 2033"-----------------------\n" 2034" LINESTRING(-1 1,-1 3)\n" 2035"\n" 2036"---Change last point in a line string (lets play with 3d linestring this " 2037"time)\n" 2038"SELECT ST_AsEWKT(ST_SetPoint(foo.the_geom, ST_NumPoints(foo.the_geom) - 1, " 2039"ST_GeomFromEWKT('POINT(-1 1 3)')))\n" 2040"FROM (SELECT ST_GeomFromEWKT('LINESTRING(-1 2 3,-1 3 4, 5 6 7)') As " 2041"the_geom) As foo;\n" 2042" st_asewkt\n" 2043"-----------------------\n" 2044"LINESTRING(-1 2 3,-1 3 4,-1 1 3)\n" 2045"\n" 2046"SELECT ST_AsText(ST_SetPoint(g, -3, p))\n" 2047"FROM ST_GEomFromText('LINESTRING(0 0, 1 1, 2 2, 3 3, 4 4)') AS g\n" 2048" , ST_PointN(g,1) as p;\n" 2049" st_astext\n" 2050"-----------------------\n" 2051"LINESTRING(0 0,1 1,0 0,3 3,4 4)" 2052msgstr "" 2053"--Cambiar el primer punto de la cadena de línea de -1 3 a -1 1\n" 2054"SELECT ST_AsText(ST_SetPoint('LINESTRING(-1 2,-1 3)', 0, 'POINT(-1 1)'));\n" 2055" st_astext\n" 2056"-----------------------\n" 2057" LINESTRING(-1 1,-1 3)\n" 2058"\n" 2059"---Cambiar el último punto de una cadena de líneas (permite jugar con cadena " 2060"de línea 3d esta vez)\n" 2061"SELECT ST_AsEWKT(ST_SetPoint(foo.the_geom, ST_NumPoints(foo.the_geom) - 1, " 2062"ST_GeomFromEWKT('POINT(-1 1 3)')))\n" 2063"FROM (SELECT ST_GeomFromEWKT('LINESTRING(-1 2 3,-1 3 4, 5 6 7)') As " 2064"the_geom) As foo;\n" 2065" st_asewkt\n" 2066"-----------------------\n" 2067"LINESTRING(-1 2 3,-1 3 4,-1 1 3)\n" 2068"\n" 2069"SELECT ST_AsText(ST_SetPoint(g, -3, p))\n" 2070"FROM ST_GEomFromText('LINESTRING(0 0, 1 1, 2 2, 3 3, 4 4)') AS g\n" 2071" , ST_PointN(g,1) as p;\n" 2072" st_astext\n" 2073"-----------------------\n" 2074"LINESTRING(0 0,1 1,0 0,3 3,4 4)" 2075 2076#. Tag: para 2077#: reference_editor.xml:1040 2078#, no-c-format 2079msgid "" 2080", <xref linkend=\"ST_NPoints\"/>, <xref linkend=\"ST_NumPoints\"/>, <xref " 2081"linkend=\"ST_PointN\"/>, <xref linkend=\"ST_RemovePoint\"/>" 2082msgstr "" 2083", <xref linkend=\"ST_NPoints\"/>, <xref linkend=\"ST_NumPoints\"/>, <xref " 2084"linkend=\"ST_PointN\"/>, <xref linkend=\"ST_RemovePoint\"/>" 2085 2086#. Tag: refname 2087#: reference_editor.xml:1046 2088#, no-c-format 2089msgid "ST_SnapToGrid" 2090msgstr "ST_SnapToGrid" 2091 2092#. Tag: refpurpose 2093#: reference_editor.xml:1048 2094#, no-c-format 2095msgid "Snap all points of the input geometry to a regular grid." 2096msgstr "" 2097"Ajusta todos los puntos de la geometría de entrada a una cuadrícula regular." 2098 2099#. Tag: funcsynopsis 2100#: reference_editor.xml:1054 2101#, no-c-format 2102msgid "" 2103"<funcprototype> <funcdef>geometry <function>ST_SnapToGrid</function></" 2104"funcdef> <paramdef><type>geometry </type> <parameter>geomA</parameter></" 2105"paramdef> <paramdef><type>float </type> <parameter>originX</parameter></" 2106"paramdef> <paramdef><type>float </type> <parameter>originY</parameter></" 2107"paramdef> <paramdef><type>float </type> <parameter>sizeX</parameter></" 2108"paramdef> <paramdef><type>float </type> <parameter>sizeY</parameter></" 2109"paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2110"<function>ST_SnapToGrid</function></funcdef> <paramdef><type>geometry </" 2111"type> <parameter>geomA</parameter></paramdef> <paramdef><type>float </type> " 2112"<parameter>sizeX</parameter></paramdef> <paramdef><type>float </type> " 2113"<parameter>sizeY</parameter></paramdef> </funcprototype> <funcprototype> " 2114"<funcdef>geometry <function>ST_SnapToGrid</function></funcdef> " 2115"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 2116"<paramdef><type>float </type> <parameter>size</parameter></paramdef> </" 2117"funcprototype> <funcprototype> <funcdef>geometry <function>ST_SnapToGrid</" 2118"function></funcdef> <paramdef><type>geometry </type> <parameter>geomA</" 2119"parameter></paramdef> <paramdef><type>geometry </type> " 2120"<parameter>pointOrigin</parameter></paramdef> <paramdef><type>float </type> " 2121"<parameter>sizeX</parameter></paramdef> <paramdef><type>float </type> " 2122"<parameter>sizeY</parameter></paramdef> <paramdef><type>float </type> " 2123"<parameter>sizeZ</parameter></paramdef> <paramdef><type>float </type> " 2124"<parameter>sizeM</parameter></paramdef> </funcprototype>" 2125msgstr "" 2126"<funcprototype> <funcdef>geometry <function>ST_SnapToGrid</function></" 2127"funcdef> <paramdef><type>geometry </type> <parameter>geomA</parameter></" 2128"paramdef> <paramdef><type>float </type> <parameter>originX</parameter></" 2129"paramdef> <paramdef><type>float </type> <parameter>originY</parameter></" 2130"paramdef> <paramdef><type>float </type> <parameter>sizeX</parameter></" 2131"paramdef> <paramdef><type>float </type> <parameter>sizeY</parameter></" 2132"paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2133"<function>ST_SnapToGrid</function></funcdef> <paramdef><type>geometry </" 2134"type> <parameter>geomA</parameter></paramdef> <paramdef><type>float </type> " 2135"<parameter>sizeX</parameter></paramdef> <paramdef><type>float </type> " 2136"<parameter>sizeY</parameter></paramdef> </funcprototype> <funcprototype> " 2137"<funcdef>geometry <function>ST_SnapToGrid</function></funcdef> " 2138"<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 2139"<paramdef><type>float </type> <parameter>size</parameter></paramdef> </" 2140"funcprototype> <funcprototype> <funcdef>geometry <function>ST_SnapToGrid</" 2141"function></funcdef> <paramdef><type>geometry </type> <parameter>geomA</" 2142"parameter></paramdef> <paramdef><type>geometry </type> " 2143"<parameter>pointOrigin</parameter></paramdef> <paramdef><type>float </type> " 2144"<parameter>sizeX</parameter></paramdef> <paramdef><type>float </type> " 2145"<parameter>sizeY</parameter></paramdef> <paramdef><type>float </type> " 2146"<parameter>sizeZ</parameter></paramdef> <paramdef><type>float </type> " 2147"<parameter>sizeM</parameter></paramdef> </funcprototype>" 2148 2149#. Tag: para 2150#: reference_editor.xml:1092 2151#, no-c-format 2152msgid "" 2153"Variant 1,2,3: Snap all points of the input geometry to the grid defined by " 2154"its origin and cell size. Remove consecutive points falling on the same " 2155"cell, eventually returning NULL if output points are not enough to define a " 2156"geometry of the given type. Collapsed geometries in a collection are " 2157"stripped from it. Useful for reducing precision." 2158msgstr "" 2159"Variante 1, 2, 3: ajusta todos los puntos de la geometría de entrada a la " 2160"cuadrícula definida por su origen y tamaño de celda. Elimina los puntos " 2161"consecutivos que caen en la misma celda, eventualmente devuelve NULL si los " 2162"puntos de salida no son suficientes para definir una geometría del tipo " 2163"dado. Las geometrías contraídas de una colección se despojan de ella. Útil " 2164"para reducir la precisión." 2165 2166#. Tag: para 2167#: reference_editor.xml:1100 2168#, no-c-format 2169msgid "" 2170"Variant 4: Introduced 1.1.0 - Snap all points of the input geometry to the " 2171"grid defined by its origin (the second argument, must be a point) and cell " 2172"sizes. Specify 0 as size for any dimension you don't want to snap to a grid." 2173msgstr "" 2174"Variante 4: introducido 1.1.0 - Ajusta todos los puntos de la geometría de " 2175"entrada a la cuadrícula definida por su origen (el segundo argumento, debe " 2176"ser un punto) y tamaños de celda. Especifique 0 como tamaño para cualquier " 2177"dimensión que no desee ajustar a una cuadrícula." 2178 2179#. Tag: para 2180#: reference_editor.xml:1106 2181#, no-c-format 2182msgid "" 2183"The returned geometry might lose its simplicity (see <xref linkend=" 2184"\"ST_IsSimple\"/>)." 2185msgstr "" 2186"La geometría devuelta podría perder su simplicidad (ver <xref linkend=" 2187"\"ST_IsSimple\"/>)." 2188 2189#. Tag: para 2190#: reference_editor.xml:1111 2191#, no-c-format 2192msgid "" 2193"Before release 1.1.0 this function always returned a 2d geometry. Starting " 2194"at 1.1.0 the returned geometry will have same dimensionality as the input " 2195"one with higher dimension values untouched. Use the version taking a second " 2196"geometry argument to define all grid dimensions." 2197msgstr "" 2198"Antes del lanzamiento 1.1.0 esta función siempre devolvió una geometría 2d. " 2199"A partir de 1.1.0 la geometría devuelta tendrá la misma dimensionalidad que " 2200"la entrada con valores de dimensión más altos sin tocar. Utilice la versión " 2201"que toma un segundo argumento de geometría para definir todas las " 2202"dimensiones de cuadrícula." 2203 2204#. Tag: para 2205#: reference_editor.xml:1118 2206#, no-c-format 2207msgid "Availability: 1.0.0RC1" 2208msgstr "Disponibilidad: 1.0.0RC1" 2209 2210#. Tag: para 2211#: reference_editor.xml:1119 2212#, no-c-format 2213msgid "Availability: 1.1.0 - Z and M support" 2214msgstr "Disponibilidad: 1.1.0 - soporte de Z y M" 2215 2216#. Tag: programlisting 2217#: reference_editor.xml:1128 2218#, no-c-format 2219msgid "" 2220"--Snap your geometries to a precision grid of 10^-3\n" 2221"UPDATE mytable\n" 2222" SET the_geom = ST_SnapToGrid(the_geom, 0.001);\n" 2223"\n" 2224"SELECT ST_AsText(ST_SnapToGrid(\n" 2225" ST_GeomFromText('LINESTRING(1.1115678 2.123, " 2226"4.111111 3.2374897, 4.11112 3.23748667)'),\n" 2227" 0.001)\n" 2228" );\n" 2229" st_astext\n" 2230"-------------------------------------\n" 2231" LINESTRING(1.112 2.123,4.111 3.237)\n" 2232" --Snap a 4d geometry\n" 2233"SELECT ST_AsEWKT(ST_SnapToGrid(\n" 2234" ST_GeomFromEWKT('LINESTRING(-1.1115678 2.123 2.3456 1.11111,\n" 2235" 4.111111 3.2374897 3.1234 1.1111, -1.11111112 2.123 2.3456 " 2236"1.1111112)'),\n" 2237" ST_GeomFromEWKT('POINT(1.12 2.22 3.2 4.4444)'),\n" 2238" 0.1, 0.1, 0.1, 0.01) );\n" 2239" st_asewkt\n" 2240"------------------------------------------------------------------------------\n" 2241" LINESTRING(-1.08 2.12 2.3 1.1144,4.12 3.22 3.1 1.1144,-1.08 2.12 2.3 " 2242"1.1144)\n" 2243"\n" 2244"\n" 2245"--With a 4d geometry - the ST_SnapToGrid(geom,size) only touches x and y " 2246"coords but keeps m and z the same\n" 2247"SELECT ST_AsEWKT(ST_SnapToGrid(ST_GeomFromEWKT('LINESTRING(-1.1115678 2.123 " 2248"3 2.3456,\n" 2249" 4.111111 3.2374897 3.1234 1.1111)'),\n" 2250" 0.01) );\n" 2251" st_asewkt\n" 2252"---------------------------------------------------------\n" 2253" LINESTRING(-1.11 2.12 3 2.3456,4.11 3.24 3.1234 1.1111)" 2254msgstr "" 2255"--Ajustar las geometrías a una cuadrícula de precisión 10^-3\n" 2256"UPDATE mytable\n" 2257" SET the_geom = ST_SnapToGrid(the_geom, 0.001);\n" 2258"\n" 2259"SELECT ST_AsText(ST_SnapToGrid(\n" 2260" ST_GeomFromText('LINESTRING(1.1115678 2.123, " 2261"4.111111 3.2374897, 4.11112 3.23748667)'),\n" 2262" 0.001)\n" 2263" );\n" 2264" st_astext\n" 2265"-------------------------------------\n" 2266" LINESTRING(1.112 2.123,4.111 3.237)\n" 2267" --Ajustar una geometría 4d\n" 2268"SELECT ST_AsEWKT(ST_SnapToGrid(\n" 2269" ST_GeomFromEWKT('LINESTRING(-1.1115678 2.123 2.3456 1.11111,\n" 2270" 4.111111 3.2374897 3.1234 1.1111, -1.11111112 2.123 2.3456 " 2271"1.1111112)'),\n" 2272" ST_GeomFromEWKT('POINT(1.12 2.22 3.2 4.4444)'),\n" 2273" 0.1, 0.1, 0.1, 0.01) );\n" 2274" st_asewkt\n" 2275"------------------------------------------------------------------------------\n" 2276" LINESTRING(-1.08 2.12 2.3 1.1144,4.12 3.22 3.1 1.1144,-1.08 2.12 2.3 " 2277"1.1144)\n" 2278"\n" 2279"\n" 2280"--Con una geometría 4d - ST_SnapToGrid (geom,size) sólo toca las coordenadas " 2281"x e y, pero mantiene el mismo m y z\n" 2282"SELECT ST_AsEWKT(ST_SnapToGrid(ST_GeomFromEWKT('LINESTRING(-1.1115678 2.123 " 2283"3 2.3456,\n" 2284" 4.111111 3.2374897 3.1234 1.1111)'),\n" 2285" 0.01) );\n" 2286" st_asewkt\n" 2287"---------------------------------------------------------\n" 2288" LINESTRING(-1.11 2.12 3 2.3456,4.11 3.24 3.1234 1.1111)" 2289 2290#. Tag: para 2291#: reference_editor.xml:1135 2292#, no-c-format 2293msgid "" 2294", <xref linkend=\"ST_AsEWKT\"/>, <xref linkend=\"ST_AsText\"/>, <xref " 2295"linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>, <xref " 2296"linkend=\"ST_Simplify\"/>" 2297msgstr "" 2298", <xref linkend=\"ST_AsEWKT\"/>, <xref linkend=\"ST_AsText\"/>, <xref " 2299"linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>, <xref " 2300"linkend=\"ST_Simplify\"/>" 2301 2302#. Tag: refname 2303#: reference_editor.xml:1148 2304#, no-c-format 2305msgid "ST_Snap" 2306msgstr "ST_Snap" 2307 2308#. Tag: refpurpose 2309#: reference_editor.xml:1150 2310#, no-c-format 2311msgid "" 2312"Snap segments and vertices of input geometry to vertices of a reference " 2313"geometry." 2314msgstr "" 2315"Ajusta segmentos y vértices de la geometría de entrada a vértices de una " 2316"geometría de referencia." 2317 2318#. Tag: funcprototype 2319#: reference_editor.xml:1158 2320#, no-c-format 2321msgid "" 2322"<funcdef>geometry <function>ST_Snap</function></funcdef> " 2323"<paramdef><type>geometry </type> <parameter>input</parameter></paramdef> " 2324"<paramdef><type>geometry </type> <parameter>reference</parameter></paramdef> " 2325"<paramdef><type>float </type> <parameter>tolerance</parameter></paramdef>" 2326msgstr "" 2327"<funcdef>geometry <function>ST_Snap</function></funcdef> " 2328"<paramdef><type>geometry </type> <parameter>input</parameter></paramdef> " 2329"<paramdef><type>geometry </type> <parameter>reference</parameter></paramdef> " 2330"<paramdef><type>float </type> <parameter>tolerance</parameter></paramdef>" 2331 2332#. Tag: para 2333#: reference_editor.xml:1170 2334#, fuzzy, no-c-format 2335msgid "" 2336"Snaps the vertices and segments of a geometry to another Geometry's " 2337"vertices. A snap distance tolerance is used to control where snapping is " 2338"performed. The result geometry is the input geometry with the vertices " 2339"snapped. If no snapping occurs then the input geometry is returned unchanged." 2340msgstr "" 2341"Ajusta los vértices y segmentos de una geometría a los vértices de otra " 2342"geometría. Se utiliza una tolerancia de la distancia de ajuste para " 2343"controlar dónde se realiza el ajuste. La geometría resultante es la " 2344"geometría de entrada con los vértices ajustados. Si no se produce un ajuste, " 2345"la geometría de entrada se devuelve sin cambios." 2346 2347#. Tag: para 2348#: reference_editor.xml:1177 2349#, no-c-format 2350msgid "" 2351"Snapping one geometry to another can improve robustness for overlay " 2352"operations by eliminating nearly-coincident edges (which cause problems " 2353"during noding and intersection calculation)." 2354msgstr "" 2355"El ajustar una geometría a otra puede mejorar la robustez de las operaciones " 2356"de superposición eliminando los bordes casi coincidentes (que causan " 2357"problemas durante el cálculo de noding y de intersección)." 2358 2359#. Tag: para 2360#: reference_editor.xml:1184 2361#, no-c-format 2362msgid "" 2363"Too much snapping can result in invalid topology being created, so the " 2364"number and location of snapped vertices is decided using heuristics to " 2365"determine when it is safe to snap. This can result in some potential snaps " 2366"being omitted, however." 2367msgstr "" 2368"Un ajuste excesivo puede resultar en la creación de una topología no válida, " 2369"por lo que el número y la ubicación de los vértices ajustados se deciden " 2370"usando heurísticas para determinar cuándo es seguro ajustar. Sin embargo, " 2371"esto puede resultar en que algunos potenciales ajustes se omitan." 2372 2373#. Tag: para 2374#: reference_editor.xml:1193 2375#, no-c-format 2376msgid "" 2377"The returned geometry might lose its simplicity (see <xref linkend=" 2378"\"ST_IsSimple\"/>) and validity (see <xref linkend=\"ST_IsValid\"/>)." 2379msgstr "" 2380"La geometría devuelta puede perder su simplicidad (ver <xref linkend=" 2381"\"ST_IsSimple\"/>) y su validez (ver <xref linkend=\"ST_IsValid\"/>)." 2382 2383#. Tag: para 2384#: reference_editor.xml:1217 2385#, no-c-format 2386msgid "A multipolygon shown with a linestring (before any snapping)" 2387msgstr "" 2388"Un multipolígono mostrado con una cadena de líneas (antes de cualquier " 2389"ajuste)" 2390 2391#. Tag: para 2392#: reference_editor.xml:1228 2393#, no-c-format 2394msgid "" 2395"A multipolygon snapped to linestring to tolerance: 1.01 of distance. The new " 2396"multipolygon is shown with reference linestring" 2397msgstr "" 2398"Un multipolígono se ajustó a una cadena de línea a la tolerancia: 1,01 de " 2399"distancia. El nuevo multipolígono se muestra en referencia a la cadena de " 2400"línea" 2401 2402#. Tag: programlisting 2403#: reference_editor.xml:1232 2404#, fuzzy, no-c-format 2405msgid "" 2406"SELECT ST_AsText(ST_Snap(poly,line, ST_Distance(poly,line)*1.01)) AS " 2407"polysnapped\n" 2408"FROM (SELECT\n" 2409" ST_GeomFromText('MULTIPOLYGON(\n" 2410" ((26 125, 26 200, 126 200, 126 125, 26 125 ),\n" 2411" ( 51 150, 101 150, 76 175, 51 150 )),\n" 2412" (( 151 100, 151 200, 176 175, 151 100 )))') As poly,\n" 2413" ST_GeomFromText('LINESTRING (5 107, 54 84, 101 100)') As line\n" 2414" ) As foo;\n" 2415"\n" 2416" polysnapped\n" 2417"---------------------------------------------------------------------\n" 2418" MULTIPOLYGON(((26 125,26 200,126 200,126 125,101 100,26 125),\n" 2419" (51 150,101 150,76 175,51 150)),((151 100,151 200,176 175,151 100)))" 2420msgstr "" 2421"SELECT ST_AsText(ST_Snap(poly,line, ST_Distance(poly,line)*1.01)) AS " 2422"polysnapped\n" 2423"FROM (SELECT\n" 2424" ST_GeomFromText('MULTIPOLYGON(\n" 2425" ((26 125, 26 200, 126 200, 126 125, 26 125 ),\n" 2426" ( 51 150, 101 150, 76 175, 51 150 )),\n" 2427" (( 151 100, 151 200, 176 175, 151 100 )))') As poly,\n" 2428" ST_GeomFromText('LINESTRING (5 107, 54 84, 101 100)') As line\n" 2429"\n" 2430" ) As foo;\n" 2431"\n" 2432" polysnapped\n" 2433"---------------------------------------------------------------------\n" 2434" MULTIPOLYGON(((26 125,26 200,126 200,126 125,101 100,26 125),\n" 2435" (51 150,101 150,76 175,51 150)),((151 100,151 200,176 175,151 100)))" 2436 2437#. Tag: para 2438#: reference_editor.xml:1239 2439#, no-c-format 2440msgid "" 2441"A multipolygon snapped to linestring to tolerance: 1.25 of distance. The new " 2442"multipolygon is shown with reference linestring" 2443msgstr "" 2444"Un multipolígono se ajustó a una cadena de línea a la tolerancia: 1,25 de " 2445"distancia. El nuevo multipolígono se muestra en referencia a la cadena de " 2446"línea" 2447 2448#. Tag: programlisting 2449#: reference_editor.xml:1243 2450#, fuzzy, no-c-format 2451msgid "" 2452"SELECT ST_AsText(\n" 2453" ST_Snap(poly,line, ST_Distance(poly,line)*1.25)\n" 2454" ) AS polysnapped\n" 2455"FROM (SELECT\n" 2456" ST_GeomFromText('MULTIPOLYGON(\n" 2457" (( 26 125, 26 200, 126 200, 126 125, 26 125 ),\n" 2458" ( 51 150, 101 150, 76 175, 51 150 )),\n" 2459" (( 151 100, 151 200, 176 175, 151 100 )))') As poly,\n" 2460" ST_GeomFromText('LINESTRING (5 107, 54 84, 101 100)') As line\n" 2461" ) As foo;\n" 2462"\n" 2463" polysnapped\n" 2464"---------------------------------------------------------------------\n" 2465"MULTIPOLYGON(((5 107,26 200,126 200,126 125,101 100,54 84,5 107),\n" 2466"(51 150,101 150,76 175,51 150)),((151 100,151 200,176 175,151 100)))" 2467msgstr "" 2468"SELECT ST_AsText(\n" 2469" ST_Snap(poly,line, ST_Distance(poly,line)*1.25)\n" 2470" ) AS polysnapped\n" 2471"FROM (SELECT\n" 2472" ST_GeomFromText('MULTIPOLYGON(\n" 2473" (( 26 125, 26 200, 126 200, 126 125, 26 125 ),\n" 2474" ( 51 150, 101 150, 76 175, 51 150 )),\n" 2475" (( 151 100, 151 200, 176 175, 151 100 )))') As poly,\n" 2476" ST_GeomFromText('LINESTRING (5 107, 54 84, 101 100)') As line\n" 2477"\n" 2478" ) As foo;\n" 2479"\n" 2480" polysnapped\n" 2481"---------------------------------------------------------------------\n" 2482"MULTIPOLYGON(((5 107,26 200,126 200,126 125,101 100,54 84,5 107),\n" 2483"(51 150,101 150,76 175,51 150)),((151 100,151 200,176 175,151 100)))" 2484 2485#. Tag: para 2486#: reference_editor.xml:1252 2487#, no-c-format 2488msgid "" 2489"The linestring snapped to the original multipolygon at tolerance 1.01 of " 2490"distance. The new linestring is shown with reference multipolygon" 2491msgstr "" 2492"La cadena de línea se ajustó al multipolígono original a la tolerancia 1,01 " 2493"de distancia. La nueva cadena de línea se muestra con referencia al " 2494"multipolígono" 2495 2496#. Tag: programlisting 2497#: reference_editor.xml:1256 2498#, no-c-format 2499msgid "" 2500"SELECT ST_AsText(\n" 2501" ST_Snap(line, poly, ST_Distance(poly,line)*1.01)\n" 2502" ) AS linesnapped\n" 2503"FROM (SELECT\n" 2504" ST_GeomFromText('MULTIPOLYGON(\n" 2505" ((26 125, 26 200, 126 200, 126 125, 26 125),\n" 2506" (51 150, 101 150, 76 175, 51 150 )),\n" 2507" ((151 100, 151 200, 176 175, 151 100)))') As poly,\n" 2508" ST_GeomFromText('LINESTRING (5 107, 54 84, 101 100)') As line\n" 2509" ) As foo;\n" 2510"\n" 2511" linesnapped\n" 2512"----------------------------------------\n" 2513" LINESTRING(5 107,26 125,54 84,101 100)" 2514msgstr "" 2515"SELECT ST_AsText(\n" 2516" ST_Snap(line, poly, ST_Distance(poly,line)*1.01)\n" 2517" ) AS linesnapped\n" 2518"FROM (SELECT\n" 2519" ST_GeomFromText('MULTIPOLYGON(\n" 2520" ((26 125, 26 200, 126 200, 126 125, 26 125),\n" 2521" (51 150, 101 150, 76 175, 51 150 )),\n" 2522" ((151 100, 151 200, 176 175, 151 100)))') As poly,\n" 2523" ST_GeomFromText('LINESTRING (5 107, 54 84, 101 100)') As line\n" 2524" ) As foo;\n" 2525"\n" 2526" linesnapped\n" 2527"----------------------------------------\n" 2528" LINESTRING(5 107,26 125,54 84,101 100)" 2529 2530#. Tag: para 2531#: reference_editor.xml:1264 2532#, no-c-format 2533msgid "" 2534"The linestring snapped to the original multipolygon at tolerance 1.25 of " 2535"distance. The new linestring is shown with reference multipolygon" 2536msgstr "" 2537"La cadena de línea se ajustó al multipolígono original a la tolerancia 1,25 " 2538"de distancia. La nueva cadena de línea se muestra con referencia al " 2539"multipolígono" 2540 2541#. Tag: programlisting 2542#: reference_editor.xml:1268 2543#, no-c-format 2544msgid "" 2545"SELECT ST_AsText(\n" 2546" ST_Snap(line, poly, ST_Distance(poly,line)*1.25)\n" 2547" ) AS linesnapped\n" 2548"FROM (SELECT\n" 2549" ST_GeomFromText('MULTIPOLYGON(\n" 2550" (( 26 125, 26 200, 126 200, 126 125, 26 125 ),\n" 2551" (51 150, 101 150, 76 175, 51 150 )),\n" 2552" ((151 100, 151 200, 176 175, 151 100 )))') As poly,\n" 2553" ST_GeomFromText('LINESTRING (5 107, 54 84, 101 100)') As line\n" 2554" ) As foo;\n" 2555" linesnapped\n" 2556"---------------------------------------\n" 2557"LINESTRING(26 125,54 84,101 100)" 2558msgstr "" 2559"SELECT ST_AsText(\n" 2560" ST_Snap(line, poly, ST_Distance(poly,line)*1.25)\n" 2561" ) AS linesnapped\n" 2562"FROM (SELECT\n" 2563" ST_GeomFromText('MULTIPOLYGON(\n" 2564" (( 26 125, 26 200, 126 200, 126 125, 26 125 ),\n" 2565" (51 150, 101 150, 76 175, 51 150 )),\n" 2566" ((151 100, 151 200, 176 175, 151 100 )))') As poly,\n" 2567" ST_GeomFromText('LINESTRING (5 107, 54 84, 101 100)') As line\n" 2568" ) As foo;\n" 2569" linesnapped\n" 2570"---------------------------------------\n" 2571"LINESTRING(26 125,54 84,101 100)" 2572 2573#. Tag: refname 2574#: reference_editor.xml:1289 2575#, no-c-format 2576msgid "ST_SwapOrdinates" 2577msgstr "" 2578 2579#. Tag: refpurpose 2580#: reference_editor.xml:1290 2581#, fuzzy, no-c-format 2582msgid "" 2583"Returns a version of the given geometry with given ordinate values swapped." 2584msgstr "Devuelve la geometría con el orden de vértice invertido." 2585 2586#. Tag: funcprototype 2587#: reference_editor.xml:1297 2588#, fuzzy, no-c-format 2589msgid "" 2590"<funcdef>geometry <function>ST_SwapOrdinates</function></funcdef> " 2591"<paramdef><type>geometry</type> <parameter>geom</parameter></paramdef> " 2592"<paramdef><type>cstring</type> <parameter>ords</parameter></paramdef>" 2593msgstr "" 2594"<funcdef>geometry <function>ST_SetSRID</function></funcdef> " 2595"<paramdef><type>geometry </type> <parameter>geom</parameter></paramdef> " 2596"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef>" 2597 2598#. Tag: para 2599#: reference_editor.xml:1307 2600#, fuzzy, no-c-format 2601msgid "Returns a version of the given geometry with given ordinates swapped." 2602msgstr "Devuelve la geometría con el orden de vértice invertido." 2603 2604#. Tag: para 2605#: reference_editor.xml:1310 2606#, no-c-format 2607msgid "" 2608"The <varname>ords</varname> parameter is a 2-characters string naming the " 2609"ordinates to swap. Valid names are: x,y,z and m." 2610msgstr "" 2611 2612#. Tag: title 2613#: reference_editor.xml:1323 2614#, fuzzy, no-c-format 2615msgid "Example" 2616msgstr "Ejemplos" 2617 2618#. Tag: programlisting 2619#: reference_editor.xml:1324 2620#, no-c-format 2621msgid "" 2622"<![CDATA[\n" 2623"-- Scale M value by 2\n" 2624"SELECT ST_AsText(\n" 2625" ST_SwapOrdinates(\n" 2626" ST_Scale(\n" 2627" ST_SwapOrdinates(g,'xm'),\n" 2628" 2, 1\n" 2629" ),\n" 2630" 'xm')\n" 2631") FROM ( SELECT 'POINT ZM (0 0 0 2)'::geometry g ) foo;\n" 2632" st_astext\n" 2633"--------------------\n" 2634" POINT ZM (0 0 0 4)\n" 2635" ]]>" 2636msgstr "" 2637 2638#~ msgid "ST_Affine" 2639#~ msgstr "ST_Affine" 2640 2641#~ msgid "Apply a 3d affine transformation to a geometry." 2642#~ msgstr "Aplicar una transformación de afinidad 3D a una geometría." 2643 2644#~ msgid "" 2645#~ "<funcprototype> <funcdef>geometry <function>ST_Affine</function></" 2646#~ "funcdef> <paramdef><type>geometry </type> <parameter>geomA</parameter></" 2647#~ "paramdef> <paramdef><type>float </type> <parameter>a</parameter></" 2648#~ "paramdef> <paramdef><type>float </type> <parameter>b</parameter></" 2649#~ "paramdef> <paramdef><type>float </type> <parameter>c</parameter></" 2650#~ "paramdef> <paramdef><type>float </type> <parameter>d</parameter></" 2651#~ "paramdef> <paramdef><type>float </type> <parameter>e</parameter></" 2652#~ "paramdef> <paramdef><type>float </type> <parameter>f</parameter></" 2653#~ "paramdef> <paramdef><type>float </type> <parameter>g</parameter></" 2654#~ "paramdef> <paramdef><type>float </type> <parameter>h</parameter></" 2655#~ "paramdef> <paramdef><type>float </type> <parameter>i</parameter></" 2656#~ "paramdef> <paramdef><type>float </type> <parameter>xoff</parameter></" 2657#~ "paramdef> <paramdef><type>float </type> <parameter>yoff</parameter></" 2658#~ "paramdef> <paramdef><type>float </type> <parameter>zoff</parameter></" 2659#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2660#~ "<function>ST_Affine</function></funcdef> <paramdef><type>geometry </type> " 2661#~ "<parameter>geomA</parameter></paramdef> <paramdef><type>float </type> " 2662#~ "<parameter>a</parameter></paramdef> <paramdef><type>float </type> " 2663#~ "<parameter>b</parameter></paramdef> <paramdef><type>float </type> " 2664#~ "<parameter>d</parameter></paramdef> <paramdef><type>float </type> " 2665#~ "<parameter>e</parameter></paramdef> <paramdef><type>float </type> " 2666#~ "<parameter>xoff</parameter></paramdef> <paramdef><type>float </type> " 2667#~ "<parameter>yoff</parameter></paramdef> </funcprototype>" 2668#~ msgstr "" 2669#~ "<funcprototype> <funcdef>geometry <function>ST_Affine</function></" 2670#~ "funcdef> <paramdef><type>geometry </type> <parameter>geomA</parameter></" 2671#~ "paramdef> <paramdef><type>float </type> <parameter>a</parameter></" 2672#~ "paramdef> <paramdef><type>float </type> <parameter>b</parameter></" 2673#~ "paramdef> <paramdef><type>float </type> <parameter>c</parameter></" 2674#~ "paramdef> <paramdef><type>float </type> <parameter>d</parameter></" 2675#~ "paramdef> <paramdef><type>float </type> <parameter>e</parameter></" 2676#~ "paramdef> <paramdef><type>float </type> <parameter>f</parameter></" 2677#~ "paramdef> <paramdef><type>float </type> <parameter>g</parameter></" 2678#~ "paramdef> <paramdef><type>float </type> <parameter>h</parameter></" 2679#~ "paramdef> <paramdef><type>float </type> <parameter>i</parameter></" 2680#~ "paramdef> <paramdef><type>float </type> <parameter>xoff</parameter></" 2681#~ "paramdef> <paramdef><type>float </type> <parameter>yoff</parameter></" 2682#~ "paramdef> <paramdef><type>float </type> <parameter>zoff</parameter></" 2683#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2684#~ "<function>ST_Affine</function></funcdef> <paramdef><type>geometry </type> " 2685#~ "<parameter>geomA</parameter></paramdef> <paramdef><type>float </type> " 2686#~ "<parameter>a</parameter></paramdef> <paramdef><type>float </type> " 2687#~ "<parameter>b</parameter></paramdef> <paramdef><type>float </type> " 2688#~ "<parameter>d</parameter></paramdef> <paramdef><type>float </type> " 2689#~ "<parameter>e</parameter></paramdef> <paramdef><type>float </type> " 2690#~ "<parameter>xoff</parameter></paramdef> <paramdef><type>float </type> " 2691#~ "<parameter>yoff</parameter></paramdef> </funcprototype>" 2692 2693#~ msgid "" 2694#~ "Applies a 3d affine transformation to the geometry to do things like " 2695#~ "translate, rotate, scale in one step." 2696#~ msgstr "" 2697#~ "Aplica una transformación de afinidad 3D a una geometría para hacer cosas " 2698#~ "como trasladar, rotar, escalar en un solo paso." 2699 2700#~ msgid "" 2701#~ "Version 1: The call <programlisting>ST_Affine(geom, a, b, c, d, e, f, g, " 2702#~ "h, i, xoff, yoff, zoff) </programlisting> represents the transformation " 2703#~ "matrix <programlisting>/ a b c xoff \\\n" 2704#~ "| d e f yoff |\n" 2705#~ "| g h i zoff |\n" 2706#~ "\\ 0 0 0 1 /</programlisting> and the vertices are transformed as " 2707#~ "follows: <programlisting>x' = a*x + b*y + c*z + xoff\n" 2708#~ "y' = d*x + e*y + f*z + yoff\n" 2709#~ "z' = g*x + h*y + i*z + zoff</programlisting> All of the translate / scale " 2710#~ "functions below are expressed via such an affine transformation." 2711#~ msgstr "" 2712#~ "Versión 1: la llamada <programlisting>ST_Affine(geom, a, b, c, d, e, f, " 2713#~ "g, h, i, xoff, yoff, zoff) </programlisting> representa la matriz de " 2714#~ "transformación <programlisting>/ a b c xoff \\\n" 2715#~ "| d e f yoff |\n" 2716#~ "| g h i zoff |\n" 2717#~ "\\ 0 0 0 1 /</programlisting> y los vértices se transforman de la " 2718#~ "siguiente manera: <programlisting>x' = a*x + b*y + c*z + xoff\n" 2719#~ "y' = d*x + e*y + f*z + yoff\n" 2720#~ "z' = g*x + h*y + i*z + zoff</programlisting> Todas las funciones de " 2721#~ "traslación/escala se expresan a través de la búsqueda de una " 2722#~ "transformación afín." 2723 2724#~ msgid "" 2725#~ "Version 2: Applies a 2d affine transformation to the geometry. The call " 2726#~ "<programlisting>ST_Affine(geom, a, b, d, e, xoff, yoff)</programlisting> " 2727#~ "represents the transformation matrix <programlisting>/ a b 0 xoff " 2728#~ "\\ / a b xoff \\\n" 2729#~ "| d e 0 yoff | rsp. | d e yoff |\n" 2730#~ "| 0 0 1 0 | \\ 0 0 1 /\n" 2731#~ "\\ 0 0 0 1 /</programlisting> and the vertices are transformed as " 2732#~ "follows: <programlisting>x' = a*x + b*y + xoff\n" 2733#~ "y' = d*x + e*y + yoff\n" 2734#~ "z' = z </programlisting> This method is a subcase of the 3D method above." 2735#~ msgstr "" 2736#~ "Versión 2: aplica una transformación de afinidad 2D a la geometría. La " 2737#~ "llamada <programlisting>ST_Affine(geom, a, b, d, e, xoff, yoff)</" 2738#~ "programlisting> representa la matriz de transformación <programlisting>/ " 2739#~ "a b 0 xoff \\ / a b xoff \\\n" 2740#~ "| d e 0 yoff | rsp. | d e yoff |\n" 2741#~ "| 0 0 1 0 | \\ 0 0 1 /\n" 2742#~ "\\ 0 0 0 1 /</programlisting> y los vértices se transforman de la " 2743#~ "siguiente manera: <programlisting>x' = a*x + b*y + xoff\n" 2744#~ "y' = d*x + e*y + yoff\n" 2745#~ "z' = z </programlisting> Este método es un subcaso del método 3D anterior." 2746 2747#~ msgid "" 2748#~ "Enhanced: 2.0.0 support for Polyhedral surfaces, Triangles and TIN was " 2749#~ "introduced." 2750#~ msgstr "" 2751#~ "Mejorado: 2.0.0 soporte para superficies poliédricas, triángulos y TIN " 2752#~ "fue introducida." 2753 2754#~ msgid "Availability: 1.1.2. Name changed from Affine to ST_Affine in 1.2.2" 2755#~ msgstr "" 2756#~ "Disponibilidad: 1.1.2. cambio de nombre de Affine a ST_Affine en 1.2.2" 2757 2758#~ msgid "" 2759#~ "Prior to 1.3.4, this function crashes if used with geometries that " 2760#~ "contain CURVES. This is fixed in 1.3.4+" 2761#~ msgstr "" 2762#~ "Antes de 1.3.4, esta función se bloquea si se utiliza con geometrías que " 2763#~ "contienen curvas. Esto se ha solucionado en la versión 1.3.4+" 2764 2765#~ msgid "" 2766#~ "--Rotate a 3d line 180 degrees about the z axis. Note this is long-hand " 2767#~ "for doing ST_Rotate();\n" 2768#~ " SELECT ST_AsEWKT(ST_Affine(the_geom, cos(pi()), -sin(pi()), 0, " 2769#~ "sin(pi()), cos(pi()), 0, 0, 0, 1, 0, 0, 0)) As using_affine,\n" 2770#~ " ST_AsEWKT(ST_Rotate(the_geom, pi())) As using_rotate\n" 2771#~ " FROM (SELECT ST_GeomFromEWKT('LINESTRING(1 2 3, 1 4 3)') As " 2772#~ "the_geom) As foo;\n" 2773#~ " using_affine | using_rotate\n" 2774#~ "-----------------------------+-----------------------------\n" 2775#~ " LINESTRING(-1 -2 3,-1 -4 3) | LINESTRING(-1 -2 3,-1 -4 3)\n" 2776#~ "(1 row)\n" 2777#~ "\n" 2778#~ "--Rotate a 3d line 180 degrees in both the x and z axis\n" 2779#~ "SELECT ST_AsEWKT(ST_Affine(the_geom, cos(pi()), -sin(pi()), 0, sin(pi()), " 2780#~ "cos(pi()), -sin(pi()), 0, sin(pi()), cos(pi()), 0, 0, 0))\n" 2781#~ " FROM (SELECT ST_GeomFromEWKT('LINESTRING(1 2 3, 1 4 3)') As " 2782#~ "the_geom) As foo;\n" 2783#~ " st_asewkt\n" 2784#~ "-------------------------------\n" 2785#~ " LINESTRING(-1 -2 -3,-1 -4 -3)\n" 2786#~ "(1 row)" 2787#~ msgstr "" 2788#~ "--Gire una línea 3D 180 grados sobre el eje Z. Tenga en cuenta que esto " 2789#~ "es de larga duración para hacer ST_Rotate ();\n" 2790#~ " SELECT ST_AsEWKT(ST_Affine(the_geom, cos(pi()), -sin(pi()), 0, " 2791#~ "sin(pi()), cos(pi()), 0, 0, 0, 1, 0, 0, 0)) As using_affine,\n" 2792#~ " ST_AsEWKT(ST_Rotate(the_geom, pi())) As using_rotate\n" 2793#~ " FROM (SELECT ST_GeomFromEWKT('LINESTRING(1 2 3, 1 4 3)') As " 2794#~ "the_geom) As foo;\n" 2795#~ " using_affine | using_rotate\n" 2796#~ "-----------------------------+-----------------------------\n" 2797#~ " LINESTRING(-1 -2 3,-1 -4 3) | LINESTRING(-1 -2 3,-1 -4 3)\n" 2798#~ "(1 row)\n" 2799#~ "\n" 2800#~ "--Rotar una línea 3D 180 grados en el eje X y Z\n" 2801#~ "SELECT ST_AsEWKT(ST_Affine(the_geom, cos(pi()), -sin(pi()), 0, sin(pi()), " 2802#~ "cos(pi()), -sin(pi()), 0, sin(pi()), cos(pi()), 0, 0, 0))\n" 2803#~ " FROM (SELECT ST_GeomFromEWKT('LINESTRING(1 2 3, 1 4 3)') As " 2804#~ "the_geom) As foo;\n" 2805#~ " st_asewkt\n" 2806#~ "-------------------------------\n" 2807#~ " LINESTRING(-1 -2 -3,-1 -4 -3)\n" 2808#~ "(1 row)" 2809 2810#~ msgid "" 2811#~ ", <xref linkend=\"ST_Scale\"/>, <xref linkend=\"ST_Translate\"/>, <xref " 2812#~ "linkend=\"ST_TransScale\"/>" 2813#~ msgstr "" 2814#~ ", <xref linkend=\"ST_Scale\"/>, <xref linkend=\"ST_Translate\"/>, <xref " 2815#~ "linkend=\"ST_TransScale\"/>" 2816 2817#~ msgid "requires GEOS >= 2.1.0" 2818#~ msgstr "Requiere GEOS >= 2.1.0" 2819 2820#~ msgid "ST_Rotate" 2821#~ msgstr "ST_Rotate" 2822 2823#~ msgid "Rotate a geometry rotRadians counter-clockwise about an origin." 2824#~ msgstr "" 2825#~ "Gira una geometría rotRadians en sentido contrario a las manecillas del " 2826#~ "reloj sobre un origen." 2827 2828#~ msgid "" 2829#~ "<funcprototype> <funcdef>geometry <function>ST_Rotate</function></" 2830#~ "funcdef> <paramdef><type>geometry</type> <parameter>geomA</parameter></" 2831#~ "paramdef> <paramdef><type>float</type> <parameter>rotRadians</parameter></" 2832#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2833#~ "<function>ST_Rotate</function></funcdef> <paramdef><type>geometry</type> " 2834#~ "<parameter>geomA</parameter></paramdef> <paramdef><type>float</type> " 2835#~ "<parameter>rotRadians</parameter></paramdef> <paramdef><type>float</type> " 2836#~ "<parameter>x0</parameter></paramdef> <paramdef><type>float</type> " 2837#~ "<parameter>y0</parameter></paramdef> </funcprototype> <funcprototype> " 2838#~ "<funcdef>geometry <function>ST_Rotate</function></funcdef> " 2839#~ "<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 2840#~ "<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef> " 2841#~ "<paramdef><type>geometry</type> <parameter>pointOrigin</parameter></" 2842#~ "paramdef> </funcprototype>" 2843#~ msgstr "" 2844#~ "<funcprototype> <funcdef>geometry <function>ST_Rotate</function></" 2845#~ "funcdef> <paramdef><type>geometry</type> <parameter>geomA</parameter></" 2846#~ "paramdef> <paramdef><type>float</type> <parameter>rotRadians</parameter></" 2847#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2848#~ "<function>ST_Rotate</function></funcdef> <paramdef><type>geometry</type> " 2849#~ "<parameter>geomA</parameter></paramdef> <paramdef><type>float</type> " 2850#~ "<parameter>rotRadians</parameter></paramdef> <paramdef><type>float</type> " 2851#~ "<parameter>x0</parameter></paramdef> <paramdef><type>float</type> " 2852#~ "<parameter>y0</parameter></paramdef> </funcprototype> <funcprototype> " 2853#~ "<funcdef>geometry <function>ST_Rotate</function></funcdef> " 2854#~ "<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 2855#~ "<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef> " 2856#~ "<paramdef><type>geometry</type> <parameter>pointOrigin</parameter></" 2857#~ "paramdef> </funcprototype>" 2858 2859#~ msgid "" 2860#~ "Rotates geometry rotRadians counter-clockwise about the origin. The " 2861#~ "rotation origin can be specified either as a POINT geometry, or as x and " 2862#~ "y coordinates. If the origin is not specified, the geometry is rotated " 2863#~ "about POINT(0 0)." 2864#~ msgstr "" 2865#~ "Gira una geometría rotRadians en sentido contrario a las manecillas del " 2866#~ "reloj sobre un origen. El origen de la rotación se puede especificar ya " 2867#~ "sea como una geometría de punto, o como coordenadas x e y. Si no se " 2868#~ "especifica el origen, la geometría se gira sobre POINT(0 0)." 2869 2870#~ msgid "" 2871#~ "Enhanced: 2.0.0 additional parameters for specifying the origin of " 2872#~ "rotation were added." 2873#~ msgstr "" 2874#~ "Mejorado: 2.0.0 se agregaron parámetros adicionales para especificar el " 2875#~ "origen de la rotación." 2876 2877#~ msgid "Availability: 1.1.2. Name changed from Rotate to ST_Rotate in 1.2.2" 2878#~ msgstr "" 2879#~ "Disponibilidad: 1.1.2. Nombre cambiado de Rotate a ST_Rotate en 1.2.2" 2880 2881#~ msgid "" 2882#~ "--Rotate 180 degrees\n" 2883#~ "SELECT ST_AsEWKT(ST_Rotate('LINESTRING (50 160, 50 50, 100 50)', pi()));\n" 2884#~ " st_asewkt\n" 2885#~ "---------------------------------------\n" 2886#~ " LINESTRING(-50 -160,-50 -50,-100 -50)\n" 2887#~ "(1 row)\n" 2888#~ "\n" 2889#~ "--Rotate 30 degrees counter-clockwise at x=50, y=160\n" 2890#~ "SELECT ST_AsEWKT(ST_Rotate('LINESTRING (50 160, 50 50, 100 50)', pi()/6, " 2891#~ "50, 160));\n" 2892#~ " st_asewkt\n" 2893#~ "---------------------------------------------------------------------------\n" 2894#~ " LINESTRING(50 160,105 64.7372055837117,148.301270189222 " 2895#~ "89.7372055837117)\n" 2896#~ "(1 row)\n" 2897#~ "\n" 2898#~ "--Rotate 60 degrees clockwise from centroid\n" 2899#~ "SELECT ST_AsEWKT(ST_Rotate(geom, -pi()/3, ST_Centroid(geom)))\n" 2900#~ "FROM (SELECT 'LINESTRING (50 160, 50 50, 100 50)'::geometry AS geom) AS " 2901#~ "foo;\n" 2902#~ " st_asewkt\n" 2903#~ "--------------------------------------------------------------\n" 2904#~ " LINESTRING(116.4225 130.6721,21.1597 75.6721,46.1597 32.3708)\n" 2905#~ "(1 row)" 2906#~ msgstr "" 2907#~ "--Gira 180 grados\n" 2908#~ "SELECT ST_AsEWKT(ST_Rotate('LINESTRING (50 160, 50 50, 100 50)', pi()));\n" 2909#~ " st_asewkt\n" 2910#~ "---------------------------------------\n" 2911#~ " LINESTRING(-50 -160,-50 -50,-100 -50)\n" 2912#~ "(1 row)\n" 2913#~ "\n" 2914#~ "--Gira 30 grados en sentido contrario a las manecillas del reloj desde " 2915#~ "x=50, y=160\n" 2916#~ "SELECT ST_AsEWKT(ST_Rotate('LINESTRING (50 160, 50 50, 100 50)', pi()/6, " 2917#~ "50, 160));\n" 2918#~ " st_asewkt\n" 2919#~ "---------------------------------------------------------------------------\n" 2920#~ " LINESTRING(50 160,105 64.7372055837117,148.301270189222 " 2921#~ "89.7372055837117)\n" 2922#~ "(1 row)\n" 2923#~ "\n" 2924#~ "--Gira 60 grados a la derecha desde el centroide\n" 2925#~ "SELECT ST_AsEWKT(ST_Rotate(geom, -pi()/3, ST_Centroid(geom)))\n" 2926#~ "FROM (SELECT 'LINESTRING (50 160, 50 50, 100 50)'::geometry AS geom) AS " 2927#~ "foo;\n" 2928#~ " st_asewkt\n" 2929#~ "--------------------------------------------------------------\n" 2930#~ " LINESTRING(116.4225 130.6721,21.1597 75.6721,46.1597 32.3708)\n" 2931#~ "(1 row)" 2932 2933#~ msgid "" 2934#~ ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateY\"/>, <xref " 2935#~ "linkend=\"ST_RotateZ\"/>" 2936#~ msgstr "" 2937#~ ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateY\"/>, <xref " 2938#~ "linkend=\"ST_RotateZ\"/>" 2939 2940#~ msgid "ST_RotateX" 2941#~ msgstr "ST_RotateX" 2942 2943#~ msgid "Rotate a geometry rotRadians about the X axis." 2944#~ msgstr "Gira una geometría rotRadians sobre el eje X." 2945 2946#~ msgid "" 2947#~ "<funcdef>geometry <function>ST_RotateX</function></funcdef> " 2948#~ "<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 2949#~ "<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef>" 2950#~ msgstr "" 2951#~ "<funcdef>geometry <function>ST_RotateX</function></funcdef> " 2952#~ "<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 2953#~ "<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef>" 2954 2955#~ msgid "Rotate a geometry geomA - rotRadians about the X axis." 2956#~ msgstr "Gira una geometría geomA - rotRadians sobre el eje X." 2957 2958#~ msgid "" 2959#~ "<code>ST_RotateX(geomA, rotRadians)</code> is short-hand for " 2960#~ "<code>ST_Affine(geomA, 1, 0, 0, 0, cos(rotRadians), -sin(rotRadians), 0, " 2961#~ "sin(rotRadians), cos(rotRadians), 0, 0, 0)</code>." 2962#~ msgstr "" 2963#~ "<code>ST_RotateX(geomA, rotRadians)</code> es de acceso rápido para " 2964#~ "<code>ST_Affine(geomA, 1, 0, 0, 0, cos(rotRadians), -sin(rotRadians), 0, " 2965#~ "sin(rotRadians), cos(rotRadians), 0, 0, 0)</code>." 2966 2967#~ msgid "" 2968#~ "Availability: 1.1.2. Name changed from RotateX to ST_RotateX in 1.2.2" 2969#~ msgstr "" 2970#~ "Disponibilidad: 1.1.2. El nombre cambió de RotateX a ST_RotateX en 1.2.2" 2971 2972#~ msgid "" 2973#~ "--Rotate a line 90 degrees along x-axis\n" 2974#~ "SELECT ST_AsEWKT(ST_RotateX(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 1)'), " 2975#~ "pi()/2));\n" 2976#~ " st_asewkt\n" 2977#~ "---------------------------\n" 2978#~ " LINESTRING(1 -3 2,1 -1 1)" 2979#~ msgstr "" 2980#~ "--Gira una línea 90 grados a lo largo del eje x\n" 2981#~ "SELECT ST_AsEWKT(ST_RotateX(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 1)'), " 2982#~ "pi()/2));\n" 2983#~ " st_asewkt\n" 2984#~ "---------------------------\n" 2985#~ " LINESTRING(1 -3 2,1 -1 1)" 2986 2987#~ msgid ", <xref linkend=\"ST_RotateY\"/>, <xref linkend=\"ST_RotateZ\"/>" 2988#~ msgstr ", <xref linkend=\"ST_RotateY\"/>, <xref linkend=\"ST_RotateZ\"/>" 2989 2990#~ msgid "ST_RotateY" 2991#~ msgstr "ST_RotateY" 2992 2993#~ msgid "Rotate a geometry rotRadians about the Y axis." 2994#~ msgstr "Gira una geometría rotRadians sobre el eje Y." 2995 2996#~ msgid "" 2997#~ "<funcdef>geometry <function>ST_RotateY</function></funcdef> " 2998#~ "<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 2999#~ "<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef>" 3000#~ msgstr "" 3001#~ "<funcdef>geometry <function>ST_RotateY</function></funcdef> " 3002#~ "<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 3003#~ "<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef>" 3004 3005#~ msgid "Rotate a geometry geomA - rotRadians about the y axis." 3006#~ msgstr "Gira una geometría geomA - rotRadians sobre el eje y." 3007 3008#~ msgid "" 3009#~ "<code>ST_RotateY(geomA, rotRadians)</code> is short-hand for " 3010#~ "<code>ST_Affine(geomA, cos(rotRadians), 0, sin(rotRadians), 0, 1, 0, -" 3011#~ "sin(rotRadians), 0, cos(rotRadians), 0, 0, 0)</code>." 3012#~ msgstr "" 3013#~ "<code>ST_RotateY(geomA, rotRadians)</code> es el acceso rápido para " 3014#~ "<code>ST_Affine(geomA, cos(rotRadians), 0, sin(rotRadians), 0, 1, 0, -" 3015#~ "sin(rotRadians), 0, cos(rotRadians), 0, 0, 0)</code>." 3016 3017#~ msgid "" 3018#~ "Availability: 1.1.2. Name changed from RotateY to ST_RotateY in 1.2.2" 3019#~ msgstr "" 3020#~ "Disponibilidad: 1.1.2. El nombre cambió de RotateY a ST_RotateY en 1.2.2" 3021 3022#~ msgid "" 3023#~ "--Rotate a line 90 degrees along y-axis\n" 3024#~ " SELECT ST_AsEWKT(ST_RotateY(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 1)'), " 3025#~ "pi()/2));\n" 3026#~ " st_asewkt\n" 3027#~ "---------------------------\n" 3028#~ " LINESTRING(3 2 -1,1 1 -1)" 3029#~ msgstr "" 3030#~ "--Gira una línea 90 grados a lo largo del eje y\n" 3031#~ " SELECT ST_AsEWKT(ST_RotateY(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 1)'), " 3032#~ "pi()/2));\n" 3033#~ " st_asewkt\n" 3034#~ "---------------------------\n" 3035#~ " LINESTRING(3 2 -1,1 1 -1)" 3036 3037#~ msgid ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateZ\"/>" 3038#~ msgstr ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateZ\"/>" 3039 3040#~ msgid "ST_RotateZ" 3041#~ msgstr "ST_RotateZ" 3042 3043#~ msgid "Rotate a geometry rotRadians about the Z axis." 3044#~ msgstr "Gira una geometría rotRadians sobre el eje Z." 3045 3046#~ msgid "" 3047#~ "<funcdef>geometry <function>ST_RotateZ</function></funcdef> " 3048#~ "<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 3049#~ "<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef>" 3050#~ msgstr "" 3051#~ "<funcdef>geometry <function>ST_RotateZ</function></funcdef> " 3052#~ "<paramdef><type>geometry</type> <parameter>geomA</parameter></paramdef> " 3053#~ "<paramdef><type>float</type> <parameter>rotRadians</parameter></paramdef>" 3054 3055#~ msgid "Rotate a geometry geomA - rotRadians about the Z axis." 3056#~ msgstr "Gira una geometría geomA - rotRadians sobre el eje Z." 3057 3058#~ msgid "This is a synonym for ST_Rotate" 3059#~ msgstr "Este es un sinónimo de ST_Rotate" 3060 3061#~ msgid "" 3062#~ "<code>ST_RotateZ(geomA, rotRadians)</code> is short-hand for <code>SELECT " 3063#~ "ST_Affine(geomA, cos(rotRadians), -sin(rotRadians), 0, sin(rotRadians), " 3064#~ "cos(rotRadians), 0, 0, 0, 1, 0, 0, 0)</code>." 3065#~ msgstr "" 3066#~ "<code>ST_RotateZ(geomA, rotRadians)</code> es el accero rápido para " 3067#~ "<code>SELECT ST_Affine(geomA, cos(rotRadians), -sin(rotRadians), 0, " 3068#~ "sin(rotRadians), cos(rotRadians), 0, 0, 0, 1, 0, 0, 0)</code>." 3069 3070#~ msgid "" 3071#~ "Availability: 1.1.2. Name changed from RotateZ to ST_RotateZ in 1.2.2" 3072#~ msgstr "" 3073#~ "Disponibilidad: 1.1.2. El nombre cambió de RotateZ a ST_RotateZ en 1.2.2" 3074 3075#~ msgid "" 3076#~ "--Rotate a line 90 degrees along z-axis\n" 3077#~ "SELECT ST_AsEWKT(ST_RotateZ(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 1)'), " 3078#~ "pi()/2));\n" 3079#~ " st_asewkt\n" 3080#~ "---------------------------\n" 3081#~ " LINESTRING(-2 1 3,-1 1 1)\n" 3082#~ "\n" 3083#~ " --Rotate a curved circle around z-axis\n" 3084#~ "SELECT ST_AsEWKT(ST_RotateZ(the_geom, pi()/2))\n" 3085#~ "FROM (SELECT ST_LineToCurve(ST_Buffer(ST_GeomFromText('POINT(234 567)'), " 3086#~ "3)) As the_geom) As foo;\n" 3087#~ "\n" 3088#~ " st_asewkt\n" 3089#~ "----------------------------------------------------------------------------------------------------------------------------\n" 3090#~ " CURVEPOLYGON(CIRCULARSTRING(-567 237,-564.87867965644 " 3091#~ "236.12132034356,-564 234,-569.12132034356 231.87867965644,-567 237))" 3092#~ msgstr "" 3093#~ "--Gira una línea 90 grados a lo largo del eje z\n" 3094#~ "SELECT ST_AsEWKT(ST_RotateZ(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 1)'), " 3095#~ "pi()/2));\n" 3096#~ " st_asewkt\n" 3097#~ "---------------------------\n" 3098#~ " LINESTRING(-2 1 3,-1 1 1)\n" 3099#~ "\n" 3100#~ " --Gira un círculo curvo alrededor del eje z\n" 3101#~ "SELECT ST_AsEWKT(ST_RotateZ(the_geom, pi()/2))\n" 3102#~ "FROM (SELECT ST_LineToCurve(ST_Buffer(ST_GeomFromText('POINT(234 567)'), " 3103#~ "3)) As the_geom) As foo;\n" 3104#~ "\n" 3105#~ " st_asewkt\n" 3106#~ "----------------------------------------------------------------------------------------------------------------------------\n" 3107#~ " CURVEPOLYGON(CIRCULARSTRING(-567 237,-564.87867965644 " 3108#~ "236.12132034356,-564 234,-569.12132034356 231.87867965644,-567 237))" 3109 3110#~ msgid ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateY\"/>" 3111#~ msgstr ", <xref linkend=\"ST_RotateX\"/>, <xref linkend=\"ST_RotateY\"/>" 3112 3113#~ msgid "ST_Scale" 3114#~ msgstr "ST_Scale" 3115 3116#~ msgid "Scale a geometry by given factors." 3117#~ msgstr "Escalar una geometría por factores dados." 3118 3119#~ msgid "" 3120#~ "Scales the geometry to a new size by multiplying the ordinates with the " 3121#~ "corresponding factor parameters." 3122#~ msgstr "" 3123#~ "Escala la geometría a un nuevo tamaño multiplicando las ordenadas con los " 3124#~ "parámetros de factor correspondientes." 3125 3126#~ msgid "" 3127#~ "The version taking a geometry as the <varname>factor</varname> parameter " 3128#~ "allows passing a 2d, 3dm, 3dz or 4d point to set scaling factor for all " 3129#~ "supported dimensions. Missing dimensions in the <varname>factor</varname> " 3130#~ "point are equivalent to no scaling the corresponding dimension." 3131#~ msgstr "" 3132#~ "La versión que toma una geometría como parámetro de <varname>factor</" 3133#~ "varname> permite pasar un punto 2d, 3dm, 3dz o 4d para definir el factor " 3134#~ "de escalado para todas las dimensiones soportadas. Las dimensiones que " 3135#~ "faltan en el punto <varname>factor</varname> es equivalente a no escalar " 3136#~ "la dimensión correspondiente." 3137 3138#~ msgid "Availability: 1.1.0." 3139#~ msgstr "Disponibilidad: 1.1.0" 3140 3141#~ msgid "" 3142#~ "Enhanced: 2.2.0 support for scaling all dimension (geometry parameter) " 3143#~ "was introduced." 3144#~ msgstr "" 3145#~ "Mejorada: 2.2.0 se introdujo soporte para escalar todas las dimensiones " 3146#~ "(parámetro de geometría)." 3147 3148#~ msgid ", <xref linkend=\"ST_TransScale\"/>" 3149#~ msgstr ", <xref linkend=\"ST_TransScale\"/>" 3150 3151#~ msgid "ST_SetSRID" 3152#~ msgstr "ST_SetSRID" 3153 3154#~ msgid "Set the SRID on a geometry to a particular integer value." 3155#~ msgstr "Establezca el SRID en una geometría en un valor entero determinado." 3156 3157#~ msgid "" 3158#~ "Sets the SRID on a geometry to a particular integer value. Useful in " 3159#~ "constructing bounding boxes for queries." 3160#~ msgstr "" 3161#~ "Establezca el SRID en una geometría en un valor entero determinado. Útil " 3162#~ "en la construcción de cuadros delimitadores para consultas." 3163 3164#~ msgid "" 3165#~ "This function does not transform the geometry coordinates in any way - it " 3166#~ "simply sets the meta data defining the spatial reference system the " 3167#~ "geometry is assumed to be in. Use <xref linkend=\"ST_Transform\"/> if you " 3168#~ "want to transform the geometry into a new projection." 3169#~ msgstr "" 3170#~ "Esta función no transforma las coordenadas de geometría de ninguna manera-" 3171#~ "simplemente establece los metadatos que definen el sistema de referencia " 3172#~ "espacial en el que se supone que se encuentra la geometría. Utilice <xref " 3173#~ "linkend=\"ST_Transform\"/> si desea transformar la geometría en una nueva " 3174#~ "proyección." 3175 3176#~ msgid "&sfs_compliant;" 3177#~ msgstr "&sfs_compliant;" 3178 3179#~ msgid "-- Mark a point as WGS 84 long lat --" 3180#~ msgstr "-- Marca un punto como WGS 84 longitud latitud --" 3181 3182#~ msgid "" 3183#~ "SELECT ST_SetSRID(ST_Point(-123.365556, 48.428611),4326) As " 3184#~ "wgs84long_lat;\n" 3185#~ "-- the ewkt representation (wrap with ST_AsEWKT) -\n" 3186#~ "SRID=4326;POINT(-123.365556 48.428611)" 3187#~ msgstr "" 3188#~ "SELECT ST_SetSRID(ST_Point(-123.365556, 48.428611),4326) As " 3189#~ "wgs84long_lat;\n" 3190#~ "-- la representation ewkt (envolver con ST_AsEWKT) -\n" 3191#~ "SRID=4326;POINT(-123.365556 48.428611)" 3192 3193#~ msgid "" 3194#~ "-- Mark a point as WGS 84 long lat and then transform to web mercator " 3195#~ "(Spherical Mercator) --" 3196#~ msgstr "" 3197#~ "-- Marcar un punto como WGS 84 longitud latitud y luego transformar a web " 3198#~ "Mercator (Mercator esférico) --" 3199 3200#~ msgid "" 3201#~ "SELECT ST_Transform(ST_SetSRID(ST_Point(-123.365556, " 3202#~ "48.428611),4326),3785) As spere_merc;\n" 3203#~ "-- the ewkt representation (wrap with ST_AsEWKT) -\n" 3204#~ "SRID=3785;POINT(-13732990.8753491 6178458.96425423)" 3205#~ msgstr "" 3206#~ "SELECT ST_Transform(ST_SetSRID(ST_Point(-123.365556, " 3207#~ "48.428611),4326),3785) As spere_merc;\n" 3208#~ "-- la representation ewkt (envolver con ST_AsEWKT) -\n" 3209#~ "SRID=3785;POINT(-13732990.8753491 6178458.96425423)" 3210 3211#~ msgid "" 3212#~ ", <xref linkend=\"ST_AsEWKT\"/>, <xref linkend=\"ST_Point\"/>, <xref " 3213#~ "linkend=\"ST_SRID\"/>, <xref linkend=\"ST_Transform\"/>, <xref linkend=" 3214#~ "\"UpdateGeometrySRID\"/>" 3215#~ msgstr "" 3216#~ ", <xref linkend=\"ST_AsEWKT\"/>, <xref linkend=\"ST_Point\"/>, <xref " 3217#~ "linkend=\"ST_SRID\"/>, <xref linkend=\"ST_Transform\"/>, <xref linkend=" 3218#~ "\"UpdateGeometrySRID\"/>" 3219 3220#~ msgid "Availability: 2.0.0 requires GEOS >= 3.3.0." 3221#~ msgstr "Disponibilidad: 2.0.0 requiere GEOS >= 3.3.0." 3222 3223#~ msgid "ST_Transform" 3224#~ msgstr "ST_Transform" 3225 3226#~ msgid "" 3227#~ "Return a new geometry with its coordinates transformed to a different " 3228#~ "spatial reference." 3229#~ msgstr "" 3230#~ "Devuelve una nueva geometría con sus coordenadas transformadas a una " 3231#~ "referencia espacial diferente." 3232 3233#~ msgid "" 3234#~ "<funcprototype> <funcdef>geometry <function>ST_Transform</function></" 3235#~ "funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></" 3236#~ "paramdef> <paramdef><type>integer </type> <parameter>srid</parameter></" 3237#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 3238#~ "<function>ST_Transform</function></funcdef> <paramdef><type>geometry </" 3239#~ "type> <parameter>geom</parameter></paramdef> <paramdef><type>text </type> " 3240#~ "<parameter>to_proj</parameter></paramdef> </funcprototype> " 3241#~ "<funcprototype> <funcdef>geometry <function>ST_Transform</function></" 3242#~ "funcdef> <paramdef><type>geometry </type> <parameter>geom</parameter></" 3243#~ "paramdef> <paramdef><type>text </type> <parameter>from_proj</parameter></" 3244#~ "paramdef> <paramdef><type>text </type> <parameter>to_proj</parameter></" 3245#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 3246#~ "<function>ST_Transform</function></funcdef> <paramdef><type>geometry </" 3247#~ "type> <parameter>geom</parameter></paramdef> <paramdef><type>text </type> " 3248#~ "<parameter>from_proj</parameter></paramdef> <paramdef><type>integer </" 3249#~ "type> <parameter>to_srid</parameter></paramdef> </funcprototype>" 3250#~ msgstr "" 3251#~ "<funcprototype> <funcdef>geometry <function>ST_Transform</function></" 3252#~ "funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></" 3253#~ "paramdef> <paramdef><type>integer </type> <parameter>srid</parameter></" 3254#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 3255#~ "<function>ST_Transform</function></funcdef> <paramdef><type>geometry </" 3256#~ "type> <parameter>geom</parameter></paramdef> <paramdef><type>text </type> " 3257#~ "<parameter>to_proj</parameter></paramdef> </funcprototype> " 3258#~ "<funcprototype> <funcdef>geometry <function>ST_Transform</function></" 3259#~ "funcdef> <paramdef><type>geometry </type> <parameter>geom</parameter></" 3260#~ "paramdef> <paramdef><type>text </type> <parameter>from_proj</parameter></" 3261#~ "paramdef> <paramdef><type>text </type> <parameter>to_proj</parameter></" 3262#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 3263#~ "<function>ST_Transform</function></funcdef> <paramdef><type>geometry </" 3264#~ "type> <parameter>geom</parameter></paramdef> <paramdef><type>text </type> " 3265#~ "<parameter>from_proj</parameter></paramdef> <paramdef><type>integer </" 3266#~ "type> <parameter>to_srid</parameter></paramdef> </funcprototype>" 3267 3268#~ msgid "" 3269#~ "Returns a new geometry with its coordinates transformed to a different " 3270#~ "spatial reference system. The destination spatial reference " 3271#~ "<varname>to_srid</varname> may be identified by a valid SRID integer " 3272#~ "parameter (i.e. it must exist in the <varname>spatial_ref_sys</varname> " 3273#~ "table). Alternatively, a spatial reference defined as a PROJ.4 string can " 3274#~ "be used for <varname>to_proj</varname> and/or <varname>from_proj</" 3275#~ "varname>, however these methods are not optimized. If the destination " 3276#~ "spatial reference system is expressed with a PROJ.4 string instead of an " 3277#~ "SRID, the SRID of the output geometry will be set to zero. With the " 3278#~ "exception of functions with <varname>from_proj</varname>, input " 3279#~ "geometries must have a defined SRID." 3280#~ msgstr "" 3281#~ "Devuelve una nueva geometría con sus coordenadas transformadas en un " 3282#~ "sistema de referencia espacial diferente. La referencia espacial de " 3283#~ "destino <varname>to_srid</varname> puede identificarse mediante un " 3284#~ "parámetro de tipo entero SRID válido (es decir, debe existir en la tabla " 3285#~ "<varname>spatial_ref_sys</varname>). Alternativamente, se puede utilizar " 3286#~ "una referencia espacial definida como una cadena de PROJ.4 para " 3287#~ "<varname>to_proj</varname> y/o <varname>from_proj</varname>, sin embargo " 3288#~ "estos métodos no están optimizados. Si el sistema de referencia espacial " 3289#~ "de destino se expresa con una cadena de PROJ.4 en lugar de un SRID, el " 3290#~ "SRID de la geometría de salida se establecerá en cero. Con la excepción " 3291#~ "de funciones con <varname>from_proj</varname>, las geometrías de entrada " 3292#~ "deben tener un SRID definido." 3293 3294#~ msgid "" 3295#~ "ST_Transform is often confused with ST_SetSRID(). ST_Transform actually " 3296#~ "changes the coordinates of a geometry from one spatial reference system " 3297#~ "to another, while ST_SetSRID() simply changes the SRID identifier of the " 3298#~ "geometry." 3299#~ msgstr "" 3300#~ "ST_Transform se confunde a menudo con ST_SetSRID(). ST_Transform " 3301#~ "realmente cambia las coordenadas de una geometría de un sistema de " 3302#~ "referencia espacial a otro, mientras que ST_SetSRID() simplemente cambia " 3303#~ "el identificador SRID de la geometría." 3304 3305#~ msgid "" 3306#~ "Requires PostGIS be compiled with Proj support. Use <xref linkend=" 3307#~ "\"PostGIS_Full_Version\"/> to confirm you have proj support compiled in." 3308#~ msgstr "" 3309#~ "Requiere que PostGIS sea compilado con soporte de Proj. Utilice <xref " 3310#~ "linkend=\"PostGIS_Full_Version\"/> para confirmar que ha compilado el " 3311#~ "soporte de proyectos." 3312 3313#~ msgid "" 3314#~ "If using more than one transformation, it is useful to have a functional " 3315#~ "index on the commonly used transformations to take advantage of index " 3316#~ "usage." 3317#~ msgstr "" 3318#~ "Si se utiliza más de una transformación, es útil disponer de un índice " 3319#~ "funcional sobre las transformaciones utilizadas comúnmente para " 3320#~ "aprovechar el uso del índice." 3321 3322#~ msgid "Enhanced: 2.3.0 support for direct PROJ.4 text was introduced." 3323#~ msgstr "" 3324#~ "Mejorado: 2.3.0 se introdujo el soporte para el texto directo PROJ.4." 3325 3326#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.6" 3327#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.6" 3328 3329#~ msgid "Change Massachusetts state plane US feet geometry to WGS 84 long lat" 3330#~ msgstr "" 3331#~ "Cambia la geometría en pies del plano del estado de Massachusetts de los " 3332#~ "Estados Unidos a WGS 84 longitud latitud" 3333 3334#~ msgid "" 3335#~ "SELECT ST_AsText(ST_Transform(ST_GeomFromText('POLYGON((743238 " 3336#~ "2967416,743238 2967450,\n" 3337#~ " 743265 2967450,743265.625 2967416,743238 2967416))',2249),4326)) " 3338#~ "As wgs_geom;\n" 3339#~ "\n" 3340#~ " wgs_geom\n" 3341#~ "---------------------------\n" 3342#~ " POLYGON((-71.1776848522251 42.3902896512902,-71.1776843766326 " 3343#~ "42.3903829478009,\n" 3344#~ "-71.1775844305465 42.3903826677917,-71.1775825927231 " 3345#~ "42.3902893647987,-71.177684\n" 3346#~ "8522251 42.3902896512902));\n" 3347#~ "(1 row)\n" 3348#~ "\n" 3349#~ "--3D Circular String example\n" 3350#~ "SELECT ST_AsEWKT(ST_Transform(ST_GeomFromEWKT('SRID=2249;" 3351#~ "CIRCULARSTRING(743238 2967416 1,743238 2967450 2,743265 2967450 " 3352#~ "3,743265.625 2967416 3,743238 2967416 4)'),4326));\n" 3353#~ "\n" 3354#~ " st_asewkt\n" 3355#~ "--------------------------------------------------------------------------------------\n" 3356#~ " SRID=4326;CIRCULARSTRING(-71.1776848522251 42.3902896512902 " 3357#~ "1,-71.1776843766326 42.3903829478009 2,\n" 3358#~ " -71.1775844305465 42.3903826677917 3,\n" 3359#~ " -71.1775825927231 42.3902893647987 3,-71.1776848522251 42.3902896512902 " 3360#~ "4)" 3361#~ msgstr "" 3362#~ "SELECT ST_AsText(ST_Transform(ST_GeomFromText('POLYGON((743238 " 3363#~ "2967416,743238 2967450,\n" 3364#~ " 743265 2967450,743265.625 2967416,743238 2967416))',2249),4326)) " 3365#~ "As wgs_geom;\n" 3366#~ "\n" 3367#~ " wgs_geom\n" 3368#~ "---------------------------\n" 3369#~ " POLYGON((-71.1776848522251 42.3902896512902,-71.1776843766326 " 3370#~ "42.3903829478009,\n" 3371#~ "-71.1775844305465 42.3903826677917,-71.1775825927231 " 3372#~ "42.3902893647987,-71.177684\n" 3373#~ "8522251 42.3902896512902));\n" 3374#~ "(1 row)\n" 3375#~ "\n" 3376#~ "--ejemplo de cadena circular 3D\n" 3377#~ "SELECT ST_AsEWKT(ST_Transform(ST_GeomFromEWKT('SRID=2249;" 3378#~ "CIRCULARSTRING(743238 2967416 1,743238 2967450 2,743265 2967450 " 3379#~ "3,743265.625 2967416 3,743238 2967416 4)'),4326));\n" 3380#~ "\n" 3381#~ " st_asewkt\n" 3382#~ "--------------------------------------------------------------------------------------\n" 3383#~ " SRID=4326;CIRCULARSTRING(-71.1776848522251 42.3902896512902 " 3384#~ "1,-71.1776843766326 42.3903829478009 2,\n" 3385#~ " -71.1775844305465 42.3903826677917 3,\n" 3386#~ " -71.1775825927231 42.3902893647987 3,-71.1776848522251 42.3902896512902 " 3387#~ "4)" 3388 3389#~ msgid "" 3390#~ "Example of creating a partial functional index. For tables where you are " 3391#~ "not sure all the geometries will be filled in, its best to use a partial " 3392#~ "index that leaves out null geometries which will both conserve space and " 3393#~ "make your index smaller and more efficient." 3394#~ msgstr "" 3395#~ "Ejemplo de creación de un índice funcional parcial. Para las tablas en " 3396#~ "las que no está seguro de que todas las geometrías se rellenan, es mejor " 3397#~ "utilizar un índice parcial que deja fuera las geometrías nulas por tanto " 3398#~ "ahorrar espacio y hacer su índice más pequeño y más eficiente." 3399 3400#~ msgid "" 3401#~ "CREATE INDEX idx_the_geom_26986_parcels\n" 3402#~ " ON parcels\n" 3403#~ " USING gist\n" 3404#~ " (ST_Transform(the_geom, 26986))\n" 3405#~ " WHERE the_geom IS NOT NULL;" 3406#~ msgstr "" 3407#~ "CREATE INDEX idx_the_geom_26986_parcels\n" 3408#~ " ON parcels\n" 3409#~ " USING gist\n" 3410#~ " (ST_Transform(the_geom, 26986))\n" 3411#~ " WHERE the_geom IS NOT NULL;" 3412 3413#~ msgid "" 3414#~ "Examples of using PROJ.4 text to transform with custom spatial references." 3415#~ msgstr "" 3416#~ "Ejemplos de uso de texto PROJ.4 para transformar con referencias " 3417#~ "espaciales personalizadas." 3418 3419#~ msgid "" 3420#~ "-- Find intersection of two polygons near the North pole, using a custom " 3421#~ "Gnomic projection\n" 3422#~ "-- See http://boundlessgeo.com/2012/02/flattening-the-peel/\n" 3423#~ " WITH data AS (\n" 3424#~ " SELECT\n" 3425#~ " ST_GeomFromText('POLYGON((170 50,170 72,-130 72,-130 50,170 50))', " 3426#~ "4326) AS p1,\n" 3427#~ " ST_GeomFromText('POLYGON((-170 68,-170 90,-141 90,-141 68,-170 " 3428#~ "68))', 4326) AS p2,\n" 3429#~ " '+proj=gnom +ellps=WGS84 +lat_0=70 +lon_0=-160 +no_defs'::text AS " 3430#~ "gnom\n" 3431#~ " )\n" 3432#~ " SELECT ST_AsText(\n" 3433#~ " ST_Transform(\n" 3434#~ " ST_Intersection(ST_Transform(p1, gnom), ST_Transform(p2, gnom)),\n" 3435#~ " gnom, 4326))\n" 3436#~ " FROM data;\n" 3437#~ " st_astext\n" 3438#~ " --------------------------------------------------------------------------------\n" 3439#~ " POLYGON((-170 74.053793645338,-141 73.4268621378904,-141 68,-170 " 3440#~ "68,-170 74.053793645338))" 3441#~ msgstr "" 3442#~ "-- Encuentre la intersección de dos polígonos cerca del Polo Norte, " 3443#~ "usando una proyección Gnomic personalizada\n" 3444#~ "-- Ver http://boundlessgeo.com/2012/02/flattening-the-peel/\n" 3445#~ " WITH data AS (\n" 3446#~ " SELECT\n" 3447#~ " ST_GeomFromText('POLYGON((170 50,170 72,-130 72,-130 50,170 50))', " 3448#~ "4326) AS p1,\n" 3449#~ " ST_GeomFromText('POLYGON((-170 68,-170 90,-141 90,-141 68,-170 " 3450#~ "68))', 4326) AS p2,\n" 3451#~ " '+proj=gnom +ellps=WGS84 +lat_0=70 +lon_0=-160 +no_defs'::text AS " 3452#~ "gnom\n" 3453#~ " )\n" 3454#~ " SELECT ST_AsText(\n" 3455#~ " ST_Transform(\n" 3456#~ " ST_Intersection(ST_Transform(p1, gnom), ST_Transform(p2, gnom)),\n" 3457#~ " gnom, 4326))\n" 3458#~ " FROM data;\n" 3459#~ " st_astext\n" 3460#~ " --------------------------------------------------------------------------------\n" 3461#~ " POLYGON((-170 74.053793645338,-141 73.4268621378904,-141 68,-170 " 3462#~ "68,-170 74.053793645338))" 3463 3464#~ msgid "Configuring transformation behaviour" 3465#~ msgstr "Configuración del comportamiento de transformación" 3466 3467#~ msgid "" 3468#~ "Sometimes coordinate transformation involving a grid-shift can fail, for " 3469#~ "example if PROJ.4 has not been built with grid-shift files or the " 3470#~ "coordinate does not lie within the range for which the grid shift is " 3471#~ "defined. By default, PostGIS will throw an error if a grid shift file is " 3472#~ "not present, but this behaviour can be configured on a per-SRID basis " 3473#~ "either by testing different <varname>to_proj</varname> values of PROJ.4 " 3474#~ "text, or altering the <varname>proj4text</varname> value within the " 3475#~ "<varname>spatial_ref_sys</varname> table." 3476#~ msgstr "" 3477#~ "A veces, la transformación de coordenadas que implica un cambio de " 3478#~ "cuadrícula puede fallar, por ejemplo, si PROJ.4 no se ha construido con " 3479#~ "archivos de desplazamiento por cuadrícula o la coordenada no se encuentra " 3480#~ "dentro del intervalo para el que se define el desplazamiento de " 3481#~ "cuadrícula. De forma predeterminada, PostGIS lanzará un error si un " 3482#~ "archivo de cambio de cuadrícula no está presente, pero este " 3483#~ "comportamiento se puede configurar sobre una base pre-SRID, ya sea " 3484#~ "probando diferentes valores de <varname>to_proj</varname> del texto " 3485#~ "PROJ.4, o alterando el valor <varname>proj4text</varname> dentro de la " 3486#~ "tabla <varname>spatial_ref_sys</varname>." 3487 3488#~ msgid "" 3489#~ "For example, the proj4text parameter +datum=NAD87 is a shorthand form for " 3490#~ "the following +nadgrids parameter:" 3491#~ msgstr "" 3492#~ "Por ejemplo, el parámetro proj4text +datum=NAD87 es una forma abreviada " 3493#~ "para el parámetro +nadgrids siguiente:" 3494 3495#~ msgid "+nadgrids=@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat" 3496#~ msgstr "+nadgrids=@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat" 3497 3498#~ msgid "" 3499#~ "The @ prefix means no error is reported if the files are not present, but " 3500#~ "if the end of the list is reached with no file having been appropriate " 3501#~ "(ie. found and overlapping) then an error is issued." 3502#~ msgstr "" 3503#~ "El prefijo @ significa que no se reporta ningún error si los archivos no " 3504#~ "están presentes, pero si se llega al final de la lista sin que el archivo " 3505#~ "haya sido apropiado (es decir, se encuentra y se superpone), se emite un " 3506#~ "error." 3507 3508#~ msgid "" 3509#~ "If, conversely, you wanted to ensure that at least the standard files " 3510#~ "were present, but that if all files were scanned without a hit a null " 3511#~ "transformation is applied you could use:" 3512#~ msgstr "" 3513#~ "Si, por el contrario, quería asegurarse de que al menos los archivos " 3514#~ "estándar estaban presentes, pero que si todos los archivos fueron " 3515#~ "escaneados sin un éxito, una transformación nula se podría utilizar:" 3516 3517#~ msgid "+nadgrids=@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat,null" 3518#~ msgstr "+nadgrids=@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat,null" 3519 3520#~ msgid "" 3521#~ "The null grid shift file is a valid grid shift file covering the whole " 3522#~ "world and applying no shift. So for a complete example, if you wanted to " 3523#~ "alter PostGIS so that transformations to SRID 4267 that didn't lie within " 3524#~ "the correct range did not throw an ERROR, you would use the following:" 3525#~ msgstr "" 3526#~ "El archivo de cambio de cuadrícula nulo es un archivo de desplazamiento " 3527#~ "de cuadrícula válido que cubre el mundo entero y no aplica ningún cambio. " 3528#~ "Así que para un ejemplo completo, si quería modificar PostGIS para que " 3529#~ "las transformaciones a SRID 4267 que no se encuentran dentro del rango " 3530#~ "correcto no lanzar un error, se utiliza lo siguiente:" 3531 3532#~ msgid "" 3533#~ "UPDATE spatial_ref_sys SET proj4text = '+proj=longlat +ellps=clrk66 " 3534#~ "+nadgrids=@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat,null +no_defs' WHERE " 3535#~ "srid = 4267;" 3536#~ msgstr "" 3537#~ "UPDATE spatial_ref_sys SET proj4text = '+proj=longlat +ellps=clrk66 " 3538#~ "+nadgrids=@conus,@alaska,@ntv2_0.gsb,@ntv1_can.dat,null +no_defs' WHERE " 3539#~ "srid = 4267;" 3540 3541#~ msgid "" 3542#~ ", <xref linkend=\"ST_AsText\"/>, <xref linkend=\"ST_SetSRID\"/>, <xref " 3543#~ "linkend=\"UpdateGeometrySRID\"/>" 3544#~ msgstr "" 3545#~ ", <xref linkend=\"ST_AsText\"/>, <xref linkend=\"ST_SetSRID\"/>, <xref " 3546#~ "linkend=\"UpdateGeometrySRID\"/>" 3547 3548#~ msgid "ST_Translate" 3549#~ msgstr "ST_Translate" 3550 3551#~ msgid "Translate a geometry by given offsets." 3552#~ msgstr "Trasladar una geometría por desplazamientos dados." 3553 3554#~ msgid "" 3555#~ "<funcprototype> <funcdef>geometry <function>ST_Translate</function></" 3556#~ "funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></" 3557#~ "paramdef> <paramdef><type>float </type> <parameter>deltax</parameter></" 3558#~ "paramdef> <paramdef><type>float </type> <parameter>deltay</parameter></" 3559#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 3560#~ "<function>ST_Translate</function></funcdef> <paramdef><type>geometry </" 3561#~ "type> <parameter>g1</parameter></paramdef> <paramdef><type>float </type> " 3562#~ "<parameter>deltax</parameter></paramdef> <paramdef><type>float </type> " 3563#~ "<parameter>deltay</parameter></paramdef> <paramdef><type>float </type> " 3564#~ "<parameter>deltaz</parameter></paramdef> </funcprototype>" 3565#~ msgstr "" 3566#~ "<funcprototype> <funcdef>geometry <function>ST_Translate</function></" 3567#~ "funcdef> <paramdef><type>geometry </type> <parameter>g1</parameter></" 3568#~ "paramdef> <paramdef><type>float </type> <parameter>deltax</parameter></" 3569#~ "paramdef> <paramdef><type>float </type> <parameter>deltay</parameter></" 3570#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 3571#~ "<function>ST_Translate</function></funcdef> <paramdef><type>geometry </" 3572#~ "type> <parameter>g1</parameter></paramdef> <paramdef><type>float </type> " 3573#~ "<parameter>deltax</parameter></paramdef> <paramdef><type>float </type> " 3574#~ "<parameter>deltay</parameter></paramdef> <paramdef><type>float </type> " 3575#~ "<parameter>deltaz</parameter></paramdef> </funcprototype>" 3576 3577#~ msgid "" 3578#~ "Returns a new geometry whose coordinates are translated delta x,delta y," 3579#~ "delta z units. Units are based on the units defined in spatial reference " 3580#~ "(SRID) for this geometry." 3581#~ msgstr "" 3582#~ "Devuelve una nueva geometría cuyas coordenadas se trasladan en las " 3583#~ "unidades Delta x, Delta y, Delta z. Las unidades se basan en las unidades " 3584#~ "definidas en la referencia espacial (SRID) para esta geometría." 3585 3586#~ msgid "Move a point 1 degree longitude" 3587#~ msgstr "Mover un punto 1 grado de longitud " 3588 3589#~ msgid "" 3590#~ "SELECT ST_AsText(ST_Translate(ST_GeomFromText('POINT(-71.01 " 3591#~ "42.37)',4326),1,0)) As wgs_transgeomtxt;\n" 3592#~ "\n" 3593#~ " wgs_transgeomtxt\n" 3594#~ " ---------------------\n" 3595#~ " POINT(-70.01 42.37)" 3596#~ msgstr "" 3597#~ "SELECT ST_AsText(ST_Translate(ST_GeomFromText('POINT(-71.01 " 3598#~ "42.37)',4326),1,0)) As wgs_transgeomtxt;\n" 3599#~ "\n" 3600#~ " wgs_transgeomtxt\n" 3601#~ " ---------------------\n" 3602#~ " POINT(-70.01 42.37)" 3603 3604#~ msgid "Move a linestring 1 degree longitude and 1/2 degree latitude" 3605#~ msgstr "" 3606#~ "Muever una cadena de línea 1 grados de longitud y 1/2 grado de latitud" 3607 3608#~ msgid "" 3609#~ "SELECT ST_AsText(ST_Translate(ST_GeomFromText('LINESTRING(-71.01 " 3610#~ "42.37,-71.11 42.38)',4326),1,0.5)) As wgs_transgeomtxt;\n" 3611#~ " wgs_transgeomtxt\n" 3612#~ " ---------------------------------------\n" 3613#~ " LINESTRING(-70.01 42.87,-70.11 42.88)" 3614#~ msgstr "" 3615#~ "SELECT ST_AsText(ST_Translate(ST_GeomFromText('LINESTRING(-71.01 " 3616#~ "42.37,-71.11 42.38)',4326),1,0.5)) As wgs_transgeomtxt;\n" 3617#~ " wgs_transgeomtxt\n" 3618#~ " ---------------------------------------\n" 3619#~ " LINESTRING(-70.01 42.87,-70.11 42.88)" 3620 3621#~ msgid "Move a 3d point" 3622#~ msgstr "Mover un punto 3d" 3623 3624#~ msgid "" 3625#~ "SELECT ST_AsEWKT(ST_Translate(CAST('POINT(0 0 0)' As geometry), 5, " 3626#~ "12,3));\n" 3627#~ " st_asewkt\n" 3628#~ " ---------\n" 3629#~ " POINT(5 12 3)" 3630#~ msgstr "" 3631#~ "SELECT ST_AsEWKT(ST_Translate(CAST('POINT(0 0 0)' As geometry), 5, " 3632#~ "12,3));\n" 3633#~ " st_asewkt\n" 3634#~ " ---------\n" 3635#~ " POINT(5 12 3)" 3636 3637#~ msgid "Move a curve and a point" 3638#~ msgstr "Mover una curva y un punto" 3639 3640#~ msgid "" 3641#~ "SELECT ST_AsText(ST_Translate(ST_Collect('CURVEPOLYGON(CIRCULARSTRING(4 " 3642#~ "3,3.12 0.878,1 0,-1.121 5.1213,6 7, 8 9,4 3))','POINT(1 3)'),1,2));\n" 3643#~ " st_astext\n" 3644#~ "------------------------------------------------------------------------------------------------------------\n" 3645#~ " GEOMETRYCOLLECTION(CURVEPOLYGON(CIRCULARSTRING(5 5,4.12 2.878,2 2,-0.121 " 3646#~ "7.1213,7 9,9 11,5 5)),POINT(2 5))" 3647#~ msgstr "" 3648#~ "SELECT ST_AsText(ST_Translate(ST_Collect('CURVEPOLYGON(CIRCULARSTRING(4 " 3649#~ "3,3.12 0.878,1 0,-1.121 5.1213,6 7, 8 9,4 3))','POINT(1 3)'),1,2));\n" 3650#~ " st_astext\n" 3651#~ "------------------------------------------------------------------------------------------------------------\n" 3652#~ " GEOMETRYCOLLECTION(CURVEPOLYGON(CIRCULARSTRING(5 5,4.12 2.878,2 2,-0.121 " 3653#~ "7.1213,7 9,9 11,5 5)),POINT(2 5))" 3654 3655#~ msgid ", <xref linkend=\"ST_AsText\"/>, <xref linkend=\"ST_GeomFromText\"/>" 3656#~ msgstr "" 3657#~ ", <xref linkend=\"ST_AsText\"/>, <xref linkend=\"ST_GeomFromText\"/>" 3658 3659#~ msgid "ST_TransScale" 3660#~ msgstr "ST_TransScale" 3661 3662#~ msgid "Translate a geometry by given factors and offsets." 3663#~ msgstr "Traslada una geometría por factores y offsets dados." 3664 3665#~ msgid "" 3666#~ "<funcdef>geometry <function>ST_TransScale</function></funcdef> " 3667#~ "<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 3668#~ "<paramdef><type>float</type> <parameter>deltaX</parameter></paramdef> " 3669#~ "<paramdef><type>float</type> <parameter>deltaY</parameter></paramdef> " 3670#~ "<paramdef><type>float</type> <parameter>XFactor</parameter></paramdef> " 3671#~ "<paramdef><type>float</type> <parameter>YFactor</parameter></paramdef>" 3672#~ msgstr "" 3673#~ "<funcdef>geometry <function>ST_TransScale</function></funcdef> " 3674#~ "<paramdef><type>geometry </type> <parameter>geomA</parameter></paramdef> " 3675#~ "<paramdef><type>float</type> <parameter>deltaX</parameter></paramdef> " 3676#~ "<paramdef><type>float</type> <parameter>deltaY</parameter></paramdef> " 3677#~ "<paramdef><type>float</type> <parameter>XFactor</parameter></paramdef> " 3678#~ "<paramdef><type>float</type> <parameter>YFactor</parameter></paramdef>" 3679 3680#~ msgid "" 3681#~ "Translates the geometry using the deltaX and deltaY args, then scales it " 3682#~ "using the XFactor, YFactor args, working in 2D only." 3683#~ msgstr "" 3684#~ "Traslada la geometría usando los argumentos deltaX y deltaY y a " 3685#~ "continuación, lo escala utilizando los argumentos XFactor, YFactor, " 3686#~ "trabaja sólo en 2D." 3687 3688#~ msgid "" 3689#~ "<code>ST_TransScale(geomA, deltaX, deltaY, XFactor, YFactor)</code> is " 3690#~ "short-hand for <code>ST_Affine(geomA, XFactor, 0, 0, 0, YFactor, 0, 0, 0, " 3691#~ "1, deltaX*XFactor, deltaY*YFactor, 0)</code>." 3692#~ msgstr "" 3693#~ "<code>ST_TransScale(geomA, deltaX, deltaY, XFactor, YFactor)</code> is " 3694#~ "short-hand for <code>ST_Affine(geomA, XFactor, 0, 0, 0, YFactor, 0, 0, 0, " 3695#~ "1, deltaX*XFactor, deltaY*YFactor, 0)</code>." 3696 3697#~ msgid "" 3698#~ "SELECT ST_AsEWKT(ST_TransScale(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 " 3699#~ "1)'), 0.5, 1, 1, 2));\n" 3700#~ " st_asewkt\n" 3701#~ "-----------------------------\n" 3702#~ " LINESTRING(1.5 6 3,1.5 4 1)\n" 3703#~ "\n" 3704#~ "\n" 3705#~ "--Buffer a point to get an approximation of a circle, convert to curve " 3706#~ "and then translate 1,2 and scale it 3,4\n" 3707#~ " SELECT ST_AsText(ST_Transscale(ST_LineToCurve(ST_Buffer('POINT(234 " 3708#~ "567)', 3)),1,2,3,4));\n" 3709#~ " st_astext\n" 3710#~ "------------------------------------------------------------------------------------------------------------------------------\n" 3711#~ " CURVEPOLYGON(CIRCULARSTRING(714 2276,711.363961030679 " 3712#~ "2267.51471862576,705 2264,698.636038969321 2284.48528137424,714 2276))" 3713#~ msgstr "" 3714#~ "SELECT ST_AsEWKT(ST_TransScale(ST_GeomFromEWKT('LINESTRING(1 2 3, 1 1 " 3715#~ "1)'), 0.5, 1, 1, 2));\n" 3716#~ " st_asewkt\n" 3717#~ "-----------------------------\n" 3718#~ " LINESTRING(1.5 6 3,1.5 4 1)\n" 3719#~ "\n" 3720#~ "\n" 3721#~ "--Buffer de un punto para obtener una aproximación de un círculo, " 3722#~ "convertir a curva y, a continuación, trasladar a 1, 2 y escalar a 3, 4\n" 3723#~ " SELECT ST_AsText(ST_Transscale(ST_LineToCurve(ST_Buffer('POINT(234 " 3724#~ "567)', 3)),1,2,3,4));\n" 3725#~ " st_astext\n" 3726#~ "------------------------------------------------------------------------------------------------------------------------------\n" 3727#~ " CURVEPOLYGON(CIRCULARSTRING(714 2276,711.363961030679 " 3728#~ "2267.51471862576,705 2264,698.636038969321 2284.48528137424,714 2276))" 3729 3730#~ msgid ", <xref linkend=\"ST_Translate\"/>" 3731#~ msgstr ", <xref linkend=\"ST_Translate\"/>" 3732