text: 
  -- admin_bdys.nz_locality
  
  INSERT INTO admin_bdys.nz_locality (id, parent_id, suburb_4th, suburb_3rd, suburb_2nd, suburb_1st, type_order, type, city_id, city_name, has_addressroad, start_date, end_date, majorlocality_id, majorlocality_name, shape) VALUES (102, 0, 'Aro Valley', NULL, NULL, NULL, 0, 'SUBURB', 1001, 'Wellington City', 'Y', '2019-05-30 14:49:52.927447', NULL, 1001, 'Wellington', '01060000204710000001000000010300000001000000050000008A9CA5145D086640B565D732A00D44C087B846FD70086640CB1EB8BD9E0D44C0D6888AC17108664030276043DA0D44C0930247F25D086640912DC3D7DB0D44C08A9CA5145D086640B565D732A00D44C0');
  INSERT INTO admin_bdys.nz_locality (id, parent_id, suburb_4th, suburb_3rd, suburb_2nd, suburb_1st, type_order, type, city_id, city_name, has_addressroad, start_date, end_date, majorlocality_id, majorlocality_name, shape) VALUES (103, 0, 'Newtown', NULL, NULL, NULL, 0, 'SUBURB', 1001, 'Wellington City', 'Y', '2019-05-30 14:49:52.927447', NULL, 1001, 'Wellington', '010600002047100000010000000103000000010000000500000087B846FD70086640CB1EB8BD9E0D44C06223B9B28E086640E47221909C0D44C0EBBE8C988F08664030056FE1D70D44C0D6888AC17108664030276043DA0D44C087B846FD70086640CB1EB8BD9E0D44C0');
  INSERT INTO admin_bdys.nz_locality (id, parent_id, suburb_4th, suburb_3rd, suburb_2nd, suburb_1st, type_order, type, city_id, city_name, has_addressroad, start_date, end_date, majorlocality_id, majorlocality_name, shape) VALUES (105, 0, 'Napier Airport', NULL, NULL, NULL, 0, 'SUBURB', 1003, 'Napier', 'Y', '2019-05-30 14:49:52.927447', NULL, 1003, 'Napier', '0106000020471000000100000001030000000100000005000000930247F25D086640912DC3D7DB0D44C0EBBE8C988F08664030056FE1D70D44C0C9B675D28F086640A81D6808EB0D44C0B5A8841D5E0866406B4D92A4F00D44C0930247F25D086640912DC3D7DB0D44C0');
  INSERT INTO admin_bdys.nz_locality (id, parent_id, suburb_4th, suburb_3rd, suburb_2nd, suburb_1st, type_order, type, city_id, city_name, has_addressroad, start_date, end_date, majorlocality_id, majorlocality_name, shape) VALUES (101, 0, 'Kelburn North', NULL, NULL, NULL, 0, 'SUBURB', 1001, 'Wellington City', 'Y', '2019-05-30 14:49:52.927447', NULL, 1001, 'Wellington', '0106000020471000000100000001030000000100000006000000F8667C865B0866405737D808350D44C00CC875098D0866404D1F72CA2E0D44C06223B9B28E086640E47221909C0D44C087B846FD70086640CB1EB8BD9E0D44C08A9CA5145D086640B565D732A00D44C0F8667C865B0866405737D808350D44C0');
  INSERT INTO admin_bdys.nz_locality (id, parent_id, suburb_4th, suburb_3rd, suburb_2nd, suburb_1st, type_order, type, city_id, city_name, has_addressroad, start_date, end_date, majorlocality_id, majorlocality_name, shape) VALUES (107, 0, NULL, 'Test Island', NULL, NULL, 0, 'ISLAND', 1001, 'Wellington City', 'Y', '2020-01-31 09:08:23', NULL, 1001, 'Wellington', '0106000020471000000100000001030000000100000005000000E08206CF85086640E8EED125EF0C44C00AD8D603870866409659F7231C0D44C0085C683A7E0866401551AE561D0D44C09C6FE6867D08664014EB39ABF00C44C0E08206CF85086640E8EED125EF0C44C0');
  INSERT INTO admin_bdys.nz_locality (id, parent_id, suburb_4th, suburb_3rd, suburb_2nd, suburb_1st, type_order, type, city_id, city_name, has_addressroad, start_date, end_date, majorlocality_id, majorlocality_name, shape) VALUES (108, 0, NULL, 'New Island', NULL, NULL, 0, 'ISLAND', 1001, 'Wellington City', 'Y', '2020-01-31 09:08:23', NULL, 1001, 'Wellington', '0106000020471000000100000001030000000100000005000000EC257D466A086640BE1CED66010D44C0936A23BB6A086640595CCA881F0D44C0460318055D086640BDD7B9A9210D44C01CC1865D5C08664031E282F8020D44C0EC257D466A086640BE1CED66010D44C0');
  
  -- admin_bdys.territorial_authority
  
  INSERT INTO admin_bdys.territorial_authority (ogc_fid, name, shape) VALUES (10003, 'Hawkes Bay', '0106000020471000000100000001030000000100000005000000FA3A70EA560866403B9233C8DC0D44C006D00819970866404939B889D50D44C0D826AD6C9708664097043F33150E44C08CDA18AB5708664022B663651C0E44C0FA3A70EA560866403B9233C8DC0D44C0');
  INSERT INTO admin_bdys.territorial_authority (ogc_fid, name, shape) VALUES (10001, 'Wellington', '01060000204710000001000000010300000001000000070000004E1C697654086640D00D7EAB280D44C0E25E455058086640691FC7A5CC0C44C01C960C498E086640D08F5162C60C44C0FFA97FD0940866403F9D6B68210D44C006D00819970866404939B889D50D44C0FA3A70EA560866403B9233C8DC0D44C04E1C697654086640D00D7EAB280D44C0');
  