| |
by: Xenophobe |
last post by:
I have successfully created a zip code radius search, but the performance is
unacceptable.
I have two tables. The first is 52K zip codes w/lat and long. The second is
3K national business addresses.
Using the zip code 10010, it takes almost 60 seconds to return 122
businesses within a 25 mile radius. This slowdown is almost entirely due to
the query radius distance formula.
|
by: 321ConTact |
last post by:
I have to find zipcodes within a given mileage range (25, 50, etc). I know
it's possible to use the longitude/latitude to find this, and I have that
for the zipcodes, but does anyone have a "ready made" formula? I know it has
something to do with the sine/cosine, but the "signs" aren't clear enough to
me (neither are the wonders).
Thanks in advance for the wisdom.
J
|
by: Galsaba |
last post by:
I am trying to find a script to a "dealer locator" or "find a store near you".
I will have two tables. One will include all US and Canada ZIPs including lat
and longtitudes. The other one is a table of our dealers (or store) including
thier ZIP codes.
When the user enters his ZIP code, the application needs to check (based on the
lat and long) if there is a dealer in a 30 miles radious.
After the application finds the list of all the...
|
by: Galsaba |
last post by:
anyone knows what the formula is for finding a distance betweeen 2 zip codes?
Aaron
|
by: csumner |
last post by:
I am trying to use the haversine function to find the distance between
two points on a sphere, specifically two zip codes in my database. I'm
neither horribly familiar with SQL syntax nor math equations :), so I
was hoping I could get some help. Below is what I'm using and it is,
as best as I can figure, the correct formula. It is not however,
giving me correct results. Some are close, others don't seem right at
all. Any ideas?
SET...
|
| |
by: Dave \IT\ |
last post by:
I'm looking to find out how I'd go about setting up a database where a
visitor to my site could punch in their postal code, and find out how far
they are from another postal code. For example, AutoTrader has this feature
I believe to tell you how far the vehicle is from you. Dating sites have
them so you can do proximity searches.
Anyone have any ideas where I could start? I'm thinking the post office,
but if anyone else has...
|
by: Joe |
last post by:
I need an Access application that can search dealers from my dealer
list, in a 30 miles distance from the user.
You may see many applications like this on the web if you search under
"find a dealer near you". Here is one I found:
http://www.shakespeare-antennas.com/content/dealersearch.asp
But I do not want to have it on the web, I want to create it on
access.
I think will need at least two tables:
|
by: Samuel Shulman |
last post by:
Hi
I need to measure the distance using 2 postcodes (UK)
How can that be done?
Thank you,
Samuel
|
by: Harch84 |
last post by:
Hi guys really hoping someone can advise me with this.
I have a Perl script that connect to a PostgreSQL database and retrieves fields and rows from a database of bus timetables and bus stop information. The data I am extracting is the reference number of the bus stop, the route number this bus stop serves and the distance of a point to this bus stop. The select query returns rows like this in PostgreSQL:
stop_reference | service_id | ...
|
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
| |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
|
