+1 for QGIS and PostGIS. Without being a GIS expert I was able to develop a solution for storing and querying invasive species abundance (and other ecological) data using these tools, and they worked _really_ well, and the researchers who were using that data were able to access it from their R environments without issues.