Difference between mobile geodatabase vs. SQLite ST_Geometry database

Bud — Mon, 06 Mar 2023 15:58:50 GMT

What's the difference between a mobile geodatabase vs. a SQLite ST_Geometry database? (other than the file extension?

Mobile Geodatabases
Load the SQLite ST_Geometry library
Load ST_Geometry to a mobile geodatabase for SQL access
- I had assumed that ST_Geometry would be installed in mobile geodatabases by default. But it sounds like that's not the case...so that's another similarity between mobile geodatabases and SQLite databases.

Re: Difference between mobile geodatabase vs. SQLite ST_Geometry database

VaibhavS — Tue, 28 Mar 2023 08:13:41 GMT

Hi Bud,

As far as I know, with respect to offline editing; as soon as we download offline map, it creates a two way replica and a version along with a mobile geodatabase.

A notable difference can be mobile geodatabases are used in offline editing while databases with ".sqlite" extensions are not.

You can store spatial information in an SQLite database using the Esri ST_Geometry spatial data type, SpatiaLite, or use the OGC GeoPackage spatial storage format. However, I believe we cannot use the Geopackages spatial storage format with a mobile geodatabase.

Please feel free to share more information. I would like to read more on this.

Regards,

Vaibhav

topic Re: Difference between mobile geodatabase vs. SQLite ST_Geometry database in Geodatabase Questions

Difference between mobile geodatabase vs. SQLite ST_Geometry database

Re: Difference between mobile geodatabase vs. SQLite ST_Geometry database