wayne-xyz / GSoC-pgRouting

Semi-mirror repository for GSoC students work
GNU General Public License v2.0
1 stars 0 forks source link

Task 5: Get familiar with pgRouting #4

Open wayne-xyz opened 3 months ago

wayne-xyz commented 3 months ago
wayne-xyz commented 3 months ago

workshop introduction

Installation done on task3

(base) rongweiji@RongWeis-MacBook-Air pgrouting-1 % mkdir build (base) rongweiji@RongWeis-MacBook-Air pgrouting-1 % cd build (base) rongweiji@RongWeis-MacBook-Air build % cmake .. CMake Deprecation Warning at CMakeLists.txt:1 (cmake_minimum_required): Compatibility with CMake < 3.5 will be removed from a future version of CMake. Update the VERSION argument value or use a ... suffix to tell CMake that the project does not need compatibility with older versions. -- Setting build type to 'Release' as none was specified. -- CMAKE_BUILD_TYPE Release -- The C compiler identification is AppleClang 15.0.0.15000309 -- The CXX compiler identification is AppleClang 15.0.0.15000309 -- Detecting C compiler ABI info -- Detecting C compiler ABI info - done -- Check for working C compiler: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/cc - skipped -- Detecting C compile features -- Detecting C compile features - done -- Detecting CXX compiler ABI info -- Detecting CXX compiler ABI info - done -- Check for working CXX compiler: /Applications/Xcode.app/Contents/Developer/Toolchains/XcodeDefault.xctoolchain/usr/bin/c++ - skipped -- Detecting CXX compile features -- Detecting CXX compile features - done -- Found Git: /usr/bin/git (found version "2.39.3 (Apple Git-146)") -- DOXYGEN_MINIMUM_VERSION=1.7 -- SPHINX_MINIMUM_VERSION=4.0 -- POSTGRESQL_MINIMUM_VERSION=9.2.0 -- BOOST_MINIMUM_VERSION=1.56.0 -- POSTGIS_MINIMUM_VERSION=2.0.0 -- Found Boost: /usr/local/lib/cmake/Boost-1.84.0/BoostConfig.cmake (found suitable version "1.84.0", minimum required is "1.56.0") -- Found Perl: /usr/bin/perl (found version "5.34.1") -- POSTGRESQL_PG_CONFIG is /usr/local/opt/postgresql@16/bin/pg_config -- POSTGRESQL_EXECUTABLE is /usr/local/Cellar/postgresql@16/16.2/bin/postgres -- POSTGRESQL_VERSION_STRING in FindPostgreSQL.cmake is PostgreSQL 16.2 (Homebrew) -- POSTGRESQL_INCLUDE_DIR: /usr/local/opt/postgresql@16/include/postgresql/server -- POSTGRESQL_LIBRARIES: /usr/local/opt/postgresql@16/lib -- POSTGRESQL_VERSION_STRING=PostgreSQL 16.2 (Homebrew) -- POSTGRESQL_VERSION=16.2 -- PGSQL_VERSION=162 -- LIBRARY_INSTALL_PATH /usr/local/opt/postgresql@16/lib/postgresql -- Performing Test C_COMPILER_SUPPORTS_FPIC -- Performing Test C_COMPILER_SUPPORTS_FPIC - Success -- Performing Test CXX_COMPILER_SUPPORTS_FPIC -- Performing Test CXX_COMPILER_SUPPORTS_FPIC - Success -- Configuring done (7.7s) -- Generating done (0.9s) -- Build files have been written to: /Users/rongweiji/Projects/pgrouting-1/build (base) rongweiji@RongWeis-MacBook-Air build % make [ 1%] Building C object src/circuits/CMakeFiles/circuits.dir/hawickCircuits.c.o [ 1%] Building CXX object src/circuits/CMakeFiles/circuits.dir/hawickCircuits_driver.cpp.o [ 1%] Built target circuits [ 1%] Building C object src/common/CMakeFiles/common.dir/postgres_connection.c.o [ 2%] Building C object src/common/CMakeFiles/common.dir/e_report.c.o [ 2%] Building CXX object src/common/CMakeFiles/common.dir/basePath_SSEC.cpp.o [ 3%] Building C object src/common/CMakeFiles/common.dir/check_parameters.c.o [ 3%] Building C object src/common/CMakeFiles/common.dir/time_msg.c.o [ 4%] Building CXX object src/common/CMakeFiles/common.dir/pgr_assert.cpp.o [ 4%] Building CXX object src/common/CMakeFiles/common.dir/identifier.cpp.o [ 5%] Building CXX object src/common/CMakeFiles/common.dir/basic_vertex.cpp.o [ 5%] Building CXX object src/common/CMakeFiles/common.dir/xy_vertex.cpp.o [ 6%] Building CXX object src/common/CMakeFiles/common.dir/ch_vertex.cpp.o [ 6%] Building CXX object src/common/CMakeFiles/common.dir/ch_edge.cpp.o [ 7%] Building CXX object src/common/CMakeFiles/common.dir/basic_edge.cpp.o [ 7%] Building CXX object src/common/CMakeFiles/common.dir/pgr_alloc.cpp.o [ 7%] Built target common [ 8%] Building C object src/dijkstra/CMakeFiles/dijkstra.dir/dijkstra.c.o [ 8%] Building C object src/dijkstra/CMakeFiles/dijkstra.dir/dijkstraVia.c.o [ 9%] Building CXX object src/dijkstra/CMakeFiles/dijkstra.dir/dijkstra_driver.cpp.o [ 9%] Building CXX object src/dijkstra/CMakeFiles/dijkstra.dir/dijkstraVia_driver.cpp.o [ 9%] Built target dijkstra [ 9%] Building C object src/allpairs/CMakeFiles/allpairs.dir/floydWarshall.c.o [ 10%] Building CXX object src/allpairs/CMakeFiles/allpairs.dir/floydWarshall_driver.cpp.o [ 10%] Building C object src/allpairs/CMakeFiles/allpairs.dir/johnson.c.o [ 11%] Building CXX object src/allpairs/CMakeFiles/allpairs.dir/johnson_driver.cpp.o [ 11%] Built target allpairs [ 12%] Building C object src/astar/CMakeFiles/astar.dir/astar.c.o [ 12%] Building CXX object src/astar/CMakeFiles/astar.dir/astar_driver.cpp.o [ 12%] Built target astar [ 13%] Building C object src/driving_distance/CMakeFiles/driving_distance.dir/many_to_dist_driving_distance.c.o [ 13%] Building C object src/driving_distance/CMakeFiles/driving_distance.dir/many_to_dist_withPointsDD.c.o /Users/rongweiji/Projects/pgrouting-1/src/driving_distance/many_to_dist_withPointsDD.c:224:54: warning: implicit conversion changes signedness: 'uint64' (aka 'unsigned long') to 'int64' (aka 'long') [-Wsign-conversion] values[0] = Int64GetDatum(funcctx->call_cntr + 1); ~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~^~~ 1 warning generated. [ 14%] Building CXX object src/driving_distance/CMakeFiles/driving_distance.dir/drivedist_driver.cpp.o [ 14%] Building CXX object src/driving_distance/CMakeFiles/driving_distance.dir/withPoints_dd_driver.cpp.o [ 14%] Built target driving_distance [ 14%] Building C object src/ksp/CMakeFiles/ksp.dir/ksp.c.o [ 15%] Building CXX object src/ksp/CMakeFiles/ksp.dir/ksp_driver.cpp.o [ 15%] Building C object src/ksp/CMakeFiles/ksp.dir/withPoints_ksp.c.o [ 16%] Building CXX object src/ksp/CMakeFiles/ksp.dir/withPoints_ksp_driver.cpp.o [ 16%] Building C object src/ksp/CMakeFiles/ksp.dir/turnRestrictedPath.c.o [ 17%] Building CXX object src/ksp/CMakeFiles/ksp.dir/turnRestrictedPath_driver.cpp.o [ 17%] Built target ksp [ 17%] Building C object src/tsp/CMakeFiles/tsp.dir/euclideanTSP.c.o [ 18%] Building C object src/tsp/CMakeFiles/tsp.dir/TSP.c.o [ 18%] Building CXX object src/tsp/CMakeFiles/tsp.dir/tsp.cpp.o [ 19%] Building CXX object src/tsp/CMakeFiles/tsp.dir/TSP_driver.cpp.o [ 19%] Building CXX object src/tsp/CMakeFiles/tsp.dir/euclideanTSP_driver.cpp.o [ 19%] Built target tsp [ 19%] Building CXX object src/alpha_shape/CMakeFiles/alpha_shape.dir/pgr_alphaShape.cpp.o [ 20%] Building C object src/alpha_shape/CMakeFiles/alpha_shape.dir/alphaShape.c.o [ 20%] Building CXX object src/alpha_shape/CMakeFiles/alpha_shape.dir/alphaShape_driver.cpp.o [ 20%] Built target alpha_shape [ 21%] Building C object src/bdAstar/CMakeFiles/bdAstar.dir/bdAstar.c.o [ 21%] Building CXX object src/bdAstar/CMakeFiles/bdAstar.dir/bdAstar_driver.cpp.o [ 21%] Built target bdAstar [ 22%] Building C object src/bdDijkstra/CMakeFiles/bdDijkstra.dir/bdDijkstra.c.o [ 22%] Building CXX object src/bdDijkstra/CMakeFiles/bdDijkstra.dir/bdDijkstra_driver.cpp.o [ 22%] Built target bdDijkstra [ 23%] Building C object src/trsp/CMakeFiles/trsp.dir/trsp.c.o [ 23%] Building CXX object src/trsp/CMakeFiles/trsp.dir/trsp_core.cpp.o [ 24%] Building CXX object src/trsp/CMakeFiles/trsp.dir/GraphDefinition.cpp.o [ 24%] Building C object src/trsp/CMakeFiles/trsp.dir/new_trsp.c.o [ 25%] Building CXX object src/trsp/CMakeFiles/trsp.dir/edgeInfo.cpp.o [ 25%] Building CXX object src/trsp/CMakeFiles/trsp.dir/pgr_trspHandler.cpp.o [ 26%] Building CXX object src/trsp/CMakeFiles/trsp.dir/trsp_driver.cpp.o [ 26%] Building C object src/trsp/CMakeFiles/trsp.dir/trsp_withPoints.c.o [ 27%] Building CXX object src/trsp/CMakeFiles/trsp.dir/trsp_withPoints_driver.cpp.o [ 27%] Building C object src/trsp/CMakeFiles/trsp.dir/trspVia.c.o [ 28%] Building CXX object src/trsp/CMakeFiles/trsp.dir/trspVia_driver.cpp.o [ 28%] Building C object src/trsp/CMakeFiles/trsp.dir/trspVia_withPoints.c.o [ 29%] Building CXX object src/trsp/CMakeFiles/trsp.dir/trspVia_withPoints_driver.cpp.o [ 29%] Built target trsp [ 29%] Building C object src/max_flow/CMakeFiles/max_flow.dir/max_flow.c.o [ 30%] Building C object src/max_flow/CMakeFiles/max_flow.dir/minCostMaxFlow.c.o [ 30%] Building C object src/max_flow/CMakeFiles/max_flow.dir/maximum_cardinality_matching.c.o [ 31%] Building C object src/max_flow/CMakeFiles/max_flow.dir/edge_disjoint_paths.c.o [ 31%] Building CXX object src/max_flow/CMakeFiles/max_flow.dir/max_flow_driver.cpp.o [ 32%] Building CXX object src/max_flow/CMakeFiles/max_flow.dir/maximum_cardinality_matching_driver.cpp.o [ 32%] Building CXX object src/max_flow/CMakeFiles/max_flow.dir/edge_disjoint_paths_driver.cpp.o [ 33%] Building CXX object src/max_flow/CMakeFiles/max_flow.dir/minCostMaxFlow_driver.cpp.o [ 33%] Building CXX object src/max_flow/CMakeFiles/max_flow.dir/pgr_maxflow.cpp.o [ 34%] Building CXX object src/max_flow/CMakeFiles/max_flow.dir/pgr_flowgraph.cpp.o [ 34%] Building CXX object src/max_flow/CMakeFiles/max_flow.dir/pgr_minCostMaxFlow.cpp.o [ 34%] Built target max_flow [ 35%] Building C object src/contraction/CMakeFiles/contraction.dir/contractGraph.c.o [ 35%] Building CXX object src/contraction/CMakeFiles/contraction.dir/contractGraph_driver.cpp.o [ 36%] Building CXX object src/contraction/CMakeFiles/contraction.dir/pgr_contract.cpp.o [ 36%] Built target contraction [ 36%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/pd_orders.cpp.o [ 37%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/fleet.cpp.o [ 37%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/pgr_pickDeliver.cpp.o [ 38%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/dnode.cpp.o [ 38%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/vehicle_pickDeliver.cpp.o [ 39%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/solution.cpp.o [ 39%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/optimize.cpp.o [ 40%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/tw_node.cpp.o [ 40%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/vehicle_node.cpp.o [ 41%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/order.cpp.o [ 41%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/initial_solution.cpp.o [ 42%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/vehicle.cpp.o [ 42%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/pickDeliverEuclidean_driver.cpp.o [ 43%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/pickDeliver_driver.cpp.o [ 43%] Building C object src/pickDeliver/CMakeFiles/pickDeliver.dir/pickDeliverEuclidean.c.o [ 44%] Building C object src/pickDeliver/CMakeFiles/pickDeliver.dir/pickDeliver.c.o [ 44%] Building CXX object src/pickDeliver/CMakeFiles/pickDeliver.dir/pd_problem.cpp.o [ 44%] Built target pickDeliver [ 45%] Building C object src/withPoints/CMakeFiles/withPoints.dir/withPoints.c.o [ 45%] Building CXX object src/withPoints/CMakeFiles/withPoints.dir/get_new_queries.cpp.o [ 46%] Building CXX object src/withPoints/CMakeFiles/withPoints.dir/withPoints_driver.cpp.o [ 46%] Building CXX object src/withPoints/CMakeFiles/withPoints.dir/pgr_withPoints.cpp.o [ 47%] Building C object src/withPoints/CMakeFiles/withPoints.dir/withPointsVia.c.o [ 48%] Building CXX object src/withPoints/CMakeFiles/withPoints.dir/withPointsVia_driver.cpp.o [ 48%] Built target withPoints [ 48%] Building C object src/lineGraph/CMakeFiles/lineGraph.dir/lineGraphFull.c.o [ 49%] Building CXX object src/lineGraph/CMakeFiles/lineGraph.dir/lineGraphFull_driver.cpp.o [ 49%] Building C object src/lineGraph/CMakeFiles/lineGraph.dir/lineGraph.c.o [ 50%] Building CXX object src/lineGraph/CMakeFiles/lineGraph.dir/lineGraph_driver.cpp.o [ 50%] Built target lineGraph [ 51%] Building C object src/components/CMakeFiles/components.dir/connectedComponents.c.o [ 51%] Building C object src/components/CMakeFiles/components.dir/strongComponents.c.o [ 52%] Building C object src/components/CMakeFiles/components.dir/biconnectedComponents.c.o [ 52%] Building C object src/components/CMakeFiles/components.dir/articulationPoints.c.o [ 53%] Building C object src/components/CMakeFiles/components.dir/bridges.c.o [ 53%] Building C object src/components/CMakeFiles/components.dir/makeConnected.c.o [ 54%] Building CXX object src/components/CMakeFiles/components.dir/makeConnected_driver.cpp.o [ 54%] Building CXX object src/components/CMakeFiles/components.dir/componentsResult.cpp.o [ 55%] Building CXX object src/components/CMakeFiles/components.dir/pgr_components.cpp.o [ 55%] Building CXX object src/components/CMakeFiles/components.dir/connectedComponents_driver.cpp.o [ 56%] Building CXX object src/components/CMakeFiles/components.dir/strongComponents_driver.cpp.o [ 56%] Building CXX object src/components/CMakeFiles/components.dir/biconnectedComponents_driver.cpp.o [ 57%] Building CXX object src/components/CMakeFiles/components.dir/articulationPoints_driver.cpp.o [ 57%] Building CXX object src/components/CMakeFiles/components.dir/bridges_driver.cpp.o [ 57%] Built target components [ 58%] Building C object src/bellman_ford/CMakeFiles/bellman_ford.dir/bellman_ford.c.o [ 58%] Building CXX object src/bellman_ford/CMakeFiles/bellman_ford.dir/bellman_ford_driver.cpp.o [ 59%] Building C object src/bellman_ford/CMakeFiles/bellman_ford.dir/edwardMoore.c.o [ 59%] Building CXX object src/bellman_ford/CMakeFiles/bellman_ford.dir/edwardMoore_driver.cpp.o [ 59%] Built target bellman_ford [ 59%] Building CXX object src/cpp_common/CMakeFiles/cpp_common.dir/Dmatrix.cpp.o [ 60%] Building CXX object src/cpp_common/CMakeFiles/cpp_common.dir/compPaths.cpp.o [ 60%] Building CXX object src/cpp_common/CMakeFiles/cpp_common.dir/rule.cpp.o [ 61%] Building CXX object src/cpp_common/CMakeFiles/cpp_common.dir/bpoint.cpp.o [ 61%] Building CXX object src/cpp_common/CMakeFiles/cpp_common.dir/pgr_messages.cpp.o [ 62%] Building CXX object src/cpp_common/CMakeFiles/cpp_common.dir/combinations.cpp.o [ 62%] Building CXX object src/cpp_common/CMakeFiles/cpp_common.dir/get_check_data.cpp.o [ 63%] Building CXX object src/cpp_common/CMakeFiles/cpp_common.dir/pgdata_fetchers.cpp.o [ 63%] Building CXX object src/cpp_common/CMakeFiles/cpp_common.dir/pgdata_getters.cpp.o [ 63%] Built target cpp_common [ 64%] Building C object src/dagShortestPath/CMakeFiles/dagShortestPath.dir/dagShortestPath.c.o [ 64%] Building CXX object src/dagShortestPath/CMakeFiles/dagShortestPath.dir/dagShortestPath_driver.cpp.o [ 64%] Built target dagShortestPath [ 65%] Building C object src/chinese/CMakeFiles/chinese.dir/chinesePostman.c.o [ 65%] Building CXX object src/chinese/CMakeFiles/chinese.dir/chinesePostman_driver.cpp.o [ 65%] Built target chinese [ 66%] Building CXX object src/spanningTree/CMakeFiles/spanningTree.dir/mst_common.cpp.o [ 66%] Building CXX object src/spanningTree/CMakeFiles/spanningTree.dir/details.cpp.o [ 67%] Building C object src/spanningTree/CMakeFiles/spanningTree.dir/kruskal.c.o [ 67%] Building CXX object src/spanningTree/CMakeFiles/spanningTree.dir/kruskal_driver.cpp.o [ 68%] Building C object src/spanningTree/CMakeFiles/spanningTree.dir/prim.c.o [ 68%] Building CXX object src/spanningTree/CMakeFiles/spanningTree.dir/prim_driver.cpp.o [ 68%] Built target spanningTree [ 69%] Building C object src/mincut/CMakeFiles/mincut.dir/stoerWagner.c.o [ 69%] Building CXX object src/mincut/CMakeFiles/mincut.dir/stoerWagner_driver.cpp.o [ 69%] Built target mincut [ 69%] Building C object src/version/CMakeFiles/version.dir/version.c.o [ 69%] Built target version [ 70%] Building C object src/topologicalSort/CMakeFiles/topologicalSort.dir/topologicalSort.c.o [ 70%] Building CXX object src/topologicalSort/CMakeFiles/topologicalSort.dir/topologicalSort_driver.cpp.o [ 70%] Built target topologicalSort [ 71%] Building C object src/transitiveClosure/CMakeFiles/transitiveClosure.dir/transitiveClosure.c.o [ 71%] Building CXX object src/transitiveClosure/CMakeFiles/transitiveClosure.dir/transitiveClosure_driver.cpp.o [ 71%] Built target transitiveClosure [ 72%] Building C object src/breadthFirstSearch/CMakeFiles/breadthFirstSearch.dir/breadthFirstSearch.c.o [ 72%] Building CXX object src/breadthFirstSearch/CMakeFiles/breadthFirstSearch.dir/breadthFirstSearch_driver.cpp.o [ 73%] Building C object src/breadthFirstSearch/CMakeFiles/breadthFirstSearch.dir/binaryBreadthFirstSearch.c.o [ 73%] Building CXX object src/breadthFirstSearch/CMakeFiles/breadthFirstSearch.dir/binaryBreadthFirstSearch_driver.cpp.o [ 73%] Built target breadthFirstSearch [ 74%] Building C object src/traversal/CMakeFiles/traversal.dir/depthFirstSearch.c.o [ 74%] Building CXX object src/traversal/CMakeFiles/traversal.dir/depthFirstSearch_driver.cpp.o [ 74%] Built target traversal [ 75%] Building C object src/coloring/CMakeFiles/coloring.dir/sequentialVertexColoring.c.o [ 75%] Building CXX object src/coloring/CMakeFiles/coloring.dir/sequentialVertexColoring_driver.cpp.o [ 76%] Building C object src/coloring/CMakeFiles/coloring.dir/bipartite.c.o [ 76%] Building CXX object src/coloring/CMakeFiles/coloring.dir/bipartite_driver.cpp.o [ 77%] Building C object src/coloring/CMakeFiles/coloring.dir/edgeColoring.c.o [ 77%] Building CXX object src/coloring/CMakeFiles/coloring.dir/edgeColoring_driver.cpp.o [ 78%] Building CXX object src/coloring/CMakeFiles/coloring.dir/pgr_edgeColoring.cpp.o [ 78%] Built target coloring [ 79%] Building C object src/planar/CMakeFiles/planar.dir/isPlanar.c.o [ 79%] Building CXX object src/planar/CMakeFiles/planar.dir/isPlanar_driver.cpp.o [ 79%] Built target planar [ 80%] Building C object src/dominator/CMakeFiles/dominator.dir/lengauerTarjanDominatorTree.c.o [ 80%] Building CXX object src/dominator/CMakeFiles/dominator.dir/lengauerTarjanDominatorTree_driver.cpp.o [ 80%] Built target dominator [ 81%] Building C object src/ordering/CMakeFiles/ordering.dir/cuthillMckeeOrdering.c.o [ 81%] Building CXX object src/ordering/CMakeFiles/ordering.dir/cuthillMckeeOrdering_driver.cpp.o [ 81%] Built target ordering [ 82%] Linking CXX shared module lib/libpgrouting-3.6.so [ 82%] Built target pgrouting-3.6 [ 83%] Generating pgrouting--3.6.2.sql [ 83%] Built target extension_file [ 83%] Generating pgrouting--3.6.1--3.6.2.sql [ 84%] Generating pgrouting--3.6.0--3.6.2.sql [ 84%] Generating pgrouting--3.5.1--3.6.2.sql [ 85%] Generating pgrouting--3.5.0--3.6.2.sql [ 85%] Generating pgrouting--3.4.2--3.6.2.sql [ 86%] Generating pgrouting--3.4.1--3.6.2.sql [ 86%] Generating pgrouting--3.4.0--3.6.2.sql [ 87%] Generating pgrouting--3.3.5--3.6.2.sql [ 87%] Generating pgrouting--3.3.4--3.6.2.sql [ 88%] Generating pgrouting--3.3.3--3.6.2.sql [ 88%] Generating pgrouting--3.3.2--3.6.2.sql [ 89%] Generating pgrouting--3.3.1--3.6.2.sql [ 89%] Generating pgrouting--3.3.0--3.6.2.sql [ 90%] Generating pgrouting--3.2.2--3.6.2.sql [ 90%] Generating pgrouting--3.2.1--3.6.2.sql [ 91%] Generating pgrouting--3.2.0--3.6.2.sql [ 91%] Generating pgrouting--3.1.4--3.6.2.sql [ 92%] Generating pgrouting--3.1.3--3.6.2.sql [ 92%] Generating pgrouting--3.1.2--3.6.2.sql [ 93%] Generating pgrouting--3.1.1--3.6.2.sql [ 93%] Generating pgrouting--3.1.0--3.6.2.sql [ 94%] Generating pgrouting--3.0.6--3.6.2.sql [ 94%] Generating pgrouting--3.0.5--3.6.2.sql [ 95%] Generating pgrouting--3.0.4--3.6.2.sql [ 95%] Generating pgrouting--3.0.3--3.6.2.sql [ 96%] Generating pgrouting--3.0.2--3.6.2.sql [ 96%] Generating pgrouting--3.0.1--3.6.2.sql [ 97%] Generating pgrouting--3.0.0--3.6.2.sql [ 97%] Generating pgrouting--2.6.3--3.6.2.sql [ 98%] Generating pgrouting--2.6.2--3.6.2.sql [ 98%] Generating pgrouting--2.6.1--3.6.2.sql [ 99%] Generating pgrouting--2.6.0--3.6.2.sql [100%] Built target update_files (base) rongweiji@RongWeis-MacBook-Air build % (base) rongweiji@RongWeis-MacBook-Air build % sudo make install Password: [ 1%] Built target circuits [ 7%] Built target common [ 9%] Built target dijkstra [ 11%] Built target allpairs [ 12%] Built target astar [ 14%] Built target driving_distance [ 17%] Built target ksp [ 19%] Built target tsp [ 20%] Built target alpha_shape [ 21%] Built target bdAstar [ 22%] Built target bdDijkstra [ 29%] Built target trsp [ 34%] Built target max_flow [ 36%] Built target contraction [ 44%] Built target pickDeliver [ 48%] Built target withPoints [ 50%] Built target lineGraph [ 57%] Built target components [ 59%] Built target bellman_ford [ 63%] Built target cpp_common [ 64%] Built target dagShortestPath [ 65%] Built target chinese [ 68%] Built target spanningTree [ 69%] Built target mincut [ 69%] Built target version [ 70%] Built target topologicalSort [ 71%] Built target transitiveClosure [ 73%] Built target breadthFirstSearch [ 74%] Built target traversal [ 78%] Built target coloring [ 79%] Built target planar [ 80%] Built target dominator [ 81%] Built target ordering [ 82%] Built target pgrouting-3.6 [ 83%] Built target extension_file [100%] Built target update_files Install the project... -- Install configuration: "Release" -- Installing: /usr/local/opt/postgresql@16/lib/postgresql/libpgrouting-3.6.so -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.6.1--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.6.0--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.5.1--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.5.0--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.4.2--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.4.1--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.4.0--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.3.5--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.3.4--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.3.3--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.3.2--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.3.1--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.3.0--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.2.2--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.2.1--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.2.0--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.1.4--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.1.3--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.1.2--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.1.1--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.1.0--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.0.6--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.0.5--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.0.4--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.0.3--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.0.2--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.0.1--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.0.0--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--2.6.3--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--2.6.2--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--2.6.1--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--2.6.0--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting--3.6.2.sql -- Installing: /usr/local/opt/postgresql@16/share/postgresql@16/extension/pgrouting.control (base) rongweiji@RongWeis-MacBook-Air build %
wayne-xyz commented 3 months ago

Basic 1 Prepare data

Screenshot 2024-04-01 at 11 53 28 PM
wayne-xyz commented 3 months ago

Basic 2 Pedestrian Routing

Screenshot 2024-04-02 at 12 48 04 AM

Exercise 1

Screenshot 2024-04-02 at 12 59 18 AM

Exercise 2

Screenshot 2024-04-02 at 12 59 58 AM
wayne-xyz commented 3 months ago

Basic 3 Vehicle Routing

Exercise 1

Screenshot 2024-04-02 at 1 04 46 AM

Exercise 2

Screenshot 2024-04-02 at 1 05 34 AM

Exercise 3

Screenshot 2024-04-02 at 1 06 41 AM

Exercise 4

Screenshot 2024-04-02 at 1 07 17 AM
wayne-xyz commented 3 months ago

Basic 4 SQL Function

Exercise 1

Screenshot 2024-04-02 at 1 10 12 AM

Exercise2

Screenshot 2024-04-02 at 1 10 46 AM

Exercise3

Screenshot 2024-04-02 at 1 11 20 AM
wayne-xyz commented 3 months ago

Basic 5 pl/pgsql function

Exercise 1

Screenshot 2024-04-02 at 1 13 43 AM

Exercise 2

Screenshot 2024-04-02 at 1 14 35 AM

Exercise 3

Screenshot 2024-04-02 at 1 15 25 AM

Exercise 4

Screenshot 2024-04-02 at 1 16 11 AM

Exercise 5

Screenshot 2024-04-02 at 1 17 10 AM

Exercise 6

Screenshot 2024-04-02 at 1 17 53 AM