deton · September 2, 2024 12:16
diff --git a/00README.md b/00README.md
diff --git a/csv2hist.bat b/csv2hist.bat
 python3 csv2hist.py sdv-gc-d.csv docomo-cycle >sdv-gc.ndjson
 python3 csv2hist.py sdv-gc-h.csv hellocycling >>sdv-gc.ndjson
 python3 csv2hist.py sdv-ctgan-d.csv docomo-cycle >sdv-ctgan.ndjson
 python3 csv2hist.py sdv-ctgan-h.csv hellocycling >>sdv-ctgan.ndjson
 python3 csv2hist.py sdv-tvae-d.csv docomo-cycle >sdv-tvae.ndjson
 python3 csv2hist.py sdv-tvae-h.csv hellocycling >>sdv-tvae.ndjson
diff --git a/csv2hist.py b/csv2hist.py
 import json
 import sys

 fname = sys.argv[1]
 systemId = sys.argv[2]

 statuslist = []
 stinfo = {}
 with open(fname) as f:
    for line in f:
        line = line.rstrip('\r\n')
        stationId, lat, lon, capacity = line.split(',')
        if stationId == 'station_id':  # header line
            continue
        stinfo[stationId] = [float(lat), float(lon)]
        statuslist.append([stationId, int(capacity)])

 outdic = {
    'ts': '2024-08-15T00:02',
    'system_id': systemId,
    'status': statuslist,
    'stations': stinfo,
 }
 print(json.dumps(outdic, ensure_ascii=False, separators=(',', ':')))
diff --git a/docomo-cycle.csv.gz b/docomo-cycle.csv.gz
diff --git a/gbfs2capacitycsv.py b/gbfs2capacitycsv.py
 # Usage: python3 gbfs2capacitycsv.py 15/0002hellocycling_station_information.json
 import json
 import sys


 print('station_id,lat,lon,capacity')
 for stfname in sys.argv[1:]:
    with open(stfname) as f:
        info = json.load(f)
    for s in info['data']['stations']:
        capacity = s.get('capacity', s.get('vehicle_capacity'))
        print(f"{s['station_id']},{s['lat']},{s['lon']},{capacity}")
diff --git a/hellocycling.csv.gz b/hellocycling.csv.gz
diff --git a/sdv-ctgan-d.csv.gz b/sdv-ctgan-d.csv.gz
diff --git a/sdv-ctgan-h.csv.gz b/sdv-ctgan-h.csv.gz
diff --git a/sdv-ctgan.geojson b/sdv-ctgan.geojson
diff --git a/sdv-gc-d.csv.gz b/sdv-gc-d.csv.gz
diff --git a/sdv-gc-h.csv.gz b/sdv-gc-h.csv.gz
diff --git a/sdv-gc.geojson b/sdv-gc.geojson
diff --git a/sdv-trial-gbfs.ipynb b/sdv-trial-gbfs.ipynb
diff --git a/sdv-tvae-d.csv.gz b/sdv-tvae-d.csv.gz
diff --git a/sdv-tvae-h.csv.gz b/sdv-tvae-h.csv.gz
diff --git a/sdv-tvae.geojson b/sdv-tvae.geojson
	python3 csv2hist.py sdv-gc-d.csv docomo-cycle >sdv-gc.ndjson
	python3 csv2hist.py sdv-gc-h.csv hellocycling >>sdv-gc.ndjson
	python3 csv2hist.py sdv-ctgan-d.csv docomo-cycle >sdv-ctgan.ndjson
	python3 csv2hist.py sdv-ctgan-h.csv hellocycling >>sdv-ctgan.ndjson
	python3 csv2hist.py sdv-tvae-d.csv docomo-cycle >sdv-tvae.ndjson
	python3 csv2hist.py sdv-tvae-h.csv hellocycling >>sdv-tvae.ndjson
	import json
	import sys

	fname = sys.argv[1]
	systemId = sys.argv[2]

	statuslist = []
	stinfo = {}
	with open(fname) as f:
	for line in f:
	line = line.rstrip('\r\n')
	stationId, lat, lon, capacity = line.split(',')
	if stationId == 'station_id': # header line
	continue
	stinfo[stationId] = [float(lat), float(lon)]
	statuslist.append([stationId, int(capacity)])

	outdic = {
	'ts': '2024-08-15T00:02',
	'system_id': systemId,
	'status': statuslist,
	'stations': stinfo,
	}
	print(json.dumps(outdic, ensure_ascii=False, separators=(',', ':')))
	# Usage: python3 gbfs2capacitycsv.py 15/0002hellocycling_station_information.json
	import json
	import sys


	print('station_id,lat,lon,capacity')
	for stfname in sys.argv[1:]:
	with open(stfname) as f:
	info = json.load(f)
	for s in info['data']['stations']:
	capacity = s.get('capacity', s.get('vehicle_capacity'))
	print(f"{s['station_id']},{s['lat']},{s['lon']},{capacity}")