My working day started as usual. The PC was turned on at 9 in the morning. I typed the password for own account into the prompt. Now I am online and working.
I currently work on GIS for one of our clients. The client is a responsible logging company with headquarters in Sweden. It manages forest in North-European Russia and soon it will go through an audit according FSC regulations. It hired our small consulting company to teach their workers FSC principles and to design and implement forest GIS.
What I'm doing now is designing schema for a spatial database. Their old spatial database is based on Austrian GIS: WinGIS. It is very ancient and does not let to edit anything in the database. So we decided to offer them cheaper and more reliable solution - QGIS + PostgreSQL/PostGIS.
That was a long foreword, I guess. =)
The logging company gave us its ancient database, and we might do all the work manually if not I suggested to use PostGIS spatial extension to PostgreSQL. They are all under GPL licence and easy to learn.
So, as I was made responsible for database design and implementation I started to think, how to create and develop it wisely so any forest worker or manager can benefit from it. I will write later on about database implementation details etc.
Particular task that I am busy with now is unifying the spatial database into ONE. Initially I had around 50 different tables in old FoxPro .dbf format. I fed them with shp2pg script to Postrges database and started to write a procedure that automatically merges these tables into ONE.
As I am writing here with simple words it could be an illusion of simplicity. I will go in details in my next posts.
No comments:
Post a Comment