-
Notifications
You must be signed in to change notification settings - Fork 2
/
Copy pathquery.html
46 lines (46 loc) · 1.8 KB
/
query.html
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<html>
<head>
<script type="text/javascript">
var fusionTableID = "1ZcENe5z6cxNPjH6kQeiTZ-__9-wgdbobvzL_994";
var tripID = "T2741456"
var linePoints = [];
function initialize(){
getTrackerInfo();
}
function getTrackerInfo(){
var script = document.createElement('script');
var url = ['https://www.googleapis.com/fusiontables/v1/query?'];
url.push('sql=');
var query = "SELECT Date, Lat, Alt, Lng FROM " + fusionTableID + " WHERE TripID = '" + tripID + "' ORDER BY Date ASC";
var encodedQuery = encodeURIComponent(query);
url.push(encodedQuery);
url.push('&callback=parseFusionTablesData');
url.push('&key=AIzaSyANk7unPrpT9r-ECaDzH7eLpog-SD8Dz-0');
script.src = url.join('');
var body = document.getElementsByTagName('body')[0];
body.appendChild(script);
}
function parseFusionTablesData(fusionTablesdata){
var rows = fusionTablesdata['rows'];
window.alert("ima here");
for (var i in rows) {
linePoints[i] = new dataPoint(i, rows[i][0],rows[i][1],rows[i][2],rows[i][3]);
}
}
function dataPoint (index, timestamp, lat, lng, alt){
this.index = index;
this.timestamp = timestamp;
this.lat = lat;
this.lng = lng;
this.alt = alt;
var newParagraph = document.createElement('p');
newParagraph.textContent = index + " " + timestamp + " " + lat + " " + lng + " " + alt;
document.getElementById("testSite").appendChild(newParagraph);
}
</script>
</head>
<body onload="initialize()">
<div id="testSite">
</div>
</body>
</html>