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 =---

Re: Managing locations

"Astra" wrote in message news:417e3126_4@127.0.0.1...
> 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

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

Re: Managing locations

McKirahan wrote on 26 okt 2004 in microsoft.public.inetserver.asp.db:
>> Has anybody had a go at making their own internal grid ref system to
>> get this sort of thing to work?
>>
>> Rgds
>>
>> Robbie
>
> Associate latitude and longitude with each location then use a
> function to calculate the distance between any two locations.

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)

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" wrote in message news:417e3126_4@127.0.0.1...
> 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 =---