topic Re: How could I get information to know which tables used for each layer ? in ArcMap Questions

How could I get information to know which tables used for each layer ?

spiderman90 — Mon, 08 May 2023 01:29:43 GMT

I would like to get information from each layer .

Each feature class read different data from different tables at my database .

How could I get information to know which tables used for each layer in ArcMap ?

Re: How could I get information to know which tables used for each layer ?

DavidPike — Mon, 08 May 2023 10:28:39 GMT

Double click on the layer in the table-of-contents (or right click -> properties) to open the layer properties window.

Then go to the 'Source' tab at the top. There you can see the data source the layer is reading from

https://desktop.arcgis.com/en/arcmap/latest/map/working-with-layers/repairing-broken-data-links.htm

If you need to see the sources for all layers in the MXD or across multiple MXDs you can use a simple python script https://community.esri.com/t5/python-questions/script-to-print-all-data-layer-names-and-sources/td-p/203713

Re: How could I get information to know which tables used for each layer ?

JeffHouser — Mon, 08 May 2023 14:59:42 GMT

Hello SM90, I have not tried the following ArcPy Code. I just did a quick search online and found the following:

Actual feature class names (as in the data source names).
https://gis.stackexchange.com/questions/423776/listing-all-feature-classes-from-an-arcgis-project-file-from-the-data-source

import arcpy
import os
import glob
import pandas as pd

# ArcPro = arpx
# ArcMap = mxd
aprx_dir = r'H:\007_Services-GV\02_GV_Updates\2201xx_Engineering\*.aprx'

aprx_dict = {}

for aprx_file in glob.glob(aprx_dir):
aprx = arcpy.mp.ArcGISProject(aprx_file)
for m in aprx.listMaps():
print (aprx_file)
for layer in m.listLayers():
print(layer.dataSource)

I hope this helps,

-Jeff

Re: How could I get information to know which tables used for each layer ?

RhettZufelt — Mon, 08 May 2023 15:09:29 GMT

In the table of contents, you can also list by data source:

Re: How could I get information to know which tables used for each layer ?

spiderman90 — Mon, 08 May 2023 18:35:27 GMT

Thanks for ur reply .

I have looked to data source and it show me the name of feature dataset and name feature class .

but feature class data collected from different tables .

i would like to get the name of tables that used to provide the data to this feature class .

How could I get the name of them for each feature class ?

Re: How could I get information to know which tables used for each layer ?

spiderman90 — Mon, 08 May 2023 18:37:01 GMT

It shows me only the feature dataset but I need to know the name of tables the provide data for each feature class or feature dataset ? How could I get table names ?

Re: How could I get information to know which tables used for each layer ?

spiderman90 — Mon, 08 May 2023 18:38:13 GMT

Thanks for the code.I thik the idea here to get the name of layers but I am looking to find the table names that provide data for each layer ?how could I achieve it ?

Re: How could I get information to know which tables used for each layer ?

RhettZufelt — Mon, 08 May 2023 18:54:01 GMT

Are you talking about joined/related tables?

Basically, in my example above, "Centerlines" is a table in the geodatabase. It also has shape field holding the geometry so Arc can display it as a feature class when added.

So, the table "name" would be "Centerlines". If you right-click on it and open attribute table you can view it.

Re: How could I get information to know which tables used for each layer ?

DavidPike — Mon, 08 May 2023 19:22:53 GMT

Not if the layer name has been changed in the TOC.

Re: How could I get information to know which tables used for each layer ?

RhettZufelt — Mon, 08 May 2023 19:29:19 GMT

Or if you have an Alias set on it. That is why I used Centerlines as example, not Urban Growth Area (that is alias, but, it IS the table alias).

Just trying to clarify what a table that provides data for a layer is.....

Re: How could I get information to know which tables used for each layer ?

spiderman90 — Mon, 08 May 2023 23:28:32 GMT

As your example , you have centerlines as table .

but in my case , the name here is not the same name of table at my database .

May be 5 tables are providing data for layer and other layer get the data from others tables .

in my case ,if I select on a cable as example then check the log file .

It shows me in the log file, that many functions used to show the data on cable .

select * from table a

select * from table b

……….

i mean , each layer getting the data from different tables at my database ,how could I see that tables name that joined to bring the data on layer ?

Re: How could I get information to know which tables used for each layer ?

RhettZufelt — Mon, 08 May 2023 23:52:41 GMT

So, sounds like maybe you have a combination of layer with joins and/or views going on.

List by source will show you all layers AND tables that are currently loaded into your map document (image show View, Table, and Feature Class):

You can right click the layer in ArcMap, properties, source tab to show you the layer/table name/location:

If you have joins or relates, you can look in the Joins and Relates tab to see what tables are joined or related:

For views, you can find the data location in the source tab, then get properties in ArcCatalog, the definition will show the SQL that creates the view:

And if you have relationship classes set up in the database, you can get that info from the Relationships tab in the properties in ArcCatalog.