Coldfusion Zip Code Store Locator
Any body have any good suggestions for a coldfusion zip code store locator. I haven't been able to find a good one that I like. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254290 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Zip Code Store Locator
Are you looking for a Postal Code Database, or a fully formed program for doing radius searches based on zip code? -- Alan Rother Macromedia Certified Advanced ColdFusion MX 7 Developer ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254291 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Coldfusion Zip Code Store Locator
My co-worker found one she really likes, but it is ASP. Would that help? -Original Message- From: jason speidel [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 26, 2006 3:40 PM To: CF-Talk Subject: Coldfusion Zip Code Store Locator Any body have any good suggestions for a coldfusion zip code store locator. I haven't been able to find a good one that I like. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254298 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion Zip Code Store Locator
We bought one of these: http://www.zipcodedownload.com/Products/Product/Z5Commercial/Standard/Overvi ew/ as the database, and they provide longitude and latitude for each zip code. Having that it's trivial to get a distance function somewhere (we have one in sql server). Is that what you're looking for? Russ -Original Message- From: Ray Champagne [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 26, 2006 4:27 PM To: CF-Talk Subject: RE: Coldfusion Zip Code Store Locator My co-worker found one she really likes, but it is ASP. Would that help? -Original Message- From: jason speidel [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 26, 2006 3:40 PM To: CF-Talk Subject: Coldfusion Zip Code Store Locator Any body have any good suggestions for a coldfusion zip code store locator. I haven't been able to find a good one that I like. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254299 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Coldfusion Zip Code Store Locator
I bought this one, which is a few bucks cheaper: http://zipcodeworld.com/zipcodepremium.htm Has lats and lons. I wrote a radius program and posted it on the dev exchange. You can wind up eating a lot of processor cycles with this stuff and ZipMonger was written in such a way as to reduce execution times pretty dramatically. Also was made to work with any db you care to plug into it. But thats still not a whole locator system. Just the core to let you build your own. http://mysecretbase.com/zipmonger_home.cfm -- [EMAIL PROTECTED] Janitor, MSB Web Systems mysecretbase.com ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254300 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Re: Coldfusion Zip Code Store Locator
i just did one www.rossreelsworldwide.com/dealers/dealers_usa.cfm What you do depends on how accurate you want it to be. If you just get a db of zipcodes, lat lon and add the formula it wont be very accurate. Since the lat lon is based upon the center of the zipcode and zipcodes and be quite large (30-50 miles across sometimes). So if the user is in one corner of his zipcode and the store is in the opposite corner of its zipcode and they are ajoining zipcodes they could be lets say 70 miles apart but your dealor locator will say its about 15 miles, which is just a bit off. To really do it even somewhat accurately you nned to get the actual lat and lon of at least the dealers address. Thats what i did, so mines still a bit off but they didnt want to ask the users for their actual address to get an exact distance. what i did was have it send a request to google with the address (cfhttp) an parse the results to get lat lon and update the dealers table to give the correct location lat lon then I was also able to use that to get a accurate google map as well. However, if the address in not normal it will have a hard time getting correct location, ex: google will puke on an address like 123 sw That st building 4 suite 44. I havent implemented this yet but to counter that we are implementing a 2nd dealer address that we will use for geocoding so we'd make that address 123 sw that st and it will work fine. Any body have any good suggestions for a coldfusion zip code store locator. I haven't been able to find a good one that I like. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254309 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Coldfusion Zip Code Store Locator
Minus the www -Original Message- From: Dave Lyons [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 26, 2006 5:36 PM To: CF-Talk Subject: Re: Coldfusion Zip Code Store Locator i just did one www.rossreelsworldwide.com/dealers/dealers_usa.cfm What you do depends on how accurate you want it to be. If you just get a db of zipcodes, lat lon and add the formula it wont be very accurate. Since the lat lon is based upon the center of the zipcode and zipcodes and be quite large (30-50 miles across sometimes). So if the user is in one corner of his zipcode and the store is in the opposite corner of its zipcode and they are ajoining zipcodes they could be lets say 70 miles apart but your dealor locator will say its about 15 miles, which is just a bit off. To really do it even somewhat accurately you nned to get the actual lat and lon of at least the dealers address. Thats what i did, so mines still a bit off but they didnt want to ask the users for their actual address to get an exact distance. what i did was have it send a request to google with the address (cfhttp) an parse the results to get lat lon and update the dealers table to give the correct location lat lon then I was also able to use that to get a accurate google map as well. However, if the address in not normal it will have a hard time getting correct location, ex: google will puke on an address like 123 sw That st building 4 suite 44. I havent implemented this yet but to counter that we are implementing a 2nd dealer address that we will use for geocoding so we'd make that address 123 sw that st and it will work fine. Any body have any good suggestions for a coldfusion zip code store locator. I haven't been able to find a good one that I like. ~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254314 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
