PostGIS in Action (2nd Edition) by Regina O. Obe, Leo S. Hsu

By Regina O. Obe, Leo S. Hsu

PostGIS in motion, moment variation teaches readers of all degrees to put in writing spatial queries that remedy real-world difficulties. It first offers a historical past in vector-, raster-, and topology-based GIS after which fast strikes into interpreting, viewing, and mapping information. This moment variation covers PostGIS 2.0 and 2.1 sequence, PostgreSQL 9.1, 9.2, and 9.3 good points, and indicates you ways to combine with different GIS instruments.

Show description

Read or Download PostGIS in Action (2nd Edition) PDF

Similar programming books

Scratch 2.0 Beginner's Guide (2nd Edition)

As twenty first century humans, we are living a electronic existence, yet desktop scientists all over the world warn of a declining pool of digitally literate desktop technological know-how scholars. The Scratch surroundings makes it enjoyable for college kids of any age to imagine, create, and collaborate digitally.

Scratch 2. zero Beginner's advisor moment variation will educate you the way to develop into a Scratch programmer and lay the root for programming in any computing device language. even if you're making a birthday card or cloning bricks for a online game of Breakout, initiatives are approached in a step by step approach to assist you layout, create, and examine each one programming workout.

Automata, Languages and Programming: 25th International Colloquium, ICALP'98 Aalborg, Denmark, July 13–17, 1998 Proceedings

This booklet constitutes the refereed court cases of the twenty fifth overseas Colloquium on Automata, Languages and Programming, ICALP'98, held in Aalborg, Denmark, in July 1998. The 70 revised complete papers provided including 8 invited contributions have been conscientiously chosen from a complete of 182 submissions.

FAQ по Microsoft Windows Vista

Этот сборник часто задаваемых вопросов по home windows Vista был собран по материалам форума OSzone. internet. Он будет полезен как для решения конкретных задачу, так и в ознакомительных целях. Возможно при прочтении данного FAQ вы узнаете что-то новое и полезное, то чем вы сможете воспользоваться в будущем. Здесь я старался собрать вопросы, которые еще не рассматривались ране, вопросы, которые относятся в первую очередь к home windows Vista, хотя фактически львиная доля вопросов, описанных в FAQ по home windows XP применима и к этой системе.

LEGO MINDSTORMS NXT-G Programming Guide, Second Edition (Practical Projects)

James Kelly’s LEGO MINDSTORMS NXT-G Programming consultant, moment version is a fountain of knowledge and ideas for these seeking to grasp the artwork of programming LEGO’s MINDSTORMS NXT robotics kits. This moment variation is fully-updated to hide all of the newest beneficial properties and components within the NXT 2. zero sequence. it is also routines on the finish of every bankruptcy and different content material feedback from educators and different readers of the 1st variation.

Extra resources for PostGIS in Action (2nd Edition)

Example text

Com> 6 CHAPTER 1 What is a spatial database? 1 shows what the results of such a spatial query might look like. 1 km Suppose you aren’t a mapping user, but are more of a data user. You work with data day in and day out, never needing to plot anything on a map. ” This is the extent of the kind of spatial queries that you can formulate with conventional databases, where data types consist mainly of text, numbers, and dates. ” Without spatial support, these questions would require you to collect or derive additional values for each data point.

Admittedly, Microsoft SQL Server 2012 has probably got the best curve and geodetic support of any database—it’s the only one to support curved geometries in geodetic space. But don’t expect to find numerous output/input functions, such as input/output for KML and JSON, or raster support, or the numerous processing functions that PostGIS has. SPATIALITE Our favorite kid on the block is SpatiaLite, which is an add-on to the open source SQLite portable database. SpatiaLite is especially interesting because it can be used as a low-end companion to PostGIS and other high-end, spatially enabled databases.

PostGIS has always supported the geometry type from its inception. 5. 0 raised the bar more by incorporating raster and network topology support. 1 introduces many more functions, perhaps the most important feature it provides is faster speed, particularly for raster and geography operations:  Geometry—The planar type. This was the very first model and it’s still the most popular type that PostGIS supports. It’s the foundation of the other types. It uses the Cartesian math you learned about in high school geometry.

Download PDF sample

Rated 4.86 of 5 – based on 29 votes