Looking for a source for data and/or algorithm that would allow me to enter
a zipcode and find - in our case - every car dealership that sells, say,
Chevy's in that zipcode - if not there, then what about adjacent
zipcodes..? - in an ever expanding circle outward, and return a list of
those zipcodes.
In my database, I've already got the car dealers and available makes. What
I need is the zipcode "map" reference. Ideas, sources?
- Wm
--
William Morris
Product Development, Seritas LLC
Kansas City, Missouri 8 1466
If you've already got the info in the database, then all you need to do is
select from it, based on certain parameters. For example;
strManufacterer = "Ferrari"
strModel = "F50"
strZipCode = "119911"
rst.Open "Select Model From tblCars Where Zip = '" & strZipCode _
& "' and Manufacterer = '" & strManufacterer & "' and model =
'" & _
strModel & "'", DB, adOpenStatic, adLockPessimistic
--
Regards
Steven Burn
Ur I.T. Mate Group www.it-mate.co.uk
Keeping it FREE!
"William Morris" <ne***************************@seamlyne.com> wrote in
message news:2i************@uni-berlin.de... Looking for a source for data and/or algorithm that would allow me to
enter a zipcode and find - in our case - every car dealership that sells, say, Chevy's in that zipcode - if not there, then what about adjacent zipcodes..? - in an ever expanding circle outward, and return a list of those zipcodes.
In my database, I've already got the car dealers and available makes.
What I need is the zipcode "map" reference. Ideas, sources?
- Wm
-- William Morris Product Development, Seritas LLC Kansas City, Missouri
You will need a zip code -> lat / long database. You can find some free
ones out there, but the quality isn't very good (you get what you pay for).
There is a mathematical formula that will tell you the distance between two
points, given the lat/long of each. So, you take the dealer's zip code,
find the lat and long, then you have a function or procedure that finds all
the zip codes where (formula) < 5 miles.
-- http://www.aspfaq.com/
(Reverse address to reply.)
"William Morris" <ne***************************@seamlyne.com> wrote in
message news:2i************@uni-berlin.de... Looking for a source for data and/or algorithm that would allow me to enter a zipcode and find - in our case - every car dealership that sells, say, Chevy's in that zipcode - if not there, then what about adjacent zipcodes..? - in an ever expanding circle outward, and return a list of those zipcodes.
In my database, I've already got the car dealers and available makes. What I need is the zipcode "map" reference. Ideas, sources?
- Wm
-- William Morris Product Development, Seritas LLC Kansas City, Missouri
Precisely what I was looking for. Thank you, Aaron. I don't suppose you
have any links handy, or the formula?
- Wm
--
William Morris
Product Development, Seritas LLC
Kansas City, Missouri
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:uM**************@TK2MSFTNGP12.phx.gbl... You will need a zip code -> lat / long database. You can find some free ones out there, but the quality isn't very good (you get what you pay
for). There is a mathematical formula that will tell you the distance between
two points, given the lat/long of each. So, you take the dealer's zip code, find the lat and long, then you have a function or procedure that finds
all the zip codes where (formula) < 5 miles.
-- http://www.aspfaq.com/ (Reverse address to reply.)
"William Morris" <ne***************************@seamlyne.com> wrote in message news:2i************@uni-berlin.de... Looking for a source for data and/or algorithm that would allow me to enter a zipcode and find - in our case - every car dealership that sells, say, Chevy's in that zipcode - if not there, then what about adjacent zipcodes..? - in an ever expanding circle outward, and return a list of those zipcodes.
In my database, I've already got the car dealers and available makes. What I need is the zipcode "map" reference. Ideas, sources?
- Wm
-- William Morris Product Development, Seritas LLC Kansas City, Missouri
http://www.mathforum.com/library/drmath/view/51711.html
Pretty simple explanation, looks right.
James
"William Morris" <ne***************************@seamlyne.com> wrote in
message news:2i************@uni-berlin.de... Precisely what I was looking for. Thank you, Aaron. I don't suppose you have any links handy, or the formula?
- Wm
-- William Morris Product Development, Seritas LLC Kansas City, Missouri
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message news:uM**************@TK2MSFTNGP12.phx.gbl... You will need a zip code -> lat / long database. You can find some free ones out there, but the quality isn't very good (you get what you pay for). There is a mathematical formula that will tell you the distance between two points, given the lat/long of each. So, you take the dealer's zip code, find the lat and long, then you have a function or procedure that finds all the zip codes where (formula) < 5 miles.
-- http://www.aspfaq.com/ (Reverse address to reply.)
"William Morris" <ne***************************@seamlyne.com> wrote in message news:2i************@uni-berlin.de... Looking for a source for data and/or algorithm that would allow me to enter a zipcode and find - in our case - every car dealership that sells,
say, Chevy's in that zipcode - if not there, then what about adjacent zipcodes..? - in an ever expanding circle outward, and return a list
of those zipcodes.
In my database, I've already got the car dealers and available makes. What I need is the zipcode "map" reference. Ideas, sources?
- Wm
-- William Morris Product Development, Seritas LLC Kansas City, Missouri
For the database: http://www.google.com/search?hl=en&i...itude+database
For the formula: http://groups.google.com/groups?hl=e...tude+longitude
I'm about to write an article about this, but the solution will use SQL
Server. If you're using SQL Server, and can wait for a bit, you might want
to wait for a bit.
-- http://www.aspfaq.com/
(Reverse address to reply.)
"William Morris" <ne***************************@seamlyne.com> wrote in
message news:2i************@uni-berlin.de... Precisely what I was looking for. Thank you, Aaron. I don't suppose you have any links handy, or the formula?
- Wm
-- William Morris Product Development, Seritas LLC Kansas City, Missouri
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message news:uM**************@TK2MSFTNGP12.phx.gbl... You will need a zip code -> lat / long database. You can find some free ones out there, but the quality isn't very good (you get what you pay for). There is a mathematical formula that will tell you the distance between two points, given the lat/long of each. So, you take the dealer's zip code, find the lat and long, then you have a function or procedure that finds all the zip codes where (formula) < 5 miles.
-- http://www.aspfaq.com/ (Reverse address to reply.)
"William Morris" <ne***************************@seamlyne.com> wrote in message news:2i************@uni-berlin.de... Looking for a source for data and/or algorithm that would allow me to enter a zipcode and find - in our case - every car dealership that sells,
say, Chevy's in that zipcode - if not there, then what about adjacent zipcodes..? - in an ever expanding circle outward, and return a list
of those zipcodes.
In my database, I've already got the car dealers and available makes. What I need is the zipcode "map" reference. Ideas, sources?
- Wm
-- William Morris Product Development, Seritas LLC Kansas City, Missouri
Actually, we are using SQL Server. The links are great, too. Our list is
small enough at this point that listing every dealer on one page is a
perfectly acceptable solution for the next few months, so, yeah, it can
wait. This'll give me something I can take to the next planning meeting and
hopefully buy myself some time.
- Wm
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message
news:eC*************@TK2MSFTNGP12.phx.gbl... For the database: http://www.google.com/search?hl=en&i...itude+database For the formula: http://groups.google.com/groups?hl=e...tude+longitude I'm about to write an article about this, but the solution will use SQL Server. If you're using SQL Server, and can wait for a bit, you might
want to wait for a bit.
-- http://www.aspfaq.com/ (Reverse address to reply.)
"William Morris" <ne***************************@seamlyne.com> wrote in message news:2i************@uni-berlin.de... Precisely what I was looking for. Thank you, Aaron. I don't suppose
you have any links handy, or the formula?
- Wm
-- William Morris Product Development, Seritas LLC Kansas City, Missouri
"Aaron [SQL Server MVP]" <te*****@dnartreb.noraa> wrote in message news:uM**************@TK2MSFTNGP12.phx.gbl... You will need a zip code -> lat / long database. You can find some
free ones out there, but the quality isn't very good (you get what you pay for). There is a mathematical formula that will tell you the distance
between two points, given the lat/long of each. So, you take the dealer's zip
code, find the lat and long, then you have a function or procedure that
finds all the zip codes where (formula) < 5 miles.
-- http://www.aspfaq.com/ (Reverse address to reply.)
"William Morris" <ne***************************@seamlyne.com> wrote in message news:2i************@uni-berlin.de... > Looking for a source for data and/or algorithm that would allow me
to > enter > a zipcode and find - in our case - every car dealership that sells, say, > Chevy's in that zipcode - if not there, then what about adjacent > zipcodes..? - in an ever expanding circle outward, and return a list of > those zipcodes. > > In my database, I've already got the car dealers and available
makes. > What > I need is the zipcode "map" reference. Ideas, sources? > > - Wm > > -- > William Morris > Product Development, Seritas LLC > Kansas City, Missouri > >
FYI, "about to" in this specific case means either tonight (time permitting)
or early next week. I had already worked on a similar solution for a
client, and adapting that work slightly will make for a good, workable
example that can be used for similar scenarios.
For future reference, my "about to" has various meanings, given context,
mood, schedule, and level of effort. ;-)
-- http://www.aspfaq.com/
(Reverse address to reply.)
"William Morris" <ne***************************@seamlyne.com> wrote in
message news:2i************@uni-berlin.de... Actually, we are using SQL Server. The links are great, too. Our list is small enough at this point that listing every dealer on one page is a perfectly acceptable solution for the next few months, so, yeah, it can wait. This'll give me something I can take to the next planning meeting
and hopefully buy myself some time.
- Wm This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jerry Asher |
last post by:
I would like to map from GPS coordinates to US Zipcode for US
Continental based needs.
(Yes, I am excluding perhaps Hawaii and Alaska for now, and I am also
assuming that a simple 2D geometry,...
|
by: Jamie Burns |
last post by:
Hello,
I am writing a search engine that uses mysql to keep a word index. I have
just added the "position" of each word, in relation to the document it is
in.
My table thus is as follows:
...
|
by: Sean |
last post by:
Hi there I am new to this and would like to know how to input a
postcode/Zipcode I know it goes something like this 00000\-9999 or LL0\-LL3
so this codes will cover numbers as zipcode like this...
|
by: premgrps |
last post by:
Hi,
I have a database with two tables
a) A table of 2 million records with city, zip and associated
information (say XYZ) and
b) zipcode latitude, longitude table having >40,000 records/zip...
|
by: Tina |
last post by:
I need to be able to provide a proximity search by zip code. I have a table
of job opportunities with the zip code where they exist. So I need to be
able to list zip codes that are within xx...
|
by: mfitzgerald |
last post by:
Hi, I've got a table of Sale Reps (ID, Name, Address, City, State, Zipcode, etct). I'm trying to create a stored proc that will accept a ZipCode and search for Reps with that ZipCode. If there isn't...
|
by: shyaminf |
last post by:
I need to monitor the proximity of a system in a network from another system in the same network. i.e., i want to know the distance between two systems. Can anyone please help me by giving the code...
|
by: paidblow |
last post by:
Hi everyone,
I am working on a project that involves proximity marketing with Bluetooth, I have been looking for similar solutions on the internet, so far almost all of them offer a dedicated...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |