Postgis In Action Third Edition

Author : Regina Obe
Publisher : Simon and Schuster
ISBN 13 : 1638351155
Total Pages : 662 pages
Book Rating : 4.53/5 ( download)

DOWNLOAD NOW!

Download or read book PostGIS in Action, Third Edition written by Regina Obe and published by Simon and Schuster. This book was released on 2021-10-12 with total page 662 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Author : Regina Obe
Publisher : Manning
ISBN 13 : 9781935182269
Total Pages : 0 pages
Book Rating : 4.69/5 ( download)

DOWNLOAD NOW!

Download or read book PostGIS in Action written by Regina Obe and published by Manning. This book was released on 2011-05-01 with total page 0 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.

Author : Regina O. Obe
Publisher : Manning Publications
ISBN 13 : 9781617291395
Total Pages : 600 pages
Book Rating : 4.90/5 ( download)

DOWNLOAD NOW!

Download or read book PostGIS in Action written by Regina O. Obe and published by Manning Publications. This book was released on 2015-01-28 with total page 600 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Author : Dominik Mikiewicz
Publisher : Packt Publishing Ltd
ISBN 13 : 1784395447
Total Pages : 321 pages
Book Rating : 4.45/5 ( download)

DOWNLOAD NOW!

Download or read book Mastering PostGIS written by Dominik Mikiewicz and published by Packt Publishing Ltd. This book was released on 2017-05-31 with total page 321 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.

Author : Regina O. Obe
Publisher : "O'Reilly Media, Inc."
ISBN 13 : 1449326293
Total Pages : 167 pages
Book Rating : 4.96/5 ( download)

DOWNLOAD NOW!

Download or read book PostgreSQL: Up and Running written by Regina O. Obe and published by "O'Reilly Media, Inc.". This book was released on 2012-07-06 with total page 167 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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

Author : Robin Lovelace
Publisher : CRC Press
ISBN 13 : 1351396900
Total Pages : 335 pages
Book Rating : 4.05/5 ( download)

DOWNLOAD NOW!

Download or read book Geocomputation with R written by Robin Lovelace and published by CRC Press. This book was released on 2019-03-22 with total page 335 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.

Author : Regina Obe
Publisher : Locate Press
ISBN 13 : 9780989421737
Total Pages : pages
Book Rating : 4.32/5 ( download)

DOWNLOAD NOW!

Download or read book PgRouting written by Regina Obe and published by Locate Press. This book was released on 2015-10-31 with total page pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.

Author : Salahaldin Juba
Publisher : Packt Publishing Ltd
ISBN 13 : 1789535212
Total Pages : 545 pages
Book Rating : 4.11/5 ( download)

DOWNLOAD NOW!

Download or read book Learning PostgreSQL 11 written by Salahaldin Juba and published by Packt Publishing Ltd. This book was released on 2019-01-31 with total page 545 pages. Available in PDF, EPUB and Kindle. Book excerpt: Leverage the power of PostgreSQL 11 to build powerful database and data warehousing applications Key FeaturesMonitor, secure, and fine-tune your PostgreSQL 11 databaseLearn client-side and server-side programming using SQL and PL/pgSQLDiscover tips on implementing efficient database solutionsBook Description PostgreSQL is one of the most popular open source database management systems in the world, and it supports advanced features included in SQL standards. This book will familiarize you with the latest features in PostgreSQL 11, and get you up and running with building efficient PostgreSQL database solutions from scratch. Learning PostgreSQL, 11 begins by covering the concepts of relational databases and their core principles. You’ll explore the Data Definition Language (DDL) and commonly used DDL commands supported by ANSI SQL. You’ll also learn how to create tables, define integrity constraints, build indexes, and set up views and other schema objects. As you advance, you’ll come to understand Data Manipulation Language (DML) and server-side programming capabilities using PL/pgSQL, giving you a robust background to develop, tune, test, and troubleshoot your database application. The book will guide you in exploring NoSQL capabilities and connecting to your database to manipulate data objects. You’ll get to grips with using data warehousing in analytical solutions and reports, and scaling the database for high availability and performance. By the end of this book, you’ll have gained a thorough understanding of PostgreSQL 11 and developed the necessary skills to build efficient database solutions. What you will learnUnderstand the basics of relational databases, relational algebra, and data modelingInstall a PostgreSQL server, create a database, and implement your data modelCreate tables and views, define indexes and stored procedures, and implement triggersMake use of advanced data types such as Arrays, hstore, and JSONBConnect your Python applications to PostgreSQL and work with data efficientlyIdentify bottlenecks to enhance reliability and performance of database applicationsWho this book is for This book is for you if you're interested in learning about PostgreSQL from scratch. Those looking to build solid database or data warehousing applications or wanting to get up to speed with the latest features of PostgreSQL 11 will also find this book useful. No prior knowledge of database programming or administration is required to get started.

Author : Brian Youngblood
Publisher : Packt Publishing Ltd
ISBN 13 : 1849516693
Total Pages : 559 pages
Book Rating : 4.93/5 ( download)

DOWNLOAD NOW!

Download or read book GeoServer Beginner's Guide written by Brian Youngblood and published by Packt Publishing Ltd. This book was released on 2013-01-01 with total page 559 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.

Author : Kyle Banker
Publisher : Manning Publications
ISBN 13 : 9781617291609
Total Pages : 375 pages
Book Rating : 4.09/5 ( download)

DOWNLOAD NOW!

Download or read book Mongodb in Action written by Kyle Banker and published by Manning Publications. This book was released on 2015-01-15 with total page 375 pages. Available in PDF, EPUB and Kindle. Book excerpt: 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.