Slide 8 of 23
Notes:
Using a single SDE database presents logistical challenges with respect to data access. This image shows an example of the connection dialog for ESRI’s ArcMap software. The potentially large number of SDE themes makes it difficult for users to identify which themes to use.
KGS developed a table naming schema to alleviate this problem. Thematic groupings are added to SDE tables named with a four character code (e.g., COAL, GEOL). Feature classes are named with a two letter state prefix, followed by a three character scale integer, and a meaningful theme name. This format results in a connection list that is sorted by theme type, followed by scale and name, with each designation nearly in vertical alignment.
Most RDBMS systems limit such table names to approximately 32 characters.