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; } } }

SelectLayerByAttribute into personal or file database

JeffHouser

Hello,

I have successfully used the arcpy.SelectLayerByAttribute_management function, and sent the results to a shapefile using the following code:

arcpy.SelectLayerByAttribute_management(fc + "_new", 'NEW_SELECTION', SetQuery)
# Write the selected features to a new featureclass to the
# defined "out_path"
outfc = os.path.join(out_path, fc + "_Edited")
arcpy.CopyFeatures_management(fc + "_new", outfc)

What do I need to do if I want to send the results into a created personal or file database using the following code?

arcpy.management.CreateFileGDB(out_path, "NewForestGIS.gdb")

Thank You for your help

-Jeff

Find more posts tagged with

Desktop

Accepted answers

JoshuaSharp-Heward

Hi Jeff,

I think it should just work as is if you replace the out_path in your "outfc" line with the path to the new geodatabase (including the name of the geodatabase NewForestGIS.gdb). I'm pretty sure CopyFeatures defaults to outputting as a shapefile if it's writing to a folder and a feature class if it's writing to a geodatabase.

All comments

JoshuaSharp-Heward

Hi Jeff,

Think you may have marked the wrong reply as the solution, but I'm glad to hear that it's all working for you now as you hoped 🙂 happy to help out!

Josh

JeffHouser

Hello Joshua, I tried a couple of times, and it still failed. On the third attempt, with your suggested change, it worked 😄 Hurray!

Thank You Joshua.

-Jeff

JoshuaSharp-Heward

Hi Jeff,

Feel free to post your code and what's going wrong and I can review it for you!

Cheers,

Josh

JeffHouser

Hello Joshua,

Thank you so much for your reply with information how to create a featureclass in a personal or filedatabase. Using your suggestion, I did spend a couple of hours with the program last Thursday (I only work Mon-Thurs). I was not successful. Your solution must be correct, I just a need a little more time with the code and see why its not working. Once I get the code to work, I will update "accept as solution". Sorry for the delay.

-Jeff

JoshuaSharp-Heward

Hi Jeff,

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

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