# SOME DESCRIPTIVE TITLE.
#
# Translators:
# pibinko <pibinko@gmail.com>, 2014
# pibinko <pibinko@gmail.com>, 2014
# Sandro Santilli <strk.io>, 2013
# Sandro Santilli <strk@kbt.io>, 2013
# Sandro Santilli <strk@kbt.io>, 2013
msgid ""
msgstr ""
"Project-Id-Version: PostGIS\n"
"Report-Msgid-Bugs-To: http://bugs.kde.org\n"
"POT-Creation-Date: 2019-10-06 23:48+0000\n"
"PO-Revision-Date: 2018-07-23 18:01+0000\n"
"Last-Translator: pibinko <pibinko@gmail.com>\n"
"Language-Team: Italian (Italy) (http://www.transifex.com/postgis/postgis/"
"language/it_IT/)\n"
"Language: it_IT\n"
"MIME-Version: 1.0\n"
"Content-Type: text/plain; charset=UTF-8\n"
"Content-Transfer-Encoding: 8bit\n"
"Plural-Forms: nplurals=2; plural=(n != 1);\n"

#. Tag: title
#: extras_topology.xml:3
#, no-c-format
msgid "Topology"
msgstr "Topologia"

#. Tag: para
#: extras_topology.xml:4
#, no-c-format
msgid ""
"The PostGIS Topology types and functions are used to manage topological "
"objects such as faces, edges and nodes."
msgstr ""
"I tipi e le funzioni della Topologia PostGIS si usano per gestire oggetti "
"topologici quali facce, bordi e nodi."

#. Tag: para
#: extras_topology.xml:5
#, no-c-format
msgid ""
"Sandro Santilli's presentation at PostGIS Day Paris 2011 conference gives a "
"good synopsis of PostGIS Topology and where it is headed <ulink url=\"http://"
"strk.kbt.io/projects/postgis/Paris2011_TopologyWithPostGIS_2_0.pdf"
"\">Topology with PostGIS 2.0 slide deck</ulink>."
msgstr ""

#. Tag: para
#: extras_topology.xml:6
#, no-c-format
msgid ""
"Vincent Picavet provides a good synopsis and overview of what is Topology, "
"how is it used, and various FOSS4G tools that support it in <ulink url="
"\"https://github.com/Oslandia/presentations/blob/master/pgconf_eu_2012/"
"pgconfeu2012_vincent_picavet_postgis_topology.pdf?raw=true\">PostGIS "
"Topology PGConf EU 2012</ulink>."
msgstr ""

#. Tag: para
#: extras_topology.xml:7
#, no-c-format
msgid ""
"An example of a topologically based GIS database is the <ulink url=\"https://"
"www.census.gov/geo/maps-data/data/tiger.html\">US Census Topologically "
"Integrated Geographic Encoding and Referencing System (TIGER)</ulink> "
"database. If you want to experiment with PostGIS topology and need some "
"data, check out <xref linkend=\"Topology_Load_Tiger\"/>."
msgstr ""

#. Tag: para
#: extras_topology.xml:8
#, no-c-format
msgid ""
"The PostGIS topology module has existed in prior versions of PostGIS but was "
"never part of the Official PostGIS documentation. In PostGIS 2.0.0 major "
"cleanup is going on to remove use of all deprecated functions in it, fix "
"known usability issues, better document the features and functions, add new "
"functions, and enhance to closer conform to SQL-MM standards."
msgstr ""
"Il modulo topologico era presente in versioni precedenti di PostGIS ma non "
"era mai stato parte della documentazione ufficiale. A partire da PostGIS "
"2.0.0 e' in corso una ripulitura generale per rimuovere le funzioni "
"deprecate, risolvere noti problemi di usabilita', migliorare la "
"documentazione delle funzioni, aggiungere funzioni e aumentare la "
"conformita' con gli standard SQL-MM."

#. Tag: para
#: extras_topology.xml:10
#, no-c-format
msgid ""
"Details of this project can be found at <ulink url=\"http://trac.osgeo.org/"
"postgis/wiki/UsersWikiPostgisTopology\">PostGIS Topology Wiki</ulink>"
msgstr ""
"Dettagli del progetto si possono trovare sul <ulink url=\"http://trac.osgeo."
"org/postgis/wiki/UsersWikiPostgisTopology\">PostGIS Topology Wiki</ulink>."

#. Tag: para
#: extras_topology.xml:11
#, no-c-format
msgid ""
"All functions and tables associated with this module are installed in a "
"schema called <varname>topology</varname>."
msgstr ""
"Tutte le funzioni e le tabelle associate con questo modulo sono installate "
"in uno schema chiamato <varname>topology</varname>."

#. Tag: para
#: extras_topology.xml:12
#, no-c-format
msgid ""
"Functions that are defined in SQL/MM standard are prefixed with ST_ and "
"functions specific to PostGIS are not prefixed."
msgstr ""
"Le funzioni definite dallo standard SQL/MM hanno il prefisso ST_ e le "
"funzioni specifiche di PostGIS sono senza prefisso."

#. Tag: para
#: extras_topology.xml:13
#, no-c-format
msgid ""
"Topology support is build by default starting with PostGIS 2.0, and can be "
"disabled specifying --without-topology configure option at build time as "
"described in <xref linkend=\"postgis_installation\"/>"
msgstr ""

#. Tag: para
#: extras_topology.xml:18
#, no-c-format
msgid ""
"This section lists the PostgreSQL data types installed by PostGIS Topology. "
"Note we describe the casting behavior of these which is very important "
"especially when designing your own functions."
msgstr ""
"Questa sezione contiene una lista dei tipi di dato PostgreSQL installati "
"dalla Topologia PostGIS. Nota che sono descritti i comportamenti di "
"conversione di questi tipi di dato, informazione molto importante nel "
"progettazione di funzioni proprie."

#. Tag: title
#: extras_topology.xml:23
#, no-c-format
msgid "Topology Types"
msgstr "Tipi di dato topologici"

#. Tag: refname
#: extras_topology.xml:27
#, no-c-format
msgid "getfaceedges_returntype"
msgstr "getfaceedges_returntype"

#. Tag: refpurpose
#: extras_topology.xml:28
#, fuzzy, no-c-format
msgid ""
"A composite type that consists of a sequence number and edge number. This is "
"the return type for <varname>ST_GetFaceEdges</varname>."
msgstr ""
"Un tipo composito che consiste in un numero sequenziale e un numero di "
"\"bordo\". E' il tipo ritornato dalla funzione <varname>ST_GetFaceEdges</"
"varname>."

#. Tag: title
#: extras_topology.xml:31 extras_topology.xml:50 extras_topology.xml:99
#: extras_topology.xml:139 extras_topology.xml:186 extras_topology.xml:263
#: extras_topology.xml:315 extras_topology.xml:357 extras_topology.xml:397
#: extras_topology.xml:438 extras_topology.xml:475 extras_topology.xml:603
#: extras_topology.xml:651 extras_topology.xml:699 extras_topology.xml:743
#: extras_topology.xml:791 extras_topology.xml:835 extras_topology.xml:879
#: extras_topology.xml:934 extras_topology.xml:980 extras_topology.xml:1027
#: extras_topology.xml:1084 extras_topology.xml:1150 extras_topology.xml:1222
#: extras_topology.xml:1290 extras_topology.xml:1356 extras_topology.xml:1411
#: extras_topology.xml:1459 extras_topology.xml:1506 extras_topology.xml:1549
#: extras_topology.xml:1603 extras_topology.xml:1644 extras_topology.xml:1691
#: extras_topology.xml:1742 extras_topology.xml:1791 extras_topology.xml:1841
#: extras_topology.xml:1883 extras_topology.xml:1925 extras_topology.xml:1968
#: extras_topology.xml:2018 extras_topology.xml:2063 extras_topology.xml:2124
#: extras_topology.xml:2182 extras_topology.xml:2223 extras_topology.xml:2280
#: extras_topology.xml:2325 extras_topology.xml:2397 extras_topology.xml:2451
#: extras_topology.xml:2520 extras_topology.xml:2596 extras_topology.xml:2641
#: extras_topology.xml:2683 extras_topology.xml:2727 extras_topology.xml:2758
#: extras_topology.xml:2796 extras_topology.xml:2844 extras_topology.xml:2944
#: extras_topology.xml:2998 extras_topology.xml:3065 extras_topology.xml:3114
#, no-c-format
msgid "Description"
msgstr "Descrizione"

#. Tag: para
#: extras_topology.xml:32
#, no-c-format
msgid ""
"A composite type that consists of a sequence number and edge number. This is "
"the return type for <varname>ST_GetFaceEdges</varname> function."
msgstr ""
"Un tipo composito che consiste in un numero sequenziale e un numero di "
"\"bordo\". E' il tipo ritornato dalla funzione <varname>ST_GetFaceEdges</"
"varname>."

#. Tag: para
#: extras_topology.xml:35
#, no-c-format
msgid ""
"<varname>sequence</varname> is an integer: Refers to a topology defined in "
"the topology.topology table which defines the topology schema and srid."
msgstr ""
"<varname>sequence</varname> e' un intero: si riferisce ad una topologia "
"definita nella tabella topology.topology, che definisce lo schema e lo srid "
"per la topologia."

#. Tag: para
#: extras_topology.xml:38
#, no-c-format
msgid "<varname>edge</varname> is an integer: The identifier of an edge."
msgstr "<varname>edge</varname> e' un intero: l'identificativo di un bordo."

#. Tag: refname
#: extras_topology.xml:46
#, no-c-format
msgid "TopoGeometry"
msgstr ""

#. Tag: refpurpose
#: extras_topology.xml:47
#, no-c-format
msgid "A composite type representing a topologically defined geometry."
msgstr ""

#. Tag: para
#: extras_topology.xml:51
#, no-c-format
msgid ""
"A composite type that refers to a topology geometry in a specific topology "
"layer, having a specific type and a specific id. The elements of a "
"TopoGeometry are the properties: topology_id, layer_id, id integer, type "
"integer."
msgstr ""

#. Tag: para
#: extras_topology.xml:54
#, no-c-format
msgid ""
"<varname>topology_id</varname> is an integer: Refers to a topology defined "
"in the topology.topology table which defines the topology schema and srid."
msgstr ""

#. Tag: para
#: extras_topology.xml:57
#, no-c-format
msgid ""
"<varname>layer_id</varname> is an integer: The layer_id in the layers table "
"that the TopoGeometry belongs to. The combination of topology_id, layer_id "
"provides a unique reference in the topology.layers table."
msgstr ""

#. Tag: para
#: extras_topology.xml:60
#, no-c-format
msgid ""
"<varname>id</varname> is an integer: The id is the autogenerated sequence "
"number that uniquely defines the topogeometry in the respective topology "
"layer."
msgstr ""

#. Tag: para
#: extras_topology.xml:63
#, no-c-format
msgid ""
"<varname>type</varname> integer between 1 - 4 that defines the geometry "
"type: 1:[multi]point, 2:[multi]line, 3:[multi]poly, 4:collection"
msgstr ""

#. Tag: title
#: extras_topology.xml:69
#, no-c-format
msgid "Casting Behavior"
msgstr "Comportamento in caso di CAST"

#. Tag: para
#: extras_topology.xml:70
#, no-c-format
msgid ""
"This section lists the automatic as well as explicit casts allowed for this "
"data type"
msgstr ""
"Questa sezione illustra le modalità di CAST - automatici e espliciti -  "
"permessi per questo tipo di dato"

#. Tag: entry
#: extras_topology.xml:75
#, no-c-format
msgid "Cast To"
msgstr "Cast verso"

#. Tag: entry
#: extras_topology.xml:76
#, no-c-format
msgid "Behavior"
msgstr "Comportamento"

#. Tag: entry
#: extras_topology.xml:79
#, no-c-format
msgid "geometry"
msgstr ""

#. Tag: entry
#: extras_topology.xml:80
#, no-c-format
msgid "automatic"
msgstr "automatico"

#. Tag: title
#: extras_topology.xml:88 extras_topology.xml:117 extras_topology.xml:169
#: extras_topology.xml:196 extras_topology.xml:288 extras_topology.xml:333
#: extras_topology.xml:374 extras_topology.xml:416 extras_topology.xml:453
#: extras_topology.xml:552 extras_topology.xml:628 extras_topology.xml:677
#: extras_topology.xml:716 extras_topology.xml:765 extras_topology.xml:806
#: extras_topology.xml:850 extras_topology.xml:894 extras_topology.xml:955
#: extras_topology.xml:1002 extras_topology.xml:1058 extras_topology.xml:1123
#: extras_topology.xml:1195 extras_topology.xml:1263 extras_topology.xml:1330
#: extras_topology.xml:1379 extras_topology.xml:1428 extras_topology.xml:1478
#: extras_topology.xml:1526 extras_topology.xml:1575 extras_topology.xml:1621
#: extras_topology.xml:1662 extras_topology.xml:1716 extras_topology.xml:1762
#: extras_topology.xml:1814 extras_topology.xml:1856 extras_topology.xml:1898
#: extras_topology.xml:1940 extras_topology.xml:1991 extras_topology.xml:2036
#: extras_topology.xml:2096 extras_topology.xml:2149 extras_topology.xml:2198
#: extras_topology.xml:2257 extras_topology.xml:2297 extras_topology.xml:2374
#: extras_topology.xml:2409 extras_topology.xml:2481 extras_topology.xml:2569
#: extras_topology.xml:2610 extras_topology.xml:2660 extras_topology.xml:2701
#: extras_topology.xml:2744 extras_topology.xml:2815 extras_topology.xml:2862
#: extras_topology.xml:2976 extras_topology.xml:3029 extras_topology.xml:3090
#: extras_topology.xml:3143
#, no-c-format
msgid "See Also"
msgstr "Si veda anche"

#. Tag: refname
#: extras_topology.xml:95
#, no-c-format
msgid "validatetopology_returntype"
msgstr "validatetopology_returntype"

#. Tag: refpurpose
#: extras_topology.xml:96
#, fuzzy, no-c-format
msgid ""
"A composite type that consists of an error message and id1 and id2 to denote "
"location of error. This is the return type for <varname>ValidateTopology</"
"varname>."
msgstr ""
"Un tipo composito che consiste in un numero sequenziale e un numero di "
"\"bordo\". E' il tipo ritornato dalla funzione <varname>ST_GetFaceEdges</"
"varname>."

#. Tag: para
#: extras_topology.xml:100
#, no-c-format
msgid ""
"A composite type that consists of an error message and two integers. The "
"<xref linkend=\"ValidateTopology\"/> function returns a set of these to "
"denote validation errors and the id1 and id2 to denote the ids of the "
"topology objects involved in the error."
msgstr ""

#. Tag: para
#: extras_topology.xml:103
#, no-c-format
msgid "<varname>error</varname> is varchar: Denotes type of error."
msgstr ""

#. Tag: para
#: extras_topology.xml:104
#, no-c-format
msgid ""
"Current error descriptors are: coincident nodes, edge crosses node, edge not "
"simple, edge end node geometry mis-match, edge start node geometry mismatch, "
"face overlaps face,face within face,"
msgstr ""

#. Tag: para
#: extras_topology.xml:107
#, no-c-format
msgid ""
"<varname>id1</varname> is an integer: Denotes identifier of edge / face / "
"nodes in error."
msgstr ""

#. Tag: para
#: extras_topology.xml:110
#, no-c-format
msgid ""
"<varname>id2</varname> is an integer: For errors that involve 2 objects "
"denotes the secondary edge / or node"
msgstr ""

#. Tag: para
#: extras_topology.xml:126
#, no-c-format
msgid ""
"This section lists the PostgreSQL domains installed by PostGIS Topology. "
"Domains can be used like object types as return objects of functions or "
"table columns. The distinction between a domain and a type is that a domain "
"is an existing type with a check constraint bound to it."
msgstr ""

#. Tag: title
#: extras_topology.xml:131
#, no-c-format
msgid "Topology Domains"
msgstr ""

#. Tag: refname
#: extras_topology.xml:135
#, no-c-format
msgid "TopoElement"
msgstr ""

#. Tag: refpurpose
#: extras_topology.xml:136
#, no-c-format
msgid ""
"An array of 2 integers generally used to identify a TopoGeometry component."
msgstr ""

#. Tag: para
#: extras_topology.xml:140
#, no-c-format
msgid ""
"An array of 2 integers used to represent one component of a simple or "
"hierarchical <xref linkend=\"topogeometry\"/>."
msgstr ""

#. Tag: para
#: extras_topology.xml:144
#, no-c-format
msgid ""
"In the case of a simple TopoGeometry the first element of the array "
"represents the identifier of a topological primitive and the second element "
"represents its type (1:node, 2:edge, 3:face). In the case of a hierarchical "
"TopoGeometry the first element of the array represents the identifier of a "
"child TopoGeometry and the second element represents its layer identifier."
msgstr ""

#. Tag: para
#: extras_topology.xml:153
#, no-c-format
msgid ""
"For any given hierarchical TopoGeometry all child TopoGeometry elements will "
"come from the same child layer, as specified in the topology.layer record "
"for the layer of the TopoGeometry being defined."
msgstr ""

#. Tag: title
#: extras_topology.xml:162 extras_topology.xml:190 extras_topology.xml:281
#: extras_topology.xml:326 extras_topology.xml:368 extras_topology.xml:409
#: extras_topology.xml:448 extras_topology.xml:546 extras_topology.xml:617
#: extras_topology.xml:667 extras_topology.xml:710 extras_topology.xml:759
#: extras_topology.xml:948 extras_topology.xml:995 extras_topology.xml:1051
#: extras_topology.xml:1116 extras_topology.xml:1188 extras_topology.xml:1256
#: extras_topology.xml:1324 extras_topology.xml:1373 extras_topology.xml:1520
#: extras_topology.xml:1569 extras_topology.xml:1615 extras_topology.xml:1656
#: extras_topology.xml:1708 extras_topology.xml:1755 extras_topology.xml:1806
#: extras_topology.xml:1850 extras_topology.xml:1892 extras_topology.xml:1934
#: extras_topology.xml:1984 extras_topology.xml:2030 extras_topology.xml:2251
#: extras_topology.xml:2291 extras_topology.xml:2368 extras_topology.xml:2560
#: extras_topology.xml:2606 extras_topology.xml:2654 extras_topology.xml:2695
#: extras_topology.xml:2738 extras_topology.xml:2808 extras_topology.xml:2855
#: extras_topology.xml:2967 extras_topology.xml:3034 extras_topology.xml:3083
#: extras_topology.xml:3136
#, no-c-format
msgid "Examples"
msgstr "Esempi"

#. Tag: programlisting
#: extras_topology.xml:163
#, no-c-format
msgid ""
"SELECT te[1] AS id, te[2] AS type FROM\n"
"( SELECT ARRAY[1,2]::topology.topoelement AS te ) f;\n"
" id | type\n"
"----+------\n"
"  1 |    2"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:164
#, no-c-format
msgid ""
"SELECT ARRAY[1,2]::topology.topoelement;\n"
"  te\n"
"-------\n"
" {1,2}"
msgstr ""
"SELECT ARRAY[1,2]::topology.topoelement;\n"
"  te\n"
"-------\n"
" {1,2}"

