Latest Contributions by RudyProsser

These are references and resources for the Esri instructor-led course Deploying and Maintaining a Multiuser Geodatabase. All references are for working with multiuser geodatabases using ArcGIS 10.5 / 10.6.      General References:   GeoNet Resources Deploying and Maintaining a Multiuser Geodatabase (10.6) Course Description Course Resources Q&A   ArcGIS Help (All geodatabase help is found in Desktop Help)   Geodata Data management Geodatabase Geodatabase administration   RDBMS Geodatabases in Oracle Geodatabases in PostgreSQL Geodatabases in SQL Server     Course Topics & References: Note: This section is a work-in-progress. For a current version see the Course Resources on GeoNet. 1: What is a multiuser geodatabase?    Administering Geodatabases Geodatabase administration Geodatabase administration terminology Migrate from ArcSDE administration commands to ArcGIS Desktop Geodatabase storage in a relational database How are geodatabases stored in a DBMS? Geodatabases in SQL Server Setting up a geodatabase in SQL Server A comparison of geodatabase owners in SQL Server System tables of a geodatabase in SQL Server The geodatabase administrator in SQL Server Geodatabases in Oracle Setting up a geodatabase in Oracle System tables of a geodatabase in Oracle The geodatabase administrator in Oracle Geodatabases in PostgreSQL Setting up a geodatabase in PostgreSQL in Windows or Linux System tables of a geodatabase in PostgreSQL Other resources Product information: Data Management Enterprise Geodatabase 101 [from ArcUser, Winter, 2008] An older article but with some good info.   Geodatabase Administration toolset An overview of the Geodatabase Administration toolset Create Enterprise Geodatabase Enable Enterprise Geodatabase 2: Connecting to the geodatabase Database connections Database clients Database connections in ArcMap Geodatabase connections Connect to SQL Server Connect to SQL Server from ArcGIS Connecting to Oracle Connect to Oracle from ArcGIS Connecting to PostgreSQL Connect to PostgreSQL from ArcGIS   3: Loading data into the geodatabase Geodatabase Administration tools Create Database Users (Data Management) Data management tools Truncate Table (Data Management) Append (Data Management) Loading data Adding datasets and other geodatabase elements Loading data Conversion tools – An overview of the Conversion toolbox Simple Data Loader – Loading data in the Catalog tree Object Loader – Loading data in ArcMap Append tool – Append (Data Management) Geoprocessing environment settings What is a geoprocessing environment setting? Creating custom tools A quick tour of creating custom tools   4: Configuring permissions User administration SQL Server Add logins and users to SQL Server Privileges for geodatabases in SQL Server Granting and revoking privileges on datasets Managing connections in Sql Server Oracle Add logins and users to Oracle Privileges for geodatabases in Oracle Granting and revoking privileges on datasets Managing connections in Oracle PostgreSQL Add login roles to PostgreSQL Privileges for geodatabases in PostgreSQL Granting and revoking privileges on datasets Managing connections in PostgreSQL Tools Create Role (Data Management) Create Database User (Data Management) Change Privileges (Data Management) 5: Managing storage Configuration keywords What are configuration keywords? Configuration keywords for enterprise geodatabases DBTUNE table SQL Server SQL Server DBTUNE configuration parameters Altering the contents of the SDE_dbtune table Oracle Oracle DBTUNE configuration parameters Altering the contents of the SDE_dbtune table PostgreSQL PostgreSQL DBTUNE configuration parameters Altering configuration keywords Spatial data types Spatial types in databases Geodatabases in Microsoft SQL Server (folder) SQL Server data types supported in ArcGIS SQL Server spatial types and ArcGIS Geodatabases in Oracle (folder) Oracle data types supported in ArcGIS What is the ST_GEOMETRY storage type? ST_GEOMETRY storage in Oracle SDO_GEOMETRY and ArcGIS Geodatabases in PostgreSQL (folder) PostgreSQL data types supported in ArcGIS What is the ST_GEOMETRY storage type? ST_GEOMETRY storage in PostgreSQL Migrating storage SQL Server - Data migration from one storage type to another Oracle - Data migration from one storage type to another PostgreSQL - Data migration from one storage type to another Migrate Storage (Data Management) Altering configuration Server_Config system table (mostly legacy) Geodatabase Log File Tables 6: Maintaining the geodatabase Geodatabase maintenance (RDBMS specific links) Maintenance overview: Sql Server | Oracle | PostgreSQL Backups: Sql Server | Oracle | PostgreSQL Update database statistics: Sql Server | Oracle | PostgreSQL Rebuild system table indexes: Sql Server | Oracle | PostgreSQL Versioning administration (reconcile, post, compress): Sql Server | Oracle | PostgreSQL Upgrade geodatabase: Sql Server | Oracle | PostgreSQL Administering enterprise geodatabase using ArcGIS Desktop Updating statistics on a dataset using the Analyze Datasets tool Rebuild dataset indexes using the Rebuild Indexes tool Compress a versioned geodatabase Attribute indexes Creating attribute indexes Managing indexes and statistics (Data Management tools) Analyze Datasets Analyze Add Attribute Index Remove Attribute Index Add Spatial Index Remove Spatial Index Rebuild Indexes Spatial Indexes An overview of spatial indexes in the geodatabase ArcGIS and Microsoft spatial types Spatial indexes and ST_Geometry RDBMS specific SQL Server (Microsoft links) Spatial indexes overview Create, modify, and drop spatial indexes Statistics Includes concepts, when to create, and when to update   Compress The compress operation and geodatabases Compress a versioned geodatabase Geodatabase compression: Sql Server | Oracle | PostgreSQL Compress (Data management) Locks Schema locking Manage connections : Sql Server | Oracle | PostgreSQL Prevent geodatabase connections : Sql Server | Oracle | PostgreSQL Geodatabase locks : Sql Server | Oracle | PostgreSQL Managing geodatabase locks : Sql Server | Oracle | PostgreSQL Managing geodatabase locks : Sql Server | Oracle | PostgreSQL Locks during non-versioned editing Concurrency and locking   7: Associating data Database views Create a database view in ArcGIS for Desktop Views in an enterprise geodatabase: Sql Server | Oracle | PostgreSQL Create Database View (Data Management) Make Table View (Data Management) Query layers What is a query layer? (folder) Creating a query layer Make Query Layer (Data Management) Make Query Table (Data Management) SQL Joins (SQL) SQL JOIN and different types of JOINs W3schools SQL tutorial   8: Geodatabase workflow   Additional Resources:   Essential Esri web sites Esri.com – Esri’s primary website. Provides product information plus links to training, services and support. Training – Esri Training gateway for instructor-led and virtual training Esri blogs – Esri InsiderArcGIS ArcGIS.com Esri Support – Esri's online support center GIS Dictionary ArcGIS Ideas GeoNet – The Esri Community Esri Training Discussions Lobby Solutions Marketplace   Learn ArcGIS – Self-study learning about GIS through hands-on projects. Trust ArcGIS – resource for security, privacy, and compliance information. ArcGIS 10.4   ArcGIS for Desktop Home Help Product information Functionality matrix System requirements – ArcGIS for Desktop  ArcGIS Pro Install guides – ArcGIS for Desktop  ArcGIS Pro   ArcGIS 10.4 for Server Home Help Product information Functionality matrix – ArcGIS for Server functionality by license level System Requirements – Windows  Linux Install guides – Windows  Linux   Recommended Training/Follow-on Classes On geodatabases Esri Training > Instructor led Building Geodatabases Deploying and Maintaining a Multiuser Geodatabase Implementing Versioned Workflows in a Multiuser Geodatabase Distributing Data Using Geodatabase Replication   Esri Training > Web courses Getting Started with the Geodatabase (3 hrs) Versioned Editing Workflows for the Multiuser Geodatabase (1 hr Training seminar) Archiving Data in a Multiuser Geodatabase (2 hrs) ... View more

