List of Tables

Chapter 1. What is a spatial database?

Table 1.1. Results of a spatial query

Chapter 2. Spatial data types

Table 2.1. The structure of the geometry_columns view

Chapter 3. Spatial reference system considerations

Table 3.1. Common ellipsoids

Table 3.2. Common spatial reference systems and their fitness for particular purposes

Table 3.3. Results of distance calculations in kilometers

Table 3.4. Ten-meter buffer areas in different regions of the world

Chapter 5. Using PostGIS on the desktop

Table 5.1. Summary of tools based on architecture, language, OS, and setup

Table 5.2. Spatial database support

Table 5.3. Vector file data formats

Table 5.4. Raster file data formats

Table 5.5. Web services support

Chapter 6. Geometry and geography functions

Table 6.1. Results of listing 6.1

Table 6.2. Using ST_GeometryType and GeometryType

Table 6.3. Differences between geometry dimension and coordinate dimension

Table 6.4. Difference between ST_NumPoints and ST_NPoints in PostGIS 2.1.3

Table 6.5. Comparing 2D and 3D lengths

Table 6.6. Output of ST_Boundary

Table 6.7. ST_Simplify versus ST_SimplifyPreserveTopology

Chapter 9. Geometry relationships

Table 9.1. PostGIS geometry comparators

Table 9.2. WKT of sales regions

Table 9.3. Where all intersect but not all contain

Table 9.4. Where ST_Covers differs from ST_Contains

Table 9.5. Where contains and contains properly are different

Table 9.6. Geometries that touch each other

Table 9.7. Geometries that cross each other