Export feature class based on values from two fields

GIS_geek — Tue, 30 Oct 2018 18:16:48 GMT

Good day,

I want to export a feature class to a feature class but only the ones that meet a certain criteria. I need values from field OWNER that are equal to LB and values from STATUS that are equal to ABN. I was able to export just one of the fields expression (OWNER) using AddFieldDelimiters, but I am not sure if this allows for an expression pointing to two fields. I tried adding a second field but only OWNER was successful and all values from STATUS were exported. Here is my script,

# Import system modules
import arcpy
from arcpy import env

# Set the workspace
arcpy.env.workspace = "Database Connections/ADMIN Edit.sde/SewerCollectionNetwork"
ArcSDE = arcpy.env.workspace
env.overwriteOutput = True

# Set local variables
inFeatures = "ssGravityMain"
outputLocation = "C:/Users/Navarro/Desktop/CAD"
outputDatabase = "CCTV.gdb"
outputDatabaseLocation = "C:/Users/Navarro/Desktop/CAD/CCTV.gdb"
outputFeatureClass = "GravityMain"
delimitedOwner = arcpy.AddFieldDelimiters(ArcSDE, "OWNER")
delimitedStatus = arcpy.AddFieldDelimiters(ArcSDE, "STATUS")
expressionOwner = delimitedOwner + " = 'LB'"
expressionStatus = delimitedStatus + " = 'ABN'"

# Creating new .gdb
print("Creating geodatabase")
arcpy.CreateFileGDB_management(outputLocation, outputDatabase)

# Export feature class to geodatabase
print("Exporting feature class to feature class")
arcpy.FeatureClassToFeatureClass_conversion(inFeatures, outputDatabaseLocation,
outputFeatureClass, expressionOwner)

Thank you in advance.

Re: Export feature class based on values from two fields

DanPatterson_Retired — Tue, 30 Oct 2018 18:25:53 GMT

You didn't try field mapping?

FieldMappings—ArcPy classes | ArcGIS Desktop

Re: Export feature class based on values from two fields

JakeSkinner — Sat, 11 Dec 2021 17:57:36 GMT

Hi Hector,

You could do the following:

expression = "OWNER = 'LB' AND STATUS = 'ABN'"

arcpy.FeatureClassToFeatureClass_conversion(inFeatures, outputDatabaseLocation,
outputFeatureClass, expression)‍‍‍‍

Re: Export feature class based on values from two fields

GIS_geek — Tue, 30 Oct 2018 20:48:53 GMT

Jake,

Thanks for the assistance.

topic Re: Export feature class based on values from two fields in Python Questions

Export feature class based on values from two fields

Re: Export feature class based on values from two fields

Re: Export feature class based on values from two fields

Re: Export feature class based on values from two fields