- Taschenbuch: 600 Seiten
- Verlag: Manning; Auflage: 2. (28. November 2014)
- Sprache: Englisch
- ISBN-10: 1617291390
- ISBN-13: 978-1617291395
- Größe und/oder Gewicht: 18,5 x 3 x 23,4 cm
- Durchschnittliche Kundenbewertung: 1 Kundenrezension
- Amazon Bestseller-Rang: Nr. 96.474 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
PostGIS in Action (Englisch) Taschenbuch – 28. November 2014
Wird oft zusammen gekauft
Kunden, die diesen Artikel gekauft haben, kauften auch
Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.
Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.
Wenn Sie dieses Produkt verkaufen, möchten Sie über Seller Support Updates vorschlagen?
Über den Autor und weitere Mitwirkende
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."
Welche anderen Artikel kaufen Kunden, nachdem sie diesen Artikel angesehen haben?
Derzeit tritt ein Problem beim Filtern der Rezensionen auf. Bitte versuchen Sie es später noch einmal.
The book is most useful for GIS developers and architects wanting an in-depth introduction to topics such as projections, spatial reference systems, GIS functions, geometric relationships, spatial queries, Geo-topologies, and proximity analysis. The wealth of concrete examples allows the reader to gain practical experience in loading data into spatial databases, transforming and analyzing data with spatial queries, and displaying the results with desktop viewing tools.
All aspects of geographic databases are covered such as geometry, geography, vectors, rasters, and geocoding. Useful Appendices contain collections of general PostGIS resources, instructions on installing and upgrading PostGIS installations, a SQL quick-start primer, and a compendium of PostgreSQL features with a special emphasis on ANSI standards and how they compare with other spatial databases.
The book has served me well to get started with PostGIS. Installation of the PostgreSQL database engine, PostGIS extensions, and spatial tools on Windows went surprisingly smoothly with the the help of EnterpriseDb's Stackbuilder. I was able to follow the examples easily, using the code downloaded from the publisher's web site to load the initial data sets and to avoid excessive typing chores. Coming from a background of MySQL and SQL Server, I was impressed by PostgreSQL's comprehensive feature set, the ability of PostGIS and its associated tools to import and export virtually every GIS format known to man, the extensive support community it enjoys, and--not least--its attractive price tag.
I found just one serious error in the entire book of almost 600 pages: the claim "[MySQL 5.6]…allowed spatial indexes on its InnoDB storage engine." on page 12 is incorrect. InnoDB tables support spatial data types, but not indexes on them.
If you want to learn about how PostGIS can help you address your spatial database needs, this book is for you.
*** 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. ***
Die hilfreichsten Kundenrezensionen auf Amazon.com
The online documentation for PostgreSQL itself is quite good and detailed. The documentation for the 3rd party PostGIS extension is not nearly as comprehensive.
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>