Professional Web Applications Themes

Managing locations - ASP Database

Hi All I know this is a strange request, but I currently creating an estate agent type site and I noticed on somebody else's (big company - not interested in little old me!!) that they give the user the option to see property results that are 2, 5, 10 miles, etc away from the location that I can pick. I think this is a really clever feature, but have a sneaking suspicion that this kind of effect could be re-created using some kind of internal grid reference proc rather than having to buy a 30,000 piece of post coding software. ...

  1. #1

    Default Managing locations

    Hi All

    I know this is a strange request, but I currently creating an estate agent
    type site and I noticed on somebody else's (big company - not interested in
    little old me!!) that they give the user the option to see property results
    that are 2, 5, 10 miles, etc away from the location that I can pick.

    I think this is a really clever feature, but have a sneaking suspicion that
    this kind of effect could be re-created using some kind of internal grid
    reference proc rather than having to buy a 30,000 piece of post coding
    software.

    The locations that I am using are only probably half of 1 county so its not
    as if I'm trying to map out the whole of the UK.

    Has anybody had a go at making their own internal grid ref system to get
    this sort of thing to work?

    Rgds

    Robbie





    ----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
    http://www.newsfeeds.com The #1 Newsgroup Service in the World! >100,000 Newsgroups
    ---= East/West-Coast Server Farms - Total Privacy via Encryption =---
    Astra Guest

  2. #2

    Default Re: Managing locations

    "Astra" <com> wrote in message news:0.0.1... 
    in 
    results 
    that 
    not 

    Associate latitude and longitude with each location then use a function to
    calculate the distance between any two locations.

    Try a Google search on:

    distances between latitudes longitudes

    Then look at

    Latitude/Longitude Distance Calculation
    http://jan.ucc.nau.edu/~cvm/latlongdist.html


    McKirahan Guest

  3. #3

    Default Re: Managing locations

    McKirahan wrote on 26 okt 2004 in microsoft.public.inetserver.asp.db: 
    >
    > Associate latitude and longitude with each location then use a
    > function to calculate the distance between any two locations.[/ref]

    If it is in the UK only you could use the National grid reference for each
    location and use a simple two dimensional Pytachorean a^2 + b^2 = c^2 on
    all properties that are less than the maximum in either the x or the y
    direction from your primary reference point.

    The UK National Grid is in kilometer/meter.

    --
    Evertjan.
    The Netherlands.
    (Please change the x'es to dots in my emailaddress,
    but let us keep the discussions in the newsgroup)

    Evertjan. Guest

  4. #4

    Default Re: Managing locations

    Here's one for the US, but I assume there are also databases published for
    UK post codes and lat/long calculations.
    http://www.aspfaq.com/2527

    --
    http://www.aspfaq.com/
    (Reverse address to reply.)




    "Astra" <com> wrote in message news:0.0.1... 
    in 
    results 
    that 
    not 
    News==---- 
    Newsgroups 


    Aaron Guest

Similar Threads

  1. Web Locations
    By ICTSM in forum Macromedia Shockwave
    Replies: 0
    Last Post: April 21st, 10:20 PM
  2. Specifying Grid Locations
    By starrize webforumsuser@macromedia.com in forum Macromedia Director Lingo
    Replies: 1
    Last Post: October 31st, 08:52 AM
  3. Appending at various locations.
    By MJS in forum PERL Miscellaneous
    Replies: 3
    Last Post: September 8th, 12:41 PM
  4. Appending at various locations
    By MJS in forum PERL Beginners
    Replies: 0
    Last Post: September 7th, 05:15 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139