#. Tag: programlisting
#: extras_topology.xml:165
#, no-c-format
msgid ""
"--Example of what happens when you try to case a 3 element array to "
"topoelement\n"
"-- NOTE: topoement has to be a 2 element array so fails dimension check\n"
"SELECT ARRAY[1,2,3]::topology.topoelement;\n"
"ERROR:  value for domain topology.topoelement violates check constraint "
"\"dimensions\""
msgstr ""

#. Tag: para
#: extras_topology.xml:170
#, no-c-format
msgid ""
", <xref linkend=\"topoelementarray\"/>, <xref linkend=\"topogeometry\"/>, "
"<xref linkend=\"TopoGeom_addElement\"/>, <xref linkend=\"TopoGeom_remElement"
"\"/>"
msgstr ""

#. Tag: refname
#: extras_topology.xml:182
#, no-c-format
msgid "TopoElementArray"
msgstr "TopoElementArray"

#. Tag: refpurpose
#: extras_topology.xml:183
#, no-c-format
msgid "An array of TopoElement objects."
msgstr ""

#. Tag: para
#: extras_topology.xml:187
#, no-c-format
msgid ""
"An array of 1 or more TopoElement objects, generally used to pass around "
"components of TopoGeometry objects."
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:191
#, no-c-format
msgid ""
"SELECT '{{1,2},{4,3}}'::topology.topoelementarray As tea;\n"
"  tea\n"
"-------\n"
"{{1,2},{4,3}}\n"
"\n"
"-- more verbose equivalent --\n"
"SELECT ARRAY[ARRAY[1,2], ARRAY[4,3]]::topology.topoelementarray As tea;\n"
"\n"
"  tea\n"
"-------\n"
"{{1,2},{4,3}}\n"
"\n"
"--using the array agg function packaged with topology --\n"
"SELECT topology.TopoElementArray_Agg(ARRAY[e,t]) As tea\n"
"  FROM generate_series(1,4) As e CROSS JOIN generate_series(1,3) As t;\n"
"  tea\n"
"--------------------------------------------------------------------------\n"
"{{1,1},{1,2},{1,3},{2,1},{2,2},{2,3},{3,1},{3,2},{3,3},{4,1},{4,2},{4,3}}"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:192
#, no-c-format
msgid ""
"SELECT '{{1,2,4},{3,4,5}}'::topology.topoelementarray As tea;\n"
"ERROR:  value for domain topology.topoelementarray violates check constraint "
"\"dimensions\""
msgstr ""
"SELECT '{{1,2,4},{3,4,5}}'::topology.topoelementarray As tea;\n"
"ERROR:  value for domain topology.topoelementarray violates check constraint "
"\"dimensions\""

#. Tag: para
#: extras_topology.xml:197
#, no-c-format
msgid ""
", <xref linkend=\"GetTopoGeomElementArray\"/>, <xref linkend="
"\"TopoElementArray_Agg\"/>"
msgstr ""
", <xref linkend=\"GetTopoGeomElementArray\"/>, <xref linkend="
"\"TopoElementArray_Agg\"/>"

#. Tag: para
#: extras_topology.xml:209
#, no-c-format
msgid ""
"This section lists the Topology functions for building new Topology schemas, "
"validating topologies, and managing TopoGeometry Columns"
msgstr ""

#. Tag: title
#: extras_topology.xml:212
#, no-c-format
msgid "Topology and TopoGeometry Management"
msgstr ""

#. Tag: refname
#: extras_topology.xml:215
#, no-c-format
msgid "AddTopoGeometryColumn"
msgstr "AddTopoGeometryColumn"

#. Tag: refpurpose
#: extras_topology.xml:216
#, no-c-format
msgid ""
"Adds a topogeometry column to an existing table, registers this new column "
"as a layer in topology.layer and returns the new layer_id."
msgstr ""

#. Tag: funcsynopsis
#: extras_topology.xml:220
#, no-c-format
msgid ""
"<funcprototype> <funcdef>integer <function>AddTopoGeometryColumn</function></"
"funcdef> <paramdef><type>varchar </type> <parameter>topology_name</"
"parameter></paramdef> <paramdef><type>varchar </type> "
"<parameter>schema_name</parameter></paramdef> <paramdef><type>varchar </"
"type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar </"
"type> <parameter>column_name</parameter></paramdef> <paramdef><type>varchar "
"</type> <parameter>feature_type</parameter></paramdef> </funcprototype> "
"<funcprototype> <funcdef>integer <function>AddTopoGeometryColumn</function></"
"funcdef> <paramdef><type>varchar </type> <parameter>topology_name</"
"parameter></paramdef> <paramdef><type>varchar </type> "
"<parameter>schema_name</parameter></paramdef> <paramdef><type>varchar </"
"type> <parameter>table_name</parameter></paramdef> <paramdef><type>varchar </"
"type> <parameter>column_name</parameter></paramdef> <paramdef><type>varchar "
"</type> <parameter>feature_type</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>child_layer</parameter></"
"paramdef> </funcprototype>"
msgstr ""

#. Tag: para
#: extras_topology.xml:265
#, no-c-format
msgid ""
"Each TopoGeometry object belongs to a specific Layer of a specific Topology. "
"Before creating a TopoGeometry object you need to create its TopologyLayer. "
"A Topology Layer is an association of a feature-table with the topology. It "
"also contain type and hierarchy information. We create a layer using the "
"AddTopoGeometryColumn() function:"
msgstr ""

#. Tag: para
#: extras_topology.xml:267
#, no-c-format
msgid ""
"This function will both add the requested column to the table and add a "
"record to the topology.layer table with all the given info."
msgstr ""

#. Tag: para
#: extras_topology.xml:268
#, no-c-format
msgid ""
"If you don't specify [child_layer] (or set it to NULL) this layer would "
"contain Basic TopoGeometries (composed by primitive topology elements). "
"Otherwise this layer will contain hierarchical TopoGeometries (composed by "
"TopoGeometries from the child_layer)."
msgstr ""

#. Tag: para
#: extras_topology.xml:271
#, no-c-format
msgid ""
"Once the layer is created (its id is returned by the AddTopoGeometryColumn "
"function) you're ready to construct TopoGeometry objects in it"
msgstr ""

#. Tag: para
#: extras_topology.xml:272
#, no-c-format
msgid ""
"Valid <varname>feature_type</varname>s are: POINT, LINE, POLYGON, COLLECTION"
msgstr ""

#. Tag: para
#: extras_topology.xml:275 extras_topology.xml:321 extras_topology.xml:363
#: extras_topology.xml:612 extras_topology.xml:704 extras_topology.xml:942
#: extras_topology.xml:989 extras_topology.xml:1366 extras_topology.xml:1514
#: extras_topology.xml:1563 extras_topology.xml:1609 extras_topology.xml:1650
#: extras_topology.xml:1845 extras_topology.xml:1929 extras_topology.xml:2024
#: extras_topology.xml:2459 extras_topology.xml:2803
#, no-c-format
msgid "Availability: 1.?"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:282
#, no-c-format
msgid ""
"-- Note for this example we created our new table in the ma_topo schema\n"
"-- though we could have created it in a different schema -- in which case "
"topology_name and schema_name would be different\n"
"CREATE SCHEMA ma;\n"
"CREATE TABLE ma.parcels(gid serial, parcel_id varchar(20) PRIMARY KEY, "
"address text);\n"
"SELECT topology.AddTopoGeometryColumn('ma_topo', 'ma', 'parcels', 'topo', "
"'POLYGON');"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:283
#, no-c-format
msgid ""
"CREATE SCHEMA ri;\n"
"CREATE TABLE ri.roads(gid serial PRIMARY KEY, road_name text);\n"
"SELECT topology.AddTopoGeometryColumn('ri_topo', 'ri', 'roads', 'topo', "
"'LINE');"
msgstr ""
"CREATE SCHEMA ri;\n"
"CREATE TABLE ri.roads(gid serial PRIMARY KEY, road_name text);\n"
"SELECT topology.AddTopoGeometryColumn('ri_topo', 'ri', 'roads', 'topo', "
"'LINE');"

#. Tag: para
#: extras_topology.xml:290
#, fuzzy, no-c-format
msgid ""
", <xref linkend=\"toTopoGeom\"/>, <xref linkend=\"CreateTopology\"/>, <xref "
"linkend=\"CreateTopoGeom\"/>"
msgstr ""
", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyName\"/>, "
"<xref linkend=\"GetTopologyID\"/>"

#. Tag: refname
#: extras_topology.xml:300
#, no-c-format
msgid "DropTopology"
msgstr "DropTopology"

#. Tag: refpurpose
#: extras_topology.xml:302
#, no-c-format
msgid ""
"Use with caution: Drops a topology schema and deletes its reference from "
"topology.topology table and references to tables in that schema from the "
"geometry_columns table."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:307
#, no-c-format
msgid ""
"<funcdef>integer <function>DropTopology</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></"
"paramdef>"
msgstr ""
"<funcdef>integer <function>DropTopology</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></"
"paramdef>"

#. Tag: para
#: extras_topology.xml:317
#, no-c-format
msgid ""
"Drops a topology schema and deletes its reference from topology.topology "
"table and references to tables in that schema from the geometry_columns "
"table. This function should be USED WITH CAUTION, as it could destroy data "
"you care about. If the schema does not exist, it just removes reference "
"entries the named schema."
msgstr ""

#. Tag: para
#: extras_topology.xml:327
#, no-c-format
msgid ""
"Cascade drops the ma_topo schema and removes all references to it in "
"topology.topology and geometry_columns."
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:328
#, no-c-format
msgid "SELECT topology.DropTopology('ma_topo');"
msgstr "SELECT topology.DropTopology('ma_topo');"

#. Tag: refname
#: extras_topology.xml:340
#, no-c-format
msgid "DropTopoGeometryColumn"
msgstr "DropTopoGeometryColumn"

#. Tag: refpurpose
#: extras_topology.xml:342
#, no-c-format
msgid ""
"Drops the topogeometry column from the table named <varname>table_name</"
"varname> in schema <varname>schema_name</varname> and unregisters the "
"columns from topology.layer table."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:347
#, no-c-format
msgid ""
"<funcdef>text <function>DropTopoGeometryColumn</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>schema_name</parameter></"
"paramdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></"
"paramdef> <paramdef><type>varchar </type> <parameter>column_name</"
"parameter></paramdef>"
msgstr ""
"<funcdef>text <function>DropTopoGeometryColumn</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>schema_name</parameter></"
"paramdef> <paramdef><type>varchar </type> <parameter>table_name</parameter></"
"paramdef> <paramdef><type>varchar </type> <parameter>column_name</"
"parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:359
#, no-c-format
msgid ""
"Drops the topogeometry column from the table named <varname>table_name</"
"varname> in schema <varname>schema_name</varname> and unregisters the "
"columns from topology.layer table. Returns summary of drop status. NOTE: it "
"first sets all values to NULL before dropping to bypass referential "
"integrity checks."
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:369
#, no-c-format
msgid ""
"SELECT topology.DropTopoGeometryColumn('ma_topo', 'parcel_topo', 'topo');"
msgstr ""
"SELECT topology.DropTopoGeometryColumn('ma_topo', 'parcel_topo', 'topo');"

#. Tag: refname
#: extras_topology.xml:381
#, no-c-format
msgid "Populate_Topology_Layer"
msgstr ""

#. Tag: refpurpose
#: extras_topology.xml:383
#, no-c-format
msgid ""
"Adds missing entries to topology.layer table by reading metadata from topo "
"tables."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:389
#, no-c-format
msgid ""
"<funcdef>setof record <function>Populate_Topology_Layer</function></funcdef> "
"<paramdef></paramdef>"
msgstr ""

#. Tag: para
#: extras_topology.xml:399
#, no-c-format
msgid ""
"Adds missing entries to the <varname>topology.layer</varname> table by "
"inspecting topology constraints on tables. This function is useful for "
"fixing up entries in topology catalog after restores of schemas with topo "
"data."
msgstr ""

#. Tag: para
#: extras_topology.xml:401
#, no-c-format
msgid ""
"It returns the list of entries created. Returned columns are "
"<varname>schema_name</varname>, <varname>table_name</varname>, "
"<varname>feature_column</varname>."
msgstr ""

#. Tag: para
#: extras_topology.xml:404
#, no-c-format
msgid "Availability: 2.3.0"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:410
#, no-c-format
msgid ""
"SELECT CreateTopology('strk_topo');\n"
"CREATE SCHEMA strk;\n"
"CREATE TABLE strk.parcels(gid serial, parcel_id varchar(20) PRIMARY KEY, "
"address text);\n"
"SELECT topology.AddTopoGeometryColumn('strk_topo', 'strk', 'parcels', "
"'topo', 'POLYGON');\n"
"-- this will return no records because this feature is already registered\n"
"SELECT *\n"
"  FROM topology.Populate_Topology_Layer();\n"
"\n"
"-- let's rebuild\n"
"TRUNCATE TABLE topology.layer;\n"
"\n"
"SELECT *\n"
"  FROM topology.Populate_Topology_Layer();\n"
"\n"
"SELECT topology_id,layer_id, schema_name As sn, table_name As tn, "
"feature_column As fc\n"
"FROM topology.layer;"
msgstr ""

#. Tag: screen
#: extras_topology.xml:411
#, no-c-format
msgid ""
"schema_name | table_name | feature_column\n"
"-------------+------------+----------------\n"
" strk        | parcels    | topo\n"
"(1 row)\n"
"\n"
" topology_id | layer_id |  sn  |   tn    |  fc\n"
"-------------+----------+------+---------+------\n"
"           2 |        2 | strk | parcels | topo\n"
"(1 row)"
msgstr ""

#. Tag: refname
#: extras_topology.xml:423
#, no-c-format
msgid "TopologySummary"
msgstr "TopologySummary"

#. Tag: refpurpose
#: extras_topology.xml:425
#, no-c-format
msgid ""
"<refpurpose>Takes a topology name and provides summary totals of types of "
"objects in topology.</refpurpose>"
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:430
#, no-c-format
msgid ""
"<funcdef>text <function>TopologySummary</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></"
"paramdef>"
msgstr ""
"<funcdef>text <function>TopologySummary</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></"
"paramdef>"

#. Tag: para
#: extras_topology.xml:440
#, no-c-format
msgid ""
"<para>Takes a topology name and provides summary totals of types of objects "
"in topology.</para>"
msgstr ""

#. Tag: para
#: extras_topology.xml:443 extras_topology.xml:662 extras_topology.xml:800
#: extras_topology.xml:844 extras_topology.xml:888 extras_topology.xml:1703
#: extras_topology.xml:1752 extras_topology.xml:1801 extras_topology.xml:1887
#: extras_topology.xml:2090 extras_topology.xml:2193 extras_topology.xml:2246
#: extras_topology.xml:2287 extras_topology.xml:2363 extras_topology.xml:2601
#: extras_topology.xml:2850 extras_topology.xml:2962
#, no-c-format
msgid "Availability: 2.0.0"
msgstr "Disponibilità: 2.0"

#. Tag: programlisting
#: extras_topology.xml:449
#, no-c-format
msgid ""
"SELECT topology.topologysummary('city_data');\n"
"                    topologysummary\n"
"--------------------------------------------------------\n"
" Topology city_data (329), SRID 4326, precision: 0\n"
" 22 nodes, 24 edges, 10 faces, 29 topogeoms in 5 layers\n"
" Layer 1, type Polygonal (3), 9 topogeoms\n"
"  Deploy: features.land_parcels.feature\n"
" Layer 2, type Puntal (1), 8 topogeoms\n"
"  Deploy: features.traffic_signs.feature\n"
" Layer 3, type Lineal (2), 8 topogeoms\n"
"  Deploy: features.city_streets.feature\n"
" Layer 4, type Polygonal (3), 3 topogeoms\n"
"  Hierarchy level 1, child layer 1\n"
"  Deploy: features.big_parcels.feature\n"
" Layer 5, type Puntal (1), 1 topogeoms\n"
"  Hierarchy level 1, child layer 2\n"
"  Deploy: features.big_signs.feature"
msgstr ""

#. Tag: refname
#: extras_topology.xml:460
#, no-c-format
msgid "ValidateTopology"
msgstr "ValidateTopology"

#. Tag: refpurpose
#: extras_topology.xml:462
#, no-c-format
msgid ""
"Returns a set of validatetopology_returntype objects detailing issues with "
"topology."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:467
#, no-c-format
msgid ""
"<funcdef>setof validatetopology_returntype <function>ValidateTopology</"
"function></funcdef> <paramdef><type>varchar </type> "
"<parameter>topology_schema_name</parameter></paramdef>"
msgstr ""
"<funcdef>setof validatetopology_returntype <function>ValidateTopology</"
"function></funcdef> <paramdef><type>varchar </type> "
"<parameter>topology_schema_name</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:477
#, no-c-format
msgid ""
"Returns a set of <xref linkend=\"validatetopology_returntype\"/> objects "
"detailing issues with topology. List of possible errors and what the "
"returned ids represent are displayed below:"
msgstr ""

#. Tag: entry
#: extras_topology.xml:481
#, no-c-format
msgid "Error"
msgstr ""

#. Tag: entry
#: extras_topology.xml:481
#, no-c-format
msgid "<entry>id1</entry>"
msgstr ""

#. Tag: entry
#: extras_topology.xml:481
#, no-c-format
msgid "<entry>id2</entry>"
msgstr ""

#. Tag: entry
#: extras_topology.xml:484
#, no-c-format
msgid "edge crosses node"
msgstr ""

#. Tag: entry
#: extras_topology.xml:485 extras_topology.xml:490 extras_topology.xml:495
#: extras_topology.xml:500 extras_topology.xml:501 extras_topology.xml:505
#: extras_topology.xml:510
#, no-c-format
msgid "edge_id"
msgstr ""

#. Tag: entry
#: extras_topology.xml:486 extras_topology.xml:506 extras_topology.xml:511
#, no-c-format
msgid "node_id"
msgstr ""

#. Tag: entry
#: extras_topology.xml:489
#, no-c-format
msgid "invalid edge"
msgstr ""

#. Tag: entry
#: extras_topology.xml:491 extras_topology.xml:496 extras_topology.xml:516
#: extras_topology.xml:521
#, no-c-format
msgid "null"
msgstr ""

#. Tag: entry
#: extras_topology.xml:494
#, no-c-format
msgid "edge not simple"
msgstr ""

#. Tag: entry
#: extras_topology.xml:499
#, no-c-format
msgid "edge crosses edge"
msgstr ""

#. Tag: entry
#: extras_topology.xml:504
#, no-c-format
msgid "edge start node geometry mis-match"
msgstr ""

#. Tag: entry
#: extras_topology.xml:509
#, no-c-format
msgid "edge end node geometry mis-match"
msgstr ""

#. Tag: entry
#: extras_topology.xml:514
#, no-c-format
msgid "face without edges"
msgstr ""

#. Tag: entry
#: extras_topology.xml:515 extras_topology.xml:520 extras_topology.xml:525
#: extras_topology.xml:526
#, no-c-format
msgid "face_id"
msgstr ""

