Computers

PostGIS in Action

Author: Regina O. Obe,Leo S. Hsu

Publisher: Manning Publications

ISBN: 9781617291395

Category: Computers

Page: 600

View: 4389

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
Computers

PostGIS in Action

Author: Regina Obe,Leo Hsu

Publisher: Manning Publications

ISBN: 9781935182269

Category: Computers

Page: 492

View: 5386

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

PostgreSQL: Up and Running

Author: Regina O. Obe,Leo S. Hsu

Publisher: "O'Reilly Media, Inc."

ISBN: 1449326293

Category: Computers

Page: 168

View: 3309

Thinking of migrating to PostgreSQL? This updated guide helps you quickly understand and use the 9.3 release of this open source database system. You’ll not only learn about its unique enterprise-class features, but also discover that PostgeSQL is more than just a database system—it’s also an impressive application platform. Using numerous examples, this book shows you how to achieve tasks that are difficult or impossible in other databases. The second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. If you’re an existing PostgreSQL user, you’ll pick up gems you may have missed along the way. 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 to replicate data, using built-in replication features
Computers

Beginning Databases with PostgreSQL

From Novice to Professional

Author: Richard Stones,Neil Matthew

Publisher: Apress

ISBN: 9781430200185

Category: Computers

Page: 664

View: 5354

*The most updated PostgreSQL book on the market, covering version 8.0 *Highlights the most popular PostgreSQL APIs, including C, Perl, PHP, and Java *This is two books in one; it simultaneously covers key relational database design principles, while teaching PostgreSQL
Computers

Mastering PostGIS

Author: Dominik Mikiewicz,Michal Mackiewicz,Tomasz Nycz

Publisher: Packt Publishing Ltd

ISBN: 1784395447

Category: Computers

Page: 328

View: 9944

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

Spatial Databases

With Application to GIS

Author: Philippe Rigaux,Michel O. Scholl,Agnès Voisard

Publisher: Morgan Kaufmann

ISBN: 9781558605886

Category: Computers

Page: 410

View: 8273

Spatial Databases is the first unified, in-depth treatment of special techniques for dealing with spatial data, particularly in the field of geographic information systems (GIS). This book surveys various techniques, such as spatial data models, algorithms, and indexing methods, developed to address specific features of spatial data that are not adequately handled by mainstream DBMS technology. The book also reviews commercial solutions to geographic data handling: ArcInfo, ArcView, and Smallworld GISs; and two extensions to the relational model, PostgreSQL and Oracle Spatial. The authors examine these underlying GIS technologies, assess their strengths and weaknesses, and consider specific uses for which each product is best suited. * Examines the strengths of various query languages and approaches to query processing. * Explains the use of computational geometry in spatial databases GISs, providing necessary background and an in-depth look at key algorithms. * Covers spatial access methods, including the R-tree and several space-driven structures, and is filled with dozens of helpful illustrations.
Computers

GeoServer Beginner's Guide

Author: Brian Youngblood

Publisher: Packt Publishing Ltd

ISBN: 1849516693

Category: Computers

Page: 350

View: 2128

Step-by-step instructions are included and the needs of a beginner are totally satisfied by the book. The book consists of plenty of examples with accompanying screenshots and code for an easy learning curve. You are a web developer with knowledge of server side scripting, and have experience with installing applications on the server. You have a desire to want more than Google maps, by offering dynamically built maps on your site with your latest geospatial data stored in MySQL, PostGIS, MsSQL or Oracle. If this is the case, this book is meant for you.
Science

Geographical Data Acquisition

Author: Yong-Qi Chen,Yuk-Cheung Lee

Publisher: Springer Science & Business Media

ISBN: 3709161835

Category: Science

Page: 265

View: 1214

This book presents the theory and methodology of geographical data acquisition, providing comprehensive coverage ranging from the definition of geo-referencing systems and transformation between these systems to the acquisition of geographical data using different methods. The material provides readers with a good understanding of the nature of spatial data, the accuracy of spatial data, and the theory behind various data acquisition methodologies.
Science

Spatial Database Systems

Design, Implementation and Project Management

Author: Albert K.W. Yeung,G. Brent Hall

Publisher: Springer Science & Business Media

ISBN: 9781402053924

Category: Science

Page: 553

View: 1249

This book places spatial data within the broader domain of information technology (IT) while providing a comprehensive and coherent explanation of the guiding principles, methods, implementation and operational management of spatial databases within the workplace. The text explains the key concepts, issues and processes of spatial data implementation and provides a holistic management perspective.
Computers

