Global Terrorism Database - USNA

文章推薦指數： 80 %
投票人數：10人

https://www.start.umd.edu/gtd/search/ This page works fine. ... but you can cut and paste from the results into Excel; Filter the results to ... GlobalTerrorismDatabase  https://www.start.umd.edu/gtd/.  Mayhaveproblemswithyourinstitutionalfirewallwithpartiallyrenders thepagebutwon'tallowittodoanything. Youwillhavetodealwith thefortressfirewalldefenders,ordownloadathome. Afterregister,candownloaddataasExcelfile haslat/long InExcel Changeallcommastosemicolons ChangeallUnknowntonothing SaveasCSV ImportintoDB Filteroutwithjusttheregion,dates,terrororganizationyouneed togetaworkablefile. https://www.start.umd.edu/gtd/search/Thispageworksfine.(10/24/2019) Noexportoptionfound(Wikipediasaysitcanbedone,andyoucan getitasaGeodatabase,whichmightbeimportablevia GDAL,and shouldhavecoordinates),butyoucancutandpastefromtheresults intoExcel Filtertheresultstojustwhatyouwant(country,group,time period). Ifyoucannotfindbulkdownload,makethefilteras restictiveaspossible. Changeto100itemsperpage Cutandpasteintoexcel.Repeattogetalltherecords. Changethefieldnamesto<=10characters SaveasCSV ImportintoDB Therearenocoordinates;useajoinfromanotherdatabase. Dependingonthecountryandthechallengesofnamesindifferent languagesandalphabets,thesuccessmyvary. GettheNGAgazetteer Join theterrorDBtothegazetteer,usingtheCITYandNAMEfields Addlat/longfromthejointotheterrordatabase GetOpenStreetMapforthearea Join theterrorDBtothePLACESfilefromOSM,usingtheCITYand NAMEfields Addlat/longfromthejointotheterrordatabase Lastrevision10/24/2019  

請為這篇文章評分？

延伸文章資訊