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