Locality Lookup

Brief description

Dataset to hold Locality Lookup tables used by My Account.

Important Notice: There is absolutely no guarantees as to its accuracy, but please feel free to let us know of any fixes or updates you see. Source data is community generated from https://github.com/matthewproctor/australianpostcodes

Full description

locality_postcodes_lookup - locality postcodes lookup\r\n\r\nbased off https://github.com/matthewproctor/australianpostcodes \r\n\r\nImportant Notice: There is absolutely no guarantees as to its accuracy, but please feel free to let us know of any fixes or updates you see. Source data is community generated from \r\nhttps://github.com/matthewproctor/australianpostcodes/blob/master/australian_postcodes.csv\r\n\r\nWhats different: \r\n\r\n1. ```id``` renamed to ```australianpostcodes_id```\r\n2. 4 new columns at the start: "```id```", "```state_code```", "```latitude```", "```longitude```"\r\n3. Add a new line for the ‘health check record' like below:\r\n\r\n **id** "```_ _HEALTH CHECK```"\r\n\r\n **state_code** "``` ```" (blank)\r\n\r\n **latitude** "```0```"\r\n\r\n **longitude** "```0```"\r\n\r\n **australianpostcodes_id** "``` ```" (blank)\r\n\r\n **postcode** "``` ```" (blank)\r\n\r\n **locality** "```Health Check```"\r\n\r\n **state** "``` ```" (blank)\r\n\r\n **long** "```149.119```"\r\n\r\n **lat** "```-35.2777```"\r\n\r\n\r\n4. Then in the fields below, use the following excel formula to build the new columns and drag down for all rows:\r\n \r\n **id** ```=UPPER(TEXTJOIN("_",FALSE,H2,F2,G2))``` (column join state, postcode, locality\r\n \r\n **state_code** ```=H2``` (column state)\r\n \r\n **latitude** ```=J2``` (column lat)\r\n \r\n **longitude** ```=I2``` (column long)\r\n\r\n\r\nAlternative locations for data:\r\n\r\n* https://www.abs.gov.au/statistics/standards/australian-statistical-geography-standard-asgs-edition-3/jul2021-jun2026/access-and-downloads/digital-boundary-files#downloads-for-gda2020-digital-boundary-files\r\n\r\n* https://placenames.fsdf.org.au/\r\n\r\n* (QLD Department Use only: https://github.com/qld-gov-au/PLSplus-QG-spec/ )