Average local taxes by assets — Departmental Map 54 Meurthe and Moselle 2015

Here is an image of the global municipal tax (founcier bati + habitation).
Average tax per asset Nancy 2014

To do it again you will need:
— QGIS software (Free: https://www.qgis.org/fr/site/forusers/download.html),
— a qgs file of your department (http://www.actualitix.com/shapefiles-des-departements-de-france.html)
— an export of tax rates (https://www.data.gouv.fr/fr/datasets/impots-locaux/ > Municipal and intercommunal data > Your Department > Local Direct Tax Data 2014 (XLS format))
— data (most days of INSEE here 2012 http://www.insee.fr/fr/themes/detail.asp?reg_id=99&ref_id=base-cc-emploi-pop-active-2012)

Operating Mode:
— process your data in your favorite spreadsheet (Excel or OpenOffice Calc) by integrating impot data, and INSEE to pull out the numbers that seem revealing to you
— Install QGIS
— Open the.qgs of your department

Add columns
— Right click property on the main layer
— Go to the field menu (on the left)
— Add (via pencil) the desired columns (here average housing tax per asset, average property tax per asset, and the sum of both)
— These are reals of precision 2, and length 6
— Register

Insert data:
— Right-click on the “Open attribute table” layer
— Select all
— Copy
— Paste in excel (or openOffice calcs)
— Put the ad hoc formulas in excel (SOMME.SI.ENS to recover the rate)
— Save the desired tab in CSV DOS with the new values
— In QGIS > Menu > Layer > Add a delimited layer of text
— Import the CSV

Present the data:
— To simplify I advise you to make a layer by rate, and layers sums. So rots you in three clicks out the image of the desired rate
— For each layer (or rate)
— Right click properties on the csv layer
— Labels to add city name and desired rate
— Style for fct coloring of a csv field

Print the data in pdf:
— To print, you need to define a print template
— In the menu choose new printing dialer
— choose the format (a department in A0 is rather readable)
— Add vas legend, scale, and other
— Print and here...

NB: this method creates aberrations:
— in the case where the INSEE does not have a number or numbers that have moved a lot since
— it is assumed that only assets pay taxes (which is more fair, but not 100 %)