PostGIS in Action

Author: Regina O. Obe

Publisher: Manning Publications

ISBN:

Category: Computers

Page: 600

View: 742

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

Author: Regina Obe

Publisher: Manning Publications

ISBN:

Category: Computers

Page: 492

View: 574

"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.

PostgreSQL: Up and Running

A Practical Introduction to the Advanced Open Source Database

Author: Regina O. Obe

Publisher: "O'Reilly Media, Inc."

ISBN:

Category: COMPUTERS

Page: 234

View: 520

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

PostgreSQL

Up and Running

Author: Regina Obe

Publisher: "O'Reilly Media, Inc."

ISBN:

Category: Computers

Page: 145

View: 694

"A practical guide to the Advanced Open Source Database"--Cover.

Mastering PostGIS

Author: Dominik Mikiewicz

Publisher: Packt Publishing Ltd

ISBN:

Category: Computers

Page: 328

View: 787

Write efficient GIS applications using PostGIS - from data creation to data consumption About This Book Learn how you can use PostGIS for spatial data analysis and manipulation Optimize your queries and build custom functionalities for your GIS application A comprehensive guide with hands-on examples to help you master PostGIS with ease Who This Book Is For If you are a GIS developer or analyst who wants to master PostGIS to build efficient, scalable GIS applications, this book is for you. If you want to conduct advanced analysis of spatial data, this book will also help you. The book assumes that you have a working installation of PostGIS in place, and have working experience with PostgreSQL. What You Will Learn Refresh your knowledge of the PostGIS concepts and spatial databases Solve spatial problems with the use of SQL in real-world scenarios Practical walkthroughs of application development examples using Postgis, GeoServer and OpenLayers. Extract, transform and load your spatial data Expose data directly or through web services. Consume your data in both desktop and web clients In Detail PostGIS is open source extension onf PostgreSQL object-relational database system that allows GIS objects to be stored and allows querying for information and location services. The aim of this book is to help you master the functionalities offered by PostGIS- from data creation, analysis and output, to ETL and live edits. The book begins with an overview of the key concepts related to spatial database systems and how it applies to Spatial RMDS. You will learn to load different formats into your Postgres instance, investigate the spatial nature of your raster data, and finally export it using built-in functionalities or 3th party tools for backup or representational purposes. Through the course of this book, you will be presented with many examples on how to interact with the database using JavaScript and Node.js. Sample web-based applications interacting with backend PostGIS will also be presented throughout the book, so you can get comfortable with the modern ways of consuming and modifying your spatial data. Style and approach This book is a comprehensive guide covering all the concepts you need to master PostGIS. Packed with hands-on examples, tips and tricks, even the most advanced concepts are explained in a very easy-to-follow manner. Every chapter in the book does not only focus on how each task is performed, but also why.

2008 Physics Education Research Conference

Author: Charles Henderson

Publisher: American Inst. of Physics

ISBN:

Category: Science

Page: 266

View: 124

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.

The Political Philosophy of Confucianism

An interpretation of the social and political ideas of Confucius, his forerunners, and his early disciples.

Author: Leonard Shihlien Hsü

Publisher: Routledge

ISBN:

Category: History

Page: 288

View: 837

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.

2006 Physics Education Research Conference

Syracuse, New York, 26-27 July 2006

Author: Laura McCullough

Publisher: Amer Inst of Physics

ISBN:

Category: Education

Page: 198

View: 471

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

Author: Patrick Espake

Publisher: Packt Publishing Ltd

ISBN:

Category: Computers

Page: 164

View: 998

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.

PostgreSQL Server Programming - Second Edition

Author: Usama Dar

Publisher: Packt Publishing Ltd

ISBN:

Category: Computers

Page: 320

View: 834

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.