Technisch overzicht

SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X',
   (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END),
   (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END)
 ) AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) AS ORD,
 '???' AS column_exists,
 q.question AS DESCR,
 ## Harmonica Question TYPE
 '????' AS HQTYPE,
 (SELECT COUNT(*) FROM `lime_conditions` c 
  WHERE c.qid = q.qid 
  AND c.cfieldname = '{TOKEN:USESLEFT}'
  AND c.method = '=='
  AND c.value = '1') AS 1STTIMEONLY,
 '' AS EXTRA,
 '' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
WHERE q.sid = 585242 AND q.type NOT IN ('M','R','P','T','O','S','|','Y','L')
## Hierboven komt niets meer uit, als het goed is!
 
UNION 
# Multiple choice subquestions (zowel gewone Multiple Choice antwoorden als MC met commentaar)
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X',
   (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END),
   (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END)
 ) AS column_name,
 (grp.group_order * 100000) + (pq.question_order * 1000) + (q.question_order * 10) AS ORD,
 'Y' AS column_exists,
 q.question AS DESCR,
 'MCQA' AS HQTYPE,
 '0' AS 1STTIMEONLY,
 # '' AS EXTRA,
 # EXTRA contains the reference to the multiple-choice question
 CONCAT(q.sid , 'X', q.gid, 'X',
   (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END)
 ) AS EXTRA,
 'Reference to question' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
  INNER JOIN `lime_questions` pq
  ON q.parent_qid = pq.qid
WHERE q.sid = 585242 AND q.type IN ('M','P','T')
## Tot 20190520 - WAS alleen type 'T' voor controle data-integriteit !!
## M = Multiple Choice antwoord
## P = Multiple Choice antwoord met commentaar
 
UNION
# Multiple choice with comments
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X', q.qid, sq.title, 'comment') AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) + (sq.question_order * 10) + 1 AS ORD,
 'Y' AS column_exists,
 q.question AS DESCR,
 'CMNT' AS HQTYPE,
 '0' AS 1STTIMEONLY,
 # '' AS EXTRA,
 # EXTRA contains the reference to the multiple-choice question
 CONCAT(q.sid , 'X', q.gid, 'X',
   (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END)
 ) AS EXTRA,
 'Reference to question' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 sq.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
  INNER JOIN `lime_questions` sq
  ON q.sid = sq.sid AND q.qid = sq.parent_qid
  AND q.type = 'P' AND sq.type in ('P','T')
## Tot 20190520 - WAS type 'T' voor controle data-integriteit !!
WHERE q.sid = 585242
 
UNION
# Multiple choice questions which have option 'Other'
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END), 'other') AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) + 99 AS ORD,
 'Y' AS column_exists,
 'Anders' AS DESCR,
 'OTHR' AS HQTYPE,
 '0' AS 1STTIMEONLY,
 # '' AS EXTRA,
 # EXTRA contains the reference to the multiple-choice question
 CONCAT(q.sid , 'X', q.gid, 'X',
   (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END)
 ) AS EXTRA,
 'Reference to question' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
WHERE q.sid = 585242 AND q.other = 'Y'
 
UNION
# File upload fields - filecount
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END), '_filecount') AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) + 1 AS ORD,
 'Y' AS column_exists,
 q.question AS DESCR,
 'FCNT' AS HQTYPE,
 '0' AS 1STTIMEONLY,
 '' AS EXTRA,
 '' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
WHERE q.sid = 585242 AND q.type = '|'
 
UNION
# Long text fields
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END)) AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) + 1 AS ORD,
 'Y' AS column_exists,
 q.question AS DESCR,
 'LTXT' AS HQTYPE,
 (SELECT COUNT(*) FROM `lime_conditions` c 
  WHERE c.qid = q.qid 
  AND c.cfieldname = '{TOKEN:USESLEFT}'
  AND c.method = '=='
  AND c.value = '1') AS 1STTIMEONLY,
 '' AS EXTRA,
 '' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
WHERE q.sid = 585242 AND q.type = 'T' AND q.parent_qid = 0
 
UNION
# Ranking fields
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X', (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END), a.sortorder) AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) + (a.sortorder * 10) AS ORD,
 'Y' AS column_exists,
 a.answer AS DESCR,
 'RKGA' AS HQTYPE,
 '0' AS 1STTIMEONLY,
 '' AS EXTRA,
 '' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
  INNER JOIN `lime_answers` a
  ON q.qid = a.qid
WHERE q.sid = 585242 AND q.type = 'R'
 
UNION
# Radio button
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X', q.qid) AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) AS ORD,
 'Y' AS column_exists,
 q.question AS DESCR,
 'RDOQ' AS HQTYPE,
 (SELECT COUNT(*) FROM `lime_conditions` c 
  WHERE c.qid = q.qid 
  AND c.cfieldname = '{TOKEN:USESLEFT}'
  AND c.method = '=='
  AND c.value = '1') AS 1STTIMEONLY,
 '' AS EXTRA,
 '' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
