Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You can use Google Places API. </p> <p>Docs: <a href="https://developers.google.com/places/documentation/search" rel="nofollow">https://developers.google.com/places/documentation/search</a></p> <p>Supported location types: <a href="https://developers.google.com/places/documentation/supported_types" rel="nofollow">https://developers.google.com/places/documentation/supported_types</a></p> <p>After you have recieved the users location, make a request like that with your location and relevant types:</p> <pre><code>https://maps.googleapis.com/maps/api/place/nearbysearch/json?location=-33.8670522,151.1957362&amp;radius=500&amp;types=food&amp;name=harbour&amp;sensor=false&amp;key=AddYourOwnKeyHere </code></pre> <hr> <p>Here is a fiddle based on yours, without using fusion tables: <a href="http://jsfiddle.net/iambnz/M9KrK/" rel="nofollow">http://jsfiddle.net/iambnz/M9KrK/</a></p> <p>Add this to your libary call:</p> <pre><code>&amp;libraries=places </code></pre> <p>Add this to your code:</p> <p>Global var:</p> <pre><code>var service; </code></pre> <p>If statement when you found the users location:</p> <pre><code>var request = { location: pos, radius: '500', types: ['store'] }; service = new google.maps.places.PlacesService(map); service.nearbySearch(request, callback); </code></pre> <p>After maps init:</p> <pre><code>function callback(results, status) { if (status == google.maps.places.PlacesServiceStatus.OK) { for (var i = 0; i &lt; results.length; i++) { var place = results[i]; createMarker(results[i]); } } } function createMarker(place) { var placeLoc = place.geometry.location; var marker = new google.maps.Marker({ map: map, position: place.geometry.location }); } </code></pre> <p>I hope this points you in the right direction. </p> <p>Example with sidebar + FT usage from @geocodezip: <a href="http://www.geocodezip.com/geoxml3_test/v3_FusionTables_Watershed_Stewards_Map_sidebar2.html" rel="nofollow">http://www.geocodezip.com/geoxml3_test/v3_FusionTables_Watershed_Stewards_Map_sidebar2.html</a></p>
    singulars
    1. This table or related slice is empty.
    1. POReturn 3 closest locations to a users location (geolocation) and list those locations for them
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USdevbnz
    1. USdevbnz
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COI will certainly test this approach out tomorrow morning. After reading through some of the Places API, do you think this is a better approach than Fusion Tables?
      singulars
      1. PO
      1. USjamez14
    2. COIf the data you are looking for is in the Places API, it is certainly simpler. But be sure to look at your projected usage as well. If the date isn't in the Places API or even if _some_ of the data isn't in the Places API, you will have to deal with that, if you put the data in a Fusion Table, you have control.
      singulars
      1. PO
      1. USgeocodezip
    3. COI think that is where my problem is with the Places API. It doesn't contain the data I need - and having all the control via Fusion Tables seems like the best route to go. I'll definitely keep this in mind though for future reference. Thank you both!
      singulars
      1. PO
      1. USjamez14
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload