nzwirelessmap
nzwirelessmap copied to clipboard
Auto-update radio link database
Links have to be updated manually.
An automatic fix might look like:
- Some virtual machine with a cronjob, which
- Downloads the data from RSM
- Imports it to sqlite3
- Exports to CSV
- Uploads CSV to Fusion Tables
It's probably not worth doing this though, given the low traffic.
Exporting to sqlite3 may not be required. The mdb-sqlite adapter I have just uses a java MS Access library. I could instead export to an in-memory SQL database (maybe H2?) and then query from there directly. Then I would need no sqlite3, no native code, could do it all in Java. Then this would be easier to deploy somewhere that can run pure java.