本文探讨了在中国移动湖北分公司的小型项目中，如何使用PostGIS进行矢量到栅格的转换，特别是在大规模点数据集上的性能优化。作者分享了在转换过程中的挑战和解决方案，包括通过手动计算坐标来加速查询速度，避免依赖PostGIS的特定函数，以提高效率。同时，提供了具体案例和代码示例，帮助读者理解如何在类似场景下应用PostGIS进行高效的数据处理。
[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]
[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]
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
