Yeah that soil data mart is a whole other animal. Luckily I'm mostly on the agronomy side of things right now, focused on Nitrogen, so we just kinda skim the data for soil properties (such as hydrology) that we need and display the GIS plots as a visual aid for the user. Then it's just manipulating that data to show trends on the GIS plots that the user is interested in. Having that soil data sitting there in a free and consistent format makes my job a hell of a lot easier, as I'm sure you found with the nutrient db.
I've recently started playing with Json (well, Google's Gson anyway) myself for a mobile application I'm working on so this may be a nice learning experience for me, but I'll dive into your source a little more this weekend and maybe try to knock an issue or 2 off your repo's list :)
I've actually started a second json database for the program for different nutrient profiles and various data that needs to be stored. I'll probably push it later today once it's working. I'm planning on asking a lot more from json, and now that I'm doing it I'm not sure why I didn't do it sooner.
Python's great for working with json because a json file is actually a valid list of dictionaries in python. I've taken to validating it with a python interpreter, since it'll find any mismatched braces or extra/missing commas.
The only issues I have listed on the repo have to do with adding some minor functionality to the GUI layer, which would entail learning wxpython and dealing with the somewhat disorganized wx code I've written. I'm never sure what the best way to clean up the wx code is, but it's always on my mind.
I've recently started playing with Json (well, Google's Gson anyway) myself for a mobile application I'm working on so this may be a nice learning experience for me, but I'll dive into your source a little more this weekend and maybe try to knock an issue or 2 off your repo's list :)