أوراق الاقتراع  البيضاء هي الأوراق التي يدلي بها الناخبين دون وضع علامة لمرشح أو حزب سياسي أو قائمة تحالف. بشكل عام، أوراق الاقتراع  البيضاء هي تصويت  من قبل الناخب الذي يرغب في ممارسة حقه في التصويت، بالرغم من عدم  رضائه على خيارات المرشحين  أو  العملية الانتخابية. في انتخابات المجلس الوطني التأسيسي لسنة  2011 ، أدلى ما يقرب عن 100،000 ناخب ببطاقات اقتراع بيضاء . هذا العرض البياني  يظهر عدد أوراق الاقتراع  البيضاء في كل دائرة انتخابية خلال انتخابات المجلس الوطني التأسيسي لسنة  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