Ebook1,460 pages11 hours
PostGIS in Action, Second Edition
By Leo S. Hsu and Regina O. Obe
Rating: 4 out of 5 stars
4/5
()
About this ebook
Summary
PostGIS in Action, Second Edition teaches readers of all levels to write spatial queries that solve real-world problems. It first gives you a background in vector-, raster-, and topology-based GIS and then quickly moves into analyzing, viewing, and mapping data. This second edition covers PostGIS 2.0 and 2.1 series, PostgreSQL 9.1, 9.2, and 9.3 features, and shows you how to integrate with other GIS tools.
Foreword by Paul Ramsey.
Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.
About the Book
Processing data tied to location and topology requires specialized know-how. PostGIS is a free spatial database extender for PostgreSQL, every bit as good as proprietary software. With it, you can easily create location-aware queries in just a few lines of SQL code and build the back end for a mapping, raster analysis, or routing application with minimal effort.
PostGIS in Action, Second Edition teaches you to solve real-world geodata problems. It first gives you a background in vector-, raster-, and topology-based GIS and then quickly moves into analyzing, viewing, and mapping data. You'll learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions for your own applications. You'll also learn how to apply your existing GIS knowledge to PostGIS and integrate with other GIS tools.
Familiarity with relational database and GIS concepts is helpful but not required.
What's Inside
About the Authors
Regina Obe and Leo Hsu are database consultants and authors. Regina is a member of the PostGIS core development team and the Project Steering Committee.
Table of Contents
PART 1 INTRODUCTION TO POSTGIS PART 2 PUTTING POSTGIS TO WORK PART 3 USING POSTGIS WITH OTHER TOOLS
PostGIS in Action, Second Edition teaches readers of all levels to write spatial queries that solve real-world problems. It first gives you a background in vector-, raster-, and topology-based GIS and then quickly moves into analyzing, viewing, and mapping data. This second edition covers PostGIS 2.0 and 2.1 series, PostgreSQL 9.1, 9.2, and 9.3 features, and shows you how to integrate with other GIS tools.
Foreword by Paul Ramsey.
Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications.
About the Book
Processing data tied to location and topology requires specialized know-how. PostGIS is a free spatial database extender for PostgreSQL, every bit as good as proprietary software. With it, you can easily create location-aware queries in just a few lines of SQL code and build the back end for a mapping, raster analysis, or routing application with minimal effort.
PostGIS in Action, Second Edition teaches you to solve real-world geodata problems. It first gives you a background in vector-, raster-, and topology-based GIS and then quickly moves into analyzing, viewing, and mapping data. You'll learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions for your own applications. You'll also learn how to apply your existing GIS knowledge to PostGIS and integrate with other GIS tools.
Familiarity with relational database and GIS concepts is helpful but not required.
What's Inside
- An introduction to spatial databases
- Geometry, geography, raster, and topology spatial types, functions, and queries
- Applying PostGIS to real-world problems
- Extending PostGIS to web and desktop applications
- Updated for PostGIS 2.x and PostgreSQL 9.x
About the Authors
Regina Obe and Leo Hsu are database consultants and authors. Regina is a member of the PostGIS core development team and the Project Steering Committee.
Table of Contents
- What is a spatial database?
- Spatial data types
- Spatial reference system considerations
- Working with real data
- Using PostGIS on the desktop
- Geometry and geography functions
- Raster functions
- PostGIS TIGER geocoder
- Geometry relationships
- Proximity analysis
- Geometry and geography processing
- Raster processing
- Building and using topologies
- Organizing spatial data
- Query performance tuning
- Extending PostGIS with pgRouting and procedural languages
- Using PostGIS in web applications
PART 1 INTRODUCTION TO POSTGIS PART 2 PUTTING POSTGIS TO WORK PART 3 USING POSTGIS WITH OTHER TOOLS
Author
Leo S. Hsu
Leo Hsu is co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 25 years of professional experience developing and thinking about databases for organizations large and small. He also holds a lectureship at Tufts University, teaching SQL to graduate level students. He has coauthored several database books with his wife Regina Obe.
Related to PostGIS in Action, Second Edition
Related ebooks
ArcGIS Web Development Rating: 0 out of 5 stars0 ratingsPostGIS Cookbook Rating: 0 out of 5 stars0 ratingsPostGIS in Action, Third Edition Rating: 0 out of 5 stars0 ratingsPython Geospatial Development - Third Edition Rating: 4 out of 5 stars4/5OpenStreetMap Rating: 5 out of 5 stars5/5Geoprocessing with Python Rating: 0 out of 5 stars0 ratingsNeo4j in Action Rating: 0 out of 5 stars0 ratingsPython Geospatial Analysis Cookbook Rating: 0 out of 5 stars0 ratingsHadoop in Practice Rating: 0 out of 5 stars0 ratingsReactive Design Patterns Rating: 0 out of 5 stars0 ratingsAspectJ in Action: Enterprise AOP with Spring Applications Rating: 0 out of 5 stars0 ratingsMastering Large Datasets with Python: Parallelize and Distribute Your Python Code Rating: 0 out of 5 stars0 ratingsD3.js in Action: Data visualization with JavaScript Rating: 0 out of 5 stars0 ratingsSpark GraphX in Action Rating: 0 out of 5 stars0 ratingsBig Data: Principles and best practices of scalable realtime data systems Rating: 4 out of 5 stars4/5Scala in Action Rating: 0 out of 5 stars0 ratingsLocation-Aware Applications Rating: 0 out of 5 stars0 ratingsFunctional and Reactive Domain Modeling Rating: 0 out of 5 stars0 ratingshapi.js in Action Rating: 0 out of 5 stars0 ratingsQGIS Blueprints Rating: 0 out of 5 stars0 ratingsThe Well-Grounded Java Developer: Vital techniques of Java 7 and polyglot programming Rating: 4 out of 5 stars4/5Practical GIS Rating: 0 out of 5 stars0 ratingsMastering PostGIS Rating: 0 out of 5 stars0 ratingsMastering ArcGIS Server Development with JavaScript Rating: 4 out of 5 stars4/5GeoServer Cookbook Rating: 0 out of 5 stars0 ratingsGeospatial Development By Example with Python Rating: 5 out of 5 stars5/5Spatial Databases: With Application to GIS Rating: 4 out of 5 stars4/5ArcGIS Server Third Edition Rating: 0 out of 5 stars0 ratingsPython Geospatial Development Rating: 4 out of 5 stars4/5Learning R for Geospatial Analysis Rating: 0 out of 5 stars0 ratings
Computers For You
Mastering ChatGPT: 21 Prompts Templates for Effortless Writing Rating: 5 out of 5 stars5/5How to Create Cpn Numbers the Right way: A Step by Step Guide to Creating cpn Numbers Legally Rating: 4 out of 5 stars4/5SQL QuickStart Guide: The Simplified Beginner's Guide to Managing, Analyzing, and Manipulating Data With SQL Rating: 4 out of 5 stars4/5Elon Musk Rating: 4 out of 5 stars4/5The ChatGPT Millionaire Handbook: Make Money Online With the Power of AI Technology Rating: 0 out of 5 stars0 ratingsUltimate Guide to Mastering Command Blocks!: Minecraft Keys to Unlocking Secret Commands Rating: 5 out of 5 stars5/5Learning the Chess Openings Rating: 5 out of 5 stars5/5Grokking Algorithms: An illustrated guide for programmers and other curious people Rating: 4 out of 5 stars4/5CompTIA Security+ Get Certified Get Ahead: SY0-701 Study Guide Rating: 5 out of 5 stars5/5CompTIA IT Fundamentals (ITF+) Study Guide: Exam FC0-U61 Rating: 0 out of 5 stars0 ratingsProcreate for Beginners: Introduction to Procreate for Drawing and Illustrating on the iPad Rating: 0 out of 5 stars0 ratingsArtificial Intelligence: The Complete Beginner’s Guide to the Future of A.I. Rating: 4 out of 5 stars4/5101 Awesome Builds: Minecraft® Secrets from the World's Greatest Crafters Rating: 4 out of 5 stars4/5Tor and the Dark Art of Anonymity Rating: 5 out of 5 stars5/5Network+ Study Guide & Practice Exams Rating: 4 out of 5 stars4/5Slenderman: Online Obsession, Mental Illness, and the Violent Crime of Two Midwestern Girls Rating: 4 out of 5 stars4/5CompTIA Security+ Practice Questions Rating: 2 out of 5 stars2/5Remote/WebCam Notarization : Basic Understanding Rating: 3 out of 5 stars3/5Master Builder Roblox: The Essential Guide Rating: 4 out of 5 stars4/5The Professional Voiceover Handbook: Voiceover training, #1 Rating: 5 out of 5 stars5/5Everybody Lies: Big Data, New Data, and What the Internet Can Tell Us About Who We Really Are Rating: 4 out of 5 stars4/5What Video Games Have to Teach Us About Learning and Literacy. Second Edition Rating: 4 out of 5 stars4/5The Mega Box: The Ultimate Guide to the Best Free Resources on the Internet Rating: 4 out of 5 stars4/5
Reviews for PostGIS in Action, Second Edition
Rating: 4 out of 5 stars
4/5
1 rating0 reviews
Book preview
PostGIS in Action, Second Edition - Leo S. Hsu
|1a book_preview_excerpt.html rW-+/c( *YF
AJ:cc@f L=?y9zu>`GKrߗȈLR}flØu;ŷo,wvoşWM&tU9InYUΓyoXok"/an%&仦ziy:֛:_,۸ ,2V*sUϳ:/Iu˼eV'iYɴI.ɒ??<<Z&YE6d7+F@w2++[mnuUս3EiS2u6"II.uZ}=f40:wJb P/yx~%oY"_5$y_*͋o\o՟m<߭o_=KkrZ iIlm`=*$Buy7d*M[M{[ٽ`il5I:-Uhf&q$+@>/e*JeV39)2
FRțl[ WnrhaFa &B:6
U2
֏Crs)C:l.4>eNh'k$Rj--FBӢ\ɧy!|/s"s,XZ̈́~-'5k'}
FɱlM3p:mfA/t"_ 9ŧQ9uؖeQ72W7go/>z~gGXM[JnY?M%ϓ=s|.x$?lT1U~J.p]%].B}
*k
䵁ܑكpA0l]Y=,V#C9*b?=:LV!ToxLzf-6/M&fmӵ= meBv*3V5SaUߑȡ^g?;L~l7mU][w0yU+6c8o+rŜ\[ӱlYUT|' w!$.
lr8mb" VUsPBO/IrY]-#fѥ}=a7D2Oɩ|seX<|%:rgB j
.Հ}=:C,=r}_ຯ)yoTGsAO˻lA0=
8!?gI|Lv;bF6#M6'h r}HDݩ2*md˄W#MerC27Dp{LOy0w [m Gx[wHYjP-)\1I+7#>;͇XIMѽD/~Sٜ1k4}FkP7rƶk2lMuWoǾ.ySA/j*DŽlxgqE51]|YUt;!խm8uLIL76ƍ7z1|rDIQ6Wfxυanu2^\]6ߨa#&lK'zeXDzr)e"lJ