How it works...

We created a new PostGIS topology schema using the CreateTopology function. This function creates a new PostgreSQL schema where all the topological entities are stored.

We can have more topological schemas within the same spatial database, each being contained in a different PostgreSQL schema. The PostGIS topology.topology table manages all the metadata for all the topological schemas.

Each topological schema is composed of a series of tables and views to manage the topological entities (such as edge, edge data, face, node, and topogeoms) and their relations.

We can have a quick look at the description of a single topological schema using the topologysummary function, which summarizes the main metadata information-name, SRID, ...

Get PostGIS Cookbook - Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.