Storage

Before discussing data loading, we should briefly touch on storage, the primary role of an enterprise database. Each RDBMS supported by ArcGIS Enterprise has its own mechanisms for storing the spatial component of geographic data (the geometries). For SQL Server, starting with ArcGIS 10.4, the default mechanism is the Microsoft Geometry spatial type. Other types available for use in SQL Server include ArcSDE compressed binary (the default prior to ArcGIS 10.4) and Microsoft Geography. These different storage types are each suitable for various environments and situations. The data storage type can be set when creating or loading/importing data. For example, in SQL Server, if you do not need SQL access to the spatial column of your ...

Get Mastering ArcGIS Enterprise Administration now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.