topic Re: Selecting PLSS data from a table of attributes in Python Questions

Selecting PLSS data from a table of attributes

JaromHlebasko — Wed, 12 Feb 2014 19:34:08 GMT

Hello, I thought I would post a question I am having to see if Python can work with what I'm trying to accomplish. I know Python at the most basic level so any help would be appreciated. I am trying to select the appropriate township, range, section, quarter, and quarter quarter section data from a separate table that contains what I am wanting queried. In the most Lehman terms possible, I have one data set of PLSS data and then a separate table that has a column (attribute) of specific locations such as T 1 S R 3 W Section 27 or NWSW, NWSE, NENW, NESW, NESE, SWNE, SWSW, SWSE, SENW, SESW, SESE. What I am trying to accomplish is I want to generate an easy way of selecting my PLSS data from this table of attributes so I do not have to find them individually. I hope this makes sense.

Thank you kindly for any help!

Re: Selecting PLSS data from a table of attributes

NicholasCoffey — Fri, 25 Apr 2014 19:33:00 GMT

If you are grouping all the PLSS data into one field, e.g. a single column with T,R,S, q, qq in one column in each row (record) then it would seem you could enter it into the attribute table. This seems related to what I am doing with well logs. I have a file called "wells" and I'm in an edit mode, creating new shapefiles... I have the edit tool set to open the attribute table a point at a time so I can write in the county well log code. Later I will edit the attribute table to include elevation data so I can make cross sections and contour the water levels. You might consider creating separate columns for each location parameter in the attribute table. However, since locations are built in why not query the locations with a python macro? I don't know how to do this so if you figure it out please pm me at grnchm@gmail.com. I hope this was at least vaguely responsive and if it wasn't I apologize to you and all affected.

Re: Selecting PLSS data from a table of attributes

JamesCrandall — Mon, 28 Apr 2014 11:31:19 GMT

Hello, I thought I would post a question I am having to see if Python can work with what I'm trying to accomplish. I know Python at the most basic level so any help would be appreciated. I am trying to select the appropriate township, range, section, quarter, and quarter quarter section data from a separate table that contains what I am wanting queried. In the most Lehman terms possible, I have one data set of PLSS data and then a separate table that has a column (attribute) of specific locations such as T 1 S R 3 W Section 27 or NWSW, NWSE, NENW, NESW, NESE, SWNE, SWSW, SWSE, SENW, SESW, SESE. What I am trying to accomplish is I want to generate an easy way of selecting my PLSS data from this table of attributes so I do not have to find them individually. I hope this makes sense.

Thank you kindly for any help!

You may have to clarify a bit, but it doesn't sound like you need Python to accomplish this at all. Why not simply join your PLSS layer with your table of attributes? You can then just make your required selections on the PLSS layer.

Re: Selecting PLSS data from a table of attributes

Zeke — Mon, 28 Apr 2014 17:53:04 GMT

If your set of PLSS data has the T, R, S... in separate columns, and your other table has them joined, you could just split the joined values and run a query on that, e.g. "Twp = newlist[0] and Rng = newlist[1] and Sec = newlist[2]..." and so on.

Even easier would be to make a new field in the first, PLSS, dataset and run a field calculation to concatenate your separate values, then join like James recommends above.

Re: Selecting PLSS data from a table of attributes

benberman — Tue, 29 Apr 2014 12:49:18 GMT

you can create a sorted list of unique PLSS values

lst=sorted(set([row.getValue("attr field") for row in arcpy.SearchCursor(feature_class_name)]))