› › Postgis In Action Third Edition

PostGIS in Action, Third Edition

Author : Leo S. Hsu

Publisher : Simon and Schuster

Page : 662 pages

File Size : 14,31 MB

Release : 2021-09-21

Category : Computers

ISBN : 1617296694

Get eBook

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.



PostGIS in Action, Third Edition

Author : Regina Obe

Publisher : Simon and Schuster

Page : 662 pages

File Size : 16,37 MB

Release : 2021-10-12

Category : Computers

ISBN : 1638351155

Get eBook

Book Description

PostGIS in Action, Third Edition shows you how to solve real-world geodata problems. You’ll go beyond basic mapping, and explore custom functions for your applications. Summary In PostGIS in Action, Third Edition you will learn: 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 Querying data from external sources using PostgreSQL Foreign Data Wrappers Optimizing queries for maximum speed Simplifying geometries for greater efficiency PostGIS in Action, Third Edition teaches readers of all levels to write spatial queries for PostgreSQL. You’ll start by exploring vector-, raster-, and topology-based GIS before quickly progressing to analyzing, viewing, and mapping data. This fully updated third edition covers key changes in PostGIS 3.1 and PostgreSQL 13, including parallelization support, partitioned tables, and new JSON functions that help in creating web mapping applications. Purchase of the print book includes a free eBook in PDF, Kindle, and ePub formats from Manning Publications. About the technology PostGIS is a spatial database extender for PostgreSQL. It offers the features and firepower you need to take on nearly any geodata task. PostGIS lets you create location-aware queries with a few lines of SQL code, then build the backend for mapping, raster analysis, or routing application with minimal effort. About the book PostGIS in Action, Third Edition shows you how to solve real-world geodata problems. You’ll go beyond basic mapping, and explore custom functions for your applications. Inside this fully updated edition, you’ll find coverage of new PostGIS features such as PostGIS Window functions, parallelization of queries, and outputting data for applications using JSON and Vector Tile functions. What's inside Fully revised for PostGIS version 3.1 and PostgreSQL 13 Optimize queries for maximum speed Simplify geometries for greater efficiency Extend PostGIS to web and desktop applications About the reader For readers familiar with relational databases and basic SQL. No prior geodata or GIS experience required. About the author 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 1 What is a spatial database? 2 Spatial data types 3 Spatial reference systems 4 Working with real data 5 Using PostGIS on the desktop 6 Geometry and geography functions 7 Raster functions 8 Spatial relationships PART 2 PUTTING POSTGIS TO WORK 9 Proximity analysis 10 PostGIS TIGER geocoder 11 Geometry and geography processing 12 Raster processing 13 Building and using topologies 14 Organizing spatial data 15 Query performance tuning PART 3 USING POSTGIS WITH OTHER TOOLS 16 Extending PostGIS with pgRouting and procedural languages 17 Using PostGIS in web applications



PostGIS in Action

Author : Regina O. Obe

Publisher : Manning Publications

Page : 600 pages

File Size : 46,66 MB

Release : 2015-01-28

Category : Computers

ISBN : 9781617291395

Get eBook

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



PostGIS in Action

Author : Regina Obe

Publisher : Manning

Page : 0 pages

File Size : 32,89 MB

Release : 2011-05-01

Category : Computers

ISBN : 9781935182269

Get eBook

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.



Mastering PostGIS

Author : Dominik Mikiewicz

Publisher : Packt Publishing Ltd

Page : 321 pages

File Size : 28,72 MB

Release : 2017-05-31

Category : Computers

ISBN : 1784395447

Get eBook

Book Description

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.



PostgreSQL: Up and Running

Author : Regina O. Obe

Publisher : "O'Reilly Media, Inc."

Page : 167 pages

File Size : 35,53 MB

Release : 2012-07-06

Category : Computers

ISBN : 1449326293

Get eBook

Book Description

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



Geocomputation with R

Author : Robin Lovelace

Publisher : CRC Press

Page : 335 pages

File Size : 44,74 MB

Release : 2019-03-22

Category : Mathematics

ISBN : 1351396900

Get eBook

Book Description

