Select to view content in your preferred language

Best practices - feature datasets and capitalization for File Geodatabases

1147
6
04-11-2023 02:10 PM
Labels (1)
LyonMNGIS
Occasional Contributor III

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

 

0 Kudos
6 Replies
DanPatterson
MVP Esteemed Contributor

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)


... sort of retired...
0 Kudos
jcarlson
MVP Esteemed Contributor

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.

- Josh Carlson
Kendall County GIS
Bud
by
Notable Contributor
MobiusSnake
MVP

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.

VinceAngelo
Esri Esteemed Contributor

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

LyonMNGIS
Occasional Contributor III

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!

 

 

0 Kudos