I am new to coding in python, my problems is the machine crashing halfway through first loop, and yet another five with its modules . i have "Serious Application Error" with the opportunity to send info to Esri. i use script in toolbox, i have arcmap 10.6 . Thanks.

While experimenting with a line shape file, I realized that you do not need to convert the .dbf table to a text file to make use MakeXYEventLayer if it contains X and Y values. For my experiment, I created some lines and save them as a shape file. I used AddGeometryAttributes to add an XY value for the mid-point of the line. The .dbf and .prj files were used to create a point feature. Perhaps the test code will give you some ideas for your project. import arcpy , os arcpy . env . workspace = r 'C:\Users\Randy\Documents\ArcGIS\PythonScripts\test\rbTest' arcpy . env . overwriteOutput = True dbf = 'line_test.dbf' # shape file data table sr = arcpy . SpatialReference ( os . path . join ( arcpy . env . workspace , 'line_test.prj' ) ) # shape file spatial reference # print sr.name, sr.factoryCode FieldX1 = 'MID_X' # midpoint of line feature FieldY1 = 'MID_y' FieldZ1 = None outShape = 'point_test.shp' points = arcpy . MakeXYEventLayer_management ( dbf , FieldX1 , FieldY1 , 'points' , sr , FieldZ1 ) # make a point layer result = arcpy . FeatureClassToFeatureClass_conversion ( points , arcpy . env . workspace , outShape ) print result '' ' # Replace a layer/table view name with a path to a dataset (which can be a layer file) or create the layer/table view within the script # The following inputs are layers or table views: "line_test" CENTROID - Adds attributes to store the centroid coordinates of each feature . ( CENTROID_X , CENTROID_Y ) CENTROID_INSIDE - Adds attributes to store the coordinates of a central point inside or on each feature . ( INSIDE_X , INSIDE_Y ) LINE_START_MID_END - Adds attributes to store the coordinates of the start , mid , and end points of each feature . ( START_X , START_Y , MID_X , MID_Y , END_X , END_Y ) LINE_BEARING - Adds an attribute to store the start - to - end bearing of each line feature . Values range from 0 to 360 , with 0 meaning north , 90 east , 180 south , 270 west , and so on . ( BEARING ) arcpy . AddGeometryAttributes_management ( Input_Features = "line_test" , Geometry_Properties = "LINE_START_MID_END;CENTROID;CENTROID_INSIDE;LINE_BEARING" , Length_Unit = "" , Area_Unit = "" , Coordinate_System = "" ) '' ' Hope this helps.

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

MakeXYEventLayer or FeatureClassToFeatureClass_conversion Cause Crash

guillaumemure

I am new to coding in python, my problems is the machine crashing halfway through first loop, and yet another five with its modules Script .

i have "Serious Application Error" with the opportunity to send info to Esri.

i use script in toolbox, i have arcmap 10.6 .

Thanks.

Trouver plus de publications taguées avec

Accepted answers

All comments

RandyBurton

While experimenting with a line shape file, I realized that you do not need to convert the .dbf table to a text file to make use MakeXYEventLayer if it contains X and Y values. For my experiment, I created some lines and save them as a shape file. I used AddGeometryAttributes to add an XY value for the mid-point of the line. The .dbf and .prj files were used to create a point feature. Perhaps the test code will give you some ideas for your project.

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

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:\Users\Randy\Documents\ArcGIS\PythonScripts\test\rbTest'</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>

