In this recipe, we will create a database and install PostGIS in its own schema. We will also load some geometries and rasters for future use by other recipes in this chapter.
The following are the two methods to create a PostGIS-enabled database:
- Using the CREATE EXTENSION statement
- Running the installation SQL scripts with a PostgreSQL client
The CREATE EXTENSION method is available if you are running PostgreSQL 9.1 or a later version and is the recommended method for installing PostGIS:
- Visit the following link to download the shapefiles for California schools and police stations: http://scec.usc.edu/internships/useit/content/california-emergency-facilities-shapefile.