Database Reference
In-Depth Information
VisitthefollowinglinktodownloadtheshapefilesforCaliforniaschoolsand
police stations:
How it works...
Inthisrecipe,wecreatedanewdatabaseandinstalledPostGISinitsownschema.
We kept the PostGIS objects separate from our geometries and rasters by not in-
stallingPostGISinthe
public
schema.Thisseparationkeepsthe
public
schema
tidy and reduces the accidental modification or deletion of the PostGIS objects.
In the following recipes, we will see that our decision to install PostGIS in its own
schema results in fewer problems when maintaining the database.
