[Rets-dev] Radius Search

[Jozsef Nagy]

That'd be great, since this functionality is used a lot for property searches. Property Valuator Models (AVM) heavily depend on this radius functionality. We will use the rectengular method queries you suggested to first download the data and then locally do the radius filter on that dataset.
   
  The way we currently do a Radius Search using the ANSI SQL language against a SQL database is exactly how you described above: first filter out the properties that fell outside the bounderies of a rectangle drawn around the source property (using longitute and latitude coordinates); then we filter further more with a mathematical radius function run against each neighboring property in the rectangle to see if its x,y coordinates (long/lat) are within the bounderies of the perimiter of a circle drawn with that radius.  This method at least gives us a starting point and allow us to run fast radius searches.
   
  Thank you.
   
  - jozsef

Sergio Del Rio <Sergio.Del.Rio at t4bi.com> wrote:
        v\:* {behavior:url(#default#VML);}  o\:* {behavior:url(#default#VML);}  w\:* {behavior:url(#default#VML);}  .shape {behavior:url(#default#VML);}        st1\:*{behavior:url(#default#ieooui) }                There is no Radius search currently defined in DMQL2.  You could only formulate a rectangular query using both Latitude and Longitude at this time.
   
  However, at MRIS we are looking at implementing this by adding an extension to DMQL2 something like
   
  RADIUS(Latitude,Longitude,Length)
   
  Once we verify that we can make this work well within the DMQL2 syntax, we plan on publishing this as a change request.
   
    Regards,
  Sergio Del Rio
  Templates 4 Business Inc.

   
      
---------------------------------
  
  From: rets-dev-bounces at rets.org [mailto:rets-dev-bounces at rets.org] On Behalf Of Jozsef Nagy
Sent: February 1, 2007 10:36 AM
To: Paul Stusiak
Cc: rets-dev at rets.org
Subject: [Rets-dev] Radius Search

   
    Paul -

     

    In DMQL2, Can I search for properties within a certain radius (using e.g. properties long/lat)? 

     

    Thank you.

     

    - jozsef

Paul Stusiak <pstusiak at falcontechnologies.com> wrote:

    See section 7.7.3 of the 1.7 specification.

(LP=200000-350000)

List price between 200,000 and 350,000 inclusive.

Section 7.7.2, Query parameter interpretation has a word definition of 
it and section 7.7.1 has the BNF definition for the "range" atom.

In your specific case, the MLS number may be a range, but it could also 
be a string list depending on how it is defined in the system under 
question. Check the metadata to determine what the mls number data type 
is. Range list is defined for both number and string so it should work 
in either case.

Paul

Gary Miller wrote:
>
> Does DMQL2 support a “between” style of a query based on a string. For 
> instance I want all MLS numbers between “100” and “120”. Does DMQL2 
> support that type of query? If so what would it look like?
>
> Thanks.
>
> Gary Miller
>
> Lucero Research
>
> gary.miller at lucero.com
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Rets-dev mailing list
> Rets-dev at rets.org
> http://lists.rets.org/mailman/listinfo/rets-dev
> 
_______________________________________________
Rets-dev mailing list
Rets-dev at rets.org
http://lists.rets.org/mailman/listinfo/rets-dev
   
    
    
---------------------------------
  
  8:00? 8:25? 8:40? Find a flick in no time
with theYahoo! Search movie showtime shortcut.



 
---------------------------------
The fish are biting.
 Get more visitors on your site using Yahoo! Search Marketing.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.rets.org/pipermail/rets-dev/attachments/20070201/a9340fbf/attachment.html