PostGIS in Action, Second Edition

List of Listings

Chapter 1. What is a spatial database?

Listing 1.1. Enabling PostGIS in a database

Listing 1.2. Create franchise lookup table

Listing 1.3. Create restaurants table

Listing 1.4. Create highways table

Listing 1.5. Populating the highways table

Listing 1.6. Restaurants within one mile of a highway

Chapter 2. Spatial data types

Listing 2.1. Points

Listing 2.2. Add linestrings

Listing 2.3. Triangular polygon with no holes

Listing 2.4. Polygon with two holes

Listing 2.5. Forming geometrycollections by collecting constituent geometries

Listing 2.6. Forming GEOMETRYCOLLECTIONMs from constituent geometries

Listing 2.7. Three-faced polyhedral surface

Listing 2.8. TIN made up of four TRIANGLEs

Listing 2.9. Building circularstrings