Dan,
Disregard my last email except the OpenJump part. I was reading out of
order.
Thanks,
Regina
_
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Dane
Springmeyer
Sent: Monday, October 06, 2008 1:12 AM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Cascade
Hi,
SELECT * FROM table1,table2
WHERE ST_within (table2.the_geom,table1.the_geom);
Fred.
On Mon, Oct 6, 2008 at 9:46 AM, Intengu Technologies <
[EMAIL PROTECTED]> wrote:
> I have a polygon (table1) and a point (table2) feature and would want to
> transfer attributes from the point feature to th
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 functionality takes 30 seconds.
So don't know what was wrong with the other pc I was on. Maybe I had
too much going on or there is something f
Sindile,
If a polygon has one or more point features and you want to transfer the
attributes from the point feature to the polygon feature, then what do
you do in cases where there are multiple points in a polygon
would you
1) pick the first one you hit
2) Sum up, take the max etc. of each
3)
Ken Southerland wrote:
I am using Postgres 8.2.4 on Windows and am having an issue with the
Circular Strings in the Postgis extension.
Why is the bounding box of circularstrings incorrectly calculated. Here
I have a circular string that represents a nearly closed circle...
db=# SELECT astex
Dane,
Thanks for testing this out.
That sounds about right. Yah sorry I missed that bottom part of your
ST_Union. I realized that after the fact. Have you ever tried running it
against the whole dataset (I mean union the whole table into a single
geometry) with ST_Union. That was the one I
Okay I tried on my slightly tweaked OpenSUSE 10.3, 8.2.6, 1.3.4SVN, Geos
3.0.0 VM install.
SELECT 242014/1000.0/60 - 4.03 minutes
SELECT ST_NPoints(upgis_cascadeunion(the_geom)) As afterpoints,
Sum(ST_NPoints(the_geom)) as beforepoints
FROM npsa;
--51.2 secs
SELECT wholedrain, ST_NPoints(upgi
Regina,
Solution 3 is would work fine, but was hoping for a solution to transfer the
attributes into one field without duplicating the poly.
Thanks for the pointer.
2008/10/6 Obe, Regina <[EMAIL PROTECTED]>
> Sindile,
>
> If a polygon has one or more point features and you want to transfer th
I have a polygon (table1) and a point (table2) feature and would want to
transfer attributes from the point feature to the polygon feature based on
whether the point feature is completely enclosed by the polygon feature.
The polygon feature can have one or more point features.
How do i transfer th
RE: [postgis-users] about st_distancethanks , Regina
- Original Message -
From: Obe, Regina
To: PostGIS Users Discussion
Sent: Friday, October 03, 2008 7:49 PM
Subject: RE: [postgis-users] about st_distance
Francisco,
ST_Distance (you can think of as min distance) return
You mean like to concatenate all the point field information in one
field in the poly. Also the below I gave was to create a new set of
data. To update a poly field by concatenating all the field information
from the points. Try something like
UPDATE table1
SET somefield = array_to_string(ARR
-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
Hi Regina,
On Oct 6, 2008, at 2:27 AM, Paragon Corporation wrote:
Dane,
Thanks for testing this out.
That sounds about right. Yah sorry I missed that bottom part of
your ST_Union. I realized that after the fact. Have you ever tried
running it against the whole dataset (I mean union th
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
Hi there,
I am writing to check how to perform SNAP and DISSOLVE function by PostGIS.
I have a point dataset table and a MultipleLineString dataset table. I need
to snap all the points in the dataset to the Line Strings when the distance
is within 100 meters.
I also need union some polygon featu
Hi John,
Regarding snapping points to lines, postgis does not have a built-in
function to do that, but this nice post gives you a good guide on how
to accomplish it: http://blog.cleverelephant.ca/2008/04/snapping-points-in-postgis.html
Regarding how to do a 'Dissolve' in postgis, I assume y
16 matches
Mail list logo