Hello -
I need either a cheap tool or code & DB that calculates, eg. within 50-mile
radius of a zip code.
Anyone have any suggestions?
--
Sandy 9 3445
> I need either a cheap tool or code & DB that calculates, eg. within 50-mile radius of a zip code.
I don't remember what the title of the thread was, but several months ago,
someone in microsoft.publi c.sqlserver.pro gramming posted a SQL Server table
and a stored procedure that does exactly that. If you repost your question
there, you might get a couple excellent answers.
--
Peace & happy computing,
Mike Labosh, MCSD
"Mr. McKittrick, after very careful consideration, I have
come to the conclusion that this new system SUCKS."
-- General Barringer, "War Games"
"Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message
news:F0******** *************** ***********@mic rosoft.com... Hello -
I need either a cheap tool or code & DB that calculates, eg. within
50-mile radius of a zip code.
Anyone have any suggestions? -- Sandy
That calculates what specifically?
Tell you whether a specific location is within 50 miles of a zip code?
Are we talking coordinates, addresses, what?
When you say within 50 miles of a zip code, you mean the actual boundary,
one of the centroids, the PO itself?
Sorry, I might be overthinking this as I do all kinds of stuff like this.
If you can clearly define what you have and what you need I might be able to
point you in the right direction.
Gerald
Gerald -
Thanks for your response. Specifically, I need to be able to have someone
enter a zip code OR city and state and be able to find out whether there is a
listing in my DB which has businesses listed with zip codes, cities and
states within a radius of 50 miles, 100 miles, etc. (The user can indicate
what radius they want.)
This is similar to store locators on websites where you can enter a zip code
and find a store within your vicinity. They have a dropdownlist indicating
whether you want "100 miles," "50 miles," "20 miles," etc.
Any help will be greatly appreciated!
--
Sandy
"Gerald Hernandez" wrote: "Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message news:F0******** *************** ***********@mic rosoft.com... Hello -
I need either a cheap tool or code & DB that calculates, eg. within 50-mile radius of a zip code.
Anyone have any suggestions? -- Sandy
That calculates what specifically? Tell you whether a specific location is within 50 miles of a zip code? Are we talking coordinates, addresses, what? When you say within 50 miles of a zip code, you mean the actual boundary, one of the centroids, the PO itself? Sorry, I might be overthinking this as I do all kinds of stuff like this. If you can clearly define what you have and what you need I might be able to point you in the right direction.
Gerald
Sandy,
One of the key elements to this is getting a known locations for both the
search point and the business locations. This is usually accomplished via a
geocode, find the location for a particular address. This is easy enough for
your business addresses as they are known. A little more difficult is for
your starting search point.
If only using ZIP code, it is not very complicated. In most cases, they just
use the centroid of the zip code, which can be defined in numerous ways but
usually the center of mass or the center of distribution/population. Then
compare that to the known location of the businesses. There is oftentimes
much pre-computation of certain parameters, such as assigning an average
value for the "radius" of a ZIP code. Plus, it's important to note that ZIP
code areas can be disjoint, meaning you can have multiple areas with the
same ZIP code with other ZIP codes in between.
City is a little more difficult. There are numerous Towns and/or Cities that
are not incorporated. As such, they don't usually have clearly defined or
maintained boundary information. For these they do a cross reference to
postal delivery names. Basically mapping "city" names to encompassing ZIP
codes, then use the above ZIP code method for location.
The above methods are quite inaccurate, but if you are just looking for
something like the store locator example, then it works well enough. If you
are needing something more complex, like routing, point to point directions,
or analysis that requires accuracy, then it is far from sufficient.
In a nutshell, you will need to determine the location of the businesses,
probably via a geocode and store that in your database. You will probably
then want to get your hands on ZIP code data and store the centroids,
bounding box area, and calculate an averaged radius size. You will also need
to cross reference the "city" names to postal delivery names and therefore
ZIP codes. There are a number of companies that can provide the needed data.
TIGER has much of it, and you might start there. It is usually free, but can
take a fair amount of work to get it into a usable form. Other companies
have already done much of the hard work for you and also reference other
datasets, but these can be quite expensive. My recommendation my be to get
your hands on MapPoint. It is relatively cheap and comes pre-packaged with
the data you need, and also provides methods to help you along.
Once you have all that information available, the query isn't terribly
difficult, well relatively speaking.
Based on your search criteria, you build a search Range / Bounding Box. Then
initially query out a subset of records using that. This will give you a
list of records that "could" meet your criteria.
Then from that dataset, you iterate through each record performing a
distance calculation to see if it actually falls within the desired radius;
keeping the ones you need and discarding the rest. If you choose to keep
your data in Lat/Lon instead of projecting coordinates to a Cartesian
coordinate system, then you will probably want to use a math library
designed to work with Lat/Lon to calculate distance. Again, MapPoint can do
this, of course there are numerous others as well. I haven't examined too
many of the "free" ones, so I can't offer a suggestion there other than to
be careful. Some of the free ones I've seen have flawed math and can give
you quite inaccurate results, especially in the northern half of the US.
I know that didn't really answer your question or provide you a solution,
but hopefully it will help you along.
Gerald
"Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message
news:71******** *************** ***********@mic rosoft.com... Gerald -
Thanks for your response. Specifically, I need to be able to have someone enter a zip code OR city and state and be able to find out whether there
is a listing in my DB which has businesses listed with zip codes, cities and states within a radius of 50 miles, 100 miles, etc. (The user can
indicate what radius they want.)
This is similar to store locators on websites where you can enter a zip
code and find a store within your vicinity. They have a dropdownlist
indicating whether you want "100 miles," "50 miles," "20 miles," etc.
Any help will be greatly appreciated!
-- Sandy
"Gerald Hernandez" wrote:
"Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message news:F0******** *************** ***********@mic rosoft.com... Hello -
I need either a cheap tool or code & DB that calculates, eg. within 50-mile radius of a zip code.
Anyone have any suggestions? -- Sandy
That calculates what specifically? Tell you whether a specific location is within 50 miles of a zip code? Are we talking coordinates, addresses, what? When you say within 50 miles of a zip code, you mean the actual
boundary, one of the centroids, the PO itself? Sorry, I might be overthinking this as I do all kinds of stuff like
this. If you can clearly define what you have and what you need I might be
able to point you in the right direction.
Gerald
Thanks for your reply, Gerald. It seems I may have found a solution suitable
to my current needs from: http://www.aspfaq.com/show.asp?id=2527
I think I have the stored procedure working, although I still need to test
it some more. I also have to build in the capabilities to use city as a
parameter. Currently it only does zip codes. I tried to plug it into my
aspx page, though, and haven't been able to get it to work correctly yet . .
.. probably something stupid I'm doing.
I briefly glanced at MapPoint and to be perfectly honest, I got aggravated
with the fact that I couldn't find the price, so I gave up. What do you mean
by "relatively cheap," and where do they list a price?
--
Sandy
"Gerald Hernandez" wrote: Sandy,
One of the key elements to this is getting a known locations for both the search point and the business locations. This is usually accomplished via a geocode, find the location for a particular address. This is easy enough for your business addresses as they are known. A little more difficult is for your starting search point.
If only using ZIP code, it is not very complicated. In most cases, they just use the centroid of the zip code, which can be defined in numerous ways but usually the center of mass or the center of distribution/population. Then compare that to the known location of the businesses. There is oftentimes much pre-computation of certain parameters, such as assigning an average value for the "radius" of a ZIP code. Plus, it's important to note that ZIP code areas can be disjoint, meaning you can have multiple areas with the same ZIP code with other ZIP codes in between.
City is a little more difficult. There are numerous Towns and/or Cities that are not incorporated. As such, they don't usually have clearly defined or maintained boundary information. For these they do a cross reference to postal delivery names. Basically mapping "city" names to encompassing ZIP codes, then use the above ZIP code method for location.
The above methods are quite inaccurate, but if you are just looking for something like the store locator example, then it works well enough. If you are needing something more complex, like routing, point to point directions, or analysis that requires accuracy, then it is far from sufficient.
In a nutshell, you will need to determine the location of the businesses, probably via a geocode and store that in your database. You will probably then want to get your hands on ZIP code data and store the centroids, bounding box area, and calculate an averaged radius size. You will also need to cross reference the "city" names to postal delivery names and therefore ZIP codes. There are a number of companies that can provide the needed data. TIGER has much of it, and you might start there. It is usually free, but can take a fair amount of work to get it into a usable form. Other companies have already done much of the hard work for you and also reference other datasets, but these can be quite expensive. My recommendation my be to get your hands on MapPoint. It is relatively cheap and comes pre-packaged with the data you need, and also provides methods to help you along.
Once you have all that information available, the query isn't terribly difficult, well relatively speaking. Based on your search criteria, you build a search Range / Bounding Box. Then initially query out a subset of records using that. This will give you a list of records that "could" meet your criteria. Then from that dataset, you iterate through each record performing a distance calculation to see if it actually falls within the desired radius; keeping the ones you need and discarding the rest. If you choose to keep your data in Lat/Lon instead of projecting coordinates to a Cartesian coordinate system, then you will probably want to use a math library designed to work with Lat/Lon to calculate distance. Again, MapPoint can do this, of course there are numerous others as well. I haven't examined too many of the "free" ones, so I can't offer a suggestion there other than to be careful. Some of the free ones I've seen have flawed math and can give you quite inaccurate results, especially in the northern half of the US.
I know that didn't really answer your question or provide you a solution, but hopefully it will help you along.
Gerald
"Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message news:71******** *************** ***********@mic rosoft.com... Gerald -
Thanks for your response. Specifically, I need to be able to have someone enter a zip code OR city and state and be able to find out whether there is a listing in my DB which has businesses listed with zip codes, cities and states within a radius of 50 miles, 100 miles, etc. (The user can indicate what radius they want.)
This is similar to store locators on websites where you can enter a zip code and find a store within your vicinity. They have a dropdownlist indicating whether you want "100 miles," "50 miles," "20 miles," etc.
Any help will be greatly appreciated!
-- Sandy
"Gerald Hernandez" wrote:
"Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message news:F0******** *************** ***********@mic rosoft.com... > Hello - > > I need either a cheap tool or code & DB that calculates, eg. within 50-mile > radius of a zip code. > > Anyone have any suggestions? > -- > Sandy
That calculates what specifically? Tell you whether a specific location is within 50 miles of a zip code? Are we talking coordinates, addresses, what? When you say within 50 miles of a zip code, you mean the actual boundary, one of the centroids, the PO itself? Sorry, I might be overthinking this as I do all kinds of stuff like this. If you can clearly define what you have and what you need I might be able to point you in the right direction.
Gerald
That's an interesting article. It takes a very simplistic approach, but
looks like a good start for what you need.
Here is a starting link for pricing on MapPoint: http://www.microsoft.com/mappoint/pr.../purchase.mspx
I say "relatively ", because compared to ArcView ($3000+) and others much
more expensive, the $300 for MapPoint is cheap. Getting quality data itself
can be expensive. ZIP code areas are changing constantly, and many data
providers provide quarterly updates, and some monthly. Assuming you need the
whole USA. Cheap data, is well cheap, sometimes free. Usually based on very
old TIGER files, often times 10 years or more out of date. Odds are to get a
decent City name to ZIP code delivery cross reference you will need to
purchase the data. Now when I say expensive, this is compared to free, you
are probably talking about less than $500.
Another thing to be aware of is that most data providers have specific
limitations on usage of the data. If it involves web pages and such, there
is an additional fee. I believe MapPoint has the same limitations,
considering they just license the data from the normal commercial providers.
Gerald
"Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message
news:3A******** *************** ***********@mic rosoft.com... Thanks for your reply, Gerald. It seems I may have found a solution
suitable to my current needs from: http://www.aspfaq.com/show.asp?id=2527
I think I have the stored procedure working, although I still need to test it some more. I also have to build in the capabilities to use city as a parameter. Currently it only does zip codes. I tried to plug it into my aspx page, though, and haven't been able to get it to work correctly yet .
.. . probably something stupid I'm doing.
I briefly glanced at MapPoint and to be perfectly honest, I got aggravated with the fact that I couldn't find the price, so I gave up. What do you
mean by "relatively cheap," and where do they list a price?
-- Sandy
"Gerald Hernandez" wrote:
Sandy,
One of the key elements to this is getting a known locations for both
the search point and the business locations. This is usually accomplished
via a geocode, find the location for a particular address. This is easy enough
for your business addresses as they are known. A little more difficult is
for your starting search point.
If only using ZIP code, it is not very complicated. In most cases, they
just use the centroid of the zip code, which can be defined in numerous ways
but usually the center of mass or the center of distribution/population.
Then compare that to the known location of the businesses. There is
oftentimes much pre-computation of certain parameters, such as assigning an average value for the "radius" of a ZIP code. Plus, it's important to note that
ZIP code areas can be disjoint, meaning you can have multiple areas with the same ZIP code with other ZIP codes in between.
City is a little more difficult. There are numerous Towns and/or Cities
that are not incorporated. As such, they don't usually have clearly defined
or maintained boundary information. For these they do a cross reference to postal delivery names. Basically mapping "city" names to encompassing
ZIP codes, then use the above ZIP code method for location.
The above methods are quite inaccurate, but if you are just looking for something like the store locator example, then it works well enough. If
you are needing something more complex, like routing, point to point
directions, or analysis that requires accuracy, then it is far from sufficient.
In a nutshell, you will need to determine the location of the
businesses, probably via a geocode and store that in your database. You will
probably then want to get your hands on ZIP code data and store the centroids, bounding box area, and calculate an averaged radius size. You will also
need to cross reference the "city" names to postal delivery names and
therefore ZIP codes. There are a number of companies that can provide the needed
data. TIGER has much of it, and you might start there. It is usually free, but
can take a fair amount of work to get it into a usable form. Other companies have already done much of the hard work for you and also reference other datasets, but these can be quite expensive. My recommendation my be to
get your hands on MapPoint. It is relatively cheap and comes pre-packaged
with the data you need, and also provides methods to help you along.
Once you have all that information available, the query isn't terribly difficult, well relatively speaking. Based on your search criteria, you build a search Range / Bounding Box.
Then initially query out a subset of records using that. This will give you a list of records that "could" meet your criteria. Then from that dataset, you iterate through each record performing a distance calculation to see if it actually falls within the desired
radius; keeping the ones you need and discarding the rest. If you choose to keep your data in Lat/Lon instead of projecting coordinates to a Cartesian coordinate system, then you will probably want to use a math library designed to work with Lat/Lon to calculate distance. Again, MapPoint can
do this, of course there are numerous others as well. I haven't examined
too many of the "free" ones, so I can't offer a suggestion there other than
to be careful. Some of the free ones I've seen have flawed math and can
give you quite inaccurate results, especially in the northern half of the US.
I know that didn't really answer your question or provide you a
solution, but hopefully it will help you along.
Gerald
"Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message news:71******** *************** ***********@mic rosoft.com... Gerald -
Thanks for your response. Specifically, I need to be able to have
someone enter a zip code OR city and state and be able to find out whether
there is a listing in my DB which has businesses listed with zip codes, cities
and states within a radius of 50 miles, 100 miles, etc. (The user can indicate what radius they want.)
This is similar to store locators on websites where you can enter a
zip code and find a store within your vicinity. They have a dropdownlist indicating whether you want "100 miles," "50 miles," "20 miles," etc.
Any help will be greatly appreciated!
-- Sandy
"Gerald Hernandez" wrote:
> > "Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message > news:F0******** *************** ***********@mic rosoft.com... > > Hello - > > > > I need either a cheap tool or code & DB that calculates, eg.
within > 50-mile > > radius of a zip code. > > > > Anyone have any suggestions? > > -- > > Sandy > > That calculates what specifically? > Tell you whether a specific location is within 50 miles of a zip
code? > Are we talking coordinates, addresses, what? > When you say within 50 miles of a zip code, you mean the actual boundary, > one of the centroids, the PO itself? > Sorry, I might be overthinking this as I do all kinds of stuff like this. > If you can clearly define what you have and what you need I might be able to > point you in the right direction. > > Gerald > > >
Gerald -
Thanks for the link to MapPoint. Have you ever used it? If so, how hard is
it to hook up?
--
Sandy
"Gerald Hernandez" wrote: That's an interesting article. It takes a very simplistic approach, but looks like a good start for what you need.
Here is a starting link for pricing on MapPoint: http://www.microsoft.com/mappoint/pr.../purchase.mspx
I say "relatively ", because compared to ArcView ($3000+) and others much more expensive, the $300 for MapPoint is cheap. Getting quality data itself can be expensive. ZIP code areas are changing constantly, and many data providers provide quarterly updates, and some monthly. Assuming you need the whole USA. Cheap data, is well cheap, sometimes free. Usually based on very old TIGER files, often times 10 years or more out of date. Odds are to get a decent City name to ZIP code delivery cross reference you will need to purchase the data. Now when I say expensive, this is compared to free, you are probably talking about less than $500.
Another thing to be aware of is that most data providers have specific limitations on usage of the data. If it involves web pages and such, there is an additional fee. I believe MapPoint has the same limitations, considering they just license the data from the normal commercial providers.
Gerald
"Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message news:3A******** *************** ***********@mic rosoft.com... Thanks for your reply, Gerald. It seems I may have found a solution suitable to my current needs from: http://www.aspfaq.com/show.asp?id=2527
I think I have the stored procedure working, although I still need to test it some more. I also have to build in the capabilities to use city as a parameter. Currently it only does zip codes. I tried to plug it into my aspx page, though, and haven't been able to get it to work correctly yet . .. . probably something stupid I'm doing.
I briefly glanced at MapPoint and to be perfectly honest, I got aggravated with the fact that I couldn't find the price, so I gave up. What do you mean by "relatively cheap," and where do they list a price?
-- Sandy
"Gerald Hernandez" wrote:
Sandy,
One of the key elements to this is getting a known locations for both the search point and the business locations. This is usually accomplished via a geocode, find the location for a particular address. This is easy enough for your business addresses as they are known. A little more difficult is for your starting search point.
If only using ZIP code, it is not very complicated. In most cases, they just use the centroid of the zip code, which can be defined in numerous ways but usually the center of mass or the center of distribution/population. Then compare that to the known location of the businesses. There is oftentimes much pre-computation of certain parameters, such as assigning an average value for the "radius" of a ZIP code. Plus, it's important to note that ZIP code areas can be disjoint, meaning you can have multiple areas with the same ZIP code with other ZIP codes in between.
City is a little more difficult. There are numerous Towns and/or Cities that are not incorporated. As such, they don't usually have clearly defined or maintained boundary information. For these they do a cross reference to postal delivery names. Basically mapping "city" names to encompassing ZIP codes, then use the above ZIP code method for location.
The above methods are quite inaccurate, but if you are just looking for something like the store locator example, then it works well enough. If you are needing something more complex, like routing, point to point directions, or analysis that requires accuracy, then it is far from sufficient.
In a nutshell, you will need to determine the location of the businesses, probably via a geocode and store that in your database. You will probably then want to get your hands on ZIP code data and store the centroids, bounding box area, and calculate an averaged radius size. You will also need to cross reference the "city" names to postal delivery names and therefore ZIP codes. There are a number of companies that can provide the needed data. TIGER has much of it, and you might start there. It is usually free, but can take a fair amount of work to get it into a usable form. Other companies have already done much of the hard work for you and also reference other datasets, but these can be quite expensive. My recommendation my be to get your hands on MapPoint. It is relatively cheap and comes pre-packaged with the data you need, and also provides methods to help you along.
Once you have all that information available, the query isn't terribly difficult, well relatively speaking. Based on your search criteria, you build a search Range / Bounding Box. Then initially query out a subset of records using that. This will give you a list of records that "could" meet your criteria. Then from that dataset, you iterate through each record performing a distance calculation to see if it actually falls within the desired radius; keeping the ones you need and discarding the rest. If you choose to keep your data in Lat/Lon instead of projecting coordinates to a Cartesian coordinate system, then you will probably want to use a math library designed to work with Lat/Lon to calculate distance. Again, MapPoint can do this, of course there are numerous others as well. I haven't examined too many of the "free" ones, so I can't offer a suggestion there other than to be careful. Some of the free ones I've seen have flawed math and can give you quite inaccurate results, especially in the northern half of the US.
I know that didn't really answer your question or provide you a solution, but hopefully it will help you along.
Gerald
"Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message news:71******** *************** ***********@mic rosoft.com... > Gerald - > > Thanks for your response. Specifically, I need to be able to have someone > enter a zip code OR city and state and be able to find out whether there is a > listing in my DB which has businesses listed with zip codes, cities and > states within a radius of 50 miles, 100 miles, etc. (The user can indicate > what radius they want.) > > This is similar to store locators on websites where you can enter a zip code > and find a store within your vicinity. They have a dropdownlist indicating > whether you want "100 miles," "50 miles," "20 miles," etc. > > Any help will be greatly appreciated! > > > -- > Sandy > > > "Gerald Hernandez" wrote: > > > > > "Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message > > news:F0******** *************** ***********@mic rosoft.com... > > > Hello - > > > > > > I need either a cheap tool or code & DB that calculates, eg. within > > 50-mile > > > radius of a zip code. > > > > > > Anyone have any suggestions? > > > -- > > > Sandy > > > > That calculates what specifically? > > Tell you whether a specific location is within 50 miles of a zip code? > > Are we talking coordinates, addresses, what? > > When you say within 50 miles of a zip code, you mean the actual boundary, > > one of the centroids, the PO itself? > > Sorry, I might be overthinking this as I do all kinds of stuff like this. > > If you can clearly define what you have and what you need I might be able to > > point you in the right direction. > > > > Gerald > > > > > >
Actually I have not used it. With half a dozen other enterprise level GIS
apps and a bunch of my own, MapPoint just doesn't cut it for me. MapPoint
seems quite limited, but I think it might be an excellent entry point for a
lot of people. From what I have read from others, and the impression I get
from the docs is that it is pretty easy to work with.
Gerald
"Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message
news:05******** *************** ***********@mic rosoft.com... Gerald -
Thanks for the link to MapPoint. Have you ever used it? If so, how hard
is it to hook up?
-- Sandy
<Snipped>...
Thanks!
--
Sandy
"Gerald Hernandez" wrote: Actually I have not used it. With half a dozen other enterprise level GIS apps and a bunch of my own, MapPoint just doesn't cut it for me. MapPoint seems quite limited, but I think it might be an excellent entry point for a lot of people. From what I have read from others, and the impression I get from the docs is that it is pretty easy to work with.
Gerald
"Sandy" <Sa***@discussi ons.microsoft.c om> wrote in message news:05******** *************** ***********@mic rosoft.com... Gerald -
Thanks for the link to MapPoint. Have you ever used it? If so, how hard is it to hook up?
-- Sandy
<Snipped>... This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: Aaron Collins |
last post by:
Hello,
How do I check the radius for a user if they come to my web site and I
want to find out how far certain churches are from where they live.
For instance, display results for churches that are within 25 miles of
where the person lives?
Thank you any help with this.
Aaron;
|
by: R. Rajesh Jeba Anbiah |
last post by:
Q: How to find the distance between two zip codes/cities?
Q: How to find list of cities/zip codes that are with in the particular
radius from given city/zip code?
A: In spherical trigonometry, we have haversine formula, which provides
relationship between the radius of the sphere and any two points on the
sphere (longitude and latitude of the points). So, if we take the earth
as a sphere and have longitude and latitude of any two cities,...
|
by: CSN |
last post by:
I looked through the docs and contrib, but didn't see
anything related to storing and using latitude and
longitude values. I have data in the form of 12° 34'
N, 12° 34' W.
Would any of the geometric data types work well for
this type of data? Or just convert them to decimals?
Are there any functions for converting lat/long
to/from decimals/DDMMSS NSEW?
|
by: kbperry |
last post by:
I am not sure if this is the right place for this, but I thought it was
worth a shot.
What I want:
Enter a From: street address and a To: street address, and then specify
an interval (say every half mile). Then, I click a submit button, and
it gives me latitude and longitude points (in order) from the beginning
of my trip to the end of my trip in 1/2 mile increments.
|
by: helpneeded |
last post by:
Hi
I am a novice using the <maptag. I have a question. I would really
appreciate if you could answer me.
I want to use the <maptag to dynamically update my map with
coordinates. These coordinates are in the form of geographic
coordinates (latitude, longitude). Can this be achieved ? How ? Please
help.
Regards
| |
by: John |
last post by:
Hi
I am trying to use the asp.net web site configuration tool with my app and I
have copied all files from
C:\WINNT\Microsoft.NET\Framework\v2.0.50727\ASP.NETWebAdminFiles into the
ASP.NETWebAdminFiles sub folder of the root of my app. I am getting several
errors. One of the errors is
Error 4 Could not load type
'System.Web.Administration.ApplicationConfigurationPage'.
|
by: Rocky86 |
last post by:
Hi brothers I am new here need help with the php programing using sql basically I am given a task to create a php code that is able to query the database on some free hosting web which I alreadx have the database done right now I am trying to query the database and I have no idea how to do it I wanted to find the value between the Latitude top, latitude bottom and longtitude top and longtitude bottom if it is between it will return the...
|
by: sajidk |
last post by:
Hi All,
I am very new to DB2 programming. I have written a SQL stored procedure and called it from C# . The program is working but it is not returning the error code and sqlstate code. If i comment out all the code except the DELETE SQL statement it gives error with code "SQL0532" in my program side.
Why the EXIT handler is not invoking? OR Why it is not returning values through OUT parameters.?
Looking forward to hear from you. My stored...
|
by: SwapnilD |
last post by:
I'm passing Multiple Lat/lan parameters to GOOGLE map to generate a MAP and also showing markers for all the locations based upon Lat/Lng.
on mouseover event of Marker I'm showing pop up with some info, but along with the info I would also like to show the addrees based upon the lat/lng.
Below is the snippet of code which displays a popup on hover of markers ...
var map = new GMap2(document.getElementById("map_canvas"));
|
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: 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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
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: 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...
| | |