QGIS 2.8.1 – Useful Functions and Operators – Field Calculator

Calculate eastings and northings of centroid within polygon layer

Calculate area and perimeter of a polygon layer

Calculate eastings and northings of a point layer

Calculate the length of a line layer

Capitalise column values
eg upper(Town)
Edinburgh becomes EDINBURGH

Camel case column values
EDINBURGH becomes Edinburgh
DUDDINGSTON LOCH becomes Duddingston Loch

Lower case column values

Replacethis withthat in string
replace(string, replacethis, withthat)

Concatenate string a and string b
Concatenate a || b

Division and next line Multiplication

area/10,000 – divides area field by 10,000 (eg going from m2 to Hectares

Remove decimals from a field
eg 7954.235 becomes 7954 and 456525.325 becomes 456525

Index a set of polygons

Functions and Operators Official Notes for Field Calculator

About Mark

Mark Brooks a forty something individual working and living in and around Edinburgh
This entry was posted in All, Digital Mapping, QGIS 2.8.1, QGIS General. Bookmark the permalink.