Hi, So I am trying to figure out how to get the date for a selected feature using the spatial location using arcpy. I keep running into an issue where the MakeFeatureLayer keeps returning an error and I am not sure as to why. I followed several examples and yet I still keep getting an error. I would greatly appreciate any help with this. import arcpy import os workspace = r 'Database Connections\Some Connection.sde' fcs = [ ] walk = arcpy . da . Walk ( workspace , datatype = "FeatureClass" ) Dist_LL = "Database Connections\Some.sde\FeatureClass" for dirpath , dirnames , filenames in walk : for filename in filenames : fcs . append ( os . path . join ( dirpath , filename ) ) for fc in fcs : geometryType = arcpy . Describe ( fc ) . shapeType print geometryType if geometryType == 'Point' : #Get feature class name fcsname = os . path . basename ( fc ) name = os . path . splitext ( fcsname ) y = name [ 1 ] . lstrip ( '.' ) print y #For fields in some feature classes fields = [ "OID@" , "LANDDISTRICT" , "LANDLOT" ] #Make feature layers arcpy . MakeFeatureLayer ( fc , 'fc' ) arcpy . MakeFeatureLayer ( Dist_LL , 'Dist_LL' ) for row in arcpy . da . SearchCursor ( fc , fields ) : if row [ 1 ] is None : arcpy . SelectLayerByLocation_management ( fc_layer , 'INTERSECT' , Dist_LL_lyr ) select_records = arcpy . da . SearchCursor ( Dist_LL_lyr ) print select_records print row elif row [ 2 ] is None : print row else : continue Robert

Never mind about the error. I came up with this solution and it seems to work. feature_layer = arcpy . MakeFeatureLayer_management ( fc , str ( y + '_layer' ) )

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

Trouble with selecting features by location using arcpy?

RPGIS

Hi,

So I am trying to figure out how to get the date for a selected feature using the spatial location using arcpy. I keep running into an issue where the MakeFeatureLayer keeps returning an error and I am not sure as to why. I followed several examples and yet I still keep getting an error. I would greatly appreciate any help with this.

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">import</SPAN> os

workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'Database Connections\Some Connection.sde'</SPAN>
fcs <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
walk <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>Walk<SPAN class="punctuation token">(</SPAN>workspace<SPAN class="punctuation token">,</SPAN> datatype<SPAN class="operator token">=</SPAN><SPAN class="string token">"FeatureClass"</SPAN><SPAN class="punctuation token">)</SPAN>

Dist_LL <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Database Connections\Some.sde\FeatureClass"</SPAN>
<SPAN class="keyword token">for</SPAN> dirpath<SPAN class="punctuation token">,</SPAN> dirnames<SPAN class="punctuation token">,</SPAN> filenames <SPAN class="keyword token">in</SPAN> walk<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> filename <SPAN class="keyword token">in</SPAN> filenames<SPAN class="punctuation token">:</SPAN>
        fcs<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>dirpath<SPAN class="punctuation token">,</SPAN> filename<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">for</SPAN> fc <SPAN class="keyword token">in</SPAN> fcs<SPAN class="punctuation token">:</SPAN>
    geometryType <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>Describe<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>shapeType
    <SPAN class="keyword token">print</SPAN> geometryType
    <SPAN class="keyword token">if</SPAN> geometryType <SPAN class="operator token">==</SPAN> <SPAN class="string token">'Point'</SPAN><SPAN class="punctuation token">:</SPAN>

        <SPAN class="comment token">#Get feature class name</SPAN>
        fcsname <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>basename<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">)</SPAN>
        name <SPAN class="operator token">=</SPAN> os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>splitext<SPAN class="punctuation token">(</SPAN>fcsname<SPAN class="punctuation token">)</SPAN>
        y <SPAN class="operator token">=</SPAN> name<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>lstrip<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'.'</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="keyword token">print</SPAN> y

        <SPAN class="comment token">#For fields in some feature classes</SPAN>
        fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"OID@"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"LANDDISTRICT"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"LANDLOT"</SPAN><SPAN class="punctuation token">]</SPAN>

        <SPAN class="comment token">#Make feature layers</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fc'</SPAN><SPAN class="punctuation token">)</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer<SPAN class="punctuation token">(</SPAN>Dist_LL<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Dist_LL'</SPAN><SPAN class="punctuation token">)</SPAN>
        
        <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> fields<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">is</SPAN> None<SPAN class="punctuation token">:</SPAN>
                arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByLocation_management <SPAN class="punctuation token">(</SPAN>fc_layer<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'INTERSECT'</SPAN><SPAN class="punctuation token">,</SPAN> Dist_LL_lyr<SPAN class="punctuation token">)</SPAN>
                select_records <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>Dist_LL_lyr<SPAN class="punctuation token">)</SPAN>
                <SPAN class="keyword token">print</SPAN> select_records
                <SPAN class="keyword token">print</SPAN> row
            <SPAN class="keyword token">elif</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">is</SPAN> None<SPAN class="punctuation token">:</SPAN>
                <SPAN class="keyword token">print</SPAN> row
            <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
                <SPAN class="keyword token">continue</SPAN>‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Robert