WHERE q.sid = 585242 AND q.type in ('O','L')
 
UNION
# Radio button - all answers
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 #CONCAT(q.sid , 'X', q.gid, 'X', q.qid) AS column_name,
 # Deze kolomnaam bestaat niet, want alleen die voor de RDOQ hierboven bestaat
 # Dus voor de fake kolomnaam a.code toegevoegd
 CONCAT(q.sid , 'X', q.gid, 'X', q.qid, a.code) AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) + (a.sortorder * 10) + 5 AS ORD,
 'N' AS column_exists,
 # CONCAT(a.code, '|', a.answer) AS DESCR,
 CONCAT(a.answer) AS DESCR,
 'RDOA' AS HQTYPE,
 '0' AS 1STTIMEONLY,
 # CONCAT(q.sid , 'X', q.gid, 'X', q.qid, '|', a.code) AS EXTRA,
 # 'Reference to question|Answer code or label' AS MEANING_EXTRA,
 CONCAT(q.sid , 'X', q.gid, 'X', q.qid) AS EXTRA,
 'Reference to question' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
  INNER JOIN `lime_answers` a
  ON q.qid = a.qid
WHERE q.sid = 585242 AND q.type in ('O','L')
 
 
UNION
# Radio button with comments
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X', q.qid, 'comment') AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) + 1 AS ORD,
 'Y' AS column_exists,
 q.question AS DESCR,
 'CMNT' AS HQTYPE,
 '0' AS 1STTIMEONLY,
 '' AS EXTRA,
 '' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
WHERE q.sid = 585242 AND q.type = 'O'
 
UNION
# Short text
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X',
   (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END),
   (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END)
 ) AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) AS ORD,
 'Y' AS column_exists,
 q.question AS DESCR,
 'STXT' AS HQTYPE,
 (SELECT COUNT(*) FROM `lime_conditions` c 
  WHERE c.qid = q.qid 
  AND c.cfieldname = '{TOKEN:USESLEFT}'
  AND c.method = '=='
  AND c.value = '1') AS 1STTIMEONLY,
 '' AS EXTRA,
 '' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
  AND NOT EXISTS 
   (SELECT 1 FROM `lime_question_attributes` qattr
    WHERE q.qid = qattr.qid AND qattr.attribute = 'location_defaultcoordinates')	
WHERE q.sid = 585242 AND q.type IN ('S')
 
UNION
# Location with default coordinates !! (Hence inner join)
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X',
   (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END),
   (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END)
 ) AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) AS ORD,
 'Y' AS column_exists,
 q.question AS DESCR,
 'LOCA' AS HQTYPE,
 (SELECT COUNT(*) FROM `lime_conditions` c 
  WHERE c.qid = q.qid 
  AND c.cfieldname = '{TOKEN:USESLEFT}'
  AND c.method = '=='
  AND c.value = '1') AS 1STTIMEONLY,
 # qattr.value AS EXTRA,
 CONCAT(locamc.value, ' ', locamz.value) AS EXTRA,
 'Coordinates latitude and longitude plus zoom level (space separated)' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
  # INNER JOIN `lime_question_attributes` qattr
  # ON q.qid = qattr.qid AND qattr.attribute = 'location_defaultcoordinates'	
  INNER JOIN `lime_question_attributes` locamc
  ON q.qid = locamc.qid AND locamc.attribute = 'location_defaultcoordinates' AND locamc.value != ''
  INNER JOIN `lime_question_attributes` locamz
  ON q.qid = locamz.qid AND locamz.attribute = 'location_mapzoom'
WHERE q.sid = 585242 AND q.type IN ('S')
 
UNION
# File upload field
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X',
   (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END),
   (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END)
 ) AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) AS ORD,
 'Y' AS column_exists,
 q.question AS DESCR,
 'UPLD' AS HQTYPE,
 (SELECT COUNT(*) FROM `lime_conditions` c 
  WHERE c.qid = q.qid 
  AND c.cfieldname = '{TOKEN:USESLEFT}'
  AND c.method = '=='
  AND c.value = '1') AS 1STTIMEONLY,
 '' AS EXTRA,
 '' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
WHERE q.sid = 585242 AND q.type IN ('|')
 
UNION
# YES/NO field
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X',
   (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END),
   (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END)
 ) AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) AS ORD,
 'Y' AS column_exists,
 q.question AS DESCR,
 'YSNO' AS HQTYPE,
 (SELECT COUNT(*) FROM `lime_conditions` c 
  WHERE c.qid = q.qid 
  AND c.cfieldname = '{TOKEN:USESLEFT}'
  AND c.method = '=='
  AND c.value = '1') AS 1STTIMEONLY,
 '' AS EXTRA,
 '' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