PostGIS Cookbook

Store, organize, manipulate, and analyze spatial data, 2nd Edition

Author: Mayra Zurbarán,Thomas Kraft,Stephen Vincent Mather,Bborie Park,Pedro Wightman

Publisher: Packt Publishing Ltd

ISBN: 1788296443

Category: Computers

Page: 584

View: 4255

Create and manage spatial data with PostGIS Key Features Import and export geographic data from the PostGIS database using the available tools Maintain, optimize, and fine-tune spatial data for long-term viability Utilize the parallel support functionality that was introduced in PostgreSQL 9.6 Book Description PostGIS is a spatial database that integrates the advanced storage and analysis of vector and raster data, and is remarkably flexible and powerful. PostGIS provides support for geographic objects to the PostgreSQL object-relational database and is currently the most popular open source spatial databases. If you want to explore the complete range of PostGIS techniques and expose related extensions, then this book is for you. This book is a comprehensive guide to PostGIS tools and concepts which are required to manage, manipulate, and analyze spatial data in PostGIS. It covers key spatial data manipulation tasks, explaining not only how each task is performed, but also why. It provides practical guidance allowing you to safely take advantage of the advanced technology in PostGIS in order to simplify your spatial database administration tasks. Furthermore, you will learn to take advantage of basic and advanced vector, raster, and routing approaches along with the concepts of data maintenance, optimization, and performance, and will help you to integrate these into a large ecosystem of desktop and web tools. By the end, you will be armed with all the tools and instructions you need to both manage the spatial database system and make better decisions as your project's requirements evolve. What you will learn Import and export geographic data from the PostGIS database using the available tools Structure spatial data using the functionality provided by a combination of PostgreSQL and PostGIS Work with a set of PostGIS functions to perform basic and advanced vector analyses Connect PostGIS with Python Learn to use programming frameworks around PostGIS Maintain, optimize, and fine-tune spatial data for long-term viability Explore the 3D capabilities of PostGIS, including LiDAR point clouds and point clouds derived from Structure from Motion (SfM) techniques Distribute 3D models through the Web using the X3D standard Use PostGIS to develop powerful GIS web applications using Open Geospatial Consortium web standards Master PostGIS Raster Who this book is for This book is for developers who need some quick solutions for PostGIS. Prior knowledge of PostgreSQL and spatial concepts would be an added advantage.
Technology & Engineering

GIS Fundamentals, Second Edition

Author: Stephen Wise

Publisher: CRC Press

ISBN: 1439886954

Category: Technology & Engineering

Page: 338

View: 2712

With GIS technology increasingly available to a wider audience on devices from apps on smartphones to satnavs in cars, many people routinely use spatial data in a way which used to be the preserve of GIS specialists. However spatial data is stored and analyzed on a computer still tends to be described in academic texts and articles which require specialist knowledge or some training in computer science. Developed to introduce computer science literature to geography students, GIS Fundamentals, Second Edition provides an accessible examination of the underlying principles for anyone with no formal training in computer science. See What’s New in the Second Edition: Coverage of the use of spatial data on the Internet Chapters on databases and on searching large databases for spatial queries Improved coverage on route-finding Improved coverage of heuristic approaches to solving real-world spatial problems International standards for spatial data The book begins with a brief but detailed introduction to how computers work and how they are programmed, giving anyone with no previous computer science background a foundation to understand the remainder of the book. As with all parts of the book there are also suggestions for further sources of reading. The book then describes the ways in which vector and raster data can be stored and how algorithms are designed to perform fundamental operations such as detecting where lines intersect. From these simple beginnings the book moves into the more complex structures used for handling surfaces and networks and contains a detailed account of what it takes to determine the shortest route between two places on a network. The final sections of the book review problems, such as the "Travelling Salesman" problem, which are so complex that it is not known whether an optimum solution exists. Using clear, concise language, but without sacrificing technical rigour, the book gives readers an understanding of what it takes to produce systems which allow them to find out where to make their next purchase and how to drive to the right place to collect it.
Computers

Web Mapping Illustrated

Using Open Source GIS Toolkits

Author: Tyler Mitchell

Publisher: "O'Reilly Media, Inc."

ISBN: 0596008651

Category: Computers

Page: 349

View: 723

Provides information on how to create custom maps from tools available over the Internet.
Computers

Pro Spatial with SQL Server 2012

Author: Alastair Aitchison

Publisher: Apress

ISBN: 143023492X

Category: Computers

Page: 560

View: 7791

