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

Create Multiple site address points from one

JoeBorgione

I have set of site address points that instead of a single house number, they contain a range of house numbers. I would like to create a point in the same location for each of the house numbers in the range. Here is the beginning of the python logic:

addrRange <SPAN class="operator token">=</SPAN> <SPAN class="string token">'8909-8927'</SPAN> <SPAN class="comment token"># the hyphenated string is in the HouseNumber field</SPAN>
begin <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>addrRange<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'-'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> 
end <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>addrRange<SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'-'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
addresses <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">(</SPAN>end <SPAN class="operator token">-</SPAN> begin<SPAN class="punctuation token">)</SPAN> <SPAN class="operator token">/</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN>
houseNumberList <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>begin<SPAN class="punctuation token">]</SPAN>

<SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>addresses<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    begin <SPAN class="operator token">+=</SPAN><SPAN class="number token">2</SPAN>
    houseNumberList<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>begin<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>

Now I have a list of house numbers and the goal is to create a new point for each of list elements:

<SPAN class="punctuation token">[</SPAN><SPAN class="number token">8909</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8911</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8913</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8915</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8917</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8919</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8921</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8923</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8925</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">8927</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN>

Basically, where there was one point, (in this case) I want ten points stacked on top of each other. Could be it's Friday, or could be I just can't wrap my head around the next step (that will involve an insert cursor) but I need another set of eyes on this. Each new point attribute record will be a copy of the original but the value in the HouseNumber field will correspond with the list element.

Thanks in advance

Encontre mais publicações marcadas com

Accepted answers

RandyBurton

Perhaps something like this, assuming a search cursor or some such loop contains your geometry, address range and attributes. (You could add a small amount to your x,y coordinates as you do the loop, if you didn't want the points on top of each other.)

searchCursor <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'geo1'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'8909-8927'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'attr1'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
                <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'geo2'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'8908-8926'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'attr2'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># start an insert cursor here</SPAN>
<SPAN class="comment token"># then continue with search cursor or other loop for address ranges</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> searchCursor<SPAN class="punctuation token">:</SPAN>
    begin <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'-'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
    end <SPAN class="operator token">=</SPAN>  int<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'-'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">1</SPAN> <SPAN class="comment token"># 1 past address range</SPAN>
    <SPAN class="keyword token">for</SPAN> address <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>begin<SPAN class="punctuation token">,</SPAN> end<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># step by 2</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> address<SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># this is your data to insert‍‍‍‍‍‍‍‍‍‍</SPAN>

<SPAN class="string token">''' results:
('geo1', 8909, 'attr1')
('geo1', 8911, 'attr1')
('geo1', 8913, 'attr1')
('geo1', 8915, 'attr1')
('geo1', 8917, 'attr1')
('geo1', 8919, 'attr1')
('geo1', 8921, 'attr1')
('geo1', 8923, 'attr1')
('geo1', 8925, 'attr1')
('geo1', 8927, 'attr1')
('geo2', 8908, 'attr2')
('geo2', 8910, 'attr2')
('geo2', 8912, 'attr2')
('geo2', 8914, 'attr2')
('geo2', 8916, 'attr2')
('geo2', 8918, 'attr2')
('geo2', 8920, 'attr2')
('geo2', 8922, 'attr2')
('geo2', 8924, 'attr2')
('geo2', 8926, 'attr2')
'''</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>

All comments

JamesBushOpelika

Hello!

I want to develop a similar process, I am a bit green with python. I am just looking for a more efficient solution to add multiple address points. For instance, when a new subdivision comes along I receive the addressing and need to create a point with attributes. For a single street, the only fields that change are the house number and a hyperlink. The x,y changes as well but I can recalculate them when the points are placed. I just want a way to create multiple points at once in arcmap, If I have to move them manually once created that is fine. Any idea on a script or tool to do this. attached is an example of my attributes. Thanks!

JoeBorgione

Thanks for your help Randy. Between your suggestion and the insert cursor help I was able to get it to work

Here is my final script:

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

fc <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'N:\GIS\AddressDataManagement\Data\AppendIntoSitesMSD.gdb\RangeAddresses'</SPAN>

<SPAN class="comment token"># use list comprehension to create a list</SPAN>
<SPAN class="comment token"># of all the existing rows where the the </SPAN>
<SPAN class="comment token"># house number is in the form of a range for example 1110-1120</SPAN>

fields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'Shape'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'PARCEL'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ADDR_HN'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ADDR_PD'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'ADDR_SN'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ADDR_ST'</SPAN><SPAN class="punctuation token">,</SPAN>
          <SPAN class="string token">'ADDR_SD'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'CITY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'ZIP_CODE'</SPAN><SPAN class="punctuation token">]</SPAN>
rowValues <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN>i <SPAN class="keyword token">for</SPAN> i <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="comment token"># the TestTarget feature class is created a-priori</SPAN>
<SPAN class="comment token"># and has the fields shown the in the insertFields list</SPAN>


target <SPAN class="operator token">=</SPAN> r'N<SPAN class="punctuation token">:</SPAN>\GIS\AddressDataManagement\Data<SPAN class="comment token">#\TestTarget'</SPAN>
insertFields <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'SHAPE@XY'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Parcel'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'HouseNumber'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'PreDir'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'StreetName'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'SufType'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'SufDir'</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">'City'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'Zip'</SPAN><SPAN class="punctuation token">]</SPAN>
cursor <SPAN class="operator token">=</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>InsertCursor<SPAN class="punctuation token">(</SPAN>target<SPAN class="punctuation token">,</SPAN> insertFields<SPAN class="punctuation token">)</SPAN>


<SPAN class="comment token"># the fun begins: plow through the original rowValues list</SPAN>
<SPAN class="comment token"># figure out what the range of addresses will include</SPAN>
<SPAN class="comment token"># since I am creating a value for the house number</SPAN>
<SPAN class="comment token"># I create a tuple that contains the info from the rowValues list</SPAN>
<SPAN class="comment token"># as well as my new house numbers for each of the house numbers</SPAN>
<SPAN class="comment token"># in the range.  And then append all the tuples to a list called rv</SPAN>

rv <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>len<SPAN class="punctuation token">(</SPAN>rowValues<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    
    begin <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>rowValues<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'-'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
    end <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>rowValues<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'-'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">2</SPAN>
    <SPAN class="keyword token">for</SPAN> hn <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>begin<SPAN class="punctuation token">,</SPAN>end<SPAN class="punctuation token">,</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        theTuple <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>rowValues<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> rowValues<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> hn<SPAN class="punctuation token">,</SPAN>rowValues<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> rowValues<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> 
        rowValues<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> rowValues<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> rowValues<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> rowValues<SPAN class="punctuation token">[</SPAN>i<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
        <SPAN class="comment token">#print(theTuple)</SPAN>
        rv<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>theTuple<SPAN class="punctuation token">)</SPAN>
        
<SPAN class="comment token"># plow throught rv list of tuples and insert them...</SPAN>

<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> rv<SPAN class="punctuation token">:</SPAN>
    cursor<SPAN class="punctuation token">.</SPAN>insertRow<SPAN class="punctuation token">(</SPAN>row<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>‍</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>

This creates a new point for each of the house numbers in the given range, and stacks them on top of each other. For example, the original house number for this location on Patricia Dr was 2836-2838; once the processing is done, the rv list of tuples looks like this:

[((1476733.9007378817, 7427506.225450307), '14292050050000', 2836, 'S', 'PATRICIA', 'DR', '', 'MAGNA', '84044')
 ((1476733.9007378817, 7427506.225450307), '14292050050000', 2838, 'S', 'PATRICIA', 'DR', '', 'MAGNA', '84044')
...]<SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

There were 101 original addresses as a range and I ended up with 450+- individual address points...

RandyBurton

searchCursor <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">'geo1'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'8909-8927'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'attr1'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
                <SPAN class="punctuation token">[</SPAN><SPAN class="string token">'geo2'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'8908-8926'</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'attr2'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">]</SPAN>

<SPAN class="comment token"># start an insert cursor here</SPAN>
<SPAN class="comment token"># then continue with search cursor or other loop for address ranges</SPAN>
<SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> searchCursor<SPAN class="punctuation token">:</SPAN>
    begin <SPAN class="operator token">=</SPAN> int<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'-'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
    end <SPAN class="operator token">=</SPAN>  int<SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">.</SPAN>split<SPAN class="punctuation token">(</SPAN><SPAN class="string token">'-'</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="operator token">+</SPAN><SPAN class="number token">1</SPAN> <SPAN class="comment token"># 1 past address range</SPAN>
    <SPAN class="keyword token">for</SPAN> address <SPAN class="keyword token">in</SPAN> range<SPAN class="punctuation token">(</SPAN>begin<SPAN class="punctuation token">,</SPAN> end<SPAN class="punctuation token">,</SPAN> <SPAN class="number token">2</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># step by 2</SPAN>
        <SPAN class="keyword token">print</SPAN><SPAN class="punctuation token">(</SPAN>row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> address<SPAN class="punctuation token">,</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="comment token"># this is your data to insert‍‍‍‍‍‍‍‍‍‍</SPAN>

<SPAN class="string token">''' results:
('geo1', 8909, 'attr1')
('geo1', 8911, 'attr1')
('geo1', 8913, 'attr1')
('geo1', 8915, 'attr1')
('geo1', 8917, 'attr1')
('geo1', 8919, 'attr1')
('geo1', 8921, 'attr1')
('geo1', 8923, 'attr1')
('geo1', 8925, 'attr1')
('geo1', 8927, 'attr1')
('geo2', 8908, 'attr2')
('geo2', 8910, 'attr2')
('geo2', 8912, 'attr2')
('geo2', 8914, 'attr2')
('geo2', 8916, 'attr2')
('geo2', 8918, 'attr2')
('geo2', 8920, 'attr2')
('geo2', 8922, 'attr2')
('geo2', 8924, 'attr2')
('geo2', 8926, 'attr2')
'''</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>

Participe da Conversa

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

Links Rápidos

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