Re: [postgis-users] raster clipping

2012-01-27 Thread Bborie Park
Hey Steve, If you don't have ST_Clip on your machine, you may want to update your PostGIS to the latest. ST_Clip with the parameter "trimraster" set to TRUE is functionally the equivalent of ST_Intersection. You may see better performance by doing the ST_Union AFTER ST_Clip/ST_Intersection

[postgis-users] raster clipping

2012-01-27 Thread Stephen Crawford
Hi All, I'm new to raster queries and i have what should be a simple operation but i can't figure it out. I have a tiled raster table for the USA lower 48 in a Lambert Conformal Conic (LCC) projection. I would like to clip this raster to the USA polygon layer, which is in epsg 4326. Since

Re: [postgis-users] ST_Quantile

2012-01-27 Thread Bborie Park
Joan, I've committed a fix for that problem in r8949. -bborie On 01/27/2012 11:52 AM, Bborie Park wrote: The way you called ST_Quantile is perfectly acceptable as there are variants of ST_Quantile that support that form. I'm fixing the problem now and should have it committed later today. -b

Re: [postgis-users] ST_Quantile

2012-01-27 Thread Bborie Park
The way you called ST_Quantile is perfectly acceptable as there are variants of ST_Quantile that support that form. I'm fixing the problem now and should have it committed later today. -bborie On 01/27/2012 11:42 AM, Joan wrote: The 0.75 is the quantile. I will report the bugs. Thanks for th

Re: [postgis-users] ST_Quantile

2012-01-27 Thread Joan
The 0.75 is the quantile. I will report the bugs. Thanks for the help/info. Joan On 27 January 2012 20:31, Stephen Woodbridge wrote: > Joan, > > Looking at the function the Bborie posted: > > > st_quantile(rastertable text, rastercolumn text, nband int DEFAULT > 1, exclude_nodata_value boolea

Re: [postgis-users] ST_Quantile

2012-01-27 Thread Stephen Woodbridge
Joan, Looking at the function the Bborie posted: st_quantile(rastertable text, rastercolumn text, nband int DEFAULT 1, exclude_nodata_value boolean DEFAULT TRUE, quantiles double precision[] DEFAULT NULL) The 3rd parameter is the band number. What is the 0.75 supposed to represent? My gu

Re: [postgis-users] ST_Quantile

2012-01-27 Thread Bborie Park
Joan, I confirm that there is a segfault. Can you add a ticket for this? I'll take a look ASAP. -bborie On 01/27/2012 11:19 AM, Joan wrote: Hi Steve, I have gotten the same problem (db server stopped running). Joan On 27 January 2012 20:05, Stephen Woodbridgewrote: Joan, I've never us

Re: [postgis-users] ST_Quantile

2012-01-27 Thread Joan
Hi Steve, I have gotten the same problem (db server stopped running). Joan On 27 January 2012 20:05, Stephen Woodbridge wrote: > Joan, > > I've never used these function, but try doing: > > select st_quantile('kbd_ext', 'rast', 0.75); > > Since you probably do not want this called once for ever

Re: [postgis-users] ST_Quantile

2012-01-27 Thread Stephen Woodbridge
Joan, I've never used these function, but try doing: select st_quantile('kbd_ext', 'rast', 0.75); Since you probably do not want this called once for every row in the table. -Steve On 1/27/2012 2:03 PM, Joan wrote: Hi Bborie, This is my query and it crashes the db server. select st_quantile

Re: [postgis-users] ST_Quantile

2012-01-27 Thread Joan
Hi Bborie, This is my query and it crashes the db server. select st_quantile('kbd_ext', 'rast', 0.75) from kbd_ext limit 10; Joan On 27 January 2012 19:14, Bborie Park wrote: > Hey Joan, > > Assuming your whole coverage is in a table, you should use the > table/column version of ST_Quantile (w

Re: [postgis-users] ST_Quantile

2012-01-27 Thread Bborie Park
Hey Joan, Assuming your whole coverage is in a table, you should use the table/column version of ST_Quantile (which by the looks of it is undocumented for some reason). The function definition of ST_Quantile(rastertable, rastercolumn) is... st_quantile(rastertable text, rastercolumn text, nb

Re: [postgis-users] ST_Quantile

2012-01-27 Thread Marco Lechner - FOSSGIS e.V.
am i right that tiles can have different resolutions and therefore the have to weihhted differently? marco Von Samsung-Tablet gesendetJoan hat geschrieben:>Hi, > >I would like to find the quantile values of a whole raster coverage, but >ST_Quantile returns quantile values of each tile. Which wo

Re: [postgis-users] ST_Quantile

2012-01-27 Thread Joan
The tiles are on the same raster, the have the same resolution. On 27 January 2012 18:17, Marco Lechner - FOSSGIS e.V. < marco.lech...@fossgis.de> wrote: > am i right that tiles can have different resolutions and therefore the > have to weihhted differently? > > marco > > Von Samsung-Tablet gesen

[postgis-users] ST_Quantile

2012-01-27 Thread Joan
Hi, I would like to find the quantile values of a whole raster coverage, but ST_Quantile returns quantile values of each tile. Which would be the best method to approximate the quantile value of the whole coverage? Regards, Joan ___ postgis-users maili

Re: [postgis-users] shp2pgsql-gui and option -S (Generate simple instead of MULTI geometries) / Ticket #660?

2012-01-27 Thread Sandro Santilli
On Thu, Jan 26, 2012 at 09:50:25PM +0100, Stefan Keller wrote: > Hi > > Recent PostGIS versions come with a nifty plugin for pgAdmin3 called > "PostGIS Shapefile and DBF Loader" (shp2pgsql-gui). I see Revision > 7713 in my case. > > A common stumbling block of shp2pgsql is that Shapefile LineStri