topic Re: Select by many attributes and then zoom to selected in ModelBuilder Questions

Select by many attributes and then zoom to selected

MichaelMichaelides — Fri, 27 Apr 2018 09:38:15 GMT

Hello. I need the help of the community and if possible the help of an ESRI’s staff.

After days and days of searching and reading different posts in the net and many dead ends (broken links) in ESRI’s site, I couldn’t find a solution to my problem.

My problem is that I’m trying to give a tool to some colleagues (ArcMap 10.5), that don’t have any experience with GIS software, which would help them to zoom to a selected parcel by selecting a value from various drop-down lists and not writing the SQL query themselves.

The tool which I’m trying to build in Model Builder (coding is not my strong background), will take the following variables: District, Town/Village, Quarter, Block, Sheet, Plan, and Parcel Number. Combining all those variables make the parcel selection unique.

Those Variables are different columns within a single Feature Class called “Parcels”.

In my model I used a tool that I had from an old search (now is a broken link) called “ChooseFieldValueToolbox10.tbx”. This tool let me expose as a list, the values from a field. Then I found the code (that actually works) from another post in the community (https://community.esri.com/thread/8396 - thanks Paul Lang), to zoom to selected feature.

Through my many failed attempts I decided to make the model (for testing purposes) with only one variable and not use all the aforementioned variables, just to see if it works, which it does (screenshot 1). For example the user to select a District or to select a Town as different models each time.

The problem is when I want to make combination of all those parameters. I can’t force the model to select from current selection and then zoom to final selection.

I attached a screenshot (screenshot 2) of my model, with the use of the first two variables (District and Town/Village).

When I run the tool, at the interface (screenshot 3), the second selection (Value (2)) does not populate the values based on the first selection (Value), instead it shows all the values of the field (Field(2)), and then nothing runs as it supposed to do. For example if in the second “Select by attributes” tool (screenshot 2), I have as a “Selection Type = SUBSET_SELECTION”, nothing gets selected so the zoom doesn’t work. If in the second “Select by attributes” tool (screenshot 2), I have as a “Selection Type = ADD_TO_SELECTION”, it selects all the rows that have the same “Dist_code” and doesn’t take account the Town/Village.

Sorry for the long post but I tried to make my problem as clear as possible.

Any ideas?

Re: Select by many attributes and then zoom to selected

JakeSkinner — Fri, 27 Apr 2018 11:42:51 GMT

Hi Michael,

I would recommend replacing your first Select Layer by Attribute with the Make Feature Layer tool. You can apply an expression within this tool that will create a in-memory layer of only the features that apply to the expression. You can then perform your second select by attribute using this in-memory layer as the input.

Re: Select by many attributes and then zoom to selected

MichaelMichaelides — Mon, 30 Apr 2018 08:04:14 GMT

Jake hello. Thanks for taking the time to answer my question.

First of all i would like to inform you that i found an error in my model. In the second "Select by attributes" in the expression there was an oversight. At first (screenshot 2 - first post), i wrote VIL_NM_E = '%Output Value% ' instead of VIL_NM_E = '%Output Value (2)% ' and there was something like a conflict with the first expression ("DIST_CODE" = %Output Value%).

After that correction, my model still didn't populate the values in the second drop down list (Value(2)) based on the selected District and instead it showed all the villages but if i selected a district and one village that belonged to that district after running the model, ArcMap zoomed in to the selected feature, correctly (screenshot 4 and 5).

Now if by a mistake i selected a village that it didn't belong to that district (due to the fact that i see all vilages from the list), instead of an error, ArcMap zoomed in to a different village that the one that i selected. That village as i noticed was the first village based on an alphabetical order, that belongs to the district that i previously chose (screenshot 6 and 7).

Then i tried your recommendation (screenshot 8), but it didn't work at all. Also in the (Value(2)), i got only one value regardless the ditrict that i choose (screenshot 9). When i run the model i got an error (screenshot 10). In the "Make Feature Layer" expression, i used the expression from the first "Select by attributes", which was "DIST_CODE" = %Output Value%. I don't know what i might did wrong.

I prepared some data containing a feature class called "Vill_selected", the script tool that my model is based on, my model that i run and a model based on your recommendation. How can i send them to you (if you want to give it a try)?

Re: Select by many attributes and then zoom to selected

JakeSkinner — Mon, 30 Apr 2018 16:44:49 GMT

You can add the data to this thread by clicking the 'Use Advanced Editor' in the top right of the reply. You will then see an option to Attach files in the lower left corner.

Re: Select by many attributes and then zoom to selected

MichaelMichaelides — Wed, 02 May 2018 05:55:22 GMT

Hi Jake. Thanks for replying.

I attached as a zip file the data that i mentioned in my last comment.

Thanks again for your time and effort.

Regards

Mike

Re: Select by many attributes and then zoom to selected

JakeSkinner — Thu, 03 May 2018 14:07:25 GMT

Michael,

I recreated the model and used references to all of the parameters (i.e. %Field%, %Value%) in the select by attributes and this worked for me.

Re: Select by many attributes and then zoom to selected

MichaelMichaelides — Thu, 03 May 2018 17:12:34 GMT

Jake hello.

I saw your answer but I’m not at work to try it.

Though if I understood correctly you did what I did and the model worked? Did I do something wrong? Please can you clarify this for me?

Re: Select by many attributes and then zoom to selected

MichaelMichaelides — Fri, 04 May 2018 07:06:50 GMT

Jake good morning.

Ignore my previous answer. I couldn't see in my phone that you attached something.

So today, i opened the zip file that you sent me and i used the "mymodel_test".

Still doesn't working correctly.

The values in the "Value(2)" drop down list shows all villages in the feature class regardless of the District Value selection. In the screenshot you can see from the attribute table that for the District Code = 3, the number of records are 8, but the drop down list in the model shows more than eight entities.

Any more ideas?

Thank you and regards.

Mike

Re: Select by many attributes and then zoom to selected

RandyBurton — Sun, 12 Dec 2021 08:38:11 GMT

Hello Michael,

After reviewing you project, I think a script tool solution similar to one in Conditional Drop Down Lists - Tool Validator will work for you (see last code example in the discussion -- the ESRI forum you mentioned was also mentioned in this discussion). In this specific example, the tool takes an input feature and would populate 3 drop down lists with values from 3 fields in that feature. The work of populating the lists is done in the updateParameters section of the ToolValidator.

As your needs call for using 7 fields, some blocks of code (such as this snippet) will need to be duplicated and modified to build the final where clause. Each block will drill down to get the user closer to the desired parcel, and the fields will need to be processed in proper sequence.

fc, c_3 = str(self.params[0].value), 'Setting' # Check field 'Setting'
if fieldNames['HarvestArea'] == u'String':
    wc3 = "{} AND HarvestArea = '{}'".format(wc2, str(self.params[2].value)) # field is string type
else:
    wc3 = "{} AND HarvestArea = {}".format(wc2, str(self.params[2].value)) # field assumed to be a number field
self.params[3].filter.list = [str(val) for val in sorted(set(row.getValue(c_3) for row in arcpy.SearchCursor(fc,fields=c_3,where_clause=wc3)))]
if self.params[3].value not in self.params[3].filter.list:
    self.params[3].value = self.params[3].filter.list[0]‍‍‍‍‍‍‍‍

I'm not sure if the script tool really needs to be part of a model. If the tool's only goal is to select and zoom to a parcel, perhaps you wouldn't need a model.

Regarding your tool, will users always be searching the same feature class for parcels? Or if they are searching several features, is the structure of the feature always the same -- that is, do the features always contain the same fields (same field name and type)?

What are the field names that correspond to District, Town/Village, Quarter, Block, Sheet, Plan, and Parcel Number? In one of the photos above I see the fields: VILL_CCD, DIST_CODE, VIL_NM_E, VIL_MN_G, VIL_CODE. Are these the field names?

If you are able to attach a few rows of sample data from your "parcels" layer, that would be helpful.

Re: Select by many attributes and then zoom to selected

MichaelMichaelides — Wed, 09 May 2018 06:05:16 GMT

Mr Burton hello and thank you for your answer.

Before contacting you, I did try to use the final code that you provided for the tool validator in the Conditional Drop Down Lists - Tool Validator, replacing "Forest" with "DIST_CODE", "HarvestArea" with "VIL_CODE" and "Setting" with "QRTR_NM_E". Also i replaced the py script with the one that you provided but there i didn't change anything, since "forestVal", "harvestVal", and "settingVal" where not refering with these names in the code before, so i assumed would be ok if i used the original. So after doing this i tried to run the script but i got the following screenshots.

Forgive me for my ignorance but something that bothered me (and could be the problem), was the answer that you provided at the 21st of April and you had this code before the tool validator class block. Should i use this code in the py script merging it with the py code from your last comment? Don't use it at all?

The reason that i want to make it a model is that i'm not familiar with programming.

My department has two feature classes for parcels so i would like them to use the tool depending on what their need is.

The column name and field types are the same for both Feature classes. I attached some test data. The fields that will be used based on ierarchy are DIST_CODE, VIL_CODE, QRTR_CODE, BLCK_CODE, SHEET, PLAN, PARCEL_NBR.

Also I have two questions:

1. Will I be able to use this tool with an SDE Feature class that will have a joined table and some of the fields will be from that table?

2. Let's say that the script is ready with no problems, how will I use all the Values that the user selected to make them as one input for zoom in? The original tool that I found and used (ChooseFieldValueToolbox10.tbx) had one Value, one Output and that's why in my first post i used it twice in my model.

Thanks again

Mike

Re: Select by many attributes and then zoom to selected

RandyBurton — Thu, 10 May 2018 06:20:05 GMT

I've been studying the information you attached. I haven't done a lot with model builder; the other post I mentioned was working with a script tool. The script tool could be used in a model, but would also perform a specific function on its own.

You mention the code posted on 21 April. That was an example of debugging the ToolValidator section of a script tool. Since this section is inside a script tool, it is difficult to see what is happening in the module. The first 16 lines set up the ToolValidator class and provide it with some test values. The last few lines set up a validator and run the updateParameters and updateMessages blocks. Once the code runs as expected, then just the middle section is pasted into the script tools validation section.

You ask if the tool will work with an SDE feature class that will have a joined table. I haven't worked with an SDE feature class, but I would think it probably would. Perhaps Jake Skinner‌ would have a better idea.

Regarding your remaining question, in the other post we were modifying the script tool to do multiple fields, in this case 3. We just need to add an additional 4 fields for your project.

Re: Select by many attributes and then zoom to selected

RandyBurton — Sun, 12 Dec 2021 08:38:15 GMT

I've worked with the sample data that you have provided and have a script tool that might give you an idea for your project. It is based on code in this thread: Conditional Drop Down Lists - Tool Validator. If a feature is selected that has the required fields, it will allow the user to drill down to a parcel. Currently the script just selects the parcel, but code can be added to zoom to it.

Most of the work is done in the updateParameters module of the ToolValidator class:

class ToolValidator(object):

    def __init__(self):
        import arcpy
        self.params = arcpy.GetParameterInfo()

    def initializeParameters(self):
        # (initializeParameters code here)
        return

    def updateParameters(self):

        if self.params[0].value: # feature has been selected
            useFields = [u'DIST_CODE', u'VIL_CODE', u'QRTR_CODE', u'BLCK_CODE', u'SHEET', u'PLAN', u'PARCEL_NBR'] # name of fields used by tool - in order
            desc = arcpy.Describe(self.params[0].value)  # information about the input feature
            fieldNames = { f.name: f.type for f in desc.fields } # dictionary used to keep field names and types together

            if set(useFields).issubset(fieldNames.keys()): # all fields were found by tool

                fc, c_1 = str(self.params[0].value), useFields[0] # DIST_CODE
                self.params[1].filter.list = [str(val) for val in sorted(set(row.getValue(c_1) for row in arcpy.SearchCursor(fc,fields=c_1)))]
                if self.params[1].value not in self.params[1].filter.list:
                    self.params[1].value = self.params[1].filter.list[0]

                fc, c_2 = str(self.params[0].value), useFields[1] # VIL_CODE
                if fieldNames[useFields[0]] == u'String': 
                    wc2 = "{} = '{}'".format(useFields[0], str(self.params[1].value)) # field is string
                else: 
                    wc2 = "{} = {}".format(useFields[0], str(self.params[1].value)) # field assumed to be a number field
                self.params[2].filter.list = [str(val) for val in sorted(set(row.getValue(c_2) for row in arcpy.SearchCursor(fc,fields=c_2,where_clause=wc2)))]
                if self.params[2].value not in self.params[2].filter.list:
                    self.params[2].value = self.params[2].filter.list[0]

                fc, c_3 = str(self.params[0].value), useFields[2] # QRTR_CODE
                if fieldNames[useFields[1]] == u'String':
                    wc3 = "{} AND {} = '{}'".format(wc2, useFields[1], str(self.params[2].value)) # field is string
                else:
                    wc3 = "{} AND {} = {}".format(wc2, useFields[1], str(self.params[2].value)) # field assumed to be a number field
                self.params[3].filter.list = [str(val) for val in sorted(set(row.getValue(c_3) for row in arcpy.SearchCursor(fc,fields=c_3,where_clause=wc3)))]
                if self.params[3].value not in self.params[3].filter.list:
                    self.params[3].value = self.params[3].filter.list[0]

                fc, c_4 = str(self.params[0].value), useFields[3] # BLCK_CODE
                if fieldNames[useFields[2]] == u'String':
                    wc4 = "{} AND {} = '{}'".format(wc3, useFields[2], str(self.params[3].value)) # field is string
                else:
                    wc4 = "{} AND {} = {}".format(wc3, useFields[2], str(self.params[3].value)) # field assumed to be a number field
                self.params[4].filter.list = [str(val) for val in sorted(set(row.getValue(c_4) for row in arcpy.SearchCursor(fc,fields=c_4,where_clause=wc4)))]
                if self.params[4].value not in self.params[4].filter.list:
                    self.params[4].value = self.params[4].filter.list[0]

                fc, c_5 = str(self.params[0].value), useFields[4] # SHEET
                if fieldNames[useFields[3]] == u'String':
                    wc5 = "{} AND {} = '{}'".format(wc4, useFields[3], str(self.params[4].value)) # field is string
                else:
                    wc5 = "{} AND {} = {}".format(wc4, useFields[3], str(self.params[4].value)) # field assumed to be a number field
                self.params[5].filter.list = [str(val) for val in sorted(set(row.getValue(c_5) for row in arcpy.SearchCursor(fc,fields=c_5,where_clause=wc5)))]
                if self.params[5].value not in self.params[5].filter.list:
                    self.params[5].value = self.params[5].filter.list[0]

                fc, c_6 = str(self.params[0].value), useFields[5] # PLAN
                if fieldNames[useFields[4]] == u'String':
                    wc6 = "{} AND {} = '{}'".format(wc5, useFields[4], str(self.params[5].value)) # field is string
                else:
                    wc6 = "{} AND {} = {}".format(wc5, useFields[4], str(self.params[5].value)) # field assumed to be a number field
                self.params[6].filter.list = [str(val) for val in sorted(set(row.getValue(c_6) for row in arcpy.SearchCursor(fc,fields=c_6,where_clause=wc6)))]
                if self.params[6].value not in self.params[6].filter.list:
                    self.params[6].value = self.params[6].filter.list[0]

                fc, c_7 = str(self.params[0].value), useFields[6] # PARCEL_NBR
                if fieldNames[useFields[5]] == u'String':
                    wc7 = "{} AND {} = '{}'".format(wc6, useFields[5], str(self.params[6].value)) # field is string
                else:
                    wc7 = "{} AND {} = {}".format(wc6, useFields[5], str(self.params[6].value)) # field assumed to be a number field
                print wc7 # # Debug # #
                self.params[7].filter.list = [str(val) for val in sorted(set(row.getValue(c_7) for row in arcpy.SearchCursor(fc,fields=c_7,where_clause=wc7)))]
                if self.params[7].value not in self.params[7].filter.list:
                    self.params[7].value = self.params[7].filter.list[0]

                # output completed whereClause
                if fieldNames[useFields[6]] == u'String': 
                    self.params[8].value = "{} AND {} = '{}'".format(wc7, useFields[6], str(self.params[7].value)) # where normally assumes string values for fields
                else:
                    self.params[8].value = "{} AND {} = {}".format(wc7, useFields[6], str(self.params[7].value)) # Setting assumed to be a number field

            else: # at least one of the field names does not exist in feature; using the parameter to hold an error message

                if  useFields[0] not in fieldNames.keys(): # DIST_CODE
                    self.params[1].value = "ERROR: Field '{}' not in selected feature class".format(useFields[0])
                if  useFields[1] not in fieldNames.keys(): # VIL_CODE
                    self.params[2].value = "ERROR: Field '{}' not in selected feature class".format(useFields[1])
                if  useFields[2] not in fieldNames.keys(): # QRTR_CODE
                    self.params[3].value = "ERROR: Field '{}' not in selected feature class".format(useFields[2])
                if  useFields[3] not in fieldNames.keys(): # BLCK_CODE
                    self.params[4].value = "ERROR: Field '{}' not in selected feature class".format(useFields[3])
                if  useFields[4] not in fieldNames.keys(): # SHEET
                    self.params[5].value = "ERROR: Field '{}' not in selected feature class".format(useFields[4])
                if  useFields[5] not in fieldNames.keys(): # PLAN
                    self.params[6].value = "ERROR: Field '{}' not in selected feature class".format(useFields[5])
                if  useFields[6] not in fieldNames.keys(): # PARCEL_NBR
                    self.params[7].value = "ERROR: Field '{}' not in selected feature class".format(useFields[6])

        return

    def updateMessages(self):
        
        self.params[0].clearMessage() # clear all error messages
        self.params[1].clearMessage()
        self.params[2].clearMessage()
        self.params[3].clearMessage()
        self.params[4].clearMessage()
        self.params[5].clearMessage()
        self.params[6].clearMessage()
        self.params[7].clearMessage()
        
        if self.params[0].value is not None: # set error message if field not in feature so user can correct problem
            useFields = [u'DIST_CODE', u'VIL_CODE', u'QRTR_CODE', u'BLCK_CODE', u'SHEET', u'PLAN', u'PARCEL_NBR'] # name of fields used by tool - in order

            if self.params[7].value is not None:
                if self.params[7].value.startswith("ERROR:"):
                    # self.params[7].value = None # clear error message in parameter value, if desired
                    self.params[0].setErrorMessage("Input FC '{}' does not contain field '{}'".format(self.params[0].value, useFields[6]))
                    self.params[7].setErrorMessage("Field '{}' is not in Input FC '{}'".format(useFields[6], self.params[0].value))

            if self.params[6].value is not None:
                if self.params[6].value.startswith("ERROR:"):
                    # self.params[6].value = None # clear error message in parameter value, if desired
                    self.params[0].setErrorMessage("Input FC '{}' does not contain field '{}'".format(self.params[0].value, useFields[5]))
                    self.params[6].setErrorMessage("Field '{}' is not in Input FC '{}'".format(useFields[5], self.params[0].value))

            if self.params[5].value is not None:
                if self.params[5].value.startswith("ERROR:"):
                    # self.params[5].value = None # clear error message in parameter value, if desired
                    self.params[0].setErrorMessage("Input FC '{}' does not contain field '{}'".format(self.params[0].value, useFields[4]))
                    self.params[5].setErrorMessage("Field '{}' is not in Input FC '{}'".format(useFields[4], self.params[0].value))

            if self.params[4].value is not None:
                if self.params[4].value.startswith("ERROR:"):
                    # self.params[4].value = None # clear error message in parameter value, if desired
                    self.params[0].setErrorMessage("Input FC '{}' does not contain field '{}'".format(self.params[0].value, useFields[3]))
                    self.params[4].setErrorMessage("Field '{}' is not in Input FC '{}'".format(useFields[3], self.params[0].value))

            if self.params[3].value is not None:
                if self.params[3].value.startswith("ERROR:"):
                    # self.params[3].value = None # clear error message in parameter value, if desired
                    self.params[0].setErrorMessage("Input FC '{}' does not contain field '{}'".format(self.params[0].value, useFields[2]))
                    self.params[3].setErrorMessage("Field '{}' is not in Input FC '{}'".format(useFields[2], self.params[0].value))

            if self.params[2].value is not None:
                if self.params[2].value.startswith("ERROR:"):
                    # self.params[2].value = None # clear error message in parameter value, if desired
                    self.params[0].setErrorMessage("Input FC '{}' does not contain field '{}'".format(self.params[0].value, useFields[1]))
                    self.params[2].setErrorMessage("Field '{}' is not in Input FC '{}'".format(useFields[1], self.params[0].value))

            if self.params[1].value is not None:
                if self.params[1].value.startswith("ERROR:"):
                    # self.params[1].value = None # clear error message in parameter value, if desired
                    self.params[0].setErrorMessage("Input FC '{}' does not contain field '{}'".format(self.params[0].value, useFields[0]))
                    self.params[1].setErrorMessage("Field '{}' is not in Input FC '{}'".format(useFields[0], self.params[0].value))

        return
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

The script I used for testing:

import arcpy

# to drill down to parcel number, use fields: DIST_CODE, VIL_CODE, QRTR_CODE, BLCK_CODE, SHEET, PLAN, PARCEL_NBR
# District, Town/Village, Quarter, Block, Sheet, Plan, and Parcel Number
inFC = arcpy.GetParameterAsText(0) # input feature class (Input, Data Type 'Feature Layer')
dist_code = arcpy.GetParameterAsText(1) # selected value of DIST_CODE field (Input, Data Type 'String')
vil_code = arcpy.GetParameterAsText(2) # selected value of VIL_CODE field (Input, Data Type 'String')
qrtr_code = arcpy.GetParameterAsText(3) # selected value of QRTR_CODE field (Input, Data Type 'String')
blck_code = arcpy.GetParameterAsText(4) # selected value of BLCK_CODE field (Input, Data Type 'String')
sheet_val = arcpy.GetParameterAsText(5) # selected value of SHEET field (Input, Data Type 'String')
plan_val = arcpy.GetParameterAsText(6) # selected value of PLAN field (Input, Data Type 'String')
parcel_nbr = arcpy.GetParameterAsText(7) # selected value of PARCEL_NBR field (Input, Data Type 'String')
whereClause = arcpy.GetParameterAsText(8) # set by ToolValidator updateParameters (Output, Derived, Data Type 'String')

arcpy.AddMessage("Where clause used: {}".format(whereClause)) 
arcpy.SelectLayerByAttribute_management(inFC, "NEW_SELECTION", where_clause=whereClause)

n = arcpy.GetCount_management(inFC)
arcpy.AddMessage("Number of records selected: {}".format(n))‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

And a couple of screen shots.

I've attached the code and toolbox. You may need to edit the location of the script in the toolbox. I've also included a debug version of the ToolValidator code should you wish examine it.

I'm not sure how a join would affect the tool as the field names sometimes get appended with the table name.

Re: Select by many attributes and then zoom to selected

MichaelMichaelides — Fri, 11 May 2018 12:11:44 GMT

Mr. Burton hello. THANK YOU so much for your help and effort.

I gave it a first try and works perfect.

I will make some more testings and i will let you know.

Have a nice weekend.

Regards

Mike

Re: Select by many attributes and then zoom to selected

MichaelMichaelides — Mon, 21 May 2018 11:37:59 GMT

Mr Burton hello again. I tried your script and i incorporated teo models of mine.

Though it does work very nice when my data are a small amount of the original, when i use the SDE feature class where theere are around 1,5 million parcels then things get very difficult. I mean it takes a lot of time to show the values per field thus making it inconvinient to use.

Any ideas how to improve the speed of the script?

Thank you for you time and efforts

Regards

Mike

Re: Select by many attributes and then zoom to selected

RandyBurton — Wed, 23 May 2018 04:22:09 GMT

I must admit that I have not worked with SDE feature classes. I'm not sure if building indexes for the columns used by the tool will improve the speed.

The tool works to build a parcel UID by starting with a district code, adding a village code, quarter code, block code, etc. It might be possible to build a table with only the unique combinations of the first four parts of the parcel code that contains much fewer rows than the feature class. Perhaps this would allow your user to start building a correct query that could then be used to make the final query.

I notice that the parcel UID might point to the sheet and plan numbers, and that the plan number would point to the parcels that are involved. It might be possible to reorder the fields queried and perhaps eliminate one.

These are just some initial thoughts. Hope it helps.