les bulletins blancs sont les suffrages exprimés par les électeurs sans cocher un candidat, un parti politique ou une liste de coalition. Dans l’ensemble, un bulletin blanc est exprimé par un électeur qui souhaite exercer son droit de vote, mais n'est pas satisfait de ses options de candidats ou le processus électoral. Lors des élections de l'Assemblée Nationale Constituante de 2011, près de 100.000 électeurs ont voté blanc. Cette visualisation montre le nombre de bulletins blancs exprimés par circonscription électorale de l'ANC aux élections de 2011.

Make sure you have read the documentation regarding installing and setting up a PostGIS-enabled database before proceeding any further.

Two datasets power this map:

• full 2011 election results available as individual .json files, parsed and provided as a single district-level CSV.
• geometry for the 27 districts derived from the delegtion shapefiles.

1. Import data to PostGIS

To set up the a table with appropriate columns, run the following SQL:

create table blank (
	cir_id int,
	circ_name text,
	total_votes numeric,
	votes_ennahdha numeric,
	votes_cpr numeric,
	votes_fdtl numeric,
	other_winning numeric,
	Wasted numeric,
	Blank_ballots numeric,
	cancelled_ballots numeric
);

Now run the following from your command line to populate the table:

blank-votes.csv | psql -d tunisia -c "COPY blank FROM STDIN WITH DELIMITER ',' CSV HEADER"

2. Dissolving Delegations into Districts

Note: If you have already performed this step for the Political parties map, you can skip to step 4.

Since this data has a district-level resolution, we need to create district polygons out of delegation polygons that we already imported.

To do this you’ll need to load the filter_rings() function explained in this post. This functions removes artifacts left by unioning each district’s member delegations. Once you’ve loaded the function into your database, run the following query.

create table districts as (
select
	circo_id,
	filter_rings(st_union(the_geom),2) as the_geom
from delegations
group by circo_id
);

4. Joining to geometry

You should now be able to open the Blank votes tilemill project

We’re joining the tabular data to geometry in TileMill’s PostGIS plugin. The query is here for your reference, but you should need to perform any further steps.

( select
    the_geom,
    cir_id,
    circ_name,
    blank_ballots,
    cancelled_ballots,
    wasted,
    map,
    total_votes,
    round((map / total_votes * 100)) as pct_n,
    cast(round((map / total_votes * 100)) as text)||'%' as pct_s,
    cast(round((map / total_votes * 100)) as text)||'%'||E' \n'||circ_name as display
  from districts a join blank b 
  on circo_id = cir_id 
) as data