dbf <SPAN class="operator token">=</SPAN> <SPAN class="string token">'line_test.dbf'</SPAN> <SPAN class="comment token"># shape file data table</SPAN>
sr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SpatialReference<SPAN class="punctuation token">(</SPAN>os<SPAN class="punctuation token">.</SPAN>path<SPAN class="punctuation token">.</SPAN>join<SPAN class="punctuation token">(</SPAN>arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="punctuation token">,</SPAN><SPAN class="string token">'line_test.prj'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># shape file spatial reference</SPAN>

<SPAN class="comment token"># print sr.name, sr.factoryCode</SPAN>

FieldX1 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'MID_X'</SPAN> <SPAN class="comment token"># midpoint of line feature</SPAN>
FieldY1 <SPAN class="operator token">=</SPAN> <SPAN class="string token">'MID_y'</SPAN>
FieldZ1 <SPAN class="operator token">=</SPAN> None

outShape <SPAN class="operator token">=</SPAN> <SPAN class="string token">'point_test.shp'</SPAN>

points <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeXYEventLayer_management<SPAN class="punctuation token">(</SPAN>dbf<SPAN class="punctuation token">,</SPAN> FieldX1<SPAN class="punctuation token">,</SPAN> FieldY1<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'points'</SPAN><SPAN class="punctuation token">,</SPAN> sr<SPAN class="punctuation token">,</SPAN> FieldZ1<SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># make a point layer</SPAN>

result <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>FeatureClassToFeatureClass_conversion<SPAN class="punctuation token">(</SPAN>points<SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="punctuation token">,</SPAN> outShape<SPAN class="punctuation token">)</SPAN>

<SPAN class="keyword token">print</SPAN> result

<SPAN class="string token">''</SPAN>'
<SPAN class="comment token"># Replace a layer/table view name with a path to a dataset (which can be a layer file) or create the layer/table view within the script</SPAN>
<SPAN class="comment token"># The following inputs are layers or table views: "line_test"</SPAN>

CENTROID <SPAN class="operator token">-</SPAN> Adds attributes to store the centroid coordinates of each feature<SPAN class="punctuation token">.</SPAN>
  <SPAN class="punctuation token">(</SPAN>CENTROID_X<SPAN class="punctuation token">,</SPAN> CENTROID_Y<SPAN class="punctuation token">)</SPAN>
  
CENTROID_INSIDE <SPAN class="operator token">-</SPAN> Adds attributes to store the coordinates of a central point inside <SPAN class="operator token">or</SPAN> on each feature<SPAN class="punctuation token">.</SPAN>
  <SPAN class="punctuation token">(</SPAN>INSIDE_X<SPAN class="punctuation token">,</SPAN> INSIDE_Y<SPAN class="punctuation token">)</SPAN>

LINE_START_MID_END <SPAN class="operator token">-</SPAN> Adds attributes to store the coordinates of the start<SPAN class="punctuation token">,</SPAN> mid<SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">and</SPAN> end points of each feature<SPAN class="punctuation token">.</SPAN>
  <SPAN class="punctuation token">(</SPAN>START_X<SPAN class="punctuation token">,</SPAN> START_Y<SPAN class="punctuation token">,</SPAN> MID_X<SPAN class="punctuation token">,</SPAN> MID_Y<SPAN class="punctuation token">,</SPAN> END_X<SPAN class="punctuation token">,</SPAN> END_Y<SPAN class="punctuation token">)</SPAN>

LINE_BEARING <SPAN class="operator token">-</SPAN> Adds an attribute to store the start<SPAN class="operator token">-</SPAN>to<SPAN class="operator token">-</SPAN>end bearing of each line feature<SPAN class="punctuation token">.</SPAN>
Values range <SPAN class="keyword token">from</SPAN> <SPAN class="number token">0</SPAN> to <SPAN class="number token">360</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">with</SPAN> <SPAN class="number token">0</SPAN> meaning north<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">90</SPAN> east<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">180</SPAN> south<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">270</SPAN> west<SPAN class="punctuation token">,</SPAN> <SPAN class="operator token">and</SPAN> so on<SPAN class="punctuation token">.</SPAN>
  <SPAN class="punctuation token">(</SPAN>BEARING<SPAN class="punctuation token">)</SPAN>
  
arcpy<SPAN class="punctuation token">.</SPAN>AddGeometryAttributes_management<SPAN class="punctuation token">(</SPAN>
    Input_Features<SPAN class="operator token">=</SPAN><SPAN class="string token">"line_test"</SPAN><SPAN class="punctuation token">,</SPAN>
    Geometry_Properties<SPAN class="operator token">=</SPAN><SPAN class="string token">"LINE_START_MID_END;CENTROID;CENTROID_INSIDE;LINE_BEARING"</SPAN><SPAN class="punctuation token">,</SPAN>
    Length_Unit<SPAN class="operator token">=</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> Area_Unit<SPAN class="operator token">=</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">,</SPAN> Coordinate_System<SPAN class="operator token">=</SPAN><SPAN class="string token">""</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="string token">''</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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Hope this helps.

RandyBurton

The additional information is helpful. Could you share a sample of what the Mobilier_Urbain_L.shp file is like? Also, is it safe to assume that all your shape files use the same format?

I noticed that the FieldX1 used in the MakeXYEventLayer may be the field name and probably should be quoted. I am assuming there is a field in the shape file with this name. If not, you would need to set it to the field's name, such as FieldX1 = 'XfieldName'.

arcpy<SPAN class="punctuation token">.</SPAN>MakeXYEventLayer_management<SPAN class="punctuation token">(</SPAN>OutTxtMob<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'FieldX1'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'FieldY1'</SPAN><SPAN class="punctuation token">,</SPAN> OutTempMob<SPAN class="punctuation token">,</SPAN> ParemSpat<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'FieldZ1'</SPAN><SPAN class="punctuation token">)</SPAN>  ‍‍<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

guillaumemure

I need to transform lines into points, because my X1Y1 are the center of the objects and X2Y2 allows me to calculate the orientation of the future symbol

is it possible to do it with makeFeature?

RandyBurton

Thank you for the additional description of your project. I am still trying to understand the work flow.

Is arcpy.GetParameter(1) around line 5 fetching a list of shapefiles, such as [ 'Mobilier_Urbain_L.shp', 'M_U_L.shp', ....] ?

And starting around line 15 to 19, is the .dbf file being converted to a text file and then into an XY layer file? Since the .dbf would be part of the shape file, is there a reason to do an XY conversion? Perhaps it would be better to converting the shape file to a feature layer with MakeFeatureLayer and then saving it with FeatureClassToFeatureClass?

tmplyr <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>MakeFeatureLayer_management<SPAN class="punctuation token">(</SPAN>r<SPAN class="string token">'C:\path\to\shapefile.shp'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'tmplyr'</SPAN><SPAN class="punctuation token">)</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>FeatureClassToFeatureClass_conversion<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"tmplyr"</SPAN><SPAN class="punctuation token">,</SPAN>r<SPAN class="string token">'C:\path\to\file.gdb'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'shp_conv'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

Thanks.

guillaumemure

Ok, i tested my code with an orientation operation and no problem but with 5 crashes, and i have in toolbox Windows, that message: [< geoprocessing value object at 0x30AC4F98>, <geoprocessing value object object at 0x30AC4FE0>] when 5 operation.

Thanks,

DanPatterson_Retired

don't run it in the background, fails have been reported in that environment when things work in the foreground and that is the recommended solutioin

guillaumemure

I want my script to make some layers, with different orientations, the input layer is always of type line, * _L, the orientation varies according to the layer. it is for the purpose of automation, that's why I check if the layer contains objects because all the objects of the layers are not to orientate.

Yes it's true, it's a short extract copy, you were right for line 9 normally in my script it is after, copy paste a little too fast ...
and for line 17 yes ListFeatIn

ListFeat = ParemListFea

for ListFeatIn in ListFeat :

</CODE><CODE>if ListFeatIn == "Mobilier_Urbain_L.shp" and ComMob > 0:

<SPAN class=""><SPAN class="" lang="en"><SPAN class="" title="">the process starts without reporting an error except when I run it in the background select layer announces an error.</SPAN></SPAN></SPAN>

Thank    

RandyBurton

Can you describe what you want your script tool to do? A description of the tool's function may assist in getting an answer to your question.

I would suggest that you do some testing of the code before putting it in a script tool. This will help debug the script as error messages will display and help pinpoint the source of the problem.

I've retyped your code as Dan Patterson‌ has suggested (using the syntax highlighter). This format will give some line numbers to aid in the discussion.

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

arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameter<SPAN class="punctuation token">(</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>
arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>overwriteOutput <SPAN class="operator token">=</SPAN> <SPAN class="token boolean">True</SPAN>
ParemListFea <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameter<SPAN class="punctuation token">(</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">)</SPAN>
ParemSpat <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetParameter<SPAN class="punctuation token">(</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="keyword token">try</SPAN><SPAN class="punctuation token">:</SPAN>
    SpatRef <SPAN class="operator token">=</SPAN> ParemSpat
    SelectMob <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SelectLayerByAttribute_management<SPAN class="punctuation token">(</SPAN>MobFeat<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"NEW_SELECTION"</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"nom = '1105'"</SPAN><SPAN class="punctuation token">)</SPAN>
    ComMob <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>GetCount_management<SPAN class="punctuation token">(</SPAN>SelectMob<SPAN class="punctuation token">)</SPAN>

    MobFeat <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Mobilier_Urbain_L"</SPAN> 
    OutMob <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Mobilier0"</SPAN>
    OutTempMob <SPAN class="operator token">=</SPAN> <SPAN class="string token">"MobilierTemp"</SPAN>
    Dbf_Mob <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Mobilier_Urbaine_L.dbf"</SPAN>
    OutTxt_Mob <SPAN class="operator token">=</SPAN> <SPAN class="string token">"Mobilier_U_L.txt"</SPAN>
    <SPAN class="keyword token">if</SPAN> ListFeatIn <SPAN class="operator token">==</SPAN> <SPAN class="string token">"Mobilier_Urbain_L.shp"</SPAN> <SPAN class="operator token">and</SPAN> ComMob <SPAN class="operator token">></SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">:</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>TableToTable_conversion<SPAN class="punctuation token">(</SPAN>Dbf_mob<SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="punctuation token">,</SPAN> OutTxt_Mob<SPAN class="punctuation token">)</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>MakeXYEventLayer_management<SPAN class="punctuation token">(</SPAN>OutTxtMob<SPAN class="punctuation token">,</SPAN> FieldX1<SPAN class="punctuation token">,</SPAN> FieldY1<SPAN class="punctuation token">,</SPAN> OutTempMob<SPAN class="punctuation token">,</SPAN> ParemSpat<SPAN class="punctuation token">,</SPAN> FieldZ1<SPAN class="punctuation token">)</SPAN>
        arcpy<SPAN class="punctuation token">.</SPAN>FeatureClassToFeatureClass_conversion<SPAN class="punctuation token">(</SPAN>OutTempMob<SPAN class="punctuation token">,</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>env<SPAN class="punctuation token">.</SPAN>workspace<SPAN class="punctuation token">,</SPAN> OutMob<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

From the code snippet above, I notice that several variables are referenced before they are defined.

In line 9, MobFeat is being referenced, but it is not defined until line 12. Perhaps line 12 should be moved before line 9 ?

And in line 17 the value of ListFeatIn is being checked to see if it matches the name of a shape file. Perhaps ListFeatIn is supposed to be ParemListFea ? I do not see a reference to ParemListFea being used later in the script.

Line 17 also references ConMob. This value will be zero or None if the SelectLayerByAttibute fails at line 9. The where clause in line 9 is referencing a field nom and checking for a certain text string '1105' that may be a number 1105. This will affect what is being returned by the query.

These are just a few quick observations. Please tell us more about your project.

guillaumemure

can be a memory problem, with the selections of different objects in different layers, is possible?

guillaumemure

The script launches is carried out a first step [1/5] without XY event and Feature Class conversion, and in step 2/5 at the level of xy event and feature class crash conversion because the text file is created.

Thanks,

DanPatterson_Retired

Could you format your code so that there are line numbers and indentation can be checked

/blogs/dan_patterson/2016/08/14/script-formatting

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Liens rapides

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