#. Tag: entry
#: extras_topology.xml:519
#, no-c-format
msgid "face has no rings"
msgstr ""

#. Tag: entry
#: extras_topology.xml:524
#, no-c-format
msgid "face overlaps face"
msgstr ""

#. Tag: entry
#: extras_topology.xml:529
#, no-c-format
msgid "face within face"
msgstr ""

#. Tag: entry
#: extras_topology.xml:530
#, no-c-format
msgid "inner face_id"
msgstr ""

#. Tag: entry
#: extras_topology.xml:531
#, no-c-format
msgid "outer face_id"
msgstr ""

#. Tag: para
#: extras_topology.xml:538
#, no-c-format
msgid "Availability: 1.0.0"
msgstr ""

#. Tag: para
#: extras_topology.xml:540
#, no-c-format
msgid ""
"Enhanced: 2.0.0 more efficient edge crossing detection and fixes for false "
"positives that were existent in prior versions."
msgstr ""

#. Tag: para
#: extras_topology.xml:541
#, no-c-format
msgid ""
"Changed: 2.2.0 values for id1 and id2 were swapped for 'edge crosses node' "
"to be consistent with error description."
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:547
#, no-c-format
msgid ""
"SELECT * FROM  topology.ValidateTopology('ma_topo');\n"
"      error        | id1 | id2\n"
"-------------------+-----+-----\n"
"face without edges |   0 |"
msgstr ""
"SELECT * FROM  topology.ValidateTopology('ma_topo');\n"
"      error        | id1 | id2\n"
"-------------------+-----+-----\n"
"face without edges |   0 |"

#. Tag: para
#: extras_topology.xml:553
#, no-c-format
msgid ", <xref linkend=\"Topology_Load_Tiger\"/>"
msgstr ", <xref linkend=\"Topology_Load_Tiger\"/>"

#. Tag: para
#: extras_topology.xml:561
#, no-c-format
msgid "This section covers the topology functions for creating new topologies."
msgstr ""

#. Tag: title
#: extras_topology.xml:564
#, no-c-format
msgid "Topology Constructors"
msgstr ""

#. Tag: refname
#: extras_topology.xml:568
#, no-c-format
msgid "CreateTopology"
msgstr "CreateTopology"

#. Tag: refpurpose
#: extras_topology.xml:569
#, no-c-format
msgid ""
"Creates a new topology schema and registers this new schema in the topology."
"topology table."
msgstr ""

#. Tag: funcsynopsis
#: extras_topology.xml:573
#, no-c-format
msgid ""
"<funcprototype> <funcdef>integer <function>CreateTopology</function></"
"funcdef> <paramdef><type>varchar </type> <parameter>topology_schema_name</"
"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>integer "
"<function>CreateTopology</function></funcdef> <paramdef><type>varchar </"
"type> <parameter>topology_schema_name</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>integer <function>CreateTopology</"
"function></funcdef> <paramdef><type>varchar </type> "
"<parameter>topology_schema_name</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef> "
"<paramdef><type>double precision </type> <parameter>prec</parameter></"
"paramdef> </funcprototype> <funcprototype> <funcdef>integer "
"<function>CreateTopology</function></funcdef> <paramdef><type>varchar </"
"type> <parameter>topology_schema_name</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>srid</parameter></paramdef> "
"<paramdef><type>double precision </type> <parameter>prec</parameter></"
"paramdef> <paramdef><type>boolean </type> <parameter>hasz</parameter></"
"paramdef> </funcprototype>"
msgstr ""

#. Tag: para
#: extras_topology.xml:605
#, no-c-format
msgid ""
"Creates a new schema with name <varname>topology_name</varname> consisting "
"of tables (<varname>edge_data</varname>,<varname>face</varname>,"
"<varname>node</varname>, <varname>relation</varname> and registers this new "
"topology in the topology.topology table. It returns the id of the topology "
"in the topology table. The srid is the spatial reference identified as "
"defined in spatial_ref_sys table for that topology. Topologies must be "
"uniquely named. The tolerance is measured in the units of the spatial "
"reference system. If the tolerance (<varname>prec</varname>) is not "
"specified defaults to 0."
msgstr ""

#. Tag: para
#: extras_topology.xml:609
#, no-c-format
msgid ""
"This is similar to the SQL/MM <xref linkend=\"ST_InitTopoGeo\"/> but a bit "
"more functional. <varname>hasz</varname> defaults to false if not specified."
msgstr ""

#. Tag: para
#: extras_topology.xml:618
#, no-c-format
msgid ""
"This example creates a new schema called ma_topo that will store edges, "
"faces, and relations in Massachusetts State Plane meters. The tolerance "
"represents 1/2 meter since the spatial reference system is a meter based "
"spatial reference system"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:620
#, no-c-format
msgid "SELECT topology.CreateTopology('ma_topo',26986, 0.5);"
msgstr "SELECT topology.CreateTopology('ma_topo',26986, 0.5);"

#. Tag: para
#: extras_topology.xml:622
#, no-c-format
msgid "Create Rhode Island topology in State Plane ft"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:623
#, no-c-format
msgid ""
"SELECT topology.CreateTopology('ri_topo',3438) As topoid;\n"
"topoid\n"
"------\n"
"2"
msgstr ""
"SELECT topology.CreateTopology('ri_topo',3438) As topoid;\n"
"topoid\n"
"------\n"
"2"

#. Tag: para
#: extras_topology.xml:630
#, no-c-format
msgid ""
", <xref linkend=\"ST_InitTopoGeo\"/>, <xref linkend=\"Topology_Load_Tiger\"/>"
msgstr ""
", <xref linkend=\"ST_InitTopoGeo\"/>, <xref linkend=\"Topology_Load_Tiger\"/>"

#. Tag: refname
#: extras_topology.xml:636
#, no-c-format
msgid "CopyTopology"
msgstr "CopyTopology"

#. Tag: refpurpose
#: extras_topology.xml:637
#, no-c-format
msgid ""
"Makes a copy of a topology structure (nodes, edges, faces, layers and "
"TopoGeometries)."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:642
#, no-c-format
msgid ""
"<funcdef>integer <function>CopyTopology</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>existing_topology_name</"
"parameter></paramdef> <paramdef><type>varchar </type> <parameter>new_name</"
"parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>CopyTopology</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>existing_topology_name</"
"parameter></paramdef> <paramdef><type>varchar </type> <parameter>new_name</"
"parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:653
#, no-c-format
msgid ""
"Creates a new topology with name <varname>new_topology_name</varname> and "
"SRID and precision taken from <varname>existing_topology_name</varname>, "
"copies all nodes, edges and faces in there, copies layers and their "
"TopoGeometries too."
msgstr ""

#. Tag: para
#: extras_topology.xml:657
#, no-c-format
msgid ""
"The new rows in topology.layer will contain synthesized values for "
"schema_name, table_name and feature_column. This is because the TopoGeometry "
"will only exist as a definition but won't be available in any user-level "
"table yet."
msgstr ""

#. Tag: para
#: extras_topology.xml:668
#, no-c-format
msgid "This example makes a backup of a topology called ma_topo"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:671
#, no-c-format
msgid "SELECT topology.CopyTopology('ma_topo', 'ma_topo_bakup');"
msgstr "SELECT topology.CopyTopology('ma_topo', 'ma_topo_bakup');"

#. Tag: para
#: extras_topology.xml:679 extras_topology.xml:2258
#, no-c-format
msgid ", <xref linkend=\"CreateTopology\"/>"
msgstr ", <xref linkend=\"CreateTopology\"/>"

#. Tag: refname
#: extras_topology.xml:685
#, no-c-format
msgid "ST_InitTopoGeo"
msgstr ""

#. Tag: refpurpose
#: extras_topology.xml:686
#, no-c-format
msgid ""
"Creates a new topology schema and registers this new schema in the topology."
"topology table and details summary of process."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:691
#, no-c-format
msgid ""
"<funcdef>text <function>ST_InitTopoGeo</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></"
"paramdef>"
msgstr ""
"<funcdef>text <function>ST_InitTopoGeo</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>topology_schema_name</parameter></"
"paramdef>"

#. Tag: para
#: extras_topology.xml:701
#, no-c-format
msgid ""
"This is an SQL-MM equivalent of CreateTopology but lacks the spatial "
"reference and tolerance options of CreateTopology and outputs a text "
"description of creation instead of topology id."
msgstr ""

#. Tag: para
#: extras_topology.xml:705
#, no-c-format
msgid ""
"&sqlmm_compliant; SQL-MM 3 Topo-Geo and Topo-Net 3: Routine Details: X.3.17"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:711
#, no-c-format
msgid ""
"SELECT topology.ST_InitTopoGeo('topo_schema_to_create') AS topocreation;\n"
"                      astopocreation\n"
"------------------------------------------------------------\n"
" Topology-Geometry 'topo_schema_to_create' (id:7) created."
msgstr ""
"SELECT topology.ST_InitTopoGeo('topo_schema_to_create') AS topocreation;\n"
"                      astopocreation\n"
"------------------------------------------------------------\n"
" Topology-Geometry 'topo_schema_to_create' (id:7) created."

#. Tag: refname
#: extras_topology.xml:725
#, no-c-format
msgid "ST_CreateTopoGeo"
msgstr "ST_CreateTopoGeo"

#. Tag: refpurpose
#: extras_topology.xml:727
#, no-c-format
msgid ""
"<refpurpose>Adds a collection of geometries to a given empty topology and "
"returns a message detailing success.</refpurpose>"
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:734
#, no-c-format
msgid ""
"<funcdef>text <function>ST_CreateTopoGeo</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>acollection</parameter></"
"paramdef>"
msgstr ""
"<funcdef>text <function>ST_CreateTopoGeo</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>acollection</parameter></"
"paramdef>"

#. Tag: para
#: extras_topology.xml:745
#, no-c-format
msgid ""
"<para>Adds a collection of geometries to a given empty topology and returns "
"a message detailing success.</para>"
msgstr ""

#. Tag: para
#: extras_topology.xml:749
#, no-c-format
msgid "Useful for populating an empty topology."
msgstr ""

#. Tag: para
#: extras_topology.xml:753 extras_topology.xml:1045 extras_topology.xml:1110
#: extras_topology.xml:1182 extras_topology.xml:1250 extras_topology.xml:1421
#: extras_topology.xml:1471 extras_topology.xml:1978 extras_topology.xml:2144
#: extras_topology.xml:2556
#, no-c-format
msgid "Availability: 2.0"
msgstr "Disponibilità: 2.0"

#. Tag: para
#: extras_topology.xml:754
#, no-c-format
msgid ""
"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details -- X.3.18"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:760
#, no-c-format
msgid ""
"-- Populate topology --\n"
"SELECT topology.ST_CreateTopoGeo('ri_topo',\n"
" ST_GeomFromText('MULTILINESTRING((384744 236928,384750 236923,384769 "
"236911,384799 236895,384811 236890,384833 236884,\n"
"  384844 236882,384866 236881,384879 236883,384954 236898,385087 "
"236932,385117 236938,\n"
"  385167 236938,385203 236941,385224 236946,385233 236950,385241 "
"236956,385254 236971,\n"
"  385260 236979,385268 236999,385273 237018,385273 237037,385271 "
"237047,385267 237057,\n"
"  385225 237125,385210 237144,385192 237161,385167 237192,385162 "
"237202,385159 237214,\n"
"  385159 237227,385162 237241,385166 237256,385196 237324,385209 "
"237345,385234 237375,\n"
"  385237 237383,385238 237399,385236 237407,385227 237419,385213 "
"237430,385193 237439,\n"
"  385174 237451,385170 237455,385169 237460,385171 237475,385181 "
"237503,385190 237521,\n"
"  385200 237533,385206 237538,385213 237541,385221 237542,385235 "
"237540,385242 237541,\n"
"  385249 237544,385260 237555,385270 237570,385289 237584,385292 "
"237589,385291 237596,385284 237630))',3438)\n"
"  );\n"
"\n"
"      st_createtopogeo\n"
"----------------------------\n"
" Topology ri_topo populated\n"
"\n"
"\n"
"-- create tables and topo geometries --\n"
"CREATE TABLE ri.roads(gid serial PRIMARY KEY, road_name text);\n"
"\n"
"SELECT topology.AddTopoGeometryColumn('ri_topo', 'ri', 'roads', 'topo', "
"'LINE');"
msgstr ""

#. Tag: para
#: extras_topology.xml:766
#, no-c-format
msgid ", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"DropTopology\"/>"
msgstr ", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"DropTopology\"/>"

#. Tag: refname
#: extras_topology.xml:772
#, no-c-format
msgid "TopoGeo_AddPoint"
msgstr "TopoGeo_AddPoint"

#. Tag: refpurpose
#: extras_topology.xml:774
#, no-c-format
msgid ""
"Adds a point to an existing topology using a tolerance and possibly "
"splitting an existing edge."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:781
#, fuzzy, no-c-format
msgid ""
"<funcdef>integer <function>TopoGeo_AddPoint</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</"
"parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>TopoGeo_AddPoint</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</"
"parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:793
#, no-c-format
msgid ""
"Adds a point to an existing topology and returns its identifier. The given "
"point will snap to existing nodes or edges within given tolerance. An "
"existing edge may be split by the snapped point."
msgstr ""

#. Tag: para
#: extras_topology.xml:807
#, no-c-format
msgid ""
", <xref linkend=\"TopoGeo_AddPolygon\"/>, <xref linkend=\"AddNode\"/>, <xref "
"linkend=\"CreateTopology\"/>"
msgstr ""
", <xref linkend=\"TopoGeo_AddPolygon\"/>, <xref linkend=\"AddNode\"/>, <xref "
"linkend=\"CreateTopology\"/>"

#. Tag: refname
#: extras_topology.xml:818
#, no-c-format
msgid "TopoGeo_AddLineString"
msgstr "TopoGeo_AddLineString"

#. Tag: refpurpose
#: extras_topology.xml:820
#, no-c-format
msgid ""
"Adds a linestring to an existing topology using a tolerance and possibly "
"splitting existing edges/faces. Returns edge identifiers."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:825
#, fuzzy, no-c-format
msgid ""
"<funcdef>SETOF integer <function>TopoGeo_AddLineString</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>aline</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</"
"parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>TopoGeo_AddPoint</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</"
"parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:837
#, no-c-format
msgid ""
"Adds a linestring to an existing topology and returns a set of edge "
"identifiers forming it up. The given line will snap to existing nodes or "
"edges within given tolerance. Existing edges and faces may be split by the "
"line."
msgstr ""

#. Tag: para
#: extras_topology.xml:851
#, no-c-format
msgid ""
", <xref linkend=\"TopoGeo_AddPolygon\"/>, <xref linkend=\"AddEdge\"/>, <xref "
"linkend=\"CreateTopology\"/>"
msgstr ""
", <xref linkend=\"TopoGeo_AddPolygon\"/>, <xref linkend=\"AddEdge\"/>, <xref "
"linkend=\"CreateTopology\"/>"

#. Tag: refname
#: extras_topology.xml:862
#, no-c-format
msgid "TopoGeo_AddPolygon"
msgstr "TopoGeo_AddPolygon"

#. Tag: refpurpose
#: extras_topology.xml:864
#, no-c-format
msgid ""
"Adds a polygon to an existing topology using a tolerance and possibly "
"splitting existing edges/faces. Returns face identifiers."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:869
#, fuzzy, no-c-format
msgid ""
"<funcdef>SETOF integer <function>TopoGeo_AddPolygon</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoly</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</"
"parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>TopoGeo_AddPoint</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>float8 </type> <parameter>tolerance</"
"parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:881
#, no-c-format
msgid ""
"Adds a polygon to an existing topology and returns a set of face identifiers "
"forming it up. The boundary of the given polygon will snap to existing nodes "
"or edges within given tolerance. Existing edges and faces may be split by "
"the boundary of the new polygon."
msgstr ""

#. Tag: para
#: extras_topology.xml:895
#, no-c-format
msgid ""
", <xref linkend=\"TopoGeo_AddLineString\"/>, <xref linkend=\"AddFace\"/>, "
"<xref linkend=\"CreateTopology\"/>"
msgstr ""
", <xref linkend=\"TopoGeo_AddLineString\"/>, <xref linkend=\"AddFace\"/>, "
"<xref linkend=\"CreateTopology\"/>"

#. Tag: para
#: extras_topology.xml:910
#, no-c-format
msgid ""
"This section covers topology functions for adding, moving, deleting, and "
"splitting edges, faces, and nodes. All of these functions are defined by ISO "
"SQL/MM."
msgstr ""

#. Tag: title
#: extras_topology.xml:913
#, no-c-format
msgid "Topology Editors"
msgstr ""

#. Tag: refname
#: extras_topology.xml:917
#, no-c-format
msgid "ST_AddIsoNode"
msgstr "ST_AddIsoNode"

#. Tag: refpurpose
#: extras_topology.xml:919
#, no-c-format
msgid ""
"Adds an isolated node to a face in a topology and returns the nodeid of the "
"new node. If face is null, the node is still created."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:924
#, no-c-format
msgid ""
"<funcdef>integer <function>ST_AddIsoNode</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>ST_AddIsoNode</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:936
#, no-c-format
msgid ""
"Adds an isolated node with point location <varname>apoint</varname> to an "
"existing face with faceid <varname>aface</varname> to a topology "
"<varname>atopology</varname> and returns the nodeid of the new node."
msgstr ""

#. Tag: para
#: extras_topology.xml:937
#, no-c-format
msgid ""
"If the spatial reference system (srid) of the point geometry is not the same "
"as the topology, the <varname>apoint</varname> is not a point geometry, the "
"point is null, or the point intersects an existing edge (even at the "
"boundaries) then an exception is thrown. If the point already exists as a "
"node, an exception is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:939
#, no-c-format
msgid ""
"If <varname>aface</varname> is not null and the <varname>apoint</varname> is "
"not within the face, then an exception is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:943
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM: Topo-Net Routines: X+1.3.1"
msgstr ""

#. Tag: para
#: extras_topology.xml:956
#, no-c-format
msgid ""
", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"DropTopology\"/>, "
"<xref linkend=\"ST_Intersects\"/>"
msgstr ""
", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"DropTopology\"/>, "
"<xref linkend=\"ST_Intersects\"/>"

#. Tag: refname
#: extras_topology.xml:962
#, no-c-format
msgid "ST_AddIsoEdge"
msgstr "ST_AddIsoEdge"

#. Tag: refpurpose
#: extras_topology.xml:964
#, no-c-format
msgid ""
"<refpurpose>Adds an isolated edge defined by geometry <varname>alinestring</"
"varname> to a topology connecting two existing isolated nodes "
"<varname>anode</varname> and <varname>anothernode</varname> and returns the "
"edge id of the new edge.</refpurpose>"
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:969
#, no-c-format
msgid ""
"<funcdef>integer <function>ST_AddIsoEdge</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anothernode</parameter></"
"paramdef> <paramdef><type>geometry </type> <parameter>alinestring</"
"parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>ST_AddIsoEdge</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anothernode</parameter></"
"paramdef> <paramdef><type>geometry </type> <parameter>alinestring</"
"parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:982
#, no-c-format
msgid ""
"<para>Adds an isolated edge defined by geometry <varname>alinestring</"
"varname> to a topology connecting two existing isolated nodes "
"<varname>anode</varname> and <varname>anothernode</varname> and returns the "
"edge id of the new edge.</para>"
msgstr ""

