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

[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]