Microsoft SQL Server implements extensive support for location-based data. Pro Spatial with SQL Server 2012 introduces SQL Server’s spatial feature set, and covers everything you'll need to know to store, manipulate, and analyze information about the physical location of objects in space. You’ll learn about the geography and geometry datatypes, and how to apply them in practical situations involving the spatial relationships of people, places, and things on Earth. Author Alastair Aitchison first introduces you to SQL Server’s spatial feature set and the fundamental concepts involved in working with spatial data, including spatial references and co-ordinate systems. You’ll learn to query, analyze, and interpret spatial data using tools such as Bing Maps and SQL Server Reporting Services. Throughout, you'll find helpful code examples that you can adopt and extend as a basis for your own projects. Explains spatial concepts from the ground up—no prior knowledge is necessary Provides comprehensive guidance for every stage of working with spatial data, from importing through cleansing and storing, to querying, and finally for retrieval and display of spatial data in an application layer Brilliantly illustrated with code examples that run in SQL Server 2012, that you can adapt and use as the basis for your own projects.
Computers

Spatial Databases

A Tour

Author: Shashi Shekhar,Sanjay Chawla

Publisher: Pearson

ISBN: 9780130174802

Category: Computers

Page: 262

View: 2954

This book by leading experts in the field provides readers with a wide range of applications and methods for spatial database management systems, and allows readers to gain hands-on experience with examples in the book. It balances theory (cutting-edge research) and practice (commercial trends) to provide a comprehensive and clear overview.Includes coverage of GIS application trends as spatial networks; discussion of spatial data mining; overview of OGIS standard spatial datatypes and operations; object-relational database framework applied in each chapter.For professionals in the field of Databases, Geographic Information Systems, Geography, Remote Sensing, Multimedia Information, Civil and Mechanical Engineering, Forestry, CAD/CAM, Health Informatics, and Natural Resource Management.
Computers

Postgis Cookbook, Second Edition

Author: Pedro Wightman,Mayra Zurbaran,Stephen Vincent Mather

Publisher: Packt Publishing

ISBN: 9781788299329

Category: Computers

Page: 584

View: 2830

PostGIS is a spatial database that integrates advanced storage and analysis of vector and raster data, and is remarkably flexible and powerful. PostGIS provides support for geographic objects to the PostgreSQL object-relational database and is currently the most popular open source spatial databases. This book is a comprehensive guide on PostGIS tools and concepts which are required to manage, manipulate, and analyse spatial data in PostGIS. It will cover key spatial data manipulation tasks, explaining not only how each task is performed, but also why. It provides practical guidance allowing you to safely take advantage of the advanced technology in PostGIS in order to simplify your spatial database administration tasks. Furthermore, you will learn to take advantage of basic and advanced vector, raster, and routing approaches along with the concepts of data maintenance, optimization, and performance, which will help you to integrate these into a large ecosystem of desktop and web tools. By the end, you will be armed with all the tools and instructions you need to both manage the spatial database system and make better decisions as your project's requirements evolve.
Computers

Big Data For Dummies

Author: Judith Hurwitz,Alan Nugent,Fern Halper,Marcia Kaufman

Publisher: John Wiley & Sons

ISBN: 1118644174

Category: Computers

Page: 336

View: 6645

Find the right big data solution for your business or organization Big data management is one of the major challenges facing business, industry, and not-for-profit organizations. Data sets such as customer transactions for a mega-retailer, weather patterns monitored by meteorologists, or social network activity can quickly outpace the capacity of traditional data management tools. If you need to develop or manage big data solutions, you'll appreciate how these four experts define, explain, and guide you through this new and often confusing concept. You'll learn what it is, why it matters, and how to choose and implement solutions that work. Effectively managing big data is an issue of growing importance to businesses, not-for-profit organizations, government, and IT professionals Authors are experts in information management, big data, and a variety of solutions Explains big data in detail and discusses how to select and implement a solution, security concerns to consider, data storage and presentation issues, analytics, and much more Provides essential information in a no-nonsense, easy-to-understand style that is empowering Big Data For Dummies cuts through the confusion and helps you take charge of big data solutions for your organization.
Computers

Geospatial Power Tools

Author: Tyler Mitchell,Gdal Developers

Publisher: N.A

ISBN: 9780989421713

Category: Computers

Page: 358

View: 9125

