<filename>oracle-scripts/New Zealand.sql<gh_stars>1-10
INSERT INTO WWS_COUNTRIES (ID, NAME, ISO3, ISO2, PHONECODE, CAPITAL, CURRENCY, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (158, 'New Zealand', 'NZL', 'NZ', '64', 'Wellington', 'NZD', TO_TIMESTAMP('2018-07-20 16:41:03','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-08-02 21:38:23','YYYY-MM-DD HH24:MI:SS'), 1, 'Q664');



INSERT ALL
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4059, 'Northland Region', 158, 'NZ', 'F6', 'NTL', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q59596')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4060, 'Manawatu-Wanganui Region', 158, 'NZ', 'F3', 'MWT', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q139907')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4061, 'Waikato Region', 158, 'NZ', 'G1', 'WKO', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q139918')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4062, 'Otago Region', 158, 'NZ', 'F7', 'OTA', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q692912')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4063, 'Marlborough Region', 158, 'NZ', 'F4', 'MBH', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q140083')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4064, 'West Coast Region', 158, 'NZ', 'G3', 'WTC', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q541468')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4065, 'Wellington Region', 158, 'NZ', 'G2', 'WGN', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q856010')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4066, 'Canterbury Region', 158, 'NZ', 'E9', 'CAN', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q657004')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4067, 'Chatham Islands', 158, 'NZ', '10', 'CIT', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q26882619')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4068, 'Gisborne District', 158, 'NZ', 'F1', 'GIS', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q140246')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4069, 'Taranaki Region', 158, 'NZ', 'F9', 'TKI', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q140207')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4070, 'Nelson Region', 158, 'NZ', 'F5', 'NSN', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q1995856')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4071, 'Southland Region', 158, 'NZ', 'F8', 'STL', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q864971')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4072, 'Auckland Region', 158, 'NZ', 'E7', 'AUK', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q726917')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4073, 'Tasman District', 158, 'NZ', 'TAS', 'TAS', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q666142')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4074, 'Bay of Plenty Region', 158, 'NZ', 'E8', 'BOP', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q2192924')
  INTO WWS_STATES (ID, NAME, COUNTRY_ID, COUNTRY_CODE, FIPS_CODE, ISO2, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (4075, 'Hawke''s Bay Region', 158, 'NZ', 'F2', 'HKB', TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 14:18:57','YYYY-MM-DD HH24:MI:SS'),1, 'Q251825')
SELECT * FROM dual;


INSERT ALL
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79768, 'Ahipara', 4059, 'NTL', 158, 'NZ', -35.16667000, 173.16667000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q400269')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79769, 'Amberley', 4066, 'CAN', 158, 'NZ', -43.15589000, 172.72975000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q457210')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79770, 'Arrowtown', 4062, 'OTA', 158, 'NZ', -44.93837000, 168.81007000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q703016')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79771, 'Ashburton', 4066, 'CAN', 158, 'NZ', -43.89834000, 171.73011000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q724923')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79772, 'Ashburton District', 4066, 'CAN', 158, 'NZ', -43.90000000, 171.75000000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q15784197')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79773, 'Auckland', 4072, 'AUK', 158, 'NZ', -36.84853000, 174.76349000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q15784197')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79774, 'Balclutha', 4062, 'OTA', 158, 'NZ', -46.23389000, 169.75000000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q804717')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79775, 'Blenheim', 4063, 'MBH', 158, 'NZ', -41.51603000, 173.95280000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q883831')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79776, 'Bluff', 4071, 'STL', 158, 'NZ', -46.60000000, 168.33333000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q152028')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79777, 'Brightwater', 4073, 'TAS', 158, 'NZ', -41.38333000, 173.11667000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q915930')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79778, 'Brooklyn', 4065, 'WGN', 158, 'NZ', -41.30586000, 174.76257000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q4974716')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79779, 'Bulls', 4060, 'MWT', 158, 'NZ', -40.17487000, 175.38463000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q834869')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79780, 'Burnham', 4066, 'CAN', 158, 'NZ', -43.61667000, 172.31667000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q137105')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79781, 'Cambridge', 4061, 'WKO', 158, 'NZ', -37.87822000, 175.44020000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1028261')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79782, 'Castlepoint', 4065, 'WGN', 158, 'NZ', -40.90000000, 176.21667000, TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:15','YYYY-MM-DD HH24:MI:SS'), 1, 'Q5050567')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79783, 'Christchurch', 4066, 'CAN', 158, 'NZ', -43.53333000, 172.63333000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q79990')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79784, 'Christchurch City', 4066, 'CAN', 158, 'NZ', -43.64578000, 172.74586000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q32159699')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79785, 'Clutha District', 4062, 'OTA', 158, 'NZ', -46.03883000, 169.60617000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1103566')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79786, 'Coromandel', 4061, 'WKO', 158, 'NZ', -36.76110000, 175.49634000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1134464')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79787, 'Cromwell', 4062, 'OTA', 158, 'NZ', -45.03837000, 169.20008000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q973355')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79788, 'Darfield', 4066, 'CAN', 158, 'NZ', -43.48333000, 172.11667000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1165830')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79789, 'Dargaville', 4059, 'NTL', 158, 'NZ', -35.93333000, 173.88333000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1165830')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79790, 'Dunedin', 4062, 'OTA', 158, 'NZ', -45.87416000, 170.50361000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1165830')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79791, 'Edgecumbe', 4074, 'BOP', 158, 'NZ', -37.98333000, 176.83333000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q151981')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79792, 'Eltham', 4069, 'TKI', 158, 'NZ', -39.42917000, 174.30000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q378717')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79793, 'Far North District', 4059, 'NTL', 158, 'NZ', -35.03359000, 173.48841000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1365839')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79794, 'Foxton', 4060, 'MWT', 158, 'NZ', -40.46667000, 175.30000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q985095')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79795, 'Geraldine', 4066, 'CAN', 158, 'NZ', -44.09061000, 171.24458000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1002934')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79796, 'Gisborne', 4068, 'GIS', 158, 'NZ', -38.65333000, 178.00417000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q233467')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79797, 'Gore', 4071, 'STL', 158, 'NZ', -46.10282000, 168.94357000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q597409')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79798, 'Greymouth', 4064, 'WTC', 158, 'NZ', -42.46667000, 171.20000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q934790')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79799, 'Hamilton', 4061, 'WKO', 158, 'NZ', -37.78333000, 175.28333000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q200028')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79800, 'Hastings', 4075, 'HKB', 158, 'NZ', -39.63810000, 176.84918000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1015690')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79801, 'Hawera', 4069, 'TKI', 158, 'NZ', -39.59167000, 174.28333000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q998452')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79802, 'Hokitika', 4064, 'WTC', 158, 'NZ', -42.71667000, 170.96667000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1549557')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79803, 'Horowhenua District', 4060, 'MWT', 158, 'NZ', -40.57733000, 175.38071000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1232367')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79804, 'Invercargill', 4071, 'STL', 158, 'NZ', -46.40000000, 168.35000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q31805')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79805, 'Kaiapoi', 4066, 'CAN', 158, 'NZ', -43.37832000, 172.64013000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1013339')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79806, 'Kaipara District', 4059, 'NTL', 158, 'NZ', -35.99546000, 174.04688000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q163982')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79807, 'Kaitaia', 4059, 'NTL', 158, 'NZ', -35.11485000, 173.26366000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q257417')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79808, 'Kapiti Coast District', 4065, 'WGN', 158, 'NZ', -40.85682000, 175.14690000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1533839')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79809, 'Katikati', 4074, 'BOP', 158, 'NZ', -37.55000000, 175.91667000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q911377')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79810, 'Kawakawa', 4059, 'NTL', 158, 'NZ', -35.38333000, 174.06667000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1013579')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79811, 'Kawerau', 4074, 'BOP', 158, 'NZ', -38.10000000, 176.70000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1674085')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79812, 'Kelburn', 4065, 'WGN', 158, 'NZ', -41.28333000, 174.76667000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1674085')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79813, 'Kerikeri', 4059, 'NTL', 158, 'NZ', -35.22676000, 173.94739000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1185949')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79814, 'Khandallah', 4065, 'WGN', 158, 'NZ', -41.24500000, 174.79422000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1185949')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79815, 'Kingston', 4062, 'OTA', 158, 'NZ', -45.33288000, 168.71476000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q128090')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79816, 'Leeston', 4066, 'CAN', 158, 'NZ', -43.76667000, 172.30000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q985373')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79817, 'Levin', 4060, 'MWT', 158, 'NZ', -40.63333000, 175.27500000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q985373')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79818, 'Lincoln', 4066, 'CAN', 158, 'NZ', -43.65000000, 172.48333000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1186226')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79819, 'Lower Hutt', 4065, 'WGN', 158, 'NZ', -41.21667000, 174.91667000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1015681')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79820, 'Mackenzie District', 4066, 'CAN', 158, 'NZ', -43.93987000, 170.51913000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1760822')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79821, 'Maketu', 4074, 'BOP', 158, 'NZ', -37.76667000, 176.45000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1886343')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79822, 'Manawatu District', 4060, 'MWT', 158, 'NZ', -40.11979000, 175.67426000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q613305')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79823, 'Mangere', 4072, 'AUK', 158, 'NZ', -36.96807000, 174.79875000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q742714')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79824, 'Manukau City', 4072, 'AUK', 158, 'NZ', -36.99282000, 174.87986000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q986198')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79825, 'Mapua', 4073, 'TAS', 158, 'NZ', -41.25000000, 173.10000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1892126')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79826, 'Masterton', 4065, 'WGN', 158, 'NZ', -40.95972000, 175.65750000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1223916')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79827, 'Matamata', 4061, 'WKO', 158, 'NZ', -37.81060000, 175.76237000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q691739')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79828, 'Maungatapere', 4059, 'NTL', 158, 'NZ', -35.75000000, 174.20000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q691739')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79829, 'Methven', 4066, 'CAN', 158, 'NZ', -43.63333000, 171.65000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1925567')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79830, 'Milton', 4062, 'OTA', 158, 'NZ', -46.12083000, 169.96944000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q203424')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79831, 'Moerewa', 4059, 'NTL', 158, 'NZ', -35.38333000, 174.03333000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q952307')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79832, 'Motueka', 4073, 'TAS', 158, 'NZ', -41.13333000, 173.01667000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q489458')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79833, 'Muriwai Beach', 4072, 'AUK', 158, 'NZ', -36.81667000, 174.45000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q495500')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79834, 'Murrays Bay', 4072, 'AUK', 158, 'NZ', -36.72819000, 174.75019000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q495500')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79835, 'Murupara', 4074, 'BOP', 158, 'NZ', -38.46667000, 176.70000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q999066')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79836, 'Napier', 4075, 'HKB', 158, 'NZ', -39.49260000, 176.91233000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q203380')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79837, 'Nelson', 4070, 'NSN', 158, 'NZ', -41.27078000, 173.28404000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q206687')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79838, 'New Plymouth', 4069, 'TKI', 158, 'NZ', -39.06667000, 174.08333000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q212984')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79839, 'New Plymouth District', 4069, 'TKI', 158, 'NZ', -39.05865000, 174.10309000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q4846747')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79840, 'Ngaruawahia', 4061, 'WKO', 158, 'NZ', -37.66738000, 175.15554000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q771298')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79841, 'Ngatea', 4061, 'WKO', 158, 'NZ', -37.28333000, 175.50000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q513626')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79842, 'Ngunguru', 4059, 'NTL', 158, 'NZ', -35.61667000, 174.50000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q513626')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79843, 'North Shore', 4072, 'AUK', 158, 'NZ', -36.80000000, 174.75000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q868671')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79844, 'Oamaru', 4062, 'OTA', 158, 'NZ', -45.09758000, 170.97087000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q4782')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79845, 'Opotiki', 4074, 'BOP', 158, 'NZ', -38.00915000, 177.28706000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q953871')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79846, 'Opunake', 4069, 'TKI', 158, 'NZ', -39.45556000, 173.85833000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q995218')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79847, 'Otaki', 4065, 'WGN', 158, 'NZ', -40.75833000, 175.15000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q984998')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79848, 'Otorohanga', 4061, 'WKO', 158, 'NZ', -38.18333000, 175.20000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1936464')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79849, 'Oxford', 4066, 'CAN', 158, 'NZ', -43.30000000, 172.18333000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1936464')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79850, 'Paeroa', 4061, 'WKO', 158, 'NZ', -37.36667000, 175.66667000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q834005')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79851, 'Paihia', 4059, 'NTL', 158, 'NZ', -35.28067000, 174.09103000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q152017')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79852, 'Pakuranga', 4072, 'AUK', 158, 'NZ', -36.88333000, 174.91667000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q7126082')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79853, 'Palmerston North', 4060, 'MWT', 158, 'NZ', -40.35636000, 175.61113000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q212289')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79854, 'Papakura', 4072, 'AUK', 158, 'NZ', -37.06573000, 174.94393000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1014616')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79855, 'Papatowai', 4062, 'OTA', 158, 'NZ', -46.56069000, 169.47068000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q7615649')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79856, 'Parakai', 4072, 'AUK', 158, 'NZ', -36.65000000, 174.43333000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q7615649')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79857, 'Paraparaumu', 4065, 'WGN', 158, 'NZ', -40.91667000, 175.01667000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1115332')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79858, 'Patea', 4069, 'TKI', 158, 'NZ', -39.75833000, 174.48333000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q2056659')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79859, 'Petone', 4065, 'WGN', 158, 'NZ', -41.22827000, 174.87019000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q120070')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79860, 'Picton', 4063, 'MBH', 158, 'NZ', -41.29067000, 174.00801000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1362879')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79861, 'Pleas<NAME>', 4066, 'CAN', 158, 'NZ', -44.26667000, 171.13333000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1474784')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79862, 'Porirua', 4065, 'WGN', 158, 'NZ', -41.13333000, 174.85000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1015773')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79863, 'Portobello', 4062, 'OTA', 158, 'NZ', -45.85000000, 170.65000000, TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:16','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1322072')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79864, 'Prebbleton', 4066, 'CAN', 158, 'NZ', -43.58333000, 172.51667000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q176330')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79865, 'Pukekohe East', 4072, 'AUK', 158, 'NZ', -37.20000000, 174.95000000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q176330')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79866, 'Queenstown', 4062, 'OTA', 158, 'NZ', -45.03023000, 168.66271000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q613602')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79867, 'Raglan', 4061, 'WKO', 158, 'NZ', -37.80000000, 174.88333000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q984803')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79868, 'Rakaia', 4066, 'CAN', 158, 'NZ', -43.75000000, 172.01667000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1015735')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79869, 'Red Hill', 4072, 'AUK', 158, 'NZ', -37.05820000, 174.97019000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1015735')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79870, 'Richmond', 4073, 'TAS', 158, 'NZ', -41.33333000, 173.18333000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1208462')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79871, 'Riverton', 4071, 'STL', 158, 'NZ', -46.35000000, 168.01667000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q152152')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79872, 'Rolleston', 4066, 'CAN', 158, 'NZ', -43.58333000, 172.38333000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1099966')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79873, 'Rosebank', 4072, 'AUK', 158, 'NZ', -36.87495000, 174.66991000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1099966')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79874, 'Rothesay Bay', 4072, 'AUK', 158, 'NZ', -36.72602000, 174.74064000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q3941757')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79875, 'Rotorua', 4074, 'BOP', 158, 'NZ', -38.13874000, 176.24516000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q208948')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79876, 'Ruakaka', 4059, 'NTL', 158, 'NZ', -35.90818000, 174.45019000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q208948')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79877, 'Selwyn District', 4066, 'CAN', 158, 'NZ', -43.32226000, 171.87064000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1210763')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79878, 'South Taranaki District', 4069, 'TKI', 158, 'NZ', -39.52156000, 174.37160000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1972712')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79879, 'South Waikato District', 4061, 'WKO', 158, 'NZ', -38.16797000, 175.88624000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1760808')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79880, 'South Wairarapa District', 4065, 'WGN', 158, 'NZ', -41.26731000, 175.38442000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1760817')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79881, 'Southland District', 4071, 'STL', 158, 'NZ', -45.77256000, 167.85266000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1972706')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79882, 'Taipa', 4059, 'NTL', 158, 'NZ', -34.99604000, 173.46665000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1972706')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79883, 'Tairua', 4061, 'WKO', 158, 'NZ', -37.01667000, 175.85000000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q2388791')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79884, 'Takaka', 4073, 'TAS', 158, 'NZ', -40.85000000, 172.80000000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q151841')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79885, 'Takanini', 4072, 'AUK', 158, 'NZ', -37.04820000, 174.90019000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q151841')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79886, 'Tamaki', 4072, 'AUK', 158, 'NZ', -36.88820000, 174.86019000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q151841')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79887, 'Taradale', 4075, 'HKB', 158, 'NZ', -39.53333000, 176.85000000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q151841')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79888, 'Taupo', 4061, 'WKO', 158, 'NZ', -38.68333000, 176.08333000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q2397257')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79889, 'Tauranga', 4074, 'BOP', 158, 'NZ', -37.68611000, 176.16667000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q207756')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79890, '<NAME>', 4071, 'STL', 158, 'NZ', -45.41667000, 167.71667000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1154973')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79891, '<NAME>', 4061, 'WKO', 158, 'NZ', -37.40000000, 175.15000000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1526617')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79892, 'Thames', 4061, 'WKO', 158, 'NZ', -37.13832000, 175.54011000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1691479')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79893, 'Timaru', 4066, 'CAN', 158, 'NZ', -44.39672000, 171.25364000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1016574')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79894, 'Timaru District', 4066, 'CAN', 158, 'NZ', -44.40000000, 171.21667000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q14395599')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79895, 'Tinwald', 4066, 'CAN', 158, 'NZ', -43.91667000, 171.71667000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q14395599')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79896, 'Titirangi', 4072, 'AUK', 158, 'NZ', -36.93754000, 174.65584000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q6517338')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79897, 'Tokoroa', 4061, 'WKO', 158, 'NZ', -38.23333000, 175.86667000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q112685')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79898, 'Turangi', 4061, 'WKO', 158, 'NZ', -38.99037000, 175.80837000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1026386')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79899, 'Upper Hutt', 4065, 'WGN', 158, 'NZ', -41.13827000, 175.05020000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q166002')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79900, 'Waihi', 4061, 'WKO', 158, 'NZ', -37.38333000, 175.83333000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q498833')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79901, 'Waihi Beach', 4074, 'BOP', 158, 'NZ', -37.40000000, 175.93333000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1520662')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79902, 'Waimakariri District', 4066, 'CAN', 158, 'NZ', -43.20750000, 172.33286000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1542322')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79903, 'Waimate North', 4059, 'NTL', 158, 'NZ', -35.31667000, 173.88333000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1542322')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79904, 'Waiouru', 4060, 'MWT', 158, 'NZ', -39.47753000, 175.66834000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q912379')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79905, 'Waipawa', 4065, 'WGN', 158, 'NZ', -41.41222000, 175.51528000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q912379')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79906, 'Wairoa', 4075, 'HKB', 158, 'NZ', -39.03333000, 177.36667000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q599594')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79907, 'Waitakere', 4072, 'AUK', 158, 'NZ', -36.91754000, 174.65773000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q782760')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79908, 'Waitangi', 4067, 'CIT', 158, 'NZ', -43.95353000, -176.55973000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1809774')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79909, 'Waitara', 4069, 'TKI', 158, 'NZ', -39.00158000, 174.23836000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q727199')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79910, 'Waiuku', 4072, 'AUK', 158, 'NZ', -37.24806000, 174.73489000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q584671')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79911, 'Wakefield', 4073, 'TAS', 158, 'NZ', -41.40000000, 173.05000000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q683323')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79912, 'Wanaka', 4062, 'OTA', 158, 'NZ', -44.70000000, 169.15000000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q930344')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79913, 'Wanganui', 4060, 'MWT', 158, 'NZ', -39.93333000, 175.05000000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1015672')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79914, 'Warkworth', 4072, 'AUK', 158, 'NZ', -36.40000000, 174.66667000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q590475')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79915, 'Wellington', 4065, 'WGN', 158, 'NZ', -41.28664000, 174.77557000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q23661')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79916, 'Wellington City', 4065, 'WGN', 158, 'NZ', -41.25300000, 174.75424000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q47037646')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79917, 'Wellsford', 4072, 'AUK', 158, 'NZ', -36.28333000, 174.51667000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q618344')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79918, 'Westport', 4064, 'WTC', 158, 'NZ', -41.75262000, 171.60370000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1349217')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79919, 'Whakatane', 4074, 'BOP', 158, 'NZ', -37.95855000, 176.98545000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q974074')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79920, 'Whangamata', 4061, 'WKO', 158, 'NZ', -37.20000000, 175.86667000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q917136')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79921, 'Whangarei', 4059, 'NTL', 158, 'NZ', -35.73167000, 174.32391000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q744239')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79922, 'Whitianga', 4061, 'WKO', 158, 'NZ', -36.83333000, 175.70000000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1375183')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79923, 'Winton', 4071, 'STL', 158, 'NZ', -46.15000000, 168.33333000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1721802')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79924, 'Wiri', 4072, 'AUK', 158, 'NZ', -36.99820000, 174.86019000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q1721802')
  INTO WWS_CITIES (ID, NAME, STATE_ID, STATE_CODE, COUNTRY_ID, COUNTRY_CODE, LATITUDE, LONGITUDE, CREATED_AT, UPDATED_AT, FLAG, WIKIDATAID) VALUES (79925, 'Woodend', 4066, 'CAN', 158, 'NZ', -43.31667000, 172.66667000, TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), TO_TIMESTAMP('2019-10-05 15:42:17','YYYY-MM-DD HH24:MI:SS'), 1, 'Q8032610')
SELECT * FROM dual;