Vincent Engelmann engelmav
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| BusRoute.route_id | |
| ,bustrip.trip_id | |
| ,bustrip.trip_headsign | |
| ,BusStopTime.arrival_time | |
| ,busstopTime.stop_sequence | |
| ,busstop.stop_name | |
| --,BusTripShape.shape_pt_sequence | |
| FROM routes BusRoute | |
| LEFT JOIN trips BusTrip |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| BusRoute.route_id | |
| ,bustrip.trip_id | |
| ,bustrip.trip_headsign | |
| ,BusStopTime.arrival_time | |
| ,busstopTime.stop_sequence | |
| ,busstop.stop_name | |
| --,BusTripShape.shape_pt_sequence | |
| FROM routes BusRoute | |
| LEFT JOIN trips BusTrip |
engelmav
/ gist:4136271
Last active
October 13, 2015 03:58
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| use strict; | |
| use DBI; | |
| use Data::Dumper; | |
| use DateTime; | |
| use Text::CSV_XS; | |
| my $pg_dbname = "gtfs_njtransit"; | |
| my $pg_host = "dbi:Pg:dbname=$pg_dbname"; | |
| my $pg_user = "xxxx"; | |
| my $pg_pass = "xxxx"; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| BusRoute.route_id | |
| ,bustrip.trip_id | |
| ,bustrip.trip_headsign | |
| ,BusStopTime.arrival_time | |
| ,busstopTime.stop_sequence | |
| ,busstop.stop_name | |
| --,BusTripShape.shape_pt_sequence | |
| FROM routes BusRoute | |
| LEFT JOIN trips BusTrip |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| BusRoute.route_id | |
| ,bustrip.trip_id | |
| ,bustrip.trip_headsign | |
| ,BusStopTime.arrival_time | |
| ,busstopTime.stop_sequence | |
| ,busstop.stop_name | |
| --,BusTripShape.shape_pt_sequence | |
| FROM routes BusRoute | |
| LEFT JOIN trips BusTrip |
engelmav
/ buses_to_pabt_8-815_lat_ln.sql
Created
December 9, 2012 16:54
NJ Buses to Port Authority b/w and 8:15 w/ Lat/Lon
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| SELECT | |
| BusRoute.route_id | |
| ,bustrip.trip_id | |
| ,bustrip.trip_headsign | |
| ,BusStopTime.arrival_time | |
| ,busstopTime.stop_sequence | |
| ,busstop.stop_name | |
| ,busstop.stop_lat | |
| ,busstop.stop_lon | |
| ,busstop.stop_id |
engelmav
/ test_nlu.py
Created
February 7, 2018 04:43
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| from rasa_nlu.model import Interpreter, RasaNLUConfig | |
| from rasa_core import utils | |
| import logging | |
| def test_loop(user_messages): | |
| for message in user_messages: | |
| result = interpreter.parse(message) | |
| logger.info("test message: `{}`, result: {} with confidence {}".format(message, result['intent']['name'], | |
| result['intent']['confidence'])) |