communes_CH_indicators: Swiss communes socio-demographic indicators

In d-qn/swiMap: Misc Functions to plot geographic maps, mainly swiss maps (cantonal, districts and communes)

Description

Load socio-demographic data by the Swiss Statistical Office.

Process Portraits régionaux de la Suisse commune xls

Load the NPA/PLZ/ Zip code for Switzerland

Usage

loadCommunesCHportraits()

processPortraitsRegionauxCommune(file = "je-f-21.03.01.xls",
  output = "communesCH_2016_indicators_je-f-21.03.01.csv")

loadCHzipcode()

Arguments

file	the raw excel file name from the Swiss Statistical office with indicators by commune
output	the output file name to be saved in the package inst/extdata

Details

Run processPortraitsRegionauxCommune() to generate a readable csv file for loadCommunesCHportraits

The matrix has the commune BFS code as rowname and 3 attributes:

• communeName the text name of the commune (same length as the matrix length)

• indicatorYear & indicatorGroup respectively the year and the category of the communal indicator (both of same length as the matrix width). See http://www.bfs.admin.ch/bfs/portal/fr/index/regionen/02/key.html

Value

a matrix

a data.frame

See Also

Office fédéral de la statistique > Les Régions > Communes > Données et explications (portraits): https://www.bfs.admin.ch/bfs/fr/home/statistiques/statistique-regions/portraits-regionaux-chiffres-cles/communes.assetdetail.328133.html
The cleaning up of raw xls file:

• Remove all the empty lines (header has 3 lines: Indicator type, indicator, year)

• Reorder the header for: indicator type, year, indicator

• Remove in the data table, the line for Switzerland

• Remove the text at the bottom

• Save as csv

http://opendata.admin.ch/de/dataset/ch-swisstopo-vd-ortschaftenverzeichnis_plz/resource/35001b61-e7c1-4124-89fa-17fac7b1139e from: http://opendata.admin.ch/de/dataset/ch-swisstopo-vd-ortschaftenverzeichnis_plz

http://opendata.admin.ch/de/dataset/ch-swisstopo-vd-ortschaftenverzeichnis_plz/resource/35001b61-e7c1-4124-89fa-17fac7b1139e from: http://opendata.admin.ch/de/dataset/ch-swisstopo-vd-ortschaftenverzeichnis_plz

Examples

communeData <- loadCommunesCHportraits()
colnames(communeData)
rownames(communeData)

# Select only "surface" indicators
colIdx <- which(attr(communeData, "indicatorGroup") == "Surface")
head(communeData[,colIdx])

zipcode <- loadCHzipcode()
match(zipcode$Gemeindename, attr(communeData, "communeName"))
##' \dontrun{
  colnames(data)
  g1 <- ggplot(data = as.data.frame(data), aes(x = `Etrangers en %`, y = UDC)) + 
  geom_point(aes(size = Habitants), alpha = 0.5, colour = swiTheme::swi_col[1]) 
  g1 + swiTheme::swi_theme()
}

## Not run: 
processPortraitsRegionauxCommune()

## End(Not run)

d-qn/swiMap documentation built on May 14, 2019, 3:04 p.m.