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 into various states

Listing 3.2. Region tagging and clipping data to a specific arrondissement

Listing 3.3. Breaking our data into separate tables with homogeneous geometry columns

Listing 3.4. Creating a child table

Listing 3.5. Adding another child and additional constraints

Listing 3.6. Adopt an orphan

Listing 3.7. Making views updateable with rules

Listing 3.8. PL/PGSQL BEFORE INSERT trigger function to redirect insert

Listing 3.9. Trigger that dynamically creates tables as needed

Listing 3.10. Binding same trigger function to multiple tables

Chapter 4. Geometry functions

Listing 4.1. Example use of ST_SRID

Listing 4.2. Differences between ST_GeometryType and GeometryType

Listing 4.3. Coordinate and geometry dimensions of various geometries