-
Remco Tukker authoredRemco Tukker authored
mapping.py 7.61 KiB
# NB in the comments i describe the source data
# query to get the data required to make this mapping:
# select a.value, q.id, q.title, q.cell_column, q.cell_row, q.identifier, q2.identifier, q2.column_headers, q2.row_headers from answers a join questions q on a.question_id = q.id left join questions q2 on q.parent_id = q2.id where a.value <> '""' and q.section_id > 225 order by q.id, a.id;
id_to_name = {
16402: "budget",
16405: "income_sources:client_institutions",
16406: "income_sources:european_funding",
16407: "income_sources:commercial",
16408: "income_sources:other",
16409: "income_sources:gov_public_bodies",
16410: "charging_mechanism", # "Other" "We use a combination of flat fee and usage-based fee" "We charge a usage-based fee" "We charge a flat fee, based on bandwidth" "We do not charge them directly"
16413: "staff_employment_type:subcontracted_fte",
16414: "staff_employment_type:permanent_fte",
16416: "staff_roles:technical_fte",
16417: "staff_roles:nontechnical_fte",
16418: "parent_organization", # "Yes" "No"
16419: "parent_organization_name",
16420: "suborganizations", # "Yes" "No"
16422: "suborganization_details[0]:suborganization_name",
16426: "suborganization_details[0]:suborganization_role-Comment",
16429: "suborganization_details[1]:suborganization_name",
16430: "suborganization_details[2]:suborganization_name",
16432: "suborganization_details[3]:suborganization_name",
16433: "suborganization_details[4]:suborganization_name",
16434: "suborganization_details[1]:suborganization_role-Comment",
16435: "suborganization_details[2]:suborganization_role-Comment",
16438: "suborganization_details[3]:suborganization_role-Comment",
16439: "suborganization_details[4]:suborganization_role-Comment",
16446: "suborganization_details[2]:suborganization_role", # "Other" "HPC centre" "IDC federation"
16448: "suborganization_details[1]:suborganization_role", # "Other" "HPC centre" "IDC federation"
16449: "suborganization_details[0]:suborganization_role", # "Other" "HPC centre" "IDC federation"
16450: "suborganization_details[4]:suborganization_role", # "Other" "HPC centre" "IDC federation"
16451: "suborganization_details[3]:suborganization_role", # "Other" "HPC centre" "IDC federation"
16452: "ec_projects", # "Yes" "No"
16453: "ec_project_names[]:ec_project_name", # json list with double quotes
16455: "full_name_english",
16456: "full_name_national_languages",
16457: "abbreviation_english",
16458: "abbreviation_national_languages",
16459: "street_name_and_number",
16460: "city",
16461: "postal_code",
16462: "country", # NB some country names are a bit different
16463: "phone_number",
16464: "email_address",
16465: "website",
16466: "organization_comments", # but should we map comments or not?
16468: "corporate_strategy", # "Yes" "No"
16469: "corporate_strategy_url",
16470: "policies:environmental_policy:available", # "Yes" "No"
16471: "policies:environmental_policy:url",
16472: "policies:equal_opportunity_policy:available", # "Yes" "No"
16473: "policies:equal_opportunity_policy:url",
16474: "policies:connectivity_policy:available", # "Yes" "No"
16475: "policies:connectivity_policy:url",
16476: "policies:acceptable_use_policy:available", # "Yes" "No"
16477: "policies:acceptable_use_policy:url",
16478: "policies:privacy_notice:available", # "Yes" "No"
16479: "policies:privacy_notice:url",
16480: "policies:data_protection_contact:available", # "Yes" "No"
16481: "policies:data_protection_contact:url",
16482: "central_software_procurement", # "Yes" "No"
16483: "central_procurement_amount",
16484: "formal_service_management_framework", # "Yes" "No"
16485: "service_level_targets", # "Yes" "No"
16486: "service_portfolio_changes", # "Yes" "No"
16488: "service_matrix{keys}:service_types['identity']", # json list with double quotes ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
16489: "service_matrix{keys}:service_types['network_services']", # json list with double quotes ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
16490: "service_matrix{keys}:service_types['collaboration']", # json list with double quotes ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
16491: "service_matrix{keys}:service_types['security']", # json list with double quotes ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
16492: "service_matrix{keys}:service_types['isp_support']", # json list with double quotes ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
16493: "service_matrix{keys}:service_types['storage_and_hosting']", # json list with double quotes ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
16494: "service_matrix{keys}:service_types['multimedia']", # json list with double quotes ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
16495: "service_matrix{keys}:service_types['professional_services']", # json list with double quotes ["Universities","Further education","Research institutes","Primary Schools","Government","For profit organisations","International Research Organisations","Cultural Institutions","(Non-research) hospitals","Secondary Schools"]
16496: "service_portfolio_eosc_portal", # "Yes" "No"
16497: "services_on_eosc_portal_list[]:service_name", # json list with double quotes
16499: "audits", # "Yes" "No"
16500: "audit_specifics",
16501: "business_continuity_plans", # "Yes" "No"
16502: "business_continuity_plans_specifics",
16503: "security_controls", # json list with double quotes ["Anti Virus","Anti-Spam","Firewall","DDoS mitigation","Network monitoring","IPS/IDS","ACL","Network segmentation","Integrity checking","Other"]
16504: "security_controls-Comment",
16505: "policy_comments", # but should we map comments or not?
16760: "policies:gender_equality_policy:available", # "Yes" "No"
16761: "policies:gender_equality_policy:url",
16762: "crisis_management_procedure", # "Yes" "No"
16763: "crisis_exercises", # json list with double quotes ["We participate in GEANT Crisis workshops such as CLAW","No, we have not done any crisis exercises or trainings","We participated in National crisis exercises ","We had a real crisis","We run our own simulation exercises","We run our own tabletop exercises","We have done/participated in other exercises or trainings"]
}