Sam Drew sam-drew

sam-drew / fake_data.json

Last active December 15, 2021 14:33

sam-drew / gtfs_schema.sql

Last active January 30, 2020 09:25

	DROP TABLE IF EXISTS agency;
	DROP TABLE IF EXISTS feed_info;
	DROP TABLE IF EXISTS stops;
	DROP TABLE IF EXISTS routes;
	DROP TABLE IF EXISTS calendar;
	DROP TABLE IF EXISTS calendar_dates;
	DROP TABLE IF EXISTS shapes;
	DROP TABLE IF EXISTS trips;
	DROP TABLE IF EXISTS stop_times;
	DROP TABLE IF EXISTS frequencies;

sam-drew / mergedatasets.py

Created January 26, 2020 20:17

Script to merge alphabetically sorted Network Rail locations JSON files.

	import glob
	import json

	result = []

	for file in glob.glob("*.json"):
	with open(file, "r") as inputfile:
	result.extend(json.load(inputfile))

	with open("TIPLOC_STANOX_LOCs_MERGED.json", "w") as outfile:

sam-drew / TrainMovementExample.json

Last active January 26, 2020 12:07

Source: https://wiki.openraildata.com/index.php?title=Train_Movement

sam-drew / ConvertCoordinates.py

Created December 20, 2019 16:01

Convert string coordinates to a coord object.

	import json

	data = None
	extractedData = []

	with open("airport-codes_json.json", "r") as read_file:
	data = json.load(read_file)

	for item in data:
	if item["iata_code"] != None and (item["type"] == "large_airport" or item["type"] == "medium_airport"):

sam-drew / AirportDatasetIATAOnly.py

Last active December 14, 2019 12:20

Extract airports which have an IATA code from the full dataset.

	import json

	data = None
	extractedData = []

	with open("airport-codes_json.json", "r") as read_file:
	data = json.load(read_file)

	for item in data:
	if item.iata_code != None: