Download E-books PostGIS in Action, 2nd Edition PDF


PostGIS in motion, moment Edition teaches readers of all degrees to jot down spatial queries that resolve real-world difficulties. It first offers a heritage in vector-, raster-, and topology-based GIS after which speedy strikes into reading, viewing, and mapping information. This moment version covers PostGIS 2.0 and 2.1 sequence, PostgreSQL 9.1, 9.2, and 9.3 good points, and exhibits you ways to combine with different GIS tools.

Purchase of the print ebook features a unfastened publication in PDF, Kindle, and ePub codecs from Manning Publications.

About the Book

Processing facts tied to situation and topology calls for really good knowledge. PostGIS is a loose spatial database extender for PostgreSQL, every piece pretty much as good as proprietary software program. With it, you could simply create location-aware queries in exactly a number of traces of SQL code and construct the again finish for a mapping, raster research, or routing program with minimum effort.

PostGIS in motion, moment Edition teaches you to resolve real-world geodata difficulties. It first promises a history in vector-, raster-, and topology-based GIS after which quick strikes into reading, viewing, and mapping information. you are going to find out how to optimize queries for max pace, simplify geometries for higher potency, and create customized features on your personal purposes. you will additionally the right way to follow your current GIS wisdom to PostGIS and combine with different GIS tools.

Familiarity with relational database and GIS thoughts is beneficial yet no longer required.

What's Inside

  • An creation to spatial databases
  • Geometry, geography, raster, and topology spatial forms, features, and queries
  • Applying PostGIS to real-world problems
  • Extending PostGIS to internet and computer applications
  • Updated for PostGIS 2.x and PostgreSQL 9.x

About the Authors

Regina Obe and Leo Hsu are database specialists and authors. Regina is a member of the PostGIS center improvement crew and the undertaking steerage Committee.

Table of Contents

    PART 1 advent TO POSTGIS
  1. What is a spatial database?
  2. Spatial info types
  3. Spatial reference process considerations
  4. Working with genuine data
  5. Using PostGIS at the desktop
  6. Geometry and geography functions
  7. Raster functions
  8. PostGIS TIGER geocoder
  9. Geometry relationships
  10. PART 2 placing POSTGIS TO WORK
  11. Proximity analysis
  12. Geometry and geography processing
  13. Raster processing
  14. Building and utilizing topologies
  15. Organizing spatial data
  16. Query functionality tuning
  17. PART three utilizing POSTGIS WITH different TOOLS
  18. Extending PostGIS with pgRouting and procedural languages
  19. Using PostGIS in internet applications

Show description

Read or Download PostGIS in Action, 2nd Edition PDF

Similar Computer Science books

Programming Massively Parallel Processors: A Hands-on Approach (Applications of GPU Computing Series)

Programming hugely Parallel Processors discusses easy techniques approximately parallel programming and GPU structure. ""Massively parallel"" refers back to the use of a giant variety of processors to accomplish a suite of computations in a coordinated parallel means. The e-book info numerous strategies for developing parallel courses.

TCP/IP Sockets in C#: Practical Guide for Programmers (The Practical Guides)

"TCP/IP sockets in C# is a wonderful publication for a person drawn to writing community purposes utilizing Microsoft . internet frameworks. it's a distinct blend of good written concise textual content and wealthy rigorously chosen set of operating examples. For the newbie of community programming, it is a strong beginning ebook; nevertheless execs make the most of very good convenient pattern code snippets and fabric on issues like message parsing and asynchronous programming.

Computational Network Science: An Algorithmic Approach (Computer Science Reviews and Trends)

The rising box of community technological know-how represents a brand new form of learn which may unify such traditionally-diverse fields as sociology, economics, physics, biology, and desktop technological know-how. it's a strong device in studying either traditional and man-made platforms, utilizing the relationships among gamers inside those networks and among the networks themselves to realize perception into the character of every box.

Computer Organization and Design: The Hardware Software Interface: ARM Edition (The Morgan Kaufmann Series in Computer Architecture and Design)

The hot ARM variation of laptop association and layout includes a subset of the ARMv8-A structure, that is used to offer the basics of applied sciences, meeting language, desktop mathematics, pipelining, reminiscence hierarchies, and I/O. With the post-PC period now upon us, computing device association and layout strikes ahead to discover this generational swap with examples, workouts, and fabric highlighting the emergence of cellular computing and the Cloud.

Extra info for PostGIS in Action, 2nd Edition

Show sample text content

25 -1. 25, -0. 25 1. 25, 2. five 1. 25, 2. five -1. 25, -0. 25 -1. 25), (2. 25 zero, 1. 25 1, 1. 25 -1, 2. 25 0), (1 -1, 1 1, zero zero, 1 -1))')) the place path[1] IN(0,1); desk four. 14 result of question in earlier code exterior_ring_polygon POLYGON((-0. 25 -1. 25, -0. 25 1. 25, 2. five 1. 25…)) interior_ring1_polygon POLYGON((2. 25 zero, 1. 25 1, 1. 25 -1, 2. 25 0)) We now practice a similar extraction utilizing ST_ExteriorRing and ST_InteriorRingN. keep in mind that those features go back the earrings as linestrings. the consequences are proven in desk four. 15. decide upon ST_AsText(ST_ExteriorRing(geom)) As exterior_ring, ST_AsText(ST_InteriorRingN(geom,1)) As interior_ring1 FROM ST_GeomFromText('POLYGON((-0. 25 -1. 25,-0. 25 1. 25,2. five 1. 25, 2. five -1. 25,-0. 25 -1. 25), (2. 25 0,1. 25 1,1. 25 -1,2. 25 0), (1 -1,1 1,0 0,1 -1))') As geom; desk four. 15 results of question in prior code exterior_ring LINESTRING(-0. 25 -1. 25, -0. 25 1. 25, 2. five 1. 25…) interior_ring1 LINESTRING(2. 25 zero, 1. 25 1, 1. 25 -1, 2. 25 zero) Now that you simply know the way to take geometries aside, you must understand how to place geometries jointly. We’ll circulate directly to composition features within the subsequent part. four. 6 Composition We already lined how one can create geometries from non-geometry info, both textual content or binary. during this part, we’ll assist you to prepare geometries from different geometries. four. 6. 1 Making issues issues are the main basic geometries. issues may be produced from X-Y coordinates with capabilities: ST_Point and ST_MakePoint. Coordinates aren’t geometries, yet we think they’re extra on the topic of geometries than textual content representations. as a result, we classify ST_Point and ST_MakePoint as composition features. 109 Composition ST_Point works just for second coordinates yet is located in so much spatial databases. ST_MakePoint and a version, ST_MakePointM, can settle for 2DM, 3D, and 4D coordinates as well as 2nd, yet those features are PostGIS-specific. Syntax is identical for all 3. the 1st argument is the coordinates separated by means of commas. simply because those services don’t take SRID as a controversy, you want to mix them with ST_SetSRID to indicate a spatial reference procedure. you'll wonder what those extra features supply past the typical ST_GeomFromText along with a distinct import structure. to place it concisely: pace and precision. making a handful or perhaps a few hundred issues doesn’t take a lot time, yet loading documents with thousands of aspect facts with many major digits (a universal activity whilst operating with information gathered through instrumentation) is a special topic, and you’ll definitely come to favor ST_Point or ST_MakePoint over ST_GeomFromText. to demonstrate those services, in directory four. 12 we’ll simulate interpreting info issues from monitoring units connected to grey whales as they make their annual migration from Baja California to the Bering Sea. counting on the period of reads and the variety of whales we song, the variety of information issues getting into our database could be very overwhelming, making pace a major attention for import. directory four. 12 element services pick out whale, ST_AsEWKT(spot) As spot FROM (VALUES ('Mr.

Rated 4.49 of 5 – based on 42 votes