2
votes
How to see the size of individual layers in a geopackage
Use the SQLite utility "sqlite3_analyzer https://www.sqlite.org/sqlanalyze.html
Usage example and an excerpt of the very comprehensive report showing the data for one data layer. Notice that it ...
- 62k
2
votes
Why is the "Label Properties" window greyed out for editing in QGIS?
To activate it, you have make some settings:
Go to the layers styling Dock (F7)
Click on the Data-definded overide box of the item which you want to change
Activate "Store Data in the Project&...
- 9,530
2
votes
Update fields in table in PostGIS database by joining attribute by field value from a layer
You could join layer B with layer A on segment_id (layerproperties -> joins). Then you can open the attributetable and sort the field with missing values in table A. Then select all rows with ...
2
votes
Accepted
Update fields in table in PostGIS database by joining attribute by field value from a layer
Import table B to PostgreSQL and:
UPDATE test.table_a AS a
SET
attr1 = b.attr2,
attr2 = b.attr2,
attr3 = b.attr3
FROM test.table_b as b
WHERE a.segment_id = b.segment_id
See: How to do ...
- 67.1k
2
votes
QGIS - selecting single polygon highlights multiple polygons
You could use Actions:
Open the layer properties and navigate to actions
Add a new Python action with the following code
layer = QgsProject.instance().mapLayer('[%@layer_id%]')
field = 'my_field'
...
- 32.6k
1
vote
Accepted
How to see the size of individual layers in a geopackage
This works if your Sqlite has dbstat support built in, which someone in the comments says isn't so for the Windows OSGeo4W. Maybe submit a feature request for it?
Add one layer from your geopackage to ...
- 61.5k
1
vote
Identifying district boundaries outliers in QGIS
Assuming your boundary layer has an attribute that shows the district name, and assuming your facilities layer also has an attribute that shows the district it is supposed to be in, use the Join ...
- 9,207
Only top scored, non community-wiki answers of a minimum length are eligible