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 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 PART 2 PUTTING POSTGIS TO WORK Proximity analysis Geometry and geography processing Raster processing Building and using topologies Organizing spatial data Query performance tuning PART 3 USING POSTGIS WITH OTHER TOOLS Extending PostGIS with pgRouting and procedural languages Using PostGIS in web applications
"PostGIS in Action" is the first book devoted entirely to PostGIS. It will help both new and experienced users write spatial queries to solve real-world problems. It also discusses the new features available in PostgreSQL 8.4 and provides tutorials.
A Practical Introduction to the Advanced Open Source Database
Author: Regina O. Obe
Publisher: "O'Reilly Media, Inc."
Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.2, 9.3, and 9.4, you’ll also discover that PostgeSQL is more than a database system—it’s also an impressive application platform. With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. If you’re a current PostgreSQL user, you’ll pick up gems you may have missed before. Learn basic administration tasks such as role management, database creation, backup, and restore Apply the psql command-line utility and the pgAdmin graphical administration tool Explore PostgreSQL tables, constraints, and indexes Learn powerful SQL constructs not generally found in other databases Use several different languages to write database functions Tune your queries to run as fast as your hardware will allow Query external and variegated data sources with foreign data wrappers Learn how use built-in replication filters to replicate data
The 2008 Physics Education Research Conference brought together researchers studying a wide variety of topics in physics education. The conference theme was “Physics Education Research with Diverse Student Populations”. Researchers specializing in diversity issues were invited to help establish a dialog and spur discussion about how the results from this work can inform the physics education research community. The organizers encouraged physics education researchers who are using research-based instructional materials with non-traditional students at either the pre-college level or the college level to share their experiences as instructors and researchers in these classes.
An interpretation of the social and political ideas of Confucius, his forerunners, and his early disciples.
Author: Leonard Shihlien Hsü
First published in 1932. One of the most astonishing features of the Confucian teaching to the modern reader is its anticipation of the Spencerian formula of evolution and its adaptation of this to a programme of progress. This volume shows that Confucius' teaching is still relevant in many of its features, not merely for China but also for the West. Contents include: The background of Confucian political philosophy; the state and its origin; political unity and organization; the principle of benevolent government; law and justice; democracy and representation, social evolution.
All papers were peer reviewed. The 2006 Physics Education Research Conference brought together researchers studying a wide variety of topics in physics education including transfer of knowledge, learning in upper level physics courses, pre-service education, and cross-disciplinary learning. The theme of this conference was Discipline-Based Education Research in Other STEM Disciplines.
Learning Heroku Postgres is targeted at developers and database admins. Even if you're new to Heroku Postgres, you'll be able to master both the basic as well as advanced features of Heroku Postgres. Since Heroku Postgres is incredibly user-friendly, no previous experience in computer coding or programming is required.
This book is for moderate to advanced PostgreSQL database professionals who wish to extend PostgreSQL, utilizing the most updated features of PostgreSQL 9.4. For a better understanding of this book, familiarity with writing SQL, a basic idea of query tuning, and some coding experience in your preferred language is expected.