Re: Dealer locator
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 22004
interpreted = N
texte = My first though would be to create a table, sort of like you see on road maps, where they have the cities listed against each other with the distances between, like so:City Dallas, TX Houston, TX Dallas, TX 0 350 Houston, TX 350 0You could create a database like this:HomeCity NearCity Distance Dallas Houston 350 Dallas San Antonio 300 Dallas Fort Worthetc., only including those cities that would fit the search parameters (i.e if your distance choices are 10, 50, 100, 200 miles, you don't need to include Anchorage, Alaska in the Dallas section)Then search on it like so:[search db=cities.db&eqHomeCitydata=[YourCity]&leDistancedata=[DistancefromYou]] [founditems] [search db=dealers.db&eqCitydata=[NearCity]] [founditems] [dealer], [city], [state], etc. [/founditems] [/search] [/founditems] [/search]The only downside I can see to this is the time for db creation, but the distance information is available for most major cities (and I'm sure you could find it for most cities, or possibly restrict them from choosing a city or town with no dealers in it, so they would just choose the nearest city with a dealer as their location).Hope this helps, Johnjosh@pop-art.com wrote: > > We have been asked to create a Dealer Locator system for a client. So > far there are approx. 6,000 dealers nationwide with many more to come. > > Has anyone done something similar? It would seem obvious that you could > simply enter a city/state, but that would eliminate nearby dealers if they > were across a boarder? > > Zip codes would seem logical if there was some sort of tabel that said wich > zip codes were near to each other, although this would not be that usefull > if you were dealing with a very wide area zip code. > > A map engine similar to Yahoo Maps would seem like the most sophisticated > way to compare addresses and then display all records within a 50 mile > radius. Are there any software packages that do this, obiviously WebCat > would not be able to do this on its own. > > If anyone has any suggestions or has done something similar we, would > appreciate the advice. > > Thanks, > > Josh > --------------------------------------------------------------------------- > Joshua Blank Pop Art LLC http://pop-art.com > josh@pop-art.com eCommerce / Web Design / Multimedia > > 7000 SW Hampton St. tel: (503) 968.5957 > Suite 124 fax: (503) 620.8487 > Portland, OR 97223-8361
Associated Messages, from the most recent to the oldest:
My first though would be to create a table, sort of like you see on road maps, where they have the cities listed against each other with the distances between, like so:City Dallas, TX Houston, TX Dallas, TX 0 350 Houston, TX 350 0You could create a database like this:HomeCity NearCity Distance Dallas Houston 350 Dallas San Antonio 300 Dallas Fort Worthetc., only including those cities that would fit the search parameters (i.e if your distance choices are 10, 50, 100, 200 miles, you don't need to include Anchorage, Alaska in the Dallas section)Then search on it like so:[search db=cities.db&eqHomeCitydata=[YourCity]&leDistancedata=[DistancefromYou]]
[founditems] [search db=dealers.db&eqCitydata=[NearCity]]
[founditems] [dealer], [city], [state], etc. [/founditems] [/search] [/founditems] [/search]The only downside I can see to this is the time for db creation, but the distance information is available for most major cities (and I'm sure you could find it for most cities, or possibly restrict them from choosing a city or town with no dealers in it, so they would just choose the nearest city with a dealer as their location).Hope this helps, Johnjosh@pop-art.com wrote: > > We have been asked to create a Dealer Locator system for a client. So > far there are approx. 6,000 dealers nationwide with many more to come. > > Has anyone done something similar? It would seem obvious that you could > simply enter a city/state, but that would eliminate nearby dealers if they > were across a boarder? > > Zip codes would seem logical if there was some sort of tabel that said wich > zip codes were near to each other, although this would not be that usefull > if you were dealing with a very wide area zip code. > > A map engine similar to Yahoo Maps would seem like the most sophisticated > way to compare addresses and then display all records within a 50 mile > radius. Are there any software packages that do this, obiviously WebCat > would not be able to do this on its own. > > If anyone has any suggestions or has done something similar we, would > appreciate the advice. > > Thanks, > > Josh > --------------------------------------------------------------------------- > Joshua Blank Pop Art LLC http://pop-art.com > josh@pop-art.com eCommerce / Web Design / Multimedia > > 7000 SW Hampton St. tel: (503) 968.5957 > Suite 124 fax: (503) 620.8487 > Portland, OR 97223-8361
John W
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
Online reference (1997)
searchable list archive (1997)
HideIf ip= OR ip= (1998)
Webmerchant (1999)
WebCat2: multiple currency support (1997)
Navigator 4.01 (1997)
[WebDNA] BBEdit Codeless Language Module for WebDNA (2009)
Updating database (1998)
My slower response (1997)
View order not right (1997)
Cleaning up all the shopping carts (2000)
nesting limits? (1998)
WebCat2 beta 11 - new prefs ... (1997)
upgrading (1997)
Bit off subject -- Faxing orders (1997)
HTML Editors (1997)
Nesting format tags (1997)
Server crash (1997)
Running _every_ page through WebCat-error.html (1997)
HTML editing and webcatalog (2000)