20221222 09385800 1.0 TRUE GEO_MASTER.GIS.LINZPlaceNames 1) Download updated version of data when needed.2) Remove all points which fall outside of the NZ coastline boundary.3) Keep all points which fall within this definition query: 'featType IN ('City', 'Island', 'Lake', 'Locality', 'Suburb', 'Town')'.4) Fix all 'Land District' records which are either NULL by changing the location in which they fall to the Regional Council area they are in, and remove all points which are an amalgamation of several Regional Council boundary areas.5) Create a new string field called 'portalSearch' which is 300 characters long.6) Populate this field with the expression: '[name] & " " & [landDistrict]'.7) Save changes and the process is complete.Checked for updates Feb 2017 - updated with data downloaded from LINZ. Place Names Names Places Search The Place Names Gazetteer contains official and unofficial place names under the jurisdiction of the New Zealand Geographic Board Ngā Pou Taunaha o Aotearoa (NZGB). Official place names are those that have been assigned, altered, adopted, approved, and validated under the NZGB Act 2008 or through other statutes that assign official names, for example, Treaty settlement legislation. Unofficial place names are those that have not been processed under the NZGB Act 2008 or through other relevant statutes. /9j/4AAQSkZJRgABAQEAAQABAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0a HBwgJC4nICIsIxwcKDcpLDAxNDQ0Hyc5PTgyPC4zNDL/2wBDAQkJCQwLDBgNDRgyIRwhMjIyMjIy MjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjIyMjL/wAARCADIASwDASIA AhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAAAgEDAwIEAwUFBAQA AAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkKFhcYGRolJicoKSo0NTY3 ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWGh4iJipKTlJWWl5iZmqKjpKWm p6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl5ufo6erx8vP09fb3+Pn6/8QAHwEA AwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREAAgECBAQDBAcFBAQAAQJ3AAECAxEEBSEx BhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYkNOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElK U1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOEhYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3 uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD3+iii gAooooAKKKKACiiigAooooAKKKKACo2gidtzRqW9SKkooAh+x2x/5YR/981yd/q0c1vLZXdlKIGH BiBQjB9a7KoLnyo7aSV4g4RCcY647UAcxHq1j5tsP7OlBUfI68npjPHU4qg1/ZRSykTSC7eNlDsp Z+WyAccYHpjPFW9S14bmt4B9llRFZXCBkxn6dajs9Rjlu3umlYCWPYkLxrtDd2Bxn16nvQBJbanp zWO2S2S6ljTEmFKZ6bjz71atfEWiqyyQwFCpEeQp4/zioGutRtpFijgt5ty5aTAIH1xViDWFSyea bTo2IAYJEgO7PpQB0F3dRWdnLdSnEUSl2PtWevibSyiO1wEDruXdxkVjzeJftbrbnTJ2QgiSI919 xVe6uLGO7eKfw/JKC2Iyit933oA6yz1O0v3dLeUOyDJHtVuuPs9dtbRppbfQrmI4wSAfm9BXU2dx 9rtI5/LaPeM7W6igCeiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAooooA KKKKACiiigAooooAKCARgjIoooAxtWhlQp9ltoyO+I1OT6HNZBudYjZ1/sK2bOPTA+nNdc5KxswG SASK5PVNSlu4TBdWd0iBgymJyhJB9VPSgCOytLua9ku1ihsCWWOUPIWV0AxgDJAOcVYl1K509lht bJZ0jcxsqryqjofxqrao08ErwKYArltlwxbcxOcjNTWE+sQfOsMcitzM6YOG/DvQBDqmoi+iVZNP dSGVsoSjsR2yMEitu71O4tb6OFbRXg8neZN43A+mM5rEk1mSTUo3ns5pJYQSmAR9enX8auSJLqdx YyxRRsznE8jko4QdMY69TxQA9/FMFu8kdxZv8pxuQZDH2qzB4mtpZIozbzRmQ4XcK1vslvtUGCI4 6ZQUv2eDIPkx5HQ7RxQBLRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUU UUAFFFFABRRRQAUUUUAFFFFABWHqmq3NlcyBQvlKgIBHLEkDr+NblYmq22ryXBewkXaRjY7YH1oA xDdyyWT2d5aS3YLl9zsRnJyAKckVz9n8vT4o9NdpCzIHIDluSenWplg8WK26Wa2wRjGeM560+/mt JGh+2zy+YgeIkDCFsjP5YoAlhj1O3Vn1K+RbaPJLKfmx25qC7hkn1Rp7S7nIlACkfd+gPY//AFqj tf7Mj8q6l1ZHBfJ54YelLNcS2Ab7S8+IJRMBBLjcrdARjkcGgAs5LiC7RbjVh8zD5GcnIB7fyrq4 riKZmWNwxXriuNl1Hw9cFGP2nKnaFK5xnqB+db+kxada2b3toZPKk5LOck44/pQBsUVRj1ewkXP2 hF9mOCKcdWsBKIzdxbyM43UAXKKjininUtE6uAcEg96koAKKhnuobbHnSBcgsM+gGTUQ1OyOMXMf PT5qALdFVf7Rs9wX7THk9Bu98VaoAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoooo AKKKKACiiigArG1W71S3vIzZW3m24X95xzn2rZrD1TSby6vRdW10Y2UYA/CgCi+pa6wYSaczDnaV QgioTLpsZhtb62BnaDe4kXLbjjg+9SR22sqg3a2jPzkEjtxVq4WK3sI7iUNeypDlljXd5hGOeOc0 AYBn0d2tyqWirDkXCNbnL9Pundx39a3YjA96Sd4eVN7h5QViA6YGOh/pTYLZ76SYHSYbeIorI8jZ LZzkFeoPSs7T5bK21RZLq+ilkEZSR5I2VtvYZzgAc9u9AF6e502ytv3brdJLuZZXYMFOO2O1Trqt sLWK0njBjePLGPgAZ9KPtWkxWskam2kiQnyYUYZ57fjVa7MtpprTzywwRysgVnTIQFgNmBz+PvQB JLpmh3E6TLO0BxtHzBQR0xTj4f0AyD98d2eB5oqO+ggjlhNzDcSW7HEK28ZYKdpyTgHHfr61m2th Z3ckD2kN7GrsVdbj93gevzDn6UAbJsZ9OiMWkbipbcpLZGe+aq3up+IbEL5wtAjOFDkbRk9uvWmv rkNpJFY2lyUMU7CYyoXLBTgjj17fSrd/qcesaWYrGcwvIrETEDMeP4sH60AQXM5ksom1u18x9su3 yhwF2jNUopvDhBC/bNxTnC547jpV2x17RbSySGXergZcFS3J4PP4VqWF3pWoSvFbRfMgBIaMr/Og DmkuPCr8RyXJ8sg8DoRyBXV6Xq9pqqyfZGciLAbcuO1WBY2oORbxjnP3e9SRW8MG7yo1TdycDrQB JRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFQXl0llaSXEgJRBk4 qesG88Saak0lndK2N+xsjI6Zz9KAOduf7DvQWS7uY2d2J2nruOT2q9ZxW9nEzaReS3E6JtSKUgLg d6sbNBv2kW3WM7EJUqrKR+lCaf8AZ4Vmh1CJJ2VcgovQD5sADnJxQBBbahOk4R7SQm5lJ3EnKg1d OnaLe3DBoYvlYiXexUsfzqtp11JcaoJXWIwqA0MjllYBvvZHTsKkn0qKaX7VcsfOJZ3+ztlV4HPN AEX2LShcTRQ6fCiqM28olzuk7cZ47dagx4gl3eaYWj3cR7kYDHQfnRpFglxdhhFcJA8ZaKZwOTkg jH65PrU02mtJPOPNkjdFPltGchscnp37c0AXL+x1G5WyZLm5ikEgMqW7RgKNpHO4cj6VnXP2fTJo 4NSNzfG2nMySvkFS2SPu4BAzjBp+iWktskep3d9OqPJ/q5ASe6jpVi9u7uAs0tl9rJZtuV7A8dPa gBj6hp94X+y6cGupc7DICAze9IL6S0l2No2JQD5mxWK7fbtzSzTzHTBfvH9jYKyBTHlUJIwTgE9q NuvNK7w3KTOibSFXAD+oyBmgDT0o22rWzzS6aICHxtkTBOO9akdvDE5eONVZupA61k6JFq6TSNqT ghlBAGODW3QAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABWVrdv d3EUItLoQMGy2TjcPStR2CIWboBk1zOp32kauIS1/wCUIMy9Ovb+lAEir4gQMzXVvtUDC4H88elV RqulytI9zYZkT5S2wZY9/wBagXTbZgX/AOElkw5Dcjp6DrVi7v0t8Ry2IuVXC8DLf7x+v9aAEsL2 xu1nDxGIpksUTGUz93P4iqRg0VbmcSX0ttMgJ2yfwg+mM1ZtLFbuOSWyeWOWM8QzSnawJzgj0HpU xsYdQ0+dm097a6SQp5rwqxYD+IDPINAEWFWMTSal9ogBjVY0iDYc55565qOK10yDz4ptVkEDqyup ZlKhhjgjmmofNufs1jORHckNAyW4AjZOuTn/AGhit5NM0nUot4VJ9vyMw55FAFc6a1slpeWl1MY7 dNoRpGZWTPLHPU4NVbTSk1HTxPYag5WRmDOuVz8xzx+lST32rxKv2CyZrf7qxsgBAHrTI9R11Jwo 04JAoG4ADqTzQBRltp4b8WU2oSJHCVbfI2Q3Tj171ZFlqSTTpDqIJlkbBlkOME5wvuKr3V/p11qE zywnzgA0jCENkAgY5P0q8mp6Jqk1uPsrGeMkxkxj5CRz/OgBPJ1lNyrdwTRJ91eSzY7cjmof7W8S IrINNBYjCscDB9aR4bj7f/Z0GoxxtboskkasQw469OlJCNUnhkdNXhYsQYiJDgDvQBp2OqavNqEc FzpvlxEEtLu6elb1QJcwhVV5kL4GeaX7Xb/89k496AJqKYkscpOx1bHXBp9ABRRRQAUUUUAFFFFA BRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAjKHQq3QjBrkprPw3HqM1rJEUkjAdj2Jrrqqzab Z3BJlt0ck5OR3oA5xz4add7BgpYc443dPzq41xdrLcm2ktRbLAPJdmyd3HUemM1pto+nMoBtIyAM Dis+68OC7lEj3G0ou2PaMYFAGbqenq1lFqVzcMZmRd8lsmWOccDnpUTQSC8VG1aVGAKooXCj2HPQ VcHhB8ANqM2OcgdDUlvpU007208A+xxqNs+drs4/pQBLqNwklhELW/PnQuGKwnmQDqv0NRWDs9kw sLMWsaThmJ+QSEYyfoelVrjSre1gc2lnNKW+9skyVPbjFU3tLSS7kiOrmLynywlGOfrQAPJqduiX jalH9maQoPMfqzcAfnWjYm9uprkpfQMyRFJYlTIEvUEtn0xxio7aRLe0a0h1a18zeuyR2DKeeRtz 1/Gnz22ox20csVzEjhiXlZxtk9OPyFAANVt7Wxt/tUMNzeb9koiXG04Jzj6VMniDQllXbGQ+RgiP oafpenXE1xJNqH2edHAIZP7351rjTrMZxbR8nJ4oAmWOJyZQo3OMFsckVhS+DNKmkLv5xJXb9/tX Q9KKAOfj8H6ZG4cGcsEKZL54NRP4J07ypFieZHf+ItnFdLRQBmaVoltpJZoWkZ3UBixzmtOiigAo oooAKKKKACiiigAooooAKKKKACiiigAooooAKKKKACo7iXyIHl27tozjOKkqnqlyLWxeQx+YOm3G c/lQBWXX7NrM3CsDhgrLnoT7/hSw+IdNm8sC4Ad8YU9eaxU1TTbfMTaUyKzgv6ZHfFRwXegSTBor FlYMFD85BoA62C5iuFJicMAcGpa5yfww1zcib7dKoxzsO3Pp04qzY6dHo0heW+kdW6LI2aANqqWp 2091bCOBwrbuSfSp1u7d0DrPGVPcMKkSSOT7jq30OaAOYurDXQuyO8ConCszAZ9KdPpuoNpP+mXS LKg5lUEke4wa2NUsJL6NFR1G05IbODx7VzV/p1/o2niWXViII8bv3bSEn6AE0AOhsNSwsC6z8yDY SYyCfQ1c+xWC2+3U4DJPHjfNtOJD2PFVpNNh1Fzv1MpcoMSMhwOPr0xRpunRGeQz3zvCAFUtICH9 xQA210/SZlu2ENtDJGxMJLH0BBIzzzVsRuNLtkmuIZHiJDeQpwWbPYk9jWLdx6XZS3MdxbXmxZMC XcMNwCMe3ateLxForWRhZGCoAWBHP1yKAM4WOkRyJI+pTIqlgYy3fnI/OtTSLnTNJjZft8svmsCp l/pWjHpOlXkSXAtUYOoYE5qV9E02QqWtVO3GOTxigDQooAwMUUAFFFFABRRRQAUUUUAFFFFABRRR QAUUUUAFFFFABRRRQAUUUUAFFFFADXdY13OwUeppnnW8nHmRtg9CR1pt5bLd2rQsxUHByO2Dn+lc y2l6SzyE6oVdixJBwQd3P60AdHK1iqtLJ5GOrEgGsa4vYzc3EFlbWoeNN0cjhQjMOoPcVXbRrGyl heS/3KueGY/MT24qFvD+kFmEeobXUZYFt3480AdHDfGPTlmu2h84JudImyM+grIuNX0nUlRpbloO CBuXO5Twfp3qrFpemrdRul258lxu+Y4XHNJeXUcc0inShtfP7woCDxQBSurSziktTaG4ms2R2Msb qqgjPGCQecY6VdjZ9BtotQghuJvtQw0TndsGMjpn2qK1uLO6kgWbTsCNGCyMvycg9vxxU1vdazC/ kWcSyIhAZQOEHbr7YoAmi8Wysnz6bOGVQWwpxnvj8abealbX8Nre/ZJ5L2FiVtRJsOO5IJAI+tXR q15Y2NzcamscIjcBGfgEHjPANZeqS6ZLeSveI29wAjo5GR/SgC1cWGlvfuocpJdsdzLIMMx7detU 444NHvJVXSr6SK3Koh+Vlk3HGRznj3ptnFpl3c28elOsc4lE2+WEPwOoGeh960JtK14XjTW+oJtZ ixRycDPYcdKAGXElzHcmSOzFzE5+VJVGFAGat6XIt7O6TaVDCoXn92OTnpTEsvEHnRu93BgSAuoJ +73HT610NACKqooVQFUdABjFLRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQ AUUUUAFRXE4trd5mBIQZIHU1LSMqupVgCD1BoAwh4s077QsDllZ1yOPbNYtxp+h3kVxcQC4uJG+Y xoeeWGcVNfSrDcSwHTYpH3AKwj7UlpcwS36RJpyR+ZuHKcAj3oAiMdlb3MdvDHGbbcfNklmKPGR3 TAOe/cVZi0Lw9MiyW7s8sowo84/N7VXlsY30xpPs9q2omUs8QnCqeeucVeuF0vS7iG6FvKyK334v mAY9OKAKM8+jr50F1b3CR20nzlWPJP8AMcVcur661YRf2LNtUKU2uxXcMdfwpl1/bKysyWsdxA2M MsXJ9Tj3GKdaahq21kXS2jKnacJ0oAjeHxSF/ePa+Wg4B6H3PHPrWpDq50yyi/taRfOYZBjHBGe1 XZbFbvS/IvlE+5CHU8bs9q5qa4t4I4YL3SiI4RtjhHzbAOB244oA259Y0W4jy91CX28ZGWAqDULK AzWl413HHCpy6yRBvMH17Vg/bdLiZmi0vG7HJbBH6f5FdJp2qw6jKLX7KVQKcE8jigDFlu72yuF2 aWjB+FkiUKcH0NXINa155UifRnQHrIWyAPyqzqOkX8l81xZTJGoRVRcYIIz3qtHpniIoVl1AHP8A dOKAOnUkqCeCRS1zD6Zr5WPbfbSgxnd1ofTPEAhOzUSXPXLcUAdPRXMPpOueV5a37YIHO7oe9bem R3cVrtvXDy56g54oAuUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUUARzu0c EjoMsqkgeprlx4qvo8+bpkpJ4UBSOanls/EMMUZtpUd2OJFJGAM9friniLXlnh3JE0YbMpJHT2oA fY66L55RNYSxLGmWJXO717Ux73SnQ2cbQC3I3lhMAQSeRikS+0u4nuDLekjfgBhtCY4IH61Dpthp +oecklnDFsciIpKH3r68Hj8aAKzWOmXWoQ21ihnilZjLIlwoMWPbHIq2bCPTUlg02Z3dQAyk7yPT 6UlxpMUMot9Ll+zXMiEedGpbYcjPPQfQ03UEu7XUGfTIo5pGwZnByQw9Rn3oAmtrzWlvo4GhzA3R mU5x7nsajkuNet1XyYTKzcNv5wc//qpq65rXX+zCTnb90/nVq61m5Nkv2eS2gujKoKXAP3MjPGQc 9aAIL+9t7q2jttQkmiZCJC8DYyyndtPHHSp08V6Q8aMGZiePuZrQjjsbqNUka3ldvmIRhyfzqT+y rDn/AEWPkY6UAOs7i11C2FxbhWjJIB2+nFWQqr0UD6CmQQRW0QihQIg6KKkoAKKKKACiiigAoooo AKKKKACiiigAooooAKKKKACiiigAooooAKKKKACiiigAoorO1PWLfSygnVzvBIIoAuNcQoxV5FUj AOT60v2iD/ntH/30K5HULnQNSld5r+SF3UM+N3yY7fXmoZLbQo1WRNZdSAGywYgj8qAOh1aC6vDF 9hmT5Mlvm9uOlZMd1rBmltxdxvJCMyJldyj3qW2ubLQ5p1a4kBZQVaXoR7Y5puoy6NcvHdwzRLdK wLFdyb88YYjr+NAFc2K3Vib1E03yxnEkxdQGzg559c1ZspbLTr2TFgyMsa4mjJKSlgD8vPSoLsav 5ChLRJLUgl43RNhGcj8O9S/23PZwL9uslW2YBYWQAgce3agCrczaZHfRzPHJFKknnDy5WOW98HHe pQvnx6rPDGjQTEfIrOJGYZyeDx+FW4dY0aO0BmjgDKoLFY+OfTinJqluqm/tUVYj8oUA5bHfA4oA owa5eI3mm0nk2HYsWMbT/Wq169hLciW8s7ppThXdTwuTV/TZ3vNbeQwzIlwu47yQEx0wOnNWr68u oLx0S1WePdgoUGMf3ie//wBagDLjvdB0+8iu4pJi652qAcHjFdDp2vWWpzGGBm3hdxBU8fjWM+o3 SDd/YEBUnAwgz9TWn4flmnSd7iyhtmDYUImCRQBtUUUUAFFFFABRRRQAUUUUAFFFFABRRRQAUUUU AFFFFABRRRQAUUUUAFFFFABRRRQBk6h4hs9NujbziTeF3ZAGCKo3HiLQ7xT5q+cEIIyoOT7UUUAQ Lc+GpZJQtuhwfmYIMZqG5vvD8k0auojjjXBRogQ/oAe3/wBeiigAvL/Q9QdA+TMV3ICv+rA9a1ot B02SzLxwqWlUHcfXsaKKAJNNhcWJi1C5iuJGDBlAwpXOBx9MCoYLa5ttPlW5FpOUYiCFUVQEzwv5 Y/KiigDLuGWE/wCmta2oeNikSW6uBgjBJPcDt70+HVUg021gWSzm/egSMB5e5e7bQMA+1FFAGjJr 8nnKbe0Mtp5SyGUHoCT2/CoYvFsM9wsMVpOSRncVwKKKAOiVtyK3qM0tFFABRRRQAUUUUAFFFFAB RRRQAUUUUAFFFFABRRRQAUUUUAFFFFABRRRQB//Z