I’ve been tasked to research the most suitable GIS solution able to meet the demands of the end users where I work. We’re a Municipal Government office so basically what people will be wanting is access to the various data associated with properties (land) via a map interface.
I plan on storing the data in either SQL Server 2008 or 2005 and would like a little input on the issues/problems others have encountered in relation to storing shape files & other GIS type data on either of these or if anyone has utilized another database solution (the actual data about the properties can be stored in any data format). I’ve been looking into ArcGIS Server (ESRI), MapXtreme (MapInfo), and MapGuide (AutoDesk) for the mapping solution. Our GIS Department is ESRI based (ArcInfo 9.3 & ArcGIS Desktop 9.3), Engineering is AutoCAD 2008 and their data will have to be incorporated into the mapping interface so sewers and other infrastructure can be displayed. The network is a mixture of Novell and Microsoft but no Linux.
If anyone has had experience setting up and/or maintaining any of the above or even similar software I would appreciate any pointers or comments on things I should watch out for.