#. Tag: para
#: extras_topology.xml:983
#, no-c-format
msgid ""
"If the spatial reference system (srid) of the <varname>alinestring</varname> "
"geometry is not the same as the topology, any of the input arguments are "
"null, or the nodes are contained in more than one face, or the nodes are "
"start or end nodes of an existing edge, then an exception is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:985
#, no-c-format
msgid ""
"If the <varname>alinestring</varname> is not within the face of the face the "
"<varname>anode</varname> and <varname>anothernode</varname> belong to, then "
"an exception is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:986
#, no-c-format
msgid ""
"If the <varname>anode</varname> and <varname>anothernode</varname> are not "
"the start and end points of the <varname>alinestring</varname> then an "
"exception is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:990
#, no-c-format
msgid ""
"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.4"
msgstr ""

#. Tag: para
#: extras_topology.xml:1003
#, no-c-format
msgid ", <xref linkend=\"ST_IsSimple\"/>, <xref linkend=\"ST_Within\"/>"
msgstr ", <xref linkend=\"ST_IsSimple\"/>, <xref linkend=\"ST_Within\"/>"

#. Tag: refname
#: extras_topology.xml:1009
#, no-c-format
msgid "ST_AddEdgeNewFaces"
msgstr "ST_AddEdgeNewFaces"

#. Tag: refpurpose
#: extras_topology.xml:1011
#, no-c-format
msgid ""
"Add a new edge and, if in doing so it splits a face, delete the original "
"face and replace it with two new faces."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1016
#, no-c-format
msgid ""
"<funcdef>integer <function>ST_AddEdgeNewFaces</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anothernode</parameter></"
"paramdef> <paramdef><type>geometry </type> <parameter>acurve</parameter></"
"paramdef>"
msgstr ""
"<funcdef>integer <function>ST_AddEdgeNewFaces</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anothernode</parameter></"
"paramdef> <paramdef><type>geometry </type> <parameter>acurve</parameter></"
"paramdef>"

#. Tag: para
#: extras_topology.xml:1029
#, no-c-format
msgid ""
"Add a new edge and, if in doing so it splits a face, delete the original "
"face and replace it with two new faces. Returns the id of the newly added "
"edge."
msgstr ""

#. Tag: para
#: extras_topology.xml:1035 extras_topology.xml:1101 extras_topology.xml:1164
#: extras_topology.xml:1232
#, no-c-format
msgid "Updates all existing joined edges and relationships accordingly."
msgstr ""

#. Tag: para
#: extras_topology.xml:1039 extras_topology.xml:1105
#, no-c-format
msgid ""
"If any arguments are null, the given nodes are unknown (must already exist "
"in the <varname>node</varname> table of the topology schema) , the "
"<varname>acurve</varname> is not a <varname>LINESTRING</varname>, the "
"<varname>anode</varname> and <varname>anothernode</varname> are not the "
"start and endpoints of <varname>acurve</varname> then an error is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:1042 extras_topology.xml:1108 extras_topology.xml:1303
#, no-c-format
msgid ""
"If the spatial reference system (srid) of the <varname>acurve</varname> "
"geometry is not the same as the topology an exception is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:1046
#, no-c-format
msgid ""
"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.12"
msgstr ""

#. Tag: refname
#: extras_topology.xml:1066
#, no-c-format
msgid "ST_AddEdgeModFace"
msgstr "ST_AddEdgeModFace"

#. Tag: refpurpose
#: extras_topology.xml:1068
#, no-c-format
msgid ""
"Add a new edge and, if in doing so it splits a face, modify the original "
"face and add a new face."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1073
#, no-c-format
msgid ""
"<funcdef>integer <function>ST_AddEdgeModFace</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anothernode</parameter></"
"paramdef> <paramdef><type>geometry </type> <parameter>acurve</parameter></"
"paramdef>"
msgstr ""
"<funcdef>integer <function>ST_AddEdgeModFace</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anothernode</parameter></"
"paramdef> <paramdef><type>geometry </type> <parameter>acurve</parameter></"
"paramdef>"

#. Tag: para
#: extras_topology.xml:1086
#, no-c-format
msgid ""
"Add a new edge and, if doing so splits a face, modify the original face and "
"add a new one."
msgstr ""

#. Tag: para
#: extras_topology.xml:1091
#, no-c-format
msgid ""
"If possible, the new face will be created on left side of the new edge. This "
"will not be possible if the face on the left side will need to be the "
"Universe face (unbounded)."
msgstr ""

#. Tag: para
#: extras_topology.xml:1097
#, no-c-format
msgid "Returns the id of the newly added edge."
msgstr ""

#. Tag: para
#: extras_topology.xml:1111
#, no-c-format
msgid ""
"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.13"
msgstr ""

#. Tag: refname
#: extras_topology.xml:1131
#, no-c-format
msgid "ST_RemEdgeNewFace"
msgstr "ST_RemEdgeNewFace"

#. Tag: refpurpose
#: extras_topology.xml:1133
#, no-c-format
msgid ""
"<refpurpose>Removes an edge and, if the removed edge separated two faces, "
"delete the original faces and replace them with a new face.</refpurpose>"
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1141
#, no-c-format
msgid ""
"<funcdef>integer <function>ST_RemEdgeNewFace</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>ST_RemEdgeNewFace</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:1152
#, no-c-format
msgid ""
"<para>Removes an edge and, if the removed edge separated two faces, delete "
"the original faces and replace them with a new face.</para>"
msgstr ""

#. Tag: para
#: extras_topology.xml:1157
#, no-c-format
msgid ""
"Returns the id of a newly created face or NULL, if no new face is created. "
"No new face is created when the removed edge is dangling or isolated or "
"confined with the universe face (possibly making the universe flood into the "
"face on the other side)."
msgstr ""

#. Tag: para
#: extras_topology.xml:1168
#, no-c-format
msgid ""
"Refuses to remove an edge participating in the definition of an existing "
"TopoGeometry. Refuses to heal two faces if any TopoGeometry is defined by "
"only one of them (and not the other)."
msgstr ""

#. Tag: para
#: extras_topology.xml:1175 extras_topology.xml:1243
#, no-c-format
msgid ""
"If any arguments are null, the given edge is unknown (must already exist in "
"the <varname>edge</varname> table of the topology schema), the topology name "
"is invalid then an error is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:1183
#, no-c-format
msgid ""
"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.14"
msgstr ""

#. Tag: refname
#: extras_topology.xml:1203
#, no-c-format
msgid "ST_RemEdgeModFace"
msgstr "ST_RemEdgeModFace"

#. Tag: refpurpose
#: extras_topology.xml:1205
#, no-c-format
msgid ""
"Removes an edge and, if the removed edge separated two faces, delete one of "
"the them and modify the other to take the space of both."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1213
#, no-c-format
msgid ""
"<funcdef>integer <function>ST_RemEdgeModFace</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef>"
msgstr ""

#. Tag: para
#: extras_topology.xml:1224
#, no-c-format
msgid ""
"Removes an edge and, if the removed edge separated two faces, delete one of "
"the them and modify the other to take the space of both. Preferentially "
"keeps the face on the right, to be symmetric with ST_AddEdgeModFace also "
"keeping it. Returns the id of the face remaining in place of the removed "
"edge."
msgstr ""

#. Tag: para
#: extras_topology.xml:1236
#, no-c-format
msgid ""
"Refuses to remove an edge partecipating in the definition of an existing "
"TopoGeometry. Refuses to heal two faces if any TopoGeometry is defined by "
"only one of them (and not the other)."
msgstr ""

#. Tag: para
#: extras_topology.xml:1251
#, no-c-format
msgid ""
"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.15"
msgstr ""

#. Tag: refname
#: extras_topology.xml:1271
#, no-c-format
msgid "ST_ChangeEdgeGeom"
msgstr "ST_ChangeEdgeGeom"

#. Tag: refpurpose
#: extras_topology.xml:1273
#, no-c-format
msgid ""
"<refpurpose>Changes the shape of an edge without affecting the topology "
"structure.</refpurpose>"
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1280
#, no-c-format
msgid ""
"<funcdef>integer <function>ST_ChangeEdgeGeom</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>acurve</parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>ST_ChangeEdgeGeom</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>acurve</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:1292
#, no-c-format
msgid ""
"<para>Changes the shape of an edge without affecting the topology structure."
"</para>"
msgstr ""

#. Tag: para
#: extras_topology.xml:1295
#, no-c-format
msgid ""
"If any arguments are null, the given edge does not exist in the "
"<varname>edge</varname> table of the topology schema, the <varname>acurve</"
"varname> is not a <varname>LINESTRING</varname>, the <varname>anode</"
"varname> and <varname>anothernode</varname> are not the start and endpoints "
"of <varname>acurve</varname> or the modification would change the underlying "
"topology then an error is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:1304
#, no-c-format
msgid ""
"If the new <varname>acurve</varname> is not simple, then an error is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:1306
#, no-c-format
msgid ""
"If moving the edge from old to new position would hit an obstacle then an "
"error is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:1312 extras_topology.xml:3074 extras_topology.xml:3127
#, no-c-format
msgid "Availability: 1.1.0"
msgstr "Disponibilità: 1.1.0"

#. Tag: para
#: extras_topology.xml:1315
#, no-c-format
msgid "Enhanced: 2.0.0 adds topological consistency enforcement"
msgstr ""

#. Tag: para
#: extras_topology.xml:1319
#, no-c-format
msgid ""
"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details X.3.6"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1325
#, no-c-format
msgid ""
"SELECT topology.ST_ChangeEdgeGeom('ma_topo', 1,\n"
"                ST_GeomFromText('LINESTRING(227591.9 893900.4,227622.6 "
"893844.3,227641.6 893816.6, 227704.5 893778.5)', 26986) );\n"
" ----\n"
" Edge 1 changed"
msgstr ""

#. Tag: refname
#: extras_topology.xml:1339
#, no-c-format
msgid "ST_ModEdgeSplit"
msgstr "ST_ModEdgeSplit"

#. Tag: refpurpose
#: extras_topology.xml:1341
#, no-c-format
msgid ""
"Split an edge by creating a new node along an existing edge, modifying the "
"original edge and adding a new edge."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1346
#, no-c-format
msgid ""
"<funcdef>integer <function>ST_ModEdgeSplit</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>"
msgstr ""

#. Tag: para
#: extras_topology.xml:1358
#, no-c-format
msgid ""
"Split an edge by creating a new node along an existing edge, modifying the "
"original edge and adding a new edge. Updates all existing joined edges and "
"relationships accordingly. Returns the identifier of the newly added node."
msgstr ""

#. Tag: para
#: extras_topology.xml:1367
#, no-c-format
msgid "Changed: 2.0 - In prior versions, this was misnamed ST_ModEdgesSplit"
msgstr ""

#. Tag: para
#: extras_topology.xml:1368 extras_topology.xml:1422 extras_topology.xml:1472
#, no-c-format
msgid ""
"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X.3.9"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1374
#, no-c-format
msgid ""
"-- Add an edge --\n"
" SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227592 "
"893910, 227600 893910)', 26986) ) As edgeid;\n"
"\n"
"-- edgeid-\n"
"3\n"
"\n"
"\n"
"-- Split the edge  --\n"
"SELECT topology.ST_ModEdgeSplit('ma_topo',  3, "
"ST_SetSRID(ST_Point(227594,893910),26986)  ) As node_id;\n"
"        node_id\n"
"-------------------------\n"
"7"
msgstr ""

#. Tag: para
#: extras_topology.xml:1380
#, no-c-format
msgid ""
", <xref linkend=\"ST_ModEdgeHeal\"/>, <xref linkend=\"ST_NewEdgeHeal\"/>, "
"<xref linkend=\"AddEdge\"/>"
msgstr ""
", <xref linkend=\"ST_ModEdgeHeal\"/>, <xref linkend=\"ST_NewEdgeHeal\"/>, "
"<xref linkend=\"AddEdge\"/>"

#. Tag: refname
#: extras_topology.xml:1391
#, no-c-format
msgid "ST_ModEdgeHeal"
msgstr "ST_ModEdgeHeal"

#. Tag: refpurpose
#: extras_topology.xml:1393
#, no-c-format
msgid ""
"Heals two edges by deleting the node connecting them, modifying the first "
"edge and deleting the second edge. Returns the id of the deleted node."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1401
#, no-c-format
msgid ""
"<funcdef>int <function>ST_ModEdgeHeal</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anotheredge</parameter></paramdef>"
msgstr ""
"<funcdef>int <function>ST_ModEdgeHeal</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anotheredge</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:1413
#, no-c-format
msgid ""
"Heals two edges by deleting the node connecting them, modifying the first "
"edge and deleting the second edge. Returns the id of the deleted node. "
"Updates all existing joined edges and relationships accordingly."
msgstr ""

#. Tag: refname
#: extras_topology.xml:1438
#, no-c-format
msgid "ST_NewEdgeHeal"
msgstr "ST_NewEdgeHeal"

#. Tag: refpurpose
#: extras_topology.xml:1440
#, no-c-format
msgid ""
"Heals two edges by deleting the node connecting them, deleting both edges, "
"and replacing them with an edge whose direction is the same as the first "
"edge provided."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1449
#, no-c-format
msgid ""
"<funcdef>int <function>ST_NewEdgeHeal</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anotheredge</parameter></paramdef>"
msgstr ""
"<funcdef>int <function>ST_NewEdgeHeal</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anotheredge</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:1461
#, no-c-format
msgid ""
"Heals two edges by deleting the node connecting them, deleting both edges, "
"and replacing them with an edge whose direction is the same as the first "
"edge provided. Returns the id of the new edge replacing the healed ones. "
"Updates all existing joined edges and relationships accordingly."
msgstr ""

#. Tag: refname
#: extras_topology.xml:1489
#, no-c-format
msgid "ST_MoveIsoNode"
msgstr "ST_MoveIsoNode"

#. Tag: refpurpose
#: extras_topology.xml:1491
#, no-c-format
msgid ""
"Moves an isolated node in a topology from one point to another. If new "
"<varname>apoint</varname> geometry exists as a node an error is thrown. "
"Returns description of move."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1496
#, no-c-format
msgid ""
"<funcdef>text <function>ST_MoveIsoNode</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>"
msgstr ""
"<funcdef>text <function>ST_MoveIsoNode</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:1508
#, no-c-format
msgid ""
"Moves an isolated node in a topology from one point to another. If new "
"<varname>apoint</varname> geometry exists as a node an error is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:1509
#, no-c-format
msgid ""
"If any arguments are null, the <varname>apoint</varname> is not a point, the "
"existing node is not isolated (is a start or end point of an existing edge), "
"new node location intersects an existing edge (even at the end points) then "
"an exception is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:1510
#, no-c-format
msgid ""
"If the spatial reference system (srid) of the point geometry is not the same "
"as the topology an exception is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:1515
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM: Topo-Net Routines: X.3.2"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1521
#, no-c-format
msgid ""
"-- Add an isolated node with no face  --\n"
"SELECT topology.ST_AddIsoNode('ma_topo',  NULL, "
"ST_GeomFromText('POINT(227579 893916)', 26986) ) As nodeid;\n"
" nodeid\n"
"--------\n"
"      7\n"
"-- Move the new node --\n"
"SELECT topology.ST_MoveIsoNode('ma_topo', 7,  "
"ST_GeomFromText('POINT(227579.5 893916.5)', 26986) ) As descrip;\n"
"                      descrip\n"
"----------------------------------------------------\n"
"Isolated Node 7 moved to location 227579.5,893916.5"
msgstr ""

#. Tag: refname
#: extras_topology.xml:1532
#, no-c-format
msgid "ST_NewEdgesSplit"
msgstr "ST_NewEdgesSplit"

#. Tag: refpurpose
#: extras_topology.xml:1534
#, no-c-format
msgid ""
"Split an edge by creating a new node along an existing edge, deleting the "
"original edge and replacing it with two new edges. Returns the id of the new "
"node created that joins the new edges."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1539
#, no-c-format
msgid ""
"<funcdef>integer <function>ST_NewEdgesSplit</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>ST_NewEdgesSplit</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:1551
#, no-c-format
msgid ""
"Split an edge with edge id <varname>anedge</varname> by creating a new node "
"with point location <varname>apoint</varname> along current edge, deleting "
"the original edge and replacing it with two new edges. Returns the id of the "
"new node created that joins the new edges. Updates all existing joined edges "
"and relationships accordingly."
msgstr ""

#. Tag: para
#: extras_topology.xml:1559
#, no-c-format
msgid ""
"If the spatial reference system (srid) of the point geometry is not the same "
"as the topology, the <varname>apoint</varname> is not a point geometry, the "
"point is null, the point already exists as a node, the edge does not "
"correspond to an existing edge or the point is not within the edge then an "
"exception is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:1564
#, no-c-format
msgid "&sqlmm_compliant; SQL-MM: Topo-Net Routines: X.3.8"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1570
#, no-c-format
msgid ""
"-- Add an edge  --\n"
"SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227575 "
"893917,227592 893900)', 26986) ) As edgeid;\n"
"-- result-\n"
"edgeid\n"
"------\n"
"        2\n"
"-- Split the new edge --\n"
"SELECT topology.ST_NewEdgesSplit('ma_topo', 2,  "
"ST_GeomFromText('POINT(227578.5 893913.5)', 26986) ) As newnodeid;\n"
" newnodeid\n"
"---------\n"
"       6"
msgstr ""

#. Tag: refname
#: extras_topology.xml:1587
#, no-c-format
msgid "ST_RemoveIsoNode"
msgstr "ST_RemoveIsoNode"

#. Tag: refpurpose
#: extras_topology.xml:1589
#, no-c-format
msgid ""
"<refpurpose>Removes an isolated node and returns description of action. If "
"the node is not isolated (is start or end of an edge), then an exception is "
"thrown.</refpurpose>"
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1594
#, no-c-format
msgid ""
"<funcdef>text <function>ST_RemoveIsoNode</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef>"
msgstr ""
"<funcdef>text <function>ST_RemoveIsoNode</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:1605
#, no-c-format
msgid ""
"<para>Removes an isolated node and returns description of action. If the "
"node is not isolated (is start or end of an edge), then an exception is "
"thrown.</para>"
msgstr ""

#. Tag: para
#: extras_topology.xml:1610 extras_topology.xml:1651
#, no-c-format
msgid ""
"&sqlmm_compliant; SQL-MM: Topo-Geo and Topo-Net 3: Routine Details: X+1.3.3"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1616 extras_topology.xml:1657
#, no-c-format
msgid ""
"-- Remove an isolated node with no face  --\n"
"SELECT topology.ST_RemoveIsoNode('ma_topo',  7 ) As result;\n"
"         result\n"
"-------------------------\n"
" Isolated node 7 removed"
msgstr ""

#. Tag: refname
#: extras_topology.xml:1628
#, no-c-format
msgid "ST_RemoveIsoEdge"
msgstr ""

