PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu
Is PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu publication your favourite reading? Is fictions? Exactly how's about record? Or is the most effective seller unique your choice to fulfil your spare time? Or perhaps the politic or religious publications are you looking for currently? Right here we go we provide PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu book collections that you need. Bunches of varieties of books from numerous areas are supplied. From fictions to scientific research and also spiritual can be searched as well as figured out right here. You could not worry not to locate your referred publication to check out. This PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu is among them.
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu
Ebook PDF Online PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu
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.
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
PART 1 INTRODUCTION TO POSTGIS- Amazon Sales Rank: #381313 in Books
- Brand: Obe, Regina O./ Hsu, Leo S.
- Published on: 2015-05-03
- Original language: English
- Number of items: 1
- Dimensions: 9.20" h x 1.20" w x 7.30" l, .0 pounds
- Binding: Paperback
- 600 pages
About the Author
Regina Obe is a co-principal of Paragon Corporation, a database consulting company based in Boston. She has over 15 years of professional experience in various programming languages and database systems, with special focus on spatial databases. She is a member of the PostGIS steering committee and the PostGIS core development team. Regina holds a BS degree in mechanical engineering from the Massachusetts Institute of Technology. She co-authored PostGIS in Action.
Leo Hsu is a co-principal of Paragon Corporation, a database consulting company based in Boston. He has over 15 years of professional experience developing and thinking about databases for organizations large and small. Leo holds an MS degree in engineering of economic systems from Stanford University and BS degrees in mechanical engineering and economics from the Massachusetts Institute of Technology. He co-authored PostGIS in Action.
Where to Download PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu
Most helpful customer reviews
6 of 6 people found the following review helpful. Start your spatial database exploration By Kosmas Chatzimichalis This is another book from Manning publications in the excellent '.. in Action' series, which guides the reader through some practical uses of the book's subject. In this case the subject is PostGIS, which for people that come across the term for the first time, is a spatial database extender for the PostgreSQL database management system. As described in the introduction the audience of this book includes GIS Practitioners and Programmers, DB Practitioners as well as Scientists, Researchers, Educators and Engineers. That makes it obvious that the audience covers a wide spectrum of professionals that would have various degrees of experience with the subject matter.The material is divided in three main parts, which are: Learning PostGIS, Putting PostGIS to work, and Using PostGIS with other tools as well as four additional appendices.The first part about Learning PostGIS is an introduction to GIS database concepts and practices, that introduces the geometry, geography, raster and topology types and what problems can be solved by each one of them. There is a thorough explanation of what PostGIS is and what you can do with a spatially enabled database that is not possible with a relational database. There are also chapters describing the spatial types that PostGIS offers and their related functions, an introduction to spatial reference systems and their concepts, tools for loading spatial data as well as desktop tools for viewing and querying them, and the use of geometry, geography and raster functions, geocoding and finally an introduction to spatial relationships.The second part Putting PostGIS to work, is where all the pieces are put together, using the theory foundation from the previous part, in order to solve real world problems to questions like: which places are within X distance and what are the N closest places?These cover the traditional methods of finding closest neighbours as well as KNN indexes. Following that there is a section dedicated to geotagging. Geometry and geography processing has its own chapter to demonstrate techniques to manipulate geometries, and some of the most common problems and solutions related to them. Other chapters include raster processing, topology which includes creating a topology, and building and working with topogeometries as well as the simplification and validation of them. The final two chapters of this part offer the reader practical solutions in how to organise the spatial storage depending on the requirements, and some very useful tips about query performance tuning and optimisations. It should be also noted that throughout the book there are plenty of examples for the reader to follow, and especially in this part, that are of great practical use.In the Using PostGIS with other tools part we are told how PostGIS can be extended by means of add-ons like the PostgreSQL procedural languages PL/R and PL/Python that allows us to use the wealth of statistical functions and plotting capabilities of R as well as the numerous Python packages. A variety of travelling-salesperson problems are displayed in this section, and the pgRouting used for building routing applications is also covered. The remaining chapters cover server-side mapping servers and client-side mapping frameworks to display PostGIS data on the web.Finally the appendices have a very useful section with additional resources, instruction for installing PostGIS, an SQL primer and a separate section with the PostgreSQL features that includes table inheritance, roles, functions and performance tips.To summarise, this is an extremely useful book for a variety of professional people interested in discovering PostGIS and at the same time PostgreSQL. It does not require any previous knowledge of geospatial databases as there is a great explanation and coverage of the theory, systems and tools needed. It would be helpful if the reader has some knowledge of SQL in order to follow the examples provided, even though there is very good appendix that covers SQL.A highly recommended book for starting your exploration in the world of spatial databases.Disclosure of Material Connection: I received this book free from the publisher. I was not required to write a positive review. The opinions I have expressed are my own. Regardless, I only recommend products or services I use personally and believe will add value to readers.
3 of 3 people found the following review helpful. The only book you'll need to learn PostGIS By Samuel Bosch While the official PostGIS documentation is already really good, this book will give you torough overview of the functionality provided by PostGIS. It has a lot of code snippets, examples, comparisons between older and newer versions of PostGIS, comparisons with other spatial databases and is very well written. The nicest thing about this book is that you can benefit from the experience of the authors because the book is full advice like: "Although it might appear that ST_Disjoint would be used frequently, this isn’t the case. The problem with ST_Disjoint is that it can’t use an index."I would recommend this book to anyone who is interested in improving his PostGIS skills, whether he is a beginner or not. For beginners it contains introductory chapters on GIS concepts like projection systems and more experienced people will still learn a lot in the later chapters like for example the nuances of the different intersection functions (clip, overlap, crosses,...), the "new" raster functions and many more.
2 of 2 people found the following review helpful. Great for GIS Server Systems, but SpatiaLite import/export desire By Mark D. Wiygul I think this is the BEST, Concise reference to PostGIS GIS Systems, with the right amount of material covering the essence of ProstgreSQL Servers. However, it doesn't do diligence to SpatiaLite, the perfect companion-dataset for those needing a single-file-portability option, for those needing to import/export To and From with a single file.[ SpatiaLite is a modern, lightning fast GIS database file using the Open Geospatial Consortium's "Simple Feature Access" standard and the lightning fast SQLite database file format, and can easily used with open GIS systems, yet it is FAR superior to GIS formats like GeoJSON, KML and other basic shape formats (numerous "ShapeFiles" can be migrated into a single spatiaLite.sqlite file, much like an access.mdb file, except that It's MUCH quicker and with the added bonus of SQL power ]Together, a GIS system featuring a server side database, [PostGIS] and a single-file-portable database [Spatialite] really empower and complement once another, and so I'm expecting the best book available on PostGIS to cover it's companion a bit. (Every GIS System should have operators experienced with both)But since this book deals with "PostGIS" I perhaps shouldn't expect more than it delivers. Still, it would have been nice to include insight into how powerful that duo work together, and it would have been nice to have more details about exporting/importing Spatialite.sqlite files to and from a PostGIS System with ease. Many GIS users would have appreciated it.Still, this is such a valuable resource that it demands a 5 star rating.
See all 5 customer reviews... PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. HsuPostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu PDF
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu iBooks
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu ePub
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu rtf
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu AZW
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu Kindle
Tidak ada komentar:
Posting Komentar