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: https://bugs.kde.org\n" 13"POT-Creation-Date: 2020-07-18 20:51+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:641 169#: extras_topology.xml:689 extras_topology.xml:737 extras_topology.xml:781 170#: extras_topology.xml:829 extras_topology.xml:873 extras_topology.xml:922 171#: extras_topology.xml:982 extras_topology.xml:1028 extras_topology.xml:1075 172#: extras_topology.xml:1132 extras_topology.xml:1198 extras_topology.xml:1270 173#: extras_topology.xml:1338 extras_topology.xml:1404 extras_topology.xml:1459 174#: extras_topology.xml:1507 extras_topology.xml:1554 extras_topology.xml:1597 175#: extras_topology.xml:1651 extras_topology.xml:1692 extras_topology.xml:1739 176#: extras_topology.xml:1790 extras_topology.xml:1839 extras_topology.xml:1889 177#: extras_topology.xml:1931 extras_topology.xml:1973 extras_topology.xml:2016 178#: extras_topology.xml:2066 extras_topology.xml:2111 extras_topology.xml:2172 179#: extras_topology.xml:2230 extras_topology.xml:2271 extras_topology.xml:2328 180#: extras_topology.xml:2373 extras_topology.xml:2445 extras_topology.xml:2499 181#: extras_topology.xml:2568 extras_topology.xml:2644 extras_topology.xml:2689 182#: extras_topology.xml:2731 extras_topology.xml:2775 extras_topology.xml:2806 183#: extras_topology.xml:2844 extras_topology.xml:2892 extras_topology.xml:2992 184#: extras_topology.xml:3046 extras_topology.xml:3113 extras_topology.xml:3162 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:666 extras_topology.xml:715 318#: extras_topology.xml:754 extras_topology.xml:803 extras_topology.xml:844 319#: extras_topology.xml:893 extras_topology.xml:942 extras_topology.xml:1003 320#: extras_topology.xml:1050 extras_topology.xml:1106 extras_topology.xml:1171 321#: extras_topology.xml:1243 extras_topology.xml:1311 extras_topology.xml:1378 322#: extras_topology.xml:1427 extras_topology.xml:1476 extras_topology.xml:1526 323#: extras_topology.xml:1574 extras_topology.xml:1623 extras_topology.xml:1669 324#: extras_topology.xml:1710 extras_topology.xml:1764 extras_topology.xml:1810 325#: extras_topology.xml:1862 extras_topology.xml:1904 extras_topology.xml:1946 326#: extras_topology.xml:1988 extras_topology.xml:2039 extras_topology.xml:2084 327#: extras_topology.xml:2144 extras_topology.xml:2197 extras_topology.xml:2246 328#: extras_topology.xml:2305 extras_topology.xml:2345 extras_topology.xml:2422 329#: extras_topology.xml:2457 extras_topology.xml:2529 extras_topology.xml:2617 330#: extras_topology.xml:2658 extras_topology.xml:2708 extras_topology.xml:2749 331#: extras_topology.xml:2792 extras_topology.xml:2863 extras_topology.xml:2910 332#: extras_topology.xml:3024 extras_topology.xml:3077 extras_topology.xml:3138 333#: extras_topology.xml:3191 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:655 458#: extras_topology.xml:705 extras_topology.xml:748 extras_topology.xml:797 459#: extras_topology.xml:996 extras_topology.xml:1043 extras_topology.xml:1099 460#: extras_topology.xml:1164 extras_topology.xml:1236 extras_topology.xml:1304 461#: extras_topology.xml:1372 extras_topology.xml:1421 extras_topology.xml:1568 462#: extras_topology.xml:1617 extras_topology.xml:1663 extras_topology.xml:1704 463#: extras_topology.xml:1756 extras_topology.xml:1803 extras_topology.xml:1854 464#: extras_topology.xml:1898 extras_topology.xml:1940 extras_topology.xml:1982 465#: extras_topology.xml:2032 extras_topology.xml:2078 extras_topology.xml:2299 466#: extras_topology.xml:2339 extras_topology.xml:2416 extras_topology.xml:2608 467#: extras_topology.xml:2654 extras_topology.xml:2702 extras_topology.xml:2743 468#: extras_topology.xml:2786 extras_topology.xml:2856 extras_topology.xml:2903 469#: extras_topology.xml:3015 extras_topology.xml:3082 extras_topology.xml:3131 470#: extras_topology.xml:3184 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:650 extras_topology.xml:742 extras_topology.xml:990 684#: extras_topology.xml:1037 extras_topology.xml:1414 extras_topology.xml:1562 685#: extras_topology.xml:1611 extras_topology.xml:1657 extras_topology.xml:1698 686#: extras_topology.xml:1893 extras_topology.xml:1977 extras_topology.xml:2072 687#: extras_topology.xml:2507 extras_topology.xml:2851 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:700 extras_topology.xml:838 955#: extras_topology.xml:887 extras_topology.xml:936 extras_topology.xml:1751 956#: extras_topology.xml:1800 extras_topology.xml:1849 extras_topology.xml:1935 957#: extras_topology.xml:2138 extras_topology.xml:2241 extras_topology.xml:2294 958#: extras_topology.xml:2335 extras_topology.xml:2411 extras_topology.xml:2649 959#: extras_topology.xml:2898 extras_topology.xml:3010 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:562 1184#, no-c-format 1185msgid "" 1186"This section discusses management of database statistics during topology " 1187"building." 1188msgstr "" 1189 1190#. Tag: title 1191#: extras_topology.xml:568 1192#, no-c-format 1193msgid "Topology Statistics Management" 1194msgstr "" 1195 1196#. Tag: para 1197#: extras_topology.xml:570 1198#, no-c-format 1199msgid "" 1200"Adding elements to a topology triggers many database queries for finding " 1201"existing edges that will be split, adding nodes and updating edges that will " 1202"node with the new linework. For this reason it is useful that statistics " 1203"about the data in the topology tables are up-to-date." 1204msgstr "" 1205 1206#. Tag: para 1207#: extras_topology.xml:578 1208#, no-c-format 1209msgid "" 1210"PostGIS Topology population and editing functions do not automatically " 1211"update the statistics because a updating stats after each and every change " 1212"in a topology would be overkill, so it is the caller's duty to take care of " 1213"that." 1214msgstr "" 1215 1216#. Tag: para 1217#: extras_topology.xml:586 1218#, no-c-format 1219msgid "" 1220"That the statistics updated by autovacuum will NOT be visible to " 1221"transactions which started before autovacuum process completed, so long-" 1222"running transactions will need to run ANALYZE themeselves, to use updated " 1223"statistics." 1224msgstr "" 1225 1226#. Tag: para 1227#: extras_topology.xml:599 1228#, no-c-format 1229msgid "This section covers the topology functions for creating new topologies." 1230msgstr "" 1231 1232#. Tag: title 1233#: extras_topology.xml:602 1234#, no-c-format 1235msgid "Topology Constructors" 1236msgstr "" 1237 1238#. Tag: refname 1239#: extras_topology.xml:606 1240#, no-c-format 1241msgid "CreateTopology" 1242msgstr "CreateTopology" 1243 1244#. Tag: refpurpose 1245#: extras_topology.xml:607 1246#, no-c-format 1247msgid "" 1248"Creates a new topology schema and registers this new schema in the topology." 1249"topology table." 1250msgstr "" 1251 1252#. Tag: funcsynopsis 1253#: extras_topology.xml:611 1254#, no-c-format 1255msgid "" 1256"<funcprototype> <funcdef>integer <function>CreateTopology</function></" 1257"funcdef> <paramdef><type>varchar </type> <parameter>topology_schema_name</" 1258"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>integer " 1259"<function>CreateTopology</function></funcdef> <paramdef><type>varchar </" 1260"type> <parameter>topology_schema_name</parameter></paramdef> " 1261"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef> </" 1262"funcprototype> <funcprototype> <funcdef>integer <function>CreateTopology</" 1263"function></funcdef> <paramdef><type>varchar </type> " 1264"<parameter>topology_schema_name</parameter></paramdef> " 1265"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef> " 1266"<paramdef><type>double precision </type> <parameter>prec</parameter></" 1267"paramdef> </funcprototype> <funcprototype> <funcdef>integer " 1268"<function>CreateTopology</function></funcdef> <paramdef><type>varchar </" 1269"type> <parameter>topology_schema_name</parameter></paramdef> " 1270"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef> " 1271"<paramdef><type>double precision </type> <parameter>prec</parameter></" 1272"paramdef> <paramdef><type>boolean </type> <parameter>hasz</parameter></" 1273"paramdef> </funcprototype>" 1274msgstr "" 1275 1276#. Tag: para 1277#: extras_topology.xml:643 1278#, no-c-format 1279msgid "" 1280"Creates a new schema with name <varname>topology_name</varname> consisting " 1281"of tables (<varname>edge_data</varname>,<varname>face</varname>," 1282"<varname>node</varname>, <varname>relation</varname> and registers this new " 1283"topology in the topology.topology table. It returns the id of the topology " 1284"in the topology table. The srid is the spatial reference identified as " 1285"defined in spatial_ref_sys table for that topology. Topologies must be " 1286"uniquely named. The tolerance is measured in the units of the spatial " 1287"reference system. If the tolerance (<varname>prec</varname>) is not " 1288"specified defaults to 0." 1289msgstr "" 1290 1291#. Tag: para 1292#: extras_topology.xml:647 1293#, no-c-format 1294msgid "" 1295"This is similar to the SQL/MM <xref linkend=\"ST_InitTopoGeo\"/> but a bit " 1296"more functional. <varname>hasz</varname> defaults to false if not specified." 1297msgstr "" 1298 1299#. Tag: para 1300#: extras_topology.xml:656 1301#, no-c-format 1302msgid "" 1303"This example creates a new schema called ma_topo that will store edges, " 1304"faces, and relations in Massachusetts State Plane meters. The tolerance " 1305"represents 1/2 meter since the spatial reference system is a meter based " 1306"spatial reference system" 1307msgstr "" 1308 1309#. Tag: programlisting 1310#: extras_topology.xml:658 1311#, no-c-format 1312msgid "SELECT topology.CreateTopology('ma_topo',26986, 0.5);" 1313msgstr "SELECT topology.CreateTopology('ma_topo',26986, 0.5);" 1314 1315#. Tag: para 1316#: extras_topology.xml:660 1317#, no-c-format 1318msgid "Create Rhode Island topology in State Plane ft" 1319msgstr "" 1320 1321#. Tag: programlisting 1322#: extras_topology.xml:661 1323#, no-c-format 1324msgid "" 1325"SELECT topology.CreateTopology('ri_topo',3438) As topoid;\n" 1326"topoid\n" 1327"------\n" 1328"2" 1329msgstr "" 1330"SELECT topology.CreateTopology('ri_topo',3438) As topoid;\n" 1331"topoid\n" 1332"------\n" 1333"2" 1334 1335#. Tag: para 1336#: extras_topology.xml:668 1337#, no-c-format 1338msgid "" 1339", <xref linkend=\"ST_InitTopoGeo\"/>, <xref linkend=\"Topology_Load_Tiger\"/>" 1340msgstr "" 1341", <xref linkend=\"ST_InitTopoGeo\"/>, <xref linkend=\"Topology_Load_Tiger\"/>" 1342 1343#. Tag: refname 1344#: extras_topology.xml:674 1345#, no-c-format 1346msgid "CopyTopology" 1347msgstr "CopyTopology" 1348 1349#. Tag: refpurpose 1350#: extras_topology.xml:675 1351#, no-c-format 1352msgid "" 1353"Makes a copy of a topology structure (nodes, edges, faces, layers and " 1354"TopoGeometries)." 1355msgstr "" 1356 1357#. Tag: funcprototype 1358#: extras_topology.xml:680 1359#, no-c-format 1360msgid "" 1361"<funcdef>integer <function>CopyTopology</function></funcdef> " 1362"<paramdef><type>varchar </type> <parameter>existing_topology_name</" 1363"parameter></paramdef> <paramdef><type>varchar </type> <parameter>new_name</" 1364"parameter></paramdef>" 1365msgstr "" 1366"<funcdef>integer <function>CopyTopology</function></funcdef> " 1367"<paramdef><type>varchar </type> <parameter>existing_topology_name</" 1368"parameter></paramdef> <paramdef><type>varchar </type> <parameter>new_name</" 1369"parameter></paramdef>" 1370 1371#. Tag: para 1372#: extras_topology.xml:691 1373#, no-c-format 1374msgid "" 1375"Creates a new topology with name <varname>new_topology_name</varname> and " 1376"SRID and precision taken from <varname>existing_topology_name</varname>, " 1377"copies all nodes, edges and faces in there, copies layers and their " 1378"TopoGeometries too." 1379msgstr "" 1380 1381#. Tag: para 1382#: extras_topology.xml:695 1383#, no-c-format 1384msgid "" 1385"The new rows in topology.layer will contain synthesized values for " 1386"schema_name, table_name and feature_column. This is because the TopoGeometry " 1387"will only exist as a definition but won't be available in any user-level " 1388"table yet." 1389msgstr "" 1390 1391#. Tag: para 1392#: extras_topology.xml:706 1393#, no-c-format 1394msgid "This example makes a backup of a topology called ma_topo" 1395msgstr "" 1396 1397#. Tag: programlisting 1398#: extras_topology.xml:709 1399#, no-c-format 1400msgid "SELECT topology.CopyTopology('ma_topo', 'ma_topo_bakup');" 1401msgstr "SELECT topology.CopyTopology('ma_topo', 'ma_topo_bakup');" 1402 1403#. Tag: para 1404#: extras_topology.xml:717 extras_topology.xml:2306 1405#, no-c-format 1406msgid ", <xref linkend=\"CreateTopology\"/>" 1407msgstr ", <xref linkend=\"CreateTopology\"/>" 1408 1409#. Tag: refname 1410#: extras_topology.xml:723 1411#, no-c-format 1412msgid "ST_InitTopoGeo" 1413msgstr "" 1414 1415#. Tag: refpurpose 1416#: extras_topology.xml:724 1417#, no-c-format 1418msgid "" 1419"Creates a new topology schema and registers this new schema in the topology." 1420"topology table and details summary of process." 1421msgstr "" 1422 1423#. Tag: funcprototype 1424#: extras_topology.xml:729 1425#, no-c-format 1426msgid "" 1427"<funcdef>text <function>ST_InitTopoGeo</function></funcdef> " 1428"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></" 1429"paramdef>" 1430msgstr "" 1431"<funcdef>text <function>ST_InitTopoGeo</function></funcdef> " 1432"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></" 1433"paramdef>" 1434 1435#. Tag: para 1436#: extras_topology.xml:739 1437#, no-c-format 1438msgid "" 1439"This is an SQL-MM equivalent of CreateTopology but lacks the spatial " 1440"reference and tolerance options of CreateTopology and outputs a text " 1441"description of creation instead of topology id." 1442msgstr "" 1443 1444#. Tag: para 1445#: extras_topology.xml:743 1446#, no-c-format 1447msgid "" 1448"&sqlmm_compliant; SQL-MM 3 Topo-Geo and Topo-Net 3: Routine Details: X.3.17" 1449msgstr "" 1450 1451#. Tag: programlisting 1452#: extras_topology.xml:749 1453#, no-c-format 1454msgid "" 1455"SELECT topology.ST_InitTopoGeo('topo_schema_to_create') AS topocreation;\n" 1456" astopocreation\n" 1457"------------------------------------------------------------\n" 1458" Topology-Geometry 'topo_schema_to_create' (id:7) created." 1459msgstr "" 1460"SELECT topology.ST_InitTopoGeo('topo_schema_to_create') AS topocreation;\n" 1461" astopocreation\n" 1462"------------------------------------------------------------\n" 1463" Topology-Geometry 'topo_schema_to_create' (id:7) created." 1464 1465#. Tag: refname 1466#: extras_topology.xml:763 1467#, no-c-format 1468msgid "ST_CreateTopoGeo" 1469msgstr "ST_CreateTopoGeo" 1470 1471#. Tag: refpurpose 1472#: extras_topology.xml:765 1473#, no-c-format 1474msgid "" 1475"<refpurpose>Adds a collection of geometries to a given empty topology and " 1476"returns a message detailing success.</refpurpose>" 1477msgstr "" 1478 1479#. Tag: funcprototype 1480#: extras_topology.xml:772 1481#, no-c-format 1482msgid "" 1483"<funcdef>text <function>ST_CreateTopoGeo</function></funcdef> " 1484"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1485"<paramdef><type>geometry </type> <parameter>acollection</parameter></" 1486"paramdef>" 1487msgstr "" 1488"<funcdef>text <function>ST_CreateTopoGeo</function></funcdef> " 1489"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1490"<paramdef><type>geometry </type> <parameter>acollection</parameter></" 1491"paramdef>" 1492 1493#. Tag: para 1494#: extras_topology.xml:783 1495#, no-c-format 1496msgid "" 1497"<para>Adds a collection of geometries to a given empty topology and returns " 1498"a message detailing success.</para>" 1499msgstr "" 1500 1501#. Tag: para 1502#: extras_topology.xml:787 1503#, no-c-format 1504msgid "Useful for populating an empty topology." 1505msgstr "" 1506 1507#. Tag: para 1508#: extras_topology.xml:791 extras_topology.xml:1093 extras_topology.xml:1158 1509#: extras_topology.xml:1230 extras_topology.xml:1298 extras_topology.xml:1469 1510#: extras_topology.xml:1519 extras_topology.xml:2026 extras_topology.xml:2192 1511#: extras_topology.xml:2604 1512#, no-c-format 1513msgid "Availability: 2.0" 1514msgstr "Disponibilità: 2.0" 1515 1516#. Tag: para 1517#: extras_topology.xml:792 1518#, no-c-format 1519msgid "" 1520"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details -- X.3.18" 1521msgstr "" 1522 1523#. Tag: programlisting 1524#: extras_topology.xml:798 1525#, no-c-format 1526msgid "" 1527"-- Populate topology --\n" 1528"SELECT topology.ST_CreateTopoGeo('ri_topo',\n" 1529" ST_GeomFromText('MULTILINESTRING((384744 236928,384750 236923,384769 " 1530"236911,384799 236895,384811 236890,384833 236884,\n" 1531" 384844 236882,384866 236881,384879 236883,384954 236898,385087 " 1532"236932,385117 236938,\n" 1533" 385167 236938,385203 236941,385224 236946,385233 236950,385241 " 1534"236956,385254 236971,\n" 1535" 385260 236979,385268 236999,385273 237018,385273 237037,385271 " 1536"237047,385267 237057,\n" 1537" 385225 237125,385210 237144,385192 237161,385167 237192,385162 " 1538"237202,385159 237214,\n" 1539" 385159 237227,385162 237241,385166 237256,385196 237324,385209 " 1540"237345,385234 237375,\n" 1541" 385237 237383,385238 237399,385236 237407,385227 237419,385213 " 1542"237430,385193 237439,\n" 1543" 385174 237451,385170 237455,385169 237460,385171 237475,385181 " 1544"237503,385190 237521,\n" 1545" 385200 237533,385206 237538,385213 237541,385221 237542,385235 " 1546"237540,385242 237541,\n" 1547" 385249 237544,385260 237555,385270 237570,385289 237584,385292 " 1548"237589,385291 237596,385284 237630))',3438)\n" 1549" );\n" 1550"\n" 1551" st_createtopogeo\n" 1552"----------------------------\n" 1553" Topology ri_topo populated\n" 1554"\n" 1555"\n" 1556"-- create tables and topo geometries --\n" 1557"CREATE TABLE ri.roads(gid serial PRIMARY KEY, road_name text);\n" 1558"\n" 1559"SELECT topology.AddTopoGeometryColumn('ri_topo', 'ri', 'roads', 'topo', " 1560"'LINE');" 1561msgstr "" 1562 1563#. Tag: para 1564#: extras_topology.xml:804 1565#, no-c-format 1566msgid ", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"DropTopology\"/>" 1567msgstr ", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"DropTopology\"/>" 1568 1569#. Tag: refname 1570#: extras_topology.xml:810 1571#, no-c-format 1572msgid "TopoGeo_AddPoint" 1573msgstr "TopoGeo_AddPoint" 1574 1575#. Tag: refpurpose 1576#: extras_topology.xml:812 1577#, no-c-format 1578msgid "" 1579"Adds a point to an existing topology using a tolerance and possibly " 1580"splitting an existing edge." 1581msgstr "" 1582 1583#. Tag: funcprototype 1584#: extras_topology.xml:819 1585#, fuzzy, no-c-format 1586msgid "" 1587"<funcdef>integer <function>TopoGeo_AddPoint</function></funcdef> " 1588"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1589"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 1590"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</" 1591"parameter></paramdef>" 1592msgstr "" 1593"<funcdef>integer <function>TopoGeo_AddPoint</function></funcdef> " 1594"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 1595"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 1596"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</" 1597"parameter></paramdef>" 1598 1599#. Tag: para 1600#: extras_topology.xml:831 1601#, no-c-format 1602msgid "" 1603"Adds a point to an existing topology and returns its identifier. The given " 1604"point will snap to existing nodes or edges within given tolerance. An " 1605"existing edge may be split by the snapped point." 1606msgstr "" 1607 1608#. Tag: para 1609#: extras_topology.xml:845 1610#, no-c-format 1611msgid "" 1612", <xref linkend=\"TopoGeo_AddPolygon\"/>, <xref linkend=\"AddNode\"/>, <xref " 1613"linkend=\"CreateTopology\"/>" 1614msgstr "" 1615", <xref linkend=\"TopoGeo_AddPolygon\"/>, <xref linkend=\"AddNode\"/>, <xref " 1616"linkend=\"CreateTopology\"/>" 1617 1618#. Tag: refname 1619#: extras_topology.xml:856 1620#, no-c-format 1621msgid "TopoGeo_AddLineString" 1622msgstr "TopoGeo_AddLineString" 1623 1624#. Tag: refpurpose 1625#: extras_topology.xml:858 1626#, no-c-format 1627msgid "" 1628"Adds a linestring to an existing topology using a tolerance and possibly " 1629"splitting existing edges/faces. Returns edge identifiers." 1630msgstr "" 1631 1632#. Tag: funcprototype 1633#: extras_topology.xml:863 1634#, fuzzy, no-c-format 1635msgid "" 1636"<funcdef>SETOF integer <function>TopoGeo_AddLineString</function></funcdef> " 1637"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1638"<paramdef><type>geometry </type> <parameter>aline</parameter></paramdef> " 1639"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</" 1640"parameter></paramdef>" 1641msgstr "" 1642"<funcdef>integer <function>TopoGeo_AddPoint</function></funcdef> " 1643"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 1644"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 1645"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</" 1646"parameter></paramdef>" 1647 1648#. Tag: para 1649#: extras_topology.xml:875 1650#, no-c-format 1651msgid "" 1652"Adds a linestring to an existing topology and returns a set of edge " 1653"identifiers forming it up. The given line will snap to existing nodes or " 1654"edges within given tolerance. Existing edges and faces may be split by the " 1655"line." 1656msgstr "" 1657 1658#. Tag: para 1659#: extras_topology.xml:881 extras_topology.xml:930 1660#, no-c-format 1661msgid "" 1662"Updating statistics about topologies being loaded via this function is up to " 1663"caller, see <xref linkend=\"Topology_StatsManagement\"/>." 1664msgstr "" 1665 1666#. Tag: para 1667#: extras_topology.xml:894 1668#, no-c-format 1669msgid "" 1670", <xref linkend=\"TopoGeo_AddPolygon\"/>, <xref linkend=\"AddEdge\"/>, <xref " 1671"linkend=\"CreateTopology\"/>" 1672msgstr "" 1673", <xref linkend=\"TopoGeo_AddPolygon\"/>, <xref linkend=\"AddEdge\"/>, <xref " 1674"linkend=\"CreateTopology\"/>" 1675 1676#. Tag: refname 1677#: extras_topology.xml:905 1678#, no-c-format 1679msgid "TopoGeo_AddPolygon" 1680msgstr "TopoGeo_AddPolygon" 1681 1682#. Tag: refpurpose 1683#: extras_topology.xml:907 1684#, no-c-format 1685msgid "" 1686"Adds a polygon to an existing topology using a tolerance and possibly " 1687"splitting existing edges/faces. Returns face identifiers." 1688msgstr "" 1689 1690#. Tag: funcprototype 1691#: extras_topology.xml:912 1692#, fuzzy, no-c-format 1693msgid "" 1694"<funcdef>SETOF integer <function>TopoGeo_AddPolygon</function></funcdef> " 1695"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1696"<paramdef><type>geometry </type> <parameter>apoly</parameter></paramdef> " 1697"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</" 1698"parameter></paramdef>" 1699msgstr "" 1700"<funcdef>integer <function>TopoGeo_AddPoint</function></funcdef> " 1701"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 1702"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 1703"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</" 1704"parameter></paramdef>" 1705 1706#. Tag: para 1707#: extras_topology.xml:924 1708#, no-c-format 1709msgid "" 1710"Adds a polygon to an existing topology and returns a set of face identifiers " 1711"forming it up. The boundary of the given polygon will snap to existing nodes " 1712"or edges within given tolerance. Existing edges and faces may be split by " 1713"the boundary of the new polygon." 1714msgstr "" 1715 1716#. Tag: para 1717#: extras_topology.xml:943 1718#, no-c-format 1719msgid "" 1720", <xref linkend=\"TopoGeo_AddLineString\"/>, <xref linkend=\"AddFace\"/>, " 1721"<xref linkend=\"CreateTopology\"/>" 1722msgstr "" 1723", <xref linkend=\"TopoGeo_AddLineString\"/>, <xref linkend=\"AddFace\"/>, " 1724"<xref linkend=\"CreateTopology\"/>" 1725 1726#. Tag: para 1727#: extras_topology.xml:958 1728#, no-c-format 1729msgid "" 1730"This section covers topology functions for adding, moving, deleting, and " 1731"splitting edges, faces, and nodes. All of these functions are defined by ISO " 1732"SQL/MM." 1733msgstr "" 1734 1735#. Tag: title 1736#: extras_topology.xml:961 1737#, no-c-format 1738msgid "Topology Editors" 1739msgstr "" 1740 1741#. Tag: refname 1742#: extras_topology.xml:965 1743#, no-c-format 1744msgid "ST_AddIsoNode" 1745msgstr "ST_AddIsoNode" 1746 1747#. Tag: refpurpose 1748#: extras_topology.xml:967 1749#, no-c-format 1750msgid "" 1751"Adds an isolated node to a face in a topology and returns the nodeid of the " 1752"new node. If face is null, the node is still created." 1753msgstr "" 1754 1755#. Tag: funcprototype 1756#: extras_topology.xml:972 1757#, no-c-format 1758msgid "" 1759"<funcdef>integer <function>ST_AddIsoNode</function></funcdef> " 1760"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1761"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef> " 1762"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 1763msgstr "" 1764"<funcdef>integer <function>ST_AddIsoNode</function></funcdef> " 1765"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1766"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef> " 1767"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 1768 1769#. Tag: para 1770#: extras_topology.xml:984 1771#, no-c-format 1772msgid "" 1773"Adds an isolated node with point location <varname>apoint</varname> to an " 1774"existing face with faceid <varname>aface</varname> to a topology " 1775"<varname>atopology</varname> and returns the nodeid of the new node." 1776msgstr "" 1777 1778#. Tag: para 1779#: extras_topology.xml:985 1780#, no-c-format 1781msgid "" 1782"If the spatial reference system (srid) of the point geometry is not the same " 1783"as the topology, the <varname>apoint</varname> is not a point geometry, the " 1784"point is null, or the point intersects an existing edge (even at the " 1785"boundaries) then an exception is thrown. If the point already exists as a " 1786"node, an exception is thrown." 1787msgstr "" 1788 1789#. Tag: para 1790#: extras_topology.xml:987 1791#, no-c-format 1792msgid "" 1793"If <varname>aface</varname> is not null and the <varname>apoint</varname> is " 1794"not within the face, then an exception is thrown." 1795msgstr "" 1796 1797#. Tag: para 1798#: extras_topology.xml:991 1799#, no-c-format 1800msgid "&sqlmm_compliant; SQL-MM: Topo-Net Routines: X+1.3.1" 1801msgstr "" 1802 1803#. Tag: para 1804#: extras_topology.xml:1004 1805#, no-c-format 1806msgid "" 1807", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"DropTopology\"/>, " 1808"<xref linkend=\"ST_Intersects\"/>" 1809msgstr "" 1810", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"DropTopology\"/>, " 1811"<xref linkend=\"ST_Intersects\"/>" 1812 1813#. Tag: refname 1814#: extras_topology.xml:1010 1815#, no-c-format 1816msgid "ST_AddIsoEdge" 1817msgstr "ST_AddIsoEdge" 1818 1819#. Tag: refpurpose 1820#: extras_topology.xml:1012 1821#, no-c-format 1822msgid "" 1823"<refpurpose>Adds an isolated edge defined by geometry <varname>alinestring</" 1824"varname> to a topology connecting two existing isolated nodes " 1825"<varname>anode</varname> and <varname>anothernode</varname> and returns the " 1826"edge id of the new edge.</refpurpose>" 1827msgstr "" 1828 1829#. Tag: funcprototype 1830#: extras_topology.xml:1017 1831#, no-c-format 1832msgid "" 1833"<funcdef>integer <function>ST_AddIsoEdge</function></funcdef> " 1834"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1835"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> " 1836"<paramdef><type>integer </type> <parameter>anothernode</parameter></" 1837"paramdef> <paramdef><type>geometry </type> <parameter>alinestring</" 1838"parameter></paramdef>" 1839msgstr "" 1840"<funcdef>integer <function>ST_AddIsoEdge</function></funcdef> " 1841"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1842"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> " 1843"<paramdef><type>integer </type> <parameter>anothernode</parameter></" 1844"paramdef> <paramdef><type>geometry </type> <parameter>alinestring</" 1845"parameter></paramdef>" 1846 1847#. Tag: para 1848#: extras_topology.xml:1030 1849#, no-c-format 1850msgid "" 1851"<para>Adds an isolated edge defined by geometry <varname>alinestring</" 1852"varname> to a topology connecting two existing isolated nodes " 1853"<varname>anode</varname> and <varname>anothernode</varname> and returns the " 1854"edge id of the new edge.</para>" 1855msgstr "" 1856 1857#. Tag: para 1858#: extras_topology.xml:1031 1859#, no-c-format 1860msgid "" 1861"If the spatial reference system (srid) of the <varname>alinestring</varname> " 1862"geometry is not the same as the topology, any of the input arguments are " 1863"null, or the nodes are contained in more than one face, or the nodes are " 1864"start or end nodes of an existing edge, then an exception is thrown." 1865msgstr "" 1866 1867#. Tag: para 1868#: extras_topology.xml:1033 1869#, no-c-format 1870msgid "" 1871"If the <varname>alinestring</varname> is not within the face of the face the " 1872"<varname>anode</varname> and <varname>anothernode</varname> belong to, then " 1873"an exception is thrown." 1874msgstr "" 1875 1876#. Tag: para 1877#: extras_topology.xml:1034 1878#, no-c-format 1879msgid "" 1880"If the <varname>anode</varname> and <varname>anothernode</varname> are not " 1881"the start and end points of the <varname>alinestring</varname> then an " 1882"exception is thrown." 1883msgstr "" 1884 1885#. Tag: para 1886#: extras_topology.xml:1038 1887#, no-c-format 1888msgid "" 1889"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.4" 1890msgstr "" 1891 1892#. Tag: para 1893#: extras_topology.xml:1051 1894#, no-c-format 1895msgid ", <xref linkend=\"ST_IsSimple\"/>, <xref linkend=\"ST_Within\"/>" 1896msgstr ", <xref linkend=\"ST_IsSimple\"/>, <xref linkend=\"ST_Within\"/>" 1897 1898#. Tag: refname 1899#: extras_topology.xml:1057 1900#, no-c-format 1901msgid "ST_AddEdgeNewFaces" 1902msgstr "ST_AddEdgeNewFaces" 1903 1904#. Tag: refpurpose 1905#: extras_topology.xml:1059 1906#, no-c-format 1907msgid "" 1908"Add a new edge and, if in doing so it splits a face, delete the original " 1909"face and replace it with two new faces." 1910msgstr "" 1911 1912#. Tag: funcprototype 1913#: extras_topology.xml:1064 1914#, no-c-format 1915msgid "" 1916"<funcdef>integer <function>ST_AddEdgeNewFaces</function></funcdef> " 1917"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1918"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> " 1919"<paramdef><type>integer </type> <parameter>anothernode</parameter></" 1920"paramdef> <paramdef><type>geometry </type> <parameter>acurve</parameter></" 1921"paramdef>" 1922msgstr "" 1923"<funcdef>integer <function>ST_AddEdgeNewFaces</function></funcdef> " 1924"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1925"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> " 1926"<paramdef><type>integer </type> <parameter>anothernode</parameter></" 1927"paramdef> <paramdef><type>geometry </type> <parameter>acurve</parameter></" 1928"paramdef>" 1929 1930#. Tag: para 1931#: extras_topology.xml:1077 1932#, no-c-format 1933msgid "" 1934"Add a new edge and, if in doing so it splits a face, delete the original " 1935"face and replace it with two new faces. Returns the id of the newly added " 1936"edge." 1937msgstr "" 1938 1939#. Tag: para 1940#: extras_topology.xml:1083 extras_topology.xml:1149 extras_topology.xml:1212 1941#: extras_topology.xml:1280 1942#, no-c-format 1943msgid "Updates all existing joined edges and relationships accordingly." 1944msgstr "" 1945 1946#. Tag: para 1947#: extras_topology.xml:1087 extras_topology.xml:1153 1948#, no-c-format 1949msgid "" 1950"If any arguments are null, the given nodes are unknown (must already exist " 1951"in the <varname>node</varname> table of the topology schema) , the " 1952"<varname>acurve</varname> is not a <varname>LINESTRING</varname>, the " 1953"<varname>anode</varname> and <varname>anothernode</varname> are not the " 1954"start and endpoints of <varname>acurve</varname> then an error is thrown." 1955msgstr "" 1956 1957#. Tag: para 1958#: extras_topology.xml:1090 extras_topology.xml:1156 extras_topology.xml:1351 1959#, no-c-format 1960msgid "" 1961"If the spatial reference system (srid) of the <varname>acurve</varname> " 1962"geometry is not the same as the topology an exception is thrown." 1963msgstr "" 1964 1965#. Tag: para 1966#: extras_topology.xml:1094 1967#, no-c-format 1968msgid "" 1969"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.12" 1970msgstr "" 1971 1972#. Tag: refname 1973#: extras_topology.xml:1114 1974#, no-c-format 1975msgid "ST_AddEdgeModFace" 1976msgstr "ST_AddEdgeModFace" 1977 1978#. Tag: refpurpose 1979#: extras_topology.xml:1116 1980#, no-c-format 1981msgid "" 1982"Add a new edge and, if in doing so it splits a face, modify the original " 1983"face and add a new face." 1984msgstr "" 1985 1986#. Tag: funcprototype 1987#: extras_topology.xml:1121 1988#, no-c-format 1989msgid "" 1990"<funcdef>integer <function>ST_AddEdgeModFace</function></funcdef> " 1991"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1992"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> " 1993"<paramdef><type>integer </type> <parameter>anothernode</parameter></" 1994"paramdef> <paramdef><type>geometry </type> <parameter>acurve</parameter></" 1995"paramdef>" 1996msgstr "" 1997"<funcdef>integer <function>ST_AddEdgeModFace</function></funcdef> " 1998"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 1999"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> " 2000"<paramdef><type>integer </type> <parameter>anothernode</parameter></" 2001"paramdef> <paramdef><type>geometry </type> <parameter>acurve</parameter></" 2002"paramdef>" 2003 2004#. Tag: para 2005#: extras_topology.xml:1134 2006#, no-c-format 2007msgid "" 2008"Add a new edge and, if doing so splits a face, modify the original face and " 2009"add a new one." 2010msgstr "" 2011 2012#. Tag: para 2013#: extras_topology.xml:1139 2014#, no-c-format 2015msgid "" 2016"If possible, the new face will be created on left side of the new edge. This " 2017"will not be possible if the face on the left side will need to be the " 2018"Universe face (unbounded)." 2019msgstr "" 2020 2021#. Tag: para 2022#: extras_topology.xml:1145 2023#, no-c-format 2024msgid "Returns the id of the newly added edge." 2025msgstr "" 2026 2027#. Tag: para 2028#: extras_topology.xml:1159 2029#, no-c-format 2030msgid "" 2031"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.13" 2032msgstr "" 2033 2034#. Tag: refname 2035#: extras_topology.xml:1179 2036#, no-c-format 2037msgid "ST_RemEdgeNewFace" 2038msgstr "ST_RemEdgeNewFace" 2039 2040#. Tag: refpurpose 2041#: extras_topology.xml:1181 2042#, no-c-format 2043msgid "" 2044"<refpurpose>Removes an edge and, if the removed edge separated two faces, " 2045"delete the original faces and replace them with a new face.</refpurpose>" 2046msgstr "" 2047 2048#. Tag: funcprototype 2049#: extras_topology.xml:1189 2050#, no-c-format 2051msgid "" 2052"<funcdef>integer <function>ST_RemEdgeNewFace</function></funcdef> " 2053"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2054"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef>" 2055msgstr "" 2056"<funcdef>integer <function>ST_RemEdgeNewFace</function></funcdef> " 2057"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2058"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef>" 2059 2060#. Tag: para 2061#: extras_topology.xml:1200 2062#, no-c-format 2063msgid "" 2064"<para>Removes an edge and, if the removed edge separated two faces, delete " 2065"the original faces and replace them with a new face.</para>" 2066msgstr "" 2067 2068#. Tag: para 2069#: extras_topology.xml:1205 2070#, no-c-format 2071msgid "" 2072"Returns the id of a newly created face or NULL, if no new face is created. " 2073"No new face is created when the removed edge is dangling or isolated or " 2074"confined with the universe face (possibly making the universe flood into the " 2075"face on the other side)." 2076msgstr "" 2077 2078#. Tag: para 2079#: extras_topology.xml:1216 2080#, no-c-format 2081msgid "" 2082"Refuses to remove an edge participating in the definition of an existing " 2083"TopoGeometry. Refuses to heal two faces if any TopoGeometry is defined by " 2084"only one of them (and not the other)." 2085msgstr "" 2086 2087#. Tag: para 2088#: extras_topology.xml:1223 extras_topology.xml:1291 2089#, no-c-format 2090msgid "" 2091"If any arguments are null, the given edge is unknown (must already exist in " 2092"the <varname>edge</varname> table of the topology schema), the topology name " 2093"is invalid then an error is thrown." 2094msgstr "" 2095 2096#. Tag: para 2097#: extras_topology.xml:1231 2098#, no-c-format 2099msgid "" 2100"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.14" 2101msgstr "" 2102 2103#. Tag: refname 2104#: extras_topology.xml:1251 2105#, no-c-format 2106msgid "ST_RemEdgeModFace" 2107msgstr "ST_RemEdgeModFace" 2108 2109#. Tag: refpurpose 2110#: extras_topology.xml:1253 2111#, no-c-format 2112msgid "" 2113"Removes an edge and, if the removed edge separated two faces, delete one of " 2114"the them and modify the other to take the space of both." 2115msgstr "" 2116 2117#. Tag: funcprototype 2118#: extras_topology.xml:1261 2119#, no-c-format 2120msgid "" 2121"<funcdef>integer <function>ST_RemEdgeModFace</function></funcdef> " 2122"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2123"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef>" 2124msgstr "" 2125 2126#. Tag: para 2127#: extras_topology.xml:1272 2128#, no-c-format 2129msgid "" 2130"Removes an edge and, if the removed edge separated two faces, delete one of " 2131"the them and modify the other to take the space of both. Preferentially " 2132"keeps the face on the right, to be symmetric with ST_AddEdgeModFace also " 2133"keeping it. Returns the id of the face remaining in place of the removed " 2134"edge." 2135msgstr "" 2136 2137#. Tag: para 2138#: extras_topology.xml:1284 2139#, no-c-format 2140msgid "" 2141"Refuses to remove an edge partecipating in the definition of an existing " 2142"TopoGeometry. Refuses to heal two faces if any TopoGeometry is defined by " 2143"only one of them (and not the other)." 2144msgstr "" 2145 2146#. Tag: para 2147#: extras_topology.xml:1299 2148#, no-c-format 2149msgid "" 2150"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.15" 2151msgstr "" 2152 2153#. Tag: refname 2154#: extras_topology.xml:1319 2155#, no-c-format 2156msgid "ST_ChangeEdgeGeom" 2157msgstr "ST_ChangeEdgeGeom" 2158 2159#. Tag: refpurpose 2160#: extras_topology.xml:1321 2161#, no-c-format 2162msgid "" 2163"<refpurpose>Changes the shape of an edge without affecting the topology " 2164"structure.</refpurpose>" 2165msgstr "" 2166 2167#. Tag: funcprototype 2168#: extras_topology.xml:1328 2169#, no-c-format 2170msgid "" 2171"<funcdef>integer <function>ST_ChangeEdgeGeom</function></funcdef> " 2172"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2173"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2174"<paramdef><type>geometry </type> <parameter>acurve</parameter></paramdef>" 2175msgstr "" 2176"<funcdef>integer <function>ST_ChangeEdgeGeom</function></funcdef> " 2177"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2178"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2179"<paramdef><type>geometry </type> <parameter>acurve</parameter></paramdef>" 2180 2181#. Tag: para 2182#: extras_topology.xml:1340 2183#, no-c-format 2184msgid "" 2185"<para>Changes the shape of an edge without affecting the topology structure." 2186"</para>" 2187msgstr "" 2188 2189#. Tag: para 2190#: extras_topology.xml:1343 2191#, no-c-format 2192msgid "" 2193"If any arguments are null, the given edge does not exist in the " 2194"<varname>edge</varname> table of the topology schema, the <varname>acurve</" 2195"varname> is not a <varname>LINESTRING</varname>, the <varname>anode</" 2196"varname> and <varname>anothernode</varname> are not the start and endpoints " 2197"of <varname>acurve</varname> or the modification would change the underlying " 2198"topology then an error is thrown." 2199msgstr "" 2200 2201#. Tag: para 2202#: extras_topology.xml:1352 2203#, no-c-format 2204msgid "" 2205"If the new <varname>acurve</varname> is not simple, then an error is thrown." 2206msgstr "" 2207 2208#. Tag: para 2209#: extras_topology.xml:1354 2210#, no-c-format 2211msgid "" 2212"If moving the edge from old to new position would hit an obstacle then an " 2213"error is thrown." 2214msgstr "" 2215 2216#. Tag: para 2217#: extras_topology.xml:1360 extras_topology.xml:3122 extras_topology.xml:3175 2218#, no-c-format 2219msgid "Availability: 1.1.0" 2220msgstr "Disponibilità: 1.1.0" 2221 2222#. Tag: para 2223#: extras_topology.xml:1363 2224#, no-c-format 2225msgid "Enhanced: 2.0.0 adds topological consistency enforcement" 2226msgstr "" 2227 2228#. Tag: para 2229#: extras_topology.xml:1367 2230#, no-c-format 2231msgid "" 2232"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details X.3.6" 2233msgstr "" 2234 2235#. Tag: programlisting 2236#: extras_topology.xml:1373 2237#, no-c-format 2238msgid "" 2239"SELECT topology.ST_ChangeEdgeGeom('ma_topo', 1,\n" 2240" ST_GeomFromText('LINESTRING(227591.9 893900.4,227622.6 " 2241"893844.3,227641.6 893816.6, 227704.5 893778.5)', 26986) );\n" 2242" ----\n" 2243" Edge 1 changed" 2244msgstr "" 2245 2246#. Tag: refname 2247#: extras_topology.xml:1387 2248#, no-c-format 2249msgid "ST_ModEdgeSplit" 2250msgstr "ST_ModEdgeSplit" 2251 2252#. Tag: refpurpose 2253#: extras_topology.xml:1389 2254#, no-c-format 2255msgid "" 2256"Split an edge by creating a new node along an existing edge, modifying the " 2257"original edge and adding a new edge." 2258msgstr "" 2259 2260#. Tag: funcprototype 2261#: extras_topology.xml:1394 2262#, no-c-format 2263msgid "" 2264"<funcdef>integer <function>ST_ModEdgeSplit</function></funcdef> " 2265"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2266"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2267"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 2268msgstr "" 2269 2270#. Tag: para 2271#: extras_topology.xml:1406 2272#, no-c-format 2273msgid "" 2274"Split an edge by creating a new node along an existing edge, modifying the " 2275"original edge and adding a new edge. Updates all existing joined edges and " 2276"relationships accordingly. Returns the identifier of the newly added node." 2277msgstr "" 2278 2279#. Tag: para 2280#: extras_topology.xml:1415 2281#, no-c-format 2282msgid "Changed: 2.0 - In prior versions, this was misnamed ST_ModEdgesSplit" 2283msgstr "" 2284 2285#. Tag: para 2286#: extras_topology.xml:1416 extras_topology.xml:1470 extras_topology.xml:1520 2287#, no-c-format 2288msgid "" 2289"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.9" 2290msgstr "" 2291 2292#. Tag: programlisting 2293#: extras_topology.xml:1422 2294#, no-c-format 2295msgid "" 2296"-- Add an edge --\n" 2297" SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227592 " 2298"893910, 227600 893910)', 26986) ) As edgeid;\n" 2299"\n" 2300"-- edgeid-\n" 2301"3\n" 2302"\n" 2303"\n" 2304"-- Split the edge --\n" 2305"SELECT topology.ST_ModEdgeSplit('ma_topo', 3, " 2306"ST_SetSRID(ST_Point(227594,893910),26986) ) As node_id;\n" 2307" node_id\n" 2308"-------------------------\n" 2309"7" 2310msgstr "" 2311 2312#. Tag: para 2313#: extras_topology.xml:1428 2314#, no-c-format 2315msgid "" 2316", <xref linkend=\"ST_ModEdgeHeal\"/>, <xref linkend=\"ST_NewEdgeHeal\"/>, " 2317"<xref linkend=\"AddEdge\"/>" 2318msgstr "" 2319", <xref linkend=\"ST_ModEdgeHeal\"/>, <xref linkend=\"ST_NewEdgeHeal\"/>, " 2320"<xref linkend=\"AddEdge\"/>" 2321 2322#. Tag: refname 2323#: extras_topology.xml:1439 2324#, no-c-format 2325msgid "ST_ModEdgeHeal" 2326msgstr "ST_ModEdgeHeal" 2327 2328#. Tag: refpurpose 2329#: extras_topology.xml:1441 2330#, no-c-format 2331msgid "" 2332"Heals two edges by deleting the node connecting them, modifying the first " 2333"edge and deleting the second edge. Returns the id of the deleted node." 2334msgstr "" 2335 2336#. Tag: funcprototype 2337#: extras_topology.xml:1449 2338#, no-c-format 2339msgid "" 2340"<funcdef>int <function>ST_ModEdgeHeal</function></funcdef> " 2341"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2342"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2343"<paramdef><type>integer </type> <parameter>anotheredge</parameter></paramdef>" 2344msgstr "" 2345"<funcdef>int <function>ST_ModEdgeHeal</function></funcdef> " 2346"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2347"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2348"<paramdef><type>integer </type> <parameter>anotheredge</parameter></paramdef>" 2349 2350#. Tag: para 2351#: extras_topology.xml:1461 2352#, no-c-format 2353msgid "" 2354"Heals two edges by deleting the node connecting them, modifying the first " 2355"edge and deleting the second edge. Returns the id of the deleted node. " 2356"Updates all existing joined edges and relationships accordingly." 2357msgstr "" 2358 2359#. Tag: refname 2360#: extras_topology.xml:1486 2361#, no-c-format 2362msgid "ST_NewEdgeHeal" 2363msgstr "ST_NewEdgeHeal" 2364 2365#. Tag: refpurpose 2366#: extras_topology.xml:1488 2367#, no-c-format 2368msgid "" 2369"Heals two edges by deleting the node connecting them, deleting both edges, " 2370"and replacing them with an edge whose direction is the same as the first " 2371"edge provided." 2372msgstr "" 2373 2374#. Tag: funcprototype 2375#: extras_topology.xml:1497 2376#, no-c-format 2377msgid "" 2378"<funcdef>int <function>ST_NewEdgeHeal</function></funcdef> " 2379"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2380"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2381"<paramdef><type>integer </type> <parameter>anotheredge</parameter></paramdef>" 2382msgstr "" 2383"<funcdef>int <function>ST_NewEdgeHeal</function></funcdef> " 2384"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2385"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2386"<paramdef><type>integer </type> <parameter>anotheredge</parameter></paramdef>" 2387 2388#. Tag: para 2389#: extras_topology.xml:1509 2390#, no-c-format 2391msgid "" 2392"Heals two edges by deleting the node connecting them, deleting both edges, " 2393"and replacing them with an edge whose direction is the same as the first " 2394"edge provided. Returns the id of the new edge replacing the healed ones. " 2395"Updates all existing joined edges and relationships accordingly." 2396msgstr "" 2397 2398#. Tag: refname 2399#: extras_topology.xml:1537 2400#, no-c-format 2401msgid "ST_MoveIsoNode" 2402msgstr "ST_MoveIsoNode" 2403 2404#. Tag: refpurpose 2405#: extras_topology.xml:1539 2406#, no-c-format 2407msgid "" 2408"Moves an isolated node in a topology from one point to another. If new " 2409"<varname>apoint</varname> geometry exists as a node an error is thrown. " 2410"Returns description of move." 2411msgstr "" 2412 2413#. Tag: funcprototype 2414#: extras_topology.xml:1544 2415#, no-c-format 2416msgid "" 2417"<funcdef>text <function>ST_MoveIsoNode</function></funcdef> " 2418"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2419"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2420"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 2421msgstr "" 2422"<funcdef>text <function>ST_MoveIsoNode</function></funcdef> " 2423"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2424"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2425"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 2426 2427#. Tag: para 2428#: extras_topology.xml:1556 2429#, no-c-format 2430msgid "" 2431"Moves an isolated node in a topology from one point to another. If new " 2432"<varname>apoint</varname> geometry exists as a node an error is thrown." 2433msgstr "" 2434 2435#. Tag: para 2436#: extras_topology.xml:1557 2437#, no-c-format 2438msgid "" 2439"If any arguments are null, the <varname>apoint</varname> is not a point, the " 2440"existing node is not isolated (is a start or end point of an existing edge), " 2441"new node location intersects an existing edge (even at the end points) then " 2442"an exception is thrown." 2443msgstr "" 2444 2445#. Tag: para 2446#: extras_topology.xml:1558 2447#, no-c-format 2448msgid "" 2449"If the spatial reference system (srid) of the point geometry is not the same " 2450"as the topology an exception is thrown." 2451msgstr "" 2452 2453#. Tag: para 2454#: extras_topology.xml:1563 2455#, no-c-format 2456msgid "&sqlmm_compliant; SQL-MM: Topo-Net Routines: X.3.2" 2457msgstr "" 2458 2459#. Tag: programlisting 2460#: extras_topology.xml:1569 2461#, no-c-format 2462msgid "" 2463"-- Add an isolated node with no face --\n" 2464"SELECT topology.ST_AddIsoNode('ma_topo', NULL, " 2465"ST_GeomFromText('POINT(227579 893916)', 26986) ) As nodeid;\n" 2466" nodeid\n" 2467"--------\n" 2468" 7\n" 2469"-- Move the new node --\n" 2470"SELECT topology.ST_MoveIsoNode('ma_topo', 7, " 2471"ST_GeomFromText('POINT(227579.5 893916.5)', 26986) ) As descrip;\n" 2472" descrip\n" 2473"----------------------------------------------------\n" 2474"Isolated Node 7 moved to location 227579.5,893916.5" 2475msgstr "" 2476 2477#. Tag: refname 2478#: extras_topology.xml:1580 2479#, no-c-format 2480msgid "ST_NewEdgesSplit" 2481msgstr "ST_NewEdgesSplit" 2482 2483#. Tag: refpurpose 2484#: extras_topology.xml:1582 2485#, no-c-format 2486msgid "" 2487"Split an edge by creating a new node along an existing edge, deleting the " 2488"original edge and replacing it with two new edges. Returns the id of the new " 2489"node created that joins the new edges." 2490msgstr "" 2491 2492#. Tag: funcprototype 2493#: extras_topology.xml:1587 2494#, no-c-format 2495msgid "" 2496"<funcdef>integer <function>ST_NewEdgesSplit</function></funcdef> " 2497"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2498"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2499"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 2500msgstr "" 2501"<funcdef>integer <function>ST_NewEdgesSplit</function></funcdef> " 2502"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2503"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> " 2504"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>" 2505 2506#. Tag: para 2507#: extras_topology.xml:1599 2508#, no-c-format 2509msgid "" 2510"Split an edge with edge id <varname>anedge</varname> by creating a new node " 2511"with point location <varname>apoint</varname> along current edge, deleting " 2512"the original edge and replacing it with two new edges. Returns the id of the " 2513"new node created that joins the new edges. Updates all existing joined edges " 2514"and relationships accordingly." 2515msgstr "" 2516 2517#. Tag: para 2518#: extras_topology.xml:1607 2519#, no-c-format 2520msgid "" 2521"If the spatial reference system (srid) of the point geometry is not the same " 2522"as the topology, the <varname>apoint</varname> is not a point geometry, the " 2523"point is null, the point already exists as a node, the edge does not " 2524"correspond to an existing edge or the point is not within the edge then an " 2525"exception is thrown." 2526msgstr "" 2527 2528#. Tag: para 2529#: extras_topology.xml:1612 2530#, no-c-format 2531msgid "&sqlmm_compliant; SQL-MM: Topo-Net Routines: X.3.8" 2532msgstr "" 2533 2534#. Tag: programlisting 2535#: extras_topology.xml:1618 2536#, no-c-format 2537msgid "" 2538"-- Add an edge --\n" 2539"SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227575 " 2540"893917,227592 893900)', 26986) ) As edgeid;\n" 2541"-- result-\n" 2542"edgeid\n" 2543"------\n" 2544" 2\n" 2545"-- Split the new edge --\n" 2546"SELECT topology.ST_NewEdgesSplit('ma_topo', 2, " 2547"ST_GeomFromText('POINT(227578.5 893913.5)', 26986) ) As newnodeid;\n" 2548" newnodeid\n" 2549"---------\n" 2550" 6" 2551msgstr "" 2552 2553#. Tag: refname 2554#: extras_topology.xml:1635 2555#, no-c-format 2556msgid "ST_RemoveIsoNode" 2557msgstr "ST_RemoveIsoNode" 2558 2559#. Tag: refpurpose 2560#: extras_topology.xml:1637 2561#, no-c-format 2562msgid "" 2563"<refpurpose>Removes an isolated node and returns description of action. If " 2564"the node is not isolated (is start or end of an edge), then an exception is " 2565"thrown.</refpurpose>" 2566msgstr "" 2567 2568#. Tag: funcprototype 2569#: extras_topology.xml:1642 2570#, no-c-format 2571msgid "" 2572"<funcdef>text <function>ST_RemoveIsoNode</function></funcdef> " 2573"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2574"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef>" 2575msgstr "" 2576"<funcdef>text <function>ST_RemoveIsoNode</function></funcdef> " 2577"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2578"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef>" 2579 2580#. Tag: para 2581#: extras_topology.xml:1653 2582#, no-c-format 2583msgid "" 2584"<para>Removes an isolated node and returns description of action. If the " 2585"node is not isolated (is start or end of an edge), then an exception is " 2586"thrown.</para>" 2587msgstr "" 2588 2589#. Tag: para 2590#: extras_topology.xml:1658 extras_topology.xml:1699 2591#, no-c-format 2592msgid "" 2593"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X+1.3.3" 2594msgstr "" 2595 2596#. Tag: programlisting 2597#: extras_topology.xml:1664 extras_topology.xml:1705 2598#, no-c-format 2599msgid "" 2600"-- Remove an isolated node with no face --\n" 2601"SELECT topology.ST_RemoveIsoNode('ma_topo', 7 ) As result;\n" 2602" result\n" 2603"-------------------------\n" 2604" Isolated node 7 removed" 2605msgstr "" 2606 2607#. Tag: refname 2608#: extras_topology.xml:1676 2609#, no-c-format 2610msgid "ST_RemoveIsoEdge" 2611msgstr "" 2612 2613#. Tag: refpurpose 2614#: extras_topology.xml:1678 2615#, no-c-format 2616msgid "" 2617"<refpurpose>Removes an isolated edge and returns description of action. If " 2618"the edge is not isolated, then an exception is thrown.</refpurpose>" 2619msgstr "" 2620 2621#. Tag: funcprototype 2622#: extras_topology.xml:1683 2623#, no-c-format 2624msgid "" 2625"<funcdef>text <function>ST_RemoveIsoEdge</function></funcdef> " 2626"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2627"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef>" 2628msgstr "" 2629 2630#. Tag: para 2631#: extras_topology.xml:1694 2632#, no-c-format 2633msgid "" 2634"<para>Removes an isolated edge and returns description of action. If the " 2635"edge is not isolated, then an exception is thrown.</para>" 2636msgstr "" 2637 2638#. Tag: title 2639#: extras_topology.xml:1718 2640#, no-c-format 2641msgid "Topology Accessors" 2642msgstr "" 2643 2644#. Tag: refname 2645#: extras_topology.xml:1721 2646#, no-c-format 2647msgid "GetEdgeByPoint" 2648msgstr "GetEdgeByPoint" 2649 2650#. Tag: refpurpose 2651#: extras_topology.xml:1723 2652#, no-c-format 2653msgid "Finds the edge-id of an edge that intersects a given point." 2654msgstr "" 2655 2656#. Tag: funcprototype 2657#: extras_topology.xml:1728 2658#, fuzzy, no-c-format 2659msgid "" 2660"<funcdef>integer <function>GetEdgeByPoint</function></funcdef> " 2661"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2662"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 2663"<paramdef><type>float8 </type> <parameter>tol1</parameter></paramdef>" 2664msgstr "" 2665"<funcdef>integer <function>GetEdgeByPoint</function></funcdef> " 2666"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2667"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 2668"<paramdef><type>float8 </type> <parameter>tol</parameter></paramdef>" 2669 2670#. Tag: para 2671#: extras_topology.xml:1741 2672#, no-c-format 2673msgid "Retrieves the id of an edge that intersects a Point." 2674msgstr "" 2675 2676#. Tag: para 2677#: extras_topology.xml:1742 2678#, no-c-format 2679msgid "" 2680"The function returns an integer (id-edge) given a topology, a POINT and a " 2681"tolerance. If tolerance = 0 then the point has to intersect the edge." 2682msgstr "" 2683 2684#. Tag: para 2685#: extras_topology.xml:1743 2686#, no-c-format 2687msgid "" 2688"If <varname>apoint</varname> doesn't intersect an edge, returns 0 (zero)." 2689msgstr "" 2690 2691#. Tag: para 2692#: extras_topology.xml:1744 2693#, no-c-format 2694msgid "" 2695"If use tolerance > 0 and there is more than one edge near the point then an " 2696"exception is thrown." 2697msgstr "" 2698 2699#. Tag: para 2700#: extras_topology.xml:1748 extras_topology.xml:1797 extras_topology.xml:1846 2701#, no-c-format 2702msgid "" 2703"If tolerance = 0, the function uses ST_Intersects otherwise uses ST_DWithin." 2704msgstr "" 2705 2706#. Tag: para 2707#: extras_topology.xml:1750 extras_topology.xml:1799 extras_topology.xml:1848 2708#: extras_topology.xml:2334 extras_topology.xml:2452 2709#, no-c-format 2710msgid "Performed by the GEOS module." 2711msgstr "Eseguito dal modulo GEOS" 2712 2713#. Tag: para 2714#: extras_topology.xml:1757 extras_topology.xml:1855 2715#, no-c-format 2716msgid "These examples use edges we created in <xref linkend=\"AddEdge\"/>" 2717msgstr "" 2718 2719#. Tag: programlisting 2720#: extras_topology.xml:1758 2721#, no-c-format 2722msgid "" 2723"SELECT topology.GetEdgeByPoint('ma_topo',geom, 1) As with1mtol, topology." 2724"GetEdgeByPoint('ma_topo',geom,0) As withnotol\n" 2725"FROM ST_GeomFromEWKT('SRID=26986;POINT(227622.6 893843)') As geom;\n" 2726" with1mtol | withnotol\n" 2727"-----------+-----------\n" 2728" 2 | 0" 2729msgstr "" 2730"SELECT topology.GetEdgeByPoint('ma_topo',geom, 1) As with1mtol, topology." 2731"GetEdgeByPoint('ma_topo',geom,0) As withnotol\n" 2732"FROM ST_GeomFromEWKT('SRID=26986;POINT(227622.6 893843)') As geom;\n" 2733" with1mtol | withnotol\n" 2734"-----------+-----------\n" 2735" 2 | 0" 2736 2737#. Tag: programlisting 2738#: extras_topology.xml:1759 2739#, no-c-format 2740msgid "" 2741"SELECT topology.GetEdgeByPoint('ma_topo',geom, 1) As nearnode\n" 2742"FROM ST_GeomFromEWKT('SRID=26986;POINT(227591.9 893900.4)') As geom;\n" 2743"\n" 2744"-- get error --\n" 2745"ERROR: Two or more edges found" 2746msgstr "" 2747"SELECT topology.GetEdgeByPoint('ma_topo',geom, 1) As nearnode\n" 2748"FROM ST_GeomFromEWKT('SRID=26986;POINT(227591.9 893900.4)') As geom;\n" 2749"\n" 2750"-- get error --\n" 2751"ERROR: Two or more edges found" 2752 2753#. Tag: para 2754#: extras_topology.xml:1766 2755#, no-c-format 2756msgid "" 2757", <xref linkend=\"GetNodeByPoint\"/>, <xref linkend=\"GetFaceByPoint\"/>" 2758msgstr "" 2759 2760#. Tag: refname 2761#: extras_topology.xml:1776 2762#, no-c-format 2763msgid "GetFaceByPoint" 2764msgstr "GetFaceByPoint" 2765 2766#. Tag: refpurpose 2767#: extras_topology.xml:1777 2768#, no-c-format 2769msgid "Finds the face-id of a face that intersects a given point." 2770msgstr "" 2771 2772#. Tag: funcprototype 2773#: extras_topology.xml:1781 2774#, fuzzy, no-c-format 2775msgid "" 2776"<funcdef>integer <function>GetFaceByPoint</function></funcdef> " 2777"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2778"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 2779"<paramdef><type>float8 </type> <parameter>tol1</parameter></paramdef>" 2780msgstr "" 2781"<funcdef>integer <function>GetFaceByPoint</function></funcdef> " 2782"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2783"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 2784"<paramdef><type>float8 </type> <parameter>tol</parameter></paramdef>" 2785 2786#. Tag: para 2787#: extras_topology.xml:1792 2788#, no-c-format 2789msgid "Retrieves the id of a face that intersects a Point." 2790msgstr "" 2791 2792#. Tag: para 2793#: extras_topology.xml:1793 2794#, no-c-format 2795msgid "" 2796"The function returns an integer (id-face) given a topology, a POINT and a " 2797"tolerance. If tolerance = 0 then the point has to intersect the face." 2798msgstr "" 2799 2800#. Tag: para 2801#: extras_topology.xml:1794 2802#, no-c-format 2803msgid "" 2804"If <varname>apoint</varname> doesn't intersect a face, returns 0 (zero)." 2805msgstr "" 2806 2807#. Tag: para 2808#: extras_topology.xml:1795 2809#, no-c-format 2810msgid "" 2811"If use tolerance > 0 and there is more than one face near the point then an " 2812"exception is thrown." 2813msgstr "" 2814 2815#. Tag: para 2816#: extras_topology.xml:1804 2817#, no-c-format 2818msgid "These examples use edges faces created in <xref linkend=\"AddFace\"/>" 2819msgstr "" 2820 2821#. Tag: programlisting 2822#: extras_topology.xml:1805 2823#, no-c-format 2824msgid "" 2825"SELECT topology.GetFaceByPoint('ma_topo',geom, 10) As with1mtol, topology." 2826"GetFaceByPoint('ma_topo',geom,0) As withnotol\n" 2827" FROM ST_GeomFromEWKT('POINT(234604.6 899382.0)') As geom;\n" 2828"\n" 2829" with1mtol | withnotol\n" 2830" -----------+-----------\n" 2831" 1 | 0" 2832msgstr "" 2833 2834#. Tag: programlisting 2835#: extras_topology.xml:1806 2836#, no-c-format 2837msgid "" 2838"SELECT topology.GetFaceByPoint('ma_topo',geom, 1) As nearnode\n" 2839" FROM ST_GeomFromEWKT('POINT(227591.9 893900.4)') As geom;\n" 2840"\n" 2841"-- get error --\n" 2842"ERROR: Two or more faces found" 2843msgstr "" 2844 2845#. Tag: para 2846#: extras_topology.xml:1811 2847#, no-c-format 2848msgid "" 2849", <xref linkend=\"GetNodeByPoint\"/>, <xref linkend=\"GetEdgeByPoint\"/>" 2850msgstr "" 2851", <xref linkend=\"GetNodeByPoint\"/>, <xref linkend=\"GetEdgeByPoint\"/>" 2852 2853#. Tag: refname 2854#: extras_topology.xml:1821 2855#, no-c-format 2856msgid "GetNodeByPoint" 2857msgstr "GetNodeByPoint" 2858 2859#. Tag: refpurpose 2860#: extras_topology.xml:1823 2861#, no-c-format 2862msgid "Finds the node-id of a node at a point location." 2863msgstr "" 2864 2865#. Tag: funcprototype 2866#: extras_topology.xml:1828 2867#, fuzzy, no-c-format 2868msgid "" 2869"<funcdef>integer <function>GetNodeByPoint</function></funcdef> " 2870"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2871"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 2872"<paramdef><type>float8 </type> <parameter>tol1</parameter></paramdef>" 2873msgstr "" 2874"<funcdef>integer <function>GetNodeByPoint</function></funcdef> " 2875"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 2876"<paramdef><type>geometry </type> <parameter>point</parameter></paramdef> " 2877"<paramdef><type>float8 </type> <parameter>tol</parameter></paramdef>" 2878 2879#. Tag: para 2880#: extras_topology.xml:1841 2881#, no-c-format 2882msgid "Retrieves the id of a node at a point location." 2883msgstr "" 2884 2885#. Tag: para 2886#: extras_topology.xml:1842 2887#, no-c-format 2888msgid "" 2889"The function returns an integer (id-node) given a topology, a POINT and a " 2890"tolerance. If tolerance = 0 means exact intersection, otherwise retrieves " 2891"the node from an interval." 2892msgstr "" 2893 2894#. Tag: para 2895#: extras_topology.xml:1843 2896#, no-c-format 2897msgid "" 2898"If <varname>apoint</varname> doesn't intersect a node, returns 0 (zero)." 2899msgstr "" 2900 2901#. Tag: para 2902#: extras_topology.xml:1844 2903#, no-c-format 2904msgid "" 2905"If use tolerance > 0 and there is more than one node near the point then an " 2906"exception is thrown." 2907msgstr "" 2908 2909#. Tag: programlisting 2910#: extras_topology.xml:1856 2911#, no-c-format 2912msgid "" 2913"SELECT topology.GetNodeByPoint('ma_topo',geom, 1) As nearnode\n" 2914" FROM ST_GeomFromEWKT('SRID=26986;POINT(227591.9 893900.4)') As geom;\n" 2915" nearnode\n" 2916"----------\n" 2917" 2" 2918msgstr "" 2919 2920#. Tag: programlisting 2921#: extras_topology.xml:1857 2922#, no-c-format 2923msgid "" 2924"SELECT topology.GetNodeByPoint('ma_topo',geom, 1000) As too_much_tolerance\n" 2925" FROM ST_GeomFromEWKT('SRID=26986;POINT(227591.9 893900.4)') As geom;\n" 2926"\n" 2927" ----get error--\n" 2928" ERROR: Two or more nodes found" 2929msgstr "" 2930 2931#. Tag: para 2932#: extras_topology.xml:1864 2933#, no-c-format 2934msgid "" 2935", <xref linkend=\"GetEdgeByPoint\"/>, <xref linkend=\"GetFaceByPoint\"/>" 2936msgstr "" 2937 2938#. Tag: refname 2939#: extras_topology.xml:1874 2940#, no-c-format 2941msgid "GetTopologyID" 2942msgstr "GetTopologyID" 2943 2944#. Tag: refpurpose 2945#: extras_topology.xml:1876 2946#, no-c-format 2947msgid "" 2948"<refpurpose>Returns the id of a topology in the topology.topology table " 2949"given the name of the topology.</refpurpose>" 2950msgstr "" 2951 2952#. Tag: funcprototype 2953#: extras_topology.xml:1881 extras_topology.xml:1923 2954#, no-c-format 2955msgid "" 2956"<funcdef>integer <function>GetTopologyID</function></funcdef> " 2957"<paramdef><type>varchar</type> <parameter>toponame</parameter></paramdef>" 2958msgstr "" 2959"<funcdef>integer <function>GetTopologyID</function></funcdef> " 2960"<paramdef><type>varchar</type> <parameter>toponame</parameter></paramdef>" 2961 2962#. Tag: para 2963#: extras_topology.xml:1891 2964#, no-c-format 2965msgid "" 2966"<para>Returns the id of a topology in the topology.topology table given the " 2967"name of the topology.</para>" 2968msgstr "" 2969 2970#. Tag: programlisting 2971#: extras_topology.xml:1899 2972#, no-c-format 2973msgid "" 2974"SELECT topology.GetTopologyID('ma_topo') As topo_id;\n" 2975" topo_id\n" 2976"---------\n" 2977" 1" 2978msgstr "" 2979"SELECT topology.GetTopologyID('ma_topo') As topo_id;\n" 2980" topo_id\n" 2981"---------\n" 2982" 1" 2983 2984#. Tag: para 2985#: extras_topology.xml:1905 2986#, no-c-format 2987msgid "" 2988", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyName\"/>, " 2989"<xref linkend=\"GetTopologySRID\"/>" 2990msgstr "" 2991 2992#. Tag: refname 2993#: extras_topology.xml:1916 2994#, no-c-format 2995msgid "GetTopologySRID" 2996msgstr "GetTopologySRID" 2997 2998#. Tag: refpurpose 2999#: extras_topology.xml:1918 3000#, no-c-format 3001msgid "" 3002"Returns the SRID of a topology in the topology.topology table given the name " 3003"of the topology." 3004msgstr "" 3005 3006#. Tag: para 3007#: extras_topology.xml:1933 3008#, no-c-format 3009msgid "" 3010"Returns the spatial reference id of a topology in the topology.topology " 3011"table given the name of the topology." 3012msgstr "" 3013 3014#. Tag: programlisting 3015#: extras_topology.xml:1941 3016#, no-c-format 3017msgid "" 3018"SELECT topology.GetTopologySRID('ma_topo') As SRID;\n" 3019" SRID\n" 3020"-------\n" 3021" 4326" 3022msgstr "" 3023"SELECT topology.GetTopologySRID('ma_topo') As SRID;\n" 3024" SRID\n" 3025"-------\n" 3026" 4326" 3027 3028#. Tag: para 3029#: extras_topology.xml:1947 3030#, no-c-format 3031msgid "" 3032", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyName\"/>, " 3033"<xref linkend=\"GetTopologyID\"/>" 3034msgstr "" 3035", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyName\"/>, " 3036"<xref linkend=\"GetTopologyID\"/>" 3037 3038#. Tag: refname 3039#: extras_topology.xml:1958 3040#, no-c-format 3041msgid "GetTopologyName" 3042msgstr "GetTopologyName" 3043 3044#. Tag: refpurpose 3045#: extras_topology.xml:1960 3046#, no-c-format 3047msgid "Returns the name of a topology (schema) given the id of the topology." 3048msgstr "" 3049 3050#. Tag: funcprototype 3051#: extras_topology.xml:1965 3052#, no-c-format 3053msgid "" 3054"<funcdef>varchar <function>GetTopologyName</function></funcdef> " 3055"<paramdef><type>integer</type> <parameter>topology_id</parameter></paramdef>" 3056msgstr "" 3057"<funcdef>varchar <function>GetTopologyName</function></funcdef> " 3058"<paramdef><type>integer</type> <parameter>topology_id</parameter></paramdef>" 3059 3060#. Tag: para 3061#: extras_topology.xml:1975 3062#, no-c-format 3063msgid "" 3064"Returns the topology name (schema) of a topology from the topology.topology " 3065"table given the topology id of the topology." 3066msgstr "" 3067 3068#. Tag: programlisting 3069#: extras_topology.xml:1983 3070#, no-c-format 3071msgid "" 3072"SELECT topology.GetTopologyName(1) As topo_name;\n" 3073" topo_name\n" 3074"-----------\n" 3075" ma_topo" 3076msgstr "" 3077"SELECT topology.GetTopologyName(1) As topo_name;\n" 3078" topo_name\n" 3079"-----------\n" 3080" ma_topo" 3081 3082#. Tag: para 3083#: extras_topology.xml:1989 3084#, no-c-format 3085msgid "" 3086", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyID\"/>, <xref " 3087"linkend=\"GetTopologySRID\"/>" 3088msgstr "" 3089", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyID\"/>, <xref " 3090"linkend=\"GetTopologySRID\"/>" 3091 3092#. Tag: refname 3093#: extras_topology.xml:2000 3094#, no-c-format 3095msgid "ST_GetFaceEdges" 3096msgstr "ST_GetFaceEdges" 3097 3098#. Tag: refpurpose 3099#: extras_topology.xml:2002 3100#, no-c-format 3101msgid "Returns a set of ordered edges that bound <varname>aface</varname>." 3102msgstr "" 3103 3104#. Tag: funcprototype 3105#: extras_topology.xml:2007 3106#, no-c-format 3107msgid "" 3108"<funcdef>getfaceedges_returntype <function>ST_GetFaceEdges</function></" 3109"funcdef> <paramdef><type>varchar </type> <parameter>atopology</parameter></" 3110"paramdef> <paramdef><type>integer </type> <parameter>aface</parameter></" 3111"paramdef>" 3112msgstr "" 3113"<funcdef>getfaceedges_returntype <function>ST_GetFaceEdges</function></" 3114"funcdef> <paramdef><type>varchar </type> <parameter>atopology</parameter></" 3115"paramdef> <paramdef><type>integer </type> <parameter>aface</parameter></" 3116"paramdef>" 3117 3118#. Tag: para 3119#: extras_topology.xml:2018 3120#, no-c-format 3121msgid "" 3122"Returns a set of ordered edges that bound <varname>aface</varname>. Each " 3123"output consists of a sequence and edgeid. Sequence numbers start with value " 3124"1." 3125msgstr "" 3126 3127#. Tag: para 3128#: extras_topology.xml:2020 3129#, no-c-format 3130msgid "" 3131"Enumeration of each ring edges start from the edge with smallest identifier. " 3132"Order of edges follows a left-hand-rule (bound face is on the left of each " 3133"directed edge)." 3134msgstr "" 3135 3136#. Tag: para 3137#: extras_topology.xml:2027 3138#, no-c-format 3139msgid "" 3140"&sqlmm_compliant; SQL-MM 3 Topo-Geo and Topo-Net 3: Routine Details: X.3.5" 3141msgstr "" 3142 3143#. Tag: programlisting 3144#: extras_topology.xml:2033 3145#, no-c-format 3146msgid "" 3147"-- Returns the edges bounding face 1\n" 3148"SELECT (topology.ST_GetFaceEdges('tt', 1)).*;\n" 3149"-- result --\n" 3150" sequence | edge\n" 3151"----------+------\n" 3152" 1 | -4\n" 3153" 2 | 5\n" 3154" 3 | 7\n" 3155" 4 | -6\n" 3156" 5 | 1\n" 3157" 6 | 2\n" 3158" 7 | 3\n" 3159"(7 rows)" 3160msgstr "" 3161 3162#. Tag: programlisting 3163#: extras_topology.xml:2034 3164#, no-c-format 3165msgid "" 3166"-- Returns the sequence, edge id\n" 3167"-- and geometry of the edges that bound face 1\n" 3168"-- If you just need geom and seq, can use ST_GetFaceGeometry\n" 3169"SELECT t.seq, t.edge, geom\n" 3170"FROM topology.ST_GetFaceEdges('tt',1) As t(seq,edge)\n" 3171" INNER JOIN tt.edge AS e ON abs(t.edge) = e.edge_id;" 3172msgstr "" 3173 3174#. Tag: para 3175#: extras_topology.xml:2040 3176#, no-c-format 3177msgid ", <xref linkend=\"AddFace\"/>, <xref linkend=\"ST_GetFaceGeometry\"/>" 3178msgstr ", <xref linkend=\"AddFace\"/>, <xref linkend=\"ST_GetFaceGeometry\"/>" 3179 3180#. Tag: refname 3181#: extras_topology.xml:2050 3182#, no-c-format 3183msgid "ST_GetFaceGeometry" 3184msgstr "ST_GetFaceGeometry" 3185 3186#. Tag: refpurpose 3187#: extras_topology.xml:2052 3188#, no-c-format 3189msgid "Returns the polygon in the given topology with the specified face id." 3190msgstr "" 3191 3192#. Tag: funcprototype 3193#: extras_topology.xml:2057 3194#, no-c-format 3195msgid "" 3196"<funcdef>geometry <function>ST_GetFaceGeometry</function></funcdef> " 3197"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3198"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef>" 3199msgstr "" 3200"<funcdef>geometry <function>ST_GetFaceGeometry</function></funcdef> " 3201"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3202"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef>" 3203 3204#. Tag: para 3205#: extras_topology.xml:2068 3206#, no-c-format 3207msgid "" 3208"Returns the polygon in the given topology with the specified face id. Builds " 3209"the polygon from the edges making up the face." 3210msgstr "" 3211 3212#. Tag: para 3213#: extras_topology.xml:2073 3214#, no-c-format 3215msgid "" 3216"&sqlmm_compliant; SQL-MM 3 Topo-Geo and Topo-Net 3: Routine Details: X.3.16" 3217msgstr "" 3218 3219#. Tag: programlisting 3220#: extras_topology.xml:2079 3221#, no-c-format 3222msgid "" 3223"-- Returns the wkt of the polygon added with AddFace\n" 3224"SELECT ST_AsText(topology.ST_GetFaceGeometry('ma_topo', 1)) As facegeomwkt;\n" 3225"-- result --\n" 3226" facegeomwkt\n" 3227"\n" 3228"--------------------------------------------------------------------------------\n" 3229" POLYGON((234776.9 899563.7,234896.5 899456.7,234914 899436.4,234946.6 " 3230"899356.9,\n" 3231"234872.5 899328.7,234891 899285.4,234992.5 899145,234890.6 899069,\n" 3232"234755.2 899255.4,234612.7 899379.4,234776.9 899563.7))" 3233msgstr "" 3234 3235#. Tag: refname 3236#: extras_topology.xml:2091 3237#, no-c-format 3238msgid "GetRingEdges" 3239msgstr "GetRingEdges" 3240 3241#. Tag: refpurpose 3242#: extras_topology.xml:2093 3243#, no-c-format 3244msgid "" 3245"Returns the ordered set of signed edge identifiers met by walking on an a " 3246"given edge side." 3247msgstr "" 3248 3249#. Tag: funcprototype 3250#: extras_topology.xml:2101 3251#, no-c-format 3252msgid "" 3253"<funcdef>getfaceedges_returntype <function>GetRingEdges</function></funcdef> " 3254"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3255"<paramdef><type>integer </type> <parameter>aring</parameter></paramdef> " 3256"<paramdef choice=\"opt\"><type>integer </type> <parameter>max_edges=null</" 3257"parameter></paramdef>" 3258msgstr "" 3259"<funcdef>getfaceedges_returntype <function>GetRingEdges</function></funcdef> " 3260"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3261"<paramdef><type>integer </type> <parameter>aring</parameter></paramdef> " 3262"<paramdef choice=\"opt\"><type>integer </type> <parameter>max_edges=null</" 3263"parameter></paramdef>" 3264 3265#. Tag: para 3266#: extras_topology.xml:2113 3267#, no-c-format 3268msgid "" 3269"Returns the ordered set of signed edge identifiers met by walking on an a " 3270"given edge side. Each output consists of a sequence and a signed edge id. " 3271"Sequence numbers start with value 1." 3272msgstr "" 3273 3274#. Tag: para 3275#: extras_topology.xml:2120 3276#, no-c-format 3277msgid "" 3278"If you pass a positive edge id, the walk starts on the left side of the " 3279"corresponding edge and follows the edge direction. If you pass a negative " 3280"edge id, the walk starts on the right side of it and goes backward." 3281msgstr "" 3282 3283#. Tag: para 3284#: extras_topology.xml:2127 3285#, no-c-format 3286msgid "" 3287"If <varname>max_edges</varname> is not null no more than those records are " 3288"returned by that function. This is meant to be a safety parameter when " 3289"dealing with possibly invalid topologies." 3290msgstr "" 3291 3292#. Tag: para 3293#: extras_topology.xml:2133 3294#, no-c-format 3295msgid "This function uses edge ring linking metadata." 3296msgstr "" 3297 3298#. Tag: para 3299#: extras_topology.xml:2145 3300#, no-c-format 3301msgid ", <xref linkend=\"GetNodeEdges\"/>" 3302msgstr ", <xref linkend=\"GetNodeEdges\"/>" 3303 3304#. Tag: refname 3305#: extras_topology.xml:2154 3306#, no-c-format 3307msgid "GetNodeEdges" 3308msgstr "GetNodeEdges" 3309 3310#. Tag: refpurpose 3311#: extras_topology.xml:2156 3312#, no-c-format 3313msgid "Returns an ordered set of edges incident to the given node." 3314msgstr "" 3315 3316#. Tag: funcprototype 3317#: extras_topology.xml:2163 3318#, no-c-format 3319msgid "" 3320"<funcdef>getfaceedges_returntype <function>GetNodeEdges</function></funcdef> " 3321"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3322"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef>" 3323msgstr "" 3324"<funcdef>getfaceedges_returntype <function>GetNodeEdges</function></funcdef> " 3325"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3326"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef>" 3327 3328#. Tag: para 3329#: extras_topology.xml:2174 3330#, no-c-format 3331msgid "" 3332"Returns an ordered set of edges incident to the given node. Each output " 3333"consists of a sequence and a signed edge id. Sequence numbers start with " 3334"value 1. A positive edge starts at the given node. A negative edge ends into " 3335"the given node. Closed edges will appear twice (with both signs). Order is " 3336"clockwise starting from northbound." 3337msgstr "" 3338 3339#. Tag: para 3340#: extras_topology.xml:2185 3341#, no-c-format 3342msgid "" 3343"This function computes ordering rather than deriving from metadata and is " 3344"thus usable to build edge ring linking." 3345msgstr "" 3346 3347#. Tag: para 3348#: extras_topology.xml:2198 3349#, no-c-format 3350msgid ", <xref linkend=\"ST_Azimuth\"/>" 3351msgstr ", <xref linkend=\"ST_Azimuth\"/>" 3352 3353#. Tag: para 3354#: extras_topology.xml:2211 3355#, no-c-format 3356msgid "" 3357"This section covers the functions for processing topologies in non-standard " 3358"ways." 3359msgstr "" 3360 3361#. Tag: title 3362#: extras_topology.xml:2214 3363#, no-c-format 3364msgid "Topology Processing" 3365msgstr "" 3366 3367#. Tag: refname 3368#: extras_topology.xml:2217 3369#, no-c-format 3370msgid "Polygonize" 3371msgstr "Polygonize" 3372 3373#. Tag: refpurpose 3374#: extras_topology.xml:2218 3375#, no-c-format 3376msgid "Finds and registers all faces defined by topology edges." 3377msgstr "" 3378 3379#. Tag: funcprototype 3380#: extras_topology.xml:2222 3381#, no-c-format 3382msgid "" 3383"<funcdef>text <function>Polygonize</function></funcdef> " 3384"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef>" 3385msgstr "" 3386"<funcdef>text <function>Polygonize</function></funcdef> " 3387"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef>" 3388 3389#. Tag: para 3390#: extras_topology.xml:2232 3391#, no-c-format 3392msgid "Registers all faces that can be built out a topology edge primitives." 3393msgstr "" 3394 3395#. Tag: para 3396#: extras_topology.xml:2233 3397#, no-c-format 3398msgid "The target topology is assumed to contain no self-intersecting edges." 3399msgstr "" 3400 3401#. Tag: para 3402#: extras_topology.xml:2234 3403#, no-c-format 3404msgid "" 3405"Already known faces are recognized, so it is safe to call Polygonize " 3406"multiple times on the same topology." 3407msgstr "" 3408 3409#. Tag: para 3410#: extras_topology.xml:2235 extras_topology.xml:2387 3411#, no-c-format 3412msgid "" 3413"This function does not use nor set the next_left_edge and next_right_edge " 3414"fields of the edge table." 3415msgstr "" 3416 3417#. Tag: para 3418#: extras_topology.xml:2247 3419#, no-c-format 3420msgid ", <xref linkend=\"ST_Polygonize\"/>" 3421msgstr ", <xref linkend=\"ST_Polygonize\"/>" 3422 3423#. Tag: refname 3424#: extras_topology.xml:2253 3425#, no-c-format 3426msgid "AddNode" 3427msgstr "AddNode" 3428 3429#. Tag: refpurpose 3430#: extras_topology.xml:2255 3431#, no-c-format 3432msgid "" 3433"Adds a point node to the node table in the specified topology schema and " 3434"returns the nodeid of new node. If point already exists as node, the " 3435"existing nodeid is returned." 3436msgstr "" 3437 3438#. Tag: funcprototype 3439#: extras_topology.xml:2260 3440#, no-c-format 3441msgid "" 3442"<funcdef>integer <function>AddNode</function></funcdef> " 3443"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 3444"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 3445"<paramdef choice=\"opt\"><type>boolean </type> " 3446"<parameter>allowEdgeSplitting=false</parameter></paramdef> <paramdef choice=" 3447"\"opt\"><type>boolean </type> <parameter>computeContainingFace=false</" 3448"parameter></paramdef>" 3449msgstr "" 3450"<funcdef>integer <function>AddNode</function></funcdef> " 3451"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 3452"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> " 3453"<paramdef choice=\"opt\"><type>boolean </type> " 3454"<parameter>allowEdgeSplitting=false</parameter></paramdef> <paramdef choice=" 3455"\"opt\"><type>boolean </type> <parameter>computeContainingFace=false</" 3456"parameter></paramdef>" 3457 3458#. Tag: para 3459#: extras_topology.xml:2273 3460#, no-c-format 3461msgid "" 3462"Adds a point node to the node table in the specified topology schema. The " 3463"<xref linkend=\"AddEdge\"/> function automatically adds start and end points " 3464"of an edge when called so not necessary to explicitly add nodes of an edge." 3465msgstr "" 3466 3467#. Tag: para 3468#: extras_topology.xml:2280 3469#, no-c-format 3470msgid "" 3471"If any edge crossing the node is found either an exception is raised or the " 3472"edge is split, depending on the <varname>allowEdgeSplitting</varname> " 3473"parameter value." 3474msgstr "" 3475 3476#. Tag: para 3477#: extras_topology.xml:2286 3478#, no-c-format 3479msgid "" 3480"If <varname>computeContainingFace</varname> is true a newly added node would " 3481"get the correct containing face computed." 3482msgstr "" 3483 3484#. Tag: para 3485#: extras_topology.xml:2291 3486#, no-c-format 3487msgid "" 3488"If the <varname>apoint</varname> geometry already exists as a node, the node " 3489"is not added but the existing nodeid is returned." 3490msgstr "" 3491 3492#. Tag: programlisting 3493#: extras_topology.xml:2300 3494#, no-c-format 3495msgid "" 3496"SELECT topology.AddNode('ma_topo', ST_GeomFromText('POINT(227641.6 " 3497"893816.5)', 26986) ) As nodeid;\n" 3498"-- result --\n" 3499"nodeid\n" 3500"--------\n" 3501" 4" 3502msgstr "" 3503"SELECT topology.AddNode('ma_topo', ST_GeomFromText('POINT(227641.6 " 3504"893816.5)', 26986) ) As nodeid;\n" 3505"-- result --\n" 3506"nodeid\n" 3507"--------\n" 3508" 4" 3509 3510#. Tag: refname 3511#: extras_topology.xml:2312 3512#, no-c-format 3513msgid "AddEdge" 3514msgstr "AddEdge" 3515 3516#. Tag: refpurpose 3517#: extras_topology.xml:2314 3518#, no-c-format 3519msgid "" 3520"Adds a linestring edge to the edge table and associated start and end points " 3521"to the point nodes table of the specified topology schema using the " 3522"specified linestring geometry and returns the edgeid of the new (or " 3523"existing) edge." 3524msgstr "" 3525 3526#. Tag: funcprototype 3527#: extras_topology.xml:2319 3528#, no-c-format 3529msgid "" 3530"<funcdef>integer <function>AddEdge</function></funcdef> " 3531"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 3532"<paramdef><type>geometry </type> <parameter>aline</parameter></paramdef>" 3533msgstr "" 3534"<funcdef>integer <function>AddEdge</function></funcdef> " 3535"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 3536"<paramdef><type>geometry </type> <parameter>aline</parameter></paramdef>" 3537 3538#. Tag: para 3539#: extras_topology.xml:2330 3540#, no-c-format 3541msgid "" 3542"Adds an edge to the edge table and associated nodes to the nodes table of " 3543"the specified <varname>toponame</varname> schema using the specified " 3544"linestring geometry and returns the edgeid of the new or existing record. " 3545"The newly added edge has \"universe\" face on both sides and links to itself." 3546msgstr "" 3547 3548#. Tag: para 3549#: extras_topology.xml:2332 3550#, no-c-format 3551msgid "" 3552"If the <varname>aline</varname> geometry crosses, overlaps, contains or is " 3553"contained by an existing linestring edge, then an error is thrown and the " 3554"edge is not added." 3555msgstr "" 3556 3557#. Tag: para 3558#: extras_topology.xml:2333 3559#, no-c-format 3560msgid "" 3561"The geometry of <varname>aline</varname> must have the same <varname>srid</" 3562"varname> as defined for the topology otherwise an invalid spatial reference " 3563"sys error will be thrown." 3564msgstr "" 3565 3566#. Tag: programlisting 3567#: extras_topology.xml:2340 3568#, no-c-format 3569msgid "" 3570"SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227575.8 " 3571"893917.2,227591.9 893900.4)', 26986) ) As edgeid;\n" 3572"-- result-\n" 3573"edgeid\n" 3574"--------\n" 3575" 1\n" 3576"\n" 3577"SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227591.9 " 3578"893900.4,227622.6 893844.2,227641.6 893816.5,\n" 3579" 227704.5 893778.5)', 26986) ) As edgeid;\n" 3580"-- result --\n" 3581"edgeid\n" 3582"--------\n" 3583" 2\n" 3584"\n" 3585" SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227591.2 " 3586"893900, 227591.9 893900.4,\n" 3587" 227704.5 893778.5)', 26986) ) As edgeid;\n" 3588" -- gives error --\n" 3589" ERROR: Edge intersects (not on endpoints) with existing edge 1" 3590msgstr "" 3591 3592#. Tag: para 3593#: extras_topology.xml:2346 extras_topology.xml:2423 3594#, no-c-format 3595msgid "" 3596", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"spatial_ref_sys\"/>" 3597msgstr "" 3598", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"spatial_ref_sys\"/>" 3599 3600#. Tag: refname 3601#: extras_topology.xml:2356 3602#, no-c-format 3603msgid "AddFace" 3604msgstr "AddFace" 3605 3606#. Tag: refpurpose 3607#: extras_topology.xml:2358 3608#, no-c-format 3609msgid "" 3610"<refpurpose>Registers a face primitive to a topology and gets its identifier." 3611"</refpurpose>" 3612msgstr "" 3613 3614#. Tag: funcprototype 3615#: extras_topology.xml:2363 3616#, no-c-format 3617msgid "" 3618"<funcdef>integer <function>AddFace</function></funcdef> " 3619"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 3620"<paramdef><type>geometry </type> <parameter>apolygon</parameter></paramdef> " 3621"<paramdef choice=\"opt\"><type>boolean </type> <parameter>force_new=false</" 3622"parameter></paramdef>" 3623msgstr "" 3624"<funcdef>integer <function>AddFace</function></funcdef> " 3625"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> " 3626"<paramdef><type>geometry </type> <parameter>apolygon</parameter></paramdef> " 3627"<paramdef choice=\"opt\"><type>boolean </type> <parameter>force_new=false</" 3628"parameter></paramdef>" 3629 3630#. Tag: para 3631#: extras_topology.xml:2375 3632#, no-c-format 3633msgid "" 3634"<para>Registers a face primitive to a topology and gets its identifier.</" 3635"para>" 3636msgstr "" 3637 3638#. Tag: para 3639#: extras_topology.xml:2379 3640#, no-c-format 3641msgid "" 3642"For a newly added face, the edges forming its boundaries and the ones " 3643"contained in the face will be updated to have correct values in the " 3644"left_face and right_face fields. Isolated nodes contained in the face will " 3645"also be updated to have a correct containing_face field value." 3646msgstr "" 3647 3648#. Tag: para 3649#: extras_topology.xml:2391 3650#, no-c-format 3651msgid "" 3652"The target topology is assumed to be valid (containing no self-intersecting " 3653"edges). An exception is raised if: The polygon boundary is not fully defined " 3654"by existing edges or the polygon overlaps an existing face." 3655msgstr "" 3656 3657#. Tag: para 3658#: extras_topology.xml:2393 3659#, no-c-format 3660msgid "" 3661"If the <varname>apolygon</varname> geometry already exists as a face, then: " 3662"if <varname>force_new</varname> is false (the default) the face id of the " 3663"existing face is returned; if <varname>force_new</varname> is true a new id " 3664"will be assigned to the newly registered face." 3665msgstr "" 3666 3667#. Tag: para 3668#: extras_topology.xml:2401 3669#, no-c-format 3670msgid "" 3671"When a new registration of an existing face is performed (force_new=true), " 3672"no action will be taken to resolve dangling references to the existing face " 3673"in the edge, node an relation tables, nor will the MBR field of the existing " 3674"face record be updated. It is up to the caller to deal with that." 3675msgstr "" 3676 3677#. Tag: para 3678#: extras_topology.xml:2408 3679#, no-c-format 3680msgid "" 3681"The <varname>apolygon</varname> geometry must have the same <varname>srid</" 3682"varname> as defined for the topology otherwise an invalid spatial reference " 3683"sys error will be thrown." 3684msgstr "" 3685 3686#. Tag: programlisting 3687#: extras_topology.xml:2417 3688#, no-c-format 3689msgid "" 3690"-- first add the edges we use generate_series as an iterator (the below\n" 3691"-- will only work for polygons with < 10000 points because of our max in " 3692"gs)\n" 3693"SELECT topology.AddEdge('ma_topo', ST_MakeLine(ST_PointN(geom,i), " 3694"ST_PointN(geom, i + 1) )) As edgeid\n" 3695" FROM (SELECT ST_NPoints(geom) AS npt, geom\n" 3696" FROM\n" 3697" (SELECT ST_Boundary(ST_GeomFromText('POLYGON((234896.5 " 3698"899456.7,234914 899436.4,234946.6 899356.9,234872.5 899328.7,\n" 3699" 234891 899285.4,234992.5 899145, 234890.6 899069,234755.2 " 3700"899255.4,\n" 3701" 234612.7 899379.4,234776.9 899563.7,234896.5 899456.7))', " 3702"26986) ) As geom\n" 3703" ) As geoms) As facen CROSS JOIN generate_series(1,10000) As i\n" 3704" WHERE i < npt;\n" 3705"-- result --\n" 3706" edgeid\n" 3707"--------\n" 3708" 3\n" 3709" 4\n" 3710" 5\n" 3711" 6\n" 3712" 7\n" 3713" 8\n" 3714" 9\n" 3715" 10\n" 3716" 11\n" 3717" 12\n" 3718"(10 rows)\n" 3719"-- then add the face -\n" 3720"\n" 3721"SELECT topology.AddFace('ma_topo',\n" 3722" ST_GeomFromText('POLYGON((234896.5 899456.7,234914 899436.4,234946.6 " 3723"899356.9,234872.5 899328.7,\n" 3724" 234891 899285.4,234992.5 899145, 234890.6 899069,234755.2 899255.4,\n" 3725" 234612.7 899379.4,234776.9 899563.7,234896.5 899456.7))', 26986) ) As " 3726"faceid;\n" 3727"-- result --\n" 3728"faceid\n" 3729"--------\n" 3730" 1" 3731msgstr "" 3732 3733#. Tag: refname 3734#: extras_topology.xml:2429 3735#, no-c-format 3736msgid "ST_Simplify" 3737msgstr "ST_Simplify" 3738 3739#. Tag: refpurpose 3740#: extras_topology.xml:2430 3741#, no-c-format 3742msgid "" 3743"Returns a \"simplified\" geometry version of the given TopoGeometry using " 3744"the Douglas-Peucker algorithm." 3745msgstr "" 3746 3747#. Tag: funcprototype 3748#: extras_topology.xml:2436 3749#, fuzzy, no-c-format 3750msgid "" 3751"<funcdef>geometry <function>ST_Simplify</function></funcdef> " 3752"<paramdef><type>TopoGeometry</type> <parameter>tg</parameter></paramdef> " 3753"<paramdef><type>float8</type> <parameter>tolerance</parameter></paramdef>" 3754msgstr "" 3755"<funcdef>geometry <function>ST_GetFaceGeometry</function></funcdef> " 3756"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> " 3757"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef>" 3758 3759#. Tag: para 3760#: extras_topology.xml:2446 3761#, no-c-format 3762msgid "" 3763"Returns a \"simplified\" geometry version of the given TopoGeometry using " 3764"the Douglas-Peucker algorithm on each component edge." 3765msgstr "" 3766 3767#. Tag: para 3768#: extras_topology.xml:2449 3769#, no-c-format 3770msgid "The returned geometry may be non-simple or non-valid." 3771msgstr "" 3772 3773#. Tag: para 3774#: extras_topology.xml:2450 3775#, no-c-format 3776msgid "Splitting component edges may help retaining simplicity/validity." 3777msgstr "" 3778 3779#. Tag: para 3780#: extras_topology.xml:2453 extras_topology.xml:3070 3781#, no-c-format 3782msgid "Availability: 2.1.0" 3783msgstr "" 3784 3785#. Tag: para 3786#: extras_topology.xml:2458 3787#, no-c-format 3788msgid "" 3789"Geometry <xref linkend=\"ST_Simplify\"/>, <xref linkend=\"ST_IsSimple\"/>, " 3790"<xref linkend=\"ST_IsValid\"/>, <xref linkend=\"ST_ModEdgeSplit\"/>" 3791msgstr "" 3792 3793#. Tag: para 3794#: extras_topology.xml:2468 3795#, no-c-format 3796msgid "" 3797"This section covers the topology functions for creating new topogeometries." 3798msgstr "" 3799 3800#. Tag: title 3801#: extras_topology.xml:2471 3802#, no-c-format 3803msgid "TopoGeometry Constructors" 3804msgstr "" 3805 3806#. Tag: refname 3807#: extras_topology.xml:2474 3808#, no-c-format 3809msgid "CreateTopoGeom" 3810msgstr "CreateTopoGeom" 3811 3812#. Tag: refpurpose 3813#: extras_topology.xml:2476 3814#, no-c-format 3815msgid "" 3816"Creates a new topo geometry object from topo element array - tg_type: 1:" 3817"[multi]point, 2:[multi]line, 3:[multi]poly, 4:collection" 3818msgstr "" 3819 3820#. Tag: funcsynopsis 3821#: extras_topology.xml:2480 3822#, no-c-format 3823msgid "" 3824"<funcprototype> <funcdef>topogeometry <function>CreateTopoGeom</function></" 3825"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 3826"paramdef> <paramdef><type>integer </type> <parameter>tg_type</parameter></" 3827"paramdef> <paramdef><type>integer</type> <parameter>layer_id</parameter></" 3828"paramdef> <paramdef><type>topoelementarray</type> <parameter>tg_objs</" 3829"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>topogeometry " 3830"<function>CreateTopoGeom</function></funcdef> <paramdef><type>varchar </" 3831"type> <parameter>toponame</parameter></paramdef> <paramdef><type>integer </" 3832"type> <parameter>tg_type</parameter></paramdef> <paramdef><type>integer</" 3833"type> <parameter>layer_id</parameter></paramdef> </funcprototype>" 3834msgstr "" 3835"<funcprototype> <funcdef>topogeometry <function>CreateTopoGeom</function></" 3836"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 3837"paramdef> <paramdef><type>integer </type> <parameter>tg_type</parameter></" 3838"paramdef> <paramdef><type>integer</type> <parameter>layer_id</parameter></" 3839"paramdef> <paramdef><type>topoelementarray</type> <parameter>tg_objs</" 3840"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>topogeometry " 3841"<function>CreateTopoGeom</function></funcdef> <paramdef><type>varchar </" 3842"type> <parameter>toponame</parameter></paramdef> <paramdef><type>integer </" 3843"type> <parameter>tg_type</parameter></paramdef> <paramdef><type>integer</" 3844"type> <parameter>layer_id</parameter></paramdef> </funcprototype>" 3845 3846#. Tag: para 3847#: extras_topology.xml:2501 3848#, no-c-format 3849msgid "" 3850"Creates a topogeometry object for layer denoted by <varname>layer_id</" 3851"varname> and registers it in the relations table in the <varname>toponame</" 3852"varname> schema." 3853msgstr "" 3854 3855#. Tag: para 3856#: extras_topology.xml:2502 3857#, no-c-format 3858msgid "" 3859"<varname>tg_type</varname> is an integer: 1:[multi]point (punctal), 2:" 3860"[multi]line (lineal), 3:[multi]poly (areal), 4:collection. " 3861"<varname>layer_id</varname> is the layer id in the topology.layer table." 3862msgstr "" 3863 3864#. Tag: para 3865#: extras_topology.xml:2503 3866#, no-c-format 3867msgid "" 3868"punctal layers are formed from set of nodes, lineal layers are formed from a " 3869"set of edges, areal layers are formed from a set of faces, and collections " 3870"can be formed from a mixture of nodes, edges, and faces." 3871msgstr "" 3872 3873#. Tag: para 3874#: extras_topology.xml:2505 3875#, no-c-format 3876msgid "" 3877"Omitting the array of components generates an empty TopoGeometry object." 3878msgstr "" 3879 3880#. Tag: title 3881#: extras_topology.xml:2512 3882#, no-c-format 3883msgid "Examples: Form from existing edges" 3884msgstr "" 3885 3886#. Tag: para 3887#: extras_topology.xml:2513 3888#, no-c-format 3889msgid "" 3890"Create a topogeom in ri_topo schema for layer 2 (our ri_roads), of type (2) " 3891"LINE, for the first edge (we loaded in <varname>ST_CreateTopoGeo</varname>)." 3892msgstr "" 3893 3894#. Tag: programlisting 3895#: extras_topology.xml:2514 3896#, no-c-format 3897msgid "" 3898"INSERT INTO ri.ri_roads(road_name, topo) VALUES('Unknown', topology." 3899"CreateTopoGeom('ri_topo',2,2,'{{1,2}}'::topology.topoelementarray);" 3900msgstr "" 3901"INSERT INTO ri.ri_roads(road_name, topo) VALUES('Unknown', topology." 3902"CreateTopoGeom('ri_topo',2,2,'{{1,2}}'::topology.topoelementarray);" 3903 3904#. Tag: title 3905#: extras_topology.xml:2519 3906#, no-c-format 3907msgid "Examples: Convert an areal geometry to best guess topogeometry" 3908msgstr "" 3909 3910#. Tag: para 3911#: extras_topology.xml:2520 3912#, no-c-format 3913msgid "" 3914"Lets say we have geometries that should be formed from a collection of " 3915"faces. We have for example blockgroups table and want to know the topo " 3916"geometry of each block group. If our data was perfectly aligned, we could do " 3917"this:" 3918msgstr "" 3919 3920#. Tag: programlisting 3921#: extras_topology.xml:2522 3922#, no-c-format 3923msgid "" 3924"-- create our topo geometry column --\n" 3925"SELECT topology.AddTopoGeometryColumn(\n" 3926" 'topo_boston',\n" 3927" 'boston', 'blockgroups', 'topo', 'POLYGON');\n" 3928"\n" 3929"-- addtopgeometrycolumn --\n" 3930"1\n" 3931"\n" 3932"-- update our column assuming\n" 3933"-- everything is perfectly aligned with our edges\n" 3934"UPDATE boston.blockgroups AS bg\n" 3935" SET topo = topology.CreateTopoGeom('topo_boston'\n" 3936" ,3,1\n" 3937" , foo.bfaces)\n" 3938"FROM (SELECT b.gid, topology.TopoElementArray_Agg(ARRAY[f.face_id,3]) As " 3939"bfaces\n" 3940" FROM boston.blockgroups As b\n" 3941" INNER JOIN topo_boston.face As f ON b.geom && f.mbr\n" 3942" WHERE ST_Covers(b.geom, topology.ST_GetFaceGeometry('topo_boston', f." 3943"face_id))\n" 3944" GROUP BY b.gid) As foo\n" 3945"WHERE foo.gid = bg.gid;" 3946msgstr "" 3947 3948#. Tag: programlisting 3949#: extras_topology.xml:2524 3950#, no-c-format 3951msgid "" 3952"--the world is rarely perfect allow for some error\n" 3953"--count the face if 50% of it falls\n" 3954"-- within what we think is our blockgroup boundary\n" 3955"UPDATE boston.blockgroups AS bg\n" 3956" SET topo = topology.CreateTopoGeom('topo_boston'\n" 3957" ,3,1\n" 3958" , foo.bfaces)\n" 3959"FROM (SELECT b.gid, topology.TopoElementArray_Agg(ARRAY[f.face_id,3]) As " 3960"bfaces\n" 3961" FROM boston.blockgroups As b\n" 3962" INNER JOIN topo_boston.face As f ON b.geom && f.mbr\n" 3963" WHERE ST_Covers(b.geom, topology.ST_GetFaceGeometry('topo_boston', f." 3964"face_id))\n" 3965" OR\n" 3966" ( ST_Intersects(b.geom, topology.ST_GetFaceGeometry('topo_boston', f." 3967"face_id))\n" 3968" AND ST_Area(ST_Intersection(b.geom, topology." 3969"ST_GetFaceGeometry('topo_boston', f.face_id) ) ) >\n" 3970" ST_Area(topology.ST_GetFaceGeometry('topo_boston', f." 3971"face_id))*0.5\n" 3972" )\n" 3973" GROUP BY b.gid) As foo\n" 3974"WHERE foo.gid = bg.gid;\n" 3975"\n" 3976"-- and if we wanted to convert our topogeometry back\n" 3977"-- to a denormalized geometry aligned with our faces and edges\n" 3978"-- cast the topo to a geometry\n" 3979"-- The really cool thing is my new geometries\n" 3980"-- are now aligned with my tiger street centerlines\n" 3981"UPDATE boston.blockgroups SET new_geom = topo::geometry;" 3982msgstr "" 3983 3984#. Tag: para 3985#: extras_topology.xml:2530 3986#, no-c-format 3987msgid "" 3988", <xref linkend=\"toTopoGeom\"/> <xref linkend=\"ST_CreateTopoGeo\"/>, <xref " 3989"linkend=\"ST_GetFaceGeometry\"/>, <xref linkend=\"topoelementarray\"/>, " 3990"<xref linkend=\"TopoElementArray_Agg\"/>" 3991msgstr "" 3992", <xref linkend=\"toTopoGeom\"/> <xref linkend=\"ST_CreateTopoGeo\"/>, <xref " 3993"linkend=\"ST_GetFaceGeometry\"/>, <xref linkend=\"topoelementarray\"/>, " 3994"<xref linkend=\"TopoElementArray_Agg\"/>" 3995 3996#. Tag: refname 3997#: extras_topology.xml:2543 extras_topology.xml:2802 3998#, no-c-format 3999msgid "toTopoGeom" 4000msgstr "toTopoGeom" 4001 4002#. Tag: refpurpose 4003#: extras_topology.xml:2545 4004#, no-c-format 4005msgid "Converts a simple Geometry into a topo geometry." 4006msgstr "" 4007 4008#. Tag: funcsynopsis 4009#: extras_topology.xml:2549 4010#, no-c-format 4011msgid "" 4012"<funcprototype> <funcdef>topogeometry <function>toTopoGeom</function></" 4013"funcdef> <paramdef><type>geometry </type> <parameter>geom</parameter></" 4014"paramdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 4015"paramdef> <paramdef><type>integer</type> <parameter>layer_id</parameter></" 4016"paramdef> <paramdef choice=\"opt\"><type>float8</type> <parameter>tolerance</" 4017"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>topogeometry " 4018"<function>toTopoGeom</function></funcdef> <paramdef><type>geometry </type> " 4019"<parameter>geom</parameter></paramdef> <paramdef><type>topogeometry </type> " 4020"<parameter>topogeom</parameter></paramdef> <paramdef choice=\"opt" 4021"\"><type>float8</type> <parameter>tolerance</parameter></paramdef> </" 4022"funcprototype>" 4023msgstr "" 4024 4025#. Tag: para 4026#: extras_topology.xml:2570 4027#, no-c-format 4028msgid "Converts a simple Geometry into a <xref linkend=\"topogeometry\"/>." 4029msgstr "" 4030 4031#. Tag: para 4032#: extras_topology.xml:2574 4033#, no-c-format 4034msgid "" 4035"Topological primitives required to represent the input geometry will be " 4036"added to the underlying topology, possibly splitting existing ones, and they " 4037"will be associated with the output TopoGeometry in the <varname>relation</" 4038"varname> table." 4039msgstr "" 4040 4041#. Tag: para 4042#: extras_topology.xml:2581 4043#, no-c-format 4044msgid "" 4045"Existing TopoGeometry objects (with the possible exception of " 4046"<varname>topogeom</varname>, if given) will retain their shapes." 4047msgstr "" 4048 4049#. Tag: para 4050#: extras_topology.xml:2586 4051#, no-c-format 4052msgid "" 4053"When <varname>tolerance</varname> is given it will be used to snap the input " 4054"geometry to existing primitives." 4055msgstr "" 4056 4057#. Tag: para 4058#: extras_topology.xml:2591 4059#, no-c-format 4060msgid "" 4061"In the first form a new TopoGeometry will be created for the given layer " 4062"(<varname>layer_id</varname>) of the given topology (<varname>toponame</" 4063"varname>)." 4064msgstr "" 4065 4066#. Tag: para 4067#: extras_topology.xml:2596 4068#, no-c-format 4069msgid "" 4070"In the second form the primitives resulting from the conversion will be " 4071"added to the pre-existing TopoGeometry (<varname>topogeom</varname>), " 4072"possibly adding space to its final shape. To have the new shape completely " 4073"replace the old one see <xref linkend=\"clearTopoGeom\"/>." 4074msgstr "" 4075 4076#. Tag: para 4077#: extras_topology.xml:2605 4078#, no-c-format 4079msgid "Enhanced: 2.1.0 adds the version taking an existing TopoGeometry." 4080msgstr "" 4081 4082#. Tag: para 4083#: extras_topology.xml:2609 4084#, no-c-format 4085msgid "This is a full self-contained workflow" 4086msgstr "" 4087 4088#. Tag: programlisting 4089#: extras_topology.xml:2610 4090#, no-c-format 4091msgid "" 4092"-- do this if you don't have a topology setup already\n" 4093"-- creates topology not allowing any tolerance\n" 4094"SELECT topology.CreateTopology('topo_boston_test', 2249);\n" 4095"-- create a new table\n" 4096"CREATE TABLE nei_topo(gid serial primary key, nei varchar(30));\n" 4097"--add a topogeometry column to it\n" 4098"SELECT topology.AddTopoGeometryColumn('topo_boston_test', 'public', " 4099"'nei_topo', 'topo', 'MULTIPOLYGON') As new_layer_id;\n" 4100"new_layer_id\n" 4101"-----------\n" 4102"1\n" 4103"\n" 4104"--use new layer id in populating the new topogeometry column\n" 4105"-- we add the topogeoms to the new layer with 0 tolerance\n" 4106"INSERT INTO nei_topo(nei, topo)\n" 4107"SELECT nei, topology.toTopoGeom(geom, 'topo_boston_test', 1)\n" 4108"FROM neighborhoods\n" 4109"WHERE gid BETWEEN 1 and 15;\n" 4110"\n" 4111"--use to verify what has happened --\n" 4112"SELECT * FROM\n" 4113" topology.TopologySummary('topo_boston_test');\n" 4114"\n" 4115"-- summary--\n" 4116"Topology topo_boston_test (5), SRID 2249, precision 0\n" 4117"61 nodes, 87 edges, 35 faces, 15 topogeoms in 1 layers\n" 4118"Layer 1, type Polygonal (3), 15 topogeoms\n" 4119" Deploy: public.nei_topo.topo" 4120msgstr "" 4121 4122#. Tag: programlisting 4123#: extras_topology.xml:2612 4124#, no-c-format 4125msgid "" 4126"-- Shrink all TopoGeometry polygons by 10 meters\n" 4127"UPDATE nei_topo SET topo = ST_Buffer(clearTopoGeom(topo), -10);\n" 4128"\n" 4129"-- Get the no-one-lands left by the above operation\n" 4130"-- I think GRASS calls this \"polygon0 layer\"\n" 4131"SELECT ST_GetFaceGeometry('topo_boston_test', f.face_id)\n" 4132" FROM topo_boston_test.face f\n" 4133" WHERE f.face_id > 0 -- don't consider the universe face\n" 4134" AND NOT EXISTS ( -- check that no TopoGeometry references the face\n" 4135" SELECT * FROM topo_boston_test.relation\n" 4136" WHERE layer_id = 1 AND element_id = f.face_id\n" 4137" );" 4138msgstr "" 4139 4140#. Tag: para 4141#: extras_topology.xml:2618 4142#, no-c-format 4143msgid "" 4144", <xref linkend=\"AddTopoGeometryColumn\"/>, <xref linkend=\"CreateTopoGeom" 4145"\"/>, <xref linkend=\"TopologySummary\"/>, <xref linkend=\"clearTopoGeom\"/>" 4146msgstr "" 4147 4148#. Tag: refname 4149#: extras_topology.xml:2630 4150#, no-c-format 4151msgid "TopoElementArray_Agg" 4152msgstr "TopoElementArray_Agg" 4153 4154#. Tag: refpurpose 4155#: extras_topology.xml:2631 4156#, no-c-format 4157msgid "" 4158"Returns a <varname>topoelementarray</varname> for a set of element_id, type " 4159"arrays (topoelements)." 4160msgstr "" 4161 4162#. Tag: funcprototype 4163#: extras_topology.xml:2636 4164#, no-c-format 4165msgid "" 4166"<funcdef>topoelementarray <function>TopoElementArray_Agg</function></" 4167"funcdef> <paramdef><type>topoelement set</type> <parameter>tefield</" 4168"parameter></paramdef>" 4169msgstr "" 4170"<funcdef>topoelementarray <function>TopoElementArray_Agg</function></" 4171"funcdef> <paramdef><type>topoelement set</type> <parameter>tefield</" 4172"parameter></paramdef>" 4173 4174#. Tag: para 4175#: extras_topology.xml:2646 4176#, no-c-format 4177msgid "" 4178"Used to create a <xref linkend=\"topoelementarray\"/> from a set of <xref " 4179"linkend=\"topoelement\"/>." 4180msgstr "" 4181 4182#. Tag: programlisting 4183#: extras_topology.xml:2655 4184#, no-c-format 4185msgid "" 4186"SELECT topology.TopoElementArray_Agg(ARRAY[e,t]) As tea\n" 4187" FROM generate_series(1,3) As e CROSS JOIN generate_series(1,4) As t;\n" 4188" tea\n" 4189"--------------------------------------------------------------------------\n" 4190"{{1,1},{1,2},{1,3},{1,4},{2,1},{2,2},{2,3},{2,4},{3,1},{3,2},{3,3},{3,4}}" 4191msgstr "" 4192"SELECT topology.TopoElementArray_Agg(ARRAY[e,t]) As tea\n" 4193" FROM generate_series(1,3) As e CROSS JOIN generate_series(1,4) As t;\n" 4194" tea\n" 4195"--------------------------------------------------------------------------\n" 4196"{{1,1},{1,2},{1,3},{1,4},{2,1},{2,2},{2,3},{2,4},{3,1},{3,2},{3,3},{3,4}}" 4197 4198#. Tag: para 4199#: extras_topology.xml:2659 extras_topology.xml:2864 4200#, no-c-format 4201msgid ", <xref linkend=\"topoelementarray\"/>" 4202msgstr "" 4203 4204#. Tag: para 4205#: extras_topology.xml:2667 4206#, no-c-format 4207msgid "" 4208"This section covers the topology functions for editing existing " 4209"topogeometries." 4210msgstr "" 4211 4212#. Tag: title 4213#: extras_topology.xml:2670 4214#, no-c-format 4215msgid "TopoGeometry Editors" 4216msgstr "" 4217 4218#. Tag: refname 4219#: extras_topology.xml:2674 4220#, no-c-format 4221msgid "clearTopoGeom" 4222msgstr "" 4223 4224#. Tag: refpurpose 4225#: extras_topology.xml:2676 4226#, no-c-format 4227msgid "Clears the content of a topo geometry." 4228msgstr "" 4229 4230#. Tag: funcprototype 4231#: extras_topology.xml:2681 4232#, no-c-format 4233msgid "" 4234"<funcdef>topogeometry <function>clearTopoGeom</function></funcdef> " 4235"<paramdef><type>topogeometry </type> <parameter>topogeom</parameter></" 4236"paramdef>" 4237msgstr "" 4238 4239#. Tag: para 4240#: extras_topology.xml:2691 4241#, no-c-format 4242msgid "" 4243"Clears the content a <xref linkend=\"topogeometry\"/> turning it into an " 4244"empty one. Mostly useful in conjunction with <xref linkend=\"toTopoGeom\"/> " 4245"to replace the shape of existing objects and any dependent object in higher " 4246"hierarchical levels." 4247msgstr "" 4248 4249#. Tag: para 4250#: extras_topology.xml:2699 4251#, no-c-format 4252msgid "Availability: 2.1" 4253msgstr "" 4254 4255#. Tag: programlisting 4256#: extras_topology.xml:2703 4257#, no-c-format 4258msgid "" 4259"-- Shrink all TopoGeometry polygons by 10 meters\n" 4260"UPDATE nei_topo SET topo = ST_Buffer(clearTopoGeom(topo), -10);" 4261msgstr "" 4262 4263#. Tag: refname 4264#: extras_topology.xml:2717 4265#, no-c-format 4266msgid "TopoGeom_addElement" 4267msgstr "" 4268 4269#. Tag: refpurpose 4270#: extras_topology.xml:2718 4271#, no-c-format 4272msgid "Adds an element to the definition of a TopoGeometry." 4273msgstr "" 4274 4275#. Tag: funcprototype 4276#: extras_topology.xml:2722 4277#, no-c-format 4278msgid "" 4279"<funcdef>topogeometry <function>TopoGeom_addElement</function></funcdef> " 4280"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4281"<paramdef><type>topoelement </type> <parameter>el</parameter></paramdef>" 4282msgstr "" 4283 4284#. Tag: para 4285#: extras_topology.xml:2733 4286#, no-c-format 4287msgid "" 4288"Adds a <xref linkend=\"topoelement\"/> to the definition of a TopoGeometry " 4289"object. Does not error out if the element is already part of the definition." 4290msgstr "" 4291 4292#. Tag: para 4293#: extras_topology.xml:2740 extras_topology.xml:2783 4294#, no-c-format 4295msgid "Availability: 2.3" 4296msgstr "" 4297 4298#. Tag: programlisting 4299#: extras_topology.xml:2744 4300#, no-c-format 4301msgid "" 4302"-- Add edge 5 to TopoGeometry tg\n" 4303"UPDATE mylayer SET tg = TopoGeom_addElement(tg, '{5,2}');" 4304msgstr "" 4305 4306#. Tag: para 4307#: extras_topology.xml:2750 extras_topology.xml:2793 4308#, no-c-format 4309msgid ", <xref linkend=\"CreateTopoGeom\"/>" 4310msgstr ", <xref linkend=\"CreateTopoGeom\"/>" 4311 4312#. Tag: refname 4313#: extras_topology.xml:2759 4314#, no-c-format 4315msgid "TopoGeom_remElement" 4316msgstr "" 4317 4318#. Tag: refpurpose 4319#: extras_topology.xml:2761 4320#, no-c-format 4321msgid "Removes an element from the definition of a TopoGeometry." 4322msgstr "" 4323 4324#. Tag: funcprototype 4325#: extras_topology.xml:2766 4326#, no-c-format 4327msgid "" 4328"<funcdef>topogeometry <function>TopoGeom_remElement</function></funcdef> " 4329"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4330"<paramdef><type>topoelement </type> <parameter>el</parameter></paramdef>" 4331msgstr "" 4332 4333#. Tag: para 4334#: extras_topology.xml:2777 4335#, no-c-format 4336msgid "" 4337"Removes a <xref linkend=\"topoelement\"/> from the definition of a " 4338"TopoGeometry object." 4339msgstr "" 4340 4341#. Tag: programlisting 4342#: extras_topology.xml:2787 4343#, no-c-format 4344msgid "" 4345"-- Remove face 43 from TopoGeometry tg\n" 4346"UPDATE mylayer SET tg = TopoGeom_remElement(tg, '{43,3}');" 4347msgstr "" 4348 4349#. Tag: refpurpose 4350#: extras_topology.xml:2803 4351#, no-c-format 4352msgid "Adds a geometry shape to an existing topo geometry." 4353msgstr "" 4354 4355#. Tag: para 4356#: extras_topology.xml:2807 4357#, fuzzy, no-c-format 4358msgid "Refer to <xref linkend=\"toTopoGeom\"/>." 4359msgstr ", <xref linkend=\"CreateTopoGeom\"/>" 4360 4361#. Tag: title 4362#: extras_topology.xml:2817 4363#, no-c-format 4364msgid "TopoGeometry Accessors" 4365msgstr "" 4366 4367#. Tag: refname 4368#: extras_topology.xml:2821 4369#, no-c-format 4370msgid "GetTopoGeomElementArray" 4371msgstr "GetTopoGeomElementArray" 4372 4373#. Tag: refpurpose 4374#: extras_topology.xml:2823 4375#, no-c-format 4376msgid "" 4377"Returns a <varname>topoelementarray</varname> (an array of topoelements) " 4378"containing the topological elements and type of the given TopoGeometry " 4379"(primitive elements)." 4380msgstr "" 4381 4382#. Tag: funcprototype 4383#: extras_topology.xml:2828 4384#, no-c-format 4385msgid "" 4386"<funcdef>topoelementarray <function>GetTopoGeomElementArray</function></" 4387"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 4388"paramdef> <paramdef><type>integer </type> <parameter>layer_id</parameter></" 4389"paramdef> <paramdef><type>integer</type> <parameter>tg_id</parameter></" 4390"paramdef>" 4391msgstr "" 4392"<funcdef>topoelementarray <function>GetTopoGeomElementArray</function></" 4393"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 4394"paramdef> <paramdef><type>integer </type> <parameter>layer_id</parameter></" 4395"paramdef> <paramdef><type>integer</type> <parameter>tg_id</parameter></" 4396"paramdef>" 4397 4398#. Tag: funcprototype 4399#: extras_topology.xml:2836 4400#, no-c-format 4401msgid "" 4402"<funcdef>topoelementarray topoelement <function>GetTopoGeomElementArray</" 4403"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4404"parameter></paramdef>" 4405msgstr "" 4406"<funcdef>topoelementarray topoelement <function>GetTopoGeomElementArray</" 4407"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4408"parameter></paramdef>" 4409 4410#. Tag: para 4411#: extras_topology.xml:2846 4412#, no-c-format 4413msgid "" 4414"Returns a <xref linkend=\"topoelementarray\"/> containing the topological " 4415"elements and type of the given TopoGeometry (primitive elements). This is " 4416"similar to GetTopoGeomElements except it returns the elements as an array " 4417"rather than as a dataset." 4418msgstr "" 4419 4420#. Tag: para 4421#: extras_topology.xml:2848 extras_topology.xml:2895 4422#, no-c-format 4423msgid "" 4424"tg_id is the topogeometry id of the topogeometry object in the topology in " 4425"the layer denoted by <varname>layer_id</varname> in the topology.layer table." 4426msgstr "" 4427 4428#. Tag: refname 4429#: extras_topology.xml:2869 4430#, no-c-format 4431msgid "GetTopoGeomElements" 4432msgstr "GetTopoGeomElements" 4433 4434#. Tag: refpurpose 4435#: extras_topology.xml:2871 4436#, no-c-format 4437msgid "" 4438"Returns a set of <varname>topoelement</varname> objects containing the " 4439"topological element_id,element_type of the given TopoGeometry (primitive " 4440"elements)." 4441msgstr "" 4442 4443#. Tag: funcprototype 4444#: extras_topology.xml:2876 4445#, no-c-format 4446msgid "" 4447"<funcdef>setof topoelement <function>GetTopoGeomElements</function></" 4448"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 4449"paramdef> <paramdef><type>integer </type> <parameter>layer_id</parameter></" 4450"paramdef> <paramdef><type>integer</type> <parameter>tg_id</parameter></" 4451"paramdef>" 4452msgstr "" 4453"<funcdef>setof topoelement <function>GetTopoGeomElements</function></" 4454"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></" 4455"paramdef> <paramdef><type>integer </type> <parameter>layer_id</parameter></" 4456"paramdef> <paramdef><type>integer</type> <parameter>tg_id</parameter></" 4457"paramdef>" 4458 4459#. Tag: funcprototype 4460#: extras_topology.xml:2884 4461#, no-c-format 4462msgid "" 4463"<funcdef>setof topoelement <function>GetTopoGeomElements</function></" 4464"funcdef> <paramdef><type>topogeometry </type> <parameter>tg</parameter></" 4465"paramdef>" 4466msgstr "" 4467"<funcdef>setof topoelement <function>GetTopoGeomElements</function></" 4468"funcdef> <paramdef><type>topogeometry </type> <parameter>tg</parameter></" 4469"paramdef>" 4470 4471#. Tag: para 4472#: extras_topology.xml:2894 4473#, no-c-format 4474msgid "" 4475"Returns a set of element_id,element_type (topoelements) for a given " 4476"topogeometry object in <varname>toponame</varname> schema." 4477msgstr "" 4478 4479#. Tag: para 4480#: extras_topology.xml:2911 4481#, no-c-format 4482msgid "" 4483", <xref linkend=\"topoelement\"/>, <xref linkend=\"TopoGeom_addElement\"/>, " 4484"<xref linkend=\"TopoGeom_remElement\"/>" 4485msgstr "" 4486 4487#. Tag: title 4488#: extras_topology.xml:2924 4489#, no-c-format 4490msgid "TopoGeometry Outputs" 4491msgstr "" 4492 4493#. Tag: refname 4494#: extras_topology.xml:2927 4495#, no-c-format 4496msgid "AsGML" 4497msgstr "AsGML" 4498 4499#. Tag: refpurpose 4500#: extras_topology.xml:2929 4501#, no-c-format 4502msgid "Returns the GML representation of a topogeometry." 4503msgstr "" 4504 4505#. Tag: funcsynopsis 4506#: extras_topology.xml:2933 4507#, no-c-format 4508msgid "" 4509"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> " 4510"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> </" 4511"funcprototype> <funcprototype> <funcdef>text <function>AsGML</function></" 4512"funcdef> <paramdef><type>topogeometry </type> <parameter>tg</parameter></" 4513"paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</parameter></" 4514"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</" 4515"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4516"parameter></paramdef> <paramdef><type>regclass </type> " 4517"<parameter>visitedTable</parameter></paramdef> </funcprototype> " 4518"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> " 4519"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4520"<paramdef><type>regclass </type> <parameter>visitedTable</parameter></" 4521"paramdef> <paramdef><type>text </type> <parameter>nsprefix</parameter></" 4522"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</" 4523"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4524"parameter></paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</" 4525"parameter></paramdef> <paramdef><type>integer </type> <parameter>precision</" 4526"parameter></paramdef> <paramdef><type>integer </type> <parameter>options</" 4527"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>text " 4528"<function>AsGML</function></funcdef> <paramdef><type>topogeometry </type> " 4529"<parameter>tg</parameter></paramdef> <paramdef><type>text </type> " 4530"<parameter>nsprefix_in</parameter></paramdef> <paramdef><type>integer </" 4531"type> <parameter>precision</parameter></paramdef> <paramdef><type>integer </" 4532"type> <parameter>options</parameter></paramdef> <paramdef><type>regclass </" 4533"type> <parameter>visitedTable</parameter></paramdef> </funcprototype> " 4534"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> " 4535"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4536"<paramdef><type>text </type> <parameter>nsprefix_in</parameter></paramdef> " 4537"<paramdef><type>integer </type> <parameter>precision</parameter></paramdef> " 4538"<paramdef><type>integer </type> <parameter>options</parameter></paramdef> " 4539"<paramdef><type>regclass </type> <parameter>visitedTable</parameter></" 4540"paramdef> <paramdef><type>text </type> <parameter>idprefix</parameter></" 4541"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</" 4542"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4543"parameter></paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</" 4544"parameter></paramdef> <paramdef><type>integer </type> <parameter>precision</" 4545"parameter></paramdef> <paramdef><type>integer </type> <parameter>options</" 4546"parameter></paramdef> <paramdef><type>regclass </type> " 4547"<parameter>visitedTable</parameter></paramdef> <paramdef><type>text </type> " 4548"<parameter>idprefix</parameter></paramdef> <paramdef><type>int </type> " 4549"<parameter>gmlversion</parameter></paramdef> </funcprototype>" 4550msgstr "" 4551"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> " 4552"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> </" 4553"funcprototype> <funcprototype> <funcdef>text <function>AsGML</function></" 4554"funcdef> <paramdef><type>topogeometry </type> <parameter>tg</parameter></" 4555"paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</parameter></" 4556"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</" 4557"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4558"parameter></paramdef> <paramdef><type>regclass </type> " 4559"<parameter>visitedTable</parameter></paramdef> </funcprototype> " 4560"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> " 4561"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4562"<paramdef><type>regclass </type> <parameter>visitedTable</parameter></" 4563"paramdef> <paramdef><type>text </type> <parameter>nsprefix</parameter></" 4564"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</" 4565"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4566"parameter></paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</" 4567"parameter></paramdef> <paramdef><type>integer </type> <parameter>precision</" 4568"parameter></paramdef> <paramdef><type>integer </type> <parameter>options</" 4569"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>text " 4570"<function>AsGML</function></funcdef> <paramdef><type>topogeometry </type> " 4571"<parameter>tg</parameter></paramdef> <paramdef><type>text </type> " 4572"<parameter>nsprefix_in</parameter></paramdef> <paramdef><type>integer </" 4573"type> <parameter>precision</parameter></paramdef> <paramdef><type>integer </" 4574"type> <parameter>options</parameter></paramdef> <paramdef><type>regclass </" 4575"type> <parameter>visitedTable</parameter></paramdef> </funcprototype> " 4576"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> " 4577"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4578"<paramdef><type>text </type> <parameter>nsprefix_in</parameter></paramdef> " 4579"<paramdef><type>integer </type> <parameter>precision</parameter></paramdef> " 4580"<paramdef><type>integer </type> <parameter>options</parameter></paramdef> " 4581"<paramdef><type>regclass </type> <parameter>visitedTable</parameter></" 4582"paramdef> <paramdef><type>text </type> <parameter>idprefix</parameter></" 4583"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</" 4584"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</" 4585"parameter></paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</" 4586"parameter></paramdef> <paramdef><type>integer </type> <parameter>precision</" 4587"parameter></paramdef> <paramdef><type>integer </type> <parameter>options</" 4588"parameter></paramdef> <paramdef><type>regclass </type> " 4589"<parameter>visitedTable</parameter></paramdef> <paramdef><type>text </type> " 4590"<parameter>idprefix</parameter></paramdef> <paramdef><type>int </type> " 4591"<parameter>gmlversion</parameter></paramdef> </funcprototype>" 4592 4593#. Tag: para 4594#: extras_topology.xml:2994 4595#, no-c-format 4596msgid "" 4597"Returns the GML representation of a topogeometry in version GML3 format. If " 4598"no <varname>nsprefix_in</varname> is specified then <varname>gml</varname> " 4599"is used. Pass in an empty string for nsprefix to get a non-qualified name " 4600"space. The precision (default: 15) and options (default 1) parameters, if " 4601"given, are passed untouched to the underlying call to ST_AsGML." 4602msgstr "" 4603 4604#. Tag: para 4605#: extras_topology.xml:2996 4606#, no-c-format 4607msgid "" 4608"The <varname>visitedTable</varname> parameter, if given, is used for keeping " 4609"track of the visited Node and Edge elements so to use cross-references " 4610"(xlink:xref) rather than duplicating definitions. The table is expected to " 4611"have (at least) two integer fields: 'element_type' and 'element_id'. The " 4612"calling user must have both read and write privileges on the given table. " 4613"For best performance, an index should be defined on <varname>element_type</" 4614"varname> and <varname>element_id</varname>, in that order. Such index would " 4615"be created automatically by adding a unique constraint to the fields. " 4616"Example:" 4617msgstr "" 4618 4619#. Tag: programlisting 4620#: extras_topology.xml:3002 4621#, no-c-format 4622msgid "" 4623"CREATE TABLE visited (\n" 4624" element_type integer, element_id integer,\n" 4625" unique(element_type, element_id)\n" 4626");" 4627msgstr "" 4628"CREATE TABLE visited (\n" 4629" element_type integer, element_id integer,\n" 4630" unique(element_type, element_id)\n" 4631");" 4632 4633#. Tag: para 4634#: extras_topology.xml:3005 4635#, no-c-format 4636msgid "" 4637"The <varname>idprefix</varname> parameter, if given, will be prepended to " 4638"Edge and Node tag identifiers." 4639msgstr "" 4640 4641#. Tag: para 4642#: extras_topology.xml:3007 4643#, no-c-format 4644msgid "" 4645"The <varname>gmlver</varname> parameter, if given, will be passed to the " 4646"underlying ST_AsGML. Defaults to 3." 4647msgstr "" 4648 4649#. Tag: para 4650#: extras_topology.xml:3016 4651#, no-c-format 4652msgid "" 4653"This uses the topo geometry we created in <xref linkend=\"CreateTopoGeom\"/>" 4654msgstr "" 4655 4656#. Tag: programlisting 4657#: extras_topology.xml:3017 4658#, no-c-format 4659msgid "" 4660"SELECT topology.AsGML(topo) As rdgml\n" 4661" FROM ri.roads\n" 4662" WHERE road_name = 'Unknown';\n" 4663"\n" 4664"-- rdgml--\n" 4665"<![CDATA[<gml:TopoCurve>\n" 4666" <gml:directedEdge>\n" 4667" <gml:Edge gml:id=\"E1\">\n" 4668" <gml:directedNode orientation=\"-\">\n" 4669" <gml:Node gml:id=\"N1\"/>\n" 4670" </gml:directedNode>\n" 4671" <gml:directedNode></gml:directedNode>\n" 4672" <gml:curveProperty>\n" 4673" <gml:Curve srsName=\"urn:ogc:def:crs:EPSG::3438\">\n" 4674" <gml:segments>\n" 4675" <gml:LineStringSegment>\n" 4676" <gml:posList srsDimension=\"2\">384744 236928 " 4677"384750 236923 384769 236911 384799 236895 384811 236890\n" 4678" 384833 236884 384844 236882 384866 236881 384879 " 4679"236883 384954 236898 385087 236932 385117 236938\n" 4680" 385167 236938 385203 236941 385224 236946 385233 " 4681"236950 385241 236956 385254 236971\n" 4682" 385260 236979 385268 236999 385273 237018 385273 " 4683"237037 385271 237047 385267 237057 385225 237125\n" 4684" 385210 237144 385192 237161 385167 237192 385162 " 4685"237202 385159 237214 385159 237227 385162 237241\n" 4686" 385166 237256 385196 237324 385209 237345 385234 " 4687"237375 385237 237383 385238 237399 385236 237407\n" 4688" 385227 237419 385213 237430 385193 237439 385174 " 4689"237451 385170 237455 385169 237460 385171 237475\n" 4690" 385181 237503 385190 237521 385200 237533 385206 " 4691"237538 385213 237541 385221 237542 385235 237540 385242 237541\n" 4692" 385249 237544 385260 237555 385270 237570 385289 " 4693"237584 385292 237589 385291 237596 385284 237630</gml:posList>\n" 4694" </gml:LineStringSegment>\n" 4695" </gml:segments>\n" 4696" </gml:Curve>\n" 4697" </gml:curveProperty>\n" 4698" </gml:Edge>\n" 4699" </gml:directedEdge>\n" 4700"</gml:TopoCurve>]]>" 4701msgstr "" 4702 4703#. Tag: para 4704#: extras_topology.xml:3018 4705#, no-c-format 4706msgid "Same exercise as previous without namespace" 4707msgstr "" 4708 4709#. Tag: programlisting 4710#: extras_topology.xml:3019 4711#, no-c-format 4712msgid "" 4713"SELECT topology.AsGML(topo,'') As rdgml\n" 4714" FROM ri.roads\n" 4715" WHERE road_name = 'Unknown';\n" 4716"\n" 4717"-- rdgml--\n" 4718"<![CDATA[<TopoCurve>\n" 4719" <directedEdge>\n" 4720" <Edge id=\"E1\">\n" 4721" <directedNode orientation=\"-\">\n" 4722" <Node id=\"N1\"/>\n" 4723" </directedNode>\n" 4724" <directedNode></directedNode>\n" 4725" <curveProperty>\n" 4726" <Curve srsName=\"urn:ogc:def:crs:EPSG::3438\">\n" 4727" <segments>\n" 4728" <LineStringSegment>\n" 4729" <posList srsDimension=\"2\">384744 236928 384750 " 4730"236923 384769 236911 384799 236895 384811 236890\n" 4731" 384833 236884 384844 236882 384866 236881 384879 " 4732"236883 384954 236898 385087 236932 385117 236938\n" 4733" 385167 236938 385203 236941 385224 236946 385233 " 4734"236950 385241 236956 385254 236971\n" 4735" 385260 236979 385268 236999 385273 237018 385273 " 4736"237037 385271 237047 385267 237057 385225 237125\n" 4737" 385210 237144 385192 237161 385167 237192 385162 " 4738"237202 385159 237214 385159 237227 385162 237241\n" 4739" 385166 237256 385196 237324 385209 237345 385234 " 4740"237375 385237 237383 385238 237399 385236 237407\n" 4741" 385227 237419 385213 237430 385193 237439 385174 " 4742"237451 385170 237455 385169 237460 385171 237475\n" 4743" 385181 237503 385190 237521 385200 237533 385206 " 4744"237538 385213 237541 385221 237542 385235 237540 385242 237541\n" 4745" 385249 237544 385260 237555 385270 237570 385289 " 4746"237584 385292 237589 385291 237596 385284 237630</posList>\n" 4747" </LineStringSegment>\n" 4748" </segments>\n" 4749" </Curve>\n" 4750" </curveProperty>\n" 4751" </Edge>\n" 4752" </directedEdge>\n" 4753"</TopoCurve>]]>" 4754msgstr "" 4755 4756#. Tag: para 4757#: extras_topology.xml:3025 4758#, no-c-format 4759msgid ", <xref linkend=\"ST_CreateTopoGeo\"/>" 4760msgstr ", <xref linkend=\"ST_CreateTopoGeo\"/>" 4761 4762#. Tag: refname 4763#: extras_topology.xml:3030 4764#, no-c-format 4765msgid "AsTopoJSON" 4766msgstr "" 4767 4768#. Tag: refpurpose 4769#: extras_topology.xml:3032 4770#, no-c-format 4771msgid "Returns the TopoJSON representation of a topogeometry." 4772msgstr "" 4773 4774#. Tag: funcprototype 4775#: extras_topology.xml:3037 4776#, no-c-format 4777msgid "" 4778"<funcdef>text <function>AsTopoJSON</function></funcdef> " 4779"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> " 4780"<paramdef><type>regclass </type> <parameter>edgeMapTable</parameter></" 4781"paramdef>" 4782msgstr "" 4783 4784#. Tag: para 4785#: extras_topology.xml:3048 4786#, no-c-format 4787msgid "" 4788"Returns the TopoJSON representation of a topogeometry. If " 4789"<varname>edgeMapTable</varname> is not null, it will be used as a lookup/" 4790"storage mapping of edge identifiers to arc indices. This is to be able to " 4791"allow for a compact \"arcs\" array in the final document." 4792msgstr "" 4793 4794#. Tag: para 4795#: extras_topology.xml:3051 4796#, no-c-format 4797msgid "" 4798"The table, if given, is expected to have an \"arc_id\" field of type \"serial" 4799"\" and an \"edge_id\" of type integer; the code will query the table for " 4800"\"edge_id\" so it is recommended to add an index on that field." 4801msgstr "" 4802 4803#. Tag: para 4804#: extras_topology.xml:3056 4805#, no-c-format 4806msgid "" 4807"Arc indices in the TopoJSON output are 0-based but they are 1-based in the " 4808"\"edgeMapTable\" table." 4809msgstr "" 4810 4811#. Tag: para 4812#: extras_topology.xml:3062 4813#, no-c-format 4814msgid "" 4815"A full TopoJSON document will be need to contain, in addition to the " 4816"snippets returned by this function, the actual arcs plus some headers. See " 4817"the <ulink url=\"http://github.com/mbostock/topojson-specification/blob/" 4818"master/README.md\">TopoJSON specification</ulink>." 4819msgstr "" 4820 4821#. Tag: para 4822#: extras_topology.xml:3071 4823#, no-c-format 4824msgid "Enhanced: 2.2.1 added support for puntal inputs" 4825msgstr "" 4826 4827#. Tag: programlisting 4828#: extras_topology.xml:3083 4829#, no-c-format 4830msgid "" 4831"CREATE TEMP TABLE edgemap(arc_id serial, edge_id int unique);\n" 4832"\n" 4833"-- header\n" 4834"SELECT '{ \"type\": \"Topology\", \"transform\": { \"scale\": [1,1], " 4835"\"translate\": [0,0] }, \"objects\": {'\n" 4836"\n" 4837"-- objects\n" 4838"UNION ALL SELECT '\"' || feature_name || '\": ' || AsTopoJSON(feature, " 4839"'edgemap')\n" 4840"FROM features.big_parcels WHERE feature_name = 'P3P4';\n" 4841"\n" 4842"-- arcs\n" 4843"WITH edges AS (\n" 4844" SELECT m.arc_id, e.geom FROM edgemap m, city_data.edge e\n" 4845" WHERE e.edge_id = m.edge_id\n" 4846"), points AS (\n" 4847" SELECT arc_id, (st_dumppoints(geom)).* FROM edges\n" 4848"), compare AS (\n" 4849" SELECT p2.arc_id,\n" 4850" CASE WHEN p1.path IS NULL THEN p2.geom\n" 4851" ELSE ST_Translate(p2.geom, -ST_X(p1.geom), -ST_Y(p1.geom))\n" 4852" END AS geom\n" 4853" FROM points p2 LEFT OUTER JOIN points p1\n" 4854" ON ( p1.arc_id = p2.arc_id AND p2.path[1] = p1.path[1]+1 )\n" 4855" ORDER BY arc_id, p2.path\n" 4856"), arcsdump AS (\n" 4857" SELECT arc_id, (regexp_matches( ST_AsGeoJSON(geom), '\\[.*\\]'))[1] as t\n" 4858" FROM compare\n" 4859"), arcs AS (\n" 4860" SELECT arc_id, '[' || array_to_string(array_agg(t), ',') || ']' as a FROM " 4861"arcsdump\n" 4862" GROUP BY arc_id\n" 4863" ORDER BY arc_id\n" 4864")\n" 4865"SELECT '}, \"arcs\": [' UNION ALL\n" 4866"SELECT array_to_string(array_agg(a), E',\\n') from arcs\n" 4867"\n" 4868"-- footer\n" 4869"UNION ALL SELECT ']}'::text as t;\n" 4870"\n" 4871"-- Result:\n" 4872"{ \"type\": \"Topology\", \"transform\": { \"scale\": [1,1], \"translate\": " 4873"[0,0] }, \"objects\": {\n" 4874"\"P3P4\": { \"type\": \"MultiPolygon\", \"arcs\": [[[-1]]," 4875"[[6,5,-5,-4,-3,1]]]}\n" 4876"}, \"arcs\": [\n" 4877" [[25,30],[6,0],[0,10],[-14,0],[0,-10],[8,0]],\n" 4878" [[35,6],[0,8]],\n" 4879" [[35,6],[12,0]],\n" 4880" [[47,6],[0,8]],\n" 4881" [[47,14],[0,8]],\n" 4882" [[35,22],[12,0]],\n" 4883" [[35,14],[0,8]]\n" 4884" ]}" 4885msgstr "" 4886 4887#. Tag: para 4888#: extras_topology.xml:3091 4889#, no-c-format 4890msgid "" 4891"This section lists the Topology functions used to check relationships " 4892"between topogeometries and topology primitives" 4893msgstr "" 4894 4895#. Tag: title 4896#: extras_topology.xml:3094 4897#, no-c-format 4898msgid "Topology Spatial Relationships" 4899msgstr "" 4900 4901#. Tag: refname 4902#: extras_topology.xml:3097 4903#, no-c-format 4904msgid "Equals" 4905msgstr "" 4906 4907#. Tag: refpurpose 4908#: extras_topology.xml:3099 4909#, no-c-format 4910msgid "" 4911"Returns true if two topogeometries are composed of the same topology " 4912"primitives." 4913msgstr "" 4914 4915#. Tag: funcprototype 4916#: extras_topology.xml:3104 4917#, no-c-format 4918msgid "" 4919"<funcdef>boolean <function>Equals</function></funcdef> " 4920"<paramdef><type>topogeometry </type> <parameter>tg1</parameter></paramdef> " 4921"<paramdef><type>topogeometry </type> <parameter>tg2</parameter></paramdef>" 4922msgstr "" 4923 4924#. Tag: para 4925#: extras_topology.xml:3115 4926#, no-c-format 4927msgid "" 4928"Returns true if two topogeometries are composed of the same topology " 4929"primitives: faces, edges, nodes." 4930msgstr "" 4931 4932#. Tag: para 4933#: extras_topology.xml:3119 4934#, no-c-format 4935msgid "" 4936"This function not supported for topogeometries that are geometry " 4937"collections. It also can not compare topogeometries from different " 4938"topologies." 4939msgstr "" 4940 4941#. Tag: para 4942#: extras_topology.xml:3126 extras_topology.xml:3179 4943#, no-c-format 4944msgid "&Z_support;" 4945msgstr "&Z_support;" 4946 4947#. Tag: programlisting 4948#: extras_topology.xml:3133 extras_topology.xml:3186 4949#, no-c-format 4950msgid "<!--TODO: Need example -->" 4951msgstr "" 4952 4953#. Tag: para 4954#: extras_topology.xml:3140 4955#, no-c-format 4956msgid ", <xref linkend=\"ST_Equals\"/>" 4957msgstr "" 4958 4959#. Tag: refname 4960#: extras_topology.xml:3146 4961#, no-c-format 4962msgid "Intersects" 4963msgstr "" 4964 4965#. Tag: refpurpose 4966#: extras_topology.xml:3148 4967#, no-c-format 4968msgid "" 4969"<refpurpose>Returns true if any pair of primitives from the two " 4970"topogeometries intersect.</refpurpose>" 4971msgstr "" 4972 4973#. Tag: funcprototype 4974#: extras_topology.xml:3153 4975#, no-c-format 4976msgid "" 4977"<funcdef>boolean <function>Intersects</function></funcdef> " 4978"<paramdef><type>topogeometry </type> <parameter>tg1</parameter></paramdef> " 4979"<paramdef><type>topogeometry </type> <parameter>tg2</parameter></paramdef>" 4980msgstr "" 4981 4982#. Tag: para 4983#: extras_topology.xml:3164 4984#, no-c-format 4985msgid "" 4986"<para>Returns true if any pair of primitives from the two topogeometries " 4987"intersect.</para>" 4988msgstr "" 4989 4990#. Tag: para 4991#: extras_topology.xml:3171 4992#, no-c-format 4993msgid "" 4994"This function not supported for topogeometries that are geometry " 4995"collections. It also can not compare topogeometries from different " 4996"topologies. Also not currently supported for hierarchichal topogeometries " 4997"(topogeometries composed of other topogeometries)." 4998msgstr "" 4999