A common GIS use case is clipping a big dataset into small portions (subsets), with maybe each representing an area of interest. In this recipe, you will export from a PostGIS layer representing the rivers in the world one distinct shapefile composed of rivers for each world's country. For this purpose, you will use the
Be sure that you have imported in PostGIS the same river dataset (a shapefile) that was used in the previous recipe.
The steps you need to perform to complete this recipe are as follows:
ST_Intersectsfunctions. Name the view