Pooled Data stored and shared: Transfer final processed data for long‐term use
Abstract
This deliverable ( D10.6) describes the final transfer of processed data for long‐term use including the Equal‐Life website, Equal‐Life toolbox and guidebook, aggregate statistics, meta‐data, anonymized enriched data, codes, pooled results, models for data mining, patent fillings etc.
Full text
1 PooledDatastoredandshared: Transferfinalprocesseddataforlong‐termuse. Projecttitle:EarlyEnvironmentalqualityandlife‐coursementalhealtheffect ProjectNumber:874724 ProjectAcronym:Equal‐Life Workpackage10‐DeliverableD10.6 HISTORYOFCHANGES VersionPublicationdateChange 1.131‐12‐2024 Initialversion 1.231‐02‐2025 Adaptedandreadytobedistributedforreview 1.331‐03‐2025 Adaptedbasedoncommentsandreadytobeuploaded 1.415‐05‐2025 Submitted H2020programGrantagreementnumbers874724(Equal‐Life), Projectstartdate:Jan1 st 2020Duration:60months ProjectCoördinator:IrenevanKamp(RIVM) WP(numberandtitle)EQUAL‐LIFEWP10 DeliverableNumberEQUAL‐LIFED10.6 DeliverableTitlePooleddataset Duedate31‐12‐2024
D10.6:Transferfinalprocesseddataforlong‐termuse 2 Actualdate15‐05‐2025 DisseminationLevelPublic LeadbeneficiaryRIVM ResponsibleauthorsIrenevanKamp,HendriekBoshuizen E‐mail/phone responsibleauthors [email protected] Hendriek. [email protected] +3130886893222 +3130886892934 Co‐authorsPetervandenHazel Pvdhazel<[email protected]> MarcoBalduini [email protected] ReviewersAllPI’s
D10.6:Transferfinalprocesseddataforlong‐termuse 3 Contents Contents..................................................................................................................................................3 1.Executivesummary.........................................................................................................................4 2.DataSummary.................................................................................................................................5 2.1.Existingdata.............................................................................................................................5 2.2Sixin‐depthstudies...................................................................................................................5 2.3Enrichedandvalidateddata.....................................................................................................6 3.Transferingdataforlongtermuse..............................................................................................7 3.1Wix..........................................................................................................................................8 3.2Zenodo................................................................................................................................8 4.Implementationandmaintenance.............................................................................................9 5.Otherissues................................................................................................................................9 6.Referencesselect......................................................................................................................10 Glossary.............................................................................................................................................11 Annex1:............................................................................................................................................12 Annex2:............................................................................................................................................13 Annex3.............................................................................................................................................15 Annex4:............................................................................................................................................17
D10.6:Transferfinalprocesseddataforlong‐termuse 4 1. Executivesummary Thisdeliverable(D10.6)describesthefinaltransferofprocesseddataforlong‐termuseincludingthe Equal‐Lifewebsite(Studyingtheexposomeforahealthierfutureforallchildren|EqualLife),Equal‐ Lifetoolboxandguidebook,aggregatestatistics,meta‐data,anonymizedenricheddata,codes,pooled results,modelsfordatamining,patentfillingsetc. AdetaileddescriptionofthedifferentproductsoftheEqual‐LifeprojectwasprovidedinD10.5and Annex3inthisdocument.Theseproductswillbeaccessibleindifferentchannels,includinganopen accesswebsitewithnorestrictions(https://www.equal‐life‐toolbox.eu/).Deliverable10.6ispartof Task10.3.Datamanagement,ledbyRIVMandco‐ledbyINCHESandQUANTIA.Thistaskfocuseson themanagementofprojectdataincludingrawdataandthederivedandprocessedfinaldata.During theproject,theresearchdatawerestoredcentrallyataserveratRIVMforprocessingandmidterm storage.Alongethicalguidelines,theoriginaldatastaywiththeownersandwillonlybepooledat resultlevel.Thisimpliesthatmatchingoftheexposuredatatothe(mentalhealthandcognitive)out‐ comedataalsohappenspercohort/dataset.ThepooleddatawerestoredattheRIVMplatform(Via‐ desk)forfurtherstatisticalanalysisinthedifferentworkpackages.Thedatacollectedinthein‐depth studiesweredealtwithbytherespectiveownersofthecohorts.Thenewdatacollectedfromschool‐ childrenaremanagedbytheinstituteperformingthemeasuresandundertheirnationalregulations. Thedataanddailymodificationsduringdataprocessingarebackedupdailytonetworkdrives.This datarepositorywasusedalsoforsharingwiththepartnersintheconsortium.Inclosecollaboration withthepartnersdealingwithcommunication,dissemination,andtooldevelopmentthistaskplanned andimplementedthesharingofnoveldataandresultscreatedintheproject.Thisalsoincludesplan‐ ningandimplementingthetoolboxandguidancedocument.Aftertheprojectisfinishedtheexpo‐ somedataandthepooledresultsareincorporatedintheEqual‐Lifetoolbox.Deliverable10.5(confi‐ dential)describesthewaysinwhichdataismadeaccessibleinternallyandexternallyalsoafterthe lifetimeoftheproject.Hereasummaryispresented. AlldatawillbearchivedonViadeskbyRIVMaswellastheAS,thepooledresultsandanonymised exposuredataofthosecohortsthatallowthedatatobemadepublicinZenodo,anEUrepository. Alink(https://zenodo.org/communities/equal_life) willbeprovidedontheEqual‐Lifewebsitehttps://www.rivm.nl/en/international‐projects/equal‐life andintheEqual‐lifetoolsandGuidebookwhichisexternallyhostedat(https://www.equal‐life‐ toolbox.eu/).Specifically,thetoolboxwasdevelopedusingtheWixplatform,whichalsoprovides hostingservices. Duringtheplatformselectionprocess,weensuredthatWixcomplieswithall relevantEuropeanregulations(e.g.,GDPR).Thetoolboxwillbehostedalsoaftertheprojectby contractuntilMay2026.Fortheperiodafterthisadditionalfundingwillhavetobesought(seealso D10.5andD10.7).AnoverviewoftheEqual‐LifeproductsintheEqual‐Lifetoolboxisprovidedin Annex3.
D10.6:Transferfinalprocesseddataforlong‐termuse 5 2. DataSummary 2.1. Existing data:elevencohorts(birthcohortsandschoolstudies). ThenamesofthesecohortsandcontactdetailsandothercharacteristicsarelistedinAnnex1 Equal‐Lifeusesprimarilyexistingdataderivedfromninecohorts,andthreelongitudinalandcross‐ sectionalstudiesinschoolchildren(N=>250.000pp)innineEUmemberstates.Thedatacontain informationfromchildren(prenataluptoage21)andtheirparents.Theexistingdatawasenriched withdatarelatedtotheexternalexposome(physicalandsocial)andintermediateeffectmarkers(in‐ ternalexposomeoncelinkedtoexposures), 2.2 Six in-depth studies. Inaddition,datahasbeencollectedfromschoolchildrenactivities(inSweden,Belgium,Germany,and theNetherlands)tostudythedistinctmechanismsunderlyingtheassociationofenvironmentalexpo‐ sureswithmentalhealthandcognitivedevelopmentindicators,includingphysicalaswellassocial aspects(stress/restoration,sleep,supportiveenvironmentsforchildrencopingandself‐regulation). Inasampleofschoolchildren,activitypatternsinfortheiragerelevantsettingswerestudied.Also, datawerecollectedabouttimeactivitypatternsinchildrenandadolescents(intheNetherlands)and duringexperimentsonchildren’sauditorycognition(inAachen,Germany). Note(Annex2)thatSleepstudy(Alpine8‐14years)hasbeenreplacedbySleepstudy(Alpine11‐14 years).ThereasonsforthatchangearealsodescribedintheupdatedAnnex1oftheGApartBand havebeenapprovedbytheECviaanamendment.
D10.6:Transferfinalprocesseddataforlong‐termuse 6 Table1:Overviewofin‐depthstudies GDPRdoesnotallowformakingthedatafromthein‐depthstudypublic.Theycanbesharedwith researcheriftheaimsalignwiththeinformedconsentofparticipants(seeD12.6)andwithagreements ofthePI’s(seecontactlistinAnnex4). 2.3 Enriched and validated data InthefirstphaseoftheprojecttheXYcoordinatesweredeliveredbythedata‐ownerstothedata enrichers.Also,thebio‐sampleswereselectedandtransferredtothelaboratoryperformingthe experiments.Datavalidationhappenedatbothsidesaniterativeprocessmeaningtheproviderand receiverside.Thisprocessisnowfinished.Importantfeaturesarethattheenrichmenttakesplace perdatasetandthatthedataset,oncecompleted,willnotbestoredexceptattheowner’sside.In otherwords,thedataownersdonotseeorshareeachother’s(enriched)data.Amongtheenrichers themselvesmodelsmightbeexchangedaswellastheunderlyingdata,butthisishighlydependent onthevariablesathand.Providingenricheddataminusthexycoordinatesandpseudonymizedby dummyaddresseswillbesharedinZenodo. ProvidingIDsandXYcoordinatesby9dataownerstothe6dataenrichers.(Done) ProvidingIDsageandgenderto1dataenricher;(Done) EnrichingtheXYcoordinateswithexposuredataby6enrichers;(Done) EnrichingtheIdsofselectedchildrenwithbiomarkersby1enricher.(Done) Table2:OverviewofthestatusoftheDataTransferAgreementson27‐06‐2024 Asshownintable2,theexchangeofXYcoordinatesisnowfinalized.Thisdatawasneededforthe dataownersandenrichersandnocentralstoragewasneeded.Thisimpliesthattherehasbeenonly =notapplicable =DTAsigned JohnGulliver(ULEIC) GabrieleBolte(UB) AlessandroBozzon(TUD) MaartenHornikx(TUE) DickBotteldoorn(Ugent) MariaForaster(ISGlobal) KatjaKanninen(UEF) 1ABCD Dataavailable TanjaVrijkotte(AMC) 2ALSPAC Nodataavailable CharlotteClark(ARUP) 3PIAMA Dataavailable JolandaBoer(RIVM) 4a RANCH‐NL Dataavailable ElisevanKempen(RIVM) 5NORAH Dataavailable MariaKlatte(TUK) 6Alpine Dataavailable PeterLercher(GUT) 7STARS Dataavailable YunChen(UGOT) 8BREATHEand WALNUTS Dataavailable MariaForaster(ISGlobal) 9FAIR Dataavailable JennySelander(KI) 10 FinnTwin12 Dataavailable JaakkoKaprio(UH) 11 DatatransferISG‐UE F Dataavailable MariaForaster(ISGlobal) StatusDataTransferEqual‐LifebasedoninformationViadesk,27June2024 DatareceiversGroup# Viadesk Dataset Dataprovider Dataavailableon Viadesk(No /Yes ) LEGENDA Datacollectionstudies Responsiblepartner TimeactivityexposurepatternstudyTU/e Auditorycognitioninactivity‐basedacousticsettingsRWTH PreschoolstudyGermanyTUK/ZEUS PreschoolstudyBelgiumUGhent SleepstudyonsubsampleofAlpinecohortcancelledGUT SecondaryanalysesonsubsampleofAlpinecohort(11‐14 years) GUT Sleepstudyonsubsampleofstarscohort(17‐19years) UGOT
D10.6:Transferfinalprocesseddataforlong‐termuse 7 anexchangeofdataandoncethisprocessofexchangewasfinishedthefilesattheexchangenodeof theRIVMwasremoved.Itwascheckedwhetherthesizeoftheenricheddatasetscausesissues, estimatedtobeoveramillionrecords(lines),includingdummycoordinates,andsome500columns atmax. Forvalidationofthedatawedonotneedaspecifiedfunctionality.Thistaskisthecalloftheenrichers beforetheysharethedataagainandofthecohortowners(whenreceivingtheenricheddataset). Analysisbytheenricherswillhappenwiththeirowntools,modelsetc. Specialattentionisneededforversionmanagementonthedatafiles;possiblymorethanoneiteration isneededtooptimisetheenrichment.Andalsotheprocessofvalidationcanleadtomultipleversions ofthedatafiles.Itwasrecommendedtocentralisedecisionmakingaboutthis.Also,itshouldbe decidedhowthecommunicationaboutthesedifferentversionsisorganizedandwhatplatformis suitableforthis(NBViadeskdoesnotfacilitatesuchinteraction,butversioncontroliswell established). Exchangeofdataonthebuiltenvironment(D5.7&D5.8)andnaturalenvironment(MS8)and environmentalquality(D3.3)isfinished. Actionsperformed 1.Testthemaximumsizeofexchangedatasets o CheckedifViadeskandMSTeamsprovidethefunctionalityneeded(done) o Arrangedforaccessrightinthefiles.(done) o Saveformats(CSVandGeoJSON).done 2.Exchangeofmodelsanddatabetweenenrichers. Someenricherssharedmodelcodesoftransportmodelsandunderlyingdata.Thebestsolutionfor internalcollaborationinrelationtoamodelcodeisGitHub.They(will)alsoprovidecodeofthe exposuremetricsdevelopedfordataenrichment,soitisnotonlyabout(transport)models.Alsothere isawishtoexchangetheunderlying(traffic)datasuchastrafficvolumes,numberoftrains(day,night), distancetogreenarea,meanareaofgreen/bluespace).Thesewillbegeospatialdatathatcan,indeed, beprojectedonamap,butmostofthemwillbedataattributesintabularformat(withattachedgeo‐ locationperdatarecord(attributestothesemapsaresimpletablescontainingforexampleheightof buildingsortrafficcountsonstreets).ItwasconfirmedthatallpartnerscanworkwithGITand exchangescanbeperformedinCSVfiles. AnoverviewofthedataisprovidedinAnnex3,wherebyadistinctionismadebetweenMETADATA, DATAanCODES. 3. Transferringdataforlongtermuse TheEqual‐Lifetoolboxandguidebook,metadata,publications,pooledresultsandcodesaremade availableintwoplatforms:thewebsite(https://www.equal‐life‐toolbox.eu/)andtheEUrepository Zenodo(https://zenodo.org/communities/equal_life).Adescriptionisprovidedinthenext paragraphs.
D10.6:Transferfinalprocesseddataforlong‐termuse 8 3.1 Wix Wix.comisacloud‐basedwebdevelopmentplatformthatallowsuserstocreateandmanage professionalwebsites.Theplatformprovidesanintuitivedrag‐and‐dropeditor,avastlibraryof customizabletemplates,andasuiteofbuilt‐intoolsthatfacilitateseamlesscollaboration.Wixenables co‐designandco‐creationwithusersbyallowingmultiplecontributorstoworkonawebsite simultaneously,offeringrole‐basedaccesscontrols,andintegratingreal‐timefeedbackmechanisms. Thesefeaturesmakeitavaluablesolutionforindividuals,smallbusinesses,andorganizationslooking tobuildandrefinetheironlinepresenceefficiently. Wix’sEuropeanheadquartersislocatedinDublin,Ireland,whereitprovidesregionalsupportand ensuresadherencetoEuropeanregulations.BymaintainingastrongpresenceinEurope,Wix continuestoenhanceitsserviceswhilealigningwiththelatestlegalandregulatoryrequirements concerningdataprivacy,cybersecurity,anddigitalcommerce. Wixplacesastrongemphasisondatasecurityandprivacyandoperatesinfullcompliancewiththe GeneralDataProtectionRegulation(GDPR).Theplatformprovideswebsiteownerswithdedicated toolstomanageuserconsent,controlpersonaldata,andgenerateGDPR‐compliantprivacypolicies. Usershavetheabilitytoaccess,modify,ordeletetheirpersonaldata,ensuringtransparencyand adherencetoEuropeandataprotectionstandards. Toensurehighperformance,reliability,andsecurity,WixstoresandprocessesdataforEuropean userswithinEU‐baseddatacenters,reinforcingitscommitmenttoGDPRcomplianceandminimizing datatransfersoutsidetheEuropeanEconomicArea(EEA). 3.2 Zenodo Zenodo(https://zenodo.org)isanEUOpenResearchRepositoryandisaZenodo‐communitydedi‐ catedtofosteringopenscienceandenhancingthevisibilityandaccessibilityofresearchoutputs fundedbytheEuropeanUnion.ThecommunityismanagedbyEuropeanOrganizationforNuclear Research(CERN)onbehalfoftheEuropeanCommission. ThemissionoftherepositoryistosupporttheimplementationoftheEU'sopensciencepolicy,provid‐ ingatrustedandcomprehensivespaceforresearcherstosharetheirresearchoutputssuchasdata, software,reports,presentations,postersandmore.TheEUOpenResearchRepositorysimplifiesthe processofcomplyingwithopensciencerequirements,ensuringthatresearchoutputsfromHorizon Europe,Euratom,andearlierFrameworkProgramsarefreelyaccessible,therebyacceleratingscien‐ tificdiscoveryandinnovation. TheEUOpenResearchRepositoryservesasacomplementaryplatformtotheOpenResearchEu‐ rope(ORE)publishingplatform.OpenResearchEuropefocusesonprovidingapublishingvenuefor peer‐reviewedarticles,ensuringthatresearchmeetsrigorousacademicstandards.TheEUOpenRe‐ searchRepositoryprovidesaspaceforalltheotherresearchoutputsincludingdatasets,software, posters,andpresentationsthatareoutofscopeforORE.Thisholisticapproachenablesresearchers tonotonlypublishtheirfindingsbutalsosharetheunderlyingdataandmaterialsthatsupporttheir work,fosteringtransparencyandreproducibilityinthescientificprocess.
D10.6:Transferfinalprocesseddataforlong‐termuse 9 TheEUOpenResearchRepositoryisfundedbytheEuropeanUnionundergrantagreement no.101122956(HORIZON‐ZEN).Formoreinformationabouttheprojectseehttps://about.ze‐ nodo.org/projects/horizon‐zen/.ZenodoisfundedbytheEuropeanCommission. WeselectedZenodoastheprimaryrepositoryforlong‐termarchiving,asitoffersatrusted,sustaina‐ ble,andsecuresolutionforpreservingoutputsbeyondthelifetimeoftheproject.WhileGitHubre‐ mainsthepreferredplatformforactivedevelopmentandcollaborationduringtheproject,Zenodo providesamorerobustoptionforpermanentstorage.Nonetheless,theGitHubrepositorywillremain accessibleforseveralyearsaftertheproject'scompletiontoensurecontinuityandeaseofaccess. Zenodoaddressestheneedforlong‐termpreservationbycreatingapermanentarchivelinkedto GitHub,ensuringthatkeyoutputsremainavailableandcitableovertime.Belowisasummaryofkey differences: ‐ ArchivalPermanence:Zenodoisspecificallydesignedforlong‐termpreservation,retaining archiveditemsforthelifetimeofCERN(minimum20years).Eachreleaseisstoredasatarball, assignedaDOI(DigitalObjectIdentifier),andmadeindependentfromGitHub,ensuringitre‐ mainsunchangedovertime. ‐ DigitalObjectIdentifiers(DOIs):ZenodoautomaticallyassignsDOIstoeacharchivedrelease, facilitatingacademiccitationandimprovingdiscoverability. ‐ IntegrationwithGitHub:ZenodooffersseamlessintegrationwithGitHub,automaticallyar‐ chivingeachreleaseandgeneratinganewDOI,thussimplifyingtheprocessofcreatingacit‐ able,permanentversionofthesoftwareordataset. BycombiningGitHubforongoingdevelopmentandZenodoforfinalarchival,weensurebothusability duringtheprojectandpreservationbeyonditsduration. 4. Implementationandmaintenance AnaccounthasbeenopenedatZenodoandthedataandcodeswillbesubmittedstepwise beforetheendoftheprojectinJune2025butpreferablyatanearlierstage.Maintenanceis guaranteeduntiltheexistenceofCERN.Thepotentialriskisthatifthedatawillbedeposited inJunethereisnotmuchmargintocreatethelinkbetweenZenodoandtheEqual‐Lifetoolbox. Therefortheprocesswillhavetospeedupasmuchaspossibleandthecoordinatinginstitute willtakeonboardthetaskofmaintenanceofthetoolboxwithadditionalfunding. 5. Otherissues n.a.
D10.6:Transferfinalprocesseddataforlong‐termuse 16 ‐Casestudiesof equityimpact assessmentofurban interventions/Good practice WP4(WP7) OpenwebsiteUniversityBremen KarolinskaInstitute ‐Conceptualmodels onmechanisms…. (WP1)andonthe SocialExposome (WP4) WP1/WP4OpenwebsiteGothenburgUniversity UniversityBremen ‐Frameworkto considerequity aspectsinurban interventions WP4OpenwebsiteUniversityBremen IIDATA ‐Enricheddata withoutthexy coordinates Includingfake addresses WP3,WP5Accesscan onlybe givenwith consentof thedata owners ZenodoCohortownersSeetable5* AggregatestatisticsWP6/WP7‐Accessto AScanonly begiven withconsent ofthedata owner withinthe consortium aswellas outsidethe consortium ZenodoCohortownersseetable5* PooledresultsWP6/WP7Accessto pooled resultsonly withconsent ofalldata ownersof data includedin thepooled results ZenodoRIVM
D10.6:Transferfinalprocesseddataforlong‐termuse 17 ‐Linkagebetween biomarkersand exposures(internal exposome). WP2,andcohort owners Biomarker determinant swillbe managed andshared bythe responsible institutes andunder their national regulations Sharingwith othersislimited FinnTwin12data findablein https://thl.fi/en /research‐and‐ development/th l‐biobank/for‐ researchers UEF IISPV HelsinkiUniversity IIICODES Codesenabling pooleddataanalyses WP6(in collaborationwith WP7) Zenodo RIVM ‐Codesenablingdata enrichment Seealsoabove ‐Newexposuredata ormodelstoobtain thesederivedinWP 3,4and5 WP3,WP4,WP5 ZenodoISGlobal StGeorgeUniversity Technicaluniversity Eindhoven UniversityGhent TechnicalUniversityDelft BremenUniversity Annex4:Contactdetailsperinstitute No Name Short name Country Contact details 1 RIJKSINSTITUUT VOOR VOLKSGEZONDHEID EN MILIEU RIVM Netherlands [email protected] 2 GOETEBORGS UNIVERSITET UGOT Sweden YunChen <[email protected]> 3 ITA-SUOMEN YLIOPISTO UEF Finland Katja Kanninen <katja.kanni- [email protected]> 4 UNIVERSITY OF LEICESTER ULEIC United Kingdom Anna Hansell <ah618 @ leicester.ac.uk> 5 UNIVERSITAET BREMEN UB Germany Gabriele Bolte <[email protected]> 6 TECHNISCHE UNIVERSITEIT DELFT TUD Netherlands Achilleas Psyllidis <A.Psyl- [email protected]> 7 KAROLINSKA INSTITUTET KI Sweden 'Jenny Selander' <[email protected]> 10 FUNDACION PRIVADA INSTITUTO DE SALUD GLOBAL BARCELONA ISGlobal Spain Payam Dadvand <payam.dad- [email protected]rg> 11 TECHNISCHE UNIVERSITAT KAISERSLAUTERN RPTU Germany Maria Klatte [Soz.-Wi.] <[email protected]> ListofBeneficiaries
D10.6:Transferfinalprocesseddataforlong‐termuse 18 12 UNIVERSITEIT GENT UGent Belgium Dick Botteldooren <Dick.Botteldooren @ UGent.be> 13 HELSINGIN YLIOPISTO UH Finland Kaprio, Jaakko A <[email protected]> 14 TECHNISCHE UNIVERSITEIT EINDHOVEN TU/e Netherlands Maarten Hornikx <M.C.J.Hor- [email protected]l> 15 ZEUS GMBH, ZENTRUM FUR ANGEWANDTE PSYCHOLOGIE, UMWELTUND SOZIALFORSCHUNG ZEUS Germany Dirk Schreckenberg (ZEUS) <[email protected]> 17 TECHNISCHE UNIVERSITAET GRAZ GUT Austria Peter Lercher <[email protected]> 18 RHEINISCH-WESTFAELISCHE TECHNISCHE HOCHSCHULE AACHEN RWTH Germany Janina Fels <[email protected]> 20 QUANTIA CONSULTING SRL Quantia Italy 'Marco Balduini' <marco.balduini@quantiaconsul ting.com> 22 FUNDACIO INSTITUT D'INVESTIGACIO SANITARIA PERE VIRGILI (IISPV) IISPV Spain Jordi Julvez Calvo <[email protected]> 23 ST GEORGE'S HOSPITAL MEDICAL SCHOOL SGUL United Kingdom John Gulliver <jgul- [email protected]>