#. Tag: refpurpose
#: extras_topology.xml:1630
#, no-c-format
msgid ""
"<refpurpose>Removes an isolated edge and returns description of action. If "
"the edge is not isolated, then an exception is thrown.</refpurpose>"
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1635
#, no-c-format
msgid ""
"<funcdef>text <function>ST_RemoveIsoEdge</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anedge</parameter></paramdef>"
msgstr ""

#. Tag: para
#: extras_topology.xml:1646
#, no-c-format
msgid ""
"<para>Removes an isolated edge and returns description of action. If the "
"edge is not isolated, then an exception is thrown.</para>"
msgstr ""

#. Tag: title
#: extras_topology.xml:1670
#, no-c-format
msgid "Topology Accessors"
msgstr ""

#. Tag: refname
#: extras_topology.xml:1673
#, no-c-format
msgid "GetEdgeByPoint"
msgstr "GetEdgeByPoint"

#. Tag: refpurpose
#: extras_topology.xml:1675
#, no-c-format
msgid "Finds the edge-id of an edge that intersects a given point."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1680
#, fuzzy, no-c-format
msgid ""
"<funcdef>integer <function>GetEdgeByPoint</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> "
"<paramdef><type>float8 </type> <parameter>tol1</parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>GetEdgeByPoint</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> "
"<paramdef><type>float8 </type> <parameter>tol</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:1693
#, no-c-format
msgid "Retrieves the id of an edge that intersects a Point."
msgstr ""

#. Tag: para
#: extras_topology.xml:1694
#, no-c-format
msgid ""
"The function returns an integer (id-edge) given a topology, a POINT and a "
"tolerance. If tolerance = 0 then the point has to intersect the edge."
msgstr ""

#. Tag: para
#: extras_topology.xml:1695
#, no-c-format
msgid ""
"If <varname>apoint</varname> doesn't intersect an edge, returns 0 (zero)."
msgstr ""

#. Tag: para
#: extras_topology.xml:1696
#, no-c-format
msgid ""
"If use tolerance > 0 and there is more than one edge near the point then an "
"exception is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:1700 extras_topology.xml:1749 extras_topology.xml:1798
#, no-c-format
msgid ""
"If tolerance = 0, the function uses ST_Intersects otherwise uses ST_DWithin."
msgstr ""

#. Tag: para
#: extras_topology.xml:1702 extras_topology.xml:1751 extras_topology.xml:1800
#: extras_topology.xml:2286 extras_topology.xml:2404
#, no-c-format
msgid "Performed by the GEOS module."
msgstr "Eseguito dal modulo GEOS"

#. Tag: para
#: extras_topology.xml:1709 extras_topology.xml:1807
#, no-c-format
msgid "These examples use edges we created in <xref linkend=\"AddEdge\"/>"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1710
#, no-c-format
msgid ""
"SELECT topology.GetEdgeByPoint('ma_topo',geom, 1) As with1mtol, topology."
"GetEdgeByPoint('ma_topo',geom,0) As withnotol\n"
"FROM ST_GeomFromEWKT('SRID=26986;POINT(227622.6 893843)') As geom;\n"
" with1mtol | withnotol\n"
"-----------+-----------\n"
"         2 |         0"
msgstr ""
"SELECT topology.GetEdgeByPoint('ma_topo',geom, 1) As with1mtol, topology."
"GetEdgeByPoint('ma_topo',geom,0) As withnotol\n"
"FROM ST_GeomFromEWKT('SRID=26986;POINT(227622.6 893843)') As geom;\n"
" with1mtol | withnotol\n"
"-----------+-----------\n"
"         2 |         0"

#. Tag: programlisting
#: extras_topology.xml:1711
#, no-c-format
msgid ""
"SELECT topology.GetEdgeByPoint('ma_topo',geom, 1) As nearnode\n"
"FROM ST_GeomFromEWKT('SRID=26986;POINT(227591.9 893900.4)') As geom;\n"
"\n"
"-- get error --\n"
"ERROR:  Two or more edges found"
msgstr ""
"SELECT topology.GetEdgeByPoint('ma_topo',geom, 1) As nearnode\n"
"FROM ST_GeomFromEWKT('SRID=26986;POINT(227591.9 893900.4)') As geom;\n"
"\n"
"-- get error --\n"
"ERROR:  Two or more edges found"

#. Tag: para
#: extras_topology.xml:1718
#, no-c-format
msgid ""
", <xref linkend=\"GetNodeByPoint\"/>, <xref linkend=\"GetFaceByPoint\"/>"
msgstr ""

#. Tag: refname
#: extras_topology.xml:1728
#, no-c-format
msgid "GetFaceByPoint"
msgstr "GetFaceByPoint"

#. Tag: refpurpose
#: extras_topology.xml:1729
#, no-c-format
msgid "Finds the face-id of a face that intersects a given point."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1733
#, fuzzy, no-c-format
msgid ""
"<funcdef>integer <function>GetFaceByPoint</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> "
"<paramdef><type>float8 </type> <parameter>tol1</parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>GetFaceByPoint</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> "
"<paramdef><type>float8 </type> <parameter>tol</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:1744
#, no-c-format
msgid "Retrieves the id of a face that intersects a Point."
msgstr ""

#. Tag: para
#: extras_topology.xml:1745
#, no-c-format
msgid ""
"The function returns an integer (id-face) given a topology, a POINT and a "
"tolerance. If tolerance = 0 then the point has to intersect the face."
msgstr ""

#. Tag: para
#: extras_topology.xml:1746
#, no-c-format
msgid ""
"If <varname>apoint</varname> doesn't intersect a face, returns 0 (zero)."
msgstr ""

#. Tag: para
#: extras_topology.xml:1747
#, no-c-format
msgid ""
"If use tolerance > 0 and there is more than one face near the point then an "
"exception is thrown."
msgstr ""

#. Tag: para
#: extras_topology.xml:1756
#, no-c-format
msgid "These examples use edges faces created in <xref linkend=\"AddFace\"/>"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1757
#, no-c-format
msgid ""
"SELECT topology.GetFaceByPoint('ma_topo',geom, 10) As with1mtol, topology."
"GetFaceByPoint('ma_topo',geom,0) As withnotol\n"
"        FROM ST_GeomFromEWKT('POINT(234604.6 899382.0)') As geom;\n"
"\n"
"         with1mtol | withnotol\n"
"        -----------+-----------\n"
"                         1 |         0"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1758
#, no-c-format
msgid ""
"SELECT topology.GetFaceByPoint('ma_topo',geom, 1) As nearnode\n"
"        FROM ST_GeomFromEWKT('POINT(227591.9 893900.4)') As geom;\n"
"\n"
"-- get error --\n"
"ERROR:  Two or more faces found"
msgstr ""

#. Tag: para
#: extras_topology.xml:1763
#, no-c-format
msgid ""
", <xref linkend=\"GetNodeByPoint\"/>, <xref linkend=\"GetEdgeByPoint\"/>"
msgstr ""
", <xref linkend=\"GetNodeByPoint\"/>, <xref linkend=\"GetEdgeByPoint\"/>"

#. Tag: refname
#: extras_topology.xml:1773
#, no-c-format
msgid "GetNodeByPoint"
msgstr "GetNodeByPoint"

#. Tag: refpurpose
#: extras_topology.xml:1775
#, no-c-format
msgid "Finds the node-id of a node at a point location."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1780
#, fuzzy, no-c-format
msgid ""
"<funcdef>integer <function>GetNodeByPoint</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> "
"<paramdef><type>float8 </type> <parameter>tol1</parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>GetNodeByPoint</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>point</parameter></paramdef> "
"<paramdef><type>float8 </type> <parameter>tol</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:1793
#, no-c-format
msgid "Retrieves the id of a node at a point location."
msgstr ""

#. Tag: para
#: extras_topology.xml:1794
#, no-c-format
msgid ""
"The function returns an integer (id-node) given a topology, a POINT and a "
"tolerance. If tolerance = 0 means exact intersection, otherwise retrieves "
"the node from an interval."
msgstr ""

#. Tag: para
#: extras_topology.xml:1795
#, no-c-format
msgid ""
"If <varname>apoint</varname> doesn't intersect a node, returns 0 (zero)."
msgstr ""

#. Tag: para
#: extras_topology.xml:1796
#, no-c-format
msgid ""
"If use tolerance > 0 and there is more than one node near the point then an "
"exception is thrown."
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1808
#, no-c-format
msgid ""
"SELECT topology.GetNodeByPoint('ma_topo',geom, 1) As nearnode\n"
" FROM ST_GeomFromEWKT('SRID=26986;POINT(227591.9 893900.4)') As geom;\n"
"  nearnode\n"
"----------\n"
"        2"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1809
#, no-c-format
msgid ""
"SELECT topology.GetNodeByPoint('ma_topo',geom, 1000) As too_much_tolerance\n"
" FROM ST_GeomFromEWKT('SRID=26986;POINT(227591.9 893900.4)') As geom;\n"
"\n"
" ----get error--\n"
" ERROR:  Two or more nodes found"
msgstr ""

#. Tag: para
#: extras_topology.xml:1816
#, no-c-format
msgid ""
", <xref linkend=\"GetEdgeByPoint\"/>, <xref linkend=\"GetFaceByPoint\"/>"
msgstr ""

#. Tag: refname
#: extras_topology.xml:1826
#, no-c-format
msgid "GetTopologyID"
msgstr "GetTopologyID"

#. Tag: refpurpose
#: extras_topology.xml:1828
#, no-c-format
msgid ""
"<refpurpose>Returns the id of a topology in the topology.topology table "
"given the name of the topology.</refpurpose>"
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1833 extras_topology.xml:1875
#, no-c-format
msgid ""
"<funcdef>integer <function>GetTopologyID</function></funcdef> "
"<paramdef><type>varchar</type> <parameter>toponame</parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>GetTopologyID</function></funcdef> "
"<paramdef><type>varchar</type> <parameter>toponame</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:1843
#, no-c-format
msgid ""
"<para>Returns the id of a topology in the topology.topology table given the "
"name of the topology.</para>"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1851
#, no-c-format
msgid ""
"SELECT topology.GetTopologyID('ma_topo') As topo_id;\n"
" topo_id\n"
"---------\n"
"       1"
msgstr ""
"SELECT topology.GetTopologyID('ma_topo') As topo_id;\n"
" topo_id\n"
"---------\n"
"       1"

#. Tag: para
#: extras_topology.xml:1857
#, no-c-format
msgid ""
", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyName\"/>, "
"<xref linkend=\"GetTopologySRID\"/>"
msgstr ""

#. Tag: refname
#: extras_topology.xml:1868
#, no-c-format
msgid "GetTopologySRID"
msgstr "GetTopologySRID"

#. Tag: refpurpose
#: extras_topology.xml:1870
#, no-c-format
msgid ""
"Returns the SRID of a topology in the topology.topology table given the name "
"of the topology."
msgstr ""

#. Tag: para
#: extras_topology.xml:1885
#, no-c-format
msgid ""
"Returns the spatial reference id of a topology in the topology.topology "
"table given the name of the topology."
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1893
#, no-c-format
msgid ""
"SELECT topology.GetTopologySRID('ma_topo') As SRID;\n"
" SRID\n"
"-------\n"
"  4326"
msgstr ""
"SELECT topology.GetTopologySRID('ma_topo') As SRID;\n"
" SRID\n"
"-------\n"
"  4326"

#. Tag: para
#: extras_topology.xml:1899
#, no-c-format
msgid ""
", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyName\"/>, "
"<xref linkend=\"GetTopologyID\"/>"
msgstr ""
", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyName\"/>, "
"<xref linkend=\"GetTopologyID\"/>"

#. Tag: refname
#: extras_topology.xml:1910
#, no-c-format
msgid "GetTopologyName"
msgstr "GetTopologyName"

#. Tag: refpurpose
#: extras_topology.xml:1912
#, no-c-format
msgid "Returns the name of a topology (schema) given the id of the topology."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1917
#, no-c-format
msgid ""
"<funcdef>varchar <function>GetTopologyName</function></funcdef> "
"<paramdef><type>integer</type> <parameter>topology_id</parameter></paramdef>"
msgstr ""
"<funcdef>varchar <function>GetTopologyName</function></funcdef> "
"<paramdef><type>integer</type> <parameter>topology_id</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:1927
#, no-c-format
msgid ""
"Returns the topology name (schema) of a topology from the topology.topology "
"table given the topology id of the topology."
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1935
#, no-c-format
msgid ""
"SELECT topology.GetTopologyName(1) As topo_name;\n"
" topo_name\n"
"-----------\n"
" ma_topo"
msgstr ""
"SELECT topology.GetTopologyName(1) As topo_name;\n"
" topo_name\n"
"-----------\n"
" ma_topo"

#. Tag: para
#: extras_topology.xml:1941
#, no-c-format
msgid ""
", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyID\"/>, <xref "
"linkend=\"GetTopologySRID\"/>"
msgstr ""
", <xref linkend=\"DropTopology\"/>, <xref linkend=\"GetTopologyID\"/>, <xref "
"linkend=\"GetTopologySRID\"/>"

#. Tag: refname
#: extras_topology.xml:1952
#, no-c-format
msgid "ST_GetFaceEdges"
msgstr "ST_GetFaceEdges"

#. Tag: refpurpose
#: extras_topology.xml:1954
#, no-c-format
msgid "Returns a set of ordered edges that bound <varname>aface</varname>."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:1959
#, no-c-format
msgid ""
"<funcdef>getfaceedges_returntype <function>ST_GetFaceEdges</function></"
"funcdef> <paramdef><type>varchar </type> <parameter>atopology</parameter></"
"paramdef> <paramdef><type>integer </type> <parameter>aface</parameter></"
"paramdef>"
msgstr ""
"<funcdef>getfaceedges_returntype <function>ST_GetFaceEdges</function></"
"funcdef> <paramdef><type>varchar </type> <parameter>atopology</parameter></"
"paramdef> <paramdef><type>integer </type> <parameter>aface</parameter></"
"paramdef>"

#. Tag: para
#: extras_topology.xml:1970
#, no-c-format
msgid ""
"Returns a set of ordered edges that bound <varname>aface</varname>. Each "
"output consists of a sequence and edgeid. Sequence numbers start with value "
"1."
msgstr ""

#. Tag: para
#: extras_topology.xml:1972
#, no-c-format
msgid ""
"Enumeration of each ring edges start from the edge with smallest identifier. "
"Order of edges follows a left-hand-rule (bound face is on the left of each "
"directed edge)."
msgstr ""

#. Tag: para
#: extras_topology.xml:1979
#, no-c-format
msgid ""
"&sqlmm_compliant; SQL-MM 3 Topo-Geo and Topo-Net 3: Routine Details: X.3.5"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1985
#, no-c-format
msgid ""
"-- Returns the edges bounding face 1\n"
"SELECT (topology.ST_GetFaceEdges('tt', 1)).*;\n"
"-- result --\n"
" sequence | edge\n"
"----------+------\n"
"        1 |   -4\n"
"        2 |    5\n"
"        3 |    7\n"
"        4 |   -6\n"
"        5 |    1\n"
"        6 |    2\n"
"        7 |    3\n"
"(7 rows)"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:1986
#, no-c-format
msgid ""
"-- Returns the sequence, edge id\n"
"-- and geometry of the edges that bound face 1\n"
"-- If you just need geom and seq, can use ST_GetFaceGeometry\n"
"SELECT t.seq, t.edge, geom\n"
"FROM topology.ST_GetFaceEdges('tt',1) As t(seq,edge)\n"
"        INNER JOIN tt.edge AS e ON abs(t.edge) = e.edge_id;"
msgstr ""

#. Tag: para
#: extras_topology.xml:1992
#, no-c-format
msgid ", <xref linkend=\"AddFace\"/>, <xref linkend=\"ST_GetFaceGeometry\"/>"
msgstr ", <xref linkend=\"AddFace\"/>, <xref linkend=\"ST_GetFaceGeometry\"/>"

#. Tag: refname
#: extras_topology.xml:2002
#, no-c-format
msgid "ST_GetFaceGeometry"
msgstr "ST_GetFaceGeometry"

#. Tag: refpurpose
#: extras_topology.xml:2004
#, no-c-format
msgid "Returns the polygon in the given topology with the specified face id."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2009
#, no-c-format
msgid ""
"<funcdef>geometry <function>ST_GetFaceGeometry</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef>"
msgstr ""
"<funcdef>geometry <function>ST_GetFaceGeometry</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:2020
#, no-c-format
msgid ""
"Returns the polygon in the given topology with the specified face id. Builds "
"the polygon from the edges making up the face."
msgstr ""

#. Tag: para
#: extras_topology.xml:2025
#, no-c-format
msgid ""
"&sqlmm_compliant; SQL-MM 3 Topo-Geo and Topo-Net 3: Routine Details: X.3.16"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2031
#, no-c-format
msgid ""
"-- Returns the wkt of the polygon added with AddFace\n"
"SELECT ST_AsText(topology.ST_GetFaceGeometry('ma_topo', 1)) As facegeomwkt;\n"
"-- result --\n"
"               facegeomwkt\n"
"\n"
"--------------------------------------------------------------------------------\n"
" POLYGON((234776.9 899563.7,234896.5 899456.7,234914 899436.4,234946.6 "
"899356.9,\n"
"234872.5 899328.7,234891 899285.4,234992.5 899145,234890.6 899069,\n"
"234755.2 899255.4,234612.7 899379.4,234776.9 899563.7))"
msgstr ""

#. Tag: refname
#: extras_topology.xml:2043
#, no-c-format
msgid "GetRingEdges"
msgstr "GetRingEdges"

#. Tag: refpurpose
#: extras_topology.xml:2045
#, no-c-format
msgid ""
"Returns the ordered set of signed edge identifiers met by walking on an a "
"given edge side."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2053
#, no-c-format
msgid ""
"<funcdef>getfaceedges_returntype <function>GetRingEdges</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>aring</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>integer </type> <parameter>max_edges=null</"
"parameter></paramdef>"
msgstr ""
"<funcdef>getfaceedges_returntype <function>GetRingEdges</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>aring</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>integer </type> <parameter>max_edges=null</"
"parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:2065
#, no-c-format
msgid ""
"Returns the ordered set of signed edge identifiers met by walking on an a "
"given edge side. Each output consists of a sequence and a signed edge id. "
"Sequence numbers start with value 1."
msgstr ""

#. Tag: para
#: extras_topology.xml:2072
#, no-c-format
msgid ""
"If you pass a positive edge id, the walk starts on the left side of the "
"corresponding edge and follows the edge direction. If you pass a negative "
"edge id, the walk starts on the right side of it and goes backward."
msgstr ""

#. Tag: para
#: extras_topology.xml:2079
#, no-c-format
msgid ""
"If <varname>max_edges</varname> is not null no more than those records are "
"returned by that function. This is meant to be a safety parameter when "
"dealing with possibly invalid topologies."
msgstr ""

#. Tag: para
#: extras_topology.xml:2085
#, no-c-format
msgid "This function uses edge ring linking metadata."
msgstr ""

#. Tag: para
#: extras_topology.xml:2097
#, no-c-format
msgid ", <xref linkend=\"GetNodeEdges\"/>"
msgstr ", <xref linkend=\"GetNodeEdges\"/>"

