O'Reilly logo

PostGIS Cookbook by Bborie Park, Stephen Vincent Mather, Thomas J. Kraft, Paolo Corti

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with basic raster information and analysis

So far, we checked and imported the PRISM and SRTM rasters into the chap5 schema of the postgis_cookbook database. We will now proceed to work with the rasters within the database.

Getting ready

In this recipe, we explore functions that provide insight into the raster attributes and characteristics found in the postgis_cookbook database. In doing so, we can see whether what is found in the database matches the information provided by gdalinfo.

How to do it...

PostGIS includes the raster_columns view to provide a high-level summary of all the raster columns found in the database. This view is similar to the geometry_columns and geography_columns views in function and form.

Let's run the following SQL ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required