用pgrouting对openstreetmap数据进行路径分析
来源:互联网 发布:淘宝网ccdd女装正品 编辑:程序博客网 时间:2024/05/29 10:09
1,将道路osm数据增加列字段
ALTER TABLE changsharoad_connected ADD COLUMN source integer;
ALTER TABLE changsharoad_connected ADD COLUMN target integer;ALTER TABLE changsharoad_connected ADD COLUMN length double precision;
ALTER TABLE changsharoad_connected ADD COLUMN cost double precision;
ALTER TABLE changsharoad_connected ADD COLUMN reverse_cost double precision;
2,创建拓扑及索引
SELECT pgr_createTopology('changsharoad_connected',0.000001, 'geom', 'gid');
create index road_source_idx on changsharoad_connected("source");
create index road_target_idx on changsharoad_connected("target");
3,分析单双向
SELECT pgr_analyzeOneway('changsharoad_connected', ARRAY['', 'B', 'T'], ARRAY['', 'B', 'F'],ARRAY['', 'B', 'F'], ARRAY['', 'B', 'T'])
update changsharoad_connected set length = ST_LengthSpheroid(geom, 'SPHEROID["WGS 84",6378137,298.257223563]');
update changsharoad_connected set cost=length where oneway='B' or oneway='F'
update changsharoad_connected set cost=-length where oneway='T'
update changsharoad_connected set reverse_cost=-length where oneway='F'
update changsharoad_connected set reverse_cost=length where oneway='B' or oneway='T'
4,最短路径分析
drop table if exists dijkstra_res;
SELECT seq, id1 AS node, id2 AS edge, a.cost as cost, geom into dijkstra_res FROM pgr_dijkstra('
SELECT gid AS id,
source::integer,
target::integer,
cost::double precision AS cost,
reverse_cost::double precision AS reverse_cost
FROM changsharoad_connected', 20946, 19758, true, true)a
LEFT JOIN changsharoad_connected b
ON (a.id2 = b.gid) order by seq;
阅读全文
0 0
- 用pgrouting对openstreetmap数据进行路径分析
- 使用pgRouting进行路径分析
- pgrouting进行路径规划之入门二
- 最短路径分析算法in PgRouting
- pgrouting路径分析(站点与GRID中心点最短距离)
- 使用pgrouting和geotools实现最短路径,服务区分析
- 路径规划PgRouting
- pgrouting最短路径
- 基于OpenStreetMap地图数据的离线路径规划
- pgrouting路径分析(任意两点之间的最短路径)
- pgrouting最优路径规划之一
- 数据挖掘对客户进行深入分析
- 怎样才能够对数据进行直观分析?
- 对网页数据进行提取与分析
- 如何对文件路径进行分析的最好方法
- pgrouting
- OpenStreetMap 获取地图数据
- 关于OpenStreetMap数据
- Linux守护进程
- leetcode226. Invert Binary Tree
- 2017.8.14--2017.8.25
- 以软硬一体化SaaS平台技术切入 奥付云瞄准的是所有自助设备的运营提升空间
- 排序算法——希尔排序
- 用pgrouting对openstreetmap数据进行路径分析
- 数据挖掘的主要技术
- 语录一
- xmpp学习
- Http下载与Ftp下载区别
- GCD收录1
- DSOD: Learning Deeply Supervised Object Detectors from Scratch 论文笔记
- CAD图纸转pdf的步骤方法
- Using ftrace