PostGIS in Action

List of Listings

Chapter 1. What is a spatial database?

Listing 1.1. Set up fastfoods and franchises lookup

Listing 1.2. Using the geometry data type to store data

Listing 1.3. Using the geography data type to store data

Listing 1.4. Using the geometry data type to store roads data

Listing 1.5. List franchise name, count of restaurants on a principal highway

Listing 1.6. Return the principal highway that has the most restaurants and how many

Chapter 2. Geometry types

Listing 2.1. Adding points

Listing 2.2. Adding linestrings

Listing 2.3. Forming geometrycollections from constituent geometries

Listing 2.4. Building circularstrings

Listing 2.5. Creating curved polygons

Chapter 3. Organizing spatial data

Listing 3.1. Code to partition roads ...