Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You'll need a way of reading that JSON and parsing it into the variable(s) you need. Since you're using jQuery, here's a method that would work with the JSON structure you have.</p> <pre><code>$.getJSON("layers.json").then(function(data) { $.each(data, function(i,datapoints) { $.each(datapoints, function(j,datapoint) { layers.push({ location: new google.maps.LatLng(datapoint.lat, datapoint.lng), weight: datapoint.weight, layerID: datapoint.layer }); }); }); }); </code></pre> <p>Adapt as necessary.</p> <p>In response to davids12's update, here's a function that returns an array of arrays where each composite array has the datapoints from a certain layer. So, running over your example, <code>layers</code> would have 2 arrays in it (<code>layers[1]</code> and <code>layers[2]</code>) which are basically <code>layer1</code> and <code>layer2</code> that you describe in your code (with an additional <code>layerID</code> variable; you could remove it if you wish). This allows you to load much more layers and points just by putting them in the JSON using the format you have now.</p> <pre><code> function loadData() { var layers = [ ]; $.ajax({ url: 'j.json', async: false, dataType: 'json', success: function (data) { for (var i=0; i&lt;data.datapoints.length; i++) { var datapoint = data.datapoints[i]; if (layers[datapoint.layer]===undefined) { layers[datapoint.layer] = []; } layers[datapoint.layer].push({ location: new google.maps.LatLng(datapoint.lat, datapoint.lng), weight: datapoint.weight, layerID: datapoint.layer }); } } }); return layers; } </code></pre>
    singulars
    1. This table or related slice is empty.
    1. POGoogle Maps from JSON File
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USYehia
    1. USYehia
    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. This table or related slice is empty.
    1. COAlright, rookie alert. I've been messing around with this for a while and can't seem to get the JSON datapoints to render to the map. I am probably way off in terms of my code, would you be able to tell me where I went wrong please? See updated code block in my above post.
      singulars
      1. PO
      1. USdavids12
    2. COThanks for your help. I've added your function which returns the layers with 2 arrays in it. How do I go about actually loading those arrays to my map? Previously I had a var called layer1 with the datapoints in it, and I eventually loaded it to my map like this: pointArray1 = new google.maps.MVCArray(layer1);
      singulars
      1. PO
      1. USdavids12
    3. COJust replace `layer1` with `layers[1]` and so on. Of course call the function first to load the data into `layers`.
      singulars
      1. PO
      1. USYehia
 

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