WHERE q.sid = 585242 AND q.type IN ('Y')
 
 
UNION
# Het is een gesloten Multiple choice vraag 
# of één met optie Other
# of één met commentaarmogelijkheid
# of één die we nog niet kennen => GEENIDEE
# Do NOT exist as columns
SELECT
 CONCAT('lime_survey_', q.sid) AS table_name,
 CONCAT(q.sid , 'X', q.gid, 'X',
   (CASE WHEN q.parent_qid = 0 THEN q.qid ELSE q.parent_qid END),
   (CASE WHEN q.parent_qid <> 0 THEN q.title ELSE '' END)
 ) AS column_name,
 (grp.group_order * 100000) + (q.question_order * 1000) AS ORD,
 'N' AS column_exists,
 q.question AS DESCR,
 (CASE q.type
   WHEN 'M' THEN 'MCQ1'
   WHEN 'P' THEN 'MCQ2'
   WHEN 'R' THEN 'RKGQ'
 END) AS HQTYPE,
  (SELECT COUNT(*) FROM `lime_conditions` c 
  WHERE c.qid = q.qid 
  AND c.cfieldname = '{TOKEN:USESLEFT}'
  AND c.method = '=='
  AND c.value = '1') AS 1STTIMEONLY,
 '' AS EXTRA,
 '' AS MEANING_EXTRA,
 (SELECT COUNT(*) FROM `lime_question_attributes` sqa 
  WHERE sqa.qid = q.qid AND sqa.attribute = 'hidden' AND sqa.value = '1') AS HIDDEN,
 grp.group_name,
 q.*
FROM `lime_questions` q
  INNER JOIN `lime_groups` grp
  ON q.sid = grp.sid AND q.gid = grp.gid
WHERE q.sid = 585242 AND q.type IN ('M','R','P')
  AND q.parent_qid = 0
## Tot 20190520 - zonder laatste restrictie
 
ORDER BY 1, 3

SELECT
  # CONCAT('585242_', lime_survey_585242.id) AS SURVEY_REC_ID,
  CONCAT('585242_', LPAD(lime_survey_585242.id, 4, '0')) AS SURVEY_REC_ID,
  lime_tokens_585242.token,
  lime_survey_585242.seed,
  lime_survey_585242.submitdate,
  IF(CONCAT(lime_tokens_585242.firstname,lime_tokens_585242.lastname) = '', 'Anonieme', lime_tokens_585242.firstname) as firstname,
  IF(CONCAT(lime_tokens_585242.firstname,lime_tokens_585242.lastname) = '', 'Gebruiker', lime_tokens_585242.lastname) as lastname,
  lime_tokens_585242.email, 
  lime_tokens_585242.sent,
  lime_tokens_585242.completed,
  lime_survey_585242.585242X107X1595SQ001,
  lime_survey_585242.585242X107X1595SQ002,
  lime_survey_585242.585242X107X1595SQ003,
  lime_survey_585242.585242X107X1595SQ004,
  lime_survey_585242.585242X107X1595SQ005,
  lime_survey_585242.585242X107X1595SQ006,
  lime_survey_585242.585242X107X1609,
  lime_survey_585242.585242X107X1596SQ001,
  lime_survey_585242.585242X107X1596SQ002,
  lime_survey_585242.585242X107X1596SQ003,
  lime_survey_585242.585242X107X1596SQ006,
  lime_survey_585242.585242X107X1596SQ004,
  lime_survey_585242.585242X107X1596SQ005,
  lime_survey_585242.585242X107X1596other,
  lime_survey_585242.585242X107X1610,
  lime_survey_585242.585242X107X1601,
  lime_survey_585242.585242X107X1601_filecount,
  lime_survey_585242.585242X108X1598,
  lime_survey_585242.585242X108X1604,
  lime_survey_585242.585242X108X1599,
  lime_survey_585242.585242X108X1611,
  lime_survey_585242.585242X108X1611_filecount,
  lime_survey_585242.585242X108X1606,
  lime_survey_585242.585242X108X1600,
  lime_survey_585242.585242X108X1607,
  lime_survey_585242.585242X108X1612,
  lime_survey_585242.585242X108X1613,
  lime_survey_585242.585242X108X1613_filecount,
  lime_survey_585242.585242X108X1603,
  lime_survey_585242.585242X108X1608,
  lime_survey_585242.585242X108X1605,
  lime_survey_585242.585242X109X1602SQ001,
  lime_survey_585242.585242X109X1602SQ002,
  lime_survey_585242.585242X109X1602SQ003,
  lime_survey_585242.585242X109X1602SQ004,
  lime_survey_585242.585242X109X1602SQ005,
  lime_survey_585242.585242X109X1597SQ001,
  lime_survey_585242.585242X109X1597SQ002,
  lime_survey_585242.585242X109X1597SQ003,
  lime_survey_585242.585242X109X1597SQ006,
  lime_survey_585242.585242X109X1597SQ004,
  lime_survey_585242.585242X109X1597SQ005,
  lime_survey_585242.585242X109X1597other
