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

Query for orginal numbers

CCWeedcontrol

I am trying to query a filed to find original parcels, i would like to create a filled and mark the ones that are original and don't have not split. Currently the field is a string with a length of 11. Some parcels have 5, some 8 and some 10 - not including the alph letter. Hopefully i have explained good what I am needing, i am just not sure how to do this. At first i thought of doing unique numbers but some how it would need to know if the first 5 digits are used, there are some duplicate numbers as well. I am kind of lost on how to proceed, if anyone has done something similar could share some code please?

the attributes are as follows for example;

R00062 (Original parcel)--> has R00062010 (Split parcel, next one below) - this is not one i need marked.

R00062010 - Not Original parcel

R32073114 - Not Original parcel

R32078 - Original parcel because there is no other parcel number associated with it, need this one mark in the new filed.

R32079 - Original parcel because there is no other parcel number associated with it,, need this one mark in the new filed.

R32081 - Original parcel because there is no other parcel number associated with it,, need this one mark in the new filed.

R32082012 - Not Original parcel

R32083012 - Not Original parcel

Encuentra más publicaciones etiquetadas con

Accepted answers

All comments

CCWeedcontrol

I have learned a lot from all you guys on this forum.

It's nice to know there are people willing to help out!

@Joshua Bixby

@Randy Burton

@Joe Borgione

@Dan Patterson

CCWeedcontrol

Excellent thank you!

JoeBorgione

I'll say the same thing about you too Randy! Both of you guys have a huge impact on what I do and how I code it!

Randy Burton‌

Joshua Bixby‌

RandyBurton

Joshua Bixby, I always learn something from your code. Thanks.

bixb0012

