ArcSDE/SQL Server Database Consulting

Enterprise GIS systems can be extremely complex. They most often need to accommodate  multiple users that need to access geographic data at the same time. This requires a combination of a robust RDBMS (relational database management system) as the storage component and ArcGIS as the client component. The piece in the middle, which allows the ArcGIS client to store, retrieve, and manage spatial data inside the RDBMS,  is ArcSDE (Spatial Database Engine). There are many advantages to having an enterprise GIS. Here a a few highlights:geodatabase-storage

Multi-user editing– numerous users can edit the same or different datasets at the same time without restrictive locking.

Versioning- alternate states of the database that are not affected by changes in other versions created by other users.

Replication– private snapshots of a dataset that can be edited independently, then merged later with the original data.

Performance- lightning fast query and display of geographic data.

Interoperability- communicate with other databases on your network, dynamically join and display external attribute data through the use of spatially enabled views.

Over the years we have discovered that there is often a lack of expertise in one area of an enterprise GIS, either on the database end or the GIS client end.  We have over 20 years of combined experience with both the ArcSDE component of an enterprise GIS and the RDBMS (SQL Server) component. Let us put our knowledge of a complete system to work for you. We can help you with:

  • Database design
  • Upgrades (GIS and/or RDBMS)
  • Database Tuning/Rebuilds
  • Onsite/Remote Consulting and Technical Support
  • Emergency Support/Disaster Recovery
  • Raster Data Management
  • Custom applications/Automation