topic Re: Create Definition Query in Python Questions

Create Definition Query

jaykapalczynski — Fri, 21 May 2021 19:22:23 GMT

I am trying to figure out how to create a Definition query and run some code against those records

How do I create the Definition Query from the species name passed to this function?

Points = r"E:/xxxx/ArcGIS/Projects/UserFrontEnd/xxx@server.sde/TestLocations" def unique_values(table, field): species = field expressionValue = "common_name = '{}'".format(species) # CREATE DEFINTION QUERY FOR COMMON_NAME Points Feature Class EQUAL TO the ExpressionValue # RUN SOME CODE AGAINST THE RESULTING RECORDS FROM THE DEFINITION QUERY Grab the resulting Point records and do something

Re: Create Definition Query

DavidPike — Fri, 21 May 2021 19:43:16 GMT

definition queries work on layers. What's with the function with a table parameter? Am confused on the detail of this tbh.

Re: Create Definition Query

BlakeTerhune — Fri, 21 May 2021 19:59:55 GMT

It's related to some preprocessing work they are trying to do for a JS app.

Count Points in Polygon and symbolize on number of... - Esri Community

Re: Create Definition Query

BlakeTerhune — Fri, 21 May 2021 20:05:38 GMT

@jaykapalczynski I mentioned before that using Dissolve seems like it would get you the output you want. Have you tried that?

Re: Create Definition Query

jaykapalczynski — Sun, 23 May 2021 12:29:10 GMT

Thanks, I will look at the dissolve...

I just do not see where I apply the Polygon Feature Class and the Point Feature Class

Re: Create Definition Query

jaykapalczynski — Mon, 24 May 2021 13:22:23 GMT

OK I posted my solution on another post...

I think you all for your thoughts....it got me through this one....

I used a Select instead and then used those results to update the polygon with counts

https://community.esri.com/t5/arcgis-api-for-javascript/count-points-in-polygon-and-symbolize-on-number-of-occurrences/td-p/1059845/page/2#M73258