18.基于java+postgis的路径分析_java实现postgis-优快云博客

本文链接：https://blog.youkuaiyun.com/yaojindou0/article/details/133268567

本文介绍了如何在PostgreSQL版本12及以上利用下载的SQL脚本创建PGR_fromAtoB函数，用于单线道路数据的路径分析，通过API提供给前端，接收起点和终点坐标作为参数进行查询。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

java路径分析函数（sql文件下载）

1.postgresql 12以下
2.postgresql 12以上

生成postgis函数

使用上面下载下来的sql生成pgr_fromAtoB函数

传入参数

1.单线道路数据表名
2.起止坐标

  @ApiOperation(value = "路径分析")
    @RequestMapping(value = "roadAnaysis", method = RequestMethod.GET, produces = "application/json")
    @ApiImplicitParams({@ApiImplicitParam(paramType = "query", name = "layerName", required = true, dataType = "String", value = "路径分析的线图层，必须是单线"),
            @ApiImplicitParam(paramType = "query", name = "startX", required = true, dataType = "Double", value = "起点位置X坐标"),
            @ApiImplicitParam(paramType = "query", name = "startY", required = true, dataType = "Double", value = "起点位置Y坐标"),
            @ApiImplicitParam(paramType = "query", name = "endX", required = true, dataType = "Double", value = "终点位置X坐标"),
            @ApiImplicitParam(paramType = "query", name = "endY", required = true, dataType = "Double", value = "终点位置Y坐标")
    })

调用sql

   <select id="roadAnaysis" parameterType="com.geotools.gistools.request.RoadAnalysisParam" resultType="java.util.Map">
        select st_asgeojson(geom) as geom  from pgr_fromAtoB('${layerName}',${startX},${startY},${endX},${endY})
    </select>