Converting points to lines to polygons and back – PostGIS

The goal of this recipe is identical to the previous two recipes, but it covers how to perform the process with data in a PostGIS database. You will use it to turn points into lines, and lines into polygons.

Not all methods are available; for those not available, you can use the previous recipe. It will also work on a database layer; it just doesn't save the results to the database. So, the results will need to be imported to the database after completion.

Getting ready

You need to load a vector layer of points with a numeric ID indicating order, and an identifier of unique lines or polygons that is shared between points of the same geometry. For example, you can use census_wake_2000_points ...

Get QGIS: Becoming a GIS Power User 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.