Re: [postgis-users] Cascaded Union Aggregate function

2008-10-06 Thread Dane Springmeyer
On Oct 6, 2008, at 4:02 AM, Obe, Regina wrote: Dane, I just ran the full union set in OpenJump and it took 55 seconds. Yes, 42 seconds for the full union. wow. Running your below for me with the OpenJump that contains the Cascade Union functionality takes 30 seconds. Yes, 32 seconds he

Re: [postgis-users] Cascaded Union Aggregate function

2008-10-06 Thread Dane Springmeyer
2008). I'll go back and try to get the latest. Dane Thanks, Regina From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ] On Behalf Of Dane Springmeyer Sent: Monday, October 06, 2008 1:46 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] Cascaded Union Aggregate function Regi

RE: [postgis-users] Cascaded Union Aggregate function

2008-10-06 Thread Bresnahan, Mike
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Hooray! I will give this a test soon. > -Original Message- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On > Behalf Of Paragon Corporation > Sent: Saturday, October 04, 2008 6:44 PM > To: 'PostGIS Users Discussion' > Subject: [p

RE: [postgis-users] Cascaded Union Aggregate function

2008-10-06 Thread Obe, Regina
egina Sent: Monday, October 06, 2008 7:02 AM To: PostGIS Users Discussion Subject: RE: [postgis-users] Cascaded Union Aggregate function Dane, I just ran the full union set in OpenJump and it took 55 seconds. Running your below for me with the OpenJump that contains the Cascade Union functiona

RE: [postgis-users] Cascaded Union Aggregate function

2008-10-06 Thread Obe, Regina
M To: 'PostGIS Users Discussion' Subject: RE: [postgis-users] Cascaded Union Aggregate function Dan, Disregard my last email except the OpenJump part. I was reading out of order. Thanks, Regina From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On B

RE: [postgis-users] Cascaded Union Aggregate function

2008-10-06 Thread Paragon Corporation
hanks, Regina _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dane Springmeyer Sent: Sunday, October 05, 2008 12:59 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Cascaded Union Aggregate function Regina, Great, my query now works with your amended upgis function posti

RE: [postgis-users] Cascaded Union Aggregate function

2008-10-06 Thread Paragon Corporation
ks, Regina _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dane Springmeyer Sent: Monday, October 06, 2008 1:46 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] Cascaded Union Aggregate function Regina, On Oct 5, 2008, at 10:29 AM, Paragon Corporation wro

Re: [postgis-users] Cascaded Union Aggregate function

2008-10-05 Thread Dane Springmeyer
163,612. Thanks, Regina From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] ] On Behalf Of Dane Springmeyer Sent: Sunday, October 05, 2008 12:59 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Cascaded Union Aggregate function Regina, Great, my query now works with your amend

Re: [postgis-users] Cascaded Union Aggregate function

2008-10-05 Thread Dane Springmeyer
AIL PROTECTED] [mailto:[EMAIL PROTECTED] ] On Behalf Of Dane Springmeyer Sent: Sunday, October 05, 2008 12:59 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Cascaded Union Aggregate function Regina, Great, my query now works with your amended upgis function posting. So, here are my t

RE: [postgis-users] Cascaded Union Aggregate function

2008-10-05 Thread Paragon Corporation
: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dane Springmeyer Sent: Sunday, October 05, 2008 12:59 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Cascaded Union Aggregate function Regina, Great, my query now works with your amended upgis function posting. So, her

Re: [postgis-users] Cascaded Union Aggregate function

2008-10-05 Thread Dane Springmeyer
ECTED] On Behalf Of Dane Springmeyer Sent: Sunday, October 05, 2008 1:47 AM To: PostGIS Users Discussion Subject: Re: [postgis-users] Cascaded Union Aggregate function Hi Regina, Thank you so much for the wiki posting. I've been using your code from your august 12th email with great succe

RE: [postgis-users] Cascaded Union Aggregate function

2008-10-05 Thread Paragon Corporation
om: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dane Springmeyer Sent: Sunday, October 05, 2008 12:42 PM To: PostGIS Users Discussion Subject: Re: [postgis-users] Cascaded Union Aggregate function You bet, Here is the data: http://riverchange.org/opendatashare/north_pacific_watersheds.zip

Re: [postgis-users] Cascaded Union Aggregate function

2008-10-05 Thread Dane Springmeyer
Users Discussion Subject: Re: [postgis-users] Cascaded Union Aggregate function Hi Regina, Thank you so much for the wiki posting. I've been using your code from your august 12th email with great success, if not joy. What an amazing speed improvement, especially for such a critical function.

RE: [postgis-users] Cascaded Union Aggregate function

2008-10-05 Thread Paragon Corporation
AM To: PostGIS Users Discussion Subject: Re: [postgis-users] Cascaded Union Aggregate function Hi Regina, Thank you so much for the wiki posting. I've been using your code from your august 12th email with great success, if not joy. What an amazing speed improvement, especially for such a cri

Re: [postgis-users] Cascaded Union Aggregate function

2008-10-04 Thread Dane Springmeyer
Hi Regina, Thank you so much for the wiki posting. I've been using your code from your august 12th email with great success, if not joy. What an amazing speed improvement, especially for such a critical function. This was your exact email of code I have working: http://postgis.refractions.n

RE: [postgis-users] Cascaded Union Aggregate function

2008-10-04 Thread Paragon Corporation
Oops sorry about that. Just realized I had ugly spaces in the link. I've changed it. Use this one http://postgis.refractions.net/support/wiki/index.php?upgis_cascadeunion -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paragon Corporation Sent: Satur