#. Tag: refname
#: extras_topology.xml:2106
#, no-c-format
msgid "GetNodeEdges"
msgstr "GetNodeEdges"

#. Tag: refpurpose
#: extras_topology.xml:2108
#, no-c-format
msgid "Returns an ordered set of edges incident to the given node."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2115
#, no-c-format
msgid ""
"<funcdef>getfaceedges_returntype <function>GetNodeEdges</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef>"
msgstr ""
"<funcdef>getfaceedges_returntype <function>GetNodeEdges</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>anode</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:2126
#, no-c-format
msgid ""
"Returns an ordered set of edges incident to the given node. Each output "
"consists of a sequence and a signed edge id. Sequence numbers start with "
"value 1. A positive edge starts at the given node. A negative edge ends into "
"the given node. Closed edges will appear twice (with both signs). Order is "
"clockwise starting from northbound."
msgstr ""

#. Tag: para
#: extras_topology.xml:2137
#, no-c-format
msgid ""
"This function computes ordering rather than deriving from metadata and is "
"thus usable to build edge ring linking."
msgstr ""

#. Tag: para
#: extras_topology.xml:2150
#, no-c-format
msgid ", <xref linkend=\"ST_Azimuth\"/>"
msgstr ", <xref linkend=\"ST_Azimuth\"/>"

#. Tag: para
#: extras_topology.xml:2163
#, no-c-format
msgid ""
"This section covers the functions for processing topologies in non-standard "
"ways."
msgstr ""

#. Tag: title
#: extras_topology.xml:2166
#, no-c-format
msgid "Topology Processing"
msgstr ""

#. Tag: refname
#: extras_topology.xml:2169
#, no-c-format
msgid "Polygonize"
msgstr "Polygonize"

#. Tag: refpurpose
#: extras_topology.xml:2170
#, no-c-format
msgid "Finds and registers all faces defined by topology edges."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2174
#, no-c-format
msgid ""
"<funcdef>text <function>Polygonize</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef>"
msgstr ""
"<funcdef>text <function>Polygonize</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:2184
#, no-c-format
msgid "Registers all faces that can be built out a topology edge primitives."
msgstr ""

#. Tag: para
#: extras_topology.xml:2185
#, no-c-format
msgid "The target topology is assumed to contain no self-intersecting edges."
msgstr ""

#. Tag: para
#: extras_topology.xml:2186
#, no-c-format
msgid ""
"Already known faces are recognized, so it is safe to call Polygonize "
"multiple times on the same topology."
msgstr ""

#. Tag: para
#: extras_topology.xml:2187 extras_topology.xml:2339
#, no-c-format
msgid ""
"This function does not use nor set the next_left_edge and next_right_edge "
"fields of the edge table."
msgstr ""

#. Tag: para
#: extras_topology.xml:2199
#, no-c-format
msgid ", <xref linkend=\"ST_Polygonize\"/>"
msgstr ", <xref linkend=\"ST_Polygonize\"/>"

#. Tag: refname
#: extras_topology.xml:2205
#, no-c-format
msgid "AddNode"
msgstr "AddNode"

#. Tag: refpurpose
#: extras_topology.xml:2207
#, no-c-format
msgid ""
"Adds a point node to the node table in the specified topology schema and "
"returns the nodeid of new node. If point already exists as node, the "
"existing nodeid is returned."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2212
#, no-c-format
msgid ""
"<funcdef>integer <function>AddNode</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>boolean </type> "
"<parameter>allowEdgeSplitting=false</parameter></paramdef> <paramdef choice="
"\"opt\"><type>boolean </type> <parameter>computeContainingFace=false</"
"parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>AddNode</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apoint</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>boolean </type> "
"<parameter>allowEdgeSplitting=false</parameter></paramdef> <paramdef choice="
"\"opt\"><type>boolean </type> <parameter>computeContainingFace=false</"
"parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:2225
#, no-c-format
msgid ""
"Adds a point node to the node table in the specified topology schema. The "
"<xref linkend=\"AddEdge\"/> function automatically adds start and end points "
"of an edge when called so not necessary to explicitly add nodes of an edge."
msgstr ""

#. Tag: para
#: extras_topology.xml:2232
#, no-c-format
msgid ""
"If any edge crossing the node is found either an exception is raised or the "
"edge is split, depending on the <varname>allowEdgeSplitting</varname> "
"parameter value."
msgstr ""

#. Tag: para
#: extras_topology.xml:2238
#, no-c-format
msgid ""
"If <varname>computeContainingFace</varname> is true a newly added node would "
"get the correct containing face computed."
msgstr ""

#. Tag: para
#: extras_topology.xml:2243
#, no-c-format
msgid ""
"If the <varname>apoint</varname> geometry already exists as a node, the node "
"is not added but the existing nodeid is returned."
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2252
#, no-c-format
msgid ""
"SELECT topology.AddNode('ma_topo', ST_GeomFromText('POINT(227641.6 "
"893816.5)', 26986) ) As nodeid;\n"
"-- result --\n"
"nodeid\n"
"--------\n"
" 4"
msgstr ""
"SELECT topology.AddNode('ma_topo', ST_GeomFromText('POINT(227641.6 "
"893816.5)', 26986) ) As nodeid;\n"
"-- result --\n"
"nodeid\n"
"--------\n"
" 4"

#. Tag: refname
#: extras_topology.xml:2264
#, no-c-format
msgid "AddEdge"
msgstr "AddEdge"

#. Tag: refpurpose
#: extras_topology.xml:2266
#, no-c-format
msgid ""
"Adds a linestring edge to the edge table and associated start and end points "
"to the point nodes table of the specified topology schema using the "
"specified linestring geometry and returns the edgeid of the new (or "
"existing) edge."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2271
#, no-c-format
msgid ""
"<funcdef>integer <function>AddEdge</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>aline</parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>AddEdge</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>aline</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:2282
#, no-c-format
msgid ""
"Adds an edge to the edge table and associated nodes to the nodes table of "
"the specified <varname>toponame</varname> schema using the specified "
"linestring geometry and returns the edgeid of the new or existing record. "
"The newly added edge has \"universe\" face on both sides and links to itself."
msgstr ""

#. Tag: para
#: extras_topology.xml:2284
#, no-c-format
msgid ""
"If the <varname>aline</varname> geometry crosses, overlaps, contains or is "
"contained by an existing linestring edge, then an error is thrown and the "
"edge is not added."
msgstr ""

#. Tag: para
#: extras_topology.xml:2285
#, no-c-format
msgid ""
"The geometry of <varname>aline</varname> must have the same <varname>srid</"
"varname> as defined for the topology otherwise an invalid spatial reference "
"sys error will be thrown."
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2292
#, no-c-format
msgid ""
"SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227575.8 "
"893917.2,227591.9 893900.4)', 26986) ) As edgeid;\n"
"-- result-\n"
"edgeid\n"
"--------\n"
" 1\n"
"\n"
"SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227591.9 "
"893900.4,227622.6 893844.2,227641.6 893816.5,\n"
" 227704.5 893778.5)', 26986) ) As edgeid;\n"
"-- result --\n"
"edgeid\n"
"--------\n"
" 2\n"
"\n"
" SELECT topology.AddEdge('ma_topo', ST_GeomFromText('LINESTRING(227591.2 "
"893900, 227591.9 893900.4,\n"
"  227704.5 893778.5)', 26986) ) As edgeid;\n"
" -- gives error --\n"
" ERROR:  Edge intersects (not on endpoints) with existing edge 1"
msgstr ""

#. Tag: para
#: extras_topology.xml:2298 extras_topology.xml:2375
#, no-c-format
msgid ""
", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"spatial_ref_sys\"/>"
msgstr ""
", <xref linkend=\"CreateTopology\"/>, <xref linkend=\"spatial_ref_sys\"/>"

#. Tag: refname
#: extras_topology.xml:2308
#, no-c-format
msgid "AddFace"
msgstr "AddFace"

#. Tag: refpurpose
#: extras_topology.xml:2310
#, no-c-format
msgid ""
"<refpurpose>Registers a face primitive to a topology and gets its identifier."
"</refpurpose>"
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2315
#, no-c-format
msgid ""
"<funcdef>integer <function>AddFace</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apolygon</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>boolean </type> <parameter>force_new=false</"
"parameter></paramdef>"
msgstr ""
"<funcdef>integer <function>AddFace</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>toponame</parameter></paramdef> "
"<paramdef><type>geometry </type> <parameter>apolygon</parameter></paramdef> "
"<paramdef choice=\"opt\"><type>boolean </type> <parameter>force_new=false</"
"parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:2327
#, no-c-format
msgid ""
"<para>Registers a face primitive to a topology and gets its identifier.</"
"para>"
msgstr ""

#. Tag: para
#: extras_topology.xml:2331
#, no-c-format
msgid ""
"For a newly added face, the edges forming its boundaries and the ones "
"contained in the face will be updated to have correct values in the "
"left_face and right_face fields. Isolated nodes contained in the face will "
"also be updated to have a correct containing_face field value."
msgstr ""

#. Tag: para
#: extras_topology.xml:2343
#, no-c-format
msgid ""
"The target topology is assumed to be valid (containing no self-intersecting "
"edges). An exception is raised if: The polygon boundary is not fully defined "
"by existing edges or the polygon overlaps an existing face."
msgstr ""

#. Tag: para
#: extras_topology.xml:2345
#, no-c-format
msgid ""
"If the <varname>apolygon</varname> geometry already exists as a face, then: "
"if <varname>force_new</varname> is false (the default) the face id of the "
"existing face is returned; if <varname>force_new</varname> is true a new id "
"will be assigned to the newly registered face."
msgstr ""

#. Tag: para
#: extras_topology.xml:2353
#, no-c-format
msgid ""
"When a new registration of an existing face is performed (force_new=true), "
"no action will be taken to resolve dangling references to the existing face "
"in the edge, node an relation tables, nor will the MBR field of the existing "
"face record be updated. It is up to the caller to deal with that."
msgstr ""

#. Tag: para
#: extras_topology.xml:2360
#, no-c-format
msgid ""
"The <varname>apolygon</varname> geometry must have the same <varname>srid</"
"varname> as defined for the topology otherwise an invalid spatial reference "
"sys error will be thrown."
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2369
#, no-c-format
msgid ""
"-- first add the edges we use generate_series as an iterator (the below\n"
"-- will only work for polygons with &lt; 10000 points because of our max in "
"gs)\n"
"SELECT topology.AddEdge('ma_topo', ST_MakeLine(ST_PointN(geom,i), "
"ST_PointN(geom, i + 1) )) As edgeid\n"
"    FROM (SELECT  ST_NPoints(geom) AS npt, geom\n"
"            FROM\n"
"                (SELECT ST_Boundary(ST_GeomFromText('POLYGON((234896.5 "
"899456.7,234914 899436.4,234946.6 899356.9,234872.5 899328.7,\n"
"                234891 899285.4,234992.5 899145, 234890.6 899069,234755.2 "
"899255.4,\n"
"                234612.7 899379.4,234776.9 899563.7,234896.5 899456.7))', "
"26986) )  As geom\n"
"            )  As geoms) As facen CROSS JOIN generate_series(1,10000) As i\n"
"         WHERE i &lt; npt;\n"
"-- result --\n"
" edgeid\n"
"--------\n"
"      3\n"
"      4\n"
"      5\n"
"      6\n"
"      7\n"
"      8\n"
"      9\n"
"     10\n"
"     11\n"
"     12\n"
"(10 rows)\n"
"-- then add the face -\n"
"\n"
"SELECT topology.AddFace('ma_topo',\n"
"    ST_GeomFromText('POLYGON((234896.5 899456.7,234914 899436.4,234946.6 "
"899356.9,234872.5 899328.7,\n"
"    234891 899285.4,234992.5 899145, 234890.6 899069,234755.2 899255.4,\n"
"    234612.7 899379.4,234776.9 899563.7,234896.5 899456.7))', 26986) ) As "
"faceid;\n"
"-- result --\n"
"faceid\n"
"--------\n"
" 1"
msgstr ""

#. Tag: refname
#: extras_topology.xml:2381
#, no-c-format
msgid "ST_Simplify"
msgstr "ST_Simplify"

#. Tag: refpurpose
#: extras_topology.xml:2382
#, no-c-format
msgid ""
"Returns a \"simplified\" geometry version of the given TopoGeometry using "
"the Douglas-Peucker algorithm."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2388
#, fuzzy, no-c-format
msgid ""
"<funcdef>geometry <function>ST_Simplify</function></funcdef> "
"<paramdef><type>TopoGeometry</type> <parameter>tg</parameter></paramdef> "
"<paramdef><type>float8</type> <parameter>tolerance</parameter></paramdef>"
msgstr ""
"<funcdef>geometry <function>ST_GetFaceGeometry</function></funcdef> "
"<paramdef><type>varchar </type> <parameter>atopology</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>aface</parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:2398
#, no-c-format
msgid ""
"Returns a \"simplified\" geometry version of the given TopoGeometry using "
"the Douglas-Peucker algorithm on each component edge."
msgstr ""

#. Tag: para
#: extras_topology.xml:2401
#, no-c-format
msgid "The returned geometry may be non-simple or non-valid."
msgstr ""

#. Tag: para
#: extras_topology.xml:2402
#, no-c-format
msgid "Splitting component edges may help retaining simplicity/validity."
msgstr ""

#. Tag: para
#: extras_topology.xml:2405 extras_topology.xml:3022
#, no-c-format
msgid "Availability: 2.1.0"
msgstr ""

#. Tag: para
#: extras_topology.xml:2410
#, no-c-format
msgid ""
"Geometry <xref linkend=\"ST_Simplify\"/>, <xref linkend=\"ST_IsSimple\"/>, "
"<xref linkend=\"ST_IsValid\"/>, <xref linkend=\"ST_ModEdgeSplit\"/>"
msgstr ""

#. Tag: para
#: extras_topology.xml:2420
#, no-c-format
msgid ""
"This section covers the topology functions for creating new topogeometries."
msgstr ""

#. Tag: title
#: extras_topology.xml:2423
#, no-c-format
msgid "TopoGeometry Constructors"
msgstr ""

#. Tag: refname
#: extras_topology.xml:2426
#, no-c-format
msgid "CreateTopoGeom"
msgstr "CreateTopoGeom"

#. Tag: refpurpose
#: extras_topology.xml:2428
#, no-c-format
msgid ""
"Creates a new topo geometry object from topo element array - tg_type: 1:"
"[multi]point, 2:[multi]line, 3:[multi]poly, 4:collection"
msgstr ""

#. Tag: funcsynopsis
#: extras_topology.xml:2432
#, no-c-format
msgid ""
"<funcprototype> <funcdef>topogeometry <function>CreateTopoGeom</function></"
"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></"
"paramdef> <paramdef><type>integer </type> <parameter>tg_type</parameter></"
"paramdef> <paramdef><type>integer</type> <parameter>layer_id</parameter></"
"paramdef> <paramdef><type>topoelementarray</type> <parameter>tg_objs</"
"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>topogeometry "
"<function>CreateTopoGeom</function></funcdef> <paramdef><type>varchar </"
"type> <parameter>toponame</parameter></paramdef> <paramdef><type>integer </"
"type> <parameter>tg_type</parameter></paramdef> <paramdef><type>integer</"
"type> <parameter>layer_id</parameter></paramdef> </funcprototype>"
msgstr ""
"<funcprototype> <funcdef>topogeometry <function>CreateTopoGeom</function></"
"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></"
"paramdef> <paramdef><type>integer </type> <parameter>tg_type</parameter></"
"paramdef> <paramdef><type>integer</type> <parameter>layer_id</parameter></"
"paramdef> <paramdef><type>topoelementarray</type> <parameter>tg_objs</"
"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>topogeometry "
"<function>CreateTopoGeom</function></funcdef> <paramdef><type>varchar </"
"type> <parameter>toponame</parameter></paramdef> <paramdef><type>integer </"
"type> <parameter>tg_type</parameter></paramdef> <paramdef><type>integer</"
"type> <parameter>layer_id</parameter></paramdef> </funcprototype>"

#. Tag: para
#: extras_topology.xml:2453
#, no-c-format
msgid ""
"Creates a topogeometry object for layer denoted by <varname>layer_id</"
"varname> and registers it in the relations table in the <varname>toponame</"
"varname> schema."
msgstr ""

#. Tag: para
#: extras_topology.xml:2454
#, no-c-format
msgid ""
"<varname>tg_type</varname> is an integer: 1:[multi]point (punctal), 2:"
"[multi]line (lineal), 3:[multi]poly (areal), 4:collection. "
"<varname>layer_id</varname> is the layer id in the topology.layer table."
msgstr ""

#. Tag: para
#: extras_topology.xml:2455
#, no-c-format
msgid ""
"punctal layers are formed from set of nodes, lineal layers are formed from a "
"set of edges, areal layers are formed from a set of faces, and collections "
"can be formed from a mixture of nodes, edges, and faces."
msgstr ""

#. Tag: para
#: extras_topology.xml:2457
#, no-c-format
msgid ""
"Omitting the array of components generates an empty TopoGeometry object."
msgstr ""

#. Tag: title
#: extras_topology.xml:2464
#, no-c-format
msgid "Examples: Form from existing edges"
msgstr ""

#. Tag: para
#: extras_topology.xml:2465
#, no-c-format
msgid ""
"Create a topogeom in ri_topo schema for layer 2 (our ri_roads), of type (2) "
"LINE, for the first edge (we loaded in <varname>ST_CreateTopoGeo</varname>)."
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2466
#, no-c-format
msgid ""
"INSERT INTO ri.ri_roads(road_name, topo) VALUES('Unknown', topology."
"CreateTopoGeom('ri_topo',2,2,'{{1,2}}'::topology.topoelementarray);"
msgstr ""
"INSERT INTO ri.ri_roads(road_name, topo) VALUES('Unknown', topology."
"CreateTopoGeom('ri_topo',2,2,'{{1,2}}'::topology.topoelementarray);"

#. Tag: title
#: extras_topology.xml:2471
#, no-c-format
msgid "Examples: Convert an areal geometry to best guess topogeometry"
msgstr ""

