Select to view content in your preferred language

Mobile Geodatabase system table documentation

939
2
03-10-2023 08:15 AM
Status: Open
Labels (1)
Bud
by
Legendary Contributor

As far as I can tell, the docs don't cover system tables when it comes to mobile geodatabases: Mobile geodatabases.
Whereas other geodatabase types have detailed documentation about how to use the system tables: Geodatabase system tables in Oracle.

Idea:
Could a section be added to the docs that explains how geodatabase mechanisms are stored in mobile GDBs? For example, in what table are domains stored? How can we query domain values (codes and descriptions) using SQL? 

I'm aware that there are GP tools, ArcPy functions, etc. that can be used to get information from GDB system tables. But that's not what I'm looking for. I want to query mobile GDB data (such as domains) using SQL so that I can include domain descriptions in SQL queries/reports, etc.

Related:  Get mobile geodatabase domain values using SQL

2 Comments
Bud
by
PaulHoefflerGISS

This is an important piece of documentation that is missing if the mobile geodatabase format is to be taken more seriously and used more widely.

Its use within ArcGIS products has expanded, but the geoprocessing tools and documentation are lacking.

I wasn't able to find any of the metadata elements within the geodatabase, but I know that they are there because I can access them in Pro and also from FME. I would expect that they could also be accessed through SQLite?