PostGIS in Action

PostGIS in Action PDF Author: Regina Obe
Publisher: Manning
ISBN: 9781935182269
Category : Computers
Languages : en
Pages : 0

Get Book Here

Book Description
Whether you're canvassing a congressional district, managing a sales region, mapping city bus schedules, or analyzing local cancer rates, thinking spatially opens up limitless possibilities for database users. PostGIS, a freely available open-source spatial database extender, can help you answer questions that you could not answer using a mere relational database. Its feature set equals or surpasses proprietary alternatives, allowing you to create location-aware queries and features with just a few lines of SQL code. 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. For those with experience in more traditional relational databases, this book provides a background in vector-based GIS so you can quickly move to analyzing, viewing, and mapping data. Advanced users will learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions suited specifically to their applications. It also discusses the new features available in PostgreSQL 8.4 and provides tutorials on using additional open source GIS tools in conjunction with PostGIS. Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.

PostGIS in Action

PostGIS in Action PDF Author: Regina Obe
Publisher: Manning
ISBN: 9781935182269
Category : Computers
Languages : en
Pages : 0

Get Book Here

Book Description
Whether you're canvassing a congressional district, managing a sales region, mapping city bus schedules, or analyzing local cancer rates, thinking spatially opens up limitless possibilities for database users. PostGIS, a freely available open-source spatial database extender, can help you answer questions that you could not answer using a mere relational database. Its feature set equals or surpasses proprietary alternatives, allowing you to create location-aware queries and features with just a few lines of SQL code. 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. For those with experience in more traditional relational databases, this book provides a background in vector-based GIS so you can quickly move to analyzing, viewing, and mapping data. Advanced users will learn how to optimize queries for maximum speed, simplify geometries for greater efficiency, and create custom functions suited specifically to their applications. It also discusses the new features available in PostgreSQL 8.4 and provides tutorials on using additional open source GIS tools in conjunction with PostGIS. Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.

Analyzing Our World Using GIS

Analyzing Our World Using GIS PDF Author: Roger Palmer
Publisher: ESRI, Inc.
ISBN: 1589481828
Category : Education
Languages : en
Pages : 158

Get Book Here

Book Description
The third volume in the Our World GIS Education series promotes inquiry-based learning in world geography and other disciplines through the use of geographic information systems (GIS). The book and accompanying materials help both GIS novices and experienced users.

Community Geography

Community Geography PDF Author: Lyn Malone
Publisher: ESRI, Inc.
ISBN: 9781589480513
Category : Science
Languages : en
Pages : 160

Get Book Here

Book Description
A guide that provides teachers with the resources they need to teach GIS exercises to middle and high school students and manage self-guided projects. It is suitable for those who want to integrate learning, GIS technology, and real-world experiences.

PostGIS in Action, Third Edition

PostGIS in Action, Third Edition PDF Author: Leo S. Hsu
Publisher: Simon and Schuster
ISBN: 1617296694
Category : Computers
Languages : en
Pages : 662

Get Book Here

Book Description
PostGIS in Action, Third 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. Fully updated to the latest versions of PostGIS and PostgreSQL, this Third Edition covers new PostGIS features including Foreign Data Wrappers, Database as a Service, parallelization of queries, and new JSON and Vector Tiles functions that help in creating web mapping applications. Key Features · 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 3 and PostgreSQL 12 For readers familiar with relational databases and basic SQL. About the technology Processing location and topology data requires specialized know-how. PostGIS is a free spatial database extender for PostgreSQL that delivers the features and firepower you need to take on nearly any geodata task. 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. 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.

Mapping Our World Using GIS

Mapping Our World Using GIS PDF Author: Anita M. Palmer
Publisher: ESRI, Inc.
ISBN: 158948181X
Category : Education
Languages : en
Pages : 230

Get Book Here

Book Description
A follow-up to "Mapping Our World: GIS Lessons for Educators," this second volume contains updated materials and lessons that combine geography, data collection, mapping, and critical analysis to guide educators and students through course content in new ways.

Comprehensive Ecosystem-based Amendment 1 for the South Atlantic Region

Comprehensive Ecosystem-based Amendment 1 for the South Atlantic Region PDF Author:
Publisher:
ISBN:
Category :
Languages : en
Pages : 468

Get Book Here

Book Description


ARC User

ARC User PDF Author:
Publisher:
ISBN:
Category : Geographic information systems
Languages : en
Pages : 294

Get Book Here

Book Description


GIS in Action

GIS in Action PDF Author: Michael N. DeMers
Publisher: Wiley
ISBN: 9781118038499
Category : Science
Languages : en
Pages : 528

Get Book Here

Book Description


PostGIS in Action

PostGIS in Action PDF Author: Regina O. Obe
Publisher: Manning Publications
ISBN: 9781617291395
Category : Computers
Languages : en
Pages : 600

Get Book Here

Book Description
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

Geographic Information Systems (GIS) for Disaster Management

Geographic Information Systems (GIS) for Disaster Management PDF Author: Brian Tomaszewski
Publisher: CRC Press
ISBN: 1482211688
Category : Social Science
Languages : en
Pages : 316

Get Book Here

Book Description
Geographic Information Systems (GIS) provide essential disaster management decision support and analytical capabilities. As such, homeland security professionals would greatly benefit from an interdisciplinary understanding of GIS and how GIS relates to disaster management, policy, and practice. Assuming no prior knowledge in GIS and/or disaster management, Geographic Information Systems (GIS) for Disaster Management guides readers through the basics of GIS as it applies to disaster management practice. Using a hands-on approach grounded in relevant GIS and disaster management theory and practice, this textbook provides coverage of the basics of GIS. It examines what GIS can and can’t do, GIS data formats (vector, raster, imagery), and basic GIS functions, including analysis, map production/cartography, and data modeling. It presents a series of real-life case studies that illustrate the GIS concepts discussed in each chapter. These case studies supply readers with an understanding of the applicability of GIS to the full disaster management cycle. Providing equal treatment to each disaster management cycle phase, the book supplies disaster management practitioners and students with coverage of the latest developments in GIS for disaster management and emerging trends. It takes a learning-by-examples approach to help readers apply what they have learned from the examples and disaster management scenarios to their specific situations. The book illustrates how GIS technology can help disaster management professionals, public policy makers, and decision-makers at the town, county, state, federal, and international levels. Offering software-neutral best practices, this book is suitable for use in undergraduate- or graduate-level disaster management courses. Offering extensive career advice on GIS for disaster management from working professionals, the book also includes a GIS for disaster management research agenda and ideas for staying current in the field.