New answers tagged query
I am posting this just so you can mark this format as the answer. The IN syntax is the most compact way to write the expression you want: [OU] IN ('001', '002') AND [Formation] = 'Residuum'
Yes it's possible to do this in python. Check out the documentation on the Make Query Layer tool http://pro.arcgis.com/en/pro-app/tool-reference/data-management/make-query-layer.htm You can also use the make query table tool (http://pro.arcgis.com/en/pro-app/tool-reference/data-management/make-query-table.htm); if you specify a shape field the query table ...
Similar to what Zoltan has said, but you want to group by the color, which will then get you the sums for each color. SELECT sum(ST_Area(ST_Intersection(grid.geom, affected.geom))), grid.color FROM grid, affected WHERE ST_Intersects(grid.geom, affected.geom) GROUP BY grid.color; The final WHERE ST_Intersects(...) will not affect the answer, ...
SELECT sum(st_area(st_intersection(grid.geom, affected.geom))) FROM grid, affected WHERE grid.color = 'green' and st_instersects(grid.geom, affected.geom);
The only change you should need to make to your original Flex where clause is to escape the single quotes around the value using the slash character: expression: 'upper(ICAOcode) LIKE upper(\'%[value]%\')',
If you select "table_1" for the Update existing field option, try using this expression: if( "table_2" = 'test', 'y', "table_1") Basically, you're using an IF THEN ELSE statement.
Perhaps an expression like this would work better: [OU] = '001' AND [Formation] = 'Residuum' OR [OU] = '002' AND [Formation] = 'Residuum' It's a little tedious in its formatting, but should return the results that you're after. A little more elegant expression would be: ([OU] = '001' OR [OU] = '002') AND [Formation] = 'Residuum' Either one should ...
With the new virtual layer you can now use SQL on any layer in QGIS, for example the airport Shapefile from the QGIS sample data: To count the number of airports by USE type and compute the average elevation use: The results are loaded as a new layer:
Top 50 recent answers are included