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