[GIS] How to update a bulk selection of fields using field calculator in QGIS 2.8.1

field-calculatorqgis

I have an attribute table showing vegetation communities. The table has three columns ("ID", "Veg Comm" and "Area_ha". Instead of having to copy and paste text after each polygon created into each field (i.e. coastal wattle scrub), is there a way to highlight a selection and mass copy?

Best Answer

Yes, in the recent versions of QGIS, if you have a selection the 'Only update x selected features' checkbox is enabled as default. Any expression written will be updates to the chosen column of the selected rows. Below picture is from QGIS 2.8.1.

enter image description here

Related Solutions

[GIS] How to select multiple features using advanced search SQL in QGIS

It looks like you have the right idea. Make sure you have AND between each. Try:

ssoln_1 = 100 AND ssoln_2 = 100 AND ssoln_3 = 100

[GIS] Batch Update Fields in Field Calculator or Model

You should be able to write this in a python scripting using an update cursor fairly easily.

import arcpy
tablename = "c:\temp\*NAMEOFYOURTABLE*"
fieldvalues = ['fieldname1','fieldname2','fieldname3'......'fieldnameX']

cur = arcpy.UpdateCursor(tablename)
for row in cur:
    sourcevalue = row.getValue('*name of field where source value coming from*')
    for f in fieldvalues:
        row.setValue(f, sourcevalue)
    cur.updateRow(row)

Best Answer

Related Solutions

[GIS] How to select multiple features using advanced search SQL in QGIS

[GIS] Batch Update Fields in Field Calculator or Model

Related Question