topic Re: Sort grid (text) field sort of like a number! in Python Questions

Sort grid (text) field sort of like a number!

Anonymous User — Tue, 23 Jun 2015 18:24:30 GMT

Hello all,

I'm not sure if python can do something like this. Our brains can do it so maybe we can get an automated way to do this?

I need to give a page number to each of these pages. They need to be in an order like below, based on the grid name. It's like township name, then some of them have a section detail page (11-1), and then some of them further have a subsection detail page (11-1NE - northeast part of section 1 in township 11). I have 275 pages in this set. In the past I have to do it manually. Does anyone have any ideas? Thank you.

11-1

11-1NE

11-1NW

11-1SE

11-2

11-2NE

11-7

11-8

11-10SW

11-12NE

Re: Sort grid (text) field sort of like a number!

SepheFox — Tue, 23 Jun 2015 18:30:36 GMT

You can use the Sort tool, in the General toolbox (data management) to sort on a field. To use it in Python, use the following syntax:

Sort_management (in_dataset, out_dataset, sort_field, {spatial_sort_method})

Re: Sort grid (text) field sort of like a number!

WesMiller — Tue, 23 Jun 2015 18:39:47 GMT

To add to Sephe Fox said you'll need an advanced license and use the "Shape" as a sort field

Re: Sort grid (text) field sort of like a number!

Anonymous User — Tue, 23 Jun 2015 18:53:29 GMT

That sounds great too. I only have a Standard license right now but I'll have to keep that in mind for some day in the future. Thanks!

Re: Sort grid (text) field sort of like a number!

DarrenWiens2 — Tue, 23 Jun 2015 20:39:18 GMT

I'm a little confused what step you're at. Do you need to assign the page numbers based on whether or not it's a detail map, or create a sortable field to order your exported data driven pages based on the page number, or both?

Re: Sort grid (text) field sort of like a number!

Anonymous User — Tue, 23 Jun 2015 20:50:15 GMT

Well, what I do when I do it manually, is first I sort it as best I can. Then I make a number field and type in one by one, the number of the page. So that when I export data driven pages it has the right page number and it's in the right order.

So if I can sort this grid number field and then assign the page numbers to that sort order, I think I would be done. At one point in time I had some code that would assign a sequential number after I had it sorted how I wanted it.

Does that help explain?

Re: Sort grid (text) field sort of like a number!

DarrenWiens2 — Tue, 23 Jun 2015 21:06:41 GMT

Yes, that helps. Do you have a quarter section grid? If so, it would be a matter of

1.) Create one field to store map type in your index layer

2.) Assign values of "TWP", "SEC", or "QTR" to denote whether the page is a township, section or quarter section map. You can likely do this automatically based on the index feature size (township > section > quarter).

3.) Spatial Join (must use the geoprocessing tool, not right-click join dialog) the index layer to the quarter section grid, based on HAVE_THEIR_CENTERS_IN. Now index features will have quarter info.

4.) Using if...then logic in field calculator, calculate the page number (if map type = "QTR", make a page number like "TWP" + "-" + "SEC" + "QTR")

Once you have your page numbers in a field, you must determine their order, which will be my next post.

Re: Sort grid (text) field sort of like a number!

DarrenWiens2 — Sun, 12 Dec 2021 01:41:51 GMT

This ended up being more complicated than I expected, but here's what I got. I have doubt there's a more direct route. Also, there be some hidden gotchas in your data. It updates a field called "ord", based on labels in "rnd" (in format "102-65NE"), from a feature class "points":

>>> from operator import itemgetter # import itergetter function
... myList = [] # make empty list
... fc = "points"
... labelField = "rnd"
... orderField = "ord"
... with arcpy.da.SearchCursor(fc,["OID@",labelField]) as cursor: # loop through your feature class
...    for row in cursor:
...        twp = str(row[1].split("-")[0]) # get township
...        if len(row[1].split("-")) > 1: # if there is more than just TWP
...            sec = ""
...            qtr = ""
...            for x in row[1].split("-")[1]: # loop through characters after hyphen
...                if x.isdigit():
...                    sec += str(x) # add to section if numerical
...                else:
...                    qtr += str(x) # add to quarter if letter
...            if len(qtr) == 0:
...                qtr = 0
...        else:
...            sec = 0
...        print twp
...        myList.append({"OID":row[0],"TWP":int(twp),"SEC":int(sec),"QTR":qtr}) # add to list
... myList = sorted(myList, key=itemgetter("TWP","SEC","QTR")) # sort list in place, by TWP, SEC, QTR
... with arcpy.da.UpdateCursor(fc,["OID@",orderField]) as cursor: # start updating
...    for row in cursor:
...        row[1] = next(index for (index, d) in enumerate(myList) if d["OID"] == row[0]) # enumerate list and match OIDs
...        cursor.updateRow(row) # update row to include a number

Re: Sort grid (text) field sort of like a number!

Anonymous User — Wed, 24 Jun 2015 18:27:03 GMT

So I'm getting Parsing error SyntaxError: invalid syntax (line 😎

twp = str(row[1].split("-")[0]) # get township

What can I do to try and run this?

Thank you for your effort to help! This code will probably help a lot of people.

Thanks,

Re: Sort grid (text) field sort of like a number!

DarrenWiens2 — Wed, 24 Jun 2015 18:37:58 GMT

I'm not sure, that looks correct to me. The line says, "Find the value in the current row, in the field specified in the 2nd variable listed in the cursor (the labelField), split it when there is a hyphen, return the portion before the first hyphen (or the entire string if there is no hyphen), convert it to a string, and store the value in a variable called twp".

Have you changed the labelField to match your field name? Also, check the previous line to make sure it's correct (e.g. not missing the colon).

Re: Sort grid (text) field sort of like a number!

Anonymous User — Sun, 12 Dec 2021 01:41:54 GMT

Runtime error 
Traceback (most recent call last):
  File "<string>", line 34, in <module>
ValueError: invalid literal for int() with base 10: '49 & 49A'

Ok, I cleaned up the spacing in PyScripter. It does work on a subset of my data!

But I have really messy data in here. Like "49 & 49A" and "51A", among other names. Maybe there can be some code that just says to ignore those if it finds them? Because I'll have to do those manually anyway based on the old book order.

Thank you!!

Re: Sort grid (text) field sort of like a number!

DarrenWiens2 — Sun, 12 Dec 2021 01:41:57 GMT

Sure, you can play around with .replace(). This will replace all " & " with "-", stored in variable newString:

...
for row in cursor:
    newString = row[1].replace(" & ", "-")