pgr_createTopology创建网络失败。。

Name

pgr_createTopology — Builds a network topology based on the geometry information.

https://docs.pgrouting.org/2.0/en/src/common/doc/functions/create_topology.html

• FAIL when the network topology was not built due to an error:
  • A required column of the Network table is not found or is not of the appropriate type.
  • The condition is not well formed.
  • The names of source , target or id are the same.
  • The SRID of the geometry could not be determined.

失败的原因有以下几种：

• 找不到网络表的必需列或该列的类型不正确。
• 情况不太好。
• 源、目标或id的名称相同。
• 无法确定几何体的SRID。

 

 Unexpected error Geometry has Z dimension but column does not

https://blog.csdn.net/wywywywywywy123456/article/details/84997049

https://www.cnblogs.com/ssjxx98/articles/14127328.html(OpenLayer+Geoserver+postgis实现路径分析（转载）)