Deploying and Maintaining a Multiuser Geodatabase is Esri Training's multiuser geodatabase course for ArcGIS 10.3. These are questions which required further research before answering. Q: Is operating system (OS) authentication supported in geodatabases on PostgreSQL? A: At the moment, no it is not. There are requests from the user community to support it and some research into what it would take to support it has been done, but in the current release of the enterprise geodatabase (ArcGIS 10.3) on PostgreSQL OS authentication is not supported. ... View more

These are questions from the ArcGIS 10.1 and 10.2 versions of the Configuring and Managing the Multiuser Geodatabase course requiring research before answering. Q: Where do I find the SQL Server Native Client? A: You can get started with the SNAC (SQL Server Native Client) at http://msdn.microsoft.com/en-us/sqlserver/aa937733. Just follow the links. Q: We don’t have Oracle Spatial. What problems does that present? Can we still query the geometry column using PL-SQL? A: Oracle Spatial is not a required component of ArcSDE. When you install ArcSDE all the necessary components are put into place to support the ST_GEOMETRY field type and query it using PL-SQL. There are a few extra installation requirements that must be followed. These are well documented in the install guide. Q: This class doesn’t cover versioning. What are some resources that can help me get started with versioning? A: A good article for understanding the basics of versioning is Versioning 101 in the Winter 2010 issue of ArcUser. After that, take a look at Working with versioned data in the ArcGIS 10.1 Help for the details. Q: What are the options for moving my geodatabase from one Oracle instance to another? A: There are several options for moving a geodatabase. See Methods for moving a geodatabase in Oracle in the ArcGIS Help. Q: Does ArcSDE have to be installed on the same server as my relational database, or can I install it on another server? A: No, ArcSDE does not have to be installed on the same server. See the ArcSDE application install guides for your RDBMS (located on the Help resources page) and the following technical articles on distributed installs: Oracle HowTo: Install ArcSDE on a machine that is remote from the Oracle RDBMS Installing Oracle and ArcSDE on separate servers SQL Server HowTo: Setup ArcSDE and Microsoft SQL Server on separate machines Installation of SQL Server and ArcSDE on separate servers Q: Can you create more than one geodatabase in an Oracle Database instance? A: Yes, you can create multiple geodatabase within one Oracle Database instance. Multiple geodatabases in Oracle and two subsequent ArcGIS Help articles describes the process. The step-by-step workflow is described in Creating a geodatabase in a user’s schema. Also take a look at Creating Multiple Geodatabases Within a Single Oracle Instance in the geodatabase blog. Q: What are the SDE admin commands and parameters for creating a service and modifying the sde configuration? A: The SDE admin commands for creating a service are sdeservice and sdeconfig. The specific parameters of each command will vary according to the RDBMS. To create a service for SQL Server, use the following: sdeservice –o create ^ –d SQLSERVER ^ –s geodata ^ –u sde ^ –p sde_class ^ –i naperville_sde Note: Give your services a meaningful name, such as the database’s name with _sde appended to it. To specify the admin database sdeservice –o register ^ -d SQLSERVER ^ -r ADMIN_DATABASE ^ -v naperville ^ -i naperville_sde Add the following line to the services.sde and services files naperville_sde 5151/tcp To start or stop your new sde serivce net start naperville_sde net stop naperville_sde To modify the sde configuration, for example, to change the maximum number of connections sdeconfig –o alter ^ -v CONNECTIONS=100 ^ -i sde:sqlserver:Geodata ^ -D Naperville ^ -u sde ^ -p sde_class Q: What are the deprecation plans for ArcGIS 10.1 and 10.2? A: The knowledge base FAQ What are the deprecation plans for ArcGIS 10.1 and the upcoming release of ArcGIS 10.2? provides links to the Esri deprecation plans. The deprecation plan indicates that 10.2 is the last release of ArcSDE as services and admin commands. Direct link to deprecation plan: Deprecation Plan for ArcGIS 10.1 and ArcGIS 10.2 Q : Can I schedule a ModelBuilder model to run at specific times? A: You cannot schedule a model to run at a specific time, but you can export the model to a Python script and schedule the script to run at specific times. See the following blog posts and Help articles: Exporting a model to a Python script Scheduling a Python script or model to run at a prescribed time Scheduling a Python script to run at prescribed times You’ll also be doing this in Lesson 9. Q: If the ArcSDE Admin Commands are going away, how will the ArcSDE configuration and DBTUNE tables be managed? A: Here’s the response I received when I asked the geodata team: “We are replacing certain commands (those where no other comparable functionality exists in the UI or via GP tools) with new GP tools. The sdedbtune command will be available via GP. The sdeconfig will not be duplicated as the majority of the parameters are App Server-specific and will be deprecated. The remaining parameters are under review to see if changes can be made so that specific settings become dynamic. The only settings that will be configurable via a GP tool will be logfile parameters.” Q: How can I determine the selectivity of an index or potential index? A: The selectivity of an index is determined by the ratio of the number of unique values in the column being indexed divided by the total number of records in the table. Highly selective indexes will have a ration approaching 1. Indexes with low selectivity will approach zero. The following SQL (T-SQL from MS SQL Server) determines the selectivity of an index built on the NAME field of the table FABRIC_PARCELS. SELECT COUNT( DISTINCT NAME) AS 'Number Unique', COUNT(*) AS 'Number Rows', STR( COUNT( DISTINCT NAME) / CAST( COUNT(*) AS REAL),4,2) AS 'Selectivity' FROM [dbo].[FABRIC_PARCELS]; GO Q: What are DBTUNE best practices for managing larger, static feature classes, e.g. do I just load Washington State parcels (3,085,858 polygon features) using the DEFAULTS keyword, or do I get more special with it? How about a state-wide transportation/navigation network - just pick the existing keyword? We don't edit these, we just receive, load, and use. Is there a current white paper available? A: I was unable to find a white paper on the subject. Static data, or basemap data, is data used to provide a context for other datasets in your database. The most common form of static data is data you receive from someplace or someone else which you include in your geodatabase, but do not edit or manage. The general consensus is to set the indexes and data file fill factors or percent free for any data that is not edited to their highest values, minimizing the space they take up in the database. Q: How can I determine if an index has been rebuilt or statistics been updated? A: For SQL Server, the following SQL query lists indexes by the last modified date, list the most recently modified index first. SELECT si.object_id AS 'Object-ID', ss.name AS 'Schema/Owner', so.name AS 'Table Name', si.name AS 'Index Name', si.type_desc AS 'Index Type', so.create_date AS 'Create Date', so.modify_date AS 'Modify Date' FROM sys.indexes AS si JOIN sys.objects AS so on si.object_id = so.object_id JOIN sys.schemas AS ss on so.schema_id = ss.schema_id WHERE so.type_desc = 'USER_TABLE' ORDER BY so.modify_date DESC; GO Q: When using Database Authentication, unchecking the Save username and password box does not appear to work. You still are connected to the geodatabase when using the connection file. A: There are known issues with database authenticated connections and how ArcMap caches current user logins. If you create a new database authenticated connection without providing a username and password after and you have already connected to the same geodatabase using different credentials, ArcGIS may substitute the cached credentials rather than prompting for new user credentials. Q: Are database views available in Workgroup geodatabases? A: Yes, you can create database views within a Workgroup geodatabase using the Create Database View tool. Q: Does Esri and ArcGIS support Microsoft SQL Server 2014 for multiuser geodatabases? A: Yes, SQL Server 2014 will be supported at ArcGIS 10.3. See Microsoft SQL Server database requirements for ArcGIS 10.3 Prerelease. ... View more

