Postgres + PostGIS + GeoServer offline path planning function (record)

Write it at the front ：

There are many schemes for offline path planning , Generally choose according to needs . The final planning result is affected by many factors . such as ：

• Whether the original line data is reliable 、
• Whether the attribute data is complete
• Whether there is topology error between different types of lines
• Whether the path planning function is reasonable
• Fault tolerance , wait

Text content ：
This article is a novice friendly tutorial , The content is quite detailed , If you are experienced giser You may find the content more cumbersome （ ha-ha ）.

1 install Postgres database

Need to be installed at the same time postgis plug-in unit

2 Naviact Connect to database

Easy to carry out SQL sentence

3 QGIS Connect to database

Easy to visualize route data , At the same time, it is convenient to import data into the database

4 Route data warehousing

Use QGIS Import route data into postgres database

5 Line topology construction （SQL sentence ）

stay navicat In the implementation of sql sentence , Build line topology .（ This process is the relocation step of route planning , Very important ！）

6 Create a query SQL function

To write SQL function . The purpose is to use postgis Its own spatial analysis method , Query paths and organize query results

7 Geoserver install

A tool , Commonly used in release management GIS Map service , The experiment is used to provide path planning interface .（ If you have the ability to write your own back-end code and operate the database , You can ignore the second 7、8 step ）

8 Route planning service release

be based on geoserver Provide path planning services

9 Test service

The longitude and latitude of the incoming starting and ending point , Return the planning result route

10 Summary of experience

The pit passed