topic Re: Geodatabase - Copy Featureclass Names to Excel in ArcGIS Pro Questions

Geodatabase - Copy Featureclass Names to Excel

sdavidson — Wed, 11 Sep 2024 12:38:41 GMT

I was given access to an enterprise feature database. I would like to systematically go through the featureclasses in the database to determine how they work together. My plan was to take a list of the featureclasses and keep notes on where different information is stored, then I can reference this as I figure out how the pieces fit together.

My plan was to copy the list into excel and start putting notes on what each featureclass contains, and then use this as a reference as I figure out how the different featureclasses work together. Is there a way to copy the list to a text file, export as csv, or just copy into excel?

At this point I will simply be copying each name into excel, but there must be a quicker way.

Re: Geodatabase - Copy Featureclass Names to Excel

RichardHowe — Thu, 12 Sep 2024 08:41:00 GMT

Tiny bit of python will get you where you need to be:

ListFeatureClasses is your friend

There's an example at the bottom of the help page. You can print your result to the python window in Pro and copy and paste the whole thing to excel

Re: Geodatabase - Copy Featureclass Names to Excel

Bud — Thu, 12 Sep 2024 08:59:24 GMT

What version of Pro?

3.2 has a new Generate Schema Report tool. @JonathanMurphy

What kind of database? Oracle, SQL Server, or PostgreSQL?

If I remember correctly, there is a geodatabase system table called GDB_ITEMS in the SDE owner (Oracle) that has a list of GDB tables.

There are also Oracle system tables.

for all views (you need dba privileges for this query)
select view_name from dba_views
for all accessible views (accessible by logged user)
select view_name from all_views
for views owned by logged user
select view_name from user_views
https://stackoverflow.com/a/13742917/5576771

Re: Geodatabase - Copy Featureclass Names to Excel

ChrisUnderwood — Thu, 12 Sep 2024 08:56:25 GMT

Hello @sdavidson , in your Enterprise Geodatabase there will be a table called SDE.sde_layers (or DBO.sde_layers SDE.layers or similar depending on your database type). The table_name column will give you a list of all the registered datasets which will be like your list of Feature Classes.

select table_name from [database].[sde].[SDE_layers] order by owner, table_name