<html>
<head>
<title></title>
<meta name="GENERATOR" content="MSHTML 8.00.6001.18975"></meta>
</head>
<body>
<div align="left">Yes, sorry</div>
<div align="left"> </div>
<div align="left">Should have been</div>
<div align="left"> </div>
<div align="left">select gid, the_geom, floorarea from "building" as m where ST_DWithin(m.geom,'POINT<span style="FONT-FAMILY: 'Courier New'">(306404701 6755737)'::geometry, 200.0</span>);<br />
<br />
/</div>
<div align="left">Nicklas</div>
<div align="left"> </div>
<div align="left"><br />
2010-10-19 zhang zhe wrote:<br />
<br />
Hello,<br />
> <br />
> Thanks. I try to run your query, and it saids<br />
> parse error-invalid geometry. point (306404701,...)<br />
> <br />
> do you know where went wrong? <br />
> <br />
> Thanks<br />
> <br />
></div>
<hr />
Date: Tue, 19 Oct 2010 12:53:22 +0200<br />
>From: nicklas.aven@jordogskog.no<br />
>To: postgis-users@postgis.refractions.net<br />
>CC: <br />
>Subject: Re: [postgis-users] How to select points within circle<br />
><br />
>>
<div align="left">Your syntax is a little backwards an it is better to use st_dwithin instead:</div>>
<div align="left"> </div>>
<div align="left">select gid, the_geom, floorarea from "building" as m where ST_DWithin(m.geom,'POINT<span style="FONT-FAMILY: 'Courier New'">(306404701,6755737)'::geometry, 200.0</span>);<br />
></div>>
<div align="left">HTH</div>>
<div align="left">Nicklas<br />
><br />
>2010-10-19 zhang zhe wrote:<br />
><br />
>Hello,<br />
>> <br />
>> I have one table called building.sql which contains points. I want to select building which fall within a circle. This circle is not a sql table but instead only coordinate and radius such as <span style="FONT-FAMILY: 'Courier New'">circle(point '(0,0)', 2.0)</span>. <br />
>> <br />
>> My sql query is like this <br />
>> select gid, the_geom, floorarea from "building" as m where m.geom within(GeoFromText(<span style="FONT-FAMILY: 'Courier New'">circle(point '(306404701,6755737)', 200.0))</span>);<br />
>> <br />
>> But it gives me erro. Does anyone knows where went wrong? <br />
>> <br />
>> Thanks a lot<br />
>> <br />
>> </div><br />
>_______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
</body>
</html>