Average local taxes by assets — Departmental Map 54 Meurthe and Moselle 2015
Description
Here is an image of the global municipal tax (founcier bati + habitation).
[Average tax per asset Nancy 2014](http://physaphae.noip.me/Img/TaxeMoy_Ncy_FoncHab_2014.jpeg “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 %)
Resources
| Name |
Format |
Description |
Link |
|
22 |
|
https://www.data.gouv.fr/fr/datasets/r/6b913cca-3f25-45c9-990c-a112c1a2b379 |
|
57 |
|
https://www.data.gouv.fr/fr/datasets/r/08bb9586-727f-4f1d-adb5-fd38e248a167 |
|
53 |
|
https://www.data.gouv.fr/fr/datasets/r/511686da-296f-45a5-b3e4-e04003b262ff |
|
33 |
|
https://www.data.gouv.fr/fr/datasets/r/d8251bb6-e3af-4e75-b357-820c058d9d16 |
Tags
- impots-locaux
- taxes
- meurthe-et-moselle