Locate Press Bookstore
Sale!
pgRouting - A Practical Guide

pgRouting: A Practical Guide (Print)

Original price was: $36.00.Current price is: $34.00.

What is pgRouting? It’s a PostgreSQL extension for developing network routing applications and doing graph analysis. pgRouting is well suited to building travel navigation systems and computing driving distance polygons for places of interest. While the main focus of pgRouting is GIS applications, it can be used for non-GIS resource management and routing applications.

SKU: PGR-PRINT Category: Tags: , , , , , ,

Description

by Regina Obe and Leo Hsu

pgRouting logo of blue elephant following a GPS map

Extending PostgreSQL and PostGIS with routing
and graph analysis

What is pgRouting? It’s a PostgreSQL extension for developing network routing applications and doing graph analysis.

Interested inƂĀ pgRouting? If so, chances are you already useƂĀ PostGIS, the spatial extender for theƂĀ PostgreSQLƂĀ database management system. So when you’ve got PostGIS, why do you need pgRouting? PostGIS is a great tool for molding geometries and doing proximity analysis, however it falls short when your proximity analysis involves constrained paths such as driving along a road or biking along defined paths.

PostGIS alone can’t help you apply costs and resource constraints to your travels, such as traffic congestion, mileage restrictions, or allocating resources like vehicles. pgRouting is a complement to PostGIS that allows you to incorporate costs and path restrictions to your proximity analysis.

pgRouting is well suited to building travel navigation systems and computing driving distance polygons for places of interest. While the main focus of pgRouting is GIS applications, it can be used for non-GIS resource management and routing applications.

Contents

  1. Getting Started with pgRouting
    • Introducing pgRouting
    • A Primer
  2. Working with Data
    • Importing ESRI Shapefiles
    • Importing Textual Data
    • Using ogr2ogr to Load Data
    • Importing OSM Data
    • Foreign Data Wrappers
  3. Working with pgRouting Functions
    • Writing pgRouting Wrapper Functions
    • Data Fixing and Applying Costs
    • Multiple Routes to Single Destination (KSP)
    • Dijkstra In-depth
    • Catchement Areas and Isochrones
    • Traveling Salesperson Problems
    • Vehicle Routing Problems
    • Routing with Turn Restriction Functions
  1. Using QGIS with pgRouting
    • Setting up a PostGIS Connection using PostGIS Add Layer
    • Map View Panel
    • Db Manager Plugin
    • OpenLayers Plugin
    • pgRoutingLayer Plugin
  2. Integrating pgRouting in Web applications
    • Basic Application Setup
    • Database Stored Functions to Support App
    • Web Server-side
    • Client Front-end
    • Web Mapping Client
  3. Appendix
    • Appendix A: changes between pgRouting 2.0 and 2.1
    • Appendix B: Installation extras

For questions regarding this book, please contact:ƂĀ [email protected]

To keep up to date on pgRouting and our other books, subscribe to our low-volumeƂĀ newsletter.

Regina Obe

Regina Obe, author of pgRouting at Locate Press}}ƂĀ Ć‚Ā Ć‚Ā 
Latest BookƂĀ 

Regina Obe is a web application and database expert with extensive experience in PostgreSQLƂĀ and SQL Server data-driven web applications. She has over 25 years professional experience in various programming languages and database systems. She is an expert onƂĀ PostGIS spatial database engineƂĀ and is a member of the PostGIS project steering committee, the PostGIS core development team,ƂĀ pgRoutingƂĀ development team, andƂĀ GEOSƂĀ development and project steering committee.

Regina holds a BS degree in mechanical engineering from the Massachusetts Institute of Technology with a concentration in Bioelectronics and control systems.

She is a co-author of the booksƂĀ pgRouting: A Practical GuideƂĀ (publisher, Locate Press),ƂĀ PostGIS in ActionƂĀ (1st, 2nd, and 3rd editions), published by Manning Publications andƂĀ PostgreSQL: Up and Running, 3rd Edition, 2nd Edition (and 1st edition) published by O’Reilly Media and upcomingƂĀ SQL in a Nutshell, 4th editionƂĀ by O’Reilly Media

Leo Hsu

Leo Hsu, author of pgRouting at Locate Press}}ƂĀ 
Latest BookƂĀ 

Leo Hsu is a master database architect with extensive experience building business intelligence and automation applications for flight management, labor unions, and eCommerce sites. He has over 20 years professional experience working for non-profits and Dot coms developing automated pricing and process applications and devising workflow strategies. Leo focuses on database design, application architecture, and overall project management. He is the resident SQL expert. Leo holds an MS degree in engineering of economic systems from Stanford University. He also holds dual BS degrees in mechanical engineering and economics from the Massachusetts Institute of Technology with a minor in Finance. He speaks fluently in both English and Chinese.

He is a co-authorƂĀ PostGIS in ActionƂĀ (1st and 2nd editions, and upcoming 3rd), published by Manning Publications and PostgreSQL: Up and Running 3rd Edition (and 2nd, 1st editions) published by O’Reilly Media, andƂĀ pgRouting: A Practical GuideƂĀ (publisher,ƂĀ Locate Press). He is working on 2nd edition of pgRouting with Regina.

Additional information

Pages

282
ISBN

978-0989421737
Published

2017-05-31

Related products

WordPress Appliance - Powered by TurnKey Linux