I use a server with a basic Microsoft OS primarily for data storage and as a central repository for edited vector data. These data are not intended to be used as mapping or GIS products available publicly on the web. Additionally, I have always used a standard file structure for organizing data on the server, where files exist within folders. Given this information, I am interested in optimizing my server performance with opensource database management tools such as PostgreSQL and PostGIS. I do not have a strong IT background and am looking for a starting point. So far, I have downloaded PostgreSQL/PostGIS, although I find the process of loading data cumbersome and find myself asking why go through the hassle?.
- Where should I begin in bringing my GIS server and data management practices up to par?
- What opensource/commonly available software can be utilized to optimize a server designed for editing vector data and storing GIS data?