topic Re: Enterprise Geodatabase feature class naming in Python Questions

Enterprise Geodatabase feature class naming

Boyang_Wang — Fri, 11 Feb 2022 15:12:04 GMT

Hi,

Not sure if this is typical, but whenever I create a feature class in my enterprise geodatabase, its name will have the database and username added. For example, if I create a feature class called FC, its name will become "database.username.FC".

This creates a problem when I try to use python to backup my enterprise geodatabase feature classes using FeatureClassToFeatureClass. I don't want my backup feature class name has "database.username." in it. How can I get the feature class name only without using string manipulation?

Thanks!

Re: Enterprise Geodatabase feature class naming

KimberlyGarbade — Fri, 11 Feb 2022 16:53:48 GMT

For enterprise GDBs (at least in SQL Server in my case) this is common, but usually its not an issue, although I haven't tried Feature Class to Feature Class backup using a python script. That being said....

In Python the output name is an input into the Feature Class to Feature Class function:

arcpy.conversion.FeatureClassToFeatureClass(in_features, out_path, out_name, {where_clause}, {field_mapping}, {config_keyword})

So if you have a variable something like txtInFeatures (to use as the 'in_features' in the function reference above) and its value is in the form "DatabaseName.Owner.FeatureClassName", I would use something like this to generate the txtOutName (to use as the 'out_name' in the function reference above)

txtOutName = txtInFeatures[txtInFeatures.rindex('.')+1:]

below is a snip of a test I ran in a python emulator. Code on the left, result on the right.

Hope this helps.

Re: Enterprise Geodatabase feature class naming

Boyang_Wang — Fri, 11 Feb 2022 17:19:27 GMT

This works great as I can use the same code for different database names and owner names. Thanks!