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