#. Tag: para
#: extras_topology.xml:2472
#, no-c-format
msgid ""
"Lets say we have geometries that should be formed from a collection of "
"faces. We have for example blockgroups table and want to know the topo "
"geometry of each block group. If our data was perfectly aligned, we could do "
"this:"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2474
#, no-c-format
msgid ""
"-- create our topo geometry column --\n"
"SELECT topology.AddTopoGeometryColumn(\n"
"        'topo_boston',\n"
"        'boston', 'blockgroups', 'topo', 'POLYGON');\n"
"\n"
"-- addtopgeometrycolumn --\n"
"1\n"
"\n"
"-- update our column assuming\n"
"-- everything is perfectly aligned with our edges\n"
"UPDATE boston.blockgroups AS bg\n"
"        SET topo = topology.CreateTopoGeom('topo_boston'\n"
"        ,3,1\n"
"        , foo.bfaces)\n"
"FROM (SELECT b.gid,  topology.TopoElementArray_Agg(ARRAY[f.face_id,3]) As "
"bfaces\n"
"        FROM boston.blockgroups As b\n"
"            INNER JOIN topo_boston.face As f ON b.geom &amp;&amp; f.mbr\n"
"        WHERE ST_Covers(b.geom, topology.ST_GetFaceGeometry('topo_boston', f."
"face_id))\n"
"            GROUP BY b.gid) As foo\n"
"WHERE foo.gid = bg.gid;"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2476
#, no-c-format
msgid ""
"--the world is rarely perfect allow for some error\n"
"--count the face if 50% of it falls\n"
"-- within what we think is our blockgroup boundary\n"
"UPDATE boston.blockgroups AS bg\n"
"        SET topo = topology.CreateTopoGeom('topo_boston'\n"
"        ,3,1\n"
"        , foo.bfaces)\n"
"FROM (SELECT b.gid,  topology.TopoElementArray_Agg(ARRAY[f.face_id,3]) As "
"bfaces\n"
"        FROM boston.blockgroups As b\n"
"            INNER JOIN topo_boston.face As f ON b.geom &amp;&amp; f.mbr\n"
"        WHERE ST_Covers(b.geom, topology.ST_GetFaceGeometry('topo_boston', f."
"face_id))\n"
"        OR\n"
" (  ST_Intersects(b.geom, topology.ST_GetFaceGeometry('topo_boston', f."
"face_id))\n"
"            AND ST_Area(ST_Intersection(b.geom, topology."
"ST_GetFaceGeometry('topo_boston', f.face_id) ) ) >\n"
"                ST_Area(topology.ST_GetFaceGeometry('topo_boston', f."
"face_id))*0.5\n"
"                )\n"
"            GROUP BY b.gid) As foo\n"
"WHERE foo.gid = bg.gid;\n"
"\n"
"-- and if we wanted to convert our topogeometry back\n"
"-- to a denormalized geometry aligned with our faces and edges\n"
"-- cast the topo to a geometry\n"
"-- The really cool thing is my new geometries\n"
"-- are now aligned with my tiger street centerlines\n"
"UPDATE boston.blockgroups SET new_geom = topo::geometry;"
msgstr ""

#. Tag: para
#: extras_topology.xml:2482
#, no-c-format
msgid ""
", <xref linkend=\"toTopoGeom\"/> <xref linkend=\"ST_CreateTopoGeo\"/>, <xref "
"linkend=\"ST_GetFaceGeometry\"/>, <xref linkend=\"topoelementarray\"/>, "
"<xref linkend=\"TopoElementArray_Agg\"/>"
msgstr ""
", <xref linkend=\"toTopoGeom\"/> <xref linkend=\"ST_CreateTopoGeo\"/>, <xref "
"linkend=\"ST_GetFaceGeometry\"/>, <xref linkend=\"topoelementarray\"/>, "
"<xref linkend=\"TopoElementArray_Agg\"/>"

#. Tag: refname
#: extras_topology.xml:2495 extras_topology.xml:2754
#, no-c-format
msgid "toTopoGeom"
msgstr "toTopoGeom"

#. Tag: refpurpose
#: extras_topology.xml:2497
#, no-c-format
msgid "Converts a simple Geometry into a topo geometry."
msgstr ""

#. Tag: funcsynopsis
#: extras_topology.xml:2501
#, no-c-format
msgid ""
"<funcprototype> <funcdef>topogeometry <function>toTopoGeom</function></"
"funcdef> <paramdef><type>geometry </type> <parameter>geom</parameter></"
"paramdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></"
"paramdef> <paramdef><type>integer</type> <parameter>layer_id</parameter></"
"paramdef> <paramdef choice=\"opt\"><type>float8</type> <parameter>tolerance</"
"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>topogeometry "
"<function>toTopoGeom</function></funcdef> <paramdef><type>geometry </type> "
"<parameter>geom</parameter></paramdef> <paramdef><type>topogeometry </type> "
"<parameter>topogeom</parameter></paramdef> <paramdef choice=\"opt"
"\"><type>float8</type> <parameter>tolerance</parameter></paramdef> </"
"funcprototype>"
msgstr ""

#. Tag: para
#: extras_topology.xml:2522
#, no-c-format
msgid "Converts a simple Geometry into a <xref linkend=\"topogeometry\"/>."
msgstr ""

#. Tag: para
#: extras_topology.xml:2526
#, no-c-format
msgid ""
"Topological primitives required to represent the input geometry will be "
"added to the underlying topology, possibly splitting existing ones, and they "
"will be associated with the output TopoGeometry in the <varname>relation</"
"varname> table."
msgstr ""

#. Tag: para
#: extras_topology.xml:2533
#, no-c-format
msgid ""
"Existing TopoGeometry objects (with the possible exception of "
"<varname>topogeom</varname>, if given) will retain their shapes."
msgstr ""

#. Tag: para
#: extras_topology.xml:2538
#, no-c-format
msgid ""
"When <varname>tolerance</varname> is given it will be used to snap the input "
"geometry to existing primitives."
msgstr ""

#. Tag: para
#: extras_topology.xml:2543
#, no-c-format
msgid ""
"In the first form a new TopoGeometry will be created for the given layer "
"(<varname>layer_id</varname>) of the given topology (<varname>toponame</"
"varname>)."
msgstr ""

#. Tag: para
#: extras_topology.xml:2548
#, no-c-format
msgid ""
"In the second form the primitives resulting from the conversion will be "
"added to the pre-existing TopoGeometry (<varname>topogeom</varname>), "
"possibly adding space to its final shape. To have the new shape completely "
"replace the old one see <xref linkend=\"clearTopoGeom\"/>."
msgstr ""

#. Tag: para
#: extras_topology.xml:2557
#, no-c-format
msgid "Enhanced: 2.1.0 adds the version taking an existing TopoGeometry."
msgstr ""

#. Tag: para
#: extras_topology.xml:2561
#, no-c-format
msgid "This is a full self-contained workflow"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2562
#, no-c-format
msgid ""
"-- do this if you don't have a topology setup already\n"
"-- creates topology not allowing any tolerance\n"
"SELECT topology.CreateTopology('topo_boston_test', 2249);\n"
"-- create a new table\n"
"CREATE TABLE nei_topo(gid serial primary key, nei varchar(30));\n"
"--add a topogeometry column to it\n"
"SELECT topology.AddTopoGeometryColumn('topo_boston_test', 'public', "
"'nei_topo', 'topo', 'MULTIPOLYGON') As new_layer_id;\n"
"new_layer_id\n"
"-----------\n"
"1\n"
"\n"
"--use new layer id in populating the new topogeometry column\n"
"-- we add the topogeoms to the new layer with 0 tolerance\n"
"INSERT INTO nei_topo(nei, topo)\n"
"SELECT nei,  topology.toTopoGeom(geom, 'topo_boston_test', 1)\n"
"FROM neighborhoods\n"
"WHERE gid BETWEEN 1 and 15;\n"
"\n"
"--use to verify what has happened --\n"
"SELECT * FROM\n"
"    topology.TopologySummary('topo_boston_test');\n"
"\n"
"-- summary--\n"
"Topology topo_boston_test (5), SRID 2249, precision 0\n"
"61 nodes, 87 edges, 35 faces, 15 topogeoms in 1 layers\n"
"Layer 1, type Polygonal (3), 15 topogeoms\n"
" Deploy: public.nei_topo.topo"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2564
#, no-c-format
msgid ""
"-- Shrink all TopoGeometry polygons by 10 meters\n"
"UPDATE nei_topo SET topo = ST_Buffer(clearTopoGeom(topo), -10);\n"
"\n"
"-- Get the no-one-lands left by the above operation\n"
"-- I think GRASS calls this \"polygon0 layer\"\n"
"SELECT ST_GetFaceGeometry('topo_boston_test', f.face_id)\n"
"  FROM topo_boston_test.face f\n"
"  WHERE f.face_id > 0 -- don't consider the universe face\n"
"  AND NOT EXISTS ( -- check that no TopoGeometry references the face\n"
"    SELECT * FROM topo_boston_test.relation\n"
"    WHERE layer_id = 1 AND element_id = f.face_id\n"
"  );"
msgstr ""

#. Tag: para
#: extras_topology.xml:2570
#, no-c-format
msgid ""
", <xref linkend=\"AddTopoGeometryColumn\"/>, <xref linkend=\"CreateTopoGeom"
"\"/>, <xref linkend=\"TopologySummary\"/>, <xref linkend=\"clearTopoGeom\"/>"
msgstr ""

#. Tag: refname
#: extras_topology.xml:2582
#, no-c-format
msgid "TopoElementArray_Agg"
msgstr "TopoElementArray_Agg"

#. Tag: refpurpose
#: extras_topology.xml:2583
#, no-c-format
msgid ""
"Returns a <varname>topoelementarray</varname> for a set of element_id, type "
"arrays (topoelements)."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2588
#, no-c-format
msgid ""
"<funcdef>topoelementarray <function>TopoElementArray_Agg</function></"
"funcdef> <paramdef><type>topoelement set</type> <parameter>tefield</"
"parameter></paramdef>"
msgstr ""
"<funcdef>topoelementarray <function>TopoElementArray_Agg</function></"
"funcdef> <paramdef><type>topoelement set</type> <parameter>tefield</"
"parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:2598
#, no-c-format
msgid ""
"Used to create a <xref linkend=\"topoelementarray\"/> from a set of <xref "
"linkend=\"topoelement\"/>."
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2607
#, no-c-format
msgid ""
"SELECT topology.TopoElementArray_Agg(ARRAY[e,t]) As tea\n"
"  FROM generate_series(1,3) As e CROSS JOIN generate_series(1,4) As t;\n"
"  tea\n"
"--------------------------------------------------------------------------\n"
"{{1,1},{1,2},{1,3},{1,4},{2,1},{2,2},{2,3},{2,4},{3,1},{3,2},{3,3},{3,4}}"
msgstr ""
"SELECT topology.TopoElementArray_Agg(ARRAY[e,t]) As tea\n"
"  FROM generate_series(1,3) As e CROSS JOIN generate_series(1,4) As t;\n"
"  tea\n"
"--------------------------------------------------------------------------\n"
"{{1,1},{1,2},{1,3},{1,4},{2,1},{2,2},{2,3},{2,4},{3,1},{3,2},{3,3},{3,4}}"

#. Tag: para
#: extras_topology.xml:2611 extras_topology.xml:2816
#, no-c-format
msgid ", <xref linkend=\"topoelementarray\"/>"
msgstr ""

#. Tag: para
#: extras_topology.xml:2619
#, no-c-format
msgid ""
"This section covers the topology functions for editing existing "
"topogeometries."
msgstr ""

#. Tag: title
#: extras_topology.xml:2622
#, no-c-format
msgid "TopoGeometry Editors"
msgstr ""

#. Tag: refname
#: extras_topology.xml:2626
#, no-c-format
msgid "clearTopoGeom"
msgstr ""

#. Tag: refpurpose
#: extras_topology.xml:2628
#, no-c-format
msgid "Clears the content of a topo geometry."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2633
#, no-c-format
msgid ""
"<funcdef>topogeometry <function>clearTopoGeom</function></funcdef> "
"<paramdef><type>topogeometry </type> <parameter>topogeom</parameter></"
"paramdef>"
msgstr ""

#. Tag: para
#: extras_topology.xml:2643
#, no-c-format
msgid ""
"Clears the content a <xref linkend=\"topogeometry\"/> turning it into an "
"empty one. Mostly useful in conjunction with <xref linkend=\"toTopoGeom\"/> "
"to replace the shape of existing objects and any dependent object in higher "
"hierarchical levels."
msgstr ""

#. Tag: para
#: extras_topology.xml:2651
#, no-c-format
msgid "Availability: 2.1"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2655
#, no-c-format
msgid ""
"-- Shrink all TopoGeometry polygons by 10 meters\n"
"UPDATE nei_topo SET topo = ST_Buffer(clearTopoGeom(topo), -10);"
msgstr ""

#. Tag: refname
#: extras_topology.xml:2669
#, no-c-format
msgid "TopoGeom_addElement"
msgstr ""

#. Tag: refpurpose
#: extras_topology.xml:2670
#, no-c-format
msgid "Adds an element to the definition of a TopoGeometry."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2674
#, no-c-format
msgid ""
"<funcdef>topogeometry <function>TopoGeom_addElement</function></funcdef> "
"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> "
"<paramdef><type>topoelement </type> <parameter>el</parameter></paramdef>"
msgstr ""

#. Tag: para
#: extras_topology.xml:2685
#, no-c-format
msgid ""
"Adds a <xref linkend=\"topoelement\"/> to the definition of a TopoGeometry "
"object. Does not error out if the element is already part of the definition."
msgstr ""

#. Tag: para
#: extras_topology.xml:2692 extras_topology.xml:2735
#, no-c-format
msgid "Availability: 2.3"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2696
#, no-c-format
msgid ""
"-- Add edge 5 to TopoGeometry tg\n"
"UPDATE mylayer SET tg = TopoGeom_addElement(tg, '{5,2}');"
msgstr ""

#. Tag: para
#: extras_topology.xml:2702 extras_topology.xml:2745
#, no-c-format
msgid ", <xref linkend=\"CreateTopoGeom\"/>"
msgstr ", <xref linkend=\"CreateTopoGeom\"/>"

#. Tag: refname
#: extras_topology.xml:2711
#, no-c-format
msgid "TopoGeom_remElement"
msgstr ""

#. Tag: refpurpose
#: extras_topology.xml:2713
#, no-c-format
msgid "Removes an element from the definition of a TopoGeometry."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2718
#, no-c-format
msgid ""
"<funcdef>topogeometry <function>TopoGeom_remElement</function></funcdef> "
"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> "
"<paramdef><type>topoelement </type> <parameter>el</parameter></paramdef>"
msgstr ""

#. Tag: para
#: extras_topology.xml:2729
#, no-c-format
msgid ""
"Removes a <xref linkend=\"topoelement\"/> from the definition of a "
"TopoGeometry object."
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2739
#, no-c-format
msgid ""
"-- Remove face 43 from TopoGeometry tg\n"
"UPDATE mylayer SET tg = TopoGeom_remElement(tg, '{43,3}');"
msgstr ""

#. Tag: refpurpose
#: extras_topology.xml:2755
#, no-c-format
msgid "Adds a geometry shape to an existing topo geometry."
msgstr ""

#. Tag: para
#: extras_topology.xml:2759
#, fuzzy, no-c-format
msgid "Refer to <xref linkend=\"toTopoGeom\"/>."
msgstr ", <xref linkend=\"CreateTopoGeom\"/>"

#. Tag: title
#: extras_topology.xml:2769
#, no-c-format
msgid "TopoGeometry Accessors"
msgstr ""

#. Tag: refname
#: extras_topology.xml:2773
#, no-c-format
msgid "GetTopoGeomElementArray"
msgstr "GetTopoGeomElementArray"

#. Tag: refpurpose
#: extras_topology.xml:2775
#, no-c-format
msgid ""
"Returns a <varname>topoelementarray</varname> (an array of topoelements) "
"containing the topological elements and type of the given TopoGeometry "
"(primitive elements)."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2780
#, no-c-format
msgid ""
"<funcdef>topoelementarray <function>GetTopoGeomElementArray</function></"
"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></"
"paramdef> <paramdef><type>integer </type> <parameter>layer_id</parameter></"
"paramdef> <paramdef><type>integer</type> <parameter>tg_id</parameter></"
"paramdef>"
msgstr ""
"<funcdef>topoelementarray <function>GetTopoGeomElementArray</function></"
"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></"
"paramdef> <paramdef><type>integer </type> <parameter>layer_id</parameter></"
"paramdef> <paramdef><type>integer</type> <parameter>tg_id</parameter></"
"paramdef>"

#. Tag: funcprototype
#: extras_topology.xml:2788
#, no-c-format
msgid ""
"<funcdef>topoelementarray topoelement <function>GetTopoGeomElementArray</"
"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</"
"parameter></paramdef>"
msgstr ""
"<funcdef>topoelementarray topoelement <function>GetTopoGeomElementArray</"
"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</"
"parameter></paramdef>"

#. Tag: para
#: extras_topology.xml:2798
#, no-c-format
msgid ""
"Returns a <xref linkend=\"topoelementarray\"/> containing the topological "
"elements and type of the given TopoGeometry (primitive elements). This is "
"similar to GetTopoGeomElements except it returns the elements as an array "
"rather than as a dataset."
msgstr ""

#. Tag: para
#: extras_topology.xml:2800 extras_topology.xml:2847
#, no-c-format
msgid ""
"tg_id is the topogeometry id of the topogeometry object in the topology in "
"the layer denoted by <varname>layer_id</varname> in the topology.layer table."
msgstr ""

#. Tag: refname
#: extras_topology.xml:2821
#, no-c-format
msgid "GetTopoGeomElements"
msgstr "GetTopoGeomElements"

#. Tag: refpurpose
#: extras_topology.xml:2823
#, no-c-format
msgid ""
"Returns a set of <varname>topoelement</varname> objects containing the "
"topological element_id,element_type of the given TopoGeometry (primitive "
"elements)."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2828
#, no-c-format
msgid ""
"<funcdef>setof topoelement <function>GetTopoGeomElements</function></"
"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></"
"paramdef> <paramdef><type>integer </type> <parameter>layer_id</parameter></"
"paramdef> <paramdef><type>integer</type> <parameter>tg_id</parameter></"
"paramdef>"
msgstr ""
"<funcdef>setof topoelement <function>GetTopoGeomElements</function></"
"funcdef> <paramdef><type>varchar </type> <parameter>toponame</parameter></"
"paramdef> <paramdef><type>integer </type> <parameter>layer_id</parameter></"
"paramdef> <paramdef><type>integer</type> <parameter>tg_id</parameter></"
"paramdef>"

#. Tag: funcprototype
#: extras_topology.xml:2836
#, no-c-format
msgid ""
"<funcdef>setof topoelement <function>GetTopoGeomElements</function></"
"funcdef> <paramdef><type>topogeometry </type> <parameter>tg</parameter></"
"paramdef>"
msgstr ""
"<funcdef>setof topoelement <function>GetTopoGeomElements</function></"
"funcdef> <paramdef><type>topogeometry </type> <parameter>tg</parameter></"
"paramdef>"

#. Tag: para
#: extras_topology.xml:2846
#, no-c-format
msgid ""
"Returns a set of element_id,element_type (topoelements) for a given "
"topogeometry object in <varname>toponame</varname> schema."
msgstr ""

#. Tag: para
#: extras_topology.xml:2863
#, no-c-format
msgid ""
", <xref linkend=\"topoelement\"/>, <xref linkend=\"TopoGeom_addElement\"/>, "
"<xref linkend=\"TopoGeom_remElement\"/>"
msgstr ""

#. Tag: title
#: extras_topology.xml:2876
#, no-c-format
msgid "TopoGeometry Outputs"
msgstr ""

#. Tag: refname
#: extras_topology.xml:2879
#, no-c-format
msgid "AsGML"
msgstr "AsGML"

#. Tag: refpurpose
#: extras_topology.xml:2881
#, no-c-format
msgid "Returns the GML representation of a topogeometry."
msgstr ""

