PostGIS 1.3.6 Manual
		Next

PostGIS 1.3.6 Manual

Abstract

PostGIS is an extension to the PostgreSQL object-relational database system which allows GIS (Geographic Information Systems) objects to be stored in the database. PostGIS includes support for GiST-based R-Tree spatial indexes, and functions for analysis and processing of GIS objects.

This is the manual for version 1.3.6

Table of Contents

1. Introduction

1.1. Credits
1.2. More Information

2. Installation

2.1. Requirements

2.2. PostGIS Compile from Source and Install

2.2.1. Creating PostGIS spatially-enabled databases from an in-built template
2.2.2. Upgrading
2.2.3. Common Problems

2.4. Loader/Dumper

3. Frequently Asked Questions

4. Using PostGIS

4.1. GIS Objects

4.1.1. OpenGIS WKB and WKT
4.1.2. PostGIS EWKB, EWKT and Canonical Forms
4.1.3. SQL-MM Part 3

4.2. Using OpenGIS Standards

4.2.1. The SPATIAL_REF_SYS Table
4.2.2. The GEOMETRY_COLUMNS Table
4.2.3. Creating a Spatial Table
4.2.4. Ensuring OpenGIS compliancy of geometries

4.3. Loading GIS Data

4.3.1. Using SQL
4.3.2. Using the Loader

4.4. Retrieving GIS Data

4.4.1. Using SQL
4.4.2. Using the Dumper

4.5. Building Indexes

4.5.1. GiST Indexes
4.5.2. Using Indexes

4.6. Complex Queries

4.6.1. Taking Advantage of Indexes
4.6.2. Examples of Spatial SQL

4.7. Using Mapserver

4.7.1. Basic Usage
4.7.2. Frequently Asked Questions
4.7.3. Advanced Usage
4.7.4. Examples

4.8. Java Clients (JDBC)

4.9. C Clients (libpq)

4.9.1. Text Cursors
4.9.2. Binary Cursors

5. Performance tips

5.1. Small tables of large geometries

5.1.1. Problem description
5.1.2. Workarounds

5.2. CLUSTERing on geometry indices

5.3. Avoiding dimension conversion

6. PostGIS Reference

6.1. OpenGIS Functions

6.1.1. Management Functions
6.1.2. Geometry Relationship Functions
6.1.3. Geometry Processing Functions
6.1.4. Geometry Accessors
6.1.5. Geometry Constructors

6.2. PostGIS Extensions

6.2.1. Management Functions
6.2.2. Operators
6.2.3. Measurement Functions
6.2.4. Geometry Outputs
6.2.5. Geometry Constructors
6.2.6. Geometry Editors
6.2.7. Linear Referencing
6.2.8. Misc
6.2.9. Long Transactions support

6.3. SQL-MM Functions

6.4. ArcSDE Functions

7. Reporting Problems

7.1. Reporting Software Bugs
7.2. Reporting Documentation Issues

A. Appendix

A.1. Release Notes

A.1.1. Release 1.3.6
A.1.2. Release 1.3.5
A.1.3. Release 1.3.4
A.1.4. Release 1.3.3
A.1.5. Release 1.3.2
A.1.6. Release 1.3.1
A.1.7. Release 1.3.0
A.1.8. Release 1.2.1
A.1.9. Release 1.2.0
A.1.10. Release 1.1.6
A.1.11. Release 1.1.5
A.1.12. Release 1.1.4
A.1.13. Release 1.1.3
A.1.14. Release 1.1.2
A.1.15. Release 1.1.1
A.1.16. Release 1.1.0
A.1.17. Release 1.0.6
A.1.18. Release 1.0.5
A.1.19. Release 1.0.4
A.1.20. Release 1.0.3
A.1.21. Release 1.0.2
A.1.22. Release 1.0.1
A.1.23. Release 1.0.0
A.1.24. Release 1.0.0RC6
A.1.25. Release 1.0.0RC5
A.1.26. Release 1.0.0RC4
A.1.27. Release 1.0.0RC3
A.1.28. Release 1.0.0RC2
A.1.29. Release 1.0.0RC1

		Next
		Chapter 1. Introduction