2d:null 2e:["$","title",null,{"children":"ixmaps - Parità di genere - per età e provincia | gjrichter | Observable"}] 33:T776,theme1 = () => { return { layer: "Province", field: "eta_5", field100: "", style: { type: "CHART|SYMBOL|SEQUENCE|PLOT|AREA|LINES|GRID|BOX|SIZE|AGGREGATE|RECT|SUM|CATEGORICAL|COUNT", colorscheme: ["#0044dd"], fillopacity: "0.2", shadow: "false", filter: 'WHERE "sesso" = "M"', dbtable: "AMMINISTRATORI_DATA", lookupfield: "sigla_provincia", symbols: ["none"], values: [ "20", "25", "30", "35", "40", "45", "50", "55", "60", "65", "70", "75", "80", "85", "90", "95", "100" ], units: "età", refreshtimeout: "0", scale: "0.2", maxvalue: "500", textcolor: "#444444", textscale: "3", linewidth: "5", boxopacity: "0.05", bordercolor: "none", titlefield: "denominazione_comune", valuescale: "1", aggregationfield: "sigla_provincia", align: "23left", valuedecimals: "0", title: "Amministratori locali in carica al
9 Settembre 2021", snippet: "Fonte: Eligendo Licenza: ???", description: "

" } }; }34:T874,theme2 = () => { return { layer: "Province", field: "eta_5", field100: "", style: { type: "CHART|SYMBOL|SEQUENCE|PLOT|AREA|LINES|GRID|BOX|SIZE|AGGREGATE|RECT|SUM|CATEGORICAL|COUNT", colorscheme: ["#dd4400"], fillopacity: "0.2", shadow: "false", filter: 'WHERE "sesso" = "F"', dbtable: "AMMINISTRATORI_DATA", lookupfield: "sigla_provincia", symbols: ["none"], values: [ "20", "25", "30", "35", "40", "45", "50", "55", "60", "65", "70", "75", "80", "85", "90", "95", "100" ], xaxis: [ "20", " ", "30", " ", "40", " ", "50", " ", "60", " ", "70", " ", "80", " ", "90", " ", "100" ], units: "età", refreshtimeout: "0", scale: "0.2", maxvalue: "500", textcolor: "#444444", textscale: "3", linewidth: "5", boxopacity: "0.05", bordercolor: "none", titlefield: "denominazione_comune", valuescale: "1", aggregationfield: "sigla_provincia", align: "23left", valuedecimals: "0", title: "Amministratori locali in carica al
9 Settembre 2021", snippet: "Fonte: Eligendo Licenza: ???", description: "

" } }; }35:T430,project = () => { return { $schema: "https://gjrichter.github.io/ixmaps/schema/ixmaps/v1.json", map: { map: "", basemap: "CartoDB - Positron", item: "html", legend: "

Amministratori locali in carica al
9 Settembre 2021

Amministratori aggregati per Provincia, sesso e fascia età

Ogni fascia d'età conprende 5 anni partendo dalla fascia 20-25 anni

fonte: Eligendo licenza: IODL v2.0

", scaleParam: { lineScaling: "0.5", normalSizeScale: "5000000" }, options: { featurescaling: "dynamic", objectscaling: "dynamic", panhidden: "false", flushChartDraw: "100000" }, center: { lat: "42.282221877329024", lng: "12.871337890625002" }, zoom: "6" }, themes: [georef(), theme1(), theme2()] }; }36:[] 31:{"id":"7c04c4fbf1ee4f6e","slug":"ixmaps-parita-di-genere-per-eta-e-provincia","title":"ixmaps - Parità di genere - per età e provincia","thumbnail":"695bc798ea684d04b610f98bf215ce3b37b873abfb1ef1457a064d1a6153cfba","access_level":"public","create_time":"$D2021-10-08T21:44:39.876Z","update_time":"$D2023-01-13T22:43:14.992Z","view_time":null,"first_public_time":"$D2021-10-08T22:50:02.933Z","has_unpublished_edits":null,"fork":{"id":"0a92560dc6a2f188","slug":"ixmaps-parita-di-genere-map-geojson","title":"","owner":{"id":"ab0359f3bbecf78a","login":"gjrichter","name":""}},"stars":1,"starred":false,"owner":{"type":"team","id":"ab0359f3bbecf78a","login":"gjrichter","name":"","avatar_url":"https://avatars-next.observableusercontent.com/1dd94096da79a76babfe37a3431edc30377043a898592a3437e913920b189ed3","tier":"starter_2024"},"version":312,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"921009d8ff1c586f","login":"gjrichter","name":"","avatar_url":"https://avatars-next.observableusercontent.com/1dd94096da79a76babfe37a3431edc30377043a898592a3437e913920b189ed3","tier":null}],"members":[{"type":"individual","id":"921009d8ff1c586f","login":"gjrichter","name":"","avatar_url":"https://avatars-next.observableusercontent.com/1dd94096da79a76babfe37a3431edc30377043a898592a3437e913920b189ed3","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":true,"trashed":false,"lapsed":null,"subscribed":null,"forks":2,"collection":{"id":"e26443931225970e","slug":"gender-maps","title":"Gender Maps","owner":{"id":"ab0359f3bbecf78a","login":"gjrichter","name":""}},"type":"notebook","body":{"title":"ixmaps - Parità di genere - per età e provincia","cells":[{"id":0,"value":"# ixmaps - Parità di genere - per età e provincia","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":292,"value":"map = ixmaps.embed(\n \"map2\",\n {\n mapCdn: \"https://gjrichter.github.io/ixmaps\",\n maptype: \"CartoDB - Positron\",\n width: \"100%\",\n height: \"900px\",\n legend: 1,\n align: \"right\",\n mode: \"pan\",\n tools: \"true\",\n name: \"map\"\n },\n (map) =>\n map\n .setData(province, {\n type: \"geojson\",\n name: \"PROVINCE\"\n })\n .setData(amministratori_data, {\n type: \"jsonDB\",\n name: \"AMMINISTRATORI_DATA\"\n })\n .loadProject(project())\n)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":14,"value":"The above map shows the **gender equity** for the local governments of all italian municipalities aggregated by Province and compared by age group.\n\nFor every Provice we see a curve chart with the elected amministrators by age class (5 years step) and gender (red = women, blue = men). The minimal age is 20 years. ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":18,"value":"The map visualizes data published by the Interior Ministry of Italy on a dedicated page ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":23,"value":"The interactive map is powered by the iXMaps framework which is loaded into an iframe and parametrized by the visualization project defined in this notebook.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":27,"value":"There is a [GitHub hosted version](https://gjrichter.github.io/ixmaps/ui/dispatch.htm?name=map1&ui=embed&basemap=ll&align=right&legend=1&scrollsafe=1&footer=1&sync=false&project=https://raw.githubusercontent.com/gjrichter/viz/master/COVID-19/projects/COVID-19-Vaccini_final/ixmaps_project_Vaccini_latest_percentuale_nuts.json) of this map where all steps are included into one JSON project definition.

In the following we realize the visualizzation project step by step.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":31,"value":"#
data
\n\nThe data is published by the Italia Interior Ministry on a dedicated page in CSV and contains all administrator of all municipalities actually in charge.\n\nTo overcome cross domain limits and the size of the file I host a zipped version of the data in an S3 bucket. \n\nHere is the raw data:","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":48,"value":"amministratori = d3.csv(\"https://s3.eu-west-1.amazonaws.com/data.ixmaps.com/Amministrazioni/ammcom.csv.gz\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":50,"value":"Inputs.Table(amministratori)","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":52,"value":"The data contains more than 120 000 rows, one row for every amministrator.\nFor the visualization of the gender equality we need to create a pivot table which sums the number of male and female amministrators for very municipality.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":134,"value":"## processing the data","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"We import the loaded data into a **Data** *object* ","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":60,"value":"amministratori_data = new Data.import({\"source\":amministratori,\"type\":\"json\"});","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":62,"value":"and create the pivot table with one row for every municipality. The option 'keep' gives us the possibility to maintain usefull coluns from the original table.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":70,"value":"The data created here will be loaded into the iXMaps application later with the name: 'AMMINISTRATORI_DATA'","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":253,"value":"{\n var iNat = amministratori_data.column(\"data_nascita\").index;\n amministratori_data.addColumn({ destination: \"eta_5\" }, function (row) {\n var dA = row[iNat].split(\"/\");\n var eta = (\n (new Date().getTime() -\n new Date(dA[2] + \"/\" + dA[1] + \"/\" + dA[0]).getTime()) /\n (1000 * 60 * 60 * 24 * 356)\n ).toFixed(0);\n return Math.floor(eta / 5) * 5;\n });\n return amministratori_data;\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":74,"value":"
\n# Defining and realizing the map
\n\nFinally we define and realize the thematic map using the loaded and processed data.
(*This project definition can be edited*)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":79,"value":"## the geographic reference\nTo put the data on the map we need a geographic reference, in this case a position given in geographic coordinates.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":171,"value":"The data is not providing such information, but we have the names of the municipalities to identify the place. iXMaps can consume geojson files to create a referenced map positions.\n\nIn this visualizzation we use a geojson file with the provinces of Italy identified by their number code (property: SIGLA).","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":147,"value":"province = d3.json(\"https://raw.githubusercontent.com/gjrichter/viz/master/Amministratori/province_2019_s.geojson\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":164,"value":"georef = () => {\n return {\n layer: \"Province\",\n field: \"$item$\",\n field100: \"\",\n style: {\n type: \"FEATURES|NOLEGEND|LOCKED\",\n colorscheme: [\"none\"],\n fillopacity: \"0.7\",\n dbtable: \"PROVINCE\",\n itemfield: \"SIGLA\",\n lookupfield: \"geometry\",\n linecolor: [\"none\"],\n linewidth: \"1\",\n title: \"Regioni\"\n }\n };\n}","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"The map is loaded in the **project** definition and refered by the visualizzation theme with:\n> ```\"layer\":\"Province\"``` and
\n> ```\"lookupfield\": \"sigla_provincia\"```\n\nWhile **\"layer\"** refers to the layer name of the loaded SVG map which serves the shapes and positions of the provinces by their numerical code, **\"lookupfield\"** defines the column name of the data table which contains this codes.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":89,"value":"
\n## the themes","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":93,"value":"In iXMaps, a theme defines the rappresentation of data by grafics or colored lines or areas on a map.\n\nA visualizzation project consist of a map definition and one or more themes.
(*The theme is defined as a function to meet Observable syntax checking*)","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":97,"value":"$33","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":193,"value":"$34","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":99,"value":"
In the theme definition, the data is linked by the property
\n> ```\"dbtable\": \"AMMINISTRATORI_DATA\"``` \n\nIt refers to the name of the data loaded into iXMaps by the realizing function, which is defined below.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":104,"value":"
\n## the project","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":107,"value":"Now we define the **iXMaps project** which configures the map for the visualizzation and refers the above defined theme","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":111,"value":"$35","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":118,"value":"
\n## drawing the map","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":122,"value":"The interactive **map** with the **data visualizzation** is realized by the **iXMaps API** code on top of the page which you can see below the map.\n\nThe **iXmaps** **API** call _**ixmaps.embed**(...)_ creates the **iframe** to host the iXMaps application and load the **data** and the visualizzation **project** defined above.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":129,"value":"That's it.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":35,"value":"
\n# Appendix","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":39,"value":"ixmaps = require('https://gjrichter.github.io/ixmaps/ui/js/htmlgui_api.js')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":41,"value":"Inputs = require(\"@observablehq/inputs@0.7.21/dist/inputs.umd.min.js\")","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":44,"value":"Data = require('https://gjrichter.github.io/data.js/data.js')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":46,"value":"$$ = require('https://code.jquery.com/jquery-3.3.1.min.js')","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W36","stdlib":"1","titling":"auto"}} 32:"$31:body"

< 40 anni 40 - 60 anni > 60 anni tutto

< 40 anni 40 - 60 anni > 60 anni tutto

Amministratori locali in carica al 9 Settembre 2021

Amministratori aggregati per Provincia, sesso e fascia età

Ogni fascia d'età conprende 5 anni partendo dalla fascia 20-25 anni

fonte: Eligendo licenza: IODL v2.0

Amministratori locali in carica al
9 Settembre 2021