Database Reference
In-Depth Information
postgis_cookbook=# UPDATE chp03.hungary hu
SET the_geom = hut.the_geom_topo
FROM chp03.hu_topo_polygons hut
WHERE hu.name_1 = hut.name_1;
16. Thesimplificationprocessshouldhaveworkedsmoothlyandproducedaval-
id topological dataset. The following screenshot shows how this looks:
How it works...
WecreatedanewPostGIStopologyschemausingthe
CreateTopology
function.
ThisfunctioncreatesanewPostgreSQLschemawhereallofthetopologicalentities
are stored.
We can have more topological schemas within the same spatial database, each
being contained in a different PostgreSQL schema. The PostGIS
topo-
logy.topology
tablemanagesallofthemetadataforallofthetopologicalschem-
as.
