Hi Bborie, Pierre,
Thanks for adding the ticket. (http://trac.osgeo.org/postgis/ticket/1889) And I guess I am looking forward to PostGIS 2.1 then :-) (But I am still a little proud of my 'round-about way' to locate the cell with the highest value...) Cheers, Egge-Jan Op maandag 25 juni 2012 21:39:29 UTC+1 schreef Bborie Park het volgende: > > Too many columns. I was thinking that this is better served in a > separate function as that value could be repeated. I'm adding a ticket > for that separate function. > > On 06/25/2012 01:36 PM, Pierre Racine wrote: > > Good find Bborie! > > > > I would add that we should fill a ticket like "ST_Summary should report > the x and y raster coordinates of the max and the min". So four new > columns... > > > > Pierre > > > >> -----Original Message----- > >> From: postgis-users-boun...@postgis.refractions.net [mailto: > postgis-users- > >> boun...@postgis.refractions.net] On Behalf Of Bborie Park > >> Sent: Monday, June 25, 2012 4:32 PM > >> To: postgis-users@postgis.refractions.net > >> Subject: Re: [postgis-users] Finding highest cell value in raster using > ST_Value > >> > >> Egge-Jan, > >> > >> That is an intriguing question with no clean/simple solution. The > >> fastest approach may be to call ST_Reclass() to create a 1BB mask based > >> upon that value and the pass the resulting raster to > >> ST_PixelAsPolygons() which will give you what you want. > >> > >> Yes, the above is a round-about way to do this. This is something I'll > >> (ST_PixelofValue?) see about adding for PostGIS 2.1. > >> > >> -bborie > >> > >> On 06/25/2012 01:16 PM, e.j.h.polle wrote: > >>> Hi, > >>> > >>> OK - with ST_SummaryStats it is easy to retrieve the highest value in > the > >>> raster, but then I only have this value. Now I want to retrieve > >>> (information about) the cell/pixel having this value, to be able to > >>> visualize the highest point on the map. My original query (see first > post) > >>> does give me this information (after 45 seconds...). > >>> > >>> How would I go about to get hold of the pixel with the highest value, > >>> knowing this value? > >>> > >>> Cheers, > >>> > >>> Egge-Jan > >>> > >>> On Sunday, June 24, 2012 8:47:58 PM UTC+1, DavidRA wrote: > >>>> > >>>> Why don't you use ST_SummaryStats instead ST_Value? That way you can > get > >>>> easily any basic stat, included the maximum value of the raster. It > would > >>>> be > >>>> something like: > >>>> > >>>> SELECT (ST_SummaryStats(rast)).max FROM raster_table; > >>>> > >>>> -- > >>>> View this message in context: > >>>> > http://postgis.17.n6.nabble.com/Finding-highest-cell-value-in-raster-using- > >> ST-Value-tp4998545p4998554.html > >>>> Sent from the PostGIS - User mailing list archive at Nabble.com. > >>>> _______________________________________________ > >>>> postgis-users mailing list > >>>> postgis-users@postgis.refractions.net > >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users > >>>> > >>> > >>> On Sunday, June 24, 2012 8:47:58 PM UTC+1, DavidRA wrote: > >>>> > >>>> Why don't you use ST_SummaryStats instead ST_Value? That way you can > get > >>>> easily any basic stat, included the maximum value of the raster. It > would > >>>> be > >>>> something like: > >>>> > >>>> SELECT (ST_SummaryStats(rast)).max FROM raster_table; > >>>> > >>>> -- > >>>> View this message in context: > >>>> > http://postgis.17.n6.nabble.com/Finding-highest-cell-value-in-raster-using- > >> ST-Value-tp4998545p4998554.html > >>>> Sent from the PostGIS - User mailing list archive at Nabble.com. > >>>> _______________________________________________ > >>>> postgis-users mailing list > >>>> postgis-users@postgis.refractions.net > >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users > >>>> > >>> > >>> On Sunday, June 24, 2012 8:47:58 PM UTC+1, DavidRA wrote: > >>>> > >>>> Why don't you use ST_SummaryStats instead ST_Value? That way you can > get > >>>> easily any basic stat, included the maximum value of the raster. It > would > >>>> be > >>>> something like: > >>>> > >>>> SELECT (ST_SummaryStats(rast)).max FROM raster_table; > >>>> > >>>> -- > >>>> View this message in context: > >>>> > http://postgis.17.n6.nabble.com/Finding-highest-cell-value-in-raster-using- > >> ST-Value-tp4998545p4998554.html > >>>> Sent from the PostGIS - User mailing list archive at Nabble.com. > >>>> _______________________________________________ > >>>> postgis-users mailing list > >>>> postgis-users@postgis.refractions.net > >>>> http://postgis.refractions.net/mailman/listinfo/postgis-users > >>>> > >>> > >>> > >>> > >>> _______________________________________________ > >>> postgis-users mailing list > >>> postgis-users@postgis.refractions.net > >>> http://postgis.refractions.net/mailman/listinfo/postgis-users > >> > >> -- > >> Bborie Park > >> Programmer > >> Center for Vectorborne Diseases > >> UC Davis > >> 530-752-8380 > >> bkp...@ucdavis.edu > >> _______________________________________________ > >> postgis-users mailing list > >> postgis-users@postgis.refractions.net > >> http://postgis.refractions.net/mailman/listinfo/postgis-users > > _______________________________________________ > > postgis-users mailing list > > postgis-users@postgis.refractions.net > > http://postgis.refractions.net/mailman/listinfo/postgis-users > > > > -- > Bborie Park > Programmer > Center for Vectorborne Diseases > UC Davis > 530-752-8380 > bkp...@ucdavis.edu > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users >
_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
