Well the example I just posted does exactly that. Actully not quite, its not talking to a mysql database, its actully using sphinxsearch as the 'database'.
You need a 'API' that accepts parameters by URL, performs the search, and then returns the results back to the application. Its old, but http://www.nearby.org.uk/google/googleMaps.xml.phps this is a basic XML api powered by mysql. Back from the days before JSON was popular, so it used XML !??! Wouldn't recommend coping that directly - but it might be useful to show what such a script would have to do. On Wed, Jun 27, 2012 at 11:46 PM, KP <kevlema...@aol.com> wrote: > Hi, Barry. Cool example! > > Short of a full-blown tutorial, I'm interested in seeing an example page > of HTML code, including the code for the Google Maps API, that: > > - Lets you get a route from A to B. > - Uses the Routeboxer method. > - Runs this method against a MySQL source in order to display only > POIs that are within a certain distance. > > I totally understand that this is not a trivial issue, but seeing example > code that does the above will let me test whether I can pull off this type > of page on my own. Thanks for any advice you can offer on finding this type > of example. > > - KP > > > > On Wednesday, June 27, 2012 6:16:36 PM UTC-4, barryhunter wrote: > >> Well I can't help you with your actual code, because I can't read your >> mind to see it. >> >> To be frank, this isnt a 'trival' topic, so if you dont have much >> experience coding, its might well be trickly to get it right. Might be >> worth looking for a developer (no I am not offering!) >> >> >> But inspired by this thread, I just built a quick rough demo >> http://ww2.scenic-tours.co.uk/**serve.php?t=** >> WoNlXJvolbOuJL5405otwMM4hZ44OV**8hXXb<http://ww2.scenic-tours.co.uk/serve.php?t=WoNlXJvolbOuJL5405otwMM4hZ44OV8hXXb> >> >> Loads photographs along the route (only have photos within the British >> Isles). The boxes, have default values that work, just press the Submit >> button. >> >> >> The main part that needs work, is how to limit the number of results. >> Currently it just takes 100 divided by number of boxes. Then each search is >> fired off, asking for that many results. It does also enforce a minimum, to >> prevent 0 being used :) >> >> This is not ideal because if, there is uneven coverage, say a large >> number of results in one box, but few in others. Will end up not showing >> many results, because the busy box, will still have the same limit. >> >> To combat, that could actully ask for many more results from each box, >> but reduce the number of results actully displayed, once you have all the >> results back. >> >> >> Alternatively could send all the bboxes to the server, and let it use >> them all when finding images. It could then take care of enforcing a good >> limit. >> >> >> Doing the server side component, is something can'y really help you with. >> >> >> >> On Wed, Jun 27, 2012 at 11:04 PM, KP >> >>> Barry, >>> >>> Thanks so much for the quick response. I'm a non-dev looking for a >>> layperson's tutorial or an example that actually does this looping. What >>> part of the code does the looping? This will help me do some cutting and >>> pasting into what I've got so far. >>> >>> I've gotten as far as creating a map that displays all of my POIs. Now, >>> I'm trying to figure out how to only pull the POIs that fall within the >>> range of the route and the box, and I just haven't been able to find a >>> walk-through or an example that is at my level of technical ability. Just >>> to see if I could do it, I added the RouteBoxer.js code to my existing >>> map. I also copied and pasted the code on the examples.html page in. When I >>> do this, no map is generated. >>> >>> Any advice you can offer is much appreciated! >>> >>> - KP >>> >>> >>> >>> >>> >>> On Wednesday, June 27, 2012 5:39:43 PM UTC-4, barryhunter wrote: >>> >>>> The example on the documentation page >>>> http://google-maps-utility-**lib**rary-v3.googlecode.com/svn/**tru** >>>> nk/routeboxer/docs/**examples.**html<http://google-maps-utility-library-v3.googlecode.com/svn/trunk/routeboxer/docs/examples.html> >>>> >>>> >>>> shows how to loop though the 'boxes' retured from the boxer call. >>>> >>>> You would probably fire off a ajax request off to your server, which >>>> would perform a bounding box search, get the results. One search per box. >>>> >>>> The actual demo >>>> http://google-maps-utility-**lib**rary-v3.googlecode.com/svn/**tru** >>>> nk/routeboxer/examples/**routebo**xer-v3.html<http://google-maps-utility-library-v3.googlecode.com/svn/trunk/routeboxer/examples/routeboxer-v3.html> >>>> just calls drawBoxes with the list, you need a similar function. >>>> >>>> >>>> >>>> >>>> On Wed, Jun 27, 2012 at 10:34 PM, KP \ wrote: >>>> >>>> Michael, >>>>> >>>>> Can you provide instructions for step 3? I have scoured the web for an >>>>> example of Routeboxer in action so that I can build a tool that will let >>>>> people map from "A" to "B" and find POIs within a certain distance. I've >>>>> copied the Google code and recreated it, but all I get is a map with a box >>>>> drawn on it. >>>>> >>>>> Thanks for any help you can provide! >>>>> >>>>> - KP >>>>> >>>>> >>>>> On Thursday, June 2, 2011 12:19:35 PM UTC-4, michaeld42 wrote: >>>>>> >>>>>> >>>>>> Tejas, >>>>>> >>>>>> There must be a lot of different ways to do this, and the 'best' way >>>>>> would depend on a lot of different factors, but Routeboxer produces a >>>>>> set of LatLngBounds objects, so to use that I'd proceed as I already >>>>>> outlined above: >>>>>> 1. Use Routeboxer to get set of bounds >>>>>> 2. Get list of all markers from database >>>>>> 3. Loop through the markers and bounds to see if each marker is in >>>>>> any >>>>>> of the bounds (use the 'contains' method documented in the API). >>>>>> >>>>>> - Michael >>>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Google Maps JavaScript API v3" group. >>>>> To view this discussion on the web visit https://groups.google.com/d/* >>>>> *ms**g/google-maps-js-api-v3/-/**eAYg**STGJFuMJ<https://groups.google.com/d/msg/google-maps-js-api-v3/-/eAYgSTGJFuMJ> >>>>> . >>>>> >>>>> To post to this group, send email to google-maps-js-api-v3@**googlegr* >>>>> *oups.com <google-maps-js-api-v3@googlegroups.com>. >>>>> To unsubscribe from this group, send email to google-maps-js-api-v3+** >>>>> unsubscr**i...@googlegroups.com<google-maps-js-api-v3%2bunsubscr...@googlegroups.com> >>>>> . >>>>> For more options, visit this group at http://groups.google.com/**group >>>>> **/google-maps-js-api-v3?**hl=en<http://groups.google.com/group/google-maps-js-api-v3?hl=en> >>>>> . >>>>> >>>> >>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Google Maps JavaScript API v3" group. >>> To view this discussion on the web visit https://groups.google.com/d/** >>> msg/google-maps-js-api-v3/-/**6HjC4Y7YraAJ<https://groups.google.com/d/msg/google-maps-js-api-v3/-/6HjC4Y7YraAJ> >>> . >>> >>> To post to this group, send email to google-maps-js-api-v3@** >>> googlegroups.com <google-maps-js-api-v3@googlegroups.com>. >>> To unsubscribe from this group, send email to google-maps-js-api-v3+** >>> unsubscr...@googlegroups.com<google-maps-js-api-v3%2bunsubscr...@googlegroups.com> >>> . >>> For more options, visit this group at http://groups.google.com/** >>> group/google-maps-js-api-v3?**hl=en<http://groups.google.com/group/google-maps-js-api-v3?hl=en> >>> . >>> >> >> -- > You received this message because you are subscribed to the Google Groups > "Google Maps JavaScript API v3" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/google-maps-js-api-v3/-/sAV0s2yV9q4J. > > To post to this group, send email to > google-maps-js-api-v3@googlegroups.com. > To unsubscribe from this group, send email to > google-maps-js-api-v3+unsubscr...@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/google-maps-js-api-v3?hl=en. > -- You received this message because you are subscribed to the Google Groups "Google Maps JavaScript API v3" group. To post to this group, send email to google-maps-js-api-v3@googlegroups.com. To unsubscribe from this group, send email to google-maps-js-api-v3+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-maps-js-api-v3?hl=en.
