Scaling of piezoelectric properties in nanometre to micrometre scale