1# SOME DESCRIPTIVE TITLE. 2# 3# Translators: 4# pibinko <pibinko@gmail.com>, 2014 5# pibinko <pibinko@gmail.com>, 2014 6# Tommaso Di Bucchianico, 2013-2014 7msgid "" 8msgstr "" 9"Project-Id-Version: PostGIS\n" 10"Report-Msgid-Bugs-To: http://bugs.kde.org\n" 11"POT-Creation-Date: 2019-10-06 23:48+0000\n" 12"PO-Revision-Date: 2018-07-23 18:01+0000\n" 13"Last-Translator: Tommaso Di Bucchianico\n" 14"Language-Team: Italian (Italy) (http://www.transifex.com/postgis/postgis/" 15"language/it_IT/)\n" 16"Language: it_IT\n" 17"MIME-Version: 1.0\n" 18"Content-Type: text/plain; charset=UTF-8\n" 19"Content-Transfer-Encoding: 8bit\n" 20"Plural-Forms: nplurals=2; plural=(n != 1);\n" 21 22#. Tag: title 23#: reference_constructor.xml:3 24#, no-c-format 25msgid "Geometry Constructors" 26msgstr "Costruttori geometrici." 27 28#. Tag: refname 29#: reference_constructor.xml:7 30#, fuzzy, no-c-format 31msgid "ST_Collect" 32msgstr "ST_GeomCollFromText" 33 34#. Tag: refpurpose 35#: reference_constructor.xml:8 36#, no-c-format 37msgid "" 38"Creates a GeometryCollection or Multi* geometry from a set of geometries." 39msgstr "" 40 41#. Tag: funcsynopsis 42#: reference_constructor.xml:12 43#, fuzzy, no-c-format 44msgid "" 45"<funcprototype> <funcdef>geometry <function>ST_Collect</function></funcdef> " 46"<paramdef><type>geometry</type> <parameter>g1</parameter></paramdef> " 47"<paramdef><type>geometry</type> <parameter>g2</parameter></paramdef> </" 48"funcprototype> <funcprototype> <funcdef>geometry <function>ST_Collect</" 49"function></funcdef> <paramdef><type>geometry[]</type> <parameter>g1_array</" 50"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 51"<function>ST_Collect</function></funcdef> <paramdef><type>geometry set</" 52"type> <parameter>g1field</parameter></paramdef> </funcprototype>" 53msgstr "" 54"<funcprototype> <funcdef>geometry <function>ST_MakeLine</function></funcdef> " 55"<paramdef><type>geometry set</type> <parameter>geoms</parameter></paramdef> " 56"</funcprototype> <funcprototype> <funcdef>geometry <function>ST_MakeLine</" 57"function></funcdef> <paramdef><type>geometry</type> <parameter>geom1</" 58"parameter></paramdef> <paramdef><type>geometry</type> <parameter>geom2</" 59"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 60"<function>ST_MakeLine</function></funcdef> <paramdef><type>geometry[]</type> " 61"<parameter>geoms_array</parameter></paramdef> </funcprototype>" 62 63#. Tag: title 64#: reference_constructor.xml:30 reference_constructor.xml:109 65#: reference_constructor.xml:154 reference_constructor.xml:203 66#: reference_constructor.xml:307 reference_constructor.xml:353 67#: reference_constructor.xml:407 reference_constructor.xml:489 68#: reference_constructor.xml:547 reference_constructor.xml:605 69#, no-c-format 70msgid "Description" 71msgstr "Descrizione" 72 73#. Tag: para 74#: reference_constructor.xml:31 75#, no-c-format 76msgid "" 77"Collects geometries into a geometry collection. The result is either a " 78"Multi* or a GeometryCollection, depending on whether the input geometries " 79"have the same or different types (homogeneous or heterogeneous). The input " 80"geometries are left unchanged within the collection." 81msgstr "" 82 83#. Tag: para 84#: reference_constructor.xml:38 reference_constructor.xml:208 85#, no-c-format 86msgid "" 87"<emphasis role=\"bold\">Variant 1:</emphasis> accepts two input geometries" 88msgstr "" 89 90#. Tag: para 91#: reference_constructor.xml:39 reference_constructor.xml:209 92#, no-c-format 93msgid "" 94"<emphasis role=\"bold\">Variant 2:</emphasis> accepts an array of geometries" 95msgstr "" 96 97#. Tag: para 98#: reference_constructor.xml:40 99#, no-c-format 100msgid "" 101"<emphasis role=\"bold\">Variant 3:</emphasis> aggregate function accepting a " 102"rowset of geometries." 103msgstr "" 104 105#. Tag: para 106#: reference_constructor.xml:42 107#, no-c-format 108msgid "" 109"If any of the input geometries are collections (Multi* or " 110"GeometryCollection) ST_Collect returns a GeometryCollection (since that is " 111"the only type which can contain nested collections). To prevent this, use " 112"<xref linkend=\"ST_Dump\"/> in a subquery to expand the input collections to " 113"their atomic elements (see example below)." 114msgstr "" 115 116#. Tag: para 117#: reference_constructor.xml:50 118#, no-c-format 119msgid "" 120"ST_Collect and <xref linkend=\"ST_Union\"/> appear similar, but in fact " 121"operate quite differently. ST_Collect aggregates geometries into a " 122"collection without changing them in any way. ST_Union geometrically merges " 123"geometries where they overlap, and splits linestrings at intersections. It " 124"may return single geometries when it dissolves boundaries." 125msgstr "" 126 127#. Tag: para 128#: reference_constructor.xml:57 129#, no-c-format 130msgid "" 131"Availability: 1.4.0 - ST_Collect(geomarray) was introduced. ST_Collect was " 132"enhanced to handle more geometries faster." 133msgstr "" 134 135#. Tag: para 136#: reference_constructor.xml:58 reference_constructor.xml:115 137#: reference_constructor.xml:220 reference_constructor.xml:321 138#: reference_constructor.xml:421 reference_constructor.xml:564 139#, no-c-format 140msgid "&Z_support;" 141msgstr "&Z_support;" 142 143#. Tag: para 144#: reference_constructor.xml:59 145#, no-c-format 146msgid "&curve_support;" 147msgstr "&curve_support;" 148 149#. Tag: title 150#: reference_constructor.xml:63 151#, fuzzy, no-c-format 152msgid "Examples - Two-input variant" 153msgstr "Esempi - uso di XLink" 154 155#. Tag: para 156#: reference_constructor.xml:64 157#, no-c-format 158msgid "Collect 2D points." 159msgstr "" 160 161#. Tag: programlisting 162#: reference_constructor.xml:65 163#, no-c-format 164msgid "" 165"SELECT ST_AsText( ST_Collect( ST_GeomFromText('POINT(1 2)'),\n" 166" ST_GeomFromText('POINT(-2 3)') ));\n" 167"\n" 168"st_astext\n" 169"----------\n" 170"MULTIPOINT(1 2,-2 3)" 171msgstr "" 172 173#. Tag: para 174#: reference_constructor.xml:67 175#, no-c-format 176msgid "Collect 3D points." 177msgstr "" 178 179#. Tag: programlisting 180#: reference_constructor.xml:68 181#, no-c-format 182msgid "" 183"SELECT ST_AsEWKT( ST_Collect( ST_GeomFromEWKT('POINT(1 2 3)'),\n" 184" ST_GeomFromEWKT('POINT(1 2 4)') ) );\n" 185"\n" 186" st_asewkt\n" 187"-------------------------\n" 188" MULTIPOINT(1 2 3,1 2 4)" 189msgstr "" 190 191#. Tag: para 192#: reference_constructor.xml:70 193#, no-c-format 194msgid "Collect curves." 195msgstr "" 196 197#. Tag: programlisting 198#: reference_constructor.xml:71 199#, no-c-format 200msgid "" 201"SELECT ST_AsText( ST_Collect( 'CIRCULARSTRING(220268 150415,220227 " 202"150505,220227 150406)',\n" 203" 'CIRCULARSTRING(220227 150406,2220227 150407,220227 " 204"150406)'));\n" 205"\n" 206" st_astext\n" 207"------------------------------------------------------------------------------------\n" 208"MULTICURVE(CIRCULARSTRING(220268 150415,220227 150505,220227 150406),\n" 209" CIRCULARSTRING(220227 150406,2220227 150407,220227 150406))" 210msgstr "" 211 212#. Tag: title 213#: reference_constructor.xml:74 214#, fuzzy, no-c-format 215msgid "Examples - Array variant" 216msgstr "Esempi - superficie poliedrica" 217 218#. Tag: para 219#: reference_constructor.xml:75 220#, no-c-format 221msgid "Using an array constructor for a subquery." 222msgstr "" 223 224#. Tag: programlisting 225#: reference_constructor.xml:76 226#, no-c-format 227msgid "SELECT ST_Collect( ARRAY( SELECT the_geom FROM sometable ) );" 228msgstr "" 229 230#. Tag: para 231#: reference_constructor.xml:77 232#, no-c-format 233msgid "Using an array constructor for values." 234msgstr "" 235 236#. Tag: programlisting 237#: reference_constructor.xml:78 238#, no-c-format 239msgid "" 240"SELECT ST_AsText( ST_Collect(\n" 241" ARRAY[ ST_GeomFromText('LINESTRING(1 2, 3 4)'),\n" 242" ST_GeomFromText('LINESTRING(3 4, 4 5)') ] )) As " 243"wktcollect;\n" 244"\n" 245"--wkt collect --\n" 246"MULTILINESTRING((1 2,3 4),(3 4,4 5))" 247msgstr "" 248 249#. Tag: title 250#: reference_constructor.xml:81 251#, no-c-format 252msgid "Examples - Aggregate variant" 253msgstr "" 254 255#. Tag: para 256#: reference_constructor.xml:82 257#, no-c-format 258msgid "Creating multiple collections by grouping geometries in a table." 259msgstr "" 260 261#. Tag: programlisting 262#: reference_constructor.xml:83 263#, no-c-format 264msgid "" 265"SELECT stusps, ST_Collect(f.the_geom) as geom\n" 266" FROM (SELECT stusps, (ST_Dump(the_geom)).geom As the_geom\n" 267" FROM\n" 268" somestatetable ) As f\n" 269" GROUP BY stusps" 270msgstr "" 271 272#. Tag: title 273#: reference_constructor.xml:87 reference_constructor.xml:127 274#: reference_constructor.xml:170 reference_constructor.xml:266 275#: reference_constructor.xml:329 reference_constructor.xml:378 276#: reference_constructor.xml:459 reference_constructor.xml:523 277#: reference_constructor.xml:579 reference_constructor.xml:618 278#, no-c-format 279msgid "See Also" 280msgstr "Vedi anche" 281 282#. Tag: para 283#: reference_constructor.xml:88 284#, fuzzy, no-c-format 285msgid ", <xref linkend=\"ST_Union\"/>" 286msgstr ", <xref linkend=\"ST_AsBinary\"/>" 287 288#. Tag: refname 289#: reference_constructor.xml:94 290#, no-c-format 291msgid "ST_LineFromMultiPoint" 292msgstr "ST_LineFromMultiPoint" 293 294#. Tag: refpurpose 295#: reference_constructor.xml:96 296#, no-c-format 297msgid "" 298"<refpurpose>Creates a LineString from a MultiPoint geometry.</refpurpose>" 299msgstr "" 300"<refpurpose>Crea una LineString da una geometria MultiPoint.</refpurpose>" 301 302#. Tag: funcprototype 303#: reference_constructor.xml:101 304#, no-c-format 305msgid "" 306"<funcdef>geometry <function>ST_LineFromMultiPoint</function></funcdef> " 307"<paramdef><type>geometry </type> <parameter>aMultiPoint</parameter></" 308"paramdef>" 309msgstr "" 310"<funcdef>geometry <function>ST_LineFromMultiPoint</function></funcdef> " 311"<paramdef><type>geometry </type> <parameter>aMultiPoint</parameter></" 312"paramdef>" 313 314#. Tag: para 315#: reference_constructor.xml:111 316#, no-c-format 317msgid "<para>Creates a LineString from a MultiPoint geometry.</para>" 318msgstr "<para>Crea una LineString da una geometria MultiPoint.</para>" 319 320#. Tag: para 321#: reference_constructor.xml:113 322#, no-c-format 323msgid "" 324"Use <xref linkend=\"ST_MakeLine\"/> to create lines from Point or LineString " 325"inputs." 326msgstr "" 327 328#. Tag: title 329#: reference_constructor.xml:120 reference_constructor.xml:325 330#: reference_constructor.xml:364 reference_constructor.xml:569 331#, no-c-format 332msgid "Examples" 333msgstr "Esempi" 334 335#. Tag: para 336#: reference_constructor.xml:121 337#, fuzzy, no-c-format 338msgid "Create a 3D line string from a 3D MultiPoint" 339msgstr "<para>Crea una LineString da una geometria MultiPoint.</para>" 340 341#. Tag: programlisting 342#: reference_constructor.xml:122 343#, fuzzy, no-c-format 344msgid "" 345"SELECT ST_AsEWKT( ST_LineFromMultiPoint('MULTIPOINT(1 2 3, 4 5 6, 7 8 " 346"9)') ));\n" 347"\n" 348"--result--\n" 349"LINESTRING(1 2 3,4 5 6,7 8 9)" 350msgstr "" 351"--Crea una 3d line string da un 3d multipoint\n" 352"SELECT ST_AsEWKT(ST_LineFromMultiPoint(ST_GeomFromEWKT('MULTIPOINT(1 2 3, 4 " 353"5 6, 7 8 9)')));\n" 354"--result--\n" 355"LINESTRING(1 2 3,4 5 6,7 8 9)" 356 357#. Tag: para 358#: reference_constructor.xml:129 359#, fuzzy, no-c-format 360msgid ", <xref linkend=\"ST_MakeLine\"/>" 361msgstr ", <xref linkend=\"ST_AsKML\"/>" 362 363#. Tag: refname 364#: reference_constructor.xml:135 365#, no-c-format 366msgid "ST_MakeEnvelope" 367msgstr "ST_MakeEnvelope" 368 369#. Tag: refpurpose 370#: reference_constructor.xml:137 371#, no-c-format 372msgid "Creates a rectangular Polygon from minimum and maximum coordinates." 373msgstr "" 374 375#. Tag: funcprototype 376#: reference_constructor.xml:142 377#, fuzzy, no-c-format 378msgid "" 379"<funcdef>geometry <function>ST_MakeEnvelope</function></funcdef> " 380"<paramdef><type>float</type> <parameter>xmin</parameter></paramdef> " 381"<paramdef><type>float</type> <parameter>ymin</parameter></paramdef> " 382"<paramdef><type>float</type> <parameter>xmax</parameter></paramdef> " 383"<paramdef><type>float</type> <parameter>ymax</parameter></paramdef> " 384"<paramdef choice=\"opt\"><type>integer</type> <parameter>srid=unknown</" 385"parameter></paramdef>" 386msgstr "" 387"<funcdef>geometry <function>ST_MakeEnvelope</function></funcdef> " 388"<paramdef><type>double precision</type> <parameter>xmin</parameter></" 389"paramdef> <paramdef><type>double precision</type> <parameter>ymin</" 390"parameter></paramdef> <paramdef><type>double precision</type> " 391"<parameter>xmax</parameter></paramdef> <paramdef><type>double precision</" 392"type> <parameter>ymax</parameter></paramdef> <paramdef choice=\"opt" 393"\"><type>integer </type> <parameter>srid=unknown</parameter></paramdef>" 394 395#. Tag: para 396#: reference_constructor.xml:156 397#, no-c-format 398msgid "" 399"Creates a rectangular Polygon from the minimum and maximum values for X and " 400"Y. Input values must be in the spatial reference system specified by the " 401"SRID. If no SRID is specified the unknown spatial reference system (SRID 0) " 402"is used." 403msgstr "" 404 405#. Tag: para 406#: reference_constructor.xml:160 407#, no-c-format 408msgid "Availability: 1.5" 409msgstr "Disponibilità: dalla versione 1.5." 410 411#. Tag: para 412#: reference_constructor.xml:161 413#, no-c-format 414msgid "" 415"Enhanced: 2.0: Ability to specify an envelope without specifying an SRID was " 416"introduced." 417msgstr "" 418 419#. Tag: title 420#: reference_constructor.xml:166 421#, no-c-format 422msgid "Example: Building a bounding box polygon" 423msgstr "" 424 425#. Tag: programlisting 426#: reference_constructor.xml:167 427#, fuzzy, no-c-format 428msgid "" 429"SELECT ST_AsText( ST_MakeEnvelope(10, 10, 11, 11, 4326) );\n" 430"\n" 431"st_asewkt\n" 432"-----------\n" 433"POLYGON((10 10, 10 11, 11 11, 11 10, 10 10))" 434msgstr "" 435"SELECT ST_AsText(ST_MakeEnvelope(10, 10, 11, 11, 4326));\n" 436"\n" 437"st_asewkt\n" 438"-----------\n" 439"POLYGON((10 10, 10 11, 11 11, 11 10, 10 10))" 440 441#. Tag: para 442#: reference_constructor.xml:171 443#, fuzzy, no-c-format 444msgid "" 445", <xref linkend=\"ST_MakeLine\"/>, <xref linkend=\"ST_MakePolygon\"/>, <xref " 446"linkend=\"ST_TileEnvelope\"/>" 447msgstr "" 448", <xref linkend=\"ST_MakePoint\"/>, <xref linkend=\"ST_Point\"/>, <xref " 449"linkend=\"ST_SRID\"/>" 450 451#. Tag: refname 452#: reference_constructor.xml:177 453#, no-c-format 454msgid "ST_MakeLine" 455msgstr "ST_MakeLine" 456 457#. Tag: refpurpose 458#: reference_constructor.xml:179 459#, fuzzy, no-c-format 460msgid "Creates a Linestring from Point, MultiPoint, or LineString geometries." 461msgstr "<para>Crea una LineString da una geometria MultiPoint.</para>" 462 463#. Tag: funcsynopsis 464#: reference_constructor.xml:183 465#, fuzzy, no-c-format 466msgid "" 467"<funcprototype> <funcdef>geometry <function>ST_MakeLine</function></funcdef> " 468"<paramdef><type>geometry</type> <parameter>geom1</parameter></paramdef> " 469"<paramdef><type>geometry</type> <parameter>geom2</parameter></paramdef> </" 470"funcprototype> <funcprototype> <funcdef>geometry <function>ST_MakeLine</" 471"function></funcdef> <paramdef><type>geometry[]</type> " 472"<parameter>geoms_array</parameter></paramdef> </funcprototype> " 473"<funcprototype> <funcdef>geometry <function>ST_MakeLine</function></funcdef> " 474"<paramdef><type>geometry set</type> <parameter>geoms</parameter></paramdef> " 475"</funcprototype>" 476msgstr "" 477"<funcprototype> <funcdef>geometry <function>ST_MakeLine</function></funcdef> " 478"<paramdef><type>geometry set</type> <parameter>geoms</parameter></paramdef> " 479"</funcprototype> <funcprototype> <funcdef>geometry <function>ST_MakeLine</" 480"function></funcdef> <paramdef><type>geometry</type> <parameter>geom1</" 481"parameter></paramdef> <paramdef><type>geometry</type> <parameter>geom2</" 482"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 483"<function>ST_MakeLine</function></funcdef> <paramdef><type>geometry[]</type> " 484"<parameter>geoms_array</parameter></paramdef> </funcprototype>" 485 486#. Tag: para 487#: reference_constructor.xml:205 488#, no-c-format 489msgid "" 490"Creates a LineString containing the points of Point, MultiPoint, or " 491"LineString geometries. Other geometry types cause an error." 492msgstr "" 493 494#. Tag: para 495#: reference_constructor.xml:210 496#, no-c-format 497msgid "" 498"<emphasis role=\"bold\">Variant 3:</emphasis> aggregate function accepting a " 499"rowset of geometries. To ensure the order of the input geometries use " 500"<varname>ORDER BY</varname> in the function call, or a subquery with an " 501"<varname>ORDER BY</varname> clause." 502msgstr "" 503 504#. Tag: para 505#: reference_constructor.xml:214 506#, no-c-format 507msgid "" 508"Repeated nodes at the beginning of input LineStrings are collapsed to a " 509"single point. Repeated points in Point and MultiPoint inputs are not " 510"collapsed. <xref linkend=\"ST_RemoveRepeatedPoints\"/> can be used to " 511"collapse repeated points from the output LineString." 512msgstr "" 513 514#. Tag: para 515#: reference_constructor.xml:222 516#, no-c-format 517msgid "" 518"Availability: 2.3.0 - Support for multipoint input elements was introduced" 519msgstr "" 520 521#. Tag: para 522#: reference_constructor.xml:223 523#, no-c-format 524msgid "" 525"Availability: 2.0.0 - Support for linestring input elements was introduced" 526msgstr "" 527 528#. Tag: para 529#: reference_constructor.xml:224 530#, no-c-format 531msgid "" 532"Availability: 1.4.0 - ST_MakeLine(geomarray) was introduced. ST_MakeLine " 533"aggregate functions was enhanced to handle more points faster." 534msgstr "" 535 536#. Tag: title 537#: reference_constructor.xml:229 538#, no-c-format 539msgid "Examples: Two-input variant" 540msgstr "" 541 542#. Tag: para 543#: reference_constructor.xml:231 544#, no-c-format 545msgid "Create a line composed of two points." 546msgstr "" 547 548#. Tag: programlisting 549#: reference_constructor.xml:232 550#, no-c-format 551msgid "" 552"SELECT ST_AsText( ST_MakeLine(ST_MakePoint(1,2), ST_MakePoint(3,4)) );\n" 553"\n" 554" st_astext\n" 555"---------------------\n" 556" LINESTRING(1 2,3 4)" 557msgstr "" 558 559#. Tag: para 560#: reference_constructor.xml:234 561#, fuzzy, no-c-format 562msgid "Create a 3D line from two 3D points." 563msgstr "Crea una BOX3D definita dalle geometrie dei punti 3d dati." 564 565#. Tag: programlisting 566#: reference_constructor.xml:235 567#, no-c-format 568msgid "" 569"SELECT ST_AsEWKT( ST_MakeLine(ST_MakePoint(1,2,3), ST_MakePoint(3,4,5) ));\n" 570"\n" 571" st_asewkt\n" 572"-------------------------\n" 573" LINESTRING(1 2 3,3 4 5)" 574msgstr "" 575 576#. Tag: para 577#: reference_constructor.xml:237 578#, no-c-format 579msgid "Create a line from two disjoint LineStrings." 580msgstr "" 581 582#. Tag: programlisting 583#: reference_constructor.xml:238 584#, no-c-format 585msgid "" 586"select ST_AsText( ST_MakeLine( 'LINESTRING(0 0, 1 1)', 'LINESTRING(2 2, 3 " 587"3)' ) );\n" 588"\n" 589" st_astext\n" 590"-----------------------------\n" 591" LINESTRING(0 0,1 1,2 2,3 3)" 592msgstr "" 593 594#. Tag: title 595#: reference_constructor.xml:242 596#, no-c-format 597msgid "Examples: Array variant" 598msgstr "" 599 600#. Tag: para 601#: reference_constructor.xml:244 602#, no-c-format 603msgid "Create a line from an array formed by a subquery with ordering." 604msgstr "" 605 606#. Tag: programlisting 607#: reference_constructor.xml:245 608#, no-c-format 609msgid "" 610"SELECT ST_MakeLine( ARRAY( SELECT ST_Centroid(the_geom) FROM visit_locations " 611"ORDER BY visit_time) );" 612msgstr "" 613 614#. Tag: para 615#: reference_constructor.xml:247 616#, no-c-format 617msgid "Create a 3D line from an array of 3D points" 618msgstr "" 619 620#. Tag: programlisting 621#: reference_constructor.xml:248 622#, fuzzy, no-c-format 623msgid "" 624"SELECT ST_AsEWKT( ST_MakeLine(\n" 625" ARRAY[ ST_MakePoint(1,2,3), ST_MakePoint(3,4,5), " 626"ST_MakePoint(6,6,6) ] ));\n" 627"\n" 628" st_asewkt\n" 629"-------------------------\n" 630"LINESTRING(1 2 3,3 4 5,6 6 6)" 631msgstr "" 632"SELECT ST_MakeLine(ARRAY(SELECT ST_Centroid(the_geom) FROM visit_locations " 633"ORDER BY visit_time));\n" 634"\n" 635"--Making a 3d line with 3 3-d points\n" 636"SELECT ST_AsEWKT(ST_MakeLine(ARRAY[ST_MakePoint(1,2,3),\n" 637" ST_MakePoint(3,4,5), " 638"ST_MakePoint(6,6,6)]));\n" 639" st_asewkt\n" 640"-------------------------\n" 641"LINESTRING(1 2 3,3 4 5,6 6 6)" 642 643#. Tag: title 644#: reference_constructor.xml:252 645#, no-c-format 646msgid "Examples: Aggregate variant" 647msgstr "" 648 649#. Tag: para 650#: reference_constructor.xml:253 651#, no-c-format 652msgid "" 653"This example queries time-based sequences of GPS points from a set of tracks " 654"and creates one record for each track. The result geometries are LineStrings " 655"composed of the GPS track points in the order of travel." 656msgstr "" 657 658#. Tag: para 659#: reference_constructor.xml:257 660#, no-c-format 661msgid "" 662"Using aggregate <varname>ORDER BY</varname> provides a correctly-ordered " 663"linestring." 664msgstr "" 665 666#. Tag: programlisting 667#: reference_constructor.xml:258 668#, no-c-format 669msgid "" 670"SELECT gps.track_id, ST_MakeLine(gps.geom ORDER BY gps_time) As geom\n" 671" FROM gps_points As gps\n" 672" GROUP BY track_id;" 673msgstr "" 674 675#. Tag: para 676#: reference_constructor.xml:260 677#, no-c-format 678msgid "" 679"Prior to PostgreSQL 9, ordering in a subquery can be used. However, " 680"sometimes the query plan may not respect the order of the subquery." 681msgstr "" 682 683#. Tag: programlisting 684#: reference_constructor.xml:262 685#, no-c-format 686msgid "" 687"SELECT gps.track_id, ST_MakeLine(gps.geom) As geom\n" 688" FROM ( SELECT track_id, gps_time, geom\n" 689" FROM gps_points ORDER BY track_id, gps_time ) As " 690"gps\n" 691" GROUP BY track_id;" 692msgstr "" 693 694#. Tag: para 695#: reference_constructor.xml:267 696#, fuzzy, no-c-format 697msgid "" 698", <xref linkend=\"ST_AsEWKT\"/>, <xref linkend=\"ST_AsText\"/>, <xref " 699"linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_MakePoint\"/>" 700msgstr "" 701", <xref linkend=\"ST_AsText\"/>, <xref linkend=\"ST_GeomFromText\"/>, <xref " 702"linkend=\"ST_MakePoint\"/>" 703 704#. Tag: refname 705#: reference_constructor.xml:274 706#, no-c-format 707msgid "ST_MakePoint" 708msgstr "ST_MakePoint" 709 710#. Tag: refpurpose 711#: reference_constructor.xml:276 712#, no-c-format 713msgid "Creates a 2D, 3DZ or 4D Point." 714msgstr "" 715 716#. Tag: funcprototype 717#: reference_constructor.xml:281 718#, fuzzy, no-c-format 719msgid "" 720"<funcdef>geometry <function>ST_MakePoint</function></funcdef> " 721"<paramdef><type>float</type> <parameter>x</parameter></paramdef> " 722"<paramdef><type>float</type> <parameter>y</parameter></paramdef>" 723msgstr "" 724"<funcdef>geometry <function>ST_Point</function></funcdef> " 725"<paramdef><type>float </type> <parameter>x_lon</parameter></paramdef> " 726"<paramdef><type>float </type> <parameter>y_lat</parameter></paramdef>" 727 728#. Tag: funcprototype 729#: reference_constructor.xml:288 730#, fuzzy, no-c-format 731msgid "" 732"<funcdef>geometry <function>ST_MakePoint</function></funcdef> " 733"<paramdef><type>float</type> <parameter>x</parameter></paramdef> " 734"<paramdef><type>float</type> <parameter>y</parameter></paramdef> " 735"<paramdef><type>float</type> <parameter>z</parameter></paramdef>" 736msgstr "" 737"<funcdef>geometry <function>ST_MakePointM</function></funcdef> " 738"<paramdef><type>float</type> <parameter>x</parameter></paramdef> " 739"<paramdef><type>float</type> <parameter>y</parameter></paramdef> " 740"<paramdef><type>float</type> <parameter>m</parameter></paramdef>" 741 742#. Tag: funcprototype 743#: reference_constructor.xml:296 744#, fuzzy, no-c-format 745msgid "" 746"<funcdef>geometry <function>ST_MakePoint</function></funcdef> " 747"<paramdef><type>float</type> <parameter>x</parameter></paramdef> " 748"<paramdef><type>float</type> <parameter>y</parameter></paramdef> " 749"<paramdef><type>float</type> <parameter>z</parameter></paramdef> " 750"<paramdef><type>float</type> <parameter>m</parameter></paramdef>" 751msgstr "" 752"<funcdef>geometry <function>ST_MakePoint</function></funcdef> " 753"<paramdef><type>double precision</type> <parameter>x</parameter></paramdef> " 754"<paramdef><type>double precision</type> <parameter>y</parameter></paramdef> " 755"<paramdef><type>double precision</type> <parameter>z</parameter></paramdef> " 756"<paramdef><type>double precision</type> <parameter>m</parameter></paramdef>" 757 758#. Tag: para 759#: reference_constructor.xml:309 760#, fuzzy, no-c-format 761msgid "Creates a 2D, 3D Z or 4D ZM Point geometry." 762msgstr "Crea una BOX2D definita dalle geometrie dei punti dati." 763 764#. Tag: para 765#: reference_constructor.xml:311 766#, no-c-format 767msgid "" 768"Use <xref linkend=\"ST_MakePointM\"/> to make points with XYM coordinates." 769msgstr "" 770 771#. Tag: para 772#: reference_constructor.xml:313 773#, no-c-format 774msgid "" 775"While not OGC-compliant, <varname>ST_MakePoint</varname> is faster and more " 776"precise than <xref linkend=\"ST_GeomFromText\"/> and <xref linkend=" 777"\"ST_PointFromText\"/>. It is also easier to use for numeric coordinate " 778"values." 779msgstr "" 780 781#. Tag: para 782#: reference_constructor.xml:319 reference_constructor.xml:359 783#: reference_constructor.xml:493 784#, no-c-format 785msgid "" 786"For geodetic coordinates, <varname>X</varname> is longitude and <varname>Y</" 787"varname> is latitude" 788msgstr "" 789 790#. Tag: programlisting 791#: reference_constructor.xml:326 792#, no-c-format 793msgid "" 794"--Return point with unknown SRID\n" 795"SELECT ST_MakePoint(-71.1043443253471, 42.3150676015829);\n" 796"\n" 797"--Return point marked as WGS 84 long lat\n" 798"SELECT ST_SetSRID(ST_MakePoint(-71.1043443253471, 42.3150676015829),4326);\n" 799"\n" 800"--Return a 3D point (e.g. has altitude)\n" 801"SELECT ST_MakePoint(1, 2,1.5);\n" 802"\n" 803"--Get z of point\n" 804"SELECT ST_Z(ST_MakePoint(1, 2,1.5));\n" 805"result\n" 806"-------\n" 807"1.5" 808msgstr "" 809 810#. Tag: para 811#: reference_constructor.xml:330 812#, no-c-format 813msgid "" 814", <xref linkend=\"ST_PointFromText\"/>, <xref linkend=\"ST_SetSRID\"/>, " 815"<xref linkend=\"ST_MakePointM\"/>" 816msgstr "" 817", <xref linkend=\"ST_PointFromText\"/>, <xref linkend=\"ST_SetSRID\"/>, " 818"<xref linkend=\"ST_MakePointM\"/>" 819 820#. Tag: refname 821#: reference_constructor.xml:336 822#, no-c-format 823msgid "ST_MakePointM" 824msgstr "ST_MakePointM" 825 826#. Tag: refpurpose 827#: reference_constructor.xml:338 828#, no-c-format 829msgid "Creates a Point from X, Y and M values." 830msgstr "" 831 832#. Tag: funcprototype 833#: reference_constructor.xml:343 834#, no-c-format 835msgid "" 836"<funcdef>geometry <function>ST_MakePointM</function></funcdef> " 837"<paramdef><type>float</type> <parameter>x</parameter></paramdef> " 838"<paramdef><type>float</type> <parameter>y</parameter></paramdef> " 839"<paramdef><type>float</type> <parameter>m</parameter></paramdef>" 840msgstr "" 841"<funcdef>geometry <function>ST_MakePointM</function></funcdef> " 842"<paramdef><type>float</type> <parameter>x</parameter></paramdef> " 843"<paramdef><type>float</type> <parameter>y</parameter></paramdef> " 844"<paramdef><type>float</type> <parameter>m</parameter></paramdef>" 845 846#. Tag: para 847#: reference_constructor.xml:355 848#, no-c-format 849msgid "Creates a point with X, Y and M (measure) coordinates." 850msgstr "" 851 852#. Tag: para 853#: reference_constructor.xml:357 854#, no-c-format 855msgid "" 856"Use <xref linkend=\"ST_MakePoint\"/> to make points with XY, XYZ, or XYZM " 857"coordinates." 858msgstr "" 859 860#. Tag: para 861#: reference_constructor.xml:365 862#, no-c-format 863msgid "" 864"is used for text output because <xref linkend=\"ST_AsText\"/> does not " 865"support M values." 866msgstr "" 867 868#. Tag: para 869#: reference_constructor.xml:368 870#, no-c-format 871msgid "Create point with unknown SRID." 872msgstr "" 873 874#. Tag: programlisting 875#: reference_constructor.xml:369 876#, no-c-format 877msgid "" 878"SELECT ST_AsEWKT( ST_MakePointM(-71.1043443253471, 42.3150676015829, " 879"10) );\n" 880"\n" 881" st_asewkt\n" 882"-----------------------------------------------\n" 883" POINTM(-71.1043443253471 42.3150676015829 10)" 884msgstr "" 885 886#. Tag: para 887#: reference_constructor.xml:371 888#, no-c-format 889msgid "Create point with a measure in the WGS 84 geodetic coordinate system." 890msgstr "" 891 892#. Tag: programlisting 893#: reference_constructor.xml:372 894#, no-c-format 895msgid "" 896"SELECT ST_AsEWKT( ST_SetSRID( ST_MakePointM(-71.104, 42.315, 10), 4326));\n" 897"\n" 898" st_asewkt\n" 899"---------------------------------------------------------\n" 900"SRID=4326;POINTM(-71.104 42.315 10)" 901msgstr "" 902 903#. Tag: para 904#: reference_constructor.xml:374 905#, no-c-format 906msgid "Get measure of created point." 907msgstr "" 908 909#. Tag: programlisting 910#: reference_constructor.xml:375 911#, no-c-format 912msgid "" 913"SELECT ST_M( ST_MakePointM(-71.104, 42.315, 10) );\n" 914"\n" 915"result\n" 916"-------\n" 917"10" 918msgstr "" 919 920#. Tag: para 921#: reference_constructor.xml:379 922#, no-c-format 923msgid ", <xref linkend=\"ST_MakePoint\"/>, <xref linkend=\"ST_SetSRID\"/>" 924msgstr ", <xref linkend=\"ST_MakePoint\"/>, <xref linkend=\"ST_SetSRID\"/>" 925 926#. Tag: refname 927#: reference_constructor.xml:385 928#, no-c-format 929msgid "ST_MakePolygon" 930msgstr "ST_MakePolygon" 931 932#. Tag: refpurpose 933#: reference_constructor.xml:387 934#, no-c-format 935msgid "Creates a Polygon from a shell and optional list of holes." 936msgstr "" 937 938#. Tag: funcprototype 939#: reference_constructor.xml:392 940#, no-c-format 941msgid "" 942"<funcdef>geometry <function>ST_MakePolygon</function></funcdef> " 943"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef>" 944msgstr "" 945"<funcdef>geometry <function>ST_MakePolygon</function></funcdef> " 946"<paramdef><type>geometry</type> <parameter>linestring</parameter></paramdef>" 947 948#. Tag: funcprototype 949#: reference_constructor.xml:398 950#, no-c-format 951msgid "" 952"<funcdef>geometry <function>ST_MakePolygon</function></funcdef> " 953"<paramdef><type>geometry</type> <parameter>outerlinestring</parameter></" 954"paramdef> <paramdef><type>geometry[]</type> <parameter>interiorlinestrings</" 955"parameter></paramdef>" 956msgstr "" 957"<funcdef>geometry <function>ST_MakePolygon</function></funcdef> " 958"<paramdef><type>geometry</type> <parameter>outerlinestring</parameter></" 959"paramdef> <paramdef><type>geometry[]</type> <parameter>interiorlinestrings</" 960"parameter></paramdef>" 961 962#. Tag: para 963#: reference_constructor.xml:409 964#, no-c-format 965msgid "" 966"Creates a Polygon formed by the given shell and optional array of holes. " 967"Input geometries must be closed LineStrings (rings)." 968msgstr "" 969 970#. Tag: para 971#: reference_constructor.xml:412 972#, no-c-format 973msgid "" 974"<emphasis role=\"bold\">Variant 1:</emphasis> Accepts one shell LineString." 975msgstr "" 976 977#. Tag: para 978#: reference_constructor.xml:413 979#, no-c-format 980msgid "" 981"<emphasis role=\"bold\">Variant 2:</emphasis> Accepts a shell LineString and " 982"an array of inner (hole) LineStrings. A geometry array can be constructed " 983"using the PostgreSQL array_agg(), ARRAY[] or ARRAY() constructs." 984msgstr "" 985 986#. Tag: para 987#: reference_constructor.xml:417 reference_constructor.xml:558 988#, no-c-format 989msgid "" 990"This function does not accept MultiLineStrings. Use <xref linkend=" 991"\"ST_LineMerge\"/> to generate a LineString, or <xref linkend=\"ST_Dump\"/> " 992"to extract LineStrings." 993msgstr "" 994 995#. Tag: title 996#: reference_constructor.xml:425 997#, no-c-format 998msgid "Examples: Single input variant" 999msgstr "" 1000 1001#. Tag: para 1002#: reference_constructor.xml:426 1003#, no-c-format 1004msgid "Create a Polygon from a 2D LineString." 1005msgstr "" 1006 1007#. Tag: programlisting 1008#: reference_constructor.xml:427 1009#, fuzzy, no-c-format 1010msgid "" 1011"SELECT ST_MakePolygon( ST_GeomFromText('LINESTRING(75 29,77 29,77 29, 75 " 1012"29)'));" 1013msgstr "SELECT ST_MLineFromText('MULTILINESTRING((1 2, 3 4), (4 5, 6 7))');" 1014 1015#. Tag: para 1016#: reference_constructor.xml:429 1017#, no-c-format 1018msgid "" 1019"Create a Polygon from an open LineString, using <xref linkend=\"ST_StartPoint" 1020"\"/> and <xref linkend=\"ST_AddPoint\"/> to close it." 1021msgstr "" 1022 1023#. Tag: programlisting 1024#: reference_constructor.xml:431 1025#, no-c-format 1026msgid "" 1027"SELECT ST_MakePolygon( ST_AddPoint(foo.open_line, ST_StartPoint(foo." 1028"open_line)) )\n" 1029"FROM (\n" 1030" SELECT ST_GeomFromText('LINESTRING(75 29,77 29,77 29, 75 29)') As " 1031"open_line) As foo;" 1032msgstr "" 1033 1034#. Tag: para 1035#: reference_constructor.xml:433 1036#, no-c-format 1037msgid "Create a Polygon from a 3D LineString" 1038msgstr "" 1039 1040#. Tag: programlisting 1041#: reference_constructor.xml:434 1042#, no-c-format 1043msgid "" 1044"SELECT ST_AsEWKT( ST_MakePolygon( 'LINESTRING(75.15 29.53 1,77 29 1,77.6 " 1045"29.5 1, 75.15 29.53 1)'));\n" 1046"\n" 1047"st_asewkt\n" 1048"-----------\n" 1049"POLYGON((75.15 29.53 1,77 29 1,77.6 29.5 1,75.15 29.53 1))" 1050msgstr "" 1051 1052#. Tag: para 1053#: reference_constructor.xml:435 1054#, no-c-format 1055msgid "Create a Polygon from a LineString with measures" 1056msgstr "" 1057 1058#. Tag: programlisting 1059#: reference_constructor.xml:436 1060#, no-c-format 1061msgid "" 1062"SELECT ST_AsEWKT( ST_MakePolygon( 'LINESTRINGM(75.15 29.53 1,77 29 1,77.6 " 1063"29.5 2, 75.15 29.53 2)' ));\n" 1064"\n" 1065"st_asewkt\n" 1066"----------\n" 1067"POLYGONM((75.15 29.53 1,77 29 1,77.6 29.5 2,75.15 29.53 2))" 1068msgstr "" 1069 1070#. Tag: title 1071#: reference_constructor.xml:439 1072#, no-c-format 1073msgid "Examples: Outer shell with inner holes variant" 1074msgstr "" 1075 1076#. Tag: para 1077#: reference_constructor.xml:441 1078#, no-c-format 1079msgid "Create a donut Polygon with an extra hole" 1080msgstr "" 1081 1082#. Tag: programlisting 1083#: reference_constructor.xml:442 1084#, fuzzy, no-c-format 1085msgid "" 1086"SELECT ST_MakePolygon( ST_ExteriorRing( ST_Buffer(ring.line,10)),\n" 1087" ARRAY[ ST_Translate(ring.line, 1, 1),\n" 1088" ST_ExteriorRing(ST_Buffer(ST_MakePoint(20,20),1)) ]\n" 1089" )\n" 1090"FROM (SELECT ST_ExteriorRing(\n" 1091" ST_Buffer(ST_MakePoint(10,10),10,10)) AS line ) AS ring;" 1092msgstr "" 1093"SELECT ST_MakePolygon(\n" 1094" ST_ExteriorRing(ST_Buffer(foo.line,10)),\n" 1095" ARRAY[ST_Translate(foo.line,1,1),\n" 1096" ST_ExteriorRing(ST_Buffer(ST_MakePoint(20,20),1)) ]\n" 1097" )\n" 1098"FROM\n" 1099" (SELECT ST_ExteriorRing(ST_Buffer(ST_MakePoint(10,10),10,10))\n" 1100" As line )\n" 1101" As foo;" 1102 1103#. Tag: para 1104#: reference_constructor.xml:443 1105#, no-c-format 1106msgid "" 1107"Create a set of province boundaries with holes representing lakes. The input " 1108"is a table of province Polygons/MultiPolygons and a table of water " 1109"linestrings. Using a LEFT JOIN ensures all provinces are included even if " 1110"they have no lakes." 1111msgstr "" 1112 1113#. Tag: para 1114#: reference_constructor.xml:449 1115#, no-c-format 1116msgid "" 1117"The CASE construct is used because passing a null array into ST_MakePolygon " 1118"results in a NULL return value." 1119msgstr "" 1120 1121#. Tag: programlisting 1122#: reference_constructor.xml:452 1123#, no-c-format 1124msgid "" 1125"SELECT p.gid, p.province_name,\n" 1126" CASE WHEN array_agg(w.the_geom) IS NULL\n" 1127" THEN p.the_geom\n" 1128" ELSE ST_MakePolygon( ST_LineMerge(ST_Boundary(p.the_geom)), " 1129"array_agg(w.the_geom)) END\n" 1130" FROM\n" 1131" provinces p LEFT JOIN waterlines w\n" 1132" ON (ST_Within(w.the_geom, p.the_geom) AND " 1133"ST_IsClosed(w.the_geom))\n" 1134" GROUP BY p.gid, p.province_name, p.the_geom;" 1135msgstr "" 1136 1137#. Tag: para 1138#: reference_constructor.xml:454 1139#, no-c-format 1140msgid "" 1141"Another technique is to utilize a correlated subquery and the ARRAY() " 1142"constructor that converts a row set to an array." 1143msgstr "" 1144 1145#. Tag: programlisting 1146#: reference_constructor.xml:456 1147#, fuzzy, no-c-format 1148msgid "" 1149"SELECT p.gid, p.province_name,\n" 1150" CASE WHEN EXISTS( SELECT w.the_geom\n" 1151" FROM waterlines w\n" 1152" WHERE ST_Within(w.the_geom, p.the_geom)\n" 1153" AND ST_IsClosed(w.the_geom))\n" 1154" THEN ST_MakePolygon(\n" 1155" ST_LineMerge(ST_Boundary(p.the_geom)),\n" 1156" ARRAY( SELECT w.the_geom\n" 1157" FROM waterlines w\n" 1158" WHERE ST_Within(w.the_geom, p.the_geom)\n" 1159" AND ST_IsClosed(w.the_geom)))\n" 1160" ELSE p.the_geom\n" 1161" END AS the_geom\n" 1162" FROM provinces p;" 1163msgstr "" 1164"SELECT p.gid, p.province_name,\n" 1165" CASE WHEN\n" 1166" ST_Accum(w.the_geom) IS NULL THEN p.the_geom\n" 1167" ELSE ST_MakePolygon(ST_LineMerge(ST_Boundary(p.the_geom)), " 1168"ST_Accum(w.the_geom)) END\n" 1169" FROM\n" 1170" provinces p LEFT JOIN waterlines w\n" 1171" ON (ST_Within(w.the_geom, p.the_geom) AND " 1172"ST_IsClosed(w.the_geom))\n" 1173" GROUP BY p.gid, p.province_name, p.the_geom;\n" 1174"\n" 1175" -- Stesso esempio di cui sopra, ma con una sottoquery correlata\n" 1176" -- e la funzione PostgreSQL ARRAY() che converte il set di record in " 1177"un vettore\n" 1178"\n" 1179" SELECT p.gid, p.province_name, CASE WHEN\n" 1180" EXISTS(SELECT w.the_geom\n" 1181" FROM waterlines w\n" 1182" WHERE ST_Within(w.the_geom, p.the_geom)\n" 1183" AND ST_IsClosed(w.the_geom))\n" 1184" THEN\n" 1185" ST_MakePolygon(ST_LineMerge(ST_Boundary(p.the_geom)),\n" 1186" ARRAY(SELECT w.the_geom\n" 1187" FROM waterlines w\n" 1188" WHERE ST_Within(w.the_geom, p.the_geom)\n" 1189" AND ST_IsClosed(w.the_geom)))\n" 1190" ELSE p.the_geom END As the_geom\n" 1191" FROM\n" 1192" provinces p;" 1193 1194#. Tag: para 1195#: reference_constructor.xml:460 1196#, fuzzy, no-c-format 1197msgid "" 1198", <xref linkend=\"ST_AddPoint\"/>, <xref linkend=\"ST_IsClosed\"/>, <xref " 1199"linkend=\"ST_LineMerge\"/>, <xref linkend=\"ST_StartPoint\"/>, <xref linkend=" 1200"\"ST_BuildArea\"/>" 1201msgstr "" 1202", <xref linkend=\"ST_AsText\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>, <xref " 1203"linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_LineMerge\"/>, <xref " 1204"linkend=\"ST_MakePolygon\"/>" 1205 1206#. Tag: refname 1207#: reference_constructor.xml:473 1208#, no-c-format 1209msgid "ST_Point" 1210msgstr "ST_Point" 1211 1212#. Tag: refpurpose 1213#: reference_constructor.xml:475 1214#, no-c-format 1215msgid "" 1216"Creates a Point with the given coordinate values. Alias for ST_MakePoint." 1217msgstr "" 1218 1219#. Tag: funcprototype 1220#: reference_constructor.xml:480 1221#, fuzzy, no-c-format 1222msgid "" 1223"<funcdef>geometry <function>ST_Point</function></funcdef> " 1224"<paramdef><type>float</type> <parameter>x</parameter></paramdef> " 1225"<paramdef><type>float</type> <parameter>y</parameter></paramdef>" 1226msgstr "" 1227"<funcdef>geometry <function>ST_Point</function></funcdef> " 1228"<paramdef><type>float </type> <parameter>x_lon</parameter></paramdef> " 1229"<paramdef><type>float </type> <parameter>y_lat</parameter></paramdef>" 1230 1231#. Tag: para 1232#: reference_constructor.xml:491 1233#, no-c-format 1234msgid "" 1235"Returns an Point with the given X and Y coordinate values. This is the SQL-" 1236"MM alias for <xref linkend=\"ST_MakePoint\"/> that takes just X and Y." 1237msgstr "" 1238 1239#. Tag: para 1240#: reference_constructor.xml:495 1241#, no-c-format 1242msgid "&sqlmm_compliant; SQL-MM 3: 6.1.2" 1243msgstr "&sqlmm_compliant; SQL-MM 3: 6.1.2" 1244 1245#. Tag: title 1246#: reference_constructor.xml:501 1247#, no-c-format 1248msgid "Examples: Geometry" 1249msgstr "" 1250 1251#. Tag: programlisting 1252#: reference_constructor.xml:503 1253#, fuzzy, no-c-format 1254msgid "SELECT ST_SetSRID( ST_Point( -71.104, 42.315), 4326)" 1255msgstr "SELECT ST_SetSRID(ST_Point(-71.1043443253471, 42.3150676015829),4326)" 1256 1257#. Tag: title 1258#: reference_constructor.xml:507 1259#, no-c-format 1260msgid "Examples: Geography" 1261msgstr "" 1262 1263#. Tag: programlisting 1264#: reference_constructor.xml:509 1265#, fuzzy, no-c-format 1266msgid "" 1267"SELECT CAST(ST_SetSRID( ST_Point( -71.104, 42.315), 4326) AS geography);" 1268msgstr "" 1269"SELECT CAST(ST_SetSRID(ST_Point(-71.1043443253471, 42.3150676015829),4326) " 1270"As geography);" 1271 1272#. Tag: para 1273#: reference_constructor.xml:511 1274#, no-c-format 1275msgid "" 1276"PostgreSQL also provides the <varname>::</varname> short-hand for casting" 1277msgstr "" 1278 1279#. Tag: programlisting 1280#: reference_constructor.xml:512 1281#, fuzzy, no-c-format 1282msgid "SELECT ST_SetSRID( ST_Point( -71.104, 42.315), 4326)::geography;" 1283msgstr "" 1284"SELECT CAST(ST_SetSRID(ST_Point(-71.1043443253471, 42.3150676015829),4326) " 1285"As geography);" 1286 1287#. Tag: para 1288#: reference_constructor.xml:514 1289#, no-c-format 1290msgid "" 1291"If the point coordinates are not in a geodetic coordinate system (such as " 1292"WGS84), then they must be reprojected before casting to a geography. In this " 1293"example a point in Pennsylvania State Plane feet (SRID 2273) is projected to " 1294"WGS84 (SRID 4326)." 1295msgstr "" 1296 1297#. Tag: programlisting 1298#: reference_constructor.xml:518 1299#, fuzzy, no-c-format 1300msgid "" 1301"SELECT ST_Transform(ST_SetSRID( ST_Point( 3637510, 3014852 ), 2273), 4326)::" 1302"geography;" 1303msgstr "" 1304"SELECT CAST(ST_SetSRID(ST_Point(-71.1043443253471, 42.3150676015829),4326) " 1305"As geography);" 1306 1307#. Tag: para 1308#: reference_constructor.xml:525 1309#, no-c-format 1310msgid "" 1311", <xref linkend=\"ST_MakePoint\"/>, <xref linkend=\"ST_SetSRID\"/>, <xref " 1312"linkend=\"ST_Transform\"/>" 1313msgstr "" 1314", <xref linkend=\"ST_MakePoint\"/>, <xref linkend=\"ST_SetSRID\"/>, <xref " 1315"linkend=\"ST_Transform\"/>" 1316 1317#. Tag: refname 1318#: reference_constructor.xml:531 1319#, no-c-format 1320msgid "ST_Polygon" 1321msgstr "ST_Polygon" 1322 1323#. Tag: refpurpose 1324#: reference_constructor.xml:533 1325#, no-c-format 1326msgid "Creates a Polygon from a LineString with a specified SRID." 1327msgstr "" 1328 1329#. Tag: funcprototype 1330#: reference_constructor.xml:538 1331#, fuzzy, no-c-format 1332msgid "" 1333"<funcdef>geometry <function>ST_Polygon</function></funcdef> " 1334"<paramdef><type>geometry </type> <parameter>lineString</parameter></" 1335"paramdef> <paramdef><type>integer </type> <parameter>srid</parameter></" 1336"paramdef>" 1337msgstr "" 1338"<funcdef>geometry <function>ST_Polygon</function></funcdef> " 1339"<paramdef><type>geometry </type> <parameter>aLineString</parameter></" 1340"paramdef> <paramdef><type>integer </type> <parameter>srid</parameter></" 1341"paramdef>" 1342 1343#. Tag: para 1344#: reference_constructor.xml:549 1345#, no-c-format 1346msgid "" 1347"Returns a polygon built from the given LineString and sets the spatial " 1348"reference system from the <varname>srid</varname>." 1349msgstr "" 1350 1351#. Tag: para 1352#: reference_constructor.xml:552 1353#, no-c-format 1354msgid "" 1355"ST_Polygon is similar to <xref linkend=\"ST_MakePolygon\"/> Variant 1 with " 1356"the addition of setting the SRID." 1357msgstr "" 1358 1359#. Tag: para 1360#: reference_constructor.xml:554 1361#, fuzzy, no-c-format 1362msgid "" 1363"To create polygons with holes use <xref linkend=\"ST_MakePolygon\"/> Variant " 1364"2 and then <xref linkend=\"ST_SetSRID\"/>." 1365msgstr ", <xref linkend=\"ST_MakePoint\"/>, <xref linkend=\"ST_SetSRID\"/>" 1366 1367#. Tag: para 1368#: reference_constructor.xml:562 1369#, no-c-format 1370msgid "&sfs_compliant;" 1371msgstr "&sfs_compliant;" 1372 1373#. Tag: para 1374#: reference_constructor.xml:563 1375#, no-c-format 1376msgid "&sqlmm_compliant; SQL-MM 3: 8.3.2" 1377msgstr "&sqlmm_compliant; SQL-MM 3: 8.3.2" 1378 1379#. Tag: para 1380#: reference_constructor.xml:571 1381#, no-c-format 1382msgid "Create a 2D polygon." 1383msgstr "" 1384 1385#. Tag: programlisting 1386#: reference_constructor.xml:572 1387#, no-c-format 1388msgid "" 1389"SELECT ST_AsText( ST_Polygon('LINESTRING(75 29, 77 29, 77 29, 75 29)'::" 1390"geometry, 4326) );\n" 1391"\n" 1392"-- result --\n" 1393"POLYGON((75 29, 77 29, 77 29, 75 29))" 1394msgstr "" 1395 1396#. Tag: para 1397#: reference_constructor.xml:573 1398#, no-c-format 1399msgid "Create a 3D polygon." 1400msgstr "" 1401 1402#. Tag: programlisting 1403#: reference_constructor.xml:574 1404#, no-c-format 1405msgid "" 1406"SELECT ST_AsEWKT( ST_Polygon( ST_GeomFromEWKT('LINESTRING(75 29 1, 77 29 2, " 1407"77 29 3, 75 29 1)'), 4326) );\n" 1408"\n" 1409"-- result --\n" 1410"SRID=4326;POLYGON((75 29 1, 77 29 2, 77 29 3, 75 29 1))" 1411msgstr "" 1412 1413#. Tag: para 1414#: reference_constructor.xml:581 1415#, no-c-format 1416msgid "" 1417", <xref linkend=\"ST_AsText\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>, <xref " 1418"linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_LineMerge\"/>, <xref " 1419"linkend=\"ST_MakePolygon\"/>" 1420msgstr "" 1421", <xref linkend=\"ST_AsText\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>, <xref " 1422"linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_LineMerge\"/>, <xref " 1423"linkend=\"ST_MakePolygon\"/>" 1424 1425#. Tag: refname 1426#: reference_constructor.xml:588 1427#, fuzzy, no-c-format 1428msgid "ST_TileEnvelope" 1429msgstr "ST_MakeEnvelope" 1430 1431#. Tag: refpurpose 1432#: reference_constructor.xml:589 1433#, no-c-format 1434msgid "" 1435"Creates a rectangular Polygon in <ulink url=\"https://en.wikipedia.org/wiki/" 1436"Web_Mercator_projection\">Web Mercator</ulink> (SRID:3857) using the <ulink " 1437"url=\"https://en.wikipedia.org/wiki/Tiled_web_map\">XYZ tile system</ulink>." 1438msgstr "" 1439 1440#. Tag: funcprototype 1441#: reference_constructor.xml:594 1442#, fuzzy, no-c-format 1443msgid "" 1444"<funcdef>geometry <function>ST_TileEnvelope</function></funcdef> " 1445"<paramdef><type>integer</type> <parameter>tileZoom</parameter></paramdef> " 1446"<paramdef><type>integer</type> <parameter>tileX</parameter></paramdef> " 1447"<paramdef><type>integer</type> <parameter>tileY</parameter></paramdef> " 1448"<paramdef choice=\"opt\"><type>geometry</type> <parameter>bounds=SRID=3857;" 1449"LINESTRING(-20037508.342789 -20037508.342789,20037508.342789 " 1450"20037508.342789)</parameter></paramdef>" 1451msgstr "" 1452"<funcdef>geometry <function>ST_MakePoint</function></funcdef> " 1453"<paramdef><type>double precision</type> <parameter>x</parameter></paramdef> " 1454"<paramdef><type>double precision</type> <parameter>y</parameter></paramdef> " 1455"<paramdef><type>double precision</type> <parameter>z</parameter></paramdef> " 1456"<paramdef><type>double precision</type> <parameter>m</parameter></paramdef>" 1457 1458#. Tag: para 1459#: reference_constructor.xml:607 1460#, no-c-format 1461msgid "" 1462"Creates a rectangular Polygon in <ulink url=\"https://en.wikipedia.org/wiki/" 1463"Web_Mercator_projection\">Web Mercator</ulink> (SRID:3857) using the <ulink " 1464"url=\"https://en.wikipedia.org/wiki/Tiled_web_map\">XYZ tile system</ulink>. " 1465"By default, the bounds are the in EPSG:3857 using the standard range of the " 1466"Web Mercator system (-20037508.342789, 20037508.342789). The optional bounds " 1467"parameter can be used to generate envelopes for any tiling scheme: provide a " 1468"geometry that has the SRID and extent of the initial \"zoom level zero\" " 1469"square within which the tile system is to be inscribed." 1470msgstr "" 1471 1472#. Tag: para 1473#: reference_constructor.xml:609 1474#, fuzzy, no-c-format 1475msgid "Availability: 3.0" 1476msgstr "Disponibilità: dalla versione 1.5." 1477 1478#. Tag: title 1479#: reference_constructor.xml:614 1480#, no-c-format 1481msgid "Example: Building a tile envelope" 1482msgstr "" 1483 1484#. Tag: programlisting 1485#: reference_constructor.xml:615 1486#, no-c-format 1487msgid "" 1488"SELECT ST_AsText( ST_TileEnvelope(2, 1, 1) );\n" 1489"\n" 1490" st_astext\n" 1491"------------------------------\n" 1492" POLYGON((-10018754.1713945 0,-10018754.1713945 10018754.1713945,0 " 1493"10018754.1713945,0 0,-10018754.1713945 0))\n" 1494"\n" 1495"SELECT ST_AsText( ST_TileEnvelope(3, 1, 1, ST_MakeEnvelope(-180, -90, 180, " 1496"90, 4326) ) );\n" 1497"\n" 1498" st_astext \n" 1499"------------------------------------------------------\n" 1500" POLYGON((-135 45,-135 67.5,-90 67.5,-90 45,-135 45))" 1501msgstr "" 1502 1503#~ msgid "ST_BdPolyFromText" 1504#~ msgstr "ST_BdPolyFromText" 1505 1506#~ msgid "" 1507#~ "<refpurpose>Construct a Polygon given an arbitrary collection of closed " 1508#~ "linestrings as a MultiLineString Well-Known text representation.</" 1509#~ "refpurpose>" 1510#~ msgstr "" 1511#~ "<refpurpose>Costruisce un poligono an partire da una collezione " 1512#~ "arbitraria di linee chiuse in forma di multilinee rappresentate come " 1513#~ "testo Well-Known</refpurpose>" 1514 1515#~ msgid "" 1516#~ "<funcdef>geometry <function>ST_BdPolyFromText</function></funcdef> " 1517#~ "<paramdef><type>text </type> <parameter>WKT</parameter></paramdef> " 1518#~ "<paramdef><type>integer </type> <parameter>srid</parameter></paramdef>" 1519#~ msgstr "" 1520#~ "<funcdef>geometry <function>ST_BdPolyFromText</function></funcdef> " 1521#~ "<paramdef><type>text </type> <parameter>WKT</parameter></paramdef> " 1522#~ "<paramdef><type>integer </type> <parameter>srid</parameter></paramdef>" 1523 1524#~ msgid "" 1525#~ "<para>Construct a Polygon given an arbitrary collection of closed " 1526#~ "linestrings as a MultiLineString Well-Known text representation.</para>" 1527#~ msgstr "" 1528#~ "<para>Costruisce un poligono an partire da una collezione arbitraria di " 1529#~ "linee chiuse in forma di multilinee rappresentate come testo Well-Known</" 1530#~ "para>" 1531 1532#~ msgid "" 1533#~ "Throws an error if WKT is not a MULTILINESTRING. Throws an error if " 1534#~ "output is a MULTIPOLYGON; use ST_BdMPolyFromText in that case, or see " 1535#~ "ST_BuildArea() for a postgis-specific approach." 1536#~ msgstr "" 1537#~ "Ritorna un errore se il testo WKT non è una MULTILINESTRING oppure se " 1538#~ "l'output è un MULTIPOLYGON; in questo caso si può usare " 1539#~ "ST_BdMPolyFromText oppure ST_BuildArea() per un approccio specifica " 1540#~ "postgis." 1541 1542#~ msgid "&sfs_compliant; s3.2.6.2" 1543#~ msgstr "&sfs_compliant; s3.2.6.2" 1544 1545#~ msgid "Availability: 1.1.0 - requires GEOS >= 2.1.0." 1546#~ msgstr "Disponibilità: 1.1.0 - richiede GEOS >= 2.1.0." 1547 1548#~ msgid "Forthcoming" 1549#~ msgstr "In preparazione" 1550 1551#~ msgid ", <xref linkend=\"ST_BdMPolyFromText\"/>" 1552#~ msgstr ", <xref linkend=\"ST_BdMPolyFromText\"/>" 1553 1554#~ msgid "ST_BdMPolyFromText" 1555#~ msgstr "ST_BdMPolyFromText" 1556 1557#~ msgid "" 1558#~ "Construct a MultiPolygon given an arbitrary collection of closed " 1559#~ "linestrings as a MultiLineString text representation Well-Known text " 1560#~ "representation." 1561#~ msgstr "" 1562#~ "Costruisce un MultiPolygon a partire da una collezione arbitraria di " 1563#~ "linee chiuse sotto forma di MultiLineString in formato Well-Known-Text." 1564 1565#~ msgid "" 1566#~ "<funcdef>geometry <function>ST_BdMPolyFromText</function></funcdef> " 1567#~ "<paramdef><type>text </type> <parameter>WKT</parameter></paramdef> " 1568#~ "<paramdef><type>integer </type> <parameter>srid</parameter></paramdef>" 1569#~ msgstr "" 1570#~ "<funcdef>geometry <function>ST_BdMPolyFromText</function></funcdef> " 1571#~ "<paramdef><type>text </type> <parameter>WKT</parameter></paramdef> " 1572#~ "<paramdef><type>integer </type> <parameter>srid</parameter></paramdef>" 1573 1574#~ msgid "" 1575#~ "Construct a Polygon given an arbitrary collection of closed linestrings, " 1576#~ "polygons, MultiLineStrings as Well-Known text representation." 1577#~ msgstr "" 1578#~ "Costruisse un poligono a partire da una collezione arbitraria di linee " 1579#~ "chiuse, poligoni e MultiLineString in formato Well-Known-Text." 1580 1581#~ msgid "" 1582#~ "Throws an error if WKT is not a MULTILINESTRING. Forces MULTIPOLYGON " 1583#~ "output even when result is really only composed by a single POLYGON; use " 1584#~ "<link linkend=\"ST_BdPolyFromText\">ST_BdPolyFromText</link> if you're " 1585#~ "sure a single POLYGON will result from operation, or see <link linkend=" 1586#~ "\"ST_BuildArea\">ST_BuildArea()</link> for a postgis-specific approach." 1587#~ msgstr "" 1588#~ "Ritorna un errore se il WKT non è una MULTILINESTRING. L'output è " 1589#~ "MULTIPOLYGON anche se il risultato è un singolo poligono. Usare <link " 1590#~ "linkend=\"ST_BdPolyFromText\">ST_BdPolyFromText</link> se si è sicuri " 1591#~ "che il risultato è un singolo poligono oppure vedere <link linkend=" 1592#~ "\"ST_BuildArea\">ST_BuildArea()</link> per un approccio specifico postgis." 1593 1594#~ msgid ", <xref linkend=\"ST_BdPolyFromText\"/>" 1595#~ msgstr ", <xref linkend=\"ST_BdPolyFromText\"/>" 1596 1597#~ msgid "ST_GeogFromText" 1598#~ msgstr "ST_GeogFromText" 1599 1600#~ msgid "" 1601#~ "Return a specified geography value from Well-Known Text representation or " 1602#~ "extended (WKT)." 1603#~ msgstr "" 1604#~ "Ritorna un valore geography sotto forma di Well-Know-Text (WKT) oppure di " 1605#~ "Extended-Well-Know-Text (EWKT)" 1606 1607#~ msgid "" 1608#~ "<funcdef>geography <function>ST_GeogFromText</function></funcdef> " 1609#~ "<paramdef><type>text </type> <parameter>EWKT</parameter></paramdef>" 1610#~ msgstr "" 1611#~ "<funcdef>geography <function>ST_GeogFromText</function></funcdef> " 1612#~ "<paramdef><type>text </type> <parameter>EWKT</parameter></paramdef>" 1613 1614#~ msgid ", <xref linkend=\"ST_GeographyFromText\"/>" 1615#~ msgstr ", <xref linkend=\"ST_GeographyFromText\"/>" 1616 1617#~ msgid "ST_GeographyFromText" 1618#~ msgstr "ST_GeographyFromText" 1619 1620#~ msgid "" 1621#~ "<funcdef>geography <function>ST_GeographyFromText</function></funcdef> " 1622#~ "<paramdef><type>text </type> <parameter>EWKT</parameter></paramdef>" 1623#~ msgstr "" 1624#~ "<funcdef>geography <function>ST_GeographyFromText</function></funcdef> " 1625#~ "<paramdef><type>text </type> <parameter>EWKT</parameter></paramdef>" 1626 1627#~ msgid ", <xref linkend=\"ST_AsText\"/>" 1628#~ msgstr ", <xref linkend=\"ST_AsText\"/>" 1629 1630#~ msgid "ST_GeogFromWKB" 1631#~ msgstr "ST_GeogFromWKB" 1632 1633#~ msgid "" 1634#~ "Creates a geography instance from a Well-Known Binary geometry " 1635#~ "representation (WKB) or extended Well Known Binary (EWKB)." 1636#~ msgstr "" 1637#~ "Crea un oggetto geography a partire da una geometria in Well-Known Binary " 1638#~ "(WKB) oppure Extended Well-Known Binary (EWKB)." 1639 1640#~ msgid "" 1641#~ "The <varname>ST_GeogFromWKB</varname> function, takes a well-known binary " 1642#~ "representation (WKB) of a geometry or PostGIS Extended WKB and creates an " 1643#~ "instance of the appropriate geography type. This function plays the role " 1644#~ "of the Geometry Factory in SQL." 1645#~ msgstr "" 1646#~ "La funzione <varname>ST_GeogFromWKB</varname> accetta come argomento una " 1647#~ "geometria POstGIS in formato Well-Known-Binary (WKB) oppure Extended WKB " 1648#~ "a crea un oggetto dell'appropriato tipo geography. Questa funzione ha un " 1649#~ "ruolo nella Geometry Factory in SQL." 1650 1651#~ msgid "If SRID is not specified, it defaults to 4326 (WGS 84 long lat)." 1652#~ msgstr "Se non specificato, lo SRID di default è 4326 (WGS 84 long lat)." 1653 1654#~ msgid "" 1655#~ "--Although bytea rep contains single \\, these need to be escaped when " 1656#~ "inserting into a table\n" 1657#~ "SELECT ST_AsText(\n" 1658#~ "ST_GeogFromWKB(E'\\\\001\\\\002\\\\000\\\\000\\\\000\\\\002\\\\000\\" 1659#~ "\\000\\\\000\\\\037\\\\205\\\\353Q\\\\270~\\\\\\\\\\\\300\\\\323Mb\\\\020X" 1660#~ "\\\\231C@\\\\020X9\\\\264\\\\310~\\\\\\\\\\\\300)\\\\\\\\\\\\217\\\\302\\" 1661#~ "\\365\\\\230C@')\n" 1662#~ ");\n" 1663#~ " st_astext\n" 1664#~ "------------------------------------------------------\n" 1665#~ " LINESTRING(-113.98 39.198,-113.981 39.195)\n" 1666#~ "(1 row)" 1667#~ msgstr "" 1668#~ "--Anche se bytea rep contiene singoli \\, these need to be escaped when " 1669#~ "inserting into a table\n" 1670#~ "SELECT ST_AsText(\n" 1671#~ "ST_GeogFromWKB(E'\\\\001\\\\002\\\\000\\\\000\\\\000\\\\002\\\\000\\" 1672#~ "\\000\\\\000\\\\037\\\\205\\\\353Q\\\\270~\\\\\\\\\\\\300\\\\323Mb\\\\020X" 1673#~ "\\\\231C@\\\\020X9\\\\264\\\\310~\\\\\\\\\\\\300)\\\\\\\\\\\\217\\\\302\\" 1674#~ "\\365\\\\230C@')\n" 1675#~ ");\n" 1676#~ " st_astext\n" 1677#~ "------------------------------------------------------\n" 1678#~ " LINESTRING(-113.98 39.198,-113.981 39.195)\n" 1679#~ "(1 row)" 1680 1681#~ msgid "" 1682#~ "<funcprototype> <funcdef>geometry <function>ST_GeomCollFromText</" 1683#~ "function></funcdef> <paramdef><type>text </type> <parameter>WKT</" 1684#~ "parameter></paramdef> <paramdef><type>integer </type> <parameter>srid</" 1685#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 1686#~ "<function>ST_GeomCollFromText</function></funcdef> <paramdef><type>text </" 1687#~ "type> <parameter>WKT</parameter></paramdef> </funcprototype>" 1688#~ msgstr "" 1689#~ "<funcprototype> <funcdef>geometry <function>ST_GeomCollFromText</" 1690#~ "function></funcdef> <paramdef><type>text </type> <parameter>WKT</" 1691#~ "parameter></paramdef> <paramdef><type>integer </type> <parameter>srid</" 1692#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 1693#~ "<function>ST_GeomCollFromText</function></funcdef> <paramdef><type>text </" 1694#~ "type> <parameter>WKT</parameter></paramdef> </funcprototype>" 1695 1696#~ msgid "OGC SPEC 3.2.6.2 - option SRID is from the conformance suite" 1697#~ msgstr "OGC SPEC 3.2.6.2 - option SRID is from the conformance suite" 1698 1699#~ msgid "Returns null if the WKT is not a GEOMETRYCOLLECTION" 1700#~ msgstr "Ritorna null se il WKT in input non è una GEOMETRYCOLLECTION" 1701 1702#~ msgid "" 1703#~ "If you are absolutely sure all your WKT geometries are collections, don't " 1704#~ "use this function. It is slower than ST_GeomFromText since it adds an " 1705#~ "additional validation step." 1706#~ msgstr "" 1707#~ "Se si è sicuri che tutti i WKT in input sono effettivamente " 1708#~ "GEOMETRYCOLLECTION, è sconsigliato usare questa funzione. È più lenta di " 1709#~ "ST_GeomFromText perché effettua anche una validazione della geometria." 1710 1711#~ msgid "&sqlmm_compliant;" 1712#~ msgstr "&sqlmm_compliant;" 1713 1714#~ msgid "" 1715#~ "SELECT ST_GeomCollFromText('GEOMETRYCOLLECTION(POINT(1 2),LINESTRING(1 2, " 1716#~ "3 4))');" 1717#~ msgstr "" 1718#~ "SELECT ST_GeomCollFromText('GEOMETRYCOLLECTION(POINT(1 2),LINESTRING(1 2, " 1719#~ "3 4))');" 1720 1721#~ msgid ", <xref linkend=\"ST_SRID\"/>" 1722#~ msgstr ", <xref linkend=\"ST_SRID\"/>" 1723 1724#~ msgid "ST_GeomFromEWKB" 1725#~ msgstr "ST_GeomFromEWKB" 1726 1727#~ msgid "" 1728#~ "Return a specified ST_Geometry value from Extended Well-Known Binary " 1729#~ "representation (EWKB)." 1730#~ msgstr "" 1731#~ "Ritorna un valore ST_Geometry a partire da Extended Well-Known Binary " 1732#~ "(EWKB)." 1733 1734#~ msgid "" 1735#~ "<funcdef>geometry <function>ST_GeomFromEWKB</function></funcdef> " 1736#~ "<paramdef><type>bytea </type> <parameter>EWKB</parameter></paramdef>" 1737#~ msgstr "" 1738#~ "<funcdef>geometry <function>ST_GeomFromEWKB</function></funcdef> " 1739#~ "<paramdef><type>bytea </type> <parameter>EWKB</parameter></paramdef>" 1740 1741#~ msgid "" 1742#~ "Constructs a PostGIS ST_Geometry object from the OGC Extended Well-Known " 1743#~ "binary (EWKT) representation." 1744#~ msgstr "" 1745#~ "Costruisce una ST_Geometry PostGIS a partire da OGC Extended Well-Known " 1746#~ "Binary (EWKT)." 1747 1748#~ msgid "" 1749#~ "The EWKB format is not an OGC standard, but a PostGIS specific format " 1750#~ "that includes the spatial reference system (SRID) identifier" 1751#~ msgstr "" 1752#~ "Il EWKB non è uno standard OGC ma uno specifico formato di Postgis che " 1753#~ "include il codice del sistema di riferimento spaziale (SRID)." 1754 1755#~ msgid "" 1756#~ "Enhanced: 2.0.0 support for Polyhedral surfaces and TIN was introduced." 1757#~ msgstr "" 1758#~ "Miglioramento nella version 2.0.2: introdotto il supporto per superfici " 1759#~ "poliedriche e TIN. " 1760 1761#~ msgid "&P_support;" 1762#~ msgstr "&P_support;" 1763 1764#~ msgid "&T_support;" 1765#~ msgstr "&T_support;" 1766 1767#~ msgid "" 1768#~ "line string binary rep 0f LINESTRING(-71.160281 42.258729,-71.160837 " 1769#~ "42.259113,-71.161144 42.25932) in NAD 83 long lat (4269)." 1770#~ msgstr "" 1771#~ "Rappresentazione binaria di LINESTRING(-71.160281 42.258729,-71.160837 " 1772#~ "42.259113,-71.161144 42.25932) in NAD 83 long lat (4269)." 1773 1774#~ msgid "" 1775#~ "SELECT ST_GeomFromEWKB(E'\\\\001\\\\002\\\\000\\\\000 \\\\255\\\\020\\" 1776#~ "\\000\\\\000\\\\003\\\\000\\\\000\\\\000\\\\344J=\n" 1777#~ "\\\\013B\\\\312Q\\\\300n\\\\303(\\\\010\\\\036!E@''\\\\277E''K\n" 1778#~ "\\\\312Q\\\\300\\\\366{b\\\\235*!E@\\\\225|\\\\354.P\\\\312Q\n" 1779#~ "\\\\300p\\\\231\\\\323e1!E@');" 1780#~ msgstr "" 1781#~ "SELECT ST_GeomFromEWKB(E'\\\\001\\\\002\\\\000\\\\000 \\\\255\\\\020\\" 1782#~ "\\000\\\\000\\\\003\\\\000\\\\000\\\\000\\\\344J=\n" 1783#~ "\\\\013B\\\\312Q\\\\300n\\\\303(\\\\010\\\\036!E@''\\\\277E''K\n" 1784#~ "\\\\312Q\\\\300\\\\366{b\\\\235*!E@\\\\225|\\\\354.P\\\\312Q\n" 1785#~ "\\\\300p\\\\231\\\\323e1!E@');" 1786 1787#~ msgid "" 1788#~ "set standard_conforming_strings = on;\n" 1789#~ "SELECT ST_GeomFromEWKB('\\001\\002\\000\\000 " 1790#~ "\\255\\020\\000\\000\\003\\000\\000\\000\\344J=\\012\\013B\n" 1791#~ " \\312Q\\300n\\303(\\010\\036!E@''\\277E''K\\012\\312Q\\300\\366{b" 1792#~ "\\235*!E@\\225|\\354.P\\312Q\\012\\300p\\231\\323e1')" 1793#~ msgstr "" 1794#~ "set standard_conforming_strings = on;\n" 1795#~ "SELECT ST_GeomFromEWKB('\\001\\002\\000\\000 " 1796#~ "\\255\\020\\000\\000\\003\\000\\000\\000\\344J=\\012\\013B\n" 1797#~ " \\312Q\\300n\\303(\\010\\036!E@''\\277E''K\\012\\312Q\\300\\366{b" 1798#~ "\\235*!E@\\225|\\354.P\\312Q\\012\\300p\\231\\323e1')" 1799 1800#~ msgid ", <xref linkend=\"ST_AsEWKB\"/>, <xref linkend=\"ST_GeomFromWKB\"/>" 1801#~ msgstr ", <xref linkend=\"ST_AsEWKB\"/>, <xref linkend=\"ST_GeomFromWKB\"/>" 1802 1803#~ msgid "ST_GeomFromEWKT" 1804#~ msgstr "ST_GeomFromEWKT" 1805 1806#~ msgid "" 1807#~ "Return a specified ST_Geometry value from Extended Well-Known Text " 1808#~ "representation (EWKT)." 1809#~ msgstr "" 1810#~ "Ritorna un valore ST_Geometry a partire da una rappresentazione Extended " 1811#~ "Well-Known Text (EWKT)." 1812 1813#~ msgid "" 1814#~ "<funcdef>geometry <function>ST_GeomFromEWKT</function></funcdef> " 1815#~ "<paramdef><type>text </type> <parameter>EWKT</parameter></paramdef>" 1816#~ msgstr "" 1817#~ "<funcdef>geometry <function>ST_GeomFromEWKT</function></funcdef> " 1818#~ "<paramdef><type>text </type> <parameter>EWKT</parameter></paramdef>" 1819 1820#~ msgid "" 1821#~ "Constructs a PostGIS ST_Geometry object from the OGC Extended Well-Known " 1822#~ "text (EWKT) representation." 1823#~ msgstr "" 1824#~ "Costruisce un oggetto PostGIS ST_Geometry a partire da una " 1825#~ "rappresentazione OGC Extended Well-Known Text (EWKT)." 1826 1827#~ msgid "" 1828#~ "The EWKT format is not an OGC standard, but an PostGIS specific format " 1829#~ "that includes the spatial reference system (SRID) identifier" 1830#~ msgstr "" 1831#~ "Il formato EWKT non è uno standard OGC ma un formato specifico di PostGIS " 1832#~ "che include il codice del sistema di riferimento spaziale (SRID)." 1833 1834#~ msgid "" 1835#~ "SELECT ST_GeomFromEWKT('SRID=4269;LINESTRING(-71.160281 " 1836#~ "42.258729,-71.160837 42.259113,-71.161144 42.25932)');\n" 1837#~ "SELECT ST_GeomFromEWKT('SRID=4269;MULTILINESTRING((-71.160281 " 1838#~ "42.258729,-71.160837 42.259113,-71.161144 42.25932))');\n" 1839#~ "\n" 1840#~ "SELECT ST_GeomFromEWKT('SRID=4269;POINT(-71.064544 42.28787)');\n" 1841#~ "\n" 1842#~ "SELECT ST_GeomFromEWKT('SRID=4269;POLYGON((-71.1776585052917 " 1843#~ "42.3902909739571,-71.1776820268866 42.3903701743239,\n" 1844#~ "-71.1776063012595 42.3903825660754,-71.1775826583081 " 1845#~ "42.3903033653531,-71.1776585052917 42.3902909739571))');\n" 1846#~ "\n" 1847#~ "SELECT ST_GeomFromEWKT('SRID=4269;MULTIPOLYGON(((-71.1031880899493 " 1848#~ "42.3152774590236,\n" 1849#~ "-71.1031627617667 42.3152960829043,-71.102923838298 42.3149156848307,\n" 1850#~ "-71.1023097974109 42.3151969047397,-71.1019285062273 42.3147384934248,\n" 1851#~ "-71.102505233663 42.3144722937587,-71.10277487471 42.3141658254797,\n" 1852#~ "-71.103113945163 42.3142739188902,-71.10324876416 42.31402489987,\n" 1853#~ "-71.1033002961013 42.3140393340215,-71.1033488797549 42.3139495090772,\n" 1854#~ "-71.103396240451 42.3138632439557,-71.1041521907712 42.3141153348029,\n" 1855#~ "-71.1041411411543 42.3141545014533,-71.1041287795912 42.3142114839058,\n" 1856#~ "-71.1041188134329 42.3142693656241,-71.1041112482575 42.3143272556118,\n" 1857#~ "-71.1041072845732 42.3143851580048,-71.1041057218871 42.3144430686681,\n" 1858#~ "-71.1041065602059 42.3145009876017,-71.1041097995362 42.3145589148055,\n" 1859#~ "-71.1041166403905 42.3146168544148,-71.1041258822717 42.3146748022936,\n" 1860#~ "-71.1041375307579 42.3147318674446,-71.1041492906949 42.3147711126569,\n" 1861#~ "-71.1041598612795 42.314808571739,-71.1042515013869 42.3151287620809,\n" 1862#~ "-71.1041173835118 42.3150739481917,-71.1040809891419 42.3151344119048,\n" 1863#~ "-71.1040438678912 42.3151191367447,-71.1040194562988 42.3151832057859,\n" 1864#~ "-71.1038734225584 42.3151140942995,-71.1038446938243 42.3151006300338,\n" 1865#~ "-71.1038315271889 42.315094347535,-71.1037393329282 42.315054824985,\n" 1866#~ "-71.1035447555574 42.3152608696313,-71.1033436658644 42.3151648370544,\n" 1867#~ "-71.1032580383161 42.3152269126061,-71.103223066939 42.3152517403219,\n" 1868#~ "-71.1031880899493 42.3152774590236)),\n" 1869#~ "((-71.1043632495873 42.315113108546,-71.1043583974082 42.3151211109857,\n" 1870#~ "-71.1043443253471 42.3150676015829,-71.1043850704575 " 1871#~ "42.3150793250568,-71.1043632495873 42.315113108546)))');" 1872#~ msgstr "" 1873#~ "SELECT ST_GeomFromEWKT('SRID=4269;LINESTRING(-71.160281 " 1874#~ "42.258729,-71.160837 42.259113,-71.161144 42.25932)');\n" 1875#~ "SELECT ST_GeomFromEWKT('SRID=4269;MULTILINESTRING((-71.160281 " 1876#~ "42.258729,-71.160837 42.259113,-71.161144 42.25932))');\n" 1877#~ "\n" 1878#~ "SELECT ST_GeomFromEWKT('SRID=4269;POINT(-71.064544 42.28787)');\n" 1879#~ "\n" 1880#~ "SELECT ST_GeomFromEWKT('SRID=4269;POLYGON((-71.1776585052917 " 1881#~ "42.3902909739571,-71.1776820268866 42.3903701743239,\n" 1882#~ "-71.1776063012595 42.3903825660754,-71.1775826583081 " 1883#~ "42.3903033653531,-71.1776585052917 42.3902909739571))');\n" 1884#~ "\n" 1885#~ "SELECT ST_GeomFromEWKT('SRID=4269;MULTIPOLYGON(((-71.1031880899493 " 1886#~ "42.3152774590236,\n" 1887#~ "-71.1031627617667 42.3152960829043,-71.102923838298 42.3149156848307,\n" 1888#~ "-71.1023097974109 42.3151969047397,-71.1019285062273 42.3147384934248,\n" 1889#~ "-71.102505233663 42.3144722937587,-71.10277487471 42.3141658254797,\n" 1890#~ "-71.103113945163 42.3142739188902,-71.10324876416 42.31402489987,\n" 1891#~ "-71.1033002961013 42.3140393340215,-71.1033488797549 42.3139495090772,\n" 1892#~ "-71.103396240451 42.3138632439557,-71.1041521907712 42.3141153348029,\n" 1893#~ "-71.1041411411543 42.3141545014533,-71.1041287795912 42.3142114839058,\n" 1894#~ "-71.1041188134329 42.3142693656241,-71.1041112482575 42.3143272556118,\n" 1895#~ "-71.1041072845732 42.3143851580048,-71.1041057218871 42.3144430686681,\n" 1896#~ "-71.1041065602059 42.3145009876017,-71.1041097995362 42.3145589148055,\n" 1897#~ "-71.1041166403905 42.3146168544148,-71.1041258822717 42.3146748022936,\n" 1898#~ "-71.1041375307579 42.3147318674446,-71.1041492906949 42.3147711126569,\n" 1899#~ "-71.1041598612795 42.314808571739,-71.1042515013869 42.3151287620809,\n" 1900#~ "-71.1041173835118 42.3150739481917,-71.1040809891419 42.3151344119048,\n" 1901#~ "-71.1040438678912 42.3151191367447,-71.1040194562988 42.3151832057859,\n" 1902#~ "-71.1038734225584 42.3151140942995,-71.1038446938243 42.3151006300338,\n" 1903#~ "-71.1038315271889 42.315094347535,-71.1037393329282 42.315054824985,\n" 1904#~ "-71.1035447555574 42.3152608696313,-71.1033436658644 42.3151648370544,\n" 1905#~ "-71.1032580383161 42.3152269126061,-71.103223066939 42.3152517403219,\n" 1906#~ "-71.1031880899493 42.3152774590236)),\n" 1907#~ "((-71.1043632495873 42.315113108546,-71.1043583974082 42.3151211109857,\n" 1908#~ "-71.1043443253471 42.3150676015829,-71.1043850704575 " 1909#~ "42.3150793250568,-71.1043632495873 42.315113108546)))');" 1910 1911#~ msgid "" 1912#~ "--3d circular string\n" 1913#~ "SELECT ST_GeomFromEWKT('CIRCULARSTRING(220268 150415 1,220227 150505 " 1914#~ "2,220227 150406 3)');" 1915#~ msgstr "" 1916#~ "-- Linea curva 3d\n" 1917#~ "SELECT ST_GeomFromEWKT('CIRCULARSTRING(220268 150415 1,220227 150505 " 1918#~ "2,220227 150406 3)');" 1919 1920#~ msgid "" 1921#~ ", <xref linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>" 1922#~ msgstr "" 1923#~ ", <xref linkend=\"ST_GeomFromText\"/>, <xref linkend=\"ST_GeomFromEWKT\"/>" 1924 1925#~ msgid "ST_GeometryFromText" 1926#~ msgstr "ST_GeometryFromText" 1927 1928#~ msgid "" 1929#~ "Return a specified ST_Geometry value from Well-Known Text representation " 1930#~ "(WKT). This is an alias name for ST_GeomFromText" 1931#~ msgstr "" 1932#~ "Restituisce un valore ST_Geometry a partire da Well-Known-Text (WKT). È " 1933#~ "un alias per ST_GeomFromText" 1934 1935#~ msgid "" 1936#~ "<funcprototype> <funcdef>geometry <function>ST_GeometryFromText</" 1937#~ "function></funcdef> <paramdef><type>text </type> <parameter>WKT</" 1938#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 1939#~ "<function>ST_GeometryFromText</function></funcdef> <paramdef><type>text </" 1940#~ "type> <parameter>WKT</parameter></paramdef> <paramdef><type>integer </" 1941#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 1942#~ msgstr "" 1943#~ "<funcprototype> <funcdef>geometry <function>ST_GeometryFromText</" 1944#~ "function></funcdef> <paramdef><type>text </type> <parameter>WKT</" 1945#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 1946#~ "<function>ST_GeometryFromText</function></funcdef> <paramdef><type>text </" 1947#~ "type> <parameter>WKT</parameter></paramdef> <paramdef><type>integer </" 1948#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 1949 1950#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.40" 1951#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.40" 1952 1953#~ msgid "ST_GeomFromGML" 1954#~ msgstr "ST_GeomFromGML" 1955 1956#~ msgid "" 1957#~ "Takes as input GML representation of geometry and outputs a PostGIS " 1958#~ "geometry object" 1959#~ msgstr "" 1960#~ "Accetta una geometria in formato GML come input e restituisce un oggetto " 1961#~ "PostGIS geometry" 1962 1963#~ msgid "" 1964#~ "<funcprototype> <funcdef>geometry <function>ST_GeomFromGML</function></" 1965#~ "funcdef> <paramdef><type>text </type> <parameter>geomgml</parameter></" 1966#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 1967#~ "<function>ST_GeomFromGML</function></funcdef> <paramdef><type>text </" 1968#~ "type> <parameter>geomgml</parameter></paramdef> <paramdef><type>integer </" 1969#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 1970#~ msgstr "" 1971#~ "<funcprototype> <funcdef>geometry <function>ST_GeomFromGML</function></" 1972#~ "funcdef> <paramdef><type>text </type> <parameter>geomgml</parameter></" 1973#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 1974#~ "<function>ST_GeomFromGML</function></funcdef> <paramdef><type>text </" 1975#~ "type> <parameter>geomgml</parameter></paramdef> <paramdef><type>integer </" 1976#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 1977 1978#~ msgid "" 1979#~ "Constructs a PostGIS ST_Geometry object from the OGC GML representation." 1980#~ msgstr "" 1981#~ "Costruisce un oggetto PostGIS ST_Geometry a partire da una " 1982#~ "rappresentazione OGC GML" 1983 1984#~ msgid "" 1985#~ "ST_GeomFromGML works only for GML Geometry fragments. It throws an error " 1986#~ "if you try to use it on a whole GML document." 1987#~ msgstr "" 1988#~ "ST_GeomFromGML supporta solo singole geometrie in formato GML. Ritorna un " 1989#~ "errore se si cerca di usare l'intero documento GML." 1990 1991#~ msgid "" 1992#~ "OGC GML versions supported: <itemizedlist> <listitem> <para>GML 3.2.1 " 1993#~ "Namespace</para> </listitem> <listitem> <para>GML 3.1.1 Simple Features " 1994#~ "profile SF-2 (with GML 3.1.0 and 3.0.0 backward compatibility)</para> </" 1995#~ "listitem> <listitem> <para>GML 2.1.2</para> </listitem> </itemizedlist> " 1996#~ "OGC GML standards, cf: <ulink url=\"http://www.opengeospatial.org/" 1997#~ "standards/gml\">http://www.opengeospatial.org/standards/gml</ulink>:" 1998#~ msgstr "" 1999#~ "Versioni di OGC GML supportate: <itemizedlist> <listitem> <para>GML 3.2.1 " 2000#~ "Namespace</para> </listitem> <listitem> <para>GML 3.1.1 Simple Features " 2001#~ "profile SF-2 (con retrocompatibilità GML 3.1.0 e 3.0.0)</para> </" 2002#~ "listitem> <listitem> <para>GML 2.1.2</para> </listitem> </itemizedlist> " 2003#~ "OGC GML standards, cf: <ulink url=\"http://www.opengeospatial.org/" 2004#~ "standards/gml\">http://www.opengeospatial.org/standards/gml</ulink>:" 2005 2006#~ msgid "Availability: 1.5, requires libxml2 1.6+" 2007#~ msgstr "Disponibilità: 1.5, richiede libxml2 1.6+" 2008 2009#~ msgid "Enhanced: 2.0.0 default srid optional parameter added." 2010#~ msgstr "" 2011#~ "Miglioramento nella versione: 2.0.0 introdotto opzionale parametro SRID." 2012 2013#~ msgid "" 2014#~ "GML allow mixed dimensions (2D and 3D inside the same MultiGeometry for " 2015#~ "instance). As PostGIS geometries don't, ST_GeomFromGML convert the whole " 2016#~ "geometry to 2D if a missing Z dimension is found once." 2017#~ msgstr "" 2018#~ "In formato GML permette di combinare diverse dimensioni (per esempio la " 2019#~ "stessa multigeometria può contenere elementi in 2D e 3D " 2020#~ "contemporaneamente). Siccome le geometrie PostGIS non supportano la " 2021#~ "combinazione di diverse dimensioni, la funzione ST_GeomFromGML converte " 2022#~ "l'intera geometria in 2D se almeno un elemento è in 2D." 2023 2024#~ msgid "" 2025#~ "GML support mixed SRS inside the same MultiGeometry. As PostGIS " 2026#~ "geometries don't, ST_GeomFromGML, in this case, reproject all " 2027#~ "subgeometries to the SRS root node. If no srsName attribute available for " 2028#~ "the GML root node, the function throw an error." 2029#~ msgstr "" 2030#~ "Il formato GML supporta la combinazione di diversi SRID all'interno della " 2031#~ "stessa multigeometria. Siccome le geometrie PostGIS non supportano questa " 2032#~ "combinazione, la funzione ST_GeomFromGML riproietta tutte le " 2033#~ "sottogeometrie nello SRID del nodo root. Se il nodo root non contiene " 2034#~ "l'attributo srsName, la funzione restituisce un errore." 2035 2036#~ msgid "" 2037#~ "ST_GeomFromGML function is not pedantic about an explicit GML namespace. " 2038#~ "You could avoid to mention it explicitly for common usages. But you need " 2039#~ "it if you want to use XLink feature inside GML." 2040#~ msgstr "" 2041#~ "La funzione ST_GeomFromGML non richiede dell'indicazione esplicita di un " 2042#~ "namespace GML. Nell'uso comune una indicazione specifica. non è " 2043#~ "necessaria. Il namespace deve però essere indicato esplicitamente se si " 2044#~ "vuole usare la feature XLink all'interno di GML." 2045 2046#~ msgid "ST_GeomFromGML function not support SQL/MM curves geometries." 2047#~ msgstr "ST_GeomFromGML non supporta geometrie curve SQL/MM." 2048 2049#~ msgid "Examples - A single geometry with srsName" 2050#~ msgstr "Esempi - Una singola geometria con srsName" 2051 2052#~ msgid "" 2053#~ "SELECT ST_GeomFromGML('<![CDATA[\n" 2054#~ " <gml:LineString srsName=\"EPSG:4269\">\n" 2055#~ " <gml:coordinates>\n" 2056#~ " -71.16028,42.258729 -71.160837,42.259112 " 2057#~ "-71.161143,42.25932\n" 2058#~ " </gml:coordinates>\n" 2059#~ " </gml:LineString>']]>);" 2060#~ msgstr "" 2061#~ "SELECT ST_GeomFromGML('<![CDATA[\n" 2062#~ " <gml:LineString srsName=\"EPSG:4269\">\n" 2063#~ " <gml:coordinates>\n" 2064#~ " -71.16028,42.258729 -71.160837,42.259112 " 2065#~ "-71.161143,42.25932\n" 2066#~ " </gml:coordinates>\n" 2067#~ " </gml:LineString>']]>);" 2068 2069#~ msgid ", <xref linkend=\"ST_AsGML\"/>, <xref linkend=\"ST_GMLToSQL\"/>" 2070#~ msgstr ", <xref linkend=\"ST_AsGML\"/>, <xref linkend=\"ST_GMLToSQL\"/>" 2071 2072#~ msgid "ST_GeomFromGeoJSON" 2073#~ msgstr "ST_GeomFromGeoJSON" 2074 2075#~ msgid "" 2076#~ "Takes as input a geojson representation of a geometry and outputs a " 2077#~ "PostGIS geometry object" 2078#~ msgstr "" 2079#~ "Accetta come input la rappresentazione geojson di una geometria e " 2080#~ "restituisce una geometria PostGIS" 2081 2082#~ msgid "" 2083#~ "Constructs a PostGIS geometry object from the GeoJSON representation." 2084#~ msgstr "" 2085#~ "Costruisce una geometria PostGIS a partire a una rappresentazione GeoJson" 2086 2087#~ msgid "" 2088#~ "ST_GeomFromGeoJSON works only for JSON Geometry fragments. It throws an " 2089#~ "error if you try to use it on a whole JSON document." 2090#~ msgstr "" 2091#~ "ST_GeomFromGeoJSON funzione solo con frammenti di geometrie GeoJson. " 2092#~ "Ritorna un errore se si cerca di usare un completo documento json." 2093 2094#~ msgid "Availability: 2.0.0 requires - JSON-C >= 0.9" 2095#~ msgstr "Disponibilità: 2.0.0. Richiede - JSON-C >= 0.9" 2096 2097#~ msgid "" 2098#~ "If you do not have JSON-C enabled, support you will get an error notice " 2099#~ "instead of seeing an output. To enable JSON-C, run configure --with-" 2100#~ "jsondir=/path/to/json-c. See <xref linkend=\"installation_configuration\"/" 2101#~ "> for details." 2102#~ msgstr "" 2103#~ "Se supporto JSON-C non è attivato, viene restituito un errore invece " 2104#~ "dell'output.\n" 2105#~ "Per attivare il supporto JSON-C, usare configure --with-jsondir=/path/to/" 2106#~ "json-c. Vedi <xref linkend=\"installation_configuration\"/> per dettagli." 2107 2108#~ msgid "" 2109#~ "SELECT ST_AsText(ST_GeomFromGeoJSON('{\"type\":\"Point\",\"coordinates\":" 2110#~ "[-48.23456,20.12345]}')) As wkt;\n" 2111#~ "wkt\n" 2112#~ "------\n" 2113#~ "POINT(-48.23456 20.12345)" 2114#~ msgstr "" 2115#~ "SELECT ST_AsText(ST_GeomFromGeoJSON('{\"type\":\"Point\",\"coordinates\":" 2116#~ "[-48.23456,20.12345]}')) As wkt;\n" 2117#~ "wkt\n" 2118#~ "------\n" 2119#~ "POINT(-48.23456 20.12345)" 2120 2121#~ msgid "" 2122#~ "-- a 3D linestring\n" 2123#~ "SELECT ST_AsText(ST_GeomFromGeoJSON('{\"type\":\"LineString\"," 2124#~ "\"coordinates\":[[1,2,3],[4,5,6],[7,8,9]]}')) As wkt;\n" 2125#~ "\n" 2126#~ "wkt\n" 2127#~ "-------------------\n" 2128#~ "LINESTRING(1 2,4 5,7 8)" 2129#~ msgstr "" 2130#~ "-- una linestring 3D\n" 2131#~ "SELECT ST_AsText(ST_GeomFromGeoJSON('{\"type\":\"LineString\"," 2132#~ "\"coordinates\":[[1,2,3],[4,5,6],[7,8,9]]}')) As wkt;\n" 2133#~ "\n" 2134#~ "wkt\n" 2135#~ "-------------------\n" 2136#~ "LINESTRING(1 2,4 5,7 8)" 2137 2138#~ msgid "" 2139#~ ", <xref linkend=\"ST_AsGeoJSON\"/>, <xref linkend=" 2140#~ "\"installation_configuration\"/>" 2141#~ msgstr "" 2142#~ ", <xref linkend=\"ST_AsGeoJSON\"/>, <xref linkend=" 2143#~ "\"installation_configuration\"/>" 2144 2145#~ msgid "ST_GeomFromKML" 2146#~ msgstr "ST_GeomFromKML" 2147 2148#~ msgid "" 2149#~ "Takes as input KML representation of geometry and outputs a PostGIS " 2150#~ "geometry object" 2151#~ msgstr "" 2152#~ "Accetta come input una geometria in formato KML e restituisce una " 2153#~ "geometria PostGIS." 2154 2155#~ msgid "" 2156#~ "<funcdef>geometry <function>ST_GeomFromKML</function></funcdef> " 2157#~ "<paramdef><type>text </type> <parameter>geomkml</parameter></paramdef>" 2158#~ msgstr "" 2159#~ "<funcdef>geometry <function>ST_GeomFromKML</function></funcdef> " 2160#~ "<paramdef><type>text </type> <parameter>geomkml</parameter></paramdef>" 2161 2162#~ msgid "" 2163#~ "Constructs a PostGIS ST_Geometry object from the OGC KML representation." 2164#~ msgstr "" 2165#~ "Costruisce un oggetto PostSIG ST_Geometry a partire da una geometria in " 2166#~ "formato OGC KML." 2167 2168#~ msgid "" 2169#~ "ST_GeomFromKML works only for KML Geometry fragments. It throws an error " 2170#~ "if you try to use it on a whole KML document." 2171#~ msgstr "" 2172#~ "ST_GeomFromKML accetta solo frammenti di geometrie KML. Restituisce un " 2173#~ "errore se l'input consiste in un intero documento KML." 2174 2175#~ msgid "" 2176#~ "OGC KML versions supported: <itemizedlist> <listitem> <para>KML 2.2.0 " 2177#~ "Namespace</para> </listitem> </itemizedlist> OGC KML standards, cf: " 2178#~ "<ulink url=\"http://www.opengeospatial.org/standards/kml\">http://www." 2179#~ "opengeospatial.org/standards/kml</ulink>:" 2180#~ msgstr "" 2181#~ "Versioni di OGC KML supportate: <itemizedlist> <listitem> <para>KML " 2182#~ "2.2.0 Namespace</para> </listitem> </itemizedlist> OGC KML standards, cf: " 2183#~ "<ulink url=\"http://www.opengeospatial.org/standards/kml\">http://www." 2184#~ "opengeospatial.org/standards/kml</ulink>:" 2185 2186#~ msgid "Availability: 1.5,libxml2 2.6+" 2187#~ msgstr "Disponibilità: PostGIS 1.5, libxml2 2.6+" 2188 2189#~ msgid "ST_GeomFromKML function not support SQL/MM curves geometries." 2190#~ msgstr "La funzione ST_GeomFromKML non supporta geometrie curve SQL/MM." 2191 2192#~ msgid "ST_GMLToSQL" 2193#~ msgstr "ST_GMLToSQL" 2194 2195#~ msgid "" 2196#~ "Return a specified ST_Geometry value from GML representation. This is an " 2197#~ "alias name for ST_GeomFromGML" 2198#~ msgstr "" 2199#~ "Restituisce un valore ST_Geometry a partire da una rappresentazione GML. " 2200#~ "Questo è solo un alias per la funzione ST_GeomFromGML." 2201 2202#~ msgid "" 2203#~ "<funcprototype> <funcdef>geometry <function>ST_GMLToSQL</function></" 2204#~ "funcdef> <paramdef><type>text </type> <parameter>geomgml</parameter></" 2205#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2206#~ "<function>ST_GMLToSQL</function></funcdef> <paramdef><type>text </type> " 2207#~ "<parameter>geomgml</parameter></paramdef> <paramdef><type>integer </type> " 2208#~ "<parameter>srid</parameter></paramdef> </funcprototype>" 2209#~ msgstr "" 2210#~ "<funcprototype> <funcdef>geometry <function>ST_GMLToSQL</function></" 2211#~ "funcdef> <paramdef><type>text </type> <parameter>geomgml</parameter></" 2212#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2213#~ "<function>ST_GMLToSQL</function></funcdef> <paramdef><type>text </type> " 2214#~ "<parameter>geomgml</parameter></paramdef> <paramdef><type>integer </type> " 2215#~ "<parameter>srid</parameter></paramdef> </funcprototype>" 2216 2217#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.50 (except for curves support)." 2218#~ msgstr "" 2219#~ "&sqlmm_compliant; SQL-MM 3: 5.1.50 (tranne che il supporto per le curve)." 2220 2221#~ msgid ", <xref linkend=\"ST_GeomFromGML\"/>, <xref linkend=\"ST_AsGML\"/>" 2222#~ msgstr ", <xref linkend=\"ST_GeomFromGML\"/>, <xref linkend=\"ST_AsGML\"/>" 2223 2224#~ msgid "ST_GeomFromText" 2225#~ msgstr "ST_GeomFromText" 2226 2227#~ msgid "" 2228#~ "Return a specified ST_Geometry value from Well-Known Text representation " 2229#~ "(WKT)." 2230#~ msgstr "" 2231#~ "Restituisce un valore ST_Geometry a partire da una rappresentazione Well-" 2232#~ "Known-Text (WKT)" 2233 2234#~ msgid "" 2235#~ "<funcprototype> <funcdef>geometry <function>ST_GeomFromText</function></" 2236#~ "funcdef> <paramdef><type>text </type> <parameter>WKT</parameter></" 2237#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2238#~ "<function>ST_GeomFromText</function></funcdef> <paramdef><type>text </" 2239#~ "type> <parameter>WKT</parameter></paramdef> <paramdef><type>integer </" 2240#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2241#~ msgstr "" 2242#~ "<funcprototype> <funcdef>geometry <function>ST_GeomFromText</function></" 2243#~ "funcdef> <paramdef><type>text </type> <parameter>WKT</parameter></" 2244#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2245#~ "<function>ST_GeomFromText</function></funcdef> <paramdef><type>text </" 2246#~ "type> <parameter>WKT</parameter></paramdef> <paramdef><type>integer </" 2247#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2248 2249#~ msgid "" 2250#~ "Constructs a PostGIS ST_Geometry object from the OGC Well-Known text " 2251#~ "representation." 2252#~ msgstr "" 2253#~ "Costruisce un oggetto PostGIS ST_Geometry a partire da geometria in " 2254#~ "formato OGC Well-Known-Text" 2255 2256#~ msgid "" 2257#~ "SELECT ST_GeomFromText('LINESTRING(-71.160281 42.258729,-71.160837 " 2258#~ "42.259113,-71.161144 42.25932)');\n" 2259#~ "SELECT ST_GeomFromText('LINESTRING(-71.160281 42.258729,-71.160837 " 2260#~ "42.259113,-71.161144 42.25932)',4269);\n" 2261#~ "\n" 2262#~ "SELECT ST_GeomFromText('MULTILINESTRING((-71.160281 42.258729,-71.160837 " 2263#~ "42.259113,-71.161144 42.25932))');\n" 2264#~ "\n" 2265#~ "SELECT ST_GeomFromText('POINT(-71.064544 42.28787)');\n" 2266#~ "\n" 2267#~ "SELECT ST_GeomFromText('POLYGON((-71.1776585052917 " 2268#~ "42.3902909739571,-71.1776820268866 42.3903701743239,\n" 2269#~ "-71.1776063012595 42.3903825660754,-71.1775826583081 " 2270#~ "42.3903033653531,-71.1776585052917 42.3902909739571))');\n" 2271#~ "\n" 2272#~ "SELECT ST_GeomFromText('MULTIPOLYGON(((-71.1031880899493 " 2273#~ "42.3152774590236,\n" 2274#~ "-71.1031627617667 42.3152960829043,-71.102923838298 42.3149156848307,\n" 2275#~ "-71.1023097974109 42.3151969047397,-71.1019285062273 42.3147384934248,\n" 2276#~ "-71.102505233663 42.3144722937587,-71.10277487471 42.3141658254797,\n" 2277#~ "-71.103113945163 42.3142739188902,-71.10324876416 42.31402489987,\n" 2278#~ "-71.1033002961013 42.3140393340215,-71.1033488797549 42.3139495090772,\n" 2279#~ "-71.103396240451 42.3138632439557,-71.1041521907712 42.3141153348029,\n" 2280#~ "-71.1041411411543 42.3141545014533,-71.1041287795912 42.3142114839058,\n" 2281#~ "-71.1041188134329 42.3142693656241,-71.1041112482575 42.3143272556118,\n" 2282#~ "-71.1041072845732 42.3143851580048,-71.1041057218871 42.3144430686681,\n" 2283#~ "-71.1041065602059 42.3145009876017,-71.1041097995362 42.3145589148055,\n" 2284#~ "-71.1041166403905 42.3146168544148,-71.1041258822717 42.3146748022936,\n" 2285#~ "-71.1041375307579 42.3147318674446,-71.1041492906949 42.3147711126569,\n" 2286#~ "-71.1041598612795 42.314808571739,-71.1042515013869 42.3151287620809,\n" 2287#~ "-71.1041173835118 42.3150739481917,-71.1040809891419 42.3151344119048,\n" 2288#~ "-71.1040438678912 42.3151191367447,-71.1040194562988 42.3151832057859,\n" 2289#~ "-71.1038734225584 42.3151140942995,-71.1038446938243 42.3151006300338,\n" 2290#~ "-71.1038315271889 42.315094347535,-71.1037393329282 42.315054824985,\n" 2291#~ "-71.1035447555574 42.3152608696313,-71.1033436658644 42.3151648370544,\n" 2292#~ "-71.1032580383161 42.3152269126061,-71.103223066939 42.3152517403219,\n" 2293#~ "-71.1031880899493 42.3152774590236)),\n" 2294#~ "((-71.1043632495873 42.315113108546,-71.1043583974082 42.3151211109857,\n" 2295#~ "-71.1043443253471 42.3150676015829,-71.1043850704575 " 2296#~ "42.3150793250568,-71.1043632495873 42.315113108546)))',4326);\n" 2297#~ "\n" 2298#~ "SELECT ST_GeomFromText('CIRCULARSTRING(220268 150415,220227 150505,220227 " 2299#~ "150406)');" 2300#~ msgstr "" 2301#~ "SELECT ST_GeomFromText('LINESTRING(-71.160281 42.258729,-71.160837 " 2302#~ "42.259113,-71.161144 42.25932)');\n" 2303#~ "SELECT ST_GeomFromText('LINESTRING(-71.160281 42.258729,-71.160837 " 2304#~ "42.259113,-71.161144 42.25932)',4269);\n" 2305#~ "\n" 2306#~ "SELECT ST_GeomFromText('MULTILINESTRING((-71.160281 42.258729,-71.160837 " 2307#~ "42.259113,-71.161144 42.25932))');\n" 2308#~ "\n" 2309#~ "SELECT ST_GeomFromText('POINT(-71.064544 42.28787)');\n" 2310#~ "\n" 2311#~ "SELECT ST_GeomFromText('POLYGON((-71.1776585052917 " 2312#~ "42.3902909739571,-71.1776820268866 42.3903701743239,\n" 2313#~ "-71.1776063012595 42.3903825660754,-71.1775826583081 " 2314#~ "42.3903033653531,-71.1776585052917 42.3902909739571))');\n" 2315#~ "\n" 2316#~ "SELECT ST_GeomFromText('MULTIPOLYGON(((-71.1031880899493 " 2317#~ "42.3152774590236,\n" 2318#~ "-71.1031627617667 42.3152960829043,-71.102923838298 42.3149156848307,\n" 2319#~ "-71.1023097974109 42.3151969047397,-71.1019285062273 42.3147384934248,\n" 2320#~ "-71.102505233663 42.3144722937587,-71.10277487471 42.3141658254797,\n" 2321#~ "-71.103113945163 42.3142739188902,-71.10324876416 42.31402489987,\n" 2322#~ "-71.1033002961013 42.3140393340215,-71.1033488797549 42.3139495090772,\n" 2323#~ "-71.103396240451 42.3138632439557,-71.1041521907712 42.3141153348029,\n" 2324#~ "-71.1041411411543 42.3141545014533,-71.1041287795912 42.3142114839058,\n" 2325#~ "-71.1041188134329 42.3142693656241,-71.1041112482575 42.3143272556118,\n" 2326#~ "-71.1041072845732 42.3143851580048,-71.1041057218871 42.3144430686681,\n" 2327#~ "-71.1041065602059 42.3145009876017,-71.1041097995362 42.3145589148055,\n" 2328#~ "-71.1041166403905 42.3146168544148,-71.1041258822717 42.3146748022936,\n" 2329#~ "-71.1041375307579 42.3147318674446,-71.1041492906949 42.3147711126569,\n" 2330#~ "-71.1041598612795 42.314808571739,-71.1042515013869 42.3151287620809,\n" 2331#~ "-71.1041173835118 42.3150739481917,-71.1040809891419 42.3151344119048,\n" 2332#~ "-71.1040438678912 42.3151191367447,-71.1040194562988 42.3151832057859,\n" 2333#~ "-71.1038734225584 42.3151140942995,-71.1038446938243 42.3151006300338,\n" 2334#~ "-71.1038315271889 42.315094347535,-71.1037393329282 42.315054824985,\n" 2335#~ "-71.1035447555574 42.3152608696313,-71.1033436658644 42.3151648370544,\n" 2336#~ "-71.1032580383161 42.3152269126061,-71.103223066939 42.3152517403219,\n" 2337#~ "-71.1031880899493 42.3152774590236)),\n" 2338#~ "((-71.1043632495873 42.315113108546,-71.1043583974082 42.3151211109857,\n" 2339#~ "-71.1043443253471 42.3150676015829,-71.1043850704575 " 2340#~ "42.3150793250568,-71.1043632495873 42.315113108546)))',4326);\n" 2341#~ "\n" 2342#~ "SELECT ST_GeomFromText('CIRCULARSTRING(220268 150415,220227 150505,220227 " 2343#~ "150406)');" 2344 2345#~ msgid ", <xref linkend=\"ST_GeomFromWKB\"/>, <xref linkend=\"ST_SRID\"/>" 2346#~ msgstr ", <xref linkend=\"ST_GeomFromWKB\"/>, <xref linkend=\"ST_SRID\"/>" 2347 2348#~ msgid "ST_GeomFromWKB" 2349#~ msgstr "ST_GeomFromWKB" 2350 2351#~ msgid "" 2352#~ "<funcprototype> <funcdef>geometry <function>ST_GeomFromWKB</function></" 2353#~ "funcdef> <paramdef><type>bytea </type> <parameter>geom</parameter></" 2354#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2355#~ "<function>ST_GeomFromWKB</function></funcdef> <paramdef><type>bytea </" 2356#~ "type> <parameter>geom</parameter></paramdef> <paramdef><type>integer </" 2357#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2358#~ msgstr "" 2359#~ "<funcprototype> <funcdef>geometry <function>ST_GeomFromWKB</function></" 2360#~ "funcdef> <paramdef><type>bytea </type> <parameter>geom</parameter></" 2361#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2362#~ "<function>ST_GeomFromWKB</function></funcdef> <paramdef><type>bytea </" 2363#~ "type> <parameter>geom</parameter></paramdef> <paramdef><type>integer </" 2364#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2365 2366#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.41" 2367#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.41" 2368 2369#~ msgid "" 2370#~ ", <xref linkend=\"ST_AsBinary\"/>, <xref linkend=\"ST_GeomFromEWKB\"/>" 2371#~ msgstr "" 2372#~ ", <xref linkend=\"ST_AsBinary\"/>, <xref linkend=\"ST_GeomFromEWKB\"/>" 2373 2374#~ msgid ", <xref linkend=\"ST_Collect\"/>, <xref linkend=\"ST_MakeLine\"/>" 2375#~ msgstr ", <xref linkend=\"ST_Collect\"/>, <xref linkend=\"ST_MakeLine\"/>" 2376 2377#~ msgid "ST_LineFromText" 2378#~ msgstr "ST_LineFromText" 2379 2380#~ msgid "" 2381#~ "<funcprototype> <funcdef>geometry <function>ST_LineFromText</function></" 2382#~ "funcdef> <paramdef><type>text </type> <parameter>WKT</parameter></" 2383#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2384#~ "<function>ST_LineFromText</function></funcdef> <paramdef><type>text </" 2385#~ "type> <parameter>WKT</parameter></paramdef> <paramdef><type>integer </" 2386#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2387#~ msgstr "" 2388#~ "<funcprototype> <funcdef>geometry <function>ST_LineFromText</function></" 2389#~ "funcdef> <paramdef><type>text </type> <parameter>WKT</parameter></" 2390#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2391#~ "<function>ST_LineFromText</function></funcdef> <paramdef><type>text </" 2392#~ "type> <parameter>WKT</parameter></paramdef> <paramdef><type>integer </" 2393#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2394 2395#~ msgid "&sqlmm_compliant; SQL-MM 3: 7.2.8" 2396#~ msgstr "&sqlmm_compliant; SQL-MM 3: 7.2.8" 2397 2398#~ msgid "" 2399#~ "SELECT ST_LineFromText('LINESTRING(1 2, 3 4)') AS aline, " 2400#~ "ST_LineFromText('POINT(1 2)') AS null_return;\n" 2401#~ "aline | null_return\n" 2402#~ "------------------------------------------------\n" 2403#~ "010200000002000000000000000000F ... | t" 2404#~ msgstr "" 2405#~ "SELECT ST_LineFromText('LINESTRING(1 2, 3 4)') AS aline, " 2406#~ "ST_LineFromText('POINT(1 2)') AS null_return;\n" 2407#~ "aline | null_return\n" 2408#~ "------------------------------------------------\n" 2409#~ "010200000002000000000000000000F ... | t" 2410 2411#~ msgid "ST_LineFromWKB" 2412#~ msgstr "ST_LineFromWKB" 2413 2414#~ msgid "" 2415#~ "<funcprototype> <funcdef>geometry <function>ST_LineFromWKB</function></" 2416#~ "funcdef> <paramdef><type>bytea </type> <parameter>WKB</parameter></" 2417#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2418#~ "<function>ST_LineFromWKB</function></funcdef> <paramdef><type>bytea </" 2419#~ "type> <parameter>WKB</parameter></paramdef> <paramdef><type>integer </" 2420#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2421#~ msgstr "" 2422#~ "<funcprototype> <funcdef>geometry <function>ST_LineFromWKB</function></" 2423#~ "funcdef> <paramdef><type>bytea </type> <parameter>WKB</parameter></" 2424#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2425#~ "<function>ST_LineFromWKB</function></funcdef> <paramdef><type>bytea </" 2426#~ "type> <parameter>WKB</parameter></paramdef> <paramdef><type>integer </" 2427#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2428 2429#~ msgid "&sqlmm_compliant; SQL-MM 3: 7.2.9" 2430#~ msgstr "&sqlmm_compliant; SQL-MM 3: 7.2.9" 2431 2432#~ msgid "" 2433#~ "SELECT ST_LineFromWKB(ST_AsBinary(ST_GeomFromText('LINESTRING(1 2, 3 " 2434#~ "4)'))) AS aline,\n" 2435#~ " ST_LineFromWKB(ST_AsBinary(ST_GeomFromText('POINT(1 " 2436#~ "2)'))) IS NULL AS null_return;\n" 2437#~ "aline | null_return\n" 2438#~ "------------------------------------------------\n" 2439#~ "010200000002000000000000000000F ... | t" 2440#~ msgstr "" 2441#~ "SELECT ST_LineFromWKB(ST_AsBinary(ST_GeomFromText('LINESTRING(1 2, 3 " 2442#~ "4)'))) AS aline,\n" 2443#~ " ST_LineFromWKB(ST_AsBinary(ST_GeomFromText('POINT(1 " 2444#~ "2)'))) IS NULL AS null_return;\n" 2445#~ "aline | null_return\n" 2446#~ "------------------------------------------------\n" 2447#~ "010200000002000000000000000000F ... | t" 2448 2449#~ msgid ", <xref linkend=\"ST_LinestringFromWKB\"/>" 2450#~ msgstr ", <xref linkend=\"ST_LinestringFromWKB\"/>" 2451 2452#~ msgid "ST_LinestringFromWKB" 2453#~ msgstr "ST_LinestringFromWKB" 2454 2455#~ msgid "" 2456#~ "<funcprototype> <funcdef>geometry <function>ST_LinestringFromWKB</" 2457#~ "function></funcdef> <paramdef><type>bytea </type> <parameter>WKB</" 2458#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2459#~ "<function>ST_LinestringFromWKB</function></funcdef> <paramdef><type>bytea " 2460#~ "</type> <parameter>WKB</parameter></paramdef> <paramdef><type>integer </" 2461#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2462#~ msgstr "" 2463#~ "<funcprototype> <funcdef>geometry <function>ST_LinestringFromWKB</" 2464#~ "function></funcdef> <paramdef><type>bytea </type> <parameter>WKB</" 2465#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2466#~ "<function>ST_LinestringFromWKB</function></funcdef> <paramdef><type>bytea " 2467#~ "</type> <parameter>WKB</parameter></paramdef> <paramdef><type>integer </" 2468#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2469 2470#~ msgid "" 2471#~ "SELECT\n" 2472#~ " ST_LineStringFromWKB(\n" 2473#~ " ST_AsBinary(ST_GeomFromText('LINESTRING(1 2, 3 4)'))\n" 2474#~ " ) AS aline,\n" 2475#~ " ST_LinestringFromWKB(\n" 2476#~ " ST_AsBinary(ST_GeomFromText('POINT(1 2)'))\n" 2477#~ " ) IS NULL AS null_return;\n" 2478#~ " aline | null_return\n" 2479#~ "------------------------------------------------\n" 2480#~ "010200000002000000000000000000F ... | t" 2481#~ msgstr "" 2482#~ "SELECT\n" 2483#~ " ST_LineStringFromWKB(\n" 2484#~ " ST_AsBinary(ST_GeomFromText('LINESTRING(1 2, 3 4)'))\n" 2485#~ " ) AS aline,\n" 2486#~ " ST_LinestringFromWKB(\n" 2487#~ " ST_AsBinary(ST_GeomFromText('POINT(1 2)'))\n" 2488#~ " ) IS NULL AS null_return;\n" 2489#~ " aline | null_return\n" 2490#~ "------------------------------------------------\n" 2491#~ "010200000002000000000000000000F ... | t" 2492 2493#~ msgid ", <xref linkend=\"ST_LineFromWKB\"/>" 2494#~ msgstr ", <xref linkend=\"ST_LineFromWKB\"/>" 2495 2496#~ msgid "ST_MakeBox2D" 2497#~ msgstr "ST_MakeBox2D" 2498 2499#~ msgid "" 2500#~ "<funcdef>box2d <function>ST_MakeBox2D</function></funcdef> " 2501#~ "<paramdef><type>geometry </type> <parameter>pointLowLeft</parameter></" 2502#~ "paramdef> <paramdef><type>geometry </type> <parameter>pointUpRight</" 2503#~ "parameter></paramdef>" 2504#~ msgstr "" 2505#~ "<funcdef>box2d <function>ST_MakeBox2D</function></funcdef> " 2506#~ "<paramdef><type>geometry </type> <parameter>pointLowLeft</parameter></" 2507#~ "paramdef> <paramdef><type>geometry </type> <parameter>pointUpRight</" 2508#~ "parameter></paramdef>" 2509 2510#~ msgid "" 2511#~ ", <xref linkend=\"ST_Point\"/>, <xref linkend=\"ST_SetSRID\"/>, <xref " 2512#~ "linkend=\"ST_SRID\"/>" 2513#~ msgstr "" 2514#~ ", <xref linkend=\"ST_Point\"/>, <xref linkend=\"ST_SetSRID\"/>, <xref " 2515#~ "linkend=\"ST_SRID\"/>" 2516 2517#~ msgid "ST_3DMakeBox" 2518#~ msgstr "ST_3DMakeBox" 2519 2520#~ msgid "" 2521#~ "<funcdef>box3d <function>ST_3DMakeBox</function></funcdef> " 2522#~ "<paramdef><type>geometry </type> <parameter>point3DLowLeftBottom</" 2523#~ "parameter></paramdef> <paramdef><type>geometry </type> " 2524#~ "<parameter>point3DUpRightTop</parameter></paramdef>" 2525#~ msgstr "" 2526#~ "<funcdef>box3d <function>ST_3DMakeBox</function></funcdef> " 2527#~ "<paramdef><type>geometry </type> <parameter>point3DLowLeftBottom</" 2528#~ "parameter></paramdef> <paramdef><type>geometry </type> " 2529#~ "<parameter>point3DUpRightTop</parameter></paramdef>" 2530 2531#~ msgid "" 2532#~ "SELECT ST_3DMakeBox(ST_MakePoint(-989502.1875, 528439.5625, 10),\n" 2533#~ " ST_MakePoint(-987121.375 ,529933.1875, 10)) As abb3d\n" 2534#~ "\n" 2535#~ "--bb3d--\n" 2536#~ "--------\n" 2537#~ "BOX3D(-989502.1875 528439.5625 10,-987121.375 529933.1875 10)" 2538#~ msgstr "" 2539#~ "SELECT ST_3DMakeBox(ST_MakePoint(-989502.1875, 528439.5625, 10),\n" 2540#~ " ST_MakePoint(-987121.375 ,529933.1875, 10)) As abb3d\n" 2541#~ "\n" 2542#~ "--bb3d--\n" 2543#~ "--------\n" 2544#~ "BOX3D(-989502.1875 528439.5625 10,-987121.375 529933.1875 10)" 2545 2546#~ msgid ", <xref linkend=\"ST_SetSRID\"/>, <xref linkend=\"ST_SRID\"/>" 2547#~ msgstr ", <xref linkend=\"ST_SetSRID\"/>, <xref linkend=\"ST_SRID\"/>" 2548 2549#~ msgid "" 2550#~ "SELECT ST_AsText(ST_MakeLine(ST_MakePoint(1,2), ST_MakePoint(3,4)));\n" 2551#~ " st_astext\n" 2552#~ "---------------------\n" 2553#~ " LINESTRING(1 2,3 4)\n" 2554#~ "\n" 2555#~ "SELECT userpoints.id, ST_MakeLine(startpoint, endpoint) As drawn_line\n" 2556#~ " FROM userpoints ;\n" 2557#~ "\n" 2558#~ "SELECT ST_AsEWKT(ST_MakeLine(ST_MakePoint(1,2,3), ST_MakePoint(3,4,5)));\n" 2559#~ " st_asewkt\n" 2560#~ "-------------------------\n" 2561#~ " LINESTRING(1 2 3,3 4 5)" 2562#~ msgstr "" 2563#~ "SELECT ST_AsText(ST_MakeLine(ST_MakePoint(1,2), ST_MakePoint(3,4)));\n" 2564#~ " st_astext\n" 2565#~ "---------------------\n" 2566#~ " LINESTRING(1 2,3 4)\n" 2567#~ "\n" 2568#~ "SELECT userpoints.id, ST_MakeLine(startpoint, endpoint) As drawn_line\n" 2569#~ " FROM userpoints ;\n" 2570#~ "\n" 2571#~ "SELECT ST_AsEWKT(ST_MakeLine(ST_MakePoint(1,2,3), ST_MakePoint(3,4,5)));\n" 2572#~ " st_asewkt\n" 2573#~ "-------------------------\n" 2574#~ " LINESTRING(1 2 3,3 4 5)" 2575 2576#~ msgid "" 2577#~ ", <xref linkend=\"ST_MakeLine\"/>, <xref linkend=\"ST_MakePolygon\"/>" 2578#~ msgstr "" 2579#~ ", <xref linkend=\"ST_MakeLine\"/>, <xref linkend=\"ST_MakePolygon\"/>" 2580 2581#~ msgid "" 2582#~ "--2d line\n" 2583#~ "SELECT ST_MakePolygon(ST_GeomFromText('LINESTRING(75.15 29.53,77 29,77.6 " 2584#~ "29.5, 75.15 29.53)'));\n" 2585#~ "--If linestring is not closed\n" 2586#~ "--you can add the start point to close it\n" 2587#~ "SELECT ST_MakePolygon(ST_AddPoint(foo.open_line, ST_StartPoint(foo." 2588#~ "open_line)))\n" 2589#~ "FROM (\n" 2590#~ "SELECT ST_GeomFromText('LINESTRING(75.15 29.53,77 29,77.6 29.5)') As " 2591#~ "open_line) As foo;\n" 2592#~ "\n" 2593#~ "--3d closed line\n" 2594#~ "SELECT ST_MakePolygon(ST_GeomFromText('LINESTRING(75.15 29.53 1,77 29 " 2595#~ "1,77.6 29.5 1, 75.15 29.53 1)'));\n" 2596#~ "\n" 2597#~ "st_asewkt\n" 2598#~ "-----------\n" 2599#~ "POLYGON((75.15 29.53 1,77 29 1,77.6 29.5 1,75.15 29.53 1))\n" 2600#~ "\n" 2601#~ "--measured line --\n" 2602#~ "SELECT ST_MakePolygon(ST_GeomFromText('LINESTRINGM(75.15 29.53 1,77 29 " 2603#~ "1,77.6 29.5 2, 75.15 29.53 2)'));\n" 2604#~ "\n" 2605#~ "st_asewkt\n" 2606#~ "----------\n" 2607#~ "POLYGONM((75.15 29.53 1,77 29 1,77.6 29.5 2,75.15 29.53 2))" 2608#~ msgstr "" 2609#~ "--linea 2d\n" 2610#~ "SELECT ST_MakePolygon(ST_GeomFromText('LINESTRING(75.15 29.53,77 29,77.6 " 2611#~ "29.5, 75.15 29.53)'));\n" 2612#~ "--se la linestring non è chiusa\n" 2613#~ "--potete aggiungere il punto iniziale per chiuderla\n" 2614#~ "SELECT ST_MakePolygon(ST_AddPoint(foo.open_line, ST_StartPoint(foo." 2615#~ "open_line)))\n" 2616#~ "FROM (\n" 2617#~ "SELECT ST_GeomFromText('LINESTRING(75.15 29.53,77 29,77.6 29.5)') As " 2618#~ "open_line) As foo;\n" 2619#~ "\n" 2620#~ "--linea 3d chiusa\n" 2621#~ "SELECT ST_MakePolygon(ST_GeomFromText('LINESTRING(75.15 29.53 1,77 29 " 2622#~ "1,77.6 29.5 1, 75.15 29.53 1)'));\n" 2623#~ "\n" 2624#~ "st_asewkt\n" 2625#~ "-----------\n" 2626#~ "POLYGON((75.15 29.53 1,77 29 1,77.6 29.5 1,75.15 29.53 1))\n" 2627#~ "\n" 2628#~ "--linea misurata --\n" 2629#~ "SELECT ST_MakePolygon(ST_GeomFromText('LINESTRINGM(75.15 29.53 1,77 29 " 2630#~ "1,77.6 29.5 2, 75.15 29.53 2)'));\n" 2631#~ "\n" 2632#~ "st_asewkt\n" 2633#~ "----------\n" 2634#~ "POLYGONM((75.15 29.53 1,77 29 1,77.6 29.5 2,75.15 29.53 2))" 2635 2636#~ msgid "" 2637#~ "<funcdef>geometry <function>ST_MakePoint</function></funcdef> " 2638#~ "<paramdef><type>double precision</type> <parameter>x</parameter></" 2639#~ "paramdef> <paramdef><type>double precision</type> <parameter>y</" 2640#~ "parameter></paramdef>" 2641#~ msgstr "" 2642#~ "<funcdef>geometry <function>ST_MakePoint</function></funcdef> " 2643#~ "<paramdef><type>double precision</type> <parameter>x</parameter></" 2644#~ "paramdef> <paramdef><type>double precision</type> <parameter>y</" 2645#~ "parameter></paramdef>" 2646 2647#~ msgid "" 2648#~ "<funcdef>geometry <function>ST_MakePoint</function></funcdef> " 2649#~ "<paramdef><type>double precision</type> <parameter>x</parameter></" 2650#~ "paramdef> <paramdef><type>double precision</type> <parameter>y</" 2651#~ "parameter></paramdef> <paramdef><type>double precision</type> " 2652#~ "<parameter>z</parameter></paramdef>" 2653#~ msgstr "" 2654#~ "<funcdef>geometry <function>ST_MakePoint</function></funcdef> " 2655#~ "<paramdef><type>double precision</type> <parameter>x</parameter></" 2656#~ "paramdef> <paramdef><type>double precision</type> <parameter>y</" 2657#~ "parameter></paramdef> <paramdef><type>double precision</type> " 2658#~ "<parameter>z</parameter></paramdef>" 2659 2660#~ msgid "ST_MLineFromText" 2661#~ msgstr "ST_MLineFromText" 2662 2663#~ msgid "" 2664#~ "<funcprototype> <funcdef>geometry <function>ST_MLineFromText</function></" 2665#~ "funcdef> <paramdef><type>text </type> <parameter>WKT</parameter></" 2666#~ "paramdef> <paramdef><type>integer </type> <parameter>srid</parameter></" 2667#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2668#~ "<function>ST_MLineFromText</function></funcdef> <paramdef><type>text </" 2669#~ "type> <parameter>WKT</parameter></paramdef> </funcprototype>" 2670#~ msgstr "" 2671#~ "<funcprototype> <funcdef>geometry <function>ST_MLineFromText</function></" 2672#~ "funcdef> <paramdef><type>text </type> <parameter>WKT</parameter></" 2673#~ "paramdef> <paramdef><type>integer </type> <parameter>srid</parameter></" 2674#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2675#~ "<function>ST_MLineFromText</function></funcdef> <paramdef><type>text </" 2676#~ "type> <parameter>WKT</parameter></paramdef> </funcprototype>" 2677 2678#~ msgid "&sqlmm_compliant;SQL-MM 3: 9.4.4" 2679#~ msgstr "&sqlmm_compliant;SQL-MM 3: 9.4.4" 2680 2681#~ msgid "ST_MPointFromText" 2682#~ msgstr "ST_MPointFromText" 2683 2684#~ msgid "" 2685#~ "<funcprototype> <funcdef>geometry <function>ST_MPointFromText</function></" 2686#~ "funcdef> <paramdef><type>text </type> <parameter>WKT</parameter></" 2687#~ "paramdef> <paramdef><type>integer </type> <parameter>srid</parameter></" 2688#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2689#~ "<function>ST_MPointFromText</function></funcdef> <paramdef><type>text </" 2690#~ "type> <parameter>WKT</parameter></paramdef> </funcprototype>" 2691#~ msgstr "" 2692#~ "<funcprototype> <funcdef>geometry <function>ST_MPointFromText</function></" 2693#~ "funcdef> <paramdef><type>text </type> <parameter>WKT</parameter></" 2694#~ "paramdef> <paramdef><type>integer </type> <parameter>srid</parameter></" 2695#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2696#~ "<function>ST_MPointFromText</function></funcdef> <paramdef><type>text </" 2697#~ "type> <parameter>WKT</parameter></paramdef> </funcprototype>" 2698 2699#~ msgid "&sfs_compliant; 3.2.6.2" 2700#~ msgstr "&sfs_compliant; 3.2.6.2" 2701 2702#~ msgid "&sqlmm_compliant; SQL-MM 3: 9.2.4" 2703#~ msgstr "&sqlmm_compliant; SQL-MM 3: 9.2.4" 2704 2705#~ msgid "" 2706#~ "SELECT ST_MPointFromText('MULTIPOINT(1 2, 3 4)');\n" 2707#~ "SELECT ST_MPointFromText('MULTIPOINT(-70.9590 42.1180, -70.9611 " 2708#~ "42.1223)', 4326);" 2709#~ msgstr "" 2710#~ "SELECT ST_MPointFromText('MULTIPOINT(1 2, 3 4)');\n" 2711#~ "SELECT ST_MPointFromText('MULTIPOINT(-70.9590 42.1180, -70.9611 " 2712#~ "42.1223)', 4326);" 2713 2714#~ msgid "ST_MPolyFromText" 2715#~ msgstr "ST_MPolyFromText" 2716 2717#~ msgid "" 2718#~ "<funcprototype> <funcdef>geometry <function>ST_MPolyFromText</function></" 2719#~ "funcdef> <paramdef><type>text </type> <parameter>WKT</parameter></" 2720#~ "paramdef> <paramdef><type>integer </type> <parameter>srid</parameter></" 2721#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2722#~ "<function>ST_MPolyFromText</function></funcdef> <paramdef><type>text </" 2723#~ "type> <parameter>WKT</parameter></paramdef> </funcprototype>" 2724#~ msgstr "" 2725#~ "<funcprototype> <funcdef>geometry <function>ST_MPolyFromText</function></" 2726#~ "funcdef> <paramdef><type>text </type> <parameter>WKT</parameter></" 2727#~ "paramdef> <paramdef><type>integer </type> <parameter>srid</parameter></" 2728#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2729#~ "<function>ST_MPolyFromText</function></funcdef> <paramdef><type>text </" 2730#~ "type> <parameter>WKT</parameter></paramdef> </funcprototype>" 2731 2732#~ msgid "&sqlmm_compliant; SQL-MM 3: 9.6.4" 2733#~ msgstr "&sqlmm_compliant; SQL-MM 3: 9.6.4" 2734 2735#~ msgid "" 2736#~ "SELECT ST_MPolyFromText('MULTIPOLYGON(((0 0 1,20 0 1,20 20 1,0 20 1,0 0 " 2737#~ "1),(5 5 3,5 7 3,7 7 3,7 5 3,5 5 3)))');\n" 2738#~ "SELECt ST_MPolyFromText('MULTIPOLYGON(((-70.916 42.1002,-70.9468 " 2739#~ "42.0946,-70.9765 42.0872,-70.9754 42.0875,-70.9749 42.0879,-70.9752 " 2740#~ "42.0881,-70.9754 42.0891,-70.9758 42.0894,-70.9759 42.0897,-70.9759 " 2741#~ "42.0899,-70.9754 42.0902,-70.9756 42.0906,-70.9753 42.0907,-70.9753 " 2742#~ "42.0917,-70.9757 42.0924,-70.9755 42.0928,-70.9755 42.0942,-70.9751 " 2743#~ "42.0948,-70.9755 42.0953,-70.9751 42.0958,-70.9751 42.0962,-70.9759 " 2744#~ "42.0983,-70.9767 42.0987,-70.9768 42.0991,-70.9771 42.0997,-70.9771 " 2745#~ "42.1003,-70.9768 42.1005,-70.977 42.1011,-70.9766 42.1019,-70.9768 " 2746#~ "42.1026,-70.9769 42.1033,-70.9775 42.1042,-70.9773 42.1043,-70.9776 " 2747#~ "42.1043,-70.9778 42.1048,-70.9773 42.1058,-70.9774 42.1061,-70.9779 " 2748#~ "42.1065,-70.9782 42.1078,-70.9788 42.1085,-70.9798 42.1087,-70.9806 " 2749#~ "42.109,-70.9807 42.1093,-70.9806 42.1099,-70.9809 42.1109,-70.9808 " 2750#~ "42.1112,-70.9798 42.1116,-70.9792 42.1127,-70.979 42.1129,-70.9787 " 2751#~ "42.1134,-70.979 42.1139,-70.9791 42.1141,-70.9987 42.1116,-71.0022 " 2752#~ "42.1273,\n" 2753#~ " -70.9408 42.1513,-70.9315 42.1165,-70.916 42.1002)))',4326);" 2754#~ msgstr "" 2755#~ "SELECT ST_MPolyFromText('MULTIPOLYGON(((0 0 1,20 0 1,20 20 1,0 20 1,0 0 " 2756#~ "1),(5 5 3,5 7 3,7 7 3,7 5 3,5 5 3)))');\n" 2757#~ "SELECt ST_MPolyFromText('MULTIPOLYGON(((-70.916 42.1002,-70.9468 " 2758#~ "42.0946,-70.9765 42.0872,-70.9754 42.0875,-70.9749 42.0879,-70.9752 " 2759#~ "42.0881,-70.9754 42.0891,-70.9758 42.0894,-70.9759 42.0897,-70.9759 " 2760#~ "42.0899,-70.9754 42.0902,-70.9756 42.0906,-70.9753 42.0907,-70.9753 " 2761#~ "42.0917,-70.9757 42.0924,-70.9755 42.0928,-70.9755 42.0942,-70.9751 " 2762#~ "42.0948,-70.9755 42.0953,-70.9751 42.0958,-70.9751 42.0962,-70.9759 " 2763#~ "42.0983,-70.9767 42.0987,-70.9768 42.0991,-70.9771 42.0997,-70.9771 " 2764#~ "42.1003,-70.9768 42.1005,-70.977 42.1011,-70.9766 42.1019,-70.9768 " 2765#~ "42.1026,-70.9769 42.1033,-70.9775 42.1042,-70.9773 42.1043,-70.9776 " 2766#~ "42.1043,-70.9778 42.1048,-70.9773 42.1058,-70.9774 42.1061,-70.9779 " 2767#~ "42.1065,-70.9782 42.1078,-70.9788 42.1085,-70.9798 42.1087,-70.9806 " 2768#~ "42.109,-70.9807 42.1093,-70.9806 42.1099,-70.9809 42.1109,-70.9808 " 2769#~ "42.1112,-70.9798 42.1116,-70.9792 42.1127,-70.979 42.1129,-70.9787 " 2770#~ "42.1134,-70.979 42.1139,-70.9791 42.1141,-70.9987 42.1116,-71.0022 " 2771#~ "42.1273,\n" 2772#~ " -70.9408 42.1513,-70.9315 42.1165,-70.916 42.1002)))',4326);" 2773 2774#~ msgid "" 2775#~ "-- the :: is PostgreSQL short-hand for casting.\n" 2776#~ "SELECT ST_SetSRID(ST_Point(-71.1043443253471, 42.3150676015829),4326)::" 2777#~ "geography;" 2778#~ msgstr "" 2779#~ "-- lo :: è l'abbreviazione PostgreSQL per il casting.\n" 2780#~ "SELECT ST_SetSRID(ST_Point(-71.1043443253471, 42.3150676015829),4326)::" 2781#~ "geography;" 2782 2783#~ msgid "ST_PointFromText" 2784#~ msgstr "ST_PointFromText" 2785 2786#~ msgid "" 2787#~ "<funcprototype> <funcdef>geometry <function>ST_PointFromText</function></" 2788#~ "funcdef> <paramdef><type>text </type> <parameter>WKT</parameter></" 2789#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2790#~ "<function>ST_PointFromText</function></funcdef> <paramdef><type>text </" 2791#~ "type> <parameter>WKT</parameter></paramdef> <paramdef><type>integer </" 2792#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2793#~ msgstr "" 2794#~ "<funcprototype> <funcdef>geometry <function>ST_PointFromText</function></" 2795#~ "funcdef> <paramdef><type>text </type> <parameter>WKT</parameter></" 2796#~ "paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2797#~ "<function>ST_PointFromText</function></funcdef> <paramdef><type>text </" 2798#~ "type> <parameter>WKT</parameter></paramdef> <paramdef><type>integer </" 2799#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2800 2801#~ msgid "&sqlmm_compliant; SQL-MM 3: 6.1.8" 2802#~ msgstr "&sqlmm_compliant; SQL-MM 3: 6.1.8" 2803 2804#~ msgid "" 2805#~ "SELECT ST_PointFromText('POINT(-71.064544 42.28787)');\n" 2806#~ "SELECT ST_PointFromText('POINT(-71.064544 42.28787)', 4326);" 2807#~ msgstr "" 2808#~ "SELECT ST_PointFromText('POINT(-71.064544 42.28787)');\n" 2809#~ "SELECT ST_PointFromText('POINT(-71.064544 42.28787)', 4326);" 2810 2811#~ msgid "ST_PointFromWKB" 2812#~ msgstr "ST_PointFromWKB" 2813 2814#~ msgid "&sfs_compliant; s3.2.7.2" 2815#~ msgstr "&sfs_compliant; s3.2.7.2" 2816 2817#~ msgid "&sqlmm_compliant; SQL-MM 3: 6.1.9" 2818#~ msgstr "&sqlmm_compliant; SQL-MM 3: 6.1.9" 2819 2820#~ msgid "" 2821#~ "SELECT\n" 2822#~ " ST_AsText(\n" 2823#~ " ST_PointFromWKB(\n" 2824#~ " ST_AsEWKB('POINT(2 5)'::geometry)\n" 2825#~ " )\n" 2826#~ " );\n" 2827#~ " st_astext\n" 2828#~ "------------\n" 2829#~ " POINT(2 5)\n" 2830#~ "(1 row)\n" 2831#~ "\n" 2832#~ "SELECT\n" 2833#~ " ST_AsText(\n" 2834#~ " ST_PointFromWKB(\n" 2835#~ " ST_AsEWKB('LINESTRING(2 5, 2 6)'::geometry)\n" 2836#~ " )\n" 2837#~ " );\n" 2838#~ " st_astext\n" 2839#~ "-----------\n" 2840#~ "\n" 2841#~ "(1 row)" 2842#~ msgstr "" 2843#~ "SELECT\n" 2844#~ " ST_AsText(\n" 2845#~ " ST_PointFromWKB(\n" 2846#~ " ST_AsEWKB('POINT(2 5)'::geometry)\n" 2847#~ " )\n" 2848#~ " );\n" 2849#~ " st_astext\n" 2850#~ "------------\n" 2851#~ " POINT(2 5)\n" 2852#~ "(1 row)\n" 2853#~ "\n" 2854#~ "SELECT\n" 2855#~ " ST_AsText(\n" 2856#~ " ST_PointFromWKB(\n" 2857#~ " ST_AsEWKB('LINESTRING(2 5, 2 6)'::geometry)\n" 2858#~ " )\n" 2859#~ " );\n" 2860#~ " st_astext\n" 2861#~ "-----------\n" 2862#~ "\n" 2863#~ "(1 row)" 2864 2865#~ msgid "" 2866#~ "--a 2d polygon\n" 2867#~ "SELECT ST_Polygon(ST_GeomFromText('LINESTRING(75.15 29.53,77 29,77.6 " 2868#~ "29.5, 75.15 29.53)'), 4326);\n" 2869#~ "\n" 2870#~ "--result--\n" 2871#~ "POLYGON((75.15 29.53,77 29,77.6 29.5,75.15 29.53))\n" 2872#~ "--a 3d polygon\n" 2873#~ "SELECT ST_AsEWKT(ST_Polygon(ST_GeomFromEWKT('LINESTRING(75.15 29.53 1,77 " 2874#~ "29 1,77.6 29.5 1, 75.15 29.53 1)'), 4326));\n" 2875#~ "\n" 2876#~ "result\n" 2877#~ "------\n" 2878#~ "SRID=4326;POLYGON((75.15 29.53 1,77 29 1,77.6 29.5 1,75.15 29.53 1))" 2879#~ msgstr "" 2880#~ "--un poligono 2d\n" 2881#~ "SELECT ST_Polygon(ST_GeomFromText('LINESTRING(75.15 29.53,77 29,77.6 " 2882#~ "29.5, 75.15 29.53)'), 4326);\n" 2883#~ "\n" 2884#~ "--risultato--\n" 2885#~ "POLYGON((75.15 29.53,77 29,77.6 29.5,75.15 29.53))\n" 2886#~ "--un poligono 3d \n" 2887#~ "SELECT ST_AsEWKT(ST_Polygon(ST_GeomFromEWKT('LINESTRING(75.15 29.53 1,77 " 2888#~ "29 1,77.6 29.5 1, 75.15 29.53 1)'), 4326));\n" 2889#~ "\n" 2890#~ "risultato\n" 2891#~ "------\n" 2892#~ "SRID=4326;POLYGON((75.15 29.53 1,77 29 1,77.6 29.5 1,75.15 29.53 1))" 2893 2894#~ msgid "ST_PolygonFromText" 2895#~ msgstr "ST_PolygonFromText" 2896 2897#~ msgid "" 2898#~ "<funcprototype> <funcdef>geometry <function>ST_PolygonFromText</" 2899#~ "function></funcdef> <paramdef><type>text </type> <parameter>WKT</" 2900#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2901#~ "<function>ST_PolygonFromText</function></funcdef> <paramdef><type>text </" 2902#~ "type> <parameter>WKT</parameter></paramdef> <paramdef><type>integer </" 2903#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2904#~ msgstr "" 2905#~ "<funcprototype> <funcdef>geometry <function>ST_PolygonFromText</" 2906#~ "function></funcdef> <paramdef><type>text </type> <parameter>WKT</" 2907#~ "parameter></paramdef> </funcprototype> <funcprototype> <funcdef>geometry " 2908#~ "<function>ST_PolygonFromText</function></funcdef> <paramdef><type>text </" 2909#~ "type> <parameter>WKT</parameter></paramdef> <paramdef><type>integer </" 2910#~ "type> <parameter>srid</parameter></paramdef> </funcprototype>" 2911 2912#~ msgid "&sqlmm_compliant; SQL-MM 3: 8.3.6" 2913#~ msgstr "&sqlmm_compliant; SQL-MM 3: 8.3.6" 2914 2915#~ msgid "" 2916#~ "SELECT ST_PolygonFromText('POLYGON((-71.1776585052917 " 2917#~ "42.3902909739571,-71.1776820268866 42.3903701743239,\n" 2918#~ "-71.1776063012595 42.3903825660754,-71.1775826583081 " 2919#~ "42.3903033653531,-71.1776585052917 42.3902909739571))');\n" 2920#~ "st_polygonfromtext\n" 2921#~ "------------------\n" 2922#~ "010300000001000000050000006...\n" 2923#~ "\n" 2924#~ "\n" 2925#~ "SELECT ST_PolygonFromText('POINT(1 2)') IS NULL as point_is_notpoly;\n" 2926#~ "\n" 2927#~ "point_is_not_poly\n" 2928#~ "----------\n" 2929#~ "t" 2930#~ msgstr "" 2931#~ "SELECT ST_PolygonFromText('POLYGON((-71.1776585052917 " 2932#~ "42.3902909739571,-71.1776820268866 42.3903701743239,\n" 2933#~ "-71.1776063012595 42.3903825660754,-71.1775826583081 " 2934#~ "42.3903033653531,-71.1776585052917 42.3902909739571))');\n" 2935#~ "st_polygonfromtext\n" 2936#~ "------------------\n" 2937#~ "010300000001000000050000006...\n" 2938#~ "\n" 2939#~ "\n" 2940#~ "SELECT ST_PolygonFromText('POINT(1 2)') IS NULL as point_is_notpoly;\n" 2941#~ "\n" 2942#~ "point_is_not_poly\n" 2943#~ "----------\n" 2944#~ "t" 2945 2946#~ msgid "ST_WKBToSQL" 2947#~ msgstr "ST_WKBToSQL" 2948 2949#~ msgid "" 2950#~ "<funcdef>geometry <function>ST_WKBToSQL</function></funcdef> " 2951#~ "<paramdef><type>bytea </type> <parameter>WKB</parameter></paramdef>" 2952#~ msgstr "" 2953#~ "<funcdef>geometry <function>ST_WKBToSQL</function></funcdef> " 2954#~ "<paramdef><type>bytea </type> <parameter>WKB</parameter></paramdef>" 2955 2956#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.36" 2957#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.36" 2958 2959#~ msgid "ST_WKTToSQL" 2960#~ msgstr "ST_WKTToSQL" 2961 2962#~ msgid "" 2963#~ "<funcdef>geometry <function>ST_WKTToSQL</function></funcdef> " 2964#~ "<paramdef><type>text </type> <parameter>WKT</parameter></paramdef>" 2965#~ msgstr "" 2966#~ "<funcdef>geometry <function>ST_WKTToSQL</function></funcdef> " 2967#~ "<paramdef><type>text </type> <parameter>WKT</parameter></paramdef>" 2968 2969#~ msgid "&sqlmm_compliant; SQL-MM 3: 5.1.34" 2970#~ msgstr "&sqlmm_compliant; SQL-MM 3: 5.1.34" 2971