{"id":"https://openalex.org/W3090958030","doi":"https://doi.org/10.1145/3410886.3410913","title":"Data Wrangling for South African Smart City Crime Data","display_name":"Data Wrangling for South African Smart City Crime Data","publication_year":2020,"publication_date":"2020-09-12","ids":{"openalex":"https://openalex.org/W3090958030","doi":"https://doi.org/10.1145/3410886.3410913","mag":"3090958030"},"language":"en","primary_location":{"id":"doi:10.1145/3410886.3410913","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3410886.3410913","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Conference of the South African Institute of Computer Scientists and Information Technologists 2020","raw_type":"proceedings-article"},"type":"article","indexed_in":["crossref"],"open_access":{"is_oa":false,"oa_status":"closed","oa_url":null,"any_repository_has_fulltext":false},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5091277351","display_name":"A.K. Kritzinger","orcid":null},"institutions":[{"id":"https://openalex.org/I99712911","display_name":"Nelson Mandela University","ror":"https://ror.org/03r1jm528","country_code":"ZA","type":"education","lineage":["https://openalex.org/I99712911"]}],"countries":["ZA"],"is_corresponding":true,"raw_author_name":"A.K. Kritzinger","raw_affiliation_strings":["Nelson Mandela University, South Africa"],"affiliations":[{"raw_affiliation_string":"Nelson Mandela University, South Africa","institution_ids":["https://openalex.org/I99712911"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5001654034","display_name":"Andr\u00e9 P. Calitz","orcid":"https://orcid.org/0000-0002-2555-9041"},"institutions":[{"id":"https://openalex.org/I99712911","display_name":"Nelson Mandela University","ror":"https://ror.org/03r1jm528","country_code":"ZA","type":"education","lineage":["https://openalex.org/I99712911"]}],"countries":["ZA"],"is_corresponding":false,"raw_author_name":"A.P. Calitz","raw_affiliation_strings":["Nelson Mandela University, South Africa"],"affiliations":[{"raw_affiliation_string":"Nelson Mandela University, South Africa","institution_ids":["https://openalex.org/I99712911"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5085724956","display_name":"Lindsay Westraadt","orcid":"https://orcid.org/0000-0001-9173-1690"},"institutions":[{"id":"https://openalex.org/I99712911","display_name":"Nelson Mandela University","ror":"https://ror.org/03r1jm528","country_code":"ZA","type":"education","lineage":["https://openalex.org/I99712911"]}],"countries":["ZA"],"is_corresponding":false,"raw_author_name":"L. Westraadt","raw_affiliation_strings":["Nelson Mandela University, South Africa"],"affiliations":[{"raw_affiliation_string":"Nelson Mandela University, South Africa","institution_ids":["https://openalex.org/I99712911"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":3,"corresponding_author_ids":["https://openalex.org/A5091277351"],"corresponding_institution_ids":["https://openalex.org/I99712911"],"apc_list":null,"apc_paid":null,"fwci":0.0,"has_fulltext":false,"cited_by_count":0,"citation_normalized_percentile":{"value":0.10523897,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":null,"biblio":{"volume":null,"issue":null,"first_page":"198","last_page":"209"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T11980","display_name":"Human Mobility and Location-Based Analysis","score":0.9984999895095825,"subfield":{"id":"https://openalex.org/subfields/3313","display_name":"Transportation"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},"topics":[{"id":"https://openalex.org/T11980","display_name":"Human Mobility and Location-Based Analysis","score":0.9984999895095825,"subfield":{"id":"https://openalex.org/subfields/3313","display_name":"Transportation"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T11479","display_name":"Smart Cities and Technologies","score":0.9983000159263611,"subfield":{"id":"https://openalex.org/subfields/2214","display_name":"Media Technology"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T11344","display_name":"Traffic Prediction and Management Techniques","score":0.9807000160217285,"subfield":{"id":"https://openalex.org/subfields/2215","display_name":"Building and Construction"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/data-collection","display_name":"Data collection","score":0.6951372027397156},{"id":"https://openalex.org/keywords/data-sharing","display_name":"Data sharing","score":0.5988332629203796},{"id":"https://openalex.org/keywords/computer-security","display_name":"Computer security","score":0.5582221150398254},{"id":"https://openalex.org/keywords/smart-city","display_name":"Smart city","score":0.5484602451324463},{"id":"https://openalex.org/keywords/computer-science","display_name":"Computer science","score":0.5283975005149841},{"id":"https://openalex.org/keywords/data-access","display_name":"Data access","score":0.4298021197319031},{"id":"https://openalex.org/keywords/data-security","display_name":"Data security","score":0.42093685269355774},{"id":"https://openalex.org/keywords/data-science","display_name":"Data science","score":0.3823968172073364},{"id":"https://openalex.org/keywords/business","display_name":"Business","score":0.365872323513031},{"id":"https://openalex.org/keywords/database","display_name":"Database","score":0.20347356796264648},{"id":"https://openalex.org/keywords/internet-of-things","display_name":"Internet of Things","score":0.15193933248519897},{"id":"https://openalex.org/keywords/encryption","display_name":"Encryption","score":0.10927966237068176}],"concepts":[{"id":"https://openalex.org/C133462117","wikidata":"https://www.wikidata.org/wiki/Q4929239","display_name":"Data collection","level":2,"score":0.6951372027397156},{"id":"https://openalex.org/C2779965156","wikidata":"https://www.wikidata.org/wiki/Q5227350","display_name":"Data sharing","level":3,"score":0.5988332629203796},{"id":"https://openalex.org/C38652104","wikidata":"https://www.wikidata.org/wiki/Q3510521","display_name":"Computer security","level":1,"score":0.5582221150398254},{"id":"https://openalex.org/C2777103469","wikidata":"https://www.wikidata.org/wiki/Q1231558","display_name":"Smart city","level":3,"score":0.5484602451324463},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.5283975005149841},{"id":"https://openalex.org/C47487241","wikidata":"https://www.wikidata.org/wiki/Q5227230","display_name":"Data access","level":2,"score":0.4298021197319031},{"id":"https://openalex.org/C10511746","wikidata":"https://www.wikidata.org/wiki/Q899388","display_name":"Data security","level":3,"score":0.42093685269355774},{"id":"https://openalex.org/C2522767166","wikidata":"https://www.wikidata.org/wiki/Q2374463","display_name":"Data science","level":1,"score":0.3823968172073364},{"id":"https://openalex.org/C144133560","wikidata":"https://www.wikidata.org/wiki/Q4830453","display_name":"Business","level":0,"score":0.365872323513031},{"id":"https://openalex.org/C77088390","wikidata":"https://www.wikidata.org/wiki/Q8513","display_name":"Database","level":1,"score":0.20347356796264648},{"id":"https://openalex.org/C81860439","wikidata":"https://www.wikidata.org/wiki/Q251212","display_name":"Internet of Things","level":2,"score":0.15193933248519897},{"id":"https://openalex.org/C148730421","wikidata":"https://www.wikidata.org/wiki/Q141090","display_name":"Encryption","level":2,"score":0.10927966237068176},{"id":"https://openalex.org/C71924100","wikidata":"https://www.wikidata.org/wiki/Q11190","display_name":"Medicine","level":0,"score":0.0},{"id":"https://openalex.org/C105795698","wikidata":"https://www.wikidata.org/wiki/Q12483","display_name":"Statistics","level":1,"score":0.0},{"id":"https://openalex.org/C142724271","wikidata":"https://www.wikidata.org/wiki/Q7208","display_name":"Pathology","level":1,"score":0.0},{"id":"https://openalex.org/C204787440","wikidata":"https://www.wikidata.org/wiki/Q188504","display_name":"Alternative medicine","level":2,"score":0.0},{"id":"https://openalex.org/C33923547","wikidata":"https://www.wikidata.org/wiki/Q395","display_name":"Mathematics","level":0,"score":0.0}],"mesh":[],"locations_count":1,"locations":[{"id":"doi:10.1145/3410886.3410913","is_oa":false,"landing_page_url":"https://doi.org/10.1145/3410886.3410913","pdf_url":null,"source":null,"license":null,"license_id":null,"version":"publishedVersion","is_accepted":true,"is_published":true,"raw_source_name":"Conference of the South African Institute of Computer Scientists and Information Technologists 2020","raw_type":"proceedings-article"}],"best_oa_location":null,"sustainable_development_goals":[{"display_name":"Sustainable cities and communities","score":0.5799999833106995,"id":"https://metadata.un.org/sdg/11"}],"awards":[],"funders":[],"has_content":{"grobid_xml":false,"pdf":false},"content_urls":null,"referenced_works_count":18,"referenced_works":["https://openalex.org/W1495125968","https://openalex.org/W2026942921","https://openalex.org/W2109864102","https://openalex.org/W2541711883","https://openalex.org/W2792984028","https://openalex.org/W2895662010","https://openalex.org/W2965929528","https://openalex.org/W2992116349","https://openalex.org/W3014799374","https://openalex.org/W3024855577","https://openalex.org/W4200199159","https://openalex.org/W4247892241","https://openalex.org/W4299009390","https://openalex.org/W6697287427","https://openalex.org/W6749869310","https://openalex.org/W6808184414","https://openalex.org/W6825673231","https://openalex.org/W6886067055"],"related_works":["https://openalex.org/W1939054760","https://openalex.org/W2010532256","https://openalex.org/W2414507368","https://openalex.org/W2166798126","https://openalex.org/W4389950265","https://openalex.org/W2421443948","https://openalex.org/W2050921398","https://openalex.org/W4226034287","https://openalex.org/W2136472275","https://openalex.org/W2129000053"],"abstract_inverted_index":{"South":[0],"Africa":[1],"(S.A.)":[2],"is":[3,30,47,67,82,107],"currently":[4],"facing":[5],"economic":[6],"and":[7,33,63,91,109,123,147,154],"social":[8],"challenges":[9],"that":[10,120,177],"could":[11,178],"benefit":[12,179],"from":[13,54],"the":[14,31,40,48,70,86,95,112,127,130,139,158],"implementation":[15],"of":[16,39,69,132],"international":[17],"smart":[18,28,76,188],"city":[19,25,29],"guidelines.":[20],"Crucial":[21],"to":[22,35,51,59,156],"transforming":[23],"a":[24,27,55,163],"into":[26,187],"collection":[32],"access":[34,50],"reliable":[36],"data.":[37,135,159,170],"One":[38],"main":[41],"problems":[42],"experienced":[43],"by":[44,85],"S.A.":[45,87,168,180],"cities":[46,181],"limited":[49],"data,":[52],"resulting":[53],"traditionally":[56],"fragmented":[57],"approach":[58],"data":[60,66,81,106,116,128,144,149,164],"collection,":[61],"sharing":[62],"use.":[64],"Crime-related":[65],"one":[68],"most":[71],"commonly":[72],"collected":[73,84],"datasets":[74],"in":[75,126,141,182],"cities.":[77,189],"In":[78,136],"S.A.,":[79],"crime":[80,105,134,143,169],"predominantly":[83],"Police":[88],"Services":[89],"(SAPS)":[90],"security":[92],"companies.":[93],"While":[94],"latter":[96],"are":[97,145,152],"not":[98],"readily":[99],"available":[100,133],"for":[101,167],"public":[102],"use,":[103],"SAPS":[104,142],"consolidated":[108],"disseminated":[110],"at":[111],"national":[113],"level.":[114],"Initial":[115],"exploration,":[117],"however,":[118],"shows":[119],"temporal,":[121],"spatial":[122],"structural":[124],"inconsistencies":[125,140],"limits":[129],"usefulness":[131],"this":[137,172],"study,":[138],"summarised,":[146],"standard":[148],"wrangling":[150,165],"techniques":[151],"implemented":[153],"evaluated":[155],"clean":[157],"The":[160],"study":[161,173],"proposes":[162],"model":[166],"Furthermore,":[171],"will":[174],"further":[175],"developments":[176],"general":[183],"as":[184],"they":[185],"transform":[186]},"counts_by_year":[],"updated_date":"2025-11-06T03:46:38.306776","created_date":"2025-10-10T00:00:00"}