Book Image

PostGIS Cookbook

Book Image

PostGIS Cookbook

Overview of this book

Table of Contents (18 chapters)
PostGIS Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Getting and loading rasters


In this recipe, we load most of the rasters used in this chapter. These rasters are examples of satellite imagery and model-generated surfaces, two of the most common raster sources.

Getting ready

If you have not done so already, create a directory and copy the chapter's datasets.

> mkdir C:\postgis_cookbook\data\chap05
> cp -r /path/to/book_dataset/chap05 C:\postgis_cookbook\data\chap05

You should also create a new schema for this chapter in the database.

> psql -d postgis_cookbook -c "CREATE SCHEMA chap5"

How to do it...

We will start with the PRISM average monthly minimum-temperature raster dataset for 2012 with coverage for the Continental United States. The raster is provided by the PRISM Climate Group at Oregon State University, with additional rasters available at http://www.prism.oregonstate.edu/mtd/.

On the command line, navigate to the PRISM directory as follows:

> cd C:\postgis_cookbook\data\chap05\PRISM

Let us spot-check one of the PRISM rasters...