Welcome to rsm.karit.geek.nz
This site tracks MBIE's Prism Spectrum Management Database changes
/access/ has an archive of the prism MS Access DB's driectly from http://www.rsm.govt.nz/cms/tools-and-services/spectrum-search-lite
/sqlite/full/ has a sqlite file that is basically a datamart that matches the access DB expect each table has one additional column which is import_date. This one file contains each update in full
/sqlite/singles is a sert of sqlite files which are same as the Access file but in sqlite format
/changes/ shows you the differences in each table between each update
Contact rsm AT karit DOT geek DOT nz or @nzkarit
All content orginally from http://www.rsm.govt.nz/cms/tools-and-services/spectrum-search-lite
I will upload the code to github at some stage. The code does the MDB to sqlite and does the differences. Nothing pretty just some bash scripts tieing mdb-tools, sqlite and wget together
The code is available at https://github.com/nzkarit/RSMPrismDiff
2016-11-21