Geocomputation with R is for people who want to analyze, visualize and model geographic data with open source software. It is based on R, a statistical programming language that has powerful data processing, visualization, and geospatial capabilities. The book equips you with the knowledge and skills to tackle a wide range of issues manifested in geographic data, including those with scientific, societal, and environmental implications. This book will interest people from many backgrounds, especially Geographic Information Systems (GIS) users interested in applying their domain-specific knowledge in a powerful open source language for data science, and R users interested in extending their skills to handle spatial data. The book is divided into three parts: (I) Foundations, aimed at getting you up-to-speed with geographic data in R, (II) extensions, which covers advanced techniques, and (III) applications to real-world problems. The chapters cover progressively more advanced topics, with early chapters providing strong foundations on which the later chapters build. Part I describes the nature of spatial datasets in R and methods for manipulating them. It also covers geographic data import/export and transforming coordinate reference systems. Part II represents methods that build on these foundations. It covers advanced map making (including web mapping), "bridges" to GIS, sharing reproducible code, and how to do cross-validation in the presence of spatial autocorrelation. Part III applies the knowledge gained to tackle real-world problems, including representing and modeling transport systems, finding optimal locations for stores or services, and ecological modeling. Exercises at the end of each chapter give you the skills needed to tackle a range of geospatial problems. Solutions for each chapter and supplementary materials providing extended examples are available at https://geocompr.github.io/geocompkg/articles/. Dr. Robin Lovelace is a University Academic Fellow at the University of Leeds, where he has taught R for geographic research over many years, with a focus on transport systems. Dr. Jakub Nowosad is an Assistant Professor in the Department of Geoinformation at the Adam Mickiewicz University in Poznan, where his focus is on the analysis of large datasets to understand environmental processes. Dr. Jannes Muenchow is a Postdoctoral Researcher in the GIScience Department at the University of Jena, where he develops and teaches a range of geographic methods, with a focus on ecological modeling, statistical geocomputing, and predictive mapping. All three are active developers and work on a number of R packages, including stplanr, sabre, and RQGIS.



Open Source GIS: A GRASS GIS Approach

Author : Markus Neteler

Publisher : Springer Science & Business Media

Page : 415 pages

File Size : 16,7 MB

Release : 2008-01-17

Category : Science

ISBN : 1402080654

Get eBook

Book Description

Since the first edition of Open Source GIS: A GRASS GIS Approach was published in 2002, GRASS has undergone major improvements. This second edition includes numerous updates related to the new development; its text is based on the GRASS 5.3 version from December 2003. Besides changes related to GRASS 5.3 enhancements, the introductory chapters have been re-organized, providing more extensive information on import of external data. Most of the improvements in technical accuracy and clarity were based on valuable feedback from readers. Open Source GIS: A GRASS GIS Approach, Second Edition, provides updated information about the use of GRASS, including geospatial modeling with raster, vector, and site data, image processing, visualization, and coupling with other open source tools for geostatistical analysis and web applications. A brief introduction to programming within GRASS encourages new development. The sample data set used throughout the book has been updated and is available on the GRASS web site. This book also includes links to sites where the GRASS software and on-line reference manuals can be downloaded and additional applications can be viewed.



Mongodb in Action

Author : Kyle Banker

Publisher : Manning Publications

Page : 375 pages

File Size : 30,79 MB

Release : 2015-01-15

Category : Computers

ISBN : 9781617291609

Get eBook

Book Description

Application developers love MongoDB, a document-oriented NoSQL database, for its speed, flexibility, scalability, and ease of use. MongoDB is well-suited as a back-end for modern web applications. Its schema-free design encourages rapid application development, and built-in replication and auto-sharding architecture allow for massive parallel distribution. Production deployments at SourceForge, Foursquare, and Shutterfly demonstrate daily that MongoDB is up to real-world challenges. MongoDB in Action, Second Edition is a comprehensive guide to MongoDB version 2.6. It begins with a general overview of current database systems, explaining what makes MongoDB unique and describing its ideal use cases. Then, a series of tutorials lead into detailed examples for leveraging MongoDB in e-commerce, social networking, and other common applications. A reference section on schema design patterns helps ease the transition from the relational data model of SQL to MongoDB's document-based data model. 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.



PgRouting

Author : Regina Obe

Publisher : Locate Press

Page : pages

File Size : 15,21 MB

Release : 2015-10-31

Category :

ISBN : 9780989421737

Get eBook

Book Description

What is pgRouting? It's a PostgreSQL extension for developing network routing applications and doing graph analysis. This book will give you all the tools and information you need to get started with pgRouting, as well as complete code examples and even how to deploy your project to the web.