PostGIS in Action![]() Regina O. Obe and Leo S. Hsu MEAP Began: May 2009 Softbound print: Summer 2010 | 425 pages ISBN: 9781935182269 |
|||
| Pre-Order options* | |||
| Order today and start reading PostGIS in Action today through MEAP | |||
| MEAP + Ebook only - $29.99 | |||
| MEAP + Print book (includes Ebook) when available - $49.99 | |||
| * For more information, please see the MEAP FAQs page. | |||
| About MEAP Release Date Estimates | |||
Table of Contents, MEAP Chapters & Resources
| Table of Contents | Resources |
|
PART I - Learning PostGIS
1. What is a spatial database? - FREE 2. Geometry types - AVAILABLE 3. Data modeling - AVAILABLE 4. Geometry functions - AVAILABLE 5. Relating two or more geometries - AVAILABLE 6. Special reference system considerations - AVAILABLE 7. Working with real data - AVAILABLE Part 2 Putting PostGIS to work 8. Techniques to solve spatial problems - AVAILABLE 9. Performance tuning - AVAILABLE Part 3 Using PostGIS with other tools 10. Enhancing SQL with add-ons - AVAILABLE 11. Using PostGIS in web applications 12. Using PostGIS in a desktop environment - AVAILABLE 13. First look at WKT Raster Appendix A Additional resources - AVAILABLE Appendix B Installing, compiling, and upgrading - AVAILABLE Appendix C SQL primer - AVAILABLE Appendix D PostGreSQL features - AVAILABLE |
|
DESCRIPTION
Whether you're canvassing a congressional district, managing a sales region, mapping city bus schedules, or analyzing local cancer rates, thinking spatially opens up limitless possibilities for database users. PostGIS, a freely available open-source spatial database extender, can help you answer questions that you could not answer using a mere relational database. Its feature set equals or surpasses proprietary alternatives, allowing you to create location-aware queries and features with just a few lines of SQL code.
PostGIS in Action is the first book devoted entirely to PostGIS. It will help both new and experienced users write spatial queries to solve real-world problems. For those with experience in more traditional relational databases, this book provides a background in vector-based GIS so you can quickly move to analyzing, viewing, and mapping data. Advanced users will learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions suited specifically to their applications. It also discusses the new features available in PostgreSQL 8.4 and provides tutorials on using additional open source GIS tools in conjunction with PostGIS.
WHAT'S INSIDE:
- An introduction to spatial databases
- The basics of geometry types, functions, and queries
- Ways to solve real-world problems
- Methods to extend PostGIS to web applications and desktop environments
About the Author
Regina Obe and Leo Hsu are a wife and husband team of database specialists who have been actively involved in the PostGIS community since 2002. Regina is a member of the PostGIS core development team and the Project Steering Committee. Their company, Paragon Corporation, was founded in 1997 and has provided database and GIS solutions for a broad range of clients. They also host two sites: BostonGIS.com and PostgresOnline.com.
About the Early Access Version
This Early Access version of PostGIS in Action enables you to receive new chapters as they are being written. You can also interact with the authors to ask questions, provide feedback and errata, and help shape the final manuscript on the Author Online
Want to learn More?
Sign up to read more content when it is released and to receive news about this book.


