topic Re: Best practices - feature datasets and capitalization for File Geodatabases in Data Management Questions

Best practices - feature datasets and capitalization for File Geodatabases

LyonMNGIS — Tue, 11 Apr 2023 21:10:29 GMT

Hello,

I have a single File Geodatabase that contains data in two projections. The database itself has 14 feature classes of which seven are in one projection and seven are in another projection.

Question 1:

Should I keep all the feature classes in the "root" folder of the Geodatabase, or should I have two separate feature datasets for each projection?

Question 2:

Should my File Geodatabase, Feature Dataset, and Feature Classes use proper case or lower case?

Thanks

Re: Best practices - feature datasets and capitalization for File Geodatabases

DanPatterson — Tue, 11 Apr 2023 21:32:38 GMT

Splitting by coordinate system would be useful. As for names, it really doesn't matter, just don't use punctuation or spaces, (underscore is acceptable)

Re: Best practices - feature datasets and capitalization for File Geodatabases

jcarlson — Tue, 11 Apr 2023 21:45:05 GMT

Personally, I prefer snake_case for naming things. I think it's mostly a matter of preference, but there could be other considerations.

For example, if you plan to use the ArcGIS Python API for anything, or are going to publish any of the data as hosted layers in AGOL, there are certain functions in there that will automatically rename your fields to snake case. So, it could be nice to keep the names in a format that will be consistent elsewhere.

Re: Best practices - feature datasets and capitalization for File Geodatabases

Bud — Tue, 11 Apr 2023 22:03:14 GMT

Re: Best practices - feature datasets and capitalization for File Geodatabases

MobiusSnake — Wed, 12 Apr 2023 10:44:55 GMT

I never use feature datasets unless they're necessary (complex dataset types like topologies, UNs, and so on). Feature datasets mean shared locks, and although that generally has less of an impact in FGDBs than in EGDBs, it's just an unnecessary complication for what I consider minimal benefit.

Re: Best practices - feature datasets and capitalization for File Geodatabases

VinceAngelo — Wed, 12 Apr 2023 17:28:15 GMT

Case is a bit tricky -- Geodatabases are case-insensitive, but the enterprise geodatabase tables themselves require single-case (UPPER for Oracle, lower for others). ArcGIS clients will show the mixed-case alias for the tables, but Esri doesn't support the RDBMS extensions that allow actual mixed case (quotes around names, e.g., "MixedName").

I guess there is merit in using mixed case in aliases, since it will subtly allow you to detect if the table is registered.

- V

Re: Best practices - feature datasets and capitalization for File Geodatabases

LyonMNGIS — Mon, 17 Apr 2023 13:12:47 GMT

Thank you everyone for your responses. I also reviewed some of the links and it seems to me that there are set standards, but a lot of this is more of a personal preference. So here is what I am going to do but please let me know if I am wrong.

snake_case is better if we expect our data to be loaded into an RDBMS. ProperCase is okay.
The use of Feature Datasets is a matter of preference for GeoDatabases with a handful of layers, recommended when a Geodatabase has many layers, and required for complex datasets.
Singular is better than plural. - But this is going to be very hard for myself to change 🙂
Never use spaces, punctuation, or SQL statements.
Always use YYYYMMDD for dates.
Describe a relationship such as ParcelHasOwners.

Thank you again for your thoughts!