I have inherited a file geodatabase containing a number of feature classes (points, lines and polygons), where many fields are common. For example all feature classes contain the following fields, and the fields should have the same settings:
- Asset_ID – should all be long numeric format with alias Asset ID
- GIS_ID – should all be Text with length 30 with alias GIS ID
- Asset_Class should be Text with length 20, alias Asset Class and Domain cvdAssetClass
I want a way to export to the field properties (Field Name, Alias, Data Type, Allow NULL, Number format, Domain, Default and Length) to a CSV or spreadsheet so I can check that all the layers are correct.
I am using ArcGIS Pro to look at the geodatabase. I have tried the "Table to Excel" command previously and combined the files and identified errors in Field Names, but I cant figure out how to confirm all the the settings are exactly the same.
Typically we export the feature classes for use in non-spatial programs, and it is important that the schemas are perfect to avoid errors when importing to the other software
Best Answer
If you are familiar with ArcPy/Python you can use ListFields. Create a list of field objects and use their properties/methods. Then create some logic to check all properties you want. Example how to access names, types, alias, etc.: