Re: [postgis-users] Summarizing the temperature values for a buffer within my tables

2011-12-04 Thread Bborie Park
On Fri, Dec 2, 2011 at 10:30 AM, maduako ikechukwu wrote: > Hi Piere, > Thanks for yesterday, right now am trying to summarize the temperature > values within a particular buffer just like you did in the tutorial using > the codes below but it seems troublesome. > could you help me please. I dont

Re: [postgis-users] Summarizing the temperature values for a buffer within my tables

2011-12-03 Thread maduako ikechukwu
Hi, guys, Hi Piere, yesterday no one replied me. I have tried to rewrite the code this way SELECT sum(ST_Area(the_geom)*val)/(sum(ST_Area(the_geom))) AS meantemp >From (Select(ST_Intersection(R.rast,(ST_Transform(ST_Buffer(I.the_geom, 1000), 32613.geom AS the_geom, (ST_Intersection(R.rast,(ST_

[postgis-users] Summarizing the temperature values for a buffer within my tables

2011-12-02 Thread maduako ikechukwu
Hi Piere, Thanks for yesterday, right now am trying to summarize the temperature values within a particular buffer just like you did in the tutorial using the codes below but it seems troublesome. could you help me please. I dont have to create tables one after the other like you did in the tutoria