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', ), )