Table of Contents

 

Copyright

Brief Table of Contents

Table of Contents

Foreword

Preface

Acknowledgments

About this Book

About the Cover Illustration

1. Learning PostGIS

Chapter 1. What is a spatial database?

1.1. Thinking spatially

1.1.1. Introducing the geometry data type

1.2. Modeling

1.2.1. Imagine the possibilities

1.3. Introducing PostgreSQL and PostGIS

1.3.1. PostgreSQL strengths

1.3.2. PostGIS, adding GIS to PostgreSQL

1.3.3. Alternatives to PostgreSQL and PostGIS

1.3.4. What works with PostGIS

1.4. Getting started with PostGIS

1.4.1. Verifying version of PostGIS and PostgreSQL

1.4.2. Creating geometries with PostGIS

1.5. Working with real data

1.5.1. Loading comma-separated data

1.5.2. Spatializing flat file data

1.5.3. Loading data from spatial data sources

1.6. Using spatial queries to analyze data

1.6.1. Proximity queries

1.6.2. Viewing spatial data with OpenJUMP

1.7. Summary

Chapter 2. Geometry types

2.1. Geometry columns in PostGIS

2.1.1. The geometry_columns table

2.1.2. Interacting with the geometry_columns table

2.2. A panoply of geometries

2.2.1. What���s a geometry?

2.2.2. Points

2.2.3. Linestrings

2.2.4. Polygons

2.2.5. Collection geometries

2.2.6. Curved geometries

2.2.7. 3D geometries

2.3. Summary

Chapter 3. Organizing spatial data

3.1. Spatial storage approaches

3.1.1. Heterogeneous geometry columns