I'm looking at replacing our corporate GIS, this is the first time that I have had the responsibility of such a task despite my years of experience with the software as an end user.
We will be looking at an ESRI platform for our desktop administrative functions but in terms of storage, database structure etc I'm beginning to realise what a minefield this is and hope that I can draw on the knowledge and experience of you good people to perhaps provide some guidance in what to look for perhaps highlight any potential pitfalls I may stumble across along the way.
My current questions are :-
FGDB vs SDE (which will mean having to puchase ArcGIS for Server). How can I best justify the investment of server just for the purposes of data storage (we will be using a different vendors product for serving up our GIS data).
POSTGRESQL/POSTGIS vs ArcGIS for Server - is postgresql/postgis a direct alternative to ArcGIS for Server/SDE etc or are the two completely different...and if so how ?
Is it easy and straightforward to connect to POSTGRESQL/POSTGIS from within ArcGIS Desktop and edit data or does this require some other 3rd party software such as FME or GISSQUIRREL etc ?
My preference is to have ArcGIS for Desktop and ArcGIS for Server from a continuity perspective. There is also the other issue that we are looking at integrating with our other corporate systems, so ideally we only want to do this once and my concern is that if we have different bits of software for different purposes that we are going to end up with more integrations that we perhaps need.
I just want to try and avoid extra steps in processes here, from data creation, to maintenance to publishing etc etc and whilst Dekho would have been the logical step given the fact we will be using ArcGIS Desktop and potentially Server, we felt the end user (GIS desktop viewer and field viewer) requirements we best fulfilled elsewhere so we are happy to take the hit on the extra steps involved in serving our data up this way...which in all honesty isn't that big a deal as most of it is automated anyway.