PDF Download PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu
Just connect to the net to get this book PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu This is why we indicate you to utilize and utilize the established technology. Reading book does not imply to bring the printed PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu Developed technology has actually allowed you to check out only the soft file of the book PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu It is same. You could not have to go as well as obtain conventionally in looking guide PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu You may not have adequate time to spend, may you? This is why we provide you the very best method to obtain guide PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu now!
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu
PDF Download PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu
This is it the book PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu to be best seller lately. We give you the best offer by obtaining the incredible book PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu in this internet site. This PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu will certainly not just be the kind of book that is hard to discover. In this web site, all sorts of publications are supplied. You could search title by title, author by author, and also publisher by author to learn the very best book PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu that you could check out now.
If you get the printed book PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu in online book establishment, you might likewise locate the exact same problem. So, you have to move establishment to store PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu as well as search for the available there. However, it will certainly not occur here. Guide PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu that we will certainly offer right here is the soft file principle. This is exactly what make you can quickly discover as well as get this PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu by reading this website. Our company offer you PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu the best product, always and also consistently.
Never question with our offer, since we will certainly always provide just what you need. As similar to this updated book PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu, you might not locate in the various other place. Yet here, it's quite simple. Just click as well as download and install, you could possess the PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu When simplicity will reduce your life, why should take the complex one? You can buy the soft file of guide PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu here as well as be participant of us. Besides this book PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu, you can likewise locate hundreds lists of guides from many sources, compilations, authors, and authors in around the world.
By clicking the link that we provide, you can take guide PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu perfectly. Link to net, download, and also conserve to your tool. What else to ask? Reading can be so simple when you have the soft data of this PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu in your gadget. You could likewise duplicate the data PostGIS In Action, 2nd Edition, By Regina O. Obe, Leo S. Hsu to your office computer system or in the house or perhaps in your laptop computer. Merely discuss this excellent news to others. Recommend them to see this web page and also get their hunted for publications 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
What is a spatial database?Spatial data typesSpatial reference system considerationsWorking with real dataUsing PostGIS on the desktopGeometry and geography functionsRaster functionsPostGIS TIGER geocoderGeometry relationshipsPART 2 PUTTING POSTGIS TO WORK
Proximity analysisGeometry and geography processingRaster processingBuilding and using topologiesOrganizing spatial dataQuery performance tuningPART 3 USING POSTGIS WITH OTHER TOOLS
Extending PostGIS with pgRouting and procedural languagesUsing PostGIS in web applications - Sales Rank: #485281 in Books
- 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.
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.
2 of 2 people found the following review helpful.
Great for GIS Server Systems, but SpatiaLite import/export desire
By Mark
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.
4 of 4 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.
See all 6 customer reviews...
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu PDF
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 Doc
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 rtf
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu Mobipocket
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu Kindle
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu PDF
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu PDF
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu PDF
PostGIS in Action, 2nd Edition, by Regina O. Obe, Leo S. Hsu PDF
