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

Listing 2.10. Creating a compoundcurve

Listing 2.11. Creating curvepolygons

Listing 2.12. Using the geography data type

Listing 2.13. How far am I from pizza (spheroid distance)

Listing 2.14. Creating a raster table of the world

Chapter 3. Spatial reference system considerations

Listing 3.1. Determining the WGS 84 UTM SRID of a geometry

Listing 3.2. Using functional indexes

Chapter 4. Working with real data

Listing 4.1. Using Wget to download a batch of files

Listing 4.2. Displaying info about GPX file using ogrinfo

Listing 4.3. Loading data from GPX into a single table

Listing 4.4. Use ogrinfo to list fields for a personal geodatabase layer

Listing 4.5. Loading MapInfo files

Listing 4.6. Export PostGIS table and query to KML