Tool Up! Become a data management superstar with tools from the Geospatial Data Abstraction Library (GDAL). This book is a reference guide for quickly finding the right syntax and example usage of all GDAL/OGR commands. Used behind most of the open source geospatial applications, as well as leading proprietary GIS applications, GDAL is the preeminent spatial data access library. GDAL comes with several powerful command line utilities including tools for examining, converting, transforming, building and analyzing raster and vector data. Included within is substantial new content, supplementing the GDAL documentation which makes up the rest of the book. Look up a workflow concept like "Translate Vectors" and quickly find examples designed to get you going right away. Digital versions of the book are fully linked with bookmarks between topics and command names, making it easier than ever to follow from an example to more detailed documentation. Tooling up your skills with this book will allow you to confidently tackle future raster and vector data management challenges!
Technology & Engineering

Geographic Information Systems and Science

Author: Paul A. Longley,Mike Goodchild,David J. Maguire,David W. Rhind

Publisher: John Wiley & Sons

ISBN: 0470721448

Category: Technology & Engineering

Page: 560

View: 7475

The Third Edition of this bestselling textbook has been fully revised and updated to include the latest developments in the field and still retains its accessible format to appeal to a broad range of students. Now divided into five clear sections the book investigates the unique, complex and difficult problems that are posed by geographic information and together they build into a holistic understanding of the key principles of GIS. This is the most current, authoritative and comprehensive treatment of the field, that goes from fundamental principles to the big picture of: GIS and the New World Order security, health and well-being digital differentiation in GIS consumption the core organizing role of GIS in Geography the greening of GIS grand challenges of GIScience science and explanation Key features: Four-colour throughout Associated website with free online resources Teacher’s manual available for lecturers A complete learning resource, with accompanying instructor links, free online lab resources and personal syllabi Includes learning objectives and review boxes throughout each chapter New in this edition: Completely revised with a new five part structure: Foundations; Principles; Techniques; Analysis; Management and Policy All new personality boxes of current GIS practitioners New chapters on Distributed GIS, Map Production, Geovisualization, Modeling, and Managing GIS
Science

Open Source GIS

A GRASS GIS Approach

Author: Markus Neteler,Helena Mitasova

Publisher: Springer Science & Business Media

ISBN: 038768574X

Category: Science

Page: 406

View: 2551

Thoroughly updated with material related to the GRASS6, the third edition includes new sections on attribute database management and SQL support, vector networks analysis, lidar data processing and new graphical user interfaces. All chapters were updated with numerous practical examples using the first release of a comprehensive, state-of-the-art geospatial data set.
Computers

Python Geospatial Development

Author: Erik Westra

Publisher: Packt Publishing Ltd

ISBN: 1782174982

Category: Computers

Page: 446

View: 3178

Develop sophisticated mapping applications from scratch using Python 3 tools for geospatial development About This Book Build web applications based around maps and geospatial data using Python 3.x Install and use various toolkits and obtain geospatial data for use in your programs This practical, hands-on book will teach you all about geospatial development in Python Who This Book Is For This book is for experienced Python developers who want to learn about geospatial concepts, obtain and work with geospatial data, solve spatial problems, and build sophisticated map-based applications using Python. What You Will Learn Access, manipulate, and display geospatial data from within your Python programs Master the core geospatial concepts of location, distance, units, projections, and datums Read and write geospatial data in both vector and raster format Perform complex, real-world geospatial calculations using Python Store and access geospatial information in a database Use points, lines, and polygons within your Python programs Convert geospatial data into attractive maps using Python-based tools Build complete web-based mapping applications using Python In Detail Geospatial development links your data to locations on the surface of the Earth. Writing geospatial programs involves tasks such as grouping data by location, storing and analyzing large amounts of spatial information, performing complex geospatial calculations, and drawing colorful interactive maps. In order to do this well, you'll need appropriate tools and techniques, as well as a thorough understanding of geospatial concepts such as map projections, datums, and coordinate systems. This book provides an overview of the major geospatial concepts, data sources, and toolkits. It starts by showing you how to store and access spatial data using Python, how to perform a range of spatial calculations, and how to store spatial data in a database. Further on, the book teaches you how to build your own slippy map interface within a web application, and finishes with the detailed construction of a geospatial data editor using the GeoDjango framework. By the end of this book, you will be able to confidently use Python to write your own geospatial applications ranging from quick, one-off utilities to sophisticated web-based applications using maps and other geospatial data. Style and approach This book is a comprehensive course in geospatial development. The concepts you need to know are presented in a hands-on fashion with example code to help you to solve real-world problems right away. Larger programs are built up step by step while guiding you through the process of building your own sophisticated mapping applications.