List of Tables

Chapter 1. What is a spatial database?

Table 1.1. Result of a spatial query

Chapter 2. Geometry types

Table 2.1. Observe how many more points the LINESTRING equivalent takes to approximate a curve.

Chapter 4. Geometry functions

Table 4.1. Results of the preceding code

Table 4.2. Results of code in listing 4.2

Table 4.3. Results of the code in listing 4.3

Table 4.4. Output results of the code in listing 4.4

Table 4.5. Result of the preceding code comparing 3D and 2D lengths

Table 4.6. Results of query in listing 4.5

Table 4.7. Results of the query in listing 4.6 demonstrating sphere versus spheroid lengths

Table 4.8. Results of listing 4.7

Table 4.9. Results of the code in listing 4.8

Table 4.10. Output of listing 4.9

Table 4.11. Output of query in listing 4.10

Table 4.12. Results of the previous code

Table 4.13. Results of code in listing 4.11

Table 4.14. Results of query in previous code

Table 4.15. Result of query in previous code

Table 4.16. Output from query in listing 4.12

Table 4.17. Results of query in listing 4.13

Table 4.18. Results of the query in the previous code

Table 4.19. Results of query in previous code (split into two sections for readability)

Chapter 5. Relationships between geometries

Table 5.1. Result of query in previous code

Table 5.2. The result of the last query in listing 5.1

Table 5.3. Result of the query: All intersect but not all contain.

Table 5.4. Result of query in listing 5.3: List all where the answer of Covers is different from that of Contains.