topic Re: DB Browser complains that mobile geodatabase requires icufoldcase in ArcGIS Pro SDK Questions

DB Browser complains that mobile geodatabase requires icufoldcase

KirkKuykendall1 — Fri, 08 Jan 2021 17:31:15 GMT

Hi -

Using Arc Pro 2.7, I created a mobile geodatabase, then opened it with DB Browser for Sqlite 3.12.1.

When I chose to browse the GDB_Items table I get this warning:

Is this something I should worry about?

Thanks, Kirk

Re: DB Browser complains that mobile geodatabase requires icufoldcase

Wolf — Fri, 08 Jan 2021 18:24:39 GMT

Hi Kirk,

I reached out to the GeoDatabase team and it turns out that GDB_Items has a spatial column that requires the ST_Geometry extension to be loaded. I think you already mentioned that you downloaded the ST_geometry extension DLL from MyEsri, I haven't verified this yet, but the ST_Geometry library is named stgeometry_sqlite.dll (or, on Linux, libstgeometry_sqlite.so).
You need to use "Tools | Load Extension ..." to load the extension in 'DB Browser'.

The GeoDatabase team also mentioned that they are working on documentation describing the use of mobile geodatabases with 3rd party software pacakages and the ST_geometry.dll as part of the 2.8 release.

Re: DB Browser complains that mobile geodatabase requires icufoldcase

KirkKuykendall1 — Fri, 08 Jan 2021 18:43:26 GMT

The Load Extensions button is grayed until I open a geodatabase.

After opening a geodatabase readonly, I click Tools>Load Extension in Db Browser and choose the dll. I then get the same warning pop up. But then I don't get the warning when opening GDB_Items.

Since I'm opening the DB Browser readonly, I bet it's a bug in DB Browser. If it's readonly I don't see how anything bad could happen.

Thanks, Kirk

Re: DB Browser complains that mobile geodatabase requires icufoldcase

Wolf — Mon, 11 Jan 2021 18:22:03 GMT

Just an FYI, in case you were not aware of this. You can open any supported feature layer data source using the ArcGIS Pro SDK. This is the code:

try { string url = @"C:\temp\Mobile\MobileSQLite.geodatabase\main.TestPoints"; Uri uri = new Uri(url); await QueuedTask.Run(() => LayerFactory.Instance.CreateLayer(uri, MapView.Active.Map)); } catch (Exception ex) { MessageBox.Show($@"Error: {ex}"); }

You can create a layer in various ways:

https://github.com/esri/arcgis-pro-sdk/wiki/ProSnippets-MapAuthoring#create-layer

And from there you can display the tabular data and perform queries through the Pro SDK API.