data-raw/das_to_ons.R

In Ottawa-Neighbourhood-Study/onsr: Ottawa Neighbourhood Study (ONS) Common Functions

# Single-Link Indicator from Ottawa Dissemination Areas (DAs) to
# Ottawa Neighbourhood Study (ONS) Neighbourhoods

# Created with the following code. NOTE that it uses a StatsCan datafile not included here.
# library(tidyverse)
# ons_shp <- onsr::get_ons_shp()
#
# ottawa_das <- sf::read_sf("../999. Often-used datafiles/lda_000b16a_e/lda_000b16a_e.shp") %>%
#   filter(stringr::str_detect(DAUID, "^3506")) %>%
#   sf::st_make_valid()
#
#
# da_to_ons_data <- ottawa_das %>%
#   sf::st_transform(crs = 4326) %>%
#   sf::st_join(ons_shp, largest = TRUE) %>%
#   select(DAUID, ONS_ID) %>%
#   sf::st_set_geometry(NULL)
#
# onsr::write_tribble(da_to_ons_data)

da_to_ons_data <- dplyr::tribble(
    ~DAUID, ~ONS_ID,
    "35060078", 913,
    "35060079", 913,
    "35060080", 913,
    "35060081", 913,
    "35060082", 913,
    "35060083", 913,
    "35060089", 926,
    "35060090", 913,
    "35060091", 913,
    "35060092", 913,
    "35060093", 913,
    "35060094", 913,
    "35060047", 76,
    "35061791", 949,
    "35061792", 908,
    "35061793", 949,
    "35061794", 934,
    "35061795", 934,
    "35061796", 934,
    "35061797", 934,
    "35061798", 934,
    "35061799", 949,
    "35061800", 908,
    "35061801", 934,
    "35061802", 934,
    "35061803", 934,
    "35061804", 907,
    "35061855", 951,
    "35061856", 951,
    "35061857", 951,
    "35061858", 944,
    "35061859", 944,
    "35061860", 944,
    "35061862", 958,
    "35061863", 958,
    "35061864", 958,
    "35061865", 958,
    "35061866", 958,
    "35061867", 958,
    "35061868", 958,
    "35061552", 28,
    "35061444", 925,
    "35061445", 925,
    "35061446", 925,
    "35061447", 925,
    "35061448", 925,
    "35061449", 925,
    "35061450", 925,
    "35061451", 925,
    "35061785", 949,
    "35061786", 949,
    "35061787", 949,
    "35061788", 908,
    "35061789", 908,
    "35061790", 908,
    "35061553", 915,
    "35061554", 926,
    "35061555", 75,
    "35061556", 75,
    "35061557", 945,
    "35061558", 945,
    "35061559", 945,
    "35061605", 82,
    "35061607", 82,
    "35061608", 82,
    "35061610", 82,
    "35061611", 923,
    "35061613", 923,
    "35061614", 28,
    "35061616", 11,
    "35061621", 923,
    "35061622", 923,
    "35061623", 82,
    "35061627", 83,
    "35061628", 82,
    "35061633", 903,
    "35061634", 903,
    "35061638", 958,
    "35060061", 943,
    "35060062", 943,
    "35060064", 943,
    "35060065", 943,
    "35060066", 943,
    "35060067", 943,
    "35060069", 939,
    "35060070", 939,
    "35060071", 939,
    "35060072", 939,
    "35060073", 939,
    "35060074", 939,
    "35060075", 939,
    "35060076", 939,
    "35060048", 76,
    "35060049", 76,
    "35060050", 76,
    "35060051", 76,
    "35060052", 943,
    "35060053", 943,
    "35060054", 943,
    "35060055", 943,
    "35060056", 943,
    "35060057", 943,
    "35060058", 943,
    "35060059", 943,
    "35061027", 949,
    "35061030", 940,
    "35061031", 940,
    "35061033", 903,
    "35061034", 903,
    "35061035", 903,
    "35061036", 903,
    "35061039", 903,
    "35061041", 903,
    "35061042", 903,
    "35061043", 903,
    "35060006", 916,
    "35060007", 936,
    "35060010", 920,
    "35060011", 920,
    "35060012", 920,
    "35060014", 920,
    "35060015", 943,
    "35060016", 943,
    "35060017", 943,
    "35060018", 943,
    "35060021", 943,
    "35060022", 943,
    "35060031", 920,
    "35060032", 920,
    "35060033", 920,
    "35060034", 920,
    "35060035", 920,
    "35060036", 920,
    "35060037", 920,
    "35060038", 920,
    "35060039", 920,
    "35061044", 903,
    "35061045", 903,
    "35061046", 903,
    "35061047", 903,
    "35061051", 903,
    "35061053", 903,
    "35061054", 87,
    "35061055", 87,
    "35060023", 920,
    "35060024", 920,
    "35060025", 920,
    "35060026", 920,
    "35060027", 920,
    "35060028", 920,
    "35060029", 920,
    "35060030", 920,
    "35060043", 920,
    "35060044", 920,
    "35060045", 920,
    "35061299", 76,
    "35061300", 11,
    "35061301", 31,
    "35061302", 23,
    "35061303", 23,
    "35061304", 951,
    "35061305", 951,
    "35061306", 951,
    "35061307", 912,
    "35061308", 912,
    "35061309", 920,
    "35060252", 908,
    "35060253", 908,
    "35060254", 908,
    "35060255", 908,
    "35060264", 949,
    "35060267", 949,
    "35061113", 918,
    "35061114", 936,
    "35061115", 936,
    "35061116", 936,
    "35061117", 936,
    "35061118", 936,
    "35061119", 955,
    "35060280", 82,
    "35060282", 82,
    "35060283", 83,
    "35060285", 83,
    "35060286", 83,
    "35060287", 83,
    "35060288", 83,
    "35060289", 83,
    "35060290", 83,
    "35060291", 83,
    "35060292", 83,
    "35060293", 83,
    "35060294", 83,
    "35060295", 923,
    "35061349", 86,
    "35061350", 86,
    "35061351", 86,
    "35061352", 86,
    "35061354", 86,
    "35061355", 86,
    "35061356", 86,
    "35061357", 86,
    "35061358", 917,
    "35061361", 940,
    "35061362", 940,
    "35061363", 940,
    "35061364", 940,
    "35061365", 940,
    "35061366", 940,
    "35060673", 930,
    "35060678", 951,
    "35060679", 951,
    "35060680", 951,
    "35060019", 943,
    "35060020", 943,
    "35060681", 951,
    "35060682", 951,
    "35060684", 951,
    "35060685", 951,
    "35060686", 951,
    "35061026", 949,
    "35061820", 90,
    "35061821", 90,
    "35061822", 90,
    "35061841", 914,
    "35061842", 914,
    "35061843", 909,
    "35061844", 909,
    "35061845", 909,
    "35061846", 909,
    "35061847", 909,
    "35061848", 920,
    "35061849", 920,
    "35061851", 951,
    "35061852", 951,
    "35061853", 944,
    "35061854", 951,
    "35061808", 907,
    "35061809", 907,
    "35061810", 907,
    "35061811", 907,
    "35061812", 907,
    "35061813", 907,
    "35061815", 907,
    "35061816", 907,
    "35061817", 907,
    "35061818", 907,
    "35061823", 90,
    "35061824", 90,
    "35061826", 947,
    "35061827", 947,
    "35061828", 919,
    "35061829", 947,
    "35061831", 16,
    "35061832", 16,
    "35061833", 16,
    "35061834", 16,
    "35061835", 16,
    "35061837", 927,
    "35061838", 927,
    "35060002", 916,
    "35060003", 916,
    "35060005", 916,
    "35061386", 926,
    "35061387", 901,
    "35061398", 937,
    "35061399", 937,
    "35061400", 937,
    "35061401", 937,
    "35061418", 945,
    "35061452", 925,
    "35061522", 45,
    "35061523", 45,
    "35061524", 45,
    "35061402", 937,
    "35061403", 937,
    "35061404", 937,
    "35061406", 937,
    "35061410", 937,
    "35061539", 38,
    "35061388", 901,
    "35061389", 901,
    "35061390", 901,
    "35061391", 926,
    "35061392", 937,
    "35061393", 937,
    "35061394", 937,
    "35061395", 937,
    "35061396", 937,
    "35061397", 937,
    "35061560", 945,
    "35061561", 945,
    "35061562", 945,
    "35061411", 945,
    "35061412", 945,
    "35061413", 945,
    "35061414", 945,
    "35061415", 945,
    "35061416", 945,
    "35061417", 945,
    "35061573", 928,
    "35061574", 902,
    "35061575", 902,
    "35061419", 945,
    "35061420", 945,
    "35061421", 937,
    "35061422", 937,
    "35061423", 937,
    "35061424", 937,
    "35061426", 926,
    "35061427", 945,
    "35061428", 945,
    "35061432", 946,
    "35061442", 925,
    "35061443", 925,
    "35061585", 13,
    "35061525", 97,
    "35061540", 951,
    "35061506", 35,
    "35061507", 922,
    "35061508", 922,
    "35061509", 949,
    "35061510", 949,
    "35061511", 949,
    "35061512", 949,
    "35061514", 82,
    "35061518", 82,
    "35061519", 82,
    "35061520", 97,
    "35061521", 45,
    "35061526", 97,
    "35061530", 90,
    "35061531", 90,
    "35061533", 38,
    "35061534", 38,
    "35061535", 38,
    "35061536", 38,
    "35061537", 38,
    "35061538", 38,
    "35061576", 929,
    "35061577", 929,
    "35061578", 928,
    "35061579", 45,
    "35061541", 951,
    "35061542", 951,
    "35061543", 951,
    "35061544", 928,
    "35061545", 928,
    "35061546", 13,
    "35061547", 13,
    "35061548", 28,
    "35061549", 28,
    "35061550", 28,
    "35061551", 28,
    "35061586", 13,
    "35061563", 945,
    "35061564", 945,
    "35061565", 912,
    "35061566", 912,
    "35061567", 912,
    "35061568", 928,
    "35061569", 928,
    "35061570", 928,
    "35061571", 928,
    "35061572", 928,
    "35061806", 907,
    "35061807", 907,
    "35061580", 45,
    "35061581", 952,
    "35061582", 952,
    "35061583", 952,
    "35061584", 952,
    "35061587", 13,
    "35061588", 13,
    "35061589", 13,
    "35061590", 13,
    "35061591", 13,
    "35061592", 13,
    "35061593", 13,
    "35061595", 937,
    "35061596", 937,
    "35061597", 937,
    "35061598", 937,
    "35061599", 937,
    "35061601", 937,
    "35061602", 24,
    "35061604", 24,
    "35061839", 927,
    "35061840", 927,
    "35060001", 916,
    "35060505", 108,
    "35060506", 99,
    "35060507", 99,
    "35060508", 99,
    "35060509", 99,
    "35060510", 99,
    "35060511", 99,
    "35060512", 99,
    "35060793", 937,
    "35060869", 97,
    "35060870", 97,
    "35060871", 97,
    "35060872", 97,
    "35060874", 49,
    "35060875", 49,
    "35060876", 49,
    "35061880", 942,
    "35061881", 942,
    "35061882", 942,
    "35061883", 942,
    "35061884", 942,
    "35061885", 942,
    "35061886", 942,
    "35060861", 52,
    "35060862", 52,
    "35060864", 45,
    "35060865", 45,
    "35060866", 45,
    "35060867", 45,
    "35060868", 97,
    "35061888", 942,
    "35061889", 942,
    "35061890", 942,
    "35061891", 942,
    "35061892", 942,
    "35061893", 936,
    "35061894", 903,
    "35061895", 942,
    "35060877", 48,
    "35060885", 52,
    "35060888", 52,
    "35060889", 52,
    "35060890", 52,
    "35060891", 932,
    "35060892", 932,
    "35060893", 932,
    "35060894", 932,
    "35060754", 924,
    "35060755", 13,
    "35060758", 13,
    "35060759", 13,
    "35060760", 13,
    "35060761", 13,
    "35060762", 13,
    "35060763", 13,
    "35061896", 936,
    "35061897", 942,
    "35061898", 942,
    "35061899", 942,
    "35061900", 942,
    "35061901", 942,
    "35060764", 13,
    "35060765", 13,
    "35060766", 13,
    "35060767", 13,
    "35060768", 13,
    "35060771", 13,
    "35061178", 106,
    "35061179", 910,
    "35061180", 910,
    "35061181", 910,
    "35061182", 931,
    "35061183", 931,
    "35061184", 931,
    "35061185", 931,
    "35061186", 931,
    "35061188", 910,
    "35061189", 910,
    "35061190", 910,
    "35060775", 13,
    "35060777", 938,
    "35060778", 938,
    "35060779", 938,
    "35060780", 938,
    "35060781", 938,
    "35060782", 938,
    "35060783", 938,
    "35060784", 938,
    "35060785", 938,
    "35060786", 938,
    "35060787", 938,
    "35060789", 938,
    "35060790", 938,
    "35060794", 937,
    "35060795", 937,
    "35060796", 937,
    "35060797", 937,
    "35060798", 937,
    "35060799", 937,
    "35060800", 937,
    "35060801", 937,
    "35061191", 910,
    "35060119", 915,
    "35060120", 915,
    "35060121", 915,
    "35060122", 915,
    "35060123", 915,
    "35060792", 937,
    "35061192", 106,
    "35061193", 106,
    "35061194", 106,
    "35061195", 106,
    "35061196", 906,
    "35061197", 906,
    "35061198", 106,
    "35061201", 106,
    "35061202", 106,
    "35061203", 106,
    "35061204", 106,
    "35061208", 12,
    "35061209", 12,
    "35061210", 12,
    "35061213", 108,
    "35060802", 937,
    "35060815", 938,
    "35060816", 938,
    "35060817", 938,
    "35060818", 938,
    "35060819", 938,
    "35060820", 938,
    "35061137", 67,
    "35061138", 67,
    "35061461", 66,
    "35061214", 108,
    "35061122", 955,
    "35061123", 936,
    "35061488", 927,
    "35061493", 937,
    "35061494", 937,
    "35061495", 937,
    "35061125", 70,
    "35061126", 70,
    "35061127", 70,
    "35061124", 936,
    "35060108", 915,
    "35060109", 915,
    "35060110", 915,
    "35060111", 915,
    "35060112", 915,
    "35060116", 915,
    "35060117", 915,
    "35061128", 70,
    "35061129", 70,
    "35061130", 70,
    "35061131", 85,
    "35060124", 915,
    "35060125", 76,
    "35060126", 915,
    "35060127", 939,
    "35060128", 939,
    "35060129", 939,
    "35060132", 915,
    "35061132", 70,
    "35061133", 85,
    "35060118", 915,
    "35060533", 28,
    "35060534", 16,
    "35060535", 16,
    "35061453", 66,
    "35061454", 66,
    "35061455", 66,
    "35061456", 66,
    "35061457", 66,
    "35061458", 66,
    "35060133", 915,
    "35060134", 926,
    "35060561", 49,
    "35060562", 48,
    "35060563", 48,
    "35060564", 48,
    "35060565", 48,
    "35061462", 81,
    "35061463", 81,
    "35061464", 81,
    "35061465", 81,
    "35061134", 85,
    "35061135", 67,
    "35061136", 67,
    "35060135", 93,
    "35060137", 93,
    "35060138", 93,
    "35060139", 93,
    "35060140", 93,
    "35060141", 93,
    "35060143", 93,
    "35061459", 66,
    "35061460", 66,
    "35061639", 958,
    "35061482", 926,
    "35061483", 918,
    "35061484", 921,
    "35061466", 81,
    "35061467", 81,
    "35061468", 81,
    "35061496", 911,
    "35061497", 30,
    "35061498", 30,
    "35061499", 30,
    "35061500", 30,
    "35060144", 93,
    "35060145", 93,
    "35060146", 93,
    "35060147", 93,
    "35060148", 3,
    "35061469", 81,
    "35061470", 81,
    "35061471", 81,
    "35061472", 81,
    "35061486", 926,
    "35061487", 927,
    "35061371", 35,
    "35061737", 946,
    "35061738", 946,
    "35061739", 946,
    "35061740", 946,
    "35061376", 35,
    "35061377", 35,
    "35061378", 911,
    "35061379", 911,
    "35061380", 911,
    "35061473", 81,
    "35061474", 64,
    "35061475", 64,
    "35061501", 30,
    "35061502", 30,
    "35061372", 29,
    "35061373", 35,
    "35061374", 35,
    "35061375", 35,
    "35060458", 31,
    "35060538", 16,
    "35060539", 16,
    "35060544", 905,
    "35060547", 927,
    "35060551", 927,
    "35060553", 49,
    "35060554", 49,
    "35061381", 911,
    "35060480", 54,
    "35060481", 54,
    "35060567", 48,
    "35060568", 927,
    "35060569", 927,
    "35060573", 51,
    "35060574", 65,
    "35060575", 65,
    "35061503", 911,
    "35061504", 911,
    "35061505", 35,
    "35061756", 946,
    "35061382", 911,
    "35061383", 911,
    "35060555", 49,
    "35060556", 49,
    "35060557", 49,
    "35060558", 49,
    "35060559", 49,
    "35060560", 49,
    "35061640", 958,
    "35061643", 106,
    "35061645", 106,
    "35061646", 106,
    "35061651", 923,
    "35061653", 923,
    "35061654", 923,
    "35060576", 65,
    "35061659", 909,
    "35061660", 909,
    "35061661", 909,
    "35061384", 35,
    "35061385", 35,
    "35060498", 108,
    "35060577", 65,
    "35060578", 65,
    "35061657", 32,
    "35061658", 32,
    "35061869", 55,
    "35061870", 55,
    "35061871", 55,
    "35061872", 55,
    "35061708", 24,
    "35061709", 24,
    "35061710", 24,
    "35061711", 24,
    "35061712", 24,
    "35061713", 24,
    "35061714", 24,
    "35061715", 24,
    "35061716", 24,
    "35061717", 24,
    "35061718", 24,
    "35061722", 954,
    "35061662", 909,
    "35061663", 909,
    "35061887", 942,
    "35061741", 946,
    "35061742", 946,
    "35061743", 946,
    "35061744", 946,
    "35061745", 946,
    "35061746", 946,
    "35061747", 946,
    "35061749", 931,
    "35061750", 958,
    "35061751", 931,
    "35060579", 65,
    "35060580", 99,
    "35060582", 100,
    "35060585", 100,
    "35060588", 100,
    "35060590", 12,
    "35060592", 54,
    "35060593", 88,
    "35060594", 54,
    "35060595", 88,
    "35061664", 917,
    "35061667", 917,
    "35061723", 954,
    "35061724", 940,
    "35061725", 954,
    "35061726", 940,
    "35061727", 954,
    "35061728", 940,
    "35061729", 954,
    "35061730", 954,
    "35061732", 926,
    "35061733", 946,
    "35061736", 946,
    "35060459", 31,
    "35060460", 31,
    "35060461", 31,
    "35060462", 31,
    "35060463", 31,
    "35060464", 31,
    "35060465", 31,
    "35060466", 31,
    "35060467", 31,
    "35061752", 958,
    "35061753", 931,
    "35061754", 958,
    "35061755", 958,
    "35060482", 54,
    "35060483", 12,
    "35060484", 12,
    "35060485", 23,
    "35060486", 23,
    "35060488", 23,
    "35060491", 23,
    "35060492", 23,
    "35060493", 23,
    "35060494", 23,
    "35061668", 86,
    "35061670", 914,
    "35061671", 914,
    "35061672", 914,
    "35061673", 914,
    "35061674", 914,
    "35061677", 952,
    "35061760", 957,
    "35061761", 957,
    "35061762", 957,
    "35061763", 957,
    "35061764", 923,
    "35061765", 923,
    "35060468", 31,
    "35060469", 31,
    "35060471", 11,
    "35060474", 11,
    "35060475", 54,
    "35060476", 54,
    "35060479", 54,
    "35060753", 924,
    "35060838", 64,
    "35060840", 64,
    "35060495", 108,
    "35060496", 108,
    "35060497", 108,
    "35060773", 13,
    "35060774", 13,
    "35060843", 70,
    "35060844", 70,
    "35060845", 64,
    "35060860", 52,
    "35061766", 957,
    "35061767", 957,
    "35061768", 957,
    "35061769", 957,
    "35061770", 957,
    "35061771", 957,
    "35061772", 957,
    "35061773", 957,
    "35061774", 957,
    "35061778", 949,
    "35061779", 949,
    "35061780", 949,
    "35061781", 949,
    "35061782", 949,
    "35061783", 949,
    "35061784", 949,
    "35060499", 108,
    "35060500", 108,
    "35060501", 108,
    "35060502", 108,
    "35060503", 108,
    "35060504", 108,
    "35060841", 64,
    "35060842", 64,
    "35061161", 922,
    "35061171", 906,
    "35061174", 910,
    "35061175", 910,
    "35061873", 55,
    "35061874", 48,
    "35061875", 48,
    "35061877", 942,
    "35061878", 942,
    "35060914", 919,
    "35060915", 919,
    "35060916", 919,
    "35060917", 919,
    "35060918", 919,
    "35061241", 904,
    "35060977", 940,
    "35060978", 940,
    "35060979", 940,
    "35060984", 940,
    "35060985", 940,
    "35060986", 940,
    "35060987", 940,
    "35060988", 940,
    "35060989", 940,
    "35060990", 940,
    "35060744", 902,
    "35060745", 902,
    "35060746", 902,
    "35060747", 928,
    "35060748", 902,
    "35060749", 902,
    "35060750", 929,
    "35060751", 924,
    "35060752", 924,
    "35060945", 45,
    "35060953", 50,
    "35060991", 940,
    "35061001", 912,
    "35061018", 953,
    "35061019", 953,
    "35061020", 934,
    "35061298", 76,
    "35061140", 67,
    "35061120", 955,
    "35061121", 918,
    "35061149", 944,
    "35061150", 938,
    "35061151", 938,
    "35061152", 938,
    "35061153", 938,
    "35061154", 938,
    "35061155", 938,
    "35061156", 938,
    "35061157", 938,
    "35061158", 938,
    "35061159", 938,
    "35060923", 46,
    "35060924", 917,
    "35060925", 46,
    "35060926", 46,
    "35060929", 46,
    "35060930", 919,
    "35060931", 919,
    "35060934", 919,
    "35060935", 919,
    "35060936", 919,
    "35060937", 919,
    "35060938", 917,
    "35061266", 915,
    "35061267", 7,
    "35060954", 50,
    "35060955", 50,
    "35060956", 50,
    "35060957", 917,
    "35060961", 919,
    "35060968", 919,
    "35060970", 947,
    "35060972", 917,
    "35061282", 932,
    "35061284", 903,
    "35061285", 106,
    "35061286", 939,
    "35061090", 910,
    "35061091", 910,
    "35061141", 67,
    "35061142", 944,
    "35061143", 944,
    "35061144", 944,
    "35061145", 944,
    "35061146", 944,
    "35060095", 913,
    "35061215", 108,
    "35061222", 949,
    "35061225", 949,
    "35061227", 93,
    "35061228", 93,
    "35061160", 922,
    "35060106", 939,
    "35060107", 913,
    "35061242", 904,
    "35061243", 904,
    "35061247", 50,
    "35061248", 49,
    "35061249", 49,
    "35061250", 932,
    "35061251", 919,
    "35061252", 16,
    "35061253", 28,
    "35061254", 88,
    "35061256", 906,
    "35061056", 932,
    "35061057", 932,
    "35061067", 28,
    "35061069", 18,
    "35061070", 18,
    "35061071", 18,
    "35061072", 18,
    "35061073", 18,
    "35061074", 18,
    "35061075", 18,
    "35061076", 18,
    "35061077", 18,
    "35061078", 18,
    "35061079", 18,
    "35061080", 18,
    "35061081", 18,
    "35061082", 18,
    "35061083", 18,
    "35061084", 18,
    "35061085", 18,
    "35061092", 910,
    "35061094", 11,
    "35061097", 950,
    "35061098", 950,
    "35061100", 950,
    "35061101", 950,
    "35061102", 905,
    "35061103", 950,
    "35061104", 950,
    "35061105", 905,
    "35061106", 905,
    "35061107", 905,
    "35061108", 941,
    "35061338", 3,
    "35061229", 904,
    "35061230", 904,
    "35061231", 904,
    "35061232", 904,
    "35061233", 904,
    "35061234", 904,
    "35061235", 904,
    "35061236", 904,
    "35061237", 904,
    "35061238", 904,
    "35061239", 904,
    "35061240", 904,
    "35061257", 931,
    "35061261", 933,
    "35061263", 953,
    "35061264", 52,
    "35060171", 912,
    "35060172", 912,
    "35061476", 64,
    "35060096", 913,
    "35060097", 913,
    "35061310", 920,
    "35061311", 909,
    "35061268", 12,
    "35061269", 23,
    "35061270", 938,
    "35061271", 929,
    "35061272", 13,
    "35061273", 943,
    "35061279", 931,
    "35061280", 11,
    "35061281", 106,
    "35060202", 953,
    "35060205", 953,
    "35060206", 953,
    "35061287", 54,
    "35061288", 100,
    "35061289", 106,
    "35061290", 929,
    "35061291", 919,
    "35061292", 919,
    "35061293", 917,
    "35061294", 108,
    "35061295", 46,
    "35061296", 920,
    "35061297", 920,
    "35060224", 948,
    "35060225", 948,
    "35060098", 913,
    "35060099", 913,
    "35060100", 939,
    "35060101", 939,
    "35060102", 939,
    "35060103", 939,
    "35060104", 939,
    "35060105", 939,
    "35060513", 31,
    "35060514", 905,
    "35060149", 3,
    "35060150", 3,
    "35060151", 3,
    "35060152", 3,
    "35060153", 93,
    "35060154", 93,
    "35061312", 909,
    "35061313", 920,
    "35061314", 920,
    "35061315", 52,
    "35061316", 52,
    "35061317", 52,
    "35061318", 52,
    "35061319", 932,
    "35061320", 932,
    "35061321", 46,
    "35061322", 46,
    "35061323", 100,
    "35061325", 75,
    "35061326", 75,
    "35061327", 75,
    "35061328", 75,
    "35061329", 75,
    "35061331", 75,
    "35061332", 75,
    "35061333", 75,
    "35061334", 3,
    "35061335", 3,
    "35061336", 3,
    "35061337", 3,
    "35060343", 24,
    "35060345", 24,
    "35060346", 24,
    "35061339", 956,
    "35061340", 912,
    "35061341", 956,
    "35061342", 956,
    "35061343", 933,
    "35061344", 933,
    "35061345", 933,
    "35061346", 933,
    "35061347", 933,
    "35061348", 86,
    "35060389", 47,
    "35060390", 47,
    "35060391", 47,
    "35060155", 93,
    "35060156", 93,
    "35060157", 93,
    "35060159", 3,
    "35060163", 3,
    "35060164", 3,
    "35060165", 912,
    "35060166", 912,
    "35060167", 912,
    "35060168", 912,
    "35060170", 912,
    "35061477", 66,
    "35061478", 918,
    "35061479", 918,
    "35061480", 918,
    "35061481", 918,
    "35061679", 926,
    "35061367", 29,
    "35061368", 29,
    "35061369", 29,
    "35060173", 912,
    "35060207", 953,
    "35060208", 953,
    "35061370", 29,
    "35060434", 931,
    "35060435", 931,
    "35060436", 931,
    "35060437", 931,
    "35060438", 931,
    "35060439", 931,
    "35060440", 931,
    "35060443", 910,
    "35060515", 905,
    "35060516", 905,
    "35060517", 905,
    "35060518", 905,
    "35060519", 905,
    "35060520", 905,
    "35060521", 905,
    "35060522", 905,
    "35060178", 940,
    "35060179", 940,
    "35060180", 940,
    "35060181", 940,
    "35060182", 940,
    "35060183", 954,
    "35060184", 940,
    "35060185", 954,
    "35060186", 954,
    "35060187", 954,
    "35060188", 954,
    "35060189", 954,
    "35060192", 953,
    "35060194", 953,
    "35060195", 953,
    "35060196", 953,
    "35060197", 953,
    "35060198", 953,
    "35060199", 953,
    "35060200", 953,
    "35060201", 953,
    "35060613", 7,
    "35060296", 923,
    "35060297", 923,
    "35060209", 5,
    "35060210", 953,
    "35060211", 948,
    "35060213", 933,
    "35060219", 933,
    "35060220", 933,
    "35060221", 933,
    "35060222", 948,
    "35060223", 948,
    "35060645", 906,
    "35060646", 906,
    "35060347", 24,
    "35060348", 957,
    "35060353", 957,
    "35060226", 935,
    "35060227", 935,
    "35060228", 935,
    "35060229", 935,
    "35060230", 935,
    "35060231", 935,
    "35060232", 935,
    "35060233", 935,
    "35060234", 935,
    "35060236", 935,
    "35060237", 940,
    "35060243", 933,
    "35060246", 934,
    "35060249", 908,
    "35060251", 908,
    "35060668", 911,
    "35060392", 47,
    "35060393", 47,
    "35060394", 47,
    "35060395", 47,
    "35060523", 905,
    "35060524", 941,
    "35060525", 941,
    "35060526", 941,
    "35060527", 950,
    "35060529", 950,
    "35060530", 950,
    "35060531", 28,
    "35060597", 88,
    "35060598", 88,
    "35060599", 88,
    "35060600", 88,
    "35060602", 12,
    "35060603", 12,
    "35060604", 6,
    "35060605", 6,
    "35060606", 6,
    "35060298", 923,
    "35060300", 923,
    "35060301", 923,
    "35060305", 923,
    "35060306", 923,
    "35060307", 923,
    "35060308", 923,
    "35060310", 923,
    "35060312", 923,
    "35060313", 24,
    "35060314", 24,
    "35060315", 24,
    "35060324", 24,
    "35060325", 24,
    "35060327", 923,
    "35060329", 24,
    "35060330", 24,
    "35060331", 24,
    "35060332", 24,
    "35060333", 24,
    "35060334", 24,
    "35060336", 24,
    "35060337", 24,
    "35060338", 24,
    "35060339", 24,
    "35060354", 957,
    "35060360", 957,
    "35060361", 957,
    "35060364", 923,
    "35060366", 923,
    "35060367", 24,
    "35060368", 24,
    "35060371", 47,
    "35060373", 28,
    "35060375", 28,
    "35060379", 55,
    "35060380", 47,
    "35060381", 47,
    "35060382", 47,
    "35060383", 47,
    "35060384", 47,
    "35060385", 47,
    "35060386", 47,
    "35060387", 47,
    "35060388", 47,
    "35060708", 924,
    "35060709", 924,
    "35060396", 47,
    "35060397", 47,
    "35060399", 60,
    "35060400", 957,
    "35060401", 24,
    "35060402", 24,
    "35060403", 24,
    "35060404", 24,
    "35060405", 24,
    "35060406", 24,
    "35060407", 24,
    "35060408", 24,
    "35060412", 55,
    "35060413", 55,
    "35060417", 958,
    "35060419", 958,
    "35060725", 929,
    "35060726", 929,
    "35060607", 6,
    "35060608", 6,
    "35060609", 6,
    "35060610", 6,
    "35060611", 6,
    "35060612", 6,
    "35061680", 944,
    "35061683", 28,
    "35061690", 28,
    "35061691", 28,
    "35061692", 28,
    "35061693", 28,
    "35061695", 903,
    "35061696", 903,
    "35061699", 903,
    "35061700", 903,
    "35061701", 903,
    "35061702", 932,
    "35061703", 24,
    "35061705", 24,
    "35060444", 910,
    "35060445", 910,
    "35060446", 910,
    "35060447", 11,
    "35060448", 11,
    "35060449", 11,
    "35060450", 11,
    "35060451", 11,
    "35060452", 11,
    "35060455", 31,
    "35060456", 31,
    "35060457", 31,
    "35060741", 902,
    "35060616", 7,
    "35060647", 906,
    "35060648", 901,
    "35060669", 930,
    "35060742", 902,
    "35060743", 902,
    "35060823", 48,
    "35060833", 70,
    "35060834", 64,
    "35060835", 64,
    "35060836", 64,
    "35060617", 7,
    "35060618", 7,
    "35060619", 7,
    "35060620", 7,
    "35060622", 6,
    "35060623", 926,
    "35060624", 100,
    "35060625", 100,
    "35060634", 106,
    "35060638", 106,
    "35060641", 906,
    "35060642", 906,
    "35060643", 906,
    "35060644", 906,
    "35060921", 46,
    "35060922", 46,
    "35060687", 951,
    "35060649", 901,
    "35060653", 32,
    "35060654", 32,
    "35060655", 32,
    "35060656", 32,
    "35060657", 32,
    "35060662", 907,
    "35060663", 907,
    "35060939", 50,
    "35060940", 50,
    "35060941", 50,
    "35060942", 50,
    "35060944", 45,
    "35060710", 924,
    "35060711", 951,
    "35060670", 930,
    "35060671", 930,
    "35060672", 922,
    "35060973", 917,
    "35060974", 940,
    "35060975", 940,
    "35060976", 940,
    "35060728", 929,
    "35060729", 929,
    "35060731", 929,
    "35060837", 64,
    "35061147", 944,
    "35061148", 944,
    "35060895", 932,
    "35060898", 932,
    "35060899", 932,
    "35060902", 932,
    "35060903", 87,
    "35060904", 87,
    "35060905", 87,
    "35060906", 87,
    "35060907", 87,
    "35060908", 87,
    "35060909", 87,
    "35060910", 87,
    "35060911", 87,
    "35060912", 919,
    "35060913", 919,
    "35060688", 951,
    "35060689", 951,
    "35060690", 951,
    "35060695", 951,
    "35060696", 951,
    "35060697", 951,
    "35060698", 951,
    "35060700", 951,
    "35060701", 924,
    "35060702", 924,
    "35060703", 924,
    "35060704", 924,
    "35060706", 924,
    "35060707", 924,
    "35060712", 929,
    "35060713", 929,
    "35060717", 929,
    "35060718", 929,
    "35060719", 929,
    "35060720", 929,
    "35060721", 929,
    "35060722", 929,
    "35060723", 929,
    "35060724", 929,
    "35061086", 18,
    "35061087", 18,
    "35061089", 55,
    "35060734", 928,
    "35060735", 928,
    "35060736", 928,
    "35060737", 928,
    "35060738", 902,
    "35060739", 902,
    "35060740", 902,
  )


# fix a few obvious mistakes, e.g. putting Vanier North DAs in cemeteries
da_to_ons_data <- dplyr::mutate(da_to_ons_data,
                                ONS_ID = dplyr::case_when(
                                    DAUID %in% c("35060209") ~ 953,
                                    TRUE ~ ONS_ID)
)


usethis::use_data(da_to_ons_data, overwrite = TRUE)