FROM lime_survey_585242
INNER JOIN lime_tokens_585242
ON lime_survey_585242.token = lime_tokens_585242.token
WHERE lime_survey_585242.submitdate IS NOT NULL
ORDER BY lime_tokens_585242.token, lime_survey_585242.id

Column-To-Question-map

array (
  '585242X107X1595' => 
  array (
    'description' => '<strong>Hoe ben je betrokken bij Ouderkerk ad Amstel?</strong>',
    'stripped_description' => 'Hoe ben je betrokken bij Ouderkerk ad Amstel?',
    'core_description' => 'Hoe ben je betrokken bij Ouderkerk ad Amstel?',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQ1',
    '1sttimeonly' => '1',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'N',
    'hqtype_descr' => 'meerkeuze',
    'mandatory' => 'Y',
    'question_nr' => 1,
    'main_question' => 1,
  ),
  '585242X107X1595SQ001' => 
  array (
    'description' => '<strong>bewoner</strong>',
    'stripped_description' => 'bewoner',
    'core_description' => 'bewoner',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X107X1595',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X107X1595SQ002' => 
  array (
    'description' => '<strong>ondernemer</strong>',
    'stripped_description' => 'ondernemer',
    'core_description' => 'ondernemer',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X107X1595',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X107X1595SQ003' => 
  array (
    'description' => '<strong>werknemer / student / vrijwilliger</strong>',
    'stripped_description' => 'werknemer / student / vrijwilliger',
    'core_description' => 'werknemer / student / vrijwilliger',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X107X1595',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X107X1595SQ004' => 
  array (
    'description' => '<strong>ambtenaar</strong>',
    'stripped_description' => 'ambtenaar',
    'core_description' => 'ambtenaar',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X107X1595',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X107X1595SQ005' => 
  array (
    'description' => '<strong>bestuurder</strong>',
    'stripped_description' => 'bestuurder',
    'core_description' => 'bestuurder',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X107X1595',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X107X1595SQ006' => 
  array (
    'description' => '<strong>bezoeker</strong>',
    'stripped_description' => 'bezoeker',
    'core_description' => 'bezoeker',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X107X1595',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X107X1609' => 
  array (
    'description' => '<p><strong>Waar woon je?</strong> Geef jouw woonlocatie globaal aan met een punt op de kaart.</p>
',
    'stripped_description' => 'Waar woon je? Geef jouw woonlocatie globaal aan met een punt op de kaart.',
    'core_description' => 'Waar woon je?',
    'type' => 'S',
    'group_name' => 'Over jou',
    'hqtype' => 'LOCA',
    '1sttimeonly' => '1',
    'extra' => '52.296720 4.905114 15',
    'meaning_extra' => 'Coordinates latitude and longitude plus zoom level (space separated)',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'locatie',
    'mandatory' => 'N',
    'question_nr' => 2,
    'main_question' => 1,
  ),
  '585242X107X1596' => 
  array (
    'description' => '<strong>Hoe maak je gebruik van Ouderkerk?</strong>',
    'stripped_description' => 'Hoe maak je gebruik van Ouderkerk?',
    'core_description' => 'Hoe maak je gebruik van Ouderkerk?',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQ1',
    '1sttimeonly' => '1',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'N',
    'hqtype_descr' => 'meerkeuze',
    'mandatory' => 'Y',
    'question_nr' => 3,
    'main_question' => 1,
  ),
  '585242X107X1596SQ001' => 
  array (
    'description' => '<strong>woning</strong> (appartement, huis, verzorgingshuis, ...)',
    'stripped_description' => 'woning (appartement, huis, verzorgingshuis, ...)',
    'core_description' => 'woning',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X107X1596',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X107X1596SQ002' => 
  array (
    'description' => '<strong>bedrijf</strong> (bedrijfspand, winkel, kantoorruimte, ...)',
    'stripped_description' => 'bedrijf (bedrijfspand, winkel, kantoorruimte, ...)',
    'core_description' => 'bedrijf',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X107X1596',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X107X1596SQ003' => 
  array (
    'description' => '<strong>sociale voorziening</strong> (horeca, buurthuis, speeltuin, school, ...)',
    'stripped_description' => 'sociale voorziening (horeca, buurthuis, speeltuin, school, ...)',
    'core_description' => 'sociale voorziening',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X107X1596',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X107X1596SQ006' => 
  array (
    'description' => '<strong>culturele voorziening</strong> (museum, bioscoop, theater, bibliotheek, ...)',
    'stripped_description' => 'culturele voorziening (museum, bioscoop, theater, bibliotheek, ...)',
    'core_description' => 'culturele voorziening',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X107X1596',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X107X1596SQ004' => 
  array (
    'description' => '<strong>transportmiddel</strong> (auto, fiets, openbaar vervoer, ...)',
    'stripped_description' => 'transportmiddel (auto, fiets, openbaar vervoer, ...)',
    'core_description' => 'transportmiddel',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X107X1596',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X107X1596SQ005' => 
  array (
    'description' => '<strong>groen</strong> (parken, sportvoorzieningen, water, ...)',
    'stripped_description' => 'groen (parken, sportvoorzieningen, water, ...)',
    'core_description' => 'groen',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X107X1596',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X107X1596other' => 
  array (
    'description' => 'Anders',
    'stripped_description' => 'Anders',
    'core_description' => 'Anders',
    'type' => 'M',
    'group_name' => 'Over jou',
    'hqtype' => 'OTHR',
    '1sttimeonly' => '0',
    'extra' => '585242X107X1596',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X107X1610' => 
  array (
    'description' => 'Dit is een Ouderkerk mozaiek. <strong>Wat is de belangrijkste locatie of plek van Ouderkerk?</strong>',
    'stripped_description' => 'Dit is een Ouderkerk mozaiek. Wat is de belangrijkste locatie of plek van Ouderkerk?',
    'core_description' => 'Wat is de belangrijkste locatie of plek van Ouderkerk?',
    'type' => 'S',
    'group_name' => 'Over jou',
    'hqtype' => 'LOCA',
    '1sttimeonly' => '1',
    'extra' => '52.296720 4.905114 15',
    'meaning_extra' => 'Coordinates latitude and longitude plus zoom level (space separated)',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'locatie',
    'mandatory' => 'N',
    'question_nr' => 4,
    'main_question' => 1,
  ),
  '585242X107X1601' => 
  array (
    'description' => '<p><strong>Voeg een foto van jezelf toe.</strong></p>
 
<p>Dit is niet verplicht, maar maakt je pagina persoonlijker.</p>
',
    'stripped_description' => 'Voeg een foto van jezelf toe. Dit is niet verplicht, maar maakt je pagina persoonlijker.',
    'core_description' => 'Voeg een foto van jezelf toe.',
    'type' => '|',
    'group_name' => 'Over jou',
    'hqtype' => 'UPLD',
    '1sttimeonly' => '1',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'upload',
    'mandatory' => 'N',
    'question_nr' => 5,
    'main_question' => 1,
  ),
  '585242X107X1601_filecount' => 
  array (
    'description' => '<p><strong>Voeg een foto van jezelf toe.</strong></p>
 
<p>Dit is niet verplicht, maar maakt je pagina persoonlijker.</p>
',
    'stripped_description' => 'Voeg een foto van jezelf toe. Dit is niet verplicht, maar maakt je pagina persoonlijker.',
    'core_description' => 'Voeg een foto van jezelf toe.',
    'type' => '|',
    'group_name' => 'Over jou',
    'hqtype' => 'FCNT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X108X1598' => 
  array (
    'description' => '<p>Waar wil je jouw toekomstidee uitvoeren?</p>
 
<p><strong>Wijs de locatie aan op de kaart.</strong></p>
',
    'stripped_description' => 'Waar wil je jouw toekomstidee uitvoeren? Wijs de locatie aan op de kaart.',
    'core_description' => 'Wijs de locatie aan op de kaart.',
    'type' => 'S',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'LOCA',
    '1sttimeonly' => '0',
    'extra' => '52.295026 4.907764 15',
    'meaning_extra' => 'Coordinates latitude and longitude plus zoom level (space separated)',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'locatie',
    'mandatory' => 'N',
    'question_nr' => 6,
    'main_question' => 1,
  ),
  '585242X108X1604' => 
  array (
    'description' => '<p><strong>Mijn toekomstidee is uit te voeren op:</strong></p>
',
    'stripped_description' => 'Mijn toekomstidee is uit te voeren op:',
    'core_description' => 'Mijn toekomstidee is uit te voeren op:',
    'type' => 'L',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'RDOQ',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'keuze',
    'mandatory' => 'Y',
    'question_nr' => 7,
    'main_question' => 1,
  ),
  '585242X108X1604A1' => 
  array (
    'description' => 'Een specifieke locatie (straat, park, plein, kruising) ',
    'stripped_description' => 'Een specifieke locatie (straat, park, plein, kruising)',
    'core_description' => 'Een specifieke locatie (straat, park, plein, kruising) ',
    'type' => 'L',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'RDOA',
    '1sttimeonly' => '0',
    'extra' => '585242X108X1604',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'N',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X108X1604A2' => 
  array (
    'description' => 'Mijn idee is op meerdere locaties uit te voeren / Mijn idee is locatie ongebonden',
    'stripped_description' => 'Mijn idee is op meerdere locaties uit te voeren / Mijn idee is locatie ongebonden',
    'core_description' => 'Mijn idee is op meerdere locaties uit te voeren / Mijn idee is locatie ongebonden',
    'type' => 'L',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'RDOA',
    '1sttimeonly' => '0',
    'extra' => '585242X108X1604',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'N',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X108X1599' => 
  array (
    'description' => '<strong>Hoe heet de locatie waar je het idee kunt uitvoeren?</strong>',
    'stripped_description' => 'Hoe heet de locatie waar je het idee kunt uitvoeren?',
    'core_description' => 'Hoe heet de locatie waar je het idee kunt uitvoeren?',
    'type' => 'T',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'Y',
    'question_nr' => 8,
    'main_question' => 1,
  ),
  '585242X108X1611' => 
  array (
    'description' => 'Laat zien waar je jouw idee wilt uitvoeren. <strong>Voeg een foto van de locatie van het idee toe.</strong>',
    'stripped_description' => 'Laat zien waar je jouw idee wilt uitvoeren. Voeg een foto van de locatie van het idee toe.',
    'core_description' => 'Voeg een foto van de locatie van het idee toe.',
    'type' => '|',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'UPLD',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'upload',
    'mandatory' => 'N',
    'question_nr' => 9,
    'main_question' => 1,
  ),
  '585242X108X1611_filecount' => 
  array (
    'description' => 'Laat zien waar je jouw idee wilt uitvoeren. <strong>Voeg een foto van de locatie van het idee toe.</strong>',
    'stripped_description' => 'Laat zien waar je jouw idee wilt uitvoeren. Voeg een foto van de locatie van het idee toe.',
    'core_description' => 'Voeg een foto van de locatie van het idee toe.',
    'type' => '|',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'FCNT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X108X1606' => 
  array (
    'description' => '<strong>Naam Locatie - Interpretatie</strong>',
    'stripped_description' => 'Naam Locatie - Interpretatie',
    'core_description' => 'Naam Locatie - Interpretatie',
    'type' => 'T',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 1,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 10,
    'main_question' => 1,
  ),
  '585242X108X1600' => 
  array (
    'description' => '<p>Toekomstidee! </p>
 
<p>Heb je een toekomstidee? </p>
 
<p><strong>Ik wil dat er.....</strong></p>
',
    'stripped_description' => 'Toekomstidee!  Heb je een toekomstidee?  Ik wil dat er.....',
    'core_description' => 'Ik wil dat er.....',
    'type' => 'T',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'Y',
    'question_nr' => 11,
    'main_question' => 1,
  ),
  '585242X108X1607' => 
  array (
    'description' => '<strong>Toekomstidee - Interpretatie</strong>',
    'stripped_description' => 'Toekomstidee - Interpretatie',
    'core_description' => 'Toekomstidee - Interpretatie',
    'type' => 'T',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 1,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 12,
    'main_question' => 1,
  ),
  '585242X108X1612' => 
  array (
    'description' => 'Heeft u een toelichting bij jouw toekomstidee? Kopier een link naar een artikel of kopieer de tekst. ',
    'stripped_description' => 'Heeft u een toelichting bij jouw toekomstidee? Kopier een link naar een artikel of kopieer de tekst. ',
    'core_description' => 'Heeft u een toelichting bij jouw toekomstidee? Kopier een link naar een artikel of kopieer de tekst. ',
    'type' => 'T',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 13,
    'main_question' => 1,
  ),
  '585242X108X1613' => 
  array (
    'description' => '<p><strong>Heb je als bron voor dit toekomstidee een brief of ander document?</strong></p>
 
<p>Zo ja, voeg dat hier toe. </p>
',
    'stripped_description' => 'Heb je als bron voor dit toekomstidee een brief of ander document? Zo ja, voeg dat hier toe. ',
    'core_description' => 'Heb je als bron voor dit toekomstidee een brief of ander document?',
    'type' => '|',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'UPLD',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'upload',
    'mandatory' => 'N',
    'question_nr' => 14,
    'main_question' => 1,
  ),
  '585242X108X1613_filecount' => 
  array (
    'description' => '<p><strong>Heb je als bron voor dit toekomstidee een brief of ander document?</strong></p>
 
<p>Zo ja, voeg dat hier toe. </p>
',
    'stripped_description' => 'Heb je als bron voor dit toekomstidee een brief of ander document? Zo ja, voeg dat hier toe. ',
    'core_description' => 'Heb je als bron voor dit toekomstidee een brief of ander document?',
    'type' => '|',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'FCNT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X108X1603' => 
  array (
    'description' => '<p>Met mijn toekomstidee wordt Ouderkerk aantrekkelijker voor bewoners, ondernemers, bezoekers, etc.</p>
 
<p><strong>Mijn idee zorgt ervoor dat ...</strong></p>
',
    'stripped_description' => 'Met mijn toekomstidee wordt Ouderkerk aantrekkelijker voor bewoners, ondernemers, bezoekers, etc. Mijn idee zorgt ervoor dat ...',
    'core_description' => 'Mijn idee zorgt ervoor dat ...',
    'type' => 'T',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 15,
    'main_question' => 1,
  ),
  '585242X108X1608' => 
  array (
    'description' => '<strong>Gevolg Idee - Interpretatie</strong>',
    'stripped_description' => 'Gevolg Idee - Interpretatie',
    'core_description' => 'Gevolg Idee - Interpretatie',
    'type' => 'T',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'LTXT',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 1,
    'column_exists' => 'Y',
    'hqtype_descr' => 'open',
    'mandatory' => 'N',
    'question_nr' => 16,
    'main_question' => 1,
  ),
  '585242X108X1605' => 
  array (
    'description' => '<p>Alle bijdragen worden opgenomen in de Ouderkerk mozaïek. Als je liever hebt dat je naam niet wordt getoond, geef dat dan hier aan.</p>
 
<p><strong>Toon mijn naam bij mijn toekomstidee:</strong></p>
 
<p> </p>
',
    'stripped_description' => 'Alle bijdragen worden opgenomen in de Ouderkerk mozaïek. Als je liever hebt dat je naam niet wordt getoond, geef dat dan hier aan. Toon mijn naam bij mijn toekomstidee:  ',
    'core_description' => 'Toon mijn naam bij mijn toekomstidee:',
    'type' => 'Y',
    'group_name' => 'Toekomstidee',
    'hqtype' => 'YSNO',
    '1sttimeonly' => '1',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'keuze',
    'mandatory' => 'Y',
    'question_nr' => 17,
    'main_question' => 1,
  ),
  '585242X109X1602' => 
  array (
    'description' => '<p>Stel dat jouw toekomstidee wordt uitgevoerd.</p>
 
<p><b>Aan welke van de onderstaande hogere doelen wordt dan een bijdrage geleverd?</b></p>
',
    'stripped_description' => 'Stel dat jouw toekomstidee wordt uitgevoerd. Aan welke van de onderstaande hogere doelen wordt dan een bijdrage geleverd?',
    'core_description' => 'Stel dat jouw toekomstidee wordt uitgevoerd.
 
Aan welke van de onderstaande hogere doelen wordt dan een bijdrage geleverd?
',
    'type' => 'M',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'MCQ1',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'N',
    'hqtype_descr' => 'meerkeuze',
    'mandatory' => 'Y',
    'question_nr' => 18,
    'main_question' => 1,
  ),
  '585242X109X1602SQ001' => 
  array (
    'description' => '<strong>Ouderkerk behouden voor alle bewoners zoals het nu is</strong>; een mooi dorp om te wonen en te verblijven',
    'stripped_description' => 'Ouderkerk behouden voor alle bewoners zoals het nu is; een mooi dorp om te wonen en te verblijven',
    'core_description' => 'Ouderkerk behouden voor alle bewoners zoals het nu is',
    'type' => 'T',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X109X1602',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X109X1602SQ002' => 
  array (
    'description' => '<strong>Ouderkerk behouden en licht ontwikkelen voor alle bewoners en bezoekers</strong>; een dorp aantrekkelijk om te wonen en optimaal te bezoeken',
    'stripped_description' => 'Ouderkerk behouden en licht ontwikkelen voor alle bewoners en bezoekers; een dorp aantrekkelijk om te wonen en optimaal te bezoeken',
    'core_description' => 'Ouderkerk behouden en licht ontwikkelen voor alle bewoners en bezoekers',
    'type' => 'T',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X109X1602',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X109X1602SQ003' => 
  array (
    'description' => '<strong>Ouderkerk ontwikkelen voor alle huidige en toekomstige bewoners</strong>; een dorp dat doorgroeit en optimaal alle ontwikkelingen faciliteert',
    'stripped_description' => 'Ouderkerk ontwikkelen voor alle huidige en toekomstige bewoners; een dorp dat doorgroeit en optimaal alle ontwikkelingen faciliteert',
    'core_description' => 'Ouderkerk ontwikkelen voor alle huidige en toekomstige bewoners',
    'type' => 'T',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X109X1602',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X109X1602SQ004' => 
  array (
    'description' => '<strong>Ouderkerk ontwikkelen voor alle huidige en toekomstige bewoners alsmede voor  bezoekers</strong>; een dorp dat doorgroeit en optimaal alle ontwikkelingen benut, maar daar extra ontwikkelingen bovenop zet',
    'stripped_description' => 'Ouderkerk ontwikkelen voor alle huidige en toekomstige bewoners alsmede voor bezoekers; een dorp dat doorgroeit en optimaal alle ontwikkelingen benut, maar daar extra ontwikkelingen bovenop zet',
    'core_description' => 'Ouderkerk ontwikkelen voor alle huidige en toekomstige bewoners alsmede voor  bezoekers',
    'type' => 'T',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X109X1602',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X109X1602SQ005' => 
  array (
    'description' => '',
    'stripped_description' => '',
    'core_description' => '',
    'type' => 'T',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X109X1602',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X109X1597' => 
  array (
    'description' => '<p><strong>Bij welke grote onderwerpen van Ouderkerk hoort jouw idee?</strong></p>
',
    'stripped_description' => 'Bij welke grote onderwerpen van Ouderkerk hoort jouw idee?',
    'core_description' => 'Bij welke grote onderwerpen van Ouderkerk hoort jouw idee?',
    'type' => 'M',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'MCQ1',
    '1sttimeonly' => '0',
    'extra' => '',
    'meaning_extra' => '',
    'hidden' => 0,
    'column_exists' => 'N',
    'hqtype_descr' => 'meerkeuze',
    'mandatory' => 'Y',
    'question_nr' => 19,
    'main_question' => 1,
  ),
  '585242X109X1597SQ001' => 
  array (
    'description' => '<strong>het centrum van Ouderkerk</strong><br/> (het Kampje, de winkels, de horeca en festiviteiten op en rondom en in het centrum en goed wonen) ',
    'stripped_description' => 'het centrum van Ouderkerk (het Kampje, de winkels, de horeca en festiviteiten op en rondom en in het centrum en goed wonen)',
    'core_description' => 'het centrum van Ouderkerk',
    'type' => 'M',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X109X1597',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X109X1597SQ002' => 
  array (
    'description' => '<strong>R net busstation </strong><br/> (parkeerproblematiek rondom halte, hard rijden, onveilige rotondes en stoplichten, drukke Stramanweg, versnipperde parkjes)',
    'stripped_description' => 'R net busstation (parkeerproblematiek rondom halte, hard rijden, onveilige rotondes en stoplichten, drukke Stramanweg, versnipperde parkjes)',
    'core_description' => 'R net busstation ',
    'type' => 'M',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X109X1597',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X109X1597SQ003' => 
  array (
    'description' => '<strong>A9/Benning en Jan Hekmanschool </strong><br/> (verbreding A9, bomenkap, bereikbaarheid, ontwikkeling rondom Urbanuskerk)',
    'stripped_description' => 'A9/Benning en Jan Hekmanschool (verbreding A9, bomenkap, bereikbaarheid, ontwikkeling rondom Urbanuskerk)',
    'core_description' => 'A9/Benning en Jan Hekmanschool ',
    'type' => 'M',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X109X1597',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X109X1597SQ006' => 
  array (
    'description' => '<strong>Bindelwijk, Amstelschool, Kofschip </strong><br/> (nieuwbouw Scholen, bereikbaarheid, parkeren)',
    'stripped_description' => 'Bindelwijk, Amstelschool, Kofschip (nieuwbouw Scholen, bereikbaarheid, parkeren)',
    'core_description' => 'Bindelwijk, Amstelschool, Kofschip ',
    'type' => 'T',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X109X1597',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X109X1597SQ004' => 
  array (
    'description' => '<strong> Amstelbrug</strong><br/> (renovatie brug, bomen, recreatie waterkant, horeca, veiligheid verkeer) ',
    'stripped_description' => 'Amstelbrug (renovatie brug, bomen, recreatie waterkant, horeca, veiligheid verkeer)',
    'core_description' => ' Amstelbrug',
    'type' => 'T',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X109X1597',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X109X1597SQ005' => 
  array (
    'description' => '<strong> De Ronde Hoep </strong><br/> (groene hart, toenemen recreatie, ontwikkeling agrarische bedrijven, rust en natuur, B&B) ',
    'stripped_description' => 'De Ronde Hoep (groene hart, toenemen recreatie, ontwikkeling agrarische bedrijven, rust en natuur, B&B)',
    'core_description' => ' De Ronde Hoep ',
    'type' => 'T',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'MCQA',
    '1sttimeonly' => '0',
    'extra' => '585242X109X1597',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
  '585242X109X1597other' => 
  array (
    'description' => 'Anders',
    'stripped_description' => 'Anders',
    'core_description' => 'Anders',
    'type' => 'M',
    'group_name' => 'Koppel je toekomstidee',
    'hqtype' => 'OTHR',
    '1sttimeonly' => '0',
    'extra' => '585242X109X1597',
    'meaning_extra' => 'Reference to question',
    'hidden' => 0,
    'column_exists' => 'Y',
    'hqtype_descr' => 'antwoord',
    'mandatory' => '-',
    'question_nr' => '',
    'main_question' => 0,
  ),
)

Qnrs

array (
  0 => 
  array (
    'label' => 'OBJECT',
    'org' => '8',
    'int' => '10',
  ),
  1 => 
  array (
    'label' => 'IDEA',
    'org' => '11',
    'int' => '12',
  ),
  2 => 
  array (
    'label' => 'GOAL',
    'org' => '15',
    'int' => '16',
  ),
)

Qcols

array (
  0 => 
  array (
    'label' => 'OBJECT',
    'org' => '585242X108X1599',
    'int' => '585242X108X1606',
  ),
  1 => 
  array (
    'label' => 'IDEA',
    'org' => '585242X108X1600',
    'int' => '585242X108X1607',
  ),
  2 => 
  array (
    'label' => 'GOAL',
    'org' => '585242X108X1603',
    'int' => '585242X108X1608',
  ),
)

Ouderkerk a/d Amstel

Technisch overzicht

Meta SQL voor survey 585242

SQL voor survey_585242

C2QMAP

INTERPRETATIONS

Verwijzende pagina's