[Oracle]在数据库中实现地图匹配

内容导读

互联网集市收集整理的这篇技术教程文章主要介绍了[Oracle]在数据库中实现地图匹配，小编现在分享给大家，供广大互联网技能从业者学习和参考。文章包含1397字，纯文字阅读大概需要2分钟。

内容图文

The method to do the map match

1 The algorithm procedures

First ,we should find the most nearest road to the point from all roads in haerbin;

Second, we should find the most nearest point to the point from the road.

For example, as figure 1 ,we will do the map match for the point O.

First ,we choose the most nearest road A by compare the distance between O and A with the distance between O and B.

Second, we choose the most nearest point A3 by compare the distance between O and A1,

the distance between O and A2, the distance between O and A3 with the distance between O and A4.

 

 

  

                   Figure 1

2 The algorithm code – oracle

select g.id into abcid from h_gl g  where

sdo_nn(g.geom,SDO_GEOMETRY(2001,8307,SDO_POINT_TYPE(In_X,In_Y, null),NULL,NULL),‘SDO_NUM_RES=1‘)=‘TRUE‘;

 Select sdo_lrs.convert_to_lrs_geom(sdo_lrs.project_pt(g.geom,m.DIMINFO, sdo_geometry(3001, 8307,                                

                                                       null, sdo_elem_info_array(1, 1,1), sdo_ordinate_array(In_X, In_Y, null))))

v_sql :=‘update table t set t.road_id=‘||abcid||‘,t.longtitude_newgps =‘||v_taxi_pt.SDO_ORDINATES(1) ||‘,

t.latitude_newgps=‘||v_taxi_pt.SDO_ORDINATES(2)||‘ where t.gpsdata_id =‘||IN_GPSDATA_ID;

        

[Oracle]在数据库中实现地图匹配

标签：

本文系统来源：http://www.cnblogs.com/liyong-hit/p/4501381.html

内容总结

以上是互联网集市为您收集整理的[Oracle]在数据库中实现地图匹配全部内容，希望文章能够帮你解决[Oracle]在数据库中实现地图匹配所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错，欢迎将互联网集市网站推荐给程序员好友。

内容备注

版权声明：本文内容由互联网用户自发贡献，该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容， 请发送邮件至 gblab@vip.qq.com 举报，一经查实，本站将立刻删除。

内容手机端

---