Script to create duplicate points based on field value

RichardBunten1

I can't get this script to work.  I am trying to create create a script that takes a point file with a single point representing a location and a field in its table "UNIT_NUMBE" and create duplicate points for that single point based on the value in this "UNIT_NUMBE" field.

Attached is the script that I have so far: 

 It bails out at line<SPAN class="" style="color: #101094; border: 0px; font-size: 13px;"></SPAN>28 or the line that reads     CountRange = range(InRow.count)

I get a runtime error: Row: Field count does not exist

Anyone help me with this.  Thanks in Advanced.

createdupptsfromcount.py.zip

DarrenWiens2

Code in question (I believe you do need a field called 'count', although I'm not familiar with the old cursors, anymore):

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

<SPAN class="comment token">#InFeatClass = sys.argv[1]</SPAN>
<SPAN class="comment token">#OutFeatClass = sys.argv[2]</SPAN>

InFeatClass <SPAN class="operator token">=</SPAN> <SPAN class="string token">"S:/GIS_Public/GIS_Data/DefaultGDB/Default.gdb/tempUnitsperParcel"</SPAN>
OutFeatClass <SPAN class="operator token">=</SPAN> <SPAN class="string token">"S:/GIS_Public/GIS_Data/DefaultGDB/Default.gdb/tempUnitsperParcel4"</SPAN>

<SPAN class="comment token"># overwriting output is ok.</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>

<SPAN class="comment token"># copy the count = 1 features to create a new feature class, saves having to do</SPAN>
<SPAN class="comment token"># new feature class, copy spatial reference and fields..</SPAN>

arcpy<SPAN class="punctuation token">.</SPAN>Select_analysis<SPAN class="punctuation token">(</SPAN>InFeatClass<SPAN class="punctuation token">,</SPAN>OutFeatClass<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"UNIT_NUMBE = 1"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># setup cursor objects - search the source, isert the destination</SPAN>
InsCur <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>OutFeatClass<SPAN class="punctuation token">)</SPAN>
SrchCur <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>InFeatClass<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"UNIT_NUMBE > 1"</SPAN><SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># get the list of fields to copy</SPAN>
FieldList <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>ListFields<SPAN class="punctuation token">(</SPAN>InFeatClass<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"*"</SPAN><SPAN class="punctuation token">)</SPAN>
NoCalcFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">"FID"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"OBJECTID"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"SHAPE"</SPAN><SPAN class="punctuation token">]</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
<SPAN class="keyword token">for</SPAN> InRow <SPAN class="keyword token">in</SPAN> SrchCur<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># create a range and then iterate over it</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># inserting a new row for each count</SPAN>
&nbsp;&nbsp;&nbsp; CountRange <SPAN class="operator token">=</SPAN> range<SPAN class="punctuation token">(</SPAN>InRow<SPAN class="punctuation token">.</SPAN>count<SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> indx <SPAN class="keyword token">in</SPAN> CountRange<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; newRow <SPAN class="operator token">=</SPAN> InsCur<SPAN class="punctuation token">.</SPAN>newRow<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># create a new (empty) feature</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># copy values from the source to the destination</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">for</SPAN> ThisField <SPAN class="keyword token">in</SPAN> FieldList<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="keyword token">if</SPAN> ThisField<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">.</SPAN>upper<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> NoCalcFields<SPAN class="punctuation token">:</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; newRow<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN>ThisField<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">,</SPAN>InRow<SPAN class="punctuation token">.</SPAN>getValue<SPAN class="punctuation token">(</SPAN>ThisField<SPAN class="punctuation token">.</SPAN>name<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># copy the shape</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; newRow<SPAN class="punctuation token">.</SPAN>setValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"SHAPE"</SPAN><SPAN class="punctuation token">,</SPAN>InRow<SPAN class="punctuation token">.</SPAN>getValue<SPAN class="punctuation token">(</SPAN><SPAN class="string token">"SHAPE"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN class="comment token"># Store it</SPAN>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; InsCur<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>newRow<SPAN class="punctuation token">)</SPAN>&nbsp;&nbsp;&nbsp;&nbsp; ‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>