From 6b6842c72b28c1346ef501bc656ec3016d00e1c7 Mon Sep 17 00:00:00 2001
From: Jacek Kowalski <Jacek@jacekk.info>
Date: Mon, 10 Jun 2019 20:49:08 +0000
Subject: [PATCH] Add procedure to match TTSS to GTFS via bus positions

---
 lib/mapper.php |   50 ++++++++++++++++++++++++++++++++++++++++++++++++++
 parse.php      |    5 +++++
 2 files changed, 55 insertions(+), 0 deletions(-)

diff --git a/lib/mapper.php b/lib/mapper.php
index 453db3f..933305f 100644
--- a/lib/mapper.php
+++ b/lib/mapper.php
@@ -9,6 +9,8 @@
 	private $ttssTrips = [];
 	private $gtfsrtDate = NULL;
 	private $gtfsrtTrips = [];
+	private $gtfsTrips = [];
+	private $gtfsRoutes = [];
 	private $logger = NULL;
 	
 	private $specialNames = [
@@ -42,8 +44,11 @@
 					continue;
 				}
 			}
+			$name = explode(' ', $vehicle->name, 2);
 			$this->ttssTrips[(int)$vehicle->tripId] = [
 				'id' => $vehicle->id,
+				'line' => $name[0],
+				'direction' => $name[1],
 				'latitude' => (float)$vehicle->latitude / 3600000.0,
 				'longitude' => (float)$vehicle->longitude / 3600000.0,
 			];
@@ -53,6 +58,29 @@
 	
 	public function getTTSSDate() {
 		return $this->ttssDate / 1000.0;
+	}
+	
+	public function loadGTFS($file) {
+		$buffer_size = 512;
+		
+		$routes = fopen('phar://'.$file.'/routes.txt', 'r');
+		$route_header = fgetcsv($routes, $buffer_size);
+		while(($route = fgetcsv($routes, $buffer_size)) !== FALSE) {
+			$this->gtfsRoutes[$route[0]] = $route[2];
+		}
+		fclose($routes);
+		
+		$trips = fopen('phar://'.$file.'/trips.txt', 'r');
+		$trip_header = fgetcsv($trips, $buffer_size);
+		var_dump($trip_header);
+		while(($trip = fgetcsv($trips, $buffer_size)) !== FALSE) {
+			$this->gtfsTrips[$trip[0]] = [
+				'line' => $this->gtfsRoutes[$trip[1]] ?? NULL,
+				'route' => $trip[1],
+				'direction' => $trip[3],
+			];
+		}
+		fclose($trips);
 	}
 	
 	public function loadGTFSRT($file) {
@@ -81,6 +109,28 @@
 		return $this->gtfsrtDate;
 	}
 	
+	public function mapUsingCoords() {
+		$level = 0.002;
+		foreach($this->gtfsrtTrips as $gkey => $gtrip) {
+			$trip = $this->gtfsTrips[$gtrip['tripId']] ?? NULL;
+			
+			if($trip === NULL) continue;
+			
+			foreach($this->ttssTrips as $jkey => $jtrip) {
+				echo $gtrip['latitude'].' '.$jtrip['latitude']."\n";
+				echo $gtrip['longitude'].' '.$jtrip['longitude']."\n";
+				echo $jtrip['line'].' '.$trip['line']."\n";
+				echo "\n";
+				
+				if($jtrip['line'] != $trip['line']) continue;
+				if(abs($gtrip['latitude'] - $jtrip['latitude']) > $level) continue;
+				if(abs($gtrip['longitude'] - $jtrip['longitude']) < $level) continue;
+				
+				echo 'MATCH '.$gtrip['num'].' '.$gkey.' '.$jkey.' ('.($jkey-$gkey).')'."\n";
+			}
+		}
+	}
+	
 	public function findOffset() {
 		if(count($this->ttssTrips) == 0 || count($this->gtfsrtTrips) == 0) {
 			return NULL;
diff --git a/parse.php b/parse.php
index b3014b8..4651082 100644
--- a/parse.php
+++ b/parse.php
@@ -7,6 +7,8 @@
 
 $sources = [
 	'bus' => [
+		'gtfs' => 'ftp://ztp.krakow.pl/GTFS_KRK_A.zip',
+		'gtfs_file' => 'GTFS_KRK_A.zip',
 		'gtfsrt' => 'ftp://ztp.krakow.pl/VehiclePositions_A.pb',
 		'gtfsrt_file' => 'VehiclePositions_A.pb',
 		'ttss' => 'http://91.223.13.70/internetservice/geoserviceDispatcher/services/vehicleinfo/vehicles',
@@ -38,6 +40,7 @@
 		$mapper = new Mapper();
 		
 		$mapper->loadTTSS($source['ttss_file']);
+
 		$timeDifference = time() - $mapper->getTTSSDate();
 		if(abs($timeDifference) > 60) {
 			throw new Exception('TTSS timestamp difference ('.$timeDifference.'s) is too high, aborting!');
@@ -49,6 +52,8 @@
 			throw new Exception('GTFSRT timestamp difference ('.$timeDifference.'s) is too high, aborting!');
 		}
 		
+		$mapper->loadGTFS($source['gtfs_file']);
+		
 		$db = new Database($source['database']);
 		
 		$logger->info('Finding correct offset...');

--
Gitblit v1.9.1