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]
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值