topic Re: GeoPackage layer name adds 'main.' prefix in ArcGIS Pro Questions

GeoPackage layer name adds 'main.' prefix

ToyotaT18 — Thu, 29 Jul 2021 07:45:58 GMT

When I add a layer from a GeoPackage (which was created using arcpy), ArcGIS Pro gives the layer a prefix of 'main.' which doesn't look great but can also mess with my arcpy tools due to the invalid '.' character.

Is there a way of avoiding this prefix being added to the layer name?

Re: GeoPackage layer name adds 'main.' prefix

MarcoBoeringa — Thu, 29 Jul 2021 12:37:31 GMT

I don't think so, this is a SQLite feature (Geopackages are based on SQLite).

SQLite supports the ability to "attach" other databases to a single database connection. The first database opened before you attach other databases, is called "main" (there is also "temp" for temporary stuff) by default:

https://www.sqlite.org/lang_attach.html

The database names ("main" or another "<YOUR_ATTACHED_DATABASE_NAME>") are essentially treated as database "schema" names by SQLite.

ArcGIS seems to inherit this structure (and I think for good reasons).

Since SQLite databases are here to stay in ArcGIS, especially now ESRI also introduced the SQLite based "Mobile Geodatabase" data format, I suggest you start adjusting your arcpy scripts to handle this, rather than trying to avoid this.

This will likely be the only viable option in the long run.

Re: GeoPackage layer name adds 'main.' prefix

ToyotaT18 — Fri, 30 Jul 2021 01:16:16 GMT

Thanks Marco, yeah I'll look into accommodating this, either through the use of arcpy.ValidateTableName, or by renaming the layer when adding to the map.