16. Module: Spatial Database Concepts with PostGIS
Spatial Databases allow the storage of the geometries of records inside a Database as well as providing functionality for querying and retrieving the records using these Geometries. In this module we will use PostGIS, an extension to PostgreSQL, to learn how to setup a spatial database, import data into the database and make use of the geographic functions that PostGIS offers.
While working through this section, you may want to keep a copy of the PostGIS cheat sheet available from Boston GIS user group. Another useful resource is the online PostGIS documentation.
There are also some more extensive tutorials on PostGIS and Spatial Databases available from Boundless Geo:
See also PostGIS In Action.
- 16.1. Lesson: PostGIS Setup
- 16.2. Lesson: Simple Feature Model
- 16.3. Lesson: Import and Export
- 16.4. Lesson: Spatial Queries
- 16.5. Lesson: Geometry Construction
- 16.5.1. Creating Linestrings
- 16.5.2. Try Yourself
- 16.5.3. Creating Polygons
- 16.5.4. Exercise: Linking Cities to People
- 16.5.5. Looking at Our Schema
- 16.5.6. Try Yourself
- 16.5.7. Access Sub-Objects
- 16.5.8. Data Processing
- 16.5.9. Clipping
- 16.5.10. Building Geometries from Other Geometries
- 16.5.11. Geometry Cleaning
- 16.5.12. Differences between tables
- 16.5.13. Tablespaces
- 16.5.14. In Conclusion