How can we improve the speed of the functionst_worldtorastercoordx(rast,geom)[

本文探讨了在中国移动湖北分公司的小型项目中,如何使用PostGIS进行矢量到栅格的转换,特别是在大规模点数据集上的性能优化。作者分享了在转换过程中的挑战和解决方案,包括通过手动计算坐标来加速查询速度,避免依赖PostGIS的特定函数,以提高效率。同时,提供了具体案例和代码示例,帮助读者理解如何在类似场景下应用PostGIS进行高效的数据处理。

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

[size=large]Hi Pierre:[/size]
[size=large] I am a project manager of chinamobile HubeI ,recently we are woking on a mini-project to verify the Raster function of PostGIS 2.1.

Raster DATA is such an advanced data model, therefor it is so difficult to find some materials on the project of Raster DATA . Thanks to the GOD, I find your web-site in the university LAVAL and the Le Centre d’étude de la forêt ( I know a little francs) , I carefulread the ppt <<Stockage, manipulation et analyse de données matricielles avec PostGIS Raster>>, And I get to know the methods about the raster creation function. Thank you so much for all your
materials on the web-site, it help me to step on step future in the area of advanved Spatial analysis technology. Just like you have said , form vector to Raster. By the way, I work in the wireless netwok management deparement. Our daily work rely heavly on the tools MAPinfo, which is realy a hard labor job , especially for some SPatial analysis task. Now I get to know more about PostGIS. In the future, I will transfer all the Job form MAPinfo to PostGIS. How I can learn from you in the future.

With the help of your document, it took us more than 3 weeks to finish the project. yet we have a problem on the function st_worldtorastercoordx(rast,geom).
the commands are
update atu_sample set x =st_worldtorastercoordx(rast,geom) from myrasters;

update atu_sample set y =st_worldtorastercoordy(rast,geom) from myrasters;

In the above example , we have 12000 points and a 1327* 1555 (pixels) raster data . it takes more than 160 Seconds to finish the task. In the future project, we will have more than 1200000 points , how could we fix the Performance problem?

hope you could help us to fix the problem , and do please keep in touch.

what is more , I send you a doucment on our mini-project. you can konw more on our project.[/size]

zhanying


Hi,

Why do you extract the raster coordinates? What do you do with it afterward?

To make the query faster you could simply do the math yourself without relying on the ST_WorldToRasterCoord() function.


Pierre



[img]http://dl2.iteye.com/upload/attachment/0110/3291/7be82d3d-5aa3-34aa-84b6-030851227528.jpg[/img]


[img]http://dl2.iteye.com/upload/attachment/0110/3293/8682c845-8a4e-3b84-a174-5f5303168866.jpg[/img]


[img]http://dl2.iteye.com/upload/attachment/0110/3295/b3d69a61-4bf7-3ba9-bdf2-ad8b4713d486.jpg[/img]


[img]http://dl2.iteye.com/upload/attachment/0110/3298/18d28f69-e58e-3fb4-ab89-74f9169e62a6.jpg[/img]



[img]http://dl2.iteye.com/upload/attachment/0110/5560/49d30c68-62f6-31d3-a0ec-781fec1a14d6.jpg[/img]


[img]http://dl2.iteye.com/upload/attachment/0110/5562/62dc9bb8-a8a8-3ecf-a0d0-e0409b320a35.jpg[/img]


[img]http://dl2.iteye.com/upload/attachment/0110/5566/291b74a0-6868-38de-81bd-cf6a322100b2.jpg[/img]

[img]http://dl2.iteye.com/upload/attachment/0110/5564/9820769b-6bce-3e61-821d-c2b183d0e0b5.jpg[/img]
内容概要:本文档详细介绍了基于MATLAB实现多目标差分进化(MODE)算法进行无人机三维路径规划的项目实例。项目旨在提升无人机在复杂三维环境中路径规划的精度、实时性、多目标协调处理能力、障碍物避让能力和路径平滑性。通过引入多目标差分进化算法,项目解决了传统路径规划算法在动态环境和多目标优化中的不足,实现了路径长度、飞行安全距离、能耗等多个目标的协调优化。文档涵盖了环境建模、路径编码、多目标优化策略、障碍物检测与避让、路径平滑处理等关键技术模块,并提供了部分MATLAB代码示例。 适合人群:具备一定编程基础,对无人机路径规划和多目标优化算法感兴趣的科研人员、工程师和研究生。 使用场景及目标:①适用于无人机在军事侦察、环境监测、灾害救援、物流运输、城市管理等领域的三维路径规划;②通过多目标差分进化算法,优化路径长度、飞行安全距离、能耗等多目标,提升无人机任务执行效率和安全性;③解决动态环境变化、实时路径调整和复杂障碍物避让等问题。 其他说明:项目采用模块化设计,便于集成不同的优化目标和动态环境因素,支持后续算法升级与功能扩展。通过系统实现和仿真实验验证,项目不仅提升了理论研究的实用价值,还为无人机智能自主飞行提供了技术基础。文档提供了详细的代码示例,有助于读者深入理解和实践该项目。
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值