How to do it...

The steps you need to take to complete this recipe are as follows:

  1. All functions and tables associated with the topology module are installed in a schema named topology, so let's add it to the search path to avoid prefixing it before every topology function or object:
      postgis_cookbook=# SET search_path TO chp03, topology, public; 
  1. Now you will use the CreateTopology function to create a new topology schema named hu_topo in which you will import the 20 administrative areas from the hungary table. In PostGIS topology, all the topology entities and relations needed for one topology schema are stored in a single PostgreSQL schema using the same spatial reference system. You will name this schema hu_topo and use the EPSG:3857 ...

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.