nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Identify feature class within feature dataset

MikeLouwrens

I have a list of feature class names I want to feed into a script, and one of the things I need the script to do is determine whether each feature class is held within a feature dataset (as then the script will treat the FC differently).

Using Describe I can identify feature classes and feature datasets, however I cannot determine whether a FC is within a FD. I can list children of a FD, but not parent of FC.

Is there another way I can easily determine whether a specified FC is held in a FD?

The list of FCs is output from a third-party table, so doesn't reference feature datasets. The FCs are contained in a database that has many feature datasets and hundreds of feature classes. While I know I could Describe all the FDs in my database and compare the children to my list, I imagine this would take a long time, when my list only contains about 60 FDs and only about 15 of them are in FDs.

EDIT: If possible I would like to determine the name of the Feature Dataset, not just if there is one. Data is in a SDE Geodatabase (SQL Server)

Thanks,
Mike.

Message was edited by: Mike Louwrens

Vind meer berichten getagd met

Accepted answers

All comments

DarrenWiens2

You can list feature classes in your gdb. This won't go into feature datasets. If it's in the list, it isn't in a feature dataset. If it's not in the list, presumably it is in a feature dataset (or doesn't exist).

Please elaborate if this doesn't address your issue.

FreddieGibson

Could you provide a little more detail on how you're using the describe object against the feature classes? I would assume if you're to the point where you can describe the feature class you could also grab the path to the feature class on disk and check against it.

MikeLouwrens

Freddie Gibson:
Could you provide a little more detail on how you're using the describe object against the feature classes? I would assume if you're to the point where you can describe the feature class you could also grab the path to the feature class on disk and check against it.

Currently I'm not really using the describe other than testing ways to get the FD. The data is in a SDE geodatabase so when I have tried using describe to get a path, no FD is ever listed (maybe I'm doing this wrong?)

Is there a describe option that would tell me the full path including the FD?

Cheers,

Mike.

MikeLouwrens

Freddie Gibson:
You can list feature classes in your gdb. This won't go into feature datasets. If it's in the list, it isn't in a feature dataset. If it's not in the list, presumably it is in a feature dataset (or doesn't exist).
Please elaborate if this doesn't address your issue.

That might work, although not ideal. I should probably have said in my original post that I'd like to know which FD the FC is in.

Cheers,

Mike.

DarrenWiens2

I'm unclear how you can describe a feature class and not know its path. The path tells you if it's in a feature dataset. Isn't this the case in SDE feature classes (obviously, I don't use SDE)?

WesMiller

import arcpy,os
fc = "your file"
h,n = os.path.split(fc)
desc = arcpy.Describe(h)
print desc.datasetType
print desc.name

FreddieGibson

Could you upload some of your code so I can get a better picture of what you're doing? For the most part whether you're working in an enterprise geodatabase or a local geodatabase (i.e. file or person) the workflow shouldn't differ. In order to use the describe object you'd need to have a reference to the dataset, whether it be the direct path to it or a layer that points to the data. That's why I'm a little confused on getting the path if you're able to get to this point. Hopefully by looking at your logic will help me fill in some of the blanks so that we can give you a solid answer for this.

MikeLouwrens

Hi Freddie,

sorry I currently don't really have any code - first thing I was trying to do was get Describe or something to identify the FD a FC was in, if any, so haven't actually written the script yet. I can send you the few lines of different Describe options I have tried, but so far none of them have told me which FD the FC is in. I'll be back in the office tomorrow, so will post that then.

Cheers,

MIke.

MikeLouwrens

Attached is all my code so far - have only attempted to find the Feature Dataset for the feature class so far, so not much to it. Using the help from Describe object properties—Help | ArcGIS for Desktop (and some of the other Describe Properties that appear to fit)

import arcpy, os

SDEDatabase = "Database Connections\\GISDatabase.sde"

## SWServiceLine is a Feature Class contained in a Feature Dataset called "StormWater",
## however my list of Feature Classes does not (and can not) identify if a particular 
## Feature Class is within a Feature Dataset and the name of the Feature Dataset if relevant
fc = SDEDatabase + "\\SWServiceLine"
tester = arcpy.Describe(fc)

## Describe options from ArcGIS desktop help.  Potentially there is one that
## tells me the Feature Dataset that contains the Feature Class, but
## I haven't found one yet
if hasattr(tester, "name"):
  print "Name:               " + tester.name
if hasattr(tester, "dataElementType"):
  print "dataElementType:    " + tester.dataElementType
if hasattr(tester, "catalogPath"):
  print "CatalogPath:        " + tester.catalogPath
if hasattr(tester, "Path"):
  print "Path:               " + tester.path
if hasattr(tester, "datasetType"):
  print "DatasetType:        " + tester.datasetType
if hasattr(tester, "baseName"):
  print "BaseName:           " + tester.baseName

## As suggested by Wes Miller
h, n = os.path.split(fc)
desc = arcpy.Describe(h)
#print desc.datasetType      ## this produces an error
print desc.name

I've been through a lot of the describe properties, but so far I haven't found any that tell me a) if the feature class is in a feature dataset or b) the name of the feature dataset.

Cheers,

Mike.

MikeLouwrens

Darren Wiens:
I'm unclear how you can describe a feature class and not know its path. The path tells you if it's in a feature dataset. Isn't this the case in SDE feature classes (obviously, I don't use SDE)?

Hi Darren,

You don't need to specify the Feature Dataset in a path to a Feature Class (works the same way in a file/personal geodatabase as in SDE). So as a result I can script things to happen to those feature classes without referring to the feature dataset at all. However in this case I need to know which Feature Dataset contains each Feature Class, if any.

Cheers,

Mike.

Luke_Pinner

I had a quick look at this and I *think* Darren Wiens is right, arcpy.da.Walk (or a combination of arcpy.ListDatasets() and arcpy.ListFeatureClasses() etc.) is the only way to get the Feature Dataset name if you only know the Feature Class name at runtime:

Something like:

import arcpy,os
gdb = r"C:\Temp\Default.gdb"
fcs = ["TESTFC",   # standalone FC
       "TESTFDFC"] # FC in a feature dataset

def get_paths(path):
    """Use this if you have multiple FCs to check"""
    paths = {}
    for dirname,subdirs,files in arcpy.da.Walk(path):
        paths.update(zip(files, [os.path.basename(dirname.replace(path,""))]*len(files)))
    return paths

def get_fd(fc):
    """Use this if you only have one FC to check"""
    path = os.path.normpath(os.path.dirname(fc))
    if  path == ".":
        path = arcpy.env.workspace
    for dirname,subdirs,files in arcpy.da.Walk(path):
        if fc in files:
            return os.path.basename(dirname.replace(path,""))

arcpy.env.workspace = gdb
paths = get_paths(gdb)
for fc in fcs:
    print os.path.join(paths[fc], fc)
    print os.path.join(get_fd(fc), fc)

TESTFC
TESTFC
TESTFD\TESTFDFC
TESTFD\TESTFDFC

KevinMorrissey

at least within the sql tables, the gdb_items indicates the Name, and the Path which contains the fds address if it applies...

The gdb_itemrelationships would be more detailed, but as I understand, this might be enough, perhaps?

This was a helpful link in identifying this...

Feature datasets in a geodatabase in SQL Server—Help | ArcGIS for Desktop

Doe mee aan het gesprek

Aangemelde leden kunnen berichten plaatsen, updates volgen en meer. Nieuw hier? Registreer een gratis account.

Snelle Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.