#. Tag: funcsynopsis
#: extras_topology.xml:2885
#, no-c-format
msgid ""
"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> "
"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>text <function>AsGML</function></"
"funcdef> <paramdef><type>topogeometry </type> <parameter>tg</parameter></"
"paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</parameter></"
"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</"
"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</"
"parameter></paramdef> <paramdef><type>regclass </type> "
"<parameter>visitedTable</parameter></paramdef> </funcprototype> "
"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> "
"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> "
"<paramdef><type>regclass </type> <parameter>visitedTable</parameter></"
"paramdef> <paramdef><type>text </type> <parameter>nsprefix</parameter></"
"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</"
"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</"
"parameter></paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</"
"parameter></paramdef> <paramdef><type>integer </type> <parameter>precision</"
"parameter></paramdef> <paramdef><type>integer </type> <parameter>options</"
"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>text "
"<function>AsGML</function></funcdef> <paramdef><type>topogeometry </type> "
"<parameter>tg</parameter></paramdef> <paramdef><type>text </type> "
"<parameter>nsprefix_in</parameter></paramdef> <paramdef><type>integer </"
"type> <parameter>precision</parameter></paramdef> <paramdef><type>integer </"
"type> <parameter>options</parameter></paramdef> <paramdef><type>regclass </"
"type> <parameter>visitedTable</parameter></paramdef> </funcprototype> "
"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> "
"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> "
"<paramdef><type>text </type> <parameter>nsprefix_in</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>precision</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>options</parameter></paramdef> "
"<paramdef><type>regclass </type> <parameter>visitedTable</parameter></"
"paramdef> <paramdef><type>text </type> <parameter>idprefix</parameter></"
"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</"
"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</"
"parameter></paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</"
"parameter></paramdef> <paramdef><type>integer </type> <parameter>precision</"
"parameter></paramdef> <paramdef><type>integer </type> <parameter>options</"
"parameter></paramdef> <paramdef><type>regclass </type> "
"<parameter>visitedTable</parameter></paramdef> <paramdef><type>text </type> "
"<parameter>idprefix</parameter></paramdef> <paramdef><type>int </type> "
"<parameter>gmlversion</parameter></paramdef> </funcprototype>"
msgstr ""
"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> "
"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> </"
"funcprototype> <funcprototype> <funcdef>text <function>AsGML</function></"
"funcdef> <paramdef><type>topogeometry </type> <parameter>tg</parameter></"
"paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</parameter></"
"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</"
"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</"
"parameter></paramdef> <paramdef><type>regclass </type> "
"<parameter>visitedTable</parameter></paramdef> </funcprototype> "
"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> "
"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> "
"<paramdef><type>regclass </type> <parameter>visitedTable</parameter></"
"paramdef> <paramdef><type>text </type> <parameter>nsprefix</parameter></"
"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</"
"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</"
"parameter></paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</"
"parameter></paramdef> <paramdef><type>integer </type> <parameter>precision</"
"parameter></paramdef> <paramdef><type>integer </type> <parameter>options</"
"parameter></paramdef> </funcprototype> <funcprototype> <funcdef>text "
"<function>AsGML</function></funcdef> <paramdef><type>topogeometry </type> "
"<parameter>tg</parameter></paramdef> <paramdef><type>text </type> "
"<parameter>nsprefix_in</parameter></paramdef> <paramdef><type>integer </"
"type> <parameter>precision</parameter></paramdef> <paramdef><type>integer </"
"type> <parameter>options</parameter></paramdef> <paramdef><type>regclass </"
"type> <parameter>visitedTable</parameter></paramdef> </funcprototype> "
"<funcprototype> <funcdef>text <function>AsGML</function></funcdef> "
"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> "
"<paramdef><type>text </type> <parameter>nsprefix_in</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>precision</parameter></paramdef> "
"<paramdef><type>integer </type> <parameter>options</parameter></paramdef> "
"<paramdef><type>regclass </type> <parameter>visitedTable</parameter></"
"paramdef> <paramdef><type>text </type> <parameter>idprefix</parameter></"
"paramdef> </funcprototype> <funcprototype> <funcdef>text <function>AsGML</"
"function></funcdef> <paramdef><type>topogeometry </type> <parameter>tg</"
"parameter></paramdef> <paramdef><type>text </type> <parameter>nsprefix_in</"
"parameter></paramdef> <paramdef><type>integer </type> <parameter>precision</"
"parameter></paramdef> <paramdef><type>integer </type> <parameter>options</"
"parameter></paramdef> <paramdef><type>regclass </type> "
"<parameter>visitedTable</parameter></paramdef> <paramdef><type>text </type> "
"<parameter>idprefix</parameter></paramdef> <paramdef><type>int </type> "
"<parameter>gmlversion</parameter></paramdef> </funcprototype>"

#. Tag: para
#: extras_topology.xml:2946
#, no-c-format
msgid ""
"Returns the GML representation of a topogeometry in version GML3 format. If "
"no <varname>nsprefix_in</varname> is specified then <varname>gml</varname> "
"is used. Pass in an empty string for nsprefix to get a non-qualified name "
"space. The precision (default: 15) and options (default 1) parameters, if "
"given, are passed untouched to the underlying call to ST_AsGML."
msgstr ""

#. Tag: para
#: extras_topology.xml:2948
#, no-c-format
msgid ""
"The <varname>visitedTable</varname> parameter, if given, is used for keeping "
"track of the visited Node and Edge elements so to use cross-references "
"(xlink:xref) rather than duplicating definitions. The table is expected to "
"have (at least) two integer fields: 'element_type' and 'element_id'. The "
"calling user must have both read and write privileges on the given table. "
"For best performance, an index should be defined on <varname>element_type</"
"varname> and <varname>element_id</varname>, in that order. Such index would "
"be created automatically by adding a unique constraint to the fields. "
"Example:"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2954
#, no-c-format
msgid ""
"CREATE TABLE visited (\n"
"  element_type integer, element_id integer,\n"
"  unique(element_type, element_id)\n"
");"
msgstr ""
"CREATE TABLE visited (\n"
"  element_type integer, element_id integer,\n"
"  unique(element_type, element_id)\n"
");"

#. Tag: para
#: extras_topology.xml:2957
#, no-c-format
msgid ""
"The <varname>idprefix</varname> parameter, if given, will be prepended to "
"Edge and Node tag identifiers."
msgstr ""

#. Tag: para
#: extras_topology.xml:2959
#, no-c-format
msgid ""
"The <varname>gmlver</varname> parameter, if given, will be passed to the "
"underlying ST_AsGML. Defaults to 3."
msgstr ""

#. Tag: para
#: extras_topology.xml:2968
#, no-c-format
msgid ""
"This uses the topo geometry we created in <xref linkend=\"CreateTopoGeom\"/>"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2969
#, no-c-format
msgid ""
"SELECT topology.AsGML(topo) As rdgml\n"
"  FROM ri.roads\n"
"  WHERE road_name = 'Unknown';\n"
"\n"
"-- rdgml--\n"
"<![CDATA[<gml:TopoCurve>\n"
"    <gml:directedEdge>\n"
"        <gml:Edge gml:id=\"E1\">\n"
"            <gml:directedNode orientation=\"-\">\n"
"                <gml:Node gml:id=\"N1\"/>\n"
"            </gml:directedNode>\n"
"            <gml:directedNode></gml:directedNode>\n"
"            <gml:curveProperty>\n"
"                <gml:Curve srsName=\"urn:ogc:def:crs:EPSG::3438\">\n"
"                    <gml:segments>\n"
"                        <gml:LineStringSegment>\n"
"                            <gml:posList srsDimension=\"2\">384744 236928 "
"384750 236923 384769 236911 384799 236895 384811 236890\n"
"                            384833 236884 384844 236882 384866 236881 384879 "
"236883 384954 236898 385087 236932 385117 236938\n"
"                            385167 236938 385203 236941 385224 236946 385233 "
"236950 385241 236956 385254 236971\n"
"                            385260 236979 385268 236999 385273 237018 385273 "
"237037 385271 237047 385267 237057 385225 237125\n"
"                            385210 237144 385192 237161 385167 237192 385162 "
"237202 385159 237214 385159 237227 385162 237241\n"
"                            385166 237256 385196 237324 385209 237345 385234 "
"237375 385237 237383 385238 237399 385236 237407\n"
"                            385227 237419 385213 237430 385193 237439 385174 "
"237451 385170 237455 385169 237460 385171 237475\n"
"                            385181 237503 385190 237521 385200 237533 385206 "
"237538 385213 237541 385221 237542 385235 237540 385242 237541\n"
"                            385249 237544 385260 237555 385270 237570 385289 "
"237584 385292 237589 385291 237596 385284 237630</gml:posList>\n"
"                        </gml:LineStringSegment>\n"
"                    </gml:segments>\n"
"                </gml:Curve>\n"
"            </gml:curveProperty>\n"
"        </gml:Edge>\n"
"    </gml:directedEdge>\n"
"</gml:TopoCurve>]]>"
msgstr ""

#. Tag: para
#: extras_topology.xml:2970
#, no-c-format
msgid "Same exercise as previous without namespace"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:2971
#, no-c-format
msgid ""
"SELECT topology.AsGML(topo,'') As rdgml\n"
"  FROM ri.roads\n"
"  WHERE road_name = 'Unknown';\n"
"\n"
"-- rdgml--\n"
"<![CDATA[<TopoCurve>\n"
"    <directedEdge>\n"
"        <Edge id=\"E1\">\n"
"            <directedNode orientation=\"-\">\n"
"                <Node id=\"N1\"/>\n"
"            </directedNode>\n"
"            <directedNode></directedNode>\n"
"            <curveProperty>\n"
"                <Curve srsName=\"urn:ogc:def:crs:EPSG::3438\">\n"
"                    <segments>\n"
"                        <LineStringSegment>\n"
"                            <posList srsDimension=\"2\">384744 236928 384750 "
"236923 384769 236911 384799 236895 384811 236890\n"
"                            384833 236884 384844 236882 384866 236881 384879 "
"236883 384954 236898 385087 236932 385117 236938\n"
"                            385167 236938 385203 236941 385224 236946 385233 "
"236950 385241 236956 385254 236971\n"
"                            385260 236979 385268 236999 385273 237018 385273 "
"237037 385271 237047 385267 237057 385225 237125\n"
"                            385210 237144 385192 237161 385167 237192 385162 "
"237202 385159 237214 385159 237227 385162 237241\n"
"                            385166 237256 385196 237324 385209 237345 385234 "
"237375 385237 237383 385238 237399 385236 237407\n"
"                            385227 237419 385213 237430 385193 237439 385174 "
"237451 385170 237455 385169 237460 385171 237475\n"
"                            385181 237503 385190 237521 385200 237533 385206 "
"237538 385213 237541 385221 237542 385235 237540 385242 237541\n"
"                            385249 237544 385260 237555 385270 237570 385289 "
"237584 385292 237589 385291 237596 385284 237630</posList>\n"
"                         </LineStringSegment>\n"
"                    </segments>\n"
"                </Curve>\n"
"            </curveProperty>\n"
"        </Edge>\n"
"    </directedEdge>\n"
"</TopoCurve>]]>"
msgstr ""

#. Tag: para
#: extras_topology.xml:2977
#, no-c-format
msgid ", <xref linkend=\"ST_CreateTopoGeo\"/>"
msgstr ", <xref linkend=\"ST_CreateTopoGeo\"/>"

#. Tag: refname
#: extras_topology.xml:2982
#, no-c-format
msgid "AsTopoJSON"
msgstr ""

#. Tag: refpurpose
#: extras_topology.xml:2984
#, no-c-format
msgid "Returns the TopoJSON representation of a topogeometry."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:2989
#, no-c-format
msgid ""
"<funcdef>text <function>AsTopoJSON</function></funcdef> "
"<paramdef><type>topogeometry </type> <parameter>tg</parameter></paramdef> "
"<paramdef><type>regclass </type> <parameter>edgeMapTable</parameter></"
"paramdef>"
msgstr ""

#. Tag: para
#: extras_topology.xml:3000
#, no-c-format
msgid ""
"Returns the TopoJSON representation of a topogeometry. If "
"<varname>edgeMapTable</varname> is not null, it will be used as a lookup/"
"storage mapping of edge identifiers to arc indices. This is to be able to "
"allow for a compact \"arcs\" array in the final document."
msgstr ""

#. Tag: para
#: extras_topology.xml:3003
#, no-c-format
msgid ""
"The table, if given, is expected to have an \"arc_id\" field of type \"serial"
"\" and an \"edge_id\" of type integer; the code will query the table for "
"\"edge_id\" so it is recommended to add an index on that field."
msgstr ""

#. Tag: para
#: extras_topology.xml:3008
#, no-c-format
msgid ""
"Arc indices in the TopoJSON output are 0-based but they are 1-based in the "
"\"edgeMapTable\" table."
msgstr ""

#. Tag: para
#: extras_topology.xml:3014
#, no-c-format
msgid ""
"A full TopoJSON document will be need to contain, in addition to the "
"snippets returned by this function, the actual arcs plus some headers. See "
"the <ulink url=\"http://github.com/mbostock/topojson-specification/blob/"
"master/README.md\">TopoJSON specification</ulink>."
msgstr ""

#. Tag: para
#: extras_topology.xml:3023
#, no-c-format
msgid "Enhanced: 2.2.1 added support for puntal inputs"
msgstr ""

#. Tag: programlisting
#: extras_topology.xml:3035
#, no-c-format
msgid ""
"CREATE TEMP TABLE edgemap(arc_id serial, edge_id int unique);\n"
"\n"
"-- header\n"
"SELECT '{ \"type\": \"Topology\", \"transform\": { \"scale\": [1,1], "
"\"translate\": [0,0] }, \"objects\": {'\n"
"\n"
"-- objects\n"
"UNION ALL SELECT '\"' || feature_name || '\": ' || AsTopoJSON(feature, "
"'edgemap')\n"
"FROM features.big_parcels WHERE feature_name = 'P3P4';\n"
"\n"
"-- arcs\n"
"WITH edges AS (\n"
"  SELECT m.arc_id, e.geom FROM edgemap m, city_data.edge e\n"
"  WHERE e.edge_id = m.edge_id\n"
"), points AS (\n"
"  SELECT arc_id, (st_dumppoints(geom)).* FROM edges\n"
"), compare AS (\n"
"  SELECT p2.arc_id,\n"
"         CASE WHEN p1.path IS NULL THEN p2.geom\n"
"              ELSE ST_Translate(p2.geom, -ST_X(p1.geom), -ST_Y(p1.geom))\n"
"         END AS geom\n"
"  FROM points p2 LEFT OUTER JOIN points p1\n"
"  ON ( p1.arc_id = p2.arc_id AND p2.path[1] = p1.path[1]+1 )\n"
"  ORDER BY arc_id, p2.path\n"
"), arcsdump AS (\n"
"  SELECT arc_id, (regexp_matches( ST_AsGeoJSON(geom), '\\[.*\\]'))[1] as t\n"
"  FROM compare\n"
"), arcs AS (\n"
"  SELECT arc_id, '[' || array_to_string(array_agg(t), ',') || ']' as a FROM "
"arcsdump\n"
"  GROUP BY arc_id\n"
"  ORDER BY arc_id\n"
")\n"
"SELECT '}, \"arcs\": [' UNION ALL\n"
"SELECT array_to_string(array_agg(a), E',\\n') from arcs\n"
"\n"
"-- footer\n"
"UNION ALL SELECT ']}'::text as t;\n"
"\n"
"-- Result:\n"
"{ \"type\": \"Topology\", \"transform\": { \"scale\": [1,1], \"translate\": "
"[0,0] }, \"objects\": {\n"
"\"P3P4\": { \"type\": \"MultiPolygon\", \"arcs\": [[[-1]],"
"[[6,5,-5,-4,-3,1]]]}\n"
"}, \"arcs\": [\n"
" [[25,30],[6,0],[0,10],[-14,0],[0,-10],[8,0]],\n"
" [[35,6],[0,8]],\n"
" [[35,6],[12,0]],\n"
" [[47,6],[0,8]],\n"
" [[47,14],[0,8]],\n"
" [[35,22],[12,0]],\n"
" [[35,14],[0,8]]\n"
" ]}"
msgstr ""

#. Tag: para
#: extras_topology.xml:3043
#, no-c-format
msgid ""
"This section lists the Topology functions used to check relationships "
"between topogeometries and topology primitives"
msgstr ""

#. Tag: title
#: extras_topology.xml:3046
#, no-c-format
msgid "Topology Spatial Relationships"
msgstr ""

#. Tag: refname
#: extras_topology.xml:3049
#, no-c-format
msgid "Equals"
msgstr ""

#. Tag: refpurpose
#: extras_topology.xml:3051
#, no-c-format
msgid ""
"Returns true if two topogeometries are composed of the same topology "
"primitives."
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:3056
#, no-c-format
msgid ""
"<funcdef>boolean <function>Equals</function></funcdef> "
"<paramdef><type>topogeometry </type> <parameter>tg1</parameter></paramdef> "
"<paramdef><type>topogeometry </type> <parameter>tg2</parameter></paramdef>"
msgstr ""

#. Tag: para
#: extras_topology.xml:3067
#, no-c-format
msgid ""
"Returns true if two topogeometries are composed of the same topology "
"primitives: faces, edges, nodes."
msgstr ""

#. Tag: para
#: extras_topology.xml:3071
#, no-c-format
msgid ""
"This function not supported for topogeometries that are geometry "
"collections. It also can not compare topogeometries from different "
"topologies."
msgstr ""

#. Tag: para
#: extras_topology.xml:3078 extras_topology.xml:3131
#, no-c-format
msgid "&Z_support;"
msgstr "&Z_support;"

#. Tag: programlisting
#: extras_topology.xml:3085 extras_topology.xml:3138
#, no-c-format
msgid "<!--TODO: Need example -->"
msgstr ""

#. Tag: para
#: extras_topology.xml:3092
#, no-c-format
msgid ", <xref linkend=\"ST_Equals\"/>"
msgstr ""

#. Tag: refname
#: extras_topology.xml:3098
#, no-c-format
msgid "Intersects"
msgstr ""

#. Tag: refpurpose
#: extras_topology.xml:3100
#, no-c-format
msgid ""
"<refpurpose>Returns true if any pair of primitives from the two "
"topogeometries intersect.</refpurpose>"
msgstr ""

#. Tag: funcprototype
#: extras_topology.xml:3105
#, no-c-format
msgid ""
"<funcdef>boolean <function>Intersects</function></funcdef> "
"<paramdef><type>topogeometry </type> <parameter>tg1</parameter></paramdef> "
"<paramdef><type>topogeometry </type> <parameter>tg2</parameter></paramdef>"
msgstr ""

#. Tag: para
#: extras_topology.xml:3116
#, no-c-format
msgid ""
"<para>Returns true if any pair of primitives from the two topogeometries "
"intersect.</para>"
msgstr ""

#. Tag: para
#: extras_topology.xml:3123
#, no-c-format
msgid ""
"This function not supported for topogeometries that are geometry "
"collections. It also can not compare topogeometries from different "
"topologies. Also not currently supported for hierarchichal topogeometries "
"(topogeometries composed of other topogeometries)."
msgstr ""