[postgis-users] GEOS union() error

Paul Ramsey pramsey at refractions.net
Wed Nov 7 09:34:54 PST 2007


But doing

SELECT pipes.*
FROM pipes
WHERE
ST_DWithin(pipes.the_geom, 'POINT()', 400)

is not an option?  Building a buffer to query a distance relation is  
bad practice.

P.

On 7-Nov-07, at 6:13 AM, Lee Keel wrote:

>> -----Original Message-----
>> From: postgis-users-bounces at postgis.refractions.net  
>> [mailto:postgis-users-
>> bounces at postgis.refractions.net] On Behalf Of Paul Ramsey
>> Sent: Tuesday, November 06, 2007 4:55 PM
>> To: PostGIS Users Discussion
>> Subject: Re: [postgis-users] GEOS union() error
>>
>> Lee, what are you going to do with this beast once you have  
>> created it?
>> P
>>
>> On 6-Nov-07, at 10:41 AM, Lee Keel wrote:
>>
>
>
> Paul,
>
> My client needs this information to generate a shape file for "call  
> before
> you dig" information.  They are a gas company and they have to  
> output this
> information all the time, the problem for them is that it is  
> becoming a full
> time job to take a shape file, open it in Arcmap, do the buffering,
> reproject the data and then save.  I told them that this could all  
> be done
> in one query in the spatial database that we were using.  But  
> obviously, I
> have run into some snags.
>
> Also, to combine chains...  I did not use collect on the geometries  
> column
> and pass that to buffer because it is very explicit in the online  
> help not
> to pass GeometryCollection as argument to buffer.
>
> Thanks for the responses.  I look forward to any more helpful ideas.
> Lee
> This email and any files transmitted with it are confidential and  
> intended solely for the use of the individual or entity to whom  
> they are addressed. If you have received this email in error please  
> notify the sender. This message contains confidential information  
> and is intended only for the individual named. If you are not the  
> named addressee you should not disseminate, distribute or copy this  
> e-mail.
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users




More information about the postgis-users mailing list