Note: This is for the ArcGIS 10.2 version of the Configuring and Managing the Multiuser Geodatabase course. Esri web pages Esri.com – Esri’s primary web site Training – Esri Training gateway for instructor-led and virtual training ArcGIS Resources – ArcGIS Help and software resources ArcGIS Help Current version Previous versions Esri Support – Esri’s online support center GIS Dictionary GeoNet ArcGIS Online ArcGIS Blogs Geodatabase Geodatabase / Geodata Community Geodata in ArcGIS 10.2 Help Geodata in ArcGIS 10.1 Help Essential readings about the geodatabase What is a geodatabase? The architecture of a geodatabase A quick tour of the geodatabase Types of geodatabases Building a geodatabase tutorial - A multi-lesson tutorial on organizing, importing, and creating geodatabase objects. Requires you to install the ArcGIS for Desktop tutorial data. Enterprise geodatabases Enterprise Geodatabase 101 - A review of design and key features for GIS managers and database administrators Geodatabase product information Multiuser geodatabase Multiuser functionality Storage in an RDBMS Geodatabase Tools & Utilities X-Ray for ArcCatalog - add-in for ArcCatalog used to develop, refine and document your geodatabase designs X-Ray for ArcCatalog (ArcGIS 10.2) X-Ray for ArcCatalog (ArcGIS 10.1) X-Ray for ArcCatalog (ArcGIS 10.0) PerfQAnalyzer – utility for capturing render and edit times. Calibrating ArcGIS Performance with PerfQAnalyzer: New Build Available for Download – Blog includes links to download the tool. ArcGIS Diagrammer - a productivity tool for GIS professionals to create, edit or analyze geodatabase schema ArcGIS Diagrammer for 10.2 ArcGIS Diagrammer for 10.1 Geodatabase Diagrammer for 10x Geodatabase design – For more information on geodatabase design, see the ArcGIS 10.1 Help section Designing a geodatabase (Help > Geodata > Geodatabases > Designing a geodatabase)      Esri Press books on geodatabase design Modeling Our World, 2 nd ed: The Esri Guide to Geodatabase Concepts Designing Geodatabases: Case Studies in GIS Data Modeling Designing Geodatabases for Transportation Thinking About GIS: Geographic Information System Planning for Managers, 4 th ed. Roger Tomlinson      Other books Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design, 3 rd ed by Michael Hernandez. It’s also available on Google Books here. Data-loading tools - See the following ArcGIS Desktop Help articles: Conversion tools – See An overview of the Conversion toolbox Simple Data Loader – see Loading data in the Catalog tree Object Loader – see About loading data in ArcMap, Adding the Load Objects command to ArcMap, and Loading data with the Load Objects command Append tool – see Append (Data Management) Versioning – Versioning is the primary editing workflow in a multi-user geodatabase, allow multiple editors to work collaboratively or in isolation. Versioning 101 Working with versioned data [book] in the ArcGIS 10.1 Help Version scenarios Managing geodatabase versions Versioning Workflows - Esri White Paper - April 20, 2004 ArcGIS Functionality Matrixes - Desktop and server functionality by license level ArcGIS for Desktop ArcGIS for Server Geodatabase repository schema – Detailed listings of the geodatabase system tables found in an enterprise geodatabase are available in ArcGIS Help articles for each supported RDBMS: SQL Server, Oracle, PostgreSQL. Object model diagrams of each geodatabase are available in the Documentation folder of the ArcGIS for Desktop install (C:\Program Files (x86)\ArcGIS\Desktop10.1\Documentation): SS_ for SQL Server, O_ for Oracle, and pgsql_ for PostgreSQL. Course Topics and References: 1. Using the geodatabase Types of geodatabases A comparison of geodatabase types Essential readings about the geodatabase 2. What is ArcSDE? A quick tour of administering geodatabases Essential geodatabase administration vocabulary A quick tour of administering ArcSDE geodatabases with ArcGIS for Desktop Storage in a Relational Database Management System (RDBMS) [from Geodatabase product information] Enterprise Geodatabase 101 [from ArcUser, Winter, 2008]      Geodatabase Repository Schema SQL Server Oracle PostgreSQL 3. Connecting to the geodatabase Database connections in ArcGIS for Desktop      Direct connections Setting up a connection to SQL Server Setting up a connection to Oracle Setting up a connection to PostgreSQL     Application server connections SQL Server Oracle PostgreSQL      ArcSDE application server installation guide SQL Server Oracle PostgreSQL      Deprecation plans KB 41175: FAQ What are the deprecation plans for ArcGIS 10.1 and the upcoming release of ArcGIS 10.2? Deprecation Plan for ArcGIS 10.1 and ArcGIS 10.2 4. Loading data into the geodatabase Workflow strategies for loading data User privileges      Geodatabase Administration tools Create Database Users (Data Management)      Data management tools Truncate Table (Data Management) Append (Data Management)      Loading data Adding datasets and other geodatabase elements (folder) Loading data (folder) Conversion tools – An overview of the Conversion toolbox Simple Data Loader – Loading data in the Catalog tree Object Loader – Loading data in ArcMap (folder) Append tool – Append (Data Management) 5. Managing storage Configuration keywords in the geodatabase Configuration keywords for ArcSDE geodatabases      DBTUNE in SQL Server Oracle PostgreSQL 6. Spatial types      ArcSDE compressed binary storage SQL Server Oracle      Spatial types SQL Server - ArcGIS and Microsoft spatial types Oracle – What is the ST_GEOMETRY storage type? What is Oracle Spatial? PostgreSQL - What is the ST_GEOMETRY storage type? What is the PostGIS geometry type?      Migrating storage SQL Server - Data migration from one storage type to another Oracle - Data migration from one storage type to another PostgreSQL - Data migration from one storage type to another Migrate Storage (Data Management) 7.Configuring permissions User privileges      User administration Adding and administrating users in SQL Server (folder) What are user privileges? User privileges for geodatabase in SQL Server Granting and revoking privileges on datasets Adding and administrating users in Oracle (folder) What are user privileges? User privileges for geodatabase in Oracle Granting and revoking privileges on datasets Adding and administrating users in PostgreSQL (folder) What are user privileges? User privileges for geodatabase in PostgreSQL Granting and revoking privileges on datasets 8. Associating data      Database views Using views in SQL Server (folder) Using views in Oracle (folder) Using views in PostgreSQL (folder) Create Database View (Data Management) Make Table View (Data Management)      Query layers Adding and working with query layers (folder) Make Query Layer (Data Management) Make Query Table (Data Management) Support Services Blog > The Evolution of Query Layers      SQL Joins (SQL) SQL JOIN and different types of JOINs 9. Managing the geodatabase Updating statistics on a dataset using the Analyze Datasets tool Updating statistics on a dataset using Analyze Using the Rebuild Indexes tool to rebuild indexes on geodatabase system tables Rebuilding indexes on geodatabase system tables using a Python script Using the Analyze Datasets tool to update statistics on geodatabase system tables Updating statistics on geodatabase system tables using a Python script 10. Managing geodatabase locks Schema locking Viewing connected user sessions Geodatabase locks Managing locks in the geodatabase Concurrency and locking 11. Geodatabase workflow Recommended Training/Follow-on Classes On geodatabases Configuring and Managing the Multiuser Implementing Versioned Workflows in a Multiuser Geodatabase Distributing Data Using Geodatabase Replication Archiving Data in a Multiuser Geodatabase (for ArcGIS 10.1) On editing and sharing geodatabases Creating and Sharing Map Packages (for ArcGIS 10.1) Editing Data with ArcGIS for Desktop (10.2) ArcGIS for Server: Sharing GIS Content on the Web (for 10.1) ArcGIS 4: Sharing Content on the Web (for ArcGIS 10.2) On Python Python for Everyone Using ArcGIS 10.1 Basics of Python (for ArcGIS 10.1) Introduction to Geoprocessing Scripts Using Python ... View more