Encontre mais publicações marcadas com

Accepted answers

RPGIS

Never mind about the error. I came up with this solution and it seems to work.

feature_layer <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> str<SPAN class="punctuation token">(</SPAN>y <SPAN class="operator token">+</SPAN> <SPAN class="string token">'_layer'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

All comments

bixb0012

You had a couple different issues come up in this thread, but please mark the one that helped the most as correct to close the thread out.

RPGIS

Never mind about the error. I came up with this solution and it seems to work.

feature_layer <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> str<SPAN class="punctuation token">(</SPAN>y <SPAN class="operator token">+</SPAN> <SPAN class="string token">'_layer'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

RPGIS

Hi Micah,

Here is the updated portion of the script. I am trying to figure out a solution to just return the selected records in the Dist_LL layer based on the number of selected records in fc.

for fc in fcs:
    geometryType = arcpy.Describe(fc).shapeType
    print geometryType
    if geometryType == 'Point':

        #Get feature class name
        fcsname = os.path.basename(fc)
        name = os.path.splitext(fcsname)
        y = name[1].lstrip('.')
        print y

        #Get these fields from feature classes
        fields = ["OID@", "LANDDISTRICT", "LANDLOT"]

        for row in arcpy.da.SearchCursor(fc, fields):
            if row[1] is None:
                arcpy.MakeFeatureLayer_management(fc, 'fc_layer')
                arcpy.SelectLayerByLocation_management('fc_layer', 'INTERSECT', 'DistLL_layer')
                for DLrow in arcpy.da.SearchCursor('DistLL_layer', ["LAND_DIST", "LAND_LOT"]):
                    print DLrow
                print row
            elif row[2] is None:
                print row
            else:
                continue‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

I am not sure if the problem lies with the way the search cursor is ran or if it was even set up to return the selected features. I will try to modify this to see if I can get the correct result to return, but I am not sure how to get there.

Also, I keep receiving this error message for some reason and I don't know how to offset this error. It occurs every time and I don't know if it is the way it is nested or if it is due to not being deleted. I will try a couple of things to see if I can correct this but this error is new to me. Any assistance on this would also be greatly appreciated.

Traceback <SPAN class="punctuation token">(</SPAN>most recent call last<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
  File <SPAN class="string token">"U:\Models_Tools\Scripts related to Landlot and District\Populate Landlot and District.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">31</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> <SPAN class="operator token"><</SPAN>module<SPAN class="operator token">></SPAN>
    arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>fc<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'fc_layer'</SPAN><SPAN class="punctuation token">)</SPAN>
  File <SPAN class="string token">"C:\Program Files (x86)\ArcGIS\Desktop10.6\ArcPy\arcpy\management.py"</SPAN><SPAN class="punctuation token">,</SPAN> line <SPAN class="number token">6993</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> MakeFeatureLayer
    <SPAN class="keyword token">raise</SPAN> e
ExecuteError<SPAN class="punctuation token">:</SPAN> Failed to execute<SPAN class="punctuation token">.</SPAN> Parameters are <SPAN class="operator token">not</SPAN> valid<SPAN class="punctuation token">.</SPAN>
ERROR <SPAN class="number token">000725</SPAN><SPAN class="punctuation token">:</SPAN> Output Layer<SPAN class="punctuation token">:</SPAN> Dataset fc_layer already exists<SPAN class="punctuation token">.</SPAN>
Failed to execute <SPAN class="punctuation token">(</SPAN>MakeFeatureLayer<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Thank you very much for your help Micah.

Robert

RPGIS

Thanks Micah,

I can't believe something that simple had slipped past me. I will make those changes and see if that fixes the issue.

MicahBabinski

Gotta include the '_management' bit to get the proper syntax. See the examples:

Make Feature Layer—Help | ArcGIS for Desktop

RPGIS

Hi Randy,

Here is the error message that I receive.

Traceback (most recent call last):
File "U:\Models_Tools\Scripts related to Landlot and District\Populate Landlot and District.py", line 17, in <module>
arcpy.MakeFeatureLayer(fc, 'fc_layer')
AttributeError: 'module' object has no attribute 'MakeFeatureLayer'

RandyBurton

And the error message is?

Participe da Conversa

Membros conectados podem postar, seguir atualizações e mais. Novo aqui? Registre uma conta gratuita.

Entrar
Registrar

Links Rápidos

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