Latest Contributions by RPGIS

Try using the @ like the example below. "dacf_site_id = @Sid" @ references the value so if it is text then it will make it text, otherwise it will be any other value. The only other thing is potentially the field name itself. Try getting a list of field names to see if the field is called that or if you are trying to use an alias instead. ... View more

I did include the filter in mine to only look for those specific domain types but I think the issue was I set it to only filter to look for a number within the range specified. Isinstance() would have been the more appropriate approach. Isinstance is much better method so kudos on that. I wrote the sample script in a couple of minutes but had no means of testing it nor did I ask what your coded values were set to. list( set( [ d.name for d in domains for cv in d.codedValues for key, value in cv.items() if d.domainType is "CodedValue" and key in range(10) ] ) ) I am glad you were able to figure it out. ... View more

Your on the right track. The only thing you would need to do is set the FeatureSetByPortalItem for both feature and table and then create the featureset using values from both.  ... View more

You would be correct if the survey itself calculates based on another layer. Since the OP is looking to find which polygons intersect the survey points then @DavidPike is correct. If, however, the survey were set to get a calculation everytime a survey is submitted then arcade would work. ... View more

I am confused by the line below. Is there a field called table name. var l_features = Filter(FeatureSetByName($datastore, "Maximo_location"), "objectrefid = @l_id AND tablename = 'ElectricDevice'") ... View more

Hi @RavindraSingh, Could you please post a snippet of the code that you are using if it does not contain sensitive information? It sounds like you are trying to accomplish something that similar to what we have since we also use Maximo as well. Well not us but another department that we work with. ... View more

I ran some tests and @DavidPike is correct if you want to symbolize based on another polygon attribute from a survey. Once the join view is created then I believe you can symbolize the feature layers, using arcade, that differentiate based on count. The only other option that I see is if you configure your survey to populate a field and have an arcade expression calculate that field based on another layer. You can then use arcade to symbolize the colors based on the counts of that field. ... View more

We are looking to do the same but most chatbots behave in a similar manner that you created. The only slight difference is that they are session based but I believe you should be able to filter based on whomever logs in or if you can set it up so that it filters based on a name. ... View more

In ArcGIS Dashboards this is a capability and it might be a capability in the map viewer symbology but I'll need to run a few tests to see what expression can make it possible.  ... View more

Just out of curiosity, is your project setup to automatically allow edits to happen when the project is opened up and feature or table attributes can be updated? This could be causing your issue if the data source is something other than a feature class or table in either an sde or gdb. The other thing you mentioned is that you are working with a file table. If you could please explain that further then it might be easier for anyone or any of us to help you with your given situation? It sounds like your file table might be either an excel spreadsheet or some other table. If that is the case have you tried importing the table and see if the results are the same. You can use python to read other tables like excel but trying to run any edits on those tables or pull information from them could result in less than desirable behaviors. I have run into similar situations using external tables and usually importing them and then running python code on that table usually fixes the issue. It is often best to run python as a standalone script using the modules that are designed to read those file types instead of bringing them into pro. @HaydenWelch may be able to affirm this or have a different take than mine. ... View more

Hi @LizAbbey, Here is my suggestion for simplifying and perhaps help troubleshoot your code at least for the validation. def updateParameters(self): # Populate domain names from workspace (no type filtering) db = self.params[0].valueAsText if db is not None: if '.sde' in db or '.gdb' in db: domains = arcpy.da.ListDomains(db) self.params[1].filter.list = list( set( [ d.name for d in domains for cv in d.codedValues for key, value in cv.items() if d.domainType is "CodedValue" and key in range(10) ] ) ) # Populate subtype field list with only Integer or SmallInteger fields fcs = {} if db is not None: walk = arcpy.da.Walk(workspace, datatype="FeatureClass") fcs = { filename : os.path.join( root, filename ) for root, directories, filenames in walk for filename in filenames } self.params[2].filter.list = list( fcs ) if self.params[2].value: table = self.params[2].valueAsText if table in fcs: table = fcs[table] numfields = [ f.name for f in arcpy.ListFields(table) if f.type in ["Integer", "SmallInteger"] ] if len( numfields ) > 0: self.params[3].filter.list = int_fields # My suspicion is the parameters need to be returned but I would need to double # check that since it has been some time since I created a python tool. # -- return self.params return This should at least help with the validation and maybe help get you in the right direction. I will need to dig in deeper for the other half but I think @HaydenWelch, @DanPatterson, or @jcarlson may have a better idea and also see if my suggestion is incorrect in some ways.   ... View more

Yes. If you have editor tracking on or any modifiable date field then all you need to search for are the dates that are closely associated with whatever timeframe you specify. Python is incredibly flexible in terms of dates. Like I also said earlier, within the cursor you can add a SQL query expression to quickly filter records. For example,  import arcpy # Define the feature class or table feature_class = "path_to_your_feature_class" # Define the SQL query (e.g., select features where 'Population' > 1000) sql_query = "Population > 1000" # Use a SearchCursor to iterate through the filtered records with arcpy.da.SearchCursor(feature_class, ["Name", "Population"], sql_query) as cursor: for row in cursor: print(f"Name: {row[0]}, Population: {row[1]}") This code was autogenerated by Microsoft's CoPilot but it should give some ideas. The SQL query can filter for only records that meet that criteria. ... View more

Hi @ChaceCarpenter, I would highly suggest checking out python cursors as to potentially help speed up some processes. Often times it is easier to only append the necessary data rather than bulk updates. In conjunction with the cursors you can also use SQL query statements to also help speed up the process as well. ... View more