New answers tagged

0

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'


1

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 ...


2

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, ...


2

SELECT sum(st_area(st_intersection(grid.geom, affected.geom))) FROM grid, affected WHERE grid.color = 'green' and st_instersects(grid.geom, affected.geom);


1

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]%\')',


1

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.


2

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 ...


0

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