Re: [postgis-users] pgsql2shp revision

2010-09-12 Thread strk
On Fri, Sep 10, 2010 at 02:31:52PM +0100, Mark Cave-Ayland wrote: This appears to be a feature of SVN in that the revision number embedded in the file is the last revision that altered that particular file, and not the latest revision of the whole repository. Since we store the revision

[postgis-users] how to write the sql if i want to find a geometry's d-distance neighbors?

2010-09-12 Thread sunpeng
Hi, I've the following table,and has created the index on uid and location; CREATE TABLE points ( location geometry, //assume it's a 2-dimension point uid integer ) Now, I've a point P with uid= 12345, and want to find the neighbors which are within 20, how to write the sql?Is this right?

Re: [postgis-users] how to write the sql if i want to find a geometry's d-distance neighbors?

2010-09-12 Thread Francis Markham
Hi Sunpeng, Definitely use ST_DWithin. -Francis On 13 September 2010 06:51, sunpeng blueva...@gmail.com wrote: Hi, I've the following table,and has created the index on uid and location; CREATE TABLE points ( location geometry, //assume it's a 2-dimension point uid integer ) Now,