<?php
require_once 'bigquery.php';
include dirname(__FILE__) . "/settings.php";
$bq = new MyBigQueryClass(BIGQUERY_PROJECT_ID, BIGQUERY_CLIENT_ID, BIGQUERY_SERVICE_ACCOUNT_NAME);
date_default_timezone_set("CET");
$xml = simplexml_load_file("http://xml.buienradar.nl");
//print_r($xml);
foreach ($xml->weergegevens->actueel_weer->weerstations->weerstation as $station) {
if ($station->stationcode == 6240) {
$row = array("datetime" => date("Y-m-d H:i:s", strtotime($station->datum)), "temperatureDC" => (double) $station->temperatuurGC, "humidity" => (double) $station->luchtvochtigheid, "windspeedMPS" => (double) $station->windsnelheidMS, "winddirectionDEG" => (double) $station->windrichtingGR, "airpressureMBAR" => (double) $station->luchtdruk, "sightM" => (double) $station->zichtmeters, "windgustsMPS" => (double) $station->windstotenMS, "rainMMPH" => (double) $station->regenMMPU);
$bq->insertRow("weather", "weather", $row);
}
}
<?php
require_once 'bigquery.php';
// or wherever autoload.php is located
include dirname(__FILE__) . "/settings.php";
$bq = new MyBigQueryClass(BIGQUERY_PROJECT_ID, BIGQUERY_CLIENT_ID, BIGQUERY_SERVICE_ACCOUNT_NAME);
date_default_timezone_set("CET");
$json = json_decode(file_get_contents("http://www.trafficlink-online.nl/trafficlinkdata/wegdata/TrajectSensorsNH.GeoJSON"));
$sum = 0;
$count = 0;
$timestamp = null;
$rows = array();
foreach ($json->features as $feature) {
if ($feature->properties->Velocity > 0) {
$length = $feature->properties->Length;
if ($length > 0) {
$ff = round($length / 13.8889, 0);
} else {
$ff = 0;
}
$row = array("id" => $feature->Id, "timestamp" => date("Y-m-d H:i:s", strtotime($feature->properties->Timestamp)), "velocity" => $feature->properties->Velocity, "traveltime" => $feature->properties->Traveltime, "traveltime_freeflow" => $ff);
$bq->insertRow("traveltimes", "traveltimes", $row);
}
}