1# SOME DESCRIPTIVE TITLE. 2# 3# Translators: 4# pibinko <pibinko@gmail.com>, 2014 5# pibinko <pibinko@gmail.com>, 2014 6# Sandro Santilli <strk.io>, 2013 7# Sandro Santilli <strk@kbt.io>, 2013 8# Sandro Santilli <strk@kbt.io>, 2013 9msgid "" 10msgstr "" 11"Project-Id-Version: PostGIS\n" 12"Report-Msgid-Bugs-To: http://bugs.kde.org\n" 13"POT-Creation-Date: 2019-10-06 23:48+0000\n" 14"PO-Revision-Date: 2018-07-23 18:01+0000\n" 15"Last-Translator: pibinko <pibinko@gmail.com>\n" 16"Language-Team: Italian (Italy) (http://www.transifex.com/postgis/postgis/" 17"language/it_IT/)\n" 18"Language: it_IT\n" 19"MIME-Version: 1.0\n" 20"Content-Type: text/plain; charset=UTF-8\n" 21"Content-Transfer-Encoding: 8bit\n" 22"Plural-Forms: nplurals=2; plural=(n != 1);\n" 23 24#. Tag: title 25#: extras_topology.xml:3 26#, no-c-format 27msgid "Topology" 28msgstr "Topologia" 29 30#. Tag: para 31#: extras_topology.xml:4 32#, no-c-format 33msgid "" 34"The PostGIS Topology types and functions are used to manage topological " 35"objects such as faces, edges and nodes." 36msgstr "" 37"I tipi e le funzioni della Topologia PostGIS si usano per gestire oggetti " 38"topologici quali facce, bordi e nodi." 39 40#. Tag: para 41#: extras_topology.xml:5 42#, no-c-format 43msgid "" 44"Sandro Santilli's presentation at PostGIS Day Paris 2011 conference gives a " 45"good synopsis of PostGIS Topology and where it is headed <ulink url=\"http://" 46"strk.kbt.io/projects/postgis/Paris2011_TopologyWithPostGIS_2_0.pdf" 47"\">Topology with PostGIS 2.0 slide deck</ulink>." 48msgstr "" 49 50#. Tag: para 51#: extras_topology.xml:6 52#, no-c-format 53msgid "" 54"Vincent Picavet provides a good synopsis and overview of what is Topology, " 55"how is it used, and various FOSS4G tools that support it in <ulink url=" 56"\"https://github.com/Oslandia/presentations/blob/master/pgconf_eu_2012/" 57"pgconfeu2012_vincent_picavet_postgis_topology.pdf?raw=true\">PostGIS " 58"Topology PGConf EU 2012</ulink>." 59msgstr "" 60 61#. Tag: para 62#: extras_topology.xml:7 63#, no-c-format 64msgid "" 65"An example of a topologically based GIS database is the <ulink url=\"https://" 66"www.census.gov/geo/maps-data/data/tiger.html\">US Census Topologically " 67"Integrated Geographic Encoding and Referencing System (TIGER)</ulink> " 68"database. If you want to experiment with PostGIS topology and need some " 69"data, check out <xref linkend=\"Topology_Load_Tiger\"/>." 70msgstr "" 71 72#. Tag: para 73#: extras_topology.xml:8 74#, no-c-format 75msgid "" 76"The PostGIS topology module has existed in prior versions of PostGIS but was " 77"never part of the Official PostGIS documentation. In PostGIS 2.0.0 major " 78"cleanup is going on to remove use of all deprecated functions in it, fix " 79"known usability issues, better document the features and functions, add new " 80"functions, and enhance to closer conform to SQL-MM standards." 81msgstr "" 82"Il modulo topologico era presente in versioni precedenti di PostGIS ma non " 83"era mai stato parte della documentazione ufficiale. A partire da PostGIS " 84"2.0.0 e' in corso una ripulitura generale per rimuovere le funzioni " 85"deprecate, risolvere noti problemi di usabilita', migliorare la " 86"documentazione delle funzioni, aggiungere funzioni e aumentare la " 87"conformita' con gli standard SQL-MM." 88 89#. Tag: para 90#: extras_topology.xml:10 91#, no-c-format 92msgid "" 93"Details of this project can be found at <ulink url=\"http://trac.osgeo.org/" 94"postgis/wiki/UsersWikiPostgisTopology\">PostGIS Topology Wiki</ulink>" 95msgstr "" 96"Dettagli del progetto si possono trovare sul <ulink url=\"http://trac.osgeo." 97"org/postgis/wiki/UsersWikiPostgisTopology\">PostGIS Topology Wiki</ulink>." 98 99#. Tag: para 100#: extras_topology.xml:11 101#, no-c-format 102msgid "" 103"All functions and tables associated with this module are installed in a " 104"schema called <varname>topology</varname>." 105msgstr "" 106"Tutte le funzioni e le tabelle associate con questo modulo sono installate " 107"in uno schema chiamato <varname>topology</varname>." 108 109#. Tag: para 110#: extras_topology.xml:12 111#, no-c-format 112msgid "" 113"Functions that are defined in SQL/MM standard are prefixed with ST_ and " 114"functions specific to PostGIS are not prefixed." 115msgstr "" 116"Le funzioni definite dallo standard SQL/MM hanno il prefisso ST_ e le " 117"funzioni specifiche di PostGIS sono senza prefisso." 118 119#. Tag: para 120#: extras_topology.xml:13 121#, no-c-format 122msgid "" 123"Topology support is build by default starting with PostGIS 2.0, and can be " 124"disabled specifying --without-topology configure option at build time as " 125"described in <xref linkend=\"postgis_installation\"/>" 126msgstr "" 127 128#. Tag: para 129#: extras_topology.xml:18 130#, no-c-format 131msgid "" 132"This section lists the PostgreSQL data types installed by PostGIS Topology. " 133"Note we describe the casting behavior of these which is very important " 134"especially when designing your own functions." 135msgstr "" 136"Questa sezione contiene una lista dei tipi di dato PostgreSQL installati " 137"dalla Topologia PostGIS. Nota che sono descritti i comportamenti di " 138"conversione di questi tipi di dato, informazione molto importante nel " 139"progettazione di funzioni proprie." 140 141#. Tag: title 142#: extras_topology.xml:23 143#, no-c-format 144msgid "Topology Types" 145msgstr "Tipi di dato topologici" 146 147#. Tag: refname 148#: extras_topology.xml:27 149#, no-c-format 150msgid "getfaceedges_returntype" 151msgstr "getfaceedges_returntype" 152 153#. Tag: refpurpose 154#: extras_topology.xml:28 155#, fuzzy, no-c-format 156msgid "" 157"A composite type that consists of a sequence number and edge number. This is " 158"the return type for <varname>ST_GetFaceEdges</varname>." 159msgstr "" 160"Un tipo composito che consiste in un numero sequenziale e un numero di " 161"\"bordo\". E' il tipo ritornato dalla funzione <varname>ST_GetFaceEdges</" 162"varname>." 163 164#. Tag: title 165#: extras_topology.xml:31 extras_topology.xml:50 extras_topology.xml:99 166#: extras_topology.xml:139 extras_topology.xml:186 extras_topology.xml:263 167#: extras_topology.xml:315 extras_topology.xml:357 extras_topology.xml:397 168#: extras_topology.xml:438 extras_topology.xml:475 extras_topology.xml:603 169#: extras_topology.xml:651 extras_topology.xml:699 extras_topology.xml:743 170#: extras_topology.xml:791 extras_topology.xml:835 extras_topology.xml:879 171#: extras_topology.xml:934 extras_topology.xml:980 extras_topology.xml:1027 172#: extras_topology.xml:1084 extras_topology.xml:1150 extras_topology.xml:1222 173#: extras_topology.xml:1290 extras_topology.xml:1356 extras_topology.xml:1411 174#: extras_topology.xml:1459 extras_topology.xml:1506 extras_topology.xml:1549 175#: extras_topology.xml:1603 extras_topology.xml:1644 extras_topology.xml:1691 176#: extras_topology.xml:1742 extras_topology.xml:1791 extras_topology.xml:1841 177#: extras_topology.xml:1883 extras_topology.xml:1925 extras_topology.xml:1968 178#: extras_topology.xml:2018 extras_topology.xml:2063 extras_topology.xml:2124 179#: extras_topology.xml:2182 extras_topology.xml:2223 extras_topology.xml:2280 180#: extras_topology.xml:2325 extras_topology.xml:2397 extras_topology.xml:2451 181#: extras_topology.xml:2520 extras_topology.xml:2596 extras_topology.xml:2641 182#: extras_topology.xml:2683 extras_topology.xml:2727 extras_topology.xml:2758 183#: extras_topology.xml:2796 extras_topology.xml:2844 extras_topology.xml:2944 184#: extras_topology.xml:2998 extras_topology.xml:3065 extras_topology.xml:3114 185#, no-c-format 186msgid "Description" 187msgstr "Descrizione" 188 189#. Tag: para 190#: extras_topology.xml:32 191#, no-c-format 192msgid "" 193"A composite type that consists of a sequence number and edge number. This is " 194"the return type for <varname>ST_GetFaceEdges</varname> function." 195msgstr "" 196"Un tipo composito che consiste in un numero sequenziale e un numero di " 197"\"bordo\". E' il tipo ritornato dalla funzione <varname>ST_GetFaceEdges</" 198"varname>." 199 200#. Tag: para 201#: extras_topology.xml:35 202#, no-c-format 203msgid "" 204"<varname>sequence</varname> is an integer: Refers to a topology defined in " 205"the topology.topology table which defines the topology schema and srid." 206msgstr "" 207"<varname>sequence</varname> e' un intero: si riferisce ad una topologia " 208"definita nella tabella topology.topology, che definisce lo schema e lo srid " 209"per la topologia." 210 211#. Tag: para 212#: extras_topology.xml:38 213#, no-c-format 214msgid "<varname>edge</varname> is an integer: The identifier of an edge." 215msgstr "<varname>edge</varname> e' un intero: l'identificativo di un bordo." 216 217#. Tag: refname 218#: extras_topology.xml:46 219#, no-c-format 220msgid "TopoGeometry" 221msgstr "" 222 223#. Tag: refpurpose 224#: extras_topology.xml:47 225#, no-c-format 226msgid "A composite type representing a topologically defined geometry." 227msgstr "" 228 229#. Tag: para 230#: extras_topology.xml:51 231#, no-c-format 232msgid "" 233"A composite type that refers to a topology geometry in a specific topology " 234"layer, having a specific type and a specific id. The elements of a " 235"TopoGeometry are the properties: topology_id, layer_id, id integer, type " 236"integer." 237msgstr "" 238 239#. Tag: para 240#: extras_topology.xml:54 241#, no-c-format 242msgid "" 243"<varname>topology_id</varname> is an integer: Refers to a topology defined " 244"in the topology.topology table which defines the topology schema and srid." 245msgstr "" 246 247#. Tag: para 248#: extras_topology.xml:57 249#, no-c-format 250msgid "" 251"<varname>layer_id</varname> is an integer: The layer_id in the layers table " 252"that the TopoGeometry belongs to. The combination of topology_id, layer_id " 253"provides a unique reference in the topology.layers table." 254msgstr "" 255 256#. Tag: para 257#: extras_topology.xml:60 258#, no-c-format 259msgid "" 260"<varname>id</varname> is an integer: The id is the autogenerated sequence " 261"number that uniquely defines the topogeometry in the respective topology " 262"layer." 263msgstr "" 264 265#. Tag: para 266#: extras_topology.xml:63 267#, no-c-format 268msgid "" 269"<varname>type</varname> integer between 1 - 4 that defines the geometry " 270"type: 1:[multi]point, 2:[multi]line, 3:[multi]poly, 4:collection" 271msgstr "" 272 273#. Tag: title 274#: extras_topology.xml:69 275#, no-c-format 276msgid "Casting Behavior" 277msgstr "Comportamento in caso di CAST" 278 279#. Tag: para 280#: extras_topology.xml:70 281#, no-c-format 282msgid "" 283"This section lists the automatic as well as explicit casts allowed for this " 284"data type" 285msgstr "" 286"Questa sezione illustra le modalità di CAST - automatici e espliciti - " 287"permessi per questo tipo di dato" 288 289#. Tag: entry 290#: extras_topology.xml:75 291#, no-c-format 292msgid "Cast To" 293msgstr "Cast verso" 294 295#. Tag: entry 296#: extras_topology.xml:76 297#, no-c-format 298msgid "Behavior" 299msgstr "Comportamento" 300 301#. Tag: entry 302#: extras_topology.xml:79 303#, no-c-format 304msgid "geometry" 305msgstr "" 306 307#. Tag: entry 308#: extras_topology.xml:80 309#, no-c-format 310msgid "automatic" 311msgstr "automatico" 312 313#. Tag: title 314#: extras_topology.xml:88 extras_topology.xml:117 extras_topology.xml:169 315#: extras_topology.xml:196 extras_topology.xml:288 extras_topology.xml:333 316#: extras_topology.xml:374 extras_topology.xml:416 extras_topology.xml:453 317#: extras_topology.xml:552 extras_topology.xml:628 extras_topology.xml:677 318#: extras_topology.xml:716 extras_topology.xml:765 extras_topology.xml:806 319#: extras_topology.xml:850 extras_topology.xml:894 extras_topology.xml:955 320#: extras_topology.xml:1002 extras_topology.xml:1058 extras_topology.xml:1123 321#: extras_topology.xml:1195 extras_topology.xml:1263 extras_topology.xml:1330 322#: extras_topology.xml:1379 extras_topology.xml:1428 extras_topology.xml:1478 323#: extras_topology.xml:1526 extras_topology.xml:1575 extras_topology.xml:1621 324#: extras_topology.xml:1662 extras_topology.xml:1716 extras_topology.xml:1762 325#: extras_topology.xml:1814 extras_topology.xml:1856 extras_topology.xml:1898 326#: extras_topology.xml:1940 extras_topology.xml:1991 extras_topology.xml:2036 327#: extras_topology.xml:2096 extras_topology.xml:2149 extras_topology.xml:2198 328#: extras_topology.xml:2257 extras_topology.xml:2297 extras_topology.xml:2374 329#: extras_topology.xml:2409 extras_topology.xml:2481 extras_topology.xml:2569 330#: extras_topology.xml:2610 extras_topology.xml:2660 extras_topology.xml:2701 331#: extras_topology.xml:2744 extras_topology.xml:2815 extras_topology.xml:2862 332#: extras_topology.xml:2976 extras_topology.xml:3029 extras_topology.xml:3090 333#: extras_topology.xml:3143 334#, no-c-format 335msgid "See Also" 336msgstr "Si veda anche" 337 338#. Tag: refname 339#: extras_topology.xml:95 340#, no-c-format 341msgid "validatetopology_returntype" 342msgstr "validatetopology_returntype" 343 344#. Tag: refpurpose 345#: extras_topology.xml:96 346#, fuzzy, no-c-format 347msgid "" 348"A composite type that consists of an error message and id1 and id2 to denote " 349"location of error. This is the return type for <varname>ValidateTopology</" 350"varname>." 351msgstr "" 352"Un tipo composito che consiste in un numero sequenziale e un numero di " 353"\"bordo\". E' il tipo ritornato dalla funzione <varname>ST_GetFaceEdges</" 354"varname>." 355 356#. Tag: para 357#: extras_topology.xml:100 358#, no-c-format 359msgid "" 360"A composite type that consists of an error message and two integers. The " 361"<xref linkend=\"ValidateTopology\"/> function returns a set of these to " 362"denote validation errors and the id1 and id2 to denote the ids of the " 363"topology objects involved in the error." 364msgstr "" 365 366#. Tag: para 367#: extras_topology.xml:103 368#, no-c-format 369msgid "<varname>error</varname> is varchar: Denotes type of error." 370msgstr "" 371 372#. Tag: para 373#: extras_topology.xml:104 374#, no-c-format 375msgid "" 376"Current error descriptors are: coincident nodes, edge crosses node, edge not " 377"simple, edge end node geometry mis-match, edge start node geometry mismatch, " 378"face overlaps face,face within face," 379msgstr "" 380 381#. Tag: para 382#: extras_topology.xml:107 383#, no-c-format 384msgid "" 385"<varname>id1</varname> is an integer: Denotes identifier of edge / face / " 386"nodes in error." 387msgstr "" 388 389#. Tag: para 390#: extras_topology.xml:110 391#, no-c-format 392msgid "" 393"<varname>id2</varname> is an integer: For errors that involve 2 objects " 394"denotes the secondary edge / or node" 395msgstr "" 396 397#. Tag: para 398#: extras_topology.xml:126 399#, no-c-format 400msgid "" 401"This section lists the PostgreSQL domains installed by PostGIS Topology. " 402"Domains can be used like object types as return objects of functions or " 403"table columns. The distinction between a domain and a type is that a domain " 404"is an existing type with a check constraint bound to it." 405msgstr "" 406 407#. Tag: title 408#: extras_topology.xml:131 409#, no-c-format 410msgid "Topology Domains" 411msgstr "" 412 413#. Tag: refname 414#: extras_topology.xml:135 415#, no-c-format 416msgid "TopoElement" 417msgstr "" 418 419#. Tag: refpurpose 420#: extras_topology.xml:136 421#, no-c-format 422msgid "" 423"An array of 2 integers generally used to identify a TopoGeometry component." 424msgstr "" 425 426#. Tag: para 427#: extras_topology.xml:140 428#, no-c-format 429msgid "" 430"An array of 2 integers used to represent one component of a simple or " 431"hierarchical <xref linkend=\"topogeometry\"/>." 432msgstr "" 433 434#. Tag: para 435#: extras_topology.xml:144 436#, no-c-format 437msgid "" 438"In the case of a simple TopoGeometry the first element of the array " 439"represents the identifier of a topological primitive and the second element " 440"represents its type (1:node, 2:edge, 3:face). In the case of a hierarchical " 441"TopoGeometry the first element of the array represents the identifier of a " 442"child TopoGeometry and the second element represents its layer identifier." 443msgstr "" 444 445#. Tag: para 446#: extras_topology.xml:153 447#, no-c-format 448msgid "" 449"For any given hierarchical TopoGeometry all child TopoGeometry elements will " 450"come from the same child layer, as specified in the topology.layer record " 451"for the layer of the TopoGeometry being defined." 452msgstr "" 453 454#. Tag: title 455#: extras_topology.xml:162 extras_topology.xml:190 extras_topology.xml:281 456#: extras_topology.xml:326 extras_topology.xml:368 extras_topology.xml:409 457#: extras_topology.xml:448 extras_topology.xml:546 extras_topology.xml:617 458#: extras_topology.xml:667 extras_topology.xml:710 extras_topology.xml:759 459#: extras_topology.xml:948 extras_topology.xml:995 extras_topology.xml:1051 460#: extras_topology.xml:1116 extras_topology.xml:1188 extras_topology.xml:1256 461#: extras_topology.xml:1324 extras_topology.xml:1373 extras_topology.xml:1520 462#: extras_topology.xml:1569 extras_topology.xml:1615 extras_topology.xml:1656 463#: extras_topology.xml:1708 extras_topology.xml:1755 extras_topology.xml:1806 464#: extras_topology.xml:1850 extras_topology.xml:1892 extras_topology.xml:1934 465#: extras_topology.xml:1984 extras_topology.xml:2030 extras_topology.xml:2251 466#: extras_topology.xml:2291 extras_topology.xml:2368 extras_topology.xml:2560 467#: extras_topology.xml:2606 extras_topology.xml:2654 extras_topology.xml:2695 468#: extras_topology.xml:2738 extras_topology.xml:2808 extras_topology.xml:2855 469#: extras_topology.xml:2967 extras_topology.xml:3034 extras_topology.xml:3083 470#: extras_topology.xml:3136 471#, no-c-format 472msgid "Examples" 473msgstr "Esempi" 474 475#. Tag: programlisting 476#: extras_topology.xml:163 477#, no-c-format 478msgid "" 479"SELECT te[1] AS id, te[2] AS type FROM\n" 480"( SELECT ARRAY[1,2]::topology.topoelement AS te ) f;\n" 481" id | type\n" 482"----+------\n" 483" 1 | 2" 484msgstr "" 485 486#. Tag: programlisting 487#: extras_topology.xml:164 488#, no-c-format 489msgid "" 490"SELECT ARRAY[1,2]::topology.topoelement;\n" 491" te\n" 492"-------\n" 493" {1,2}" 494msgstr "" 495"SELECT ARRAY[1,2]::topology.topoelement;\n" 496" te\n" 497"-------\n" 498" {1,2}" 499 500#. Tag: programlisting 501#: extras_topology.xml:165 502#, no-c-format 503msgid "" 504"--Example of what happens when you try to case a 3 element array to " 505"topoelement\n" 506"-- NOTE: topoement has to be a 2 element array so fails dimension check\n" 507"SELECT ARRAY[1,2,3]::topology.topoelement;\n" 508"ERROR: value for domain topology.topoelement violates check constraint " 509"\"dimensions\"" 510msgstr "" 511 512#. Tag: para 513#: extras_topology.xml:170 514#, no-c-format 515msgid "" 516", <xref linkend=\"topoelementarray\"/>, <xref linkend=\"topogeometry\"/>, " 517"<xref linkend=\"TopoGeom_addElement\"/>, <xref linkend=\"TopoGeom_remElement" 518"\"/>" 519msgstr "" 520 521#. Tag: refname 522#: extras_topology.xml:182 523#, no-c-format 524msgid "TopoElementArray" 525msgstr "TopoElementArray" 526 527#. Tag: refpurpose 528#: extras_topology.xml:183 529#, no-c-format 530msgid "An array of TopoElement objects." 531msgstr "" 532 533#. Tag: para 534#: extras_topology.xml:187 535#, no-c-format 536msgid "" 537"An array of 1 or more TopoElement objects, generally used to pass around " 538"components of TopoGeometry objects." 539msgstr "" 540 541#. Tag: programlisting 542#: extras_topology.xml:191 543#, no-c-format 544msgid "" 545"SELECT '{{1,2},{4,3}}'::topology.topoelementarray As tea;\n" 546" tea\n" 547"-------\n" 548"{{1,2},{4,3}}\n" 549"\n" 550"-- more verbose equivalent --\n" 551"SELECT ARRAY[ARRAY[1,2], ARRAY[4,3]]::topology.topoelementarray As tea;\n" 552"\n" 553" tea\n" 554"-------\n" 555"{{1,2},{4,3}}\n" 556"\n" 557"--using the array agg function packaged with topology --\n" 558"SELECT topology.TopoElementArray_Agg(ARRAY[e,t]) As tea\n" 559" FROM generate_series(1,4) As e CROSS JOIN generate_series(1,3) As t;\n" 560" tea\n" 561"--------------------------------------------------------------------------\n" 562"{{1,1},{1,2},{1,3},{2,1},{2,2},{2,3},{3,1},{3,2},{3,3},{4,1},{4,2},{4,3}}" 563msgstr "" 564 565#. Tag: programlisting 566#: extras_topology.xml:192 567#, no-c-format 568msgid "" 569"SELECT '{{1,2,4},{3,4,5}}'::topology.topoelementarray As tea;\n" 570"ERROR: value for domain topology.topoelementarray violates check constraint " 571"\"dimensions\"" 572msgstr "" 573"SELECT '{{1,2,4},{3,4,5}}'::topology.topoelementarray As tea;\n" 574"ERROR: value for domain topology.topoelementarray violates check constraint " 575"\"dimensions\"" 576 577#. Tag: para 578#: extras_topology.xml:197 579#, no-c-format 580msgid "" 581", <xref linkend=\"GetTopoGeomElementArray\"/>, <xref linkend=" 582"\"TopoElementArray_Agg\"/>" 583msgstr "" 584", <xref linkend=\"GetTopoGeomElementArray\"/>, <xref linkend=" 585"\"TopoElementArray_Agg\"/>" 586 587#. Tag: para 588#: extras_topology.xml:209 589#, no-c-format 590msgid "" 591"This section lists the Topology functions for building new Topology schemas, " 592"validating topologies, and managing TopoGeometry Columns" 593msgstr "" 594 595#. Tag: title 596#: extras_topology.xml:212 597#, no-c-format 598msgid "Topology and TopoGeometry Management" 599msgstr "" 600 601#. Tag: refname 602#: extras_topology.xml:215 603#, no-c-format 604msgid "AddTopoGeometryColumn" 605msgstr "AddTopoGeometryColumn" 606 607#. Tag: refpurpose 608#: extras_topology.xml:216 609#, no-c-format 610msgid "" 611"Adds a topogeometry column to an existing table, registers this new column " 612"as a layer in topology.layer and returns the new layer_id." 613msgstr "" 614 615#. Tag: funcsynopsis 616#: extras_topology.xml:220 617#, no-c-format 618msgid "" 619"<funcprototype> <funcdef>integer <function>AddTopoGeometryColumn</function></" 620"funcdef> <paramdef><type>varchar </type> <parameter>topology_name</" 621"parameter></paramdef> <paramdef><type>varchar </type> " 622"<parameter>schema_name</parameter></paramdef> <paramdef><type>varchar </" 623"type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar </" 624"type> <parameter>column_name</parameter></paramdef> <paramdef><type>varchar " 625"</type> <parameter>feature_type</parameter></paramdef> </funcprototype> " 626"<funcprototype> <funcdef>integer <function>AddTopoGeometryColumn</function></" 627"funcdef> <paramdef><type>varchar </type> <parameter>topology_name</" 628"parameter></paramdef> <paramdef><type>varchar </type> " 629"<parameter>schema_name</parameter></paramdef> <paramdef><type>varchar </" 630"type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar </" 631"type> <parameter>column_name</parameter></paramdef> <paramdef><type>varchar " 632"</type> <parameter>feature_type</parameter></paramdef> " 633"<paramdef><type>integer </type> <parameter>child_layer</parameter></" 634"paramdef> </funcprototype>" 635msgstr "" 636 637#. Tag: para 638#: extras_topology.xml:265 639#, no-c-format 640msgid "" 641"Each TopoGeometry object belongs to a specific Layer of a specific Topology. " 642"Before creating a TopoGeometry object you need to create its TopologyLayer. " 643"A Topology Layer is an association of a feature-table with the topology. It " 644"also contain type and hierarchy information. We create a layer using the " 645"AddTopoGeometryColumn() function:" 646msgstr "" 647 648#. Tag: para 649#: extras_topology.xml:267 650#, no-c-format 651msgid "" 652"This function will both add the requested column to the table and add a " 653"record to the topology.layer table with all the given info." 654msgstr "" 655 656#. Tag: para 657#: extras_topology.xml:268 658#, no-c-format 659msgid "" 660"If you don't specify [child_layer] (or set it to NULL) this layer would " 661"contain Basic TopoGeometries (composed by primitive topology elements). " 662"Otherwise this layer will contain hierarchical TopoGeometries (composed by " 663"TopoGeometries from the child_layer)." 664msgstr "" 665 666#. Tag: para 667#: extras_topology.xml:271 668#, no-c-format 669msgid "" 670"Once the layer is created (its id is returned by the AddTopoGeometryColumn " 671"function) you're ready to construct TopoGeometry objects in it" 672msgstr "" 673 674#. Tag: para 675#: extras_topology.xml:272 676#, no-c-format 677msgid "" 678"Valid <varname>feature_type</varname>s are: POINT, LINE, POLYGON, COLLECTION" 679msgstr "" 680 681#. Tag: para 682#: extras_topology.xml:275 extras_topology.xml:321 extras_topology.xml:363 683#: extras_topology.xml:612 extras_topology.xml:704 extras_topology.xml:942 684#: extras_topology.xml:989 extras_topology.xml:1366 extras_topology.xml:1514 685#: extras_topology.xml:1563 extras_topology.xml:1609 extras_topology.xml:1650 686#: extras_topology.xml:1845 extras_topology.xml:1929 extras_topology.xml:2024 687#: extras_topology.xml:2459 extras_topology.xml:2803 688#, no-c-format 689msgid "Availability: 1.?" 690msgstr "" 691 692#. Tag: programlisting 693#: extras_topology.xml:282 694#, no-c-format 695msgid "" 696"-- Note for this example we created our new table in the ma_topo schema\n" 697"-- though we could have created it in a different schema -- in which case " 698"topology_name and schema_name would be different\n" 699"CREATE SCHEMA ma;\n" 700"CREATE TABLE ma.parcels(gid serial, parcel_id varchar(20) PRIMARY KEY, " 701"address text);\n" 702"SELECT topology.AddTopoGeometryColumn('ma_topo', 'ma', 'parcels', 'topo', " 703"'POLYGON');" 704msgstr "" 705 706#. Tag: programlisting 707#: extras_topology.xml:283 708#, no-c-format 709msgid "" 710"CREATE SCHEMA ri;\n" 711"CREATE TABLE ri.roads(gid serial PRIMARY KEY, road_name text);\n" 712"SELECT topology.AddTopoGeometryColumn('ri_topo', 'ri', 'roads', 'topo', " 713"'LINE');" 714msgstr "" 715"CREATE SCHEMA ri;\n" 716"CREATE TABLE ri.roads(gid serial PRIMARY KEY, road_name text);\n" 717"SELECT topology.AddTopoGeometryColumn('ri_topo', 'ri', 'roads', 'topo', " 718"'LINE');" 719 720#. Tag: para 721#: extras_topology.xml:290 722#, fuzzy, no-c-format 723msgid "" 724", <xref linkend=\"toTopoGeom\"/>, <xref linkend=\"CreateTopology\"/>, <xref " 725"linkend=\"CreateTopoGeom\"/>" 726msgstr "" 727", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyName\"/>, " 728"<xref linkend=\"GetTopologyID\"/>" 729 730#. Tag: refname 731#: extras_topology.xml:300 732#, no-c-format 733msgid "DropTopology" 734msgstr "DropTopology" 735 736#. Tag: refpurpose 737#: extras_topology.xml:302 738#, no-c-format 739msgid "" 740"Use with caution: Drops a topology schema and deletes its reference from " 741"topology.topology table and references to tables in that schema from the " 742"geometry_columns table." 743msgstr "" 744 745#. Tag: funcprototype 746#: extras_topology.xml:307 747#, no-c-format 748msgid "" 749"<funcdef>integer <function>DropTopology</function></funcdef> " 750"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></" 751"paramdef>" 752msgstr "" 753"<funcdef>integer <function>DropTopology</function></funcdef> " 754"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></" 755"paramdef>" 756 757#. Tag: para 758#: extras_topology.xml:317 759#, no-c-format 760msgid "" 761"Drops a topology schema and deletes its reference from topology.topology " 762"table and references to tables in that schema from the geometry_columns " 763"table. This function should be USED WITH CAUTION, as it could destroy data " 764"you care about. If the schema does not exist, it just removes reference " 765"entries the named schema." 766msgstr "" 767 768#. Tag: para 769#: extras_topology.xml:327 770#, no-c-format 771msgid "" 772"Cascade drops the ma_topo schema and removes all references to it in " 773"topology.topology and geometry_columns." 774msgstr "" 775 776#. Tag: programlisting 777#: extras_topology.xml:328 778#, no-c-format 779msgid "SELECT topology.DropTopology('ma_topo');" 780msgstr "SELECT topology.DropTopology('ma_topo');" 781 782#. Tag: refname 783#: extras_topology.xml:340 784#, no-c-format 785msgid "DropTopoGeometryColumn" 786msgstr "DropTopoGeometryColumn" 787 788#. Tag: refpurpose 789#: extras_topology.xml:342 790#, no-c-format 791msgid "" 792"Drops the topogeometry column from the table named <varname>table_name</" 793"varname> in schema <varname>schema_name</varname> and unregisters the " 794"columns from topology.layer table." 795msgstr "" 796 797#. Tag: funcprototype 798#: extras_topology.xml:347 799#, no-c-format 800msgid "" 801"<funcdef>text <function>DropTopoGeometryColumn</function></funcdef> " 802"<paramdef><type>varchar </type> <parameter>schema_name</parameter></" 803"paramdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></" 804"paramdef> <paramdef><type>varchar </type> <parameter>column_name</" 805"parameter></paramdef>" 806msgstr "" 807"<funcdef>text <function>DropTopoGeometryColumn</function></funcdef> " 808"<paramdef><type>varchar </type> <parameter>schema_name</parameter></" 809"paramdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></" 810"paramdef> <paramdef><type>varchar </type> <parameter>column_name</" 811"parameter></paramdef>" 812 813#. Tag: para 814#: extras_topology.xml:359 815#, no-c-format 816msgid "" 817"Drops the topogeometry column from the table named <varname>table_name</" 818"varname> in schema <varname>schema_name</varname> and unregisters the " 819"columns from topology.layer table. Returns summary of drop status. NOTE: it " 820"first sets all values to NULL before dropping to bypass referential " 821"integrity checks." 822msgstr "" 823 824#. Tag: programlisting 825#: extras_topology.xml:369 826#, no-c-format 827msgid "" 828"SELECT topology.DropTopoGeometryColumn('ma_topo', 'parcel_topo', 'topo');" 829msgstr "" 830"SELECT topology.DropTopoGeometryColumn('ma_topo', 'parcel_topo', 'topo');" 831 832#. Tag: refname 833#: extras_topology.xml:381 834#, no-c-format 835msgid "Populate_Topology_Layer" 836msgstr "" 837 838#. Tag: refpurpose 839#: extras_topology.xml:383 840#, no-c-format 841msgid "" 842"Adds missing entries to topology.layer table by reading metadata from topo " 843"tables." 844msgstr "" 845 846#. Tag: funcprototype 847#: extras_topology.xml:389 848#, no-c-format 849msgid "" 850"<funcdef>setof record <function>Populate_Topology_Layer</function></funcdef> " 851"<paramdef></paramdef>" 852msgstr "" 853 854#. Tag: para 855#: extras_topology.xml:399 856#, no-c-format 857msgid "" 858"Adds missing entries to the <varname>topology.layer</varname> table by " 859"inspecting topology constraints on tables. This function is useful for " 860"fixing up entries in topology catalog after restores of schemas with topo " 861"data." 862msgstr "" 863 864#. Tag: para 865#: extras_topology.xml:401 866#, no-c-format 867msgid "" 868"It returns the list of entries created. Returned columns are " 869"<varname>schema_name</varname>, <varname>table_name</varname>, " 870"<varname>feature_column</varname>." 871msgstr "" 872 873#. Tag: para 874#: extras_topology.xml:404 875#, no-c-format 876msgid "Availability: 2.3.0" 877msgstr "" 878 879#. Tag: programlisting 880#: extras_topology.xml:410 881#, no-c-format 882msgid "" 883"SELECT CreateTopology('strk_topo');\n" 884"CREATE SCHEMA strk;\n" 885"CREATE TABLE strk.parcels(gid serial, parcel_id varchar(20) PRIMARY KEY, " 886"address text);\n" 887"SELECT topology.AddTopoGeometryColumn('strk_topo', 'strk', 'parcels', " 888"'topo', 'POLYGON');\n" 889"-- this will return no records because this feature is already registered\n" 890"SELECT *\n" 891" FROM topology.Populate_Topology_Layer();\n" 892"\n" 893"-- let's rebuild\n" 894"TRUNCATE TABLE topology.layer;\n" 895"\n" 896"SELECT *\n" 897" FROM topology.Populate_Topology_Layer();\n" 898"\n" 899"SELECT topology_id,layer_id, schema_name As sn, table_name As tn, " 900"feature_column As fc\n" 901"FROM topology.layer;" 902msgstr "" 903 904#. Tag: screen 905#: extras_topology.xml:411 906#, no-c-format 907msgid "" 908"schema_name | table_name | feature_column\n" 909"-------------+------------+----------------\n" 910" strk | parcels | topo\n" 911"(1 row)\n" 912"\n" 913" topology_id | layer_id | sn | tn | fc\n" 914"-------------+----------+------+---------+------\n" 915" 2 | 2 | strk | parcels | topo\n" 916"(1 row)" 917msgstr "" 918 919#. Tag: refname 920#: extras_topology.xml:423 921#, no-c-format 922msgid "TopologySummary" 923msgstr "TopologySummary" 924 925#. Tag: refpurpose 926#: extras_topology.xml:425 927#, no-c-format 928msgid "" 929"<refpurpose>Takes a topology name and provides summary totals of types of " 930"objects in topology.</refpurpose>" 931msgstr "" 932 933#. Tag: funcprototype 934#: extras_topology.xml:430 935#, no-c-format 936msgid "" 937"<funcdef>text <function>TopologySummary</function></funcdef> " 938"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></" 939"paramdef>" 940msgstr "" 941"<funcdef>text <function>TopologySummary</function></funcdef> " 942"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></" 943"paramdef>" 944 945#. Tag: para 946#: extras_topology.xml:440 947#, no-c-format 948msgid "" 949"<para>Takes a topology name and provides summary totals of types of objects " 950"in topology.</para>" 951msgstr "" 952 953#. Tag: para 954#: extras_topology.xml:443 extras_topology.xml:662 extras_topology.xml:800 955#: extras_topology.xml:844 extras_topology.xml:888 extras_topology.xml:1703 956#: extras_topology.xml:1752 extras_topology.xml:1801 extras_topology.xml:1887 957#: extras_topology.xml:2090 extras_topology.xml:2193 extras_topology.xml:2246 958#: extras_topology.xml:2287 extras_topology.xml:2363 extras_topology.xml:2601 959#: extras_topology.xml:2850 extras_topology.xml:2962 960#, no-c-format 961msgid "Availability: 2.0.0" 962msgstr "Disponibilità: 2.0" 963 964#. Tag: programlisting 965#: extras_topology.xml:449 966#, no-c-format 967msgid "" 968"SELECT topology.topologysummary('city_data');\n" 969" topologysummary\n" 970"--------------------------------------------------------\n" 971" Topology city_data (329), SRID 4326, precision: 0\n" 972" 22 nodes, 24 edges, 10 faces, 29 topogeoms in 5 layers\n" 973" Layer 1, type Polygonal (3), 9 topogeoms\n" 974" Deploy: features.land_parcels.feature\n" 975" Layer 2, type Puntal (1), 8 topogeoms\n" 976" Deploy: features.traffic_signs.feature\n" 977" Layer 3, type Lineal (2), 8 topogeoms\n" 978" Deploy: features.city_streets.feature\n" 979" Layer 4, type Polygonal (3), 3 topogeoms\n" 980" Hierarchy level 1, child layer 1\n" 981" Deploy: features.big_parcels.feature\n" 982" Layer 5, type Puntal (1), 1 topogeoms\n" 983" Hierarchy level 1, child layer 2\n" 984" Deploy: features.big_signs.feature" 985msgstr "" 986 987#. Tag: refname 988#: extras_topology.xml:460 989#, no-c-format 990msgid "ValidateTopology" 991msgstr "ValidateTopology" 992 993#. Tag: refpurpose 994#: extras_topology.xml:462 995#, no-c-format 996msgid "" 997"Returns a set of validatetopology_returntype objects detailing issues with " 998"topology." 999msgstr "" 1000 1001#. Tag: funcprototype 1002#: extras_topology.xml:467 1003#, no-c-format 1004msgid "" 1005"<funcdef>setof validatetopology_returntype <function>ValidateTopology</" 1006"function></funcdef> <paramdef><type>varchar </type> " 1007"<parameter>topology_schema_name</parameter></paramdef>" 1008msgstr "" 1009"<funcdef>setof validatetopology_returntype <function>ValidateTopology</" 1010"function></funcdef> <paramdef><type>varchar </type> " 1011"<parameter>topology_schema_name</parameter></paramdef>" 1012 1013#. Tag: para 1014#: extras_topology.xml:477 1015#, no-c-format 1016msgid "" 1017"Returns a set of <xref linkend=\"validatetopology_returntype\"/> objects " 1018"detailing issues with topology. List of possible errors and what the " 1019"returned ids represent are displayed below:" 1020msgstr "" 1021 1022#. Tag: entry 1023#: extras_topology.xml:481 1024#, no-c-format 1025msgid "Error" 1026msgstr "" 1027 1028#. Tag: entry 1029#: extras_topology.xml:481 1030#, no-c-format 1031msgid "<entry>id1</entry>" 1032msgstr "" 1033 1034#. Tag: entry 1035#: extras_topology.xml:481 1036#, no-c-format 1037msgid "<entry>id2</entry>" 1038msgstr "" 1039 1040#. Tag: entry 1041#: extras_topology.xml:484 1042#, no-c-format 1043msgid "edge crosses node" 1044msgstr "" 1045 1046#. Tag: entry 1047#: extras_topology.xml:485 extras_topology.xml:490 extras_topology.xml:495 1048#: extras_topology.xml:500 extras_topology.xml:501 extras_topology.xml:505 1049#: extras_topology.xml:510 1050#, no-c-format 1051msgid "edge_id" 1052msgstr "" 1053 1054#. Tag: entry 1055#: extras_topology.xml:486 extras_topology.xml:506 extras_topology.xml:511 1056#, no-c-format 1057msgid "node_id" 1058msgstr "" 1059 1060#. Tag: entry 1061#: extras_topology.xml:489 1062#, no-c-format 1063msgid "invalid edge" 1064msgstr "" 1065 1066#. Tag: entry 1067#: extras_topology.xml:491 extras_topology.xml:496 extras_topology.xml:516 1068#: extras_topology.xml:521 1069#, no-c-format 1070msgid "null" 1071msgstr "" 1072 1073#. Tag: entry 1074#: extras_topology.xml:494 1075#, no-c-format 1076msgid "edge not simple" 1077msgstr "" 1078 1079#. Tag: entry 1080#: extras_topology.xml:499 1081#, no-c-format 1082msgid "edge crosses edge" 1083msgstr "" 1084 1085#. Tag: entry 1086#: extras_topology.xml:504 1087#, no-c-format 1088msgid "edge start node geometry mis-match" 1089msgstr "" 1090 1091#. Tag: entry 1092#: extras_topology.xml:509 1093#, no-c-format 1094msgid "edge end node geometry mis-match" 1095msgstr "" 1096 1097#. Tag: entry 1098#: extras_topology.xml:514 1099#, no-c-format 1100msgid "face without edges" 1101msgstr "" 1102 1103#. Tag: entry 1104#: extras_topology.xml:515 extras_topology.xml:520 extras_topology.xml:525 1105#: extras_topology.xml:526 1106#, no-c-format 1107msgid "face_id" 1108msgstr "" 1109 1110#. Tag: entry 1111#: extras_topology.xml:519 1112#, no-c-format 1113msgid "face has no rings" 1114msgstr "" 1115 1116#. Tag: entry 1117#: extras_topology.xml:524 1118#, no-c-format 1119msgid "face overlaps face" 1120msgstr "" 1121 1122#. Tag: entry 1123#: extras_topology.xml:529 1124#, no-c-format 1125msgid "face within face" 1126msgstr "" 1127 1128#. Tag: entry 1129#: extras_topology.xml:530 1130#, no-c-format 1131msgid "inner face_id" 1132msgstr "" 1133 1134#. Tag: entry 1135#: extras_topology.xml:531 1136#, no-c-format 1137msgid "outer face_id" 1138msgstr "" 1139 1140#. Tag: para 1141#: extras_topology.xml:538 1142#, no-c-format 1143msgid "Availability: 1.0.0" 1144msgstr "" 1145 1146#. Tag: para 1147#: extras_topology.xml:540 1148#, no-c-format 1149msgid "" 1150"Enhanced: 2.0.0 more efficient edge crossing detection and fixes for false " 1151"positives that were existent in prior versions." 1152msgstr "" 1153 1154#. Tag: para 1155#: extras_topology.xml:541 1156#, no-c-format 1157msgid "" 1158"Changed: 2.2.0 values for id1 and id2 were swapped for 'edge crosses node' " 1159"to be consistent with error description." 1160msgstr "" 1161 1162#. Tag: programlisting 1163#: extras_topology.xml:547 1164#, no-c-format 1165msgid "" 1166"SELECT * FROM topology.ValidateTopology('ma_topo');\n" 1167" error | id1 | id2\n" 1168"-------------------+-----+-----\n" 1169"face without edges | 0 |" 1170msgstr "" 1171"SELECT * FROM topology.ValidateTopology('ma_topo');\n" 1172" error | id1 | id2\n" 1173"-------------------+-----+-----\n" 1174"face without edges | 0 |" 1175 1176#. Tag: para 1177#: extras_topology.xml:553 1178#, no-c-format 1179msgid ", <xref linkend=\"Topology_Load_Tiger\"/>" 1180msgstr ", <xref linkend=\"Topology_Load_Tiger\"/>" 1181 1182#. Tag: para 1183#: extras_topology.xml:561 1184#, no-c-format 1185msgid "This section covers the topology functions for creating new topologies." 1186msgstr "" 1187 1188#. Tag: title 1189#: extras_topology.xml:564 1190#, no-c-format 1191msgid "Topology Constructors" 1192msgstr "" 1193 1194#. Tag: refname 1195#: extras_topology.xml:568 1196#, no-c-format 1197msgid "CreateTopology" 1198msgstr "CreateTopology" 1199 1200#. Tag: refpurpose 1201#: extras_topology.xml:569 1202#, no-c-format 1203msgid "" 1204"Creates a new topology schema and registers this new schema in the topology." 1205"topology table." 1206msgstr "" 1207 1208#. Tag: funcsynopsis 1209#: extras_topology.xml:573 1210#, no-c-format 1211msgid "" 1212"<funcprototype> <funcdef>integer <function>CreateTopology</function></" 1213"funcdef> <paramdef><type>varchar </type> <parameter>topology_schema_name</" 1214"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>integer " 1215"<function>CreateTopology</function></funcdef> <paramdef><type>varchar </" 1216"type> <parameter>topology_schema_name</parameter></paramdef> " 1217"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef> </" 1218"funcprototype> <funcprototype> <funcdef>integer <function>CreateTopology</" 1219"function></funcdef> <paramdef><type>varchar </type> " 1220"<parameter>topology_schema_name</parameter></paramdef> " 1221"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef> " 1222"<paramdef><type>double precision </type> <parameter>prec</parameter></" 1223"paramdef> </funcprototype> <funcprototype> <funcdef>integer " 1224"<function>CreateTopology</function></funcdef> <paramdef><type>varchar </" 1225"type> <parameter>topology_schema_name</parameter></paramdef> " 1226"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef> " 1227"<paramdef><type>double precision </type> <parameter>prec</parameter></" 1228"paramdef> <paramdef><type>boolean </type> <parameter>hasz</parameter></" 1229"paramdef> </funcprototype>" 1230msgstr "" 1231 1232#. Tag: para 1233#: extras_topology.xml:605 1234#, no-c-format 1235msgid "" 1236"Creates a new schema with name <varname>topology_name</varname> consisting " 1237"of tables (<varname>edge_data</varname>,<varname>face</varname>," 1238"<varname>node</varname>, <varname>relation</varname> and registers this new " 1239"topology in the topology.topology table. It returns the id of the topology " 1240"in the topology table. The srid is the spatial reference identified as " 1241"defined in spatial_ref_sys table for that topology. Topologies must be " 1242"uniquely named. The tolerance is measured in the units of the spatial " 1243"reference system. If the tolerance (<varname>prec</varname>) is not " 1244"specified defaults to 0." 1245msgstr "" 1246 1247#. Tag: para 1248#: extras_topology.xml:609 1249#, no-c-format 1250msgid "" 1251"This is similar to the SQL/MM <xref linkend=\"ST_InitTopoGeo\"/> but a bit " 1252"more functional. <varname>hasz</varname> defaults to false if not specified." 1253msgstr "" 1254 1255#. Tag: para 1256#: extras_topology.xml:618 1257#, no-c-format 1258msgid "" 1259"This example creates a new schema called ma_topo that will store edges, " 1260"faces, and relations in Massachusetts State Plane meters. The tolerance " 1261"represents 1/2 meter since the spatial reference system is a meter based " 1262"spatial reference system" 1263msgstr "" 1264 1265#. Tag: programlisting 1266#: extras_topology.xml:620 1267#, no-c-format 1268msgid "SELECT topology.CreateTopology('ma_topo',26986, 0.5);" 1269msgstr "SELECT topology.CreateTopology('ma_topo',26986, 0.5);" 1270 1271#. Tag: para 1272#: extras_topology.xml:622 1273#, no-c-format 1274msgid "Create Rhode Island topology in State Plane ft" 1275msgstr "" 1276 1277#. Tag: programlisting 1278#: extras_topology.xml:623 1279#, no-c-format 1280msgid "" 1281"SELECT topology.CreateTopology('ri_topo',3438) As topoid;\n" 1282"topoid\n" 1283"------\n" 1284"2" 1285msgstr "" 1286"SELECT topology.CreateTopology('ri_topo',3438) As topoid;\n" 1287"topoid\n" 1288"------\n" 1289"2" 1290 1291#. Tag: para 1292#: extras_topology.xml:630 1293#, no-c-format 1294msgid "" 1295", <xref linkend=\"ST_InitTopoGeo\"/>, <xref linkend=\"Topology_Load_Tiger\"/>" 1296msgstr "" 1297", <xref linkend=\"ST_InitTopoGeo\"/>, <xref linkend=\"Topology_Load_Tiger\"/>" 1298 1299#. Tag: refname 1300#: extras_topology.xml:636 1301#, no-c-format 1302msgid "CopyTopology" 1303msgstr "CopyTopology" 1304 1305#. Tag: refpurpose 1306#: extras_topology.xml:637 1307#, no-c-format 1308msgid "" 1309"Makes a copy of a topology structure (nodes, edges, faces, layers and " 1310"TopoGeometries)." 1311msgstr "" 1312 1313#. Tag: funcprototype 1314#: extras_topology.xml:642 1315#, no-c-format 1316msgid "" 1317"<funcdef>integer <function>CopyTopology</function></funcdef> " 1318"<paramdef><type>varchar </type> <parameter>existing_topology_name</" 1319"parameter></paramdef> <paramdef><type>varchar </type> <parameter>new_name</" 1320"parameter></paramdef>" 1321msgstr "" 1322"<funcdef>integer <function>CopyTopology</function></funcdef> " 1323"<paramdef><type>varchar </type> <parameter>existing_topology_name</" 1324"parameter></paramdef> <paramdef><type>varchar </type> <parameter>new_name</" 1325"parameter></paramdef>" 1326 1327#. Tag: para 1328#: extras_topology.xml:653 1329#, no-c-format 1330msgid "" 1331"Creates a new topology with name <varname>new_topology_name</varname> and " 1332"SRID and precision taken from <varname>existing_topology_name</varname>, " 1333"copies all nodes, edges and faces in there, copies layers and their " 1334"TopoGeometries too." 1335msgstr "" 1336 1337#. Tag: para 1338#: extras_topology.xml:657 1339#, no-c-format 1340msgid "" 1341"The new rows in topology.layer will contain synthesized values for " 1342"schema_name, table_name and feature_column. This is because the TopoGeometry " 1343"will only exist as a definition but won't be available in any user-level " 1344"table yet." 1345msgstr "" 1346 1347#. Tag: para 1348#: extras_topology.xml:668 1349#, no-c-format 1350msgid "This example makes a backup of a topology called ma_topo" 1351msgstr "" 1352 1353#. Tag: programlisting 1354#: extras_topology.xml:671 1355#, no-c-format 1356msgid "SELECT topology.CopyTopology('ma_topo', 'ma_topo_bakup');" 1357msgstr "SELECT topology.CopyTopology('ma_topo', 'ma_topo_bakup');" 1358 1359#. Tag: para 1360#: extras_topology.xml:679 extras_topology.xml:2258 1361#, no-c-format 1362msgid ", <xref linkend=\"CreateTopology\"/>" 1363msgstr ", <xref linkend=\"CreateTopology\"/>" 1364 1365#. Tag: refname 1366#: extras_topology.xml:685 1367#, no-c-format 1368msgid "ST_InitTopoGeo" 1369msgstr "" 1370 1371#. Tag: refpurpose 1372#: extras_topology.xml:686 1373#, no-c-format 1374msgid "" 1375"Creates a new topology schema and registers this new schema in the topology." 1376"topology table and details summary of process." 1377msgstr "" 1378 1379#. Tag: funcprototype 1380#: extras_topology.xml:691 1381#, no-c-format 1382msgid "" 1383"<funcdef>text <function>ST_InitTopoGeo</function></funcdef> " 1384"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></" 1385"paramdef>" 1386msgstr "" 1387"<funcdef>text <function>ST_InitTopoGeo</function></funcdef> " 1388"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></" 1389"paramdef>" 1390 1391#. Tag: para 1392#: extras_topology.xml:701 1393#, no-c-format 1394msgid "" 1395"This is an SQL-MM equivalent of CreateTopology but lacks the spatial " 1396"reference and tolerance options of CreateTopology and outputs a text " 1397"description of creation instead of topology id." 1398msgstr "" 1399 1400#. Tag: para 1401#: extras_topology.xml:705 1402#, no-c-format 1403msgid "" 1404"&sqlmm_compliant; SQL-MM 3 Topo-Geo and Topo-Net 3: Routine Details: X.3.17" 1405msgstr "" 1406 1407#. Tag: programlisting 1408#: extras_topology.xml:711 1409#, no-c-format 1410msgid "" 1411"SELECT topology.ST_InitTopoGeo('topo_schema_to_create') AS topocreation;\n" 1412" astopocreation\n" 1413"------------------------------------------------------------\n" 1414" Topology-Geometry 'topo_schema_to_create' (id:7) created." 1415msgstr "" 1416"SELECT topology.ST_InitTopoGeo('topo_schema_to_create') AS topocreation;\n" 1417" astopocreation\n" 1418"------------------------------------------------------------\n" 1419" Topology-Geometry 'topo_schema_to_create' (id:7) created." 1420 1421#. Tag: refname 1422#: extras_topology.xml:725 1423#, no-c-format 1424msgid "ST_CreateTopoGeo" 1425msgstr "ST_CreateTopoGeo" 1426 1427#. Tag: refpurpose 1428#: extras_topology.xml:727 1429#, no-c-format 1430msgid "" 1431"<refpurpose>Adds a collection of geometries to a given empty topology and " 1432"returns a message detailing success.</refpurpose>" 1433msgstr "" 1434 1435#. Tag: funcprototype 1436#: extras_topology.xml:734 1437#, no-c-format 1438msgid "" 1439"<funcdef>text <function>ST_CreateTopoGeo</function></funcdef> " 1440"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1441"<paramdef><type>geometry </type> <parameter>acollection</parameter></" 1442"paramdef>" 1443msgstr "" 1444"<funcdef>text <function>ST_CreateTopoGeo</function></funcdef> " 1445"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1446"<paramdef><type>geometry </type> <parameter>acollection</parameter></" 1447"paramdef>" 1448 1449#. Tag: para 1450#: extras_topology.xml:745 1451#, no-c-format 1452msgid "" 1453"<para>Adds a collection of geometries to a given empty topology and returns " 1454"a message detailing success.</para>" 1455msgstr "" 1456 1457#. Tag: para 1458#: extras_topology.xml:749 1459#, no-c-format 1460msgid "Useful for populating an empty topology." 1461msgstr "" 1462 1463#. Tag: para 1464#: extras_topology.xml:753 extras_topology.xml:1045 extras_topology.xml:1110 1465#: extras_topology.xml:1182 extras_topology.xml:1250 extras_topology.xml:1421 1466#: extras_topology.xml:1471 extras_topology.xml:1978 extras_topology.xml:2144 1467#: extras_topology.xml:2556 1468#, no-c-format 1469msgid "Availability: 2.0" 1470msgstr "Disponibilità: 2.0" 1471 1472#. Tag: para 1473#: extras_topology.xml:754 1474#, no-c-format 1475msgid "" 1476"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details -- X.3.18" 1477msgstr "" 1478 1479#. Tag: programlisting 1480#: extras_topology.xml:760 1481#, no-c-format 1482msgid "" 1483"-- Populate topology --\n" 1484"SELECT topology.ST_CreateTopoGeo('ri_topo',\n" 1485" ST_GeomFromText('MULTILINESTRING((384744 236928,384750 236923,384769 " 1486"236911,384799 236895,384811 236890,384833 236884,\n" 1487" 384844 236882,384866 236881,384879 236883,384954 236898,385087 " 1488"236932,385117 236938,\n" 1489" 385167 236938,385203 236941,385224 236946,385233 236950,385241 " 1490"236956,385254 236971,\n" 1491" 385260 236979,385268 236999,385273 237018,385273 237037,385271 " 1492"237047,385267 237057,\n" 1493" 385225 237125,385210 237144,385192 237161,385167 237192,385162 " 1494"237202,385159 237214,\n" 1495" 385159 237227,385162 237241,385166 237256,385196 237324,385209 " 1496"237345,385234 237375,\n" 1497" 385237 237383,385238 237399,385236 237407,385227 237419,385213 " 1498"237430,385193 237439,\n" 1499" 385174 237451,385170 237455,385169 237460,385171 237475,385181 " 1500"237503,385190 237521,\n" 1501" 385200 237533,385206 237538,385213 237541,385221 237542,385235 " 1502"237540,385242 237541,\n" 1503" 385249 237544,385260 237555,385270 237570,385289 237584,385292 " 1504"237589,385291 237596,385284 237630))',3438)\n" 1505" );\n" 1506"\n" 1507" st_createtopogeo\n" 1508"----------------------------\n" 1509" Topology ri_topo populated\n" 1510"\n" 1511"\n" 1512"-- create tables and topo geometries --\n" 1513"CREATE TABLE ri.roads(gid serial PRIMARY KEY, road_name text);\n" 1514"\n" 1515"SELECT topology.AddTopoGeometryColumn('ri_topo', 'ri', 'roads', 'topo', " 1516"'LINE');" 1517msgstr "" 1518 1519#. Tag: para 1520#: extras_topology.xml:766 1521#, no-c-format 1522msgid ", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"DropTopology\"/>" 1523msgstr ", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"DropTopology\"/>" 1524 1525#. Tag: refname 1526#: extras_topology.xml:772 1527#, no-c-format 1528msgid "TopoGeo_AddPoint" 1529msgstr "TopoGeo_AddPoint" 1530 1531#. Tag: refpurpose 1532#: extras_topology.xml:774 1533#, no-c-format 1534msgid "" 1535"Adds a point to an existing topology using a tolerance and possibly " 1536"splitting an existing edge." 1537msgstr "" 1538 1539#. Tag: funcprototype 1540#: extras_topology.xml:781 1541#, fuzzy, no-c-format 1542msgid "" 1543"<funcdef>integer <function>TopoGeo_AddPoint</function></funcdef> " 1544"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1545"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 1546"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</" 1547"parameter></paramdef>" 1548msgstr "" 1549"<funcdef>integer <function>TopoGeo_AddPoint</function></funcdef> " 1550"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 1551"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 1552"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</" 1553"parameter></paramdef>" 1554 1555#. Tag: para 1556#: extras_topology.xml:793 1557#, no-c-format 1558msgid "" 1559"Adds a point to an existing topology and returns its identifier. The given " 1560"point will snap to existing nodes or edges within given tolerance. An " 1561"existing edge may be split by the snapped point." 1562msgstr "" 1563 1564#. Tag: para 1565#: extras_topology.xml:807 1566#, no-c-format 1567msgid "" 1568", <xref linkend=\"TopoGeo_AddPolygon\"/>, <xref linkend=\"AddNode\"/>, <xref " 1569"linkend=\"CreateTopology\"/>" 1570msgstr "" 1571", <xref linkend=\"TopoGeo_AddPolygon\"/>, <xref linkend=\"AddNode\"/>, <xref " 1572"linkend=\"CreateTopology\"/>" 1573 1574#. Tag: refname 1575#: extras_topology.xml:818 1576#, no-c-format 1577msgid "TopoGeo_AddLineString" 1578msgstr "TopoGeo_AddLineString" 1579 1580#. Tag: refpurpose 1581#: extras_topology.xml:820 1582#, no-c-format 1583msgid "" 1584"Adds a linestring to an existing topology using a tolerance and possibly " 1585"splitting existing edges/faces. Returns edge identifiers." 1586msgstr "" 1587 1588#. Tag: funcprototype 1589#: extras_topology.xml:825 1590#, fuzzy, no-c-format 1591msgid "" 1592"<funcdef>SETOF integer <function>TopoGeo_AddLineString</function></funcdef> " 1593"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1594"<paramdef><type>geometry </type> <parameter>aline</parameter></paramdef> " 1595"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</" 1596"parameter></paramdef>" 1597msgstr "" 1598"<funcdef>integer <function>TopoGeo_AddPoint</function></funcdef> " 1599"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 1600"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 1601"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</" 1602"parameter></paramdef>" 1603 1604#. Tag: para 1605#: extras_topology.xml:837 1606#, no-c-format 1607msgid "" 1608"Adds a linestring to an existing topology and returns a set of edge " 1609"identifiers forming it up. The given line will snap to existing nodes or " 1610"edges within given tolerance. Existing edges and faces may be split by the " 1611"line." 1612msgstr "" 1613 1614#. Tag: para 1615#: extras_topology.xml:851 1616#, no-c-format 1617msgid "" 1618", <xref linkend=\"TopoGeo_AddPolygon\"/>, <xref linkend=\"AddEdge\"/>, <xref " 1619"linkend=\"CreateTopology\"/>" 1620msgstr "" 1621", <xref linkend=\"TopoGeo_AddPolygon\"/>, <xref linkend=\"AddEdge\"/>, <xref " 1622"linkend=\"CreateTopology\"/>" 1623 1624#. Tag: refname 1625#: extras_topology.xml:862 1626#, no-c-format 1627msgid "TopoGeo_AddPolygon" 1628msgstr "TopoGeo_AddPolygon" 1629 1630#. Tag: refpurpose 1631#: extras_topology.xml:864 1632#, no-c-format 1633msgid "" 1634"Adds a polygon to an existing topology using a tolerance and possibly " 1635"splitting existing edges/faces. Returns face identifiers." 1636msgstr "" 1637 1638#. Tag: funcprototype 1639#: extras_topology.xml:869 1640#, fuzzy, no-c-format 1641msgid "" 1642"<funcdef>SETOF integer <function>TopoGeo_AddPolygon</function></funcdef> " 1643"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1644"<paramdef><type>geometry </type> <parameter>apoly</parameter></paramdef> " 1645"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</" 1646"parameter></paramdef>" 1647msgstr "" 1648"<funcdef>integer <function>TopoGeo_AddPoint</function></funcdef> " 1649"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 1650"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 1651"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</" 1652"parameter></paramdef>" 1653 1654#. Tag: para 1655#: extras_topology.xml:881 1656#, no-c-format 1657msgid "" 1658"Adds a polygon to an existing topology and returns a set of face identifiers " 1659"forming it up. The boundary of the given polygon will snap to existing nodes " 1660"or edges within given tolerance. Existing edges and faces may be split by " 1661"the boundary of the new polygon." 1662msgstr "" 1663 1664#. Tag: para 1665#: extras_topology.xml:895 1666#, no-c-format 1667msgid "" 1668", <xref linkend=\"TopoGeo_AddLineString\"/>, <xref linkend=\"AddFace\"/>, " 1669"<xref linkend=\"CreateTopology\"/>" 1670msgstr "" 1671", <xref linkend=\"TopoGeo_AddLineString\"/>, <xref linkend=\"AddFace\"/>, " 1672"<xref linkend=\"CreateTopology\"/>" 1673 1674#. Tag: para 1675#: extras_topology.xml:910 1676#, no-c-format 1677msgid "" 1678"This section covers topology functions for adding, moving, deleting, and " 1679"splitting edges, faces, and nodes. All of these functions are defined by ISO " 1680"SQL/MM." 1681msgstr "" 1682 1683#. Tag: title 1684#: extras_topology.xml:913 1685#, no-c-format 1686msgid "Topology Editors" 1687msgstr "" 1688 1689#. Tag: refname 1690#: extras_topology.xml:917 1691#, no-c-format 1692msgid "ST_AddIsoNode" 1693msgstr "ST_AddIsoNode" 1694 1695#. Tag: refpurpose 1696#: extras_topology.xml:919 1697#, no-c-format 1698msgid "" 1699"Adds an isolated node to a face in a topology and returns the nodeid of the " 1700"new node. If face is null, the node is still created." 1701msgstr "" 1702 1703#. Tag: funcprototype 1704#: extras_topology.xml:924 1705#, no-c-format 1706msgid "" 1707"<funcdef>integer <function>ST_AddIsoNode</function></funcdef> " 1708"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1709"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef> " 1710"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 1711msgstr "" 1712"<funcdef>integer <function>ST_AddIsoNode</function></funcdef> " 1713"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1714"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef> " 1715"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 1716 1717#. Tag: para 1718#: extras_topology.xml:936 1719#, no-c-format 1720msgid "" 1721"Adds an isolated node with point location <varname>apoint</varname> to an " 1722"existing face with faceid <varname>aface</varname> to a topology " 1723"<varname>atopology</varname> and returns the nodeid of the new node." 1724msgstr "" 1725 1726#. Tag: para 1727#: extras_topology.xml:937 1728#, no-c-format 1729msgid "" 1730"If the spatial reference system (srid) of the point geometry is not the same " 1731"as the topology, the <varname>apoint</varname> is not a point geometry, the " 1732"point is null, or the point intersects an existing edge (even at the " 1733"boundaries) then an exception is thrown. If the point already exists as a " 1734"node, an exception is thrown." 1735msgstr "" 1736 1737#. Tag: para 1738#: extras_topology.xml:939 1739#, no-c-format 1740msgid "" 1741"If <varname>aface</varname> is not null and the <varname>apoint</varname> is " 1742"not within the face, then an exception is thrown." 1743msgstr "" 1744 1745#. Tag: para 1746#: extras_topology.xml:943 1747#, no-c-format 1748msgid "&sqlmm_compliant; SQL-MM: Topo-Net Routines: X+1.3.1" 1749msgstr "" 1750 1751#. Tag: para 1752#: extras_topology.xml:956 1753#, no-c-format 1754msgid "" 1755", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"DropTopology\"/>, " 1756"<xref linkend=\"ST_Intersects\"/>" 1757msgstr "" 1758", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"DropTopology\"/>, " 1759"<xref linkend=\"ST_Intersects\"/>" 1760 1761#. Tag: refname 1762#: extras_topology.xml:962 1763#, no-c-format 1764msgid "ST_AddIsoEdge" 1765msgstr "ST_AddIsoEdge" 1766 1767#. Tag: refpurpose 1768#: extras_topology.xml:964 1769#, no-c-format 1770msgid "" 1771"<refpurpose>Adds an isolated edge defined by geometry <varname>alinestring</" 1772"varname> to a topology connecting two existing isolated nodes " 1773"<varname>anode</varname> and <varname>anothernode</varname> and returns the " 1774"edge id of the new edge.</refpurpose>" 1775msgstr "" 1776 1777#. Tag: funcprototype 1778#: extras_topology.xml:969 1779#, no-c-format 1780msgid "" 1781"<funcdef>integer <function>ST_AddIsoEdge</function></funcdef> " 1782"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1783"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> " 1784"<paramdef><type>integer </type> <parameter>anothernode</parameter></" 1785"paramdef> <paramdef><type>geometry </type> <parameter>alinestring</" 1786"parameter></paramdef>" 1787msgstr "" 1788"<funcdef>integer <function>ST_AddIsoEdge</function></funcdef> " 1789"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1790"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> " 1791"<paramdef><type>integer </type> <parameter>anothernode</parameter></" 1792"paramdef> <paramdef><type>geometry </type> <parameter>alinestring</" 1793"parameter></paramdef>" 1794 1795#. Tag: para 1796#: extras_topology.xml:982 1797#, no-c-format 1798msgid "" 1799"<para>Adds an isolated edge defined by geometry <varname>alinestring</" 1800"varname> to a topology connecting two existing isolated nodes " 1801"<varname>anode</varname> and <varname>anothernode</varname> and returns the " 1802"edge id of the new edge.</para>" 1803msgstr "" 1804 1805#. Tag: para 1806#: extras_topology.xml:983 1807#, no-c-format 1808msgid "" 1809"If the spatial reference system (srid) of the <varname>alinestring</varname> " 1810"geometry is not the same as the topology, any of the input arguments are " 1811"null, or the nodes are contained in more than one face, or the nodes are " 1812"start or end nodes of an existing edge, then an exception is thrown." 1813msgstr "" 1814 1815#. Tag: para 1816#: extras_topology.xml:985 1817#, no-c-format 1818msgid "" 1819"If the <varname>alinestring</varname> is not within the face of the face the " 1820"<varname>anode</varname> and <varname>anothernode</varname> belong to, then " 1821"an exception is thrown." 1822msgstr "" 1823 1824#. Tag: para 1825#: extras_topology.xml:986 1826#, no-c-format 1827msgid "" 1828"If the <varname>anode</varname> and <varname>anothernode</varname> are not " 1829"the start and end points of the <varname>alinestring</varname> then an " 1830"exception is thrown." 1831msgstr "" 1832 1833#. Tag: para 1834#: extras_topology.xml:990 1835#, no-c-format 1836msgid "" 1837"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.4" 1838msgstr "" 1839 1840#. Tag: para 1841#: extras_topology.xml:1003 1842#, no-c-format 1843msgid ", <xref linkend=\"ST_IsSimple\"/>, <xref linkend=\"ST_Within\"/>" 1844msgstr ", <xref linkend=\"ST_IsSimple\"/>, <xref linkend=\"ST_Within\"/>" 1845 1846#. Tag: refname 1847#: extras_topology.xml:1009 1848#, no-c-format 1849msgid "ST_AddEdgeNewFaces" 1850msgstr "ST_AddEdgeNewFaces" 1851 1852#. Tag: refpurpose 1853#: extras_topology.xml:1011 1854#, no-c-format 1855msgid "" 1856"Add a new edge and, if in doing so it splits a face, delete the original " 1857"face and replace it with two new faces." 1858msgstr "" 1859 1860#. Tag: funcprototype 1861#: extras_topology.xml:1016 1862#, no-c-format 1863msgid "" 1864"<funcdef>integer <function>ST_AddEdgeNewFaces</function></funcdef> " 1865"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1866"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> " 1867"<paramdef><type>integer </type> <parameter>anothernode</parameter></" 1868"paramdef> <paramdef><type>geometry </type> <parameter>acurve</parameter></" 1869"paramdef>" 1870msgstr "" 1871"<funcdef>integer <function>ST_AddEdgeNewFaces</function></funcdef> " 1872"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1873"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> " 1874"<paramdef><type>integer </type> <parameter>anothernode</parameter></" 1875"paramdef> <paramdef><type>geometry </type> <parameter>acurve</parameter></" 1876"paramdef>" 1877 1878#. Tag: para 1879#: extras_topology.xml:1029 1880#, no-c-format 1881msgid "" 1882"Add a new edge and, if in doing so it splits a face, delete the original " 1883"face and replace it with two new faces. Returns the id of the newly added " 1884"edge." 1885msgstr "" 1886 1887#. Tag: para 1888#: extras_topology.xml:1035 extras_topology.xml:1101 extras_topology.xml:1164 1889#: extras_topology.xml:1232 1890#, no-c-format 1891msgid "Updates all existing joined edges and relationships accordingly." 1892msgstr "" 1893 1894#. Tag: para 1895#: extras_topology.xml:1039 extras_topology.xml:1105 1896#, no-c-format 1897msgid "" 1898"If any arguments are null, the given nodes are unknown (must already exist " 1899"in the <varname>node</varname> table of the topology schema) , the " 1900"<varname>acurve</varname> is not a <varname>LINESTRING</varname>, the " 1901"<varname>anode</varname> and <varname>anothernode</varname> are not the " 1902"start and endpoints of <varname>acurve</varname> then an error is thrown." 1903msgstr "" 1904 1905#. Tag: para 1906#: extras_topology.xml:1042 extras_topology.xml:1108 extras_topology.xml:1303 1907#, no-c-format 1908msgid "" 1909"If the spatial reference system (srid) of the <varname>acurve</varname> " 1910"geometry is not the same as the topology an exception is thrown." 1911msgstr "" 1912 1913#. Tag: para 1914#: extras_topology.xml:1046 1915#, no-c-format 1916msgid "" 1917"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.12" 1918msgstr "" 1919 1920#. Tag: refname 1921#: extras_topology.xml:1066 1922#, no-c-format 1923msgid "ST_AddEdgeModFace" 1924msgstr "ST_AddEdgeModFace" 1925 1926#. Tag: refpurpose 1927#: extras_topology.xml:1068 1928#, no-c-format 1929msgid "" 1930"Add a new edge and, if in doing so it splits a face, modify the original " 1931"face and add a new face." 1932msgstr "" 1933 1934#. Tag: funcprototype 1935#: extras_topology.xml:1073 1936#, no-c-format 1937msgid "" 1938"<funcdef>integer <function>ST_AddEdgeModFace</function></funcdef> " 1939"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1940"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> " 1941"<paramdef><type>integer </type> <parameter>anothernode</parameter></" 1942"paramdef> <paramdef><type>geometry </type> <parameter>acurve</parameter></" 1943"paramdef>" 1944msgstr "" 1945"<funcdef>integer <function>ST_AddEdgeModFace</function></funcdef> " 1946"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1947"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> " 1948"<paramdef><type>integer </type> <parameter>anothernode</parameter></" 1949"paramdef> <paramdef><type>geometry </type> <parameter>acurve</parameter></" 1950"paramdef>" 1951 1952#. Tag: para 1953#: extras_topology.xml:1086 1954#, no-c-format 1955msgid "" 1956"Add a new edge and, if doing so splits a face, modify the original face and " 1957"add a new one." 1958msgstr "" 1959 1960#. Tag: para 1961#: extras_topology.xml:1091 1962#, no-c-format 1963msgid "" 1964"If possible, the new face will be created on left side of the new edge. This " 1965"will not be possible if the face on the left side will need to be the " 1966"Universe face (unbounded)." 1967msgstr "" 1968 1969#. Tag: para 1970#: extras_topology.xml:1097 1971#, no-c-format 1972msgid "Returns the id of the newly added edge." 1973msgstr "" 1974 1975#. Tag: para 1976#: extras_topology.xml:1111 1977#, no-c-format 1978msgid "" 1979"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.13" 1980msgstr "" 1981 1982#. Tag: refname 1983#: extras_topology.xml:1131 1984#, no-c-format 1985msgid "ST_RemEdgeNewFace" 1986msgstr "ST_RemEdgeNewFace" 1987 1988#. Tag: refpurpose 1989#: extras_topology.xml:1133 1990#, no-c-format 1991msgid "" 1992"<refpurpose>Removes an edge and, if the removed edge separated two faces, " 1993"delete the original faces and replace them with a new face.</refpurpose>" 1994msgstr "" 1995 1996#. Tag: funcprototype 1997#: extras_topology.xml:1141 1998#, no-c-format 1999msgid "" 2000"<funcdef>integer <function>ST_RemEdgeNewFace</function></funcdef> " 2001"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2002"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef>" 2003msgstr "" 2004"<funcdef>integer <function>ST_RemEdgeNewFace</function></funcdef> " 2005"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2006"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef>" 2007 2008#. Tag: para 2009#: extras_topology.xml:1152 2010#, no-c-format 2011msgid "" 2012"<para>Removes an edge and, if the removed edge separated two faces, delete " 2013"the original faces and replace them with a new face.</para>" 2014msgstr "" 2015 2016#. Tag: para 2017#: extras_topology.xml:1157 2018#, no-c-format 2019msgid "" 2020"Returns the id of a newly created face or NULL, if no new face is created. " 2021"No new face is created when the removed edge is dangling or isolated or " 2022"confined with the universe face (possibly making the universe flood into the " 2023"face on the other side)." 2024msgstr "" 2025 2026#. Tag: para 2027#: extras_topology.xml:1168 2028#, no-c-format 2029msgid "" 2030"Refuses to remove an edge participating in the definition of an existing " 2031"TopoGeometry. Refuses to heal two faces if any TopoGeometry is defined by " 2032"only one of them (and not the other)." 2033msgstr "" 2034 2035#. Tag: para 2036#: extras_topology.xml:1175 extras_topology.xml:1243 2037#, no-c-format 2038msgid "" 2039"If any arguments are null, the given edge is unknown (must already exist in " 2040"the <varname>edge</varname> table of the topology schema), the topology name " 2041"is invalid then an error is thrown." 2042msgstr "" 2043 2044#. Tag: para 2045#: extras_topology.xml:1183 2046#, no-c-format 2047msgid "" 2048"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.14" 2049msgstr "" 2050 2051#. Tag: refname 2052#: extras_topology.xml:1203 2053#, no-c-format 2054msgid "ST_RemEdgeModFace" 2055msgstr "ST_RemEdgeModFace" 2056 2057#. Tag: refpurpose 2058#: extras_topology.xml:1205 2059#, no-c-format 2060msgid "" 2061"Removes an edge and, if the removed edge separated two faces, delete one of " 2062"the them and modify the other to take the space of both." 2063msgstr "" 2064 2065#. Tag: funcprototype 2066#: extras_topology.xml:1213 2067#, no-c-format 2068msgid "" 2069"<funcdef>integer <function>ST_RemEdgeModFace</function></funcdef> " 2070"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2071"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef>" 2072msgstr "" 2073 2074#. Tag: para 2075#: extras_topology.xml:1224 2076#, no-c-format 2077msgid "" 2078"Removes an edge and, if the removed edge separated two faces, delete one of " 2079"the them and modify the other to take the space of both. Preferentially " 2080"keeps the face on the right, to be symmetric with ST_AddEdgeModFace also " 2081"keeping it. Returns the id of the face remaining in place of the removed " 2082"edge." 2083msgstr "" 2084 2085#. Tag: para 2086#: extras_topology.xml:1236 2087#, no-c-format 2088msgid "" 2089"Refuses to remove an edge partecipating in the definition of an existing " 2090"TopoGeometry. Refuses to heal two faces if any TopoGeometry is defined by " 2091"only one of them (and not the other)." 2092msgstr "" 2093 2094#. Tag: para 2095#: extras_topology.xml:1251 2096#, no-c-format 2097msgid "" 2098"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.15" 2099msgstr "" 2100 2101#. Tag: refname 2102#: extras_topology.xml:1271 2103#, no-c-format 2104msgid "ST_ChangeEdgeGeom" 2105msgstr "ST_ChangeEdgeGeom" 2106 2107#. Tag: refpurpose 2108#: extras_topology.xml:1273 2109#, no-c-format 2110msgid "" 2111"<refpurpose>Changes the shape of an edge without affecting the topology " 2112"structure.</refpurpose>" 2113msgstr "" 2114 2115#. Tag: funcprototype 2116#: extras_topology.xml:1280 2117#, no-c-format 2118msgid "" 2119"<funcdef>integer <function>ST_ChangeEdgeGeom</function></funcdef> " 2120"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2121"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2122"<paramdef><type>geometry </type> <parameter>acurve</parameter></paramdef>" 2123msgstr "" 2124"<funcdef>integer <function>ST_ChangeEdgeGeom</function></funcdef> " 2125"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2126"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2127"<paramdef><type>geometry </type> <parameter>acurve</parameter></paramdef>" 2128 2129#. Tag: para 2130#: extras_topology.xml:1292 2131#, no-c-format 2132msgid "" 2133"<para>Changes the shape of an edge without affecting the topology structure." 2134"</para>" 2135msgstr "" 2136 2137#. Tag: para 2138#: extras_topology.xml:1295 2139#, no-c-format 2140msgid "" 2141"If any arguments are null, the given edge does not exist in the " 2142"<varname>edge</varname> table of the topology schema, the <varname>acurve</" 2143"varname> is not a <varname>LINESTRING</varname>, the <varname>anode</" 2144"varname> and <varname>anothernode</varname> are not the start and endpoints " 2145"of <varname>acurve</varname> or the modification would change the underlying " 2146"topology then an error is thrown." 2147msgstr "" 2148 2149#. Tag: para 2150#: extras_topology.xml:1304 2151#, no-c-format 2152msgid "" 2153"If the new <varname>acurve</varname> is not simple, then an error is thrown." 2154msgstr "" 2155 2156#. Tag: para 2157#: extras_topology.xml:1306 2158#, no-c-format 2159msgid "" 2160"If moving the edge from old to new position would hit an obstacle then an " 2161"error is thrown." 2162msgstr "" 2163 2164#. Tag: para 2165#: extras_topology.xml:1312 extras_topology.xml:3074 extras_topology.xml:3127 2166#, no-c-format 2167msgid "Availability: 1.1.0" 2168msgstr "Disponibilità: 1.1.0" 2169 2170#. Tag: para 2171#: extras_topology.xml:1315 2172#, no-c-format 2173msgid "Enhanced: 2.0.0 adds topological consistency enforcement" 2174msgstr "" 2175 2176#. Tag: para 2177#: extras_topology.xml:1319 2178#, no-c-format 2179msgid "" 2180"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details X.3.6" 2181msgstr "" 2182 2183#. Tag: programlisting 2184#: extras_topology.xml:1325 2185#, no-c-format 2186msgid "" 2187"SELECT topology.ST_ChangeEdgeGeom('ma_topo', 1,\n" 2188" ST_GeomFromText('LINESTRING(227591.9 893900.4,227622.6 " 2189"893844.3,227641.6 893816.6, 227704.5 893778.5)', 26986) );\n" 2190" ----\n" 2191" Edge 1 changed" 2192msgstr "" 2193 2194#. Tag: refname 2195#: extras_topology.xml:1339 2196#, no-c-format 2197msgid "ST_ModEdgeSplit" 2198msgstr "ST_ModEdgeSplit" 2199 2200#. Tag: refpurpose 2201#: extras_topology.xml:1341 2202#, no-c-format 2203msgid "" 2204"Split an edge by creating a new node along an existing edge, modifying the " 2205"original edge and adding a new edge." 2206msgstr "" 2207 2208#. Tag: funcprototype 2209#: extras_topology.xml:1346 2210#, no-c-format 2211msgid "" 2212"<funcdef>integer <function>ST_ModEdgeSplit</function></funcdef> " 2213"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2214"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2215"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 2216msgstr "" 2217 2218#. Tag: para 2219#: extras_topology.xml:1358 2220#, no-c-format 2221msgid "" 2222"Split an edge by creating a new node along an existing edge, modifying the " 2223"original edge and adding a new edge. Updates all existing joined edges and " 2224"relationships accordingly. Returns the identifier of the newly added node." 2225msgstr "" 2226 2227#. Tag: para 2228#: extras_topology.xml:1367 2229#, no-c-format 2230msgid "Changed: 2.0 - In prior versions, this was misnamed ST_ModEdgesSplit" 2231msgstr "" 2232 2233#. Tag: para 2234#: extras_topology.xml:1368 extras_topology.xml:1422 extras_topology.xml:1472 2235#, no-c-format 2236msgid "" 2237"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.9" 2238msgstr "" 2239 2240#. Tag: programlisting 2241#: extras_topology.xml:1374 2242#, no-c-format 2243msgid "" 2244"-- Add an edge --\n" 2245" SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227592 " 2246"893910, 227600 893910)', 26986) ) As edgeid;\n" 2247"\n" 2248"-- edgeid-\n" 2249"3\n" 2250"\n" 2251"\n" 2252"-- Split the edge --\n" 2253"SELECT topology.ST_ModEdgeSplit('ma_topo', 3, " 2254"ST_SetSRID(ST_Point(227594,893910),26986) ) As node_id;\n" 2255" node_id\n" 2256"-------------------------\n" 2257"7" 2258msgstr "" 2259 2260#. Tag: para 2261#: extras_topology.xml:1380 2262#, no-c-format 2263msgid "" 2264", <xref linkend=\"ST_ModEdgeHeal\"/>, <xref linkend=\"ST_NewEdgeHeal\"/>, " 2265"<xref linkend=\"AddEdge\"/>" 2266msgstr "" 2267", <xref linkend=\"ST_ModEdgeHeal\"/>, <xref linkend=\"ST_NewEdgeHeal\"/>, " 2268"<xref linkend=\"AddEdge\"/>" 2269 2270#. Tag: refname 2271#: extras_topology.xml:1391 2272#, no-c-format 2273msgid "ST_ModEdgeHeal" 2274msgstr "ST_ModEdgeHeal" 2275 2276#. Tag: refpurpose 2277#: extras_topology.xml:1393 2278#, no-c-format 2279msgid "" 2280"Heals two edges by deleting the node connecting them, modifying the first " 2281"edge and deleting the second edge. Returns the id of the deleted node." 2282msgstr "" 2283 2284#. Tag: funcprototype 2285#: extras_topology.xml:1401 2286#, no-c-format 2287msgid "" 2288"<funcdef>int <function>ST_ModEdgeHeal</function></funcdef> " 2289"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2290"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2291"<paramdef><type>integer </type> <parameter>anotheredge</parameter></paramdef>" 2292msgstr "" 2293"<funcdef>int <function>ST_ModEdgeHeal</function></funcdef> " 2294"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2295"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2296"<paramdef><type>integer </type> <parameter>anotheredge</parameter></paramdef>" 2297 2298#. Tag: para 2299#: extras_topology.xml:1413 2300#, no-c-format 2301msgid "" 2302"Heals two edges by deleting the node connecting them, modifying the first " 2303"edge and deleting the second edge. Returns the id of the deleted node. " 2304"Updates all existing joined edges and relationships accordingly." 2305msgstr "" 2306 2307#. Tag: refname 2308#: extras_topology.xml:1438 2309#, no-c-format 2310msgid "ST_NewEdgeHeal" 2311msgstr "ST_NewEdgeHeal" 2312 2313#. Tag: refpurpose 2314#: extras_topology.xml:1440 2315#, no-c-format 2316msgid "" 2317"Heals two edges by deleting the node connecting them, deleting both edges, " 2318"and replacing them with an edge whose direction is the same as the first " 2319"edge provided." 2320msgstr "" 2321 2322#. Tag: funcprototype 2323#: extras_topology.xml:1449 2324#, no-c-format 2325msgid "" 2326"<funcdef>int <function>ST_NewEdgeHeal</function></funcdef> " 2327"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2328"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2329"<paramdef><type>integer </type> <parameter>anotheredge</parameter></paramdef>" 2330msgstr "" 2331"<funcdef>int <function>ST_NewEdgeHeal</function></funcdef> " 2332"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2333"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2334"<paramdef><type>integer </type> <parameter>anotheredge</parameter></paramdef>" 2335 2336#. Tag: para 2337#: extras_topology.xml:1461 2338#, no-c-format 2339msgid "" 2340"Heals two edges by deleting the node connecting them, deleting both edges, " 2341"and replacing them with an edge whose direction is the same as the first " 2342"edge provided. Returns the id of the new edge replacing the healed ones. " 2343"Updates all existing joined edges and relationships accordingly." 2344msgstr "" 2345 2346#. Tag: refname 2347#: extras_topology.xml:1489 2348#, no-c-format 2349msgid "ST_MoveIsoNode" 2350msgstr "ST_MoveIsoNode" 2351 2352#. Tag: refpurpose 2353#: extras_topology.xml:1491 2354#, no-c-format 2355msgid "" 2356"Moves an isolated node in a topology from one point to another. If new " 2357"<varname>apoint</varname> geometry exists as a node an error is thrown. " 2358"Returns description of move." 2359msgstr "" 2360 2361#. Tag: funcprototype 2362#: extras_topology.xml:1496 2363#, no-c-format 2364msgid "" 2365"<funcdef>text <function>ST_MoveIsoNode</function></funcdef> " 2366"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2367"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2368"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 2369msgstr "" 2370"<funcdef>text <function>ST_MoveIsoNode</function></funcdef> " 2371"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2372"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2373"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 2374 2375#. Tag: para 2376#: extras_topology.xml:1508 2377#, no-c-format 2378msgid "" 2379"Moves an isolated node in a topology from one point to another. If new " 2380"<varname>apoint</varname> geometry exists as a node an error is thrown." 2381msgstr "" 2382 2383#. Tag: para 2384#: extras_topology.xml:1509 2385#, no-c-format 2386msgid "" 2387"If any arguments are null, the <varname>apoint</varname> is not a point, the " 2388"existing node is not isolated (is a start or end point of an existing edge), " 2389"new node location intersects an existing edge (even at the end points) then " 2390"an exception is thrown." 2391msgstr "" 2392 2393#. Tag: para 2394#: extras_topology.xml:1510 2395#, no-c-format 2396msgid "" 2397"If the spatial reference system (srid) of the point geometry is not the same " 2398"as the topology an exception is thrown." 2399msgstr "" 2400 2401#. Tag: para 2402#: extras_topology.xml:1515 2403#, no-c-format 2404msgid "&sqlmm_compliant; SQL-MM: Topo-Net Routines: X.3.2" 2405msgstr "" 2406 2407#. Tag: programlisting 2408#: extras_topology.xml:1521 2409#, no-c-format 2410msgid "" 2411"-- Add an isolated node with no face --\n" 2412"SELECT topology.ST_AddIsoNode('ma_topo', NULL, " 2413"ST_GeomFromText('POINT(227579 893916)', 26986) ) As nodeid;\n" 2414" nodeid\n" 2415"--------\n" 2416" 7\n" 2417"-- Move the new node --\n" 2418"SELECT topology.ST_MoveIsoNode('ma_topo', 7, " 2419"ST_GeomFromText('POINT(227579.5 893916.5)', 26986) ) As descrip;\n" 2420" descrip\n" 2421"----------------------------------------------------\n" 2422"Isolated Node 7 moved to location 227579.5,893916.5" 2423msgstr "" 2424 2425#. Tag: refname 2426#: extras_topology.xml:1532 2427#, no-c-format 2428msgid "ST_NewEdgesSplit" 2429msgstr "ST_NewEdgesSplit" 2430 2431#. Tag: refpurpose 2432#: extras_topology.xml:1534 2433#, no-c-format 2434msgid "" 2435"Split an edge by creating a new node along an existing edge, deleting the " 2436"original edge and replacing it with two new edges. Returns the id of the new " 2437"node created that joins the new edges." 2438msgstr "" 2439 2440#. Tag: funcprototype 2441#: extras_topology.xml:1539 2442#, no-c-format 2443msgid "" 2444"<funcdef>integer <function>ST_NewEdgesSplit</function></funcdef> " 2445"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2446"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2447"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 2448msgstr "" 2449"<funcdef>integer <function>ST_NewEdgesSplit</function></funcdef> " 2450"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2451"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2452"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 2453 2454#. Tag: para 2455#: extras_topology.xml:1551 2456#, no-c-format 2457msgid "" 2458"Split an edge with edge id <varname>anedge</varname> by creating a new node " 2459"with point location <varname>apoint</varname> along current edge, deleting " 2460"the original edge and replacing it with two new edges. Returns the id of the " 2461"new node created that joins the new edges. Updates all existing joined edges " 2462"and relationships accordingly." 2463msgstr "" 2464 2465#. Tag: para 2466#: extras_topology.xml:1559 2467#, no-c-format 2468msgid "" 2469"If the spatial reference system (srid) of the point geometry is not the same " 2470"as the topology, the <varname>apoint</varname> is not a point geometry, the " 2471"point is null, the point already exists as a node, the edge does not " 2472"correspond to an existing edge or the point is not within the edge then an " 2473"exception is thrown." 2474msgstr "" 2475 2476#. Tag: para 2477#: extras_topology.xml:1564 2478#, no-c-format 2479msgid "&sqlmm_compliant; SQL-MM: Topo-Net Routines: X.3.8" 2480msgstr "" 2481 2482#. Tag: programlisting 2483#: extras_topology.xml:1570 2484#, no-c-format 2485msgid "" 2486"-- Add an edge --\n" 2487"SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227575 " 2488"893917,227592 893900)', 26986) ) As edgeid;\n" 2489"-- result-\n" 2490"edgeid\n" 2491"------\n" 2492" 2\n" 2493"-- Split the new edge --\n" 2494"SELECT topology.ST_NewEdgesSplit('ma_topo', 2, " 2495"ST_GeomFromText('POINT(227578.5 893913.5)', 26986) ) As newnodeid;\n" 2496" newnodeid\n" 2497"---------\n" 2498" 6" 2499msgstr "" 2500 2501#. Tag: refname 2502#: extras_topology.xml:1587 2503#, no-c-format 2504msgid "ST_RemoveIsoNode" 2505msgstr "ST_RemoveIsoNode" 2506 2507#. Tag: refpurpose 2508#: extras_topology.xml:1589 2509#, no-c-format 2510msgid "" 2511"<refpurpose>Removes an isolated node and returns description of action. If " 2512"the node is not isolated (is start or end of an edge), then an exception is " 2513"thrown.</refpurpose>" 2514msgstr "" 2515 2516#. Tag: funcprototype 2517#: extras_topology.xml:1594 2518#, no-c-format 2519msgid "" 2520"<funcdef>text <function>ST_RemoveIsoNode</function></funcdef> " 2521"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2522"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef>" 2523msgstr "" 2524"<funcdef>text <function>ST_RemoveIsoNode</function></funcdef> " 2525"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2526"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef>" 2527 2528#. Tag: para 2529#: extras_topology.xml:1605 2530#, no-c-format 2531msgid "" 2532"<para>Removes an isolated node and returns description of action. If the " 2533"node is not isolated (is start or end of an edge), then an exception is " 2534"thrown.</para>" 2535msgstr "" 2536 2537#. Tag: para 2538#: extras_topology.xml:1610 extras_topology.xml:1651 2539#, no-c-format 2540msgid "" 2541"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X+1.3.3" 2542msgstr "" 2543 2544#. Tag: programlisting 2545#: extras_topology.xml:1616 extras_topology.xml:1657 2546#, no-c-format 2547msgid "" 2548"-- Remove an isolated node with no face --\n" 2549"SELECT topology.ST_RemoveIsoNode('ma_topo', 7 ) As result;\n" 2550" result\n" 2551"-------------------------\n" 2552" Isolated node 7 removed" 2553msgstr "" 2554 2555#. Tag: refname 2556#: extras_topology.xml:1628 2557#, no-c-format 2558msgid "ST_RemoveIsoEdge" 2559msgstr "" 2560 2561#. Tag: refpurpose 2562#: extras_topology.xml:1630 2563#, no-c-format 2564msgid "" 2565"<refpurpose>Removes an isolated edge and returns description of action. If " 2566"the edge is not isolated, then an exception is thrown.</refpurpose>" 2567msgstr "" 2568 2569#. Tag: funcprototype 2570#: extras_topology.xml:1635 2571#, no-c-format 2572msgid "" 2573"<funcdef>text <function>ST_RemoveIsoEdge</function></funcdef> " 2574"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2575"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef>" 2576msgstr "" 2577 2578#. Tag: para 2579#: extras_topology.xml:1646 2580#, no-c-format 2581msgid "" 2582"<para>Removes an isolated edge and returns description of action. If the " 2583"edge is not isolated, then an exception is thrown.</para>" 2584msgstr "" 2585 2586#. Tag: title 2587#: extras_topology.xml:1670 2588#, no-c-format 2589msgid "Topology Accessors" 2590msgstr "" 2591 2592#. Tag: refname 2593#: extras_topology.xml:1673 2594#, no-c-format 2595msgid "GetEdgeByPoint" 2596msgstr "GetEdgeByPoint" 2597 2598#. Tag: refpurpose 2599#: extras_topology.xml:1675 2600#, no-c-format 2601msgid "Finds the edge-id of an edge that intersects a given point." 2602msgstr "" 2603 2604#. Tag: funcprototype 2605#: extras_topology.xml:1680 2606#, fuzzy, no-c-format 2607msgid "" 2608"<funcdef>integer <function>GetEdgeByPoint</function></funcdef> " 2609"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2610"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 2611"<paramdef><type>float8 </type> <parameter>tol1</parameter></paramdef>" 2612msgstr "" 2613"<funcdef>integer <function>GetEdgeByPoint</function></funcdef> " 2614"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2615"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 2616"<paramdef><type>float8 </type> <parameter>tol</parameter></paramdef>" 2617 2618#. Tag: para 2619#: extras_topology.xml:1693 2620#, no-c-format 2621msgid "Retrieves the id of an edge that intersects a Point." 2622msgstr "" 2623 2624#. Tag: para 2625#: extras_topology.xml:1694 2626#, no-c-format 2627msgid "" 2628"The function returns an integer (id-edge) given a topology, a POINT and a " 2629"tolerance. If tolerance = 0 then the point has to intersect the edge." 2630msgstr "" 2631 2632#. Tag: para 2633#: extras_topology.xml:1695 2634#, no-c-format 2635msgid "" 2636"If <varname>apoint</varname> doesn't intersect an edge, returns 0 (zero)." 2637msgstr "" 2638 2639#. Tag: para 2640#: extras_topology.xml:1696 2641#, no-c-format 2642msgid "" 2643"If use tolerance > 0 and there is more than one edge near the point then an " 2644"exception is thrown." 2645msgstr "" 2646 2647#. Tag: para 2648#: extras_topology.xml:1700 extras_topology.xml:1749 extras_topology.xml:1798 2649#, no-c-format 2650msgid "" 2651"If tolerance = 0, the function uses ST_Intersects otherwise uses ST_DWithin." 2652msgstr "" 2653 2654#. Tag: para 2655#: extras_topology.xml:1702 extras_topology.xml:1751 extras_topology.xml:1800 2656#: extras_topology.xml:2286 extras_topology.xml:2404 2657#, no-c-format 2658msgid "Performed by the GEOS module." 2659msgstr "Eseguito dal modulo GEOS" 2660 2661#. Tag: para 2662#: extras_topology.xml:1709 extras_topology.xml:1807 2663#, no-c-format 2664msgid "These examples use edges we created in <xref linkend=\"AddEdge\"/>" 2665msgstr "" 2666 2667#. Tag: programlisting 2668#: extras_topology.xml:1710 2669#, no-c-format 2670msgid "" 2671"SELECT topology.GetEdgeByPoint('ma_topo',geom, 1) As with1mtol, topology." 2672"GetEdgeByPoint('ma_topo',geom,0) As withnotol\n" 2673"FROM ST_GeomFromEWKT('SRID=26986;POINT(227622.6 893843)') As geom;\n" 2674" with1mtol | withnotol\n" 2675"-----------+-----------\n" 2676" 2 | 0" 2677msgstr "" 2678"SELECT topology.GetEdgeByPoint('ma_topo',geom, 1) As with1mtol, topology." 2679"GetEdgeByPoint('ma_topo',geom,0) As withnotol\n" 2680"FROM ST_GeomFromEWKT('SRID=26986;POINT(227622.6 893843)') As geom;\n" 2681" with1mtol | withnotol\n" 2682"-----------+-----------\n" 2683" 2 | 0" 2684 2685#. Tag: programlisting 2686#: extras_topology.xml:1711 2687#, no-c-format 2688msgid "" 2689"SELECT topology.GetEdgeByPoint('ma_topo',geom, 1) As nearnode\n" 2690"FROM ST_GeomFromEWKT('SRID=26986;POINT(227591.9 893900.4)') As geom;\n" 2691"\n" 2692"-- get error --\n" 2693"ERROR: Two or more edges found" 2694msgstr "" 2695"SELECT topology.GetEdgeByPoint('ma_topo',geom, 1) As nearnode\n" 2696"FROM ST_GeomFromEWKT('SRID=26986;POINT(227591.9 893900.4)') As geom;\n" 2697"\n" 2698"-- get error --\n" 2699"ERROR: Two or more edges found" 2700 2701#. Tag: para 2702#: extras_topology.xml:1718 2703#, no-c-format 2704msgid "" 2705", <xref linkend=\"GetNodeByPoint\"/>, <xref linkend=\"GetFaceByPoint\"/>" 2706msgstr "" 2707 2708#. Tag: refname 2709#: extras_topology.xml:1728 2710#, no-c-format 2711msgid "GetFaceByPoint" 2712msgstr "GetFaceByPoint" 2713 2714#. Tag: refpurpose 2715#: extras_topology.xml:1729 2716#, no-c-format 2717msgid "Finds the face-id of a face that intersects a given point." 2718msgstr "" 2719 2720#. Tag: funcprototype 2721#: extras_topology.xml:1733 2722#, fuzzy, no-c-format 2723msgid "" 2724"<funcdef>integer <function>GetFaceByPoint</function></funcdef> " 2725"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2726"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 2727"<paramdef><type>float8 </type> <parameter>tol1</parameter></paramdef>" 2728msgstr "" 2729"<funcdef>integer <function>GetFaceByPoint</function></funcdef> " 2730"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2731"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 2732"<paramdef><type>float8 </type> <parameter>tol</parameter></paramdef>" 2733 2734#. Tag: para 2735#: extras_topology.xml:1744 2736#, no-c-format 2737msgid "Retrieves the id of a face that intersects a Point." 2738msgstr "" 2739 2740#. Tag: para 2741#: extras_topology.xml:1745 2742#, no-c-format 2743msgid "" 2744"The function returns an integer (id-face) given a topology, a POINT and a " 2745"tolerance. If tolerance = 0 then the point has to intersect the face." 2746msgstr "" 2747 2748#. Tag: para 2749#: extras_topology.xml:1746 2750#, no-c-format 2751msgid "" 2752"If <varname>apoint</varname> doesn't intersect a face, returns 0 (zero)." 2753msgstr "" 2754 2755#. Tag: para 2756#: extras_topology.xml:1747 2757#, no-c-format 2758msgid "" 2759"If use tolerance > 0 and there is more than one face near the point then an " 2760"exception is thrown." 2761msgstr "" 2762 2763#. Tag: para 2764#: extras_topology.xml:1756 2765#, no-c-format 2766msgid "These examples use edges faces created in <xref linkend=\"AddFace\"/>" 2767msgstr "" 2768 2769#. Tag: programlisting 2770#: extras_topology.xml:1757 2771#, no-c-format 2772msgid "" 2773"SELECT topology.GetFaceByPoint('ma_topo',geom, 10) As with1mtol, topology." 2774"GetFaceByPoint('ma_topo',geom,0) As withnotol\n" 2775" FROM ST_GeomFromEWKT('POINT(234604.6 899382.0)') As geom;\n" 2776"\n" 2777" with1mtol | withnotol\n" 2778" -----------+-----------\n" 2779" 1 | 0" 2780msgstr "" 2781 2782#. Tag: programlisting 2783#: extras_topology.xml:1758 2784#, no-c-format 2785msgid "" 2786"SELECT topology.GetFaceByPoint('ma_topo',geom, 1) As nearnode\n" 2787" FROM ST_GeomFromEWKT('POINT(227591.9 893900.4)') As geom;\n" 2788"\n" 2789"-- get error --\n" 2790"ERROR: Two or more faces found" 2791msgstr "" 2792 2793#. Tag: para 2794#: extras_topology.xml:1763 2795#, no-c-format 2796msgid "" 2797", <xref linkend=\"GetNodeByPoint\"/>, <xref linkend=\"GetEdgeByPoint\"/>" 2798msgstr "" 2799", <xref linkend=\"GetNodeByPoint\"/>, <xref linkend=\"GetEdgeByPoint\"/>" 2800 2801#. Tag: refname 2802#: extras_topology.xml:1773 2803#, no-c-format 2804msgid "GetNodeByPoint" 2805msgstr "GetNodeByPoint" 2806 2807#. Tag: refpurpose 2808#: extras_topology.xml:1775 2809#, no-c-format 2810msgid "Finds the node-id of a node at a point location." 2811msgstr "" 2812 2813#. Tag: funcprototype 2814#: extras_topology.xml:1780 2815#, fuzzy, no-c-format 2816msgid "" 2817"<funcdef>integer <function>GetNodeByPoint</function></funcdef> " 2818"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2819"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 2820"<paramdef><type>float8 </type> <parameter>tol1</parameter></paramdef>" 2821msgstr "" 2822"<funcdef>integer <function>GetNodeByPoint</function></funcdef> " 2823"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2824"<paramdef><type>geometry </type> <parameter>point</parameter></paramdef> " 2825"<paramdef><type>float8 </type> <parameter>tol</parameter></paramdef>" 2826 2827#. Tag: para 2828#: extras_topology.xml:1793 2829#, no-c-format 2830msgid "Retrieves the id of a node at a point location." 2831msgstr "" 2832 2833#. Tag: para 2834#: extras_topology.xml:1794 2835#, no-c-format 2836msgid "" 2837"The function returns an integer (id-node) given a topology, a POINT and a " 2838"tolerance. If tolerance = 0 means exact intersection, otherwise retrieves " 2839"the node from an interval." 2840msgstr "" 2841 2842#. Tag: para 2843#: extras_topology.xml:1795 2844#, no-c-format 2845msgid "" 2846"If <varname>apoint</varname> doesn't intersect a node, returns 0 (zero)." 2847msgstr "" 2848 2849#. Tag: para 2850#: extras_topology.xml:1796 2851#, no-c-format 2852msgid "" 2853"If use tolerance > 0 and there is more than one node near the point then an " 2854"exception is thrown." 2855msgstr "" 2856 2857#. Tag: programlisting 2858#: extras_topology.xml:1808 2859#, no-c-format 2860msgid "" 2861"SELECT topology.GetNodeByPoint('ma_topo',geom, 1) As nearnode\n" 2862" FROM ST_GeomFromEWKT('SRID=26986;POINT(227591.9 893900.4)') As geom;\n" 2863" nearnode\n" 2864"----------\n" 2865" 2" 2866msgstr "" 2867 2868#. Tag: programlisting 2869#: extras_topology.xml:1809 2870#, no-c-format 2871msgid "" 2872"SELECT topology.GetNodeByPoint('ma_topo',geom, 1000) As too_much_tolerance\n" 2873" FROM ST_GeomFromEWKT('SRID=26986;POINT(227591.9 893900.4)') As geom;\n" 2874"\n" 2875" ----get error--\n" 2876" ERROR: Two or more nodes found" 2877msgstr "" 2878 2879#. Tag: para 2880#: extras_topology.xml:1816 2881#, no-c-format 2882msgid "" 2883", <xref linkend=\"GetEdgeByPoint\"/>, <xref linkend=\"GetFaceByPoint\"/>" 2884msgstr "" 2885 2886#. Tag: refname 2887#: extras_topology.xml:1826 2888#, no-c-format 2889msgid "GetTopologyID" 2890msgstr "GetTopologyID" 2891 2892#. Tag: refpurpose 2893#: extras_topology.xml:1828 2894#, no-c-format 2895msgid "" 2896"<refpurpose>Returns the id of a topology in the topology.topology table " 2897"given the name of the topology.</refpurpose>" 2898msgstr "" 2899 2900#. Tag: funcprototype 2901#: extras_topology.xml:1833 extras_topology.xml:1875 2902#, no-c-format 2903msgid "" 2904"<funcdef>integer <function>GetTopologyID</function></funcdef> " 2905"<paramdef><type>varchar</type> <parameter>toponame</parameter></paramdef>" 2906msgstr "" 2907"<funcdef>integer <function>GetTopologyID</function></funcdef> " 2908"<paramdef><type>varchar</type> <parameter>toponame</parameter></paramdef>" 2909 2910#. Tag: para 2911#: extras_topology.xml:1843 2912#, no-c-format 2913msgid "" 2914"<para>Returns the id of a topology in the topology.topology table given the " 2915"name of the topology.</para>" 2916msgstr "" 2917 2918#. Tag: programlisting 2919#: extras_topology.xml:1851 2920#, no-c-format 2921msgid "" 2922"SELECT topology.GetTopologyID('ma_topo') As topo_id;\n" 2923" topo_id\n" 2924"---------\n" 2925" 1" 2926msgstr "" 2927"SELECT topology.GetTopologyID('ma_topo') As topo_id;\n" 2928" topo_id\n" 2929"---------\n" 2930" 1" 2931 2932#. Tag: para 2933#: extras_topology.xml:1857 2934#, no-c-format 2935msgid "" 2936", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyName\"/>, " 2937"<xref linkend=\"GetTopologySRID\"/>" 2938msgstr "" 2939 2940#. Tag: refname 2941#: extras_topology.xml:1868 2942#, no-c-format 2943msgid "GetTopologySRID" 2944msgstr "GetTopologySRID" 2945 2946#. Tag: refpurpose 2947#: extras_topology.xml:1870 2948#, no-c-format 2949msgid "" 2950"Returns the SRID of a topology in the topology.topology table given the name " 2951"of the topology." 2952msgstr "" 2953 2954#. Tag: para 2955#: extras_topology.xml:1885 2956#, no-c-format 2957msgid "" 2958"Returns the spatial reference id of a topology in the topology.topology " 2959"table given the name of the topology." 2960msgstr "" 2961 2962#. Tag: programlisting 2963#: extras_topology.xml:1893 2964#, no-c-format 2965msgid "" 2966"SELECT topology.GetTopologySRID('ma_topo') As SRID;\n" 2967" SRID\n" 2968"-------\n" 2969" 4326" 2970msgstr "" 2971"SELECT topology.GetTopologySRID('ma_topo') As SRID;\n" 2972" SRID\n" 2973"-------\n" 2974" 4326" 2975 2976#. Tag: para 2977#: extras_topology.xml:1899 2978#, no-c-format 2979msgid "" 2980", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyName\"/>, " 2981"<xref linkend=\"GetTopologyID\"/>" 2982msgstr "" 2983", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyName\"/>, " 2984"<xref linkend=\"GetTopologyID\"/>" 2985 2986#. Tag: refname 2987#: extras_topology.xml:1910 2988#, no-c-format 2989msgid "GetTopologyName" 2990msgstr "GetTopologyName" 2991 2992#. Tag: refpurpose 2993#: extras_topology.xml:1912 2994#, no-c-format 2995msgid "Returns the name of a topology (schema) given the id of the topology." 2996msgstr "" 2997 2998#. Tag: funcprototype 2999#: extras_topology.xml:1917 3000#, no-c-format 3001msgid "" 3002"<funcdef>varchar <function>GetTopologyName</function></funcdef> " 3003"<paramdef><type>integer</type> <parameter>topology_id</parameter></paramdef>" 3004msgstr "" 3005"<funcdef>varchar <function>GetTopologyName</function></funcdef> " 3006"<paramdef><type>integer</type> <parameter>topology_id</parameter></paramdef>" 3007 3008#. Tag: para 3009#: extras_topology.xml:1927 3010#, no-c-format 3011msgid "" 3012"Returns the topology name (schema) of a topology from the topology.topology " 3013"table given the topology id of the topology." 3014msgstr "" 3015 3016#. Tag: programlisting 3017#: extras_topology.xml:1935 3018#, no-c-format 3019msgid "" 3020"SELECT topology.GetTopologyName(1) As topo_name;\n" 3021" topo_name\n" 3022"-----------\n" 3023" ma_topo" 3024msgstr "" 3025"SELECT topology.GetTopologyName(1) As topo_name;\n" 3026" topo_name\n" 3027"-----------\n" 3028" ma_topo" 3029 3030#. Tag: para 3031#: extras_topology.xml:1941 3032#, no-c-format 3033msgid "" 3034", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyID\"/>, <xref " 3035"linkend=\"GetTopologySRID\"/>" 3036msgstr "" 3037", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyID\"/>, <xref " 3038"linkend=\"GetTopologySRID\"/>" 3039 3040#. Tag: refname 3041#: extras_topology.xml:1952 3042#, no-c-format 3043msgid "ST_GetFaceEdges" 3044msgstr "ST_GetFaceEdges" 3045 3046#. Tag: refpurpose 3047#: extras_topology.xml:1954 3048#, no-c-format 3049msgid "Returns a set of ordered edges that bound <varname>aface</varname>." 3050msgstr "" 3051 3052#. Tag: funcprototype 3053#: extras_topology.xml:1959 3054#, no-c-format 3055msgid "" 3056"<funcdef>getfaceedges_returntype <function>ST_GetFaceEdges</function></" 3057"funcdef> <paramdef><type>varchar </type> <parameter>atopology</parameter></" 3058"paramdef> <paramdef><type>integer </type> <parameter>aface</parameter></" 3059"paramdef>" 3060msgstr "" 3061"<funcdef>getfaceedges_returntype <function>ST_GetFaceEdges</function></" 3062"funcdef> <paramdef><type>varchar </type> <parameter>atopology</parameter></" 3063"paramdef> <paramdef><type>integer </type> <parameter>aface</parameter></" 3064"paramdef>" 3065 3066#. Tag: para 3067#: extras_topology.xml:1970 3068#, no-c-format 3069msgid "" 3070"Returns a set of ordered edges that bound <varname>aface</varname>. Each " 3071"output consists of a sequence and edgeid. Sequence numbers start with value " 3072"1." 3073msgstr "" 3074 3075#. Tag: para 3076#: extras_topology.xml:1972 3077#, no-c-format 3078msgid "" 3079"Enumeration of each ring edges start from the edge with smallest identifier. " 3080"Order of edges follows a left-hand-rule (bound face is on the left of each " 3081"directed edge)." 3082msgstr "" 3083 3084#. Tag: para 3085#: extras_topology.xml:1979 3086#, no-c-format 3087msgid "" 3088"&sqlmm_compliant; SQL-MM 3 Topo-Geo and Topo-Net 3: Routine Details: X.3.5" 3089msgstr "" 3090 3091#. Tag: programlisting 3092#: extras_topology.xml:1985 3093#, no-c-format 3094msgid "" 3095"-- Returns the edges bounding face 1\n" 3096"SELECT (topology.ST_GetFaceEdges('tt', 1)).*;\n" 3097"-- result --\n" 3098" sequence | edge\n" 3099"----------+------\n" 3100" 1 | -4\n" 3101" 2 | 5\n" 3102" 3 | 7\n" 3103" 4 | -6\n" 3104" 5 | 1\n" 3105" 6 | 2\n" 3106" 7 | 3\n" 3107"(7 rows)" 3108msgstr "" 3109 3110#. Tag: programlisting 3111#: extras_topology.xml:1986 3112#, no-c-format 3113msgid "" 3114"-- Returns the sequence, edge id\n" 3115"-- and geometry of the edges that bound face 1\n" 3116"-- If you just need geom and seq, can use ST_GetFaceGeometry\n" 3117"SELECT t.seq, t.edge, geom\n" 3118"FROM topology.ST_GetFaceEdges('tt',1) As t(seq,edge)\n" 3119" INNER JOIN tt.edge AS e ON abs(t.edge) = e.edge_id;" 3120msgstr "" 3121 3122#. Tag: para 3123#: extras_topology.xml:1992 3124#, no-c-format 3125msgid ", <xref linkend=\"AddFace\"/>, <xref linkend=\"ST_GetFaceGeometry\"/>" 3126msgstr ", <xref linkend=\"AddFace\"/>, <xref linkend=\"ST_GetFaceGeometry\"/>" 3127 3128#. Tag: refname 3129#: extras_topology.xml:2002 3130#, no-c-format 3131msgid "ST_GetFaceGeometry" 3132msgstr "ST_GetFaceGeometry" 3133 3134#. Tag: refpurpose 3135#: extras_topology.xml:2004 3136#, no-c-format 3137msgid "Returns the polygon in the given topology with the specified face id." 3138msgstr "" 3139 3140#. Tag: funcprototype 3141#: extras_topology.xml:2009 3142#, no-c-format 3143msgid "" 3144"<funcdef>geometry <function>ST_GetFaceGeometry</function></funcdef> " 3145"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3146"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef>" 3147msgstr "" 3148"<funcdef>geometry <function>ST_GetFaceGeometry</function></funcdef> " 3149"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3150"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef>" 3151 3152#. Tag: para 3153#: extras_topology.xml:2020 3154#, no-c-format 3155msgid "" 3156"Returns the polygon in the given topology with the specified face id. Builds " 3157"the polygon from the edges making up the face." 3158msgstr "" 3159 3160#. Tag: para 3161#: extras_topology.xml:2025 3162#, no-c-format 3163msgid "" 3164"&sqlmm_compliant; SQL-MM 3 Topo-Geo and Topo-Net 3: Routine Details: X.3.16" 3165msgstr "" 3166 3167#. Tag: programlisting 3168#: extras_topology.xml:2031 3169#, no-c-format 3170msgid "" 3171"-- Returns the wkt of the polygon added with AddFace\n" 3172"SELECT ST_AsText(topology.ST_GetFaceGeometry('ma_topo', 1)) As facegeomwkt;\n" 3173"-- result --\n" 3174" facegeomwkt\n" 3175"\n" 3176"--------------------------------------------------------------------------------\n" 3177" POLYGON((234776.9 899563.7,234896.5 899456.7,234914 899436.4,234946.6 " 3178"899356.9,\n" 3179"234872.5 899328.7,234891 899285.4,234992.5 899145,234890.6 899069,\n" 3180"234755.2 899255.4,234612.7 899379.4,234776.9 899563.7))" 3181msgstr "" 3182 3183#. Tag: refname 3184#: extras_topology.xml:2043 3185#, no-c-format 3186msgid "GetRingEdges" 3187msgstr "GetRingEdges" 3188 3189#. Tag: refpurpose 3190#: extras_topology.xml:2045 3191#, no-c-format 3192msgid "" 3193"Returns the ordered set of signed edge identifiers met by walking on an a " 3194"given edge side." 3195msgstr "" 3196 3197#. Tag: funcprototype 3198#: extras_topology.xml:2053 3199#, no-c-format 3200msgid "" 3201"<funcdef>getfaceedges_returntype <function>GetRingEdges</function></funcdef> " 3202"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3203"<paramdef><type>integer </type> <parameter>aring</parameter></paramdef> " 3204"<paramdef choice=\"opt\"><type>integer </type> <parameter>max_edges=null</" 3205"parameter></paramdef>" 3206msgstr "" 3207"<funcdef>getfaceedges_returntype <function>GetRingEdges</function></funcdef> " 3208"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3209"<paramdef><type>integer </type> <parameter>aring</parameter></paramdef> " 3210"<paramdef choice=\"opt\"><type>integer </type> <parameter>max_edges=null</" 3211"parameter></paramdef>" 3212 3213#. Tag: para 3214#: extras_topology.xml:2065 3215#, no-c-format 3216msgid "" 3217"Returns the ordered set of signed edge identifiers met by walking on an a " 3218"given edge side. Each output consists of a sequence and a signed edge id. " 3219"Sequence numbers start with value 1." 3220msgstr "" 3221 3222#. Tag: para 3223#: extras_topology.xml:2072 3224#, no-c-format 3225msgid "" 3226"If you pass a positive edge id, the walk starts on the left side of the " 3227"corresponding edge and follows the edge direction. If you pass a negative " 3228"edge id, the walk starts on the right side of it and goes backward." 3229msgstr "" 3230 3231#. Tag: para 3232#: extras_topology.xml:2079 3233#, no-c-format 3234msgid "" 3235"If <varname>max_edges</varname> is not null no more than those records are " 3236"returned by that function. This is meant to be a safety parameter when " 3237"dealing with possibly invalid topologies." 3238msgstr "" 3239 3240#. Tag: para 3241#: extras_topology.xml:2085 3242#, no-c-format 3243msgid "This function uses edge ring linking metadata." 3244msgstr "" 3245 3246#. Tag: para 3247#: extras_topology.xml:2097 3248#, no-c-format 3249msgid ", <xref linkend=\"GetNodeEdges\"/>" 3250msgstr ", <xref linkend=\"GetNodeEdges\"/>" 3251 3252#. Tag: refname 3253#: extras_topology.xml:2106 3254#, no-c-format 3255msgid "GetNodeEdges" 3256msgstr "GetNodeEdges" 3257 3258#. Tag: refpurpose 3259#: extras_topology.xml:2108 3260#, no-c-format 3261msgid "Returns an ordered set of edges incident to the given node." 3262msgstr "" 3263 3264#. Tag: funcprototype 3265#: extras_topology.xml:2115 3266#, no-c-format 3267msgid "" 3268"<funcdef>getfaceedges_returntype <function>GetNodeEdges</function></funcdef> " 3269"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3270"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef>" 3271msgstr "" 3272"<funcdef>getfaceedges_returntype <function>GetNodeEdges</function></funcdef> " 3273"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3274"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef>" 3275 3276#. Tag: para 3277#: extras_topology.xml:2126 3278#, no-c-format 3279msgid "" 3280"Returns an ordered set of edges incident to the given node. Each output " 3281"consists of a sequence and a signed edge id. Sequence numbers start with " 3282"value 1. A positive edge starts at the given node. A negative edge ends into " 3283"the given node. Closed edges will appear twice (with both signs). Order is " 3284"clockwise starting from northbound." 3285msgstr "" 3286 3287#. Tag: para 3288#: extras_topology.xml:2137 3289#, no-c-format 3290msgid "" 3291"This function computes ordering rather than deriving from metadata and is " 3292"thus usable to build edge ring linking." 3293msgstr "" 3294 3295#. Tag: para 3296#: extras_topology.xml:2150 3297#, no-c-format 3298msgid ", <xref linkend=\"ST_Azimuth\"/>" 3299msgstr ", <xref linkend=\"ST_Azimuth\"/>" 3300 3301#. Tag: para 3302#: extras_topology.xml:2163 3303#, no-c-format 3304msgid "" 3305"This section covers the functions for processing topologies in non-standard " 3306"ways." 3307msgstr "" 3308 3309#. Tag: title 3310#: extras_topology.xml:2166 3311#, no-c-format 3312msgid "Topology Processing" 3313msgstr "" 3314 3315#. Tag: refname 3316#: extras_topology.xml:2169 3317#, no-c-format 3318msgid "Polygonize" 3319msgstr "Polygonize" 3320 3321#. Tag: refpurpose 3322#: extras_topology.xml:2170 3323#, no-c-format 3324msgid "Finds and registers all faces defined by topology edges." 3325msgstr "" 3326 3327#. Tag: funcprototype 3328#: extras_topology.xml:2174 3329#, no-c-format 3330msgid "" 3331"<funcdef>text <function>Polygonize</function></funcdef> " 3332"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef>" 3333msgstr "" 3334"<funcdef>text <function>Polygonize</function></funcdef> " 3335"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef>" 3336 3337#. Tag: para 3338#: extras_topology.xml:2184 3339#, no-c-format 3340msgid "Registers all faces that can be built out a topology edge primitives." 3341msgstr "" 3342 3343#. Tag: para 3344#: extras_topology.xml:2185 3345#, no-c-format 3346msgid "The target topology is assumed to contain no self-intersecting edges." 3347msgstr "" 3348 3349#. Tag: para 3350#: extras_topology.xml:2186 3351#, no-c-format 3352msgid "" 3353"Already known faces are recognized, so it is safe to call Polygonize " 3354"multiple times on the same topology." 3355msgstr "" 3356 3357#. Tag: para 3358#: extras_topology.xml:2187 extras_topology.xml:2339 3359#, no-c-format 3360msgid "" 3361"This function does not use nor set the next_left_edge and next_right_edge " 3362"fields of the edge table." 3363msgstr "" 3364 3365#. Tag: para 3366#: extras_topology.xml:2199 3367#, no-c-format 3368msgid ", <xref linkend=\"ST_Polygonize\"/>" 3369msgstr ", <xref linkend=\"ST_Polygonize\"/>" 3370 3371#. Tag: refname 3372#: extras_topology.xml:2205 3373#, no-c-format 3374msgid "AddNode" 3375msgstr "AddNode" 3376 3377#. Tag: refpurpose 3378#: extras_topology.xml:2207 3379#, no-c-format 3380msgid "" 3381"Adds a point node to the node table in the specified topology schema and " 3382"returns the nodeid of new node. If point already exists as node, the " 3383"existing nodeid is returned." 3384msgstr "" 3385 3386#. Tag: funcprototype 3387#: extras_topology.xml:2212 3388#, no-c-format 3389msgid "" 3390"<funcdef>integer <function>AddNode</function></funcdef> " 3391"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 3392"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 3393"<paramdef choice=\"opt\"><type>boolean </type> " 3394"<parameter>allowEdgeSplitting=false</parameter></paramdef> <paramdef choice=" 3395"\"opt\"><type>boolean </type> <parameter>computeContainingFace=false</" 3396"parameter></paramdef>" 3397msgstr "" 3398"<funcdef>integer <function>AddNode</function></funcdef> " 3399"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 3400"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 3401"<paramdef choice=\"opt\"><type>boolean </type> " 3402"<parameter>allowEdgeSplitting=false</parameter></paramdef> <paramdef choice=" 3403"\"opt\"><type>boolean </type> <parameter>computeContainingFace=false</" 3404"parameter></paramdef>" 3405 3406#. Tag: para 3407#: extras_topology.xml:2225 3408#, no-c-format 3409msgid "" 3410"Adds a point node to the node table in the specified topology schema. The " 3411"<xref linkend=\"AddEdge\"/> function automatically adds start and end points " 3412"of an edge when called so not necessary to explicitly add nodes of an edge." 3413msgstr "" 3414 3415#. Tag: para 3416#: extras_topology.xml:2232 3417#, no-c-format 3418msgid "" 3419"If any edge crossing the node is found either an exception is raised or the " 3420"edge is split, depending on the <varname>allowEdgeSplitting</varname> " 3421"parameter value." 3422msgstr "" 3423 3424#. Tag: para 3425#: extras_topology.xml:2238 3426#, no-c-format 3427msgid "" 3428"If <varname>computeContainingFace</varname> is true a newly added node would " 3429"get the correct containing face computed." 3430msgstr "" 3431 3432#. Tag: para 3433#: extras_topology.xml:2243 3434#, no-c-format 3435msgid "" 3436"If the <varname>apoint</varname> geometry already exists as a node, the node " 3437"is not added but the existing nodeid is returned." 3438msgstr "" 3439 3440#. Tag: programlisting 3441#: extras_topology.xml:2252 3442#, no-c-format 3443msgid "" 3444"SELECT topology.AddNode('ma_topo', ST_GeomFromText('POINT(227641.6 " 3445"893816.5)', 26986) ) As nodeid;\n" 3446"-- result --\n" 3447"nodeid\n" 3448"--------\n" 3449" 4" 3450msgstr "" 3451"SELECT topology.AddNode('ma_topo', ST_GeomFromText('POINT(227641.6 " 3452"893816.5)', 26986) ) As nodeid;\n" 3453"-- result --\n" 3454"nodeid\n" 3455"--------\n" 3456" 4" 3457 3458#. Tag: refname 3459#: extras_topology.xml:2264 3460#, no-c-format 3461msgid "AddEdge" 3462msgstr "AddEdge" 3463 3464#. Tag: refpurpose 3465#: extras_topology.xml:2266 3466#, no-c-format 3467msgid "" 3468"Adds a linestring edge to the edge table and associated start and end points " 3469"to the point nodes table of the specified topology schema using the " 3470"specified linestring geometry and returns the edgeid of the new (or " 3471"existing) edge." 3472msgstr "" 3473 3474#. Tag: funcprototype 3475#: extras_topology.xml:2271 3476#, no-c-format 3477msgid "" 3478"<funcdef>integer <function>AddEdge</function></funcdef> " 3479"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 3480"<paramdef><type>geometry </type> <parameter>aline</parameter></paramdef>" 3481msgstr "" 3482"<funcdef>integer <function>AddEdge</function></funcdef> " 3483"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 3484"<paramdef><type>geometry </type> <parameter>aline</parameter></paramdef>" 3485 3486#. Tag: para 3487#: extras_topology.xml:2282 3488#, no-c-format 3489msgid "" 3490"Adds an edge to the edge table and associated nodes to the nodes table of " 3491"the specified <varname>toponame</varname> schema using the specified " 3492"linestring geometry and returns the edgeid of the new or existing record. " 3493"The newly added edge has \"universe\" face on both sides and links to itself." 3494msgstr "" 3495 3496#. Tag: para 3497#: extras_topology.xml:2284 3498#, no-c-format 3499msgid "" 3500"If the <varname>aline</varname> geometry crosses, overlaps, contains or is " 3501"contained by an existing linestring edge, then an error is thrown and the " 3502"edge is not added." 3503msgstr "" 3504 3505#. Tag: para 3506#: extras_topology.xml:2285 3507#, no-c-format 3508msgid "" 3509"The geometry of <varname>aline</varname> must have the same <varname>srid</" 3510"varname> as defined for the topology otherwise an invalid spatial reference " 3511"sys error will be thrown." 3512msgstr "" 3513 3514#. Tag: programlisting 3515#: extras_topology.xml:2292 3516#, no-c-format 3517msgid "" 3518"SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227575.8 " 3519"893917.2,227591.9 893900.4)', 26986) ) As edgeid;\n" 3520"-- result-\n" 3521"edgeid\n" 3522"--------\n" 3523" 1\n" 3524"\n" 3525"SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227591.9 " 3526"893900.4,227622.6 893844.2,227641.6 893816.5,\n" 3527" 227704.5 893778.5)', 26986) ) As edgeid;\n" 3528"-- result --\n" 3529"edgeid\n" 3530"--------\n" 3531" 2\n" 3532"\n" 3533" SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227591.2 " 3534"893900, 227591.9 893900.4,\n" 3535" 227704.5 893778.5)', 26986) ) As edgeid;\n" 3536" -- gives error --\n" 3537" ERROR: Edge intersects (not on endpoints) with existing edge 1" 3538msgstr "" 3539 3540#. Tag: para 3541#: extras_topology.xml:2298 extras_topology.xml:2375 3542#, no-c-format 3543msgid "" 3544", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"spatial_ref_sys\"/>" 3545msgstr "" 3546", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"spatial_ref_sys\"/>" 3547 3548#. Tag: refname 3549#: extras_topology.xml:2308 3550#, no-c-format 3551msgid "AddFace" 3552msgstr "AddFace" 3553 3554#. Tag: refpurpose 3555#: extras_topology.xml:2310 3556#, no-c-format 3557msgid "" 3558"<refpurpose>Registers a face primitive to a topology and gets its identifier." 3559"</refpurpose>" 3560msgstr "" 3561 3562#. Tag: funcprototype 3563#: extras_topology.xml:2315 3564#, no-c-format 3565msgid "" 3566"<funcdef>integer <function>AddFace</function></funcdef> " 3567"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 3568"<paramdef><type>geometry </type> <parameter>apolygon</parameter></paramdef> " 3569"<paramdef choice=\"opt\"><type>boolean </type> <parameter>force_new=false</" 3570"parameter></paramdef>" 3571msgstr "" 3572"<funcdef>integer <function>AddFace</function></funcdef> " 3573"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 3574"<paramdef><type>geometry </type> <parameter>apolygon</parameter></paramdef> " 3575"<paramdef choice=\"opt\"><type>boolean </type> <parameter>force_new=false</" 3576"parameter></paramdef>" 3577 3578#. Tag: para 3579#: extras_topology.xml:2327 3580#, no-c-format 3581msgid "" 3582"<para>Registers a face primitive to a topology and gets its identifier.</" 3583"para>" 3584msgstr "" 3585 3586#. Tag: para 3587#: extras_topology.xml:2331 3588#, no-c-format 3589msgid "" 3590"For a newly added face, the edges forming its boundaries and the ones " 3591"contained in the face will be updated to have correct values in the " 3592"left_face and right_face fields. Isolated nodes contained in the face will " 3593"also be updated to have a correct containing_face field value." 3594msgstr "" 3595 3596#. Tag: para 3597#: extras_topology.xml:2343 3598#, no-c-format 3599msgid "" 3600"The target topology is assumed to be valid (containing no self-intersecting " 3601"edges). An exception is raised if: The polygon boundary is not fully defined " 3602"by existing edges or the polygon overlaps an existing face." 3603msgstr "" 3604 3605#. Tag: para 3606#: extras_topology.xml:2345 3607#, no-c-format 3608msgid "" 3609"If the <varname>apolygon</varname> geometry already exists as a face, then: " 3610"if <varname>force_new</varname> is false (the default) the face id of the " 3611"existing face is returned; if <varname>force_new</varname> is true a new id " 3612"will be assigned to the newly registered face." 3613msgstr "" 3614 3615#. Tag: para 3616#: extras_topology.xml:2353 3617#, no-c-format 3618msgid "" 3619"When a new registration of an existing face is performed (force_new=true), " 3620"no action will be taken to resolve dangling references to the existing face " 3621"in the edge, node an relation tables, nor will the MBR field of the existing " 3622"face record be updated. It is up to the caller to deal with that." 3623msgstr "" 3624 3625#. Tag: para 3626#: extras_topology.xml:2360 3627#, no-c-format 3628msgid "" 3629"The <varname>apolygon</varname> geometry must have the same <varname>srid</" 3630"varname> as defined for the topology otherwise an invalid spatial reference " 3631"sys error will be thrown." 3632msgstr "" 3633 3634#. Tag: programlisting 3635#: extras_topology.xml:2369 3636#, no-c-format 3637msgid "" 3638"-- first add the edges we use generate_series as an iterator (the below\n" 3639"-- will only work for polygons with < 10000 points because of our max in " 3640"gs)\n" 3641"SELECT topology.AddEdge('ma_topo', ST_MakeLine(ST_PointN(geom,i), " 3642"ST_PointN(geom, i + 1) )) As edgeid\n" 3643" FROM (SELECT ST_NPoints(geom) AS npt, geom\n" 3644" FROM\n" 3645" (SELECT ST_Boundary(ST_GeomFromText('POLYGON((234896.5 " 3646"899456.7,234914 899436.4,234946.6 899356.9,234872.5 899328.7,\n" 3647" 234891 899285.4,234992.5 899145, 234890.6 899069,234755.2 " 3648"899255.4,\n" 3649" 234612.7 899379.4,234776.9 899563.7,234896.5 899456.7))', " 3650"26986) ) As geom\n" 3651" ) As geoms) As facen CROSS JOIN generate_series(1,10000) As i\n" 3652" WHERE i < npt;\n" 3653"-- result --\n" 3654" edgeid\n" 3655"--------\n" 3656" 3\n" 3657" 4\n" 3658" 5\n" 3659" 6\n" 3660" 7\n" 3661" 8\n" 3662" 9\n" 3663" 10\n" 3664" 11\n" 3665" 12\n" 3666"(10 rows)\n" 3667"-- then add the face -\n" 3668"\n" 3669"SELECT topology.AddFace('ma_topo',\n" 3670" ST_GeomFromText('POLYGON((234896.5 899456.7,234914 899436.4,234946.6 " 3671"899356.9,234872.5 899328.7,\n" 3672" 234891 899285.4,234992.5 899145, 234890.6 899069,234755.2 899255.4,\n" 3673" 234612.7 899379.4,234776.9 899563.7,234896.5 899456.7))', 26986) ) As " 3674"faceid;\n" 3675"-- result --\n" 3676"faceid\n" 3677"--------\n" 3678" 1" 3679msgstr "" 3680 3681#. Tag: refname 3682#: extras_topology.xml:2381 3683#, no-c-format 3684msgid "ST_Simplify" 3685msgstr "ST_Simplify" 3686 3687#. Tag: refpurpose 3688#: extras_topology.xml:2382 3689#, no-c-format 3690msgid "" 3691"Returns a \"simplified\" geometry version of the given TopoGeometry using " 3692"the Douglas-Peucker algorithm." 3693msgstr "" 3694 3695#. Tag: funcprototype 3696#: extras_topology.xml:2388 3697#, fuzzy, no-c-format 3698msgid "" 3699"<funcdef>geometry <function>ST_Simplify</function></funcdef> " 3700"<paramdef><type>TopoGeometry</type> <parameter>tg</parameter></paramdef> " 3701"<paramdef><type>float8</type> <parameter>tolerance</parameter></paramdef>" 3702msgstr "" 3703"<funcdef>geometry <function>ST_GetFaceGeometry</function></funcdef> " 3704"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3705"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef>" 3706 3707#. Tag: para 3708#: extras_topology.xml:2398 3709#, no-c-format 3710msgid "" 3711"Returns a \"simplified\" geometry version of the given TopoGeometry using " 3712"the Douglas-Peucker algorithm on each component edge." 3713msgstr "" 3714 3715#. Tag: para 3716#: extras_topology.xml:2401 3717#, no-c-format 3718msgid "The returned geometry may be non-simple or non-valid." 3719msgstr "" 3720 3721#. Tag: para 3722#: extras_topology.xml:2402 3723#, no-c-format 3724msgid "Splitting component edges may help retaining simplicity/validity." 3725msgstr "" 3726 3727#. Tag: para 3728#: extras_topology.xml:2405 extras_topology.xml:3022 3729#, no-c-format 3730msgid "Availability: 2.1.0" 3731msgstr "" 3732 3733#. Tag: para 3734#: extras_topology.xml:2410 3735#, no-c-format 3736msgid "" 3737"Geometry <xref linkend=\"ST_Simplify\"/>, <xref linkend=\"ST_IsSimple\"/>, " 3738"<xref linkend=\"ST_IsValid\"/>, <xref linkend=\"ST_ModEdgeSplit\"/>" 3739msgstr "" 3740 3741#. Tag: para 3742#: extras_topology.xml:2420 3743#, no-c-format 3744msgid "" 3745"This section covers the topology functions for creating new topogeometries." 3746msgstr "" 3747 3748#. Tag: title 3749#: extras_topology.xml:2423 3750#, no-c-format 3751msgid "TopoGeometry Constructors" 3752msgstr "" 3753 3754#. Tag: refname 3755#: extras_topology.xml:2426 3756#, no-c-format 3757msgid "CreateTopoGeom" 3758msgstr "CreateTopoGeom" 3759 3760#. Tag: refpurpose 3761#: extras_topology.xml:2428 3762#, no-c-format 3763msgid "" 3764"Creates a new topo geometry object from topo element array - tg_type: 1:" 3765"[multi]point, 2:[multi]line, 3:[multi]poly, 4:collection" 3766msgstr "" 3767 3768#. Tag: funcsynopsis 3769#: extras_topology.xml:2432 3770#, no-c-format 3771msgid "" 3772"<funcprototype> <funcdef>topogeometry <function>CreateTopoGeom</function></" 3773"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 3774"paramdef> <paramdef><type>integer </type> <parameter>tg_type</parameter></" 3775"paramdef> <paramdef><type>integer</type> <parameter>layer_id</parameter></" 3776"paramdef> <paramdef><type>topoelementarray</type> <parameter>tg_objs</" 3777"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>topogeometry " 3778"<function>CreateTopoGeom</function></funcdef> <paramdef><type>varchar </" 3779"type> <parameter>toponame</parameter></paramdef> <paramdef><type>integer </" 3780"type> <parameter>tg_type</parameter></paramdef> <paramdef><type>integer</" 3781"type> <parameter>layer_id</parameter></paramdef> </funcprototype>" 3782msgstr "" 3783"<funcprototype> <funcdef>topogeometry <function>CreateTopoGeom</function></" 3784"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 3785"paramdef> <paramdef><type>integer </type> <parameter>tg_type</parameter></" 3786"paramdef> <paramdef><type>integer</type> <parameter>layer_id</parameter></" 3787"paramdef> <paramdef><type>topoelementarray</type> <parameter>tg_objs</" 3788"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>topogeometry " 3789"<function>CreateTopoGeom</function></funcdef> <paramdef><type>varchar </" 3790"type> <parameter>toponame</parameter></paramdef> <paramdef><type>integer </" 3791"type> <parameter>tg_type</parameter></paramdef> <paramdef><type>integer</" 3792"type> <parameter>layer_id</parameter></paramdef> </funcprototype>" 3793 3794#. Tag: para 3795#: extras_topology.xml:2453 3796#, no-c-format 3797msgid "" 3798"Creates a topogeometry object for layer denoted by <varname>layer_id</" 3799"varname> and registers it in the relations table in the <varname>toponame</" 3800"varname> schema." 3801msgstr "" 3802 3803#. Tag: para 3804#: extras_topology.xml:2454 3805#, no-c-format 3806msgid "" 3807"<varname>tg_type</varname> is an integer: 1:[multi]point (punctal), 2:" 3808"[multi]line (lineal), 3:[multi]poly (areal), 4:collection. " 3809"<varname>layer_id</varname> is the layer id in the topology.layer table." 3810msgstr "" 3811 3812#. Tag: para 3813#: extras_topology.xml:2455 3814#, no-c-format 3815msgid "" 3816"punctal layers are formed from set of nodes, lineal layers are formed from a " 3817"set of edges, areal layers are formed from a set of faces, and collections " 3818"can be formed from a mixture of nodes, edges, and faces." 3819msgstr "" 3820 3821#. Tag: para 3822#: extras_topology.xml:2457 3823#, no-c-format 3824msgid "" 3825"Omitting the array of components generates an empty TopoGeometry object." 3826msgstr "" 3827 3828#. Tag: title 3829#: extras_topology.xml:2464 3830#, no-c-format 3831msgid "Examples: Form from existing edges" 3832msgstr "" 3833 3834#. Tag: para 3835#: extras_topology.xml:2465 3836#, no-c-format 3837msgid "" 3838"Create a topogeom in ri_topo schema for layer 2 (our ri_roads), of type (2) " 3839"LINE, for the first edge (we loaded in <varname>ST_CreateTopoGeo</varname>)." 3840msgstr "" 3841 3842#. Tag: programlisting 3843#: extras_topology.xml:2466 3844#, no-c-format 3845msgid "" 3846"INSERT INTO ri.ri_roads(road_name, topo) VALUES('Unknown', topology." 3847"CreateTopoGeom('ri_topo',2,2,'{{1,2}}'::topology.topoelementarray);" 3848msgstr "" 3849"INSERT INTO ri.ri_roads(road_name, topo) VALUES('Unknown', topology." 3850"CreateTopoGeom('ri_topo',2,2,'{{1,2}}'::topology.topoelementarray);" 3851 3852#. Tag: title 3853#: extras_topology.xml:2471 3854#, no-c-format 3855msgid "Examples: Convert an areal geometry to best guess topogeometry" 3856msgstr "" 3857 3858#. Tag: para 3859#: extras_topology.xml:2472 3860#, no-c-format 3861msgid "" 3862"Lets say we have geometries that should be formed from a collection of " 3863"faces. We have for example blockgroups table and want to know the topo " 3864"geometry of each block group. If our data was perfectly aligned, we could do " 3865"this:" 3866msgstr "" 3867 3868#. Tag: programlisting 3869#: extras_topology.xml:2474 3870#, no-c-format 3871msgid "" 3872"-- create our topo geometry column --\n" 3873"SELECT topology.AddTopoGeometryColumn(\n" 3874" 'topo_boston',\n" 3875" 'boston', 'blockgroups', 'topo', 'POLYGON');\n" 3876"\n" 3877"-- addtopgeometrycolumn --\n" 3878"1\n" 3879"\n" 3880"-- update our column assuming\n" 3881"-- everything is perfectly aligned with our edges\n" 3882"UPDATE boston.blockgroups AS bg\n" 3883" SET topo = topology.CreateTopoGeom('topo_boston'\n" 3884" ,3,1\n" 3885" , foo.bfaces)\n" 3886"FROM (SELECT b.gid, topology.TopoElementArray_Agg(ARRAY[f.face_id,3]) As " 3887"bfaces\n" 3888" FROM boston.blockgroups As b\n" 3889" INNER JOIN topo_boston.face As f ON b.geom && f.mbr\n" 3890" WHERE ST_Covers(b.geom, topology.ST_GetFaceGeometry('topo_boston', f." 3891"face_id))\n" 3892" GROUP BY b.gid) As foo\n" 3893"WHERE foo.gid = bg.gid;" 3894msgstr "" 3895 3896#. Tag: programlisting 3897#: extras_topology.xml:2476 3898#, no-c-format 3899msgid "" 3900"--the world is rarely perfect allow for some error\n" 3901"--count the face if 50% of it falls\n" 3902"-- within what we think is our blockgroup boundary\n" 3903"UPDATE boston.blockgroups AS bg\n" 3904" SET topo = topology.CreateTopoGeom('topo_boston'\n" 3905" ,3,1\n" 3906" , foo.bfaces)\n" 3907"FROM (SELECT b.gid, topology.TopoElementArray_Agg(ARRAY[f.face_id,3]) As " 3908"bfaces\n" 3909" FROM boston.blockgroups As b\n" 3910" INNER JOIN topo_boston.face As f ON b.geom && f.mbr\n" 3911" WHERE ST_Covers(b.geom, topology.ST_GetFaceGeometry('topo_boston', f." 3912"face_id))\n" 3913" OR\n" 3914" ( ST_Intersects(b.geom, topology.ST_GetFaceGeometry('topo_boston', f." 3915"face_id))\n" 3916" AND ST_Area(ST_Intersection(b.geom, topology." 3917"ST_GetFaceGeometry('topo_boston', f.face_id) ) ) >\n" 3918" ST_Area(topology.ST_GetFaceGeometry('topo_boston', f." 3919"face_id))*0.5\n" 3920" )\n" 3921" GROUP BY b.gid) As foo\n" 3922"WHERE foo.gid = bg.gid;\n" 3923"\n" 3924"-- and if we wanted to convert our topogeometry back\n" 3925"-- to a denormalized geometry aligned with our faces and edges\n" 3926"-- cast the topo to a geometry\n" 3927"-- The really cool thing is my new geometries\n" 3928"-- are now aligned with my tiger street centerlines\n" 3929"UPDATE boston.blockgroups SET new_geom = topo::geometry;" 3930msgstr "" 3931 3932#. Tag: para 3933#: extras_topology.xml:2482 3934#, no-c-format 3935msgid "" 3936", <xref linkend=\"toTopoGeom\"/> <xref linkend=\"ST_CreateTopoGeo\"/>, <xref " 3937"linkend=\"ST_GetFaceGeometry\"/>, <xref linkend=\"topoelementarray\"/>, " 3938"<xref linkend=\"TopoElementArray_Agg\"/>" 3939msgstr "" 3940", <xref linkend=\"toTopoGeom\"/> <xref linkend=\"ST_CreateTopoGeo\"/>, <xref " 3941"linkend=\"ST_GetFaceGeometry\"/>, <xref linkend=\"topoelementarray\"/>, " 3942"<xref linkend=\"TopoElementArray_Agg\"/>" 3943 3944#. Tag: refname 3945#: extras_topology.xml:2495 extras_topology.xml:2754 3946#, no-c-format 3947msgid "toTopoGeom" 3948msgstr "toTopoGeom" 3949 3950#. Tag: refpurpose 3951#: extras_topology.xml:2497 3952#, no-c-format 3953msgid "Converts a simple Geometry into a topo geometry." 3954msgstr "" 3955 3956#. Tag: funcsynopsis 3957#: extras_topology.xml:2501 3958#, no-c-format 3959msgid "" 3960"<funcprototype> <funcdef>topogeometry <function>toTopoGeom</function></" 3961"funcdef> <paramdef><type>geometry </type> <parameter>geom</parameter></" 3962"paramdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 3963"paramdef> <paramdef><type>integer</type> <parameter>layer_id</parameter></" 3964"paramdef> <paramdef choice=\"opt\"><type>float8</type> <parameter>tolerance</" 3965"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>topogeometry " 3966"<function>toTopoGeom</function></funcdef> <paramdef><type>geometry </type> " 3967"<parameter>geom</parameter></paramdef> <paramdef><type>topogeometry </type> " 3968"<parameter>topogeom</parameter></paramdef> <paramdef choice=\"opt" 3969"\"><type>float8</type> <parameter>tolerance</parameter></paramdef> </" 3970"funcprototype>" 3971msgstr "" 3972 3973#. Tag: para 3974#: extras_topology.xml:2522 3975#, no-c-format 3976msgid "Converts a simple Geometry into a <xref linkend=\"topogeometry\"/>." 3977msgstr "" 3978 3979#. Tag: para 3980#: extras_topology.xml:2526 3981#, no-c-format 3982msgid "" 3983"Topological primitives required to represent the input geometry will be " 3984"added to the underlying topology, possibly splitting existing ones, and they " 3985"will be associated with the output TopoGeometry in the <varname>relation</" 3986"varname> table." 3987msgstr "" 3988 3989#. Tag: para 3990#: extras_topology.xml:2533 3991#, no-c-format 3992msgid "" 3993"Existing TopoGeometry objects (with the possible exception of " 3994"<varname>topogeom</varname>, if given) will retain their shapes." 3995msgstr "" 3996 3997#. Tag: para 3998#: extras_topology.xml:2538 3999#, no-c-format 4000msgid "" 4001"When <varname>tolerance</varname> is given it will be used to snap the input " 4002"geometry to existing primitives." 4003msgstr "" 4004 4005#. Tag: para 4006#: extras_topology.xml:2543 4007#, no-c-format 4008msgid "" 4009"In the first form a new TopoGeometry will be created for the given layer " 4010"(<varname>layer_id</varname>) of the given topology (<varname>toponame</" 4011"varname>)." 4012msgstr "" 4013 4014#. Tag: para 4015#: extras_topology.xml:2548 4016#, no-c-format 4017msgid "" 4018"In the second form the primitives resulting from the conversion will be " 4019"added to the pre-existing TopoGeometry (<varname>topogeom</varname>), " 4020"possibly adding space to its final shape. To have the new shape completely " 4021"replace the old one see <xref linkend=\"clearTopoGeom\"/>." 4022msgstr "" 4023 4024#. Tag: para 4025#: extras_topology.xml:2557 4026#, no-c-format 4027msgid "Enhanced: 2.1.0 adds the version taking an existing TopoGeometry." 4028msgstr "" 4029 4030#. Tag: para 4031#: extras_topology.xml:2561 4032#, no-c-format 4033msgid "This is a full self-contained workflow" 4034msgstr "" 4035 4036#. Tag: programlisting 4037#: extras_topology.xml:2562 4038#, no-c-format 4039msgid "" 4040"-- do this if you don't have a topology setup already\n" 4041"-- creates topology not allowing any tolerance\n" 4042"SELECT topology.CreateTopology('topo_boston_test', 2249);\n" 4043"-- create a new table\n" 4044"CREATE TABLE nei_topo(gid serial primary key, nei varchar(30));\n" 4045"--add a topogeometry column to it\n" 4046"SELECT topology.AddTopoGeometryColumn('topo_boston_test', 'public', " 4047"'nei_topo', 'topo', 'MULTIPOLYGON') As new_layer_id;\n" 4048"new_layer_id\n" 4049"-----------\n" 4050"1\n" 4051"\n" 4052"--use new layer id in populating the new topogeometry column\n" 4053"-- we add the topogeoms to the new layer with 0 tolerance\n" 4054"INSERT INTO nei_topo(nei, topo)\n" 4055"SELECT nei, topology.toTopoGeom(geom, 'topo_boston_test', 1)\n" 4056"FROM neighborhoods\n" 4057"WHERE gid BETWEEN 1 and 15;\n" 4058"\n" 4059"--use to verify what has happened --\n" 4060"SELECT * FROM\n" 4061" topology.TopologySummary('topo_boston_test');\n" 4062"\n" 4063"-- summary--\n" 4064"Topology topo_boston_test (5), SRID 2249, precision 0\n" 4065"61 nodes, 87 edges, 35 faces, 15 topogeoms in 1 layers\n" 4066"Layer 1, type Polygonal (3), 15 topogeoms\n" 4067" Deploy: public.nei_topo.topo" 4068msgstr "" 4069 4070#. Tag: programlisting 4071#: extras_topology.xml:2564 4072#, no-c-format 4073msgid "" 4074"-- Shrink all TopoGeometry polygons by 10 meters\n" 4075"UPDATE nei_topo SET topo = ST_Buffer(clearTopoGeom(topo), -10);\n" 4076"\n" 4077"-- Get the no-one-lands left by the above operation\n" 4078"-- I think GRASS calls this \"polygon0 layer\"\n" 4079"SELECT ST_GetFaceGeometry('topo_boston_test', f.face_id)\n" 4080" FROM topo_boston_test.face f\n" 4081" WHERE f.face_id > 0 -- don't consider the universe face\n" 4082" AND NOT EXISTS ( -- check that no TopoGeometry references the face\n" 4083" SELECT * FROM topo_boston_test.relation\n" 4084" WHERE layer_id = 1 AND element_id = f.face_id\n" 4085" );" 4086msgstr "" 4087 4088#. Tag: para 4089#: extras_topology.xml:2570 4090#, no-c-format 4091msgid "" 4092", <xref linkend=\"AddTopoGeometryColumn\"/>, <xref linkend=\"CreateTopoGeom" 4093"\"/>, <xref linkend=\"TopologySummary\"/>, <xref linkend=\"clearTopoGeom\"/>" 4094msgstr "" 4095 4096#. Tag: refname 4097#: extras_topology.xml:2582 4098#, no-c-format 4099msgid "TopoElementArray_Agg" 4100msgstr "TopoElementArray_Agg" 4101 4102#. Tag: refpurpose 4103#: extras_topology.xml:2583 4104#, no-c-format 4105msgid "" 4106"Returns a <varname>topoelementarray</varname> for a set of element_id, type " 4107"arrays (topoelements)." 4108msgstr "" 4109 4110#. Tag: funcprototype 4111#: extras_topology.xml:2588 4112#, no-c-format 4113msgid "" 4114"<funcdef>topoelementarray <function>TopoElementArray_Agg</function></" 4115"funcdef> <paramdef><type>topoelement set</type> <parameter>tefield</" 4116"parameter></paramdef>" 4117msgstr "" 4118"<funcdef>topoelementarray <function>TopoElementArray_Agg</function></" 4119"funcdef> <paramdef><type>topoelement set</type> <parameter>tefield</" 4120"parameter></paramdef>" 4121 4122#. Tag: para 4123#: extras_topology.xml:2598 4124#, no-c-format 4125msgid "" 4126"Used to create a <xref linkend=\"topoelementarray\"/> from a set of <xref " 4127"linkend=\"topoelement\"/>." 4128msgstr "" 4129 4130#. Tag: programlisting 4131#: extras_topology.xml:2607 4132#, no-c-format 4133msgid "" 4134"SELECT topology.TopoElementArray_Agg(ARRAY[e,t]) As tea\n" 4135" FROM generate_series(1,3) As e CROSS JOIN generate_series(1,4) As t;\n" 4136" tea\n" 4137"--------------------------------------------------------------------------\n" 4138"{{1,1},{1,2},{1,3},{1,4},{2,1},{2,2},{2,3},{2,4},{3,1},{3,2},{3,3},{3,4}}" 4139msgstr "" 4140"SELECT topology.TopoElementArray_Agg(ARRAY[e,t]) As tea\n" 4141" FROM generate_series(1,3) As e CROSS JOIN generate_series(1,4) As t;\n" 4142" tea\n" 4143"--------------------------------------------------------------------------\n" 4144"{{1,1},{1,2},{1,3},{1,4},{2,1},{2,2},{2,3},{2,4},{3,1},{3,2},{3,3},{3,4}}" 4145 4146#. Tag: para 4147#: extras_topology.xml:2611 extras_topology.xml:2816 4148#, no-c-format 4149msgid ", <xref linkend=\"topoelementarray\"/>" 4150msgstr "" 4151 4152#. Tag: para 4153#: extras_topology.xml:2619 4154#, no-c-format 4155msgid "" 4156"This section covers the topology functions for editing existing " 4157"topogeometries." 4158msgstr "" 4159 4160#. Tag: title 4161#: extras_topology.xml:2622 4162#, no-c-format 4163msgid "TopoGeometry Editors" 4164msgstr "" 4165 4166#. Tag: refname 4167#: extras_topology.xml:2626 4168#, no-c-format 4169msgid "clearTopoGeom" 4170msgstr "" 4171 4172#. Tag: refpurpose 4173#: extras_topology.xml:2628 4174#, no-c-format 4175msgid "Clears the content of a topo geometry." 4176msgstr "" 4177 4178#. Tag: funcprototype 4179#: extras_topology.xml:2633 4180#, no-c-format 4181msgid "" 4182"<funcdef>topogeometry <function>clearTopoGeom</function></funcdef> " 4183"<paramdef><type>topogeometry </type> <parameter>topogeom</parameter></" 4184"paramdef>" 4185msgstr "" 4186 4187#. Tag: para 4188#: extras_topology.xml:2643 4189#, no-c-format 4190msgid "" 4191"Clears the content a <xref linkend=\"topogeometry\"/> turning it into an " 4192"empty one. Mostly useful in conjunction with <xref linkend=\"toTopoGeom\"/> " 4193"to replace the shape of existing objects and any dependent object in higher " 4194"hierarchical levels." 4195msgstr "" 4196 4197#. Tag: para 4198#: extras_topology.xml:2651 4199#, no-c-format 4200msgid "Availability: 2.1" 4201msgstr "" 4202 4203#. Tag: programlisting 4204#: extras_topology.xml:2655 4205#, no-c-format 4206msgid "" 4207"-- Shrink all TopoGeometry polygons by 10 meters\n" 4208"UPDATE nei_topo SET topo = ST_Buffer(clearTopoGeom(topo), -10);" 4209msgstr "" 4210 4211#. Tag: refname 4212#: extras_topology.xml:2669 4213#, no-c-format 4214msgid "TopoGeom_addElement" 4215msgstr "" 4216 4217#. Tag: refpurpose 4218#: extras_topology.xml:2670 4219#, no-c-format 4220msgid "Adds an element to the definition of a TopoGeometry." 4221msgstr "" 4222 4223#. Tag: funcprototype 4224#: extras_topology.xml:2674 4225#, no-c-format 4226msgid "" 4227"<funcdef>topogeometry <function>TopoGeom_addElement</function></funcdef> " 4228"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4229"<paramdef><type>topoelement </type> <parameter>el</parameter></paramdef>" 4230msgstr "" 4231 4232#. Tag: para 4233#: extras_topology.xml:2685 4234#, no-c-format 4235msgid "" 4236"Adds a <xref linkend=\"topoelement\"/> to the definition of a TopoGeometry " 4237"object. Does not error out if the element is already part of the definition." 4238msgstr "" 4239 4240#. Tag: para 4241#: extras_topology.xml:2692 extras_topology.xml:2735 4242#, no-c-format 4243msgid "Availability: 2.3" 4244msgstr "" 4245 4246#. Tag: programlisting 4247#: extras_topology.xml:2696 4248#, no-c-format 4249msgid "" 4250"-- Add edge 5 to TopoGeometry tg\n" 4251"UPDATE mylayer SET tg = TopoGeom_addElement(tg, '{5,2}');" 4252msgstr "" 4253 4254#. Tag: para 4255#: extras_topology.xml:2702 extras_topology.xml:2745 4256#, no-c-format 4257msgid ", <xref linkend=\"CreateTopoGeom\"/>" 4258msgstr ", <xref linkend=\"CreateTopoGeom\"/>" 4259 4260#. Tag: refname 4261#: extras_topology.xml:2711 4262#, no-c-format 4263msgid "TopoGeom_remElement" 4264msgstr "" 4265 4266#. Tag: refpurpose 4267#: extras_topology.xml:2713 4268#, no-c-format 4269msgid "Removes an element from the definition of a TopoGeometry." 4270msgstr "" 4271 4272#. Tag: funcprototype 4273#: extras_topology.xml:2718 4274#, no-c-format 4275msgid "" 4276"<funcdef>topogeometry <function>TopoGeom_remElement</function></funcdef> " 4277"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4278"<paramdef><type>topoelement </type> <parameter>el</parameter></paramdef>" 4279msgstr "" 4280 4281#. Tag: para 4282#: extras_topology.xml:2729 4283#, no-c-format 4284msgid "" 4285"Removes a <xref linkend=\"topoelement\"/> from the definition of a " 4286"TopoGeometry object." 4287msgstr "" 4288 4289#. Tag: programlisting 4290#: extras_topology.xml:2739 4291#, no-c-format 4292msgid "" 4293"-- Remove face 43 from TopoGeometry tg\n" 4294"UPDATE mylayer SET tg = TopoGeom_remElement(tg, '{43,3}');" 4295msgstr "" 4296 4297#. Tag: refpurpose 4298#: extras_topology.xml:2755 4299#, no-c-format 4300msgid "Adds a geometry shape to an existing topo geometry." 4301msgstr "" 4302 4303#. Tag: para 4304#: extras_topology.xml:2759 4305#, fuzzy, no-c-format 4306msgid "Refer to <xref linkend=\"toTopoGeom\"/>." 4307msgstr ", <xref linkend=\"CreateTopoGeom\"/>" 4308 4309#. Tag: title 4310#: extras_topology.xml:2769 4311#, no-c-format 4312msgid "TopoGeometry Accessors" 4313msgstr "" 4314 4315#. Tag: refname 4316#: extras_topology.xml:2773 4317#, no-c-format 4318msgid "GetTopoGeomElementArray" 4319msgstr "GetTopoGeomElementArray" 4320 4321#. Tag: refpurpose 4322#: extras_topology.xml:2775 4323#, no-c-format 4324msgid "" 4325"Returns a <varname>topoelementarray</varname> (an array of topoelements) " 4326"containing the topological elements and type of the given TopoGeometry " 4327"(primitive elements)." 4328msgstr "" 4329 4330#. Tag: funcprototype 4331#: extras_topology.xml:2780 4332#, no-c-format 4333msgid "" 4334"<funcdef>topoelementarray <function>GetTopoGeomElementArray</function></" 4335"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 4336"paramdef> <paramdef><type>integer </type> <parameter>layer_id</parameter></" 4337"paramdef> <paramdef><type>integer</type> <parameter>tg_id</parameter></" 4338"paramdef>" 4339msgstr "" 4340"<funcdef>topoelementarray <function>GetTopoGeomElementArray</function></" 4341"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 4342"paramdef> <paramdef><type>integer </type> <parameter>layer_id</parameter></" 4343"paramdef> <paramdef><type>integer</type> <parameter>tg_id</parameter></" 4344"paramdef>" 4345 4346#. Tag: funcprototype 4347#: extras_topology.xml:2788 4348#, no-c-format 4349msgid "" 4350"<funcdef>topoelementarray topoelement <function>GetTopoGeomElementArray</" 4351"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4352"parameter></paramdef>" 4353msgstr "" 4354"<funcdef>topoelementarray topoelement <function>GetTopoGeomElementArray</" 4355"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4356"parameter></paramdef>" 4357 4358#. Tag: para 4359#: extras_topology.xml:2798 4360#, no-c-format 4361msgid "" 4362"Returns a <xref linkend=\"topoelementarray\"/> containing the topological " 4363"elements and type of the given TopoGeometry (primitive elements). This is " 4364"similar to GetTopoGeomElements except it returns the elements as an array " 4365"rather than as a dataset." 4366msgstr "" 4367 4368#. Tag: para 4369#: extras_topology.xml:2800 extras_topology.xml:2847 4370#, no-c-format 4371msgid "" 4372"tg_id is the topogeometry id of the topogeometry object in the topology in " 4373"the layer denoted by <varname>layer_id</varname> in the topology.layer table." 4374msgstr "" 4375 4376#. Tag: refname 4377#: extras_topology.xml:2821 4378#, no-c-format 4379msgid "GetTopoGeomElements" 4380msgstr "GetTopoGeomElements" 4381 4382#. Tag: refpurpose 4383#: extras_topology.xml:2823 4384#, no-c-format 4385msgid "" 4386"Returns a set of <varname>topoelement</varname> objects containing the " 4387"topological element_id,element_type of the given TopoGeometry (primitive " 4388"elements)." 4389msgstr "" 4390 4391#. Tag: funcprototype 4392#: extras_topology.xml:2828 4393#, no-c-format 4394msgid "" 4395"<funcdef>setof topoelement <function>GetTopoGeomElements</function></" 4396"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 4397"paramdef> <paramdef><type>integer </type> <parameter>layer_id</parameter></" 4398"paramdef> <paramdef><type>integer</type> <parameter>tg_id</parameter></" 4399"paramdef>" 4400msgstr "" 4401"<funcdef>setof topoelement <function>GetTopoGeomElements</function></" 4402"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 4403"paramdef> <paramdef><type>integer </type> <parameter>layer_id</parameter></" 4404"paramdef> <paramdef><type>integer</type> <parameter>tg_id</parameter></" 4405"paramdef>" 4406 4407#. Tag: funcprototype 4408#: extras_topology.xml:2836 4409#, no-c-format 4410msgid "" 4411"<funcdef>setof topoelement <function>GetTopoGeomElements</function></" 4412"funcdef> <paramdef><type>topogeometry </type> <parameter>tg</parameter></" 4413"paramdef>" 4414msgstr "" 4415"<funcdef>setof topoelement <function>GetTopoGeomElements</function></" 4416"funcdef> <paramdef><type>topogeometry </type> <parameter>tg</parameter></" 4417"paramdef>" 4418 4419#. Tag: para 4420#: extras_topology.xml:2846 4421#, no-c-format 4422msgid "" 4423"Returns a set of element_id,element_type (topoelements) for a given " 4424"topogeometry object in <varname>toponame</varname> schema." 4425msgstr "" 4426 4427#. Tag: para 4428#: extras_topology.xml:2863 4429#, no-c-format 4430msgid "" 4431", <xref linkend=\"topoelement\"/>, <xref linkend=\"TopoGeom_addElement\"/>, " 4432"<xref linkend=\"TopoGeom_remElement\"/>" 4433msgstr "" 4434 4435#. Tag: title 4436#: extras_topology.xml:2876 4437#, no-c-format 4438msgid "TopoGeometry Outputs" 4439msgstr "" 4440 4441#. Tag: refname 4442#: extras_topology.xml:2879 4443#, no-c-format 4444msgid "AsGML" 4445msgstr "AsGML" 4446 4447#. Tag: refpurpose 4448#: extras_topology.xml:2881 4449#, no-c-format 4450msgid "Returns the GML representation of a topogeometry." 4451msgstr "" 4452 4453#. Tag: funcsynopsis 4454#: extras_topology.xml:2885 4455#, no-c-format 4456msgid "" 4457"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> " 4458"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> </" 4459"funcprototype> <funcprototype> <funcdef>text <function>AsGML</function></" 4460"funcdef> <paramdef><type>topogeometry </type> <parameter>tg</parameter></" 4461"paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</parameter></" 4462"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</" 4463"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4464"parameter></paramdef> <paramdef><type>regclass </type> " 4465"<parameter>visitedTable</parameter></paramdef> </funcprototype> " 4466"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> " 4467"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4468"<paramdef><type>regclass </type> <parameter>visitedTable</parameter></" 4469"paramdef> <paramdef><type>text </type> <parameter>nsprefix</parameter></" 4470"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</" 4471"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4472"parameter></paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</" 4473"parameter></paramdef> <paramdef><type>integer </type> <parameter>precision</" 4474"parameter></paramdef> <paramdef><type>integer </type> <parameter>options</" 4475"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>text " 4476"<function>AsGML</function></funcdef> <paramdef><type>topogeometry </type> " 4477"<parameter>tg</parameter></paramdef> <paramdef><type>text </type> " 4478"<parameter>nsprefix_in</parameter></paramdef> <paramdef><type>integer </" 4479"type> <parameter>precision</parameter></paramdef> <paramdef><type>integer </" 4480"type> <parameter>options</parameter></paramdef> <paramdef><type>regclass </" 4481"type> <parameter>visitedTable</parameter></paramdef> </funcprototype> " 4482"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> " 4483"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4484"<paramdef><type>text </type> <parameter>nsprefix_in</parameter></paramdef> " 4485"<paramdef><type>integer </type> <parameter>precision</parameter></paramdef> " 4486"<paramdef><type>integer </type> <parameter>options</parameter></paramdef> " 4487"<paramdef><type>regclass </type> <parameter>visitedTable</parameter></" 4488"paramdef> <paramdef><type>text </type> <parameter>idprefix</parameter></" 4489"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</" 4490"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4491"parameter></paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</" 4492"parameter></paramdef> <paramdef><type>integer </type> <parameter>precision</" 4493"parameter></paramdef> <paramdef><type>integer </type> <parameter>options</" 4494"parameter></paramdef> <paramdef><type>regclass </type> " 4495"<parameter>visitedTable</parameter></paramdef> <paramdef><type>text </type> " 4496"<parameter>idprefix</parameter></paramdef> <paramdef><type>int </type> " 4497"<parameter>gmlversion</parameter></paramdef> </funcprototype>" 4498msgstr "" 4499"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> " 4500"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> </" 4501"funcprototype> <funcprototype> <funcdef>text <function>AsGML</function></" 4502"funcdef> <paramdef><type>topogeometry </type> <parameter>tg</parameter></" 4503"paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</parameter></" 4504"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</" 4505"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4506"parameter></paramdef> <paramdef><type>regclass </type> " 4507"<parameter>visitedTable</parameter></paramdef> </funcprototype> " 4508"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> " 4509"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4510"<paramdef><type>regclass </type> <parameter>visitedTable</parameter></" 4511"paramdef> <paramdef><type>text </type> <parameter>nsprefix</parameter></" 4512"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</" 4513"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4514"parameter></paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</" 4515"parameter></paramdef> <paramdef><type>integer </type> <parameter>precision</" 4516"parameter></paramdef> <paramdef><type>integer </type> <parameter>options</" 4517"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>text " 4518"<function>AsGML</function></funcdef> <paramdef><type>topogeometry </type> " 4519"<parameter>tg</parameter></paramdef> <paramdef><type>text </type> " 4520"<parameter>nsprefix_in</parameter></paramdef> <paramdef><type>integer </" 4521"type> <parameter>precision</parameter></paramdef> <paramdef><type>integer </" 4522"type> <parameter>options</parameter></paramdef> <paramdef><type>regclass </" 4523"type> <parameter>visitedTable</parameter></paramdef> </funcprototype> " 4524"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> " 4525"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4526"<paramdef><type>text </type> <parameter>nsprefix_in</parameter></paramdef> " 4527"<paramdef><type>integer </type> <parameter>precision</parameter></paramdef> " 4528"<paramdef><type>integer </type> <parameter>options</parameter></paramdef> " 4529"<paramdef><type>regclass </type> <parameter>visitedTable</parameter></" 4530"paramdef> <paramdef><type>text </type> <parameter>idprefix</parameter></" 4531"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</" 4532"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4533"parameter></paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</" 4534"parameter></paramdef> <paramdef><type>integer </type> <parameter>precision</" 4535"parameter></paramdef> <paramdef><type>integer </type> <parameter>options</" 4536"parameter></paramdef> <paramdef><type>regclass </type> " 4537"<parameter>visitedTable</parameter></paramdef> <paramdef><type>text </type> " 4538"<parameter>idprefix</parameter></paramdef> <paramdef><type>int </type> " 4539"<parameter>gmlversion</parameter></paramdef> </funcprototype>" 4540 4541#. Tag: para 4542#: extras_topology.xml:2946 4543#, no-c-format 4544msgid "" 4545"Returns the GML representation of a topogeometry in version GML3 format. If " 4546"no <varname>nsprefix_in</varname> is specified then <varname>gml</varname> " 4547"is used. Pass in an empty string for nsprefix to get a non-qualified name " 4548"space. The precision (default: 15) and options (default 1) parameters, if " 4549"given, are passed untouched to the underlying call to ST_AsGML." 4550msgstr "" 4551 4552#. Tag: para 4553#: extras_topology.xml:2948 4554#, no-c-format 4555msgid "" 4556"The <varname>visitedTable</varname> parameter, if given, is used for keeping " 4557"track of the visited Node and Edge elements so to use cross-references " 4558"(xlink:xref) rather than duplicating definitions. The table is expected to " 4559"have (at least) two integer fields: 'element_type' and 'element_id'. The " 4560"calling user must have both read and write privileges on the given table. " 4561"For best performance, an index should be defined on <varname>element_type</" 4562"varname> and <varname>element_id</varname>, in that order. Such index would " 4563"be created automatically by adding a unique constraint to the fields. " 4564"Example:" 4565msgstr "" 4566 4567#. Tag: programlisting 4568#: extras_topology.xml:2954 4569#, no-c-format 4570msgid "" 4571"CREATE TABLE visited (\n" 4572" element_type integer, element_id integer,\n" 4573" unique(element_type, element_id)\n" 4574");" 4575msgstr "" 4576"CREATE TABLE visited (\n" 4577" element_type integer, element_id integer,\n" 4578" unique(element_type, element_id)\n" 4579");" 4580 4581#. Tag: para 4582#: extras_topology.xml:2957 4583#, no-c-format 4584msgid "" 4585"The <varname>idprefix</varname> parameter, if given, will be prepended to " 4586"Edge and Node tag identifiers." 4587msgstr "" 4588 4589#. Tag: para 4590#: extras_topology.xml:2959 4591#, no-c-format 4592msgid "" 4593"The <varname>gmlver</varname> parameter, if given, will be passed to the " 4594"underlying ST_AsGML. Defaults to 3." 4595msgstr "" 4596 4597#. Tag: para 4598#: extras_topology.xml:2968 4599#, no-c-format 4600msgid "" 4601"This uses the topo geometry we created in <xref linkend=\"CreateTopoGeom\"/>" 4602msgstr "" 4603 4604#. Tag: programlisting 4605#: extras_topology.xml:2969 4606#, no-c-format 4607msgid "" 4608"SELECT topology.AsGML(topo) As rdgml\n" 4609" FROM ri.roads\n" 4610" WHERE road_name = 'Unknown';\n" 4611"\n" 4612"-- rdgml--\n" 4613"<![CDATA[<gml:TopoCurve>\n" 4614" <gml:directedEdge>\n" 4615" <gml:Edge gml:id=\"E1\">\n" 4616" <gml:directedNode orientation=\"-\">\n" 4617" <gml:Node gml:id=\"N1\"/>\n" 4618" </gml:directedNode>\n" 4619" <gml:directedNode></gml:directedNode>\n" 4620" <gml:curveProperty>\n" 4621" <gml:Curve srsName=\"urn:ogc:def:crs:EPSG::3438\">\n" 4622" <gml:segments>\n" 4623" <gml:LineStringSegment>\n" 4624" <gml:posList srsDimension=\"2\">384744 236928 " 4625"384750 236923 384769 236911 384799 236895 384811 236890\n" 4626" 384833 236884 384844 236882 384866 236881 384879 " 4627"236883 384954 236898 385087 236932 385117 236938\n" 4628" 385167 236938 385203 236941 385224 236946 385233 " 4629"236950 385241 236956 385254 236971\n" 4630" 385260 236979 385268 236999 385273 237018 385273 " 4631"237037 385271 237047 385267 237057 385225 237125\n" 4632" 385210 237144 385192 237161 385167 237192 385162 " 4633"237202 385159 237214 385159 237227 385162 237241\n" 4634" 385166 237256 385196 237324 385209 237345 385234 " 4635"237375 385237 237383 385238 237399 385236 237407\n" 4636" 385227 237419 385213 237430 385193 237439 385174 " 4637"237451 385170 237455 385169 237460 385171 237475\n" 4638" 385181 237503 385190 237521 385200 237533 385206 " 4639"237538 385213 237541 385221 237542 385235 237540 385242 237541\n" 4640" 385249 237544 385260 237555 385270 237570 385289 " 4641"237584 385292 237589 385291 237596 385284 237630</gml:posList>\n" 4642" </gml:LineStringSegment>\n" 4643" </gml:segments>\n" 4644" </gml:Curve>\n" 4645" </gml:curveProperty>\n" 4646" </gml:Edge>\n" 4647" </gml:directedEdge>\n" 4648"</gml:TopoCurve>]]>" 4649msgstr "" 4650 4651#. Tag: para 4652#: extras_topology.xml:2970 4653#, no-c-format 4654msgid "Same exercise as previous without namespace" 4655msgstr "" 4656 4657#. Tag: programlisting 4658#: extras_topology.xml:2971 4659#, no-c-format 4660msgid "" 4661"SELECT topology.AsGML(topo,'') As rdgml\n" 4662" FROM ri.roads\n" 4663" WHERE road_name = 'Unknown';\n" 4664"\n" 4665"-- rdgml--\n" 4666"<![CDATA[<TopoCurve>\n" 4667" <directedEdge>\n" 4668" <Edge id=\"E1\">\n" 4669" <directedNode orientation=\"-\">\n" 4670" <Node id=\"N1\"/>\n" 4671" </directedNode>\n" 4672" <directedNode></directedNode>\n" 4673" <curveProperty>\n" 4674" <Curve srsName=\"urn:ogc:def:crs:EPSG::3438\">\n" 4675" <segments>\n" 4676" <LineStringSegment>\n" 4677" <posList srsDimension=\"2\">384744 236928 384750 " 4678"236923 384769 236911 384799 236895 384811 236890\n" 4679" 384833 236884 384844 236882 384866 236881 384879 " 4680"236883 384954 236898 385087 236932 385117 236938\n" 4681" 385167 236938 385203 236941 385224 236946 385233 " 4682"236950 385241 236956 385254 236971\n" 4683" 385260 236979 385268 236999 385273 237018 385273 " 4684"237037 385271 237047 385267 237057 385225 237125\n" 4685" 385210 237144 385192 237161 385167 237192 385162 " 4686"237202 385159 237214 385159 237227 385162 237241\n" 4687" 385166 237256 385196 237324 385209 237345 385234 " 4688"237375 385237 237383 385238 237399 385236 237407\n" 4689" 385227 237419 385213 237430 385193 237439 385174 " 4690"237451 385170 237455 385169 237460 385171 237475\n" 4691" 385181 237503 385190 237521 385200 237533 385206 " 4692"237538 385213 237541 385221 237542 385235 237540 385242 237541\n" 4693" 385249 237544 385260 237555 385270 237570 385289 " 4694"237584 385292 237589 385291 237596 385284 237630</posList>\n" 4695" </LineStringSegment>\n" 4696" </segments>\n" 4697" </Curve>\n" 4698" </curveProperty>\n" 4699" </Edge>\n" 4700" </directedEdge>\n" 4701"</TopoCurve>]]>" 4702msgstr "" 4703 4704#. Tag: para 4705#: extras_topology.xml:2977 4706#, no-c-format 4707msgid ", <xref linkend=\"ST_CreateTopoGeo\"/>" 4708msgstr ", <xref linkend=\"ST_CreateTopoGeo\"/>" 4709 4710#. Tag: refname 4711#: extras_topology.xml:2982 4712#, no-c-format 4713msgid "AsTopoJSON" 4714msgstr "" 4715 4716#. Tag: refpurpose 4717#: extras_topology.xml:2984 4718#, no-c-format 4719msgid "Returns the TopoJSON representation of a topogeometry." 4720msgstr "" 4721 4722#. Tag: funcprototype 4723#: extras_topology.xml:2989 4724#, no-c-format 4725msgid "" 4726"<funcdef>text <function>AsTopoJSON</function></funcdef> " 4727"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4728"<paramdef><type>regclass </type> <parameter>edgeMapTable</parameter></" 4729"paramdef>" 4730msgstr "" 4731 4732#. Tag: para 4733#: extras_topology.xml:3000 4734#, no-c-format 4735msgid "" 4736"Returns the TopoJSON representation of a topogeometry. If " 4737"<varname>edgeMapTable</varname> is not null, it will be used as a lookup/" 4738"storage mapping of edge identifiers to arc indices. This is to be able to " 4739"allow for a compact \"arcs\" array in the final document." 4740msgstr "" 4741 4742#. Tag: para 4743#: extras_topology.xml:3003 4744#, no-c-format 4745msgid "" 4746"The table, if given, is expected to have an \"arc_id\" field of type \"serial" 4747"\" and an \"edge_id\" of type integer; the code will query the table for " 4748"\"edge_id\" so it is recommended to add an index on that field." 4749msgstr "" 4750 4751#. Tag: para 4752#: extras_topology.xml:3008 4753#, no-c-format 4754msgid "" 4755"Arc indices in the TopoJSON output are 0-based but they are 1-based in the " 4756"\"edgeMapTable\" table." 4757msgstr "" 4758 4759#. Tag: para 4760#: extras_topology.xml:3014 4761#, no-c-format 4762msgid "" 4763"A full TopoJSON document will be need to contain, in addition to the " 4764"snippets returned by this function, the actual arcs plus some headers. See " 4765"the <ulink url=\"http://github.com/mbostock/topojson-specification/blob/" 4766"master/README.md\">TopoJSON specification</ulink>." 4767msgstr "" 4768 4769#. Tag: para 4770#: extras_topology.xml:3023 4771#, no-c-format 4772msgid "Enhanced: 2.2.1 added support for puntal inputs" 4773msgstr "" 4774 4775#. Tag: programlisting 4776#: extras_topology.xml:3035 4777#, no-c-format 4778msgid "" 4779"CREATE TEMP TABLE edgemap(arc_id serial, edge_id int unique);\n" 4780"\n" 4781"-- header\n" 4782"SELECT '{ \"type\": \"Topology\", \"transform\": { \"scale\": [1,1], " 4783"\"translate\": [0,0] }, \"objects\": {'\n" 4784"\n" 4785"-- objects\n" 4786"UNION ALL SELECT '\"' || feature_name || '\": ' || AsTopoJSON(feature, " 4787"'edgemap')\n" 4788"FROM features.big_parcels WHERE feature_name = 'P3P4';\n" 4789"\n" 4790"-- arcs\n" 4791"WITH edges AS (\n" 4792" SELECT m.arc_id, e.geom FROM edgemap m, city_data.edge e\n" 4793" WHERE e.edge_id = m.edge_id\n" 4794"), points AS (\n" 4795" SELECT arc_id, (st_dumppoints(geom)).* FROM edges\n" 4796"), compare AS (\n" 4797" SELECT p2.arc_id,\n" 4798" CASE WHEN p1.path IS NULL THEN p2.geom\n" 4799" ELSE ST_Translate(p2.geom, -ST_X(p1.geom), -ST_Y(p1.geom))\n" 4800" END AS geom\n" 4801" FROM points p2 LEFT OUTER JOIN points p1\n" 4802" ON ( p1.arc_id = p2.arc_id AND p2.path[1] = p1.path[1]+1 )\n" 4803" ORDER BY arc_id, p2.path\n" 4804"), arcsdump AS (\n" 4805" SELECT arc_id, (regexp_matches( ST_AsGeoJSON(geom), '\\[.*\\]'))[1] as t\n" 4806" FROM compare\n" 4807"), arcs AS (\n" 4808" SELECT arc_id, '[' || array_to_string(array_agg(t), ',') || ']' as a FROM " 4809"arcsdump\n" 4810" GROUP BY arc_id\n" 4811" ORDER BY arc_id\n" 4812")\n" 4813"SELECT '}, \"arcs\": [' UNION ALL\n" 4814"SELECT array_to_string(array_agg(a), E',\\n') from arcs\n" 4815"\n" 4816"-- footer\n" 4817"UNION ALL SELECT ']}'::text as t;\n" 4818"\n" 4819"-- Result:\n" 4820"{ \"type\": \"Topology\", \"transform\": { \"scale\": [1,1], \"translate\": " 4821"[0,0] }, \"objects\": {\n" 4822"\"P3P4\": { \"type\": \"MultiPolygon\", \"arcs\": [[[-1]]," 4823"[[6,5,-5,-4,-3,1]]]}\n" 4824"}, \"arcs\": [\n" 4825" [[25,30],[6,0],[0,10],[-14,0],[0,-10],[8,0]],\n" 4826" [[35,6],[0,8]],\n" 4827" [[35,6],[12,0]],\n" 4828" [[47,6],[0,8]],\n" 4829" [[47,14],[0,8]],\n" 4830" [[35,22],[12,0]],\n" 4831" [[35,14],[0,8]]\n" 4832" ]}" 4833msgstr "" 4834 4835#. Tag: para 4836#: extras_topology.xml:3043 4837#, no-c-format 4838msgid "" 4839"This section lists the Topology functions used to check relationships " 4840"between topogeometries and topology primitives" 4841msgstr "" 4842 4843#. Tag: title 4844#: extras_topology.xml:3046 4845#, no-c-format 4846msgid "Topology Spatial Relationships" 4847msgstr "" 4848 4849#. Tag: refname 4850#: extras_topology.xml:3049 4851#, no-c-format 4852msgid "Equals" 4853msgstr "" 4854 4855#. Tag: refpurpose 4856#: extras_topology.xml:3051 4857#, no-c-format 4858msgid "" 4859"Returns true if two topogeometries are composed of the same topology " 4860"primitives." 4861msgstr "" 4862 4863#. Tag: funcprototype 4864#: extras_topology.xml:3056 4865#, no-c-format 4866msgid "" 4867"<funcdef>boolean <function>Equals</function></funcdef> " 4868"<paramdef><type>topogeometry </type> <parameter>tg1</parameter></paramdef> " 4869"<paramdef><type>topogeometry </type> <parameter>tg2</parameter></paramdef>" 4870msgstr "" 4871 4872#. Tag: para 4873#: extras_topology.xml:3067 4874#, no-c-format 4875msgid "" 4876"Returns true if two topogeometries are composed of the same topology " 4877"primitives: faces, edges, nodes." 4878msgstr "" 4879 4880#. Tag: para 4881#: extras_topology.xml:3071 4882#, no-c-format 4883msgid "" 4884"This function not supported for topogeometries that are geometry " 4885"collections. It also can not compare topogeometries from different " 4886"topologies." 4887msgstr "" 4888 4889#. Tag: para 4890#: extras_topology.xml:3078 extras_topology.xml:3131 4891#, no-c-format 4892msgid "&Z_support;" 4893msgstr "&Z_support;" 4894 4895#. Tag: programlisting 4896#: extras_topology.xml:3085 extras_topology.xml:3138 4897#, no-c-format 4898msgid "<!--TODO: Need example -->" 4899msgstr "" 4900 4901#. Tag: para 4902#: extras_topology.xml:3092 4903#, no-c-format 4904msgid ", <xref linkend=\"ST_Equals\"/>" 4905msgstr "" 4906 4907#. Tag: refname 4908#: extras_topology.xml:3098 4909#, no-c-format 4910msgid "Intersects" 4911msgstr "" 4912 4913#. Tag: refpurpose 4914#: extras_topology.xml:3100 4915#, no-c-format 4916msgid "" 4917"<refpurpose>Returns true if any pair of primitives from the two " 4918"topogeometries intersect.</refpurpose>" 4919msgstr "" 4920 4921#. Tag: funcprototype 4922#: extras_topology.xml:3105 4923#, no-c-format 4924msgid "" 4925"<funcdef>boolean <function>Intersects</function></funcdef> " 4926"<paramdef><type>topogeometry </type> <parameter>tg1</parameter></paramdef> " 4927"<paramdef><type>topogeometry </type> <parameter>tg2</parameter></paramdef>" 4928msgstr "" 4929 4930#. Tag: para 4931#: extras_topology.xml:3116 4932#, no-c-format 4933msgid "" 4934"<para>Returns true if any pair of primitives from the two topogeometries " 4935"intersect.</para>" 4936msgstr "" 4937 4938#. Tag: para 4939#: extras_topology.xml:3123 4940#, no-c-format 4941msgid "" 4942"This function not supported for topogeometries that are geometry " 4943"collections. It also can not compare topogeometries from different " 4944"topologies. Also not currently supported for hierarchichal topogeometries " 4945"(topogeometries composed of other topogeometries)." 4946msgstr "" 4947