PDF PostGIS in Action 2nd Edition Regina O Obe Leo S Hsu 9781617291395 Books
PDF PostGIS in Action 2nd Edition Regina O Obe Leo S Hsu 9781617291395 Books
Download As PDF : PostGIS in Action 2nd Edition Regina O Obe Leo S Hsu 9781617291395 Books
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, , 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
PDF PostGIS in Action 2nd Edition Regina O Obe Leo S Hsu 9781617291395 Books
"A great book. Complete and well-written."
Product details
|
Tags : PostGIS in Action, 2nd Edition [Regina O. Obe, Leo S. Hsu] on . <div> <b>Summary</b> PostGIS in Action, Second Edition</i> teaches readers of all levels to write spatial queries that solve real-world problems. It first gives you a background in vector,Regina O. Obe, Leo S. Hsu,PostGIS in Action, 2nd Edition,Manning Publications,1617291390,Programming Languages - Python,Database searching,Database searching.,Geographic information systems,Geographic information systems.,ArcGIS; ESRI; GML; GeoJson; KML; MapInfo; OpenStreetMap; Oracle Spatial; PostGIS; SQL; SQL Server spatial; Shapefile; database; geography; geometry; gis; javascript; json; mapping; pgRouting; pl/Pgsql; pl/Python; pl/R; python; raster; relational; routing; spatial; topology; vector,ArcGIS;ESRI;GML;GeoJson;KML;MapInfo;OpenStreetMap;Oracle Spatial;PostGIS;SQL;SQL Server spatial;Shapefile;database;geography;geometry;gis;javascript;json;mapping;pgRouting;pl/Pgsql;pl/Python;pl/R;python;raster;relational;routing;spatial;topology;vector,COMPUTER,COMPUTERS / Computer Science,COMPUTERS / Data Processing,COMPUTERS / Databases / Data Mining,COMPUTERS / Desktop Applications / Databases,COMPUTERS / Desktop Applications / General,COMPUTERS / Programming / Open Source,COMPUTERS / Programming Languages / General,COMPUTERS / Programming Languages / JavaScript,COMPUTERS / Programming Languages / Python,COMPUTERS / Programming Languages / SQL,COMPUTERS / Software Development Engineering / Tools,COMPUTERS / Web / General,COMPUTERS / Web / Web Programming,Computer - Internet,Computer Applications,Computer Books Database,Computer Science,Computer/Databases,Computers,Computers/Computer Science,Computers/Data Processing,Computers/Databases - Data Mining,Database searching,Database searching.,Databases - Data Mining,Geographic information systems,Geographic information systems.,How-to/Do-it-yourself,Non-Fiction,Programming Languages - Python,Scholarly/Undergraduate,United States,Web - Web Programming,COMPUTERS / Computer Science,COMPUTERS / Data Processing,COMPUTERS / Databases / Data Mining,COMPUTERS / Desktop Applications / Databases,COMPUTERS / Desktop Applications / General,COMPUTERS / Programming / Open Source,COMPUTERS / Programming Languages / General,COMPUTERS / Programming Languages / JavaScript,COMPUTERS / Programming Languages / Python,COMPUTERS / Programming Languages / SQL,COMPUTERS / Software Development Engineering / Tools,COMPUTERS / Web / General,COMPUTERS / Web / Web Programming,Computer Science,Computers/Computer Science,Computers/Data Processing,Computers/Databases - Data Mining,Databases - Data Mining,Web - Web Programming,Computer - Internet,Computers,Computer Books Database
PostGIS in Action 2nd Edition Regina O Obe Leo S Hsu 9781617291395 Books Reviews :
PostGIS in Action 2nd Edition Regina O Obe Leo S Hsu 9781617291395 Books Reviews
- His is an excellent book full of real world examples plus you can download the PDF once you purchase which I ended up using more. Finally this authors sense of humor is spot on.
" what's the average distance to a hospital?. Which three hospitals offer emergence vasectomies?" When you find yourself laughing in a Starbucks practicing for your next job through this book you can't help but give a great review! - Do not buy the version. All Manning books are great. I cannot recommend them enough, but this version is not properly laid out. It is hard to read and near impossible to follow along. I want this book, but it is a better idea to buy the PDF from Manning directly.
- I'm a PhD student in geography and this is the best PostGIS resource I've found. There isn't much out there (even on the internet) in terms of tutorials and help for PostGIS, so I took a chance and bought this. The book gives tons of examples which are fun to follow along with. I've read just about everything through the first 250 pages and plan on reading to the end.
- Very through and detailed
- A great book. Complete and well-written.
- Lovely approach and lead in..
- 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 <em>Learning PostGIS</em>, <em>Putting PostGIS to work</em>, and <em>Using PostGIS with other tools</em> as well as four additional appendices.
The first part about <em>Learning PostGIS</em> 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 <em>Putting PostGIS to work</em>, 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 <em>Using PostGIS with other tools part</em> 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.
<em>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.</em> - 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.
Comments
Post a Comment