• Chapters
  • 1. 序章
  • 2. ワークショップについて
    • 2.1. pgRouting 概要
    • 2.2. osm2pgrouting 概要
    • 2.3. OpenStreetMap 概要
  • 3. インストール
    • 3.1. VirtualBox 上の OSGeoLive
  • 4. Prepare Data
    • 4.1. Prepare the database
    • 4.2. Get the Workshop Data
    • 4.3. Upload Data to the database
  • 5. pgRouting Algorithms
    • 5.1. pgr_dijkstra
    • 5.2. pgr_dijkstraCost
  • 6. Advanced Routing Queries
    • 6.1. Routing for Vehicles
    • 6.2. Cost Manipulations
  • 7. Writing a SQL Stored Procedures
    • 7.1. The application requirements
    • 7.2. Geometry handling
    • 7.3. Creating a Function
  • 8. Writing a pl/pgsql Stored Procedures
    • 8.1. Requirements for Routing from A to B
    • 8.2. The Vertex Table
    • 8.3. wrk_fromAtoB function
  • 9. Using Qgis
    • 9.1. Set Up QGIS
    • 9.2. Add a postGIS Layer
    • 9.3. Format a Routing Layer
    • 9.4. Copy/Paste Format
    • 9.5. Save the project
  • 10. WMS server with GeoServer
    • 10.1. Connect to the administration page
    • 10.2. Create the layer
  • 11. OpenLayers Based Routing Interface
    • 11.1. OpenLayers introduction
    • 11.2. Creating a minimal map
    • 11.3. WMS GET parameters
    • 11.4. Select 「start」 and 「destination」
    • 11.5. Clear the results
    • 11.6. Summary (full example)
  • 12. Create a Network Topology
    • 12.1. Load network data
    • 12.2. Create a Routing Network Topology
    • 12.3. Verify the Routing Network Topology
    • 12.4. Analyze and Adjust the Routing Network Topology
  • 13. Appendix: Workshop Solutions
    • 13.1. pgRouting Algorithms Solutions
    • 13.2. Advanced Routing Queries Solutions
    • 13.3. Solutions to Writing a SQL Stored Procedures Chapter
    • 13.4. Solutions to Writing a pl/pgsql Stored Procedures Chapter
  • 14. Appendix: Installation
  • 15. Appendix: osm2pgrouting Import Tool
• Page
  • pgRouting ワークショップ
• 1. 序章 »