Search Results

Groups" AS "point_gr", SUM(p.Data) AS "value", COUNT(p.id) AS "points_count" FROM "cells" AS c JOIN "points" AS p ON st_intersects(c.geometry, p.geometry) GROUP BY c.id, p." …

Another solution using only native QGIS 3 tools. Let's assume there two layers "cells" and "points" with its corresponding attribute tables, see image below. Step 1. Use a 'Join attributes by locatio …

Another option can be the allFeatureIds() method from the QgsFeatureSource class: num_of_features = len(layer.allFeatureIds())

Try also the "DBSCAN clustering" geoalgorithm. It contains a setting called 'Maximum distance between clustered points' and will provide in the end the "CLUSTER_SIZE" attribute.

.*, COUNT(*) AS "numpois" FROM "polygons" AS poly JOIN "points" AS poi ON st_within(poi.geometry, poly.geometry) GROUP BY poly." … So, the new query will look like SELECT poly.*, COUNT(*) AS "numpois", GROUP_CONCAT(poi." …

Use the "Count points in polygon" tool, which can be found under Vector > Analysis Tools > Count points in polygon as well as in the Processing Toolbox (Ctrl+Shift+T). …

layer.featureCount() # setting up a new name layer.setName(f"{name} [{n}]") However, if this operation happens more often, one should think of a more programmatic way of showing the feature count … References: Rename layers with PyQGIS script Getting feature count of QgsVectorLayer using PyQGIS? Was QgsMapLayerRegistry being removed in QGIS 3? …

Apply the "Count Polygon Overlap" model with a desired input layer and get the output like this References: QGIS Resource Sharing - Documentation …

os.path import normpath from shapefile import Reader absolute_path_to_shp = normpath("C:/Users/taras/files/cluster_test.shp") shp = Reader(absolute_path_to_shp) print(shp.numRecords) # returns features count …

SELECT "COUNTY_NM" || ' | ' || GROUP_CONCAT("layer" || ' : ' || n) AS res FROM ( SELECT "COUNTY_NM", "layer", COUNT("layer") AS n FROM "points" GROUP BY "layer", "COUNTY_NM") GROUP BY "COUNTY_NM …

Try using the "Identify Features" tool (Ctrl+Shift+I) from the Attributes Toolbar. Click on the target feature and check the (Derived) tab, where you may see the 'Vertices' attribute

As an alternative you may try the following expression: array_length(string_to_array("ID", delimiter:='|'))

Also can be achieved with this expression count(1, group_by:=is_selected()), based on the is_selected() function. Returns True if a feature is selected. … The total number of selected features will be represented in the row called 'Count'. References: DefKey | QGIS 3.10 keyboard shortcuts …

Extending the idea from @geozelot it is possible to count the polygons via grouping by their geometry. … With the following expression: SELECT GROUP_CONCAT("id") AS ids, GROUP_CONCAT("uniqueID") AS uniques, COUNT(*) AS NumGeom, -- COUNT(*) geometry AS geom FROM "poly_test" GROUP BY …

With the following query, it is possible to count points within a polygon layer, grouped by an attribute of the points. … (poi.geometry, poly.geometry) AND poi.attribute = 'A' GROUP BY poly.id ) ON poly.id = idA LEFT JOIN ( SELECT poly.id AS idB, count(1) AS countB FROM "Random points in polygons" AS …