Based on your requirements, and the possibility of duplicate parcel IDs, the following will generate a Python set of parcel IDs that meet your conditions. You can then use an update cursor to loop over the records and check whether the ID is in the set, and then flag the record accordingly.

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">from</SPAN> collections <SPAN class="keyword token">import</SPAN> defaultdict
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> 
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> tbl <SPAN class="operator token">=</SPAN> <SPAN class="comment token"># path to table containing "PARCEL_NO" field</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> 
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> unique_pids <SPAN class="operator token">=</SPAN> defaultdict<SPAN class="punctuation token">(</SPAN>set<SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> <SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"PARCEL_NO"</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cur<SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>     <SPAN class="keyword token">for</SPAN> pid<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> cur<SPAN class="punctuation token">:</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>         unique_pids<SPAN class="punctuation token">[</SPAN>pid<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><SPAN class="punctuation token">.</SPAN>add<SPAN class="punctuation token">(</SPAN>pid<SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN><SPAN class="punctuation token">.</SPAN>         
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> orig_pids <SPAN class="operator token">=</SPAN> set<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">.</SPAN>union<SPAN class="punctuation token">(</SPAN><SPAN class="operator token">*</SPAN><SPAN class="punctuation token">(</SPAN>i <SPAN class="keyword token">for</SPAN> i <SPAN class="keyword token">in</SPAN> unique_pids<SPAN class="punctuation token">.</SPAN>values<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>i<SPAN class="punctuation token">)</SPAN> <SPAN class="operator 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="operator token">></SPAN> orig_pids
set<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">[</SPAN>u<SPAN class="string token">'R29688011'</SPAN><SPAN class="punctuation token">,</SPAN> u<SPAN class="string token">'R29844'</SPAN><SPAN class="punctuation token">,</SPAN> u<SPAN class="string token">'R29842010'</SPAN><SPAN class="punctuation token">,</SPAN> u<SPAN class="string token">'R29835'</SPAN><SPAN class="punctuation token">,</SPAN> u<SPAN class="string token">'R29846'</SPAN><SPAN class="punctuation token">,</SPAN> u<SPAN class="string token">'R29833'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator 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>

RandyBurton

I like Joshua Bixby ‌'s code as it is simple. When you are in the UpdateCursor, just use the first 6 characters of the parcel id to check if it is in the original list, then set the flag. Here is that approach for you to test.

<SPAN class="keyword token">import</SPAN> arcpy
<SPAN class="keyword token">from</SPAN> collections <SPAN class="keyword token">import</SPAN> Counter

tbl <SPAN class="operator token">=</SPAN> r<SPAN class="string token">'C:/Temp/ParcelNumberSample2.dbf'</SPAN>

<SPAN class="comment token"># read parcel id into counter</SPAN>
parcel_count <SPAN class="operator token">=</SPAN> Counter<SPAN class="punctuation token">(</SPAN>
    <SPAN class="punctuation token">(</SPAN>pid<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">for</SPAN> pid<SPAN class="punctuation token">,</SPAN> <SPAN class="keyword token">in</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>SearchCursor<SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">,</SPAN><SPAN class="string token">"PARCEL_NO"</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">)</SPAN>
<SPAN class="punctuation token">)</SPAN>

original <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># an empty list for original parcels</SPAN>

<SPAN class="keyword token">for</SPAN> pid<SPAN class="punctuation token">,</SPAN>cnt <SPAN class="keyword token">in</SPAN> parcel_count<SPAN class="punctuation token">.</SPAN>items<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">if</SPAN> cnt <SPAN class="operator token">==</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># origional parcels will only have a count of 1</SPAN>
        original<SPAN class="punctuation token">.</SPAN>append<SPAN class="punctuation token">(</SPAN>pid<SPAN class="punctuation token">)</SPAN>

<SPAN class="comment token"># print original</SPAN>

<SPAN class="keyword token">with</SPAN> arcpy<SPAN class="punctuation token">.</SPAN>da<SPAN class="punctuation token">.</SPAN>UpdateCursor<SPAN class="punctuation token">(</SPAN>tbl<SPAN class="punctuation token">,</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="string token">"PARCEL_NO"</SPAN><SPAN class="punctuation token">,</SPAN><SPAN class="string token">"Org_Par"</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">)</SPAN> <SPAN class="keyword token">as</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">for</SPAN> row <SPAN class="keyword token">in</SPAN> cursor<SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="keyword token">in</SPAN> original<SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># trim row[0] to 6 characters and check if in original list</SPAN>
            <SPAN class="comment token"># print row[0]</SPAN>
            row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'Orig'</SPAN>
            <SPAN class="comment token"># cursor.updateRow(row) # you can just update the flagged records by uncommenting this line and deleting the remaining lines</SPAN>
        <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN> <SPAN class="comment token"># or add an else to set non-original fields to a value</SPAN>
            row<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="string token">'N'</SPAN>
        cursor<SPAN class="punctuation token">.</SPAN>updateRow<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>

If you find that you do need the object id to do some other things, here's and updated version of my code that may give you some ideas. I used where OBJECTID IN ( nnn, nnn) in my SQL; you may need to make adjustments for your version. I was also testing with a file geodatabase where you might be testing with a shapefile.

import arcpy

tbl = r'C:/Temp/ParcelNumberSample2.dbf' # use your table name

# read oid and parcel_id into dictionary
parcels = [[r[0],r[1]] for r in arcpy.da.SearchCursor(tbl, ['PARCEL_NO', 'OBJECTID'])] # use your field names

# print parcels

# empty dictionaries for parents and children
parentFound = {} # format: { parent parcel id : object id }
childFound = {} # format: { parent parcel id : ( object id, count of items) }

for p in parcels:
    parent = p[0][:6]
    # print parent
    if len(p[0]) > len(parent):
        if parent in childFound.keys():
            childFound[parent] = (p[1], 1 + childFound[parent][1] )# this will be last child found (by objectid)
        else:
            childFound[parent] = (p[1], 0)
    else:
        parentFound[parent] = p[1] # this will be last parent found (by objectid)

# print parentFound
# print childFound

objID = [] # empty list for object ids

for k in parentFound.keys():
    if k not in childFound.keys(): 
        # print k, parentFound<K>, "parent is orig"  # this is the parcelid and objectid of parent parcels, add to a list
        objID.append(parentFound<K>)

for k in childFound.keys():
    if k not in parentFound.keys():
        if childFound<K>[1] < 1:
            # print k, childFound<K>[0], "child is orig" # this would be the parent parcelid that was NOT found, add to the list also
            objID.append(childFound<K>[0])

# print sorted(objID)
where = "OBJECTID IN ({})".format(str(sorted(objID)).strip('[]')) # substitute name of object id field

with arcpy.da.UpdateCursor(tbl,["OBJECTID","Org_Par"], where_clause=where) as cursor:
    for row in cursor: # this will just update the rows where an original parcel id was found
        print row
        row[1] = 'Orig'
        cursor.updateRow(row)‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></K></K></K></K></K>

DanPatterson_Retired

row[2] would mean that you have 3 elements in the field since python is 0-based, row[1] would be the second element... row[0], the first

CCWeedcontrol

I am confused as to how you are got the parcel numbers into the list, i am trying this based on what you posted but get parcels = [row[2] for row in arcpy.da.SearchCursor(fc, field1)] IndexError: tuple index out of range. I thought about duplicates since it doesn't matter which one i can first occurrence. There is two fields before the PARCEL_NO field.

fc = 'C:/Temp/ParcelNumberSample2.dbf'
field1 = "PARCEL_NO" 

parcels = [row[2] for row in arcpy.da.SearchCursor(fc, field1)]


parentFound = {} # empty dictionary
childFound = {}

# order by objectid
for p in parcels:
    parent = p[1][:6]
    # print parent
    if len(p[1]) > len(parent):
        if parent in childFound.keys():
            childFound[parent] = (p[0], 1 + childFound[parent][1] )# this will be last child found (by objectid)
        else:
            childFound[parent] = (p[0], 0)
    else:
        parentFound[parent] = p[0] # this will be last parent found (by objectid)

# print parentFound
# print childFound

for k in parentFound.keys():
    if k not in childFound.keys():
        print (k, parentFound<K>, "parent is orig")  # this is the parcelid and objectid of parent parcels, add to a list

for k in childFound.keys():
    if k not in parentFound.keys():
        if childFound<K>[1] < 1:
            print (k, childFound<K>[0], "child is orig") # this would be the parent parcelid that was NOT found, add to the list also

‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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></K></K></K>

OriginalParcelsTable.png

RandyBurton

I was wondering, what would be the "original" if a parent parcel id such as "R29835" appeared more than once in your parcel file? Would you want to use the first or last occurrence for the original?

RandyBurton

Regarding your question previously:

So i am not sure as to why it indicated that there was R37422 as an original when there is no R37422 in the parcel's. The same thing for R39509, there is no R39509 but there is a R39509500.

From your example file, you mentioned that a child would be an original if the first 6 characters had not been used in another parcel. Joshua counts what would be parent codes. R39509500 would be considered an original as there are no other parcels starting with the same six characters.

For your project, I think it would be helpful to pair an object id with the parcel id. Here's my test code using your example file. Perhaps it will be helpful in this discussion.

parcels <SPAN class="operator 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="string token">'R29681011'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">2</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29681113'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">3</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29681114'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">4</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29681115'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">5</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29681116'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29681117'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">7</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29681118'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">8</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29681119'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">9</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29681120'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">10</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29681121'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="punctuation token">[</SPAN><SPAN class="number token">11</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29681122'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">12</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29681122B'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">13</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29681122C'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">14</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29681122D'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">15</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29682011'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="punctuation token">[</SPAN><SPAN class="number token">16</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29682012'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">17</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29682013'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">18</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29688011'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">19</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29825'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">20</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29825010A'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="punctuation token">[</SPAN><SPAN class="number token">21</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29825010B'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">22</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29826'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">23</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29826011'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">24</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29826011A'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">25</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29826011B'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="punctuation token">[</SPAN><SPAN class="number token">26</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29826011C'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">27</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29826011D'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">28</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29826012'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">29</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29826012A'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">30</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29826013'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="punctuation token">[</SPAN><SPAN class="number token">31</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29826014'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">32</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29826015'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">33</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29826016'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">34</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29833'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">35</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29834'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="punctuation token">[</SPAN><SPAN class="number token">36</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29834010'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">37</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29835'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">38</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29836'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">39</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29836010'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">40</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29842010'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="punctuation token">[</SPAN><SPAN class="number token">41</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29844'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">42</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29846'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">43</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29850'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">44</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29850010'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="punctuation token">[</SPAN><SPAN class="number token">45</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29852'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="punctuation token">[</SPAN><SPAN class="number token">46</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">'R29852010'</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN>
    <SPAN class="punctuation token">]</SPAN>

parentFound <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN> <SPAN class="comment token"># empty dictionary</SPAN>
childFound <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">{</SPAN><SPAN class="punctuation token">}</SPAN>

<SPAN class="comment token"># order by objectid</SPAN>
<SPAN class="keyword token">for</SPAN> p <SPAN class="keyword token">in</SPAN> parcels<SPAN class="punctuation token">:</SPAN>
    parent <SPAN class="operator token">=</SPAN> p<SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN>
    <SPAN class="comment token"># print parent</SPAN>
    <SPAN class="keyword token">if</SPAN> len<SPAN class="punctuation token">(</SPAN>p<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> len<SPAN class="punctuation token">(</SPAN>parent<SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> parent <SPAN class="keyword token">in</SPAN> childFound<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
            childFound<SPAN class="punctuation token">[</SPAN>parent<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">1</SPAN> <SPAN class="operator token">+</SPAN> childFound<SPAN class="punctuation token">[</SPAN>parent<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="comment token"># this will be last child found (by objectid)</SPAN>
        <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
            childFound<SPAN class="punctuation token">[</SPAN>parent<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> <SPAN class="punctuation token">(</SPAN>p<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="number token">0</SPAN><SPAN class="punctuation token">)</SPAN>
    <SPAN class="keyword token">else</SPAN><SPAN class="punctuation token">:</SPAN>
        parentFound<SPAN class="punctuation token">[</SPAN>parent<SPAN class="punctuation token">]</SPAN> <SPAN class="operator token">=</SPAN> p<SPAN class="punctuation token">[</SPAN><SPAN class="number token">0</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="comment token"># this will be last parent found (by objectid)</SPAN>

<SPAN class="comment token"># print parentFound</SPAN>
<SPAN class="comment token"># print childFound</SPAN>

<SPAN class="keyword token">for</SPAN> k <SPAN class="keyword token">in</SPAN> parentFound<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">if</SPAN> k <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> childFound<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">print</SPAN> k<SPAN class="punctuation token">,</SPAN> parentFound<SPAN class="punctuation token">[</SPAN>k<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">,</SPAN> <SPAN class="string token">"parent is orig"</SPAN>  <SPAN class="comment token"># this is the parcelid and objectid of parent parcels, add to a list</SPAN>

<SPAN class="keyword token">for</SPAN> k <SPAN class="keyword token">in</SPAN> childFound<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
    <SPAN class="keyword token">if</SPAN> k <SPAN class="operator token">not</SPAN> <SPAN class="keyword token">in</SPAN> parentFound<SPAN class="punctuation token">.</SPAN>keys<SPAN class="punctuation token">(</SPAN><SPAN class="punctuation token">)</SPAN><SPAN class="punctuation token">:</SPAN>
        <SPAN class="keyword token">if</SPAN> childFound<SPAN class="punctuation token">[</SPAN>k<SPAN class="punctuation token">]</SPAN><SPAN class="punctuation token">[</SPAN><SPAN class="number token">1</SPAN><SPAN class="punctuation token">]</SPAN> <SPAN class="operator token"><</SPAN> <SPAN class="number token">1</SPAN><SPAN class="punctuation token">:</SPAN>
            <SPAN class="keyword token">print</SPAN> k<SPAN class="punctuation token">,</SPAN> childFound<SPAN class="punctuation token">[</SPAN>k<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> <SPAN class="string token">"child is orig"</SPAN> <SPAN class="comment token"># this would be the parent parcelid that was NOT found, add to the list also</SPAN>

<SPAN class="comment token"># output:</SPAN>
R29835 <SPAN class="number token">37</SPAN> parent <SPAN class="keyword token">is</SPAN> orig
R29833 <SPAN class="number token">34</SPAN> parent <SPAN class="keyword token">is</SPAN> orig
R29844 <SPAN class="number token">41</SPAN> parent <SPAN class="keyword token">is</SPAN> orig
R29846 <SPAN class="number token">42</SPAN> parent <SPAN class="keyword token">is</SPAN> orig
R29842 <SPAN class="number token">40</SPAN> child <SPAN class="keyword token">is</SPAN> orig
R29688 <SPAN class="number token">18</SPAN> child <SPAN class="keyword token">is</SPAN> orig
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍<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>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN>

The idea would be to loop through your parcel ID's to locate the "originals". The object id of the originals would be added to a list which would be used with an update cursor to set the original flag field.

CCWeedcontrol

Yes that is correct.

JoeBorgione

I think Randy Burton‌'s comment is putting you in the right direction: If you parse out the original parcel from those that have been split, you can get a list of parent parcels. Use that list to plow through the entire data set. When the id in the list is found in the data set, keep going; those parcel ids that are not in the list are the ones you want to flag as original...

bixb0012

So you are really interesting in marking/finding all original parcels that were never split and thus have no children parcels?

CCWeedcontrol

I have attached some sample data.

ParcelNoExample.xls

CCWeedcontrol

Your assumption is correct, i haven't thought about marking duplicate original numbers. If there is a duplicate but no child parcel numbers then I would like this one marked as original parcel.

CCWeedcontrol

Yes it's always 6 characters, R00062 would seem like it's an original parcel but there could be R00062010 or R00062010 or R00062011 or R00062012 (These would be considered child parcels) but some how it needs to check to see if R00062 (6 characters) are used in other parcel numbers. This parcel would not be considered an original parcel because it's has child parcel numbers.

CCWeedcontrol

Joe,

When a parcel is split for example, a split comes through for R00062, R00062 stays as the mother account and the new parcels (child parcels) get 010 or 011 or 012 etc. There is currently no efficient way of maintaining this data, one would just have to look to see of there is a R00062010 or R00062010 or R00062011 or R00062012 etc. This is not my data this is data i am working with.

bixb0012

In the case of duplicate numbers, assuming you are referring to duplicate "original" numbers, how do you decide which record to mark and which one not to mark?

RandyBurton

Is the original parcel always 6 characters? If so, would slicing work?

<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> parcel <SPAN class="operator token">=</SPAN> <SPAN class="string token">'R00062010'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> original <SPAN class="operator token">=</SPAN> parcel<SPAN class="punctuation token">[</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> original
<SPAN class="string token">'R00062'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> subparcel <SPAN class="operator token">=</SPAN> parcel<SPAN class="punctuation token">[</SPAN><SPAN class="number token">6</SPAN><SPAN class="punctuation token">:</SPAN><SPAN class="punctuation token">]</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> subparcel
<SPAN class="string token">'010'</SPAN>
<SPAN class="operator token">>></SPAN><SPAN class="operator token">></SPAN> len<SPAN class="punctuation token">(</SPAN>subparcel<SPAN class="punctuation token">)</SPAN>
<SPAN class="number token">3</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>

JoeBorgione

When you say 'Original parcel because there is no other parcel number associated with it' how is that 'association' maintained? Do you have a related table of the 'child' parcels? Is it maintained in the actual parcel data itself?

Is there some what to see what the parent parcel of R00062010 is? etc.....

Únete a la Conversación

Los miembros registrados pueden publicar, seguir actualizaciones y más. ¿Nuevo aquí? Regístrate gratis.

Enlaces Rápidos

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