topic Re: SelectLayerByAttribute into personal or file database in ArcMap Questions

SelectLayerByAttribute into personal or file database

JeffHouser — Thu, 11 May 2023 04:31:21 GMT

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

Re: SelectLayerByAttribute into personal or file database

JoshuaSharp-Heward — Thu, 11 May 2023 05:23:01 GMT

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.

Re: SelectLayerByAttribute into personal or file database

JeffHouser — Mon, 15 May 2023 14:10:46 GMT

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

Re: SelectLayerByAttribute into personal or file database

JoshuaSharp-Heward — Mon, 15 May 2023 19:13:47 GMT

Hi Jeff,

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

Cheers,

Josh

Re: SelectLayerByAttribute into personal or file database

JeffHouser — Tue, 16 May 2023 05:11:57 GMT

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

Re: SelectLayerByAttribute into personal or file database

JoshuaSharp-Heward — Tue, 16 May 2023 05:24:21 GMT

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