PostGIS Cookbook - Second Edition

How it works...

We added a PostGIS layer in OpenJUMP using the Open Data Store Layer menu. This was achieved after creating a new connection and entering our database parameters.

In the example, census data was added which included the boundary of Cuyahoga county. Part of the boundary advances into Lake Erie to the International Boundary with Canada. While technically correct, the water boundary is typically not used for practical mapping purposes. In this case, it's easy to visualize which data needs to be removed.

OpenJUMP allows us to easily see and delete records that should be deleted from the table. The selected lines were deleted, and the table was saved to the database.